|
|
MLCUAMOUNT FILE
ML Ledger Currency Amount
The Multi Book Ledger Currency Amount file contains a partial chart of
accounts for non-base currency transactions. All Lawson subsystems verify the
existence of non-base currency accounts against this file.
This file also maintains monthly activity and beginning balances for all
non-base currency, posting level accounting units. Ledger Journal Posting
(ML190) updates this file, and Currency Revaluation (ML191) revalues the
balance sheet accounts. Non-base currency, balance sheet accounts used in
revaluation are designated as type 2 amounts. Type 1 amounts are non-base
currency account amounts and are not revalued.
REFERENCED BY
RW80.1 MLRV.1
UPDATED BY
GL120 GL310
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
MCA-LEDGER Alpha 15
Element: Ledger The ledger associated with the currency
amount record.
MCA-COMPANY Numeric 4
Element: Company The company associated to the ledger.
MCA-FISCAL-YEAR Numeric 4
Element: Last Closed YeThe fiscal year of the currency amount
record.
MCA-AMT-TYPE Numeric 1
Element: Amount Type The amount type can be either account
currency, transaction currency, report
currency one, or report currency two.
1 = Account Currency Balance
2 = Transaction Balances
3 = Currency One Balance
4 = Currency Two Balance
MCA-VAR-LEVELS Alpha 30 GL120
Element: Variable LevelThe variable level address of the
posting accounting unit associated with
this record.
MCA-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 is stored.
MCA-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 is stored.
MCA-ACCT-UNIT Alpha 15
Element: Accounting UniThe accounting unit is a shorthand
notation representing the variable level
number. When used in the General Ledger
Account Master file, the accounting unit
must be defined in the General Ledger
Names file as a posting accounting unit.
MCA-CURRENCY-CODE Alpha 5
Element: Currency Code This field contains the company
currency code corresponding to the
amount type.
MCA-CHART-NAME Alpha 12
Element: Chart Name This is the chart of accounts assigned
to the General Ledger company.
MCA-CURR-ND Numeric 1
Account Currency This field defines the number of
Code positions for nonbase currency amounts.
MCA-BASE-ND Numeric 1
Base Number Of This field defines the number of
Decimals positions for base currency amounts.
MCA-DB-BEG-BAL Signed 18.2
Element: Intl Amt This is the beginning debit balance for
nonbase amounts.
MCA-CR-BEG-BAL Signed 18.2
Element: Intl Amt This is the beginning credit balance
for nonbase amounts.
MCA-BASE-DB-BBAL Signed 18.2
Element: Intl Amt This is the beginning debit balance for
base amounts.
MCA-BASE-CR-BBAL Signed 18.2
Element: Intl Amt This is the beginning credit balance
for nonbase amounts.
MCA-RPT1-DB-BBAL Signed 18.2 GL310
Element: Intl Amt This is the beginning debit balance for
report 1 currency amounts.
MCA-RPT1-CR-BBAL Signed 18.2 GL310
Element: Intl Amt This is the beginning credit balance
for report 1 currency amounts.
MCA-RPT2-DB-BBAL Signed 18.2 GL310
Element: Intl Amt This is the beginning debit balance for
report 2 currency amounts.
MCA-RPT2-CR-BBAL Signed 18.2 GL310
Element: Intl Amt This is the beginning credit balance
for report 2 currency amounts.
MCA-DB-AMOUNT Signed 18.2 Occurs 13 Times
Element: Intl Amt This is the total debit nonbase
currency amount.
MCA-CR-AMOUNT Signed 18.2 Occurs 13 Times
Element: Intl Amt This is the total credit nonbase
currency amount.
MCA-BASE-DB-AMT Signed 18.2 Occurs 13 Times
Element: Intl Amt This is the total debit base currency
amount.
MCA-BASE-CR-AMT Signed 18.2 Occurs 13 Times
Element: Intl Amt This is the total credit base currency
amount.
MCA-RPT1-DB-AMT Signed 18.2 Occurs 13 Times GL310
Element: Intl Amt This is the total debit report 1
currency amount.
MCA-RPT1-CR-AMT Signed 18.2 Occurs 13 Times GL310
Element: Intl Amt This is the total credit report 1
currency amount.
MCA-RPT2-DB-AMT Signed 18.2 Occurs 13 Times GL310
Element: Intl Amt This is the total debit report 2
currency amount.
MCA-RPT2-CR-AMT Signed 18.2 Occurs 13 Times GL310
Element: Intl Amt This is the total credit report 2
currency amount.
MCA-MAINT-DATE Numeric 8 (yyyymmdd)
Element: Maintenance DaThis is the date the records were last
updated.
MCA-MAINT-TIME Numeric 6 (hhmmss)
Element: Sys Time This is the time the records were last
updated.
MCA-CPAMT-DR Derived
Element: Current PeriodThis is the nonbase currency debit
amount for the current period.
MCA-CPAMT-CR Derived
Current Period This is the nonbase currency credit
Credit amount for the current period.
MCA-CPAMT Derived
Current Period This is the net nonbase currency amount
Amount for the current period.
MCA-CUR-PD-SUM-A-D Derived
Element: Cur Pd Sum A DThis is the summary debit amount for
the current period.
MCA-CUR-PD-SUM-A-C Derived
Element: Cur Pd Sum A CThis is the summary credit amount for
the current period.
MCA-CYBAMT Derived
Element: Cybamt This is the beginning base amount for
the current year.
MCA-CYDAMT Derived
Element: Cydamt This is the year-to-date base amount.
MCA-CYPAMT1-DR Derived
Period 1 Base Debit This is the period 1 base debit amount.
Amount
MCA-CYPAMT1-CR Derived
Period 1 Base This is the period 1 base credit amount.
Credit Amount
MCA-CYPYTD1 Derived
Element: Period 1 Base Current year period year to date
period 1.
MCA-CYPAMT2-DR Derived
Period 2 Base Debit This is the period 2 base debit amount.
Amount
MCA-CYPAMT2-CR Derived
Period 2 Base This is the period 2 base credit amount.
Credit Amount
MCA-CYPYTD2 Derived
Element: Period 2 Base Current year period year to date
period 2.
MCA-CYPAMT3-DR Derived
Period 3 Base Debit This is the period 3 base debit amount.
Amount
MCA-CYPAMT3-CR Derived
Period 3 Base This is the period 3 base credit amount.
Credit Amount
MCA-CYPYTD3 Derived
Element: Period 3 Base Current year period year to date
period 3.
MCA-CYPAMT4-DR Derived
Period 4 Base Debit This is the period 4 base debit amount.
Amount
MCA-CYPAMT4-CR Derived
Period 4 Base This is the period 4 base credit amount.
Credit Amount
MCA-CYPYTD4 Derived
Element: Period 4 Base Current year period year to date
period 4.
MCA-CYPAMT5-DR Derived
Period 5 Base Debit This is the period 5 base debit amount.
Amount
MCA-CYPAMT5-CR Derived
Peirod 5 Base This is the period 5 base credit amount.
Credit Amount
MCA-CYPYTD5 Derived
Element: Peirod 5 Base Current year period year to date
period 5.
MCA-CYPAMT6-DR Derived
Period 6 Base Debit This is the period 6 base debit amount.
Amount
MCA-CYPAMT6-CR Derived
Period 6 Base This is the period 6 base credit amount.
Credit Amount
MCA-CYPYTD6 Derived
Element: Period 6 Base Current year period year to date
period 6.
MCA-CYPAMT7-DR Derived
Period 7 Base Debit This is the period 7 base debit amount.
Amount
MCA-CYPAMT7-CR Derived
Period 7 Base This is the period 7 base credit amount.
Credit Amount
MCA-CYPYTD7 Derived
Element: Period 7 Base Current year period year to date
period 7.
MCA-CYPAMT8-DR Derived
Period 8 Base This is the period 8 base debit amount.
Detail Amount
MCA-CYPAMT8-CR Derived
Period 8 Base This is the period 8 base credit amount.
Credit Amount
MCA-CYPYTD8 Derived
Element: Period 8 Base Current year period year to date
period 8.
MCA-CYPAMT9-DR Derived
Period 9 Base Debit This is the period 9 base debit amount.
Amount
MCA-CYPAMT9-CR Derived
Period 9 Base This is the period 9 base credit amount.
Credit Amount
MCA-CYPYTD9 Derived
Element: Period 9 Base Current year period year to date
period 9.
MCA-CYPAMT10-DR Derived
Period 10 Base This is the period 10 base debit amount.
Debit Amount
MCA-CYPAMT10-CR Derived
Period 10 Base This is the period 10 base credit
Credit Amount amount.
MCA-CYPYTD10 Derived
Period 10 Baes Current year period year to date
Amount period 10.
MCA-CYPAMT11-DR Derived
Period 11 Base This is the period 11 base debit amount.
Debit Amount
MCA-CYPAMT11-CR Derived
Period 11 Base This is the period 11 base credit
Credit Amount amount.
MCA-CYPYTD11 Derived
Period 11 Base Current year period year to date
Amount period 11.
MCA-CYPAMT12-DR Derived
Period 12 Base This is the period 12 base debit amount.
Debit Amount
MCA-CYPAMT12-CR Derived
Period 12 Base This is the period 12 base credit
Credit Amount amount.
MCA-CYPYTD12 Derived
Period 12 Base Current year period year to date
Amount period 12.
MCA-CYPAMT13-DR Derived
Period 13 Base This is the period 13 base debit amount.
Debit Amount
MCA-CYPAMT13-CR Derived
Period 13 Base This is the period 13 base credit
Credit Amount amount.
MCA-CYPYTD13 Derived
Period 13 Base Current year period year to date
Amount period 13.
MCA-CPCUR-DR Derived
Current Period This is the current period nonbase
Currency Debit debit amount.
MCA-CPCUR-CR Derived
Current Period This is the current period nonbase
Currency Credit credit amount.
MCA-CPCUR Derived
Current Period This is the current period nonbase net
Currency amount.
MCA-CUR-PD-SUM-C-D Derived
Element: Cur Pd Sum C DThis is the current period nonbase
summary debit amount.
MCA-CUR-PD-SUM-C-C Derived
Element: Cur Pd Sum C CThis is the current period nonbase
summary credit amount.
MCA-CYBCUR Derived
Element: Cybcur This the nonbase currency current year
beginning balance.
MCA-CYDCUR Derived
Element: Cydcur This the nonbase currency current
year-to-date amount.
MCA-CYPCUR1-DR Derived
Per 1 Currency This is the period 1 nonbase debit
Debit Amount amount.
MCA-CYPCUR1-CR Derived
Per 1 Currency This is the period 1 nonbase credit
Credit Amount amount.
MCA-CURYTD1 Derived
Per 1 Currency Currency current year period year to
Amount date period 1.
MCA-CYPCUR2-DR Derived
Per 2 Currency This is the period 2 nonbase debit
Debit Amount amount.
MCA-CYPCUR2-CR Derived
Per 2 Currency This is the period 2 nonbase credit
Credit Amount amount.
MCA-CURYTD2 Derived
Per 2 Currency Currency current year period year to
Amount date period 2.
MCA-CYPCUR3-DR Derived
Per 3 Currency This is the period 3 nonbase debit
Debit Amount amount.
MCA-CYPCUR3-CR Derived
Per 3 Currency This is the period 3 nonbase credit
Credit Amount amount.
MCA-CURYTD3 Derived
Per 3 Currency Currency current year period year to
Amount date period 3.
MCA-CYPCUR4-DR Derived
Element: Cypcur4 Dr This is the period 4 nonbase debit
amount.
MCA-CYPCUR4-CR Derived
Per 4 Currency This is the period 4 nonbase credit
Credit Amount amount.
MCA-CURYTD4 Derived
Per 4 Currency Currency current year period year to
Amount date period 4.
MCA-CYPCUR5-DR Derived
Element: Cypcur5 Dr This is the period 5 nonbase debit
amount.
MCA-CYPCUR5-CR Derived
Element: Cypcur5 Cr This is the period 5 nonbase credit
amount.
MCA-CURYTD5 Derived
Element: Cypcur5 Currency current year period year to
date period 5.
MCA-CYPCUR6-DR Derived
Element: Cypcur6 Dr This is the period 6 nonbase debit
amount.
MCA-CYPCUR6-CR Derived
Element: Cypcur6 Cr This is the period 6 nonbase credit
amount.
MCA-CURYTD6 Derived
Element: Cypcur6 Currency current year period year to
date period 6.
MCA-CYPCUR7-DR Derived
Element: Cypcur7 Dr This is the period 6 nonbase debit
amount.
MCA-CYPCUR7-CR Derived
Element: Cypcur7 Cr This is the period 7 nonbase credit
amount.
MCA-CURYTD7 Derived
Element: Cypcur7 Currency current year period year to
date period 7.
MCA-CYPCUR8-DR Derived
Element: Cypcur8 Dr This is the period 8 nonbase debit
amount.
MCA-CYPCUR8-CR Derived
Element: Cypcur8 Cr This is the period 8 nonbase credit
amount.
MCA-CURYTD8 Derived
Element: Cypcur8 Currency current year period year to
date period 8.
MCA-CYPCUR9-DR Derived
Element: Cypcur9 Dr This is the period 9 nonbase debit
amount.
MCA-CYPCUR9-CR Derived
Element: Cypcur9 Cr This is the period 9 nonbase credit
amount.
MCA-CURYTD9 Derived
Element: Cypcur9 Currency current year period year to
date period 9.
MCA-CYPCUR10-DR Derived
Per 10 Currency This is the period 10 nonbase debit
Debit Amount amount.
MCA-CYPCUR10-CR Derived
Per 10 Currency This is the period 10 nonbase credit
Credit Amount amount.
MCA-CURYTD10 Derived
Per 10 Currency Currency current year period year to
Amount date period 10.
MCA-CYPCUR11-DR Derived
Per 11 Currency This is the period 11 nonbase debit
Debit Amount amount.
MCA-CYPCUR11-CR Derived
Per 11 Currency This is the period 11 nonbase credit
Credit Amount amount.
MCA-CURYTD11 Derived
Per 11 Currency Currency current year period year to
Amount date period 11.
MCA-CYPCUR12-DR Derived
Per 12 Currency This is the period 12 nonbase debit
Debit Amount amount.
MCA-CYPCUR12-CR Derived
Per 12 Currency This is the period 12 nonbase credit
Credit Amount amount.
MCA-CURYTD12 Derived
Per 12 Currency Currency current year period year to
Amount date period 12.
MCA-CYPCUR13-DR Derived
Per 13 Currency This is the period 13 nonbase debit
Debit Amount amount.
MCA-CYPCUR13-CR Derived
Per 13 Currency This is the period 13 nonbase credit
Credit Amount amount.
MCA-CURYTD13 Derived
Per 13 Currency Currency current year period year to
Amount date period 13.
MCA-BLANK Derived
Element: Blank This derived field is always blank. It
is used in the Drill Around feature for
column headings.
MCA-PARENT-VAR-LEV Alpha 30 GL120
Element: Parent Var LevThe variable level address of the parent
accounting unit.
MLCUAMOUNT FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
MCASET1 FISCAL-YEAR
LEDGER
COMPANY
AMT-TYPE
VAR-LEVELS
ACCOUNT
SUB-ACCOUNT
ACCT-UNIT
CURRENCY-CODE
MCASET2 FISCAL-YEAR
LEDGER
COMPANY
AMT-TYPE
CURRENCY-CODE
ACCOUNT
SUB-ACCOUNT
VAR-LEVELS
ACCT-UNIT
MCASET3 AMT-TYPE RW80.1 MLRV.1
FISCAL-YEAR
LEDGER
COMPANY
VAR-LEVELS
ACCOUNT
SUB-ACCOUNT
ACCT-UNIT
CURRENCY-CODE
MCASET4 AMT-TYPE MLRV.1
FISCAL-YEAR
LEDGER
COMPANY
ACCOUNT
SUB-ACCOUNT
VAR-LEVELS
ACCT-UNIT
CURRENCY-CODE
MCASET5 LEDGER GL120 GL310
COMPANY
ACCT-UNIT
ACCOUNT
SUB-ACCOUNT
AMT-TYPE
CURRENCY-CODE
FISCAL-YEAR
VAR-LEVELS
MCASET6 AMT-TYPE MLRV.1
FISCAL-YEAR
VAR-LEVELS
ACCOUNT
SUB-ACCOUNT
LEDGER
COMPANY
ACCT-UNIT
CURRENCY-CODE
MCASET7 AMT-TYPE MLRV.1
FISCAL-YEAR
ACCOUNT
SUB-ACCOUNT
VAR-LEVELS
LEDGER
COMPANY
ACCT-UNIT
CURRENCY-CODE
MCASET9 PARENT-VAR-LEV
AMT-TYPE
LEDGER
COMPANY
ACCOUNT
SUB-ACCOUNT
FISCAL-YEAR
ACCT-UNIT
VAR-LEVELS
CURRENCY-CODE
MLCUAMOUNT FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Chart Detail GLCHARTDTL Required
GLS-CHART-NAME -> GDT-CHART-NAME (GDTSET2)
MCA-ACCOUNT -> GDT-ACCOUNT
MCA-SUB-ACCOUNT -> GDT-SUB-ACCOUNT
Company GLSYSTEM Not Required
MCA-COMPANY -> GLS-COMPANY
Cucodes CUCODES Required
MCA-CURRENCY-CODE -> CUC-CURRENCY-CODE
Glnames GLNAMES Required
MCA-COMPANY -> GLN-COMPANY
MCA-ACCT-UNIT -> GLN-ACCT-UNIT
Mla Sibling MLAMOUNTS Required
MCA-PARENT-VAR-LEV -> MLA-PARENT-VAR-LEV
MCA-LEDGER -> MLA-LEDGER
MCA-COMPANY -> MLA-COMPANY
MCA-ACCOUNT -> MLA-ACCOUNT
MCA-SUB-ACCOUNT -> MLA-SUB-ACCOUNT
MCA-FISCAL-YEAR -> MLA-FISCAL-YEAR
MCA-ACCT-UNIT -> MLA-ACCT-UNIT
Mlcoledger MLCOLEDGER Required
MCA-LEDGER -> MLE-LEDGER
MCA-COMPANY -> MLE-COMPANY
MLCUAMOUNT FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Consol Parent1 MLCONSOL
MCA-PARENT-VAR-LEV -> MCN-VAR-LEVELS
"Y" -> MCN-TRANS-TYPE
MCA-LEDGER -> MCN-LEDGER
MCA-COMPANY -> MCN-COMPANY
MCA-ACCOUNT -> MCN-ACCOUNT
MCA-SUB-ACCOUNT -> MCN-SUB-ACCOUNT
MCA-FISCAL-YEAR -> MCN-FISCAL-YEAR
MCN-LEVEL-DEPTH
MCN-CURRENCY-CODE
Consol Parent2 MLCONSOL
MCA-PARENT-VAR-LEV -> MCN-VAR-LEVELS
"Z" -> MCN-TRANS-TYPE
MCA-LEDGER -> MCN-LEDGER
MCA-COMPANY -> MCN-COMPANY
MCA-ACCOUNT -> MCN-ACCOUNT
MCA-SUB-ACCOUNT -> MCN-SUB-ACCOUNT
MCA-FISCAL-YEAR -> MCN-FISCAL-YEAR
MCN-LEVEL-DEPTH
MCN-CURRENCY-CODE
Curr 1 MLCUAMOUNT
MCA-PARENT-VAR-LEV -> MCA-PARENT-VAR-LEV
3 -> MCA-AMT-TYPE
MCA-LEDGER -> MCA-LEDGER
MCA-COMPANY -> MCA-COMPANY
MCA-ACCOUNT -> MCA-ACCOUNT
MCA-SUB-ACCOUNT -> MCA-SUB-ACCOUNT
MCA-FISCAL-YEAR -> MCA-FISCAL-YEAR
MCA-ACCT-UNIT -> MCA-ACCT-UNIT
MCA-VAR-LEVELS -> MCA-VAR-LEVELS
MCA-CURRENCY-CODE
Curr 2 MLCUAMOUNT
MCA-PARENT-VAR-LEV -> MCA-PARENT-VAR-LEV
4 -> MCA-AMT-TYPE
MCA-LEDGER -> MCA-LEDGER
MCA-COMPANY -> MCA-COMPANY
MCA-ACCOUNT -> MCA-ACCOUNT
MCA-SUB-ACCOUNT -> MCA-SUB-ACCOUNT
MCA-FISCAL-YEAR -> MCA-FISCAL-YEAR
MCA-ACCT-UNIT -> MCA-ACCT-UNIT
MCA-VAR-LEVELS -> MCA-VAR-LEVELS
MCA-CURRENCY-CODE
Mltrans 1 Prd MLTRANS
MCA-LEDGER -> MLT-LEDGER
MCA-COMPANY -> MLT-TO-COMPANY
MCA-FISCAL-YEAR -> MLT-FISCAL-YEAR
MLE-ACCT-PERIOD -> MLT-ACCT-PERIOD
MCA-ACCT-UNIT -> MLT-ACCT-UNIT
MCA-ACCOUNT -> MLT-ACCOUNT
MCA-SUB-ACCOUNT -> MLT-SUB-ACCOUNT
MLT-OBJ-ID
Mltrans 1 Year MLTRANS
MCA-LEDGER -> MLT-LEDGER
MCA-COMPANY -> MLT-TO-COMPANY
MCA-ACCOUNT -> MLT-ACCOUNT
MCA-SUB-ACCOUNT -> MLT-SUB-ACCOUNT
MCA-ACCT-UNIT -> MLT-ACCT-UNIT
MCA-FISCAL-YEAR -> MLT-FISCAL-YEAR
MLT-ACCT-PERIOD
MLT-OBJ-ID
|
