Table Gen_Resource_Cost_Rates

Entity

Entity: General.Resources.ResourceCostRates

Contains cost rates for different periods for resources. Each record is valid until the next From Date. Entity: Gen_Resource_Cost_Rates

Owner Tables Hierarchy

• Gen_Resources
• Gen_Resource_Groups

Summary

Name	Type	Description
Enterprise_Company_Id	uniqueidentifier	The enterprise company for which the cost is defined.
From_Date	date	Starting date of validity of the cost rate. The rate is valid until the next cost rate record with later date is defined.
Notes	nvarchar(max)
Overtime_Rate_Per_Hour	decimal(12, 4)	The overtime cost of the resource per hour in the resources costing currency. The overtime rate specifies the cost of the resource, when it is used outside the normal working schedule. NULL means that there is no special overtime rate and the standard rate should be applied.
Per_Use_Cost	decimal(12, 2)	One-time cost for each usage of the resource in the resources costing currency.
Resource_Cost_Rate_Id	uniqueidentifier PK
Resource_Id	uniqueidentifier	The resource for which the cost rate is defined.
Row_Version	timestamp
Standard_Rate_Per_Hour	decimal(12, 4)	The standard cost per hour of the resource in the resources costing currency. The standard cost is applied for resource usage during the normal working hours.

Columns

Enterprise_Company_Id

The enterprise company for which the cost is defined.

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_Enterprise_Companies
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

Enterprise_Company_Id - Supported Filters

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

From_Date

Starting date of validity of the cost rate. The rate is valid until the next cost rate record with later date is defined.

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	date
UI Memo Editor	no
UI Width	Medium
User Login	no
Visible	yes

From_Date - Supported Filters

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

Notes

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	2147483647
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(max) (Allows NULL)
UI Memo Editor	no
UI Width	Medium
User Login	no
Visible	yes

Overtime_Rate_Per_Hour

The overtime cost of the resource per hour in the resources costing currency. The overtime rate specifies the cost of the resource, when it is used outside the normal working schedule. NULL means that there is no special overtime rate and the standard rate should be applied.

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, 4) (Allows NULL)
UI Memo Editor	no
UI Width	Medium
User Login	no
Visible	yes

Overtime_Rate_Per_Hour - Supported Filters

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

Per_Use_Cost

One-time cost for each usage of the resource in the resources costing currency.

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, 2)
UI Memo Editor	no
UI Width	Medium
User Login	no
Visible	yes

Per_Use_Cost - Supported Filters

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

Resource_Cost_Rate_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

Resource_Cost_Rate_Id - Supported Filters

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

Resource_Id

The resource for which the cost rate is defined.

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

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

Standard_Rate_Per_Hour

The standard cost per hour of the resource in the resources costing currency. The standard cost is applied for resource usage during the normal working hours.

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, 4)
UI Memo Editor	no
UI Width	Medium
User Login	no
Visible	yes

Standard_Rate_Per_Hour - Supported Filters

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