project QadFinancials > class BAPMatchingReport > business logic query PendingVoucherForUnmatched
Description
.
Parameters
| icFromPurchaseOrder | character | |
| icToPurchaseOrder | character | |
| icFromCreditorCode | character | |
| icToCreditorCode | character | |
| icFromItem | character | |
| icToItem | character | |
| itFromReceiptDate | date | |
| itToReceiptDate | date | |
| icSiteCode | character | |
| icDomainCode | character | |
query condition
each pvo_mstr where
pvo_mstr.pvo_last_voucher = '' AND
pvo_mstr.pvo_order >= icFromPurchaseOrder AND
pvo_mstr.pvo_order <= icToPurchaseOrder AND
pvo_mstr.pvo_supplier >= icFromCreditorCode AND
pvo_mstr.pvo_supplier <= icToCreditorCode AND
pvo_mstr.pvo_domain = icDomainCode
first po_mstr (inner-join) where
po_mstr.po_domain = pvo_mstr.pvo_domain AND
po_mstr.po_nbr = pvo_mstr.pvo_order AND
each pvod_det (inner-join) where
pvod_det.pvod_domain = pvo_mstr.pvo_domain AND
pvod_det.pvod_id = pvo_mstr.pvo_id AND
pvod_det.pvod_last_voucher = '' AND
pvod_det.pvod_part >= icFromItem AND
pvod_det.pvod_part <= icToItem AND
pvod_det.pvod_eff_date >= itFromReceiptDate AND
pvod_det.pvod_eff_date <= itToReceiptDate AND
pvod_det.pvod_shipto can-do icSiteCode
first prh_hist (outer-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 pt_mstr (inner-join) where
pt_mstr.pt_domain = pvod_det.pvod_domain AND
pt_mstr.pt_part = pvod_det.pvod_part AND
each tx2d_det (conditional-join) where
tx2d_det.tx2d_domain = pvod_det.pvod_domain AND
((tx2d_det.tx2d_line = pvod_det.pvod_order_line AND
'01' = pvod_det.pvod_order_type) OR
(0 = pvod_det.pvod_order_line AND
pvod_det1.pvod_id_line = tx2d_det1.tx2d_line AND
'02' = pvod_det.pvod_order_type) OR
(tx2d_det.tx2d_line = 0 AND
'01' = pvod_det.pvod_order_type)) AND
tx2d_det.tx2d_ref = (if pvod_det.pvod_accrued_amt = 0 then pvod_det.pvod_internal_ref else string(pvod_det.pvod_id) ) AND
(tx2d_det.tx2d_tr_type = '21' OR
tx2d_det.tx2d_tr_type = '27' OR
tx2d_det.tx2d_tr_type = '43' OR
tx2d_det.tx2d_tr_type = '45' )
first vd_mstr (conditional-join) where
vd_mstr.vd_addr = pvo_mstr.pvo_supplier AND
vd_mstr.vd_domain = pvo_mstr.pvo_domain AND
query resultset tqPendingVoucherForUnmatched
| field name | data type | db field | description |
|---|
| tcpo_buyer | character | po_mstr.po_buyer | Buyer |
| tcpo_nbr | character | po_mstr.po_nbr | Purchase Order |
| ttpo_ord_date | date | po_mstr.po_ord_date | Order Date |
| tcpo_rmks | character | po_mstr.po_rmks | Remarks |
| tcprh_curr | character | prh_hist.prh_curr | Currency |
| tcprh_domain | character | prh_hist.prh_domain | Domain |
| tiprh_line | integer | prh_hist.prh_line | PO Line |
| tcprh_nbr | character | prh_hist.prh_nbr | Order |
| tcprh_receiver | character | prh_hist.prh_receiver | Receiver |
| tcprh_shipto | character | prh_hist.prh_shipto | Ship-to |
| tcprh_site | character | prh_hist.prh_site | Site |
| tcprh_type | character | prh_hist.prh_type | Purchase Type |
| tcprh_um | character | prh_hist.prh_um | UM |
| tdprh_um_conv | decimal | prh_hist.prh_um_conv | UM Conversion |
| tcprh_vend | character | prh_hist.prh_vend | Supplier |
| tcpt_prod_line | character | pt_mstr.pt_prod_line | Prod Line |
| tcpt_site | character | pt_mstr.pt_site | Site |
| ttpvo_eff_date | date | pvo_mstr.pvo_eff_date | GL Effective Date |
| tcpvo_lc_charge | character | pvo_mstr.pvo_lc_charge | Logistics Charge Code |
| tcpvo_supplier | character | pvo_mstr.pvo_supplier | Supplier |
| ttpvo_trans_date | date | pvo_mstr.pvo_trans_date | Transaction Date |
| 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 |
| tipvod_id | integer | pvod_det.pvod_id | Pending Voucher ID |
| tipvod_id_line | integer | pvod_det.pvod_id_line | Line |
| tcpvod_part | character | pvod_det.pvod_part | Item Number |
| tcpvod_project | character | pvod_det.pvod_project | Project |
| tdpvod_pur_cost | decimal | pvod_det.pvod_pur_cost | PO Cost |
| tdpvod_trans_qty | decimal | pvod_det.pvod_trans_qty | Transaction Qty |
| tdpvod_vouchered_amt | decimal | pvod_det.pvod_vouchered_amt | Vouchered Amount |
| tdpvod_vouchered_qty | decimal | pvod_det.pvod_vouchered_qty | Vouchered Qty |
| tdtx2d_cur_tax_amt | decimal | tx2d_det.tx2d_cur_tax_amt | Tax |
| tcvd_type | character | vd_mstr.vd_type | Type |
Internal usage
QadFinancials