X++ SQL 代码转换为 SQL Server 代码 - 税务交易转换

以下是将 X++ 代码转换为 SQL Server 的 SQL 代码：\n\nSELECT taxTransCur10.TaxValue, SUM(taxTransCur10.SourceBaseAmountCur), SUM(taxTransCur10.SourceTaxAmountCur)\nFROM custInvoiceJour_WCur\nJOIN custConsInvoice_JP ON custInvoiceJour_WCur.CustConsInvoice_JP = custConsInvoice_JP.RecId\nJOIN custInvoiceJourCur ON custInvoiceJourCur.RecId = custInvoiceJour_WCur.CustInvoiceJour\nJOIN custInvoiceTransCur ON custInvoiceTransCur.SalesId = custInvoiceJourCur.SalesId\n\tAND custInvoiceTransCur.InvoiceId = custInvoiceJourCur.InvoiceId\n\tAND custInvoiceTransCur.InvoiceDate = custInvoiceJourCur.InvoiceDate\n\tAND custInvoiceTransCur.numberSequenceGroup = custInvoiceJourCur.numberSequenceGroup\nLEFT JOIN ledgerJournalTransCur ON ledgerJournalTransCur.JournalNum = journalBatchNumber\n\tAND ledgerJournalTransCur.Invoice = custInvoiceJourCur.InvoiceId\n\tAND ledgerJournalTransCur.TransDate = custInvoiceJourCur.InvoiceDate\n\tAND ledgerJournalTransCur.Voucher = custInvoiceJourCur.LedgerVoucher\nLEFT JOIN dimensionAttributeValueCombinationCur ON dimensionAttributeValueCombinationCur.RecId = ledgerJournalTransCur.LedgerDimension\n\tAND dimensionAttributeValueCombinationCur.DisplayValue = custInvoiceJourCur.InvoiceAccount\nJOIN taxTransCur10 ON (taxTransCur10.SourceRecId = custInvoiceTransCur.RecId\n\tAND taxTransCur10.SourceTableId = custInvoiceTransCur.TableId)\n\tOR (taxTransCur10.SourceRecId = ledgerJournalTransCur.RecId\n\tAND taxTransCur10.SourceTableId = ledgerJournalTransCur.TableId)\nWHERE taxTransCur10.TaxValue = 10\nGROUP BY taxTransCur10.TaxValue;