Parameters
| iiCompanyId | integer | Company id |
| iiGrossIncAccID | integer | |
| icSalesGLCode | character | |
| icSalesDivisionCode | character | |
| icSalesCostCentreCode | character | |
| icSalesProjectCode | character | |
| icTaxPayableGLCode | character | |
| icTaxPayableDivisionCode | character | |
| iiSalesGLID | integer | |
| iiSalesDivisionID | integer | |
| iiSalesCostCentreID | integer | |
| iiSalesProjectID | integer | |
| iiTaxPayableGLID | integer | |
| iiTaxPayableDivisionID | integer | |
query condition
each GrossIncAcc where
GrossIncAcc.GrossIncAcc_ID = iiGrossIncAccID AND
GrossIncAcc.Company_ID = iiCompanyId AND
GrossIncAcc.SalesGL_ID = iiSalesGLID AND
GrossIncAcc.SalesDivision_ID = iiSalesDivisionID AND
GrossIncAcc.SalesCostCentre_ID = iiSalesCostCentreID AND
GrossIncAcc.SalesProject_ID = iiSalesProjectID AND
GrossIncAcc.TaxPayableGL_ID = iiTaxPayableGLID AND
GrossIncAcc.TaxPayableDivision_ID = iiTaxPayableDivisionID
first CostCentre (conditional-join) where
CostCentre.SharedSet_Id = vi_COSTCENTRE_sharedset(iiCompanyId) AND
CostCentre.CostCentre_ID = GrossIncAcc.SalesCostCentre_ID AND
CostCentre.CostCentreCode = icSalesCostCentreCode
first Division1 (conditional-join) where
Division1.SharedSet_Id = vi_DIVISION_sharedset(iiCompanyId) AND
Division1.Division_ID = GrossIncAcc.SalesDivision_ID AND
Division1.DivisionCode = icSalesDivisionCode
first Division2 (conditional-join) where
Division2.SharedSet_Id = vi_DIVISION_sharedset(iiCompanyId) AND
Division2.Division_ID = GrossIncAcc.TaxPayableDivision_ID AND
Division2.DivisionCode = icTaxPayableDivisionCode
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 Project (conditional-join) where
Project.SharedSet_Id = vi_PROJECT_sharedset(iiCompanyId) AND
Project.Project_ID = GrossIncAcc.SalesProject_ID AND
Project.ProjectCode = icSalesProjectCode
query sort order
GrossIncAcc.Company_ID (ascending)
GL1.SalesGLCode (ascending)
Division1.SalesDivisionCode (ascending)
CostCentre.SalesCostCentreCode (ascending)
Project.SalesProjectCode (ascending)
query resultset tqGrossIncAccPrim
| field name | data type | db field | description |
|---|
| tiCompany_ID | integer | GrossIncAcc.Company_ID | Link to Company |
| tiGrossIncAcc_ID | integer | GrossIncAcc.GrossIncAcc_ID | Record ID |
| tiSalesGL_ID | integer | GrossIncAcc.SalesGL_ID | Link To GL (Sales) |
| tiSalesDivision_ID | integer | GrossIncAcc.SalesDivision_ID | Link To Division (Sales) |
| tiSalesCostCentre_ID | integer | GrossIncAcc.SalesCostCentre_ID | Link To CostCentre (Sales) |
| tiSalesProject_ID | integer | GrossIncAcc.SalesProject_ID | Link To Project (Sales) |
| tiTaxPayableGL_ID | integer | GrossIncAcc.TaxPayableGL_ID | Link To GL (Tax Payable) |
| tiTaxPayableDivision_ID | integer | GrossIncAcc.TaxPayableDivision_ID | Link To Division (Tax Payable) |
| tcSalesGLCode | character | GL1.GLCode | A code identifying the GL account. |
| tcSalesDivisionCode | character | Division1.DivisionCode | Sub-Account |
| tcSalesCostCentreCode | character | CostCentre.CostCentreCode | Cost Center: A code that identifies the cost center. |
| tcSalesProjectCode | character | Project.ProjectCode | Project |
| tcTaxPayableGLCode | character | GL2.GLCode | A code identifying the GL account. |
| tcTaxPayableDivisionCode | character | Division2.DivisionCode | Sub-Account |
Internal usage
QadFinancials