project QadFinancials > class BMfgItem > business logic query ItemByItemWithVendDet
Description
Get item details with additional vendor item details.
Parameters
| icDomain | character | |
| icPart | character | |
| icVendor | character | Code of vendor |
| icVendorPart | character | |
query condition
each pt_mstr where
pt_mstr.pt_domain = icDomain AND
pt_mstr.pt_part = icPart
each vp_mstr (inner-join) where
vp_mstr.vp_domain = pt_mstr.pt_domain AND
vp_mstr.vp_part = pt_mstr.pt_part AND
vp_mstr.vp_vend = icVendor AND
vp_mstr.vp_vend_part = icVendorPart
query resultset tqItemByItemWithVendDet
| field name | data type | db field | description |
|---|
| tcpt_domain | character | pt_mstr.pt_domain | Domain |
| tcpt_part | character | pt_mstr.pt_part | Item Number |
| tcpt_um | character | pt_mstr.pt_um | UM |
| tcvp_curr | character | vp_mstr.vp_curr | Currency |
| tdvp_q_price | decimal | vp_mstr.vp_q_price | Quote Price |
| tdvp_q_qty | decimal | vp_mstr.vp_q_qty | Quote Qty |
| tcvp_um | character | vp_mstr.vp_um | UM |
| tcvp_vend | character | vp_mstr.vp_vend | Supplier |
| tcvp_vend_part | character | vp_mstr.vp_vend_part | Supplier Item |
Internal usage
QadFinancials