On the Item Fulfillment, we have a tab package. I'...
# suiteql
s
On the Item Fulfillment, we have a tab package. I'm trying to access that table using SuiteQL. I thought the table was select * from ShippingPackage but I'm getting nothing. Do you know the table name ?
d
that is a valid SuiteQL table, although maps to the data found under Setup > Accounting > Shipping > Packages tab/sublist not sure exactly what data you're trying to access instead, but I assume is on the Transaction itself potentially
t
I think that table is only available / populated if the Advanced Shipping feature is in use.
s
It was a bit tricky but I made it SELECT Transaction.ID,Transaction.TranID,Transaction.TranDate,TransactionShipment.Weight, BUILTIN.DF(transactionline.item) AS item,BUILTIN.DF( Transaction.TrackingNumberList ) AS trackingnumber FROM Transaction INNER JOIN TransactionShipment ON TransactionShipment.Doc = Transaction.ID INNER JOIN TransactionLine ON TransactionLine.Transaction = Transaction.ID AND TransactionLine.MainLine = 'T' INNER JOIN Transaction AS SalesOrder ON SalesOrder.ID = TransactionLine.CreatedFrom WHERE Transaction.Type = 'ItemShip' AND Transactionline.createdfrom = 54860805