I gave up too soon. found them in a tip from epicweb.
Page 13505mps
PROBLEM DESCRIPTION:
In the Supplier Price List on the Parts tab > Detail tab, there is a checkbox titled Approved Supplier. What table and field stores this information to notify in a query/export whether or not it is checked? Same with the Primary Supplier checkbox.
VERSION: 9.04.507a
PROBLEM RESOLUTION:
A query / report would have to be created that would link the AprvVend table with the related tables VendPart and VendPbrk that store related Supplier Price List information. Should be able to link them thru the PartNum and VendorNum fields.
The Primary Supplier is stored in the PartPlant tab > VendorNum fields. Link this table back to the Vendor table using this VendorNum field to obtain futher Supplier information such as Name, VendorID, Address, Terms, etc
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
On Behalf Of Greg Payne
Sent: Friday, April 25, 2014 2:24 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Supplier Price List Fields
Can anyone tell me where Approved Supplier and Primary Supplier from the Supplier Price List entry screen are stored. They are in the PartVend View and PartVend dataset, but not the PartVend table.
I looked in PatchFld, but not there either.
Thanks
Greg Payne
CONFIDENTIALITY NOTICE
The information contained in this communication, including attachments, is privileged and confidential. It is intended only for the exclusive use of the addressee. If the reader of this message is not the intended recipient, or the employee or agent responsible
for delivering it to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify us at 727-578-6280 and immediately
delete the communication.
"This (document/presentation) may contain technical data as defined in the International Traffic In Arms Regulations (ITAR) 22 CFR 120.10. Export of this material is restricted by the Arms Export Control Act (22 U.S.C. 2751 et seq.) and may not be exported
to foreign persons without prior approval form the U.S. Department of State."
CONFIDENTIALITY NOTICE
The information contained in this communication, including attachments, is privileged and confidential. It is intended only for the exclusive use of the addressee. If the reader of this message is not the intended recipient, or the employee or agent responsible for delivering it to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify us at 727-578-6280 and immediately delete the communication.
"This (document/presentation) may contain technical data as defined in the International Traffic In Arms Regulations (ITAR) 22 CFR 120.10. Export of this material is restricted by the Arms Export Control Act (22 U.S.C. 2751 et seq.) and may not be exported to foreign persons without prior approval form the U.S. Department of State."