KCST_FX_UPDATE_SERVICE

This table is used by the FX Update service to store exchange rate update requests.

Foreign Keys

Primary Key Table

Primary Key Column

Foreign Key Column

KCST_CURRENCIES_NLS

CURRENCY_ID

LOCAL_CURRENCY_ID

KNTA_USERS

USER_ID

CREATED_BY

KNTA_USERS

USER_ID

LAST_UPDATED_BY

Column Descriptions

Column Name

Null?

Data Type

Description

FX_UPDATE_SERVICE_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

EXCHANGE_DATE

NOT NULL

DATE

Date of the exchange rate being modified or inserted.

NEXT_EXCHANGE_DATE

NULLABLE

DATE

Date of the next exchange rate in the system. Useful for determining the date range in which to modify exchange rates.

LOCAL_CURRENCY_ID

NOT NULL

NUMBER

Identifier of the currency having its exchange rate modified

NEW_EXCHANGE_RATE

NOT NULL

NUMBER

Newly inserted or modified exchange rate

PARENT_ENTITY_TYPE

NOT NULL

VARCHAR2(50)

Identifies the type of the parent entity being updated or recalculated

PARENT_ENTITY_ID

NOT NULL

NUMBER

Foreign key that references the parent entity

UPDATE_TYPE

NOT NULL

VARCHAR2(10)

Indicates whether a rate is being updated or inserted

ENTITY_LAST_UPDATE_DATE

NOT NULL

DATE

Date a record in the entity was last updated

Indexes

Index Name

Index Type

Sequence

Column Name

KCST_FX_UPDATE_SERVICE_N1

NONUNIQUE

1

CREATION_DATE

KCST_FX_UPDATE_SERVICE_N2

NONUNIQUE

1

PARENT_ENTITY_TYPE

KCST_FX_UPDATE_SERVICE_N2

NONUNIQUE

2

PARENT_ENTITY_ID

KCST_FX_UPDATE_SERVICE_U1

UNIQUE

1

FX_UPDATE_SERVICE_ID

Sequences

This table uses no sequences.