project QadFinancials > class BDInvoice > business logic query GetPostingTextByDInvoiceID
Parameters
| iiCompanyId | integer | Company id |
| iiDInvoiceID | integer | |
query condition
each DInvoice where
DInvoice.Company_Id = iiCompanyId AND
DInvoice.DInvoice_ID = iiDInvoiceID
each DInvoicePosting (inner-join) where
DInvoicePosting.DInvoice_ID = DInvoice.DInvoice_ID AND
first Posting (inner-join) where
Posting.Company_Id = iiCompanyId AND
Posting.Posting_ID = DInvoicePosting.Posting_ID AND
query resultset tqGetPostingTextByDInvoiceID
| field name | data type | db field | description |
|---|
| tcPostingText | character | Posting.PostingText | Free text describing the posting. |
| api annotation: | | Value for this field defaults to blank |
Internal usage
QadFinancials