|
|
MLUNITS FILE
ML Units
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
Element: Ledger The ledger being posted to.
MLU-COMPANY Numeric 4
Element: 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
Element: Year Contains the fiscal year for the data
stored on this record.
MLU-ACCT-UNIT Alpha 15
Element: Acct Unit This is the accounting unit with which
unit amounts are associated.
MLU-ACCOUNT Numeric 6
Element: Account This is the account with which unit
amounts are associated.
MLU-SUB-ACCOUNT Numeric 4
Element: Sub Acct This is the subaccount with which unit
amounts are associated.
MLU-VAR-LEVELS Alpha 30 GL120
Element: Var 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
Element: Chart Name This is the chart of account with which
the company is associated.
MLU-DB-BEG-BAL Signed 18.2
Element: Intl Amt The debit unit beginning balance.
MLU-CR-BEG-BAL Signed 18.2
Element: Intl Amt The credit unit beginning balance.
MLU-DB-UNITS Signed 15.2 Occurs 13 Times
Element: Auto Debits The debit unit amount.
MLU-CR-UNITS Signed 15.2 Occurs 13 Times
Element: Auto Credits The credit unit amount.
MLU-ACTIVITY-FLAG Alpha 1 Occurs 13 Times
Element: Activity Flag When activity for this period has
occurred a "Y" will be inserted. Not
required.
MLU-MAINT-DATE Numeric 8 (yyyymmdd) GL120
Element: Maint Date The date the unit record was last
changed.
MLU-MAINT-TIME Numeric 6 (hhmmss) GL120
Element: Sys Time The time the unit record was last
changed.
MLU-CYBUNT Derived
Element: Cybunt The current year beginning unit balance.
MLU-CPUNT-DR Derived
Element: Cpunt Dr The current period debit unit amount.
MLU-CPUNT-CR Derived
Element: Cpunt Cr The current period credit unit amount.
MLU-CPUNT Derived
Element: Cpunt The current period net unit amount.
MLU-CUR-PD-SUM-U-D Derived
Element: Cur Pd Sum U DThe current period summary debit units.
MLU-CUR-PD-SUM-U-C Derived
Element: Cur Pd Sum U CThe current period summary credit units.
MLU-CYDUNT Derived
Element: Cydunt The current year-to-date units.
MLU-CYPUNT1-DR Derived
Element: Cypunt1 Dr The current year period 1 debit unit
amount.
MLU-CYPUNT2-DR Derived
Element: Cypunt2 Dr The current year period 2 debit unit
amount.
MLU-CYPUNT3-DR Derived
Element: Cypunt3 Dr The current year period 3 debit unit
amount.
MLU-CYPUNT4-DR Derived
Element: Cypunt4 Dr The current year period 4 debit unit
amount.
MLU-CYPUNT5-DR Derived
Element: Cypunt5 Dr The current year period 5 debit unit
amount.
MLU-CYPUNT6-DR Derived
Element: Cypunt6 Dr The current year period 6 debit unit
amount.
MLU-CYPUNT7-DR Derived
Element: Cypunt7 Dr The current year period 7 debit unit
amount.
MLU-CYPUNT8-DR Derived
Element: Cypunt8 Dr The current year period 8 debit unit
amount.
MLU-CYPUNT9-DR Derived
Element: Cypunt9 Dr The current year period 9 debit unit
amount.
MLU-CYPUNT10-DR Derived
Element: Cypunt10 Dr The current year period 10 debit unit
amount.
MLU-CYPUNT11-DR Derived
Element: Cypunt11 Dr The current year period 11 debit unit
amount.
MLU-CYPUNT12-DR Derived
Element: Cypunt12 Dr The current year period 12 debit unit
amount.
MLU-CYPUNT13-DR Derived
Element: Cypunt13 Dr The current year period 13 debit unit
amount.
MLU-CYPUNT1-CR Derived
Element: Cypunt1 Cr The current year period 1 credit unit
amount.
MLU-CYPUNT2-CR Derived
Element: Cypunt2 Cr The current year period 2 credit unit
amount.
MLU-CYPUNT3-CR Derived
Element: Cypunt3 Cr The current year period 3 credit unit
amount.
MLU-CYPUNT4-CR Derived
Element: Cypunt4 Cr The current year period 4 credit unit
amount.
MLU-CYPUNT5-CR Derived
Element: Cypunt5 Cr The current year period 5 credit unit
amount.
MLU-CYPUNT6-CR Derived
Element: Cypunt6 Cr The current year period 6 credit unit
amount.
MLU-CYPUNT7-CR Derived
Element: Cypunt7 Cr The current year period 7 credit unit
amount.
MLU-CYPUNT8-CR Derived
Element: Cypunt8 Cr The current year period 8 credit unit
amount.
MLU-CYPUNT9-CR Derived
Element: Cypunt9 Cr The current year period 9 credit unit
amount.
MLU-CYPUNT10-CR Derived
Element: Cypunt10 Cr The current year period 10 credit unit
amount.
MLU-CYPUNT11-CR Derived
Element: Cypunt11 Cr The current year period 11 credit unit
amount.
MLU-CYPUNT12-CR Derived
Element: Cypunt12 Cr The current year period 12 credit unit
amount.
MLU-CYPUNT13-CR Derived
Element: Cypunt13 Cr The current year period 13 credit unit
amount.
MLU-CYPUNT1 Derived
Element: Cypunt1 The current year period 1 net unit
amount.
MLU-CYPUNT2 Derived
Element: Cypunt2 The current year period 2 net unit
amount.
MLU-CYPUNT3 Derived
Element: Cypunt3 The current year period 3 net unit
amount.
MLU-CYPUNT4 Derived
Element: Cypunt4 The current year period 4 net unit
amount.
MLU-CYPUNT5 Derived
Element: Cypunt5 The current year period 5 net unit
amount.
MLU-CYPUNT6 Derived
Element: Cypunt6 The current year period 6 net unit
amount.
MLU-CYPUNT7 Derived
Element: Cypunt7 The current year period 7 net unit
amount.
MLU-CYPUNT8 Derived
Element: Cypunt8 The current year period 8 net unit
amount.
MLU-CYPUNT9 Derived
Element: Cypunt9 The current year period 9 net unit
amount.
MLU-CYPUNT10 Derived
Element: Cypunt10 The current year period 10 net unit
amount.
MLU-CYPUNT11 Derived
Element: Cypunt11 The current year period 11 net unit
amount.
MLU-CYPUNT12 Derived
Element: Cypunt12 The current year period 12 net unit
amount.
MLU-CYPUNT13 Derived
Element: Cypunt13 The current year period 13 net unit
amount.
MLU-CYPYTD1 Derived
Element: Cypunt1 Current year period year to date
period 1.
MLU-CYPYTD2 Derived
Element: Cypunt2 Current year period year to date
period 2.
MLU-CYPYTD3 Derived
Element: Cypunt3 Current year period year to date
period 3.
MLU-CYPYTD4 Derived
Element: Cypunt4 Current year period year to date
period 4.
MLU-CYPYTD5 Derived
Element: Cypunt5 Current year period year to date
period 5.
MLU-CYPYTD6 Derived
Element: Cypunt6 Current year period year to date
period 6.
MLU-CYPYTD7 Derived
Element: Cypunt7 Current year period year to date
period 7.
MLU-CYPYTD8 Derived
Element: Cypunt8 Current year period year to date
period 8.
MLU-CYPYTD9 Derived
Element: Cypunt9 Current year period year to date
period 9.
MLU-CYPYTD10 Derived
Element: Cypunt10 Current year period year to date
period 10.
MLU-CYPYTD11 Derived
Element: Cypunt11 Current year period year to date
period 11.
MLU-CYPYTD12 Derived
Element: Cypunt12 Current year period year to date
period 12.
MLU-CYPYTD13 Derived
Element: Cypunt13 Current year period year to date
period 13.
MLU-BLANKAM Derived
Element: Blankam This field consists of blank spaces.
It is used to provide column headings on
drill arounds.
MLU-PARENT-VAR-LEV Alpha 30 GL120
Element: Parent Var LevThe variable level address of the parent
accounting unit.
MLUNITS FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
MLUSET1 LEDGER GL120
COMPANY
FISCAL-YEAR
ACCT-UNIT
ACCOUNT
SUB-ACCOUNT
MLUSET2 FISCAL-YEAR KeyChange GL120 RW80.1
LEDGER MLRV.1
COMPANY
VAR-LEVELS
ACCOUNT
SUB-ACCOUNT
ACCT-UNIT
MLUSET3 LEDGER KeyChange
COMPANY
ACCOUNT
SUB-ACCOUNT
VAR-LEVELS
ACCT-UNIT
FISCAL-YEAR
MLUSET4 FISCAL-YEAR KeyChange MLRV.1
VAR-LEVELS
ACCOUNT
SUB-ACCOUNT
LEDGER
COMPANY
ACCT-UNIT
MLUSET5 FISCAL-YEAR KeyChange MLRV.1
ACCOUNT
SUB-ACCOUNT
VAR-LEVELS
LEDGER
COMPANY
ACCT-UNIT
MLUSET6 FISCAL-YEAR KeyChange MLRV.1
LEDGER
COMPANY
ACCOUNT
SUB-ACCOUNT
VAR-LEVELS
ACCT-UNIT
MLUSET7 PARENT-VAR-LEV
LEDGER
COMPANY
ACCOUNT
SUB-ACCOUNT
FISCAL-YEAR
ACCT-UNIT
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
MLUNITS FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Annual Units MLUNITS
MLU-LEDGER -> MLU-LEDGER
MLU-COMPANY -> MLU-COMPANY
MLU-ACCOUNT -> MLU-ACCOUNT
MLU-SUB-ACCOUNT -> MLU-SUB-ACCOUNT
MLU-VAR-LEVELS -> MLU-VAR-LEVELS
MLU-ACCT-UNIT -> MLU-ACCT-UNIT
MLU-FISCAL-YEAR
Mlunit Parent MLCONSOL
MLU-PARENT-VAR-LEV -> MCN-VAR-LEVELS
"U" -> MCN-TRANS-TYPE
MLU-LEDGER -> MCN-LEDGER
MLU-COMPANY -> MCN-COMPANY
MLU-ACCOUNT -> MCN-ACCOUNT
MLU-SUB-ACCOUNT -> MCN-SUB-ACCOUNT
MLU-FISCAL-YEAR -> MCN-FISCAL-YEAR
MCN-LEVEL-DEPTH
MCN-CURRENCY-CODE
|
