Skip to main content

Booking data mapping

Zuora

Booking data mapping

The following table describes the field mappings between Zuora Billing and Zuora Revenue for the Booking Transaction object.

Booking Transaction Field Label Revenue Display Label
Unbilled Receivables Account Number Unbilled AR Account
Currency Code Transaction Currency
Subscription Version Subscription Version
Term Type Subscription Type
Subscription Term Start Date Subscription Term Start Date
Term Number Subscription Term Number
Subscription Term End Date Subscription Term End Date
Subscription Status Subscription Status
Subscription Start Date Subscription Start Date
Subscription Owner Account Name Subscription Owner
Subscription Number Subscription Name
Subscription Last Booking Date Subscription Last Book Date
Subscription ID Subscription ID
Subscription End Date Subscription End Date
Sold To State ID Sold To State
Sold To Country ID Sold To Country
Sold To City ID Sold To City
Skip CT Mod Flag Skip CT Mod Flag
Original Order Date Sales Order Date
Current Start Date Revenue Start Date
Contract Recognized Revenue Account Number Revenue Segments
Current End Date Revenue End Date
N/A Retain Line ID
Restrict SO Value Update Restrict SO Value Update
Is Unbilled Rc Unbill Flag
Sales Order Number Rc So Num
Sales Order Line Number Rc So Line Num
Sales Order Line ID Rc So Line ID
Original Order Date Rc So Date
Is Allocation Eligible Rc Cv Eligible Flag
Product Rate Plan Name Rate Plan Name
Rate Plan ID Rate Plan Id
Rate Plan Charge Version Rate Plan Charge Version
Revenue Recognition Timing Revenue Recognition Timing
Revenue Amortization Method Revenue Amortization Method
Charge Type Rate Plan Charge Type
Trigger Event Rate Plan Charge Trigger Event
Charge Through Date Rate Plan Charge Through Date
Charge Segment Rate Plan Charge Segment
Charge Number Rate Plan Charge Num
Product Rate Plan Charge Name Rate Plan Charge Name
Charge Model Rate Plan Charge Model
Rate Plan Charge ID Rate Plan Charge Id
Product Rate Plan ID Product Rate Plan Id
Product Rate Plan Charge ID Product Rate Plan Charge Id
Product Line Product Line
Product ID Product Id
Product Family Product Family
Product Class Product Class
Product Category Product Category
Parent Charge Segment Parent Charge Segment
Parent Charge Number Parent Charge Number
Original Term Start Date Original Term Start Date
Original Rate Plan Charge ID Original Rate Plan Charge Id
Original Charge Create Date Original Rate Plan Charge Created Date
Original Charge Segment Create Date Original Charge Segment Crt Date
Original Sales Order Line Item ID Orig SO Line ID
Original Order Date Orig Order Date
Current Quantity Ordered Qty
Order Number Order Id
Business Type Line Type
Item Name Line Item Num
Is Done Flag Is Done Flag
N/A Invoice Qty
Subscription Invoice Owner Account Name Invoice Owner
N/A Invoice Num
N/A Invoice Line Num
N/A Invoice Date
Global Fx Rate Global Ex Rate
Fx Rate Functional Ex Rate
Home Currency Code Functional Currency
Current CCV Ext Sell Price
Current ELP Ext List Price
Entity ID Entity Id
Contract Liability Account Number Deferred Segments
Customer Number Customer Number
Customer Name Customer Name
Contract Asset Account Number Contract Asset Account
Company Code Company Code
Charge/OLI Update Date Charge Last Update Date
Charge/OLI Create Date Charge Created Date
Organization Name Business Unit
N/A Avoid Overage
Discount Applied To Rate Plan Charge Number Applied RPC ID
Amendment Type Amendment Type
Amendment Reason Amendment Reason
Amendment Number Amendment Id
Amendment Create Date Amendment Created Date
Amended By Order On Amend By Order On
Adjustment Revenue Account Number Adjustment Revenue Account
Adjustment Revenue Account Number Adjustment Liability Account
Customer ID Account Id