This appendix covers the following topics:
The following table shows seeded Lease and Finance 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 |
| Interim Rent or Interim Interest | ALL | System | Single | No | Taxable = Yes Billable = Yes Capitalize = No |
Dependent | Rent/Loan Payment |
| Interim Fee Payment | ALL | System | Multiple | No | Taxable = Yes Billable = Yes Capitalize = No |
Dependent | Fee Payment |
| Interim Service Payment | ALL | System | Multiple | No | Taxable = Yes Billable = Yes Capitalize = No |
Dependent | Service 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 Financed Service Obligation 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 Financed Service Obligation | 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 | |
| Strip 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 following table lists formulas that are part of the Oracle Lease and Finance 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_Cap_Amnt_Assets | Capital amount excludes financed service assets. This is used for booking accounting for Operating leases. | Derive the capital amount of a contract excluding the financed service assets. | - |
| 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 |
| Financed_Service_Principal | Principal balance for financed serviced assets. This is used for booking accounting for leases. | Derive the capital amount of a contract for financed service assets only. | - |
| Contract_Cap_Amnt_Assets | Capital amount excludes financed service assets. This is used for booking accounting for Operating leases. | Derive the capital amount of a contract excluding the financed service assets. | - |
| Quote_Serv_Unbilled_Prin | Derive unbilled receivables for lease and principal balance for loan financed service asset. | Sum of unbilled rents for lease and principal balance for loan of financed service asset. | - |
| Quote_Termination | The operands included determine the elements to be computed for the termination quote. | Added AMFSOC operand to the string. This add financed service obligation to the termination quote. | - |
| Fair_Value_Assets | Formula to calculate Asset Comparison Amount | Added new operands: OP_ASSET_FEES CAPITALIZED OP_ASSET_OEC | - |
The following table lists workflows that are part of the Oracle Lease and Finance 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:
|
| OKL Stream Generation - Inbound | OKLSTIN.wft | Authoring | Workflow to start an in-bound transaction coming from Pricing Engine for Streams Generation. Steps:
|
| 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. |