|
|
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
CB50.1 CB500
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
CVC-RUN-GROUP Alpha 15 CB50.1
Element: Run Group Run Group and Seq Number are the keys
to the file. They should be used to
group records together for interfacing.
CVC-CASH-CODE Alpha 4 CB50.1
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 CB50.1
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) CB50.1 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-SEQ-NBR Numeric 4 CB50.1
Element: Seq Nbr An automatically assigned sequence
number.
CVC-COMPANY Numeric 4 CB50.1
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) CB50.1
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 CB50.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 CB50.1
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.
All valid source codes are allowed
with
the exception of AR.
CVC-ISSUE-DATE Numeric 8 (yyyymmdd) CB50.1
Element: Issue Date Required. The date of the bank
transaction.
CVC-ISSUE-BNK-AMT Signed 18.2 CB50.1
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 CB50.1
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) CB50.1 CB500
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 CB50.1 CB500
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 CB50.1
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) CB50.1
Element: Description The bank transaction description. The
field accepts both upper and lower case
entries.
CVC-REFERENCE Alpha 10 (Lower Case) CB50.1
Element: Reference The reference value assigned to the
transaction. Used for informational
purposes.
CVC-DIS-ACCT-UNIT Alpha 15 CB50.1
Element: Acct Unit 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),
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 CB50.1
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 CB50.1
Element: Sub Acct 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 CB50.1
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 CB50.1
Element: Taxable Required if a Tax Code is present. The
taxable amount of the bank transaction.
CVC-TRAN-TAX-AMT Signed 18.2 CB50.1 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 CB50.1
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 CB50.1
Element: Issue Amount The amount of the transaction in the
currency of the transaction.
CVC-BNK-CNV-RATE Signed 14.7 CB50.1
Element: Bank ConversioThe exchange rate used to convert the
transaction currency to the bank account
currency.
CVC-CURRENCY-CODE Alpha 5 CB50.1 CB500
Element: Currency Code The currency of the transaction. Must
be a valid record in the Lawson Currency
system.
CVC-BANK-ND Numeric 1 CB50.1
Bank Number of The number of decimal positions defined
Decimals for the bank account currency.
CVC-TRAN-ND Numeric 1 CB50.1
transaction Number The number of decimal positions defined
of Decimals for the transaction currency.
CVC-STMT-STATUS Numeric 1 CB50.1
Element: Statement StatThe status of the bank statement
associated with the transaction.
CVC-PAY-GROUP Alpha 4 CB50.1
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 CB50.1
Original Conversion The currency rate.
Rate
CVC-SEGMENT-BLOCK Alpha 103 CB50.1
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 CB50.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 CB50.1
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 CB50.1 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 Currently not in use.
CVC-USER-FIELD1 Alpha 30 CB50.1
Element: User Field1 This is the first user definable field.
It can be used to capture any data that
the user wants. The title of the field
is setup in IC00.
CVC-USER-FIELD2 Alpha 30 CB50.1
Element: User Field2 This is the second user definable
field. This field can be used to enter
any data that the user wants to capture
for this item. The title of the field
is setup in IC00.
CVC-USER-FIELD3 Alpha 30 CB50.1
Element: User Field1 This is the first user definable field.
It can be used to capture any data that
the user wants. The title of the field
is setup in IC00.
CVC-USER-FIELD4 Alpha 30 CB50.1
Element: User Field2 This is the second user definable
field. This field can be used to enter
any data that the user wants to capture
for this item. The title of the field
is setup in IC00.
CVC-POST-DATE Numeric 8 (yyyymmdd) CB50.1 CB500
Element: Dist Date The general ledger posting date that
the general ledger transactions created
for this record will use.
CVC-DIS-COMPANY Numeric 4 CB50.1 CB500
Element: Company Identifies the AP company if the
resource type = V. Identifies the HR
company if the resource type = E. It is
blank for type A, P or Q resources.
CVC-DIS-SEG-BLOCK Alpha 103 CB50.1
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.
CBCTRANS FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
CVCSET1 RUN-GROUP CB50.1 CB500
CASH-CODE
BANK-INST-CODE
TRANS-NBR
SEQ-NBR
|
