SV_SQL_Dispatch_Join (SV70001)

azurecurve Products WennSoft Products (131)3rd PartySV_SQL_Dispatch_Join (SV70001)

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

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

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

azurecurve Products WennSoft Products (131)3rd PartySV_SQL_Dispatch_Join (SV70001)

Click to show/hide

Leave a Reply Cancel reply