project QadFinancials > class BBillReport > business logic query GetDDocumentByPostingID


Parameters


iiCompanyIdintegerCompany id
icPosting_IDscharacter


query condition


  each Posting where
Posting.Company_Id = iiCompanyId AND
Posting.Posting_ID can-do icPosting_IDs

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

          each DDocumentPostingLine (inner-join) where
DDocumentPostingLine.PostingLine_ID = PostingLine.PostingLine_ID AND

              first DDocument (inner-join) where
DDocument.Company_Id = iiCompanyId AND
DDocument.DDocument_ID = DDocumentPostingLine.DDocument_ID AND


query resultset tqGetDDocumentByPostingID


field namedata typedb fielddescription
tiDDocument_IDintegerDDocument.DDocument_IDRecord ID
tiDDocumentPostingLine_IDintegerDDocumentPostingLine.DDocumentPostingLine_IDRecord ID
tcDDocumentReferencecharacterDDocument.DDocumentReferenceReference. Reference text for the payment.
tcDDocumentStatuscharacterDDocument.DDocumentStatusStatus. The payment status. The default value for a new record is Initial.
tcDDocumentTypecharacterDDocument.DDocumentTypePayment Instrument. The system displays the payment instrument associated with the payment format linked to the customer bank.
tiPosting_IDintegerPosting.Posting_IDRecord ID
tiPostingLine_IDintegerPostingLine.PostingLine_IDRecord ID


Internal usage


QadFinancials
method BBillReport.GetBillReportPayment