SV_Maint_Annual_MSTR_Archive (SVA0550)

azurecurve Products WennSoft Products (131)3rd PartySV_Maint_Annual_MSTR_Archive (SVA0550)

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

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

Display Name: SV_Maint_Annual_MSTR_Archive
Physical Name: SVA0550
Technical Name: SV_Maint_Annual_MSTR_Archive

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_Maint_Annual_MSTR_Archive'].CUSTNMBR AS 'SV_Maint_Annual_MSTR_Archive-Customer Number' ,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number' FROM SVA0550 AS ['SV_Maint_Annual_MSTR_Archive'] INNER JOIN RM00101 AS ['RM Customer MSTR'] ON ['SV_Maint_Annual_MSTR_Archive'].CUSTNMBR = ['RM Customer MSTR'].CUSTNMBR
2	ADRSCODE	Address Code	STR15_Address_Code	String	15
3	Equipment_ID	Equipment ID	STR30	String	30
4	Contract_Number	WS Contract Number	STR10	String	10
5	WSCONTSQ	WS Contract Number Sequence	LI_Sequence_Number	Long Integer	10
6	Wennsoft_Affiliate	Wennsoft Affiliate	STR15_LBAU	String	15
7	Wennsoft_Region	Wennsoft Region	STR15_LBAU	String	15
8	Wennsoft_Branch	Wennsoft Branch	STR15_LBAU	String	15
9	USERID	User ID	STR15_User_ID	String	15
	Key to the Users Master (SY01400). Click to show/hide SELECT ['SV_Maint_Annual_MSTR_Archive'].USERID AS 'SV_Maint_Annual_MSTR_Archive-User ID' ,['Users Master'].USERID AS 'Users Master-User ID' FROM SVA0550 AS ['SV_Maint_Annual_MSTR_Archive'] INNER JOIN DYNAMICS..SY01400 AS ['Users Master'] ON ['SV_Maint_Annual_MSTR_Archive'].USERID = ['Users Master'].USERID
10	HOLD	Hold	CB_Hold	Boolean	0
11	Cancel_Box	Cancel Box	CB_Cancel	Boolean	0
12	Task_Estimated_Hours1	Task Estimated Hours1	INT3	Integer	3
13	Task_Estimated_Hours2	Task Estimated Hours2	INT3	Integer	3
14	Task_Estimated_Hours3	Task Estimated Hours3	INT3	Integer	3
15	Task_Estimated_Hours4	Task Estimated Hours4	INT3	Integer	3
16	Task_Estimated_Hours5	Task Estimated Hours5	INT3	Integer	3
17	Divisions	Divisions	STR15_LBAU	String	15
18	Technician	Technician	STR10_LBAU	String	10
19	Service_Call_ID	Service Call ID	STR17_LBAU	String	17
20	Service_Area	Service Area	STR15_LBAU	String	15
21	First_Mailer_Sent	First Mailer Sent	CB	Boolean	0
22	Contract_Expiration_Date	Contract Experation Date	DT	Date	8
23	Contract_Description	Contract Description	STR30_LBAU	String	30
24	Technician_ID	Technician ID	STR15_Employee_ID	String	15
25	Technician_Team	Technician Team	STR15_LBAU	String	15
26	Wennsoft_Model_Number	Wennsoft Model Number	STR20	String	20
27	Equipment_Type	Equipment Type	STR30	String	30
28	Manufacturer_ID	Manufacturer ID	STR15_LBAU	String	15
29	ITEMNMBR	Item Number	STR30_Item_Number	String	30
	Key to the Item Master (IV00101). Click to show/hide SELECT ['SV_Maint_Annual_MSTR_Archive'].ITEMNMBR AS 'SV_Maint_Annual_MSTR_Archive-Item Number' ,['Item Master'].ITEMNMBR AS 'Item Master-Item Number' FROM SVA0550 AS ['SV_Maint_Annual_MSTR_Archive'] INNER JOIN IV00101 AS ['Item Master'] ON ['SV_Maint_Annual_MSTR_Archive'].ITEMNMBR = ['Item Master'].ITEMNMBR
30	Do_Task_1	Do Task[1]	CB_Do_Task	Boolean	0
31	Do_Task_2	Do Task[2]	CB_Do_Task	Boolean	0
32	Do_Task_3	Do Task[3]	CB_Do_Task	Boolean	0
33	Do_Task_4	Do Task[4]	CB_Do_Task	Boolean	0
34	Do_Task_5	Do Task[5]	CB_Do_Task	Boolean	0
35	Task_Override_Amount_1	Task Override Amount[1]	DLR14	Currency	14
36	Task_Override_Amount_2	Task Override Amount[2]	DLR14	Currency	14
37	Task_Override_Amount_3	Task Override Amount[3]	DLR14	Currency	14
38	Task_Override_Amount_4	Task Override Amount[4]	DLR14	Currency	14
39	Task_Override_Amount_5	Task Override Amount[5]	DLR14	Currency	14
40	Override_Amount_Flag	Override Amount Flag	STR_10	String	10
41	Report_Break	Report Break	STR50	String	50
42	Estimated_Service_Date	Estimated Service Date	DT	Date	8
43	Response_Date	Response Date	DT	Date	8
44	Tot_Summer_Service_Tasks	Total Summer Service Tasks	DLR14_$U2	Currency	16
45	Service_User_Define_1	Service User Define 1	STR20	String	20
46	Service_User_Define_2	Service User Define 2	STR20	String	20
47	Service_User_Define_3	Service User Define 3	STR30	String	30
48	Service_User_Define_4	Service User Define 4	STR30	String	30
49	Service_User_Define_5	Service User Define 5	LI6_S2	Long Integer	6
50	Service_User_Define_6	Service User Define 6	LI6_S2	Long Integer	6
51	Service_User_Define_7	Service User Define 7	LI6_S2	Long Integer	6
52	Service_User_Define_8	Service User Define 8	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_11	Service User Define 11	DT	Date	8
56	Service_User_Define_12	Service User Define 12	DT	Date	8
57	Service_User_Define_18	Service User Define 18	CB	Boolean	0
58	Service_User_Define_19	Service User Define 19	CB	Boolean	0
59	Service_User_Define_20	Service User Define 20	CB	Boolean	0
60	Service_User_Define_21	Service User Define 21	CB	Boolean	0
61	Service_User_Define_22	Service User Define 22	DLR14_RBS0_STR$	Currency	14
62	Service_User_Define_23	Service User Define 23	DLR14_RBS0_STR$	Currency	14
63	Service_User_Define_24	Service User Define 24	DLR14_RBS0_STR$	Currency	14
64	Service_User_Define_25	Service User Define 25	DLR14_RBS0_STR$	Currency	14
65	MODIFDT	Modified Date	DT	Date	8
66	Modified_Time	Modified Time	TM6	Time	6
67	MDFUSRID	Modified User ID	STR15	String	15
	Key to the Users Master (SY01400). Click to show/hide SELECT ['SV_Maint_Annual_MSTR_Archive'].MDFUSRID AS 'SV_Maint_Annual_MSTR_Archive-Modified User ID' ,['Users Master'].USERID AS 'Users Master-User ID' FROM SVA0550 AS ['SV_Maint_Annual_MSTR_Archive'] INNER JOIN DYNAMICS..SY01400 AS ['Users Master'] ON ['SV_Maint_Annual_MSTR_Archive'].MDFUSRID = ['Users Master'].USERID
68	Time_Zone	Time Zone	STR3	String	3
69	SV_Language_ID	SV Language ID	INT2	Integer	2
70	Base_Currency_ID	Base Currency ID	STR15_Currency_ID	String	15
71	Billing_Currency_ID	Billing Currency ID	STR15_Currency_ID	String	15
72	Local_Currency_ID	Local Currency ID	STR15_Currency_ID	String	15
73	WSReserved_CB1	WSReserved CB1	CB	Boolean	0
74	WSReserved_CB2	WSReserved CB2	CB	Boolean	0
75	WSReserved_CB3	WSReserved CB3	CB	Boolean	0
76	WSReserved_CB4	WSReserved CB4	CB	Boolean	0
77	WSReserved_CB5	WSReserved CB5	CB	Boolean	0
78	WSReserved_CB6	WSReserved CB6	CB	Boolean	0
79	WSReserved_CB7	WSReserved CB7	CB	Boolean	0
80	WSReserved_CB8	WSReserved CB8	CB	Boolean	0
81	WSReserved_CB9	WSReserved CB9	CB	Boolean	0
82	WSReserved_CB10	WSReserved CB10	CB	Boolean	0
83	WSReserved_STR1	WSReserved STR1	STR10	String	10
84	WSReserved_STR2	WSReserved STR2	STR10	String	10

azurecurve Products WennSoft Products (131)3rd PartySV_Maint_Annual_MSTR_Archive (SVA0550)

Click to show/hide

Click to show/hide

Click to show/hide

Click to show/hide

Leave a Reply Cancel reply