Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/AAG70001
Product: Analytical Accounting (3180)
Series:
Display Name: aaGLDistReport
Physical Name: AAG70001
Technical Name: aaGLDistReportSeq 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
['aaGLDistReport'].USERID AS 'aaGLDistReport-User ID'
,['Users Master'].USERID AS 'Users Master-User ID'
FROM
AAG70001 AS ['aaGLDistReport']
INNER JOIN
DYNAMICS..SY01400 AS ['Users Master']
ON
['aaGLDistReport'].USERID = ['Users Master'].USERID
2 TRXBTCHSRC aaTRXBatchSource String aaStr50 50 3 SERIES Series Integer DDL_Series 0 4 aaGLHdrID aaGLHdrID Long Integer aaLONG_INT 8 5 aaGLDistID aaGLDistID 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
['aaGLDistReport'].ACTINDX AS 'aaGLDistReport-Account Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
AAG70001 AS ['aaGLDistReport']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['aaGLDistReport'].ACTINDX = ['Account Index Master'].ACTINDX
7 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
['aaGLDistReport'].CURNCYID AS 'aaGLDistReport-Currency ID'
,['Currency Setup'].CURNCYID AS 'Currency Setup-Currency ID'
FROM
AAG70001 AS ['aaGLDistReport']
INNER JOIN
DYNAMICS..MC40200 AS ['Currency Setup']
ON
['aaGLDistReport'].CURNCYID = ['Currency Setup'].CURNCYID
12 CURRNIDX Currency Index Integer INT3 3 Key to the Currency Setup (MC40200).
Click to show/hide
SELECT
['aaGLDistReport'].CURRNIDX AS 'aaGLDistReport-Currency Index'
,['Currency Setup'].CURRNIDX AS 'Currency Setup-Currency Index'
FROM
AAG70001 AS ['aaGLDistReport']
INNER JOIN
DYNAMICS..MC40200 AS ['Currency Setup']
ON
['aaGLDistReport'].CURRNIDX = ['Currency Setup'].CURRNIDX