This table holds information used to convert currencies in customer orders.

Column Name

Type

Length

Null Allowed

Description

DAY_ID

varchar

40

No

Primary key component. Foreign key to ARF_TIME_DAY.ID column.

SRC_CURRENCY_ID

smallint

No

Currency to be converted from. Primary key component. Foreign key to ARF_CURRENCY.ID column.

DST_CURRENCY_ID

smallint

No

Currency to be converted to. Primary key component. Foreign key to ARF_CURRENCY.ID column.

SRC_DST_CONV_RATE

double

No

Conversion rate from the source to the destination currency.

The field length is 19 digits, with 7 digits to the left of the decimal and 12 to the right.

DST_SRC_CONV_RATE

double

No

Conversion rate from the destination to the source currency.

The field length is 19 digits, with 7 digits to the left of the decimal and 12 to the right.


Copyright © 1997, 2013 Oracle and/or its affiliates. All rights reserved. Legal Notices