CBBALANCE FILE
Bank Account Balance
The Bank Account Balance file contains bank account period balance
information for a cash code.
REFERENCED BY
AP170 AP180 AP181 AP190 AP255 AP265
AP81.1 AP90.5 AR115 AR124 AR20.1 AR21.1
AR21.2 AR21.3 AR24.1 AR30.1 AR34.1 AR570
AR575 AR580 AR82.1 CB06.2 CB10.1 CB15.1
CB15.2 CB180 CB185 CB191 CB20.1 CB25.1
CB30.1 CB500 CB80.1 CB90.3 DT180 DT181
DT185 DT92.1
UPDATED BY
CB190 CB300 CB99.2
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
CBB-CASH-CODE Alpha 4 CB190 CB99.2
Element: Cash Code The cash code. Represents a bank
account. Must be a valid record in the
Cash Code file.
CBB-PER-END-DATE Numeric 8 (yyyymmdd) CB190 CB99.2
Element: Period End DatThe closing date of the bank period.
CBB-BEG-BALANCE Signed 18.2 CB190 CB99.2
Element: Beginning BalaThe bank account balance at the
beginning of the bank period. This value
equals the ending balance of the
previous bank period.
CBB-TRANS-BALANCE Signed 18.2 CB190
Element: Transaction BaThe total amount of all transactions
for the bank period.
CBB-DEBIT-BALANCE Signed 18.2 CB190
Element: Debit Balance The total amount of bank debit
transactions for the bank period.
CBB-CREDIT-BALANCE Signed 18.2 CB190
Element: Credit BalanceThe total amount of bank credit
transactions for the bank period.
CBB-DEBIT-REC-CNT Numeric 7 CB190
Debit Reconciled The total number of bank debit
Count transactions for the bank period.
CBB-CREDIT-REC-CNT Numeric 7 CB190
Credit Reconciled The total number of bank credit
Count transactions for the bank period.
CBB-ENDING-BALANCE Signed 18.2 CB99.2
Element: Ending BalanceThe bank account balance at the end of
the bank period.
CBB-PER-BEG-DATE Numeric 8 (yyyymmdd) CB190 CB99.2
Period Beginning The beginning date of the bank period.
Date
CBBALANCE FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
CBBSET1 CASH-CODE This index is used to access a balance AP170 AP180
PER-END-DATE record for a bank account. AP181 AP190
AP255 AP265
AP81.1 AP90.5
AR115 AR124
AR20.1 AR21.1
AR21.2 AR21.3
AR24.1 AR30.1
AR34.1 AR570
AR575 AR580
AR82.1 CB06.2
CB10.1 CB15.1
CB15.2 CB180
CB185 CB190
CB191 CB20.1
...
CBBSET2 CASH-CODE This index is used to access a balance CB30.1
PER-END-DATE* record in the most recent bank period
for a bank account.
CBBALANCE FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Cbcashcode CBCASHCODE Required
CBB-CASH-CODE -> CBC-CASH-CODE
CBBALANCE FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Cbtrans CBTRANS
CBB-CASH-CODE -> CBT-CASH-CODE
CBB-PER-END-DATE -> CBT-PERIOD-DATE
CBT-BANK-INST-CODE
CBT-TRANS-NBR
CBT-SUFFIX
CBT-TRANS-IDENT
|
