Bank Account Balance
The Bank Account Balance file contains bank account period balance information for a cash code.
REFERENCED BY
| CB190 | CB300 | CB99.2 |
| FIELD NAME | DESCRIPTION/VALID VALUES | UPDATED BY | ||
|---|---|---|---|---|
| CBB-CASH-CODE Element: Cash Code | Alpha 4 The cash code. Represents a bank account. Must be a valid record in the Cash Code file. |
|
||
| CBB-PER-END-DATE Element: Period End Date | Numeric 8 (yyyymmdd) The closing date of the bank period. |
|
||
| CBB-BEG-BALANCE Element: Beginning Balance | Signed 18.2 The bank account balance at the beginning of the bank period. This value equals the ending balance of the previous bank period. |
|
||
| CBB-TRANS-BALANCE Element: Transaction Balance | Signed 18.2 The total amount of all transactions for the bank period. |
|
||
| CBB-DEBIT-BALANCE Element: Debit Balance | Signed 18.2 The total amount of bank debit transactions for the bank period. |
|
||
| CBB-CREDIT-BALANCE Element: Credit Balance | Signed 18.2 The total amount of bank credit transactions for the bank period. |
|
||
| CBB-DEBIT-REC-CNT Debit Reconciled Count | Numeric 7 The total number of bank debit transactions for the bank period. |
|
||
| CBB-CREDIT-REC-CNT Credit Reconciled Count | Numeric 7 The total number of bank credit transactions for the bank period. |
|
||
| CBB-ENDING-BALANCE Element: Ending Balance | Signed 18.2 The bank account balance at the end of the bank period. |
|
||
| CBB-PER-BEG-DATE Period Beginning Date | Numeric 8 (yyyymmdd) The beginning date of the bank period. |
|
| NAME | KEY FIELDS | DESCRIPTION / SUBSET CONDITION | USED IN | ||||||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| CBBSET1 |
CASH-CODE PER-END-DATE |
|
...
| ||||||||||||||||||||||||||||||||||||
| CBBSET2 |
CASH-CODE PER-END-DATE* |
|
| ||||||||||||||||||||||||||||||||||||
| RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | |||
|---|---|---|---|---|---|
| Cbcashcode | CBCASHCODE |
Required
|
| RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | ||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Cbtrans | CBTRANS |
|
All trademarks and registered trademarks are the property of their
respective owners.