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 |
Following are the possible response codes with their messages:
Response Codes | |||
Code | Message | ||
1037 | Input Required. | ||
7070 | Customer does not exist. |