The add-in models NetSuite information as an easy-to-use SQL database with tables, views, and stored procedures. The table definitions are dynamically obtained based on your NetSuite account.

Tables

The Tables section, which details standard SQL tables, and the Views section, which lists read-only SQL tables, contain samples of what you might have access to in your NetSuite account.

Common tables include:

Table	Description
Customer	Stores customer records, including contact details, preferences, and transaction history.
Transactions	Provides a comprehensive view of all transactions recorded in NetSuite, useful for auditing, reporting, and data analysis.
SalesOrder	Stores sales order details, tracking order processing, fulfillment, and invoicing.
Invoice	Stores details of customer invoices for sales transactions, including payment terms and due dates.
Employee	Manages employee records, including personal details, roles, and payroll information.
Vendor	Stores vendor records, including contact details, transaction history, and payment terms.
PurchaseOrder	Records purchase orders for goods and services, including vendor details and approval status.
Contact	Stores details of individuals associated with customers, vendors, and partners.
CustomerPayment	Tracks payments received from customers and their application to outstanding invoices.
JournalEntry	Records financial transactions manually entered into the general ledger.
Account	Stores financial account details used in transactions, reporting, and budgeting.
Department	Stores department classifications for financial reporting and organizational structure.
Location	Manages physical locations, including warehouses, offices, and retail stores.
Classification	Defines classifications used to categorize records for reporting and accounting segmentation.
ItemFulfillment	Records the fulfillment of sales orders, tracking shipments and deliveries.
Opportunity	Tracks potential sales opportunities, including estimated revenue, stage, and probability.
Estimate	Tracks sales estimates and quotes provided to customers before finalizing orders.
CreditMemo	Tracks issued credit memos for customer refunds, adjustments, or overpayments.
ExpenseReport	Stores submitted employee expense reports for approval and reimbursement.
TimeBill	Records billable hours logged by employees or contractors for project and service tracking.

Stored Procedures

Stored Procedures are scripts that are invoked via SQL queries. They perform tasks beyond standard CRUD operations, and can be used to search, update, and modify information in NetSuite.