Navigation:  Integration via database > Published interfaces > PDM >

ITMANU - Item X manufacturer association import

Previous  Top  Next

This import template enables to insert/edit/delete:

Data of the association between item and manufacturers.

 

To insert each of these items, it is necessary to follow the standard documented below.

Insert/edit/delete association between item and manufacturers

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:

107 - Code of component SoftExpert PDM.

FGOPTION

X

NUMERIC

2

Code of the operation to be performed:

7 – Insert/Edit association of manufacturers with items;

8 – Delete association of manufacturers with items.

NMFIELD01

X1

TEXT

255

Item ID #.

NMFIELD02

X2

TEXT

255

Customer company ID.

NMFIELD03

X3

TEXT

255

Customer company name.

NMFIELD04

X

TEXT

255

Manufacturer reference.

NMFIELD05

X

TEXT

255

Template.

NMFIELD10

X4

TEXT

255

Company code.

NMFIELD11

 

TEXT

255

1 - Defines that the manufacturer is preferential.

2 - Defines that it is NOT preferential.

When inserting, for blank value or any other value different from 1, the record will be non-preferential.

When editing, if a blank or any other value different from 1 and 2 is entered, the field will not be changed, it will keep the value previously set.

 

X1 - Field required for deletion.

X2 - Field required if “Company code” is empty. (also valid for deletion).

X3 - Field required if “Company code” is empty. (also valid for deletion).

X4 - Field required if “Company ID” and/or “Company name” are empty. (also valid for deletion).