|
AMCNVASSET FILE
Asset Conversion Number
This file is a cross-reference file, containing the conversion number and the
asset number that the converted asset was assigned. This file lets you convert
asset attributes and transactions at times other than the initial asset
conversion.
REFERENCED BY
AM93.1 AM94.1
UPDATED BY
AM170 AM300 AM500 AM40.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
CVA-CONVERSION-NBR Alpha 22 AM500
Element: Conversion NumRequired key. This number associates the
attribute or transaction with the asset.
CVA-ASSET Numeric 10 AM500
Element: Asset This is the Lawson-assigned asset
number, to be used for attribute
conversion at a later date. The asset
number contains up to ten numeric
characters that uniquely identify an
asset. Assets are automatically numbered
system-wide.
AMCNVASSET FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
CVASET1 CONVERSION-NBR AM300 AM500
AM93.1 AM94.1
CVASET2 ASSET AM170 AM40.1
CONVERSION-NBR
AMCNVASSET FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Amassetcnv AMASSETCNV Not Required
CVA-CONVERSION-NBR -> ACN-CONVERSION-NBR
AMCNVASSET FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Amastbkcnv AMASTBKCNV
CVA-CONVERSION-NBR -> ABC-CONVERSION-NBR
ABC-BOOK
Amastitcnv AMASTITCNV
CVA-CONVERSION-NBR -> ITC-CONVERSION-NBR
ITC-SEQ-NUMBER
Amastmxcnv AMASTMXCNV
CVA-CONVERSION-NBR -> MCV-CONVERSION-NBR
MCV-MATRIX-CAT
Amasttrcnv AMASTTRCNV
CVA-CONVERSION-NBR -> TNC-CONVERSION-NBR
TNC-SEQ-NUMBER
|