project QadFinancials > class BPosting > business logic query PostingLineByLayerTypeGLDivCCPrj
Parameters
| iiCompanyId | integer | Company id |
| icLayerTypes | character | |
| iiGLId | integer | |
| iiDivisionId | integer | |
| iiCostCentreId | integer | |
| iiProjectId | integer | ID 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 name | data type | db field | description |
|---|
| tiCostCentre_ID | integer | PostingLine.CostCentre_ID | Cost Center Code |
| tiDivision_ID | integer | PostingLine.Division_ID | Sub-Account Code |
| tiGL_ID | integer | PostingLine.GL_ID | GL Description |
| tcLayerTypeCode | character | Layer.LayerTypeCode | Layer Type |
| tiProject_ID | integer | PostingLine.Project_ID | Description |
Internal usage
QadFinancials