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     AP20.1    AP20.2    AP20.3    AP20.4
AP20.5    AP20.7    AP23.1    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     MA41.2    MA43.2
MA530     MA540     PO31.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                                                AP181   AP191
          JRNL-BOOK-NBR                                          AP20.1  AP20.2
          SYSTEM                                                 AP20.3  AP20.4
                                                                 AP20.5  AP20.7
                                                                 AP23.1  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
                                                                 ...

                         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