project QadFinancials > class BMfgInventory > business logic query InventoryForCostingInfo
Parameters
| icDomain | character | |
| icSite | character | |
| icPart | character | |
query condition
each in_mstr where
in_mstr.in_domain = icDomain AND
in_mstr.in_site = icSite AND
in_mstr.in_part = icPart
first cs_mstr1 (outer-join) where
cs_mstr1.cs_domain = in_mstr.in_domain AND
cs_mstr1.cs_set = in_mstr.in_gl_set AND
first cs_mstr2 (outer-join) where
cs_mstr2.cs_domain = in_mstr.in_domain AND
cs_mstr2.cs_set = in_mstr.in_cur_set AND
query resultset tqInventoryForCostingInfo
| 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 |
| tcin_cur_set | character | in_mstr.in_cur_set | Current Cost Set |
| tcin_domain | character | in_mstr.in_domain | Domain |
| tcin_gl_set | character | in_mstr.in_gl_set | GL Cost Set |
| tcin_part | character | in_mstr.in_part | Item Number |
| tcin_site | character | in_mstr.in_site | Site |
| ti_sequence | integer | calculated | primary index |
| tc_rowid | character | calculated | = rowid(in_mstr),rowid(cs_mstr1),rowid(cs_mstr2) |
Internal usage
QadFinancials