InventTrans entity schema table description in MSD Axapta

 The InventTrans table contains information about inventory transactions. When order lines such as sales order lines or purchase order lines are created they generate related records in the inventTrans table. These records represent the flow of material that goes in and out of the inventory.

The InventTable table contains information about items.

The InventSum table contains information about the present and expected on-hand stock of items. Expected on-hand is calculated by looking at the present on-hand and adding whatever is on-order (has been purchased but not arrived yet).

The InventDim table contains values for inventory dimensions.

The VendTable table contains vendors for accounts payable.

The CustTable table contains the list of customers for accounts receivable and customer relationship management.