[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | OKL_HEADER_INTERFACE |
|---|---|
| Object Type: | TABLE |
| Owner: | OKL |
| FND Design Data: |  OKL.OKL_HEADER_INTERFACE
|
| Subobject Name: | |
| Status: | VALID |
OKL_HEADER_INTERFACE table stores information used to create Lease contract during Lease contract open interface import.
There is one row for each contract you import. You can import a contract to Lease management with the same number as it is in legacy system or import process gives a unique number to each contract during import process.
Import process is able to get contract header information from a specified template contract in case that particular information is not available at OKL_HEADER_INTERFACE table. e.g. if you do not specify billing address of customer at OKL_HEADER_INTERFACE table and have specified a template contract number at TEMPLATE_CONTRACT column, import process creates a contract in OKL with billing address information of specifed template contract.
Scope: public
Product: OKL
Display Name: OKL Contract Open Interface
Category: BUSINESS_ENTITY OKL_CONTRACT
Lifecycle: active
| Tablespace: |  APPS_TS_INTERFACE |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| OKL_HEADER_INTERFACE_N1 | NORMAL | NONUNIQUE |
APPS_TS_INTERFACE
|
 CONTRACT_NUMBER_OLD
|
| OKL_HEADER_INTERFACE_N2 | NORMAL | NONUNIQUE |
APPS_TS_INTERFACE
|
CONTRACT_NUMBER
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| BATCH_NUMBER | VARCHAR2 | (30) | Contract import batch number. This column is used to group contract(s) to be imported at a single import run. | |
| STATUS | VARCHAR2 | (30) | Yes | Status |
| CREATED_BY | NUMBER | Yes | Standard who column | |
| DATE_CREATED | DATE | Yes | Standard Who column | |
| DATE_CREATED_IN_OKL | DATE | Date contract imported to Lease Management. | ||
| APPLICATION_CODE | VARCHAR2 | (30) | Yes | Contract application code. Valid value is 'OKL'. |
| CONTRACT_CATEGORY | VARCHAR2 | (30) | Yes | Contract category. Valid value is 'LEASE'. |
| CONTRACT_NUMBER_OLD | VARCHAR2 | (30) | Yes | Legacy contract number. This is an unique identifier and is used to link records with other interface tables for Lease contract open interface. |
| CONTRACT_SOURCE | VARCHAR2 | (30) | Source of imported contract. Only one source ('OKL_IMPORT") is allowed now. | |
| CONTRACT_NUMBER | VARCHAR2 | (120) | Contract number | |
| CUSTOMER_NUMBER | VARCHAR2 | (30) | Contract customer number. Validated against OKX_PARTIES_V.PARTY_NUMBER and is used to create party role 'LESSEE'. | |
| CUSTOMER_ID | NUMBER | Contract customer IDr. Validated against OKX_PARTIES_V.ID1 and is used to create party role 'LESSEE'. | ||
| CUSTOMER_ACCOUNT_NUMBER | VARCHAR2 | (30) | Contract customer account number. Validated against OKX_CUSTOMER_ACCOUNTS_V.DESCRIPTION. | |
| CUSTOMER_ACCOUNT_ID | NUMBER | Contract customer account ID. Validated against OKX_CUSTOMER_ACCOUNTS_V.ID. | ||
| START_DATE | DATE | Start date | ||
| IMPORT_REQUEST_STAGE | VARCHAR2 | (30) | Stage upto which contract is imported. Valid values are:'NEW' : Import contract only.'PASSED': Import contract and validate (QA Checker).'COMPLETE': Import, validate, generate streams and draft Journal entries.'BOOKED': Import, validate, generate streams, draft & final Journal entries and activate the contract. | |
| CURRENCY_CODE | VARCHAR2 | (3) | Currency code | |
| CUSTOMER_PO_NUMBER | VARCHAR2 | (150) | Customer PO number. | |
| DATE_SIGNED | DATE | Date contract singed | ||
| DATE_APPROVED | DATE | Date contract approved. | ||
| ACCEPTANCE_METHOD_CODE | VARCHAR2 | (30) | Acceptance method code. | |
| CONSUMER_CREDIT_ACT_DEAL_FLAG | VARCHAR2 | (1) | Consumer credit account deal flag. Valid values are 'Y' or 'N'. | |
| TERM | NUMBER | Term of contract in months. | ||
| CONVERTED_ACCOUNT | VARCHAR2 | (1) | Converted account flag. Valid values are 'Y' or 'N'. | |
| ACCEPTED_DATE | DATE | Customer acceptance date. | ||
| DEAL_TYPE_CODE | VARCHAR2 | (30) | Contract deal type. | |
| EXPECTED_DELIVERY_DATE | DATE | Expected delivery date. | ||
| CONTRACT_DESCRIPTION | VARCHAR2 | (600) | Contract description. | |
| SALESPERSON_NAME | VARCHAR2 | (240) | Name of salesperson. Validated against OKX_SALESREPS_V.NAME and is used to create contact. | |
| SALESPERSON_ID | NUMBER | ID of salesperson. Validated against OKX_SALESREPS_V.ID1 and is used to create contact. | ||
| PRIVATE_LABEL_NUMBER | VARCHAR2 | (30) | Private label party number. Validated against OKX_PARTIES_V.PARTY_NUMBER. | |
| PRIVATE_LABEL_ID | NUMBER | Private label party ID.. Validated against OKX_PARTIES_V.PARTY_ID1. | ||
| PRIVATE_LABEL_URL | VARCHAR2 | (250) | Web address of private lable party. | |
| PROGRAM_AGREEMENT_NUMBER | VARCHAR2 | (120) | Vendor program agreement number. Validated against OKC_K_HEADERS_V.CONTRACT_NUMBER with scs code as 'PROGRAM'. | |
| PROGRAM_AGREEMENT_ID | NUMBER | Vendor program agreement ID. Validated against OKC_K_HEADERS_V.ID with scs code as 'PROGRAM'. | ||
| PROGRAM_VENDOR_NAME | VARCHAR2 | (240) | Vendor name for program. | |
| PROGRAM_VENDOR_ID | NUMBER | Vendor ID for program. | ||
| MASTER_LEASE_AGREEMENT_NUMBER | VARCHAR2 | (120) | Master lease agreement number. Validated against OKC_K_HEADERS_V.CONTRACT_NUMBER with scs code as 'MASTER_LEASE'. | |
| MASTER_LEASE_AGREEMENT_ID | NUMBER | Master lease agreement ID. Validated against OKC_K_HEADERS_V.ID with scs code as 'MASTER_LEASE'. | ||
| PRODUCT_NAME | VARCHAR2 | (150) | Financial product name. Validated against OKL_PRODUCTS_V.NAME. | |
| PRODUCT_ID | NUMBER | Financial product id. Validated against OKL_PRODUCTS_V.ID. | ||
| CALCULATE_RESIDUAL_INSURANCE | VARCHAR2 | (1) | Calculate residual insurance flag. | |
| REBOOK_LIMIT_DATE | DATE | Contrac rebook limit date. Rebooking of contract is allowed only after this date. | ||
| IMPORT_REQUEST_ID | NUMBER | Not in use. | ||
| END_OF_TERM_OPTION | VARCHAR2 | (30) | Code for end of term option. | |
| END_OF_TERM_AMOUNT | NUMBER | Amount associated with end of term option. | ||
| MID_TERM_OPTION | VARCHAR2 | (30) | Code for mid term option. | |
| MID_TERM_AMOUNT | NUMBER | Amount associated with mid term option. | ||
| SECURITY_DEPOSIT_HOLD_FLAG | VARCHAR2 | (1) | Ssecurity deposit hold until contract expiration flag. Valid value is 'Y' or 'N'. | |
| SECURITY_DEPOSIT_NET_FLAG | VARCHAR2 | (1) | Net security deposit from contract sales proceeds flag. Valid value is 'Y' or 'N'. | |
| SECURITY_DEPOSIT_DATE | DATE | Security deposit hold until date. | ||
| RENEWAL_NOTICE_DAYS | NUMBER | Days in advance to notify of auto renewal. | ||
| RENEWAL_OPTION | VARCHAR2 | (30) | Code for renewal option. | |
| RENEWAL_AMOUNT | NUMBER | Amount associated with renewal option. | ||
| LATE_INTEREST_HELD_UNTIL_DATE | DATE | Date to which late interest charges are not billed. | ||
| LATE_INTEREST_EXEMPT_FLAG | VARCHAR2 | (1) | Contract is exempt from late interest. Valid value is 'Y' or 'N'. | |
| LATE_CHARGE_HELD_UNTIL_DATE | DATE | Date to which late charges are not billed. | ||
| LATE_CHARGE_PRODUCT_CODE | VARCHAR2 | (1995) | Late charge product. | |
| LATE_CHARGE_EXEMPT_FLAG | VARCHAR2 | (1) | Contract is exempt from late charges. Valid value is 'Y' or 'N'. | |
| VARIABLE_RATE | VARCHAR2 | (1) | Variable Rate Flag. Valid value is 'Y' or 'N'. | |
| CONVERT_TYPE | VARCHAR2 | (30) | Convert type. | |
| CONVERSION_METHOD | VARCHAR2 | (30) | Convesion method code. | |
| DATE_OF_CONVERSION | DATE | Date of conversion. | ||
| CONVERT_BY_DATE | DATE | convert by date. | ||
| VARIABLE_METHOD | VARCHAR2 | (30) | Variable method. | |
| INDEX_NAME | VARCHAR2 | (150) | Index name. Validated against OKL_INDICIES_V.NAME. | |
| BASE_RATE | NUMBER | Base rate. | ||
| ADDER | NUMBER | Adder. | ||
| MINIMUM_RATE | NUMBER | Minimum rate. | ||
| MAXIMUM_RATE | NUMBER | Maximum rate. | ||
| TOLERANCE | NUMBER | Tollerance. | ||
| ADJUSTMENT_FREQUENCY | VARCHAR2 | (80) | Adjustment frequency. | |
| DAYS_IN_YEAR | VARCHAR2 | (30) | Days in year | |
| DAYS_IN_MONTH | VARCHAR2 | (30) | Days in month. | |
| INTEREST_METHOD | VARCHAR2 | (30) | Interest method. | |
| INTEREST_START_DATE | DATE | Interest start date. | ||
| METHOD_OF_CALCULATION | VARCHAR2 | (80) | Method of calculation. | |
| FORMULA_NAME | VARCHAR2 | (999) | Calculation formula name. | |
| CAPITALIZE_FLAG | VARCHAR2 | (1) | Capitalize flag. Valid value is 'Y' or 'N'. | |
| NON_NOTIFICATION_FLAG | VARCHAR2 | (1) | Non notification flag. Valid value is 'Y' or 'N'. | |
| TAX_WITHHOLDING_FLAG | VARCHAR2 | (1) | Tax withholding flag. Valid value is 'Y' or 'N'. | |
| TAX_CALC_FORMULA_NAME | VARCHAR2 | (999) | Tax calculation formula name. | |
| TAX_OWNER | VARCHAR2 | (80) | Tax owner name. | |
| FACTORING_DATE | DATE | Factoring date. | ||
| FACTORING_PERCENTAGE | NUMBER | Factoring percentage. | ||
| FACTORING_DISCOUNT_RATE | NUMBER | Factoring discount rate. | ||
| EVERGREEN_ELIGIBLE_FLAG | VARCHAR2 | (1) | Contract eligible for auto-renewal. | |
| BILL_TO_ADDRESS_ID | NUMBER | Customer billing address ID. Validated against OKX_CUST_SITE_USES_V.ID1 with site use code as 'BILL_TO'. | ||
| BILL_TO_ADDRESS | VARCHAR2 | (240) | Customer billing address. Validated against OKX_CUST_SITE_USES_V.NAME with site use code as 'BILL_TO'. | |
| BANK_ACCOUNT_ID | NUMBER | Customer bank account ID. Validated against OKX_RCPT_METHOD_ACCOUNTS_V.ID1. | ||
| BANK_ACCOUNT_NUMBER | VARCHAR2 | (30) | Customer bank account number. Validated against OKX_RCPT_METHOD_ACCOUNTS_V.BANK_ACCOUNT_NUM. | |
| REASON_FOR_INVOICE_REVIEW | VARCHAR2 | (50) | Reason for invoice review. | |
| INVOICE_REVIEW_UNTIL_DATE | DATE | Invoice review until date. | ||
| INVOICE_FORMAT_ID | NUMBER | Invoice format ID. Validated against OKL_INVOICE_FORMATS_V.ID1. | ||
| INVOICE_FORMAT_CODE | VARCHAR2 | (150) | Invoice format ID. Validated against OKL_INVOICE_FORMATS_V.NAME. | |
| REVIEW_INVOICE_FLAG | VARCHAR2 | (1) | Review invoice flag. Valid value is 'Y' or 'N'. | |
| PAYMENT_METHOD_ID | NUMBER | Customer payment method ID. Validated against OKX_RECEIPT_METHODS_V.ID1. | ||
| PAYMENT_METHOD | VARCHAR2 | (30) | Customer payment method. Validated against OKX_RECEIPT_METHODS_V.NAME. | |
| AUTHORING_ORG_ID | NUMBER | Organization ID for authoring unit | ||
| INVENTORY_ORGANIZATION_ID | NUMBER | Inventory organization ID (for access to inventory items). | ||
| POLICY_NUMBER | VARCHAR2 | (20) | 3rd party insurance policy number | |
| POLICY_EFFECTIVE_FROM | DATE | 3rd party insurance policy effective date | ||
| POLICY_EFFECTIVE_TO | DATE | 3rd party insurance policy expiry date | ||
| COVERED_AMOUNT | NUMBER | Coverage amount of 3rd party insurance policy | ||
| DEDUCTIBLE_AMOUNT | NUMBER | Deductible amount of 3rd party insurance policy | ||
| ENDORSEMENT | VARCHAR2 | (512) | Is there an endorsement on the 3rd party insurance policy. | |
| NAME_OF_INSURED | VARCHAR2 | (256) | Name of insured party on 3rd party insurance policy (if not lessor). | |
| LESSOR_INSURED_FLAG | VARCHAR2 | (1) | Lessor insured flag. Valid value is 'Y' or 'N'. | |
| LESSOR_PAYEE_FLAG | VARCHAR2 | (1) | Lessor payee flag. Valid value is 'Y' or 'N'. | |
| INSURANCE_COMPANY_NAME | VARCHAR2 | (360) | Company name of insurer. | |
| INSURANCE_COMPANY_ID | NUMBER | ID of insurer. | ||
| INSURANCE_COMPANY_SITE_NAME | VARCHAR2 | (150) | Pay to site name of insurer. | |
| INSURANCE_COMPANY_SITE_ID | NUMBER | Pay to site ID of insurer. | ||
| AGENT_NAME | VARCHAR2 | (360) | Agent name for insurance policy. | |
| AGENT_ID | NUMBER | Agent ID for insurance policy. | ||
| AGENT_ADDRESS_SITE_NAME | VARCHAR2 | (150) | Agent address name for insurance policy. | |
| AGENT_ADDRESS_SITE_ID | NUMBER | Agent address ID for insurance policy. | ||
| PROOF_DUE_DATE | DATE | Date proof of insurance is due. | ||
| PROOF_PROVIDED_DATE | DATE | Date proof of insurance was provided. | ||
| PREFUNDING_ELIGIBLE_FLAG | VARCHAR2 | (1) | Prefunding eligible flag. | |
| PRIVATE_ACTIVITY_BOND_FLAG | VARCHAR2 | (1) | Private activity bond flag. | |
| RVI_AUTO_CALCULATE_FLAG | VARCHAR2 | (1) | RVI auto calculate flag. | |
| RVI_GUARANTEED_AMOUNT | NUMBER | RVI guaranteed amount. | ||
| RVI_PRESENT_GUARANTEED_AMOUNT | NUMBER | RVI present guaranteed amount. | ||
| RVI_PREMIUM_AMOUNT | NUMBER | RVI premimum amount. | ||
| RVI_RATE | NUMBER | RVI rate. | ||
| TEMPLATE_NUMBER | VARCHAR2 | (120) | Contract template number. Validated aganist OKC_K_HEADERS_V.contract_number with template flag as 'Y'. This is used to get header information in case that is not specified at OKL_HEADER_INTERFACE column(s). | |
| EVERGREEN_PASSTHRU_FEES | NUMBER | Evergreen passthrough fee amount. | ||
| EVERGREEN_PASSTHRU_PERCENT | NUMBER | Evergreen passthorugh percent. | ||
| FLOOR_PRICE_FORMULA | VARCHAR2 | (150) | Floor price formula name. | |
| REMKT_SALE_PRICE_FORMULA | VARCHAR2 | (150) | Remarket sale price formula name. | |
| REPURCHASE_QUOTE_OPTION | VARCHAR2 | (3) | Repurchase quote option name. | |
| REPURCHASE_QUOTE_FORMULA | VARCHAR2 | (150) | Repurchase quote formula name. | |
| SALE_PRICE_OPTION | VARCHAR2 | (30) | Repurchase quote option - sale price option. | |
| SALE_PRICE_AMOUNT | NUMBER | Repurchase quote option - sale price amount. | ||
| SALE_PRICE_FORMULA | VARCHAR2 | (150) | Repurchase quote option - sale price formula name. | |
| SALE_PRICE_PRORATE | VARCHAR2 | (30) | Repurchase quote option - sale price formula prorate. | |
| DISCOUNT_RATE_OPTION | VARCHAR2 | (30) | Repurchase quote option - discount rate option. | |
| DISCOUNT_RATE_AMOUNT | NUMBER | Repurchase quote option - discount rate amount. | ||
| DISCOUNT_RATE_FORMULA | VARCHAR2 | (150) | Repurchase quote option - discount rate formula name. | |
| DISCOUNT_RATE_PRORATE | VARCHAR2 | (30) | Repurchase quote option - discount rate prorate. | |
| QUOTE_FEE_OPTION | VARCHAR2 | (30) | Repurchase quote fee option. | |
| QUOTE_FEE_AMOUNT | NUMBER | Repurchase quote fee amount. | ||
| QUOTE_FEE_FORMULA | VARCHAR2 | (150) | Repurchase quote fee formula name. | |
| QUOTE_FEE_PRORATE | VARCHAR2 | (30) | Repurchase quote fee prorate. | |
| ERT_PURCHASE_OPT | VARCHAR2 | (30) | Early termination purchase option name. | |
| ERT_PURCHASE_OPT_TYPE | VARCHAR2 | (30) | Early termination purchase option type. | |
| ERT_PURCHASE_OPT_AMOUNT | NUMBER | Early termination purchase option amount. | ||
| ERT_PURCHASE_OPT_FORMULA | VARCHAR2 | (150) | Early termination purchase option formula name. | |
| ERT_PURCHASE_OPT_PRORATE | VARCHAR2 | (30) | Early termination purchase option prorate. | |
| ERT_PURCHASE_OPT_MAX_OPT | VARCHAR2 | (30) | Early termination purchase option maximum option. | |
| ERT_PURCHASE_OPT_MAX_AMT | NUMBER | Early termination purchase option maximum amount. | ||
| ERT_PURCHASE_OPT_MAX_FORMULA | VARCHAR2 | (150) | Early termination purchase option maximum formula name. | |
| ERT_PURCHASE_OPT_MIN_OPT | VARCHAR2 | (30) | Early termination purchase option minimum option. | |
| ERT_PURCHASE_OPT_MIN_AMT | NUMBER | Early termination purchase option minimum amount. | ||
| ERT_PURCHASE_OPT_MIN_FORMULA | VARCHAR2 | (150) | Early termination purchase option minimum formula name. | |
| EOT_PURCHASE_OPT | VARCHAR2 | (30) | End of term purchase option name. | |
| EOT_PURCHASE_OPT_TYPE | VARCHAR2 | (30) | End of term purchase option type. | |
| EOT_PURCHASE_OPT_AMOUNT | NUMBER | End of term purchase option amount. | ||
| EOT_PURCHASE_OPT_FORMULA | VARCHAR2 | (150) | End of term purchase option formula. | |
| EOT_PURCHASE_OPT_PRORATE | VARCHAR2 | (30) | End of term purchase option prorate. | |
| EOT_PURCHASE_OPT_MAX_OPT | VARCHAR2 | (30) | End of term purchase option maximum option. | |
| EOT_PURCHASE_OPT_MAX_AMT | NUMBER | End of term purchase option maximum amount. | ||
| EOT_PURCHASE_OPT_MAX_FORMULA | VARCHAR2 | (150) | End of term purchase option maximum formula name. | |
| EOT_PURCHASE_OPT_MIN_OPT | VARCHAR2 | (30) | End of term purchase option minimum option. | |
| EOT_PURCHASE_OPT_MIN_AMT | NUMBER | End of term purchase option minimum amount. | ||
| EOT_PURCHASE_OPT_MIN_FORMULA | VARCHAR2 | (150) | End of term purchase option minimum formula name. | |
| TQP_ERL_TERMINATION_ALWD_FLAG | VARCHAR2 | (3) | Termination of quote process - early termination allowed flag. | |
| TQP_PRT_TERMINATION_ALWD_FLAG | VARCHAR2 | (3) | Termination of quote process -partial termination allowed flag. | |
| QUOTE_EFFECTIVE_DAYS | NUMBER | Termination of quote process - quote effective days. | ||
| QUOTE_EFF_MAX_DAYS | NUMBER | Termination of quote process - quote effective maximum days. | ||
| EOT_TOLERANCE_DAYS | NUMBER | Termination of quote process - end of term tolerance days. | ||
| PRT_TERMINATION_APPROVAL_REQ | VARCHAR2 | (3) | Termination of quote process - partial termination approval required flag.. | |
| PRT_TERMINATION_ALLOWED_FLAG | VARCHAR2 | (3) | Termination of quote process -partial termination allowed flag. | |
| GAIN_LOSS_APPROVAL_REQ | VARCHAR2 | (3) | Gain or loss approval required. | |
| GAIN_LOSS_NET_QUOTE_OPT | VARCHAR2 | (30) | Gain or loss net quote option. | |
| GAIN_LOSS_NET_QUOTE_AMT | NUMBER | Gain or loss net quote amount. | ||
| GAIN_LOSS_NET_QUOTE_FORMULA | VARCHAR2 | (150) | Gain or loss net quote formula name. | |
| GAIN_LOSS_TOLERANCE_ALLOWED | VARCHAR2 | (150) | Gain or loss net quote tolerance allowed flag. | |
| QUOTE_RCPT_CONTRACT_ROLE | VARCHAR2 | (30) | Quote recipientt main recipient role name. | |
| QUOTE_APPROVER_CONTRACT_ROLE | VARCHAR2 | (30) | Quote approver role name. | |
| QUOTE_CRTSY_COPY_CONTRACT_ROLE | VARCHAR2 | (30) | Quote courtesy copy role name. | |
| ERT_QUOTE_CALC_TERM_OPTION | VARCHAR2 | (3) | Early termination quote formula option. | |
| ERT_QUOTE_CALC_TERM_FORMULA | VARCHAR2 | (150) | Early termination quote formula name. | |
| ERT_CONTRACT_OBLIG_OPT | VARCHAR2 | (30) | Early termination contract obligation option. | |
| ERT_CONTRACT_OBLIG_AMOUNT | NUMBER | Early termination contract obligation amount. | ||
| ERT_CONTRACT_OBLIG_FORMULA | VARCHAR2 | (150) | Early termination contract obligation formula name. | |
| ERT_CONTRACT_OBLIG_PRORATE | VARCHAR2 | (30) | Early termination contract obligation prorate. | |
| ERT_DISC_RATE_OPT | VARCHAR2 | (30) | Early termination discount rate option. | |
| ERT_DISC_RATE_AMOUNT | NUMBER | Early termination discount rate amount. | ||
| ERT_DISC_RATE_FORMULA | VARCHAR2 | (150) | Early termination discount rate formula name. | |
| ERT_DISC_RATE_PRORATE | VARCHAR2 | (30) | Early termination discount rate prorate. | |
| ERT_QUOTE_FEE_OPT | VARCHAR2 | (30) | Early termination quote fee option. | |
| ERT_QUOTE_FEE_AMOUNT | NUMBER | Early termination quote fee amount. | ||
| ERT_QUOTE_FEE_FORMULA | VARCHAR2 | (150) | Early termination quote fee formula. | |
| ERT_QUOTE_FEE_PRORATE | VARCHAR2 | (30) | Early termination quote fee prorate. | |
| ERT_RETURN_FEE_OPTION | VARCHAR2 | (30) | Early termination return fee option. | |
| ERT_RETURN_FEE_AMOUNT | NUMBER | Early termination return fee amount. | ||
| ERT_RETURN_FEE_FORMULA | VARCHAR2 | (150) | Early termination return fee formula name. | |
| ERT_RETURN_FEE_PRORATE | VARCHAR2 | (30) | Early termination return fee prorate. | |
| ERT_ROLL_INCTV_OPTION | VARCHAR2 | (30) | Early termination rollover incentive option. | |
| ERT_ROLL_INCTV_AMOUNT | NUMBER | Early termination rollover incentive amount. | ||
| ERT_ROLL_INCTV_FORMULA | VARCHAR2 | (150) | Early termination rollover incentive formula name. | |
| ERT_ROLL_INCTV_PRORATE | VARCHAR2 | (30) | Early termination rollover incentive prorate. | |
| ERT_SECU_DEP_DISPO_OPTION | VARCHAR2 | (30) | Early termination security deposite disposition option. | |
| ERT_SECU_DEP_DISPO_AMOUNT | NUMBER | Early termination security deposite disposition amount. | ||
| ERT_SECU_DEP_DISPO_FORMULA | VARCHAR2 | (150) | Early termination security deposite disposition formula name. | |
| ERT_SECU_DEP_DISPO_PRORATE | VARCHAR2 | (30) | Early termination security deposite disposition prorate. | |
| ERT_TERM_PENALTY_OPTION | VARCHAR2 | (30) | Early termination penalty option. | |
| ERT_TERM_PENALTY_AMOUNT | NUMBER | Early termination penalty amount. | ||
| ERT_TERM_PENALTY_FORMULA | VARCHAR2 | (150) | Early termination penalty formula name. | |
| ERT_TERM_PENALTY_PRORATE | VARCHAR2 | (30) | Early termination penalty prorate. | |
| ERT_TERM_PENALTY_CAP_OPTION | VARCHAR2 | (30) | Early termination penalty CAP option. | |
| ERT_TERM_PENALTY_CAP_AMOUNT | NUMBER | Early termination penalty CAP amount. | ||
| ERT_TERM_PENALTY_CAP_FORMULA | VARCHAR2 | (150) | Early termination penalty CAP formula name. | |
| ERT_EST_PROP_TAX_OPTION | VARCHAR2 | (30) | Early termination estimated property tax option. | |
| ERT_EST_PROP_TAX_AMOUNT | NUMBER | Early termination estimated property tax amount. | ||
| ERT_EST_PROP_TAX_FORMULA | VARCHAR2 | (150) | Early termination estimated property tax formula name. | |
| ERT_EST_PROP_TAX_PRORATE | VARCHAR2 | (30) | Early termination estimated property tax prorate. | |
| ERT_CONTR_FEES_OPTION | VARCHAR2 | (3) | Early termination contractual fees option flag. | |
| ERT_OUTSTND_BAL_OPTION | VARCHAR2 | (3) | Early termination outstanding balance option flag. | |
| ERT_SERV_MANT_OPTION | VARCHAR2 | (3) | Early termination service and maintenance option flag. | |
| EOT_QUOTE_CALC_TERM_OPTION | VARCHAR2 | (3) | End of term quote calculation termination option. | |
| EOT_QUOTE_CALC_TERM_FORMULA | VARCHAR2 | (150) | End of term quote calculation termination formula name. | |
| EOT_CONTRACT_OBLIG_OPT | VARCHAR2 | (30) | End of term contract obligation option. | |
| EOT_CONTRACT_OBLIG_AMOUNT | NUMBER | End of term contract obligation amount. | ||
| EOT_CONTRACT_OBLIG_FORMULA | VARCHAR2 | (150) | End of term contract obligation formula name. | |
| EOT_CONTRACT_OBLIG_PRORATE | VARCHAR2 | (30) | End of term contract obligation prorate. | |
| EOT_DISC_RATE_OPT | VARCHAR2 | (30) | End of term contract discount rate option. | |
| EOT_DISC_RATE_AMOUNT | NUMBER | End of term contract discount rate amount. | ||
| EOT_DISC_RATE_FORMULA | VARCHAR2 | (150) | End of term contract discount rate formula name. | |
| EOT_DISC_RATE_PRORATE | VARCHAR2 | (30) | End of term contract discount rate prorate. | |
| EOT_QUOTE_FEE_OPT | VARCHAR2 | (30) | End of term quote fee option. | |
| EOT_QUOTE_FEE_AMOUNT | NUMBER | End of term quote fee amount. | ||
| EOT_QUOTE_FEE_FORMULA | VARCHAR2 | (150) | End of term quote fee formula name. | |
| EOT_QUOTE_FEE_PRORATE | VARCHAR2 | (30) | End of term quote fee prorate. | |
| EOT_RETURN_FEE_OPTION | VARCHAR2 | (30) | End of term return fee option. | |
| EOT_RETURN_FEE_AMOUNT | NUMBER | End of term return fee amount. | ||
| EOT_RETURN_FEE_FORMULA | VARCHAR2 | (150) | End of term return fee formula name. | |
| EOT_RETURN_FEE_PRORATE | VARCHAR2 | (30) | End of term return fee prorate. | |
| EOT_ROLL_INCTV_OPTION | VARCHAR2 | (30) | End of term rollover incentive option. | |
| EOT_ROLL_INCTV_AMOUNT | NUMBER | End of term rollover incentive amount. | ||
| EOT_ROLL_INCTV_FORMULA | VARCHAR2 | (150) | End of term rollover incentive formula name. | |
| EOT_ROLL_INCTV_PRORATE | VARCHAR2 | (30) | End of term rollover incentive prorate. | |
| EOT_SECU_DEP_DISPO_OPTION | VARCHAR2 | (30) | End of term security deposite disposition option. | |
| EOT_SECU_DEP_DISPO_AMOUNT | NUMBER | End of term security deposite disposition amount. | ||
| EOT_SECU_DEP_DISPO_FORMULA | VARCHAR2 | (150) | End of term security deposite disposition formula name. | |
| EOT_SECU_DEP_DISPO_PRORATE | VARCHAR2 | (30) | End of term security deposite disposition prorate. | |
| EOT_TERM_PENALTY_OPTION | VARCHAR2 | (30) | End of term termination penalty option. | |
| EOT_TERM_PENALTY_AMOUNT | NUMBER | End of term termination penalty amount. | ||
| EOT_TERM_PENALTY_FORMULA | VARCHAR2 | (150) | End of term termination penalty formula name. | |
| EOT_TERM_PENALTY_PRORATE | VARCHAR2 | (30) | End of term termination penalty prorate. | |
| EOT_TERM_PENALTY_CAP_OPTION | VARCHAR2 | (30) | End of term termination penalty CAP option. | |
| EOT_TERM_PENALTY_CAP_AMOUNT | NUMBER | End of term termination penalty CAP amount. | ||
| EOT_TERM_PENALTY_CAP_FORMULA | VARCHAR2 | (150) | End of term termination penalty CAP formula. | |
| EOT_EST_PROP_TAX_OPTION | VARCHAR2 | (30) | End of term estimated property tax option. | |
| EOT_EST_PROP_TAX_AMOUNT | NUMBER | End of term estimated property tax amount. | ||
| EOT_EST_PROP_TAX_FORMULA | VARCHAR2 | (150) | End of term estimated property tax formula. | |
| EOT_EST_PROP_TAX_PRORATE | VARCHAR2 | (30) | End of term estimated property tax prorate. | |
| EOT_CONTR_FEES_OPTION | VARCHAR2 | (3) | End of term contractual fees option. | |
| EOT_OUTSTND_BAL_OPTION | VARCHAR2 | (3) | End of term outstanding balances option. | |
| EOT_SERV_MANT_OPTION | VARCHAR2 | (3) | End of term service and maintenance option. | |
| LIEN_TYPE | VARCHAR2 | (30) | Line type name. | |
| FILING_NUMBER | VARCHAR2 | (50) | Liens filing number. | |
| FILING_DATE | DATE | Liens filing date. | ||
| FILING_STATUS | VARCHAR2 | (30) | Liens filing status. | |
| LIEN_HOLDER_NAME | VARCHAR2 | (360) | Lien holder name. | |
| LIEN_HOLDER_ID | NUMBER | Lien holder ID. | ||
| JURISDICTION | VARCHAR2 | (50) | Liens jurisdiction. | |
| SUB_JURISDICTION | VARCHAR2 | (50) | Liens sub-jurisdiction. | |
| LIEN_EXPIRATION_DATE | DATE | Liens expiration date. | ||
| LIEN_CONTINUATION_NUMBER | VARCHAR2 | (50) | Lien continuation number. | |
| LIEN_CONTINUATION_DATE | DATE | Liens continuation date. | ||
| TITLE_TYPE | VARCHAR2 | (30) | Title type. | |
| TITLE_ISSUER_NAME | VARCHAR2 | (360) | Title issuer name. | |
| TITLE_ISSUER_ID | NUMBER | Title issuer ID. | ||
| TITLE_DATE | DATE | Title date. | ||
| TITLE_NUMBER | VARCHAR2 | (50) | Title number. | |
| REGISTRATION_NUMBER | VARCHAR2 | (50) | Title registration number. | |
| LOCATION | VARCHAR2 | (50) | Title location. | |
| TITLE_CUSTODIAN_NAME | VARCHAR2 | (360) | Title custodian name. | |
| TITLE_CUSTODIAN_ID | NUMBER | Title custodian ID. | ||
| PAYEE_SITE | VARCHAR2 | (50) | Title payee site. | |
| REGISTRATION_LOCATION | VARCHAR2 | (50) | Registration location. | |
| REG_EXPIRATION_DATE | DATE | Registration expiration date. | ||
| CREDIT_LINE_ID | NUMBER | Credit line ID. Validate against OKC_K_HEADERS_V.ID with scs code as 'CREDITLINE_CONTRACT'. | ||
| CREDIT_LINE_NUMBER | VARCHAR2 | (30) | Credit line number. Validate against OKC_K_HEADERS_V.CONTRACT_NUMBER with scs code as 'CREDITLINE_CONTRACT'. | |
| PRTFL_APPROVAL_REQ | VARCHAR2 | (3) | Contract portfolio - Approval Required 'Y'/'N'. | |
| PRTFL_ASSGN_GROUP | VARCHAR2 | (30) | Portfolio - Assignment Group. | |
| PRTFL_BUDGET_AMT_OPT | VARCHAR2 | (30) | Portfolio - Budget Amount option. | |
| PRTFL_BUDGET_FIXED_AMT | NUMBER | Portfolio - Budget Amount Fixed. | ||
| PRTFL_BUDGET_AMT_FORMULA | VARCHAR2 | (150) | Contract Portfolio -budget amount formula name. | |
| PRTFL_DAYS_FROM_CON_EXPR | NUMBER | Contract Portfolio - days from contract expiry. | ||
| PRTFL_STRATEGY | VARCHAR2 | (30) | Contract Portfolio Strategy. | |
| PROP_TAX_APPLICABLE | VARCHAR2 | (3) | Property tax applicable flag. | |
| PROP_TAX_LEASE_REP | VARCHAR2 | (3) | Property Tax Lease reporting flag. | |
| MEX_TAX_SUB_BASIC_WTHLD | VARCHAR2 | (3) | Localization - mexico tax sub-basic witheld flag. | |
| MEX_TAX_CALC_FORMULA | VARCHAR2 | (150) | Localization - Mexico tax calculation formula. | |
| AUS_TAX_STAMP_DUTY | VARCHAR2 | (3) | Localization - Australian stamp Duty Flag. | |
| CURRENCY_CONVERSION_TYPE | VARCHAR2 | (30) | Currency conversion type | |
| CURRENCY_CONVERSION_RATE | NUMBER | Currency conversion date | ||
| CURRENCY_CONVERSION_DATE | DATE | Currency conversion date | ||
| ASSIGNABLE_YN | VARCHAR2 | (3) | Assignable flag.Determines whether lease contract can be assigned to a securitization pool or not | |
| LESSEE_VENDOR_ID | NUMBER | Identifier for vendor mapped to a customer. This will be used for the purpose of making payments to the customer. Foreign key to purchasing vendors | ||
| LESSEE_VENDOR_NAME | VARCHAR2 | (240) | Vendor name for the vendor mapped to the customer. This will be used for the purpose of making payments to the customer | |
| LESSEE_VENDOR_SITE_ID | NUMBER | Vendor payables site identifier for the vendor mapped to contract customer. This will be used for making payments to customer | ||
| LESSEE_VENDOR_SITE_CODE | VARCHAR2 | (15) | Vendor payables site code for the vendor mapped to contract customer. This will be used for making payments to customer | |
| INSURANCE_COMPANY_NUMBER | VARCHAR2 | (30) | Insurance Company number, used for third party insurance. | |
| INSURANCE_COMPANY_SITE_NUMBER | VARCHAR2 | (30) | Insurance Company Site number, used for third party insurance. | |
| AGENT_NUMBER | VARCHAR2 | (30) | Agent Number, used for third party insurance. | |
| AGENT_ADDRESS_SITE_NUMBER | VARCHAR2 | (30) | Agent Site Number, used for third party insurance. | |
| CASH_APPL_RULE_NAME | VARCHAR2 | (150) | Cash application rule name for the contract. | |
| PROP_TAX_BILL_METHOD | VARCHAR2 | (35) | Billing method code for Property Tax | |
| GAIN_LOSS_TOLRNC_ALLWD_AMT | NUMBER | Gain Loss tolerance allowed amount | ||
| GAIN_LOSS_TOLRNC_ALLWD_FRML | VARCHAR2 | (150) | Gain Loss Tolerance Allowed Formula | |
| GAIN_LOSS_TOLRNC_BASIS | VARCHAR2 | (30) | Basis of Gain Loss Tolerance | |
| GAIN_LOSS_APPRV_PROC_FRML | VARCHAR2 | (150) | Formula for Gain Loss approval tolerance | |
| ERT_ABSORBED_FEE_FRML | VARCHAR2 | (150) | Formula for Early term Absorbed Fee | |
| ERT_EXPENSE_FEE_FRML | VARCHAR2 | (150) | Formula for Early term Expense Fee | |
| ERT_FINANCED_FEE_FRML | VARCHAR2 | (150) | Formula for Early term Financed Fee | |
| ERT_GENERAL_FEE_FRML | VARCHAR2 | (150) | Formula for Early term General Fee | |
| ERT_INCOME_FEE_FRML | VARCHAR2 | (150) | Formula for Early term Income Fee | |
| ERT_MISC_FEE_FRML | VARCHAR2 | (150) | Formula for Early term Miscellaneous Fee | |
| ERT_PASSTHRU_FEE_FRML | VARCHAR2 | (150) | Formula for Early term Pass through Fee | |
| ERT_ROLLOVER_FEE_FRML | VARCHAR2 | (150) | Formula for Early term Rollover Fee | |
| EOT_ABSORBED_FEE_FRML | VARCHAR2 | (150) | Formula for end of term Absorbed Fee | |
| EOT_EXPENSE_FEE_FRML | VARCHAR2 | (150) | Formula for end of term Expense Fee | |
| EOT_FINANCED_FEE_FRML | VARCHAR2 | (150) | Formula for end of term Financed Fee | |
| EOT_GENERAL_FEE_FRML | VARCHAR2 | (150) | Formula for end of term General Fee | |
| EOT_INCOME_FEE_FRML | VARCHAR2 | (150) | Formula for end of term Income Fee | |
| EOT_MISC_FEE_FRML | VARCHAR2 | (150) | Formula for end of term Miscellaneous Fee | |
| EOT_PASSTHRU_FEE_FRML | VARCHAR2 | (150) | Formula for end of term Passthrough Fee | |
| EOT_ROLLOVER_FEE_FRML | VARCHAR2 | (150) | Formula for end of term Rollover Fee | |
| LATE_INTEREST_PRODUCT_CODE | VARCHAR2 | (1995) | Late interest policy name | |
| SCHEDULED_WORKER_ID | VARCHAR2 | (30) | Worker identifier to process this contract | |
| DELETE_BEFORE_IMPORT_YN | VARCHAR2 | (1) | The flag to indicate whether to delete the contract before importing | |
| ST_UPDATE_LINES_FROM_CONTRACT | VARCHAR2 | (1) | Update contract line sales tax parameters from contract flag | |
| ST_INTEREST_DISCLOSED | VARCHAR2 | (1) | Sales tax interest disclosed flag | |
| ST_TRANSFER_OF_TITLE | VARCHAR2 | (1) | Sales tax transfer of title flag | |
| ST_SALE_AND_LEASE_BACK | VARCHAR2 | (1) | Sales tax sale or lease back flag | |
| ST_PURCHASE_OF_LEASE | VARCHAR2 | (1) | Sales tax purchase of lease flag | |
| ST_EQUIPMENT_USAGE | VARCHAR2 | (30) | Sales tax usage of equipment | |
| ST_EQUIPMENT_AGE | NUMBER | Sales tax age of equipment | ||
| ST_ASSET_UPFRONT_TAX | VARCHAR2 | (30) | Sales tax asset level upfront tax type | |
| ST_BILL_STREAM_TYPE_CODE | VARCHAR2 | (150) | Sales tax stream type code for Billing | |
| ST_BILL_STREAM_PURPOSE_CODE | VARCHAR2 | (30) | Sales tax stream purpose code for Billing | |
| ST_FIN_STREAM_TYPE_CODE | VARCHAR2 | (150) | Sales tax stream type code for financed fee | |
| ST_FIN_STREAM_PURPOSE_CODE | VARCHAR2 | (30) | Sales tax stream purpose code for financed fee | |
| ST_CAP_STREAM_TYPE_CODE | VARCHAR2 | (150) | Sales tax stream type code for capitalized fee | |
| ST_CAP_STREAM_PURPOSE_CODE | VARCHAR2 | (30) | Sales tax stream purpose code for capitalized fee | |
| INT_RATE_EFFECTIVE_FROM_DATE | DATE | Interest Rate Effective from | ||
| INT_RATE_EFFECTIVE_TO_DATE | DATE | Interest Rate Effective to | ||
| INT_RATE_PRINC_BASIS_CODE | VARCHAR2 | (30) | Interest Rate Principal Basis code | |
| INT_RATE_BASIS_CODE | VARCHAR2 | (30) | Interest Rate Basis code | |
| INT_RATE_DELAY_CODE | VARCHAR2 | (30) | Interest Rate delay code | |
| INT_RATE_DELAY_FREQ | NUMBER | Interest Rate delay frequency | ||
| INT_RATE_CMPND_FREQ_CODE | VARCHAR2 | (30) | Interest Rate compounding frequency Code | |
| INT_RATE_CATCHUP_BASIS_CODE | VARCHAR2 | (30) | Interest rate catchup basis code | |
| INT_RATE_CATCHUP_START_DATE | DATE | Interest rate catchup start date | ||
| INT_RATE_CAT_STLMNT_CODE | VARCHAR2 | (30) | Interest rate catchup settlement code | |
| INT_RATE_CHANGE_START_DATE | DATE | Interest rate change start date | ||
| INT_RATE_CHANGE_FREQ_CODE | VARCHAR2 | (30) | Interest rate change frequency code | |
| INT_RATE_CHANGE_VALUE | NUMBER | Interest rate change value | ||
| INT_RATE_CON_OPTION_CODE | VARCHAR2 | (30) | Interest rate conversion option code | |
| INT_RATE_NEXT_CON_DATE | DATE | Interest rate next conversion date | ||
| INT_RATE_CON_INDEX_NAME | VARCHAR2 | (150) | Interest rate conversion index name | |
| INT_RATE_CON_BASE_RATE | NUMBER | Interest rate conversion base rate | ||
| INT_RATE_CON_START_DATE | DATE | Interest rate conversion start date | ||
| INT_RATE_CON_ADDER_RATE | NUMBER | Interest rate conversion adder rate | ||
| INT_RATE_CON_MAXIMUM_RATE | NUMBER | Interest rate conversion maximum rate | ||
| INT_RATE_CON_MINIMUM_RATE | NUMBER | Interest rate conversion minimum rate | ||
| INT_RATE_CON_PRC_BAS_CODE | VARCHAR2 | (30) | Interest rate conversion principal basis code | |
| INT_RATE_CON_DAY_MTH_CODE | VARCHAR2 | (30) | Interest rate conversion day in a month code | |
| INT_RATE_CON_DAY_YER_CODE | VARCHAR2 | (30) | Interest rate conversion days in a year code | |
| INT_RATE_CON_INT_BAS_CODE | VARCHAR2 | (30) | Interest rate conversion interest basis code | |
| INT_RATE_CON_RATE_DELAY_CODE | VARCHAR2 | (30) | Interest rate conversion rate delay code | |
| INT_RATE_CON_RATE_DELAY_FREQ | NUMBER | Interest rate conversion rate delay frequency | ||
| INT_RATE_CON_CMPND_FREQ_CODE | VARCHAR2 | (30) | Interest rate conversion compounding frequency code | |
| INT_RATE_CON_FORMULA_NAME | VARCHAR2 | (999) | Interest rate conversion formula name | |
| INT_RATE_CON_CAT_BAS_CODE | VARCHAR2 | (30) | Interest rate conversion catchup basis code | |
| INT_RATE_CON_CAT_START_DATE | DATE | Interest rate conversion catchup start date | ||
| INT_RATE_CON_CAT_STLMNT_CODE | VARCHAR2 | (30) | Interest rate conversion catchup settlement code | |
| INT_RATE_CON_CHG_START_DATE | DATE | Interest rate conversion change start date | ||
| INT_RATE_CON_CHG_FREQ_CODE | VARCHAR2 | (30) | Interest rate conversion change frequency code | |
| INT_RATE_CON_CHG_VALUE | NUMBER | Interest rate conversion change value | ||
| INT_RATE_CAT_FREQ_CODE | VARCHAR2 | (30) | Interest rate catchup frequency code | |
| INT_RATE_CON_CAT_FREQ_CODE | VARCHAR2 | (30) | Interest rate convserion catchup frequency code | |
| RVI_STREAM_CODE | VARCHAR2 | (150) | Residual value stream type code | |
| RVI_STREAM_PURPOSE_CODE | VARCHAR2 | (30) | Residual value stream purpose code | |
| ATTRIBUTE_CATEGORY | VARCHAR2 | (150) | Descriptive flexfield category column | |
| ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive column | |
| ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive column | |
| ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive column | |
| ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive column | |
| ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive column | |
| ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive column | |
| ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive column | |
| ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive column | |
| ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive column | |
| ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive column | |
| ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive column | |
| ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive column | |
| ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive column | |
| ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive column | |
| ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive column | |
| EOT_AUTO_PROC_PURCHASE_OPT | VARCHAR2 | (1) | Automatically process end-of-term purchase options flag | |
| PTH_EVG_PAYOUT_BASIS | VARCHAR2 | (30) | Evergreen pass through payout basis | |
| PTH_PAYOUT_BASIS_FORMULA | VARCHAR2 | (150) | Evergreen pass through payout formula | |
| PTH_EVG_STREAM_CODE | VARCHAR2 | (150) | Evergreen pass through stream type code | |
| PTH_EVG_STREAM_PURPOSE_CODE | VARCHAR2 | (30) | Evergreen pass through stream type purpose code | |
| SEND_BILL_SALE | VARCHAR2 | (1) | Flag to indicate Send bill of Sale | |
| MANUAL_QUOTES_ONLY | VARCHAR2 | (1) | Flag to indicate manual quotes only | |
| FIRST_TERMINATION_DATE | DATE | First termination date | ||
| QUOTE_RCPT_ADDL_RCPT_ROLE | VARCHAR2 | (30) | Role of Quote additional recipient | |
| QUOTE_RCPT_ALLOC_PTG | NUMBER | Allocation percentage of the quote recipient | ||
| QUOTE_APPRVR_ADV_NOTICE_ROLE | VARCHAR2 | (30) | Role of Quote approver advance notice | |
| QUOTE_APPROVER_DELAY_DAYS | NUMBER | Quote approver delay days | ||
| ERT_SERV_MANT_FRML | VARCHAR2 | (150) | Early termination service and maintenance formula | |
| EOT_SERV_MANT_FRML | VARCHAR2 | (150) | End of term service and maintenance formula | |
| LEGAL_ENTITY_ID | NUMBER | Stores the Legal Entity Id. Foreign Key to XLE_ENTITY_PROFILES | ||
| ST_TAX_SCHEDULE_APPLIES_FLAG | VARCHAR2 | (1) | Sales Tax Schedule applicability at contract header level | |
| PRINT_LEAD_DAYS | NUMBER | Print Lead Days |
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 does not reference any database object
OKL.OKL_HEADER_INTERFACE is referenced by following:
APPS
OKL_HEADER_INTERFACE
|
|
|
|