project QadFinancials > class BYearClosing > business logic query YearClosingPrim

Description

YearClosingPrim


Parameters


iiCompanyIdintegerCompany id
iiYearClosingIDintegerYearClosingID
iiYearClosingAccountingYearintegerYearClosingAccountingYear


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 namedata typedb fielddescription
tiYearClosing_IDintegerYearClosing.YearClosing_IDRecord ID
tiCompany_IDintegerYearClosing.Company_IDLink to Company
tiYearClosingAccountingYearintegerYearClosing.YearClosingAccountingYearGL Calendar Year
ti_sequenceintegercalculatedprimary index
tc_rowidcharactercalculated = rowid(YearClosing)


Internal usage


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