ITCARVAR – Import of variable type characteristics
|
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:
18 – Only inserts;
19 – Only edits;
20 – Insert and, if there is already a record with the same ID #, edits the existing record.
|
NMFIELD01
|
X
|
TEXT
|
255
|
Item ID #.
|
NMFIELD02
|
X
|
TEXT
|
255
|
Item revision ID #.
|
NMFIELD03
|
X
|
TEXT
|
255
|
Characteristic ID #.
|
NMFIELD04
|
X
|
TEXT
|
255
|
Characteristic name.
|
NMFIELD05
|
|
TEXT
|
255
|
Characteristic type ID #.
|
NMFIELD06
|
|
TEXT
|
255
|
Special characteristic:
1 – Yes;
2 – No.
If the "Require symbol in the characteristic" general parameter from SoftExpert PDM is checked, the system will always consider it as "1 - Yes", even when any value is entered, requiring the input of a symbol.
|
NMFIELD07
|
|
TEXT
|
255
|
Customer symbol name Required if the characteristic is special.
|
NMFIELD08
|
|
TEXT
|
255
|
Supplier symbol name Required if the characteristic is special.
|
NMFIELD09
|
X
|
TEXT
|
255
|
Number of decimal places.
|
NMFIELD10
|
X
|
TEXT
|
255
|
Limits:
0 – Bilateral;
1 – Unilateral up;
2 – Unilateral down.
|
NMFIELD11
|
X
|
TEXT
|
255
|
Measurement unit ID #.
|
NMFIELD12
|
X
|
TEXT
|
255
|
Nominal value.
|
NMFIELD13
|
X
|
TEXT
|
255
|
Upper tolerance.
|
NMFIELD14
|
X
|
TEXT
|
255
|
Lower tolerance.
|
NMFIELD15
|
|
TEXT
|
255
|
# of items per sample (not required). Used in the SPC tab in the item characteristic
|
DSFIELD01
|
|
TEXT
|
4000
|
Comments.
|