DynDeveloper.com

DynDeveloper.com
Table Edits Forum Articles
Table Edits 0 Table Edits 0 Table Edits 0
Sign Up Now! Log In
Search the GP Tables
Search by TABLE NAME
Search by FIELD NAME
These are our SOP scripts. All of our scripts for Dynamics GP can be found here
Module List > Module CAM tables CAM10200
You are currently viewing the COMPANY database.
Change

COMPANY..CAM10200 Table Definition

(COMPANY..CAM Summary Header)

4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value		 Source
CAMAccountType smallint
0

DATE1 datetime
'1/1/1900'
Date: Date...(more) Join Now SY03900.DATE1
TIME1 datetime
'1/1/1900'
Time see ...(more) Join Now CM20200.TIME1
CMPANYID smallint
0
Company ID...(more) Join Now POP10100.CMPANYID
join ... more text available
CAM_Series smallint
0

SGMTNUMB smallint
0

USERID char(15)
''
The user t...(more) Join Now
join ... more text available
CAM_Amount_Total numeric(19,5)
0.00

CAM_CntrlCount_1 smallint
0

CAM_CntrlCount_2 smallint
0

CAM_DistCount_1 smallint
0

CAM_DistCount_2 smallint
0

CAM_DistCount_3 smallint
0

CAM_DistCount_4 smallint
0

CAM_DistCount_5 smallint
0

CAM_DistCount_6 smallint
0

CAM_DistCount_7 smallint
0

CAM_DistCount_8 smallint
0

CAM_DistCount_9 smallint
0

CAM_DistCount_10 smallint
0

CAM_DistCount_11 smallint
0

CAM_DistCount_12 smallint
0

CAM_DistCount_13 smallint
0

CAM_DistCount_14 smallint
0

CAM_DistCount_15 smallint
0

CAM_DistCount_16 smallint
0

CAM_DocCount_1 smallint
0

CAM_DocCount_2 smallint
0

CAM_DocCount_3 smallint
0

CAM_DocCount_4 smallint
0

CAM_DocCount_5 smallint
0

CAM_DocCount_6 smallint
0

CAM_DocCount_7 smallint
0

BACHNUMB char(15)
''
Batch Numb...(more) Join Now
join ... more text available
BCHCOMNT char(61)
''
Batch Comm...(more) Join Now SY00500.BCHCOMNT
REFRENCE char(31)
''
Reference:...(more) Join Now POP30300.REFRENCE
SOURCDOC char(11)
''
Field values: 1= Invoice 2= Finance Charge 3= Miscellaneous Charges 4= Return 5= Credit Memo PP000001.SOURCDOC
TRXSRCPX char(5)
''

TRXDATE datetime
'1/1/1900'
TrxDate Transaction Date used when the transaction was posted CM20502.TRXDATE
RVRSNGDT datetime
'1/1/1900'
Reversing ...(more) Join Now GL10000.RVRSNGDT
CAM_Status smallint
0

DEX_ROW_ID int
auto number (1,1)
 Unique ide...(more) Join Now
Table Definition Quick Links
All Tables
SOP Tables
RM Tables
GL Tables
POP Tables
HR Tables
PM Tables
UPR Tables
IV Tables
Olympic Tables
Archives | Table Listing | eConnect Error Database | eConnect Schema | Gold Star Locksmith
3