CAM Summary Header (CAM10200)

Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/CAM10200

Product: Control Account Management (2416)
Series: Company

Display Name: CAM Summary Header
Physical Name: CAM10200
Technical Name: CAM_Summary_HDR

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1CAMAccountType SearchCAM_Account_TypeDDL_CAM_Account_TypeInteger0
2DATE1 SearchDateDT6Date6
3TIME1 SearchTimeTM6Time6
4CMPANYID SearchCompany IDINT5Integer4
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_SeriesCAM_DDL_SeriesInteger0
6SGMTNUMB SearchSegment NumberINT2Integer2
7USERID SearchUser IDSTR15_User_IDString15
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 TotalDLR19_$S2Currency19
9CAM_CntrlCount_1 SearchCAM_CntrlCount[1]INTInteger0
10CAM_CntrlCount SearchCAM_CntrlCountINTInteger0
11CAM_CntrlCount_2 SearchCAM_CntrlCount[2]INTInteger0
12CAM_DistCount SearchCAM_DistCountINTInteger0
13CAM_DistCount_1 SearchCAM_DistCount[1]INTInteger0
14CAM_DocCount SearchCAM_DocCountINTInteger0
15BACHNUMB SearchBatch NumberSTR15_LBAUString15
16CAM_DistCount_2 SearchCAM_DistCount[2]INTInteger0
17BCHCOMNT SearchBatch CommentSTR60String60
18CAM_DistCount_3 SearchCAM_DistCount[3]INTInteger0
19REFRENCE SearchReferenceSTR30String30
20CAM_DistCount_4 SearchCAM_DistCount[4]INTInteger0
21CAM_DistCount_5 SearchCAM_DistCount[5]INTInteger0
22SOURCDOC SearchSource DocumentSTR10_Source_DocumentString10
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
23TRXSRCPX SearchTransaction Source PrefixTransaction Source PrefixString5
24CAM_DistCount_6 SearchCAM_DistCount[6]INTInteger0
25TRXDATE SearchTRX DateDT_DateDate6
26CAM_DistCount_7 SearchCAM_DistCount[7]INTInteger0
27RVRSNGDT SearchReversing DateDT_DateDate6
28CAM_DistCount_8 SearchCAM_DistCount[8]INTInteger0
29CAM_DistCount_9 SearchCAM_DistCount[9]INTInteger0
30CAM_Status SearchCAM_StatusCAM_StatusTpeInteger0
31CAM_DistCount_10 SearchCAM_DistCount[10]INTInteger0
32CAM_DistCount_11 SearchCAM_DistCount[11]INTInteger0
33CAM_DistCount_12 SearchCAM_DistCount[12]INTInteger0
34CAM_DistCount_13 SearchCAM_DistCount[13]INTInteger0
35CAM_DistCount_14 SearchCAM_DistCount[14]INTInteger0
36CAM_DistCount_15 SearchCAM_DistCount[15]INTInteger0
37CAM_DistCount_16 SearchCAM_DistCount[16]INTInteger0
38CAM_DocCount_1 SearchCAM_DocCount[1]INTInteger0
39CAM_DocCount_2 SearchCAM_DocCount[2]INTInteger0
40CAM_DocCount_3 SearchCAM_DocCount[3]INTInteger0
41CAM_DocCount_4 SearchCAM_DocCount[4]INTInteger0
42CAM_DocCount_5 SearchCAM_DocCount[5]INTInteger0
43CAM_DocCount_6 SearchCAM_DocCount[6]INTInteger0
44CAM_DocCount_7 SearchCAM_DocCount[7]INTInteger0
45DEX_ROW_ID Searchintint10

DEX_ROW_ID is an auto-numbered IDENTITY column used internally by Dexterity for lock management; it should not be used by developers to identify any particular piece of information.

Microsoft MVP Mariano Gomez has a good write up on the DEX_ROW_ID column.

Leave a Reply

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