Subscription Usage Charges

The subscription usage charge resource contains balance code, balance register, bill line ID, currency, charge name, event ID, priced quantity, reported quantity, usage quantity, usage charge ID, subscription product ID and so on.

Data Store Key : CrmAnalyticsAM.CrmExtractAM.OssBiccExtractAM.SubscriptionUsageChargePVO

Primary Keys : UsageChargeId

Initial Extract Date : CreationDate

Incremental Extract Date : LastUpdateDate

Attributes

This table provides the list of exposed attributes and their descriptions.

Name	Description
AddtlChargeRuleCriteriaId	The addition charge rule criteria identifier of the usage charge line.
AddtlChargeRuleId	The addition charge rule identifier of the usage charge line.
AdhocPriceAdjAmount	The ad hoc amount price adjustment amount applied to the usage charge line.
AdjustedAmount	The adjusted amount of the usage charge.
AdjustedListPrice	The adjusted list price used for the usage charge line.
AdjustedPrice	The adjusted price calculated for the usage charge line.
AdjustedQuantity	The adjusted quantity of the usage charge.
AdjustmentsNetPrice	The net price after applying all adjustments on the usage charge line.
AllowanceAdjAmount	The allowance adjustment amount applied to the usage charge line.
AllowanceAmount	The allowance amount of the usage charge.
AllowanceQuantity	The allowance quantity under subscription entitlement plan details.
Amount	The amount value associated with the usage charge line.
AmountBalanceCodeId	The identifier of the amount balance code associated with the usage charge.
AmountBalanceCommitmentId	The identifier of the amount balance commitment associated with the usage charge.
AmountBalanceEstimateId	The identifier of the amount balance estimate associated with the usage charge.
AmountBalanceUsageChargeId	The amount balance usage charge identifier of the usage charge line.
BalanceCodeId	The unique identifier of the balance code.
BalanceCodeQpRtRuleId	The balance code rated rule identifier of the usage charge line.
BalanceCommitmentId	The identifier of the balance commitment associated with the usage charge.
BalanceEstimateId	The identifier of the balance estimate associated with the usage charge.
BalanceProfileChargeId	The unique identifier of the balance profile charge.
BalanceProfileId	The identifier of the balance profile associated with the usage charge.
BalanceRegisterId	The unique identifier of the balance register.
BalanceRegisterPeriodId	The unique identifier of the balance register period.
BalanceUsageChargeId	The balance usage charge identifier of the usage charge line.
BasePriceMatrixId	The base price matrix identifier of the usage charge line.
BatchId	The batch identifier of the usage charge line.
BatchTag	The batch tag of the usage charge line.
BillAmount1	The first bill amount value associated with the usage charge line.
BillAmount10	The tenth bill amount value associated with the usage charge line.
BillAmount2	The second bill amount value associated with the usage charge line.
BillAmount3	The third bill amount value associated with the usage charge line.
BillAmount4	The fourth bill amount value associated with the usage charge line.
BillAmount5	The fifth bill amount value associated with the usage charge line.
BillAmount6	The sixth bill amount value associated with the usage charge line.
BillAmount7	The seventh bill amount value associated with the usage charge line.
BillAmount8	The eighth bill amount value associated with the usage charge line.
BillAmount9	The ninth bill amount value associated with the usage charge line.
BillLineId	The unique identifier of the bill line.
BillSequenceNumber	The bill sequence number of the usage bill line.
BillSubtotal1	The first subtotal amount calculated for the usage charge line.
BillSubtotal10	The tenth subtotal amount calculated for the usage charge line.
BillSubtotal2	The second subtotal amount calculated for the usage charge line.
BillSubtotal3	The third subtotal amount calculated for the usage charge line.
BillSubtotal4	The fourth subtotal amount calculated for the usage charge line.
BillSubtotal5	The fifth subtotal amount calculated for the usage charge line.
BillSubtotal6	The sixth subtotal amount calculated for the usage charge line.
BillSubtotal7	The seventh subtotal amount calculated for the usage charge line.
BillSubtotal8	The eighth subtotal amount calculated for the usage charge line.
BillSubtotal9	The ninth subtotal amount calculated for the usage charge line.
BilledAmount	The billed amount the usage charge.
CanAdjustFlag	The indicator of whether the usage charge can be adjusted.
ChargeAppliesTo	The charge applies to of the usage charge.
ChargeCurrency	The charge currency of the usage charge.
ChargeDefinition	The charge definition of the usage charge.
ChargeDefinitionId	The unique identifier of the usage charge definition.
ChargeDeterminantId	The unique identifier of the rate plan charge determinant.
ChargeId	The charge ID.
ChargeLineId	The identifier of the usage charge line.
ChargeName	The charge name of the usage charge.
ChargePeriodCode	The charge period code associated with the usage charge.
ChargeSubtype	The charge subtype of the usage charge.
ChargeType	The type of usage charge.
ConversionRate	The conversion rate of the usage charge line.
CopiedFromSourceAdjAmount	The adjustment amount copied from the source transaction.
CpiAdjAmount	The CPI based adjustment amount applied to the usage charge line.
CreatedBy	The user who created the usage charge.
CreationDate	The date on which the usage charge was created.
CurrencyCode	The currency code of the usage charge lien.
DeterminantBalanceCodeId	The determinant balance code identifier of the usage charge line.
EntPlanAggnChargeRuleId	The entitlement plan aggregation charge rule identifier of the usage charge line.
EntPlanChargeRuleId	The entitlement plan charge rule identifier of the usage charge line.
EventId	The unique identifier of the usage event.
EventTypeChargeId	The event type charge identifier of the usage charge line.
ExtendedAmount	The extended amount of the specific usage charge.
InstanceChargeDeterminantId	The instance charge determinant identifier of the usage charge line.
LastUpdateDate	The date on which this usage charge got updated the last.
LastUpdateLogin	The login of the user who last updated the usage charge.
LastUpdatedBy	The user who last updated the usage charge.
ManualAdjListPrice	The manual adjustment list price of the usage charge line.
ManualPriceAdjAmount	The manual price adjustment amount of the usage charge line.
ObjectVersionNumber	The object version number updated after every update of an usage event charge.
ParentBillLineId	The parent bill line identifier of the usage charge line.
ParentEntity	The parent entity associated with the usage event charge.
ParentEntityId	The unique identifier of the parent entity associated with the usage event charge.
ParentUsageChargeId	The parent usage charge identifier of the usage charge line.
PartitionName	The partition name of the usage charge line.
PeriodicBillingYn	The indicator of whether periodic billing is applicable for the usage charge.
PeriodicRecognitionYn	The indicator of whether periodic recognition is applicable for the usage charge.
PrevBilledAmount	The previous billed amount of the usage charge line.
PriceAdjChargeRuleId	The price adjustment charge rule identifier of the usage charge line.
PriceAdjMatrixCriteriaId	The price adjustment matrix criteria identifier of the usage charge line.
PriceAdjustmentMatrixId	The price adjustment matrix identifier of the usage charge line.
PriceListChargeId	The price list charge identifier to the usage charge line.
PriceType	The price type of the usage charge.
PricedQuantity	The usage quantity which is priced after the usage rating.
PricedQuantityUom	The UOM of the usage charge quantity.
PricingTermAdjAmount	The pricing term adjustment amount applied to the usage charge line.
PrimaryFlag	Indicates whether the usage charge is primary.
QpAdjMatrixRuleId	The adjustment matrix rule identifier of the usage charge line.
QpAdjMatrixValidityFlag	The adjustment matrix validity flag of the usage charge line.
QpQuantityAttributeName	The quantity attribute name of the usage charge line.
QpQuantityUomAttributeName	The quantity unit of measure attribute name of the usage charge line.
QpRateTableRuleId	The rate table rule identifier of the usage charge line.
QpRateTableValidityFlag	The rate table validity flag of the usage charge line.
QuantityAttributeName	The quantity attribute name of the usage charge line.
QuantityColumnName	The quantity column name of the usage charge line.
QuantityUomAttributeName	The unit of measure attribute name of the usage charge line.
QuantityUomColumnName	The unit of measure column name of the usage charge line.
RateTableChargeRuleId	The rate table charge rule identifier of the usage charge line.
RateTableMatrixCriteriaId	The rate table matrix criteria identifier of the usage charge line.
RatingChargeLineId	The rating charge line identifier of the usage charge line.
RatingModel	The rating model of the usage charge.
RecPricePeriodicityCode	The recurring price periodicity code associated with the usage charge.
ReportedQtyAttributeName	The reported quantity attribute name of the usage charge line.
ReportedQtyColumnName	The reported quantity column name of the usage charge line.
ReportedQuantity	The reported usage quantity which has to be rated.
ReportedUomAttributeName	The reported unit of measure attribute name of the usage charge line.
ReportedUomColumnName	The reported unit of measure column name of the usage charge line.
RequestId	The request ID associated with the usage charge.
RollupFlag	The rollup indicator associated with the usage charge.
RootBillLineId	The root bill line identifier of the usage charge line.
RoundedQuantity	The usage quantity which is rounded to the nearest precision.
RowID	The row identifier of the usage charge line.
SequenceNumber	The sequence number associated with an usage charge.
SubscriptionId	The unique identifier of a subscription to which this usage charge belongs.
SubscriptionProductId	The unique identifier of a subscription product to which this usage charge belongs.
SummarizedRatingFlag	Indicates whether the events are eligible for summarized rating.
SystemAdhocPriceAdjAmount	The system generated ad hoc amount price adjustment amount for the usage charge line.
SystemPriceAdjAmount	The system price adjustment amount applied to the usage charge line.
SystemVolumePriceAdjAmount	The system volume price adjustment amount applied to the usage charge line.
UnitPrice	The unit price of the usage charge line.
UsageBillLineId	The usage bill line identifier to usage charge line.
UsageCaptureFlag	Indicates whether the usage capture is enabled for a balance register profile charge.
UsageChargeId	The unique identifier of the usage charge.
UsageChargePuid	The PUID of the usage charge. This must be unique across the usage charge object.
UsageQuantity	The usage quantity which has to be rated.
UsageUom	The UOM of the usage quantity.
UserReportedQuantity	The user reported quantity to usage charge line.
UserReportedUom	The user reported unit of measure to usage charge line.
VolAggrBalanceCodeId	The aggregate balance code identifier to usage charge line.
VolEligibleBalanceCodeId	The eligible balance code identifier to usage charge line.
VolPriAggnBalanceCodeId	The volume pricing aggregate balance code identifier to usage charge line.
VolPriElgblBalanceCodeId	The volume pricing eligible balance code identifier to usage charge line.
VolRebateSurchargeAmount	The volume rebate surcharge amount applied to the usage charge line.
VolumePriceAdjAmount	The volume price adjustment amount applied to the usage charge line.
VolumePricingFlag	Indicates whether the profile charge is enabled for volume pricing.