Principal: 99887775
Today: 2025-10-02
FDWR_ACRN_CS-2
|
|
RECHARGE ACTIVITY: View Active Principal: 99887775 |
|
|
Today: 2025-10-02
FDWR_ACRN_CS-2
|
|
FrontierDataWarehouse ACORN Script |
IF EXISTS(select COUNT(*) OVER () as Total_Rows, dmria.* FROM dbo.Dim_MeterRechargeInvestigateActivity AS dmria WITH (NOLOCK) JOIN dbo.DimMerchantGroups AS dmg WITH (NOLOCK) ON dmg.MerchantKey = dmria.TenantKey WHERE dmg.PrincipalKey=dbo.FN_MerchantKey('99887775') AND dmria.meterserialnumber LIKE '%%' AND dmria.ShowIt = 1 ) SELECT COUNT(*) OVER () as Total_Rows, dmria.* FROM dbo.Dim_MeterRechargeInvestigateActivity AS dmria WITH (NOLOCK) JOIN dbo.DimMerchantGroups AS dmg WITH (NOLOCK) ON dmg.MerchantKey = dmria.TenantKey WHERE dmg.PrincipalKey=dbo.FN_MerchantKey('99887775') AND dmria.meterserialnumber LIKE '%%' AND dmria.ShowIt = 1 ORDER BY dmria.PushAlerts DESC, dmria.Priority DESC, dmria.TenantName asc ELSE SELECT 0 as Total_Rows |
| Icon // Abbr | Description | |
|
V I E W S
|
|
Type Of Meter |
|
Meter Details | |
|
Tenant Details | |
|
Priority | |
|
Show Record in the Grid | |
 |
Hide Record from Grid | |
|
A L A R M S
|
|
No Allerts |
|
Alerts | |
|
|
Flow Interrupted | |
|
Flow Normal | |
| |
Events: None | |
| |
Events: Yes | |
|
C O M M A N D S
|
|
Change Meter Status |
|
View Meter History | |
 |
No Records | |
|
Processing | |
 |
Completed | |
 |
Error | |
 |
Unknown | |
 |
Reset | |
 |
Recovery | |
 |
Cancelled | |
|
L O G S
|
|
View Logs |
|
Log Closed | |
 |
Log Open | |
 |
Add New Log | |
| DLM | Differential Last Month. Refers to percentage change compared to previous month | |
| FBU | Free Basic Utilities | |
