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 AR32.1 AR34.1
AR570 AR575 AR580 AR82.1 CB06.2 CB10.1
CB145 CB15.1 CB15.2 CB150 CB180 CB185
CB186 CB187 CB191 CB20.1 CB25.1 CB30.1
CB43.1 CB44.1 CB46.1 CB500 CB543 CB544
CB80.1 CB82.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 AP170 AP180
PER-END-DATE AP181 AP190
AP255 AP265
AP81.1 AP90.5
AR115 AR124
AR20.1 AR21.1
AR21.2 AR21.3
AR24.1 AR30.1
AR32.1 AR34.1
AR570 AR575
AR580 AR82.1
CB06.2 CB10.1
CB145 CB15.1
CB15.2 CB150
CB180 CB185
...
CBBSET2 CASH-CODE CB30.1
PER-END-DATE*
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
|
