Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/CAM10000
Product: Control Account Management (2416)
Series:
Display Name: CAM Transaction Work
Physical Name: CAM10000
Technical Name: CAM_Transaction_WORKSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 DATE1 
Date Date DT6 6 2 TIME1 Time Time TM6 6 3 VCHRNMBR Voucher Number String STR20_LBAU 20 4 DOCTYPE Document Type Integer DDL_Document_Type 0 5 CNTRLTYP Control Type Integer INT1 1 6 VENDORID Vendor ID String STR_15_Vendor_ID 15 Key to the PM Vendor Master File (PM00200).
Click to show/hide
SELECT
['CAM Transaction Work'].VENDORID AS 'CAM Transaction Work-Vendor ID'
,['PM Vendor Master File'].VENDORID AS 'PM Vendor Master File-Vendor ID'
FROM
CAM10000 AS ['CAM Transaction Work']
INNER JOIN
PM00200 AS ['PM Vendor Master File']
ON
['CAM Transaction Work'].VENDORID = ['PM Vendor Master File'].VENDORID7 CAM_Amount_Total CAM Amount Total Currency DLR19_$S2 19 8 CAM_Amount_Owing CAM Amount Owing Currency DLR19_$S2 19