Response Reference Grid
LeasePak Documentation Suite NETSOL website
retrieve

(mPower icon) LPCustomer

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 CUSTOMER_INFO 0 1 Element
1.1.1 CUSTOMER_RECORD 1 1 Element
1.1.1.1 portfolio 1 1 String (2) def_por_s
1.1.1.2 company 0 1 String (2) def_com_s
1.1.1.3 region 0 1 String (2) def_reg_s
1.1.1.4 office 0 1 String (3) def_off_s
1.1.1.5 clientNumber 0 1 String (9) cus_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) bus_phn_s
1.1.1.13 homePhone 0 1 String (10) phn_s
1.1.1.14 homePhoneType 0 1 String (4) hom_phn_type_s
1.1.1.15 busPhoneType 0 1 String (4) bus_phn_type_s
1.1.1.16 emailAddress 0 1 String (50) email_s
1.1.1.17 parentCustomer 0 1 String (9) par_cus_s
1.1.1.18 contactName 0 1 String (36) cont_nam_s
1.1.1.19 contactTitle 0 1 String (25) cont_title_s
1.1.1.20 billingName 0 1 String (36) bill_nam_s
1.1.1.21 billingAddress1 0 1 String (36) bill_add_s
1.1.1.22 billingAddress2 0 1 String (36) bill_add2_s
1.1.1.23 billingCity 0 1 String (25) bill_cty_s
1.1.1.24 billingState 0 1 String (2) bill_st_s
1.1.1.25 billingZipCode 0 1 String (9) bill_zip_s
1.1.1.26 letterVersionCode 0 1 String (4) lt_version_s
1.1.1.27 paymentHierarchyCode 0 1 String (4) pmt_hier_s
1.1.1.28 ssnBusinessID 0 1 String (20) ss_s
1.1.1.29 shortname 1 1 String (25) client_s_name_s
1.1.1.30 lastPhoneUsed 0 1 String (25) last_phn_used_c
1.1.1.31 collectionTeam 0 1 String (4) col_team_s
1.1.1.32 drawdownDate 0 1 Date d_drawdown_exp_s
1.1.1.33 dateFinancialStatement 0 1 Date d_fin_s
1.1.1.34 revolvingCrdExpDate 0 1 Date d_revolving_exp_s
1.1.1.35 drawdownCrdLimit 0 1 Decimal (15,2) drawdown_limit_d
1.1.1.36 revolvingCrdLimit 0 1 Decimal (15,2) revolving_limit_d
1.1.1.37 clientRelChecksum 1 1 String (32) Checksum value
1.1.1.38 dcxChecksum 1 1 String (32) Checksum value
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) cus_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) cus_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) CUSTOMER
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
1037 Input Required.
7070 Customer does not exist.