VIEW: OKL.OKL_LINES_INTERFACE#

Source

View Text - Preformatted

select CONTRACT_NUMBER_OLD CONTRACT_NUMBER_OLD, LINE_NUMBER LINE_NUMBER, LINE_TYPE LINE_TYPE, ASSET_NUMBER ASSET_NUMBER, LINK_ASSET_NUMBER LINK_ASSET_NUMBER, ORIGINAL_COST ORIGINAL_COST, TOTAL_UNITS TOTAL_UNITS, AMOUNT AMOUNT, STATUS STATUS, DATE_APPROVED DATE_APPROVED, DATE_SIGNED DATE_SIGNED, CURRENCY_CODE CURRENCY_CODE, INVENTORY_ORGANIZATION_NAME INVENTORY_ORGANIZATION_NAME, INVENTORY_ORGANIZATION_ID INVENTORY_ORGANIZATION_ID, INVENTORY_ITEM_NAME INVENTORY_ITEM_NAME, INVENTORY_ITEM_ID INVENTORY_ITEM_ID, DESCRIPTION DESCRIPTION, MODEL MODEL, MAKE MAKE, YEAR_OF_MANUFACTURE YEAR_OF_MANUFACTURE, INSTALL_SITE_NUMBER INSTALL_SITE_NUMBER, INSTALL_SITE_ID INSTALL_SITE_ID, RESIDUAL_PERCENT RESIDUAL_PERCENT, RESIDUAL_AMOUNT RESIDUAL_AMOUNT, RESIDUAL_AMOUNT_GUARANTEE RESIDUAL_AMOUNT_GUARANTEE, RESIDUAL_AMOUNT_GUARANTEE_PV RESIDUAL_AMOUNT_GUARANTEE_PV, GUARANTOR_TYPE_CODE GUARANTOR_TYPE_CODE, TRADE_IN_AMOUNT TRADE_IN_AMOUNT, CAPITAL_REDUCTION_PERCENT CAPITAL_REDUCTION_PERCENT, CAPITAL_REDUCTION_AMOUNT CAPITAL_REDUCTION_AMOUNT, INTERIM_INT_CAPITALIZED_AMT INTERIM_INT_CAPITALIZED_AMT, ASSET_CORPORATE_BOOK ASSET_CORPORATE_BOOK, ASSET_CATEGORY_SEGMENT1 ASSET_CATEGORY_SEGMENT1, ASSET_CATEGORY_SEGMENT2 ASSET_CATEGORY_SEGMENT2, ASSET_CATEGORY_SEGMENT3 ASSET_CATEGORY_SEGMENT3, ASSET_CATEGORY_SEGMENT4 ASSET_CATEGORY_SEGMENT4, ASSET_CATEGORY_SEGMENT5 ASSET_CATEGORY_SEGMENT5, ASSET_CATEGORY_SEGMENT6 ASSET_CATEGORY_SEGMENT6, ASSET_CATEGORY_SEGMENT7 ASSET_CATEGORY_SEGMENT7, ASSET_CATEGORY_ID ASSET_CATEGORY_ID, ASSET_LOCATION_SEGMENT1 ASSET_LOCATION_SEGMENT1, ASSET_LOCATION_SEGMENT2 ASSET_LOCATION_SEGMENT2, ASSET_LOCATION_SEGMENT3 ASSET_LOCATION_SEGMENT3, ASSET_LOCATION_SEGMENT4 ASSET_LOCATION_SEGMENT4, ASSET_LOCATION_SEGMENT5 ASSET_LOCATION_SEGMENT5, ASSET_LOCATION_SEGMENT6 ASSET_LOCATION_SEGMENT6, ASSET_LOCATION_SEGMENT7 ASSET_LOCATION_SEGMENT7, ASSET_LOCATION_ID ASSET_LOCATION_ID, DEPRECIATION_METHOD_ID DEPRECIATION_METHOD_ID, DEPRECIATION_METHOD_CODE DEPRECIATION_METHOD_CODE, LIFE_IN_MONTHS LIFE_IN_MONTHS, DEPRECIATION_RATE DEPRECIATION_RATE, SALVAGE_VALUE SALVAGE_VALUE, SALVAGE_VALUE_PERCENT SALVAGE_VALUE_PERCENT, SALES_TAX_EXEMPT_FLAG SALES_TAX_EXEMPT_FLAG, SALES_TAX_EXEMPT_CERT_NUMBER SALES_TAX_EXEMPT_CERT_NUMBER, SALES_TAX_OVERRIDE_FLAG SALES_TAX_OVERRIDE_FLAG, SALES_TAX_OVERRIDE_RATE SALES_TAX_OVERRIDE_RATE, VAT_TAX_EXEMPT VAT_TAX_EXEMPT, VAT_TAX_EXEMPT_CERT_NUMBER VAT_TAX_EXEMPT_CERT_NUMBER, VAT_TAX_OVERRIDE_FLAG VAT_TAX_OVERRIDE_FLAG, VAT_TAX_OVERRIDE_RATE VAT_TAX_OVERRIDE_RATE, LIEN_TYPE LIEN_TYPE, LIEN_FILING_NUMBER LIEN_FILING_NUMBER, LIEN_FILING_DATE LIEN_FILING_DATE, LIEN_FILING_STATUS LIEN_FILING_STATUS, LIENHOLDER_ID LIENHOLDER_ID, LIENHOLDER_NUMBER LIENHOLDER_NUMBER, FILING_JURISDICTION FILING_JURISDICTION, FILING_SUB_JURISDICTION FILING_SUB_JURISDICTION, LIEN_EXPIRATION_DATE LIEN_EXPIRATION_DATE, LIEN_CONTINUATION_NUMBER LIEN_CONTINUATION_NUMBER, LIEN_CONTINUATION_DATE LIEN_CONTINUATION_DATE, TITLE_TYPE TITLE_TYPE, TITLE_ISSUER_NUMBER TITLE_ISSUER_NUMBER, TITLE_ISSUER_ID TITLE_ISSUER_ID, TITLE_DATE TITLE_DATE, TITLE_NUMBER TITLE_NUMBER, REGISTRATION_NUMBER REGISTRATION_NUMBER, ASSET_REGISTRATION_LOC_NAME ASSET_REGISTRATION_LOC_NAME, TITLE_CUSTODIAN_NAME TITLE_CUSTODIAN_NAME, PAYEE_SITE_NAME PAYEE_SITE_NAME, SERIAL_NUMBER SERIAL_NUMBER, VENDOR_INVOICE_NUMBER VENDOR_INVOICE_NUMBER, VENDOR_INVOICE_DATE VENDOR_INVOICE_DATE, SHIP_TO_SITE_NUMBER SHIP_TO_SITE_NUMBER, SHIP_TO_SITE_ID SHIP_TO_SITE_ID, START_DATE START_DATE, END_DATE END_DATE, PASSTHROUGH_PERCENT PASSTHROUGH_PERCENT, PASSTHROUGH_BASIS_CODE PASSTHROUGH_BASIS_CODE, FEE_CODE FEE_CODE, USAGE_ITEM_NAME USAGE_ITEM_NAME, USAGE_ITEM_ID USAGE_ITEM_ID, PRICE_LIST_NAME PRICE_LIST_NAME, PRICE_LIST_ID PRICE_LIST_ID, COUNTER_GROUP_NAME COUNTER_GROUP_NAME, COUNTER_GROUP_ID COUNTER_GROUP_ID, USAGE_BILL_FREQUENCY_CODE USAGE_BILL_FREQUENCY_CODE, MINIMUM_QTY_USAGE MINIMUM_QTY_USAGE, DEFAULT_QTY_USAGE DEFAULT_QTY_USAGE, AMCV_FLAG AMCV_FLAG, LEVEL_FLAG LEVEL_FLAG, BASE_READING BASE_READING, BASE_READING_UOM_CODE BASE_READING_UOM_CODE, REAL_EST_INIT_DIRECT_COST REAL_EST_INIT_DIRECT_COST, REAL_EST_OCCUPANCY REAL_EST_OCCUPANCY, REAL_EST_DATE_LAST_INSP REAL_EST_DATE_LAST_INSP, REAL_EST_DATE_NEXT_INSP REAL_EST_DATE_NEXT_INSP, REAL_EST_WTD_AVG_LIFE REAL_EST_WTD_AVG_LIFE, REAL_EST_BOND_EQ_YIELD REAL_EST_BOND_EQ_YIELD, REAL_EST_REFINANCE_AMT REAL_EST_REFINANCE_AMT, REAL_EST_CREDIT_TENANT_FLAG REAL_EST_CREDIT_TENANT_FLAG, REAL_EST_PROPERTY_CLASS_CODE REAL_EST_PROPERTY_CLASS_CODE, REAL_EST_COVERAGE_RATIO REAL_EST_COVERAGE_RATIO, REAL_EST_NET_CASH_FLOW REAL_EST_NET_CASH_FLOW, REAL_EST_FUNDING_CATG_CODE REAL_EST_FUNDING_CATG_CODE, REAL_EST_APPRAISAL_FLAG REAL_EST_APPRAISAL_FLAG, REAL_EST_APPRAISAL_DATE REAL_EST_APPRAISAL_DATE, REAL_EST_APPRAISAL_VALUE REAL_EST_APPRAISAL_VALUE, REAL_EST_CONCEPT_TYPE_CODE REAL_EST_CONCEPT_TYPE_CODE, REAL_EST_DEAL_TYPE_CODE REAL_EST_DEAL_TYPE_CODE, REAL_EST_GROSS_FOOTAGE REAL_EST_GROSS_FOOTAGE, REAL_EST_NET_FOOTAGE_RENTABLE REAL_EST_NET_FOOTAGE_RENTABLE, REAL_EST_LETTER_ACCEPT_DATE REAL_EST_LETTER_ACCEPT_DATE, REAL_EST_ACCEPT_EXPIRE_DATE REAL_EST_ACCEPT_EXPIRE_DATE, CAPITALIZED_INTEREST CAPITALIZED_INTEREST, TAX_COST TAX_COST, TAX_BOOK TAX_BOOK, LIFE_IN_MONTHS_TAX LIFE_IN_MONTHS_TAX, DEPRN_METHOD_TAX DEPRN_METHOD_TAX, DEPRN_RATE_TAX DEPRN_RATE_TAX, PAYMENT_TERM PAYMENT_TERM, PAYMENT_TERM_ID PAYMENT_TERM_ID, VENDOR_PAYSITE_ID VENDOR_PAYSITE_ID, VENDOR_PAYSITE_NAME VENDOR_PAYSITE_NAME, VENDOR_PAYMENT_METHOD VENDOR_PAYMENT_METHOD, FEE_EXP_NO_OF_PERIODS FEE_EXP_NO_OF_PERIODS, FEE_EXP_FREQUENCY FEE_EXP_FREQUENCY, FEE_EXP_AMOUNT_PER_PERIOD FEE_EXP_AMOUNT_PER_PERIOD, PROP_TAX_APPLICABLE PROP_TAX_APPLICABLE, PROP_TAX_LEASE_REP PROP_TAX_LEASE_REP, FRENCH_TAX_CODE FRENCH_TAX_CODE, FRENCH_TAX_NAME FRENCH_TAX_NAME, USAGE_TYPE_CODE USAGE_TYPE_CODE, FIXED_USAGE_QUANTITY FIXED_USAGE_QUANTITY, INITIAL_DIRECT_COST INITIAL_DIRECT_COST, IN_SERVICE_DATE IN_SERVICE_DATE, LINK_ASSET_AMOUNT LINK_ASSET_AMOUNT, FEE_TYPE FEE_TYPE, DEPRECIATION_COST DEPRECIATION_COST, USAGE_PERIOD USAGE_PERIOD, USAGE_NO_OF_PERIOD USAGE_NO_OF_PERIOD, ASSET_KEY_ID ASSET_KEY_ID, ASSET_KEY_SEGMENT1 ASSET_KEY_SEGMENT1, ASSET_KEY_SEGMENT2 ASSET_KEY_SEGMENT2, ASSET_KEY_SEGMENT3 ASSET_KEY_SEGMENT3, ASSET_KEY_SEGMENT4 ASSET_KEY_SEGMENT4, ASSET_KEY_SEGMENT5 ASSET_KEY_SEGMENT5, ASSET_KEY_SEGMENT6 ASSET_KEY_SEGMENT6, ASSET_KEY_SEGMENT7 ASSET_KEY_SEGMENT7, ASSET_KEY_SEGMENT8 ASSET_KEY_SEGMENT8, ASSET_KEY_SEGMENT9 ASSET_KEY_SEGMENT9, ASSET_KEY_SEGMENT10 ASSET_KEY_SEGMENT10, TERMINATION_QUOTE_ID TERMINATION_QUOTE_ID, TERMINATION_QUOTE_NUMBER TERMINATION_QUOTE_NUMBER, PROP_TAX_BILL_METHOD PROP_TAX_BILL_METHOD, PROP_TAX_AS_CONTRACT_YN PROP_TAX_AS_CONTRACT_YN, STREAM_PURPOSE_CODE STREAM_PURPOSE_CODE, EXPLICIT_NEW_LINE_FLAG EXPLICIT_NEW_LINE_FLAG, SUBSIDY_ID SUBSIDY_ID, SUBSIDY_NAME SUBSIDY_NAME, SUBSIDY_OVERRIDE_AMOUNT SUBSIDY_OVERRIDE_AMOUNT, SUBSIDY_PARTY_ID SUBSIDY_PARTY_ID, SUBSIDY_PARTY_NAME SUBSIDY_PARTY_NAME, SUBSIDY_REFND_PAYSITE_ID SUBSIDY_REFND_PAYSITE_ID, SUBSIDY_REFND_PAYSITE_CODE SUBSIDY_REFND_PAYSITE_CODE, SUBSIDY_REFND_PAYTERM_ID SUBSIDY_REFND_PAYTERM_ID, SUBSIDY_REFND_PAYTERM_NAME SUBSIDY_REFND_PAYTERM_NAME, SUBSIDY_REFND_PAYMETHOD_CODE SUBSIDY_REFND_PAYMETHOD_CODE, SUBSIDY_REFND_PAYGROUP_CODE SUBSIDY_REFND_PAYGROUP_CODE, PTH_BASE_PAYOUT_BASIS PTH_BASE_PAYOUT_BASIS, PTH_BASE_STREAM_CODE PTH_BASE_STREAM_CODE, PTH_BASE_STREAM_PURPOSE_CODE PTH_BASE_STREAM_PURPOSE_CODE, PTH_START_DATE PTH_START_DATE, PTH_EVG_PAYOUT_BASIS PTH_EVG_PAYOUT_BASIS, PTH_PAYOUT_BASIS_FORMULA PTH_PAYOUT_BASIS_FORMULA, PTH_EVG_STREAM_CODE PTH_EVG_STREAM_CODE, PTH_EVG_STREAM_PURPOSE_CODE PTH_EVG_STREAM_PURPOSE_CODE, ST_UPDATE_LINES_FROM_CONTRACT ST_UPDATE_LINES_FROM_CONTRACT, ST_TRANSFER_OF_TITLE ST_TRANSFER_OF_TITLE, ST_SALE_AND_LEASE_BACK ST_SALE_AND_LEASE_BACK, ST_PURCHASE_OF_LEASE ST_PURCHASE_OF_LEASE, ST_EQUIPMENT_USAGE ST_EQUIPMENT_USAGE, ST_EQUIPMENT_AGE ST_EQUIPMENT_AGE, FEE_PURPOSE_CODE FEE_PURPOSE_CODE, ST_ASSET_UPFRONT_TAX ST_ASSET_UPFRONT_TAX, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, ATTRIBUTE1 ATTRIBUTE1, ATTRIBUTE2 ATTRIBUTE2, ATTRIBUTE3 ATTRIBUTE3, ATTRIBUTE4 ATTRIBUTE4, ATTRIBUTE5 ATTRIBUTE5, ATTRIBUTE6 ATTRIBUTE6, ATTRIBUTE7 ATTRIBUTE7, ATTRIBUTE8 ATTRIBUTE8, ATTRIBUTE9 ATTRIBUTE9, ATTRIBUTE10 ATTRIBUTE10, ATTRIBUTE11 ATTRIBUTE11, ATTRIBUTE12 ATTRIBUTE12, ATTRIBUTE13 ATTRIBUTE13, ATTRIBUTE14 ATTRIBUTE14, ATTRIBUTE15 ATTRIBUTE15, DOWN_PAYMENT_RECEIVER_CODE DOWN_PAYMENT_RECEIVER_CODE, CAPITALIZE_DOWN_PAYMENT_YN CAPITALIZE_DOWN_PAYMENT_YN, DATE_FUNDING_EXPECTED DATE_FUNDING_EXPECTED, ORIGINATION_INCOME ORIGINATION_INCOME, AMOUNT_BALANCE_LEGACY AMOUNT_BALANCE_LEGACY, DT_EFFECTIVE_BALANCE_LEGACY DT_EFFECTIVE_BALANCE_LEGACY from "OKL"."OKL_LINES_INTERFACE"

View Text - HTML Formatted

SELECT CONTRACT_NUMBER_OLD CONTRACT_NUMBER_OLD
, LINE_NUMBER LINE_NUMBER
, LINE_TYPE LINE_TYPE
, ASSET_NUMBER ASSET_NUMBER
, LINK_ASSET_NUMBER LINK_ASSET_NUMBER
, ORIGINAL_COST ORIGINAL_COST
, TOTAL_UNITS TOTAL_UNITS
, AMOUNT AMOUNT
, STATUS STATUS
, DATE_APPROVED DATE_APPROVED
, DATE_SIGNED DATE_SIGNED
, CURRENCY_CODE CURRENCY_CODE
, INVENTORY_ORGANIZATION_NAME INVENTORY_ORGANIZATION_NAME
, INVENTORY_ORGANIZATION_ID INVENTORY_ORGANIZATION_ID
, INVENTORY_ITEM_NAME INVENTORY_ITEM_NAME
, INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, DESCRIPTION DESCRIPTION
, MODEL MODEL
, MAKE MAKE
, YEAR_OF_MANUFACTURE YEAR_OF_MANUFACTURE
, INSTALL_SITE_NUMBER INSTALL_SITE_NUMBER
, INSTALL_SITE_ID INSTALL_SITE_ID
, RESIDUAL_PERCENT RESIDUAL_PERCENT
, RESIDUAL_AMOUNT RESIDUAL_AMOUNT
, RESIDUAL_AMOUNT_GUARANTEE RESIDUAL_AMOUNT_GUARANTEE
, RESIDUAL_AMOUNT_GUARANTEE_PV RESIDUAL_AMOUNT_GUARANTEE_PV
, GUARANTOR_TYPE_CODE GUARANTOR_TYPE_CODE
, TRADE_IN_AMOUNT TRADE_IN_AMOUNT
, CAPITAL_REDUCTION_PERCENT CAPITAL_REDUCTION_PERCENT
, CAPITAL_REDUCTION_AMOUNT CAPITAL_REDUCTION_AMOUNT
, INTERIM_INT_CAPITALIZED_AMT INTERIM_INT_CAPITALIZED_AMT
, ASSET_CORPORATE_BOOK ASSET_CORPORATE_BOOK
, ASSET_CATEGORY_SEGMENT1 ASSET_CATEGORY_SEGMENT1
, ASSET_CATEGORY_SEGMENT2 ASSET_CATEGORY_SEGMENT2
, ASSET_CATEGORY_SEGMENT3 ASSET_CATEGORY_SEGMENT3
, ASSET_CATEGORY_SEGMENT4 ASSET_CATEGORY_SEGMENT4
, ASSET_CATEGORY_SEGMENT5 ASSET_CATEGORY_SEGMENT5
, ASSET_CATEGORY_SEGMENT6 ASSET_CATEGORY_SEGMENT6
, ASSET_CATEGORY_SEGMENT7 ASSET_CATEGORY_SEGMENT7
, ASSET_CATEGORY_ID ASSET_CATEGORY_ID
, ASSET_LOCATION_SEGMENT1 ASSET_LOCATION_SEGMENT1
, ASSET_LOCATION_SEGMENT2 ASSET_LOCATION_SEGMENT2
, ASSET_LOCATION_SEGMENT3 ASSET_LOCATION_SEGMENT3
, ASSET_LOCATION_SEGMENT4 ASSET_LOCATION_SEGMENT4
, ASSET_LOCATION_SEGMENT5 ASSET_LOCATION_SEGMENT5
, ASSET_LOCATION_SEGMENT6 ASSET_LOCATION_SEGMENT6
, ASSET_LOCATION_SEGMENT7 ASSET_LOCATION_SEGMENT7
, ASSET_LOCATION_ID ASSET_LOCATION_ID
, DEPRECIATION_METHOD_ID DEPRECIATION_METHOD_ID
, DEPRECIATION_METHOD_CODE DEPRECIATION_METHOD_CODE
, LIFE_IN_MONTHS LIFE_IN_MONTHS
, DEPRECIATION_RATE DEPRECIATION_RATE
, SALVAGE_VALUE SALVAGE_VALUE
, SALVAGE_VALUE_PERCENT SALVAGE_VALUE_PERCENT
, SALES_TAX_EXEMPT_FLAG SALES_TAX_EXEMPT_FLAG
, SALES_TAX_EXEMPT_CERT_NUMBER SALES_TAX_EXEMPT_CERT_NUMBER
, SALES_TAX_OVERRIDE_FLAG SALES_TAX_OVERRIDE_FLAG
, SALES_TAX_OVERRIDE_RATE SALES_TAX_OVERRIDE_RATE
, VAT_TAX_EXEMPT VAT_TAX_EXEMPT
, VAT_TAX_EXEMPT_CERT_NUMBER VAT_TAX_EXEMPT_CERT_NUMBER
, VAT_TAX_OVERRIDE_FLAG VAT_TAX_OVERRIDE_FLAG
, VAT_TAX_OVERRIDE_RATE VAT_TAX_OVERRIDE_RATE
, LIEN_TYPE LIEN_TYPE
, LIEN_FILING_NUMBER LIEN_FILING_NUMBER
, LIEN_FILING_DATE LIEN_FILING_DATE
, LIEN_FILING_STATUS LIEN_FILING_STATUS
, LIENHOLDER_ID LIENHOLDER_ID
, LIENHOLDER_NUMBER LIENHOLDER_NUMBER
, FILING_JURISDICTION FILING_JURISDICTION
, FILING_SUB_JURISDICTION FILING_SUB_JURISDICTION
, LIEN_EXPIRATION_DATE LIEN_EXPIRATION_DATE
, LIEN_CONTINUATION_NUMBER LIEN_CONTINUATION_NUMBER
, LIEN_CONTINUATION_DATE LIEN_CONTINUATION_DATE
, TITLE_TYPE TITLE_TYPE
, TITLE_ISSUER_NUMBER TITLE_ISSUER_NUMBER
, TITLE_ISSUER_ID TITLE_ISSUER_ID
, TITLE_DATE TITLE_DATE
, TITLE_NUMBER TITLE_NUMBER
, REGISTRATION_NUMBER REGISTRATION_NUMBER
, ASSET_REGISTRATION_LOC_NAME ASSET_REGISTRATION_LOC_NAME
, TITLE_CUSTODIAN_NAME TITLE_CUSTODIAN_NAME
, PAYEE_SITE_NAME PAYEE_SITE_NAME
, SERIAL_NUMBER SERIAL_NUMBER
, VENDOR_INVOICE_NUMBER VENDOR_INVOICE_NUMBER
, VENDOR_INVOICE_DATE VENDOR_INVOICE_DATE
, SHIP_TO_SITE_NUMBER SHIP_TO_SITE_NUMBER
, SHIP_TO_SITE_ID SHIP_TO_SITE_ID
, START_DATE START_DATE
, END_DATE END_DATE
, PASSTHROUGH_PERCENT PASSTHROUGH_PERCENT
, PASSTHROUGH_BASIS_CODE PASSTHROUGH_BASIS_CODE
, FEE_CODE FEE_CODE
, USAGE_ITEM_NAME USAGE_ITEM_NAME
, USAGE_ITEM_ID USAGE_ITEM_ID
, PRICE_LIST_NAME PRICE_LIST_NAME
, PRICE_LIST_ID PRICE_LIST_ID
, COUNTER_GROUP_NAME COUNTER_GROUP_NAME
, COUNTER_GROUP_ID COUNTER_GROUP_ID
, USAGE_BILL_FREQUENCY_CODE USAGE_BILL_FREQUENCY_CODE
, MINIMUM_QTY_USAGE MINIMUM_QTY_USAGE
, DEFAULT_QTY_USAGE DEFAULT_QTY_USAGE
, AMCV_FLAG AMCV_FLAG
, LEVEL_FLAG LEVEL_FLAG
, BASE_READING BASE_READING
, BASE_READING_UOM_CODE BASE_READING_UOM_CODE
, REAL_EST_INIT_DIRECT_COST REAL_EST_INIT_DIRECT_COST
, REAL_EST_OCCUPANCY REAL_EST_OCCUPANCY
, REAL_EST_DATE_LAST_INSP REAL_EST_DATE_LAST_INSP
, REAL_EST_DATE_NEXT_INSP REAL_EST_DATE_NEXT_INSP
, REAL_EST_WTD_AVG_LIFE REAL_EST_WTD_AVG_LIFE
, REAL_EST_BOND_EQ_YIELD REAL_EST_BOND_EQ_YIELD
, REAL_EST_REFINANCE_AMT REAL_EST_REFINANCE_AMT
, REAL_EST_CREDIT_TENANT_FLAG REAL_EST_CREDIT_TENANT_FLAG
, REAL_EST_PROPERTY_CLASS_CODE REAL_EST_PROPERTY_CLASS_CODE
, REAL_EST_COVERAGE_RATIO REAL_EST_COVERAGE_RATIO
, REAL_EST_NET_CASH_FLOW REAL_EST_NET_CASH_FLOW
, REAL_EST_FUNDING_CATG_CODE REAL_EST_FUNDING_CATG_CODE
, REAL_EST_APPRAISAL_FLAG REAL_EST_APPRAISAL_FLAG
, REAL_EST_APPRAISAL_DATE REAL_EST_APPRAISAL_DATE
, REAL_EST_APPRAISAL_VALUE REAL_EST_APPRAISAL_VALUE
, REAL_EST_CONCEPT_TYPE_CODE REAL_EST_CONCEPT_TYPE_CODE
, REAL_EST_DEAL_TYPE_CODE REAL_EST_DEAL_TYPE_CODE
, REAL_EST_GROSS_FOOTAGE REAL_EST_GROSS_FOOTAGE
, REAL_EST_NET_FOOTAGE_RENTABLE REAL_EST_NET_FOOTAGE_RENTABLE
, REAL_EST_LETTER_ACCEPT_DATE REAL_EST_LETTER_ACCEPT_DATE
, REAL_EST_ACCEPT_EXPIRE_DATE REAL_EST_ACCEPT_EXPIRE_DATE
, CAPITALIZED_INTEREST CAPITALIZED_INTEREST
, TAX_COST TAX_COST
, TAX_BOOK TAX_BOOK
, LIFE_IN_MONTHS_TAX LIFE_IN_MONTHS_TAX
, DEPRN_METHOD_TAX DEPRN_METHOD_TAX
, DEPRN_RATE_TAX DEPRN_RATE_TAX
, PAYMENT_TERM PAYMENT_TERM
, PAYMENT_TERM_ID PAYMENT_TERM_ID
, VENDOR_PAYSITE_ID VENDOR_PAYSITE_ID
, VENDOR_PAYSITE_NAME VENDOR_PAYSITE_NAME
, VENDOR_PAYMENT_METHOD VENDOR_PAYMENT_METHOD
, FEE_EXP_NO_OF_PERIODS FEE_EXP_NO_OF_PERIODS
, FEE_EXP_FREQUENCY FEE_EXP_FREQUENCY
, FEE_EXP_AMOUNT_PER_PERIOD FEE_EXP_AMOUNT_PER_PERIOD
, PROP_TAX_APPLICABLE PROP_TAX_APPLICABLE
, PROP_TAX_LEASE_REP PROP_TAX_LEASE_REP
, FRENCH_TAX_CODE FRENCH_TAX_CODE
, FRENCH_TAX_NAME FRENCH_TAX_NAME
, USAGE_TYPE_CODE USAGE_TYPE_CODE
, FIXED_USAGE_QUANTITY FIXED_USAGE_QUANTITY
, INITIAL_DIRECT_COST INITIAL_DIRECT_COST
, IN_SERVICE_DATE IN_SERVICE_DATE
, LINK_ASSET_AMOUNT LINK_ASSET_AMOUNT
, FEE_TYPE FEE_TYPE
, DEPRECIATION_COST DEPRECIATION_COST
, USAGE_PERIOD USAGE_PERIOD
, USAGE_NO_OF_PERIOD USAGE_NO_OF_PERIOD
, ASSET_KEY_ID ASSET_KEY_ID
, ASSET_KEY_SEGMENT1 ASSET_KEY_SEGMENT1
, ASSET_KEY_SEGMENT2 ASSET_KEY_SEGMENT2
, ASSET_KEY_SEGMENT3 ASSET_KEY_SEGMENT3
, ASSET_KEY_SEGMENT4 ASSET_KEY_SEGMENT4
, ASSET_KEY_SEGMENT5 ASSET_KEY_SEGMENT5
, ASSET_KEY_SEGMENT6 ASSET_KEY_SEGMENT6
, ASSET_KEY_SEGMENT7 ASSET_KEY_SEGMENT7
, ASSET_KEY_SEGMENT8 ASSET_KEY_SEGMENT8
, ASSET_KEY_SEGMENT9 ASSET_KEY_SEGMENT9
, ASSET_KEY_SEGMENT10 ASSET_KEY_SEGMENT10
, TERMINATION_QUOTE_ID TERMINATION_QUOTE_ID
, TERMINATION_QUOTE_NUMBER TERMINATION_QUOTE_NUMBER
, PROP_TAX_BILL_METHOD PROP_TAX_BILL_METHOD
, PROP_TAX_AS_CONTRACT_YN PROP_TAX_AS_CONTRACT_YN
, STREAM_PURPOSE_CODE STREAM_PURPOSE_CODE
, EXPLICIT_NEW_LINE_FLAG EXPLICIT_NEW_LINE_FLAG
, SUBSIDY_ID SUBSIDY_ID
, SUBSIDY_NAME SUBSIDY_NAME
, SUBSIDY_OVERRIDE_AMOUNT SUBSIDY_OVERRIDE_AMOUNT
, SUBSIDY_PARTY_ID SUBSIDY_PARTY_ID
, SUBSIDY_PARTY_NAME SUBSIDY_PARTY_NAME
, SUBSIDY_REFND_PAYSITE_ID SUBSIDY_REFND_PAYSITE_ID
, SUBSIDY_REFND_PAYSITE_CODE SUBSIDY_REFND_PAYSITE_CODE
, SUBSIDY_REFND_PAYTERM_ID SUBSIDY_REFND_PAYTERM_ID
, SUBSIDY_REFND_PAYTERM_NAME SUBSIDY_REFND_PAYTERM_NAME
, SUBSIDY_REFND_PAYMETHOD_CODE SUBSIDY_REFND_PAYMETHOD_CODE
, SUBSIDY_REFND_PAYGROUP_CODE SUBSIDY_REFND_PAYGROUP_CODE
, PTH_BASE_PAYOUT_BASIS PTH_BASE_PAYOUT_BASIS
, PTH_BASE_STREAM_CODE PTH_BASE_STREAM_CODE
, PTH_BASE_STREAM_PURPOSE_CODE PTH_BASE_STREAM_PURPOSE_CODE
, PTH_START_DATE PTH_START_DATE
, PTH_EVG_PAYOUT_BASIS PTH_EVG_PAYOUT_BASIS
, PTH_PAYOUT_BASIS_FORMULA PTH_PAYOUT_BASIS_FORMULA
, PTH_EVG_STREAM_CODE PTH_EVG_STREAM_CODE
, PTH_EVG_STREAM_PURPOSE_CODE PTH_EVG_STREAM_PURPOSE_CODE
, ST_UPDATE_LINES_FROM_CONTRACT ST_UPDATE_LINES_FROM_CONTRACT
, ST_TRANSFER_OF_TITLE ST_TRANSFER_OF_TITLE
, ST_SALE_AND_LEASE_BACK ST_SALE_AND_LEASE_BACK
, ST_PURCHASE_OF_LEASE ST_PURCHASE_OF_LEASE
, ST_EQUIPMENT_USAGE ST_EQUIPMENT_USAGE
, ST_EQUIPMENT_AGE ST_EQUIPMENT_AGE
, FEE_PURPOSE_CODE FEE_PURPOSE_CODE
, ST_ASSET_UPFRONT_TAX ST_ASSET_UPFRONT_TAX
, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, ATTRIBUTE6 ATTRIBUTE6
, ATTRIBUTE7 ATTRIBUTE7
, ATTRIBUTE8 ATTRIBUTE8
, ATTRIBUTE9 ATTRIBUTE9
, ATTRIBUTE10 ATTRIBUTE10
, ATTRIBUTE11 ATTRIBUTE11
, ATTRIBUTE12 ATTRIBUTE12
, ATTRIBUTE13 ATTRIBUTE13
, ATTRIBUTE14 ATTRIBUTE14
, ATTRIBUTE15 ATTRIBUTE15
, DOWN_PAYMENT_RECEIVER_CODE DOWN_PAYMENT_RECEIVER_CODE
, CAPITALIZE_DOWN_PAYMENT_YN CAPITALIZE_DOWN_PAYMENT_YN
, DATE_FUNDING_EXPECTED DATE_FUNDING_EXPECTED
, ORIGINATION_INCOME ORIGINATION_INCOME
, AMOUNT_BALANCE_LEGACY AMOUNT_BALANCE_LEGACY
, DT_EFFECTIVE_BALANCE_LEGACY DT_EFFECTIVE_BALANCE_LEGACY
FROM "OKL"."OKL_LINES_INTERFACE"