2 Tables
This section provides information about NetSuite Analytics Warehouse data tables.
Overview
This section provides details of tables such as key columns, data types, and table descriptions. Use the "Referred Table" and "Referred Column" information to decide on the join condition between Fact and Dimension tables.
Note:
Tables ending with the suffix_EN and those listed in Tables Without WHO Columns and Internal Use Only Columns are for Oracle Internal use only. You must not use the UPDATE W$_INSERT_DT and W$_UPDATE_DT columns for reporting purposes. Use these columns with caution for downstream custom ETL. NetSuite Analytics
Warehouse truncates and reloads tables as required, effectively removing the historical record of these columns.
Download this ZIP file that contains available tables that apply to the current version of NetSuite Analytics Warehouse. Once the file downloads, extract the file, open the folder, and then open the release-specific Index.html file. For example, click 26R2_Fusion_NS_Analytics_Tables.html.
Table Types
The suffixes in table names designate the table type.
- CA, A: Aggregate
- CF, F: Fact
- CF_DN: Denormalized Fact
- CG, G: General
- D: Dimension
- DH: Dimension Hierarchy
- EF: Extended Fact
- EN: Oracle internal use only
- H: Helper
- P: Prediction
- TL: Translation
Internal Use Only Columns
The tables provided in NetSuite Analytics Warehouse include columns that are for Oracle internal use only.
The following columns aren't available for customers to use.
| Table Name | Target Column |
|---|---|
| All Tables | SOURCE_RECORD_ID |
| All Tables | SOURCE_RECORD_ID |
| DW_NS_customer_D | firstorderdate |
| DW_NS_customer_D | firstsaledate |
| DW_NS_customer_D | lastorderdate |
| DW_NS_customer_D | lastsaledate |
| DW_NS_customer_D | oncredithold |
| DW_NS_employee_D | jobdescription |
| DW_NS_billingAccount_D | lastbilldate |
| DW_NS_PaycheckNextTransactionLineLink_F | anchor_doc |
| DW_NS_BuildNextTransactionLineLink_F | anchor_doc |
| DW_NS_CashRfndNextTransactionLineLink_F | anchor_doc |
| DW_NS_CashSaleNextTransactionLineLink_F | anchor_doc |
| DW_NS_CheckNextTransactionLineLink_F | anchor_doc |
| DW_NS_CommissnNextTransactionLineLink_F | anchor_doc |
| DW_NS_CustChrgNextTransactionLineLink_F | anchor_doc |
| DW_NS_CustCredNextTransactionLineLink_F | anchor_doc |
| DW_NS_CustDepNextTransactionLineLink_F | anchor_doc |
| DW_NS_CustInvcNextTransactionLineLink_F | anchor_doc |
| DW_NS_CustPymtNextTransactionLineLink_F | anchor_doc |
| DW_NS_CustRfndNextTransactionLineLink_F | anchor_doc |
| DW_NS_DepApplNextTransactionLineLink_F | anchor_doc |
| DW_NS_DepositNextTransactionLineLink_F | anchor_doc |
| DW_NS_EstimateNextTransactionLineLink_F | anchor_doc |
| DW_NS_ExpReptNextTransactionLineLink_F | anchor_doc |
| DW_NS_FxRevalNextTransactionLineLink_F | anchor_doc |
| DW_NS_InvAdjstNextTransactionLineLink_F | anchor_doc |
| DW_NS_InvCountNextTransactionLineLink_F | anchor_doc |
| DW_NS_InvRevalNextTransactionLineLink_F | anchor_doc |
| DW_NS_InvTrnfrNextTransactionLineLink_F | anchor_doc |
| DW_NS_ItemRcptNextTransactionLineLink_F | anchor_doc |
| DW_NS_ItemShipNextTransactionLineLink_F | anchor_doc |
| DW_NS_JournalNextTransactionLineLink_F | anchor_doc |
| DW_NS_NettStlmNextTransactionLineLink_F | anchor_doc |
| DW_NS_OpprtntyNextTransactionLineLink_F | anchor_doc |
| DW_NS_OwnTrnsfNextTransactionLineLink_F | anchor_doc |
| DW_NS_PurchConNextTransactionLineLink_F | anchor_doc |
| DW_NS_PurchOrdNextTransactionLineLink_F | anchor_doc |
| DW_NS_PurchReqNextTransactionLineLink_F | anchor_doc |
| DW_NS_RevArrngNextTransactionLineLink_F | anchor_doc |
| DW_NS_RevCommNextTransactionLineLink_F | anchor_doc |
| DW_NS_RevComRvNextTransactionLineLink_F | anchor_doc |
| DW_NS_RtnAuthNextTransactionLineLink_F | anchor_doc |
| DW_NS_SalesOrdNextTransactionLineLink_F | anchor_doc |
| DW_NS_StPickUpNextTransactionLineLink_F | anchor_doc |
| DW_NS_SysJrnlNextTransactionLineLink_F | anchor_doc |
| DW_NS_TrnfrOrdNextTransactionLineLink_F | anchor_doc |
| DW_NS_VendAuthNextTransactionLineLink_F | anchor_doc |
| DW_NS_VendBillNextTransactionLineLink_F | anchor_doc |
| DW_NS_VendCredNextTransactionLineLink_F | anchor_doc |
| DW_NS_VendPymtNextTransactionLineLink_F | anchor_doc |
| DW_NS_VPrepAppNextTransactionLineLink_F | anchor_doc |
| DW_NS_VPrepNextTransactionLineLink_F | anchor_doc |
| DW_NS_WOCloseNextTransactionLineLink_F | anchor_doc |
| DW_NS_WOComplNextTransactionLineLink_F | anchor_doc |
| DW_NS_WOIssueNextTransactionLineLink_F | anchor_doc |
| DW_NS_WorkOrdNextTransactionLineLink_F | anchor_doc |
| DW_NS_XChgJrnlNextTransactionLineLink_F | anchor_doc |
| DW_NS_CUSTOMER_PAYMENT_ACTIVITY_EF | anchor_id |
| DW_NS_CUSTOMER_PAYMENT_ACTIVITY_LINES_EF | anchor_id |
| DW_NS_CUSTOMER_PAYMENT_ACTIVITY_LINES_EF | anchor_lineid |
| DW_NS_ORDER_FULFILLMENT_LINES_EF | anchor_id |
| DW_NS_ORDER_FULFILLMENT_LINES_EF | anchor_lineid |