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

TABLE: IGI.IGI_INT_HEADER

Object Details
Object Name: IGI_INT_HEADER
Object Type: TABLE
Owner: IGI
FND Design Data: TableIGI.IGI_INT_HEADER
Subobject Name:
Status: VALID


IGI_INT_HEADER stores the Journal Header information from the feeder system.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
IGI_INT_HEADER_PK NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnINTERFACE_HEADER_ID
Columns
Name Datatype Length Mandatory Comments
RECORD_TYPE VARCHAR2 (2) Yes Record type. JH indicates Journal Header.
INTERFACE_FILE_ID NUMBER
Yes Interface file identifier
INTERFACE_HEADER_ID NUMBER
Yes Interface header identifier
USER_JE_CATEGORY_NAME VARCHAR2 (25) Yes Journal entry category user defined name
REVERSE_FLAG VARCHAR2 (1) Yes Reverse flag
REVERSE_PERIOD_OFFSET NUMBER
Yes Reverse period offset
ACTUAL_FLAG VARCHAR2 (1) Yes Transaction type. Values are A for Actual and E for Encumbrance.
ENCUMBRANCE_TYPE_ID NUMBER

Purchasing encumbrance type identifier
CURRENCY_CODE VARCHAR2 (10) Yes Currency code
CURRENCY_CONVERSION_DATE DATE

Exchange rate date
CURRENCY_CONVERSION_TYPE VARCHAR2 (30)
Exchange rate type
CURRENCY_CONVERSION_RATE NUMBER

Foreign currency exchange rate
Query Text

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


SELECT RECORD_TYPE
,      INTERFACE_FILE_ID
,      INTERFACE_HEADER_ID
,      USER_JE_CATEGORY_NAME
,      REVERSE_FLAG
,      REVERSE_PERIOD_OFFSET
,      ACTUAL_FLAG
,      ENCUMBRANCE_TYPE_ID
,      CURRENCY_CODE
,      CURRENCY_CONVERSION_DATE
,      CURRENCY_CONVERSION_TYPE
,      CURRENCY_CONVERSION_RATE
FROM IGI.IGI_INT_HEADER;

Dependencies

[top of page]

IGI.IGI_INT_HEADER does not reference any database object

IGI.IGI_INT_HEADER is referenced by following:

SchemaAPPS
SynonymIGI_INT_HEADER