Navigation:  Integration via database > Published interfaces > Administration >

ADMCPNATRASS - Import of association of attributes to companies

Previous  Top  Next

This import template enables to associate an attribute value with a company from the SE Administration component. Follow the standard documented below.

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:

153 - Code of component SoftExpert Administration.

FGOPTION

X

NUMERIC

2

Code of the operation to be performed:

94 - Association of an attribute with a company.

NMFIELD01

X

TEXT

255

Company ID #.

NMFIELD02

X

TEXT

255

Attribute ID #.

NMFIELD03

X

TEXT

255

Attribute value.

DSFIELD01

TEXT

4000

When the attribute is of the "Memo" type, this field will be required, whereas the NMFIELD03 will not.

 

x¹ - When the attribute is of the required "Memo" type, the value must be entered in the DSFIEL01 to support 4000 characters. If the attribute is "Memo", the DSFIELD01 is required, whereas the NMFIELD03 ceases to be.