Navigation:  Integration via database > Published interfaces > Inspection >

IPREC - Import of receiving

Previous  Top  Next

This import template enables to insert/edit/send to next step/delete:

Receiving data

 

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

Insert/edit/delete receiving

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:

34 – Code of component SoftExpert Inspection.

FGOPTION

X

NUMERIC

2

Code of the operation to be performed:

3 – Add;

4 – Edit;

5 – Delete.

NMFIELD01

X1

TEXT

255

Inspection form ID #

NMFIELD02

X2

TEXT

255

Supplier company ID.

NMFIELD03

X3

TEXT

255

Lot number

NMFIELD04

X3

TEXT

255

Invoice number

NMFIELD05

X3

TEXT

255

Invoice date

NMFIELD06

X3

TEXT

255

Order number

NMFIELD07

X3

TEXT

255

Order date

NMFIELD08

X3

TEXT

255

Request order number

NMFIELD09

X3

TEXT

255

Request order date

NMFIELD10

X3

TEXT

255

Production order number

NMFIELD11

X3

TEXT

255

Production order date

NMFIELD12

X3

TEXT

255

Estimated date

NMFIELD13

X3

TEXT

255

Actual date

NMFIELD14

X

TEXT

255

Expected amount

NMFIELD15

X

TEXT

255

Actual quantity

NMFIELD16

X3

TEXT

255

Estimated cost

NMFIELD17

X3

TEXT

255

Actual cost

NMFIELD18

X4

TEXT

255

Inspection flow ID #

NMFIELD19

 

TEXT

255

Send to the next step (only for editing):

1 – Send to the next step;

2 – Do not send to the next step.

NMFIELD20

X5

TEXT

255

Workflow instance ID #

NMFIELD21

X6

TEXT

255

Receiving ID # (number)

NMFIELD22

X3

TEXT

255

Estimated time

NMFIELD23

X3

TEXT

255

Actual time

NMFIELD24

 

TEXT

255

Description

 

X1 – Required when adding; ignored for other actions.

X2 – Required for inspections of Supplies, Services, and External finished products, ignored for other object types.

X3 – Required, not required, or ignored, depending on the configurations of inspection form type set.

X4 – Required if the "Allow editing flow during receiving" option is checked on the inspection form tab, or ignored otherwise.

X5 – Required if the inspection object is a Workflow process instance; otherwise it is ignored.

X6 – Required to edit and delete.