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_HEADER_INTERFACE#

Source

View Text - Preformatted


select BATCH_NUMBER BATCH_NUMBER, STATUS STATUS, CREATED_BY CREATED_BY, DATE_CREATED DATE_CREATED, DATE_CREATED_IN_OKL DATE_CREATED_IN_OKL, APPLICATION_CODE APPLICATION_CODE, CONTRACT_CATEGORY CONTRACT_CATEGORY, CONTRACT_NUMBER_OLD CONTRACT_NUMBER_OLD, CONTRACT_SOURCE CONTRACT_SOURCE, CONTRACT_NUMBER CONTRACT_NUMBER, CUSTOMER_NUMBER CUSTOMER_NUMBER, CUSTOMER_ID CUSTOMER_ID, CUSTOMER_ACCOUNT_NUMBER CUSTOMER_ACCOUNT_NUMBER, CUSTOMER_ACCOUNT_ID CUSTOMER_ACCOUNT_ID, START_DATE START_DATE, IMPORT_REQUEST_STAGE IMPORT_REQUEST_STAGE, CURRENCY_CODE CURRENCY_CODE, CUSTOMER_PO_NUMBER CUSTOMER_PO_NUMBER, DATE_SIGNED DATE_SIGNED, DATE_APPROVED DATE_APPROVED, ACCEPTANCE_METHOD_CODE ACCEPTANCE_METHOD_CODE, CONSUMER_CREDIT_ACT_DEAL_FLAG CONSUMER_CREDIT_ACT_DEAL_FLAG, TERM TERM, CONVERTED_ACCOUNT CONVERTED_ACCOUNT, ACCEPTED_DATE ACCEPTED_DATE, DEAL_TYPE_CODE DEAL_TYPE_CODE, EXPECTED_DELIVERY_DATE EXPECTED_DELIVERY_DATE, CONTRACT_DESCRIPTION CONTRACT_DESCRIPTION, SALESPERSON_NAME SALESPERSON_NAME, SALESPERSON_ID SALESPERSON_ID, PRIVATE_LABEL_NUMBER PRIVATE_LABEL_NUMBER, PRIVATE_LABEL_ID PRIVATE_LABEL_ID, PRIVATE_LABEL_URL PRIVATE_LABEL_URL, PROGRAM_AGREEMENT_NUMBER PROGRAM_AGREEMENT_NUMBER, PROGRAM_AGREEMENT_ID PROGRAM_AGREEMENT_ID, PROGRAM_VENDOR_NAME PROGRAM_VENDOR_NAME, PROGRAM_VENDOR_ID PROGRAM_VENDOR_ID, MASTER_LEASE_AGREEMENT_NUMBER MASTER_LEASE_AGREEMENT_NUMBER, MASTER_LEASE_AGREEMENT_ID MASTER_LEASE_AGREEMENT_ID, PRODUCT_NAME PRODUCT_NAME, PRODUCT_ID PRODUCT_ID, CALCULATE_RESIDUAL_INSURANCE CALCULATE_RESIDUAL_INSURANCE, REBOOK_LIMIT_DATE REBOOK_LIMIT_DATE, IMPORT_REQUEST_ID IMPORT_REQUEST_ID, END_OF_TERM_OPTION END_OF_TERM_OPTION, END_OF_TERM_AMOUNT END_OF_TERM_AMOUNT, MID_TERM_OPTION MID_TERM_OPTION, MID_TERM_AMOUNT MID_TERM_AMOUNT, SECURITY_DEPOSIT_HOLD_FLAG SECURITY_DEPOSIT_HOLD_FLAG, SECURITY_DEPOSIT_NET_FLAG SECURITY_DEPOSIT_NET_FLAG, SECURITY_DEPOSIT_DATE SECURITY_DEPOSIT_DATE, RENEWAL_NOTICE_DAYS RENEWAL_NOTICE_DAYS, RENEWAL_OPTION RENEWAL_OPTION, RENEWAL_AMOUNT RENEWAL_AMOUNT, LATE_INTEREST_HELD_UNTIL_DATE LATE_INTEREST_HELD_UNTIL_DATE, LATE_INTEREST_EXEMPT_FLAG LATE_INTEREST_EXEMPT_FLAG, LATE_CHARGE_HELD_UNTIL_DATE LATE_CHARGE_HELD_UNTIL_DATE, LATE_CHARGE_PRODUCT_CODE LATE_CHARGE_PRODUCT_CODE, LATE_CHARGE_EXEMPT_FLAG LATE_CHARGE_EXEMPT_FLAG, VARIABLE_RATE VARIABLE_RATE, CONVERT_TYPE CONVERT_TYPE, CONVERSION_METHOD CONVERSION_METHOD, DATE_OF_CONVERSION DATE_OF_CONVERSION, CONVERT_BY_DATE CONVERT_BY_DATE, VARIABLE_METHOD VARIABLE_METHOD, INDEX_NAME INDEX_NAME, BASE_RATE BASE_RATE, ADDER ADDER, MINIMUM_RATE MINIMUM_RATE, MAXIMUM_RATE MAXIMUM_RATE, TOLERANCE TOLERANCE, ADJUSTMENT_FREQUENCY ADJUSTMENT_FREQUENCY, DAYS_IN_YEAR DAYS_IN_YEAR, DAYS_IN_MONTH DAYS_IN_MONTH, INTEREST_METHOD INTEREST_METHOD, INTEREST_START_DATE INTEREST_START_DATE, METHOD_OF_CALCULATION METHOD_OF_CALCULATION, FORMULA_NAME FORMULA_NAME, CAPITALIZE_FLAG CAPITALIZE_FLAG, NON_NOTIFICATION_FLAG NON_NOTIFICATION_FLAG, TAX_WITHHOLDING_FLAG TAX_WITHHOLDING_FLAG, TAX_CALC_FORMULA_NAME TAX_CALC_FORMULA_NAME, TAX_OWNER TAX_OWNER, FACTORING_DATE FACTORING_DATE, FACTORING_PERCENTAGE FACTORING_PERCENTAGE, FACTORING_DISCOUNT_RATE FACTORING_DISCOUNT_RATE, EVERGREEN_ELIGIBLE_FLAG EVERGREEN_ELIGIBLE_FLAG, BILL_TO_ADDRESS_ID BILL_TO_ADDRESS_ID, BILL_TO_ADDRESS BILL_TO_ADDRESS, BANK_ACCOUNT_ID BANK_ACCOUNT_ID, BANK_ACCOUNT_NUMBER BANK_ACCOUNT_NUMBER, REASON_FOR_INVOICE_REVIEW REASON_FOR_INVOICE_REVIEW, INVOICE_REVIEW_UNTIL_DATE INVOICE_REVIEW_UNTIL_DATE, INVOICE_FORMAT_ID INVOICE_FORMAT_ID, INVOICE_FORMAT_CODE INVOICE_FORMAT_CODE, REVIEW_INVOICE_FLAG REVIEW_INVOICE_FLAG, PAYMENT_METHOD_ID PAYMENT_METHOD_ID, PAYMENT_METHOD PAYMENT_METHOD, AUTHORING_ORG_ID AUTHORING_ORG_ID, INVENTORY_ORGANIZATION_ID INVENTORY_ORGANIZATION_ID, POLICY_NUMBER POLICY_NUMBER, POLICY_EFFECTIVE_FROM POLICY_EFFECTIVE_FROM, POLICY_EFFECTIVE_TO POLICY_EFFECTIVE_TO, COVERED_AMOUNT COVERED_AMOUNT, DEDUCTIBLE_AMOUNT DEDUCTIBLE_AMOUNT, ENDORSEMENT ENDORSEMENT, NAME_OF_INSURED NAME_OF_INSURED, LESSOR_INSURED_FLAG LESSOR_INSURED_FLAG, LESSOR_PAYEE_FLAG LESSOR_PAYEE_FLAG, INSURANCE_COMPANY_NAME INSURANCE_COMPANY_NAME, INSURANCE_COMPANY_ID INSURANCE_COMPANY_ID, INSURANCE_COMPANY_SITE_NAME INSURANCE_COMPANY_SITE_NAME, INSURANCE_COMPANY_SITE_ID INSURANCE_COMPANY_SITE_ID, AGENT_NAME AGENT_NAME, AGENT_ID AGENT_ID, AGENT_ADDRESS_SITE_NAME AGENT_ADDRESS_SITE_NAME, AGENT_ADDRESS_SITE_ID AGENT_ADDRESS_SITE_ID, PROOF_DUE_DATE PROOF_DUE_DATE, PROOF_PROVIDED_DATE PROOF_PROVIDED_DATE, PREFUNDING_ELIGIBLE_FLAG PREFUNDING_ELIGIBLE_FLAG, PRIVATE_ACTIVITY_BOND_FLAG PRIVATE_ACTIVITY_BOND_FLAG, RVI_AUTO_CALCULATE_FLAG RVI_AUTO_CALCULATE_FLAG, RVI_GUARANTEED_AMOUNT RVI_GUARANTEED_AMOUNT, RVI_PRESENT_GUARANTEED_AMOUNT RVI_PRESENT_GUARANTEED_AMOUNT, RVI_PREMIUM_AMOUNT RVI_PREMIUM_AMOUNT, RVI_RATE RVI_RATE, TEMPLATE_NUMBER TEMPLATE_NUMBER, EVERGREEN_PASSTHRU_FEES EVERGREEN_PASSTHRU_FEES, EVERGREEN_PASSTHRU_PERCENT EVERGREEN_PASSTHRU_PERCENT, FLOOR_PRICE_FORMULA FLOOR_PRICE_FORMULA, REMKT_SALE_PRICE_FORMULA REMKT_SALE_PRICE_FORMULA, REPURCHASE_QUOTE_OPTION REPURCHASE_QUOTE_OPTION, REPURCHASE_QUOTE_FORMULA REPURCHASE_QUOTE_FORMULA, SALE_PRICE_OPTION SALE_PRICE_OPTION, SALE_PRICE_AMOUNT SALE_PRICE_AMOUNT, SALE_PRICE_FORMULA SALE_PRICE_FORMULA, SALE_PRICE_PRORATE SALE_PRICE_PRORATE, DISCOUNT_RATE_OPTION DISCOUNT_RATE_OPTION, DISCOUNT_RATE_AMOUNT DISCOUNT_RATE_AMOUNT, DISCOUNT_RATE_FORMULA DISCOUNT_RATE_FORMULA, DISCOUNT_RATE_PRORATE DISCOUNT_RATE_PRORATE, QUOTE_FEE_OPTION QUOTE_FEE_OPTION, QUOTE_FEE_AMOUNT QUOTE_FEE_AMOUNT, QUOTE_FEE_FORMULA QUOTE_FEE_FORMULA, QUOTE_FEE_PRORATE QUOTE_FEE_PRORATE, ERT_PURCHASE_OPT ERT_PURCHASE_OPT, ERT_PURCHASE_OPT_TYPE ERT_PURCHASE_OPT_TYPE, ERT_PURCHASE_OPT_AMOUNT ERT_PURCHASE_OPT_AMOUNT, ERT_PURCHASE_OPT_FORMULA ERT_PURCHASE_OPT_FORMULA, ERT_PURCHASE_OPT_PRORATE ERT_PURCHASE_OPT_PRORATE, ERT_PURCHASE_OPT_MAX_OPT ERT_PURCHASE_OPT_MAX_OPT, ERT_PURCHASE_OPT_MAX_AMT ERT_PURCHASE_OPT_MAX_AMT, ERT_PURCHASE_OPT_MAX_FORMULA ERT_PURCHASE_OPT_MAX_FORMULA, ERT_PURCHASE_OPT_MIN_OPT ERT_PURCHASE_OPT_MIN_OPT, ERT_PURCHASE_OPT_MIN_AMT ERT_PURCHASE_OPT_MIN_AMT, ERT_PURCHASE_OPT_MIN_FORMULA ERT_PURCHASE_OPT_MIN_FORMULA, EOT_PURCHASE_OPT EOT_PURCHASE_OPT, EOT_PURCHASE_OPT_TYPE EOT_PURCHASE_OPT_TYPE, EOT_PURCHASE_OPT_AMOUNT EOT_PURCHASE_OPT_AMOUNT, EOT_PURCHASE_OPT_FORMULA EOT_PURCHASE_OPT_FORMULA, EOT_PURCHASE_OPT_PRORATE EOT_PURCHASE_OPT_PRORATE, EOT_PURCHASE_OPT_MAX_OPT EOT_PURCHASE_OPT_MAX_OPT, EOT_PURCHASE_OPT_MAX_AMT EOT_PURCHASE_OPT_MAX_AMT, EOT_PURCHASE_OPT_MAX_FORMULA EOT_PURCHASE_OPT_MAX_FORMULA, EOT_PURCHASE_OPT_MIN_OPT EOT_PURCHASE_OPT_MIN_OPT, EOT_PURCHASE_OPT_MIN_AMT EOT_PURCHASE_OPT_MIN_AMT, EOT_PURCHASE_OPT_MIN_FORMULA EOT_PURCHASE_OPT_MIN_FORMULA, TQP_ERL_TERMINATION_ALWD_FLAG TQP_ERL_TERMINATION_ALWD_FLAG, TQP_PRT_TERMINATION_ALWD_FLAG TQP_PRT_TERMINATION_ALWD_FLAG, QUOTE_EFFECTIVE_DAYS QUOTE_EFFECTIVE_DAYS, QUOTE_EFF_MAX_DAYS QUOTE_EFF_MAX_DAYS, EOT_TOLERANCE_DAYS EOT_TOLERANCE_DAYS, PRT_TERMINATION_APPROVAL_REQ PRT_TERMINATION_APPROVAL_REQ, PRT_TERMINATION_ALLOWED_FLAG PRT_TERMINATION_ALLOWED_FLAG, GAIN_LOSS_APPROVAL_REQ GAIN_LOSS_APPROVAL_REQ, GAIN_LOSS_NET_QUOTE_OPT GAIN_LOSS_NET_QUOTE_OPT, GAIN_LOSS_NET_QUOTE_AMT GAIN_LOSS_NET_QUOTE_AMT, GAIN_LOSS_NET_QUOTE_FORMULA GAIN_LOSS_NET_QUOTE_FORMULA, GAIN_LOSS_TOLERANCE_ALLOWED GAIN_LOSS_TOLERANCE_ALLOWED, QUOTE_RCPT_CONTRACT_ROLE QUOTE_RCPT_CONTRACT_ROLE, QUOTE_APPROVER_CONTRACT_ROLE QUOTE_APPROVER_CONTRACT_ROLE, QUOTE_CRTSY_COPY_CONTRACT_ROLE QUOTE_CRTSY_COPY_CONTRACT_ROLE, ERT_QUOTE_CALC_TERM_OPTION ERT_QUOTE_CALC_TERM_OPTION, ERT_QUOTE_CALC_TERM_FORMULA ERT_QUOTE_CALC_TERM_FORMULA, ERT_CONTRACT_OBLIG_OPT ERT_CONTRACT_OBLIG_OPT, ERT_CONTRACT_OBLIG_AMOUNT ERT_CONTRACT_OBLIG_AMOUNT, ERT_CONTRACT_OBLIG_FORMULA ERT_CONTRACT_OBLIG_FORMULA, ERT_CONTRACT_OBLIG_PRORATE ERT_CONTRACT_OBLIG_PRORATE, ERT_DISC_RATE_OPT ERT_DISC_RATE_OPT, ERT_DISC_RATE_AMOUNT ERT_DISC_RATE_AMOUNT, ERT_DISC_RATE_FORMULA ERT_DISC_RATE_FORMULA, ERT_DISC_RATE_PRORATE ERT_DISC_RATE_PRORATE, ERT_QUOTE_FEE_OPT ERT_QUOTE_FEE_OPT, ERT_QUOTE_FEE_AMOUNT ERT_QUOTE_FEE_AMOUNT, ERT_QUOTE_FEE_FORMULA ERT_QUOTE_FEE_FORMULA, ERT_QUOTE_FEE_PRORATE ERT_QUOTE_FEE_PRORATE, ERT_RETURN_FEE_OPTION ERT_RETURN_FEE_OPTION, ERT_RETURN_FEE_AMOUNT ERT_RETURN_FEE_AMOUNT, ERT_RETURN_FEE_FORMULA ERT_RETURN_FEE_FORMULA, ERT_RETURN_FEE_PRORATE ERT_RETURN_FEE_PRORATE, ERT_ROLL_INCTV_OPTION ERT_ROLL_INCTV_OPTION, ERT_ROLL_INCTV_AMOUNT ERT_ROLL_INCTV_AMOUNT, ERT_ROLL_INCTV_FORMULA ERT_ROLL_INCTV_FORMULA, ERT_ROLL_INCTV_PRORATE ERT_ROLL_INCTV_PRORATE, ERT_SECU_DEP_DISPO_OPTION ERT_SECU_DEP_DISPO_OPTION, ERT_SECU_DEP_DISPO_AMOUNT ERT_SECU_DEP_DISPO_AMOUNT, ERT_SECU_DEP_DISPO_FORMULA ERT_SECU_DEP_DISPO_FORMULA, ERT_SECU_DEP_DISPO_PRORATE ERT_SECU_DEP_DISPO_PRORATE, ERT_TERM_PENALTY_OPTION ERT_TERM_PENALTY_OPTION, ERT_TERM_PENALTY_AMOUNT ERT_TERM_PENALTY_AMOUNT, ERT_TERM_PENALTY_FORMULA ERT_TERM_PENALTY_FORMULA, ERT_TERM_PENALTY_PRORATE ERT_TERM_PENALTY_PRORATE, ERT_TERM_PENALTY_CAP_OPTION ERT_TERM_PENALTY_CAP_OPTION, ERT_TERM_PENALTY_CAP_AMOUNT ERT_TERM_PENALTY_CAP_AMOUNT, ERT_TERM_PENALTY_CAP_FORMULA ERT_TERM_PENALTY_CAP_FORMULA, ERT_EST_PROP_TAX_OPTION ERT_EST_PROP_TAX_OPTION, ERT_EST_PROP_TAX_AMOUNT ERT_EST_PROP_TAX_AMOUNT, ERT_EST_PROP_TAX_FORMULA ERT_EST_PROP_TAX_FORMULA, ERT_EST_PROP_TAX_PRORATE ERT_EST_PROP_TAX_PRORATE, ERT_CONTR_FEES_OPTION ERT_CONTR_FEES_OPTION, ERT_OUTSTND_BAL_OPTION ERT_OUTSTND_BAL_OPTION, ERT_SERV_MANT_OPTION ERT_SERV_MANT_OPTION, EOT_QUOTE_CALC_TERM_OPTION EOT_QUOTE_CALC_TERM_OPTION, EOT_QUOTE_CALC_TERM_FORMULA EOT_QUOTE_CALC_TERM_FORMULA, EOT_CONTRACT_OBLIG_OPT EOT_CONTRACT_OBLIG_OPT, EOT_CONTRACT_OBLIG_AMOUNT EOT_CONTRACT_OBLIG_AMOUNT, EOT_CONTRACT_OBLIG_FORMULA EOT_CONTRACT_OBLIG_FORMULA, EOT_CONTRACT_OBLIG_PRORATE EOT_CONTRACT_OBLIG_PRORATE, EOT_DISC_RATE_OPT EOT_DISC_RATE_OPT, EOT_DISC_RATE_AMOUNT EOT_DISC_RATE_AMOUNT, EOT_DISC_RATE_FORMULA EOT_DISC_RATE_FORMULA, EOT_DISC_RATE_PRORATE EOT_DISC_RATE_PRORATE, EOT_QUOTE_FEE_OPT EOT_QUOTE_FEE_OPT, EOT_QUOTE_FEE_AMOUNT EOT_QUOTE_FEE_AMOUNT, EOT_QUOTE_FEE_FORMULA EOT_QUOTE_FEE_FORMULA, EOT_QUOTE_FEE_PRORATE EOT_QUOTE_FEE_PRORATE, EOT_RETURN_FEE_OPTION EOT_RETURN_FEE_OPTION, EOT_RETURN_FEE_AMOUNT EOT_RETURN_FEE_AMOUNT, EOT_RETURN_FEE_FORMULA EOT_RETURN_FEE_FORMULA, EOT_RETURN_FEE_PRORATE EOT_RETURN_FEE_PRORATE, EOT_ROLL_INCTV_OPTION EOT_ROLL_INCTV_OPTION, EOT_ROLL_INCTV_AMOUNT EOT_ROLL_INCTV_AMOUNT, EOT_ROLL_INCTV_FORMULA EOT_ROLL_INCTV_FORMULA, EOT_ROLL_INCTV_PRORATE EOT_ROLL_INCTV_PRORATE, EOT_SECU_DEP_DISPO_OPTION EOT_SECU_DEP_DISPO_OPTION, EOT_SECU_DEP_DISPO_AMOUNT EOT_SECU_DEP_DISPO_AMOUNT, EOT_SECU_DEP_DISPO_FORMULA EOT_SECU_DEP_DISPO_FORMULA, EOT_SECU_DEP_DISPO_PRORATE EOT_SECU_DEP_DISPO_PRORATE, EOT_TERM_PENALTY_OPTION EOT_TERM_PENALTY_OPTION, EOT_TERM_PENALTY_AMOUNT EOT_TERM_PENALTY_AMOUNT, EOT_TERM_PENALTY_FORMULA EOT_TERM_PENALTY_FORMULA, EOT_TERM_PENALTY_PRORATE EOT_TERM_PENALTY_PRORATE, EOT_TERM_PENALTY_CAP_OPTION EOT_TERM_PENALTY_CAP_OPTION, EOT_TERM_PENALTY_CAP_AMOUNT EOT_TERM_PENALTY_CAP_AMOUNT, EOT_TERM_PENALTY_CAP_FORMULA EOT_TERM_PENALTY_CAP_FORMULA, EOT_EST_PROP_TAX_OPTION EOT_EST_PROP_TAX_OPTION, EOT_EST_PROP_TAX_AMOUNT EOT_EST_PROP_TAX_AMOUNT, EOT_EST_PROP_TAX_FORMULA EOT_EST_PROP_TAX_FORMULA, EOT_EST_PROP_TAX_PRORATE EOT_EST_PROP_TAX_PRORATE, EOT_CONTR_FEES_OPTION EOT_CONTR_FEES_OPTION, EOT_OUTSTND_BAL_OPTION EOT_OUTSTND_BAL_OPTION, EOT_SERV_MANT_OPTION EOT_SERV_MANT_OPTION, LIEN_TYPE LIEN_TYPE, FILING_NUMBER FILING_NUMBER, FILING_DATE FILING_DATE, FILING_STATUS FILING_STATUS, LIEN_HOLDER_NAME LIEN_HOLDER_NAME, LIEN_HOLDER_ID LIEN_HOLDER_ID, JURISDICTION JURISDICTION, SUB_JURISDICTION 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_NAME TITLE_ISSUER_NAME, TITLE_ISSUER_ID TITLE_ISSUER_ID, TITLE_DATE TITLE_DATE, TITLE_NUMBER TITLE_NUMBER, REGISTRATION_NUMBER REGISTRATION_NUMBER, LOCATION LOCATION, TITLE_CUSTODIAN_NAME TITLE_CUSTODIAN_NAME, TITLE_CUSTODIAN_ID TITLE_CUSTODIAN_ID, PAYEE_SITE PAYEE_SITE, REGISTRATION_LOCATION REGISTRATION_LOCATION, REG_EXPIRATION_DATE REG_EXPIRATION_DATE, CREDIT_LINE_ID CREDIT_LINE_ID, CREDIT_LINE_NUMBER CREDIT_LINE_NUMBER, PRTFL_APPROVAL_REQ PRTFL_APPROVAL_REQ, PRTFL_ASSGN_GROUP PRTFL_ASSGN_GROUP, PRTFL_BUDGET_AMT_OPT PRTFL_BUDGET_AMT_OPT, PRTFL_BUDGET_FIXED_AMT PRTFL_BUDGET_FIXED_AMT, PRTFL_BUDGET_AMT_FORMULA PRTFL_BUDGET_AMT_FORMULA, PRTFL_DAYS_FROM_CON_EXPR PRTFL_DAYS_FROM_CON_EXPR, PRTFL_STRATEGY PRTFL_STRATEGY, PROP_TAX_APPLICABLE PROP_TAX_APPLICABLE, PROP_TAX_LEASE_REP PROP_TAX_LEASE_REP, MEX_TAX_SUB_BASIC_WTHLD MEX_TAX_SUB_BASIC_WTHLD, MEX_TAX_CALC_FORMULA MEX_TAX_CALC_FORMULA, AUS_TAX_STAMP_DUTY AUS_TAX_STAMP_DUTY, CURRENCY_CONVERSION_TYPE CURRENCY_CONVERSION_TYPE, CURRENCY_CONVERSION_RATE CURRENCY_CONVERSION_RATE, CURRENCY_CONVERSION_DATE CURRENCY_CONVERSION_DATE, ASSIGNABLE_YN ASSIGNABLE_YN, LESSEE_VENDOR_ID LESSEE_VENDOR_ID, LESSEE_VENDOR_NAME LESSEE_VENDOR_NAME, LESSEE_VENDOR_SITE_ID LESSEE_VENDOR_SITE_ID, LESSEE_VENDOR_SITE_CODE LESSEE_VENDOR_SITE_CODE, INSURANCE_COMPANY_NUMBER INSURANCE_COMPANY_NUMBER, INSURANCE_COMPANY_SITE_NUMBER INSURANCE_COMPANY_SITE_NUMBER, AGENT_NUMBER AGENT_NUMBER, AGENT_ADDRESS_SITE_NUMBER AGENT_ADDRESS_SITE_NUMBER, CASH_APPL_RULE_NAME CASH_APPL_RULE_NAME, PROP_TAX_BILL_METHOD PROP_TAX_BILL_METHOD, GAIN_LOSS_TOLRNC_ALLWD_AMT GAIN_LOSS_TOLRNC_ALLWD_AMT, GAIN_LOSS_TOLRNC_ALLWD_FRML GAIN_LOSS_TOLRNC_ALLWD_FRML, GAIN_LOSS_TOLRNC_BASIS GAIN_LOSS_TOLRNC_BASIS, GAIN_LOSS_APPRV_PROC_FRML GAIN_LOSS_APPRV_PROC_FRML, ERT_ABSORBED_FEE_FRML ERT_ABSORBED_FEE_FRML, ERT_EXPENSE_FEE_FRML ERT_EXPENSE_FEE_FRML, ERT_FINANCED_FEE_FRML ERT_FINANCED_FEE_FRML, ERT_GENERAL_FEE_FRML ERT_GENERAL_FEE_FRML, ERT_INCOME_FEE_FRML ERT_INCOME_FEE_FRML, ERT_MISC_FEE_FRML ERT_MISC_FEE_FRML, ERT_PASSTHRU_FEE_FRML ERT_PASSTHRU_FEE_FRML, ERT_ROLLOVER_FEE_FRML ERT_ROLLOVER_FEE_FRML, EOT_ABSORBED_FEE_FRML EOT_ABSORBED_FEE_FRML, EOT_EXPENSE_FEE_FRML EOT_EXPENSE_FEE_FRML, EOT_FINANCED_FEE_FRML EOT_FINANCED_FEE_FRML, EOT_GENERAL_FEE_FRML EOT_GENERAL_FEE_FRML, EOT_INCOME_FEE_FRML EOT_INCOME_FEE_FRML, EOT_MISC_FEE_FRML EOT_MISC_FEE_FRML, EOT_PASSTHRU_FEE_FRML EOT_PASSTHRU_FEE_FRML, EOT_ROLLOVER_FEE_FRML EOT_ROLLOVER_FEE_FRML, LATE_INTEREST_PRODUCT_CODE LATE_INTEREST_PRODUCT_CODE, SCHEDULED_WORKER_ID SCHEDULED_WORKER_ID, DELETE_BEFORE_IMPORT_YN DELETE_BEFORE_IMPORT_YN, ST_UPDATE_LINES_FROM_CONTRACT ST_UPDATE_LINES_FROM_CONTRACT, ST_INTEREST_DISCLOSED ST_INTEREST_DISCLOSED, 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, ST_ASSET_UPFRONT_TAX ST_ASSET_UPFRONT_TAX, ST_BILL_STREAM_TYPE_CODE ST_BILL_STREAM_TYPE_CODE, ST_BILL_STREAM_PURPOSE_CODE ST_BILL_STREAM_PURPOSE_CODE, ST_FIN_STREAM_TYPE_CODE ST_FIN_STREAM_TYPE_CODE, ST_FIN_STREAM_PURPOSE_CODE ST_FIN_STREAM_PURPOSE_CODE, ST_CAP_STREAM_TYPE_CODE ST_CAP_STREAM_TYPE_CODE, ST_CAP_STREAM_PURPOSE_CODE ST_CAP_STREAM_PURPOSE_CODE, INT_RATE_EFFECTIVE_FROM_DATE INT_RATE_EFFECTIVE_FROM_DATE, INT_RATE_EFFECTIVE_TO_DATE INT_RATE_EFFECTIVE_TO_DATE, INT_RATE_PRINC_BASIS_CODE INT_RATE_PRINC_BASIS_CODE, INT_RATE_BASIS_CODE INT_RATE_BASIS_CODE, INT_RATE_DELAY_CODE INT_RATE_DELAY_CODE, INT_RATE_DELAY_FREQ INT_RATE_DELAY_FREQ, INT_RATE_CMPND_FREQ_CODE INT_RATE_CMPND_FREQ_CODE, INT_RATE_CATCHUP_BASIS_CODE INT_RATE_CATCHUP_BASIS_CODE, INT_RATE_CATCHUP_START_DATE INT_RATE_CATCHUP_START_DATE, INT_RATE_CAT_STLMNT_CODE INT_RATE_CAT_STLMNT_CODE, INT_RATE_CHANGE_START_DATE INT_RATE_CHANGE_START_DATE, INT_RATE_CHANGE_FREQ_CODE INT_RATE_CHANGE_FREQ_CODE, INT_RATE_CHANGE_VALUE INT_RATE_CHANGE_VALUE, INT_RATE_CON_OPTION_CODE INT_RATE_CON_OPTION_CODE, INT_RATE_NEXT_CON_DATE INT_RATE_NEXT_CON_DATE, INT_RATE_CON_INDEX_NAME INT_RATE_CON_INDEX_NAME, INT_RATE_CON_BASE_RATE INT_RATE_CON_BASE_RATE, INT_RATE_CON_START_DATE INT_RATE_CON_START_DATE, INT_RATE_CON_ADDER_RATE INT_RATE_CON_ADDER_RATE, INT_RATE_CON_MAXIMUM_RATE INT_RATE_CON_MAXIMUM_RATE, INT_RATE_CON_MINIMUM_RATE INT_RATE_CON_MINIMUM_RATE, INT_RATE_CON_PRC_BAS_CODE INT_RATE_CON_PRC_BAS_CODE, INT_RATE_CON_DAY_MTH_CODE INT_RATE_CON_DAY_MTH_CODE, INT_RATE_CON_DAY_YER_CODE INT_RATE_CON_DAY_YER_CODE, INT_RATE_CON_INT_BAS_CODE INT_RATE_CON_INT_BAS_CODE, INT_RATE_CON_RATE_DELAY_CODE INT_RATE_CON_RATE_DELAY_CODE, INT_RATE_CON_RATE_DELAY_FREQ INT_RATE_CON_RATE_DELAY_FREQ, INT_RATE_CON_CMPND_FREQ_CODE INT_RATE_CON_CMPND_FREQ_CODE, INT_RATE_CON_FORMULA_NAME INT_RATE_CON_FORMULA_NAME, INT_RATE_CON_CAT_BAS_CODE INT_RATE_CON_CAT_BAS_CODE, INT_RATE_CON_CAT_START_DATE INT_RATE_CON_CAT_START_DATE, INT_RATE_CON_CAT_STLMNT_CODE INT_RATE_CON_CAT_STLMNT_CODE, INT_RATE_CON_CHG_START_DATE INT_RATE_CON_CHG_START_DATE, INT_RATE_CON_CHG_FREQ_CODE INT_RATE_CON_CHG_FREQ_CODE, INT_RATE_CON_CHG_VALUE INT_RATE_CON_CHG_VALUE, INT_RATE_CAT_FREQ_CODE INT_RATE_CAT_FREQ_CODE, INT_RATE_CON_CAT_FREQ_CODE INT_RATE_CON_CAT_FREQ_CODE, RVI_STREAM_CODE RVI_STREAM_CODE, RVI_STREAM_PURPOSE_CODE RVI_STREAM_PURPOSE_CODE, 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, EOT_AUTO_PROC_PURCHASE_OPT EOT_AUTO_PROC_PURCHASE_OPT, 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, SEND_BILL_SALE SEND_BILL_SALE, MANUAL_QUOTES_ONLY MANUAL_QUOTES_ONLY, FIRST_TERMINATION_DATE FIRST_TERMINATION_DATE, QUOTE_RCPT_ADDL_RCPT_ROLE QUOTE_RCPT_ADDL_RCPT_ROLE, QUOTE_RCPT_ALLOC_PTG QUOTE_RCPT_ALLOC_PTG, QUOTE_APPRVR_ADV_NOTICE_ROLE QUOTE_APPRVR_ADV_NOTICE_ROLE, QUOTE_APPROVER_DELAY_DAYS QUOTE_APPROVER_DELAY_DAYS, ERT_SERV_MANT_FRML ERT_SERV_MANT_FRML, EOT_SERV_MANT_FRML EOT_SERV_MANT_FRML, LEGAL_ENTITY_ID LEGAL_ENTITY_ID, ST_TAX_SCHEDULE_APPLIES_FLAG ST_TAX_SCHEDULE_APPLIES_FLAG, PRINT_LEAD_DAYS PRINT_LEAD_DAYS from "OKL"."OKL_HEADER_INTERFACE"

View Text - HTML Formatted

SELECT BATCH_NUMBER BATCH_NUMBER
, STATUS STATUS
, CREATED_BY CREATED_BY
, DATE_CREATED DATE_CREATED
, DATE_CREATED_IN_OKL DATE_CREATED_IN_OKL
, APPLICATION_CODE APPLICATION_CODE
, CONTRACT_CATEGORY CONTRACT_CATEGORY
, CONTRACT_NUMBER_OLD CONTRACT_NUMBER_OLD
, CONTRACT_SOURCE CONTRACT_SOURCE
, CONTRACT_NUMBER CONTRACT_NUMBER
, CUSTOMER_NUMBER CUSTOMER_NUMBER
, CUSTOMER_ID CUSTOMER_ID
, CUSTOMER_ACCOUNT_NUMBER CUSTOMER_ACCOUNT_NUMBER
, CUSTOMER_ACCOUNT_ID CUSTOMER_ACCOUNT_ID
, START_DATE START_DATE
, IMPORT_REQUEST_STAGE IMPORT_REQUEST_STAGE
, CURRENCY_CODE CURRENCY_CODE
, CUSTOMER_PO_NUMBER CUSTOMER_PO_NUMBER
, DATE_SIGNED DATE_SIGNED
, DATE_APPROVED DATE_APPROVED
, ACCEPTANCE_METHOD_CODE ACCEPTANCE_METHOD_CODE
, CONSUMER_CREDIT_ACT_DEAL_FLAG CONSUMER_CREDIT_ACT_DEAL_FLAG
, TERM TERM
, CONVERTED_ACCOUNT CONVERTED_ACCOUNT
, ACCEPTED_DATE ACCEPTED_DATE
, DEAL_TYPE_CODE DEAL_TYPE_CODE
, EXPECTED_DELIVERY_DATE EXPECTED_DELIVERY_DATE
, CONTRACT_DESCRIPTION CONTRACT_DESCRIPTION
, SALESPERSON_NAME SALESPERSON_NAME
, SALESPERSON_ID SALESPERSON_ID
, PRIVATE_LABEL_NUMBER PRIVATE_LABEL_NUMBER
, PRIVATE_LABEL_ID PRIVATE_LABEL_ID
, PRIVATE_LABEL_URL PRIVATE_LABEL_URL
, PROGRAM_AGREEMENT_NUMBER PROGRAM_AGREEMENT_NUMBER
, PROGRAM_AGREEMENT_ID PROGRAM_AGREEMENT_ID
, PROGRAM_VENDOR_NAME PROGRAM_VENDOR_NAME
, PROGRAM_VENDOR_ID PROGRAM_VENDOR_ID
, MASTER_LEASE_AGREEMENT_NUMBER MASTER_LEASE_AGREEMENT_NUMBER
, MASTER_LEASE_AGREEMENT_ID MASTER_LEASE_AGREEMENT_ID
, PRODUCT_NAME PRODUCT_NAME
, PRODUCT_ID PRODUCT_ID
, CALCULATE_RESIDUAL_INSURANCE CALCULATE_RESIDUAL_INSURANCE
, REBOOK_LIMIT_DATE REBOOK_LIMIT_DATE
, IMPORT_REQUEST_ID IMPORT_REQUEST_ID
, END_OF_TERM_OPTION END_OF_TERM_OPTION
, END_OF_TERM_AMOUNT END_OF_TERM_AMOUNT
, MID_TERM_OPTION MID_TERM_OPTION
, MID_TERM_AMOUNT MID_TERM_AMOUNT
, SECURITY_DEPOSIT_HOLD_FLAG SECURITY_DEPOSIT_HOLD_FLAG
, SECURITY_DEPOSIT_NET_FLAG SECURITY_DEPOSIT_NET_FLAG
, SECURITY_DEPOSIT_DATE SECURITY_DEPOSIT_DATE
, RENEWAL_NOTICE_DAYS RENEWAL_NOTICE_DAYS
, RENEWAL_OPTION RENEWAL_OPTION
, RENEWAL_AMOUNT RENEWAL_AMOUNT
, LATE_INTEREST_HELD_UNTIL_DATE LATE_INTEREST_HELD_UNTIL_DATE
, LATE_INTEREST_EXEMPT_FLAG LATE_INTEREST_EXEMPT_FLAG
, LATE_CHARGE_HELD_UNTIL_DATE LATE_CHARGE_HELD_UNTIL_DATE
, LATE_CHARGE_PRODUCT_CODE LATE_CHARGE_PRODUCT_CODE
, LATE_CHARGE_EXEMPT_FLAG LATE_CHARGE_EXEMPT_FLAG
, VARIABLE_RATE VARIABLE_RATE
, CONVERT_TYPE CONVERT_TYPE
, CONVERSION_METHOD CONVERSION_METHOD
, DATE_OF_CONVERSION DATE_OF_CONVERSION
, CONVERT_BY_DATE CONVERT_BY_DATE
, VARIABLE_METHOD VARIABLE_METHOD
, INDEX_NAME INDEX_NAME
, BASE_RATE BASE_RATE
, ADDER ADDER
, MINIMUM_RATE MINIMUM_RATE
, MAXIMUM_RATE MAXIMUM_RATE
, TOLERANCE TOLERANCE
, ADJUSTMENT_FREQUENCY ADJUSTMENT_FREQUENCY
, DAYS_IN_YEAR DAYS_IN_YEAR
, DAYS_IN_MONTH DAYS_IN_MONTH
, INTEREST_METHOD INTEREST_METHOD
, INTEREST_START_DATE INTEREST_START_DATE
, METHOD_OF_CALCULATION METHOD_OF_CALCULATION
, FORMULA_NAME FORMULA_NAME
, CAPITALIZE_FLAG CAPITALIZE_FLAG
, NON_NOTIFICATION_FLAG NON_NOTIFICATION_FLAG
, TAX_WITHHOLDING_FLAG TAX_WITHHOLDING_FLAG
, TAX_CALC_FORMULA_NAME TAX_CALC_FORMULA_NAME
, TAX_OWNER TAX_OWNER
, FACTORING_DATE FACTORING_DATE
, FACTORING_PERCENTAGE FACTORING_PERCENTAGE
, FACTORING_DISCOUNT_RATE FACTORING_DISCOUNT_RATE
, EVERGREEN_ELIGIBLE_FLAG EVERGREEN_ELIGIBLE_FLAG
, BILL_TO_ADDRESS_ID BILL_TO_ADDRESS_ID
, BILL_TO_ADDRESS BILL_TO_ADDRESS
, BANK_ACCOUNT_ID BANK_ACCOUNT_ID
, BANK_ACCOUNT_NUMBER BANK_ACCOUNT_NUMBER
, REASON_FOR_INVOICE_REVIEW REASON_FOR_INVOICE_REVIEW
, INVOICE_REVIEW_UNTIL_DATE INVOICE_REVIEW_UNTIL_DATE
, INVOICE_FORMAT_ID INVOICE_FORMAT_ID
, INVOICE_FORMAT_CODE INVOICE_FORMAT_CODE
, REVIEW_INVOICE_FLAG REVIEW_INVOICE_FLAG
, PAYMENT_METHOD_ID PAYMENT_METHOD_ID
, PAYMENT_METHOD PAYMENT_METHOD
, AUTHORING_ORG_ID AUTHORING_ORG_ID
, INVENTORY_ORGANIZATION_ID INVENTORY_ORGANIZATION_ID
, POLICY_NUMBER POLICY_NUMBER
, POLICY_EFFECTIVE_FROM POLICY_EFFECTIVE_FROM
, POLICY_EFFECTIVE_TO POLICY_EFFECTIVE_TO
, COVERED_AMOUNT COVERED_AMOUNT
, DEDUCTIBLE_AMOUNT DEDUCTIBLE_AMOUNT
, ENDORSEMENT ENDORSEMENT
, NAME_OF_INSURED NAME_OF_INSURED
, LESSOR_INSURED_FLAG LESSOR_INSURED_FLAG
, LESSOR_PAYEE_FLAG LESSOR_PAYEE_FLAG
, INSURANCE_COMPANY_NAME INSURANCE_COMPANY_NAME
, INSURANCE_COMPANY_ID INSURANCE_COMPANY_ID
, INSURANCE_COMPANY_SITE_NAME INSURANCE_COMPANY_SITE_NAME
, INSURANCE_COMPANY_SITE_ID INSURANCE_COMPANY_SITE_ID
, AGENT_NAME AGENT_NAME
, AGENT_ID AGENT_ID
, AGENT_ADDRESS_SITE_NAME AGENT_ADDRESS_SITE_NAME
, AGENT_ADDRESS_SITE_ID AGENT_ADDRESS_SITE_ID
, PROOF_DUE_DATE PROOF_DUE_DATE
, PROOF_PROVIDED_DATE PROOF_PROVIDED_DATE
, PREFUNDING_ELIGIBLE_FLAG PREFUNDING_ELIGIBLE_FLAG
, PRIVATE_ACTIVITY_BOND_FLAG PRIVATE_ACTIVITY_BOND_FLAG
, RVI_AUTO_CALCULATE_FLAG RVI_AUTO_CALCULATE_FLAG
, RVI_GUARANTEED_AMOUNT RVI_GUARANTEED_AMOUNT
, RVI_PRESENT_GUARANTEED_AMOUNT RVI_PRESENT_GUARANTEED_AMOUNT
, RVI_PREMIUM_AMOUNT RVI_PREMIUM_AMOUNT
, RVI_RATE RVI_RATE
, TEMPLATE_NUMBER TEMPLATE_NUMBER
, EVERGREEN_PASSTHRU_FEES EVERGREEN_PASSTHRU_FEES
, EVERGREEN_PASSTHRU_PERCENT EVERGREEN_PASSTHRU_PERCENT
, FLOOR_PRICE_FORMULA FLOOR_PRICE_FORMULA
, REMKT_SALE_PRICE_FORMULA REMKT_SALE_PRICE_FORMULA
, REPURCHASE_QUOTE_OPTION REPURCHASE_QUOTE_OPTION
, REPURCHASE_QUOTE_FORMULA REPURCHASE_QUOTE_FORMULA
, SALE_PRICE_OPTION SALE_PRICE_OPTION
, SALE_PRICE_AMOUNT SALE_PRICE_AMOUNT
, SALE_PRICE_FORMULA SALE_PRICE_FORMULA
, SALE_PRICE_PRORATE SALE_PRICE_PRORATE
, DISCOUNT_RATE_OPTION DISCOUNT_RATE_OPTION
, DISCOUNT_RATE_AMOUNT DISCOUNT_RATE_AMOUNT
, DISCOUNT_RATE_FORMULA DISCOUNT_RATE_FORMULA
, DISCOUNT_RATE_PRORATE DISCOUNT_RATE_PRORATE
, QUOTE_FEE_OPTION QUOTE_FEE_OPTION
, QUOTE_FEE_AMOUNT QUOTE_FEE_AMOUNT
, QUOTE_FEE_FORMULA QUOTE_FEE_FORMULA
, QUOTE_FEE_PRORATE QUOTE_FEE_PRORATE
, ERT_PURCHASE_OPT ERT_PURCHASE_OPT
, ERT_PURCHASE_OPT_TYPE ERT_PURCHASE_OPT_TYPE
, ERT_PURCHASE_OPT_AMOUNT ERT_PURCHASE_OPT_AMOUNT
, ERT_PURCHASE_OPT_FORMULA ERT_PURCHASE_OPT_FORMULA
, ERT_PURCHASE_OPT_PRORATE ERT_PURCHASE_OPT_PRORATE
, ERT_PURCHASE_OPT_MAX_OPT ERT_PURCHASE_OPT_MAX_OPT
, ERT_PURCHASE_OPT_MAX_AMT ERT_PURCHASE_OPT_MAX_AMT
, ERT_PURCHASE_OPT_MAX_FORMULA ERT_PURCHASE_OPT_MAX_FORMULA
, ERT_PURCHASE_OPT_MIN_OPT ERT_PURCHASE_OPT_MIN_OPT
, ERT_PURCHASE_OPT_MIN_AMT ERT_PURCHASE_OPT_MIN_AMT
, ERT_PURCHASE_OPT_MIN_FORMULA ERT_PURCHASE_OPT_MIN_FORMULA
, EOT_PURCHASE_OPT EOT_PURCHASE_OPT
, EOT_PURCHASE_OPT_TYPE EOT_PURCHASE_OPT_TYPE
, EOT_PURCHASE_OPT_AMOUNT EOT_PURCHASE_OPT_AMOUNT
, EOT_PURCHASE_OPT_FORMULA EOT_PURCHASE_OPT_FORMULA
, EOT_PURCHASE_OPT_PRORATE EOT_PURCHASE_OPT_PRORATE
, EOT_PURCHASE_OPT_MAX_OPT EOT_PURCHASE_OPT_MAX_OPT
, EOT_PURCHASE_OPT_MAX_AMT EOT_PURCHASE_OPT_MAX_AMT
, EOT_PURCHASE_OPT_MAX_FORMULA EOT_PURCHASE_OPT_MAX_FORMULA
, EOT_PURCHASE_OPT_MIN_OPT EOT_PURCHASE_OPT_MIN_OPT
, EOT_PURCHASE_OPT_MIN_AMT EOT_PURCHASE_OPT_MIN_AMT
, EOT_PURCHASE_OPT_MIN_FORMULA EOT_PURCHASE_OPT_MIN_FORMULA
, TQP_ERL_TERMINATION_ALWD_FLAG TQP_ERL_TERMINATION_ALWD_FLAG
, TQP_PRT_TERMINATION_ALWD_FLAG TQP_PRT_TERMINATION_ALWD_FLAG
, QUOTE_EFFECTIVE_DAYS QUOTE_EFFECTIVE_DAYS
, QUOTE_EFF_MAX_DAYS QUOTE_EFF_MAX_DAYS
, EOT_TOLERANCE_DAYS EOT_TOLERANCE_DAYS
, PRT_TERMINATION_APPROVAL_REQ PRT_TERMINATION_APPROVAL_REQ
, PRT_TERMINATION_ALLOWED_FLAG PRT_TERMINATION_ALLOWED_FLAG
, GAIN_LOSS_APPROVAL_REQ GAIN_LOSS_APPROVAL_REQ
, GAIN_LOSS_NET_QUOTE_OPT GAIN_LOSS_NET_QUOTE_OPT
, GAIN_LOSS_NET_QUOTE_AMT GAIN_LOSS_NET_QUOTE_AMT
, GAIN_LOSS_NET_QUOTE_FORMULA GAIN_LOSS_NET_QUOTE_FORMULA
, GAIN_LOSS_TOLERANCE_ALLOWED GAIN_LOSS_TOLERANCE_ALLOWED
, QUOTE_RCPT_CONTRACT_ROLE QUOTE_RCPT_CONTRACT_ROLE
, QUOTE_APPROVER_CONTRACT_ROLE QUOTE_APPROVER_CONTRACT_ROLE
, QUOTE_CRTSY_COPY_CONTRACT_ROLE QUOTE_CRTSY_COPY_CONTRACT_ROLE
, ERT_QUOTE_CALC_TERM_OPTION ERT_QUOTE_CALC_TERM_OPTION
, ERT_QUOTE_CALC_TERM_FORMULA ERT_QUOTE_CALC_TERM_FORMULA
, ERT_CONTRACT_OBLIG_OPT ERT_CONTRACT_OBLIG_OPT
, ERT_CONTRACT_OBLIG_AMOUNT ERT_CONTRACT_OBLIG_AMOUNT
, ERT_CONTRACT_OBLIG_FORMULA ERT_CONTRACT_OBLIG_FORMULA
, ERT_CONTRACT_OBLIG_PRORATE ERT_CONTRACT_OBLIG_PRORATE
, ERT_DISC_RATE_OPT ERT_DISC_RATE_OPT
, ERT_DISC_RATE_AMOUNT ERT_DISC_RATE_AMOUNT
, ERT_DISC_RATE_FORMULA ERT_DISC_RATE_FORMULA
, ERT_DISC_RATE_PRORATE ERT_DISC_RATE_PRORATE
, ERT_QUOTE_FEE_OPT ERT_QUOTE_FEE_OPT
, ERT_QUOTE_FEE_AMOUNT ERT_QUOTE_FEE_AMOUNT
, ERT_QUOTE_FEE_FORMULA ERT_QUOTE_FEE_FORMULA
, ERT_QUOTE_FEE_PRORATE ERT_QUOTE_FEE_PRORATE
, ERT_RETURN_FEE_OPTION ERT_RETURN_FEE_OPTION
, ERT_RETURN_FEE_AMOUNT ERT_RETURN_FEE_AMOUNT
, ERT_RETURN_FEE_FORMULA ERT_RETURN_FEE_FORMULA
, ERT_RETURN_FEE_PRORATE ERT_RETURN_FEE_PRORATE
, ERT_ROLL_INCTV_OPTION ERT_ROLL_INCTV_OPTION
, ERT_ROLL_INCTV_AMOUNT ERT_ROLL_INCTV_AMOUNT
, ERT_ROLL_INCTV_FORMULA ERT_ROLL_INCTV_FORMULA
, ERT_ROLL_INCTV_PRORATE ERT_ROLL_INCTV_PRORATE
, ERT_SECU_DEP_DISPO_OPTION ERT_SECU_DEP_DISPO_OPTION
, ERT_SECU_DEP_DISPO_AMOUNT ERT_SECU_DEP_DISPO_AMOUNT
, ERT_SECU_DEP_DISPO_FORMULA ERT_SECU_DEP_DISPO_FORMULA
, ERT_SECU_DEP_DISPO_PRORATE ERT_SECU_DEP_DISPO_PRORATE
, ERT_TERM_PENALTY_OPTION ERT_TERM_PENALTY_OPTION
, ERT_TERM_PENALTY_AMOUNT ERT_TERM_PENALTY_AMOUNT
, ERT_TERM_PENALTY_FORMULA ERT_TERM_PENALTY_FORMULA
, ERT_TERM_PENALTY_PRORATE ERT_TERM_PENALTY_PRORATE
, ERT_TERM_PENALTY_CAP_OPTION ERT_TERM_PENALTY_CAP_OPTION
, ERT_TERM_PENALTY_CAP_AMOUNT ERT_TERM_PENALTY_CAP_AMOUNT
, ERT_TERM_PENALTY_CAP_FORMULA ERT_TERM_PENALTY_CAP_FORMULA
, ERT_EST_PROP_TAX_OPTION ERT_EST_PROP_TAX_OPTION
, ERT_EST_PROP_TAX_AMOUNT ERT_EST_PROP_TAX_AMOUNT
, ERT_EST_PROP_TAX_FORMULA ERT_EST_PROP_TAX_FORMULA
, ERT_EST_PROP_TAX_PRORATE ERT_EST_PROP_TAX_PRORATE
, ERT_CONTR_FEES_OPTION ERT_CONTR_FEES_OPTION
, ERT_OUTSTND_BAL_OPTION ERT_OUTSTND_BAL_OPTION
, ERT_SERV_MANT_OPTION ERT_SERV_MANT_OPTION
, EOT_QUOTE_CALC_TERM_OPTION EOT_QUOTE_CALC_TERM_OPTION
, EOT_QUOTE_CALC_TERM_FORMULA EOT_QUOTE_CALC_TERM_FORMULA
, EOT_CONTRACT_OBLIG_OPT EOT_CONTRACT_OBLIG_OPT
, EOT_CONTRACT_OBLIG_AMOUNT EOT_CONTRACT_OBLIG_AMOUNT
, EOT_CONTRACT_OBLIG_FORMULA EOT_CONTRACT_OBLIG_FORMULA
, EOT_CONTRACT_OBLIG_PRORATE EOT_CONTRACT_OBLIG_PRORATE
, EOT_DISC_RATE_OPT EOT_DISC_RATE_OPT
, EOT_DISC_RATE_AMOUNT EOT_DISC_RATE_AMOUNT
, EOT_DISC_RATE_FORMULA EOT_DISC_RATE_FORMULA
, EOT_DISC_RATE_PRORATE EOT_DISC_RATE_PRORATE
, EOT_QUOTE_FEE_OPT EOT_QUOTE_FEE_OPT
, EOT_QUOTE_FEE_AMOUNT EOT_QUOTE_FEE_AMOUNT
, EOT_QUOTE_FEE_FORMULA EOT_QUOTE_FEE_FORMULA
, EOT_QUOTE_FEE_PRORATE EOT_QUOTE_FEE_PRORATE
, EOT_RETURN_FEE_OPTION EOT_RETURN_FEE_OPTION
, EOT_RETURN_FEE_AMOUNT EOT_RETURN_FEE_AMOUNT
, EOT_RETURN_FEE_FORMULA EOT_RETURN_FEE_FORMULA
, EOT_RETURN_FEE_PRORATE EOT_RETURN_FEE_PRORATE
, EOT_ROLL_INCTV_OPTION EOT_ROLL_INCTV_OPTION
, EOT_ROLL_INCTV_AMOUNT EOT_ROLL_INCTV_AMOUNT
, EOT_ROLL_INCTV_FORMULA EOT_ROLL_INCTV_FORMULA
, EOT_ROLL_INCTV_PRORATE EOT_ROLL_INCTV_PRORATE
, EOT_SECU_DEP_DISPO_OPTION EOT_SECU_DEP_DISPO_OPTION
, EOT_SECU_DEP_DISPO_AMOUNT EOT_SECU_DEP_DISPO_AMOUNT
, EOT_SECU_DEP_DISPO_FORMULA EOT_SECU_DEP_DISPO_FORMULA
, EOT_SECU_DEP_DISPO_PRORATE EOT_SECU_DEP_DISPO_PRORATE
, EOT_TERM_PENALTY_OPTION EOT_TERM_PENALTY_OPTION
, EOT_TERM_PENALTY_AMOUNT EOT_TERM_PENALTY_AMOUNT
, EOT_TERM_PENALTY_FORMULA EOT_TERM_PENALTY_FORMULA
, EOT_TERM_PENALTY_PRORATE EOT_TERM_PENALTY_PRORATE
, EOT_TERM_PENALTY_CAP_OPTION EOT_TERM_PENALTY_CAP_OPTION
, EOT_TERM_PENALTY_CAP_AMOUNT EOT_TERM_PENALTY_CAP_AMOUNT
, EOT_TERM_PENALTY_CAP_FORMULA EOT_TERM_PENALTY_CAP_FORMULA
, EOT_EST_PROP_TAX_OPTION EOT_EST_PROP_TAX_OPTION
, EOT_EST_PROP_TAX_AMOUNT EOT_EST_PROP_TAX_AMOUNT
, EOT_EST_PROP_TAX_FORMULA EOT_EST_PROP_TAX_FORMULA
, EOT_EST_PROP_TAX_PRORATE EOT_EST_PROP_TAX_PRORATE
, EOT_CONTR_FEES_OPTION EOT_CONTR_FEES_OPTION
, EOT_OUTSTND_BAL_OPTION EOT_OUTSTND_BAL_OPTION
, EOT_SERV_MANT_OPTION EOT_SERV_MANT_OPTION
, LIEN_TYPE LIEN_TYPE
, FILING_NUMBER FILING_NUMBER
, FILING_DATE FILING_DATE
, FILING_STATUS FILING_STATUS
, LIEN_HOLDER_NAME LIEN_HOLDER_NAME
, LIEN_HOLDER_ID LIEN_HOLDER_ID
, JURISDICTION JURISDICTION
, SUB_JURISDICTION 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_NAME TITLE_ISSUER_NAME
, TITLE_ISSUER_ID TITLE_ISSUER_ID
, TITLE_DATE TITLE_DATE
, TITLE_NUMBER TITLE_NUMBER
, REGISTRATION_NUMBER REGISTRATION_NUMBER
, LOCATION LOCATION
, TITLE_CUSTODIAN_NAME TITLE_CUSTODIAN_NAME
, TITLE_CUSTODIAN_ID TITLE_CUSTODIAN_ID
, PAYEE_SITE PAYEE_SITE
, REGISTRATION_LOCATION REGISTRATION_LOCATION
, REG_EXPIRATION_DATE REG_EXPIRATION_DATE
, CREDIT_LINE_ID CREDIT_LINE_ID
, CREDIT_LINE_NUMBER CREDIT_LINE_NUMBER
, PRTFL_APPROVAL_REQ PRTFL_APPROVAL_REQ
, PRTFL_ASSGN_GROUP PRTFL_ASSGN_GROUP
, PRTFL_BUDGET_AMT_OPT PRTFL_BUDGET_AMT_OPT
, PRTFL_BUDGET_FIXED_AMT PRTFL_BUDGET_FIXED_AMT
, PRTFL_BUDGET_AMT_FORMULA PRTFL_BUDGET_AMT_FORMULA
, PRTFL_DAYS_FROM_CON_EXPR PRTFL_DAYS_FROM_CON_EXPR
, PRTFL_STRATEGY PRTFL_STRATEGY
, PROP_TAX_APPLICABLE PROP_TAX_APPLICABLE
, PROP_TAX_LEASE_REP PROP_TAX_LEASE_REP
, MEX_TAX_SUB_BASIC_WTHLD MEX_TAX_SUB_BASIC_WTHLD
, MEX_TAX_CALC_FORMULA MEX_TAX_CALC_FORMULA
, AUS_TAX_STAMP_DUTY AUS_TAX_STAMP_DUTY
, CURRENCY_CONVERSION_TYPE CURRENCY_CONVERSION_TYPE
, CURRENCY_CONVERSION_RATE CURRENCY_CONVERSION_RATE
, CURRENCY_CONVERSION_DATE CURRENCY_CONVERSION_DATE
, ASSIGNABLE_YN ASSIGNABLE_YN
, LESSEE_VENDOR_ID LESSEE_VENDOR_ID
, LESSEE_VENDOR_NAME LESSEE_VENDOR_NAME
, LESSEE_VENDOR_SITE_ID LESSEE_VENDOR_SITE_ID
, LESSEE_VENDOR_SITE_CODE LESSEE_VENDOR_SITE_CODE
, INSURANCE_COMPANY_NUMBER INSURANCE_COMPANY_NUMBER
, INSURANCE_COMPANY_SITE_NUMBER INSURANCE_COMPANY_SITE_NUMBER
, AGENT_NUMBER AGENT_NUMBER
, AGENT_ADDRESS_SITE_NUMBER AGENT_ADDRESS_SITE_NUMBER
, CASH_APPL_RULE_NAME CASH_APPL_RULE_NAME
, PROP_TAX_BILL_METHOD PROP_TAX_BILL_METHOD
, GAIN_LOSS_TOLRNC_ALLWD_AMT GAIN_LOSS_TOLRNC_ALLWD_AMT
, GAIN_LOSS_TOLRNC_ALLWD_FRML GAIN_LOSS_TOLRNC_ALLWD_FRML
, GAIN_LOSS_TOLRNC_BASIS GAIN_LOSS_TOLRNC_BASIS
, GAIN_LOSS_APPRV_PROC_FRML GAIN_LOSS_APPRV_PROC_FRML
, ERT_ABSORBED_FEE_FRML ERT_ABSORBED_FEE_FRML
, ERT_EXPENSE_FEE_FRML ERT_EXPENSE_FEE_FRML
, ERT_FINANCED_FEE_FRML ERT_FINANCED_FEE_FRML
, ERT_GENERAL_FEE_FRML ERT_GENERAL_FEE_FRML
, ERT_INCOME_FEE_FRML ERT_INCOME_FEE_FRML
, ERT_MISC_FEE_FRML ERT_MISC_FEE_FRML
, ERT_PASSTHRU_FEE_FRML ERT_PASSTHRU_FEE_FRML
, ERT_ROLLOVER_FEE_FRML ERT_ROLLOVER_FEE_FRML
, EOT_ABSORBED_FEE_FRML EOT_ABSORBED_FEE_FRML
, EOT_EXPENSE_FEE_FRML EOT_EXPENSE_FEE_FRML
, EOT_FINANCED_FEE_FRML EOT_FINANCED_FEE_FRML
, EOT_GENERAL_FEE_FRML EOT_GENERAL_FEE_FRML
, EOT_INCOME_FEE_FRML EOT_INCOME_FEE_FRML
, EOT_MISC_FEE_FRML EOT_MISC_FEE_FRML
, EOT_PASSTHRU_FEE_FRML EOT_PASSTHRU_FEE_FRML
, EOT_ROLLOVER_FEE_FRML EOT_ROLLOVER_FEE_FRML
, LATE_INTEREST_PRODUCT_CODE LATE_INTEREST_PRODUCT_CODE
, SCHEDULED_WORKER_ID SCHEDULED_WORKER_ID
, DELETE_BEFORE_IMPORT_YN DELETE_BEFORE_IMPORT_YN
, ST_UPDATE_LINES_FROM_CONTRACT ST_UPDATE_LINES_FROM_CONTRACT
, ST_INTEREST_DISCLOSED ST_INTEREST_DISCLOSED
, 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
, ST_ASSET_UPFRONT_TAX ST_ASSET_UPFRONT_TAX
, ST_BILL_STREAM_TYPE_CODE ST_BILL_STREAM_TYPE_CODE
, ST_BILL_STREAM_PURPOSE_CODE ST_BILL_STREAM_PURPOSE_CODE
, ST_FIN_STREAM_TYPE_CODE ST_FIN_STREAM_TYPE_CODE
, ST_FIN_STREAM_PURPOSE_CODE ST_FIN_STREAM_PURPOSE_CODE
, ST_CAP_STREAM_TYPE_CODE ST_CAP_STREAM_TYPE_CODE
, ST_CAP_STREAM_PURPOSE_CODE ST_CAP_STREAM_PURPOSE_CODE
, INT_RATE_EFFECTIVE_FROM_DATE INT_RATE_EFFECTIVE_FROM_DATE
, INT_RATE_EFFECTIVE_TO_DATE INT_RATE_EFFECTIVE_TO_DATE
, INT_RATE_PRINC_BASIS_CODE INT_RATE_PRINC_BASIS_CODE
, INT_RATE_BASIS_CODE INT_RATE_BASIS_CODE
, INT_RATE_DELAY_CODE INT_RATE_DELAY_CODE
, INT_RATE_DELAY_FREQ INT_RATE_DELAY_FREQ
, INT_RATE_CMPND_FREQ_CODE INT_RATE_CMPND_FREQ_CODE
, INT_RATE_CATCHUP_BASIS_CODE INT_RATE_CATCHUP_BASIS_CODE
, INT_RATE_CATCHUP_START_DATE INT_RATE_CATCHUP_START_DATE
, INT_RATE_CAT_STLMNT_CODE INT_RATE_CAT_STLMNT_CODE
, INT_RATE_CHANGE_START_DATE INT_RATE_CHANGE_START_DATE
, INT_RATE_CHANGE_FREQ_CODE INT_RATE_CHANGE_FREQ_CODE
, INT_RATE_CHANGE_VALUE INT_RATE_CHANGE_VALUE
, INT_RATE_CON_OPTION_CODE INT_RATE_CON_OPTION_CODE
, INT_RATE_NEXT_CON_DATE INT_RATE_NEXT_CON_DATE
, INT_RATE_CON_INDEX_NAME INT_RATE_CON_INDEX_NAME
, INT_RATE_CON_BASE_RATE INT_RATE_CON_BASE_RATE
, INT_RATE_CON_START_DATE INT_RATE_CON_START_DATE
, INT_RATE_CON_ADDER_RATE INT_RATE_CON_ADDER_RATE
, INT_RATE_CON_MAXIMUM_RATE INT_RATE_CON_MAXIMUM_RATE
, INT_RATE_CON_MINIMUM_RATE INT_RATE_CON_MINIMUM_RATE
, INT_RATE_CON_PRC_BAS_CODE INT_RATE_CON_PRC_BAS_CODE
, INT_RATE_CON_DAY_MTH_CODE INT_RATE_CON_DAY_MTH_CODE
, INT_RATE_CON_DAY_YER_CODE INT_RATE_CON_DAY_YER_CODE
, INT_RATE_CON_INT_BAS_CODE INT_RATE_CON_INT_BAS_CODE
, INT_RATE_CON_RATE_DELAY_CODE INT_RATE_CON_RATE_DELAY_CODE
, INT_RATE_CON_RATE_DELAY_FREQ INT_RATE_CON_RATE_DELAY_FREQ
, INT_RATE_CON_CMPND_FREQ_CODE INT_RATE_CON_CMPND_FREQ_CODE
, INT_RATE_CON_FORMULA_NAME INT_RATE_CON_FORMULA_NAME
, INT_RATE_CON_CAT_BAS_CODE INT_RATE_CON_CAT_BAS_CODE
, INT_RATE_CON_CAT_START_DATE INT_RATE_CON_CAT_START_DATE
, INT_RATE_CON_CAT_STLMNT_CODE INT_RATE_CON_CAT_STLMNT_CODE
, INT_RATE_CON_CHG_START_DATE INT_RATE_CON_CHG_START_DATE
, INT_RATE_CON_CHG_FREQ_CODE INT_RATE_CON_CHG_FREQ_CODE
, INT_RATE_CON_CHG_VALUE INT_RATE_CON_CHG_VALUE
, INT_RATE_CAT_FREQ_CODE INT_RATE_CAT_FREQ_CODE
, INT_RATE_CON_CAT_FREQ_CODE INT_RATE_CON_CAT_FREQ_CODE
, RVI_STREAM_CODE RVI_STREAM_CODE
, RVI_STREAM_PURPOSE_CODE RVI_STREAM_PURPOSE_CODE
, 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
, EOT_AUTO_PROC_PURCHASE_OPT EOT_AUTO_PROC_PURCHASE_OPT
, 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
, SEND_BILL_SALE SEND_BILL_SALE
, MANUAL_QUOTES_ONLY MANUAL_QUOTES_ONLY
, FIRST_TERMINATION_DATE FIRST_TERMINATION_DATE
, QUOTE_RCPT_ADDL_RCPT_ROLE QUOTE_RCPT_ADDL_RCPT_ROLE
, QUOTE_RCPT_ALLOC_PTG QUOTE_RCPT_ALLOC_PTG
, QUOTE_APPRVR_ADV_NOTICE_ROLE QUOTE_APPRVR_ADV_NOTICE_ROLE
, QUOTE_APPROVER_DELAY_DAYS QUOTE_APPROVER_DELAY_DAYS
, ERT_SERV_MANT_FRML ERT_SERV_MANT_FRML
, EOT_SERV_MANT_FRML EOT_SERV_MANT_FRML
, LEGAL_ENTITY_ID LEGAL_ENTITY_ID
, ST_TAX_SCHEDULE_APPLIES_FLAG ST_TAX_SCHEDULE_APPLIES_FLAG
, PRINT_LEAD_DAYS PRINT_LEAD_DAYS
FROM "OKL"."OKL_HEADER_INTERFACE"