home

Zuora Billing

Zuora BillingZuora PaymentsZuora PlatformZuora CPQZephrZuora RevenueAccounts ReceivableRelease NotesBasicsEntitlementsSupport and policies
Zuora BillingZuora PaymentsZuora PlatformZuora CPQZephrZuora RevenueAccounts ReceivableRelease NotesBasicsEntitlementsSupport and policies

Welcome to Zuora Product Documentation

Explore our rich library of product information

Show Contents

thumbnailZuora Billing

Prepaid with Drawdown

Query the Prepaid with Drawdown objects through Data Query

Learn how to query Prepaid Balance, Prepaid Balance Fund, and Prepaid Balance Transaction objects using SQL examples through Data Query.

You can perform queries on the Prepaid Balance, Prepaid Balance Fund, Prepaid Balance Transaction objects through the Data Query.

SQL examples for querying the Prepaid with Drawdown objects

To query the Prepaid with Drawdown objects, you can use the following SQL examples:

  • Query the Prepaid Balance object by using the OrigSubscriptionId field: 

    select Id,Name,Balance,TotalFund,StartDate,EndDate,OrigSubscriptionId,UOM from prepaidbalance 
where OrigSubscriptionId='402881847e2d707b017e2d76c48a0016'

  • Query the Prepaid Balance object by using the Name field: 

    select Id,Name,TotalFund,Balance,UOM 
from prepaidbalance
where Name ='A-S00000037_Each'

  • Query the Prepaid Balance Fund object by using the PrepaidBalanceId field: 

    select id,PrepaidBalanceId,FundedBalance,Balance,StartDate,EndDate,FundSourceType 
from prepaidbalancefund
where PrepaidBalanceId='402881847e2d707b017e2d76c8ae002f'

  • Query the Prepaid Balance Transaction object by using the FundId field: 

    select id,PrepaidBalanceId,FundId,Amount,Balance,TransactionDate,PrepaidBalanceTransactionType 
from PrepaidBalanceTransaction 
where FundId='402881847e2d707b017e2d76c8b80030'

Last updated: October 24, 2025