Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

CBTRFTABLE


                            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
Accounts Receivable    The cash code. Represents a bank
Code                   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
Element: To TransactionThe 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