Get Tax Details Through SQL

Use SQL to get tax details for a sales order.

For example, get tax details for sales order 657486.

select dfl.source_order_number, dfl.fulfill_line_id, zr.tax, zr.tax_rate_code, zr.tax_regime_code, zr.percentage_rate
from doo_fulfill_lines_all dfl,
doo_order_charges doo,
doo_order_charge_components docc,
doo_order_tax_details dotd,
zx_rates_b zr
where dfl.fulfill_line_id=doo.parent_entity_id
and doo.order_charge_id=docc.order_charge_id
and docc.order_charge_component_id=dotd.order_charge_component_id
and dotd.tax_rate_id=zr.tax_rate_id
and dfl.source_order_number=657486