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