GP Tables

SV585CLP - SV_Contract_Tasks_TEMP

SQL Query Builder

38 Columns

Column Description Type Length
CUSTNMBR char(15)
ADRSCODE char(15)
Contract_Number char(11)
WSCONTSQ int
Task_Code char(11)
Equipment_ID char(31)
Contract_Task_List_ID char(11)
Technician_ID char(15)
Out_of_Service_Flag tinyint
Jan_Est_Hours int
Feb_Est_Hours int
March_Est_Hours int
April_Est_Hours int
May_Est_Hours int
June_Est_Hours int
July_Est_Hours int
Aug_Est_Hours int
Sept_Est_Hours int
Oct_Est_Hours int
Nov_Est_Hours int
Dec_Est_Hours int
Equipment_Type char(31)
Task_Description char(61)
Jan_Required tinyint
Feb_Required tinyint
March_Required tinyint
April_Required tinyint
May_Required tinyint
June_Required tinyint
July_Required tinyint
Aug_Required tinyint
Sept_Required tinyint
Oct_Required tinyint
Nov_Required tinyint
Dec_Required tinyint
USERID char(15)
Schedule_Description char(31)
DEX_ROW_ID int auto number (1,1)

Related Tables

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

DEX_ROW_ID

AAG00200 AAG00201 AAG00202 AAG00300 AAG00301 AAG00302 ACColumn AF00100

USERID

AAG50001 AAG60001 AAG70001 ACTIVITY AHPSLH01 APR_APR30000 APR_APR30300 ASIEXP100

CUSTNMBR

ASIEXP02 ASIEXP06 ASIEXP07 ASIEXP08 ASIEXP15 ASIEXP19 ASIEXP20 ASIEXP21

ADRSCODE

ASIEXP02 ASIEXP05 ASIEXP07 ASIEXP08 ASIEXP10 ASIEXP15 ASIEXP16 ASIEXP18

Technician_ID

JC00102 JC00106 JC20003 JC30001 JC30003 JC30006 JC40203 JC40204