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:
3 – Import of a new storeroom object.
|
NMFIELD01
|
X
|
TEXT
|
255
|
Storeroom ID #.
|
NMFIELD02
|
X
|
TEXT
|
255
|
Object ID #
|
NMFIELD03
|
|
TEXT
|
255
|
Control ideal amount:
1 - Yes;
2 or NULL – No.
|
NMFIELD04
|
|
TEXT
|
255
|
Ideal quantity (required if the value of the previous field is 1).
|
NMFIELD05
|
|
TEXT
|
255
|
Notify when the stock is below the ideal quantity:
1 - Yes;
2 or NULL – No.
|
NMFIELD06
|
|
TEXT
|
255
|
Control reorder point:
1 – Yes;
2 or NULL – No.
|
NMFIELD07
|
|
TEXT
|
255
|
Reorder point quantity.
|
NMFIELD08
|
|
TEXT
|
255
|
Notify when the stock is below the reorder point:
1 - Yes;
2 or NULL – No.
|
NMFIELD09
|
|
TEXT
|
255
|
Restrict storage place:
1 - Yes;
2 or NULL – No.
|
NMFIELD10
|
|
TEXT
|
255
|
Control maximum capacity:
1 - Yes;
2 or NULL – No.
|