OKL Tables (415)

OKL - Lease and Finance Management — documented tables from Oracle EBS ETRM 12.2.2. Click any name for its documentation, columns and AI summary.

TableColumnsDescription
OKL_ACCRUAL_GNRTNS_ALL 18 Accual rules
OKL_ACCRUAL_PROCESSING 13 This table is used only by the accrual program to process accruals
OKL_ACCT_SOURCES_ALL 45 Table that stores the accounting sources
OKL_ACC_EVENTS_ALL 18 Accounting Events
OKL_ACC_GEN_RULES_ALL 10 Account generator rule header
OKL_ACC_GEN_RUL_LNS 31 Account generator rule lines
OKL_ACC_GROUP_BAL 11 Account group balances
OKL_ACC_GROUP_CCID_ALL 11 Account groups
OKL_AE_HEADERS_ALL 27 Accounting entry headers
OKL_AE_LINES_ALL 57 Accounting Entry lines
OKL_AE_TEMPLATES_ALL 43 Accounting templates
OKL_AE_TMPT_LNES 32 Accounting template lines
OKL_AE_TMPT_SETS_ALL 14 Accounting template sets
OKL_AG_SOURCE_MAPS_ALL 12 Account generator source maps
OKL_AMORT_HLD_SETUPS_ALL 13 Setup of hold period requirements per asset category and asset book combination
OKL_ANSR_CRTRN_VALS 26 Associating a CASE with a particular combination of allowed values of allowed CRITERION
OKL_ANSR_SET_CN_VLS 33 Allowed values or "arguments" CRITERION may take on
OKL_ANSR_SET_CRTRIA_B 26 Link between Questions and Answer Sets
OKL_ANSR_SET_CRTRIA_TL 10 Translatable columns from OKL_ANSR_SET_CRTRIA_B, per MLS standards
OKL_ANSWERS 26 State, circumstance, situation, possibility or case
OKL_ANSWER_SETS_B 30 Set of possible states, circumstances, situations, possibilities or cases
OKL_ANSWER_SETS_TL 11 Translatable columns from OKL_ANSWER_SETS_B, per MLS standards
OKL_ASSETS_B 39 OKL_ASSETS_B stores header information about assets quoted on a Lease Quote.
OKL_ASSETS_TL 12 OKL_ASSETS_TL holds translatable data of OKL_ASSETS_B.
OKL_ASSET_CNDTNS_ALL 34 Details of a condition report of an asset
OKL_ASSET_CNDTN_LNS_TL 13 Translatable columns from OKL_ASSET_CNDTN_LNS_B, per MLS standards
OKL_ASSET_COMPONENTS_B 32 Asset components are sourced from inventory items. Asset components are always created within the context of a Quoted Asset.
OKL_ASSET_COMPONENTS_TL 12 OKL_ASSET_COMPONENTS_TL holds translatable data of OKL_ASSET_COMPONENTS_B.
OKL_ASSET_RETURNS_ALL_B 59 The transaction table for managing assets that are off lease after a contract termination or assets that have been identified as possible re
OKL_ASSET_RETURNS_TL 11 Translatable columns from OKL_ASSET_RETURNS_B, per MLS standards
OKL_AST_CNDTN_LNS_ALL_B 48 The line of a condition report detailing the item description and damage
OKL_BILLING_CHARGES_TL 11 Translatable columns from OKL_BILLING_CHARGES_B, per MLS standards
OKL_BLLNG_CHRG_HDRS_TL 12 Translatable columns from OKL_BLLNG_CHRG_HDRS_B, per MLS standards
OKL_BLNG_CHARGES_ALL_B 56 Billing import mechanism within OKL provides an ability to read third-party files containing billing charges
OKL_BLNG_CHRG_HDRS_ALL_B 31 The batch or file of records transmitted
OKL_BOOK_CONTROL_TRX_ALL 15 OKL Booking Controller Transaction Table
OKL_BUCKETS 17 Loss rates
OKL_CASH_ALLCTN_RLS_ALL 37 Contains generic attributes applied to all mismatched receipts
OKL_CASH_FLOWS 32 Table used to store the header details of Cash Flows in OKL
OKL_CASH_FLOW_LEVELS 33 Table used to store the levels of Cash Flows
OKL_CASH_FLOW_OBJECTS 26 Table used to store the object that can be associated to a cash flow
OKL_CF_OBJECT_PERIODS 27 Table used to store the object periods of a Cash Flow
OKL_CHECKLISTS_ALL 40 Checklist item templates for Credit line and Funding request
OKL_CHECKLIST_DTLS_ALL 40 Detail checklist item templates for Credit line and Funding request
OKL_CNSLD_AP_INVS_ALL 53 Payables consolidated invoice header
OKL_CNSLD_AR_HDRS_ALL_B 41 Single printed report "bill" for many actual AR invoices
OKL_CNSLD_AR_HDRS_TL 10 Translatable columns from OKL_CNSLD_AR_HDRS_B, per MLS standards
OKL_CNSLD_AR_LINES_B 37 Line of consolidated invoice
OKL_CNSLD_AR_LINES_TL 9 Translatable columns from OKL_CNSLD_AR_LINES_B, per MLS standards
OKL_CNSLD_AR_STRMS_B 44 Lowest level transaction included into consolidated bill
OKL_CNSLD_AR_STRMS_TL 9 Translatable columns from OKL_CNSLD_AR_STRMS_B, per MLS standards
OKL_CNTRCT_BALANCES_ALL 42 Contract Balances
OKL_CNTR_LVLNG_GRPS_TL 12 Translatable columns from OKL_CNTR_LVLNG_GRPS_B, per MLS standards
OKL_CNTR_LVLNG_LNS_B 25 Assigns Contract Lines (Assets) to Counter Leveling Groups
OKL_CNTR_LVL_GRPS_ALL_B 34 Associates a number of counters together for leveling, averaging purposes
OKL_CNTX_GRP_PRMTRS 10 Association of Parameters for the Context Group
OKL_CODE_CMBNS_GT 2
OKL_CONDITION_MSSGS 26 Associates one or more sequenced messages to be printed with boolean function
OKL_CONTEXT_GROUPS_B 9 Grouping of list of parameters required by the Formulae.
OKL_CONTEXT_GROUPS_TL 11 Translatable columns from OKL_CONTEXT_GROUPS_B, per MLS standards
OKL_CONTRACT_ASSET_H 55 History table for recording attributes of Fixed Asset module when a contract is versioned.
OKL_CONTRACT_IB_H 33 History table for recording attributes of Install Base module when a contract is versioned.
OKL_CONVERT_INT_RATE_REQUEST 50 Convert Interest Table
OKL_COST_ADJUSTMENTS_B 34 OKL_COST_ADJUSTMENTS_B stores financing cost adjustments of quoted assets.
OKL_COST_ADJUSTMENTS_TL 12 OKL_COST_ADJUSTMENTS_TL holds translatable data of OKL_COST_ADJUSTMENTS_B.
OKL_CREDIT_REQUESTS 35 Transaction-level request information.
OKL_CRITERIA_B 26 Parameters, the values of which, define the possible CASE in a CASE SET
OKL_CRITERIA_TL 11 Translatable columns from OKL_CRITERIA_B, per MLS standards
OKL_CRTRN_LNSTYLS 25 The linestyles which the criterion can be found at
OKL_CRTRN_SBCLSSES 25 The subclasses which the criterion can be found at
OKL_CRTRN_USER_VALS_B 26 A list of user defined values for a user defined criterion
OKL_CRTRN_USER_VALS_TL 10 Translatable columns from OKL_CRTRN_USER_VALS_B, per MLS standards
OKL_CSH_ALLCT_RL_HDR_ALL 26 Cash application rules header
OKL_CSH_ALLCT_SRCHS_ALL 28 During automatic cash allocation process, defines the combination of transactions types that can be used for search purposes
OKL_CURE_AMOUNTS_ALL 49 Stores cure and repurchase amounts generated per contract per period
OKL_CURE_FUND_SUMS_ALL 30 Stores funds available for refund (basically derived from overpayment/under payment for a report), and grouped by vendor program
OKL_CURE_FUND_TRANS_ALL 34 Stores over payment/under payment amounts per payment against a report, and grouped against a vendor program
OKL_CURE_PAYMENT_LNS_ALL 41 Stores line level information for OKL CURE PAYMENTS
OKL_CURE_REFUNDS_ALL 44 Stores refunds made to vendor for cured contracts. Cure refund pool is per contract. The refund will group all the cash recieved by the vend
OKL_CURE_REFUND_HEADERS_B 43 Stores refunds made to vendor for cured contracts. The table will hold refund requests grouped by currency and vendor /contract.
OKL_CURE_REFUND_HEADERS_TL 10 Translatable columns from OKL_CURE_REFUND_REQUESTS_B, per MLS standards
OKL_CURE_REFUND_STAGE 32 Staging area of cured contracts, which needs to be refunded.
OKL_CURE_REPORTS_ALL 38 Stores request header details for cure repurcahse request
OKL_CURE_REPORT_AMTS_ALL 40 Stores line level information for OKL_CURE_REPORTS table
OKL_DATA_SRC_FNCTNS_B 31 The name of the function that maps to the desired PL/SQL function.
OKL_DATA_SRC_FNCTNS_TL 11 Translatable columns from OKL_DATA_SRC_FNCTNS_B, per MLS standards
OKL_DF_CTGY_RMK_TMS_ALL 13 The default asset category/remarketing teams
OKL_DISB_RULES_ALL_B 36 Disbursement Rules table for consolidation of disbursement transactions
OKL_DISB_RULES_TL 10 Translatable columns from OKL_DISB_RULES_ALL_B, per MLS standards
OKL_DISB_RULE_STY_TYPES 25 Disbursement stream types for consolidation
OKL_DISB_RULE_VENDOR_SITES 31 Disbursement rule vendor sites
OKL_EXT_AP_HEADER_SOURCES_B 79 Payables transactions header extension table
OKL_EXT_AP_HEADER_SOURCES_TL 12
OKL_EXT_AP_LINE_SOURCES_B 43 Payables transactions line extension table
OKL_EXT_AP_LINE_SOURCES_TL 13
OKL_EXT_AR_HEADER_SOURCES_B 78 Receivables transactions header extension table
OKL_EXT_AR_HEADER_SOURCES_TL 12
OKL_EXT_AR_LINE_SOURCES_B 47 Receivables transactions line extension table
OKL_EXT_AR_LINE_SOURCES_TL 13
OKL_EXT_BILLING_INTF_ALL 83 External Billing Interface
OKL_EXT_CSH_RCPTS_ALL_B 52 A receipt received from a customer and send to Receivables lockbox interface
OKL_EXT_CSH_RCPTS_TL 10 Translatable columns from OKL_EXT_CSH_RCPTS_B, per MLS standards
OKL_EXT_FA_HEADER_SOURCES_B 77 Fixed Assets transactions header extension table
OKL_EXT_FA_HEADER_SOURCES_TL 11
OKL_EXT_FA_LINE_SOURCES_B 39 Fixed Assets transactions line extension table
OKL_EXT_FA_LINE_SOURCES_TL 12
OKL_EXT_FUND_RQNS_ALL_B 29 External transaction header when purchase requisition required
OKL_EXT_FUND_RQNS_TL 9 Translatable columns from OKL_EXT_FUND_RQNS_B, per MLS standards
OKL_EXT_PAY_INVS_ALL_B 54 Header information about invoices exported to AP
OKL_EXT_PAY_INVS_TL 12 Translatable columns from OKL_EXT_PAY_INVS_B, per MLS standards
OKL_EXT_SELL_INVS_ALL_B 50 External transactions header table for Billing records. It stores data ready for AR Interface.
OKL_EXT_SELL_INVS_TL 14 Translatable columns from OKL_EXT_SELL_INVS_B, per MLS standards
OKL_FEES_B 42 OKL_FEES_B stores header information about fees quoted on a Lease Quote.
OKL_FEES_TL 12 OKL_FEES_TL holds translatable data of OKL_FEES_B.
OKL_FE_ADJ_MAT_ALL_B 31 Pricing adjustment matrix header table
OKL_FE_ADJ_MAT_ALL_TL 10 Pricing adjustment matrix translations table storing name and description
OKL_FE_ADJ_MAT_VERSIONS 28 Pricing adjustment matrix versions table
OKL_FE_CRITERIA 12 Eligibility Criteria Line Attributes
OKL_FE_CRITERIA_SET 11 Eligibility Criteria Header attributes
OKL_FE_CRITERION_VALUES 28 Eligibility Criteria Line values
OKL_FE_CRIT_CAT_DEF_B 18 Criteria Categories base Table
OKL_FE_CRIT_CAT_DEF_TL 11 Criteria Categories Translatable
OKL_FE_CRIT_CAT_OBJECTS 10 Applicable Object Classes for Eligibility Criteria Categories
OKL_FE_EO_TERMS_ALL_B 33 End of Term value header table
OKL_FE_EO_TERMS_ALL_TL 10 End-of-Term Value header translations table
OKL_FE_EO_TERM_OBJECTS 29 End-of-Term Values Objects table
OKL_FE_EO_TERM_VALUES 26 End-of-Term Values table
OKL_FE_EO_TERM_VERS 28 End-of-Term Values Versions table
OKL_FE_ITEM_RESDL_VALUES 11 Item Residual Line Values
OKL_FE_ITEM_RESIDUAL_ALL 20 Item Residual Header
OKL_FE_RATE_SET_LEVELS 30 Lease Rate Factor Levels
OKL_FE_RATE_SET_VERSIONS 38 Lease Rate Set Versions
OKL_FE_RESI_CAT_ALL_B 12 Residual Category Set Base
OKL_FE_RESI_CAT_ALL_TL 10 Residual Category Set Translatable
OKL_FE_RESI_CAT_OBJECTS 12 Residual Category Set Objects
OKL_FE_STD_RT_TMP_ALL_B 37 Standard Rate Template header table
OKL_FE_STD_RT_TMP_ALL_TL 10 Standard Rate Template translations table storing name and description
OKL_FE_STD_RT_TMP_VERS 34 Standard Rate Template versions table
OKL_FMLA_OPRNDS 11 Association of Formulae and Operands
OKL_FNCTN_PRMTRS_B 12 Constant values for the parameter or the association of parameter to function. It can be of CHAR, Number & Date data types.
OKL_FNCTN_PRMTRS_TL 12 Translatable columns from OKL_FNCTN_PRMTRS_B, per MLS standards
OKL_FORMULAE_B 33 Definition of formulae. It also holds the context group required by the formula
OKL_FORMULAE_TL 11 Translatable columns from OKL_FORMULAE_B, per MLS standards
OKL_FRENCH_TAX_B 27 Localization Table to store French Tax Codes.
OKL_FRENCH_TAX_TL 11 Translatable columns from OKL_FRENCH_TAX_B, per MLS standards
OKL_G_REPORTS_GT 50
OKL_HEADER_INTERFACE 422 Open interface Header Table
OKL_INDEX_VALUES 15 Interest rate values
OKL_INDICES 31 Interest rate header
OKL_INDX_INTERFACES 36 Index interface table
OKL_INSURANCE_ESTIMATES_B 25 OKL_INSURANCE_ESTIMATES_B stores insurance estimated on a Lease Quote.
OKL_INSURANCE_ESTIMATES_TL 12 OKL_INSURANCE_ESTIMATES_TL holds translatable data of OKL_INSURANCE_ESTIMATES_B.
OKL_INSURANCE_WORKFLOW_TRX 30 Status of workflow to gather insurance information
OKL_INSURER_RANKINGS 28 Provider's ranking
OKL_INS_ASSETS_ALL 33 Insurance for fixed asset line
OKL_INS_CLAIMS_ALL_B 37 Lease and optional insurance claims
OKL_INS_CLAIMS_TL 12 Translatable columns from OKL_INS_CLAIMS_B, per MLS standards
OKL_INS_CLASS_CATS 11 Insurance asset class
OKL_INS_EXCLUSIONS_B 28 Restrictions on selling
OKL_INS_EXCLUSIONS_TL 10 Translatable columns from OKL_INS_EXCLUSIONS_B, per MLS standards
OKL_INS_POLICIES_ALL_B 72 Insurance policies and quotes
OKL_INS_POLICIES_TL 13 Translatable columns from OKL_INS_POLICIES_B, per MLS standards
OKL_INS_PRODUCTS_B 37 Lease and optional insurance products
OKL_INS_PRODUCTS_TL 11 Translatable columns from OKL_INS_PRODUCTS_B, per MLS standards
OKL_INS_RATES 34 Rates for insurance premium
OKL_INVC_FRMT_STRMS 26 Every stream type has to be assigned to one of invoice types and be included into one of invoice lines
OKL_INVC_LINE_TYPES_B 25 The "type" of invoice line in terms of which transactions, stream types, cash flows will be grouped into the invoice line type
OKL_INVC_LINE_TYPES_TL 11 Translatable columns from OKL_INVC_LINE_TYPES_B, per MLS standards
OKL_INVC_MSS_PRCDRS 26 PL/SQL function which returns the boolean value to determine whether messages are printed on invoice
OKL_INVOICE_FORMATS_TL 11 Translatable columns from OKL_INVOICE_FORMATS_B, per MLS standards
OKL_INVOICE_MSSGS_ALL_B 29 A standard message to be printed on invoices
OKL_INVOICE_MSSGS_TL 12 Translatable columns from OKL_INVOICE_MSSGS_B, per MLS standards
OKL_INVOICE_TYPES_B 26 The "type" of invoice in terms of which transactions, stream types, cash flows will be grouped onto the invoice type
OKL_INVOICE_TYPES_TL 11 Translatable columns from OKL_INVOICE_TYPES_B, per MLS standards
OKL_INV_FORMATS_ALL_B 28 Describes the presentation of invoice information
OKL_INV_MSSG_ATT 25 Messages to be displayed for consolidated invoice
OKL_ITM_CAT_RV_PRCS 32 Stores the item residual value percentages.
OKL_IV_PAYOUT_SMRY_ALL_B 37 Investor payout summary
OKL_K_CONTROL 10 Earliest next billing date for each contract is stored in this table.
OKL_K_HEADERS 83 Oracle Lease Management shadow table for Oracle Contracts Core header tables, OKC_K_HEADERS_B and OKC_K_HEADERS_TL. OKL_K_HEADERS contains
OKL_K_HEADERS_H 84 History table for OKL_K_HEADERS
OKL_K_LINES 130 Oracle Lease Management shadow table for Oracle Contracts Core line tables, OKC_K_LINES_B and OKC_K_LINES_TL. OKL_K_LINES contains attribute
OKL_K_LINES_H 131 History Table for table OKL_K_LINES_B
OKL_K_PARTY_ROLES 23 Lease Contract Party Roles
OKL_K_PARTY_ROLES_H 24 History table for OKL_K_PARTY_ROLES
OKL_K_RATE_PARAMS 49 Transaction table for storing interest rate parameters for a lease contract
OKL_LATE_INTERESTS 36 Interest which may be charged on over due receivables
OKL_LATE_POLICIES_ALL_B 47 Policy for charging on overdue receivables
OKL_LATE_POLICIES_TL 10 Translatable columns from OKL_LATE_POLICIES_B, per MLS standards
OKL_LEASEAPP_DATAPOINTS 11 Stores the additional data point values that can have user entered values from Lease Application
OKL_LEASEAPP_TEMPL_VERSIONS_B 30 Lease Application Template Versions
OKL_LEASEAPP_TEMPL_VERSIONS_TL 10 Translatable table for Lease Application Template Versions
OKL_LEASEAPP_TMPLS_ALL 32 Lease Application templates
OKL_LEASE_APPLICATIONS_TL 11 OKL_LEASE_APPLICATIONS_TL holds translatable data of OKL_LEASE_APPLICATIONS_B.
OKL_LEASE_APPS_ALL_B 50 Lease Applications
OKL_LEASE_OPPORTUNITIES_TL 12 OKL_LEASE_OPPORTUNITIES_TL holds translatable data of OKL_LEASE_OPPORTUNITIES_B.
OKL_LEASE_OPPS_ALL_B 55 OKL_LEASE_OPPORTUNITIES_B is the Lease Opportunity header table.
OKL_LEASE_QUOTES_B 74 OKL_LEASE_QUOTES_B is the Lease Quote header table. Lease Quotes (also known as Sales Quotes in OLM documentation) created within the conte
OKL_LEASE_QUOTES_TL 12 OKL_LEASE_QUOTES_TL holds translatable data of OKL_LEASE_QUOTES_B.
OKL_LINES_INTERFACE 219 Contract Open Interface Lines Table
OKL_LINE_RELATIONSHIPS_B 29 Line Relationships
OKL_LINE_RELATIONSHIPS_TL 12 Translatable table for Line Relationships
OKL_LRF_INTERFACE 9 No Longer Used
OKL_LS_RT_FCTR_ENTS 29 Child table of OKL_LS_RT_FCTR_SETS_B.
OKL_LS_RT_FCTR_SETS_TL 11 Translatable columns from OKL_LS_RT_FCTR_SETS_B, per MLS standards
OKL_LS_RT_FTR_SETS_ALL_B 37 The Rate Card (Lease Rate Set) header table.
OKL_LTE_CHRG_SETUPS 35 When a lessee/borrower does not pay an invoice prior to the due date, a penalty can be assessed
OKL_MASS_RBK_CRITERIA 32 Table to capture OKL Mass Rebook Criteria and Set Values
OKL_OPEN_INT_ALL 82 Open Interface for report to credit bureau/transfer to external agency
OKL_OPEN_INT_ASST 62 Open interface asset details for report to credit bureau/transfer to external agency
OKL_OPEN_INT_PRTY 57 Open interface guarantor details for report to credit Bureau/transfer to external agency
OKL_OPERANDS_B 17 Operands required by the Formulae
OKL_OPERANDS_TL 11 Translatable columns from OKL_OPERANDS_B, per MLS standards
OKL_OPTIONS 27 Options are defined to characterize the Contract
OKL_OPT_RULES 14 Association of Rules with Option
OKL_OPT_VALUES 12 Values that can be associated with the option
OKL_OPV_RULES 15 Association of Option Values with Option Rules. This is used by Option Value Rule Template during Product Setup.
OKL_OVD_RUL_TMLS 10 Association of Option Value rules with Rule Templates.
OKL_PARALLEL_PROCESSES 18 Used for spawning child concurrent programs for the master billing programs.
OKL_PARAMETERS_B 11 List of parameters required by the Formulae.
OKL_PARAMETERS_TL 11 Translatable columns from OKL_PARAMETERS_B, per MLS standards
OKL_PARTY_PAYMENT_DTLS 41 Party payment details table
OKL_PARTY_PAYMENT_HDR 17 Header table to store pass through line level parameters
OKL_PARTY_PAYMENT_HDR_H 18 History table for okl_party_payment_hdr to store pass through line level parameters
OKL_PARTY_PYMT_DTLS_H 42 History table for OKL_PARTY_PAYMENT_DTLS
OKL_PARTY_ROLES_INTERFACE 85 Contract Open Interface Party Roles Table
OKL_PAYMENTS_INTERFACE 16 Contract Open Interface Payments Table
OKL_PDT_OPTS 12 Association of options with a product.
OKL_PDT_OPT_VALS 11 Association of option values with a product.
OKL_PDT_PQYS 11 Association of qualities with product .
OKL_PDT_PQY_VALS 12 Association Quality Values with a product.
OKL_PDT_QUALITYS 13 Product Qualities used by Product Template - Product Qualities during product setup.
OKL_PDT_TEMPLATES 12 Product Templates used by Product during setup.
OKL_PMT_CHANNEL_METHODS_ALL 10 Table to store mapping between PAyment Method and Receipt Method
OKL_POOLS_ALL 44 Securitization pool header.
OKL_POOL_CONTENTS 40 Details for a pool header.
OKL_POOL_TRANSACTIONS 40 Pool transactions.
OKL_POOL_TYPES 28 Categorization of pools.
OKL_PQY_VALUES 13 Values attached to Product Qualities and are used by Product - Quality Value during Product Setup.
OKL_PRD_PRICE_TMPLS 14 Holds the details of pricing templates which are used for external pricing.
OKL_PROCESS_TMPLTS_ALL_B 30 Intersection table between JTF_AMV_ITEMS_B (stores Fulfillment Master Documents) and FND_LOOKUPS (stores OKL Process codes).
OKL_PROCESS_TMPLTS_TL 10 Translatable columns from OKL_PROCESS_TMPLTS_B, per MLS standards
OKL_PRODUCTS 33 Define the financial treatment for the contract.
OKL_PROD_STRM_TYPES 12 Association of Stream Types with Product.
OKL_PROPERTY_TAX_ALL_B 47 Property tax Info for asset for which lease contract is signed
OKL_PROPERTY_TAX_TL 10 Translatable columns from OKL_PROPERTY_TAX_B, per MLS standards
OKL_PROVISIONS 33 Loss provisions
OKL_PRPTY_TAX_SETUPS_ALL 13 Stores the setup for estimated property tax
OKL_PRTFL_CNTRCTS_B 29 Contract activation triggers the generation of a portfolio management strategy profile. The profile defines a strategy that determines the
OKL_PRTFL_CNTRCTS_TL 11 Translatable columns from OKL_PRTFL_CNTRCTS_B, per MLS standards
OKL_PRTFL_LINES_B 42 The profile defines a strategy that determines the action(s) to be taken when a contract reaches the end of term and a budget amount that is
OKL_PRTFL_LINES_TL 10 Translatable columns from OKL_PRTFL_LINES_B, per MLS standards
OKL_PTL_PTQ_VALS 12 Association of Template Qualities and Values with Product Template.
OKL_PTL_QUALITYS 11 Template Qualities used by Product Template - Template Qualities during Product Setup.
OKL_PTQ_VALUES 12 Values attached to Template Qualities and is used by Product Template - Template Qualities during Product Setup.
OKL_QUESTION_CRTRNS 25 A relationship or associative entity defining the allowed set of CRITERION or "parameters"
OKL_QUESTION_TYPES_B 28 A matter or question requiring action, depending on the situation
OKL_QUESTION_TYPES_TL 11 Translatable columns from OKL_QUESTION_TYPES_B, per MLS standards
OKL_QUICK_QUOTES_ALL_B 56 OKL_QUICK_QUOTES_B is the Quick Quote header table.
OKL_QUICK_QUOTES_TL 12 OKL_QUICK_QUOTES_TL holds translatable data of OKL_QUICK_QUOTES_B.
OKL_QUICK_QUOTE_LINES_B 33 All lines of a quick quote are stored in this table.
OKL_QUICK_QUOTE_LINES_TL 12 OKL_QUICK_QUOTE_LINES_TL holds translatable data of OKL_QUICK_QUOTE_LINES_B.
OKL_QUOTE_LINE_STRM_ALL 11 During termination quote billing, indicates which stream type to use for every quote line
OKL_QUOTE_PARTIES 20 The parties related to the quote, could be one or more OKL contract party roles
OKL_QUOTE_RATE_FACTORS 28 Table for Storing Quote's Rate factors.
OKL_QUOTE_SUBPOOL_USAGE 36 Stores the maximum subsidy pool usage for an object
OKL_RBK_SELECTED_CONTRACT 31 This table stores the selected Contracts for Rebooking.
OKL_RELOCATE_ASSETS_TL 10 Translatable columns from OKL_RELOCATE_ASSETS_B, per MLS standards
OKL_RELOCATE_ASTS_ALL_B 39 Represents the shipping instructions of an asset determined during the asset return process
OKL_REMARKTNG_COSTS_TL 10 Translatable columns from OKL_REMARKTNG_COSTS_B, per MLS standards
OKL_REPAIR_COSTS_ALL_B 15 Setup table to store types of repair and a recommended cost applicable to asset condition repairs
OKL_REPAIR_COSTS_TL 11 Translatable columns from OKL_REPAIR_COSTS_B, per MLS standards
OKL_REPORTS_B 16 This table stores basic information of a report.
OKL_REPORTS_TL 11 Translatable Columns for table OKL_REPORTS_B
OKL_REPORT_ACC_PARAMS 10
OKL_REPORT_PARAMETERS 12 Table to store parameters of a particular Report
OKL_REPORT_STREAM_PARAMS 9
OKL_REPORT_TRX_PARAMS 10
OKL_REP_PRODUCTS_GT 2
OKL_RMKTNG_COSTS_ALL_B 36 Used to document the remarketing costs associated with the whole remarketing process, including return, condition, repurchase
OKL_RULES_DFF 59 Structured data representation of free format text contained in an ARTICLE. This is Contracts for Lease Copy of OKL_RULES_B created for the
OKL_RV_INTERFACE_ALL 11 Interface table used to import Item Residual Values.
OKL_SERVICES_B 28 OKL_SERVICES_B stores header information about services quoted on a Lease Quote.
OKL_SERVICES_TL 12 OKL_SERVICES_TL holds translatable data of OKL_SERVICES_B.
OKL_SERVICE_FEES_ALL_B 29 The fee charged for service rendered.
OKL_SERVICE_FEES_TL 11 Translatable columns from OKL_SERVICE_FEES_B, per MLS standards
OKL_SGN_TRANSLATIONS 31 Holds the mapping for parameter values between Oracle and external pricing engine.
OKL_SIF_FEES 56 Holds the fee and payment details required for external pricing.
OKL_SIF_LINES 63 Holds the asset line details used for external pricing.
OKL_SIF_PRICE_PARMS 32 Holds the details for the custom parameters used for external pricing.
OKL_SIF_PRICING_PARAMS 32 Holds the stream interface pricing parameters
OKL_SIF_RETS 36 Holds the header details for the data returned by the external pricing engine.
OKL_SIF_RET_ERRORS 29 Holds the details of errors returned by the external pricing engine.
OKL_SIF_RET_LEVELS 36 Holds the payment levels returned from the external pricing engine.
OKL_SIF_RET_STRMS 29 Holds the streams returned by the external pricing process.
OKL_SIF_STREAM_TYPES 12 Holds the stream types that are generated for a transaction from the external pricing engine.
OKL_SIF_TRX_PARMS 14 Holds the value of the custom parameters for the transactions for external pricing engine.
OKL_SIF_YIELDS 34 Holds the definition of the yields that are calculated for a transaction by the external pricing engine.
OKL_SLCTD_OPTNS 25 OKL_SLCTD_OPTNS links a lease contract to product option values.
OKL_SRCH_STRM_TYPS 26 Stream types to use for automatic cash application
OKL_SSC_PARTY_ROLE_MAP 11 Role Visiblity Matrix
OKL_STREAMS 28 Holds the payment header details.
OKL_STREAMS_H 29 Holds Streams History Details
OKL_STREAM_INTERFACES 58 Holds the contract header level details for external pricing.
OKL_STREAM_TRX_DATA 13 Holds the XML data for a transaction with the external pricing engine.
OKL_STRM_ELEMENTS 24 Holds the actual payment schedules for a payment header.
OKL_STRM_ELEMENTS_H 24 Holds the stream elemnts history details
OKL_STRM_TYPE_B 42 Holds the definition of payment types.
OKL_STRM_TYPE_EXEMPT 26 Streams exempt from overdue charges
OKL_STRM_TYPE_TL 13 Translatable columns from OKL_STRM_TYPE_B, per MLS standards
OKL_STRM_TYP_ALLOCS 28 Describes the priority or sequence in which to apply insufficient cash to stream types
OKL_ST_GEN_PRC_PRMS_ALL 15 This table holds Stream Generation Pricing Parameters
OKL_ST_GEN_TEMPLATES_ALL 29 This table holds all the stream templates for a stream template set.
OKL_ST_GEN_TMPT_LNS_ALL 13 This table holds the stream template lines for a stream template
OKL_ST_GEN_TMPT_SETS_ALL 19 This table holds the stream template sets.
OKL_SUBSIDIES_ALL_B 49 This table stores subsidy setups.
OKL_SUBSIDIES_TL 11 Translation table for OKL_SUBSIDIES_B
OKL_SUBSIDY_CRITERIA 34 This table stores applicability criterion for a subsidy
OKL_SUBSIDY_POOLS_B 35 This table stores subsidy pools data
OKL_SUBSIDY_POOLS_TL 11 Translation table for OKL_SUBSIDY_POOLS_B
OKL_SUBSIDY_POOL_BUDGETS_B 30 This table stores the budget lines for subsidy pools
OKL_SUBSIDY_POOL_BUDGETS_TL 10 Translation table for OKL_SUBSIDY_POOL_BUDGETS_B
OKL_SUPP_INVOICE_DTLS 31 A contract line level table to record vendor invoice and shipping details for the line item.
OKL_SUPP_INVOICE_DTLS_H 32 History Table for table OKL_SUPP_INVOICE_DTLS
OKL_SYSTEM_PARAMS_ALL 63 Table for storing the parameters used by the system.
OKL_SYS_ACCT_OPTS_ALL 59 System accounting options
OKL_TAA_REQUEST_DETAILS_B 48 Table for storing the the Transfer and Assumption request details
OKL_TAD_GL_DATE_NM_T 3 This table is used for data migration of SLA Uptake project
OKL_TAL_TCL_MAP_T 2 This table is used for migration of Asset Disposition transaction
OKL_TAXBASISOVERRIDE_ALL 29 This table is used to store the taxable basis override formula for tax transactions.
OKL_TAX_ATTR_DEFINITIONS 44 This table is used to store the definitions of Transaction Business Category, Product Category and User Defined Fiscal Classification as set
OKL_TAX_LINES_ALL 50 Display tax lines for VAT requirement on lease center
OKL_TAX_SOURCES 83 This table is used to store the taxable lines for OLM tax events.
OKL_TAX_SOURCES_T 85 This table is used during upgrades to store taxable lines
OKL_TAX_TRX_DETAILS 73 This table is used to store the tax lines for OLM tax events
OKL_TAX_TRX_DETAILS_T 75 This table is used during upgrades, to store the tax lines.
OKL_TAX_TRX_DTLS_GT 2
OKL_TERMNT_INTERFACE_ALL 48 Termination interface table that allows import of contract or asset termination requests
OKL_TERMNT_INTF_PTY 39 Termination interface detail table that allows import of termination quote party information pertaining to contract or asset termination req
OKL_TERMS_INTERFACE 18 Contracts Open Terms Interface Rules Table
OKL_TRNS_ACC_DSTRS_ALL 57 Accounting distributions
OKL_TRX_ACCT_OPTS_ALL 33 Transaction accounting options
OKL_TRX_AP_INVOICES_TL 10 Translatable columns from OKL_TRX_AP_INVOICES_B, per MLS standards
OKL_TRX_AP_INVS_ALL_B 72 Collection of all OKL transaction which generate Payables invoices
OKL_TRX_AR_ADJSTS_ALL_B 36 OKL writeoffs which generate AR adjustments
OKL_TRX_AR_ADJSTS_TL 10 Translatable columns from OKL_TRX_AR_ADJSTS_B, per MLS standards
OKL_TRX_AR_INVOICES_B 73 Collection of all OKL transaction which generate Receivables invoices
OKL_TRX_AR_INVOICES_TL 10 Translatable columns from OKL_TRX_AR_INVOICES_B, per MLS standards
OKL_TRX_ASSETS 35 A top level transaction table to group all the transactions for creation of Asset lines for a Lease/Loan contract
OKL_TRX_CONTRACTS_ALL 97 Lease transactions header table
OKL_TRX_CSH_BATCH_ALL_B 41 Batch of manual cash receipt entered via OKL
OKL_TRX_CSH_BATCH_TL 11 Translatable columns from OKL_TRX_CSH_BATCH_B, per MLS standards
OKL_TRX_CSH_RCPT_ALL_B 49 Individual receipt processed in a batch
OKL_TRX_CSH_RECEIPT_TL 10 Translatable columns from OKL_TRX_CSH_RECEIPT_B, per MLS standards
OKL_TRX_EXTENSION_B 65 Lease transactions header extension table
OKL_TRX_EXTENSION_TL 13 Lease transactions header MLS extension table
OKL_TRX_MSGS 20 System messages related to a transaction. References AOL messages
OKL_TRX_PARAMS_B 10 Stores the Attributes which are required to be shown to the user for a given billing transaction, but are not required for Billing as such.
OKL_TRX_QTE_CF_OBJECTS 26 Table used to store the objects assoicated with a quote.
OKL_TRX_QUOTES_ALL_B 81 Termination, restructure or repurchase quotes
OKL_TRX_QUOTES_TL 10 Translatable columns from OKL_TRX_QUOTES_B, per MLS standards
OKL_TRX_REQUESTS 81 Stores transaction-level request information. Records in this table either represent Contract-level requests or Asset-level requests.
OKL_TRX_SUBSIDY_POOLS 38 This entity holds subsidy pool transaction information for Lease Contract, Lease Quote, Lease Application and Lease Opportunity
OKL_TRX_TYPES_B 20 Transaction types
OKL_TRX_TYPES_TL 14 Translatable columns from OKL_TRX_TYPES_B, per MLS standards
OKL_TXD_AR_LN_DTLS_B 64 Transaction line details to be included into Receivables invoices
OKL_TXD_AR_LN_DTLS_TL 11 Translatable columns from OKL_TXD_AR_LN_DTLS_B, per MLS standards
OKL_TXD_ASSETS_B 40 A transaction table to record various Tax book related assets attributes needed by Fixed Asset Module before activating the contract and ad
OKL_TXD_ASSETS_TL 10 Translatable columns from OKL_TXD_ASSETS_B, per MLS standards
OKL_TXD_QTE_ANT_BILL_ALL 39 Table for storing Billing information for future dated quote
OKL_TXD_QUOTE_LINE_DTLS 31 Quote lines details. References the serial numbers for partial line termination
OKL_TXL_ADJSTS_LNS_ALL_B 39 Application of OKL writeoffs to AR invoices
OKL_TXL_ADJSTS_LNS_TL 9 Translatable columns from OKL_TXL_ADJSTS_LNS_B, per MLS standards
OKL_TXL_AP_INV_LNS_ALL_B 51 Transaction lines to be included into Payables invoices
OKL_TXL_AP_INV_LNS_TL 10 Translatable columns from OKL_TXL_AP_INV_LNS_B, per MLS standards
OKL_TXL_AR_INV_LNS_B 55 Transaction lines to be included into Receivables invoices
OKL_TXL_AR_INV_LNS_TL 11 Translatable columns from OKL_TXL_AR_INV_LNS_B, per MLS standards
OKL_TXL_ASSETS_B 80 A contract line level transaction table to record various asset attributes needed by Fixed Asset Module before activating the contract.
OKL_TXL_ASSETS_TL 10 Translatable columns from OKL_TXL_ASSETS_B, per MLS standards
OKL_TXL_CNTRCT_LNS_ALL 58 Lease transactions line table
OKL_TXL_EXTENSION_B 34 Lease transaction lines extension table
OKL_TXL_EXTENSION_TL 11 Lease transaction lines MLS extension table
OKL_TXL_ITM_INSTS 44 A contract line level transaction table to record various Install Base Module location attributes of an asset needed by Install Base Mod
OKL_TXL_QTE_LINES_ALL_B 59 Termination, restructure or repurchase quote lines
OKL_TXL_QUOTE_LINES_TL 10 Translatable columns from OKL_TXL_QUOTE_LINES_B, per MLS standards
OKL_TXL_RCPT_APPS_ALL_B 38 Apply cash to various OKL objects
OKL_TXL_RCPT_APPS_TL 10 Translatable columns from OKL_TXL_RCPT_APPS_B, per MLS standards
OKL_UPG_TRNS_ACC_DSTRS_T 2 This table is used for the upgrade of the identifier column of the okl_trns_acc_dstrs table. It stores the old and new identifiers.
OKL_UPG_TRX_CONTRACTS_T 2 This table is used for the upgrade of the identifier column of the okl_trx_contracts table. It stores the old and new identifiers.
OKL_UPG_TXL_CNTRCT_LNS_T 2 This table is used for the upgrade of the identifier column of the okl_txl_cntrct_lns table. It stores the old and new identifiers.
OKL_VALIDATIONSETS_ALL_B 27 Header table for Validation Sets
OKL_VALIDATIONS_B 26 Stores the validation lines for Validation Set
OKL_VALIDATIONS_TL 12 Translateable table for Validation Lines
OKL_VALIDATION_RESULTS_B 27 Stores the result of Validation performed on different objects
OKL_VALIDATION_RESULTS_TL 10 Translateable table for Validation Results
OKL_VALIDATION_SETS_TL 12 Translateable table for Validation Sets header table
OKL_VAR_INT_PARAMS_ALL 42 Variable Rate parameters table
OKL_VAR_INT_PROCESS_B 33 Variable Interest Rate Process
OKL_VAR_PRINCIPAL_BAL_TXN 32 Variable Rate - Transactions effecting principal balance
OKL_VP_ASSOCIATIONS 35 This table stores information about relation between contract, vendor program and change request.
OKL_VP_CHANGE_REQUESTS 37 Change request table for Vendor Agreements
OKL_VP_CR_REASONS 31 Change request reasons for Vendor Agreement change requests
OKL_XLA_ACC_DATA_GT 33
OKL_XLA_ENT_TCN_MAP_GT 2
OKL_XLA_EVE_HDR_TRX_MAP_GT 5
OKL_XLA_EVE_TAD_MAP_T 2 This table as part of data migration for SLA Uptake
OKL_XMLP_PARAMS 27 Internal table holding record identifiers to pass to xml API
OKL_XTD_SELL_INVS_B 34 Accounting distributions for the transaction
OKL_XTD_SELL_INVS_TL 9 Translatable columns from OKL_XTD_SELL_INVS_B, per MLS standards
OKL_XTL_CSH_APPS_ALL_B 40 Receipt application specyfing amount applied to Receivables invoices
OKL_XTL_CSH_APPS_TL 9 Translatable columns from OKL_XTL_CSH_APPS_B, per MLS standards
OKL_XTL_PAY_INVS_ALL_B 40 Stores information used to create invoice distributions
OKL_XTL_PAY_INVS_TL 11 Translatable columns from OKL_XTL_PAY_INVS_B, per MLS standards
OKL_XTL_SELL_INVS_B 42 The transaction table for "bill" type transactions, where cash receipts are expected
OKL_XTL_SELL_INVS_TL 14 Translatable columns from OKL_XTL_SELL_INVS_B, per MLS standards