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:
149 - Code of component SoftExpert Supply.
|
FGOPTION
|
X
|
NUMERIC
|
2
|
Code of the operation to be performed:
7 – Insert supply type; if it exists, edits it;
8 – Delete supply type;
|
NMFIELD01
|
X
|
TEXT
|
255
|
Supply type ID # (for deletion, only this field is required).
|
NMFIELD02
|
X
|
TEXT
|
255
|
Supply type name.
|
NMFIELD03
|
|
TEXT
|
255
|
Upper level supply type (ID #).
|
NMFIELD04
|
|
TEXT
|
255
|
Identification mask (ID #).
|
NMFIELD05
|
|
TEXT
|
255
|
Allow editing the ID # generated by the identification mask (required if the option to use identification mask is equal to 1):
1 – Yes;
2 – No.
|
NMFIELD06
|
X
|
TEXT
|
255
|
Revision control:
1 – Yes;
2 – No.
|
NMFIELD07
|
|
TEXT
|
255
|
Revision template:
1 – ISO9000 based;
2 – Workflow.
Required in the case of revision
|
NMFIELD08
|
|
TEXT
|
255
|
Route type:
1 – Fixed;
2 – Variable;
3 – Fixed & unique.
Required in the case of revision
|
NMFIELD09
|
|
TEXT
|
255
|
Revision route (ID #):
Revised if the revision template is ISO9000 and the route type is “fixed & unique”
|
NMFIELD10
|
|
TEXT
|
255
|
Process (ID #):
Required if the revision template is WORKFLOW.
|
NMFIELD11
|
|
TEXT
|
255
|
Revision ID #:
1 – Numeric;
2 – Text;
3 – Customized.
Required in the case of revision
|
NMFIELD12
|
|
TEXT
|
255
|
Cycle:
1 – Numeric;
2 – Text.
Required in the case of revision
|
NMFIELD13
|
|
TEXT
|
255
|
Retention of obsolete revisions – Quantity.
|
NMFIELD14
|
|
TEXT
|
255
|
Retention of obsolete revisions – Frequency unit:
1 – Revisions;
2 – Months;
3 – Years.
|
NMFIELD15
|
|
TEXT
|
255
|
Change:
1 – Text;
2 – Numeric.
Required in the case of revision
|
NMFIELD16
|
|
TEXT
|
255
|
ISO9000 configuration – Approval mode:
1 – Incremental;
2 – Circular.
Required if the revision template is ISO9000.
|
NMFIELD17
|
|
TEXT
|
255
|
ISO9000 configuration – Closure:
1 – Automatic;
2 – Manual.
Required if the revision template is ISO9000.
|
NMFIELD18
|
|
TEXT
|
255
|
ISO9000 configuration – Draft:
1 – AND;
2 – OR.
Required if the revision template is ISO9000.
|
NMFIELD19
|
|
TEXT
|
255
|
ISO9000 configuration – Review:
1 – AND;
2 – OR.
Required if the revision template is ISO9000.
|
NMFIELD20
|
|
TEXT
|
255
|
ISO9000 configuration – Approval:
1 – AND;
2 – OR.
Required if the revision template is ISO9000.
|
NMFIELD21
|
|
TEXT
|
255
|
ISO9000 configuration – Release:
1 – AND;
2 – OR.
Required if the revision template is ISO9000.
|
NMFIELD22
|
|
TEXT
|
255
|
Begin filling in the explanation when starting a revision
1 – Yes;
2 – No.
Required in the case of revision
|