Aggregates List
The table below lists Retail Insights aggregates grouped by subject area and aggregation type.
Table 7-1 Retail Insights Aggregates
| Fact | Base Fact Table | Aggregate Tables As-Was | Aggregate Tables As-Is | Corporate Aggregate Tables (As-Was) | Corporate Aggregate Tables (As-Is) | Season Aggregates (As-Is/As-Was) |
|---|---|---|---|---|---|---|
|
Inventory Position |
W_RTL_INV_IT_LC_DY_F |
W_RTL_INV_IT_LC_WK_A W_RTL_INV_IT_LC_GMH_AW_RTL_INV_IT_RG_DY_AW_RTL_INV_SC_LC_DY_A W_RTL_INV_SC_LC_WK_A W_RTL_INV_CL_LC_DY_A W_RTL_INV_CL_LC_WK_A W_RTL_INV_DP_LC_DY_A W_RTL_INV_DP_LC_WK_AW_RTL_INVAGE_DP_LC_DY_A |
W_RTL_INV_IT_LC_WK_A W_RTL_INV_IT_LC_GMH_A W_RTL_INV_IT_RG_DY_CUR_A W_RTL_INV_SC_LC_DY_CUR_A W_RTL_INV_SC_LC_WK_CUR_A |
W_RTL_INV_IT_DY_A W_RTL_INV_IT_WK_A W_RTL_INV_SC_DY_A W_RTL_INV_SC_WK_A |
W_RTL_INV_IT_DY_A W_RTL_INV_IT_WK_A W_RTL_INV_SC_DY_CUR_A W_RTL_INV_SC_WK_CUR_A |
|
|
Inventory Receipts |
W_RTL_INVRC_IT_LC_DY_F |
W_RTL_INVRC_IT_LC_WK_A W_RTL_INVRC_SC_LC_DY_A W_RTL_INVRC_SC_LC_WK_A W_RTL_INVRC_CL_LC_WK_A W_RTL_INVRC_CL_LC_DY_A W_RTL_INVRC_DP_LC_DY_A W_RTL_INVRC_DP_LC_WK_A W_RTL_INVRC_ID_LC_DY_AW_RTL_INVRC_ID_LC_WK_AW_RTL_INVRC_IL1_LC_DY_AW_RTL_INVRC_IL1_LC_WK_A |
W_RTL_INVRC_SC_LC_DY_CUR_A W_RTL_INVRC_SC_LC_WK_CUR_A W_RTL_INVRC_IT_LC_WK_ A W_RTL_INVRC_ID_LC_DY_AW_RTL_INVRC_ID_LC_WK_AW_RTL_INVRC_IL1_LC_DY_AW_RTL_INVRC_IL1_LC_WK_A |
W_RTL_INVRC_IT_DY_A W_RTL_INVRC_IT_WK_A W_RTL_INVRC_SC_DY_A W_RTL_INVRC_SC_WK_A |
W_RTL_INVRC_IT_DY_A W_RTL_INVRC_IT_WK_A W_RTL_INVRC_SC_DY_CUR_A W_RTL_INVRC_SC_WK_CUR_A |
W_RTL_INVRC_IT_DY_SN_A W_RTL_INVRC_IT_LC_DY_SN_A W_RTL_INVRC_IT_LC_WK_SN_A W_RTL_INVRC_IT_WK_SN_A |
|
Inventory Adjustment |
W_RTL_INVADJ_IT_LC_DY_F |
W_RTL_INVADJ_IT_LC_WK_A W_RTL_INVADJ_SC_LC_DY_A W_RTL_INVADJ_SC_LC_WK_A |
W_RTL_INVADJ_IT_LC_WK_A W_RTL_INVADJ_SC_LC_DY_CUR_A W_RTL_INVADJ_SC_LC_WK_CUR_A |
W_RTL_INVADJ_IT_LC_DY_SN_A |
||
|
Inventory Transfer |
W_RTL_INVTSF_IT_LC_DY_F |
W_RTL_INVTSF_IT_LC_WK_A W_RTL_INVTSF_SC_LC_DY_A W_RTL_INVTSF_SC_LC_WK_A |
W_RTL_INVTSF_IT_LC_WK_A W_RTL_INVTSF_SC_LC_DY_CUR_A W_RTL_INVTSF_SC_LC_WK_CUR_A |
W_RTL_INVTSF_IT_LC_DY_SN_A |
||
|
Return to Vendor |
W_RTL_INVRTV_IT_LC_DY_F |
|||||
|
Unavailable Inventory |
W_RTL_INVU_IT_LC_DY_F |
W_RTL_INVU_IT_LC_WK_A W_RTL_INVU_SC_LC_DY_A W_RTL_INVU_SC_LC_WK_A |
W_RTL_INVU_IT_LC_WK_A W_RTL_INVU_SC_LC_DY_CUR_A W_RTL_INVU_SC_LC_WK_CUR_A |
|||
|
Markdown |
W_RTL_MKDN_IT_LC_DY_F |
W_RTL_MKDN_IT_LC_WK_A W_RTL_MKDN_SC_LC_DY_A W_RTL_MKDN_SC_LC_WK_A W_RTL_MKDN_CL_LC_DY_A W_RTL_MKDN_CL_LC_WK_A W_RTL_MKDN_DP_LC_DY_A W_RTL_MKDN_DP_LC_WK_A W_RTL_MKDN_ID_LC_DY_AW_RTL_MKDN_ID_LC_WK_AW_RTL_MKDN_IL1_LC_DY_AW_RTL_MKDN_IL1_LC_WK_A |
W_RTL_MKDN_SC_ LC_DY_CUR_A W_ RTL_MKDN_SC_LC_ WK_CUR_A W_RTL_ MKDN_CL_LC_DY_ CUR_A W_RTL_ MKDN_CL_LC_WK_ CUR_A W_RTL_ MKDN_DP_LC_DY_ CUR_A W_RTL_ MKDN_DP_LC_WK_ CUR_A W_RTL_MKDN_IT_LC_WK_ A W_RTL_MKDN_ID_LC_DY_AW_RTL_MKDN_ID_LC_WK_AW_RTL_MKDN_IL1_LC_DY_AW_RTL_MKDN_IL1_LC_WK_A |
W_RTL_MKDN_IT_DY_A W_RTL_MKDN_IT_WK_A W_RTL_MKDN_SC_DY_A W_RTL_MKDN_SC_WK_A W_RTL_MKDN_SC_DY_CURR_A W_RTL_MKDN_SC_WK_CURR_A |
W_RTL_MKDN_IT_DY_A W_RTL_MKDN_IT_WK_A W_RTL_MKDN_SC_DY_CURR_A W_RTL_MKDN_SC_WK_CURR_A |
W_RTL_MKDN_IT_LC_DY_SN_A W_RTL_MKDN_IT_LC_WK_SN_A W_RTL_MKDN_IT_DY_SN_A W_RTL_MKDN_IT_WK_SN_A |
|
Net Cost |
W_RTL_NCOST_IT_LC_DY_F |
W_RTL_NCOST_IT_DY_A |
W_RTL_NCOST_IT_DY_A |
|||
|
Net Profit |
W_RTL_NPROF_IT_LC_DY_F |
W_RTL_NPROF_IT_LC_WK_A W_RTL_NPROF_SC_LC_DY_A W_RTL_NPROF_SC_LC_WK_A W_RTL_NPROF_CL_LC_DY_A W_RTL_NPROF_CL_LC_WK_A W_RTL_NPROF_DP_LC_DY_A W_RTL_NPROF_DP_LC_WK_A |
W_RTL_NPROF_IT_LC_WK_ A |
W_RTL_NPROF_IT_DY_A W_RTL_NPROF_IT_WK_A W_RTL_NPROF_SC_DY_A W_RTL_NPROF_SC_WK_A |
W_RTL_NPROF_IT_DY_A W_RTL_NPROF_IT_WK_A |
|
|
On Order |
W_RTL_PO_ONORD_IT_LC_DY_F W_RTL_PO_ONALC_IT_LC_DY_F |
|||||
|
Planning |
W_RTL_MFPOP_PROD3_LC3_T3_F W_RTL_PLAN1_PROD1_LC1_T1_FW_RTL_PLAN2_PROD2_LC2_T2_FW_RTL_PLAN3_PROD3_LC3_T3_FW_RTL_PLAN4_PROD4_LC4_T4_F |
|||||
|
Planning Forecast |
W_RTL_PLANFC1_PROD1_LC1_T1_F W_RTL_PLANFC2_PROD2_LC2_T2_F |
|||||
|
Pricing |
W_RTL_PRICE_IT_LC_DY_F |
W_RTL_PRICE_IT_DY_A |
W_RTL_PRICE_IT_DY_A |
|||
|
Promotion Actuals |
W_RTL_PRACT_IT_LC_DY_F |
|||||
|
Promotion Budget |
W_RTL_PRBDGT_IT_LC_F |
|||||
|
Promotion Forecast |
W_RTL_SLSPRFC_PC_CS_DY_F W_RTL_SLSPRFC_PC_CS_WK_F |
|||||
|
Sales Transaction |
W_RTL_SLS_TRX_IT_LC_DY_F |
W_RTL_SLS_IT_LC_DY_A W_RTL_SLS_IT_LC_WK_A W_RTL_SLS_SC_LC_DY_A W_RTL_SLS_SC_LC_WK_A W_RTL_SLS_CL_LC_DY_A W_RTL_SLS_CL_LC_WK_A W_RTL_SLS_DP_LC_DY_A W_RTL_SLS_DP_LC_WK_A W_RTL_SLS_CS_IT_LC_DY_A W_RTL_SLS_CUST_LC_DY_A W_RTL_SLS_ID_LC_DY_AW_RTL_SLS_ID_LC_WK_AW_RTL_SLS_IL1_LC_DY_AW_RTL_SLS_IL1_LC_WK_A |
W_RTL_SLS_IT_LC_DY_A W_RTL_SLS_IT_LC_WK_A W_RTL_SLS_SC_LC_DY_CUR_A W_RTL_SLS_SC_LC_WK_CUR_A W_RTL_SLS_CL_LC_DY_CUR_A W_RTL_SLS_CL_LC_WK_CUR_A W_RTL_SLS_DP_LC_DY_CUR_A W_RTL_SLS_DP_LC_WK_CUR_A W_RTL_SLS_CS_IT_LC_DY_A W_RTL_SLS_CUST_LC_DY_A W_RTL_SLS_ID_LC_DY_AW_RTL_SLS_ID_LC_WK_AW_RTL_SLS_IL1_LC_DY_AW_RTL_SLS_IL1_LC_WK_A |
W_RTL_SLS_IT_DY_A W_RTL_SLS_IT_WK_A W_RTL_SLS_SC_DY_A W_RTL_SLS_SC_WK_A W_RTL_SLS_SC_DY_CUR_A W_RTL_SLS_SC_WK_CUR_A W_RTL_SLS_LC_DY_A W_RTL_SLS_LC_WK_A |
W_RTL_SLS_IT_DY_A W_RTL_SLS_IT_WK_A W_RTL_SLS_SC_DY_CUR_A W_RTL_SLS_SC_WK_CUR_A W_RTL_SLS_LC_DY_A W_RTL_SLS_LC_WK_A |
W_RTL_SLS_IT_LC_DY_SN_A W_RTL_SLS_IT_LC_WK_SN_A W_RTL_SLS_IT_DY_SN_A W_RTL_SLS_IT_WK_SN_A |
|
Sales Discount |
W_RTL_SLSDSC_TRX_IT_LC_DY_F |
|||||
|
Sales Forecast |
W_RTL_SLSFC_IT_LC_DY_F W_RTL_SLSFC_IT_LC_WK_F |
W_RTL_SLSFC_SC_LC_DY_A W_RTL_SLSFC_SC_LC_WK_A |
W_RTL_SLSFC_SC_LC_DY_CUR_A W_RTL_SLSFC_SC_LC_WK_CUR_A |
W_RTL_SLSFC_IT_DY_A W_RTL_SLSFC_IT_WK_A W_RTL_SLSFC_SC_DY_A W_RTL_SLSFC_SC_WK_A |
W_RTL_SLSFC_IT_DY_A W_RTL_SLSFC_IT_WK_A W_RTL_SLSFC_SC_DY_CUR_A W_RTL_SLSFC_SC_WK_CUR_A |
W_RTL_SLSFC_IT_LC_DY_SN_A W_RTL_SLSFC_IT_LC_WK_SN_A W_RTL_SLSFC_IT_DY_SN_A W_RTL_SLSFC_IT_WK_SN_A |
|
Sales Pack |
W_RTL_SLSPK_IT_LC_DY_F |
W_RTL_SLSPK_IT_LC_WK_A |
W_RTL_SLSPK_IT_DY_A W_RTL_SLSPK_IT_WK_A |
W_RTL_SLSPK_IT_DY_A W_RTL_SLSPK_IT_WK_A |
W_RTL_SLSPK_IT_LC_DY_SN_A W_RTL_SLSPK_IT_LC_WK_SN_A W_RTL_SLSPK_IT_DY_SN_A W_RTL_SLSPK_IT_WK_SN_A |
|
|
Sales Promotion |
W_RTL_SLSPR_TRX_IT_LC_DY_F |
W_RTL_SLSPR_PC_CS_IT_LC_DY_AW_RTL_SLSPR_PC_CUST_LC_DY_AW_RTL_SLSPR_PC_HH_WK_AW_RTL_SLSPR_PC_IT_LC_DY_AW_RTL_SLSPR_PE_CS_IT_LC_DY_AW_RTL_SLSPR_PE_CUST_LC_DY_AW_RTL_SLSPR_PE_IT_LC_DY_AW_RTL_SLSPR_PP_CS_IT_LC_DY_AW_RTL_SLSPR_PP_CUST_LC_DY_AW_RTL_SLSPR_PP_IT_LC_DY_A |
W_RTL_SLSPR_PC_CS_IT_ LC_DY_A W_RTL_SLSPR_PC_IT_LC_ DY_A W_RTL_SLSPR_PC_CUST_ LC_DY_A W_RTL_SLSPR_PC_HH_WK_ A W_RTL_SLSPR_PE_CS_IT_ LC_DY_A W_RTL_SLSPR_PE_CUST_ LC_DY_A
W_RTL_SLSPR_PE_IT_LC_ DY_A W_RTL_SLSPR_PP_CS_IT_ LC_DY_A
W_RTL_SLSPR_PP_CUST_ LC_DY_A
W_RTL_SLSPR_PP_IT_LC_ DY_A |
|||
|
Stock Ledger |
W_RTL_STCK_LDGR_SC_LC_WK_F W_RTL_STCK_LDGR_SC_LC_MH_F |
|||||
|
Store Traffic |
W_RTL_STTRFC_LC_DY_MI_F |
|||||
|
Supplier Compliance |
W_RTL_SUPPCM_IT_LC_DY_F W_RTL_SUPPCMUF_LC_DY_F |
W_RTL_SUPPCM_IT_LC_WK_A W_RTL_SUPPCMUF_LC_WK_A |
W_RTL_SUPPCM_IT_LC_WK_A W_RTL_SUPPCMUF_LC_WK_A |
W_RTL_SUPPCM_LC_WK_A |
W_RTL_SUPPCM_LC_WK_A |
|
|
Supplier Invoice |
W_RTL_SUPP_IVC_PO_IT_F |
|||||
|
Transaction Tender |
W_RTL_TRX_TNDR_LC_DY_F |
|||||
|
Unit Cost |
W_RTL_BCOST_IT_LC_DY_F |
W_RTL_BCOST_IT_DY_A |
W_RTL_BCOST_IT_DY_A |
|||
|
Wholesale Franchise |
W_RTL_SLSWF_IT_LC_DY_F |
W_RTL_SLSWF_IT_LC_WK_A W_RTL_SLSWF_SC_LC_DY_A W_RTL_SLSWF_SC_LC_WK_A |
W_RTL_SLSWF_IT_LC_WK_A W_RTL_SLSWF_SC_LC_DY_CUR_A W_RTL_SLSWF_SC_LC_WK_CUR_A |
W_RTL_SLSWF_IT_DY_A W_RTL_SLSWF_IT_WK_A |
W_RTL_SLSWF_IT_DY_A W_RTL_SLSWF_IT_WK_A |
|
|
CO Tender Type |
W_RTL_CO_HEAD_TNDR_LC_DY_F |
|||||
|
CO Promotion Transaction |
W_RTL_COPR_LINE_IT_LC_DY_F W_RTL_COPR_HEAD_LC_DY_F |
|||||
|
Market Sales |
W_RTL_MKTSLS_TA_CH_CNG_WK_F W_RTL_MKTSLS_TA_CH_HG_WK_F |
W_RTL_MKTSLS_TA_CL_CS_QR_CUR_A W_RTL_MKTSLS_TA_CL_QR_CUR_A W_RTL_MKTSLS_TA_CMG_CS_QR_A W_RTL_MKTSLS_TA_CMG_QR_A |
||||
|
Customer Order Fulfillment |
W_RTL_CO_LINE_FL_IT_LC_DY_F |
W_RTL_COFL_IT_LC_DY_A W_RTL_COFL_IT_LC_WK_A W_RTL_COFL_SC_LC_DY_A W_RTL_COFL_SC_LC_WK_A |
W_RTL_COFL_IT_LC_DY_A W_RTL_COFL_IT_LC_WK_A W_RTL_COFL_SC_LC_DY_CUR_A W_RTL_COFL_SC_LC_WK_CUR_A |
W_RTL_COFL_IT_CH_DY_A W_RTL_COFL_IT_CH_WK_A W_RTL_COFL_SC_CH_DY_A W_RTL_COFL_SC_CH_WK_A |
W_RTL_COFL_IT_CH_DY_A W_RTL_COFL_IT_CH_WK_A W_RTL_COFL_SC_CH_DY_CUR_A W_RTL_COFL_SC_CH_WK_CUR_A |
W_RTL_COFL_IT_CH_DY_SN_A W_RTL_COFL_IT_CH_WK_SN_A W_RTL_COFL_IT_LC_DY_SN_A W_RTL_COFL_IT_LC_WK_SN_A |
|
Customer Order Status |
W_RTL_CO_LINE_STATUS_F |
W_RTL_CO_STATUS_IT_LC_CH_DY_A W_RTL_CO_STATUS_IT_LC_CH_WK_A W_RTL_CO_STATUS_SC_LC_CH_DY_A W_RTL_CO_STATUS_SC_LC_CH_WK_A |
W_RTL_CO_STATUS_IT_LC_CH_DY_A W_RTL_CO_STATUS_IT_LC_CH_WK_A |
W_RTL_CO_STATUS_IT_CH_DY_A W_RTL_CO_STATUS_IT_CH_WK_A W_RTL_CO_STATUS_SC_CH_DY_A W_RTL_CO_STATUS_SC_CH_WK_A |
W_RTL_CO_STATUS_IT_CH_DY_A W_RTL_CO_STATUS_IT_CH_WK_A W_RTL_CO_STATUS_SC_CH_DY_CUR_A W_RTL_CO_STATUS_SC_CH_WK_CUR_A |
|
|
Customer Order Transaction |
W_RTL_CO_HEAD_LC_DY_F W_RTL_CO_LINE_IT_LC_DY_F |
W_RTL_CO_IT_LC_CH_DY_A W_RTL_CO_IT_LC_CH_WK_A W_RTL_CO_SC_LC_CH_DY_A W_RTL_CO_SC_LC_CH_WK_A W_RTL_CO_CS_IT_LC_CH_DY_A |
W_RTL_CO_IT_LC_CH_DY_A W_RTL_CO_IT_LC_CH_WK_A W_RTL_CO_SC_LC_CH_DY_CUR_A W_RTL_CO_SC_LC_CH_WK_CUR_A W_RTL_CO_CS_IT_LC_CH_DY_A |
W_RTL_CO_IT_CH_DY_A W_RTL_CO_IT_CH_WK_A W_RTL_CO_SC_CH_DY_A W_RTL_CO_SC_CH_WK_A |
W_RTL_CO_IT_CH_DY_A W_RTL_CO_IT_CH_WK_A W_RTL_CO_SC_CH_DY_CUR_A W_RTL_CO_SC_CH_WK_CUR_A |
W_RTL_CO_IT_LC_CH_DY_SN_A W_RTL_CO_IT_LC_CH_WK_SN_A W_RTL_CO_IT_CH_DY_SN_A W_RTL_CO_IT_CH_WK_SN_A |
|
Gift Card Sales |
W_RTL_GCN_TRX_LC_DY_F |
|||||
|
Touch Point |
W_RTL_CO_HEAD_TP_LC_DY_F |
|||||
|
Customer Loyalty |
W_RTL_CUST_LYL_TRX_LC_DY_F |
|||||
|
Customer Loyalty |
W_RTL_CUST_LYL_AWD_TRX_DY_F |