How do I query, with suiteQL, the order schedule on blanket purchase orders?

AI generated answer (using internal Slack threads):

To query the order schedule on blanket purchase orders using SuiteQL, you would need to target the appropriate tables and fields in your query. Unfortunately, the specific tables and fields to use are not provided in the provided Slack threads. However, generally, you would need to join the purchase order table with the line item table and filter by the purchase order type to get only blanket purchase orders. The schedule would likely be stored in a separate table or as a field on the line item table. Here is a general example of what the SuiteQL might look like:

sql
SELECT po.id, po.number, line.itemId, line.schedule
FROM PurchaseOrder AS po
JOIN LineItem AS line ON po.id = line.purchaseOrderId
WHERE po.type = 'Blanket Purchase Order'

Please note that this is a simplified example and the actual table and field names in NetSuite may be different. You would need to refer to the NetSuite Records Browser or SuiteAnswers for the exact table and field names to use. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******