business logic query YearClosingPrim

Description

YearClosingPrim

Parameters

iiCompanyId	integer	Company id
iiYearClosingID	integer	YearClosingID
iiYearClosingAccountingYear	integer	YearClosingAccountingYear

query condition

each YearClosing where

YearClosing.Company_Id = iiCompanyId AND
YearClosing.YearClosing_ID = iiYearClosingID AND
YearClosing.YearClosingAccountingYear = iiYearClosingAccountingYear

query sort order

YearClosing.Company_ID (ascending)
YearClosing.YearClosingAccountingYear (ascending)

query resultset tqYearClosingPrim

field name	data type	db field	description
tiYearClosing_ID	integer	YearClosing.YearClosing_ID	Record ID
tiCompany_ID	integer	YearClosing.Company_ID	Link to Company
tiYearClosingAccountingYear	integer	YearClosing.YearClosingAccountingYear	GL Calendar Year
ti_sequence	integer	calculated	primary index
tc_rowid	character	calculated	= rowid(YearClosing)

Internal usage

QadFinancials

method BGL.TrialBalanceGroup
method BGLReport.CalMeasureActualsForBSGL
method BGLReport.CalMeasureActualsForMultiColBSGL
method BYearClosing.ApiStdMaintainTT