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