Skip to main content

Billing Transaction data source

Zuora

Billing Transaction data source

Use the Billing Transaction data source to report on information for a given Billing Transaction. See Billing Transaction for more information about the Billing Transaction object.

The following objects are available in the data source.

Object Description
Billing Transaction

Information about the Billing Transaction.

This is the base object for the Billing Transaction Data Source Export. Contains the following fields:

  • Adjustment Liability Account ID
  • Adjustment Liability Account Name
  • Adjustment Liability Account Number
  • Adjustment Liability GL Account Name
  • Adjustment Revenue Account ID
  • Adjustment Revenue Account Name
  • Adjustment Revenue Account Number
  • Adjustment Revenue GL Account Name
  • Avoid Overage
  • Bill To City ID
  • Bill To Country ID
  • Bill To State ID
  • Booking Reference
  • Business Type: The type is INV for revenue standalone credit memo.
  • Charge Create Date
  • Charge Last Update Date
  • Charge Model
  • Charge Name
  • Charge Number
  • Charge Segment
  • Charge Through Date
  • Charge Type
  • Company Code
  • Contract Asset Account ID
  • Contract Asset Account Name
  • Contract Asset Account Number
  • Contract Asset GL Account Name
  • Contract Liability Account ID
  • Contract Liability Account Name
  • Contract Liability Account Number
  • Contract Liability GL Account Name
  • Contract Recognized Revenue Account ID
  • Contract Recognized Revenue Account Name
  • Contract Recognized Revenue Account Number
  • Contract Recognized Revenue GL Account Name
  • Created By ID
  • Created Date
  • Currency Code
  • Customer ID
  • Customer Name
  • Customer Number
  • Discount Applied To Rate Plan Charge Model ID
  • Discount Applied To Rate Plan Charge Number
  • Discount Applied To Rate Plan Charge Segment
  • Discount Applied To Rate Plan Charge Type ID
  • Document Date
  • Document ID
  • Document Line ID
  • Document Line Number
  • Document Number
  • Document Quantity
  • Document Type
  • End Date
  • Exclude Item Billing From Revenue Accounting
  • Exclude Item Booking From Revenue Accounting
  • Fx Rate
  • Global Fx Rate
  • Home Currency Code
  • ID
  • Invoice ID
  • Invoice Original Owner ID
  • Invoice Owner Name
  • List Price
  • Ordered Quantity
  • Organization Name
  • Original Invoice Line ID: The value is null for revenue standalone credit memo.
  • Original Rate Plan Charge ID
  • Original Sales Order Line Item ID: The value is null for revenue standalone credit memo.
  • Rate Plan Charge Version
  • Rate Plan Name
  • Retain Line ID
  • Revenue Recognition Timing
  • Revenue Amortization Method
  • Sales Order Line ID: The value is null for revenue standalone credit memo.
  • Sales Order Line Number
  • Sales Order Number
  • Sell Price
  • Sold To City ID
  • Sold To Country ID
  • Sold To State ID
  • Start Date
  • Subscription End Date
  • Subscription Name
  • Subscription Original Owner ID
  • Subscription Owner Name
  • Subscription Start Date
  • Subscription Status
  • Subscription Term End Date
  • Subscription Term Start Date
  • Subscription Version
  • Term Number
  • Term Type
  • Transaction Type
  • Trigger Event
  • Unbilled Receivables Account ID
  • Unbilled Receivables Account Name
  • Unbilled Receivables Account Number
  • Unbilled Receivables GL Account Name
  • Updated By ID
  • Updated Date
  • Zbill Ex Rate Date
Amendment

The change made to subscription. Contains the following fields:

  • Auto Renew
  • Code
  • Contract Effective Date
  • Created By ID
  • Created Date
  • Current Term
  • Current Term Period Type
  • Customer Acceptance Date
  • Description
  • Effective Date
  • ID
  • Name
  • Renewal Setting
  • Renewal Term
  • Renewal Term Period Type
  • Resume Date
  • Service Activation Date
  • Specific Update Date
  • Status
  • Subscription ID
  • Suspend Date
  • Term Start Date
  • Term Type
  • Type
  • Updated By ID
  • Updated Date
Bill To

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

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.

Product

The product information. Contains the following fields:

  • AllowFeatureChanges
  • Category
  • Created By ID
  • Created Date
  • Description
  • Effective End Date
  • Effective Start Date
  • ID
  • Name
  • NetSuite Integration ID
  • NetSuite Integration Status
  • NetSuite Item Type
  • NetSuite Sync Date
  • SKU
  • Updated By ID
  • Updated Date
Product Rate Plan

The rate plan coming from the product catalog. Contains the following fields:

  • Created By ID
  • Created Date
  • Description
  • Effective End Date
  • Effective Start Date
  • ID
  • Name
  • Updated By ID
  • Updated Date
Product Rate Plan Charge Charge information from the product catalog.
Rate Plan

Refers to the rate plan or pricing plan information associated 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
  • Subscription Owner ID: the subscription owner ID of the subscription that contains the rate plan
  • 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 contact associated with the account to whom your product or service is sold.

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
Subscription Owner

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

  • Account Balance
  • Account Number
  • Additional Email Addresses
  • Alllow Invoice Editing
  • Auto Pay
  • Bill Cycle Day Setting Option
  • Billing Batch
  • CMRR
  • CRM Account ID
  • CSR
  • CommunicationProfile ID
  • Created By ID
  • Created Date
  • Credit Balance
  • Currency
  • Default Payment Method ID
  • ID
  • Invoice Delivery Preferences Email
  • Invoice Delivery Preferences Print
  • Invoice Template ID
  • Last Invoice Date
  • Name
  • Notes
  • PO Number
  • Parent ID
  • Payment Gateway Name
  • Payment Term
  • Sales Rep
  • Sequence Set ID
  • Status
  • Tax Company Code
  • Tax Exempt Certificate ID
  • Tax Exempt Certificate Type
  • Tax Exempt Certificate Description
  • Tax Exempt Certificate Effective Date
  • Tax Exempt Certificate Entity/Use Code
  • Tax Exempt Certificate Expiration Date
  • Tax Exempt Certificate Issuing Jurisdiction
  • Tax Exempt Certificate Status
  • Total Debit Memo Balance
  • Total Invoice Balance
  • Unapplied Balance
  • Unapplied Credit Memo Amount
  • Updated By ID
  • Updated Date
  • VAT ID
  • account_index_a_picklist
Subscription Rate Plan

The rate plan of the subscription. Contains the following fields:

  • Amendment Type
  • Created By ID
  • Created date
  • Externally Managed Plan ID
  • ID
  • Invoice Owner ID
  • Name
  • RP_CF_1
  • RP_CF_2
  • RP_CF_3
  • RP_CF_4
  • RP_CF_5
  • RP_CF_6
  • RP_CF_7
  • RP_CF_8
  • RP_CF_9
  • Subscription Owner ID
  • Updated By ID
  • Updated Date
  • picklist