Navigation:  Integration via database > Published interfaces > PDM >

ITINSP - Production inspection

Previous  Top  Next

This import template allows associating/editing:

Production inspection in item characteristic.

 

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

ITINSP - Production inspection

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 – PDM component code.

FGOPTION

X

NUMERIC

2

Code of the operation to be performed:

23 – Insert/Edit.

NMFIELD01

X

TEXT

255

Item ID #.

NMFIELD02

X

TEXT

255

Item revision #.

NMFIELD03

X

TEXT

255

Item characteristic ID #.

NMFIELD04

X

TEXT

255

Production inspection:

1 – Enabled;

2 – Disabled.

NMFIELD05

X1

TEXT

255

Sampling rule:

1 – Sampling plan;

3 – Defined size.

NMFIELD06

X2

TEXT

255

Sampling plan:

1 – Simple;

2 – Double;

3 – Multiple.

NMFIELD07

X2

TEXT

255

Inspection level:

1 – 01;

2 – 02;

3 – 03;

4 – S1;

5 – S2;

6 – S3;

7 – S4.

NMFIELD08

X2

TEXT

255

Work regime:

1 – Reduced;

2 – Normal;

3 – Multiple.

NMFIELD09

X2

TEXT

255

AQL:

1 – 0.01000000;

2 – 0.01500000;

3 – 0.02500000;

4 – 0.04000000;

5 – 0.65000000;

6 – 0.10000000;

7 – 0.15000000;

8 – 0.25000000;

9 – 0.40000000;

10 – 0.65000000;

11 – 1.00000000;

12 – 1.50000000;

13 – 2.50000000;

14 – 4.00000000;

15 – 6.50000000;

16 – 10.00000000;

17 – 15.00000000;

18 – 25.00000000;

19 – 40.00000000;

20 – 65.00000000;

21 – 100.00000000;

22 – 150.00000000;

23 – 250.00000000;

24 – 400.00000000;

25 – 650.00000000;

26 – 1000.00000000.

NMFIELD10

X3

TEXT

255

Number of samples.

NMFIELD11

 

TEXT

255

Unit of the number of samples.

NMFIELD12

X3

TEXT

255

Number of readings (Required in variable characteristics).

NMFIELD13

X3

TEXT

255

Number of items per sample (Required in attribute characteristics).

NMFIELD14

X3

TEXT

255

Maximum number of rejects (Required in attribute characteristics).

NMFIELD15

 

TEXT

255

Retest rule:

1 – Enabled;

2 – Disabled.

NMFIELD16

X4

TEXT

255

Retest result:

1 – Rejected;

2 – New retest.

NMFIELD17

X4

TEXT

255

Number of samples.

NMFIELD18

X4

TEXT

255

Unit of the number of samples.

NMFIELD19

X4

TEXT

255

Maximum number of rejects.

NMFIELD20

 

TEXT

255

Control time frequency:

1 – Enabled;

2 – Disabled.

NMFIELD21

X5

TEXT

255

Test frequency.

NMFIELD22

X5

TEXT

255

Unit:

5 – Minute(s);

6 – Hour(s).

NMFIELD23

 

TEXT

255

Test time.

NMFIELD24

X6

TEXT

255

Test time unit.

NMFIELD25

 

TEXT

255

Relative humidity.

NMFIELD26

X7

TEXT

255

Relative humidity unit.

NMFIELD27

 

TEXT

255

Test temperature.

NMFIELD28

X8

TEXT

255

Test temperature unit.

NMFIELD29

 

TEXT

255

Atmospheric pressure.

NMFIELD30

X9

TEXT

255

Atmospheric pressure unit.

 

1 – Required when Production inspection is enabled.

2 – Required when Sampling rule is: Sampling plan.

3 – Required when Sampling rule is: Defined size.

4 - Required when Retest rule is enabled.

5 - Required when the option of controlling time frequency is enabled.

6 - Required when the Test time field is completed.

7 - Required when the Relative humidity field is completed.

8 - Required when the Test temperature field is completed.

9 - Required when the Atmospheric pressure field is completed.