project QadFinancials > class BPosting > 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


iiCompanyIdintegerCompany id
icPostingOriginatorReferencecharacterPostingOriginatorReference
ilPostingIsReplacementlogicalPostingIsReplacement
ilPostingIsReversinglogicalPostingIsReversing
icSkipRowidcharactericSkipRowid: 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 namedata typedb fielddescription
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).
tiPostingYearintegerPosting.PostingYearThe GL calendar year for the posting.
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.
tcPostingOriginatorReferencecharacterPosting.PostingOriginatorReferenceOriginal 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.
tlPostingIsReplacementlogicalPosting.PostingIsReplacementIndicate 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".
tlPostingIsReversinglogicalPosting.PostingIsReversingIndicate whether the posting is a reversal of an existing posting.
api annotation:Value for this field defaults to "false".
tiPostingYearPeriodintegerPosting.PostingYearPeriodThe 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_IDintegerPosting.Posting_IDRecord ID
tiCompany_IDintegerPosting.Company_IDLink to Company
tiJournal_IDintegerPosting.Journal_IDDaybook Code
tiPeriod_IDintegerPosting.Period_IDLink to Period
ti_sequenceintegercalculatedprimary index
tc_rowidcharactercalculated = rowid(Posting),rowid(Journal)


Internal usage


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