Customer Site Extensions (SVC00950)

azurecurve Products FieldService (949)ProjectCustomer Site Extensions (SVC00950)

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

Display Name: Customer Site Extensions
Physical Name: SVC00950
Technical Name: SVC_Customer_Site_Ext

Group Display Name: Service Table Group
Group Technical Name: Service

Seq No	Physical Name	Display Name	Dexterity Data Type	SQL Data Type	Length
1	CUSTNMBR	Customer Number	String	STR15_RM_Customer_Number	15
	Key to the RM Customer MSTR (RM00101). Click to show/hide SELECT ['Customer Site Extensions'].CUSTNMBR AS 'Customer Site Extensions-Customer Number' ,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number' FROM SVC00950 AS ['Customer Site Extensions'] INNER JOIN RM00101 AS ['RM Customer MSTR'] ON ['Customer Site Extensions'].CUSTNMBR = ['RM Customer MSTR'].CUSTNMBR
2	ADRSCODE	Address Code	String	STR15_Address_Code	15
3	WORKDYS	Work Days	CB	Boolean	0
4	WORKDYS_1	Work Days[1]	Boolean	CB	0
5	WORKDYS_2	Work Days[2]	Boolean	CB	0
6	WORKDYS_3	Work Days[3]	Boolean	CB	0
7	WORKDYS_4	Work Days[4]	Boolean	CB	0
8	WORKDYS_5	Work Days[5]	Boolean	CB	0
9	WORKDYS_6	Work Days[6]	Boolean	CB	0
10	WORKDYS_7	Work Days[7]	Boolean	CB	0
11	WORKSTRT_1	Work Start[1]	Time	TM6	6
12	WORKSTRT_2	Work Start[2]	Time	TM6	6
13	WORKSTRT	Work Start	TM6	Time	6
14	WORKSTRT_3	Work Start[3]	Time	TM6	6
15	WORKSTRT_4	Work Start[4]	Time	TM6	6
16	WORKSTRT_5	Work Start[5]	Time	TM6	6
17	WORKSTRT_6	Work Start[6]	Time	TM6	6
18	WORKSTRT_7	Work Start[7]	Time	TM6	6
19	WORKEND_1	Work End[1]	Time	TM6	6
20	WORKEND_2	Work End[2]	Time	TM6	6
21	WORKEND	Work End	TM6	Time	6
22	WORKEND_3	Work End[3]	Time	TM6	6
23	WORKEND_4	Work End[4]	Time	TM6	6
24	WORKEND_5	Work End[5]	Time	TM6	6
25	WORKEND_6	Work End[6]	Time	TM6	6
26	WORKEND_7	Work End[7]	Time	TM6	6
27	LSTSRVDTE	Last Service Date	Date	DT_Date	6
28	SVCAREA	Service Area	String	STR10_LBAU	10
29	OFFID	Office ID	String	STR10_LBAU	10
30	TECHID	Tech ID	String	STR10_LBAU	10
31	TIMEZONE	TimeZone	String	STR3_LBU	3
32	SRVTYPE	Service Type	String	STR10_LBAU	10
33	Bill_To_Customer	Bill To Customer	String	STR15_RM_Customer_Number	15
34	SVC_Address_Option	SVC_Address_Option	Integer	DDL_Address_Option	0
35	SVC_Misc_Address_Code	SVC_Misc_Address_Code	String	STR15_Address_Code	15
36	SVC_PM_Date	SVC PM Month	Integer	SVC_DDL_Month	0
37	SVC_PM_Day	SVC PM Day	Integer	SVC_PM_Day	2
38	SVC_PM_Allowed	SVC PM Allowed	Boolean	CB	0
39	SVC_Allow_Contract_0_SOP	SVC Allow Contract 0 SOP	Boolean	CB	0
40	svcPreferredDay_1	svc Preferred Day[1]	Boolean	CB	0
41	svcPreferredDay_2	svc Preferred Day[2]	Boolean	CB	0
42	svcPreferredDay_3	svc Preferred Day[3]	Boolean	CB	0
43	svcPreferredDay_4	svc Preferred Day[4]	Boolean	CB	0
44	svcPreferredDay	svc Preferred Day	CB	Boolean	0
45	svcPreferredDay_5	svc Preferred Day[5]	Boolean	CB	0
46	svcPreferredDay_6	svc Preferred Day[6]	Boolean	CB	0
47	svcPreferredDay_7	svc Preferred Day[7]	Boolean	CB	0
48	svcPreferredStartTime_1	svc Preferred Start Time[1]	Time	TM6	6
49	svcPreferredStartTime_2	svc Preferred Start Time[2]	Time	TM6	6
50	svcPreferredStartTime_3	svc Preferred Start Time[3]	Time	TM6	6
51	svcPreferredStartTime_4	svc Preferred Start Time[4]	Time	TM6	6
52	svcPreferredStartTime_5	svc Preferred Start Time[5]	Time	TM6	6
53	svcPreferredStartTime	svc Preferred Start Time	TM6	Time	6
54	svcPreferredStartTime_6	svc Preferred Start Time[6]	Time	TM6	6
55	svcPreferredStartTime_7	svc Preferred Start Time[7]	Time	TM6	6
56	svcPreferredEndTime_1	svc Preferred End Time[1]	Time	TM6	6
57	svcPreferredEndTime_2	svc Preferred End Time[2]	Time	TM6	6
58	svcPreferredEndTime_3	svc Preferred End Time[3]	Time	TM6	6
59	svcPreferredEndTime_4	svc Preferred End Time[4]	Time	TM6	6
60	svcPreferredEndTime_5	svc Preferred End Time[5]	Time	TM6	6
61	svcPreferredEndTime	svc Preferred End Time	TM6	Time	6
62	svcPreferredEndTime_6	svc Preferred End Time[6]	Time	TM6	6
63	svcPreferredEndTime_7	svc Preferred End Time[7]	Time	TM6	6
64	CNSOLDTD	Consolidated	Boolean	CB_Consolidated	0
65	svcConsolidateContractIn	svcConsolidateContractInvoice	Boolean	CB	0

azurecurve Products FieldService (949)ProjectCustomer Site Extensions (SVC00950)

Click to show/hide

Leave a Reply Cancel reply