SET IDENTITY_INSERT [dbo].[PurchasesPayment] ON 
INSERT [dbo].[PurchasesPayment] ([Id], [SupplierId], [InvoiceNo], [QuoteNo], [CommonCharge], [Discount], [DiscountAmount], [VAT], [VATAmount], [SubTotal], [GrandTotal], [PaidAmount], [DueAmount], [ChangedAmount], [CurrencyId], [BranchId], [PaymentStatus], [Category], [PurchaseOrderNumber], [CustomerNote], [PrivateNote], [ReturnType], [CreatedDate], [ModifiedDate], [CreatedBy], [ModifiedBy], [Cancelled]) VALUES (1, 1, N'PINV1', NULL, 0, 0, 0, 0, 7302, 52200, 59502, 59502, 0, 0, 5, 1, 1, 1, NULL, NULL, NULL, 0, CAST(N'2022-10-07T18:18:25.1820000' AS DateTime2), CAST(N'2022-10-07T18:18:48.0068711' AS DateTime2), N'admin@gmail.com', NULL, 0)
INSERT [dbo].[PurchasesPayment] ([Id], [SupplierId], [InvoiceNo], [QuoteNo], [CommonCharge], [Discount], [DiscountAmount], [VAT], [VATAmount], [SubTotal], [GrandTotal], [PaidAmount], [DueAmount], [ChangedAmount], [CurrencyId], [BranchId], [PaymentStatus], [Category], [PurchaseOrderNumber], [CustomerNote], [PrivateNote], [ReturnType], [CreatedDate], [ModifiedDate], [CreatedBy], [ModifiedBy], [Cancelled]) VALUES (2, 1, N'PINV2', NULL, 0, 0, 0, 0, 24.5, 700, 724.5, 0, 724.5, 0, 5, 1, 2, 1, NULL, NULL, NULL, 0, CAST(N'2022-10-07T18:18:55.0490000' AS DateTime2), CAST(N'2022-10-07T18:19:03.0491780' AS DateTime2), N'admin@gmail.com', NULL, 0)
INSERT [dbo].[PurchasesPayment] ([Id], [SupplierId], [InvoiceNo], [QuoteNo], [CommonCharge], [Discount], [DiscountAmount], [VAT], [VATAmount], [SubTotal], [GrandTotal], [PaidAmount], [DueAmount], [ChangedAmount], [CurrencyId], [BranchId], [PaymentStatus], [Category], [PurchaseOrderNumber], [CustomerNote], [PrivateNote], [ReturnType], [CreatedDate], [ModifiedDate], [CreatedBy], [ModifiedBy], [Cancelled]) VALUES (3, 1, N'PINV3', NULL, 0, 0, 0, 0, 48600, 108000, 156600, 0, 156600, 0, 5, 1, 2, 1, NULL, NULL, NULL, 0, CAST(N'2022-10-07T18:19:05.7390000' AS DateTime2), CAST(N'2022-10-07T18:19:14.1160767' AS DateTime2), N'admin@gmail.com', NULL, 0)
INSERT [dbo].[PurchasesPayment] ([Id], [SupplierId], [InvoiceNo], [QuoteNo], [CommonCharge], [Discount], [DiscountAmount], [VAT], [VATAmount], [SubTotal], [GrandTotal], [PaidAmount], [DueAmount], [ChangedAmount], [CurrencyId], [BranchId], [PaymentStatus], [Category], [PurchaseOrderNumber], [CustomerNote], [PrivateNote], [ReturnType], [CreatedDate], [ModifiedDate], [CreatedBy], [ModifiedBy], [Cancelled]) VALUES (4, 1, N'PINV4', NULL, 0, 0, 0, 0, 864.5, 13700, 14564.5, 0, 14564.5, 0, 5, 1, 2, 1, NULL, NULL, NULL, 0, CAST(N'2022-10-07T18:19:16.2290000' AS DateTime2), CAST(N'2022-10-07T18:19:31.0156853' AS DateTime2), N'admin@gmail.com', NULL, 0)
INSERT [dbo].[PurchasesPayment] ([Id], [SupplierId], [InvoiceNo], [QuoteNo], [CommonCharge], [Discount], [DiscountAmount], [VAT], [VATAmount], [SubTotal], [GrandTotal], [PaidAmount], [DueAmount], [ChangedAmount], [CurrencyId], [BranchId], [PaymentStatus], [Category], [PurchaseOrderNumber], [CustomerNote], [PrivateNote], [ReturnType], [CreatedDate], [ModifiedDate], [CreatedBy], [ModifiedBy], [Cancelled]) VALUES (5, 1, N'PINV5', NULL, 0, 0, 0, 0, 429.5, 9700, 10129.5, 0, 10129.5, 0, 5, 4, 2, 1, NULL, NULL, NULL, 0, CAST(N'2022-10-07T18:20:28.5550000' AS DateTime2), CAST(N'2022-10-07T18:20:45.0750481' AS DateTime2), N'admin@gmail.com', NULL, 0)
SET IDENTITY_INSERT [dbo].[PurchasesPayment] OFF


SET IDENTITY_INSERT [dbo].[PurchasesPaymentDetail] ON 
INSERT [dbo].[PurchasesPaymentDetail] ([Id], [PaymentId], [ItemId], [ItemName], [Quantity], [UnitPrice], [ItemVAT], [ItemVATAmount], [ItemDiscount], [ItemDiscountAmount], [TotalAmount], [IsReturn], [CreatedDate], [ModifiedDate], [CreatedBy], [ModifiedBy], [Cancelled]) VALUES (1, 1, 25, N'Steel Water Bottle', 100, 160, 8, 1280, 0, 0, 17280, 0, CAST(N'2022-10-07T18:18:28.5462652' AS DateTime2), CAST(N'2022-10-07T18:18:35.1607153' AS DateTime2), N'admin@gmail.com', N'admin@gmail.com', 0)
INSERT [dbo].[PurchasesPaymentDetail] ([Id], [PaymentId], [ItemId], [ItemName], [Quantity], [UnitPrice], [ItemVAT], [ItemVATAmount], [ItemDiscount], [ItemDiscountAmount], [TotalAmount], [IsReturn], [CreatedDate], [ModifiedDate], [CreatedBy], [ModifiedBy], [Cancelled]) VALUES (2, 1, 24, N'Jonsonlotion', 100, 340, 17, 5780, 0, 0, 39780, 0, CAST(N'2022-10-07T18:18:38.0262556' AS DateTime2), CAST(N'2022-10-07T18:18:38.0262572' AS DateTime2), N'admin@gmail.com', N'admin@gmail.com', 0)
INSERT [dbo].[PurchasesPaymentDetail] ([Id], [PaymentId], [ItemId], [ItemName], [Quantity], [UnitPrice], [ItemVAT], [ItemVATAmount], [ItemDiscount], [ItemDiscountAmount], [TotalAmount], [IsReturn], [CreatedDate], [ModifiedDate], [CreatedBy], [ModifiedBy], [Cancelled]) VALUES (3, 1, 22, N'Icecream', 10, 220, 11, 242, 0, 0, 2442, 0, CAST(N'2022-10-07T18:18:44.2472637' AS DateTime2), CAST(N'2022-10-07T18:18:44.2472656' AS DateTime2), N'admin@gmail.com', N'admin@gmail.com', 0)
INSERT [dbo].[PurchasesPaymentDetail] ([Id], [PaymentId], [ItemId], [ItemName], [Quantity], [UnitPrice], [ItemVAT], [ItemVATAmount], [ItemDiscount], [ItemDiscountAmount], [TotalAmount], [IsReturn], [CreatedDate], [ModifiedDate], [CreatedBy], [ModifiedBy], [Cancelled]) VALUES (4, 2, 20, N'Milk', 10, 70, 3.5, 24.5, 0, 0, 724.5, 0, CAST(N'2022-10-07T18:19:01.5171498' AS DateTime2), CAST(N'2022-10-07T18:19:01.5171514' AS DateTime2), N'admin@gmail.com', N'admin@gmail.com', 0)
INSERT [dbo].[PurchasesPaymentDetail] ([Id], [PaymentId], [ItemId], [ItemName], [Quantity], [UnitPrice], [ItemVAT], [ItemVATAmount], [ItemDiscount], [ItemDiscountAmount], [TotalAmount], [IsReturn], [CreatedDate], [ModifiedDate], [CreatedBy], [ModifiedBy], [Cancelled]) VALUES (5, 3, 17, N'Xiaomi 9 Pro', 120, 900, 45, 48600, 0, 0, 156600, 0, CAST(N'2022-10-07T18:19:12.0630631' AS DateTime2), CAST(N'2022-10-07T18:19:12.0630654' AS DateTime2), N'admin@gmail.com', N'admin@gmail.com', 0)
INSERT [dbo].[PurchasesPaymentDetail] ([Id], [PaymentId], [ItemId], [ItemName], [Quantity], [UnitPrice], [ItemVAT], [ItemVATAmount], [ItemDiscount], [ItemDiscountAmount], [TotalAmount], [IsReturn], [CreatedDate], [ModifiedDate], [CreatedBy], [ModifiedBy], [Cancelled]) VALUES (6, 4, 14, N'Coffee Mug', 100, 120, 6, 720, 0, 0, 12720, 0, CAST(N'2022-10-07T18:19:23.1721350' AS DateTime2), CAST(N'2022-10-07T18:19:23.1721362' AS DateTime2), N'admin@gmail.com', N'admin@gmail.com', 0)
INSERT [dbo].[PurchasesPaymentDetail] ([Id], [PaymentId], [ItemId], [ItemName], [Quantity], [UnitPrice], [ItemVAT], [ItemVATAmount], [ItemDiscount], [ItemDiscountAmount], [TotalAmount], [IsReturn], [CreatedDate], [ModifiedDate], [CreatedBy], [ModifiedBy], [Cancelled]) VALUES (7, 4, 16, N'Olive oil', 10, 170, 8.5, 144.5, 0, 0, 1844.5, 0, CAST(N'2022-10-07T18:19:28.7182651' AS DateTime2), CAST(N'2022-10-07T18:19:28.7182668' AS DateTime2), N'admin@gmail.com', N'admin@gmail.com', 0)
INSERT [dbo].[PurchasesPaymentDetail] ([Id], [PaymentId], [ItemId], [ItemName], [Quantity], [UnitPrice], [ItemVAT], [ItemVATAmount], [ItemDiscount], [ItemDiscountAmount], [TotalAmount], [IsReturn], [CreatedDate], [ModifiedDate], [CreatedBy], [ModifiedBy], [Cancelled]) VALUES (8, 5, 21, N'Cocacoal', 100, 90, 4.5, 405, 0, 0, 9405, 0, CAST(N'2022-10-07T18:20:33.5973712' AS DateTime2), CAST(N'2022-10-07T18:20:33.5973727' AS DateTime2), N'admin@gmail.com', N'admin@gmail.com', 0)
INSERT [dbo].[PurchasesPaymentDetail] ([Id], [PaymentId], [ItemId], [ItemName], [Quantity], [UnitPrice], [ItemVAT], [ItemVATAmount], [ItemDiscount], [ItemDiscountAmount], [TotalAmount], [IsReturn], [CreatedDate], [ModifiedDate], [CreatedBy], [ModifiedBy], [Cancelled]) VALUES (9, 5, 20, N'Milk', 10, 70, 3.5, 24.5, 0, 0, 724.5, 0, CAST(N'2022-10-07T18:20:37.9699659' AS DateTime2), CAST(N'2022-10-07T18:20:37.9699679' AS DateTime2), N'admin@gmail.com', N'admin@gmail.com', 0)
SET IDENTITY_INSERT [dbo].[PurchasesPaymentDetail] OFF




