Navigation:  Integration via database > Published interfaces > PDM >

ITATRIB - Attribute type characteristics import

Previous  Top  Next

This import template enables to insert and/or edit attribute type characteristics.

 

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

ITCARATR – Import of attribute type characteristics

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:

15 – Only inserts;

16 – Only edits;

17 – Insert and, if there is already a record with the same ID #, edits the existing record.

NMFIELD01

X

TEXT

255

Item ID #.

NMFIELD02

X

TEXT

255

Item revision ID #.

NMFIELD03

X

TEXT

255

Characteristic ID #.

NMFIELD04

X

TEXT

255

Characteristic name.

NMFIELD05

 

TEXT

255

Characteristic type ID #.

NMFIELD06

 

TEXT

255

Special characteristic:

1 – Yes;

2 – No.

If the "Require symbol in the characteristic" general parameter from SoftExpert PDM is checked, the system will always consider it as "1 - Yes", even when any value is entered, requiring the input of a symbol.

NMFIELD07

 

TEXT

255

Customer symbol name Required if the characteristic is special.

NMFIELD08

 

TEXT

255

Supplier symbol name Required if the characteristic is special.

NMFIELD15

 

TEXT

255

# of items per sample (not required). Used in the SPC tab in the item characteristic

DSFIELD01

 

TEXT

4000

Comments.

DSFIELD02

 

TEXT

4000

Specifications.