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