project QadFinancials > class BAPMatchingReport > business logic query PendingVoucherByAPMatchingLn
Parameters
icPvoDomain | character | |
iiPvoId | integer | |
iiPvoLineId | integer | |
itFromPODate | date | |
itToPODate | date | |
icBuyer | character | |
icFromInternalRef | character | |
icToInternalRef | character | |
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 name | data type | db field | description |
tipod_op | integer | pod_det.pod_op | Operation |
tcpod_wo_lot | character | pod_det.pod_wo_lot | Work Order ID |
tcprh_um | character | prh_hist.prh_um | UM |
tdprh_um_conv | decimal | prh_hist.prh_um_conv | UM Conversion |
tcpvo_buyer | character | pvo_mstr.pvo_buyer | Buyer |
tcpvo_internal_ref | character | pvo_mstr.pvo_internal_ref | Internal Reference |
tcpvo_supplier | character | pvo_mstr.pvo_supplier | Supplier |
tdpvod_accrued_amt | decimal | pvod_det.pvod_accrued_amt | Accrued Amount |
tdpvod_ex_rate | decimal | pvod_det.pvod_ex_rate | Exch Rate |
tdpvod_ex_rate2 | decimal | pvod_det.pvod_ex_rate2 | Exch Rate 2 |
tdpvod_mtl_std | decimal | pvod_det.pvod_mtl_std | Item Material Cost |
tdpvod_ovh_std | decimal | pvod_det.pvod_ovh_std | Item Overhead Cost |
tdpvod_pur_cost | decimal | pvod_det.pvod_pur_cost | PO Cost |
tdpvod_pur_std | decimal | pvod_det.pvod_pur_std | Item PO Cost |
tdpvod_sub_std | decimal | pvod_det.pvod_sub_std | Item Subcontract Cost |
Internal usage
QadFinancials