Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/RVLSP002
Product: Scheduled Instalment (1150)
Series: Company
Display Name: Company Scheduled Instalments Master
Physical Name: RVLSP002
Technical Name: rvlPmntSchldMSTRSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 PMNTSCHLDID 
PmntSchldID STR15_LBAU String 15 2 DSCRIPTN Description STR30 String 30 3 NUMPMNT NumPmnt INT2_U0 Integer 2 4 DAYS1STP DTFirstPmnt INT3_RUO Integer 3 5 CADENCE Cadence INT3_RUO Integer 3 6 NOTEINDX Note Index DLR14 Currency 14 Key to the Record Notes Master (SY03900).
Click to show/hide
SELECT
['Company Scheduled Instalments Master'].NOTEINDX AS 'Company Scheduled Instalments Master-Note Index'
,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
RVLSP002 AS ['Company Scheduled Instalments Master']
INNER JOIN
SY03900 AS ['Record Notes Master']
ON
['Company Scheduled Instalments Master'].NOTEINDX = ['Record Notes Master'].NOTEINDX