project QadFinancials > class BSafStructure > business logic query SafStructureLineByStructConc
Description
SafStructureLineByStructConc
Parameters
| icSafConceptCode | character | SAF Concept Code |
| iiSafStructureID | integer | |
query condition
each SafStructureLine where
SafStructureLine.SafStructure_ID = iiSafStructureID
first SafConcept (inner-join) where
SafConcept.SafConcept_ID = SafStructureLine.SafConcept_ID AND
SafConcept.SafConceptCode = icSafConceptCode
query resultset tqSafStructureLineByStructConc
| field name | data type | db field | description |
|---|
| tcSafConceptCode | character | SafConcept.SafConceptCode | SAF Concept Code |
| tiSafStructure_ID | integer | SafStructureLine.SafStructure_ID | Link to SafStructure |
| tiSafStructureLineNumber | integer | SafStructureLine.SafStructureLineNumber | Line Number |
Internal usage
QadFinancials