project QadFinancials > class BAPMatching > business logic query APMatchingByCInvoiceWithLines
Parameters
| iiCompanyId | integer | Company id |
| iiCInvoiceID | integer | |
| icAPMatchingStatus | character | |
query condition
each APMatching where
APMatching.Company_Id = iiCompanyId AND
APMatching.CInvoice_ID = iiCInvoiceID AND
APMatching.APMatchingStatus = icAPMatchingStatus
each APMatchingLn (inner-join) where
APMatchingLn.APMatching_ID = APMatching.APMatching_ID AND
query resultset tqAPMatchingByCInvoiceWithLines
| field name | data type | db field | description |
|---|
| tiAPMatching_ID | integer | APMatching.APMatching_ID | Record ID |
| tiAPMatchingLn_ID | integer | APMatchingLn.APMatchingLn_ID | Record ID |
| tcAPMatchingLnPvodIntRef | character | APMatchingLn.APMatchingLnPvodIntRef | Internal Ref |
| tcAPMatchingLnPvodOrder | character | APMatchingLn.APMatchingLnPvodOrder | Order |
| tcAPMatchingStatus | character | APMatching.APMatchingStatus | Status |
| tiCInvoice_ID | integer | APMatching.CInvoice_ID | Voucher |
| tiCompany_ID | integer | APMatching.Company_ID | Link to Company |
Internal usage
QadFinancials