CBCTRANS

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

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
CVCSET1 RUN-GROUP
CASH-CODE
BANK-INST-CODE
TRANS-NBR
SEQ-NBR
CB50.1 CB500


File created: Wed Jun 08 20:48:21 2016

Home
Contact Us



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