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