business logic query DeductionCatLineForExcelInteg

Parameters

iiCompanyId

integer

Company id

each DeductionCatLine where

first CostCentre (outer-join) where

CostCentre.SharedSet_Id = vi_COSTCENTRE_sharedset(iiCompanyId) AND
CostCentre.CostCentre_ID = DeductionCatLine.CostCentre_ID AND

first Division (outer-join) where

Division.SharedSet_Id = vi_DIVISION_sharedset(iiCompanyId) AND
Division.Division_ID = DeductionCatLine.Division_ID AND

first Domains (inner-join) where

Domains.Domain_ID = DeductionCatLine.Domain_ID AND

first GL (outer-join) where

GL.SharedSet_Id = vi_GL_sharedset(iiCompanyId) AND
GL.GL_ID = DeductionCatLine.GL_ID AND

first Journal1 (outer-join) where

Journal1.SharedSet_Id = vi_JOURNAL_sharedset(iiCompanyId) AND
Journal1.Journal_ID = DeductionCatLine.ExpenseJournal_ID AND

first Journal2 (outer-join) where

Journal2.SharedSet_Id = vi_JOURNAL_sharedset(iiCompanyId) AND
Journal2.Journal_ID = DeductionCatLine.RechargeJournal_ID AND

field name	data type	db field	description
tiCostCentre_ID	integer	DeductionCatLine.CostCentre_ID	Link to CostCentre
tcCostCentreCode	character	CostCentre.CostCentreCode	Cost Center: A code that identifies the cost center.
tiDeductionCat_ID	integer	DeductionCatLine.DeductionCat_ID	Link to DeductionCat
tiDeductionCatLine_ID	integer	DeductionCatLine.DeductionCatLine_ID	Record ID
tlDeductionCatLineIsAutoWOff	logical	DeductionCatLine.DeductionCatLineIsAutoWOff	Auto Write-off
tdDeductionCatLineWOffLimit	decimal	DeductionCatLine.DeductionCatLineWOffLimit	Write-off Limit
tiDivision_ID	integer	DeductionCatLine.Division_ID	Link to Division
tcDivisionCode	character	Division.DivisionCode	Sub-Account
tiDomain_ID	integer	DeductionCatLine.Domain_ID	Link to Doamin
tcDomainCode	character	Domains.DomainCode	Domain
tiExpenseJournal_ID	integer	DeductionCatLine.ExpenseJournal_ID	Link to ExpenseJournal
tiGL_ID	integer	DeductionCatLine.GL_ID	Link to GL
tcGLCode	character	GL.GLCode	A code identifying the GL account.
tcJournalCode	character	Journal1.JournalCode	A daybook code (maximum eight characters).
tcJournalCode1	character	Journal2.JournalCode	A daybook code (maximum eight characters).
tiRechargeJournal_ID	integer	DeductionCatLine.RechargeJournal_ID	Link to RechargeJournal
tiSafStructure_ID	integer	DeductionCatLine.SafStructure_ID	Link to SafStructure
ti_sequence	integer	calculated	primary index
tc_rowid	character	calculated	= rowid(DeductionCatLine),rowid(CostCentre),rowid(Division),rowid(Domains),rowid(GL),rowid(Journal1),rowid(Journal2)

QadFinancials