Module List > Module CM tables CM20500
You are currently viewing the COMPANY database.
Change

COMPANY..CM20500 Table Definition

(COMPANY..CM Reconcile Header)


4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
CHEKBKID char(15)
''
Checkbook ...(more) Join Now
join ... more text available
RECONUM numeric(19,5)
0.00

Recond tinyint
0
Reconciled...(more) Join Now
StmntDate datetime
'1/1/1900'

StmntBal numeric(19,5)
0.00

CUTOFFBAL numeric(19,5)
0.00

ClrdPay smallint
0

ClrdDep smallint
0

ClrePayAmt numeric(19,5)
0.00

ClrdDepAmt numeric(19,5)
0.00

Cleared_Difference numeric(19,5)
0.00

OUTPAYTOT numeric(19,5)
0.00

OUTDEPTOT numeric(19,5)
0.00

IINADJTOT numeric(19,5)
0.00

DECADJTOT numeric(19,5)
0.00

ASOFBAL numeric(19,5)
0.00

CUTOFDAT datetime
'1/1/1900'

GLPOSTDT datetime
'1/1/1900'
GL Posting...(more) Join Now
MDFUSRID char(15)
''
User that ...(more) Join Now
join ... more text available
MODIFDT datetime
'1/1/1900'
Date the r...(more) Join Now
CURNCYID char(15)
''
Currency I...(more) Join Now
join ... more text available
NOTEINDX numeric(19,5)
0.00
Note Index...(more) Join Now
join ... more text available
RCRDSTTS smallint
0
RecordStat...(more) Join Now
Reconcile_Messages binary(4)
0

AUDITTRAIL char(13)
''
Audit Trai...(more) Join Now
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
3