Orders

CREATE TABLE [dbo].[Orders]

([Orders_ID] [varchar](18) NOT NULL,[Shipping_Address1] [varchar](255) NOT NULL, [Shipping_Address2] [varchar](255) NULL, [Shipping_Address3] [varchar](255) NULL, [Shipping_State] [varchar](18) NOT NULL, [Shipping_City] [varchar](18) NOT NULL, [Shipping_Zip] [int] NOT NULL, [CreatedById] [varchar](18) NOT NULL, [LastModifiedById] [varchar](18) NOT NULL, [Order_Name] [varchar](255) NOT NULL, [OwnerId] [varchar](18) NOT NULL, [Order_Status] [varchar](18) NOT NULL, [LastModifiedDate] [timestamp] NOT NULL, [OrderNotes] [text] NULL, [OrderDate] [datetime] NOT NULL, [Shipping_Tracking_Number] [varchar](255) NULL, [Shipping_provider] [varchar](255) NULL, [Order_Total] [money] NULL, [Contact_ID] [varchar](18) NULL, [Quote_ID] [varchar](18) NULL, [Promo_Code] [varchar](18) NULL)

CREATE TABLE [dbo].[Order_Details]

( [OrderDetails_ID] [varchar](18) NOT NULL, [Orders_ID] [varchar](18) NOT NULL, [CreatedById] [varchar](18) NOT NULL, [CreatedDate] [datetime] NOT NULL, [LastModifiedById] [varchar](18) NOT NULL, [LastModifiedDate] [timestamp] NOT NULL, [Orderdetails_Status] [varchar](18) NOT NULL, [Quantity] [int] NULL, [Product_ID] [varchar](18) NOT NULL, [Price] [money] NULL, [Total_amount] [money] NULL)