eCommerceDataset.eCommerceOrderDataDataTable
Columns:
|
Name |
Type |
Max Length |
Default Value |
Allow Null |
Read Only |
Unique |
OrderID |
Int64 |
|
|
|
X |
X |
ExternalOrderID |
String |
50 |
|
X |
|
|
OrderNumber |
String |
50 |
|
X |
|
|
CustomerID |
Int64 |
|
|
X |
|
|
CreatedDate |
DateTime |
|
|
X |
|
|
ModifiedDate |
DateTime |
|
|
X |
|
|
CompletedDate |
DateTime |
|
|
X |
|
|
StatusID |
Int32 |
|
|
X |
|
|
StatusCode |
String |
60 |
|
X |
|
|
IpAddress |
String |
20 |
|
X |
|
|
UserAgent |
String |
2147483647 |
|
X |
|
|
OrderNotes |
String |
2147483647 |
|
X |
|
|
CustomerMessage |
String |
2147483647 |
|
X |
|
|
CurrencyID |
Int32 |
|
|
X |
|
|
CurrencyCode |
String |
20 |
|
X |
|
|
ExchangeRate |
Decimal |
|
|
X |
|
|
ItemsTotal |
Int32 |
|
|
X |
|
|
SubTotal |
Decimal |
|
|
X |
|
|
Shipping |
Decimal |
|
|
X |
|
|
Tax |
Decimal |
|
|
X |
|
|
Discount |
Decimal |
|
|
X |
|
|
Total |
Decimal |
|
|
X |
|
|
ShippingMethod |
String |
50 |
|
X |
|
|
ShippingWeight |
Decimal |
|
|
X |
|
|
PaymentMethod |
String |
25 |
|
X |
|
|
PaymentMethodID |
String |
50 |
|
X |
|
|
PaymentStatus |
String |
50 |
|
X |
|
|
MemberID |
Int32 |
|
|
X |
|
|
DateAdded |
DateTime |
|
|
X |
|
|
ListName |
String |
60 |
|
X |
|
|
eCommercePortal |
String |
30 |
|
|
|
|
DiscountCode |
String |
50 |
|
X |
|
|
EmailAddress |
String |
100 |
|
X |
|
|
CartToken |
String |
75 |
|
X |
|
|