Navigation:  Integration via database > Published interfaces > Storeroom >

STMSTORE - Storeroom import

Previous  Top  Next

This import template makes it possible to insert:

Data of a storeroom.

 

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:

1 – Insert a new storeroom

NMFIELD01

X

TEXT

255

Storeroom ID #.

NMFIELD02

X

TEXT

255

Storeroom name.

NMFIELD03

X

TEXT

255

Storeroom type ID #.

NMFIELD04

 

X

TEXT

255

Storeroom object:

2 – Waste;

3 – PDM;

4 – Supply.

NMFIELD05

X

TEXT

255

Responsible team ID #.

NMFIELD06

 

TEXT

255

Upper level storeroom ID #.

NMFIELD07

 

TEXT

255

Event configuration ID #.

NMFIELD08

X

TEXT

255

Storeroom owner type:

1 – Internal;

2 – Customer;

3 – Supplier.

NMFIELD09

 

TEXT

255

Storeroom owner ID #.

If internal: Department ID #.

If customer: Customer ID #.

If supplier: Supplier ID#.

Note: If it is not entered, it must follow the owner type.

DSFIELD01

 

TEXT

4000

Storeroom description.