Skip to navigation
DataZuora ReportingData sources and exportsData source reference

Fulfillment data source

View as Markdown

Data source to report on information for a given fulfillment.

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

Accessing the data source

Navigation: Reporting > Data Sources and select Fulfillment as the data source.

Base object description

The following table provides descriptions for the base object.

Object

Description

Fulfillment

Information about the fulfillment.Contains the following fields:

  • Bill Target Date
  • Carrier
  • Created By ID
  • Created Date
  • Description
  • Exclude Item Billing From Revenue Accounting
  • Exclude Item Booking From Revenue Accounting
  • External Id
  • Fulfillment Date
  • Fulfillment Location
  • Fulfillment Number
  • Fulfillment System
  • Fulfillment Type
  • ID
  • Quantity
  • State
  • Tracking Number
  • Updated By ID
  • Updated Date

The following table provides descriptions for the related object.

Object

Description

Order Line Item

Information about the order line item with which the fulfillment is associated.Contains the following fields:

  • Accounting Code

  • Amended By Order On

  • Amount

  • Amount Per Unit

  • Amount Without Tax

  • Bill Target Date

  • Billing Rule

  • Created By ID

  • Created Date

  • Deferred Revenue Accounting Code

  • Description

  • 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.

  • 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.

  • ID

  • 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.

  • Inline Discount Type - Specifies the inline discount type, which can be Percentage, FixedAmount, or NoneUpdated Date

  • Item Category

  • Item Name

  • Item Number

  • Item State

  • Item Type

  • List Price

  • List Price Per Unit

  • Original Order Date

  • Original Oder Line Item Number

  • Original Order Number

  • Product Code

  • Product Rate Plan Charge ID

  • Purchase Order Number

  • Quantity

  • Quantity Available For Return

  • Quantity Fulfilled

  • Quantity Pending Fulfillment

  • Recognized Revenue Accounting Code

  • Related Subscription Number

  • Requires Fulfillment

  • Revenue Recognition Rule

  • Sold To Contact ID

  • Tax Code

  • Tax Mode

  • Transaction End Date

  • Transaction Start Date

  • UOM

  • Updated By ID