JBKSEQNBR

Journal Book Sequence Number

The Journal Book Sequence Number file contains the last sequence number assigned to a General Ledger transaction.

REFERENCED BY
GL210 JB200


UPDATED BY
AP150 AP170 AP193 AP20.1 AP20.2 AP20.3
AP20.4 AP20.5 AP20.7 AP21.1 AP23.1 AP520
API1.1 CB06.2 CB10.1 CB15.1 CB15.2 CB150
CB180 CB20.1 CB45.1 CB46.1 CB543 CB544
CB55.1 CB554 EE20.2 EE520 CA190 GL110
GL146 GL147 GL170 GL190 GL197 GL199
GL40.1 GL40.2 GL40.3 GL40.6 GL40.7 GL40.8
GL44.1 GL45.1 GL70.1 GL70.2 GL70.3 GL70.5
GL70.6 GL75.1 EX175 EX542 EX545 GL10.1
JB00.1 MA41.1 MA41.2 MA41.4 MA41.7 MA42.2
MA43.2 MA44.1 MA44.2 ML146 ML170 ML190
ML199 ML40.1 ML40.2 ML40.3 ML40.6 ML40.7
ML40.8 ML44.1 ML45.1 ML70.1 ML70.2 ML70.3
ML70.5 ML70.6 ML75.1

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
JSQ-COMPANY
Element: Company
Numeric 4
The company number you are defining a journal book for.
...
AP150 AP170
AP193 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP520
API1.1 CA190
CB06.2 CB10.1
CB15.1 CB15.2
CB150 CB180
CB20.1 CB45.1
CB46.1 CB543
CB544 CB55.1
CB554 EE20.2
EE520 EX175
EX542 EX545
GL10.1 GL110
GL146 GL147
GL170 GL190
GL197 GL199
GL40.1 GL40.2
GL40.3 GL40.6
GL40.7 GL40.8
GL44.1 GL45.1
GL70.1 GL70.2
GL70.3 GL70.5
GL70.6 GL75.1
JB00.1 MA41.1
MA41.2 MA41.4
MA41.7 MA42.2
JSQ-JRNL-BOOK-NBR
Element: Journal Book Number
Alpha 12
The Journal Book reference number assigned to group General Ledger transactions.
...
AP150 AP170
AP193 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP520
API1.1 CA190
CB06.2 CB10.1
CB15.1 CB15.2
CB150 CB180
CB20.1 CB45.1
CB46.1 CB543
CB544 CB55.1
CB554 EE20.2
EE520 EX175
EX542 EX545
GL10.1 GL146
GL147 GL170
GL190 GL197
GL199 GL40.1
GL40.2 GL40.3
GL40.6 GL40.7
GL40.8 GL44.1
GL45.1 GL70.1
GL70.2 GL70.3
GL70.5 GL70.6
GL75.1 JB00.1
MA41.1 MA41.2
MA41.4 MA41.7
MA42.2 MA43.2
JSQ-FISCAL-YEAR
Element: Fiscal Year
Numeric 4
This is the fiscal year journal books are defined in.
...
AP150 AP170
AP193 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP520
API1.1 CA190
CB06.2 CB10.1
CB15.1 CB15.2
CB150 CB180
CB20.1 CB45.1
CB46.1 CB543
CB544 CB55.1
CB554 EE20.2
EE520 EX175
EX542 EX545
GL10.1 GL146
GL147 GL170
GL190 GL197
GL199 GL40.1
GL40.2 GL40.3
GL40.6 GL40.7
GL40.8 GL44.1
GL45.1 GL70.1
GL70.2 GL70.3
GL70.5 GL70.6
GL75.1 JB00.1
MA41.1 MA41.2
MA41.4 MA41.7
MA42.2 MA43.2
JSQ-SEQ-TRNS-NBR
Element: Transaction Number
Numeric 10
The last transaction sequence number assigned to a company or journal book General Ledger transaction.
GL10.1 GL110
GL146 GL147
GL190 GL197
GL199 GL40.1
GL40.2 GL40.3
GL40.7 GL40.8
GL44.1 GL45.1
JB00.1 ML146
ML190 ML199
ML40.1 ML40.2
ML40.3 ML40.7
ML40.8 ML44.1
ML45.1
JSQ-JBK-LAST-SEQ
Element: Jbk Last Seq
Numeric 10
The last sequence number assigned to a journal book transaction at entry time.
AP150 AP170
AP193 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP520
API1.1 CA190
CB06.2 CB10.1
CB15.1 CB15.2
CB150 CB180
CB20.1 CB45.1
CB46.1 CB543
CB544 CB55.1
CB554 EE20.2
EE520 EX175
EX542 EX545
GL110 GL170
GL40.2 GL40.6
GL70.1 GL70.2
GL70.3 GL70.5
GL70.6 GL75.1
JB00.1 MA41.1
MA41.2 MA41.4
MA41.7 MA42.2
MA43.2 MA44.1
MA44.2 ML170
ML40.2 ML40.6
ML70.1 ML70.2
ML70.3 ML70.5
ML70.6 ML75.1


JBKSEQNBR FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
JSQSET1 COMPANY
JRNL-BOOK-NBR
FISCAL-YEAR
...
AP150 AP170
AP193 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP520
API1.1 CB06.2
CB10.1 CB15.1
CB15.2 CB150
CB180 CB20.1
CB45.1 CB46.1
CB543 CB544
CB55.1 CB554
EE20.2 EE520
CA190 GL110


File created: Thu Jun 09 11:13:26 2016

Home
Contact Us



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