Lawson Insight Technical Documentation |
|
GLUNITS
GLUNITS FILE
General Ledger Units
The General Ledger Units file contains debit and credit unit balance
information including the company, fiscal year, accounting unit, and account
records.
REFERENCED BY
CA290 FB120 FB20.1 FB20.3 FB20.4 FB20.6
FB20.7 GL141 GL281 GL290 GL291 GL90.1
GL90.4 GLOP.1 GL195 GLSV.1 RW80.1 GLRV.1
GL122 GL20.2 GL295 GL320
UPDATED BY
CA110 GL110 GL120 GL146 GL167 GL190
GL197 GL199 GL300 GL325 GL330 GL40.1
GL40.2 GL40.3 GL40.7 GL40.8 GL44.1 GL45.1
GL500
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
GLU-COMPANY Numeric 4 CA110 GL110
Element: Company The company number represents an GL146 GL167
established company and is entered on GL190 GL197
all function codes. GL199 GL325
GL330 GL40.1
GL40.2 GL40.3
GL40.7 GL40.8
GL44.1 GL45.1
GL500 GLSV.1
GLU-FISCAL-YEAR Numeric 4 CA110 GL146
Element: Fiscal Year This is the current fiscal year. This GL167 GL190
field is updated by Period Closing GL197 GL199
(GL199). GL325 GL330
GL40.1 GL40.2
GL40.3 GL40.7
GL40.8 GL44.1
GL45.1 GL500
GLSV.1
GLU-ACCT-UNIT Alpha 15 CA110 GL146
Element: Accounting UniThe accounting unit is a shorthand GL167 GL190
notation representing the variable level GL197 GL199
number. When used in the General Ledger GL325 GL330
Account Master file, the accounting unit GL40.1 GL40.2
must be defined in the General Ledger GL40.3 GL40.7
Names file as a posting accounting unit. GL40.8 GL44.1
GL45.1 GL500
GLSV.1
GLU-ACCOUNT Numeric 6 CA110 GL146
Element: Account This field along with the accounting GL167 GL190
unit and subaccount make up the location GL197 GL199
(account) where amounts and other GL325 GL330
account information is stored. GL40.1 GL40.2
GL40.3 GL40.7
GL40.8 GL44.1
GL45.1 GL500
GLSV.1
GLU-SUB-ACCOUNT Numeric 4 CA110 GL146
Element: Subaccount This field along with the accounting GL167 GL190
unit and account make up the location GL197 GL199
(account) where amounts and other GL325 GL330
account information is stored. GL40.1 GL40.2
GL40.3 GL40.7
GL40.8 GL44.1
GL45.1 GL500
GLSV.1
GLU-VAR-LEVELS Alpha 30 CA110 GL120
Element: Variable Levels GL146 GL167
GL190 GL197
GL199 GL325
GL330 GL40.1
GL40.2 GL40.3
GL40.7 GL40.8
GL44.1 GL45.1
GL500 GLSV.1
GLU-CHART-NAME Alpha 12 CA110 GL146
Element: Chart Name The name assigned to the chart of GL167 GL190
accounts when you defined your company GL197 GL199
structure in the Lawson General Ledger GL325 GL330
system. GL40.1 GL40.2
GL40.3 GL40.7
GL40.8 GL44.1
GL45.1 GL500
GLSV.1
GLU-DB-BEG-BAL Currency 15.2 FB20.7 GL110
Debit Beginning GL167 GL199
Balance GL281 GL291
GL325 GL500
GLSV.1
GLU-CR-BEG-BAL Currency 15.2 FB20.7 GL110
Credit Beginning GL167 GL199
Balance GL281 GL291
GL325 GL500
GLSV.1
GLU-DB-UNITS Signed 15.2 Occurs 13 Times FB20.7 GL110
Element: Debit Units The debit units. GL146 GL167
GL190 GL197
GL281 GL291
GL325 GL330
GL40.1 GL40.2
GL40.3 GL40.7
GL40.8 GL44.1
GL45.1 GL500
GLSV.1
GLU-CR-UNITS Signed 15.2 Occurs 13 Times FB20.7 GL110
Element: Credit Units The credit units. GL146 GL167
GL190 GL197
GL281 GL291
GL325 GL330
GL40.1 GL40.2
GL40.3 GL40.7
GL40.8 GL44.1
GL45.1 GL500
GLSV.1
GLU-ACTIVITY-FLAG Alpha 1 Occurs 13 Times GL146 GL167
Element: Activity Flag Not required. GL190 GL197
When activity for this period has GL325 GL40.1
occurred, a "Y" will be inserted. GL40.2 GL40.3
GL40.7 GL40.8
Y = Yes GL44.1 GL45.1
N = No GL500
" " = No
GLU-MAINT-DATE Numeric 8 (yyyymmdd) GL120 GL146
Element: Date GL167 GL190
GL197 GL199
GL330 GL40.1
GL40.2 GL40.3
GL40.7 GL40.8
GL44.1 GL45.1
GL500
GLU-MAINT-TIME Numeric 6 (hhmmss) GL120 GL146
Element: Sys Time GL167 GL190
GL197 GL199
GL330 GL40.1
GL40.2 GL40.3
GL40.7 GL40.8
GL44.1 GL45.1
GL500
GLU-CYBUNT Derived
Element: Cybunt The current year beginning unit
balance.
GLU-CPUNT-DR Derived
Current Period Unit The debit unit amount.
Debit
GLU-CPUNT-CR Derived
Current Period Unit The credit unit amount.
Credit
GLU-CPUNT Derived
Element: Current PeriodThe total unit amount.
GLU-CUR-PD-SUM-U-D Derived
Element: Cur Pd Sum U DThe current period debit units.
GLU-CUR-PD-SUM-U-C Derived
Element: Cur Pd Sum U CThe current period credit units.
GLU-CYDUNT Derived
Element: Cydunt The current year-to-date units.
GLU-CYPUNT1-DR Derived
Element: Cypunt1 Dr The current year period one debit unit
amount.
GLU-CYPUNT2-DR Derived
Element: Cypunt2 Dr The current year period two debit unit
amount.
GLU-CYPUNT3-DR Derived
Element: Cypunt3 Dr The current year period three debit
unit amount.
GLU-CYPUNT4-DR Derived
Element: Cypunt4 Dr The current year period four debit unit
amount.
GLU-CYPUNT5-DR Derived
Element: Cypunt5 Dr The current year period five debit unit
amount.
GLU-CYPUNT6-DR Derived
Element: Cypunt6 Dr The current year period six debit unit
amount.
GLU-CYPUNT7-DR Derived
Element: Cypunt7 Dr The current year period seven debit
unit amount.
GLU-CYPUNT8-DR Derived
Element: Cypunt8 Dr The current year period eight debit
unit amount.
GLU-CYPUNT9-DR Derived
Element: Cypunt9 Dr The current year period nine debit unit
amount.
GLU-CYPUNT10-DR Derived
Element: Cypunt10 Dr The current year period ten debit unit
amount.
GLU-CYPUNT11-DR Derived
Element: Cypunt11 Dr The current year period eleven debit
unit amount.
GLU-CYPUNT12-DR Derived
Element: Cypunt12 Dr The current year period twelve debit
unit amount.
GLU-CYPUNT13-DR Derived
Element: Cypunt13 Dr The current year period 13 debit unit
amount.
GLU-CYPUNT1-CR Derived
Element: Cypunt1 Cr The current year period 1 credit unit
amount.
GLU-CYPUNT2-CR Derived
Element: Cypunt2 Cr The current year period 2 credit unit
amount.
GLU-CYPUNT3-CR Derived
Element: Cypunt3 Cr The current year period 3 credit unit
amount.
GLU-CYPUNT4-CR Derived
Element: Cypunt4 Cr The current year period 4 credit unit
amount.
GLU-CYPUNT5-CR Derived
Element: Cypunt5 Cr The current year period 5 credit unit
amount.
GLU-CYPUNT6-CR Derived
Element: Cypunt6 Cr The current year period 6 credit unit
amount.
GLU-CYPUNT7-CR Derived
Element: Cypunt7 Cr The current year period 7 credit unit
amount.
GLU-CYPUNT8-CR Derived
Element: Cypunt8 Cr The current year period 8 credit unit
amount.
GLU-CYPUNT9-CR Derived
Element: Cypunt9 Cr The current year period 9 credit unit
amount.
GLU-CYPUNT10-CR Derived
Element: Cypunt10 Cr The current year period 10 credit unit
amount.
GLU-CYPUNT11-CR Derived
Element: Cypunt11 Cr The current year period 11 credit unit
amount.
GLU-CYPUNT12-CR Derived
Element: Cypunt12 Cr The current year period 12 credit unit
amount.
GLU-CYPUNT13-CR Derived
Element: Cypunt13 Cr The current year period 13 credit unit
amount.
GLU-CYPUNT1 Derived
Element: Cypunt1 The current year period 1 unit amount.
GLU-CYPUNT2 Derived
Element: Cypunt2 The current year period 2 unit amount.
GLU-CYPUNT3 Derived
Element: Cypunt3 The current year period 3 unit amount.
GLU-CYPUNT4 Derived
Element: Cypunt4 The current year period 4 unit amount.
GLU-CYPUNT5 Derived
Element: Cypunt5 The current year period 5 unit amount.
GLU-CYPUNT6 Derived
Element: Cypunt6 The current year period 6 unit amount.
GLU-CYPUNT7 Derived
Element: Cypunt7 The current year period 7 unit amount.
GLU-CYPUNT8 Derived
Element: Cypunt8 The current year period 8 unit amount.
GLU-CYPUNT9 Derived
Element: Cypunt9 The current year period 9 unit amount.
GLU-CYPUNT10 Derived
Element: Cypunt10 The current year period 10 unit amount.
GLU-CYPUNT11 Derived
Element: Cypunt11 The current year period 11 unit amount.
GLU-CYPUNT12 Derived
Element: Cypunt12 The current year period 12 unit amount.
GLU-CYPUNT13 Derived
Element: Cypunt13 The current year period 13 unit amount.
GLU-BLANKAM Derived
Element: Blank This field consists of blank spaces. It
is used to provide column headings on
Drill Arounds.
GLUNITS FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
GLUSET1 COMPANY CA110 CA290
FISCAL-YEAR FB120 FB20.1
ACCT-UNIT FB20.3 FB20.4
ACCOUNT FB20.6 FB20.7
SUB-ACCOUNT GL110 GL120
GL141 GL146
GL167 GL190
GL197 GL199
GL281 GL290
GL291 GL300
GL325 GL330
GL40.1 GL40.2
GL40.3 GL40.7
GL40.8 GL44.1
GL45.1 GL500
...
GLUSET2 FISCAL-YEAR KeyChange FB120 GL195
COMPANY GL281 GL291
VAR-LEVELS GL325 GLSV.1
ACCOUNT RW80.1 GLOP.1
SUB-ACCOUNT GLRV.1
ACCT-UNIT
GLUSET3 COMPANY KeyChange GL122 GL500
ACCOUNT GL20.2
SUB-ACCOUNT
VAR-LEVELS
ACCT-UNIT
FISCAL-YEAR
GLUSET4 FISCAL-YEAR KeyChange GLSV.1 GLRV.1
VAR-LEVELS
ACCOUNT
SUB-ACCOUNT
COMPANY
ACCT-UNIT
GLUSET5 FISCAL-YEAR KeyChange GLSV.1 GLRV.1
ACCOUNT
SUB-ACCOUNT
VAR-LEVELS
COMPANY
ACCT-UNIT
GLUSET6 FISCAL-YEAR KeyChange GL199 GL290
COMPANY GL295 GL320
ACCOUNT GL325 GL330
SUB-ACCOUNT GLSV.1 GLRV.1
VAR-LEVELS
ACCT-UNIT
GLUSET8 MAINT-DATE KeyChange GLOP.1
MAINT-TIME
COMPANY
ACCT-UNIT
ACCOUNT
SUB-ACCOUNT
FISCAL-YEAR
GLUNITS FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Acct Au GLMASTER Required
GLU-COMPANY -> GLM-COMPANY
GLU-ACCT-UNIT -> GLM-ACCT-UNIT
GLU-ACCOUNT -> GLM-ACCOUNT
GLU-SUB-ACCOUNT -> GLM-SUB-ACCOUNT
Chart Detail GLCHARTDTL Required
GLU-CHART-NAME -> GDT-CHART-NAME
GLU-ACCOUNT -> GDT-ACCOUNT
GLU-SUB-ACCOUNT -> GDT-SUB-ACCOUNT
Company GLSYSTEM Required
GLU-COMPANY -> GLS-COMPANY
|