Lawson Insight Technical Documentation


ERDs Tables Elements Libraries App Forms

                             CBCCTRNJB FILE

                         Cash Code Journal Book

The Cash Code Journal Book file contains default journal book numbers for
each transaction code that is defined for a company cash code.


REFERENCED BY

AP125     AP126     AP151     AP160     AP170     AP190
AP213     AP25.1    AP25.2    AP26.1    AP28.1    AP28.2
AP284     AP56.1    AR20.1    CB00.3    CB20.1    DT160
DT170     DT180

UPDATED BY

CB05.1

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

CJB-COMPANY          Numeric 4                                   CB05.1
Company              The company number. Must be a valid
                     record in the General Ledger Company
                     file.


CJB-CASH-CODE        Alpha 4                                     CB05.1
Cash Code            The cash code. Represents a bank
                     account. Must be a valid record in the
                     Cash Code file and a valid relationship
                     must exist between the company and the
                     cash code in the Company - Cash Code
                     Relationship file.


CJB-BANK-INST-CODE   Alpha 3                                     CB05.1
Transaction Code     The transaction code. Represents a type
                     of cash payment, bill of exchange
                     payment, or bank service transaction.
                     Must be a valid record in the Bank
                     Transaction Code file.


CJB-JRNL-BOOK-NBR    Alpha 12                                    CB05.1
Journal Book         The default journal book assigned to
                     the transaction code for the company -
                     cash code relationship. Must be a valid
                     record in the Journal Book Header file.


                         CBCCTRNJB FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

CJBSET1   COMPANY       This index is used to create and verify  AP125   AP126
          CASH-CODE     the relationship between a company, cash AP151   AP160
          BANK-INST-CODEcode, payment code and journal book.     AP170   AP190
                                                                 AP213   AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP28.1  AP28.2
                                                                 AP284   AP56.1
                                                                 AR20.1  CB00.3
                                                                 CB05.1  CB20.1
                                                                 DT160   DT170
                                                                 DT180