Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/AAG60001
Product: Analytical Accounting (3180)
Series:
Display Name: aaGLWorkDistReport
Physical Name: AAG60001
Technical Name: aaGLWorkDistReportSeq 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
['aaGLWorkDistReport'].USERID AS 'aaGLWorkDistReport-User ID'
,['Users Master'].USERID AS 'Users Master-User ID'
FROM
AAG60001 AS ['aaGLWorkDistReport']
INNER JOIN
DYNAMICS..SY01400 AS ['Users Master']
ON
['aaGLWorkDistReport'].USERID = ['Users Master'].USERID2 TRXBTCHSRC aaTRXBatchSource String aaStr50 50 3 SERIES Series Integer DDL_Series 0 4 aaGLWorkHdrID aaGLWorkHdrID Long Integer aaLONG_INT 8 5 aaGLWorkDistID aaGLWorkDistID Long Integer aaLONG_INT 8 6 ACTINDX Account Index Long Integer LI_14 14 Key to the Account Index Master (GL00105).
Click to show/hide
SELECT
['aaGLWorkDistReport'].ACTINDX AS 'aaGLWorkDistReport-Account Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
AAG60001 AS ['aaGLWorkDistReport']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['aaGLWorkDistReport'].ACTINDX = ['Account Index Master'].ACTINDX7 DEBITAMT Debit Amount Currency DLR19_$S2 19 8 CRDTAMNT Credit Amount Currency DLR19_$S2 19 9 ORDBTAMT Originating Debit Amount Currency DLR19_$S2 19 10 ORCRDAMT Originating Credit Amount Currency DLR19_$S2 19 11 CURNCYID Currency ID String STR15_Currency_ID 15 Key to the Currency Setup (MC40200).
Click to show/hide
SELECT
['aaGLWorkDistReport'].CURNCYID AS 'aaGLWorkDistReport-Currency ID'
,['Currency Setup'].CURNCYID AS 'Currency Setup-Currency ID'
FROM
AAG60001 AS ['aaGLWorkDistReport']
INNER JOIN
DYNAMICS..MC40200 AS ['Currency Setup']
ON
['aaGLWorkDistReport'].CURNCYID = ['Currency Setup'].CURNCYID12 CURRNIDX Currency Index Integer INT3 3 Key to the Currency Setup (MC40200).
Click to show/hide
SELECT
['aaGLWorkDistReport'].CURRNIDX AS 'aaGLWorkDistReport-Currency Index'
,['Currency Setup'].CURRNIDX AS 'Currency Setup-Currency Index'
FROM
AAG60001 AS ['aaGLWorkDistReport']
INNER JOIN
DYNAMICS..MC40200 AS ['Currency Setup']
ON
['aaGLWorkDistReport'].CURRNIDX = ['Currency Setup'].CURRNIDX