ODBC Driver for Oracle Fusion Cloud SCM

Build 25.0.9434

InstalledBaseAssetsrelationships

Handles structural relationships between assets, including hierarchical and linked associations.

Columns

Name Type Description
InstalledBaseAssetsAssetId [KEY] Long The unique identifier for the asset in the InstalledBaseAssets table. This value links the asset to its relationships with other assets.
RelationshipId [KEY] Long The unique identifier for the asset relationship. This value is generated by the system when a relationship between assets is created, and is read-only.
AssetId Long The unique identifier for the child asset in the relationship structure. This is a required attribute for defining the relationship between the parent and child assets.
SerialNumber String The serial number of the child asset in the relationship. This helps uniquely identify the asset, especially when dealing with serialized inventory.
ItemNumber String The item number associated with the child asset in the relationship. This attribute provides additional identification for the asset item in the system.
AssetNumber String The unique number that identifies the child asset in the asset relationship structure. This is a read-only attribute that is automatically set by the system.
LogicalObjectId Long The logical object ID associated with the asset relationship. This ID is used internally to manage the asset relationship data structure.
Finder String The finder associated with the asset relationships. This is used to search and retrieve specific asset relationships based on the criteria set in the system.

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