CBTRFDTL

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

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
CBLSET1 CASH-CODE
TRANSFER-NBR
DTL-CASH-CODE
CB15.1 CB15.2
CB150 CB195
CB215 CB300
CBLSET3 DTL-CASH-CODE
TRANSFER-NBR
CASH-CODE
KeyChange
CB06.2 CB10.1
CB15.1 CB15.2
CB175 CB20.1
CB43.1 CB44.1
CB45.1 CB46.1
CB543 CB544


CBTRFDTL FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Cbbankent Dtl CBBANKENT Required
CBC-BANK-ENTITY->CBE-BANK-ENTITY
Cbbankent Hdr CBBANKENT Required
CBC-BANK-ENTITY->CBE-BANK-ENTITY
Cbbankinst CBBANKINST Required
CBL-BANK-INST-CODE->CBI-BANK-INST-CODE
Cbcashcode CBCASHCODE Required
CBL-CASH-CODE->CBC-CASH-CODE
Cbcashcode Dtl CBCASHCODE Required
CBL-DTL-CASH-CODE->CBC-CASH-CODE
Cbtrfhdr CBTRFHDR Required
CBL-CASH-CODE->CBH-CASH-CODE
CBL-TRANSFER-NBR->CBH-TRANSFER-NBR
Cbtrftable CBTRFTABLE Required
CBL-CASH-CODE->CBX-CASH-CODE
Glsystem Dtl GLSYSTEM Required
CBL-DTL-COMPANY->GLS-COMPANY
Glsystem Hdr GLSYSTEM Required
CBH-COMPANY->GLS-COMPANY


File created: Thu Jun 09 11:11:49 2016

Home
Contact Us



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