CAM Summary Line (CAM10210)

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

Product: Control Account Management (2416)
Series:

Display Name: CAM Summary Line
Physical Name: CAM10210
Technical Name: CAM_Summary_LINE

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1DATE1 SearchDateDateDT66
2TIME1 SearchTimeTimeTM66
3CMPANYID SearchCompany IDIntegerINT54
Key to the Company Master (SY01500).

Click to show/hide

SELECT
       ['CAM Summary Line'].CMPANYID AS 'CAM Summary Line-Company ID'
       ,['Company Master'].CMPANYID AS 'Company Master-Company ID'
FROM
       CAM10210 AS ['CAM Summary Line']
INNER JOIN
       DYNAMICS..SY01500 AS ['Company Master']
              ON
                     ['CAM Summary Line'].CMPANYID = ['Company Master'].CMPANYID
4SGMNTID SearchSegment IDStringSTR66_Seg_ID66
5CAM_ControlAccountIndex SearchCAM_ControlAccountIndexLong IntegerLI_1414
6CAMControlAccount_1 SearchCAM_ControlAccount:Account_Segment_Pool1StringAccount_Segment_Pool16
7CAMControlAccount SearchCAM_ControlAccountAccount_NumberComposite 80
8CAMControlAccount_2 SearchCAM_ControlAccount:Account_Segment_Pool2StringAccount_Segment_Pool26
9CAMControlAccount_3 SearchCAM_ControlAccount:Account_Segment_Pool3StringAccount_Segment_Pool36
10CAMControlAccount_4 SearchCAM_ControlAccount:Account_Segment_Pool4StringAccount_Segment_Pool46
11CAMControlAccount_5 SearchCAM_ControlAccount:Account_Segment_Pool5StringAccount_Segment_Pool56
12CAMControlAccount_6 SearchCAM_ControlAccount:Account_Segment_Pool6StringAccount_Segment_Pool66
13CAMControlAccount_7 SearchCAM_ControlAccount:Account_Segment_Pool7StringAccount_Segment_Pool76
14CAMControlAccount_8 SearchCAM_ControlAccount:Account_Segment_Pool8StringAccount_Segment_Pool86
15CAMControlAccount_9 SearchCAM_ControlAccount:Account_Segment_Pool9StringAccount_Segment_Pool96
16CAMControlAccount_10 SearchCAM_ControlAccount:Account_Segment_Pool10StringAccount_Segment_Pool106
17CAM_ControlAcctDescr SearchCAM_ControlAcctDescriptionStringSTR3232
18CAM_Amount_Total SearchCAM Amount TotalCurrencyDLR19_$S219

Leave a Reply

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