DBA Data[Home] [Help] [Dependency Information]

TABLE: IGC.IGC_CC_MC_ACCT_LINE_HISTORY

Object Details
Object Name: IGC_CC_MC_ACCT_LINE_HISTORY
Object Type: TABLE
Owner: IGC
FND Design Data: TableIGC.IGC_CC_MC_ACCT_LINE_HISTORY
Subobject Name:
Status: VALID


IGC_CC_MC_ACCT_LINE_HISTORY stores information specific to Multiple Reporting Currency versions for account lines.


Storage Details
Tablespace: TablespaceAPPS_TS_ARCHIVE
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
IGC_CC_MC_ACCT_LINE_HISTORY_U1 NORMAL UNIQUE TablespaceAPPS_TS_ARCHIVE ColumnCC_ACCT_LINE_ID
ColumnSET_OF_BOOKS_ID
ColumnCC_ACCT_VERSION_NUM
Columns
Name Datatype Length Mandatory Comments
CC_ACCT_LINE_ID NUMBER
Yes Account line defining column
SET_OF_BOOKS_ID NUMBER (15) Yes Reporting Set of Books defining column
CC_ACCT_FUNC_AMT NUMBER

Account line functional amount to be converted
CC_ACCT_ENCMBRNC_AMT NUMBER

Account line encumbrance amount to be converted
CC_ACCT_VERSION_NUM NUMBER
Yes Contract commitment version number
CC_ACCT_VERSION_ACTION VARCHAR2 (1) Yes Contract commitment version action
CONVERSION_TYPE VARCHAR2 (30)
Conversion type used for converting between currencies
CONVERSION_DATE DATE

Conversion date used for converting the currencies
CONVERSION_RATE NUMBER

Conversion rate used for converting the currencies
CC_FUNC_WITHHELD_AMT NUMBER

Withheld Amount in the Functional Currency
Query Text

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


SELECT CC_ACCT_LINE_ID
,      SET_OF_BOOKS_ID
,      CC_ACCT_FUNC_AMT
,      CC_ACCT_ENCMBRNC_AMT
,      CC_ACCT_VERSION_NUM
,      CC_ACCT_VERSION_ACTION
,      CONVERSION_TYPE
,      CONVERSION_DATE
,      CONVERSION_RATE
,      CC_FUNC_WITHHELD_AMT
FROM IGC.IGC_CC_MC_ACCT_LINE_HISTORY;

Dependencies

[top of page]

IGC.IGC_CC_MC_ACCT_LINE_HISTORY does not reference any database object

IGC.IGC_CC_MC_ACCT_LINE_HISTORY is referenced by following:

SchemaAPPS
SynonymIGC_CC_MC_ACCT_LINE_HISTORY