GO

/****** Object:  Table [dbo].[SalesOrder]    Script Date: 06-04-2025 14:43:38 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO



CREATE TABLE [dbo].[SalesOrder](
	[ID] [int] IDENTITY(1,1) NOT NULL,
	[EntryDate] [datetime] NULL,
	[SalesOrderNo] [nvarchar](500) NULL,
	[RefNo] [nvarchar](500) NULL,
	[Attended] [nvarchar](2000) NULL,
	[CustomerCode] [nvarchar](500) NULL,
	[CustomerName] [nvarchar](2000) NULL,
	[Address] [nvarchar](2000) NULL,
	[Telephone] [nvarchar](500) NULL,
	[Fax] [nvarchar](500) NULL,
	[Attention] [nvarchar](2000) NULL,
	[NetAmount] [float] NULL,
	[KeyFld] [float] NULL,
	[PaymentTerms] [nvarchar](500) NULL,
	[Validity] [nvarchar](500) NULL,
	[PlaceOfDelivery] [nvarchar](500) NULL,
	[DeliveryTime] [nvarchar](500) NULL,
	[Flag] [nvarchar](500) NULL,
	[Less] [float] NULL,
	[LessPerc] [float] NULL,
	[GrossAmount] [float] NULL,
	[Remarks] [nvarchar](2000) NULL,
	[UserName] [nvarchar](500) NULL,
	[PenQuo] [bit] NULL,
	[custRefNo] [nvarchar](500) NULL,
	[SalesMan] [nvarchar](2000) NULL,
	[AttenMob] [nvarchar](500) NULL,
	[AttenEmail] [nvarchar](500) NULL,
	[CustEmail] [nvarchar](500) NULL,
	[RFQDate] [datetime] NULL,
	[Del1] [nvarchar](500) NULL,
	[Del2] [nvarchar](500) NULL,
	[Del3] [nvarchar](500) NULL,
	[Del4] [nvarchar](500) NULL,
	[freight] [nvarchar](500) NULL,
	[Trans] [nvarchar](500) NULL,
	[dnno] [nvarchar](100) NULL,
	[Mobile] [nvarchar](500) NULL,
	[Vatno] [nvarchar](200) NULL,
	[Vattotal] [float] NULL,
	[NETDISC] [float] NULL,
	[Branch] [nvarchar](500) NULL,
	[TotalIncDiscAmount] [float] NULL,
	[DiscountType] [nchar](10) NULL,
	[NetDiscPer] [float] NULL,
	[BranchCode] [nvarchar](500) NULL,
	[BranchName] [nvarchar](500) NULL,
	[InvoiceNo] [nvarchar](500) NULL,
	[isDeleted] [nvarchar](50) NULL,
	[JobCardNo] [nvarchar](100) NULL
) ON [PRIMARY]
GO




GO

/****** Object:  Table [dbo].[SalesOrderItem]    Script Date: 06-04-2025 14:44:38 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[SalesOrderItem](
	[ID] [int] IDENTITY(1,1) NOT NULL,
	[EntryDate] [datetime] NULL,
	[SalesOrderNo] [nvarchar](500) NULL,
	[SlNo] [numeric](18, 0) NULL,
	[ItemCode] [nvarchar](500) NULL,
	[ItemName] [nvarchar](2000) NULL,
	[ArabicName] [nvarchar](500) NULL,
	[Unit] [nvarchar](50) NULL,
	[Qty] [float] NULL,
	[qtyperunit] [float] NULL,
	[Rate] [float] NULL,
	[IDiscPer] [float] NULL,
	[IDiscRate] [float] NULL,
	[DISCONINCRATE] [float] NULL,
	[Vatper] [float] NULL,
	[VatAmt] [float] NULL,
	[Amount] [float] NULL,
	[KeyFld] [nvarchar](500) NULL,
	[Remarks] [nvarchar](2000) NULL,
	[partno] [nvarchar](2000) NULL,
	[Branch] [nvarchar](500) NULL,
	[NetDiscPer] [float] NULL,
	[NetDiscAmt] [float] NULL,
	[NetVatAmt] [float] NULL,
	[DelNoteNo] [nvarchar](500) NULL,
	[SubId] [int] NULL,
	[BranchCode] [nvarchar](500) NULL,
	[BranchName] [nvarchar](500) NULL,
	[rateafterdisc] [float] NULL,
	[LineTotal] [float] NULL,
	[ModelNo] [varchar](500) NULL,
	[isDeleted] [nvarchar](50) NULL
) ON [PRIMARY]
GO