Magento Business Intelligence Help Center

Expected Zuora data

BROUGHT TO YOU BY

Avatar

After the Zuora setup is complete, you'll see the following tables in your data warehouse. To see the attributes of each table, refer to Zuora's API documentation - click the table name to go there.  

Want to learn more about how the tables in your Zuora integration relate to each other? Check out Zuora's entity relationship diagram for more insight.

Account This table includes customer account information, including the account ID, customer's address, payment methods, terms, balance, and so on.
AccountingCode This table includes information relevant to the various accounting codes used in Zuora. Attributes include the accounting code category, GL account information, status, and type.
AccountingPeriod The Accounting Period table includes attributes such as the period's ID, start and end dates, fiscal year, name, and status.
Amendment Amendments are changes to customer subscriptions. This table records information about these changes, such as the amendment's ID, code, effective date, customer acceptance date, renewal setting, and more.
BillingRun The Billing Run table records information about ad hoc billing runs, including the billing run ID, account ID, batch information, charge type exclusions, execution date, invoice information, status, target date, and creation/update information.
CommunicationProfile A communication profile is a set of policies that determine how to communicate with the contacts associated with an account. This table records the profile ID, name, description, and creation information.
Contact The Contact table contains information about an account's point of contact, including the account ID, address, name, phone number, and email.
CreditBalanceAdjustment This table records information about changes to a customer's credit balance and includes the adjustment ID, account ID, accounting code, adjustment date, amount, reason code, source transaction information, and status.
Invoice The Invoice table includes the invoice ID, customer's account ID, adjustment amounts, invoice amount, pre-tax amount, balance, bill run ID, due date, one-time charge information, recurring charges, invoice date, payment amount, refund amount, posting information, source, status, and tax amount attributes.
InvoiceAdjustment An invoice adjustment modifies an existing invoice. This table contains information about these adjustments, including the ID, account ID, accounting code, adjustment date, amount, creation information, customer name, impact amount, reason code, status, and type.
InvoiceItem The Invoice Item table records information about individual line items in invoices. Attributes include the ID, accounting code, charge information, invoice ID, processing type, product information, subscription ID, and tax information.
InvoiceItemAdjustment This table records information about adjustments to line items in invoices such as the adjustment ID, account ID, accounting code, adjustment date, amount, invoice ID, reason code, source, status, and type.
InvoicePayment An invoice payment is just that - a payment applied to an invoice. Attributes of this table include the payment ID, amount, invoice ID, refund amount, and creation information.
InvoiceSplit A 'split' invoice is one of several invoices that once formed one original invoices. This table contains information about split invoices, such as the original invoice ID, the split invoice ID, and creation information.
InvoiceSplitItem Split invoice items refer to the individual line items contained in split invoices. Data in this table includes the split invoice item ID, invoice date, new invoice ID, payment term, and the split percentage.
JournalEntryItem The Journal Entry Item table records information about journal entries, including the journal entry item ID, amount, currency, type, accounting code, accounting period, detailed journal information, and creation/update information.
Payment The Payment table contains all the information related to customer payments, including the payment ID, account ID, accounting code, amount, application information, auth ID, effective date, gateway data, invoice data, payment method, settlement date, source, status, submission date, and type.
PaymentMethod Payment methods are the ways customers pay for their subscriptions. The Payment Method table records the various payment types such as check, PayPal, credit card, and so on. Attributes include the ID, account ID, and information specific to each payment type, depending on how the customer paid. Click the table name to see the full list of fields in this table.
PaymentMethodSnapshot The fields in this table are identical to those in the PaymentMethod table, which the exception of the Active, Created by ID, Created Date, Updated by ID, and Updated Date fields. Check out the PaymentMethod documentation (click the table name) for more information.
PaymentTransactionLog This table contains information about transaction logs sent from Zuora to the gateway for payment. Attributes include the payment transaction log ID, batch ID, gateway information, account, billing information, payment method, and creation/update information.
Product The Product table contains data about the products your company offers, including the product ID, category, description, effective start and end dates, SKU, and update information.
ProductRatePlan A product rate plan is the part of a product that your customers can subscribe to. This table records information about the product rate plans, including ID, active currencies, description, effective start and end dates, name, and product ID.
ProductRatePlanCharge Product rate plan charges are a charge model or a set of fees associated with a product rate plan. This table includes the ID, accounting code, discount information, billing and billing cycle information, charge type, end date condition, quantity information, overage information, product rate plan ID, tax information, trigger event, and more.
ProductRatePlanChargeTier This table holds the pricing information for product rate plan charges. Attributes include the ID, currency, discount information, price, product rate plan charge ID, tier, and more.
RatePlan A rate plan is a price or collection of prices for services. The RatePlan table contains the rate plan ID, name, amendment information, and product rate plan ID.
RatePlanCharge Rate plan charges are parts of a subscription or subscription amendment, which come from product rate plan charges. Attributes of this table include the rate plan charge ID, accounting code, billing cycle and period information, charge information, discount information, effective start and end dates,
RatePlanChargeTier Rate plan charge tiers are part of a subscription or amendment; it comes from a product rate plan charge tier. A rate plan charge tier contains the prices for a rate plan charge. This table includes the rate plan charge tier ID, pricing and overage information, rate plan charge ID, tier information, and creation/update information.
Refund Refunds are transactions where money is returned to the customer. The Refund table records information about these transactions such as the refund ID, account ID, accounting code, amount, cancellation information, processing and settlement information, refund method, reason code, refund date, status, type, and update information.
RefundInvoicePayment A refund invoice payment is a part of a refund that's being made against a payment that was applied to an invoice. Attributes in this table includes the refund invoice payment ID, refund amount, refund ID, and creation/update information.
RefundTransactionLog A refund transaction log is a record of all transactions related to refunds. This table includes the transaction log ID, batch ID, gateway information, and request and response strings.
RevenueChargeSummaryItem The Revenue Charge Summary Item table includes the ID, amount, currency, and creation/update information.
RevenueEventItem The Revenue Event Item table records information about revenue events. Attributes include the revenue event item ID, amount, currency, and creation/update information.
RevenueScheduleItem The Revenue Schedule Item contains information about revenue schedule items, including the revenue schedule item ID, amount, currency, ID, and creation/update information.
RevenueScheduleItemInvoiceItemAdjustment This table records information pertaining to revenue schedule item - invoice item adjustments. Attributes include the ID, amount, currency, and creation/update information.
RevenueScheduleItemInvoiceItem The Revenue Schedule Item Invoice Item table includes the ID, amount, currency, and creation/update information. Click the table name for a full list of related data points.
Subscription Subscriptions are products or services with recurring charges. The subscriptions table includes the subscription ID, account ID, renewal information, cancellation information, contract information, current term, term type, name, creation information, status, and version information.
TaxationItem The Taxation Item is used to add a tax amount to an invoice item. The Taxation Item table includes the Taxation Item ID, accounting code, exempt amount, invoice ID, invoice item ID, jurisdiction, location code, name, tax information, and creation/update information.
UnitOfMeasure Unit of measures are definable units that you measure when determining charges. If a subscription plan includes 5 licenses, then 5 is the quantity and the license is the unit that the quantity measures. This table records the Unit of Measure ID, name, status, decimal places, display value, rounding value, and creation/update information.
UpdaterDetail The Updater Detail table contains information about the Payment Method Updater, including the payment method, new payment method, and batch information.
Usage Usage is the amount of resources a customer uses. Attributes of this table include the usage ID, account ID, account number, charge information, description, invoice information, quantity, RBE (rating and billing engine) status, soucre information, start and end dates, subscription information, units of measure, and creation/update information.

 

Related

Was this article helpful?
0 out of 0 found this helpful

Comments

Powered by Zendesk