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