This import template makes it possible to insert:
▪Data of the objects of an input event
To insert each of these items, it is necessary to follow the standard documented below.
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:
180 – Code of component SoftExpert Storeroom.
|
FGOPTION
|
X
|
NUMERIC
|
2
|
Code of the operation to be performed:
11 – Insert a new object of an input event.
|
NMFIELD01
|
X
|
TEXT
|
255
|
Event ID #.
|
NMFIELD02
|
X
|
TEXT
|
255
|
Object ID #.
|
NMFIELD03
|
X
|
TEXT
|
255
|
Storage place ID #.
|
NMFIELD04
|
X
|
TEXT
|
255
|
Quantity.
|
NMFIELD05
|
|
TEXT
|
255
|
Lot number.
|
NMFIELD06
|
|
TEXT
|
255
|
Serial number.
|
NMFIELD07
|
|
NUMERIC
|
10
|
Unit cost.
|
NMFIELD08
|
|
TEXT
|
255
|
Expiration date. Date format must be Y-M-D (Year-Month-Day).
|
|