This import template enables to insert/edit/send to next step/delete:
▪Receiving data
To insert each of these items, it is necessary to follow the standard documented below.
Insert/edit/delete receiving
|
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:
34 – Code of component SoftExpert Inspection.
|
FGOPTION
|
X
|
NUMERIC
|
2
|
Code of the operation to be performed:
3 – Add;
4 – Edit;
5 – Delete.
|
NMFIELD01
|
X1
|
TEXT
|
255
|
Inspection form ID #
|
NMFIELD02
|
X2
|
TEXT
|
255
|
Supplier company ID.
|
NMFIELD03
|
X3
|
TEXT
|
255
|
Lot number
|
NMFIELD04
|
X3
|
TEXT
|
255
|
Invoice number
|
NMFIELD05
|
X3
|
TEXT
|
255
|
Invoice date
|
NMFIELD06
|
X3
|
TEXT
|
255
|
Order number
|
NMFIELD07
|
X3
|
TEXT
|
255
|
Order date
|
NMFIELD08
|
X3
|
TEXT
|
255
|
Request order number
|
NMFIELD09
|
X3
|
TEXT
|
255
|
Request order date
|
NMFIELD10
|
X3
|
TEXT
|
255
|
Production order number
|
NMFIELD11
|
X3
|
TEXT
|
255
|
Production order date
|
NMFIELD12
|
X3
|
TEXT
|
255
|
Estimated date
|
NMFIELD13
|
X3
|
TEXT
|
255
|
Actual date
|
NMFIELD14
|
X
|
TEXT
|
255
|
Expected amount
|
NMFIELD15
|
X
|
TEXT
|
255
|
Actual quantity
|
NMFIELD16
|
X3
|
TEXT
|
255
|
Estimated cost
|
NMFIELD17
|
X3
|
TEXT
|
255
|
Actual cost
|
NMFIELD18
|
X4
|
TEXT
|
255
|
Inspection flow ID #
|
NMFIELD19
|
|
TEXT
|
255
|
Send to the next step (only for editing):
1 – Send to the next step;
2 – Do not send to the next step.
|
NMFIELD20
|
X5
|
TEXT
|
255
|
Workflow instance ID #
|
NMFIELD21
|
X6
|
TEXT
|
255
|
Receiving ID # (number)
|
NMFIELD22
|
X3
|
TEXT
|
255
|
Estimated time
|
NMFIELD23
|
X3
|
TEXT
|
255
|
Actual time
|
NMFIELD24
|
|
TEXT
|
255
|
Description
|
|