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. | |
| allocatedtime | Double | Total work hours allocated to resources 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. | |
| allowtasktimeforrsrcalloc | Boolean | Indicates whether allocated resources can enter time against all tasks. | |
| 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. | |
| altphone | String | Alternate phone number for the job contact. | |
| applyprojectexpensetypetoall | Boolean | Indicates whether the project expense type applies to all time entries. | |
| averageprojectplanrecalculationduration | Double | Average duration taken to recalculate the project plan. | |
| baselinebudget | String | Baseline budget associated with the job. | |
| bbudgetusecalculatedvalues | Boolean | Indicates whether calculated values are used for all billing budgets. | |
| billingaccount | String | Account used for billing the job. | |
| billingratecard | String | Rate card that defines billing rates 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. | |
| calculatedstartdate | Date | System-calculated start date for the job. | |
| calculatedstartdatebaseline | Date | Baseline value for the system-calculated start date. | |
| calculatedwork | Double | System-calculated total work hours for the job. | |
| calculatedworkbaseline | Double | Baseline value for the system-calculated total work hours. | |
| category | String | Category or classification assigned to the job. | |
| cbudgetlaborbudgetfromalloc | Boolean | Indicates whether labor budgets are calculated from resource allocations. | |
| cbudgetusecalculatedvalues | Boolean | Indicates whether calculated values are used for all cost budgets. | |
| 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 | Datetime | 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. | |
| String | Email address associated with the job. | ||
| emailpreference | String | Preferred email format for job communications. | |
| 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. | |
| estimateatcompletionbudget | String | Estimate-at-completion (EAC) budget for the job. | |
| estimatedcost | Decimal | Projected total cost required to complete the job. | |
| estimatedcostjc | Decimal | Estimated total cost for the job in the job costing context. | |
| 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. | |
| estimatedrevenuejc | Decimal | Estimated total revenue for the job in the job costing context. | |
| 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. | |
| estimaterevrectemplate | String | Revenue recognition forecast template applied to the job estimate. | |
| externalid | String | Unique identifier for external integrations or references. | |
| fax | String | Fax number associated with the job. | |
| files | String | Files attached to the job record. | |
| forecastchargerunondemand | Boolean | Specifies whether forecast charges can be run on demand. | |
| fullname | String | Full display name of the job. | |
| fxrate | Decimal | Exchange rate applicable to currency values in this job. | |
| image | String | Image associated with the job record. | |
| 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 | Datetime | Last recorded modification date of the job record. | |
| lastprojectplanrecalculationdatetime | Datetime | Date and time of the last project plan recalculation. | |
| lastprojectplanrecalculationduration | Double | Duration of the last project plan recalculation. | |
| lastprojectplanrecalculationstatus | String | Status of the last project plan recalculation. | |
| lastprojectplanrecalculationtrigger | String | Event that triggered the last project plan recalculation. | |
| 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. | |
| percentcompletebyrsrcalloc | Double | Percentage of work complete based on allocated resource work. | |
| percenttimecomplete | Double | Percentage of work completed based on recorded time. | |
| phone | String | Primary phone number associated with the job. | |
| plannedrevenue | Decimal | Planned total revenue for the job. | |
| plannedwork | Double | Planned total work hours for the job. | |
| plannedworkbaseline | Double | Baseline value for the planned total work hours. | |
| primarycontact | String | Main point of contact for the job. | |
| projectcompletelybilled | Boolean | Indicates whether the project has been completely billed. | |
| projectedenddate | Date | Estimated completion date based on current progress. | |
| projectedenddatebaseline | Date | Baseline projected end date for tracking deviations. | |
| projectexpensetype | String | Expense type classification applied to the project. | |
| projectmanager | String | Person responsible for managing the job. | |
| recognizedrevenue | Decimal | Revenue recognized for the job. | |
| revenuearrangements | String | Revenue arrangements associated with the job. | |
| revrecforecastrule | String | Revenue recognition forecast rule applied to the job. | |
| scheduledenddate | Date | Scheduled completion date for the job. | |
| scheduledenddatebaseline | Date | Baseline value for the scheduled completion date. | |
| schedulingmethod | String | Method used to schedule the job. | |
| sourceserviceitemfromratecard | Boolean | Indicates whether service items for task assignments are sourced from the rate card. | |
| startdate | Date | Official start date of the job. | |
| startdatebaseline | Date | Baseline start date recorded for tracking changes. | |
| subsidiary | String | Subsidiary that owns the job. | |
| timeapproval | String | Approval process required for time entries related to this job. | |
| timeremaining | Double | Estimated remaining work hours needed to complete the job. | |
| totalrevenue | Decimal | Total revenue for the job. | |
| useallocatedtimeforforecast | Boolean | Indicates whether allocated time is used for forecasting. | |
| usepercentcompleteoverride | Boolean | Indicates whether the percent complete override is used for forecasting. | |
| wbs | String | Work breakdown structure associated with the job. |