ProcessWorkOrdersOperationMaterial
ProcessWorkOrdersOperationMaterial
Columns
| Name | Type | SupportedFinders | Description |
| ProcessWorkOrdersWorkOrderId [KEY] | Long | The work order ID from process work orders | |
| OperationWorkOrderOperationId [KEY] | Long | The operation ID for the work order operation | |
| OrganizationId | Long | WorkOrderSearch, WorkOrdersCompletingToday, WorkOrdersDelayed, WorkOrdersOnHold, WorkOrdersOpDelayed, WorkOrdersStartingToday, WorkOrdersWithException, WorkOrderB2BCM, WorkOrderByComponent, WorkOrderByModifiedDate, WorkOrderByResource, WorkOrderBySerial, WorkOrderBySerialNumber, WorkOrderByWorkAreaWorkCenter, WorkOrderByWorkOrderNumber | The organization identifier |
| WorkOrderId | Long | PrimaryKey, WorkOrderAndWorkAreaCenter, WorkOrderB2BCM | The work order identifier |
| WorkOrderOperationId | Long | The operation ID within the work order | |
| OperationSequenceNumber | Decimal | The sequence number of the operation | |
| OperationName | String | The name of the operation | |
| StandardOperationId | Long | The standard operation identifier | |
| StandardOperationCode | String | The standard operation code | |
| WorkAreaId | Long | WorkOrderAndWorkAreaCenter, WorkOrderSearch, WorkOrdersCompletingToday, WorkOrdersDelayed, WorkOrdersOnHold, WorkOrdersOpDelayed, WorkOrdersStartingToday, WorkOrdersWithException, WorkOrderByWorkAreaWorkCenter | The work area identifier |
| WorkAreaName | String | The name of the work area | |
| WorkCenterId | Long | WorkOrderAndWorkAreaCenter, WorkOrderSearch, WorkOrdersCompletingToday, WorkOrdersDelayed, WorkOrdersOnHold, WorkOrdersOpDelayed, WorkOrdersStartingToday, WorkOrdersWithException, WorkOrderByWorkAreaWorkCenter | Identifier of the work center. |
| WorkCenterName | String | Name of the work center. | |
| WorkOrderOperationMaterialId [KEY] | Long | Unique identifier for the work order operation material record. | |
| MaterialSequenceNumber | Decimal | Sequence number of the material within the operation. | |
| MaterialType | String | Type or category of the material. | |
| InventoryItemId | Long | WorkOrderB2BCM, WorkOrderByModifiedDate, WorkOrderByWorkAreaWorkCenter | Identifier of the inventory item. |
| ItemNumber | String | WorkOrderB2BCM | Item number or part number. |
| ItemDescription | String | Description of the item. | |
| ItemRevision | String | Revision or version of the item. | |
| BasisType | String | Basis type used for material calculations. | |
| Quantity | Decimal | Requested quantity for this material. | |
| UOMCode | String | Unit of measure code for quantity. | |
| UnitOfMeasure | String | Full name of the unit of measure. | |
| RequiredDate | Datetime | Date/time when the material is required. | |
| YieldFactor | Decimal | Factor used to calculate the yield of the operation. | |
| IncludeInPlanningFlag | Bool | Indicates if the material is included in planning. | |
| SupplyType | String | Type of supply for the material. | |
| SupplyTypeDescription | String | Description of the supply type. | |
| SupplySubinventory | String | Subinventory location for supply. | |
| SupplyLocatorId | Long | Identifier of the supply locator. | |
| SupplyLocator | String | Location of the supply within the locator. | |
| ReservedQuantity | Decimal | Quantity of material reserved for this operation. | |
| IssuedQuantity | Decimal | Quantity of material issued for this operation. | |
| ProducedQuantity | Decimal | Quantity of material produced by this operation. | |
| AllocatedQuantity | Decimal | Quantity of material allocated for this operation. | |
| PickedQuantity | Decimal | Quantity of material picked for this operation. | |
| RemainingAllocatedQuantity | Decimal | Remaining allocated quantity for this operation. | |
| CreatedBy | String | User who created the record. | |
| CreationDate | Datetime | Date and time when the record was created. | |
| LastUpdateDate | Datetime | WorkOrderByModifiedDate | Date and time when the record was last updated. |
| LastUpdatedBy | String | User who last updated the record. | |
| SecondaryQuantity | Decimal | Secondary quantity for the material. | |
| SecondaryUOMCode | String | Unit of measure code for secondary quantity. | |
| SubstituteFlag | Bool | Indicates if the material can be substituted. | |
| AutoTransactFlag | Bool | Indicates if the transaction is automated. | |
| CountPointOperationFlag | Bool | Indicates if this is a count point operation. | |
| EnforceIntRequirements | String | Enforce integer requirements for the operation. | |
| ExtendedQuantity | Decimal | Extended quantity for the operation. | |
| EnforceIntegerRequirementsMeaning | String | Meaning of the enforce integer requirements. | |
| ContributeToYieldFlag | Bool | Indicates if the material contributes to yield. | |
| WdOperationMaterialId | Long | Identifier for the work order operation material in the Wd table. | |
| BackToBackFlag | String | WorkOrderB2BCM, WorkOrderByComponent, WorkOrderByResource, WorkOrderBySerial | Back-to-back flag attribute for the process work orders operation material. |
| ContractMfgFlag | String | WorkOrderB2BCM, WorkOrderByComponent, WorkOrderByResource, WorkOrderBySerial | Flag indicating contract manufacturing status (e.g., 'Y' or 'N'). |
| DueDays | Int | WorkOrderSearch, WorkOrdersCompletingToday, WorkOrdersDelayed, WorkOrdersOnHold, WorkOrdersOpDelayed, WorkOrdersStartingToday, WorkOrdersWithException | Number of days until the material is due. |
| MaterialItemId | Long | WorkOrderByComponent | Identifier of the material item. |
| PlannedCompletionDate | Datetime | WorkOrderB2BCM, WorkOrderByComponent, WorkOrderByResource, WorkOrderBySerial, WorkOrderByWorkAreaWorkCenter | Planned completion date for the work order operation (UTC). |
| PlannedStartDate | Datetime | WorkOrderB2BCM, WorkOrderByComponent, WorkOrderByResource, WorkOrderBySerial, WorkOrderByWorkAreaWorkCenter | Planned start date for the work order operation (UTC). |
| ProductSerialId | Long | WorkOrderBySerial | Identifier of the product serial number associated with the work order item. |
| ResourceId | Long | WorkOrderByResource, WorkOrderBySerial | Identifier of the resource assigned to this operation. |
| SerialNumber | String | WorkOrderBySerialNumber | Serial number for the work order item, if applicable. |
| SourceHeaderReferenceId | Long | WorkOrderByWorkAreaWorkCenter | Reference ID linking to the source header record for this material. |
| SourceHeaderRefId | Long | WorkOrderB2BCM, WorkOrderByComponent, WorkOrderByModifiedDate, WorkOrderByResource, WorkOrderBySerial | Alternate reference ID for the source header record. |
| SourceLineReferenceId | Long | WorkOrderByWorkAreaWorkCenter | Reference ID linking to the source line record for this material. |
| SourceLineRefId | Long | WorkOrderB2BCM, WorkOrderByComponent, WorkOrderByModifiedDate, WorkOrderByResource, WorkOrderBySerial | Alternate reference ID for the source line record. |
| SourceSystemId | Long | WorkOrderB2BCM, WorkOrderByComponent, WorkOrderByModifiedDate, WorkOrderByResource, WorkOrderBySerial, WorkOrderByWorkAreaWorkCenter | Identifier of the originating source system for this record. |
| Tolerance | Int | WorkOrderAndWorkAreaCenter, WorkOrderSearch, WorkOrdersCompletingToday, WorkOrdersDelayed, WorkOrdersOnHold, WorkOrdersOpDelayed, WorkOrdersStartingToday, WorkOrdersWithException | Allowed tolerance value for the operation (units defined by context). |
| WoProjectNumber | String | FindByProjectNumberTaskNumber | Project number associated with the work order. |
| WorkOrderNumber | String | WorkOrderSearch, WorkOrdersCompletingToday, WorkOrdersDelayed, WorkOrdersOnHold, WorkOrdersOpDelayed, WorkOrdersStartingToday, WorkOrdersWithException, WorkOrderByWorkOrderNumber | External work order number for reference. |
| WorkOrderStatusId | Long | WorkOrderB2BCM, WorkOrderByComponent, WorkOrderByModifiedDate, WorkOrderByResource, WorkOrderBySerial, WorkOrderByWorkAreaWorkCenter | Identifier representing the work order status. |
| WoTaskNumber | String | FindByProjectNumberTaskNumber | Task number within the work order project. |