|
|
CBTRFHDR FILE
Fund Transfer
The Fund Transfer file contains bank fund transfer records.
REFERENCED BY
CB06.2 CB10.1 CB20.1 CB215 CB195 CB221
UPDATED BY
CB15.1 CB15.2 CB300
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
CBH-CASH-CODE Alpha 4 CB15.1 CB15.2
Accounts Receivable The cash code. If the Transfer Type
Code 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.
CBH-TRANSFER-NBR Alpha 10 (Right Justified) CB15.1 CB15.2
Element: Transfer NumbeA user-defined identification number
used to identify the bank fund transfer.
CBH-TRANSFER-TYPE Alpha 1 CB15.1 CB15.2
Element: Transfer Type 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.
CBH-COMPANY Numeric 4 CB15.1 CB15.2
Element: Company 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.
CBH-TRANSFER-AMT Signed 15.2 CB15.1 CB15.2
Element: Transfer AmounThe 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.
CBH-APPLIED-AMT Signed 15.2 CB15.1 CB15.2
Element: Adj Amt 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.
CBH-CPY-BASE-AMT Signed 15.2 CB15.1 CB15.2
Base Currency The amount of the fund transfer in the
Transfer Amount base currency of the Company responsible
for initiating the transfer.
CBH-BASE-APPL-AMT Signed 15.2 CB15.1 CB15.2
Base Currency The total distribution amount of the
Applied Amount bank fund transfer in the base currency
of the Company responsible for
initiating the transfer.
CBH-TRANSFER-DATE Numeric 8 (yyyymmdd) CB15.1 CB15.2
Element: Date The date funds will be transferred. If
left blank, the system date defaults.
CBH-POST-DATE Numeric 8 (yyyymmdd) CB15.1 CB15.2
Element: Date The date used for posting the bank fund
transfer to the general ledger. If left
blank, the Transfer Date is used.
CBH-BEXP-TRAN-AMT Signed 15.2 CB15.1
Element: Bank Expense AIf 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.
CBH-BEXP-BASE-AMT Signed 15.2 CB15.1
Base Currency Bank The amount charged by the bank for the
Expense Amt fund transfer in the base currency of
the Company responsible for initiating
the transfer.
CBH-BEXP-ACCT-UNIT Alpha 15 CB15.1
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.
CBH-BEXP-ACCOUNT Numeric 6 CB15.1
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.
CBH-BEXP-SUB-ACCT Numeric 4 CB15.1
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.
CBH-BANK-INST-CODE Alpha 3 CB15.1 CB15.2
Element: Transaction CoThe 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.
CBH-EXCHANGE-RATE Signed 12.6 CB15.1 CB15.2
Element: Account Rate 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.
CBH-REC-STATUS Numeric 1 CB15.1 CB15.2
Element: Record Status The status of the transaction. Valid
values are:
0 = Unreleased.
1 = Released.
CBH-DESCRIPTION Alpha 30 (Lower Case) CB15.1 CB15.2
Element: Description The description of the bank fund
transfer.
CBH-JRNL-BOOK-NBR Alpha 12 CB15.1 CB15.2
Element: Journal Book The journal book assigned to the
transaction.
CBH-TRF-DIFFERENCE Derived
Element: Transfer DiffeThe difference between the Transfer
Amount and Applied Amount in the bank
account currency defined for the Cash
Code.
CBH-TRF-TYPE-DESC Derived
Transfer Type A description of the Transfer Type.
Description
CBH-JBK-SEQ-NBR Numeric 10 CB15.1 CB15.2
Journal Book The journal book sequence number
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).
CBTRFHDR FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
CBHSET1 CASH-CODE This primary index is used to keep fund CB06.2 CB10.1
TRANSFER-NBR transfer records unique by originating CB15.1 CB15.2
cash code and transfer number. CB20.1 CB215
CB300
CBHSET2 CASH-CODE This index is used to access unreleased CB195 CB221
TRANSFER-NBR bank transfer records.
Subset
Where REC-STATUS = Zeroes
CBTRFHDR FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Cbbankent CBBANKENT Required
CBC-BANK-ENTITY -> CBE-BANK-ENTITY
Cbbankinst CBBANKINST Required
CBH-BANK-INST-CODE -> CBI-BANK-INST-CODE
Cbcashcode CBCASHCODE Required
CBH-CASH-CODE -> CBC-CASH-CODE
Cbtrftable CBTRFTABLE Required
CBH-CASH-CODE -> CBX-CASH-CODE
Gladdress GLADDRESS Required
CBH-COMPANY -> GAD-COMPANY
Spaces -> GAD-ACCT-UNIT
CBTRFHDR FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Cbtrfdtl CBTRFDTL
CBH-CASH-CODE -> CBL-CASH-CODE
CBH-TRANSFER-NBR -> CBL-TRANSFER-NBR
CBL-DTL-CASH-CODE
|
