home / fishbowl_archive / dataexport

dataexport: 14

This data as json

id dataQuery dateCreated dateLastModified description lastChangedUserId name
14 select So.num, SOitem.soLineItem, so.billToName, so.customerpo, so.salesman, soitem.productnum, soitem.description, soitem.qtyordered, soitem.qtyfulfilled, soitem.unitprice, soitem.totalPrice, so.dateCreated, so.dateissued, soitem.dateScheduledFulfillment from so join soitem on so.id = soitem.soid join soitemstatus on soitem.statusId = soitemstatus.id where soitemstatus.name = "entered" 2025-09-30 14:02:18.194000 2025-09-30 14:02:18.194000   46 Production Schedule
Powered by Datasette · Queries took 1.322ms