[Home] [Help] [Dependency Information]
Object Name: | OKL_SIF_LINES# |
---|---|
Object Type: | VIEW |
Owner: | OKL |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ID | NUMBER | Yes | ||
STATE_DEPRE_DMNSHING_VALUE_RT | NUMBER | (5) | ||
BOOK_DEPRE_DMNSHING_VALUE_RT | NUMBER | (5) | ||
RESIDUAL_GUARANTEE_METHOD | VARCHAR2 | (30) | ||
FED_DEPRE_TERM | NUMBER | (4) | ||
FED_DEPRE_DMNSHING_VALUE_RATE | NUMBER | (5) | ||
FED_DEPRE_ADR_CONVE | VARCHAR2 | (80) | ||
STATE_DEPRE_BASIS_PERCENT | NUMBER | |||
STATE_DEPRE_METHOD | VARCHAR2 | (80) | ||
PURCHASE_OPTION | VARCHAR2 | (30) | ||
ASSET_COST | NUMBER | (14) | ||
STATE_DEPRE_TERM | NUMBER | (4) | ||
STATE_DEPRE_ADR_CONVENT | VARCHAR2 | (80) | ||
FED_DEPRE_METHOD | VARCHAR2 | (80) | ||
RESIDUAL_AMOUNT | NUMBER | (14) | ||
FED_DEPRE_SALVAGE | NUMBER | |||
DATE_FED_DEPRE | DATE | |||
BOOK_SALVAGE | NUMBER | |||
BOOK_ADR_CONVENTION | VARCHAR2 | (80) | ||
STATE_DEPRE_SALVAGE | NUMBER | |||
FED_DEPRE_BASIS_PERCENT | NUMBER | |||
BOOK_BASIS_PERCENT | NUMBER | |||
DATE_DELIVERY | DATE | |||
BOOK_TERM | NUMBER | (4) | ||
RESIDUAL_GUARANTEE_AMOUNT | NUMBER | (14) | ||
DATE_FUNDING | DATE | |||
DATE_BOOK | DATE | |||
DATE_STATE_DEPRE | DATE | |||
BOOK_METHOD | VARCHAR2 | (80) | ||
INDEX_NUMBER | NUMBER | Yes | ||
DESCRIPTION | VARCHAR2 | (1995) | ||
DATE_START | DATE | |||
DATE_LENDING | DATE | |||
PURCHASE_OPTION_AMOUNT | NUMBER | (14) | ||
OBJECT_VERSION_NUMBER | NUMBER | (9) | Yes | |
SIF_ID | NUMBER | Yes | ||
KLE_ID | NUMBER | Yes | ||
SIL_TYPE | VARCHAR2 | (10) | Yes | |
RESIDUAL_GUARANTEE_TYPE | VARCHAR2 | (200) | ||
STREAM_INTERFACE_ATTRIBUTE01 | VARCHAR2 | (450) | ||
STREAM_INTERFACE_ATTRIBUTE02 | VARCHAR2 | (450) | ||
STREAM_INTERFACE_ATTRIBUTE03 | VARCHAR2 | (450) | ||
STREAM_INTERFACE_ATTRIBUTE04 | VARCHAR2 | (450) | ||
STREAM_INTERFACE_ATTRIBUTE05 | VARCHAR2 | (450) | ||
STREAM_INTERFACE_ATTRIBUTE06 | VARCHAR2 | (450) | ||
STREAM_INTERFACE_ATTRIBUTE07 | VARCHAR2 | (450) | ||
STREAM_INTERFACE_ATTRIBUTE08 | VARCHAR2 | (450) | ||
STREAM_INTERFACE_ATTRIBUTE09 | VARCHAR2 | (450) | ||
STREAM_INTERFACE_ATTRIBUTE10 | VARCHAR2 | (450) | ||
STREAM_INTERFACE_ATTRIBUTE11 | VARCHAR2 | (450) | ||
STREAM_INTERFACE_ATTRIBUTE12 | VARCHAR2 | (450) | ||
STREAM_INTERFACE_ATTRIBUTE13 | VARCHAR2 | (450) | ||
STREAM_INTERFACE_ATTRIBUTE14 | VARCHAR2 | (450) | ||
STREAM_INTERFACE_ATTRIBUTE15 | VARCHAR2 | (450) | ||
CREATED_BY | NUMBER | (15) | Yes | |
CREATION_DATE | DATE | Yes | ||
LAST_UPDATED_BY | NUMBER | (15) | Yes | |
LAST_UPDATE_DATE | DATE | Yes | ||
LAST_UPDATE_LOGIN | NUMBER | (15) | ||
RESIDUAL_DATE | DATE | |||
DOWN_PAYMENT_AMOUNT | NUMBER | |||
CAPITALIZE_DOWN_PAYMENT_YN | VARCHAR2 | (30) | ||
ORIG_CONTRACT_LINE_ID | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT ID
, STATE_DEPRE_DMNSHING_VALUE_RT
, BOOK_DEPRE_DMNSHING_VALUE_RT
, RESIDUAL_GUARANTEE_METHOD
, FED_DEPRE_TERM
, FED_DEPRE_DMNSHING_VALUE_RATE
, FED_DEPRE_ADR_CONVE
, STATE_DEPRE_BASIS_PERCENT
, STATE_DEPRE_METHOD
, PURCHASE_OPTION
, ASSET_COST
, STATE_DEPRE_TERM
, STATE_DEPRE_ADR_CONVENT
, FED_DEPRE_METHOD
, RESIDUAL_AMOUNT
, FED_DEPRE_SALVAGE
, DATE_FED_DEPRE
, BOOK_SALVAGE
, BOOK_ADR_CONVENTION
, STATE_DEPRE_SALVAGE
, FED_DEPRE_BASIS_PERCENT
, BOOK_BASIS_PERCENT
, DATE_DELIVERY
, BOOK_TERM
, RESIDUAL_GUARANTEE_AMOUNT
, DATE_FUNDING
, DATE_BOOK
, DATE_STATE_DEPRE
, BOOK_METHOD
, INDEX_NUMBER
, DESCRIPTION
, DATE_START
, DATE_LENDING
, PURCHASE_OPTION_AMOUNT
, OBJECT_VERSION_NUMBER
, SIF_ID
, KLE_ID
, SIL_TYPE
, RESIDUAL_GUARANTEE_TYPE
, STREAM_INTERFACE_ATTRIBUTE01
, STREAM_INTERFACE_ATTRIBUTE02
, STREAM_INTERFACE_ATTRIBUTE03
, STREAM_INTERFACE_ATTRIBUTE04
, STREAM_INTERFACE_ATTRIBUTE05
, STREAM_INTERFACE_ATTRIBUTE06
, STREAM_INTERFACE_ATTRIBUTE07
, STREAM_INTERFACE_ATTRIBUTE08
, STREAM_INTERFACE_ATTRIBUTE09
, STREAM_INTERFACE_ATTRIBUTE10
, STREAM_INTERFACE_ATTRIBUTE11
, STREAM_INTERFACE_ATTRIBUTE12
, STREAM_INTERFACE_ATTRIBUTE13
, STREAM_INTERFACE_ATTRIBUTE14
, STREAM_INTERFACE_ATTRIBUTE15
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, RESIDUAL_DATE
, DOWN_PAYMENT_AMOUNT
, CAPITALIZE_DOWN_PAYMENT_YN
, ORIG_CONTRACT_LINE_ID
FROM OKL.OKL_SIF_LINES#;
|
|
|