project QadFinancials > class BPosting > business logic query PostingByCrossCyLayerType
Description
Get Posting by Posting ID and Cross Company Layer Type Code
Parameters
| iiCompanyId | integer | Company id |
| iiPostingId | integer | Posting ID |
| icCrossCyLayerTypeCode | character | Layer Type Code of Cross Company posting |
query condition
each Posting where
Posting.Company_Id = iiCompanyId AND
Posting.Posting_ID = iiPostingId
each PostingLine (inner-join) where
PostingLine.Company_Id = iiCompanyId AND
PostingLine.Posting_ID = Posting.Posting_ID AND
first Posting2 (inner-join) where
Posting2.Company_Id = iiCompanyId AND
Posting2.Posting_ID = PostingLine.CrossCompanyPosting_ID AND
first Journal (inner-join) where
Journal.SharedSet_Id = vi_JOURNAL_sharedset(iiCompanyId) AND
Journal.Journal_ID = Posting2.Journal_ID AND
first Layer (inner-join) where
Layer.Layer_ID = Journal.Layer_ID AND
Layer.LayerTypeCode = icCrossCyLayerTypeCode
query resultset tqPostingByCrossCyLayerType
| field name | data type | db field | description |
|---|
| tcLayerTypeCode | character | Layer.LayerTypeCode | Layer Type |
| tiPosting_ID | integer | Posting.Posting_ID | Record ID |
Internal usage
QadFinancials