Subscription Bill Adjustments

The bill adjustments view object stores details about bill adjustments such as adjustment name, adjustment value, adjustment type, reason, effectivity.

Data Store Key : CrmAnalyticsAM.CrmExtractAM.OssBiccExtractAM.SubscriptionBillAdjustmentExtractPVO

Primary Keys : BillAdjustmentId

Initial Extract Date : CreationDate

Incremental Extract Date : LastUpdateDate

Attributes

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

Name	Description
AdjustmentAmount	The amount of the bill adjustment.
AdjustmentCategoryCode	The category or type of billing adjustment applied to the subscription. This helps classify and process adjustments during billing extraction.
AdjustmentName	The name of the bill adjustment.
AdjustmentReasonCode	The reason code of the bill adjustment.
AdjustmentStepSeqNum	The sequential step number of the billing adjustment. It indicates the order in which the adjustment was applied within the overall billing adjustment process.
AdjustmentType	The type of bill adjustment.
AdjustmentValue	The value of the bill adjustment.
AmountAfterAdjustments
AutoAdjustmentYn	Indicates if the bill adjustment is automatically adjusted or not.
BasisElement	The basis element of the bill adjustment.
BillAdjustmentId	The identifier of the bill adjustment.
BillAdjustmentPuid	The public unique identifier of the bill adjustment.
BillLineId	The identifier of the bill line to which this bill adjustment belongs.
ChargeAdjustmentId	The identifier of the charge adjustment.
ChargeKey	The key of the charge to which this bill adjustment belongs.
CreatedBy	The user who created this bill adjustment.
CreationDate	The date on which the bill adjustment was created.
EffectiveDayFrom	The date from which the bill adjustment is effective.
EffectiveDayTo	The date until when the bill adjustment is effective.
EffectiveMonthFrom	The month from which the bill adjustment is effective.
EffectiveMonthTo	The month until when the bill adjustment is effective.
Effectivity	The effectivity of the bill adjustment.
LastUpdateDate	The date on which the bill adjustment was last updated.
LastUpdateLogin	The session login of the user who last updated the bill adjustment.
LastUpdatedBy	The user who last updated the bill adjustment.
NumberOfPeriods	The number of periods for which the bill adjustment is applicable.
ObjectVersionNumber	The object version number of the bill adjustment.
PerPeriodFlag	Indicates if the billing adjustment is applied on a per-period basis.
PerQuantityFlag	Indicates if the billing adjustment is calculated based on the quantity of the subscribed item or usage.
PeriodFrom	The period from of the bill adjustment.
PeriodUntil	The period until of the bill adjustment.
Reason	The reason for the bill adjustment.
RevAdjFromDate	The revenue adjustment from date of the bill adjustment.
RevAdjToDate	The revenue adjustment to date of the bill adjustment.
RevenueOption	The revenue option of the bill adjustment.
RevenuePeriod	The revenue period of the bill adjustment.
SequenceNumber	The sequence number of the bill adjustment.
SubscriptionId	The unique identifier of the subscription associated with the bill adjustment.
SubscriptionProductId	The unique identifier of the subscription product associated with the bill adjustment.
ValidFrom	The valid from of the bill adjustment.
ValidUntil	The valid until of the bill adjustment.