DDL Code |
CREATE TABLE [dbo].[csOrders](
[Date] [datetime] NULL ,
[Customer] [varchar](50 ) NULL CONSTRAINT [DF_csOrders_Customer] DEFAULT (0 ),
[ShipToID] [varchar](50 ) NULL ,
[Class] [varchar](50 ) NULL CONSTRAINT [DF_csOrders_Class] DEFAULT (0 ),
[Memo] [nvarchar](50 ) NULL ,
[Term] [varchar](50 ) NULL CONSTRAINT [DF_csOrders_Term] DEFAULT (0 ),
[OrderNo] [varchar](50 ) NOT NULL ,
[DueDate] [datetime] NULL ,
[ShipVia] [varchar](50 ) NULL CONSTRAINT [DF_csOrders_ShipVia] DEFAULT (0 ),
[ShipDate] [datetime] NULL ,
[POID] [varchar](50 ) NULL ,
[CustomerMessage] [varchar](50 ) NULL CONSTRAINT [DF_csOrders_CustomerMessage] DEFAULT (0 ),
[Discount] [float] NULL CONSTRAINT [DF_csOrders_Discount] DEFAULT (0 ),
[Freight] [money] NULL CONSTRAINT [DF_csOrders_Freight] DEFAULT (0 ),
[SalesTax] [varchar](50 ) NULL ,
[Tax] [money] NULL CONSTRAINT [DF_csOrders_Tax] DEFAULT (0 ),
[TaxTotal] [money] NULL CONSTRAINT [DF_csOrders_TaxTotal] DEFAULT (0 ),
[Total] [money] NULL CONSTRAINT [DF_csOrders_Total] DEFAULT (0 ),
[TotalWeight] [float] NULL CONSTRAINT [DF_csOrders_TotalWeight] DEFAULT (0 ),
[ShippingCharge] [money] NULL CONSTRAINT [DF_csOrders_ShippingCharge] DEFAULT (0 ),
[Handling] [money] NULL CONSTRAINT [DF_csOrders_Handling] DEFAULT (0 ),
[ApplyYN] [bit] NOT NULL CONSTRAINT [DF_csOrders_ApplyYN] DEFAULT (0 ),
[Picked] [bit] NOT NULL CONSTRAINT [DF_csOrders_Picked] DEFAULT (0 ),
[Billed] [bit] NOT NULL CONSTRAINT [DF_csOrders_Billed] DEFAULT (0 ),
[Printed] [bit] NOT NULL CONSTRAINT [DF_csOrders_Printed] DEFAULT (0 ),
[Shipped] [bit] NOT NULL CONSTRAINT [DF_csOrders_Shipped] DEFAULT (0 ),
[Backordered] [bit] NOT NULL CONSTRAINT [DF_csOrders_Backordered] DEFAULT (0 ),
[Invoiced] [bit] NOT NULL CONSTRAINT [DF_csOrders_Invoiced] DEFAULT (0 ),
[TrackingNumber] [varchar](30 ) NULL ,
[CCType] [varchar](50 ) NULL ,
[CCName] [varchar](50 ) NULL CONSTRAINT [DF_csOrders_CCName] DEFAULT ( ''),
[CCNumber] [varchar](20 ) NULL CONSTRAINT [DF_csOrders_CCNumber] DEFAULT ( ''),
[CCExpDate] [datetime] NULL ,
[ApprovalNumber] [varchar](12 ) NULL CONSTRAINT [DF_csOrders_ApprovalNumber] DEFAULT ( ''),
[PostedYN] [bit] NOT NULL CONSTRAINT [DF_csOrders_PostedYN] DEFAULT (0 ),
[EditStamp] [timestamp] NOT NULL ,
CONSTRAINT [PK_csOrders] PRIMARY KEY NONCLUSTERED
(
[OrderNo] ASC
)WITH (IGNORE_DUP_KEY = OFF ) ON [PRIMARY]
) ON [PRIMARY]
END
|