Response Reference Grid
LeasePak Documentation Suite NETSOL website
retrieve

(mPower icon) LPVendor

retrieve

Response Reference Grid

Response
    Occurs   LeasePak Database Datatype  
Level Element Min Max Type Table Column Oracle Sybase Description
1 LP_RESPONSE_INFO 1 1 Root Element
1.1 VENDOR_INFO 0 1 Element
1.1.1 VENDOR_RECORD 1 1 Element
1.1.1.1 portfolio 1 1 String (2) def_por_s
1.1.1.2 company 1 1 String (2) def_com_s
1.1.1.3 region 1 1 String (2) def_reg_s
1.1.1.4 office 1 1 String (3) def_off_s
1.1.1.5 clientNumber 1 1 String (9) dlr_s
1.1.1.6 name 1 1 String (125) nam_long_s
1.1.1.7 address1 1 1 String (36) add_s
1.1.1.8 address2 0 1 String (36) add2_s
1.1.1.9 city 1 1 String (25) cty_s
1.1.1.10 state 1 1 String (2) st_s
1.1.1.11 zipCode 1 1 String (9) zip_s
1.1.1.12 busPhone 0 1 String (10) phn_s
1.1.1.13 emailAddress 0 1 String (50) email_s
1.1.1.14 papInstID 0 1 String (9) inst_id_s
1.1.1.15 papAchType 0 1 String (4) ach_type_s
1.1.1.16 papAccount 0 1 String (17) payer_acct_s
1.1.1.17 rateplanGroup 0 1 String (4) plan_s
1.1.1.18 letterVersionCode 0 1 String (4) lt_version_s
1.1.1.19 contactName1 0 1 String (36) cont_nam1_s
1.1.1.20 contactName2 0 1 String (36) cont_nam2_s
1.1.1.21 vendorParticipationCode 0 1 String (4) part_s
1.1.1.22 activityStatus 0 1 String (4) stat_s
1.1.1.23 remittanceName 0 1 String (36) rmt_nam_s
1.1.1.24 remittanceAddress 0 1 String (36) rmt_add_s
1.1.1.25 remittanceAddress2 0 1 String (36) rmt_add2_s
1.1.1.26 remittanceCity 0 1 String (25) rmt_cty_s
1.1.1.27 remittanceState 0 1 String (2) rmt_st_s
1.1.1.28 remittanceZipCode 0 1 String (9) rmt_zip_s
1.1.1.29 contactTitle1 0 1 String (25) cont_title1_s
1.1.1.30 contactTitle2 0 1 String (25) cont_title2_s
1.1.1.31 recourseType 0 1 String (4) rec_s
1.1.1.32 prenotificationSentYN 0 1 String (1) prenote_sent_c
1.1.1.33 datePrenotificationSentOn 0 1 Date d_prenote_sent_on_s
1.1.1.34 vendorType 0 1 String (4) vend_type_s
1.1.1.35 fundingTaxCode 0 1 String (4) txp_s
Applicable codes are: CITY, CNTY, CNCI, STAT, STCI, STCN ALL.
1.1.1.36 ssnBusinessID 0 1 String (20) ss_s
1.1.1.37 shortname 1 1 String (25) client_s_name_s
1.1.1.38 alertNote 0 1 String (255) alrt_note_s
1.1.1.39 authSignName 0 1 String (36) auth_sign_s
1.1.1.40 badDebtPerc 0 1 Decimal (15,5) bad_debt_d
1.1.1.41 county 0 1 String (60) cnty_s
1.1.1.42 dateVendorAgreement 0 1 Date d_agr_s
1.1.1.43 dateSuspenseOverride 0 1 Date d_alrt_susp_ovr_s
1.1.1.44 dateFinancialStatement 0 1 Date d_fin_s
1.1.1.45 vendorTaxID 0 1 String (36) dlr_tax_id_s
1.1.1.46 holdbackAllow 0 1 Decimal (15,2) holdback_d
1.1.1.47 insuranceBank 0 1 String (3) ins_bank_s
1.1.1.48 maturingLeaseTeam 0 1 String (4) ml_team_s
1.1.1.49 newOwner 0 1 String (3) new_own_s
1.1.1.50 owner 0 1 String (36) own_s
1.1.1.51 insurancePercentage 0 1 Decimal (15,5) p_ins_d
1.1.1.52 remittanceType 0 1 String (4) remit_type_s
1.1.1.53 salespersonNumber 0 1 String (4) sales_s
1.1.1.54 vertexTaxAreaId 0 1 String (10) vtx_taid_s
1.1.1.55 alertSwitch[1:6] 0 1 String (1) alrt_s
1.1.1.56 alertAmt[1:6] 0 1 Decimal (15,2) alrt_amt1_d
1.1.1.57 dcxChecksum 1 1 String (32) 32 characters checksum of the client record.
1.1.1.58 clientRelChecksum 1 1 String (32) 32 characters client checksum of the vendor record.
1.1.2 UDF_FIELDS_RECORD 0 1 Element
1.1.2.1 udfType 1 1 String (3) udf_type_s
1.1.2.2 udfKey 1 1 String (9) dlr_s
1.1.2.3 checksum 1 1 String (32) Checksum value
1.1.2.4 udfField[1:250] 0 1 String (36) field1_s
1.1.3 UDT_FIELDS_RECORD 0 36 Element
1.1.3.1 recordNumber 1 1 Number unique_l
1.1.3.2 udtKey 1 1 String (9) dlr_s
1.1.3.3 udtchecksum 1 1 String (32) Checksum value
1.1.3.4 udtTable[1:12] 0 1 String (12) table1_s
1.2 RESULT_RECORD 0 1 Element
1.2.1 TYPE 1 1 String (10) INFO/ERROR
1.2.2 RECORD 0 1 String (20) VENDOR
1.2.3 KEY 0 1 String (10) Record identifier
1.2.4 FIELD 0 1 String (50) Element name
1.2.5 MSGCODE 0 1 String (4) msgcode_l
1.2.6 MSGTEXT 1 1 String (255) msgtext_s

Response Codes

Following are the possible response codes with their messages:

Response Codes
Code Message
0 Successful.
1037 Input Required.
6046 User is not authorized to perform this operation.
7005 The update has been cancelled because the record was modified by another user. Please re-enter your update.
7025 Vendor does not exist.