project QadFinancials > class BSaf > business logic query SafPrim

Description

Prim query
= query that can be used to find the logical key based on the prim-key and vice-versa.


Parameters


iiSafIDintegerSafID
icSafCodecharacterSAF Code
icSafConceptCodecharacter


query condition


  each Saf where
Saf.Saf_ID = iiSafID and
Saf.SafCode = icSafCode

      first SafConcept (inner-join) where
SafConcept.SafConcept_ID = Saf.SafConcept_ID AND
SafConcept.SafConceptCode = icSafConceptCode


query resultset tqSafPrim


field namedata typedb fielddescription
tcSafConceptCodecharacterSafConcept.SafConceptCodeSAF Concept Code
tcSafCodecharacterSaf.SafCodeSAF Code
tiSaf_IDintegerSaf.Saf_IDRecord ID


Internal usage


QadFinancials
method BAllocationBatch.GetProposedAllocationsProportionalClean
method BAnalyticalReport.ApiGetAlternateKeyValues
method BAnalyticalReport.SetDataItemsBasedOnFilterTTSub
method BBudget.BudgetWBSAutoLinkAssignFDS
method BBudgetLinkAccDet.ApiCreateOrUpdateBudgetLinkAccDet
method BBusinessRelation.ValidateComponent
method BBusinessRelation.ValidateComponentPre
method BCostCentre.ValidateComponent
method BCreditor.PostValidateComponent
method BCreditor.ValidateComponent
method BDebtor.PostValidateComponent
method BDebtor.ValidateComponent
method BDeductionCat.ApiGetSafsByGLCodeCostCenter
method BDeductionCat.ValidateComponent
method BExpenseNote.Calculate
method BFixedAssetDepreciation.PostValidateComponent
method BFixedAssetDepreciation.ValidateComponent
method BFixedAssetRevaluation.RevaluationCreateDetSafForFAAccount
method BFixedAssetRevaluation.RevaluationCreateDetSafForRevalAccount
method BFRWAnalysisCode.ValidateComponentPreFRWAnCodeElemDet
method BGL.ValGL
method BGL.ValidateComponent
method BPosting.ApiStdMaintainTTCreatetApiSafFromPosting
method BPosting.StdMaintainTTSub1
method BProject.ValidateComponent
method BSaf.ApiStdMaintainTT
method BSafStructure.Calculate
read related business field(s) on tAllocationProportional.Saf_ID
read related business field(s) on tBusRelationSafDefault.Saf_ID
read related business field(s) on tConsolidCycleSaf.Saf_ID
read related business field(s) on tCostCentreSafDefault.Saf_ID
read related business field(s) on tCreditorSafDefault.Saf_ID
read related business field(s) on tDebtorSafDefault.Saf_ID
read related business field(s) on tDeductionCatLineSaf.Saf_ID
read related business field(s) on tFAAssetGLSaf.Saf_ID
read related business field(s) on tFAAssetSaf.Saf_ID
read related business field(s) on tFADepreciationDetSaf.Saf_ID
read related business field(s) on tFADisposalDetSaf.Saf_ID
read related business field(s) on tFARevalDetSaf.Saf_ID
read related business field(s) on tGLSafDefault.Saf_ID
read related business field(s) on tPostingSaf.Saf_ID
read related business field(s) on tProjectSafDefault.Saf_ID
ApiGetAlternateKeyValues
ApiGetAlternateKeyValues
ApiGetAlternateKeyValues
ApiGetAlternateKeyValues
ApiGetAlternateKeyValues
ApiGetAlternateKeyValues
ApiGetAlternateKeyValues
ApiGetAlternateKeyValues
ApiGetAlternateKeyValues
ApiGetAlternateKeyValues
ApiGetAlternateKeyValues
ApiGetAlternateKeyValues
ApiGetAlternateKeyValues
ApiGetAlternateKeyValues
ApiGetAlternateKeyValues
validate related business field(s) on tAllocationProportional.Saf_ID
validate related business field(s) on tConsolidCycleSaf.Saf_ID
validate related business field(s) on tDeductionCatLineSaf.Saf_ID
validate related business field(s) on tFAAssetGLSaf.Saf_ID
validate related business field(s) on tFAAssetSaf.Saf_ID
validate related business field(s) on tFADisposalDetSaf.Saf_ID
validate related business field(s) on tFARevalDetSaf.Saf_ID
validate related business field(s) on tPostingSaf.Saf_ID