LPBookLease
| Response | |||||||||
| Occurs | LeasePak Database | Datatype | |||||||
| Level | Element | Min | Max | Type | Table | Column | Oracle | Sybase | Description |
| 1 | PAYOFFQUOTE | 1 | 1 | Root Element | |||||
| 1.1 | leaseNumber | 1 | 1 | String (10) | lse_s | ||||
| 1.2 | effectiveDate | 1 | 1 | Date | d_eff_s | ||||
| 1.3 | leaseNumber | 1 | 1 | String (125) | nam_long_s | ||||
| 1.4 | vendorName | 1 | 1 | String | nam_long_s | ||||
| 1.5 | customerName | 0 | 1 | String (125) | nam_long_s | ||||
| 1.6 | payoffMethod | 1 | 1 | String | payoff_s | ||||
| 1.7 | payoffCalcualtedMethod | 1 | 1 | String | cd_long_s | ||||
| 1.8 | purchaseOptionCode | 1 | 1 | String | purch_s | ||||
| 1.9 | purchaseOption | 1 | 1 | String (20) | cd_long_s | ||||
| 1.10 | futurePmtsRecv | 1 | 1 | String (1) | pmt_recd_c | ||||
| 1.11 | perdiem | 1 | 1 | Decimal (15,2) | diem_d | ||||
| 1.12 | paymentsOutstanding | 1 | 1 | Decimal (15,2) | pmt_dlnq_d | ||||
| 1.13 | paymentsOutstanding | 1 | 1 | Decimal (15,2) | asm_outs_d | ||||
| 1.14 | additionalInterest | 1 | 1 | Decimal (15,2) | add_d | ||||
| 1.15 | feesPenalties | 1 | 1 | Decimal (15,2) | fee_d | ||||
| 1.16 | salesTax | 1 | 1 | Decimal (15,2) | sales_tax_d | ||||
| 1.17 | itcRecapture | 1 | 1 | Decimal (15,2) | itc_d | ||||
| 1.18 | fixedPricePurchase | 1 | 1 | Decimal (15,2) | fp_amt_d | ||||
| 1.19 | transactionBond | 1 | 1 | Decimal (15,2) | sec_d | ||||
| 1.20 | residualAmount | 1 | 1 | Decimal (15,2) | tot_res_d | ||||
| 1.21 | effectiveRate | 1 | 1 | Decimal (15,2) | rate_d | ||||
| 1.22 | buyoutQuotes | 1 | 1 | Number | buyout_quote_l | ||||
| 1.23 | payoffAmount | 1 | 1 | String (4) | base_def_s | ||||
| 1.24 | basePayoffAmount | 1 | 1 | Decimal (15,2) | base_d | ||||
| 1.25 | goodUntil | 1 | 1 | Date | d_good_s | ||||
| 1.26 | maturityDate | 1 | 1 | Date | d_mat_s | ||||
| 1.27 | terminationAmount | 1 | 1 | Decimal (15,2) | bas_wo_d | ||||
| 1.28 | grossRecBalance | 1 | 1 | ||||||
| 1.29 | netOutBalance | 1 | 1 | ||||||
| 1.30 | grossOutBalance | 1 | 1 | ||||||
| 1.31 | crLIF1Rebate | 0 | 1 | String | cr_lif1_re_d | ||||
| 1.32 | crLIF2Rebate | 0 | 1 | String | cr_lif2_re_d | ||||
| 1.33 | crDIS1Rebate | 0 | 1 | String | cr_dis1_re_d | ||||
| 1.34 | crDIS2Rebate | 0 | 1 | String | cr_dis2_re_d | ||||
| 1.35 | closeType | 0 | 1 | String | quote_type_c | ||||
| 1.36 | payoffAmountDue | 0 | 1 | Decimal (15,2) | pay_due_d | ||||
| 1.37 | allowanceForBadDebt | 0 | 1 | Decimal (15,2) | allow_d | ||||
| 1.38 | proceedsOfSale | 0 | 1 | Decimal (15,2) | pro_sale_d | ||||
| 1.39 | payoffTaxAmount | 0 | 1 | Decimal (15,2) | tax_amt_d | ||||
| 1.40 | gainLossAmount | 0 | 1 | Decimal (15,2) | gnls_d | ||||
| 1.41 | effDateOfClose | 0 | 1 | String | d_eff_s | ||||
| 1.42 | actualDateOfClose | 0 | 1 | String | d_pay_s | ||||
| 1.43 | actualTimeOfClose | 0 | 1 | String | t_pay_s | ||||
| 1.44 | payoffSource | 0 | 1 | String | p_src_s | ||||
| 1.45 | transactionCode | 0 | 1 | String | trn_s | ||||
| 1.46 | payoffCloseMethod | 0 | 1 | String | meth_s | ||||
| 1.47 | securityDepositRefund | 0 | 1 | String | sec_refund_d | ||||
| 1.48 | baseTaxableAmount | 1 | 1 | String | base_amt_d | ||||
| 1.49 | totalTaxableAmount | 1 | 1 | ||||||
| 1.50 | totalSalesTax | 1 | 1 | ||||||
| 1.51 | assetDetail_[1:unbounded] | 0 | 1 | String (10) | unit_s | ||||
| 1.52 | taxCode_[1:unbounded] | 0 | 1 | String (4) | txp_s | ||||
| 1.53 | payoffState_[1:unbounded] | 0 | 1 | String (2) | pay_st_s | ||||
| 1.54 | payoffCounty_[1:unbounded] | 0 | 1 | String (4) | pay_ct_s | ||||
| 1.55 | payoffCity_[1:unbounded] | 0 | 1 | String (4) | pay_cy_s | ||||
| 1.56 | stateRate_[1:unbounded] | 0 | 1 | Decimal (15,2) | pay_st_rate_d | ||||
| 1.57 | countyRate_[1:unbounded] | 0 | 1 | Decimal (15,2) | pay_ct_rate_d | ||||
| 1.58 | cityRate_[1:unbounded] | 0 | 1 | Decimal (15,2) | pay_cy_rate_d | ||||
| 1.59 | assetTaxableAmount_[1:unbounded] | 1 | 1 | Decimal (15,2) | pay_tax_amt_d | ||||
| 1.60 | assetSalesTax_[1:unbounded] | 0 | 1 | Decimal (15,2) | sales_tax_d | ||||