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 GL10.1 JB00.1 MA41.1 MA41.2
MA41.4 MA41.7 MA43.1 MA43.2 MA43.3 MA43.4
MA43.6

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


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: Wed Jun 08 20:48:42 2016

Home
Contact Us



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