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.

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
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
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
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 marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
GUXSET1COMPANY, DATE, ACCT-UNIT, ACCOUNT, SUB-ACCOUNTPrimaryGL110, GL120, GL146, GL167, GL190, GL197, GL326, GL40.1 +8 more
GUXSET2MAINT-DATE, MAINT-TIME, COMPANY, DATE, ACCT-UNIT, ACCOUNT, SUB-ACCOUNTKeyChangeGLOP.1
GUXSET3COMPANY, FISCAL-YEAR, ACCT-UNIT, ACCOUNT, SUB-ACCOUNT, DATEKeyChangeGL110
GUXSET4COMPANY, ACCT-UNIT, ACCOUNT, SUB-ACCOUNT, DATEGL120, GL243, GL43.1

Programs

Updated by (15)

Referenced by (3)