Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

JBOOKHDR


                             JBOOKHDR FILE

                          Journal Book Header

The Journal Book Header file contains the Journal Book definition
information, including description, restrictions, creation, status, and
accounting unit list.


REFERENCED BY

AC191     AP125     AP126     AP25.1    AP25.2    AP26.1
AP27.1    API2.1    BR44.1    GL247     GL256     JB240
IFAC.1    JB200     MA61.1    MAI1.1    RQ10.1    RQ10.3
RQ11.1    RQ13.2    RQ35.1    RQ500     RQIB.1    RQIF.1
RQIJ.1

UPDATED BY

AP181     AP191     AP20.1    AP20.2    AP20.3    AP20.4
AP20.5    AP20.7    AP21.1    AP23.1    AP520     API1.1
AR115     AR137     AR14.1    AR190     AR42.2    AR42.7
AR44.3    AR48.3    AR502     AR560     AR575     AR580
AR82.1    ARLL.1    BL123     CB00.3    CB05.1    CB06.1
CB10.1    CB145     CB15.1    CB15.2    CB20.1    CB43.1
CB45.1    CB50.1    CB500     CB543     CB55.1    CB554
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    GL110     GL165
GL190     GL40.1    GL40.2    GL40.6    GL40.8    GL44.1
GL45.1    GL65.1    GL70.1    GL70.2    GL70.3    GL01.1
GL01.2    GL10.1    IFGT.1    JB00.1    MA41.1    MA41.2
MA41.4    MA41.7    MA43.2    MA530     MA540     PO31.1


FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

JBK-COMPANY            Numeric 4                                 GL10.1  GL110
Element: Company       The company number you are defining a     JB00.1
                       journal book for.


JBK-JRNL-BOOK-NBR      Alpha 12                                  GL10.1  JB00.1
Element: Journal Book NThe Journal Book reference number
                       assigned to group General Ledger
                       transactions.


JBK-DESCRIPTION        Alpha 30  (Lower Case)                    GL10.1  JB00.1
Element: Description   The description of the journal book.

JBK-RESTRICT-SYS       Alpha 1                                   GL10.1  JB00.1
Element: Restrict SysteThis indicates if the journal book can
                       only be used in specific systems.

                       Y = Yes
                       N = No

JBK-RESTRICT-OPER      Alpha 1                                   GL10.1  JB00.1
Element: Restrict OperaThis indicates if the journal book can
                       only be used by specific users.

                       Y = Yes
                       N = No

JBK-RESTRICT-ACCT      Alpha 1                                   GL10.1  JB00.1
Element: Restrict AccouThis indicates if the journal book can
                       only access specific accounts.

                       Y = Yes
                       N = No

JBK-CREATE-DATE        Numeric 8  (yyyymmdd)                     GL10.1  JB00.1
Element: Create Date   This is the date the journal book was
                       created.


JBK-CREATE-TIME        Numeric 6  (hhmmss)                       GL10.1  JB00.1
Element: Create Time   This is the time the journal book was
                       created.


JBK-ACTIVE-STATUS      Alpha 1                                   GL10.1  JB00.1
Element: Active Status The status of the journal book.
                       A = Active
                       I = Inactive

JBK-MATRIX-LIST        Alpha 12                                  JB00.1
Element: Matrix List   Attribute categories are selection
                       parameters used to build a list of
                       objects (accounting units). Attribute
                       categories and values are the basis of
                       the selection and sorting. An attribute
                       list can then be used for reporting on
                       and processing objects.


JBK-USED-FLAG          Alpha 1                                   AP181   AP191
Element: Used          Indicates if the record has been          AP20.1  AP20.2
                       accessed by some source after creation.   AP20.3  AP20.4
                                                                 AP20.5  AP20.7
                       " " = Not Used                            AP21.1  AP23.1
                       Y = Used                                  AP520   API1.1
                                                                 AR115   AR137
                                                                 AR14.1  AR190
                                                                 AR42.2  AR42.7
                                                                 AR44.3  AR48.3
                                                                 AR502   AR560
                                                                 AR575   AR580
                                                                 AR82.1  ARLL.1
                                                                 BL123   CA10.2
                                                                 CB00.3  CB05.1
                                                                 CB06.1  CB10.1
                                                                 CB145   CB15.1
                                                                 CB15.2  CB20.1
                                                                 CB43.1  CB45.1
                                                                 CB50.1  CB500
                                                                 CB543   CB55.1
                                                                 CB554   DT150
                                                                 DT180   DT181
                                                                 DT185   DT30.1
                                                                 DT30.2  DT40.1
                                                                 DT52.1  DT520
                                                                 DT70.1  DT70.3
                                                                 DT92.1  EE20.2
                                                                 EE20.4  EE520
                                                                 GL01.1  GL01.2
                                                                 ...

                         JBOOKHDR FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

JBKSET1   COMPANY                                                AC191   AP125
          JRNL-BOOK-NBR                                          AP126   AP181
                                                                 AP191   AP20.1
                                                                 AP20.2  AP20.3
                                                                 AP20.4  AP20.5
                                                                 AP20.7  AP21.1
                                                                 AP23.1  AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP520
                                                                 API1.1  API2.1
                                                                 AR115   AR137
                                                                 AR14.1  AR190
                                                                 AR42.2  AR42.7
                                                                 AR44.3  AR48.3
                                                                 AR502   AR560
                                                                 ...

                         JBOOKHDR FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Glsystem       GLSYSTEM     Required

                            JBK-COMPANY          -> GLS-COMPANY

Jbkseqnbr Fy   JBKSEQNBR    Not Required

                            JBK-COMPANY          -> JSQ-COMPANY
                            JBK-JRNL-BOOK-NBR    -> JSQ-JRNL-BOOK-NBR
                            GLS-FISCAL-YEAR      -> JSQ-FISCAL-YEAR

                         JBOOKHDR FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Jbkacct        JBKACCT      Delete Cascades

                            JBK-COMPANY          -> JAC-COMPANY
                            JBK-JRNL-BOOK-NBR    -> JAC-JRNL-BOOK-NBR
                                                    JAC-TH-ACCOUNT
                                                    JAC-TH-SUB-ACCT

Jbkopcode      JBKOPCODE

                            JBK-COMPANY          -> JBO-COMPANY
                            JBK-JRNL-BOOK-NBR    -> JBO-JRNL-BOOK-NBR
                                                    JBO-OPERATOR

Jbkseqnbr      JBKSEQNBR

                            JBK-COMPANY          -> JSQ-COMPANY
                            JBK-JRNL-BOOK-NBR    -> JSQ-JRNL-BOOK-NBR
                                                    JSQ-FISCAL-YEAR

Jbksyscode     JBKSYSCODE

                            JBK-COMPANY          -> JSC-COMPANY
                            JBK-JRNL-BOOK-NBR    -> JSC-JRNL-BOOK-NBR
                                                    JSC-SYSTEM