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 GL90.6 GLOP.1 GL195 GLSV.1 RW80.1
GLRV.1 GL122 GL20.2 GL295 GL320
UPDATED BY
CA110 CA190 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 Identifies the AP company if the GL146 GL167
resource type = V. Identifies the HR GL190 GL197
company if the resource type = E. It is GL199 GL325
blank for type A, P or Q resources. 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 Contains the fiscal year for the data GL167 GL190
stored on this record. GL197 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 LevelA level that represents the location of GL146 GL167
an accounting unit in an organization's GL190 GL197
level structure. 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 Signed 15.2 FB20.7 GL110
Debit Beginning The total positive detail auto GL167 GL199
Balance reversing amounts. GL281 GL291
GL325 GL330
GL500 GLSV.1
GLU-CR-BEG-BAL Signed 15.2 FB20.7 GL110
Credit Beginning The total negative detail auto GL167 GL199
Balance reversing amounts. GL281 GL291
GL325 GL330
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: Maint Date The date last changed. 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
Element: Cpunt Dr The debit unit amount.
GLU-CPUNT-CR Derived
Element: Cpunt Cr The credit unit amount.
GLU-CPUNT Derived
Element: Cpunt The 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-CYPYTD1 Derived
Element: Cypunt1 Current year period year to date
period 1.
GLU-CYPYTD2 Derived
Element: Cypunt2 Current year period year to date
period 2.
GLU-CYPYTD3 Derived
Element: Cypunt3 Current year period year to date
period 3.
GLU-CYPYTD4 Derived
Element: Cypunt4 Current year period year to date
period 4.
GLU-CYPYTD5 Derived
Element: Cypunt5 Current year period year to date
period 5.
GLU-CYPYTD6 Derived
Element: Cypunt6 Current year period year to date
period 6.
GLU-CYPYTD7 Derived
Element: Cypunt7 Current year period year to date
period 7.
GLU-CYPYTD8 Derived
Element: Cypunt8 Current year period year to date
period 8.
GLU-CYPYTD9 Derived
Element: Cypunt9 Current year period year to date
period 9.
GLU-CYPYTD10 Derived
Element: Cypunt10 Current year period year to date
period 10.
GLU-CYPYTD11 Derived
Element: Cypunt11 Current year period year to date
period 11.
GLU-CYPYTD12 Derived
Element: Cypunt12 Current year period year to date
period 12.
GLU-CYPYTD13 Derived
Element: Cypunt13 Current year period year to date
period 13.
GLU-BLANKAM Derived
Element: Blankam This field consists of blank spaces. It
is used to provide column headings on
Drill Arounds.
GLU-PARENT-VAR-LEV Alpha 30 CA110 GL120
Element: Parent Var LevThe variable level address of the parent GL146 GL167
accounting unit. GL190 GL197
GL199 GL325
GL40.1 GL40.2
GL40.3 GL40.7
GL40.8 GL44.1
GL45.1 GL500
GLUNITS FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
GLUSET1 COMPANY CA110 CA190
FISCAL-YEAR CA290 FB120
ACCT-UNIT FB20.1 FB20.3
ACCOUNT FB20.4 FB20.6
SUB-ACCOUNT FB20.7 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
...
GLUSET2 FISCAL-YEAR KeyChange FB120 GL120
COMPANY GL195 GL281
VAR-LEVELS GL291 GL325
ACCOUNT GLSV.1 RW80.1
SUB-ACCOUNT GLOP.1 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
GLUSET9 PARENT-VAR-LEV
COMPANY
ACCOUNT
SUB-ACCOUNT
FISCAL-YEAR
ACCT-UNIT
GLUNITS FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Acct Au GLMASTER Required
GLU-COMPANY -> GLM-COMPANY (GLMSET2)
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
GLUNITS FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Units Parent GLCONSOL
GLU-PARENT-VAR-LEV -> GCN-VAR-LEVELS
"U" -> GCN-TRANS-TYPE
GLU-COMPANY -> GCN-COMPANY
GLU-ACCOUNT -> GCN-ACCOUNT
GLU-SUB-ACCOUNT -> GCN-SUB-ACCOUNT
GLU-FISCAL-YEAR -> GCN-FISCAL-YEAR
GCN-BUDGET-NBR
GCN-LEVEL-DEPTH
GCN-CURRENCY-CODE
|