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.
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.
|
|