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 |
| account | String | The account associated with this invoice, typically representing the financial account used for recording transactions. | |
| althandlingcost | Decimal | The alternative handling cost applied to the invoice, usually reflecting special handling fees or adjustments. | |
| altshippingcost | Decimal | The alternative shipping cost applied to the invoice, used when an alternative rate is used instead of standard shipping charges. | |
| 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. | |
| amountremainingtotalbox | Decimal | The total remaining balance displayed in the summary section of the invoice, aggregating all outstanding amounts. | |
| approvalstatus | String | Indicates the current approval status of the invoice, such as pending, approved, or rejected. | |
| asofdate | Date | The effective date for financial reporting purposes, representing when the invoice data is considered valid. | |
| balance | Decimal | The total outstanding balance on this invoice, reflecting unpaid amounts after all payments and credits have been accounted for. | |
| billaddress | String | The billing address where the invoice is directed, typically including recipient name, street address, city, and postal code. | |
| billaddresslist | String | A reference to a predefined list of billing addresses associated with the customer. | |
| billingaccount | String | The specific billing account linked to this invoice, used for categorization and financial tracking. | |
| billingaddress | String | The complete formatted billing address for the invoice recipient, used for official correspondence. | |
| billisresidential | String | Indicates whether the billing address is a residential location, which can impact tax calculations and delivery methods. | |
| bulkprocsubmission | String | Indicates whether this invoice was submitted as part of a bulk processing operation, useful for tracking large-scale transactions. | |
| canhavestackable | Boolean | Specifies whether multiple discounts or promotions can be stacked on this invoice, affecting pricing calculations. | |
| class | String | The accounting classification assigned to this invoice, often used for departmental tracking and reporting. | |
| consolidatebalance | Decimal | The total consolidated balance across related invoices or financial entities, useful for aggregated reporting. | |
| couponcode | String | A promotional code applied to the invoice, potentially reducing the total amount due. | |
| createddate | Datetime | The date and time when the invoice was originally created in the system, which is automatically generated. | |
| createdfrom | String | The source transaction or document from which this invoice was generated, such as a sales order. | |
| currency | String | The currency in which this invoice is denominated, based on the customer's default or selected currency. | |
| currencyname | String | The name of the currency associated with this invoice, such as US Dollar or Euro. | |
| currencysymbol | String | The symbol of the currency used in this invoice, such as $ for US dollars, € for euros, or £ for British pounds. | |
| customform | String | A reference to the custom invoice form template used for this specific transaction, allowing for customized layouts. | |
| deferredrevenue | Decimal | The portion of the invoice amount recognized as deferred revenue, indicating income that will be realized in future periods. | |
| department | String | The department responsible for the transaction, used for internal accounting and reporting. | |
| discountamount | Decimal | The total discount amount applied to this invoice, reducing the payable balance. | |
| discountdate | Date | The date by which the discount must be utilized to be applicable, typically part of early payment terms. | |
| discountitem | String | The specific discount item or policy applied to this invoice, often referencing predefined discount rules. | |
| discountrate | String | The rate or percentage of discount applied to this invoice, affecting the overall price calculation. | |
| discounttotal | Decimal | The total sum of all discounts applied to this invoice, including item-level and overall discounts. | |
| duedate | Date | The date by which the invoice must be paid according to the terms established between the vendor and the company. | |
| String | The email address associated with the recipient of this invoice, used for electronic delivery. | ||
| enddate | Date | The final date relevant to this invoice, such as the end of a service period or subscription term. | |
| entity | String | The customer, supplier, or entity to whom this invoice is issued, which serves as a foreign key linking to the corresponding record. | |
| entitynexus | String | The tax nexus associated with the customer entity, influencing tax calculation rules. | |
| entitytaxregnum | String | The tax registration number of the customer, required for compliance in certain tax jurisdictions. | |
| estgrossprofit | Decimal | The estimated gross profit for this invoice, calculated as revenue minus direct costs. | |
| estgrossprofitpercent | String | The estimated gross profit percentage, reflecting profitability as a ratio of revenue. | |
| exchangerate | Decimal | The exchange rate applied to convert invoice amounts to the base currency for accounting purposes. | |
| excludecommission | Boolean | Indicates whether sales commissions should be excluded from this invoice, affecting salesperson compensation. | |
| expcostdiscamount | Decimal | The total discount amount applied to expenses included in this invoice. | |
| expcostdiscount | String | The discount applied to expense-related charges on the invoice, reducing the total payable amount. | |
| expcostdiscprint | Boolean | Specifies whether the expense discount should be displayed on the printed invoice. | |
| expcostdiscrate | String | The percentage discount applied to expenses on this invoice, influencing cost reductions. | |
| expcostdisctaxable | Boolean | Indicates whether the expense discount amount is subject to tax calculations. | |
| expcosttaxcode | String | The tax code applied to expense-related charges in this invoice tracks the specific tax treatment during processing. | |
| expcosttaxrate1 | String | The primary tax rate applied to expense-related charges on this invoice, typically associated with purchases or reimbursements. | |
| externalid | String | A unique external identifier for this invoice, often used for integrations with external systems. | |
| fob | String | The Free on Board (FOB) term associated with this invoice, indicating the point of transfer for shipping liability. | |
| forinvoicegrouping | Boolean | Indicates whether this invoice is eligible for grouping with other invoices for consolidated billing. | |
| giftcertapplied | Decimal | The total monetary value of gift certificates applied to this invoice, reducing the outstanding balance. | |
| groupedto | String | Indicates whether this invoice is grouped with another transaction for processing or reporting purposes, typically used for consolidating invoices. | |
| handlingcost | Decimal | The cost associated with handling the order include packaging, administrative fees, and shipping. | |
| handlingtax1rate | String | The tax rate applied to the handling charges for the invoice, representing the percentage rate used to calculate handling tax. | |
| handlingtaxcode | String | The tax code associated with handling charges on the invoice determines the applicable tax rules for handling fees. | |
| isbasecurrency | Boolean | Indicates whether the invoice is in the company's base currency. A value of 'true' means it is, while 'false' means it is in a foreign currency. | |
| ismultishipto | Boolean | Specifies whether the invoice includes multiple shipping destinations. If 'true', the invoice supports multiple shipping addresses. | |
| istaxable | Boolean | Specifies whether this invoice is subject to taxation based on applicable tax laws. | |
| itemcostdiscamount | Decimal | The total discount amount applied to the cost of the item, representing the monetary reduction in item cost due to applied discounts | |
| itemcostdiscount | String | The type or name of the discount applied to the item cost, indicating the discount category, such as promotional discounts. | |
| itemcostdiscprint | Boolean | Specifies whether the item cost discount should be visible on the printed invoice. | |
| itemcostdiscrate | String | The discount rate applied to the cost of an item in a vendor invoice, typically expressed as a percentage. | |
| itemcostdisctaxable | Boolean | Indicates whether the item cost discount amount is taxable. | |
| itemcosttaxcode | String | The tax code applied to item-related charges, typically used to determine the tax treatment of the item cost. | |
| itemcosttaxrate1 | String | The primary cost-based tax rate applied to an item in a vendor bill or invoice associated with cost-based taxation calculations. | |
| lastmodifieddate | Datetime | The date and time of the last modification to this invoice maintained by NetSuite, capturing all changes made. | |
| leadsource | String | The marketing or sales campaign that led to this transaction, useful for attribution tracking. | |
| linkedtrackingnumbers | String | A list of tracking numbers associated with shipments related to this invoice, providing logistics details. | |
| location | String | The physical or virtual location associated with this invoice, often used for reporting and taxation purposes. | |
| memo | String | A custom note or memo associated with the invoice, often used for internal reference or additional details. | |
| message | String | The message displayed on the invoice, typically containing customer-facing information or special instructions. | |
| messagesel | String | An internal identifier or selection key for predefined messages associated with invoices. | |
| muccpromocodeinstance | String | A unique identifier linking the invoice to a specific multi-use coupon code instance, used for tracking applied discounts. | |
| nextapprover | String | The designated user or role responsible for approving the invoice, if approval workflows are enabled. | |
| nexus | String | The tax jurisdiction or location associated with the invoice, determining applicable tax rates and regulations. | |
| opportunity | String | A reference to the associated sales opportunity, linking the invoice to a potential deal or pipeline stage. | |
| otherrefnum | String | An alternate reference number provided by the customer, often used for purchase orders or external tracking. | |
| overrideinstallments | Boolean | Indicates whether the default installment payment schedule for this invoice has been manually overridden. | |
| partner | String | The business partner, reseller, or affiliate associated with this transaction. | |
| paylink | String | A payment link generated for the invoice, allowing customers to make online payments directly. | |
| postingperiod | String | The financial period during which this invoice is posted, used for accounting and reporting purposes. | |
| promocode | String | The promotional code applied to this invoice, determining discounts or special pricing adjustments. | |
| promocodepluginimpl | String | The system implementation or plugin managing the application of the promotional code logic. | |
| recognizedrevenue | Decimal | The portion of the invoice amount that has been recognized as revenue according to accounting standards. | |
| recurringbill | Boolean | Indicates whether this invoice is part of a recurring billing schedule, generating periodic charges. | |
| returntrackingnumbers | String | Tracking numbers associated with returned items linked to this invoice, aiding in logistics and processing. | |
| revenuestatus | String | The current revenue recognition status of the invoice, indicating whether revenue has been deferred, recognized, or pending. | |
| revreconrevcommitment | Boolean | Indicates whether revenue reconciliation and commitment processes apply to this invoice for financial tracking. | |
| saleseffectivedate | Date | The official date when the sales transaction became effective for revenue recognition purposes. | |
| salesgroup | String | The sales team or group responsible for the transaction, used for performance tracking and commissions. | |
| salesrep | String | The individual sales representative assigned to this invoice, linked to sales performance and incentives. | |
| shipaddress | String | The shipping address where goods or services associated with this invoice will be delivered. | |
| shipaddresslist | String | A list of available shipping addresses associated with the customer for selection in this transaction. | |
| shipdate | Date | The scheduled date when the order associated with this invoice is set to be shipped. | |
| shipisresidential | String | Indicates whether the shipping address is classified as a residential location, which can affect shipping costs. | |
| shipmethod | String | The shipping method selected for this invoice, such as standard, expedited, or freight. | |
| shipoverride | String | Indicates whether the default shipping method and details have been manually overridden. | |
| shippingaddress | String | The detailed address to which goods will be shipped, including street, city, and postal code. | |
| shippingcost | Decimal | The total cost of shipping for this invoice, calculated based on carrier rates and selected shipping options. | |
| shippingcostoverridden | String | Indicates whether the calculated shipping cost has been manually modified. | |
| shippingtax1rate | String | The tax rate applied to the first level of shipping charges, if applicable. | |
| shippingtaxcode | String | The tax code associated with shipping charges, used for compliance with tax regulations. | |
| source | String | The origin of this invoice, such as a sales order, web transaction, or manual entry. | |
| startdate | Date | The start date relevant to this invoice, often used for subscription services or contract-based billing. | |
| status | String | The current status of the invoice, such as pending, approved, paid, or voided. | |
| statusRef | String | An internal reference code representing the status of the invoice in system workflows. | |
| subsidiary | String | The business entity or subsidiary under which this invoice is recorded, relevant for multi-entity organizations. | |
| subsidiarytaxregnum | String | The tax registration number of the subsidiary handling this invoice, ensuring compliance with tax authorities. | |
| subtotal | Decimal | The total amount of the invoice before taxes and additional charges are applied. | |
| syncpartnerteams | Boolean | Indicates whether partner sales teams are synchronized with this invoice for reporting and commission calculations. | |
| syncsalesteams | Boolean | Indicates whether the sales teams associated with this invoice are synchronized for tracking and analysis. | |
| taxdetailsoverride | Boolean | Specifies whether default tax calculations for this invoice have been manually overridden. | |
| taxitem | String | The specific tax item applied to this invoice, defining how tax is calculated and reported. | |
| taxpointdate | Date | The date on which the tax liability for this invoice is recognized, crucial for VAT and sales tax reporting. | |
| taxpointdateoverride | Boolean | Indicates whether the default tax point date has been manually adjusted. | |
| taxrate | Double | The tax rate applied to the invoice, determining the total tax amount calculated. | |
| taxregoverride | Boolean | Specifies whether the default tax registration settings have been manually overridden for this invoice. | |
| taxtotal | Decimal | The total tax amount calculated for this invoice, based on applicable tax rates and taxable amounts. | |
| terms | String | The payment terms specified for this invoice, such as net 30, due on receipt, or installment-based. | |
| timediscamount | Decimal | The discount amount applied based on early payment terms or time-sensitive promotions. | |
| timediscount | String | A reference to the time-based discount policy applicable to this invoice. | |
| timediscprint | Boolean | Indicates whether the time-based discount should be displayed on the printed invoice. | |
| timediscrate | String | The rate at which a time-based discount is applied, typically expressed as a percentage. | |
| timedisctaxable | Boolean | Indicates whether the time-based discount amount is subject to taxation. | |
| timetaxcode | String | The tax code associated with the time-based discount, ensuring proper tax calculation and compliance. | |
| timetaxrate1 | String | The first level tax rate applied to the time-based discount amount, if applicable. | |
| tobeemailed | Boolean | Indicates whether this invoice is scheduled to be sent to the customer via email. | |
| tobefaxed | Boolean | Indicates whether this invoice should be sent to the customer via fax. | |
| tobeprinted | Boolean | Indicates whether a physical copy of this invoice is required for printing. | |
| total | Decimal | The final total amount of the invoice, including taxes, discounts, and additional charges. | |
| totalcostestimate | Decimal | An estimated total cost associated with fulfilling this invoice, useful for profitability analysis. | |
| trackingnumbers | String | A list of tracking numbers associated with shipments linked to this invoice, aiding in delivery monitoring. | |
| trandate | Date | The transaction date of this invoice, representing when the invoice was officially created. | |
| tranid | String | The unique transaction ID assigned to this invoice for system tracking and reference. | |
| tranisvsoebundle | Boolean | Indicates whether this invoice is part of a Vendor-Specific Objective Evidence (VSOE) bundle for revenue recognition. | |
| unbilledorders | Decimal | The total value of associated sales orders that have not yet been billed in this invoice. | |
| vsoeautocalc | Boolean | Indicates whether VSOE calculations are automatically applied to this invoice. |