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
Ledger The ledger into which the transactions
are to be interfaced. Must be defined in
MLLEDGER.
MLA-COMPANY Numeric 4
Company The company into which transactions are
to be interfaced.
MLA-FISCAL-YEAR Numeric 4
Fiscal Year The fiscal year for the transactions to
be interfaced. Defaults to the current
fiscal year.
MLA-VAR-LEVELS Alpha 30 GL120
Variable Levels A level that represents the location of
an accounting unit in an organization's
level structure.
MLA-ACCT-UNIT Alpha 15
Accounting Unit The short-hand notation representing
the variable level. It must defined in
the General Ledger as a posting
accounting unit.
MLA-ACCOUNT Numeric 6
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
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
Chart Name The chart of accounts assigned to the
ledger
MLA-DB-BEG-BAL Currency 15.2
Debit Beginning The debit beginning balance.
Balance
MLA-CR-BEG-BAL Currency 15.2
Credit Beginning The credit beginning balance.
Balance
MLA-DB-AMOUNT Currency 15.2 Occurs 13 Times
Debit Amount The debit amount.
MLA-CR-AMOUNT Currency 15.2 Occurs 13 Times
Credit Amount The credit amount.
MLA-ACTIVITY-FLAG Alpha 1 Occurs 13 Times
Activity Flag The field indicates whether there was
activity to this account.
MLA-MAINT-DATE Numeric 8 (yyyymmdd) GL120
Maintenance Date The date the record was last changed.
MLA-MAINT-TIME Numeric 6 (hhmmss) GL120
Maintenance Time The time the record was last changed.
MLA-CPAMT-DR Derived
Current Period Debit The 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
Cybamt The current year beginning amount.
MLA-CUR-PD-SUM-DR Derived
Cur Pd Sum Dr The current period summary debit amount.
MLA-CUR-PD-SUM-CR Derived
Cur Pd Sum Cr The current period summary credit
amount.
MLA-CUR-PD-SUM Derived
Cur Pd Sum The current period summary amount.
MLA-CYDAMT Derived
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
Period 1 Base Amount 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
Period 2 Base Amount 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
Period 3 Base Amount 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
Period 4 Base Amount 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
Peirod 5 Base Amount 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
Period 6 Base Amount 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
Period 7 Base Amount 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
Period 8 Base Amount 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
Period 9 Base Amount 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
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
Cpamt Thou The current period base amount divided
by 1,000.
MLA-CYDAMT-THOU Derived
Cydamt Thou The current period amount divided by
1000.
MLA-PARENT-OBJ-ID Numeric 12
Parent Obj Id The parent object identifier field
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 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 MLRV.1
LEDGER
COMPANY
ACCOUNT
SUB-ACCOUNT
VAR-LEVELS
ACCT-UNIT
MLASET5 FISCAL-YEAR MLRV.1
VAR-LEVELS
ACCOUNT
SUB-ACCOUNT
LEDGER
COMPANY
ACCT-UNIT
MLASET6 FISCAL-YEAR 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
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
|
