project QadFinancials > class BMfgPLInvoice > business logic query PLInvoiceDetailForMatching

Description

PLInvoiceDetailForMatching: query that returns the pending vouchers based on purchase order shipper


Parameters


icDomainCodecharacter
iiPvoIDinteger
icPOShipperInvoicecharacter


query condition


  each pli_mstr where
pli_mstr.pli_domain = icDomainCode AND
pli_mstr.pli_invoice = icPOShipperInvoice

      each plid_det (inner-join) where
plid_det.plid_domain = pli_mstr.pli_domain AND
plid_det.plid_pli_keyid = pli_mstr.pli_keyid AND
plid_det.plid_pvo_id = (if iiPvoID = -999999 then 0 else iiPvoID)


query resultset tqPLInvoiceDetailForMatching


field namedata typedb fielddescription
tcpli_domaincharacterpli_mstr.pli_domainDomain
tcpli_invoicecharacterpli_mstr.pli_invoiceInvoice Number
tdpli_invoice_amtdecimalpli_mstr.pli_invoice_amtInvoice Amount
ttpli_invoice_datedatepli_mstr.pli_invoice_dateInvoice Date
tipli_keyidintegerpli_mstr.pli_keyidKey ID
tcpli_suppliercharacterpli_mstr.pli_supplierSupplier
tiplid_lineintegerplid_det.plid_lineLine
tiplid_pvo_idintegerplid_det.plid_pvo_idPending Voucher ID
ti_sequenceintegercalculatedprimary index
tc_rowidcharactercalculated = rowid(pli_mstr),rowid(plid_det)


Internal usage


QadFinancials
method BAPMatching.GetPendingVouchersPOShipper
method BAPMatching.ValidateComponentPreAPMLn1