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_CHECKS

Object Details

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

AP_MC_CHECKS 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_CHECKS_ALL
and this table. For each payment in the AP_CHECKS_ALL table, there
can be several invoices in the AP_MC_CHECKS table with the same
CHECK_ID value, but different values for SET_OF_BOOKS_ID. The number
of invoices stored in the AP_MC_CHECKS table having the same CHECK_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_CHECKS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	CHECK_ID SET_OF_BOOKS_ID

Columns

Name	Datatype	Length	Mandatory	Comments
CHECK_ID	NUMBER	(15)	Yes	Payment identifier
SET_OF_BOOKS_ID	NUMBER	(15)	Yes	Set of Books identifier
CLEARED_BASE_AMOUNT	NUMBER			Payment cleared amount in functional currency
CLEARED_EXCHANGE_RATE	NUMBER			Exchange rate at which the payment cleared, for foreign currency payments only
CLEARED_EXCHANGE_DATE	DATE			Date clearing exchange rate is effective, usually accounting date of a transaction
CLEARED_EXCHANGE_RATE_TYPE	VARCHAR2	(30)		Exchange rate type at payment clearing time, for foreign currency payments only
EXCHANGE_RATE	NUMBER			Currency conversion rate used to convert the transactional currency amount to reporting currency amount
EXCHANGE_DATE	DATE			Date which determines currency conversion rate to convert transaction currency amounts into reporting currency amounts
EXCHANGE_RATE_TYPE	VARCHAR2	(30)		Currency conversion rate type to convert transaction currency amounts into reporting currency amounts
MATURITY_EXCHANGE_DATE	DATE			Date maturing exchange rate is effective, usually accouning date of a transaction
MATURITY_EXCHANGE_RATE_TYPE	VARCHAR2	(30)		Exchange rate type at payment maturity time, for foreign currency payments only
MATURITY_EXCHANGE_RATE	NUMBER			Exchange rate ate which payment matured, for foreign currency payments only
BASE_AMOUNT	NUMBER			Distribution amount in functional currency, only used for foreign currency invoices
CLEARED_ERROR_BASE_AMOUNT	NUMBER			Cleared payment error base amount
CLEARED_CHARGES_BASE_AMOUNT	NUMBER			Cleared payment charges amount
STAMP_DUTY_BASE_AMT	NUMBER			Stamp duty tax amount in functional currency for country-specific functionality

Query Text

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


SELECT CHECK_ID
,      SET_OF_BOOKS_ID
,      CLEARED_BASE_AMOUNT
,      CLEARED_EXCHANGE_RATE
,      CLEARED_EXCHANGE_DATE
,      CLEARED_EXCHANGE_RATE_TYPE
,      EXCHANGE_RATE
,      EXCHANGE_DATE
,      EXCHANGE_RATE_TYPE
,      MATURITY_EXCHANGE_DATE
,      MATURITY_EXCHANGE_RATE_TYPE
,      MATURITY_EXCHANGE_RATE
,      BASE_AMOUNT
,      CLEARED_ERROR_BASE_AMOUNT
,      CLEARED_CHARGES_BASE_AMOUNT
,      STAMP_DUTY_BASE_AMT
FROM AP.AP_MC_CHECKS;

Dependencies

[top of page]

AP.AP_MC_CHECKS does not reference any database object

AP.AP_MC_CHECKS is referenced by following:

APPS: AP_MC_CHECKS