project QadFinancials > class BExpenseGLMatrix > business logic query ExpenseGLMatrixByIDs
Parameters
| iiCompanyId | integer | Company id |
| iiCostCentreGL_ID | integer | |
| iiEmployeeExpenseCode_ID | integer | |
| iiItemExpenseCode_ID | integer | |
| iiNoAnalysisGL_ID | integer | |
| iiProjectGL_ID | integer | |
| iiExpenseGLMatrix_ID | integer | |
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 name | data type | db field | description |
|---|
| tiCostCentreGL_ID | integer | ExpenseGLMatrix.CostCentreGL_ID | Expense Acc (CC) |
| tcCostCentreGLCode | character | GL2.GLCode | A code identifying the GL account. |
| tcEmployeeExpenseCode | character | ExpenseCode2.ExpenseCode | Expense Code |
| tiEmployeeExpenseCode_ID | integer | ExpenseGLMatrix.EmployeeExpenseCode_ID | Employee Expense Code |
| tiExpenseGLMatrix_ID | integer | ExpenseGLMatrix.ExpenseGLMatrix_ID | Record ID |
| tcItemExpenseCode | character | ExpenseCode1.ExpenseCode | Expense Code |
| tiItemExpenseCode_ID | integer | ExpenseGLMatrix.ItemExpenseCode_ID | Item Expense Code |
| tiNoAnalysisGL_ID | integer | ExpenseGLMatrix.NoAnalysisGL_ID | Expense Account (No Analysis) |
| tcNoAnalysisGLCode | character | GL3.GLCode | A code identifying the GL account. |
| tiProjectGL_ID | integer | ExpenseGLMatrix.ProjectGL_ID | Expense Acc (Prj) |
| tcProjectGLCode | character | GL1.GLCode | A code identifying the GL account. |
| tiSharedSet_ID | integer | ExpenseGLMatrix.SharedSet_ID | Link to SharedSet |
Internal usage
QadFinancials