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 |