Skip to main content

Order Line Item Data Source

Zuora

Order Line Item Data Source

The Order Line Items feature is now generally available to all Zuora customers. 

You need to enable the Orders feature to access the Order Line Items feature. Orders is generally available as of Zuora Billing Release 284 (August 2020). If you are an existing Zuora Subscribe and Amend customer and want to adopt Orders, see What is Orders Harmonization and join the Orders Harmonization community group for more information. If you want to enable Orders, submit a request at Zuora Global Support.

As of Zuora Billing Release 313 (November 2021), new customers who onboard on Orders will have the Order Line Items feature enabled by default. If you are a new customer who onboard on Orders Harmonization and want to enable the Order Line Items feature, submit a request at Zuora Global Support. If you are an existing Orders or Orders Harmonization customer and want to enable the Order Line Items feature, submit a request at Zuora Global Support.

Use the Order Line Item data source to report on information for a given Order Line Item. See Overview of Order Line Items for more information about the order line item.

The following objects are available in the data source.

Object Description
Order Line Item

Information about the order line item.

This is the base object for the Order Line Item Data Source Export. Contains the following fields:

  • ID
  • Created By ID
  • Created Date
  • Updated Date
  • Updated By ID
  • Item Name
  • Item Number
  • Description
  • Purchase Order Number
  • Product Code
  • Quantity
  • Amount Per Unit
  • Amount Without Tax
  • List Price
  • List Price Per Unit
  • Amount
  • Item Type
  • RelatedSubscriptionNumber
  • Transaction Start Date
  • Transaction End Date
  • Tax Code
  • Tax Mode
  • Bill Target Date
  • Item State
  • Deferred Revenue Accounting Code
  • Recognized Revenue Accounting Code
  • Accounting Code
  • Revenue Recognition Rule
  • UOM
  • Product Rate Plan Charge ID
  • Sold To Contact ID
Adjustment Liability Accounting Code

The accounting code for customers using Zuora Billing - Revenue Integration. Contains the following fields:

  • Category
  • Created By ID
  • Created Date
  • GL Account Name
  • GL Account Number
  • ID
  • Name
  • Notes
  • Status
  • Type
  • Updated By ID
  • Updated Date
Adjustment Revenue Accounting Code

The accounting code for customers using Zuora Billing - Revenue Integration. Contains the following fields:

  • Category
  • Created By ID
  • Created Date
  • GL Account Name
  • GL Account Number
  • ID
  • Name
  • Notes
  • Status
  • Type
  • Updated By ID
  • Updated Date
Account Information about the customer account that owns the order line item.
Bill To

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

Contract Asset Accounting Code

The accounting code for customers using Zuora Billing - Revenue Integration. Contains the following fields:

  • Category
  • Created By ID
  • Created Date
  • GL Account Name
  • GL Account Number
  • ID
  • Name
  • Notes
  • Status
  • Type
  • Updated By ID
  • Updated Date
Contract Liability Accounting Code

The accounting code for customers using Zuora Billing - Revenue Integration. Contains the following fields:

  • Category
  • Created By ID
  • Created Date
  • GL Account Name
  • GL Account Number
  • ID
  • Name
  • Notes
  • Status
  • Type
  • Updated By ID
  • Updated Date
Contract Recognized Revenue Accounting Code

The accounting code for customers using Zuora Billing - Revenue Integration. Contains the following fields:

  • Category
  • Created By ID
  • Created Date
  • GL Account Name
  • GL Account Number
  • ID
  • Name
  • Notes
  • Status
  • Type
  • Updated By ID
  • Updated Date
Default Payment Method

The default payment method used to make payments.

Order The order that contains the order line item.
Order Contact The order contact information.
Parent Account

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

Recognized Revenue Accounting Code

The accounting code. Contains the following fields:

  • Category
  • Created By ID
  • Created Date
  • GL Account Name
  • GL Account Number
  • ID
  • Name
  • Notes
  • Status
  • Type
  • Updated By ID
  • Updated Date
Sold To

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

Unbilled Receivables Accounting Code

The accounting code for customers using Zuora Billing - Revenue Integration. Contains the following fields:

  • Category
  • Created By ID
  • Created Date
  • GL Account Name
  • GL Account Number
  • ID
  • Name
  • Notes
  • Status
  • Type
  • Updated By ID
  • Updated Date