Table Name: WS20004
Description: This procedure allows the insert or update of records into the Mobile Contacts WORK table.
|
Element Name |
Data Type |
Length |
Required |
Default |
Description |
|---|---|---|---|---|---|
|
@I_vCUSTNMBR |
varchar |
15 |
Yes |
|
|
|
@I_vADRSCODE |
varchar |
15 |
Yes |
|
|
|
@I_vWS_Contact_Name |
varchar |
41 |
Yes |
|
|
|
@I_vE_Mail_Address |
varchar |
255 |
Yes |
|
|
|
@I_vPHONE1 |
varchar |
21 |
Yes |
|
|
|
@I_vContact_ID |
varchar |
15 |
No |
0 |
The value of 0 really means new contact |
|
@I_vPhone_ID |
varchar |
15 |
No |
0 |
The value of 0 really means new contact phone. |
|
@I_vContact_Role_Type |
varchar |
11 |
No |
null |
|
|
@I_vPhone_Type |
varchar |
13 |
No |
null |
|
|
@I_vMODIFDT |
datetime |
8 |
No |
null |
|
|
@I_vModified_Time |
datetime |
8 |
No |
null |
|
|
@I_vMDFUSRID |
varchar |
15 |
No |
null |
|
|
@I_vCREATDDT |
datetime |
8 |
No |
null |
|
|
@I_vCreated_Time |
datetime |
8 |
No |
null |
|
|
@I_vCRUSRID |
varchar |
15 |
No |
null |
|
|
@I_vMKTOPROC |
tinyint |
1 |
No |
null |
|
|
@I_vERMSGTXT |
varchar |
255 |
No |
null |
|
|
@I_vUSRDEFND1 |
varchar |
50 |
No |
null |
|
|
@I_vUSRDEFND2 |
varchar |
50 |
No |
null |
|
|
@I_vUSRDEFND3 |
varchar |
50 |
No |
null |
|
|
@I_vUSRDEFND4 |
varchar |
8000 |
No |
null |
|
|
@I_vUSRDEFND5 |
varchar |
8000 |
No |
null |
|
|
@I_vUpdateIfExists |
tinyint |
1 |
No |
0 |
|
|
@I_vSkipIfExists |
tinyint |
1 |
No |
0 |
|
|
@O_iErrorState |
int |
4 |
No |
0 |
|
|
@oErrString |
varchar |
255 |
No |
empty |
|