Navigation:  Integration via database > Published interfaces > Supply >

INSATTR - Association of attributes with the supply

Previous  Top  Next

This import template enables to import attributes into supply records and to determine their values.

 

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:

149 - Code of component SoftExpert Supply.

FGOPTION

X

NUMERIC

2

Code of the operation to be performed:

14 – Inserts a new attribute association. If the attribute is already associated, it only updates its value.

NMFIELD01

X

TEXT

255

Supply ID #.

NMFIELD02

X

TEXT

255

Attribute ID #.

NMFIELD03

X

TEXT

255

Attribute value.

NMFIELD04

 

TEXT

255

Revision ID #.

NMFIELD10

 

TEXT

255

If the value 1 is entered, 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.