Commodity Usage DMO

Object Properties

Object API Name: ssot__CommodityUsage__dlm
Category: Unassigned
Availability: Available in 254 and later versions
Primary Key Field: Id

Relationships

• ConsumptionQuantityUOMId has a FOREIGNKEY relationship with the Unit of Measure DMO Id field.
• AssetId has a FOREIGNKEY relationship with the Asset DMO Id field.

Fields

• AssetId
• cdp_sys_record_currency
• ConsumptionQuantity
• ConsumptionQuantityUOMId
• DataSourceId
• DataSourceObjectId
• EndDateTime
• Id
• InternalOrganizationId
• KQ_AssetId
• KQ_ConsumptionQuantityUOMId
• KQ_Id
• MeterExternalId
• RegisterExternalId
• ServicePointExternalId
• StartDateTime
• TimeOfUse

AssetId

• Field API Name: ssot__AssetId__c
• Data Type: TEXT
• Description: The unique identifier for the related Asset record. Maximum size is 15 characters.

cdp_sys_record_currency

• Field API Name: ssot__cdp_sys_record_currency__c
• Data Type: TEXT
• Description: System-generated metadata field that stores a 3-letter ISO currency code.

ConsumptionQuantity

• Field API Name: ssot__ConsumptionQuantity__c
• Data Type: DOUBLE
• Description: Quantity of Resource/commodity (electricity/gas/water) consumed between the start and end date time.

ConsumptionQuantityUOMId

• Field API Name: ssot__ConsumptionQuantityUOMId__c
• Data Type: TEXT
• Description: Unit of Measure corresponding to the consumption quantity.

DataSourceId

• Field API Name: ssot__DataSourceId__c
• Data Type: TEXT
• Description: A unique, system-generated identifier for this record.

DataSourceObjectId

• Field API Name: ssot__DataSourceObjectId__c
• Data Type: TEXT
• Description: A unique, system-generated identifier for this record.

EndDateTime

• Field API Name: ssot__EndDateTime__c
• Data Type: DATETIME
• Description: End Date time until which the consumptionis calculated.

Id

• Field API Name: ssot__Id__c
• Data Type: TEXT
• Description: Required. A unique, system-generated identifier for this CommodityUsage record. Maximum size is 15 characters.

InternalOrganizationId

• Field API Name: ssot__InternalOrganizationId__c
• Data Type: TEXT
• Description: A unique, system-generated identifier for this record.

KQ_AssetId

• Field API Name: KQ_AssetId__c
• Data Type: TEXT
• Description: Key Qualifier system field for AssetId

KQ_ConsumptionQuantityUOMId

• Field API Name: KQ_ConsumptionQuantityUOMId__c
• Data Type: TEXT
• Description: Key Qualifier system field for ConsumptionQuantityUOMId

KQ_Id

• Field API Name: KQ_Id__c
• Data Type: TEXT
• Description: Key Qualifier system field for Id

MeterExternalId

• Field API Name: ssot__MeterExternalId__c
• Data Type: TEXT
• Description: Reference to the external id of the meter asset the validated Resource/commodity Usage is a part of.

RegisterExternalId

• Field API Name: ssot__RegisterExternalId__c
• Data Type: TEXT
• Description: Reference to the external id of the meter Register asset the validated Resource/commodity Usage is a part of.

ServicePointExternalId

• Field API Name: ssot__ServicePointExternalId__c
• Data Type: TEXT
• Description: Reference to the metering asset supertype the Validated Resource/commodity Usage is a part of.

StartDateTime

• Field API Name: ssot__StartDateTime__c
• Data Type: DATETIME
• Description: Start date time from which the consumption is calculated.

TimeOfUse

• Field API Name: ssot__TimeOfUse__c
• Data Type: TEXT
• Description: Time Of Use.