Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/AMS00200
Product: MIS-AMS Extensions (3459)
Series: Purchasing
Display Name: AMS Vendor MSTR
Physical Name: AMS00200
Technical Name: AMS_Vendor_MSTRSeq 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
['AMS Vendor MSTR'].VENDORID AS 'AMS Vendor MSTR-Vendor ID'
,['PM Vendor Master File'].VENDORID AS 'PM Vendor Master File-Vendor ID'
FROM
AMS00200 AS ['AMS Vendor MSTR']
INNER JOIN
PM00200 AS ['PM Vendor Master File']
ON
['AMS Vendor MSTR'].VENDORID = ['PM Vendor Master File'].VENDORID2 AMSCONID AMS Contractor Supplier ID long Long Integer 8 3 AMSREPID AMS Repairs Contractor ID long Long Integer 8 4 AMS_Sub_Contractor_ID AMS Contractors Sub Contractor ID long Long Integer 8