CREATE TABLE [dbo].[ItemMasterFile]( [CodeItem] [int] IDENTITY(1,1) NOT NULL, [Descriptionitem] [varchar](50) NULL, [BaleSize] [varchar](50) NULL, [weight] [int] NULL, [SecID] [int] NULL, [Packsize] [varchar](50) NULL, [ALID] [varchar](50) NULL, [IDUOM] [int] NULL, [entryDate] [date] NULL, CONSTRAINT [PK_ItemMasterFile]
CREATE TABLE [dbo].[CustomerItem]( [CItem] [int] IDENTITY(1,1) NOT NULL, [CIName] [varchar](50) NULL, [CustomerID] [int] NOT NULL, [Codeitem] [int] NULL, [Price] [int] NULL, [Address] [varchar](50) NULL, CONSTRAINT [PK_CustomerItem] PRIMARY KEY CLUSTERED
CREATE TABLE [dbo].[Customer]( [CustomerID] [int] IDENTITY(1,1) NOT NULL, [CustomerName] [varchar](50) NULL, [Contactno] [varchar](50) NULL, [Address] [varchar](50) NULL, CONSTRAINT [PK_Customer] PRIMARY KEY CLUSTERED
CREATE TABLE [dbo].[SalesOrder]( [OrderNo] [int] NOT NULL, [Order_Ref_No] [varchar](50) NULL, [CustomerID] [int] NULL, [Order_date] [date] NULL, [SOpirority] [int] NULL, [Status] [varchar](50) NULL, CONSTRAINT [PK_SalesOrder] PRIMARY KEY
CREATE TABLE [dbo].[Probale]( [Prdno] [int] IDENTITY(1000001,1) NOT NULL, [OrderNo] [int] NOT NULL, [Codeitem] [int] NULL, [prdqty] [int] NULL, [EntryDate] [date] NOT NULL, [Weigth] [nchar](10) NULL, [IDwokrer] [int] NULL, [FID] [int] NULL, [udate] [date] NULL, [DelID] [int] NULL, [ddate] [date] NULL, CONSTRAINT [PK_Probale] PRIMARY KEY CLUSTERED (