Connect Access to Transaction Quantities
Item count and quantity values aren't exposed as columns in the Transactions table. However, you can obtain these values through the Connect Service by running a query against the Transaction Lines table such as the following:
select TRANSACTIONS.TRANSACTION_ID, TRANSACTION_LINES.ITEM_COUNT
from TRANSACTIONS, TRANSACTION_LINES
where TRANSACTION_LINES.TRANSACTION_ID = TRANSACTIONS.TRANSACTION_ID
and TRANSACTION_LINES.TRANSACTION_LINE_ID > 0;
These results can be useful for inventory reporting purposes.
Note that the transaction_id field corresponds to the unique identifier of a transaction. To get the transaction ID through a Transaction saved search, select the Internal ID (Number) in the Filter field.