1

Query-for-fetching-Order-Tax-Details

rob edited this page 2026-06-29 09:04:57 +00:00

select 
   o.id as OrderId, 
    status,
    ca.name as ChannelName,
    o.checkoutDate,
    ro.customerName,
    ro.customerEmail,
    sinfo.address1 as ShippingAddressLine1,
    sinfo.address2 as ShippingAddressLine2,
    binfo.address1 as BillingAddressLine1,
    binfo.address2 as BillingAddressLine2,
    sinfo.city,
    sinfo.state,
    sinfo.zip,
    sinfo.country,
    o.totalTax,
    o.invoiceTotal,
    pa.addressLine1 as PostalAddress1,
    pa.addressLine2 as PostalAddress2,
    pa.postalCode as PostalCode,
    pa.countryCode,
    pa.administrativeArea,
    pa.locality   
from 
	OOrder o
Left Join RetailOrder ro on ro.id = o.id    
Left Join ChannelAccount ca On (ca.id = o.channelAccount_id)
LEFT JOIN ShippingInfo sinfo ON  sinfo.id = o.shippingInfo_id
LEFT JOIN BillingInfo binfo ON  binfo.id = o.billingInfo_id
LEFT JOIN PostalAddress pa ON pa.id = sinfo.address_id
where

o.checkoutDate >= '2021-01-01 00:00:00';