writing an SQL to pull a list of items on a specific purchase order with the NetSuite2.com schema

AI generated answer (using internal Slack threads):

To pull a list of items on a specific purchase order using SQL, you would need to join the relevant tables in your NetSuite database. Here's a basic example of how you might do this:

sql
SELECT 
    po.purchaseOrderId, 
    po.purchaseOrderDate, 
    i.itemId, 
    i.itemName
FROM 
    PurchaseOrder po
JOIN 
    PurchaseOrderItem poi ON po.purchaseOrderId = poi.purchaseOrderId
JOIN 
    Item i ON poi.itemId = i.itemId
WHERE 
    po.purchaseOrderId = 'YourSpecificPurchaseOrderId';

In this SQL query, we're joining the

PurchaseOrder

,

PurchaseOrderItem

, and

Item

tables on their respective IDs. We're then selecting the purchase order ID, the purchase order date, the item ID, and the item name from these tables. The

WHERE

clause is used to specify the specific purchase order ID that you're interested in. Please note that the actual table and column names in your NetSuite database may vary, so you'll need to adjust the query accordingly. Also, this is a basic example and might not cover all your needs, but it should give you a good starting point. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******

I get a Base table: PurchaseOrder not found [10129]