aaMLQueryMstr (AAG00310)

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

Product: Analytical Accounting (3180)
Series: Company

Display Name: aaMLQueryMstr
Physical Name: AAG00310
Technical Name: aaMLQueryMstr

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeSQL DB LengthKeyable Length
1aaMLQueryID SearchaaMLQueryIDaaLONG_INTLong Integer48
2aaMLQuery SearchaaMLQueryaaSTR15_LBAUString1615
3aaMLQueryDescr SearchaaMLQueryDescraaStr50String5250
4aaLevelTimeSpread SearchaaLevelTimeSpreadaaDDLevelSpreadInteger20
5aaLevelCodeSpread SearchaaLevelCodeSpreadaaDDLevelSpreadInteger20
6aaCodeSpreadCol SearchaaCodeSpreadColaaINTInteger25
7aaInclBSAccts SearchaaInclBSAcctsaaCBBSAcctsBoolean20
8aaInclPLAccts SearchaaInclPLAcctsaaCBPLAcctsBoolean20
9aaInclUnitAccts SearchaaInclUnitAcctsaaCBUnitAcctsBoolean20
10aaMatchType SearchaaMatchTypeaaDDLMatchTypeInteger20
11aaCallMacro SearchaaCallMacroaaSTR255String256255
12NOTEINDX SearchNote IndexDLR14Currency1014
Key to the Record Notes Master (SY03900).

Click to show/hide

SELECT
       ['aaMLQueryMstr'].NOTEINDX AS 'aaMLQueryMstr-Note Index'
       ,['Record Notes Master'].NOTEINDX AS 'Record Notes Master-Note Index'
FROM
       AAG00310 AS ['aaMLQueryMstr']
INNER JOIN
       SY03900 AS ['Record Notes Master']
              ON
                     ['aaMLQueryMstr'].NOTEINDX = ['Record Notes Master'].NOTEINDX
13DEX_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 *