GP Tables

CAM10200 - CAM Summary Header

Dynamics GP table CAM10200 (CAM Summary Header) contains 41 columns including CAMAccountType, DATE1, TIME1....

SQL Query Builder

41 Columns

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

Related Tables

Tables that share columns with CAM10200. Click "Join" to add to your query.

USERID

AAG50001 AAG60001 AAG70001 ACTIVITY AHPSLH01 ASIEXP100 ASIEXP85 CM20203

TIME1

AAG10001 AAG20001 AAG20011 AAG2001T AAG30001 AAG40001 ASIEXP06 ASIEXP07

BACHNUMB

ASIEXP06 ASIEXP08 ASIEXP09 ASIEXP10 ASIEXP12 ASIEXP19 ASIEXP20 ASIEXP25

CMPANYID

ADSK0600 ASIEXP07 ASIEXP100 ASIEXP21 ASIEXP85 CAM10210 CPO40001 CPO40002

REFRENCE

ASIEXP06 ASIEXP12 ASIEXP20 ASIEXP27 BM10200 BM30200 CM00001 CPO10113

SOURCDOC

AAG30001 AAG40001 ASIEXP09 ASIEXP12 ASIEXP22 CM20200 CM20300 CPO10113

DATE1

AE031000 CAM10100 CAM10210 CN00100 CN10200 DO10100 IF000005 PM10200

TRXDATE

ASIEXP12 ASIEXP14 ASIEXP22 BM10200 BM30200 CM20200 CM20501 CPO10113

SGMTNUMB

IF000001 SY00302

CAM_Amount_Total

CAM10100 CAM10210