AP_USER_EXCHANGE_RATES

This table holds User type exchange rate when submitting the payment process request for multiple currencies and even multiple functional currencies (because the documents payable can be for multiple ledgers). The user will know the required user rates if the request is limited to specific currencies for specific ledgers and if the payment date is not in the future. If the user does not know all these factors, then the payment process request will pause later with a status of Payment Exchange Rates Missing.

Details

• Schema: FUSION

• Object owner: AP

• Object type: TABLE

• Tablespace: APPS_TS_TX_DATA

Primary Key

Name	Columns
AP_USER_EXCHANGE_RATES_PK	PPR_USER_EXCHANGE_RATE_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
PPR_USER_EXCHANGE_RATE_ID	NUMBER		18	Yes	Payment Process Request User Exchange Rate Identifier
CHECKRUN_ID	NUMBER		18	Yes	Payment process request identifier
PAYMENT_CURRENCY_CODE	VARCHAR2	15		Yes	Currency used for making payment.
LEDGER_CURRENCY_CODE	VARCHAR2	15			Currency used for accounting and reporting in a ledger. It is often referred as, accounting currency, base currency, or functional currency.
EXCHANGE_RATE	NUMBER				User exchange rate that is associated with the payment process request identifier.
CREATION_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the creation of the row.
CREATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who created the row.
LAST_UPDATE_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the last update of the row.
LAST_UPDATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who last updated the row.
LAST_UPDATE_LOGIN	VARCHAR2	32			Who column: indicates the session login associated to the user who last updated the row.
OBJECT_VERSION_NUMBER	NUMBER		9	Yes	Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried.
INVOICE_CURRENCY_CODE	VARCHAR2	15			The currency in which a supplier invoice is received.
BANK_CURRENCY_CODE	VARCHAR2	15			Disbursement bank account currency.

Foreign Keys

Table	Foreign Table	Foreign Key Column
AP_USER_EXCHANGE_RATES	ap_inv_selection_criteria_all	CHECKRUN_ID

Indexes

Index	Uniqueness	Tablespace	Columns	Status
AP_USER_EXCHANGE_RATES_N1	Non Unique	Default	CHECKRUN_ID, PAYMENT_CURRENCY_CODE
AP_USER_EXCHANGE_RATES_U1	Unique	Default	PPR_USER_EXCHANGE_RATE_ID
AP_USER_EXCHANGE_RATES_U2	Unique	Default	PPR_USER_EXCHANGE_RATE_ID, CHECKRUN_ID	Obsolete