project QadFinancials > class BPosting > business logic query PostingByCrossCyLayerType

Description

Get Posting by Posting ID and Cross Company Layer Type Code


Parameters


iiCompanyIdintegerCompany id
iiPostingIdintegerPosting ID
icCrossCyLayerTypeCodecharacterLayer 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 namedata typedb fielddescription
tcLayerTypeCodecharacterLayer.LayerTypeCodeLayer Type
tiPosting_IDintegerPosting.Posting_IDRecord ID


Internal usage


QadFinancials
method BMassLayerTransfer.ApiExecuteLayerTransferV01