Welcome to Zuora Product Documentation

Explore our rich library of product information

A data source reporting example

Here is a data source reporting example

If we wanted to report on invoices, we could pick the Invoice data source. From the Invoice data source we can link each Invoice to an Account because each Invoice is tied to only one Account. One drawback of picking the Invoice data source, however, is that if you want more granular details, that is prohibited by the data object model where each base object has only one record, and each invoice can contain multiple invoice items. A selection of the Invoice data source would only allow us to construct the following table:

Account: Account Number

Invoice: Invoice Number

Invoice: Invoice Date

Invoice: Amount

A-00001

INV-00001

1/1/2015

100

A-00001

INV-00002

2/1/2015

100

A-00001

INV-00003

3/1/2015

100

On the other hand, if we choose the Invoice Item data source, we can link to Invoice, and, via Invoice, all the way back to Account. Each row in this data source represents one Invoice Item.

Account: Account Number

Invoice: Invoice Number

Invoice: Invoice Date

Invoice: Amount

Invoice Item: Charge Name

Invoice Item: Charge Amount

A-00001

INV-00001

1/1/2015

100

Monthly Platform Charge

80

A-00001

INV-00001

1/1/2015

100

Monthly Support Charge

20

A-00001

INV-00002

2/1/2015

100

Monthly Platform Charge

80

A-00001

INV-00002

2/1/2015

100

Monthly Support Charge

20

A-00001

INV-00003

3/1/2015

100

Monthly Platform Charge

80

A-00001

INV-00003

3/1/2015

100

Monthly Support Charge

20