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.