project QadFinancials > class BPostingSafHist > business logic query PostingSafCombinedForPrjSaf
Parameters
| iiPostingSafCombinedID | integer | |
query condition
each PostingSafCombined where
PostingSafCombined.PostingSafCombined_ID = iiPostingSafCombinedID
first Saf3 (conditional-join) where
Saf3.Saf_ID = PostingSafCombined.Project3Saf_ID AND
first SafConcept3 (conditional-join) where
SafConcept3.SafConcept_ID = Saf3.SafConcept_ID AND
first Saf1 (conditional-join) where
Saf1.Saf_ID = PostingSafCombined.Project1Saf_ID AND
first SafConcept1 (conditional-join) where
SafConcept1.SafConcept_ID = Saf1.SafConcept_ID AND
first Saf2 (conditional-join) where
Saf2.Saf_ID = PostingSafCombined.Project2Saf_ID AND
first SafConcept2 (conditional-join) where
SafConcept2.SafConcept_ID = Saf2.SafConcept_ID AND
first Saf4 (conditional-join) where
Saf4.Saf_ID = PostingSafCombined.Project4Saf_ID AND
first SafConcept4 (conditional-join) where
SafConcept4.SafConcept_ID = Saf4.SafConcept_ID AND
first Saf5 (conditional-join) where
Saf5.Saf_ID = PostingSafCombined.Project5Saf_ID AND
first SafConcept5 (conditional-join) where
SafConcept5.SafConcept_ID = Saf5.SafConcept_ID AND
first SafStructure (conditional-join) where
SafStructure.SafStructure_ID = PostingSafCombined.ProjectSafStructure_ID AND
query resultset tqPostingSafCombinedForPrjSaf
| field name | data type | db field | description |
|---|
| tiCostCentre1Saf_ID | integer | PostingSafCombined.CostCentre1Saf_ID | Link to CostCentre-SAF1 |
| tiCostCentre2Saf_ID | integer | PostingSafCombined.CostCentre2Saf_ID | Link to CostCentre-SAF2 |
| tiCostCentre3Saf_ID | integer | PostingSafCombined.CostCentre3Saf_ID | Link to CostCentre-SAF3 |
| tiCostCentre4Saf_ID | integer | PostingSafCombined.CostCentre4Saf_ID | Link to CostCentre-SAF4 |
| tiCostCentre5Saf_ID | integer | PostingSafCombined.CostCentre5Saf_ID | Link to CostCentre-SAF5 |
| tiPostingSafCombined_ID | integer | PostingSafCombined.PostingSafCombined_ID | Record ID |
| tcPrjSafConceptCode1 | character | SafConcept1.SafConceptCode | SAF Concept Code |
| tcPrjSafConceptCode2 | character | SafConcept2.SafConceptCode | SAF Concept Code |
| tcPrjSafConceptCode3 | character | SafConcept3.SafConceptCode | SAF Concept Code |
| tcPrjSafConceptCode4 | character | SafConcept4.SafConceptCode | SAF Concept Code |
| tcPrjSafConceptCode5 | character | SafConcept5.SafConceptCode | SAF Concept Code |
| tcProjectSafCode1 | character | Saf1.SafCode | SAF Code |
| tcProjectSafCode2 | character | Saf2.SafCode | SAF Code |
| tcProjectSafCode3 | character | Saf3.SafCode | SAF Code |
| tcProjectSafCode4 | character | Saf4.SafCode | SAF Code |
| tcProjectSafCode5 | character | Saf5.SafCode | SAF Code |
| tcProjectSafStructureCode | character | SafStructure.SafStructureCode | Structure Code |
Internal usage
QadFinancials