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
AP125 AP126 AP25.1 AP25.2 AP26.1 AP27.1
API2.1 GL247 GL256 JB240 IFAC.1 MAI1.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 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 GL01.1 GL01.2 GL10.1
IFGT.1 JB00.1 MA41.1 MA41.2 MA41.4 MA41.7
MA43.1 MA43.2 MA43.3 MA43.4 MA43.6 MA540
JB200

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 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
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 MA43.1
MA43.2 MA43.3
MA43.4 MA43.6
MA540


JBOOKHDR FILE INDEX

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


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: Wed Jun 08 20:49:46 2016

Home
Contact Us



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