project QadFinancials > class BMfgSalesOrderQuery > business logic query OpenSalesOrderByCompany


Parameters


icCompanyCodeListcharacter
icDebtorCodecharacter


query condition


  each dom_mstr where

      each so_mstr (inner-join) where
so_mstr.so_domain = dom_mstr.dom_domain AND
so_mstr.so_compl_stat = '' AND
so_mstr.so_cust = icDebtorCode

          each si_mstr (inner-join) where
si_mstr.si_domain = so_mstr.so_domain AND
si_mstr.si_site = so_mstr.so_site AND
si_mstr.si_entity = icCompanyCodeList


query resultset tqOpenSalesOrderByCompany


field namedata typedb fielddescription
tcsi_entitycharactersi_mstr.si_entityEntity
tcso_currcharacterso_mstr.so_currCurrency
tcso_domaincharacterso_mstr.so_domainDomain
tcso_nbrcharacterso_mstr.so_nbrSales Order
tdso_trl1_amtdecimalso_mstr.so_trl1_amtTrailer Amt 1


Internal usage


QadFinancials
method BDebtor.CalculateBOIforCompanies