Navigation:  Integration via database > Published interfaces > Time control >

WRRESOURCE - 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:

205 – Code of component SoftExpert Time control.

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.

NMFIELD04

 

TEXT

255

Cost – regular working hour value. Required to create a new cost range for a Labor 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 Labor resource type.

NMFIELD08

 

TEXT

255

Billing date.

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.