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