Oracle® Retail Data Model Reference Release 11.3.1 Part Number E20361-01 |
|
|
PDF · Mobi · ePub |
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 |
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 |