Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                             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    CA190
GL110     GL146     GL170     GL190     GL199     GL40.2
GL40.6    GL45.1    GL75.1    GL10.1    JB00.1

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

JSQ-COMPANY          Numeric 4                                   AP170   AP193
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
                                                                 GL10.1  GL110
                                                                 GL146   GL170
                                                                 GL190   GL199
                                                                 GL40.2  GL40.6
                                                                 GL45.1  GL75.1
                                                                 JB00.1

JSQ-JRNL-BOOK-NBR    Alpha 12                                    AP170   AP193
Journal Book Number  The 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
                                                                 GL10.1  GL146
                                                                 GL170   GL190
                                                                 GL199   GL40.2
                                                                 GL40.6  GL45.1
                                                                 GL75.1  JB00.1

JSQ-FISCAL-YEAR      Numeric 4                                   AP170   AP193
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
                                                                 GL10.1  GL146
                                                                 GL170   GL190
                                                                 GL199   GL40.2
                                                                 GL40.6  GL45.1
                                                                 GL75.1  JB00.1

JSQ-SEQ-TRNS-NBR     Numeric 10                                  GL10.1  GL146
Transaction Number   The last transaction sequence number        GL190   GL199
                     assigned to a company or journal book       GL45.1  JB00.1
                     General Ledger transaction.


JSQ-JBK-LAST-SEQ     Numeric 10                                  AP170   AP193
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
                                                                 GL170   GL40.2
                                                                 GL40.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  CA190
                                                                 GL110   GL146
                                                                 GL170   GL190
                                                                 GL199   GL40.2
                                                                 GL40.6  GL45.1
                                                                 GL75.1  GL10.1
                                                                 GL210   JB00.1
                                                                 JB200