[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#;
|
|
|