Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

CBCTRANS


                             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