Excel Add-In for Oracle Fusion Cloud SCM

Build 24.0.9175

InstalledBaseAssetsmeters

Manages details about meters associated with assets, including readings and configurations.

Columns

Name Type Description
InstalledBaseAssetsAssetId [KEY] Long The unique identifier for the asset in the InstalledBaseAssets table. This attribute links the asset with its associated meters for tracking consumption or usage.
MeterUsageCode String A code that identifies the usage type of the meter. This attribute categorizes the meter based on its specific application or function for the asset.
MeterObjectId Long The unique identifier for the meter object in the system. It is used to reference the specific meter associated with the asset.
MeterId Long A unique identifier for the meter itself. This value is used to track the meter and its readings.
AssetNumber String The number assigned to the asset. This is used to identify the asset and is usually linked with the asset's primary identification in the system.
ActiveEndDate Datetime The date and time when the meter association with the asset becomes inactive. This attribute is used to mark the end of the meter's active usage period.
ActiveStartDate Datetime The date and time when the meter association with the asset becomes active. This attribute indicates when the meter starts tracking the asset's usage.
LastReadingValue String The value recorded during the last reading of the meter. This represents the latest measurement or usage tracked by the meter.
LastReadingDate Datetime The date and time when the last meter reading was taken. This attribute helps track when the most recent data was recorded.
LastReadingComments String Any comments associated with the last meter reading. This can be used for additional information regarding the reading or the meter's condition at the time.
DisplayedReading String The reading shown on the meter for display purposes. This may be a rounded or simplified version of the actual reading value.
LifeToDateReading Decimal The total reading accumulated by the meter since its installation or reset. This reflects the overall usage tracked by the meter.
WorkOrderId Long The unique identifier of the work order associated with the meter. This links the meter readings to any maintenance or service activities performed on the asset.
WorkOrderNumber String The work order number associated with the meter. This is used to reference a specific work order for the asset's maintenance or servicing.
MeterTypeCode String A code that identifies the type of meter being used. This attribute is part of the setup and helps categorize meters for asset tracking.
MeterType String The type of meter used for tracking the asset's usage, such as energy, water, or gas. This helps identify the purpose of the meter.
MeterDefinitionId [KEY] Long The unique identifier for the meter definition. This refers to the setup or template that defines the characteristics of the meter.
MeterName String The name assigned to the meter. This name is used to uniquely identify the meter and distinguish it from others in the system.
MeterDescription String A description of the meter. This attribute provides more detailed information about the meter's function and purpose.
MeterCode String A code used to uniquely identify the meter. This code is part of the setup and allows the meter to be referenced in the system.
ReadingDirection String The direction in which the meter readings are taken, such as forward or reverse. This attribute helps define how the meter tracks usage over time.
ReadingDirectionMeaning String A description of the meaning of the reading direction. It explains the context of the reading direction (for example, increase or decrease in the tracked value).
ReadingTypeCode String A code identifying the type of reading, such as initial, regular, or final. This allows the system to categorize readings.
ReadingType String The type of reading taken by the meter, such as usage reading or diagnostic reading. This helps classify the meter's data.
UOMCode String The unit of measure (UOM) code associated with the meter's readings, such as kilowatt-hours (kWh) or gallons. This ensures consistent tracking of the meter's data.
UnitOfMeasure String The full name of the unit of measure (UOM) used for the meter readings. This provides more detailed information about the UOM.
RolloverResetValue Decimal The value at which the meter's reading resets due to rollover. This happens when the meter reaches a specific limit and starts counting from a predefined starting point.
RolloverMaximumValue Decimal The maximum value the meter can reach before it resets or rolls over. This helps track how the meter handles large or continuous readings.
RolloverAllowedFlag Bool Indicates whether rollover is allowed for the meter. If true, the meter can reset once it reaches its maximum value. If false, the meter does not allow rollover.
ResetAllowedFlag Bool Indicates whether resetting the meter is allowed. If true, the meter can be manually reset to start counting from zero. If false, resetting is not permitted.
ResetValue Decimal The value to which the meter reading is reset. This is used to manually set the meter back to a starting value, typically when maintenance is performed.
DailyUtilizationRate Decimal The daily usage rate for the asset, as measured by the meter. This reflects the asset's average daily consumption or usage.
AllowInMaintProgramFlag Bool Indicates whether the meter is included in maintenance programs. If true, the meter is part of a scheduled maintenance plan; if false, it is excluded.
RecordAtWoComplCode String The code used to record the meter reading when the work order is completed. This helps track meter data during the completion of service or maintenance tasks.
RecordAtWoComplMeaning String The description of the meaning behind the work order completion code. This provides context for the actions taken during the work order's completion.
UtilizationRateComputedAt Decimal The calculated utilization rate at the time of meter reading. This value represents how much of the asset’s capacity has been used up at a given point in time.
CalculatedUtilizationRate Decimal The computed rate of utilization based on the meter readings and asset usage over time.
AssetId Long The unique identifier for the asset associated with the meter. This attribute links the meter readings to a specific asset.
Finder String The finder used to search and retrieve meter data based on specific criteria.

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