AMASTMXCNV FILE
Asset Attribute Conversion
This file stores asset attribute conversion information. It must be loaded in
a way similar to existing asset conversion files (such as AMASSETCNV).
UPDATED BY
AM500 AM94.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
MCV-CONVERSION-NBR Alpha 22 AM94.1
Element: Conversion NumRequired key. This number associates
the attribute with the asset. This
number can be the Lawson-assigned asset
number for use when doing just attribute
conversion.
MCV-MATRIX-CAT Alpha 12 AM94.1
Element: Asset AttributThis is the name of the asset attribute
to which you are assigning values. This
field is required if you are adding or
deleting an asset attribute.
MCV-MX-VALUE Alpha 32 AM94.1
Element: Attribute ValuThis is the value to assign to the
asset attribute. This field is required
if you are adding or deleting an
attribute value.
AMASTMXCNV FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
MCVSET1 CONVERSION-NBR AM500 AM94.1
MATRIX-CAT
AMASTMXCNV FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Amassetcnv AMASSETCNV Not Required
MCV-CONVERSION-NBR -> ACN-CONVERSION-NBR
Amcnvasset AMCNVASSET Not Required
MCV-CONVERSION-NBR -> CVA-CONVERSION-NBR
AMASTMXCNV FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Amastbkcnv AMASTBKCNV
MCV-CONVERSION-NBR -> ABC-CONVERSION-NBR
ABC-BOOK
Amastitcnv AMASTITCNV
MCV-CONVERSION-NBR -> ITC-CONVERSION-NBR
ITC-SEQ-NUMBER
Amasttrcnv AMASTTRCNV
MCV-CONVERSION-NBR -> TNC-CONVERSION-NBR
TNC-SEQ-NUMBER
|
