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_BURDEN_ADJUSTMENTS_LOG

Object Details

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

GMS_BURDEN_ADJUSTMENTS_LOG maintains the journal of burdenable raw cost adjustments done across expenditure items, invoice distribution, manual encumbrances, purchase order distribution, and purchase requisition distribution in order to maximize the burdenable raw cost by award and expenditure type.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
GMS_ADJ_PK_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	ADJUSTMENT_ID LINE_NUM
GMS_DOC_KEY_IND_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	DOCUMENT_HEADER_ID DOCUMENT_DISTRIBUTION_ID DOCUMENT_TYPE
GMS_PACKET_IND_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PACKET_ID BC_PACKET_ID

Columns

Name	Datatype	Length	Mandatory	Comments
ADJUSTMENT_ID	NUMBER	(15)	Yes	Unique identifier for set of adjustments
LINE_NUM	NUMBER	(15)	Yes	Sequence of adjustments in a given set
DOCUMENT_HEADER_ID	NUMBER	(15)	Yes	Internal identifier of the transaction adjusted
DOCUMENT_DISTRIBUTION_ID	NUMBER	(15)	Yes	Distribution identifier of the source transaction
DOCUMENT_TYPE	VARCHAR2	(3)	Yes	Document type of the transaction adjusted
AMOUNT	NUMBER	(22)	Yes	Raw cost of the adjusting transaction
ADJ_BURDENABLE_AMOUNT	NUMBER	(22)	Yes	Burdenable amount of adjusting transaction
SOURCE_FLAG	VARCHAR2	(1)	Yes	Indicates the source of adjustments. Default value is Y.
AWARD_SET_ID	NUMBER	(15)	Yes	Reference number for the award distribution
ADL_LINE_NUM	NUMBER	(15)	Yes	Sequence number of the award distribution within a distribution set
AWARD_ID	NUMBER		Yes	Internal identifier of award
EXPENDITURE_TYPE	VARCHAR2	(30)	Yes	Expenditure type of the adjustment transaction
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who column
CREATED_BY	NUMBER	(15)	Yes	Standard Who column
CREATION_DATE	DATE		Yes	Standard Who column
LAST_UPDATE_LOGIN	NUMBER	(15)	Yes	Standard Who column
POSTED_FLAG	VARCHAR2	(1)	Yes	Indicates status of posting adjustment transaction in balances
PACKET_ID	NUMBER	(15)		GMS_bc_packets Packet id reference.
BC_PACKET_ID	NUMBER	(15)		GMS_bc_packets bc_packet id reference.

Query Text

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


SELECT ADJUSTMENT_ID
,      LINE_NUM
,      DOCUMENT_HEADER_ID
,      DOCUMENT_DISTRIBUTION_ID
,      DOCUMENT_TYPE
,      AMOUNT
,      ADJ_BURDENABLE_AMOUNT
,      SOURCE_FLAG
,      AWARD_SET_ID
,      ADL_LINE_NUM
,      AWARD_ID
,      EXPENDITURE_TYPE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATE_LOGIN
,      POSTED_FLAG
,      PACKET_ID
,      BC_PACKET_ID
FROM GMS.GMS_BURDEN_ADJUSTMENTS_LOG;

Dependencies

[top of page]

GMS.GMS_BURDEN_ADJUSTMENTS_LOG does not reference any database object

GMS.GMS_BURDEN_ADJUSTMENTS_LOG is referenced by following:

APPS: GMS_BURDEN_ADJUSTMENTS_LOG