project QadFinancials > class BPosting > business logic query PostingLineByLayerTypeGLDivCCPrj


Parameters


iiCompanyIdintegerCompany id
icLayerTypescharacter
iiGLIdinteger
iiDivisionIdinteger
iiCostCentreIdinteger
iiProjectIdintegerID of project, for which posting is searched


query condition


  each PostingLine where
PostingLine.Company_Id = iiCompanyId AND
PostingLine.CostCentre_ID = iiCostCentreId AND
PostingLine.Division_ID = iiDivisionId AND
PostingLine.GL_ID = iiGLId AND
PostingLine.Project_ID = iiProjectId

      first Posting (inner-join) where
Posting.Company_Id = iiCompanyId AND
Posting.Posting_ID = PostingLine.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 tqPostingLineByLayerTypeGLDivCCP


field namedata typedb fielddescription
tiCostCentre_IDintegerPostingLine.CostCentre_IDCost Center Code
tiDivision_IDintegerPostingLine.Division_IDSub-Account Code
tiGL_IDintegerPostingLine.GL_IDGL Description
tcLayerTypeCodecharacterLayer.LayerTypeCodeLayer Type
tiProject_IDintegerPostingLine.Project_IDDescription


Internal usage


QadFinancials
method BCostCentre.ValidateComponent
method BDivision.ValidateComponent
method BGL.ValDisabledFields
method BProject.ValidateComponent