project QadFinancials > class BMfgPurchaseVoucherHist > business logic query VoucherInvoiceHistoryForERSDet


Parameters


icDomainCodecharacter
icEDIBatchNumbercharacter
iiCompanyIdintegerCompany id


query condition


  each vph_hist where
vph_hist.vph_domain = icDomainCode AND
vph_hist.vph__qadc02 = icEDIBatchNumber

      each APMatching (inner-join) where
APMatching.Company_Id = iiCompanyId AND
APMatching.CInvoice_ID = vph_hist.vph_cinvoice_id AND

          each APMatchingLn (inner-join) where
APMatchingLn.APMatching_ID = APMatching.APMatching_ID AND
APMatchingLn.PvoDomain = vph_hist1.vph_domain AND
APMatchingLn.PvoID = vph_hist1.vph_pvo_id AND
APMatchingLn.PvodLineID = vph_hist1.vph_pvod_id_line

              each APMatchingLnTax (outer-join) where
APMatchingLnTax.APMatchingLn_ID = APMatchingLn.APMatchingLn_ID AND


query resultset tqVoucherInvoiceHistoryForERSDet


field namedata typedb fielddescription
tiAPMatching_IDintegerAPMatching.APMatching_IDRecord ID
tiAPMatchingLn_IDintegerAPMatchingLn.APMatchingLn_IDRecord ID
tdAPMatchingLnMatchAmtLCdecimalAPMatchingLn.APMatchingLnMatchAmtLCBC Matched Amount
tdAPMatchingLnMatchAmtTCdecimalAPMatchingLn.APMatchingLnMatchAmtTCTC Matched Amount
tdAPMatchingLnMatchQtydecimalAPMatchingLn.APMatchingLnMatchQtyMatched Quantity
tdAPMatchingLnMatchUnitPricedecimalAPMatchingLn.APMatchingLnMatchUnitPriceMatched Unit Price
tcAPMatchingLnPvodOrdercharacterAPMatchingLn.APMatchingLnPvodOrderOrder
tiAPMatchingLnPvodOrderLnNbrintegerAPMatchingLn.APMatchingLnPvodOrderLnNbrOrder Line Nbr
tdAPMatchingLnTaxTaxLCdecimalAPMatchingLnTax.APMatchingLnTaxTaxLCLC Tax
tdAPMatchingLnTaxTaxTCdecimalAPMatchingLnTax.APMatchingLnTaxTaxTCTC Tax
tiCInvoice_IDintegerAPMatching.CInvoice_IDVoucher
tiPvodLineIDintegerAPMatchingLn.PvodLineIDPinv Line ID
tcPvoDomaincharacterAPMatchingLn.PvoDomainDomain
tiPvoIDintegerAPMatchingLn.PvoIDPinv ID
tcvph__qadc02charactervph_hist.vph__qadc02
tcvph_domaincharactervph_hist.vph_domainDomain


Internal usage


QadFinancials
method BCInvoiceAPMatching.ApiGetCInvoiceAPMatchingDetails