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_LINESeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 DATE1 
Date Date DT6 6 2 TIME1 Time Time TM6 6 3 CMPANYID Company ID Integer INT5 4 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'].CMPANYID4 SGMNTID Segment ID String STR66_Seg_ID 66 5 CAM_ControlAccountIndex CAM_ControlAccountIndex Long Integer LI_14 14 6 CAMControlAccount_1 CAM_ControlAccount:Account_Segment_Pool1 String Account_Segment_Pool1 6 7 CAMControlAccount CAM_ControlAccount Account_Number Composite 80 8 CAMControlAccount_2 CAM_ControlAccount:Account_Segment_Pool2 String Account_Segment_Pool2 6 9 CAMControlAccount_3 CAM_ControlAccount:Account_Segment_Pool3 String Account_Segment_Pool3 6 10 CAMControlAccount_4 CAM_ControlAccount:Account_Segment_Pool4 String Account_Segment_Pool4 6 11 CAMControlAccount_5 CAM_ControlAccount:Account_Segment_Pool5 String Account_Segment_Pool5 6 12 CAMControlAccount_6 CAM_ControlAccount:Account_Segment_Pool6 String Account_Segment_Pool6 6 13 CAMControlAccount_7 CAM_ControlAccount:Account_Segment_Pool7 String Account_Segment_Pool7 6 14 CAMControlAccount_8 CAM_ControlAccount:Account_Segment_Pool8 String Account_Segment_Pool8 6 15 CAMControlAccount_9 CAM_ControlAccount:Account_Segment_Pool9 String Account_Segment_Pool9 6 16 CAMControlAccount_10 CAM_ControlAccount:Account_Segment_Pool10 String Account_Segment_Pool10 6 17 CAM_ControlAcctDescr CAM_ControlAcctDescription String STR32 32 18 CAM_Amount_Total CAM Amount Total Currency DLR19_$S2 19