Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/paSelVendor
Product: Company Archive (1755)
Series: Company
Display Name: PA - Selected Vendors
Physical Name: paSelVendor
Technical Name: paSelectedVendorsSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 VENDORID 
Vendor ID STR_15_Vendor_ID String 15 Key to the PM Vendor Master File (PM00200).
Click to show/hide
SELECT
['PA - Selected Vendors'].VENDORID AS 'PA - Selected Vendors-Vendor ID'
,['PM Vendor Master File'].VENDORID AS 'PM Vendor Master File-Vendor ID'
FROM
paSelVendor AS ['PA - Selected Vendors']
INNER JOIN
PM00200 AS ['PM Vendor Master File']
ON
['PA - Selected Vendors'].VENDORID = ['PM Vendor Master File'].VENDORID2 VENDNAME Vendor Name STR64_Vendor_Name String 64 3 MKTOPROC Marked To Process CB Boolean 0 4 VNDCLSID Vendor Class ID STR10_Class_ID String 10 Key to the PM Class Master File (PM00100).
Click to show/hide
SELECT
['PA - Selected Vendors'].VNDCLSID AS 'PA - Selected Vendors-Vendor Class ID'
,['PM Class Master File'].VNDCLSID AS 'PM Class Master File-Vendor Class ID'
FROM
paSelVendor AS ['PA - Selected Vendors']
INNER JOIN
PM00100 AS ['PM Class Master File']
ON
['PA - Selected Vendors'].VNDCLSID = ['PM Class Master File'].VNDCLSID