4 Logical to Physical Mappings in the Oracle Retail Data Model

ACCOUNT TYPE

DWL_ACCT_TYP (View)

ACTIVITY REQUEST TYPE

DWL_ACTVTY_RQST_TYP (View)

ADDRESS LOCATION

DWR_ADDR_LOC

ADDRESS LOCATION HISTORY

DWR_ADDR_LOC_HIST

ADDRESS RELATED

DWR_ADDR_RLTD

ADDRESS TELEPHONE

DWR_ADDR_PHONE

ADDRESS TYPE

DWL_ADDR_TYP (View)

ADVERTISING PERIOD

DWR_ADVR_PERIOD

ADVERTISING QUARTER

DWR_ADVR_QTR

ADVERTISING WEEK

DWR_ADVR_WK

ADVERTISING YEAR

DWR_ADVR_YR

AGE RESTRICTION RULE

Subentity of SALES RESTRICTION (Reference Entity)

AGGREGATE SKU

Subentity of SKU ITEM (Reference Entity)

ALTERNATIVE ITEM

DWR_ALTVE_ITEM

ANALYSIS DURATION

DWL_ANALYSIS_DURATION

APPOINTMENT CALENDAR

DWR_APPT_CALNDR

APPOINTMENT TYPE

DWL_APPT_TYP (View)

AUTHORIZATION METHOD

DWL_ATHRZTN_MTHD (View)

BRAND

DWR_BRND

BUSINESS ENTITY SELLING RULE

DWR_BSNS_ENT_SLNG_RULE

BUSINESS ENTITY TENDER RESTRICTION RULE

DWR_BSNS_ENT_TNDR_RSTRCT_RULE

BUSINESS HALF MONTH

DWR_BSNS_HLF_MO

BUSINESS HALF YEAR

DWR_BSNS_HLF_YR

BUSINESS MONTH

DWR_BSNS_MO

BUSINESS QUARTER

DWR_BSNS_QTR

BUSINESS UNIT CALENDAR

DWR_BSNS_UNIT_CLNDR

BUSINESS UNIT JOB ROLE

DWR_BSNS_UNIT_JB_RL

BUSINESS UNIT SHIFT

DWR_BSNS_UNIT_SHFT

BUSINESS UNIT TYPE

DWL_BSNS_UNIT_TYP (View)

BUSINESS UNIT USAGE TYPE

DWL_BSNS_UNIT_USG_TYP (View)

BUSINESS WEEK

DWR_BSNS_WK

BUSINESS YEAR

DWR_BSNS_YR

CALENDAR HALF MONTH

DWR_CLNDR_HLF_MO

CALENDAR HALF YEAR

DWR_CLNDR_HLF_YR

CALENDAR MONTH

DWR_CLNDR_MO

CALENDAR QUARTER

DWR_CLNDR_QTR

CALENDAR WEEK

DWR_CLNDR_WK

CALENDAR YEAR

DWR_CLNDR_YR

CALL CENTER

Subentity of TOUCHPOINT (Reference Entity)

CAMPAIGN

DWR_CMPGN

CAMPAIGN COST

Subentity of CAMPAIGN CUSTOMER ASSIGNMENT (Reference Entity)

CAMPAIGN CUSTOMER ASSIGNMENT

DWR_CMPGN_CUST_ASGNMNT

CAMPAIGN EXECUTION MESSAGE

DWR_CMPGN_EXECUTION_MSG

CAMPAIGN MEDIA

DWR_CMPGN_MEDIA

CAMPAIGN MEDIA LAUNCH

DWR_CMPGN_MEDIA_LAUNCH

CAMPAIGN MEDIA SELLING ITEM

DWR_CMPGN_MEDIA_SLNG_ITEM

CAMPAIGN MESSAGE DEPICTION

DWR_CMPGN_MSG_DPCT

CAMPAIGN MESSAGE RENDERING

DWR_CMPGN_MSG_RNDRNG

CAMPAIGN TARGET

Subentity of CAMPAIGN CUSTOMER ASSIGNMENT (Reference Entity)

CARD TYPE

DWL_CARD_TYP (View)

CARRIER

DWR_CARRIER

CARRIER COMPLIANCE WEEK AGGR

DWA_CARRIER_CMPLNC_WK

CATALOG REQUEST BY DAY DERIVED

DWD_CTLG_RQST_BY_DAY

CATALOG REQUEST TYPE

DWL_CTLG_RQST_TYP (View)

CATALOG TYPE

DWL_CTLG_TYP (View)

CERTIFICATE

DWR_CERTIFICATE

CERTIFICATE ACTIVITY DAY AGGR

DWA_CERTIFICATE_ACTVTY_DAY

CERTIFICATE ACTIVITY TRANSACTION DERIVED

DWD_CERTIFICATE_ACTVTY_TRX

CERTIFICATE ACTIVITY WEEK AGGR

DWA_CERTIFICATE_ACTVTY_WK

CERTIFICATE AGE BAND

DWL_CERTIFICATE_AGE_BND

CERTIFICATE ESCHEATED DAY

DWB_CERTIFICATE_ESCHTD_DAY

CERTIFICATE LINE ITEM

DWB_CERTIFICATE_LI

CERTIFICATE TENDER

DWB_CERTIFICATE_TNDR

CERTIFICATE TYPE

DWL_CERTIFICATE_TYP (View)

CHANNEL TYPE

DWL_CHNL_TYP (View)

CHECK IN TYPE

DWL_CHECK_IN_TYP (View)

CHECK TENDER

DWB_CHECK_TNDR

COATING

DWL_COATING (View)

CODE MASTER

DWL_CODE_MASTER

COLOR

DWL_COLOR (View)

COMMUNICATION TYPE

DWL_COMUNICTN_TYP

COMPANY

DWR_CMPNY

COMPETITOR

DWR_CMPTR

COMPETITOR LOCATION

DWR_CMPTR_LOC

COMPETITOR LOCATION ASSIGNMENT

DWR_CMPTR_LOC_ASGNMNT

COMPETITOR RETAIL ITEM

DWR_CMPTR_RTL_ITEM

COST

Subentity of CAMPAIGN MESSAGE RENDERING (Reference Entity)

COST PER UNIT TYPE

DWL_COST_PER_UNIT_TYP (View)

COUPON SCAN

DWL_CPN_SCAN (View)

CREATIVES

DWR_CREA

CREDIT-DEBIT CARD TENDER

DWB_CR_DEBIT_CARD_TNDR

CURRENCY

DWL_CRNCY

CUST EMPLOYEE RELATIONSHIP MONTH AGGR

DWA_CUST_EMP_RLTNSHP_MO

CUSTOMER

DWR_CUST

CUSTOMER ACCOUNT

DWR_CUST_ACCT

CUSTOMER ACCOUNT TENDER

DWB_CUST_ACCT_TNDR

CUSTOMER ADDRESS

DWR_CUST_ADDR

CUSTOMER AFFILIATION

DWR_CUST_AFFLTN

CUSTOMER CLUSTER

DWR_CUST_CLSTR

CUSTOMER CLUSTER ITEM ASSIGNMENT

DWR_CUST_CLSTR_ITEM_ASGNMNT

CUSTOMER EMPLOYEE RELATIONSHIP DAY

DWD_CUST_EMP_RLTNSHP_DAY

CUSTOMER EMPLOYEE SALE RETURN MONTH AGGR

DWA_CUST_EMP_SL_RETRN_MO

CUSTOMER EMPLOYEE SALE RETURN WEEK AGGR

DWA_CUST_EMP_SL_RETRN_WK

CUSTOMER GROUP

DWR_CUST_GRP

CUSTOMER GROUP ITEM

DWR_CUST_GRP_ITEM

CUSTOMER OCCASION

DWR_CUST_OCCSN

CUSTOMER OCCASION TYPE

DWL_CUST_OCCSN_TYP (View)

CUSTOMER ORDER

DWB_CUST_ORDR

CUSTOMER ORDER DEPARTMENT DAY AGGR

DWA_CUST_ORDR_DEPT_DAY

CUSTOMER ORDER DEPARTMENT MONTH AGGR

DWA_CUST_ORDR_DEPT_MO

CUSTOMER ORDER HOLD EVENT

DWL_CUST_ORDR_HOLD_EVNT (View)

CUSTOMER ORDER ITEM DAY DERIVED

DWD_CUST_ORDR_ITEM_DAY

CUSTOMER ORDER ITEM MONTH AGGR

DWA_CUST_ORDR_ITEM_MO

CUSTOMER ORDER ITEM WEEK AGGR

DWA_CUST_ORDR_ITEM_WK

CUSTOMER ORDER LINE ITEM

DWB_CUST_ORDR_LI

CUSTOMER ORDER LINE ITEM STATE ASSIGN

DWB_CUST_ORDR_LI_STATE_ASSIGN

CUSTOMER ORDER LINE ITEM STATE DERIVED

DWD_CUST_ORDR_LI_STATE

CUSTOMER ORDER STATE

DWB_CUST_ORDR_STATE

CUSTOMER ORDER SUBCLASS DAY AGGR

DWA_CUST_ORDR_SBC_DAY

CUSTOMER ORDER SUBCLASS MONTH AGGR

DWA_CUST_ORDR_SBC_MO

CUSTOMER ORDER SUBCLASS WEEK AGGR

DWA_CUST_ORDR_SBC_WK

CUSTOMER PICKUP TYPE

DWL_CUST_PCKUP_TYP (View)

CUSTOMER PREFERENCE

DWR_CUST_PREF

CUSTOMER QUICK FACTS

Subentity of CUSTOMER (Reference Entity)

CUSTOMER RELATIONSHIP

DWR_CUST_RLTNSHP

CUSTOMER RESTRICTED INFO

DWR_CUST_RSTRCTD_INFO

CUSTOMER RFMP SCORE

DWD_CUST_RFMP_SCR

CUSTOMER SERVICE REQUEST

DWB_CUST_SRVC_RQST

CUSTOMER SKU SALE RETURN DAY DERIVED

DWD_CUST_SKU_SL_RETRN_DAY

CUSTOMER STATUS

DWR_CUST_STATUS

DAY

DWR_DAY

DAY ACTUAL CONDITION

DWB_DAY_ACT_CONDITION

DAY TODATE TRANSFORMATION

DWB_DAY_TODATE_TRANS

DAY TRANSFORMATION

DWR_DAY_TRANS

DEAL

DWB_DEAL

DEAL VENDOR ITEM ASSIGNMENT

DWB_DEAL_VNDR_ITEM_ASGNMNT

DEMOGRAPHY ATTRIBUTE

DWR_DEMOG_ATTR

DEMOGRAPHY GROUP

DWR_DEMOG_GRP

DENOMINATION

DWL_DENMTN

DEPOSIT RULE

DWR_DPST_RULE

DERIVED VALUE

DWR_DRVD_VAL

DISCOUNT LINE ITEM

DWB_DISC_LI

DISCOUNT TYPE

DWL_DISC_TYP

DISCREPANCY TOLERANCE RULE

DWR_DSCRPNCY_TOLRNC_RULE

DISPLAY UNIT ITEM

Subentity of ITEM (Reference Entity)

DISPOSITION TYPE

DWL_DSPSTN_TYP (View)

DYE

DWL_DYE (View)

EMAIL ADDRESS

DWR_EMAIL_ADDR

EMPLOYEE

DWR_EMP

EMPLOYEE ACTUAL LABOR HOURLY

DWR_EMP_ACT_LBR_HRLY

EMPLOYEE ACTUAL LABOR SALARIED

DWR_EMP_ACT_LBR_SAL

EMPLOYEE ADDRESS

DWR_EMP_ADDR

EMPLOYEE DESIGNATION

DWR_EMP_DESIG

EMPLOYEE DISCOUNT GROUP

DWR_EMP_DISC_GRP

EMPLOYEE DISCOUNT GROUP ASSIGNMENT

DWR_EMP_DISC_GRP_ASGNMNT

EMPLOYEE JOB ROLE ASSIGNMENT

DWR_EMP_JOB_ROLE_ASGNMNT

EMPLOYEE LABOR

DWB_EMP_LBR

EMPLOYEE RESTRICTED INFORMATION

DWR_EMP_RSTRCTD_INFO

EMPLOYEE SCHEDULE

DWR_EMP_SCHL

EMPLOYEE TRAINING RECORD

DWR_EMP_TRNG_REC

EMPLOYEE TYPE

DWL_EMP_TYP (View)

ENTRY METHOD

DWL_ENTRY_MTHD (View)

ENVIRONMENT TYPE

DWL_ENV_TYP (View)

EVENT

DWR_EVNT

EXCHANGE RATE CURRENCY DAY

DWB_EXCHNG_RATE_CRNCY_DAY

EXTERNAL DEPOSITORY

DWR_EXTRNL_DPSTRY

FABRIC

DWL_FABRIC (View)

FACTOR COMPANY

DWR_FCTR_CMPNY

FIBER

DWL_FIBRE (View)

FISCAL HALF MONTH

DWR_FSCL_HLF_MO

FISCAL HALF YEAR

DWR_FSCL_HLF_YR

FISCAL MONTH

DWR_FSCL_MO

FISCAL QUARTER

DWR_FSCL_QTR

FISCAL WEEK

DWR_FSCL_WK

FISCAL YEAR

DWR_FSCL_YR

GEOGRAPHY DEMOGRAPHIC GROUP

DWR_GEOG_DEMOG_GRP

GEOGRAPHY DEMOGRAPHY ATTRIBUTE

DWR_GEOG_DEMOG_ATTR

GEOGRAPHY DEMOGRAPHY VALUE

DWR_GEOG_DEMOG_VAL

GEOGRAPHY ENTITY

DWR_GEOG_ENT

GEOGRAPHY HIERARCHY

DWR_GEOG_HRCHY

GEOGRAPHY HIERARCHY LEVEL

DWR_GEOG_HRCHY_LVL

GEOGRAPHY HIERARCHY LEVEL ASSIGNMENT

DWR_GEOG_HRCHY_LVL_ASGNMNT

GEOGRAPHY HIERARCHY VERSION

DWR_GEOG_HRCHY_VRSN

GEOGRAPHY LEVEL

DWR_GEOG_LVL

GEOGRAPHY LEVEL ATTRIBUTE VALUE

DWR_GEOG_LVL_ATTR_VAL

GEOGRAPHY LEVEL ATTRIBUTES

DWR_GEOG_LVL_ATTR

GROUP SELECT

Subentity of SKU ITEM (Reference Entity)

GROUP SELECT ITEM

Subentity of ITEM (Reference Entity)

HALF HOUR

DWR_HLF_HR

HALF MONTH TODATE TRANSFORMATION

DWR_HLF_MO_TODATE_TRANS

HALF MONTH TRANSFORMATION

DWR_HLF_MO_TRANS

HALF YEAR TODATE TRANSFORMATION

DWR_HLF_YR_TODATE_TRANS

HALF YEAR TRANSFORMATION

DWR_HLF_YR_TRANS

HAZARDOUS MATERIAL TYPE

DWL_HZRDS_MTRL_TYP (View)

HOUR

DWR_HR

HOUSEHOLD

DWR_HH

INDIVIDUAL DEMOGRAPHY VALUE

DWR_INDVL_DEMOG_VAL

INVENTORY ACCOUNTING METHOD

DWL_INV_ACCT_MTHD (View)

INVENTORY ADJUSTMENT BY ITEM DAY DERIVED

DWD_INV_ADJ_BY_ITEM_DAY

INVENTORY BUDGET BY WEEK AGGR

DWA_INV_BDGT_BY_WK

INVENTORY CONDITION

DWL_INV_CNDTN (View)

INVENTORY CONTROL DOCUMENT

Main Entity of Base

INVENTORY CONTROL DOCUMENT LINE ITEM

DWB_INV_CNTRL_DOC_LI

INVENTORY DOCUMENT TYPE

DWI_INV_DOC_TYP (View)

INVENTORY ITEM STATE

DWB_INV_ITEM_STATE

INVENTORY ITEM STATE HISTORY WEEK

DWA_INV_ITEM_STATE_HIST_WK

INVENTORY LOCATION

DWR_INV_LOC

INVENTORY LOCATION TYPE

DWI_INV_LOC_TYP (View)

INVENTORY POSITION BY DEPT WEEK AGGR

DWA_INV_POSN_BY_DEPT_WK

INVENTORY POSITION BY ITEM DAY DERIVED

DWD_INV_POSN_BY_ITEM_DAY

INVENTORY POSITION BY ITEM WEEK AGGR

DWA_INV_POSN_BY_ITEM_WK

INVENTORY POSITION BY SUBCLASS DAY AGGR

DWA_INV_POSN_BY_SBC_DAY

INVENTORY POSITION BY SUBCLASS WEEK AGGR

DWA_INV_POSN_BY_SBC_WK

INVENTORY POSITON BY DEPT DAY AGGR

DWA_INV_POSN_BY_DEPT_DAY

INVENTORY RECEIPT BY ITEM DAY AGGR

DWA_INV_RCPT_BY_ITEM_DAY

INVENTORY RECEIPT BY ITEM WEEK AGGR

DWA_INV_RCPT_BY_ITEM_WK

INVENTORY RECEIPT BY SUBCLASS DAY AGGR

DWA_INV_RCPT_BY_SBC_DAY

INVENTORY RECEIPT BY SUBCLASS WEEK AGGR

DWA_INV_RCPT_BY_SBC_WK

INVENTORY STATE

DWL_INV_STATE

INVENTORY STATUS

DWL_INV_STATUS

INVENTORY TRANSFER BY ITEM DAY AGGR

DWA_INV_TRNSFR_BY_ITEM_DAY

INVENTORY TRANSFER BY ITEM WEEK AGGR

DWA_INV_TRNSFR_BY_ITEM_WK

INVENTORY TRANSFER BY SUBCLASS DAY AGGR

DWA_INV_TRNSFR_BY_SBC_DAY

INVENTORY TRANSFER BY SUBCLASS WEEK AGGR

DWA_INV_TRNSFR_BY_SBC_WK

INVENTORY TYPE

DWL_INV_TYP (View)

INVENTORY UNAVAILABLE BY ITEM DAY

DWD_INV_UNAVL_BY_ITEM_DAY

INVENTORY VENDOR COMPLIANCE AGGR

DWA_INV_VNDR_CMPLNC

ISSUE TYPE

DWL_ISSUE_TYP (View)

ITEM

DWR_ITEM

ITEM CATEGORY

DWR_ITEM_CTGRY

ITEM CLASS

DWR_ITEM_CLASS

ITEM CLUSTER

DWR_ITEM_CLSTR

ITEM CLUSTER CUSTOMER ASSIGNMENT

DWR_ITEM_CLSTR_CUST_ASGNMNT

ITEM DEPARTMENT

DWR_ITEM_DEPT

ITEM DIVISION

DWR_ITEM_DIV

ITEM GROUP

DWR_ITEM_GRP

ITEM HIERARCHY

DWR_ITEM_HRCHY

ITEM HIERARCHY LEVEL

DWR_ITEM_HRCHY_LVL

ITEM HIERARCHY LEVEL ASSIGNMENT

DWR_ITEM_HRCHY_LVL_ASGNMNT

ITEM HIERARCHY VERSION

DWR_ITEM_HRCHY_VRSN

ITEM LEVEL

DWR_ITEM_LVL

ITEM LEVEL ATTRIBUTE

DWR_ITEM_LVL_ATTR

ITEM LEVEL ATTRIBUTE VALUE

DWR_ITEM_LVL_ATTR_VAL

ITEM MARKET DATA

DWR_ITEM_MKT_DATA

ITEM SALES PROHIBITION PERIOD RULE

Subentity of SALES RESTRICTION (Reference Entity)

ITEM SEASON

DWR_ITEM_SEASON

ITEM SELLING RULE

DWR_ITEM_SLNG_RULE

ITEM SHELF LABEL

DWR_ITEM_SHELF_LABEL

ITEM SPIFF RULE

DWR_ITEM_SPIFF_RULE

ITEM STATE

DWL_ITEM_STATE (View)

ITEM SUBCLASS

DWR_ITEM_SBC

ITEM SUBDEPARTMENT

DWR_ITEM_SBDEPT

ITEM TENDER RESTRICTION GROUP

DWR_ITEM_TNDR_RSTRCT_GRP

ITEM TENDER RESTRICTION RULE

DWR_ITEM_TNDR_RSTRCT_RULE

JOB ROLES

DWR_JB_RL

LANGUAGE

DWL_LANG (View)

LICENSE SALES RESTRICTION

Subentity of SALES RESTRICTION (Reference Entity)

LOCAL AUTHORITY TYPE

DWL_LCL_AUTH_TYP (View)

LOCAL TAX AUTHORITY

DWR_LCL_TAX_AUTH

LOCATION TYPE

DWL_LOC_TYP (View)

LOYALTY AWARD

DWR_LYLTY_AWARD

MANUFACTURAR COUPON TENDER

DWB_MNFCTR_CPN_TNDR

MANUFACTURER

DWR_MNFCTR

MANUFACTURER COUPON FAMILY

DWL_MNFCTR_CPN_FMLY

MARKET AREA

DWR_MKT_AREA

MARKET AREA LEVEL

DWR_MKT_AREA_LVL

MARKET ITEM DEPARTMENT

DWR_MKT_ITEM_DEPT

MARKET ITEM DEPARTMENT ASSIGNMENT

DWR_MKT_ITEM_DEPT_ASGNMNT

MARKET SALES DEPARTMENT WEEK AGGR

DWA_MKT_SLS_DEPT_WK

MARKET SALES ITEM WEEK

DWB_MKT_SLS_ITEM_WK

MEDIA

DWR_MEDIA

MEDIA DEPICTION ITEM ASSIGNMENT

DWR_MEDIA_DPCT_ITEM_ASGNMNT

MEDIA TYPE

DWL_MEDIA_TYP

MEMBERSHIP ACCOUNT

DWR_MBRSHIP_ACCT

MEMBERSHIP TYPE

DWL_MBRSHIP_TYP (View)

MINUTE

DWR_MNT

MISCELLANEOUS LINE ITEM TYPE

DWI_MISC_LI_TYP (View)

MONTH TODATE TRANSFORMATION

DWR_MO_TODATE_TRANS

MONTH TRANSFORMATION

DWR_MO_TRANS

MULTIPLE TENDER CLASS

DWL_MLTPL_TNDR_CLASS (View)

ORDER CATEGORY TYPE

DWL_ORDR_CTGRY_TYP(View)

ORDER DOCUMENT

DWB_ORDR_DOC

ORDER EVENT TYPE

DWL_ORDR_EVNT_TYP (View)

ORDER LINE ITEM STATE

DWL_ORDR_LINE_ITEM_STATE (View)

ORDER SOURCE TYPE

DWL_ORDR_SRC_TYP (View)

ORDER STATE

DWL_ORDR_STATE (View)

ORDER STATUS

DWL_ORDR_STATUS

ORDER STATUS TYPE

DWL_ORDR_STATUS_TYP

ORDER TYPE

DWL_ORDR_TYP (View)

ORGANIZATION AREA

DWR_ORG_AREA

ORGANIZATION BANNER

DWR_ORG_BNR

ORGANIZATION BUSINESS ENTITY

DWR_ORG_BSNS_ENT

ORGANIZATION BUSINESS UNIT

DWR_ORG_BSNS_UNIT

ORGANIZATION CATALOGUE

Subentity of ORGANIZATION BUSINESS UNIT (Reference Entity)

ORGANIZATION CHAIN

DWR_ORG_CHAIN

ORGANIZATION DEMOGRAPHY VALUE

DWR_ORG_DEMOG_VAL

ORGANIZATION DEPARTMENT

DWR_ORG_DEPT

ORGANIZATION DISTRIBUTION CENTER

Subentity of ORGANIZATION BUSINESS UNIT (Reference Entity)

ORGANIZATION DISTRICT

DWR_ORG_DSTRCT

ORGANIZATION DIVISION

DWR_ORG_DIV

ORGANIZATION HIERARCHY

DWR_ORG_HRCHY

ORGANIZATION HIERARCHY LEVEL

DWR_ORG_HRCHY_LVL

ORGANIZATION HIERARCHY LEVEL ASSIGNMENT

DWR_ORG_HRCHY_LVL_ASGNMNT

ORGANIZATION HIERARCHY VERSION

DWR_ORG_HRCHY_VRSN

ORGANIZATION LEVEL

DWR_ORG_LVL

ORGANIZATION LEVEL ATTRIBUTE VALUE

DWR_ORG_LVL_ATTR_VAL

ORGANIZATION LEVEL ATTRIBUTES

DWR_ORG_LVL_ATTR

ORGANIZATION MARKET DATA

DWR_ORG_MKT_DATA

ORGANIZATION REGION

DWR_ORG_RGN

ORGANIZATION STORE

Subentity of ORGANIZATION BUSINESS UNIT (Reference Entity)

ORGANIZATION WAREHOUSE

Subentity of ORGANIZATION BUSINESS UNIT (Reference Entity)

ORGANIZATION WEB STORE

Subentity of ORGANIZATION BUSINESS UNIT (Reference Entity)

PACKING SLIP

DWB_PACKING_SLIP

PAY CATEGORY

DWL_PAY_CTGRY (View)

PAY DETAIL

DWR_PAY_DTL

PAY TYPE

DWL_PAY_TYP

PAYMENT ON ACCOUNT

DWB_PYMT_ON_ACCT

PERIOD TODATE TRANSFORMATION

DWR_PERIOD_TODATE_TRANS

PERIOD TRANSFORMATION

DWR_PERIOD_TRANS

PERSONAL ID REQUIRED TYPE

DWL_PRSNL_ID_REQD_TYP (View)

PHASE

DWR_PHS

PLANNING PERIOD

DWR_PLNG_PERIOD

PLANNING QUARTER

DWR_PLNG_QTR

PLANNING SEASON

DWR_PLNG_SEASON

PLANNING SEASON WEEK ASSIGNMENT

DWR_PLNG_SEASON_WK_ASGNMNT

PLANNING WEEK

DWR_PLNG_WK

PLANNING YEAR

DWR_PLNG_YR

POS CONTROL

DWD_POS_CNTRL

POS DEPARTMENT

DWR_POS_DEPT

POS IDENTITY

DWR_POS_IDNT

POS RETAIL

DWD_POS_RTL

POS STORE FINANCIAL

DWD_POS_STORE_FINCL

POS TENDER FLOW

DWD_POS_TNDR_FLOW

POS TYPE

DWL_POS_TYP

POST CODE

DWR_POSTCD

PREFERENCE TYPE

DWL_PREF_TYP (View)

PREPARED

Subentity of SKU ITEM (Reference Entity)

PRICE DERIVATION RULE

DWR_PRICE_DRVTN_RULE

PRICE LIST

DWL_PRICE_LST_TYP (View)

PRODUCT ENTITY

DWR_PROD_ENT

PROFILE INDIVIDUAL

Subentity of CUSTOMER (Reference Entity)

PROFILE ORGANIZATION

Subentity of CUSTOMER (Reference Entity)

PROFILE SOURCE

DWL_PRFL_SRC (View)

PROMOTION

DWR_PRMTN

PROMOTION COST CONTRIBUTION WEEK AGGR

DWA_PRMTN_COST_CNTRBTN_WK

PROMOTION ITEM

DWB_PRMTN_ITM

PROMOTION MEDIA COST

DWB_PRMTN_MEDIA_COST

PROMOTION PRICE DERIVATION

DWB_PRMTN_PRICE_DRVTN

PROMOTION SALES MARGIN WEEK AGGR

DWA_PRMTN_SLS_MRGN_WK

PROMOTION SELLING ITEM

DWR_PRMTN_SLNG_ITEM

PROMOTION TRIGGER TYPE

DWL_PRMTN_TRGR_TYP (View)

PROSPECT

DWR_PRSPCT

PROSPECT INDIVIDUAL

Subentity of PROSPECT (Reference Entity)

PROSPECT ORGANIZATION

Subentity of PROSPECT (Reference Entity)

PROSPECT QUICK FACTS

Subentity of PROSPECT (Reference Entity)

PROSPECT RESTRICTED INFO

DWR_PRSPCT_RSTRCT_INFO

PURCHASE ORDER

DWB_PCHSE_ORDR

PURCHASE ORDER LINE ITEM

DWB_PCHSE_ORDR_LI

PURCHASE ORDER LINE ITEM STATE

DWB_PCHSE_ORDR_LI_STATE

PURCHASE ORDER STATE

DWB_PCHSE_ORDR_STATE

QUARTER HOUR

DWR_QTR_HR

QUARTER TODATE TRANSFORMATION

DWR_QTR_TODATE_TRANS

QUARTER TRANSFORMATION

DWR_QTR_TRANS

REASON

DWL_RSN

REASON CATEGORY

DWL_RSN_CTGRY

RECEIVING DOCUMENT

DWB_RCVNG_DOC

REQUEST ORIGIN TYPE

DWL_RQST_ORIGIN_TYP (View)

RESTRICTION VALIDATION QUESTION

DWR_RSTRCT_VALID_QUES

RETAIL MARK DOWN ITEM DAY AGGR

DWA_RTL_MRKDN_ITEM_DAY

RETAIL MARKDOWN DEPARTMENT DAY AGGR

DWA_RTL_MRKDN_DEPT_DAY

RETAIL MARKDOWN DEPARTMENT WEEK AGGR

DWA_RTL_MRKDN_DEPT_WK

RETAIL MARKDOWN ITEM WEEK AGGR

DWA_RTL_MRKDN_ITEM_WK

RETAIL SALE RETURN DEPARTMENT DAY AGGR

DWA_RTL_SL_RETRN_DEPT_DAY

RETAIL SALE RETURN DEPARTMENT WEEK AGGR

DWA_RTL_SL_RETRN_DEPT_WK

RETAIL SALE RETURN ITEM DAY DERIVED

DWD_RTL_SL_RETRN_ITEM_DAY

RETAIL SALE RETURN ITEM MONTH AGGR

DWA_RTL_SL_RETRN_ITEM_MO

RETAIL SALE RETURN ITEM WEEK AGGR

DWA_RTL_SL_RETRN_ITEM_WK

RETAIL SALE RETURN LINE ITEM

DWB_RTL_SLS_RETRN_LINE_ITEM

RETAIL SALE RETURN ORG HRCHY DAY AGGR

DWA_RTL_SL_RETRN_ORG_HRCHY_DAY

RETAIL SALE RETURN PROMOTION LINE ITEM

DWB_RTL_SL_RETRN_PRMTN_LI

RETAIL SALE RETURN SUBCLASS DAY AGGR

DWA_RTL_SL_RETRN_SBC_DAY

RETAIL SALE RETURN SUBCLASS MONTH AGGR

DWA_RTL_SL_RETRN_SBC_MO

RETAIL SALE RETURN SUBCLASS WEEK AGGR

DWA_RTL_SL_RETRN_SBC_WK

RETAIL TENDER HISTORY

DWB_RTL_TNDR_HIST

RETAIL TRANSACTION

DWB_RTL_TRX

RETAIL TRANSACTION ASSOCIATE ASSIGNMENT

DWB_RTL_TRX_ASSOCT_ASGNMNT

RETAIL TRANSACTION EMP WORKSTATION AGGR

DWA_RTL_TRX_EMP_WRKSTN

RETAIL TRANSACTION MISCELLANEOUS LINE ITEM

DWB_RTL_TRX_MISC_LI

RETAIL TRANSACTION TYPE

DWL_RTL_TRX_TYP (View)

RETAIL TYPE

DWL_RTL_TYP (View)

RETURN AND TRANSFER IN OUT DOCUMENT

DWB_RETRN_TRNSFR_IN_OUT_DOC

RETURN AUTHORIZATION REQUEST

DWB_RETRN_ATHRZTN_RQST

RETURN STATUS

DWL_RETRN_STATUS (View)

RETURN TO VENDOR ITEM DAY DERIVED

DWD_RTV_ITEM_DAY

RFMP METHOD

DWL_RFMP_MTHD

ROLES HIERARCHY

DWR_RL_HRCHY

SALE OR RETURN ACTION

DWL_SL_OR_RETRN_ACTN (View)

SALE WEIGHT OR UNIT COUNT

DWL_SL_WT_OR_UNIT_CNT (View)

SALES FORECAST ITEM ORG HIERARCHY WEEK

DWB_SL_FRCST_ITEM_ORG_HRCHY_WK

SALES PLAN ITEM ORG HIERARCHY WEEK

DWB_SLS_PLAN_ITEM_ORG_HRCHY_WK

SALES RESTRICTION

DWR_SLS_RSTRCT

SEASON

DWR_SEASON

SECURITY REQUIRED TYPE

DWL_SCRTY_REQD_TYP (View)

SELLING LOCATION

DWR_SLNG_LOC

SELLING LOCATION TYPE

DWL_SLNG_LOC_TYP (View)

SELLING STATUS

DWL_SLNG_STATUS (View)

SERVICE SKU

Subentity of SKU ITEM (Reference Entity)

SERVICE TERM

DWR_SRVC_TERM

SHIPMENT METHOD

DWL_SHPMNT_MTHD (View)

SHIPMENT PRIORITY

DWL_SHPMNT_PRIORITY (View)

SIZE

DWL_SZ

SIZE TYPE

DWL_SZ_TYP (View)

SKU ITEM

DWR_SKU_ITEM

SKU ITEM BUSINESS UNIT INVENTORY RULES

DWR_SKU_ITEM_BSNS_UNIT_INV_RL

SKU ITEM BUSINESS UNIT SELLING PRICE

DWR_SKU_ITEM_BU_SL_PRC

SKU ITEM CHOICE

DWR_SKU_ITEM_CHOICE

SKU ITEM COLLECTION

DWR_SKU_ITEM_COLLCTN

SKU ITEM CONSTRUCTION

DWR_SKU_ITEM_CONSTRUCTION

SKU ITEM SELLING PRICE

DWB_SKU_ITEM_SLNG_PRICE

SKU ITEM SELLING PRICE HISTORY

DWR_SKU_ITEM_SLNG_PRICE_HIST

SKU ITEM SHELF ATTRIBUTES

DWR_SKU_ITEM_SHELF_ATTR

SKU ITEM STYLE

DWL_SKU_ITEM_STYLE (View)

SKU ITEM SUBSTITUTION

DWR_SKU_ITEM_SUB

SKU ITEM TYPE

DWL_SKU_ITEM_TYP (View)

SKU ITEM VARIETY ASSIGNMENT

DWR_SKU_ITEM_VRTY_ASGNMNT

SKU ITEM WEIGHT

DWR_SKU_ITEM_WT

SPACE UTILIZATION DEPARTMENT DAY AGGR

DWA_SPACE_UTLZTN_DEPT_DAY

SPACE UTILIZATION ITEM DAY DERIVED

DWD_SPACE_UTLZTN_ITEM_DAY

STATUS

DWR_STATUS

STATUS REASON

DWL_STATUS_RSN (View)

STATUS TYPE

DWL_STATUS_TYP (View)

STOCK

Subentity of SKU ITEM (Reference Entity)

STOCK ITEM TYPE

DWL_STCK_ITEM_TYP (View)

STOCK LEDGER BY SUBCLASS MONTH AGGR

DWA_STCK_LDGR_BY_SBC_MO

STOCK LEDGER BY SUBCLASS WEEK AGGR

DWA_STCK_LDGR_BY_SBC_WK

STORE FINANCIAL LEDGER ACCOUNT

DWL_STORE_FINCL_LDGR_ACCT

STORE SAFE

DWR_STORE_SAFE

STORE WORKSTATION

Subentity of TOUCHPOINT (Reference Entity)

TARGET

Subentity of CAMPAIGN MESSAGE RENDERING (Reference Entity)

TAX AUTHORITY

DWL_TAX_AUTH

TAX EXEMPT CODE

DWR_TAX_EXMPT_CD

TAX EXEMPTION

DWL_TAX_EXMPTN

TAXABLE GROUP

DWL_TAXBL_GRP

TENDER

DWR_TNDR

TENDER CHANGE LINE ITEM

DWB_TNDR_CHNG_LI

TENDER CLASS

DWL_TNDR_CLASS (View)

TENDER REPOSITORY

DWR_TNDR_RPSTRY

TENDER REPOSITORY CLASS

DWL_TNDR_RPSTRY_CLASS (View)

TENDER TYPE

DWL_TNDR_TYP

TERM CODE

DWL_TERM_CD

TERMS MASTER

DWR_TRMS_MASTER

THEFT TYPE

DWL_THEFT_TYP (View)

TILL

DWD_TILL

TILL HISTORY

DWB_TILL_HIST

TILL HISTORY WORKSTATION AGGR

DWA_TILL_HIST_WRKSTN

TILL TAX HISTORY

DWB_TILL_TAX_HIST

TILL TENDER HISTORY

DWB_TILL_TNDR_HIST

TILL TENDER HISTORY EMPLOYEE AGGR

DWA_TILL_TNDR_HIST_EMP

TIME PLANNING SEASON TODATE BY WEEK

DWR_TIME_PLNG_SEASON_TD_BY_WK

TIME STANDARD BY DAY

DWR_TIME_STNDRD_BY_DAY

TIME STANDARD BY WEEK

DWR_TIME_STNDRD_BY_WK

TIME ZONE

DWL_TIME_ZN

TOTAL TYPE

DWL_TOTAL_TYP (View)

TOUCHPOINT

DWR_TCHPNT

TRADE AREA

DWR_TRD_AREA

TRADE AREA COVERAGE

DWR_TRD_AREA_COVRG

TRADE IN TENDER

DWB_TRD_IN_TNDR

TRANSACTION TYPE

DWL_TRX_TYP

TRANSFER TYPE

DWL_TRNSFR_TYP (View)

UNIT OF MEASURE

DWL_UOM

UOM CONVERSION

DWI_UOM_CNVRSN

USER

DWR_USERS

VALIDATION QUESTION ASSIGNMENT

DWR_VALID_QUES_ASGNMNT

VALUE MEASURE

DWR_VAL_MSR

VALUE TYPE

DWL_VAL_TYP (View)

VARIETY

DWR_VRTY

VARIETY TYPE

DWL_VRTY_TYP (View)

VENDOR

DWR_VNDR

VENDOR APPOINTMENT

DWR_VNDR_APNMNT

VENDOR AVALABILITY ITEM DAY AGGR

DWA_VNDR_AVLBLTY_ITEM_DAY

VENDOR CARRIER ASSIGNMENT

DWR_VNDR_CARRIER_ASGNMNT

VENDOR CLASS

DWL_VNDR_CLASS (View)

VENDOR COMPLIANCE ITEM WEEK AGGR

DWA_VNDR_CMPLNC_ITEM_WK

VENDOR COMPLIANCE WEEK AGGR

DWA_VNDR_CMPLNC_WK

VENDOR CONTRACT

DWR_VNDR_CNTRCT

VENDOR CONTRACT ITEM DAY AGGR

DWA_VNDR_CNTRCT_ITEM_DAY

VENDOR FACTOR COMPANY ASSIGNMENT

DWR_VNDR_FCTR_CMPNY_ASGNMNT

VENDOR ITEM

DWR_VNDR_ITEM

VENDOR ITEM BUSINESS UNIT ASSIGNMENT

DWR_VNDR_ITEM_BSNS_UNIT_ASGN

VENDOR ITEM SKU ASSIGNMENT

DWR_VNDR_ITEM_SKU_ASGNMNT

VENDOR MANUFACTURER BRAND

DWR_VNDR_MNFCTR_BRAND

VENDOR QUICK FACTS

Subentity of VENDOR ITEM (Reference Entity)

VENDOR RATING

DWR_VNDR_RTNG

VENDOR RATING TYPE

DWL_VNDR_RTNG_TYP (View)

VENDOR SITE

DWR_VNDR_SITE

VENDOR SITE ADDRESS

DWR_VNDR_SITE_ADDR

VENDOR SITE CARRIER ASSIGNMENT

DWR_VNDR_CARRIER_ASGNMNT

VENDOR SKU BUSINESS UNIT ASSIGNMENT

DWR_VNDR_SKU_BSNS_UNIT_ASGNMNT

VENDOR SKU COST PROFIT DAY

DWB_VNDR_SKU_COST_PRFT_DAY

VENDOR STATUS

DWR_VNDR_STATUS

WEAVE

DWL_WEAVE (View)

WEEK

DWR_WK

WEEK TODATE TRANSFORMATION

DWR_WK_TODATE_TRANS

WEEK TRANSFORMATION

DWR_WK_TRANS

WEEKDAY

DWR_WKDAY

WORK HOUR TYPE

DWL_WRK_HR_TYP (View)

WORK STATION DISPLAY

DWR_WRKSTN_DISP

WORKSTATION LOCATION TYPE

DWL_WRKSTN_LOC_TYP (View)

YEAR TRANSFORMATION

DWR_YR_TRANS