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.

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 marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
JBKSET1COMPANY, JRNL-BOOK-NBRPrimaryAC191, AP125, AP126, AP181, AP191, AP20.1, AP20.2, AP20.3 +22 more (list truncated in source)

Relations

One to one (2) — lookups and parents

RelationTableRulesConditionField map
GlsystemGLSYSTEMRequiredJBK-COMPANY → GLS-COMPANY
Jbkseqnbr FyJBKSEQNBRNot RequiredJBK-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 CascadesJBK-COMPANY → JAC-COMPANY, JBK-JRNL-BOOK-NBR → JAC-JRNL-BOOK-NBR, → JAC-TH-ACCOUNT, → JAC-TH-SUB-ACCT
JbkopcodeJBKOPCODEJBK-COMPANY → JBO-COMPANY, JBK-JRNL-BOOK-NBR → JBO-JRNL-BOOK-NBR, → JBO-OPERATOR
JbkseqnbrJBKSEQNBRJBK-COMPANY → JSQ-COMPANY, JBK-JRNL-BOOK-NBR → JSQ-JRNL-BOOK-NBR, → JSQ-FISCAL-YEAR
JbksyscodeJBKSYSCODEJBK-COMPANY → JSC-COMPANY, JBK-JRNL-BOOK-NBR → JSC-JRNL-BOOK-NBR, → JSC-SYSTEM

Programs

Updated by (78)

Referenced by (31)