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_CORR_PAY_SCHED_ALL

Object Details

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

The AR_CORR_PAY_SCHED_ALL table stores one record for each invoice that Oracle Receivables selects for dunning. Each row includes invoice and correspondence information. Oracle Receivables uses this information to determine which customer invoices were dunned. You can find detailed information about a customer's dunning letter in the AR_CORRESPONDENCES_ALL table.
.
The primary key for this table is CORRESPONDENCE_PAY_SCHED_ID.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
AR_CORRESPONDENCE_PAY_SCHED_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	CORRESPONDENCE_PAY_SCHED_ID
AR_CORRESPONDENCE_PAY_SCHED_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PAYMENT_SCHEDULE_ID
AR_CORRESPONDENCE_PAY_SCHED_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CORRESPONDENCE_ID

Columns

Name	Datatype	Length	Mandatory	Comments
CORRESPONDENCE_PAY_SCHED_ID	NUMBER	(15)	Yes	Identifier of the correspondence payment schedule
LAST_UPDATE_DATE	DATE		Yes	Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
CREATION_DATE	DATE		Yes	Standard who column - date when this row was created.
CREATED_BY	NUMBER	(15)	Yes	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
PAYMENT_SCHEDULE_ID	NUMBER	(15)	Yes	Identifier of the payment schedule associated with this dunned record
CORRESPONDENCE_ID	NUMBER	(15)	Yes	Identifier of the correspondence associated with this record
AMOUNT_DUE_REMAINING	NUMBER		Yes	Transaction balance as reported on dunning letter
AMOUNT_ACCRUE	NUMBER		Yes	Accrued finance charge amount
AMOUNT_UNACCRUE	NUMBER		Yes	Unaccrued finance charge amount
ORG_ID	NUMBER	(15)		Organization identifier
STAGED_DUNNING_LEVEL	NUMBER	(2)		Dunning level of the item as printed on the dunning correspondence

Query Text

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


SELECT CORRESPONDENCE_PAY_SCHED_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATION_DATE
,      CREATED_BY
,      PAYMENT_SCHEDULE_ID
,      CORRESPONDENCE_ID
,      AMOUNT_DUE_REMAINING
,      AMOUNT_ACCRUE
,      AMOUNT_UNACCRUE
,      ORG_ID
,      STAGED_DUNNING_LEVEL
FROM AR.AR_CORR_PAY_SCHED_ALL;

Dependencies

[top of page]

AR.AR_CORR_PAY_SCHED_ALL does not reference any database object

AR.AR_CORR_PAY_SCHED_ALL is referenced by following:

APPS: AR_CORRESPONDENCE_PAY_SCHED; AR_CORR_PAY_SCHED_ALL