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

wiki.page{path: "z_Source/dataSourceFD", heading: "2", section: "Amendment"}

Bill To

wiki.page{path: "z_Source/dataSourceFD", heading: "2", section: "Bill-To Contact"}

Default Payment Method

wiki.page{path: "z_Source/dataSourceFD", heading: "2", section: "Default Payment Method"}

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

wiki.page{path: "z_Source/dataSourceFD", heading: "2", section: "Parent Account"}

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

wiki.page{path: "z_Source/dataSourceFD", heading: "2", section: "Rate Plan Charge"}

Sold To

wiki.page{path: "z_Source/dataSourceFD", heading: "2", section: "Sold-To Contact"}

Subscription

wiki.page{path: "z_Source/dataSourceFD", heading: "2", section: "Subscription"}

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