The following table lists the entities in the logical data model, and the physical database tables or views to which they have been implemented or "physicalized".
Table 4-1 lists the entities and the tables or views they map to.
Table 4-1 Entity Mapping Table
Entity | Table or View |
---|---|
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 |