Skip to main content
Version: 2.2.0

INSINS - Supply import

This import template allows inserting, updating or deleting:

  • Supply definition.

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

ColumnRequiredTypePrecisionDescription
OIDINTERFACEXTEXT32Sequential code - Identifies an item to be imported into SoftExpert Suite.
FGIMPORTXNUMERIC2Import status:
1 - New;
2 - In progress;
3 - Finished;
4 - Error.
CDISOSYSTEMXNUMERIC10Code of the system for which the integration will be performed:
149 - Code of the SoftExpert Supply component.
FGOPTIONXNUMERIC2Code of the operation to be performed:
1 - Insert supply; if the record exists already, it will be edited;
2 - Delete supply.
NMFIELD01XTEXT255Supply ID # (for deletion, only this field is required).
NMFIELD02XTEXT255Supply name.
NMFIELD03XTEXT255Supply type (ID #).
NMFIELD04XTEXT255Responsible team (ID #).
NMFIELD05TEXT255Cost.
NMFIELD06XTEXT255Measurement unit (ID #).
NMFIELD07TEXT255Revision date.
NMFIELD08TEXT255Color ID #.
NMFIELD09TEXT255Odor ID #.
NMFIELD10TEXT255UN code.
NMFIELD11TEXT255ABNT code.
NMFIELD12TEXT255Hazard ID #.
NMFIELD13TEXT255Classification ID #.
NMFIELD14NUMERIC2Lot and series control [1 - Lot, 2 - Series].
NMFIELD15NUMERIC2Physical state [1 - Solid, 2 - Liquid, 3 - Gas, 4 - Sludge].
NMFIELD16TEXT255User ID.
DSFIELD01TEXT4000Supply 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.
DSFIELD02TEXT4000Comments.
DSFIELD03TEXT4000General description of the composition.
info

Note:

  • X¹ - Required only when the supply type used contains revision.