Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/AMS00402
Product: MIS-AMS Extensions (3459)
Series: Purchasing
Display Name: AMS POP Transaction Job Control
Physical Name: AMS00402
Technical Name: AMS_POP_Transaction_Job_ControlSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 POPRCTNM 
POP Receipt Number STR17_POP_Number String 17 2 SEQNUMBR Sequence Number LI_Sequence_Number Long Integer 10 3 AMS_Job_ID AMS Job ID Long Int Long Integer 8 4 AMS_Contractors_Started AMS Contractors Started Boolean Boolean 0 5 AMS_Contractors_Finished AMS Contractors Finished Boolean Boolean 0 6 AMS_Dist_Line_Desc AMS Distribution Line Description AMS_STR255 String 255 7 AMS_WO_ID AMS WO ID Long Int Long Integer 8 8 VENDORID Vendor ID STR_15_Vendor_ID String 15 Key to the PM Vendor Master File (PM00200).
Click to show/hide
SELECT
['AMS POP Transaction Job Control'].VENDORID AS 'AMS POP Transaction Job Control-Vendor ID'
,['PM Vendor Master File'].VENDORID AS 'PM Vendor Master File-Vendor ID'
FROM
AMS00402 AS ['AMS POP Transaction Job Control']
INNER JOIN
PM00200 AS ['PM Vendor Master File']
ON
['AMS POP Transaction Job Control'].VENDORID = ['PM Vendor Master File'].VENDORID