CBCTRANS – Bank Transaction Conversion/In

System: Cash Ledger (CB)
Prefix: CVC
Primary key: RUN-GROUP, CASH-CODE, BANK-INST-CODE, TRANS-NBR, SEQ-NBR
Fields: 44
Updated by: 2 programs
Referenced by: 0 programs

CBCTRANS is the Bank Transaction Conversion/In table in Lawson Cash Ledger (prefix CVC). It is indexed by RUN-GROUP, CASH-CODE, BANK-INST-CODE, TRANS-NBR, SEQ-NBR (CVCSET1). It is updated by CB50.1 and CB500. The table has 44 fields, 1 index and 0 documented relations.

About CBCTRANS

No description in the Lawson data dictionary.

Fields (44)

Column = COBOL field name without the CVC- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / column	Type	Description & values	Updated by
`CVC-RUN-GROUP` PK 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` PK 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` PK BANK_INST_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` PK TRANS_NBR	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` PK SEQ_NBR	Numeric 4	An automatically assigned sequence number.	CB50.1
`CVC-COMPANY` 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` 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` REC_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` 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` ISSUE_DATE	Numeric 8 (yyyymmdd)	Required. The date of the bank transaction.	CB50.1
`CVC-ISSUE-BNK-AMT` ISSUE_BNK_AMT	Signed 18.2	Required. The amount of the bank transaction in the currency of the bank account.	CB50.1
`CVC-ISSUE-BASE-AMT` ISSUE_BASE_AMT	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` RECON_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` RECON_BNK_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` RECON_BASE_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` DESCRIPTION	Alpha 30 (Lower Case)	The bank transaction description. The field accepts both upper and lower case entries.	CB50.1
`CVC-REFERENCE` REFERENCE	Alpha 10 (Lower Case)	The reference value assigned to the transaction. Used for informational purposes.	CB50.1
`CVC-DIS-ACCT-UNIT` DIS_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` DIS_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` DIS_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` 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` TRAN_TAXABLE	Signed 18.2	Required if a Tax Code is present. The taxable amount of the bank transaction.	CB50.1
`CVC-TRAN-TAX-AMT` TRAN_TAX_AMT	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` JRNL_BOOK_NBR	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` ISSUE_TRAN_AMT	Signed 18.2	The amount of the transaction in the currency of the transaction.	CB50.1
`CVC-BNK-CNV-RATE` BNK_CNV_RATE	Signed 14.7	The exchange rate used to convert the transaction currency to the bank account currency.	CB50.1
`CVC-CURRENCY-CODE` 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_ND	Numeric 1	The number of decimal positions defined for the bank account currency.	CB50.1
`CVC-TRAN-ND` TRAN_ND	Numeric 1	The number of decimal positions defined for the transaction currency.	CB50.1
`CVC-STMT-STATUS` STMT_STATUS	Numeric 1	The status of the bank statement associated with the transaction.	CB50.1
`CVC-PAY-GROUP` 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` ORIG_CNV_RATE	Signed 14.7	The currency rate.	CB50.1
`CVC-SEGMENT-BLOCK` 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` 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` 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` ACCT_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` ANALYSIS_FLD	Alpha 32	Currently not in use.	—
`CVC-USER-FIELD1` 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` 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` USER_FIELD3	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` USER_FIELD4	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` POST_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` DIS_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` DIS_SEG_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

Indexes (1)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

Index	Keys	Flags	Condition	Used in
`CVCSET1`	`RUN-GROUP`, `CASH-CODE`, `BANK-INST-CODE`, `TRANS-NBR`, `SEQ-NBR`	Primary		CB50.1, CB500

Programs

Updated by (2)

CB50.1 Bank Transaction Interface Maintenance
CB500 Bank Transaction Interface