The connector models NetSuite information as an easy-to-use SQL database with views and stored procedures.

Views

The Views section, which lists read-only SQL tables, contains samples of what you might have access to in your NetSuite account.

Common views include:

View	Description
transaction	Stores financial transaction records, linking them to customers, vendors, and accounts.
customer	Tracks detailed customer information, including contact details, account status, and transaction history for billing and Customer Relationship Management.
vendor	Stores detailed information about vendors, including company details, contact information, and relationships.
employee	Tracks employee records, storing personal and professional details for HR, payroll, and management purposes.
item	Holds details about inventory and non-inventory items, including products, materials, and services available in NetSuite.
account	Stores financial account details, including general ledger accounts used for recording transactions.
salesorder	Stores details of sales orders, including order status, customer, and line items.
creditmemo	Stores credit memo records, which are issued to customers when an amount is credited back to their account, often due to returns or billing errors.
journalentry	Stores financial journal entries, tracking debits and credits for accounting purposes.
department	Contains details about the departments within an organization, used for categorizing and organizing personnel, expenses, and tasks.
classification	Defines the classification system used for categorizing different records within the platform, such as customer types or item categories.
location	Stores details about business locations, including warehouses and offices.
itemfulfillment	Stores records of item fulfillment transactions, detailing how and when items are shipped to customers.
itemreceipt	Records the receipt of inventory items, capturing details such as purchase order fulfillment and supplier shipments.
expensereport	Tracks employee expense reports, used for submission, approval, and reimbursement of employee-incurred expenses.
timebill	Records time billing data, tracking billable hours for projects and services.
supportcase	Logs customer support cases, including issue descriptions, statuses, resolutions, and assigned agents.
opportunity	Stores information about sales opportunities, including potential revenue and deal details.

Stored Procedures

Stored Procedures are scripts that are invoked via SQL queries. They perform tasks beyond standard CRUD operations, and can be used to manage OAuth access.