Grand Total (Excl.tax) value in database

[Andy_Acute]

Hi all.

Does anyone know which database table the Grand Total (Excl.tax) of an order is saved please?

In fact, it would a great help if any knows where all of the order totals values are stored.

I know they're spread across multiple tables, but to help me get a grip on where all of these values are stored would be a big help.

If not, I'm mainly interested in the Grand Total (Excl.tax) value.

Many Thanks in advance

Andy

[gaurav_harsh1]

Hello @Andy_Acute ,

you'll find all details(tax, shipping amount, subtotal etc) in sales_order and sales_order_grid table for all orders. and for specific item detail, you can check in sales_order_item table.

Hope it helps.