CAM Summary Header (CAM10200)

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_HDR

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1CAMAccountType SearchCAM_Account_TypeIntegerDDL_CAM_Account_Type0
2DATE1 SearchDateDateDT66
3TIME1 SearchTimeTimeTM66
4CMPANYID SearchCompany IDIntegerINT54
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'].CMPANYID
5CAM_Series SearchCAM_SeriesIntegerCAM_DDL_Series0
6SGMTNUMB SearchSegment NumberIntegerINT22
7USERID SearchUser IDStringSTR15_User_ID15
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'].USERID
8CAM_Amount_Total SearchCAM Amount TotalCurrencyDLR19_$S219
9CAM_CntrlCount_1 SearchCAM_CntrlCount[1]IntegerINT0
10CAM_CntrlCount SearchCAM_CntrlCountINTInteger0
11CAM_DistCount SearchCAM_DistCountINTInteger0
12CAM_CntrlCount_2 SearchCAM_CntrlCount[2]IntegerINT0
13CAM_DocCount SearchCAM_DocCountINTInteger0
14CAM_DistCount_1 SearchCAM_DistCount[1]IntegerINT0
15CAM_DistCount_2 SearchCAM_DistCount[2]IntegerINT0
16CAM_DistCount_3 SearchCAM_DistCount[3]IntegerINT0
17CAM_DistCount_4 SearchCAM_DistCount[4]IntegerINT0
18CAM_DistCount_5 SearchCAM_DistCount[5]IntegerINT0
19CAM_DistCount_6 SearchCAM_DistCount[6]IntegerINT0
20CAM_DistCount_7 SearchCAM_DistCount[7]IntegerINT0
21CAM_DistCount_8 SearchCAM_DistCount[8]IntegerINT0
22CAM_DistCount_9 SearchCAM_DistCount[9]IntegerINT0
23CAM_DistCount_10 SearchCAM_DistCount[10]IntegerINT0
24CAM_DistCount_11 SearchCAM_DistCount[11]IntegerINT0
25CAM_DistCount_12 SearchCAM_DistCount[12]IntegerINT0
26CAM_DistCount_13 SearchCAM_DistCount[13]IntegerINT0
27CAM_DistCount_14 SearchCAM_DistCount[14]IntegerINT0
28CAM_DistCount_15 SearchCAM_DistCount[15]IntegerINT0
29CAM_DistCount_16 SearchCAM_DistCount[16]IntegerINT0
30CAM_DocCount_1 SearchCAM_DocCount[1]IntegerINT0
31CAM_DocCount_2 SearchCAM_DocCount[2]IntegerINT0
32CAM_DocCount_3 SearchCAM_DocCount[3]IntegerINT0
33CAM_DocCount_4 SearchCAM_DocCount[4]IntegerINT0
34CAM_DocCount_5 SearchCAM_DocCount[5]IntegerINT0
35CAM_DocCount_6 SearchCAM_DocCount[6]IntegerINT0
36CAM_DocCount_7 SearchCAM_DocCount[7]IntegerINT0
37BACHNUMB SearchBatch NumberStringSTR15_LBAU15
38BCHCOMNT SearchBatch CommentStringSTR6060
39REFRENCE SearchReferenceStringSTR3030
40SOURCDOC SearchSource DocumentStringSTR10_Source_Document10
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'].SOURCDOC
41TRXSRCPX SearchTransaction Source PrefixStringTransaction Source Prefix5
42TRXDATE SearchTRX DateDateDT_Date6
43RVRSNGDT SearchReversing DateDateDT_Date6
44CAM_Status SearchCAM_StatusIntegerCAM_StatusTpe0

Leave a Reply

Your email address will not be published. Required fields are marked *