MaintenanceWorkOrderMaterials
The Maintenance Work Order Materials resource manages the materials that the work order requires to perform a maintenance operation.
Columns
| Name | Type | Description |
| WoOperationMaterialId [KEY] | Long | Value that uniquely identifies the material for work order operation. This attribute is read-only. The value of this attribute is generated when the application creates the operation material. |
| OrganizationCode | String | Abbreviation for the maintenance organization of the work order. |
| OrganizationId | Long | Value that uniquely identifies the maintenance organization of the work order. |
| WorkOrderId | Long | Value that uniquely identifies the work order. This attribute is read-only. The value of this attribute is derived from the work order number when the application creates the work order. |
| WorkOrderNumber | String | Number that identifies the work order. This number is unique in the organization. The user can manually assign the number when creating the work order, or allow the application to create a unique number from the numbering scheme that the following Plant parameters define: Work Order Prefix or Work Order Starting Number. |
| WoOperationId | Long | Value that uniquely identifies the work order operation. This attribute is read-only. The value of this attribute is generated when the application creates the work order operation. |
| WoOperationName | String | Name of the work order operation. The operation name is required to create an operation. |
| WoOperationDescription | String | Description of the operation to be performed during the work order execution. The operation description is optional to create the work order operation. |
| WoOperationSequenceNumber | Decimal | Number that identifies the sequence to use when performing the work order operations. The operation sequence is required to create an operation. It must be a positive integer. Its value must be unique within the work order operations. If it isn't provided, then the last operation sequence incremented by 10 is used as sequence to create an operation. |
| CountPointOperationFlag | Bool | Contains one of the following values: true or false. If true, then make this operation a count point operation. If an operation occurs on the shop floor, the user must manually report it in the application when the operation occurs. If false, then don't make this operation a count point operation. The user doesn't need to report the operation. It's recommended that you configure each work order so that it includes at least one count point operation, and to make sure that the last operation that the work order performs is a count point operation. The default value is true. |
| AutoTransactFlag | Bool | Contains one of the following values: true or false. If true, then automatically report the operation when the operation occurs on the shop floor. If false, then don't report this operation automatically. If the operation isn't significant, it's recommended that you set AutoTransactFlag to true. The Count Point attribute and the Automatically Transact attribute are mutually exclusive. You must make sure that each of these attributes do not both contain true. If the Count Point and Automatically Transact attributes each contain false, then the operation is optional. Note that the user can manually report component usage and resource usage for an optional operation. The default value is false. |
| MaterialSequenceNumber | Decimal | Number that identifies the sequence of the material component assigned to the work order operation. The sequence is required to create an operation material. The last operation material sequence incremented by 10 is used as sequence to create an operation material. |
| MaterialTypeCode | String | Abbreviation for the type of material defined for the work order operation. Valid values are contained in the lookup ORA_WIE_MATERIAL_TYPE. |
| MaterialType | String | Meaning for the type of material defined for the work order operation. Valid values are contained in the lookup ORA_WIE_MATERIAL_TYPE. |
| InventoryItemId | Long | Value that uniquely identifies the material component item to issue to the work order. You must provide either the item number or the item identifier to create a work order operation material. |
| InventoryItemNumber | String | Number that identifies the material component item to issue to the work order. You must provide either the item number or the item identifier to create a work order operation material. |
| InventoryItemDescription | String | Description of the item number. |
| InventoryItemLongDescription | String | Long description of the item number. |
| UOMCode | String | Abbreviation that identifies the unit of measure of the operation material quantity. |
| UnitOfMeasure | String | Unit of measure of the material component quantity to be issued. It is the primary unit of measure of the item. This attribute is read-only. The value of this attribute is derived from the material component item. |
| RequiredQuantity | Decimal | Material component quantity which is required to be issued for the work order operation. The material component quantity is required to create an operation material. |
| BasisTypeCode | String | Abbreviation for the basis type of material defined for the work order operation. Valid values are contained in the lookup EGP_BOM_BASIS_TYPE. |
| BasisType | String | Meaning for the basis type of material defined for the work order operation. Valid values are contained in the lookup EGP_BOM_BASIS_TYPE. |
| QuantityPerAsset | Decimal | Material component quantity per asset which is required to be issued for the work order operation. The material component quantity is required to create an operation material. |
| ReservedQuantity | Decimal | Quantity of material that is reserved for a work order operation item. |
| AllocatedQuantity | Decimal | Quantity of material allocated during the picking process when a movement request is created for a work order operation item. |
| PickedQuantity | Decimal | Quantity of material picked when the pick slip is confirmed and is issued either directly to the work order or is moved to the supply subinventory for a work order operation item. |
| IssuedQuantity | Decimal | Net quantity of the material issued to the operation. |
| QuantityIssuedPerAsset | Decimal | Net quantity of the material issued per asset to the operation. |
| OpenQuantity | Decimal | Open quantity of the material issued to the operation. |
| ProducedQuantity | Decimal | Quantity that the work order creates. This attribute isn't applicable to maintenance work orders. |
| OnHandQuantity | Decimal | Available quantity of the material in the subinventory location. |
| RequiredDate | Datetime | Date when the plant requires the materials so it can perform the operation. This attribute is required. The default value is the operation start date. The required date must not occur before the operation start date, or after the operation completion date. |
| IncludeInPlanningFlag | Bool | Contains one of the following values: true or false. If true, then planning considers the material when it plans the supply. If false, then planning does not consider the material when it plans the supply. The default value is true. |
| SupplyType | String | Type of consumption of the material component. Valid values include 1: Push, 2: Assembly pull, 3: Operation pull, 4: Bulk, and 5: Supplier. This attribute is required to create an operation material. If the supply type isn't provided, then the default value is material component item. If the work order was created with a work definition, then the default value is based on the work definition. |
| SupplyTypeDescription | String | Description of the operation material supply type. This attribute is read-only. The value of this attribute is derived from the supply type code. |
| SupplySubinventory | String | Supply subinventory from where the material is issued during an assembly or operation pull. The default value is the component item definition or the plant parameters. |
| LotControlFlag | Bool | Indicates if the item is lot controlled. Values are true or false. |
| AssetTrackedFlag | Bool | Indicates if the item is asset-tracked. Values are true or false. |
| SerialControlFlag | Bool | Indicates if the item is serial controlled. Values are true or false. |
| LocatorControlFlag | Bool | Indicates if the item is locator controlled. Values are true or false. |
| SupplyLocatorId | Long | Value that uniquely identifies the supply subinventory locator from where the material is issued during an assembly or operation pull. The default value is the component item definition or the plant parameters. |
| SupplyLocator | String | Name of the supply locator from where the material component item is issued. This attribute is read-only. The value of this attribute is derived from the supply locator identifier. |
| RepairTransactionCodeId | Long | Value that uniquely identifies the reason for repair of the maintenance work order operation material. This attribute is read-only. The list of values comes from the user-defined condition event codes with the transaction type Reason for repair. |
| RepairTransactionCode | String | Abbreviation that identifies the reason for repair of the maintenance work order operation material. This attribute is read-only. The list of values comes from the user-defined condition event codes with the transaction type Reason for repair. |
| RepairTransactionName | String | Meaning of the repair transaction code. |
| CreatedBy | String | Session login associated with the user who created the record. |
| CreationDate | Datetime | Date when the record was created. |
| LastUpdatedBy | String | Session login associated with the user who most recently updated the record. |
| LastUpdateDate | Datetime | Date when the record was most recently updated. |
| SerialNumberControlCode | Decimal | Value that indicates the number assigned to each unit of an item and is used to track the item. A list of accepted values is defined in the lookup EGP_SERIAL_NUMBER_CONTROL_TYPE. |
| LotControlCode | Decimal | Value that indicates the ability to use lot numbers during material transactions for tracking batches of an item. A list of accepted values is defined in the lookup EGP_LOT_CONTROL_CODE_TYPE. |
| StockLocatorControlCode | Decimal | Value that indicates the physical area within a subinventory where you store material, such as a row, aisle, bin, or shelf. A list of accepted values is defined in the lookup EGP_LOCATOR_CONTROL_CODE_TYPE. |
| SubstituteMaterialFlag | Bool | Value that indicates whether the component is a substitute. |
| WorkOrderReleasedDate | Datetime | Date when the work order is released. |
| InverseQuantity | Decimal | Allocated component quantity. |
| YieldFactor | Decimal | Factor to use when calculating the quantity that the operation requires to accommodate component waste when it processes the item. The application considers the yield when it calculates the required quantity according to the Include plant parameter for the component yield. |
| SubstituteAllowedFlag | Bool | Value that indicates whether the material requirement allows a substitute component. |
| WorkMethodCode | String | Abbreviation that identifies the method that the work order uses such as DISCRETE_MANUFACTURING or MAINTENANCE. |
| WorkCenterCode | String | Abbreviation that identifies the work center. |
| AvailableToTransact | Decimal | The quantity already reserved and ready to transact. Available to Transact = (Quantity On Hand) - Pending Transactions - Reservations. |
| MaterialExceptionFlag | Bool | Value that indicates whether open exceptions of type component exists for a specific material requirement of the work order. |
| WorkCenterId | Long | Value that uniquely identifies the work center. It's a primary key that the application generates when it creates the work center. |
| BindAssetId | Long | A finder used to filter data using Finder column. Value that uniquely identifies the asset. |
| BindWorkCenterId | Long | A finder used to filter data using Finder column. Value that uniquely identifies the work center. |
| BindWorkMethodCode | String | A finder used to filter data using Finder column. Value that uniquely identifies the work method code. |
| BindWorkOrderId | Long | A finder used to filter data using Finder column. Value that uniquely identifies the work order. |
| Finder | String | Finder criteria used to filter maintenance work order materials based on specific search parameters and conditions. |