Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/SV00801
Product: WennSoft Products (131)
Series: 3rd Party
Display Name: SV_Labor_Load_Annual_Schedule
Physical Name: SV00801
Technical Name: SV_Labor_Load_Annual_ScheduleSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 Technician 
Technician STR10_LBAU String 10 2 CUSTNMBR Customer Number STR15_RM_Customer_Number String 15 Key to the RM Customer MSTR (RM00101).
Click to show/hide
SELECT
['SV_Labor_Load_Annual_Schedule'].CUSTNMBR AS 'SV_Labor_Load_Annual_Schedule-Customer Number'
,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number'
FROM
SV00801 AS ['SV_Labor_Load_Annual_Schedule']
INNER JOIN
RM00101 AS ['RM Customer MSTR']
ON
['SV_Labor_Load_Annual_Schedule'].CUSTNMBR = ['RM Customer MSTR'].CUSTNMBR3 LOCATNNM Location Name STR30 String 30 4 Contract_Number WS Contract Number STR10 String 10 5 WSCONTSQ WS Contract Number Sequence LI_Sequence_Number Long Integer 10 6 Burden_Hrs_Jan Burden Hrs Jan LI6_S2 Long Integer 6 7 Burden_Hrs_Feb Burden Hrs Feb LI6_S2 Long Integer 6 8 Burden_Hrs_Mar Burden Hrs Mar LI6_S2 Long Integer 6 9 Burden_Hrs_Apr Burden Hrs Apr LI6_S2 Long Integer 6 10 Burden_Hrs_May Burden Hrs May LI6_S2 Long Integer 6 11 Burden_Hrs_Jun Burden Hrs Jun LI6_S2 Long Integer 6 12 Burden_Hrs_Jul Burden Hrs Jul LI6_S2 Long Integer 6 13 Burden_Hrs_Aug Burden Hrs Aug LI6_S2 Long Integer 6 14 Burden_Hrs_Sep Burden Hrs Sep LI6_S2 Long Integer 6 15 Burden_Hrs_Oct Burden Hrs Oct LI6_S2 Long Integer 6 16 Burden_Hrs_Nov Burden Hrs Nov LI6_S2 Long Integer 6 17 Burden_Hrs_Dec Burden Hrs Dec LI6_S2 Long Integer 6 18 Available_MCC_Hours_Jan Available MCC Hours Jan LI6_S2 Long Integer 6 19 Available_MCC_Hours_Feb Available MCC Hours Feb LI6_S2 Long Integer 6 20 Available_MCC_Hours_Mar Available MCC Hours Mar LI6_S2 Long Integer 6 21 Available_MCC_Hours_Apr Available MCC Hours Apr LI6_S2 Long Integer 6 22 Available_MCC_Hours_May Available MCC Hours May LI6_S2 Long Integer 6 23 Available_MCC_Hours_Jun Available MCC Hours Jun LI6_S2 Long Integer 6 24 Available_MCC_Hours_Jul Available MCC Hours Jul LI6_S2 Long Integer 6 25 Available_MCC_Hours_Aug Available MCC Hours Aug LI6_S2 Long Integer 6 26 Available_MCC_Hours_Sep Available MCC Hours Sep LI6_S2 Long Integer 6 27 Available_MCC_Hours_Oct Available MCC Hours Oct LI6_S2 Long Integer 6 28 Available_MCC_Hours_Nov Available MCC Hours Nov LI6_S2 Long Integer 6 29 Available_MCC_Hours_Dec Available MCC Hours Dec LI6_S2 Long Integer 6 30 MC_Hours_Jan MC Hours Jan LI6_S2 Long Integer 6 31 MC_Hours_Feb MC Hours Feb LI6_S2 Long Integer 6 32 MC_Hours_Mar MC Hours Mar LI6_S2 Long Integer 6 33 MC_Hours_Apr MC Hours Apr LI6_S2 Long Integer 6 34 MC_Hours_May MC Hours May LI6_S2 Long Integer 6 35 MC_Hours_Jun MC Hours Jun LI6_S2 Long Integer 6 36 MC_Hours_Jul MC Hours Jul LI6_S2 Long Integer 6 37 MC_Hours_Aug MC Hours Aug LI6_S2 Long Integer 6 38 MC_Hours_Sep MC Hours Sep LI6_S2 Long Integer 6 39 MC_Hours_Oct MC Hours Oct LI6_S2 Long Integer 6 40 MC_Hours_Nov MC Hours Nov LI6_S2 Long Integer 6 41 MC_Hours_Dec MC Hours Dec LI6_S2 Long Integer 6 42 Est_Billable_Hours_Jan Estimate Billable Hours Jan LI6_S2 Long Integer 6 43 Est_Billable_Hours_Feb Estimate Billable Hours Feb LI6_S2 Long Integer 6 44 Est_Billable_Hours_Mar Estimate Billable Hours Mar LI6_S2 Long Integer 6 45 Est_Billable_Hours_Apr Estimate Billable Hours Apr LI6_S2 Long Integer 6 46 Est_Billable_Hours_May Estimate Billable Hours May LI6_S2 Long Integer 6 47 Est_Billable_Hours_Jun Estimate Billable Hours Jun LI6_S2 Long Integer 6 48 Est_Billable_Hours_Jul Estimate Billable Hours Jul LI6_S2 Long Integer 6 49 Est_Billable_Hours_Aug Estimate Billable Hours Aug LI6_S2 Long Integer 6 50 Est_Billable_Hours_Sep Estimate Billable Hours Sep LI6_S2 Long Integer 6 51 Est_Billable_Hours_Oct Estimate Billable Hours Oct LI6_S2 Long Integer 6 52 Est_Billable_Hours_Nov Estimate Billable Hours Nov LI6_S2 Long Integer 6 53 Est_Billable_Hours_Dec Estimate Billable Hours Dec LI6_S2 Long Integer 6 54 Jan_Est_Hours Jan Est Hours LI6_S2 Long Integer 6 55 Feb_Est_Hours Feb Est Hours LI6_S2 Long Integer 6 56 March_Est_Hours March Est Hours LI6_S2 Long Integer 6 57 April_Est_Hours April Est Hours LI6_S2 Long Integer 6 58 May_Est_Hours May Est Hours LI6_S2 Long Integer 6 59 June_Est_Hours June Est Hours LI6_S2 Long Integer 6 60 July_Est_Hours July Est Hours LI6_S2 Long Integer 6 61 Aug_Est_Hours Aug Est Hours LI6_S2 Long Integer 6 62 Sept_Est_Hours Sept Est Hours LI6_S2 Long Integer 6 63 Oct_Est_Hours Oct Est Hours LI6_S2 Long Integer 6 64 Nov_Est_Hours Nov Est Hours LI6_S2 Long Integer 6 65 Dec_Est_Hours Dec Est Hours LI6_S2 Long Integer 6 66 Task_Hours Task Hours LI6_S2 Long Integer 6 67 Jan_Required Jan Required CB Boolean 0 68 Feb_Required Feb Required CB Boolean 0 69 March_Required March Required CB Boolean 0 70 April_Required April Required CB Boolean 0 71 May_Required May Required CB Boolean 0 72 June_Required June Required CB Boolean 0 73 July_Required July Required CB Boolean 0 74 Aug_Required Aug Required CB Boolean 0 75 Sept_Required Sept Required CB Boolean 0 76 Oct_Required Oct Required CB Boolean 0 77 Nov_Required Nov Required CB Boolean 0 78 Dec_Required Dec Required CB Boolean 0 79 Total_Hours_Jan Total Hours Jan LI6_S2 Long Integer 6 80 Total_Hours_Feb Total Hours Feb LI6_S2 Long Integer 6 81 Total_Hours_Mar Total Hours Mar LI6_S2 Long Integer 6 82 Total_Hours_Apr Total Hours Apr LI6_S2 Long Integer 6 83 Total_Hours_May Total Hours May LI6_S2 Long Integer 6 84 Total_Hours_Jun Total Hours Jun LI6_S2 Long Integer 6 85 Total_Hours_Jul Total Hours Jul LI6_S2 Long Integer 6 86 Total_Hours_Aug Total Hours Aug LI6_S2 Long Integer 6 87 Total_Hours_Sep Total Hours Sep LI6_S2 Long Integer 6 88 Total_Hours_Oct Total Hours Oct LI6_S2 Long Integer 6 89 Total_Hours_Nov Total Hours Nov LI6_S2 Long Integer 6 90 Total_Hours_Dec Total Hours Dec LI6_S2 Long Integer 6 91 Estimate_Hours Estimate Hours LI6_S2 Long Integer 6 92 Total_ATS_PM_Hours Total ATS PM Hours LI6_S2 Long Integer 6 93 Total_All_Hours Total All Hours LI6_S2 Long Integer 6 94 Standard_Task_Hours Standard Task Hours LI6_S2 Long Integer 6