eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

VIEW: OKL.OKL_CNTRCT_FIN_EXTRACT_T#

Source

View Text - Preformatted


select REQUEST_ID REQUEST_ID, CONTRACT_ID CONTRACT_ID, CONTRACT_DOCUMENT_ID CONTRACT_DOCUMENT_ID, CONTRACT_NUMBER CONTRACT_NUMBER, CONTRACT_OPERATING_UNIT_ID CONTRACT_OPERATING_UNIT_ID, CONTRACT_INVENTORY_ORG_ID CONTRACT_INVENTORY_ORG_ID, CONTRACT_STATUS_CODE CONTRACT_STATUS_CODE, CONTRACT_CURRENCY CONTRACT_CURRENCY, CONTRACT_TEMPLATE_INDICATOR CONTRACT_TEMPLATE_INDICATOR, CONTRACT_CUST_PURCH_ORDER_NUM CONTRACT_CUST_PURCH_ORDER_NUM, CONTRACT_TEMPLATE_NAME CONTRACT_TEMPLATE_NAME, CONTRACT_APPROVED_DATE CONTRACT_APPROVED_DATE, CONTRACT_CANCELED_TIMESTAMP CONTRACT_CANCELED_TIMESTAMP, CONTRACT_SIGNED_DATE CONTRACT_SIGNED_DATE, CONTRACT_TERMINATION_DATE CONTRACT_TERMINATION_DATE, CONTRACT_START_DATE CONTRACT_START_DATE, CONTRACT_END_DATE CONTRACT_END_DATE, CUSTOMER_ACCOUNT_ID CUSTOMER_ACCOUNT_ID, CUST_BILL_TO_SITE_USE_ID CUST_BILL_TO_SITE_USE_ID, CUST_PAYMENT_TERM_ID CUST_PAYMENT_TERM_ID, CONTRACT_ORIG_SYSTEM_SOURCE CONTRACT_ORIG_SYSTEM_SOURCE, CONTRACT_SALES_REGION_ID CONTRACT_SALES_REGION_ID, VENDOR_PROGRAM_ID VENDOR_PROGRAM_ID, CONTRACT_FINANCIAL_PRODUCT_ID CONTRACT_FINANCIAL_PRODUCT_ID, CONTRACT_DATE_DEAL_ACTIVATED CONTRACT_DATE_DEAL_ACTIVATED, CONTRACT_DATE_DEAL_TRANSFERD CONTRACT_DATE_DEAL_TRANSFERD, CONTRACT_TERM_DURATION CONTRACT_TERM_DURATION, CONTRACT_HDR_DFF_CATEGORY CONTRACT_HDR_DFF_CATEGORY, CONTRACT_HDR_DFF1 CONTRACT_HDR_DFF1, CONTRACT_HDR_DFF2 CONTRACT_HDR_DFF2, CONTRACT_HDR_DFF3 CONTRACT_HDR_DFF3, CONTRACT_HDR_DFF4 CONTRACT_HDR_DFF4, CONTRACT_HDR_DFF5 CONTRACT_HDR_DFF5, CONTRACT_HDR_DFF6 CONTRACT_HDR_DFF6, CONTRACT_HDR_DFF7 CONTRACT_HDR_DFF7, CONTRACT_HDR_DFF8 CONTRACT_HDR_DFF8, CONTRACT_HDR_DFF9 CONTRACT_HDR_DFF9, CONTRACT_HDR_DFF10 CONTRACT_HDR_DFF10, CONTRACT_HDR_DFF11 CONTRACT_HDR_DFF11, CONTRACT_HDR_DFF12 CONTRACT_HDR_DFF12, CONTRACT_HDR_DFF13 CONTRACT_HDR_DFF13, CONTRACT_HDR_DFF14 CONTRACT_HDR_DFF14, CONTRACT_HDR_DFF15 CONTRACT_HDR_DFF15, CONTRACT_ACCRUAL_STATUS CONTRACT_ACCRUAL_STATUS, CONTRACT_GEN_ACCRUAL_OVRIDE_YN CONTRACT_GEN_ACCRUAL_OVRIDE_YN, CONTRACT_CREDIT_ACT_YN CONTRACT_CREDIT_ACT_YN, CONTRACT_CONVERTED_ACCOUNT_YN CONTRACT_CONVERTED_ACCOUNT_YN, CONTRACT_AFTER_TAX_YIELD CONTRACT_AFTER_TAX_YIELD, CONTRACT_IMPL_INTEREST_RATE CONTRACT_IMPL_INTEREST_RATE, CONTRACT_LAST_INT_CALC_DATE CONTRACT_LAST_INT_CALC_DATE, CONTRACT_BOOK_CLASS_CODE CONTRACT_BOOK_CLASS_CODE, CONTRACT_BOOK_CLASSIFICATION CONTRACT_BOOK_CLASSIFICATION, CONTRACT_PRE_TAX_IRR CONTRACT_PRE_TAX_IRR, CONTRACT_AFTER_TAX_IRR CONTRACT_AFTER_TAX_IRR, CONTRACT_EXP_DELIVERY_DATE CONTRACT_EXP_DELIVERY_DATE, CONTRACT_ACCEPTANCE_DATE CONTRACT_ACCEPTANCE_DATE, CONTRACT_PREFUND_ELIG_YN CONTRACT_PREFUND_ELIG_YN, CONTRACT_REVOL_CREDIT_ELIG_YN CONTRACT_REVOL_CREDIT_ELIG_YN, CONTRACT_CURRENCY_CONV_TYPE CONTRACT_CURRENCY_CONV_TYPE, CONTRACT_CURRENCY_CONV_RATE CONTRACT_CURRENCY_CONV_RATE, CONTRACT_CURRENCY_CONV_DATE CONTRACT_CURRENCY_CONV_DATE, CONTRACT_MULTI_GAAP_ELIG_YN CONTRACT_MULTI_GAAP_ELIG_YN, CONTRACT_INVESTOR_ASSIGN_YN CONTRACT_INVESTOR_ASSIGN_YN, CONTRACT_SECURITIZATION_TYPE CONTRACT_SECURITIZATION_TYPE, CONTRACT_SUB_AFTER_TAX_YIELD CONTRACT_SUB_AFTER_TAX_YIELD, CONTRACT_SUB_IMPL_INT_RATE CONTRACT_SUB_IMPL_INT_RATE, CONTRACT_SUB_PRE_TAX_IRR CONTRACT_SUB_PRE_TAX_IRR, CONTRACT_SUB_AFTER_TAX_IRR CONTRACT_SUB_AFTER_TAX_IRR, CONTRACT_CRDTLINE_TRNSFR_AMT CONTRACT_CRDTLINE_TRNSFR_AMT, CONTRACT_CRDTLINE_NETRNSFR_AMT CONTRACT_CRDTLINE_NETRNSFR_AMT, CONTRACT_CRDTLINE_LIMIT CONTRACT_CRDTLINE_LIMIT, CONTRACT_CRDTLINE_FUNDING_AMT CONTRACT_CRDTLINE_FUNDING_AMT, CONTRACT_TEMPL_TYPE_CODE CONTRACT_TEMPL_TYPE_CODE, CONTRACT_TRADEIN_DESCRIPTION CONTRACT_TRADEIN_DESCRIPTION, CONTRACT_TRADEIN_DATE CONTRACT_TRADEIN_DATE, CONTRACT_LEGAL_ENTITY_ID CONTRACT_LEGAL_ENTITY_ID, CONTRACT_FIRST_ACTIVITY_DATE CONTRACT_FIRST_ACTIVITY_DATE, CONTRACT_ACCUMULATED_DEP CONTRACT_ACCUMULATED_DEP, CONTRACT_CAPITALIZED_REDUCTION CONTRACT_CAPITALIZED_REDUCTION, CONTRACT_CAPITALIZED_FEE CONTRACT_CAPITALIZED_FEE, CONTRACT_CAPITALIZED_INTEREST CONTRACT_CAPITALIZED_INTEREST, CONTRACT_DISCOUNT CONTRACT_DISCOUNT, CONTRACT_ASSET_COST CONTRACT_ASSET_COST, CONTRACT_FINANCED_FEE CONTRACT_FINANCED_FEE, CONTRACT_NEXT_PAYMENT_AMT CONTRACT_NEXT_PAYMENT_AMT, CONTRACT_TOTAL_ACCRUED_INT CONTRACT_TOTAL_ACCRUED_INT, CONTRACT_TOTAL_ACTUAL_INT CONTRACT_TOTAL_ACTUAL_INT, CONTRACT_SUBSIDY_AMOUNT CONTRACT_SUBSIDY_AMOUNT, CONTRACT_UNACCRUED_SUBSIDY CONTRACT_UNACCRUED_SUBSIDY, CONTRACT_UNBILLED_DUE_AMOUNT CONTRACT_UNBILLED_DUE_AMOUNT, CONTRACT_UNBILLED_RECEIVABLES CONTRACT_UNBILLED_RECEIVABLES, CONTRACT_OEC CONTRACT_OEC, CONTRACT_ACTUAL_PRINC_BAL CONTRACT_ACTUAL_PRINC_BAL, ROLLOVER_FEE_AMOUNT ROLLOVER_FEE_AMOUNT, CONTRACT_TRADEIN_AMOUNT CONTRACT_TRADEIN_AMOUNT, TOTAL_AMOUNT_PAID_TO_DEALER TOTAL_AMOUNT_PAID_TO_DEALER, TOTAL_DEBITS_FOR_PREFUNDING TOTAL_DEBITS_FOR_PREFUNDING, CONTRACT_PREFUNDED_AMOUNT CONTRACT_PREFUNDED_AMOUNT, CONTRACT_BILLED_RENTS CONTRACT_BILLED_RENTS, CONTRACT_BILLED_RENTS_FUNC CONTRACT_BILLED_RENTS_FUNC, CONTRACT_BILLED_NON_RENTS CONTRACT_BILLED_NON_RENTS, CONTRACT_BILLED_NON_RENTS_FUNC CONTRACT_BILLED_NON_RENTS_FUNC, SUPPLIER_RETENTION_FUNDING_AMT SUPPLIER_RETENTION_FUNDING_AMT, ASSETS_FUNDED_AMOUNT ASSETS_FUNDED_AMOUNT, EXPENSE_FUNDED_AMOUNT EXPENSE_FUNDED_AMOUNT, CONTRACT_IDC_AMOUNT CONTRACT_IDC_AMOUNT, CONTRACT_SCHEDULED_PRINC_BAL CONTRACT_SCHEDULED_PRINC_BAL, CONTRACT_INTEREST_RATE CONTRACT_INTEREST_RATE, CONTRACT_DAYS_TO_ACCRUE CONTRACT_DAYS_TO_ACCRUE, CONTRACT_DAYS_IN_YEAR CONTRACT_DAYS_IN_YEAR, CONTRACT_CAP_AMOUNT CONTRACT_CAP_AMOUNT, CONTRACT_FINANCED_AMOUNT CONTRACT_FINANCED_AMOUNT, CONTRACT_VAR_INCOME_ACCRUAL CONTRACT_VAR_INCOME_ACCRUAL, TOTAL_PREFUNDING_AMOUNT TOTAL_PREFUNDING_AMOUNT, OPERATING_UNIT OPERATING_UNIT, OPERATING_UNIT_SHORT_CODE OPERATING_UNIT_SHORT_CODE, CONTRACT_STATUS_TYPE_CODE CONTRACT_STATUS_TYPE_CODE, CONTRACT_STATUS CONTRACT_STATUS, CONTRACT_FEE_INCOME CONTRACT_FEE_INCOME, ACC_ENGINE_TEMPL_SET_ID ACC_ENGINE_TEMPL_SET_ID, CONTRACT_FIN_PROD_TEMPLATE_ID CONTRACT_FIN_PROD_TEMPLATE_ID, CONTRACT_FINANCIAL_PRODUCT CONTRACT_FINANCIAL_PRODUCT, CONTRACT_FIN_PROD_DESC CONTRACT_FIN_PROD_DESC, REPORTING_PRODUCT_ID REPORTING_PRODUCT_ID, CONTRACT_FIN_PROD_STATUS_CODE CONTRACT_FIN_PROD_STATUS_CODE, CONTRACT_FIN_PROD_EFF_FROM_DT CONTRACT_FIN_PROD_EFF_FROM_DT, CONTRACT_FIN_PROD_EFF_TO_DT CONTRACT_FIN_PROD_EFF_TO_DT, REPORTING_PRODUCT REPORTING_PRODUCT, VENDOR_PROGRAM_NAME VENDOR_PROGRAM_NAME, VENDOR_NUMBER VENDOR_NUMBER, VENDOR_NAME VENDOR_NAME, VENDOR_TYPE_CODE VENDOR_TYPE_CODE, VENDOR_BILL_TO_SITE_USE_ID VENDOR_BILL_TO_SITE_USE_ID, VENDOR_PARTY_ROLE VENDOR_PARTY_ROLE, TOTAL_UPFRONT_TAX_ON_ASSETS TOTAL_UPFRONT_TAX_ON_ASSETS, TOTAL_NUMBER_OF_ASSETS TOTAL_NUMBER_OF_ASSETS, FUNCTIONAL_CURRENCY FUNCTIONAL_CURRENCY, LEDGER_ID LEDGER_ID, LEDGER LEDGER, CONTRACT_EARLIEST_BILL_DATE CONTRACT_EARLIEST_BILL_DATE, CONTRACT_SALES_REP CONTRACT_SALES_REP, LEGAL_ENTITY LEGAL_ENTITY, CUSTOMER_PARTY_NUMBER CUSTOMER_PARTY_NUMBER, CUSTOMER_PARTY_NAME CUSTOMER_PARTY_NAME, CUSTOMER_PARTY_TYPE CUSTOMER_PARTY_TYPE, CUSTOMER_SIC_CODE CUSTOMER_SIC_CODE, CUSTOMER_HQ_BRANCH_IND CUSTOMER_HQ_BRANCH_IND, CUSTOMER_TAX_REFERENCE CUSTOMER_TAX_REFERENCE, CUSTOMER_DUNS_NUMBER CUSTOMER_DUNS_NUMBER, CUSTOMER_ALIAS CUSTOMER_ALIAS, CUSTOMER_COUNTRY CUSTOMER_COUNTRY, CUSTOMER_ADDRESS1 CUSTOMER_ADDRESS1, CUSTOMER_ADDRESS2 CUSTOMER_ADDRESS2, CUSTOMER_ADDRESS3 CUSTOMER_ADDRESS3, CUSTOMER_ADDRESS4 CUSTOMER_ADDRESS4, CUSTOMER_CITY CUSTOMER_CITY, CUSTOMER_POSTAL_CODE CUSTOMER_POSTAL_CODE, CUSTOMER_STATE CUSTOMER_STATE, CUSTOMER_PROVINCE CUSTOMER_PROVINCE, CUSTOMER_COUNTY CUSTOMER_COUNTY, CUSTOMER_SIC_CODE_TYPE CUSTOMER_SIC_CODE_TYPE, CUSTOMER_URL CUSTOMER_URL, FINANCIAL_INFO_FISCAL_YEAR FINANCIAL_INFO_FISCAL_YEAR, CUSTOMER_FISCAL_YEAREND_MONTH CUSTOMER_FISCAL_YEAREND_MONTH, TOTAL_NUM_OF_EMPLOYEES TOTAL_NUM_OF_EMPLOYEES, CURR_FISC_YEAR_POTENTIAL_REV CURR_FISC_YEAR_POTENTIAL_REV, NEXT_FISC_YEAR_POTENTIAL_REV NEXT_FISC_YEAR_POTENTIAL_REV, CUSTOMER_YEAR_ESTABLISHED CUSTOMER_YEAR_ESTABLISHED, GEN_SERV_ADMIN_INDICATOR GEN_SERV_ADMIN_INDICATOR, CUSTOMER_ORG_NAME_PHONETIC CUSTOMER_ORG_NAME_PHONETIC, CUSTOMER_COMPETITOR_YN CUSTOMER_COMPETITOR_YN, CUSTOMER_ALIAS2 CUSTOMER_ALIAS2, CUSTOMER_ALIAS3 CUSTOMER_ALIAS3, CUSTOMER_ALIAS4 CUSTOMER_ALIAS4, CUSTOMER_ALIAS5 CUSTOMER_ALIAS5, CUSTOMER_PRIM_PHONE_PURPOSE CUSTOMER_PRIM_PHONE_PURPOSE, CUSTOMER_PRIM_PHONE_TYPE CUSTOMER_PRIM_PHONE_TYPE, CUSTOMER_PRIM_PH_COUNTRY_CODE CUSTOMER_PRIM_PH_COUNTRY_CODE, CUSTOMER_PRIM_PH_AREA_CODE CUSTOMER_PRIM_PH_AREA_CODE, CUSTOMER_PRIM_PHONE_NUMBER CUSTOMER_PRIM_PHONE_NUMBER, CUSTOMER_PRIM_PHONE_EXTN CUSTOMER_PRIM_PHONE_EXTN, CUSTOMER_HOME_COUNTRY CUSTOMER_HOME_COUNTRY, CUSTOMER_STATUS CUSTOMER_STATUS, CUSTOMER_PARTY_ID CUSTOMER_PARTY_ID, CUSTOMER_ACCOUNT_NUMBER CUSTOMER_ACCOUNT_NUMBER, CUSTOMER_ACC_DFF_CATEGORY CUSTOMER_ACC_DFF_CATEGORY, CUSTOMER_ACC_DFF1 CUSTOMER_ACC_DFF1, CUSTOMER_ACC_DFF2 CUSTOMER_ACC_DFF2, CUSTOMER_ACC_DFF3 CUSTOMER_ACC_DFF3, CUSTOMER_ACC_DFF4 CUSTOMER_ACC_DFF4, CUSTOMER_ACC_DFF5 CUSTOMER_ACC_DFF5, CUSTOMER_ACC_DFF6 CUSTOMER_ACC_DFF6, CUSTOMER_ACC_DFF7 CUSTOMER_ACC_DFF7, CUSTOMER_ACC_DFF8 CUSTOMER_ACC_DFF8, CUSTOMER_ACC_DFF9 CUSTOMER_ACC_DFF9, CUSTOMER_ACC_DFF10 CUSTOMER_ACC_DFF10, CUSTOMER_ACC_DFF11 CUSTOMER_ACC_DFF11, CUSTOMER_ACC_DFF12 CUSTOMER_ACC_DFF12, CUSTOMER_ACC_DFF13 CUSTOMER_ACC_DFF13, CUSTOMER_ACC_DFF14 CUSTOMER_ACC_DFF14, CUSTOMER_ACC_DFF15 CUSTOMER_ACC_DFF15, CUSTOMER_ACC_DFF16 CUSTOMER_ACC_DFF16, CUSTOMER_ACC_DFF17 CUSTOMER_ACC_DFF17, CUSTOMER_ACC_DFF18 CUSTOMER_ACC_DFF18, CUSTOMER_ACC_DFF19 CUSTOMER_ACC_DFF19, CUSTOMER_ACC_DFF20 CUSTOMER_ACC_DFF20, CUSTOMER_ACCOUNT_STATUS CUSTOMER_ACCOUNT_STATUS, CUSTOMER_TYPE CUSTOMER_TYPE, CUSTOMER_SALES_CHANNEL CUSTOMER_SALES_CHANNEL, CUSTOMER_ACC_ESTAB_DATE CUSTOMER_ACC_ESTAB_DATE, CUSTOMER_ACCOUNT_NAME CUSTOMER_ACCOUNT_NAME, CUSTOMER_ACCOUNT_COMMENTS CUSTOMER_ACCOUNT_COMMENTS, CUSTOMER_LAST_STATUS_UPD_DT CUSTOMER_LAST_STATUS_UPD_DT, CUSTOMER_PARTY_SITE_ID CUSTOMER_PARTY_SITE_ID, CUSTOMER_PARTY_SITE_NUMBER CUSTOMER_PARTY_SITE_NUMBER, CUSTOMER_PARTY_SITE_NAME CUSTOMER_PARTY_SITE_NAME, CUSTOMER_PARTY_SITE_LOC_ID CUSTOMER_PARTY_SITE_LOC_ID, CUSTOMER_IDENTIFYING_ADR_FLAG CUSTOMER_IDENTIFYING_ADR_FLAG, CUSTOMER_PARTY_SITE_STATUS CUSTOMER_PARTY_SITE_STATUS, CUSTOMER_PARTY_SITE_ADDRESSEE CUSTOMER_PARTY_SITE_ADDRESSEE, CUSTOMER_SITE_GLOB_LOC_NUM CUSTOMER_SITE_GLOB_LOC_NUM, CUSTOMER_PARTY_SITE_USE_ID CUSTOMER_PARTY_SITE_USE_ID, CUSTOMER_PARTY_SITE_USE_TYPE CUSTOMER_PARTY_SITE_USE_TYPE, CUSTOMER_PARTY_SITE_COMMENTS CUSTOMER_PARTY_SITE_COMMENTS, CUSTOMER_PARTY_SITE_USE_STATUS CUSTOMER_PARTY_SITE_USE_STATUS, CONTRACT_PAST_DUE_AMT_1_30 CONTRACT_PAST_DUE_AMT_1_30, CONTRACT_PAST_DUE_AMT_31_60 CONTRACT_PAST_DUE_AMT_31_60, CONTRACT_PAST_DUE_AMT_61_90 CONTRACT_PAST_DUE_AMT_61_90, CONTRACT_PAST_DUE_AMT_91_120 CONTRACT_PAST_DUE_AMT_91_120, CONTRACT_PAST_DUE_AMT_120_PLUS CONTRACT_PAST_DUE_AMT_120_PLUS, CONTRACT_TOT_PAST_DUE_AMT CONTRACT_TOT_PAST_DUE_AMT, CONTRACT_TOT_BILLED_RECEIVABLE CONTRACT_TOT_BILLED_RECEIVABLE, CONTRACT_RESIDUAL_AMOUNT CONTRACT_RESIDUAL_AMOUNT, CONTRACT_RENT_AMOUNT CONTRACT_RENT_AMOUNT, CONTRACT_ACC_DEPRECIATION CONTRACT_ACC_DEPRECIATION, NET_INVESTMENT NET_INVESTMENT, NET_INVESTMENT_FUNCTIONAL NET_INVESTMENT_FUNCTIONAL, CONTRACT_AMOUNT_PREFUNDED CONTRACT_AMOUNT_PREFUNDED, CONTRACT_TOTAL_MISC_FUND CONTRACT_TOTAL_MISC_FUND, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_LOGIN_ID PROGRAM_LOGIN_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE from "OKL"."OKL_CNTRCT_FIN_EXTRACT_T"

View Text - HTML Formatted

SELECT REQUEST_ID REQUEST_ID
, CONTRACT_ID CONTRACT_ID
, CONTRACT_DOCUMENT_ID CONTRACT_DOCUMENT_ID
, CONTRACT_NUMBER CONTRACT_NUMBER
, CONTRACT_OPERATING_UNIT_ID CONTRACT_OPERATING_UNIT_ID
, CONTRACT_INVENTORY_ORG_ID CONTRACT_INVENTORY_ORG_ID
, CONTRACT_STATUS_CODE CONTRACT_STATUS_CODE
, CONTRACT_CURRENCY CONTRACT_CURRENCY
, CONTRACT_TEMPLATE_INDICATOR CONTRACT_TEMPLATE_INDICATOR
, CONTRACT_CUST_PURCH_ORDER_NUM CONTRACT_CUST_PURCH_ORDER_NUM
, CONTRACT_TEMPLATE_NAME CONTRACT_TEMPLATE_NAME
, CONTRACT_APPROVED_DATE CONTRACT_APPROVED_DATE
, CONTRACT_CANCELED_TIMESTAMP CONTRACT_CANCELED_TIMESTAMP
, CONTRACT_SIGNED_DATE CONTRACT_SIGNED_DATE
, CONTRACT_TERMINATION_DATE CONTRACT_TERMINATION_DATE
, CONTRACT_START_DATE CONTRACT_START_DATE
, CONTRACT_END_DATE CONTRACT_END_DATE
, CUSTOMER_ACCOUNT_ID CUSTOMER_ACCOUNT_ID
, CUST_BILL_TO_SITE_USE_ID CUST_BILL_TO_SITE_USE_ID
, CUST_PAYMENT_TERM_ID CUST_PAYMENT_TERM_ID
, CONTRACT_ORIG_SYSTEM_SOURCE CONTRACT_ORIG_SYSTEM_SOURCE
, CONTRACT_SALES_REGION_ID CONTRACT_SALES_REGION_ID
, VENDOR_PROGRAM_ID VENDOR_PROGRAM_ID
, CONTRACT_FINANCIAL_PRODUCT_ID CONTRACT_FINANCIAL_PRODUCT_ID
, CONTRACT_DATE_DEAL_ACTIVATED CONTRACT_DATE_DEAL_ACTIVATED
, CONTRACT_DATE_DEAL_TRANSFERD CONTRACT_DATE_DEAL_TRANSFERD
, CONTRACT_TERM_DURATION CONTRACT_TERM_DURATION
, CONTRACT_HDR_DFF_CATEGORY CONTRACT_HDR_DFF_CATEGORY
, CONTRACT_HDR_DFF1 CONTRACT_HDR_DFF1
, CONTRACT_HDR_DFF2 CONTRACT_HDR_DFF2
, CONTRACT_HDR_DFF3 CONTRACT_HDR_DFF3
, CONTRACT_HDR_DFF4 CONTRACT_HDR_DFF4
, CONTRACT_HDR_DFF5 CONTRACT_HDR_DFF5
, CONTRACT_HDR_DFF6 CONTRACT_HDR_DFF6
, CONTRACT_HDR_DFF7 CONTRACT_HDR_DFF7
, CONTRACT_HDR_DFF8 CONTRACT_HDR_DFF8
, CONTRACT_HDR_DFF9 CONTRACT_HDR_DFF9
, CONTRACT_HDR_DFF10 CONTRACT_HDR_DFF10
, CONTRACT_HDR_DFF11 CONTRACT_HDR_DFF11
, CONTRACT_HDR_DFF12 CONTRACT_HDR_DFF12
, CONTRACT_HDR_DFF13 CONTRACT_HDR_DFF13
, CONTRACT_HDR_DFF14 CONTRACT_HDR_DFF14
, CONTRACT_HDR_DFF15 CONTRACT_HDR_DFF15
, CONTRACT_ACCRUAL_STATUS CONTRACT_ACCRUAL_STATUS
, CONTRACT_GEN_ACCRUAL_OVRIDE_YN CONTRACT_GEN_ACCRUAL_OVRIDE_YN
, CONTRACT_CREDIT_ACT_YN CONTRACT_CREDIT_ACT_YN
, CONTRACT_CONVERTED_ACCOUNT_YN CONTRACT_CONVERTED_ACCOUNT_YN
, CONTRACT_AFTER_TAX_YIELD CONTRACT_AFTER_TAX_YIELD
, CONTRACT_IMPL_INTEREST_RATE CONTRACT_IMPL_INTEREST_RATE
, CONTRACT_LAST_INT_CALC_DATE CONTRACT_LAST_INT_CALC_DATE
, CONTRACT_BOOK_CLASS_CODE CONTRACT_BOOK_CLASS_CODE
, CONTRACT_BOOK_CLASSIFICATION CONTRACT_BOOK_CLASSIFICATION
, CONTRACT_PRE_TAX_IRR CONTRACT_PRE_TAX_IRR
, CONTRACT_AFTER_TAX_IRR CONTRACT_AFTER_TAX_IRR
, CONTRACT_EXP_DELIVERY_DATE CONTRACT_EXP_DELIVERY_DATE
, CONTRACT_ACCEPTANCE_DATE CONTRACT_ACCEPTANCE_DATE
, CONTRACT_PREFUND_ELIG_YN CONTRACT_PREFUND_ELIG_YN
, CONTRACT_REVOL_CREDIT_ELIG_YN CONTRACT_REVOL_CREDIT_ELIG_YN
, CONTRACT_CURRENCY_CONV_TYPE CONTRACT_CURRENCY_CONV_TYPE
, CONTRACT_CURRENCY_CONV_RATE CONTRACT_CURRENCY_CONV_RATE
, CONTRACT_CURRENCY_CONV_DATE CONTRACT_CURRENCY_CONV_DATE
, CONTRACT_MULTI_GAAP_ELIG_YN CONTRACT_MULTI_GAAP_ELIG_YN
, CONTRACT_INVESTOR_ASSIGN_YN CONTRACT_INVESTOR_ASSIGN_YN
, CONTRACT_SECURITIZATION_TYPE CONTRACT_SECURITIZATION_TYPE
, CONTRACT_SUB_AFTER_TAX_YIELD CONTRACT_SUB_AFTER_TAX_YIELD
, CONTRACT_SUB_IMPL_INT_RATE CONTRACT_SUB_IMPL_INT_RATE
, CONTRACT_SUB_PRE_TAX_IRR CONTRACT_SUB_PRE_TAX_IRR
, CONTRACT_SUB_AFTER_TAX_IRR CONTRACT_SUB_AFTER_TAX_IRR
, CONTRACT_CRDTLINE_TRNSFR_AMT CONTRACT_CRDTLINE_TRNSFR_AMT
, CONTRACT_CRDTLINE_NETRNSFR_AMT CONTRACT_CRDTLINE_NETRNSFR_AMT
, CONTRACT_CRDTLINE_LIMIT CONTRACT_CRDTLINE_LIMIT
, CONTRACT_CRDTLINE_FUNDING_AMT CONTRACT_CRDTLINE_FUNDING_AMT
, CONTRACT_TEMPL_TYPE_CODE CONTRACT_TEMPL_TYPE_CODE
, CONTRACT_TRADEIN_DESCRIPTION CONTRACT_TRADEIN_DESCRIPTION
, CONTRACT_TRADEIN_DATE CONTRACT_TRADEIN_DATE
, CONTRACT_LEGAL_ENTITY_ID CONTRACT_LEGAL_ENTITY_ID
, CONTRACT_FIRST_ACTIVITY_DATE CONTRACT_FIRST_ACTIVITY_DATE
, CONTRACT_ACCUMULATED_DEP CONTRACT_ACCUMULATED_DEP
, CONTRACT_CAPITALIZED_REDUCTION CONTRACT_CAPITALIZED_REDUCTION
, CONTRACT_CAPITALIZED_FEE CONTRACT_CAPITALIZED_FEE
, CONTRACT_CAPITALIZED_INTEREST CONTRACT_CAPITALIZED_INTEREST
, CONTRACT_DISCOUNT CONTRACT_DISCOUNT
, CONTRACT_ASSET_COST CONTRACT_ASSET_COST
, CONTRACT_FINANCED_FEE CONTRACT_FINANCED_FEE
, CONTRACT_NEXT_PAYMENT_AMT CONTRACT_NEXT_PAYMENT_AMT
, CONTRACT_TOTAL_ACCRUED_INT CONTRACT_TOTAL_ACCRUED_INT
, CONTRACT_TOTAL_ACTUAL_INT CONTRACT_TOTAL_ACTUAL_INT
, CONTRACT_SUBSIDY_AMOUNT CONTRACT_SUBSIDY_AMOUNT
, CONTRACT_UNACCRUED_SUBSIDY CONTRACT_UNACCRUED_SUBSIDY
, CONTRACT_UNBILLED_DUE_AMOUNT CONTRACT_UNBILLED_DUE_AMOUNT
, CONTRACT_UNBILLED_RECEIVABLES CONTRACT_UNBILLED_RECEIVABLES
, CONTRACT_OEC CONTRACT_OEC
, CONTRACT_ACTUAL_PRINC_BAL CONTRACT_ACTUAL_PRINC_BAL
, ROLLOVER_FEE_AMOUNT ROLLOVER_FEE_AMOUNT
, CONTRACT_TRADEIN_AMOUNT CONTRACT_TRADEIN_AMOUNT
, TOTAL_AMOUNT_PAID_TO_DEALER TOTAL_AMOUNT_PAID_TO_DEALER
, TOTAL_DEBITS_FOR_PREFUNDING TOTAL_DEBITS_FOR_PREFUNDING
, CONTRACT_PREFUNDED_AMOUNT CONTRACT_PREFUNDED_AMOUNT
, CONTRACT_BILLED_RENTS CONTRACT_BILLED_RENTS
, CONTRACT_BILLED_RENTS_FUNC CONTRACT_BILLED_RENTS_FUNC
, CONTRACT_BILLED_NON_RENTS CONTRACT_BILLED_NON_RENTS
, CONTRACT_BILLED_NON_RENTS_FUNC CONTRACT_BILLED_NON_RENTS_FUNC
, SUPPLIER_RETENTION_FUNDING_AMT SUPPLIER_RETENTION_FUNDING_AMT
, ASSETS_FUNDED_AMOUNT ASSETS_FUNDED_AMOUNT
, EXPENSE_FUNDED_AMOUNT EXPENSE_FUNDED_AMOUNT
, CONTRACT_IDC_AMOUNT CONTRACT_IDC_AMOUNT
, CONTRACT_SCHEDULED_PRINC_BAL CONTRACT_SCHEDULED_PRINC_BAL
, CONTRACT_INTEREST_RATE CONTRACT_INTEREST_RATE
, CONTRACT_DAYS_TO_ACCRUE CONTRACT_DAYS_TO_ACCRUE
, CONTRACT_DAYS_IN_YEAR CONTRACT_DAYS_IN_YEAR
, CONTRACT_CAP_AMOUNT CONTRACT_CAP_AMOUNT
, CONTRACT_FINANCED_AMOUNT CONTRACT_FINANCED_AMOUNT
, CONTRACT_VAR_INCOME_ACCRUAL CONTRACT_VAR_INCOME_ACCRUAL
, TOTAL_PREFUNDING_AMOUNT TOTAL_PREFUNDING_AMOUNT
, OPERATING_UNIT OPERATING_UNIT
, OPERATING_UNIT_SHORT_CODE OPERATING_UNIT_SHORT_CODE
, CONTRACT_STATUS_TYPE_CODE CONTRACT_STATUS_TYPE_CODE
, CONTRACT_STATUS CONTRACT_STATUS
, CONTRACT_FEE_INCOME CONTRACT_FEE_INCOME
, ACC_ENGINE_TEMPL_SET_ID ACC_ENGINE_TEMPL_SET_ID
, CONTRACT_FIN_PROD_TEMPLATE_ID CONTRACT_FIN_PROD_TEMPLATE_ID
, CONTRACT_FINANCIAL_PRODUCT CONTRACT_FINANCIAL_PRODUCT
, CONTRACT_FIN_PROD_DESC CONTRACT_FIN_PROD_DESC
, REPORTING_PRODUCT_ID REPORTING_PRODUCT_ID
, CONTRACT_FIN_PROD_STATUS_CODE CONTRACT_FIN_PROD_STATUS_CODE
, CONTRACT_FIN_PROD_EFF_FROM_DT CONTRACT_FIN_PROD_EFF_FROM_DT
, CONTRACT_FIN_PROD_EFF_TO_DT CONTRACT_FIN_PROD_EFF_TO_DT
, REPORTING_PRODUCT REPORTING_PRODUCT
, VENDOR_PROGRAM_NAME VENDOR_PROGRAM_NAME
, VENDOR_NUMBER VENDOR_NUMBER
, VENDOR_NAME VENDOR_NAME
, VENDOR_TYPE_CODE VENDOR_TYPE_CODE
, VENDOR_BILL_TO_SITE_USE_ID VENDOR_BILL_TO_SITE_USE_ID
, VENDOR_PARTY_ROLE VENDOR_PARTY_ROLE
, TOTAL_UPFRONT_TAX_ON_ASSETS TOTAL_UPFRONT_TAX_ON_ASSETS
, TOTAL_NUMBER_OF_ASSETS TOTAL_NUMBER_OF_ASSETS
, FUNCTIONAL_CURRENCY FUNCTIONAL_CURRENCY
, LEDGER_ID LEDGER_ID
, LEDGER LEDGER
, CONTRACT_EARLIEST_BILL_DATE CONTRACT_EARLIEST_BILL_DATE
, CONTRACT_SALES_REP CONTRACT_SALES_REP
, LEGAL_ENTITY LEGAL_ENTITY
, CUSTOMER_PARTY_NUMBER CUSTOMER_PARTY_NUMBER
, CUSTOMER_PARTY_NAME CUSTOMER_PARTY_NAME
, CUSTOMER_PARTY_TYPE CUSTOMER_PARTY_TYPE
, CUSTOMER_SIC_CODE CUSTOMER_SIC_CODE
, CUSTOMER_HQ_BRANCH_IND CUSTOMER_HQ_BRANCH_IND
, CUSTOMER_TAX_REFERENCE CUSTOMER_TAX_REFERENCE
, CUSTOMER_DUNS_NUMBER CUSTOMER_DUNS_NUMBER
, CUSTOMER_ALIAS CUSTOMER_ALIAS
, CUSTOMER_COUNTRY CUSTOMER_COUNTRY
, CUSTOMER_ADDRESS1 CUSTOMER_ADDRESS1
, CUSTOMER_ADDRESS2 CUSTOMER_ADDRESS2
, CUSTOMER_ADDRESS3 CUSTOMER_ADDRESS3
, CUSTOMER_ADDRESS4 CUSTOMER_ADDRESS4
, CUSTOMER_CITY CUSTOMER_CITY
, CUSTOMER_POSTAL_CODE CUSTOMER_POSTAL_CODE
, CUSTOMER_STATE CUSTOMER_STATE
, CUSTOMER_PROVINCE CUSTOMER_PROVINCE
, CUSTOMER_COUNTY CUSTOMER_COUNTY
, CUSTOMER_SIC_CODE_TYPE CUSTOMER_SIC_CODE_TYPE
, CUSTOMER_URL CUSTOMER_URL
, FINANCIAL_INFO_FISCAL_YEAR FINANCIAL_INFO_FISCAL_YEAR
, CUSTOMER_FISCAL_YEAREND_MONTH CUSTOMER_FISCAL_YEAREND_MONTH
, TOTAL_NUM_OF_EMPLOYEES TOTAL_NUM_OF_EMPLOYEES
, CURR_FISC_YEAR_POTENTIAL_REV CURR_FISC_YEAR_POTENTIAL_REV
, NEXT_FISC_YEAR_POTENTIAL_REV NEXT_FISC_YEAR_POTENTIAL_REV
, CUSTOMER_YEAR_ESTABLISHED CUSTOMER_YEAR_ESTABLISHED
, GEN_SERV_ADMIN_INDICATOR GEN_SERV_ADMIN_INDICATOR
, CUSTOMER_ORG_NAME_PHONETIC CUSTOMER_ORG_NAME_PHONETIC
, CUSTOMER_COMPETITOR_YN CUSTOMER_COMPETITOR_YN
, CUSTOMER_ALIAS2 CUSTOMER_ALIAS2
, CUSTOMER_ALIAS3 CUSTOMER_ALIAS3
, CUSTOMER_ALIAS4 CUSTOMER_ALIAS4
, CUSTOMER_ALIAS5 CUSTOMER_ALIAS5
, CUSTOMER_PRIM_PHONE_PURPOSE CUSTOMER_PRIM_PHONE_PURPOSE
, CUSTOMER_PRIM_PHONE_TYPE CUSTOMER_PRIM_PHONE_TYPE
, CUSTOMER_PRIM_PH_COUNTRY_CODE CUSTOMER_PRIM_PH_COUNTRY_CODE
, CUSTOMER_PRIM_PH_AREA_CODE CUSTOMER_PRIM_PH_AREA_CODE
, CUSTOMER_PRIM_PHONE_NUMBER CUSTOMER_PRIM_PHONE_NUMBER
, CUSTOMER_PRIM_PHONE_EXTN CUSTOMER_PRIM_PHONE_EXTN
, CUSTOMER_HOME_COUNTRY CUSTOMER_HOME_COUNTRY
, CUSTOMER_STATUS CUSTOMER_STATUS
, CUSTOMER_PARTY_ID CUSTOMER_PARTY_ID
, CUSTOMER_ACCOUNT_NUMBER CUSTOMER_ACCOUNT_NUMBER
, CUSTOMER_ACC_DFF_CATEGORY CUSTOMER_ACC_DFF_CATEGORY
, CUSTOMER_ACC_DFF1 CUSTOMER_ACC_DFF1
, CUSTOMER_ACC_DFF2 CUSTOMER_ACC_DFF2
, CUSTOMER_ACC_DFF3 CUSTOMER_ACC_DFF3
, CUSTOMER_ACC_DFF4 CUSTOMER_ACC_DFF4
, CUSTOMER_ACC_DFF5 CUSTOMER_ACC_DFF5
, CUSTOMER_ACC_DFF6 CUSTOMER_ACC_DFF6
, CUSTOMER_ACC_DFF7 CUSTOMER_ACC_DFF7
, CUSTOMER_ACC_DFF8 CUSTOMER_ACC_DFF8
, CUSTOMER_ACC_DFF9 CUSTOMER_ACC_DFF9
, CUSTOMER_ACC_DFF10 CUSTOMER_ACC_DFF10
, CUSTOMER_ACC_DFF11 CUSTOMER_ACC_DFF11
, CUSTOMER_ACC_DFF12 CUSTOMER_ACC_DFF12
, CUSTOMER_ACC_DFF13 CUSTOMER_ACC_DFF13
, CUSTOMER_ACC_DFF14 CUSTOMER_ACC_DFF14
, CUSTOMER_ACC_DFF15 CUSTOMER_ACC_DFF15
, CUSTOMER_ACC_DFF16 CUSTOMER_ACC_DFF16
, CUSTOMER_ACC_DFF17 CUSTOMER_ACC_DFF17
, CUSTOMER_ACC_DFF18 CUSTOMER_ACC_DFF18
, CUSTOMER_ACC_DFF19 CUSTOMER_ACC_DFF19
, CUSTOMER_ACC_DFF20 CUSTOMER_ACC_DFF20
, CUSTOMER_ACCOUNT_STATUS CUSTOMER_ACCOUNT_STATUS
, CUSTOMER_TYPE CUSTOMER_TYPE
, CUSTOMER_SALES_CHANNEL CUSTOMER_SALES_CHANNEL
, CUSTOMER_ACC_ESTAB_DATE CUSTOMER_ACC_ESTAB_DATE
, CUSTOMER_ACCOUNT_NAME CUSTOMER_ACCOUNT_NAME
, CUSTOMER_ACCOUNT_COMMENTS CUSTOMER_ACCOUNT_COMMENTS
, CUSTOMER_LAST_STATUS_UPD_DT CUSTOMER_LAST_STATUS_UPD_DT
, CUSTOMER_PARTY_SITE_ID CUSTOMER_PARTY_SITE_ID
, CUSTOMER_PARTY_SITE_NUMBER CUSTOMER_PARTY_SITE_NUMBER
, CUSTOMER_PARTY_SITE_NAME CUSTOMER_PARTY_SITE_NAME
, CUSTOMER_PARTY_SITE_LOC_ID CUSTOMER_PARTY_SITE_LOC_ID
, CUSTOMER_IDENTIFYING_ADR_FLAG CUSTOMER_IDENTIFYING_ADR_FLAG
, CUSTOMER_PARTY_SITE_STATUS CUSTOMER_PARTY_SITE_STATUS
, CUSTOMER_PARTY_SITE_ADDRESSEE CUSTOMER_PARTY_SITE_ADDRESSEE
, CUSTOMER_SITE_GLOB_LOC_NUM CUSTOMER_SITE_GLOB_LOC_NUM
, CUSTOMER_PARTY_SITE_USE_ID CUSTOMER_PARTY_SITE_USE_ID
, CUSTOMER_PARTY_SITE_USE_TYPE CUSTOMER_PARTY_SITE_USE_TYPE
, CUSTOMER_PARTY_SITE_COMMENTS CUSTOMER_PARTY_SITE_COMMENTS
, CUSTOMER_PARTY_SITE_USE_STATUS CUSTOMER_PARTY_SITE_USE_STATUS
, CONTRACT_PAST_DUE_AMT_1_30 CONTRACT_PAST_DUE_AMT_1_30
, CONTRACT_PAST_DUE_AMT_31_60 CONTRACT_PAST_DUE_AMT_31_60
, CONTRACT_PAST_DUE_AMT_61_90 CONTRACT_PAST_DUE_AMT_61_90
, CONTRACT_PAST_DUE_AMT_91_120 CONTRACT_PAST_DUE_AMT_91_120
, CONTRACT_PAST_DUE_AMT_120_PLUS CONTRACT_PAST_DUE_AMT_120_PLUS
, CONTRACT_TOT_PAST_DUE_AMT CONTRACT_TOT_PAST_DUE_AMT
, CONTRACT_TOT_BILLED_RECEIVABLE CONTRACT_TOT_BILLED_RECEIVABLE
, CONTRACT_RESIDUAL_AMOUNT CONTRACT_RESIDUAL_AMOUNT
, CONTRACT_RENT_AMOUNT CONTRACT_RENT_AMOUNT
, CONTRACT_ACC_DEPRECIATION CONTRACT_ACC_DEPRECIATION
, NET_INVESTMENT NET_INVESTMENT
, NET_INVESTMENT_FUNCTIONAL NET_INVESTMENT_FUNCTIONAL
, CONTRACT_AMOUNT_PREFUNDED CONTRACT_AMOUNT_PREFUNDED
, CONTRACT_TOTAL_MISC_FUND CONTRACT_TOTAL_MISC_FUND
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_LOGIN_ID PROGRAM_LOGIN_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
FROM "OKL"."OKL_CNTRCT_FIN_EXTRACT_T"