project QadFinancials > class BYearClosing > business logic query YearClosingByCyYearID

Description

Year Closing By Company, Accounting Year, Year Closing ID


Parameters


iiCompanyIdintegerCompany id
iiYearClosingAccountingYearintegerYear Closing Accounting Year
iiYearClosingIDintegerYearClosingID
iiLayerIDinteger


query condition


  each YearClosing where
YearClosing.Company_Id = iiCompanyId AND
YearClosing.YearClosing_ID = iiYearClosingID AND
YearClosing.YearClosingAccountingYear = iiYearClosingAccountingYear AND
YearClosing.Layer_ID = iiLayerID

      first GL1 (conditional-join) where
GL1.SharedSet_Id = vi_GL_sharedset(iiCompanyId) AND
GL1.GL_ID = YearClosing.ClosingPLGL_ID AND

      first GL2 (conditional-join) where
GL2.SharedSet_Id = vi_GL_sharedset(iiCompanyId) AND
GL2.GL_ID = YearClosing.ClosingPLDivGL_ID AND

      first GL3 (conditional-join) where
GL3.SharedSet_Id = vi_GL_sharedset(iiCompanyId) AND
GL3.GL_ID = YearClosing.ClosingBalanceGL_ID AND

      first GL4 (conditional-join) where
GL4.SharedSet_Id = vi_GL_sharedset(iiCompanyId) AND
GL4.GL_ID = YearClosing.ClosingBalanceDivGL_ID AND

      first Journal1 (inner-join) where
Journal1.SharedSet_Id = vi_JOURNAL_sharedset(iiCompanyId) AND
Journal1.Journal_ID = YearClosing.ClosingBalanceJournal_ID AND

      first Journal2 (inner-join) where
Journal2.SharedSet_Id = vi_JOURNAL_sharedset(iiCompanyId) AND
Journal2.Journal_ID = YearClosing.ClosingPLJournal_ID AND

      first Journal3 (conditional-join) where
Journal3.SharedSet_Id = vi_JOURNAL_sharedset(iiCompanyId) AND
Journal3.Journal_ID = YearClosing.ClosingTransferJournal_ID AND


query sort order


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


query resultset tqYearClosingByCyYearID


field namedata typedb fielddescription
tiLayer_IDintegerYearClosing.Layer_IDLink to Layer
tiYearClosingAccountingYearintegerYearClosing.YearClosingAccountingYearGL Calendar Year
tlYearClosingIsTransPLToBallogicalYearClosing.YearClosingIsTransPLToBalAuto-Transfer Profit/Loss to BS
tlYearClosingIsInclDivisionlogicalYearClosing.YearClosingIsInclDivisionInclude Sub-Accounts
tcClosingPLGLCodecharacterGL1.GLCodeA code identifying the GL account.
tcClosingPLDivGLCodecharacterGL2.GLCodeA code identifying the GL account.
tcClosingBalanceGLCodecharacterGL3.GLCodeA code identifying the GL account.
tcClosingBalanceDivGLCodecharacterGL4.GLCodeA code identifying the GL account.
tcClosingTransferJournalCodecharacterJournal3.JournalCodeA daybook code (maximum eight characters).
tcClosingPLJournalCodecharacterJournal2.JournalCodeA daybook code (maximum eight characters).
tcClosingBalanceJournalCodecharacterJournal1.JournalCodeA daybook code (maximum eight characters).
tiYearClosing_IDintegerYearClosing.YearClosing_IDRecord ID
tiCompany_IDintegerYearClosing.Company_IDLink to Company
tiClosingPLGL_IDintegerYearClosing.ClosingPLGL_IDProfit/Loss Closing Account
tiClosingPLDivGL_IDintegerYearClosing.ClosingPLDivGL_IDProfit/Loss Closing Sub-Account
tiClosingBalanceGL_IDintegerYearClosing.ClosingBalanceGL_IDBalance Sheet Closing Account
tiClosingBalanceDivGL_IDintegerYearClosing.ClosingBalanceDivGL_IDBalance Sheet Closing Sub-Account
tiClosingTransferJournal_IDintegerYearClosing.ClosingTransferJournal_IDAutomated Profit/Loss Transfer Daybook
tiClosingPLJournal_IDintegerYearClosing.ClosingPLJournal_IDClosing Profit/Loss Daybook
tiClosingBalanceJournal_IDintegerYearClosing.ClosingBalanceJournal_IDClosing Balance Daybook
ti_sequenceintegercalculatedprimary index
tc_rowidcharactercalculated = rowid(YearClosing),rowid(GL1),rowid(GL2),rowid(GL3),rowid(GL4),rowid(Journal1),rowid(Journal2),rowid(Journal3)


Internal usage


QadFinancials
method BYearClosing.ValidateComponentAll
method BYearClosing.DefaultValuesLayer