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

 

select * from custtrans where   custtrans.VOUCHER      in

–ACCOUNTNUM =’Cust-02032′ and

(

select LedgerJournalTrans.VOUCHER from   LedgerJournalTrans

join  LEDGERJOURNALTABLE

on LedgerJournalTrans.JOURNALNUM = LEDGERJOURNALTABLE.JOURNALNUM