Parameters
| icCompanyCodeList | character | |
| icDebtorCode | character | |
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 name | data type | db field | description |
|---|
| tcsi_entity | character | si_mstr.si_entity | Entity |
| tcso_curr | character | so_mstr.so_curr | Currency |
| tcso_domain | character | so_mstr.so_domain | Domain |
| tcso_nbr | character | so_mstr.so_nbr | Sales Order |
| tdso_trl1_amt | decimal | so_mstr.so_trl1_amt | Trailer Amt 1 |
Internal usage
QadFinancials