DDD Sales
Entity Relationship Diagram
|
Tip: |
Right click the attachment to view Entity Relationship Diagram for DDD Sales in a new tab. |
List of Objects
| DB Object Name | Object Business Name | Object Description | DB Attribute Name | Attribute Business Name | Ordinal Position | Data Type Name | Data Type Size | Numeric Scale | Is Identity | Is Nullable | Primary Key | Mandatory |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| DDD_WKLY_SLS_FACT_C | DDD Weekly Sales Fact | DDD Weekly Sales Fact | OTLT_SYS_KEY_C | OTLT SYS KEY C | 1 | VARCHAR | 16777216 | NO | NO | FALSE | TRUE | |
| DDD_WKLY_SLS_FACT_C | DDD Weekly Sales Fact | DDD Weekly Sales Fact | PRD_DT_SYS_KEY_C | PRD DT SYS KEY C | 2 | VARCHAR | 16777216 | NO | NO | FALSE | TRUE | |
| DDD_WKLY_SLS_FACT_C | DDD Weekly Sales Fact | DDD Weekly Sales Fact | PSET_MKT_SYS_KEY_C | PSET MKT SYS KEY C | 3 | VARCHAR | 16777216 | NO | NO | FALSE | TRUE | |
| DDD_WKLY_SLS_FACT_C | DDD Weekly Sales Fact | DDD Weekly Sales Fact | PSET_GRP_SYS_KEY_C | PSET GRP SYS KEY C | 4 | VARCHAR | 16777216 | NO | NO | FALSE | TRUE | |
| DDD_WKLY_SLS_FACT_C | DDD Weekly Sales Fact | DDD Weekly Sales Fact | PSET_SYS_KEY_C | PSET SYS KEY C | 5 | VARCHAR | 16777216 | NO | NO | FALSE | TRUE | |
| DDD_WKLY_SLS_FACT_C | DDD Weekly Sales Fact | DDD Weekly Sales Fact | DDD_CHNL_CD_C | DDD CHNL CD C | 6 | VARCHAR | 20 | NO | YES | FALSE | FALSE | |
| DDD_WKLY_SLS_FACT_C | DDD Weekly Sales Fact | DDD Weekly Sales Fact | DDD_SUBCAT_CD_C | DDD SUBCAT CD C | 7 | VARCHAR | 20 | NO | YES | FALSE | FALSE | |
| DDD_WKLY_SLS_FACT_C | DDD Weekly Sales Fact | DDD Weekly Sales Fact | SRC_OTLT_KEY_C | SRC OTLT KEY C | 8 | VARCHAR | 50 | NO | YES | FALSE | FALSE | |
| DDD_WKLY_SLS_FACT_C | DDD Weekly Sales Fact | DDD Weekly Sales Fact | SRC_PRD_KEY_C | SRC PRD KEY C | 9 | VARCHAR | 20 | NO | YES | FALSE | FALSE | |
| DDD_WKLY_SLS_FACT_C | DDD Weekly Sales Fact | DDD Weekly Sales Fact | SRC_PGN_KEY_C | SRC PGN KEY C | 10 | VARCHAR | 20 | NO | YES | FALSE | FALSE | |
| DDD_WKLY_SLS_FACT_C | DDD Weekly Sales Fact | DDD Weekly Sales Fact | SRC_PERIOD_KEY_C | SRC PERIOD KEY C | 11 | VARCHAR | 20 | NO | YES | FALSE | FALSE | |
| DDD_WKLY_SLS_FACT_C | DDD Weekly Sales Fact | DDD Weekly Sales Fact | SRC_MKT_KEY_C | SRC MKT KEY C | 12 | VARCHAR | 20 | NO | YES | FALSE | FALSE | |
| DDD_WKLY_SLS_FACT_C | DDD Weekly Sales Fact | DDD Weekly Sales Fact | UNITS_QTY_VAL_C | UNITS QTY VAL C | 13 | NUMERIC | 18 | 3 | NO | YES | FALSE | FALSE |
| DDD_WKLY_SLS_FACT_C | DDD Weekly Sales Fact | DDD Weekly Sales Fact | DOLLAR_AMT_VAL_C | DOLLAR AMT VAL C | 14 | NUMERIC | 18 | 3 | NO | YES | FALSE | FALSE |
| DDD_WKLY_SLS_FACT_C | DDD Weekly Sales Fact | DDD Weekly Sales Fact | FACTR_QTY_VAL_C | FACTR QTY VAL C | 15 | NUMERIC | 18 | 3 | NO | YES | FALSE | FALSE |
| DMD_WKLY_SLS_FACT_C | DMD Weekly Sales Fact | DMD Weekly Sales Fact | OTLT_SYS_KEY_C | OTLT SYS KEY C | 1 | VARCHAR | 16777216 | NO | NO | FALSE | TRUE | |
| DMD_WKLY_SLS_FACT_C | DMD Weekly Sales Fact | DMD Weekly Sales Fact | HCO_SYS_KEY_C | HCO SYS KEY C | 2 | VARCHAR | 16777216 | NO | NO | FALSE | TRUE | |
| DMD_WKLY_SLS_FACT_C | DMD Weekly Sales Fact | DMD Weekly Sales Fact | RXER_SYS_KEY_C | RXER SYS KEY C | 3 | VARCHAR | 16777216 | NO | NO | FALSE | TRUE | |
| DMD_WKLY_SLS_FACT_C | DMD Weekly Sales Fact | DMD Weekly Sales Fact | PRD_DT_SYS_KEY_C | PRD DT SYS KEY C | 4 | VARCHAR | 16777216 | NO | NO | FALSE | TRUE | |
| DMD_WKLY_SLS_FACT_C | DMD Weekly Sales Fact | DMD Weekly Sales Fact | PSET_MKT_SYS_KEY_C | PSET MKT SYS KEY C | 5 | VARCHAR | 16777216 | NO | NO | FALSE | TRUE | |
| DMD_WKLY_SLS_FACT_C | DMD Weekly Sales Fact | DMD Weekly Sales Fact | PSET_GRP_SYS_KEY_C | PSET GRP SYS KEY C | 6 | VARCHAR | 16777216 | NO | NO | FALSE | TRUE | |
| DMD_WKLY_SLS_FACT_C | DMD Weekly Sales Fact | DMD Weekly Sales Fact | PSET_SYS_KEY_C | PSET SYS KEY C | 7 | VARCHAR | 16777216 | NO | NO | FALSE | TRUE | |
| DMD_WKLY_SLS_FACT_C | DMD Weekly Sales Fact | DMD Weekly Sales Fact | DDD_CHNL_CD_C | DDD CHNL CD C | 8 | VARCHAR | 16777216 | NO | YES | FALSE | FALSE | |
| DMD_WKLY_SLS_FACT_C | DMD Weekly Sales Fact | DMD Weekly Sales Fact | DDD_SUBCAT_CD_C | DDD SUBCAT CD C | 9 | VARCHAR | 16777216 | NO | YES | FALSE | FALSE | |
| DMD_WKLY_SLS_FACT_C | DMD Weekly Sales Fact | DMD Weekly Sales Fact | SRC_OTLT_KEY_C | SRC OTLT KEY C | 10 | VARCHAR | 16777216 | NO | YES | FALSE | FALSE | |
| DMD_WKLY_SLS_FACT_C | DMD Weekly Sales Fact | DMD Weekly Sales Fact | SRC_RXER_KEY_C | SRC RXER KEY C | 11 | VARCHAR | 16777216 | NO | YES | FALSE | FALSE | |
| DMD_WKLY_SLS_FACT_C | DMD Weekly Sales Fact | DMD Weekly Sales Fact | SRC_HCO_KEY_C | SRC HCO KEY C | 12 | VARCHAR | 16777216 | NO | YES | FALSE | FALSE | |
| DMD_WKLY_SLS_FACT_C | DMD Weekly Sales Fact | DMD Weekly Sales Fact | SRC_PRD_KEY_C | SRC PRD KEY C | 13 | VARCHAR | 16777216 | NO | YES | FALSE | FALSE | |
| DMD_WKLY_SLS_FACT_C | DMD Weekly Sales Fact | DMD Weekly Sales Fact | SRC_PGN_KEY_C | SRC PGN KEY C | 14 | VARCHAR | 16777216 | NO | YES | FALSE | FALSE | |
| DMD_WKLY_SLS_FACT_C | DMD Weekly Sales Fact | DMD Weekly Sales Fact | SRC_PERIOD_KEY_C | SRC PERIOD KEY C | 15 | VARCHAR | 16777216 | NO | YES | FALSE | FALSE | |
| DMD_WKLY_SLS_FACT_C | DMD Weekly Sales Fact | DMD Weekly Sales Fact | SRC_MKT_KEY_C | SRC MKT KEY C | 16 | VARCHAR | 16777216 | NO | YES | FALSE | FALSE | |
| DMD_WKLY_SLS_FACT_C | DMD Weekly Sales Fact | DMD Weekly Sales Fact | UNITS_QTY_VAL_C | UNITS QTY VAL C | 17 | NUMERIC | 38 | 0 | NO | YES | FALSE | FALSE |
| DMD_WKLY_SLS_FACT_C | DMD Weekly Sales Fact | DMD Weekly Sales Fact | DOLLAR_AMT_VAL_C | DOLLAR AMT VAL C | 18 | NUMERIC | 38 | 0 | NO | YES | FALSE | FALSE |
| DMD_WKLY_SLS_FACT_C | DMD Weekly Sales Fact | DMD Weekly Sales Fact | FACTR_QTY_VAL_C | FACTR QTY VAL C | 19 | NUMERIC | 38 | 0 | NO | YES | FALSE | FALSE |