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 | _D_Company |
Data Warehouse | _D_Customer |
Data Warehouse | _D_CustAddress |
Data Warehouse | _D_Item |
Data Warehouse | _D_Location |
Data Warehouse | _D_Salesperson |
Data Warehouse | _D_Warehouse |
Data Warehouse | _F_AR_Aging_Today |
Data Warehouse | _F_Purchase_Order |
Data Warehouse | _F_Sales_Invoice |
Data Warehouse | _F_Sales_Order |
Data Warehouse | _T_DataAsOf |
Data Warehouse | _T_Today |
Data Warehouse | _T_Date |
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+.
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.
Table Linking Example
The following exemplifies how _Purchase_Order tables are linked in DataSelf’s out-of-the-box templates. This linking applies to Power BI semantic models, Tableau data sources, Excel, and other reporting tools.
