Subscription Charge Adjustments
The adjustments view object stores details about the subscription charge adjustment such as adjustment name, adjustment type, adjustment value, adjustment reason and effectivity.
Data Store Key : CrmAnalyticsAM.CrmExtractAM.OssBiccExtractAM.SubscriptionChargeAdjustmentExtractPVO
Primary Keys : ChargeAdjustmentId
Initial Extract Date : CreationDate
Incremental Extract Date : LastUpdateDate
Attributes
This table provides the list of exposed attributes and their descriptions.
| Name | Description |
|---|---|
| AdjustmentCategoryCode | The category or type of billing adjustment applied to the subscription. This helps classify and process adjustments during billing extraction. |
| AdjustmentCurrency | The currency of the charge adjustment. |
| AdjustmentName | The name of the adjustment. |
| AdjustmentPricingError | The adjustment pricing error. |
| 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 adjustment type. The valid values are ORA_MARKUP_PERCENT, ORA_DISCOUNT_PERCENT, ORA_MARKUP_AMOUNT, ORA_MARKUP_AMOUNT, and ORA_PRICE_OVERRIDE. |
| AdjustmentValue | The value of the charge adjustment. |
| AutoAdjustmentYn | Indicates if the charge is automatically adjusted. |
| BasisElement | The basis element of the charge adjustment. |
| ChargeAdjustmentId | The charge adjustment identifier. |
| ChargeAdjustmentPuid | The public unique identifier of the charge adjustment. |
| ChargeDefinition | The charge definition of the charge adjustment. |
| ChargeDefinitionId | The identifier of the charge definition associated with the charge adjustment. |
| ChargeExternalKey | The charge external key of the charge adjustment. |
| ChargeId | The charge identifier of the charge adjustment. |
| ChargeParentEntity | The charge parent entity of the charge adjustment. |
| ChargeParentEntityId | The charge parent entity identifier of the charge adjustment. |
| ChargeRollupFlag | Indicates if the charge adjustment is rolled up. |
| CreatedBy | The user who created this subscription charge adjustment. |
| CreationDate | The date on which the subscription charge adjustment was created. |
| EffectiveDayFrom | The date from which the charge adjustment is effective. |
| EffectiveDayTo | The date until when the charge adjustment is effective. |
| EffectiveMonthFrom | The month from which the charge adjustment is effective. |
| EffectiveMonthTo | The month until when the charge adjustment is effective. |
| Effectivity | The effectivity of the charge adjustment. Valid values are ORA_ALL_TERM, ORA_FIRST_PERIODS, ORA_LAST_PERIODS, ORA_SPECIFIC_PERIODS, ORA_FIRST_FULL_PERIODS |
| ExternalAttributeChar1 | |
| ExternalAttributeChar2 | |
| ExternalAttributeChar3 | |
| ExternalAttributeNumber1 | |
| ExternalAttributeNumber2 | |
| ExternalAttributeNumber3 | |
| ExternalAttributeNumber4 | |
| ExternalAttributeNumber5 | |
| ExternalAttributeNumber6 | |
| ExternalAttributeTimestamp1 | |
| ExternalAttributeTimestamp2 | |
| ExternalAttributeTimestamp3 | |
| LastUpdateDate | The date on which the subscription charge adjustment was last updated. |
| LastUpdateLogin | The session login of the user who last updated the subscription charge adjustment. |
| LastUpdatedBy | The user who last updated the subscription charge adjustment. |
| NumberOfPeriods | The number of periods for which the charge adjustment is applicable. |
| ObjectVersionNumber | The object version number of the subscription charge adjustment. |
| PeriodFrom | The period from of the charge adjustment. |
| PeriodUntil | The period until of the charge adjustment. |
| PriceAdjustmentType | The type of price adjustment associated with the charge adjustment. |
| PriceBasisElement | The price basis element associated with the charge adjustment. |
| PricePeriodicity | The price periodicity of the charge adjustment. |
| Reason | The reason for the charge adjustment. |
| ReasonCode | The reason code associated with the charge adjustment. |
| SequenceNumber | The sequence number of the charge adjustment. |
| SourceObjectId | The source object associated with the charge adjustment on the subscription root resource. |
| SubscriptionId | The unique identifier of the subscription to which this subscription charge adjustment belongs. |
| SubscriptionProductId | The unique identifier of the subscription product to which this subscription charge adjustment belongs. |
| UsageUom | The usage UOM of the charge adjustment. |
| ValidFrom | The valid from of the charge adjustment. |
| ValidUntil | The valid until of the charge adjustment. |
| VersionType | The version type of the subscription charge adjustment. |