|
|
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
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: Last Closed YeThis is the current fiscal year. This
field is updated by Period Closing
(GL199).
MLU-ACCT-UNIT Alpha 15
Element: Accounting UniThis 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: Subaccount This is the subaccount with which unit
amounts are associated.
MLU-VAR-LEVELS Alpha 30 GL120
Element: New 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: Name User This is the chart of account with which
the company is associated.
MLU-DB-BEG-BAL Currency 15.2
Element: Amount The debit unit beginning balance.
MLU-CR-BEG-BAL Currency 15.2
Element: Amount 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: 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
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
Element: Current PeriodThe 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-BLANKAM Derived
Element: 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 KeyChange RW80.1 MLRV.1
LEDGER
COMPANY
VAR-LEVELS
ACCOUNT
SUB-ACCOUNT
ACCT-UNIT
MLUSET3 LEDGER KeyChange GL120
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 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
|
