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 |
---|---|---|---|---|
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 |
lastPhoneUsed | n/a | No | rcu | last_phn_used_c |
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 |
paymentHierarchyCode | n/a | No | rcu | pmt_hier_s |
collectionTeam | n/a | No | rcu | col_team_s |
drawdownDate | n/a | No | rcu | d_drawdown_exp_s |
dateFinancialStatement | n/a | No | rcu | d_fin_s |
revolvingCrdExpDate | n/a | No | rcu | d_revolving_exp_s |
drawdownCrdLimit | n/a | No | rcu | drawdown_limit_d |
revolvingCrdLimit | n/a | No | rcu | revolving_limit_d |
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 |
paymentDueDay | n/a | No | ral | due_l |
activityStatus | n/a | No | ral | act_stat_s |
addressType | n/a | No | ral | addr_type_c |
addressStatus | n/a | No | ral | addr_stat_c |
addressConfDate | n/a | No | ral | d_addr_confirm_s |
addressConfTime | n/a | No | ral | t_addr_confirm_s |
busIndicator | n/a | No | ral | cb_business_c |
drawdownCrdLimit | n/a | No | ral | drawdown_limit_d |
autoCrdLimit | n/a | No | ral | auto_lim_d |
datePrenotificationSentOn | n/a | No | ral | d_prenote_sent_on_s |
employer1Name | n/a | No | rale | emp1_nam_s |
employer1Contact | n/a | No | rale | emp1_cont_s |
employer1ContactTitle | n/a | No | rale | emp1_cont_title_s |
employer1Address1 | n/a | No | rale | emp1_add_s |
employer1Address2 | n/a | No | rale | emp1_add2_s |
employer1City | n/a | No | rale | emp1_cty_s |
employer1State | n/a | No | rale | emp1_st_s |
employer1ZipCode | n/a | No | rale | emp1_zip_s |
employer1Phone | n/a | No | rale | emp1_phn_s |
employer1Position | n/a | No | rale | emp1_position_s |
employer1YearsEmployed | n/a | No | rale | emp1_yrs_l |
employer1MonthsEmployed | n/a | No | rale | emp1_mon_l |
employer1MonthlySalary | n/a | No | rale | emp1_salary_d |
employer2Name | n/a | No | rale | emp2_nam_s |
employer2Contact | n/a | No | rale | emp2_cont_s |
employer2ContactTitle | n/a | No | rale | emp2_cont_title_s |
employer2Address1 | n/a | No | rale | emp2_add_s |
employer2Address2 | n/a | No | rale | emp2_add2_s |
employer2City | n/a | No | rale | emp2_cty_s |
employer2State | n/a | No | rale | emp2_st_s |
employer2ZipCode | n/a | No | rale | emp2_zip_s |
employer2Phone | n/a | No | rale | emp2_phn_s |
employer2Position | n/a | No | rale | emp2_position_s |
employer2YearsEmployed | n/a | No | rale | emp2_yrs_l |
employer2MonthsEmployed | n/a | No | rale | emp2_mon_l |
employer2MonthlySalary | n/a | No | rale | emp2_salary_d |
previousEmployerName | n/a | No | rale | pemp_nam_s |
previousEmployerContact | n/a | No | rale | pemp_cont_s |
previousEmployerContactTitle | n/a | No | rale | pemp_cont_title_s |
previousEmployerAddress1 | n/a | No | rale | pemp_add_s |
previousEmployerAddress2 | n/a | No | rale | pemp_add2_s |
previousEmployerCity | n/a | No | rale | pemp_cty_s |
previousEmployerState | n/a | No | rale | pemp_st_s |
previousEmployerZipCode | n/a | No | rale | pemp_zip_s |
previousEmployerPhone | n/a | No | rale | pemp_phn_s |
previousEmployerPosition | n/a | No | rale | pemp_position_s |
previousEmployerYearsEmployed | n/a | No | rale | pemp_yrs_l |
previousEmployerMonthsEmployed | n/a | No | rale | pemp_mon_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 |
additionalIncomeSource | n/a | No | rgr | add_inc_src_s |
otherName | n/a | No | rgr | othr_nam_s |
otherAddress1 | n/a | No | rgr | othr_add_s |
otherAddress2 | n/a | No | rgr | othr_add2_s |
otherCity | n/a | No | rgr | othr_cty_s |
otherState | n/a | No | rgr | othr_st_s |
otherZipCode | n/a | No | rgr | othr_zip_s |
otherBusPhone | n/a | No | rgr | othr_bus_phn_s |
otherHomePhone | n/a | No | rgr | othr_home_phn_s |
OtherYearsResiding | n/a | No | rgr | othr_res_yrs_l |
OtherMonthsResiding | n/a | No | rgr | othr_res_mon_l |
employer1Name | n/a | No | rgr | emp1_nam_s |
employer1Contact | n/a | No | rgr | emp1_cont_s |
employer1ContactTitle | n/a | No | rgr | emp1_cont_title_s |
employer1Address1 | n/a | No | rgr | emp1_add_s |
employer1Address2 | n/a | No | rgr | emp1_add2_s |
employer1City | n/a | No | rgr | emp1_cty_s |
employer1State | n/a | No | rgr | emp1_st_s |
employer1ZipCode | n/a | No | rgr | emp1_zip_s |
employer1Phone | n/a | No | rgr | emp1_phn_s |
employer1Position | n/a | No | rgr | emp1_position_s |
employer1YearsEmployed | n/a | No | rgr | emp1_yrs_l |
employer1MonthsEmployed | n/a | No | rgr | emp1_mon_l |
employer1MonthlySalary | n/a | No | rgr | emp1_salary_d |
additionalIncome | n/a | No | rgr | add_inc_d |
employer1ReferenceStatus | n/a | No | rgr | emp1_ref_stat_s |
employer2Name | n/a | No | rgr | emp2_nam_s |
employer2Contact | n/a | No | rgr | emp2_cont_s |
employer2ContactTitle | n/a | No | rgr | emp2_cont_title_s |
employer2Address1 | n/a | No | rgr | emp2_add_s |
employer2Address2 | n/a | No | rgr | emp2_add2_s |
employer2City | n/a | No | rgr | emp2_cty_s |
employer2State | n/a | No | rgr | emp2_st_s |
employer2ZipCode | n/a | No | rgr | emp2_zip_s |
employer2Phone | n/a | No | rgr | emp2_phn_s |
employer2Position | n/a | No | rgr | emp2_position_s |
employer2YearsEmployed | n/a | No | rgr | emp2_yrs_l |
employer2MonthsEmployed | n/a | No | rgr | emp2_mon_l |
employer2MonthlySalary | n/a | No | rgr | emp2_salary_d |
employer2ReferenceStatus | n/a | No | rgr | emp2_ref_stat_s |
previousEmployerName | n/a | No | rgr | pemp_nam_s |
previousEmployerContact | n/a | No | rgr | pemp_cont_s |
previousEmployerContactTitle | n/a | No | rgr | pemp_cont_title_s |
previousEmployerAddress1 | n/a | No | rgr | pemp_add_s |
previousEmployerAddress2 | n/a | No | rgr | pemp_add2_s |
previousEmployerCity | n/a | No | rgr | pemp_cty_s |
previousEmployerState | n/a | No | rgr | pemp_st_s |
previousEmployerZipCode | n/a | No | rgr | pemp_zip_s |
previousEmployerPhone | n/a | No | rgr | pemp_phn_s |
previousEmployerPosition | n/a | No | rgr | pemp_position_s |
previousEmployerYearsEmployed | n/a | No | rgr | pemp_yrs_l |
previousEmployerMonthsEmployed | n/a | No | rgr | pemp_mon_l |
previousEmployerReferenceStatus | n/a | No | rgr | pemp_ref_stat_s |
activityStatus | n/a | No | rgr | act_stat_s |
addressType | n/a | No | rgr | addr_type_c |
addressStatus | n/a | No | rgr | addr_stat_c |
addressConfDate | n/a | No | rgr | d_addr_confirm_s |
addressConfTime | n/a | No | rgr | t_addr_confirm_s |
busIndicator | n/a | No | rgr | cb_business_c |
residenceType | n/a | No | rgr | res_stat_s |
birthDate | n/a | No | rgr | d_birth_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 |
alertNote | n/a | No | rlr | alrt_note_s |
authSignName | n/a | No | rlr | sign_s |
badDebtPerc | n/a | No | rlr | bad_debt_l |
county | n/a | No | rlr | cnty_s |
dateVendorAgreement | n/a | No | rlr | d_agr_s |
dateSuspenseOverride | n/a | No | rlr | d_alrt_susp_ovr_s |
dateFinancialStatement | n/a | No | rlr | d_fin_s |
vendorTaxID | n/a | No | rlr | dlr_tax_id_s |
fundingTaxCode | n/a | No | rlr | txp_s |
holdbackAllow | n/a | No | rlr | holdback_d |
insuranceBank | n/a | No | rlr | ins_bank_s |
maturingLeaseTeam | n/a | No | rlr | ml_team_s |
newOwner | n/a | No | rlr | new_own_s |
owner | n/a | No | rlr | own_s |
insurancePercentage | n/a | No | rlr | p_ins_l |
remittanceType | n/a | No | rlr | remit_s |
salespersonNumber | n/a | No | rlr | sales_s |
vertexTaxAreaId | n/a | No | rlr | vtx_taid_s |
alertSwitch1 | n/a | No | rlr | alrt_s |
alertSwitch2 | n/a | No | rlr | alrt_s |
alertSwitch3 | n/a | No | rlr | alrt_s |
alertSwitch4 | n/a | No | rlr | alrt_s |
alertSwitch5 | n/a | No | rlr | alrt_s |
alertSwitch6 | n/a | No | rlr | alrt_s |
alertAmt1 | n/a | No | rlr | alrt_amt1_d |
alertAmt2 | n/a | No | rlr | alrt_amt2_d |
alertAmt3 | n/a | No | rlr | alrt_amt3_d |
alertAmt4 | n/a | No | rlr | alrt_amt4_d |
alertAmt5 | n/a | No | rlr | alrt_amt5_d |
alertAmt6 | n/a | No | rlr | alrt_amt6_d |
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 |
county | n/a | No | rbk | cnty_s |
zipCode | n/a | Yes | rbk | zip_s |
busPhone | n/a | No | rbk | phn_s |
emailAddress | n/a | No | rbk | email_s |
fundingTaxCode | n/a | No | rbk | txp_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 |
estimatedTerm | n/a | No | rap | est_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 |
otherCharges | n/a | No | rap | tot_other_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 |
idc8 | n/a | No | rap | idc8_d |
idc9 | n/a | No | rap | idc9_d |
idcA | n/a | No | rap | idca_d |
idcB | n/a | No | rap | idcb_d |
idcC | n/a | No | rap | idcc_d |
idcD | n/a | No | rap | idcd_d |
idcE | n/a | No | rap | idce_d |
idcF | n/a | No | rap | idcf_d |
idcG | n/a | No | rap | idcg_d |
idcH | n/a | No | rap | idch_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 |
openingCommission | n/a | No | rap | open_comm_incm_d |
totalTaxCredit | n/a | No | rap | orig_tax_crd_d |
dealerReceivedPayments | n/a | No | rapa | dlr_rec_pmts_d |
principalWriteDown | n/a | No | rapa | prn_write_down_c |
dealerPaymentBankCode | n/a | No | rapa | 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 |
paymentHierarchyCode | n/a | No | rapa | pmt_hier_s |
poolID | n/a | No | rapa | pool_id_s |
papInstitutionACHtransitID | n/a | No | rapa | inst_id_s |
papAccountNumber | n/a | No | rapa | payer_acct_s |
papBankAccountName | n/a | No | rapa | payer_acct_nam_s |
papEffectiveDate | n/a | No | rapa | d_pap_eff_s |
vertexO | n/a | No | rapa | vtx_o_c |
interestFreeMonths | n/a | No | rapa | int_free_mths_l |
prepaidLease | n/a | No | rapa | prepaid_c |
autoPayInterval | n/a | No | rapa | auto_pay_interval_l |
idcAsc842Amount | n/a | No | rapa | idc_asc842_d |
autoPay | n/a | No | rapa | auto_pay_c |
autoPayStart | n/a | No | rapa | d_auto_pay_start_s |
autoPayStop | n/a | No | rapa | d_auto_pay_stop_s |
autoPayType | n/a | No | rapa | auto_pay_amt_type_c |
autoPayOtherAmt | n/a | No | rapa | auto_pay_other_amt_d |
pmtSource | n/a | No | rapa | pmt_source_s |
accrualCycle | n/a | Yes | rapa | accrual_cycle_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_34* | No | rapr | bundle_rcr_c |
recurringChargeMaturityDate_0 | recurringChargeMaturityDate_34* | No | rapr | d_mrcr_s |
recurringChargeBrkrPayable_0 | recurringChargeBrkrPayable_34* | No | rapr | rcr_pay_brk_s |
recurringChargeAmount_0 | recurringChargeAmount_34* | No | rapr | rcr_amt_d |
recurringChargeDealerPayable_0 | recurringChargeDealerPayable_34* | No | rapr | rcr_pay_dlr_s |
recurringChargeStartDate_0 | recurringChargeStartDate_34* | 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 |
subventionType_0 | subventionType_4* | No | rapv | subv_type_s |
progId1_0 | progId1_4* | No | rapv | subv_prog_id_1_s |
progId2_0 | progId2_4* | No | rapv | subv_prog_id_2_s |
buyRate_0 | buyRate_4* | No | rapv | p_subv_buy_rate_d |
subventionRate_0 | subventionRate_4* | No | rapv | p_subv_rate_d |
subventionAmount_0 | subventionAmount_4* | No | rapv | subv_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 |
dealerBonus | n/a | No | raq | idc6_d |
dealerBonusPayTo | n/a | No | raq | idc6_pay_to_s |
dealerReserve | n/a | No | raq | idc7_d |
dealerReservePayTo | n/a | No | raq | idc7_pay_to_s |
dealerPlancode | n/a | No | raq | idc7_dlr_plan_s |
bulletinPromoNumber | n/a | No | raq | dlr_res_promo_s |
programRate | n/a | No | raq | p_dlr_res_prog_rate_d |
buyRate | n/a | No | raq | p_dlr_res_buy_rate_d |
utilizeVehicleTaxRatesYN | n/a | No | raq | utilize_veh_tax_rates_c |
assessmentTaxclass | n/a | No | raq | assmt_tax_cls_s |
vertexTaxAreaId | n/a | No | raq | vtx_taid_s |
equipmentCounty | n/a | No | raq | eq_cnty_s |
taxPaymentType | n/a | No | raq | tax_pmt_typ_s |
upfrontTaxAdmOrig | n/a | No | raq | upf_ao_dlr_s |
supplementalDepreciationStartDate | n/a | No | raq | d_supp_depr_start_s |
supplementalDepreciationBasis | n/a | No | raq | supp_depr_basis_d |
supplementalDepreciationSalvage | n/a | No | raq | supp_depr_sal_d |
stateRate | n/a | No | raq | st_rate_d |
countyRate | n/a | No | raq | ct_rate_d |
cityRate | n/a | No | raq | cy_rate_d |
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 |
upfrontTaxDestTaid | n/a | No | rou | vtx_taid_s |
upfrontTaxDestState | n/a | No | rou | st_s |
upfrontTaxDestCounty | n/a | No | rou | cnty_s |
upfrontTaxDestCity | n/a | No | rou | cty_s |
upfrontTaxDestAddress | n/a | No | rou | add_s |
upfrontTaxDestAddress2 | n/a | No | rou | add2_s |
upfrontTaxDestZip | n/a | No | rou | zip_s |
upfrontTaxAdmOrigTaid | n/a | No | rou | vtx_taid_s |
upfrontTaxAdmOrigState | n/a | No | rou | st_s |
upfrontTaxAdmOrigCounty | n/a | No | rou | cnty_s |
upfrontTaxAdmOrigCity | n/a | No | rou | cty_s |
upfrontTaxAdmOrigAddress | n/a | No | rou | add_s |
upfrontTaxAdmOrigAddress2 | n/a | No | rou | add2_s |
upfrontTaxAdmOrigZip | n/a | No | rou | zip_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 |
udfField52 | n/a | No | rud | rum | ruj | rur | ruo | field52_s |
udfField53 | n/a | No | rud | rum | ruj | rur | ruo | field53_s |
udfField54 | n/a | No | rud | rum | ruj | rur | ruo | field54_s |
udfField55 | n/a | No | rud | rum | ruj | rur | ruo | field55_s |
udfField56 | n/a | No | rud | rum | ruj | rur | ruo | field56_s |
udfField57 | n/a | No | rud | rum | ruj | rur | ruo | field57_s |
udfField58 | n/a | No | rud | rum | ruj | rur | ruo | field58_s |
udfField59 | n/a | No | rud | rum | ruj | rur | ruo | field59_s |
udfField60 | n/a | No | rud | rum | ruj | rur | ruo | field60_s |
udfField61 | n/a | No | rud | rum | ruj | rur | ruo | field61_s |
udfField62 | n/a | No | rud | rum | ruj | rur | ruo | field62_s |
udfField63 | n/a | No | rud | rum | ruj | rur | ruo | field63_s |
udfField64 | n/a | No | rud | rum | ruj | rur | ruo | field64_s |
udfField65 | n/a | No | rud | rum | ruj | rur | ruo | field65_s |
udfField66 | n/a | No | rud | rum | ruj | rur | ruo | field66_s |
udfField67 | n/a | No | rud | rum | ruj | rur | ruo | field67_s |
udfField68 | n/a | No | rud | rum | ruj | rur | ruo | field68_s |
udfField69 | n/a | No | rud | rum | ruj | rur | ruo | field69_s |
udfField70 | n/a | No | rud | rum | ruj | rur | ruo | field70_s |
udfField71 | n/a | No | rud | rum | ruj | rur | ruo | field71_s |
udfField72 | n/a | No | rud | rum | ruj | rur | ruo | field72_s |
udfField73 | n/a | No | rud | rum | ruj | rur | ruo | field73_s |
udfField74 | n/a | No | rud | rum | ruj | rur | ruo | field74_s |
udfField75 | n/a | No | rud | rum | ruj | rur | ruo | field75_s |
udfField76 | n/a | No | rud | rum | ruj | rur | ruo | field76_s |
udfField77 | n/a | No | rud | rum | ruj | rur | ruo | field77_s |
udfField78 | n/a | No | rud | rum | ruj | rur | ruo | field78_s |
udfField79 | n/a | No | rud | rum | ruj | rur | ruo | field79_s |
udfField80 | n/a | No | rud | rum | ruj | rur | ruo | field80_s |
udfField81 | n/a | No | rud | rum | ruj | rur | ruo | field81_s |
udfField82 | n/a | No | rud | rum | ruj | rur | ruo | field82_s |
udfField83 | n/a | No | rud | rum | ruj | rur | ruo | field83_s |
udfField84 | n/a | No | rud | rum | ruj | rur | ruo | field84_s |
udfField85 | n/a | No | rud | rum | ruj | rur | ruo | field85_s |
udfField86 | n/a | No | rud | rum | ruj | rur | ruo | field86_s |
udfField87 | n/a | No | rud | rum | ruj | rur | ruo | field87_s |
udfField88 | n/a | No | rud | rum | ruj | rur | ruo | field88_s |
udfField89 | n/a | No | rud | rum | ruj | rur | ruo | field89_s |
udfField90 | n/a | No | rud | rum | ruj | rur | ruo | field90_s |
udfField91 | n/a | No | rud | rum | ruj | rur | ruo | field91_s |
udfField92 | n/a | No | rud | rum | ruj | rur | ruo | field92_s |
udfField93 | n/a | No | rud | rum | ruj | rur | ruo | field93_s |
udfField94 | n/a | No | rud | rum | ruj | rur | ruo | field94_s |
udfField95 | n/a | No | rud | rum | ruj | rur | ruo | field95_s |
udfField96 | n/a | No | rud | rum | ruj | rur | ruo | field96_s |
udfField97 | n/a | No | rud | rum | ruj | rur | ruo | field97_s |
udfField98 | n/a | No | rud | rum | ruj | rur | ruo | field98_s |
udfField99 | n/a | No | rud | rum | ruj | rur | ruo | field99_s |
udfField100 | n/a | No | rud | rum | ruj | rur | ruo | field100_s |
udfField101 | n/a | No | rud | rum | ruj | rur | ruo | field101_s |
udfField102 | n/a | No | rud | rum | ruj | rur | ruo | field102_s |
udfField103 | n/a | No | rud | rum | ruj | rur | ruo | field103_s |
udfField104 | n/a | No | rud | rum | ruj | rur | ruo | field104_s |
udfField105 | n/a | No | rud | rum | ruj | rur | ruo | field105_s |
udfField106 | n/a | No | rud | rum | ruj | rur | ruo | field106_s |
udfField107 | n/a | No | rud | rum | ruj | rur | ruo | field107_s |
udfField108 | n/a | No | rud | rum | ruj | rur | ruo | field108_s |
udfField109 | n/a | No | rud | rum | ruj | rur | ruo | field109_s |
udfField110 | n/a | No | rud | rum | ruj | rur | ruo | field110_s |
udfField111 | n/a | No | rud | rum | ruj | rur | ruo | field111_s |
udfField112 | n/a | No | rud | rum | ruj | rur | ruo | field112_s |
udfField113 | n/a | No | rud | rum | ruj | rur | ruo | field113_s |
udfField114 | n/a | No | rud | rum | ruj | rur | ruo | field114_s |
udfField115 | n/a | No | rud | rum | ruj | rur | ruo | field115_s |
udfField116 | n/a | No | rud | rum | ruj | rur | ruo | field116_s |
udfField117 | n/a | No | rud | rum | ruj | rur | ruo | field117_s |
udfField118 | n/a | No | rud | rum | ruj | rur | ruo | field118_s |
udfField119 | n/a | No | rud | rum | ruj | rur | ruo | field119_s |
udfField120 | n/a | No | rud | rum | ruj | rur | ruo | field120_s |
udfField121 | n/a | No | rud | rum | ruj | rur | ruo | field121_s |
udfField122 | n/a | No | rud | rum | ruj | rur | ruo | field122_s |
udfField123 | n/a | No | rud | rum | ruj | rur | ruo | field123_s |
udfField124 | n/a | No | rud | rum | ruj | rur | ruo | field124_s |
udfField125 | n/a | No | rud | rum | ruj | rur | ruo | field125_s |
udfField126 | n/a | No | rud | rum | ruj | rur | ruo | field126_s |
udfField127 | n/a | No | rud | rum | ruj | rur | ruo | field127_s |
udfField128 | n/a | No | rud | rum | ruj | rur | ruo | field128_s |
udfField129 | n/a | No | rud | rum | ruj | rur | ruo | field129_s |
udfField130 | n/a | No | rud | rum | ruj | rur | ruo | field130_s |
udfField131 | n/a | No | rud | rum | ruj | rur | ruo | field131_s |
udfField132 | n/a | No | rud | rum | ruj | rur | ruo | field132_s |
udfField133 | n/a | No | rud | rum | ruj | rur | ruo | field133_s |
udfField134 | n/a | No | rud | rum | ruj | rur | ruo | field134_s |
udfField135 | n/a | No | rud | rum | ruj | rur | ruo | field135_s |
udfField136 | n/a | No | rud | rum | ruj | rur | ruo | field136_s |
udfField137 | n/a | No | rud | rum | ruj | rur | ruo | field137_s |
udfField138 | n/a | No | rud | rum | ruj | rur | ruo | field138_s |
udfField139 | n/a | No | rud | rum | ruj | rur | ruo | field139_s |
udfField140 | n/a | No | rud | rum | ruj | rur | ruo | field140_s |
udfField141 | n/a | No | rud | rum | ruj | rur | ruo | field141_s |
udfField142 | n/a | No | rud | rum | ruj | rur | ruo | field142_s |
udfField143 | n/a | No | rud | rum | ruj | rur | ruo | field143_s |
udfField144 | n/a | No | rud | rum | ruj | rur | ruo | field144_s |
udfField145 | n/a | No | rud | rum | ruj | rur | ruo | field145_s |
udfField146 | n/a | No | rud | rum | ruj | rur | ruo | field146_s |
udfField147 | n/a | No | rud | rum | ruj | rur | ruo | field147_s |
udfField148 | n/a | No | rud | rum | ruj | rur | ruo | field148_s |
udfField149 | n/a | No | rud | rum | ruj | rur | ruo | field149_s |
udfField150 | n/a | No | rud | rum | ruj | rur | ruo | field150_s |
udfField151 | n/a | No | rud | rum | ruj | rur | ruo | field151_s |
udfField152 | n/a | No | rud | rum | ruj | rur | ruo | field152_s |
udfField153 | n/a | No | rud | rum | ruj | rur | ruo | field153_s |
udfField154 | n/a | No | rud | rum | ruj | rur | ruo | field154_s |
udfField155 | n/a | No | rud | rum | ruj | rur | ruo | field155_s |
udfField156 | n/a | No | rud | rum | ruj | rur | ruo | field156_s |
udfField157 | n/a | No | rud | rum | ruj | rur | ruo | field157_s |
udfField158 | n/a | No | rud | rum | ruj | rur | ruo | field158_s |
udfField159 | n/a | No | rud | rum | ruj | rur | ruo | field159_s |
udfField160 | n/a | No | rud | rum | ruj | rur | ruo | field160_s |
udfField161 | n/a | No | rud | rum | ruj | rur | ruo | field161_s |
udfField162 | n/a | No | rud | rum | ruj | rur | ruo | field162_s |
udfField163 | n/a | No | rud | rum | ruj | rur | ruo | field163_s |
udfField164 | n/a | No | rud | rum | ruj | rur | ruo | field164_s |
udfField165 | n/a | No | rud | rum | ruj | rur | ruo | field165_s |
udfField166 | n/a | No | rud | rum | ruj | rur | ruo | field166_s |
udfField167 | n/a | No | rud | rum | ruj | rur | ruo | field167_s |
udfField168 | n/a | No | rud | rum | ruj | rur | ruo | field168_s |
udfField169 | n/a | No | rud | rum | ruj | rur | ruo | field169_s |
udfField170 | n/a | No | rud | rum | ruj | rur | ruo | field170_s |
udfField171 | n/a | No | rud | rum | ruj | rur | ruo | field171_s |
udfField172 | n/a | No | rud | rum | ruj | rur | ruo | field172_s |
udfField173 | n/a | No | rud | rum | ruj | rur | ruo | field173_s |
udfField174 | n/a | No | rud | rum | ruj | rur | ruo | field174_s |
udfField175 | n/a | No | rud | rum | ruj | rur | ruo | field175_s |
udfField176 | n/a | No | rud | rum | ruj | rur | ruo | field176_s |
udfField177 | n/a | No | rud | rum | ruj | rur | ruo | field177_s |
udfField178 | n/a | No | rud | rum | ruj | rur | ruo | field178_s |
udfField179 | n/a | No | rud | rum | ruj | rur | ruo | field179_s |
udfField180 | n/a | No | rud | rum | ruj | rur | ruo | field180_s |
udfField181 | n/a | No | rud | rum | ruj | rur | ruo | field181_s |
udfField182 | n/a | No | rud | rum | ruj | rur | ruo | field182_s |
udfField183 | n/a | No | rud | rum | ruj | rur | ruo | field183_s |
udfField184 | n/a | No | rud | rum | ruj | rur | ruo | field184_s |
udfField185 | n/a | No | rud | rum | ruj | rur | ruo | field185_s |
udfField186 | n/a | No | rud | rum | ruj | rur | ruo | field186_s |
udfField187 | n/a | No | rud | rum | ruj | rur | ruo | field187_s |
udfField188 | n/a | No | rud | rum | ruj | rur | ruo | field188_s |
udfField189 | n/a | No | rud | rum | ruj | rur | ruo | field189_s |
udfField190 | n/a | No | rud | rum | ruj | rur | ruo | field190_s |
udfField191 | n/a | No | rud | rum | ruj | rur | ruo | field191_s |
udfField192 | n/a | No | rud | rum | ruj | rur | ruo | field192_s |
udfField193 | n/a | No | rud | rum | ruj | rur | ruo | field193_s |
udfField194 | n/a | No | rud | rum | ruj | rur | ruo | field194_s |
udfField195 | n/a | No | rud | rum | ruj | rur | ruo | field195_s |
udfField196 | n/a | No | rud | rum | ruj | rur | ruo | field196_s |
udfField197 | n/a | No | rud | rum | ruj | rur | ruo | field197_s |
udfField198 | n/a | No | rud | rum | ruj | rur | ruo | field198_s |
udfField199 | n/a | No | rud | rum | ruj | rur | ruo | field199_s |
udfField200 | n/a | No | rud | rum | ruj | rur | ruo | field200_s |
udfField201 | n/a | No | rud | rum | ruj | rur | ruo | field201_s |
udfField202 | n/a | No | rud | rum | ruj | rur | ruo | field202_s |
udfField203 | n/a | No | rud | rum | ruj | rur | ruo | field203_s |
udfField204 | n/a | No | rud | rum | ruj | rur | ruo | field204_s |
udfField205 | n/a | No | rud | rum | ruj | rur | ruo | field205_s |
udfField206 | n/a | No | rud | rum | ruj | rur | ruo | field206_s |
udfField207 | n/a | No | rud | rum | ruj | rur | ruo | field207_s |
udfField208 | n/a | No | rud | rum | ruj | rur | ruo | field208_s |
udfField209 | n/a | No | rud | rum | ruj | rur | ruo | field209_s |
udfField210 | n/a | No | rud | rum | ruj | rur | ruo | field210_s |
udfField211 | n/a | No | rud | rum | ruj | rur | ruo | field211_s |
udfField212 | n/a | No | rud | rum | ruj | rur | ruo | field212_s |
udfField213 | n/a | No | rud | rum | ruj | rur | ruo | field213_s |
udfField214 | n/a | No | rud | rum | ruj | rur | ruo | field214_s |
udfField215 | n/a | No | rud | rum | ruj | rur | ruo | field215_s |
udfField216 | n/a | No | rud | rum | ruj | rur | ruo | field216_s |
udfField217 | n/a | No | rud | rum | ruj | rur | ruo | field217_s |
udfField218 | n/a | No | rud | rum | ruj | rur | ruo | field218_s |
udfField219 | n/a | No | rud | rum | ruj | rur | ruo | field219_s |
udfField220 | n/a | No | rud | rum | ruj | rur | ruo | field220_s |
udfField221 | n/a | No | rud | rum | ruj | rur | ruo | field221_s |
udfField222 | n/a | No | rud | rum | ruj | rur | ruo | field222_s |
udfField223 | n/a | No | rud | rum | ruj | rur | ruo | field223_s |
udfField224 | n/a | No | rud | rum | ruj | rur | ruo | field224_s |
udfField225 | n/a | No | rud | rum | ruj | rur | ruo | field225_s |
udfField226 | n/a | No | rud | rum | ruj | rur | ruo | field226_s |
udfField227 | n/a | No | rud | rum | ruj | rur | ruo | field227_s |
udfField228 | n/a | No | rud | rum | ruj | rur | ruo | field228_s |
udfField229 | n/a | No | rud | rum | ruj | rur | ruo | field229_s |
udfField230 | n/a | No | rud | rum | ruj | rur | ruo | field230_s |
udfField231 | n/a | No | rud | rum | ruj | rur | ruo | field231_s |
udfField232 | n/a | No | rud | rum | ruj | rur | ruo | field232_s |
udfField233 | n/a | No | rud | rum | ruj | rur | ruo | field233_s |
udfField234 | n/a | No | rud | rum | ruj | rur | ruo | field234_s |
udfField235 | n/a | No | rud | rum | ruj | rur | ruo | field235_s |
udfField236 | n/a | No | rud | rum | ruj | rur | ruo | field236_s |
udfField237 | n/a | No | rud | rum | ruj | rur | ruo | field237_s |
udfField238 | n/a | No | rud | rum | ruj | rur | ruo | field238_s |
udfField239 | n/a | No | rud | rum | ruj | rur | ruo | field239_s |
udfField240 | n/a | No | rud | rum | ruj | rur | ruo | field240_s |
udfField241 | n/a | No | rud | rum | ruj | rur | ruo | field241_s |
udfField242 | n/a | No | rud | rum | ruj | rur | ruo | field242_s |
udfField243 | n/a | No | rud | rum | ruj | rur | ruo | field243_s |
udfField244 | n/a | No | rud | rum | ruj | rur | ruo | field244_s |
udfField245 | n/a | No | rud | rum | ruj | rur | ruo | field245_s |
udfField246 | n/a | No | rud | rum | ruj | rur | ruo | field246_s |
udfField247 | n/a | No | rud | rum | ruj | rur | ruo | field247_s |
udfField248 | n/a | No | rud | rum | ruj | rur | ruo | field248_s |
udfField249 | n/a | No | rud | rum | ruj | rur | ruo | field249_s |
udfField250 | n/a | No | rud | rum | ruj | rur | ruo | field250_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 |
*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. |