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