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:
107 - Code of component SoftExpert PDM.
|
FGOPTION
|
X
|
NUMERIC
|
2
|
Code of the operation to be performed:
9 - Insert/Edit association of suppliers with the items;
10 - Delete association of suppliers with the items.
|
NMFIELD01
|
X
|
TEXT
|
255
|
Item ID # (field required for deletion).
|
NMFIELD02
|
|
TEXT
|
255
|
Customer company ID. Field required if “Company code” is empty. (also valid for deletion).
|
NMFIELD03
|
|
TEXT
|
255
|
Customer company name. Field required if “Company code” is empty. (also valid for deletion).
|
NMFIELD04
|
X
|
TEXT
|
255
|
Supplier reference.
|
NMFIELD05
|
X
|
TEXT
|
4000
|
Description.
|
NMFIELD06
|
|
TEXT
|
255
|
Minimum reorder quantity.
|
NMFIELD07
|
|
TEXT
|
4000
|
Expected delivery (quantity).
|
NMFIELD08
|
|
TEXT
|
255
|
Expected delivery unit:
1 - Day;
2 - Week;
3 - Month;
4 - Year.
|
NMFIELD09
|
|
TEXT
|
4000
|
Cost.
|
NMFIELD10
|
|
TEXT
|
4000
|
Company code. Required field if “Company ID” and/or “Company name” are empty.
(also valid for deletion)
|
NMFIELD11
|
|
TEXT
|
255
|
1 - Defines that the supplier is preferential.
2 - Defines that it is NOT preferential.
When inserting, for blank value or any other value different from 1, the record will be non-preferential.
When editing, if a blank or any other value different from 1 and 2 is entered, the field will not be changed, it will keep the value previously set.
|