project QadFinancials > class BCOACrossRef > business logic query COACrossRefDetByIDParentID


Parameters


iiCOACrossRefIDinteger
iiCOACrossRefDetIDinteger
iiCompanyIdintegerCompany id


query condition


  each COACrossRefDet where
COACrossRefDet.COACrossRef_ID = iiCOACrossRefID AND
COACrossRefDet.COACrossRefDet_ID = iiCOACrossRefDetID

      first AltCOAStructDet (conditional-join) where
AltCOAStructDet.AltCOAStructDet_ID = COACrossRefDet.TargetAltCOAStructDet_ID AND

      first CostCentre (conditional-join) where
CostCentre.SharedSet_Id = vi_COSTCENTRE_sharedset(iiCompanyId) AND
CostCentre.CostCentre_ID = COACrossRefDet.TargetCostCentre_ID AND

      first Division (conditional-join) where
Division.SharedSet_Id = vi_DIVISION_sharedset(iiCompanyId) AND
Division.Division_ID = COACrossRefDet.TargetDivision_ID AND

      first GL (conditional-join) where
GL.SharedSet_Id = vi_GL_sharedset(iiCompanyId) AND
GL.GL_ID = COACrossRefDet.TargetGL_ID AND

          first ExchangeRateType (conditional-join) where
ExchangeRateType.ExchangeRateType_ID = GL.UsrDefExchangeRateType_ID AND

      first Project (conditional-join) where
Project.SharedSet_Id = vi_PROJECT_sharedset(iiCompanyId) AND
Project.Project_ID = COACrossRefDet.TargetProject_ID AND


query resultset tqCOACrossRefDetByIDParentID


field namedata typedb fielddescription
tiAltCOAStruct_IDintegerAltCOAStructDet.AltCOAStruct_IDAlternate COA Structure
tcAltCOAStructDetDescriptioncharacterAltCOAStructDet.AltCOAStructDetDescriptionDescription
tcAltCOAStructDetSeqcharacterAltCOAStructDet.AltCOAStructDetSeqSequence
tiCOACrossRef_IDintegerCOACrossRefDet.COACrossRef_IDCross Reference
tiCOACrossRefDet_IDintegerCOACrossRefDet.COACrossRefDet_IDCross Reference Detail
tcCOACrossRefDetSrcCCFromcharacterCOACrossRefDet.COACrossRefDetSrcCCFromSource Cost Center From
tcCOACrossRefDetSrcCCTocharacterCOACrossRefDet.COACrossRefDetSrcCCToSource Cost Center To
tcCOACrossRefDetSrcDivFromcharacterCOACrossRefDet.COACrossRefDetSrcDivFromSource Sub-Account From
tcCOACrossRefDetSrcDivTocharacterCOACrossRefDet.COACrossRefDetSrcDivToSource Sub-Account To
tcCOACrossRefDetSrcGLFromcharacterCOACrossRefDet.COACrossRefDetSrcGLFromSource GL Account From
tcCOACrossRefDetSrcGLTocharacterCOACrossRefDet.COACrossRefDetSrcGLToSource GL Account To
tcCOACrossRefDetSrcProjFromcharacterCOACrossRefDet.COACrossRefDetSrcProjFromSource Project From
tcCOACrossRefDetSrcProjTocharacterCOACrossRefDet.COACrossRefDetSrcProjToSource Project To
tlCostCentreIsWithSaflogicalCostCentre.CostCentreIsWithSafSAF Enabled: This field indicates if the SAF analysis is enabled.
api annotation:This field can be left blank as it will be calculated by the system.
PartialUpdate = yes - defaults to false
tcExchangeRateTypeCodecharacterExchangeRateType.ExchangeRateTypeCodeA code identifying an exchange rate type. A number of types are predefined and required by the system.
tcGLExchangeMethodcharacterGL.GLExchangeMethodThis field is filled If this account is used by a domain that is the target of a consolidation.
tlGLIsCostCentreAccountlogicalGL.GLIsCostCentreAccountThis field will be calculated by the system based on the value of tcAnalysisType.

If the analysis type of the account is Project the value will be true.
api annotation:This field can be left blank as it will be calculated by the system.
tlGLIsDivisionAccountlogicalGL.GLIsDivisionAccountSet to true if the account has a sub-account.
Its value is calculated by the system and is determined by the value of tcDivisionProfileCode.
api annotation:This field can be left blank as it will be calculated by the system.
tlGLIsProjectAccountlogicalGL.GLIsProjectAccountProject Analysis: This field will be calculated by the system based on the value of tcAnalysisType.
If the analysis type of the account is Project the value will be true.
api annotation:This field can be left blank as it will be calculated by the system.
tlGLIsSafAccountlogicalGL.GLIsSafAccountSAF Enabled: This field will be calculated by the system based on the value of tcAnalysisType.
If the analysis type of the account is Project the value will be true.
api annotation:This field can be left blank as it will be calculated by the system.
tlProjectIsWithSaflogicalProject.ProjectIsWithSafSAF Enabled
tiTargetAltCOAStructDet_IDintegerCOACrossRefDet.TargetAltCOAStructDet_IDTarget Alternate COA
tcTargetAltCOAStructDetCodecharacterAltCOAStructDet.AltCOAStructDetCodeAlternate COA
tiTargetCostCentre_IDintegerCOACrossRefDet.TargetCostCentre_IDTarget Cost Center
tcTargetCostCentreCodecharacterCostCentre.CostCentreCodeCost Center: A code that identifies the cost center.
tiTargetDivision_IDintegerCOACrossRefDet.TargetDivision_IDTarget Sub-Account
tcTargetDivisionCodecharacterDivision.DivisionCodeSub-Account
tiTargetGL_IDintegerCOACrossRefDet.TargetGL_IDTarget GL Account
tcTargetGLCodecharacterGL.GLCodeA code identifying the GL account.
tiTargetProject_IDintegerCOACrossRefDet.TargetProject_IDTarget Project
tcTargetProjectCodecharacterProject.ProjectCodeProject
tiUsrDefExchangeRateType_IDintegerGL.UsrDefExchangeRateType_IDConsolidation Rate Type
ti_sequenceintegercalculatedprimary index
tc_rowidcharactercalculated = rowid(COACrossRefDet),rowid(AltCOAStructDet),rowid(CostCentre),rowid(Division),rowid(GL),rowid(ExchangeRateType),rowid(Project)


Internal usage


QadFinancials
method BCOACrossRef.ApiLoadCOACrossRef
method BCOACrossRef.GetCOACrossRef
method BConsolid.ValidateComponentPost
method BConsolidCycle.ValidateComponentAllCrossReference