Adrian I agree. There are many businesses where you buy items from a wholesaler that are essentially identical except that they are manufactured by different companies. Plumbing supplies, lumber and machine tools come to mind. The wholesaler is the supplier. However, customers freqently request items made by a particular manufacturer that they have had success with in the past, hence the need to identify that attribute.
Skip -----Original Message----- From: Adrian Crum [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 29, 2008 10:46 AM To: [email protected] Subject: Re: Product - Manufacturer Party Id question BJ, Sometimes it matters who manufactures a product. We keep track of that here. Suppliers can carry more than one manfacturer. Purchasing decisions can be based on manufacturer. If you do a search of the mailing lists, you'll find where I've given example scenarios in the past. -Adrian BJ Freeman wrote: > Not sure that a manufacture party is any different from a SupplierID. > how someone has product to sell you is not important, as they can sell > it to you. > unless I am missing something. > > Ritz123 sent the following on 1/28/2008 3:09 PM: > >>Hi, >> >>How do you create a party as a manufacturer, if you wanted to associate this >>manufacturer party with the MANUFACTURER_PARTY_ID column of the PRODUCT >>table? >> >>I looked at PARTY_ROLE, ROLE_TYPE, PARTY_TYPE tables - couldnt find a role >>or a type which is either manufacturer or OEM. What am I missing? > > > No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.5.516 / Virus Database: 269.19.11/1244 - Release Date: 1/25/2008 7:44 PM No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.5.516 / Virus Database: 269.19.11/1244 - Release Date: 1/25/2008 7:44 PM
