GP Tables

SV30301 - SV_Appointment_History_MSTR

SQL Query Builder

33 Columns

Column Description Type Length
WS_Appointment_ID int
Appointment_Action char(17)
Service_Call_ID char(17)
Appointment char(25)
Appointment_Type smallint
Technician char(11)
Skill_Level char(15)
Task_Date datetime
STRTTIME datetime
ENDTIME datetime
Estimate_Hours int
Actual_Hours int
Technician_Status char(17)
Appointment_Status char(11)
Status_Date datetime
Status_Time datetime
Completion_Date datetime
Time_Entered_CB tinyint
CREATDDT datetime
CRUSRID char(15)
MODIFDT datetime
MDFUSRID char(15)
Modified_Time datetime
USERDEF1 char(21)
USERDEF2 char(21)
UDCB1 tinyint
UDCB2 tinyint
USRDAT01 datetime
USRDAT02 datetime
UserDD1 numeric(19,5)
UserDD2 numeric(19,5)
SV_Tool_ID int
DEX_ROW_ID int auto number (1,1)

Related Tables

Tables that share columns with SV30301. Click "Join" to add to your query.

DEX_ROW_ID

AAG00200 AAG00201 AAG00202 AAG00300 AAG00301 AAG00302 ACColumn AF00100

MODIFDT

ASIEXP01 ASIEXP02 ASIEXP03 ASIEXP04 ASIEXP06 ASIEXP07 ASIEXP09 ASIEXP11

MDFUSRID

ASIEXP09 ASIEXP19 ASIEXP22 CM20200 CM20300 CT00002 CT00102 CT40401

Modified_Time

PDK10500 JC00102 JC00103 JC00104 JC00106 JC00107 JC00201 JC00301

USERDEF1

ASIEXP01 ASIEXP02 ASIEXP03 ASIEXP05 ASIEXP06 ASIEXP07 ASIEXP08 ASIEXP09

USERDEF2

ASIEXP01 ASIEXP02 ASIEXP03 ASIEXP05 ASIEXP06 ASIEXP07 ASIEXP08 ASIEXP09