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.
UPDATED BY
| 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.
|
|
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.
|
|
CBO-COMPANY
Element: Company | Numeric 4
Identifies the cash code company.
|
|
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.
|
|
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
|
|
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.
|
|
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
|
|
CBO-ISSUED
Element: Intl Amt | Signed 18.2
Amount of all issues for the run date
|
|
CBO-ISSUED-UNITS
Element: Nbr Of Trans | Signed 6.0
Number of CBTRANS records for the
issued amount
|
|
CBO-RECONCILED
Element: Intl Amt | Signed 18.2
Amount of all reconciled transactions
for the run date.
|
|
CBO-RECON-UNITS
Element: Nbr Of Trans | Signed 6.0
Number of CBTRANS records for the
reconciled amount.
|
|
CBO-VOIDED
Element: Intl Amt | Signed 18.2
Amount of all voided transactions for
the run date.
|
|
CBO-VOIDED-UNITS
Element: Nbr Of Trans | Signed 6.0
Number of CBTRANS records for the
voided amount.
|
|
CBO-STOP-PAID
Element: Intl Amt | Signed 18.2
Amount of all stop paid transactions
for the run date of the report.
|
|
CBO-STOP-UNITS
Element: Nbr Of Trans | Signed 6.0
Number of CBTRANS records for the stop
paid amount.
|
|
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.
|
|
CBO-STALE-DATED
Element: Intl Amt | Signed 18.2
Amount of all stale dated transactions
for the run date of the report.
|
|
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
|
|
CBO-ESCH-UNITS
Element: Nbr Of Trans | Signed 6.0
Number of CBTRANS records for the
escheated amount.
|
|
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.
|
|
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.
|
|
CBO-MAINT-DATE
Element: Maint Date | Numeric 8 (yyyymmdd)
The date last changed.
|
|
CBO-MAINT-TIME
Element: Maint Time | Numeric 6 (hhmmss)
The time last changed.
|
|
