Request Reference Grid
LeasePak Documentation Suite NETSOL website
getR0109

(mPower icon) LPRreports

getR0109

Request Reference Grid

The input for this method is a XML document to get R0109 Model Amortization report.

The parameters are:

NameDirectionTypeDescription
inputInputstring input (XML doc) XML document to extract model amortization report R0109. For details of xml document see, below request reference grid parameters.

Request
Occurs LeasePak Database Type
Level Element Min Max Required Data Type Table Column Oracle Sybase Description
1 R0109_RECORD 1 1 Y
1.1 acquisitionCost 1 1 Y decimal(15,2) Application (rap) tot_org_d NUMBER(15,2) double precision Total acquisition cost
1.2 lessorAccrualMethod 1 1 Y string(4) Application (rap) acc_l_s CHAR(4) char(4) Accrual method lessor
1.3 portfolio 1 1 Y string(2) Application (rap) por_s CHAR(2) char(2) Portfolio
1.4 annualPreTaxYield 0 1 C decimal(15,7) Application (rap) p_irr_d NUMBER(15,7) double precision IRR (yield)
1.5 commencementDate 1 1 Y date Application (rap) d_com_s DATE datetime Lease commencement date
1.6 downPayment 0 1 N decimal(15,2) Application (rap) cap_d NUMBER(15,2) double precision Down payment
1.7 otherCharges 0 1 N decimal(15,2) Application (rap) tot_other_d NUMBER(15,2) double precision Other charges
1.8 totalInitialDirectCosts 0 1 N decimal(15,2) Application (rap) idc_d NUMBER(15,2) double precision Total initial direct costs
1.9 securityDeposit 0 1 N decimal(15,2) Application (rap) sec_d NUMBER(15,2) double precision Security deposit
1.10 residual 0 1 N decimal(15,2) Application (rap) tot_res_d NUMBER(15,2) double precision Residual amount
If tot_res_d is entered by the user, the value of p_res_d
is erased.
1.11 residPercent 0 1 N decimal(15,5) Application (rap) p_res_d NUMBER(15,5) double precision Residual percentage
If entered by the user, tot_res_d is also
calculated and stored.
1.12 interimRent 0 1 N decimal(15,2) Application (rap) pro_d NUMBER(15,2) double precision Interim rent
1.13 insurancePremium 0 1 N decimal(15,2) Application (rap) ins_prem_cost_d NUMBER(15,2) double precision Insurance premium cost
1.14 notaryFee 0 1 N decimal(15,2) Application (rap) notary_fee_cost_d NUMBER(15,2) double precision Notary fee cost
1.15 dealerSubsidyIncome 0 1 N decimal(15,2) Application (rap) dlr_subsidy_incm_d NUMBER(15,2) double precision Dealer subsidy income
1.16 registrationFee 0 1 N decimal(15,2) Application (rap) reg_fee_incm_d NUMBER(15,2) double precision Registration fee income
1.17 openingCommission 0 1 N decimal(15,2) Application (rap) open_comm_incm_d NUMBER(15,2) double precision Open commission income
1.18 documentationFee 0 1 N decimal(15,2) Application (rap) up_d NUMBER(15,2) double precision Documentation fee
1.19 fixedRateReserves 0 1 N decimal(15,2) Application (rap) idc3_d NUMBER(15,2) double precision Fixed rate reserves IDC3
1.20 standardReserves 0 1 N decimal(15,2) Application (rap) idc4_d NUMBER(15,2) double precision Standard reserves IDC4
1.21 guaranteedReserves 0 1 N decimal(15,2) Application (rap) idc5_d NUMBER(15,2) double precision Guaranteed reserves IDC5
1.22 idc8Reserves 0 1 N decimal(15,2) idc8_d NUMBER(15,2) double precision IDC8 reserves amount
1.23 idc9Reserves 0 1 N decimal(15,2) idc9_d NUMBER(15,2) double precision IDC9 reserves amount
1.24 idcAReserves 0 1 N decimal(15,2) idca_d NUMBER(15,2) double precision IDCA reserves amount
1.25 idcBReserves 0 1 N decimal(15,2) idcb_d NUMBER(15,2) double precision IDCB reserves amount
1.26 idcCReserves 0 1 N decimal(15,2) idcc_d NUMBER(15,2) double precision IDCC reserves amount
1.27 idcDReserves 0 1 N decimal(15,2) idcd_d NUMBER(15,2) double precision IDCD reserves amount
1.28 idcEReserves 0 1 N decimal(15,2) idce_d NUMBER(15,2) double precision IDCE reserves amount
1.29 idcFReserves 0 1 N decimal(15,2) idcf_d NUMBER(15,2) double precision IDCF reserves amount
1.30 idcGReserves 0 1 N decimal(15,2) idcg_d NUMBER(15,2) double precision IDCG reserves amount
1.31 idcHReserves 0 1 N decimal(15,2) idch_d NUMBER(15,2) double precision IDCH reserves amount
1.32 subvention 0 1 N decimal(15,2) Application (rap) idr5_d NUMBER(15,2) double precision Subvention IDR5
1.33 dealerBuydown 0 1 N decimal(15,2) Application (rap) idr6_d NUMBER(15,2) double precision Dealer buy down ID6
1.34 creditLife1 0 1 N decimal(15,2) Application (rap) idr7_d NUMBER(15,2) double precision Credit life insurance 1 IDR7
1.35 creditLife2 0 1 N decimal(15,2) Application (rap) idr8_d NUMBER(15,2) double precision Credit life insurance 2 IDR8
1.36 idrbAcquisitionFee 0 1 N decimal(15,2) Application (rap) idrb_d NUMBER(15,2) double precision Acquisition fee IDRB
1.37 warrantyInsurance 0 1 N decimal(15,2) Application (rap) idrc_d NUMBER(15,2) double precision Warranty insurance IDRC
1.38 floatIndex 0 1 N string(4) Application (rap) prim_num_s CHAR(4) char(4) Prime rate bank number
1.39 comRate 0 1 N decimal(15,5) Application (rap) p_rent_d NUMBER(15,5) double precision Lessor rental simple rate
1.40 contractRentalRateAddon 0 1 N decimal(15,5) Application (rap) p_cntr_d NUMBER(15,5) double precision Contract rental rate add-on
1.41 subventionAmount_(0-4) 0 5 N decimal(15,2) Application Subvention (rapv) subv_d NUMBER(15,2) double precision Subvention amount
1.42 itcAccrualMethod 0 1 N string(4) Application Asset (raq) itc_meth_s CHAR(4) char(4) ITC accrual method
1.43 bookDepreciationMethod 0 1 N string(4) Application Asset (raq) bkd_s CHAR(4) char(4) Book depreciation method
1.44 dealerBonus 0 1 N decimal(15,2) Application Asset (raq) idc6_d NUMBER(15,2) double precision Dealer bonus IDC6
1.45 dealerReserve 0 1 N decimal(15,2) Application Asset (raq) idc7_d NUMBER(15,2) double precision Dealer reserve IDC7
1.46 payment_Code_(0-359) 1 360 Y string(4) Application Payment Schedule (rapp) pmt_cd_s CHAR(4) char(4) Payment frequency code
1.47 payment_Freq_(0-359) 1 360 Y integer Application Payment Schedule (rapp) pmt_frq_l NUMBER(10) integer Number of payments at frequency
1.48 payment_Amount_(0-359) 0 360 C decimal(15,2) Application Payment Schedule (rapp) pmt_amt_d NUMBER(15,2) double precision Payment amount
1.49 lease 0 1 N string(10) Application(rap) lse_s CHAR(10) char(10) Lease
1.50 customerCompanyFlag 0 1 N decimal(15,2) M - Company
S - Customer
blank - M (Company as default)
1.51 idcAsc842Amount 0 1 N decimal(15,2) Lease 3 (rlsb) idc_asc842_d NUMBER(15,2) double precision Total IDC ASC 842 initial direct cost amount.
1.52 accrualCycle 0 1 N string(1) Lease 3 (rlsb) accrual_cycle_c CHAR (1) char (1) Accrual/billing cycle (M/S/B/W)
  • M - Monthly (12 per year)
  • S - Semi-monthly (24 per year)
  • B - Bi-weekly (26 per year)
  • W - Weekly (52 per year)