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 |
Description |
|---|---|---|---|---|---|
|
@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 |
|