Navigation: Integration via database > Published interfaces > Storeroom >
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
NUMERIC
2
Import status:
1 – New;
2 – In progress;
3 – Finished;
4 – Error;
CDISOSYSTEM
10
System code where the integration will be performed to:
180 – Code of component SoftExpert Storeroom.
FGOPTION
Code of the operation to be performed:
1 – Insert a new storeroom
NMFIELD01
255
Storeroom ID #.
NMFIELD02
Storeroom name.
NMFIELD03
Storeroom type ID #.
NMFIELD04
Storeroom object:
2 – Waste;
3 – PDM;
4 – Supply.
NMFIELD05
Responsible team ID #.
NMFIELD06
Upper level storeroom ID #.
NMFIELD07
Event configuration ID #.
NMFIELD08
Storeroom owner type:
1 – Internal;
2 – Customer;
3 – Supplier.
NMFIELD09
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
4000
Storeroom description.