Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/PA02010
Product: Project Accounting (258)
Series:
Display Name: PA RR Cycle MSTR
Physical Name: PA02010
Technical Name: PA_RR_Cycle_MSTRSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 PABILLCYCLEID1 PA RR Cycle ID String STR15_LBAU 15 2 PABILLCYCLEDESC1 PA RR Cycle Description String STR40 40 3 NOTEINDX Note Index Currency DLR14 14 Key to the Record Notes Master (SY03900).
Click to show/hide
SELECT
['PA RR Cycle MSTR'].NOTEINDX AS 'PA RR Cycle MSTR-Note Index'
,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
PA02010 AS ['PA RR Cycle MSTR']
INNER JOIN
SY03900 AS ['Record Notes Master']
ON
['PA RR Cycle MSTR'].NOTEINDX = ['Record Notes Master'].NOTEINDX