|
|
CBTRFHDR FILE
Fund Transfer
The Fund Transfer file contains bank fund transfer records.
REFERENCED BY
CB06.2 CB10.1 CB20.1 CB215 CB43.1 CB44.1
CB45.1 CB46.1 CB543 CB544 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
Element: Cash Code The cash code. If the Transfer Type
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 18.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 18.2 CB15.1 CB15.2
Element: Intl 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 18.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 18.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: Transfer 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: Post 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 18.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 18.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-BEXP-ACTIVITY Alpha 15 CB15.1
Element: Activity Activities are the processes or
procedures that produce work. Cost
objects (products, services, customers,
and so on) are the reasons for
performing the activity.
CBH-BEXP-ACCT-CAT Alpha 5 CB15.1
Element: Acct Category 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
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 14.7 CB15.1 CB15.2
Element: Acct 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: Rec 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: Jrnl Book Nbr 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
Element: Jbk Seq Nbr The journal book 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 CB06.2 CB10.1
TRANSFER-NBR CB15.1 CB15.2
CB20.1 CB215
CB300 CB43.1
CB44.1 CB45.1
CB46.1 CB543
CB544
CBHSET2 CASH-CODE Subset CB195 CB221
TRANSFER-NBR 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
|
