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    CB43.1
CB44.1    CB45.1    CB46.1    CB543     CB544

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      Activities are the processes or
                       procedures that produce work. Cost
                       objects (products, services, customers,
                       and so on) are the reasons for
                       performing the activity.


CBL-BEXP-ACCT-CAT      Alpha 5                                   CB15.2
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

CBL-JRNL-BOOK-NBR      Alpha 12                                  CB15.1  CB15.2
Element: Jrnl Book Nbr The journal book assigned to the
                       transaction.

                         CBTRFDTL FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

CBLSET1   CASH-CODE                                              CB15.1  CB15.2
          TRANSFER-NBR                                           CB195   CB215
          DTL-CASH-CODE                                          CB300

CBLSET3   DTL-CASH-CODE KeyChange                                CB06.2  CB10.1
          TRANSFER-NBR                                           CB15.1  CB15.2
          CASH-CODE                                              CB20.1  CB43.1
                                                                 CB44.1  CB45.1
                                                                 CB46.1  CB543
                                                                 CB544

                         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