Using ODBC, does anyone have an idea why a Sales Order always has several null lines?

select TRANSACTION_ID, ITEM_ID from TRANSACTION_LINES
where TRANSACTION_ID = '7996032';

There will be main lines and possibly shipping lines as well.

To add to this, there may be Shipping Lines, Tax Lines, and COGS line. You should be able to exclude these in your query