top of page

Commonly Used CM Tables

Table                        Description

CM00100                Checkbook Master                

​

CM10100                Deposit Work

CM20100                Bank Rec Journal

CM20200                Transactions

CM20201                Transactions Totals

CM20300                Receipts

CM20400                Distributions

CM20500                Reconciliation Headers

CM20501                Reconciliation Adj.'s

CM20600                Transfers

​

CMTrxType (Transaction Type):
1 – DEP – Deposit
2 – RCT – Receipt [not used in CM20200] 
3 – CHK – Check
4 – WDL – Withdrawal
5 – IAJ – Increase Adjustment
6 – DAJ – Decrease Adjustment
7 – XFR – Transfer
101 – INT – Interest Income
102 – OIN – Other Income
103 – OEX – Other Expense
104 – SVC – Service Charge

bottom of page