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. |