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: TableAR.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: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
AR_CORRESPONDENCE_PAY_SCHED_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnCORRESPONDENCE_PAY_SCHED_ID
AR_CORRESPONDENCE_PAY_SCHED_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPAYMENT_SCHEDULE_ID
AR_CORRESPONDENCE_PAY_SCHED_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnCORRESPONDENCE_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:

SchemaAPPS
SynonymAR_CORRESPONDENCE_PAY_SCHED
SynonymAR_CORR_PAY_SCHED_ALL