ADMCPNATRASS - Import of association between attributes and companies
This import template allows associating an attribute value with a company from the SoftExpert Administration component. Follow the standard documented below.
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: 153 - Code of the SoftExpert Administration component. |
| FGOPTION | X | NUMERIC | 2 | Code of the operation to be performed: 94 - Association of an attribute with a company. |
| NMFIELD01 | X | TEXT | 255 | Company ID #. |
| NMFIELD02 | X | TEXT | 255 | Attribute ID #. |
| NMFIELD03 | X | TEXT | 255 | Attribute value |
| DSFIELD01 | X¹ | TEXT | 4000 | When the attribute is of the "Memo" type, this field will be required, whereas the NMFIELD03 will not. |
info
Note:
- x¹ - When the attribute is of the required "Memo" type, the value must be entered in the DSFIEL01 to support 4000 characters. If the attribute is "Memo", the DSFIELD01 is required, whereas the NMFIELD03 ceases to be.