[Home] [Help] [Dependency Information]
Object Name: | OKL_SIF_FEES# |
---|---|
Object Type: | VIEW |
Owner: | OKL |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ID | NUMBER | Yes | ||
SFE_TYPE | VARCHAR2 | (10) | Yes | |
DATE_START | DATE | |||
DATE_PAID | DATE | |||
AMOUNT | NUMBER | |||
IDC_ACCOUNTING_FLAG | VARCHAR2 | (10) | ||
INCOME_OR_EXPENSE | VARCHAR2 | (10) | Yes | |
DESCRIPTION | VARCHAR2 | (1995) | ||
FEE_INDEX_NUMBER | NUMBER | Yes | ||
LEVEL_INDEX_NUMBER | NUMBER | (3) | ||
ADVANCE_OR_ARREARS | VARCHAR2 | (10) | Yes | |
LEVEL_TYPE | VARCHAR2 | (30) | ||
LOCK_LEVEL_STEP | VARCHAR2 | (10) | ||
PERIOD | VARCHAR2 | (30) | ||
NUMBER_OF_PERIODS | NUMBER | (6) | ||
LEVEL_LINE_NUMBER | NUMBER | (5) | ||
SIF_ID | NUMBER | |||
KLE_ID | NUMBER | |||
SIL_ID | NUMBER | |||
RATE | NUMBER | (18) | ||
OBJECT_VERSION_NUMBER | NUMBER | (9) | Yes | |
STRUCTURE | VARCHAR2 | (200) | ||
DAYS_IN_PERIOD | NUMBER | |||
QUERY_LEVEL_YN | VARCHAR2 | (10) | ||
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) | ||
STREAM_INTERFACE_ATTRIBUTE16 | VARCHAR2 | (450) | ||
STREAM_INTERFACE_ATTRIBUTE17 | VARCHAR2 | (450) | ||
STREAM_INTERFACE_ATTRIBUTE18 | VARCHAR2 | (450) | ||
STREAM_INTERFACE_ATTRIBUTE19 | VARCHAR2 | (450) | ||
STREAM_INTERFACE_ATTRIBUTE20 | VARCHAR2 | (450) | ||
CREATED_BY | NUMBER | (15) | Yes | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | |
CREATION_DATE | DATE | Yes | ||
LAST_UPDATE_DATE | DATE | Yes | ||
LAST_UPDATE_LOGIN | NUMBER | (15) | ||
CASH_EFFECT_YN | VARCHAR2 | (3) | ||
TAX_EFFECT_YN | VARCHAR2 | (3) | ||
DAYS_IN_MONTH | VARCHAR2 | (30) | ||
DAYS_IN_YEAR | VARCHAR2 | (240) | ||
BALANCE_TYPE_CODE | VARCHAR2 | (30) | ||
DOWN_PAYMENT_AMOUNT | NUMBER | |||
ORIG_CONTRACT_LINE_ID | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT ID
, SFE_TYPE
, DATE_START
, DATE_PAID
, AMOUNT
, IDC_ACCOUNTING_FLAG
, INCOME_OR_EXPENSE
, DESCRIPTION
, FEE_INDEX_NUMBER
, LEVEL_INDEX_NUMBER
, ADVANCE_OR_ARREARS
, LEVEL_TYPE
, LOCK_LEVEL_STEP
, PERIOD
, NUMBER_OF_PERIODS
, LEVEL_LINE_NUMBER
, SIF_ID
, KLE_ID
, SIL_ID
, RATE
, OBJECT_VERSION_NUMBER
, STRUCTURE
, DAYS_IN_PERIOD
, QUERY_LEVEL_YN
, 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
, STREAM_INTERFACE_ATTRIBUTE16
, STREAM_INTERFACE_ATTRIBUTE17
, STREAM_INTERFACE_ATTRIBUTE18
, STREAM_INTERFACE_ATTRIBUTE19
, STREAM_INTERFACE_ATTRIBUTE20
, CREATED_BY
, LAST_UPDATED_BY
, CREATION_DATE
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, CASH_EFFECT_YN
, TAX_EFFECT_YN
, DAYS_IN_MONTH
, DAYS_IN_YEAR
, BALANCE_TYPE_CODE
, DOWN_PAYMENT_AMOUNT
, ORIG_CONTRACT_LINE_ID
FROM OKL.OKL_SIF_FEES#;
|
|
|