WorkOrdersWorkOrderMaterial
The Work Order Materials resource manages materials that the operations use to process the work order.
Columns
| Name | Type | Description |
| WorkOrdersWorkOrderId [KEY] | Long | WorkOrdersWorkOrderId of WorkOrdersWorkOrderMaterial |
| OrganizationId | Long | OrganizationId of WorkOrdersWorkOrderMaterial |
| WorkOrderId | Long | WorkOrderId of WorkOrdersWorkOrderMaterial |
| WorkOrderOperationId | Long | WorkOrderOperationId of WorkOrdersWorkOrderMaterial |
| OperationSequenceNumber | Decimal | OperationSequenceNumber of WorkOrdersWorkOrderMaterial |
| OperationName | String | OperationName of WorkOrdersWorkOrderMaterial |
| StandardOperationId | Long | StandardOperationId of WorkOrdersWorkOrderMaterial |
| StandardOperationCode | String | StandardOperationCode of WorkOrdersWorkOrderMaterial |
| WorkAreaId | Long | WorkAreaId of WorkOrdersWorkOrderMaterial |
| WorkAreaName | String | WorkAreaName of WorkOrdersWorkOrderMaterial |
| WorkCenterId | Long | WorkCenterId of WorkOrdersWorkOrderMaterial |
| WorkCenterName | String | WorkCenterName of WorkOrdersWorkOrderMaterial |
| WorkOrderOperationMaterialId [KEY] | Long | WorkOrderOperationMaterialId of WorkOrdersWorkOrderMaterial |
| MaterialSequenceNumber | Decimal | MaterialSequenceNumber of WorkOrdersWorkOrderMaterial |
| MaterialType | String | MaterialType of WorkOrdersWorkOrderMaterial |
| InventoryItemId | Long | InventoryItemId of WorkOrdersWorkOrderMaterial |
| ItemNumber | String | ItemNumber of WorkOrdersWorkOrderMaterial |
| ItemDescription | String | ItemDescription of WorkOrdersWorkOrderMaterial |
| ItemRevision | String | ItemRevision of WorkOrdersWorkOrderMaterial |
| QuantityPERProduct | Decimal | QuantityPERProduct of WorkOrdersWorkOrderMaterial |
| BasisType | String | BasisType of WorkOrdersWorkOrderMaterial |
| Quantity | Decimal | Quantity of WorkOrdersWorkOrderMaterial |
| InverseQuantity | Decimal | InverseQuantity of WorkOrdersWorkOrderMaterial |
| UOMCode | String | UOMCode of WorkOrdersWorkOrderMaterial |
| UnitOfMeasure | String | UnitOfMeasure of WorkOrdersWorkOrderMaterial |
| RequiredDate | Datetime | RequiredDate of WorkOrdersWorkOrderMaterial |
| YieldFactor | Decimal | YieldFactor of WorkOrdersWorkOrderMaterial |
| IncludeInPlanningFlag | Bool | IncludeInPlanningFlag of WorkOrdersWorkOrderMaterial |
| SupplyType | String | SupplyType of WorkOrdersWorkOrderMaterial |
| SupplyTypeDescription | String | SupplyTypeDescription of WorkOrdersWorkOrderMaterial |
| SupplySubinventory | String | SupplySubinventory of WorkOrdersWorkOrderMaterial |
| SupplyLocatorId | Long | SupplyLocatorId of WorkOrdersWorkOrderMaterial |
| SupplyLocator | String | SupplyLocator of WorkOrdersWorkOrderMaterial |
| ReservedQuantity | Decimal | ReservedQuantity of WorkOrdersWorkOrderMaterial |
| IssuedQuantity | Decimal | IssuedQuantity of WorkOrdersWorkOrderMaterial |
| ProducedQuantity | Decimal | ProducedQuantity of WorkOrdersWorkOrderMaterial |
| AllocatedQuantity | Decimal | AllocatedQuantity of WorkOrdersWorkOrderMaterial |
| PickedQuantity | Decimal | PickedQuantity of WorkOrdersWorkOrderMaterial |
| RemainingAllocatedQuantity | Decimal | RemainingAllocatedQuantity of WorkOrdersWorkOrderMaterial |
| CreatedBy | String | CreatedBy of WorkOrdersWorkOrderMaterial |
| CreationDate | Datetime | CreationDate of WorkOrdersWorkOrderMaterial |
| LastUpdateDate | Datetime | LastUpdateDate of WorkOrdersWorkOrderMaterial |
| LastUpdatedBy | String | LastUpdatedBy of WorkOrdersWorkOrderMaterial |
| SubstituteFlag | Bool | SubstituteFlag of WorkOrdersWorkOrderMaterial |
| BackToBackFlag | String | BackToBackFlag of WorkOrdersWorkOrderMaterial |
| ContractMfgFlag | String | ContractMfgFlag of WorkOrdersWorkOrderMaterial |
| DueDays | Int | DueDays of WorkOrdersWorkOrderMaterial |
| Finder | String | Finder of WorkOrdersWorkOrderMaterial |
| FirmPlannedFlag | String | FirmPlannedFlag of WorkOrdersWorkOrderMaterial |
| MaterialItemId | Long | MaterialItemId of WorkOrdersWorkOrderMaterial |
| PlannedCompletionDate | Datetime | PlannedCompletionDate of WorkOrdersWorkOrderMaterial |
| PlannedStartDate | Datetime | PlannedStartDate of WorkOrdersWorkOrderMaterial |
| ProductSerialId | Long | ProductSerialId of WorkOrdersWorkOrderMaterial |
| ResourceId | Long | ResourceId of WorkOrdersWorkOrderMaterial |
| SerialNumber | String | SerialNumber of WorkOrdersWorkOrderMaterial |
| SourceHeaderReferenceId | Long | SourceHeaderReferenceId of WorkOrdersWorkOrderMaterial |
| SourceHeaderRefId | Long | SourceHeaderRefId of WorkOrdersWorkOrderMaterial |
| SourceLineReferenceId | Long | SourceLineReferenceId of WorkOrdersWorkOrderMaterial |
| SourceLineRefId | Long | SourceLineRefId of WorkOrdersWorkOrderMaterial |
| SourceSystemId | Long | SourceSystemId of WorkOrdersWorkOrderMaterial |
| Tolerance | Int | Tolerance of WorkOrdersWorkOrderMaterial |
| WoProjectNumber | String | WoProjectNumber of WorkOrdersWorkOrderMaterial |
| WorkOrderNumber | String | WorkOrderNumber of WorkOrdersWorkOrderMaterial |
| WorkOrderStatusId | Long | WorkOrderStatusId of WorkOrdersWorkOrderMaterial |
| WoTaskNumber | String | WoTaskNumber of WorkOrdersWorkOrderMaterial |