SV_Labor_Load_Annual_Schedule (SV00801)

azurecurveProductsWennSoft Products (131)3rd PartySV_Labor_Load_Annual_Schedule (SV00801)

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_Schedule

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1Technician SearchTechnicianSTR10_LBAUString10
2CUSTNMBR SearchCustomer NumberSTR15_RM_Customer_NumberString15
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'].CUSTNMBR
3LOCATNNM SearchLocation NameSTR30String30
4Contract_Number SearchWS Contract NumberSTR10String10
5WSCONTSQ SearchWS Contract Number SequenceLI_Sequence_NumberLong Integer10
6Burden_Hrs_Jan SearchBurden Hrs JanLI6_S2Long Integer6
7Burden_Hrs_Feb SearchBurden Hrs FebLI6_S2Long Integer6
8Burden_Hrs_Mar SearchBurden Hrs MarLI6_S2Long Integer6
9Burden_Hrs_Apr SearchBurden Hrs AprLI6_S2Long Integer6
10Burden_Hrs_May SearchBurden Hrs MayLI6_S2Long Integer6
11Burden_Hrs_Jun SearchBurden Hrs JunLI6_S2Long Integer6
12Burden_Hrs_Jul SearchBurden Hrs JulLI6_S2Long Integer6
13Burden_Hrs_Aug SearchBurden Hrs AugLI6_S2Long Integer6
14Burden_Hrs_Sep SearchBurden Hrs SepLI6_S2Long Integer6
15Burden_Hrs_Oct SearchBurden Hrs OctLI6_S2Long Integer6
16Burden_Hrs_Nov SearchBurden Hrs NovLI6_S2Long Integer6
17Burden_Hrs_Dec SearchBurden Hrs DecLI6_S2Long Integer6
18Available_MCC_Hours_Jan SearchAvailable MCC Hours JanLI6_S2Long Integer6
19Available_MCC_Hours_Feb SearchAvailable MCC Hours FebLI6_S2Long Integer6
20Available_MCC_Hours_Mar SearchAvailable MCC Hours MarLI6_S2Long Integer6
21Available_MCC_Hours_Apr SearchAvailable MCC Hours AprLI6_S2Long Integer6
22Available_MCC_Hours_May SearchAvailable MCC Hours MayLI6_S2Long Integer6
23Available_MCC_Hours_Jun SearchAvailable MCC Hours JunLI6_S2Long Integer6
24Available_MCC_Hours_Jul SearchAvailable MCC Hours JulLI6_S2Long Integer6
25Available_MCC_Hours_Aug SearchAvailable MCC Hours AugLI6_S2Long Integer6
26Available_MCC_Hours_Sep SearchAvailable MCC Hours SepLI6_S2Long Integer6
27Available_MCC_Hours_Oct SearchAvailable MCC Hours OctLI6_S2Long Integer6
28Available_MCC_Hours_Nov SearchAvailable MCC Hours NovLI6_S2Long Integer6
29Available_MCC_Hours_Dec SearchAvailable MCC Hours DecLI6_S2Long Integer6
30MC_Hours_Jan SearchMC Hours JanLI6_S2Long Integer6
31MC_Hours_Feb SearchMC Hours FebLI6_S2Long Integer6
32MC_Hours_Mar SearchMC Hours MarLI6_S2Long Integer6
33MC_Hours_Apr SearchMC Hours AprLI6_S2Long Integer6
34MC_Hours_May SearchMC Hours MayLI6_S2Long Integer6
35MC_Hours_Jun SearchMC Hours JunLI6_S2Long Integer6
36MC_Hours_Jul SearchMC Hours JulLI6_S2Long Integer6
37MC_Hours_Aug SearchMC Hours AugLI6_S2Long Integer6
38MC_Hours_Sep SearchMC Hours SepLI6_S2Long Integer6
39MC_Hours_Oct SearchMC Hours OctLI6_S2Long Integer6
40MC_Hours_Nov SearchMC Hours NovLI6_S2Long Integer6
41MC_Hours_Dec SearchMC Hours DecLI6_S2Long Integer6
42Est_Billable_Hours_Jan SearchEstimate Billable Hours JanLI6_S2Long Integer6
43Est_Billable_Hours_Feb SearchEstimate Billable Hours FebLI6_S2Long Integer6
44Est_Billable_Hours_Mar SearchEstimate Billable Hours MarLI6_S2Long Integer6
45Est_Billable_Hours_Apr SearchEstimate Billable Hours AprLI6_S2Long Integer6
46Est_Billable_Hours_May SearchEstimate Billable Hours MayLI6_S2Long Integer6
47Est_Billable_Hours_Jun SearchEstimate Billable Hours JunLI6_S2Long Integer6
48Est_Billable_Hours_Jul SearchEstimate Billable Hours JulLI6_S2Long Integer6
49Est_Billable_Hours_Aug SearchEstimate Billable Hours AugLI6_S2Long Integer6
50Est_Billable_Hours_Sep SearchEstimate Billable Hours SepLI6_S2Long Integer6
51Est_Billable_Hours_Oct SearchEstimate Billable Hours OctLI6_S2Long Integer6
52Est_Billable_Hours_Nov SearchEstimate Billable Hours NovLI6_S2Long Integer6
53Est_Billable_Hours_Dec SearchEstimate Billable Hours DecLI6_S2Long Integer6
54Jan_Est_Hours SearchJan Est HoursLI6_S2Long Integer6
55Feb_Est_Hours SearchFeb Est HoursLI6_S2Long Integer6
56March_Est_Hours SearchMarch Est HoursLI6_S2Long Integer6
57April_Est_Hours SearchApril Est HoursLI6_S2Long Integer6
58May_Est_Hours SearchMay Est HoursLI6_S2Long Integer6
59June_Est_Hours SearchJune Est HoursLI6_S2Long Integer6
60July_Est_Hours SearchJuly Est HoursLI6_S2Long Integer6
61Aug_Est_Hours SearchAug Est HoursLI6_S2Long Integer6
62Sept_Est_Hours SearchSept Est HoursLI6_S2Long Integer6
63Oct_Est_Hours SearchOct Est HoursLI6_S2Long Integer6
64Nov_Est_Hours SearchNov Est HoursLI6_S2Long Integer6
65Dec_Est_Hours SearchDec Est HoursLI6_S2Long Integer6
66Task_Hours SearchTask HoursLI6_S2Long Integer6
67Jan_Required SearchJan RequiredCBBoolean0
68Feb_Required SearchFeb RequiredCBBoolean0
69March_Required SearchMarch RequiredCBBoolean0
70April_Required SearchApril RequiredCBBoolean0
71May_Required SearchMay RequiredCBBoolean0
72June_Required SearchJune RequiredCBBoolean0
73July_Required SearchJuly RequiredCBBoolean0
74Aug_Required SearchAug RequiredCBBoolean0
75Sept_Required SearchSept RequiredCBBoolean0
76Oct_Required SearchOct RequiredCBBoolean0
77Nov_Required SearchNov RequiredCBBoolean0
78Dec_Required SearchDec RequiredCBBoolean0
79Total_Hours_Jan SearchTotal Hours JanLI6_S2Long Integer6
80Total_Hours_Feb SearchTotal Hours FebLI6_S2Long Integer6
81Total_Hours_Mar SearchTotal Hours MarLI6_S2Long Integer6
82Total_Hours_Apr SearchTotal Hours AprLI6_S2Long Integer6
83Total_Hours_May SearchTotal Hours MayLI6_S2Long Integer6
84Total_Hours_Jun SearchTotal Hours JunLI6_S2Long Integer6
85Total_Hours_Jul SearchTotal Hours JulLI6_S2Long Integer6
86Total_Hours_Aug SearchTotal Hours AugLI6_S2Long Integer6
87Total_Hours_Sep SearchTotal Hours SepLI6_S2Long Integer6
88Total_Hours_Oct SearchTotal Hours OctLI6_S2Long Integer6
89Total_Hours_Nov SearchTotal Hours NovLI6_S2Long Integer6
90Total_Hours_Dec SearchTotal Hours DecLI6_S2Long Integer6
91Estimate_Hours SearchEstimate HoursLI6_S2Long Integer6
92Total_ATS_PM_Hours SearchTotal ATS PM HoursLI6_S2Long Integer6
93Total_All_Hours SearchTotal All HoursLI6_S2Long Integer6
94Standard_Task_Hours SearchStandard Task HoursLI6_S2Long Integer6
azurecurveProductsWennSoft Products (131)3rd PartySV_Labor_Load_Annual_Schedule (SV00801)

Leave a Reply

Your email address will not be published. Required fields are marked *