SV_Quote_MSTR (SV00502)

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

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

Display Name: SV_Quote_MSTR
Physical Name: SV00502
Technical Name: SV_Quote_MSTR

Group Display Name: SERVICE
Group Technical Name: SERVICE

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
       ['SV_Quote_MSTR'].CUSTNMBR AS 'SV_Quote_MSTR-Customer Number'
       ,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number'
FROM
       SV00502 AS ['SV_Quote_MSTR']
INNER JOIN
       RM00101 AS ['RM Customer MSTR']
              ON
                     ['SV_Quote_MSTR'].CUSTNMBR = ['RM Customer MSTR'].CUSTNMBR
2ADRSCODE SearchAddress CodeSTR15_Address_CodeString1615
3Quote_Number SearchQuote NumberSTR10String1210
4Quote_Type SearchQuote TypeDDL_Quote_TypeInteger20
5QUOTEDAT SearchQuote DateDTDate48
6QUOEXPDA SearchQuote Expiration DateDTDate48
7Contract_Number SearchWS Contract NumberSTR10String1210
8WSCONTSQ SearchWS Contract Number SequenceLI_Sequence_NumberLong Integer410
9Wennsoft_Affiliate SearchWennsoft AffiliateSTR15_LBAUString1615
10Wennsoft_Region SearchWennsoft RegionSTR15_LBAUString1615
11Wennsoft_Branch SearchWennsoft BranchSTR15_LBAUString1615
12Contract_Description SearchContract DescriptionSTR30_LBAUString3230
13Contract_Internal_Name SearchContract Internal NameSTR15_LBAUString1615
14USERID SearchUser IDSTR15_User_IDString1615
Key to the Users Master (SY01400).

Click to show/hide

SELECT
       ['SV_Quote_MSTR'].USERID AS 'SV_Quote_MSTR-User ID'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       SV00502 AS ['SV_Quote_MSTR']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['SV_Quote_MSTR'].USERID = ['Users Master'].USERID
15Contract_Amount SearchContract AmountDLR14_RBS0_UTR$Currency1014
16Bill_Freq SearchBill FreqDDL_Bill_FreqInteger20
17Contract_Billing_Date SearchContract Billing DateINT2_U0Integer22
18SLPRSNID SearchSalesperson IDSTR15_Salesperson_IDString1615
Key to the RM Salesperson Master (RM00301).

Click to show/hide

SELECT
       ['SV_Quote_MSTR'].SLPRSNID AS 'SV_Quote_MSTR-Salesperson ID'
       ,['RM Salesperson Master'].SLPRSNID AS 'RM Salesperson Master-Salesperson ID'
FROM
       SV00502 AS ['SV_Quote_MSTR']
INNER JOIN
       RM00301 AS ['RM Salesperson Master']
              ON
                     ['SV_Quote_MSTR'].SLPRSNID = ['RM Salesperson Master'].SLPRSNID
19SVSLARES SearchSV Service Level IDSTR10_LBAUString1210
20User_Define_1a SearchUser Define 1aSTR30String3230
21User_Define_2a SearchUser Define 2aSTR30String3230
22User_Define_3a SearchUser Define 3aSTR30String3230
23User_Define_4a SearchUser Define 4aSTR30String3230
24Forecast_Original_Equip SearchForecast Original EquipmentDLR14_RBS0_STR$Currency1014
25Fore_Orig_Material SearchForecast Original MaterialDLR14_RBS0_STR$Currency1014
26Forecast_Orig_Labor_1 SearchForecast Orig Labor 1DLR14_RBS0_STR$Currency1014
27Forecast_Orig_Labor1_Hrs SearchForecast Orig Labor 1 HoursLI6_S2Long Integer46
28Forecast_Orig_Labor_2 SearchForecast Orig Labor 2DLR14_RBS0_STR$Currency1014
29Fore_Orig_Labor_2_Hrs SearchForecast Orig Labor 2 HoursLI6_S2Long Integer46
30Forecast_Orig_Labor_3 SearchForecast Orig Labor 3DLR14_RBS0_STR$Currency1014
31Forecast_Orig_Labor3_Hrs SearchForecast Orig Labor 3 HoursLI6_S2Long Integer46
32Forecast_Orig_Labor_4 SearchForecast Orig Labor 4DLR14_RBS0_STR$Currency1014
33Forecast_Orig_Labor4_Hrs SearchForecast Orig Labor 4 HoursLI6_S2Long Integer46
34Forecast_Orig_Labor_5 SearchForecast Orig Labor 5DLR14_RBS0_STR$Currency1014
35Forecast_Orig_Labor5_Hrs SearchForecast Orig Labor 5 HoursLI6_S2Long Integer46
36Forecast_Original_Labor SearchForecast Original LaborDLR14_RBS0_STR$Currency1014
37Forecast_Original_Subs SearchForecast Original SubsDLR14_RBS0_STR$Currency1014
38Forecast_Original_Other SearchForecast Original OtherDLR14_RBS0_STR$Currency1014
39Forecast_Orig_Tot_Labor SearchForecast Orig Total LaborDLR14_RBS0_STR$Currency1014
40Fore_Orig_Tot_Lbr_Hrs SearchForecast Orig Total Labor HrsLI6_S2Long Integer46
41Forecast_Equipment SearchForecast EquipmentDLR14_RBS0_STR$Currency1014
42Forecast_Material SearchForecast MaterialDLR14_RBS0_STR$Currency1014
43Forecast_Labor_1 SearchForecast Labor 1DLR14_RBS0_STR$Currency1014
44Forecast_Labor_1_Hours SearchForecast Labor 1 HoursLI6_S2Long Integer46
45Forecast_Labor_2 SearchForecast Labor 2DLR14_RBS0_STR$Currency1014
46Forecast_Labor_2_Hours SearchForecast Labor 2 HoursLI6_S2Long Integer46
47Forecast_Labor_3 SearchForecast Labor 3DLR14_RBS0_STR$Currency1014
48Forecast_Labor_3_Hours SearchForecast Labor 3 HoursLI6_S2Long Integer46
49Forecast_Labor_4 SearchForecast Labor 4DLR14_RBS0_STR$Currency1014
50Forecast_Labor_4_Hours SearchForecast Labor 4 HoursLI6_S2Long Integer46
51Forecast_Labor_5 SearchForecast Labor 5DLR14_RBS0_STR$Currency1014
52Forecast_Labor_5_Hours SearchForecast Labor 5 HoursLI6_S2Long Integer46
53Forecast_Labor SearchForecast LaborDLR14_RBS0_STR$Currency1014
54Forecast_Subs SearchForecast SubsDLR14_RBS0_STR$Currency1014
55Forecast_Other SearchForecast OtherDLR14_RBS0_STR$Currency1014
56Forecast_Total_Cost SearchForecast Total CostDLR14_RBS0_STR$Currency1014
57Forecast_Total_Labor SearchForecast Total LaborDLR14_RBS0_STR$Currency1014
58Forecast_Total_Labor_Hrs SearchForecast Total Labor HrsLI6_S2Long Integer46
59Billing_Equipment SearchBilling EquipmentDLR14_RBS0_STR$Currency1014
60Billing_Material SearchBilling MaterialDLR14_RBS0_STR$Currency1014
61Billing_Labor_1 SearchBilling Labor 1DLR14_RBS0_STR$Currency1014
62Billing_Labor_1_Hours SearchBilling Labor 1 HoursLI6_S2Long Integer46
63Billing_Labor_2 SearchBilling Labor 2DLR14_RBS0_STR$Currency1014
64Billing_Labor_2_Hours SearchBilling Labor 2 HoursLI6_S2Long Integer46
65Billing_Labor_3 SearchBilling Labor 3DLR14_RBS0_STR$Currency1014
66Billing_Labor_3_Hours SearchBilling Labor 3 HoursLI6_S2Long Integer46
67Billing_Labor_4 SearchBilling Labor 4DLR14_RBS0_STR$Currency1014
68Billing_Labor_4_Hours SearchBilling Labor 4 HoursLI6_S2Long Integer46
69Billing_Labor_5 SearchBilling Labor 5DLR14_RBS0_STR$Currency1014
70Billing_Labor_5_Hours SearchBilling Labor 5 HoursLI6_S2Long Integer46
71Billing_Labor SearchBilling LaborDLR14_RBS0_STR$Currency1014
72Billing_Labor_Hours SearchBilling Labor HoursLI6_S2Long Integer46
73Billing_Subs SearchBilling SubsDLR14_RBS0_STR$Currency1014
74Billing_Other SearchBilling OtherDLR14_RBS0_STR$Currency1014
75Billing_Total SearchBilling TotalDLR14_RBS0_STR$Currency1014
76Billing_Percentage_Equip SearchBilling Percentage EquipDLR5_%2Currency108
77Billing_Pct_Material SearchBilling Percentage MaterialDLR5_%2Currency108
78Billing_Percentage_Labor SearchBilling Percentage LaborDLR5_%2Currency108
79Billing_Percentage_Subs SearchBilling Percentage SubsDLR5_%2Currency108
80Billing_Percentage_Other SearchBilling Percentage OtherDLR5_%2Currency108
81Billing_Percentage_Total SearchBilling Percentage TotalDLR5_%2Currency108
82Estimate_Equipment SearchEstimate EquipmentDLR14_RBS0_STR$Currency1014
83Estimate_Material SearchEstimate MaterialDLR14_RBS0_STR$Currency1014
84Estimate_Labor_1 SearchEstimate Labor 1DLR14_RBS0_STR$Currency1014
85Estimate_Labor_1_Hours SearchEstimate Labor 1 HoursLI6_S2Long Integer46
86Estimate_Labor_2 SearchEstimate Labor 2DLR14_RBS0_STR$Currency1014
87Estimate_Labor_2_Hours SearchEstimate Labor 2 HoursLI6_S2Long Integer46
88Estimate_Labor_3 SearchEstimate Labor 3DLR14_RBS0_STR$Currency1014
89Estimate_Labor_3_Hours SearchEstimate Labor 3 HoursLI6_S2Long Integer46
90Estimate_Labor_4 SearchEstimate Labor 4DLR14_RBS0_STR$Currency1014
91Estimate_Labor_4_Hours SearchEstimate Labor 4 HoursLI6_S2Long Integer46
92Estimate_Labor_5 SearchEstimate Labor 5DLR14_RBS0_STR$Currency1014
93Estimate_Labor_5_Hours SearchEstimate Labor 5 HoursLI6_S2Long Integer46
94Estimate_Labor SearchEstimate LaborDLR14_RBS0_STR$Currency1014
95Estimate_Hours SearchEstimate HoursLI6_S2Long Integer46
96Estimate_Subs SearchEstimate SubsDLR14_RBS0_STR$Currency1014
97Estimate_Other SearchEstimate OtherDLR14_RBS0_STR$Currency1014
98Estimate_Total_Cost SearchEstimate Total CostDLR14_RBS0_STR$Currency1014
99Estimate_Total_Labor SearchEstimate Total LaborDLR14_RBS0_STR$Currency1014
100Estimate_Total_Labor_Hrs SearchEstimate Total Labor HrsLI6_S2Long Integer46
101Annual_Contract_Value SearchAnnual Contract ValueDLR14_RBS0_STR$Currency1014
102Revenue_Rec_Method_ID SearchRevenue Recognition Method IDINT2Integer22
103Invoice_Style SearchInvoice StyleINT2Integer22
104Multiyear_Contract_Flag SearchMultiyear Contract FlagBooleanBoolean20
105Contract_Start_Date SearchWS Contract Start DateDTDate48
106Contract_Expiration_Date SearchContract Experation DateDTDate48
107Service_User_Define_3 SearchService User Define 3STR30String3230
108Service_User_Define_5 SearchService User Define 5LI6_S2Long Integer46
109Service_User_Define_6 SearchService User Define 6LI6_S2Long Integer46
110Service_User_Define_9 SearchService User Define 9DTDate48
111Service_User_Define_10 SearchService User Define 10DTDate48
112Service_User_Define_18 SearchService User Define 18CBBoolean20
113Service_User_Define_19 SearchService User Define 19CBBoolean20
114Service_User_Define_22 SearchService User Define 22DLR14_RBS0_STR$Currency1014
115Service_User_Define_23 SearchService User Define 23DLR14_RBS0_STR$Currency1014
116Service_User_Define_24 SearchService User Define 24DLR14_RBS0_STR$Currency1014
117Auto_Bill SearchAuto BillCB_Auto_BillBoolean20
118Cancel_Box SearchCancel BoxCB_CancelBoolean20
119HOLD SearchHoldCB_HoldBoolean20
120Excess_Cost SearchExcess CostDLR14_RBS0_STR$Currency1014
121Contract_NTE_Units SearchContract NTE UnitsLI8Long Integer48
122Contract_Actual_Units SearchContract Actual UnitsLI8Long Integer48
123Warranty_Checkbox SearchWarranty CheckboxCB_WarrantyBoolean20
124MODIFDT SearchModified DateDTDate48
125Modified_Time SearchModified TimeTM6Time46
126MDFUSRID SearchModified User IDSTR15String1615
Key to the Users Master (SY01400).

Click to show/hide

SELECT
       ['SV_Quote_MSTR'].MDFUSRID AS 'SV_Quote_MSTR-Modified User ID'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       SV00502 AS ['SV_Quote_MSTR']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['SV_Quote_MSTR'].MDFUSRID = ['Users Master'].USERID
127Time_Zone SearchTime ZoneSTR3String43
128Base_Currency_ID SearchBase Currency IDSTR15_Currency_IDString1615
129Billing_Currency_ID SearchBilling Currency IDSTR15_Currency_IDString1615
130Local_Currency_ID SearchLocal Currency IDSTR15_Currency_IDString1615
131Hold_Reason_ID SearchHold Reason IDINT5Integer24
132Last_Review_Date SearchLast Review DateDATEDate46
133Last_Review_User_ID SearchLast Review User IDSTR15_User_IDString1615
134Evergreen_Contract_Flag SearchEvergreen Contract FlagBooleanBoolean20
135Contract_Units_Measure SearchContract Units MeasureSTR15_LBAUString1615
136Pricing_Matrix_Name SearchPricing Matrix NameSTR15_RM_Customer_NumberString1615
137WSReserved_CB1 SearchWSReserved CB1CBBoolean20
138WSReserved_CB2 SearchWSReserved CB2CBBoolean20
139WSReserved_CB3 SearchWSReserved CB3CBBoolean20
140WSReserved_CB5 SearchWSReserved CB5CBBoolean20
141WSReserved_CB6 SearchWSReserved CB6CBBoolean20
142WSReserved_CB7 SearchWSReserved CB7CBBoolean20
143WSReserved_CB8 SearchWSReserved CB8CBBoolean20
144WSReserved_CB9 SearchWSReserved CB9CBBoolean20
145WSReserved_CB10 SearchWSReserved CB10CBBoolean20
146WSReserved_STR1 SearchWSReserved STR1STR10String1210
147WSReserved_STR2 SearchWSReserved STR2STR10String1210

Leave a Reply

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