SV_Technician_Labor_Plan_MSTR_Archive (SVA0150)

azurecurveProductsWennSoft Products (131)3rd PartySV_Technician_Labor_Plan_MSTR_Archive (SVA0150)

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

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

Display Name: SV_Technician_Labor_Plan_MSTR_Archive
Physical Name: SVA0150
Technical Name: SV_Technician_Labor_Plan_MSTR_Archive

Group Display Name: SERVICE
Group Technical Name: SERVICE

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1Technician_ID SearchTechnician IDSTR15_Employee_IDString15
2YEAR1 SearchYearYearInteger4
3Wennsoft_Affiliate SearchWennsoft AffiliateSTR15_LBAUString15
4Wennsoft_Region SearchWennsoft RegionSTR15_LBAUString15
5Wennsoft_Branch SearchWennsoft BranchSTR15_LBAUString15
6USERID SearchUser IDSTR15_User_IDString15
Key to the Users Master (SY01400).

Click to show/hide

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

Click to show/hide

SELECT
       ['SV_Technician_Labor_Plan_MSTR_Archive'].MDFUSRID AS 'SV_Technician_Labor_Plan_MSTR_Archive-Modified User ID'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       SVA0150 AS ['SV_Technician_Labor_Plan_MSTR_Archive']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['SV_Technician_Labor_Plan_MSTR_Archive'].MDFUSRID = ['Users Master'].USERID
127Time_Zone SearchTime ZoneSTR3String3
128SV_Language_ID SearchSV Language IDINT2Integer2
129WSReserved_CB1 SearchWSReserved CB1CBBoolean0
130WSReserved_CB2 SearchWSReserved CB2CBBoolean0
131WSReserved_CB3 SearchWSReserved CB3CBBoolean0
132WSReserved_CB4 SearchWSReserved CB4CBBoolean0
133WSReserved_CB5 SearchWSReserved CB5CBBoolean0
134WSReserved_CB6 SearchWSReserved CB6CBBoolean0
135WSReserved_CB7 SearchWSReserved CB7CBBoolean0
136WSReserved_CB8 SearchWSReserved CB8CBBoolean0
137WSReserved_CB9 SearchWSReserved CB9CBBoolean0
138WSReserved_CB10 SearchWSReserved CB10CBBoolean0
139WSReserved_STR1 SearchWSReserved STR1STR10String10
140WSReserved_STR2 SearchWSReserved STR2STR10String10
azurecurveProductsWennSoft Products (131)3rd PartySV_Technician_Labor_Plan_MSTR_Archive (SVA0150)

Leave a Reply

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