Fund Transfer Detail

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

CB06.2	CB10.1	CB15.1	CB15.2	CB150	CB175
CB195	CB20.1	CB215	CB300	CB43.1	CB44.1
CB45.1	CB46.1	CB543	CB544

FIELD NAME	DESCRIPTION/VALID VALUES	UPDATED BY
CBL-CASH-CODE Element: Cash Code	Alpha 4 The 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 Element: Transfer Number	Alpha 10 (Right Justified) A user-defined identification number used to identify the bank fund transfer.	CB15.1 CB15.2
CBL-DTL-CASH-CODE Element: Detail Cash Code	Alpha 4 The 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 Element: Detail Company	Numeric 4 The 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 Detail Transfer Amount	Signed 18.2 The amount of the transfer in the bank account currency of the Detail Cash Code.	CB15.1 CB15.2
CBL-DTL-BASE-AMT Base Detail Transfer Amount	Signed 18.2 The amount of the transfer in the base currency of the Detail Company.	CB15.1 CB15.2
CBL-HDR-TRAN-AMT Element: Transfer Amount	Signed 18.2 The 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 Element: Base Transfer Amount	Signed 18.2 The 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 Element: Detail Exchange Rate	Signed 14.7 The 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 Transfer Exchange Rate	Signed 14.7 The 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 Element: Transaction Code	Alpha 3 The 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 Element: Bank Expense Amount	Signed 18.2 The 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 Base Currency Bank Expense Amt	Signed 18.2 The amount charged by the bank for the fund transfer in the base currency of the Detail Company.	CB15.2
CBL-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.2
CBL-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.2
CBL-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.2
CBL-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.2
CBL-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.2
CBL-JRNL-BOOK-NBR Element: Jrnl Book Nbr	Alpha 12 The journal book assigned to the transaction.	CB15.1 CB15.2

CBTRFDTL FILE INDEX

CBTRFDTL FILE RELATIONS

ONE TO ONE RELATIONS

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