GLUNITS

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 FB20.1 FB20.3 FB20.4 FB20.6 FB20.7
GL141 GLSV.1


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 FB120 GL281 GL290 GL291
GL90.1 GL90.6 GLOP.1 GL195 RW80.1 GLRV.1
GL122 GL20.2 GL295 GL320

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
GLU-COMPANY
Element: Company
Numeric 4
Identifies the AP company if the resource type = V. Identifies the HR company if the resource type = E. It is blank for type A, P or Q resources.
CA110 GL110
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-FISCAL-YEAR
Element: Fiscal Year
Numeric 4
Contains the fiscal year for the data stored on this record.
CA110 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-ACCT-UNIT
Element: Accounting Unit
Alpha 15
The accounting unit is a shorthand notation representing the variable level number. When used in the General Ledger Account Master file, the accounting unit must be defined in the General Ledger Names file as a posting accounting unit.
CA110 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-ACCOUNT
Element: Account
Numeric 6
This field along with the accounting unit and subaccount make up the location (account) where amounts and other account information is stored.
CA110 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-SUB-ACCOUNT
Element: Subaccount
Numeric 4
This field along with the accounting unit and account make up the location (account) where amounts and other account information is stored.
CA110 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-VAR-LEVELS
Element: Variable Levels
Alpha 30
A level that represents the location of an accounting unit in an organization's level structure.
CA110 GL120
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
Element: Chart Name
Alpha 12
The name assigned to the chart of accounts when you defined your company structure in the Lawson General Ledger system.
CA110 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-DB-BEG-BAL
Debit Beginning
Balance
Signed 15.2
The total positive detail auto reversing amounts.
FB20.7 GL110
GL167 GL199
GL281 GL291
GL325 GL330
GL500 GLSV.1
GLU-CR-BEG-BAL
Credit Beginning
Balance
Signed 15.2
The total negative detail auto reversing amounts.
FB20.7 GL110
GL167 GL199
GL281 GL291
GL325 GL330
GL500 GLSV.1
GLU-DB-UNITS
Element: Debit Units
Signed 15.2 Occurs 13 Times
The debit units.
FB20.7 GL110
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
Element: Credit Units
Signed 15.2 Occurs 13 Times
The credit units.
FB20.7 GL110
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
Element: Activity Flag
Alpha 1 Occurs 13 Times
Not required. When activity for this period has occurred, a "Y" will be inserted.
Y = Yes
N = No
" " = No
GL146 GL167
GL190 GL197
GL325 GL40.1
GL40.2 GL40.3
GL40.7 GL40.8
GL44.1 GL45.1
GL500
GLU-MAINT-DATE
Element: Maint Date
Numeric 8 (yyyymmdd)
The date last changed.
GL120 GL146
GL167 GL190
GL197 GL199
GL330 GL40.1
GL40.2 GL40.3
GL40.7 GL40.8
GL44.1 GL45.1
GL500
GLU-MAINT-TIME
Element: Sys Time
Numeric 6 (hhmmss)
GL120 GL146
GL167 GL190
GL197 GL199
GL330 GL40.1
GL40.2 GL40.3
GL40.7 GL40.8
GL44.1 GL45.1
GL500
GLU-CYBUNT
Element: Cybunt
Derived
The current year beginning unit balance.
GLU-CPUNT-DR
Element: Cpunt Dr
Derived
The debit unit amount.
GLU-CPUNT-CR
Element: Cpunt Cr
Derived
The credit unit amount.
GLU-CPUNT
Element: Cpunt
Derived
The total unit amount.
GLU-CUR-PD-SUM-U-D
Element: Cur Pd Sum U D
Derived
The current period debit units.
GLU-CUR-PD-SUM-U-C
Element: Cur Pd Sum U C
Derived
The current period credit units.
GLU-CYDUNT
Element: Cydunt
Derived
The current year-to-date units.
GLU-CYPUNT1-DR
Element: Cypunt1 Dr
Derived
The current year period one debit unit amount.
GLU-CYPUNT2-DR
Element: Cypunt2 Dr
Derived
The current year period two debit unit amount.
GLU-CYPUNT3-DR
Element: Cypunt3 Dr
Derived
The current year period three debit unit amount.
GLU-CYPUNT4-DR
Element: Cypunt4 Dr
Derived
The current year period four debit unit amount.
GLU-CYPUNT5-DR
Element: Cypunt5 Dr
Derived
The current year period five debit unit amount.
GLU-CYPUNT6-DR
Element: Cypunt6 Dr
Derived
The current year period six debit unit amount.
GLU-CYPUNT7-DR
Element: Cypunt7 Dr
Derived
The current year period seven debit unit amount.
GLU-CYPUNT8-DR
Element: Cypunt8 Dr
Derived
The current year period eight debit unit amount.
GLU-CYPUNT9-DR
Element: Cypunt9 Dr
Derived
The current year period nine debit unit amount.
GLU-CYPUNT10-DR
Element: Cypunt10 Dr
Derived
The current year period ten debit unit amount.
GLU-CYPUNT11-DR
Element: Cypunt11 Dr
Derived
The current year period eleven debit unit amount.
GLU-CYPUNT12-DR
Element: Cypunt12 Dr
Derived
The current year period twelve debit unit amount.
GLU-CYPUNT13-DR
Element: Cypunt13 Dr
Derived
The current year period 13 debit unit amount.
GLU-CYPUNT1-CR
Element: Cypunt1 Cr
Derived
The current year period 1 credit unit amount.
GLU-CYPUNT2-CR
Element: Cypunt2 Cr
Derived
The current year period 2 credit unit amount.
GLU-CYPUNT3-CR
Element: Cypunt3 Cr
Derived
The current year period 3 credit unit amount.
GLU-CYPUNT4-CR
Element: Cypunt4 Cr
Derived
The current year period 4 credit unit amount.
GLU-CYPUNT5-CR
Element: Cypunt5 Cr
Derived
The current year period 5 credit unit amount.
GLU-CYPUNT6-CR
Element: Cypunt6 Cr
Derived
The current year period 6 credit unit amount.
GLU-CYPUNT7-CR
Element: Cypunt7 Cr
Derived
The current year period 7 credit unit amount.
GLU-CYPUNT8-CR
Element: Cypunt8 Cr
Derived
The current year period 8 credit unit amount.
GLU-CYPUNT9-CR
Element: Cypunt9 Cr
Derived
The current year period 9 credit unit amount.
GLU-CYPUNT10-CR
Element: Cypunt10 Cr
Derived
The current year period 10 credit unit amount.
GLU-CYPUNT11-CR
Element: Cypunt11 Cr
Derived
The current year period 11 credit unit amount.
GLU-CYPUNT12-CR
Element: Cypunt12 Cr
Derived
The current year period 12 credit unit amount.
GLU-CYPUNT13-CR
Element: Cypunt13 Cr
Derived
The current year period 13 credit unit amount.
GLU-CYPUNT1
Element: Cypunt1
Derived
The current year period 1 unit amount.
GLU-CYPUNT2
Element: Cypunt2
Derived
The current year period 2 unit amount.
GLU-CYPUNT3
Element: Cypunt3
Derived
The current year period 3 unit amount.
GLU-CYPUNT4
Element: Cypunt4
Derived
The current year period 4 unit amount.
GLU-CYPUNT5
Element: Cypunt5
Derived
The current year period 5 unit amount.
GLU-CYPUNT6
Element: Cypunt6
Derived
The current year period 6 unit amount.
GLU-CYPUNT7
Element: Cypunt7
Derived
The current year period 7 unit amount.
GLU-CYPUNT8
Element: Cypunt8
Derived
The current year period 8 unit amount.
GLU-CYPUNT9
Element: Cypunt9
Derived
The current year period 9 unit amount.
GLU-CYPUNT10
Element: Cypunt10
Derived
The current year period 10 unit amount.
GLU-CYPUNT11
Element: Cypunt11
Derived
The current year period 11 unit amount.
GLU-CYPUNT12
Element: Cypunt12
Derived
The current year period 12 unit amount.
GLU-CYPUNT13
Element: Cypunt13
Derived
The current year period 13 unit amount.
GLU-CYPYTD1
Element: Cypunt1
Derived
Current year period year to date period 1.
GLU-CYPYTD2
Element: Cypunt2
Derived
Current year period year to date period 2.
GLU-CYPYTD3
Element: Cypunt3
Derived
Current year period year to date period 3.
GLU-CYPYTD4
Element: Cypunt4
Derived
Current year period year to date period 4.
GLU-CYPYTD5
Element: Cypunt5
Derived
Current year period year to date period 5.
GLU-CYPYTD6
Element: Cypunt6
Derived
Current year period year to date period 6.
GLU-CYPYTD7
Element: Cypunt7
Derived
Current year period year to date period 7.
GLU-CYPYTD8
Element: Cypunt8
Derived
Current year period year to date period 8.
GLU-CYPYTD9
Element: Cypunt9
Derived
Current year period year to date period 9.
GLU-CYPYTD10
Element: Cypunt10
Derived
Current year period year to date period 10.
GLU-CYPYTD11
Element: Cypunt11
Derived
Current year period year to date period 11.
GLU-CYPYTD12
Element: Cypunt12
Derived
Current year period year to date period 12.
GLU-CYPYTD13
Element: Cypunt13
Derived
Current year period year to date period 13.
GLU-BLANKAM
Element: Blankam
Derived
This field consists of blank spaces. It is used to provide column headings on Drill Arounds.
GLU-PARENT-VAR-LEV
Element: Parent Var Lev
Alpha 30
The variable level address of the parent accounting unit.
CA110 GL120
GL146 GL167
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
FISCAL-YEAR
ACCT-UNIT
ACCOUNT
SUB-ACCOUNT
...
CA110 CA190
CA290 FB120
FB20.1 FB20.3
FB20.4 FB20.6
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
COMPANY
VAR-LEVELS
ACCOUNT
SUB-ACCOUNT
ACCT-UNIT
KeyChange
FB120 GL120
GL195 GL281
GL291 GL325
GLSV.1 RW80.1
GLOP.1 GLRV.1
GLUSET3 COMPANY
ACCOUNT
SUB-ACCOUNT
VAR-LEVELS
ACCT-UNIT
FISCAL-YEAR
KeyChange
GL122 GL500
GL20.2
GLUSET4 FISCAL-YEAR
VAR-LEVELS
ACCOUNT
SUB-ACCOUNT
COMPANY
ACCT-UNIT
KeyChange
GLSV.1 GLRV.1
GLUSET5 FISCAL-YEAR
ACCOUNT
SUB-ACCOUNT
VAR-LEVELS
COMPANY
ACCT-UNIT
KeyChange
GLSV.1 GLRV.1
GLUSET6 FISCAL-YEAR
COMPANY
ACCOUNT
SUB-ACCOUNT
VAR-LEVELS
ACCT-UNIT
KeyChange
GL199 GL290
GL295 GL320
GL325 GL330
GLSV.1 GLRV.1
GLUSET8 MAINT-DATE
MAINT-TIME
COMPANY
ACCT-UNIT
ACCOUNT
SUB-ACCOUNT
FISCAL-YEAR
KeyChange
GLOP.1
GLUSET9 PARENT-VAR-LEV
COMPANY
ACCOUNT
SUB-ACCOUNT
FISCAL-YEAR
ACCT-UNIT
KeyChange


GLUNITS FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED 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
Glnames GLNAMES Required
GLU-COMPANY->GLN-COMPANY
GLU-ACCT-UNIT->GLN-ACCT-UNIT


GLUNITS FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME
RELATED 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


File created: Wed Jun 08 20:48:42 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.