Navigation:  Integration via database > Published interfaces > PDM >

ITCARTPAT - Asset type association import with the item characteristics

Previous  Top  Next

This import template enables to associate the asset type with the characteristic records in the item.

 

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

ITCARTPAT – Import of the asset type association with the item 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:

22 – Associate.

NMFIELD01

X

TEXT

255

Item ID #.

NMFIELD02

X

TEXT

255

Item revision ID #.

NMFIELD03

X

TEXT

255

Characteristic ID #.

NMFIELD04

X

TEXT

255

Asset type ID #.