ADO.NET Provider for Oracle Fusion Cloud SCM

Build 24.0.9175

InstalledBaseAssetsfixedAssetAssociations

Maintains associations between installed base assets and fixed assets, including updates and terminations.

Columns

Name Type Description
InstalledBaseAssetsAssetId [KEY] Long The unique identifier for the asset in the InstalledBaseAssets table. This attribute is used to associate the asset with a fixed asset in the InstalledBaseAssetsfixedAssetAssociations table.
ActiveEndDate Datetime The date and time when the association between the installed base asset and the fixed asset becomes inactive. This marks the end of the relationship between the two assets.
ActiveStartDate Datetime The date and time when the association between the installed base asset and the fixed asset becomes active. This marks the beginning of the relationship between the two assets.
AutoTerminationFlag String Indicates whether the association will be automatically terminated. If true, the association is automatically deactivated; if false, it is not. The flag is set conditionally during asset updates based on certain criteria.
FixedAssetId Long The unique identifier for the fixed asset in the table. This attribute establishes the link between an installed base asset and a fixed asset.
TerminationReasonCode String The message code for the reason behind the auto-termination of the association, provided when the 'AutoTerminationFlag' is set to true. This code is conditionally displayed in the user interface and explains why the association was terminated.
FixedAssetNumber String The unique identifier for the fixed asset, usually an asset number assigned to the fixed asset.
AssetId Long The unique identifier for the asset in the InstalledBaseAssets table. This attribute is used in the InstalledBaseAssetsfixedAssetAssociations table to associate the fixed asset with an installed base asset.
Finder String The finder used to search for and retrieve the asset associations based on specific criteria.

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