This import template makes it possible to:
▪Map requirements by business unit, department4, item, supplier, supply, asset and waste.
To insert each of these items, it is necessary to follow the standard documented below.
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:
227 – Requirement component code
|
FGOPTION
|
X
|
NUMERIC
|
2
|
Code of the operation to be performed:
7 – Map by business unit.
|
NMFIELD01
|
X
|
TEXT
|
50
|
Requirement mapping ID #
|
NMFIELD02
|
X
|
TEXT
|
50
|
Requirement ID #
|
NMFIELD03
|
X1
|
NUMERIC
|
50
|
Department ID #
|
NMFIELD04
|
|
NUMERIC
|
2
|
Applicable:
1 – Yes;
2 – No.
|
NMFIELD05
|
|
NUMERIC
|
2
|
Value implemented
Data input standards:
• Values between 0 and 10
|
NMFIELD06
|
|
TEXT
|
50
|
Criterion 1 ID #
|
NMFIELD07
|
|
NUMERIC
|
2
|
Criterion 1 value
|
NMFIELD08
|
|
TEXT
|
50
|
Criterion 2 ID #
|
NMFIELD09
|
|
NUMERIC
|
2
|
Criterion 2 value
|
NMFIELD10
|
|
TEXT
|
50
|
Criterion 3 ID #
|
NMFIELD11
|
|
NUMERIC
|
2
|
Criterion 3 value
|
NMFIELD12
|
|
TEXT
|
50
|
Criterion 4 ID #
|
NMFIELD13
|
|
NUMERIC
|
2
|
Criterion 4 value
|
NMFIELD14
|
|
TEXT
|
50
|
Criterion 5 ID #
|
NMFIELD15
|
|
NUMERIC
|
2
|
Criterion 5 value
|
DSFIELD01
|
|
TEXT
|
4000
|
Explanation
|
|