AMASTMXCNV

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
Element: Conversion Number
Alpha 22
Required 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.
AM94.1
MCV-MATRIX-CAT
Element: Asset Attribute
Alpha 12
This 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.
AM94.1
MCV-MX-VALUE
Element: Attribute Value
Alpha 32
This is the value to assign to the asset attribute. This field is required if you are adding or deleting an attribute value.
AM94.1


AMASTMXCNV FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
MCVSET1 CONVERSION-NBR
MATRIX-CAT
AM500 AM94.1


AMASTMXCNV FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED 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
NAME
RELATED 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


File created: Wed Jun 08 20:47:07 2016

Home
Contact Us



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