AML Delete Specification

Disconnects an MEP from an enterprise part as an equivalent in Materials Compliance Management.

Field Num	Field Name	Definition & Materials Compliance Management-Workgroup Mapping	Materials Compliance Management Mapping
1	Rowtype	Defines the type of data in the row. Set to "AML-DELETE".
2	Part Number	The unique part number (Customer part number).	Used to match an existing EP in MMaterials Compliance ManagementCC by attribute "Name".
3	Revision Level	The part revision level.	Used to match an existing EP in Materials Compliance Management by attribute “Revision Level".
4	Revision Date	The date of the revision, which must be in the format YYYY-MM-DD.	Ignored in Materials Compliance Management
5	Division/Product Type	The product type or company division to which the part belongs. The name must correspond exactly to one of the valid names defined in Materials Compliance Management for this field.	Ignored in Materials Compliance Management
6	Supplier Name	Name of the company supplying the part	Used with Vendor Code/Number to match a Supplier in Materials Compliance Management. This is used with Supplier Part Number to match an existing MEP in Materials Compliance Management by Manufacturer
7	Vendor Code/Number	A single, unique identifier for the supplier	Used with Supplier Name to match a Supplier in MCC. This is used with Supplier Part Number to match an existing MEP in Materials Compliance Management by Manufacturer
8	Supplier Part Number	The MPN (Manufacturer Part Number)	Used with Supplier Name and Vendor Code/Number to match an existing MEP. This field is compared to the MEP "Name" attribute.

The supplier for the part is queried using the following criteria.

"Supplier Name" Field Value	"Vendor Code/Number" Field Value	Action
Empty	Empty	Syntax error
Empty	Non-empty	Match the Materials Compliance Management supplier that has at least one of the Vendor/Code Number(s) in the field value.
Non-empty	Empty	Match the Materials Compliance Management supplier with a name that exactly matches the Supplier Name field value.
Non-empty	Non-empty	Match the Materials Compliance Management Supsupplierplier with a name that exactly matches the Supplier Name field value AND has at least one of the codes in the Vendor/Code Number field value.
Note: In the cases where multiple suppliers match the criteria, the error "Supplier information matches multiple MCC suppliers" will be reported.

Once the supplier is determined, the supplied part to be removed from the AML is queried using the following configuration options.

Importer Configuration Option Values			Action
revision-level-in-part-definition-match	revision-date-in-part-definition-match	division-product-type-in-part-definition-match
no	no	no	Match Materials Compliance Management parts that have the same Part Number, Supplier, and Supplier Part Number.
no	no	yes	Match Materials Compliance Management parts that have the same Part Number, Division/Product Type, Supplier, and Supplier Part Number.
no	yes	no	Match Materials Compliance Management parts that have the same Part Number, Revision Date, Supplier, and Supplier Part Number.
no	yes	yes	Match Materials Compliance Management parts that have the same Part Number, Revision Date, Division/Product Type, Supplier, and Supplier Part Number.
yes	no	no	Match Materials Compliance Management parts that have the same Part Number, Revision Level, Supplier, and Supplier Part Number.
yes	no	yes	Match Materials Compliance Management parts that have the same Part Number, Revision Level, Division/Product Type, Supplier, and Supplier Part Number.
yes	yes	no	Match Materials Compliance Management parts that have the same Part Number, Revision Level, Revision Date, Supplier, and Supplier Part Number.
yes	yes	yes	Match Materials Compliance Management parts that have the same Part Number, Revision Level, Revision Date, Division/Product Type, Supplier, and Supplier Part Number.

If there are instances of the supplied part for the AML in Materials Compliance Management, the Importer will query Materials Compliance Management for parts that directly use these instances. If there are no direct uses, the instances will be removed from the AML. If there are direct uses, the AML will be queried (using the rowtype fields) to determine a replacement.

Importer Configuration Option Values			Action
revision-level-in-part-definition-match	revision-date-in-part-definition-match	division-product-type-in-part-definition-match
no	no	no	Match Materials Compliance Management parts that have the same Part Number, a non-empty Supplier, and a non-empty Supplier Part Number.
no	no	yes	Match Materials Compliance Management parts that have the same Part Number and Division/Product Type, a non-empty Supplier, and a non-empty Supplier Part Number.
no	yes	no	Match Materials Compliance Management parts that have the same Part Number and Revision Date , a non-empty Supplier, and a non-empty Supplier Part Number.
no	yes	yes	Match Materials Compliance Management parts that have the same Part Number, Revision Date and Division/Product Type , a non-empty Supplier, and a non-empty Supplier Part Number
yes	no	no	Match Materials Compliance Management parts that have the same Part Number and Revision Level , a non-empty Supplier, and a non-empty Supplier Part Number.
yes	no	yes	Match Materials Compliance Management parts that have the same Part Number, Revision Level and Division/Product Type, a non-empty Supplier, and a non-empty Supplier Part Number.
yes	yes	no	Match Materials Compliance Management parts that have the same Part Number, Revision Level and Revision Date, a non-empty Supplier, and a non-empty Supplier Part Number.
yes	yes	yes	Match Materials Compliance Management parts that have the same Part Number, Revision Level, Revision Date and Division/Product Type, a non-empty Supplier, and a non-empty Supplier Part Number.