AMCNVASSET

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 AM40.1 AM500

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
CVA-CONVERSION-NBR
Element: Conversion Number		Alpha 22
Required key. This number associates the attribute or transaction with the asset.
AM500
CVA-ASSET
Element: Asset		Numeric 10
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.
AM500


AMCNVASSET FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
CVASET1 CONVERSION-NBR
AM300 AM500
AM93.1 AM94.1
CVASET2 ASSET
CONVERSION-NBR
AM170 AM40.1


AMCNVASSET FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME		 RELATED FILE INTEGRITY RULES / FIELD MATCH
Amassetcnv AMASSETCNV Not Required
CVA-CONVERSION-NBR->ACN-CONVERSION-NBR


AMCNVASSET FILE RELATIONS


ONE TO MANY RELATIONS

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

File created: Thu Jun 09 11:06:00 2016

Home
Contact Us



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