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 |
|
|