CBBALANCE

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

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
CBBSET1 CASH-CODE
PER-END-DATE
...
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
CBBSET2 CASH-CODE
PER-END-DATE*
CB222 CB30.1


CBBALANCE FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Cbcashcode CBCASHCODE Required
CBB-CASH-CODE->CBC-CASH-CODE


CBBALANCE FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME
RELATED 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


File created: Thu Jun 09 11:11:35 2016

Home
Contact Us



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