SV Service Requests Archive (SVA0309)

azurecurve Products WennSoft Products (131)3rd PartySV Service Requests Archive (SVA0309)

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

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

Display Name: SV Service Requests Archive
Physical Name: SVA0309
Technical Name: SV_Service_Request_MSTR_Archive

Group Display Name: SERVICE
Group Technical Name: SERVICE

Seq No	Physical Name	Display Name	Dexterity Data Type	SQL Data Type	Length
1	Svc_Request_ID	Request ID	STR17	String	17
2	Svc_Request_Date	Request Date	Svc_Request_Date	Date	8
3	Svc_Request_Type	Requestor Type	Svc_Request_Type	Integer	1
4	EMPLOYID	Employee ID	STR15_Employee_ID	String	15
5	Svc_Request_Name	Requestor Name	STR31	String	31
6	Svc_Request_Address	Address	STR31	String	31
7	CITY	City	STR35	String	35
8	STATE	State	STR30_State	String	29
9	ZIP	Zip	STR10	String	10
10	Svc_Request_Phone	Phone	STR21	String	21
11	Svc_Request_Alt_Phone	Alternate Phone	STR21	String	21
12	Request_Email_Address	Email	STR41	String	41
13	Request_Notify_Method	Notify Method	STR31	String	31
14	Svc_Request_Association	Association	STR31	String	31
15	Service_Type_Group	Service Type	Svc_Request_Service_Type_Group	Integer	1
16	Request_Location_Govt	Location of Problem - Government Property	STR31	String	31
17	Request_Location_Other	Location of Problem - Non-Government Property	SSTR51	String	51
18	Location_Address	Location Address	STR22_LBAU	String	22
19	Svc_Request_Street	Location Street	STR31	String	31
20	Svc_Request_LCity	Location City	STR31	String	31
21	Svc_Request_LZip	Location ZIP	STR11	String	11
22	Type_of_Problem	Type of Problem	STR30	String	30
23	Svc_Request_Issue	Issue Description	STR31	String	31
24	Svc_Request_Issue_Date	Issue Date	Date8	Date	8
25	Previously_ReportedGroup	Previously Reported	Smallint1	Integer	1
26	Svc_Request_Department	Request Department	STR31	String	31
27	CUSTNMBR	Customer Number	STR15_RM_Customer_Number	String	15
	Key to the RM Customer MSTR (RM00101). Click to show/hide SELECT ['SV Service Requests Archive'].CUSTNMBR AS 'SV Service Requests Archive-Customer Number' ,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number' FROM SVA0309 AS ['SV Service Requests Archive'] INNER JOIN RM00101 AS ['RM Customer MSTR'] ON ['SV Service Requests Archive'].CUSTNMBR = ['RM Customer MSTR'].CUSTNMBR
28	ADRSCODE	Address Code	STR15_Address_Code	String	15
29	Service_Call_ID	Service Call ID	STR17_LBAU	String	17
30	Date1	Call Open Date	Date8	Date	8
31	WS_Time_1a	Call Open Time	TM6	Time	6
32	Svc_Actual__Department	Actual Department	STR31	String	31
33	Equipment_ID	Equipment ID	STR30	String	30
34	Equipment_Meter1_Master	Equipment Meter1 Master	LI8_U0	Long Integer	8
35	Meter_Read_Date	Meter Read Date	DT6	Date	6
36	Request_Equipment__Down	Equipment Down Flag	Boolean1	Boolean	0
37	Location_Emergency	Location Emergency Flag	Boolean1	Boolean	0
38	Dept_Emergency_Contact	Department Emergency Contact	STR41	String	41
39	Request_EmergencyContact	System Emergency Contact	STR41	String	41
40	MODIFDT	Modified Date	DT	Date	8
41	Modified_Time	Modified Time	TM6	Time	6
42	MDFUSRID	Modified User ID	STR15	String	15
	Key to the Users Master (SY01400). Click to show/hide SELECT ['SV Service Requests Archive'].MDFUSRID AS 'SV Service Requests Archive-Modified User ID' ,['Users Master'].USERID AS 'Users Master-User ID' FROM SVA0309 AS ['SV Service Requests Archive'] INNER JOIN DYNAMICS..SY01400 AS ['Users Master'] ON ['SV Service Requests Archive'].MDFUSRID = ['Users Master'].USERID
43	Service_User_Define_1	Service User Define 1	STR20	String	20
44	Service_User_Define_2	Service User Define 2	STR20	String	20
45	Service_User_Define_3	Service User Define 3	STR30	String	30
46	Service_User_Define_4	Service User Define 4	STR30	String	30
47	Service_User_Define_5	Service User Define 5	LI6_S2	Long Integer	6
48	Service_User_Define_6	Service User Define 6	LI6_S2	Long Integer	6
49	Service_User_Define_7	Service User Define 7	LI6_S2	Long Integer	6
50	Service_User_Define_8	Service User Define 8	LI6_S2	Long Integer	6
51	Service_User_Define_9	Service User Define 9	DT	Date	8
52	Service_User_Define_10	Service User Define 10	DT	Date	8
53	Service_User_Define_11	Service User Define 11	DT	Date	8
54	Service_User_Define_12	Service User Define 12	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_20	Service User Define 20	CB	Boolean	0
58	Service_User_Define_21	Service User Define 21	CB	Boolean	0
59	Service_User_Define_22	Service User Define 22	DLR14_RBS0_STR$	Currency	14
60	Service_User_Define_23	Service User Define 23	DLR14_RBS0_STR$	Currency	14
61	Service_User_Define_24	Service User Define 24	DLR14_RBS0_STR$	Currency	14
62	Service_User_Define_25	Service User Define 25	DLR14_RBS0_STR$	Currency	14
63	WSReserved_CB1	WSReserved CB1	CB	Boolean	0
64	WSReserved_CB2	WSReserved CB2	CB	Boolean	0
65	WSReserved_CB3	WSReserved CB3	CB	Boolean	0
66	WSReserved_CB4	WSReserved CB4	CB	Boolean	0
67	WSReserved_CB5	WSReserved CB5	CB	Boolean	0
68	WSReserved_CB6	WSReserved CB6	CB	Boolean	0
69	WSReserved_CB7	WSReserved CB7	CB	Boolean	0
70	WSReserved_CB8	WSReserved CB8	CB	Boolean	0
71	WSReserved_CB9	WSReserved CB9	CB	Boolean	0
72	WSReserved_CB10	WSReserved CB10	CB	Boolean	0
73	WSReserved_STR1	WSReserved STR1	STR10	String	10
74	WSReserved_STR2	WSReserved STR2	STR10	String	10
75	SVC_Request_Note	Location Description (other)	SVC_Request_Note	Text	16

azurecurve Products WennSoft Products (131)3rd PartySV Service Requests Archive (SVA0309)

Click to show/hide

Click to show/hide

Leave a Reply Cancel reply