Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/CAM40004
Product: Control Account Management (2416)
Series:
Display Name: CAM_AcctTypesData
Physical Name: CAM40004
Technical Name: CAM_AcctTypesDataSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 REFRENCE 
Reference String STR30 30 2 SOURCDOC Source Document String STR10_Source_Document 10 Key to the Source Document Master (SY00900).
Click to show/hide
SELECT
['CAM_AcctTypesData'].SOURCDOC AS 'CAM_AcctTypesData-Source Document'
,['Source Document Master'].SOURCDOC AS 'Source Document Master-Source Document'
FROM
CAM40004 AS ['CAM_AcctTypesData']
INNER JOIN
SY00900 AS ['Source Document Master']
ON
['CAM_AcctTypesData'].SOURCDOC = ['Source Document Master'].SOURCDOC3 CAMAccountType CAM_Account_Type Integer DDL_CAM_Account_Type 0 4 BCHCOMNT Batch Comment String STR60 60 5 BACHNUMB Batch Number String STR15_LBAU 15