Navigation:  Integration via database > Published interfaces > Asset >

ASTSITE - Asset location import

Previous  Top  Next

This import template enables to insert/delete:

Location data of an asset.

 

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

Insert/delete asset location

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:

5 - Insert location of an asset;

6 - Delete location of an asset.

NMFIELD01

X

TEXT

255

Asset ID # (for deletion, only this field is required).

NMFIELD02

X

TEXT

255

Asset location data.

Note: It cannot be greater than the current date (Format: yyyy-mm-dd).

NMFIELD03

X

TEXT

255

Asset location time (Format: hh:mm).

NMFIELD04

 

X

TEXT

255

Location type:

1 - Location;

2 - User;

3 - Location and user;

4 - Coordinate;

5 - Location and coordinate;

6 - User and coordinate;

7 - Location, user and coordinate.

NMFIELD05

X

TEXT

255

Storage place ID #. Required for location type 1, 3, 5 or 7.

NMFIELD06

 

X

TEXT

255

User ID # (User ID). Required for location type 2, 3, 6 or 7.

NMFIELD07

 

TEXT

255

Comments.

NMFIELD08

 

NUMERIC

2

Update the location of the child assets.

[1- Update; 2 or empty - Do not update (default value)]

NMFIELD09

X

TEXT

255

Coordinate.

Required for location type 4, 5, 6 or 7.