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 TypeLength
1aaDistrQueryID SearchaaDistrQueryIDaaLONG_INTLong Integer8
2aaMvmtQueryID SearchaaMvmtQueryIDaaLONG_INTLong Integer8
3aaMvmtQuery SearchaaMvmtQueryaaSTR15_LBAUString15
4aaDistrQuery SearchaaDistrQueryaaSTR15_LBAUString15
5aaDistrQueryDescr SearchaaDistrQueryDescraaSTR50String50
6aaMvmtQueryDescr SearchaaMvmtQueryDescraaSTR50String50
7aaRestrictAccts SearchaaRestrictAcctsaaRGRestrictAcctsInteger0
8aaInclBSAccts SearchaaInclBSAcctsaaCBBSAcctsBoolean0
9aaInclPLAccts SearchaaInclPLAcctsaaCBPLAcctsBoolean0
10aaAll SearchaaAllaaCBBoolean0
11From_Account_Number_1 SearchFrom Account Number:Account_Segment_Pool1Account_Segment_Pool1String6
12aaInclUnitAccts SearchaaInclUnitAcctsaaCBUnitAcctsBoolean0
13aaCallMacro SearchaaCallMacroaaSTR255String255
14From_Account_Number_2 SearchFrom Account Number:Account_Segment_Pool2Account_Segment_Pool2String6
15From_Account_Number_3 SearchFrom Account Number:Account_Segment_Pool3Account_Segment_Pool3String6
16aaMatchType SearchaaMatchTypeaaDDLMatchTypeInteger0
17NOTEINDX SearchNote IndexDLR14Currency14
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_Pool4String6
19From_Account_Number_5 SearchFrom Account Number:Account_Segment_Pool5Account_Segment_Pool5String6
20From_Account_Number_6 SearchFrom Account Number:Account_Segment_Pool6Account_Segment_Pool6String6
21From_Account_Number_7 SearchFrom Account Number:Account_Segment_Pool7Account_Segment_Pool7String6
22From_Account_Number_8 SearchFrom Account Number:Account_Segment_Pool8Account_Segment_Pool8String6
23From_Account_Number_9 SearchFrom Account Number:Account_Segment_Pool9Account_Segment_Pool9String6
24From_Account_Number_10 SearchFrom Account Number:Account_Segment_Pool10Account_Segment_Pool10String6
25To_Account_Number_1 SearchTo Account Number:Account_Segment_Pool1Account_Segment_Pool1String6
26To_Account_Number_2 SearchTo Account Number:Account_Segment_Pool2Account_Segment_Pool2String6
27To_Account_Number_3 SearchTo Account Number:Account_Segment_Pool3Account_Segment_Pool3String6
28To_Account_Number_4 SearchTo Account Number:Account_Segment_Pool4Account_Segment_Pool4String6
29To_Account_Number_5 SearchTo Account Number:Account_Segment_Pool5Account_Segment_Pool5String6
30To_Account_Number_6 SearchTo Account Number:Account_Segment_Pool6Account_Segment_Pool6String6
31To_Account_Number_7 SearchTo Account Number:Account_Segment_Pool7Account_Segment_Pool7String6
32To_Account_Number_8 SearchTo Account Number:Account_Segment_Pool8Account_Segment_Pool8String6
33To_Account_Number_9 SearchTo Account Number:Account_Segment_Pool9Account_Segment_Pool9String6
34To_Account_Number_10 SearchTo Account Number:Account_Segment_Pool10Account_Segment_Pool10String6
35DEX_ROW_ID Searchintint10

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 *