OrderShippingAddresses

Returns shipping addresses and their corresponding orders.

Columns


Name	Type	References	Description
Id [KEY]	Integer		ID of this shipping address.
OrderId	Integer	Orders.Id	ID of the order.
FirstName	String		Addressee first name.
LastName	String		Addressee last name.
Company	String		Addressee company.
Street1	String		Street address (first line).
Street2	String		Street address (second line).
City	String		Addressee city.
Zip	String		ZIP or postal code.
Country	String		Addressee's country.
State	String		The name of the state or province. Should be spelled out in full, for example, California.
Email	String		Recipient's email address.
Phone	String		Recipient's telephone number.
BaseCost	Decimal		The base value of the order’s items.
BaseHandlingCost	Decimal		The base handling charge.
CostExTax	Decimal		The value of the order’s items, excluding tax.
CostIncTax	Decimal		The value of the order’s items, including tax.
CostTax	Decimal		The tax amount on the order.
CostTaxClassId	String		The ID of the tax class applied to the product.
CountryIso2	String		2-letter ISO Alpha-2 code for the country.
HandlingCostExTax	Decimal		The handling charge, excluding tax.
HandlingCostIncTax	Decimal		The handling charge, including tax.
HandlingCostTax	Decimal		The handling charge.
HandlingCostTaxClassId	String		A read-only value. Do not attempt to set or modify this value in a POST or PUT operation. (NOTE: Value ignored if automatic tax is enabled on the store.)
ItemsShipped	Integer		The number of items that have been shipped.
ItemsTotal	Integer		The total number of items in the order.
ShippingMethod	String		Text code identifying the BigCommerce shipping module selected by the customer.
ShippingZoneId	Integer		Numeric ID of the shipping zone.
ShippingZoneName	String		Name of the shipping zone.

Power BI Connector for BigCommerce

OrderShippingAddresses

Columns