DCDOCATRVAL - Attribute value import

This import template allows inserting:

• Attribute value data.

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: 73 - Code of the SoftExpert Document component.
FGOPTION	X	NUMERIC	2	Code of the operation to be performed: 95 - Insert new attribute value.
NMFIELD01	X	TEXT	255	Attribute ID #.
NMFIELD02	X	TEXT	255	Attribute value. Information required if the attribute type is "List of values". Attributes of the Undetermined type will not be accepted for value import.
NMFIELD03	X	TEXT	255	Use as default. 1 - The value of the attribute will be the default for the attribute; 2 - The value of the attribute will not be the default for the attribute.
NMFIELD04	X	TEXT	255	User ID
NMFIELD05		TEXT	255	Server (name or IP address of the external-attribute database).
NMFIELD06		TEXT	255	Alias/Database path (external attribute).
NMFIELD07		TEXT	255	Database user (external attribute).
NMFIELD08		TEXT	255	Password (external attribute).
NMFIELD09		TEXT	255	DB type. 1 - ITERBASE 2 - MSSQL 3 - MSSQL (ODBC) 4 - ORACLE < 8.05 5 - ORACLE 8/9 (SERVICE NAME) 6 - ORACLE 8/9 (SID) 7 - ORACLE (ODBC) 8 - DB2 (ODBC) 9 - INFORMIX 10 - ORACLE 8/9 (TNS NAME) 11 - MySQL 12 - POSTGRESQL
NMFIELD10		TEXT	255	SQL (Select that will search for the external attribute field).
NMFIELD11		TEXT	255	Field.
NMFIELD75		TEXT	255	Upper-level interface code. If the upper-level interface is not imported successfully, the current interface will not be executed.