Bank Account Balance

The Bank Account Balance file contains bank account period balance information for a cash code.
UPDATED BY

AP170	AP180	AP181	AP190	AP255	AP265
AP81.1	AP90.5	CB06.2	CB10.1	CB145	CB15.1
CB15.2	CB150	CB180	CB185	CB186	CB187
CB190	CB191	CB20.1	CB20.6	CB222	CB25.1
CB30.1	CB300	CB43.1	CB44.1	CB46.1	CB500
CB543	CB544	CB80.1	CB82.1	CB90.3	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.	CB190 CB99.2
CBB-PER-END-DATE Element: Period End Date	Numeric 8 (yyyymmdd) The closing date of the bank period.	CB190 CB99.2
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.	CB190 CB99.2
CBB-TRANS-BALANCE Element: Transaction Balance	Signed 18.2 The total amount of all transactions for the bank period.	CB190
CBB-DEBIT-BALANCE Element: Debit Balance	Signed 18.2 The total amount of bank debit transactions for the bank period.	CB190
CBB-CREDIT-BALANCE Element: Credit Balance	Signed 18.2 The total amount of bank credit transactions for the bank period.	CB190
CBB-DEBIT-REC-CNT Debit Reconciled Count	Numeric 7 The total number of bank debit transactions for the bank period.	CB190
CBB-CREDIT-REC-CNT Credit Reconciled Count	Numeric 7 The total number of bank credit transactions for the bank period.	CB190
CBB-ENDING-BALANCE Element: Ending Balance	Signed 18.2 The bank account balance at the end of the bank period.	CB99.2
CBB-PER-BEG-DATE Period Beginning Date	Numeric 8 (yyyymmdd) The beginning date of the bank period.	CB190 CB99.2

CBBALANCE FILE INDEX

CBBALANCE FILE RELATIONS

ONE TO ONE RELATIONS

CBBALANCE FILE RELATIONS

ONE TO MANY RELATIONS

All trademarks and registered trademarks are the property of their respective owners.