project QadFinancials > class BPosting > business logic query PostingByPeriodPeriodMark

Description

PostingByPeriodPeriodMark; Get postings based on the Period and the PeriodMark


Parameters


iiCompanyIdintegerCompany id
iiPeriodIDintegerPeriodID
iiPeriodMarkIDintegerPeriodMarkID


query condition


  each Posting where
Posting.Company_Id = iiCompanyId AND
Posting.Period_ID = iiPeriodID AND
Posting.PeriodMark_ID = iiPeriodMarkID


query sort order


Posting.Company_ID (ascending)
Posting.Period_ID (ascending)
Posting.Posting_ID (ascending)


query resultset tqPostingByPeriodPeriodMark


field namedata typedb fielddescription
tiPeriodMark_IDintegerPosting.PeriodMark_IDLink to PeriodMark
tiCompany_IDintegerPosting.Company_IDLink to Company
tiPosting_IDintegerPosting.Posting_IDRecord ID
tiPeriod_IDintegerPosting.Period_IDLink to Period
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).
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.


Internal usage


QadFinancials
method BPeriod.ValidateComponentPost
method BPeriodMark.GetPeriodMarkIsReferenced