Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/AAG00300
Product: Analytical Accounting (3180)
Series:
Display Name: aaDistrQueryMstr
Physical Name: AAG00300
Technical Name: aaDistrQueryMstrSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 aaMvmtQueryID 
aaMvmtQueryID Long Integer aaLONG_INT 8 2 aaDistrQueryID aaDistrQueryID Long Integer aaLONG_INT 8 3 aaMvmtQuery aaMvmtQuery String aaSTR15_LBAU 15 4 aaDistrQuery aaDistrQuery String aaSTR15_LBAU 15 5 aaDistrQueryDescr aaDistrQueryDescr String aaSTR50 50 6 aaMvmtQueryDescr aaMvmtQueryDescr String aaSTR50 50 7 aaInclBSAccts aaInclBSAccts Boolean aaCBBSAccts 0 8 aaRestrictAccts aaRestrictAccts Integer aaRGRestrictAccts 0 9 aaInclPLAccts aaInclPLAccts Boolean aaCBPLAccts 0 10 aaAll aaAll Boolean aaCB 0 11 aaInclUnitAccts aaInclUnitAccts Boolean aaCBUnitAccts 0 12 From_Account_Number_1 From Account Number:Account_Segment_Pool1 String Account_Segment_Pool1 6 13 aaCallMacro aaCallMacro String aaSTR255 255 14 From_Account_Number_2 From Account Number:Account_Segment_Pool2 String Account_Segment_Pool2 6 15 From_Account_Number_3 From Account Number:Account_Segment_Pool3 String Account_Segment_Pool3 6 16 aaMatchType aaMatchType Integer aaDDLMatchType 0 17 NOTEINDX Note Index Currency DLR14 14 Key to the Record Notes Master (SY03900).
Click to show/hide
SELECT
['aaDistrQueryMstr'].NOTEINDX AS 'aaDistrQueryMstr-Note Index'
,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
AAG00300 AS ['aaDistrQueryMstr']
INNER JOIN
SY03900 AS ['Record Notes Master']
ON
['aaDistrQueryMstr'].NOTEINDX = ['Record Notes Master'].NOTEINDX18 From_Account_Number_4 From Account Number:Account_Segment_Pool4 String Account_Segment_Pool4 6 19 From_Account_Number_5 From Account Number:Account_Segment_Pool5 String Account_Segment_Pool5 6 20 From_Account_Number_6 From Account Number:Account_Segment_Pool6 String Account_Segment_Pool6 6 21 From_Account_Number_7 From Account Number:Account_Segment_Pool7 String Account_Segment_Pool7 6 22 From_Account_Number_8 From Account Number:Account_Segment_Pool8 String Account_Segment_Pool8 6 23 From_Account_Number_9 From Account Number:Account_Segment_Pool9 String Account_Segment_Pool9 6 24 From_Account_Number_10 From Account Number:Account_Segment_Pool10 String Account_Segment_Pool10 6 25 To_Account_Number_1 To Account Number:Account_Segment_Pool1 String Account_Segment_Pool1 6 26 To_Account_Number_2 To Account Number:Account_Segment_Pool2 String Account_Segment_Pool2 6 27 To_Account_Number_3 To Account Number:Account_Segment_Pool3 String Account_Segment_Pool3 6 28 To_Account_Number_4 To Account Number:Account_Segment_Pool4 String Account_Segment_Pool4 6 29 To_Account_Number_5 To Account Number:Account_Segment_Pool5 String Account_Segment_Pool5 6 30 To_Account_Number_6 To Account Number:Account_Segment_Pool6 String Account_Segment_Pool6 6 31 To_Account_Number_7 To Account Number:Account_Segment_Pool7 String Account_Segment_Pool7 6 32 To_Account_Number_8 To Account Number:Account_Segment_Pool8 String Account_Segment_Pool8 6 33 To_Account_Number_9 To Account Number:Account_Segment_Pool9 String Account_Segment_Pool9 6 34 To_Account_Number_10 To Account Number:Account_Segment_Pool10 String Account_Segment_Pool10 6