Lawson Insight Technical Documentation


ERDs Tables Elements Libraries App Forms

                            JBKSYSCODE FILE

                          Journal Book System

The Journal Book System file contains valid systems that can use the Journal
Book in JB00.2 (Journal Book Systems).


REFERENCED BY

AP151     AP180     AP181     AP191     AP20.1    AP20.2
AP20.5    AP20.7    AP23.1    AP520     AP56.1    AR115
AR137     AR14.1    AR190     AR42.2    AR42.7    AR44.3
AR502     AR560     AR575     AR580     AR82.1    BL123
CB00.3    CB05.1    CB06.1    CB10.1    CB15.1    CB15.2
CB20.1    CB500     DT150     DT180     DT181     DT185
DT30.1    DT30.2    DT40.1    DT52.1    DT520     DT70.1
DT70.3    DT92.1    EE20.2    EE20.4    EE520     CA10.2
GL165     GL190     GL40.1    GL40.2    GL40.7    GL40.9
GL44.1    GL45.1    GL65.1    GL70.1    GL70.2    GL01.1
GL01.2    GL10.1    IFGT.1    JB200     MA40.1    MA40.2
MA41.1    MA41.2    MA41.4    MA41.5    MA41.6    MA43.1
MA43.2    MA43.3    MA43.4    MA52.1

UPDATED BY

GL110     JB00.1    JB00.2

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

JSC-COMPANY          Numeric 4                                   GL110   JB00.2
Company              The company number you are defining a
                     journal book for.


JSC-JRNL-BOOK-NBR    Alpha 12                                    JB00.2
Journal Book Number  The Journal Book reference number
                     assigned to group General Ledger
                     transactions.


JSC-SYSTEM           Alpha 2                                     JB00.2
System Code          A two-character code representing an
                     application used within the Lawson
                     system. (i.e., GL = General Ledger, AP =
                     Accounts Payable, and so on.)


                         JBKSYSCODE FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

JSCSET1   COMPANY                                                AP151   AP180
          JRNL-BOOK-NBR                                          AP181   AP191
          SYSTEM                                                 AP20.1  AP20.2
                                                                 AP20.5  AP20.7
                                                                 AP23.1  AP520
                                                                 AP56.1  AR115
                                                                 AR137   AR14.1
                                                                 AR190   AR42.2
                                                                 AR42.7  AR44.3
                                                                 AR502   AR560
                                                                 AR575   AR580
                                                                 AR82.1  BL123
                                                                 CB00.3  CB05.1
                                                                 CB06.1  CB10.1
                                                                 CB15.1  CB15.2
                                                                 ...

                         JBKSYSCODE FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Glcodes        GLCODES      Not Required

                            JSC-COMPANY    -> GCD-COMPANY
                            JSC-SYSTEM     -> GCD-SYSTEM