[Home] [Help] [Dependency Information]
Object Name: | IGI_IMP_IAC_EXCEP_REP_ITF |
---|---|
Object Type: | TABLE |
Owner: | IGI |
Subobject Name: | |
Status: | VALID |
Asset Exception Report interface table
Tablespace: | APPS_TS_INTERFACE |
---|---|
PCT Free: | 10 |
PCT Used: |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
REQUEST_ID | NUMBER | Request_ID-Primary Key for the table. | ||
SOB_BOOK | VARCHAR2 | (30) | Foreign key to GL_SET_OF_BOOKS.If this is included the set of books name and the Functional Currency can be displayed in the report output. | |
ORGANISATION_NAME | VARCHAR2 | (30) | Enterprise Name | |
CORP_BOOK | VARCHAR2 | (15) | Asset Corporate Book | |
TAX_BOOK | VARCHAR2 | (15) | Asset Tax Book | |
PERIOD | VARCHAR2 | (30) | Period Name | |
FISCAL_YEAR_NAME | VARCHAR2 | (30) | Fiscal Year Name | |
WARNING_MESSAGE | VARCHAR2 | (100) | Warning Message | |
WARNING_MESSAGE_CODE | VARCHAR2 | (1) | Message Code | |
ASSET_NUMBER | VARCHAR2 | (15) | Sort in ascending order | |
ASSET_DESCRIPTION | VARCHAR2 | (80) | Asset Description | |
FUNCTIONAL_CURRENCY_CODE | VARCHAR2 | (15) | Functional Currency Code | |
DPIS_CORP | DATE | DPIS (Corp) | ||
DPIS_TAX | DATE | DPIS (MHCA) | ||
ASSET_LIFE_CORP | NUMBER | (15) | Asset Life (corp) | |
ASSET_LIFE_TAX | NUMBER | (15) | Asset Life (MHCA) | |
CONCAT_CATEGORY | VARCHAR2 | (600) | Concatenated Category Description | |
HIST_COST_CORP | NUMBER | Historic Cost (corp) | ||
HIST_COST_TAX | NUMBER | Historic Cost (MHCA) | ||
SALVAGE_VALUE_CORP | NUMBER | Salvage value (corp) | ||
SALVAGE_VALUE_TAX | NUMBER | Salvage value (MHCA) | ||
CREATION_DATE | DATE | Creation Date | ||
LAST_UPDATE_LOGIN | NUMBER | Last Update Login | ||
LAST_UPDATED_BY | NUMBER | (15) | Last Updated By | |
LSAT_UPDATE_DATE | DATE | Last Update Date |
Cut, paste (and edit) the following text to query this object:
SELECT REQUEST_ID
, SOB_BOOK
, ORGANISATION_NAME
, CORP_BOOK
, TAX_BOOK
, PERIOD
, FISCAL_YEAR_NAME
, WARNING_MESSAGE
, WARNING_MESSAGE_CODE
, ASSET_NUMBER
, ASSET_DESCRIPTION
, FUNCTIONAL_CURRENCY_CODE
, DPIS_CORP
, DPIS_TAX
, ASSET_LIFE_CORP
, ASSET_LIFE_TAX
, CONCAT_CATEGORY
, HIST_COST_CORP
, HIST_COST_TAX
, SALVAGE_VALUE_CORP
, SALVAGE_VALUE_TAX
, CREATION_DATE
, LAST_UPDATE_LOGIN
, LAST_UPDATED_BY
, LSAT_UPDATE_DATE
FROM IGI.IGI_IMP_IAC_EXCEP_REP_ITF;
IGI.IGI_IMP_IAC_EXCEP_REP_ITF does not reference any database object
IGI.IGI_IMP_IAC_EXCEP_REP_ITF is referenced by following:
|
|
|