SV_Tech_Board_Join (SV90002)

azurecurve Products WennSoft Products (131)3rd PartySV_Tech_Board_Join (SV90002)

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

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

Display Name: SV_Tech_Board_Join
Physical Name: SV90002
Technical Name: SV_Tech_Board_Join

Group Display Name: SERVICE
Group Technical Name: SERVICE

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

azurecurve Products WennSoft Products (131)3rd PartySV_Tech_Board_Join (SV90002)

Click to show/hide

Leave a Reply Cancel reply