k2aMobileContactWork

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