project QadFinancials > class BMfgBudget > business logic query MfgBudgetForBudgetCodeCheck
Description
Select Query to return a budget code for a budget in a given domain from the bg_mstr table.
Parameters
| icMfgBudgetCode | character | Input parameter for the MFg Budget Code. |
| icDomainCode | character | Input parameter corresponding to the domain code. |
query condition
each bg_mstr where
bg_mstr.bg_code = icMfgBudgetCode AND
bg_mstr.bg_domain = icDomainCode
query resultset tqMfgBudgetForBudgetCodeCheck
| field name | data type | db field | description |
|---|
| tcbg_code | character | bg_mstr.bg_code | Budget Code |
| tcbg_domain | character | bg_mstr.bg_domain | Domain |
| ti_sequence | integer | calculated | primary index |
| tc_rowid | character | calculated | = rowid(bg_mstr) |
Internal usage
QadFinancials