|
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 AP125 AP126 AP25.1 AP25.2 AP26.1
AP27.1 API2.1 BR44.1 GL247 GL256 JB240
IFAC.1 JB200 MA61.1 MAI1.1 RQ10.1 RQ10.3
RQ11.1 RQ13.2 RQ35.1 RQ500 RQIB.1 RQIF.1
RQIJ.1
UPDATED BY
AP181 AP191 AP20.1 AP20.2 AP20.3 AP20.4
AP20.5 AP20.7 AP21.1 AP23.1 AP520 API1.1
AR115 AR137 AR14.1 AR190 AR42.2 AR42.7
AR44.3 AR48.3 AR502 AR560 AR575 AR580
AR82.1 ARLL.1 BL123 CB00.3 CB05.1 CB06.1
CB10.1 CB145 CB15.1 CB15.2 CB20.1 CB43.1
CB45.1 CB50.1 CB500 CB543 CB55.1 CB554
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 GL70.3 GL01.1
GL01.2 GL10.1 IFGT.1 JB00.1 MA41.1 MA41.2
MA41.4 MA41.7 MA43.2 MA530 MA540 PO31.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
JBK-COMPANY Numeric 4 GL10.1 GL110
Element: Company The company number you are defining a JB00.1
journal book for.
JBK-JRNL-BOOK-NBR Alpha 12 GL10.1 JB00.1
Element: Journal Book NThe Journal Book reference number
assigned to group General Ledger
transactions.
JBK-DESCRIPTION Alpha 30 (Lower Case) GL10.1 JB00.1
Element: Description The description of the journal book.
JBK-RESTRICT-SYS Alpha 1 GL10.1 JB00.1
Element: Restrict SysteThis 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
Element: Restrict OperaThis 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
Element: Restrict AccouThis indicates if the journal book can
only access specific accounts.
Y = Yes
N = No
JBK-CREATE-DATE Numeric 8 (yyyymmdd) GL10.1 JB00.1
Element: Create Date This is the date the journal book was
created.
JBK-CREATE-TIME Numeric 6 (hhmmss) GL10.1 JB00.1
Element: Create Time This is the time the journal book was
created.
JBK-ACTIVE-STATUS Alpha 1 GL10.1 JB00.1
Element: Active Status The status of the journal book.
A = Active
I = Inactive
JBK-MATRIX-LIST Alpha 12 JB00.1
Element: 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
Element: Used Indicates if the record has been AP20.1 AP20.2
accessed by some source after creation. AP20.3 AP20.4
AP20.5 AP20.7
" " = Not Used AP21.1 AP23.1
Y = Used AP520 API1.1
AR115 AR137
AR14.1 AR190
AR42.2 AR42.7
AR44.3 AR48.3
AR502 AR560
AR575 AR580
AR82.1 ARLL.1
BL123 CA10.2
CB00.3 CB05.1
CB06.1 CB10.1
CB145 CB15.1
CB15.2 CB20.1
CB43.1 CB45.1
CB50.1 CB500
CB543 CB55.1
CB554 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
...
JBOOKHDR FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
JBKSET1 COMPANY AC191 AP125
JRNL-BOOK-NBR AP126 AP181
AP191 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP520
API1.1 API2.1
AR115 AR137
AR14.1 AR190
AR42.2 AR42.7
AR44.3 AR48.3
AR502 AR560
...
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
|