Billing Transaction data source

Last updated
Save as PDF

Use the Billing Transaction data source to report on information for a given Billing Transaction. See Billing Transaction for more information about the Billing Transaction object.

The following objects are available in the data source.

Object	Description
Billing Transaction	Information about the Billing Transaction. This is the base object for the Billing Transaction Data Source Export. Contains the following fields: Adjustment Liability Account ID Adjustment Liability Account Name Adjustment Liability Account Number Adjustment Liability GL Account Name Adjustment Revenue Account ID Adjustment Revenue Account Name Adjustment Revenue Account Number Adjustment Revenue GL Account Name Avoid Overage Bill To City ID Bill To Country ID Bill To State ID Booking Reference Business Type: The type is INV for revenue standalone credit memo. Charge Create Date Charge Last Update Date Charge Model Charge Name Charge Number Charge Segment Charge Through Date Charge Type Company Code Contract Asset Account ID Contract Asset Account Name Contract Asset Account Number Contract Asset GL Account Name Contract Liability Account ID Contract Liability Account Name Contract Liability Account Number Contract Liability GL Account Name Contract Recognized Revenue Account ID Contract Recognized Revenue Account Name Contract Recognized Revenue Account Number Contract Recognized Revenue GL Account Name Created By ID Created Date Currency Code Customer ID Customer Name Customer Number Discount Applied To Rate Plan Charge Model ID Discount Applied To Rate Plan Charge Number Discount Applied To Rate Plan Charge Segment Discount Applied To Rate Plan Charge Type ID Document Date Document ID Document Line ID Document Line Number Document Number Document Quantity Document Type End Date Exclude Item Billing From Revenue Accounting Exclude Item Booking From Revenue Accounting Fx Rate Global Fx Rate Home Currency Code ID Invoice ID Invoice Original Owner ID Invoice Owner Name List Price Ordered Quantity Organization Name Original Invoice Line ID: The value is null for revenue standalone credit memo. Original Rate Plan Charge ID Original Sales Order Line Item ID: The value is null for revenue standalone credit memo. Rate Plan Charge Version Rate Plan Name Retain Line ID Revenue Recognition Timing Revenue Amortization Method Sales Order Line ID: The value is null for revenue standalone credit memo. Sales Order Line Number Sales Order Number Sell Price Sold To City ID Sold To Country ID Sold To State ID Start Date Subscription End Date Subscription Name Subscription Original Owner ID Subscription Owner Name Subscription Start Date Subscription Status Subscription Term End Date Subscription Term Start Date Subscription Version Term Number Term Type Transaction Type Trigger Event Unbilled Receivables Account ID Unbilled Receivables Account Name Unbilled Receivables Account Number Unbilled Receivables GL Account Name Updated By ID Updated Date Zbill Ex Rate Date
Amendment	The change made to subscription. Contains the following fields: Auto Renew Code Contract Effective Date Created By ID Created Date Current Term Current Term Period Type Customer Acceptance Date Description Effective Date ID Name Renewal Setting Renewal Term Renewal Term Period Type Resume Date Service Activation Date Specific Update Date Status Subscription ID Suspend Date Term Start Date Term Type Type Updated By ID Updated Date
Bill To	The contact associated with the account to whom your product or service is billed.
Default Payment Method	The default payment method used to make payments.
Entity	The entity that the data relates to. Part of the Multi-entity feature. Contains the following fields: Address 1 Address 2 City Country Created By ID Created Date Display Name Email ID Name Postal Code State Updated By ID Updated Date
Parent Account	Refers to the parent account associated with the customer account, if applicable.
Product	The product information. Contains the following fields: AllowFeatureChanges Category Created By ID Created Date Description Effective End Date Effective Start Date ID Name NetSuite Integration ID NetSuite Integration Status NetSuite Item Type NetSuite Sync Date SKU Updated By ID Updated Date
Product Rate Plan	The rate plan coming from the product catalog. Contains the following fields: Created By ID Created Date Description Effective End Date Effective Start Date ID Name Updated By ID Updated Date
Product Rate Plan Charge	Charge information from the product catalog.
Rate Plan	Refers to the rate plan or pricing plan information associated the subscription. Contains the following fields: Amendment Type: Note that a filter on this field using the unequal operator cannot return those Rate Plan records with a blank Amendment Type field. Created By ID Created Date Externally Managed Plan ID: a text field. This field indicates the unique identifier of a rate plan purchased on a third-party store. ID Invoice Owner ID: the invoice owner ID of the subscription that contains the rate plan Name Subscription Owner ID: the subscription owner ID of the subscription that contains the rate plan Updated By ID Updated Date
Rate Plan Charge	The charge information associated with the subscription. Contains the following fields: Accounting Code Apply Discount To Bill Cycle Day Bill Cycle Type Billing Period Billing Period Alignment Billing Timing Charge Model Charge Number Charge Type Charged Through Date Created By ID Created Date DMRC DTCV Description Discount Level Effective End Date Effective Start Date End Date Condition ID Invoice Owner ID: the invoice owner ID of the subscription that contains the rate plan charge Is Last Segment Is Processed List Price Base MRR Name Number of Periods Original ID Overage Calculation Option Overage Unused Units Credit Option Price Change Option Price Increase Percentage Processed Through Date Quantity Rating Group Revenue Recognition Code Revenue Recognition Rule Name Revenue Recognition Trigger Condition Segment Specific Billing Period Specific End Date Subscription Id: the ID of the subscription that contains the rate plan charge Subscription Owner ID: the subscription owner ID of the subscription that contains the rate plan charge TCV Trigger Date Trigger Event Unit of Measure Up To Periods Up To Periods Type Updated By ID Updated Date Version Weekly Bill Cycle Day
Sold To	The contact associated with the account to whom your product or service is sold.
Subscription	The subscription to which the rate plan is associated. Contains the following fields: Auto Renew Cancelled Date Contract Acceptance Date Contract Effective Date Cpq Bundle Json ID Created By ID Created Date Creator Account ID Creator Invoice Owner ID Current Term Current Term Period Type ID Initial Term Initial Term Period Type Invoice Owner ID Invoice Separate Name Notes Opportunity Close Date Opportunity Name Original Created Date Original ID Previous Subscription ID Quote Business Type Quote Number Quote Type Renewal Setting Renewal Term Renewal Term Period Type Service Activation Date Status Subscription End Date Subscription Start Date Term End Date Term Start Date Term Type Updated By ID Updated Date Version
Subscription Owner	The owner of the subscription to which the rate plan is associated. Contains the following fields: Account Balance Account Number Additional Email Addresses Alllow Invoice Editing Auto Pay Bill Cycle Day Setting Option Billing Batch CMRR CRM Account ID CSR CommunicationProfile ID Created By ID Created Date Credit Balance Currency Default Payment Method ID ID Invoice Delivery Preferences Email Invoice Delivery Preferences Print Invoice Template ID Last Invoice Date Name Notes PO Number Parent ID Payment Gateway Name Payment Term Sales Rep Sequence Set ID Status Tax Company Code Tax Exempt Certificate ID Tax Exempt Certificate Type Tax Exempt Certificate Description Tax Exempt Certificate Effective Date Tax Exempt Certificate Entity/Use Code Tax Exempt Certificate Expiration Date Tax Exempt Certificate Issuing Jurisdiction Tax Exempt Certificate Status Total Debit Memo Balance Total Invoice Balance Unapplied Balance Unapplied Credit Memo Amount Updated By ID Updated Date VAT ID account_index_a_picklist
Subscription Rate Plan	The rate plan of the subscription. Contains the following fields: Amendment Type Created By ID Created date Externally Managed Plan ID ID Invoice Owner ID Name RP_CF_1 RP_CF_2 RP_CF_3 RP_CF_4 RP_CF_5 RP_CF_6 RP_CF_7 RP_CF_8 RP_CF_9 Subscription Owner ID Updated By ID Updated Date picklist