Navigation:  Integration via database > Published interfaces > Project >

PRORESOURCE - Resource value import

Previous  Top  Next

This import template enables to insert/edit:

Resource values;

 

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

Add/edit resource values

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:

41 - Code of component SoftExpert Project.

FGOPTION

X

NUMERIC

2

Code of the operation to be performed:

3 – Insert resource value.

NMFIELD01

X

TEXT

255

Resource ID # or name.

NMFIELD02

X

TEXT

255

Calendar ID # or name.

NMFIELD03

 

TEXT

255

Cost date. Required to create a new cost range. Field NULL represents the initial range of the cost.

NMFIELD04

 

TEXT

255

Cost - regular working hour value. Required to create a new cost range for a Work or Asset resource type.

NMFIELD05

 

TEXT

255

Cost – overtime rate. Required to create a new cost range for the Labor resource type.

NMFIELD06

 

TEXT

255

Cost – weekend rate. Required to create a new cost range for the Labor resource type.

NMFIELD07

 

TEXT

255

Cost - percentage value. Required to create a new cost range for the Asset resource type.

NMFIELD08

 

TEXT

255

Billing date. Required to create a new billing range. Field NULL represents the initial range of the billing.

NMFIELD09

 

TEXT

255

Billing – regular working hour value. Required to create a new billing range for the Work or Asset resource type.

NMFIELD10

 

TEXT

255

Billing – overtime rate. Required to create a new billing range for the Labor resource type.

NMFIELD11

 

TEXT

255

Billing – weekend rate. Required to create a new billing range for the Labor resource type.

NMFIELD12

 

TEXT

255

Billing – daily rate. Required to create a new billing range for the Asset resource type.