Cash Code
The Cash Code file contains all valid cash codes. A cash code represents a bank account at a financial institution location.
REFERENCED BY
| AP100 | AP101 | AP109 | AP111 | AP14.1 | AP14.2 |
| AP14.5 | AP16.1 | AP16.2 | AP193 | AP58.1 | AP590 |
| AR02.1 | CB01.1 | CB01.4 | CB01.5 | CB01.6 | CB01.7 |
| CB05.1 | CB07.1 | CB11.1 | CB181 | CB211 | CBBC.1 |
| CBOP.1 | MA64.6 | MA64.9 | MAED.1 |
| FIELD NAME | DESCRIPTION/VALID VALUES | UPDATED BY | ||
|---|---|---|---|---|
| CBC-CASH-CODE Element: Cash Code | Alpha 4 A user-defined code representing a bank account at a bank location. |
|
||
| CBC-BANK-ACCT-NBR Element: Bank Account Number | Alpha 35 The bank-assigned account number identification to be used for the cash code. |
|
||
| CBC-BANK-IDENT Element: Alphadata1 | Alpha 1 |
|
||
| CBC-CURRENCY-CODE Bank Account Currency | Alpha 5 The currency of the bank account. Must be a valid record in the Currency Code file. |
|
||
| CBC-BANK-ENTITY Element: Bank Identification | Alpha 15 The bank location where the bank account is located. Must be a valid record in the Bank file. |
|
||
| CBC-SEND-BANK-ENT Electronic Transfer Bank | Alpha 15 If the bank for the cash code does not process electronic payments, this field contains the bank that processes the electronic payment media, if applicable. Must be a valid record in the Bank file. If left blank, the Bank Identification defaults. |
|
||
| CBC-ACTIVE-STATUS Element: Active Status | Alpha 1 The status of the of the bank account. If the bank account is Inactive, new bank transactions cannot be entered for the bank account, but bank transactions already entered in the system can be processed and reconciled. Valid values are: A = Active. I = Inactive. |
|
||
| CBC-REC-BALANCE Element: Reconciled Balance | Signed 18.2 The current reconciled balance of the bank account. |
|||
| CBC-OPEN-BALANCE Element: Open Balance | Signed 18.2 The current outstanding, or unreconciled, balance of the bank account. |
|||
| CBC-AP-DRAFTS AP Bill of Exchange Future Amt | Signed 18.2 |
|
||
| CBC-AR-DRAFTS AR Bill of Exchange Future Amt | Signed 18.2 |
|
||
| CBC-USED-FLAG Element: Used Flag | Alpha 1 Indicates whether the cash code has been used. Valid values are: Y = Yes. N = No. |
|||
| CBC-CURR-ND Currency Number of Decimals | Numeric 1 The number of decimal places defined for the bank account currency. |
|
||
| CBC-ROI-RATE Return on Investment Rate | Signed 5.3 The return on investment rate granted by the bank. For example, the interest rate. |
|
||
| CBC-SERIAL-NUM Element: Serial Number | Numeric 8 The serial number of the last payment tape created for the bank. |
|
||
| CBC-USER-CLASS Element: User Class | Alpha 12 The user class assigned to the cash code. Used to restrict access and use of the cash code to a specific group of users. If left blank, no access restrictions apply. |
|
||
| CBC-RECON-STMT-REQ Reconcile Statement Required | Alpha 1 Y = Yes N = No |
|
||
| CBC-RECON-JRNL-BK Reconciliation Journal Book | Alpha 12 The reconciliation journal book associated with the cash code. Used only if the Reconciliation Statement Required field = Yes. |
|
||
| CBC-NET-BALANCE Element: Net Balance | Derived The Reconciled Balance plus the Open Balance for the bank account. |
|
||
| CBC-RECON-STMT-NBR Reconcile Statement Number | Numeric 12 The bank-assigned reconciliation statement number. Used only for cash codes that require reconciliation statements. |
|
||
| CBC-LAST-END-BAL Element: Last End Balance | Signed 18.2 |
|
||
| CBC-SGLSTMT-USR-FL Single Statement User Flag | Alpha 1 |
|
||
| CBC-DESCRIPTION Element: Description | Alpha 30 (Lower Case) This field contains the description used in the GoFinancials product. |
|
||
| CBC-CBO-BAL-FLAG Element: All Flag | Alpha 1 |
|
||
| CBC-CREATED-BY Element: Operator | Alpha 10 |
|
||
| CBC-LAST-UPDT-DATE Element: Date | Numeric 8 (yyyymmdd) |
|||
| CBC-LAST-UPDT-TIME Element: Time | Numeric 8 |
|||
| CBC-LAST-UPDATE-BY Element: Operator | Alpha 10 |
|||
| CBC-SEPA-FLAG Element: Flag | Alpha 1 |
|
||
| CBC-SWIFT-ID Element: Swift Id | Alpha 12 |
|
| NAME | KEY FIELDS | DESCRIPTION / SUBSET CONDITION | USED IN | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| CBCSET1 |
CASH-CODE |
|
|||||||||||
| CBCSET2 |
BANK-ENTITY CASH-CODE |
|
| ||||||||||
| CBCSET3 |
BANK-ENTITY BANK-ACCT-NBR CASH-CODE |
|
| ||||||||||
| RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | |||
|---|---|---|---|---|---|
| Cbbankent | CBBANKENT |
Required
| |||
| Cbcashcode | CBCASHCODE |
Required
| |||
| Cbsend Bankent | CBBANKENT |
Required
| |||
| Cucodes | CUCODES |
Required
|
| RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | |||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Cbadjust | CBADJUST |
| |||||||||||||||||||||
| Cbadjust Unrel | CBADJUST |
| |||||||||||||||||||||
| Cbbalance | CBBALANCE |
Delete Restricted
| |||||||||||||||||||||
| Cbcashform | CBCASHFORM |
| |||||||||||||||||||||
| Cbcheck | CBCHECK |
| |||||||||||||||||||||
| Cbcpycash | CBCPYCASH |
| |||||||||||||||||||||
| Cbcscdaud | CBCSCDAUD |
| |||||||||||||||||||||
| Cbgrpcc | CBGRPCC |
| |||||||||||||||||||||
| Cbtrans | CBTRANS |
| |||||||||||||||||||||
| Cbtrans Date | CBTRANS |
| |||||||||||||||||||||
| Cbtrfhdr | CBTRFHDR |
| |||||||||||||||||||||
| Recpthdr Unrel | CBRECPTHDR |
| |||||||||||||||||||||
| Trfhdr Unrel | CBTRFHDR |
| |||||||||||||||||||||
| Unrel Trfhdr | CBTRFHDR |
|
All trademarks and registered trademarks are the property of their
respective owners.