/*<![CDATA[*/ div.rbtoc1765575882300 {padding: 0px;} div.rbtoc1765575882300 ul {list-style: disc;margin-left: 0px;} div.rbtoc1765575882300 li {margin-left: 0px;padding-left: 0px;} /*]]>*/ Table Name: SV00054 Error Codes
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). |