Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/CAM40001
Product: Control Account Management (2416)
Series:
Display Name: CAM_Setup
Physical Name: CAM40001
Technical Name: CAM_SetupSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 SGMTNUMB 
Segment Number Integer INT2 2 2 CAM_Series CAM_Series Integer CAM_DDL_Series 0 3 CAMActivated CAM_Activated Boolean CAM_Activated 0 4 CAM_Distribution_Created CAM_DistributionCreated Boolean CAM_DistributionCreated 0 5 CAM_Posted CAM_Posted Boolean CAM_Posted 0 6 BACHNUMB Batch Number String STR15_LBAU 15 7 BCHCOMNT Batch Comment String STR60 60 8 REFRENCE Reference String STR30 30 9 TRXSRCPX Transaction Source Prefix String Transaction Source Prefix 5 10 SOURCDOC Source Document String STR10_Source_Document 10 Key to the Source Document Master (SY00900).
Click to show/hide
SELECT
['CAM_Setup'].SOURCDOC AS 'CAM_Setup-Source Document'
,['Source Document Master'].SOURCDOC AS 'Source Document Master-Source Document'
FROM
CAM40001 AS ['CAM_Setup']
INNER JOIN
SY00900 AS ['Source Document Master']
ON
['CAM_Setup'].SOURCDOC = ['Source Document Master'].SOURCDOC11 NOTEINDX Note Index Currency DLR14 14 Key to the Record Notes Master (SY03900).
Click to show/hide
SELECT
['CAM_Setup'].NOTEINDX AS 'CAM_Setup-Note Index'
,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
CAM40001 AS ['CAM_Setup']
INNER JOIN
SY03900 AS ['Record Notes Master']
ON
['CAM_Setup'].NOTEINDX = ['Record Notes Master'].NOTEINDX