project QadFinancials > class BDDocument > business logic query GetPostingInfoByDocumentID


Parameters


iiCompanyIdintegerCompany id
iiDDocumentIDinteger


query condition


  each DDocument where
DDocument.Company_Id = iiCompanyId AND
DDocument.DDocument_ID = iiDDocumentID

      each DDocumentPostingLine (inner-join) where
DDocumentPostingLine.DDocument_ID = DDocument.DDocument_ID AND

          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

                  first Journal (inner-join) where
Journal.SharedSet_Id = vi_JOURNAL_sharedset(iiCompanyId) AND
Journal.Journal_ID = Posting.Journal_ID AND


query resultset tqGetPostingInfoByDocumentID


field namedata typedb fielddescription
tcJournalCodecharacterJournal.JournalCodeA daybook code (maximum eight characters).
tiPostingVoucherintegerPosting.PostingVoucherVoucher is a sequential number that uniquely identifies the journal entry (within the combination of an entity and a daybook code).
api annotation:In create mode,enter 0 in this field - the voucher number is generated by the system. In Modify/Delete, the correct voucher number must be entered because this identifies the record.
tiPostingYearintegerPosting.PostingYearThe GL calendar year for the posting.


Internal usage


QadFinancials
method BDDocument.ValidateComponentDDocumentStatus
method BDInvoice.UpdateDeductionForBouncedDDoc