Project

Internal ID: job

Fields

Internal ID	Type	nlapiSubmitField	Label	Required	Help
accountnumber	text	true	Account	false
actualtime	time	false	Actual Work	false
allowallresourcesfortasks	checkbox	true	Display All Resources for ProjectTask Assignment	false
allowexpenses	checkbox	true	Allow Expenses	false
allowtime	checkbox	true	Allow Time Entry	false
autoname	checkbox	false	Auto	false
billingschedule	select	false	Billing Schedule	false
calculatedenddate	date	false	Calculated End Date	false
calculatedenddatebaseline	date	false	Calculated End Date Baseline	false
category	select	true	Category	false	Select the category that applies to this customer. To add choices to this list, go to <_TABNAME=EDIT_ACCOUNTINGOTHERLIST_> &gt <_TASKCATEGORY= ACCOUNTINGOTHERLIST _> &gt; New &gt; Customer Category. For example, you might create categories of wholesale, retail, and online.
comments	textarea	true	Comments	false	Enter other information about this project.
companyname	text	true	Project Name	false
contact	select	false	Primary Contact	false
currency	select	false	Currency	false	The customer's currency is shown here. This is the currency used for all transactions and records created for this project. If you use the Multi-Currency Customers feature, select the customer's transaction currency you want to use for this project and its associated records and transactions.
currencyprecision	text	false	Currency Precision	false
customform	select	false	Custom Form	true
datecreated	datetime	false	Date Created	false
enddate	date	false	Actual End Date	false
entityid	text	true	Project ID	true
entitystatus	select	true	Status	false
estimatedcost	currency	false	Estimated Cost	false
estimatedgrossprofit	currency	false	Estimated Gross Profit	false
estimatedgrossprofitpercent	percent	false	Estimated Gross Profit Percent	false
estimatedlaborcost	currency	false	Estimated Labor Cost	false
estimatedlaborcostbaseline	currency	false	Estimated Labor Cost Baseline	false
estimatedlaborrevenue	currency	false	Estimated Labor Revenue	false
estimatedrevenue	currency	false	Estimated Revenue	false
estimatedtime	time	true	Initial Time Budget	false
estimatedtimeoverride	time	false	Estimated Work	false
estimatedtimeoverridebaseline	time	false	Estimated Work Baseline	false
estimaterevrectemplate	select	false	Rev Rec Forecast Template	false
externalid	text	false	ExternalId	false
fxrate	currency2	false	Exchange Rate	false
includecrmtasksintotals	checkbox	true	Include CRM Tasks in Project Totals	false
isbasecurrency	checkbox	false	Base Currency	false
isexempttime	checkbox	true	Classify Time as Exempt	false
isinactive	checkbox	true	Inactive	false
isjob	text	false		false
isproductivetime	checkbox	true	Classify Time as Productive	false
isutilizedtime	checkbox	true	Classify Time as Utilized	false
jobbillingtype	select	false	Billing Type	false
jobitem	select	false	Billing Item	false
jobprice	currency	false	Project Price	false
jobtype	select	false	Project Type	false
language	select	false	Language	false	Select the language to use to display all project records and invoices.
lastbaselinedate	date	false	Last Baseline Date	false
lastmodifieddate	datetime	false	Last Modified Date	false
limittimetoassignees	checkbox	true	Limit Time Entry to Assignees	false
materializetime	checkbox	true	Create Planned Time Entries	false
otherrelationships	select	false	Other Relationships	false
parent	select	false	Customer	false	Enter the name of the customer for this project. If you are creating a subproject, then enter a customer and project in this field.
percentcomplete	percent	false	Percent Complete	false
percenttimecomplete	percent	false	Percent Work Complete	false
projectedenddate	date	false	Estimated End Date	false
projectedenddatebaseline	date	false	Estimated End Date Baseline	false
stage	text	false		false
startdate	date	false	Start Date	false
startdatebaseline	date	false	Start Date Baseline	false
subsidiary	select	false	Subsidiary	true
timeremaining	time	false	Remaining Work	false

Sublists

jobresources - Resource Details

Internal ID	Type	Label	Required
email	email	Email	false
jobresource	select	Name	true
role	select	Role	true

Tabs

Name	Label
address	Address
custom	Custom
financial	Financial
general	General
info	Info
resources	Resources
schedule	Schedule
workflow	Workflow

Search Joins

Join ID	Join Description	Actual Join Name
billingschedule	Billing Schedule	Billing Schedule
campaignresponse	Campaign Response	Campaign
contactprimary	Contact (Primary)	Contact
customer	Customer	Customer
messages	Messages	Message
messagesfrom	Messages From	Message
messagesto	Messages To	Message
projecttask	Project Task	ProjectTask
task	Task	Task

Search Filters

Internal ID	Type	Label
accountnumber	text	Account
actualtime	float	Actual Work
address	textarea	Address
addressee	text	Addressee
addresslabel	text	Address Label
addressphone	phone	Address Phone
allocatepayrollexpenses	checkbox	Allocate Payroll Expenses
allowallresourcesfortasks	checkbox	Display All Resources for ProjectTask Assignment
allowexpenses	checkbox	Allow Expenses
allowtime	checkbox	Allow Time Entry
applyprojectexpensetypetoall	checkbox	Apply to all time entries
attention	text	Attention
billingschedule	select	Billing Schedule
calculatedenddate	date	Calculated End Date
calculatedenddatebaseline	date	Calculated End Date Baseline
category	select	Category
city	text	City
comments	textarea	Comments
contact	text	Contact
country	select	Country
county	text	County/State
customer	select	Customer
datecreated	datetime	Date Created
email	text	Email
enddate	date	Actual End Date
entityid	text	Name/ID
estcost	currency	Estimated Cost
estenddate	date	Projected End Date
estimatedgrossprofit	currency	Estimated Gross Profit
estimatedgrossprofitpercent	percent	Estimated Gross Profit %
estimatedlaborcost	currency	Estimated Labor Cost
estimatedlaborcostbaseline	currency	Estimated Labor Cost Baseline
estimatedlaborrevenue	currency	Estimated Labor Revenue
estimatedtime	float	Initial Time Budget
estimatedtimeoverride	float	Estimated Work
estimatedtimeoverridebaseline	float	Estimated Work Baseline
estrevenue	currency	Estimated Revenue
externalid	select	External ID
externalidstring	text	External ID (Text)
fax	phone	Fax
formuladate	date	Formula (Date)
formulanumeric	float	Formula (Numeric)
formulatext	text	Formula (Text)
giveaccess	checkbox	Login Access
globalsubscriptionstatus	select	Global Subscription Status
image	image	Image
includecrmtasksintotals	checkbox	Include CRM Tasks in Job Totals
internalid	select	Internal ID
internalidnumber	integer	Internal ID (Number)
isdefaultbilling	checkbox	Default Billing Address
isdefaultshipping	checkbox	Default Shipping Address
isexempttime	checkbox	Classify Time as Exempt
isinactive	checkbox	Inactive
isproductivetime	checkbox	Classify Time as Productive
isutilizedtime	checkbox	Classify Time as Utilized
jobbillingtype	select	Billing Type
jobitem	select	Billing Item
jobprice	currency	Job Price
jobresource	select	Job Resource
jobresourcerole	select	Job Resource Role
jobtype	select	Job Type
language	select	Language
lastbaselinedate	date	Last Baseline Date
lastmodifieddate	datetime	Last Modified
level	select	Level
limittimetoassignees	checkbox	Limit Time and Expenses To Resources
materializetime	checkbox	Create Planned Time Entries
parent	select	Sub of
pctcomplete	integer	Percent Complete
percenttimecomplete	integer	Percent Time Complete
permission	select	Permission
phone	phone	Phone
phoneticname	text	Phonetic Name
projectedenddatebaseline	date	Projected End Date Baseline
representingsubsidiary	select	Represents Subsidiary
startdate	date	Start Date
startdatebaseline	date	Start Date Baseline
state	select	State/Province
status	select	Status
subsidiary	select	Subsidiary
timeremaining	float	Remaining Work
type	select	Entity Type
zipcode	text	Zip

Search Columns

Internal ID	Type	Label
accountnumber	text	Account
actualtime	float	Actual Work
address	text	Address
address1	text	Address 1
address2	text	Address 2
address3	text	Address 3
addressee	text	Addressee
addressinternalid	text	Address Internal ID
addresslabel	text	Address Label
addressphone	text	Address Phone
allocatepayrollexpenses	checkbox	Allocate Payroll Expenses
allowallresourcesfortasks	checkbox	Display All Resources for ProjectTask Assignment
allowexpenses	checkbox	Allow Expenses
allowtime	checkbox	Allow Time Entry
altcontact	text	Alt. Contact
altemail	email	Alt. Email
altname	text	Name
altphone	phone	Office Phone
attention	text	Attention
billaddress1	text	Billing Address 1
billaddress2	text	Billing Address 2
billaddress3	text	Billing Address 3
billaddressee	text	Billing Addressee
billattention	text	Billing Attention
billcity	text	Billing City
billcountry	select	Billing Country
billcountrycode	text	Billing Country Code
billingschedule	select	Billing Schedule
billphone	text	Billing Phone
billstate	select	Billing State/Province
billzipcode	text	Billing Zip
calculatedenddate	date	Calculated End Date
calculatedenddatebaseline	date	Calculated End Date Baseline
category	select	Category
city	text	City
comments	text	Comments
companyname	text	Job Name
contact	text	Primary Contact
country	select	Country
countrycode	text	Country Code
customer	select	Customer
datecreated	datetime	Date Created
email	email	Email
enddate	date	Actual End Date
entityid	text	Name
entitynumber	integer	Number
entitystatus	select	Status
estimatedcost	currency	Estimated Cost
estimatedgrossprofit	currency	Estimated Gross Profit
estimatedgrossprofitpercent	percent	Estimated Gross Profit %
estimatedlaborcost	currency	Estimated Labor Cost
estimatedlaborcostbaseline	currency	Estimated Labor Cost Baseline
estimatedlaborrevenue	currency	Estimated Labor Revenue
estimatedrevenue	currency	Estimated Revenue
estimatedtime	float	Initial Time Budget
estimatedtimeoverride	float	Estimated Work
estimatedtimeoverridebaseline	float	Estimated Work Baseline
externalid	select	External ID
fax	text	Fax
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)
globalsubscriptionstatus	select	Global Subscription Status
image	select	Image
includecrmtasksintotals	checkbox	Include CRM Tasks in Job Totals
internalid	select	Internal ID
isdefaultbilling	checkbox	Default Billing Address
isdefaultshipping	checkbox	Default Shipping Address
isexempttime	checkbox	Classify Time as Exempt
isinactive	checkbox	Inactive
isproductivetime	checkbox	Classify Time as Productive
isutilizedtime	checkbox	Classify Time as Utilized
jobbillingtype	select	Billing Type
jobitem	select	Billing Item
jobprice	currency	Job Price
jobresource	select	Job Resource
jobresourcerole	select	Job Resource Role
jobtype	select	Job Type
language	select	Language
lastbaselinedate	date	Last Baseline Date
lastmodifieddate	datetime	Last Modified
lastviewed	datetime	Last Viewed
level	select	Level
limittimetoassignees	checkbox	Limit Time and Expenses to Resources
materializetime	checkbox	Create Planned Time Entries
percentcomplete	percent	Percent Complete
percenttimecomplete	percent	Percent Time Complete
permission	select	Permission
phone	phone	Phone
phoneticname	text	Phonetic Name
projectedenddate	date	Projected End Date
projectedenddatebaseline	date	Projected End Date Baseline
representingsubsidiary	select	Represents Subsidiary
shipaddress1	text	Shipping Address 1
shipaddress2	text	Shipping Address 2
shipaddress3	text	Shipping Address 3
shipaddressee	text	Shipping Addressee
shipattention	text	Shipping Attention
shipcity	text	Shipping City
shipcountry	select	Shipping Country
shipcountrycode	text	Shipping Country Code
shipphone	text	Shipping Phone
shipstate	text	Shipping State/Province
shipzip	text	Shipping Zip
startdate	date	Start Date
startdatebaseline	date	Start Date Baseline
state	select	State/Province
statedisplayname	select	State/Province Display Name
subscription	select	Subscription
subscriptiondate	datetime	Subscription Date
subscriptionstatus	checkbox	Subscription Status
subsidiary	select	Subsidiary
subsidiarynohierarchy	select	Subsidiary (no hierarchy)
timeremaining	float	Remaining Work
type	select	Type
zipcode	text	Zip Code