JBOOKHDR – Journal Book Header

System
General Ledger Setup (IF)
Prefix
JBK
Primary key
COMPANY, JRNL-BOOK-NBR
Fields
11
Updated by
78 programs
Referenced by
31 programs

JBOOKHDR is the Journal Book Header table in Lawson General Ledger Setup (prefix JBK). It is indexed by COMPANY, JRNL-BOOK-NBR (JBKSET1). It is related 1:1 to GLSYSTEM and JBKSEQNBR and 1:M to JBKACCT, JBKOPCODE, JBKSEQNBR and JBKSYSCODE. It is updated by AP181, AP191, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5, AP20.7 and 70 more and referenced by AC191, AP125, AP126, AP25.1, AP25.2, AP26.1, AP27.1, API2.1 and 23 more. The table has 11 fields, 1 index and 6 documented relations.

About JBOOKHDR

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

Fields (11)

Column = COBOL field name without the JBK- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored. PK = primary key (present in every index); SETn = leading/alternate key of that index.

Field / columnTypeDescription & valuesUpdated by
#JBK-COMPANY PK
COMPANY		Numeric 4The company number you are defining a journal book for.GL10.1, GL110, JB00.1
#JBK-JRNL-BOOK-NBR PK
JRNL_BOOK_NBR		Alpha 12The Journal Book reference number assigned to group General Ledger transactions.GL10.1, JB00.1
#JBK-DESCRIPTION
DESCRIPTION		Alpha 30 (Lower Case)The description of the journal book.GL10.1, JB00.1
#JBK-RESTRICT-SYS
RESTRICT_SYS		Alpha 1This indicates if the journal book can only be used in specific systems.
  • Y Yes
  • N No
GL10.1, JB00.1
#JBK-RESTRICT-OPER
RESTRICT_OPER		Alpha 1This indicates if the journal book can only be used by specific users.
  • Y Yes
  • N No
GL10.1, JB00.1
#JBK-RESTRICT-ACCT
RESTRICT_ACCT		Alpha 1This indicates if the journal book can only access specific accounts.
  • Y Yes
  • N No
GL10.1, JB00.1
#JBK-CREATE-DATE
CREATE_DATE		Numeric 8 (yyyymmdd)This is the date the journal book was created.GL10.1, JB00.1
#JBK-CREATE-TIME
CREATE_TIME		Numeric 6 (hhmmss)This is the time the journal book was created.GL10.1, JB00.1
#JBK-ACTIVE-STATUS
ACTIVE_STATUS		Alpha 1The status of the journal book.
  • A Active
  • I Inactive
GL10.1, JB00.1
#JBK-MATRIX-LIST
MATRIX_LIST		Alpha 12Attribute 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.JB00.1
#JBK-USED-FLAG
USED_FLAG		Alpha 1Indicates if the record has been accessed by some source after creation. " " = Not Used
  • Y Used
AP181, AP191, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5, AP20.7 +52 more (list truncated in source)

Indexes (1)

Keys are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
JBKSET1
  1. COMPANY
  2. JRNL-BOOK-NBR
PrimaryAC191, AP125, AP126, AP181, AP191, AP20.1, AP20.2, AP20.3 +22 more (list truncated in source)

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
GLSYSTEMJBKSEQNBRJBKACCTJBKOPCODEJBKSEQNBRJBKSYSCODEJBOOKHDR

One to one (2) — lookups and parents

RelationTableRulesConditionField map
GlsystemGLSYSTEMRequired
JBK-COMPANY→GLS-COMPANY
Jbkseqnbr FyJBKSEQNBRNot Required
JBK-COMPANY→JSQ-COMPANY
JBK-JRNL-BOOK-NBR→JSQ-JRNL-BOOK-NBR
GLS-FISCAL-YEAR→JSQ-FISCAL-YEAR

One to many (4) — child tables

RelationTableRulesConditionField map
JbkacctJBKACCTDelete Cascades
JBK-COMPANY→JAC-COMPANY
JBK-JRNL-BOOK-NBR→JAC-JRNL-BOOK-NBR
—→JAC-TH-ACCOUNT
—→JAC-TH-SUB-ACCT
JbkopcodeJBKOPCODE
JBK-COMPANY→JBO-COMPANY
JBK-JRNL-BOOK-NBR→JBO-JRNL-BOOK-NBR
—→JBO-OPERATOR
JbkseqnbrJBKSEQNBR
JBK-COMPANY→JSQ-COMPANY
JBK-JRNL-BOOK-NBR→JSQ-JRNL-BOOK-NBR
—→JSQ-FISCAL-YEAR
JbksyscodeJBKSYSCODE
JBK-COMPANY→JSC-COMPANY
JBK-JRNL-BOOK-NBR→JSC-JRNL-BOOK-NBR
—→JSC-SYSTEM

Programs

Updated by (78)

Referenced by (31)