project QadFinancials > class BMfgLocationDet > business logic query LocationDetailBySiteLoc


Parameters


icDomaincharacterDomain
icSitecharacterSite
icLocationcharacter
icPartcharacter
icLotSerialNumbercharacter
icLotReferencecharacter


query condition


  each ld_det where
ld_det.ld_domain = icDomain AND
ld_det.ld_site = icSite AND
ld_det.ld_loc = icLocation AND
ld_det.ld_part = icPart AND
ld_det.ld_lot = icLotSerialNumber AND
ld_det.ld_ref = icLotReference


query resultset tqLocationDetailBySiteLoc


field namedata typedb fielddescription
tdld_assaydecimalld_det.ld_assayAssay %
tcld_domaincharacterld_det.ld_domainDomain
ttld_expiredateld_det.ld_expireExpire Date
tcld_gradecharacterld_det.ld_gradeGrade
tcld_loccharacterld_det.ld_locLocation
tcld_lotcharacterld_det.ld_lotLot/Serial
tcld_partcharacterld_det.ld_partItem Number
tdld_qty_ohdecimalld_det.ld_qty_ohQty On Hand
tcld_refcharacterld_det.ld_refRef
tcld_sitecharacterld_det.ld_siteSite
tcld_statuscharacterld_det.ld_statusInventory Status
tdoid_ld_detdecimalld_det.oid_ld_det
ti_sequenceintegercalculatedprimary index
tc_rowidcharactercalculated = rowid(ld_det)


Internal usage


QadFinancials
method BMfgLocationDet.LoadLocationDet