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_MHC_LEDGER

Object Details

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

IGI_MHC_LEDGER holds the journal entries created by the Revaluation and Depreciation processes before they are transferred into the GL_INTERFACE and FA_ADJUSTMENT tables.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IGI_MHC_LEDGER_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	LEDGER_ENTRY_ID
IGI_MHC_LEDGER_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ASSET_ID
IGI_MHC_LEDGER_T_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	BOOK_TYPE_CODE ASSET_ID DISTRIBUTION_ID

Columns

Name	Datatype	Length	Mandatory	Comments
LEDGER_ENTRY_ID	NUMBER	(15)	Yes	Unique identifier for the Ledger Entry
CURRENT_PERIOD_COUNTER	NUMBER	(15)	Yes	Current Depreciation Period
BOOK_TYPE_CODE	VARCHAR2	(15)	Yes	Name of the Book
ASSET_ID	NUMBER	(15)	Yes	Unique Identifier for the Asset
DISTRIBUTION_ID	NUMBER		Yes	Identofier for the Distribution Line of the Asset
TRANSACTION_TYPE	VARCHAR2	(25)	Yes	The process which has created the Ledger entry. For example DEPRECIATION or REVALUATION
TRANSACTION_SUB_TYPE	VARCHAR2	(25)	Yes	The type of the process which has created the ledger entry. For example 'INDEXED' if created by the INDEXED REVALUATION process of CATCHUP, if created when calculating CATCHUP REVALUATION.
TRANSACTION_HEADER_ID	NUMBER		Yes	Transaction Header Id from the Oracle Assets table FA_TRANSACTION_HEADER
TRANSFER_STATUS	VARCHAR2	(5)	Yes	Flag indicating whether these entries have been transferred to the GL_INTERFACE or FA_ADJUSTMENTS table. Typical Values areGL : Record awaiting to be transferred to the GL_INTERFACE tableADJ : Record awaiting to be transferred to the FA_ADJUSTMENTS tableGLT : Record has been transferred to the GL Interface tableADJT : Record has been transferred to the FA_ADJUSTMENTS tableREF : Record for Reference purposes only.
TRANSFER_PERIOD_COUNTER	NUMBER	(15)		Depreciation Period Counter in which the transfer was performed.
PROCESS_ID	NUMBER	(15)		Id of the Process which has created the Ledger Entry
PROCESS_MODE	VARCHAR2	(1)		Mode in which the process had been run which created the Ledger Entry Id. Live (L) or Preview (P)
JOURNAL_DESCRIPTION	VARCHAR2	(200)		Decription of the journal to be created, For example 'MHCA : Depreciation'
JOURNAL_SOURCE	VARCHAR2	(30)	Yes	Journal entry source user defined name, For Example ' Assets'
JOURNAL_DATE	DATE			Date the journal was created
ENTERED_DEBIT	NUMBER			Transaction amount in Debit
ENTERED_CREDIT	NUMBER			Transaction amount in Credit
AMOUNT	NUMBER			Transaction amount
DR_CR_FLAG	VARCHAR2	(2)		Flag to indicate whether the amount is to be Debited or Credited.
CODE_COMBINATION_ID	NUMBER	(15)	Yes	Code Comibination Id of the account
REVERSAL_LEDGER_ENTRY_ID	NUMBER	(25)		Ledger Entry Id of the Ledger in which this transaction was reversed
CREATION_DATE	DATE		Yes	Standard who column - date when this row was created.
CREATED_BY	NUMBER	(15)	Yes	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE	DATE			Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY	NUMBER	(15)		Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
REFERENCE1	VARCHAR2	(100)		Reference 1
REFERENCE2	VARCHAR2	(240)		Reference 2
REFERENCE3	VARCHAR2	(240)		Reference3
REFERENCE4	VARCHAR2	(240)		Reference 4
REFERENCE5	VARCHAR2	(240)		Text to indicate which account gets affected. Used internally. Typical values includeDEPRN_EXPENSE_ACCTBLOG_DEPRN_RSVREVAL_RESERVE_ACCTASSET_COST_ACCTGENERAL_FUND_ACCT
CONCATENATED_SEGMENTS	VARCHAR2	(1000)		Concatenated segments of the account for the code combination id. This is for reporting puproses only.
ACCOUNT_TYPE	VARCHAR2	(25)	Yes	Type of Account.Typical values areBACKLOGCOSTEXPENSEGENERAL FUNDREVAL RESERVE
FA_ADJUSTMENTS_ROWID	ROWID	(10)		ROWID of the record in FA_ADJUSTMENTS after this entry has been transferred to FA_ADJUSTMENTS
GL_JE_LINES_ROWID	ROWID	(10)		ROWID in GL_JE_LINES table after this entry has been copied over from the GL_INTERFACE table to the GL_JE_LINES table. This column will be populated by a Trigger on GL_JE_LINES table.
CURRENT_MHC_PERIOD_COUNTER	NUMBER	(15)	Yes	Current Modified Historic Cost Accounting Period Counter

Query Text

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


SELECT LEDGER_ENTRY_ID
,      CURRENT_PERIOD_COUNTER
,      BOOK_TYPE_CODE
,      ASSET_ID
,      DISTRIBUTION_ID
,      TRANSACTION_TYPE
,      TRANSACTION_SUB_TYPE
,      TRANSACTION_HEADER_ID
,      TRANSFER_STATUS
,      TRANSFER_PERIOD_COUNTER
,      PROCESS_ID
,      PROCESS_MODE
,      JOURNAL_DESCRIPTION
,      JOURNAL_SOURCE
,      JOURNAL_DATE
,      ENTERED_DEBIT
,      ENTERED_CREDIT
,      AMOUNT
,      DR_CR_FLAG
,      CODE_COMBINATION_ID
,      REVERSAL_LEDGER_ENTRY_ID
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      REFERENCE1
,      REFERENCE2
,      REFERENCE3
,      REFERENCE4
,      REFERENCE5
,      CONCATENATED_SEGMENTS
,      ACCOUNT_TYPE
,      FA_ADJUSTMENTS_ROWID
,      GL_JE_LINES_ROWID
,      CURRENT_MHC_PERIOD_COUNTER
FROM IGI.IGI_MHC_LEDGER;

Dependencies

[top of page]

IGI.IGI_MHC_LEDGER does not reference any database object

IGI.IGI_MHC_LEDGER is referenced by following:

APPS: IGI_MHC_LEDGER