Order Delta Quantity
The order delta quantity is the difference between the total product quantity after the order and the quantity before the order for various order actions, including Renewal, Add Product, Remove Product, and Update Product.
This topic lists examples of calculating Order Delta Quantity metrics for different order actions.
In the following example, the order delta quantity for charge segment PRC-2 between 2025-01-01 and 2026-01-01 for the Renewal order action is 20.
In the following example, the order delta quantity for charge segment PRC 2-1 between 2025-07-01 and 2026-01-01 for the Add Product order action is 15.
In the following example, the order delta quantity for charge segment PRC-2 between 2025-07-01 and 2026-01-01 for the Remove Product order action is -20.
In the following example, for the Update Product order action, the order delta quantity for charge segment PRC-2 between 2025–07-01 and 2026-01-01 is -20 due to the shrinking of the rate plan, and the order delta quantity for charge segment PRC-3 between 2025–07-01 and 2026-01-01 is 15 due to the updated quantity.
The Order Delta Quantity object can be accessed through Data Query with the following fields.
|
Field Name |
Description |
|
Id |
The internal ID of the order delta metrics. |
|
OrderNumber |
The Order number for the associated Order. |
|
StartDate |
The Start Date of the metric. This is also the start date of the period where there is an impact on the metrics caused by the order. |
|
EndDate |
The End Date of the metric. This is also the end date of the period where there is an impact on the metrics caused by the order. The End Date is exclusive. |
|
Quantity |
The delta quantity for each charge segment for each order action. |
|
ChargeNumber |
The charge number of rate plan charge object that the metrics is associated with. |
|
RatePlanChargeId |
The id of the rate plan charge object that the metrics is associated with. |
|
ProductRatePlanChargeId |
The id of the product plan charge object of the rate plan charge object. |
|
OrderActionId |
The Id of the associated Order Action that creates the metric |
|
OrderLineItemId |
The ID of the order line item. |
|
CreatedDate |
The date time when the metric is created. |
|
UpdatedDate |
The date time when the metric is last updated. |
|
deleted |
Indicates whether the metric is deleted. |