project QadFinancials > class BSafStructure > business logic query SafStructureByDefault

Description

SafStructureByDefault


Parameters


icSafStructureCodecharacterSafStructureCode


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 namedata typedb fielddescription
tiSaf_IDintegerSafStructureLine.Saf_IDLink to Saf
tcSafCodecharacterSaf.SafCodeSAF Code
tiSafConcept_IDintegerSafStructureLine.SafConcept_IDLink to SafConcept
tcSafConceptCodecharacterSafConcept.SafConceptCodeSAF Concept Code
tiSafStructure_IDintegerSafStructure.SafStructure_IDRecord ID
tcSafStructureCodecharacterSafStructure.SafStructureCodeStructure Code


Internal usage


QadFinancials
method BSafDefault.GetSafDefaults