Skip to main content
Skip table of contents

NetSuite Pre-Mapped Data Warehouse Tables

Click here to learn about Tableau, Power BI, and MS Excel templates for NetSuite.

Tables

Pre-mapped ETL+ tables available for Sage Intacct as of 01/2023. Subject to change without notice.

Source

Table Name

NetSuite

2.0_transaction

NetSuite

2.0_TransactionAccountingLine

NetSuite

2.0_transactionLine

NetSuite

classification

NetSuite

Customer

NetSuite

customerAddressbookEntityAddress

NetSuite

customerCategory

NetSuite

employee_SalesRep

NetSuite

inventoryItemLocations

NetSuite

item

NetSuite

itemType

NetSuite

Location

NetSuite

LocationType

NetSuite

PreviousTransactionLink

NetSuite

Subsidiary

NetSuite

transaction

NetSuite

TransactionAccountingLine

NetSuite

transactionLine

NetSuite

unitsTypeUom

NetSuite

Vendor

Data Warehouse

4_Today

Data Warehouse

5_Date

Data Warehouse

6_Period

Data Warehouse

INz_10_Inventory_Planning

Data Warehouse

TransactionHdr_PO

Data Warehouse

TransactionHdr_SI

Data Warehouse

TransactionHdr_SO

Data Warehouse

TransactionLine_PO

Data Warehouse

TransactionLine_SI

Data Warehouse

TransactionLine_SO

Data Warehouse

TransactionHdr_

Notes:

  • Some of the above tables will only be deployed using customized SOWs or via services.

  • All Intacct tables can be extracted into the data warehouse using an ODBC.

  • We only recommend extracting tables that are important for your reporting purposes.

Table Columns Example

The following is an example of an Intacct table and its column names, indexes, and formatting in ETL+.

Column green icons indicate the data type and/or index definition have been set or changed in ETL+.

image-20240411-145758.png

Delta Load Example

DataSelf ETL+ templates include delta load configuration for popular large tables. This dramatically reduces the time to refresh the data warehouse. ETL+ Table Load Types.

The following is an example of a table configured to use the Upsert feature.

image-20240411-145614.png

Table Linking Example

The following exemplifies how _Purchase_Order tables are linked in DataSelf’s out-of-the-box templates. This linking applies to Tableau data sources, Power BI data sets, Excel, and other reporting tools.

image-20240411-144215.png

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.