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:
73 - Code of component SoftExpert Document.
|
FGOPTION
|
X
|
NUMERIC
|
2
|
Code of the operation to be performed:
95 - Inserts a new attribute value.
|
NMFIELD01
|
X
|
TEXT
|
255
|
Attribute ID #.
|
NMFIELD02
|
X
|
TEXT
|
255
|
Attribute value.
Required information if the attribute type is List of values. Non-discrete type attributes 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's reg. code #.
|
NMFIELD05
|
|
TEXT
|
255
|
Server (the name or the 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.
|
