project QadFinancials > class BAPMatchingReport > business logic query PendingVoucherByAPMatchingLn


Parameters


icPvoDomaincharacter
iiPvoIdinteger
iiPvoLineIdinteger
itFromPODatedate
itToPODatedate
icBuyercharacter
icFromInternalRefcharacter
icToInternalRefcharacter


query condition


  each pvod_det where
pvod_det.pvod_domain = icPvoDomain AND
pvod_det.pvod_id = iiPvoId AND
pvod_det.pvod_id_line = iiPvoLineId

      first pod_det (inner-join) where
pod_det.pod_domain = pvod_det.pvod_domain AND
pod_det.pod_line = pvod_det.pvod_order_line AND
pod_det.pod_nbr = pvod_det.pvod_order AND

      first prh_hist (conditional-join) where
prh_hist.prh_domain = pvod_det.pvod_domain AND
prh_hist.prh_receiver = pvod_det.pvod_internal_ref AND
prh_hist.prh_nbr = pvod_det.pvod_order AND
prh_hist.prh_line = pvod_det.pvod_order_line AND

      first pvo_mstr (inner-join) where
pvo_mstr.pvo_domain = pvod_det.pvod_domain AND
pvo_mstr.pvo_id = pvod_det.pvod_id AND
pvo_mstr.pvo_buyer can-do icBuyer AND
pvo_mstr.pvo_internal_ref >= icFromInternalRef AND
pvo_mstr.pvo_internal_ref <= icToInternalRef

          first po_mstr (inner-join) where
po_mstr.po_domain = pvo_mstr.pvo_domain AND
po_mstr.po_nbr = pvo_mstr.pvo_order AND
po_mstr.po_ord_date >= itFromPODate AND
po_mstr.po_ord_date <= itToPODate


query resultset tqPendingVoucherByAPMatchingLn


field namedata typedb fielddescription
tipod_opintegerpod_det.pod_opOperation
tcpod_wo_lotcharacterpod_det.pod_wo_lotWork Order ID
tcprh_umcharacterprh_hist.prh_umUM
tdprh_um_convdecimalprh_hist.prh_um_convUM Conversion
tcpvo_buyercharacterpvo_mstr.pvo_buyerBuyer
tcpvo_internal_refcharacterpvo_mstr.pvo_internal_refInternal Reference
tcpvo_suppliercharacterpvo_mstr.pvo_supplierSupplier
tdpvod_accrued_amtdecimalpvod_det.pvod_accrued_amtAccrued Amount
tdpvod_ex_ratedecimalpvod_det.pvod_ex_rateExch Rate
tdpvod_ex_rate2decimalpvod_det.pvod_ex_rate2Exch Rate 2
tdpvod_mtl_stddecimalpvod_det.pvod_mtl_stdItem Material Cost
tdpvod_ovh_stddecimalpvod_det.pvod_ovh_stdItem Overhead Cost
tdpvod_pur_costdecimalpvod_det.pvod_pur_costPO Cost
tdpvod_pur_stddecimalpvod_det.pvod_pur_stdItem PO Cost
tdpvod_sub_stddecimalpvod_det.pvod_sub_stdItem Subcontract Cost


Internal usage


QadFinancials
method BAPMatchingReport.MatchingVariance