project QadFinancials > class BSafStructure > business logic query SafConceptCodeByLine

Description

GetSafConceptCodeByLine


Parameters


iiSafStructure_IDintegerSAF Structure ID
iiSafStructureLineNumberintegerSAF Structure Line Number
icSafStructureCodecharacterSafStructureCode


query condition


  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


query resultset tqSafConceptCodeByLine


field namedata typedb fielddescription
tiSafStructure_IDintegerSafStructure.SafStructure_IDRecord ID
tiSafConcept_IDintegerSafStructureLine.SafConcept_IDLink to SafConcept
tiSafStructureLineNumberintegerSafStructureLine.SafStructureLineNumberLine Number
tcSafConceptCodecharacterSafConcept.SafConceptCodeSAF Concept Code
tlSafConceptIsActivelogicalSafConcept.SafConceptIsActiveActive
tcSafStructureCodecharacterSafStructure.SafStructureCodeStructure Code
tlSafStructureIsActivelogicalSafStructure.SafStructureIsActiveActive
tcSafStructureDescriptioncharacterSafStructure.SafStructureDescriptionDescription


Internal usage


QadFinancials
method BBudget.AdditionalUpdValBudgetFDS
method BBudget.AdditionalUpdValBudgetFDSCycle
method BBudget.BudgetWBSCreate
method BBudget.BudgetWBSCreateMultiple
method BBudget.BudgetWBSCreateMultipleGetInfo
method BBudget.BudgetWBSInsert
method BBudget.BudgetWBSUpdate
method BBudget.BudgetWBSUpdateSAFChilds
method BCostCentre.ApiGetCostCentreSafByCompany
method BProject.ApiGetProjectSafByCompany
method BQBudgetActual.AdditonalUpdatesDelete
method BQBudgetCommitment.AdditionalUpdatesDelete
method BSafStructure.APIGetSafConceptCode