project QadFinancials > class BExpenseGLMatrix > business logic query ExpenseGLMatrixByExpenseInfo
Parameters
| icEmployeeExpenseCode | character | |
| iiEmployeeExpenseCode_ID | integer | |
| icItemExpenseCode | character | |
| iiItemExpenseCode_ID | integer | |
| iiCompanyId | integer | Company id |
query condition
each ExpenseGLMatrix where
ExpenseGLMatrix.EmployeeExpenseCode_ID = iiEmployeeExpenseCode_ID AND
ExpenseGLMatrix.ItemExpenseCode_ID = iiItemExpenseCode_ID
first ExpenseCode1 (inner-join) where
ExpenseCode1.ExpenseCode_ID = ExpenseGLMatrix.EmployeeExpenseCode_ID AND
ExpenseCode1.ExpenseCode matches icEmployeeExpenseCode
first ExpenseCode2 (conditional-join) where
ExpenseCode2.ExpenseCode_ID = ExpenseGLMatrix.ItemExpenseCode_ID AND
ExpenseCode2.ExpenseCode matches icItemExpenseCode
first GL1 (conditional-join) where
GL1.SharedSet_Id = vi_GL_sharedset(iiCompanyId) AND
GL1.GL_ID = ExpenseGLMatrix.ProjectGL_ID AND
first GL2 (conditional-join) where
GL2.SharedSet_Id = vi_GL_sharedset(iiCompanyId) AND
GL2.GL_ID = ExpenseGLMatrix.CostCentreGL_ID AND
first GL3 (conditional-join) where
GL3.SharedSet_Id = vi_GL_sharedset(iiCompanyId) AND
GL3.GL_ID = ExpenseGLMatrix.NoAnalysisGL_ID AND
query resultset tqExpenseGLMatrixByExpenseInfo
| 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 | ExpenseCode1.ExpenseCode | Expense Code |
| tiEmployeeExpenseCode_ID | integer | ExpenseGLMatrix.EmployeeExpenseCode_ID | Employee Expense Code |
| tiExpenseGLMatrix_ID | integer | ExpenseGLMatrix.ExpenseGLMatrix_ID | Record ID |
| tcItemExpenseCode | character | ExpenseCode2.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. |
Internal usage
QadFinancials