ITSUPP - Item x Supplier association import

This import template allows inserting/editing/deleting:

• Item and supplier association data.

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

Insert

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: 9 - Insert/edit supplier association with items; 10 - Delete supplier association with items.
NMFIELD01	X	TEXT	255	Item ID # (field required for deletion).
NMFIELD02		TEXT	255	Customer company ID. Field required if “Company code” is empty. (also valid for deletion).
NMFIELD03		TEXT	255	Customer company name. Field required if “Company code” is empty. (also valid for deletion).
NMFIELD04	X	TEXT	255	Supplier reference.
NMFIELD05	X	TEXT	4000	Description.
NMFIELD06		TEXT	255	Minimum reorder quantity.
NMFIELD07		TEXT	4000	Expected delivery (quantity).
NMFIELD08		TEXT	255	Expected delivery unit: 1 - Day; 2 - Week; 3 - Month; 4 - Year.
NMFIELD09		TEXT	4000	Cost.
NMFIELD10		TEXT	4000	Company code. Field required if “Company ID” and/or “Company name” are empty (also valid for deletion).
NMFIELD11		TEXT	255	1 - Defines that the supplier 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.