Power Query

NetSuite Data Export

Keyboard Shortcuts

Run queryCtrl+Enter
Save queryCtrl+S
History tabCtrl+H
Schema tabCtrl+/
Close popoverEsc
Tools Hub

SuiteQL Tips

Use ROWNUM <= N to limit rows. Dates: TO_DATE('2024-01-01','YYYY-MM-DD'). String concat: ||. NULL check: NVL(field,'default'). Current date: SYSDATE.

Common Tables

transaction, transactionline, customer, item, vendor, contact, employee, location, inventorybalance, pricing

Join Pattern

transaction t INNER JOIN transactionline tl ON tl.transaction = t.id

Parameters

SQL:
Select a template or write a query Choose a category on the left to get started

Save Query