Context
Reference catalog of the RDE (Retail Data Extractor) input interfaces that feed AIF DATA. Each row maps a functional area to the AIF DATA extract job, the source tables it reads, and the AIF DATA target (staging or dimension) tables it populates.
The table below have more columns, so slide it by selecting or using the touchpad in order to check full information
| Functional Area | AIF DATA Job Name | Source Tables | AIF DATA Target Tables |
|---|---|---|---|
| Allocations | RDE_ALLOCDETAILDYSDE_INITIAL_JOB | ALLOC_HEADER, ALLOC_DETAIL, ITEM_LOC_SOH_EOD, ITEM_MASTER | W_RTL_ALC_IT_LC_DY_FS |
| Allocations | RDE_EXTRACT_FACT_P9_ALLOCDETAILDYSDE_JOB | ALLOC_HEADER, ALLOC_DETAIL, ITEM_LOC_SOH_EOD, ITEM_MASTER | W_RTL_ALC_IT_LC_DY_FS |
| Allocations | RDE_EXTRACT_DIM_P10_ALCDETAILSSDE_JOB | ALLOC_HEADER | W_RTL_ALC_DETAILS_DS |
| Application Codes | RDE_EXTRACT_DIM_P18_DOMAINMEMLKUPSDE_JOB (Codes) | LANG, W_LANGUAGES_G, CODE_DETAIL, CODE_DETAIL_TL | W_DOMAIN_MEMBER_DS_TL |
| Application Codes | RDE_EXTRACT_DIM_P8_APPCODEDTLSDE_JOB | CODE_DETAIL | W_RTL_CODE_DS |
| Application Codes | RDE_EXTRACT_DIM_P8_NMCODESDE_JOB | NON_MERCH_CODE_COMP, ELC_COMP | W_RTL_NON_MERCH_CODE_DS |
| Business Calendar | ETLREFRESHGENSDE_JOB | SYSTEM_OPTIONS, PERIOD, SYSTEM_VARIABLES | RA_SRC_CURR_PARAM_G, C_LOAD_DATES |
| Business Calendar | RDE_EXTRACT_DIM_P12_MCALPERIODSDE_JOB | CALENDAR, SYSTEM_OPTIONS | W_MCAL_PERIOD_DS |
| Clearances | RDE_EXTRACT_CLRPRICESDE_DIM_LOAD_JOB | XTERN_CLRPC, RPM_CLEARANCE, RPM_CLEARANCE_GROUP | W_RTL_PRICE_CLR_IT_LC_DS |
| Clearances | RDE_CLRPRICESDE_XTERN_INITIAL_JOB | RPM_RDE_CLEARANCE_DATA | XTERN_CLRPC |
| Clearances | RDE_EXTRACT_CLRPRICESDE_XTERN_JOB | RPM_RDE_CLEARANCE_DATA | XTERN_CLRPC |
| Cluster/Price Zone | RDE_EXTRACT_DIM_P18_DOMAINMEMLKUPSDE_JOB (Price Zones) | LANG, W_LANGUAGES_G, RPM_ZONE_GROUP, RPM_ZONE | W_DOMAIN_MEMBER_DS_TL |
| Cluster/Price Zone | RDE_EXTRACT_DIM_P6_PRICEZONESDE_JOB | RPM_ZONE_GROUP, RPM_ZONE, RPM_ZONE_LOCATION, RPM_MERCH_RETAIL_DEF, RPM_MARKDOWN_ZONE_GROUP_DEF | W_RTL_CLSTR_GRP_DS, W_RTL_CLSTR_HDR_DS, W_RTL_CLSTR_GRP_HDR_LC_DS, W_RTL_CLSTR_GRP_PRD_DS |
| Competitive Pricing | RDE_EXTRACT_FACT_P2_COMPPRICINGSDE_JOB | STORE, COMP_STORE_LINK, COMP_PRICE_HIST, Currency Codes (STORE, WH, PARTNER) | W_RTL_COMP_PRICE_IT_LC_DY_FS |
| Competitive Pricing | RDE_SEEDCOMPPRICINGSDE_JOB | STORE, COMP_STORE_LINK, COMP_PRICE_HIST, Currency Rates (MV_CURRENCY_CONVERSION_RATES, STORE, WH, PARTNER) | W_RTL_COMP_PRICE_IT_LC_DY_FS |
| Competitive Pricing | RDE_EXTRACT_DIM_P15_COMPSTORESDE_JOB | COMPETITOR, COMP_STORE | W_RTL_COMP_STORE_DS |
| Costs | CSTISLDSDE_JOB | V_ITEM_SUPP_COUNTRY_LOC, PRICE_HIST, ITEM_LOC, V_PACKSKU_QTY, ITEM_MASTER, Currency Rates (MV_CURRENCY_CONVERSION_RATES, STORE, WH, PARTNER) | W_RTL_BCOST_IT_LC_DY_FS |
| Costs | RDE_EXTRACT_FACT_P1_NCSTILDSDE_JOB | FUTURE_COST, ITEM_MASTER, ITEM_SUPP_COUNTRY, V_PACKSKU_QTY, Currency Rates (MV_CURRENCY_CONVERSION_RATES, STORE, WH, PARTNER) | W_RTL_NCOST_IT_LC_DY_FS |
| Costs | RDE_SEEDCSTISLDSDE_JOB | V_ITEM_SUPP_COUNTRY_LOC, PRICE_HIST, ITEM_LOC, V_PACKSKU_QTY, ITEM_MASTER, Currency Rates (MV_CURRENCY_CONVERSION_RATES, STORE, WH, PARTNER) | W_RTL_BCOST_IT_LC_DY_FS |
| Costs | RDE_SEEDNCSTILDSDE_JOB | FUTURE_COST, ITEM_MASTER, ITEM_SUPP_COUNTRY, V_PACKSKU_QTY, Currency Rates (MV_CURRENCY_CONVERSION_RATES, STORE, WH, PARTNER) | W_RTL_NCOST_IT_LC_DY_FS |
| Custom Flex Attributes (CFAS) | RDE_EXTRACT_DIM_P18_DOMAINMEMLKUPSDE_JOB (CFA Labels) | LANG, W_LANGUAGES_G, CFA_ATTRIB_GROUP, CFA_ATTRIB_GROUP_LABELS,CFA_ATTRIB_GROUP_SET, CFA_ATTRIB_GROUP_SET_LABELS, CFA_ATTRIB, CFA_ATTRIB_LABELS | W_DOMAIN_MEMBER_DS_TL |
| Custom Flex Attributes (CFAS) | RDE_EXTRACT_DIM_P4_ITEMCFASDE_JOB | CFA_ATTRIB, CFA_ATTRIB_GROUP, CFA_ATTRIB_GROUP_SET, CFA_REC_GROUP, ITEM_MASTER_CFA_EXT | W_PRODUCT_DS_CFA |
| Custom Flex Attributes (CFAS) | RDE_EXTRACT_DIM_P4_ITEMLOCCFASDE_JOB | CFA_ATTRIB, CFA_ATTRIB_GROUP, CFA_ATTRIB_GROUP_SET, CFA_REC_GROUP, ITEM_LOC_CFA_EXT | W_RTL_IT_LC_DS_CFA |
| Custom Flex Attributes (CFAS) | RDE_EXTRACT_DIM_P4_LOCCFASDE_JOB | CFA_ATTRIB, CFA_ATTRIB_GROUP, CFA_ATTRIB_GROUP_SET, CFA_REC_GROUP, STORE_CFA_EXT, WH_CFA_EXT, PARTNER_CFA_EXT | W_INT_ORG_DS_CFA |
| Custom Flex Attributes (CFAS) | RDE_EXTRACT_DIM_P4_PRDCFAHIERSDE_JOB | CFA_ATTRIB, CFA_ATTRIB_GROUP, CFA_ATTRIB_GROUP_SET, CFA_REC_GROUP, DEPS, DEPS_CFA_EXT, CLASS, CLASS_CFA_EXT, SUBCLASS, SUBCLASS_CFA_EXT | W_PROD_CAT_DHS_CFA |
| Custom Flex Attributes (CFAS) | RDE_EXTRACT_DIM_P4_SUPPCFASDE_JOB | CFA_ATTRIB, CFA_ATTRIB_GROUP, CFA_ATTRIB_GROUP_SET, CFA_REC_GROUP, SUPS_CFA_EXT | W_PARTY_ORG_DS_CFA |
| Customer | RDE_EXTRACT_CE_DIM_CUSTADDR_JOB | RI_CUSTOMER_ADDRESS_VIEW | W_RTL_CUST_ADDRESS_DS |
| Customer | RDE_EXTRACT_CE_DIM_CUSTDEDUP_JOB | CST_CUST_ALT_KEY | W_RTL_CUST_DEDUP_DS |
| Customer | RDE_EXTRACT_CE_DIM_CUSTHOUSEHOLD_JOB | RI_CUSTOMER_HOUSEHOLD_VIEW | W_RTL_CUST_HOUSEHOLD_DS |
| Customer | RDE_EXTRACT_CE_DIM_HOUSEHOLD_JOB | RI_HOUSEHOLD_VIEW | W_HOUSEHOLD_DS |
| Customer | RDE_EXTRACT_CE_DIM_PARTY_JOB | RI_CUSTOMER_VIEW | W_PARTY_PER_DS |
| Customer | RDE_EXTRACT_CE_DIM_PARTYATTR_JOB | RI_CUSTOMER_ATTRIBUTE_VIEW | W_RTL_PARTY_PER_ATTR_DS |
| Customer Loyalty | RDE_EXTRACT_CE_DIM_CUSTLOYALTY_JOB | RI_LOYALTY_ACCOUNT_VIEW | W_RTL_CUST_LYL_ACCT_DS |
| Customer Loyalty | RDE_EXTRACT_CE_DIM_CUSTLOYALTYPROG_JOB | RI_LOYALTY_PROGRAM_VIEW | W_RTL_CUST_LYL_PROG_DS |
| Customer Loyalty | RDE_EXTRACT_CE_FACT_CUSTLOYALTYAWD_JOB | RI_LOYALTY_AWARD_TRANSACTION_VIEW | W_RTL_CUST_LYL_AWD_TRX_DY_FS |
| Customer Loyalty | RDE_EXTRACT_CE_FACT_CUSTLOYALTYTRANS_JOB | RI_LOYALTY_TRANSACTION_VIEW | W_RTL_CUST_LYL_TRX_LC_DY_FS |
| Customer Segment | RDE_EXTRACT_CE_DIM_CUSTSEG_JOB | RI_SEGMENT_CUSTOMER_VIEW | W_RTL_CUST_CUSTSEG_DS |
| Customer Segment | RDE_EXTRACT_CE_DIM_CUSTSEGATTR_DS_JOB | RI_SEGMENT_ATTRIBUTE_VIEW | W_RTL_CUSTSEG_ATTR_DS |
| Customer Segment | RDE_EXTRACT_CE_DIM_SEGMENT_JOB | RI_SEGMENT_VIEW | W_RTL_CUSTSEG_DS |
| Data Security | RDE_EXTRACT_DIM_P2_FILTERGROUPMERCHSDE_JOB | FILTER_GROUP_MERCH | RAF_FILTER_GROUP_MERCH |
| Data Security | RDE_EXTRACT_DIM_P2_FILTERGROUPORGSDE_JOB | FILTER_GROUP_ORG | RAF_FILTER_GROUP_ORG |
| Data Security | RDE_EXTRACT_DIM_P2_SECGROUPSDE_JOB | SEC_GROUP | RAF_SEC_GROUP |
| Data Security | RDE_EXTRACT_DIM_P2_SECUSERGROUPSDE_JOB | SEC_USER_GROUP | RAF_SEC_USER_GROUP |
| Data Security | RDE_EXTRACT_DIM_P2_SECUSERSDE_JOB | SEC_USER | RAF_SEC_USER |
| Deal Income | RDE_DEALINILDSDE_INITIAL_JOB | TRAN_DATA_HISTORY, DEAL_HEAD, ITEM_MASTER, Currency Rates (STORE, WH, PARTNER) | W_RTL_DEALINC_IT_LC_DY_FS |
| Deal Income | RDE_EXTRACT_FACT_P8_DEALINILDSDE_JOB | IF_TRAN_DATA, DEAL_HEAD, ITEM_MASTER, Currency Codes (STORE, WH, PARTNER) | W_RTL_DEALINC_IT_LC_DY_FS |
| Deal Income | RDE_EXTRACT_FACT_P12_DEALACTILDSDE_JOB | DEAL_ACTUALS_ITEM_LOC | W_RTL_DEALACT_IT_LC_DY_FS |
| Deal Income | RDE_EXTRACT_DIM_P20_DEALDETAILSDE_JOB | DEAL_HEAD, DEAL_DETAIL, DEAL_THRESHOLD, DEAL_COMP_TYPE_TL | W_RTL_DEAL_DETAIL_DS |
| Deal Income | RDE_EXTRACT_DIM_P20_DEALHEADSDE_JOB | DEAL_HEAD, DEAL_DETAIL, DEAL_COMP_TYPE_TL, SUPS, PARTNER | W_RTL_DEAL_DS |
| Differentiator Groups | RDE_EXTRACT_DIM_P8_DIFFGRPSDE_JOB | DIFF_GROUP_HEAD, DIFF_GROUP_DETAIL, DIFF_GROUP_HEAD_TL | W_RTL_DIFF_GRP_DS, W_RTL_DIFF_GRP_DS_TL |
| Differentiator Ranges | RDE_EXTRACT_DIM_P8_DIFFRNGSDE_JOB | DIFF_RANGE_HEAD, DIFF_RANGE_DETAIL, DIFF_RANGE_HEAD_TL | W_RTL_DIFF_RNG_DS, W_RTL_DIFF_RNG_DS_TL |
| Discount Type | RDE_EXTRACT_DIM_P8_DSCTYPSDE_JOB | CODE_HEAD, CODE_DETAIL | W_RTL_DISCOUNT_TYPE_DS |
| Exchange Rates | RDE_EXTRACT_DIM_P16_EXCHGRATEGENSDE_JOB | MV_CURRENCY_CONVERSION_RATES | W_EXCH_RATE_GS |
| Exchange Rates | RDE_EXTRACT_DIM_P18_DOMAINMEMLKUPSDE_JOB (Currencies) | LANG, W_LANGUAGES_G, CURRENCIES, CURRENCIES_TL | W_DOMAIN_MEMBER_DS_TL |
| Expenses and Allowances | RDE_EXTRACT_FACT_P7_IVRCEXPILDSDE_JOB | IF_TRAN_DATA, ITEM_MASTER, Currency Codes (STORE, WH, PARTNER) | W_RTL_INVRC_EXP_IT_LC_DY_FS |
| Intercompany Margins | RDE_EXTRACT_FACT_P8_INTCMPMRGINSDE_JOB | IF_TRAN_DATA, ITEM_MASTER, Currency Codes (STORE, WH, PARTNER) | W_RTL_ICM_IT_LC_DY_FS |
| Intercompany Margins | RDE_INTCMPMRGINSDE_HIST_JOB | TRAN_DATA_HISTORY, ITEM_MASTER, Currency Rates (STORE, WH, PARTNER) | W_RTL_ICM_IT_LC_DY_FS |
| Inventory | RDE_EXTRACT_DIM_P18_DOMAINMEMLKUPSDE_JOB (Adjustment Reason) | LANG, W_LANGUAGES_G, INV_ADJ_REASON, INV_ADJ_REASON_TL | W_DOMAIN_MEMBER_DS_TL |
| Inventory | RDE_EXTRACT_FACT_P4_IVRTVILDSDE_JOB | IF_TRAN_DATA, RTV_HEAD, RTV_DETAIL, ITEM_LOC, ITEM_MASTER, V_PACKSKU_QTY, SUPS, Currency Codes (STORE, WH, PARTNER) | W_RTL_INVRTV_IT_LC_DY_FS |
| Inventory | RDE_EXTRACT_FACT_P7_INVILDSDE_JOB | ITEM_LOC_SOH_EOD, IF_TRAN_DATA, ITEM_MASTER, ITEM_LOC, REPL_ITEM_LOC, V_PACKSKU_QTY, V_ITEM_SUPP_COUNTRY_LOC, ORDHEAD, ORDHEAD_REV, ORDLOC, ORDLOC_REV, ORDCUST, ORDCUST_DETAIL, PRICE_HIST, WEEK_DATA, SYSTEM_CONFIG_OPTIONS, FINANCIAL_UNIT_OPTIONS, SYSTEM_VARIABLES, Currency Rates (MV_CURRENCY_CONVERSION_RATES, STORE, WH, PARTNER), SVAT Tax (DEPS, VAT_ITEM, SYSTEM_OPTIONS), Global Tax (GTS_ITEM_TAX, GTS_MERCH_TAX, GTS_RULES_CONFIG) | W_RTL_INV_IT_LC_DY_FS |
| Inventory | RDE_EXTRACT_FACT_P7_INVPKILDSDE_JOB | ITEM_LOC_SOH_EOD, IF_TRAN_DATA, ITEM_MASTER, ITEM_LOC, V_ITEM_SUPP_COUNTRY_LOC, ORDHEAD, ORDHEAD_REV, ORDLOC, ORDLOC_REV, PRICE_HIST, WEEK_DATA, SYSTEM_CONFIG_OPTIONS, FINANCIAL_UNIT_OPTIONS, SYSTEM_VARIABLES, Currency Rates (MV_CURRENCY_CONVERSION_RATES, STORE, WH, PARTNER), SVAT Tax (DEPS, VAT_ITEM, SYSTEM_OPTIONS), Global Tax (GTS_ITEM_TAX, GTS_MERCH_TAX, GTS_RULES_CONFIG) | W_RTL_INVPK_IT_LC_DY_FS |
| Inventory | RDE_EXTRACT_FACT_P7_INVRECLASSSDE_JOB | TRAN_DATA_HISTORY, ITEM_MASTER, Currency Codes (STORE, WH, PARTNER) | W_RTL_INVRECLASS_IT_LC_DY_FS |
| Inventory | RDE_EXTRACT_FACT_P7_IVADJILDSDE_JOB | IF_TRAN_DATA, ITEM_MASTER, Currency Codes (STORE, WH, PARTNER) | W_RTL_INVADJ_IT_LC_DY_FS |
| Inventory | RDE_EXTRACT_FACT_P7_IVRCPILDSDE_JOB | IF_TRAN_DATA, ITEM_MASTER, SHIPSKU_V, Currency Codes (STORE, WH, PARTNER) | W_RTL_INVRC_IT_LC_DY_FS |
| Inventory | RDE_EXTRACT_FACT_P7_IVTSFILDSDE_JOB | IF_TRAN_DATA, ITEM_MASTER, Currency Codes (STORE, WH, PARTNER) | W_RTL_INVTSF_IT_LC_DY_FS |
| Inventory | RDE_INVRECLASSSDE_HIST_JOB | TRAN_DATA_HISTORY, ITEM_MASTER, Currency Rates (STORE, WH, PARTNER) | W_RTL_INVRECLASS_IT_LC_DY_FS |
| Inventory | RDE_IVADJILDSDE_INITIAL_JOB | TRAN_DATA_HISTORY, ITEM_MASTER, Currency Rates (STORE, WH, PARTNER) | W_RTL_INVADJ_IT_LC_DY_FS |
| Inventory | RDE_IVRCPILDSDE_INITIAL_JOB | TRAN_DATA_HISTORY, ITEM_MASTER, SHIPSKU_V, Currency Rates (STORE, WH, PARTNER) | W_RTL_INVRC_IT_LC_DY_FS |
| Inventory | RDE_IVRTVILDSDE_INITIAL_JOB | TRAN_DATA_HISTORY, RTV_HEAD, RTV_DETAIL, ITEM_LOC, ITEM_MASTER, V_PACKSKU_QTY, SUPS, Currency Rates (STORE, WH, PARTNER) | W_RTL_INVRTV_IT_LC_DY_FS |
| Inventory | RDE_IVTSFILDSDE_INITIAL_JOB | TRAN_DATA_HISTORY, ITEM_MASTER, Currency Rates (STORE, WH, PARTNER) | W_RTL_INVTSF_IT_LC_DY_FS |
| Inventory | RDE_SEEDINVILDSDE_JOB | ITEM_LOC_SOH_EOD, ITEM_MASTER, ITEM_LOC, REPL_ITEM_LOC, V_PACKSKU_QTY, V_ITEM_SUPP_COUNTRY_LOC, ORDHEAD, ORDHEAD_REV, ORDLOC, ORDLOC_REV, ORDCUST, ORDCUST_DETAIL, PRICE_HIST, WEEK_DATA, SYSTEM_CONFIG_OPTIONS, FINANCIAL_UNIT_OPTIONS, SYSTEM_VARIABLES, Currency Rates (MV_CURRENCY_CONVERSION_RATES, STORE, WH, PARTNER), SVAT Tax (DEPS, VAT_ITEM, SYSTEM_OPTIONS), Global Tax (GTS_ITEM_TAX, GTS_MERCH_TAX, GTS_RULES_CONFIG) | W_RTL_INV_IT_LC_DY_FS |
| Inventory | RDE_EXTRACT_DIM_P18_DOMAINMEMLKUPSDE_JOB (Inv Status) | LANG, W_LANGUAGES_G, INV_STATUS_TYPES, INV_STATUS_TYPES_TL | W_DOMAIN_MEMBER_DS_TL |
| Inventory | RDE_EXTRACT_DIM_P18_DOMAINMEMLKUPSDE_JOB (RTV Reason) | LANG, W_LANGUAGES_G, CODE_DETAIL, CODE_DETAIL_TL | W_DOMAIN_MEMBER_DS_TL |
| Inventory Transfer Detail | RDE_EXTRACT_FACT_P4_TSFILDSDE_JOB | TSFHEAD, TSFDETAIL, V_PACKSKU_QTY, ITEM_MASTER, ORDHEAD, ITEM_LOC_SOH_EOD, Currency Rates (MV_CURRENCY_CONVERSION_RATES, STORE, WH, PARTNER) | W_RTL_TSF_IT_LC_DY_FS |
| Inventory Transfer Detail | RDE_TSFILDSDE_INITIAL_JOB | TSFHEAD, TSFDETAIL, V_PACKSKU_QTY, ITEM_MASTER, ORDHEAD, ITEM_LOC_SOH_EOD, Currency Rates (MV_CURRENCY_CONVERSION_RATES, STORE, WH, PARTNER) | W_RTL_TSF_IT_LC_DY_FS |
| Inventory Transfer Detail | RDE_EXTRACT_DIM_P7_TSFDETAILSDE_JOB | TSFHEAD | W_RTL_TSF_DETAILS_DS |
| Inventory Unavailable | RDE_EXTRACT_FACT_P7_UNAVINVILDSDE_JOB | INV_STATUS_QTY, ITEM_MASTER, ITEM_LOC, PRICE_HIST, ITEM_LOC_SOH_EOD, V_ITEM_SUPP_COUNTRY_LOC, Currency Codes (STORE, WH, PARTNER) | W_RTL_INVU_IT_LC_DY_FS |
| Inventory Unavailable | RDE_SEEDUNAVINVILDSDE_JOB | INV_STATUS_QTY, ITEM_MASTER, ITEM_LOC, ITEM_LOC_SOH_EOD, V_ITEM_SUPP_COUNTRY_LOC, STORE, WH, PARTNER | W_RTL_INVU_IT_LC_DY_FS |
| Inventory Unavailable | RDE_EXTRACT_DIM_P8_STATUSSDE_JOB | INV_STATUS_TYPES | W_STATUS_DS |
| Location Closures | RDE_EXTRACT_DIM_P19_COMPCLOSEDEXCEPSDE_JOB | COMPANY_CLOSED_EXCEP | W_RTL_CMP_CLOSED_EXC_DS |
| Location Closures | RDE_EXTRACT_DIM_P19_COMPCLOSEDSDE_JOB | COMPANY_CLOSED | W_RTL_CMP_CLOSED_DS |
| Location Closures | RDE_EXTRACT_DIM_P5_LOCCLOSESDE_JOB | LOCATION_CLOSED | W_RTL_LOC_CLOSED_DS |
| Location Hierarchy | RDE_EXTRACT_DIM_P18_DOMAINMEMLKUPSDE_JOB (Channels) | LANG, W_LANGUAGES_G, BANNER, BANNER_TL, CHANNELS, CHANNELS_TL | W_DOMAIN_MEMBER_DS_TL |
| Location Hierarchy | RDE_EXTRACT_DIM_P18_DOMAINMEMLKUPSDE_JOB (Organization) | LANG, W_LANGUAGES_G, DISTRICT, DISTRICT_TL, REGION, REGION_TL, AREA, AREA_TL, REGION, REGION_TL, CHAIN, CHAIN_TL, COMPHEAD, COMPHEAD_TL | W_DOMAIN_MEMBER_DS_TL |
| Location Hierarchy | RDE_EXTRACT_DIM_P18_DOMAINMEMLKUPSDE_JOB (Store Format) | LANG, W_LANGUAGES_G, STORE_FORMAT, STORE_FORMAT_TL | W_DOMAIN_MEMBER_DS_TL |
| Location Hierarchy | RDE_EXTRACT_DIM_P18_DOMAINMEMLKUPSDE_JOB (Transfer Entity) | LANG, W_LANGUAGES_G, TSF_ENTITY, TSF_ENTITY_TL, | W_DOMAIN_MEMBER_DS_TL |
| Location Hierarchy | RDE_EXTRACT_DIM_P6_ORGCHNCTRYSDE_JOB | V_PLANNING_STORE, V_PLANNING_WH | W_RTL_CHANNEL_CNTRY_DS |
| Location Hierarchy | RDE_EXTRACT_DIM_P6_ORGCHNSDE_JOB | BANNER, CHANNELS | W_RTL_CHANNEL_DS |
| Location Hierarchy | RDE_EXTRACT_DIM_P6_ORGHIERSDE_JOB | COMPHEAD, CHAIN, REGION, AREA, DISTRICT, STORE, WH, PARTNER | W_INT_ORG_DHS |
| Location Hierarchy | RDE_EXTRACT_DIM_P6_ORGLOCSDE_JOB | STORE, WH, PARTNER, SYSTEM_OPTIONS, ADD_TYPE, ADD_TYPE_TL, ADDR, ADD_TYPE_MODULE, BANNER, CHANNELS, CURRENCIES, STATE, COUNTRY, STORE_FORMAT, TSFZONE, WF_CUSTOMER, LANG, STORE_TL, WH_TL, PARTNER_TL | W_INT_ORG_DS, W_INT_ORG_DS_TL, W_INT_ORG_ATTR_DS |
| Location Hierarchy | RDE_EXTRACT_DIM_P6_ORGLOLSDE_JOB | LOC_LIST_HEAD, LOC_LIST_DETAIL | W_RTL_LOC_LIST_DS |
| Location Hierarchy | RDE_EXTRACT_DIM_P6_ORGLTMSDE_JOB | LOC_TRAITS, LOC_TRAITS_MATRIX | W_RTL_LOC_TRAIT_DS |
| Markdown | RDE_EXTRACT_FACT_P8_SLSMKDNILDSDE_JOB | IF_TRAN_DATA, ITEM_MASTER, Currency Codes (STORE, WH, PARTNER) | W_RTL_MKDN_IT_LC_DY_FS |
| Prices | RDE_EXTRACT_FACT_P2_PRCILDSDE_JOB | PRICE_HIST, ITEM_MASTER, Currency Codes (STORE, WH, PARTNER) | W_RTL_PRICE_IT_LC_DY_FS |
| Prices | RDE_SEEDPRCILDSDE_JOB | PRICE_HIST, ITEM_MASTER, Currency Rates (MV_CURRENCY_CONVERSION_RATES, STORE, WH, PARTNER) | W_RTL_PRICE_IT_LC_DY_FS |
| Product Hierarchy | RDE_EXTRACT_DIM_P1_PRDDIFFSDE_JOB | ITEM_MASTER, DIFF_IDS, DIFF_TYPE, V_PACKSKU_QTY, BRAND | W_RTL_ITEM_GRP1_DS |
| Product Hierarchy | RDE_EXTRACT_DIM_P1_PRDITMGRP2SDE_JOB | V_PACKSKU_QTY | W_RTL_ITEM_GRP2_DS |
| Product Hierarchy | RDE_EXTRACT_DIM_P1_PRDITMLSDE_JOB | SKULIST_HEAD, SKULIST_DETAIL, RDS_SKULIST_DETAIL_DELETE | W_RTL_ITEM_GRP1_DS |
| Product Hierarchy | RDE_EXTRACT_DIM_P1_PRDITMUDSDE_JOB | UDA_VALUES, UDA_ITEM_DATE, UDA_ITEM_FF, UDA_ITEM_LOV, RDS_UDA_ITEM_FF_DELETE, RDS_UDA_ITEM_DATE_DELETE, RDS_UDA_ITEM_LOV_DELETE, ITEM_MASTER, V_PACKSKU_QTY | W_RTL_ITEM_GRP1_DS |
| Product Hierarchy | RDE_EXTRACT_DIM_P1_PRDITMXFORMSDE_JOB | ITEM_XFORM_HEAD, ITEM_XFORM_DETAIL | W_RTL_ITEM_XFORM_DS |
| Product Hierarchy | RDE_EXTRACT_DIM_P18_DOMAINMEMLKUPSDE_JOB (Color) | LANG, W_LANGUAGES_G, DIFF_IDS, DIFF_IDS_TL | W_DOMAIN_MEMBER_DS_TL |
| Product Hierarchy | RDE_EXTRACT_DIM_P18_DOMAINMEMLKUPSDE_JOB (Diff Types) | LANG, W_LANGUAGES_G, DIFF_TYPE, DIFF_TYPE_TL | W_DOMAIN_MEMBER_DS_TL |
| Product Hierarchy | RDE_EXTRACT_DIM_P18_DOMAINMEMLKUPSDE_JOB (Diffs) | LANG, W_LANGUAGES_G, DIFF_IDS, DIFF_IDS_TL | W_DOMAIN_MEMBER_DS_TL |
| Product Hierarchy | RDE_EXTRACT_DIM_P18_DOMAINMEMLKUPSDE_JOB (Fabric) | LANG, W_LANGUAGES_G, DIFF_IDS, DIFF_IDS_TL | W_DOMAIN_MEMBER_DS_TL |
| Product Hierarchy | RDE_EXTRACT_DIM_P18_DOMAINMEMLKUPSDE_JOB (Item Lists) | LANG, W_LANGUAGES_G, SKULIST_HEAD, SKULIST_HEAD_TL | W_DOMAIN_MEMBER_DS_TL |
| Product Hierarchy | RDE_EXTRACT_DIM_P18_DOMAINMEMLKUPSDE_JOB (Prod Classification) | LANG, W_LANGUAGES_G, CODE_DETAIL, CODE_DETAIL_TL | W_DOMAIN_MEMBER_DS_TL |
| Product Hierarchy | RDE_EXTRACT_DIM_P18_DOMAINMEMLKUPSDE_JOB (Product) | LANG, W_LANGUAGES_G, SUBCLASS, SUBCLASS_TL, CLASS, CLASS_TL, DEPS, DEPS_TL, GROUPS, GROUPS_TL, DIVISION, DIVISION_TL | W_DOMAIN_MEMBER_DS_TL |
| Product Hierarchy | RDE_EXTRACT_DIM_P18_DOMAINMEMLKUPSDE_JOB (Scent) | LANG, W_LANGUAGES_G, DIFF_IDS, DIFF_IDS_TL | W_DOMAIN_MEMBER_DS_TL |
| Product Hierarchy | RDE_EXTRACT_DIM_P18_DOMAINMEMLKUPSDE_JOB (Style) | LANG, W_LANGUAGES_G, DIFF_IDS, DIFF_IDS_TL | W_DOMAIN_MEMBER_DS_TL |
| Product Hierarchy | RDE_EXTRACT_DIM_P18_DOMAINMEMLKUPSDE_JOB (UDAs) | LANG, W_LANGUAGES_G, UDA, UDA_TL, UDA_VALUES, UDA_VALUES_TL, UDA_ITEM_FF, UDA_ITEM_FF_TL | W_DOMAIN_MEMBER_DS_TL |
| Product Hierarchy | RDE_EXTRACT_DIM_P3_PRDATTRSDE_JOB | DIFF_TYPE, DIFF_IDS, UDA, UDA_VALUES | W_RTL_PRODUCT_ATTR_DS, W_RTL_PRODUCT_ATTR_DS_TL |
| Product Hierarchy | RDE_EXTRACT_DIM_P3_PRDBRNDSDE_JOB | BRAND, BRAND_TL | W_RTL_PRODUCT_BRAND_DS, W_RTL_PRODUCT_BRAND_DS_TL |
| Product Hierarchy | RDE_EXTRACT_DIM_P3_PRDCLRSDE_JOB | DIFF_IDS | W_RTL_PRODUCT_COLOR_DS |
| Product Hierarchy | RDE_EXTRACT_DIM_P3_PRDHIERSDE_JOB | COMPHEAD, BUYER, MERCHANT, DIVISION, GROUPS, DEPS, CLASS, SUBCLASS | W_PROD_CAT_DHS, W_RTL_PROD_HIER_ATTR_LKP_DHS |
| Product Hierarchy | RDE_EXTRACT_DIM_P3_PRDITMDELSDE_JOB | RDS_ITEM_MASTER_DELETE | W_RTL_ITEM_DEL_TMP |
| Product Hierarchy | RDE_EXTRACT_DIM_P3_PRDITMDIM_JOB | ITEM_MASTER, ITEM_MASTER_TL, UOM_CLASS, LANG, CODE_DETAIL, DEPS, GROUPS, DIVISION, V_PACKSKU_QTY, ITEM_SUPP_COUNTRY, RPM_ITEM_ZONE_PRICE, RPM_MERCH_RETAIL_DEF | W_PRODUCT_ATTR_DS, W_PRODUCT_DS, W_PRODUCT_DS_TL |
| Product Hierarchy | RDE_EXTRACT_DIM_P3_PRDITMIMGSDE_JOB | ITEM_IMAGE | W_RTL_PRODUCT_IMAGE_DS |
| Product Hierarchy | RDE_EXTRACT_DIM_P3_PRDITMSUPSDE_JOB | ITEM_MASTER, ITEM_SUPPLIER, ITEM_SUPP_COUNTRY | W_RTL_IT_SUPPLIER_DS |
| Product Hierarchy | RDE_EXTRACT_DIM_P3_PRDRCLSITMSDE_JOB | RECLASS_ITEM_TEMP, RDW_RECLASS | W_RTL_RECLASS_IT_SC_CL_TMP, W_RTL_RECLASS_DP_GP_TMP |
| Product Location Attributes | RDE_EXTRACT_DIM_P3_RTLILSDE_JOB | ITEM_LOC, ITEM_MASTER, DELETE_ITEM, RDS_ITEM_LOC_DELETE | W_RTL_IT_LC_DS |
| Promotion | RDE_EXTRACT_CE_DIM_CUSTPROMO_JOB | RI_CMP_PROMOTION_VIEW | W_RTL_PROMO_CE_DS |
| Promotion | RDE_EXTRACT_CE_DIM_CUSTPROMOITLC_JOB | CMP_PROMOTION, CMP_PROMODEAL, CMP_PROMO_STORE_LOCATION, DTV_STORE_ATTRIBUTE, DLS_DEAL, DLS_ITEM_SPECIFIER, DLS_ITEM_SET, ITM_MERCH_HIERARCHY | W_RTL_PROMO_CE_IT_LC_DS |
| Promotion | RDE_EXTRACT_DIM_P13_PROMOITLCSDE_JOB | RPM_PROMO, RPM_PROMO_OFFER, RPM_PROMO_OFFER_REWARD, RPM_PROMO_OFFER_REWARD_MERCH, RPM_PROMO_OFFER_COND, RPM_PROMO_OFFER_COND_MERCH, RPM_PROMO_OFFER_ZONE_LOC, CODE_DETAIL | W_RTL_PROMO_IT_LC_DS |
| Promotion | RDE_EXTRACT_DIM_P13_PROMOSDE_JOB | RPM_PROMO, RPM_PROMO_OFFER, RPM_PROMO_CAMPAIGN, RPM_PROMO_OFFER_REWARD | W_RTL_PROMO_DS, W_RTL_PROMO_DS_TL |
| Purchasing | RDE_EXTRACT_DIM_P10_PODETAILSSDE_JOB | ORDHEAD, ORDHEAD_REV, ORDCUST | W_RTL_PO_DETAILS_DS |
| Purchasing | RDE_EXTRACT_DIM_P17_BUYERSDE_JOB | BUYER | W_RTL_BUYER_D |
| Purchasing | RDE_EXTRACT_FACT_P3_POONORDILDSDE_JOB | ORDHEAD, ORDHEAD_REV, ORDLOC, ORDLOC_REV, ITEM_MASTER, V_ITEM_SUPP_COUNTRY_LOC, IF_TRAN_DATA, Currency Rates (MV_CURRENCY_CONVERSION_RATES, STORE, WH, PARTNER), SVAT Tax (DEPS, VAT_ITEM, SYSTEM_OPTIONS), Global Tax (GTS_ITEM_TAX, GTS_MERCH_TAX, GTS_RULES_CONFIG) | W_RTL_PO_ONORD_IT_LC_DY_FS |
| Purchasing | RDE_EXTRACT_FACT_P9_POONALCILDSDE_JOB | ALLOC_HEADER, ALLOC_DETAIL, ORDHEAD, ORDHEAD_REV, ORDLOC, ORDLOC_REV, ORDLOC_EXP, ITEM_MASTER, ITEM_LOC, V_PACKSKU_QTY, V_ITEM_SUPP_COUNTRY_LOC, SHIPMENT, Currency Rates (MV_CURRENCY_CONVERSION_RATES, STORE, WH, PARTNER) | W_RTL_PO_ONALC_IT_LC_DY_FS |
| Purchasing | RDE_POONALCILDSDE_INITIAL_JOB | ALLOC_HEADER, ALLOC_DETAIL, ORDHEAD, ORDHEAD_REV, ORDLOC, ORDLOC_REV, ORDLOC_EXP, ITEM_MASTER, ITEM_LOC, V_PACKSKU_QTY, V_ITEM_SUPP_COUNTRY_LOC, SHIPMENT, Currency Rates (MV_CURRENCY_CONVERSION_RATES, STORE, WH, PARTNER) | W_RTL_PO_ONALC_IT_LC_DY_FS |
| Purchasing | RDE_SEEDPOONORDILDSDE_JOB | ORDHEAD, ORDHEAD_REV, ORDLOC, ORDLOC_REV, ITEM_MASTER, V_ITEM_SUPP_COUNTRY_LOC, IF_TRAN_DATA, Currency Rates (MV_CURRENCY_CONVERSION_RATES, STORE, WH, PARTNER), SVAT Tax (DEPS, VAT_ITEM, SYSTEM_OPTIONS), Global Tax (GTS_ITEM_TAX, GTS_MERCH_TAX, GTS_RULES_CONFIG) | W_RTL_PO_ONORD_IT_LC_DY_FS |
| Reason Codes | RDE_EXTRACT_DIM_P8_REASONSDE_JOB | INV_ADJ_REASON, CODE_HEAD, CODE_DETAIL | W_REASON_DS |
| Related Items | RDE_EXTRACT_DIM_P1_PRDITMGRP3SDE_JOB | RELATED_ITEM_HEAD, RELATED_ITEM_DETAIL | W_RTL_ITEM_GRP3_DS |
| Related Items | RDE_EXTRACT_DIM_P18_DOMAINMEMLKUPSDE_JOB (Related Item Groups) | LANG, W_LANGUAGES_G, RELATED_ITEM_HEAD, RELATED_ITEM_HEAD_TL | W_DOMAIN_MEMBER_DS_TL |
| Replenishment | RDE_EXTRACT_DIM_P16_INVOPTIONSSDE_JOB | INV_MOVE_UNIT_OPTIONS | W_INVENTORY_OPTIONS_GS |
| Replenishment | RDE_EXTRACT_DIM_P3_PRDITMATTRSDE_JOB | REPL_ITEM_LOC, REPL_RESULTS, ITEM_LOC_TRAITS, ITEM_LOC_CFA_EXT, ITEM_MASTER, V_PACKSKU_QTY | W_INVENTORY_PRODUCT_ATTR_DS |
| Replenishment | RDE_EXTRACT_DIM_P5_REPLDAYSDE_JOB | REPL_DAY, REPL_ITEM_LOC | W_RTL_REPL_DAY_DS |
| Replenishment | RDE_EXTRACT_DIM_P5_REPLDLVRYSCHEDEXCSDE_JOB | SOURCE_DLVRY_SCHED_EXC | W_RTL_REPL_DLVRY_SCH_EXC_DS |
| Replenishment | RDE_EXTRACT_DIM_P5_REPLDLVRYSCHEDSDE_JOB | SOURCE_DLVRY_SCHED, SOURCE_DLVRY_SCHED_DAYS | W_RTL_REPL_DLVRY_SCHED_DS |
| Replenishment | RDE_EXTRACT_DIM_P5_REPLSUPDIMSDE_JOB | ITEM_SUPP_COUNTRY_DIM | W_RTL_REPL_SUP_DIM_DS |
| Replenishment | RDE_EXTRACT_DIM_P5_REPLSUPMGMTSDE_JOB | SUP_INV_MGMT | W_RTL_REPL_SUP_MGMT_DS |
| Replenishment | RDE_EXTRACT_DIM_P5_REPLWFORDSDE_JOB | WF_ORDER_HEAD | W_RTL_REPL_WF_ORD_DS |
| Replenishment | RDE_EXTRACT_FACT_P11_REPLWFORDILDSDE_JOB | WF_ORDER_HEAD, WF_ORDER_DETAIL, ITEM_MASTER, Currency Rates (MV_CURRENCY_CONVERSION_RATES, STORE, WH, PARTNER) | W_RTL_REPL_WF_ORD_IT_LC_DY_FS |
| Replenishment | RDE_EXTRACT_FACT_P11_REPLSTOREORDILSDE_JOB | STORE_ORDERS, DELIVERY_SLOT, ITEM_MASTER, Currency Rates (MV_CURRENCY_CONVERSION_RATES, STORE, WH, PARTNER) | W_RTL_REPL_ORD_IT_LC_DY_FS |
| Replenishment | RDE_EXTRACT_FACT_P11_REPLDEMANDILSDE_JOB | REPL_ADDITIONAL_DEMAND | W_RTL_REPL_DMD_IT_LC_DY_FS |
| Replenishment | RDE_REPLDAYSDE_INITIAL_JOB | REPL_DAY, REPL_ITEM_LOC | W_RTL_REPL_DAY_DS |
| Replenishment | RDE_REPLSUPDIMSDE_INITIAL_JOB | ITEM_SUPP_COUNTRY_DIM | W_RTL_REPL_SUP_DIM_DS |
| Replenishment | RDE_REPLWFORDILDSDE_INITIAL_JOB | WF_ORDER_HEAD, WF_ORDER_DETAIL, ITEM_MASTER, Currency Rates (MV_CURRENCY_CONVERSION_RATES, STORE, WH, PARTNER) | W_RTL_REPL_WF_ORD_IT_LC_DY_FS |
| Sales Transaction | RDE_EXTRACT_DIM_P18_DOMAINMEMLKUPSDE_JOB (Return Reason) | LANG, W_LANGUAGES_G, CODE_DETAIL, CODE_DETAIL_TL | W_DOMAIN_MEMBER_DS_TL |
| Sales Transaction | RDE_EXTRACT_DIM_P18_DOMAINMEMLKUPSDE_JOB (Tender) | LANG, W_LANGUAGES_G, POS_TENDER_TYPE_HEAD, POS_TENDER_TYPE_HEAD_TL, CODE_DETAIL, CODE_DETAIL_TL | W_DOMAIN_MEMBER_DS_TL |
| Sales Transaction | RDE_EXTRACT_RESA_SALE_FACT_GCNLDSDE_JOB | XTERN_RDWT, STORE | W_RTL_GCN_TRX_LC_DY_FS |
| Sales Transaction | RDE_EXTRACT_RESA_SALE_FACT_SLSDISCTRXLDSDE_JOB | XTERN_RDWT, ITEM_MASTER, CLASS, VAT_ITEM, GTAX_ITEM_ROLLUP, STORE | W_RTL_SLSDSC_TRX_IT_LC_DY_FS |
| Sales Transaction | RDE_EXTRACT_RESA_SALE_FACT_SLSILTSDE_JOB | XTERN_RDWT, ITEM_MASTER, ITEM_LOC, ITEM_SUPPLIER, ITEM_SUPP_COUNTRY, ITEM_LOC_SOH_EOD, V_PACKSKU_QTY, DEPS, CLASS, VAT_ITEM, V_ITEM_SUPP_COUNTRY_LOC, GTAX_ITEM_ROLLUP, STORE, SYSTEM_OPTIONS | W_RTL_SLS_TRX_IT_LC_DY_FS, W_RTL_SLSPK_IT_LC_DY_FS, W_RTL_SLSCC_TRX_IT_LC_DY_FS |
| Sales Transaction | RDE_EXTRACT_RESA_SALE_FACT_TNDRTRXLDSDE_JOB | XTERN_RDWF, STORE | W_RTL_TRX_TNDR_LC_DY_FS |
| Sales Transaction | RDE_EXTRACT_RESA_SALE_XTERN_RDWF_JOB | SA_EXPDW_RDWT_HEAD, SA_EXPDW_RDWF_DETAIL | XTERN_RDWF |
| Sales Transaction | RDE_EXTRACT_RESA_SALE_XTERN_RDWT_JOB | SA_EXPDW_RDWT_HEAD, SA_EXPDW_RDWT_DETAIL | XTERN_RDWT |
| Sales Transaction | RDE_EXTRACT_DIM_P8_COUPONSDE_JOB | POS_COUPON_HEAD, POS_COUPON_HEAD_TL | W_RTL_COUPON_DS, W_RTL_COUPON_DS_TL |
| Sales Transaction | RDE_EXTRACT_DIM_P8_TNDRTPSDE_JOB | POS_TENDER_TYPE_HEAD, CODE_DETAIL | W_RTL_TNDR_TYPE_DS |
| Sales Wholesale and Franchise | RDE_EXTRACT_FACT_P8_WFSLSILDSDE_JOB | IF_TRAN_DATA, ITEM_MASTER, TSFHEAD, Currency Codes (STORE, WH, PARTNER) | W_RTL_SLSWF_IT_LC_DY_FS |
| Seasons/Phases | RDE_EXTRACT_DIM_P18_DOMAINMEMLKUPSDE_JOB (Seasons) | LANG, W_LANGUAGES_G, SEASONS, SEASONS_TL, PHASES, PHASES_TL | W_DOMAIN_MEMBER_DS_TL |
| Seasons/Phases | RDE_EXTRACT_DIM_P3_PRDITMSEASNDE_JOB | SEASONS, PHASES, ITEM_SEASONS, ITEM_MASTER, V_PACKSKU_QTY | W_RTL_SEASON_PHASE_IT_DS |
| Seasons/Phases | RDE_EXTRACT_DIM_P8_PHASESDE_JOB | PHASES | W_RTL_PHASE_DS |
| Seasons/Phases | RDE_EXTRACT_DIM_P8_SEASNSDE_JOB | SEASONS | W_RTL_SEASON_DS |
| Shipments | RDE_EXTRACT_DIM_P10_SHIPDETAILSDE_JOB | SHIPMENT | W_RTL_SHIP_DETAILS_DS |
| Shipments | RDE_EXTRACT_FACT_P3_SHIPILDSDE_JOB | SHIPMENT, SHIPSKU, SHIPMENT_PRG_HIST, SHIPSKU_PRG_HIST, V_PACKSKU_QTY, ITEM_MASTER, ORDHEAD, Currency Rates (MV_CURRENCY_CONVERSION_RATES, STORE, WH, PARTNER) | W_RTL_SHIP_IT_LC_DY_FS |
| Shipments | RDE_SHIPDETAILSDE_INITIAL_JOB | SHIPMENT, SHIPMENT_PRG_HIST | W_RTL_SHIP_DETAILS_DS |
| Shipments | RDE_SHIPILDSDE_INITIAL_JOB | SHIPMENT, SHIPSKU, SHIPMENT_PRG_HIST, SHIPSKU_PRG_HIST, V_PACKSKU_QTY, ITEM_MASTER, ORDHEAD, Currency Rates (MV_CURRENCY_CONVERSION_RATES, STORE, WH, PARTNER) | W_RTL_SHIP_IT_LC_DY_FS |
| Stock Counts | RDE_EXTRACT_DIM_P21_STKCNTSDE_JOB | STAKE_HEAD, STAKE_LOCATION, STAKE_SKU_LOC | W_RTL_LOC_STOCK_CNT_DS |
| Stock Counts | RDE_EXTRACT_FACT_P10_STKCNTILSDE_JOB | STAKE_SKU_LOC, Currency Codes (STORE, WH, PARTNER) | W_RTL_INVSS_CNT_IT_LC_DY_FS |
| Stock Ledger | RDE_EXTRACT_DIM_P6_ORGFINSDE_JOB | FIF_GL_SETUP, ORG_UNIT, TSF_ENTITY_ORG_UNIT_SOB | W_RTL_ORG_FIN_DS |
| Stock Ledger | RDE_EXTRACT_FACT_P6_STLBLMTHSDE_JOB | MONTH_DATA, SUBCLASS, STORE, WH | W_RTL_STCKLDGR_SC_LC_MH_FS |
| Stock Ledger | RDE_EXTRACT_FACT_P6_STLBLWSDE_JOB | WEEK_DATA, SUBCLASS, STORE, WH | W_RTL_STCKLDGR_SC_LC_WK_FS |
| Substitute Items | RDE_EXTRACT_DIM_P3_SUBITMLSDE_JOB | SUB_ITEMS_HEAD, SUB_ITEMS_DETAIL | W_RTL_SUB_IT_LC_DS |
| Supplier | RDE_EXTRACT_DIM_P18_DOMAINMEMLKUPSDE_JOB (Supplier Traits) | LANG, W_LANGUAGES_G, SUP_TRAITS, SUP_TRAITS_TL | W_DOMAIN_MEMBER_DS_TL |
| Supplier | RDE_EXTRACT_FACT_P5_SCMPLILDSDE_JOB | IF_TRAN_DATA, ORDHEAD, ORDLOC, DLVRY_SCHED_DAYS, SOURCE_DLVRY_SCHED, ITEM_MASTER, STORE, WH, ORDLOC, SHIPMENT, V_PACKSKU_QTY | W_RTL_SUPPCM_IT_LC_DY_FS |
| Supplier | RDE_EXTRACT_FACT_P5_SCMPLUFILDSDE_JOB | IF_TRAN_DATA, ORDHEAD, ORDLOC, STORE, WH, SHIPMENT | W_RTL_SUPPCMUF_LC_DY_FS |
| Supplier | RDE_EXTRACT_FACT_P5_SINVCSTILSDSDE_JOB | IM_DOC_HEAD, IM_INVOICE_DETAIL, ORDHEAD, ORDLOC, ITEM_MASTER, V_PACKSKU_QTY, Currency Rates (MV_CURRENCY_CONVERSION_RATES, STORE, WH, PARTNER) | W_RTL_SUPP_IVC_PO_IT_FS |
| Supplier | RDE_EXTRACT_DIM_P9_SUPSDE_JOB | SUPS | W_PARTY_ORG_DS, W_PARTY_ATTR_DS |
| Supplier | RDE_EXTRACT_DIM_P9_SUPTRSDE_JOB | SUP_TRAITS_MATRIX | W_RTL_SUPPLIER_TRAIT_DS |
| Transaction Codes | RDE_EXTRACT_DIM_P8_CODESDE_JOB | TRAN_DATA_CODES | W_CODE_DS |
| Upcharges | RDE_EXTRACT_DIM_P11_ALCCHRGSDE_JOB | ALLOC_CHRG | W_RTL_ALLOC_CHRG_DETAILS_DS |
| Upcharges | RDE_EXTRACT_DIM_P11_DEPTCHRGDETAILSDE_JOB | DEPT_CHRG_HEAD, DEPT_CHRG_DETAIL | W_RTL_DEPT_CHRG_DETAILS_DS |
| Upcharges | RDE_EXTRACT_DIM_P11_ELCCOMPDSDE_JOB | ELC_COMP | W_RTL_ELC_COMP_DS |
| Upcharges | RDE_EXTRACT_DIM_P11_ITEMCHRGDETAILSDE_JOB | ITEM_CHRG_HEAD, ITEM_CHRG_DETAIL | W_RTL_ITEM_CHRG_DETAILS_DS |
| Upcharges | RDE_EXTRACT_DIM_P11_TSFCHRGSDE_JOB | TSFDETAIL_CHRG | W_RTL_TSF_CHRG_DETAILS_DS |