JBKACCT – Journal Book Account

System: General Ledger Setup (IF)
Prefix: JAC
Primary key: COMPANY, JRNL-BOOK-NBR, TH-ACCOUNT, TH-SUB-ACCT
Fields: 6
Updated by: 3 programs
Referenced by: 52 programs

JBKACCT is the Journal Book Account table in Lawson General Ledger Setup (prefix JAC). It is indexed by COMPANY, JRNL-BOOK-NBR, TH-ACCOUNT, TH-SUB-ACCT (JACSET1). It is updated by GL110, JB00.1 and JB00.4 and referenced by AC191, AP125, AP126, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 and 44 more. The table has 6 fields, 1 index and 0 documented relations.

About JBKACCT

The Journal Book Account file contains account records that you choose to include in a Journal Book transactions group in JB00.4 (Journal Book Accounts).

Fields (6)

Column = COBOL field name without the JAC- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / column	Type	Description & values	Updated by
`JAC-COMPANY` PK COMPANY	Numeric 4	The company number you are defining a journal book for.	GL110, JB00.4
`JAC-JRNL-BOOK-NBR` PK JRNL_BOOK_NBR	Alpha 12	The Journal Book reference number assigned to group General Ledger transactions.	JB00.4
`JAC-FR-ACCOUNT` FR_ACCOUNT	Numeric 6	This field along with the accounting unit and subaccount make up the location (account) where amounts and other account information is stored.	JB00.4
`JAC-TH-ACCOUNT` PK TH_ACCOUNT	Numeric 6	This field along with the accounting unit and subaccount make up the location (account) where amounts and other account information is stored.	JB00.4
`JAC-FR-SUB-ACCT` FR_SUB_ACCT	Numeric 4	This field contains the subaccount from your general ledger chart of accounts that was charged with the amount carried on this record.	JB00.4
`JAC-TH-SUB-ACCT` PK TH_SUB_ACCT	Numeric 4	This field contains the subaccount from your general ledger chart of accounts that was charged with the amount carried on this record.	JB00.4

Indexes (1)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

Index	Keys	Flags	Condition	Used in
`JACSET1`	`COMPANY`, `JRNL-BOOK-NBR`, `TH-ACCOUNT`, `TH-SUB-ACCT`	Primary		AC191, AP125, AP126, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +22 more (list truncated in source)

Programs

Updated by (3)

GL110 Company Copy Delete
JB00.1 Journal Book
JB00.4 Journal Book Accounts

Referenced by (52)

AC191 Accounting Unit Balance Post
AP125 Batch Release
AP126 Mass Invoice Release
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
AP25.1 Batch Control
AP25.2 Batch Review
AP26.1 Invoice Release
AP27.1 Single Invoice Release
API1.1 Add Invoice
API2.1 Add Invoice
BR44.1 Mass Transaction Transfer
CB10.1 Cash Receipt Deposit
CB15.1 Bank Fund Transfer - Multiple Deposits
CB15.2 Bank Fund Transfer - Multiple Withdrawals
CB20.1 Bank Transaction Entry
CB222 Cash Position Reconciliation
CB50.1 Bank Transaction Interface Maintenance
CB500 Bank Transaction Interface
CB55.1 Payment Entry
DR100 Distribution Requirements Report
IC141 Location Replenishment Report
IC142 Replenishment by Requisition PO's
IC222 Unreleased Documents
IC83.1 Par Location Counts
IFAC.1 General Ledger Account Edit
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
MA61.1 Match Invoice Approval
MAI1.1 Invoke for MAMATCH Object
RQ10.1 Requisition
RQ10.3 Select and Copy
RQ11.1 Kit Accessories
RQ13.2 Direct Line Approval
RQ35.1 Requisition Returns
RQ500 Requisition Interface
RQIB.1 RQRQHUPD Invoke Object
RQIF.1 RQRLNUPD Invoke Object
RQIJ.1 Requisition Copy