SV_Master_Contract_MSTR (SV00650)

azurecurve Products WennSoft Products (131)3rd PartySV_Master_Contract_MSTR (SV00650)

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

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

Display Name: SV_Master_Contract_MSTR
Physical Name: SV00650
Technical Name: SV_Master_Contract_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_Master_Contract_MSTR'].CUSTNMBR AS 'SV_Master_Contract_MSTR-Customer Number' ,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number' FROM SV00650 AS ['SV_Master_Contract_MSTR'] INNER JOIN RM00101 AS ['RM Customer MSTR'] ON ['SV_Master_Contract_MSTR'].CUSTNMBR = ['RM Customer MSTR'].CUSTNMBR
2	Corporate_Contract_Nbr	Corporate Contract Number	STR20_LBAU	String	20
3	WSMSTRCONTSQ	WS Master Contract Seq Number	LI_Sequence_Number	Long Integer	10
4	Wennsoft_Affiliate	Wennsoft Affiliate	STR15_LBAU	String	15
5	Wennsoft_Region	Wennsoft Region	STR15_LBAU	String	15
6	Wennsoft_Branch	Wennsoft Branch	STR15_LBAU	String	15
7	USERID	User ID	STR15_User_ID	String	15
	Key to the Users Master (SY01400). Click to show/hide SELECT ['SV_Master_Contract_MSTR'].USERID AS 'SV_Master_Contract_MSTR-User ID' ,['Users Master'].USERID AS 'Users Master-User ID' FROM SV00650 AS ['SV_Master_Contract_MSTR'] INNER JOIN DYNAMICS..SY01400 AS ['Users Master'] ON ['SV_Master_Contract_MSTR'].USERID = ['Users Master'].USERID
8	Technician_ID	Technician ID	STR15_Employee_ID	String	15
9	Technician_Team	Technician Team	STR15_LBAU	String	15
10	Customer_Contract_Type	Customer Contract Type	STR15	String	15
11	Customer_Contract_Desc	Customer Contract Description	STR30	String	30
12	Customer_Contract_Amount	Customer Contract Amount	DLR14_RBS0_STR$	Currency	14
13	Cust_Contract_Start_Date	Customer Contract Start Date	DT	Date	8
14	Customer_Contract_End_Dt	Customer Contract End Date	DT	Date	8
15	Contract_Service_Date	Contract Service Date	INT2_U0	Integer	2
16	SLPRSNID	Salesperson ID	STR15_Salesperson_ID	String	15
	Key to the RM Salesperson Master (RM00301). Click to show/hide SELECT ['SV_Master_Contract_MSTR'].SLPRSNID AS 'SV_Master_Contract_MSTR-Salesperson ID' ,['RM Salesperson Master'].SLPRSNID AS 'RM Salesperson Master-Salesperson ID' FROM SV00650 AS ['SV_Master_Contract_MSTR'] INNER JOIN RM00301 AS ['RM Salesperson Master'] ON ['SV_Master_Contract_MSTR'].SLPRSNID = ['RM Salesperson Master'].SLPRSNID
17	COMAPPTO	Commission Applied To	GB	Integer	0
18	PRBTADCD	Primary Billto Address Code	STR15_LBAU	String	15
19	Bill_Freq	Bill Freq	DDL_Bill_Freq	Integer	0
20	Wennsoft_Close_Date	Wennsoft Close Date	DT	Date	8
21	Annual_Contract_Value	Annual Contract Value	DLR14_RBS0_STR$	Currency	14
22	Revenue_Rec_Method_ID	Revenue Recognition Method ID	INT2	Integer	2
23	Invoice_Style	Invoice Style	INT2	Integer	2
24	Multiyear_Contract_Flag	Multiyear Contract Flag	Boolean	Boolean	0
25	PORDNMBR	Purchase Order Number	Purchase Order Number	String	20
26	Current_Billing_Amount	Current Billing Amount	DLR14_RBS0_STR$	Currency	14
27	Billing_Control	Billing Control	CB_Billing_Control	Boolean	0
28	Billing_Equipment	Billing Equipment	DLR14_RBS0_STR$	Currency	14
29	Billing_Material	Billing Material	DLR14_RBS0_STR$	Currency	14
30	Billing_Labor	Billing Labor	DLR14_RBS0_STR$	Currency	14
31	Billing_Subs	Billing Subs	DLR14_RBS0_STR$	Currency	14
32	Billing_Other	Billing Other	DLR14_RBS0_STR$	Currency	14
33	Billing_Percentage_Equip	Billing Percentage Equip	DLR5_%2	Currency	8
34	Billing_Pct_Material	Billing Percentage Material	DLR5_%2	Currency	8
35	Billing_Percentage_Labor	Billing Percentage Labor	DLR5_%2	Currency	8
36	Billing_Percentage_Subs	Billing Percentage Subs	DLR5_%2	Currency	8
37	Billing_Percentage_Other	Billing Percentage Other	DLR5_%2	Currency	8
38	WSUserDefined1ID	WSUserDefined1ID	STR15_LBAU	String	15
39	WSUserDefined2ID	WSUserDefined2ID	STR15_LBAU	String	15
40	Customer_User_Define1a	Customer User Define1a	STR15	String	15
41	Customer_User_Define2a	Customer User Define2a	STR15	String	15
42	Customer_User_Define3a	Customer User Define3a	STR15	String	15
43	Customer_User_Define4a	Customer User Define4a	STR15	String	15
44	Customer_User_Define5a	Customer User Define5a	STR15	String	15
45	Customer_User_Define6a	Customer User Define6a	STR15	String	15
46	Customer_User_Define7a	Customer User Define7a	STR15	String	15
47	Customer_User_Define8a	Customer User Define8a	STR15	String	15
48	Customer_User_Define9a	Customer User Define9a	STR15	String	15
49	Customer_User_Define10a	Customer User Define10a	STR15	String	15
50	Service_User_Define_3	Service User Define 3	STR30	String	30
51	Service_User_Define_5	Service User Define 5	LI6_S2	Long Integer	6
52	Service_User_Define_6	Service User Define 6	LI6_S2	Long Integer	6
53	Service_User_Define_9	Service User Define 9	DT	Date	8
54	Service_User_Define_10	Service User Define 10	DT	Date	8
55	Service_User_Define_18	Service User Define 18	CB	Boolean	0
56	Service_User_Define_19	Service User Define 19	CB	Boolean	0
57	Service_User_Define_22	Service User Define 22	DLR14_RBS0_STR$	Currency	14
58	Service_User_Define_23	Service User Define 23	DLR14_RBS0_STR$	Currency	14
59	Service_User_Define_24	Service User Define 24	DLR14_RBS0_STR$	Currency	14
60	Contract_Billing_Date	Contract Billing Date	INT2_U0	Integer	2
61	WS_Closed	WS Closed	True/False	Boolean	0
62	Auto_Bill	Auto Bill	CB_Auto_Bill	Boolean	0
63	LSTFSCDY	Last Fiscal Day	DT_Date	Date	6
64	Auto_Date	Auto Date	DATE	Date	6
65	Cancel_Box	Cancel Box	CB_Cancel	Boolean	0
66	HOLD	Hold	CB_Hold	Boolean	0
67	Hold_Reason_ID	Hold Reason ID	INT5	Integer	4
68	MODIFDT	Modified Date	DT	Date	8
69	Modified_Time	Modified Time	TM6	Time	6
70	MDFUSRID	Modified User ID	STR15	String	15
	Key to the Users Master (SY01400). Click to show/hide SELECT ['SV_Master_Contract_MSTR'].MDFUSRID AS 'SV_Master_Contract_MSTR-Modified User ID' ,['Users Master'].USERID AS 'Users Master-User ID' FROM SV00650 AS ['SV_Master_Contract_MSTR'] INNER JOIN DYNAMICS..SY01400 AS ['Users Master'] ON ['SV_Master_Contract_MSTR'].MDFUSRID = ['Users Master'].USERID
71	Time_Zone	Time Zone	STR3	String	3
72	SV_Language_ID	SV Language ID	INT2	Integer	2
73	Escalation_Frequency	Escalation Frequency	STR15_LBAU	String	15
74	Escalation_Date	Escalation Date	DATE	Date	6
75	Escal_Notify_Days	Escalation Notification Days	INT3_U0	Integer	3
76	Next_Escalation_Date	Next Escalation Date	DATE	Date	6
77	Begin_Date_CY	Begin Date CY	DATE	Date	6
78	Anniversary_Date	Anniversary Date	DT	Date	8
79	Evergreen_Contract_Flag	Evergreen Contract Flag	Boolean	Boolean	0
80	Contract_Units_Measure	Contract Units Measure	STR15_LBAU	String	15
81	Last_Review_Date	Last Review Date	DATE	Date	6
82	Last_Review_User_ID	Last Review User ID	STR15_User_ID	String	15
83	Contract_Internal_Name	Contract Internal Name	STR15_LBAU	String	15
84	Auto_Escalation_Flag	Automatic Escalation Flag	CB	Boolean	0
85	Leave_Open_Flag	Leave Open Flag	CB_Leave_Open	Boolean	0
86	Bill_Customer_Number	Bill Customer Number	STR15_RM_Customer_Number	String	15
87	Bill_Address_Code	Bill Address Code	STR15_Address_Code	String	15
88	WSReserved_CB1	WSReserved CB1	CB	Boolean	0
89	WSReserved_CB2	WSReserved CB2	CB	Boolean	0
90	WSReserved_CB3	WSReserved CB3	CB	Boolean	0
91	WSReserved_CB4	WSReserved CB4	CB	Boolean	0
92	WSReserved_CB5	WSReserved CB5	CB	Boolean	0
93	WSReserved_CB6	WSReserved CB6	CB	Boolean	0
94	WSReserved_CB7	WSReserved CB7	CB	Boolean	0
95	WSReserved_CB8	WSReserved CB8	CB	Boolean	0
96	WSReserved_CB9	WSReserved CB9	CB	Boolean	0
97	WSReserved_CB10	WSReserved CB10	CB	Boolean	0
98	WSReserved_STR1	WSReserved STR1	STR10	String	10
99	WSReserved_STR2	WSReserved STR2	STR10	String	10

azurecurve Products WennSoft Products (131)3rd PartySV_Master_Contract_MSTR (SV00650)

Click to show/hide

Click to show/hide

Click to show/hide

Click to show/hide

Leave a Reply Cancel reply