MLAMOUNTS

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
ML195 ML290 ML291 ML320 ML90.1 ML90.4
RW80.1 ML196


UPDATED BY
GL120 GL20.2 ML110 ML146 ML167 ML190
ML199 ML300 ML325 ML327 ML330 ML40.1
ML40.2 ML40.3 ML40.7 ML40.8 ML44.1 ML45.1
MLRV.1

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
MLA-LEDGER
Element: Ledger
Alpha 15
The ledger associated with the balance record. The ledger must be defined in ML10.
ML110 ML146
ML167 ML190
ML199 ML325
ML330 ML40.1
ML40.2 ML40.3
ML40.7 ML40.8
ML44.1 ML45.1
MLA-COMPANY
Element: Company
Numeric 4
The company into which transactions are to be interfaced.
ML146 ML167
ML190 ML199
ML325 ML327
ML330 ML40.1
ML40.2 ML40.3
ML40.7 ML40.8
ML44.1 ML45.1
MLA-FISCAL-YEAR
Element: Fiscal Year
Numeric 4
The fiscal year for the transactions to be interfaced. Defaults to the current fiscal year.
ML146 ML167
ML190 ML199
ML325 ML327
ML330 ML40.1
ML40.2 ML40.3
ML40.7 ML40.8
ML44.1 ML45.1
MLA-VAR-LEVELS
Element: Variable Levels
Alpha 30
A level that represents the location of an accounting unit in an organization's level structure.
GL120 ML146
ML167 ML190
ML199 ML325
ML327 ML330
ML40.1 ML40.2
ML40.3 ML40.7
ML40.8 ML44.1
ML45.1
MLA-ACCT-UNIT
Element: Accounting Unit
Alpha 15
The short-hand notation representing the variable level. It must defined in the General Ledger as a posting accounting unit.
ML146 ML167
ML190 ML199
ML325 ML327
ML330 ML40.1
ML40.2 ML40.3
ML40.7 ML40.8
ML44.1 ML45.1
MLA-ACCOUNT
Element: Account
Numeric 6
This field, along with the accounting unit and subaccount, make up the location (account) where amounts and other account information are stored.
ML146 ML167
ML190 ML199
ML325 ML327
ML330 ML40.1
ML40.2 ML40.3
ML40.7 ML40.8
ML44.1 ML45.1
MLA-SUB-ACCOUNT
Element: Subaccount
Numeric 4
This field, along with the accounting unit and account, make up the location (account) where amounts and other account information are stored.
ML146 ML167
ML190 ML199
ML325 ML327
ML330 ML40.1
ML40.2 ML40.3
ML40.7 ML40.8
ML44.1 ML45.1
MLA-CHART-NAME
Element: Chart Name
Alpha 12
The chart of accounts assigned to the ledger
ML146 ML167
ML190 ML199
ML325 ML327
ML330 ML40.1
ML40.2 ML40.3
ML40.7 ML40.8
ML44.1 ML45.1
MLA-DB-BEG-BAL
Debit Beginning
Balance
Signed 18.2
The debit beginning balance.
ML110 ML167
ML199 ML291
ML325
MLA-CR-BEG-BAL
Credit Beginning
Balance
Signed 18.2
The credit beginning balance.
ML110 ML167
ML199 ML291
ML325
MLA-DB-AMOUNT
Element: Debit Amount
Signed 18.2 Occurs 13 Times
The debit amount.
ML110 ML146
ML167 ML190
ML291 ML325
ML330 ML40.1
ML40.2 ML40.3
ML40.7 ML40.8
ML44.1 ML45.1
MLA-CR-AMOUNT
Element: Credit Amount
Signed 18.2 Occurs 13 Times
The credit amount.
ML110 ML146
ML167 ML190
ML291 ML325
ML330 ML40.1
ML40.2 ML40.3
ML40.7 ML40.8
ML44.1 ML45.1
MLA-ACTIVITY-FLAG
Element: Activity Flag
Alpha 1 Occurs 13 Times
The field indicates whether there was activity to this account.
ML146 ML167
ML190 ML325
ML40.1 ML40.2
ML40.3 ML40.7
ML40.8 ML44.1
ML45.1
MLA-MAINT-DATE
Element: Maintenance Date
Numeric 8 (yyyymmdd)
The date the record was last changed.
GL120 ML146
ML167 ML190
ML199 ML330
ML40.1 ML40.2
ML40.3 ML40.7
ML40.8 ML44.1
ML45.1
MLA-MAINT-TIME
Element: Maintenance Time
Numeric 6 (hhmmss)
The time the record was last changed.
GL120 ML146
ML167 ML190
ML199 ML330
ML40.1 ML40.2
ML40.3 ML40.7
ML40.8 ML44.1
ML45.1
MLA-CPAMT-DR
Element: Current Period Debit
Derived
The current period debit amount.
MLA-CPAMT-CR
Current Period
Credit
Derived
The current period credit amount.
MLA-CPAMT
Current Period
Amount
Derived
The total current period amount.
MLA-CYBAMT
Current Year
Beginning Amount
Derived
The current year beginning amount.
MLA-CUR-PD-SUM-DR
Current Per Summ
Debit
Derived
The current period summary debit amount.
MLA-CUR-PD-SUM-CR
Current Per Summ
Credit
Derived
The current period summary credit amount.
MLA-CUR-PD-SUM
Element: Current Per Summ
Derived
The current period summary amount.
MLA-CYDAMT
Current Year to
Date Amount
Derived
The current year-to-date amount.
MLA-CYPAMT1-DR
Current Period 1
Debit Amount
Derived
The current year period 1 debit amount
MLA-CYPAMT1-CR
Current Period 1
Credit Amount
Derived
The current year period 1 credit amount
MLA-CYPAMT1
Current Period 1
Amount
Derived
The current year period 1 amount.
MLA-CYPYTD1
Curr Per 1 Year to
Date Amount
Derived
Current year period year to date period 1.
MLA-CYPAMT2-DR
Current Period 2
Debit Amount
Derived
The current year period 2 debit amount
MLA-CYPAMT2-CR
Current Period 2
Credit Amount
Derived
The current year period 2 credit amount
MLA-CYPAMT2
Current Period 2
Amount
Derived
The current year period 2 amount.
MLA-CYPYTD2
Curr Per 2 Year to
Date Amount
Derived
Current year period year to date period 2.
MLA-CYPAMT3-DR
Current Period 3
Debit Amount
Derived
The current year period 3 debit amount
MLA-CYPAMT3-CR
Current Period 3
Credit Amount
Derived
The current year period 3 credit amount
MLA-CYPAMT3
Current Period 3
Amount
Derived
The current year period 3 amount.
MLA-CYPYTD3
Curr Per 3 Year to
Date Amount
Derived
Current year period year to date period 3.
MLA-CYPAMT4-DR
Current Period 4
Debit Amount
Derived
The current year period 4 debit amount
MLA-CYPAMT4-CR
Current Period 4
Credit Amount
Derived
The current year period 4 credit amount
MLA-CYPAMT4
Current Period 4
Amount
Derived
The current year period 4 amount.
MLA-CYPYTD4
Curr Per 4 Year to
Date Amount
Derived
Current year period year to date period 4.
MLA-CYPAMT5-DR
Current Period 5
Debit Amount
Derived
The current year period 5 debit amount
MLA-CYPAMT5-CR
Current Period 5
Credit Amount
Derived
The current year period 5 credit amount
MLA-CYPAMT5
Current Period 5
Amount
Derived
The current year period 5 amount.
MLA-CYPYTD5
Curr Per 5 Year to
Date Amount
Derived
Current year period year to date period 5.
MLA-CYPAMT6-DR
Current Period 6
Debit Amount
Derived
The current year period 6 debit amount
MLA-CYPAMT6-CR
Current Period 6
Credit Amount
Derived
The current year period 6 credit amount
MLA-CYPAMT6
Current Period 6
Amount
Derived
The current year period 6 amount.
MLA-CYPYTD6
Curr Per 6 Year to
Date Amount
Derived
Current year period year to date period 6.
MLA-CYPAMT7-DR
Current Period 7
Debit Amount
Derived
The current year period 7 debit amount
MLA-CYPAMT7-CR
Current Period 7
Credit Amount
Derived
The current year period 7 credit amount
MLA-CYPAMT7
Current Period 7
Amount
Derived
The current year period 7 amount.
MLA-CYPYTD7
Curr Per 7 Year to
Date Amount
Derived
Current year period year to date period 7.
MLA-CYPAMT8-DR
Current Period 8
Debit Amount
Derived
The current year period 8 debit amount
MLA-CYPAMT8-CR
Current Period 8
Credit Amount
Derived
The current year period 8 credit amount
MLA-CYPAMT8
Current Period 8
Amount
Derived
The current year period 8 amount.
MLA-CYPYTD8
Curr Per 8 Year to
Date Amount
Derived
Current year period year to date period 8.
MLA-CYPAMT9-DR
Current Period 9
Debit Amount
Derived
The current year period 9 debit amount
MLA-CYPAMT9-CR
Current Period 9
Credit Amount
Derived
The current year period 9 credit amount
MLA-CYPAMT9
Current Period 9
Amount
Derived
The current year period 9 amount.
MLA-CYPYTD9
Curr Per 9 Year to
Date Amount
Derived
Current year period year to date period 9.
MLA-CYPAMT10-DR
Current Period 10
Debit Amount
Derived
The current year period 10 debit amount
MLA-CYPAMT10-CR
Current Period 10
Credit Amt
Derived
The current year period 10 credit amount
MLA-CYPAMT10
Current Period 10
Amount
Derived
The current year period 10 amount.
MLA-CYPYTD10
Curr Per 10 Year to
Date Amt
Derived
Current year period year to date period 10.
MLA-CYPAMT11-DR
Current Period 11
Debit Amount
Derived
The current year period 11 debit amount
MLA-CYPAMT11-CR
Current Period 11
Credit Amt
Derived
The current year period 11 credit amount
MLA-CYPAMT11
Current Period 11
Amount
Derived
The current year period 11 amount.
MLA-CYPYTD11
Curr Per 11 Year to
Date Amt
Derived
Current year period year to date period 11.
MLA-CYPAMT12-DR
Cuurent Period 12
Debit Amount
Derived
The current year period 12 debit amount
MLA-CYPAMT12-CR
Current Period 12
Credit Amt
Derived
The current year period 12 credit amount
MLA-CYPAMT12
Current Period 12
Amount
Derived
The current year period 12 amount.
MLA-CYPYTD12
Curr Per 12 Year to
Date Amt
Derived
Current year period year to date period 12.
MLA-CYPAMT13-DR
Current Period 13
Debit Amount
Derived
The current year period 13 debit amount
MLA-CYPAMT13-CR
Current Period 13
Credit Amt
Derived
The current year period 13 credit amount
MLA-CYPAMT13
Current Period 13
Amount
Derived
The current year period 13 amount.
MLA-CYPYTD13
Curr Per 13 Year to
Date Amt
Derived
Current year period year to date period 13.
MLA-BLANK
Element: Blank
Derived
This derived field is always blank. It is used in the Drill Around feature for column headings. .~$3 MLAMOUNTS CPAMT-THOU
MLA-CPAMT-THOU
Current Period
Thousands
Derived
The current period base amount divided by 1,000.
MLA-CYDAMT-THOU
Current Year to
Date Thousands
Derived
The current period amount divided by 1000.
MLA-PARENT-VAR-LEV
Parent Variable
Level
Alpha 30
The variable level address of the parent accounting unit.
GL120 ML146
ML167 ML190
ML199 ML325
ML327 ML330
ML40.1 ML40.2
ML40.3 ML40.7
ML40.8 ML44.1
ML45.1


MLAMOUNTS FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
MLASET1 LEDGER
COMPANY
FISCAL-YEAR
ACCT-UNIT
ACCOUNT
SUB-ACCOUNT
GL120 ML110
ML146 ML167
ML190 ML195
ML199 ML290
ML291 ML300
ML320 ML325
ML327 ML330
ML40.1 ML40.2
ML40.3 ML40.7
ML40.8 ML44.1
ML45.1 ML90.1
ML90.4
MLASET10 PARENT-VAR-LEV
LEDGER
COMPANY
ACCOUNT
SUB-ACCOUNT
FISCAL-YEAR
ACCT-UNIT
MLASET2 FISCAL-YEAR
LEDGER
COMPANY
VAR-LEVELS
ACCOUNT
SUB-ACCOUNT
ACCT-UNIT
KeyChange
RW80.1 ML195
ML196 ML290
ML291 ML325
MLRV.1
MLASET3 LEDGER
COMPANY
ACCT-UNIT
ACCOUNT
SUB-ACCOUNT
FISCAL-YEAR
GL120 GL20.2
MLASET4 FISCAL-YEAR
LEDGER
COMPANY
ACCOUNT
SUB-ACCOUNT
VAR-LEVELS
ACCT-UNIT
KeyChange
ML199 ML290
ML320 ML325
MLRV.1
MLASET5 FISCAL-YEAR
VAR-LEVELS
ACCOUNT
SUB-ACCOUNT
LEDGER
COMPANY
ACCT-UNIT
KeyChange
MLRV.1
MLASET6 FISCAL-YEAR
ACCOUNT
SUB-ACCOUNT
VAR-LEVELS
LEDGER
COMPANY
ACCT-UNIT
KeyChange
MLRV.1
MLASET7 LEDGER
COMPANY
FISCAL-YEAR
ACCOUNT
SUB-ACCOUNT
ACCT-UNIT
ML325 ML330


MLAMOUNTS FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Chart Detail GLCHARTDTL Required
MLA-CHART-NAME->GDT-CHART-NAME
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
NAME
RELATED 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


File created: Thu Jun 09 11:21:10 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.