project QadFinancials > class BExpenseGLMatrix > business logic query ExpenseGLMatrixByIDs


Parameters


iiCompanyIdintegerCompany id
iiCostCentreGL_IDinteger
iiEmployeeExpenseCode_IDinteger
iiItemExpenseCode_IDinteger
iiNoAnalysisGL_IDinteger
iiProjectGL_IDinteger
iiExpenseGLMatrix_IDinteger


query condition


  each ExpenseGLMatrix where
ExpenseGLMatrix.EmployeeExpenseCode_ID = iiEmployeeExpenseCode_ID AND
ExpenseGLMatrix.ItemExpenseCode_ID = iiItemExpenseCode_ID AND
ExpenseGLMatrix.NoAnalysisGL_ID = iiNoAnalysisGL_ID AND
ExpenseGLMatrix.ProjectGL_ID = iiProjectGL_ID AND
ExpenseGLMatrix.CostCentreGL_ID = iiCostCentreGL_ID AND
ExpenseGLMatrix.ExpenseGLMatrix_ID = iiExpenseGLMatrix_ID

      first ExpenseCode1 (outer-join) where
ExpenseCode1.ExpenseCode_ID = ExpenseGLMatrix.ItemExpenseCode_ID AND

      first ExpenseCode2 (inner-join) where
ExpenseCode2.ExpenseCode_ID = ExpenseGLMatrix.EmployeeExpenseCode_ID AND

      first GL1 (outer-join) where
GL1.SharedSet_Id = vi_GL_sharedset(iiCompanyId) AND
GL1.GL_ID = ExpenseGLMatrix.ProjectGL_ID AND

      first GL2 (outer-join) where
GL2.SharedSet_Id = vi_GL_sharedset(iiCompanyId) AND
GL2.GL_ID = ExpenseGLMatrix.CostCentreGL_ID AND

      first GL3 (outer-join) where
GL3.SharedSet_Id = vi_GL_sharedset(iiCompanyId) AND
GL3.GL_ID = ExpenseGLMatrix.NoAnalysisGL_ID AND


query resultset tqExpenseGLMatrixByIDs


field namedata typedb fielddescription
tiCostCentreGL_IDintegerExpenseGLMatrix.CostCentreGL_IDExpense Acc (CC)
tcCostCentreGLCodecharacterGL2.GLCodeA code identifying the GL account.
tcEmployeeExpenseCodecharacterExpenseCode2.ExpenseCodeExpense Code
tiEmployeeExpenseCode_IDintegerExpenseGLMatrix.EmployeeExpenseCode_IDEmployee Expense Code
tiExpenseGLMatrix_IDintegerExpenseGLMatrix.ExpenseGLMatrix_IDRecord ID
tcItemExpenseCodecharacterExpenseCode1.ExpenseCodeExpense Code
tiItemExpenseCode_IDintegerExpenseGLMatrix.ItemExpenseCode_IDItem Expense Code
tiNoAnalysisGL_IDintegerExpenseGLMatrix.NoAnalysisGL_IDExpense Account (No Analysis)
tcNoAnalysisGLCodecharacterGL3.GLCodeA code identifying the GL account.
tiProjectGL_IDintegerExpenseGLMatrix.ProjectGL_IDExpense Acc (Prj)
tcProjectGLCodecharacterGL1.GLCodeA code identifying the GL account.
tiSharedSet_IDintegerExpenseGLMatrix.SharedSet_IDLink to SharedSet


Internal usage


QadFinancials
method BExpenseGLMatrix.ApiGetMissingOnes
method BExpenseGLMatrix.ApiSetExpenseGLMatrix