SV_Dispatch_Join (SV90001)

azurecurve Products WennSoft Products (131)3rd PartySV_Dispatch_Join (SV90001)

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

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

Display Name: SV_Dispatch_Join
Physical Name: SV90001
Technical Name: SV_Dispatch_Join

Group Display Name: SERVICE
Group Technical Name: SERVICE

Seq No	Physical Name	Display Name	Dexterity Data Type	SQL Data Type	Length
1	Service_Call_ID	Service Call ID	STR17_LBAU	String	17
2	Type_of_Problem	Type of Problem	STR30	String	30
3	Technician	Technician	STR10_LBAU	String	10
4	Priority_of_Call	Priority of Call	STR1	String	1
5	Status_of_Call	Status of Call	STR10_LBAU	String	10
6	LOCATNNM	Location Name	STR30	String	30
7	Service_Description	Service Description	STR30_LBAU	String	30
8	Purchase_Order	Purchase Order	STR15	String	15
9	Division	Division	DDL_Division	Integer	0
10	Divisions	Divisions	STR15_LBAU	String	15
11	Contract_Number	WS Contract Number	STR10	String	10
12	WSCONTSQ	WS Contract Number Sequence	LI_Sequence_Number	Long Integer	10
13	User_Define_1a	User Define 1a	STR30	String	30
14	User_Define_2a	User Define 2a	STR30	String	30
15	User_Define_3a	User Define 3a	STR30	String	30
16	User_Define_4a	User Define 4a	STR30	String	30
17	Type_Call_Short	Type Call Short	STR3_LBAU	String	3
18	Type_of_Call	Type of Call	STR15	String	15
19	CUSTNMBR	Customer Number	STR15_RM_Customer_Number	String	15
	Key to the RM Customer MSTR (RM00101). Click to show/hide SELECT ['SV_Dispatch_Join'].CUSTNMBR AS 'SV_Dispatch_Join-Customer Number' ,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number' FROM SV90001 AS ['SV_Dispatch_Join'] INNER JOIN RM00101 AS ['RM Customer MSTR'] ON ['SV_Dispatch_Join'].CUSTNMBR = ['RM Customer MSTR'].CUSTNMBR
20	CUSTNAME	Customer Name	STR64_Customer_Name	String	64
21	Call_Invoice_Number	Call Invoice Number	STR17_LBAU	String	17
22	ADRSCODE	Address Code	STR15_Address_Code	String	15
23	Technician_Team	Technician Team	STR15_LBAU	String	15
24	Service_Area	Service Area	STR15_LBAU	String	15
25	Wennsoft_Affiliate	Wennsoft Affiliate	STR15_LBAU	String	15
26	Wennsoft_Region	Wennsoft Region	STR15_LBAU	String	15
27	Wennsoft_Branch	Wennsoft Branch	STR15_LBAU	String	15
28	Completion_Date	SV Completion Date	DT	Date	8
29	Appointment	Appointment	STR25	String	25
30	Appointment_Status	Appointment Status	STR10_LBAU	String	10
31	Appointment_Type	Appointment Type	DDL_Appointment_Type	Integer	0
32	Estimate_Hours	Estimate Hours	LI6_S2	Long Integer	6
33	STRTTIME	Start Time	TM6	Time	6
34	Task_Date	Task Date	Date	Date	10
35	Resolution_ID	Resolution ID	STR3_LBAU	String	3
36	Resolution_Description	Resolution Description	STR30	String	30
37	Skill_Level	Skill Level	STR15_LBAU	String	15
38	ADDRESS1	Address 1	STR60	String	60
39	ADDRESS2	Address 2	STR60	String	60
40	CNTCPRSN	Contact Person	STR60	String	60
41	PHONE1	Phone 1	Phone_Number	String	14
42	Contract_Description	Contract Description	STR30_LBAU	String	30
43	Contract_Internal_Name	Contract Internal Name	STR15_LBAU	String	15
44	WS_Job_Number	WS Job Number	STR17_LBAU	String	17
45	Cost_Code_Alias	Cost Code Alias	STR26	String	26
46	Location_Time_Zone_Tag	Location Time Zone Tag	STR4	String	4
47	Location_Start_Time	Location Start Time	TM6	Time	6
48	Location_Task_Date	Location Task Date	Date	Date	10
49	Technician_Time_Zone_Tag	Technician Time Zone Tag	STR4	String	4
50	Technician_Start_Time	Technician Start Time	TM6	Time	6
51	Technician_Task_Date	Technician Task Date	Date	Date	10

azurecurve Products WennSoft Products (131)3rd PartySV_Dispatch_Join (SV90001)

Click to show/hide

Leave a Reply Cancel reply