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

COMPANY..CM00100 Table Definition

(COMPANY..CM Checkbook Master)

 

This table stores the checkbook information - specifically the next deposit number. We also use the table to indicate that, during the posting of the deposit, a deposit is in progress for this checkbook.


4Penny.net

Field Definitions:

What is the 'source' column?

 Column NameData Type
Default Value
 Source
CHEKBKID char(15)
''
Checkbook ...(more) Join Now
DSCRIPTN char(31)
''
Descriptio...(more) Join Now
BANKID char(15)
''
BankID Ban...(more) Join Now
CURNCYID char(15)
''
Currency I...(more) Join Now
join ... more text available
ACTINDX int
0
Account In...(more) Join Now
join ... more text available
BNKACTNM char(15)
''
Bank Accou...(more) Join Now
NXTCHNUM char(21)
''
Next Check...(more) Join Now
Next_Deposit_Number char(21)
''
Next Depos...(more) Join Now
INACTIVE tinyint
0
Inactive F...(more) Join Now
DYDEPCLR smallint
0
Days Depos...(more) Join Now
XCDMCHPW char(11)
''
Exceed Max...(more) Join Now
MXCHDLR numeric(19,5)
0.00
Maximum Ch...(more) Join Now
DUPCHNUM tinyint
0
Duplicate ...(more) Join Now
OVCHNUM1 tinyint
0
Override C...(more) Join Now
LOCATNID char(15)
''
Location I...(more) Join Now
join ... more text available
NOTEINDX numeric(19,5)
0.00
Note Index...(more) Join Now
join ... more text available
CMUSRDF1 char(21)
''
UserDefine...(more) Join Now
CMUSRDF2 char(21)
''
UserDefine...(more) Join Now
Last_Reconciled_Date datetime
'1/1/1900'
Last Recon...(more) Join Now
Last_Reconciled_Balance numeric(19,5)
0.00
Last Recon...(more) Join Now
CURRBLNC numeric(19,5)
0.00
Current Ba...(more) Join Now
CREATDDT datetime
'1/1/1900'
Created Da...(more) Join Now
MODIFDT datetime
'1/1/1900'
Date the r...(more) Join Now
Recond tinyint
0
Reconciled...(more) Join Now
Reconcile_In_Progress numeric(19,5)
0.00
Reconcile ...(more) Join Now
Deposit_In_Progress char(21)
''
Deposit In...(more) Join Now
CHBKPSWD char(15)
''
Checkbook ...(more) Join Now
CURNCYPD char(15)
''
Currency P...(more) Join Now
CRNCYRCD char(15)
''
Currency R...(more) Join Now
ADPVADLR numeric(19,5)
0.00
Allow Depo...(more) Join Now
ADPVAPWD char(11)
''
Allow Depo...(more) Join Now
DYCHTCLR smallint
0
Days Check...(more) Join Now
CMPANYID smallint
0
Company ID...(more) Join Now
join ... more text available
CHKBKTYP smallint
0
Checkbook ...(more) Join Now
DDACTNUM char(17)
''
DD Account...(more) Join Now
DDINDNAM char(23)
''
DD Individ...(more) Join Now
DDTRANS char(3)
''
DD Transac...(more) Join Now
PaymentRateTypeID char(15)
''
Payment Ra...(more) Join Now
DepositRateTypeID char(15)
''
Deposit Ra...(more) Join Now
CashInTransAcctIdx int
0
Cash In Tr...(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