aaMvmtQueryOpt (AAG00302)

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

Product: Analytical Accounting (3180)
Series: Company

Display Name: aaDistrQueryFltr
Physical Name: AAG00302
Technical Name: aaMvmtQueryOpt

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1aaMvmtQueryID SearchaaMvmtQueryIDaaLONG_INTLong Integer48
2aaDistrQueryID SearchaaDistrQueryIDaaLONG_INTLong Integer48
3aaColumn SearchaaColumnaaINTInteger25
4aaTrxDimID SearchaaTrxDimIDaaLONG_INTLong Integer48
5aaAll SearchaaAllaaCBBoolean20
6aaSelectOption SearchaaSelectOptionaaDDLSelectOptionInteger20
7aaFromStr SearchaaFromStraaSTR30String3230
8aaIncludeEmpty SearchaaIncludeEmptyaaCBBoolean20
9aaFromDimCode SearchaaFromDimCodeaaSTR30String3230
10aaToStr SearchaaToStraaSTR30String3230
11aaToDimCode SearchaaToDimCodeaaSTR30String3230
12aaFromNum SearchaaFromNumaaDLR14Currency1014
13aaToNum SearchaaToNumaaDLR14Currency1014
14aaFromDimCodeNum SearchaaFromDimCodeNumaaDLR14Currency1014
15aaToDimCodeNum SearchaaToDimCodeNumaaDLR14Currency1014
16aaFromBool SearchaaFromBoolaaCBBoolean20
17aaToBool SearchaaToBoolaaCBBoolean20
18aaFromDimCodeBool SearchaaFromDimCodeBoolaaCBBoolean20
19aaFromDate SearchaaFromDateaaDATE_LONGDate48
20aaToDimCodeBool SearchaaToDimCodeBoolaaCBBoolean20
21aaFromDimCodeDate SearchaaFromDimCodeDateaaDATE_LONGDate48
22aaToDate SearchaaToDateaaDATE_LONGDate48
23From_Account_Number_1 SearchFrom Account Number:Account_Segment_Pool1Account_Segment_Pool1String86
24aaToDimCodeDate SearchaaToDimCodeDateaaDATE_LONGDate48
25From_Account_Number SearchFrom Account NumberAccount_NumberComposite 8080
26From_Account_Number_2 SearchFrom Account Number:Account_Segment_Pool2Account_Segment_Pool2String86
27To_Account_Number SearchTo Account NumberAccount_NumberComposite 8080
28From_Account_Number_3 SearchFrom Account Number:Account_Segment_Pool3Account_Segment_Pool3String86
29From_Account_Number_4 SearchFrom Account Number:Account_Segment_Pool4Account_Segment_Pool4String86
30From_Account_Number_5 SearchFrom Account Number:Account_Segment_Pool5Account_Segment_Pool5String86
31From_Account_Number_6 SearchFrom Account Number:Account_Segment_Pool6Account_Segment_Pool6String86
32From_Account_Number_7 SearchFrom Account Number:Account_Segment_Pool7Account_Segment_Pool7String86
33From_Account_Number_8 SearchFrom Account Number:Account_Segment_Pool8Account_Segment_Pool8String86
34From_Account_Number_9 SearchFrom Account Number:Account_Segment_Pool9Account_Segment_Pool9String86
35From_Account_Number_10 SearchFrom Account Number:Account_Segment_Pool10Account_Segment_Pool10String86
36To_Account_Number_1 SearchTo Account Number:Account_Segment_Pool1Account_Segment_Pool1String86
37To_Account_Number_2 SearchTo Account Number:Account_Segment_Pool2Account_Segment_Pool2String86
38To_Account_Number_3 SearchTo Account Number:Account_Segment_Pool3Account_Segment_Pool3String86
39To_Account_Number_4 SearchTo Account Number:Account_Segment_Pool4Account_Segment_Pool4String86
40To_Account_Number_5 SearchTo Account Number:Account_Segment_Pool5Account_Segment_Pool5String86
41To_Account_Number_6 SearchTo Account Number:Account_Segment_Pool6Account_Segment_Pool6String86
42To_Account_Number_7 SearchTo Account Number:Account_Segment_Pool7Account_Segment_Pool7String86
43To_Account_Number_8 SearchTo Account Number:Account_Segment_Pool8Account_Segment_Pool8String86
44To_Account_Number_9 SearchTo Account Number:Account_Segment_Pool9Account_Segment_Pool9String86
45To_Account_Number_10 SearchTo Account Number:Account_Segment_Pool10Account_Segment_Pool10String86
46DEX_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 *