The CRM Fields custom field is available for the Project Tasks table.
| Name | Type | Length | Precision | Scale | References | In | Description |
|---|---|---|---|---|---|---|---|
| actual_work | NUMBER | 39 | 0 | Amount of work completed for project task | |||
| allocated_work | NUMBER | 39 | 0 | Allocated work | |||
| assigned_id | NUMBER | 39 | 0 | Assigned To | |||
| calculated_work | NUMBER | 39 | 0 | Current calculated work required for task | |||
| calculated_work_baseline | NUMBER | 39 | 0 | Original calculated work required for task | |||
| constraint_type | VARCHAR2 | 15 | Method for calculating estimated start and end dates for project task (as soon as possible or fixed date) | ||||
| date_last_modified | TIMESTAMP | Date last modified (GMT) | |||||
| due_date | TIMESTAMP | Date when project task must be completed | |||||
| end_date | TIMESTAMP | Current estimated date to complete project task | |||||
| end_date_baseline | TIMESTAMP | Original estimated date to complete project task | |||||
| estimated_cost | NUMBER | 39 | 0 | Current estimated cost of project task | |||
| estimated_cost_baseline | NUMBER | 39 | 0 | Original estimated cost of project task | |||
| estimated_cost_baseline_frn | NUMBER | 39 | 0 | Original estimated cost of project task in foreign currency | |||
| estimated_cost_foreign | NUMBER | 39 | 0 | Current estimated cost of project task in foreign currency | |||
| estimated_work | NUMBER | 39 | 0 | Current estimate of work required for task | |||
| estimated_work_baseline | NUMBER | 39 | 0 | Original estimate of work required for task | |||
| finish_by_date | TIMESTAMP | Finish no later than | |||||
| is_milestone | VARCHAR2 | 1 | Indicates whether the project task is a milestone. | ||||
| is_non_billable | VARCHAR2 | 3 | Indicates whether the project task is non-billable | ||||
| is_on_critical_path | VARCHAR2 | 3 | Indicates whether the project task is on critical path. | ||||
| is_summary_task | VARCHAR2 | 3 | Is parent task | ||||
| isinactive | VARCHAR2 | 3 | Is inactive | ||||
| message | VARCHAR2 | 4000 | Notes about project task | ||||
| name | VARCHAR2 | 256 | Project task name | ||||
| owner_id | NUMBER | 39 | 0 | Project task owner | |||
| parent_task_id | NUMBER | 39 | 0 | ID for parent project task of this project task, if any | |||
| percent_complete | NUMBER | 39 | 0 | Percent of project task complete | |||
| percent_complete_by_allocation | NUMBER | 39 | 0 | Percent of project task complete by allocation | |||
| planned_work | NUMBER | 39 | 0 | Current planned work required for task | |||
| planned_work_baseline | NUMBER | 39 | 0 | Original planned work required for task | |||
| priority | VARCHAR2 | 32 | Relative importance of task: high, medium, or low. | ||||
| project_id | NUMBER | 39 | 0 | Project ID | |||
| projecttask_extid | VARCHAR2 | 255 | Project task external ID | ||||
| projecttask_id | NUMBER | 39 | 0 | Project task ID | |||
| slack_minutes | NUMBER | 39 | 0 | Slack minutes of the project task (indicates how much the start of the project task can be delayed without delaying the end of the project). | |||
| start_date | TIMESTAMP | Current estimated date to begin work on project task | |||||
| start_date_0 | TIMESTAMP | Start date | |||||
| start_date_baseline | TIMESTAMP | Original estimated date to begin work on project task | |||||
| status | VARCHAR2 | 64 | Status of project task | ||||
| taskorder | NUMBER | 39 | 0 | Project task that follows | |||
| use_calculated_billing_budget | VARCHAR2 | 3 | Use calculated billing budget | ||||
| use_calculated_cost_budget | VARCHAR2 | 3 | Use calculated cost budget |
| PK Column Name |
|---|
| projecttask_id |