Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/CAM10200
Product: Control Account Management (2416)
Series:
Display Name: CAM Summary Header
Physical Name: CAM10200
Technical Name: CAM_Summary_HDRSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 CAMAccountType 
CAM_Account_Type Integer DDL_CAM_Account_Type 0 2 DATE1 Date Date DT6 6 3 TIME1 Time Time TM6 6 4 CMPANYID Company ID Integer INT5 4 Key to the Company Master (SY01500).
Click to show/hide
SELECT
['CAM Summary Header'].CMPANYID AS 'CAM Summary Header-Company ID'
,['Company Master'].CMPANYID AS 'Company Master-Company ID'
FROM
CAM10200 AS ['CAM Summary Header']
INNER JOIN
DYNAMICS..SY01500 AS ['Company Master']
ON
['CAM Summary Header'].CMPANYID = ['Company Master'].CMPANYID5 CAM_Series CAM_Series Integer CAM_DDL_Series 0 6 SGMTNUMB Segment Number Integer INT2 2 7 USERID User ID String STR15_User_ID 15 Key to the Users Master (SY01400).
Click to show/hide
SELECT
['CAM Summary Header'].USERID AS 'CAM Summary Header-User ID'
,['Users Master'].USERID AS 'Users Master-User ID'
FROM
CAM10200 AS ['CAM Summary Header']
INNER JOIN
DYNAMICS..SY01400 AS ['Users Master']
ON
['CAM Summary Header'].USERID = ['Users Master'].USERID8 CAM_Amount_Total CAM Amount Total Currency DLR19_$S2 19 9 CAM_CntrlCount_1 CAM_CntrlCount[1] Integer INT 0 10 CAM_CntrlCount CAM_CntrlCount INT Integer 0 11 CAM_CntrlCount_2 CAM_CntrlCount[2] Integer INT 0 12 CAM_DistCount CAM_DistCount INT Integer 0 13 CAM_DistCount_1 CAM_DistCount[1] Integer INT 0 14 CAM_DocCount CAM_DocCount INT Integer 0 15 CAM_DistCount_2 CAM_DistCount[2] Integer INT 0 16 CAM_DistCount_3 CAM_DistCount[3] Integer INT 0 17 CAM_DistCount_4 CAM_DistCount[4] Integer INT 0 18 CAM_DistCount_5 CAM_DistCount[5] Integer INT 0 19 CAM_DistCount_6 CAM_DistCount[6] Integer INT 0 20 CAM_DistCount_7 CAM_DistCount[7] Integer INT 0 21 CAM_DistCount_8 CAM_DistCount[8] Integer INT 0 22 CAM_DistCount_9 CAM_DistCount[9] Integer INT 0 23 CAM_DistCount_10 CAM_DistCount[10] Integer INT 0 24 CAM_DistCount_11 CAM_DistCount[11] Integer INT 0 25 CAM_DistCount_12 CAM_DistCount[12] Integer INT 0 26 CAM_DistCount_13 CAM_DistCount[13] Integer INT 0 27 CAM_DistCount_14 CAM_DistCount[14] Integer INT 0 28 CAM_DistCount_15 CAM_DistCount[15] Integer INT 0 29 CAM_DistCount_16 CAM_DistCount[16] Integer INT 0 30 CAM_DocCount_1 CAM_DocCount[1] Integer INT 0 31 CAM_DocCount_2 CAM_DocCount[2] Integer INT 0 32 CAM_DocCount_3 CAM_DocCount[3] Integer INT 0 33 CAM_DocCount_4 CAM_DocCount[4] Integer INT 0 34 CAM_DocCount_5 CAM_DocCount[5] Integer INT 0 35 CAM_DocCount_6 CAM_DocCount[6] Integer INT 0 36 CAM_DocCount_7 CAM_DocCount[7] Integer INT 0 37 BACHNUMB Batch Number String STR15_LBAU 15 38 BCHCOMNT Batch Comment String STR60 60 39 REFRENCE Reference String STR30 30 40 SOURCDOC Source Document String STR10_Source_Document 10 Key to the Source Document Master (SY00900).
Click to show/hide
SELECT
['CAM Summary Header'].SOURCDOC AS 'CAM Summary Header-Source Document'
,['Source Document Master'].SOURCDOC AS 'Source Document Master-Source Document'
FROM
CAM10200 AS ['CAM Summary Header']
INNER JOIN
SY00900 AS ['Source Document Master']
ON
['CAM Summary Header'].SOURCDOC = ['Source Document Master'].SOURCDOC41 TRXSRCPX Transaction Source Prefix String Transaction Source Prefix 5 42 TRXDATE TRX Date Date DT_Date 6 43 RVRSNGDT Reversing Date Date DT_Date 6 44 CAM_Status CAM_Status Integer CAM_StatusTpe 0