eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: AP.AP_MC_INVOICE_PAYMENTS

Object Details

Object Name:	AP_MC_INVOICE_PAYMENTS
Object Type:	TABLE
Owner:	AP
FND Design Data:	SQLAP.AP_MC_INVOICE_PAYMENTS
Subobject Name:
Status:	VALID

AP_MC_INVOICE_PAYMENTS is a Multiple Reporting Currencies table that
stores reporting currency information for each payment in Oracle
Payables. There is an optional one to many relationship between
AP_INVOICE_PAYMENTS_ALL and this table. For each invoice in the
AP_INVOICE_PAYMENTS_ALL table, there can be several payments in the
AP_MC_INVOICE_PAYMENTS table with the same INVOICE_PAYMENT_ID value,
but different values for SET_OF_BOOKS_ID. The number of payments
stored in the AP_MC_INVOICE_PAYMENTS table having the same
INVOICE_PAYMENT_ID will correspond with the number of Reporting Sets
of Books that have been defined.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
AP_MC_INVOICE_PAYMENTS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	INVOICE_PAYMENT_ID SET_OF_BOOKS_ID

Columns

Name	Datatype	Length	Mandatory	Comments
INVOICE_PAYMENT_ID	NUMBER	(15)	Yes	Invoice payment identifier
SET_OF_BOOKS_ID	NUMBER	(15)	Yes	Set of Books identifier
EXCHANGE_DATE	DATE			Date which determines currency conversion rate to convert transaction currency amounts into reporting currency amounts
EXCHANGE_RATE	NUMBER			Currency conversion rate used to convert the transactional currency amount to reporting currency amount
EXCHANGE_RATE_TYPE	VARCHAR2	(30)		Currency conversion rate type to convert transaction currency amounts into reporting currency amounts
GAIN_CODE_COMBINATION_ID	NUMBER	(15)		Accounting Flexfield identifier for account to which realized exchange rate gains are posted
INVOICE_BASE_AMOUNT	NUMBER			Invoice amount in functional currency, only used for foreign currency invoices
LOSS_CODE_COMBINATION_ID	NUMBER	(15)		Accounting Flexfield identifier for account to which realized exchange rate losses are posted
PAYMENT_BASE_AMOUNT	NUMBER			Payment amount in functional currency, only used for foreign currency invoices

Query Text

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


SELECT INVOICE_PAYMENT_ID
,      SET_OF_BOOKS_ID
,      EXCHANGE_DATE
,      EXCHANGE_RATE
,      EXCHANGE_RATE_TYPE
,      GAIN_CODE_COMBINATION_ID
,      INVOICE_BASE_AMOUNT
,      LOSS_CODE_COMBINATION_ID
,      PAYMENT_BASE_AMOUNT
FROM AP.AP_MC_INVOICE_PAYMENTS;

Dependencies

[top of page]

AP.AP_MC_INVOICE_PAYMENTS does not reference any database object

AP.AP_MC_INVOICE_PAYMENTS is referenced by following:

APPS: AP_MC_INVOICE_PAYMENTS