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

COMPANY..CM20600 Table Definition

(COMPANY..CM Transfer)
This table stores all posted information concerning transfers. Unposted information is entered here before posting but not stored since Bank Reconciliation does not use batches.
4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
Xfr_Record_Number numeric(19,5)
0.00
Internally...(more) Join Now
CMXFRNUM char(21)
''
This is th...(more) Join Now
CMFRMRECNUM numeric(19,5)
0.00
This is th...(more) Join Now
CMTORECNUM numeric(19,5)
0.00
This is th...(more) Join Now
CMFRMSTATUS smallint
0
RECONCILED...(more) Join Now
CMTOSTATUS smallint
0
RECONCILED...(more) Join Now
CMFRMCHKBKID char(15)
''
The checkb...(more) Join Now
CMCHKBKID char(15)
''
The checkb...(more) Join Now
CMXFTDATE datetime
'1/1/1900'
Date used ...(more) Join Now
NOTEINDX numeric(19,5)
0.00
Note Index...(more) Join Now
join ... more text available
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