aaMLQueryUsrWrk (AAG00315)

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

Product: Analytical Accounting (3180)
Series:

Display Name: aaMLQueryUsrWrk
Physical Name: AAG00315
Technical Name: aaMLQueryUsrWrk

Seq NoPhysical NameDisplay NameDexterity Data TypeSQL Data TypeLength
1USERID SearchUser IDStringSTR15_User_ID15
Key to the Users Master (SY01400).

Click to show/hide

SELECT
       ['aaMLQueryUsrWrk'].USERID AS 'aaMLQueryUsrWrk-User ID'
       ,['Users Master'].USERID AS 'Users Master-User ID'
FROM
       AAG00315 AS ['aaMLQueryUsrWrk']
INNER JOIN
       DYNAMICS..SY01400 AS ['Users Master']
              ON
                     ['aaMLQueryUsrWrk'].USERID = ['Users Master'].USERID
2YEAR1 SearchYearIntegerYear4
3aaYearFld SearchaaYearFldStringaaStr3232
4From_Period SearchFrom PeriodIntegerINT33
5To_Period SearchTo PeriodIntegerINT33
6aaPerFld SearchaaPerFldStringaaStr3232
7aaPerStr SearchaaPerStrStringaaStr3232
8aaEmptyCodeStr SearchaaEmptyCodeStrStringaaStr3232
9aaTimeSpreadUsed SearchaaTimeSpreadUsedBooleanaaBoolean0
10aaCodeSpreadUsed SearchaaCodeSpreadUsedBooleanaaBoolean0
11aaCodeSpreadCol SearchaaCodeSpreadColIntegeraaINT5
12THSSPRTR SearchThousands SeparatorStringSTR11
13DECSPRTR SearchDecimal SeparatorStringSTR11
14aaNegSignLeft SearchaaNegativeSignLeftStringaaSTR11
15aaNegSignRight SearchaaNegativeSignRightStringaaSTR11
16aaTruncateTo SearchaaTruncateToIntegeraaINT5
17aaClearEmptyCells SearchaaClearEmptyCellsBooleanaaCBClearEmptyCells0
18aaSQLCreate SearchaaSQLCreateTextaaText32k32000
19aaSQLInsert SearchaaSQLInsertTextaaText32k32000
20aaSQLSelect SearchaaSQLSelectTextaaText32k32000
21aaSQLFrom SearchaaSQLFromTextaaText32k32000
22aaSQLWhere SearchaaSQLWhereTextaaText32k32000
23aaSQLGroupBy SearchaaSQLGroupByTextaaText32k32000
24aaSQLCols SearchaaSQLColumnsTextaaText32k32000

Leave a Reply

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