Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/SVC00946
Product: FieldService (949)
Series:
Display Name: SVC Tech Inventory Template
Physical Name: SVC00946
Technical Name: svcTechIVTemplateSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 SVC_Tech_Inventory_ID 
SVC Tech Inventory ID String STR10_LBAU 10 2 DSCRIPTN Description String STR30 30 3 NOTEINDX Note Index Currency DLR14 14 Key to the Record Notes Master (SY03900).
Click to show/hide
SELECT
['SVC Tech Inventory Template'].NOTEINDX AS 'SVC Tech Inventory Template-Note Index'
,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
SVC00946 AS ['SVC Tech Inventory Template']
INNER JOIN
SY03900 AS ['Record Notes Master']
ON
['SVC Tech Inventory Template'].NOTEINDX = ['Record Notes Master'].NOTEINDX