project QadFinancials > class BQBudgetActual > business logic query QBudgetLinkActualByAll
Description
query on QBudgetLinkActual that returns all
Parameters
iiCompanyId | integer | Company id |
iiDaemonId | integer | |
iiBudgetID | integer | |
query condition
each QBudgetLinkActual where
QBudgetLinkActual.Company_Id = iiCompanyId AND
QBudgetLinkActual.Budget_ID = iiBudgetID
each fcDaemonQueue (outer-join) where
fcDaemonQueue.DaemonQueueRef = string(QBudgetLinkActual.QBudgetLinkActual_ID) AND
fcDaemonQueue.DaemonId = iiDaemonId
query resultset tqQBudgetLinkActualByAll
field name | data type | db field | description |
tcBudgetLinkActualInfo | character | QBudgetLinkActual.BudgetLinkActualInfo | Reference |
tiCompany_ID | integer | QBudgetLinkActual.Company_ID | Link to Company |
tiDaemonId | integer | fcDaemonQueue.DaemonId | Daemon ID |
tiDaemonQueueId | integer | fcDaemonQueue.DaemonQueueId | identifier |
tiQBudgetLinkActual_ID | integer | QBudgetLinkActual.QBudgetLinkActual_ID | Record ID |
Internal usage
QadFinancials