ODBC Driver for BigCommerce

Build 24.0.9060

OrderShippingAddresses

Returns shipping addresses and their corresponding orders.

Columns

Name Type References Description
Id [KEY] Integer ID of this shipping address.
OrderId Integer 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.
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.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060