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