Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

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

AP150     AP151     AP155     AP160     AP161     AP170
AP176     AP180     AP190     AP213     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  AP150   AP151
          CASH-CODE     the relationship between a company, cash AP155   AP160
          BANK-INST-CODEcode, payment code and journal book.     AP161   AP170
                                                                 AP176   AP180
                                                                 AP190   AP213
                                                                 AP28.1  AP28.2
                                                                 AP284   AP56.1
                                                                 AR20.1  CB00.3
                                                                 CB05.1  CB20.1
                                                                 DT160   DT170
                                                                 DT180