project QadFinancials > class BAPMatching > business logic query APMatchingByCInvoiceWithLines


Parameters


iiCompanyIdintegerCompany id
iiCInvoiceIDinteger
icAPMatchingStatuscharacter


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 namedata typedb fielddescription
tiAPMatching_IDintegerAPMatching.APMatching_IDRecord ID
tiAPMatchingLn_IDintegerAPMatchingLn.APMatchingLn_IDRecord ID
tcAPMatchingLnPvodIntRefcharacterAPMatchingLn.APMatchingLnPvodIntRefInternal Ref
tcAPMatchingLnPvodOrdercharacterAPMatchingLn.APMatchingLnPvodOrderOrder
tcAPMatchingStatuscharacterAPMatching.APMatchingStatusStatus
tiCInvoice_IDintegerAPMatching.CInvoice_IDVoucher
tiCompany_IDintegerAPMatching.Company_IDLink to Company


Internal usage


QadFinancials
method BCInvoiceAPMatching.ApiGetCInvoiceAPMatchingDetails