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

Leave a Reply

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