Fund Transfer Detail
The Fund Transfer Detail file contains all distributions associated with a bank fund transfer.
REFERENCED BY
CB150 | CB175 | CB195 | CB215 | CB06.2 | CB10.1 |
CB20.1 | CB43.1 | CB44.1 | CB45.1 | CB46.1 | CB543 |
CB544 |
CB15.1 | CB15.2 | CB300 |
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. |
|
||
CBL-TRANSFER-NBR Element: Transfer Number | Alpha 10 (Right Justified) A user-defined identification number used to identify the bank fund transfer. |
|
||
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. |
|
||
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). |
|
||
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. |
|
||
CBL-DTL-BASE-AMT Base Detail Transfer Amount | Signed 18.2 The amount of the transfer in the base currency of the Detail Company. |
|
||
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. |
|
||
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. |
|
||
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. |
|
||
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. |
|
||
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. |
|
||
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. |
|
||
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. |
|
||
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. |
|
||
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. |
|
||
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. |
|
||
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. |
|
||
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 |
|
||
CBL-JRNL-BOOK-NBR Element: Jrnl Book Nbr | Alpha 12 The journal book assigned to the transaction. |
|
NAME | KEY FIELDS | DESCRIPTION / SUBSET CONDITION | USED IN | ||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
CBLSET1 |
CASH-CODE TRANSFER-NBR DTL-CASH-CODE |
|
| ||||||||||||||||||
CBLSET3 |
DTL-CASH-CODE TRANSFER-NBR CASH-CODE |
|
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | ||||||
---|---|---|---|---|---|---|---|---|
Cbbankent Dtl | CBBANKENT |
Required
| ||||||
Cbbankent Hdr | CBBANKENT |
Required
| ||||||
Cbbankinst | CBBANKINST |
Required
| ||||||
Cbcashcode | CBCASHCODE |
Required
| ||||||
Cbcashcode Dtl | CBCASHCODE |
Required
| ||||||
Cbtrfhdr | CBTRFHDR |
Required
| ||||||
Cbtrftable | CBTRFTABLE |
Required
| ||||||
Glsystem Dtl | GLSYSTEM |
Required
| ||||||
Glsystem Hdr | GLSYSTEM |
Required
|
All trademarks and registered trademarks are the property of their
respective owners.