ProjectResources
Tracks resource allocations by listing employees, materials, and costs assigned to specific projects.
Columns
| Name | Type | ReadOnly | Description |
| Recordno [KEY] | String | False |
Unique identifier for the project resource record. |
| Whencreated | Datetime | False |
Timestamp indicating when the resource allocation was created. |
| Whenmodified | Datetime | False |
Timestamp indicating when the resource allocation was last modified. |
| Createdby | Int64 | False |
User ID of the person who created the resource allocation. |
| Modifiedby | Int64 | False |
User ID of the person who last modified the resource allocation. |
| Projectkey | Int64 | False |
Unique key identifying the project associated with the resource allocation. |
| Projectid | String | False |
Identifier for the project associated with the resource allocation. |
| Projectname | String | False |
Name of the project associated with the resource allocation. |
| Employeekey | Int64 | False |
Unique key identifying the employee assigned to the project. |
| Employeeid | String | False |
Identifier for the employee assigned to the project. |
| Employeecontactname | String | False |
Name of the employee assigned to the project. |
| Itemkey | Int64 | False |
Unique key identifying the item allocated to the project. |
| Itemid | String | False |
Identifier for the item allocated to the project. |
| Itemname | String | False |
Name of the item allocated to the project. |
| Description | String | False |
Description of the resource allocation for the project. |
| Startdate | Datetime | False |
Start date of the resource allocation for the project. |
| Billingpricing | String | False |
Billing pricing strategy applied to the resource. |
| Billingrate | Double | False |
Billing rate applied to the resource. |
| Expensepricing | String | False |
Expense pricing strategy applied to the resource. |
| Expenserate | Double | False |
Expense rate applied to the resource. |
| Poappricing | String | False |
Purchase order or accounts payable pricing strategy applied to the resource. |
| Poaprate | Double | False |
Purchase order or accounts payable rate applied to the resource. |
| Record_url | String | False |
URL linking to the record of the resource allocation. |