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