Connect Access to Transaction Quantities

Item count and quantity values are not 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

Examples of Queries
Joining Tables in Connect
Connect Access to Transaction Credit and Debit Amounts

General Notices