ADMATRRELATION – Attributes relationship

This import template enables to insert/delete:

•Attributes relationship.

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.