aaMvmtQueryMstr (AAG00300)

Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/AAG00300

Product: Analytical Accounting (3180)
Series: Company

Display Name: aaDistrQueryMstr
Physical Name: AAG00300
Technical Name: aaDistrQueryMstr

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1aaDistrQueryID SearchaaDistrQueryIDaaLONG_INTLong Integer48
2aaMvmtQueryID SearchaaMvmtQueryIDaaLONG_INTLong Integer48
3aaMvmtQuery SearchaaMvmtQueryaaSTR15_LBAUString1615
4aaDistrQuery SearchaaDistrQueryaaSTR15_LBAUString1615
5aaDistrQueryDescr SearchaaDistrQueryDescraaSTR50String5250
6aaMvmtQueryDescr SearchaaMvmtQueryDescraaSTR50String5250
7aaRestrictAccts SearchaaRestrictAcctsaaRGRestrictAcctsInteger20
8aaInclBSAccts SearchaaInclBSAcctsaaCBBSAcctsBoolean20
9aaInclPLAccts SearchaaInclPLAcctsaaCBPLAcctsBoolean20
10aaAll SearchaaAllaaCBBoolean20
11From_Account_Number_1 SearchFrom Account Number:Account_Segment_Pool1Account_Segment_Pool1String86
12aaInclUnitAccts SearchaaInclUnitAcctsaaCBUnitAcctsBoolean20
13aaCallMacro SearchaaCallMacroaaSTR255String256255
14From_Account_Number_2 SearchFrom Account Number:Account_Segment_Pool2Account_Segment_Pool2String86
15From_Account_Number_3 SearchFrom Account Number:Account_Segment_Pool3Account_Segment_Pool3String86
16aaMatchType SearchaaMatchTypeaaDDLMatchTypeInteger20
17NOTEINDX SearchNote IndexDLR14Currency1014
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'].NOTEINDX
18From_Account_Number_4 SearchFrom Account Number:Account_Segment_Pool4Account_Segment_Pool4String86
19From_Account_Number_5 SearchFrom Account Number:Account_Segment_Pool5Account_Segment_Pool5String86
20From_Account_Number_6 SearchFrom Account Number:Account_Segment_Pool6Account_Segment_Pool6String86
21From_Account_Number_7 SearchFrom Account Number:Account_Segment_Pool7Account_Segment_Pool7String86
22From_Account_Number_8 SearchFrom Account Number:Account_Segment_Pool8Account_Segment_Pool8String86
23From_Account_Number_9 SearchFrom Account Number:Account_Segment_Pool9Account_Segment_Pool9String86
24From_Account_Number_10 SearchFrom Account Number:Account_Segment_Pool10Account_Segment_Pool10String86
25To_Account_Number_1 SearchTo Account Number:Account_Segment_Pool1Account_Segment_Pool1String86
26To_Account_Number_2 SearchTo Account Number:Account_Segment_Pool2Account_Segment_Pool2String86
27To_Account_Number_3 SearchTo Account Number:Account_Segment_Pool3Account_Segment_Pool3String86
28To_Account_Number_4 SearchTo Account Number:Account_Segment_Pool4Account_Segment_Pool4String86
29To_Account_Number_5 SearchTo Account Number:Account_Segment_Pool5Account_Segment_Pool5String86
30To_Account_Number_6 SearchTo Account Number:Account_Segment_Pool6Account_Segment_Pool6String86
31To_Account_Number_7 SearchTo Account Number:Account_Segment_Pool7Account_Segment_Pool7String86
32To_Account_Number_8 SearchTo Account Number:Account_Segment_Pool8Account_Segment_Pool8String86
33To_Account_Number_9 SearchTo Account Number:Account_Segment_Pool9Account_Segment_Pool9String86
34To_Account_Number_10 SearchTo Account Number:Account_Segment_Pool10Account_Segment_Pool10String86
35DEX_ROW_ID Searchintint1010

DEX_ROW_ID is an auto-numbered IDENTITY column used internally by Dexterity for lock management; it should not be used by developers to identify any particular piece of information.

Microsoft MVP Mariano Gomez has a good write up on the DEX_ROW_ID column.

Leave a Reply

Your email address will not be published. Required fields are marked *