project QadFinancials > class BPosting > business logic query PostingByIdAndLayerType
Description
Posting By Posting ID and Layer Type Code
Parameters
| iiCompanyId | integer | Company id |
| iiPostingId | integer | |
| icLayerTypeCode | character | |
query condition
each Posting where
Posting.Company_Id = iiCompanyId AND
Posting.Posting_ID = iiPostingId
first Journal (inner-join) where
Journal.SharedSet_Id = vi_JOURNAL_sharedset(iiCompanyId) AND
Journal.Journal_ID = Posting.Journal_ID AND
first Layer (inner-join) where
Layer.Layer_ID = Journal.Layer_ID AND
Layer.LayerTypeCode = icLayerTypeCode
query resultset tqPostingByIdAndLayerType
| field name | data type | db field | description |
|---|
| tcLayerTypeCode | character | Layer.LayerTypeCode | Layer Type |
| tiPosting_ID | integer | Posting.Posting_ID | Record ID |
Internal usage
QadFinancials