Navigation:  Integration via database > Published interfaces > Asset >

ASTOEE - Insertion of Parameter data to calculate OEE

Previous  Top  Next

This import template enables to add:

Parameter data to calculate OEE

 

To insert the data, 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:

109 - Code of component SoftExpert Asset.

FGOPTION

X

NUMERIC

2

Code of the operation to be performed:

20 – Add.

NMFIELD01

X

TEXT

255

Asset ID #

NMFIELD02

X

TEXT

255

Start date. Date format must be Y-M-D (Year-Month-Day)

NMFIELD04

X

TEXT

255

End date. Date format must be Y-M-D (Year-Month-Day)

NMFIELD06

X

TEXT

255

Quality parts

NMFIELD07

X

TEXT

255

Total parts

NMFIELD08

X

TEXT

255

Amount produced

NMFIELD09

X

TEXT

255

Planned quantity