Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

CBCCTRNJB


                             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
AP213     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     MA61.1
MAI1.1

UPDATED BY

CB05.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

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

CJB-CASH-CODE          Alpha 4                                   CB05.1
Element: 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
Element: Bank InstrumenThe 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
Element: Journal Book NThe 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
                                                                 AP213   AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP28.1
                                                                 AP28.2  AP284
                                                                 AP56.1  AP56.2
                                                                 AP80.1  AR20.1
                                                                 CB00.3  CB05.1
                                                                 CB20.1  DT160
                                                                 DT170   DT180
                                                                 ...