project QadFinancials > class BPosting > business logic query PostingByJournalCode

Description

This query returns original posting record on the basis of Journal Code, PeriodYear and Voucher.


Parameters


iiCompanyIdintegerCompany id
icJournalCodecharacter
iiPeriodYearinteger
iiPostingVoucherinteger


query condition


  each Posting where
Posting.Company_Id = iiCompanyId AND
Posting.PostingVoucher = iiPostingVoucher AND
Posting.PostingYear = iiPeriodYear

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

      first Period (inner-join) where
Period.Company_Id = iiCompanyId AND
Period.Period_ID = Posting.Period_ID AND
Period.PeriodYear = iiPeriodYear


query resultset tqPostingByJournalCode


field namedata typedb fielddescription
tiPeriodPeriodintegerPeriod.PeriodPeriodGL Period
tiPostingPeriodintegerPosting.PostingPeriodThe GL period for the posting. The period must be open.
tiPostingYearintegerPosting.PostingYearThe GL calendar year for the posting.
tiPosting_IDintegerPosting.Posting_IDRecord ID
tiCompany_IDintegerPosting.Company_IDLink to Company
tiJournal_IDintegerPosting.Journal_IDDaybook Code
tcJournalCodecharacterJournal.JournalCodeA daybook code (maximum eight characters).
tiPeriod_IDintegerPosting.Period_IDLink to Period
tiPeriodYearintegerPeriod.PeriodYearGL Calendar Year
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.
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).


Internal usage


QadFinancials
method BPosting.ApiStdMaintainTT
method BPosting.ValidateComponentPreAssignPosting1