Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/SVC0060V
Product: FieldService (949)
Series: Project
Display Name: svcContractHdrView 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: SVC0060V
Technical Name: svcContractHdrViewSeq 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 CNTTYPE Contract Type STR10_LBAU String 10 4 MSTCNTRCT Master Contract Number STR10 String 10 5 CUSTNMBR Customer Number STR15_RM_Customer_Number String 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'].CUSTNMBR
6 CUSTNAME Customer Name STR64_Customer_Name String 64 7 ADRSCODE Address Code STR15_Address_Code String 15 8 Bill_To_Customer Bill To Customer STR15_RM_Customer_Number String 15 9 SVC_Bill_To_Address_Code SVC Bill To Address Code STR15_Address_Code String 15 10 PORDNMBR Purchase Order Number Purchase Order Number String 20 11 STRTDATE Start Date DT Date 8 12 ENDDATE End Date DT Date 8 13 DSCRIPTN Description STR30 String 30 14 DEX_ROW_ID int int 10