JBKSYSCODE – Journal Book System

System
General Ledger Setup (IF)
Prefix
JSC
Primary key
COMPANY, JRNL-BOOK-NBR, SYSTEM
Fields
3
Updated by
3 programs
Referenced by
77 programs

JBKSYSCODE is the Journal Book System table in Lawson General Ledger Setup (prefix JSC). It is indexed by COMPANY, JRNL-BOOK-NBR, SYSTEM (JSCSET1). It is related 1:1 to GLCODES. It is updated by GL110, JB00.1 and JB00.2 and referenced by AP181, AP191, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5, AP20.7 and 69 more. The table has 3 fields, 1 index and 1 documented relation.

About JBKSYSCODE

The Journal Book System file contains valid systems that can use the Journal Book in JB00.2 (Journal Book Systems).

Fields (3)

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

Field / columnTypeDescription & valuesUpdated by
JSC-COMPANY PK
COMPANY		Numeric 4The company number you are defining a journal book for.GL110, JB00.2
JSC-JRNL-BOOK-NBR PK
JRNL_BOOK_NBR		Alpha 12The Journal Book reference number assigned to group General Ledger transactions.JB00.2
JSC-SYSTEM PK
SYSTEM		Alpha 2A two-character code representing an application used within the Lawson system. (i.e., GL = General Ledger, AP = Accounts Payable, and so on.)JB00.2

Indexes (1)

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

IndexKeysFlagsConditionUsed in
JSCSET1COMPANY, JRNL-BOOK-NBR, SYSTEMPrimaryAP181, AP191, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5, AP20.7 +22 more (list truncated in source)

Relations

One to one (1) — lookups and parents

RelationTableRulesConditionField map
GlcodesGLCODESNot RequiredJSC-COMPANY → GCD-COMPANY, JSC-SYSTEM → GCD-SYSTEM

Programs

Updated by (3)

Referenced by (77)