SET IDENTITY_INSERT [dbo].[PaymentDetail] ON 
INSERT [dbo].[PaymentDetail] ([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', 1, 168, 8.4, 14.11, 0, 0, 182.11, 0, CAST(N'2022-05-13T16:09:18.6572208' AS DateTime2), CAST(N'2022-05-13T16:09:18.6572241' AS DateTime2), N'admin@gmail.com', N'admin@gmail.com', 0)
INSERT [dbo].[PaymentDetail] ([Id], [PaymentId], [ItemId], [ItemName], [Quantity], [UnitPrice], [ItemVAT], [ItemVATAmount], [ItemDiscount], [ItemDiscountAmount], [TotalAmount], [IsReturn], [CreatedDate], [ModifiedDate], [CreatedBy], [ModifiedBy], [Cancelled]) VALUES (2, 1, 22, N'Icecream', 1, 231, 11.55, 26.68, 0, 0, 257.68, 0, CAST(N'2022-05-13T16:09:18.8029321' AS DateTime2), CAST(N'2022-05-13T16:09:18.8029331' AS DateTime2), N'admin@gmail.com', N'admin@gmail.com', 0)
INSERT [dbo].[PaymentDetail] ([Id], [PaymentId], [ItemId], [ItemName], [Quantity], [UnitPrice], [ItemVAT], [ItemVATAmount], [ItemDiscount], [ItemDiscountAmount], [TotalAmount], [IsReturn], [CreatedDate], [ModifiedDate], [CreatedBy], [ModifiedBy], [Cancelled]) VALUES (3, 1, 19, N'Orange', 1, 157.5, 7.88, 12.41, 0, 0, 169.91, 0, CAST(N'2022-05-13T16:09:18.8100152' AS DateTime2), CAST(N'2022-05-13T16:09:18.8100162' AS DateTime2), N'admin@gmail.com', N'admin@gmail.com', 0)
INSERT [dbo].[PaymentDetail] ([Id], [PaymentId], [ItemId], [ItemName], [Quantity], [UnitPrice], [ItemVAT], [ItemVATAmount], [ItemDiscount], [ItemDiscountAmount], [TotalAmount], [IsReturn], [CreatedDate], [ModifiedDate], [CreatedBy], [ModifiedBy], [Cancelled]) VALUES (4, 1, 21, N'Cocacoal', 3, 94.5, 4.73, 13.41, 0, 0, 296.91, 0, CAST(N'2022-05-13T16:09:18.8164148' AS DateTime2), CAST(N'2022-05-13T16:09:18.8164157' AS DateTime2), N'admin@gmail.com', N'admin@gmail.com', 0)
INSERT [dbo].[PaymentDetail] ([Id], [PaymentId], [ItemId], [ItemName], [Quantity], [UnitPrice], [ItemVAT], [ItemVATAmount], [ItemDiscount], [ItemDiscountAmount], [TotalAmount], [IsReturn], [CreatedDate], [ModifiedDate], [CreatedBy], [ModifiedBy], [Cancelled]) VALUES (5, 2, 23, N'Tomato', 1, 31.5, 1.58, 0.5, 0, 0, 32, 0, CAST(N'2022-05-13T16:10:03.6818987' AS DateTime2), CAST(N'2022-05-13T16:10:03.6819003' AS DateTime2), N'admin@gmail.com', N'admin@gmail.com', 0)
INSERT [dbo].[PaymentDetail] ([Id], [PaymentId], [ItemId], [ItemName], [Quantity], [UnitPrice], [ItemVAT], [ItemVATAmount], [ItemDiscount], [ItemDiscountAmount], [TotalAmount], [IsReturn], [CreatedDate], [ModifiedDate], [CreatedBy], [ModifiedBy], [Cancelled]) VALUES (6, 2, 20, N'Milk', 3, 73.5, 3.68, 8.11, 0, 0, 228.61, 0, CAST(N'2022-05-13T16:10:03.6998513' AS DateTime2), CAST(N'2022-05-13T16:10:03.6998523' AS DateTime2), N'admin@gmail.com', N'admin@gmail.com', 0)
INSERT [dbo].[PaymentDetail] ([Id], [PaymentId], [ItemId], [ItemName], [Quantity], [UnitPrice], [ItemVAT], [ItemVATAmount], [ItemDiscount], [ItemDiscountAmount], [TotalAmount], [IsReturn], [CreatedDate], [ModifiedDate], [CreatedBy], [ModifiedBy], [Cancelled]) VALUES (7, 3, 20, N'Milk', 2, 73.5, 3.68, 5.41, 0, 0, 152.41, 0, CAST(N'2022-05-13T16:10:39.3714422' AS DateTime2), CAST(N'2022-05-13T16:10:39.3714430' AS DateTime2), N'admin@gmail.com', N'admin@gmail.com', 0)
SET IDENTITY_INSERT [dbo].[PaymentDetail] ON 
