ProcessWorkOrdersProcessWorkOrderDFF
Manages detailed and customizable descriptive flexfields associated with process work orders, allowing tailored data tracking.
Columns
| Name | Type | SupportedFinders | Description |
| ProcessWorkOrdersWorkOrderId [KEY] | Long | The unique identifier linking the process work order with its descriptive flexfield (DFF) attributes. | |
| WorkOrderId [KEY] | Long | PrimaryKey, WorkOrderAndWorkAreaCenter, WorkOrderB2BCM | 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 | WorkOrderByComponent, WorkOrderBySerial, WorkOrderByResource, WorkOrderB2BCM | Indicates whether the work order is part of a back-to-back manufacturing process, directly connecting supply and demand. |
| ContractMfgFlag | String | WorkOrderB2BCM, WorkOrderByComponent, WorkOrderByResource, WorkOrderBySerial | Indicates whether the work order involves contract manufacturing, where production is outsourced to a third-party manufacturer. |
| DueDays | Int | WorkOrdersWithException, WorkOrdersStartingToday, WorkOrdersOnHold, WorkOrdersCompletingToday, WorkOrderSearch, WorkOrdersOpDelayed, WorkOrdersDelayed | 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 | WorkOrderByComponent, WorkOrderBySerial, WorkOrderByResource, WorkOrderByModifiedDate | Indicates whether the work order is firm planned, meaning it is locked from changes by scheduling or planning processes. |
| InventoryItemId | Long | WorkOrderB2BCM, WorkOrderByWorkAreaWorkCenter, WorkOrderByModifiedDate | The unique identifier for the inventory item associated with the work order, used to track materials or finished goods. |
| ItemNumber | String | WorkOrderB2BCM | The unique number assigned to the inventory item associated with the work order. |
| LastUpdateDate | Datetime | WorkOrderByModifiedDate | The date and time when the descriptive flexfield or its attributes were last updated. |
| MaterialItemId | Long | WorkOrderByComponent | The unique identifier for the material item used in the work order, typically representing raw materials or components. |
| OrganizationId | Long | WorkOrderByModifiedDate, WorkOrderByResource, WorkOrderByComponent, WorkOrdersStartingToday, WorkOrderB2BCM, WorkOrderBySerial, WorkOrdersDelayed, WorkOrdersCompletingToday, WorkOrderByWorkAreaWorkCenter, WorkOrderBySerialNumber, WorkOrdersOnHold, WorkOrderSearch, WorkOrdersOpDelayed, WorkOrdersWithException | The unique identifier for the organization where the work order is executed, representing a specific facility or inventory location. |
| PlannedCompletionDate | Datetime | WorkOrderByResource, WorkOrderB2BCM, WorkOrderByWorkAreaWorkCenter, WorkOrderByComponent, WorkOrderBySerial | The planned date and time for the work order's completion, as determined by the scheduling application. |
| PlannedStartDate | Datetime | WorkOrderByResource, WorkOrderBySerial, WorkOrderByComponent, WorkOrderByWorkAreaWorkCenter, WorkOrderB2BCM | The planned date and time for the work order's start, as determined by the scheduling application. |
| ProductSerialId | Long | WorkOrderBySerial | The unique identifier for the product serial number associated with the work order, enabling serialized tracking of finished goods or components. |
| ResourceId | Long | WorkOrderByResource, WorkOrderBySerial | The unique identifier for the resource (for example, equipment or personnel) associated with the work order. |
| SerialNumber | String | WorkOrderBySerialNumber | The serial number assigned to the product or component being tracked in the work order. |
| SourceHeaderReferenceId | Long | WorkOrderByWorkAreaWorkCenter | The unique identifier for the source header that links the work order to its originating transaction or external system. |
| SourceHeaderRefId | Long | WorkOrderByModifiedDate, WorkOrderByResource, WorkOrderBySerial, WorkOrderB2BCM, WorkOrderByComponent | Alternate unique identifier for the source header reference associated with the work order. |
| SourceLineReferenceId | Long | WorkOrderByWorkAreaWorkCenter | The unique identifier for the source line that links the work order to a specific line item in the source document. |
| SourceLineRefId | Long | WorkOrderBySerial, WorkOrderByModifiedDate, WorkOrderByComponent, WorkOrderB2BCM, WorkOrderByResource | Alternate unique identifier for the source line reference associated with the work order. |
| SourceSystemId | Long | WorkOrderByWorkAreaWorkCenter, WorkOrderBySerial, WorkOrderByComponent, WorkOrderByResource, WorkOrderByModifiedDate, WorkOrderB2BCM | The unique identifier for the source system from which the work order or related data originates. |
| Tolerance | Int | WorkOrderAndWorkAreaCenter, WorkOrdersWithException, WorkOrdersOpDelayed, WorkOrdersOnHold, WorkOrdersDelayed, WorkOrderSearch, WorkOrdersCompletingToday, WorkOrdersStartingToday | The allowable tolerance level for the work order, such as variances in material quantities or production time. |
| WoProjectNumber | String | FindByProjectNumberTaskNumber | The project number associated with the work order, used for project-specific tracking and reporting. |
| WorkAreaId | Long | WorkOrderAndWorkAreaCenter, WorkOrderByWorkAreaWorkCenter, WorkOrdersWithException, WorkOrdersCompletingToday, WorkOrdersOpDelayed, WorkOrderSearch, WorkOrdersOnHold, WorkOrdersStartingToday, WorkOrdersDelayed | The unique identifier for the work area where the work order is executed. Work areas group resources within the manufacturing facility. |
| WorkCenterId | Long | WorkOrderByWorkAreaWorkCenter, WorkOrderAndWorkAreaCenter, WorkOrdersCompletingToday, WorkOrdersDelayed, WorkOrdersStartingToday, WorkOrdersOpDelayed, WorkOrdersOnHold, WorkOrderSearch, WorkOrdersWithException | The unique identifier for the work center where work order operations occur. This identifier tracks the specific area or equipment used. |
| WorkOrderNumber | String | WorkOrdersCompletingToday, WorkOrderSearch, WorkOrdersDelayed, WorkOrdersOpDelayed, WorkOrdersWithException, WorkOrdersStartingToday, WorkOrdersOnHold | The unique number assigned to the work order. This number helps identify and track the work order within the organization. |
| WorkOrderStatusId | Long | WorkOrderByWorkAreaWorkCenter, WorkOrderB2BCM, WorkOrderBySerial, WorkOrderByResource, WorkOrderByComponent, WorkOrderByModifiedDate | The unique identifier for the status of the work order. Statuses indicate whether the work order is open, in progress, or completed. |
| WoTaskNumber | String | FindByProjectNumberTaskNumber | The task number associated with the work order, used to track specific tasks within the broader work order. |