project QadFinancials > class BSafStructure > business logic query SafStructureByDefault
Description
SafStructureByDefault
Parameters
| icSafStructureCode | character | SafStructureCode |
query condition
each SafStructure where
SafStructure.SafStructureCode = icSafStructureCode
each SafStructureLine (inner-join) where
SafStructureLine.SafStructure_ID = SafStructure.SafStructure_ID AND
first Saf (conditional-join) where
Saf.Saf_ID = SafStructureLine.Saf_ID AND
first SafConcept (inner-join) where
SafConcept.SafConcept_ID = SafStructureLine.SafConcept_ID AND
query resultset tqSafStructureByDefault
| field name | data type | db field | description |
|---|
| tiSaf_ID | integer | SafStructureLine.Saf_ID | Link to Saf |
| tcSafCode | character | Saf.SafCode | SAF Code |
| tiSafConcept_ID | integer | SafStructureLine.SafConcept_ID | Link to SafConcept |
| tcSafConceptCode | character | SafConcept.SafConceptCode | SAF Concept Code |
| tiSafStructure_ID | integer | SafStructure.SafStructure_ID | Record ID |
| tcSafStructureCode | character | SafStructure.SafStructureCode | Structure Code |
Internal usage
QadFinancials