|
|
CBCTRANS FILE
Bank Transaction Conversion/In
The Bank Transaction Conversion file is used by the Bank Transaction Interface
program to convert or interface bank transaction records to the Lawson Cash
Ledger system and, optionally, to convert cash payment transaction records to
the Lawson Accounts Payable system.
When you run CB500 (Bank Transaction Interface), the system reads records in
this file for conversion or interface into the Cash Ledger Bank Transaction
file and, if applicable, the Accounts Payable Cash Payment file. When the Bank
Transaction Conversion file records are successfully converted or interfaced,
they are purged from this file.
UPDATED BY
CB500
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
CVC-CASH-CODE Alpha 4
Element: Cash Code Required. The cash code. Represents a
bank account. Must be a valid record in
the Cash Code file.
CVC-BANK-INST-CODE Alpha 3
Element: Transaction CoRequired. The bank transaction code.
Represents a type of cash payment, bill
of exchange payment, or bank service.
Must be a valid record in the Bank
Transaction Code file.
CVC-TRANS-NBR Alpha 10 (Right Justified) CB500
Element: Transaction NuRequired. The bank transaction number.
The value should be loaded right
justified. If loading a numeric value,
use leading spaces rather than leading
zeros.
CVC-COMPANY Numeric 4
Element: Company Required. The company number that
initiated the bank transaction. Must be
a valid record in the General Ledger
Company file and a valid relationship
record must exist in the Company-Cash
Code Relationship file. If the Source
Code field is AP, the Company field must
be the Pay Post Company assigned to the
pay group.
CVC-VENDOR Alpha 9 (Right Justified)
Element: Vendor Required if the Source Code field = AP.
This field contains the accounts payable
vendor number associated with the bank
transaction. Must be a valid record in
the Accounts Payable Vendor file. Load
numeric values right justified with
leading spaces.
CVC-REC-STATUS Numeric 1
Element: Reconcile StatRequired. The bank transaction record
status. Determines the status of the
bank transaction in the Lawson Cash
Ledger system. Valid values are:
1 = Open (Unreconciled).
2 = Reconciled.
3 = Voided.
CVC-SOURCE-CODE Alpha 2
Element: Source Code Required. Identifies the source of the
transaction. If this field = AP, CB500
(Bank Transaction Interface) will update
the Accounts Payable Cash Payment file.
Valid values are:
AP = Accounts Payable.
CB = Cash Ledger.
CVC-ISSUE-DATE Numeric 8 (yyyymmdd)
Element: Issue Date Required. The date of the bank
transaction.
CVC-ISSUE-BNK-AMT Signed 18.2
Account Currency Required. The amount of the bank
Issued Amount transaction in the currency of the bank
account.
CVC-ISSUE-BASE-AMT Signed 18.2 CB500
Base Currency Required if the bank account currency
Issued Amount is different from the company base
currency. The amount of the bank
transaction in the currency of the
company responsible for generating the
transaction.
CVC-RECON-DATE Numeric 8 (yyyymmdd)
Element: Reconcile DateRequired if the Record Status field = 2
(Reconciled) or 3 (Voided). The
reconciliation or void date of the bank
transaction.
CVC-RECON-BNK-AMT Signed 18.2
Acct Currency Required if the Record Status field = 2
Reconciled Amt (Reconciled). The amount of the bank
transaction recognized by the bank in
the currency of the bank account.
CVC-RECON-BASE-AMT Signed 18.2
Base Currency Required if the Record Status field = 2
Reconciled Amt (Reconciled) and the bank account
currency is different from the company
base currency. The reconciled amount of
the bank transaction in the company base
currency. If the bank account currency
is the same as the company base
currency, this value equals the amount
in the Account Currency Reconciled
Amount field.
CVC-DESCRIPTION Alpha 30 (Lower Case)
Element: Description The bank transaction description. The
field accepts both upper and lower case
entries.
CVC-REFERENCE Alpha 10 (Lower Case)
Element: Reference The reference value assigned to the
transaction. Used for informational
purposes.
CVC-DIS-ACCT-UNIT Alpha 15
Element: Accounting UniUse this field ONLY if the bank
transaction has NOT been posted to the
general ledger and you want CB500 (Bank
Transaction Interface) to create general
ledger transaction distributions. The
Record Status field must = 1
(Open/Unreconciled) or 2 (Reconciled),
and the Source Code field must = CB.
The general ledger distribution
accounting unit used for posting the
bank transaction. Must be a valid record
in the General Ledger Names file. If
present, CB500 creates unposted
transaction distribution records in the
Transaction Distribution file for this
account and offset transaction
distribution records for the cash
account. These transaction distributions
are posted to the general ledger when
you run CB175 (Bank Transaction
Posting).
Leave this field blank if the bank
transaction has already been posted to
the general ledger and you do NOT want a
general ledger distribution to be
created for the bank transaction.
CVC-DIS-ACCOUNT Numeric 6
Element: Account Use this field ONLY if the bank
transaction has NOT been posted to the
general ledger and you want CB500 (Bank
Transaction Interface) to create general
ledger transaction distributions. The
Record Status field must = 1
(Open/Unreconciled) or 2 (Reconciled).
The general ledger distribution account
number used for posting the bank
transaction. Must be a valid record in
the General Ledger Account Master file.
If present, CB500 creates unposted
transaction distribution records in the
Transaction Distribution file for this
account and offset transaction
distribution records for the cash
account. These transaction distributions
are posted to the general ledger when
you run CB175 (Bank Transaction
Posting).
Leave this field blank if the bank
transaction has already been posted to
the general ledger and you do NOT want a
general ledger distribution to be
created for the bank transaction.
CVC-DIS-SUB-ACCT Numeric 4
Element: Subaccount Use this field ONLY if the bank
transaction has NOT been posted to the
general ledger and you want CB500 (Bank
Transaction Interface) to create general
ledger transaction distributions. The
Record Status field must = 1
(Open/Unreconciled) or 2 (Reconciled).
The general ledger distribution
subaccount number used for posting the
bank transaction. Must be a valid record
in the General Ledger Account Master
file. If present, CB500 creates unposted
transaction distribution records in the
Transaction Distribution file for this
account and offset transaction
distribution records for the cash
account. These transaction distributions
are posted to the general ledger when
you run CB175 (Bank Transaction
Posting).
Leave this field blank if the bank
transaction has already been posted to
the general ledger and you do NOT want a
general ledger distribution to be
created for the bank transaction.
CVC-TAX-CODE Alpha 10
Element: Tax Code Use this field ONLY if you want CB500
(Bank Transaction Interface) to create a
general ledger tax distribution for the
bank transaction.
The tax code associated with the bank
transaction. Used to calculate bank
transaction tax information. Must be a
valid record in the Tax Code file. If
present, CB500 creates an unposted tax
distribution record for the Tax Amount
in the Transaction Distribution file.
The difference between the Transaction
Amount and the Tax Amount will be posted
to the Distribution Account assigned to
the bank transaction.
Leave this field blank if the bank
transaction has already been posted to
the general ledger and you do NOT want a
general ledger tax distribution to be
created for the bank transaction.
CVC-TRAN-TAXABLE Signed 18.2
Element: Taxable Required if a Tax Code is present. The
taxable amount of the bank transaction.
CVC-TRAN-TAX-AMT Signed 18.2 CB500
Element: Tax Amount Use this field ONLY if you want CB500
(Bank Transaction Interface) to create a
general ledger tax distribution for the
bank transaction.
The tax amount of the bank transaction.
If left blank and a Tax Code is present,
this amount will be calculated.
Represents the amount to be posted to
the general ledger for the tax
distribution. If present, CB500 creates
an unposted tax distribution record for
the Tax Amount in the Transaction
Distribution file. The difference
between the Transaction Amount and the
Tax Amount will be posted to the
Distribution Account assigned to the
bank transaction.
Leave this field blank if the bank
transaction has already been posted to
the general ledger and you do NOT want a
general ledger tax distribution to be
created for the bank transaction.
CVC-JRNL-BOOK-NBR Alpha 12
Element: Jouranl Book NUse this field ONLY if you want CB500
(Bank Transaction Interface) to create a
general ledger journal book distribution
for the bank transaction.
The journal book associated with the
bank transaction. Must be a valid record
in the Journal Book Header file.
Leave this field blank if the bank
transaction has already been posted to
the general ledger and you do NOT want a
general ledger tax distribution to be
created for the bank transaction.
CVC-ISSUE-TRAN-AMT Signed 18.2 CB500
Element: Issue Amount The amount of the transaction in the
currency of the transaction.
CVC-BNK-CNV-RATE Signed 14.7 CB500
Element: Bank ConversioThe exchange rate used to convert the
transaction currency to the bank account
currency.
CVC-CURRENCY-CODE Alpha 5 CB500
Element: Currency Code The currency of the transaction. Must be
a valid record in the Lawson Currency
system.
CVC-BANK-ND Numeric 1 CB500
Bank Number of The number of decimal positions defined
Decimals for the bank account currency.
CVC-TRAN-ND Numeric 1 CB500
transaction Number The number of decimal positions defined
of Decimals for the transaction currency.
CVC-STMT-STATUS Numeric 1
Element: Statement StatThe status of the bank statement
associated with the transaction.
CVC-PAY-GROUP Alpha 4
Element: Pay Group The pay group assigned to the
transaction. This field is required if
the Source Code field is AP.
CVC-ORIG-CNV-RATE Signed 14.7 CB500
Original Conversion Represents the currency exchange rate
Rate the transaction was created with.
CVC-SEGMENT-BLOCK Alpha 103
Element: Segment Block This field identifies the user analysis
values included in the transaction.
You can either type up to four values
or use Define (F6) to open the User
Analysis Entry subform. Use this subform
to select the user analysis values you
want to include in the transaction. If
you choose to type values, use commas to
separate them. For example:
value1,value2,value3,value4
There are three conditions that affect
how you can select user analysis values.
See the User Analysis Entry form help or
the Strategic Ledger procedures manual
for additional information.
CVC-SOURCE Alpha 1
Element: Source The source of the transaction. Input or
output. Input transactions are Accounts
Payable. Output transactions are
Accounts Receivable.
CVC-ACTIVITY Alpha 15
Element: Activity Activities are the processes or
procedures that produce work. Cost
objects (products, services, customers,
and so on) are the reasons for
performing the activity.
CVC-ACCT-CATEGORY Alpha 5 CB500
Element: Account CategoAccount categories are groupings of
costs, revenues, or a combination of
both used for reporting and inquiries
for activities in the Activity
Management system. All transactions are
posted to an account category within an
activity. You can assign a specific
General Ledger account or range of
accounts (company, accounting unit,
account, and subaccount) that make up
the transactions posted to an account
category using AC07.1 (Account
Assignment).
Period-to-date, year-to-date, and
life-to-date balances are maintained by
account category for activities. Account
categories must be assigned to
activities before you do any budgeting
or transaction processing.
Valid account category types are:
cost
revenue
accrual
pass thru
CVC-ANALYSIS-FLD Alpha 32
Element: User Analysis The user-defined analysis field
assigned to the bank transaction
distribution.
CBCTRANS FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
CVCSET1 CASH-CODE This index is used to access bank CB500
BANK-INST-CODEtransaction conversion or interface
TRANS-NBR records from the bank transaction
conversion/interface file.
|
