Import Omni Subscription - Data dictionary
Describes Data Loader's functionality and benefits in Zuora Tenant.
This article lists all the fields associated with the Omni Subscription data dictionary in Zuora.
Note: Fields with an asterisk mark indicate mandatory fields.
Name | Description | Value |
---|---|---|
Account Id* | The associated Zuora account id. It must be firstly created. | follow the rule of the current Zuora account ID |
External Product Id* | The product id in the external system. | varchar(500) |
External Subscription Id* | The original transaction id of the notification. | varchar(32) NOT NULL |
Auto Renew | The term type, true or false. | boolean |
Currency Code | currency code, 3 chars | |
External Activation Date | When the external subscription was activated on the external platform. UTC time, `yyyy-mm-dd hh:mm:ss`. | date time |
External Application Id | the application ID of the subscription recoreded in the third party system. | varchar(150) |
External Bundle Id | the bundle ID of the subscription recoreded in the third party system. | varchar(150) |
External Expiration Date | The expiresDate is a static value that applies for each transaction. UTC time, `yyyy-mm-dd hh:mm:ss`. | date time |
External In App Ownership Type | Such as purchased, family_shared. | varchar(30) |
External Last Renewal Date | the last renewal date of the subscription recoreded in the third party system. | date time |
External Next Renewal Date | the next renewal date of the subscription recoreded in the third party system. | date time |
External Price | The price of the product. | decimal(22,9) |
External Purchase Date | The App Store charged the user’s account for a purchase, restored product, subscription, or subscription renewal after a lapse. UTC time, `yyyy-mm-dd hh:mm:ss`. | date time |
External Purchase Type | varchar(30) | |
External Quantity | The quantity of the product. Must be >= 0. | int |
External Replace By Product Id | The productId is going to replace the existing productId. | varchar(500) |
External Source System | For example, Apple, Google, Roku, Amazon. | varchar(100) NOT NULL |
External State | The original status from client, such as active, canceled, expired, pastDue. | varchar(100) |
External Subscriber Id | The subscriber ID from client. | varchar(150) |
External Transaction Reason | The latest transaction reason. | varchar(100) |
State | The common external subscription state. | varchar(30) |