project QadFinancials > class BGrossIncomeAccounting > business logic query GrossIncAccForAllFields


Parameters


iiCompanyIdintegerCompany id
iiGrossIncAccIdinteger
iiSalesGLIdinteger
icSalesGLCodecharacter
iiSalesDivisionIdinteger
icSalesDivisionCodecharacter
iiSalesCostCentreIdinteger
icSalesCostCentreCodecharacter
iiSalesProjectIdinteger
icSalesProjectCodecharacter
iiTaxPayableGLIdinteger
icTaxPayableGLCodecharacter
iiTaxPayableDivisionIdinteger
icTaxPayableDivisionCodecharacter


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 namedata typedb fielddescription
tcJournalCodecharacterJournal.JournalCodeA daybook code (maximum eight characters).
tiJournal_IDintegerGrossIncAcc.Journal_IDLink To Journal
tiCompany_IDintegerGrossIncAcc.Company_IDLink to Company
tiGrossIncAcc_IDintegerGrossIncAcc.GrossIncAcc_IDRecord ID
tiSalesCostCentre_IDintegerGrossIncAcc.SalesCostCentre_IDLink To CostCentre (Sales)
tiSalesDivision_IDintegerGrossIncAcc.SalesDivision_IDLink To Division (Sales)
tiSalesGL_IDintegerGrossIncAcc.SalesGL_IDLink To GL (Sales)
tiSalesProject_IDintegerGrossIncAcc.SalesProject_IDLink To Project (Sales)
tiTaxExpenseCostCentre_IDintegerGrossIncAcc.TaxExpenseCostCentre_IDLink To CostCentre (Tax Expense)
tiTaxExpenseDivision_IDintegerGrossIncAcc.TaxExpenseDivision_IDLink To Division (Tax Expense)
tiTaxExpenseGL_IDintegerGrossIncAcc.TaxExpenseGL_IDLink To GL (Tax Expense)
tiTaxExpenseProject_IDintegerGrossIncAcc.TaxExpenseProject_IDLink To Project (Tax Expense)
tiTaxPayableDivision_IDintegerGrossIncAcc.TaxPayableDivision_IDLink To Division (Tax Payable)
tiTaxPayableGL_IDintegerGrossIncAcc.TaxPayableGL_IDLink To GL (Tax Payable)
tlGrossIncAccIsAllCostCentrelogicalGrossIncAcc.GrossIncAccIsAllCostCentreAll Cost Centers
tlGrossIncAccIsAllDivisionlogicalGrossIncAcc.GrossIncAccIsAllDivisionAll Sub-Accounts
tlGrossIncAccIsAllProjectlogicalGrossIncAcc.GrossIncAccIsAllProjectAll Projects
tcSalesGLCodecharacterGL1.GLCodeA code identifying the GL account.
tcSalesDivisionCodecharacterDivision1.DivisionCodeSub-Account
tcSalesCostCentreCodecharacterCostCentre1.CostCentreCodeCost Center: A code that identifies the cost center.
tcSalesProjectCodecharacterProject1.ProjectCodeProject
tcTaxPayableGLCodecharacterGL2.GLCodeA code identifying the GL account.
tcTaxPayableDivisionCodecharacterDivision2.DivisionCodeSub-Account
tcTaxExpenseGLCodecharacterGL3.GLCodeA code identifying the GL account.
tcTaxExpenseDivisionCodecharacterDivision3.DivisionCodeSub-Account
tcTaxExpenseCostCentreCodecharacterCostCentre2.CostCentreCodeCost Center: A code that identifies the cost center.
tcTaxExpenseProjectCodecharacterProject2.ProjectCodeProject
ti_sequenceintegercalculatedprimary index
tc_rowidcharactercalculated = 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