| LeasePak 6.2a Database Reference | Print Version| Help| Search| DocSuite | Document Top |  |
| rap Table: Application (Oracle) | |||
| Columns Indexes sp1 Child sp2 rapa rapd raph rapp rapr raps | |||
| LeasePak 6.2a Database Reference | Print Version| Help| Search| DocSuite | Document Top | |
| rap Table: Application (Oracle) | |||
| Columns Indexes sp1 Child sp2 rapa rapd raph rapp rapr raps | |||
Oracle DBMS
Specifies the columns and rows with Oracle data type information for the rap Application table.
Parent-Child:
This table has one or more child tables--click here for a listing.
| Description | Column Name | Data Type ? | Characteristics ? |
|---|---|---|---|
| Portfolio | por_s | CHAR(2) | |
| Company | com_s | CHAR(2) | |
| Region | reg_s | CHAR(2) | |
| Office | off_s | CHAR(3) | |
| Application | app_s | CHAR(10) | |
| Record modification stamp | stamp_l | NUMBER(10) | |
| Vendor | dlr_s | CHAR(9) | |
| Broker | brk_s | CHAR(9) | |
| Investor | inv_s | CHAR(9) | |
| Lessee number | les_s | CHAR(9) | |
| Lease | lse_s | CHAR(10) | |
| Lease date | d_lsd_s | DATE | |
| Lease commencement date | d_com_s | DATE | |
| Disbursement date | d_dis_s | DATE | |
| Maturity date | d_mat_s | DATE | |
| Custom date 1 | d_cus1_s | DATE | |
| Document sent date | d_doc_sent_s | DATE | |
| Approval expiration date | d_exp_s | DATE | |
| Documentation completion date | d_doc_comp_s | DATE | |
| Line of credit start date Date the line of credit was created. This field is part of the drawdown enhancement module. It only has values if the portfolio for this application has drawdown tracking turned on (rpa.drawdown_tracking_c = 'Y') AND the application is a normal or a master application. (i.e. norm_mas_sub_c = 'N' or norm_mas_sub_c = 'M') | d_start_s | DATE | |
| Original line of credit expiration date This field is part of the drawdown enhancement module. It only has values if the portfolio for this application has drawdown tracking turned on (rpa.drawdown_tracking_c = 'Y') AND the application is a normal or a master application. (i.e. norm_mas_sub_c = 'N' or norm_mas_sub_c = 'M') | d_orig_exp_s | DATE | |
| Current line of credit expiration date This field is part of the drawdown enhancement module. It only has values if the portfolio for this application has drawdown tracking turned on (rpa.drawdown_tracking_c = 'Y') AND the application is a normal or a master application. (i.e. norm_mas_sub_c = 'N' or norm_mas_sub_c = 'M') | d_curr_exp_s | DATE | |
| Accrual method lessor | acc_l_s | CHAR(4) | |
| Accrual method vendor | acc_d_s | CHAR(4) | |
| Accrual method investor | acc_i_s | CHAR(4) | |
| Lease source | dir_s | CHAR(4) | |
| Lease form code | frm_s | CHAR(4) | |
| Delinquency watch code | del_s | CHAR(4) | |
| Broker payment code | brk_pay_s | CHAR(4) | |
| Late charge assess | late_s | CHAR(4) | |
| Lease type code | ls_typ_s | CHAR(4) | |
| Custom code 1 | c_cus1_s | CHAR(4) | |
| Custom code 2 | c_cus2_s | CHAR(4) | |
| Custom code 3 | c_cus3_s | CHAR(4) | |
| Purchase option billing method | po_meth_s | CHAR(4) | |
| Purchase option | pur_opt_s | CHAR(4) | |
| Reasons/conditions [1] | dec1_s | CHAR(4) | |
| Reasons/conditions [2] | dec2_s | CHAR(4) | |
| Reasons/conditions [3] | dec3_s | CHAR(4) | |
| Reasons/conditions [4] | dec4_s | CHAR(4) | |
| Reasons/conditions [5] | dec5_s | CHAR(4) | |
| Reasons/conditions [6] | dec6_s | CHAR(4) | |
| Purchase option owner | pur_opt_owner_s | CHAR(4) | |
| Market code | mkt_s | CHAR(4) | |
| Account code | acc_code_s | CHAR(4) | |
| Application type | typ_s | CHAR(4) | |
| Rate plan | rp_s | CHAR(4) | |
| Upfront sales tax code | stax_cd_s | CHAR(4) | |
| Documentation type code | doc_cd_s | CHAR(4) | |
| Prime rate bank number | prim_num_s | CHAR(4) | |
| Late charge index | lat_ind_s | CHAR(4) | |
| IDC accounting method | idc_acct_s | CHAR(4) | |
| Product type code | prd_s | CHAR(4) | |
| CCA accrual method | cca_acc_s | CHAR(4) | |
| Business/personal (B/P) | bus_c | CHAR(1) | |
| Type of lease, open or closed (O/C) | opn_c | CHAR(1) | |
| Assumed payment (Y/N) | a_pmt_c | CHAR(1) | |
| Residual income separated (Y/N) | res_inc_c | CHAR(1) | |
| Refundable (Y/N) | refund_c | CHAR(1) | |
| Pre-authorize switch (Y/N) | pap_pmt_c | CHAR(1) | |
| Billing level (C/L/I) C - Customer L - Lessee I - Individual | b_lvl_c | CHAR(1) | |
| Funding interest modified by user (Y/N) | stub_amt_mod_c | CHAR(1) | |
| IDC modified by user (Y/N) | idc_mod_c | CHAR(1) | |
| Tax IDC modified by user (Y/N) | idc_tax_mod_c | CHAR(1) | |
| Statement code (I/C/F/N/' ') I - individual invoice format C - coupon books F - group invoice format N - billing method outside of LeasePak | stmt_c | CHAR(1) | |
| Normal/master/sub application (N/M/S) N - Normal M - Master S - Sub (part of Master) | norm_mas_sub_c | CHAR(1) | |
| CCA fixed rate (Y/N) | cca_fix_c | CHAR(1) | |
| Automatic charge off (Y/N/D) Y - Lease will be automatically charged off after delinquent for more than 120 days. N - No automatic charge off. D - Lease will defer charge off for 1 month. | auto_charge_c | CHAR(1) | |
| General description | desc_s | VARCHAR2(36) | |
| Custom string 1 | s_cus1_s | CHAR(10) | |
| Custom string 2 | s_cus2_s | CHAR(10) | |
| Trade-in description | trd_desc_s | VARCHAR2(36) | |
| Vendor contact name | dlr_cont_s | VARCHAR2(36) | |
| Vendor phone number | dlr_phn_s | CHAR(10) | |
| Broker contact name | brk_cont_s | VARCHAR2(36) | |
| Broker phone number | brk_phn_s | CHAR(10) | |
| Lease address name | lse_nam_s | VARCHAR2(36) | |
| Lease address | lse_add_s | VARCHAR2(36) | |
| Lease address 2 | lse_add2_s | VARCHAR2(36) | |
| Lease address city | lse_cty_s | VARCHAR2(25) | |
| Lease address state | lse_st_s | CHAR(2) | |
| Lease address zip code | lse_zip_s | CHAR(9) | |
| Default application | def_appln_s | CHAR(10) | |
| Billing address name | bill_nam_s | VARCHAR2(36) | |
| Billing address | bill_add_s | VARCHAR2(36) | |
| Billing address 2 | bill_add2_s | VARCHAR2(36) | |
| Billing address city | bill_cty_s | VARCHAR2(25) | |
| Billing address state | bill_st_s | CHAR(2) | |
| Billing address zip code | bill_zip_s | CHAR(9) | |
| Group number | grp_s | CHAR(3) | |
| Master application number This field is part of the drawdown enhancement module. It only has values if the portfolio for this application has drawdown tracking turned on (rpa.drawdown_tracking_c = 'Y') AND the application is a sub-application. (i.e. norm_mas_sub_c = 'S') | master_app_s | CHAR(10) | |
| Vendor factor | p_dlr_d | NUMBER(15,5) | |
| Lease term | trm_l | NUMBER(10) | |
| Estimated lease term | est_trm_l | NUMBER(10) | |
| Payment due day | due_l | NUMBER(10) | |
| Grace period in days | grc_l | NUMBER(10) | |
| Lessor yield | p_con_d | NUMBER(15,7) | |
| Vendor yield | p_dly_d | NUMBER(15,7) | |
| Investor yield factor | p_inv_yld_d | NUMBER(15,7) | |
| Cost of funds | p_fund_d | NUMBER(15,5) | |
| NPV discount rate | p_erly_pay_d | NUMBER(15,5) | |
| IRR (yield) | p_irr_d | NUMBER(15,7) | |
| IRR (yield) without residual | p_irr_nr_d | NUMBER(15,7) | |
| Bad debt percentage | bad_debt_d | NUMBER(15,5) | |
| Custom integer 1 | i_cus1_l | NUMBER(10) | |
| Custom integer 2 | i_cus2_l | NUMBER(10) | |
| Lease factor | factor_d | NUMBER(15,7) | |
| Residual percentage If entered by the user, tot_res_d is also calculated and stored. | p_res_d | NUMBER(15,5) | |
| Lessor rental simple rate | p_rent_d | NUMBER(15,5) | |
| Lessor rental rate add-on | p_byrt_d | NUMBER(15,5) | |
| Contract rental rate add-on | p_cntr_d | NUMBER(15,5) | |
| Investor rental simple rate | p_rent_i_d | NUMBER(15,5) | |
| Investor rental rate add-on | p_inv_d | NUMBER(15,5) | |
| Vendor rental simple rate | p_rent_d_d | NUMBER(15,5) | |
| Rate of participation | p_part_d | NUMBER(15,5) | |
| Maximum interest rate - lease level | p_max_d | NUMBER(15,5) | |
| Minimum interest rate - lease level | p_min_d | NUMBER(15,5) | |
| Total acquisition cost | tot_org_d | NUMBER(15,2) | |
| Other charges | tot_other_d | NUMBER(15,2) | |
| Security deposit | sec_d | NUMBER(15,2) | |
| Down payment | cap_d | NUMBER(15,2) | |
| Documentation fee | up_d | NUMBER(15,2) | |
| Interim rent | pro_d | NUMBER(15,2) | |
| Broker fees | brk_fee_d | NUMBER(15,2) | |
| Total initial direct costs | idc_d | NUMBER(15,2) | |
| Residual amount If tot_res_d is entered by the user, the value of p_res_d is erased. | tot_res_d | NUMBER(15,2) | |
| Guaranteed portion of residual | res_guar_d | NUMBER(15,2) | |
| Mark up | mrk_up_d | NUMBER(15,2) | |
| In-house fee | in_fee_d | NUMBER(15,2) | |
| Funding interest owed (-) or earned (+) | stub_fund_amt_d | NUMBER(15,2) | |
| NPV of payment stream | npv_d | NUMBER(15,2) | |
| Titling tax paid up-front | tax_paid_d | NUMBER(15,2) | |
| Custom float 1 | f_cus1_d | NUMBER(15,2) | |
| Custom float 2 | f_cus2_d | NUMBER(15,2) | |
| Custom float 3 | f_cus3_d | NUMBER(15,2) | |
| Custom float 4 | f_cus4_d | NUMBER(15,2) | |
| Custom float 5 | f_cus5_d | NUMBER(15,2) | |
| Fixed price purchase | fp_amt_d | NUMBER(15,2) | |
| Compensation amount | comm_d | NUMBER(15,2) | |
| Upfront sales tax on cost | stax_d | NUMBER(15,2) | |
| Trade-in | trade_in_d | NUMBER(15,2) | |
| Advanced money received | adv_rec_d | NUMBER(15,2) | |
| Tax IDC | idc_tax_d | NUMBER(15,2) | |
| Acquisition cost at approval for field security tolerance | apprv_org_d | NUMBER(15,2) | |
| Down payment at approval for field security tolerance | apprv_cap_d | NUMBER(15,2) | |
| Documentation fee at approval for field security tolerance | apprv_up_d | NUMBER(15,2) | |
| Residual amount at approval for field security tolerance | apprv_res_d | NUMBER(15,2) | |
| Payment amount at approval for field security tolerance regular payment schedules only | apprv_pmt_d | NUMBER(15,2) | |
| Security deposit at approval for field security tolerance | apprv_sec_d | NUMBER(15,2) | |
| Drawdown amount at application approval/book | drawdown_amt_d | NUMBER(15,2) | |
| Credit limit amount This field is part of the drawdown enhancement module. It only has values if the portfolio for this application has drawdown tracking turned on (rpa.drawdown_tracking_c = 'Y') AND the application is a normal or a master application. (i.e. norm_mas_sub_c = 'N' or norm_mas_sub_c = 'M') | credit_lim_d | NUMBER(15,2) | |
| Credit balance amount This field is part of the drawdown enhancement module. It only has values if the portfolio for this application has drawdown tracking turned on (rpa.drawdown_tracking_c = 'Y') AND the application is a normal or a master application. (i.e. norm_mas_sub_c = 'N' or norm_mas_sub_c = 'M') | credit_bal_d | NUMBER(15,2) | |
| Payment frequency code (regular payment schedules) | pmt_cd_reg_s | CHAR(4) | |
| Payment amount (regular payment schedules) | pmt_amt_reg_d | NUMBER(15,2) | |
| Advanced payments begin | adv_beg_l | NUMBER(10) | |
| Advanced payments end | adv_end_l | NUMBER(10) | |
| Capitalize IBL interest (Y/N/' ') | capitalize_interest_c | CHAR(1) | |
| Insurance premium cost | ins_prem_cost_d | NUMBER(15,2) | |
| Notary fee payable to | notary_fee_pay_to_s | CHAR(9) | |
| Insurance premium payable to | ins_prem_pay_to_s | CHAR(9) | |
| Insurance fee income | ins_fee_incm_d | NUMBER(15,2) | |
| Notary fee cost | notary_fee_cost_d | NUMBER(15,2) | |
| Registration fee income | reg_fee_incm_d | NUMBER(15,2) | |
| Dealer subsidy income | dlr_subsidy_incm_d | NUMBER(15,2) | |
| Open commission income | open_comm_incm_d | NUMBER(15,2) | |
| Last status history date | d_his_s | DATE | |
| Last status history time | t_his_s | CHAR(6) | |
| Last status history status code | his_stat_s | CHAR(4) | |
| Last status history owner | his_owner_s | CHAR(3) | |
| Last status history transfered by (initials) | his_xfer_s | CHAR(3) | |
| Date entered | d_ent_s | DATE | |
| Time entered (HHMMSS) | t_ent_s | CHAR(6) | |
| Change lease key is in progress | msi_chg_key_c | CHAR(1) | |
| Fixed rate reserves IDC3 | idc3_d | NUMBER(15,2) | |
| Standard reserves IDC4 | idc4_d | NUMBER(15,2) | |
| Guaranteed reserves IDC5 | idc5_d | NUMBER(15,2) | |
| Subvention IDR5 | idr5_d | NUMBER(15,2) | |
| Dealer buy down ID6 | idr6_d | NUMBER(15,2) | |
| Credit life insurance 1 IDR7 | idr7_d | NUMBER(15,2) | |
| Credit life insurance 2 IDR8 | idr8_d | NUMBER(15,2) | |
| Credit disability insurance 1 IDR9 | idr9_d | NUMBER(15,2) | |
| Credit disability insurance 2 IDRA | idra_d | NUMBER(15,2) | |
| Acquisition fee IDRB | idrb_d | NUMBER(15,2) | |
| Warranty insurance IDRC | idrc_d | NUMBER(15,2) | |
| Excess MSRP | x_msrp_d | NUMBER(15,2) | |
| Estimated unearned | l_est_ue_d | NUMBER(15,2) | |
| Informational down payment amount | inf_dwn_pmt_d | NUMBER(15,2) | |
| Trade-in make | trade_in_make_s | CHAR(15) | |
| Trade-in model | trade_in_model_s | CHAR(15) | |
| Trade-in year | trade_in_year_l | NUMBER(10) | |
| Trade-in gross allowance | trade_in_gross_allow_d | NUMBER(15,2) | |
| Trade-in outstanding debt | trade_in_outst_debt_d | NUMBER(15,2) | |
| Trade-in net allowance | trade_in_net_allow_d | NUMBER(15,2) | |
| Trade-in cash down | trade_in_cash_dwn_d | NUMBER(15,2) | |
| Down payment tax | dwn_pmt_tax_d | NUMBER(15,2) | |
| Dealer recourse | rec_s | CHAR(4) | |
| Credit quality | cred_quality_s | CHAR(4) | |
| Optional insurance | opt_ins_s | CHAR(4) | |
| Account type (P/L/I) P - Prestige Buyer L - Lease I - Retail Installment | acct_type_c | CHAR(1) | |
| Purchase option fee | purch_option_fee_d | NUMBER(15,2) | |
| Transfer of equity (Y/N) | tran_eqty_c | CHAR(1) | |
| Cost of funds 2 (For FCT) | p_fund2_d | NUMBER(15,5) | |
| Dealer reserves SL depreciation basis | idc_depr_l | NUMBER(10) | |
| Acquisition fee SL depreciation basis | idrb_depr_l | NUMBER(10) | |
| Original credit limit | orig_credit_lim_d | NUMBER(15,2) | |
| Check number | chk_num_s | CHAR(10) | |
| Revolving credit limit | revolving_limit_d | NUMBER(15,2) | |
| Revolving credit line fee | p_revolving_line_fee_d | NUMBER(15,5) | |
| Customer yield | p_cus_d | NUMBER(15,7) | |
| Insurance risk fee rate | p_ins_risk_fee_d | NUMBER(15,5) | |
| Insurance risk fee code | ins_risk_fee_s | CHAR(4) | |
| Total tax credit | orig_tax_crd_d | NUMBER(15,2) | |
| Sum of payments | sum_pmt_d | NUMBER(15,2) | |
| Calculated total of payments | calc_pmt_d | NUMBER(15,2) |
| Index Name | Piece 1 | Piece 2 | Piece 3 | Piece 4 | Piece 5 |
|---|---|---|---|---|---|
| rap_idx0 | por_s | com_s | reg_s | off_s | app_s |
| rap_idx1 | app_s | ||||
| rap_idx2 | dlr_s | app_s | |||
| rap_idx3 | brk_s | app_s | |||
| rap_idx4 | inv_s | app_s | |||
| rap_idx5 | les_s | app_s |
| Table Name | Description |
|---|---|
| rapa | Application 2 |
| rapd | Application Document |
| raph | Application Status History |
| rapp | Application Payment Schedule |
| rapr | Application Recurring Charge |
| raps | Application Salesperson |
Following are descriptions of the Oracle data types used in the LeasePak database. Note that LeasePak does not use all the Oracle data types.
LeasePak 6.2a Documentation Suite
©
2010 by NetSol Technologies Inc. All rights reserved.
The information contained in this document is the property of NetSol Technologies Inc. Use of the information contained herein is restricted. Conditions of use are subject to change without notice. NetSol Technologies Inc. assumes no liability for any inaccuracy that may appear in this document; the contents of this document do not constitute a promise or warranty. The software described in this document is furnished under license and may be used or copied only in accordance with the terms of said license. Unauthorized use, alteration, or reproduction of this document without the written consent of NetSol Technologies Inc. is prohibited.