ITMANU - Item x Manufacturer association import

This import template allows inserting/editing/deleting:

• Item and manufacturer association data.

For the insertion of each one of these items, the standard documented below must be followed.

Insert/edit/delete association between item and manufacturer

Column	Required	Type	Precision	Description
OIDINTERFACE	X	TEXT	32	Primary key - Identifies an item to be imported into SoftExpert Suite.
FGIMPORT	X	NUMERIC	2	Import status: 1 - New; 2 - In progress; 3 - Finished; 4 - Error.
CDISOSYSTEM	X	NUMERIC	10	Code of the system for which the integration will be performed: 107 - Code of the SoftExpert PDM component.
FGOPTION	X	NUMERIC	2	Code of the operation to be performed: 7 - Insert/edit manufacturer association with items; 8 - Delete manufacturer association with items.
NMFIELD01	X¹	TEXT	255	Item ID #.
NMFIELD02	X²	TEXT	255	Customer company ID.
NMFIELD03	X³	TEXT	255	Customer company name.
NMFIELD04	X	TEXT	255	Manufacturer reference.
NMFIELD05	X	TEXT	255	Model.
NMFIELD10	X⁴	TEXT	255	Company code.
NMFIELD11		TEXT	255	1 - Defines that the manufacturer is preferential. 2 - Defines that the customer is NOT preferential. For insertion, in case of blank value or any other value different from 1, the record will be non-preferential. For editing, if a blank value or any other value different from 1 and 2 is entered, the field will not be changed, it will keep the value previously set.

info

Note:

• X¹ - Field required for deletion.
• X² - Field required if "Company code" is empty (also valid for deletion).
• X³ - Field required if "Company code" is empty (also valid for deletion).
• X⁴ - Field required if “Company ID” and/or “Company name” are empty (also valid for deletion).