Subscription Balance Register Estimates

The estimates resource is used to view a register which displays the estimates records. These records are displayed only for those balance codes which have the estimate flag enabled.

Data Store Key : CrmAnalyticsAM.CrmExtractAM.OssBiccExtractAM.SubscriptionBalanceRegisterEstimateExtractPVO

Primary Keys : BalanceEstimateId

Initial Extract Date : CreationDate

Incremental Extract Date : LastUpdateDate

Attributes

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

Name	Description
ActualUsageAmount	The consumed amount of the subscription balance estimates.
ActualUsageFlag	Tracks the actual usage flag for the balance estimate line.
ActualUsageQuantity	The consumed quantity of the subscription balance estimates.
AdhocAdjEstimatedAmt	The ad-hoc adjusted estimated amount of the subscription balance estimates.
AdhocAdjEstimatedQty	The ad-hoc adjusted estimated quantity of the subscription balance estimates.
AdhocApplRolloverAmt	The ad-hoc applied rollover amount of the subscription balance estimates.
AdhocApplRolloverQty	The ad-hoc applied rollover quantity of the subscription balance estimates.
AdhocPriceAdjAmount	The ad-hoc price adjustment amount applied to the estimate line.
AdjustedEstimatedAmount	The adjusted estimated amount of the subscription balance estimates.
AdjustedEstimatedQuantity	The adjusted estimated quantity of the subscription balance estimates.
AdjustedListPrice	The adjusted list price used for the estimate line.
AdjustedPrice	The adjusted price calculated for the estimate line.
AdjustedUsageAmount	The adjusted usage amount of the subscription balance estimates.
AdjustedUsageQuantity	The adjusted usage quantity of the subscription balance estimates.
AdjustmentsNetPrice	The net price after applying all adjustments on the estimate line.
AllowanceAdjAmount	The allowance adjustment amount applied to the estimate line.
Amount	The amount of the subscription balance register estimates.
AppliedRolloverAmount	The applied rollover amount of the subscription balance estimates.
AppliedRolloverQuantity	The applied rollover quantity of the subscription balance estimates.
BalanceCodeId	The balance code identifier of the subscription balance register estimates.
BalanceCodeType	The balance code type for the subscription balance register estimates.
BalanceEstimateId	The balance register estimate identifier of the subscription balance register estimates.
BalanceEstimateNumber	The balance register estimate number of the subscription balance register estimates.
BalanceRegisterId	The balance register identifier of the subscription balance estimates.
BalanceRegisterPeriodId	The balance register period identifier of the subscription balance estimates.
BatchId	Tracks batch identifier which currently locked the Usage Event Batch.
BillAmount1	The first bill amount value associated with the estimate line.
BillAmount10	The tenth bill amount value associated with the estimate line.
BillAmount2	The second bill amount value associated with the estimate line.
BillAmount3	The third bill amount value associated with the estimate line.
BillAmount4	The fourth bill amount value associated with the estimate line.
BillAmount5	The fifth bill amount value associated with the estimate line.
BillAmount6	The sixth bill amount value associated with the estimate line.
BillAmount7	The seventh bill amount value associated with the estimate line.
BillAmount8	The eighth bill amount value associated with the estimate line.
BillAmount9	The ninth bill amount value associated with the estimate line.
BillInterfaceFlag	Indicates whether the bill line is interfaced.
BillLineId	The bill line identifier of the subscription balance estimates.
BillSequenceNumber	The bill line sequence number of the subscription balance estimates.
BillStatus	The bill line status of the subscription balance estimates.
BillSubtotal1	The first subtotal amount calculated for the estimate line.
BillSubtotal10	The tenth subtotal amount calculated for the estimate line.
BillSubtotal2	The second subtotal amount calculated for the estimate line.
BillSubtotal3	The third subtotal amount calculated for the estimate line.
BillSubtotal4	The fourth subtotal amount calculated for the estimate line.
BillSubtotal5	The fifth subtotal amount calculated for the estimate line.
BillSubtotal6	The sixth subtotal amount calculated for the estimate line.
BillSubtotal7	The seventh subtotal amount calculated for the estimate line.
BillSubtotal8	The eighth subtotal amount calculated for the estimate line.
BillSubtotal9	The ninth subtotal amount calculated for the estimate line.
BilledTrueupAmount	The billed true up amount of the subscription balance estimates.
BilledTrueupQty	The billed true up quantity of the subscription balance estimates.
BillingRequestId	The billing request identifier of the subscription balance estimates.
ChargeDefinitionId	The balance charge definition identifier of the subscription balance profile charges.
ChargeId	The charge identifier of the subscription balance estimates.
ChargeLineId	The charge line identifier of the subscription balance estimates.
ConsumptionFlag	Indicates whether the consumption is started.
CopiedFromSourceAdjAmount	The adjustment amount copied from the source transaction of the subscription balance estimates.
CpiAdjAmount	The CPI-based adjustment amount applied to the estimate line.
CreatedBy	The user who created the subscription balance estimate.
CreationDate	The date when the subscription balance estimate was created.
CurrencyCode	The currency code of the subscription balance estimates.
DeleteFlag	Indicates if the record is marked as soft deleted within the balance estimate.
EnableTrueupFlag	Indicates whether the true up is enabled.
EndDate	The end date of the subscription balance register estimates.
EntPlanEstimateId	The unique identifier of the subscription entitlement plan estimates.
EstimateConversionFactor	The estimate conversion factor of the subscription balance estimates.
EstimatePeriodNumber	The estimate period number of the subscription balance estimates.
EstimatePeriodicity	The estimate periodicity of the subscription balance estimates.
EstimateTrueupAmount	The estimate true up amount of the subscription balance estimates.
EstimateUsageFlag	Indicates whether the estimate usage is enabled.
EstimatedAmount	The estimated amount of the subscription balance register estimates.
EstimatedQuantity	The estimated quantity of the subscription balance register estimates.
EventId	The event identifier of the subscription balance estimates.
FinalizeTrueupFlag	Indicates whether the true up is finalized.
InitialConsumedAmount	The initial consumed amount of the subscription balance estimates.
InitialConsumedQuantity	The initial consumed quantity of the subscription balance estimates.
LastUpdateDate	The date when the subscription balance estimates was last updated.
LastUpdateLogin	The login of the user who last updated the subscription balance estimates.
LastUpdatedBy	The user who has last updated the subscription balance estimates.
ListPrice	The list price of the subscription balance estimates.
LockedBatchId	Tracks locked batch identifier which currently locked the Usage Event Batch.
ManualAdjListPrice	The manually adjusted list price applied to the estimate line.
ManualPriceAdjAmount	The manual price adjustment amount applied to the estimate line.
ObjectVersionNumber	The object version number updated after every update of a subscription balance estimates.
OverrideEstimatedAmount	The override estimated amount of true up estimate.
OverrideEstimatedQuantity	The override estimated quantity of true-up estimate.
OverrideUsageAmount	The override usage amount of true up estimate.
OverrideUsageQuantity	The override usage quantity of true up estimate.
ParentBillLineId	The unique identifier of the parent bill line that's linked to the balance estimate.
ParentEstimateId	The parent estimate identifier of true up estimate.
PeriodicityBaseUom	The periodicity base unit of measure of the subscription balance estimates.
PeriodicityConversionRate	The periodicity conversion rate of the subscription balance estimates.
PrevBilledAmount	The total previous billed amount of the subscription balance register estimates.
PrevBilledTrueupAmount	The true-up amount carried over from an earlier termination in the balance estimate.
PricingError	The pricing error of the estimate line.
PricingTermAdjAmount	The pricing term adjustment amount applied to the estimate line.
QuantityUom	The quantity unit of measure of true up estimate.
RatedAmount	The rating amount of the subscription balance register estimates.
RatingRequestId	The rating request identifier of the subscription balance register estimates.
RatingStatus	The rating status of the estimate line.
RelatedTrueupEstimateId	The related true up estimate identifier of the subscription balance register estimates.
RemainingEstimatedAmount	The remaining amount of the subscription balance estimates.
RemainingEstimatedQuantity	The remaining quantity of the subscription balance estimates.
RequestId	The unique identifier of the request of subscription balance estimates.
ReterminateFlag	Identifies if the estimate line has been terminated prior to its expected duration in the balance estimate.
RolloverEndDate	The rollover end date of the subscription balance estimates.
RolloverRemainingAmount	The rollover remaining amount of subscription balance estimates.
RolloverRemainingQuantity	The rollover remaining quantity of subscription balance estimates.
RolloverUsageAmount	The rollover usage amount of the subscription balance estimates.
RolloverUsageQuantity	The rollover usage quantity of the subscription balance estimates.
RollupEstimateFlag	Tracks the rollup estimate flag for the balance estimate line.
RollupProcessFlag	Tracks the rollup process flag for the given balance estimate.
RootBalanceBillFlag	Indicates whether the bill is tracked at the root balance bill line or if a new balance bill line is created for the given balance estimate.
RootBillLineId	The unique identifier of the root bill line linked to the balance estimate.
SequenceNumber	The sequence number of the subscription balance periods.
StartDate	The balance period start date of the subscription balance periods.
SubscriptionCurrency	The subscription currency associated with the balance estimate line.
SubscriptionId	The unique identifier of the subscription for the balance estimate line.
SubscriptionProductId	The unique identifier of the subscription product for the balance estimate line.
SystemAdhocPriceAdjAmount	The system-generated ad-hoc price adjustment amount for the balance estimate line.
SystemPriceAdjAmount	The system price adjustment amount for the balance estimate line.
SystemVolumePriceAdjAmount	The system volume price adjustment amount applied for the balance estimate line.
TerminatedEstimatedAmt	The terminated estimated amount of the subscription balance estimates.
TerminatedEstimatedQty	The terminated estimated quantity of the subscription balance estimates.
TotalUsageAmount	Tracks the total usage amount for the balance estimate line.
TotalUsageQuantity	Tracks the total usage quantity for the balance estimate line.
TrueupAmount	The true up amount of true-up estimate.
TrueupDate	The true up date of true up estimate.
TrueupHoldFlag	Indicates whether the true up hold is enabled.
TrueupProcessFlag	Tracks the true up process flag for the given balance estimate.
TrueupQuantity	Tracks the true up quantity for the balance estimate line.
TrueupReason	The true up reason of true up estimate.
TrueupReasonDescription	The true up reason description of true up estimate.
TrueupStatus	The true up status of true-up estimate.
TrueupType	The true up type of true up estimate.
TrueupUsageFlag	Indicates whether true-up for the usage is enabled.
UnbilledTrueupAmount	Tracks the unbilled true up amount for the balance estimate line.
UnbilledTrueupQty	Tracks the unbilled true up quantity for the balance estimate line.
UnsettledEstimatedAmount	Tracks the unsettled estimated amount for the balance estimate line.
UnsettledEstimatedQuantity	Tracks the unsettled estimated quantity for the balance estimate line.
VolRebateSurchargeAmount	The volume rebate surcharge amount applied to the balance estimate line.
VolumePriceAdjAmount	The volume price adjustment amount applied to the balance estimate line.