Power BI Connector for NetSuite

Build 26.0.9770

invoice

Holds invoice details, including billing status, customer information, transaction amounts, payment terms, and links to sales orders and payments.

Columns

Name Type References Description
abbrevtype String The abbreviation type associated with the invoice transaction.
account String The financial account associated with this invoice, used for recording revenue or receivables.
amountpaid Decimal The total amount that has been paid against this invoice, reducing the outstanding balance.
amountremaining Decimal The remaining balance due on the invoice after payments and adjustments have been applied.
approvalstatus String Indicates the current approval status of the invoice, such as pending, approved, or rejected.
asofdate Date The date as of which the invoice balance or status is calculated.
automaticallyapplypromotions Boolean If the value is true, eligible promotions are automatically applied to this invoice.
basehandlingtaxamount Decimal The base tax amount applied to handling charges before any adjustments.
baseshippingtaxamount Decimal The base tax amount applied to shipping charges before any adjustments.
billingaccount String The billing account linked to this invoice for subscription or recurring billing scenarios.
billingaddress String The primary billing address used on this invoice.
bulkprocsubmission String The bulk processing submission associated with this invoice.
class String The classification assigned to this invoice, used for financial reporting and segmentation.
companyid String The identifier of the company associated with this invoice.
createdby String The user who created this invoice.
createddate Datetime The date and time when this invoice was created.
createdfrom String The originating transaction, such as a sales order, from which this invoice was generated.
currency String The currency in which this invoice is denominated.
defaultcatchup Integer The number of periods used for the catch-up calculation on this invoice.
deferredrevenue Decimal The portion of the invoice total that is recognized as deferred revenue pending future recognition.
department String The department associated with this invoice.
discountamount Decimal The total discount amount applied to this invoice.
discountdate Date The date by which payment must be made to qualify for an early payment discount.
documentsequence String The document numbering sequence assigned to this invoice.
duedate Date The date by which payment for this invoice is due, based on the payment terms.
email String The email address used for sending this invoice electronically.
emailaddr String The email address recorded on this invoice.
enddate Date The end date of the billing period covered by this invoice.
entity String The customer entity to whom this invoice is issued.
entitytaxregnum String The tax registration number assigned to the customer entity on this invoice.
estgrossprofit Decimal The estimated gross profit from this invoice, calculated from revenue minus estimated costs.
estgrossprofitpercent String The estimated gross profit percentage, providing insight into the expected margin for this invoice.
exchangerate Decimal The exchange rate used to convert the invoice currency to the base reporting currency.
excludecommission Boolean If the value is true, this invoice is excluded from commission calculations.
excludefromglnumbering Boolean If the value is true, this invoice is excluded from GL audit numbering.
expcostdiscamount Decimal The discount amount applied to billable expenses on this invoice.
expcostdiscount String The discount item applied to billable expense costs on this invoice.
expcostdiscprint Boolean If the value is true, the expense cost discount is printed on the invoice.
expcostdiscrate String The discount rate applied to billable expense costs, expressed as a percentage or fixed amount.
externalid String A unique external identifier for referencing this invoice in external systems.
fax String The fax number associated with the customer on this invoice.
fob String The Free on Board (FOB) term specifying when and where ownership of goods transfers.
forinvoicegrouping Boolean If the value is true, this invoice is eligible to be grouped with others on a consolidated invoice.
groupedto String The invoice to which this invoice has been grouped for consolidated billing.
handlingcost Decimal The total handling fee charged on this invoice.
handlingtax1rate Double The primary tax rate applied to handling costs on this invoice.
handlingtax2rate Double The secondary tax rate applied to handling costs on this invoice.
handlingtaxamount Decimal The total tax amount applied to handling costs on this invoice.
handlingtaxcode String The tax code governing how handling charges are taxed on this invoice.
id Integer The internal ID uniquely identifying this invoice in NetSuite.
intercostatus String The intercompany processing status of this invoice.
intercotransaction String The related intercompany transaction paired with this invoice.
ipaddress String The IP address from which this invoice was submitted.
ipaddresscountry String The country associated with the IP address from which this invoice was submitted.
ismultishipto Boolean If the value is true, this invoice contains line items shipping to multiple addresses.
istaxable Boolean If the value is true, taxes are applicable to this invoice.
itemcostdiscamount Decimal The discount amount applied to billable item costs on this invoice.
itemcostdiscount String The discount item applied to billable item costs on this invoice.
itemcostdiscprint Boolean If the value is true, the item cost discount is printed on the invoice.
itemcostdiscrate String The discount rate applied to billable item costs, expressed as a percentage or fixed amount.
job String The project or job associated with this invoice for project-based billing.
lastmodifiedby String The user who last modified this invoice.
lastmodifieddate Datetime The date and time when this invoice was last modified.
leadsource String The lead source attributed to the customer for this invoice.
legacytax Boolean If the value is true, this invoice uses the legacy tax calculation method.
location String The location associated with this invoice, used for inventory and tax calculations.
memo String An internal memo or note providing additional context about this invoice.
message String A customer-facing message displayed on this invoice.
mosscountry String The country of consumption for Mini One Stop Shop (MOSS) VAT reporting.
mosscountrydetail String Detailed consumption country information for Mini One Stop Shop (MOSS) VAT reporting.
nextapprover String The user designated as the next approver for this invoice.
nexus String The tax nexus for this invoice, representing the tax jurisdiction based on selling or shipping location.
number Integer The document number assigned to this invoice.
opportunity String The CRM opportunity linked to this invoice.
otherrefnum String An additional reference number for this invoice, such as a PO or check number.
overrideinstallments Boolean If the value is true, the default installment schedule is overridden on this invoice.
partner String The partner associated with this invoice for partner relationship management.
paymentlink String The payment link provided to the customer for online payment of this invoice.
pendingpaypalauth String The pending PayPal authorization reference for this invoice.
postingperiod String The accounting period in which this invoice is posted.
predictedoverduedays Integer The predicted number of days this invoice will be overdue based on machine learning analysis.
predictedpaymentdate Date The predicted payment date for this invoice based on machine learning analysis.
predictedpaymentdateavailability String Indicates the availability status of the predicted payment date for this invoice.
predictedpaymentdatelastupdated Date The date when the predicted payment date for this invoice was last updated.
prevdate Date The previous effective date associated with this invoice.
previousopportunity String The previous opportunity reference associated with this invoice.
pricesincludetax Boolean If the value is true, prices on this invoice include tax.
primarybookbasecurrency String The base currency of the primary accounting book for this invoice.
recognizedrevenue Decimal The amount of revenue from this invoice that has been recognized.
recurringbill Boolean If the value is true, this invoice is part of a recurring billing arrangement.
revcommitstatusdescr String A text description of the revenue commitment status for this invoice.
revenuestatus String The current revenue recognition status of this invoice.
revenuestatusdescr String A text description of the revenue recognition status of this invoice.
revrecenddate Date The end date of the revenue recognition schedule for this invoice.
revreconrevcommitment Boolean If the value is true, revenue recognition is applied on revenue commitment for this invoice.
revrecschedule String The revenue recognition schedule applied to this invoice.
revrecstartdate Date The start date of the revenue recognition schedule for this invoice.
saascommitmentenddate Date The end date of the SaaS metric commitment period for this invoice.
saascommitmentstartdate Date The start date of the SaaS metric commitment period for this invoice.
saleschannel String The sales channel through which this invoice was generated.
saleschannelorderpriority String The order priority assigned by the sales channel for this invoice.
saleseffectivedate Date The effective date used for sales reporting purposes on this invoice.
salesrep String The sales representative associated with this invoice.
shipaddress String The formatted shipping address for this invoice.
shipdate Date The date on which the goods on this invoice are shipped.
shipmethod String The shipping method used for this invoice.
shippingaddress String The primary shipping address for this invoice.
shippingcost Decimal The total shipping cost charged on this invoice.
shippingtax1rate Double The primary tax rate applied to shipping costs on this invoice.
shippingtax2rate Double The secondary tax rate applied to shipping costs on this invoice.
shippingtaxamount Decimal The total tax amount applied to shipping costs on this invoice.
shippingtaxcode String The tax code used for shipping charges on this invoice.
source String The source of the invoice or order.
sourcesystem String The external system from which this invoice originated.
sourcewebsite String The web store or website from which this invoice was generated.
startdate Date The start date of the billing period covered by this invoice.
status String The current status of this invoice, such as open, paid, or voided.
subsidiary String The subsidiary associated with this invoice.
subsidiarytaxregnum String The tax registration number of the subsidiary issuing this invoice.
tax2total Decimal The total secondary tax amount (such as PST) applied to this invoice.
taxdetailsoverride Boolean If the value is true, the tax details on this invoice have been manually overridden.
taxitem String The tax item applied to this invoice.
taxperiod String The tax period in which this invoice is reported.
taxpointdate Date The tax point date that determines the tax period for this invoice.
taxpointdateoverride Boolean If the value is true, the tax point date on this invoice has been manually overridden.
taxrate Double The tax rate applied to this invoice.
taxregoverride Boolean If the value is true, the tax registration has been manually overridden on this invoice.
taxtotal Decimal The total tax amount applied to this invoice.
terms String The payment terms associated with this invoice, such as Net 30 or Net 60.
thirdpartyacct String The third-party account number associated with this invoice.
timediscamount Decimal The discount amount applied to billable time on this invoice.
timediscount String The discount item applied to billable time on this invoice.
timediscprint Boolean If the value is true, the time discount is printed on the invoice.
timediscrate String The discount rate applied to billable time, expressed as a percentage or fixed amount.
tobeemailed Boolean If the value is true, this invoice is marked to be sent by email.
tobefaxed Boolean If the value is true, this invoice is marked to be sent by fax.
tobeprinted Boolean If the value is true, this invoice is marked to be printed.
total Decimal The total amount of this invoice, including taxes and fees.
totalaftertaxes Decimal The total amount of this invoice after all taxes have been applied.
totalcostestimate Decimal The estimated total cost of goods and services on this invoice.
trandate Date The date when this invoice was recorded.
tranid String The unique invoice number assigned to this transaction.
tranisvsoebundle Boolean If the value is true, this invoice is part of a VSOE bundle transaction.
transactionnumber String The system-generated number identifying this transaction.
type String The type of the transaction record.
userestimatedpaymentdate Date The payment date manually estimated by the user for this invoice.
userestimatesource String The source or method used by the user to estimate the payment date for this invoice.
vatregnum String The VAT registration number associated with this invoice.
voided Boolean If the value is true, this invoice has been voided.
website String The website associated with the customer on this invoice.

Copyright (c) 2026 CData Software, Inc. - All rights reserved.
Build 26.0.9770