|
|
MLCUAMOUNT FILE
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 being posted to.
MCA-COMPANY Numeric 4
Element: Company This is the company for which
transactions are posted to the ledger.
It must a valid company for the ledger
with a ledger calendar defined.
MCA-FISCAL-YEAR Numeric 4
Element: Last Closed YeThis is the current fiscal year for the
ledger company. This field is updated
by Ledger Period Closing (ML199).
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.
MCA-VAR-LEVELS Alpha 30 GL120
Element: New Levels A level that represents the location of
an accounting unit in an organization's
level structure.
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: Name User 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
Account Currency This field defines the number of
Code positions for base currency amounts.
MCA-DB-BEG-BAL Currency 15.2
Element: Amount This is the beginning debit balance for
nonbase amounts.
MCA-CR-BEG-BAL Currency 15.2
Element: Amount This is the beginning credit balance
for nonbase amounts.
MCA-BASE-DB-BBAL Currency 15.2
Element: Amount This is the beginning debit balance for
base amounts.
MCA-BASE-CR-BBAL Currency 15.2
Element: Amount This is the beginning credit balance
for nonbase amounts.
MCA-RPT1-DB-BBAL Currency 15.2 GL310
Element: Rpt1 Db Bbal This is the beginning debit balance for
report 1 currency amounts.
MCA-RPT1-CR-BBAL Currency 15.2 GL310
Element: Rpt1 Cr Bbal This is the beginning credit balance
for report 1 currency amounts.
MCA-RPT2-DB-BBAL Currency 15.2 GL310
Element: Rpt2 Db Bbal This is the beginning debit balance for
report 2 currency amounts.
MCA-RPT2-CR-BBAL Currency 15.2 GL310
Element: Rpt2 Cr Bbal This is the beginning credit balance
for report 2 currency amounts.
MCA-DB-AMOUNT Currency 15.2 Occurs 13 Times
Element: Amount This is the total debit nonbase
currency amount.
MCA-CR-AMOUNT Currency 15.2 Occurs 13 Times
Element: Amount This is the total credit nonbase
currency amount.
MCA-BASE-DB-AMT Currency 15.2 Occurs 13 Times
Element: Amount This is the total debit base currency
amount.
MCA-BASE-CR-AMT Currency 15.2 Occurs 13 Times
Element: Amount This is the total credit base currency
amount.
MCA-RPT1-DB-AMT Currency 15.2 Occurs 13 Times GL310
Element: Rpt1 Db Amt This is the total debit report 1
currency amount.
MCA-RPT1-CR-AMT Currency 15.2 Occurs 13 Times GL310
Element: Rpt1 Cr Amt This is the total credit report 1
currency amount.
MCA-RPT2-DB-AMT Currency 15.2 Occurs 13 Times GL310
Element: Rpt2 Db Amt This is the total debit report 2
currency amount.
MCA-RPT2-CR-AMT Currency 15.2 Occurs 13 Times GL310
Element: Rpt2 Cr Amt This is the total credit report 2
currency amount.
MCA-MAINT-DATE Numeric 8 (yyyymmdd)
Element: 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: 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-CYPAMT1 Derived
Element: Period 1 Base This is the period 1 net base amount.
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-CYPAMT2 Derived
Element: Period 2 Base This is the period 2 net base amount.
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-CYPAMT3 Derived
Element: Period 3 Base This is the period 3 net base amount.
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-CYPAMT4 Derived
Element: Period 4 Base This is the period 4 net base amount.
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-CYPAMT5 Derived
Element: Peirod 5 Base This is the period 5 net base amount.
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-CYPAMT6 Derived
Element: Period 6 Base This is the period 6 net base amount.
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-CYPAMT7 Derived
Element: Period 7 Base This is the period 7 net base amount.
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-CYPAMT8 Derived
Element: Period 8 Base This is the period 8 net base amount.
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-CYPAMT9 Derived
Element: Period 9 Base This is the period 9 net base amount.
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-CYPAMT10 Derived
Period 10 Baes This is the period 01 net base amount.
Amount
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-CYPAMT11 Derived
Period 11 Base This is the period 11 net base amount.
Amount
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-CYPAMT12 Derived
Period 12 Base This is the period 12 net base amount.
Amount
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-CYPAMT13 Derived
Period 13 Base This is the period 13 net base amount.
Amount
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-CYPCUR1 Derived
Per 1 Currency This is the period 1 nonbase net amount.
Amount
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-CYPCUR2 Derived
Per 2 Currency This is the period 2 nonbase net amount.
Amount
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-CYPCUR3 Derived
Per 3 Currency This is the period 3 nonbase net amount.
Amount
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-CYPCUR4 Derived
Per 4 Currency This is the period 4 nonbase net amount.
Amount
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-CYPCUR5 Derived
Element: Cypcur5 This is the period 5 nonbase net amount.
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-CYPCUR6 Derived
Element: Cypcur6 This is the period 6 nonbase net amount.
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-CYPCUR7 Derived
Element: Cypcur7 This is the period 7 nonbase net amount.
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-CYPCUR8 Derived
Element: Cypcur8 This is the period 8 nonbase net amount.
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-CYPCUR9 Derived
Element: Cypcur9 This is the period 9 nonbase net amount.
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-CYPCUR10 Derived
Per 10 Currency This is the period 10 nonbase net
Amount amount.
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-CYPCUR11 Derived
Per 11 Currency This is the period 11 nonbase net
Amount amount.
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-CYPCUR12 Derived
Per 12 Currency This is the period 12 nonbase net
Amount amount.
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-CYPCUR13 Derived
Per 13 Currency This is the period 13 nonbase net
Amount amount.
MCA-BLANK Derived
Element: Blank This derived field is always blank. It
is used in the Drill Around feature for
column headings.
MCA-CPAMT-THOU Derived
Element: Cpamt Thou This is current period base amount
divided by 1000.
MCA-CYDAMT-THOU Derived
Element: Cydamt Thou This is current year-to-date base
amount divided by 1000.
MCA-CPCUR-THOU Derived
Element: Cpcur Thou This is current period nonbase amount
divided by 1000.
MCA-CYDCUR-THOU Derived
Element: Cydcur Thou This is current year-to-date nonbase
amount divided by 1000.
MCA-PARENT-OBJ-ID Numeric 12
Object
Identification
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
MCASET8 PARENT-OBJ-ID KeyChange
AMT-TYPE
LEDGER
COMPANY
ACCT-UNIT
ACCOUNT
SUB-ACCOUNT
VAR-LEVELS
FISCAL-YEAR
CURRENCY-CODE
MCASET9 AMT-TYPE KeyChange
MAINT-DATE
MAINT-TIME
CURRENCY-CODE
LEDGER
COMPANY
ACCT-UNIT
ACCOUNT
SUB-ACCOUNT
FISCAL-YEAR
VAR-LEVELS
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-OBJ-ID -> MLA-PARENT-OBJ-ID
MCA-LEDGER -> MLA-LEDGER
MCA-COMPANY -> MLA-COMPANY
MCA-ACCT-UNIT -> MLA-ACCT-UNIT
MCA-ACCOUNT -> MLA-ACCOUNT
MCA-SUB-ACCOUNT -> MLA-SUB-ACCOUNT
MCA-FISCAL-YEAR -> MLA-FISCAL-YEAR
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-OBJ-ID -> MCN-OBJ-ID
"Y" -> MCN-TRANS-TYPE
MCA-LEDGER -> MCN-LEDGER
MCA-COMPANY -> MCN-COMPANY
MCN-VAR-LEVELS
MCN-ACCOUNT
MCN-SUB-ACCOUNT
MCN-FISCAL-YEAR
MCN-LEVEL-DEPTH
MCN-CURRENCY-CODE
Consol Parent2 MLCONSOL
MCA-PARENT-OBJ-ID -> MCN-OBJ-ID
"Z" -> MCN-TRANS-TYPE
MCA-LEDGER -> MCN-LEDGER
MCA-COMPANY -> MCN-COMPANY
MCA-LEDGER -> MCN-VAR-LEVELS
MCN-ACCOUNT
MCN-SUB-ACCOUNT
MCN-FISCAL-YEAR
MCN-LEVEL-DEPTH
MCN-CURRENCY-CODE
Curr 1 MLCUAMOUNT
MCA-PARENT-OBJ-ID -> MCA-PARENT-OBJ-ID
3 -> MCA-AMT-TYPE
MCA-LEDGER -> MCA-LEDGER
MCA-COMPANY -> MCA-COMPANY
MCA-ACCT-UNIT -> MCA-ACCT-UNIT
MCA-ACCOUNT -> MCA-ACCOUNT
MCA-SUB-ACCOUNT -> MCA-SUB-ACCOUNT
MCA-VAR-LEVELS -> MCA-VAR-LEVELS
MCA-FISCAL-YEAR -> MCA-FISCAL-YEAR
MCA-CURRENCY-CODE
Curr 2 MLCUAMOUNT
MCA-PARENT-OBJ-ID -> MCA-PARENT-OBJ-ID
4 -> MCA-AMT-TYPE
MCA-LEDGER -> MCA-LEDGER
MCA-COMPANY -> MCA-COMPANY
MCA-ACCT-UNIT -> MCA-ACCT-UNIT
MCA-ACCOUNT -> MCA-ACCOUNT
MCA-SUB-ACCOUNT -> MCA-SUB-ACCOUNT
MCA-VAR-LEVELS -> MCA-VAR-LEVELS
MCA-FISCAL-YEAR -> MCA-FISCAL-YEAR
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
|
