project QadFinancials > class BCPay > business logic query CPayByCInvoice


Parameters


iiCInvoiceIdinteger
iiCompanyIdintegerCompany id


query condition


  each CPay where
CPay.CInvoice_ID = iiCInvoiceId

      first PostingLine (inner-join) where
PostingLine.Company_Id = iiCompanyId AND
PostingLine.PostingLine_ID = CPay.PostingLine_ID AND

          first Posting (inner-join) where
Posting.Company_Id = iiCompanyId AND
Posting.Posting_ID = PostingLine.Posting_ID AND


query resultset tqCPayByCInvoice


field namedata typedb fielddescription
tiCInvoice_IDintegerCPay.CInvoice_IDLink to CInvoice
ttPostingDatedatePosting.PostingDateThe accounting date on which the journal entry is posted. The posting date must be a valid calendar date and must be within the GL calendar year (PostingYear) and period (PostingPeriod).
tdPostingLineCreditTCdecimalPostingLine.PostingLineCreditTCTC Credit
tdPostingLineDebitTCdecimalPostingLine.PostingLineDebitTCTC Debit


Internal usage


QadFinancials
method BCInvoiceAPMatching.ApiGetCInvoiceAPMatchingDetails