JBKSEQNBR FILE
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
AP170 AP20.1 AP20.2 AP20.5 AP20.7 AP23.1
AR20.1 CB06.2 CB10.1 CB15.1 CB15.2 CB20.1
EE20.2 CA190 GL110 GL146 GL170 GL190
GL199 GL40.2 GL40.7 GL45.1 GL75.1 GL10.1
JB00.1 MA40.1 MA40.2 MA41.1 MA41.2 MA41.4
MA41.5 MA41.6 MA43.1 MA43.2 MA43.3 MA43.4
MA52.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
JSQ-COMPANY Numeric 4 AP170 AP20.1
Company The company number you are defining a AP20.2 AP20.5
journal book for. AP20.7 AP23.1
AR20.1 CA190
CB06.2 CB10.1
CB15.1 CB15.2
CB20.1 EE20.2
GL10.1 GL110
GL146 GL170
GL190 GL199
GL40.2 GL40.7
GL45.1 GL75.1
JB00.1 MA40.1
MA40.2 MA41.1
MA41.2 MA41.4
MA41.5 MA41.6
MA43.1 MA43.2
MA43.3 MA43.4
MA52.1
JSQ-JRNL-BOOK-NBR Alpha 12 AP170 AP20.1
Journal Book Number The Journal Book reference number AP20.2 AP20.5
assigned to group General Ledger AP20.7 AP23.1
transactions. AR20.1 CA190
CB06.2 CB10.1
CB15.1 CB15.2
CB20.1 EE20.2
GL10.1 GL146
GL170 GL190
GL199 GL40.2
GL40.7 GL45.1
GL75.1 JB00.1
MA40.1 MA40.2
MA41.1 MA41.2
MA41.4 MA41.5
MA41.6 MA43.1
MA43.2 MA43.3
MA43.4 MA52.1
JSQ-FISCAL-YEAR Numeric 4 AP170 AP20.1
Fiscal Year This is the fiscal year journal books AP20.2 AP20.5
are defined in. AP20.7 AP23.1
AR20.1 CA190
CB06.2 CB10.1
CB15.1 CB15.2
CB20.1 EE20.2
GL10.1 GL146
GL170 GL190
GL199 GL40.2
GL40.7 GL45.1
GL75.1 JB00.1
MA40.1 MA40.2
MA41.1 MA41.2
MA41.4 MA41.5
MA41.6 MA43.1
MA43.2 MA43.3
MA43.4 MA52.1
JSQ-SEQ-TRNS-NBR Numeric 10 GL10.1 GL146
Transaction Number The last transaction sequence number GL190 GL199
assigned to a company or journal book GL45.1 JB00.1
General Ledger transaction.
JSQ-JBK-LAST-SEQ Numeric 10 AP170 AP20.1
Last Journal Book The last sequence number assigned to a AP20.2 AP20.5
Seq Number journal book transaction at entry time. AP20.7 AP23.1
AR20.1 CA190
CB06.2 CB10.1
CB15.1 CB15.2
CB20.1 EE20.2
GL170 GL40.2
GL40.7 GL75.1
JB00.1 MA40.1
MA40.2 MA41.1
MA41.2 MA41.4
MA41.5 MA41.6
MA43.1 MA43.2
MA43.3 MA43.4
MA52.1
JBKSEQNBR FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
JSQSET1 COMPANY AP170 AP20.1
JRNL-BOOK-NBR AP20.2 AP20.5
FISCAL-YEAR AP20.7 AP23.1
AR20.1 CB06.2
CB10.1 CB15.1
CB15.2 CB20.1
EE20.2 CA190
GL110 GL146
GL170 GL190
GL199 GL40.2
GL40.7 GL45.1
GL75.1 GL10.1
GL210 JB00.1
JB200 MA40.1
MA40.2 MA41.1
...
|