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_BILLING_CANCELLATIONS

Object Details

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

GMS_BILLING_CANCELLATIONS store cancelled or deleted revenue and billing amounts. Used for maintaining invoice or revenue amounts in Award Status Inquiry.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
GMS_BILLING_CANCELLATIONS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	EXPENDITURE_ITEM_ID ADL_LINE_NUM ACTUAL_PROJECT_ID ACTUAL_TASK_ID AWARD_PROJECT_ID
GMS_BILLING_CANCELLATIONS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	AWARD_PROJECT_ID ACTUAL_PROJECT_ID ACTUAL_TASK_ID

Columns

Name	Datatype	Length	Mandatory	Comments
AWARD_PROJECT_ID	NUMBER	(15)	Yes	Internal identifier of the project maintained for an award
EVENT_NUM	NUMBER	(15)	Yes	Event number of the deleted or cancelled billing event
EXPENDITURE_ITEM_ID	NUMBER	(15)		Expenditure item identifier of the cancelled or deleted billing event distribution
ADL_LINE_NUM	NUMBER	(15)		Award distribution line number of the expenditure item in the cancelled or deleted billing or revenue distribution.
BILL_AMOUNT	NUMBER	(22)		Revenue or invoice amount of the event distribution
CALLING_PROCESS	VARCHAR2	(15)		Process name describes whether the record is an invoice or revenue distribution
BURDEN_EXP_TYPE	VARCHAR2	(30)		Expenditure type mapped to the indirect cost code
BURDEN_COST_CODE	VARCHAR2	(30)		Indirect cost code
CREATION_DATE	DATE			Date of creation of the revenue or invoice
ACTUAL_PROJECT_ID	NUMBER	(15)		Internal identifier of the sponsored project to which the event was assigned.
ACTUAL_TASK_ID	NUMBER	(15)		Internal identifier of the task to which the cancelled billing event is assigned
EXPENDITURE_ORG_ID	NUMBER	(15)		Expenditure organization
DELETION_DATE	DATE			Date on which the revenue or invoice was deleted
RESOURCE_LIST_MEMBER_ID	NUMBER	(15)		Resource list member identifier to which the billing event distribution is mapped to

Query Text

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


SELECT AWARD_PROJECT_ID
,      EVENT_NUM
,      EXPENDITURE_ITEM_ID
,      ADL_LINE_NUM
,      BILL_AMOUNT
,      CALLING_PROCESS
,      BURDEN_EXP_TYPE
,      BURDEN_COST_CODE
,      CREATION_DATE
,      ACTUAL_PROJECT_ID
,      ACTUAL_TASK_ID
,      EXPENDITURE_ORG_ID
,      DELETION_DATE
,      RESOURCE_LIST_MEMBER_ID
FROM GMS.GMS_BILLING_CANCELLATIONS;

Dependencies

[top of page]

GMS.GMS_BILLING_CANCELLATIONS does not reference any database object

GMS.GMS_BILLING_CANCELLATIONS is referenced by following:

GMS: GMS_BILLING_CANCELLATIONS#