business logic query APMatchingByCInvoiceIDRowidID

Description

APMatchingByCInvoiceIDRowidID: simple query that tries to find APMathcing-records based on the CInvoice_ID and that returns the posting-key (in case the APMathcing was finished)

Parameters

iiCompanyId	integer	Company id
iiCInvoiceID	integer	CInvoiceID
icSkipAPMatchingRowid	character	This parameter can contain the rowid (converted to string) of an APMatching-record that shoudl NOT be in the result-set.

query condition

each APMatching where

APMatching.Company_Id = iiCompanyId AND
APMatching.CInvoice_ID = iiCInvoiceID AND
rowid(APMatching) <> to-rowid(icSkipAPMatchingRowid)

first Journal (outer-join) where

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

first Posting (outer-join) where

Posting.Company_Id = iiCompanyId AND
Posting.Posting_ID = APMatching.Posting_ID AND

query resultset tqAPMatchingByCInvoiceIDRowidID

field name	data type	db field	description
tiAPMatching_ID	integer	APMatching.APMatching_ID	Record ID
ttAPMatchingDate	date	APMatching.APMatchingDate	Date
tcAPMatchingStatus	character	APMatching.APMatchingStatus	Status
tiCInvoice_ID	integer	APMatching.CInvoice_ID	Voucher
tiCompany_ID	integer	APMatching.Company_ID	Link to Company
tiJournal_ID	integer	APMatching.Journal_ID	Daybook
tcJournalCode	character	Journal.JournalCode	A daybook code (maximum eight characters).
tiPosting_ID	integer	APMatching.Posting_ID	Voucher
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 BAPMatching.ValidateComponentPost
method BAPMatching.ValidateComponentPostAPM2