Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/SVC0060V
Product: FieldService (949)
Series:
Display Name: svcContractHdrView
Physical Name: SVC0060V
Technical Name: svcContractHdrViewSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 CONSTS 
Contract Record Type Integer DDL_Contract_Status 0 2 CONTNBR Contract Number String STR11 11 3 CNTTYPE Contract Type String STR10_LBAU 10 4 MSTCNTRCT Master Contract Number String STR10 10 5 CUSTNMBR Customer Number String STR15_RM_Customer_Number 15 Key to the RM Customer MSTR (RM00101).
Click to show/hide
SELECT
['svcContractHdrView'].CUSTNMBR AS 'svcContractHdrView-Customer Number'
,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number'
FROM
SVC0060V AS ['svcContractHdrView']
INNER JOIN
RM00101 AS ['RM Customer MSTR']
ON
['svcContractHdrView'].CUSTNMBR = ['RM Customer MSTR'].CUSTNMBR6 CUSTNAME Customer Name String STR64_Customer_Name 64 7 ADRSCODE Address Code String STR15_Address_Code 15 8 Bill_To_Customer Bill To Customer String STR15_RM_Customer_Number 15 9 SVC_Bill_To_Address_Code SVC Bill To Address Code String STR15_Address_Code 15 10 PORDNMBR Purchase Order Number String Purchase Order Number 20 11 STRTDATE Start Date Date DT 8 12 ENDDATE End Date Date DT 8 13 DSCRIPTN Description String STR30 30