JBKSYSCODE – Journal Book System
- System
- General Ledger Setup (IF)
- Prefix
JSC- Primary key
COMPANY,JRNL-BOOK-NBR,SYSTEM- Fields
- 3
- Updated by
- 3 programs
- Referenced by
- 77 programs
JBKSYSCODE is the Journal Book System table in Lawson General Ledger Setup (prefix JSC). It is indexed by COMPANY, JRNL-BOOK-NBR, SYSTEM (JSCSET1). It is related 1:1 to GLCODES. It is updated by GL110, JB00.1 and JB00.2 and referenced by AP181, AP191, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5, AP20.7 and 69 more. The table has 3 fields, 1 index and 1 documented relation.
About JBKSYSCODE
The Journal Book System file contains valid systems that can use the Journal Book in JB00.2 (Journal Book Systems).
Fields (3)
Column = COBOL field name without the JSC- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored. PK = primary key (present in every index); SETn = leading/alternate key of that index.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
#JSC-COMPANY PKCOMPANY | Numeric 4 | The company number you are defining a journal book for. | GL110, JB00.2 |
#JSC-JRNL-BOOK-NBR PKJRNL_BOOK_NBR | Alpha 12 | The Journal Book reference number assigned to group General Ledger transactions. | JB00.2 |
#JSC-SYSTEM PKSYSTEM | Alpha 2 | A two-character code representing an application used within the Lawson system. (i.e., GL = General Ledger, AP = Accounts Payable, and so on.) | JB00.2 |
Indexes (1)
Keys are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.
| Index | Keys | Flags | Condition | Used in |
|---|---|---|---|---|
JSCSET1 |
| Primary | AP181, AP191, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5, AP20.7 +22 more (list truncated in source) |
Relations
One to one (1) — lookups and parents
| Relation | Table | Rules | Condition | Field map | ||||||
|---|---|---|---|---|---|---|---|---|---|---|
| Glcodes | GLCODES | Not Required |
|
Programs
Updated by (3)
Referenced by (77)
- AP181 Bill of Exchange Statement Update
- AP191 Unrealized Gain or Loss
- AP20.1 Basic Invoice
- AP20.2 Taxed Invoice
- AP20.3 Detail Invoice
- AP20.4 Invoice Line Detail
- AP20.5 Multiple Invoice
- AP20.7 Distributions
- AP21.1 View Distributions
- AP23.1 Transit Invoice Entry
- AP520 Invoice Interface
- API1.1 Add Invoice
- AR14.1 Lockbox
- ARLL.1 AR Transaction Interface
- CA10.2 Define Allocation
- CB00.3 Company Cash Code Relationships
- CB05.1 Cash Code Journal Book
- CB06.1 Bank Statement
- CB10.1 Cash Receipt Deposit
- CB145 EFT Extract Update
- CB15.1 Bank Fund Transfer - Multiple Deposits
- CB15.2 Bank Fund Transfer - Multiple Withdrawals
- CB20.1 Bank Transaction Entry
- CB43.1 Receipts Load Maintenance
- CB45.1 EFT/CC Extract Entry
- CB50.1 Bank Transaction Interface Maintenance
- CB500 Bank Transaction Interface
- CB543 Receipts Load
- CB55.1 Payment Entry
- CB554 Payment Load
- EE20.2 Employee Expense
- EE20.4 Employee Payback
- EE520 Expense Interface
- EX175 Company Expense Posting
- EX542 Expense Creation
- EX545 Advance Payback Creation
- GL01.1 System Control
- GL01.2 System Control
- GL10.1 Company
- GL165 Transaction Interface
- GL190 Journal Posting
- GL40.1 Journal Entry
- GL40.2 Define Journal
- GL40.6 Journal Copy
- GL40.8 Journal Entry
- GL44.1 Report Currency Entry
- GL45.1 Journal Control
- GL65.1 Transaction Interface Maintenance
- GL70.1 Recurring Journal
- GL70.2 Define Recurring Journal
- GL70.3 Amounts Only
- IFGT.1 GLTRANS Interface
- JB200 Journal Book Listing
- MA41.1 Add-On Cost Detail - Purchase Order
- MA41.2 Add On Cost Lookup
- MA41.4 Miscellaneous Add-On Cost
- MA41.7 AOC Approval Entry
- MA42.2 Memo Line AOC Detail
- MA43.2 Purchase Order Lookup
- MA44.1 Invoice Line Detail - Purchase Order
- MA44.2 Invoice Line Detail- Service
- MA530 ERS Invoice Creation
- MA540 Invoice Interface
- ML165 Ledger Transaction Interface
- ML190 Ledger Journal Posting
- ML40.1 Ledger Journal Entry
- ML40.2 Define Ledger Journal
- ML40.6 Ledger Journal Copy
- ML40.8 Ledger Journal Entry
- ML44.1 Ledger Report Currency Entry
- ML45.1 Ledger Journal Control
- ML65.1 Ledger Transaction Interface Maintenance
- ML70.1 Ledger Recurring Journal
- ML70.2 Define Recurring Journal
- ML70.3 Amounts Only
- MLIT.1 General Ledger Account Edit
- PO31.1 Vendor Return