CAM Summary Header (CAM10200)

azurecurve Products Control Account Management (2416)CompanyCAM 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 No	Physical Name	Display Name	Dexterity Data Type	SQL Data Type	Length
1	CAMAccountType	CAM_Account_Type	Integer	DDL_CAM_Account_Type	0
2	DATE1	Date	Date	DT6	6
3	TIME1	Time	Time	TM6	6
4	CMPANYID	Company ID	Integer	INT5	4
	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
5	CAM_Series	CAM_Series	Integer	CAM_DDL_Series	0
6	SGMTNUMB	Segment Number	Integer	INT2	2
7	USERID	User ID	String	STR15_User_ID	15
	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
8	CAM_Amount_Total	CAM Amount Total	Currency	DLR19_$S2	19
9	CAM_CntrlCount	CAM_CntrlCount	INT	Integer	0
10	CAM_CntrlCount_1	CAM_CntrlCount[1]	Integer	INT	0
11	CAM_CntrlCount_2	CAM_CntrlCount[2]	Integer	INT	0
12	CAM_DistCount	CAM_DistCount	INT	Integer	0
13	CAM_DistCount_1	CAM_DistCount[1]	Integer	INT	0
14	CAM_DocCount	CAM_DocCount	INT	Integer	0
15	CAM_DistCount_2	CAM_DistCount[2]	Integer	INT	0
16	CAM_DistCount_3	CAM_DistCount[3]	Integer	INT	0
17	CAM_DistCount_4	CAM_DistCount[4]	Integer	INT	0
18	CAM_DistCount_5	CAM_DistCount[5]	Integer	INT	0
19	CAM_DistCount_6	CAM_DistCount[6]	Integer	INT	0
20	CAM_DistCount_7	CAM_DistCount[7]	Integer	INT	0
21	CAM_DistCount_8	CAM_DistCount[8]	Integer	INT	0
22	CAM_DistCount_9	CAM_DistCount[9]	Integer	INT	0
23	CAM_DistCount_10	CAM_DistCount[10]	Integer	INT	0
24	CAM_DistCount_11	CAM_DistCount[11]	Integer	INT	0
25	CAM_DistCount_12	CAM_DistCount[12]	Integer	INT	0
26	CAM_DistCount_13	CAM_DistCount[13]	Integer	INT	0
27	CAM_DistCount_14	CAM_DistCount[14]	Integer	INT	0
28	CAM_DistCount_15	CAM_DistCount[15]	Integer	INT	0
29	CAM_DistCount_16	CAM_DistCount[16]	Integer	INT	0
30	CAM_DocCount_1	CAM_DocCount[1]	Integer	INT	0
31	CAM_DocCount_2	CAM_DocCount[2]	Integer	INT	0
32	CAM_DocCount_3	CAM_DocCount[3]	Integer	INT	0
33	CAM_DocCount_4	CAM_DocCount[4]	Integer	INT	0
34	CAM_DocCount_5	CAM_DocCount[5]	Integer	INT	0
35	CAM_DocCount_6	CAM_DocCount[6]	Integer	INT	0
36	CAM_DocCount_7	CAM_DocCount[7]	Integer	INT	0
37	BACHNUMB	Batch Number	String	STR15_LBAU	15
38	BCHCOMNT	Batch Comment	String	STR60	60
39	REFRENCE	Reference	String	STR30	30
40	SOURCDOC	Source Document	String	STR10_Source_Document	10
	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
41	TRXSRCPX	Transaction Source Prefix	String	Transaction Source Prefix	5
42	TRXDATE	TRX Date	Date	DT_Date	6
43	RVRSNGDT	Reversing Date	Date	DT_Date	6
44	CAM_Status	CAM_Status	Integer	CAM_StatusTpe	0

azurecurve Products Control Account Management (2416)CompanyCAM Summary Header (CAM10200)

Click to show/hide

Click to show/hide

Click to show/hide

Leave a Reply Cancel reply