Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/SVC3060V
Product: FieldService (949)
Series:
Display Name: svcContractHdrViewHIST
Physical Name: SVC3060V
Technical Name: svcContractHdrViewHISTSeq 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 SVC_Contract_Version SVC_Contract_Version Integer INT3 3 4 CNTTYPE Contract Type String STR10_LBAU 10 5 MSTCNTRCT Master Contract Number String STR10 10 6 CUSTNMBR Customer Number String STR15_RM_Customer_Number 15 Key to the RM Customer MSTR (RM00101).
Click to show/hide
SELECT
['svcContractHdrViewHIST'].CUSTNMBR AS 'svcContractHdrViewHIST-Customer Number'
,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number'
FROM
SVC3060V AS ['svcContractHdrViewHIST']
INNER JOIN
RM00101 AS ['RM Customer MSTR']
ON
['svcContractHdrViewHIST'].CUSTNMBR = ['RM Customer MSTR'].CUSTNMBR7 CUSTNAME Customer Name String STR64_Customer_Name 64 8 ADRSCODE Address Code String STR15_Address_Code 15 9 Bill_To_Customer Bill To Customer String STR15_RM_Customer_Number 15 10 SVC_Bill_To_Address_Code SVC Bill To Address Code String STR15_Address_Code 15 11 PORDNMBR Purchase Order Number String Purchase Order Number 20 12 STRTDATE Start Date Date DT 8 13 ENDDATE End Date Date DT 8 14 DSCRIPTN Description String STR30 30