Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

CBTRFHDR


                             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
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
General Ledger         The date used for posting the bank fund
Posting Date           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

CBH-BEXP-ACCT-CAT      Alpha 5                                   CB15.1
Element: Account Category

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: 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