 |
Lawson Insight Technical Documentation |
|
JBOOKHDR FILE
Journal Book Header
The Journal Book Header file contains the Journal Book definition
information, including description, restrictions, creation, status, and
accounting unit list.
REFERENCED BY
AC191 GL247 GL256 JB240 IC222 IFAC.1
JB200
UPDATED BY
AP181 AP191 AP520 API1.1 AR115 AR137
AR14.1 AR190 AR42.2 AR42.7 AR44.3 AR48.3
AR502 AR560 AR575 AR580 AR82.1 CB00.3
CB05.1 CB06.1 CB10.1 CB15.1 CB15.2 CB20.1
CB500 DT150 DT180 DT181 DT185 DT30.1
DT30.2 DT40.1 DT52.1 DT520 DT70.1 DT70.3
DT92.1 EE20.2 EE20.4 EE520 CA10.2 GL110
GL165 GL190 GL40.1 GL40.2 GL40.6 GL40.8
GL44.1 GL45.1 GL65.1 GL70.1 GL70.2 GL01.1
GL01.2 GL10.1 IFGT.1 JB00.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
JBK-COMPANY Numeric 4 GL10.1 GL110
Company The company number you are defining a JB00.1
journal book for.
JBK-JRNL-BOOK-NBR Alpha 12 GL10.1 JB00.1
Journal Book Number The Journal Book reference number
assigned to group General Ledger
transactions.
JBK-DESCRIPTION Alpha 30 (Lower Case) GL10.1 JB00.1
Description The description of the journal book.
JBK-RESTRICT-SYS Alpha 1 GL10.1 JB00.1
Restrict System This indicates if the journal book can
only be used in specific systems.
Y = Yes
N = No
JBK-RESTRICT-OPER Alpha 1 GL10.1 JB00.1
Restrict Operator This indicates if the journal book can
only be used by specific users.
Y = Yes
N = No
JBK-RESTRICT-ACCT Alpha 1 GL10.1 JB00.1
Restrict Accounts This indicates if the journal book can
only access specific accounts.
Y = Yes
N = No
JBK-CREATE-DATE Numeric 8 (yyyymmdd) GL10.1 JB00.1
Create Date This is the date the journal book was
created.
JBK-CREATE-TIME Numeric 6 (hhmmss) GL10.1 JB00.1
Create Time This is the time the journal book was
created.
JBK-ACTIVE-STATUS Alpha 1 GL10.1 JB00.1
Active Status The status of the journal book.
A = Active
I = Inactive
JBK-MATRIX-LIST Alpha 12 JB00.1
Matrix List Attribute 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.
JBK-USED-FLAG Alpha 1 AP181 AP191
Used Indicates if the record has been AP520 API1.1
accessed by some source after creation. AR115 AR137
AR14.1 AR190
" " = Not Used AR42.2 AR42.7
Y = Used AR44.3 AR48.3
AR502 AR560
AR575 AR580
AR82.1 CA10.2
CB00.3 CB05.1
CB06.1 CB10.1
CB15.1 CB15.2
CB20.1 CB500
DT150 DT180
DT181 DT185
DT30.1 DT30.2
DT40.1 DT52.1
DT520 DT70.1
DT70.3 DT92.1
EE20.2 EE20.4
EE520 GL01.1
GL01.2 GL10.1
GL165 GL190
GL40.1 GL40.2
GL40.6 GL40.8
GL44.1 GL45.1
GL65.1 GL70.1
GL70.2 IFGT.1
JB00.1
JBOOKHDR FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
JBKSET1 COMPANY AC191 AP181
JRNL-BOOK-NBR AP191 AP520
API1.1 AR115
AR137 AR14.1
AR190 AR42.2
AR42.7 AR44.3
AR48.3 AR502
AR560 AR575
AR580 AR82.1
CB00.3 CB05.1
CB06.1 CB10.1
CB15.1 CB15.2
CB20.1 CB500
DT150 DT180
DT181 DT185
...
JBOOKHDR FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Glsystem GLSYSTEM Required
JBK-COMPANY -> GLS-COMPANY
Jbkseqnbr Fy JBKSEQNBR Not Required
JBK-COMPANY -> JSQ-COMPANY
JBK-JRNL-BOOK-NBR -> JSQ-JRNL-BOOK-NBR
GLS-FISCAL-YEAR -> JSQ-FISCAL-YEAR
JBOOKHDR FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Jbkacct JBKACCT Delete Cascades
JBK-COMPANY -> JAC-COMPANY
JBK-JRNL-BOOK-NBR -> JAC-JRNL-BOOK-NBR
JAC-TH-ACCOUNT
JAC-TH-SUB-ACCT
Jbkopcode JBKOPCODE
JBK-COMPANY -> JBO-COMPANY
JBK-JRNL-BOOK-NBR -> JBO-JRNL-BOOK-NBR
JBO-OPERATOR
Jbkseqnbr JBKSEQNBR
JBK-COMPANY -> JSQ-COMPANY
JBK-JRNL-BOOK-NBR -> JSQ-JRNL-BOOK-NBR
JSQ-FISCAL-YEAR
Jbksyscode JBKSYSCODE
JBK-COMPANY -> JSC-COMPANY
JBK-JRNL-BOOK-NBR -> JSC-JRNL-BOOK-NBR
JSC-SYSTEM
|