Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/AMS00401
Product: MIS-AMS Extensions (3459)
Series: Purchasing
Display Name: AMS PM Transaction Job Control
Physical Name: AMS00401
Technical Name: AMS_PM_Transaction_Job_ControlSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 DOCTYPE 
Document Type DDL_Document_Type Integer 0 Click to show/hide Document Types
1 Invoice
2 Finance Charge
3 Miscellaneous Charges
4 Return
5 Credit Memo2 VCHRNMBR Voucher Number STR20_LBAU String 20 Partial key to the PM Key Master File (PM00400).
Click to show/hide
SELECT
['AMS PM Transaction Job Control'].VCHRNMBR AS 'AMS PM Transaction Job Control-Voucher Number'
,['PM Key Master File'].CNTRLNUM AS 'PM Key Master File-Control Number'
FROM
AMS00401 AS ['AMS PM Transaction Job Control']
INNER JOIN
PM00400 AS ['PM Key Master File']
ON
['AMS PM Transaction Job Control'].VCHRNMBR = ['PM Key Master File'].CNTRLNUM
AND
['AMS PM Transaction Job Control'].DOCTYPE = ['PM Key Master File'].DOCTYPE3 DSTSQNUM Distribution Sequence Number Long Int Long Integer 8 4 AMS_Job_ID AMS Job ID Long Int Long Integer 8 5 AMS_Contractors_Started AMS Contractors Started Boolean Boolean 0 6 AMS_Contractors_Finished AMS Contractors Finished Boolean Boolean 0 7 AMS_Dist_Line_Desc AMS Distribution Line Description AMS_STR255 String 255 8 AMS_Job_Description AMS Job Description AMS_STR255 String 255 9 AME_Awaiting_Auth AME Awaiting Authorisation Boolean Boolean 0 10 AMS_WO_ID AMS WO ID Long Int Long Integer 8 11 AMS_Repairs_Started AMS Repairs Started Boolean Boolean 0 12 AMS_Repairs_Finished AMS Repairs Finished Boolean Boolean 0 13 AMS_WO_Description AMS WO Description AMS_STR255 String 255 14 AME_User_Who_Authorised AME User Who Authorised STR15_User_ID String 15 15 AME_Date_Authorised AME Date Authorised DT Date 8 16 AME_Time_Authorised AME Time Authorised TM6 Time 6 17 VENDORID Vendor ID STR_15_Vendor_ID String 15 Key to the PM Vendor Master File (PM00200).
Click to show/hide
SELECT
['AMS PM Transaction Job Control'].VENDORID AS 'AMS PM Transaction Job Control-Vendor ID'
,['PM Vendor Master File'].VENDORID AS 'PM Vendor Master File-Vendor ID'
FROM
AMS00401 AS ['AMS PM Transaction Job Control']
INNER JOIN
PM00200 AS ['PM Vendor Master File']
ON
['AMS PM Transaction Job Control'].VENDORID = ['PM Vendor Master File'].VENDORID