JBOOKHDR

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 CB222 GL247 GL256
JB240 DR100 IC141 IC142 IC222 IC83.1
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
AR14.1 ARLL.1 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 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 EX175 EX542
EX545 GL01.1 GL01.2 GL10.1 IFGT.1 JB00.1
MA41.1 MA41.2 MA41.4 MA41.7 MA42.2 MA43.2
MA44.1 MA44.2 MA530 MA540 ML165 ML190
ML40.1 ML40.2 ML40.6 ML40.8 ML44.1 ML45.1
ML65.1 ML70.1 ML70.2 ML70.3 MLIT.1 PO31.1

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
JBK-COMPANY
Element: Company
Numeric 4
The company number you are defining a journal book for.
GL10.1 GL110
JB00.1
JBK-JRNL-BOOK-NBR
Element: Journal Book Number
Alpha 12
The Journal Book reference number assigned to group General Ledger transactions.
GL10.1 JB00.1
JBK-DESCRIPTION
Element: Description
Alpha 30 (Lower Case)
The description of the journal book.
GL10.1 JB00.1
JBK-RESTRICT-SYS
Element: Restrict System
Alpha 1
This indicates if the journal book can only be used in specific systems.
Y = Yes
N = No
GL10.1 JB00.1
JBK-RESTRICT-OPER
Element: Restrict Operator
Alpha 1
This indicates if the journal book can only be used by specific users.
Y = Yes
N = No
GL10.1 JB00.1
JBK-RESTRICT-ACCT
Element: Restrict Accounts
Alpha 1
This indicates if the journal book can only access specific accounts.
Y = Yes
N = No
GL10.1 JB00.1
JBK-CREATE-DATE
Element: Create Date
Numeric 8 (yyyymmdd)
This is the date the journal book was created.
GL10.1 JB00.1
JBK-CREATE-TIME
Element: Create Time
Numeric 6 (hhmmss)
This is the time the journal book was created.
GL10.1 JB00.1
JBK-ACTIVE-STATUS
Element: Active Status
Alpha 1
The status of the journal book.
A = Active
I = Inactive
GL10.1 JB00.1
JBK-MATRIX-LIST
Element: Matrix List
Alpha 12
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.
JB00.1
JBK-USED-FLAG
Element: Used
Alpha 1
Indicates 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
AP21.1 AP23.1
AP520 API1.1
AR14.1 ARLL.1
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
EE20.2 EE20.4
EE520 EX175
EX542 EX545
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
GL70.3 IFGT.1
JB00.1 MA41.1
MA41.2 MA41.4
MA41.7 MA42.2
MA43.2 MA44.1


JBOOKHDR FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
JBKSET1 COMPANY
JRNL-BOOK-NBR
...
AC191 AP125
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
AR14.1 ARLL.1
BR44.1 CB00.3
CB05.1 CB06.1
CB10.1 CB145
CB15.1 CB15.2


JBOOKHDR FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED 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
NAME
RELATED 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


File created: Thu Jun 09 02:20:52 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.