Navigation:  Integration via database > Published interfaces > Storeroom >

STMEVENTATTRIB - Association of event attributes import

Previous  Top  Next

This import template makes it possible to insert:

Data of an event attribute association.

 

To insert each of these items, it is necessary to 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:

180 – Code of component SoftExpert Storeroom.

FGOPTION

X

NUMERIC

2

Code of the operation to be performed:

12 – Inserts a new event attribute association.

NMFIELD01

X

TEXT

255

Event ID #.

NMFIELD02

X

TEXT

255

Attribute ID #.

NMFIELD03

X

TEXT

255

Attribute value.

NMFIELD04

X

TEXT

255

Revision ID #.

Required information if the component needs the revision code in the specific table of the attribute.

NMFIELD10

 

TEXT

255

If the entered value is 1, the interface will verify whether the attribute value already belongs to the list of values; if it does not exist, it will be added.

DSFIELD01

 

TEXT

4000

Attribute value.

Mandatory information if the type of the attribute value is MEMO.