Tableau Connector for NetSuite

Build 25.0.9434

invoicegroup

Represents a collection of invoices processed together for streamlined billing, payment, or financial reporting.

Columns

Name Type References Description
amountdue Decimal The total outstanding balance for the invoice, representing the amount that is still unpaid by the customer.
amountpaid Decimal The total amount that has been paid toward the invoice by the customer, reflecting partial or full payments made.
billaddress String The full billing address associated with the invoice group, including street, city, state, and postal code.
billaddresslist String A reference identifier for the billing address record stored in the system.
currency String The currency in which the invoice group transactions are recorded, represented by the currency code.
customer String The unique identifier for the customer associated with this invoice group. This value links to the customer record in the system.
customername String The full name of the customer, as recorded in the system. This is a human-readable version of the customer identifier.
datedriven String Indicates whether the invoice due date is determined based on a specific date-driven rule or a predefined term.
dayofmonthnetdue Integer The specific day of the month on which the invoice is due when using a date-driven payment term.
daysuntilnetdue Integer The number of days from the invoice date until the payment is due.
discounttotal Decimal The total discount applied to the invoice group, including any early payment or promotional discounts.
duedate Date The final date by which payment for the invoice group is expected to be made.
duenextmonthifwithindays Integer If the invoice is due within this many days from the end of the month, the due date is extended to the following month.
externalid String An optional user-defined identifier for the invoice group, typically used for integration with external systems.
groupedbypo Boolean Indicates whether invoices within this group are consolidated based on purchase order numbers.
handlingcost Decimal The total cost associated with handling fees for the invoice group, such as packaging or processing charges.
id Integer The internal system-generated identifier for the invoice group record that distinguishes each invoice group entry.
invoicegroupnumber String The unique identifier assigned to the invoice group for tracking and reference.
itemtotal Decimal The total cost of all items included in the invoice group before taxes, discounts, and additional charges.
lastmodifiedby String The user who last modified the invoice group record in the system essential for tracking changes.
lastmodifieddate Datetime The timestamp of the most recent update or modification made to a particular invoice group record.
memo String An optional note or remark associated with the invoice group, typically used for internal reference.
ponumber String The purchase order number associated with this invoice group, which links the invoice to the original purchase order issued by the buyer.
shippingcost Decimal The total cost of shipping for this invoice group, including any applicable handling fees or surcharges.
status String The current status of the invoice group, indicating whether it is pending, approved, paid, or in another relevant state.
subsidiary String The subsidiary or business entity associated with this invoice group, which helps identify the organizational unit responsible for the transaction.
taxtotal Decimal The total amount of tax applied to this invoice group, including all applicable sales tax, Value Added Tax (VAT), or other regulatory tax components.
terms String The payment terms agreed upon for this invoice group, specifying conditions such as net payment periods, early payment discounts, or due dates.
total Decimal The total amount due for this invoice group, including all item costs, taxes, and shipping fees.
trandate Date The transaction date for this invoice group, indicating when the invoice was created or processed in the system.

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