workorder
Represents work orders issued for production or maintenance processes, tracking materials and labor usage.
Columns
| Name | Type | References | Description |
| actualproductionenddate | Date | The actual date when the production process for this work order was completed. | |
| actualproductionstartdate | Date | The actual date when the production process for this work order began. | |
| assemblyitem | String | The assembly item associated with this work order, specifying the finished product being manufactured. | |
| autocalculatelag | Boolean | Indicates whether the system should automatically calculate lag time between dependent work order operations. | |
| billofmaterials | String | The Bill of Materials (BOM) that defines the list of raw materials, components, and sub-assemblies required for production. | |
| billofmaterialsrevision | String | The specific revision of the BOM used in this work order, reflecting changes in materials or processes. | |
| class | String | The classification category assigned to this work order for tracking and reporting purposes. | |
| createddate | Datetime | The date and time when this work order was initially created in the system. | |
| createdfrom | String | The originating transaction or record that this work order was created from, such as a sales order or another work order. | |
| currency | String | The currency in which this work order's costs and transactions are recorded. | |
| customform | String | The custom form template used to enter and display data for this work order. | |
| department | String | The department responsible for executing or managing this work order, useful for financial tracking and reporting. | |
| enddate | Date | The scheduled or planned completion date for this work order. | |
| entity | String | The entity, such as a customer or vendor, associated with this work order. | |
| entitynexus | String | The tax nexus linked to the entity for tax compliance and jurisdictional reporting. | |
| exchangerate | String | The exchange rate applied if this work order involves a foreign currency. | |
| expandassembly | Boolean | Indicates whether the assembly item components should be expanded and displayed in detail. | |
| externalid | String | A unique identifier for this work order from an external system or integration. | |
| firmed | Boolean | Indicates whether this work order is firmed, meaning that it is locked from automatic rescheduling. | |
| job | String | The job or project associated with this work order, used for job costing and tracking. | |
| lastmodifieddate | Datetime | The date and time when this work order was last modified. | |
| location | String | The physical or virtual location where this work order's production or assembly takes place. | |
| memo | String | A free-text field for entering additional notes or comments regarding this work order. | |
| nexus | String | The tax jurisdiction that applies to this work order for compliance purposes. | |
| orderstatus | String | The current status of this work order, such as pending, in progress, or completed. | |
| quantity | String | The number of units to be produced or processed under this work order. | |
| requesteddate | Date | The date requested for this work order to be completed. | |
| revision | String | The version or revision of the work order, typically used for tracking changes over time. | |
| revisionmemo | String | A note explaining changes made in a specific revision of this work order. | |
| salesgroup | String | The sales group responsible for the transaction that led to this work order, if applicable. | |
| salesrep | String | The sales representative associated with this work order, typically from the originating transaction. | |
| schedulingmethod | String | The method used to schedule this work order, such as forward scheduling or backward scheduling. | |
| source | String | The source of this work order, indicating whether it was created manually, from a sales order, or another transaction. | |
| startdate | Date | The planned or scheduled start date for this work order. | |
| status | String | The current processing status of this work order, such as open, closed, or in production. | |
| statusRef | String | A reference code for the status of this work order, often used internally for system processing. | |
| subsidiary | String | The subsidiary within the organization that owns and manages this work order. | |
| syncpartnerteams | Boolean | Indicates whether partner teams should be synchronized with this work order for collaboration. | |
| syncsalesteams | Boolean | Indicates whether sales teams should be synchronized with this work order for reporting and tracking. | |
| trandate | Date | The transaction date recorded for this work order, often used for financial and reporting purposes. | |
| tranid | String | The unique transaction ID assigned to this work order by the system. | |
| units | String | The unit of measure applicable to the quantity specified in this work order. |