Lawson Insight Technical Documentation

                            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

AP181     AP191     AP520     API1.1    AR115     AR137
AR14.1    AR190     AR42.2    AR42.7    AR44.3    AR48.3
AR502     AR560     AR575     AR580     AR82.1    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.6    GL40.8    GL44.1
GL45.1    GL65.1    GL70.1    GL70.2    GL01.1    GL01.2
GL10.1    IFGT.1    JB200

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                                                AP181   AP191
          JRNL-BOOK-NBR                                          AP520   API1.1
          SYSTEM                                                 AR115   AR137
                                                                 AR14.1  AR190
                                                                 AR42.2  AR42.7
                                                                 AR44.3  AR48.3
                                                                 AR502   AR560
                                                                 AR575   AR580
                                                                 AR82.1  CB00.3
                                                                 CB05.1  CB06.1
                                                                 CB10.1  CB15.1
                                                                 CB15.2  CB20.1
                                                                 CB500   DT150
                                                                 DT180   DT181
                                                                 DT185   DT30.1
                                                                 ...

                         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