[Home] [Help] [Dependency Information]
Object Name: | IGI_INT_FILE |
---|---|
Object Type: | TABLE |
Owner: | IGI |
FND Design Data: | IGI.IGI_INT_FILE |
Subobject Name: | |
Status: | VALID |
IGI_INT_FILE stores details of transfer files, each of which supplies one or more journals.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
IGI_INT_FILE_PK | NORMAL | UNIQUE | APPS_TS_TX_IDX | INTERFACE_FILE_ID |
IGI_INT_FILE_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
TRANSMISSION_NUMBER
USER_JE_SOURCE_NAME |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
RECORD_TYPE | VARCHAR2 | (2) | Yes | Record type. FH indicates File Header. |
INTERFACE_FILE_ID | NUMBER | Yes | Interface file identifier | |
USER_JE_SOURCE_NAME | VARCHAR2 | (25) | Yes | Journal entry source user-defined name |
SOURCE_PERIOD_NAME | VARCHAR2 | (15) | Yes | Feeder system accounting period |
TRANSMISSION_NUMBER | VARCHAR2 | (75) | Yes | Feeder system file identifier |
FEEDER_BOOK_ID | VARCHAR2 | (25) | Yes | Feeder book identifier |
STATUS | VARCHAR2 | (1) | Yes | Status |
IGI_INT_FILE_FEEDER_BOOK_ID | VARCHAR2 | (25) | Link to the Feeder Book identifier |
Cut, paste (and edit) the following text to query this object:
SELECT RECORD_TYPE
, INTERFACE_FILE_ID
, USER_JE_SOURCE_NAME
, SOURCE_PERIOD_NAME
, TRANSMISSION_NUMBER
, FEEDER_BOOK_ID
, STATUS
, IGI_INT_FILE_FEEDER_BOOK_ID
FROM IGI.IGI_INT_FILE;
IGI.IGI_INT_FILE does not reference any database object
IGI.IGI_INT_FILE is referenced by following:
|
|
|