TSQL Query for tables where each General ledger entry has effect Dynamics Ax 2012

For Future reference, I used following Queries to check the General Ledger Entry in Dynamics ax 2012. Small tip,

You can used them to delete posted ledger entry

select * from LEDGERJOURNALTABLE where JOURNALNUM =’XYZ-015528′

select * from LEDGERJOURNALTRANS where JOURNALNUM =’XyZ-015528′

select * from LedgerEntryJournal   where JOURNALNUMBER =’XyZ-015528′

select recid,* from GeneralJournalEntry where  LedgerEntryJournal= LedgerEntryJournal.RecID

select * from GeneralJournalAccountEntry where GeneralJournalEntry = GeneralJournalEntry.RecID