business logic query RevaluationForBase

Parameters

iiCompanyId	integer	Company id
iiAccPeriod	integer
iiAccYear	integer
iiRevalNumber	integer
icRevalArea	character

query condition

each RevalHeader where

RevalHeader.Company_Id = iiCompanyId AND
RevalHeader.RevalHeaderNumber = iiRevalNumber

first Layer (inner-join) where

Layer.Layer_ID = RevalHeader.Layer_ID AND

first Period (inner-join) where

Period.Company_Id = iiCompanyId AND
Period.Period_ID = RevalHeader.Period_ID AND
Period.PeriodYear = iiAccYear AND
Period.PeriodPeriod = iiAccPeriod

each Reval (conditional-join) where

Reval.RevalHeader_ID = RevalHeader.RevalHeader_ID AND
Reval.RevalRevaluationArea can-do icRevalArea

each RevalGL (conditional-join) where

RevalGL.Reval_ID = Reval.Reval_ID AND

first BusinessRelation (conditional-join) where

BusinessRelation.BusinessRelation_ID = RevalGL.IntercoBusinessRelation_ID AND

first GL1 (conditional-join) where

GL1.SharedSet_Id = vi_GL_sharedset(iiCompanyId) AND
GL1.GL_ID = RevalGL.GL_ID AND

first GL2 (conditional-join) where

GL2.SharedSet_Id = vi_GL_sharedset(iiCompanyId) AND
GL2.GL_ID = GL1.RevaluationGL_ID AND

first Project (conditional-join) where

Project.SharedSet_Id = vi_PROJECT_sharedset(iiCompanyId) AND
Project.Project_ID = RevalGL.Project_ID AND

each RevalDet (conditional-join) where

RevalDet.RevalGL_ID = RevalGL.RevalGL_ID AND

first RevalGLSafCombined (conditional-join) where

RevalGLSafCombined.RevalGLSafCombined_ID = RevalGL.RevalGLSafCombined_ID AND

query resultset tqRevaluationForBase

field name	data type	db field	description
tcBusinessRelationCodeInt	character	BusinessRelation.BusinessRelationCode	Business Relation. A code to identify the business relation. If this field does not have a input from the user, the system automatically generates a number for the record based on the sequence defined in Business Relation Autonumber Create.
tcBusinessRelationName1Int	character	BusinessRelation.BusinessRelationName1	Name: The full name of the business relation. This field sets the default name for linked addresses such as customers and suppliers.
	api annotation:		PartialUpdate = yes - defaults to the BusinessRelationCode.
tiCostCentre_ID	integer	RevalGL.CostCentre_ID	Cost Center
tiCurrency_ID	integer	RevalGL.Currency_ID	Currency Code
tiDivision_ID	integer	RevalGL.Division_ID	Sub-Account
tiGL_ID	integer	GL1.GL_ID	Record ID
tiGL_ID1	integer	GL2.GL_ID	Record ID
tcGLCodeRevaluated	character	GL1.GLCode	A code identifying the GL account.
tcGLCodeRevaluation	character	GL2.GLCode	A code identifying the GL account.
tcGLDescriptionRevaluated	character	GL1.GLDescription	A description of the GL account.
tcGLDescriptionRevaluation	character	GL2.GLDescription	A description of the GL account.
tlGLIsDebitAccount	logical	GL1.GLIsDebitAccount	Debit/Credit: The posting designation for this account.
	api annotation:		This field can be left blank as it will be calculated by the system.
tiLayer_ID	integer	Layer.Layer_ID	Record ID
tcLayerCode	character	Layer.LayerCode	Layer Code
tcLayerDescription	character	Layer.LayerDescription	Description
tcLayerTypeCode	character	Layer.LayerTypeCode	Layer Type
tiPeriodPeriodRev	integer	Period.PeriodPeriod	GL Period
tiPeriodYearRev	integer	Period.PeriodYear	GL Calendar Year
tiProject_ID	integer	Project.Project_ID	Record ID
tcProjectCode	character	Project.ProjectCode	Project
tcProjectDescription	character	Project.ProjectDescription	Description
tiRevalDet_ID	integer	RevalDet.RevalDet_ID	Record ID
tdRevalDetCreditCC	decimal	RevalDet.RevalDetCreditCC	SC Credit
tdRevalDetCreditLC	decimal	RevalDet.RevalDetCreditLC	BC Credit
tdRevalDetCreditTC	decimal	RevalDet.RevalDetCreditTC	TC Credit
tdRevalDetDebitCC	decimal	RevalDet.RevalDetDebitCC	SC Debit
tdRevalDetDebitLC	decimal	RevalDet.RevalDetDebitLC	BC Debit
tdRevalDetDebitTC	decimal	RevalDet.RevalDetDebitTC	TC Debit
tiRevalDetParentObject_ID	integer	RevalDet.RevalDetParentObject_ID	Link to ParentObject
tcRevalDetParentObjectType	character	RevalDet.RevalDetParentObjectType	Object Type
tdRevalDetRevCreditCC	decimal	RevalDet.RevalDetRevCreditCC	SC Revaluated Credit
tdRevalDetRevCreditLC	decimal	RevalDet.RevalDetRevCreditLC	BC Revaluated Credit
tdRevalDetRevDebitCC	decimal	RevalDet.RevalDetRevDebitCC	SC Revaluated Debit
tdRevalDetRevDebitLC	decimal	RevalDet.RevalDetRevDebitLC	BC Revaluated Debit
tiRevalGL_ID	integer	RevalGL.RevalGL_ID	Record ID
tdRevalGLCreditCC	decimal	RevalGL.RevalGLCreditCC	SC Credit
tdRevalGLCreditLC	decimal	RevalGL.RevalGLCreditLC	BC Credit
tdRevalGLCreditTC	decimal	RevalGL.RevalGLCreditTC	TC Credit
tdRevalGLDebitCC	decimal	RevalGL.RevalGLDebitCC	SC Debit
tdRevalGLDebitLC	decimal	RevalGL.RevalGLDebitLC	BC Debit
tdRevalGLDebitTC	decimal	RevalGL.RevalGLDebitTC	TC Debit
tcRevalGLMethodCC	character	RevalGL.RevalGLMethodCC	SC Revaluation Method
tcRevalGLMethodTC	character	RevalGL.RevalGLMethodTC	TC Revaluation Method
tdRevalGLRevCreditCC	decimal	RevalGL.RevalGLRevCreditCC	SC Revaluated Credit
tdRevalGLRevCreditLC	decimal	RevalGL.RevalGLRevCreditLC	BC Revaluated Credit
tdRevalGLRevDebitCC	decimal	RevalGL.RevalGLRevDebitCC	SC Revaluated Debit
tdRevalGLRevDebitLC	decimal	RevalGL.RevalGLRevDebitLC	BC Revaluated Debit
tcRevalGLType	character	RevalGL.RevalGLType	GL Type
tcRevalHeaderDescription	character	RevalHeader.RevalHeaderDescription	Rev Desc
tiRevalHeaderNumber	integer	RevalHeader.RevalHeaderNumber	Rev Number
ttRevalHeaderRevalDate	date	RevalHeader.RevalHeaderRevalDate	Rev Date
tcRevalRevaluationArea	character	Reval.RevalRevaluationArea	Revaluation Area
tcRevalStatusCode	character	Reval.RevalStatusCode	Status

Internal usage

QadFinancials

method BRevaluationReport.Revaluation