Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/NCABR217
Product: Advanced Bank Reconciliation (2440)
Series: Financial
Display Name: NC_Deposit_Group_MSTR
Physical Name: NCABR217
Technical Name: NC_Deposit_Group_MSTRSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 NC_Deposit_Group_ID 
NC Deposit Group ID STR20_LBAU String 20 2 NC_Description NC_Description STR30 String 30 3 NOTEINDX Note Index DLR14 Currency 14 Key to the Record Notes Master (SY03900).
Click to show/hide
SELECT
['NC_Deposit_Group_MSTR'].NOTEINDX AS 'NC_Deposit_Group_MSTR-Note Index'
,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
NCABR217 AS ['NC_Deposit_Group_MSTR']
INNER JOIN
SY03900 AS ['Record Notes Master']
ON
['NC_Deposit_Group_MSTR'].NOTEINDX = ['Record Notes Master'].NOTEINDX4 NC_Next_Deposit_Number NC Next Deposit Number STR20_Document_Number String 20 5 NC_Date_Mask NC Date Mask STR20 String 20 6 NC_Separator NC Separator STR2 String 2