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: FTP.FTP_PAYMENT_SCHEDULE

Object Details

Object Name:	FTP_PAYMENT_SCHEDULE
Object Type:	TABLE
Owner:	FTP
Subobject Name:
Status:	VALID

The FTP_PAYMENT_SCHEDULE table stores account level cash flow information for instruments that have custom payment characteristics. This table is populated directly during the data load process and is referenced by the Cash Flow engine by lookup based on a match of the INSTRUMENT_TYPE_CODE and ID_NUMBER columns. The Cash Flow engine looks at this table when the AMRT_TYPE_CODE column on the instrument record is populated with a value of 800 (Conventional Schedule), 801 (Level Principal Schedule), or 802 (Simple Interest Schedule).

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
FTP_PAYMENT_SCHEDULE_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	ID_NUMBER SOURCE_SYSTEM_CODE INSTRUMENT_TYPE_CODE PAYMENT_DATE

Columns

Name	Datatype	Length	Mandatory	Comments
ID_NUMBER	NUMBER		Yes	Identifies the instrument record for which the schedule applies
SOURCE_SYSTEM_CODE	NUMBER		Yes	Application to which the schedule applies
INSTRUMENT_TYPE_CODE	NUMBER		Yes	Instrument type of ID_NUMBER. Used to find exact match.
PAYMENT_DATE	DATE		Yes	Date for the schedule payment
AMOUNT	NUMBER	(14)		Amount of the schedule payment
CREATED_BY_OBJECT_ID	NUMBER	(9)	Yes	Object that created the row. References FEM_PL_OBJECT_EXECUTIONS.OBJECT_ID
CREATED_BY_REQUEST_ID	NUMBER		Yes	Request that created the row. References FEM_PL_OBJECT_EXECUTIONS.REQUEST_ID
LAST_UPDATED_BY_OBJECT_ID	NUMBER		Yes	Object that last updated the row. References FEM_PL_OBJECT_EXECUTIONS.OBJECT_ID
LAST_UPDATED_BY_REQUEST_ID	NUMBER		Yes	Request that last updated the row. References FEM_PL_OBJECT_EXECUTIONS.REQUEST_ID

Query Text

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


SELECT ID_NUMBER
,      SOURCE_SYSTEM_CODE
,      INSTRUMENT_TYPE_CODE
,      PAYMENT_DATE
,      AMOUNT
,      CREATED_BY_OBJECT_ID
,      CREATED_BY_REQUEST_ID
,      LAST_UPDATED_BY_OBJECT_ID
,      LAST_UPDATED_BY_REQUEST_ID
FROM FTP.FTP_PAYMENT_SCHEDULE;

Dependencies

[top of page]

FTP.FTP_PAYMENT_SCHEDULE does not reference any database object

FTP.FTP_PAYMENT_SCHEDULE is referenced by following:

APPS: FTP_PAYMENT_SCHEDULE