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