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

GLUNITS FILE RELATIONS

ONE TO ONE RELATIONS

GLUNITS FILE RELATIONS

ONE TO MANY RELATIONS

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