Skip to main content

Order Action Data Source

Zuora

Order Action Data Source

Use this data source to report on the actions to be applied to the subscription in a given order. Examples of order action types would be New Subscription, Update Product, New Product, etc. See Order Actions for more information.

The following objects are available in the data source.

Object Description
Order Action

Contains the following fields:

  • Auto Generated - Customers using Order Harmonization can use this field to determine whether an order action is automatically generated by the system or created through the Create an order operation(or Orders UI). Possible values for the field are:
    • TRUE: The order action is automatically generated by the system as a result of a subscription or amendment created through the Subscribe and Amend APIs and UI.
    • FALSE: The order action is created through the "Create an order" operation or Orders UI.
  • Auto Renew
  • Cancellation Effective Date - When the Cancellation Policy field is set to SpecificDate, you need to use this field to set the specific cancellation date. Otherwise, leave this field empty.
  • Cancellation Policy
  • Clearing Existing Bill To Contact
  • Clearing Existing Payment Term
  • Contract Effective Date
  • Created By ID
  • Created Date
  • Current Term
  • Current Term Period Type
  • Customer Acceptance Date
  • ID
  • Payment Term
  • Renewal Setting
  • Renewal Term
  • Renewal Term Period Type
  • Resume Date
  • Sequence
  • Service Activation Date
  • Suspend Date
  • Term Start Date
  • Term Type
  • Type
  • Updated By ID
  • Updated Date
  • Custom Fields

Subscription

The subscription to which the rate plan is associated. Contains the following fields:

  • Auto Renew
  • Cancelled Date
  • Contract Acceptance Date
  • Contract Effective Date
  • Cpq Bundle Json ID
  • Created By ID
  • Created Date
  • Creator Account ID
  • Creator Invoice Owner ID
  • Current Term
  • Current Term Period Type
  • ID
  • Initial Term
  • Initial Term Period Type
  • Invoice Owner ID
  • Invoice Separate
  • Name
  • Notes
  • Opportunity Close Date
  • Opportunity Name
  • Original Created Date
  • Original ID
  • Previous Subscription ID
  • Quote Business Type
  • Quote Number
  • Quote Type
  • Renewal Setting
  • Renewal Term
  • Renewal Term Period Type
  • Service Activation Date
  • Status
  • Subscription End Date
  • Subscription Start Date
  • Term End Date
  • Term Start Date
  • Term Type
  • Updated By ID
  • Updated Date
  • Version
Subscription Version Amendment

The amendment that is responsible for creating the particular subscription version. This amendment corresponds directly to the Order object. If you have the Orders feature enabled, the Subscription Version Amendment object is not available; you should use the Order object instead.

Order

The order you want to view the order action information for.

Account

The customer account information. Note this is the Invoice Owner account.

Add Rate Plan

Refers to the rate plan or pricing plan information associated with the Add Product order action.

For complete information about ChangePlan (that is, removing the old rate plan and adding a new one), you need to view the "Remove Rate Plan" joined object and this joined object.

Contains the following fields:

  • Amendment Type: Note that a filter on this field using the unequal operator cannot return those Rate Plan records with a blank Amendment Type field. 
  • Created By ID
  • Created Date
  • Externally Managed Plan ID: a text field. This field indicates the unique identifier of a rate plan purchased on a third-party store.
  • ID
  • Invoice Owner ID: the invoice owner ID of the subscription that contains the rate plan
  • Name
  • Subscription Owner ID: the subscription owner ID of the subscription that contains the rate plan
  • Updated By ID
  • Updated Date
Bill To 

The contact associated with the account to whom your product or service is billed.

Order Action Bill To The bill to contact that is specified at subscription level during creating order action: CreateSubscription, Renewal or TermsAndConditions order action.
Default Payment Method

The default payment method used to make payments.

Parent Account

Refers to the parent account associated with the customer account, if applicable.

Remove Rate Plan

Refers to the rate plan or pricing plan information associated with the Remove Product order action.

For complete information about ChangePlan (that is, removing the old rate plan and adding a new one), you need to view this joined object and the “Add Rate Plan” joined object.

Contains the following fields:

  • Amendment Type: Note that a filter on this field using the unequal operator cannot return those Rate Plan records with a blank Amendment Type field. 
  • Created By ID
  • Created Date
  • Externally Managed Plan ID: a text field. This field indicates the unique identifier of a rate plan purchased on a third-party store.
  • ID
  • Invoice Owner ID: the invoice owner ID of the subscription that contains the rate plan
  • Name
  • Subscription Owner ID: the subscription owner ID of the subscription that contains the rate plan
  • Updated By ID
  • Updated Date
Sold To

The contact associated with the account to whom your product or service is sold.

Subscription Bill To The bill-to contact of a subscription.
Subscription Bill To Snapshot A copy of the bill-to contact information of a subscription.
Subscription Owner Account The subscription owner of an order.
Subscription Owner Account Bill To The bill-to contact of an order's subscription owner.
Subscription Owner Account Sold To The sold-to contact of an order's subscription owner.
Subscription Status History

  The status history information of a subscription. Contains the following fields:

The Subscription Status History feature is in the Early Adopter phase. We are actively soliciting feedback from a small set of early adopters before releasing it as generally available. If you want to join this early adopter program, submit a request at Zuora Global Support.

  • Created By ID - The ID of the user who created the subscription.
  • Created Date - The date when the subscription was created.
  • End Date - The latest date that the status ends.
  • ID - The unique identifier of the subscription.
  • Sort Order - The chronological order of the subscription statuses.
  • Start Date - The effective start date of the status history.
  • Status - The status of the subscription.
  • Subscription Number - The subscription number that uniquely identifies each subscription.
  • Updated By ID - The ID of the user who last updated the subscription.
  • Updated Date - The date when the subscription was last updated.
Update Rate Plan

Refers to the rate plan or pricing plan information associated with the Update Product order action.

Contains the following fields:

  • Amendment Type: Note that a filter on this field using the unequal operator cannot return those Rate Plan records with a blank Amendment Type field. 
  • Created By ID
  • Created Date
  • Externally Managed Plan ID: a text field. This field indicates the unique identifier of a rate plan purchased on a third-party store.
  • ID
  • Invoice Owner ID: the invoice owner ID of the subscription that contains the rate plan
  • Name
  • Subscription Owner ID: the subscription owner ID of the subscription that contains the rate plan
  • Updated By ID
  • Updated Date