ITITEM - Item import

To insert each of these items, it is necessary to follow the standard documented below.

Insert/edit/delete item
Column	Required	Type	Precision	Description
OIDINTERFACE	X	TEXT	32	Sequential code - 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	System code where the integration will be performed to: 107 - Code of component SoftExpert PDM.
FGOPTION	X	NUMERIC	2	Code of the operation to be performed: 1 - Insert item; if it exists, edits it; 2 - Delete item.
NMFIELD01		TEXT	255	Item ID #; if it is not entered, an ID # will be created automatically (for deletion, only this field is required).
NMFIELD02	X	TEXT	255	Item name.
NMFIELD03	X	TEXT	255	Item type ID #.
NMFIELD04	X	TEXT	255	Responsible team ID #.
NMFIELD05	X	TEXT	255	Measurement unit ID #.
NMFIELD06		TEXT	255	Physical state: 1 – Solid; 2 – Liquid; 3 – Gas; 4 – Sludge.
NMFIELD07		TEXT	255	Odor ID #.
NMFIELD08		TEXT	255	Color name.
NMFIELD09		TEXT	255	UN code.
NMFIELD10		TEXT	255	Hazard ID #.
NMFIELD11		TEXT	255	Classification ID #.
NMFIELD12		TEXT	255	ABNT code.
NMFIELD13		TEXT	255	Revision date, in the YYYY/MM/DD format.
NMFIELD14		TEXT	255	Revision ID #.
NMFIELD15	X1	TEXT	255	User's reg. code #.
NMFIELD16		TEXT	255	Item family: 1 - Yes.
NMFIELD17		TEXT	255	Item family ID #.
NMFIELD18		TEXT	255	Item cost value.
NMFIELD19		TEXT	255	Drawing ID #
DSFIELD01		TEXT	4000	General description of the composition.
DSFIELD02		TEXT	4000	Item attributes. Example: identifier_of_attribute1=value_of_attribute1; identifier_of_attribute2=value_of_attribute2; identifier_of_attribute3=value_of_attribute3 Example with a multivalued attribute: identifier_of_attribute1=value1_of_attribute1,value2_of_attribute1,value3_of_attibute1 Note: For attributes with a numeric value, the decimal place separator must be '.'. For date fields, the value must have the “Y-M-D” (Year-Month-Day) format.