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 FB121 FB165 FB20.1 FB20.3 FB20.4
FB20.6 FB20.7 FB21.1 FB230 FB231 FB30.1
FB31.1 FB65.1 GL170 GL230 GL247 GL256
GL270 JB240 IC222 IFAC.1 JB200 RQ10.1
UPDATED BY
AP151 AP180 AP181 AP191 AP20.1 AP20.2
AP20.5 AP20.7 AP23.1 AP520 AP56.1 AR115
AR137 AR14.1 AR190 AR42.2 AR42.7 AR44.3
AR502 AR560 AR575 AR580 AR82.1 BL123
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.7
GL40.9 GL44.1 GL45.1 GL65.1 GL70.1 GL70.2
GL01.1 GL01.2 GL10.1 IFGT.1 JB00.1 MA40.1
MA40.2 MA41.1 MA41.2 MA41.4 MA41.5 MA41.6
MA43.1 MA43.2 MA43.3 MA43.4 MA52.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 AP151 AP180
Used Indicates if the record has been AP181 AP191
accessed by some source after creation. AP20.1 AP20.2
AP20.5 AP20.7
" " = Not Used AP23.1 AP520
Y = Used AP56.1 AR115
AR137 AR14.1
AR190 AR42.2
AR42.7 AR44.3
AR502 AR560
AR575 AR580
AR82.1 BL123
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.7
GL40.9 GL44.1
GL45.1 GL65.1
...
JBOOKHDR FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
JBKSET1 COMPANY AC191 AP151
JRNL-BOOK-NBR AP180 AP181
AP191 AP20.1
AP20.2 AP20.5
AP20.7 AP23.1
AP520 AP56.1
AR115 AR137
AR14.1 AR190
AR42.2 AR42.7
AR44.3 AR502
AR560 AR575
AR580 AR82.1
BL123 CB00.3
CB05.1 CB06.1
CB10.1 CB15.1
...
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
|