job
The job table.
Columns
| Name | Type | References | Description |
| id [KEY] | Integer | Internal ID | |
| accountnumber | String | Account | |
| actualtime | Double | Actual Work | |
| allowallresourcesfortasks | Boolean | Display All Resources for Project Task Assignment | |
| allowexpenses | Boolean | Allow Expenses | |
| allowtime | Boolean | Allow Time Entry | |
| alternatecontact | String | Alt. Contact | |
| altname | String | Project | |
| billingschedule | String | Billing Schedule | |
| calculatedenddate | Date | Calculated End Date | |
| calculatedenddatebaseline | Date | Calculated End Date Baseline | |
| category | String | Category | |
| comments | String | Comments | |
| companyname | String | Job Name | |
| contact | String | Primary Contact | |
| contactlist | String | Contacts | |
| currency | String | Currency | |
| currencyprecision | Integer | Currency Precision | |
| customer | String | Customer | |
| datecreated | Date | Date Created | |
| defaultbillingaddress | String | Default Billing Address | |
| defaultshippingaddress | String | Default Shipping Address | |
| enddate | Date | Actual End Date | |
| entityid | String | Entity ID | |
| entitynumber | Integer | Number | |
| entitystatus | String | Status | |
| entitytitle | String | Project ID | |
| estimatedcost | Decimal | Estimated Cost | |
| estimatedgrossprofit | Decimal | Estimated Gross Profit | |
| estimatedgrossprofitpercent | Double | Estimated Gross Profit Percent | |
| estimatedlaborcost | Decimal | Estimated Labor Cost | |
| estimatedlaborcostbaseline | Decimal | Estimated Labor Cost Baseline | |
| estimatedlaborrevenue | Decimal | Estimated Labor Revenue | |
| estimatedrevenue | Decimal | Estimated Revenue | |
| estimatedtime | Double | Initial Time Budget | |
| estimatedtimeoverride | Double | Estimated Work | |
| estimatedtimeoverridebaseline | Double | Estimated Work Baseline | |
| externalid | String | External ID | |
| forecastchargerunondemand | Boolean | Forecast Charge Run on Demand | |
| fxrate | Decimal | Exchange Rate | |
| includecrmtasksintotals | Boolean | Include CRM Task In Job Totals | |
| isexempttime | Boolean | Classify Time as Exempt | |
| isinactive | Boolean | Inactive | |
| isproductivetime | Boolean | Classify Time as Productive | |
| isutilizedtime | Boolean | Classify Time as Utilized | |
| jobbillingtype | String | Billing Type | |
| jobitem | String | Billing Item | |
| jobprice | Decimal | Project Price | |
| jobtype | String | Job Type | |
| lastbaselinedate | Date | Last Baseline Date | |
| lastmodifieddate | Date | Last Modified Date | |
| limittimetoassignees | Boolean | Limit Time and Expenses To Resources | |
| materializetime | Boolean | Create Planned Time Entries | |
| parent | String | Parent Record | |
| percentcomplete | Double | Rev Rec Override Percent Complete | |
| percenttimecomplete | Double | Percent Work Complete | |
| primarycontact | String | Primary Contact | |
| projectedenddate | Date | Estimated End Date | |
| projectedenddatebaseline | Date | Estimated End Date Baseline | |
| projectmanager | String | Job Manager | |
| startdate | Date | Start Date | |
| startdatebaseline | Date | Start Date Baseline | |
| timeapproval | String | Time Approval | |
| timeremaining | Double | Remaining Work |