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