project QadFinancials > class BMfgSite > business logic query SiteForInventoryStatusLoc
Description
Returns status given site
Parameters
| icDomain | character | Domain |
| icSite | character | Site |
query condition
each si_mstr where
si_mstr.si_domain = icDomain AND
si_mstr.si_site = icSite
first is_mstr (inner-join) where
is_mstr.is_domain = si_mstr.si_domain AND
is_mstr.is_status = si_mstr.si_status AND
query resultset tqSiteForInventoryStatusLoc
| field name | data type | db field | description |
|---|
| tcis__qadc01 | character | is_mstr.is__qadc01 | |
| tlis_avail | logical | is_mstr.is_avail | Available |
| tiis_cmtindx | integer | is_mstr.is_cmtindx | Comment Index |
| tcis_desc | character | is_mstr.is_desc | Description |
| tcis_domain | character | is_mstr.is_domain | Domain |
| tcis_fail_status | character | is_mstr.is_fail_status | Fail Status |
| tlis_frozen | logical | is_mstr.is_frozen | Frozen |
| ttis_mod_date | date | is_mstr.is_mod_date | Modified Date |
| tlis_nettable | logical | is_mstr.is_nettable | Nettable |
| tlis_overissue | logical | is_mstr.is_overissue | Overissue |
| tcis_status | character | is_mstr.is_status | Status Code |
| tcis_user1 | character | is_mstr.is_user1 | Ufld1 |
| tcis_user2 | character | is_mstr.is_user2 | Ufld2 |
| tcis_userid | character | is_mstr.is_userid | User ID |
| tdoid_is_mstr | decimal | is_mstr.oid_is_mstr | |
| tcsi_domain | character | si_mstr.si_domain | Domain |
| tcsi_site | character | si_mstr.si_site | Site |
| tcsi_status | character | si_mstr.si_status | Default Inventory Status |
| ti_sequence | integer | calculated | primary index |
| tc_rowid | character | calculated | = rowid(si_mstr),rowid(is_mstr) |
Internal usage
QadFinancials