Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

CBTRFDTL


                             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
Accounts Receivable    The cash code. Represents either the
Code                   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 15.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 15.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 15.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 15.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 12.6                               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 12.6                               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 15.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 15.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-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