SV_Quote_MSTR (SV00502)

azurecurve Products WennSoft Products (131)3rd PartySV_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 No	Physical Name	Display Name	Dexterity Data Type	SQL Data Type	Length
1	CUSTNMBR	Customer Number	STR15_RM_Customer_Number	String	15
	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
2	ADRSCODE	Address Code	STR15_Address_Code	String	15
3	Quote_Number	Quote Number	STR10	String	10
4	Quote_Type	Quote Type	DDL_Quote_Type	Integer	0
5	QUOTEDAT	Quote Date	DT	Date	8
6	QUOEXPDA	Quote Expiration Date	DT	Date	8
7	Contract_Number	WS Contract Number	STR10	String	10
8	WSCONTSQ	WS Contract Number Sequence	LI_Sequence_Number	Long Integer	10
9	Wennsoft_Affiliate	Wennsoft Affiliate	STR15_LBAU	String	15
10	Wennsoft_Region	Wennsoft Region	STR15_LBAU	String	15
11	Wennsoft_Branch	Wennsoft Branch	STR15_LBAU	String	15
12	Contract_Description	Contract Description	STR30_LBAU	String	30
13	Contract_Internal_Name	Contract Internal Name	STR15_LBAU	String	15
14	USERID	User ID	STR15_User_ID	String	15
	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
15	Contract_Amount	Contract Amount	DLR14_RBS0_UTR$	Currency	14
16	Bill_Freq	Bill Freq	DDL_Bill_Freq	Integer	0
17	Contract_Billing_Date	Contract Billing Date	INT2_U0	Integer	2
18	SLPRSNID	Salesperson ID	STR15_Salesperson_ID	String	15
	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
19	SVSLARES	SV Service Level ID	STR10_LBAU	String	10
20	User_Define_1a	User Define 1a	STR30	String	30
21	User_Define_2a	User Define 2a	STR30	String	30
22	User_Define_3a	User Define 3a	STR30	String	30
23	User_Define_4a	User Define 4a	STR30	String	30
24	Forecast_Original_Equip	Forecast Original Equipment	DLR14_RBS0_STR$	Currency	14
25	Fore_Orig_Material	Forecast Original Material	DLR14_RBS0_STR$	Currency	14
26	Forecast_Orig_Labor_1	Forecast Orig Labor 1	DLR14_RBS0_STR$	Currency	14
27	Forecast_Orig_Labor1_Hrs	Forecast Orig Labor 1 Hours	LI6_S2	Long Integer	6
28	Forecast_Orig_Labor_2	Forecast Orig Labor 2	DLR14_RBS0_STR$	Currency	14
29	Fore_Orig_Labor_2_Hrs	Forecast Orig Labor 2 Hours	LI6_S2	Long Integer	6
30	Forecast_Orig_Labor_3	Forecast Orig Labor 3	DLR14_RBS0_STR$	Currency	14
31	Forecast_Orig_Labor3_Hrs	Forecast Orig Labor 3 Hours	LI6_S2	Long Integer	6
32	Forecast_Orig_Labor_4	Forecast Orig Labor 4	DLR14_RBS0_STR$	Currency	14
33	Forecast_Orig_Labor4_Hrs	Forecast Orig Labor 4 Hours	LI6_S2	Long Integer	6
34	Forecast_Orig_Labor_5	Forecast Orig Labor 5	DLR14_RBS0_STR$	Currency	14
35	Forecast_Orig_Labor5_Hrs	Forecast Orig Labor 5 Hours	LI6_S2	Long Integer	6
36	Forecast_Original_Labor	Forecast Original Labor	DLR14_RBS0_STR$	Currency	14
37	Forecast_Original_Subs	Forecast Original Subs	DLR14_RBS0_STR$	Currency	14
38	Forecast_Original_Other	Forecast Original Other	DLR14_RBS0_STR$	Currency	14
39	Forecast_Orig_Tot_Labor	Forecast Orig Total Labor	DLR14_RBS0_STR$	Currency	14
40	Fore_Orig_Tot_Lbr_Hrs	Forecast Orig Total Labor Hrs	LI6_S2	Long Integer	6
41	Forecast_Equipment	Forecast Equipment	DLR14_RBS0_STR$	Currency	14
42	Forecast_Material	Forecast Material	DLR14_RBS0_STR$	Currency	14
43	Forecast_Labor_1	Forecast Labor 1	DLR14_RBS0_STR$	Currency	14
44	Forecast_Labor_1_Hours	Forecast Labor 1 Hours	LI6_S2	Long Integer	6
45	Forecast_Labor_2	Forecast Labor 2	DLR14_RBS0_STR$	Currency	14
46	Forecast_Labor_2_Hours	Forecast Labor 2 Hours	LI6_S2	Long Integer	6
47	Forecast_Labor_3	Forecast Labor 3	DLR14_RBS0_STR$	Currency	14
48	Forecast_Labor_3_Hours	Forecast Labor 3 Hours	LI6_S2	Long Integer	6
49	Forecast_Labor_4	Forecast Labor 4	DLR14_RBS0_STR$	Currency	14
50	Forecast_Labor_4_Hours	Forecast Labor 4 Hours	LI6_S2	Long Integer	6
51	Forecast_Labor_5	Forecast Labor 5	DLR14_RBS0_STR$	Currency	14
52	Forecast_Labor_5_Hours	Forecast Labor 5 Hours	LI6_S2	Long Integer	6
53	Forecast_Labor	Forecast Labor	DLR14_RBS0_STR$	Currency	14
54	Forecast_Subs	Forecast Subs	DLR14_RBS0_STR$	Currency	14
55	Forecast_Other	Forecast Other	DLR14_RBS0_STR$	Currency	14
56	Forecast_Total_Cost	Forecast Total Cost	DLR14_RBS0_STR$	Currency	14
57	Forecast_Total_Labor	Forecast Total Labor	DLR14_RBS0_STR$	Currency	14
58	Forecast_Total_Labor_Hrs	Forecast Total Labor Hrs	LI6_S2	Long Integer	6
59	Billing_Equipment	Billing Equipment	DLR14_RBS0_STR$	Currency	14
60	Billing_Material	Billing Material	DLR14_RBS0_STR$	Currency	14
61	Billing_Labor_1	Billing Labor 1	DLR14_RBS0_STR$	Currency	14
62	Billing_Labor_1_Hours	Billing Labor 1 Hours	LI6_S2	Long Integer	6
63	Billing_Labor_2	Billing Labor 2	DLR14_RBS0_STR$	Currency	14
64	Billing_Labor_2_Hours	Billing Labor 2 Hours	LI6_S2	Long Integer	6
65	Billing_Labor_3	Billing Labor 3	DLR14_RBS0_STR$	Currency	14
66	Billing_Labor_3_Hours	Billing Labor 3 Hours	LI6_S2	Long Integer	6
67	Billing_Labor_4	Billing Labor 4	DLR14_RBS0_STR$	Currency	14
68	Billing_Labor_4_Hours	Billing Labor 4 Hours	LI6_S2	Long Integer	6
69	Billing_Labor_5	Billing Labor 5	DLR14_RBS0_STR$	Currency	14
70	Billing_Labor_5_Hours	Billing Labor 5 Hours	LI6_S2	Long Integer	6
71	Billing_Labor	Billing Labor	DLR14_RBS0_STR$	Currency	14
72	Billing_Labor_Hours	Billing Labor Hours	LI6_S2	Long Integer	6
73	Billing_Subs	Billing Subs	DLR14_RBS0_STR$	Currency	14
74	Billing_Other	Billing Other	DLR14_RBS0_STR$	Currency	14
75	Billing_Total	Billing Total	DLR14_RBS0_STR$	Currency	14
76	Billing_Percentage_Equip	Billing Percentage Equip	DLR5_%2	Currency	8
77	Billing_Pct_Material	Billing Percentage Material	DLR5_%2	Currency	8
78	Billing_Percentage_Labor	Billing Percentage Labor	DLR5_%2	Currency	8
79	Billing_Percentage_Subs	Billing Percentage Subs	DLR5_%2	Currency	8
80	Billing_Percentage_Other	Billing Percentage Other	DLR5_%2	Currency	8
81	Billing_Percentage_Total	Billing Percentage Total	DLR5_%2	Currency	8
82	Estimate_Equipment	Estimate Equipment	DLR14_RBS0_STR$	Currency	14
83	Estimate_Material	Estimate Material	DLR14_RBS0_STR$	Currency	14
84	Estimate_Labor_1	Estimate Labor 1	DLR14_RBS0_STR$	Currency	14
85	Estimate_Labor_1_Hours	Estimate Labor 1 Hours	LI6_S2	Long Integer	6
86	Estimate_Labor_2	Estimate Labor 2	DLR14_RBS0_STR$	Currency	14
87	Estimate_Labor_2_Hours	Estimate Labor 2 Hours	LI6_S2	Long Integer	6
88	Estimate_Labor_3	Estimate Labor 3	DLR14_RBS0_STR$	Currency	14
89	Estimate_Labor_3_Hours	Estimate Labor 3 Hours	LI6_S2	Long Integer	6
90	Estimate_Labor_4	Estimate Labor 4	DLR14_RBS0_STR$	Currency	14
91	Estimate_Labor_4_Hours	Estimate Labor 4 Hours	LI6_S2	Long Integer	6
92	Estimate_Labor_5	Estimate Labor 5	DLR14_RBS0_STR$	Currency	14
93	Estimate_Labor_5_Hours	Estimate Labor 5 Hours	LI6_S2	Long Integer	6
94	Estimate_Labor	Estimate Labor	DLR14_RBS0_STR$	Currency	14
95	Estimate_Hours	Estimate Hours	LI6_S2	Long Integer	6
96	Estimate_Subs	Estimate Subs	DLR14_RBS0_STR$	Currency	14
97	Estimate_Other	Estimate Other	DLR14_RBS0_STR$	Currency	14
98	Estimate_Total_Cost	Estimate Total Cost	DLR14_RBS0_STR$	Currency	14
99	Estimate_Total_Labor	Estimate Total Labor	DLR14_RBS0_STR$	Currency	14
100	Estimate_Total_Labor_Hrs	Estimate Total Labor Hrs	LI6_S2	Long Integer	6
101	Annual_Contract_Value	Annual Contract Value	DLR14_RBS0_STR$	Currency	14
102	Revenue_Rec_Method_ID	Revenue Recognition Method ID	INT2	Integer	2
103	Invoice_Style	Invoice Style	INT2	Integer	2
104	Multiyear_Contract_Flag	Multiyear Contract Flag	Boolean	Boolean	0
105	Contract_Start_Date	WS Contract Start Date	DT	Date	8
106	Contract_Expiration_Date	Contract Experation Date	DT	Date	8
107	Service_User_Define_3	Service User Define 3	STR30	String	30
108	Service_User_Define_5	Service User Define 5	LI6_S2	Long Integer	6
109	Service_User_Define_6	Service User Define 6	LI6_S2	Long Integer	6
110	Service_User_Define_9	Service User Define 9	DT	Date	8
111	Service_User_Define_10	Service User Define 10	DT	Date	8
112	Service_User_Define_18	Service User Define 18	CB	Boolean	0
113	Service_User_Define_19	Service User Define 19	CB	Boolean	0
114	Service_User_Define_22	Service User Define 22	DLR14_RBS0_STR$	Currency	14
115	Service_User_Define_23	Service User Define 23	DLR14_RBS0_STR$	Currency	14
116	Service_User_Define_24	Service User Define 24	DLR14_RBS0_STR$	Currency	14
117	Auto_Bill	Auto Bill	CB_Auto_Bill	Boolean	0
118	Cancel_Box	Cancel Box	CB_Cancel	Boolean	0
119	HOLD	Hold	CB_Hold	Boolean	0
120	Excess_Cost	Excess Cost	DLR14_RBS0_STR$	Currency	14
121	Contract_NTE_Units	Contract NTE Units	LI8	Long Integer	8
122	Contract_Actual_Units	Contract Actual Units	LI8	Long Integer	8
123	Warranty_Checkbox	Warranty Checkbox	CB_Warranty	Boolean	0
124	MODIFDT	Modified Date	DT	Date	8
125	Modified_Time	Modified Time	TM6	Time	6
126	MDFUSRID	Modified User ID	STR15	String	15
	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
127	Time_Zone	Time Zone	STR3	String	3
128	Base_Currency_ID	Base Currency ID	STR15_Currency_ID	String	15
129	Billing_Currency_ID	Billing Currency ID	STR15_Currency_ID	String	15
130	Local_Currency_ID	Local Currency ID	STR15_Currency_ID	String	15
131	Hold_Reason_ID	Hold Reason ID	INT5	Integer	4
132	Last_Review_Date	Last Review Date	DATE	Date	6
133	Last_Review_User_ID	Last Review User ID	STR15_User_ID	String	15
134	Evergreen_Contract_Flag	Evergreen Contract Flag	Boolean	Boolean	0
135	Contract_Units_Measure	Contract Units Measure	STR15_LBAU	String	15
136	Pricing_Matrix_Name	Pricing Matrix Name	STR15_RM_Customer_Number	String	15
137	WSReserved_CB1	WSReserved CB1	CB	Boolean	0
138	WSReserved_CB2	WSReserved CB2	CB	Boolean	0
139	WSReserved_CB3	WSReserved CB3	CB	Boolean	0
140	WSReserved_CB5	WSReserved CB5	CB	Boolean	0
141	WSReserved_CB6	WSReserved CB6	CB	Boolean	0
142	WSReserved_CB7	WSReserved CB7	CB	Boolean	0
143	WSReserved_CB8	WSReserved CB8	CB	Boolean	0
144	WSReserved_CB9	WSReserved CB9	CB	Boolean	0
145	WSReserved_CB10	WSReserved CB10	CB	Boolean	0
146	WSReserved_STR1	WSReserved STR1	STR10	String	10
147	WSReserved_STR2	WSReserved STR2	STR10	String	10

azurecurve Products WennSoft Products (131)3rd PartySV_Quote_MSTR (SV00502)

Click to show/hide

Click to show/hide

Click to show/hide

Click to show/hide

Leave a Reply Cancel reply