The CRM Fields custom field is available for the Resource Allocations table.
Name | Type | Length | Precision | Scale | References | In | Description |
---|---|---|---|---|---|---|---|
allocation_type | VARCHAR2 | 200 | Type of allocation (Soft or Hard) | ||||
allocation_unit | VARCHAR2 | 1 | Allocation unit (H for hours, P for percentage of time) | ||||
customer_id | NUMBER | 39 | 0 | Customer for which the resource is allocated | |||
date_last_modified | TIMESTAMP | Last modification date | |||||
end_date | TIMESTAMP | End date | |||||
is_inactive | VARCHAR2 | 3 | Inactive | ||||
notes | VARCHAR2 | 4000 | Notes | ||||
num_hours | NUMBER | 10 | 4 | Number of hours | |||
num_percent | NUMBER | 12 | 4 | Percentage of allocated working time (based on resource's working calendar) | |||
project_id | NUMBER | 39 | 0 | Project for which the resource is allocated | |||
project_task_id | NUMBER | 39 | 0 | Project task ID | |||
requestor_id | NUMBER | 39 | 0 | Requestor (owner) of the allocation | |||
resource_allocation_extid | VARCHAR2 | 255 | Resource allocation external ID | ||||
resource_allocation_id | NUMBER | 39 | 0 | Resource allocation ID | |||
resource_id | NUMBER | 39 | 0 | Allocated resource (employee/vendor) | |||
start_date | TIMESTAMP | Start date |