The input for this method is a XML document to get R0109 Model Amortization report.
The parameters are:
Name | Direction | Type | Description |
input | Input | string 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)
|