SV_Technician_Labor_Plan_MSTR (sv00150)

azurecurveProductsWennSoft Products (131)3rd PartySV_Technician_Labor_Plan_MSTR (sv00150)

Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/sv00150

Product: WennSoft Products (131)
Series: 3rd Party

Display Name: SV_Technician_Labor_Plan_MSTR
Physical Name: sv00150
Technical Name: SV_Technician_Labor_Plan_MSTR

Group Display Name: SERVICE
Group Technical Name: SERVICE

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1Technician_ID SearchTechnician IDSTR15_Employee_IDString1615
2YEAR1 SearchYearYearInteger24
3Wennsoft_Affiliate SearchWennsoft AffiliateSTR15_LBAUString1615
4Wennsoft_Region SearchWennsoft RegionSTR15_LBAUString1615
5Wennsoft_Branch SearchWennsoft BranchSTR15_LBAUString1615
6USERID SearchUser IDSTR15_User_IDString1615
Key to the Users Master (SY01400).

Click to show/hide

SELECT
       ['SV_Technician_Labor_Plan_MSTR'].USERID AS 'SV_Technician_Labor_Plan_MSTR-User ID'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       sv00150 AS ['SV_Technician_Labor_Plan_MSTR']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['SV_Technician_Labor_Plan_MSTR'].USERID = ['Users Master'].USERID
7Technician_Team SearchTechnician TeamSTR15_LBAUString1615
8Burden_Hrs_Jan SearchBurden Hrs JanLI6_S2Long Integer46
9Burden_Hrs_Feb SearchBurden Hrs FebLI6_S2Long Integer46
10Burden_Hrs_Mar SearchBurden Hrs MarLI6_S2Long Integer46
11Burden_Hrs_Apr SearchBurden Hrs AprLI6_S2Long Integer46
12Burden_Hrs_May SearchBurden Hrs MayLI6_S2Long Integer46
13Burden_Hrs_Jun SearchBurden Hrs JunLI6_S2Long Integer46
14Burden_Hrs_Jul SearchBurden Hrs JulLI6_S2Long Integer46
15Burden_Hrs_Aug SearchBurden Hrs AugLI6_S2Long Integer46
16Burden_Hrs_Sep SearchBurden Hrs SepLI6_S2Long Integer46
17Burden_Hrs_Oct SearchBurden Hrs OctLI6_S2Long Integer46
18Burden_Hrs_Nov SearchBurden Hrs NovLI6_S2Long Integer46
19Burden_Hrs_Dec SearchBurden Hrs DecLI6_S2Long Integer46
20Available_MCC_Hours_Jan SearchAvailable MCC Hours JanLI6_S2Long Integer46
21Available_MCC_Hours_Feb SearchAvailable MCC Hours FebLI6_S2Long Integer46
22Available_MCC_Hours_Mar SearchAvailable MCC Hours MarLI6_S2Long Integer46
23Available_MCC_Hours_Apr SearchAvailable MCC Hours AprLI6_S2Long Integer46
24Available_MCC_Hours_May SearchAvailable MCC Hours MayLI6_S2Long Integer46
25Available_MCC_Hours_Jun SearchAvailable MCC Hours JunLI6_S2Long Integer46
26Available_MCC_Hours_Jul SearchAvailable MCC Hours JulLI6_S2Long Integer46
27Available_MCC_Hours_Aug SearchAvailable MCC Hours AugLI6_S2Long Integer46
28Available_MCC_Hours_Sep SearchAvailable MCC Hours SepLI6_S2Long Integer46
29Available_MCC_Hours_Oct SearchAvailable MCC Hours OctLI6_S2Long Integer46
30Available_MCC_Hours_Nov SearchAvailable MCC Hours NovLI6_S2Long Integer46
31Available_MCC_Hours_Dec SearchAvailable MCC Hours DecLI6_S2Long Integer46
32MC_Hours_Jan SearchMC Hours JanLI6_S2Long Integer46
33MC_Hours_Feb SearchMC Hours FebLI6_S2Long Integer46
34MC_Hours_Mar SearchMC Hours MarLI6_S2Long Integer46
35MC_Hours_Apr SearchMC Hours AprLI6_S2Long Integer46
36MC_Hours_May SearchMC Hours MayLI6_S2Long Integer46
37MC_Hours_Jun SearchMC Hours JunLI6_S2Long Integer46
38MC_Hours_Jul SearchMC Hours JulLI6_S2Long Integer46
39MC_Hours_Aug SearchMC Hours AugLI6_S2Long Integer46
40MC_Hours_Sep SearchMC Hours SepLI6_S2Long Integer46
41MC_Hours_Oct SearchMC Hours OctLI6_S2Long Integer46
42MC_Hours_Nov SearchMC Hours NovLI6_S2Long Integer46
43MC_Hours_Dec SearchMC Hours DecLI6_S2Long Integer46
44Est_Billable_Hours_Jan SearchEstimate Billable Hours JanLI6_S2Long Integer46
45Est_Billable_Hours_Feb SearchEstimate Billable Hours FebLI6_S2Long Integer46
46Est_Billable_Hours_Mar SearchEstimate Billable Hours MarLI6_S2Long Integer46
47Est_Billable_Hours_Apr SearchEstimate Billable Hours AprLI6_S2Long Integer46
48Est_Billable_Hours_May SearchEstimate Billable Hours MayLI6_S2Long Integer46
49Est_Billable_Hours_Jun SearchEstimate Billable Hours JunLI6_S2Long Integer46
50Est_Billable_Hours_Jul SearchEstimate Billable Hours JulLI6_S2Long Integer46
51Est_Billable_Hours_Aug SearchEstimate Billable Hours AugLI6_S2Long Integer46
52Est_Billable_Hours_Sep SearchEstimate Billable Hours SepLI6_S2Long Integer46
53Est_Billable_Hours_Oct SearchEstimate Billable Hours OctLI6_S2Long Integer46
54Est_Billable_Hours_Nov SearchEstimate Billable Hours NovLI6_S2Long Integer46
55Est_Billable_Hours_Dec SearchEstimate Billable Hours DecLI6_S2Long Integer46
56Actual_Paid_Hours_Jan SearchActual Paid Hours JanLI6_S2Long Integer46
57Actual_Paid_Hours_Feb SearchActual Paid Hours FebLI6_S2Long Integer46
58Actual_Paid_Hours_Mar SearchActual Paid Hours MarLI6_S2Long Integer46
59Actual_Paid_Hours_Apr SearchActual Paid Hours AprLI6_S2Long Integer46
60Actual_Paid_Hours_May SearchActual Paid Hours MayLI6_S2Long Integer46
61Actual_Paid_Hours_Jun SearchActual Paid Hours JunLI6_S2Long Integer46
62Actual_Paid_Hours_Jul SearchActual Paid Hours JulLI6_S2Long Integer46
63Actual_Paid_Hours_Aug SearchActual Paid Hours AugLI6_S2Long Integer46
64Actual_Paid_Hours_Sep SearchActual Paid Hours SepLI6_S2Long Integer46
65Actual_Paid_Hours_Oct SearchActual Paid Hours OctLI6_S2Long Integer46
66Actual_Paid_Hours_Nov SearchActual Paid Hours NovLI6_S2Long Integer46
67Actual_Paid_Hours_Dec SearchActual Paid Hours DecLI6_S2Long Integer46
68MC_Hours_Calc_Date SearchMC Hours Calc DateDATEDate46
69Actual_MCC_Hours_Jan SearchActual MCC Hours JanLI6_S2Long Integer46
70Actual_MCC_Hours_Feb SearchActual MCC Hours FebLI6_S2Long Integer46
71Actual_MCC_Hours_Mar SearchActual MCC Hours MarLI6_S2Long Integer46
72Actual_MCC_Hours_Apr SearchActual MCC Hours AprLI6_S2Long Integer46
73Actual_MCC_Hours_May SearchActual MCC Hours MayLI6_S2Long Integer46
74Actual_MCC_Hours_Jun SearchActual MCC Hours JunLI6_S2Long Integer46
75Actual_MCC_Hours_July SearchActual MCC Hours JulyLI6_S2Long Integer46
76Actual_MCC_Hours_Aug SearchActual MCC Hours AugLI6_S2Long Integer46
77Actual_MCC_Hours_Sep SearchActual MCC Hours SepLI6_S2Long Integer46
78Actual_MCC_Hours_Oct SearchActual MCC Hours OctLI6_S2Long Integer46
79Actual_MCC_Hours_Nov SearchActual MCC Hours NovLI6_S2Long Integer46
80Actual_MCC_Hours_Dec SearchActual MCC Hours DecLI6_S2Long Integer46
81Actual_Non_MCC_Hours_Jan SearchActual Non MCC Hours JanLI6_S2Long Integer46
82Actual_Non_MCC_Hours_Feb SearchActual Non MCC Hours FebLI6_S2Long Integer46
83Actual_Non_MCC_Hours_Mar SearchActual Non MCC Hours MarLI6_S2Long Integer46
84Actual_Non_MCC_Hours_Apr SearchActual Non MCC Hours AprLI6_S2Long Integer46
85Actual_Non_MCC_Hours_May SearchActual Non MCC Hours MayLI6_S2Long Integer46
86Actual_Non_MCC_Hours_Jun SearchActual Non MCC Hours JunLI6_S2Long Integer46
87Actual_Non_MCC_Hrs_July SearchActual Non MCC Hours JulyLI6_S2Long Integer46
88Actual_Non_MCC_Hours_Aug SearchActual Non MCC Hours AugLI6_S2Long Integer46
89Actual_Non_MCC_Hours_Oct SearchActual Non MCC Hours OctLI6_S2Long Integer46
90Actual_Non_MCC_Hours_Nov SearchActual Non MCC Hours NovLI6_S2Long Integer46
91Actual_Non_MCC_Hours_Dec SearchActual Non MCC Hours DecLI6_S2Long Integer46
92Total_Hours_Jan SearchTotal Hours JanLI6_S2Long Integer46
93Total_Hours_Feb SearchTotal Hours FebLI6_S2Long Integer46
94Total_Hours_Mar SearchTotal Hours MarLI6_S2Long Integer46
95Total_Hours_Apr SearchTotal Hours AprLI6_S2Long Integer46
96Total_Hours_May SearchTotal Hours MayLI6_S2Long Integer46
97Total_Hours_Jun SearchTotal Hours JunLI6_S2Long Integer46
98Total_Hours_Jul SearchTotal Hours JulLI6_S2Long Integer46
99Total_Hours_Aug SearchTotal Hours AugLI6_S2Long Integer46
100Total_Hours_Sep SearchTotal Hours SepLI6_S2Long Integer46
101Total_Hours_Oct SearchTotal Hours OctLI6_S2Long Integer46
102Total_Hours_Nov SearchTotal Hours NovLI6_S2Long Integer46
103Total_Hours_Dec SearchTotal Hours DecLI6_S2Long Integer46
104Service_User_Define_1 SearchService User Define 1STR20String2220
105Service_User_Define_2 SearchService User Define 2STR20String2220
106Service_User_Define_3 SearchService User Define 3STR30String3230
107Service_User_Define_4 SearchService User Define 4STR30String3230
108Service_User_Define_5 SearchService User Define 5LI6_S2Long Integer46
109Service_User_Define_6 SearchService User Define 6LI6_S2Long Integer46
110Service_User_Define_7 SearchService User Define 7LI6_S2Long Integer46
111Service_User_Define_8 SearchService User Define 8LI6_S2Long Integer46
112Service_User_Define_9 SearchService User Define 9DTDate48
113Service_User_Define_10 SearchService User Define 10DTDate48
114Service_User_Define_11 SearchService User Define 11DTDate48
115Service_User_Define_12 SearchService User Define 12DTDate48
116Service_User_Define_18 SearchService User Define 18CBBoolean20
117Service_User_Define_19 SearchService User Define 19CBBoolean20
118Service_User_Define_20 SearchService User Define 20CBBoolean20
119Service_User_Define_21 SearchService User Define 21CBBoolean20
120Service_User_Define_22 SearchService User Define 22DLR14_RBS0_STR$Currency1014
121Service_User_Define_23 SearchService User Define 23DLR14_RBS0_STR$Currency1014
122Service_User_Define_24 SearchService User Define 24DLR14_RBS0_STR$Currency1014
123Service_User_Define_25 SearchService User Define 25DLR14_RBS0_STR$Currency1014
124MODIFDT SearchModified DateDTDate48
125Modified_Time SearchModified TimeTM6Time46
126MDFUSRID SearchModified User IDSTR15String1615
Key to the Users Master (SY01400).

Click to show/hide

SELECT
       ['SV_Technician_Labor_Plan_MSTR'].MDFUSRID AS 'SV_Technician_Labor_Plan_MSTR-Modified User ID'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       sv00150 AS ['SV_Technician_Labor_Plan_MSTR']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['SV_Technician_Labor_Plan_MSTR'].MDFUSRID = ['Users Master'].USERID
127Time_Zone SearchTime ZoneSTR3String43
128SV_Language_ID SearchSV Language IDINT2Integer22
129WSReserved_CB1 SearchWSReserved CB1CBBoolean20
130WSReserved_CB2 SearchWSReserved CB2CBBoolean20
131WSReserved_CB3 SearchWSReserved CB3CBBoolean20
132WSReserved_CB4 SearchWSReserved CB4CBBoolean20
133WSReserved_CB5 SearchWSReserved CB5CBBoolean20
134WSReserved_CB6 SearchWSReserved CB6CBBoolean20
135WSReserved_CB7 SearchWSReserved CB7CBBoolean20
136WSReserved_CB8 SearchWSReserved CB8CBBoolean20
137WSReserved_CB9 SearchWSReserved CB9CBBoolean20
138WSReserved_CB10 SearchWSReserved CB10CBBoolean20
139WSReserved_STR1 SearchWSReserved STR1STR10String1210
140WSReserved_STR2 SearchWSReserved STR2STR10String1210
azurecurveProductsWennSoft Products (131)3rd PartySV_Technician_Labor_Plan_MSTR (sv00150)

Leave a Reply

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