[Home] [Help] [Dependency Information]
Object Name: | IGI_INT_FOOTER |
---|---|
Object Type: | TABLE |
Owner: | IGI |
FND Design Data: | IGI.IGI_INT_FOOTER |
Subobject Name: | |
Status: | VALID |
IGI_INT_FOOTER stores the check totals for each transfer file.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
IGI_INT_FOOTER_PK | NORMAL | UNIQUE | APPS_TS_TX_IDX | INTERFACE_FILE_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
RECORD_TYPE | VARCHAR2 | (2) | Yes | Record type. FF indicates File Footer. |
INTERFACE_FILE_ID | NUMBER | Yes | Interface file identifier | |
TOTAL_AMOUNT | NUMBER | Yes | Total amount | |
RECORD_COUNT | NUMBER | Yes | Number count |
Cut, paste (and edit) the following text to query this object:
SELECT RECORD_TYPE
, INTERFACE_FILE_ID
, TOTAL_AMOUNT
, RECORD_COUNT
FROM IGI.IGI_INT_FOOTER;
IGI.IGI_INT_FOOTER does not reference any database object
IGI.IGI_INT_FOOTER is referenced by following:
|
|
|