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

AP125     AP126     AP150     AP151     AP155     AP156
AP160     AP161     AP170     AP176     AP180     AP190
AP20.1    AP20.2    AP20.3    AP20.4    AP20.5    AP20.7
AP20.8    AP213     AP23.1    AP25.1    AP25.2    AP26.1
AP27.1    AP28.1    AP28.2    AP284     AP56.1    AP56.2
AP80.1    AR20.1    CB00.3    CB20.1    DT160     DT170
DT180     MA41.2    MA43.2    MA61.1    MAI1.1

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 AP150   AP151
          BANK-INST-CODEcode, payment code and journal book.     AP155   AP156
                                                                 AP160   AP161
                                                                 AP170   AP176
                                                                 AP180   AP190
                                                                 AP20.1  AP20.2
                                                                 AP20.3  AP20.4
                                                                 AP20.5  AP20.7
                                                                 AP20.8  AP213
                                                                 AP23.1  AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP28.1
                                                                 AP28.2  AP284
                                                                 AP56.1  AP56.2
                                                                 ...