Commonly Used Tables:

  • CM00100 – Checkbook Master   - setup information like GL account, next check and deposit numbers and checkbook balance
  • CM10100 – Deposit Work   - saved unposted deposit data
  • CM20100 – Bank Rec Journal   - contains a record for each posted transaction, allows for reprinting of some bank rec posting journals
  • CM20200 – Transactions   - all transaction data except receipts
  • CM20201 – Transaction Totals   - information for posted deposits
  • CM20300 – Receipts  - all receipts (deposited and undeposited)
  • CM20400 – Distributions   - GL distributions for all bank rec transactions
  • CM20500 – Reconciliation Headers   - header information entered during bank reconciliation
  • CM20501 – Reconcile Adjustments   - adjustments on current reconciliations
  • CM20600 – Transfers
INACTIVE in CM00100:
0 – Active
1 – Inactive

CNTRLTYP (Control Type):
1 – Transaction
2 – Receipt

CMTrxType (Transaction Type) and abbreviation:
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

DEPTYPE (Deposit Type):
1 – Deposit with Receipts
2 – Deposit without Receipts
3 – Clearing Deposit

DEPOSITED:
0 – False
1 – True

RcpType (Receipt Type):
1 – Check
2 – Cash
3 – Credit Card

 


Comments




Leave a Reply