project QadFinancials > class BMfgInventoryControl > business logic query InventoryControlCostsByDomain
Parameters
query condition
each icc_ctrl where
icc_ctrl.icc_domain = icDomain
first cs_mstr1 (outer-join) where
cs_mstr1.cs_domain = icc_ctrl.icc_domain AND
cs_mstr1.cs_set = icc_ctrl.icc_gl_set AND
first cs_mstr2 (outer-join) where
cs_mstr2.cs_domain = icc_ctrl.icc_domain AND
cs_mstr2.cs_set = icc_ctrl.icc_cur_set AND
query resultset tqInventoryControlCostsByDomain
| field name | data type | db field | description |
|---|
| tccurrent_cs_method | character | cs_mstr2.cs_method | Costing Method |
| tcgl_cs_method | character | cs_mstr1.cs_method | Costing Method |
| tlicc_cur_ap | logical | icc_ctrl.icc_cur_ap | Current Cost from AP |
| tcicc_cur_set | character | icc_ctrl.icc_cur_set | Default Current Cost Set |
| tcicc_domain | character | icc_ctrl.icc_domain | Domain |
| tcicc_gl_set | character | icc_ctrl.icc_gl_set | Default GL Cost Set |
| tcicc_site | character | icc_ctrl.icc_site | Default Site |
| ti_sequence | integer | calculated | primary index |
| tc_rowid | character | calculated | = rowid(icc_ctrl),rowid(cs_mstr1),rowid(cs_mstr2) |
Internal usage
QadFinancials