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