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	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	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.