CBCONSOL

This file is updated by a batch program that consolidated CBTRANS amounts by Cash Code/Bank Inst Code/Company. It is used to populate cash ledger data marts.

REFERENCED BY
CB90.6 CB90.7 CB90.8 CBOP.1


UPDATED BY
AP170 AP180 AP181 AP190 AP255 AP265
AP81.1 AP90.5 CB06.2 CB10.1 CB145 CB15.1
CB15.2 CB150 CB180 CB181 CB185 CB186
CB187 CB190 CB191 CB20.1 CB20.6 CB25.1
CB30.1 CB46.1 CB500 CB543 CB544 CB80.1
CB82.1 CB99.3 CB99.4 CB99.5

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
CBO-CASH-CODE
Element: Cash Code
Alpha 4
A cash code represents a bank account. More than one company can use the same cash code. The cash code must be linked to a bank in the Lawson Cash Ledger system.
AP170 AP180
AP181 AP190
AP255 AP265
AP81.1 AP90.5
CB06.2 CB10.1
CB145 CB15.1
CB15.2 CB150
CB180 CB181
CB185 CB186
CB187 CB190
CB191 CB20.1
CB20.6 CB25.1
CB30.1 CB46.1
CB500 CB543
CB544 CB80.1
CB82.1 CB99.3
CB99.4 CB99.5
CBO-BANK-INST-CODE
Element: Bank Inst Code
Alpha 3
A transaction code represents a type of cash payment, bill of exchange payment, or bank service transaction.
AP170 AP180
AP181 AP190
AP255 AP265
AP81.1 AP90.5
CB06.2 CB10.1
CB145 CB15.1
CB15.2 CB150
CB180 CB181
CB185 CB186
CB187 CB190
CB191 CB20.1
CB20.6 CB25.1
CB30.1 CB46.1
CB500 CB543
CB544 CB80.1
CB82.1 CB99.3
CB99.4 CB99.5
CBO-COMPANY
Element: Company
Numeric 4
Identifies the cash code company.
AP170 AP180
AP181 AP190
AP255 AP265
AP81.1 AP90.5
CB06.2 CB10.1
CB145 CB15.1
CB15.2 CB150
CB180 CB181
CB185 CB186
CB187 CB190
CB191 CB20.1
CB20.6 CB25.1
CB30.1 CB46.1
CB500 CB543
CB544 CB80.1
CB82.1 CB99.3
CB99.4 CB99.5
CBO-BANK-BEG-BAL
Element: Intl Amt
Signed 18.2
The bank beginning balance. Represents Represents all reconciled transactions up to (but not including) the run date of the report.
AP170 AP180
AP181 AP190
AP255 AP265
AP81.1 AP90.5
CB06.2 CB10.1
CB145 CB15.1
CB15.2 CB150
CB180 CB181
CB185 CB186
CB187 CB190
CB191 CB20.1
CB20.6 CB25.1
CB30.1 CB46.1
CB500 CB543
CB544 CB80.1
CB82.1 CB99.3
CBO-BANK-END-BAL
Element: Intl Amt
Signed 18.2
The bank ending balance. Represents all reconciled transaction up through the run date of the report
AP170 AP180
AP181 AP190
AP255 AP265
AP81.1 AP90.5
CB06.2 CB10.1
CB145 CB15.1
CB15.2 CB150
CB180 CB181
CB185 CB186
CB187 CB190
CB191 CB20.1
CB20.6 CB25.1
CB30.1 CB46.1
CB500 CB543
CB544 CB80.1
CB82.1 CB99.3
CBO-OPEN-BEG-BAL
Element: Intl Amt
Signed 18.2
Open Beginning Balance. Represents all open transaction up to (but not including) the run date of the report.
AP170 AP180
AP181 AP190
AP255 AP265
AP81.1 AP90.5
CB06.2 CB10.1
CB145 CB15.1
CB15.2 CB150
CB180 CB181
CB185 CB186
CB187 CB190
CB191 CB20.1
CB20.6 CB25.1
CB30.1 CB46.1
CB500 CB543
CB544 CB80.1
CB82.1 CB99.5
CBO-ACCT-BEG-BAL
Element: Intl Amt
Signed 18.2
Accounting Beginning Balance. Represents all transactions posted to the cash code general ledger account up to (but not including) the run date of the report
AP170 AP180
AP181 AP190
AP255 AP265
AP81.1 AP90.5
CB06.2 CB10.1
CB145 CB15.1
CB15.2 CB150
CB180 CB181
CB185 CB186
CB187 CB190
CB191 CB20.1
CB20.6 CB25.1
CB30.1 CB46.1
CB500 CB543
CB544 CB80.1
CB82.1 CB99.4
CBO-ISSUED
Element: Intl Amt
Signed 18.2
Amount of all issues for the run 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
CB25.1 CB30.1
CB46.1 CB500
CB543 CB544
CB80.1 CB82.1
CBO-ISSUED-UNITS
Element: Nbr Of Trans
Signed 6.0
Number of CBTRANS records for the issued amount
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
CB25.1 CB30.1
CB46.1 CB500
CB543 CB544
CB80.1 CB82.1
CBO-RECONCILED
Element: Intl Amt
Signed 18.2
Amount of all reconciled transactions for the run 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
CB25.1 CB30.1
CB46.1 CB500
CB543 CB544
CB80.1 CB82.1
CBO-RECON-UNITS
Element: Nbr Of Trans
Signed 6.0
Number of CBTRANS records for the reconciled amount.
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
CB25.1 CB30.1
CB46.1 CB500
CB543 CB544
CB80.1 CB82.1
CBO-VOIDED
Element: Intl Amt
Signed 18.2
Amount of all voided transactions for the run 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
CB25.1 CB30.1
CB46.1 CB500
CB543 CB544
CB80.1 CB82.1
CBO-VOIDED-UNITS
Element: Nbr Of Trans
Signed 6.0
Number of CBTRANS records for the voided amount.
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
CB25.1 CB30.1
CB46.1 CB500
CB543 CB544
CB80.1 CB82.1
CBO-STOP-PAID
Element: Intl Amt
Signed 18.2
Amount of all stop paid transactions for the run date of the report.
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
CB25.1 CB30.1
CB46.1 CB500
CB543 CB544
CB80.1 CB82.1
CBO-STOP-UNITS
Element: Nbr Of Trans
Signed 6.0
Number of CBTRANS records for the stop paid amount.
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
CB25.1 CB30.1
CB46.1 CB500
CB543 CB544
CB80.1 CB82.1
CBO-ADJUSTMENTS
Element: Intl Amt
Signed 18.2
Amount of any reopened reconciled, voided, stop paid or staled dated record. Also any reconcile variance amouns.
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
CB25.1 CB30.1
CB46.1 CB500
CB543 CB544
CB80.1 CB82.1
CBO-STALE-DATED
Element: Intl Amt
Signed 18.2
Amount of all stale dated transactions for the run date of the report.
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
CB25.1 CB30.1
CB46.1 CB500
CB543 CB544
CB80.1 CB82.1
CBO-STALE-UNITS
Element: Nbr Of Trans
Signed 6.0
Number of CBTRANS records for the stale dated amount.
CBO-ESCHEATED
Element: Intl Amt
Signed 18.2
Amount of all escheated transactions for the run date of the report
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
CB25.1 CB30.1
CB46.1 CB500
CB543 CB544
CB80.1 CB82.1
CBO-ESCH-UNITS
Element: Nbr Of Trans
Signed 6.0
Number of CBTRANS records for the escheated amount.
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
CB25.1 CB30.1
CB46.1 CB500
CB543 CB544
CB80.1 CB82.1
CBO-OPEN-END-BAL
Element: Intl Amt
Signed 18.2
Open Ending Balance. Represents the open amount as of the run date of the report.
AP170 AP180
AP181 AP190
AP255 AP265
AP81.1 AP90.5
CB06.2 CB10.1
CB145 CB15.1
CB15.2 CB150
CB180 CB181
CB185 CB186
CB187 CB190
CB191 CB20.1
CB20.6 CB25.1
CB30.1 CB46.1
CB500 CB543
CB544 CB80.1
CB82.1 CB99.5
CBO-ACCT-END-BAL
Element: Intl Amt
Signed 18.2
Accounting End Balance. Represents the amount posted to the cash code general ledger account up to and including the run date of the report.
AP170 AP180
AP181 AP190
AP255 AP265
AP81.1 AP90.5
CB06.2 CB10.1
CB145 CB15.1
CB15.2 CB150
CB180 CB181
CB185 CB186
CB187 CB190
CB191 CB20.1
CB20.6 CB25.1
CB30.1 CB46.1
CB500 CB543
CB544 CB80.1
CB82.1 CB99.4
CBO-MAINT-DATE
Element: Maint Date
Numeric 8 (yyyymmdd)
The date last changed.
AP170 AP180
AP181 AP190
AP255 AP265
AP81.1 AP90.5
CB06.2 CB10.1
CB145 CB15.1
CB15.2 CB150
CB180 CB181
CB185 CB186
CB187 CB190
CB191 CB20.1
CB20.6 CB25.1
CB30.1 CB46.1
CB500 CB543
CB544 CB80.1
CB82.1 CB99.3
CB99.4 CB99.5
CBO-MAINT-TIME
Element: Maint Time
Numeric 6 (hhmmss)
The time last changed.
AP170 AP180
AP181 AP190
AP255 AP265
AP81.1 AP90.5
CB06.2 CB10.1
CB145 CB15.1
CB15.2 CB150
CB180 CB181
CB185 CB186
CB187 CB190
CB191 CB20.1
CB20.6 CB25.1
CB30.1 CB46.1
CB500 CB543
CB544 CB80.1
CB82.1 CB99.3
CB99.4 CB99.5


CBCONSOL FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
CBOSET1 CASH-CODE
BANK-INST-CODE
COMPANY
MAINT-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
CB25.1 CB30.1
CB46.1 CB500
CB543 CB544
CB80.1 CB82.1
CBOSET2 MAINT-DATE
CASH-CODE
COMPANY
BANK-INST-CODE
CB181 CBOP.1
CBOSET3 CASH-CODE
COMPANY
BANK-INST-CODE
MAINT-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
CB25.1 CB30.1
CB46.1 CB500
CB543 CB544
CB80.1 CB82.1
CBOSET4 CASH-CODE
BANK-INST-CODE
COMPANY
MAINT-DATE*
...
AP170 AP180
AP181 AP190
AP255 AP265
AP81.1 AP90.5
CB06.2 CB10.1
CB145 CB15.1
CB15.2 CB150
CB180 CB181
CB185 CB186
CB187 CB190
CB191 CB20.1
CB20.6 CB25.1
CB30.1 CB46.1
CB500 CB543
CB544 CB80.1
CBOSET5 CASH-CODE
MAINT-DATE*
COMPANY
BANK-INST-CODE
CB181 CB90.6
CB90.7 CB90.8
CB99.3 CB99.4
CB99.5


File created: Thu Jun 09 02:12:02 2016

Home
Contact Us



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