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 TypeLength
1CUSTNMBR SearchCustomer NumberSTR15_RM_Customer_NumberString15
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_CodeString15
3Quote_Number SearchQuote NumberSTR10String10
4Quote_Type SearchQuote TypeDDL_Quote_TypeInteger0
5QUOTEDAT SearchQuote DateDTDate8
6QUOEXPDA SearchQuote Expiration DateDTDate8
7Contract_Number SearchWS Contract NumberSTR10String10
8WSCONTSQ SearchWS Contract Number SequenceLI_Sequence_NumberLong Integer10
9Wennsoft_Affiliate SearchWennsoft AffiliateSTR15_LBAUString15
10Wennsoft_Region SearchWennsoft RegionSTR15_LBAUString15
11Wennsoft_Branch SearchWennsoft BranchSTR15_LBAUString15
12Contract_Description SearchContract DescriptionSTR30_LBAUString30
13Contract_Internal_Name SearchContract Internal NameSTR15_LBAUString15
14USERID SearchUser IDSTR15_User_IDString15
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$Currency14
16Bill_Freq SearchBill FreqDDL_Bill_FreqInteger0
17Contract_Billing_Date SearchContract Billing DateINT2_U0Integer2
18SLPRSNID SearchSalesperson IDSTR15_Salesperson_IDString15
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_LBAUString10
20User_Define_1a SearchUser Define 1aSTR30String30
21User_Define_2a SearchUser Define 2aSTR30String30
22User_Define_3a SearchUser Define 3aSTR30String30
23User_Define_4a SearchUser Define 4aSTR30String30
24Forecast_Original_Equip SearchForecast Original EquipmentDLR14_RBS0_STR$Currency14
25Fore_Orig_Material SearchForecast Original MaterialDLR14_RBS0_STR$Currency14
26Forecast_Orig_Labor_1 SearchForecast Orig Labor 1DLR14_RBS0_STR$Currency14
27Forecast_Orig_Labor1_Hrs SearchForecast Orig Labor 1 HoursLI6_S2Long Integer6
28Forecast_Orig_Labor_2 SearchForecast Orig Labor 2DLR14_RBS0_STR$Currency14
29Fore_Orig_Labor_2_Hrs SearchForecast Orig Labor 2 HoursLI6_S2Long Integer6
30Forecast_Orig_Labor_3 SearchForecast Orig Labor 3DLR14_RBS0_STR$Currency14
31Forecast_Orig_Labor3_Hrs SearchForecast Orig Labor 3 HoursLI6_S2Long Integer6
32Forecast_Orig_Labor_4 SearchForecast Orig Labor 4DLR14_RBS0_STR$Currency14
33Forecast_Orig_Labor4_Hrs SearchForecast Orig Labor 4 HoursLI6_S2Long Integer6
34Forecast_Orig_Labor_5 SearchForecast Orig Labor 5DLR14_RBS0_STR$Currency14
35Forecast_Orig_Labor5_Hrs SearchForecast Orig Labor 5 HoursLI6_S2Long Integer6
36Forecast_Original_Labor SearchForecast Original LaborDLR14_RBS0_STR$Currency14
37Forecast_Original_Subs SearchForecast Original SubsDLR14_RBS0_STR$Currency14
38Forecast_Original_Other SearchForecast Original OtherDLR14_RBS0_STR$Currency14
39Forecast_Orig_Tot_Labor SearchForecast Orig Total LaborDLR14_RBS0_STR$Currency14
40Fore_Orig_Tot_Lbr_Hrs SearchForecast Orig Total Labor HrsLI6_S2Long Integer6
41Forecast_Equipment SearchForecast EquipmentDLR14_RBS0_STR$Currency14
42Forecast_Material SearchForecast MaterialDLR14_RBS0_STR$Currency14
43Forecast_Labor_1 SearchForecast Labor 1DLR14_RBS0_STR$Currency14
44Forecast_Labor_1_Hours SearchForecast Labor 1 HoursLI6_S2Long Integer6
45Forecast_Labor_2 SearchForecast Labor 2DLR14_RBS0_STR$Currency14
46Forecast_Labor_2_Hours SearchForecast Labor 2 HoursLI6_S2Long Integer6
47Forecast_Labor_3 SearchForecast Labor 3DLR14_RBS0_STR$Currency14
48Forecast_Labor_3_Hours SearchForecast Labor 3 HoursLI6_S2Long Integer6
49Forecast_Labor_4 SearchForecast Labor 4DLR14_RBS0_STR$Currency14
50Forecast_Labor_4_Hours SearchForecast Labor 4 HoursLI6_S2Long Integer6
51Forecast_Labor_5 SearchForecast Labor 5DLR14_RBS0_STR$Currency14
52Forecast_Labor_5_Hours SearchForecast Labor 5 HoursLI6_S2Long Integer6
53Forecast_Labor SearchForecast LaborDLR14_RBS0_STR$Currency14
54Forecast_Subs SearchForecast SubsDLR14_RBS0_STR$Currency14
55Forecast_Other SearchForecast OtherDLR14_RBS0_STR$Currency14
56Forecast_Total_Cost SearchForecast Total CostDLR14_RBS0_STR$Currency14
57Forecast_Total_Labor SearchForecast Total LaborDLR14_RBS0_STR$Currency14
58Forecast_Total_Labor_Hrs SearchForecast Total Labor HrsLI6_S2Long Integer6
59Billing_Equipment SearchBilling EquipmentDLR14_RBS0_STR$Currency14
60Billing_Material SearchBilling MaterialDLR14_RBS0_STR$Currency14
61Billing_Labor_1 SearchBilling Labor 1DLR14_RBS0_STR$Currency14
62Billing_Labor_1_Hours SearchBilling Labor 1 HoursLI6_S2Long Integer6
63Billing_Labor_2 SearchBilling Labor 2DLR14_RBS0_STR$Currency14
64Billing_Labor_2_Hours SearchBilling Labor 2 HoursLI6_S2Long Integer6
65Billing_Labor_3 SearchBilling Labor 3DLR14_RBS0_STR$Currency14
66Billing_Labor_3_Hours SearchBilling Labor 3 HoursLI6_S2Long Integer6
67Billing_Labor_4 SearchBilling Labor 4DLR14_RBS0_STR$Currency14
68Billing_Labor_4_Hours SearchBilling Labor 4 HoursLI6_S2Long Integer6
69Billing_Labor_5 SearchBilling Labor 5DLR14_RBS0_STR$Currency14
70Billing_Labor_5_Hours SearchBilling Labor 5 HoursLI6_S2Long Integer6
71Billing_Labor SearchBilling LaborDLR14_RBS0_STR$Currency14
72Billing_Labor_Hours SearchBilling Labor HoursLI6_S2Long Integer6
73Billing_Subs SearchBilling SubsDLR14_RBS0_STR$Currency14
74Billing_Other SearchBilling OtherDLR14_RBS0_STR$Currency14
75Billing_Total SearchBilling TotalDLR14_RBS0_STR$Currency14
76Billing_Percentage_Equip SearchBilling Percentage EquipDLR5_%2Currency8
77Billing_Pct_Material SearchBilling Percentage MaterialDLR5_%2Currency8
78Billing_Percentage_Labor SearchBilling Percentage LaborDLR5_%2Currency8
79Billing_Percentage_Subs SearchBilling Percentage SubsDLR5_%2Currency8
80Billing_Percentage_Other SearchBilling Percentage OtherDLR5_%2Currency8
81Billing_Percentage_Total SearchBilling Percentage TotalDLR5_%2Currency8
82Estimate_Equipment SearchEstimate EquipmentDLR14_RBS0_STR$Currency14
83Estimate_Material SearchEstimate MaterialDLR14_RBS0_STR$Currency14
84Estimate_Labor_1 SearchEstimate Labor 1DLR14_RBS0_STR$Currency14
85Estimate_Labor_1_Hours SearchEstimate Labor 1 HoursLI6_S2Long Integer6
86Estimate_Labor_2 SearchEstimate Labor 2DLR14_RBS0_STR$Currency14
87Estimate_Labor_2_Hours SearchEstimate Labor 2 HoursLI6_S2Long Integer6
88Estimate_Labor_3 SearchEstimate Labor 3DLR14_RBS0_STR$Currency14
89Estimate_Labor_3_Hours SearchEstimate Labor 3 HoursLI6_S2Long Integer6
90Estimate_Labor_4 SearchEstimate Labor 4DLR14_RBS0_STR$Currency14
91Estimate_Labor_4_Hours SearchEstimate Labor 4 HoursLI6_S2Long Integer6
92Estimate_Labor_5 SearchEstimate Labor 5DLR14_RBS0_STR$Currency14
93Estimate_Labor_5_Hours SearchEstimate Labor 5 HoursLI6_S2Long Integer6
94Estimate_Labor SearchEstimate LaborDLR14_RBS0_STR$Currency14
95Estimate_Hours SearchEstimate HoursLI6_S2Long Integer6
96Estimate_Subs SearchEstimate SubsDLR14_RBS0_STR$Currency14
97Estimate_Other SearchEstimate OtherDLR14_RBS0_STR$Currency14
98Estimate_Total_Cost SearchEstimate Total CostDLR14_RBS0_STR$Currency14
99Estimate_Total_Labor SearchEstimate Total LaborDLR14_RBS0_STR$Currency14
100Estimate_Total_Labor_Hrs SearchEstimate Total Labor HrsLI6_S2Long Integer6
101Annual_Contract_Value SearchAnnual Contract ValueDLR14_RBS0_STR$Currency14
102Revenue_Rec_Method_ID SearchRevenue Recognition Method IDINT2Integer2
103Invoice_Style SearchInvoice StyleINT2Integer2
104Multiyear_Contract_Flag SearchMultiyear Contract FlagBooleanBoolean0
105Contract_Start_Date SearchWS Contract Start DateDTDate8
106Contract_Expiration_Date SearchContract Experation DateDTDate8
107Service_User_Define_3 SearchService User Define 3STR30String30
108Service_User_Define_5 SearchService User Define 5LI6_S2Long Integer6
109Service_User_Define_6 SearchService User Define 6LI6_S2Long Integer6
110Service_User_Define_9 SearchService User Define 9DTDate8
111Service_User_Define_10 SearchService User Define 10DTDate8
112Service_User_Define_18 SearchService User Define 18CBBoolean0
113Service_User_Define_19 SearchService User Define 19CBBoolean0
114Service_User_Define_22 SearchService User Define 22DLR14_RBS0_STR$Currency14
115Service_User_Define_23 SearchService User Define 23DLR14_RBS0_STR$Currency14
116Service_User_Define_24 SearchService User Define 24DLR14_RBS0_STR$Currency14
117Auto_Bill SearchAuto BillCB_Auto_BillBoolean0
118Cancel_Box SearchCancel BoxCB_CancelBoolean0
119HOLD SearchHoldCB_HoldBoolean0
120Excess_Cost SearchExcess CostDLR14_RBS0_STR$Currency14
121Contract_NTE_Units SearchContract NTE UnitsLI8Long Integer8
122Contract_Actual_Units SearchContract Actual UnitsLI8Long Integer8
123Warranty_Checkbox SearchWarranty CheckboxCB_WarrantyBoolean0
124MODIFDT SearchModified DateDTDate8
125Modified_Time SearchModified TimeTM6Time6
126MDFUSRID SearchModified User IDSTR15String15
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 ZoneSTR3String3
128Base_Currency_ID SearchBase Currency IDSTR15_Currency_IDString15
129Billing_Currency_ID SearchBilling Currency IDSTR15_Currency_IDString15
130Local_Currency_ID SearchLocal Currency IDSTR15_Currency_IDString15
131Hold_Reason_ID SearchHold Reason IDINT5Integer4
132Last_Review_Date SearchLast Review DateDATEDate6
133Last_Review_User_ID SearchLast Review User IDSTR15_User_IDString15
134Evergreen_Contract_Flag SearchEvergreen Contract FlagBooleanBoolean0
135Contract_Units_Measure SearchContract Units MeasureSTR15_LBAUString15
136Pricing_Matrix_Name SearchPricing Matrix NameSTR15_RM_Customer_NumberString15
137WSReserved_CB1 SearchWSReserved CB1CBBoolean0
138WSReserved_CB2 SearchWSReserved CB2CBBoolean0
139WSReserved_CB3 SearchWSReserved CB3CBBoolean0
140WSReserved_CB5 SearchWSReserved CB5CBBoolean0
141WSReserved_CB6 SearchWSReserved CB6CBBoolean0
142WSReserved_CB7 SearchWSReserved CB7CBBoolean0
143WSReserved_CB8 SearchWSReserved CB8CBBoolean0
144WSReserved_CB9 SearchWSReserved CB9CBBoolean0
145WSReserved_CB10 SearchWSReserved CB10CBBoolean0
146WSReserved_STR1 SearchWSReserved STR1STR10String10
147WSReserved_STR2 SearchWSReserved STR2STR10String10

Leave a Reply

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