Navigation:  Integration via database > Published interfaces > PDM >

ITTYPE - Item types import

Previous  Top  Next

This import template enables to insert/edit/delete:

Data of an item type.

 

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

ITTYPE - Insert/edit/delete item type

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:

11 - Insert item type; if it exists, edits it;

12 - Delete item type.

NMFIELD01

X

TEXT

255

Item type ID # (for deletion, only this field is required).

NMFIELD02

X

TEXT

255

Item type name.

NMFIELD03

 

TEXT

255

Upper level item type.

NMFIELD04

 

X

TEXT

255

Use identification mask:

1 - Yes;

2 - No.

NMFIELD05

 

TEXT

255

Identification mask ID # (required if the option to use identification mask is equal to 1).

NMFIELD06

 

TEXT

255

Allow editing the ID # generated by the identification mask (required if the option to use identification mask is equal to 1):

1 - Yes;

2 - No.

NMFIELD07

X

TEXT

255

Revision control:

1 - Yes;

2 - No.

NMFIELD08

 

TEXT

255

Revision ID # (required if the option to control the revision is equal to 1):

1 - Numeric;

2 - Text;

3 - Customized.

NMFIELD09

 

TEXT

255

Approval method (required if the option to control the revision is equal to 1):

1 - Incremental;

2 - Circular.

NMFIELD10

 

TEXT

255

Closure (required if the option to control the revision is equal to 1):

1 - Automatic;

2 - Manual.

NMFIELD11

 

TEXT

255

Number of retentions of obsolete revisions (required if the option to control the revision is equal to 1);

NMFIELD12

 

TEXT

255

Retention frequency (required if the option to control the revision is equal to 1):

1 - Revisions;

2 - Months;

3 - Years.

NMFIELD13

 

TEXT

255

Route type (required if the option to control the revision is equal to 1):

1 - Fixed;

2 - Variable.

NMFIELD14

 

TEXT

255

Acceptance of revision draft (required if the option to control the revision is equal to 1):

1 - AND;

2 - OR.

NMFIELD15

 

TEXT

255

Acceptance of review revision (required if the option to control the revision is equal to 1):

1 - AND;

2 - OR.

NMFIELD16

 

TEXT

255

Acceptance of approval revision (required if the option to control the revision is equal to 1):

1 - AND;

2 - OR.

NMFIELD17

 

TEXT

255

Acceptance of Release revision (required if the option to control the revision is equal to 1):

1 - AND;

2 - OR.

NMFIELD18

X

TEXT

255

Watermark:

1 - Yes;

2 - No.

NMFIELD19

X

TEXT

255

Publish PDF files:

1 - Yes;

2 - No.

NMFIELD20

X

TEXT

255

File type:

1 - Simple;

2 - Multiple;

3 - Complex.

NMFIELD21

 

TEXT

255

Complex file container ID # (required if the file type option is equal to 3).