AX2012Ledger Transaction 的数据由原来的LedgerTrans一张表,分为GenerJournalAccountEntry, GeneralJournalEntry, SubledgeVoucherGeneralJournalEntry,
LedgerEntry(可选), LedgerEntryJournal(可选),和LedgerEntryJournalizing(可选)六张表. 另外TaxRefId字段被表TaxTransGeneralJournalAccountEntry link表替代.
取某一特定交易日期数据:
select RecId from generalJournalAccountEntry
join RecId from generalJournalEntry
where generalJournalEntry.RecId == generalJournalAccountEntry.GeneralJournalEntry
&& generalJournalEntry.AccountingDate == <transaction date input>
取某一特定凭证和交易日期数据:
select RecId from generalJournalAccountEntry
join RecId from generalJournalEntry
where generalJournalEntry.RecId == generalJournalAccountEntry.GeneralJournalEntry
join RecId from subledgerVoucherGeneralJournalEntry
where subledgerVoucherGeneralJournalEntry.GeneralJournalEntry == generalJournalEntry.RecId
&& subledgerVoucherGeneralJo