business logic query PostingByUniqueKey

Description

PostingByUniqueKey: simple query just using the Company_ID, PostingYear, Journal_ID and PostingVoucher as input

Parameters

iiCompanyId	integer	Company id
iiPostingYear	integer
iiJournalID	integer
iiPostingVoucher	integer

query condition

each Posting where

Posting.Company_Id = iiCompanyId AND
Posting.PostingYear = iiPostingYear AND
Posting.Journal_ID = iiJournalID AND
Posting.PostingVoucher = iiPostingVoucher

query resultset tqPostingByUniqueKey

field name	data type	db field	description
tiPosting_ID	integer	Posting.Posting_ID	Record ID
tiCompany_ID	integer	Posting.Company_ID	Link to Company
tiJournal_ID	integer	Posting.Journal_ID	Daybook Code
tiPostingVoucher	integer	Posting.PostingVoucher	Voucher 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.
tiPostingYear	integer	Posting.PostingYear	The GL calendar year for the posting.

Internal usage

QadFinancials

method BPosting.GetPostingIDsForXLSIntegration