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.

Related Topics

General Notices