INSATTR - Attribute association with supply
This import template allows importing attributes into supplies and setting their values.
For the insertion of each one of these items, the standard documented below must be followed.
Insert
| Column | Required | Type | Precision | Description |
|---|---|---|---|---|
| OIDINTERFACE | X | TEXT | 32 | Primary key - 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: 149 - Code of the SoftExpert Supply component. |
| FGOPTION | X | NUMERIC | 2 | Code of the operation to be performed: 14 - Insert new attribute association. If the attribute is already associated, the system will simply update the value. |
| NMFIELD01 | X | TEXT | 255 | Supply ID # |
| NMFIELD02 | X | TEXT | 255 | Attribute ID #. |
| NMFIELD03 | X | TEXT | 255 | Attribute value. |
| NMFIELD04 | TEXT | 255 | Revision ID #. | |
| NMFIELD10 | TEXT | 255 | If the value 1 is entered, The interface will check if the attribute value already belongs to the list of values; if it does not exist, it will be added. | |
| DSFIELD01 | TEXT | 4000 | Attribute value. Information required if the attribute value is of the MEMO type. |