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 Element: Run Group	Alpha 15 Run Group and Seq Number are the keys to the file. They should be used to group records together for interfacing.	CB50.1
CVC-CASH-CODE Element: Cash Code	Alpha 4 Required. The cash code. Represents a bank account. Must be a valid record in the Cash Code file.	CB50.1
CVC-BANK-INST-CODE Element: Transaction Code	Alpha 3 Required. 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.	CB50.1
CVC-TRANS-NBR Element: Transaction Number	Alpha 10 (Right Justified) Required. The bank transaction number. The value should be loaded right justified. If loading a numeric value, use leading spaces rather than leading zeros.	CB50.1 CB500
CVC-SEQ-NBR Element: Seq Nbr	Numeric 4 An automatically assigned sequence number.	CB50.1
CVC-COMPANY Element: Company	Numeric 4 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.	CB50.1
CVC-VENDOR Element: Vendor	Alpha 9 (Right Justified) 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.	CB50.1
CVC-REC-STATUS Element: Reconcile Status	Numeric 1 Required. 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.	CB50.1
CVC-SOURCE-CODE Element: Source Code	Alpha 2 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.	CB50.1
CVC-ISSUE-DATE Element: Issue Date	Numeric 8 (yyyymmdd) Required. The date of the bank transaction.	CB50.1
CVC-ISSUE-BNK-AMT Account Currency Issued Amount	Signed 18.2 Required. The amount of the bank transaction in the currency of the bank account.	CB50.1
CVC-ISSUE-BASE-AMT Base Currency Issued Amount	Signed 18.2 Required if the bank account currency is different from the company base currency. The amount of the bank transaction in the currency of the company responsible for generating the transaction.	CB50.1
CVC-RECON-DATE Element: Reconcile Date	Numeric 8 (yyyymmdd) Required if the Record Status field = 2 (Reconciled) or 3 (Voided). The reconciliation or void date of the bank transaction.	CB50.1 CB500
CVC-RECON-BNK-AMT Acct Currency Reconciled Amt	Signed 18.2 Required if the Record Status field = 2 (Reconciled). The amount of the bank transaction recognized by the bank in the currency of the bank account.	CB50.1 CB500
CVC-RECON-BASE-AMT Base Currency Reconciled Amt	Signed 18.2 Required if the Record Status field = 2 (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.	CB50.1
CVC-DESCRIPTION Element: Description	Alpha 30 (Lower Case) The bank transaction description. The field accepts both upper and lower case entries.	CB50.1
CVC-REFERENCE Element: Reference	Alpha 10 (Lower Case) The reference value assigned to the transaction. Used for informational purposes.	CB50.1
CVC-DIS-ACCT-UNIT Element: Acct Unit	Alpha 15 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.	CB50.1
CVC-DIS-ACCOUNT Element: Account	Numeric 6 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.	CB50.1
CVC-DIS-SUB-ACCT Element: Sub Acct	Numeric 4 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.	CB50.1
CVC-TAX-CODE Element: Tax Code	Alpha 10 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.	CB50.1
CVC-TRAN-TAXABLE Element: Taxable	Signed 18.2 Required if a Tax Code is present. The taxable amount of the bank transaction.	CB50.1
CVC-TRAN-TAX-AMT Element: Tax Amount	Signed 18.2 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.	CB50.1 CB500
CVC-JRNL-BOOK-NBR Element: Jouranl Book Number	Alpha 12 Use 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.	CB50.1
CVC-ISSUE-TRAN-AMT Element: Issue Amount	Signed 18.2 The amount of the transaction in the currency of the transaction.	CB50.1
CVC-BNK-CNV-RATE Element: Bank Conversion Rate	Signed 14.7 The exchange rate used to convert the transaction currency to the bank account currency.	CB50.1
CVC-CURRENCY-CODE Element: Currency Code	Alpha 5 The currency of the transaction. Must be a valid record in the Lawson Currency system.	CB50.1 CB500
CVC-BANK-ND Bank Number of Decimals	Numeric 1 The number of decimal positions defined for the bank account currency.	CB50.1
CVC-TRAN-ND transaction Number of Decimals	Numeric 1 The number of decimal positions defined for the transaction currency.	CB50.1
CVC-STMT-STATUS Element: Statement Status	Numeric 1 The status of the bank statement associated with the transaction.	CB50.1
CVC-PAY-GROUP Element: Pay Group	Alpha 4 The pay group assigned to the transaction. This field is required if the Source Code field is AP.	CB50.1
CVC-ORIG-CNV-RATE Original Conversion Rate	Signed 14.7 The currency rate.	CB50.1
CVC-SEGMENT-BLOCK Element: Segment Block	Alpha 103 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.	CB50.1
CVC-SOURCE Element: Source	Alpha 1 The source of the transaction. Input or output. Input transactions are Accounts Payable. Output transactions are Accounts Receivable.	CB50.1
CVC-ACTIVITY Element: Activity	Alpha 15 Activities are the processes or procedures that produce work. Cost objects (products, services, customers, and so on) are the reasons for performing the activity.	CB50.1
CVC-ACCT-CATEGORY Element: Account Category	Alpha 5 Account 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	CB50.1 CB500
CVC-ANALYSIS-FLD Element: User Analysis	Alpha 32 Currently not in use.
CVC-USER-FIELD1 Element: User Field1	Alpha 30 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.	CB50.1
CVC-USER-FIELD2 Element: User Field2	Alpha 30 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.	CB50.1
CVC-USER-FIELD3 Element: User Field1	Alpha 30 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.	CB50.1
CVC-USER-FIELD4 Element: User Field2	Alpha 30 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.	CB50.1
CVC-POST-DATE Element: Dist Date	Numeric 8 (yyyymmdd) The general ledger posting date that the general ledger transactions created for this record will use.	CB50.1 CB500
CVC-DIS-COMPANY Element: Company	Numeric 4 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.	CB50.1 CB500
CVC-DIS-SEG-BLOCK Element: Segment Block	Alpha 103 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.	CB50.1

CBCTRANS FILE INDEX

All trademarks and registered trademarks are the property of their respective owners.