ODBC Driver for NetSuite

Build 25.0.9434

revenuecommitment

Records revenue commitments, outlining contractual obligations for future revenue recognition based on service or product delivery.

Columns

Name Type References Description
accountingbook String The accounting book associated with this revenue commitment, which determines the set of financial reporting rules applied.
billaddress String The full billing address used for invoicing the customer, including street, city, state, and postal code.
billaddresslist String A reference to the predefined list of billing addresses available for the customer making this transaction.
billingaddress String The structured billing address for the transaction, stored separately from the shipping address.
billisresidential String Indicates whether the billing address is classified as a residential location, which can impact taxation and shipping fees.
class String A classification or categorization of the revenue commitment, often used for reporting or segmentation.
couponcode String The promotional or discount code applied to the transaction, reducing the total payable amount based on predefined rules.
createddate Datetime The exact date and time when this revenue commitment record was created in the system.
createdfrom String A reference to the original transaction or document from which this revenue commitment was generated.
currency String The currency in which the transaction is denominated, affecting exchange rate calculations and reporting.
currencyname String The full name of the currency used in the transaction, such as 'US Dollar' or 'Euro'.
currencysymbol String The symbol representing the currency of the transaction, such as '$' for USD or '€' for Euro.
customform String The specific custom form layout assigned to this revenue commitment for data entry and display purposes.
deferredrevenue Decimal The amount of revenue that has been deferred and recognized over time, typically related to subscription or service-based income.
department String The department within the organization associated with this revenue commitment, used for financial reporting and tracking.
discountamount Decimal The total monetary value of discounts applied to the transaction, reducing the overall revenue commitment amount.
discountdate Date The date by which the discount must be applied in order to be valid. Often linked to early payment discounts.
discountitem String The specific item or service associated with the applied discount, used for tracking and reporting purposes.
discountrate String The percentage or fixed amount by which the total transaction value is reduced as part of a discount.
discounttotal Decimal The cumulative value of all discounts applied to this transaction, impacting the final payable amount.
enddate Date The end date associated with the revenue commitment, often representing the conclusion of a contract or service period.
entity String The customer, vendor, or other business entity linked to this revenue commitment.
entitynexus String The tax nexus or jurisdiction associated with the entity, which determines applicable tax regulations.
exchangerate Decimal The exchange rate used to convert the transaction currency into the base currency for accounting and reporting.
externalid String A unique identifier (Id) for this revenue commitment used in external systems for integration or reference purposes.
fob String The Free On Board (FOB) terms of the transaction, which specify when ownership and responsibility of goods transfer.
isbasecurrency Boolean Indicates whether the transaction is recorded in the company's base currency 'true' or a foreign currency 'false'.
job String The project or job linked to this revenue commitment, allowing revenue tracking for specific work or contracts.
lastmodifieddate Datetime The date and time when this revenue commitment record was last updated, used for audit tracking and version control.
linkedtrackingnumbers String Tracking numbers associated with the revenue commitment, linking shipments or returns for reference.
location String The physical or virtual location where the transaction is recorded or processed. Can be a warehouse, store, or region.
memo String A text field allowing users to enter additional information or notes related to the revenue commitment for internal reference.
muccpromocodeinstance String the unique Id for a promotion code instance, linking the revenue commitment to a specific applied discount or offer.
nexus String The tax jurisdiction associated with this transaction, determining applicable tax rates based on company and customer location.
opportunity String Reference to a sales opportunity tied to this revenue commitment, indicating a prior lead or potential sale that materialized.
otherrefnum String An alternate reference number provided by the user or external system for tracking purposes, such as an order number.
partner String The business partner, reseller, or affiliate associated with this revenue commitment, playing a role in the transaction.
postingperiod String The financial period in which this revenue commitment is recorded, used for accounting and reporting purposes.
promocode String The promotional code applied to the transaction, potentially affecting pricing, discounts, or special offers.
promocodepluginimpl String The system implementation or logic governing the behavior of promotional codes applied to this revenue commitment.
recognizedrevenue Decimal The portion of revenue from this transaction that has been recognized in the accounting period per revenue recognition rules.
returntrackingnumbers String Tracking numbers associated with returned items linked to this revenue commitment, used for logistics and auditing.
revenuestatus String The current status of the revenue commitment, such as pending, recognized, or deferred, indicating its financial state.
salesgroup String The sales team or department responsible for this transaction, used for performance tracking and commission calculations.
salesrep String The specific sales representative credited with this transaction, affecting sales reporting and potential commissions.
shipaddress String The shipping address provided for this transaction, indicating where goods or services should be delivered.
shipaddresslist String A list of available shipping addresses linked to the customer or transaction, providing selectable shipping options.
shipisresidential String Indicates whether the shipping address is a residential location, which can impact shipping costs and carrier selection.
shipoverride String Specifies whether the default shipping method or address has been manually overridden for this transaction.
shippingaddress String The final confirmed shipping address for the transaction, used for logistics and delivery tracking.
source String The origin or channel of this transaction, such as web store, direct sales, or marketplace, for tracking and reporting.
startdate Date The date when the revenue commitment becomes effective, often relevant for revenue recognition and contract terms.
subsidiary String The specific business entity or subsidiary under which this transaction is recorded, important for multi-entity companies.
subtotal Decimal The total amount for this transaction before taxes, shipping, and additional fees are applied.
syncpartnerteams Boolean Indicates whether the partner teams involved in this transaction should be synchronized across related records and systems.
syncsalesteams Boolean Indicates whether the sales teams related to this transaction should be synchronized across various records and reports.
total Decimal The final total amount for the transaction, including taxes, shipping, and any applicable discounts.
trackingnumbers String Tracking numbers assigned to the shipment for monitoring delivery status and ensuring fulfillment accuracy.
trandate Date The official transaction date recorded in the system, used for accounting, reporting, and reconciliation.
tranid String A unique Id for the revenue commitment transaction, essential for record-keeping and cross-referencing.
tranisvsoebundle Boolean Indicates whether this transaction is part of a Vendor-Specific Objective Evidence (VSOE) bundle, impacting revenue recognition.
vsoeautocalc Boolean Specifies whether the system automatically calculates VSOE allocation for revenue recognition compliance.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9434