SMS_Build_Customer_Quicksearch
Table Name: SV00054
Other tables affected: None
Other stored procedures called: None
Description:
This procedure allows the insert/update of records into the Service Customer Quicksearch.
| Element Name | Data Type | Length | Required | Default | Description |
|---|---|---|---|---|---|
@I_vCustomerNumber | char | 15 | Yes |
| Validated in SV00100 and RM00101, convert to upper case |
@I_vAddressCode | char | 15 | Yes |
|
|
@I_vWennsoftAffiliate | char | 15 | Yes |
| Existing Affiliate in sv00015. Only required if 'Use Global Record Identification Records' is marked on in Service. Not Required on Updates |
@I_vWennsoftRegion | char | 15 | Yes |
| Existing Region in sv00015. Only required if 'Use Global Record Identification Records' is marked on in Service. Not Required on Updates |
@I_vWennsoftBranch | char | 15 | Yes |
| Existing Branch in sv00015. Only required if 'Use Global Record Identification Records' is marked on in Service. Not Required on Updates |
@I_vCustomerName | char | 65 | No |
|
|
@I_vLocationName | char | 31 | No |
|
|
@I_vAddress1 | char | 61 | No |
|
|
@I_vPhone1 | char | 21 | No | 00000000000000 | Defaults to zero.Is right padded to fill with zerosNot formatted (i.e. 262-821-4100 Ext: 3619 would be 26282141003619) Length can't be greater than 14 |
@I_vPhone2 | char | 21 | No | 00000000000000 | Defaults to zero.Is right padded to fill with zerosNot formatted (i.e. 262-821-4100 Ext: 3619 would be 26282141003619) Length can't be greater than 14 |
@I_vFax | char | 21 | No | 00000000000000 | Defaults to zero.Is right padded to fill with zerosNot formatted (i.e. 262-821-4100 Ext: 3619 would be 26282141003619) Length can't be greater than 14 |
@I_vZip | char | 11 | No |
|
|
@I_vUserDefine1a | char | 31 | No |
|
|
@I_vTimeZone | char | 3 | No |
|
|
@I_vWSPrimary | tinyint | 3 | No |
| With Customer and Primary Bill Address Code check to see if Primary and if it is then set to 1 |
@I_vGlobalCustomer | tinyint | 3 | No |
|
|
@I_vCity | char | 35 | No |
|
|
@I_vUpdateIfExists | tinyint | 3 | Yes | 1 | Defaults to 1. It can only be 0 for don't update or 1 update if exists |
@I_vWennSoftTablesOnly | tinyint | 3 | Yes | 0 | Defaults to false. |
@I_vOnlyValidate | tinyint | 3 | Yes | 0 | Defaults to false |
@I_vUSRDEFND1 | char | 50 | No |
|
|
@I_vUSRDEFND2 | char | 50 | No |
|
|
@I_vUSRDEFND3 | char | 50 | No |
|
|
@I_vUSRDEFND4 | varchar | 8000 | No |
|
|
@I_vUSRDEFND5 | varchar | 8000 | No |
|
|
@I_vReturnErrorText | tinyint | 3 | No | 1 | Defaults to false |
@O_iErrorState | int | 10 | No | 0 |
|
@oErrString | varchar | 255 | No |
|
|
Error Codes
| Error Code | Description |
|---|---|
51102 | The customer is empty |
51000 | Customer Number does not exist in Service |
51001 | Customer Number does not exist in Microsoft Business Solutions |
52189 | Address Code field is empty |
52177 | affiliate, region and branch are not valid |
52190 | Location Name field is empty |
52191 | Phone 1 field contains an invalid value (length > 14). |
52192 | Phone 2 field contains an invalid value (length > 14). |
52192 | Fax field contains an invalid value (length > 14). |