VIEW: OKL.OKL_SIF_FEES#

Source

View Text - Preformatted

select ID ID, SFE_TYPE SFE_TYPE, DATE_START DATE_START, DATE_PAID DATE_PAID, AMOUNT#1 AMOUNT, IDC_ACCOUNTING_FLAG IDC_ACCOUNTING_FLAG, INCOME_OR_EXPENSE INCOME_OR_EXPENSE, DESCRIPTION DESCRIPTION, FEE_INDEX_NUMBER FEE_INDEX_NUMBER, LEVEL_INDEX_NUMBER LEVEL_INDEX_NUMBER, ADVANCE_OR_ARREARS ADVANCE_OR_ARREARS, LEVEL_TYPE LEVEL_TYPE, LOCK_LEVEL_STEP LOCK_LEVEL_STEP, PERIOD PERIOD, NUMBER_OF_PERIODS NUMBER_OF_PERIODS, LEVEL_LINE_NUMBER LEVEL_LINE_NUMBER, SIF_ID SIF_ID, KLE_ID KLE_ID, SIL_ID SIL_ID, RATE RATE, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, STRUCTURE STRUCTURE, DAYS_IN_PERIOD DAYS_IN_PERIOD, QUERY_LEVEL_YN QUERY_LEVEL_YN, STREAM_INTERFACE_ATTRIBUTE01 STREAM_INTERFACE_ATTRIBUTE01, STREAM_INTERFACE_ATTRIBUTE02 STREAM_INTERFACE_ATTRIBUTE02, STREAM_INTERFACE_ATTRIBUTE03 STREAM_INTERFACE_ATTRIBUTE03, STREAM_INTERFACE_ATTRIBUTE04 STREAM_INTERFACE_ATTRIBUTE04, STREAM_INTERFACE_ATTRIBUTE05 STREAM_INTERFACE_ATTRIBUTE05, STREAM_INTERFACE_ATTRIBUTE06 STREAM_INTERFACE_ATTRIBUTE06, STREAM_INTERFACE_ATTRIBUTE07 STREAM_INTERFACE_ATTRIBUTE07, STREAM_INTERFACE_ATTRIBUTE08 STREAM_INTERFACE_ATTRIBUTE08, STREAM_INTERFACE_ATTRIBUTE09 STREAM_INTERFACE_ATTRIBUTE09, STREAM_INTERFACE_ATTRIBUTE10 STREAM_INTERFACE_ATTRIBUTE10, STREAM_INTERFACE_ATTRIBUTE11 STREAM_INTERFACE_ATTRIBUTE11, STREAM_INTERFACE_ATTRIBUTE12 STREAM_INTERFACE_ATTRIBUTE12, STREAM_INTERFACE_ATTRIBUTE13 STREAM_INTERFACE_ATTRIBUTE13, STREAM_INTERFACE_ATTRIBUTE14 STREAM_INTERFACE_ATTRIBUTE14, STREAM_INTERFACE_ATTRIBUTE15 STREAM_INTERFACE_ATTRIBUTE15, STREAM_INTERFACE_ATTRIBUTE16 STREAM_INTERFACE_ATTRIBUTE16, STREAM_INTERFACE_ATTRIBUTE17 STREAM_INTERFACE_ATTRIBUTE17, STREAM_INTERFACE_ATTRIBUTE18 STREAM_INTERFACE_ATTRIBUTE18, STREAM_INTERFACE_ATTRIBUTE19 STREAM_INTERFACE_ATTRIBUTE19, STREAM_INTERFACE_ATTRIBUTE20 STREAM_INTERFACE_ATTRIBUTE20, CREATED_BY CREATED_BY, LAST_UPDATED_BY LAST_UPDATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, CASH_EFFECT_YN CASH_EFFECT_YN, TAX_EFFECT_YN TAX_EFFECT_YN, DAYS_IN_MONTH DAYS_IN_MONTH, DAYS_IN_YEAR DAYS_IN_YEAR, BALANCE_TYPE_CODE BALANCE_TYPE_CODE, DOWN_PAYMENT_AMOUNT DOWN_PAYMENT_AMOUNT, ORIG_CONTRACT_LINE_ID ORIG_CONTRACT_LINE_ID from "OKL"."OKL_SIF_FEES"

View Text - HTML Formatted

SELECT ID ID
, SFE_TYPE SFE_TYPE
, DATE_START DATE_START
, DATE_PAID DATE_PAID
, AMOUNT#1 AMOUNT
, IDC_ACCOUNTING_FLAG IDC_ACCOUNTING_FLAG
, INCOME_OR_EXPENSE INCOME_OR_EXPENSE
, DESCRIPTION DESCRIPTION
, FEE_INDEX_NUMBER FEE_INDEX_NUMBER
, LEVEL_INDEX_NUMBER LEVEL_INDEX_NUMBER
, ADVANCE_OR_ARREARS ADVANCE_OR_ARREARS
, LEVEL_TYPE LEVEL_TYPE
, LOCK_LEVEL_STEP LOCK_LEVEL_STEP
, PERIOD PERIOD
, NUMBER_OF_PERIODS NUMBER_OF_PERIODS
, LEVEL_LINE_NUMBER LEVEL_LINE_NUMBER
, SIF_ID SIF_ID
, KLE_ID KLE_ID
, SIL_ID SIL_ID
, RATE RATE
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, STRUCTURE STRUCTURE
, DAYS_IN_PERIOD DAYS_IN_PERIOD
, QUERY_LEVEL_YN QUERY_LEVEL_YN
, STREAM_INTERFACE_ATTRIBUTE01 STREAM_INTERFACE_ATTRIBUTE01
, STREAM_INTERFACE_ATTRIBUTE02 STREAM_INTERFACE_ATTRIBUTE02
, STREAM_INTERFACE_ATTRIBUTE03 STREAM_INTERFACE_ATTRIBUTE03
, STREAM_INTERFACE_ATTRIBUTE04 STREAM_INTERFACE_ATTRIBUTE04
, STREAM_INTERFACE_ATTRIBUTE05 STREAM_INTERFACE_ATTRIBUTE05
, STREAM_INTERFACE_ATTRIBUTE06 STREAM_INTERFACE_ATTRIBUTE06
, STREAM_INTERFACE_ATTRIBUTE07 STREAM_INTERFACE_ATTRIBUTE07
, STREAM_INTERFACE_ATTRIBUTE08 STREAM_INTERFACE_ATTRIBUTE08
, STREAM_INTERFACE_ATTRIBUTE09 STREAM_INTERFACE_ATTRIBUTE09
, STREAM_INTERFACE_ATTRIBUTE10 STREAM_INTERFACE_ATTRIBUTE10
, STREAM_INTERFACE_ATTRIBUTE11 STREAM_INTERFACE_ATTRIBUTE11
, STREAM_INTERFACE_ATTRIBUTE12 STREAM_INTERFACE_ATTRIBUTE12
, STREAM_INTERFACE_ATTRIBUTE13 STREAM_INTERFACE_ATTRIBUTE13
, STREAM_INTERFACE_ATTRIBUTE14 STREAM_INTERFACE_ATTRIBUTE14
, STREAM_INTERFACE_ATTRIBUTE15 STREAM_INTERFACE_ATTRIBUTE15
, STREAM_INTERFACE_ATTRIBUTE16 STREAM_INTERFACE_ATTRIBUTE16
, STREAM_INTERFACE_ATTRIBUTE17 STREAM_INTERFACE_ATTRIBUTE17
, STREAM_INTERFACE_ATTRIBUTE18 STREAM_INTERFACE_ATTRIBUTE18
, STREAM_INTERFACE_ATTRIBUTE19 STREAM_INTERFACE_ATTRIBUTE19
, STREAM_INTERFACE_ATTRIBUTE20 STREAM_INTERFACE_ATTRIBUTE20
, CREATED_BY CREATED_BY
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CASH_EFFECT_YN CASH_EFFECT_YN
, TAX_EFFECT_YN TAX_EFFECT_YN
, DAYS_IN_MONTH DAYS_IN_MONTH
, DAYS_IN_YEAR DAYS_IN_YEAR
, BALANCE_TYPE_CODE BALANCE_TYPE_CODE
, DOWN_PAYMENT_AMOUNT DOWN_PAYMENT_AMOUNT
, ORIG_CONTRACT_LINE_ID ORIG_CONTRACT_LINE_ID
FROM "OKL"."OKL_SIF_FEES"