我正在使用access 2013,并尝试识别向供应商支付的重复付款。我使用下面的SQL查询来识别不同类型的重复,但它没有给出预期的结果,因为有时两个条件是不同的,如发票编号和发票日期。
SELECT
Base.ID AS SerialNumber,
Base.CoCd AS CoCode,
Base.DocumentNo AS DocID,
Base.ClrngdocNo AS ClearingDoc,
Base.DocumentType AS DocType,
Base.Account AS VendorName,
Base.Reference AS InvoiceNumber
我在IBM Hyperledger Composer中定义了以下业务网络
========================================
namespace org.india.invoicefinance
enum InvoiceState {
o SUBMITTED
o APPROVED
o REJECTED
o FINANCED
}
asset InvoiceLedger identified by invoiceNumber {
o String invoiceNumber
o DateTime invoiceDt