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: GMS.GMS_TRANSACTION_INTERFACE_ALL

Object Details

Object Name:	GMS_TRANSACTION_INTERFACE_ALL
Object Type:	TABLE
Owner:	GMS
FND Design Data:	GMS.GMS_TRANSACTION_INTERFACE_ALL
Subobject Name:
Status:	VALID

GMS_TRANSACTION_INTERFACE_ALL stores additional information on transactions to be interfaced to Grants Accounting for each transaction created in the PA_TRANSACTION_INTERFACE_ALL table.

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
GMS_TXN_XFACE_U1	NORMAL	UNIQUE	APPS_TS_INTERFACE	TXN_INTERFACE_ID
GMS_TXN_XFACE_N1	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	BATCH_NAME TRANSACTION_SOURCE TRANSACTION_STATUS_CODE
GMS_TXN_XFACE_N2	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	ORIG_TRANSACTION_REFERENCE

Columns

Name	Datatype	Length	Mandatory	Comments
TXN_INTERFACE_ID	NUMBER	(15)	Yes	System-generated unique identifier for a transaction to be interfaced. This is same as the TXN_INTERFACE_ID in PA_TRANSACTION_INTERFACE_ALL.
BATCH_NAME	VARCHAR2	(50)		The column is obsolete
TRANSACTION_SOURCE	VARCHAR2	(30)		The column is obsolete
EXPENDITURE_ENDING_DATE	DATE			The column is obsolete
EXPENDITURE_ITEM_DATE	DATE			The column is obsolete
PROJECT_NUMBER	VARCHAR2	(25)		The column is obsolete
TASK_NUMBER	VARCHAR2	(25)		The column is obsolete
AWARD_ID	NUMBER	(15)		The column is obsolete
EXPENDITURE_TYPE	VARCHAR2	(30)		The column is obsolete
TRANSACTION_STATUS_CODE	VARCHAR2	(2)		The column is obsolete
ORIG_TRANSACTION_REFERENCE	VARCHAR2	(30)		The column is obsolete
ORG_ID	NUMBER	(15)		The column is obsolete
SYSTEM_LINKAGE	VARCHAR2	(30)		The column is obsolete
USER_TRANSACTION_SOURCE	VARCHAR2	(80)		The column is obsolete
TRANSACTION_TYPE	VARCHAR2	(1)		Transaction type. E indicates Encumbrance, and A indicates Actuals.
BURDENABLE_RAW_COST	NUMBER	(22)		Amount of raw cost eligible for burdening
FUNDING_PATTERN_ID	NUMBER	(15)		Funding pattern identifier for the award distribution
CREATED_BY	NUMBER	(15)		Standard Who column
CREATION_DATE	DATE			Standard Who column
LAST_UPDATED_BY	NUMBER	(15)		Standard Who column
LAST_UPDATE_DATE	DATE			Standard Who column
AWARD_NUMBER	VARCHAR2	(15)		Number identifying the award to which the transaction is charged
ORIGINAL_ENCUMBRANCE_ITEM_ID	NUMBER	(15)		Number identifying the Original Encumbrance Item which will be adjusted

Query Text

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


SELECT TXN_INTERFACE_ID
,      BATCH_NAME
,      TRANSACTION_SOURCE
,      EXPENDITURE_ENDING_DATE
,      EXPENDITURE_ITEM_DATE
,      PROJECT_NUMBER
,      TASK_NUMBER
,      AWARD_ID
,      EXPENDITURE_TYPE
,      TRANSACTION_STATUS_CODE
,      ORIG_TRANSACTION_REFERENCE
,      ORG_ID
,      SYSTEM_LINKAGE
,      USER_TRANSACTION_SOURCE
,      TRANSACTION_TYPE
,      BURDENABLE_RAW_COST
,      FUNDING_PATTERN_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      AWARD_NUMBER
,      ORIGINAL_ENCUMBRANCE_ITEM_ID
FROM GMS.GMS_TRANSACTION_INTERFACE_ALL;

Dependencies

[top of page]

GMS.GMS_TRANSACTION_INTERFACE_ALL does not reference any database object

GMS.GMS_TRANSACTION_INTERFACE_ALL is referenced by following:

GMS: GMS_TRANSACTION_INTERFACE_ALL#