ProcessWorkOrdersProcessWorkOrderDFF
Manages detailed and customizable descriptive flexfields associated with process work orders, allowing tailored data tracking.
Columns
| Name | Type | Description |
| ProcessWorkOrdersWorkOrderId [KEY] | Long | The unique identifier linking the process work order with its descriptive flexfield (DFF) attributes. |
| WorkOrderId [KEY] | Long | The unique identifier for the work order. This value is a primary key generated by the application when the work order is created. |
| _FLEX_Context | String | The name of the descriptive flexfield (DFF) context for work orders, used to group related flexfield segments. |
| _FLEX_Context_DisplayValue | String | The display value or label for the flexfield context segment associated with the work order. |
| BackToBackFlag | String | Indicates whether the work order is part of a back-to-back manufacturing process, directly connecting supply and demand. |
| ContractMfgFlag | String | Indicates whether the work order involves contract manufacturing, where production is outsourced to a third-party manufacturer. |
| DueDays | Int | The number of days remaining until the work order is due for completion. |
| Finder | String | Represents the search mechanism or criteria used to locate and identify the work order within the system. |
| FirmPlannedFlag | String | Indicates whether the work order is firm planned, meaning it is locked from changes by scheduling or planning processes. |
| InventoryItemId | Long | The unique identifier for the inventory item associated with the work order, used to track materials or finished goods. |
| ItemNumber | String | The unique number assigned to the inventory item associated with the work order. |
| LastUpdateDate | Datetime | The date and time when the descriptive flexfield or its attributes were last updated. |
| MaterialItemId | Long | The unique identifier for the material item used in the work order, typically representing raw materials or components. |
| OrganizationId | Long | The unique identifier for the organization where the work order is executed, representing a specific facility or inventory location. |
| PlannedCompletionDate | Datetime | The planned date and time for the work order's completion, as determined by the scheduling application. |
| PlannedStartDate | Datetime | The planned date and time for the work order's start, as determined by the scheduling application. |
| ProductSerialId | Long | The unique identifier for the product serial number associated with the work order, enabling serialized tracking of finished goods or components. |
| ResourceId | Long | The unique identifier for the resource (for example, equipment or personnel) associated with the work order. |
| SerialNumber | String | The serial number assigned to the product or component being tracked in the work order. |
| SourceHeaderReferenceId | Long | The unique identifier for the source header that links the work order to its originating transaction or external system. |
| SourceHeaderRefId | Long | Alternate unique identifier for the source header reference associated with the work order. |
| SourceLineReferenceId | Long | The unique identifier for the source line that links the work order to a specific line item in the source document. |
| SourceLineRefId | Long | Alternate unique identifier for the source line reference associated with the work order. |
| SourceSystemId | Long | The unique identifier for the source system from which the work order or related data originates. |
| Tolerance | Int | The allowable tolerance level for the work order, such as variances in material quantities or production time. |
| WoProjectNumber | String | The project number associated with the work order, used for project-specific tracking and reporting. |
| WorkAreaId | Long | The unique identifier for the work area where the work order is executed. Work areas group resources within the manufacturing facility. |
| WorkCenterId | Long | The unique identifier for the work center where work order operations occur. This identifier tracks the specific area or equipment used. |
| WorkOrderNumber | String | The unique number assigned to the work order. This number helps identify and track the work order within the organization. |
| WorkOrderStatusId | Long | The unique identifier for the status of the work order. Statuses indicate whether the work order is open, in progress, or completed. |
| WoTaskNumber | String | The task number associated with the work order, used to track specific tasks within the broader work order. |