project QadFinancials > class BPosting > business logic query PostingByLayerTypeCode
Parameters
| iiCompanyId | integer | Company id |
| icLayerTypeCode | character | |
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
first Layer (inner-join) where
Layer.Layer_ID = Journal.Layer_ID AND
Layer.LayerTypeCode = icLayerTypeCode
query resultset tqPostingByLayerTypeCode
| field name | data type | db field | description |
|---|
| tcLayerTypeCode | character | Layer.LayerTypeCode | Layer Type |
| tiPosting_ID | integer | Posting.Posting_ID | Record ID |
| ti_sequence | integer | calculated | primary index |
| tc_rowid | character | calculated | = rowid(Posting),rowid(Journal),rowid(Layer) |
Internal usage
QadFinancials