Navigation:  Integration via database > Published interfaces > Storeroom >

STMSTORAGEPLACE - Storage place import

Previous  Top  Next

This import template makes it possible to insert:

Storage place data.

 

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:

5 – Insert a new storage place

NMFIELD01

X

TEXT

255

Storeroom ID #.

NMFIELD02

X

TEXT

255

Storage place ID #.

NMFIELD03

X

TEXT

255

Storage place name.

NMFIELD04

 

X

TEXT

255

Place type:

1 – Storage place;

2 – Repository.

NMFIELD05

 

TEXT

255

Upper storage place ID #.

NMFIELD06

 

TEXT

255

Controls the capacity of repositories (Not valid for repository type):

1 – Yes;

2 or NULL – No.

NMFIELD07

 

TEXT

255

Maximum number of repositories.

Note: Required if the previous field is 1.