Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/CAM10100
Product: Control Account Management (2416)
Series:
Display Name: CAM Distribution Work
Physical Name: CAM10100
Technical Name: CAM_Distribution_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 CAM_ControlAccountIndex CAM_ControlAccountIndex Long Integer LI_14 14 4 CAM_Account_Num_String CAM Account Number String String STR128_LBU 128 5 CAM_ControlAcctDescr CAM_ControlAcctDescription String STR32 32 6 VENDORID Vendor ID String STR_15_Vendor_ID 15 Key to the PM Vendor Master File (PM00200).
Click to show/hide
SELECT
['CAM Distribution Work'].VENDORID AS 'CAM Distribution Work-Vendor ID'
,['PM Vendor Master File'].VENDORID AS 'PM Vendor Master File-Vendor ID'
FROM
CAM10100 AS ['CAM Distribution Work']
INNER JOIN
PM00200 AS ['PM Vendor Master File']
ON
['CAM Distribution Work'].VENDORID = ['PM Vendor Master File'].VENDORID7 ACTINDX Account Index Long Integer LI_14 14 Key to the Account Index Master (GL00105).
Click to show/hide
SELECT
['CAM Distribution Work'].ACTINDX AS 'CAM Distribution Work-Account Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
CAM10100 AS ['CAM Distribution Work']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['CAM Distribution Work'].ACTINDX = ['Account Index Master'].ACTINDX8 ACTNUMST Account Number String String STR128_LBU 128 9 ACTDESCR Account Description String STR50 50 10 VCHRNMBR Voucher Number String STR20_LBAU 20 11 APTVCHNM Apply To Voucher Number String STR20_LBAU 20 12 DEBITAMT Debit Amount Currency DLR19_$S2 19 13 CRDTAMNT Credit Amount Currency DLR19_$S2 19 14 CAM_Amount_Total CAM Amount Total Currency DLR19_$S2 19 15 DISTTYPE Distribution Type Integer DDL 0 16 SEQNUMBR Sequence Number Long Integer LI_Sequence_Number 10