business logic query PostingByReverseOriginatorRef

Description

PostingByReverseOriginatorRef: query that has a parameter on field PostingOriginatorReference (field that is filled with the reference-information Year/Journal/Voucher(9)) in case of reverse- or replace-activity and other paramaters for reversing and replacement.

Parameters

iiCompanyId	integer	Company id
icPostingOriginatorReference	character	PostingOriginatorReference
ilPostingIsReplacement	logical	PostingIsReplacement
ilPostingIsReversing	logical	PostingIsReversing
icSkipRowid	character	icSkipRowid: rowid of the posting to be excluded from the result-set (converted to character)

query condition

each Posting where

Posting.Company_Id = iiCompanyId AND
Posting.PostingOriginatorReference = icPostingOriginatorReference AND
Posting.PostingIsReversing = ilPostingIsReversing AND
Posting.PostingIsReplacement = ilPostingIsReplacement AND
rowid(Posting) <> to-rowid(icSkipRowid)

first Journal (inner-join) where

Journal.SharedSet_Id = vi_JOURNAL_sharedset(iiCompanyId) AND
Journal.Journal_ID = Posting.Journal_ID AND

query resultset tqPostingByReverseOriginatorRef

field name	data type	db field	description
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).
tiPostingYear	integer	Posting.PostingYear	The GL calendar year for the posting.
tcJournalCode	character	Journal.JournalCode	A daybook code (maximum eight characters).
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.
tcPostingOriginatorReference	character	Posting.PostingOriginatorReference	Original Posting Reference. this field must contain the key values of the refered posting, if this posting is a manual reversal or replacement of an existing posting.
	api annotation:		Value for this field defaults to blank.
tlPostingIsReplacement	logical	Posting.PostingIsReplacement	Indicate whether the posting is a replacement of an existing posting.
	api annotation:		Value for this field defaults to "false". For reversal postings, either automatic or manual - this value defaults to "true".
tlPostingIsReversing	logical	Posting.PostingIsReversing	Indicate whether the posting is a reversal of an existing posting.
	api annotation:		Value for this field defaults to "false".
tiPostingYearPeriod	integer	Posting.PostingYearPeriod	The GL calendar year/period for the posting. This field is determined by "PostingPeriod" and "PostingYear".
	api annotation:		If Partial Update is true, the value defaults using PostingPeriod and PostingYear.
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
tiPeriod_ID	integer	Posting.Period_ID	Link to Period
ti_sequence	integer	calculated	primary index
tc_rowid	character	calculated	= rowid(Posting),rowid(Journal)

Internal usage

QadFinancials

method BAPMatching.ApiGetMatchingInfoMulti
method BPosting.ApiMassReversePeriodicCostingPostings
method BPosting.MassReversePeriodicCostingPostings
method BPosting.PostSave
method BPosting.ValidateComponentPreAssignPosting1