Country & Currency
Entity Relationship Diagram
|
Tip: |
Right click the attachment to view Entity Relationship Diagram for Country & Currency 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| CNTRY_CURR_REF_C | Country Currency Reference | Country Currency Reference | CTRY_CD_C | CTRY CD C | 1 | VARCHAR | 20 | NO | NO | TRUE | TRUE | |
| CNTRY_CURR_REF_C | Country Currency Reference | Country Currency Reference | CURR_ISO_CD_C | CURR ISO CD C | 2 | VARCHAR | 3 | NO | NO | TRUE | TRUE | |
| CNTRY_CURR_REF_C | Country Currency Reference | Country Currency Reference | CURR_NM_C | CURR NM C | 3 | VARCHAR | 100 | NO | YES | FALSE | FALSE | |
| CNTRY_CURR_REF_C | Country Currency Reference | Country Currency Reference | PRIM_CURR_IND_C | PRIM CURR IND C | 4 | VARCHAR | 1 | NO | YES | FALSE | FALSE | |
| CNTRY_CURR_REF_C | Country Currency Reference | Country Currency Reference | SYS_CRT_DTT_C | SYS CRT DTT C | 5 | DATE | NO | YES | FALSE | FALSE | ||
| CNTRY_CURR_REF_C | Country Currency Reference | Country Currency Reference | SYS_CRT_BY_C | SYS CRT BY C | 6 | VARCHAR | 255 | NO | YES | FALSE | FALSE | |
| CNTRY_CURR_REF_C | Country Currency Reference | Country Currency Reference | SYS_EFF_DTT_C | SYS EFF DTT C | 7 | DATE | NO | YES | FALSE | FALSE | ||
| CNTRY_CURR_REF_C | Country Currency Reference | Country Currency Reference | SYS_UPDT_DTT_C | SYS UPDT DTT C | 8 | DATE | NO | YES | FALSE | FALSE | ||
| CNTRY_CURR_REF_C | Country Currency Reference | Country Currency Reference | SYS_UPDT_BY_C | SYS UPDT BY C | 9 | VARCHAR | 255 | NO | YES | FALSE | FALSE | |
| CNTRY_CURR_REF_C | Country Currency Reference | Country Currency Reference | SYS_END_DTT_C | SYS END DTT C | 10 | DATE | NO | YES | FALSE | FALSE | ||
| CTRY_HIER_C | Country Hierarchy | Country Hierarchy | CTRY_HIER_SYS_KEY_C | CTRY HIER SYS KEY C | 1 | VARCHAR | 20 | NO | NO | FALSE | TRUE | |
| CTRY_HIER_C | Country Hierarchy | Country Hierarchy | PRNT_CTRY_CD_C | PRNT CTRY CD C | 2 | VARCHAR | 20 | NO | NO | FALSE | TRUE | |
| CTRY_HIER_C | Country Hierarchy | Country Hierarchy | PRNT_CTRY_TYPE_CD_C | PRNT CTRY TYPE CD C | 3 | VARCHAR | 20 | NO | YES | FALSE | FALSE | |
| CTRY_HIER_C | Country Hierarchy | Country Hierarchy | CHLD_CTRY_CD_C | CHLD CTRY CD C | 4 | VARCHAR | 20 | NO | NO | FALSE | TRUE | |
| CTRY_HIER_C | Country Hierarchy | Country Hierarchy | CHLD_CTRY_TYPE_CD_C | CHLD CTRY TYPE CD C | 5 | VARCHAR | 20 | NO | YES | FALSE | FALSE | |
| CTRY_HIER_C | Country Hierarchy | Country Hierarchy | SYS_CRT_DTT_C | SYS CRT DTT C | 6 | DATE | NO | YES | FALSE | FALSE | ||
| CTRY_HIER_C | Country Hierarchy | Country Hierarchy | SYS_CRT_BY_C | SYS CRT BY C | 7 | VARCHAR | 255 | NO | YES | FALSE | FALSE | |
| CTRY_HIER_C | Country Hierarchy | Country Hierarchy | SYS_EFF_DTT_C | SYS EFF DTT C | 8 | DATE | NO | YES | FALSE | FALSE | ||
| CTRY_HIER_C | Country Hierarchy | Country Hierarchy | SYS_UPDT_DTT_C | SYS UPDT DTT C | 9 | DATE | NO | YES | FALSE | FALSE | ||
| CTRY_HIER_C | Country Hierarchy | Country Hierarchy | SYS_UPDT_BY_C | SYS UPDT BY C | 10 | VARCHAR | 255 | NO | YES | FALSE | FALSE | |
| CTRY_HIER_C | Country Hierarchy | Country Hierarchy | SYS_END_DTT_C | SYS END DTT C | 11 | DATE | NO | YES | FALSE | FALSE | ||
| CTRY_REF_C | Country Reference | Country Reference | CTRY_CD_C | CTRY CD C | 1 | VARCHAR | 20 | NO | NO | TRUE | TRUE | |
| CTRY_REF_C | Country Reference | Country Reference | CTRY_TYPE_CD_C | CTRY TYPE CD C | 2 | VARCHAR | 20 | NO | YES | FALSE | FALSE | |
| CTRY_REF_C | Country Reference | Country Reference | CTRY_NM_C | CTRY NM C | 3 | VARCHAR | 100 | NO | YES | FALSE | FALSE | |
| CTRY_REF_C | Country Reference | Country Reference | CTRY_ISO2_CD_C | CTRY ISO2 CD C | 4 | VARCHAR | 2 | NO | YES | FALSE | FALSE | |
| CTRY_REF_C | Country Reference | Country Reference | CTRY_ISO3_CD_C | CTRY ISO3 CD C | 5 | VARCHAR | 3 | NO | YES | FALSE | FALSE | |
| CTRY_REF_C | Country Reference | Country Reference | CTRY_UN_CD_C | CTRY UN CD C | 6 | VARCHAR | 3 | NO | YES | FALSE | FALSE | |
| CTRY_REF_C | Country Reference | Country Reference | SYS_CRT_DTT_C | SYS CRT DTT C | 7 | DATE | NO | YES | FALSE | FALSE | ||
| CTRY_REF_C | Country Reference | Country Reference | SYS_CRT_BY_C | SYS CRT BY C | 8 | VARCHAR | 255 | NO | YES | FALSE | FALSE | |
| CTRY_REF_C | Country Reference | Country Reference | SYS_EFF_DTT_C | SYS EFF DTT C | 9 | DATE | NO | YES | FALSE | FALSE | ||
| CTRY_REF_C | Country Reference | Country Reference | SYS_UPDT_DTT_C | SYS UPDT DTT C | 10 | DATE | NO | YES | FALSE | FALSE | ||
| CTRY_REF_C | Country Reference | Country Reference | SYS_UPDT_BY_C | SYS UPDT BY C | 11 | VARCHAR | 255 | NO | YES | FALSE | FALSE | |
| CTRY_REF_C | Country Reference | Country Reference | SYS_END_DTT_C | SYS END DTT C | 12 | DATE | NO | YES | FALSE | FALSE | ||
| CURR_XCHNG_REF_C | Currency Exchange Reference | Currency Exchange Reference | CURR_XCHNG_SYS_KEY_C | CURR XCHNG SYS KEY C | 1 | VARCHAR | 20 | NO | NO | TRUE | TRUE | |
| CURR_XCHNG_REF_C | Currency Exchange Reference | Currency Exchange Reference | CTRY_CD_C | CTRY CD C | 2 | VARCHAR | 20 | NO | NO | FALSE | TRUE | |
| CURR_XCHNG_REF_C | Currency Exchange Reference | Currency Exchange Reference | CURR_XCHNG_TYPE_CD_C | CURR XCHNG TYPE CD C | 3 | VARCHAR | 20 | NO | YES | FALSE | FALSE | |
| CURR_XCHNG_REF_C | Currency Exchange Reference | Currency Exchange Reference | FRM_CURR_ISO_CD_C | FRM CURR ISO CD C | 4 | VARCHAR | 3 | NO | NO | FALSE | TRUE | |
| CURR_XCHNG_REF_C | Currency Exchange Reference | Currency Exchange Reference | TO_CURR_ISO_CD_C | TO CURR ISO CD C | 5 | VARCHAR | 3 | NO | NO | FALSE | TRUE | |
| CURR_XCHNG_REF_C | Currency Exchange Reference | Currency Exchange Reference | PERIOD_ID_C | PERIOD ID C | 6 | VARCHAR | 20 | NO | YES | FALSE | FALSE | |
| CURR_XCHNG_REF_C | Currency Exchange Reference | Currency Exchange Reference | CURR_XCHNG_RATE_VAL_C | CURR XCHNG RATE VAL C | 7 | NUMERIC | 10 | 5 | NO | YES | FALSE | FALSE |
| CURR_XCHNG_REF_C | Currency Exchange Reference | Currency Exchange Reference | SYS_CRT_DTT_C | SYS CRT DTT C | 8 | DATE | NO | YES | FALSE | FALSE | ||
| CURR_XCHNG_REF_C | Currency Exchange Reference | Currency Exchange Reference | SYS_CRT_BY_C | SYS CRT BY C | 9 | VARCHAR | 255 | NO | YES | FALSE | FALSE | |
| CURR_XCHNG_REF_C | Currency Exchange Reference | Currency Exchange Reference | SYS_EFF_DTT_C | SYS EFF DTT C | 10 | DATE | NO | YES | FALSE | FALSE | ||
| CURR_XCHNG_REF_C | Currency Exchange Reference | Currency Exchange Reference | SYS_UPDT_DTT_C | SYS UPDT DTT C | 11 | DATE | NO | YES | FALSE | FALSE | ||
| CURR_XCHNG_REF_C | Currency Exchange Reference | Currency Exchange Reference | SYS_UPDT_BY_C | SYS UPDT BY C | 12 | VARCHAR | 255 | NO | YES | FALSE | FALSE | |
| CURR_XCHNG_REF_C | Currency Exchange Reference | Currency Exchange Reference | SYS_END_DTT_C | SYS END DTT C | 13 | DATE | NO | YES | FALSE | FALSE |