project QadFinancials > class BMfgSite > business logic query SiteForInventoryStatusLoc

Description

Returns status given site


Parameters


icDomaincharacterDomain
icSitecharacterSite


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 namedata typedb fielddescription
tcis__qadc01characteris_mstr.is__qadc01
tlis_availlogicalis_mstr.is_availAvailable
tiis_cmtindxintegeris_mstr.is_cmtindxComment Index
tcis_desccharacteris_mstr.is_descDescription
tcis_domaincharacteris_mstr.is_domainDomain
tcis_fail_statuscharacteris_mstr.is_fail_statusFail Status
tlis_frozenlogicalis_mstr.is_frozenFrozen
ttis_mod_datedateis_mstr.is_mod_dateModified Date
tlis_nettablelogicalis_mstr.is_nettableNettable
tlis_overissuelogicalis_mstr.is_overissueOverissue
tcis_statuscharacteris_mstr.is_statusStatus Code
tcis_user1characteris_mstr.is_user1Ufld1
tcis_user2characteris_mstr.is_user2Ufld2
tcis_useridcharacteris_mstr.is_useridUser ID
tdoid_is_mstrdecimalis_mstr.oid_is_mstr
tcsi_domaincharactersi_mstr.si_domainDomain
tcsi_sitecharactersi_mstr.si_siteSite
tcsi_statuscharactersi_mstr.si_statusDefault Inventory Status
ti_sequenceintegercalculatedprimary index
tc_rowidcharactercalculated = rowid(si_mstr),rowid(is_mstr)


Internal usage


QadFinancials
method BMfgLocation.CreateLocation
method BMfgLocationDet.CreateLocationDet