To insert each one 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:
153 - Code of component SoftExpert Administration.
FGOPTION
X
NUMERIC
2
Code of the operation to be performed:
97 – Add relationship.
NMFIELD01
X
TEXT
255
Parent attribute ID #.
NMFIELD02
X
TEXT
255
Child attribute ID #.
NMFIELD03
X
TEXT
255
Parent attribute value.
Notes according to the attribute type:
• Numeric: numeric digits without thousand separator and with period (.) as decimal separator
• Currency: numeric digits without thousand separator and with period (.) as decimal separator
• Date: YYYY-MM-DD
• Hour: HHHH:MM
NMFIELD04
X
TEXT
255
Child attribute value.
Notes according to the attribute type:
• Numeric: numeric digits without thousand separator and with period (.) as decimal separator
• Currency: numeric digits without thousand separator and with period (.) as decimal separator
• Date: YYYY-MM-DD
• Hour: HHHH:MM
NMFIELD05
TEXT
255
Use [1 – Yes, 2 – No] as default.
If it is not entered, [2 – No] will be considered.
The relationship can only be set between attributes of the List of values type.
Delete
Column
Required
Type
Precision
Description
OIDINTERFACE
X
NUMERIC
10
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:
153 - Code of component SoftExpert Administration.
FGOPTION
X
NUMERIC
2
Code of the operation to be performed:
98 – Delete relationship.
NMFIELD01
X
TEXT
255
Parent attribute ID #.
NMFIELD02
X
TEXT
255
Child attribute ID #.
NMFIELD03
X1
TEXT
255
Parent attribute value (required when entering the child attribute value)
Notes according to the attribute type:
• Numeric: numeric digits without thousand separator and with period (.) as decimal separator
• Currency: numeric digits without thousand separator and with period (.) as decimal separator
• Date: YYYY-MM-DD
• Hour: HHHH:MM
NMFIELD04
X1
TEXT
255
Child attribute value (required when entering the parent attribute value)
Notes according to the attribute type:
• Numeric: numeric digits without thousand separator and with period (.) as decimal separator
• Currency: numeric digits without thousand separator and with period (.) as decimal separator
• Date: YYYY-MM-DD
• Hour: HHHH:MM
X1 - Required to remove only the relationship between attribute values; if it is omitted, all relationships between the parent and child attributes will be removed.