aaMLQueryDet (AAG00314)

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

Product: Analytical Accounting (3180)
Series: Company

Display Name: aaMLQueryDet
Physical Name: AAG00314
Technical Name: aaMLQueryDet

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1aaMLQueryID SearchaaMLQueryIDaaLONG_INTLong Integer48
2aaColumn SearchaaColumnaaINTInteger25
3aaUseTree SearchaaUseTreeaaCBBoolean20
4aaUseCodes SearchaaUseCodesaaCBBoolean20
5aaTreeID SearchaaTreeIDaaLONG_INTLong Integer48
6aaTreeLevel SearchaaTreeLevelaaLONG_INTLong Integer48
7aaInclEmptyCodes SearchaaInclEmptyCodesaaCBBoolean20
8aaSelectOption SearchaaSelectOptionaaDDLSelectOptionInteger20
9aaFromStr SearchaaFromStraaSTR30String3230
10aaToStr SearchaaToStraaSTR30String3230
11aaFromNum SearchaaFromNumaaDLR14Currency1014
12aaToNum SearchaaToNumaaDLR14Currency1014
13aaFromBool SearchaaFromBoolaaCBBoolean20
14aaToBool SearchaaToBoolaaCBBoolean20
15aaFromDate SearchaaFromDateaaDATE_LONGDate48
16aaToDate SearchaaToDateaaDATE_LONGDate48
17From_Account_Number_1 SearchFrom Account Number:Account_Segment_Pool1Account_Segment_Pool1String86
18From_Account_Number SearchFrom Account NumberAccount_NumberComposite 8080
19To_Account_Number SearchTo Account NumberAccount_NumberComposite 8080
20From_Account_Number_2 SearchFrom Account Number:Account_Segment_Pool2Account_Segment_Pool2String86
21From_Account_Number_3 SearchFrom Account Number:Account_Segment_Pool3Account_Segment_Pool3String86
22From_Account_Number_4 SearchFrom Account Number:Account_Segment_Pool4Account_Segment_Pool4String86
23From_Account_Number_5 SearchFrom Account Number:Account_Segment_Pool5Account_Segment_Pool5String86
24From_Account_Number_6 SearchFrom Account Number:Account_Segment_Pool6Account_Segment_Pool6String86
25From_Account_Number_7 SearchFrom Account Number:Account_Segment_Pool7Account_Segment_Pool7String86
26From_Account_Number_8 SearchFrom Account Number:Account_Segment_Pool8Account_Segment_Pool8String86
27From_Account_Number_9 SearchFrom Account Number:Account_Segment_Pool9Account_Segment_Pool9String86
28From_Account_Number_10 SearchFrom Account Number:Account_Segment_Pool10Account_Segment_Pool10String86
29To_Account_Number_1 SearchTo Account Number:Account_Segment_Pool1Account_Segment_Pool1String86
30To_Account_Number_2 SearchTo Account Number:Account_Segment_Pool2Account_Segment_Pool2String86
31To_Account_Number_3 SearchTo Account Number:Account_Segment_Pool3Account_Segment_Pool3String86
32To_Account_Number_4 SearchTo Account Number:Account_Segment_Pool4Account_Segment_Pool4String86
33To_Account_Number_5 SearchTo Account Number:Account_Segment_Pool5Account_Segment_Pool5String86
34To_Account_Number_6 SearchTo Account Number:Account_Segment_Pool6Account_Segment_Pool6String86
35To_Account_Number_7 SearchTo Account Number:Account_Segment_Pool7Account_Segment_Pool7String86
36To_Account_Number_8 SearchTo Account Number:Account_Segment_Pool8Account_Segment_Pool8String86
37To_Account_Number_9 SearchTo Account Number:Account_Segment_Pool9Account_Segment_Pool9String86
38To_Account_Number_10 SearchTo Account Number:Account_Segment_Pool10Account_Segment_Pool10String86
39DEX_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 *