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

iiCompanyId	integer	Company id
iiDivisionID	integer	DivisionID
icDivisionCode	character	Sub-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 name	data type	db field	description
tcDivisionDescription	character	Division.DivisionDescription	Description
tiDivision_ID	integer	Division.Division_ID	Record ID
tcDivisionCode	character	Division.DivisionCode	Sub-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