job
Stores information about jobs, including their status, related entities, and project details.
Columns
| Name | Type | References | Description |
| id [KEY] | Integer | Unique internal identifier for the job record. | |
| accountnumber | String | Account associated with the job, typically a customer or company. | |
| actualtime | Double | Total actual work hours recorded for the job. | |
| allowallresourcesfortasks | Boolean | Indicates whether all resources can be assigned to project tasks. | |
| allowexpenses | Boolean | Specifies whether expense tracking is enabled for the job. | |
| allowtime | Boolean | Specifies whether time tracking is allowed for this job. | |
| alternatecontact | String | Secondary contact person associated with the job. | |
| altname | String | Project name or alternative name for the job. | |
| billingschedule | String | Defines the billing schedule used for invoicing this job. | |
| calculatedenddate | Date | System-calculated expected completion date for the job. | |
| calculatedenddatebaseline | Date | Baseline value for the system-calculated completion date. | |
| category | String | Category or classification assigned to the job. | |
| comments | String | Additional notes or remarks related to the job. | |
| companyname | String | Name of the company or entity associated with the job. | |
| contact | String | Primary contact person for the job. | |
| contactlist | String | List of contacts associated with this job. | |
| currency | String | Currency in which financials for the job are tracked. | |
| currencyprecision | Integer | Number of decimal places used for currency values in this job. | |
| customer | String | Customer linked to the job. | |
| datecreated | Date | Date when the job record was created. | |
| defaultbillingaddress | String | Primary billing address associated with the job. | |
| defaultshippingaddress | String | Primary shipping address associated with the job. | |
| enddate | Date | Actual date the job was completed. | |
| entityid | String | Unique identifier for the job within the system. | |
| entitynumber | Integer | System-generated number for the job record. | |
| entitystatus | String | Current status of the job, such as 'In Progress' or 'Completed'. | |
| entitytitle | String | Project identifier or reference name for the job. | |
| estimatedcost | Decimal | Projected total cost required to complete the job. | |
| estimatedgrossprofit | Decimal | Estimated gross profit expected from the job. | |
| estimatedgrossprofitpercent | Double | Percentage of estimated gross profit relative to revenue. | |
| estimatedlaborcost | Decimal | Expected labor cost for completing the job. | |
| estimatedlaborcostbaseline | Decimal | Baseline estimate of labor costs for the job. | |
| estimatedlaborrevenue | Decimal | Projected revenue generated from labor costs. | |
| estimatedrevenue | Decimal | Expected total revenue from the job. | |
| estimatedtime | Double | Initial estimated hours required for the job. | |
| estimatedtimeoverride | Double | Updated estimated work hours based on adjustments. | |
| estimatedtimeoverridebaseline | Double | Baseline value for adjusted estimated work hours. | |
| externalid | String | Unique identifier for external integrations or references. | |
| forecastchargerunondemand | Boolean | Specifies whether forecast charges can be run on demand. | |
| fxrate | Decimal | Exchange rate applicable to currency values in this job. | |
| includecrmtasksintotals | Boolean | Indicates whether CRM task values should be included in job totals. | |
| isexempttime | Boolean | Marks time entries for this job as exempt from standard tracking. | |
| isinactive | Boolean | Indicates whether the job record is inactive. | |
| isproductivetime | Boolean | Marks recorded time as productive work hours. | |
| isutilizedtime | Boolean | Classifies tracked time as utilized work hours. | |
| jobbillingtype | String | Defines how the job is billed, such as 'Fixed Price' or 'Time & Materials'. | |
| jobitem | String | Item or service linked to job billing. | |
| jobprice | Decimal | Price assigned to the job, typically for billing purposes. | |
| jobtype | String | Classification of the job, such as 'Internal' or 'External'. | |
| lastbaselinedate | Date | Date when the last baseline for this job was set. | |
| lastmodifieddate | Date | Last recorded modification date of the job record. | |
| limittimetoassignees | Boolean | Restricts time and expense tracking to assigned resources only. | |
| materializetime | Boolean | Enables automatic creation of planned time entries. | |
| parent | String | Parent record to which this job is linked, if applicable. | |
| percentcomplete | Double | Percentage of revenue recognition override completion. | |
| percenttimecomplete | Double | Percentage of work completed based on recorded time. | |
| primarycontact | String | Main point of contact for the job. | |
| projectedenddate | Date | Estimated completion date based on current progress. | |
| projectedenddatebaseline | Date | Baseline projected end date for tracking deviations. | |
| projectmanager | String | Person responsible for managing the job. | |
| startdate | Date | Official start date of the job. | |
| startdatebaseline | Date | Baseline start date recorded for tracking changes. | |
| timeapproval | String | Approval process required for time entries related to this job. | |
| timeremaining | Double | Estimated remaining work hours needed to complete the job. |