Lawson Insight Technical Documentation |
|
JBKSEQNBR
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
AP150 AP170 AP193 AP20.1 AP20.2 AP20.3
AP20.4 AP20.5 AP20.7 AP21.1 AP23.1 AP520
API1.1 AR20.1 CB06.2 CB10.1 CB15.1 CB15.2
CB150 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.2
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
JSQ-COMPANY Numeric 4 AP150 AP170
Element: Company The company number you are defining a AP193 AP20.1
journal book for. AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP520
API1.1 AR20.1
CA190 CB06.2
CB10.1 CB15.1
CB15.2 CB150
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.2
JSQ-JRNL-BOOK-NBR Alpha 12 AP150 AP170
Element: Journal Book NThe Journal Book reference number AP193 AP20.1
assigned to group General Ledger AP20.2 AP20.3
transactions. AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP520
API1.1 AR20.1
CA190 CB06.2
CB10.1 CB15.1
CB15.2 CB150
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.2
JSQ-FISCAL-YEAR Numeric 4 AP150 AP170
Element: Fiscal Year This is the fiscal year journal books AP193 AP20.1
are defined in. AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP520
API1.1 AR20.1
CA190 CB06.2
CB10.1 CB15.1
CB15.2 CB150
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.2
JSQ-SEQ-TRNS-NBR Numeric 10 GL10.1 GL110
Element: Transaction NuThe last transaction sequence number GL146 GL147
assigned to a company or journal book GL190 GL197
General Ledger transaction. GL199 GL40.1
GL40.2 GL40.3
GL40.7 GL40.8
GL44.1 GL45.1
JB00.1
JSQ-JBK-LAST-SEQ Numeric 10 AP150 AP170
Element: Jbk Last Seq The last sequence number assigned to a AP193 AP20.1
journal book transaction at entry time. AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP520
API1.1 AR20.1
CA190 CB06.2
CB10.1 CB15.1
CB15.2 CB150
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.2
JBKSEQNBR FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
JSQSET1 COMPANY AP150 AP170
JRNL-BOOK-NBR AP193 AP20.1
FISCAL-YEAR AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP520
API1.1 AR20.1
CB06.2 CB10.1
CB15.1 CB15.2
CB150 CB20.1
CB45.1 CB46.1
CB543 CB544
CB55.1 CB554
EE20.2 EE520
CA190 GL110
...
|