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_T

Object Details

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

The FTP_PAYMENT_SCHEDULE_T interface or source table acts as a staging area for loading data into the FTP_PAYMENT_SCHEDULE destination or target table, using the FTP Payment Schedule Data Loader.
Except the STATUS and SOURCE_SYSTEM_DISPLAY_CODE columns, the columns in the interface table map to a column with the same name in the destination table.
The SOURCE_SYSTEM_CODE column in the target table represents a dimension. When you enter the display code for a dimension member in the interface table, the data loader validates the display code and transforms it into the correct internal numeric identifier in the destination table. The data loader also validates values for INSTRUMENT_TYPE_CODE before loading the record.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
FTP_PAYMENT_SCHEDULE_T_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	ID_NUMBER SOURCE_SYSTEM_DISPLAY_CODE INSTRUMENT_TYPE_CODE PAYMENT_DATE

Columns

Name	Datatype	Length	Mandatory	Comments
ID_NUMBER	NUMBER		Yes	Identifies the instrument record to which the schedule applies
SOURCE_SYSTEM_DISPLAY_CODE	VARCHAR2	(150)	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
STATUS	VARCHAR2	(60)	Yes	Designates the status of the row for loading. Records with a status of 'LOAD' are loaded by the FTP Payment Schedule Data Loader. If a row fails to load, the data loader updates the status column with an error code indicating the nature of the error.

Query Text

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


SELECT ID_NUMBER
,      SOURCE_SYSTEM_DISPLAY_CODE
,      INSTRUMENT_TYPE_CODE
,      PAYMENT_DATE
,      AMOUNT
,      STATUS
FROM FTP.FTP_PAYMENT_SCHEDULE_T;

Dependencies

[top of page]

FTP.FTP_PAYMENT_SCHEDULE_T does not reference any database object

FTP.FTP_PAYMENT_SCHEDULE_T is referenced by following:

APPS: FTP_PAYMENT_SCHEDULE_T