SVC_Customer_Site_Call (SVC00960)

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

Display Name: SVC_Customer_Site_Call
Physical Name: SVC00960
Technical Name: SVC_Customer_Site_Call

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 ['SVC_Customer_Site_Call'].CUSTNMBR AS 'SVC_Customer_Site_Call-Customer Number' ,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number' FROM SVC00960 AS ['SVC_Customer_Site_Call'] INNER JOIN RM00101 AS ['RM Customer MSTR'] ON ['SVC_Customer_Site_Call'].CUSTNMBR = ['RM Customer MSTR'].CUSTNMBR
2	ADRSCODE	Address Code	String	STR15_Address_Code	15
3	FRSTNAME	First Name	String	STR15	15
4	LASTNAME	Last Name	String	STR20	20
5	PHONNAME	Phone Number	String	Phone_Number	14
6	FAXNUMBR	Fax Number	String	STR14_FAX	14
7	ANI_Number	ANI Number	String	STR_ANI_Number	12
8	EMail	EMail	String	STR255	255