Navigation:  Integration via database > Published interfaces > Document >

DCDOCATR - Attribute import

Previous  Top  Next

This import template makes it possible to insert:

Data of an attribute.

 

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

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:

73 - Code of component SoftExpert Document.

FGOPTION

X

NUMERIC

2

Code of the operation to be performed:

96 - Inserts a new attribute.

NMFIELD01

X

TEXT

255

Attribute ID #.

NMFIELD02

X

TEXT

255

Attribute name.

NMFIELD03

X

TEXT

255

User's reg. code #.

NMFIELD04

X

TEXT

255

Attribute type:

1 - List of values;

2 - Non-discrete;

3 - External.

NMFIELD05

 

TEXT

255

Attribute data type.    

List of values:    

1 - Text;

2 - Numeric;

3 - Date;

5 - Currency.

Non-discrete  

1 - Text;

2 - Numeric;

3 - Date;

4 - Memo;

5 - Currency.

External    

1 - Text.

NMFIELD06

 

TEXT

255

Selection mode.

List of values and External attribute types must inform the Selection mode. Accepted values:

1 - Zoom;

2 - Combo.

The List of values attribute type can inform whether the attribute will be Multivalued. Accepted values:

1 - Multivalued.

NMFIELD07

 

TEXT

255

Multivalued.

NMFIELD75

 

TEXT

255

Upper level interface code. If the upper level interface is not imported successfully, the current interface will not be executed.