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