Order Delta TCV - Data Query Use Case
This topic provides an example of performing queries on the Order Line Item object using Data Query, including creating an order with specific actions and retrieving TCV metrics.
You can perform queries on the Order Line Item object through Data Query. See the following example.
Example
You create an Order O-000001 containing the following order actions:
-
Add a rate plan with a recurring charge of $50 per month. The term starts on 1/1/2021 and ends on 12/31/2021. A 10% discount applies to the charge.
-
Remove the discount on 4/1/2021.
In this example, Zuora creates two TCV metrics for the same charge.
You can get a summary for the Order Delta Tcv metrics for the Order above using the following data query:
Select oa.Type, tcv.StartDate, tcv.EndDate, tcv.GrossAmount, tcv.NetAmount
From OrderDeltaTcv tcv
inner join OrderAction oa on tcv.orderActionId = oa.Id
Where tcv.orderNumber = ‘O-000001’The result is as in the following table:
|
Type |
Start Date |
End Date |
Gross Amount |
Net Amount |
|
AddProduct |
2021-01-01 |
2022-01-01 |
600 |
540 |
|
RemoveProduct |
2021-04-01 |
2022-01-01 |
-600 |
-540 |