Skip to main content

Delivery Adjustment data source

Zuora

Delivery Adjustment data source

Use this data source to export data about delivery adjustment for the Delivery Pricing charge model, including information such as adjustment amount, associated subscription and charge, and reason for the adjustment.

Data Source

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

Data Source Detail

Base Object Description

Descriptions for the base Zuora object.

Zuora Object Description
Delivery Adjustment

This is the base Zuora object for the Delivery Adjustment data source export and includes the following fields:

  • Account ID: The account ID for which the adjustment is created. The account ID indicates the subscription owner.
  • Accounting Code
  • Adjustment Date: The date that the delivery adjustment is created against.
  • Adjustment Number: The unique human readable number of the delivery adjustment.
  • Amount: The value equals the Amount Per Unit multiplied by the Number Of Deliveries and then by -1, where the Number Of Deliveries is always 1.
  • Amount Per Unit: The amount for each delivery adjustment. Reserved for future use.
  • Billing Date: The date when the associated Credit Memo is created.
  • Charge ID: The charge ID in the subscription for which the adjustment needs to be created.
  • Charge Number: The charge number in the subscription for which the adjustment needs to be created.
  • Created By ID: The account that creates the delivery adjustment.
  • Created Date:  The date when the delivery adjustment is created.
  • Credit Memo Number: The Credit Memo generated for the delivery adjustment.
  • Debit Memo Number: The Debit Memo generated for the cancelled delivery adjustment.
  • Deferred Accounting Code: The accounting code for the deferred revenue, such as Monthly Recurring Liability.
  • Delivery Day: The day of the week that the delivery adjustment is against.
  • ID: The ID of the delivery adjustment.
  • Invoice Owner Account ID:  The invoice owner of the subscription.
  • Memo Number: The number of the credit memo that is associated with the delivery adjustment.
  • Original Subscription ID
  • Number Of Deliveries: The total number of all delivery adjustments. The value is 1. Reserved for future use.
  • Reason: The reason for the adjustment.
  • Recognized Revenue Accounting Code: The accounting code for the recognized revenue, such as Monthly Recurring Charges or Overage Charges.
  • Revenue Recognition Rule Name: The name of the revenue recognition rule governing the revenue schedule.
  • Segment ID: The charge segment ID.
  • Status: The status of the delivery adjustment. The value is either Billed or Cancelled.
  • Subscription ID: The subscription ID for which the adjustment is created.
  • SubscriptionNumber - The subscription number for which the adjustment is created.
  • Type: The type of adjustment. The value is DeliveryCredit.
  • Updated By ID: The account that updates the delivery adjustment.
  • Updated Date: The date when the delivery adjustment is updated.

Related Object Descriptions

Descriptions for related Zuora objects are listed in alphabetical order.

Zuora Object Description
Account The account that made the payment.
Bill To The Bill-To Contact of the Account.
Default Payment Method

The default payment method used to make payments.

Entity

The entity that the data relates to. Part of the Multi-entity feature. Contains the following fields:

  • Address 1
  • Address 2
  • City
  • Country
  • Created By ID
  • Created Date
  • Display Name
  • Email
  • ID
  • Name
  • Postal Code
  • State
  • Updated By ID
  • Updated Date
Parent Account

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

Rate Plan

Refers to the rate plan or pricing plan information associated with the subscription. Contains the following fields:

  • Amendment Type: Note that a filter on this field using the unequal operator cannot return those Rate Plan records with a blank Amendment Type field. 
  • Created By ID
  • Created Date
  • Externally Managed Plan ID: a text field. This field indicates the unique identifier of a rate plan purchased on a third-party store.
  • ID
  • Invoice Owner ID: the invoice owner ID of the subscription that contains the rate plan
  • Name
  • Original Rate Plan ID: the original ID of the subscription rate plan, which is the ID of the subscription rate plan in the version-1 subscription
  • Subscription Owner ID: the subscription owner ID of the subscription that contains the rate plan
  • Subscription Rate Plan Number
  • Updated By ID
  • Updated Date
Rate Plan Charge

The charge information associated with the subscription. Contains the following fields:

  • Accounting Code
  • Apply Discount To
  • Bill Cycle Day
  • Bill Cycle Type
  • Billing Period
  • Billing Period Alignment
  • Billing Timing
  • Charge Model
  • Charge Number
  • Charge Type
  • Charged Through Date
  • Created By ID
  • Created Date
  • DMRC
  • DTCV
  • Description
  • Discount Level
  • Effective End Date
  • Effective Start Date
  • End Date Condition
  • ID
  • Invoice Owner ID: the invoice owner ID of the subscription that contains the rate plan charge
  • Is Last Segment
  • Is Processed
  • List Price Base
  • MRR
  • Name
  • Number of Periods
  • Original ID
  • Overage Calculation Option
  • Overage Unused Units Credit Option
  • Price Change Option
  • Price Increase Percentage
  • Processed Through Date
  • Quantity
  • Rating Group
  • Revenue Recognition Code
  • Revenue Recognition Rule Name
  • Revenue Recognition Trigger Condition
  • Segment
  • Specific Billing Period
  • Specific End Date
  • Subscription Id: the ID of the subscription that contains the rate plan charge
  • Subscription Owner ID: the subscription owner ID of the subscription that contains the rate plan charge
  • TCV
  • Trigger Date
  • Trigger Event
  • Unit of Measure
  • Up To Periods
  • Up To Periods Type
  • Updated By ID
  • Updated Date
  • Version
  • Weekly Bill Cycle Day
Sold To The Sold-To Contact of the Account.
Subscription

The subscription to which the rate plan is associated. Contains the following fields:

  • Auto Renew
  • Cancelled Date
  • Contract Acceptance Date
  • Contract Effective Date
  • Cpq Bundle Json ID
  • Created By ID
  • Created Date
  • Creator Account ID
  • Creator Invoice Owner ID
  • Current Term
  • Current Term Period Type
  • ID
  • Initial Term
  • Initial Term Period Type
  • Invoice Owner ID
  • Invoice Separate
  • Name
  • Notes
  • Opportunity Close Date
  • Opportunity Name
  • Original Created Date
  • Original ID
  • Previous Subscription ID
  • Quote Business Type
  • Quote Number
  • Quote Type
  • Renewal Setting
  • Renewal Term
  • Renewal Term Period Type
  • Service Activation Date
  • Status
  • Subscription End Date
  • Subscription Start Date
  • Term End Date
  • Term Start Date
  • Term Type
  • Updated By ID
  • Updated Date
  • Version