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
CA110 | CA190 | GL110 | GL120 | GL146 | GL167 |
GL190 | GL194 | 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 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. |
|
||||||||||||||||||||
GLU-FISCAL-YEAR Element: Fiscal Year | Numeric 4 Contains the fiscal year for the data stored on this record. |
|
||||||||||||||||||||
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. |
|
||||||||||||||||||||
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. |
|
||||||||||||||||||||
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. |
|
||||||||||||||||||||
GLU-VAR-LEVELS Element: Variable Levels | Alpha 30 A level that represents the location of an accounting unit in an organization's level structure. |
|
||||||||||||||||||||
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. |
|
||||||||||||||||||||
GLU-DB-BEG-BAL Debit Beginning Balance | Signed 15.2 The total positive detail auto reversing amounts. |
|
||||||||||||||||||||
GLU-CR-BEG-BAL Credit Beginning Balance | Signed 15.2 The total negative detail auto reversing amounts. |
|
||||||||||||||||||||
GLU-DB-UNITS Element: Debit Units | Signed 15.2 Occurs 13 Times The debit units. |
|
||||||||||||||||||||
GLU-CR-UNITS Element: Credit Units | Signed 15.2 Occurs 13 Times The credit units. |
|
||||||||||||||||||||
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 |
|
||||||||||||||||||||
GLU-MAINT-DATE Element: Maint Date | Numeric 8 (yyyymmdd) The date last changed. |
|
||||||||||||||||||||
GLU-MAINT-TIME Element: Sys Time | Numeric 6 (hhmmss) |
|
||||||||||||||||||||
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. |
|
NAME | KEY FIELDS | DESCRIPTION / SUBSET CONDITION | USED IN | ||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
GLUSET1 |
COMPANY FISCAL-YEAR ACCT-UNIT ACCOUNT SUB-ACCOUNT |
|
| ||||||||||||||||||||||||||||||||||||
GLUSET2 |
FISCAL-YEAR COMPANY VAR-LEVELS ACCOUNT SUB-ACCOUNT ACCT-UNIT |
|
| ||||||||||||||||||||||||||||||||||||
GLUSET3 |
COMPANY ACCOUNT SUB-ACCOUNT VAR-LEVELS ACCT-UNIT FISCAL-YEAR |
|
| ||||||||||||||||||||||||||||||||||||
GLUSET4 |
FISCAL-YEAR VAR-LEVELS ACCOUNT SUB-ACCOUNT COMPANY ACCT-UNIT |
|
| ||||||||||||||||||||||||||||||||||||
GLUSET5 |
FISCAL-YEAR ACCOUNT SUB-ACCOUNT VAR-LEVELS COMPANY ACCT-UNIT |
|
| ||||||||||||||||||||||||||||||||||||
GLUSET6 |
FISCAL-YEAR COMPANY ACCOUNT SUB-ACCOUNT VAR-LEVELS ACCT-UNIT |
|
| ||||||||||||||||||||||||||||||||||||
GLUSET8 |
MAINT-DATE MAINT-TIME COMPANY ACCT-UNIT ACCOUNT SUB-ACCOUNT FISCAL-YEAR |
|
| ||||||||||||||||||||||||||||||||||||
GLUSET9 |
PARENT-VAR-LEV COMPANY ACCOUNT SUB-ACCOUNT FISCAL-YEAR ACCT-UNIT |
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Acct Au | GLMASTER |
Required
| ||||||||||||
Chart Detail | GLCHARTDTL |
Required
| ||||||||||||
Company | GLSYSTEM |
Required
| ||||||||||||
Glnames | GLNAMES |
Required
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | |||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Units Parent | GLCONSOL |
|
All trademarks and registered trademarks are the property of their
respective owners.