project QadFinancials > class BPosting > business logic query PostingByLayerID
Description
GetPostingForLayer
Parameters
| iiLayerId | integer | LayerId |
| iiCompanyId | integer | Company id |
query condition
each Posting where
Posting.Company_Id = iiCompanyId AND
first Journal (inner-join) where
Journal.SharedSet_Id = vi_JOURNAL_sharedset(iiCompanyId) AND
Journal.Journal_ID = Posting.Journal_ID AND
Journal.Layer_ID = iiLayerId
query resultset tqPostingByLayerID
| field name | data type | db field | description |
|---|
| tiLayer_ID | integer | Journal.Layer_ID | Link to Layer |
| tiPosting_ID | integer | Posting.Posting_ID | Record ID |
Internal usage
QadFinancials