project QadFinancials > class BDDocument > business logic query DDocumentPostingLineForPostingDate
Parameters
iiCompanyId | integer | Company id |
iiDocument_ID | integer | |
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 name | data type | db field | description |
tiDDocument_ID | integer | DDocumentPostingLine.DDocument_ID | Link to DDocument |
tiPosting_ID | integer | Posting.Posting_ID | Record ID |
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). |
tiPostingLine_ID | integer | PostingLine.PostingLine_ID | Record ID |
Internal usage
QadFinancials