Navigation:  Integration via database > Published interfaces > Maintenance >

MNMAINTVARIABLE – Variable reading

Previous  Top  Next

This import template makes it possible to insert:

Asset variable readings

 

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

Insert reading

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:

126 – Code of the SoftExpert Maintenance component

FGOPTION

X

NUMERIC

2

Code of the operation to be performed:

3 – Insert variable reading

NMFIELD01

X

TEXT

255

Asset ID #.

NMFIELD02

X

TEXT

255

Variable ID #.

NMFIELD03

X

TEXT

255

If it is a subjective variable:

Name of the option of the list of values of the variable.

 

If it is an objective variable:

Reading value.

NMFIELD04

 

TEXT

255

Variable reading date.

If empty, it will consider the date and time of the import service.

NMFIELD05

TEXT

255

Variable reading time, in the hh:mm (00:00 - 23:59) format. If empty, it will consider the date and time of the import service.

 

X¹ - Required if the reading date is filled in.