RQMAPPINGANALYSIS - Map requirement
This import template allows:
- Mapping requirements by business unit, department4, item, supplier, supply, asset, and waste.
To insert each of these items, the standard documented below must be followed.
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 | Code of the system for which the integration will be performed: 227 - Code of the SoftExpert Requirement component. |
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 | X¹ | NUMERIC | 50 | Department ID # |
NMFIELD04 | NUMERIC | 2 | Applicable: 1 - Yes; 2 - No. | |
NMFIELD05 | NUMERIC | 2 | Value implemented Data input standard: • 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. |
info
Note:
- ¹ - To evaluate requirements with "Quantitative" evaluation method, the "Criterion ID #" and "Criterion value" fields must be completed.
- ² - To evaluate requirements with "Simple listing" evaluation method, only the
"Criterion value" (
NMFIELD06
) must be entered. - ³ - Only standard formulas are supported for importing requirement evaluation. It is not possible to import using customized formulas.
- ⁴ - For requirement mapping by business unit and department, only one department can be mapped.
tip
Examples of standard formulas:
CRITERIONOPERATION('Add';'With weight')
CRITERIONOPERATION('Multiply';'Without weight')
CRITERION('001';'Value')
CRITERION('001';'Weight')