Skip to main content

Price Book Item - Data dictionary and Template

Zuora

Price Book Item - Data dictionary and Template

This article lists all the fields associated with the Price Book Item data dictionary. Read more on Price book items here

Note: Fields with an asterisk mark indicate mandatory fields. 

Name

Description

Value

IsNewPriceBookItem Marker Column TRUE,FALSE
Currency* A currency as defined in Billing Settings in the Zuora UI. A string of 3 characters(Required field)

 

Default Quantity

The default quantity of the price book item.

Decimal
Effective End Date

The effective end date of the offer.

Date(yyyy-MM-dd)
Effective Start Date

The effective start date of the price book item.

Date(yyyy-MM-dd)
Included Units The number of units included in the price book item. Decimal
List Base Price

The list price base of the price book item.

List Base Price values 

  • Per_Billing_Period,
  • Per_Month,
  • Per_Week,
  • Per_Year,
  • Per_Specific_Months
Offer Id The ID of the offer Alphanumeric Id
Offer Number The number of the offer that you want to associate the price book item with. Alphanumeric
Overage Price

The overage price of the price book item.

Decimal
Price The price of the price book item. Decimal
Product Charge Id* The ID of the product rate plan charge associated with the price book item. Alphanumeric Id
IsNewTier Marker Column TRUE,FALSE
Tiers Ending Unit

The ending unit of the tier.

Decimal
Tiers Price*

The price of the tier.

Decimal
Tiers Price Format

The price format of the tier.

Price values 

  • FlatFee,
  • PerUnit
Tiers Starting Unit* The starting unit of the tier. Decimal
Tiers Tier* The number of the tier.

Number

IsNewIntervalPrice Marker Column TRUE,FALSE
Interval Price Duration The duration of the interval.

Number

Interval Price Overage Price The overage price.

Decimal

Interval Price The price for the interval. Decimal
Interval Price Sequence* The sequence of the interval. Number
Interval Price Type* The type of the interval.

Price Type values 

  • Infinity,
  • Day,
  • Month
IsNewIntervalPriceTier Marker Column TRUE,FALSE
Interval Price Tiers Ending Unit

The ending unit of the tier.

Decimal
Interval Price Tiers Price*

The price of the tier.

Decimal
Interval Price Tiers Price Format

The price format of the tier.

Price Format values 

  • FlatFee,
  • PerUnit
Interval Price Tiers Starting Unit* The starting unit of the tier. Decimal
Interval Price Tiers Tier* The number of the tier.

Number

 

Data Dictionary Template
Price Book Item Price Books.numbers