project QadFinancials > class BPosting > business logic query PostingSafForValSafTrans
Description
This query is used for validation, whether Saf code of Saf Structure is used in posting in any required layer
Parameters
| iiCompanyId | integer | Company id |
| icLayerTypes | character | Types of layers |
| iiSafStructure_ID | integer | ID of Saf Structure |
| iiSaf_ID | integer | ID of SAF |
query condition
each PostingSaf where
PostingSaf.Saf_ID = iiSaf_ID AND
PostingSaf.SafStructure_ID = iiSafStructure_ID
first Posting (inner-join) where
Posting.Company_Id = iiCompanyId AND
Posting.Posting_ID = PostingSaf.Posting_ID 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 can-do icLayerTypes
query resultset tqPostingSafForValSafTrans
| field name | data type | db field | description |
|---|
| tcLayerTypeCode | character | Layer.LayerTypeCode | Layer Type |
| tiSaf_ID | integer | PostingSaf.Saf_ID | SAF Code |
| tiSafStructure_ID | integer | PostingSaf.SafStructure_ID | Structure Code |
Internal usage
QadFinancials