ITCUST - Item X customer association import

Insert/edit/delete association between item and customers

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:

5 - Insert/Edit association of customers with items;

6 - Delete association of customers with items.

NMFIELD01

X1

TEXT

255

Item ID #.

NMFIELD02

X2

TEXT

255

Customer company ID.

NMFIELD03

X3

TEXT

255

Customer company name.

NMFIELD04

TEXT

255

Customer item #.

NMFIELD05

TEXT

255

Customer revision #.

NMFIELD06

TEXT

255

Customer drawing #.

NMFIELD07

TEXT

255

Customer drawing date.

NMFIELD10

X4

TEXT

255

Company code.

NMFIELD11

TEXT

255

1 - Defines that the customer 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.