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: XTR.XTR_TRANSACTIONS_INTERFACE

Object Details

Object Name:	XTR_TRANSACTIONS_INTERFACE
Object Type:	TABLE
Owner:	XTR
FND Design Data:	XTR.XTR_TRANSACTIONS_INTERFACE
Subobject Name:
Status:	VALID

This table is a details table to its master table XTR_DEALS_INTERFACE, and it extends the usage of XTR_DEALS_INTERFACE by providing an interface table for the details of deals that have multiple transactions associated.
Scope: public
Product: XTR
Lifecycle: active
Display Name: Treasury Transaction Data Import Interface
Category: BUSINESS_ENTITY XTR_DEAL_DATA

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
XTR_TRANSACTIONS_INTERFACE_U1	NORMAL	UNIQUE	APPS_TS_INTERFACE	EXTERNAL_DEAL_ID DEAL_TYPE TRANSACTION_NO

Columns

Name	Datatype	Length	Mandatory	Comments
EXTERNAL_DEAL_ID	VARCHAR2	(240)	Yes	Unique Identifier for the deal, must match the deal header information for this deal as found in XTR_DEALS_INTERFACE
DEAL_TYPE	VARCHAR2	(7)	Yes	The deal type for the deal, must match the deal header information for this deal as found in XTR_DEALS_INTERFACE
TRANSACTION_NO	NUMBER		Yes	Unique Identifier for this transaction of the deal. This value is used only for identification purposes during the import process, and will be discarded once the import process is complete
CREATED_BY	NUMBER	(15)	Yes	Standard Who column
CREATION_DATE	DATE		Yes	Standard Who column
LAST_UPDATE_DATE	DATE			Standard Who column
LAST_UPDATED_BY	NUMBER			Standard Who column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who column
AMOUNT_A	NUMBER			Generic field for holding amounts. See documentation for field mappings for each deal type
AMOUNT_B	NUMBER			Generic field for holding amounts. See documentation for field mappings for each deal type
AMOUNT_C	NUMBER			Generic field for holding amounts. See documentation for field mappings for each deal type
AMOUNT_D	NUMBER			Generic field for holding amounts. See documentation for field mappings for each deal type
VALUE_A	NUMBER			Generic field for holding values. See documentation for field mappings for each deal type
OPTION_A	VARCHAR2	(1)		Generic field for holding options. See documentation for field mappings for each deal type
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Descriptive flexfield category. See documentation for flexfield mappings for each deal type
ATTRIBUTE1	VARCHAR2	(150)		Descriptive flexfield. See documentation for flexfield mappings for each deal type
ATTRIBUTE2	VARCHAR2	(150)		Descriptive flexfield. See documentation for flexfield mappings for each deal type
ATTRIBUTE3	VARCHAR2	(150)		Descriptive flexfield. See documentation for flexfield mappings for each deal type
ATTRIBUTE4	VARCHAR2	(150)		Descriptive flexfield. See documentation for flexfield mappings for each deal type
ATTRIBUTE5	VARCHAR2	(150)		Descriptive flexfield. See documentation for flexfield mappings for each deal type
ATTRIBUTE6	VARCHAR2	(150)		Descriptive flexfield. See documentation for flexfield mappings for each deal type
ATTRIBUTE7	VARCHAR2	(150)		Descriptive flexfield. See documentation for flexfield mappings for each deal type
ATTRIBUTE8	VARCHAR2	(150)		Descriptive flexfield. See documentation for flexfield mappings for each deal type
ATTRIBUTE9	VARCHAR2	(150)		Descriptive flexfield. See documentation for flexfield mappings for each deal type
ATTRIBUTE10	VARCHAR2	(150)		Descriptive flexfield. See documentation for flexfield mappings for each deal type
ATTRIBUTE11	VARCHAR2	(150)		Descriptive flexfield. See documentation for flexfield mappings for each deal type
ATTRIBUTE12	VARCHAR2	(150)		Descriptive flexfield. See documentation for flexfield mappings for each deal type
ATTRIBUTE13	VARCHAR2	(150)		Descriptive flexfield. See documentation for flexfield mappings for each deal type
ATTRIBUTE14	VARCHAR2	(150)		Descriptive flexfield. See documentation for flexfield mappings for each deal type
ATTRIBUTE15	VARCHAR2	(150)		Descriptive flexfield. See documentation for flexfield mappings for each deal type

Query Text

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


SELECT EXTERNAL_DEAL_ID
,      DEAL_TYPE
,      TRANSACTION_NO
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      AMOUNT_A
,      AMOUNT_B
,      AMOUNT_C
,      AMOUNT_D
,      VALUE_A
,      OPTION_A
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
FROM XTR.XTR_TRANSACTIONS_INTERFACE;

Dependencies

[top of page]

XTR.XTR_TRANSACTIONS_INTERFACE does not reference any database object

XTR.XTR_TRANSACTIONS_INTERFACE is referenced by following:

XTR: XTR_TRANSACTIONS_INTERFACE#