DBA Data[Home] [Help] [Dependency Information]

TABLE: AP.AP_USER_EXCHANGE_RATES

Object Details
Object Name: AP_USER_EXCHANGE_RATES
Object Type: TABLE
Owner: AP
FND Design Data: TableSQLAP.AP_USER_EXCHANGE_RATES
Subobject Name:
Status: VALID


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.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
AP_USER_EXCHANGE_RATES_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnCHECKRUN_ID
ColumnPAYMENT_CURRENCY_CODE
ColumnLEDGER_CURRENCY_CODE
Columns
Name Datatype Length Mandatory Comments
CHECKRUN_ID NUMBER (15) Yes Payment process request identifier
PAYMENT_CURRENCY_CODE VARCHAR2 (15) Yes Payment Currency Code
LEDGER_CURRENCY_CODE VARCHAR2 (15) Yes Ledger Currency Code
EXCHANGE_RATE NUMBER

User Exchange Rate
CREATION_DATE DATE
Yes Standard Who column
CREATED_BY NUMBER (15) Yes Standard Who column
LAST_UPDATE_DATE DATE
Yes Standard Who column
LAST_UPDATED_BY NUMBER (15) Yes Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT CHECKRUN_ID
,      PAYMENT_CURRENCY_CODE
,      LEDGER_CURRENCY_CODE
,      EXCHANGE_RATE
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
FROM AP.AP_USER_EXCHANGE_RATES;

Dependencies

[top of page]

AP.AP_USER_EXCHANGE_RATES does not reference any database object

AP.AP_USER_EXCHANGE_RATES is referenced by following:

SchemaAP
ViewAP_USER_EXCHANGE_RATES#