business logic query GrossIncAccForAllFields

Parameters

iiCompanyId	integer	Company id
iiGrossIncAccId	integer
iiSalesGLId	integer
icSalesGLCode	character
iiSalesDivisionId	integer
icSalesDivisionCode	character
iiSalesCostCentreId	integer
icSalesCostCentreCode	character
iiSalesProjectId	integer
icSalesProjectCode	character
iiTaxPayableGLId	integer
icTaxPayableGLCode	character
iiTaxPayableDivisionId	integer
icTaxPayableDivisionCode	character

query condition

each GrossIncAcc where

GrossIncAcc.Company_Id = iiCompanyId AND
GrossIncAcc.GrossIncAcc_ID = iiGrossIncAccId AND
GrossIncAcc.SalesGL_ID = iiSalesGLId AND
GrossIncAcc.SalesDivision_ID = iiSalesDivisionId AND
GrossIncAcc.SalesCostCentre_ID = iiSalesCostCentreId AND
GrossIncAcc.TaxPayableGL_ID = iiTaxPayableGLId AND
GrossIncAcc.TaxPayableDivision_ID = iiTaxPayableDivisionId AND
GrossIncAcc.SalesProject_ID = iiSalesProjectId

first CostCentre1 (conditional-join) where

CostCentre1.SharedSet_Id = vi_COSTCENTRE_sharedset(iiCompanyId) AND
CostCentre1.CostCentre_ID = GrossIncAcc.SalesCostCentre_ID AND
CostCentre1.CostCentreCode = icSalesCostCentreCode

first CostCentre2 (conditional-join) where

CostCentre2.SharedSet_Id = vi_COSTCENTRE_sharedset(iiCompanyId) AND
CostCentre2.CostCentre_ID = GrossIncAcc.TaxExpenseCostCentre_ID AND

first Division2 (conditional-join) where

Division2.SharedSet_Id = vi_DIVISION_sharedset(iiCompanyId) AND
Division2.Division_ID = GrossIncAcc.TaxPayableDivision_ID AND
Division2.DivisionCode = icTaxPayableDivisionCode

first Division1 (conditional-join) where

Division1.SharedSet_Id = vi_DIVISION_sharedset(iiCompanyId) AND
Division1.Division_ID = GrossIncAcc.SalesDivision_ID AND
Division1.DivisionCode = icSalesDivisionCode

first Division3 (conditional-join) where

Division3.SharedSet_Id = vi_DIVISION_sharedset(iiCompanyId) AND
Division3.Division_ID = GrossIncAcc.TaxExpenseDivision_ID AND

first GL1 (inner-join) where

GL1.SharedSet_Id = vi_GL_sharedset(iiCompanyId) AND
GL1.GL_ID = GrossIncAcc.SalesGL_ID AND
GL1.GLCode = icSalesGLCode

first GL2 (inner-join) where

GL2.SharedSet_Id = vi_GL_sharedset(iiCompanyId) AND
GL2.GL_ID = GrossIncAcc.TaxPayableGL_ID AND
GL2.GLCode = icTaxPayableGLCode

first GL3 (inner-join) where

GL3.SharedSet_Id = vi_GL_sharedset(iiCompanyId) AND
GL3.GL_ID = GrossIncAcc.TaxExpenseGL_ID AND

first Journal (inner-join) where

Journal.SharedSet_Id = vi_JOURNAL_sharedset(iiCompanyId) AND
Journal.Journal_ID = GrossIncAcc.Journal_ID AND

first Project1 (conditional-join) where

Project1.SharedSet_Id = vi_PROJECT_sharedset(iiCompanyId) AND
Project1.Project_ID = GrossIncAcc.SalesProject_ID AND
Project1.ProjectCode = icSalesProjectCode

first Project2 (conditional-join) where

Project2.SharedSet_Id = vi_PROJECT_sharedset(iiCompanyId) AND
Project2.Project_ID = GrossIncAcc.TaxExpenseProject_ID AND

query sort order

GrossIncAcc.Company_ID (ascending)
GL1.SalesGLCode (ascending)
Division1.SalesDivisionCode (ascending)
CostCentre1.SalesCostCentreCode (ascending)
Project1.SalesProjectCode (ascending)

query resultset tqGrossIncAccForAllFields

field name	data type	db field	description
tcJournalCode	character	Journal.JournalCode	A daybook code (maximum eight characters).
tiJournal_ID	integer	GrossIncAcc.Journal_ID	Link To Journal
tiCompany_ID	integer	GrossIncAcc.Company_ID	Link to Company
tiGrossIncAcc_ID	integer	GrossIncAcc.GrossIncAcc_ID	Record ID
tiSalesCostCentre_ID	integer	GrossIncAcc.SalesCostCentre_ID	Link To CostCentre (Sales)
tiSalesDivision_ID	integer	GrossIncAcc.SalesDivision_ID	Link To Division (Sales)
tiSalesGL_ID	integer	GrossIncAcc.SalesGL_ID	Link To GL (Sales)
tiSalesProject_ID	integer	GrossIncAcc.SalesProject_ID	Link To Project (Sales)
tiTaxExpenseCostCentre_ID	integer	GrossIncAcc.TaxExpenseCostCentre_ID	Link To CostCentre (Tax Expense)
tiTaxExpenseDivision_ID	integer	GrossIncAcc.TaxExpenseDivision_ID	Link To Division (Tax Expense)
tiTaxExpenseGL_ID	integer	GrossIncAcc.TaxExpenseGL_ID	Link To GL (Tax Expense)
tiTaxExpenseProject_ID	integer	GrossIncAcc.TaxExpenseProject_ID	Link To Project (Tax Expense)
tiTaxPayableDivision_ID	integer	GrossIncAcc.TaxPayableDivision_ID	Link To Division (Tax Payable)
tiTaxPayableGL_ID	integer	GrossIncAcc.TaxPayableGL_ID	Link To GL (Tax Payable)
tlGrossIncAccIsAllCostCentre	logical	GrossIncAcc.GrossIncAccIsAllCostCentre	All Cost Centers
tlGrossIncAccIsAllDivision	logical	GrossIncAcc.GrossIncAccIsAllDivision	All Sub-Accounts
tlGrossIncAccIsAllProject	logical	GrossIncAcc.GrossIncAccIsAllProject	All Projects
tcSalesGLCode	character	GL1.GLCode	A code identifying the GL account.
tcSalesDivisionCode	character	Division1.DivisionCode	Sub-Account
tcSalesCostCentreCode	character	CostCentre1.CostCentreCode	Cost Center: A code that identifies the cost center.
tcSalesProjectCode	character	Project1.ProjectCode	Project
tcTaxPayableGLCode	character	GL2.GLCode	A code identifying the GL account.
tcTaxPayableDivisionCode	character	Division2.DivisionCode	Sub-Account
tcTaxExpenseGLCode	character	GL3.GLCode	A code identifying the GL account.
tcTaxExpenseDivisionCode	character	Division3.DivisionCode	Sub-Account
tcTaxExpenseCostCentreCode	character	CostCentre2.CostCentreCode	Cost Center: A code that identifies the cost center.
tcTaxExpenseProjectCode	character	Project2.ProjectCode	Project
ti_sequence	integer	calculated	primary index
tc_rowid	character	calculated	= rowid(GrossIncAcc),rowid(CostCentre1),rowid(CostCentre2),rowid(Division2),rowid(Division1),rowid(Division3),rowid(GL1),rowid(GL2),rowid(GL3),rowid(Journal),rowid(Project1),rowid(Project2)

Internal usage

QadFinancials

method BGrossIncomeAccounting.ApiGetGIAMapping
method BGrossIncomeAccounting.ApiLoadGrossIncAcc