MLUNITS FILE
The Multi Book Ledger Units file contains debit and credit unit balance
information including the ledger, company, fiscal year, accounting unit, and
account records.
REFERENCED BY
RW80.1 MLRV.1
UPDATED BY
GL120
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
MLU-LEDGER Alpha 15
Ledger The ledger being posted to.
MLU-COMPANY Numeric 4
Company This is the company the ledger is
linked to
.~$3 MLUNITS FISCAL-YEAR
This is the fiscal year the unit
amounts are posted to.
MLU-FISCAL-YEAR Numeric 4
Fiscal Year This is the current fiscal year. This
field is updated by Period Closing
(GL199).
MLU-ACCT-UNIT Alpha 15
Accounting Unit This is the accounting unit with which
unit amounts are associated.
MLU-ACCOUNT Numeric 6
Account This is the account with which unit
amounts are associated.
MLU-SUB-ACCOUNT Numeric 4
Subaccount This is the subaccount with which unit
amounts are associated.
MLU-VAR-LEVELS Alpha 30 GL120
Variable Levels This is the variable level with which
unit amounts are associated. A level
represents the location of an accounting
unit in an organization's level
structure.
MLU-CHART-NAME Alpha 12
Chart Name This is the chart of account with which
the company is associated.
MLU-DB-BEG-BAL Currency 15.2
Debit Beginning The debit unit beginning balance.
Balance
MLU-CR-BEG-BAL Currency 15.2
Credit Beginning The credit unit beginning balance.
Balance
MLU-DB-UNITS Signed 15.2 Occurs 13 Times
Debit Units The debit unit amount.
MLU-CR-UNITS Signed 15.2 Occurs 13 Times
Credit Unit The credit unit amount.
MLU-ACTIVITY-FLAG Alpha 1 Occurs 13 Times
Activity Flag When activity for this period has
occurred a "Y" will be inserted. Not
required.
MLU-MAINT-DATE Numeric 8 (yyyymmdd) GL120
Maintenance Date The date the unit record was last
changed.
MLU-MAINT-TIME Numeric 6 (hhmmss) GL120
Maintenance Time The time the unit record was last
changed.
MLU-CYBUNT Derived
Cybunt The current year beginning unit balance.
MLU-CPUNT-DR Derived
Current Period Unit The current period debit unit amount.
Debit
MLU-CPUNT-CR Derived
Current Period Unit The current period credit unit amount.
Credit
MLU-CPUNT Derived
Current Period Unit The current period net unit amount.
MLU-CUR-PD-SUM-U-D Derived
Cur Pd Sum U D The current period summary debit units.
MLU-CUR-PD-SUM-U-C Derived
Cur Pd Sum U C The current period summary credit units.
MLU-CYDUNT Derived
Cydunt The current year-to-date units.
MLU-CYPUNT1-DR Derived
Cypunt1 Dr The current year period 1 debit unit
amount.
MLU-CYPUNT2-DR Derived
Cypunt2 Dr The current year period 2 debit unit
amount.
MLU-CYPUNT3-DR Derived
Cypunt3 Dr The current year period 3 debit unit
amount.
MLU-CYPUNT4-DR Derived
Cypunt4 Dr The current year period 4 debit unit
amount.
MLU-CYPUNT5-DR Derived
Cypunt5 Dr The current year period 5 debit unit
amount.
MLU-CYPUNT6-DR Derived
Cypunt6 Dr The current year period 6 debit unit
amount.
MLU-CYPUNT7-DR Derived
Cypunt7 Dr The current year period 7 debit unit
amount.
MLU-CYPUNT8-DR Derived
Cypunt8 Dr The current year period 8 debit unit
amount.
MLU-CYPUNT9-DR Derived
Cypunt9 Dr The current year period 9 debit unit
amount.
MLU-CYPUNT10-DR Derived
Cypunt10 Dr The current year period 10 debit unit
amount.
MLU-CYPUNT11-DR Derived
Cypunt11 Dr The current year period 11 debit unit
amount.
MLU-CYPUNT12-DR Derived
Cypunt12 Dr The current year period 12 debit unit
amount.
MLU-CYPUNT13-DR Derived
Cypunt13 Dr The current year period 13 debit unit
amount.
MLU-CYPUNT1-CR Derived
Cypunt1 Cr The current year period 1 credit unit
amount.
MLU-CYPUNT2-CR Derived
Cypunt2 Cr The current year period 2 credit unit
amount.
MLU-CYPUNT3-CR Derived
Cypunt3 Cr The current year period 3 credit unit
amount.
MLU-CYPUNT4-CR Derived
Cypunt4 Cr The current year period 4 credit unit
amount.
MLU-CYPUNT5-CR Derived
Cypunt5 Cr The current year period 5 credit unit
amount.
MLU-CYPUNT6-CR Derived
Cypunt6 Cr The current year period 6 credit unit
amount.
MLU-CYPUNT7-CR Derived
Cypunt7 Cr The current year period 7 credit unit
amount.
MLU-CYPUNT8-CR Derived
Cypunt8 Cr The current year period 8 credit unit
amount.
MLU-CYPUNT9-CR Derived
Cypunt9 Cr The current year period 9 credit unit
amount.
MLU-CYPUNT10-CR Derived
Cypunt10 Cr The current year period 10 credit unit
amount.
MLU-CYPUNT11-CR Derived
Cypunt11 Cr The current year period 11 credit unit
amount.
MLU-CYPUNT12-CR Derived
Cypunt12 Cr The current year period 12 credit unit
amount.
MLU-CYPUNT13-CR Derived
Cypunt13 Cr The current year period 13 credit unit
amount.
MLU-CYPUNT1 Derived
Cypunt1 The current year period 1 net unit
amount.
MLU-CYPUNT2 Derived
Cypunt2 The current year period 2 net unit
amount.
MLU-CYPUNT3 Derived
Cypunt3 The current year period 3 net unit
amount.
MLU-CYPUNT4 Derived
Cypunt4 The current year period 4 net unit
amount.
MLU-CYPUNT5 Derived
Cypunt5 The current year period 5 net unit
amount.
MLU-CYPUNT6 Derived
Cypunt6 The current year period 6 net unit
amount.
MLU-CYPUNT7 Derived
Cypunt7 The current year period 7 net unit
amount.
MLU-CYPUNT8 Derived
Cypunt8 The current year period 8 net unit
amount.
MLU-CYPUNT9 Derived
Cypunt9 The current year period 9 net unit
amount.
MLU-CYPUNT10 Derived
Cypunt10 The current year period 10 net unit
amount.
MLU-CYPUNT11 Derived
Cypunt11 The current year period 11 net unit
amount.
MLU-CYPUNT12 Derived
Cypunt12 The current year period 12 net unit
amount.
MLU-CYPUNT13 Derived
Cypunt13 The current year period 13 net unit
amount.
MLU-BLANKAM Derived
Blank This field consists of blank spaces.
It is used to provide column headings on
drill arounds.
MLUNITS FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
MLUSET1 LEDGER
COMPANY
FISCAL-YEAR
ACCT-UNIT
ACCOUNT
SUB-ACCOUNT
MLUSET2 FISCAL-YEAR RW80.1 MLRV.1
LEDGER
COMPANY
VAR-LEVELS
ACCOUNT
SUB-ACCOUNT
ACCT-UNIT
MLUSET3 LEDGER GL120
COMPANY
ACCOUNT
SUB-ACCOUNT
VAR-LEVELS
ACCT-UNIT
FISCAL-YEAR
MLUSET4 FISCAL-YEAR MLRV.1
VAR-LEVELS
ACCOUNT
SUB-ACCOUNT
LEDGER
COMPANY
ACCT-UNIT
MLUSET5 FISCAL-YEAR MLRV.1
ACCOUNT
SUB-ACCOUNT
VAR-LEVELS
LEDGER
COMPANY
ACCT-UNIT
MLUSET6 FISCAL-YEAR MLRV.1
LEDGER
COMPANY
ACCOUNT
SUB-ACCOUNT
VAR-LEVELS
ACCT-UNIT
MLUSET7 MAINT-DATE KeyChange
MAINT-TIME
LEDGER
COMPANY
ACCT-UNIT
ACCOUNT
SUB-ACCOUNT
FISCAL-YEAR
MLUNITS FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Acct Au GLMASTER Required
MLU-COMPANY -> GLM-COMPANY (GLMSET2)
MLU-ACCT-UNIT -> GLM-ACCT-UNIT
MLU-ACCOUNT -> GLM-ACCOUNT
MLU-SUB-ACCOUNT -> GLM-SUB-ACCOUNT
Chart Detail GLCHARTDTL Required
MLU-CHART-NAME -> GDT-CHART-NAME
MLU-ACCOUNT -> GDT-ACCOUNT
MLU-SUB-ACCOUNT -> GDT-SUB-ACCOUNT
Company GLSYSTEM Required
MLU-COMPANY -> GLS-COMPANY
Mlledger MLLEDGER Required
MLU-LEDGER -> MLL-LEDGER
|
