project QadFinancials > class BDDocument > business logic query DDocumentPostingLineForPostingDate


Parameters


iiCompanyIdintegerCompany id
iiDocument_IDinteger


query condition


  each DDocumentPostingLine where
DDocumentPostingLine.DDocument_ID = iiDocument_ID

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

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


query sort order


Posting.PostingDate (ascending)


query resultset tqDDocumentPostingLineForPostDat


field namedata typedb fielddescription
tiDDocument_IDintegerDDocumentPostingLine.DDocument_IDLink to DDocument
tiPosting_IDintegerPosting.Posting_IDRecord ID
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).
tiPostingLine_IDintegerPostingLine.PostingLine_IDRecord ID


Internal usage


QadFinancials
method BBankEntry.ValidateComponentPost
method BDDocument.ValidateComponentPost