CData Python Connector for Oracle Fusion Cloud SCM

Build 25.0.9454

MaintenanceWorkOrdersWorkOrderAsset

Query the assets that a multiple asset work order requires.

Columns

Name Type Description
MaintenanceWorkOrdersWorkOrderId [KEY] Long Value that uniquely identifies the work order.
AssetId Long Value that uniquely identifies the asset associated to the maintenance work order. When the value for
OrganizationId Long Identifier of the organization associated to the respective work order assets. This attribute is read-only.
WoAssetId [KEY] Long Value that uniquely identifies the asset association to the maintenance work order . This attribute is read-only. The value is generated when the asset is added to the work order.
WorkOrderId Long Value that uniquely identifies the work order to which the asset is associated. This attribute is read-only.
ItemId Long Value that uniquely identifies the item referenced in the work order asset. This attribute is read-only.
AssetNumber String Number that uniquely identifies the asset associated to the maintenance work order. When the value for
SerialNumber String The serial number of the asset associated to the work order. The value is conditionally referenced in the asset based on the attributes of the item associated to the work order asset.
LotNumber String The lot number of the asset associated to the work order. The value is conditionally referenced in the asset based on the attributes of the item associated to the work order asset.
Quantity Decimal Asset quantity and is read-only. The value is derived from the respective work order asset.
UOMCode String The primary unit of measure of the item associated to the asset in context.
MatchToTransactionCodeFlag Bool Contains one of the following values: true or false. If true, then only those material and resource transactions that have a matching repair transaction code in an active warranty contract are considered for creating a warranty entitlement. If false, then entitlements are created for all material and resource transactions. This attribute has a default value of false.
WarrantyRepairFlag Bool Contains one of the following values: true or false. If true, then the work order is considered for warranty entitlement creation and claim review. If false, then the work order isn't considered for warranty entitlement creation and claim review. This attribute has a default value of false.
PrimaryReasonForRepairCode String Abbreviation that identifies the primary reason for repair of the maintenance work order asset. This attribute is read-only. The list of values comes from the user-defined condition event codes with the transaction type Reason for repair.
PrimaryReasonForRepair String Meaning of the primary reason for the repair code. This attribute is read-only.
AssetDescription String Description of an asset. The value is read only.
Finder String Finder criteria used to filter maintenance work order assets based on specific search parameters and conditions.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9454