business logic query DomainForCalculate

Description

DomainForInterCompany: query that returns the Interco G.L accounts for a certain domain.

Parameters

iiDomainID	integer	Domain ID
icDomainCode	character	Domain Code
iiCompanyID	integer	Company id: redundant paramater that was auto-added by CB-tool and that corresponds with the SharedSet of the lined G/L

query condition

each Domains where

Domains.Domain_ID = iiDomainID AND
Domains.DomainCode = icDomainCode

each DomainProperty (inner-join) where

DomainProperty.Domain_ID = Domains.Domain_ID AND

first Currency (inner-join) where

Currency.Currency_ID = DomainProperty.Currency_ID AND

first GL1 (outer-join) where

GL1.SharedSet_Id = vi_GL_sharedset(iiCompanyId) AND
GL1.GL_ID = DomainProperty.IntercoAPGL_ID AND

first GL2 (outer-join) where

GL2.SharedSet_Id = vi_GL_sharedset(iiCompanyId) AND
GL2.GL_ID = DomainProperty.IntercoARGL_ID AND

first GL3 (outer-join) where

GL3.SharedSet_Id = vi_GL_sharedset(iiCompanyId) AND
GL3.GL_ID = DomainProperty.IntercoFAGL_ID AND

first GL4 (outer-join) where

GL4.SharedSet_Id = vi_GL_sharedset(iiCompanyId) AND
GL4.GL_ID = DomainProperty.IntercoICGL_ID AND

first GL5 (outer-join) where

GL5.SharedSet_Id = vi_GL_sharedset(iiCompanyId) AND
GL5.GL_ID = DomainProperty.IntercoJEGL_ID AND

query resultset tqDomainForCalculate

field name	data type	db field	description
tcCurrencyCode	character	Currency.CurrencyCode	Currency Code
tiDeductPaymentCondition_ID	integer	DomainProperty.DeductPaymentCondition_ID	Non-Staged Deduction Payment Condition
tcDomainPropertyCodePage	character	DomainProperty.DomainPropertyCodePage	Domain Code Page
tlDomainPropertyIsChronolNr	logical	DomainProperty.DomainPropertyIsChronolNr	Chronological Invoice Numbering
tlDomainPropertyIsConsecutNr	logical	DomainProperty.DomainPropertyIsConsecutNr	Consecutive Invoice Numbering
tlDomainPropertyIsInvCertific	logical	DomainProperty.DomainPropertyIsInvCertific	Invoice Certification: activated or not
tlDomainPropertyIsMaskCC	logical	DomainProperty.DomainPropertyIsMaskCC	Cost Center COA Mask
tlDomainPropertyIsMaskCCAll	logical	DomainProperty.DomainPropertyIsMaskCCAll	Cost Center All-Range Mask By Default
tlDomainPropertyIsMaskDiv	logical	DomainProperty.DomainPropertyIsMaskDiv	Sub-Account COA Mask
tlDomainPropertyIsMaskDivAll	logical	DomainProperty.DomainPropertyIsMaskDivAll	Sub-Account All-Range Mask By Default
tlDomainPropertyIsMaskPrjAll	logical	DomainProperty.DomainPropertyIsMaskPrjAll	Project All-Range Mask By Default
tlDomainPropertyIsMaskProj	logical	DomainProperty.DomainPropertyIsMaskProj	Project COA Mask
tlDomainPropertyIsPIBFLogEnabled	logical	DomainProperty.DomainPropertyIsPIBFLogEnabled	Enable Incoming Bank File Log
tlDomainPropertyIsPopupInvNr	logical	DomainProperty.DomainPropertyIsPopupInvNr	Show Supplier Invoice Number in Pop-up After Save
tlDomainPropertyIsStatutory	logical	DomainProperty.DomainPropertyIsStatutory	Statutory Currency Enabled
tlDomainPropertyIsTaxValid	logical	DomainProperty.DomainPropertyIsTaxValid	Tax Validation
tlDomainPropertyIsWHT	logical	DomainProperty.DomainPropertyIsWHT	Use Withholding Tax
tcDomainPropertyName	character	DomainProperty.DomainPropertyName	Name
tcDomainPropertyNonChronErr	character	DomainProperty.DomainPropertyNonChronErr	Action on Non-Chronological Number
tcDomainPropertySearchName	character	DomainProperty.DomainPropertySearchName	Search Name
tcDomainPropertyWHTDueMoment	character	DomainProperty.DomainPropertyWHTDueMoment	WHT Due at
tiPrepayPaymentCondition_ID	integer	DomainProperty.PrepayPaymentCondition_ID	Non-Staged Prepayment Payment Condition
tiStatutoryCurrency_ID	integer	DomainProperty.StatutoryCurrency_ID	Statutory Currency
tiDomain_ID	integer	Domains.Domain_ID	Record ID
tcDomainCode	character	Domains.DomainCode	Domain
tiCurrency_ID	integer	DomainProperty.Currency_ID	Base Currency
tiDomainProperty_ID	integer	DomainProperty.DomainProperty_ID	Record ID
tiLng_ID	integer	Domains.Lng_ID	Language
tiPrimaryCompany_ID	integer	Domains.PrimaryCompany_ID	Primary Entity
tlDomainIsActive	logical	Domains.DomainIsActive	Active
tcDomainType	character	Domains.DomainType	Type
tlDomainPropertyIsSetupCompl	logical	DomainProperty.DomainPropertyIsSetupCompl	Setup Complete
tiIntercoAPGL_ID	integer	DomainProperty.IntercoAPGL_ID	Account Payable GL Account
tcIntercoAPGLCode	character	GL1.GLCode	A code identifying the GL account.
tlIntercoAPGLIsProjectAccount	logical	GL1.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.
tlIntercoAPGLIsIntercoAccount	logical	GL1.GLIsIntercoAccount	If the account is an intercompany account. Its value is calculated by the system and is determined by the value of tcBusinessRelationInterco.
	api annotation:		This field can be left blank as it will be calculated by the system.
tlIntercoAPGLIsDivisionAccount	logical	GL1.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.
tlIntercoAPGLIsCostCentreAccount	logical	GL1.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.
tiIntercoAPCostCentreProfile_ID	integer	GL1.CostCentreProfile_ID	Link to Profile
tiIntercoAPDivisionProfile_ID	integer	GL1.DivisionProfile_ID	Link to Profile
tiIntercoAPProjectProfile_ID	integer	GL1.ProjectProfile_ID	Link to Profile
tiIntercoARGL_ID	integer	DomainProperty.IntercoARGL_ID	Account Receivable GL Account
tcIntercoARGLCode	character	GL2.GLCode	A code identifying the GL account.
tlIntercoARGLIsProjectAccount	logical	GL2.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.
tlIntercoARGLIsIntercoAccount	logical	GL2.GLIsIntercoAccount	If the account is an intercompany account. Its value is calculated by the system and is determined by the value of tcBusinessRelationInterco.
	api annotation:		This field can be left blank as it will be calculated by the system.
tiIntercoARCostCentreProfile_ID	integer	GL2.CostCentreProfile_ID	Link to Profile
tiIntercoARDivisionProfile_ID	integer	GL2.DivisionProfile_ID	Link to Profile
tiIntercoARProjectProfile_ID	integer	GL2.ProjectProfile_ID	Link to Profile
tlIntercoARGLIsDivisionAccount	logical	GL2.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.
tlIntercoARGLIsCostCentreAccount	logical	GL2.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.
tiIntercoFAGL_ID	integer	DomainProperty.IntercoFAGL_ID	Fixed Asset GL Account
tcIntercoFAGLCode	character	GL3.GLCode	A code identifying the GL account.
tlIntercoFAGLIsCDivisionAccount	logical	GL3.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.
tlIntercoFAGLIsCostCentreAccount	logical	GL3.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.
tiIntercoFACostCentreProfile_ID	integer	GL3.CostCentreProfile_ID	Link to Profile
tiIntercoFADivisionProfile_ID	integer	GL3.DivisionProfile_ID	Link to Profile
tlIntercoFAGLIsProjectAccount	logical	GL3.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.
tiIntercoFAProjectProfile_ID	integer	GL3.ProjectProfile_ID	Link to Profile
tlIntercoFAGLIsIntercoAccount	logical	GL3.GLIsIntercoAccount	If the account is an intercompany account. Its value is calculated by the system and is determined by the value of tcBusinessRelationInterco.
	api annotation:		This field can be left blank as it will be calculated by the system.
tiIntercoICGL_ID	integer	DomainProperty.IntercoICGL_ID	Inter Company GL Account
tcIntercoICGLCode	character	GL4.GLCode	A code identifying the GL account.
tiIntercoICCostCentreProfile_ID	integer	GL4.CostCentreProfile_ID	Link to Profile
tiIntercoICDivisionProfile_ID	integer	GL4.DivisionProfile_ID	Link to Profile
tiIntercoICProjectProfile_ID	integer	GL4.ProjectProfile_ID	Link to Profile
tlIntercoICGLIsProjectAccount	logical	GL4.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.
tlIntercoICGLIsIntercoAccount	logical	GL4.GLIsIntercoAccount	If the account is an intercompany account. Its value is calculated by the system and is determined by the value of tcBusinessRelationInterco.
	api annotation:		This field can be left blank as it will be calculated by the system.
tlIntercoICGLIsDivisionAccount	logical	GL4.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.
tlIntercoICGLIsCostCentreAccount	logical	GL4.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.
tiIntercoJEGL_ID	integer	DomainProperty.IntercoJEGL_ID	Manual Journal Entry GL Account
tcIntercoJEGLCode	character	GL5.GLCode	A code identifying the GL account.
tiIntercoJECostCentreProfile_ID	integer	GL5.CostCentreProfile_ID	Link to Profile
tiIntercoJEDivisionProfile_ID	integer	GL5.DivisionProfile_ID	Link to Profile
tiIntercoJEProjectProfile_ID	integer	GL5.ProjectProfile_ID	Link to Profile
tlIntercoJEGLIsProjectAccount	logical	GL5.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.
tlIntercoJEGLIsIntercoAccount	logical	GL5.GLIsIntercoAccount	If the account is an intercompany account. Its value is calculated by the system and is determined by the value of tcBusinessRelationInterco.
	api annotation:		This field can be left blank as it will be calculated by the system.
tlIntercoJEGLIsDivisionAccount	logical	GL5.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.
tlIntercoJEGLIsCostCentreAccount	logical	GL5.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.
ti_sequence	integer	calculated	primary index
tc_rowid	character	calculated	= rowid(Domains),rowid(DomainProperty),rowid(Currency),rowid(GL1),rowid(GL2),rowid(GL3),rowid(GL4),rowid(GL5)

Internal usage

QadFinancials

method BDomain.Calculate