project QadFinancials > class BAPMatching > business logic query APMatchingLnForPostingJournal
Description
This query returns the posting and journal information for a given AP Matching line.
Parameters
| iiCompanyId | integer | Company id |
| iiApMatchingLnID | integer | The ID for the AP Matching Line. |
query condition
each APMatchingLn where
APMatchingLn.APMatchingLn_ID = iiApMatchingLnID
first APMatching (inner-join) where
APMatching.Company_Id = iiCompanyId AND
APMatching.APMatching_ID = APMatchingLn.APMatching_ID AND
first Posting (inner-join) where
Posting.Company_Id = iiCompanyId AND
Posting.Posting_ID = APMatching.Posting_ID AND
first Journal (inner-join) where
Journal.SharedSet_Id = vi_JOURNAL_sharedset(iiCompanyId) AND
Journal.Journal_ID = Posting.Journal_ID AND
query resultset tqAPMatchingLnForPostingJournal
| field name | data type | db field | description |
|---|
| tiAPMatching_ID | integer | APMatchingLn.APMatching_ID | Link to APMatching |
| tiAPMatchingLn_ID | integer | APMatchingLn.APMatchingLn_ID | Record ID |
| tiJournal_ID | integer | Posting.Journal_ID | Daybook Code |
| tcJournalCode | character | Journal.JournalCode | A daybook code (maximum eight characters). |
| tiPosting_ID | integer | Posting.Posting_ID | Record ID |
| 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