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 |