SV00301 - SV_Service_Appointments_MSTR | GP Tables

Column	Type	Shared With
Service_Call_ID	char(17)	44 tables
Appointment	char(25)	7 tables
Appointment_Type	smallint	3 tables
Technician	char(11)	33 tables
WS_Cost_Code	int	21 tables
WS_Job_Number	char(17)	90 tables
Cost_Code_Alias	char(27)	8 tables
Appointment_Group_ID	char(25)	1 tables
Appointment_Description	char(51)	1 tables
UPRTRXCD	char(7)	9 tables
Skill_Level	char(15)	19 tables
Task_Date	datetime	3 tables
STRTTIME	datetime	7 tables
ENDTIME	datetime	4 tables
Estimate_Hours	int	25 tables
Actual_Hours	int	11 tables
Technician_Status	char(17)	4 tables
Appointment_Status	char(11)	5 tables
Completion_Date	datetime	19 tables
Time_Entered_CB	tinyint	2 tables
Cancelled_Reason	char(25)	1 tables
CREATDDT	datetime	74 tables
CRUSRID	char(15)	27 tables
MODIFDT	datetime	394 tables
MDFUSRID	char(15)	349 tables
Modified_Time	datetime	326 tables
USERDEF1	char(21)	138 tables
USERDEF2	char(21)	138 tables
UDCB1	tinyint	5 tables
UDCB2	tinyint	5 tables
USRDAT01	datetime	100 tables
USRDAT02	datetime	98 tables
UserDD1	numeric(19,5)	5 tables
UserDD2	numeric(19,5)	5 tables
Service_User_Define_1	char(21)	123 tables
Service_User_Define_2	char(21)	123 tables
Service_User_Define_3	char(31)	129 tables
Service_User_Define_4	char(31)	121 tables
Service_User_Define_5	int	131 tables
Service_User_Define_6	int	131 tables
Service_User_Define_7	int	122 tables
Service_User_Define_8	int	122 tables
Service_User_Define_9	datetime	131 tables
Service_User_Define_10	datetime	131 tables
Service_User_Define_11	datetime	123 tables
Service_User_Define_12	datetime	123 tables
Service_User_Define_18	tinyint	131 tables
Service_User_Define_19	tinyint	131 tables
Service_User_Define_20	tinyint	122 tables
Service_User_Define_21	tinyint	121 tables
SV_Tool_ID	int	3 tables
DEX_ROW_ID	int auto number (1,1)	608 tables