I have a large number of suppliers that all assign me a different customer number. Does anyone know how/where I can record this information? I need to include the number on things like my purchase orders.

The obvious place for such an attribute is with the "party_relationship" (although since this could conceivably be multi-valued, a new table ala "employment" would be better).

A short-term hack would be to simply store the information as a "party_attr". For example, if my customer number with supplier XYZ is 1234, store (XYZ, 123) as a name-value pair in party_attr.

Have I missed something more obvious, like the correct place to record assigned customer numbers?

Cheers, Iain


--
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.409 / Virus Database: 268.14.6/535 - Release Date: 15/11/2006

Reply via email to