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. PK = primary key (present in every index); SETn = leading/alternate key of that index.

Field / columnTypeDescription & valuesUpdated by
#JAC-COMPANY PK
COMPANY
Numeric 4The company number you are defining a journal book for.GL110, JB00.4
#JAC-JRNL-BOOK-NBR PK
JRNL_BOOK_NBR
Alpha 12The Journal Book reference number assigned to group General Ledger transactions.JB00.4
#JAC-FR-ACCOUNT
FR_ACCOUNT
Numeric 6This 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 6This 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 4This 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 4This 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 are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
JACSET1
  1. COMPANY
  2. JRNL-BOOK-NBR
  3. TH-ACCOUNT
  4. TH-SUB-ACCT
PrimaryAC191, AP125, AP126, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +22 more (list truncated in source)

Programs

Updated by (3)

Referenced by (52)