Navigation:  Integration via database > Published interfaces > Asset >

ASTSTRC - Asset structure import

Previous  Top  Next

This import template enables to insert/edit/delete:

Asset structure data.

 

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

Insert/edit/delete asset structures

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:

3 - Insert asset to the structure. If it exists, edits it;

4 - Delete asset in the structure.

NMFIELD01

X

TEXT

255

Upper level asset (parent asset) ID #.

NMFIELD02

X

TEXT

255

Upper level asset (parent asset) revision ID #.

NMFIELD03

X

TEXT

255

Asset (lower level asset) ID #.

NMFIELD04

X

TEXT

255

Asset (lower level asset) revision ID #.

NMFIELD05

X

TEXT

255

Quantity used in the structure.

NMFIELD06

 

TEXT

255

Object specification (Considered as 1 by default):

1 - Asset;

2 - Supply.