Ex-US Subnational
Entity Relationship Diagram
|
Tip: |
Right click the attachment to view Entity Relationship Diagram for Ex-US Subnational 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| EXUS_SUBNATL_SLS_FACT_C | Ex Us Subnational Sales Fact | Ex Us Subnational Sales Fact | BP_SYS_KEY_C | BP SYS KEY C | 1 | VARCHAR | 16777216 | NO | YES | FALSE | FALSE | |
| EXUS_SUBNATL_SLS_FACT_C | Ex Us Subnational Sales Fact | Ex Us Subnational Sales Fact | PRD_DT_SYS_KEY_C | PRD DT SYS KEY C | 2 | VARCHAR | 16777216 | NO | NO | FALSE | TRUE | |
| EXUS_SUBNATL_SLS_FACT_C | Ex Us Subnational Sales Fact | Ex Us Subnational Sales Fact | GORG_SYS_KEY_C | GORG SYS KEY C | 3 | VARCHAR | 16777216 | NO | NO | FALSE | TRUE | |
| EXUS_SUBNATL_SLS_FACT_C | Ex Us Subnational Sales Fact | Ex Us Subnational Sales Fact | PSET_SYS_KEY_C | PSET SYS KEY C | 4 | VARCHAR | 16777216 | NO | NO | FALSE | TRUE | |
| EXUS_SUBNATL_SLS_FACT_C | Ex Us Subnational Sales Fact | Ex Us Subnational Sales Fact | SPCL_CD_C | SPCL CD C | 5 | VARCHAR | 20 | NO | NO | FALSE | TRUE | |
| EXUS_SUBNATL_SLS_FACT_C | Ex Us Subnational Sales Fact | Ex Us Subnational Sales Fact | SLS_CHNL_CD_C | SLS CHNL CD C | 6 | VARCHAR | 20 | NO | NO | FALSE | TRUE | |
| EXUS_SUBNATL_SLS_FACT_C | Ex Us Subnational Sales Fact | Ex Us Subnational Sales Fact | IN_OUT_CD_C | IN OUT CD C | 7 | VARCHAR | 20 | NO | NO | FALSE | TRUE | |
| EXUS_SUBNATL_SLS_FACT_C | Ex Us Subnational Sales Fact | Ex Us Subnational Sales Fact | WARD_CD_C | WARD CD C | 8 | VARCHAR | 20 | NO | NO | FALSE | TRUE | |
| EXUS_SUBNATL_SLS_FACT_C | Ex Us Subnational Sales Fact | Ex Us Subnational Sales Fact | CTRY_CD_C | CTRY CD C | 9 | VARCHAR | 20 | NO | NO | FALSE | TRUE | |
| EXUS_SUBNATL_SLS_FACT_C | Ex Us Subnational Sales Fact | Ex Us Subnational Sales Fact | SRC_SYS_CD_C | SRC SYS CD C | 10 | VARCHAR | 20 | NO | NO | FALSE | TRUE | |
| EXUS_SUBNATL_SLS_FACT_C | Ex Us Subnational Sales Fact | Ex Us Subnational Sales Fact | CURR_ISO_CD_C | CURR ISO CD C | 11 | VARCHAR | 20 | NO | YES | FALSE | FALSE | |
| EXUS_SUBNATL_SLS_FACT_C | Ex Us Subnational Sales Fact | Ex Us Subnational Sales Fact | SRC_PRD_KEY_C | SRC PRD KEY C | 12 | VARCHAR | 20 | NO | YES | FALSE | FALSE | |
| EXUS_SUBNATL_SLS_FACT_C | Ex Us Subnational Sales Fact | Ex Us Subnational Sales Fact | SRC_BP_KEY_C | SRC BP KEY C | 13 | VARCHAR | 20 | NO | YES | FALSE | FALSE | |
| EXUS_SUBNATL_SLS_FACT_C | Ex Us Subnational Sales Fact | Ex Us Subnational Sales Fact | SRC_PERIOD_KEY_C | SRC PERIOD KEY C | 14 | VARCHAR | 20 | NO | YES | FALSE | FALSE | |
| EXUS_SUBNATL_SLS_FACT_C | Ex Us Subnational Sales Fact | Ex Us Subnational Sales Fact | SRC_GORG_KEY_C | SRC GORG KEY C | 15 | VARCHAR | 20 | NO | YES | FALSE | FALSE | |
| EXUS_SUBNATL_SLS_FACT_C | Ex Us Subnational Sales Fact | Ex Us Subnational Sales Fact | LCL_EXMFR_AMT_C | LCL EXMFR AMT C | 16 | NUMERIC | 18 | 3 | NO | YES | FALSE | FALSE |
| EXUS_SUBNATL_SLS_FACT_C | Ex Us Subnational Sales Fact | Ex Us Subnational Sales Fact | LCL_PHARMY_AMT_C | LCL PHARMY AMT C | 17 | NUMERIC | 18 | 3 | NO | YES | FALSE | FALSE |
| EXUS_SUBNATL_SLS_FACT_C | Ex Us Subnational Sales Fact | Ex Us Subnational Sales Fact | LCL_TRADE_AMT_C | LCL TRADE AMT C | 18 | NUMERIC | 18 | 3 | NO | YES | FALSE | FALSE |
| EXUS_SUBNATL_SLS_FACT_C | Ex Us Subnational Sales Fact | Ex Us Subnational Sales Fact | CU_AMT_C | CU AMT C | 19 | NUMERIC | 18 | 3 | NO | YES | FALSE | FALSE |
| EXUS_SUBNATL_SLS_FACT_C | Ex Us Subnational Sales Fact | Ex Us Subnational Sales Fact | PACK_UNITS_AMT_C | PACK UNITS AMT C | 20 | NUMERIC | 18 | 3 | NO | YES | FALSE | FALSE |
| EXUS_SUBNATL_SLS_FACT_C | Ex Us Subnational Sales Fact | Ex Us Subnational Sales Fact | DDD_UNITS_AMT_C | DDD UNITS AMT C | 21 | NUMERIC | 18 | 3 | NO | YES | FALSE | FALSE |
| EXUS_SUBNATL_SLS_FACT_C | Ex Us Subnational Sales Fact | Ex Us Subnational Sales Fact | LCL_WHSE_AMT_C | LCL WHSE AMT C | 22 | NUMERIC | 18 | 3 | NO | YES | FALSE | FALSE |
| EXUS_SUBNATL_SLS_FACT_C | Ex Us Subnational Sales Fact | Ex Us Subnational Sales Fact | SALES_VALUE_AMT_C | SALES VALUE AMT C | 23 | NUMERIC | 18 | 3 | NO | YES | FALSE | FALSE |
| EXUS_SUBNATL_SLS_FACT_C | Ex Us Subnational Sales Fact | Ex Us Subnational Sales Fact | INDV_UNITS_AMT_C | INDV UNITS AMT C | 24 | NUMERIC | 18 | 3 | NO | YES | FALSE | FALSE |