Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                            CBTRFTABLE FILE

                          Fund Transfer Table

The Fund Transfer Table file identifies the bank service transaction codes
used for bank fund transfers for a cash code (bank account). The bank service
transaction codes represent a withdrawal from the account, a deposit to the
account, and a bank expense associated with the funds transfer.

REFERENCED BY

CB15.1    CB15.2

UPDATED BY

CB02.1

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

CBX-CASH-CODE        Alpha 4                                     CB02.1
Cash Code            The cash code. Represents a bank
                     account. Must be a valid record in the
                     Cash Code file.

CBX-FROM-INST-CODE   Alpha 3                                     CB02.1
From Transaction     The bank service transaction code used
Code                 for transferring funds from the bank
                     account (withdrawal). Must be a valid
                     bank debit type bank service transaction
                     code record in the Bank Transaction Code
                     file.

CBX-TO-INST-CODE     Alpha 3                                     CB02.1
To Transaction Code  The bank service transaction code used
                     for transferring funds to the bank
                     account (deposit). Must be a valid bank
                     credit type bank service transaction
                     code record in the Bank Transaction Code
                     file.

CBX-EXP-INST-CODE    Alpha 3                                     CB02.1
Expense Transaction  The bank service transaction code used
Code                 for bank expenses associated with funds
                     transfers for bank account. Must be a
                     valid bank debit type bank service
                     transaction code record in the Bank
                     Transaction Code file.

                         CBTRFTABLE FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

CBXSET1   CASH-CODE     This index allows only one bank          CB02.1  CB15.1
                        transfer definition per cash code.       CB15.2

                         CBTRFTABLE FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Cbbankent      CBBANKENT    Required

                            CBC-BANK-ENTITY       -> CBE-BANK-ENTITY

Cbbankinstexp  CBBANKINST   Required

                            CBX-EXP-INST-CODE     -> CBI-BANK-INST-CODE

Cbbankinstfrom CBBANKINST   Required

                            CBX-FROM-INST-CODE    -> CBI-BANK-INST-CODE

Cbbankinstto   CBBANKINST   Required

                            CBX-TO-INST-CODE      -> CBI-BANK-INST-CODE

Cbcashcode     CBCASHCODE   Required

                            CBX-CASH-CODE         -> CBC-CASH-CODE