|
|
GLUNITS FILE
General Ledger Units - Period
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 GLSV.1 RW80.1 GLRV.1 GL122
GL20.2 GL295 GL320
UPDATED BY
CA110 GL110 GL120 GL146 GL167 GL190
GL199 GL300 GL324 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. GL324 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 GL199 (Period GL199 GL324
Closing). GL325 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 GL324
number. When used in the General Ledger GL325 GL45.1
Account Master file, the accounting unit GL500 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 GL324
(account) where amounts and other GL325 GL45.1
account information is stored. GL500 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 GL324
(account) where amounts and other GL325 GL45.1
account information is stored. GL500 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. GL324 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 GL324
structure in the Lawson General Ledger GL325 GL45.1
system. GL500 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. GL324 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
Current Year Unit The current year beginning unit balance.
Begin Bal
GLU-CPUNT-DR Derived
Current Period Unit The debit unit amount.
Debit
GLU-CPUNT-CR Derived
Currenct Period The credit unit amount.
Unit 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
Current Year Per 1 The current year period one debit unit
Unit Debit amount.
GLU-CYPUNT2-DR Derived
Current Year Per 2 The current year period two debit unit
Unit Debit amount.
GLU-CYPUNT3-DR Derived
Current Year Per 3 The current year period three debit
Unit Debit unit amount.
GLU-CYPUNT4-DR Derived
Current Year Per 4 The current year period four debit unit
Unit Debit amount.
GLU-CYPUNT5-DR Derived
Current Year Per 5 The current year period five debit unit
Unit Debit amount.
GLU-CYPUNT6-DR Derived
Current Year Per 6 The current year period six debit unit
Unit Debit amount.
GLU-CYPUNT7-DR Derived
Current Year Per 7 The current year period seven debit
Unit Debit unit amount.
GLU-CYPUNT8-DR Derived
Current Year Per 8 The current year period eight debit
Unit Debit unit amount.
GLU-CYPUNT9-DR Derived
Current Year Per 9 The current year period nine debit unit
Unit Debit amount.
GLU-CYPUNT10-DR Derived
Current Year Per 10 The current year period ten debit unit
Unit Debit amount.
GLU-CYPUNT11-DR Derived
Current Year Per 11 The current year period eleven debit
Unit Debit unit amount.
GLU-CYPUNT12-DR Derived
Current Year Per 12 The current year period twelve debit
Unit Debit unit amount.
GLU-CYPUNT13-DR Derived
Current Year Per 13 The current year period 13 debit unit
Unit Debit amount.
GLU-CYPUNT1-CR Derived
Current Year Per 1 The current year period 1 credit unit
Unit Credit amount.
GLU-CYPUNT2-CR Derived
Current Year Per 2 The current year period 2 credit unit
Unit Credit amount.
GLU-CYPUNT3-CR Derived
Current Year Per 3 The current year period 3 credit unit
Unit Credit amount.
GLU-CYPUNT4-CR Derived
Current Year Per 4 The current year period 4 credit unit
Unit Credit amount.
GLU-CYPUNT5-CR Derived
Current Year Per 5 The current year period 5 credit unit
Unit Credit amount.
GLU-CYPUNT6-CR Derived
Current Year Per 6 The current year period 6 credit unit
Unit Credit amount.
GLU-CYPUNT7-CR Derived
Current Year Per 7 The current year period 7 credit unit
Unit Credit amount.
GLU-CYPUNT8-CR Derived
Current Year Per 8 The current year period 8 credit unit
Unit Credit amount.
GLU-CYPUNT9-CR Derived
Current Year Per 9 The current year period 9 credit unit
Unit Credit amount.
GLU-CYPUNT10-CR Derived
Curr Year Per 10 The current year period 10 credit unit
Unit Credit amount.
GLU-CYPUNT11-CR Derived
Curr Year Per 11 The current year period 11 credit unit
Unit Credit amount.
GLU-CYPUNT12-CR Derived
Curr Year Per 12 The current year period 12 credit unit
Unit Credit amount.
GLU-CYPUNT13-CR Derived
Curr Year Per 13 The current year period 13 credit unit
Unit Credit amount.
GLU-CYPUNT1 Derived
Current Year Per 1 The current year period 1 unit amount.
Unit Amt
GLU-CYPUNT2 Derived
Current Year Per 2 The current year period 2 unit amount.
Unit Amt
GLU-CYPUNT3 Derived
Current Year Per 3 The current year period 3 unit amount.
Unit Amt
GLU-CYPUNT4 Derived
Current Year Per 4 The current year period 4 unit amount.
Unit Amt
GLU-CYPUNT5 Derived
Current Year Per 5 The current year period 5 unit amount.
Unit Amt
GLU-CYPUNT6 Derived
Current Year Per 6 The current year period 6 unit amount.
Unit Amt
GLU-CYPUNT7 Derived
Current Year Per 7 The current year period 7 unit amount.
Unit Amt
GLU-CYPUNT8 Derived
Current Year Per 8 The current year period 8 unit amount.
Unit Amt
GLU-CYPUNT9 Derived
Current Year Per 9 The current year period 9 unit amount.
Unit Amt
GLU-CYPUNT10 Derived
Current Year Per 10 The current year period 10 unit amount.
Unit Amt
GLU-CYPUNT11 Derived
Current Year Per 11 The current year period 11 unit amount.
Unit Amt
GLU-CYPUNT12 Derived
Current Year Per 12 The current year period 12 unit amount.
Unit Amt
GLU-CYPUNT13 Derived
Current Year Per 13 The current year period 13 unit amount.
Unit Amt
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
GL324 GL325
GL45.1 GL500
GL90.1 GL90.4
GLOP.1
GLUSET2 FISCAL-YEAR FB120 GL281
COMPANY GL291 GLSV.1
VAR-LEVELS RW80.1 GLRV.1
ACCOUNT
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
|