project QadFinancials > class BMfgItem > business logic query ItemForShelfLife
Description
Get Item shelf life given domain and part
Parameters
| icDomain | character | Domain |
| icPart | character | Part |
query condition
each pt_mstr where
pt_mstr.pt_domain = icDomain AND
pt_mstr.pt_part = icPart
query resultset tqItemForShelfLife
| field name | data type | db field | description |
|---|
| tcpt_domain | character | pt_mstr.pt_domain | Domain |
| tcpt_part | character | pt_mstr.pt_part | Item Number |
| tipt_shelflife | integer | pt_mstr.pt_shelflife | Shelf Life |
| ti_sequence | integer | calculated | primary index |
| tc_rowid | character | calculated | = rowid(pt_mstr) |
Internal usage
QadFinancials