Navigation:  Integration via database > Published interfaces > Storeroom >

STMOUTPUTEVENT - Output event import

Previous  Top  Next

This import template makes it possible to insert:

Data of an output event.

 

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

Insert

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:

180 – Code of component SoftExpert Storeroom.

FGOPTION

X

NUMERIC

2

Code of the operation to be performed:

9 – Insert a new output event.

NMFIELD01

X

TEXT

255

Event ID #.

NMFIELD02

X

TEXT

255

Storeroom ID #.

NMFIELD03

 

TEXT

255

Source responsibility ID #.

NMFIELD04

 

TEXT

255

Source date.

NMFIELD05

X

TEXT

255

Addressee type:

1 – Department;

2 – User;

3 – Supplier;

4 – Delete.

NMFIELD06

 

TEXT

255

Addressee/disposition, according to the previous type:

Department: department ID #;

User: user ID #;

Supplier: supplier id#;

Delete - Disposal/Treatment: disposal/treatment ID #.

NMFIELD07

 

TEXT

255

Destination responsibility ID #.

NMFIELD08

 

TEXT

255

Destination date.

NMFIELD09

 

TEXT

255

Approval route ID #.

DSFIELD01

 

TEXT

4000

Event description.