Skip to main content

Order Line Item Data Source

Zuora

Order Line Item Data Source

The Order Line Items feature is now generally available. You need to enable the Orders or Orders Harmonization feature to access the Order Line Items feature. 

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
  • Exclude Item Booking from Revenue - Specifies whether to exclude non-revenue related rate plan charges and order line items from syncing to Zuora Revenue. This field is only available if you have enabled Zuora Billing - Revenue Integration.
  • Exclude Item Billing from Revenue - Specifies whether to exclude non-revenue related invoice items, invoice item adjustments, credit memo items, and debit memo items from syncing to Zuora Revenue. This field is only available if you have enabled Zuora Billing - Revenue Integration.
  • Purchase Order Number
  • Product Code
  • Quantity
  • Amount Per Unit
  • List Price Per Unit
  • Amount
  • Inline Discount Type - Specifies the inline discount type, which can be PercentageFixedAmount, or None.
  • Inline Discount Per Unit - This field is used in accordance with the Inline Discount Type field, in the following manner:
    • If the Inline Discount Type field is set as Percentage, this field specifies the discount percentage for each unit of the order line item.
    • If the Inline Discount Type field is set as FixedAmount, this field specifies the discount amount on each unit of the order line item.
  • Discount - This field shows the total discount amount that is applied to an order line item after the Inline Discount Type and  Inline Discount Per Unit fields are set.
  • 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