Billing data mapping
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 |