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: aaMLQueryUsrWrkSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 USERID User ID String STR15_User_ID 15 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
2 YEAR1 Year Integer Year 4 3 aaYearFld aaYearFld String aaStr32 32 4 From_Period From Period Integer INT3 3 5 To_Period To Period Integer INT3 3 6 aaPerFld aaPerFld String aaStr32 32 7 aaPerStr aaPerStr String aaStr32 32 8 aaEmptyCodeStr aaEmptyCodeStr String aaStr32 32 9 aaTimeSpreadUsed aaTimeSpreadUsed Boolean aaBoolean 0 10 aaCodeSpreadUsed aaCodeSpreadUsed Boolean aaBoolean 0 11 aaCodeSpreadCol aaCodeSpreadCol Integer aaINT 5 12 THSSPRTR Thousands Separator String STR1 1 13 DECSPRTR Decimal Separator String STR1 1 14 aaNegSignLeft aaNegativeSignLeft String aaSTR1 1 15 aaNegSignRight aaNegativeSignRight String aaSTR1 1 16 aaTruncateTo aaTruncateTo Integer aaINT 5 17 aaClearEmptyCells aaClearEmptyCells Boolean aaCBClearEmptyCells 0 18 aaSQLCreate aaSQLCreate Text aaText32k 32000 19 aaSQLInsert aaSQLInsert Text aaText32k 32000 20 aaSQLSelect aaSQLSelect Text aaText32k 32000 21 aaSQLFrom aaSQLFrom Text aaText32k 32000 22 aaSQLWhere aaSQLWhere Text aaText32k 32000 23 aaSQLGroupBy aaSQLGroupBy Text aaText32k 32000 24 aaSQLCols aaSQLColumns Text aaText32k 32000