While the agreement entities may make for a simple integration with your recent improvements, IMO it's not an accurate representation of the data field. In the business sense, a customer Id is a party alias and can be assigned without the presence or utilization of an agreement. This may seem like a minor distinction, however because agreements are by their nature subject to one time frame and your customer Id is not subject to the same time frame, you would need to be maintaining a separate agreement solely for the purpose of keeping track of your customer Id otherwise risk expiring information that does not expire.
--- Jacopo Cappellato <[EMAIL PROTECTED]> wrote: > Iain, > > I'd suggest considering the Agreement/AgreementTerm > entities: you create > an agreement between your company and the supplier, > then add a new term > to specify the assigned id; when you start a > purchase order and select > this agreement, the agreement term will be > automatically added to the > cart/order/documents. > > Jacopo > > PS: IMO in general, for the future, we should > consider to move > information to the Agreement data model: for > example, with a concept of > a default agreement for sales orders, some of the > fields in the product > store could be moved in the agreement etc... > > > Iain Fogg wrote: > > 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 > > > > > >
