|
|
MLAMOUNTS FILE
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 is defined in ML10.
MLA-COMPANY Numeric 4
Element: Company The company associated with the balance
record. The company is linked to the
ledger in ML10.
MLA-FISCAL-YEAR Numeric 4
Element: Last Closed YeThe fiscal year associated with the
balance record.
MLA-VAR-LEVELS Alpha 30 GL120
Element: New Levels The variable level address of the
accounting unit for the balance record.
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: Name User The chart of accounts assigned to the
ledger
MLA-DB-BEG-BAL Currency 15.2
Element: Amount The debit beginning balance.
MLA-CR-BEG-BAL Currency 15.2
Element: Amount The credit beginning balance.
MLA-DB-AMOUNT Currency 15.2 Occurs 13 Times
Element: Amount The debit amount.
MLA-CR-AMOUNT Currency 15.2 Occurs 13 Times
Element: 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: Date The date the record was last changed.
MLA-MAINT-TIME Numeric 6 (hhmmss) GL120
Element: Sys Time The 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
Element: Cybamt The current year beginning amount.
MLA-CUR-PD-SUM-DR Derived
Element: Cur Pd Sum Dr The current period summary debit amount.
MLA-CUR-PD-SUM-CR Derived
Element: Cur Pd Sum Cr The current period summary credit
amount.
MLA-CUR-PD-SUM Derived
Element: Cur Pd Sum The current period summary amount.
MLA-CYDAMT Derived
Element: Cydamt The current year-to-date amount.
MLA-CYPAMT1-DR Derived
Period 1 Base Debit The current year period 1 debit amount
Amount
MLA-CYPAMT1-CR Derived
Period 1 Base The current year period 1 credit amount
Credit Amount
MLA-CYPAMT1 Derived
Element: Period 1 Base The current year period 1 amount.
MLA-CYPAMT2-DR Derived
Period 2 Base Debit The current year period 2 debit amount
Amount
MLA-CYPAMT2-CR Derived
Period 2 Base The current year period 2 credit amount
Credit Amount
MLA-CYPAMT2 Derived
Element: Period 2 Base The current year period 2 amount.
MLA-CYPAMT3-DR Derived
Period 3 Base Debit The current year period 3 debit amount
Amount
MLA-CYPAMT3-CR Derived
Period 3 Base The current year period 3 credit amount
Credit Amount
MLA-CYPAMT3 Derived
Element: Period 3 Base The current year period 3 amount.
MLA-CYPAMT4-DR Derived
Period 4 Base Debit The current year period 4 debit amount
Amount
MLA-CYPAMT4-CR Derived
Period 4 Base The current year period 4 credit amount
Credit Amount
MLA-CYPAMT4 Derived
Element: Period 4 Base The current year period 4 amount.
MLA-CYPAMT5-DR Derived
Period 5 Base Debit The current year period 5 debit amount
Amount
MLA-CYPAMT5-CR Derived
Peirod 5 Base The current year period 5 credit amount
Credit Amount
MLA-CYPAMT5 Derived
Element: Peirod 5 Base The current year period 5 amount.
MLA-CYPAMT6-DR Derived
Period 6 Base Debit The current year period 6 debit amount
Amount
MLA-CYPAMT6-CR Derived
Period 6 Base The current year period 6 credit amount
Credit Amount
MLA-CYPAMT6 Derived
Element: Period 6 Base The current year period 6 amount.
MLA-CYPAMT7-DR Derived
Period 7 Base Debit The current year period 7 debit amount
Amount
MLA-CYPAMT7-CR Derived
Period 7 Base The current year period 7 credit amount
Credit Amount
MLA-CYPAMT7 Derived
Element: Period 7 Base The current year period 7 amount.
MLA-CYPAMT8-DR Derived
Period 8 Base The current year period 8 debit amount
Detail Amount
MLA-CYPAMT8-CR Derived
Period 8 Base The current year period 8 credit amount
Credit Amount
MLA-CYPAMT8 Derived
Element: Period 8 Base The current year period 8 amount.
MLA-CYPAMT9-DR Derived
Period 9 Base Debit The current year period 9 debit amount
Amount
MLA-CYPAMT9-CR Derived
Period 9 Base The current year period 9 credit amount
Credit Amount
MLA-CYPAMT9 Derived
Element: Period 9 Base The current year period 9 amount.
MLA-CYPAMT10-DR Derived
Period 10 Base The current year period 10 debit amount
Debit Amount
MLA-CYPAMT10-CR Derived
Period 10 Base The current year period 10 credit amount
Credit Amount
MLA-CYPAMT10 Derived
Period 10 Baes The current year period 10 amount.
Amount
MLA-CYPAMT11-DR Derived
Period 11 Base The current year period 11 debit amount
Debit Amount
MLA-CYPAMT11-CR Derived
Period 11 Base The current year period 11 credit amount
Credit Amount
MLA-CYPAMT11 Derived
Period 11 Base The current year period 11 amount.
Amount
MLA-CYPAMT12-DR Derived
Period 12 Base The current year period 12 debit amount
Debit Amount
MLA-CYPAMT12-CR Derived
Period 12 Base The current year period 12 credit amount
Credit Amount
MLA-CYPAMT12 Derived
Period 12 Base The current year period 12 amount.
Amount
MLA-CYPAMT13-DR Derived
Period 13 Base The current year period 13 debit amount
Debit Amount
MLA-CYPAMT13-CR Derived
Period 13 Base The current year period 13 credit amount
Credit Amount
MLA-CYPAMT13 Derived
Period 13 Base The current year period 13 amount.
Amount
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
Element: Cpamt Thou The current period base amount divided
by 1,000.
MLA-CYDAMT-THOU Derived
Element: Cydamt Thou The current period amount divided by
1000.
MLA-PARENT-OBJ-ID Numeric 12
Object The parent object identifier field
Identification contains the object identifier of the
member parent.
MLAMOUNTS FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
MLASET1 LEDGER
COMPANY
FISCAL-YEAR
ACCT-UNIT
ACCOUNT
SUB-ACCOUNT
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
MLASET8 MAINT-DATE KeyChange
MAINT-TIME
LEDGER
COMPANY
ACCT-UNIT
ACCOUNT
SUB-ACCOUNT
FISCAL-YEAR
MLASET9 PARENT-OBJ-ID KeyChange
LEDGER
COMPANY
ACCT-UNIT
ACCOUNT
SUB-ACCOUNT
FISCAL-YEAR
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
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-OBJ-ID -> MCN-OBJ-ID
"A" -> MCN-TRANS-TYPE
MLA-LEDGER -> MCN-LEDGER
MLA-COMPANY -> MCN-COMPANY
MCN-VAR-LEVELS
MCN-ACCOUNT
MCN-SUB-ACCOUNT
MCN-FISCAL-YEAR
MCN-LEVEL-DEPTH
MCN-CURRENCY-CODE
Mca Curr 1 MLCUAMOUNT
MLA-PARENT-OBJ-ID -> MCA-PARENT-OBJ-ID
3 -> MCA-AMT-TYPE
MLA-LEDGER -> MCA-LEDGER
MLA-COMPANY -> MCA-COMPANY
MLA-ACCT-UNIT -> MCA-ACCT-UNIT
MLA-ACCOUNT -> MCA-ACCOUNT
MLA-SUB-ACCOUNT -> MCA-SUB-ACCOUNT
MLA-VAR-LEVELS -> MCA-VAR-LEVELS
MLA-FISCAL-YEAR -> MCA-FISCAL-YEAR
MCA-CURRENCY-CODE
Mca Curr 2 MLCUAMOUNT
MLA-PARENT-OBJ-ID -> MCA-PARENT-OBJ-ID
4 -> MCA-AMT-TYPE
MLA-LEDGER -> MCA-LEDGER
MLA-COMPANY -> MCA-COMPANY
MLA-ACCT-UNIT -> MCA-ACCT-UNIT
MLA-ACCOUNT -> MCA-ACCOUNT
MLA-SUB-ACCOUNT -> MCA-SUB-ACCOUNT
MLA-VAR-LEVELS -> MCA-VAR-LEVELS
MLA-FISCAL-YEAR -> MCA-FISCAL-YEAR
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
|
