dataexport: 15
This data as json
| id | dataQuery | dateCreated | dateLastModified | description | lastChangedUserId | name |
|---|---|---|---|---|---|---|
| 15 | select SO.num, soitem.soLineItem, SO.customerContact, soitem.customerPartNum, soitem.productNum, soitem.description, soitem.qtytofulfill, so.dateCreated, so.dateIssued, soitem.dateScheduledFulfillment, sostatus.name, bom.activeflag from so join soitem on so.id = soitem.soid join Bom on soitem.productnum = bom.num Join sostatus on so.statusid = sostatus.id Where SO.statusId in (10,20) and bom.activeflag = 0 order by so.datecreated desc | 2025-10-15 14:17:30.379000 | 2025-10-22 17:22:36.193000 | Returns all open orders whre the BOM is not active | 46 | Document Demand Report |