GO

CREATE TABLE [dbo].[ZL_Shop_ProOrder](

[ID] [int] IDENTITY(1,1) NOT NULL,

[OrderNo] [varchar](50) NULL,

[Reuser] [varchar](255) NULL,

[Receiver] [varchar](50) NULL,

[Rename] [varchar](255) NULL,

[Guojia] [varchar](255) NULL,

[Shengfen] [varchar](255) NULL,

[Chengshi] [varchar](255) NULL,

[Diqu] [varchar](255) NULL,

[Jiedao] [varchar](255) NULL,

[ZipCode] [varchar](50) NULL,

[Phone] [varchar](50) NULL,

[Email] [varchar](50) NULL,

[Mobile] [int] NULL,

[Delivery] [int] NULL,

[Outstock] [int] NULL,

[Deliverytime] [int] NULL,

[Payment] [int] NULL,

[Invoice] [varchar](2000) NULL,

[Ordermessage] [text] NULL,

[Merchandiser] [varchar](50) NULL,

[Internalrecords] [text] NULL,

[Ordersamount] [money] NULL,

[Receivablesamount] [money] NULL,

[Specifiedprice] [money] NULL,

[Freight] [money] NULL,

[Invoiceneeds] [int] NULL,

[Developedvotes] [int] NULL,

[OrderStatus] [int] NULL,

[Paymentstatus] [int] NULL,

[StateLogistics] [int] NULL,

[Signed] [int] NULL,

[Settle] [int] NULL,

[Aside] [int] NULL,

[Suspended] [int] NULL,

[Ordertype] [int] NULL,

[AddTime] [datetime] NULL,

[AddUser] [varchar](255) NULL,

[Userid] [int] NULL,

[city] [nvarchar](50) NULL,

[IsCount] [bit] NULL,

[Integral] [int] NULL,

[parentID] [int] NULL,

[service_charge] [float] NULL,

[Balance_price] [float] NULL,

[Freight_remark] [nvarchar](1000) NULL,

[Balance_remark] [nvarchar](1000) NULL,

[Money_rate] [money] NULL,

[Money_code] [varchar](4) NULL,

[MobileNum] [nvarchar](20) NULL,

[ExpressDelivery] [nvarchar](500) NULL,

[InvoType] [int] NULL,

[Promoter] [int] NULL,

[ExpressNum] [varchar](400) NULL,

[Company] [nvarchar](400) NULL,

[SendPointStatus] [int] NULL,

[Province] [nvarchar](1) NULL,

[Extend] [ntext] NULL,

[StoreID] [int] NULL,

[AllMoney_Json] [nvarchar](500) NULL,

[PaymentNo] [nvarchar](500) NULL,

[ExpTime] [nvarchar](500) NULL,

[IsSure] [int] NULL,

[BackID] [int] NULL,

CONSTRAINT [PK_ZL_Shop_ProOrder] PRIMARY KEY CLUSTERED 

([ID] ASC

)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]

) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]