Oracle Lease and Finance Management Implementation Guide Release 12.1 Part Number E13577-05 | ![]() Contents | ![]() Previous | ![]() Next |
This appendix covers the following topics:
The following table shows seeded Lease Management stream purposes and contains columns for:
Type - indicates the types of templates in which the Purpose can be used by book class.
ALL means the Purpose can be used in all stream generation templates with a product type of Financial Product.
LS means the Purpose can be used in stream generation templates with a product type of Financial Product and Book Class of Operating Lease, Direct Financial Lease, or Sales Type Lease.
LN means the Purpose can be used in stream generation templates with a product type of Financial Product and Book Class of Loan or Loan-Revolving.
INV means the Purpose can be used in stream generation templates with a product type of Investor Product.
Used By- User indicates the stream purpose is selected by the user during booking or other processes. System indicates the stream purpose is used by the system without being selected by the user.
Single or Multiple - Single means only one stream type with this purpose can be added to the stream generation template. Multiple means one or more stream types with this purpose can be added to the stream generation template.
Mandatory- indicates if the stream Purpose is mandatory on the type of stream generation template used.
Attributes- indicates whether a stream Purpose is Taxable, Billable, and can Capitalize.
Primary or Dependent- indicates whether a stream purpose is primary or dependent.
Depends On - for dependent stream purposes only, indicates the primary stream purpose to which the stream is dependent.
Purpose Name | Type | Used By | Single or Multiple | Mandatory | Attributes | Primary or Dependent | Depends On |
---|---|---|---|---|---|---|---|
Accounting | ALL, INV | User | Multiple | No | Taxable = No Billable = No Capitalize = No | Primary | |
Accrued Fee Expense | ALL | System | Single for each expense | No | Taxable = No Billable = No Capitalize = No | Dependent | Expense |
Accrued Fee Income | ALL | System | Single for each fee payment type | No | Taxable = No Billable = No Capitalize = No | Dependent | Fee Payment - All Types except Income Fee Payment |
Actual Income Accrual | LN | System | Single | Yes | Taxable = No Billable = No Capitalize = No | Dependent | Rent |
Actual Property Tax | ALL | System | Single | No | Taxable = Both Billable = Yes Capitalize = No | Primary | |
Adjusted Property Tax | ALL | System | Single | No | Taxable = Both Billable = Yes Capitalize = No | Dependent | Actual Property Tax |
Advance Rent | ALL | System | Single for each rent | Yes | Taxable = Yes Billable = Yes Capitalize = No | Dependent | Rent |
Amortized Fee Expense | ALL | System | Single for each expense | No | Taxable = No Billable = No Capitalize = No | Dependent | Expense |
Amortized Fee Income | ALL | System | Single for each fee payment type | No | Taxable = No Billable = No Capitalize = No | Dependent | Income Fee Payment |
Billing Adjustment | ALL | System | Single | Yes | Taxable = No Billable = No Capitalize = No | Primary | |
Book Depreciation | LS | System | Single | No | Taxable = No Billable = No Capitalize = No | Primary | |
Cure | ALL | System | Single | Yes | Taxable = Yes Billable = Yes Capitalize = No | Primary | |
Daily Interest - Interest | LN | System | Single | Yes | Taxable = Both Billable = No Capitalize = No | Dependent | Rent |
Daily Interest - Principal | LN | System | Single | Yes | Taxable = Both Billable = No Capitalize = No | Dependent | Rent |
Down Payment | ALL | User | Multiple | No | Taxable = Both Billable = Yes Capitalize = No | Primary | |
Estimated Property Tax | ALL | User | Multiple | No | Taxable = Both Billable = Yes Capitalize = No | Primary | |
Excess Interest Paid | LN | System | Single | Yes | Taxable = Both Billable = Yes Capitalize = No | Dependent | Rent |
Excess Loan Payment Paid | LN | System | Single | Yes | Taxable = Both Billable = Yes Capitalize = No | Dependent | Rent |
Excess Principal Paid | LN | System | Single | Yes | Taxable = Both Billable = Yes Capitalize = No | Dependent | Rent |
Expense | ALL | User | Multiple | No | Taxable = Yes Billable = No Capitalize = Yes, No, or Null | Primary | |
Federal Depreciation | LS | System | Single | No | Taxable = No Billable = No Capitalize = No | Primary | |
Fee Payment | ALL | User | Multiple | No | Taxable = Yes Billable = Yes Capitalize = No | Primary | |
Fee Renewal | LS | System | Single for each fee payment type | No | Taxable = Yes Billable = Yes Capitalize = No | Dependent | Fee Payments - All Types |
Float Factor Adjustment | LS | System | Single | Yes | Taxable = Both Billable = Yes Capitalize = No | Dependent | Rent |
Funding | ALL | User | Multiple | Yes | Taxable = Yes Billable = No Capitalize = No | Primary | |
General Loss Provision | ALL, INV | User | Multiple | No | Taxable = No Billable = No Capitalize = No | Primary | |
Insurance Accrual Adjustment | ALL | System | Single | No | Taxable = No Billable = No Capitalize = No | Primary | |
Insurance Adjustment | ALL | System | Single | No | Taxable = No Billable = No Capitalize = No | Primary | |
Insurance Expense Accrual | ALL | System | Single | No | Taxable = No Billable = No Capitalize = No | Primary | |
Insurance Income Accrual | ALL | System | Single | No | Taxable = No Billable = No Capitalize = No | Primary | |
Insurance Payable | ALL | System | Single | No | Taxable = Yes Billable = No Capitalize = No | Primary | |
Insurance Receivable | ALL | System | Single | No | Taxable = Yes Billable = Yes Capitalize = No | Primary | |
Insurance Refund | ALL | System | Single | No | Taxable = Yes Billable = No Capitalize = No | Primary | |
Interest Catchup | LN | System | Single | Yes | Taxable = Both Billable = Yes Capitalize = No | Dependent | Rent |
Interest Income | LN | System | Single | Yes | Taxable = No Billable = No Capitalize = No | Dependent | Rent, Fee Payment |
Interest Payment | LN | System | Single | Yes | Taxable = Yes Billable = Yes Capitalize = No | Dependent | Rent, Fee Payment |
Investor Contract Obligation Payable | INV | System | Single | Yes | Taxable = No Billable = No Capitalize = No | Primary | |
Investor Disbursement Adjustment | INV | System | Single | Yes | Taxable = No Billable = No Capitalize = No | Primary | |
Investor Evergreen Rent Payable | INV | System | Single | Yes | Taxable = No Billable = No Capitalize = No | Primary | |
Investor Interest Income | LN | System | Single | Yes | Taxable = No Billable = No Capitalize = No | Primary | |
Investor Interest Payable | INV | System | Single | No | Taxable = No Billable = No Capitalize = No | Primary | |
Investor Late Fee Payable | INV | System | Single | Yes | Taxable = No Billable = No Capitalize = No | Primary | |
Investor Late Interest Payable | INV | System | Single | Yes | Taxable = No Billable = No Capitalize = No | Primary | |
Investor Payable | INV | System | Single | Yes | Taxable = No Billable = No Capitalize = No | Primary | |
Investor Pre-tax Income | LS | System | Single | Yes | Taxable = No Billable = No Capitalize = No | Primary | |
Investor Principal Payable | INV | System | Single | Yes | Taxable = No Billable = No Capitalize = No | Primary | |
Investor Receivable | INV | System | Single | Yes | Taxable = Both Billable = Yes Capitalize = No | Primary | |
Investor Rent Buyback | INV | System | Single | Yes | Taxable = No Billable = No Capitalize = No | Primary | |
Investor Rent Disbursement Basis | INV | System | Single | Yes | Taxable = No Billable = No Capitalize = No | Primary | |
Investor Rent Payable | INV | System | Single | Yes | Taxable = No Billable = No Capitalize = No | Primary | |
Investor Rental Accrual | LS | System | Single | Yes | Taxable = No Billable = No Capitalize = No | Primary | |
Investor Residual Buyback | INV | System | Single | Yes | Taxable = No Billable = No Capitalize = No | Primary | |
Investor Residual Disbursement Basis | INV | System | Single | Yes | Taxable = No Billable = No Capitalize = No | Primary | |
Investor Residual Payable | INV | System | Single | Yes | Taxable = No Billable = No Capitalize = No | Primary | |
Investor Variable Interest | LN | System | Single | Yes | Taxable = No Billable = No Capitalize = No | Primary | |
Late Fee | ALL | System | Single | Yes | Taxable = Yes Billable = Yes Capitalize = No | Primary | |
Late Interest | ALL | System | Single | Yes | Taxable = Yes Billable = Yes Capitalize = No | Primary | |
Lease Income | DF, ST | System | Single | Yes | Taxable = No Billable = No Capitalize = No | Dependent | Rent |
Loan Payment | LN | System | Single | Yes | Taxable = No Billable = No Capitalize = No | Dependent | Rent, Fee Payment |
Pass-Through Expense Accrual | ALL | System | Single for each Pass-Through Fee Type | No | Taxable = No Billable = No Capitalize = No | Dependent | Pass-Through Fee |
Pass-Through Fee | ALL | User | No | Taxable = Yes Billable = No Capitalize = No | Primary | ||
Pass-Through Fee Renewal | LS | System | Single for each Pass-Through Fee Type | No | Taxable = Yes Billable = Yes Capitalize = No | Dependent | Pass-Through Fee |
Pass-Through Renewal Rent | LS | System | Single for each Rent | Yes | Taxable = Yes Billable = Yes Capitalize = No | Dependent | Rent |
Pass-Through Revenue Accrual | ALL | System | Single for each Pass-Through Fee Type | No | Taxable = No Billable = No Capitalize = No | Dependent | Pass-Through Fee |
Pass-Through Service | ALL | System | No | Taxable = Yes Billable = No Capitalize = No | Primary | ||
Pass-Through Service Expense Accrual | ALL | System | Single for each Pass-Through Service Payment | No | Taxable = No Billable = No Capitalize = No | Dependent | Service Pass-Through |
Pass-Through Service Renewal | LS | System | Single for each Pass-Through Service Payment | No | Taxable = Yes Billable = Yes Capitalize = No | Dependent | Pass-Through Service |
Pass-Through Service Revenue Accrual | ALL | System | Single for each Pass-Through Service Payment | No | Taxable = No Billable = No Capitalize = No | Dependent | Pass-Through Service |
Pre-funding | ALL | User | Multiple | No | Taxable = Yes Billable = No Capitalize = No | Primary | |
Pre-funding Interest Payment | ALL | System | Single | Yes | Taxable = Yes Billable = Yes Capitalize = No | Primary | |
Principal Balance | LN | System | Single | Yes | Taxable = No Billable = No Capitalize = No | Dependent | Rent, Fee Payment |
Principal Catchup | LN | System | Single | Yes | Taxable = Both Billable = Yes Capitalize = No | Dependent | Rent |
Principal Payment | LN | System | Single | Yes | Taxable = Both Billable = Yes Capitalize = No | Dependent | Rent, Fee Payment |
PV Rent | LS | System | Single | Yes | Taxable = No Billable = No Capitalize = No | Dependent | Rent |
PV Rent Securitized | INV | System | Single | Yes | Taxable = No Billable = No Capitalize = No | Primary | |
PV RV | LS | System | Single | Yes | Taxable = No Billable = No Capitalize = No | Dependent | Residual Value |
PV RV Guaranteed | LS | System | Single | Yes | Taxable = No Billable = No Capitalize = No | Dependent | Residual Value |
PV RV Insured | LS | System | Single | Yes | Taxable = No Billable = No Capitalize = No | Dependent | Residual Value |
PV RV Securitized | INV | System | Single | Yes | Taxable = No Billable = No Capitalize = No | Primary | |
PV RV Unguaranteed | LS | System | Single | Yes | Taxable = No Billable = No Capitalize = No | Dependent | Residual Value |
PV RV Uninsured | LS | System | Single | Yes | Taxable = No Billable = No Capitalize = No | Dependent | Residual Value |
Quote Absorbed Fee | System | Single | No | Taxable = Both Billable = Yes Capitalize = No | Primary | ||
Quote Contract Obligation | System | Single | No | Taxable = Both Billable = Yes Capitalize = No | Primary | ||
Quote Contractual Fee | System | Single | No | Taxable = Both Billable = Yes Capitalize = No | Primary | ||
Quote Discount | System | Single | No | Taxable = Both Billable = Yes Capitalize = No | Primary | ||
Quote Estimated Billing Adjustment | System | Single | No | Taxable = Both Billable = Yes Capitalize = No | Primary | ||
Quote Estimated Property Tax | System | Single | No | Taxable = Both Billable = Yes Capitalize = No | Primary | ||
Quote Expense Fee | System | Single | No | Taxable = Both Billable = Yes Capitalize = No | Primary | ||
Quote Fee | System | Single | No | Taxable = Both Billable = Yes Capitalize = No | Primary | ||
Quote Financed Fee | System | Single | No | Taxable = Both Billable = Yes Capitalize = No | Primary | ||
Quote General Fee | System | Single | No | Taxable = Both Billable = Yes Capitalize = No | Primary | ||
Quote Income Fee | System | Single | No | Taxable = Both Billable = Yes Capitalize = No | Primary | ||
Quote Miscellaneous | System | Single | No | Taxable = Both Billable = Yes Capitalize = No | Primary | ||
Quote Miscellaneous Fee | System | Single | No | Taxable = Both Billable = Yes Capitalize = No | Primary | ||
Quote Pass-Through Fee | System | Single | No | Taxable = Both Billable = Yes Capitalize = No | Primary | ||
Quote Per Diem | LN, LS | System | Single | Yes | Taxable = Both Billable = Yes Capitalize = No | Primary | |
Quote Principal Balance | System | Single | No | Taxable = Both Billable = Yes Capitalize = No | Primary | ||
Quote Purchase Amount | System | Single | No | Taxable = Both Billable = Yes Capitalize = No | Primary | ||
Quote Repurchase Sale Price | ALL | System | Single | No | Taxable = Both Billable = Yes Capitalize = No | Primary | |
Quote Return Fee | System | Single | No | Taxable = Both Billable = Yes Capitalize = No | Primary | ||
Quote Rollover Incentive | System | Single | No | Taxable = Both Billable = Yes Capitalize = No | Primary | ||
Quote Service and Maintenance | System | Single | No | Taxable = Both Billable = Yes Capitalize = No | Primary | ||
Quote Termination Penalty | System | Single | No | Taxable = Both Billable = Yes Capitalize = No | Primary | ||
Quote Unbilled Receivables | System | Single | No | Taxable = Both Billable = Yes Capitalize = No | Primary | ||
Renewal Property Tax | LS | System | Single for each Estimated Property Tax | No | Taxable = Yes Billable = Yes Capitalize = No | Dependent | Estimated Property Tax |
Renewal Rent | LS | System | Single for each Rent | Yes | Taxable = Yes Billable = Yes Capitalize = No | Dependent | Rent |
Rent | ALL | User | Single | Yes | Taxable = Yes Billable = Yes Capitalize = No | Primary | |
Rent Accrual | OP | System | Single for each Rent | Yes | Taxable = No Billable = No Capitalize = No | Dependent | Rent |
Repair Charge | ALL | System | Single | Yes | Taxable = Yes Billable = Yes Capitalize = No | Primary | |
Residual Guaranteed | LS | System | Single | Yes | Taxable = No Billable = No Capitalize = No | Dependent | Residual Value |
Residual Value | LS | System | Single | Yes | Taxable = No Billable = Yes Capitalize = No | Primary | |
Residual Value Insurance Premium | LS | System | Single | Yes | Taxable = No Billable = No Capitalize = No | Dependent | Residual Value |
Security Deposit | ALL | User | Multiple | No | Taxable = Yes Billable = Yes Capitalize = No | Primary | |
Service Expense | ALL | System | Multiple | No | Taxable = No Billable = No Capitalize = No | Primary | |
Service Fee - Amortization Schedule | ALL | System | Single | Yes | Taxable = Yes Billable = Yes Capitalize = No | Primary | |
Service Fee - Audit Letter | ALL | System | Single | Yes | Taxable = Yes Billable = Yes Capitalize = No | Primary | |
Service Fee - Document Request | ALL | System | Single | Yes | Taxable = Yes Billable = Yes Capitalize = No | Primary | |
Service Fee - Exchange Request | ALL | System | Single | Yes | Taxable = Yes Billable = Yes Capitalize = No | Primary | |
Service Fee - General | ALL | System | Single | Yes | Taxable = Yes Billable = Yes Capitalize = No | Primary | |
Service Fee - Interest Conversion | ALL | System | Single | Yes | Taxable = Yes Billable = Yes Capitalize = No | Primary | |
Service Fee - Invoice On Demand | ALL | System | Single | Yes | Taxable = Yes Billable = Yes Capitalize = No | Primary | |
Service Fee - Invoice Reprint | ALL | System | Single | Yes | Taxable = Yes Billable = Yes Capitalize = No | Primary | |
Service Fee - Payment Change | ALL | System | Single | Yes | Taxable = Yes Billable = Yes Capitalize = No | Primary | |
Service Fee - Restructure Request | ALL | System | Single | Yes | Taxable = Yes Billable = Yes Capitalize = No | Primary | |
Service Fee - Termination Request | ALL | System | Single | Yes | Taxable = Yes Billable = Yes Capitalize = No | Primary | |
Service Fee - Transfer Request | ALL | System | Single | Yes | Taxable = Yes Billable = Yes Capitalize = No | Primary | |
Service Fee - Variable Rate Statement | ALL | System | Single | Yes | Taxable = Yes Billable = Yes Capitalize = No | Primary | |
Service Fee - VAT Schedule | ALL | System | Single | Yes | Taxable = Yes Billable = Yes Capitalize = No | Primary | |
Service Income | ALL | System | Single for each Service Payment | No | Taxable = No Billable = No Capitalize = No | Dependent | Service Payment |
Service Payment | ALL | User | Multiple | No | Taxable = Yes Billable = Yes Capitalize = No | Primary | |
Service Renewal | ALL | System | Single for each Service Payment | No | Taxable = Yes Billable = Yes Capitalize = No | Dependent | Service Payment |
Specific Loss Provision | ALL, INV | User | Multiple | No | Taxable = No Billable = No Capitalize = No | Primary | |
State Depreciation | LS | System | Single | No | Taxable = No Billable = No Capitalize = No | Primary | |
Stip Loss Value | LS | System | Single | No | Taxable = No Billable = No Capitalize = No | Dependent | Rent |
Subsidy | ALL | User | Multiple | No | Taxable = Yes Billable = Yes Capitalize = No | Primary | |
Subsidy Income | ALL | System | Single for each Subsidy | No | Taxable = No Billable = No Capitalize = No | Dependent | Subsidy |
Termination Value | LS | System | Single | No | Taxable = No Billable = No Capitalize = No | Dependent | Rent |
Unscheduled Loan Payment | LN | System | Single | Yes | Taxable = Both Billable = Yes Capitalize = No | Dependent | Rent |
Unscheduled Principal Payment | LN | System | Single | Yes | Taxable = Both Billable = Yes Capitalize = No | Dependent | Rent |
Usage Payment | ALL | System | Single | No | Taxable = Yes Billable = Yes Capitalize = No | Primary | |
Variable Income Non-Accrual | LN | System | Single | Yes | Taxable = No Billable = No Capitalize = No | Dependent | Variable Interest |
Variable Interest | LN | User | Single | Yes | Taxable = Yes Billable = Yes Capitalize = No | Primary | |
Variable Interest Income | LN | System | Single | Yes | Taxable = No Billable = No Capitalize = No | Dependent | Variable Interest |
Variable Interest Schedule | LN | System | Single | No | Taxable = No Billable = No Capitalize = No | Primary | |
Variable Loan Payment | LN | System | Single | Yes | Taxable = Both Billable = Yes Capitalize = No | Dependent | Rent |
Vendor Residual Sharing | LS | User | Single | No | Taxable = Yes Billable = No Capitalize = No | Primary |
The Oracle Contracts rules architecture is part of the Oracle Contracts Core contract structure and works in combination with the contract header and lines. Rules are a structured presentation of contract terms and conditions. How the data relate to the contract determines whether the data are captured as a rule or in the header-line structure. In general, rules govern the operation or procedures and processes performed on contract headers, lines, or sub-lines.
For example, a rule can specify a number of days that should elapse between transaction events for a contract. This rule is checked by the process against the first transaction date before picking up the contract and processing it for the second transaction.
Rules comprise four basic components:
Rule definition
Rule group definition
Rule values
Rule group values
Once defined, the rule and rule group definitions are referenced when the rule and rule group values are assigned in the rule tables (OKC_RULES_B and OKC_RULE_GROUPS_B) that correspond to a contract, contract line, or sub-line.
A variety of sources can assign the rule and rule group values, including:
Master Lease Agreement
Vendor Agreements (Operating Agreements and Program Agreements)
Product
Contract Interface
Profile Options
The following table lists all the seeded rules in Oracle Lease Management.
Rule Group | Rule Group Meaning | Rule Name | Rule Meaning | Rule Component | Description | Value Set or Source |
---|---|---|---|---|---|---|
AMTFOC | End of Term Purchase Option, Contract | AMTINV | Automat-ically Invoice for Fixed Purchase Option | RULE_INFORMATION1 | Automat-ically Process Fixed Purchase Option | Y/N |
LABKCL | Book Class | LABKCL | Book Class | RULE_INFORMATION1 | Book Class | FND |
LAEVEL | Evergreen Eligibility | LAEVEL | Evergreen Eligibility | RULE_INFORMATION1 | Eligible for Evergreen | Y/N |
LAFCTG | Factoring | LAFCTG | Factoring | RULE_INFORMATION1 | Factoring Date | Date Value |
LAFCTG | Factoring | LAFCTG | Factoring | RULE_INFORMATION2 | Factoring Percentage | Entered Value |
LAFCTG | Factoring | LAFCTG | Factoring | RULE_INFORMATION3 | Factoring Discount Rate | Entered Value |
LARNOP | Renewal Option | LAREND | Renewal Notice Days | RULE_INFORMATION1 | Renewal notice days | Entered Value |
LARNOP | Renewal Option | LARNEW | Renewal Options | RULE_INFORMATION1 | Renewal option | FND |
LARNOP | Renewal Option | LARNEW | Renewal Options | RULE_INFORMATION2 | Renewal amount | Entered Value |
LASDEP | Security Deposit | LASDEP | Security Deposit | RULE_INFORMATION2 | Sec Dep Held until maturity | Y/N |
LASDEP | Security Deposit | LASDEP | Security Deposit | RULE_INFORMATION4 | Net Sec Dep from Sale proceeds | Y/N |
LASDEP | Security Deposit | LASDEP | Security Deposit | RULE_INFORMATION5 | Sec Dep Held until date | Date Value |
LATROP | Termination Options | LAEOTR | End of Term Options | RULE_INFORMATION1 | End of term option | FND |
LATROP | Termination Options | LAEOTR | End of Term Options | RULE_INFORMATION2 | End of Term Amount | Entered Value |
LATROP | Termination Options | LAMITR | Mid Term Options | RULE_INFORMATION1 | Mid Term Option | FND |
LATROP | Termination Options | LAMITR | Mid Term Options | RULE_INFORMATION2 | Mid Term Amount | Entered Value |
LATOWN | Tax Owner | LATOWN | Tax Owner | RULE_INFORMATION1 | Tax Owner (for deal) | FND |
The following table lists formulas that are part of the Oracle Lease Management seed data:
Formula Name | Description | Calculation | Parameters |
---|---|---|---|
LINE_OEC | Calculates the OEC | Price per unit * no of units | Contract id (mandatory) + Line id (optional) |
CONTRACT_SUMOF_RENTS | Sum of rents | Sum of amounts on stream type - Rent. Use this formula on the booking transaction type template. | ? |
CONT_RBK_UNBILL_RECEIVABLES | Sum of unbilled rents | Sum of rent not billed for all active assets on a lease contract. Use this formula on the rebook transaction type. The amount calculation for this formula and the CONTRACT_SUMOF_RENTS formula together gives the correct accounting amounts for the rebook transactions. | ? |
LINE_RESIDUAL_VALUE | Calculates the RV | Residual Value per unit | Contract id (mandatory) + Line id (mandatory) |
CONTRACT_RESIDUAL_VALUE | Calculates the RV | Residual Value for the contract | Contract id (mandatory) |
CONTRACT_OEC | Contract Capitalized Amount | Sum of capitalized amount of all asset lines | Contract id (mandatory) |
CONTRACT_TRADEIN | Sum of Trade Ins | Sum of all trade ins from financial asset lines | Contract id (mandatory) |
LINE_TRADEIN | Trade in amount for a line | Trade in amount for the asset line | Contract id (mandatory) + Line id (mandatory) |
CONTRACT_CAPREDUCTION | Sum of Capital Reduction | Sum of capital reduction of all asset lines | Contract id (mandatory) |
LINE_CAPREDUCTION | Capital Reduction of a line | Capital reduction amount for the asset line | Contract id (mandatory) + Line id (mandatory) |
CONTRACT_FEESCAPITALIZED | Sum of Capitalized Fees | Sum of capitalized fees lines | Contract id (mandatory) |
LINE_FEESCAPITALIZED | Capitalized Fees for line | Capitalized fees for the asset line | Contract id (mandatory) + Line id (mandatory) |
CONTRACT_CAP_AMNT | Total financed amount | OEC-Trade in - Cap Reduction + Cap Fees | Contract id (mandatory) |
LINE_CAP_AMNT | Financed amount for line | OEC-Trade in - Cap Reduction + Cap Fees | Contract id (mandatory) + Line id (mandatory) |
CONTRACT_AMNT_PREFNDED | Amount pre-funded | Sum of all approved requests for specific contract where type = prefunding | Contract id (mandatory) |
CONTRACT_TOT_FNDED | Total funded amount | Sum of all approved requests for specific contract | Contract id (mandatory) |
CONTRACT_TOT_DEBITS | Total negative fundings | Sum of all approved requests for specific contract where amount is negative (A/P debits) | Contract id (mandatory) |
CONTRACT_TOT_CRDT_LMT | Total credit limit | Sum of all credit limit (contract line) for specific contract entity scs_code = 'CREDITLINE_CONTRACT | 'Contract id (mandatory) |
CONTRACT_CRDT_RMNG | Balance credit limit | Sum of all credit limit (contract line) for specific contract cs_code = 'CREDITLINE_CONTRACT' and subtract from Funding total | Contract id (mandatory) |
CONTRACT_TOT_CRDT_NEW_LMT | New credit limit | Sum of all credit new limit (contract line) for specific contract scs_code = 'CREDITLINE_CONTRACT | Contract id (mandatory) |
CONTRACT_TOT_CRDT_ADDN | Additional credit limit | Sum of all credit addition (contract line) for specific contract scs_code = 'CREDITLINE_CONTRACT | Contract id (mandatory) |
CONTRACT_TOT_CRDT_REDN | Reduction in credit limit | Sum of all credit addition (contract line) for specific contract scs_code = 'CREDITLINE_CONTRACT | Contract id (mandatory) |
AM_UNBILLED_RECEIVABLES | Future Dues for a lease | Sum of unbilled rents (at present value) - advance rent | Contract id (mandatory) |
AMCTOC | Principal Balance for a loan | Principal Balance | Contract id (mandatory) |
AM_DISCOUNT_RATE | Discount Rate | Original Capitalized Cost * (-0.1) | Contract id (mandatory) |
AM_QUOTE_FEE | Quote Fee | Original Capitalized Cost * 0.1 | Contract id (mandatory) |
AM_RETURN_FEE | Return Fee | Original Capitalized Cost * 0.1 | Contract id (mandatory) |
AM_ROLLOVER_INCENTIVE | Rollover Incentive | Original Capitalized Cost * 0.1 | Contract id (mandatory) |
AM_SECURITY_DEPOSIT | Security Deposit refundable | Balance Security Deposit Amount | Contract id (mandatory) |
AM_TERMINATION_PENALTY | Termination Penalty | Original Capitalized Cost * 0.1 | Contract id (mandatory) |
AM_ESTIMATED_PROPERTY_TAX | Estimated Property Tax | Estimated Property Tax | Contract id (mandatory) |
VARIABLE_INCOME_ACCRUAL | Variable Income Amount | Principal * Interest Rate * No of days to accrue / No of days in a year | Contract id (mandatory) |
LP_NET_INVESTMENT_VALUE | Balance investment on contract | Operating Lease - Net Book Value, DF Lease - Net Investment Value and Loan - Principal Balance | Contract id (mandatory) |
CS_ADVANCE_RENT | Advance Rent | Advance Rent | Contract id (mandatory) |
CS_SECURITY_DEPOSIT | Security Deposit | Security Deposit | Contract id (mandatory) |
CS_NET_INVESTMENT | Net Investment | Rent + Residual Value - Unearned Income | Contract id (mandatory) |
NET_GAIN_LOSS_QUOTE | Net Gain/Loss | The net gain loss resulting from a termination quote | N/A |
The following table lists workflows that are part of the Oracle Lease Management seed data:
Workflow Name | File Name | Functional Area | Description |
---|---|---|---|
OKL CS Equipment Exchange. | OKLCSEQU.wft | Lease Center | This work flow is used in equipment exchange to exchange the equipment in the background after getting the necessary approvals. |
OKL CS Transfer Assumption Request | OKLCSTRQ.wft | Lease Center | This work flow is used to carry out a Transfer and Assumption Request after receiving the appropriate approvals. |
OKL CS Billing Correction Request. | OKLCSBCW.wft | Lease Center | This work flow is used for Billing Correction Request to notify an Administrator about any corrections. |
OKL CS Billing Refund Request. | OKLCSBRW.wft | Lease Center | This work flow is used for Billing Refund Request to notify an Administrator about any Refunds. |
OKL CS Convert Interest Type | OKLCSCIT.wft | Lease Center | This work flow is used to notify an Administrator about any changes in the interest types. |
OKL CS Contract Lease Renewal. | OKLCSKLR.wft | Lease Center | This work flow is used for lease renewals. |
OKL Stream Generation - Outbound | OKLSTOUT.wft | Authoring | Workflow to start an out-bound transaction with Pricing Engine for Streams Generation. Steps: 1. Receive raised Business Event to send out bound xml message. 2. Call ECX api to check for validity of the generated document. 3. Report Error if applicable. 4. Call ECX API to send the document. |
OKL Stream Generation - Inbound | OKLSTIN.wft | Authoring | Workflow to start an in-bound transaction coming from Pricing Engine for Streams Generation. Steps: 1. Capture the business event for Inbound xml message. 2. Process Stream Results. |
OKL - IN Gather Third Party Insurance Information | OKLININF.wft | Authoring | To gather third-party information when customer fails to provide insurance proof, and the lessor cannot sell insurance. |
Lease Account Generator | OKLFLXWF.wft | Accounting | You can use this workflow to generate account combinations instead of the seeded sources. |
Approve Contract Portfolio | OKLAMATK.wft | Asset Management | This workflow routes the contract portfolio for approval. |
Notify Contract Portfolio Execution | OKLAMCPE.wft | Asset Management | This workflow notifies the remarketer for the contract portfolio execution. |
Approve Restructure | OKLAMRQT.wft | Asset Management | This workflow routes the restructure for approval. |
Approve Gain / Loss | OKLAMGAL.wft | Asset Management | This workflow routes the gain / loss on termination for approval. |
Approve Partial Quote | OKLAMPAR.wft | Asset Management | This workflow routes partial quotes for approval. |
Shipping Instructions | OKLAMNSI.wft | Asset Management | This workflow is used to inform the shipping details for an asset. |
Notify Internal Transport Department | OKLAMNTD.wft | Asset Management | This workflow is used to inform the internal transport department the shipping details for an asset. |
Send Quote | OKLAMNQT.wft | Asset Management | This workflow is used to send a quote. |
Repurchase Acceptance | OKLAMRAC.wft | Asset Management | This workflow informs user(s) of the acceptance of a repurchase quote. |
Termination Quote Acceptance | OKLAMPPT.wft | Asset Management | This workflow informs user(s) of the acceptance of a termination quote. |
Restructure Quote Acceptance | OKLAMRQT.wft | Asset Management | This workflow informs user(s) of the acceptance of a restructure quote. |
Notify Remarketer | OKLAMNRM.wft | Asset Management | This workflow informs the remarketing team of a new asset assignment |
Notify Collections | OKLAMNCO.wft | Asset Management | This workflow informs the collections agent of updates on returns in the case of a repossession. |
Notify Repossession Agent | OKLAMNRA.wft | Asset Management | This workflow informs the external repossession agent of a new repossession request. |
Notify Provider | OKLAMNPR.wft | Asset Management | This workflow informs the provider of service and/or maintenance of the asset return. |
Asset Repair | OKLAMAAR.wft | Asset Management | This workflow routes asset repair requests for approval. |
Request Title Return | OKLAMRTR.wft | Asset Management | This workflow requests the 3rd party title holder to return the title on the expiration of the contract. |
Remarketing Order Cycle | OKLAMROM.wft | Asset Management | This workflow defines the order cycle in Order Management for remarketed assets. |
Credit Application Request | OKLSOCAR.wft | Sales and Origination | Notifies the Lease Credit Analyst of credit request recommendations from Oracle Credit Management. |
Copyright © 2002, 2010, Oracle and/or its affiliates. All rights reserved.