business logic query YearClosingByCyYearID

Description

Year Closing By Company, Accounting Year, Year Closing ID

Parameters

iiCompanyId	integer	Company id
iiYearClosingAccountingYear	integer	Year Closing Accounting Year
iiYearClosingID	integer	YearClosingID
iiLayerID	integer

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 name	data type	db field	description
tiLayer_ID	integer	YearClosing.Layer_ID	Link to Layer
tiYearClosingAccountingYear	integer	YearClosing.YearClosingAccountingYear	GL Calendar Year
tlYearClosingIsTransPLToBal	logical	YearClosing.YearClosingIsTransPLToBal	Auto-Transfer Profit/Loss to BS
tlYearClosingIsInclDivision	logical	YearClosing.YearClosingIsInclDivision	Include Sub-Accounts
tcClosingPLGLCode	character	GL1.GLCode	A code identifying the GL account.
tcClosingPLDivGLCode	character	GL2.GLCode	A code identifying the GL account.
tcClosingBalanceGLCode	character	GL3.GLCode	A code identifying the GL account.
tcClosingBalanceDivGLCode	character	GL4.GLCode	A code identifying the GL account.
tcClosingTransferJournalCode	character	Journal3.JournalCode	A daybook code (maximum eight characters).
tcClosingPLJournalCode	character	Journal2.JournalCode	A daybook code (maximum eight characters).
tcClosingBalanceJournalCode	character	Journal1.JournalCode	A daybook code (maximum eight characters).
tiYearClosing_ID	integer	YearClosing.YearClosing_ID	Record ID
tiCompany_ID	integer	YearClosing.Company_ID	Link to Company
tiClosingPLGL_ID	integer	YearClosing.ClosingPLGL_ID	Profit/Loss Closing Account
tiClosingPLDivGL_ID	integer	YearClosing.ClosingPLDivGL_ID	Profit/Loss Closing Sub-Account
tiClosingBalanceGL_ID	integer	YearClosing.ClosingBalanceGL_ID	Balance Sheet Closing Account
tiClosingBalanceDivGL_ID	integer	YearClosing.ClosingBalanceDivGL_ID	Balance Sheet Closing Sub-Account
tiClosingTransferJournal_ID	integer	YearClosing.ClosingTransferJournal_ID	Automated Profit/Loss Transfer Daybook
tiClosingPLJournal_ID	integer	YearClosing.ClosingPLJournal_ID	Closing Profit/Loss Daybook
tiClosingBalanceJournal_ID	integer	YearClosing.ClosingBalanceJournal_ID	Closing Balance Daybook
ti_sequence	integer	calculated	primary index
tc_rowid	character	calculated	= 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