ProcessWorkOrdersOperationMaterial
ProcessWorkOrdersOperationMaterial
Columns
| Name | Type | 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 | The organization identifier |
| WorkOrderId | Long | 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 | The work area identifier |
| WorkAreaName | String | The name of the work area |
| WorkCenterId | Long | 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 | Identifier of the inventory item. |
| ItemNumber | String | 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 | 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 | Back-to-back flag attribute for the process work orders operation material. |
| ContractMfgFlag | String | Flag indicating contract manufacturing status (e.g., 'Y' or 'N'). |
| DueDays | Int | Number of days until the material is due. |
| MaterialItemId | Long | Identifier of the material item. |
| PlannedCompletionDate | Datetime | Planned completion date for the work order operation (UTC). |
| PlannedStartDate | Datetime | Planned start date for the work order operation (UTC). |
| ProductSerialId | Long | Identifier of the product serial number associated with the work order item. |
| ResourceId | Long | Identifier of the resource assigned to this operation. |
| SerialNumber | String | Serial number for the work order item, if applicable. |
| SourceHeaderReferenceId | Long | Reference ID linking to the source header record for this material. |
| SourceHeaderRefId | Long | Alternate reference ID for the source header record. |
| SourceLineReferenceId | Long | Reference ID linking to the source line record for this material. |
| SourceLineRefId | Long | Alternate reference ID for the source line record. |
| SourceSystemId | Long | Identifier of the originating source system for this record. |
| Tolerance | Int | Allowed tolerance value for the operation (units defined by context). |
| WoProjectNumber | String | Project number associated with the work order. |
| WorkOrderNumber | String | External work order number for reference. |
| WorkOrderStatusId | Long | Identifier representing the work order status. |
| WoTaskNumber | String | Task number within the work order project. |