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