Query All Transactions

 Hi Everyone,

     Good day! I have a problem of query.. do you have any idea guys that how to query all transactional tables in apps like sales, inventory, transfer between organization etc. I mean all inventory transactions happen like a stockard example see below

     ITEM       IN          OUT       TOTAL

     cd          1000     500        500

    or

    ITEM       purchases      transfer-in     transfer-out    returns     sales     TOTAL

   CD           500                 500               250                  0                250       500

   like this output above, is there select statement can serve this type of report? ITIMIZED?

Regards,

Al