ProcessWorkOrdersOperationMaterialMaterialDFF
ProcessWorkOrdersOperationMaterialMaterialDFF
Columns
| Name | Type | SupportedFinders | Description |
| ProcessWorkOrdersWorkOrderId [KEY] | Long | Parent work order identifier (references the process work order). | |
| OperationWorkOrderOperationId [KEY] | Long | Parent operation identifier within the work order. | |
| MaterialWorkOrderOperationMaterialId [KEY] | Long | Identifier for the material record attached to the operation. | |
| WoOperationMaterialId [KEY] | Long | Local identifier for the operation material (legacy Wd table key). | |
| _FLEX_Context | String | Context identifier for flexible attributes (internal use). | |
| _FLEX_Context_DisplayValue | String | Display value for the flexible attribute context. | |
| BackToBackFlag | String | WorkOrderB2BCM, WorkOrderByComponent, WorkOrderByResource, WorkOrderBySerial | Flag indicating back-to-back supply status. |
| ContractMfgFlag | String | WorkOrderB2BCM, WorkOrderByComponent, WorkOrderByResource, WorkOrderBySerial | Flag indicating contract manufacturing status. |
| DueDays | Int | WorkOrderSearch, WorkOrdersCompletingToday, WorkOrdersDelayed, WorkOrdersOnHold, WorkOrdersOpDelayed, WorkOrdersStartingToday, WorkOrdersWithException | Number of days until the material is due. |
| Finder | String | Internal finder field used by the system; not a business data field. | |
| FirmPlannedFlag | String | WorkOrderByComponent, WorkOrderByModifiedDate, WorkOrderByResource, WorkOrderBySerial | Flag indicating if the material is firm planned. |
| InventoryItemId | Long | WorkOrderB2BCM, WorkOrderByModifiedDate, WorkOrderByWorkAreaWorkCenter | Identifier of the inventory item associated with this material. |
| ItemNumber | String | WorkOrderB2BCM | Item number for the material. |
| LastUpdateDate | Datetime | WorkOrderByModifiedDate | Date and time when the material record was last updated. |
| MaterialItemId | Long | WorkOrderByComponent | Identifier for the material item. |
| OrganizationId | Long | WorkOrderSearch, WorkOrdersCompletingToday, WorkOrdersDelayed, WorkOrdersOnHold, WorkOrdersOpDelayed, WorkOrdersStartingToday, WorkOrdersWithException, WorkOrderB2BCM, WorkOrderByComponent, WorkOrderByModifiedDate, WorkOrderByResource, WorkOrderBySerial, WorkOrderBySerialNumber, WorkOrderByWorkAreaWorkCenter, WorkOrderByWorkOrderNumber | Identifier for the organization associated with the work order. |
| PlannedCompletionDate | Datetime | WorkOrderB2BCM, WorkOrderByComponent, WorkOrderByResource, WorkOrderBySerial, WorkOrderByWorkAreaWorkCenter | Planned completion date for the work order. |
| PlannedStartDate | Datetime | WorkOrderB2BCM, WorkOrderByComponent, WorkOrderByResource, WorkOrderBySerial, WorkOrderByWorkAreaWorkCenter | Planned start date for the work order. |
| ProductSerialId | Long | WorkOrderBySerial | Identifier for the product serial number. |
| ResourceId | Long | WorkOrderByResource, WorkOrderBySerial | Identifier for the resource associated with the work order. |
| SerialNumber | String | WorkOrderBySerialNumber | Serial number of the work order. |
| SourceHeaderReferenceId | Long | WorkOrderByWorkAreaWorkCenter | Reference ID for the source header. |
| SourceHeaderRefId | Long | WorkOrderB2BCM, WorkOrderByComponent, WorkOrderByModifiedDate, WorkOrderByResource, WorkOrderBySerial | Reference ID for the source header (alternate). |
| SourceLineReferenceId | Long | WorkOrderByWorkAreaWorkCenter | Reference ID for the source line. |
| SourceLineRefId | Long | WorkOrderB2BCM, WorkOrderByComponent, WorkOrderByModifiedDate, WorkOrderByResource, WorkOrderBySerial | Reference ID for the source line (alternate). |
| SourceSystemId | Long | WorkOrderB2BCM, WorkOrderByComponent, WorkOrderByModifiedDate, WorkOrderByResource, WorkOrderBySerial, WorkOrderByWorkAreaWorkCenter | Identifier for the source system. |
| Tolerance | Int | WorkOrderAndWorkAreaCenter, WorkOrderSearch, WorkOrdersCompletingToday, WorkOrdersDelayed, WorkOrdersOnHold, WorkOrdersOpDelayed, WorkOrdersStartingToday, WorkOrdersWithException | Tolerance level for the work order. |
| WoProjectNumber | String | FindByProjectNumberTaskNumber | Project number associated with the work order. |
| WorkAreaId | Long | WorkOrderAndWorkAreaCenter, WorkOrderSearch, WorkOrdersCompletingToday, WorkOrdersDelayed, WorkOrdersOnHold, WorkOrdersOpDelayed, WorkOrdersStartingToday, WorkOrdersWithException, WorkOrderByWorkAreaWorkCenter | Identifier for the work area associated with the work order. |
| WorkCenterId | Long | WorkOrderAndWorkAreaCenter, WorkOrderSearch, WorkOrdersCompletingToday, WorkOrdersDelayed, WorkOrdersOnHold, WorkOrdersOpDelayed, WorkOrdersStartingToday, WorkOrdersWithException, WorkOrderByWorkAreaWorkCenter | Identifier for the work center associated with the work order. |
| WorkOrderId | Long | PrimaryKey, WorkOrderAndWorkAreaCenter, WorkOrderB2BCM | Unique identifier for the work order. |
| WorkOrderNumber | String | WorkOrderSearch, WorkOrdersCompletingToday, WorkOrdersDelayed, WorkOrdersOnHold, WorkOrdersOpDelayed, WorkOrdersStartingToday, WorkOrdersWithException, WorkOrderByWorkOrderNumber | Work order number for external reference. |
| WorkOrderStatusId | Long | WorkOrderB2BCM, WorkOrderByComponent, WorkOrderByModifiedDate, WorkOrderByResource, WorkOrderBySerial, WorkOrderByWorkAreaWorkCenter | Identifier for the work order status. |
| WoTaskNumber | String | FindByProjectNumberTaskNumber | Task number associated with the work order. |