Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/AMS00201
Product: MIS-AMS Extensions (3459)
Series: Purchasing
Display Name: AMS Job MSTR
Physical Name: AMS00201
Technical Name: AMS_Job_MSTRSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 AMS_Job_ID 
AMS Job ID Long Int Long Integer 8 2 AMS_Job_Reference AMS Job Reference STR20 String 20 3 AMS_Job_Description AMS Job Description AMS_STR255 String 255 4 VENDORID Vendor ID STR_15_Vendor_ID String 15 Key to the PM Vendor Master File (PM00200).
Click to show/hide
SELECT
['AMS Job MSTR'].VENDORID AS 'AMS Job MSTR-Vendor ID'
,['PM Vendor Master File'].VENDORID AS 'PM Vendor Master File-Vendor ID'
FROM
AMS00201 AS ['AMS Job MSTR']
INNER JOIN
PM00200 AS ['PM Vendor Master File']
ON
['AMS Job MSTR'].VENDORID = ['PM Vendor Master File'].VENDORID5 AMS_WO_Status AMS WO Status INT Integer 0 6 AMS_WO_Status_Date AMS WO Status Date DATE_LONG Date 8