Project Task

Internal ID: projecttask

Supports Custom Fields

Fields

Internal ID Type nlapiSubmitField Label Required Help
actualwork float false Actual Work false Indicates the actual time entered against the task.
bbudgetshowcalculatedlines checkbox false Show Calculated Lines false Check this box to show calculated lines for each category.
bbudgetusecalculatedvalues checkbox false Use Calculated Values for all Labor Billing Budgets false Check this box to use calculated values for all labor billing budgets. You will no longer be able to enter budget amounts manually.
cbudgetshowcalculatedlines checkbox false Show Calculated Lines false Check this box to show calculated lines for each category.
cbudgetusecalculatedvalues checkbox false Use Calculated Values for all Labor Cost Budgets false Check this box to use calculated budgets for all labor cost categories. You will no longer be able to enter budgets manually.
company select false Project Name true Indicates the customer and project that this task belongs to. All project tasks must be created in the context of a project and cannot be moved from one project to another.
constrainttype select false Constraint Type false Specifies how to determine the start and end dates for a task. As Soon As Possible: NetSuite calculates the earliest possible start date for a task based on existing predecessors and sets the end date based on the available work time in the assigned resource's work calendar. Fixed Date: The task starts on the date you specify. Predecessor relationships are ignored. The task end date is based on the estimated work for the task and the assigned resource's available work time.
contact select false Contact false Select a contact for this task.
customform select false Custom Form true Select the form you want to use to enter this record. Select Standard Project Task Form to continue using this form, select a custom project task form you have already created, or select New to create a custom project task form.
enddate date false End Date false Indicates the estimated date when work for this task will be completed. NetSuite derives this date from the estimated work and other task dependencies. This date can change over the life of the project if the amount of work, resources assigned, or task dependencies change. When the task status is Completed, the end date is the date of the last time entry entered against the task.
enddatebaseline datetime false End Date Baseline false The date in the End Date field when the baseline was set.
estimatedwork float false Estimated Work false Estimated Work for a project task is the total of all completed and planned work for this task. NetSuite calculates this field by summing the estimated work entered for the resources. If you enter a value in this field, then NetSuite distributes the amount equally to all resources assigned to this task. If you also use Resource Allocations and the Allow Allocated Resources to Enter Time to All Tasks preference is enabled for this project, the estimated work field is updated to add any time tracked against tasks by allocated resources. When task status is marked Completed, this number is set to equal Actual Work.
estimatedworkbaseline float false Estimated Work Baseline false The value in the Estimated Work field when the baseline was set.
eventid integer false Project Task ID true
externalid text false ExternalId false
finishbydate date false Finish No Later Than false Select the date this task must be finished by. This constraint takes precedence over task relationships and start dates are adjusted according to the fixed end date of a task with a Finish No Later Than constraint.
fxrate currency2 false Exchange Rate false
ismilestone checkbox false false
isoncriticalpath text false false
lateend date false false
latestart date false false
message textarea false false Enter any comments for the task.
nonbillabletask checkbox false Non-billable false Check this box to designate this task as non-billable. When time is entered against this task, it is automatically marked as non-billable and cannot be changed to billable.
order select false Insert Before false To place the new task in the proper order in the schedule, select the task that follows it.
owner select false Created By false The name of the employee who created this task.
parent select false Parent Task false Select a parent task if the task you are creating is part of a group of tasks. The parent task summarizes data for all of its subordinate tasks. You cannot assign resources to a parent task.
percenttimecomplete percent false Percent Complete false Shows the percent of planned project task time that has been completed. Percent Complete is calculated as follows: [Actual Work / Estimated Work] Percent Complete is 100% when the task status is Completed and Estimated Work is set to Actual Work.
plannedwork float false Planned Work true Total planned work entered for the assigned resources. Time tracked against this task outside of the planned work is not added to this total.
plannedworkbaseline float false Planned Work Baseline false
priority select true Priority true Indicate how important the task is. Tasks with higher priorities should be worked on before tasks with lower priorities. Task priority does not affect the project schedule.
remainingwork float false Remaining Work false Remaining Work is calculated as: [Estimated Work - Actual Work] Before work starts on a task, Remainng Work is the same as Estimated Work. When a task is marked Completed, Estimated Work is set to equal Actual Work and Remaining Work is 0.
slackminutes float false false
startdate date false Start Date false Indicates the estimated date to begin work on the task. If the task constraint is Fixed Date, enter the date to begin work on the task. If the constraint is As Soon As Possible, NetSuite determines the Start Date based on the schedule.
startdatebaseline datetime false Start Date Baseline false The date in the State Date field when the baseline was set.
starttime timeofday false Start Time false For Fixed Start project tasks, optionally enter the time to start work on the task. If left blank, start time is 12:00 am. The time zone is the same time zone as the user creating the task.
status select true Status true The status for a task can be: Completed - task has been finished In Progress - task is being worked on Not Started - task has not been started You must have permission to edit a task record to change the status.
title text false Project Task Name true Enter a name for the project task.

Sublists

assignee - Assignees

Internal ID Type Label Required Help
billingclass select Billing Class false
cost currency Cost false
estimatedwork float Estimated Work true
id integer false
plannedwork float Planned Work true
price currency Price false
resource select Resource true
serviceitem select Service Item false
unitcost currency Unit Cost true
unitprice currency Unit Price false
units percent Units false

bbudget - Billing Budget

Internal ID Type Label Required Help
costcategoryref integer false
costcategorysubtype text false
costcategorytype text false
selectline checkbox Select false
totalamount currency Task Total false

cbudget - Cost Budget

Internal ID Type Label Required Help
costcategoryref integer false
costcategorysubtype text false
costcategorytype text false
selectline checkbox Select false
totalamount currency Task Total false

predecessor - Predecessors

Internal ID Type Label Required Help
enddate datetime End Date false
startdate datetime Start Date false
task select Task true
type select Type true

Tabs

Name Label
assignees Assignees
budget Budget
communication Communication
custom Custom
history History
media File Cabinet
predecessors Predecessors
time Time
workflow Workflow

Search Joins

Join ID Join Description Actual Join Name
job Job Job
predecessor Predecessor ProjectTask
projecttaskassignment Project Task Assignment Project Task Assignment
successor Successor ProjectTask
transaction Transaction Transaction

Search Filters

Internal ID Type Label
actualwork float Actual Work
assignee select Assignee
company select Project/Project Template
constrainttype select Constraint Type
contact select Contact
cost currency Estimated Cost
costbase currency Estimated Cost (Base Currency)
costbasebaseline currency Estimated Cost Baseline (Base Currency)
costbaseline currency Estimated Cost Baseline
costbasevariance currency Estimated Cost Variance (Base Currency)
costvariance currency Estimated Cost Variance
costvariancepercent float Estimated Cost Variance Percent
createddate datetime Date Created
enddate date End Date
enddatebaseline date End Date Baseline
enddatevariance float End Date Variance
estimatedwork float Estimated Work
estimatedworkbaseline float Estimated Work Baseline
estimatedworkvariance float Estimated Work Variance
estimatedworkvariancepercent float Estimated Work Variance Percent
externalid select External ID
externalidstring text External ID (Text)
finishbydate date Finish No Later Than Date
formuladate date Formula (Date)
formulanumeric float Formula (Numeric)
formulatext text Formula (Text)
id integer ID
internalid select Internal ID
internalidnumber integer Internal ID (Number)
ismilestone checkbox Milestone
issummarytask checkbox Is Job Summary Task
lastmodifieddate datetime Date Last Modified
nonbillabletask checkbox Non-billable
owner select Created By
parent select Parent Task
percentworkcomplete percent Percent Work Complete
plannedwork float Planned Work
plannedworkbaseline float Planned Work Baseline
predecessor select Predecessor
predecessors text Predecessors
priority select Priority
remainingwork float Remaining Work
startdate date Start Date
startdatebaseline date Start Date Baseline
startdatevariance float Start Date Variance
status select Status
successor select Successor
title text Task Name

Search Columns

Internal ID Type Label
actualwork float Actual Work
bbudgetusecalculatedvalues checkbox Use Calculated Values for all Labor Billing Budgets
cbudgetusecalculatedvalues checkbox Use Calculated Values for all Labor Cost Budgets
company select Project
constrainttype select Constraint Type
contact select Contact
cost currency Estimated Cost
costbase currency Estimated Cost (Base Currency)
costbasebaseline currency Estimated Cost Baseline (Base Currency)
costbaseline currency Estimated Cost Baseline
costbasevariance currency Estimated Cost Variance (Base Currency)
costvariance currency Estimated Cost Variance
costvariancepercent float Estimated Cost Variance Percent
createddate datetime Date Created
enddate date End Date
enddatebaseline date End Date Baseline
enddatevariance float End Date Variance
estimatedwork float Estimated Work
estimatedworkbaseline float Estimated Work Baseline
estimatedworkvariance float Estimated Work Variance
estimatedworkvariancepercent float Estimated Work Variance Percent
externalid select External ID
finishbydate date Finish No Later Than Date
formulacurrency currency Formula (Currency)
formuladate date Formula (Date)
formuladatetime datetime Formula (Date/Time)
formulanumeric float Formula (Numeric)
formulapercent percent Formula (Percent)
formulatext text Formula (Text)
id integer ID
internalid select Internal ID
ismilestone checkbox Milestone
issummarytask checkbox Is Summary Task
lastmodifieddate datetime Last Modified
message text Notes
nonbillabletask checkbox Non-billable
owner select Created By
parent select Parent Task
percentworkcomplete percent Percent Work Complete
plannedwork float Planned Work
plannedworkbaseline float Planned Work Baseline
predecessor select Predecessor
predecessors text Predecessors
predecessortype text Predecessor Type
priority select Priority
remainingwork float Remaining Work
startdate date Start Date
startdatebaseline date Start Date Baseline
startdatevariance float Start Date Variance
status select Status
successor select Successor
successortype text Successor Type
title text Task Name