Zack
asked on
AX - Mysteries Dimension fields
Hi EE,
The following post describes the fields of
dalve.DIMENSIONATTRIBUTE
dalvp.DIMENSIONATTRIBUTE
dalvf.DIMENSIONATTRIBUTE
daftp.CATEGORY
daftf.CATEGORY
https://community.dynamics.com/ax/f/microsoft-dynamics-ax-forum/414852/voucher-transaction-error-hexadecimal-value-0x02-is-an-invalid-character/1135163
What are these fields and how do they relate to this query in terms of filtering results?
Any assistance is welcome.
Thank you.
The following post describes the fields of
dalve.DIMENSIONATTRIBUTE
dalvp.DIMENSIONATTRIBUTE
dalvf.DIMENSIONATTRIBUTE
daftp.CATEGORY
daftf.CATEGORY
https://community.dynamics.com/ax/f/microsoft-dynamics-ax-forum/414852/voucher-transaction-error-hexadecimal-value-0x02-is-an-invalid-character/1135163
select
gje.SUBLEDGERVOUCHER "Voucher",
gje.ACCOUNTINGDATE,
m.MAINACCOUNTID "Account",
m.NAME "AccountName",
gjae.TEXT as Description,CHARINDEX(0x02, CAST(TEXT AS varbinary(30))) Position,
gjae.*
from GENERALJOURNALENTRY gje
inner join ledger com on gje.LEDGER = com.RECID --and gje.[PARTITION] = com.[PARTITION]
inner join GENERALJOURNALACCOUNTENTRY gjae on gje.RECID = gjae.GENERALJOURNALENTRY --and gje.[PARTITION] = gjae.[PARTITION]
inner join DIMENSIONATTRIBUTEVALUECOMBINATION davc on gjae.LEDGERDIMENSION = davc.RECID --and gje.[PARTITION] = davc.[PARTITION]
inner join MAINACCOUNT m on davc.MAINACCOUNT = m.RECID --and davc.[PARTITION] = m.[PARTITION]
inner join [FISCALCALENDARPERIOD] FCP ON gje.[FISCALCALENDARPERIOD] = FCP.[RECID] --and gje.[PARTITION] = FCP.[PARTITION]
inner join [FISCALCALENDARYEAR] FCY ON gje.FISCALCALENDARYEAR = FCY.RECID and gje.[PARTITION] = FCY.[PARTITION] -- AND FCY.FISCALCALENDAR = FCP.FISCALCALENDAR
left join MainAccountCategory mc ON mc.ACCOUNTCATEGORYREF = m.ACCOUNTCATEGORYREF --and mc.[PARTITION] = m.[PARTITION]
left join DIMENSIONATTRIBUTELEVELVALUEVIEW dalvd on davc.recid= dalvd.VALUECOMBINATIONRECID and dalvd.DIMENSIONATTRIBUTE = 5637144826
left join [DIMENSIONATTRIBUTEVALUE] dav on dav.DIMENSIONATTRIBUTE = dalvd.DIMENSIONATTRIBUTE and dav.ENTITYINSTANCE = dalvd.ENTITYINSTANCE
left join [DIMATTRIBUTEOMDEPARTMENT] daod on -- dalvd.DISPLAYVALUE = daod.VALUE
daod.[KEY_] = dav.ENTITYINSTANCE
left join DIMENSIONATTRIBUTELEVELVALUEVIEW dalvf on davc.recid= dalvf.VALUECOMBINATIONRECID and dalvf.DIMENSIONATTRIBUTE = 5637145326
left join [DIMATTRTRANSLFINANCIALTAG] daftf on dalvf.DISPLAYVALUE = daftf.VALUE and daftf.CATEGORY = 5637144577 --and daftf.LANGUAGEID = 'en-us'
left join DIMENSIONATTRIBUTELEVELVALUEVIEW dalvp on davc.recid= dalvp.VALUECOMBINATIONRECID and dalvp.DIMENSIONATTRIBUTE = 5637145327
left join [DIMATTRTRANSLFINANCIALTAG] daftp on dalvp.DISPLAYVALUE = daftp.VALUE and daftp.CATEGORY = 5637144576 --and daftp.LANGUAGEID = 'en-us'
left join DIMENSIONATTRIBUTELEVELVALUEVIEW dalve on davc.recid= dalve.VALUECOMBINATIONRECID and dalve.DIMENSIONATTRIBUTE = 5637145576
left join SRSANALYSISENUMS enumLPT ON enumLPT.ENUMNAME = 'LedgerPostingType' AND enumLPT.ENUMITEMVALUE = gjae.POSTINGTYPE
left join subledgerVoucherGeneralJournalEntry svgje ON svgje.GENERALJOURNALENTRY = gje.RECID AND svgje.VOUCHERDATAAREAID = gje.SUBLEDGERVOUCHERDATAAREAID AND svgje.VOUCHER = gje.SUBLEDGERVOUCHER
where
gje.ACCOUNTINGDATE BETWEEN '08/01/2020' AND '12/31/2020'
and com.NAME in ('EF')
--and CHARINDEX(0x02, CAST(TEXT AS varbinary(30))) > 0 --Add this line to discover errors.
What are these fields and how do they relate to this query in terms of filtering results?
Any assistance is welcome.
Thank you.
ASKER
Hi netminder
What they used for with a few examples if possible.
Thank you
What they used for with a few examples if possible.
Thank you
Sorry but I don't know what you are asking.
If you are asking what the DimensionAttribute column in the DIMENSIONATTRIBUTELEVELVAL UEVIEW view is actually used for, I'm not going to be able to help because I don't know or use Microsoft Dynamics.
If you are asking what the DimensionAttribute column in the DIMENSIONATTRIBUTELEVELVAL
ASKER
Hi Netminder,
Correct that is my question: DimensionAttribute column in the DIMENSIONATTRIBUTELEVELVALUEVIEW view is actually used for.
Cheers for the responding though.
Correct that is my question: DimensionAttribute column in the DIMENSIONATTRIBUTELEVELVALUEVIEW view is actually used for.
Cheers for the responding though.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
For example, a quick Google of "DIMENSIONATTRIBUTELEVELVA
https://cloudblogs.microsoft.com/dynamics365/no-audience/2011/10/13/financial-journal-dimension-table-relations-on-ax-2012/
What specifically are you looking to find on these tables/columns?