INSINS - Supply import

Insert

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:

149 - Code of component SoftExpert Supply.

FGOPTION

X

NUMERIC

2

Code of the operation to be performed:

1 - Insert supply; if it exists, edits it;

2 – Delete supply.

NMFIELD01

X

TEXT

255

Supply ID # (for deletion only this field is required).

NMFIELD02

X

TEXT

255

Supply name.

NMFIELD03

X

TEXT

255

Supply type (ID #).

NMFIELD04

X

TEXT

255

Responsible team (ID #).

NMFIELD05

TEXT

255

Cost.

NMFIELD06

X

TEXT

255

Measurement unit (ID #).

NMFIELD07

TEXT

255

Revision date.

NMFIELD08

TEXT

255

Color ID #.

NMFIELD09

TEXT

255

Odor ID #.

NMFIELD10

TEXT

255

UN code.

NMFIELD11

TEXT

255

ABNT code.

NMFIELD12

TEXT

255

Hazard ID #.

NMFIELD13

TEXT

255

Classification ID #.

NMFIELD14

NUMERIC

2

Lot and series control [1 - Lot, 2 - Series].

NMFIELD15

NUMERIC

2

Physical state [1 - Solid, 2 - Liquid, 3 - Gas, 4 - Sludge].

NMFIELD16

X1

TEXT

255

User's reg. code #.

DSFIELD01

TEXT

4000

Supply 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.

DSFIELD02

TEXT

4000

Comments.

DSFIELD03

TEXT

4000

General description of the composition.