|
|
MLAMOUNTS FILE
Multi-Book Ledger Amounts
The Multi-Book Ledger Amounts-Period file contains beginning and period
account balances by accounting unit, account, and subaccount.
REFERENCED BY
RW80.1 MLRV.1
UPDATED BY
GL120
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
MLA-LEDGER Alpha 15
Element: Ledger The ledger associated with the balance
record. The ledger must be defined in
ML10.
MLA-COMPANY Numeric 4
Element: Company The company into which transactions are
to be interfaced.
MLA-FISCAL-YEAR Numeric 4
Element: Fiscal Year The fiscal year for the transactions to
be interfaced. Defaults to the current
fiscal year.
MLA-VAR-LEVELS Alpha 30 GL120
Element: Variable LevelA level that represents the location of
an accounting unit in an organization's
level structure.
MLA-ACCT-UNIT Alpha 15
Element: Accounting UniThe short-hand notation representing
the variable level. It must defined in
the General Ledger as a posting
accounting unit.
MLA-ACCOUNT Numeric 6
Element: Account This field, along with the accounting
unit and subaccount, make up the
location (account) where amounts and
other account information are stored.
MLA-SUB-ACCOUNT Numeric 4
Element: Subaccount This field, along with the accounting
unit and account, make up the location
(account) where amounts and other
account information are stored.
MLA-CHART-NAME Alpha 12
Element: Chart Name The chart of accounts assigned to the
ledger
MLA-DB-BEG-BAL Signed 18.2
Debit Beginning The debit beginning balance.
Balance
MLA-CR-BEG-BAL Signed 18.2
Credit Beginning The credit beginning balance.
Balance
MLA-DB-AMOUNT Signed 18.2 Occurs 13 Times
Element: Debit Amount The debit amount.
MLA-CR-AMOUNT Signed 18.2 Occurs 13 Times
Element: Credit Amount The credit amount.
MLA-ACTIVITY-FLAG Alpha 1 Occurs 13 Times
Element: Activity Flag The field indicates whether there was
activity to this account.
MLA-MAINT-DATE Numeric 8 (yyyymmdd) GL120
Element: Maintenance DaThe date the record was last changed.
MLA-MAINT-TIME Numeric 6 (hhmmss) GL120
Element: Maintenance TiThe time the record was last changed.
MLA-CPAMT-DR Derived
Element: Current PeriodThe current period debit amount.
MLA-CPAMT-CR Derived
Current Period The current period credit amount.
Credit
MLA-CPAMT Derived
Current Period The total current period amount.
Amount
MLA-CYBAMT Derived
Current Year The current year beginning amount.
Beginning Amount
MLA-CUR-PD-SUM-DR Derived
Current Per Summ The current period summary debit amount.
Debit
MLA-CUR-PD-SUM-CR Derived
Current Per Summ The current period summary credit
Credit amount.
MLA-CUR-PD-SUM Derived
Element: Current Per SuThe current period summary amount.
MLA-CYDAMT Derived
Current Year to The current year-to-date amount.
Date Amount
MLA-CYPAMT1-DR Derived
Current Period 1 The current year period 1 debit amount
Debit Amount
MLA-CYPAMT1-CR Derived
Current Period 1 The current year period 1 credit amount
Credit Amount
MLA-CYPAMT1 Derived
Current Period 1 The current year period 1 amount.
Amount
MLA-CYPYTD1 Derived
Curr Per 1 Year to Current year period year to date
Date Amount period 1.
MLA-CYPAMT2-DR Derived
Current Period 2 The current year period 2 debit amount
Debit Amount
MLA-CYPAMT2-CR Derived
Current Period 2 The current year period 2 credit amount
Credit Amount
MLA-CYPAMT2 Derived
Current Period 2 The current year period 2 amount.
Amount
MLA-CYPYTD2 Derived
Curr Per 2 Year to Current year period year to date
Date Amount period 2.
MLA-CYPAMT3-DR Derived
Current Period 3 The current year period 3 debit amount
Debit Amount
MLA-CYPAMT3-CR Derived
Current Period 3 The current year period 3 credit amount
Credit Amount
MLA-CYPAMT3 Derived
Current Period 3 The current year period 3 amount.
Amount
MLA-CYPYTD3 Derived
Curr Per 3 Year to Current year period year to date
Date Amount period 3.
MLA-CYPAMT4-DR Derived
Current Period 4 The current year period 4 debit amount
Debit Amount
MLA-CYPAMT4-CR Derived
Current Period 4 The current year period 4 credit amount
Credit Amount
MLA-CYPAMT4 Derived
Current Period 4 The current year period 4 amount.
Amount
MLA-CYPYTD4 Derived
Curr Per 4 Year to Current year period year to date
Date Amount period 4.
MLA-CYPAMT5-DR Derived
Current Period 5 The current year period 5 debit amount
Debit Amount
MLA-CYPAMT5-CR Derived
Current Period 5 The current year period 5 credit amount
Credit Amount
MLA-CYPAMT5 Derived
Current Period 5 The current year period 5 amount.
Amount
MLA-CYPYTD5 Derived
Curr Per 5 Year to Current year period year to date
Date Amount period 5.
MLA-CYPAMT6-DR Derived
Current Period 6 The current year period 6 debit amount
Debit Amount
MLA-CYPAMT6-CR Derived
Current Period 6 The current year period 6 credit amount
Credit Amount
MLA-CYPAMT6 Derived
Current Period 6 The current year period 6 amount.
Amount
MLA-CYPYTD6 Derived
Curr Per 6 Year to Current year period year to date
Date Amount period 6.
MLA-CYPAMT7-DR Derived
Current Period 7 The current year period 7 debit amount
Debit Amount
MLA-CYPAMT7-CR Derived
Current Period 7 The current year period 7 credit amount
Credit Amount
MLA-CYPAMT7 Derived
Current Period 7 The current year period 7 amount.
Amount
MLA-CYPYTD7 Derived
Curr Per 7 Year to Current year period year to date
Date Amount period 7.
MLA-CYPAMT8-DR Derived
Current Period 8 The current year period 8 debit amount
Debit Amount
MLA-CYPAMT8-CR Derived
Current Period 8 The current year period 8 credit amount
Credit Amount
MLA-CYPAMT8 Derived
Current Period 8 The current year period 8 amount.
Amount
MLA-CYPYTD8 Derived
Curr Per 8 Year to Current year period year to date
Date Amount period 8.
MLA-CYPAMT9-DR Derived
Current Period 9 The current year period 9 debit amount
Debit Amount
MLA-CYPAMT9-CR Derived
Current Period 9 The current year period 9 credit amount
Credit Amount
MLA-CYPAMT9 Derived
Current Period 9 The current year period 9 amount.
Amount
MLA-CYPYTD9 Derived
Curr Per 9 Year to Current year period year to date
Date Amount period 9.
MLA-CYPAMT10-DR Derived
Current Period 10 The current year period 10 debit amount
Debit Amount
MLA-CYPAMT10-CR Derived
Current Period 10 The current year period 10 credit amount
Credit Amt
MLA-CYPAMT10 Derived
Current Period 10 The current year period 10 amount.
Amount
MLA-CYPYTD10 Derived
Curr Per 10 Year to Current year period year to date
Date Amt period 10.
MLA-CYPAMT11-DR Derived
Current Period 11 The current year period 11 debit amount
Debit Amount
MLA-CYPAMT11-CR Derived
Current Period 11 The current year period 11 credit amount
Credit Amt
MLA-CYPAMT11 Derived
Current Period 11 The current year period 11 amount.
Amount
MLA-CYPYTD11 Derived
Curr Per 11 Year to Current year period year to date
Date Amt period 11.
MLA-CYPAMT12-DR Derived
Cuurent Period 12 The current year period 12 debit amount
Debit Amount
MLA-CYPAMT12-CR Derived
Current Period 12 The current year period 12 credit amount
Credit Amt
MLA-CYPAMT12 Derived
Current Period 12 The current year period 12 amount.
Amount
MLA-CYPYTD12 Derived
Curr Per 12 Year to Current year period year to date
Date Amt period 12.
MLA-CYPAMT13-DR Derived
Current Period 13 The current year period 13 debit amount
Debit Amount
MLA-CYPAMT13-CR Derived
Current Period 13 The current year period 13 credit amount
Credit Amt
MLA-CYPAMT13 Derived
Current Period 13 The current year period 13 amount.
Amount
MLA-CYPYTD13 Derived
Curr Per 13 Year to Current year period year to date
Date Amt period 13.
MLA-BLANK Derived
Element: Blank This derived field is always blank. It
is used in the Drill Around feature for
column headings.
.~$3 MLAMOUNTS CPAMT-THOU
MLA-CPAMT-THOU Derived
Current Period The current period base amount divided
Thousands by 1,000.
MLA-CYDAMT-THOU Derived
Current Year to The current period amount divided by
Date Thousands 1000.
MLA-PARENT-VAR-LEV Alpha 30 GL120
Parent Variable The variable level address of the parent
Level accounting unit.
MLAMOUNTS FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
MLASET1 LEDGER GL120
COMPANY
FISCAL-YEAR
ACCT-UNIT
ACCOUNT
SUB-ACCOUNT
MLASET10 PARENT-VAR-LEV
LEDGER
COMPANY
ACCOUNT
SUB-ACCOUNT
FISCAL-YEAR
ACCT-UNIT
MLASET2 FISCAL-YEAR KeyChange RW80.1 MLRV.1
LEDGER
COMPANY
VAR-LEVELS
ACCOUNT
SUB-ACCOUNT
ACCT-UNIT
MLASET3 LEDGER GL120
COMPANY
ACCT-UNIT
ACCOUNT
SUB-ACCOUNT
FISCAL-YEAR
MLASET4 FISCAL-YEAR KeyChange MLRV.1
LEDGER
COMPANY
ACCOUNT
SUB-ACCOUNT
VAR-LEVELS
ACCT-UNIT
MLASET5 FISCAL-YEAR KeyChange MLRV.1
VAR-LEVELS
ACCOUNT
SUB-ACCOUNT
LEDGER
COMPANY
ACCT-UNIT
MLASET6 FISCAL-YEAR KeyChange MLRV.1
ACCOUNT
SUB-ACCOUNT
VAR-LEVELS
LEDGER
COMPANY
ACCT-UNIT
MLASET7 LEDGER
COMPANY
FISCAL-YEAR
ACCOUNT
SUB-ACCOUNT
ACCT-UNIT
MLAMOUNTS FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Chart Detail GLCHARTDTL Required
MLA-CHART-NAME -> GDT-CHART-NAME (GDTSET2)
MLA-ACCOUNT -> GDT-ACCOUNT
MLA-SUB-ACCOUNT -> GDT-SUB-ACCOUNT
Company GLSYSTEM Required
MLA-COMPANY -> GLS-COMPANY
Glmaster GLMASTER Required
MLA-COMPANY -> GLM-COMPANY
MLA-ACCT-UNIT -> GLM-ACCT-UNIT
MLA-ACCOUNT -> GLM-ACCOUNT
MLA-SUB-ACCOUNT -> GLM-SUB-ACCOUNT
Mlcoledger MLCOLEDGER Required
MLA-LEDGER -> MLE-LEDGER
MLA-COMPANY -> MLE-COMPANY
MLAMOUNTS FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Annual Amounts MLAMOUNTS
MLA-LEDGER -> MLA-LEDGER
MLA-COMPANY -> MLA-COMPANY
MLA-ACCT-UNIT -> MLA-ACCT-UNIT
MLA-ACCOUNT -> MLA-ACCOUNT
MLA-SUB-ACCOUNT -> MLA-SUB-ACCOUNT
MLA-FISCAL-YEAR
Company Trans MLTRANS
MLA-LEDGER -> MLT-LEDGER
MLA-COMPANY -> MLT-TO-COMPANY
MLA-FISCAL-YEAR -> MLT-FISCAL-YEAR
MLE-ACCT-PERIOD -> MLT-ACCT-PERIOD
MLA-ACCOUNT -> MLT-ACCOUNT
MLA-SUB-ACCOUNT -> MLT-SUB-ACCOUNT
MLT-ACCT-UNIT
MLT-OBJ-ID
Consol Parent MLCONSOL
MLA-PARENT-VAR-LEV -> MCN-VAR-LEVELS
"A" -> MCN-TRANS-TYPE
MLA-LEDGER -> MCN-LEDGER
MLA-COMPANY -> MCN-COMPANY
MLA-ACCOUNT -> MCN-ACCOUNT
MLA-SUB-ACCOUNT -> MCN-SUB-ACCOUNT
MLA-FISCAL-YEAR -> MCN-FISCAL-YEAR
MCN-LEVEL-DEPTH
MCN-CURRENCY-CODE
Mca Curr 1 MLCUAMOUNT
MLA-PARENT-VAR-LEV -> MCA-PARENT-VAR-LEV
3 -> MCA-AMT-TYPE
MLA-LEDGER -> MCA-LEDGER
MLA-COMPANY -> MCA-COMPANY
MLA-ACCOUNT -> MCA-ACCOUNT
MLA-SUB-ACCOUNT -> MCA-SUB-ACCOUNT
MLA-FISCAL-YEAR -> MCA-FISCAL-YEAR
MLA-ACCT-UNIT -> MCA-ACCT-UNIT
MLA-VAR-LEVELS -> MCA-VAR-LEVELS
MCA-CURRENCY-CODE
Mca Curr 2 MLCUAMOUNT
MLA-PARENT-VAR-LEV -> MCA-PARENT-VAR-LEV
4 -> MCA-AMT-TYPE
MLA-LEDGER -> MCA-LEDGER
MLA-COMPANY -> MCA-COMPANY
MLA-ACCOUNT -> MCA-ACCOUNT
MLA-SUB-ACCOUNT -> MCA-SUB-ACCOUNT
MLA-FISCAL-YEAR -> MCA-FISCAL-YEAR
MLA-ACCT-UNIT -> MCA-ACCT-UNIT
MLA-VAR-LEVELS -> MCA-VAR-LEVELS
MCA-CURRENCY-CODE
Trans One Prd MLTRANS
MLA-LEDGER -> MLT-LEDGER
MLA-COMPANY -> MLT-TO-COMPANY
MLA-FISCAL-YEAR -> MLT-FISCAL-YEAR
MLE-ACCT-PERIOD -> MLT-ACCT-PERIOD
MLA-ACCT-UNIT -> MLT-ACCT-UNIT
MLA-ACCOUNT -> MLT-ACCOUNT
MLA-SUB-ACCOUNT -> MLT-SUB-ACCOUNT
MLT-OBJ-ID
Trans One Prds MLTRANS
MLA-LEDGER -> MLT-LEDGER
MLA-COMPANY -> MLT-TO-COMPANY
MLA-ACCOUNT -> MLT-ACCOUNT
MLA-SUB-ACCOUNT -> MLT-SUB-ACCOUNT
MLA-ACCT-UNIT -> MLT-ACCT-UNIT
MLE-FISCAL-YEAR -> MLT-FISCAL-YEAR
MLT-ACCT-PERIOD
MLT-OBJ-ID
|
