 |
Lawson Insight Technical Documentation |
|
GLUNITSX FILE
General Ledger Units-Daily
The General Ledger Units - Daily file contains debit and credit unit balance
information by accounting unit, account, and subaccount for the date
specified.
REFERENCED BY
GLOP.1 GL243 GL43.1
UPDATED BY
GL110 GL120 GL146 GL167 GL190 GL197
GL326 GL40.1 GL40.2 GL40.3 GL40.7 GL40.8
GL44.1 GL45.1 GL500
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
GUX-COMPANY Numeric 4 GL110 GL146
Company The Company field contains the company GL167 GL190
number that is used in the Organization GL197 GL326
dimension. GL40.1 GL40.2
GL40.3 GL40.7
GL40.8 GL44.1
GL45.1
GUX-DATE Numeric 8 (yyyymmdd) GL146 GL167
Date The Date field contains the system date GL190 GL197
this was created. The Date format used GL326 GL40.1
is YYYYMMDD. GL40.2 GL40.3
GL40.7 GL40.8
GL44.1 GL45.1
GUX-ACCT-UNIT Alpha 15 GL146 GL167
Accounting Unit The Accounting Unit field contains the GL190 GL197
name of the accounting unit that is used GL326 GL40.1
in the Organization dimension. If this GL40.2 GL40.3
field is blank, all accounting units are GL40.7 GL40.8
included as members in the dimension GL44.1 GL45.1
outline. This name can contain up to 15
alphabetic characters.
GUX-ACCOUNT Numeric 6 GL146 GL167
Account This field, along with the accounting GL190 GL197
unit and subaccount, make up the GL326 GL40.1
location (account) where units and other GL40.2 GL40.3
account information are stored. GL40.7 GL40.8
GL44.1 GL45.1
GUX-SUB-ACCOUNT Numeric 4 GL146 GL167
Subaccount This field along with the accounting GL190 GL197
unit and subaccount make up the location GL326 GL40.1
(account) where units and other account GL40.2 GL40.3
information is stored. GL40.7 GL40.8
GL44.1 GL45.1
GUX-VAR-LEVELS Alpha 30 GL120 GL146
Variable Levels A level that represents the location of GL167 GL190
an accounting unit in an organization's GL197 GL326
level structure. GL40.1 GL40.2
GL40.3 GL40.7
GL40.8 GL44.1
GL45.1
GUX-CHART-NAME Alpha 12 GL146 GL167
Chart Name The Chart of Accounts Name field GL190 GL197
contains the name of the chart of GL326 GL40.1
accounts that is used by the GL40.2 GL40.3
Organization dimension. This name can GL40.7 GL40.8
contain up to 12 alphabetic characters. GL44.1 GL45.1
GUX-DB-UNITS Signed 15.2 GL110 GL146
Debit Units The Debit Units field contains the GL167 GL190
number of debit units. GL197 GL326
GL40.1 GL40.2
GL40.3 GL40.7
GL40.8 GL44.1
GL45.1
GUX-CR-UNITS Signed 15.2 GL110 GL146
Credit Unit The Credit Units field contains the GL167 GL190
number of credit units. GL197 GL326
GL40.1 GL40.2
GL40.3 GL40.7
GL40.8 GL44.1
GL45.1
GUX-FISCAL-YEAR Numeric 4 GL146 GL167
Fiscal Year The Fiscal Year field contains the GL190 GL197
numeric fiscal year. This field can GL326 GL40.1
contain up to four numeric characters. GL40.2 GL40.3
GL40.7 GL40.8
GL44.1 GL45.1
GL500
GUX-MAINT-DATE Numeric 8 (yyyymmdd) GL120 GL146
Maintenance Date The Maintenance Date field contains the GL167 GL190
date that this file was last updated. GL197 GL326
The date format used is YYYYMMDD. GL40.1 GL40.2
GL40.3 GL40.7
GL40.8 GL44.1
GL45.1 GL500
GUX-MAINT-TIME Numeric 6 (hhmmss) GL120 GL146
Maintenance Time The Maintenance Time field contains the GL167 GL190
time that this file was last updated. GL197 GL326
The time format used is HHMMSS. GL40.1 GL40.2
GL40.3 GL40.7
GL40.8 GL44.1
GL45.1 GL500
GLUNITSX FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
GUXSET1 COMPANY GL110 GL146
DATE GL167 GL190
ACCT-UNIT GL197 GL326
ACCOUNT GL40.1 GL40.2
SUB-ACCOUNT GL40.3 GL40.7
GL40.8 GL44.1
GL45.1 GL500
GLOP.1
GUXSET2 MAINT-DATE KeyChange GLOP.1
MAINT-TIME
COMPANY
DATE
ACCT-UNIT
ACCOUNT
SUB-ACCOUNT
GUXSET3 COMPANY KeyChange GL110
FISCAL-YEAR
ACCT-UNIT
ACCOUNT
SUB-ACCOUNT
DATE
GUXSET4 COMPANY GL120 GL243
ACCT-UNIT GL43.1
ACCOUNT
SUB-ACCOUNT
DATE
|