workorderclose
Stores information about closed work orders, including completion details and final statuses.
Columns
| Name | Type | References | Description |
| class | String | Represents the financial classification of the work order closure, typically used for tracking costs and reporting. | |
| createddate | Datetime | The timestamp when this work order closure record was created in the system. | |
| customform | String | The internal identifier for the custom form used when entering the work order closure. | |
| department | String | The department associated with this work order closure, used for categorization and financial tracking. | |
| externalid | String | A user-defined unique identifier for this work order closure, often used for integrations with external systems. | |
| item | String | The item associated with this work order closure, representing the finished good or component being processed. | |
| lastmodifieddate | Datetime | The timestamp of the most recent modification to this work order closure record. | |
| location | String | The physical or logical location where the work order closure is being recorded, such as a warehouse or production site. | |
| manufacturingrouting | Integer | The unique identifier for the manufacturing routing that defines the sequence of operations required to complete the work order. | |
| memo | String | A free-text field for additional notes or comments related to this work order closure. | |
| orderquantity | Double | The total quantity of items initially planned for production in this work order. | |
| postingperiod | String | The accounting period in which this work order closure transaction is recorded. | |
| quantity | String | The actual quantity of items being closed in this work order, which can differ from the order quantity. | |
| revision | String | The specific product revision or version associated with this work order closure, typically used in engineering and manufacturing processes. | |
| revisionmemo | String | Additional notes or comments related to the product revision used in this work order closure. | |
| scrapquantity | Double | The quantity of items scrapped during the work order process due to defects, waste, or inefficiencies. | |
| subsidiary | String | The subsidiary or business entity associated with this work order closure, relevant in multi-entity organizations. | |
| taxperiod | String | The tax reporting period in which this work order closure is recorded for compliance and reporting purposes. | |
| total | Decimal | The total cost or value associated with this work order closure transaction, including labor, materials, and overhead. | |
| trandate | Date | The transaction date when this work order closure was officially recorded in the system. | |
| tranid | String | The unique transaction identifier assigned to this work order closure, used for tracking and referencing. |