Billing data mapping
Outlines the field mappings between Zuora Billing and Zuora Revenue for the Billing Transaction object, including a table of corresponding field labels.
The following table describes the field mappings between Zuora Billing and Zuora Revenue for the Billing Transaction object.
|
Billing Transaction Field Label |
Revenue Display Label |
|---|---|
|
Customer ID |
Account Id |
|
Adjustment Revenue Account Number |
Adjustment Liability Account |
|
Amendment Create Date |
Amendment Created Date |
|
Amendment Number |
Amendment Id |
|
Amendment Reason |
Amendment Reason |
|
Amendment Type |
Amendment Type |
|
Amended By Order On |
Amend By Order On |
|
Discount Applied To Rate Plan Charge Number |
Applied RPC ID |
|
Adjustment Revenue Account Number |
Adjustment Revenue Account |
|
Avoid Overage |
Avoid Overage |
|
Organization Name |
Business Unit |
|
Contract Asset Account Number |
Contract Asset Account |
|
Charge/OLI Create Date |
Charge Created Date |
|
Charge/OLI Update Date |
Charge Last Update Date |
|
Charge Through Date |
Rate Plan Charge Through Date |
|
Company Code |
Company Code |
|
Customer Name |
Customer Name |
|
Currency Code |
Transaction Currency |
|
Customer Number |
Customer Number |
|
Is Allocation Eligible |
Rc Cv Eligible Flag |
|
Contract Liability Account Number |
Deferred Segments |
|
Original Order Date |
Sales Order Date |
|
Current End Date |
Revenue End Date |
|
Entity ID |
Entity Id |
|
Current ELP |
Ext List Price |
|
Current CCV |
Ext Sell Price |
|
Home Currency Code |
Functional Currency |
|
Fx Rate |
Functional Ex Rate |
|
Global Fx Rate |
Global Ex Rate |
|
Subscription Invoice Owner Account Name |
Invoice Owner |
|
Document Date |
Invoice Date |
|
Document Line Number |
Invoice Line Num |
|
DocumentNumber |
Invoice Num |
|
DocumentQuantity |
Invoice Qty |
|
Is Done Flag |
Is Done Flag |
|
Item Name |
Line Item Num |
|
Order Number |
Order Id |
|
Current Quantity |
Ordered Qty |
|
Original Charge Create Date |
Original Rate Plan Charge Created Date |
|
Original Charge Segment Create Date |
Original Charge Segment Crt Date |
|
Original Order Date |
Orig Order Date |
|
Original Rate Plan Charge Id |
Original Rate Plan Charge Id |
|
Original Sales Order Line Item Id |
Orig SO Line ID |
|
Original Term Start Date |
Original Term Start Date |
|
Parent Charge Number |
Parent Charge Number |
|
Parent Charge Segment |
Parent Charge Segment |
|
Product Class |
Product Class |
|
Product Category |
Product Category |
|
Product Family |
Product Family |
|
Product Line |
Product Line |
|
Product ID |
Product Id |
|
Product Rate Plan ID |
Product Rate Plan Id |
|
Product Rate Plan Charge ID |
Product Rate Plan Charge Id |
|
Retain Line ID |
Retain Line ID |
|
Contract Recognized Revenue Account Number |
Revenue Segments |
|
Rate Plan |
Rate Plan Id |
|
Product Rate Plan Name |
Rate Plan Name |
|
Rate Plan Charge |
Rate Plan Charge Id |
|
Revenue Recognition Timing |
Revenue Recognition Timing |
|
Revenue Amortization Method |
Revenue Amortization Method |
|
Charge Model |
Rate Plan Charge Model |
|
Product Rate Plan Charge Name |
Rate Plan Charge Name |
|
Charge Number |
Rate Plan Charge Num |
|
Charge Segment |
Rate Plan Charge Segment |
|
Trigger Event |
Rate Plan Charge Trigger Event |
|
Charge Type |
Rate Plan Charge Type |
|
Rate Plan Charge Version |
Rate Plan Charge Version |
|
Restrict SO Value Update |
Restrict SO Value Update |
|
metadataOrgId |
Security Value |
|
Skip CT Mod Flag |
Skip CT Mod Flag |
|
Original Order Date |
Rc So Date |
|
Sales Order Line ID |
Rc So Line ID |
|
Sales Order Line Number |
Rc So Line Num |
|
Sales Order Number |
Rc So Num |
|
Sold To City ID |
Sold To City |
|
Sold To Country ID |
Sold To Country |
|
Sold To State ID |
Sold To State |
|
Current Start Date |
Revenue Start Date |
|
Subscription End Date |
Subscription End Date |
|
Subscription ID |
Subscription ID |
|
Subscription Last Booking Date |
Subscription Last Book Date |
|
Subscription Number |
Subscription Name |
|
Subscription Owner Account Name |
Subscription Owner |
|
Subscription Start Date |
Subscription Start Date |
|
Subscription Status |
Subscription Status |
|
Term Number |
Subscription Term Number |
|
Subscription Term End Date |
Subscription Term End Date |
|
Subscription Term Start Date |
Subscription Term Start Date |
|
Term Type |
Subscription Type |
|
Subscription Version |
Subscription Version |
|
Business Type |
Line Type |
|
Unbilled Receivables Account Number |
Unbilled AR Account |
|
Is Unbilled |
Rc Unbill Flag |