Share this page
KCST_CURRENCIES
This table stores the currency information for all currencies available in PPM Center.
Foreign Keys
|
Primary Key Table |
Primary Key Column |
Foreign Key Column |
|---|---|---|
|
KNTA_USERS |
USER_ID |
CREATED_BY |
|
KNTA_USERS |
USER_ID |
LAST_UPDATED_BY |
Column Descriptions
|
Column Name |
Null? |
Data Type |
Description |
|---|---|---|---|
|
CURRENCY_ID |
NOT NULL |
NUMBER |
System-generated identifier |
|
CREATION_DATE |
NOT NULL |
DATE |
Date record was created |
|
CREATED_BY |
NOT NULL |
NUMBER |
Identifier for the user who created the record |
|
LAST_UPDATE_DATE |
NOT NULL |
DATE |
Date record was last updated |
|
LAST_UPDATED_BY |
NOT NULL |
NUMBER |
Identifier for the user who last updated the record |
|
CURRENCY_NAME |
NOT NULL |
VARCHAR2(100) |
Indicates the name of the currency (such as Dollar) |
|
CURRENCY_CODE |
NOT NULL |
VARCHAR2(10) |
Indicates the three-character currency code (such as USD) |
|
CURRENCY_SYMBOL |
NOT NULL |
VARCHAR2(50) |
Indicates the currency symbol (such as $) |
|
DISPLAY_DECIMALS |
NOT NULL |
NUMBER |
Indicates whether decimals are displayed |
|
BASE_CURRENCY_FLAG |
NOT NULL |
VARCHAR2(1) |
Indicates whether this currency is the system base currency. |
|
ENABLED_FLAG |
NOT NULL |
VARCHAR2(1) |
Indicates whether this currency is enabled for use |
|
ENTITY_LAST_UPDATE_DATE |
NOT NULL |
DATE |
Date a record in the entity was last updated |
|
DEFINITION_LANGUAGE |
NOT NULL |
VARCHAR2(40) |
Language in which this currency was created in PPM Center |
|
REFERENCE_CODE |
NOT NULL |
VARCHAR2(200) |
Indicates the reference code. |
Indexes
|
Index Name |
Index Type |
Sequence |
Column Name |
|---|---|---|---|
|
KCST_CURRENCIES_U1 |
UNIQUE |
1 |
CURRENCY_ID |
|
KCST_CURRENCIES_U2 |
UNIQUE |
1 |
CURRENCY_CODE |
|
KCST_CURRENCIES_U3 |
UNIQUE |
1 |
CURRENCY_NAME |
|
SYS_C00109351527 |
UNIQUE |
1 |
REFERENCE_CODE |
Sequences
|
Sequence Name |
Sequence Type |
|---|---|
|
KCST_CURRENCIES_HIB_S |
CURRENCY_ID |
