Cash Management Overview
Primary Tables:
CMTACCT
Key Fields:
- ACCOUNT_TYPE
CH;Checking SA;Savings CC;Credit Card CA;Cash NP;Note Payable NR;Note Receivable IN;Investment
CMTTRX
Key Fields for CMTTRX:
- TRANS_TYPE (See Table Below)
- STATUS
- 1: Open
- 2: Cleared
- 3: Reconciled
TRANS_TYPE Definitions
| Named Constant | Value | Code | Description | ShortDesc | Manual entry | DR/CR |
| (on-screen) | ||||||
| CM_BALANCE_FORWARD | 1 | B | Balance Forward | Bal Fwd | N | CR |
| CM_CHECK | 2 | C | Check | Check | Y | DR |
| CM_AP_CHECK | 3 | A | AP Check | Check-AP | N | DR |
| CM_PAYCHECK | 4 | P | Paycheck | Check-PY | N | DR |
| CM_DEPOSIT | 5 | D | Deposit | Deposit | Y | CR |
| CM_AR_DEPOSIT | 6 | R | AR Deposit | Dep- AR | N | CR |
| CM_INTEREST | 7 | I | Interest | Interest | Y | CR |
| CM_SERVICE_CHARGE | 8 | S | Service Charge | Svc Chg | Y | DR |
| CM_TRANSFER | 9 | T | Transfer | Transfer | Y | DR |
| CM_TRANSFER_IN | 10 | N | Transfer In | Transfer | N | CR |
| CM_MISCELLANEOUS | 11 | M | Miscellaneous | Misc | Y | CR |
| CM_DIVIDEND | 12 | V | Dividend | Dividend | Y | CR |
| CM_INVALID | -1 | N | CR | |||