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 |
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. |