CBTRFDTL – Fund Transfer Detail

System
Cash Ledger (CB)
Prefix
CBL
Primary key
CASH-CODE, TRANSFER-NBR, DTL-CASH-CODE
Fields
19
Updated by
3 programs
Referenced by
13 programs

CBTRFDTL is the Fund Transfer Detail table in Lawson Cash Ledger (prefix CBL). It is indexed by CASH-CODE, TRANSFER-NBR, DTL-CASH-CODE (CBLSET1); alternate indexes: CBLSET3. It is related 1:1 to CBBANKENT, CBBANKINST, CBCASHCODE, CBTRFHDR, CBTRFTABLE and GLSYSTEM. It is updated by CB15.1, CB15.2 and CB300 and referenced by CB06.2, CB10.1, CB150, CB175, CB195, CB20.1, CB215, CB43.1 and 5 more. The table has 19 fields, 2 indexes and 9 documented relations.

About CBTRFDTL

The Fund Transfer Detail file contains all distributions associated with a bank fund transfer.

Fields (19)

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

Field / columnTypeDescription & valuesUpdated by
CBL-CASH-CODE PK
CASH_CODE		Alpha 4The cash code. Represents either the bank account you are transferring funds from for multiple deposits or the bank account you are transferring funds to from multiple withdrawals. If the Transfer Type field of the associated Fund Transfer file record = 1 (Many Deposits), this cash code represents the bank account you are transferring funds from for deposit into the Detail Cash Code. If the Transfer Type field of the associated Fund Transfer file record = 2 (Many Withdrawals), this cash code represents the bank account you are transferring funds to from a withdrawal made from the Detail Cash Code. Must be a valid record in the Cash Code file.CB15.1, CB15.2
CBL-TRANSFER-NBR PK
TRANSFER_NBR		Alpha 10 (Right Justified)A user-defined identification number used to identify the bank fund transfer.CB15.1, CB15.2
CBL-DTL-CASH-CODE PK
DTL_CASH_CODE		Alpha 4The cash code representing the bank account a deposit is being made to or a withdrawal is being made from. If the Transfer Type field of the associated Fund Transfer file record = 1 (Many Deposits), this cash code represents the bank account you are depositing funds to based on a transfer from the Cash Code. If the Transfer Type field of the associated Fund Transfer file record = 2 (Many Withdrawals), this cash code represents the bank account you are withdrawing funds from based on a transfer to the Cash Code. Must be a valid record in the Cash Code file.CB15.1, CB15.2
CBL-DTL-COMPANY
DTL_COMPANY		Numeric 4The company associated with the Detail Cash Code. Must be a valid record in the General Ledger Company file and have a valid relationship record in the Intercompany Relationship file. If left blank, the company responsible for initiating the fund transfer defaults (the Company field of the associated Fund Transfer file record).CB15.1, CB15.2
CBL-DTL-TRAN-AMT
DTL_TRAN_AMT		Signed 18.2The amount of the transfer in the bank account currency of the Detail Cash Code.CB15.1, CB15.2
CBL-DTL-BASE-AMT
DTL_BASE_AMT		Signed 18.2The amount of the transfer in the base currency of the Detail Company.CB15.1, CB15.2
CBL-HDR-TRAN-AMT
HDR_TRAN_AMT		Signed 18.2The amount to be deposited to the Detail Cash Code in the bank account currency of the Header Cash Code.CB15.1, CB15.2
CBL-HDR-BASE-AMT
HDR_BASE_AMT		Signed 18.2The amount to be deposited to the Detail Cash Code in the base currency of the company responsible for initiating the transfer.CB15.1, CB15.2
CBL-DTL-EXCH-RATE
DTL_EXCH_RATE		Signed 14.7The currency exchange rate used for converting transfer amounts from the bank account currency of the Detail Cash Code to the base currency of the Detail Company.CB15.1, CB15.2
CBL-HDR-EXCH-RATE
HDR_EXCH_RATE		Signed 14.7The currency exchange rate used for converting transfer amounts from the bank account currency of the Header Cash Code to the base currency of the Company responsible for initiating the transfer.CB15.1, CB15.2
CBL-BANK-INST-CODE
BANK_INST_CODE		Alpha 3The transaction code. If the Detail Transfer Amount represents a deposit to the Detail Cash Code, this field contains the transaction code used for transferring funds to the Detail Cash Code as defined in the Fund Transfer Table file. Must be a valid bank credit type bank service transaction code in the Bank Transaction Code file. If the Detail Transfer Amount represents a withdrawal from the Detail Cash Code, this field contains the transaction code used for transferring funds from the Detail Cash Code as defined in the Fund Transfer Table file. Must be a valid bank debit type bank service transaction code in the Bank Transaction Code file.CB15.1, CB15.2
CBL-BEXP-TRAN-AMT
BEXP_TRAN_AMT		Signed 18.2The amount charged by the bank for the fund transfer in the bank account currency defined for the Detail Cash Code. This field is used only if the Detail Transfer Amount represents a withdrawal from the Detail Cash Code.CB15.2
CBL-BEXP-BASE-AMT
BEXP_BASE_AMT		Signed 18.2The amount charged by the bank for the fund transfer in the base currency of the Detail Company.CB15.2
CBL-BEXP-ACCT-UNIT
BEXP_ACCT_UNIT		Alpha 15The general ledger accounting unit used for posting the bank expense. Must be a valid record in the General Ledger Names file.CB15.2
CBL-BEXP-ACCOUNT
BEXP_ACCOUNT		Numeric 6The general ledger account number used for posting the bank expense. Must be a valid record in the General Ledger Account Master file.CB15.2
CBL-BEXP-SUB-ACCT
BEXP_SUB_ACCT		Numeric 4The general ledger subaccount number used for posting the bank expense. Must be a valid record in the General Ledger Account Master file.CB15.2
CBL-BEXP-ACTIVITY
BEXP_ACTIVITY		Alpha 15Activities are the processes or procedures that produce work. Cost objects (products, services, customers, and so on) are the reasons for performing the activity.CB15.2
CBL-BEXP-ACCT-CAT
BEXP_ACCT_CAT		Alpha 5Account 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 thruCB15.2
CBL-JRNL-BOOK-NBR
JRNL_BOOK_NBR		Alpha 12The journal book assigned to the transaction.CB15.1, CB15.2

Indexes (2)

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

IndexKeysFlagsConditionUsed in
CBLSET1CASH-CODE, TRANSFER-NBR, DTL-CASH-CODEPrimaryCB15.1, CB15.2, CB150, CB175, CB195, CB215, CB300
CBLSET3DTL-CASH-CODE, TRANSFER-NBR, CASH-CODEKeyChangeCB06.2, CB10.1, CB15.1, CB15.2, CB20.1, CB43.1, CB44.1, CB45.1 +3 more

Relations

One to one (9) — lookups and parents

RelationTableRulesConditionField map
Cbbankent DtlCBBANKENTRequiredCBC-BANK-ENTITY → CBE-BANK-ENTITY
Cbbankent HdrCBBANKENTRequiredCBC-BANK-ENTITY → CBE-BANK-ENTITY
CbbankinstCBBANKINSTRequiredCBL-BANK-INST-CODE → CBI-BANK-INST-CODE
CbcashcodeCBCASHCODERequiredCBL-CASH-CODE → CBC-CASH-CODE
Cbcashcode DtlCBCASHCODERequiredCBL-DTL-CASH-CODE → CBC-CASH-CODE
CbtrfhdrCBTRFHDRRequiredCBL-CASH-CODE → CBH-CASH-CODE, CBL-TRANSFER-NBR → CBH-TRANSFER-NBR
CbtrftableCBTRFTABLERequiredCBL-CASH-CODE → CBX-CASH-CODE
Glsystem DtlGLSYSTEMRequiredCBL-DTL-COMPANY → GLS-COMPANY
Glsystem HdrGLSYSTEMRequiredCBH-COMPANY → GLS-COMPANY

Programs

Updated by (3)

Referenced by (13)