project QadFinancials > class BMfgCosting > business logic query CostSimulationByCostSetPartSt
Description
Get costing details
Parameters
| icDomain | character | |
| icSite | character | |
| icPart | character | |
| icCostSet | character | |
query condition
each sct_det where
sct_det.sct_domain = icDomain AND
sct_det.sct_sim = icCostSet AND
sct_det.sct_part = icPart AND
sct_det.sct_site = icSite
query resultset tqCostSimulationByCostSetPartSt
| field name | data type | db field | description |
|---|
| tdsct_cst_tot | decimal | sct_det.sct_cst_tot | Cost Total |
| tcsct_domain | character | sct_det.sct_domain | Domain |
| tdsct_mtl_tl | decimal | sct_det.sct_mtl_tl | Material |
| tcsct_part | character | sct_det.sct_part | Item Number |
| tcsct_sim | character | sct_det.sct_sim | Cost Set |
| tcsct_site | character | sct_det.sct_site | Site |
Internal usage
QadFinancials