project QadFinancials > class BMfgLocationDet > business logic query LocationDetailBySiteLoc
Parameters
icDomain | character | Domain |
icSite | character | Site |
icLocation | character | |
icPart | character | |
icLotSerialNumber | character | |
icLotReference | character | |
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 name | data type | db field | description |
tdld_assay | decimal | ld_det.ld_assay | Assay % |
tcld_domain | character | ld_det.ld_domain | Domain |
ttld_expire | date | ld_det.ld_expire | Expire Date |
tcld_grade | character | ld_det.ld_grade | Grade |
tcld_loc | character | ld_det.ld_loc | Location |
tcld_lot | character | ld_det.ld_lot | Lot/Serial |
tcld_part | character | ld_det.ld_part | Item Number |
tdld_qty_oh | decimal | ld_det.ld_qty_oh | Qty On Hand |
tcld_ref | character | ld_det.ld_ref | Ref |
tcld_site | character | ld_det.ld_site | Site |
tcld_status | character | ld_det.ld_status | Inventory Status |
tdoid_ld_det | decimal | ld_det.oid_ld_det | |
ti_sequence | integer | calculated | primary index |
tc_rowid | character | calculated | = rowid(ld_det) |
Internal usage
QadFinancials