project QadFinancials > class BDInvoice > business logic query DInvoiceForInvoiceCert

Description

Query that returns the invoice-certification related fields based upon a DInvoiceID.


Parameters


iiCompanyIdintegerCompany id
iiDInvoiceIDintegerID fo the DInvoice.


query condition


  each DInvoice where
DInvoice.Company_Id = iiCompanyId AND
DInvoice.DInvoice_ID = iiDInvoiceID


query resultset tqDInvoiceForInvoiceCert


field namedata typedb fielddescription
tiDInvoice_IDintegerDInvoice.DInvoice_IDRecord ID
tcDInvoiceInvCertCertificatecharacterDInvoice.DInvoiceInvCertCertificateDuplicate field from SysProperty
tcDInvoiceInvCertKeycharacterDInvoice.DInvoiceInvCertKeyInvoice Certification Key
tcDInvoiceInvCertSignatureCurrcharacterDInvoice.DInvoiceInvCertSignatureCurrSignature Current Invoice
tcDInvoiceInvCertSignaturePrevcharacterDInvoice.DInvoiceInvCertSignaturePrevSignature Previous Invoice


Internal usage


QadFinancials
method BDInvoice.VerifySignature
method BDInvoiceJournalEntry.ApiStdMaintainTTV01