Subscription Usage Charge Components
The subscription usage charge component resource contains information such as event ID, currency, extended amount, subscription ID, subscription product ID, unit price, and so on.
Data Store Key : CrmAnalyticsAM.CrmExtractAM.OssBiccExtractAM.SubscriptionUsageChargeComponentPVO
Primary Keys : UsageChargeComponentId
Initial Extract Date : CreationDate
Incremental Extract Date : LastUpdateDate
Attributes
This table provides the list of exposed attributes and their descriptions.
| Name | Description |
|---|---|
| BatchId | |
| ChargeCurrency | The charge currency of the usage charge component. |
| CoverageExtendedAmount | The coverage extended amount of the usage charge component. |
| CreatedBy | The user who created the usage charge component. |
| CreationDate | The date on which the usage charge component was created. |
| EventId | The unique identifier of the usage event. |
| Explanation | The explanation of the usage charge component. |
| ExplanationMessageName | The explanation message name of the usage charge component. |
| ExtendedAmount | The extended amount of the specific usage charge component. |
| LastUpdateDate | The date on which this usage charge component got updated the last. |
| LastUpdateLogin | The login of the user who last updated the usage charge component. |
| LastUpdatedBy | The user who last updated the usage charge component. |
| ObjectVersionNumber | The object version number updated after every update of an usage charge component. |
| PartitionName | |
| PctOfComparisonElement | The percent of comparison element of the usage charge component. |
| PriceElement | The value that identifies the element reference to the price elements setup. For example, LISTPRICE, and NETPRICE. |
| PriceElementUsage | The value that's used by consuming applications to indicate how the charge component will be used. A list of accepted values is defined in the lookup type ORA_QP_ELEMENT_USAGES. |
| PricingSourceId | The value that uniquely identifies the source charge created by an external pricing engine. |
| PricingSourceType | The type of the Pricing source such as Segment Price List Line. A list of accepted values is defined in the lookup type QP_ENTITY_TYPES and manually adjusted. |
| RollupFlag | The rollup flag of the usage charge component. |
| SequenceNumber | The sequence number associated with an usage charge component. |
| SubscrCurrencyCovExtAmt | The coverage extended amount of the usage charge component in subscription currency. |
| SubscrCurrencyExtAmount | The extended amount of the usage charge component in subscription currency. |
| SubscrCurrencyUnitPrice | The usage price of the usage charge component in subscription currency. |
| SubscriptionCurrency | The subscription currency associated with the usage charge component. |
| SubscriptionId | The unique identifier of a subscription to which this usage charge component belongs. |
| SubscriptionProductId | The PUID of a subscription product to which this usage charge component belongs. |
| TaxIncludedFlag | The tax included indicator of the usage charge component. |
| UnitPrice | The unit price of the usage charge component. |
| UsageChargeComponentId | The unique identifier of the usage event charge component. |
| UsageChargeComponentPuid | The PUID of the usage charge component. This must be unique across the usage charge component object. |
| UsageChargeId | The unique identifier of the usage charge. |