[Home] [Help] [Dependency Information]
Object Name: | IGI_IMP_IAC_ITF# |
---|---|
Object Type: | VIEW |
Owner: | IGI |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
BOOK_TYPE_CODE | VARCHAR2 | (15) | ||
REQUEST_ID | NUMBER | (15) | ||
SET_OF_BOOKS_ID | NUMBER | (15) | ||
ASSET_ID | NUMBER | (15) | ||
CATEGORY_ID | NUMBER | (15) | ||
DISTRIBUTION_ID | NUMBER | (15) | ||
FUNCTIONAL_CURRENCY_CODE | VARCHAR2 | (15) | ||
FISCAL_YEAR_NAME | VARCHAR2 | (15) | ||
PERIOD | VARCHAR2 | (15) | ||
COST_CENTER | VARCHAR2 | (30) | ||
ASSET_NUMBER | VARCHAR2 | (15) | ||
ASSET_DESCRIPTION | VARCHAR2 | (80) | ||
MAJOR_CATEGORY | VARCHAR2 | (30) | ||
MINOR_CATEGORY | VARCHAR2 | (30) | ||
CONCAT_CATEGORY | VARCHAR2 | (80) | ||
REVAL_COST | NUMBER | |||
NET_REVAL_RESERVE | NUMBER | |||
REVAL_RES_BLOG | NUMBER | |||
REVAL_YTD_DEPRN | NUMBER | |||
REVAL_DEPRN_RESERVE | NUMBER | |||
OPER_ACCT | NUMBER | |||
OPER_EXP_BACKLOG | NUMBER | |||
GENERAL_FUND | NUMBER | |||
PARENT_NO | NUMBER | (15) | ||
CURR_REVAL_FACTOR | NUMBER | |||
CUMM_REVAL_FACTOR | NUMBER | |||
ASSET_TAG | VARCHAR2 | (15) | ||
BALANCING_SEGMENT | VARCHAR2 | (30) | ||
SERIAL_NO | VARCHAR2 | (35) | ||
DPIS | DATE | |||
LIFE_MONTHS | NUMBER | |||
STL_RATE | NUMBER | |||
DEPRECIATION_METHOD | VARCHAR2 | (30) | ||
CONC_ASSET_KEY | VARCHAR2 | (80) | ||
CONC_LOCATION | VARCHAR2 | (80) | ||
COST_ACCT | VARCHAR2 | (25) | ||
IAC_REVAL_RESV_ACCT | VARCHAR2 | (25) | ||
DEPRN_RES_ACCT | VARCHAR2 | (25) | ||
DEPRN_BACKLOG_ACCT | VARCHAR2 | (25) | ||
GEN_FUND_ACCT | VARCHAR2 | (25) | ||
DEPRN_EXP_ACCT | VARCHAR2 | (25) | ||
OPER_EXP_ACCT | VARCHAR2 | (25) | ||
HIST_COST | NUMBER | |||
HIST_YTD_DEPRN | NUMBER | |||
HIST_ACC_DEPRN | NUMBER | |||
ORGANIZATION_NAME | VARCHAR2 | (80) | ||
CREATED_BY | NUMBER | (15) | ||
CREATION_DATE | DATE | |||
LAST_UPDATE_LOGIN | NUMBER | (15) | ||
LAST_UPDATED_BY | NUMBER | (15) | ||
LAST_UPDATE_DATE | DATE |
Cut, paste (and edit) the following text to query this object:
SELECT BOOK_TYPE_CODE
, REQUEST_ID
, SET_OF_BOOKS_ID
, ASSET_ID
, CATEGORY_ID
, DISTRIBUTION_ID
, FUNCTIONAL_CURRENCY_CODE
, FISCAL_YEAR_NAME
, PERIOD
, COST_CENTER
, ASSET_NUMBER
, ASSET_DESCRIPTION
, MAJOR_CATEGORY
, MINOR_CATEGORY
, CONCAT_CATEGORY
, REVAL_COST
, NET_REVAL_RESERVE
, REVAL_RES_BLOG
, REVAL_YTD_DEPRN
, REVAL_DEPRN_RESERVE
, OPER_ACCT
, OPER_EXP_BACKLOG
, GENERAL_FUND
, PARENT_NO
, CURR_REVAL_FACTOR
, CUMM_REVAL_FACTOR
, ASSET_TAG
, BALANCING_SEGMENT
, SERIAL_NO
, DPIS
, LIFE_MONTHS
, STL_RATE
, DEPRECIATION_METHOD
, CONC_ASSET_KEY
, CONC_LOCATION
, COST_ACCT
, IAC_REVAL_RESV_ACCT
, DEPRN_RES_ACCT
, DEPRN_BACKLOG_ACCT
, GEN_FUND_ACCT
, DEPRN_EXP_ACCT
, OPER_EXP_ACCT
, HIST_COST
, HIST_YTD_DEPRN
, HIST_ACC_DEPRN
, ORGANIZATION_NAME
, CREATED_BY
, CREATION_DATE
, LAST_UPDATE_LOGIN
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
FROM IGI.IGI_IMP_IAC_ITF#;
|
|
|