project QadFinancials > class BCPay > business logic query CPayByCInvoice
Parameters
| iiCInvoiceId | integer | |
| iiCompanyId | integer | Company 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 name | data type | db field | description |
|---|
| tiCInvoice_ID | integer | CPay.CInvoice_ID | Link to CInvoice |
| ttPostingDate | date | Posting.PostingDate | The 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). |
| tdPostingLineCreditTC | decimal | PostingLine.PostingLineCreditTC | TC Credit |
| tdPostingLineDebitTC | decimal | PostingLine.PostingLineDebitTC | TC Debit |
Internal usage
QadFinancials