| Internal ID | Type | nlapiSubmitField | Label | Required | Help |
|---|---|---|---|---|---|
| actualwork | float | false | Actual Work | false | |
| company | select | false | Project Name | true | |
| constrainttype | select | false | Constraint Type | false | |
| contact | select | false | Contact | false | |
| customform | select | false | Custom Form | true | |
| enddate | date | false | End Date | false | |
| enddatebaseline | datetime | false | End Date Baseline | false | |
| estimatedwork | float | false | Estimated Work | false | |
| estimatedworkbaseline | float | false | Estimated Work Baseline | false | |
| eventid | integer | false | Project Task ID | true | |
| externalid | text | false | ExternalId | false | |
| finishbydate | date | false | Finish No Later Than | false | |
| 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 | ||
| nonbillabletask | checkbox | false | Non-billable | false | |
| order | select | false | Insert Before | false | |
| owner | select | false | Created By | false | |
| parent | select | false | Parent Task | false | |
| percenttimecomplete | percent | false | Percent Complete | false | |
| priority | select | true | Priority | true | |
| remainingwork | float | false | Remaining Work | false | |
| slackminutes | float | false | false | ||
| startdate | date | false | Start Date | false | |
| startdatebaseline | datetime | false | Start Date Baseline | false | |
| starttime | timeofday | false | Start Time | false | |
| status | select | true | Status | true | |
| title | text | false | Project Task Name | true |
| Internal ID | Type | Label | Required |
|---|---|---|---|
| cost | currency | Cost | false |
| estimatedwork | float | Estimated Work | true |
| id | integer | false | |
| 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 |
| Internal ID | Type | Label | Required |
|---|---|---|---|
| enddate | datetime | End Date | false |
| startdate | datetime | Start Date | false |
| task | select | Task | true |
| type | select | Type | true |
| Name | Label |
|---|---|
| assignees | Assignees |
| communication | Communication |
| custom | Custom |
| history | History |
| media | File Cabinet |
| predecessors | Predecessors |
| time | Time |
| workflow | Workflow |
| Join ID | Join Description | Actual Join Name |
|---|---|---|
| job | Job | Job |
| predecessor | Predecessor | ProjectTask |
| successor | Successor | ProjectTask |
| Internal ID | Type | Label |
|---|---|---|
| actualwork | float | Actual Work |
| assignee | select | Assignee |
| 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 |
| 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 |
| 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 |
| Internal ID | Type | Label |
|---|---|---|
| actualwork | float | Actual Work |
| 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 |
| 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 |