GLUNITSX – General Ledger Units-Daily

System
General Ledger (GL)
Prefix
GUX
Primary key
COMPANY, DATE, ACCT-UNIT, ACCOUNT, SUB-ACCOUNT
Fields
12
Updated by
15 programs
Referenced by
3 programs

GLUNITSX is the General Ledger Units-Daily table in Lawson General Ledger (prefix GUX). It is indexed by COMPANY, DATE, ACCT-UNIT, ACCOUNT, SUB-ACCOUNT (GUXSET1); alternate indexes: GUXSET2, GUXSET3 and GUXSET4. It is updated by GL110, GL120, GL146, GL167, GL190, GL197, GL326, GL40.1 and 7 more and referenced by GL243, GL43.1 and GLOP.1. The table has 12 fields, 4 indexes and 0 documented relations.

About GLUNITSX

The General Ledger Units - Daily file contains debit and credit unit balance information by accounting unit, account, and subaccount for the date specified.

Fields (12)

Column = COBOL field name without the GUX- 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
#GUX-COMPANY PK
COMPANY		Numeric 4The Company field contains the company number that is used in the Organization dimension.GL110, GL146, GL167, GL190, GL197, GL326, GL40.1, GL40.2 +5 more
#GUX-DATE PK
DATE		Numeric 8 (yyyymmdd)The Date field contains the system date this was created. The Date format used is YYYYMMDD.GL146, GL167, GL190, GL197, GL326, GL40.1, GL40.2, GL40.3 +4 more
#GUX-ACCT-UNIT PK
ACCT_UNIT		Alpha 15The Accounting Unit field contains the name of the accounting unit that is used in the Organization dimension. If this field is blank, all accounting units are included as members in the dimension outline. This name can contain up to 15 alphabetic characters.GL146, GL167, GL190, GL197, GL326, GL40.1, GL40.2, GL40.3 +4 more
#GUX-ACCOUNT PK
ACCOUNT		Numeric 6This field, along with the accounting unit and subaccount, make up the location (account) where units and other account information are stored.GL146, GL167, GL190, GL197, GL326, GL40.1, GL40.2, GL40.3 +4 more
#GUX-SUB-ACCOUNT PK
SUB_ACCOUNT		Numeric 4This field along with the accounting unit and subaccount make up the location (account) where units and other account information is stored.GL146, GL167, GL190, GL197, GL326, GL40.1, GL40.2, GL40.3 +4 more
#GUX-VAR-LEVELS
VAR_LEVELS		Alpha 30A level that represents the location of an accounting unit in an organization's level structure.GL120, GL146, GL167, GL190, GL197, GL326, GL40.1, GL40.2 +5 more
#GUX-CHART-NAME
CHART_NAME		Alpha 12The Chart of Accounts Name field contains the name of the chart of accounts that is used by the Organization dimension. This name can contain up to 12 alphabetic characters.GL146, GL167, GL190, GL197, GL326, GL40.1, GL40.2, GL40.3 +4 more
#GUX-DB-UNITS
DB_UNITS		Signed 15.2The Debit Units field contains the number of debit units.GL110, GL146, GL167, GL190, GL197, GL326, GL40.1, GL40.2 +5 more
#GUX-CR-UNITS
CR_UNITS		Signed 15.2The Credit Units field contains the number of credit units.GL110, GL146, GL167, GL190, GL197, GL326, GL40.1, GL40.2 +5 more
#GUX-FISCAL-YEAR SET3
FISCAL_YEAR		Numeric 4The Fiscal Year field contains the numeric fiscal year. This field can contain up to four numeric characters.GL146, GL167, GL190, GL197, GL326, GL40.1, GL40.2, GL40.3 +5 more
#GUX-MAINT-DATE SET2
MAINT_DATE		Numeric 8 (yyyymmdd)The Maintenance Date field contains the date that this file was last updated. The date format used is YYYYMMDD.GL120, GL146, GL167, GL190, GL197, GL326, GL40.1, GL40.2 +6 more
#GUX-MAINT-TIME SET2
MAINT_TIME		Numeric 6 (hhmmss)The Maintenance Time field contains the time that this file was last updated. The time format used is HHMMSS.GL120, GL146, GL167, GL190, GL197, GL326, GL40.1, GL40.2 +6 more

Indexes (4)

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
GUXSET1
  1. COMPANY
  2. DATE
  3. ACCT-UNIT
  4. ACCOUNT
  5. SUB-ACCOUNT
PrimaryGL110, GL120, GL146, GL167, GL190, GL197, GL326, GL40.1 +8 more
GUXSET2
  1. MAINT-DATE
  2. MAINT-TIME
  3. COMPANY
  4. DATE
  5. ACCT-UNIT
  6. ACCOUNT
  7. SUB-ACCOUNT
KeyChangeGLOP.1
GUXSET3
  1. COMPANY
  2. FISCAL-YEAR
  3. ACCT-UNIT
  4. ACCOUNT
  5. SUB-ACCOUNT
  6. DATE
KeyChangeGL110
GUXSET4
  1. COMPANY
  2. ACCT-UNIT
  3. ACCOUNT
  4. SUB-ACCOUNT
  5. DATE
GL120, GL243, GL43.1

Programs

Updated by (15)

Referenced by (3)