Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/SVC3060V
Product: FieldService (949)
Series: Project
Display Name: svcContractHdrViewHIST DEX_ROW_ID is an auto-numbered IDENTITY column used internally by Dexterity for lock management; it should not be used by developers to identify any particular piece of information. Microsoft MVP Mariano Gomez has a good write up on the DEX_ROW_ID column.
Physical Name: SVC3060V
Technical Name: svcContractHdrViewHISTSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 CONSTS Contract Record Type DDL_Contract_Status Integer 0 2 CONTNBR Contract Number STR11 String 11 3 SVC_Contract_Version SVC_Contract_Version INT3 Integer 3 4 CNTTYPE Contract Type STR10_LBAU String 10 5 MSTCNTRCT Master Contract Number STR10 String 10 6 CUSTNMBR Customer Number STR15_RM_Customer_Number String 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'].CUSTNMBR
7 CUSTNAME Customer Name STR64_Customer_Name String 64 8 ADRSCODE Address Code STR15_Address_Code String 15 9 Bill_To_Customer Bill To Customer STR15_RM_Customer_Number String 15 10 SVC_Bill_To_Address_Code SVC Bill To Address Code STR15_Address_Code String 15 11 PORDNMBR Purchase Order Number Purchase Order Number String 20 12 STRTDATE Start Date DT Date 8 13 ENDDATE End Date DT Date 8 14 DSCRIPTN Description STR30 String 30 15 DEX_ROW_ID int int 10