Connector Improvement: Fivetran Zuora revenue tables
AnsweredHi Team,
Since the Zuora revenue connector is still in beta, we are expecting to see the tables below from the Zuora revenue connection. We wanted to make sure all these tables/views are accessable by the Fivetran connector
REVENUECALENDAR: Contains the details of the accounting calendar that are configured in Zuora Revenue.
REVENUECONTRACT: Contains the details of distinct revenue contracts (RC) based on the defined RC grouping template.
REVENUECONTRACTACCOUNTINGENTRIES: Contains the accounting entries / journal entries of every transaction based on its performance obligation template.
REVENUECONTRACTACCOUNTINGSEGMENTS: Contains the Accounting segments details for deferring and releasing segments of every accounting entry.
REVENUECONTRACTACCOUNTINGTYPE: Contains the accounting type details of every Accounting entries.
REVENUECONTRACTACTIONS: Contains the details of every revenue contract POB's release and deferral actions thats are taken by both the system and manual operation.
REVENUECONTRACTAPPROVALS: Contains the details of revenue contract approvals and their history.
REVENUECONTRACTBILLSDIMENSIONS: Contains the billing transaction dimensional details, which include transaction types such as INV, CM, CM-R, CM-C, CM-RO, and RORD.
REVENUECONTRACTBILLSFACTS: Contains the billing transaction fact, which includes transaction types such as INV, CM, CM-R, CM-C, CM-RO, and RORD.
REVENUECONTRACTCOSTDIMENSIONS: Contains the cost transaction dimensional details of both standard standard and user-defined cost.
REVENUECONTRACTCOSTFACTS: Contains the cost transaction fact, which includes both standard and user-defined costs.
REVENUECONTRACTHOLDS: Contains the details of revenue contract hold at all the line level, POB level, and Revenue Contract level.
REVENUECONTRACTLINESDIMENSIONS: Contains the sales order transaction dimensional details.
REVENUECONTRACTLINESFACTS: Contains the sales order transaction fact details.
REVENUECONTRACTMJENTRIESDIMENSIONS: Contains the manual journal transaction dimensional details.
REVENUECONTRACTMJENTRIESFACTS: Contains the Manual journal transaction fact details.
REVENUECONTRACTVCDIMENSIONS: Contains the variable consideration (VC) transaction dimensional details of both standard and user-defined VC.
REVENUECONTRACTVCFACTS: Contains the variable consideration transaction fact, which includes both standard and user-defined VC.
REVENUEPERIODS: Contains the open period details.
REVENUECONTRACTNETTINGSTATUS: Contains period-wise contract's asset/liability position of the revenue contract. This is applicable if you are using CA/CL Netting in Zuora Revenue.
REVENUEACCOUNTINGSUMMARY - This object provides the calculated fields such as the opening balance, additions, releases, activity, and ending balances for the various schedule types & account segment values. The balances are maintained period-wise at a Revenue Contract line level. With this object, you can easily create revenue reports in the data warehouse.
RCROLLFORWARDDETAILS - Use this object to access the Roll forward report directly from your data warehouse.
Ref similar feature: https://support.fivetran.com/hc/en-us/community/posts/35441484694679-Connector-Improvement-Fivetran-Zuora-revenue-tables
-
Official comment
Hi Syed,
Thank you for your feature request regarding the Fivetran Zuora revenue tables. We have merged your request with an existing one to streamline our process. You can follow updates and developments on this feature request here: [Connector Improvement: Fivetran Zuora revenue tables]. We appreciate your input and encourage you to check the link for any progress or updates.
Best,
Sandeep
Please sign in to leave a comment.
Comments
1 comment