|
|
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: Year The fiscal year of the currency amount
record.
MCA-AMT-TYPE Numeric 1
Element: Amt 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: Var Levels The 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: Sub Acct 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: Acct Unit The 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
Element: Acct Nd This field defines the number of
positions for nonbase currency amounts.
MCA-BASE-ND Numeric 1
Element: Base Nd This field defines the number of
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: Maint Date This 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: Cpamt Dr This is the nonbase currency debit
amount for the current period.
MCA-CPAMT-CR Derived
Element: Cpamt Cr This is the nonbase currency credit
amount for the current period.
MCA-CPAMT Derived
Element: Cpamt This is the net nonbase currency 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
Element: Cypamt1 Dr This is the period 1 base debit amount.
MCA-CYPAMT1-CR Derived
Element: Cypamt1 Cr This is the period 1 base credit amount.
MCA-CYPYTD1 Derived
Element: Cypamt1 Current year period year to date
period 1.
MCA-CYPAMT2-DR Derived
Element: Cypamt2 Dr This is the period 2 base debit amount.
MCA-CYPAMT2-CR Derived
Element: Cypamt2 Cr This is the period 2 base credit amount.
MCA-CYPYTD2 Derived
Element: Cypamt2 Current year period year to date
period 2.
MCA-CYPAMT3-DR Derived
Element: Cypamt3 Dr This is the period 3 base debit amount.
MCA-CYPAMT3-CR Derived
Element: Cypamt3 Cr This is the period 3 base credit amount.
MCA-CYPYTD3 Derived
Element: Cypamt3 Current year period year to date
period 3.
MCA-CYPAMT4-DR Derived
Element: Cypamt4 Dr This is the period 4 base debit amount.
MCA-CYPAMT4-CR Derived
Element: Cypamt4 Cr This is the period 4 base credit amount.
MCA-CYPYTD4 Derived
Element: Cypamt4 Current year period year to date
period 4.
MCA-CYPAMT5-DR Derived
Element: Cypamt5 Dr This is the period 5 base debit amount.
MCA-CYPAMT5-CR Derived
Element: Cypamt5 Cr This is the period 5 base credit amount.
MCA-CYPYTD5 Derived
Element: Cypamt5 Current year period year to date
period 5.
MCA-CYPAMT6-DR Derived
Element: Cypamt6 Dr This is the period 6 base debit amount.
MCA-CYPAMT6-CR Derived
Element: Cypamt6 Cr This is the period 6 base credit amount.
MCA-CYPYTD6 Derived
Element: Cypamt6 Current year period year to date
period 6.
MCA-CYPAMT7-DR Derived
Element: Cypamt7 Dr This is the period 7 base debit amount.
MCA-CYPAMT7-CR Derived
Element: Cypamt7 Cr This is the period 7 base credit amount.
MCA-CYPYTD7 Derived
Element: Cypamt7 Current year period year to date
period 7.
MCA-CYPAMT8-DR Derived
Element: Cypamt8 Dr This is the period 8 base debit amount.
MCA-CYPAMT8-CR Derived
Element: Cypamt8 Cr This is the period 8 base credit amount.
MCA-CYPYTD8 Derived
Element: Cypamt8 Current year period year to date
period 8.
MCA-CYPAMT9-DR Derived
Element: Cypamt9 Dr This is the period 9 base debit amount.
MCA-CYPAMT9-CR Derived
Element: Cypamt9 Cr This is the period 9 base credit amount.
MCA-CYPYTD9 Derived
Element: Cypamt9 Current year period year to date
period 9.
MCA-CYPAMT10-DR Derived
Element: Cypamt10 Dr This is the period 10 base debit amount.
MCA-CYPAMT10-CR Derived
Element: Cypamt10 Cr This is the period 10 base credit
amount.
MCA-CYPYTD10 Derived
Element: Cypamt10 Current year period year to date
period 10.
MCA-CYPAMT11-DR Derived
Element: Cypamt11 Dr This is the period 11 base debit amount.
MCA-CYPAMT11-CR Derived
Element: Cypamt11 Cr This is the period 11 base credit
amount.
MCA-CYPYTD11 Derived
Element: Cypamt11 Current year period year to date
period 11.
MCA-CYPAMT12-DR Derived
Element: Cypamt12 Dr This is the period 12 base debit amount.
MCA-CYPAMT12-CR Derived
Element: Cypamt12 Cr This is the period 12 base credit
amount.
MCA-CYPYTD12 Derived
Element: Cypamt12 Current year period year to date
period 12.
MCA-CYPAMT13-DR Derived
Element: Cypamt13 Dr This is the period 13 base debit amount.
MCA-CYPAMT13-CR Derived
Element: Cypamt13 Cr This is the period 13 base credit
amount.
MCA-CYPYTD13 Derived
Element: Cypamt13 Current year period year to date
period 13.
MCA-CPCUR-DR Derived
Element: Cpcur Dr This is the current period nonbase
debit amount.
MCA-CPCUR-CR Derived
Element: Cpcur Cr This is the current period nonbase
credit amount.
MCA-CPCUR Derived
Element: Cpcur This is the current period nonbase net
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
Element: Cypcur1 Dr This is the period 1 nonbase debit
amount.
MCA-CYPCUR1-CR Derived
Element: Cypcur1 Cr This is the period 1 nonbase credit
amount.
MCA-CURYTD1 Derived
Element: Cypcur1 Currency current year period year to
date period 1.
MCA-CYPCUR2-DR Derived
Element: Cypcur2 Dr This is the period 2 nonbase debit
amount.
MCA-CYPCUR2-CR Derived
Element: Cypcur2 Cr This is the period 2 nonbase credit
amount.
MCA-CURYTD2 Derived
Element: Cypcur2 Currency current year period year to
date period 2.
MCA-CYPCUR3-DR Derived
Element: Cypcur3 Dr This is the period 3 nonbase debit
amount.
MCA-CYPCUR3-CR Derived
Element: Cypcur3 Cr This is the period 3 nonbase credit
amount.
MCA-CURYTD3 Derived
Element: Cypcur3 Currency current year period year to
date period 3.
MCA-CYPCUR4-DR Derived
Element: Cypcur4 Dr This is the period 4 nonbase debit
amount.
MCA-CYPCUR4-CR Derived
Element: Cypcur4 Cr This is the period 4 nonbase credit
amount.
MCA-CURYTD4 Derived
Element: Cypcur4 Currency current year period year to
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
Element: Cypcur10 Dr This is the period 10 nonbase debit
amount.
MCA-CYPCUR10-CR Derived
Element: Cypcur10 Cr This is the period 10 nonbase credit
amount.
MCA-CURYTD10 Derived
Element: Cypcur10 Currency current year period year to
date period 10.
MCA-CYPCUR11-DR Derived
Element: Cypcur11 Dr This is the period 11 nonbase debit
amount.
MCA-CYPCUR11-CR Derived
Element: Cypcur11 Cr This is the period 11 nonbase credit
amount.
MCA-CURYTD11 Derived
Element: Cypcur11 Currency current year period year to
date period 11.
MCA-CYPCUR12-DR Derived
Element: Cypcur12 Dr This is the period 12 nonbase debit
amount.
MCA-CYPCUR12-CR Derived
Element: Cypcur12 Cr This is the period 12 nonbase credit
amount.
MCA-CURYTD12 Derived
Element: Cypcur12 Currency current year period year to
date period 12.
MCA-CYPCUR13-DR Derived
Element: Cypcur13 Dr This is the period 13 nonbase debit
amount.
MCA-CYPCUR13-CR Derived
Element: Cypcur13 Cr This is the period 13 nonbase credit
amount.
MCA-CURYTD13 Derived
Element: Cypcur13 Currency current year period year to
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 GL120
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
|
