Billing data mapping
The following table describes the field mappings between Zuora Billing and Zuora Revenue for the Billing Transaction object.
If any text is larger than the limitation, Zuora Revenue will truncate the text.
| 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 |