In a Sales Order containing several line items, it is possible to have one or more line items marked as closed. A User would want to identify cancelled/closed line items using ODBC.
The 'Closed' field is exposed in TRANSACTION_LINES view as 'ITEM_RECEIVED' field. ITEM_RECEIVED = 'Yes' indicates a closed line item.
SELECT * FROM Administrator.TRANSACTION_LINES
WHERE TRANSACTION_ID = '4962'
AND ITEM_RECEIVED = 'Yes'
Post a Comment