Exigo OData Service

Orders

Read-Only
Yes

Properties
OrderID
Int32
No
The unique identifier for the order
CustomerID
Int32
No
The unique identifier of the customer
OrderStatusID
Int32
No
OrderDate
DateTime
No
The date the order will process
CurrencyCode
String
No
The standard ISO 4217 3-letter currency code
WarehouseID
Int32
No
The unique identifier for the warehouse
ShipMethodID
Int32
No
The unique identifier for the ship method
OrderTypeID
Int32
No
PriceTypeID
Int32
No
The type of price
FirstName
String
No
The customer's first name
MiddleName
String
No
The customer's middle name
LastName
String
No
The customer's last name
NameSuffix
String
No
The customer's name suffix
Company
String
No
The customer's company name
Address1
String
No
Address2
String
No
City
String
No
State
String
No
Zip
String
No
Country
String
No
County
String
No
Email
String
No
The customer's email address
Phone
String
No
The customer's primary phone number
Notes
String
No
Any additional notes or information about this record
Total
Decimal
No
The total of the order
SubTotal
Decimal
No
The subtotal of the order
TaxTotal
Decimal
No
The total taxes of the order
ShippingTotal
Decimal
No
The total shipping fees of the order
DiscountTotal
Decimal
No
The total discounts applied to the order
DiscountPercent
Decimal
No
WeightTotal
Decimal
No
The total weight of the item
BusinessVolumeTotal
Decimal
No
The total business volume of the order
CommissionableVolumeTotal
Decimal
No
The total commissionable volume of the order
TrackingNumber1
String
No
TrackingNumber2
String
No
TrackingNumber3
String
No
TrackingNumber4
String
No
TrackingNumber5
String
No
Other1Total
Decimal
No
The total value of the Other1 price of the order
Other2Total
Decimal
No
The total value of the Other2 price of the order
Other3Total
Decimal
No
The total value of the Other3 price of the order
Other4Total
Decimal
No
The total value of the Other4 price of the order
Other5Total
Decimal
No
The total value of the Other5 price of the order
Other6Total
Decimal
No
The total value of the Other6 price of the order
Other7Total
Decimal
No
The total value of the Other7 price of the order
Other8Total
Decimal
No
The total value of the Other8 price of the order
Other9Total
Decimal
No
The total value of the Other9 price of the order
Other10Total
Decimal
No
The total value of the Other10 price of the order
ShippingTax
Decimal
No
The total tax from shipping of the order
OrderTax
Decimal
No
FedTaxTotal
Decimal
No
StateTaxTotal
Decimal
No
FedShippingTax
Decimal
No
StateShippingTax
Decimal
No
CityShippingTax
Decimal
No
CityLocalShippingTax
Decimal
No
CountyShippingTax
Decimal
No
CountyLocalShippingTax
Decimal
No
Other11
String
No
A company-defined custom value.
Other12
String
No
A company-defined custom value.
Other13
String
No
A company-defined custom value.
Other14
String
No
A company-defined custom value.
Other15
String
No
A company-defined custom value.
Other16
String
No
A company-defined custom value.
Other17
String
No
A company-defined custom value.
Other18
String
No
A company-defined custom value.
Other19
String
No
A company-defined custom value.
Other20
String
No
A company-defined custom value.
AutoOrderID
Int32?
Yes
The unique identifier for the auto order
ReturnOrderID
Int32?
Yes
ParentOrderID
Int32?
Yes
TransferToCustomerID
Int32?
Yes
DeclineCount
Int32
No
ShippedDate
DateTime?
Yes
CreatedDate
DateTime
No
The date the record was created
TaxFedRate
Decimal
No
TaxStateRate
Decimal
No
TaxCityRate
Decimal
No
TaxCityLocalRate
Decimal
No
TaxCountyRate
Decimal
No
TaxCountyLocalRate
Decimal
No
TaxManualRate
Decimal
No
TaxCity
String
No
TaxCounty
String
No
TaxState
String
No
TaxZip
String
No
TaxCountry
String
No
TaxIsExempt
Boolean
No
TaxIsOverRide
Boolean
No
ModifiedDate
DateTime
No
The date the record was last modified
Details
OrderDetail[]
No
Payments
Payment[]
No
Customer
Customer
No
OrderStatus
OrderStatus
No
The status of the order
Warehouse
Warehouse
No
ShipMethod
ShipMethod
No
PriceType
PriceType
No
The type of price
OrderType
OrderType
No
The type of the order