ServiceMaintWarehouse (SVINTER5)

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

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

Display Name: ServiceMaintWarehouse
Physical Name: SVINTER5
Technical Name: ServiceMaintWarehouse

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1CUSTNMBR SearchCustomer NumberSTR15_RM_Customer_NumberString1615
Key to the RM Customer MSTR (RM00101).

Click to show/hide

SELECT
       ['ServiceMaintWarehouse'].CUSTNMBR AS 'ServiceMaintWarehouse-Customer Number'
       ,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number'
FROM
       SVINTER5 AS ['ServiceMaintWarehouse']
INNER JOIN
       RM00101 AS ['RM Customer MSTR']
              ON
                     ['ServiceMaintWarehouse'].CUSTNMBR = ['RM Customer MSTR'].CUSTNMBR
2ADRSCODE SearchAddress CodeSTR15_Address_CodeString1615
3Contract_Number SearchWS Contract NumberSTR10String1210
4WSCONTSQ SearchWS Contract Number SequenceLI_Sequence_NumberLong Integer410
5Wennsoft_Affiliate SearchWennsoft AffiliateSTR15_LBAUString1615
6Wennsoft_Region SearchWennsoft RegionSTR15_LBAUString1615
7Wennsoft_Branch SearchWennsoft BranchSTR15_LBAUString1615
8USERID SearchUser IDSTR15_User_IDString1615
Key to the Users Master (SY01400).

Click to show/hide

SELECT
       ['ServiceMaintWarehouse'].USERID AS 'ServiceMaintWarehouse-User ID'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       SVINTER5 AS ['ServiceMaintWarehouse']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['ServiceMaintWarehouse'].USERID = ['Users Master'].USERID
9Technician_ID SearchTechnician IDSTR15_Employee_IDString1615
10Technician_Team SearchTechnician TeamSTR15_LBAUString1615
11Technician SearchTechnicianSTR10_LBAUString1210
12CPRCSTNM SearchCorporate Customer NumberSTR15_RM_Customer_NumberString1615
13Corporate_Contract_Nbr SearchCorporate Contract NumberSTR20_LBAUString2220
14WSMSTRCONTSQ SearchWS Master Contract Seq NumberLI_Sequence_NumberLong Integer410
15Corporate_Invoice_Number SearchCorporate Invoice NumberSTR17_LBAUString1817
16Contract_Amount SearchContract AmountDLR14_RBS0_UTR$Currency1014
17Bill_Freq SearchBill FreqDDL_Bill_FreqInteger20
18Wennsoft_Close_Date SearchWennsoft Close DateDTDate48
19Amount_Billed SearchAmount Billed0DLR14_RBS0_STR$Currency1014
20SLPRSNID SearchSalesperson IDSTR15_Salesperson_IDString1615
Key to the RM Salesperson Master (RM00301).

Click to show/hide

SELECT
       ['ServiceMaintWarehouse'].SLPRSNID AS 'ServiceMaintWarehouse-Salesperson ID'
       ,['RM Salesperson Master'].SLPRSNID AS 'RM Salesperson Master-Salesperson ID'
FROM
       SVINTER5 AS ['ServiceMaintWarehouse']
INNER JOIN
       RM00301 AS ['RM Salesperson Master']
              ON
                     ['ServiceMaintWarehouse'].SLPRSNID = ['RM Salesperson Master'].SLPRSNID
21Annual_Contract_Value SearchAnnual Contract ValueDLR14_RBS0_STR$Currency1014
22Revenue_Rec_Method_ID SearchRevenue Recognition Method IDINT2Integer22
23Invoice_Style SearchInvoice StyleINT2Integer22
24Multiyear_Contract_Flag SearchMultiyear Contract FlagBooleanBoolean20
25Contract_Start_Date SearchWS Contract Start DateDTDate48
26Contract_Expiration_Date SearchContract Experation DateDTDate48
27Forecast_Original_Equip SearchForecast Original EquipmentDLR14_RBS0_STR$Currency1014
28Forecast_Original_Labor SearchForecast Original LaborDLR14_RBS0_STR$Currency1014
29Fore_Orig_Material SearchForecast Original MaterialDLR14_RBS0_STR$Currency1014
30Forecast_Original_Other SearchForecast Original OtherDLR14_RBS0_STR$Currency1014
31Forecast_Original_Subs SearchForecast Original SubsDLR14_RBS0_STR$Currency1014
32Forecast_Orig_Labor_1 SearchForecast Orig Labor 1DLR14_RBS0_STR$Currency1014
33Forecast_Orig_Labor1_Hrs SearchForecast Orig Labor 1 HoursLI6_S2Long Integer46
34Forecast_Orig_Labor_2 SearchForecast Orig Labor 2DLR14_RBS0_STR$Currency1014
35Fore_Orig_Labor_2_Hrs SearchForecast Orig Labor 2 HoursLI6_S2Long Integer46
36Forecast_Orig_Labor_3 SearchForecast Orig Labor 3DLR14_RBS0_STR$Currency1014
37Forecast_Orig_Labor3_Hrs SearchForecast Orig Labor 3 HoursLI6_S2Long Integer46
38Forecast_Orig_Labor_4 SearchForecast Orig Labor 4DLR14_RBS0_STR$Currency1014
39Forecast_Orig_Labor4_Hrs SearchForecast Orig Labor 4 HoursLI6_S2Long Integer46
40Forecast_Orig_Labor_5 SearchForecast Orig Labor 5DLR14_RBS0_STR$Currency1014
41Forecast_Orig_Labor5_Hrs SearchForecast Orig Labor 5 HoursLI6_S2Long Integer46
42Forecast_Orig_Tot_Labor SearchForecast Orig Total LaborDLR14_RBS0_STR$Currency1014
43Fore_Orig_Tot_Lbr_Hrs SearchForecast Orig Total Labor HrsLI6_S2Long Integer46
44Actual_Equipment SearchActual EquipmentDLR14_RBS0_STR$Currency1014
45Actual_Labor SearchActual LaborDLR14_RBS0_STR$Currency1014
46Actual_Material SearchActual MaterialDLR14_RBS0_STR$Currency1014
47Actual_Subs SearchActual SubsDLR14_RBS0_STR$Currency1014
48Actual_Other SearchActual OtherDLR14_RBS0_STR$Currency1014
49Total_Cost_Tax SearchTotal Cost TaxDLR11_$S2Currency1014
50Actual_Total_Cost SearchActual Total CostDLR14_RBS0_STR$Currency1014
51Actual_Hours SearchActual HoursLI6_S2Long Integer46
52Actual_Labor_1 SearchActual Labor 1DLR14_RBS0_STR$Currency1014
53Actual_Labor_1_Hours SearchActual Labor 1 HoursLI6_S2Long Integer46
54Actual_Labor_2 SearchActual Labor 2DLR14_RBS0_STR$Currency1014
55Actual_Labor_2_Hours SearchActual Labor 2 HoursLI6_S2Long Integer46
56Actual_Labor_3 SearchActual Labor 3DLR14_RBS0_STR$Currency1014
57Actual_Labor_3_Hours SearchActual Labor 3 HoursLI6_S2Long Integer46
58Actual_Labor_4 SearchActual Labor 4DLR14_RBS0_STR$Currency1014
59Actual_Labor_4_Hours SearchActual Labor 4 HoursLI6_S2Long Integer46
60Actual_Labor_5 SearchActual Labor 5DLR14_RBS0_STR$Currency1014
61Actual_Labor_5_Hours SearchActual Labor 5 HoursLI6_S2Long Integer46
62Actual_Total_Labor SearchActual Total LaborDLR14_RBS0_STR$Currency1014
63Actual_Total_Labor_Hrs SearchActual Total Labor HrsLI6_S2Long Integer46
64Estimate_Equipment SearchEstimate EquipmentDLR14_RBS0_STR$Currency1014
65Estimate_Labor SearchEstimate LaborDLR14_RBS0_STR$Currency1014
66Estimate_Material SearchEstimate MaterialDLR14_RBS0_STR$Currency1014
67Estimate_Subs SearchEstimate SubsDLR14_RBS0_STR$Currency1014
68Estimate_Other SearchEstimate OtherDLR14_RBS0_STR$Currency1014
69Estimate_Total_Cost SearchEstimate Total CostDLR14_RBS0_STR$Currency1014
70Estimate_Hours SearchEstimate HoursLI6_S2Long Integer46
71Estimate_Labor_1 SearchEstimate Labor 1DLR14_RBS0_STR$Currency1014
72Estimate_Labor_1_Hours SearchEstimate Labor 1 HoursLI6_S2Long Integer46
73Estimate_Labor_2 SearchEstimate Labor 2DLR14_RBS0_STR$Currency1014
74Estimate_Labor_2_Hours SearchEstimate Labor 2 HoursLI6_S2Long Integer46
75Estimate_Labor_3 SearchEstimate Labor 3DLR14_RBS0_STR$Currency1014
76Estimate_Labor_3_Hours SearchEstimate Labor 3 HoursLI6_S2Long Integer46
77Estimate_Labor_4 SearchEstimate Labor 4DLR14_RBS0_STR$Currency1014
78Estimate_Labor_4_Hours SearchEstimate Labor 4 HoursLI6_S2Long Integer46
79Estimate_Labor_5 SearchEstimate Labor 5DLR14_RBS0_STR$Currency1014
80Estimate_Labor_5_Hours SearchEstimate Labor 5 HoursLI6_S2Long Integer46
81Estimate_Total_Labor SearchEstimate Total LaborDLR14_RBS0_STR$Currency1014
82Estimate_Total_Labor_Hrs SearchEstimate Total Labor HrsLI6_S2Long Integer46
83Forecast_Labor SearchForecast LaborDLR14_RBS0_STR$Currency1014
84Forecast_Equipment SearchForecast EquipmentDLR14_RBS0_STR$Currency1014
85Forecast_Material SearchForecast MaterialDLR14_RBS0_STR$Currency1014
86Forecast_Subs SearchForecast SubsDLR14_RBS0_STR$Currency1014
87Forecast_Other SearchForecast OtherDLR14_RBS0_STR$Currency1014
88Forecast_Total_Cost SearchForecast Total CostDLR14_RBS0_STR$Currency1014
89Forecast_Hours SearchForecast HoursLI6_S2Long Integer46
90Forecast_Labor_1 SearchForecast Labor 1DLR14_RBS0_STR$Currency1014
91Forecast_Labor_1_Hours SearchForecast Labor 1 HoursLI6_S2Long Integer46
92Forecast_Labor_2 SearchForecast Labor 2DLR14_RBS0_STR$Currency1014
93Forecast_Labor_2_Hours SearchForecast Labor 2 HoursLI6_S2Long Integer46
94Forecast_Labor_3 SearchForecast Labor 3DLR14_RBS0_STR$Currency1014
95Forecast_Labor_3_Hours SearchForecast Labor 3 HoursLI6_S2Long Integer46
96Forecast_Labor_4 SearchForecast Labor 4DLR14_RBS0_STR$Currency1014
97Forecast_Labor_4_Hours SearchForecast Labor 4 HoursLI6_S2Long Integer46
98Forecast_Labor_5 SearchForecast Labor 5DLR14_RBS0_STR$Currency1014
99Forecast_Labor_5_Hours SearchForecast Labor 5 HoursLI6_S2Long Integer46
100Forecast_Total_Labor SearchForecast Total LaborDLR14_RBS0_STR$Currency1014
101Forecast_Total_Labor_Hrs SearchForecast Total Labor HrsLI6_S2Long Integer46
102Task_Est_Rollup_Group SearchTask Estimate Rollup GroupGBInteger20
103Contract_Description SearchContract DescriptionSTR30_LBAUString3230
104User_Define_1a SearchUser Define 1aSTR30String3230
105User_Define_2a SearchUser Define 2aSTR30String3230
106User_Define_3a SearchUser Define 3aSTR30String3230
107User_Define_4a SearchUser Define 4aSTR30String3230
108Service_User_Define_3 SearchService User Define 3STR30String3230
109Service_User_Define_5 SearchService User Define 5LI6_S2Long Integer46
110Service_User_Define_6 SearchService User Define 6LI6_S2Long Integer46
111Service_User_Define_9 SearchService User Define 9DTDate48
112Service_User_Define_10 SearchService User Define 10DTDate48
113Service_User_Define_18 SearchService User Define 18CBBoolean20
114Service_User_Define_19 SearchService User Define 19CBBoolean20
115Service_User_Define_22 SearchService User Define 22DLR14_RBS0_STR$Currency1014
116Service_User_Define_23 SearchService User Define 23DLR14_RBS0_STR$Currency1014
117Service_User_Define_24 SearchService User Define 24DLR14_RBS0_STR$Currency1014
118Contract_Billing_Date SearchContract Billing DateINT2_U0Integer22
119Contract_Service_Date SearchContract Service DateINT2_U0Integer22
120WS_Closed SearchWS ClosedTrue/FalseBoolean20
121Auto_Bill SearchAuto BillCB_Auto_BillBoolean20
122Purchase_Order SearchPurchase OrderSTR15String1615
123LSTFSCDY SearchLast Fiscal DayDT_DateDate46
124Divisions SearchDivisionsSTR15_LBAUString1615
125PY_Labor SearchPY LaborDLR14_RBS0_STR$Currency1014
126PY_Material SearchPY MaterialDLR14_RBS0_STR$Currency1014
127PY_Equipment SearchPY EquipmentDLR14_RBS0_STR$Currency1014
128PY_Subcontractor SearchPY SubcontractorDLR14_RBS0_STR$Currency1014
129PY_Other SearchPY OtherDLR14_RBS0_STR$Currency1014
130PY_Total_Cost SearchPY Total CostDLR14_RBS0_STR$Currency1014
131PY_Billed SearchPY BilledDLR14_RBS0_STR$Currency1014
132PY_Contract_Earned SearchPY Contract EarnedDLR14_RBS0_STR$Currency1014
133PY_Gross_Profit SearchPY Gross ProfitDLR14_RBS0_STR$Currency1014
134PY_Revenue_Recognized SearchPY Revenue RecognizedDLR14_RBS0_STR$Currency1014
135PY_Hours SearchPY HoursLI6_S2Long Integer46
136PY_Labor_1 SearchPY Labor 1DLR14_RBS0_STR$Currency1014
137PY_Labor_1_Hours SearchPY Labor 1 HoursLI6_S2Long Integer46
138PY_Labor_2 SearchPY Labor 2DLR14_RBS0_STR$Currency1014
139PY_Labor_2_Hours SearchPY Labor 2 HoursLI6_S2Long Integer46
140PY_Labor_3 SearchPY Labor 3DLR14_RBS0_STR$Currency1014
141PY_Labor_3_Hours SearchPY Labor 3 HoursLI6_S2Long Integer46
142PY_Labor_4 SearchPY Labor 4DLR14_RBS0_STR$Currency1014
143PY_Labor_4_Hours SearchPY Labor 4 HoursLI6_S2Long Integer46
144PY_Labor_5 SearchPY Labor 5DLR14_RBS0_STR$Currency1014
145PY_Labor_5_Hours SearchPY Labor 5 HoursLI6_S2Long Integer46
146PY_Total_Labor SearchPY Total LaborDLR14_RBS0_STR$Currency1014
147PY_Total_Labor_Hrs SearchPY Total Labor HrsLI6_S2Long Integer46
148YTD_Labor SearchYTD LaborDLR14_RBS0_STR$Currency1014
149YTD_Material SearchYTD MaterialDLR14_RBS0_STR$Currency1014
150YTD_Equipment SearchYTD EquipmentDLR14_RBS0_STR$Currency1014
151YTD_Subcontractor SearchYTD SubcontractorDLR14_RBS0_STR$Currency1014
152YTD_Other SearchYTD OtherDLR14_RBS0_STR$Currency1014
153YTD_Total_Cost SearchYTD Total CostDLR14_RBS0_STR$Currency1014
154YTD_Billed SearchYTD BilledDLR14_RBS0_STR$Currency1014
155YTD_Contract_Earned SearchYTD Contract EarnedDLR14_RBS0_STR$Currency1014
156YTD_Gross_Profit SearchYTD Gross ProfitDLR14_RBS0_STR$Currency1014
157YTD_Revenue_Recognized SearchYTD Revenue RecognizedDLR14_RBS0_STR$Currency1014
158YTDHOURS SearchYTD HoursLI6_S2Long Integer46
159YTD_Labor_1 SearchYTD Labor 1DLR14_RBS0_STR$Currency1014
160YTD_Labor_1_Hours SearchYTD Labor 1 HoursLI6_S2Long Integer46
161YTD_Labor_2 SearchYTD Labor 2DLR14_RBS0_STR$Currency1014
162YTD_Labor_2_Hours SearchYTD Labor 2 HoursLI6_S2Long Integer46
163YTD_Labor_3 SearchYTD Labor 3DLR14_RBS0_STR$Currency1014
164YTD_Labor_3_Hours SearchYTD Labor 3 HoursLI6_S2Long Integer46
165YTD_Labor_4 SearchYTD Labor 4DLR14_RBS0_STR$Currency1014
166YTD_Labor_4_Hours SearchYTD Labor 4 HoursLI6_S2Long Integer46
167YTD_Labor_5 SearchYTD Labor 5DLR14_RBS0_STR$Currency1014
168YTD_Labor_5_Hours SearchYTD Labor 5 HoursLI6_S2Long Integer46
169YTD_Total_Labor SearchYTD Total LaborDLR14_RBS0_STR$Currency1014
170YTD_Total_Labor_Hrs SearchYTD Total Labor HrsLI6_S2Long Integer46
171TTD_Billed SearchTTD BilledDLR14_RBS0_STR$Currency1014
172TTD_Contract_Earned SearchTTD Contract EarnedDLR14_RBS0_STR$Currency1014
173TTD_Gross_Profit SearchTTD Gross ProfitDLR14_RBS0_STR$Currency1014
174TTD_Revenue_Recognized SearchTTD Revenue RecognizedDLR14_RBS0_STR$Currency1014
175Auto_Date SearchAuto DateDATEDate46
176Cancel_Box SearchCancel BoxCB_CancelBoolean20
177HOLD SearchHoldCB_HoldBoolean20
178Excess_Cost SearchExcess CostDLR14_RBS0_STR$Currency1014
179Unbilled_Receivable SearchUnbilled ReceivableDLR14_RBS0_STR$Currency1014
180Contract_NTE_Units SearchContract NTE UnitsLI8Long Integer48
181Contract_Actual_Units SearchContract Actual UnitsLI8Long Integer48
182Equipment_ID SearchEquipment IDSTR30String3230
183Warranty_Checkbox SearchWarranty CheckboxCB_WarrantyBoolean20
184MODIFDT SearchModified DateDTDate48
185Modified_Time SearchModified TimeTM6Time46
186MDFUSRID SearchModified User IDSTR15String1615
Key to the Users Master (SY01400).

Click to show/hide

SELECT
       ['ServiceMaintWarehouse'].MDFUSRID AS 'ServiceMaintWarehouse-Modified User ID'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       SVINTER5 AS ['ServiceMaintWarehouse']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['ServiceMaintWarehouse'].MDFUSRID = ['Users Master'].USERID
187Time_Zone SearchTime ZoneSTR3String43
188SV_Language_ID SearchSV Language IDINT2Integer22
189Base_Currency_ID SearchBase Currency IDSTR15_Currency_IDString1615
190Billing_Currency_ID SearchBilling Currency IDSTR15_Currency_IDString1615
191Local_Currency_ID SearchLocal Currency IDSTR15_Currency_IDString1615
192Hold_Reason_ID SearchHold Reason IDINT5Integer24
193Billing_Equipment SearchBilling EquipmentDLR14_RBS0_STR$Currency1014
194Billing_Material SearchBilling MaterialDLR14_RBS0_STR$Currency1014
195Billing_Labor SearchBilling LaborDLR14_RBS0_STR$Currency1014
196Billing_Subs SearchBilling SubsDLR14_RBS0_STR$Currency1014
197Billing_Other SearchBilling OtherDLR14_RBS0_STR$Currency1014
198Billing_Percentage_Equip SearchBilling Percentage EquipDLR5_%2Currency108
199Billing_Pct_Material SearchBilling Percentage MaterialDLR5_%2Currency108
200Billing_Percentage_Labor SearchBilling Percentage LaborDLR5_%2Currency108
201Billing_Percentage_Subs SearchBilling Percentage SubsDLR5_%2Currency108
202Billing_Percentage_Other SearchBilling Percentage OtherDLR5_%2Currency108
203Current_Billing_Amount SearchCurrent Billing AmountDLR14_RBS0_STR$Currency1014
204Escalation_Frequency SearchEscalation FrequencySTR15_LBAUString1615
205Escalation_Date SearchEscalation DateDATEDate46
206Escal_Notify_Days SearchEscalation Notification DaysINT3_U0Integer23
207Next_Escalation_Date SearchNext Escalation DateDATEDate46
208Begin_Date_CY SearchBegin Date CYDATEDate46
209Anniversary_Date SearchAnniversary DateDTDate48
210Evergreen_Contract_Flag SearchEvergreen Contract FlagBooleanBoolean20
211Contract_Units_Measure SearchContract Units MeasureSTR15_LBAUString1615
212Last_Review_Date SearchLast Review DateDATEDate46
213Last_Review_User_ID SearchLast Review User IDSTR15_User_IDString1615
214Contract_Internal_Name SearchContract Internal NameSTR15_LBAUString1615
215Auto_Escalation_Flag SearchAutomatic Escalation FlagCBBoolean20
216WSReserved_CB1 SearchWSReserved CB1CBBoolean20
217WSReserved_CB2 SearchWSReserved CB2CBBoolean20
218WSReserved_CB3 SearchWSReserved CB3CBBoolean20
219WSReserved_CB4 SearchWSReserved CB4CBBoolean20
220WSReserved_CB5 SearchWSReserved CB5CBBoolean20
221WSReserved_CB6 SearchWSReserved CB6CBBoolean20
222WSReserved_CB7 SearchWSReserved CB7CBBoolean20
223WSReserved_CB8 SearchWSReserved CB8CBBoolean20
224WSReserved_CB9 SearchWSReserved CB9CBBoolean20
225WSReserved_CB10 SearchWSReserved CB10CBBoolean20
226WSReserved_STR1 SearchWSReserved STR1STR10String1210
227WSReserved_STR2 SearchWSReserved STR2STR10String1210

Leave a Reply

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