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


icDomainCodecharacter
icPONbrcharacter
icPOVendorcharacterVendor
icPOCurrencycharacterPOCurrency
icPOTypecharacterPOType


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 namedata typedb fielddescription
tcpo_cr_termscharacterpo_mstr.po_cr_termsCredit Terms
tcpo_daybooksetcharacterpo_mstr.po_daybooksetDaybook Set
tcpo_shipcharacterpo_mstr.po_shipShip-To
tcpo_domaincharacterpo_mstr.po_domainDomain
tcpo_vendcharacterpo_mstr.po_vendSupplier
tcpo_nbrcharacterpo_mstr.po_nbrPurchase Order
tcpo_typecharacterpo_mstr.po_typeType
tcpo_currcharacterpo_mstr.po_currCurrency
tcpo_sitecharacterpo_mstr.po_siteSite
tlpo_confirmlogicalpo_mstr.po_confirmConfirming
ttpo_ord_datedatepo_mstr.po_ord_dateOrder Date
ti_sequenceintegercalculatedprimary index
tc_rowidcharactercalculated = rowid(po_mstr)


Internal usage


QadFinancials
method BAPMatching.GetPendingVouchersValidate
method BCInvoice.AddCInvoicePO
method BCInvoice.CreateCInvoices
method BCInvoice.DefaultValuesPO
method BCInvoice.ValidateComponentPostPO
method BCInvoiceAPMatching.ApiEDICInvoiceAPMatchingImport
method BCInvoiceAPMatching.CreateCInvoice