CData Python Connector for Oracle Fusion Cloud SCM

Build 25.0.9454

MaintenanceWorkOrdersRouteAssets

Query the asset routes required for the work order.

Columns

Name Type Description
MaintenanceWorkOrdersWorkOrderId [KEY] Long Value that uniquely identifies the work order.
WoAssetId [KEY] Long Unique identifier of the associated asset route.
WorkOrderId Long Value that uniquely identifies the work order.
AssetId Long Value that uniquely identifies the asset route associated with the maintenance work order. When the work order status is other than 'unreleased,' the assets in the work order cannot be updated or deleted.
AssetNumber String Number that uniquely identifies the asset route associated with the maintenance work order. When the work order status is other than 'unreleased,' the assets in the work order cannot be updated or deleted.
AssetDescription String Number that uniquely identifies the asset route description associated to the maintenance work order.
SerialNumber String The serial number of the asset route associated with the work order. The value is conditionally referenced in the asset based on the attributes of the item associated with the work order asset.
LocationType String The location type of the asset route associated with the work order. This value represents the current location of the asset associated with the work order.
LocationTypeMeaning String The location meaning of the asset route associated with the work order. This value represents the location meaning of the asset associated with the work order.
Location String The location context of the asset route associated with the work order. This value represents the location of the asset associated with the work order.
RouteCompleteFlag Bool Indicates the completed flag for the work order asset route. This value represents the completion status of the asset.
RouteSkippedFlag Bool Indicates the skipped flag for the work order asset route. This value represents the skipped status of the asset.
BindDocNumber String A finder used to filter data using Finder column. Number that identifies the document.
BindDocType String A finder used to filter data using Finder column. Type of the document.
Finder String Finder criteria used to filter maintenance work order route assets based on specific search parameters and conditions.
OrganizationId Long A finder used to filter data using Finder column. Value that uniquely identifies the organization.
WorkDefinitionId Long A finder used to filter data using Finder column. Value that uniquely identifies the work definition.
WorkOrderNumber String A finder used to filter data using Finder column. Value that uniquely identifies the work order.

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