business logic query COACrossRefDetByIDParentID

Parameters

iiCOACrossRefID	integer
iiCOACrossRefDetID	integer
iiCompanyId	integer	Company 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 name	data type	db field	description
tiAltCOAStruct_ID	integer	AltCOAStructDet.AltCOAStruct_ID	Alternate COA Structure
tcAltCOAStructDetDescription	character	AltCOAStructDet.AltCOAStructDetDescription	Description
tcAltCOAStructDetSeq	character	AltCOAStructDet.AltCOAStructDetSeq	Sequence
tiCOACrossRef_ID	integer	COACrossRefDet.COACrossRef_ID	Cross Reference
tiCOACrossRefDet_ID	integer	COACrossRefDet.COACrossRefDet_ID	Cross Reference Detail
tcCOACrossRefDetSrcCCFrom	character	COACrossRefDet.COACrossRefDetSrcCCFrom	Source Cost Center From
tcCOACrossRefDetSrcCCTo	character	COACrossRefDet.COACrossRefDetSrcCCTo	Source Cost Center To
tcCOACrossRefDetSrcDivFrom	character	COACrossRefDet.COACrossRefDetSrcDivFrom	Source Sub-Account From
tcCOACrossRefDetSrcDivTo	character	COACrossRefDet.COACrossRefDetSrcDivTo	Source Sub-Account To
tcCOACrossRefDetSrcGLFrom	character	COACrossRefDet.COACrossRefDetSrcGLFrom	Source GL Account From
tcCOACrossRefDetSrcGLTo	character	COACrossRefDet.COACrossRefDetSrcGLTo	Source GL Account To
tcCOACrossRefDetSrcProjFrom	character	COACrossRefDet.COACrossRefDetSrcProjFrom	Source Project From
tcCOACrossRefDetSrcProjTo	character	COACrossRefDet.COACrossRefDetSrcProjTo	Source Project To
tlCostCentreIsWithSaf	logical	CostCentre.CostCentreIsWithSaf	SAF 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
tcExchangeRateTypeCode	character	ExchangeRateType.ExchangeRateTypeCode	A code identifying an exchange rate type. A number of types are predefined and required by the system.
tcGLExchangeMethod	character	GL.GLExchangeMethod	This field is filled If this account is used by a domain that is the target of a consolidation.
tlGLIsCostCentreAccount	logical	GL.GLIsCostCentreAccount	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.
tlGLIsDivisionAccount	logical	GL.GLIsDivisionAccount	Set 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.
tlGLIsProjectAccount	logical	GL.GLIsProjectAccount	Project 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.
tlGLIsSafAccount	logical	GL.GLIsSafAccount	SAF 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.
tlProjectIsWithSaf	logical	Project.ProjectIsWithSaf	SAF Enabled
tiTargetAltCOAStructDet_ID	integer	COACrossRefDet.TargetAltCOAStructDet_ID	Target Alternate COA
tcTargetAltCOAStructDetCode	character	AltCOAStructDet.AltCOAStructDetCode	Alternate COA
tiTargetCostCentre_ID	integer	COACrossRefDet.TargetCostCentre_ID	Target Cost Center
tcTargetCostCentreCode	character	CostCentre.CostCentreCode	Cost Center: A code that identifies the cost center.
tiTargetDivision_ID	integer	COACrossRefDet.TargetDivision_ID	Target Sub-Account
tcTargetDivisionCode	character	Division.DivisionCode	Sub-Account
tiTargetGL_ID	integer	COACrossRefDet.TargetGL_ID	Target GL Account
tcTargetGLCode	character	GL.GLCode	A code identifying the GL account.
tiTargetProject_ID	integer	COACrossRefDet.TargetProject_ID	Target Project
tcTargetProjectCode	character	Project.ProjectCode	Project
tiUsrDefExchangeRateType_ID	integer	GL.UsrDefExchangeRateType_ID	Consolidation Rate Type
ti_sequence	integer	calculated	primary index
tc_rowid	character	calculated	= 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