Using SuiteQL, get only the ITEM lines of a Transfer Order

AI generated answer (using internal Slack threads):

To get only the ITEM lines of a Transfer Order using SuiteQL, you can use the

TransactionLine

table. This table contains all the lines of a transaction, including the item lines. You can filter the results by the

Transaction.type

field to get only the Transfer Orders and by the

TransactionLine.itemtype

field to get only the item lines. Here is a sample SuiteQL query:

sql
SELECT 
    Transaction.tranid, 
    TransactionLine.item, 
    TransactionLine.quantity
FROM 
    Transaction 
INNER JOIN 
    TransactionLine ON Transaction.ID = TransactionLine.Transaction 
WHERE 
    Transaction.type = 'TrnfrOrd' AND TransactionLine.itemtype = 'InvtPart'

This query will return the transaction ID (

tranid

), the item ID (

item

), and the quantity (

quantity

) for each item line in all Transfer Orders. Please note that 'InvtPart' is used as an example for

TransactionLine.itemtype

and it represents inventory items. You might need to adjust this according to your specific needs. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******