project QadFinancials > class BMfgPLInvoice > business logic query PLInvoiceDetailForMatching
Description
PLInvoiceDetailForMatching: query that returns the pending vouchers based on purchase order shipper
Parameters
| icDomainCode | character | |
| iiPvoID | integer | |
| icPOShipperInvoice | character | |
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 name | data type | db field | description |
|---|
| tcpli_domain | character | pli_mstr.pli_domain | Domain |
| tcpli_invoice | character | pli_mstr.pli_invoice | Invoice Number |
| tdpli_invoice_amt | decimal | pli_mstr.pli_invoice_amt | Invoice Amount |
| ttpli_invoice_date | date | pli_mstr.pli_invoice_date | Invoice Date |
| tipli_keyid | integer | pli_mstr.pli_keyid | Key ID |
| tcpli_supplier | character | pli_mstr.pli_supplier | Supplier |
| tiplid_line | integer | plid_det.plid_line | Line |
| tiplid_pvo_id | integer | plid_det.plid_pvo_id | Pending Voucher ID |
| ti_sequence | integer | calculated | primary index |
| tc_rowid | character | calculated | = rowid(pli_mstr),rowid(plid_det) |
Internal usage
QadFinancials