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: AR.AR_MC_PAYMENT_SCHEDULES

Object Details

Object Name:	AR_MC_PAYMENT_SCHEDULES
Object Type:	TABLE
Owner:	AR
FND Design Data:	AR.AR_MC_PAYMENT_SCHEDULES
Subobject Name:
Status:	VALID

The AR_MC_PAYMENTS_SCHEDULES table is a Multiple Reporting Currencies (MRC) subtable of the AR_PAYMENT_SCHEDULES_ALL table. The AR_MC_PAYMENT_SCHEDULES table stores currency- related information about all transactions except adjustments and miscellaneous cash receipts for each reporting set of books that is associated with the parent record in the AR_PAYMENT_SCHEDULES_ALL table.
.
Oracle Receivables updates this table when a transaction occurs against an invoice, debit memo, chargeback, credit memo, on-account credit, or receipt.
.
The primary keys for this table are SET_OF_BOOKS_ID and PAYMENT_SCHEDULE_ID.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
AR_MC_PAYMENT_SCHEDULES_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	PAYMENT_SCHEDULE_ID SET_OF_BOOKS_ID
AR_MC_PAYMENT_SCHEDULES_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CUSTOMER_TRX_ID

Columns

Name	Datatype	Length	Mandatory	Comments
SET_OF_BOOKS_ID	NUMBER	(15)	Yes	Set of Books identifier
PAYMENT_SCHEDULE_ID	NUMBER	(15)	Yes	Payment schedule identifier
CUSTOMER_TRX_ID	NUMBER	(15)		Invoice identifier
EXCHANGE_RATE_TYPE	VARCHAR2	(30)		Conversion type used to convert foreign currency transactions
EXCHANGE_DATE	DATE			Currency conversion date used to convert the transactional currency amount to reporting currency amount
EXCHANGE_RATE	NUMBER			Currency conversion rate used to convert the transactional currency amount to reporting currency amount
ACCTD_AMOUNT_DUE_REMAINING	NUMBER		Yes	AMOUNT_DUE_REMAINING in the functional currency
AMOUNT_DUE_REMAINING	NUMBER			The current amount due remaining

Query Text

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


SELECT SET_OF_BOOKS_ID
,      PAYMENT_SCHEDULE_ID
,      CUSTOMER_TRX_ID
,      EXCHANGE_RATE_TYPE
,      EXCHANGE_DATE
,      EXCHANGE_RATE
,      ACCTD_AMOUNT_DUE_REMAINING
,      AMOUNT_DUE_REMAINING
FROM AR.AR_MC_PAYMENT_SCHEDULES;

Dependencies

[top of page]

AR.AR_MC_PAYMENT_SCHEDULES does not reference any database object

AR.AR_MC_PAYMENT_SCHEDULES is referenced by following:

APPS: AR_MC_PAYMENT_SCHEDULES