Charge Lines

The charge lines extract view object contains information on bill amounts, quantities, and so on about the charge lines.

Data Store Key : CrmAnalyticsAM.CrmExtractAM.OssBiccExtractAM.ChargeLinesExtractPVO

Primary Keys : ChargeLineId

Initial Extract Date : CreationDate

Incremental Extract Date : LastUpdateDate

Attributes

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

Name	Description
AdhocPriceAdjAmount	The ad hoc amount price adjustment applied to the charge line.
AdjustedListPrice	The adjusted list price used for the charge line.
AdjustedPrice	The adjusted price calculated for the charge line.
AdjustmentsNetPrice	The net price after applying all adjustments on the charge line.
AllowanceAdjAmount	The allowance adjustment amount applied to the charge line.
AllowanceAmount	The allowance amount of the usage charge line.
AllowanceQuantity	The allowance quantity of the usage charge line.
Amount	The amount of the usage charge line.
BalanceProfileChargeId	The unique identifier of the balance profile charge.
BalanceRegisterId	The unique identifier of the balance register.
BalanceRegisterPeriodId	The unique identifier of the balance register period.
BillAmount1	The first bill amount value associated with the charge line.
BillAmount10	The tenth bill amount value associated with the charge line.
BillAmount2	The second bill amount value associated with the charge line.
BillAmount3	The third bill amount value associated with the charge line.
BillAmount4	The fourth bill amount value associated with the charge line.
BillAmount5	The fifth bill amount value associated with the charge line.
BillAmount6	The sixth bill amount value associated with the charge line.
BillAmount7	The seventh bill amount value associated with the charge line.
BillAmount8	The eighth bill amount value associated with the charge line.
BillAmount9	The ninth bill amount value associated with the charge line.
BillSubtotal1	The first subtotal amount calculated for the charge line.
BillSubtotal10	The tenth subtotal amount calculated for the charge line.
BillSubtotal2	The second subtotal amount calculated for the charge line.
BillSubtotal3	The third subtotal amount calculated for the charge line.
BillSubtotal4	The fourth subtotal amount calculated for the charge line.
BillSubtotal5	The fifth subtotal amount calculated for the charge line.
BillSubtotal6	The sixth subtotal amount calculated for the charge line.
BillSubtotal7	The seventh subtotal amount calculated for the charge line.
BillSubtotal8	The eighth subtotal amount calculated for the charge line.
BillSubtotal9	The ninth subtotal amount calculated for the charge line.
BilledAmount	The billed amount for the charge line.
BilledQuantity	The billed quantity for the charge line.
ChargeDefinition	The charge definition of the subscription charge. This must match with pricing definition.
ChargeDefinitionId	The unique identifier of the usage charge definition.
ChargeId	The identifier of the subscription charge.
ChargeLineId	The identifier of the usage charge line.
ChargeLineNumber	The charge line number of the usage charge line.
ChargeLineSequence	The charge line sequence of the usage charge line.
ChargePeriodFactor	The charge period factor of the usage charge line.
CopiedFromSourceAdjAmount	The adjustment amount copied from the source transaction.
CpiAdjAmount	The CPI-based adjustment amount applied to the bill line.
CreatedBy	The user who created the charge line.
CreationDate	The date when the charge line was created.
CurrencyCode	The currency code of charge line.
EndDate	The end date of charge line.
ExtendedAmount	The extended amount of the charge line.
LastUpdateDate	The date when the charge line was last updated.
LastUpdateLogin	The login of the user who last updated the charge line.
LastUpdatedBy	The user who has last updated the charge line.
ManualAdjListPrice	The manually adjusted list price applied to the charge line.
ManualPriceAdjAmount	The manual price adjustment amount applied to the charge line.
NetUnitPrice	The net unit price of the charge line.
ObjectVersionNumber	The object version number of the charge line.
OrigSubscriptionProductPuid	The original subscription product unique identifier of the charge line.
PeriodEndDate	The period end date of the charge line.
PeriodStartDate	The period start date of the charge line.
PrevBilledAmount	The previously billed amount for the charge line.
PreviousChargePeriodFactor	The previously charge period factor for the charge line.
PreviousEndDate	The previous end date for the charge line.
PricingTermAdjAmount	The pricing term adjustment amount applied to the charge line.
ProductChangeSequenceNumber	The product charge sequence number of the charge line.
RatingModel	The rating model of the charge line.
RenewalSequenceNumber	The renewal sequence number of the charge line.
ReportedQuantity	The reported quantity of the charge line.
RequestId	The request identifier of the charge line.
RoundedQuantity	The rounded quantity of the charge line.
StartDate	The start date of the charge line.
SubscriptionId	The subscription identifier of the charge line.
SubscriptionProductId	The subscription product identifier of the charge line.
SummarizedRatingFlag	Indicates whether the events are eligible for summarized rating.
SystemAdhocPriceAdjAmount	The system-generated ad-hoc price adjustment amount for the charge line.
SystemPriceAdjAmount	The system price adjustment amount applied to the charge line.
SystemVolumePriceAdjAmount	The system volume price adjustment amount applied to the charge line.
TrueupAmount	The true up amount of the charge line.
TrueupQuantity	The true up quantity of the charge line.
UnbilledAmount	The unbilled amount of the charge line.
UnbilledQuantity	The unbilled quantity of the charge line.
UnitPrice	The unit price of the charge line.
UsageQuantity	The usage quantity of the charge line.
UsageUom	The usage unit of measure of the charge line.
VolRebateSurchargeAmount	The volume rebate surcharge amount applied to the charge line.
VolumePriceAdjAmount	The volume price adjustment amount applied to the charge line.