Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/PO50103
Product: WennSoft Products (131)
Series: Purchasing
Display Name: PO_Escalation_Group_MSTR
Physical Name: PO50103
Technical Name: PO_Escalation_Group_MSTRSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 PO_User_EscalationGrDesc 
PO_User_Escalation_Group_Desc_STR STR50 String 50 2 PO_User_Escalation_Group PO_User_Escalation_Group_ID_STR STR15_Escalation_ID String 15 3 NOTEINDX Note Index DLR14 Currency 14 Key to the Record Notes Master (SY03900).
Click to show/hide
SELECT
['PO_Escalation_Group_MSTR'].NOTEINDX AS 'PO_Escalation_Group_MSTR-Note Index'
,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
PO50103 AS ['PO_Escalation_Group_MSTR']
INNER JOIN
SY03900 AS ['Record Notes Master']
ON
['PO_Escalation_Group_MSTR'].NOTEINDX = ['Record Notes Master'].NOTEINDX