Navigation: Integration via database > Published interfaces > Administration >
This import template enables to insert/edit/delete:
▪Company contact data.
To insert each of these items, it is necessary to follow the standard documented below.
Insert/edit/delete company contacts
Column
Required
Type
Precision
Description
OIDINTERFACE
X
TEXT
32
Sequential code - Identifies an item to be imported into SoftExpert Suite.
FGIMPORT
NUMERIC
2
Import status:
1 - New;
2 - In progress;
3 - Finished;
4 - Error.
CDISOSYSTEM
10
System code where the integration will be performed to:
153 - Code of component SoftExpert Administration.
FGOPTION
Code of the operation to be performed:
19 - Insert company contact. If it exists, edits the existing record;
20 - Delete company contact.
NMFIELD01
255
Company ID (required field for deletion).
NMFIELD02
Contact name (required field for deletion).
NMFIELD03
Department.
NMFIELD04
Position.
NMFIELD05
Phone #.
NMFIELD06
Fax #.
NMFIELD07
E-mail.
NMFIELD08
Comments.
NMFIELD09
Default contact:
1 - Yes;
2 - No.