Skip Headers
Oracle® Retail Data Model Reference
Release 11.3.1

Part Number E20361-01
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

4 Logical to Physical Mappings in the Oracle Retail Data Model

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".

Entity Mapping Table

Table 4-1 and Table 4-2 list the Oracle Retail Data Model entities and the mapping to tables or views for each entity.

Table 4-1 Entity Mapping Logical to Physical: A to M Entities

Entity Table or View

ACCOUNT PAYABLE DAY DERIVED

DWD_ACCT_PAYBL_DAY

ACCOUNT PAYABLE MONTH AGGR

DWA_ACCT_PAYBL_MO

ACCOUNT RECEIVABLE DAY DERIVED

DWD_ACCT_RCVBL_DAY

ACCOUNT RECEIVABLE MONTH AGGR

DWA_ACCT_RCVBL_MO

ACCOUNT TYPE

DWL_ACCT_TYP

ACTIVITY REQUEST DAY DERIVED

DWD_ACTVTY_RQST_DAY

ACTIVITY REQUEST MONTH AGGR

DWA_ACTVTY_RQST_MO

ACTIVITY REQUEST TYPE

DWL_ACTVTY_RQST_TYP

ADDRESS LOCATION

DWR_ADDR_LOC

ADDRESS LOCATION STATUS HISTORY

DWB_ADDR_LOC_STAT_HIST

ADDRESS LOCATION TYPE

DWL_ADDR_LOC_TYP

ADDRESS RELATED

DWR_ADDR_RLTD

ADDRESS TELEPHONE

DWR_ADDR_PHONE

ADDRESS TYPE

DWL_ADDR_TYP

ADDRESS VERIFICATION TYPE

DWL_ADDR_VRFY_TYP

ADJUSTMENT TYPE

DWL_ADJ_TYP

ADMINISTRATION CENTER

DWR_ORG_BSNS_UNIT

ADVANCED SHIP NOTICE DOCUMENT

DWB_INV_CNTRL_DOC

ADVANCED SHIP NOTICE DOCUMENT LINE ITEM

DWB_INV_CNTRL_DOC_LI

ADVERTISING PERIOD

DWR_ADVR_PERIOD

ADVERTISING QUARTER

DWR_ADVR_QTR

ADVERTISING WEEK

DWR_ADVR_WK

ADVERTISING YEAR

DWR_ADVR_YR

AGE GROUP

DWL_AGE_GRP

AGE RESTRICTION RULE

DWR_AGE_RSTRCT_RULE

AGENT

DWR_AGNT

AGGREGATE SKU

DWR_SKU_ITEM

ALTERNATIVE ITEM

DWR_ALTVE_ITEM

ANALYSIS DURATION

DWR_ANLYS_DRTN

APPAREL ITEM

DWR_SKU_ITEM

APPOINTMENT CALENDAR

DWR_APPT_CALNDR

APPOINTMENT MEETING TYPE

DWL_APNMNT_MTNG_TYP

APPOINTMENT TYPE

DWL_APNMNT_TYP

ASSETS DAY DERIVED

DWD_ASSTS_DAY

ASSETS MONTH AGGR

DWA_ASSTS_MO

ASSETS TYPE

DWL_ASSTS_TYP

AUTHORIZATION METHOD

DWL_ATHRZTN_MTHD

BANK

DWR_BNK

BASE DAY

DWR_BASE_DAY

BLENDER

DWR_EQPMNT

BRAND

DWR_BRND

BULK ITEM

DWR_SKU_ITEM

BUMP BAR EQUIPMENT STATISTICS READING

DWB_BUMP_BR_EQPMNT_STSTCS_RDNG

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 LEGAL STATUS

DWL_BSNS_LEGAL_STAT

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

BUSINESS UNIT USAGE TYPE

DWL_BSNS_UNIT_USG_TYP

BUSINESS WEEK

DWR_BSNS_WK

BUSINESS YEAR

DWR_BSNS_YR

CALENDAR

DWR_CLNDR

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 TYPE

DWL_CLNDR_TYP

CALENDAR WEEK

DWR_CLNDR_WK

CALENDAR YEAR

DWR_CLNDR_YR

CALL CENTER

DWR_CALL_CNTR

CALL CENTER AGENT

DWR_CALL_CNTR_AGNT

CALL CENTER AGENT TYPE

DWL_CALL_CNTR_AGNT_TYP

CALL CENTER CASE SUB TYPE

DWL_CALL_CNTR_CASE_SB_TYP

CALL CENTER CASE TITLE

DWR_CALL_CNTR_CASE_TTL

CALL CENTER CASE TYPE

DWL_CALL_CNTR_CASE_TYP

CAMPAIGN

DWR_CMPGN

CAMPAIGN COST

DWB_COST

CAMPAIGN CUSTOMER ASSIGNMENT

DWR_CMPGN_CUST_ASGN

CAMPAIGN EXECUTION MESSAGE

DWR_CMPGN_EXEC_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 MESSAGE RENDERING COST

DWB_COST

CAMPAIGN TARGET

DWR_CMPGN_CUST_ASGN

CARD HOLDER VERIFICATION TYPE

DWL_CARD_HLDR_VRFY_TYP

CARD TYPE

DWL_CARD_TYP

CARRIER

DWR_CARRIER

CARRIER COMPLIANCE DAY DERIVED

DWD_CARRIER_CMPLNC_DAY

CARRIER COMPLIANCE WEEK AGGR

DWA_CARRIER_CMPLNC_WK

CASH DRAWER EQUIPMENT STATISTICS READING

DWB_CS_DRWR_EQPMNT_STSTCS_RDNG

CERTIFICATE

DWR_CRTFCT

CERTIFICATE ACTIVITY DAY AGGR

DWA_CRTFCT_ACTVTY_DAY

CERTIFICATE ACTIVITY TRANSACTION DERIVED

DWD_CRTFCT_ACTVTY_TRX

CERTIFICATE AGE BAND

DWR_CRTFCT_AGE_BND

CERTIFICATE ESCHEATED DAY

DWB_CRTFCT_ESCHTD_DAY

CERTIFICATE LINE ITEM

DWB_CRTFCT_LI

CERTIFICATE TENDER LINE ITEM

DWB_RTL_TNDR_LI

CERTIFICATE TYPE

DWL_CRTFCT_TYP

CHANNEL TYPE

DWL_CHNL_TYP

CHECK TENDER LINE ITEM

DWB_RTL_TNDR_LI

CLASS

DWL_CLASS

CLIENT

DWR_CLNT

CLIENT HOST

DWR_CLNT_HOST

CLIENT TYPE

DWL_CLNT_TYP

CLIENT VERSION

DWR_CLNT_VRSN

COATING

DWL_COATING

COLOR

DWL_COLOR

COLOR LIST AGENCY

DWL_COLOR_LST_AGNCY

COLOR PALETTE

DWL_COLOR_PALETTE

COMMUNICATION TYPE

DWL_COMUNICTN_TYP

COMPETITOR

DWR_CMPTR

COMPETITOR LOCATION

DWR_CMPTR_LOC

COMPETITOR LOCATION ASSIGNMENT

DWR_CMPTR_LOC_ASGN

COMPETITOR MANUFACTURER SKU ITEM

DWR_CMPTR_MNFCTR_SKU_ITEM

COMPETITOR RETAIL ITEM

DWR_CMPTR_RTL_ITEM

CONTRACT STATUS

DWR_CNRT_STAT

CONTRACT STATUS REASON

DWL_CNRT_STAT_RSN

CONTRACT STATUS TYPE

DWL_CNRT_STAT_TYP

CONTRACT TERM TYPE

DWL_CNRT_TERM_TYP

CONTRACT TERM VALUE

DWR_CNRT_TERM_VAL

CONTRACT TYPE

DWL_CNRT_TYP

CONTROL TRANSACTION

DWB_CNTRL_TRX

CONTROL TRANSACTION TYPE

DWL_CNTRL_TRX_TYP

COST

DWB_COST

COST CENTER

DWR_COST_CNTR

COST CENTER BUDGET

DWB_COST_CNTR_BDGT

COST DAY DERIVED

DWD_COST_DAY

COST MONTH AGGR

DWA_COST_MO

COST PER UNIT TYPE

DWL_COST_PER_UNIT_TYP

COST REASON

DWL_COST_RSN

COST SUBTYPE

DWL_COST_SUBTYP

COST TYPE

DWL_COST_TYP

COST VALUATION LEDGER ACCOUNT

DWR_GL_ACCT

COST VALUATION LEDGER ACCOUNT HISTORY

DWB_COST_VALTN_LDGR_ACCT_HIST

COUPON SCAN

DWL_CPN_SCAN

COUPON TENDER LINE ITEM

DWB_RTL_TNDR_LI

COUPON TYPE

DWL_CPN_TYP

CREATIVES

DWR_CRTV

CREDIT-DEBIT CARD TENDER LINE ITEM

DWB_RTL_TNDR_LI

CURRENCY

DWL_CRNCY

CURRENCY CONFIGURATION

DWC_CRNCY_CONF

CUSTOMER

DWR_CUST

CUSTOMER ACCOUNT

DWR_CUST_ACCT

CUSTOMER ACCOUNT CARD

DWR_CUST_ACCT_CARD

CUSTOMER ACCOUNT CARD ASSIGNMENT

DWR_CUST_ACCT_CARD_ASGN

CUSTOMER ACCOUNT TENDER LINE ITEM

DWB_RTL_TNDR_LI

CUSTOMER ADDRESS

DWR_CUST_ADDR

CUSTOMER AFFILIATION

DWR_CUST_AFFLTN

CUSTOMER AUTHENTICATION GROUP

DWR_CUST_ATHNCTN_GRP

CUSTOMER CLUSTER

DWR_CUST_CLSTR

CUSTOMER CLUSTER ITEM ASSIGNMENT

DWR_CUST_CLSTR_ITEM_ASGN

CUSTOMER CLUSTER TYPE

DWR_CUST_CLSTR_TYP

CUSTOMER CONTRACT

DWR_CUST_CNRT

CUSTOMER COST

DWB_COST

CUSTOMER EMPLOYEE RELATIONSHIP DAY DERIVED

DWD_CUST_EMP_RLTNSHP_DAY

CUSTOMER EMPLOYEE RELATIONSHIP MONTH AGGR

DWA_CUST_EMP_RLTNSHP_MO

CUSTOMER EMPLOYEE SALE RETURN MONTH AGGR

DWA_CUST_EMP_SL_RETRN_MO

CUSTOMER GROUP

DWR_CUST_GRP

CUSTOMER GROUP ITEM

DWR_CUST_GRP_ITEM

CUSTOMER INDIVIDUAL

DWR_CUST

CUSTOMER INFORMATION LINE ITEM

DWB_CUST_INFO_LI

CUSTOMER INVOICE

DWB_CUST_INVC

CUSTOMER INVOICE ITEM

DWB_CUST_INVC_ITEM

CUSTOMER OCCASION

DWR_CUST_OCCSN

CUSTOMER OCCASION TYPE

DWL_CUST_OCCSN_TYP

CUSTOMER ORDER

DWB_CUST_ORDR

CUSTOMER ORDER CONTROL TRANSACTION

DWB_CUST_ORDR_CNTRL_TRX

CUSTOMER ORDER CONTROL TRANSACTION LINE ITEM

DWB_CUST_ORDR_CNTRL_TRX_LI

CUSTOMER ORDER LINE ITEM

DWB_CUST_ORDR_LI

CUSTOMER ORDER LINE ITEM STATE

DWB_CUST_ORDR_LI_STATE

CUSTOMER ORDER LINE ITEM STATE DERIVED

DWD_CUST_ORDR_LI_STATE

CUSTOMER ORDER STATE

DWB_CUST_ORDR_STATE

CUSTOMER ORDER TAX EXEMPTION MODIFIER

DWB_CUST_ORDR_TAX_EXMPTN_MDFR

CUSTOMER ORDER TAX LINE ITEM

DWB_CUST_ORDR_LI

CUSTOMER ORDER TAX OVERRIDE MODIFIER

DWB_CUST_ORDR_TAX_OVRRD_MDFR

CUSTOMER ORDER TENDER PRE AUTHORIZATION

DWB_CUST_ORDR_LI

CUSTOMER ORGANIZATION

DWR_CUST

CUSTOMER PAYMENT

DWB_CUST_PYMT

CUSTOMER PICKUP TYPE

DWL_CUST_PCKUP_TYP

CUSTOMER PREFERENCE

DWR_CUST_PREF

CUSTOMER QUICK FACTS

Subentity of CUSTOMER (Reference Entity)

CUSTOMER RELATIONSHIP

DWR_CUST_RLTNSHP

CUSTOMER RELATIONSHIP TYPE

DWL_CUST_RLTN_TYP

CUSTOMER RENTAL ACCOUNT

DWR_CUST_ACCT

CUSTOMER RENTAL ACCOUNT HISTORY

DWB_CUST_RNTL_ACCT_HIST

CUSTOMER RESTRICTED INFO

DWR_CUST_RSTRCT_INFO

CUSTOMER RFMP SCORE

DWD_CUST_RFMP_SCR

CUSTOMER SKU SALE RETURN DAY DERIVED

DWD_CUST_SKU_SL_RETRN_DAY

CUSTOMER STATUS

DWB_CUST_STAT

CUSTOMER TRADE ACCOUNT

DWR_CUST_ACCT

CUSTOMER TYPE

DWL_CUST_TYP

CUSTOMER TYPE ORDER DEPARTMENT MONTH AGGR

DWA_CUST_TYP_ORDR_DEPT_MO

CUSTOMER TYPE ORDER ITEM DAY DERIVED

DWD_CUST_TYP_ORDR_ITEM_DAY

CUSTOMER TYPE ORDER SUBCLASS WEEK AGGR

DWA_CUST_TYP_ORDR_SBC_WK

DAY

DWR_DAY

DAY ACTUAL CONDITION

DWR_DAY_ACT_CNDTN

DAY TODATE TRANSFORMATION

DWR_DAY_TODATE_TRANS

DAY TRANSFORMATION

DWR_DAY_TRANS

DEAL

DWR_DEAL

DEAL VENDOR ITEM ASSIGNMENT

DWB_DEAL_VNDR_ITEM_ASGN

DEAL VENDOR ITEM COST BREAK

DWB_DEAL_VNDR_ITEM_COST_BRK

DEMOGRAPHY ATTRIBUTE

DWR_DEMOG_ATTR

DEMOGRAPHY GROUP

DWR_DEMOG_GRP

DENOMINATION

DWL_DENMTN

DEPOSIT REDEMPTION LINE ITEM

DWB_DPST_RDMPTN_LI

DEPOSIT REDEMPTION TYPE

DWL_DPST_RDMPTN_TYP

DEPOSIT RULE

DWR_DPST_RULE

DERIVED VALUE

DWR_DRVD_VAL

DESTINATION TYPE

DWL_DSTN_TYP

DEVICE EVENT

DWB_DVC_EVT

DISBURSEMENT FUNDS RECEIPT REASON

DWL_DISBRSMNT_FND_RCPT_RSN

DISBURSEMENT TRANSACTION

DWB_TNDR_CNTRL_TRX

DISCOUNT LINE ITEM

DWB_DISC_LI

DISCOUNT TYPE

DWL_DISC_TYP

DISCOUNT TYPE GROUP

DWL_DISC_TYP_GRP

DISCREPANCY TOLERANCE RULE

DWR_DSCRPNCY_TOLRNC_RULE

DISPLAY UNIT ITEM

DWR_ITEM

DISPOSITION TYPE

DWL_DSPSTN_TYP

DOMAIN

DWR_DOMAIN

DOMAIN TYPE

DWL_DOMAIN_TYP

DRIVE OFF TRANSACTION

DWB_FORECOURT_TRX

DYE

DWL_DYE

EDUCATION

DWL_EDU_LVL

EMAIL ADDRESS

DWR_EML_ADDR

EMPLOYEE

DWR_EMP

EMPLOYEE ACTUAL LABOR DETAIL

DWB_EMP_ACT_LBR_SAL

EMPLOYEE ACTUAL LABOR HOURLY

DWB_EMP_ACT_LBR_HRLY

EMPLOYEE ACTUAL LABOR SALARIED

DWB_EMP_ACT_LBR_SAL

EMPLOYEE ADDRESS

DWR_EMP_ADDR

EMPLOYEE AVAILABILITY

DWR_EMP_AVLBLTY

EMPLOYEE CERTIFICATE

DWR_EMP_CRTFCT

EMPLOYEE CERTIFICATION ISSUING BODY

DWR_EMP_CRTFCTN_ISSUING_BODY

EMPLOYEE CERTIFICATION TYPE

DWL_EMP_CRTFCTN_TYP

EMPLOYEE CLASS

DWR_EMP_CLASS

EMPLOYEE CLASS ASSIGNMENT

DWR_EMP_CLASS_ASGN

EMPLOYEE COMMISSION PLAN

DWR_EMP_CMISN_PLN

EMPLOYEE COST

DWB_COST

EMPLOYEE DESIGNATION

DWR_EMP_DESIG

EMPLOYEE DISCOUNT GROUP

DWR_EMP_DISC_GRP

EMPLOYEE DISCOUNT GROUP ASSIGNMENT

DWR_EMP_DISC_GRP_ASGN

EMPLOYEE DISCOUNTED SALES HISTORY

DWB_EMP_DISC_SL_HIST

EMPLOYEE JOB ROLE ASSIGNMENT

DWB_EMP_JB_RL_ASGN

EMPLOYEE LABOR DERIVED

DWD_EMP_LBR

EMPLOYEE POSITION ASSIGNMENT

DWB_EMP_POSN_ASGN

EMPLOYEE PUNCH

DWB_EMP_PUNCH

EMPLOYEE RESTRICTED INFORMATION

DWR_EMP_RSTRCT_INFO

EMPLOYEE SCHEDULE

DWR_EMP_SCHL

EMPLOYEE SERVER ASSIGNMENT

DWB_EMP_SERVER_ASGN

EMPLOYEE TIME ACCRUAL HISTORY

DWB_EMP_TIME_ACCRUAL_HIST

EMPLOYEE TIME ACCRUAL TYPE

DWL_EMP_TIME_ACCRUAL_TYP

EMPLOYEE TIME PUNCH ENTRY

DWB_EMP_TIME_PUNCH_ENTRY

EMPLOYEE TRAINING RECORD

DWB_EMP_TRNG_REC

EMPLOYEE TYPE

DWL_EMP_TYP

EMPLOYEE WAGE PAYMENT DAY DERIVED

DWD_EMP_WG_PYMT_DAY

ENTRY METHOD

DWL_ENTRY_MTHD

ENVIRONMENT TYPE

DWL_ENV_TYP

EQUIPMENT

DWR_EQPMNT

EQUIPMENT ASSIGNMENT

DWR_EQPMNT_ASGN

EQUIPMENT CLASS

DWR_EQPMNT_CLASS

EQUIPMENT STATISTICS READING

Supertype (no physical table)

EQUIPMENT TYPE

DWL_EQPMNT_TYP

EVENT

DWB_EVT

EVENT COST

DWB_COST

EVENT PARTY INTERACTION PARTICIPATION

DWB_EVT_PRTY_INTRACN_PRTCPTN

EVENT TYPE

DWL_EVT_TYP

EXCHANGE RATE CURRENCY DAY

DWB_EXCHNG_RATE_CRNCY_DAY

EXPENSE TYPE

DWL_EXP_TYP

EXTERNAL DEPOSITORY

DWR_EXT_DEPOS

EXTERNAL DEPOSITORY SETTLEMENT TRANSACTION

DWB_CNTRL_TRX

FABRIC

DWL_FABRIC

FACTOR COMPANY

DWR_FCTR_CMPNY

FIBER

DWL_FIBER

FISCAL HALF MONTH

DWR_FSCL_HLF_MO

FISCAL HALF YEAR

DWR_FSCL_HLF_YR

FISCAL MONTH

DWR_FSCL_MO

FISCAL PRINTER EQUIPMENT STATISTICS READING

DWB_FCL_PTR_EQPMNT_STSTCS_RDNG

FISCAL QUARTER

DWR_FSCL_QTR

FISCAL WEEK

DWR_FSCL_WK

FISCAL YEAR

DWR_FSCL_YR

FLEET MANAGEMENT

DWB_FLEET_MGMT

FOOD SERVICE LINE ITEM

DWB_RTL_SL_RTRN_LI

FOOD SERVICE TABLE

DWR_FOOD_SRVC_TBL

FOOD SERVICE TRANSACTION

DWB_FOOD_SRVC_TRX

FOOD STAMPS TENDER LINE ITEM

DWB_RTL_TNDR_LI

FORECOURT SETTLEMENT TRANSACTION

DWB_FORECOURT_TRX

FORECOURT TRANSACTION

DWB_FORECOURT_TRX

FRANCHISEE

DWR_FRANCHISEE

FREIGHT DOCUMENT

DWB_FRGHT_DOC

FUEL ITEM

DWR_SKU_ITEM

FUEL ITEM PRICE

DWB_SKU_ITEM_SLNG_PRICE

FUEL PUMP

DWR_EQPMNT

FUEL SALE STATUS

DWL_FUEL_SL_STAT

FUEL SALES LINE ITEM

DWB_RTL_SL_RTRN_LI

FUELING POINT

DWR_EQPMNT

FUELING TRANSACTION

DWB_FUELING_TRX

FULFILLMENT ACKNOWLEDGMENT LINE ITEM

DWB_FLFLMNT_ACKNLGMNT_LI

FULFILLMENT ACKNOWLEDGMENT TRANSACTION

DWB_FLFLMNT_ACKNLGMNT_LI

FUNCTION CODE

DWL_FNCTN_CD

FUND RECEIPT TRANSACTION

DWB_TNDR_CNTRL_TRX

GENDER

DWL_GNDR

GEOGRAPHY CITY

DWR_GEO_CITY

GEOGRAPHY COUNTRY

DWR_GEO_CNTRY

GEOGRAPHY COUNTY

DWR_GEO_CNTY

GEOGRAPHY DEMOGRAPHIC GROUP

DWR_GEO_DEMOG_GRP

GEOGRAPHY DEMOGRAPHY ATTRIBUTES

DWR_GEO_DEMOG_ATTR

GEOGRAPHY DEMOGRAPHY VALUE

DWR_GEO_DEMOG_VAL

GEOGRAPHY ENTITY

DWR_GEO_ENT

GEOGRAPHY HIERARCHY

DWR_GEO_HRCHY

GEOGRAPHY HIERARCHY LEVEL

DWR_GEO_HRCHY_LVL

GEOGRAPHY HIERARCHY LEVEL ASSIGNMENT

DWR_GEO_HRCHY_LVL_ASGN

GEOGRAPHY HIERARCHY VERSION

DWR_GEO_HRCHY_VRSN

GEOGRAPHY LEVEL

DWR_GEO_LVL

GEOGRAPHY LEVEL ATTRIBUTE VALUE

DWR_GEO_LVL_ATTR_VAL

GEOGRAPHY LEVEL ATTRIBUTES

DWR_GEO_LVL_ATTR

GEOGRAPHY REGION

DWR_GEO_RGN

GEOGRAPHY STATE

DWR_GEO_STATE

GEOGRAPHY SUB REGION

DWR_GEO_SB_RGN

GEOGRAPHY WORLD

DWR_GEO_WORLD

GIFT CERTIFICATE CLASS

DWR_GFT_CRTFCT_CLASS

GIFT CERTIFICATE TYPE

DWL_GFT_CRTFCT_TYP

GL ACCOUNT

DWR_GL_ACCT

GL ACCOUNT ASSIGNMENT

DWR_GL_ACCT_ASGN

GL ACCOUNT ASSIGNMENT TYPE

DWL_GL_ACCT_ASGN_TYP

GL ACCOUNT TYPE

DWL_GL_ACCT_TYP

GL BALANCE

DWB_GL_BAL

GL COST CENTER SEGMENT

DWR_GL_SGMNT

GL JE LINE SUBLEDGER ASSIGNMENT

DWB_GL_JE_LN_SBLDGR_ASGN

GL JOURNAL ENTRY

DWB_GL_JRNL_ENTRY

GL JOURNAL ENTRY BATCH

DWB_GL_JRNL_ENTRY_BTCH

GL JOURNAL ENTRY CATEGORY

DWR_GL_JRNL_ENTRY_CTGRY

GL JOURNAL ENTRY LINE

DWB_GL_JRNL_ENTRY_LN

GL LEDGER

DWR_GL_LDGR

GL LEDGER ACCOUNT ASSIGNMENT

DWR_GL_LDGR_ACCT_ASGN

GL ORG BSNS UNIT SEGMENT

DWR_GL_SGMNT

GL PERIOD

DWR_GL_PRD

GL PRODUCT SEGMENT

DWR_GL_SGMNT

GL PROJECT SEGMENT

DWR_GL_SGMNT

GL SEGMENT

DWR_GL_SGMNT

GL SEGMENT TYPE

DWL_GL_SGMNT_TYP

GL SUBLEDGER

DWR_GL_SBLDGR

GL SUBLEDGER JOURNAL ENTRY

DWB_GL_SBLDGR_JRNL_ENTRY

GL SUBLEDGER JOURNAL ENTRY LINE

DWB_GL_SBLDGR_JRNL_ENTRY_LN

GROUP SELECT

DWR_SKU_ITEM

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

HOUR

DWR_HR

HOURS TYPE

DWL_HRS_TYP

HOUSEHOLD

DWR_HH

ICD ALLOWANCE LINE ITEM

DWB_INV_CNTRL_DOC_LI

ICD ASSIGNMENT REASON

DWL_ICD_ASGN_RSN

ICD ASSIGNMENT TYPE

DWL_ICD_ASGN_TYP

ICD CHARGE LINE ITEM

DWB_INV_CNTRL_DOC_LI

ICD FREIGHT LINE ITEM

DWB_INV_CNTRL_DOC_LI

ICD LINE ITEM ASSIGNMENT

DWB_ICD_LI_ASGN

ICD MERCHANDISE LINE ITEM MODIFIER

DWB_ICD_MRCHNDS_LI_MDFR

ICD MERCHANDISE TAX LINE ITEM

DWB_ICD_MRCHNDS_TAX_LI

ICD TAX EXEMPTION MODIFIER

DWB_ICD_TAX_EXMPTN_MDFR

ICD TAX LINE ITEM

DWB_INV_CNTRL_DOC_LI

IMPRESSION

DWB_IMPRESSION

INDIVIDUAL DEMOGRAPHY VALUE

DWR_INDVL_DEMOG_VAL

INGREDIENT

DWR_INGREDIENT

INGREDIENT OPTION

DWR_INGREDIENT_OPTION

INTERACTION CHANNEL

DWL_INTRACN_CHNL

INTERACTION CHANNEL TYPE

DWL_INTRACN_CHNL_TYP

INTERACTION DIRECTION

DWL_INTRACN_DRCTN

INTERACTION REASON

DWL_INTRACN_RSN

INTERACTION RESULT TYPE

DWL_INTRACN_RSLT_TYP

INTERACTION STATUS

DWL_INTRACN_STAT

INTERACTION THREAD STATUS

DWL_INTRACN_THRD_STAT

INTERACTION TYPE

DWL_INTRACN_TYP

INVENTORY ACCOUNTING METHOD

DWL_INV_ACCT_MTHD

INVENTORY ADJUSTMENT DOCUMENT

DWB_INV_ADJ_DOC

INVENTORY ADJUSTMENT DOCUMENT LINE ITEM

DWB_INV_ADJ_DOC_LI

INVENTORY ADJUSTMENT ITEM DAY DERIVED

DWD_INV_ADJ_ITEM_DAY

INVENTORY CONDITION

DWL_INV_CNDTN

INVENTORY CONTROL DOCUMENT

DWB_INV_CNTRL_DOC

INVENTORY CONTROL DOCUMENT ASSIGNMENT

DWB_INV_CNTRL_DOC_ASGN

INVENTORY CONTROL DOCUMENT LINE ITEM

DWB_INV_CNTRL_DOC_LI

INVENTORY CONTROL DOCUMENT LINE ITEM TYPE

DWL_INV_DOC_LI_TYP

INVENTORY DOCUMENT TYPE

DWL_INV_DOC_TYP

INVENTORY ITEM STATE

DWB_INV_ITEM_STATE

INVENTORY LOCATION

DWR_INV_LOC

INVENTORY LOCATION TYPE

DWL_INV_LOC_TYP

INVENTORY POSITION DEPT DAY AGGR

DWA_INV_POSN_DEPT_DAY

INVENTORY POSITION ITEM DAY DERIVED

DWD_INV_POSN_ITEM_DAY

INVENTORY POSITION SUBCLASS MONTH AGGR

DWA_INV_POSN_SBC_MO

INVENTORY RECEIPT ITEM DAY DERIVED

DWD_INV_RCPT_ITEM_DAY

INVENTORY RECEIPT SUBCLASS WEEK AGGR

DWA_INV_RCPT_SBC_WK

INVENTORY SPACE ALLOCATION

DWB_INV_SPACE_ALCTN

INVENTORY STATE

DWL_INV_STATE

INVENTORY STATUS

DWL_INV_STAT

INVENTORY TRANSFER ITEM DAY DERIVED

DWD_INV_XFER_ITEM_DAY

INVENTORY TYPE

DWL_INV_TYP

INVENTORY UNAVAILABLE ITEM DAY DERIVED

DWD_INV_UNAVL_ITEM_DAY

INVENTORY VENDOR COMPLIANCE DAY DERIVED

DWD_INV_VNDR_CMPLNC_DAY

ISSUE TYPE

DWL_ISSUE_TYP

ITEM

DWR_ITEM

ITEM CLASS

DWR_ITEM_CLASS

ITEM CLUSTER

DWR_ITEM_CLSTR

ITEM CLUSTER CUSTOMER ASSIGNMENT

DWR_ITEM_CLSTR_CUST_ASGN

ITEM CLUSTER TYPE

DWL_ITEM_CLSTR_TYP

ITEM COMPANY

DWR_ITEM_CMPNY

ITEM DEPARTMENT

DWR_ITEM_DEPT

ITEM DIVISION

DWR_ITEM_DIV

ITEM ELECTRONIC LABEL

DWR_ITEM_LBL

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_ASGN

ITEM HIERARCHY VERSION

DWR_ITEM_HRCHY_VRSN

ITEM INVENTORY JOURNAL ENTRY

DWB_ITEM_INV_JRNL_ENTRY

ITEM LABEL

DWR_ITEM_LBL

ITEM LEVEL

DWR_ITEM_LVL

ITEM LEVEL ATTRIBUTE

DWR_ITEM_LVL_ATTR

ITEM LEVEL ATTRIBUTE VALUE

DWR_ITEM_LVL_ATTR_VAL

ITEM LOOKUP METHOD

DWL_ITEM_LKUP_MTHD

ITEM MARKET DATA

DWR_ITEM_MKT_DATA

ITEM PRICE DERIVATION RULE

DWR_ITEM_PRICE_DRVTN_RULE

ITEM SALES PROHIBITION PERIOD RULE

DWR_SLS_RSTRCT

ITEM SEASON

DWR_ITEM_SEASON

ITEM SELLING RULE

DWR_ITEM_SLNG_RULE

ITEM SHELF LABEL

DWR_ITEM

ITEM SPIFF RULE

DWR_ITEM_SPIFF_RULE

ITEM STATE

DWL_ITEM_STATE

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

ITEM TICKET

DWR_ITEM

JOB ALLOCATION

DWB_JB_ALCTN

JOB ROLES

DWL_JB_RL

JOB TASK SET

DWR_JB_TASK_SET

KEY LOCK EQUIPMENT STATISTICS READING

DWB_KEY_LCK_EQPMNT_STSTCS_RDNG

KNOWN SOURCE TYPE

DWL_KNWN_SRC_TYP

LABEL TYPE

DWL_LBL_TYP

LANGUAGE

DWL_LANG

LETTER TYPE

DWL_LTTR_TYP

LIABILITY DAY DERIVED

DWD_LIAB_DAY

LIABILITY MONTH AGGR

DWA_LIAB_MO

LIABILITY TYPE

DWL_LIAB_TYP

LICENSE SALES RESTRICTION

DWR_LICNS_SLS_RSTRCT

LIFECYCLE TYPE

DWL_LFCCL_TYP

LINE DISPLAY EQUIPMENT STATISTICS READING

DWB_LN_DSPL_EQPMNT_STSTCS_RDNG

LOCAL AUTHORITY TYPE

DWL_LCL_AUTH_TYP

LOCAL TAX AUTHORITY

DWR_LCL_TAX_AUTH

LOCATION

Super-entity with work location, selling location, and inventory location as subtypes

LOCATION TYPE

DWL_LOC_TYP

LOYALTY AWARD

DWR_LYLTY_AWRD

LOYALTY PROGRAM

DWR_LYLTY_PROG

LOYALTY REWARD LINE ITEM

DWB_LYLTY_RWRD_LI

MANUFACTURER

DWR_MNFCTR

MANUFACTURER BRAND

DWR_MNFCTR_BRND

MANUFACTURER COST

DWB_COST

MANUFACTURER COUPON FAMILY

DWR_MNFCTR_CPN_FMLY

MANUFACTURER INVENTORY ITEM STATE

DWB_MNFCTR_INV_ITEM_STATE

MANUFACTURER ITEM CLASS

DWR_MNFCTR_ITEM_CLASS

MANUFACTURER ITEM COMPANY

DWR_MNFCTR_ITEM_CMPNY

MANUFACTURER ITEM DIVISION

DWR_MNFCTR_ITEM_DIV

MANUFACTURER ITEM GROUP

DWR_MNFCTR_ITEM_GRP

MANUFACTURER ITEM RETAILER ASSIGNMENT

DWR_MNFCTR_ITEM_RTLR_ASGN

MANUFACTURER ITEM SUBCLASS

DWR_MNFCTR_ITEM_SBC

MANUFACTURER ORGANIZATION COMPETITOR ASSIGNMENT

DWR_MNFCTR_ORG_CMPTR_ASGN

MANUFACTURER RETAILER ITEM ASSIGNMENT

DWR_MNFCTR_RTLR_ITEM_ASGN

MANUFACTURER SKU ITEM

DWR_MNFCTR_SKU_ITEM

MANUFACTURER SKU ITEM BUSINESS UNIT ASSIGNMENT

DWR_MNFCTR_SKU_BSNS_UNIT_ASGN

MANUFACTURER SKU ITEM COLLECTION

DWR_MNFCTR_SKU_ITEM_COLLCTN

MANUFACTURER SKU ITEM SELLING PRICE

DWR_MNFCTR_SKU_ITEM_SLNG_PRICE

MANUFACTURER SKU ITEM SELLING PRICE HISTORY

DWB_MNFCTR_SKU_IM_SLNG_PRC_HST

MANUFACTURER SKU ITEM SHELF ATTRIBUTES

DWR_MNFCTR_SKU_ITEM_SHLF_ATTR

MANUFACTURER SKU ITEM VARIETY ASSIGNMENT

DWR_MNFCTR_SKU_ITEM_VRTY_ASGN

MANUFACTURER STOCK

DWR_MNFCTR_STCK

MANUFACTURER TYPE

DWL_MNFCTR_TYP

MANUFACTURER VARIETY

DWR_MNFCTR_VRTY

MARITAL STATUS

DWL_MRTL_STAT

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_ASGN

MARKET SALES ITEM WEEK

DWB_MKT_SLS_ITEM_LVL_WK

MEDIA

DWR_MEDIA

MEDIA COST

DWB_COST

MEDIA DEPICTION ITEM ASSIGNMENT

DWR_MEDIA_DPCT_ITEM_ASGN

MEDIA TYPE

DWL_MEDIA_TYP

MEMBERSHIP ACCOUNT

DWR_MBRSHIP_ACCT

MEMBERSHIP TYPE

DWL_MBRSHIP_TYP

MICR EQUIPMENT STATISTICS READING

DWB_MICR_EQPMNT_STTSTCS_RDNG

MINUTE

DWR_MNT

MISCELLANEOUS FEE LINE ITEM

DWB_MISCLNS_FEE_LI

MISCELLANEOUS LINE ITEM TYPE

DWL_MISCLNS_LI_TYP

MISSED SCHEDULE

DWB_MISS_SCHL

MIX AND MATCH PRICE DERIVATION ITEM

DWR_MIX_N_MTCH_PRC_DRVTN_ITEM

MIX AND MATCH PRICE DERIVATION RULE

DWR_MIX_N_MTCH_PRC_DRVTN_RULE

MONTH TODATE TRANSFORMATION

DWR_MO_TODATE_TRANS

MONTH TRANSFORMATION

DWR_MO_TRANS

MOTION SENSOR EQUIPMENT STATISTICS READING

DWB_MTN_SNSR_EQPMT_STSTCS_RDNG

MULTIPLE TENDER CLASS

DWL_MLTPL_TNDR_CLASS


Table 4-2 Entity Mapping Logical to Physical: N to Z Entities

Entity Table or View

NATIONALITY

DWL_NTNLTY

NOZZLE

DWR_EQPMNT

NOZZLE HISTORY

DWB_NOZZLE_HIST

OPERATING COST

DWB_COST

OPERATING SYSTEM

DWR_OPERTNG_SYS

ORDER

DWB_ORDR

ORDER CATEGORY TYPE

DWL_ORDR_CTGRY_TYP

ORDER DOCUMENT

DWB_INV_CNTRL_DOC

ORDER LINE ITEM

DWB_ORDR_LI

ORDER LINE ITEM STATE

DWB_ORDR_LI_STATE

ORDER LINE ITEM STATE TYPE

DWL_ORDR_LI_STATE_TYP

ORDER LINE ITEM TYPE

DWL_ORDR_LI_TYP

ORDER SOURCE TYPE

DWL_ORDR_SRC

ORDER STATE

DWL_ORDR_STATE

ORDER STATUS

DWL_ORDR_STAT

ORDER STATUS TYPE

DWL_ORDR_STAT_TYP

ORDER TYPE

DWL_ORDR_TYP

ORG BSNS UNIT SUB REGION ASSIGNMENT

DWR_ORG_BSNS_UNIT_SB_RGN_ASGN

ORGANIZATION

DWR_ORG

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 BUSINESS UNIT HOLIDAY

DWR_ORG_BSNS_UNIT_HOLIDY

ORGANIZATION BUSINESS UNIT HOURS DAY DERIVED

DWD_ORG_BSNS_UNT_HRS_DAY

ORGANIZATION BUSINESS UNIT TRAFFIC

DWB_ORG_BSNS_UNIT_TRFC

ORGANIZATION BUSINESS UNIT TRAFFIC DAY DERIVED

DWD_ORG_BSNS_UNT_TRFC_DAY

ORGANIZATION CATALOG

DWR_ORG_BSNS_UNIT

ORGANIZATION CHAIN

DWR_ORG_CHAIN

ORGANIZATION COMPANY

DWR_ORG_CMPNY

ORGANIZATION COST

DWB_COST

ORGANIZATION DEMOGRAPHY VALUE

DWR_ORG_DEMOG_VAL

ORGANIZATION DEPARTMENT

DWR_ORG_DEPT

ORGANIZATION DISTRIBUTION CENTER

DWR_ORG_BSNS_UNIT

ORGANIZATION DISTRICT

DWR_ORG_DSTRCT

ORGANIZATION DIVISION

DWR_ORG_DIV

ORGANIZATION HIERARCHY

DWR_ORG_HRCHY

ORGANIZATION HIERARCHY LEVEL

DWR_ORG_HRCHY_LVL

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 LEVEL TYPE

DWL_ORG_LVL_TYP

ORGANIZATION MARKET DATA

DWR_ORG_MKT_DATA

ORGANIZATION RECIPE ASSIGNMENT

DWR_ORG_RECIPE_ASGN

ORGANIZATION REGION

DWR_ORG_RGN

ORGANIZATION STORE

DWR_ORG_BSNS_UNIT

ORGANIZATION TYPE

DWL_ORG_TYP

ORGANIZATION WAREHOUSE

DWR_ORG_BSNS_UNIT

ORGANIZATION WEB STORE

DWR_ORG_BSNS_UNIT

OTHER INDIVIDUAL

DWR_OTHR_INDVL

PACKING SLIP

DWB_INV_CNTRL_DOC

PAGE

DWR_PG

PAGE CATEGORY

DWR_PG_CTGRY

PAGE CATEGORY LEVEL

DWR_PG_CTGRY_LVL

PARTY

DWR_PRTY

PARTY ASSIGNMENT

DWR_PRTY_ASGN

PARTY ASSIGNMENT REASON

DWL_PRTY_ASGN_RSN

PARTY ASSIGNMENT TYPE

DWL_PRTY_ASGN_TYP

PARTY CONTACT INFORMATION

DWR_PRTY_CNCT_INFO

PARTY CONTACT INFORMATION TYPE

DWL_PRTY_CNCT_INFO_TYP

PARTY DEMOGRAPHIC GROUP

DWR_PRTY_DEMOG_GRP

PARTY DEMOGRAPHY ATTRIBUTE

DWR_PRTY_DEMOG_ATTR

PARTY DEMOGRAPHY VALUE

DWR_PRTY_DEMOG_VAL

PARTY INTERACTION CALL EVENT

DWB_PRTY_INTRACN_CALL_EVT

PARTY INTERACTION EMAIL EVENT

DWB_PRTY_INTRACN_EML_EVT

PARTY INTERACTION EVENT

Only subtypes are physicalized

PARTY INTERACTION LETTER EVENT

DWB_PRTY_INTRACN_LTTR_EVT

PARTY INTERACTION THREAD

DWB_PRTY_INTRACN_THRD

PARTY INTERACTION THREAD EVENT ASSIGNMENT

DWB_PRTY_INTRACN_THRD_EVT_ASGN

PARTY INTERACTION THREAD STATUS HISTORY

DWB_PRTY_INTRCN_THRD_STAT_HIST

PARTY INTERACTION THREAD TYPE

DWL_PRTY_INTRACN_THRD_TYP

PARTY INTERACTION VISIT EVENT

DWB_PRTY_INTRACN_VST_EVT

PARTY STATUS CATEGORY

DWL_PRTY_STAT_CTGRY

PARTY STATUS CODE

DWL_PRTY_STAT_CD

PARTY STATUS HISTORY

DWB_PRTY_STAT_HIST

PARTY STATUS TYPE

DWL_PRTY_STAT_TYP

PARTY TYPE

DWL_PRTY_TYP

PAY CATEGORY

DWL_PAY_CTGRY

PAY DETAIL

DWB_PAY_DTL

PAY TYPE

DWL_PAY_TYP

PAYABLE INVOICE

DWB_PAYBL_INVC

PAYABLE INVOICE ITEM

DWB_PAYBL_INVC_ITEM

PAYMENT ON ACCOUNT LINE ITEM

DWB_PYMT_ON_ACCT_LI

PENALTY METHOD

DWL_PNLTY_MTHD

PERIOD CLOSE TRANSACTION

DWB_CNTRL_TRX

PERIOD OPEN TRANSACTION

DWB_CNTRL_TRX

PERIOD TODATE TRANSFORMATION

DWR_PERIOD_TODATE_TRANS

PERIOD TRANSFORMATION

DWR_PERIOD_TRANS

PERIOD TYPE

DWL_PRD_TYP

PERSONAL ID REQUIRED TYPE

DWL_PRSNL_ID_REQD_TYP

PHASE

DWR_PHS

PHYSICAL COUNT DOCUMENT

DWB_PHY_CNT_DOC

PHYSICAL COUNT DOCUMENT LINE ITEM

DWB_PHY_CNT_DOC_LI

PHYSICAL COUNT TRANSACTION

DWB_PHY_CNT_DOC

PHYSICAL INVENTORY EVENT

DWB_SCHL_EVT

PINPAD EQUIPMENT STATISTICS READING

DWB_PINPAD_EQPMNT_STTSTCS_RDNG

PLANNING PERIOD

DWR_PLNG_PERIOD

PLANNING QUARTER

DWR_PLNG_QTR

PLANNING SEASON

DWR_PLNG_SEASON

PLANNING SEASON WEEK ASSIGNMENT

DWR_PLNG_SEASON_WK_ASGN

PLANNING WEEK

DWR_PLNG_WK

PLANNING YEAR

DWR_PLNG_YR

PLATFORM

DWR_PLTFRM

POS CONTROL

DWD_POS_CNTRL

POS DEPARTMENT

DWR_POS_DEPT

POS IDENTITY

DWR_POS_IDNT

POS IDENTITY TYPE

DWL_POS_IDNT_TYP

POS KEYBOARD EQUIPMENT STATISTICS READING

DWB_POS_KEYBD_EQPMT_STSTS_RDNG

POS LOCK TRANSACTION

DWB_CNTRL_TRX

POS NO SALE TRANSACTION

DWB_CNTRL_TRX

POS PRINTER EQUIPMENT STATISTICS READING

DWB_POS_PRNTR_EQPMT_STSTS_RDNG

POS RETAIL

DWD_POS_RTL

POS RETAIL EMPLOYEE MONTH AGGR

DWA_POS_RTL_EMP_MO

POS STORE FINANCIAL

DWD_POS_STORE_FINCL

POS TENDER FLOW

DWD_POS_TNDR_FLOW

POS TRANSACTION FLOW

Supertype (no physical table)

POS UNLOCK TRANSACTION

DWB_CNTRL_TRX

POSITION

DWR_POSN

POSITION HIERARCHY

DWR_POSN_HRCHY

POSITION WORK SCHEDULE

DWR_POSN_WRK_SCHL

POST CODE

DWR_POSTCD

POSTAL SERVICE TYPE

DWL_POSTL_SRVC_TYP

PREFERENCE TYPE

DWL_PREF_TYP

PREPARED

Subentity of SKU ITEM (Reference Entity)

PRICE DERIVATION RULE

DWR_PRICE_DRVTN_RULE

PRICE DERIVATION RULE ELIGIBILITY

DWR_PRICE_DRVTN_RULE_ELGBL

PRICE LINE

DWB_PRICE_LN

PRICE LIST

DWL_PRICE_LST

PRICE MODIFICATION LINE ITEM

DWB_PRICE_MODIFICATION_LI

PRICE TYPE

DWL_PRICE_TYP

PRODUCT

DWR_PROD

PRODUCT COST

DWB_COST

PRODUCT ENTITY

DWR_PROD_ENT

PRODUCTION ITEM CONVEYABLE TYPE

DWL_PRODTN_ITEM_CONVBL_TYP

PROFILE INDIVIDUAL

Subentity of CUSTOMER (Reference Entity)

PROFILE ORGANIZATION

Subentity of CUSTOMER (Reference Entity)

PROFILE SOURCE

DWR_PRFL_SRC

PROJECT

DWR_PROJ

PROMOTION

DWR_PRMTN

PROMOTION COST

DWB_COST

PROMOTION HISTORY

DWB_PRMTN_HIST

PROMOTION ITEM

DWR_PRMTN_ITEM

PROMOTION MEDIA COST

DWB_PRMTN_MEDIA_COST

PROMOTION PLAN

DWR_PRMTN_PLN

PROMOTION PRICE DERIVATION

DWR_PRMTN_PRICE_DRVTN

PROMOTION PRODUCT TYPE

DWL_PRMTN_PROD_TYP

PROMOTION PROMOTION TYPE

DWR_PRMTN_PRMTN_TYP

PROMOTION SELLING ITEM

DWR_PRMTN_SLNG_ITEM

PROMOTION TYPE

DWL_PRMTN_TYP

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 DEPARTMENT MONTH AGGR

DWA_PCHSE_ORDR_DEPT_MO

PURCHASE ORDER LINE ITEM

DWB_PCHSE_ORDR_LI

PURCHASE ORDER LINE ITEM DAY AGGR

DWA_PCHSE_ORDR_LI_DAY

PURCHASE ORDER LINE ITEM MONTH AGGR

DWA_PCHSE_ORDR_LI_MO

PURCHASE ORDER LINE ITEM STATE

DWB_PCHSE_ORDR_LI_STATE

PURCHASE ORDER LINE ITEM STATE DERIVED

DWD_PCHSE_ORDR_LI_STATE

PURCHASE ORDER STATE

DWB_PCHSE_ORDR_STATE

PURCHASE ORDER STATE DERIVED

DWD_PCHSE_ORDR_STATE

PURCHASE ORDER SUBCLASS DAY AGGR

DWA_PCHSE_ORDR_SBC_DAY

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_INV_CNTRL_DOC

RECIPE

DWR_RECIPE

RECIPE INGREDIENT ASSIGNMENT

DWR_RECIPE_INGREDIENT_ASGN

REFERRING CATEGORY

DWR_REFERRING_CTGRY

REFERRING CATEGORY LEVEL

DWR_REFERRING_CTGRY_LVL

REFERRING SITE

DWR_REFERRING_SITE

REFERRING URL

DWR_REFERRING_URL

REGION

DWR_RGN

RELATED ITEM ASSOCIATION

DWR_RLTD_ITEM_ASSOCTN

RELATED ITEM ASSOCIATION TYPE

DWL_RLTD_ITEM_ASSOCTN_TYP

RELIGIOUS AFFILIATION

DWL_RELIGIOUS_AFFLTN

RENTAL SERVICE

DWR_RNTL_SRVC

RENTAL UNIT

DWR_RNTL_UNIT

REQUEST FOR DEBIT CREDIT DOCUMENT

DWB_INV_CNTRL_DOC

REQUEST ORIGIN TYPE

DWL_RQST_ORIGIN

REQUISITION DOCUMENT

DWB_INV_CNTRL_DOC

RESERVATION

DWB_RESERVATION

RESTRICTION VALIDATION QUESTION

DWR_RSTRCT_VALID_QUES

RETAIL SALE LINE ITEM AUDIT

DWB_RTL_SL_LI_AUDIT

RETAIL SALE RETURN DEPARTMENT DAY AGGR

DWA_RTL_SL_RETRN_DEPT_DAY

RETAIL SALE RETURN ITEM DAY DERIVED

DWD_RTL_SL_RETRN_ITEM_DAY

RETAIL SALE RETURN LINE ITEM

DWB_RTL_SL_RTRN_LI

RETAIL SALE RETURN SUBCLASS MONTH AGGR

DWA_RTL_SL_RETRN_SBC_MO

RETAIL TENDER HISTORY

DWB_RTL_TNDR_HIST

RETAIL TENDER LINE ITEM

DWB_RTL_TNDR_LI

RETAIL TENDER LINE ITEM AUDIT

DWB_RTL_TNDR_LI_AUDIT

RETAIL TRANSACTION

DWB_RTL_TRX

RETAIL TRANSACTION ASSOCIATE ASSIGNMENT

DWB_RTL_TRX_ASSOCT_ASGN

RETAIL TRANSACTION DELIVERY PREFERENCE

DWR_RTL_TRX_DLVRY_PREF

RETAIL TRANSACTION DELIVERY PREFERENCE ITEM

DWR_RTL_TRX_DLVRY_PREF_ITEM

RETAIL TRANSACTION DISCOUNT LINE ITEM AUDIT

DWB_RTL_TRX_DISC_LI_AUDIT

RETAIL TRANSACTION EMP WORKSTATION DAY DERIVED

DWD_RTL_TRX_EMP_WRKSTN_DAY

RETAIL TRANSACTION LINE ITEM

DWB_RTL_TRX_LI

RETAIL TRANSACTION LINE ITEM ASSIGNMENT

DWB_RTL_TRX_LI_ASGN

RETAIL TRANSACTION LINE ITEM ASSIGNMENT TYPE

DWL_RTL_TRX_LI_ASGN_TYP

RETAIL TRANSACTION LINE ITEM GROUP

DWB_RTL_TRX_LI_GRP

RETAIL TRANSACTION LINE ITEM GROUP TYPE

DWL_RTL_TRX_LI_GRP_TYP

RETAIL TRANSACTION LINE ITEM TYPE

DWL_RTL_TRX_LI_TYP

RETAIL TRANSACTION MISC LINE ITEM

DWB_RTL_TRX_MISC_LI

RETAIL TRANSACTION SHIPMENT

DWB_RTL_TRX_SHPMNT

RETAIL TRANSACTION SHIPMENT ITEM

DWB_RTL_TRX_SHPMNT_ITEM

RETAIL TYPE

DWL_RTL_TYP

RETAIL VALUATION LEDGER ACCOUNT

DWR_GL_ACCT

RETAIL VALUATION LEDGER ACCOUNT HISTORY

DWB_RTL_VALTN_LDGR_ACCT_HIST

RETAILER

DWR_RTLR

RETAILER ASSIGNMENT

DWR_RTLR_ASGN

RETAILER BRAND

DWR_RTLR_BRND

RETAILER CLUSTER

DWR_RTLR_CLSTR

RETAILER CLUSTER ITEM ASSIGNMENT

DWR_RTLR_CLSTR_ITEM_ASGN

RETAILER CLUSTER RETAILER ASSIGNMENT

DWR_RTLR_CLSTR_RTLR_ASGN

RETAILER ORDER

DWB_ORDR

RETAILER ORDER LINE ITEM

DWB_ORDR_LI

RETAILER PAYMENT

DWB_RTLR_PYMT

RETAILER VENDOR ASSIGNED STATUS

DWB_RTLR_VNDR_ASGND_STAT

RETURN AGENT

DWR_VNDR

RETURN AUTHORIZATION REQUEST

DWB_INV_CNTRL_DOC

RETURN DOCUMENT

DWB_INV_CNTRL_DOC

RETURN TO VENDOR DEPARTMENT DAY AGGR

DWA_RTV_DEPT_DAY

RETURN TO VENDOR ITEM DAY DERIVED

DWD_RTV_ITEM_DAY

RETURN TO VENDOR SUBCLASS MONTH AGGR

DWA_RTV_SBC_MO

RETURN TYPE

DWL_RETRN_TYP

REVENUE CENTER

DWR_RVN_CNTR

RFMP METHOD

DWL_RFMP_MTHD

ROLES HIERARCHY

DWR_RL_HRCHY

ROUNDING LINE ITEM

DWB_RNDNG_LI

SAFE TRANSFER TRANSACTION

DWB_TNDR_CNTRL_TRX

SALE OR RETURN ACTION

DWL_SL_OR_RETRN_ACTN

SALE RETURN TAX OVERRIDE MODIFIER

DWB_SL_RETRN_TAX_OVRRD_MDFR

SALE WEIGHT OR UNIT COUNT

DWL_SL_WT_OR_UNIT_CNT

SALES ASSOCIATE ACTION

DWL_SL_ASSOCT_ACTN

SALES FORECAST ITEM ORG HIERARCHY WEEK

DWB_FRCST_ITEM_ORG_HRCHY_WK

SALES METER

DWR_EQPMNT

SALES METER READING

DWB_SL_METER_RDNG

SALES ORDER

DWB_ORDR

SALES ORDER LINE ITEM

DWB_ORDR_LI

SALES PLAN ITEM ORG HIERARCHY WEEK

DWB_SL_PLAN_ITEM_ORG_HRCHY_WK

SALES RESTRICTION

DWR_SLS_RSTRCT

SCALE EQUIPMENT STATISTICS READING

DWB_SCL_EQPMNT_STTSTCS_RDNG

SCANNER EQUIPMENT STATISTICS READING

DWB_SCNR_EQPMNT_STTSTCS_RDNG

SCHEDULE EVENT

DWB_SCHL_EVT

SEARCH

DWR_SEARCH

SEARCH CATEGORY

DWR_SEARCH_CTGRY

SEARCH CATEGORY LEVEL

DWR_SEARCH_CTGRY_LVL

SEASON

DWR_SEASON

SECOND

DWR_SCND

SECURITY CLASS

DWL_SCRTY_CLASS

SECURITY REQUIRED TYPE

DWL_SCRTY_REQD_TYP

SELLING LOCATION

DWR_SLNG_LOC

SELLING LOCATION TYPE

DWL_SLNG_LOC_TYP

SELLING STATUS

DWL_SLNG_STAT

SEND CHECK TENDER LINE ITEM

DWB_RTL_TNDR_LI

SERIALIZED ITEM

DWR_SRLZD_ITEM

SERIALIZED UNIT

DWR_SRLZD_UNIT

SERIALIZED UNIT MODIFIER

DWB_SRLZD_UNIT_MDFR

SERIALIZED UNIT TYPE

DWL_SRLZD_UNIT_TYP

SERVER

DWR_SERVER

SERVER FARM

DWR_SERVER_FARM

SERVER STATUS

DWL_SERVER_STAT

SERVER STATUS HISTORY

DWB_SERVER_STAT_HIST

SERVICE ITEM PROVIDER

DWR_SRVC_ITEM_PRVDR

SERVICE PROVIDER

DWR_VNDR

SERVICE SKU

Subentity of SKU ITEM (Reference Entity)

SERVICE TERM

DWR_SRVC_TERM

SERVICE TYPE

DWL_SRVC_TYP

SESSION

DWB_SESSION

SESSION TYPE

DWL_SESSION_TYP

SHIFT DIFFERENTIAL

DWR_SHFT_DFFRNTL

SHIFT TYPE

DWL_SHFT_TYP

SHIPMENT METHOD

DWL_SHPMNT_MTHD

SHIPMENT PRIORITY

DWL_SHPMNT_PRIORITY

SIGN OFF TRANSACTION

DWB_CNTRL_TRX

SIGN ON TRANSACTION

DWB_CNTRL_TRX

SIGNATURE EQUIPMENT CAPTURE STATISTICS READING

DWB_SGNTR_EQMT_CPTR_STSTS_RDNG

SITE

DWR_SITE

SIZE

DWL_SZ

SIZE TYPE

DWL_SZ_TYP

SKU ITEM

DWR_SKU_ITEM

SKU ITEM BUSINESS UNIT INVENTORY RULES

DWR_SKU_ITEM_BU_INV_RULE

SKU ITEM BUSINESS UNIT SELLING PRICE

DWB_SKU_ITEM_BU_SLNG_PRC

SKU ITEM CHOICE

DWR_SKU_ITEM_CHOICE

SKU ITEM COLLECTION

DWR_SKU_ITEM_COLLCTN

SKU ITEM CONSTRUCTION

DWR_SKU_ITEM_CONSTRCTN

SKU ITEM RECIPE ASSIGNMENT

DWR_SKU_ITEM_RECIPE_ASGN

SKU ITEM SELLING PRICE

DWB_SKU_ITEM_SLNG_PRICE

SKU ITEM SELLING PRICE HISTORY

DWB_SKU_ITEM_SLNG_PRICE_HIST

SKU ITEM SHELF ATTRIBUTES

DWR_SKU_ITEM_SHLF_ATTR

SKU ITEM STYLE

DWL_SKU_ITEM_STYLE

SKU ITEM SUBSTITUTION

DWR_SKU_ITEM_SBSTTN

SKU ITEM TYPE

DWL_SKU_ITEM_TYP

SKU ITEM VARIETY ASSIGNMENT

DWR_SKU_ITEM_VRTY_ASGN

SKU ITEM WEIGHT

DWR_SKU_ITEM_WT

SOC JOB

DWR_SOC_JB

SOC JOB CATEGORY

DWR_SOC_JB_CTGRY

SOC JOB GROUP

DWR_SOC_JB_GRP

SOC JOB MAJOR GROUP

DWR_SOC_JB_MJR_GRP

SPACE UTILIZATION DEPARTMENT DAY AGGR

DWA_SPACE_UTLZTN_DEPT_DAY

SPACE UTILIZATION ITEM DAY DERIVED

DWD_SPACE_UTLZTN_ITEM_DAY

STATUS

DWL_STAT

STATUS REASON

DWL_STAT_RSN

STATUS TYPE

DWL_STAT_TYP

STOCK

Subentity of SKU ITEM (Reference Entity)

STOCK ITEM CONSUMER PRODUCT LABEL

DWR_STCK_ITEM_CONSMR_PROD_LBL

STOCK ITEM TYPE

DWL_STCK_ITEM_TYP

STOCK LEDGER ACCOUNT HISTORY

DWB_STCK_LDGR_ACCT_HIST

STOCK LEDGER JOURNAL ENTRY

DWB_STCK_LDGR_JRNL_ENTRY

STOCK METER

DWR_EQPMNT

STOCK METER READING

DWB_STCK_METER_RDNG

STORE FINANCIAL LEDGER ACCOUNT

DWR_STORE_FIN_LEDG_ACCT

STORE SAFE

DWR_STORE_SAFE

STORE SAFE SETTLEMENT TRANSACTION

DWB_CNTRL_TRX

STORE WORKSTATION

Subentity of TOUCHPOINT (Reference Entity)

SUB BRAND

DWR_SB_BRND

SUB REGION

DWR_SB_RGN

SUBSCRIPTION

DWR_SBRP

SURVEY

DWR_SURVEY

SURVEY COST

DWB_COST

SURVEY QUESTION

DWR_SURVEY_QUES

SURVEY QUESTION OPTION

DWR_SURVEY_QUES_OPTION

SURVEY RESPONSE DETAIL

DWB_SURVEY_RESPN_DTL

SURVEY RESPONSE HEADER

DWB_SURVEY_RESPN_HDR

TANK

DWR_EQPMNT

TANK LEVEL GAUGE

DWR_EQPMNT

TANK PROBE

DWR_EQPMNT

TANK READING

DWB_TANK_RDNG

TANK TEMPERATURE READING

DWB_TANK_TEMP_RDNG

TANK TEMPERATURE SENSOR

DWR_EQPMNT

TARE

DWR_TARE

TARGET

Subentity of CAMPAIGN MESSAGE RENDERING (Reference Entity)

TASK

DWR_TASK

TASK PREREQUISITE

DWR_TASK_PREREQUISITE

TASK SET

DWR_TASK_SET

TAX AUTHORITY

DWR_TAX_AUTH

TAX EXEMPTION

DWR_TAX_EXMPTN

TAX GROUP RULE

DWR_TAX_GRP_RULE

TAX LEVEL TYPE

DWL_TAX_LVL_TYP

TAX LINE ITEM

DWB_TAX_LI

TAX LINE ITEM AUDIT

DWB_TAX_LI_AUDIT

TAX RATE CLASS

DWL_TAX_RATE_CLASS

TAX RATE RULE

DWR_TAX_RATE_RULE

TAX RESULT TYPE

DWL_TAX_RSLT_TYP

TAX THRESHOLD TYPE

DWL_TAX_THRSHLD_TYP

TAX TYPE

DWL_TAX_TYP

TAXABLE GROUP

DWR_TAXBL_GRP

TENDER

DWR_TNDR

TENDER ACCOUNT APPROVAL REFERENCE

DWR_TNDR_ACCT_APRVL_REF

TENDER ADJUSTMENT TRANSACTION

DWB_TNDR_CNTRL_TRX

TENDER AUTHORIZATION

DWB_TNDR_ATHRZTN

TENDER AUTHORIZATION REVERSAL

DWB_TNDR_ATHRZTN_REVERSAL

TENDER AUTHORIZATION TERMINAL

DWR_TNDR_ATHRZTN_TRML

TENDER AUTHORIZATION TERMINAL SOFTWARE VERSION

DWR_TNDR_ATHRZN_TRML_SFTWR_VSN

TENDER CLASS

DWL_TNDR_CLASS

TENDER CONTROL TRANSACTION

DWB_TNDR_CNTRL_TRX

TENDER CONTROL TRANSACTION TENDER LINE ITEM

DWB_TNDR_CNTRL_TRX_TNDR_LI

TENDER CONTROL TYPE

DWL_TNDR_CNTRL_TRX_TYP

TENDER DEPOSIT TRANSACTION

DWB_TNDR_CNTRL_TRX

TENDER EXCHANGE TRANSACTION

DWB_TNDR_CNTRL_TRX

TENDER LINE ITEM DENOMINATION

DWB_TNDR_LI_DENMTN

TENDER LOAN TRANSACTION

DWB_TNDR_CNTRL_TRX

TENDER PICKUP TRANSACTION

DWB_TNDR_CNTRL_TRX

TENDER REPOSITORY

DWR_TNDR_RPSTRY

TENDER REPOSITORY CLASS

DWL_TNDR_RPSTRY_CLASS

TENDER REPOSITORY TENDER ACCOUNT

DWR_TNDR_RPSTRY_TNDR_ACCT

TERM CODE

DWR_TERM_CD

TERMS MASTER

DWB_TRMS_MASTER

TEST DELIVERY

DWB_FORECOURT_TRX

THEFT TYPE

DWL_THEFT_TYP

TILL DERIVED

DWD_TILL

TILL HISTORY

DWB_TILL_HIST

TILL LIMIT EXCEEDED TRANSACTION

DWB_CNTRL_TRX

TILL LIMIT RULE

DWR_TILL_LMT_RULE

TILL LIMIT TYPE

DWL_TILL_LMT_TYP

TILL MOVEMENT DIRECTION

DWL_TILL_MOVEMENT_DRCTN

TILL MOVEMENT TRANSACTION

DWB_CNTRL_TRX

TILL OPERATOR ASSIGNMENT TRANSACTION

DWB_CNTRL_TRX

TILL TAX HISTORY

DWB_TILL_TAX_HIST

TILL TENDER HISTORY

DWB_TILL_TNDR_HIST

TILL TENDER LIMIT RULE ASSIGNMENT

DWR_TILL_TNDR_LMT_RULE_ASGN

TILL WORKSTATION ASSIGNMENT

DWR_TILL_WRKSTN_ASGN

TIME PLANNING SEASON TODATE BY WEEK

DWR_TIME_PLNG_SEASON_TD_BY_WK

TIME PUNCH APPROVAL

DWB_TIME_PUNCH_APRVL

TIME PUNCH CORRECTION

DWB_TIME_PUNCH_CORRECTION

TIME PUNCH TRANSACTION

DWB_CNTRL_TRX

TIME STANDARD BY DAY

DWR_TIME_STNDRD_BY_DAY

TIME STANDARD BY WEEK

DWR_TIME_STNDRD_BY_WK

TIME ZONE

DWR_TIME_ZN

TIP OUT TRANSACTION

DWB_TNDR_CNTRL_TRX

TONE INDICATOR EQUIPMENT STATISTICS READING

DWB_TONE_IND_EQPMT_STSTCS_RDNG

TOTAL TIME

DWR_TOT_TIME

TOTAL TYPE

DWL_TOT_TYP

TOUCHPOINT

DWR_TCHPNT

TRADE AREA

DWR_TRD_AREA

TRADE AREA COVERAGE

DWR_TRD_AREA_COVRG

TRADE IN TENDER

DWB_RTL_TNDR_LI

TRANSACTION ASSIGNMENT

DWB_TRX_ASGN

TRANSACTION ASSIGNMENT TYPE

DWL_TRX_ASGN_TYP

TRANSACTION CATEGORY

DWL_TRX_CTGRY

TRANSACTION TYPE

DWL_TRX_TYP

TRANSFER IN DOCUMENT

DWB_INV_CNTRL_DOC

TRANSFER OUT DOCUMENT

DWB_INV_CNTRL_DOC

TRANSFER TYPE

DWL_TRNSFR_TYP

UNIT OF MEASURE

DWL_UOM

UNIT OF MEASURE CONFIGURATION

DWC_UOM_CONF

UNIT OF MEASURE CONVERSION

DWR_UOM_CONVRSN

UNIT OF MEASURE TYPE

DWL_UOM_TYP

UNLOCK TRANSACTION

Not physicalized

USER

DWR_USER

VALIDATION QUESTION ASSIGNMENT

DWR_VALID_QUES_ASGN

VALUE MEASURE

DWR_VAL_MSR

VALUE TYPE

DWL_VAL_TYP

VARIETY

DWR_VRTY

VARIETY TYPE

DWL_VRTY_TYP

VENDOR

DWR_VNDR

VENDOR APPOINTMENT

DWR_VNDR_APNMNT

VENDOR CARRIER ASSIGNMENT

DWR_VNDR_CARRIER_ASGN

VENDOR CLASS

DWL_VNDR_CLASS

VENDOR COMPLIANCE ITEM DAY DERIVED

DWD_VNDR_CMPLNC_ITEM_DAY

VENDOR CONTRACT

DWR_VNDR_CNRT

VENDOR COST

DWB_COST

VENDOR FACTOR COMPANY ASSIGNMENT

DWR_VNDR_FCTR_CMPNY_ASGN

VENDOR ITEM

DWR_VNDR_ITEM

VENDOR ITEM BUSINESS UNIT ASSIGNMENT

DWR_VNDR_ITEM_BSNS_UNIT_ASGN

VENDOR ITEM CATALOG BASE COST

DWB_VNDR_ITEM_CTLG_BASE_COST

VENDOR ITEM CATALOG BASE COST BREAK

DWB_VDR_ITM_CTLG_BASE_COST_BRK

VENDOR ITEM COST PER UNIT TYPE

DWL_VNDR_ITEM_CPU_TYP

VENDOR ITEM SKU ASSIGNMENT

DWR_VNDR_ITEM_SKU_ASGN

VENDOR MANUFACTURER BRAND

DWR_VNDR_MNFCTR_BRND

VENDOR QUICK FACTS

Subentity of VENDOR ITEM (Reference Entity)

VENDOR RATING

DWB_VNDR_RTNG

VENDOR RATING TYPE

DWL_VNDR_RTNG_TYP

VENDOR SITE

DWR_VNDR_SITE

VENDOR SITE ADDRESS

DWR_VNDR_SITE_ADDR

VENDOR SITE CARRIER ASSIGNMENT

DWR_VNDR_SITE_CARRIER_ASGN

VENDOR SKU BUSINESS UNIT ASSIGNMENT

DWR_VNDR_SKU_BSNS_UNIT_ASGN

VENDOR SKU COST PROFIT DAY

DWB_VNDR_SKU_COST_DAY

VENDOR STATUS

DWB_VNDR_STAT

VISITOR

DWR_VISITOR

VISITOR TYPE

DWL_VISITOR_TYP

VOID TRANSACTION

DWB_CNTRL_TRX

VOIDS LINE ITEM

DWB_VOID_LI

WARRANTY TYPE

DWL_WRNTY_TYP

WEAVE

DWL_WEAVE

WEBSITE RESOURCE

DWR_WBSITE_RESRE

WEBSITE RESOURCE TYPE

DWL_WBSITE_RESRE_TYP

WEBSITE USER

DWR_WBSITE_USER

WEEK TODATE TRANSFORMATION

DWR_WK_TODATE_TRANS

WEEK TRANSFORMATION

DWR_WK_TRANS

WEEKDAY

DWR_WKDAY

WF CUSTOMER

DWR_CUST

WF CUSTOMER TYPE

DWL_WF_CUST_TYP

WORK HOUR TYPE

DWL_WRK_HR_TYP

WORK LOCATION

DWR_WRK_LOC

WORKSTATION DISPLAY

DWR_WRKSTN_DISP

WORKSTATION GROUP

DWR_WRKSTN_GRP

WORKSTATION LOCATION ASSIGNMENT

DWR_WRKSTN_LOC_ASGN

WORKSTATION LOCATION TYPE

DWL_WRKSTN_LOC_TYP

WORKSTATION PERIOD END TRANSACTION

DWB_CNTRL_TRX

WORKSTATION PERIOD START TRANSACTION

DWB_CNTRL_TRX

YEAR TRANSFORMATION

DWR_YR_TRANS