business logic query SafConceptCodeByLine

Description

GetSafConceptCodeByLine

each SafStructureLine where

SafStructureLine.SafStructure_ID = iiSafStructure_ID AND
SafStructureLine.SafStructureLineNumber = iiSafStructureLineNumber

first SafConcept (inner-join) where

SafConcept.SafConcept_ID = SafStructureLine.SafConcept_ID AND

first SafStructure (inner-join) where

SafStructure.SafStructure_ID = SafStructureLine.SafStructure_ID AND
SafStructure.SafStructureCode = icSafStructureCode

field name	data type	db field	description
tiSafStructure_ID	integer	SafStructure.SafStructure_ID	Record ID
tiSafConcept_ID	integer	SafStructureLine.SafConcept_ID	Link to SafConcept
tiSafStructureLineNumber	integer	SafStructureLine.SafStructureLineNumber	Line Number
tcSafConceptCode	character	SafConcept.SafConceptCode	SAF Concept Code
tlSafConceptIsActive	logical	SafConcept.SafConceptIsActive	Active
tcSafStructureCode	character	SafStructure.SafStructureCode	Structure Code
tlSafStructureIsActive	logical	SafStructure.SafStructureIsActive	Active
tcSafStructureDescription	character	SafStructure.SafStructureDescription	Description

QadFinancials