CAM10200 - CAM Summary Header | Prospr - Dynamics GP Table Reference

CAM10200 - CAM Summary Header

Query Builder

Select * from CAM10200

Column	Description	Data Type	Length	Tables This Field Is In	In Query ()
CAMAccountType	CAM_Account_Type	Integer	2	View
DATE1	Date	Date	4	View
TIME1	Time	Time	4	View
CMPANYID	Company ID	Integer	2	View
CAM_Series	CAM_Series	Integer	2	View
SGMTNUMB	Segment Number	Integer	2	View
USERID	User ID	String	16	View
CAM_Amount_Total	CAM Amount Total	Currency	10	View
CAM_CntrlCount_1	CAM_CntrlCount[1]	Integer	2	View
CAM_CntrlCount_2	CAM_CntrlCount[2]	Integer	2	View
CAM_DistCount_1	CAM_DistCount[1]	Integer	2	View
CAM_DistCount_2	CAM_DistCount[2]	Integer	2	View
CAM_DistCount_3	CAM_DistCount[3]	Integer	2	View
CAM_DistCount_4	CAM_DistCount[4]	Integer	2	View
CAM_DistCount_5	CAM_DistCount[5]	Integer	2	View
CAM_DistCount_6	CAM_DistCount[6]	Integer	2	View
CAM_DistCount_7	CAM_DistCount[7]	Integer	2	View
CAM_DistCount_8	CAM_DistCount[8]	Integer	2	View
CAM_DistCount_9	CAM_DistCount[9]	Integer	2	View
CAM_DistCount_10	CAM_DistCount[10]	Integer	2	View
CAM_DistCount_11	CAM_DistCount[11]	Integer	2	View
CAM_DistCount_12	CAM_DistCount[12]	Integer	2	View
CAM_DistCount_13	CAM_DistCount[13]	Integer	2	View
CAM_DistCount_14	CAM_DistCount[14]	Integer	2	View
CAM_DistCount_15	CAM_DistCount[15]	Integer	2	View
CAM_DistCount_16	CAM_DistCount[16]	Integer	2	View
CAM_DocCount_1	CAM_DocCount[1]	Integer	2	View
CAM_DocCount_2	CAM_DocCount[2]	Integer	2	View
CAM_DocCount_3	CAM_DocCount[3]	Integer	2	View
CAM_DocCount_4	CAM_DocCount[4]	Integer	2	View
CAM_DocCount_5	CAM_DocCount[5]	Integer	2	View
CAM_DocCount_6	CAM_DocCount[6]	Integer	2	View
CAM_DocCount_7	CAM_DocCount[7]	Integer	2	View
BACHNUMB	Batch Number	String	16	View
BCHCOMNT	Batch Comment	String	62	View
REFRENCE	Reference	String	32	View
SOURCDOC	Source Document 1= Invoice 2= Finance Charge 3= Miscellaneous Charges 4= Return 5= Credit Memo	String	12	View
TRXSRCPX	Transaction Source Prefix	String	6	View
TRXDATE	TRX Date	Date	4	View
RVRSNGDT	Reversing Date	Date	4	View
CAM_Status	CAM_Status	Integer	2	View

CAM10200 - CAM Summary Header

Query Builder

Customer Service

Information

My Account

Contact Us