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
GL199 GL300 GL325 GL45.1 GL500
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
GLU-COMPANY Numeric 4 CA110 GL110
Company The company number represents an GL146 GL167
established company and is entered on GL190 GL199
all function codes. GL325 GL45.1
GL500 GLSV.1
GLU-FISCAL-YEAR Numeric 4 CA110 GL146
Fiscal Year This is the current fiscal year. This GL167 GL190
field is updated by Period Closing GL199 GL325
(GL199). GL45.1 GL500
GLSV.1
GLU-ACCT-UNIT Alpha 15 CA110 GL146
Accounting Unit The accounting unit is a shorthand GL167 GL190
notation representing the variable level GL199 GL325
number. When used in the General Ledger GL45.1 GL500
Account Master file, the accounting unit GLSV.1
must be defined in the General Ledger
Names file as a posting accounting unit.
GLU-ACCOUNT Numeric 6 CA110 GL146
Account This field along with the accounting GL167 GL190
unit and subaccount make up the location GL199 GL325
(account) where amounts and other GL45.1 GL500
account information is stored. GLSV.1
GLU-SUB-ACCOUNT Numeric 4 CA110 GL146
Subaccount This field along with the accounting GL167 GL190
unit and account make up the location GL199 GL325
(account) where amounts and other GL45.1 GL500
account information is stored. GLSV.1
GLU-VAR-LEVELS Alpha 30 CA110 GL120
Variable Levels A level that represents the location of GL146 GL167
an accounting unit in an organization's GL190 GL199
level structure. GL325 GL45.1
GL500 GLSV.1
GLU-CHART-NAME Alpha 12 CA110 GL146
Chart Name The name assigned to the chart of GL167 GL190
accounts when you defined your company GL199 GL325
structure in the Lawson General Ledger GL45.1 GL500
system. GLSV.1
GLU-DB-BEG-BAL Currency 15.2 FB20.7 GL110
Debit Beginning The debit beginning balance. GL167 GL199
Balance GL281 GL291
GL325 GL500
GLSV.1
GLU-CR-BEG-BAL Currency 15.2 FB20.7 GL110
Credit Beginning The credit beginning balance. GL167 GL199
Balance GL281 GL291
GL325 GL500
GLSV.1
GLU-DB-UNITS Signed 15.2 Occurs 13 Times FB20.7 GL110
Debit Units The debit units. GL146 GL167
GL190 GL281
GL291 GL325
GL45.1 GL500
GLSV.1
GLU-CR-UNITS Signed 15.2 Occurs 13 Times FB20.7 GL110
Credit Units The credit units. GL146 GL167
GL190 GL281
GL291 GL325
GL45.1 GL500
GLSV.1
GLU-ACTIVITY-FLAG Alpha 1 Occurs 13 Times GL167 GL190
Activity Flag Not required. GL325 GL500
When activity for this period has
occurred, a "Y" will be inserted.
Y = Yes
N = No
" " = No
GLU-MAINT-DATE Numeric 8 (yyyymmdd) GL120 GL146
Maintenance Date The date last changed. GL167 GL190
GL199 GL45.1
GL500
GLU-MAINT-TIME Numeric 6 (hhmmss) GL120 GL146
Maintenance Time The time last changed. GL167 GL190
GL199 GL45.1
GL500
GLU-CYBUNT Derived
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
Current Period Unit The total unit amount.
GLU-CUR-PD-SUM-U-D Derived
Cur Pd Sum U D The current period debit units.
GLU-CUR-PD-SUM-U-C Derived
Cur Pd Sum U C The current period credit units.
GLU-CYDUNT Derived
Cydunt The current year-to-date units.
GLU-CYPUNT1-DR Derived
Cypunt1 Dr The current year period one debit unit
amount.
GLU-CYPUNT2-DR Derived
Cypunt2 Dr The current year period two debit unit
amount.
GLU-CYPUNT3-DR Derived
Cypunt3 Dr The current year period three debit
unit amount.
GLU-CYPUNT4-DR Derived
Cypunt4 Dr The current year period four debit unit
amount.
GLU-CYPUNT5-DR Derived
Cypunt5 Dr The current year period five debit unit
amount.
GLU-CYPUNT6-DR Derived
Cypunt6 Dr The current year period six debit unit
amount.
GLU-CYPUNT7-DR Derived
Cypunt7 Dr The current year period seven debit
unit amount.
GLU-CYPUNT8-DR Derived
Cypunt8 Dr The current year period eight debit
unit amount.
GLU-CYPUNT9-DR Derived
Cypunt9 Dr The current year period nine debit unit
amount.
GLU-CYPUNT10-DR Derived
Cypunt10 Dr The current year period ten debit unit
amount.
GLU-CYPUNT11-DR Derived
Cypunt11 Dr The current year period eleven debit
unit amount.
GLU-CYPUNT12-DR Derived
Cypunt12 Dr The current year period twelve debit
unit amount.
GLU-CYPUNT13-DR Derived
Cypunt13 Dr The current year period 13 debit unit
amount.
GLU-CYPUNT1-CR Derived
Cypunt1 Cr The current year period 1 credit unit
amount.
GLU-CYPUNT2-CR Derived
Cypunt2 Cr The current year period 2 credit unit
amount.
GLU-CYPUNT3-CR Derived
Cypunt3 Cr The current year period 3 credit unit
amount.
GLU-CYPUNT4-CR Derived
Cypunt4 Cr The current year period 4 credit unit
amount.
GLU-CYPUNT5-CR Derived
Cypunt5 Cr The current year period 5 credit unit
amount.
GLU-CYPUNT6-CR Derived
Cypunt6 Cr The current year period 6 credit unit
amount.
GLU-CYPUNT7-CR Derived
Cypunt7 Cr The current year period 7 credit unit
amount.
GLU-CYPUNT8-CR Derived
Cypunt8 Cr The current year period 8 credit unit
amount.
GLU-CYPUNT9-CR Derived
Cypunt9 Cr The current year period 9 credit unit
amount.
GLU-CYPUNT10-CR Derived
Cypunt10 Cr The current year period 10 credit unit
amount.
GLU-CYPUNT11-CR Derived
Cypunt11 Cr The current year period 11 credit unit
amount.
GLU-CYPUNT12-CR Derived
Cypunt12 Cr The current year period 12 credit unit
amount.
GLU-CYPUNT13-CR Derived
Cypunt13 Cr The current year period 13 credit unit
amount.
GLU-CYPUNT1 Derived
Cypunt1 The current year period 1 unit amount.
GLU-CYPUNT2 Derived
Cypunt2 The current year period 2 unit amount.
GLU-CYPUNT3 Derived
Cypunt3 The current year period 3 unit amount.
GLU-CYPUNT4 Derived
Cypunt4 The current year period 4 unit amount.
GLU-CYPUNT5 Derived
Cypunt5 The current year period 5 unit amount.
GLU-CYPUNT6 Derived
Cypunt6 The current year period 6 unit amount.
GLU-CYPUNT7 Derived
Cypunt7 The current year period 7 unit amount.
GLU-CYPUNT8 Derived
Cypunt8 The current year period 8 unit amount.
GLU-CYPUNT9 Derived
Cypunt9 The current year period 9 unit amount.
GLU-CYPUNT10 Derived
Cypunt10 The current year period 10 unit amount.
GLU-CYPUNT11 Derived
Cypunt11 The current year period 11 unit amount.
GLU-CYPUNT12 Derived
Cypunt12 The current year period 12 unit amount.
GLU-CYPUNT13 Derived
Cypunt13 The current year period 13 unit amount.
GLU-BLANKAM Derived
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 GL141
GL146 GL167
GL190 GL199
GL281 GL290
GL291 GL300
GL325 GL45.1
GL500 GL90.1
GL90.4 GLOP.1
GLUSET2 FISCAL-YEAR FB120 GL195
COMPANY GL281 GL291
VAR-LEVELS GL325 GLSV.1
ACCOUNT RW80.1 GLRV.1
SUB-ACCOUNT
ACCT-UNIT
GLUSET3 COMPANY GL120 GL122
ACCOUNT GL500 GL20.2
SUB-ACCOUNT
VAR-LEVELS
ACCT-UNIT
FISCAL-YEAR
GLUSET4 FISCAL-YEAR GLSV.1 GLRV.1
VAR-LEVELS
ACCOUNT
SUB-ACCOUNT
COMPANY
ACCT-UNIT
GLUSET5 FISCAL-YEAR GLSV.1 GLRV.1
ACCOUNT
SUB-ACCOUNT
VAR-LEVELS
COMPANY
ACCT-UNIT
GLUSET6 FISCAL-YEAR GL199 GL290
COMPANY GL295 GL320
ACCOUNT GLSV.1 GLRV.1
SUB-ACCOUNT
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
|
