ODBC Driver for Oracle Fusion Cloud SCM

Build 24.0.9175

InstalledBaseAssetscharges

Tracks asset-related charges, including billing and renewal pricing information.

Columns

Name Type Description
InstalledBaseAssetsAssetId [KEY] Long The unique identifier for the asset in the InstalledBaseAssets table. This attribute is used in the InstalledBaseAssetscharges table and is read-only.
AssetChargeId [KEY] Long The unique identifier for the asset charge. This value is automatically generated by the application when the asset charge is created and is read-only.
AssetId Long The unique identifier of the asset to which the charge is associated. The asset referenced determines the value for this attribute, and it is read-only.
ChargeComponentsRollupFlag Bool Indicates whether the charge component represents an aggregated value from a rollup charge. If true, the charge component is a rollup; if false, it is not. The default value is false.
ChargeDefinitionCode String The abbreviation that uniquely identifies the pricing charge definition. This attribute is required to define the asset charge.
ChargesRollupFlag Bool Indicates whether the pricing charge is a rollup charge. If true, the charge is a rollup; if false, it is not. The default value is false.
CurrencyCode String The abbreviation for the currency used by the pricing charge. This attribute is required to define the charge for asset pricing.
PriceElementCode String The abbreviation that identifies the pricing element associated with the charge. This attribute is required to define the asset charge.
PriceElementUsageCode String Indicates whether the unit price in the pricing element is the list price or the net price. This attribute helps distinguish between the two pricing methods.
PricePeriodicityCode String The abbreviation for the recurring time period used to price the charge, such as monthly or yearly. This helps define the periodicity of the asset charge.
PricedQuantityUOMCode String The abbreviation for the unit of measure used for the quantity being priced. This attribute is required to define the charge for asset pricing.
PrimaryFlag Bool Indicates whether the charge is the primary charge for the asset. If true, the charge is considered primary; if false, it is secondary. The default value is false.
TaxIncludedFlag Bool Indicates whether the asset price includes taxes. If true, taxes are included in the price; if false, they are not. The default value is false.
UnitPrice Decimal The unit price of the asset, representing the current price or the price at which the asset was sold. This is used for pricing the asset.
Finder String The finder allows users to search for and filter asset charge records based on specific criteria.

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