Fund Transfer

The Fund Transfer file contains bank fund transfer records.

REFERENCED BY

CB06.2	CB10.1	CB20.1	CB215	CB43.1	CB44.1
CB45.1	CB46.1	CB500	CB543	CB544	CB195
CB221

UPDATED BY

CB15.1

CB15.2

CB150

CB300

FIELD NAME	DESCRIPTION/VALID VALUES	UPDATED BY
CBH-CASH-CODE Element: Cash Code	Alpha 4 The cash code. If the Transfer Type field = 1 (Many Deposits), this cash 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.	CB15.1 CB15.2
CBH-TRANSFER-NBR Element: Transfer Number	Alpha 10 (Right Justified) A user-defined identification number used to identify the bank fund transfer.	CB15.1 CB15.2
CBH-TRANSFER-TYPE Element: Transfer Type	Alpha 1 Identifies the type of bank fund transfer (and the screen the bank fund transfer was entered on). Valid values are: 1 = Many Deposits (entered in CB15.1). Funds are being transferred from one bank account (cash code) to one or more other bank accounts. 2 = Many Withdrawals (entered in CB15.2). Funds are being transferred to one bank account (cash code) from one or more other bank accounts.	CB15.1 CB15.2
CBH-COMPANY Element: Company	Numeric 4 The 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 Element: Transfer Amount	Signed 18.2 The 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 Element: Intl Amt	Signed 18.2 The 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 field = 1 (Many Deposits), this amount represents the total amount to be deposited based on funds withdrawn from the Cash Code. If the Transfer Type field = 2 (Many Withdrawals), this 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.	CB15.1 CB15.2
CBH-CPY-BASE-AMT Base Currency Transfer Amount	Signed 18.2 The 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 Currency Applied Amount	Signed 18.2 The 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 Element: 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 Element: 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 Element: Bank Expense Amount	Signed 18.2 If 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 Base Currency Bank Expense Amt	Signed 18.2 The 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 Bank Expense Accounting Unit	Alpha 15 The 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 Bank Expense Account Number	Numeric 6 The 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 Bank Expense Subaccount Number	Numeric 4 The 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 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.	CB15.1
CBH-BEXP-ACCT-CAT Element: 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	CB15.1
CBH-BANK-INST-CODE Element: Transaction Code	Alpha 3 The 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 Element: Acct Rate	Signed 14.7 The 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 Element: Rec Status	Numeric 1 The status of the transaction. Valid values are: 0 = Unreleased. 1 = Released.	CB15.1 CB15.2 CB150
CBH-DESCRIPTION Element: Description	Alpha 30 (Lower Case) The description of the bank fund transfer.	CB15.1 CB15.2
CBH-JRNL-BOOK-NBR Element: Jrnl Book Nbr	Alpha 12 The journal book assigned to the transaction.	CB15.1 CB15.2
CBH-TRF-DIFFERENCE Element: Transfer Difference	Derived The difference between the Transfer Amount and Applied Amount in the bank account currency defined for the Cash Code.
CBH-TRF-TYPE-DESC Transfer Type Description	Derived A description of the Transfer Type.
CBH-JBK-SEQ-NBR Element: Jbk Seq Nbr	Numeric 10 The 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

CBTRFHDR FILE INDEX

CBTRFHDR FILE RELATIONS

ONE TO ONE RELATIONS

CBTRFHDR FILE RELATIONS

ONE TO MANY RELATIONS

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