k2aJobAppointmentNote

Table Name: JC000805

Description: This procedure allows the insert or update of records into the Job Appointment Note MSTR table.

Element Name	Data Type	Length	Required	Default
@I_vWS_Job_Number	varchar	17	Yes
@I_vAppointment	varchar	25	Yes
@I_vTechnician	varchar	11	Yes
@I_vNote_Service_Index	varchar	25	Yes
@I_vWS_Note_Type	varchar	1	Yes
@I_vNote_Author	varchar	21	No	null
@I_vReminder	tinyint	1	No	null
@I_vReminder_Date	datetime	8	No	null
@I_vPrintable_Group	smallint	2	No	null
@I_vCREATDDT	datetime	8	No	null
@I_vCreated_Time	datetime	8	No	null
@I_vCRUSRID	varchar	15	No	null
@I_vMODIFDT	datetime	8	No	null
@I_vModified_Time	datetime	8	No	null
@I_vMDFUSRID	varchar	15	No	null
@I_vRecord_Notes	varchar	8000	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