API fields and their corresponding LeasePak database columns supported by the MsiAppOriginator web service for Web Services API (LinkIT).
| API Field Name | Array Limit* | Required | LeasePak Database Table | LeasePak Database Column |
|---|---|---|---|---|
| leaseNumber | n/a | Yes | rls | lse_s |
| effectiveDate | n/a | No | ||
| payoffMethod | n/a | No | ||
| includeUnguaranteedResidual | n/a | No | ||
| includePaymentsOutstanding | n/a | No | ||
| *If not marked "n/a," represents an array field. For full listings of all array fields, refer to the NetSol App Originator DTD. | ||||
| API Field Name | Array Limit* | Required | LeasePak Database Table | LeasePak Database Column |
|---|---|---|---|---|
| portfolio | n/a | Yes | rcu | def_por_s |
| company | n/a | Yes | rcu | def_com_s |
| region | n/a | Yes | rcu | def_reg_s |
| office | n/a | Yes | rcu | def_off_s |
| clientNumber | n/a | No | rcu | cus_s |
| name | n/a | Yes | rcu | nam_long_s |
| address1 | n/a | Yes | rcu | add_s |
| address2 | n/a | No | rcu | add2_s |
| city | n/a | Yes | rcu | cty_s |
| state | n/a | Yes | rcu | st_s |
| zipCode | n/a | Yes | rcu | zip_s |
| busPhone | n/a | No | rcu | bus_phn_s |
| homePhone | n/a | No | rcu | phn_s |
| homePhoneType | n/a | No | rcu | hom_phn_type_s |
| busPhoneType | n/a | No | rcu | bus_phn_type_s |
| emailAddress | n/a | No | rcu | email_s |
| parentCustomer | n/a | No | rcu | par_cus_s |
| contactName | n/a | No | rcu | cont_nam_s |
| contactTitle | n/a | No | rcu | cont_title_s |
| billingName | n/a | No | rcu | bill_nam_s |
| billingAddress1 | n/a | No | rcu | bill_add_s |
| billingAddress2 | n/a | No | rcu | bill_add2_s |
| billingCity | n/a | No | rcu | bill_cty_s |
| billingState | n/a | No | rcu | bill_st_s |
| billingZipCode | n/a | No | rcu | bill_zip_s |
| letterVersionCode | n/a | No | rcu | lt_version_s |
| ssnBusinessID | n/a | No | rcx | ss_s |
| shortname | n/a | Yes | rcx | client_s_name_s |
| *If not marked "n/a," represents an array field. For full listings of all array fields, refer to the NetSol App Originator DTD. | ||||
| API Field Name | Array Limit* | Required | LeasePak Database Table | LeasePak Database Column |
|---|---|---|---|---|
| portfolio | n/a | Yes | ral | def_por_s |
| company | n/a | Yes | ral | def_com_s |
| region | n/a | Yes | ral | def_reg_s |
| office | n/a | Yes | ral | def_off_s |
| clientNumber | n/a | No | ral | les_s |
| name | n/a | Yes | ral | nam_long_s |
| address1 | n/a | Yes | ral | add_s |
| address2 | n/a | No | ral | add2_s |
| city | n/a | Yes | ral | cty_s |
| state | n/a | Yes | ral | st_s |
| zipCode | n/a | Yes | ral | zip_s |
| lastPhoneUsed | n/a | No | ral | last_phn_used_c |
| busPhone | n/a | No | ral | bus_phn_s |
| typeBusPhone | n/a | No | ral | bus_phn_type_s |
| homePhone | n/a | No | ral | hom_phn_s |
| typeHomePhone | n/a | No | ral | hom_phn_type_s |
| emailAddress | n/a | No | ral | email_s |
| papAcctType | n/a | No | ral | pap_acct_type_s |
| papInstID | n/a | No | ral | inst_id_s |
| papAchType | n/a | No | ral | ach_type_s |
| papAccount | n/a | No | ral | payer_acct_s |
| prenoteSent | n/a | No | ral | prenote_sent_c |
| sicCode | n/a | No | ral | sic_s |
| remittanceAddress | n/a | No | ral | remit_s |
| age | n/a | No | ral | age_l |
| residenceType | n/a | No | ral | res_stat_s |
| maritalStatus | n/a | No | ral | marital_s |
| noDependents | n/a | No | ral | dependents_l |
| birthDate | n/a | No | ral | d_birth_s |
| salutation | n/a | No | ral | sal_s |
| signerTitle | n/a | No | ral | sig_nam_s |
| signerName | n/a | No | ral | sig_title_s |
| contactTitle | n/a | No | ral | cont_title_s |
| contactName | n/a | No | ral | short_cont_nam_s |
| contractState | n/a | No | ral | contract_st_s |
| incorporatedDate | n/a | No | ral | d_inco_s |
| finStatementDate | n/a | No | ral | d_fin_stmt_s |
| collectionTeam | n/a | No | ral | col_team_s |
| collectionStatus | n/a | No | ral | col_stat_s |
| taxExemptNumber | n/a | No | ral | tx_exempt_s |
| additionalIncomeSource | n/a | No | ral | add_inc_src_s |
| currentOwnerDate | n/a | No | ral | ym_cur_own_s |
| customerNumber | n/a | No | ral | cus_s |
| letterVersionCode | n/a | No | ral | lt_version_s |
| billingName | n/a | No | ral | bill_nam_s |
| billingAddress1 | n/a | No | ral | bill_add_s |
| billingAddress2 | n/a | No | ral | bill_add2_s |
| billingCity | n/a | No | ral | bill_cty_s |
| billingState | n/a | No | ral | bill_st_s |
| billingZipCode | n/a | No | ral | bill_zip_s |
| otherName | n/a | No | ral | othr_nam_s |
| otherAddress1 | n/a | No | ral | othr_add_s |
| otherAddress2 | n/a | No | ral | othr_add2_s |
| otherCity | n/a | No | ral | othr_cty_s |
| otherState | n/a | No | ral | othr_st_s |
| otherZipCode | n/a | No | ral | othr_zip_s |
| otherBusPhone | n/a | No | ral | othr_bus_phn_s |
| otherHomePhone | n/a | No | ral | othr_home_phn_s |
| busEstablishedDate | n/a | No | ral | ym_bus_est_s |
| businessDescription | n/a | No | ral | bus_desc_s |
| businessType | n/a | No | ral | bus_typ_s |
| busIncorpState | n/a | No | ral | bus_st_s |
| useTaxExemptCode | n/a | No | ral | stax_exempt_s |
| otherNote1 | n/a | No | ral | othr_note1_s |
| otherNote2 | n/a | No | ral | othr_note2_s |
| residenceInYears | n/a | No | ral | res_yrs_l |
| residenceInMonths | n/a | No | ral | res_mon_l |
| employer1Name | n/a | No | ral | emp1_nam_s |
| employer1Address1 | n/a | No | ral | emp1_add_s |
| employer1Address2 | n/a | No | ral | emp1_add2_s |
| employer1City | n/a | No | ral | emp1_cty_s |
| employer1State | n/a | No | ral | emp1_st_s |
| employer1ZipCode | n/a | No | ral | emp1_zip_s |
| employer1Phone | n/a | No | ral | emp1_phn_s |
| employer1Position | n/a | No | ral | emp1_position_s |
| employer1YearsEmployed | n/a | No | ral | emp1_yrs_l |
| employer1MonthsEmployed | n/a | No | ral | emp1_mon_l |
| employer1MonthlySalary | n/a | No | ral | emp1_salary_d |
| paymentDueDay | n/a | No | ral | due_l |
| dbaName | n/a | No | rcx | client_s_name_s |
| ssnBusinessID | n/a | No | rcx | ss_s |
| shortname | n/a | Yes | rcx | client_s_name_s |
| *If not marked "n/a," represents an array field. For full listings of all array fields, refer to the NetSol App Originator DTD. | ||||
| API Field Name | Array Limit* | Required | LeasePak Database Table | LeasePak Database Column |
|---|---|---|---|---|
| portfolio | n/a | Yes | rgr | def_por_s |
| company | n/a | Yes | rgr | def_com_s |
| region | n/a | Yes | rgr | def_reg_s |
| office | n/a | Yes | rgr | def_off_s |
| clientNumber | n/a | No | rgr | grn_s |
| name | n/a | Yes | rgr | nam_long_s |
| address1 | n/a | Yes | rgr | add_s |
| address2 | n/a | No | rgr | add2_s |
| city | n/a | Yes | rgr | cty_s |
| state | n/a | Yes | rgr | st_s |
| zipCode | n/a | Yes | rgr | zip_s |
| busPhone | n/a | No | rgr | bus_phn_s |
| homePhone | n/a | No | rgr | home_phn_s |
| emailAddress | n/a | No | rgr | email_s |
| guarantorTitle | n/a | No | rgr | guarantor_title_s |
| otherNote1 | n/a | No | rgr | othr_note1_s |
| otherNote2 | n/a | No | rgr | othr_note2_s |
| letterVersionCode | n/a | No | rgr | lt_version_s |
| otherID | n/a | No | rgr | othr_id_s |
| ssnBusinessID | n/a | No | rcx | ss_s |
| shortname | n/a | Yes | rcx | client_s_name_s |
| *If not marked "n/a," represents an array field. For full listings of all array fields, refer to the NetSol App Originator DTD. | ||||
| API Field Name | Array Limit* | Required | LeasePak Database Table | LeasePak Database Column |
|---|---|---|---|---|
| portfolio | n/a | Yes | rlr | def_por_s |
| company | n/a | Yes | rlr | def_com_s |
| region | n/a | Yes | rlr | def_reg_s |
| office | n/a | Yes | rlr | def_off_s |
| clientNumber | n/a | No | rlr | dlr_s |
| name | n/a | Yes | rlr | nam_long_s |
| address1 | n/a | Yes | rlr | add_s |
| address2 | n/a | No | rlr | add2_s |
| city | n/a | Yes | rlr | cty_s |
| state | n/a | Yes | rlr | st_s |
| zipCode | n/a | Yes | rlr | zip_s |
| busPhone | n/a | No | rlr | phn_s |
| emailAddress | n/a | No | rlr | email_s |
| papInstID | n/a | No | rlr | inst_id_s |
| papAchType | n/a | No | rlr | ach_type_s |
| papAccount | n/a | No | rlr | payer_acct_s |
| rateplanGroup | n/a | No | rlr | plan_s |
| letterVersionCode | n/a | No | rlr | lt_version_s |
| contactName1 | n/a | No | rlr | cont_nam1_s |
| contactName2 | n/a | No | rlr | cont_nam2_s |
| vendorParticipationCode | n/a | No | rlr | part_s |
| activityStatus | n/a | No | rlr | stat_s |
| remittanceName | n/a | No | rlr | rmt_nam_s |
| remittanceAddress | n/a | No | rlr | rmt_add_s |
| remittanceAddress2 | n/a | No | rlr | rmt_add2_s |
| remittanceCity | n/a | No | rlr | rmt_cty_s |
| remittanceState | n/a | No | rlr | rmt_st_s |
| remittanceZipCode | n/a | No | rlr | rmt_zip_s |
| contactTitle1 | n/a | No | rlr | cont_title1_s |
| contactTitle2 | n/a | No | rlr | cont_title2_s |
| recourseType | n/a | No | rlr | rec_s |
| prenotificationSentYN | n/a | No | rlr | prenote_sent_c |
| datePrenotificationSentOn | n/a | No | rlr | d_prenote_sent_on_s |
| vendorType | n/a | No | rlr | vend_type_s |
| ssnBusinessID | n/a | No | rcx | ss_s |
| shortname | n/a | Yes | rcx | client_s_name_s |
| *If not marked "n/a," represents an array field. For full listings of all array fields, refer to the NetSol App Originator DTD. | ||||
| API Field Name | Array Limit* | Required | LeasePak Database Table | LeasePak Database Column |
|---|---|---|---|---|
| portfolio | n/a | Yes | rbk | def_por_s |
| company | n/a | Yes | rbk | def_com_s |
| region | n/a | Yes | rbk | def_reg_s |
| office | n/a | Yes | rbk | def_off_s |
| clientNumber | n/a | No | rbk | brk_s |
| name | n/a | Yes | rbk | nam_s |
| address1 | n/a | Yes | rbk | add_s |
| address2 | n/a | No | rbk | add2_s |
| city | n/a | Yes | rbk | cty_s |
| state | n/a | Yes | rbk | st_s |
| zipCode | n/a | Yes | rbk | zip_s |
| busPhone | n/a | No | rbk | phn_s |
| emailAddress | n/a | No | rbk | email_s |
| activityStatus | n/a | No | rbk | stat_s |
| contactName | n/a | No | rbk | cont_nam_s |
| contactTitle | n/a | No | rbk | cont_title_s |
| ssnBusinessID | n/a | No | rcx | ss_s |
| shortname | n/a | Yes | rcx | client_s_name_s |
| *If not marked "n/a," represents an array field. For full listings of all array fields, refer to the NetSol App Originator DTD. | ||||
| API Field Name | Array Limit* | Required | LeasePak Database Table | LeasePak Database Column |
|---|---|---|---|---|
| clientNumber | n/a | No | ruc | client_id_s |
| clientRelation | n/a | Yes | ruc | client_rel_s |
| portfolio | n/a | Yes | ruc | def_por_s |
| company | n/a | No | ruc | def_com_s |
| region | n/a | No | ruc | def_reg_s |
| office | n/a | No | ruc | def_off_s |
| name | n/a | Yes | ruc | nam_s |
| address1 | n/a | Yes | ruc | add_s |
| address2 | n/a | No | ruc | add2_s |
| city | n/a | Yes | ruc | cty_s |
| state | n/a | Yes | ruc | st_s |
| zipCode | n/a | Yes | ruc | zip_s |
| phoneNumber | n/a | No | ruc | phn_s |
| emailAddress | n/a | No | ruc | email_s |
| contactName | n/a | No | ruc | cont_nam_s |
| contactTitle | n/a | No | ruc | cont_title_s |
| letterVersionCode | n/a | No | ruc | lt_version_s |
| activityStatus | n/a | No | ruc | stat_s |
| ssnBusinessID | n/a | No | rcx | ss_s |
| shortname | n/a | Yes | rcx | client_s_name_s |
| *If not marked "n/a," represents an array field. For full listings of all array fields, refer to the NetSol App Originator DTD. | ||||
| API Field Name | Array Limit* | Required | LeasePak Database Table | LeasePak Database Column |
|---|---|---|---|---|
| portfolio | n/a | Yes | rap | por_s |
| company | n/a | Yes | rap | com_s |
| region | n/a | Yes | rap | reg_s |
| office | n/a | Yes | rap | off_s |
| appNumber | n/a | No | rap | app_s |
| vendor | n/a | No | rap | dlr_s |
| broker | n/a | No | rap | brk_s |
| investor | n/a | No | rap | inv_s |
| lessee | n/a | Yes | rap | les_s |
| leaseDate | n/a | No | rap | d_lsd_s |
| commencementDate | n/a | No | rap | d_com_s |
| disbursementDate | n/a | No | rap | d_dis_s |
| documentSentDate | n/a | No | rap | d_doc_sent_s |
| documentCompleteDate | n/a | No | rap | d_doc_comp_s |
| dueDate | n/a | No | rap | due_l |
| creditStartDate | n/a | No | rap | d_start_s |
| origCreditExpdate | n/a | No | rap | d_orig_exp_s |
| currCreditExpdate | n/a | No | rap | d_curr_exp_s |
| lessorAccrualMethod | n/a | No | rap | acc_l_s |
| vendorAccrualMethod | n/a | No | rap | acc_d_s |
| investorAccrualMethod | n/a | No | rap | acc_i_s |
| leaseSource | n/a | No | rap | dir_s |
| checkNumber | n/a | No | rap | chk_num_s |
| formCode | n/a | No | rap | frm_s |
| advancePaymentBegins | n/a | No | rap | adv_beg_l |
| advancePaymentEnds | n/a | No | rap | adv_end_l |
| delinquencyWatchCode | n/a | No | rap | del_s |
| brokerPaymentCode | n/a | No | rap | brk_pay_s |
| lateChargeAsmt | n/a | No | rap | late_s |
| leaseTypeCode | n/a | No | rap | ls_typ_s |
| purOptionBillingMethod | n/a | No | rap | po_meth_s |
| purchaseOption | n/a | No | rap | pur_opt_s |
| purOptionOwner | n/a | No | rap | pur_opt_owner_s |
| marketCode | n/a | No | rap | mkt_s |
| accountCode | n/a | No | rap | acc_code_s |
| applicationType | n/a | No | rap | typ_s |
| ratePlan | n/a | No | rap | rp_s |
| upfrontSalesTaxCode | n/a | No | rap | stax_cd_s |
| documentTypeCode | n/a | No | rap | doc_cd_s |
| primeRateBankNumber | n/a | No | rap | prim_num_s |
| lateChargeIndex | n/a | No | rap | lat_ind_s |
| idcAccountMethod | n/a | No | rap | idc_acct_s |
| productTypeCode | n/a | No | rap | prd_s |
| businessPersonal | n/a | No | rap | bus_c |
| openCloseLeaseType | n/a | No | rap | opn_c |
| assumedPayment | n/a | No | rap | a_pmt_c |
| resIncomeSep | n/a | No | rap | res_inc_c |
| refundable | n/a | No | rap | refund_c |
| preauthSwitch | n/a | No | rap | pap_pmt_c |
| fundingInterestModByUserYN | n/a | No | rap | stub_amt_mod_c |
| idcModByUserYN | n/a | No | rap | idc_mod_c |
| taxIDCModByUserYN | n/a | No | rap | idc_tax_mod_c |
| statementCode | n/a | No | rap | stmt_c |
| normalMstrSub | n/a | No | rap | norm_mas_sub_c |
| automaticChargeOff | n/a | No | rap | auto_charge_c |
| generalDescription | n/a | No | rap | desc_s |
| tradeinDescription | n/a | No | rap | trd_desc_s |
| vendContactName | n/a | No | rap | dlr_cont_s |
| vendPhoneNum | n/a | No | rap | dlr_phn_s |
| brkrContactName | n/a | No | rap | brk_cont_s |
| brkrPhoneNum | n/a | No | rap | brk_phn_s |
| securityDeposit | n/a | No | rap | sec_d |
| downPayment | n/a | No | rap | cap_d |
| residual | n/a | No | rap | tot_res_d |
| residPercent | n/a | No | rap | p_res_d |
| fundingInterestOwedOrEarned | n/a | No | rap | stub_fund_amt_d |
| leaseAddressName | n/a | No | rap | lse_nam_s |
| leaseAddress1 | n/a | No | rap | lse_add_s |
| leaseAddress2 | n/a | No | rap | lse_add2_s |
| leaseCity | n/a | No | rap | lse_cty_s |
| leaseState | n/a | No | rap | lse_st_s |
| leaseZipCode | n/a | No | rap | lse_zip_s |
| billingLevel | n/a | No | rap | b_lvl_c |
| billingName | n/a | No | rap | bill_nam_s |
| billingAddress1 | n/a | No | rap | bill_add_s |
| billingAddress2 | n/a | No | rap | bill_add2_s |
| billingCity | n/a | No | rap | bill_cty_s |
| billingState | n/a | No | rap | bill_st_s |
| billingZipCode | n/a | No | rap | bill_zip_s |
| groupNumber | n/a | No | rap | grp_s |
| masterAppNumber | n/a | No | rap | master_app_s |
| term | n/a | No | rap | trm_l |
| gracePeriodInDays | n/a | No | rap | grc_l |
| npvDiscountRate | n/a | No | rap | p_erly_pay_d |
| lessorRentalSimpleRate | n/a | No | rap | p_rent_d |
| lessorRentalRateAddOn | n/a | No | rap | p_byrt_d |
| contractRentalRateAddon | n/a | No | rap | p_cntr_d |
| rateOfParticipation | n/a | No | rap | p_part_d |
| maximumInterestRateLeaseLevel | n/a | No | rap | p_max_d |
| minimumInterestRateLeaseLevel | n/a | No | rap | p_min_d |
| documentationFee | n/a | No | rap | up_d |
| interimRent | n/a | No | rap | pro_d |
| brokerFees | n/a | No | rap | brk_fee_d |
| totalInitialDirectCosts | n/a | No | rap | idc_d |
| guaranteedPortionOfResidual | n/a | No | rap | res_guar_d |
| upfrontTitlingTaxPaid | n/a | No | rap | tax_paid_d |
| fixedPricePurchase | n/a | No | rap | fp_amt_d |
| upfrontSalesTaxOnCost | n/a | No | rap | stax_d |
| advancedMoneyReceived | n/a | No | rap | adv_rec_d |
| acquisitionCost | n/a | No | rap | tot_org_d |
| paymentFreq | n/a | No | rap | pmt_cd_reg_s |
| paymentAmount | n/a | No | rap | pmt_amt_reg_d |
| capitalizeIBLInterest | n/a | No | rap | capitalize_interest_c |
| notaryFeePayable | n/a | No | rap | notary_fee_pay_to_s |
| insurancePremiumPayTo | n/a | No | rap | ins_prem_pay_to_s |
| dealerRecourse | n/a | No | rap | rec_s |
| creditQuality | n/a | No | rap | cred_quality_s |
| optionalInsurance | n/a | No | rap | opt_ins_s |
| accountType | n/a | No | rap | acct_type_c |
| purchaseOptionFee | n/a | No | rap | purch_option_fee_d |
| revolvingCreditLimit | n/a | No | rap | revolving_limit_d |
| sumOfPayments | n/a | No | rap | sum_pmt_d |
| drawdownBalance | n/a | No | rap | credit_bal_d |
| revolvingCreditLineFee | n/a | No | rap | p_revolving_line_fee_d |
| dealerSubsidyIncome | n/a | No | rap | dlr_subsidy_incm_d |
| subvention | n/a | No | rap | idr5_d |
| dealerBuydown | n/a | No | rap | idr6_d |
| warrantyInsurance | n/a | No | rap | idrc_d |
| notaryFeeCost | n/a | No | rap | notary_fee_cost_d |
| fixedRateReserves | n/a | No | rap | idc3_d |
| standardReserves | n/a | No | rap | idc4_d |
| guaranteedReserves | n/a | No | rap | idc5_d |
| idrbAcquisitionFee | n/a | No | rap | idrb_d |
| slDeprBasisAcquisitionFee | n/a | No | rap | idrb_depr_l |
| slDeprBasisDealerReserves | n/a | No | rap | idc_depr_l |
| vendorFactor | n/a | No | rap | p_dlr_d |
| insurancePremium | n/a | No | rap | ins_prem_cost_d |
| tradeIn | n/a | No | rap | trade_in_d |
| markUp | n/a | No | rap | mrk_up_d |
| transferOfEquityYN | n/a | No | rap | tran_eqty_c |
| investorYieldFactor | n/a | No | rap | p_inv_d |
| costOfFunds | n/a | No | rap | p_fund_d |
| creditLife1 | n/a | No | rap | idr7_d |
| creditLife2 | n/a | No | rap | idr8_d |
| CRdisabilityIns1 | n/a | No | rap | idr9_d |
| CRdisabilityIns2 | n/a | No | rap | idra_d |
| registrationFeeIncome | n/a | No | rap | reg_fee_incm_d |
| excessMSRP | n/a | No | rap | x_msrp_d |
| totalTaxCredit | n/a | No | rap | orig_tax_crd_d |
| dealerReceivedPayments | n/a | No | rap | dlr_rec_pmts_d |
| principalWriteDown | n/a | No | rap | prn_write_down_c |
| dealerPaymentBankCode | n/a | No | rap | dlr_pmt_bank_code_s |
| useTaxExemptCode | n/a | No | rapa | stax_exempt_s |
| stagedEquityAmount | n/a | No | rapa | stg_eqty_d |
| leverageCommencementDate | n/a | No | rapa | d_lvr_com_s |
| lastLeverageDownloadDate | n/a | No | rapa | d_lst_lvr_s |
| leverageTerm | n/a | No | rapa | lvr_trm_l |
| stagedEquityFundPbl | n/a | No | rapa | stg_eqty_pay_to_s |
| nonpyramidLateCrgMin | n/a | No | rapa | npyr_min_d |
| invoiceFormatCode | n/a | No | rapa | invo_format_s |
| revolvingDrawdown | n/a | No | rapa | revolving_drawdown_c |
| metro2FileFormat | n/a | No | rapa | metro2_s |
| floatBasePerc | n/a | No | rapa | p_float_base_d |
| floatRateFreq | n/a | No | rapa | float_frq_s |
| floatRateSetDay | n/a | No | rapa | float_day_l |
| floatRateSetMon | n/a | No | rapa | float_mon_l |
| floatUseBus | n/a | No | rapa | float_bus_or_cal_c |
| floatCalendar | n/a | No | rapa | calendar_s |
| contractendDate | n/a | No | rapa | d_cntr_end_s |
| assetLevelPmt | n/a | No | rapa | asset_lvl_c |
| payment_Freq_0 | payment_Freq_359* | No | rapp | pmt_frq_l |
| payment_Amount_0 | payment_Amount_359* | No | rapp | pmt_amt_d |
| payment_Code_0 | payment_Code_359* | No | rapp | pmt_cd_s |
| clientRelationshipType_0 | clientRelationshipType_9* | No | rgc | client_typ_c |
| client_Number_0 | client_Number_9* | No | rgc | client_id_s |
| bndlRecurrChgOnInvo_0 | bndlRecurrChgOnInvo_14* | No | rapr | bundle_rcr_c |
| recurringChargeMaturityDate_0 | recurringChargeMaturityDate_14* | No | rapr | d_mrcr_s |
| recurringChargeBrkrPayable_0 | recurringChargeBrkrPayable_14* | No | rapr | rcr_pay_brk_s |
| recurringChargeAmount_0 | recurringChargeAmount_14* | No | rapr | rcr_amt_d |
| recurringChargeDealerPayable_0 | recurringChargeDealerPayable_14* | No | rapr | rcr_pay_dlr_s |
| recurringChargeStartDate_0 | recurringChargeStartDate_14* | No | rapr | d_srcr_s |
| salesPersonVolumePrct_0 | salesPersonVolumePrct_9* | No | raps | vol_d |
| salesPersonNumber_0 | salesPersonNumber_9* | No | raps | sales_s |
| salesPersonDollarPrct_0 | salesPersonDollarPrct_9* | No | raps | dol_d |
| *If not marked "n/a," represents an array field. For full listings of all array fields, refer to the NetSol App Originator DTD. | ||||
| API Field Name | Array Limit* | Required | LeasePak Database Table | LeasePak Database Column |
|---|---|---|---|---|
| appNumber | n/a | Yes | raq | app_s |
| *If not marked "n/a," represents an array field. For full listings of all array fields, refer to the NetSol App Originator DTD. | ||||
| API Field Name | Array Limit* | Required | LeasePak Database Table | LeasePak Database Column |
|---|---|---|---|---|
| assetNumber | n/a | No | raq | unit_s |
| applicationNumber | n/a | Yes | raq | app_s |
| identification | n/a | Yes | raq | id_s |
| supplier | n/a | Yes | raq | dlr_s |
| purchaseOrderNo | n/a | No | raq | pur_ord_s |
| acquisitionDate | n/a | Yes | raq | d_acq_s |
| acquisitionCost | n/a | Yes | raq | org_d |
| fhutDate | n/a | No | raq | d_fhut_s |
| inServiceDate | n/a | Yes | raq | d_serv_s |
| inspectionDate | n/a | No | raq | d_insp_s |
| bookDepreciationDate | n/a | No | raq | d_bok_s |
| assetClass | n/a | Yes | raq | cls_s |
| etcTakeBypassCode | n/a | No | raq | etc_s |
| manufacturer | n/a | No | raq | mnf_s |
| model | n/a | No | raq | mdl_s |
| year | n/a | No | raq | yr_s |
| locationState | n/a | No | raq | st_s |
| locationCounty | n/a | No | raq | ct_s |
| locationCity | n/a | No | raq | cy_s |
| taxPaymentCode | n/a | No | raq | txp_s |
| fedHighwayUseTaxCode | n/a | No | raq | hw_s |
| taxType | n/a | No | raq | tax_type_s |
| upfrontSalesTaxState | n/a | No | raq | upf_st_s |
| upfrontSalesTaxCounty | n/a | No | raq | upf_ct_s |
| upfrontSalesTaxCity | n/a | No | raq | upf_cy_s |
| assetStatus | n/a | No | raq | eqt_stat_s |
| newUsed | n/a | No | raq | new_c |
| reportPropertyTaxYN | n/a | No | raq | rpt_ptax_c |
| assetAppearsOnTaxReportsYN | n/a | No | raq | tax_rptg_c |
| upfrontSalesTaxYN | n/a | No | raq | upf_stax_c |
| description | n/a | Yes | raq | desc_s |
| licenseAuto | n/a | No | raq | lic_s |
| stockNumber | n/a | No | raq | stock_s |
| odometerReading | n/a | No | raq | codm_l |
| fhutAssetWeight | n/a | No | raq | weight_l |
| avgYearAllowMileage | n/a | No | raq | mil_aam_l |
| upfrontSalesTaxStRate | n/a | No | raq | upf_strt_d |
| upfrontSalesTaxCountyRate | n/a | No | raq | upf_ctrt_d |
| upfrontSalesTaxCityRate | n/a | No | raq | upf_cyrt_d |
| otherCharges | n/a | No | raq | other_d |
| residualCost | n/a | No | raq | res_d |
| listPrice | n/a | No | raq | lst_d |
| licenseFees | n/a | No | raq | lic_d |
| warrInsurancePremium | n/a | No | raq | pre_d |
| repairCost | n/a | No | raq | rep_d |
| gasCost | n/a | No | raq | gas_d |
| bookSalvageValue | n/a | No | raq | sal_bkd_d |
| stateSalvageValue | n/a | No | raq | sal_st_d |
| bookTaxBasis | n/a | No | raq | bk_basis_d |
| manufDepreciationBasis | n/a | No | raq | man_bas_d |
| originalAssetCost | n/a | No | raq | ast_cst_d |
| upfrontSalesTaxBaseAmt | n/a | No | raq | upf_bamt_d |
| upfrontSalesTaxSlsTxAmt | n/a | No | raq | upf_samt_d |
| gstVendorPayable | n/a | No | raq | gst_vendor_payable_d |
| insurancePremiumCost | n/a | No | raq | ins_prem_cost_d |
| warranty | n/a | No | raq | warranty_c |
| titleStatus | n/a | No | raq | title_status_s |
| additionalDeprMthd1 | n/a | No | raq | ger1_s |
| additionalDeprMthd2 | n/a | No | raq | ger2_s |
| warrMilesAllowed | n/a | No | raq | war_miles_l |
| vehicleColor | n/a | No | raq | color_s |
| manufKeyCode | n/a | No | raq | cd_key_s |
| partNumber | n/a | No | raq | part_num_s |
| startBookDeprecValue | n/a | No | raq | taxbasis_d |
| insuranceExprDate | n/a | No | raq | d_ins_exp_s |
| insuranceAsset | n/a | No | raq | ins_unit_c |
| diminValueRate | n/a | No | raq | p_dim_val_d |
| leveraged | n/a | No | raq | lvr_c |
| amtDepreciationLife | n/a | No | raq | amt_life_l |
| fedDepreciationLife | n/a | No | raq | fed_life_l |
| associatedAsset | n/a | No | raq | asset_s |
| bookAccountingMethod | n/a | No | raq | bk_acct_s |
| bookDepreciationMethod | n/a | No | raq | bkd_s |
| checkReference | n/a | No | raq | chk_ref_s |
| federalMethodOfDepreciation | n/a | No | raq | fed_s |
| federalAMTMethod | n/a | No | raq | fed_amt_s |
| itcAccrualMethod | n/a | No | raq | itc_meth_s |
| itcTakeBypassCode | n/a | No | raq | itc_s |
| paymentAmount | n/a | No | raq | pmt_amt_d |
| propertyTaxBasis | n/a | No | raq | prop_tax_basis_d |
| purchaseOrderDate | n/a | No | raq | d_po_s |
| residualInsuranceYN | n/a | No | raq | res_ins_c |
| stateDepreciationMethod | n/a | No | raq | std_s |
| stateOfLicensePlateIssued | n/a | No | raq | lic_st_s |
| warrInsuranceYN | n/a | No | raq | war_c |
| pptExemptCode | n/a | No | raq | ptax_exempt_s |
| useTaxExemptCode | n/a | No | raq | stax_exempt_s |
| pptLastUsedDate | n/a | No | raq | d_ptax_last_used_s |
| securityDeposit | n/a | No | raq | sec_d |
| address1 | n/a | Yes | raq | eq_add_s |
| address2 | n/a | No | raq | eq_add2_s |
| city | n/a | Yes | raq | eq_cty_s |
| state | n/a | Yes | raq | eq_st_s |
| zipCode | n/a | Yes | raq | eq_zip_s |
| supplierAddress | n/a | No | raq | sup_add_s |
| supplierAddress2 | n/a | No | raq | sup_add2_s |
| supplierCity | n/a | No | raq | sup_cty_s |
| supplierState | n/a | No | raq | sup_st_s |
| supplierZip | n/a | No | raq | sup_zip_s |
| operatorName | n/a | No | raq | opr_nam_s |
| utilizeVehicleTaxRatesYN | n/a | No | raq | utilize_veh_tax_rates_c |
| uccTitleFilingTerm_0 | uccTitleFilingTerm_4* | No | raqu | ucc_trm_l |
| uccTitleFilingNumber_0 | uccTitleFilingNumber_4* | No | raqu | ucc_num_s |
| uccTitleFilingType_0 | uccTitleFilingType_4* | No | raqu | ucc_typ_s |
| uccTitleFilingState_0 | uccTitleFilingState_4* | No | raqu | ucc_st_s |
| uccTitleFilingCode_0 | uccTitleFilingCode_4* | No | raqu | ucc_s |
| uccTitleFilingDate_0 | uccTitleFilingDate_4* | No | raqu | d_ucc_s |
| uccTitleFilingCounty_0 | uccTitleFilingCounty_4* | No | raqu | ucc_cnty_s |
| payment_Freq_0 | payment_Freq_359* | No | raqp | pmt_frq_l |
| payment_Amount_0 | payment_Amount_359* | No | raqp | pmt_amnt_d |
| payment_Code_0 | payment_Code_359* | No | raqp | pmt_cd_s |
| *If not marked "n/a," represents an array field. For full listings of all array fields, refer to the NetSol App Originator DTD. | ||||
| API Field Name | Array Limit* | Required | LeasePak Database Table | LeasePak Database Column |
|---|---|---|---|---|
| appLeaseNumber | n/a | Yes | rdm | app_lse_s |
| entityFilingCode | n/a | No | rdm | entity_s |
| finalCreditScore | n/a | No | rdm | scr_s |
| recordType | n/a | No | rdm | rec_typ_c |
| interestBearingSecDeposit | n/a | No | rdm | ib_sec_dep_c |
| prelimCreditScore | n/a | No | rdm | pr_scr_s |
| creditApprovalOfficer | n/a | No | rdm | ofc_s |
| customString1 | n/a | No | rdm | cus_str1_s |
| fundingApprovalOfficer | n/a | No | rdm | fnd_ofc_s |
| documentApprovalOfficer | n/a | No | rdm | doc_ofc_s |
| agentName_0 | agentName_4* | No | rdmi | ag_nam_s |
| agentContactName_0 | agentContactName_4* | No | rdmi | ag_cont_nam_s |
| agentContactTitle_0 | agentContactTitle_4* | No | rdmi | ag_cont_title_s |
| agentAddress2_0 | agentAddress2_4* | No | rdmi | ag_add2_s |
| agentAddress1_0 | agentAddress1_4* | No | rdmi | ag_add_s |
| agentCity_0 | agentCity_4* | No | rdmi | ag_cty_s |
| agentState_0 | agentState_4* | No | rdmi | ag_st_s |
| agentZipCode_0 | agentZipCode_4* | No | rdmi | ag_zip_s |
| insuranceAgentPhoneNum_0 | insuranceAgentPhoneNum_4* | No | rdmi | ins_phn_s |
| insuranceCarrierName_0 | insuranceCarrierName_4* | No | rdmi | ins_car_nam_s |
| insuranceCarrierCode_0 | insuranceCarrierCode_4* | No | rdmi | ins_car_s |
| insuranceExpDate_0 | insuranceExpDate_4* | No | rdmi | d_ins_s |
| insurancePolicyEffDate_0 | insurancePolicyEffDate_4* | No | rdmi | d_pol_s |
| insuranceType_0 | insuranceType_4* | No | rdmi | ins_typ_s |
| insuranceStatus_0 | insuranceStatus_4* | No | rdmi | ins_stat_s |
| insuranceCoverageType_0 | insuranceCoverageType_4* | No | rdmi | ins_cov_s |
| policyNumber_0 | policyNumber_4* | No | rdmi | pol_num_s |
| payeeLossAmount_0 | payeeLossAmount_4* | No | rdmi | loss_amt_d |
| lossPayee_0 | lossPayee_4* | No | rdmi | payee_s |
| *If not marked "n/a," represents an array field. For full listings of all array fields, refer to the NetSol App Originator DTD. | ||||
| API Field Name | Array Limit* | Required | LeasePak Database Table | LeasePak Database Column |
|---|---|---|---|---|
| udfKey | n/a | Yes | rud | rum | ruj | rur | ruo | cus_s | les_s | app_s | unit_s | dlr_s |
| udfType | n/a | Yes | rud | rum | ruj | rur | ruo | CUS | LES | APP | UNI | VND |
| udfField1 | n/a | No | rud | rum | ruj | rur | ruo | field1_s |
| udfField2 | n/a | No | rud | rum | ruj | rur | ruo | field2_s |
| udfField3 | n/a | No | rud | rum | ruj | rur | ruo | field3_s |
| udfField4 | n/a | No | rud | rum | ruj | rur | ruo | field4_s |
| udfField5 | n/a | No | rud | rum | ruj | rur | ruo | field5_s |
| udfField6 | n/a | No | rud | rum | ruj | rur | ruo | field6_s |
| udfField7 | n/a | No | rud | rum | ruj | rur | ruo | field7_s |
| udfField8 | n/a | No | rud | rum | ruj | rur | ruo | field8_s |
| udfField9 | n/a | No | rud | rum | ruj | rur | ruo | field9_s |
| udfField10 | n/a | No | rud | rum | ruj | rur | ruo | field10_s |
| udfField11 | n/a | No | rud | rum | ruj | rur | ruo | field11_s |
| udfField12 | n/a | No | rud | rum | ruj | rur | ruo | field12_s |
| udfField13 | n/a | No | rud | rum | ruj | rur | ruo | field13_s |
| udfField14 | n/a | No | rud | rum | ruj | rur | ruo | field14_s |
| udfField15 | n/a | No | rud | rum | ruj | rur | ruo | field15_s |
| udfField16 | n/a | No | rud | rum | ruj | rur | ruo | field16_s |
| udfField17 | n/a | No | rud | rum | ruj | rur | ruo | field17_s |
| udfField18 | n/a | No | rud | rum | ruj | rur | ruo | field18_s |
| udfField19 | n/a | No | rud | rum | ruj | rur | ruo | field19_s |
| udfField20 | n/a | No | rud | rum | ruj | rur | ruo | field20_s |
| udfField21 | n/a | No | rud | rum | ruj | rur | ruo | field21_s |
| udfField22 | n/a | No | rud | rum | ruj | rur | ruo | field22_s |
| udfField23 | n/a | No | rud | rum | ruj | rur | ruo | field23_s |
| udfField24 | n/a | No | rud | rum | ruj | rur | ruo | field24_s |
| udfField25 | n/a | No | rud | rum | ruj | rur | ruo | field25_s |
| udfField26 | n/a | No | rud | rum | ruj | rur | ruo | field26_s |
| udfField27 | n/a | No | rud | rum | ruj | rur | ruo | field27_s |
| udfField28 | n/a | No | rud | rum | ruj | rur | ruo | field28_s |
| udfField29 | n/a | No | rud | rum | ruj | rur | ruo | field29_s |
| udfField30 | n/a | No | rud | rum | ruj | rur | ruo | field30_s |
| udfField31 | n/a | No | rud | rum | ruj | rur | ruo | field31_s |
| udfField32 | n/a | No | rud | rum | ruj | rur | ruo | field32_s |
| udfField33 | n/a | No | rud | rum | ruj | rur | ruo | field33_s |
| udfField34 | n/a | No | rud | rum | ruj | rur | ruo | field34_s |
| udfField35 | n/a | No | rud | rum | ruj | rur | ruo | field35_s |
| udfField36 | n/a | No | rud | rum | ruj | rur | ruo | field36_s |
| udfField37 | n/a | No | rud | rum | ruj | rur | ruo | field37_s |
| udfField38 | n/a | No | rud | rum | ruj | rur | ruo | field38_s |
| udfField39 | n/a | No | rud | rum | ruj | rur | ruo | field39_s |
| udfField40 | n/a | No | rud | rum | ruj | rur | ruo | field40_s |
| udfField41 | n/a | No | rud | rum | ruj | rur | ruo | field41_s |
| udfField42 | n/a | No | rud | rum | ruj | rur | ruo | field42_s |
| udfField43 | n/a | No | rud | rum | ruj | rur | ruo | field43_s |
| udfField44 | n/a | No | rud | rum | ruj | rur | ruo | field44_s |
| udfField45 | n/a | No | rud | rum | ruj | rur | ruo | field45_s |
| udfField46 | n/a | No | rud | rum | ruj | rur | ruo | field46_s |
| udfField47 | n/a | No | rud | rum | ruj | rur | ruo | field47_s |
| udfField48 | n/a | No | rud | rum | ruj | rur | ruo | field48_s |
| udfField49 | n/a | No | rud | rum | ruj | rur | ruo | field49_s |
| udfField50 | n/a | No | rud | rum | ruj | rur | ruo | field50_s |
| udfField51 | n/a | No | rud | rum | ruj | rur | ruo | field51_s |
| *If not marked "n/a," represents an array field. For full listings of all array fields, refer to the NetSol App Originator DTD. | ||||
| API Field Name | Array Limit* | Required | LeasePak Database Table | LeasePak Database Column |
|---|---|---|---|---|
| appLeaseNumber | n/a | Yes | mjl | app_lse_s |
| dateEntered | n/a | Yes | mjl | dt_ent_s |
| timeEntered | n/a | Yes | mjl | dt_ent_s |
| dateFollowup | n/a | Yes | mjl | dt_fol_s |
| timeFollowup | n/a | Yes | mjl | dt_fol_s |
| noteType | n/a | Yes | mjl | note_type_s |
| prcs | n/a | Yes | mjl | prcs_c |
| prio | n/a | Yes | mjl | prio_c |
| fromUser | n/a | Yes | mjl | from_s |
| toUser | n/a | Yes | mjl | to_s |
| noteTitle | n/a | Yes | mjl | note_title_s |
| privateNote | n/a | No | mjl | private_c |
| leaseAcc | n/a | No | mjl | lse_acc_c |
| collectionStatus | n/a | No | mjl | col_stat_s |
| reason | n/a | No | mjl | ntbk_rsn_s |
| notebookText | n/a | No | mjl | info_s | info1_s | info2_s | info3_s | info4_s |
| *If not marked "n/a," represents an array field. For full listings of all array fields, refer to the NetSol App Originator DTD. | ||||
| API Field Name | Array Limit* | Required | LeasePak Database Table | LeasePak Database Column |
|---|---|---|---|---|
| udtKey | n/a | Yes | rus | rue | ruk | ruq | run | unit_s | cus_s | app_s | dlr_s | les_s |
| udtType | n/a | Yes | rus | rue | ruk | ruq | run | UNI | CUS | APP | VND | LES |
| recordNumber | n/a | Yes | rust | ruet | rukt | ruqt | runt | unique_l |
| udtTable1 | n/a | No | rust | ruet | rukt | ruqt | runt | table1_s |
| udtTable2 | n/a | No | rust | ruet | rukt | ruqt | runt | table2_s |
| udtTable3 | n/a | No | rust | ruet | rukt | ruqt | runt | table3_s |
| udtTable4 | n/a | No | rust | ruet | rukt | ruqt | runt | table4_s |
| udtTable5 | n/a | No | rust | ruet | rukt | ruqt | runt | table5_s |
| udtTable6 | n/a | No | rust | ruet | rukt | ruqt | runt | table6_s |
| udtTable7 | n/a | No | rust | ruet | rukt | ruqt | runt | table7_s |
| udtTable8 | n/a | No | rust | ruet | rukt | ruqt | runt | table8_s |
| udtTable9 | n/a | No | rust | ruet | rukt | ruqt | runt | table9_s |
| udtTable10 | n/a | No | rust | ruet | rukt | ruqt | runt | table10_s |
| udtTable11 | n/a | No | rust | ruet | rukt | ruqt | runt | table11_s |
| udtTable12 | n/a | No | rust | ruet | rukt | ruqt | runt | table12_s |
| *If not marked "n/a," represents an array field. For full listings of all array fields, refer to the NetSol App Originator DTD. | ||||