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: IGI.IGI_ITR_CHARGE_HEADERS

Object Details

Object Name:	IGI_ITR_CHARGE_HEADERS
Object Type:	TABLE
Owner:	IGI
FND Design Data:	IGI.IGI_ITR_CHARGE_HEADERS
Subobject Name:
Status:	VALID

IGI_ITR_CHARGE_HEADERS stores cross charge entry headers. Each row includes the cross charge name, running total debits, running total credits, as well as other necessary information. This table corresponds to the header region of the Internal Charge Entry window.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IGI_ITR_CHARGE_HEADERS_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	IT_HEADER_ID

Columns

Name	Datatype	Length	Mandatory	Comments
IT_HEADER_ID	NUMBER	(15)	Yes	Cross charge header identifier
SET_OF_BOOKS_ID	NUMBER	(15)	Yes	Set of Books identifier
NAME	VARCHAR2	(100)	Yes	Cross charge name
DESCRIPTION	VARCHAR2	(240)		Cross charge header description
IT_PERIOD_NAME	VARCHAR2	(15)	Yes	Accounting period
ENTERED_DR	NUMBER			Header entered debit, base currency
ENTERED_CR	NUMBER			Header entered credit, base currency
SUBMIT_FLAG	VARCHAR2	(1)	Yes	Values are N for New, S for Submit, F for Fundsfail, D for Deleted, P for Posted, R for Repost, and C for Complete.
IT_ORIGINATOR_ID	VARCHAR2	(25)	Yes	Cross charge entry originator identifier
IT_CATEGORY	VARCHAR2	(25)		Not Used Anymore
IT_SOURCE	VARCHAR2	(25)		Not Used Anymore
GL_DATE	DATE		Yes	Transaction date
SUBMIT_DATE	DATE			Date cross charge was submitted
CURRENCY_CODE	VARCHAR2	(15)	Yes	Currency
CODE_COMBINATION_ID	NUMBER	(15)		Not Used Anymore
ENCUMBRANCE_TYPE_ID	NUMBER	(15)		Not Used Anymore
CREATION_DATE	DATE		Yes	Standard who column - date when this row was created.
CREATED_BY	NUMBER		Yes	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN	NUMBER			Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
LAST_UPDATE_DATE	DATE			Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY	NUMBER			Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
EMPLOYEE_ID	NUMBER	(15)		Not Used Anymore
CHARGE_CENTER_ID	NUMBER	(15)		Charge Center Identifier

Query Text

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


SELECT IT_HEADER_ID
,      SET_OF_BOOKS_ID
,      NAME
,      DESCRIPTION
,      IT_PERIOD_NAME
,      ENTERED_DR
,      ENTERED_CR
,      SUBMIT_FLAG
,      IT_ORIGINATOR_ID
,      IT_CATEGORY
,      IT_SOURCE
,      GL_DATE
,      SUBMIT_DATE
,      CURRENCY_CODE
,      CODE_COMBINATION_ID
,      ENCUMBRANCE_TYPE_ID
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      EMPLOYEE_ID
,      CHARGE_CENTER_ID
FROM IGI.IGI_ITR_CHARGE_HEADERS;

Dependencies

[top of page]

IGI.IGI_ITR_CHARGE_HEADERS does not reference any database object

IGI.IGI_ITR_CHARGE_HEADERS is referenced by following:

APPS: IGI_ITR_CHARGE_HEADERS