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 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 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 |
|
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 |
|
EXTERNAL DEPOSITORY TENDER HISTORY |
DWB_EXTRNL_DEPOS_TNDR_HIST |
|
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 |
|
IMPRESSION TYPE |
DWL_IMPRESSION_EVT_TYP |
|
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 INVENTORY EVENT |
DWB_SCHL_EVT |
|
PINPAD EQUIPMENT STATISTICS READING |
DWB_PINPAD_EQPMNT_STTSTCS_RDNG |
|
PLAN TYPE |
DWL_PLAN_TYP |
|
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 DERIVED |
DWD_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 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 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 |
|
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 |
|
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 IN OUT 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 |