CBTRFHDR – Fund Transfer

System
Cash Ledger (CB)
Prefix
CBH
Primary key
CASH-CODE, TRANSFER-NBR
Fields
25
Updated by
4 programs
Referenced by
13 programs

CBTRFHDR is the Fund Transfer table in Lawson Cash Ledger (prefix CBH). It is indexed by CASH-CODE, TRANSFER-NBR (CBHSET1); alternate indexes: CBHSET2. It is related 1:1 to CBBANKENT, CBBANKINST, CBCASHCODE, CBTRFTABLE and GLADDRESS and 1:M to CBTRFDTL. It is updated by CB15.1, CB15.2, CB150 and CB300 and referenced by CB06.2, CB10.1, CB195, CB20.1, CB215, CB221, CB43.1, CB44.1 and 5 more. The table has 25 fields, 2 indexes and 6 documented relations.

About CBTRFHDR

The Fund Transfer file contains bank fund transfer records.

Fields (25)

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

Field / columnTypeDescription & valuesUpdated by
CBH-CASH-CODE PK
CASH_CODE		Alpha 4The cash code. If the Transfer Type code represents the bank account you are transferring funds from for deposit into one or more other bank accounts. If the Transfer Type field = 2 (Many Withdrawals), this cash code represents the bank account you are transferring funds to from withdrawals made from one or more other bank accounts. Must be a valid record in the Cash Code file and have a valid record in the Fund Transfer Table file.
  • field 1 (Many Deposits), this cash
CB15.1, CB15.2
CBH-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
CBH-TRANSFER-TYPE
TRANSFER_TYPE		Alpha 1Identifies the type of bank fund transfer (and the screen the bank fund transfer was entered on). Valid values are: Funds are being transferred from one bank account (cash code) to one or more other bank accounts. CB15.2). Funds are being transferred to one bank account (cash code) from one or more other bank accounts.
  • 1 Many Deposits (entered in CB15.1).
  • 2 Many Withdrawals (entered in
CB15.1, CB15.2
CBH-COMPANY
COMPANY		Numeric 4The company number of the company initiating the bank transfer. Must be a valid record in the General Ledger Company file and have a valid relationship record in the Company-Cash Code Relationship file.CB15.1, CB15.2
CBH-TRANSFER-AMT
TRANSFER_AMT		Signed 18.2The amount of the fund transfer in the bank account currency of the Cash Code. If the Transfer Type field = 1 (Many Deposits), this amount represents the amount to be transferred from the Cash Code. If the Transfer Type field = 2 (Many Withdrawals), this amount represents the amount to be transferred to the Cash Code.CB15.1, CB15.2
CBH-APPLIED-AMT
APPLIED_AMT		Signed 18.2The total distribution amount of the bank fund transfer in the currency of the Cash Code (the total Transfer Detail file records). If the Transfer Type represents the total amount to be deposited based on funds withdrawn from the Cash Code. If the Transfer Type amount represents the total amount to be withdrawn for transfer to the Cash Code. This amount must equal the Transfer Amount before the bank fund transfer can be released.
  • field 1 (Many Deposits), this amount
  • field 2 (Many Withdrawals), this
CB15.1, CB15.2
CBH-CPY-BASE-AMT
CPY_BASE_AMT		Signed 18.2The amount of the fund transfer in the base currency of the Company responsible for initiating the transfer.CB15.1, CB15.2
CBH-BASE-APPL-AMT
BASE_APPL_AMT		Signed 18.2The total distribution amount of the bank fund transfer in the base currency of the Company responsible for initiating the transfer.CB15.1, CB15.2
CBH-TRANSFER-DATE
TRANSFER_DATE		Numeric 8 (yyyymmdd)The date funds will be transferred. If left blank, the system date defaults.CB15.1, CB15.2
CBH-POST-DATE
POST_DATE		Numeric 8 (yyyymmdd)The date used for posting the bank fund transfer to the general ledger. If left blank, the Transfer Date is used.CB15.1, CB15.2
CBH-BEXP-TRAN-AMT
BEXP_TRAN_AMT		Signed 18.2If the Transfer Type field = 1 (Many Deposits), this field contains the amount charged by the bank for the fund transfer. This amount is in the bank account currency defined for the Cash Code.CB15.1
CBH-BEXP-BASE-AMT
BEXP_BASE_AMT		Signed 18.2The amount charged by the bank for the fund transfer in the base currency of the Company responsible for initiating the transfer.CB15.1
CBH-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.1
CBH-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.1
CBH-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.1
CBH-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.1
CBH-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.1
CBH-BANK-INST-CODE
BANK_INST_CODE		Alpha 3The transaction code. If the Transfer Type field = 1 (Many Deposits), this field contains the transaction code used for transferring funds from the 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. If the Transfer Type field = 2 (Many Withdrawals), this field contains the transaction code used for transferring funds to the 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.CB15.1, CB15.2
CBH-EXCHANGE-RATE
EXCHANGE_RATE		Signed 14.7The currency exchange rate used for converting transfer amounts from the bank account currency of the Cash Code to the base currency of the Company responsible for initiating the transfer.CB15.1, CB15.2
CBH-REC-STATUS
REC_STATUS		Numeric 1The status of the transaction. Valid values are:
  • 0 Unreleased.
  • 1 Released.
CB15.1, CB15.2, CB150
CBH-DESCRIPTION
DESCRIPTION		Alpha 30 (Lower Case)The description of the bank fund transfer.CB15.1, CB15.2
CBH-JRNL-BOOK-NBR
JRNL_BOOK_NBR		Alpha 12The journal book assigned to the transaction.CB15.1, CB15.2
CBH-TRF-DIFFERENCE
TRF_DIFFERENCE		DerivedThe difference between the Transfer Amount and Applied Amount in the bank account currency defined for the Cash Code.—
CBH-TRF-TYPE-DESC
TRF_TYPE_DESC		DerivedA description of the Transfer Type.—
CBH-JBK-SEQ-NBR
JBK_SEQ_NBR		Numeric 10The journal book sequence number assigned to a journal book transaction when it is added or interfaced to the Lawson system. Used only when Auto Journal Book Seq Nbr is set to Yes in GL10.1 (Company).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
CBHSET1CASH-CODE, TRANSFER-NBRPrimaryCB06.2, CB10.1, CB15.1, CB15.2, CB150, CB20.1, CB215, CB300 +7 more
CBHSET2CASH-CODE, TRANSFER-NBRSubsetWhere REC-STATUS = ZeroesCB150, CB195, CB221

Relations

One to one (5) — lookups and parents

RelationTableRulesConditionField map
CbbankentCBBANKENTRequiredCBC-BANK-ENTITY → CBE-BANK-ENTITY
CbbankinstCBBANKINSTRequiredCBH-BANK-INST-CODE → CBI-BANK-INST-CODE
CbcashcodeCBCASHCODERequiredCBH-CASH-CODE → CBC-CASH-CODE
CbtrftableCBTRFTABLERequiredCBH-CASH-CODE → CBX-CASH-CODE
GladdressGLADDRESSRequiredCBH-COMPANY → GAD-COMPANY, Spaces → GAD-ACCT-UNIT

One to many (1) — child tables

RelationTableRulesConditionField map
CbtrfdtlCBTRFDTLCBH-CASH-CODE → CBL-CASH-CODE, CBH-TRANSFER-NBR → CBL-TRANSFER-NBR, → CBL-DTL-CASH-CODE

Programs

Updated by (4)

Referenced by (13)