USE [master]
GO
USE [RetailPOS_DB_AR]
GO
/****** Object:  Table [dbo].[Activation]    Script Date: 20-01-2023 09:56:22 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Activation](
	[Id] [int] IDENTITY(1,1) NOT NULL,
	[HardwareID] [nchar](100) NOT NULL,
	[ActivationID] [nchar](150) NOT NULL,
 CONSTRAINT [PK_Activation] 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]

GO
/****** Object:  Table [dbo].[Bank]    Script Date: 20-01-2023 09:56:22 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Bank](
	[BankName] [nvarchar](250) NOT NULL,
 CONSTRAINT [PK_Bank] PRIMARY KEY CLUSTERED 
(
	[BankName] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[BankAccountLedger]    Script Date: 20-01-2023 09:56:22 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[BankAccountLedger](
	[Id] [int] IDENTITY(1,1) NOT NULL,
	[Date] [datetime] NULL,
	[AccNo] [nchar](50) NULL,
	[LedgerNo] [nchar](200) NULL,
	[Label] [nchar](200) NULL,
	[Debit] [decimal](18, 2) NULL,
	[Credit] [decimal](18, 2) NULL,
 CONSTRAINT [PK_BankAccountLedger] 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]

GO
/****** Object:  Table [dbo].[BankAccountRegistration]    Script Date: 20-01-2023 09:56:22 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[BankAccountRegistration](
	[AccountNo] [nchar](50) NOT NULL,
	[AccountName] [nchar](200) NULL,
	[AccountType] [nchar](100) NULL,
	[OpeningDate] [datetime] NULL,
	[BalanceAmount] [decimal](18, 2) NULL,
	[Active] [nchar](10) NULL,
	[BranchID] [int] NULL,
	[Id] [int] NULL,
 CONSTRAINT [PK_BankAccountRegistration] PRIMARY KEY CLUSTERED 
(
	[AccountNo] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[BankBranch]    Script Date: 20-01-2023 09:56:22 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[BankBranch](
	[Id] [int] NOT NULL,
	[BranchName] [nvarchar](250) NULL,
	[Address] [nvarchar](250) NULL,
	[ContactNo] [nchar](100) NULL,
	[SwiftCode] [nchar](50) NULL,
	[IFSCCode] [nchar](50) NULL,
	[BankName] [nvarchar](250) NOT NULL,
 CONSTRAINT [PK_BankBranch] 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]

GO
/****** Object:  Table [dbo].[CardProcessing]    Script Date: 20-01-2023 09:56:22 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[CardProcessing](
	[CP_ID] [int] IDENTITY(1,1) NOT NULL,
	[InvoiceID] [int] NULL,
	[PF] [decimal](18, 2) NULL,
	[Amount] [decimal](18, 4) NULL,
	[InvoiceAmount] [decimal](18, 2) NULL,
 CONSTRAINT [PK_CardProcessing] PRIMARY KEY CLUSTERED 
(
	[CP_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]

GO
/****** Object:  Table [dbo].[Category]    Script Date: 20-01-2023 09:56:22 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Category](
	[CategoryName] [nchar](200) NOT NULL,
 CONSTRAINT [PK_Category] PRIMARY KEY CLUSTERED 
(
	[CategoryName] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[ClockIN]    Script Date: 20-01-2023 09:56:22 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[ClockIN](
	[ID] [int] IDENTITY(1,1) NOT NULL,
	[UserID] [nchar](100) NULL,
	[ClockINDate] [datetime] NULL,
 CONSTRAINT [PK_ClockIN] 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]

GO
/****** Object:  Table [dbo].[ClockOUT]    Script Date: 20-01-2023 09:56:22 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[ClockOUT](
	[ID] [int] IDENTITY(1,1) NOT NULL,
	[ClockInID] [int] NULL,
	[ClockOUTDate] [datetime] NULL,
 CONSTRAINT [PK_ClockOUT] 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]

GO
/****** Object:  Table [dbo].[Company]    Script Date: 20-01-2023 09:56:22 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Company](
	[Id] [int] IDENTITY(1,1) NOT NULL,
	[CompanyName] [nvarchar](250) NOT NULL,
	[MailingName] [nvarchar](250) NULL,
	[Country] [nvarchar](250) NULL,
	[Address] [nvarchar](250) NULL,
	[City] [nchar](200) NULL,
	[State] [nchar](200) NULL,
	[PinCode] [nchar](30) NULL,
	[ContactNo] [nchar](100) NULL,
	[Fax] [nchar](100) NULL,
	[Email] [nchar](200) NULL,
	[Website] [nvarchar](max) NULL,
	[TIN] [nchar](50) NULL,
	[LicenseNo] [nchar](50) NULL,
	[ServiceTaxNo] [nvarchar](max) NULL,
	[CST] [nchar](50) NULL,
	[PAN] [nchar](100) NULL,
	[CurrencyCode] [nchar](10) NULL,
	[Currency] [nchar](100) NULL,
	[Logo] [image] NULL,
	[ShowLogo] [nchar](20) NULL,
	[CapitalAccount] [decimal](18, 2) NULL,
	[BuildingNo] [nchar](10) NULL,
	[StreetName] [nchar](150) NULL,
	[City1] [nchar](50) NULL,
	[District] [nchar](50) NULL,
	[PI] [nchar](20) NULL,
	[CRN] [nchar](20) NULL,
	[RegName] [nchar](150) NULL,
 CONSTRAINT [PK_Company] 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]

GO
/****** Object:  Table [dbo].[CreditCustomer]    Script Date: 20-01-2023 09:56:22 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[CreditCustomer](
	[CC_ID] [int] NOT NULL,
	[CreditCustomerID] [nchar](30) NOT NULL,
	[Name] [nchar](200) NULL,
	[ContactNo] [nchar](50) NULL,
	[Address] [nvarchar](max) NULL,
	[TRN] [nchar](30) NULL,
	[OpeningBalance] [decimal](18, 2) NULL,
	[OpeningBalanceType] [nchar](10) NULL,
	[RegistrationDate] [datetime] NULL,
	[Active] [nchar](10) NOT NULL,
	[CreditLimit] [decimal](18, 2) NULL,
 CONSTRAINT [PK_CreditCustomer] PRIMARY KEY CLUSTERED 
(
	[CC_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]

GO
/****** Object:  Table [dbo].[CreditCustomerLedger]    Script Date: 20-01-2023 09:56:22 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[CreditCustomerLedger](
	[Id] [int] IDENTITY(1,1) NOT NULL,
	[Date] [datetime] NULL,
	[LedgerNo] [nchar](50) NULL,
	[Label] [nchar](200) NULL,
	[Debit] [decimal](18, 2) NULL,
	[Credit] [decimal](18, 2) NULL,
	[CreditCustomer_ID] [int] NULL,
 CONSTRAINT [PK_CreditCustomerLedger] 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]

GO
/****** Object:  Table [dbo].[CreditCustomerPayment]    Script Date: 20-01-2023 09:56:22 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[CreditCustomerPayment](
	[T_ID] [int] NOT NULL,
	[TransactionID] [nchar](20) NULL,
	[Date] [datetime] NOT NULL,
	[PaymentMode] [nchar](30) NULL,
	[CreditCustomer_ID] [int] NOT NULL,
	[Amount] [decimal](18, 2) NOT NULL,
	[Remarks] [nvarchar](250) NULL,
	[PaymentModeDetails] [nvarchar](250) NULL,
 CONSTRAINT [PK_CreditCustomerPayment] PRIMARY KEY CLUSTERED 
(
	[T_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]

GO
/****** Object:  Table [dbo].[Currency]    Script Date: 20-01-2023 09:56:22 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Currency](
	[CurrencyCode] [nchar](10) NOT NULL,
	[Currencyname] [nchar](200) NOT NULL,
	[Rate] [decimal](18, 2) NOT NULL,
 CONSTRAINT [PK_CurrencyRate] PRIMARY KEY CLUSTERED 
(
	[CurrencyCode] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[Customer]    Script Date: 20-01-2023 09:56:22 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Customer](
	[CC_ID] [int] NOT NULL,
	[CustomerID] [nchar](30) NOT NULL,
	[Name] [nchar](200) NULL,
	[ContactNo] [nchar](50) NULL,
	[Address] [nvarchar](max) NULL,
	[TRN] [nchar](30) NULL,
	[RegistrationDate] [datetime] NULL,
	[Active] [nchar](10) NOT NULL,
 CONSTRAINT [PK_CashCustomer] PRIMARY KEY CLUSTERED 
(
	[CC_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]

GO
/****** Object:  Table [dbo].[CustomerMaster]    Script Date: 20-01-2023 09:56:22 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[CustomerMaster](
	[Cid] [int] NOT NULL,
	[CName] [nchar](150) NULL,
	[ContactNo] [nchar](100) NULL,
	[RS] [nchar](10) NULL,
	[RC] [nchar](10) NULL,
	[RAx] [nchar](10) NULL,
	[RAd] [nchar](10) NULL,
	[RI] [nchar](10) NULL,
	[LS] [nchar](10) NULL,
	[LC] [nchar](10) NULL,
	[LAx] [nchar](10) NULL,
	[LAd] [nchar](10) NULL,
	[LI] [nchar](10) NULL,
	[Remarks] [nchar](250) NULL,
	[RegisteredDate] [datetime] NULL,
	[Active] [nchar](10) NULL,
 CONSTRAINT [PK_CustomerMaster] PRIMARY KEY CLUSTERED 
(
	[Cid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[DiscountSetting]    Script Date: 20-01-2023 09:56:22 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[DiscountSetting](
	[Id] [int] IDENTITY(1,1) NOT NULL,
	[UserID] [nchar](100) NULL,
	[MaxDiscPerAllowed] [decimal](18, 2) NULL,
 CONSTRAINT [PK_DiscountSetting] 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]

GO
/****** Object:  Table [dbo].[EmailSetting]    Script Date: 20-01-2023 09:56:22 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[EmailSetting](
	[Id] [int] IDENTITY(1,1) NOT NULL,
	[ServerName] [nchar](150) NOT NULL,
	[SMTPAddress] [nvarchar](250) NOT NULL,
	[Username] [nchar](200) NOT NULL,
	[Password] [nchar](100) NOT NULL,
	[Port] [int] NOT NULL,
	[TLS_SSL_Required] [nchar](10) NOT NULL,
	[IsDefault] [nchar](10) NOT NULL,
	[IsActive] [nchar](10) NOT NULL,
 CONSTRAINT [PK_EmailSetting] 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]

GO
/****** Object:  Table [dbo].[Expense]    Script Date: 20-01-2023 09:56:22 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Expense](
	[ExpenseName] [nvarchar](250) NOT NULL,
	[ExpenseType] [nchar](200) NOT NULL,
 CONSTRAINT [PK_Expense_1] PRIMARY KEY CLUSTERED 
(
	[ExpenseName] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[ExpenseType]    Script Date: 20-01-2023 09:56:22 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[ExpenseType](
	[Type] [nchar](200) NOT NULL,
 CONSTRAINT [PK_ExpenseType] PRIMARY KEY CLUSTERED 
(
	[Type] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[FundDeposit]    Script Date: 20-01-2023 09:56:22 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[FundDeposit](
	[Id] [int] NOT NULL,
	[DepositerName] [nchar](150) NULL,
	[Amount] [decimal](18, 2) NULL,
	[Date] [datetime] NULL,
	[AccNo] [nchar](50) NULL,
	[Notes] [nchar](200) NULL,
 CONSTRAINT [PK_FundDeposit] 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]

GO
/****** Object:  Table [dbo].[FundTransfer]    Script Date: 20-01-2023 09:56:22 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[FundTransfer](
	[Id] [int] NOT NULL,
	[AccountTransFrom] [nchar](50) NULL,
	[AccountTransTo] [nchar](50) NULL,
	[Amount] [decimal](18, 2) NULL,
	[Date] [datetime] NULL,
	[Operator] [nchar](150) NULL,
	[Notes] [nchar](200) NULL,
 CONSTRAINT [PK_FundTransfer] 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]

GO
/****** Object:  Table [dbo].[Invoice_Payment]    Script Date: 20-01-2023 09:56:22 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Invoice_Payment](
	[IP_ID] [int] IDENTITY(1,1) NOT NULL,
	[InvoiceID] [int] NULL,
	[PaymentMode] [nchar](150) NULL,
	[Amount] [decimal](18, 2) NULL,
 CONSTRAINT [PK_Invoice_Payment] PRIMARY KEY CLUSTERED 
(
	[IP_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]

GO
/****** Object:  Table [dbo].[Invoice_Product]    Script Date: 20-01-2023 09:56:22 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Invoice_Product](
	[IPo_ID] [int] IDENTITY(1,1) NOT NULL,
	[InvoiceID] [int] NOT NULL,
	[ProductID] [int] NULL,
	[Barcode] [nchar](100) NULL,
	[MfgDate] [nchar](50) NULL,
	[ExpiryDate] [nchar](50) NULL,
	[SalesRate] [decimal](18, 2) NULL,
	[DiscountPer] [decimal](18, 2) NULL,
	[Discount] [decimal](18, 2) NULL,
	[VATPer] [decimal](18, 2) NULL,
	[VAT] [decimal](18, 2) NULL,
	[Qty] [decimal](18, 2) NULL,
	[TotalAmount] [decimal](18, 2) NULL,
	[PurchaseRate] [decimal](18, 2) NULL,
	[Margin] [decimal](18, 2) NULL,
 CONSTRAINT [PK_Invoice_Product] PRIMARY KEY CLUSTERED 
(
	[IPo_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]

GO
/****** Object:  Table [dbo].[InvoiceInfo]    Script Date: 20-01-2023 09:56:22 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[InvoiceInfo](
	[Inv_ID] [int] NOT NULL,
	[InvoiceNo] [nchar](30) NOT NULL,
	[InvoiceDate] [datetime] NOT NULL,
	[OpenID] [int] NULL,
	[CurrencyCode] [nchar](50) NULL,
	[ExchangeRate] [decimal](18, 2) NULL,
	[DiscPer] [decimal](18, 2) NULL,
	[DiscAmt] [decimal](18, 2) NULL,
	[GrandTotal] [decimal](18, 2) NULL,
	[TaxType] [nchar](20) NULL,
	[Member_ID] [nchar](50) NULL,
	[SalesmanID] [int] NULL,
	[Cash] [decimal](18, 2) NULL,
	[Change] [decimal](18, 2) NULL,
	[CustID] [int] NULL,
	[LoyaltyMemberID] [int] NULL,
	[BillNote] [nvarchar](max) NULL,
	[LP] [int] NULL,
	[QRCode] [image] NULL,
	[CName] [nchar](150) NULL,
	[CCN] [nchar](30) NULL,
	[Inv_Status] [nchar](20) NULL,
	[InvoiceType] [nvarchar](50) NULL,
	[InvoiceHash] [nvarchar](100) NULL,
	[UID] [nvarchar](100) NULL,
	[PIH] [nvarchar](100) NULL,
 CONSTRAINT [PK_InvoiceInfo] PRIMARY KEY CLUSTERED 
(
	[Inv_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]

GO
/****** Object:  Table [dbo].[Journal]    Script Date: 20-01-2023 09:56:22 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Journal](
	[ID] [int] NOT NULL,
	[DebitAccount] [nchar](200) NULL,
	[CreditAccount] [nchar](200) NULL,
	[Date] [datetime] NULL,
	[Amount] [decimal](18, 2) NULL,
	[Remarks] [nvarchar](max) NULL,
 CONSTRAINT [PK_Journal] 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]

GO
/****** Object:  Table [dbo].[LedgerBook]    Script Date: 20-01-2023 09:56:22 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[LedgerBook](
	[Id] [int] IDENTITY(1,1) NOT NULL,
	[Date] [datetime] NOT NULL,
	[Name] [nchar](200) NOT NULL,
	[AccLedger] [nchar](200) NULL,
	[LedgerNo] [nchar](200) NOT NULL,
	[Label] [nchar](200) NOT NULL,
	[Debit] [decimal](18, 2) NOT NULL,
	[Credit] [decimal](18, 2) NOT NULL,
	[PartyID] [nchar](50) NULL,
 CONSTRAINT [PK_LedgerBook] 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]

GO
/****** Object:  Table [dbo].[Logs]    Script Date: 20-01-2023 09:56:22 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Logs](
	[Id] [int] IDENTITY(1,1) NOT NULL,
	[UserID] [nchar](100) NOT NULL,
	[Operation] [nvarchar](250) NOT NULL,
	[Date] [datetime] NOT NULL,
 CONSTRAINT [PK_Logs] 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]

GO
/****** Object:  Table [dbo].[LoyaltyMember]    Script Date: 20-01-2023 09:56:22 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[LoyaltyMember](
	[MemberID] [int] NOT NULL,
	[Name] [nchar](200) NULL,
	[CardNo] [nchar](50) NULL,
	[ContactNo] [nchar](50) NULL,
	[Address] [nvarchar](max) NULL,
	[RegistrationDate] [datetime] NULL,
	[Active] [nchar](10) NULL,
 CONSTRAINT [PK_LoyaltyMember] PRIMARY KEY CLUSTERED 
(
	[MemberID] 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]

GO
/****** Object:  Table [dbo].[LoyaltyMemberLedgerBook]    Script Date: 20-01-2023 09:56:22 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[LoyaltyMemberLedgerBook](
	[Id] [int] IDENTITY(1,1) NOT NULL,
	[Date] [datetime] NOT NULL,
	[LedgerNo] [nchar](50) NOT NULL,
	[Label] [nchar](200) NOT NULL,
	[PointsEarned] [decimal](18, 2) NOT NULL,
	[PointsRedeem] [decimal](18, 2) NOT NULL,
	[MemberID] [int] NULL,
 CONSTRAINT [PK_LoyaltyMemberBook] 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]

GO
/****** Object:  Table [dbo].[LoyaltySetting]    Script Date: 20-01-2023 09:56:22 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[LoyaltySetting](
	[LoyaltyName] [nchar](150) NOT NULL,
	[Amount] [decimal](18, 2) NULL,
	[Points] [decimal](18, 2) NULL,
 CONSTRAINT [PK_LoyaltySetting] PRIMARY KEY CLUSTERED 
(
	[LoyaltyName] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[Party]    Script Date: 20-01-2023 09:56:22 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Party](
	[PT_ID] [int] NOT NULL,
	[Partyname] [nvarchar](250) NOT NULL,
	[Alias] [nchar](200) NULL,
	[Country] [nvarchar](250) NOT NULL,
	[Address] [nvarchar](250) NOT NULL,
	[City] [nchar](200) NOT NULL,
	[State] [nchar](200) NULL,
	[PinCode] [nchar](30) NULL,
	[ContactNo] [nchar](100) NOT NULL,
	[Fax] [nchar](100) NULL,
	[Email] [nchar](200) NULL,
	[TIN] [nchar](50) NULL,
	[CST] [nchar](50) NULL,
	[PAN] [nchar](50) NULL,
	[OpeningBalance] [decimal](18, 2) NOT NULL,
	[BalanceType] [nchar](20) NOT NULL,
	[CreditLimit] [decimal](18, 2) NOT NULL,
	[CreditDays] [int] NOT NULL,
 CONSTRAINT [PK_Party] PRIMARY KEY CLUSTERED 
(
	[PT_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]

GO
/****** Object:  Table [dbo].[Payment]    Script Date: 20-01-2023 09:56:22 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Payment](
	[T_ID] [int] NOT NULL,
	[TransactionID] [nchar](20) NULL,
	[Date] [datetime] NOT NULL,
	[PaymentMode] [nchar](30) NULL,
	[SupplierID] [int] NOT NULL,
	[Amount] [decimal](18, 2) NOT NULL,
	[Remarks] [nvarchar](250) NULL,
	[PaymentModeDetails] [nvarchar](250) NULL,
 CONSTRAINT [PK_Payment] PRIMARY KEY CLUSTERED 
(
	[T_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]

GO
/****** Object:  Table [dbo].[Payment_Withdraw]    Script Date: 20-01-2023 09:56:22 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Payment_Withdraw](
	[id] [int] NOT NULL,
	[AccountFrom] [nchar](50) NULL,
	[PaymentMode] [nchar](50) NULL,
	[Date] [datetime] NULL,
	[Amount] [decimal](18, 2) NULL,
	[ReceiverName] [nchar](150) NULL,
	[PhoneNo] [nchar](50) NULL,
	[Notes] [nchar](200) NULL,
 CONSTRAINT [PK_Payment_Withdraw] 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]

GO
/****** Object:  Table [dbo].[Payroll]    Script Date: 20-01-2023 09:56:22 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Payroll](
	[ID] [int] NOT NULL,
	[PaymentID] [nchar](30) NULL,
	[PaymentDate] [datetime] NULL,
	[PaymentMode] [nchar](150) NULL,
	[UserID] [nchar](100) NULL,
	[Rate] [decimal](18, 2) NULL,
	[Hours] [int] NULL,
	[GrossSalary] [decimal](18, 2) NULL,
	[CPPPer] [decimal](18, 2) NULL,
	[CPP] [decimal](18, 2) NULL,
	[EIPer] [decimal](18, 2) NULL,
	[EI] [decimal](18, 2) NULL,
	[FedTaxPer] [decimal](18, 2) NULL,
	[FedTax] [decimal](18, 2) NULL,
	[NetPay] [decimal](18, 2) NULL,
	[DateFrom] [datetime] NULL,
	[DateTo] [datetime] NULL,
	[Remarks] [nchar](250) NULL,
 CONSTRAINT [PK_Payroll] 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]

GO
/****** Object:  Table [dbo].[Payroll_MB]    Script Date: 20-01-2023 09:56:22 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Payroll_MB](
	[ID] [int] NOT NULL,
	[PaymentID] [nchar](30) NULL,
	[PaymentDate] [datetime] NULL,
	[PaymentMode] [nchar](150) NULL,
	[UserID] [nchar](100) NULL,
	[GrossSalary] [decimal](18, 2) NULL,
	[CPPPer] [decimal](18, 2) NULL,
	[CPP] [decimal](18, 2) NULL,
	[EIPer] [decimal](18, 2) NULL,
	[EI] [decimal](18, 2) NULL,
	[FedTaxPer] [decimal](18, 2) NULL,
	[FedTax] [decimal](18, 2) NULL,
	[NetPay] [decimal](18, 2) NULL,
	[Month] [nchar](30) NULL,
	[Year] [int] NULL,
	[Remarks] [nchar](250) NULL,
 CONSTRAINT [PK_Payroll_MB] 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]

GO
/****** Object:  Table [dbo].[POS_ClosingCash]    Script Date: 20-01-2023 09:56:22 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[POS_ClosingCash](
	[ClosingID] [int] NOT NULL,
	[OpenID] [int] NOT NULL,
	[ClosingDate] [datetime] NULL,
	[ClosingBalance] [decimal](18, 2) NULL,
 CONSTRAINT [PK_POS_ClosingCash] PRIMARY KEY CLUSTERED 
(
	[ClosingID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[POS_HoldBill]    Script Date: 20-01-2023 09:56:22 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[POS_HoldBill](
	[Hold_ID] [nchar](20) NOT NULL,
	[OpenID] [int] NULL,
	[Date] [datetime] NULL,
	[DiscPer] [decimal](18, 2) NULL,
	[DiscAmt] [decimal](18, 2) NULL,
 CONSTRAINT [PK_POS_HoldBill] PRIMARY KEY CLUSTERED 
(
	[Hold_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]

GO
/****** Object:  Table [dbo].[POS_HoldBillItems]    Script Date: 20-01-2023 09:56:22 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[POS_HoldBillItems](
	[HBI_ID] [int] IDENTITY(1,1) NOT NULL,
	[HoldID] [nchar](20) NULL,
	[ProductID] [int] NULL,
	[Barcode] [nchar](100) NULL,
	[MfgDate] [nchar](50) NULL,
	[ExpiryDate] [nchar](50) NULL,
	[SalesRate] [decimal](18, 2) NULL,
	[DiscountPer] [decimal](18, 2) NULL,
	[Discount] [decimal](18, 2) NULL,
	[VATPer] [decimal](18, 2) NULL,
	[VAT] [decimal](18, 2) NULL,
	[Qty] [decimal](18, 2) NULL,
	[TotalAmount] [decimal](18, 2) NULL,
	[PurchaseRate] [decimal](18, 2) NULL,
	[Margin] [decimal](18, 2) NULL,
	[MarginPer] [decimal](18, 2) NULL,
 CONSTRAINT [PK_POS_HoldBillItems] PRIMARY KEY CLUSTERED 
(
	[HBI_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]

GO
/****** Object:  Table [dbo].[POS_OpeningCash]    Script Date: 20-01-2023 09:56:22 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[POS_OpeningCash](
	[OpenID] [int] NOT NULL,
	[TillDetails] [nchar](100) NULL,
	[UserID] [nchar](100) NOT NULL,
	[OpeningDate] [datetime] NULL,
	[Closed] [int] NULL,
	[OpeningCash] [decimal](18, 2) NULL,
 CONSTRAINT [PK_POS_OpeningCash] PRIMARY KEY CLUSTERED 
(
	[OpenID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[PosPrinterSetting]    Script Date: 20-01-2023 09:56:22 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[PosPrinterSetting](
	[Id] [int] IDENTITY(1,1) NOT NULL,
	[PrinterName] [nvarchar](250) NOT NULL,
	[IsEnabled] [nchar](20) NOT NULL,
	[TillID] [nchar](100) NULL,
	[CashDrawer] [nchar](20) NULL,
	[CustomerDisplay] [nchar](20) NULL,
	[CDPort] [nchar](30) NULL,
	[WS] [nchar](30) NULL,
	[WSPortNo] [nchar](30) NULL,
	[PT] [nchar](30) NULL,
	[PTipAddress] [nchar](100) NULL,
	[PTPortNo] [nchar](30) NULL,
	[CCD] [nchar](30) NULL,
 CONSTRAINT [PK_PosPrinterSetting] 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]

GO
/****** Object:  Table [dbo].[Product]    Script Date: 20-01-2023 09:56:22 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Product](
	[PID] [int] NOT NULL,
	[ProductCode] [nchar](50) NOT NULL,
	[ProductName] [nvarchar](max) NOT NULL,
	[Alias] [nchar](150) NULL,
	[VATCommodity] [nchar](200) NULL,
	[Description] [nvarchar](max) NULL,
	[Barcode] [nchar](100) NULL,
	[Category] [nchar](200) NULL,
	[PurchaseUnit] [nchar](30) NULL,
	[SalesUnit] [nchar](30) NULL,
	[PurchaseCost] [decimal](18, 2) NULL,
	[SalesCost] [decimal](18, 2) NULL,
	[ReorderPoint] [int] NULL,
	[AddedDate] [datetime] NULL,
	[MarginPer] [decimal](18, 2) NULL,
	[ImagePath] [nvarchar](max) NULL,
	[ShowPS] [nchar](30) NULL,
	[ButtonUIColor] [int] NULL,
	[A1] [nchar](10) NULL,
	[A2] [nchar](10) NULL,
	[A3] [nchar](10) NULL,
	[A4] [nchar](10) NULL,
	[A5] [nchar](10) NULL,
	[B1] [nchar](50) NULL,
	[B2] [nchar](50) NULL,
	[B3] [nchar](50) NULL,
	[B4] [nchar](50) NULL,
	[B5] [nchar](50) NULL,
	[P1] [decimal](18, 2) NULL,
	[P2] [decimal](18, 2) NULL,
	[P3] [decimal](18, 2) NULL,
	[P4] [decimal](18, 2) NULL,
	[P5] [decimal](18, 2) NULL,
	[Q1] [int] NULL,
	[Q2] [int] NULL,
	[Q3] [int] NULL,
	[Q4] [int] NULL,
	[Q5] [int] NULL,
 CONSTRAINT [PK_Product] PRIMARY KEY CLUSTERED 
(
	[PID] 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]

GO
/****** Object:  Table [dbo].[Product_OpeningStock]    Script Date: 20-01-2023 09:56:22 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Product_OpeningStock](
	[PS_ID] [int] IDENTITY(1,1) NOT NULL,
	[ProductID] [int] NOT NULL,
	[StorageType] [nchar](20) NULL,
	[Warehouse_Store] [nchar](250) NULL,
	[Qty] [decimal](18, 2) NULL,
	[ExpiryDate] [nchar](50) NULL,
	[ManufacturingDate] [nchar](50) NULL,
 CONSTRAINT [PK_Product_OpeningStock] PRIMARY KEY CLUSTERED 
(
	[PS_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]

GO
/****** Object:  Table [dbo].[ProductLocation]    Script Date: 20-01-2023 09:56:22 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[ProductLocation](
	[ID] [int] IDENTITY(1,1) NOT NULL,
	[RackNo] [nchar](50) NULL,
	[ProductID] [int] NULL,
	[ShelfPosition] [nchar](20) NULL,
 CONSTRAINT [PK_ProductLocation] 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]

GO
/****** Object:  Table [dbo].[Purchase]    Script Date: 20-01-2023 09:56:22 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Purchase](
	[ST_ID] [int] NOT NULL,
	[InvoiceNo] [nchar](30) NOT NULL,
	[Date] [datetime] NOT NULL,
	[PurchaseType] [nchar](20) NOT NULL,
	[Supplier_ID] [int] NOT NULL,
	[SubTotal] [decimal](18, 2) NOT NULL,
	[DiscountPer] [decimal](18, 2) NOT NULL,
	[Discount] [decimal](18, 2) NOT NULL,
	[PreviousDue] [decimal](18, 2) NOT NULL,
	[FreightCharges] [decimal](18, 2) NOT NULL,
	[OtherCharges] [decimal](18, 2) NOT NULL,
	[Total] [decimal](18, 2) NOT NULL,
	[RoundOff] [decimal](18, 2) NOT NULL,
	[GrandTotal] [decimal](18, 2) NOT NULL,
	[TotalPayment] [decimal](18, 2) NOT NULL,
	[PaymentDue] [decimal](18, 2) NOT NULL,
	[Remarks] [nvarchar](max) NULL,
	[VATPer] [decimal](18, 2) NULL,
	[VAT] [decimal](18, 2) NULL,
	[ReferenceNo1] [nchar](50) NULL,
	[ReferenceNo2] [nchar](50) NULL,
	[SupplierInvoiceNo] [nchar](50) NULL,
	[SupplierInvoiceDate] [datetime] NULL,
	[TaxType] [nchar](20) NULL,
 CONSTRAINT [PK_Purchase] PRIMARY KEY CLUSTERED 
(
	[ST_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]

GO
/****** Object:  Table [dbo].[Purchase_Join]    Script Date: 20-01-2023 09:56:22 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Purchase_Join](
	[SP_ID] [int] IDENTITY(1,1) NOT NULL,
	[PurchaseID] [int] NOT NULL,
	[ProductID] [int] NOT NULL,
	[Qty] [decimal](18, 2) NOT NULL,
	[Price] [decimal](18, 2) NOT NULL,
	[TotalAmount] [decimal](18, 2) NOT NULL,
	[StorageType] [nchar](20) NULL,
	[Warehouse_Store] [nchar](250) NOT NULL,
	[SalesCost] [decimal](18, 2) NULL,
	[Barcode] [nchar](50) NULL,
	[ExpiryDate] [nchar](50) NULL,
	[ManufacturingDate] [nchar](30) NULL,
	[RackNo] [nchar](50) NULL,
 CONSTRAINT [PK_Purchase_Join] PRIMARY KEY CLUSTERED 
(
	[SP_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]

GO
/****** Object:  Table [dbo].[PurchaseOrder]    Script Date: 20-01-2023 09:56:22 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[PurchaseOrder](
	[PO_ID] [int] NOT NULL,
	[PONumber] [nchar](50) NOT NULL,
	[Date] [datetime] NULL,
	[Supplier_ID] [int] NULL,
	[Terms] [nvarchar](max) NULL,
	[SubTotal] [decimal](18, 2) NULL,
	[VATPer] [decimal](18, 2) NULL,
	[VATAmount] [decimal](18, 2) NULL,
	[GrandTotal] [decimal](18, 2) NULL,
	[TaxType] [nchar](20) NULL,
 CONSTRAINT [PK_PurchaseOrder] PRIMARY KEY CLUSTERED 
(
	[PO_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]

GO
/****** Object:  Table [dbo].[PurchaseOrder_Join]    Script Date: 20-01-2023 09:56:22 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[PurchaseOrder_Join](
	[POJ_ID] [int] IDENTITY(1,1) NOT NULL,
	[PurchaseOrderID] [int] NOT NULL,
	[ProductID] [int] NOT NULL,
	[Qty] [decimal](18, 2) NOT NULL,
	[PricePerUnit] [decimal](18, 2) NULL,
	[Amount] [decimal](18, 2) NULL,
 CONSTRAINT [PK_PurchaseOrder_Join] PRIMARY KEY CLUSTERED 
(
	[POJ_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]

GO
/****** Object:  Table [dbo].[PurchaseReturn]    Script Date: 20-01-2023 09:56:22 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[PurchaseReturn](
	[PR_ID] [int] NOT NULL,
	[PRNo] [nchar](30) NULL,
	[Date] [datetime] NULL,
	[PurchaseID] [int] NULL,
	[SubTotal] [decimal](18, 2) NULL,
	[DiscPer] [decimal](18, 2) NULL,
	[Discount] [decimal](18, 2) NULL,
	[VATPer] [decimal](18, 2) NULL,
	[VATAmt] [decimal](18, 2) NULL,
	[FreightCharges] [decimal](18, 2) NULL,
	[OtherCharges] [decimal](18, 2) NULL,
	[Total] [decimal](18, 2) NULL,
	[RoundOff] [decimal](18, 2) NULL,
	[GrandTotal] [decimal](18, 2) NULL,
 CONSTRAINT [PK_PurchaseReturn] PRIMARY KEY CLUSTERED 
(
	[PR_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]

GO
/****** Object:  Table [dbo].[PurchaseReturn_Join]    Script Date: 20-01-2023 09:56:22 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[PurchaseReturn_Join](
	[PRJ_ID] [int] IDENTITY(1,1) NOT NULL,
	[PurchaseReturnID] [int] NOT NULL,
	[ProductID] [int] NULL,
	[Qty] [decimal](18, 2) NULL,
	[Price] [decimal](18, 2) NULL,
	[TotalAmount] [decimal](18, 2) NULL,
	[Warehouse_Store] [nchar](250) NULL,
	[SalesCost] [decimal](18, 2) NULL,
	[Barcode] [nchar](50) NULL,
	[ExpiryDate] [nchar](50) NULL,
	[ManufacturingDate] [nchar](30) NULL,
	[ReturnQty] [decimal](18, 2) NULL,
	[StorageType] [nchar](20) NULL,
 CONSTRAINT [PK_PurchaseReturn_Join] PRIMARY KEY CLUSTERED 
(
	[PRJ_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]

GO
/****** Object:  Table [dbo].[Racking]    Script Date: 20-01-2023 09:56:22 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Racking](
	[RackNo] [nchar](50) NOT NULL,
	[NoOfShelves] [int] NULL,
	[Active] [nchar](10) NULL,
 CONSTRAINT [PK_Racking] PRIMARY KEY CLUSTERED 
(
	[RackNo] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[Registration]    Script Date: 20-01-2023 09:56:22 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Registration](
	[UserID] [nchar](100) NOT NULL,
	[UserType] [nchar](30) NOT NULL,
	[Password] [nchar](50) NOT NULL,
	[Name] [nchar](150) NOT NULL,
	[ContactNo] [nchar](50) NULL,
	[SSN] [nchar](30) NULL,
	[EmailID] [nchar](150) NULL,
	[JoiningDate] [datetime] NOT NULL,
	[Active] [nchar](10) NULL,
	[PayrollType] [nchar](30) NULL,
 CONSTRAINT [PK_Registration] PRIMARY KEY CLUSTERED 
(
	[UserID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[Sales]    Script Date: 20-01-2023 09:56:22 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Sales](
	[SalesID] [int] NOT NULL,
	[BillNo] [nchar](30) NOT NULL,
	[BillDate] [datetime] NOT NULL,
	[BillShamsiDate] [datetime] NOT NULL,
	[RefNo1] [nchar](50) NULL,
	[RefNo2] [nchar](50) NULL,
	[SalesType] [nchar](20) NOT NULL,
	[UserOperator] [nchar](100) NOT NULL,
	[PartyID] [int] NOT NULL,
	[SubTotal] [decimal](18, 2) NOT NULL,
	[DiscountPer] [decimal](18, 2) NOT NULL,
	[Discount] [decimal](18, 2) NOT NULL,
	[FreightCharges] [decimal](18, 2) NOT NULL,
	[OtherCharges] [decimal](18, 2) NOT NULL,
	[PreviousDue] [decimal](18, 2) NOT NULL,
	[Total] [decimal](18, 2) NOT NULL,
	[RoundOff] [decimal](18, 2) NOT NULL,
	[GrandTotal] [decimal](18, 2) NOT NULL,
	[TotalPaid] [decimal](18, 2) NOT NULL,
	[Balance] [decimal](18, 2) NOT NULL,
	[Remarks] [nvarchar](max) NULL,
 CONSTRAINT [PK_Sales] PRIMARY KEY CLUSTERED 
(
	[SalesID] 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]

GO
/****** Object:  Table [dbo].[Sales_Product]    Script Date: 20-01-2023 09:56:22 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Sales_Product](
	[SP_ID] [int] IDENTITY(1,1) NOT NULL,
	[SalesID] [int] NOT NULL,
	[ProductID] [int] NOT NULL,
	[Warehouse] [nchar](250) NOT NULL,
	[QtyPerCarton] [int] NOT NULL,
	[TotalQty] [int] NOT NULL,
	[PricePerQtyBC] [decimal](18, 2) NOT NULL,
	[CurrencyCode] [nchar](10) NOT NULL,
	[Total_SalesdCurrency] [decimal](18, 2) NOT NULL,
	[ExchangeRate] [decimal](18, 2) NOT NULL,
	[PricePerQty] [decimal](18, 2) NOT NULL,
	[Total_QuotedCurrency] [decimal](18, 2) NOT NULL,
	[DiscountPer] [decimal](18, 2) NOT NULL,
	[Discount] [decimal](18, 2) NOT NULL,
	[VATPer] [decimal](18, 2) NOT NULL,
	[VAT] [decimal](18, 2) NOT NULL,
	[AdditionalVAT] [decimal](18, 2) NOT NULL,
	[AdditionalVATPer] [decimal](18, 2) NOT NULL,
	[TotalAmount] [decimal](18, 2) NOT NULL,
 CONSTRAINT [PK_Sales_Product] PRIMARY KEY CLUSTERED 
(
	[SP_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]

GO
/****** Object:  Table [dbo].[SalesMan]    Script Date: 20-01-2023 09:56:22 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[SalesMan](
	[SM_ID] [int] NOT NULL,
	[SalesMan_ID] [nchar](30) NULL,
	[Name] [nchar](200) NULL,
	[Address] [nvarchar](250) NULL,
	[City] [nchar](200) NULL,
	[State] [nchar](150) NULL,
	[ZipCode] [nchar](15) NULL,
	[ContactNo] [nchar](150) NULL,
	[EmailID] [nchar](200) NULL,
	[Remarks] [nvarchar](max) NULL,
	[Photo] [image] NULL,
	[CommissionPer] [decimal](18, 2) NULL,
 CONSTRAINT [PK_SalesMan] PRIMARY KEY CLUSTERED 
(
	[SM_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]

GO
/****** Object:  Table [dbo].[Salesman_Commission]    Script Date: 20-01-2023 09:56:22 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Salesman_Commission](
	[ID] [int] IDENTITY(1,1) NOT NULL,
	[InvoiceID] [int] NOT NULL,
	[CommissionPer] [decimal](18, 2) NOT NULL,
	[Commission] [decimal](18, 2) NOT NULL,
 CONSTRAINT [PK_Salesman_Commission] 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]

GO
/****** Object:  Table [dbo].[SalesReturn]    Script Date: 20-01-2023 09:56:22 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[SalesReturn](
	[SR_ID] [int] NOT NULL,
	[SRNo] [nchar](50) NULL,
	[Date] [date] NULL,
	[SalesID] [int] NULL,
	[SubTotal] [decimal](18, 2) NULL,
	[VAT] [decimal](18, 2) NULL,
	[GrandTotal] [decimal](18, 2) NULL,
 CONSTRAINT [PK_SalesReturn] PRIMARY KEY CLUSTERED 
(
	[SR_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]

GO
/****** Object:  Table [dbo].[SalesReturn_Join]    Script Date: 20-01-2023 09:56:22 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[SalesReturn_Join](
	[SRJ_ID] [int] IDENTITY(1,1) NOT NULL,
	[SalesReturnID] [int] NOT NULL,
	[ProductID] [int] NULL,
	[Barcode] [nchar](50) NULL,
	[ManufacturingDate] [nchar](30) NULL,
	[ExpiryDate] [nchar](50) NULL,
	[Qty] [decimal](18, 2) NULL,
	[SalesCost] [decimal](18, 2) NULL,
	[DiscPer] [decimal](18, 2) NULL,
	[DiscAmt] [decimal](18, 2) NULL,
	[CGSTPer] [decimal](18, 2) NULL,
	[CGSTAmt] [decimal](18, 2) NULL,
	[ReturnQty] [decimal](18, 2) NULL,
	[TotalAmount] [decimal](18, 2) NULL,
 CONSTRAINT [PK_SalesReturn_Join] PRIMARY KEY CLUSTERED 
(
	[SRJ_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]

GO
/****** Object:  Table [dbo].[Setting]    Script Date: 20-01-2023 09:56:22 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Setting](
	[ID] [int] IDENTITY(1,1) NOT NULL,
	[PurchaseTax] [nchar](20) NOT NULL,
	[SalesTax] [nchar](20) NOT NULL,
 CONSTRAINT [PK_PurchaseSetting] 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]

GO
/****** Object:  Table [dbo].[SMS]    Script Date: 20-01-2023 09:56:22 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[SMS](
	[Id] [int] IDENTITY(1,1) NOT NULL,
	[SMS] [nvarchar](max) NULL,
 CONSTRAINT [PK_SMS] 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]

GO
/****** Object:  Table [dbo].[SMSSetting]    Script Date: 20-01-2023 09:56:22 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[SMSSetting](
	[Id] [int] IDENTITY(1,1) NOT NULL,
	[APIURL] [nvarchar](max) NOT NULL,
	[IsDefault] [nchar](10) NOT NULL,
	[IsEnabled] [nchar](10) NOT NULL,
 CONSTRAINT [PK_SMSSetting] 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]

GO
/****** Object:  Table [dbo].[StockAdjustment_Store]    Script Date: 20-01-2023 09:56:22 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[StockAdjustment_Store](
	[SA_ID] [int] NOT NULL,
	[ProductID] [int] NULL,
	[Barcode] [nchar](30) NULL,
	[Date] [datetime] NULL,
	[AdjustmentType] [nchar](20) NULL,
	[Qty] [decimal](18, 2) NULL,
	[Reason] [nchar](200) NULL,
 CONSTRAINT [PK_StockAdjustment_Store] PRIMARY KEY CLUSTERED 
(
	[SA_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]

GO
/****** Object:  Table [dbo].[StockAdjustment_Warehouse]    Script Date: 20-01-2023 09:56:22 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[StockAdjustment_Warehouse](
	[SA_ID] [int] NOT NULL,
	[Date] [datetime] NULL,
	[Warehouse] [nchar](250) NULL,
	[ProductID] [int] NULL,
	[Barcode] [nchar](30) NULL,
	[AdjustmentType] [nchar](20) NULL,
	[Qty] [decimal](18, 2) NULL,
	[Reason] [nchar](200) NULL,
 CONSTRAINT [PK_StockAdjustment_Warehouse] PRIMARY KEY CLUSTERED 
(
	[SA_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]

GO
/****** Object:  Table [dbo].[StockTransfer]    Script Date: 20-01-2023 09:56:22 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[StockTransfer](
	[ST_ID] [int] NOT NULL,
	[TransferID] [nchar](30) NULL,
	[Date] [datetime] NOT NULL,
	[CompanyID] [int] NOT NULL,
 CONSTRAINT [PK_StockTransfer_1] PRIMARY KEY CLUSTERED 
(
	[ST_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]

GO
/****** Object:  Table [dbo].[StockTransfer_Join]    Script Date: 20-01-2023 09:56:22 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[StockTransfer_Join](
	[STJ_ID] [int] IDENTITY(1,1) NOT NULL,
	[StockTransferID] [int] NOT NULL,
	[Warehouse] [nchar](250) NOT NULL,
	[ProductID] [int] NOT NULL,
	[Barcode] [nchar](50) NULL,
	[SalesRate] [decimal](18, 2) NULL,
	[ManufacturingDate] [nchar](50) NULL,
	[ExpiryDate] [nchar](50) NULL,
	[Qty] [decimal](18, 2) NULL,
 CONSTRAINT [PK_StockTransfer] PRIMARY KEY CLUSTERED 
(
	[STJ_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]

GO
/****** Object:  Table [dbo].[StockTransfer_Join_S2W]    Script Date: 20-01-2023 09:56:22 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[StockTransfer_Join_S2W](
	[STJ_ID] [int] IDENTITY(1,1) NOT NULL,
	[StockTransferID] [int] NOT NULL,
	[ProductID] [int] NOT NULL,
	[Barcode] [nchar](50) NULL,
	[SalesRate] [decimal](18, 2) NULL,
	[ManufacturingDate] [nchar](50) NULL,
	[ExpiryDate] [nchar](50) NULL,
	[Qty] [decimal](18, 2) NULL,
 CONSTRAINT [PK_StockTransfer_S2W] PRIMARY KEY CLUSTERED 
(
	[STJ_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]

GO
/****** Object:  Table [dbo].[StockTransfer_Join_W2W]    Script Date: 20-01-2023 09:56:22 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[StockTransfer_Join_W2W](
	[STJ_ID] [int] IDENTITY(1,1) NOT NULL,
	[StockTransferID] [int] NOT NULL,
	[Warehouse] [nchar](250) NOT NULL,
	[ProductID] [int] NOT NULL,
	[Barcode] [nchar](50) NULL,
	[SalesRate] [decimal](18, 2) NULL,
	[ManufacturingDate] [nchar](50) NULL,
	[ExpiryDate] [nchar](50) NULL,
	[Qty] [decimal](18, 2) NULL,
 CONSTRAINT [PK_StockTransfer_W2W] PRIMARY KEY CLUSTERED 
(
	[STJ_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]

GO
/****** Object:  Table [dbo].[StockTransfer_S2W]    Script Date: 20-01-2023 09:56:22 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[StockTransfer_S2W](
	[ST_ID] [int] NOT NULL,
	[TransferID] [nchar](30) NULL,
	[Date] [datetime] NOT NULL,
	[Warehouse] [nchar](250) NOT NULL,
 CONSTRAINT [PK_StockTransfer_S2W_1] PRIMARY KEY CLUSTERED 
(
	[ST_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]

GO
/****** Object:  Table [dbo].[StockTransfer_W2W]    Script Date: 20-01-2023 09:56:22 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[StockTransfer_W2W](
	[ST_ID] [int] NOT NULL,
	[TransferID] [nchar](30) NULL,
	[Date] [datetime] NOT NULL,
	[Warehouse] [nchar](250) NOT NULL,
 CONSTRAINT [PK_StockTransfer_W2W_1] PRIMARY KEY CLUSTERED 
(
	[ST_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]

GO
/****** Object:  Table [dbo].[Supplier]    Script Date: 20-01-2023 09:56:22 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Supplier](
	[ID] [int] NOT NULL,
	[SupplierID] [nchar](30) NOT NULL,
	[Name] [nchar](200) NULL,
	[Address] [nvarchar](250) NULL,
	[City] [nchar](200) NULL,
	[State] [nchar](150) NULL,
	[ZipCode] [nchar](15) NULL,
	[ContactNo] [nchar](150) NULL,
	[EmailID] [nchar](200) NULL,
	[Remarks] [nvarchar](max) NULL,
	[TIN] [nchar](100) NULL,
	[STNo] [nchar](100) NULL,
	[CST] [nchar](100) NULL,
	[PAN] [nchar](100) NULL,
	[AccountName] [nchar](150) NULL,
	[AccountNumber] [nchar](100) NULL,
	[Bank] [nchar](150) NULL,
	[Branch] [nchar](150) NULL,
	[IFSCCode] [nchar](50) NULL,
	[OpeningBalance] [decimal](18, 2) NULL,
	[OpeningBalanceType] [nchar](20) NULL,
 CONSTRAINT [PK_Supplier] 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]

GO
/****** Object:  Table [dbo].[SupplierLedgerBook]    Script Date: 20-01-2023 09:56:22 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[SupplierLedgerBook](
	[Id] [int] IDENTITY(1,1) NOT NULL,
	[Date] [datetime] NOT NULL,
	[Name] [nchar](200) NOT NULL,
	[LedgerNo] [nchar](50) NOT NULL,
	[Label] [nchar](200) NOT NULL,
	[Debit] [decimal](18, 2) NOT NULL,
	[Credit] [decimal](18, 2) NOT NULL,
	[PartyID] [nchar](20) NULL,
 CONSTRAINT [PK_SupplierLedgerBook] 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]

GO
/****** Object:  Table [dbo].[TaxMaster]    Script Date: 20-01-2023 09:56:22 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TaxMaster](
	[TaxName] [nchar](200) NOT NULL,
	[TaxType] [nchar](200) NOT NULL,
	[Percentage] [decimal](18, 2) NOT NULL,
	[AdditionalPercentage] [decimal](18, 2) NOT NULL,
 CONSTRAINT [PK_TaxMaster] PRIMARY KEY CLUSTERED 
(
	[TaxName] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[TaxType]    Script Date: 20-01-2023 09:56:22 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TaxType](
	[Type] [nchar](200) NOT NULL,
 CONSTRAINT [PK_TaxType] PRIMARY KEY CLUSTERED 
(
	[Type] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[Temp_Stock]    Script Date: 20-01-2023 09:56:22 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Temp_Stock](
	[Id] [int] IDENTITY(1,1) NOT NULL,
	[ProductID] [int] NOT NULL,
	[Warehouse] [nchar](250) NOT NULL,
	[Barcode] [nchar](30) NULL,
	[PurchaseRate] [decimal](18, 2) NULL,
	[SalesRate] [decimal](18, 2) NULL,
	[Qty] [decimal](18, 2) NULL,
	[ExpiryDate] [nchar](50) NULL,
	[ManufacturingDate] [nchar](50) NULL,
 CONSTRAINT [PK_Temp_Stock] 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]

GO
/****** Object:  Table [dbo].[Temp_Stock_Company]    Script Date: 20-01-2023 09:56:22 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Temp_Stock_Company](
	[Id] [int] IDENTITY(1,1) NOT NULL,
	[ProductID] [int] NOT NULL,
	[Barcode] [nchar](30) NULL,
	[PurchaseRate] [decimal](18, 2) NULL,
	[SalesRate] [decimal](18, 2) NULL,
	[ManufacturingDate] [nchar](30) NULL,
	[ExpiryDate] [nchar](30) NULL,
	[Qty] [decimal](18, 2) NULL,
 CONSTRAINT [PK_Temp_Stock_Store] 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]

GO
/****** Object:  Table [dbo].[UnitMaster]    Script Date: 20-01-2023 09:56:22 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[UnitMaster](
	[Unit] [nchar](150) NOT NULL,
 CONSTRAINT [PK_UnitMaster] PRIMARY KEY CLUSTERED 
(
	[Unit] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[UserRights]    Script Date: 20-01-2023 09:56:22 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[UserRights](
	[ID] [int] IDENTITY(1,1) NOT NULL,
	[ModuleName] [nchar](200) NULL,
	[UR_Save] [bit] NULL,
	[UR_Update] [bit] NULL,
	[UR_Delete] [bit] NULL,
	[UR_View] [bit] NULL,
	[UserID] [nchar](100) NULL,
	[ModuleName_AR] [nchar](200) NULL,
 CONSTRAINT [PK_UserRights] 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]

GO
/****** Object:  Table [dbo].[Voucher]    Script Date: 20-01-2023 09:56:22 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Voucher](
	[ID] [int] NOT NULL,
	[VoucherNo] [nchar](30) NOT NULL,
	[Name] [nchar](150) NULL,
	[Date] [datetime] NOT NULL,
	[Details] [nvarchar](max) NULL,
	[PaymentMode] [nchar](150) NOT NULL,
	[SubTotal] [decimal](18, 2) NULL,
	[VATPer] [decimal](18, 2) NULL,
	[VAT] [decimal](18, 2) NULL,
	[GrandTotal] [decimal](18, 2) NOT NULL,
 CONSTRAINT [PK_Voucher] 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]

GO
/****** Object:  Table [dbo].[Voucher_OtherDetails]    Script Date: 20-01-2023 09:56:22 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Voucher_OtherDetails](
	[VD_ID] [int] IDENTITY(1,1) NOT NULL,
	[VoucherID] [int] NOT NULL,
	[Particulars] [nvarchar](250) NOT NULL,
	[Amount] [decimal](18, 2) NOT NULL,
	[Note] [nvarchar](max) NULL,
 CONSTRAINT [PK_Voucher_OtherDetails] PRIMARY KEY CLUSTERED 
(
	[VD_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]

GO
/****** Object:  Table [dbo].[Wallet]    Script Date: 20-01-2023 09:56:22 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Wallet](
	[WalletType] [nchar](200) NOT NULL,
 CONSTRAINT [PK_Wallet] PRIMARY KEY CLUSTERED 
(
	[WalletType] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[Warehouse]    Script Date: 20-01-2023 09:56:22 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Warehouse](
	[WarehouseName] [nchar](250) NOT NULL,
	[Address] [nvarchar](250) NOT NULL,
	[WarehouseType] [nchar](200) NOT NULL,
	[City] [nchar](200) NOT NULL,
 CONSTRAINT [PK_Warehouse] PRIMARY KEY CLUSTERED 
(
	[WarehouseName] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
/****** Object:  Table [dbo].[WarehouseType]    Script Date: 20-01-2023 09:56:22 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[WarehouseType](
	[Type] [nchar](200) NOT NULL,
 CONSTRAINT [PK_WarehouseType] PRIMARY KEY CLUSTERED 
(
	[Type] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
INSERT [dbo].[Registration] ([UserID], [UserType], [Password], [Name], [ContactNo], [SSN], [EmailID], [JoiningDate], [Active], [PayrollType]) VALUES (N'admin                                                                                               ', N'Admin                         ', N'MTIzNA==                                          ', N'Mohandiss Computers                                                                                                                                                 ', N'0533515181                                        ', N'123-45-6790                   ', N'Mohandiss@hotmail.com                                                                                                                                   ', CAST(N'2018-01-07 06:29:32.050' AS DateTime), N'Yes       ', N'Hourly Basis                  ')
SET IDENTITY_INSERT [dbo].[Setting] ON 

INSERT [dbo].[Setting] ([ID], [PurchaseTax], [SalesTax]) VALUES (1, N'Exclusive           ', N'Exclusive           ')
SET IDENTITY_INSERT [dbo].[Setting] OFF
INSERT [dbo].[TaxType] ([Type]) VALUES (N'VAT                                                                                                                                                                                                     ')
SET IDENTITY_INSERT [dbo].[UserRights] ON 

INSERT [dbo].[UserRights] ([ID], [ModuleName], [UR_Save], [UR_Update], [UR_Delete], [UR_View], [UserID], [ModuleName_AR]) VALUES (1, N'Company Master                                                                                                                                                                                          ', 1, 1, 1, 1, N'admin                                                                                               ', N'بيانات الشركه                                                                                                                                                                                           ')
INSERT [dbo].[UserRights] ([ID], [ModuleName], [UR_Save], [UR_Update], [UR_Delete], [UR_View], [UserID], [ModuleName_AR]) VALUES (2, N'Settings                                                                                                                                                                                                ', 1, 1, 1, 1, N'admin                                                                                               ', N'الاعدادات                                                                                                                                                                                               ')
INSERT [dbo].[UserRights] ([ID], [ModuleName], [UR_Save], [UR_Update], [UR_Delete], [UR_View], [UserID], [ModuleName_AR]) VALUES (3, N'Registration                                                                                                                                                                                            ', 1, 1, 1, 1, N'admin                                                                                               ', N'التسجيل                                                                                                                                                                                                 ')
INSERT [dbo].[UserRights] ([ID], [ModuleName], [UR_Save], [UR_Update], [UR_Delete], [UR_View], [UserID], [ModuleName_AR]) VALUES (4, N'Logs                                                                                                                                                                                                    ', 0, 0, 1, 1, N'admin                                                                                               ', N'السجلات                                                                                                                                                                                                 ')
INSERT [dbo].[UserRights] ([ID], [ModuleName], [UR_Save], [UR_Update], [UR_Delete], [UR_View], [UserID], [ModuleName_AR]) VALUES (5, N'Wallet                                                                                                                                                                                                  ', 1, 1, 1, 1, N'admin                                                                                               ', N'المحفظه                                                                                                                                                                                                 ')
INSERT [dbo].[UserRights] ([ID], [ModuleName], [UR_Save], [UR_Update], [UR_Delete], [UR_View], [UserID], [ModuleName_AR]) VALUES (6, N'Loyalty Card                                                                                                                                                                                            ', 1, 1, 1, 1, N'admin                                                                                               ', N'بطاقة الولاء                                                                                                                                                                                            ')
INSERT [dbo].[UserRights] ([ID], [ModuleName], [UR_Save], [UR_Update], [UR_Delete], [UR_View], [UserID], [ModuleName_AR]) VALUES (7, N'Category                                                                                                                                                                                                ', 1, 1, 1, 1, N'admin                                                                                               ', N'الاقسام                                                                                                                                                                                                 ')
INSERT [dbo].[UserRights] ([ID], [ModuleName], [UR_Save], [UR_Update], [UR_Delete], [UR_View], [UserID], [ModuleName_AR]) VALUES (8, N'Salesman Master                                                                                                                                                                                         ', 1, 1, 1, 1, N'admin                                                                                               ', N'البائع الرئيسي                                                                                                                                                                                          ')
INSERT [dbo].[UserRights] ([ID], [ModuleName], [UR_Save], [UR_Update], [UR_Delete], [UR_View], [UserID], [ModuleName_AR]) VALUES (9, N'Bank Reconciliation                                                                                                                                                                                     ', 1, 1, 1, 1, N'admin                                                                                               ', N'الخدمات البنكيه                                                                                                                                                                                         ')
INSERT [dbo].[UserRights] ([ID], [ModuleName], [UR_Save], [UR_Update], [UR_Delete], [UR_View], [UserID], [ModuleName_AR]) VALUES (10, N'Payroll                                                                                                                                                                                                 ', 1, 1, 1, 1, N'admin                                                                                               ', N'الرواتب                                                                                                                                                                                                 ')
INSERT [dbo].[UserRights] ([ID], [ModuleName], [UR_Save], [UR_Update], [UR_Delete], [UR_View], [UserID], [ModuleName_AR]) VALUES (11, N'Product Master                                                                                                                                                                                          ', 1, 1, 1, 1, N'admin                                                                                               ', N'المنتج الرئيسي                                                                                                                                                                                          ')
INSERT [dbo].[UserRights] ([ID], [ModuleName], [UR_Save], [UR_Update], [UR_Delete], [UR_View], [UserID], [ModuleName_AR]) VALUES (12, N'Supplier                                                                                                                                                                                                ', 1, 1, 1, 1, N'admin                                                                                               ', N'المورد                                                                                                                                                                                                  ')
INSERT [dbo].[UserRights] ([ID], [ModuleName], [UR_Save], [UR_Update], [UR_Delete], [UR_View], [UserID], [ModuleName_AR]) VALUES (13, N'Credit Customer                                                                                                                                                                                         ', 1, 1, 1, 1, N'admin                                                                                               ', N'عميل الائتمان                                                                                                                                                                                           ')
INSERT [dbo].[UserRights] ([ID], [ModuleName], [UR_Save], [UR_Update], [UR_Delete], [UR_View], [UserID], [ModuleName_AR]) VALUES (14, N'Purchase Order                                                                                                                                                                                          ', 1, 1, 1, 1, N'admin                                                                                               ', N'طلب الشراء                                                                                                                                                                                              ')
INSERT [dbo].[UserRights] ([ID], [ModuleName], [UR_Save], [UR_Update], [UR_Delete], [UR_View], [UserID], [ModuleName_AR]) VALUES (15, N'Purchase Entry                                                                                                                                                                                          ', 1, 1, 1, 1, N'admin                                                                                               ', N'الشراء                                                                                                                                                                                                  ')
INSERT [dbo].[UserRights] ([ID], [ModuleName], [UR_Save], [UR_Update], [UR_Delete], [UR_View], [UserID], [ModuleName_AR]) VALUES (16, N'Purchase Return                                                                                                                                                                                         ', 1, 1, 1, 1, N'admin                                                                                               ', N'مرتجع الشراء                                                                                                                                                                                            ')
INSERT [dbo].[UserRights] ([ID], [ModuleName], [UR_Save], [UR_Update], [UR_Delete], [UR_View], [UserID], [ModuleName_AR]) VALUES (17, N'Sales Return                                                                                                                                                                                            ', 1, 1, 1, 1, N'admin                                                                                               ', N'مرتجع المبيعات                                                                                                                                                                                          ')
INSERT [dbo].[UserRights] ([ID], [ModuleName], [UR_Save], [UR_Update], [UR_Delete], [UR_View], [UserID], [ModuleName_AR]) VALUES (18, N'Stock Transfer/Issue                                                                                                                                                                                    ', 1, 1, 1, 1, N'admin                                                                                               ', N'تحويل المخزون                                                                                                                                                                                           ')
INSERT [dbo].[UserRights] ([ID], [ModuleName], [UR_Save], [UR_Update], [UR_Delete], [UR_View], [UserID], [ModuleName_AR]) VALUES (19, N'Stock Adjustment                                                                                                                                                                                        ', 1, 1, 1, 1, N'admin                                                                                               ', N'جرد المخزون                                                                                                                                                                                             ')
INSERT [dbo].[UserRights] ([ID], [ModuleName], [UR_Save], [UR_Update], [UR_Delete], [UR_View], [UserID], [ModuleName_AR]) VALUES (20, N'Racking                                                                                                                                                                                                 ', 1, 1, 1, 1, N'admin                                                                                               ', N'الارفف                                                                                                                                                                                                  ')
INSERT [dbo].[UserRights] ([ID], [ModuleName], [UR_Save], [UR_Update], [UR_Delete], [UR_View], [UserID], [ModuleName_AR]) VALUES (21, N'Products Location                                                                                                                                                                                       ', 1, 1, 1, 1, N'admin                                                                                               ', N'موقع المنتجات                                                                                                                                                                                           ')
INSERT [dbo].[UserRights] ([ID], [ModuleName], [UR_Save], [UR_Update], [UR_Delete], [UR_View], [UserID], [ModuleName_AR]) VALUES (22, N'Payment                                                                                                                                                                                                 ', 1, 1, 1, 1, N'admin                                                                                               ', N'الدفع                                                                                                                                                                                                   ')
INSERT [dbo].[UserRights] ([ID], [ModuleName], [UR_Save], [UR_Update], [UR_Delete], [UR_View], [UserID], [ModuleName_AR]) VALUES (23, N'Expense Type Master                                                                                                                                                                                     ', 1, 1, 1, 1, N'admin                                                                                               ', N'نوع المصروف                                                                                                                                                                                             ')
INSERT [dbo].[UserRights] ([ID], [ModuleName], [UR_Save], [UR_Update], [UR_Delete], [UR_View], [UserID], [ModuleName_AR]) VALUES (24, N'Expense Master                                                                                                                                                                                          ', 1, 1, 1, 1, N'admin                                                                                               ', N'المصروف الرئيسي                                                                                                                                                                                         ')
INSERT [dbo].[UserRights] ([ID], [ModuleName], [UR_Save], [UR_Update], [UR_Delete], [UR_View], [UserID], [ModuleName_AR]) VALUES (25, N'Voucher                                                                                                                                                                                                 ', 1, 1, 1, 1, N'admin                                                                                               ', N'القسيمه                                                                                                                                                                                                 ')
INSERT [dbo].[UserRights] ([ID], [ModuleName], [UR_Save], [UR_Update], [UR_Delete], [UR_View], [UserID], [ModuleName_AR]) VALUES (26, N'POS Work Period                                                                                                                                                                                         ', 0, 0, 1, 1, N'admin                                                                                               ', N'فترة عميل نقاط البيع                                                                                                                                                                                    ')
INSERT [dbo].[UserRights] ([ID], [ModuleName], [UR_Save], [UR_Update], [UR_Delete], [UR_View], [UserID], [ModuleName_AR]) VALUES (27, N'POS Record                                                                                                                                                                                              ', 0, 0, 1, 1, N'admin                                                                                               ', N'سجل نقاط البيع                                                                                                                                                                                          ')
INSERT [dbo].[UserRights] ([ID], [ModuleName], [UR_Save], [UR_Update], [UR_Delete], [UR_View], [UserID], [ModuleName_AR]) VALUES (28, N'POS Report                                                                                                                                                                                              ', 0, 0, 0, 1, N'admin                                                                                               ', N'تقرير نقاط البيع                                                                                                                                                                                        ')
INSERT [dbo].[UserRights] ([ID], [ModuleName], [UR_Save], [UR_Update], [UR_Delete], [UR_View], [UserID], [ModuleName_AR]) VALUES (29, N'Accounting Report                                                                                                                                                                                       ', 0, 0, 0, 1, N'admin                                                                                               ', N'التقارير المحاسبيه                                                                                                                                                                                      ')
INSERT [dbo].[UserRights] ([ID], [ModuleName], [UR_Save], [UR_Update], [UR_Delete], [UR_View], [UserID], [ModuleName_AR]) VALUES (30, N'Change Price(POS)                                                                                                                                                                                       ', 1, 0, 0, 0, N'admin                                                                                               ', N'تغيير السعر (POS)                                                                                                                                                                                       ')
INSERT [dbo].[UserRights] ([ID], [ModuleName], [UR_Save], [UR_Update], [UR_Delete], [UR_View], [UserID], [ModuleName_AR]) VALUES (31, N'Item Discount(POS)                                                                                                                                                                                      ', 1, 0, 0, 0, N'admin                                                                                               ', N'خصم البند (POS)                                                                                                                                                                                         ')
INSERT [dbo].[UserRights] ([ID], [ModuleName], [UR_Save], [UR_Update], [UR_Delete], [UR_View], [UserID], [ModuleName_AR]) VALUES (32, N'Bill Discount(POS)                                                                                                                                                                                      ', 1, 0, 0, 0, N'admin                                                                                               ', N'خصم الفاتورة (POS)                                                                                                                                                                                      ')
SET IDENTITY_INSERT [dbo].[UserRights] OFF
ALTER TABLE [dbo].[CardProcessing] ADD  CONSTRAINT [DF_CardProcessing_PF]  DEFAULT ((0.00)) FOR [PF]
GO
ALTER TABLE [dbo].[CardProcessing] ADD  CONSTRAINT [DF_CardProcessing_Amount]  DEFAULT ((0.0000)) FOR [Amount]
GO
ALTER TABLE [dbo].[CardProcessing] ADD  CONSTRAINT [DF_CardProcessing_InvoiceAmount]  DEFAULT ((0.00)) FOR [InvoiceAmount]
GO
ALTER TABLE [dbo].[Company] ADD  CONSTRAINT [DF_Company_LicenseNo]  DEFAULT ((0.00)) FOR [LicenseNo]
GO
ALTER TABLE [dbo].[Company] ADD  CONSTRAINT [DF_Company_CapitalAccount]  DEFAULT ((0.00)) FOR [CapitalAccount]
GO
ALTER TABLE [dbo].[CreditCustomer] ADD  CONSTRAINT [DF_CreditCustomer_OpeningBalance]  DEFAULT ((0.00)) FOR [OpeningBalance]
GO
ALTER TABLE [dbo].[CreditCustomer] ADD  CONSTRAINT [DF_CreditCustomer_CreditLimit]  DEFAULT ((0.00)) FOR [CreditLimit]
GO
ALTER TABLE [dbo].[Invoice_Payment] ADD  CONSTRAINT [DF_Invoice_Payment_Amount]  DEFAULT ((0.00)) FOR [Amount]
GO
ALTER TABLE [dbo].[Invoice_Product] ADD  CONSTRAINT [DF_Invoice_Product_DiscountPer]  DEFAULT ((0.00)) FOR [DiscountPer]
GO
ALTER TABLE [dbo].[Invoice_Product] ADD  CONSTRAINT [DF_Invoice_Product_Discount]  DEFAULT ((0.00)) FOR [Discount]
GO
ALTER TABLE [dbo].[Invoice_Product] ADD  CONSTRAINT [DF_Invoice_Product_VATPer]  DEFAULT ((0.00)) FOR [VATPer]
GO
ALTER TABLE [dbo].[Invoice_Product] ADD  CONSTRAINT [DF_Invoice_Product_VAT]  DEFAULT ((0.00)) FOR [VAT]
GO
ALTER TABLE [dbo].[Invoice_Product] ADD  CONSTRAINT [DF_Invoice_Product_Qty]  DEFAULT ((1)) FOR [Qty]
GO
ALTER TABLE [dbo].[Invoice_Product] ADD  CONSTRAINT [DF_Invoice_Product_TotalAmount]  DEFAULT ((0.00)) FOR [TotalAmount]
GO
ALTER TABLE [dbo].[InvoiceInfo] ADD  CONSTRAINT [DF_InvoiceInfo_ExchangeRate]  DEFAULT ((1.00)) FOR [ExchangeRate]
GO
ALTER TABLE [dbo].[InvoiceInfo] ADD  CONSTRAINT [DF_InvoiceInfo_DiscPer]  DEFAULT ((0.00)) FOR [DiscPer]
GO
ALTER TABLE [dbo].[InvoiceInfo] ADD  CONSTRAINT [DF_InvoiceInfo_DiscAmt]  DEFAULT ((0.00)) FOR [DiscAmt]
GO
ALTER TABLE [dbo].[InvoiceInfo] ADD  CONSTRAINT [DF_InvoiceInfo_SalesmanID]  DEFAULT ((0)) FOR [SalesmanID]
GO
ALTER TABLE [dbo].[InvoiceInfo] ADD  CONSTRAINT [DF_InvoiceInfo_Cash]  DEFAULT ((0.00)) FOR [Cash]
GO
ALTER TABLE [dbo].[InvoiceInfo] ADD  CONSTRAINT [DF_InvoiceInfo_Change]  DEFAULT ((0.00)) FOR [Change]
GO
ALTER TABLE [dbo].[InvoiceInfo] ADD  CONSTRAINT [DF_InvoiceInfo_CustID]  DEFAULT ((0)) FOR [CustID]
GO
ALTER TABLE [dbo].[InvoiceInfo] ADD  CONSTRAINT [DF_InvoiceInfo_LoyaltyMemberID]  DEFAULT ((0)) FOR [LoyaltyMemberID]
GO
ALTER TABLE [dbo].[InvoiceInfo] ADD  CONSTRAINT [DF_InvoiceInfo_LP]  DEFAULT ((0)) FOR [LP]
GO
ALTER TABLE [dbo].[Party] ADD  CONSTRAINT [DF_Party_OpeningBalance]  DEFAULT ((0.00)) FOR [OpeningBalance]
GO
ALTER TABLE [dbo].[Party] ADD  CONSTRAINT [DF_Party_CreditLimit]  DEFAULT ((0.00)) FOR [CreditLimit]
GO
ALTER TABLE [dbo].[Party] ADD  CONSTRAINT [DF_Party_CreditDays]  DEFAULT ((0)) FOR [CreditDays]
GO
ALTER TABLE [dbo].[Payroll] ADD  CONSTRAINT [DF_Payroll_Rate]  DEFAULT ((0.00)) FOR [Rate]
GO
ALTER TABLE [dbo].[Payroll] ADD  CONSTRAINT [DF_Payroll_GrossSalary]  DEFAULT ((0.00)) FOR [GrossSalary]
GO
ALTER TABLE [dbo].[Payroll] ADD  CONSTRAINT [DF_Payroll_CPPPer]  DEFAULT ((0.00)) FOR [CPPPer]
GO
ALTER TABLE [dbo].[Payroll] ADD  CONSTRAINT [DF_Payroll_CPP]  DEFAULT ((0.00)) FOR [CPP]
GO
ALTER TABLE [dbo].[Payroll] ADD  CONSTRAINT [DF_Payroll_EIPer]  DEFAULT ((0.00)) FOR [EIPer]
GO
ALTER TABLE [dbo].[Payroll] ADD  CONSTRAINT [DF_Payroll_EI]  DEFAULT ((0.00)) FOR [EI]
GO
ALTER TABLE [dbo].[Payroll] ADD  CONSTRAINT [DF_Payroll_FedTaxPer]  DEFAULT ((0.00)) FOR [FedTaxPer]
GO
ALTER TABLE [dbo].[Payroll] ADD  CONSTRAINT [DF_Payroll_FedTax]  DEFAULT ((0.00)) FOR [FedTax]
GO
ALTER TABLE [dbo].[Payroll] ADD  CONSTRAINT [DF_Payroll_NetPay]  DEFAULT ((0.00)) FOR [NetPay]
GO
ALTER TABLE [dbo].[Payroll_MB] ADD  CONSTRAINT [DF_Payroll_MB_GrossSalary]  DEFAULT ((0.00)) FOR [GrossSalary]
GO
ALTER TABLE [dbo].[Payroll_MB] ADD  CONSTRAINT [DF_Payroll_MB_CPPPer]  DEFAULT ((0.00)) FOR [CPPPer]
GO
ALTER TABLE [dbo].[Payroll_MB] ADD  CONSTRAINT [DF_Payroll_MB_CPP]  DEFAULT ((0.00)) FOR [CPP]
GO
ALTER TABLE [dbo].[Payroll_MB] ADD  CONSTRAINT [DF_Payroll_MB_EIPer]  DEFAULT ((0.00)) FOR [EIPer]
GO
ALTER TABLE [dbo].[Payroll_MB] ADD  CONSTRAINT [DF_Payroll_MB_EI]  DEFAULT ((0.00)) FOR [EI]
GO
ALTER TABLE [dbo].[Payroll_MB] ADD  CONSTRAINT [DF_Payroll_MB_FedTaxPer]  DEFAULT ((0.00)) FOR [FedTaxPer]
GO
ALTER TABLE [dbo].[Payroll_MB] ADD  CONSTRAINT [DF_Payroll_MB_FedTax]  DEFAULT ((0.00)) FOR [FedTax]
GO
ALTER TABLE [dbo].[Payroll_MB] ADD  CONSTRAINT [DF_Payroll_MB_NetPay]  DEFAULT ((0.00)) FOR [NetPay]
GO
ALTER TABLE [dbo].[POS_ClosingCash] ADD  CONSTRAINT [DF_POS_ClosingCash_ClosingBalance]  DEFAULT ((0.00)) FOR [ClosingBalance]
GO
ALTER TABLE [dbo].[POS_HoldBill] ADD  CONSTRAINT [DF_POS_HoldBill_DiscPer]  DEFAULT ((0.00)) FOR [DiscPer]
GO
ALTER TABLE [dbo].[POS_HoldBill] ADD  CONSTRAINT [DF_POS_HoldBill_DiscAmt]  DEFAULT ((0.00)) FOR [DiscAmt]
GO
ALTER TABLE [dbo].[POS_HoldBillItems] ADD  CONSTRAINT [DF_POS_HoldBillItems_DiscountPer]  DEFAULT ((0.00)) FOR [DiscountPer]
GO
ALTER TABLE [dbo].[POS_HoldBillItems] ADD  CONSTRAINT [DF_POS_HoldBillItems_Discount]  DEFAULT ((0.00)) FOR [Discount]
GO
ALTER TABLE [dbo].[POS_HoldBillItems] ADD  CONSTRAINT [DF_POS_HoldBillItems_VATPer]  DEFAULT ((0.00)) FOR [VATPer]
GO
ALTER TABLE [dbo].[POS_HoldBillItems] ADD  CONSTRAINT [DF_POS_HoldBillItems_VAT]  DEFAULT ((0.00)) FOR [VAT]
GO
ALTER TABLE [dbo].[POS_HoldBillItems] ADD  CONSTRAINT [DF_POS_HoldBillItems_Qty]  DEFAULT ((1)) FOR [Qty]
GO
ALTER TABLE [dbo].[POS_HoldBillItems] ADD  CONSTRAINT [DF_POS_HoldBillItems_TotalAmount]  DEFAULT ((0.00)) FOR [TotalAmount]
GO
ALTER TABLE [dbo].[POS_OpeningCash] ADD  CONSTRAINT [DF_POS_OpeningCash_Closed]  DEFAULT ((0)) FOR [Closed]
GO
ALTER TABLE [dbo].[POS_OpeningCash] ADD  CONSTRAINT [DF_POS_OpeningCash_OpeningCash]  DEFAULT ((0.00)) FOR [OpeningCash]
GO
ALTER TABLE [dbo].[Product] ADD  CONSTRAINT [DF_Product_PurchaseCost]  DEFAULT ((0.00)) FOR [PurchaseCost]
GO
ALTER TABLE [dbo].[Product] ADD  CONSTRAINT [DF_Product_SalesCost]  DEFAULT ((0.00)) FOR [SalesCost]
GO
ALTER TABLE [dbo].[Product] ADD  CONSTRAINT [DF_Product_ReorderPoint]  DEFAULT ((0)) FOR [ReorderPoint]
GO
ALTER TABLE [dbo].[Product] ADD  CONSTRAINT [DF_Product_MarginPer]  DEFAULT ((0.00)) FOR [MarginPer]
GO
ALTER TABLE [dbo].[Product] ADD  CONSTRAINT [DF_Product_P1]  DEFAULT ((0.00)) FOR [P1]
GO
ALTER TABLE [dbo].[Product] ADD  CONSTRAINT [DF_Product_P2]  DEFAULT ((0.00)) FOR [P2]
GO
ALTER TABLE [dbo].[Product] ADD  CONSTRAINT [DF_Product_P3]  DEFAULT ((0.00)) FOR [P3]
GO
ALTER TABLE [dbo].[Product] ADD  CONSTRAINT [DF_Product_P4]  DEFAULT ((0.00)) FOR [P4]
GO
ALTER TABLE [dbo].[Product] ADD  CONSTRAINT [DF_Product_P5]  DEFAULT ((0.00)) FOR [P5]
GO
ALTER TABLE [dbo].[Product] ADD  CONSTRAINT [DF_Product_Q1]  DEFAULT ((0)) FOR [Q1]
GO
ALTER TABLE [dbo].[Product] ADD  CONSTRAINT [DF_Product_Q2]  DEFAULT ((0)) FOR [Q2]
GO
ALTER TABLE [dbo].[Product] ADD  CONSTRAINT [DF_Product_Q3]  DEFAULT ((0)) FOR [Q3]
GO
ALTER TABLE [dbo].[Product] ADD  CONSTRAINT [DF_Product_Q4]  DEFAULT ((0)) FOR [Q4]
GO
ALTER TABLE [dbo].[Product] ADD  CONSTRAINT [DF_Product_Q5]  DEFAULT ((0)) FOR [Q5]
GO
ALTER TABLE [dbo].[Product_OpeningStock] ADD  CONSTRAINT [DF_Product_OpeningStock_Qty]  DEFAULT ((0)) FOR [Qty]
GO
ALTER TABLE [dbo].[Purchase] ADD  CONSTRAINT [DF_Purchase_SubTotal]  DEFAULT ((0.00)) FOR [SubTotal]
GO
ALTER TABLE [dbo].[Purchase] ADD  CONSTRAINT [DF_Purchase_DiscountPer]  DEFAULT ((0.00)) FOR [DiscountPer]
GO
ALTER TABLE [dbo].[Purchase] ADD  CONSTRAINT [DF_Purchase_Discount]  DEFAULT ((0.00)) FOR [Discount]
GO
ALTER TABLE [dbo].[Purchase] ADD  CONSTRAINT [DF_Purchase_PreviousDue]  DEFAULT ((0.00)) FOR [PreviousDue]
GO
ALTER TABLE [dbo].[Purchase] ADD  CONSTRAINT [DF_Purchase_FreightCharges]  DEFAULT ((0.00)) FOR [FreightCharges]
GO
ALTER TABLE [dbo].[Purchase] ADD  CONSTRAINT [DF_Purchase_OtherCharges]  DEFAULT ((0.00)) FOR [OtherCharges]
GO
ALTER TABLE [dbo].[Purchase] ADD  CONSTRAINT [DF_Purchase_Total]  DEFAULT ((0.00)) FOR [Total]
GO
ALTER TABLE [dbo].[Purchase] ADD  CONSTRAINT [DF_Purchase_RoundOff]  DEFAULT ((0.00)) FOR [RoundOff]
GO
ALTER TABLE [dbo].[Purchase] ADD  CONSTRAINT [DF_Purchase_GrandTotal]  DEFAULT ((0.00)) FOR [GrandTotal]
GO
ALTER TABLE [dbo].[Purchase] ADD  CONSTRAINT [DF_Purchase_TotalPayment]  DEFAULT ((0.00)) FOR [TotalPayment]
GO
ALTER TABLE [dbo].[Purchase] ADD  CONSTRAINT [DF_Purchase_PaymentDue]  DEFAULT ((0.00)) FOR [PaymentDue]
GO
ALTER TABLE [dbo].[Purchase] ADD  CONSTRAINT [DF_Purchase_VATPer]  DEFAULT ((0.00)) FOR [VATPer]
GO
ALTER TABLE [dbo].[Purchase] ADD  CONSTRAINT [DF_Purchase_VAT]  DEFAULT ((0.00)) FOR [VAT]
GO
ALTER TABLE [dbo].[Purchase_Join] ADD  CONSTRAINT [DF_Purchase_Join_Qty]  DEFAULT ((0)) FOR [Qty]
GO
ALTER TABLE [dbo].[Purchase_Join] ADD  CONSTRAINT [DF_Purchase_Join_Price]  DEFAULT ((0.00)) FOR [Price]
GO
ALTER TABLE [dbo].[Purchase_Join] ADD  CONSTRAINT [DF_Purchase_Join_SalesCost]  DEFAULT ((0.00)) FOR [SalesCost]
GO
ALTER TABLE [dbo].[PurchaseOrder] ADD  CONSTRAINT [DF_PurchaseOrder_SubTotal]  DEFAULT ((0.00)) FOR [SubTotal]
GO
ALTER TABLE [dbo].[PurchaseOrder] ADD  CONSTRAINT [DF_PurchaseOrder_VATPer]  DEFAULT ((0.00)) FOR [VATPer]
GO
ALTER TABLE [dbo].[PurchaseOrder] ADD  CONSTRAINT [DF_PurchaseOrder_VATAmount]  DEFAULT ((0.00)) FOR [VATAmount]
GO
ALTER TABLE [dbo].[PurchaseOrder] ADD  CONSTRAINT [DF_PurchaseOrder_GrandTotal]  DEFAULT ((0.00)) FOR [GrandTotal]
GO
ALTER TABLE [dbo].[PurchaseOrder_Join] ADD  CONSTRAINT [DF_PurchaseOrder_Join_PricePerUnit]  DEFAULT ((0.00)) FOR [PricePerUnit]
GO
ALTER TABLE [dbo].[PurchaseOrder_Join] ADD  CONSTRAINT [DF_PurchaseOrder_Join_Amount]  DEFAULT ((0.00)) FOR [Amount]
GO
ALTER TABLE [dbo].[PurchaseReturn] ADD  CONSTRAINT [DF_PurchaseReturn_SubTotal]  DEFAULT ((0.00)) FOR [SubTotal]
GO
ALTER TABLE [dbo].[PurchaseReturn] ADD  CONSTRAINT [DF_PurchaseReturn_DiscPer]  DEFAULT ((0.00)) FOR [DiscPer]
GO
ALTER TABLE [dbo].[PurchaseReturn] ADD  CONSTRAINT [DF_PurchaseReturn_Discount]  DEFAULT ((0.00)) FOR [Discount]
GO
ALTER TABLE [dbo].[PurchaseReturn] ADD  CONSTRAINT [DF_PurchaseReturn_VATPer]  DEFAULT ((0.00)) FOR [VATPer]
GO
ALTER TABLE [dbo].[PurchaseReturn] ADD  CONSTRAINT [DF_PurchaseReturn_VATAmt]  DEFAULT ((0.00)) FOR [VATAmt]
GO
ALTER TABLE [dbo].[PurchaseReturn] ADD  CONSTRAINT [DF_PurchaseReturn_Total]  DEFAULT ((0.00)) FOR [Total]
GO
ALTER TABLE [dbo].[PurchaseReturn] ADD  CONSTRAINT [DF_PurchaseReturn_RoundOff]  DEFAULT ((0.00)) FOR [RoundOff]
GO
ALTER TABLE [dbo].[PurchaseReturn] ADD  CONSTRAINT [DF_PurchaseReturn_GrandTotal]  DEFAULT ((0.00)) FOR [GrandTotal]
GO
ALTER TABLE [dbo].[SalesMan] ADD  CONSTRAINT [DF_SalesMan_Commission]  DEFAULT ((0.00)) FOR [CommissionPer]
GO
ALTER TABLE [dbo].[Salesman_Commission] ADD  CONSTRAINT [DF_Salesman_Commission_CommissionPer]  DEFAULT ((0.00)) FOR [CommissionPer]
GO
ALTER TABLE [dbo].[Salesman_Commission] ADD  CONSTRAINT [DF_Salesman_Commission_Commission]  DEFAULT ((0.00)) FOR [Commission]
GO
ALTER TABLE [dbo].[StockTransfer_Join] ADD  CONSTRAINT [DF_StockTransfer_Join_SalesRate]  DEFAULT ((0.00)) FOR [SalesRate]
GO
ALTER TABLE [dbo].[StockTransfer_Join_S2W] ADD  CONSTRAINT [DF_StockTransfer_Join_S2W_SalesRate]  DEFAULT ((0.00)) FOR [SalesRate]
GO
ALTER TABLE [dbo].[StockTransfer_Join_W2W] ADD  CONSTRAINT [DF_StockTransfer_Join_W2W_SalesRate]  DEFAULT ((0.00)) FOR [SalesRate]
GO
ALTER TABLE [dbo].[Supplier] ADD  CONSTRAINT [DF_Supplier_OpeningBalance]  DEFAULT ((0.00)) FOR [OpeningBalance]
GO
ALTER TABLE [dbo].[Temp_Stock] ADD  CONSTRAINT [DF_Temp_Stock_SalesRate]  DEFAULT ((0.00)) FOR [SalesRate]
GO
ALTER TABLE [dbo].[Temp_Stock] ADD  CONSTRAINT [DF_Temp_Stock_Qty]  DEFAULT ((0)) FOR [Qty]
GO
ALTER TABLE [dbo].[Temp_Stock_Company] ADD  CONSTRAINT [DF_Temp_Stock_Company_SalesRate]  DEFAULT ((0.00)) FOR [SalesRate]
GO
ALTER TABLE [dbo].[Temp_Stock_Company] ADD  CONSTRAINT [DF_Temp_Stock_Company_Qty]  DEFAULT ((0.00)) FOR [Qty]
GO
ALTER TABLE [dbo].[Voucher] ADD  CONSTRAINT [DF_Voucher_SubTotal]  DEFAULT ((0.00)) FOR [SubTotal]
GO
ALTER TABLE [dbo].[Voucher] ADD  CONSTRAINT [DF_Voucher_VATPer]  DEFAULT ((0.00)) FOR [VATPer]
GO
ALTER TABLE [dbo].[Voucher] ADD  CONSTRAINT [DF_Voucher_VAT]  DEFAULT ((0.00)) FOR [VAT]
GO
ALTER TABLE [dbo].[BankAccountLedger]  WITH CHECK ADD  CONSTRAINT [FK_BankAccountLedger_BankAccountRegistration] FOREIGN KEY([AccNo])
REFERENCES [dbo].[BankAccountRegistration] ([AccountNo])
ON UPDATE CASCADE
ON DELETE CASCADE
GO
ALTER TABLE [dbo].[BankAccountLedger] CHECK CONSTRAINT [FK_BankAccountLedger_BankAccountRegistration]
GO
ALTER TABLE [dbo].[BankAccountRegistration]  WITH CHECK ADD  CONSTRAINT [FK_BankAccountRegistration_BankBranch] FOREIGN KEY([BranchID])
REFERENCES [dbo].[BankBranch] ([Id])
ON UPDATE CASCADE
GO
ALTER TABLE [dbo].[BankAccountRegistration] CHECK CONSTRAINT [FK_BankAccountRegistration_BankBranch]
GO
ALTER TABLE [dbo].[BankBranch]  WITH CHECK ADD  CONSTRAINT [FK_BankBranch_Bank] FOREIGN KEY([BankName])
REFERENCES [dbo].[Bank] ([BankName])
ON UPDATE CASCADE
GO
ALTER TABLE [dbo].[BankBranch] CHECK CONSTRAINT [FK_BankBranch_Bank]
GO
ALTER TABLE [dbo].[CardProcessing]  WITH CHECK ADD  CONSTRAINT [FK_CardProcessing_InvoiceInfo] FOREIGN KEY([InvoiceID])
REFERENCES [dbo].[InvoiceInfo] ([Inv_ID])
ON UPDATE CASCADE
ON DELETE CASCADE
GO
ALTER TABLE [dbo].[CardProcessing] CHECK CONSTRAINT [FK_CardProcessing_InvoiceInfo]
GO
ALTER TABLE [dbo].[ClockOUT]  WITH CHECK ADD  CONSTRAINT [FK_ClockOUT_ClockIN] FOREIGN KEY([ClockInID])
REFERENCES [dbo].[ClockIN] ([ID])
ON UPDATE CASCADE
ON DELETE CASCADE
GO
ALTER TABLE [dbo].[ClockOUT] CHECK CONSTRAINT [FK_ClockOUT_ClockIN]
GO
ALTER TABLE [dbo].[CreditCustomerLedger]  WITH CHECK ADD  CONSTRAINT [FK_CreditCustomerLedger_CreditCustomer] FOREIGN KEY([CreditCustomer_ID])
REFERENCES [dbo].[CreditCustomer] ([CC_ID])
ON UPDATE CASCADE
ON DELETE CASCADE
GO
ALTER TABLE [dbo].[CreditCustomerLedger] CHECK CONSTRAINT [FK_CreditCustomerLedger_CreditCustomer]
GO
ALTER TABLE [dbo].[CreditCustomerPayment]  WITH CHECK ADD  CONSTRAINT [FK_CreditCustomerPayment_CreditCustomer] FOREIGN KEY([CreditCustomer_ID])
REFERENCES [dbo].[CreditCustomer] ([CC_ID])
ON UPDATE CASCADE
GO
ALTER TABLE [dbo].[CreditCustomerPayment] CHECK CONSTRAINT [FK_CreditCustomerPayment_CreditCustomer]
GO
ALTER TABLE [dbo].[DiscountSetting]  WITH CHECK ADD  CONSTRAINT [FK_DiscountSetting_Registration] FOREIGN KEY([UserID])
REFERENCES [dbo].[Registration] ([UserID])
ON UPDATE CASCADE
ON DELETE CASCADE
GO
ALTER TABLE [dbo].[DiscountSetting] CHECK CONSTRAINT [FK_DiscountSetting_Registration]
GO
ALTER TABLE [dbo].[Expense]  WITH CHECK ADD  CONSTRAINT [FK_Expense_ExpenseType] FOREIGN KEY([ExpenseType])
REFERENCES [dbo].[ExpenseType] ([Type])
ON UPDATE CASCADE
GO
ALTER TABLE [dbo].[Expense] CHECK CONSTRAINT [FK_Expense_ExpenseType]
GO
ALTER TABLE [dbo].[FundDeposit]  WITH CHECK ADD  CONSTRAINT [FK_FundDeposit_BankAccountRegistration] FOREIGN KEY([AccNo])
REFERENCES [dbo].[BankAccountRegistration] ([AccountNo])
ON UPDATE CASCADE
GO
ALTER TABLE [dbo].[FundDeposit] CHECK CONSTRAINT [FK_FundDeposit_BankAccountRegistration]
GO
ALTER TABLE [dbo].[Invoice_Payment]  WITH CHECK ADD  CONSTRAINT [FK_Invoice_Payment_InvoiceInfo] FOREIGN KEY([InvoiceID])
REFERENCES [dbo].[InvoiceInfo] ([Inv_ID])
ON UPDATE CASCADE
ON DELETE CASCADE
GO
ALTER TABLE [dbo].[Invoice_Payment] CHECK CONSTRAINT [FK_Invoice_Payment_InvoiceInfo]
GO
ALTER TABLE [dbo].[Invoice_Product]  WITH CHECK ADD  CONSTRAINT [FK_Invoice_Product_InvoiceInfo] FOREIGN KEY([InvoiceID])
REFERENCES [dbo].[InvoiceInfo] ([Inv_ID])
ON UPDATE CASCADE
ON DELETE CASCADE
GO
ALTER TABLE [dbo].[Invoice_Product] CHECK CONSTRAINT [FK_Invoice_Product_InvoiceInfo]
GO
ALTER TABLE [dbo].[Invoice_Product]  WITH CHECK ADD  CONSTRAINT [FK_Invoice_Product_Product] FOREIGN KEY([ProductID])
REFERENCES [dbo].[Product] ([PID])
ON UPDATE CASCADE
GO
ALTER TABLE [dbo].[Invoice_Product] CHECK CONSTRAINT [FK_Invoice_Product_Product]
GO
ALTER TABLE [dbo].[InvoiceInfo]  WITH CHECK ADD  CONSTRAINT [FK_InvoiceInfo_POS_OpeningCash] FOREIGN KEY([OpenID])
REFERENCES [dbo].[POS_OpeningCash] ([OpenID])
ON UPDATE CASCADE
GO
ALTER TABLE [dbo].[InvoiceInfo] CHECK CONSTRAINT [FK_InvoiceInfo_POS_OpeningCash]
GO
ALTER TABLE [dbo].[Logs]  WITH CHECK ADD  CONSTRAINT [FK_Logs_Registration] FOREIGN KEY([UserID])
REFERENCES [dbo].[Registration] ([UserID])
ON UPDATE CASCADE
ON DELETE CASCADE
GO
ALTER TABLE [dbo].[Logs] CHECK CONSTRAINT [FK_Logs_Registration]
GO
ALTER TABLE [dbo].[LoyaltyMemberLedgerBook]  WITH CHECK ADD  CONSTRAINT [FK_LoyaltyMemberLedgerBook_LoyaltyMember] FOREIGN KEY([MemberID])
REFERENCES [dbo].[LoyaltyMember] ([MemberID])
ON UPDATE CASCADE
GO
ALTER TABLE [dbo].[LoyaltyMemberLedgerBook] CHECK CONSTRAINT [FK_LoyaltyMemberLedgerBook_LoyaltyMember]
GO
ALTER TABLE [dbo].[Payment]  WITH CHECK ADD  CONSTRAINT [FK_Payment_Supplier] FOREIGN KEY([SupplierID])
REFERENCES [dbo].[Supplier] ([ID])
ON UPDATE CASCADE
GO
ALTER TABLE [dbo].[Payment] CHECK CONSTRAINT [FK_Payment_Supplier]
GO
ALTER TABLE [dbo].[Payment_Withdraw]  WITH CHECK ADD  CONSTRAINT [FK_Payment_Withdraw_BankAccountRegistration] FOREIGN KEY([AccountFrom])
REFERENCES [dbo].[BankAccountRegistration] ([AccountNo])
ON UPDATE CASCADE
GO
ALTER TABLE [dbo].[Payment_Withdraw] CHECK CONSTRAINT [FK_Payment_Withdraw_BankAccountRegistration]
GO
ALTER TABLE [dbo].[Payroll]  WITH CHECK ADD  CONSTRAINT [FK_Payroll_Registration] FOREIGN KEY([UserID])
REFERENCES [dbo].[Registration] ([UserID])
ON UPDATE CASCADE
GO
ALTER TABLE [dbo].[Payroll] CHECK CONSTRAINT [FK_Payroll_Registration]
GO
ALTER TABLE [dbo].[Payroll_MB]  WITH CHECK ADD  CONSTRAINT [FK_Payroll_MB_Registration] FOREIGN KEY([UserID])
REFERENCES [dbo].[Registration] ([UserID])
ON UPDATE CASCADE
GO
ALTER TABLE [dbo].[Payroll_MB] CHECK CONSTRAINT [FK_Payroll_MB_Registration]
GO
ALTER TABLE [dbo].[POS_ClosingCash]  WITH CHECK ADD  CONSTRAINT [FK_POS_ClosingCash_POS_OpeningCash] FOREIGN KEY([OpenID])
REFERENCES [dbo].[POS_OpeningCash] ([OpenID])
ON UPDATE CASCADE
ON DELETE CASCADE
GO
ALTER TABLE [dbo].[POS_ClosingCash] CHECK CONSTRAINT [FK_POS_ClosingCash_POS_OpeningCash]
GO
ALTER TABLE [dbo].[POS_HoldBill]  WITH CHECK ADD  CONSTRAINT [FK_POS_HoldBill_POS_OpeningCash] FOREIGN KEY([OpenID])
REFERENCES [dbo].[POS_OpeningCash] ([OpenID])
ON UPDATE CASCADE
ON DELETE CASCADE
GO
ALTER TABLE [dbo].[POS_HoldBill] CHECK CONSTRAINT [FK_POS_HoldBill_POS_OpeningCash]
GO
ALTER TABLE [dbo].[POS_HoldBillItems]  WITH CHECK ADD  CONSTRAINT [FK_POS_HoldBillItems_POS_HoldBill] FOREIGN KEY([HoldID])
REFERENCES [dbo].[POS_HoldBill] ([Hold_ID])
ON UPDATE CASCADE
ON DELETE CASCADE
GO
ALTER TABLE [dbo].[POS_HoldBillItems] CHECK CONSTRAINT [FK_POS_HoldBillItems_POS_HoldBill]
GO
ALTER TABLE [dbo].[POS_HoldBillItems]  WITH CHECK ADD  CONSTRAINT [FK_POS_HoldBillItems_Product1] FOREIGN KEY([ProductID])
REFERENCES [dbo].[Product] ([PID])
ON UPDATE CASCADE
ON DELETE CASCADE
GO
ALTER TABLE [dbo].[POS_HoldBillItems] CHECK CONSTRAINT [FK_POS_HoldBillItems_Product1]
GO
ALTER TABLE [dbo].[POS_OpeningCash]  WITH CHECK ADD  CONSTRAINT [FK_POS_OpeningCash_Registration] FOREIGN KEY([UserID])
REFERENCES [dbo].[Registration] ([UserID])
ON UPDATE CASCADE
GO
ALTER TABLE [dbo].[POS_OpeningCash] CHECK CONSTRAINT [FK_POS_OpeningCash_Registration]
GO
ALTER TABLE [dbo].[Product]  WITH CHECK ADD  CONSTRAINT [FK_Product_Category] FOREIGN KEY([Category])
REFERENCES [dbo].[Category] ([CategoryName])
ON UPDATE CASCADE
GO
ALTER TABLE [dbo].[Product] CHECK CONSTRAINT [FK_Product_Category]
GO
ALTER TABLE [dbo].[Product]  WITH CHECK ADD  CONSTRAINT [FK_Product_TaxMaster] FOREIGN KEY([VATCommodity])
REFERENCES [dbo].[TaxMaster] ([TaxName])
ON UPDATE CASCADE
GO
ALTER TABLE [dbo].[Product] CHECK CONSTRAINT [FK_Product_TaxMaster]
GO
ALTER TABLE [dbo].[Product_OpeningStock]  WITH CHECK ADD  CONSTRAINT [FK_Product_OpeningStock_Product] FOREIGN KEY([ProductID])
REFERENCES [dbo].[Product] ([PID])
ON UPDATE CASCADE
ON DELETE CASCADE
GO
ALTER TABLE [dbo].[Product_OpeningStock] CHECK CONSTRAINT [FK_Product_OpeningStock_Product]
GO
ALTER TABLE [dbo].[ProductLocation]  WITH CHECK ADD  CONSTRAINT [FK_ProductLocation_Product] FOREIGN KEY([ProductID])
REFERENCES [dbo].[Product] ([PID])
ON UPDATE CASCADE
GO
ALTER TABLE [dbo].[ProductLocation] CHECK CONSTRAINT [FK_ProductLocation_Product]
GO
ALTER TABLE [dbo].[ProductLocation]  WITH CHECK ADD  CONSTRAINT [FK_ProductLocation_Racking] FOREIGN KEY([RackNo])
REFERENCES [dbo].[Racking] ([RackNo])
ON UPDATE CASCADE
GO
ALTER TABLE [dbo].[ProductLocation] CHECK CONSTRAINT [FK_ProductLocation_Racking]
GO
ALTER TABLE [dbo].[Purchase]  WITH CHECK ADD  CONSTRAINT [FK_Purchase_Supplier] FOREIGN KEY([Supplier_ID])
REFERENCES [dbo].[Supplier] ([ID])
ON UPDATE CASCADE
GO
ALTER TABLE [dbo].[Purchase] CHECK CONSTRAINT [FK_Purchase_Supplier]
GO
ALTER TABLE [dbo].[Purchase_Join]  WITH CHECK ADD  CONSTRAINT [FK_Purchase_Join_Product] FOREIGN KEY([ProductID])
REFERENCES [dbo].[Product] ([PID])
ON UPDATE CASCADE
GO
ALTER TABLE [dbo].[Purchase_Join] CHECK CONSTRAINT [FK_Purchase_Join_Product]
GO
ALTER TABLE [dbo].[Purchase_Join]  WITH CHECK ADD  CONSTRAINT [FK_Purchase_Join_Purchase] FOREIGN KEY([PurchaseID])
REFERENCES [dbo].[Purchase] ([ST_ID])
ON UPDATE CASCADE
ON DELETE CASCADE
GO
ALTER TABLE [dbo].[Purchase_Join] CHECK CONSTRAINT [FK_Purchase_Join_Purchase]
GO
ALTER TABLE [dbo].[PurchaseOrder]  WITH CHECK ADD  CONSTRAINT [FK_PurchaseOrder_Supplier] FOREIGN KEY([Supplier_ID])
REFERENCES [dbo].[Supplier] ([ID])
ON UPDATE CASCADE
GO
ALTER TABLE [dbo].[PurchaseOrder] CHECK CONSTRAINT [FK_PurchaseOrder_Supplier]
GO
ALTER TABLE [dbo].[PurchaseOrder_Join]  WITH CHECK ADD  CONSTRAINT [FK_PurchaseOrder_Join_Product] FOREIGN KEY([ProductID])
REFERENCES [dbo].[Product] ([PID])
ON UPDATE CASCADE
GO
ALTER TABLE [dbo].[PurchaseOrder_Join] CHECK CONSTRAINT [FK_PurchaseOrder_Join_Product]
GO
ALTER TABLE [dbo].[PurchaseOrder_Join]  WITH CHECK ADD  CONSTRAINT [FK_PurchaseOrder_Join_PurchaseOrder] FOREIGN KEY([PurchaseOrderID])
REFERENCES [dbo].[PurchaseOrder] ([PO_ID])
ON UPDATE CASCADE
ON DELETE CASCADE
GO
ALTER TABLE [dbo].[PurchaseOrder_Join] CHECK CONSTRAINT [FK_PurchaseOrder_Join_PurchaseOrder]
GO
ALTER TABLE [dbo].[PurchaseReturn]  WITH CHECK ADD  CONSTRAINT [FK_PurchaseReturn_Purchase] FOREIGN KEY([PurchaseID])
REFERENCES [dbo].[Purchase] ([ST_ID])
ON UPDATE CASCADE
GO
ALTER TABLE [dbo].[PurchaseReturn] CHECK CONSTRAINT [FK_PurchaseReturn_Purchase]
GO
ALTER TABLE [dbo].[PurchaseReturn_Join]  WITH CHECK ADD  CONSTRAINT [FK_PurchaseReturn_Join_Product] FOREIGN KEY([ProductID])
REFERENCES [dbo].[Product] ([PID])
ON UPDATE CASCADE
GO
ALTER TABLE [dbo].[PurchaseReturn_Join] CHECK CONSTRAINT [FK_PurchaseReturn_Join_Product]
GO
ALTER TABLE [dbo].[PurchaseReturn_Join]  WITH CHECK ADD  CONSTRAINT [FK_PurchaseReturn_Join_PurchaseReturn] FOREIGN KEY([PurchaseReturnID])
REFERENCES [dbo].[PurchaseReturn] ([PR_ID])
ON UPDATE CASCADE
ON DELETE CASCADE
GO
ALTER TABLE [dbo].[PurchaseReturn_Join] CHECK CONSTRAINT [FK_PurchaseReturn_Join_PurchaseReturn]
GO
ALTER TABLE [dbo].[Sales]  WITH CHECK ADD  CONSTRAINT [FK_Sales_Party] FOREIGN KEY([PartyID])
REFERENCES [dbo].[Party] ([PT_ID])
ON UPDATE CASCADE
GO
ALTER TABLE [dbo].[Sales] CHECK CONSTRAINT [FK_Sales_Party]
GO
ALTER TABLE [dbo].[Sales]  WITH CHECK ADD  CONSTRAINT [FK_Sales_Registration] FOREIGN KEY([UserOperator])
REFERENCES [dbo].[Registration] ([UserID])
ON UPDATE CASCADE
GO
ALTER TABLE [dbo].[Sales] CHECK CONSTRAINT [FK_Sales_Registration]
GO
ALTER TABLE [dbo].[Sales_Product]  WITH CHECK ADD  CONSTRAINT [FK_Sales_Product_Product] FOREIGN KEY([ProductID])
REFERENCES [dbo].[Product] ([PID])
ON UPDATE CASCADE
GO
ALTER TABLE [dbo].[Sales_Product] CHECK CONSTRAINT [FK_Sales_Product_Product]
GO
ALTER TABLE [dbo].[Sales_Product]  WITH CHECK ADD  CONSTRAINT [FK_Sales_Product_Sales] FOREIGN KEY([SalesID])
REFERENCES [dbo].[Sales] ([SalesID])
ON UPDATE CASCADE
ON DELETE CASCADE
GO
ALTER TABLE [dbo].[Sales_Product] CHECK CONSTRAINT [FK_Sales_Product_Sales]
GO
ALTER TABLE [dbo].[Sales_Product]  WITH CHECK ADD  CONSTRAINT [FK_Sales_Product_Warehouse] FOREIGN KEY([Warehouse])
REFERENCES [dbo].[Warehouse] ([WarehouseName])
ON UPDATE CASCADE
GO
ALTER TABLE [dbo].[Sales_Product] CHECK CONSTRAINT [FK_Sales_Product_Warehouse]
GO
ALTER TABLE [dbo].[Salesman_Commission]  WITH CHECK ADD  CONSTRAINT [FK_Salesman_Commission_InvoiceInfo] FOREIGN KEY([InvoiceID])
REFERENCES [dbo].[InvoiceInfo] ([Inv_ID])
ON UPDATE CASCADE
ON DELETE CASCADE
GO
ALTER TABLE [dbo].[Salesman_Commission] CHECK CONSTRAINT [FK_Salesman_Commission_InvoiceInfo]
GO
ALTER TABLE [dbo].[SalesReturn]  WITH CHECK ADD  CONSTRAINT [FK_SalesReturn_InvoiceInfo] FOREIGN KEY([SalesID])
REFERENCES [dbo].[InvoiceInfo] ([Inv_ID])
ON UPDATE CASCADE
GO
ALTER TABLE [dbo].[SalesReturn] CHECK CONSTRAINT [FK_SalesReturn_InvoiceInfo]
GO
ALTER TABLE [dbo].[SalesReturn_Join]  WITH CHECK ADD  CONSTRAINT [FK_SalesReturn_Join_Product] FOREIGN KEY([ProductID])
REFERENCES [dbo].[Product] ([PID])
ON UPDATE CASCADE
ON DELETE CASCADE
GO
ALTER TABLE [dbo].[SalesReturn_Join] CHECK CONSTRAINT [FK_SalesReturn_Join_Product]
GO
ALTER TABLE [dbo].[SalesReturn_Join]  WITH CHECK ADD  CONSTRAINT [FK_SalesReturn_Join_SalesReturn] FOREIGN KEY([SalesReturnID])
REFERENCES [dbo].[SalesReturn] ([SR_ID])
ON UPDATE CASCADE
ON DELETE CASCADE
GO
ALTER TABLE [dbo].[SalesReturn_Join] CHECK CONSTRAINT [FK_SalesReturn_Join_SalesReturn]
GO
ALTER TABLE [dbo].[StockAdjustment_Store]  WITH CHECK ADD  CONSTRAINT [FK_StockAdjustment_Store_Product] FOREIGN KEY([ProductID])
REFERENCES [dbo].[Product] ([PID])
ON UPDATE CASCADE
GO
ALTER TABLE [dbo].[StockAdjustment_Store] CHECK CONSTRAINT [FK_StockAdjustment_Store_Product]
GO
ALTER TABLE [dbo].[StockAdjustment_Warehouse]  WITH CHECK ADD  CONSTRAINT [FK_StockAdjustment_Warehouse_Product] FOREIGN KEY([ProductID])
REFERENCES [dbo].[Product] ([PID])
ON UPDATE CASCADE
GO
ALTER TABLE [dbo].[StockAdjustment_Warehouse] CHECK CONSTRAINT [FK_StockAdjustment_Warehouse_Product]
GO
ALTER TABLE [dbo].[StockAdjustment_Warehouse]  WITH CHECK ADD  CONSTRAINT [FK_StockAdjustment_Warehouse_Warehouse] FOREIGN KEY([Warehouse])
REFERENCES [dbo].[Warehouse] ([WarehouseName])
ON UPDATE CASCADE
GO
ALTER TABLE [dbo].[StockAdjustment_Warehouse] CHECK CONSTRAINT [FK_StockAdjustment_Warehouse_Warehouse]
GO
ALTER TABLE [dbo].[StockTransfer]  WITH CHECK ADD  CONSTRAINT [FK_StockTransfer_Company] FOREIGN KEY([CompanyID])
REFERENCES [dbo].[Company] ([Id])
ON UPDATE CASCADE
GO
ALTER TABLE [dbo].[StockTransfer] CHECK CONSTRAINT [FK_StockTransfer_Company]
GO
ALTER TABLE [dbo].[StockTransfer_Join]  WITH CHECK ADD  CONSTRAINT [FK_StockTransfer_Join_StockTransfer] FOREIGN KEY([StockTransferID])
REFERENCES [dbo].[StockTransfer] ([ST_ID])
ON UPDATE CASCADE
ON DELETE CASCADE
GO
ALTER TABLE [dbo].[StockTransfer_Join] CHECK CONSTRAINT [FK_StockTransfer_Join_StockTransfer]
GO
ALTER TABLE [dbo].[StockTransfer_Join]  WITH CHECK ADD  CONSTRAINT [FK_StockTransfer_Product] FOREIGN KEY([ProductID])
REFERENCES [dbo].[Product] ([PID])
ON UPDATE CASCADE
GO
ALTER TABLE [dbo].[StockTransfer_Join] CHECK CONSTRAINT [FK_StockTransfer_Product]
GO
ALTER TABLE [dbo].[StockTransfer_Join]  WITH CHECK ADD  CONSTRAINT [FK_StockTransfer_Warehouse] FOREIGN KEY([Warehouse])
REFERENCES [dbo].[Warehouse] ([WarehouseName])
ON UPDATE CASCADE
GO
ALTER TABLE [dbo].[StockTransfer_Join] CHECK CONSTRAINT [FK_StockTransfer_Warehouse]
GO
ALTER TABLE [dbo].[StockTransfer_Join_S2W]  WITH CHECK ADD  CONSTRAINT [FK_StockTransfer_Join_S2W_Product] FOREIGN KEY([ProductID])
REFERENCES [dbo].[Product] ([PID])
ON UPDATE CASCADE
GO
ALTER TABLE [dbo].[StockTransfer_Join_S2W] CHECK CONSTRAINT [FK_StockTransfer_Join_S2W_Product]
GO
ALTER TABLE [dbo].[StockTransfer_Join_S2W]  WITH CHECK ADD  CONSTRAINT [FK_StockTransfer_Join_S2W_StockTransfer_S2W] FOREIGN KEY([StockTransferID])
REFERENCES [dbo].[StockTransfer_S2W] ([ST_ID])
ON UPDATE CASCADE
ON DELETE CASCADE
GO
ALTER TABLE [dbo].[StockTransfer_Join_S2W] CHECK CONSTRAINT [FK_StockTransfer_Join_S2W_StockTransfer_S2W]
GO
ALTER TABLE [dbo].[StockTransfer_Join_W2W]  WITH CHECK ADD  CONSTRAINT [FK_StockTransfer_Join_W2W_Product] FOREIGN KEY([ProductID])
REFERENCES [dbo].[Product] ([PID])
ON UPDATE CASCADE
GO
ALTER TABLE [dbo].[StockTransfer_Join_W2W] CHECK CONSTRAINT [FK_StockTransfer_Join_W2W_Product]
GO
ALTER TABLE [dbo].[StockTransfer_Join_W2W]  WITH CHECK ADD  CONSTRAINT [FK_StockTransfer_Join_W2W_StockTransfer_W2W] FOREIGN KEY([StockTransferID])
REFERENCES [dbo].[StockTransfer_W2W] ([ST_ID])
ON UPDATE CASCADE
ON DELETE CASCADE
GO
ALTER TABLE [dbo].[StockTransfer_Join_W2W] CHECK CONSTRAINT [FK_StockTransfer_Join_W2W_StockTransfer_W2W]
GO
ALTER TABLE [dbo].[StockTransfer_S2W]  WITH CHECK ADD  CONSTRAINT [FK_StockTransfer_S2W_Warehouse] FOREIGN KEY([Warehouse])
REFERENCES [dbo].[Warehouse] ([WarehouseName])
ON UPDATE CASCADE
GO
ALTER TABLE [dbo].[StockTransfer_S2W] CHECK CONSTRAINT [FK_StockTransfer_S2W_Warehouse]
GO
ALTER TABLE [dbo].[StockTransfer_W2W]  WITH CHECK ADD  CONSTRAINT [FK_StockTransfer_W2W_Warehouse] FOREIGN KEY([Warehouse])
REFERENCES [dbo].[Warehouse] ([WarehouseName])
ON UPDATE CASCADE
GO
ALTER TABLE [dbo].[StockTransfer_W2W] CHECK CONSTRAINT [FK_StockTransfer_W2W_Warehouse]
GO
ALTER TABLE [dbo].[TaxMaster]  WITH CHECK ADD  CONSTRAINT [FK_TaxMaster_TaxType] FOREIGN KEY([TaxType])
REFERENCES [dbo].[TaxType] ([Type])
ON UPDATE CASCADE
GO
ALTER TABLE [dbo].[TaxMaster] CHECK CONSTRAINT [FK_TaxMaster_TaxType]
GO
ALTER TABLE [dbo].[Temp_Stock]  WITH CHECK ADD  CONSTRAINT [FK_Temp_Stock_Product] FOREIGN KEY([ProductID])
REFERENCES [dbo].[Product] ([PID])
ON UPDATE CASCADE
ON DELETE CASCADE
GO
ALTER TABLE [dbo].[Temp_Stock] CHECK CONSTRAINT [FK_Temp_Stock_Product]
GO
ALTER TABLE [dbo].[Temp_Stock]  WITH CHECK ADD  CONSTRAINT [FK_Temp_Stock_Warehouse] FOREIGN KEY([Warehouse])
REFERENCES [dbo].[Warehouse] ([WarehouseName])
ON UPDATE CASCADE
ON DELETE CASCADE
GO
ALTER TABLE [dbo].[Temp_Stock] CHECK CONSTRAINT [FK_Temp_Stock_Warehouse]
GO
ALTER TABLE [dbo].[Temp_Stock_Company]  WITH CHECK ADD  CONSTRAINT [FK_Temp_Stock_Store_Product] FOREIGN KEY([ProductID])
REFERENCES [dbo].[Product] ([PID])
ON UPDATE CASCADE
ON DELETE CASCADE
GO
ALTER TABLE [dbo].[Temp_Stock_Company] CHECK CONSTRAINT [FK_Temp_Stock_Store_Product]
GO
ALTER TABLE [dbo].[UserRights]  WITH CHECK ADD  CONSTRAINT [FK_UserRights_Registration] FOREIGN KEY([UserID])
REFERENCES [dbo].[Registration] ([UserID])
ON UPDATE CASCADE
ON DELETE CASCADE
GO
ALTER TABLE [dbo].[UserRights] CHECK CONSTRAINT [FK_UserRights_Registration]
GO
ALTER TABLE [dbo].[Voucher_OtherDetails]  WITH CHECK ADD  CONSTRAINT [FK_Voucher_OtherDetails_Expense] FOREIGN KEY([Particulars])
REFERENCES [dbo].[Expense] ([ExpenseName])
ON UPDATE CASCADE
GO
ALTER TABLE [dbo].[Voucher_OtherDetails] CHECK CONSTRAINT [FK_Voucher_OtherDetails_Expense]
GO
ALTER TABLE [dbo].[Voucher_OtherDetails]  WITH CHECK ADD  CONSTRAINT [FK_Voucher_OtherDetails_Voucher] FOREIGN KEY([VoucherID])
REFERENCES [dbo].[Voucher] ([ID])
ON UPDATE CASCADE
ON DELETE CASCADE
GO
ALTER TABLE [dbo].[Voucher_OtherDetails] CHECK CONSTRAINT [FK_Voucher_OtherDetails_Voucher]
GO
ALTER TABLE [dbo].[Warehouse]  WITH CHECK ADD  CONSTRAINT [FK_Warehouse_WarehouseType] FOREIGN KEY([WarehouseType])
REFERENCES [dbo].[WarehouseType] ([Type])
ON UPDATE CASCADE
GO
ALTER TABLE [dbo].[Warehouse] CHECK CONSTRAINT [FK_Warehouse_WarehouseType]
GO
USE [master]
GO
ALTER DATABASE [RetailPOS_DB_AR] SET  READ_WRITE 
GO
