Table of Contents

Table Prj_Project_Task_Resources

Entity

Entity: Projects.Classic.ProjectTaskResources

Contains the resources, required by the project tasks. Entity: Prj_Project_Task_Resources

Owner Tables Hierarchy

Summary

Name Type Description
Billing_Price_Per_Hour decimal(12, 5) When not null, specifies the price per hour (in the currency of the Project) of resource usage which will be used for billing. NULL means that the item will be billed in another way. This way of billing is mutually exclusive with Fixed Total Price
Billing_Total_Amount decimal(14, 2) When not NULL, specifies that this item will be billed for the specified fixed total price (in the currency of the Project). NULL means that this item will be billed in another way. This way of billing is mutually exclusive with Billing Price Per Hour.
Cost_Per_Hour decimal(12, 5) Cost per hour for the resource usage for this task (in the currency of the project).
Notes nvarchar(254)
Per_Use_Cost decimal(14, 2) One time cost for each resource usage, specified in the projects currency.
Project_Task_Id uniqueidentifier The task for which the resource is planned.
Project_Task_Resource_Id uniqueidentifier PK
Resource_Id uniqueidentifier The planned resource.
Resource_Instance_Id uniqueidentifier The concrete resource instance, which should be used. NULL when no specific resource instance is required.
Resource_Usage_Hours decimal(10, 2) The total number of resource-hours, which are planned for this task. Equals to the length of the task, multiplied by the resource usage.
Resource_Usage_Percent decimal(18, 4) The planned resource usage for this activity in percents. Values of more than 100% are allowed when more than 1 resource is required.
Row_Version timestamp
Task_Total_Cost decimal(14, 2) Total cost for this task (in the currency of the project).

Columns

Billing_Price_Per_Hour

When not null, specifies the price per hour (in the currency of the Project) of resource usage which will be used for billing. NULL means that the item will be billed in another way. This way of billing is mutually exclusive with Fixed Total Price

Property Value
Auto Complete no
Data Filter no
Default Value None
Enter Stop yes
Format N2
Ignore for Insert Order no
Is Entity Name no
Max Length -1
Order 2147483647
Ownership Reference no
Pasword no
Picture no
Primary Key no
Readonly no
RTF no
Sortable no
Summary Type None
Supports EQUALS_IN no
Type decimal(12, 5) (Allows NULL)
UI Memo Editor no
UI Width Medium
User Login no
Visible yes

Billing_Price_Per_Hour - Supported Filters

Filter Type Default Include Nulls Hidden by Default
Equals NULL yes no

Billing_Total_Amount

When not NULL, specifies that this item will be billed for the specified fixed total price (in the currency of the Project). NULL means that this item will be billed in another way. This way of billing is mutually exclusive with Billing Price Per Hour.

Property Value
Auto Complete no
Data Filter no
Default Value None
Enter Stop yes
Format N2
Ignore for Insert Order no
Is Entity Name no
Max Length -1
Order 2147483647
Ownership Reference no
Pasword no
Picture no
Primary Key no
Readonly no
RTF no
Sortable no
Summary Type None
Supports EQUALS_IN no
Type decimal(14, 2) (Allows NULL)
UI Memo Editor no
UI Width Medium
User Login no
Visible yes

Billing_Total_Amount - Supported Filters

Filter Type Default Include Nulls Hidden by Default
Equals NULL yes no

Cost_Per_Hour

Cost per hour for the resource usage for this task (in the currency of the project).

Property Value
Auto Complete no
Data Filter no
Default Value 0
Enter Stop yes
Format N2
Ignore for Insert Order no
Is Entity Name no
Max Length -1
Order 2147483647
Ownership Reference no
Pasword no
Picture no
Primary Key no
Readonly no
RTF no
Sortable no
Summary Type None
Supports EQUALS_IN no
Type decimal(12, 5)
UI Memo Editor no
UI Width Medium
User Login no
Visible yes

Cost_Per_Hour - Supported Filters

Filter Type Default Include Nulls Hidden by Default
Equals NULL no no

Notes

Property Value
Attributes IsLongString
Auto Complete no
Data Filter no
Default Value None
Enter Stop yes
Ignore for Insert Order no
Is Entity Name no
Max Length 254
Order 2147483647
Ownership Reference no
Pasword no
Picture no
Primary Key no
Readonly no
RTF no
Sortable no
Summary Type None
Supports EQUALS_IN no
Type nvarchar(254) (Allows NULL)
UI Memo Editor no
UI Width Medium
User Login no
Visible yes

Per_Use_Cost

One time cost for each resource usage, specified in the projects currency.

Property Value
Auto Complete no
Data Filter no
Default Value None
Enter Stop yes
Format N2
Ignore for Insert Order no
Is Entity Name no
Max Length -1
Order 2147483647
Ownership Reference no
Pasword no
Picture no
Primary Key no
Readonly no
RTF no
Sortable no
Summary Type None
Supports EQUALS_IN no
Type decimal(14, 2) (Allows NULL)
UI Memo Editor no
UI Width Medium
User Login no
Visible yes

Project_Task_Id

The task for which the resource is planned.

Property Value
Auto Complete no
Data Filter no
Default Value None
Enter Stop yes
Ignore for Insert Order no
Is Entity Name no
Max Length -1
Order 2147483647
Ownership Reference yes
Pasword no
Picture no
Primary Key no
Readonly no
Referenced Table Prj_Project_Tasks
RTF no
Sortable no
Summary Type None
Supports EQUALS_IN yes
Type uniqueidentifier
UI Memo Editor no
UI Width Medium
User Login no
Visible yes

Project_Task_Id - Supported Filters

Filter Type Default Include Nulls Hidden by Default
Equals NULL no no

Project_Task_Resource_Id

Property Value
Auto Complete no
Data Filter no
Default Value NewGuid
Enter Stop yes
Ignore for Insert Order no
Is Entity Name no
Max Length -1
Order 2147483647
Ownership Reference no
Pasword no
Picture no
Primary Key yes (order: 1)
Readonly no
RTF no
Sortable no
Summary Type None
Supports EQUALS_IN yes
Type uniqueidentifier
UI Memo Editor no
UI Width Medium
User Login no
Visible no

Project_Task_Resource_Id - Supported Filters

Filter Type Default Include Nulls Hidden by Default
Equals NULL no no

Resource_Id

The planned resource.

Property Value
Auto Complete no
Data Filter no
Default Value None
Enter Stop yes
Ignore for Insert Order no
Is Entity Name no
Max Length -1
Order 2147483647
Ownership Reference no
Pasword no
Picture no
Primary Key no
Readonly no
Referenced Table Gen_Resources
RTF no
Sortable no
Summary Type None
Supports EQUALS_IN yes
Type uniqueidentifier
UI Memo Editor no
UI Width Medium
User Login no
Visible yes

Resource_Id - Supported Filters

Filter Type Default Include Nulls Hidden by Default
Equals NULL no no

Resource_Instance_Id

The concrete resource instance, which should be used. NULL when no specific resource instance is required.

Property Value
Auto Complete no
Data Filter no
Default Value None
Enter Stop yes
Ignore for Insert Order no
Is Entity Name no
Max Length -1
Order 2147483647
Ownership Reference no
Pasword no
Picture no
Primary Key no
Readonly no
Referenced Table Gen_Resource_Instances
RTF no
Sortable no
Summary Type None
Supports EQUALS_IN yes
Type uniqueidentifier (Allows NULL)
UI Memo Editor no
UI Width Medium
User Login no
Visible yes

Resource_Instance_Id - Supported Filters

Filter Type Default Include Nulls Hidden by Default
Equals NULL yes no

Resource_Usage_Hours

The total number of resource-hours, which are planned for this task. Equals to the length of the task, multiplied by the resource usage.

Property Value
Auto Complete no
Data Filter no
Default Value 0
Enter Stop yes
Ignore for Insert Order no
Is Entity Name no
Max Length -1
Order 2147483647
Ownership Reference no
Pasword no
Picture no
Primary Key no
Readonly no
RTF no
Sortable no
Summary Type None
Supports EQUALS_IN no
Type decimal(10, 2)
UI Memo Editor no
UI Width Medium
User Login no
Visible yes

Resource_Usage_Hours - Supported Filters

Filter Type Default Include Nulls Hidden by Default
Equals NULL no no

Resource_Usage_Percent

The planned resource usage for this activity in percents. Values of more than 100% are allowed when more than 1 resource is required.

Property Value
Attributes IsPercent
Auto Complete no
Data Filter no
Default Value 1
Enter Stop yes
Ignore for Insert Order no
Is Entity Name no
Max Length -1
Order 2147483647
Ownership Reference no
Pasword no
Picture no
Primary Key no
Readonly no
RTF no
Sortable no
Summary Type None
Supports EQUALS_IN no
Type decimal(18, 4)
UI Memo Editor no
UI Width Medium
User Login no
Visible yes

Resource_Usage_Percent - Supported Filters

Filter Type Default Include Nulls Hidden by Default
Equals NULL no no

Row_Version

Property Value
Auto Complete no
Data Filter no
Default Value None
Enter Stop yes
Ignore for Insert Order no
Is Entity Name no
Max Length -1
Order 2147483647
Ownership Reference no
Pasword no
Picture no
Primary Key no
Readonly no
RTF no
Sortable no
Summary Type None
Supports EQUALS_IN no
Type timestamp
UI Memo Editor no
UI Width Medium
User Login no
Visible no

Task_Total_Cost

Total cost for this task (in the currency of the project).

Property Value
Auto Complete no
Data Filter no
Default Value 0
Enter Stop yes
Format N2
Ignore for Insert Order no
Is Entity Name no
Max Length -1
Order 2147483647
Ownership Reference no
Pasword no
Picture no
Primary Key no
Readonly no
RTF no
Sortable no
Summary Type None
Supports EQUALS_IN no
Type decimal(14, 2)
UI Memo Editor no
UI Width Medium
User Login no
Visible yes

Task_Total_Cost - Supported Filters

Filter Type Default Include Nulls Hidden by Default
Equals NULL no no
Suggest improvement to this page