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 TypeSQL DB LengthKeyable Length
1CAMAccountType SearchCAM_Account_TypeDDL_CAM_Account_TypeInteger20
2DATE1 SearchDateDT6Date46
3TIME1 SearchTimeTM6Time46
4CMPANYID SearchCompany IDINT5Integer24
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_SeriesInteger20
6SGMTNUMB SearchSegment NumberINT2Integer22
7USERID SearchUser IDSTR15_User_IDString1615
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_$S2Currency1019
9CAM_CntrlCount_1 SearchCAM_CntrlCount[1]INTInteger20
10CAM_CntrlCount SearchCAM_CntrlCountINTInteger20
11CAM_CntrlCount_2 SearchCAM_CntrlCount[2]INTInteger20
12CAM_DistCount SearchCAM_DistCountINTInteger20
13CAM_DistCount_1 SearchCAM_DistCount[1]INTInteger20
14CAM_DocCount SearchCAM_DocCountINTInteger20
15BACHNUMB SearchBatch NumberSTR15_LBAUString1615
16CAM_DistCount_2 SearchCAM_DistCount[2]INTInteger20
17BCHCOMNT SearchBatch CommentSTR60String6260
18CAM_DistCount_3 SearchCAM_DistCount[3]INTInteger20
19REFRENCE SearchReferenceSTR30String3230
20CAM_DistCount_4 SearchCAM_DistCount[4]INTInteger20
21CAM_DistCount_5 SearchCAM_DistCount[5]INTInteger20
22SOURCDOC SearchSource DocumentSTR10_Source_DocumentString1210
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 PrefixString65
24CAM_DistCount_6 SearchCAM_DistCount[6]INTInteger20
25TRXDATE SearchTRX DateDT_DateDate46
26CAM_DistCount_7 SearchCAM_DistCount[7]INTInteger20
27CAM_DistCount_8 SearchCAM_DistCount[8]INTInteger20
28RVRSNGDT SearchReversing DateDT_DateDate46
29CAM_DistCount_9 SearchCAM_DistCount[9]INTInteger20
30CAM_Status SearchCAM_StatusCAM_StatusTpeInteger20
31CAM_DistCount_10 SearchCAM_DistCount[10]INTInteger20
32CAM_DistCount_11 SearchCAM_DistCount[11]INTInteger20
33CAM_DistCount_12 SearchCAM_DistCount[12]INTInteger20
34CAM_DistCount_13 SearchCAM_DistCount[13]INTInteger20
35CAM_DistCount_14 SearchCAM_DistCount[14]INTInteger20
36CAM_DistCount_15 SearchCAM_DistCount[15]INTInteger20
37CAM_DistCount_16 SearchCAM_DistCount[16]INTInteger20
38CAM_DocCount_1 SearchCAM_DocCount[1]INTInteger20
39CAM_DocCount_2 SearchCAM_DocCount[2]INTInteger20
40CAM_DocCount_3 SearchCAM_DocCount[3]INTInteger20
41CAM_DocCount_4 SearchCAM_DocCount[4]INTInteger20
42CAM_DocCount_5 SearchCAM_DocCount[5]INTInteger20
43CAM_DocCount_6 SearchCAM_DocCount[6]INTInteger20
44CAM_DocCount_7 SearchCAM_DocCount[7]INTInteger20
45DEX_ROW_ID Searchintint1010

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 *