|
|
CBTRFDTL FILE
Fund Transfer Detail
The Fund Transfer Detail file contains all distributions associated with a
bank fund transfer.
REFERENCED BY
CB195 CB215 CB06.2 CB10.1 CB20.1
UPDATED BY
CB15.1 CB15.2 CB300
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
CBL-CASH-CODE Alpha 4 CB15.1 CB15.2
Element: Cash Code 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 Alpha 10 (Right Justified) CB15.1 CB15.2
Element: Transfer NumbeA user-defined identification number
used to identify the bank fund transfer.
CBL-DTL-CASH-CODE Alpha 4 CB15.1 CB15.2
Element: Detail Cash CoThe 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 Numeric 4 CB15.1 CB15.2
Element: Detail CompanyThe 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 Signed 18.2 CB15.1 CB15.2
Detail Transfer The amount of the transfer in the bank
Amount account currency of the Detail Cash
Code.
CBL-DTL-BASE-AMT Signed 18.2 CB15.1 CB15.2
Base Detail The amount of the transfer in the base
Transfer Amount currency of the Detail Company.
CBL-HDR-TRAN-AMT Signed 18.2 CB15.1 CB15.2
Element: Transfer AmounThe amount to be deposited to the
Detail Cash Code in the bank account
currency of the Header Cash Code.
CBL-HDR-BASE-AMT Signed 18.2 CB15.1 CB15.2
Element: Base Transfer 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 Signed 14.7 CB15.1 CB15.2
Element: Detail ExchangThe 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 Signed 14.7 CB15.1 CB15.2
Transfer Exchange The currency exchange rate used for
Rate 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 Alpha 3 CB15.1 CB15.2
Element: Transaction CoThe 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 Signed 18.2 CB15.2
Element: Bank Expense AThe 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 Signed 18.2 CB15.2
Base Currency Bank The amount charged by the bank for the
Expense Amt fund transfer in the base currency of
the Detail Company.
CBL-BEXP-ACCT-UNIT Alpha 15 CB15.2
Bank Expense The general ledger accounting unit used
Accounting Unit for posting the bank expense. Must be a
valid record in the General Ledger Names
file.
CBL-BEXP-ACCOUNT Numeric 6 CB15.2
Bank Expense The general ledger account number used
Account Number for posting the bank expense. Must be a
valid record in the General Ledger
Account Master file.
CBL-BEXP-SUB-ACCT Numeric 4 CB15.2
Bank Expense The general ledger subaccount number
Subaccount Number used for posting the bank expense. Must
be a valid record in the General Ledger
Account Master file.
CBL-BEXP-ACTIVITY Alpha 15 CB15.2
Element: Activity
CBL-BEXP-ACCT-CAT Alpha 5 CB15.2
Element: Account Category
CBL-JRNL-BOOK-NBR Alpha 12 CB15.1 CB15.2
Element: Journal Book The journal book assigned to the
transaction.
CBTRFDTL FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
CBLSET1 CASH-CODE This index is used to group transferred CB15.1 CB15.2
TRANSFER-NBR bank transactions by originating bank. CB195 CB215
DTL-CASH-CODE CB300
CBLSET3 DTL-CASH-CODE This index is used to edit for CB06.2 CB10.1
TRANSFER-NBR duplicate transfer numbers. CB20.1
CASH-CODE KeyChange
CBTRFDTL FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME 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
|
