SalesOrderID|int|4|10|0|no
RevisionNumber|tinyint|1|3|0|no
OrderDate|datetime|8|||no
DueDate|datetime|8|||no
ShipDate|datetime|8|||yes
Status|tinyint|1|3|0|no
OnlineOrderFlag|Flag|1|||no
SalesOrderNumber|nvarchar|50|||no
PurchaseOrderNumber|OrderNumber|50|||yes
AccountNumber|AccountNumber|30|||yes
CustomerID|int|4|10|0|no
ContactID|int|4|10|0|no
SalesPersonID|int|4|10|0|yes
TerritoryID|int|4|10|0|yes
BillToAddressID|int|4|10|0|no
ShipToAddressID|int|4|10|0|no
ShipMethodID|int|4|10|0|no
CreditCardID|int|4|10|0|yes
CreditCardApprovalCode|varchar|15|||yes
CurrencyRateID|int|4|10|0|yes
SubTotal|money|8|19|4|no
TaxAmt|money|8|19|4|no
Freight|money|8|19|4|no
TotalDue|money|8|19|4|no
Comment|nvarchar|256|||yes
rowguid|uniqueidentifier|16|||no
ModifiedDate|datetime|8|||no