project QadFinancials > class BDivision > business logic query DivisionPrim

Description

Query that returns the ID and Code of the Division based on tyhe ID and the Code. Code is a related-key-business-field.


Parameters


iiCompanyIdintegerCompany id
iiDivisionIDintegerDivisionID
icDivisionCodecharacterSub-Account Code


query condition


  each Division where
Division.SharedSet_Id = vi_DIVISION_sharedset(iiCompanyId) AND
Division.DivisionCode = icDivisionCode AND
Division.Division_ID = iiDivisionID


query resultset tqDivisionPrim


field namedata typedb fielddescription
tcDivisionDescriptioncharacterDivision.DivisionDescriptionDescription
tiDivision_IDintegerDivision.Division_IDRecord ID
tcDivisionCodecharacterDivision.DivisionCodeSub-Account


Internal usage


QadFinancials
method BAllocationBatch.GetProposedAllocationsProportionalClean
method BAPMatching.AdditionalUpdatesAllLinesPLAddPostingLine
method BAPMatching.AdditionalUpdatesAllLinesPLAddPostingLineOpAllocCode
method BBudget.BudgetWBSAutoLinkAssignFDS
method BBudget.ValidateComponentBudgetWBSList
method BBudget.ValidateComponentBudgetWBSRange
method BCDocument.AdditionalUpdatesPostingCrossCy
method BCOACrossRef.DefaultValuesTypeSeperate
method BCOACrossRef.ValidateComponentPre
method BCreditorOpenBalance.ApiCreateCreditorOpenBalanceV01
method BDebtorOpenBalance.ApiCreateDebtorOpenBalanceV01
method BDeductionCat.ValidateComponent
method BDInvoice.CreateDIPostingValidate
method BDivision.ApiGetRoleScopeValues
method BDivision.ApiReplicateFromDaemon
method BDivision.ApiStdMaintainTT
method BDomain.AdditionalUpdatesReplication
method BEmployee.ApiLoadEmployee
method BEmployee.ApiLoadEmployeeCalcDivisionCode
method BFixedAssetRevaluation.RevaluationCreateDet
method BFRWAnalysisCode.ValidateComponentPreFRWAnCodeElemDet
method BGLMask.ApiSetGLMasks
method BGLMask.ApiStdMaintainTT
method BGLMask.DataLoadByInput
method BGLReport.ApiGetAlternateKeyValues
method BGLReport.SetDataItemsBasedOnFilterTT
method BGrossIncomeAccounting.DataLoadByInput
method BPosting.AddPostingSub
method BJournalEntry.GetPostingAmountByPostingLineId
method BJournalEntry.GetPostingInfoByPostingLineIDTT
method BJournalEntry.UpdatePostingLine
method BQCrossCyPosting.ApiProcessQCrossCyPostingForAPM
method BWithholdingTax.ValidateComponent
read related business field(s) on tAllocationProportional.Division_ID
read related business field(s) on tAPMatchingLn.Division_ID
read related business field(s) on tAPMatchingLnTax.NormalTaxDivision_ID
read related business field(s) on tAPMatchingLnTax.AbsRetTaxDivision_ID
read related business field(s) on tAPMatchingLnTax.SuspDelTaxDivision_ID
read related business field(s) on tAPMatchingLnWHT.Division_ID
read related business field(s) on tCashReport.Division_ID
read related business field(s) on tCInvoice.Division_ID
read related business field(s) on tCInvoiceVat.NormalTaxDivision_ID
read related business field(s) on tCInvoiceVat.AbsRetTaxDivision_ID
read related business field(s) on tCInvoiceVat.SuspDelTaxDivision_ID
read related business field(s) on tCInvoiceWHT.Division_ID
read related business field(s) on tCOACrossRefDet.TargetDivision_ID
read related business field(s) on tCompanyProperty.CompPropIntercoARDbDiv_ID
read related business field(s) on tCompanyProperty.CompPropIntercoICDbDiv_ID
read related business field(s) on tCompanyProperty.CompPropIntercoICCrDiv_ID
read related business field(s) on tCompanyProperty.CompPropIntercoARCrDiv_ID
read related business field(s) on tCompanyProperty.CompPropIntercoFADbDiv_ID
read related business field(s) on tCompanyProperty.CompPropIntercoFACrDiv_ID
read related business field(s) on tConsolidCycle.Division_ID
read related business field(s) on tDeductionCatLine.Division_ID
read related business field(s) on tDInvoice.Division_ID
read related business field(s) on tDInvoiceVat.NormalTaxDivision_ID
read related business field(s) on tDInvoiceVat.AbsRetTaxDivision_ID
read related business field(s) on tDInvoiceVat.SuspDelTaxDivision_ID
read related business field(s) on tEmployee.Division_ID
read related business field(s) on tExpNoteLine.Division_ID
read related business field(s) on tFAAsset.Division_ID
read related business field(s) on tFAAssetGL.Division_ID
read related business field(s) on tFADepreciationDet.Division_ID
read related business field(s) on tFADisposalDet.Division_ID
read related business field(s) on tFARevalDet.Division_ID
read related business field(s) on tGLMask.Division_ID
read related business field(s) on tGrossIncAcc.SalesDivision_ID
read related business field(s) on tGrossIncAcc.TaxExpenseDivision_ID
read related business field(s) on tGrossIncAcc.TaxPayableDivision_ID
read related business field(s) on tMirroringGL.Source1Division_ID
read related business field(s) on tMirroringGL.Mirror1Division_ID
read related business field(s) on tMirroringGL.Source2Division_ID
read related business field(s) on tMirroringGL.Mirror2Division_ID
read related business field(s) on tPostingLine.Division_ID
read related business field(s) on tRevalGL.Division_ID
read related business field(s) on tWHT.Division_ID
ApiGetAlternateKeyValues
ApiGetAlternateKeyValues
ApiGetAlternateKeyValues
ApiGetAlternateKeyValues
ApiGetAlternateKeyValues
ApiGetAlternateKeyValues
ApiGetAlternateKeyValues
ApiGetAlternateKeyValues
ApiGetAlternateKeyValues
ApiGetAlternateKeyValues
ApiGetAlternateKeyValues
ApiGetAlternateKeyValues
ApiGetAlternateKeyValues
ApiGetAlternateKeyValues
ApiGetAlternateKeyValues
ApiGetAlternateKeyValues
ApiGetAlternateKeyValues
ApiGetAlternateKeyValues
ApiGetAlternateKeyValues
ApiGetAlternateKeyValues
ApiGetAlternateKeyValues
ApiGetAlternateKeyValues
ApiGetAlternateKeyValues
ApiGetAlternateKeyValues
ApiGetAlternateKeyValues
ApiGetAlternateKeyValues
ApiGetAlternateKeyValues
ApiGetAlternateKeyValues
ApiGetAlternateKeyValues
ApiGetAlternateKeyValues
ApiGetAlternateKeyValues
ApiGetAlternateKeyValues
ApiGetAlternateKeyValues
ApiGetAlternateKeyValues
ApiGetAlternateKeyValues
ApiGetAlternateKeyValues
ApiGetAlternateKeyValues
ApiGetAlternateKeyValues
ApiGetAlternateKeyValues
ApiGetAlternateKeyValues
ApiGetAlternateKeyValues
ApiGetAlternateKeyValues
ApiGetAlternateKeyValues
validate related business field(s) on tAllocationProportional.Division_ID
validate related business field(s) on tAPMatchingLn.Division_ID
validate related business field(s) on tAPMatchingLnTax.NormalTaxDivision_ID
validate related business field(s) on tAPMatchingLnTax.AbsRetTaxDivision_ID
validate related business field(s) on tAPMatchingLnTax.SuspDelTaxDivision_ID
validate related business field(s) on tAPMatchingLnWHT.Division_ID
validate related business field(s) on tCashReport.Division_ID
validate related business field(s) on tCInvoice.Division_ID
validate related business field(s) on tCInvoiceVat.NormalTaxDivision_ID
validate related business field(s) on tCInvoiceVat.AbsRetTaxDivision_ID
validate related business field(s) on tCInvoiceVat.SuspDelTaxDivision_ID
validate related business field(s) on tCInvoiceWHT.Division_ID
validate related business field(s) on tCompanyProperty.CompPropIntercoARDbDiv_ID
validate related business field(s) on tCompanyProperty.CompPropIntercoICDbDiv_ID
validate related business field(s) on tCompanyProperty.CompPropIntercoICCrDiv_ID
validate related business field(s) on tCompanyProperty.CompPropIntercoARCrDiv_ID
validate related business field(s) on tCompanyProperty.CompPropIntercoFADbDiv_ID
validate related business field(s) on tCompanyProperty.CompPropIntercoFACrDiv_ID
validate related business field(s) on tConsolidCycle.Division_ID
validate related business field(s) on tDeductionCatLine.Division_ID
validate related business field(s) on tDInvoice.Division_ID
validate related business field(s) on tDInvoiceVat.NormalTaxDivision_ID
validate related business field(s) on tDInvoiceVat.AbsRetTaxDivision_ID
validate related business field(s) on tDInvoiceVat.SuspDelTaxDivision_ID
validate related business field(s) on tEmployee.Division_ID
validate related business field(s) on tExpNoteLine.Division_ID
validate related business field(s) on tFAAsset.Division_ID
validate related business field(s) on tFAAssetGL.Division_ID
validate related business field(s) on tFADepreciationDet.Division_ID
validate related business field(s) on tFADisposalDet.Division_ID
validate related business field(s) on tFARevalDet.Division_ID
validate related business field(s) on tGrossIncAcc.SalesDivision_ID
validate related business field(s) on tGrossIncAcc.TaxExpenseDivision_ID
validate related business field(s) on tGrossIncAcc.TaxPayableDivision_ID
validate related business field(s) on tMirroringGL.Source1Division_ID
validate related business field(s) on tMirroringGL.Mirror1Division_ID
validate related business field(s) on tMirroringGL.Source2Division_ID
validate related business field(s) on tMirroringGL.Mirror2Division_ID
validate related business field(s) on tPostingLine.Division_ID
validate related business field(s) on tRevalGL.Division_ID
validate related business field(s) on tWHT.Division_ID