Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

JBKSEQNBR


                             JBKSEQNBR FILE

                      Journal Book Sequence Number

The Journal Book Sequence Number file contains the last sequence number
assigned to a General Ledger transaction.


REFERENCED BY

GL210     JB200

UPDATED BY

AP170     AP193     AP520     API1.1    AR20.1    CB06.2
CB10.1    CB15.1    CB15.2    CB20.1    EE20.2    EE520
CA190     GL110     GL146     GL147     GL170     GL190
GL197     GL199     GL40.1    GL40.2    GL40.3    GL40.6
GL40.7    GL40.8    GL44.1    GL45.1    GL70.1    GL70.2
GL70.3    GL70.5    GL70.6    GL75.1    GL10.1    JB00.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

JSQ-COMPANY            Numeric 4                                 AP170   AP193
Element: Company       The company number you are defining a     AP520   API1.1
                       journal book for.                         AR20.1  CA190
                                                                 CB06.2  CB10.1
                                                                 CB15.1  CB15.2
                                                                 CB20.1  EE20.2
                                                                 EE520   GL10.1
                                                                 GL110   GL146
                                                                 GL147   GL170
                                                                 GL190   GL197
                                                                 GL199   GL40.1
                                                                 GL40.2  GL40.3
                                                                 GL40.6  GL40.7
                                                                 GL40.8  GL44.1
                                                                 GL45.1  GL70.1
                                                                 GL70.2  GL70.3
                                                                 GL70.5  GL70.6
                                                                 GL75.1  JB00.1

JSQ-JRNL-BOOK-NBR      Alpha 12                                  AP170   AP193
Element: Journal Book NThe Journal Book reference number         AP520   API1.1
                       assigned to group General Ledger          AR20.1  CA190
                       transactions.                             CB06.2  CB10.1
                                                                 CB15.1  CB15.2
                                                                 CB20.1  EE20.2
                                                                 EE520   GL10.1
                                                                 GL146   GL147
                                                                 GL170   GL190
                                                                 GL197   GL199
                                                                 GL40.1  GL40.2
                                                                 GL40.3  GL40.6
                                                                 GL40.7  GL40.8
                                                                 GL44.1  GL45.1
                                                                 GL70.1  GL70.2
                                                                 GL70.3  GL70.5
                                                                 GL70.6  GL75.1
                                                                 JB00.1

JSQ-FISCAL-YEAR        Numeric 4                                 AP170   AP193
Element: Fiscal Year   This is the fiscal year journal books     AP520   API1.1
                       are defined in.                           AR20.1  CA190
                                                                 CB06.2  CB10.1
                                                                 CB15.1  CB15.2
                                                                 CB20.1  EE20.2
                                                                 EE520   GL10.1
                                                                 GL146   GL147
                                                                 GL170   GL190
                                                                 GL197   GL199
                                                                 GL40.1  GL40.2
                                                                 GL40.3  GL40.6
                                                                 GL40.7  GL40.8
                                                                 GL44.1  GL45.1
                                                                 GL70.1  GL70.2
                                                                 GL70.3  GL70.5
                                                                 GL70.6  GL75.1
                                                                 JB00.1

JSQ-SEQ-TRNS-NBR       Numeric 10                                GL10.1  GL110
Element: Transaction NuThe last transaction sequence number      GL146   GL147
                       assigned to a company or journal book     GL190   GL197
                       General Ledger transaction.               GL199   GL40.1
                                                                 GL40.2  GL40.3
                                                                 GL40.7  GL40.8
                                                                 GL44.1  GL45.1
                                                                 JB00.1

JSQ-JBK-LAST-SEQ       Numeric 10                                AP170   AP193
Element: Jbk Last Seq  The last sequence number assigned to a    AP520   API1.1
                       journal book transaction at entry time.   AR20.1  CA190
                                                                 CB06.2  CB10.1
                                                                 CB15.1  CB15.2
                                                                 CB20.1  EE20.2
                                                                 EE520   GL110
                                                                 GL170   GL40.2
                                                                 GL40.6  GL70.1
                                                                 GL70.2  GL70.3
                                                                 GL70.5  GL70.6
                                                                 GL75.1  JB00.1

                         JBKSEQNBR FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

JSQSET1   COMPANY                                                AP170   AP193
          JRNL-BOOK-NBR                                          AP520   API1.1
          FISCAL-YEAR                                            AR20.1  CB06.2
                                                                 CB10.1  CB15.1
                                                                 CB15.2  CB20.1
                                                                 EE20.2  EE520
                                                                 CA190   GL110
                                                                 GL146   GL147
                                                                 GL170   GL190
                                                                 GL197   GL199
                                                                 GL40.1  GL40.2
                                                                 GL40.3  GL40.6
                                                                 GL40.7  GL40.8
                                                                 GL44.1  GL45.1
                                                                 GL70.1  GL70.2
                                                                 ...