Navigation:  Integration via database > Published interfaces > Administration >

ADCTC - Company contacts import

Previous  Top  Next

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

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:

19 - Insert company contact. If it exists, edits the existing record;

20 - Delete company contact.

NMFIELD01

X

TEXT

255

Company ID (required field for deletion).

NMFIELD02

X

TEXT

255

Contact name (required field for deletion).

NMFIELD03

 

TEXT

255

Department.

NMFIELD04

 

TEXT

255

Position.

NMFIELD05

 

TEXT

255

Phone #.

NMFIELD06

 

TEXT

255

Fax #.

NMFIELD07

 

TEXT

255

E-mail.

NMFIELD08

 

TEXT

255

Comments.

NMFIELD09

 

TEXT

255

Default contact:

1 - Yes;

2 - No.