project QadFinancials > class BMfgPO > business logic query PurchaseOrderByDomainNbrVend
Description
PurchaseOrderByDomainNbrVend: query that allows filtering on the domain, po-number and vendor and returns a limited set of fields
Parameters
| icDomainCode | character | |
| icPONbr | character | |
| icPOVendor | character | Vendor |
| icPOCurrency | character | POCurrency |
| icPOType | character | POType |
query condition
each po_mstr where
po_mstr.po_domain = icDomainCode AND
po_mstr.po_nbr = icPONbr AND
po_mstr.po_curr = icPOCurrency AND
po_mstr.po_type = icPOType AND
po_mstr.po_vend = icPOVendor
query resultset tqPurchaseOrderByDomainNbrVend
| field name | data type | db field | description |
|---|
| tcpo_cr_terms | character | po_mstr.po_cr_terms | Credit Terms |
| tcpo_daybookset | character | po_mstr.po_daybookset | Daybook Set |
| tcpo_ship | character | po_mstr.po_ship | Ship-To |
| tcpo_domain | character | po_mstr.po_domain | Domain |
| tcpo_vend | character | po_mstr.po_vend | Supplier |
| tcpo_nbr | character | po_mstr.po_nbr | Purchase Order |
| tcpo_type | character | po_mstr.po_type | Type |
| tcpo_curr | character | po_mstr.po_curr | Currency |
| tcpo_site | character | po_mstr.po_site | Site |
| tlpo_confirm | logical | po_mstr.po_confirm | Confirming |
| ttpo_ord_date | date | po_mstr.po_ord_date | Order Date |
| ti_sequence | integer | calculated | primary index |
| tc_rowid | character | calculated | = rowid(po_mstr) |
Internal usage
QadFinancials