JBKSEQNBR – Journal Book Sequence Number

System: General Ledger (GL)
Prefix: JSQ
Primary key: COMPANY, JRNL-BOOK-NBR, FISCAL-YEAR
Fields: 5
Updated by: 81 programs
Referenced by: 2 programs

JBKSEQNBR is the Journal Book Sequence Number table in Lawson General Ledger (prefix JSQ). It is indexed by COMPANY, JRNL-BOOK-NBR, FISCAL-YEAR (JSQSET1). It is updated by AP150, AP170, AP193, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 and 73 more and referenced by GL210 and JB200. The table has 5 fields, 1 index and 0 documented relations.

About JBKSEQNBR

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

Fields (5)

Column = COBOL field name without the JSQ- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / column	Type	Description & values	Updated by
`JSQ-COMPANY` PK COMPANY	Numeric 4	The company number you are defining a journal book for.	AP150, AP170, AP193, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
`JSQ-JRNL-BOOK-NBR` PK JRNL_BOOK_NBR	Alpha 12	The Journal Book reference number assigned to group General Ledger transactions.	AP150, AP170, AP193, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
`JSQ-FISCAL-YEAR` PK FISCAL_YEAR	Numeric 4	This is the fiscal year journal books are defined in.	AP150, AP170, AP193, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
`JSQ-SEQ-TRNS-NBR` SEQ_TRNS_NBR	Numeric 10	The last transaction sequence number assigned to a company or journal book General Ledger transaction.	GL10.1, GL110, GL146, GL147, GL190, GL197, GL199, GL40.1 +17 more
`JSQ-JBK-LAST-SEQ` JBK_LAST_SEQ	Numeric 10	The last sequence number assigned to a journal book transaction at entry time.	AP150, AP170, AP193, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more

Indexes (1)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

Index	Keys	Flags	Condition	Used in
`JSQSET1`	`COMPANY`, `JRNL-BOOK-NBR`, `FISCAL-YEAR`	Primary		AP150, AP170, AP193, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +22 more (list truncated in source)

Programs

Updated by (81)

AP150 Cash Requirements
AP170 Payment Closing
AP193 Recurring Invoice Update
AP20.1 Basic Invoice
AP20.2 Taxed Invoice
AP20.3 Detail Invoice
AP20.4 Invoice Line Detail
AP20.5 Multiple Invoice
AP20.7 Distributions
AP21.1 View Distributions
AP23.1 Transit Invoice Entry
AP520 Invoice Interface
API1.1 Add Invoice
CA190 Allocation Interface
CB06.2 Bank Statement Detail Entry
CB10.1 Cash Receipt Deposit
CB15.1 Bank Fund Transfer - Multiple Deposits
CB15.2 Bank Fund Transfer - Multiple Withdrawals
CB150 Mass Release
CB180 Cash Ledger Void Update
CB20.1 Bank Transaction Entry
CB45.1 EFT/CC Extract Entry
CB46.1 Returned Payment Entry
CB543 Receipts Load
CB544 Returned Payment Load
CB55.1 Payment Entry
CB554 Payment Load
EE20.2 Employee Expense
EE520 Expense Interface
EX175 Company Expense Posting
EX542 Expense Creation
EX545 Advance Payback Creation
GL10.1 Company
GL110 Company Copy Delete
GL146 Batch Journal Control
GL147 General Journal Report
GL170 Recurring Journal Interface
GL190 Journal Posting
GL197 Period, Year End GL Commitments Processing
GL199 Period Closing
GL40.1 Journal Entry
GL40.2 Define Journal
GL40.3 Speed Entry
GL40.6 Journal Copy
GL40.7 Totals
GL40.8 Journal Entry
GL44.1 Report Currency Entry
GL45.1 Journal Control
GL70.1 Recurring Journal
GL70.2 Define Recurring Journal
GL70.3 Amounts Only
GL70.5 Filter
GL70.6 Recurring Copy
GL75.1 Recurring Journal Control
JB00.1 Journal Book
MA41.1 Add-On Cost Detail - Purchase Order
MA41.2 Add On Cost Lookup
MA41.4 Miscellaneous Add-On Cost
MA41.7 AOC Approval Entry
MA42.2 Memo Line AOC Detail
MA43.2 Purchase Order Lookup
MA44.1 Invoice Line Detail - Purchase Order
MA44.2 Invoice Line Detail- Service
ML146 Batch Ledger Journal Control
ML170 Ledger Recurring Journal Interface
ML190 Ledger Journal Posting
ML199 Ledger Period Closing
ML40.1 Ledger Journal Entry
ML40.2 Define Ledger Journal
ML40.3 Ledger Speed Entry
ML40.6 Ledger Journal Copy
ML40.7 Ledger Totals
ML40.8 Ledger Journal Entry
ML44.1 Ledger Report Currency Entry
ML45.1 Ledger Journal Control
ML70.1 Ledger Recurring Journal
ML70.2 Define Recurring Journal
ML70.3 Amounts Only
ML70.5 Filter
ML70.6 Ledger Recurring Copy
ML75.1 Ledger Recurring Journal Control

Referenced by (2)

GL210 Company Listing
JB200 Journal Book Listing