Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/aagError
Product: Analytical Accounting (3180)
Series:
Display Name: aagErrorReportGL
Physical Name: aagError
Technical Name: aagErrorReportGLSeq No Physical Name Display Name Dexterity Data Type SQL Data Type Length 1 ACTDESCR Account Description String STR50 50 2 aaGLWorkHdrID aaGLWorkHdrID Long Integer aaLONG_INT 8 3 JRNENTRY Journal Entry Long Integer LI8_U0 8 4 aaErrorNum aaErrorNum Integer INT4 4 5 aaTrxDim aaTrxDim String aaSTR30_LBAU 30 6 aaGLWorkDistID aaGLWorkDistID Long Integer aaLONG_INT 8 7 ACTINDX Account Index Long Integer LI_14 14 Key to the Account Index Master (GL00105).
Click to show/hide
SELECT
['aagErrorReportGL'].ACTINDX AS 'aagErrorReportGL-Account Index'
,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index'
FROM
aagError AS ['aagErrorReportGL']
INNER JOIN
GL00105 AS ['Account Index Master']
ON
['aagErrorReportGL'].ACTINDX = ['Account Index Master'].ACTINDX
8 aaTrxDimDescr aaTrxDimDescr String aaStr50 50 9 aaAccountClass aaAccountClass String aaSTR15_LBAU 15 10 aaTrxDimCode aaTrxDimCode String aaSTR30_LBAU 30 11 aaAcctClassID aaAccountClassID Long Integer aaLONG_INT 8 12 USERID User ID String STR15_User_ID 15 Key to the Users Master (SY01400).
Click to show/hide
SELECT
['aagErrorReportGL'].USERID AS 'aagErrorReportGL-User ID'
,['Users Master'].USERID AS 'Users Master-User ID'
FROM
aagError AS ['aagErrorReportGL']
INNER JOIN
DYNAMICS..SY01400 AS ['Users Master']
ON
['aagErrorReportGL'].USERID = ['Users Master'].USERID
13 aaGLWorkAssignID aaGLWorkAssignID Long Integer aaLONG_INT 8 14 ACTNUMBR_1 Account Number:Account_Segment_Pool1 String Account_Segment_Pool1 6 15 ACTNUMBR Account Number Account_Number Composite 80 16 ACTNUMBR_2 Account Number:Account_Segment_Pool2 String Account_Segment_Pool2 6 17 ACTNUMBR_3 Account Number:Account_Segment_Pool3 String Account_Segment_Pool3 6 18 ACTNUMBR_4 Account Number:Account_Segment_Pool4 String Account_Segment_Pool4 6 19 ACTNUMBR_5 Account Number:Account_Segment_Pool5 String Account_Segment_Pool5 6 20 ACTNUMBR_6 Account Number:Account_Segment_Pool6 String Account_Segment_Pool6 6 21 ACTNUMBR_7 Account Number:Account_Segment_Pool7 String Account_Segment_Pool7 6 22 ACTNUMBR_8 Account Number:Account_Segment_Pool8 String Account_Segment_Pool8 6 23 ACTNUMBR_9 Account Number:Account_Segment_Pool9 String Account_Segment_Pool9 6 24 ACTNUMBR_10 Account Number:Account_Segment_Pool10 String Account_Segment_Pool10 6 25 aaRelatedTrxDim aaRelatedTrxDim String aaSTR15_LBAU 15 26 aaRelatedTrxDimCode aaRelatedTrxDimCode String aaSTR30 30