project QadFinancials > class BBudget > business logic query BudgetCompanyByBudgetID
Description
BudgetCompanyByBudgetID
Parameters
| iiCompanyId | integer | Company id |
| iiBudgetID | integer | Budget ID |
query condition
each BudgetCompany where
BudgetCompany.Company_Id = iiCompanyId AND
BudgetCompany.Budget_ID = iiBudgetID
first Company (inner-join) where
Company.Company_Id = iiCompanyId AND
Company.Company_ID = BudgetCompany.Company_ID AND
query resultset tqBudgetCompanyByBudgetID
| field name | data type | db field | description |
|---|
| tiBudget_ID | integer | BudgetCompany.Budget_ID | Link to Budget |
| tiBudgetCompany_ID | integer | BudgetCompany.BudgetCompany_ID | Record ID |
| tiCompany_ID | integer | BudgetCompany.Company_ID | Link to Company |
| tcCompanyCode | character | Company.CompanyCode | Entity Code |
Internal usage
QadFinancials