INSERT [dbo].[Commission] ([Id], [EmployeeId], [EmployeeType], [CommissionType], [Amount], [IsPaid], [Title], [InvoiceId], [HospitalId], [DateTime], [CreatedTime], [UpdatedTime], [MainInvoiceId], [PaymentGroup], [MainInvoiceCode], [InvoiceCode], [PercentOrValue], [InvoiceTotal], [LessAmount], [SpecialAmount], [Category], [InvoiceCreatedTime], [InvoiceDiagnosticTestId], [IsPaidFinally], [PaymentId], [ReceiptCreatedTime], [BarCodeImageUrl]) VALUES (N'bd6c3c22-f584-4f5e-a34a-740dc9d8560e', N'f58ff95f-89e6-4f8e-8868-a83828ebe999', N'Doctor', N'Biochemistry ', 50, 1, N'', N'3eddb765-d8ed-44bb-ad8a-2effd21d9b58', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2018-12-23T11:14:13.7564967' AS DateTime2), CAST(N'2018-12-23T11:21:43.2176009' AS DateTime2), N'NOTASSIGNED', N'NCR0077', NULL, N'NCDG0074', N'10%', 585, 65, 0, N'Test', CAST(N'2018-12-23T11:14:13.6797121' AS DateTime2), NULL, 1, N'NA', N'NA', N'NA')
INSERT [dbo].[Commission] ([Id], [EmployeeId], [EmployeeType], [CommissionType], [Amount], [IsPaid], [Title], [InvoiceId], [HospitalId], [DateTime], [CreatedTime], [UpdatedTime], [MainInvoiceId], [PaymentGroup], [MainInvoiceCode], [InvoiceCode], [PercentOrValue], [InvoiceTotal], [LessAmount], [SpecialAmount], [Category], [InvoiceCreatedTime], [InvoiceDiagnosticTestId], [IsPaidFinally], [PaymentId], [ReceiptCreatedTime], [BarCodeImageUrl]) VALUES (N'be3f47f0-2b60-4d13-a07f-cbcf9b758387', N'2f49ff36-b04f-4081-9261-60ec973da26d', N'UltraSoundDoctor', N'UltraSoundCategory_1', 0, 0, N'', N'bf6974a6-9f9e-4640-bd8f-535bab6e4eab', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2019-01-08T11:19:12.5665672' AS DateTime2), CAST(N'2019-02-03T08:17:35.7629175' AS DateTime2), N'NOTASSIGNED', N'NCR0114', N'NOTASSIGNED', N'NCDG0093', NULL, 307013, 10000, 0, N'Test', CAST(N'2019-01-07T16:47:29.9695552' AS DateTime2), N'5d0ed592-85d8-4dda-a970-b37c8909359e', 1, NULL, N'03-02-2019 8:17 AM', N'data:image/jpeg;base64,[encoded data, 8380 characters]')
INSERT [dbo].[Commission] ([Id], [EmployeeId], [EmployeeType], [CommissionType], [Amount], [IsPaid], [Title], [InvoiceId], [HospitalId], [DateTime], [CreatedTime], [UpdatedTime], [MainInvoiceId], [PaymentGroup], [MainInvoiceCode], [InvoiceCode], [PercentOrValue], [InvoiceTotal], [LessAmount], [SpecialAmount], [Category], [InvoiceCreatedTime], [InvoiceDiagnosticTestId], [IsPaidFinally], [PaymentId], [ReceiptCreatedTime], [BarCodeImageUrl]) VALUES (N'be6228cf-125c-423c-ad6c-f34587e1efc1', N'2f49ff36-b04f-4081-9261-60ec973da26d', N'Doctor', N'CT_2', 23.3, 0, N'', N'703d5936-69a5-45c0-a69e-1b32c6fcd0f7', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2019-01-07T11:10:20.4745365' AS DateTime2), CAST(N'2019-02-03T08:17:35.7629175' AS DateTime2), N'NOTASSIGNED', N'NCR0114', NULL, N'NCDG0085', N'10%', 1357, 0, 0, N'Test', CAST(N'2019-01-07T10:38:42.9472130' AS DateTime2), NULL, 1, NULL, N'03-02-2019 8:17 AM', N'data:image/jpeg;base64,[encoded data, 8380 characters]')
INSERT [dbo].[Commission] ([Id], [EmployeeId], [EmployeeType], [CommissionType], [Amount], [IsPaid], [Title], [InvoiceId], [HospitalId], [DateTime], [CreatedTime], [UpdatedTime], [MainInvoiceId], [PaymentGroup], [MainInvoiceCode], [InvoiceCode], [PercentOrValue], [InvoiceTotal], [LessAmount], [SpecialAmount], [Category], [InvoiceCreatedTime], [InvoiceDiagnosticTestId], [IsPaidFinally], [PaymentId], [ReceiptCreatedTime], [BarCodeImageUrl]) VALUES (N'bf952acf-eee3-41bb-ae02-d2d2ae9a38d7', N'5972905b-bc7d-495a-bc9d-4469871316b1', N'Doctor', N'Biochemistry', -370, 1, N'', N'fcc273a5-90e1-4238-901f-65511300243c', N'd821cd9f-ac10-4f94-92cf-c292cd83b2c0', NULL, CAST(N'2018-09-04T12:02:59.2800000' AS DateTime2), CAST(N'2018-09-04T22:35:23.4133333' AS DateTime2), N'13c7f850-bbad-496b-a304-64cdd2292055', N'RR0043', N'RINV0160', N'RDG0177', N'0%', 2160, 540, 0, N'Test', CAST(N'2018-08-29T21:43:25.7900000' AS DateTime2), NULL, 0, N'NA', N'NA', N'NA')
INSERT [dbo].[Commission] ([Id], [EmployeeId], [EmployeeType], [CommissionType], [Amount], [IsPaid], [Title], [InvoiceId], [HospitalId], [DateTime], [CreatedTime], [UpdatedTime], [MainInvoiceId], [PaymentGroup], [MainInvoiceCode], [InvoiceCode], [PercentOrValue], [InvoiceTotal], [LessAmount], [SpecialAmount], [Category], [InvoiceCreatedTime], [InvoiceDiagnosticTestId], [IsPaidFinally], [PaymentId], [ReceiptCreatedTime], [BarCodeImageUrl]) VALUES (N'bfb0d4e9-1bbf-4507-8759-391c5708b816', N'4c772c03-ef45-492a-82d7-24bd49320ea3', N'Doctor', N'ANESTHESIA_DOCTOR', 660, 1, N'KidneyOP_1', N'35309d68-3241-45dd-abff-5a49a3367c91', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2019-01-31T10:57:08.8405541' AS DateTime2), CAST(N'2019-02-02T16:33:46.1966396' AS DateTime2), N'c535df32-81aa-4031-919a-9b288bf847d0', NULL, N'NCINV0058', N'NCINV0058', N'3456', NULL, 0, 0, N'Operation', CAST(N'2019-01-31T10:57:08.6286581' AS DateTime2), NULL, 0, N'NCP0054', NULL, NULL)
INSERT [dbo].[Commission] ([Id], [EmployeeId], [EmployeeType], [CommissionType], [Amount], [IsPaid], [Title], [InvoiceId], [HospitalId], [DateTime], [CreatedTime], [UpdatedTime], [MainInvoiceId], [PaymentGroup], [MainInvoiceCode], [InvoiceCode], [PercentOrValue], [InvoiceTotal], [LessAmount], [SpecialAmount], [Category], [InvoiceCreatedTime], [InvoiceDiagnosticTestId], [IsPaidFinally], [PaymentId], [ReceiptCreatedTime], [BarCodeImageUrl]) VALUES (N'c042a07b-53a3-4320-8a03-89f01c84e17e', N'f58ff95f-89e6-4f8e-8868-a83828ebe999', N'Doctor', N'CombineCategory_1', 4.4, 0, N'', N'5e555d75-f6b1-4a96-8483-d65e27f3ec6b', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2019-01-07T16:44:25.5166539' AS DateTime2), CAST(N'2019-02-03T08:17:35.7629175' AS DateTime2), N'ebce39be-4d21-4251-835d-2620dd8fe8aa', N'NCR0114', NULL, N'NCDG0090', N'10%', 294, 0, 0, N'Test', CAST(N'2019-01-07T16:44:24.6661795' AS DateTime2), NULL, 1, NULL, N'03-02-2019 8:17 AM', N'data:image/jpeg;base64,[encoded data, 8380 characters]')
INSERT [dbo].[Commission] ([Id], [EmployeeId], [EmployeeType], [CommissionType], [Amount], [IsPaid], [Title], [InvoiceId], [HospitalId], [DateTime], [CreatedTime], [UpdatedTime], [MainInvoiceId], [PaymentGroup], [MainInvoiceCode], [InvoiceCode], [PercentOrValue], [InvoiceTotal], [LessAmount], [SpecialAmount], [Category], [InvoiceCreatedTime], [InvoiceDiagnosticTestId], [IsPaidFinally], [PaymentId], [ReceiptCreatedTime], [BarCodeImageUrl]) VALUES (N'c0ec3189-7ac4-4862-a10b-ffd23218ba43', N'4c772c03-ef45-492a-82d7-24bd49320ea3', N'Doctor', N'DoctorVisit', 3344, 1, N'', N'NOTASSIGNED', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2019-01-17T13:14:59.7198587' AS DateTime2), CAST(N'2019-01-17T13:16:26.2449862' AS DateTime2), N'f253682d-6adc-4661-b133-62ba078575b5', NULL, NULL, N'NOTASSIGNED', NULL, NULL, 0, 0, N'ADDED_JUST_FOR_COMMISSION', CAST(N'0001-01-01T00:00:00.0000000' AS DateTime2), NULL, 0, N'NCP0036', NULL, NULL)
INSERT [dbo].[Commission] ([Id], [EmployeeId], [EmployeeType], [CommissionType], [Amount], [IsPaid], [Title], [InvoiceId], [HospitalId], [DateTime], [CreatedTime], [UpdatedTime], [MainInvoiceId], [PaymentGroup], [MainInvoiceCode], [InvoiceCode], [PercentOrValue], [InvoiceTotal], [LessAmount], [SpecialAmount], [Category], [InvoiceCreatedTime], [InvoiceDiagnosticTestId], [IsPaidFinally], [PaymentId], [ReceiptCreatedTime], [BarCodeImageUrl]) VALUES (N'c0fcee48-5f20-40c8-9f52-61b15f3fb60d', N'4c772c03-ef45-492a-82d7-24bd49320ea3', N'Doctor', N'CombineCategory_1', 35.6, 0, N'', N'38eaf1ff-15e6-464b-afe4-8edfd638a740', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2019-01-07T11:52:53.1985796' AS DateTime2), CAST(N'2019-02-03T08:17:35.7629175' AS DateTime2), N'NOTASSIGNED', N'NCR0114', NULL, N'NCDG0087', N'10%', 14356, 1000, 0, N'Test', CAST(N'2019-01-07T11:52:53.0736566' AS DateTime2), NULL, 1, NULL, N'03-02-2019 8:17 AM', N'data:image/jpeg;base64,[encoded data, 8380 characters]')
INSERT [dbo].[Commission] ([Id], [EmployeeId], [EmployeeType], [CommissionType], [Amount], [IsPaid], [Title], [InvoiceId], [HospitalId], [DateTime], [CreatedTime], [UpdatedTime], [MainInvoiceId], [PaymentGroup], [MainInvoiceCode], [InvoiceCode], [PercentOrValue], [InvoiceTotal], [LessAmount], [SpecialAmount], [Category], [InvoiceCreatedTime], [InvoiceDiagnosticTestId], [IsPaidFinally], [PaymentId], [ReceiptCreatedTime], [BarCodeImageUrl]) VALUES (N'c1e4cae2-cb9a-41b8-af54-1b418fa2feb0', N'8d3cf8f9-7ef7-4008-b529-e05a062b3f0c', N'Doctor', N'SPECIAL_SURGEON', 2220, 0, N'KidneyOP_1', N'1d164d48-5760-4f63-9083-066b657fa554', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2019-01-16T11:39:05.4430353' AS DateTime2), CAST(N'2019-02-03T08:17:35.7629175' AS DateTime2), N'382d7597-0685-443c-b918-7aab224db486', N'NCR0114', N'NCINV0048', N'NCINV0048', N'2220', NULL, 0, 0, N'Operation', CAST(N'2019-01-16T11:39:05.0952503' AS DateTime2), NULL, 1, NULL, N'03-02-2019 8:17 AM', N'data:image/jpeg;base64,[encoded data, 8380 characters]')
INSERT [dbo].[Commission] ([Id], [EmployeeId], [EmployeeType], [CommissionType], [Amount], [IsPaid], [Title], [InvoiceId], [HospitalId], [DateTime], [CreatedTime], [UpdatedTime], [MainInvoiceId], [PaymentGroup], [MainInvoiceCode], [InvoiceCode], [PercentOrValue], [InvoiceTotal], [LessAmount], [SpecialAmount], [Category], [InvoiceCreatedTime], [InvoiceDiagnosticTestId], [IsPaidFinally], [PaymentId], [ReceiptCreatedTime], [BarCodeImageUrl]) VALUES (N'c1e73d1b-ef1a-41a4-90b5-dfae58ee20f7', N'f58ff95f-89e6-4f8e-8868-a83828ebe999', N'Doctor', N'Biochemistry ', 50, 1, N'', N'26b3e18b-3653-41c6-95af-cc1cff900d7f', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2018-12-24T12:13:57.3873896' AS DateTime2), CAST(N'2018-12-24T14:23:29.4297460' AS DateTime2), N'NOTASSIGNED', N'NCR0087', NULL, N'NCDG0075', N'10%', 867, 0, 0, N'Test', CAST(N'2018-12-24T12:13:56.8550827' AS DateTime2), NULL, 1, N'NCP0002', N'NA', N'NA')
INSERT [dbo].[Commission] ([Id], [EmployeeId], [EmployeeType], [CommissionType], [Amount], [IsPaid], [Title], [InvoiceId], [HospitalId], [DateTime], [CreatedTime], [UpdatedTime], [MainInvoiceId], [PaymentGroup], [MainInvoiceCode], [InvoiceCode], [PercentOrValue], [InvoiceTotal], [LessAmount], [SpecialAmount], [Category], [InvoiceCreatedTime], [InvoiceDiagnosticTestId], [IsPaidFinally], [PaymentId], [ReceiptCreatedTime], [BarCodeImageUrl]) VALUES (N'c2402f41-671b-4968-9149-cac2ca3adfdc', N'2f49ff36-b04f-4081-9261-60ec973da26d', N'Referral', N'UltraSoundCategory_2', 8.16, 1, N'', N'a022cb08-0c98-4969-a31f-1d5d2884fbbb', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2018-12-06T13:57:10.1079174' AS DateTime2), CAST(N'2018-12-06T15:14:18.7574420' AS DateTime2), N'NOTASSIGNED', N'NCR0042', NULL, N'NCDG0068', N'24%', 68, 0, 0, N'Test', CAST(N'2018-12-06T13:43:42.0771626' AS DateTime2), NULL, 0, N'NA', N'NA', N'NA')
INSERT [dbo].[Commission] ([Id], [EmployeeId], [EmployeeType], [CommissionType], [Amount], [IsPaid], [Title], [InvoiceId], [HospitalId], [DateTime], [CreatedTime], [UpdatedTime], [MainInvoiceId], [PaymentGroup], [MainInvoiceCode], [InvoiceCode], [PercentOrValue], [InvoiceTotal], [LessAmount], [SpecialAmount], [Category], [InvoiceCreatedTime], [InvoiceDiagnosticTestId], [IsPaidFinally], [PaymentId], [ReceiptCreatedTime], [BarCodeImageUrl]) VALUES (N'c24826b6-fc6a-45a1-a11e-65eba296f226', N'8d3cf8f9-7ef7-4008-b529-e05a062b3f0c', N'Referral', N'Biochemistry ', 75, 1, N'', N'eb7be4be-6bd1-45ba-9031-6297b013383c', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2019-02-03T11:14:29.3517213' AS DateTime2), CAST(N'2019-02-03T11:15:12.9411262' AS DateTime2), N'NOTASSIGNED', N'NCR0117', NULL, N'NCDG0116', N'10%', 1105, 0, 0, N'Test', CAST(N'2019-02-03T09:56:48.9540657' AS DateTime2), NULL, 1, N'NCP0066', N'03-02-2019 11:15 AM', N'data:image/jpeg;base64,[encoded data, 8320 characters]')
INSERT [dbo].[Commission] ([Id], [EmployeeId], [EmployeeType], [CommissionType], [Amount], [IsPaid], [Title], [InvoiceId], [HospitalId], [DateTime], [CreatedTime], [UpdatedTime], [MainInvoiceId], [PaymentGroup], [MainInvoiceCode], [InvoiceCode], [PercentOrValue], [InvoiceTotal], [LessAmount], [SpecialAmount], [Category], [InvoiceCreatedTime], [InvoiceDiagnosticTestId], [IsPaidFinally], [PaymentId], [ReceiptCreatedTime], [BarCodeImageUrl]) VALUES (N'c271b025-5ae4-429c-9d95-c4b672fa2fa6', N'4c772c03-ef45-492a-82d7-24bd49320ea3', N'Referral', N'CT_2', 110, 1, N'', N'22b6caac-53fd-43b0-a1fc-f5a38215c3a2', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2018-11-26T13:54:13.5235331' AS DateTime2), CAST(N'2018-12-22T16:36:52.8269747' AS DateTime2), N'NOTASSIGNED', N'NCR0008', NULL, N'NCDG0057', N'10%', 924.3, 102.7, 0, N'Test+OverAllAmount', CAST(N'2018-11-26T13:54:12.9779995' AS DateTime2), NULL, 1, N'NA', N'NA', N'NA')
INSERT [dbo].[Commission] ([Id], [EmployeeId], [EmployeeType], [CommissionType], [Amount], [IsPaid], [Title], [InvoiceId], [HospitalId], [DateTime], [CreatedTime], [UpdatedTime], [MainInvoiceId], [PaymentGroup], [MainInvoiceCode], [InvoiceCode], [PercentOrValue], [InvoiceTotal], [LessAmount], [SpecialAmount], [Category], [InvoiceCreatedTime], [InvoiceDiagnosticTestId], [IsPaidFinally], [PaymentId], [ReceiptCreatedTime], [BarCodeImageUrl]) VALUES (N'c2e2e965-1aed-4f91-b080-4b67cef86df7', N'4c772c03-ef45-492a-82d7-24bd49320ea3', N'Doctor', N'ANESTHESIA_DOCTOR', 1000, 1, N'KidneyOP_1', N'0cb8c3a4-5ed3-4945-9a65-9214be4c4765', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2018-12-26T12:17:48.1460315' AS DateTime2), CAST(N'2018-12-27T12:05:15.6370524' AS DateTime2), N'0c6f2449-2e4f-489d-8372-860af4eabf75', NULL, N'NCINV0041', N'NCINV0041', N'1000', NULL, 0, 0, N'Operation', CAST(N'2018-12-26T12:16:04.4329021' AS DateTime2), NULL, 0, N'NCP0025', NULL, N'NA')
INSERT [dbo].[Commission] ([Id], [EmployeeId], [EmployeeType], [CommissionType], [Amount], [IsPaid], [Title], [InvoiceId], [HospitalId], [DateTime], [CreatedTime], [UpdatedTime], [MainInvoiceId], [PaymentGroup], [MainInvoiceCode], [InvoiceCode], [PercentOrValue], [InvoiceTotal], [LessAmount], [SpecialAmount], [Category], [InvoiceCreatedTime], [InvoiceDiagnosticTestId], [IsPaidFinally], [PaymentId], [ReceiptCreatedTime], [BarCodeImageUrl]) VALUES (N'c2f9795b-2dc4-4535-8a5d-343157853ecc', N'24a50fd4-8d08-41d3-94e5-be95c9e77925', N'Doctor', N'Pathology (Combination)', -4.4776119402985071, 1, N'', N'b70eff46-b568-4872-a0ab-c1b3f08d0952', N'd821cd9f-ac10-4f94-92cf-c292cd83b2c0', NULL, CAST(N'2018-07-09T21:57:50.0000000' AS DateTime2), CAST(N'2018-09-04T22:35:23.4133333' AS DateTime2), N'aa1caee1-8c39-4ec8-b77c-a7419072800d', N'RR0003', N'RINV0002', N'RDG0010', N'0%', 3300, 50, 0, N'Test', CAST(N'2018-07-09T21:48:26.0000000' AS DateTime2), NULL, 0, N'NA', N'NA', N'NA')
INSERT [dbo].[Commission] ([Id], [EmployeeId], [EmployeeType], [CommissionType], [Amount], [IsPaid], [Title], [InvoiceId], [HospitalId], [DateTime], [CreatedTime], [UpdatedTime], [MainInvoiceId], [PaymentGroup], [MainInvoiceCode], [InvoiceCode], [PercentOrValue], [InvoiceTotal], [LessAmount], [SpecialAmount], [Category], [InvoiceCreatedTime], [InvoiceDiagnosticTestId], [IsPaidFinally], [PaymentId], [ReceiptCreatedTime], [BarCodeImageUrl]) VALUES (N'c3490dec-c7f6-4381-9d11-6623a377d736', N'e3d4a527-b8d6-4e80-8e15-ddd22394a385', N'Doctor', N'Ultrasound', -320, 1, N'', N'e6c7e2bf-19c9-4451-a118-c34a0c698c23', N'd821cd9f-ac10-4f94-92cf-c292cd83b2c0', NULL, CAST(N'2018-07-21T15:03:58.8633333' AS DateTime2), CAST(N'2018-09-04T22:35:23.4166667' AS DateTime2), N'dd5e3703-3ba2-4cc1-b199-9c5887a08b72', N'RR0037', N'RINV0031', N'RDG0049', N'0%', 1020, 680, 0, N'Test', CAST(N'2018-07-21T14:58:57.5700000' AS DateTime2), NULL, 0, N'NA', N'NA', N'NA')
INSERT [dbo].[Commission] ([Id], [EmployeeId], [EmployeeType], [CommissionType], [Amount], [IsPaid], [Title], [InvoiceId], [HospitalId], [DateTime], [CreatedTime], [UpdatedTime], [MainInvoiceId], [PaymentGroup], [MainInvoiceCode], [InvoiceCode], [PercentOrValue], [InvoiceTotal], [LessAmount], [SpecialAmount], [Category], [InvoiceCreatedTime], [InvoiceDiagnosticTestId], [IsPaidFinally], [PaymentId], [ReceiptCreatedTime], [BarCodeImageUrl]) VALUES (N'c3ed7fae-fd63-4e11-bfdf-314808e5cdf0', N'4c772c03-ef45-492a-82d7-24bd49320ea3', N'UltraSoundDoctor', N'UltraSoundCategory_2', 2000, 1, N'', N'c5e84ccb-38d8-4ca4-a224-92ea42e0f4c5', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2019-02-03T08:30:33.6703237' AS DateTime2), CAST(N'2019-02-03T08:44:45.7304082' AS DateTime2), N'NOTASSIGNED', N'NCR0115', N'NOTASSIGNED', N'NCDG0115', NULL, 889, 0, 0, N'test', CAST(N'2019-02-02T16:42:10.5098169' AS DateTime2), N'66f40bc0-859b-4db3-a54a-e21d029f3ea8', 1, N'NCP0063', N'03-02-2019 8:33 AM', N'data:image/jpeg;base64,[encoded data, 8332 characters]')
INSERT [dbo].[Commission] ([Id], [EmployeeId], [EmployeeType], [CommissionType], [Amount], [IsPaid], [Title], [InvoiceId], [HospitalId], [DateTime], [CreatedTime], [UpdatedTime], [MainInvoiceId], [PaymentGroup], [MainInvoiceCode], [InvoiceCode], [PercentOrValue], [InvoiceTotal], [LessAmount], [SpecialAmount], [Category], [InvoiceCreatedTime], [InvoiceDiagnosticTestId], [IsPaidFinally], [PaymentId], [ReceiptCreatedTime], [BarCodeImageUrl]) VALUES (N'c40ec595-28f5-4fc3-a430-4cc7e8f2dfc6', N'e3d4a527-b8d6-4e80-8e15-ddd22394a385', N'Doctor', N'Pathology', -6.5217391304347823, 1, N'', N'22d470c7-cb02-4d5b-99d5-c276c653412f', N'd821cd9f-ac10-4f94-92cf-c292cd83b2c0', NULL, CAST(N'2018-07-21T12:40:23.6600000' AS DateTime2), CAST(N'2018-09-04T22:35:23.4166667' AS DateTime2), N'45daa90c-6a81-4de1-a0b8-96142e893b17', N'RR0046', N'RINV0028', N'RDG0046', N'0%', 1100, 50, 0, N'Test', CAST(N'2018-07-21T12:32:18.4566667' AS DateTime2), NULL, 0, N'NA', N'NA', N'NA')
INSERT [dbo].[Commission] ([Id], [EmployeeId], [EmployeeType], [CommissionType], [Amount], [IsPaid], [Title], [InvoiceId], [HospitalId], [DateTime], [CreatedTime], [UpdatedTime], [MainInvoiceId], [PaymentGroup], [MainInvoiceCode], [InvoiceCode], [PercentOrValue], [InvoiceTotal], [LessAmount], [SpecialAmount], [Category], [InvoiceCreatedTime], [InvoiceDiagnosticTestId], [IsPaidFinally], [PaymentId], [ReceiptCreatedTime], [BarCodeImageUrl]) VALUES (N'c466a9f3-5007-4963-800a-2543b688d276', N'6ee087eb-7031-408f-b4ea-f567d250f75b', N'Doctor', N'Ultrasound', 126000, 0, N'', N'bf6974a6-9f9e-4640-bd8f-535bab6e4eab', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2019-01-08T11:29:27.6334722' AS DateTime2), CAST(N'2019-02-03T08:17:35.7629175' AS DateTime2), N'NOTASSIGNED', N'NCR0114', NULL, N'NCDG0093', N'18%', 13139963.79, 1000, 0, N'Test', CAST(N'2019-01-07T16:47:29.0000000' AS DateTime2), NULL, 1, NULL, N'03-02-2019 8:17 AM', N'data:image/jpeg;base64,[encoded data, 8380 characters]')
INSERT [dbo].[Commission] ([Id], [EmployeeId], [EmployeeType], [CommissionType], [Amount], [IsPaid], [Title], [InvoiceId], [HospitalId], [DateTime], [CreatedTime], [UpdatedTime], [MainInvoiceId], [PaymentGroup], [MainInvoiceCode], [InvoiceCode], [PercentOrValue], [InvoiceTotal], [LessAmount], [SpecialAmount], [Category], [InvoiceCreatedTime], [InvoiceDiagnosticTestId], [IsPaidFinally], [PaymentId], [ReceiptCreatedTime], [BarCodeImageUrl]) VALUES (N'c49bf1c5-7eda-4fc6-8d78-9d4440cede6a', N'4c772c03-ef45-492a-82d7-24bd49320ea3', N'UltraSoundDoctor', N'UltraSoundCategory_2', 0, 0, N'', N'bf6974a6-9f9e-4640-bd8f-535bab6e4eab', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2019-01-08T11:14:00.1717668' AS DateTime2), CAST(N'2019-02-03T08:17:35.7629175' AS DateTime2), N'NOTASSIGNED', N'NCR0114', N'NOTASSIGNED', N'NCDG0093', NULL, 303413, 10000, 0, N'Test', CAST(N'2019-01-07T16:47:29.9695552' AS DateTime2), N'31543210-5683-449b-8846-1d8f5c3ac0c3', 1, NULL, N'03-02-2019 8:17 AM', N'data:image/jpeg;base64,[encoded data, 8380 characters]')
INSERT [dbo].[Commission] ([Id], [EmployeeId], [EmployeeType], [CommissionType], [Amount], [IsPaid], [Title], [InvoiceId], [HospitalId], [DateTime], [CreatedTime], [UpdatedTime], [MainInvoiceId], [PaymentGroup], [MainInvoiceCode], [InvoiceCode], [PercentOrValue], [InvoiceTotal], [LessAmount], [SpecialAmount], [Category], [InvoiceCreatedTime], [InvoiceDiagnosticTestId], [IsPaidFinally], [PaymentId], [ReceiptCreatedTime], [BarCodeImageUrl]) VALUES (N'c4e41d51-a3e3-40d7-9c33-aa88588191c1', N'4c772c03-ef45-492a-82d7-24bd49320ea3', N'Doctor', N'ASSISTANT_SURGEON', 22, 0, N'KidneyOP_1', N'172d55ca-fd29-4f10-bb15-b9c83957b941', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2019-02-22T22:49:35.9703381' AS DateTime2), CAST(N'2019-02-22T22:49:35.9703381' AS DateTime2), N'd1039f90-a091-4ef6-ae6f-5c88d88c8fad', NULL, N'NCINV0064', N'NCINV0064', N'220', NULL, 0, 0, N'Operation', CAST(N'2019-02-22T22:49:35.7954201' AS DateTime2), NULL, 0, NULL, NULL, NULL)
INSERT [dbo].[Commission] ([Id], [EmployeeId], [EmployeeType], [CommissionType], [Amount], [IsPaid], [Title], [InvoiceId], [HospitalId], [DateTime], [CreatedTime], [UpdatedTime], [MainInvoiceId], [PaymentGroup], [MainInvoiceCode], [InvoiceCode], [PercentOrValue], [InvoiceTotal], [LessAmount], [SpecialAmount], [Category], [InvoiceCreatedTime], [InvoiceDiagnosticTestId], [IsPaidFinally], [PaymentId], [ReceiptCreatedTime], [BarCodeImageUrl]) VALUES (N'c58d77c7-c095-48a5-bba0-5d5e717dcc55', N'e3d4a527-b8d6-4e80-8e15-ddd22394a385', N'Doctor', N'Pathology', -60.000000000000007, 1, N'', N'e6c7e2bf-19c9-4451-a118-c34a0c698c23', N'd821cd9f-ac10-4f94-92cf-c292cd83b2c0', NULL, CAST(N'2018-07-21T15:03:58.8633333' AS DateTime2), CAST(N'2018-09-04T22:35:23.4166667' AS DateTime2), N'dd5e3703-3ba2-4cc1-b199-9c5887a08b72', N'RR0035', N'RINV0031', N'RDG0049', N'0%', 1020, 680, 0, N'Test', CAST(N'2018-07-21T14:58:57.5700000' AS DateTime2), NULL, 0, N'NA', N'NA', N'NA')
INSERT [dbo].[Commission] ([Id], [EmployeeId], [EmployeeType], [CommissionType], [Amount], [IsPaid], [Title], [InvoiceId], [HospitalId], [DateTime], [CreatedTime], [UpdatedTime], [MainInvoiceId], [PaymentGroup], [MainInvoiceCode], [InvoiceCode], [PercentOrValue], [InvoiceTotal], [LessAmount], [SpecialAmount], [Category], [InvoiceCreatedTime], [InvoiceDiagnosticTestId], [IsPaidFinally], [PaymentId], [ReceiptCreatedTime], [BarCodeImageUrl]) VALUES (N'c59f7c57-d25e-4a57-b562-211966b4d679', N'bb6d3d69-74b2-4218-b563-49d01cfbe205', N'Doctor', N'Biochemistry', 0, 0, N'', N'02a0bc61-fe04-4dab-a57c-673eaf1a8fea', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2019-02-22T22:34:51.0304636' AS DateTime2), CAST(N'2019-02-22T22:42:42.8431685' AS DateTime2), N'NOTASSIGNED', NULL, NULL, N'NCDG0119', N'0%', 9111.6, 1012.4, 0, N'Test', CAST(N'2019-02-22T22:34:49.1956179' AS DateTime2), NULL, 0, NULL, NULL, NULL)
INSERT [dbo].[Commission] ([Id], [EmployeeId], [EmployeeType], [CommissionType], [Amount], [IsPaid], [Title], [InvoiceId], [HospitalId], [DateTime], [CreatedTime], [UpdatedTime], [MainInvoiceId], [PaymentGroup], [MainInvoiceCode], [InvoiceCode], [PercentOrValue], [InvoiceTotal], [LessAmount], [SpecialAmount], [Category], [InvoiceCreatedTime], [InvoiceDiagnosticTestId], [IsPaidFinally], [PaymentId], [ReceiptCreatedTime], [BarCodeImageUrl]) VALUES (N'c67ae0d9-82c6-47d4-a8d4-b2e3acd38650', N'4c772c03-ef45-492a-82d7-24bd49320ea3', N'Doctor', N'Biochemistry ', 791.5, 0, N'', N'3e34586b-5b04-4755-ae22-5694878a495e', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2019-01-21T15:49:34.8288263' AS DateTime2), CAST(N'2019-02-03T08:17:35.7629175' AS DateTime2), N'NOTASSIGNED', N'NCR0114', NULL, N'NCDG0107', N'10%', 22280, 0, 0, N'Test', CAST(N'2019-01-21T15:49:31.1487126' AS DateTime2), NULL, 1, NULL, N'03-02-2019 8:17 AM', N'data:image/jpeg;base64,[encoded data, 8380 characters]')
INSERT [dbo].[Commission] ([Id], [EmployeeId], [EmployeeType], [CommissionType], [Amount], [IsPaid], [Title], [InvoiceId], [HospitalId], [DateTime], [CreatedTime], [UpdatedTime], [MainInvoiceId], [PaymentGroup], [MainInvoiceCode], [InvoiceCode], [PercentOrValue], [InvoiceTotal], [LessAmount], [SpecialAmount], [Category], [InvoiceCreatedTime], [InvoiceDiagnosticTestId], [IsPaidFinally], [PaymentId], [ReceiptCreatedTime], [BarCodeImageUrl]) VALUES (N'c6bf321f-7f18-4ed0-9e8a-7c3cafc6b079', N'f58ff95f-89e6-4f8e-8868-a83828ebe999', N'Doctor', N'UltraSoundCategory_1', 0, 0, N'', N'b19fdabe-22c4-4bfd-9e31-ce5c9110367b', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2018-11-29T16:14:24.8276819' AS DateTime2), CAST(N'2018-12-22T16:17:56.9948653' AS DateTime2), N'NOTASSIGNED', NULL, NULL, N'NCDG0061', N'0%', 157, 0, 0, N'Test', CAST(N'2018-11-29T16:14:24.7495605' AS DateTime2), NULL, 1, N'NA', N'NA', N'NA')
INSERT [dbo].[Commission] ([Id], [EmployeeId], [EmployeeType], [CommissionType], [Amount], [IsPaid], [Title], [InvoiceId], [HospitalId], [DateTime], [CreatedTime], [UpdatedTime], [MainInvoiceId], [PaymentGroup], [MainInvoiceCode], [InvoiceCode], [PercentOrValue], [InvoiceTotal], [LessAmount], [SpecialAmount], [Category], [InvoiceCreatedTime], [InvoiceDiagnosticTestId], [IsPaidFinally], [PaymentId], [ReceiptCreatedTime], [BarCodeImageUrl]) VALUES (N'c6cdd60a-ccf2-44af-862b-d9669c2ed597', N'2f49ff36-b04f-4081-9261-60ec973da26d', N'Doctor', N'DoctorVisit', 400, 1, N'', N'4d18c948-5466-4da6-a96b-2fef3505c7df', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2018-12-26T08:11:02.2810064' AS DateTime2), CAST(N'2018-12-27T12:05:15.7076295' AS DateTime2), N'0c6f2449-2e4f-489d-8372-860af4eabf75', NULL, NULL, N'NCINV0041', NULL, NULL, 0, 0, N'Operation', CAST(N'0001-01-01T00:00:00.0000000' AS DateTime2), NULL, 0, N'NCP0020', NULL, N'NA')
INSERT [dbo].[Commission] ([Id], [EmployeeId], [EmployeeType], [CommissionType], [Amount], [IsPaid], [Title], [InvoiceId], [HospitalId], [DateTime], [CreatedTime], [UpdatedTime], [MainInvoiceId], [PaymentGroup], [MainInvoiceCode], [InvoiceCode], [PercentOrValue], [InvoiceTotal], [LessAmount], [SpecialAmount], [Category], [InvoiceCreatedTime], [InvoiceDiagnosticTestId], [IsPaidFinally], [PaymentId], [ReceiptCreatedTime], [BarCodeImageUrl]) VALUES (N'c71aad1e-470b-4373-8f63-2c03d47d2496', N'2f49ff36-b04f-4081-9261-60ec973da26d', N'Doctor', N'SpecialSurgeon', 1000, 0, N'KidneyOP_1', N'54122edc-d414-4681-bcd9-8a2c5dea2efa', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2018-12-13T16:01:53.5431524' AS DateTime2), CAST(N'2018-12-22T16:17:56.9948653' AS DateTime2), N'3185ec7e-59f6-4fdc-b1ff-b0d47865fd59', NULL, N'NCINV0034', N'NCINV0034', N'1000', NULL, 0, 0, N'Operation', CAST(N'2018-12-13T15:34:21.0070266' AS DateTime2), NULL, 1, N'NA', N'NA', N'NA')
INSERT [dbo].[Commission] ([Id], [EmployeeId], [EmployeeType], [CommissionType], [Amount], [IsPaid], [Title], [InvoiceId], [HospitalId], [DateTime], [CreatedTime], [UpdatedTime], [MainInvoiceId], [PaymentGroup], [MainInvoiceCode], [InvoiceCode], [PercentOrValue], [InvoiceTotal], [LessAmount], [SpecialAmount], [Category], [InvoiceCreatedTime], [InvoiceDiagnosticTestId], [IsPaidFinally], [PaymentId], [ReceiptCreatedTime], [BarCodeImageUrl]) VALUES (N'c7651a8f-cd80-417d-864c-dcef7dd57425', N'4c772c03-ef45-492a-82d7-24bd49320ea3', N'Referral', N'CombineCategory_1', 65.9, 0, N'', N'34fc05d9-22b2-478c-9ca0-f9a14d2e39a3', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2018-11-22T15:12:52.0635048' AS DateTime2), CAST(N'2018-12-22T16:17:56.9948653' AS DateTime2), N'NOTASSIGNED', NULL, NULL, N'NCDG0050', N'10%', 7322.92, 822.8, 0, N'Test', CAST(N'2018-11-22T15:12:50.9855282' AS DateTime2), NULL, 1, N'NA', N'NA', N'NA')
INSERT [dbo].[Commission] ([Id], [EmployeeId], [EmployeeType], [CommissionType], [Amount], [IsPaid], [Title], [InvoiceId], [HospitalId], [DateTime], [CreatedTime], [UpdatedTime], [MainInvoiceId], [PaymentGroup], [MainInvoiceCode], [InvoiceCode], [PercentOrValue], [InvoiceTotal], [LessAmount], [SpecialAmount], [Category], [InvoiceCreatedTime], [InvoiceDiagnosticTestId], [IsPaidFinally], [PaymentId], [ReceiptCreatedTime], [BarCodeImageUrl]) VALUES (N'c776ecee-e31f-4417-9d74-7504f07048ee', N'4c772c03-ef45-492a-82d7-24bd49320ea3', N'Referral', N'CombineCategory_1', 12.3, 1, N'', N'4bac4ff3-459b-4475-8761-1773a8b06677', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2018-12-25T16:06:14.3482289' AS DateTime2), CAST(N'2018-12-25T16:07:36.8553368' AS DateTime2), N'NOTASSIGNED', N'NCR0091', NULL, N'NCDG0080', N'10%', 740.7, 82.3, 0, N'Test', CAST(N'2018-12-25T16:06:13.9164993' AS DateTime2), NULL, 1, N'NCP0013', N'25-Dec-18 4:07 PM', N'NA')
INSERT [dbo].[Commission] ([Id], [EmployeeId], [EmployeeType], [CommissionType], [Amount], [IsPaid], [Title], [InvoiceId], [HospitalId], [DateTime], [CreatedTime], [UpdatedTime], [MainInvoiceId], [PaymentGroup], [MainInvoiceCode], [InvoiceCode], [PercentOrValue], [InvoiceTotal], [LessAmount], [SpecialAmount], [Category], [InvoiceCreatedTime], [InvoiceDiagnosticTestId], [IsPaidFinally], [PaymentId], [ReceiptCreatedTime], [BarCodeImageUrl]) VALUES (N'c780d921-1cd6-4ebc-9852-e0484ad746d2', N'f58ff95f-89e6-4f8e-8868-a83828ebe999', N'Doctor', N'Biochemistry ', 50, 1, N'', N'4bac4ff3-459b-4475-8761-1773a8b06677', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2018-12-25T16:06:14.3372473' AS DateTime2), CAST(N'2018-12-25T16:07:39.3366352' AS DateTime2), N'NOTASSIGNED', N'NCR0092', NULL, N'NCDG0080', N'10%', 740.7, 82.3, 0, N'Test', CAST(N'2018-12-25T16:06:13.9164993' AS DateTime2), NULL, 1, N'NCP0012', N'25-Dec-18 4:07 PM', N'NA')
GO
INSERT [dbo].[Commission] ([Id], [EmployeeId], [EmployeeType], [CommissionType], [Amount], [IsPaid], [Title], [InvoiceId], [HospitalId], [DateTime], [CreatedTime], [UpdatedTime], [MainInvoiceId], [PaymentGroup], [MainInvoiceCode], [InvoiceCode], [PercentOrValue], [InvoiceTotal], [LessAmount], [SpecialAmount], [Category], [InvoiceCreatedTime], [InvoiceDiagnosticTestId], [IsPaidFinally], [PaymentId], [ReceiptCreatedTime], [BarCodeImageUrl]) VALUES (N'c7fb7726-917c-4819-a205-f71f9aa78b69', N'4c772c03-ef45-492a-82d7-24bd49320ea3', N'Referral', N'UltraSoundCategory_2', 10.2, 1, N'', N'24e4ffc4-6392-4eb1-a842-d19b9ccf6475', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2018-12-03T16:05:49.9443921' AS DateTime2), CAST(N'2018-12-03T16:23:12.2017090' AS DateTime2), N'NOTASSIGNED', N'NCR0021', NULL, N'NCDG0063', N'15%', 314, 0, 0, N'Test', CAST(N'2018-12-03T16:05:49.6665426' AS DateTime2), NULL, 0, N'NA', N'NA', N'NA')
INSERT [dbo].[Commission] ([Id], [EmployeeId], [EmployeeType], [CommissionType], [Amount], [IsPaid], [Title], [InvoiceId], [HospitalId], [DateTime], [CreatedTime], [UpdatedTime], [MainInvoiceId], [PaymentGroup], [MainInvoiceCode], [InvoiceCode], [PercentOrValue], [InvoiceTotal], [LessAmount], [SpecialAmount], [Category], [InvoiceCreatedTime], [InvoiceDiagnosticTestId], [IsPaidFinally], [PaymentId], [ReceiptCreatedTime], [BarCodeImageUrl]) VALUES (N'c821039d-3d0e-4299-9e57-0e3d6d56d93a', N'f58ff95f-89e6-4f8e-8868-a83828ebe999', N'Doctor', N'ASSIGNED_DOCTOR', 2220, 0, N'KidneyOP_1', N'1d164d48-5760-4f63-9083-066b657fa554', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2019-01-16T11:39:05.3630848' AS DateTime2), CAST(N'2019-02-03T08:17:35.7629175' AS DateTime2), N'382d7597-0685-443c-b918-7aab224db486', N'NCR0114', N'NCINV0048', N'NCINV0048', N'2220', NULL, 0, 0, N'Operation', CAST(N'2019-01-16T11:39:05.0952503' AS DateTime2), NULL, 1, NULL, N'03-02-2019 8:17 AM', N'data:image/jpeg;base64,[encoded data, 8380 characters]')
INSERT [dbo].[Commission] ([Id], [EmployeeId], [EmployeeType], [CommissionType], [Amount], [IsPaid], [Title], [InvoiceId], [HospitalId], [DateTime], [CreatedTime], [UpdatedTime], [MainInvoiceId], [PaymentGroup], [MainInvoiceCode], [InvoiceCode], [PercentOrValue], [InvoiceTotal], [LessAmount], [SpecialAmount], [Category], [InvoiceCreatedTime], [InvoiceDiagnosticTestId], [IsPaidFinally], [PaymentId], [ReceiptCreatedTime], [BarCodeImageUrl]) VALUES (N'c88b11bf-574b-4cde-b0f0-2d3eb9745a1c', N'1fc95b60-c117-4163-b73d-37bd64d7fac8', N'Doctor', N'CLINIC_REFERRAL', 77, 0, N'ClinicInvoice', N'NOTASSIGNED', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2019-01-17T12:09:52.5659455' AS DateTime2), CAST(N'2019-02-03T08:17:35.7629175' AS DateTime2), N'54863b24-e825-429a-9631-211c636d6bd2', N'NCR0114', NULL, N'NOTASSIGNED', N'77', NULL, 0, 0, N'ADDED_JUST_FOR_COMMISSION', CAST(N'0001-01-01T00:00:00.0000000' AS DateTime2), NULL, 1, NULL, N'03-02-2019 8:17 AM', N'data:image/jpeg;base64,[encoded data, 8380 characters]')
INSERT [dbo].[Commission] ([Id], [EmployeeId], [EmployeeType], [CommissionType], [Amount], [IsPaid], [Title], [InvoiceId], [HospitalId], [DateTime], [CreatedTime], [UpdatedTime], [MainInvoiceId], [PaymentGroup], [MainInvoiceCode], [InvoiceCode], [PercentOrValue], [InvoiceTotal], [LessAmount], [SpecialAmount], [Category], [InvoiceCreatedTime], [InvoiceDiagnosticTestId], [IsPaidFinally], [PaymentId], [ReceiptCreatedTime], [BarCodeImageUrl]) VALUES (N'c8b7ffd3-0ce5-4ae3-b9c8-15c85abed496', N'f58ff95f-89e6-4f8e-8868-a83828ebe999', N'Doctor', N'CombineCategory_1', 12.3, 1, N'', N'26b3e18b-3653-41c6-95af-cc1cff900d7f', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2018-12-24T12:13:57.4070503' AS DateTime2), CAST(N'2018-12-24T14:23:29.4317445' AS DateTime2), N'NOTASSIGNED', N'NCR0087', NULL, N'NCDG0075', N'10%', 867, 0, 0, N'Test', CAST(N'2018-12-24T12:13:56.8550827' AS DateTime2), NULL, 1, N'NCP0002', N'NA', N'NA')
INSERT [dbo].[Commission] ([Id], [EmployeeId], [EmployeeType], [CommissionType], [Amount], [IsPaid], [Title], [InvoiceId], [HospitalId], [DateTime], [CreatedTime], [UpdatedTime], [MainInvoiceId], [PaymentGroup], [MainInvoiceCode], [InvoiceCode], [PercentOrValue], [InvoiceTotal], [LessAmount], [SpecialAmount], [Category], [InvoiceCreatedTime], [InvoiceDiagnosticTestId], [IsPaidFinally], [PaymentId], [ReceiptCreatedTime], [BarCodeImageUrl]) VALUES (N'c8c2a436-49bd-4340-a06b-dc602e70256e', N'2f49ff36-b04f-4081-9261-60ec973da26d', N'Referral', N'CT_2', 273, 0, N'', N'bf6974a6-9f9e-4640-bd8f-535bab6e4eab', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2019-01-08T10:26:12.7237315' AS DateTime2), CAST(N'2019-02-03T08:17:35.7629175' AS DateTime2), N'NOTASSIGNED', N'NCR0114', NULL, N'NCDG0093', N'10%', 13139963.79, 1000, 0, N'Test', CAST(N'2019-01-07T16:47:29.0000000' AS DateTime2), NULL, 1, NULL, N'03-02-2019 8:17 AM', N'data:image/jpeg;base64,[encoded data, 8380 characters]')
INSERT [dbo].[Commission] ([Id], [EmployeeId], [EmployeeType], [CommissionType], [Amount], [IsPaid], [Title], [InvoiceId], [HospitalId], [DateTime], [CreatedTime], [UpdatedTime], [MainInvoiceId], [PaymentGroup], [MainInvoiceCode], [InvoiceCode], [PercentOrValue], [InvoiceTotal], [LessAmount], [SpecialAmount], [Category], [InvoiceCreatedTime], [InvoiceDiagnosticTestId], [IsPaidFinally], [PaymentId], [ReceiptCreatedTime], [BarCodeImageUrl]) VALUES (N'c94c0115-2fda-4189-9429-bb4a577a1607', N'f58ff95f-89e6-4f8e-8868-a83828ebe999', N'Referral', N'Haematology', 15, 0, N'', N'8be24963-914e-473d-b269-d80182e42daf', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2018-11-25T08:59:06.4224617' AS DateTime2), CAST(N'2018-12-22T16:17:56.9948653' AS DateTime2), N'NOTASSIGNED', NULL, NULL, N'NCDG0054', N'10%', 4699.8, 522.2, 0, N'Test', CAST(N'2018-11-25T08:59:05.7217518' AS DateTime2), NULL, 1, N'NA', N'NA', N'NA')
INSERT [dbo].[Commission] ([Id], [EmployeeId], [EmployeeType], [CommissionType], [Amount], [IsPaid], [Title], [InvoiceId], [HospitalId], [DateTime], [CreatedTime], [UpdatedTime], [MainInvoiceId], [PaymentGroup], [MainInvoiceCode], [InvoiceCode], [PercentOrValue], [InvoiceTotal], [LessAmount], [SpecialAmount], [Category], [InvoiceCreatedTime], [InvoiceDiagnosticTestId], [IsPaidFinally], [PaymentId], [ReceiptCreatedTime], [BarCodeImageUrl]) VALUES (N'c9aaf05f-b2cd-4e96-a887-d71612790c1f', N'f58ff95f-89e6-4f8e-8868-a83828ebe999', N'Doctor', N'Biochemistry ', 108.3, 1, N'', N'7563126c-a5b2-40ab-bdef-ef3b9f9dbfc4', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2018-11-26T09:22:22.5386890' AS DateTime2), CAST(N'2018-11-26T13:54:40.8539228' AS DateTime2), N'NOTASSIGNED', N'NCR0005', NULL, N'NCDG0056', N'10%', 1227.03, 499.97, 0, N'Test', CAST(N'2018-11-26T09:22:21.0580030' AS DateTime2), NULL, 0, N'NA', N'NA', N'NA')
INSERT [dbo].[Commission] ([Id], [EmployeeId], [EmployeeType], [CommissionType], [Amount], [IsPaid], [Title], [InvoiceId], [HospitalId], [DateTime], [CreatedTime], [UpdatedTime], [MainInvoiceId], [PaymentGroup], [MainInvoiceCode], [InvoiceCode], [PercentOrValue], [InvoiceTotal], [LessAmount], [SpecialAmount], [Category], [InvoiceCreatedTime], [InvoiceDiagnosticTestId], [IsPaidFinally], [PaymentId], [ReceiptCreatedTime], [BarCodeImageUrl]) VALUES (N'ca8f564f-6020-4225-bf4c-70ff86b2cc2a', N'4c772c03-ef45-492a-82d7-24bd49320ea3', N'Doctor', N'CombineCategory_1', 12.3, 0, N'', N'15a731c0-16d0-4ab4-a55b-8352a17027fc', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2018-11-19T15:21:13.0996055' AS DateTime2), CAST(N'2018-12-22T16:17:56.9948653' AS DateTime2), N'NOTASSIGNED', NULL, NULL, N'NCDG0043', N'10%', 1556, 0, 0, N'Test', CAST(N'0001-01-01T00:00:00.0000000' AS DateTime2), NULL, 1, N'NA', N'NA', N'NA')
INSERT [dbo].[Commission] ([Id], [EmployeeId], [EmployeeType], [CommissionType], [Amount], [IsPaid], [Title], [InvoiceId], [HospitalId], [DateTime], [CreatedTime], [UpdatedTime], [MainInvoiceId], [PaymentGroup], [MainInvoiceCode], [InvoiceCode], [PercentOrValue], [InvoiceTotal], [LessAmount], [SpecialAmount], [Category], [InvoiceCreatedTime], [InvoiceDiagnosticTestId], [IsPaidFinally], [PaymentId], [ReceiptCreatedTime], [BarCodeImageUrl]) VALUES (N'caa170f5-211a-4a65-a95c-b5252ca3ff51', N'2f49ff36-b04f-4081-9261-60ec973da26d', N'Referral', N'CombineCategory_1', 100, 1, N'', N'26b3e18b-3653-41c6-95af-cc1cff900d7f', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2018-12-24T12:13:57.4173188' AS DateTime2), CAST(N'2018-12-24T14:16:30.8806509' AS DateTime2), N'NOTASSIGNED', N'NCR0086', NULL, N'NCDG0075', N'10%', 867, 0, 0, N'Test', CAST(N'2018-12-24T12:13:56.8550827' AS DateTime2), NULL, 1, N'NCP0003', N'NA', N'NA')
INSERT [dbo].[Commission] ([Id], [EmployeeId], [EmployeeType], [CommissionType], [Amount], [IsPaid], [Title], [InvoiceId], [HospitalId], [DateTime], [CreatedTime], [UpdatedTime], [MainInvoiceId], [PaymentGroup], [MainInvoiceCode], [InvoiceCode], [PercentOrValue], [InvoiceTotal], [LessAmount], [SpecialAmount], [Category], [InvoiceCreatedTime], [InvoiceDiagnosticTestId], [IsPaidFinally], [PaymentId], [ReceiptCreatedTime], [BarCodeImageUrl]) VALUES (N'caa80b4f-dfd9-4ee4-b83d-7aef70cab9d1', N'f58ff95f-89e6-4f8e-8868-a83828ebe999', N'UltraSoundDoctor', N'UltraSoundCategory_2', 100, 1, N'', N'b19fdabe-22c4-4bfd-9e31-ce5c9110367b', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2018-11-29T16:14:24.7808084' AS DateTime2), CAST(N'2018-12-02T15:50:26.1834295' AS DateTime2), N'NOTASSIGNED', N'NCR0011', N'NOTASSIGNED', N'NCDG0061', NULL, 157, 0, 0, N'test', CAST(N'2018-11-29T16:14:24.7495605' AS DateTime2), NULL, 0, N'NA', N'NA', N'NA')
INSERT [dbo].[Commission] ([Id], [EmployeeId], [EmployeeType], [CommissionType], [Amount], [IsPaid], [Title], [InvoiceId], [HospitalId], [DateTime], [CreatedTime], [UpdatedTime], [MainInvoiceId], [PaymentGroup], [MainInvoiceCode], [InvoiceCode], [PercentOrValue], [InvoiceTotal], [LessAmount], [SpecialAmount], [Category], [InvoiceCreatedTime], [InvoiceDiagnosticTestId], [IsPaidFinally], [PaymentId], [ReceiptCreatedTime], [BarCodeImageUrl]) VALUES (N'cacb5bda-4734-4364-bdec-dc1aab57cd2a', N'cbfa4e4e-2fdf-48c7-9b94-e4712cf1f267', N'Referral', N'Serology', -42.307692307692307, 1, N'', N'daf7c28c-4e05-453f-9b21-b814e85a24e9', N'd821cd9f-ac10-4f94-92cf-c292cd83b2c0', NULL, CAST(N'2018-09-04T12:34:13.3666667' AS DateTime2), CAST(N'2018-09-04T22:35:23.4200000' AS DateTime2), N'b165f658-f1e5-4e8d-902c-61e20171ec3c', N'RR0051', N'RINV0176', N'RDG0192', N'0%', 1200, 100, 0, N'Test', CAST(N'2018-09-01T10:23:20.5533333' AS DateTime2), NULL, 0, N'NA', N'NA', N'NA')
INSERT [dbo].[Commission] ([Id], [EmployeeId], [EmployeeType], [CommissionType], [Amount], [IsPaid], [Title], [InvoiceId], [HospitalId], [DateTime], [CreatedTime], [UpdatedTime], [MainInvoiceId], [PaymentGroup], [MainInvoiceCode], [InvoiceCode], [PercentOrValue], [InvoiceTotal], [LessAmount], [SpecialAmount], [Category], [InvoiceCreatedTime], [InvoiceDiagnosticTestId], [IsPaidFinally], [PaymentId], [ReceiptCreatedTime], [BarCodeImageUrl]) VALUES (N'cb7a2e61-1902-49de-ae82-c17a732ed8a1', N'f58ff95f-89e6-4f8e-8868-a83828ebe999', N'Doctor', N'UltraSoundCategory_1', 246, 0, N'', N'9ec3c26c-7cfa-44f4-8e24-98f3073d3ea5', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2018-12-06T15:26:18.5965347' AS DateTime2), CAST(N'2018-12-22T16:17:56.9948653' AS DateTime2), N'NOTASSIGNED', NULL, NULL, N'NCDG0069', N'20%', 1683, 187, 0, N'Test', CAST(N'2018-12-06T15:26:18.2047477' AS DateTime2), NULL, 1, N'NA', N'NA', N'NA')
INSERT [dbo].[Commission] ([Id], [EmployeeId], [EmployeeType], [CommissionType], [Amount], [IsPaid], [Title], [InvoiceId], [HospitalId], [DateTime], [CreatedTime], [UpdatedTime], [MainInvoiceId], [PaymentGroup], [MainInvoiceCode], [InvoiceCode], [PercentOrValue], [InvoiceTotal], [LessAmount], [SpecialAmount], [Category], [InvoiceCreatedTime], [InvoiceDiagnosticTestId], [IsPaidFinally], [PaymentId], [ReceiptCreatedTime], [BarCodeImageUrl]) VALUES (N'cb871f5b-ec27-46cb-882d-be696996b028', N'e3d4a527-b8d6-4e80-8e15-ddd22394a385', N'Doctor', N'Ultrasound', -26.086956521739129, 1, N'', N'22d470c7-cb02-4d5b-99d5-c276c653412f', N'd821cd9f-ac10-4f94-92cf-c292cd83b2c0', NULL, CAST(N'2018-07-21T12:40:23.5966667' AS DateTime2), CAST(N'2018-09-04T22:35:23.4200000' AS DateTime2), N'45daa90c-6a81-4de1-a0b8-96142e893b17', N'RR0046', N'RINV0028', N'RDG0046', N'0%', 1100, 50, 0, N'Test', CAST(N'2018-07-21T12:32:18.4566667' AS DateTime2), NULL, 0, N'NA', N'NA', N'NA')
INSERT [dbo].[Commission] ([Id], [EmployeeId], [EmployeeType], [CommissionType], [Amount], [IsPaid], [Title], [InvoiceId], [HospitalId], [DateTime], [CreatedTime], [UpdatedTime], [MainInvoiceId], [PaymentGroup], [MainInvoiceCode], [InvoiceCode], [PercentOrValue], [InvoiceTotal], [LessAmount], [SpecialAmount], [Category], [InvoiceCreatedTime], [InvoiceDiagnosticTestId], [IsPaidFinally], [PaymentId], [ReceiptCreatedTime], [BarCodeImageUrl]) VALUES (N'cbdb554d-bc63-4f76-9512-03e26a043daa', N'f58ff95f-89e6-4f8e-8868-a83828ebe999', N'Doctor', N'CLINIC_REFERRAL', 555, 0, N'ClinicInvoice', N'NOTASSIGNED', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2019-01-17T11:46:49.8036434' AS DateTime2), CAST(N'2019-02-03T08:17:35.7629175' AS DateTime2), N'409081dc-7ea0-4c1a-9ac9-e50472e9bb1f', N'NCR0114', NULL, N'NOTASSIGNED', N'555', NULL, 0, 0, N'ADDED_JUST_FOR_COMMISSION', CAST(N'0001-01-01T00:00:00.0000000' AS DateTime2), NULL, 1, NULL, N'03-02-2019 8:17 AM', N'data:image/jpeg;base64,[encoded data, 8380 characters]')
INSERT [dbo].[Commission] ([Id], [EmployeeId], [EmployeeType], [CommissionType], [Amount], [IsPaid], [Title], [InvoiceId], [HospitalId], [DateTime], [CreatedTime], [UpdatedTime], [MainInvoiceId], [PaymentGroup], [MainInvoiceCode], [InvoiceCode], [PercentOrValue], [InvoiceTotal], [LessAmount], [SpecialAmount], [Category], [InvoiceCreatedTime], [InvoiceDiagnosticTestId], [IsPaidFinally], [PaymentId], [ReceiptCreatedTime], [BarCodeImageUrl]) VALUES (N'cc404a93-214e-4c7a-b13e-5982467a68ae', N'f58ff95f-89e6-4f8e-8868-a83828ebe999', N'Doctor', N'CLINIC_REFERRAL', 220, 0, N'ClinicInvoice', N'd6d08d5c-02e3-4d18-845a-a407ed8a4c8d', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2019-02-22T22:50:08.8259336' AS DateTime2), CAST(N'2019-02-22T22:50:08.8259336' AS DateTime2), N'd1039f90-a091-4ef6-ae6f-5c88d88c8fad', NULL, N'NCINV0064', N'NOTASSIGNED', N'220', NULL, 0, 0, N'OPERATION', CAST(N'2019-02-22T22:43:49.4365512' AS DateTime2), NULL, 0, NULL, NULL, NULL)
INSERT [dbo].[Commission] ([Id], [EmployeeId], [EmployeeType], [CommissionType], [Amount], [IsPaid], [Title], [InvoiceId], [HospitalId], [DateTime], [CreatedTime], [UpdatedTime], [MainInvoiceId], [PaymentGroup], [MainInvoiceCode], [InvoiceCode], [PercentOrValue], [InvoiceTotal], [LessAmount], [SpecialAmount], [Category], [InvoiceCreatedTime], [InvoiceDiagnosticTestId], [IsPaidFinally], [PaymentId], [ReceiptCreatedTime], [BarCodeImageUrl]) VALUES (N'cc4d2fab-bbc7-4964-a2e8-598a79fe0339', N'c3c1951b-2c4d-4567-9d89-2855bdaf5baf', N'Referral', N'Hematology', 40, 1, N'', N'aeaa6efb-8389-4057-9cec-761f3127e92c', N'd821cd9f-ac10-4f94-92cf-c292cd83b2c0', NULL, CAST(N'2018-08-03T15:08:16.9400000' AS DateTime2), CAST(N'2018-09-04T22:35:23.4200000' AS DateTime2), N'58185790-2cb4-4666-8850-1480190f4f9e', N'RR0049', N'RINV0088', N'RDG0105', N'40', 200, 0, 0, N'Test', CAST(N'2018-08-03T13:33:32.7200000' AS DateTime2), NULL, 0, N'NA', N'NA', N'NA')
INSERT [dbo].[Commission] ([Id], [EmployeeId], [EmployeeType], [CommissionType], [Amount], [IsPaid], [Title], [InvoiceId], [HospitalId], [DateTime], [CreatedTime], [UpdatedTime], [MainInvoiceId], [PaymentGroup], [MainInvoiceCode], [InvoiceCode], [PercentOrValue], [InvoiceTotal], [LessAmount], [SpecialAmount], [Category], [InvoiceCreatedTime], [InvoiceDiagnosticTestId], [IsPaidFinally], [PaymentId], [ReceiptCreatedTime], [BarCodeImageUrl]) VALUES (N'cd7edd4b-00e9-48de-98e8-12cc7969351b', N'4c772c03-ef45-492a-82d7-24bd49320ea3', N'Doctor', N'Haematology', 15, 0, N'', N'209481c5-8894-40e0-9811-794b49bb6446', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2018-11-28T08:59:15.3707876' AS DateTime2), CAST(N'2018-12-22T16:17:56.9948653' AS DateTime2), N'NOTASSIGNED', NULL, NULL, N'NCDG0060', N'10%', 7374.6, 819.4, 0, N'Test', CAST(N'2018-11-28T08:59:14.2156449' AS DateTime2), NULL, 1, N'NA', N'NA', N'NA')
INSERT [dbo].[Commission] ([Id], [EmployeeId], [EmployeeType], [CommissionType], [Amount], [IsPaid], [Title], [InvoiceId], [HospitalId], [DateTime], [CreatedTime], [UpdatedTime], [MainInvoiceId], [PaymentGroup], [MainInvoiceCode], [InvoiceCode], [PercentOrValue], [InvoiceTotal], [LessAmount], [SpecialAmount], [Category], [InvoiceCreatedTime], [InvoiceDiagnosticTestId], [IsPaidFinally], [PaymentId], [ReceiptCreatedTime], [BarCodeImageUrl]) VALUES (N'cd867f0c-041d-42a9-a91f-022f61bffa11', N'f58ff95f-89e6-4f8e-8868-a83828ebe999', N'Doctor', N'Conbination', 30, 0, N'', N'9ec3c26c-7cfa-44f4-8e24-98f3073d3ea5', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2018-12-06T15:32:43.5311657' AS DateTime2), CAST(N'2018-12-22T16:17:56.9948653' AS DateTime2), N'NOTASSIGNED', NULL, NULL, N'NCDG0069', N'10%', 1683, 187, 0, N'Test', CAST(N'0001-01-01T00:00:00.0000000' AS DateTime2), NULL, 1, N'NA', N'NA', N'NA')
INSERT [dbo].[Commission] ([Id], [EmployeeId], [EmployeeType], [CommissionType], [Amount], [IsPaid], [Title], [InvoiceId], [HospitalId], [DateTime], [CreatedTime], [UpdatedTime], [MainInvoiceId], [PaymentGroup], [MainInvoiceCode], [InvoiceCode], [PercentOrValue], [InvoiceTotal], [LessAmount], [SpecialAmount], [Category], [InvoiceCreatedTime], [InvoiceDiagnosticTestId], [IsPaidFinally], [PaymentId], [ReceiptCreatedTime], [BarCodeImageUrl]) VALUES (N'cd95e84c-09b3-4ea1-8eea-7928229cbfd2', N'8d3cf8f9-7ef7-4008-b529-e05a062b3f0c', N'Doctor', N'DoctorVisit', 99900, 0, N'', N'4d9b9c6b-cc25-44fa-96b6-7914579da4bc', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2019-01-12T12:07:51.1546713' AS DateTime2), CAST(N'2019-02-03T08:17:35.7629175' AS DateTime2), N'7dae257e-be11-4a1a-ac50-a24ff4da3c98', N'NCR0114', N'NCINV0046', NULL, NULL, NULL, 0, 0, N'Operation', CAST(N'2019-01-12T09:28:40.6767798' AS DateTime2), NULL, 1, NULL, N'03-02-2019 8:17 AM', N'data:image/jpeg;base64,[encoded data, 8380 characters]')
INSERT [dbo].[Commission] ([Id], [EmployeeId], [EmployeeType], [CommissionType], [Amount], [IsPaid], [Title], [InvoiceId], [HospitalId], [DateTime], [CreatedTime], [UpdatedTime], [MainInvoiceId], [PaymentGroup], [MainInvoiceCode], [InvoiceCode], [PercentOrValue], [InvoiceTotal], [LessAmount], [SpecialAmount], [Category], [InvoiceCreatedTime], [InvoiceDiagnosticTestId], [IsPaidFinally], [PaymentId], [ReceiptCreatedTime], [BarCodeImageUrl]) VALUES (N'ce17b2c0-5ecb-4254-83eb-63d29e5a5bb2', N'6ee087eb-7031-408f-b4ea-f567d250f75b', N'Doctor', N'UltraSoundCategory_1', 64.8, 0, N'', N'bf6974a6-9f9e-4640-bd8f-535bab6e4eab', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2019-01-08T11:19:15.6625906' AS DateTime2), CAST(N'2019-02-03T08:17:35.7629175' AS DateTime2), N'NOTASSIGNED', N'NCR0114', NULL, N'NCDG0093', N'18%', 13139963.79, 1000, 0, N'Test', CAST(N'2019-01-07T16:47:29.0000000' AS DateTime2), NULL, 1, NULL, N'03-02-2019 8:17 AM', N'data:image/jpeg;base64,[encoded data, 8380 characters]')
INSERT [dbo].[Commission] ([Id], [EmployeeId], [EmployeeType], [CommissionType], [Amount], [IsPaid], [Title], [InvoiceId], [HospitalId], [DateTime], [CreatedTime], [UpdatedTime], [MainInvoiceId], [PaymentGroup], [MainInvoiceCode], [InvoiceCode], [PercentOrValue], [InvoiceTotal], [LessAmount], [SpecialAmount], [Category], [InvoiceCreatedTime], [InvoiceDiagnosticTestId], [IsPaidFinally], [PaymentId], [ReceiptCreatedTime], [BarCodeImageUrl]) VALUES (N'ced2ff44-27d0-4452-a48e-5e54b74ba27b', N'f58ff95f-89e6-4f8e-8868-a83828ebe999', N'Doctor', N'Biochemistry ', 50, 1, N'', N'02581d5d-e2a1-45e9-b4c4-36f1102a9f4a', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2018-12-05T12:30:59.4507845' AS DateTime2), CAST(N'2018-12-06T13:19:34.6918070' AS DateTime2), N'NOTASSIGNED', N'NCR0040', NULL, N'NCDG0065', N'10%', 955, 0, 0, N'Test', CAST(N'2018-12-05T12:30:58.5829589' AS DateTime2), NULL, 0, N'NA', N'NA', N'NA')
INSERT [dbo].[Commission] ([Id], [EmployeeId], [EmployeeType], [CommissionType], [Amount], [IsPaid], [Title], [InvoiceId], [HospitalId], [DateTime], [CreatedTime], [UpdatedTime], [MainInvoiceId], [PaymentGroup], [MainInvoiceCode], [InvoiceCode], [PercentOrValue], [InvoiceTotal], [LessAmount], [SpecialAmount], [Category], [InvoiceCreatedTime], [InvoiceDiagnosticTestId], [IsPaidFinally], [PaymentId], [ReceiptCreatedTime], [BarCodeImageUrl]) VALUES (N'cf6152d4-ff75-483d-b345-346821c919be', N'4c772c03-ef45-492a-82d7-24bd49320ea3', N'Referral', N'Biochemistry ', 500, 1, N'', N'11ca0974-d897-47ae-9180-66b70ae11df1', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2018-12-24T13:50:33.6181463' AS DateTime2), CAST(N'2018-12-24T14:13:15.4618121' AS DateTime2), N'NOTASSIGNED', N'NCR0081', NULL, N'NCDG0077', N'10%', 969.3, 107.7, 0, N'Test', CAST(N'2018-12-24T13:50:33.1434282' AS DateTime2), NULL, 1, N'NCP0007', N'NA', N'NA')
INSERT [dbo].[Commission] ([Id], [EmployeeId], [EmployeeType], [CommissionType], [Amount], [IsPaid], [Title], [InvoiceId], [HospitalId], [DateTime], [CreatedTime], [UpdatedTime], [MainInvoiceId], [PaymentGroup], [MainInvoiceCode], [InvoiceCode], [PercentOrValue], [InvoiceTotal], [LessAmount], [SpecialAmount], [Category], [InvoiceCreatedTime], [InvoiceDiagnosticTestId], [IsPaidFinally], [PaymentId], [ReceiptCreatedTime], [BarCodeImageUrl]) VALUES (N'cffadddb-f095-4d7e-b086-20a4845fc6ed', N'1fc95b60-c117-4163-b73d-37bd64d7fac8', N'Doctor', N'Biochemistry ', 75, 0, N'', N'1d7e9ea2-f7ae-418b-a43d-762f94e11b7c', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2019-01-05T15:22:03.4187629' AS DateTime2), CAST(N'2019-02-03T08:17:35.7629175' AS DateTime2), N'NOTASSIGNED', N'NCR0114', NULL, N'NCDG0082', N'10%', 873, 0, 0, N'Test', CAST(N'2019-01-05T15:22:02.7041591' AS DateTime2), NULL, 1, NULL, N'03-02-2019 8:17 AM', N'data:image/jpeg;base64,[encoded data, 8380 characters]')
INSERT [dbo].[Commission] ([Id], [EmployeeId], [EmployeeType], [CommissionType], [Amount], [IsPaid], [Title], [InvoiceId], [HospitalId], [DateTime], [CreatedTime], [UpdatedTime], [MainInvoiceId], [PaymentGroup], [MainInvoiceCode], [InvoiceCode], [PercentOrValue], [InvoiceTotal], [LessAmount], [SpecialAmount], [Category], [InvoiceCreatedTime], [InvoiceDiagnosticTestId], [IsPaidFinally], [PaymentId], [ReceiptCreatedTime], [BarCodeImageUrl]) VALUES (N'd00558e2-1239-476b-a61e-57aa853a6046', N'6ee087eb-7031-408f-b4ea-f567d250f75b', N'Doctor', N'CLINIC_REFERRAL', 330, 0, N'ClinicInvoice', N'4a28ee30-d035-43c8-9603-5b17fff3e26e', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2019-01-14T12:56:31.6306734' AS DateTime2), CAST(N'2019-02-03T08:17:35.7629175' AS DateTime2), N'ee0b1f7f-b2bc-46e2-abf6-e16c6d791ec1', N'NCR0114', N'NCINV0047', N'NOTASSIGNED', N'330', NULL, 0, 0, N'OPERATION', CAST(N'2019-01-14T10:42:01.7797406' AS DateTime2), NULL, 1, NULL, N'03-02-2019 8:17 AM', N'data:image/jpeg;base64,[encoded data, 8380 characters]')
INSERT [dbo].[Commission] ([Id], [EmployeeId], [EmployeeType], [CommissionType], [Amount], [IsPaid], [Title], [InvoiceId], [HospitalId], [DateTime], [CreatedTime], [UpdatedTime], [MainInvoiceId], [PaymentGroup], [MainInvoiceCode], [InvoiceCode], [PercentOrValue], [InvoiceTotal], [LessAmount], [SpecialAmount], [Category], [InvoiceCreatedTime], [InvoiceDiagnosticTestId], [IsPaidFinally], [PaymentId], [ReceiptCreatedTime], [BarCodeImageUrl]) VALUES (N'd02d4f3c-1915-471b-8eb3-c7e44489f8d5', N'aa1bef3d-ea7c-404a-9d19-2347fcd8fad9', N'Doctor', N'Pathology', -102.32558139534883, 1, N'', N'7a054570-a86b-44e4-b924-ce2c3d1cd64e', N'd821cd9f-ac10-4f94-92cf-c292cd83b2c0', NULL, CAST(N'2018-07-16T17:41:26.7433333' AS DateTime2), CAST(N'2018-09-04T22:35:23.4266667' AS DateTime2), N'f2724c66-005f-4357-b7a5-3ab67b54cea0', N'RR0041', N'RINV0015', N'RDG0032', N'0%', 1600, 550, 0, N'Test', CAST(N'2018-07-16T17:21:37.3566667' AS DateTime2), NULL, 0, N'NA', N'NA', N'NA')
INSERT [dbo].[Commission] ([Id], [EmployeeId], [EmployeeType], [CommissionType], [Amount], [IsPaid], [Title], [InvoiceId], [HospitalId], [DateTime], [CreatedTime], [UpdatedTime], [MainInvoiceId], [PaymentGroup], [MainInvoiceCode], [InvoiceCode], [PercentOrValue], [InvoiceTotal], [LessAmount], [SpecialAmount], [Category], [InvoiceCreatedTime], [InvoiceDiagnosticTestId], [IsPaidFinally], [PaymentId], [ReceiptCreatedTime], [BarCodeImageUrl]) VALUES (N'd0df06da-4cf7-4596-be38-78c5ff2b550f', N'2f49ff36-b04f-4081-9261-60ec973da26d', N'UltraSoundDoctor', N'UltraSoundCategory_1', 0, 0, N'', N'bf6974a6-9f9e-4640-bd8f-535bab6e4eab', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2019-01-08T11:19:12.8653815' AS DateTime2), CAST(N'2019-02-03T08:17:35.7629175' AS DateTime2), N'NOTASSIGNED', N'NCR0114', N'NOTASSIGNED', N'NCDG0093', NULL, 307013, 10000, 0, N'Test', CAST(N'2019-01-07T16:47:29.9695552' AS DateTime2), N'ee26a254-4990-4c21-bad6-787045e311be', 1, NULL, N'03-02-2019 8:17 AM', N'data:image/jpeg;base64,[encoded data, 8380 characters]')
INSERT [dbo].[Commission] ([Id], [EmployeeId], [EmployeeType], [CommissionType], [Amount], [IsPaid], [Title], [InvoiceId], [HospitalId], [DateTime], [CreatedTime], [UpdatedTime], [MainInvoiceId], [PaymentGroup], [MainInvoiceCode], [InvoiceCode], [PercentOrValue], [InvoiceTotal], [LessAmount], [SpecialAmount], [Category], [InvoiceCreatedTime], [InvoiceDiagnosticTestId], [IsPaidFinally], [PaymentId], [ReceiptCreatedTime], [BarCodeImageUrl]) VALUES (N'd12b659c-0f48-402b-a58c-c1a9afcdac61', N'aa1bef3d-ea7c-404a-9d19-2347fcd8fad9', N'Doctor', N'X-Ray ', -102.32558139534883, 1, N'', N'7a054570-a86b-44e4-b924-ce2c3d1cd64e', N'd821cd9f-ac10-4f94-92cf-c292cd83b2c0', NULL, CAST(N'2018-07-16T17:41:26.7266667' AS DateTime2), CAST(N'2018-09-04T22:35:23.4266667' AS DateTime2), N'f2724c66-005f-4357-b7a5-3ab67b54cea0', N'RR0041', N'RINV0015', N'RDG0032', N'0%', 1600, 550, 0, N'Test', CAST(N'2018-07-16T17:21:37.3566667' AS DateTime2), NULL, 0, N'NA', N'NA', N'NA')
INSERT [dbo].[Commission] ([Id], [EmployeeId], [EmployeeType], [CommissionType], [Amount], [IsPaid], [Title], [InvoiceId], [HospitalId], [DateTime], [CreatedTime], [UpdatedTime], [MainInvoiceId], [PaymentGroup], [MainInvoiceCode], [InvoiceCode], [PercentOrValue], [InvoiceTotal], [LessAmount], [SpecialAmount], [Category], [InvoiceCreatedTime], [InvoiceDiagnosticTestId], [IsPaidFinally], [PaymentId], [ReceiptCreatedTime], [BarCodeImageUrl]) VALUES (N'd28c9d3f-afa3-48e0-aa2e-43ecbc877eec', N'24a50fd4-8d08-41d3-94e5-be95c9e77925', N'Doctor', N'Pathology (Normal)', -20.512820512820511, 1, N'', N'c58a7b22-0d04-4786-8350-d805dddce26d', N'd821cd9f-ac10-4f94-92cf-c292cd83b2c0', NULL, CAST(N'2018-07-09T21:55:24.3800000' AS DateTime2), CAST(N'2018-09-04T22:35:23.4300000' AS DateTime2), N'86369ff8-4d85-4b08-8b42-7ba206964d7a', N'RR0004', N'RINV0006', N'RDG0018', N'0%', 1750, 200, 0, N'Test', CAST(N'2018-07-09T21:50:19.0200000' AS DateTime2), NULL, 0, N'NA', N'NA', N'NA')
INSERT [dbo].[Commission] ([Id], [EmployeeId], [EmployeeType], [CommissionType], [Amount], [IsPaid], [Title], [InvoiceId], [HospitalId], [DateTime], [CreatedTime], [UpdatedTime], [MainInvoiceId], [PaymentGroup], [MainInvoiceCode], [InvoiceCode], [PercentOrValue], [InvoiceTotal], [LessAmount], [SpecialAmount], [Category], [InvoiceCreatedTime], [InvoiceDiagnosticTestId], [IsPaidFinally], [PaymentId], [ReceiptCreatedTime], [BarCodeImageUrl]) VALUES (N'd32f410e-ccf3-4ca5-bb27-6d9f072b9245', N'4c772c03-ef45-492a-82d7-24bd49320ea3', N'Doctor', N'ANESTHESIA_DOCTOR', 8900, 0, N'KidneyOP_1', N'67650f2a-cd2d-49fd-bc7e-5eefce820158', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2018-12-20T15:20:15.7690134' AS DateTime2), CAST(N'2018-12-22T16:17:56.9948653' AS DateTime2), N'e442f9c5-c767-48c4-a0e9-983012f4bb00', NULL, N'NCINV0039', N'NCINV0039', N'8900', NULL, 0, 0, N'Operation', CAST(N'2018-12-20T15:11:56.1774447' AS DateTime2), NULL, 1, N'NA', N'NA', N'NA')
INSERT [dbo].[Commission] ([Id], [EmployeeId], [EmployeeType], [CommissionType], [Amount], [IsPaid], [Title], [InvoiceId], [HospitalId], [DateTime], [CreatedTime], [UpdatedTime], [MainInvoiceId], [PaymentGroup], [MainInvoiceCode], [InvoiceCode], [PercentOrValue], [InvoiceTotal], [LessAmount], [SpecialAmount], [Category], [InvoiceCreatedTime], [InvoiceDiagnosticTestId], [IsPaidFinally], [PaymentId], [ReceiptCreatedTime], [BarCodeImageUrl]) VALUES (N'd3b34953-bcbb-4b16-960d-afe4b7001381', N'45c6d504-e6fb-4da1-9454-92195a3dba94', N'Doctor', N'Pathology', 0, 1, N'', N'06a3ddcf-f02a-4fff-b171-13b42c093c81', N'd821cd9f-ac10-4f94-92cf-c292cd83b2c0', NULL, CAST(N'2018-07-20T12:24:41.3366667' AS DateTime2), CAST(N'2018-09-04T22:35:23.4300000' AS DateTime2), N'6c056c80-8225-4edb-a07a-69ca4db0296a', N'RR0040', N'RINV0026', N'RDG0044', N'0%', 800, 0, 0, N'Test', CAST(N'2018-07-20T12:22:06.6800000' AS DateTime2), NULL, 0, N'NA', N'NA', N'NA')
INSERT [dbo].[Commission] ([Id], [EmployeeId], [EmployeeType], [CommissionType], [Amount], [IsPaid], [Title], [InvoiceId], [HospitalId], [DateTime], [CreatedTime], [UpdatedTime], [MainInvoiceId], [PaymentGroup], [MainInvoiceCode], [InvoiceCode], [PercentOrValue], [InvoiceTotal], [LessAmount], [SpecialAmount], [Category], [InvoiceCreatedTime], [InvoiceDiagnosticTestId], [IsPaidFinally], [PaymentId], [ReceiptCreatedTime], [BarCodeImageUrl]) VALUES (N'd40100cc-54e8-4d0f-9a7c-410a3e50cecd', N'2f49ff36-b04f-4081-9261-60ec973da26d', N'Referral', N'Biochemistry ', 100, 0, N'', N'86636fc7-fea3-4e6c-ad30-5f4bea4f8417', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2018-11-24T13:30:55.9313425' AS DateTime2), CAST(N'2018-12-22T16:17:56.9948653' AS DateTime2), N'NOTASSIGNED', NULL, NULL, N'NCDG0053', N'10%', 1356.05, 199.95, 0, N'Test', CAST(N'2018-11-24T13:30:55.6012090' AS DateTime2), NULL, 1, N'NA', N'NA', N'NA')
INSERT [dbo].[Commission] ([Id], [EmployeeId], [EmployeeType], [CommissionType], [Amount], [IsPaid], [Title], [InvoiceId], [HospitalId], [DateTime], [CreatedTime], [UpdatedTime], [MainInvoiceId], [PaymentGroup], [MainInvoiceCode], [InvoiceCode], [PercentOrValue], [InvoiceTotal], [LessAmount], [SpecialAmount], [Category], [InvoiceCreatedTime], [InvoiceDiagnosticTestId], [IsPaidFinally], [PaymentId], [ReceiptCreatedTime], [BarCodeImageUrl]) VALUES (N'd4e549f6-b0c6-444b-9a26-1cf01467ea06', N'f58ff95f-89e6-4f8e-8868-a83828ebe999', N'Doctor', N'UltraSoundCategory_1', 56, 1, N'', N'e456eaf1-93e2-43db-9cd1-8a09a2a66374', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2018-12-03T16:34:17.6252684' AS DateTime2), CAST(N'2018-12-04T10:52:50.5371787' AS DateTime2), N'NOTASSIGNED', N'NCR0026', NULL, N'NCDG0064', N'20%', 1004, 0, 0, N'Test', CAST(N'2018-12-03T16:34:17.4923501' AS DateTime2), NULL, 0, N'NA', N'NA', N'NA')
INSERT [dbo].[Commission] ([Id], [EmployeeId], [EmployeeType], [CommissionType], [Amount], [IsPaid], [Title], [InvoiceId], [HospitalId], [DateTime], [CreatedTime], [UpdatedTime], [MainInvoiceId], [PaymentGroup], [MainInvoiceCode], [InvoiceCode], [PercentOrValue], [InvoiceTotal], [LessAmount], [SpecialAmount], [Category], [InvoiceCreatedTime], [InvoiceDiagnosticTestId], [IsPaidFinally], [PaymentId], [ReceiptCreatedTime], [BarCodeImageUrl]) VALUES (N'd51829c9-ae1b-4e2f-9dc9-971c83028497', N'cbfa4e4e-2fdf-48c7-9b94-e4712cf1f267', N'Referral', N'X-Ray ', -450, 1, N'', N'0a3797d0-4678-4d57-a1e7-0a1fbfd2403f', N'd821cd9f-ac10-4f94-92cf-c292cd83b2c0', NULL, CAST(N'2018-09-04T12:36:33.0866667' AS DateTime2), CAST(N'2018-09-04T22:35:23.4300000' AS DateTime2), N'bb6797bb-6fd2-464b-8880-539b58f95590', N'RR0051', N'RINV0175', N'RDG0191', N'0%', 0, 2050, 0, N'Test', CAST(N'2018-09-01T10:15:48.6966667' AS DateTime2), NULL, 0, N'NA', N'NA', N'NA')
INSERT [dbo].[Commission] ([Id], [EmployeeId], [EmployeeType], [CommissionType], [Amount], [IsPaid], [Title], [InvoiceId], [HospitalId], [DateTime], [CreatedTime], [UpdatedTime], [MainInvoiceId], [PaymentGroup], [MainInvoiceCode], [InvoiceCode], [PercentOrValue], [InvoiceTotal], [LessAmount], [SpecialAmount], [Category], [InvoiceCreatedTime], [InvoiceDiagnosticTestId], [IsPaidFinally], [PaymentId], [ReceiptCreatedTime], [BarCodeImageUrl]) VALUES (N'd5996ca4-98f6-4297-b45f-7044c8d0aba0', N'82b04905-0844-420a-9734-ef6ef52771f2', N'Doctor', N'Biochemistry', 140, 1, N'', N'abc57b45-50ab-4fe6-bdf2-ddbf1c3fbeee', N'd821cd9f-ac10-4f94-92cf-c292cd83b2c0', NULL, CAST(N'2018-08-01T20:49:52.3166667' AS DateTime2), CAST(N'2018-09-04T22:35:23.4300000' AS DateTime2), N'8c2d43c9-ad67-42a8-8527-2fc86d1cd454', N'RR0006', N'RINV0078', N'RDG0093', N'40%', 1500, 300, 0, N'Test', CAST(N'2018-08-01T10:33:28.2000000' AS DateTime2), NULL, 0, N'NA', N'NA', N'NA')
INSERT [dbo].[Commission] ([Id], [EmployeeId], [EmployeeType], [CommissionType], [Amount], [IsPaid], [Title], [InvoiceId], [HospitalId], [DateTime], [CreatedTime], [UpdatedTime], [MainInvoiceId], [PaymentGroup], [MainInvoiceCode], [InvoiceCode], [PercentOrValue], [InvoiceTotal], [LessAmount], [SpecialAmount], [Category], [InvoiceCreatedTime], [InvoiceDiagnosticTestId], [IsPaidFinally], [PaymentId], [ReceiptCreatedTime], [BarCodeImageUrl]) VALUES (N'd6c19b4b-3a29-42c3-a7f3-7e8e5a425a8a', N'6ee087eb-7031-408f-b4ea-f567d250f75b', N'Doctor', N'ASSISTANT_DOCTOR', 222, 1, N'KidneyOP_1', N'35309d68-3241-45dd-abff-5a49a3367c91', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2019-01-31T10:57:08.8855753' AS DateTime2), CAST(N'2019-02-02T16:33:26.3179380' AS DateTime2), N'c535df32-81aa-4031-919a-9b288bf847d0', N'NCR0109', N'NCINV0058', N'NCINV0058', N'222', NULL, 0, 0, N'Operation', CAST(N'2019-01-31T10:57:08.6286581' AS DateTime2), NULL, 1, N'NCP0052', N'31-01-2019 10:58 AM', N'data:image/jpeg;base64,[encoded data, 8436 characters]')
INSERT [dbo].[Commission] ([Id], [EmployeeId], [EmployeeType], [CommissionType], [Amount], [IsPaid], [Title], [InvoiceId], [HospitalId], [DateTime], [CreatedTime], [UpdatedTime], [MainInvoiceId], [PaymentGroup], [MainInvoiceCode], [InvoiceCode], [PercentOrValue], [InvoiceTotal], [LessAmount], [SpecialAmount], [Category], [InvoiceCreatedTime], [InvoiceDiagnosticTestId], [IsPaidFinally], [PaymentId], [ReceiptCreatedTime], [BarCodeImageUrl]) VALUES (N'd6dbacdf-1409-42f4-8da8-66d2290242bc', N'4c772c03-ef45-492a-82d7-24bd49320ea3', N'Referral', N'CombineCategory_1', 12.3, 1, N'', N'842671da-0061-4672-b0ca-22660eee3ef5', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2018-12-24T13:34:09.6341787' AS DateTime2), CAST(N'2018-12-24T13:36:33.7760122' AS DateTime2), N'NOTASSIGNED', NULL, NULL, N'NCDG0076', N'10%', 1100.7, 122.3, 0, N'Test', CAST(N'2018-12-24T13:34:09.3753377' AS DateTime2), NULL, 0, N'NCP0005', N'NA', N'NA')
INSERT [dbo].[Commission] ([Id], [EmployeeId], [EmployeeType], [CommissionType], [Amount], [IsPaid], [Title], [InvoiceId], [HospitalId], [DateTime], [CreatedTime], [UpdatedTime], [MainInvoiceId], [PaymentGroup], [MainInvoiceCode], [InvoiceCode], [PercentOrValue], [InvoiceTotal], [LessAmount], [SpecialAmount], [Category], [InvoiceCreatedTime], [InvoiceDiagnosticTestId], [IsPaidFinally], [PaymentId], [ReceiptCreatedTime], [BarCodeImageUrl]) VALUES (N'd70222c8-fbbc-493d-b359-ac2707290c47', N'f58ff95f-89e6-4f8e-8868-a83828ebe999', N'UltraSoundDoctor', N'UltraSoundCategory_1', 500, 1, N'', N'003042e8-1731-43ad-a3cd-906998b3e07d', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2018-12-05T16:07:50.2708491' AS DateTime2), CAST(N'2018-12-06T10:03:41.6293930' AS DateTime2), N'NOTASSIGNED', N'NCR0030', N'NOTASSIGNED', N'NCDG0066', NULL, 512, 51.2, 0, N'test', CAST(N'2018-12-05T16:07:49.8740832' AS DateTime2), N'8d176567-3e5d-480d-bf2b-d088801ac136', 0, N'NA', N'NA', N'NA')
INSERT [dbo].[Commission] ([Id], [EmployeeId], [EmployeeType], [CommissionType], [Amount], [IsPaid], [Title], [InvoiceId], [HospitalId], [DateTime], [CreatedTime], [UpdatedTime], [MainInvoiceId], [PaymentGroup], [MainInvoiceCode], [InvoiceCode], [PercentOrValue], [InvoiceTotal], [LessAmount], [SpecialAmount], [Category], [InvoiceCreatedTime], [InvoiceDiagnosticTestId], [IsPaidFinally], [PaymentId], [ReceiptCreatedTime], [BarCodeImageUrl]) VALUES (N'd70636a7-6915-4bdd-b202-547c76b5d52e', N'2f49ff36-b04f-4081-9261-60ec973da26d', N'UltraSoundDoctor', N'UltraSoundCategory_1', 0, 0, N'', N'3e34586b-5b04-4755-ae22-5694878a495e', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2019-01-21T15:49:34.6418440' AS DateTime2), CAST(N'2019-02-03T08:17:35.7629175' AS DateTime2), N'NOTASSIGNED', N'NCR0114', N'NOTASSIGNED', N'NCDG0107', NULL, 22280, 0, 0, N'Test', CAST(N'2019-01-21T15:49:31.1487126' AS DateTime2), N'0688c1a0-4f32-490f-8b2f-d87531053e6a', 1, NULL, N'03-02-2019 8:17 AM', N'data:image/jpeg;base64,[encoded data, 8380 characters]')
INSERT [dbo].[Commission] ([Id], [EmployeeId], [EmployeeType], [CommissionType], [Amount], [IsPaid], [Title], [InvoiceId], [HospitalId], [DateTime], [CreatedTime], [UpdatedTime], [MainInvoiceId], [PaymentGroup], [MainInvoiceCode], [InvoiceCode], [PercentOrValue], [InvoiceTotal], [LessAmount], [SpecialAmount], [Category], [InvoiceCreatedTime], [InvoiceDiagnosticTestId], [IsPaidFinally], [PaymentId], [ReceiptCreatedTime], [BarCodeImageUrl]) VALUES (N'd714ac82-2aba-4b8b-8e20-c6c5725408b0', N'2f49ff36-b04f-4081-9261-60ec973da26d', N'Referral', N'Biochemistry ', 50, 1, N'', N'd999eed0-af1a-4904-8e5e-2d6f053afd89', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2018-12-11T09:37:21.7160337' AS DateTime2), CAST(N'2018-12-23T10:33:57.9977525' AS DateTime2), N'6d5275c3-14d6-402f-a25a-be761fa0a549', N'NCR0072', N'NCINV0032', N'NCDG0070', N'10%', 500, 0, 0, N'Test', CAST(N'2018-12-11T09:37:21.2382312' AS DateTime2), NULL, 1, N'NA', N'NA', N'NA')
INSERT [dbo].[Commission] ([Id], [EmployeeId], [EmployeeType], [CommissionType], [Amount], [IsPaid], [Title], [InvoiceId], [HospitalId], [DateTime], [CreatedTime], [UpdatedTime], [MainInvoiceId], [PaymentGroup], [MainInvoiceCode], [InvoiceCode], [PercentOrValue], [InvoiceTotal], [LessAmount], [SpecialAmount], [Category], [InvoiceCreatedTime], [InvoiceDiagnosticTestId], [IsPaidFinally], [PaymentId], [ReceiptCreatedTime], [BarCodeImageUrl]) VALUES (N'd75a87f3-e07e-43e2-a432-8e9acb8acf63', N'65ba8697-497a-4f36-bd6c-668eba0c5d62', N'Doctor', N'Assistance', 33, 0, N'KidneyOP_1', N'a5c8f1df-75e3-41e6-b77f-76aec925404e', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2018-12-13T16:01:55.2680879' AS DateTime2), CAST(N'2018-12-22T16:17:56.9948653' AS DateTime2), N'3185ec7e-59f6-4fdc-b1ff-b0d47865fd59', NULL, N'NCINV0034', N'NCINV0034', N'33', NULL, 0, 0, N'Operation', CAST(N'2018-12-13T15:36:00.3756381' AS DateTime2), NULL, 1, N'NA', N'NA', N'NA')
INSERT [dbo].[Commission] ([Id], [EmployeeId], [EmployeeType], [CommissionType], [Amount], [IsPaid], [Title], [InvoiceId], [HospitalId], [DateTime], [CreatedTime], [UpdatedTime], [MainInvoiceId], [PaymentGroup], [MainInvoiceCode], [InvoiceCode], [PercentOrValue], [InvoiceTotal], [LessAmount], [SpecialAmount], [Category], [InvoiceCreatedTime], [InvoiceDiagnosticTestId], [IsPaidFinally], [PaymentId], [ReceiptCreatedTime], [BarCodeImageUrl]) VALUES (N'd7c501c8-2649-418c-8c47-ad5067ed1b17', N'410f20e6-ad68-450b-9cf3-55da4793042c', N'Doctor', N'ASSISTANT_DOCTOR', 22, 0, N'KidneyOP_1', N'503de2f0-2c09-4be7-8f57-8b7c28560eff', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2019-01-17T13:27:38.7457073' AS DateTime2), CAST(N'2019-02-03T08:17:35.7629175' AS DateTime2), N'409081dc-7ea0-4c1a-9ac9-e50472e9bb1f', N'NCR0114', N'NCINV0051', N'NCINV0051', N'22', NULL, 0, 0, N'Operation', CAST(N'2019-01-17T13:27:38.5977670' AS DateTime2), NULL, 1, NULL, N'03-02-2019 8:17 AM', N'data:image/jpeg;base64,[encoded data, 8380 characters]')
INSERT [dbo].[Commission] ([Id], [EmployeeId], [EmployeeType], [CommissionType], [Amount], [IsPaid], [Title], [InvoiceId], [HospitalId], [DateTime], [CreatedTime], [UpdatedTime], [MainInvoiceId], [PaymentGroup], [MainInvoiceCode], [InvoiceCode], [PercentOrValue], [InvoiceTotal], [LessAmount], [SpecialAmount], [Category], [InvoiceCreatedTime], [InvoiceDiagnosticTestId], [IsPaidFinally], [PaymentId], [ReceiptCreatedTime], [BarCodeImageUrl]) VALUES (N'd80b037a-726f-4d80-9254-1d73704266b4', N'82b04905-0844-420a-9734-ef6ef52771f2', N'Doctor', N'Ultrasound', 40, 1, N'', N'1f2197fc-5fe9-4325-899d-994c9fd6ea75', N'd821cd9f-ac10-4f94-92cf-c292cd83b2c0', NULL, CAST(N'2018-08-03T15:09:09.7366667' AS DateTime2), CAST(N'2018-09-04T22:35:23.4300000' AS DateTime2), N'dc1a2ce0-6318-4422-9ecc-8889dc8d00c4', N'RR0045', N'RINV0084', N'RDG0101', N'40', 1200, 50, 0, N'Test', CAST(N'2018-08-03T11:43:50.0966667' AS DateTime2), NULL, 0, N'NA', N'NA', N'NA')
INSERT [dbo].[Commission] ([Id], [EmployeeId], [EmployeeType], [CommissionType], [Amount], [IsPaid], [Title], [InvoiceId], [HospitalId], [DateTime], [CreatedTime], [UpdatedTime], [MainInvoiceId], [PaymentGroup], [MainInvoiceCode], [InvoiceCode], [PercentOrValue], [InvoiceTotal], [LessAmount], [SpecialAmount], [Category], [InvoiceCreatedTime], [InvoiceDiagnosticTestId], [IsPaidFinally], [PaymentId], [ReceiptCreatedTime], [BarCodeImageUrl]) VALUES (N'd87964e8-90f6-48f0-8df9-ea33dbb24c6a', N'f58ff95f-89e6-4f8e-8868-a83828ebe999', N'Referral', N'CT_2', 4.4, 0, N'', N'209481c5-8894-40e0-9811-794b49bb6446', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2018-11-28T08:59:15.3395208' AS DateTime2), CAST(N'2018-12-22T16:17:56.9948653' AS DateTime2), N'NOTASSIGNED', NULL, NULL, N'NCDG0060', N'10%', 7374.6, 819.4, 0, N'Test', CAST(N'2018-11-28T08:59:14.2156449' AS DateTime2), NULL, 1, N'NA', N'NA', N'NA')
INSERT [dbo].[Commission] ([Id], [EmployeeId], [EmployeeType], [CommissionType], [Amount], [IsPaid], [Title], [InvoiceId], [HospitalId], [DateTime], [CreatedTime], [UpdatedTime], [MainInvoiceId], [PaymentGroup], [MainInvoiceCode], [InvoiceCode], [PercentOrValue], [InvoiceTotal], [LessAmount], [SpecialAmount], [Category], [InvoiceCreatedTime], [InvoiceDiagnosticTestId], [IsPaidFinally], [PaymentId], [ReceiptCreatedTime], [BarCodeImageUrl]) VALUES (N'd8d204b2-59e9-4fe6-96bd-d8d229406b22', N'4c772c03-ef45-492a-82d7-24bd49320ea3', N'Doctor', N'Serology ', 0, 0, N'', N'8be24963-914e-473d-b269-d80182e42daf', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2018-11-25T08:59:06.4224617' AS DateTime2), CAST(N'2018-12-22T16:17:56.9948653' AS DateTime2), N'NOTASSIGNED', NULL, NULL, N'NCDG0054', N'0%', 4699.8, 522.2, 0, N'Test', CAST(N'2018-11-25T08:59:05.7217518' AS DateTime2), NULL, 1, N'NA', N'NA', N'NA')
INSERT [dbo].[Commission] ([Id], [EmployeeId], [EmployeeType], [CommissionType], [Amount], [IsPaid], [Title], [InvoiceId], [HospitalId], [DateTime], [CreatedTime], [UpdatedTime], [MainInvoiceId], [PaymentGroup], [MainInvoiceCode], [InvoiceCode], [PercentOrValue], [InvoiceTotal], [LessAmount], [SpecialAmount], [Category], [InvoiceCreatedTime], [InvoiceDiagnosticTestId], [IsPaidFinally], [PaymentId], [ReceiptCreatedTime], [BarCodeImageUrl]) VALUES (N'd9020542-60c3-45e1-a334-3a063afc4b73', N'2f49ff36-b04f-4081-9261-60ec973da26d', N'Doctor', N'UltraSoundCategory_1', 6.8, 1, N'', N'01742239-632f-4455-8f21-a6e5fde60fd1', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2019-01-17T10:22:39.9151784' AS DateTime2), CAST(N'2019-01-19T13:54:33.3800088' AS DateTime2), N'NOTASSIGNED', N'NCR0106', NULL, N'NCDG0104', N'20%', 1457, 0, 0, N'Test', CAST(N'2019-01-17T09:32:56.0000000' AS DateTime2), NULL, 1, N'NCP0048', N'19-01-2019 1:54 PM', N'data:image/jpeg;base64,[encoded data, 8452 characters]')
INSERT [dbo].[Commission] ([Id], [EmployeeId], [EmployeeType], [CommissionType], [Amount], [IsPaid], [Title], [InvoiceId], [HospitalId], [DateTime], [CreatedTime], [UpdatedTime], [MainInvoiceId], [PaymentGroup], [MainInvoiceCode], [InvoiceCode], [PercentOrValue], [InvoiceTotal], [LessAmount], [SpecialAmount], [Category], [InvoiceCreatedTime], [InvoiceDiagnosticTestId], [IsPaidFinally], [PaymentId], [ReceiptCreatedTime], [BarCodeImageUrl]) VALUES (N'd9212bc6-421d-4622-91a7-ec03d6ecc185', N'f58ff95f-89e6-4f8e-8868-a83828ebe999', N'Doctor', N'Conbination', 200, 1, N'', N'842671da-0061-4672-b0ca-22660eee3ef5', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2018-12-24T13:34:09.6241848' AS DateTime2), CAST(N'2018-12-24T14:11:26.5307031' AS DateTime2), N'NOTASSIGNED', N'NCR0079', NULL, N'NCDG0076', N'10%', 1100.7, 122.3, 0, N'Test', CAST(N'2018-12-24T13:34:09.3753377' AS DateTime2), NULL, 1, N'NCP0004', N'NA', N'NA')
INSERT [dbo].[Commission] ([Id], [EmployeeId], [EmployeeType], [CommissionType], [Amount], [IsPaid], [Title], [InvoiceId], [HospitalId], [DateTime], [CreatedTime], [UpdatedTime], [MainInvoiceId], [PaymentGroup], [MainInvoiceCode], [InvoiceCode], [PercentOrValue], [InvoiceTotal], [LessAmount], [SpecialAmount], [Category], [InvoiceCreatedTime], [InvoiceDiagnosticTestId], [IsPaidFinally], [PaymentId], [ReceiptCreatedTime], [BarCodeImageUrl]) VALUES (N'd9863917-d608-4e25-9b06-5ef7645284a3', N'4c772c03-ef45-492a-82d7-24bd49320ea3', N'Doctor', N'CT_2', 23.3, 0, N'', N'cdc3b1aa-6295-40f8-a64a-22c9e2ac20f6', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2019-01-07T13:03:42.2009705' AS DateTime2), CAST(N'2019-02-03T08:17:35.7629175' AS DateTime2), N'NOTASSIGNED', N'NCR0114', NULL, N'NCDG0088', N'10%', 609, 0, 0, N'Test', CAST(N'2019-01-07T13:03:41.3549972' AS DateTime2), NULL, 1, NULL, N'03-02-2019 8:17 AM', N'data:image/jpeg;base64,[encoded data, 8380 characters]')
INSERT [dbo].[Commission] ([Id], [EmployeeId], [EmployeeType], [CommissionType], [Amount], [IsPaid], [Title], [InvoiceId], [HospitalId], [DateTime], [CreatedTime], [UpdatedTime], [MainInvoiceId], [PaymentGroup], [MainInvoiceCode], [InvoiceCode], [PercentOrValue], [InvoiceTotal], [LessAmount], [SpecialAmount], [Category], [InvoiceCreatedTime], [InvoiceDiagnosticTestId], [IsPaidFinally], [PaymentId], [ReceiptCreatedTime], [BarCodeImageUrl]) VALUES (N'd989ca10-e674-4a86-802c-457745aac56b', N'4c772c03-ef45-492a-82d7-24bd49320ea3', N'Doctor', N'SPECIAL_SURGEON', 330, 1, N'KidneyOP_1', N'503de2f0-2c09-4be7-8f57-8b7c28560eff', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2019-01-17T13:27:38.7530402' AS DateTime2), CAST(N'2019-02-02T16:34:47.7664132' AS DateTime2), N'409081dc-7ea0-4c1a-9ac9-e50472e9bb1f', NULL, N'NCINV0051', N'NCINV0051', N'2330', NULL, 0, 0, N'Operation', CAST(N'2019-01-17T13:27:38.5977670' AS DateTime2), NULL, 0, N'NCP0059', NULL, NULL)
INSERT [dbo].[Commission] ([Id], [EmployeeId], [EmployeeType], [CommissionType], [Amount], [IsPaid], [Title], [InvoiceId], [HospitalId], [DateTime], [CreatedTime], [UpdatedTime], [MainInvoiceId], [PaymentGroup], [MainInvoiceCode], [InvoiceCode], [PercentOrValue], [InvoiceTotal], [LessAmount], [SpecialAmount], [Category], [InvoiceCreatedTime], [InvoiceDiagnosticTestId], [IsPaidFinally], [PaymentId], [ReceiptCreatedTime], [BarCodeImageUrl]) VALUES (N'db1889bd-2667-462e-8c49-2fc780a74fd0', N'2f49ff36-b04f-4081-9261-60ec973da26d', N'Doctor', N'DoctorVisit', 12100, 1, N'', N'b6bb9d0f-f127-42f2-ae28-de930d9ba7b4', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2018-12-20T13:32:38.5784897' AS DateTime2), CAST(N'2018-12-20T13:44:57.0458831' AS DateTime2), N'9c0c25c5-11fc-4a52-a928-6cfebda17d20', N'NCR0062', N'NCINV0038', N'NCINV0038', NULL, NULL, 0, 0, N'Operation', CAST(N'0001-01-01T00:00:00.0000000' AS DateTime2), NULL, 0, N'NA', N'NA', N'NA')
INSERT [dbo].[Commission] ([Id], [EmployeeId], [EmployeeType], [CommissionType], [Amount], [IsPaid], [Title], [InvoiceId], [HospitalId], [DateTime], [CreatedTime], [UpdatedTime], [MainInvoiceId], [PaymentGroup], [MainInvoiceCode], [InvoiceCode], [PercentOrValue], [InvoiceTotal], [LessAmount], [SpecialAmount], [Category], [InvoiceCreatedTime], [InvoiceDiagnosticTestId], [IsPaidFinally], [PaymentId], [ReceiptCreatedTime], [BarCodeImageUrl]) VALUES (N'dbc5bbaf-34fb-4b5f-8db4-de633c7196cf', N'410f20e6-ad68-450b-9cf3-55da4793042c', N'Doctor', N'DoctorVisit', 2200, 0, N'', N'603b1385-43d9-4a71-abb9-2c4ec452acce', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2018-12-18T10:32:51.0200884' AS DateTime2), CAST(N'2018-12-22T16:17:56.9948653' AS DateTime2), N'83281dd4-5998-4b90-bd4f-ad30ae28cfa6', NULL, N'NCINV0036', N'NCINV0036', NULL, NULL, 0, 0, N'Operation', CAST(N'0001-01-01T00:00:00.0000000' AS DateTime2), NULL, 1, N'NA', N'NA', N'NA')
INSERT [dbo].[Commission] ([Id], [EmployeeId], [EmployeeType], [CommissionType], [Amount], [IsPaid], [Title], [InvoiceId], [HospitalId], [DateTime], [CreatedTime], [UpdatedTime], [MainInvoiceId], [PaymentGroup], [MainInvoiceCode], [InvoiceCode], [PercentOrValue], [InvoiceTotal], [LessAmount], [SpecialAmount], [Category], [InvoiceCreatedTime], [InvoiceDiagnosticTestId], [IsPaidFinally], [PaymentId], [ReceiptCreatedTime], [BarCodeImageUrl]) VALUES (N'dbf871a8-10df-43cc-b2e2-5ee0b0836a5a', N'2f49ff36-b04f-4081-9261-60ec973da26d', N'Doctor', N'SPECIAL_SURGEON', 120, 0, N'KidneyOP_1', N'4b1a982e-042e-4c33-8058-6b23570c0f85', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2018-12-25T16:30:29.0102562' AS DateTime2), CAST(N'2019-02-03T08:17:35.7629175' AS DateTime2), N'2dea13d0-bea8-41c9-8442-93148a2818c1', N'NCR0114', N'NCINV0040', N'NCINV0040', N'120', NULL, 0, 0, N'Operation', CAST(N'2018-12-25T16:30:07.3822871' AS DateTime2), NULL, 1, NULL, N'03-02-2019 8:17 AM', N'data:image/jpeg;base64,[encoded data, 8380 characters]')
INSERT [dbo].[Commission] ([Id], [EmployeeId], [EmployeeType], [CommissionType], [Amount], [IsPaid], [Title], [InvoiceId], [HospitalId], [DateTime], [CreatedTime], [UpdatedTime], [MainInvoiceId], [PaymentGroup], [MainInvoiceCode], [InvoiceCode], [PercentOrValue], [InvoiceTotal], [LessAmount], [SpecialAmount], [Category], [InvoiceCreatedTime], [InvoiceDiagnosticTestId], [IsPaidFinally], [PaymentId], [ReceiptCreatedTime], [BarCodeImageUrl]) VALUES (N'dc44b8f0-59b7-426d-94f7-51dd657f46b5', N'bb6d3d69-74b2-4218-b563-49d01cfbe205', N'Doctor', N'Biochemistry', 0, 0, N'', N'ac8fd896-ce40-4ccc-ae4a-f4b36463259e', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2019-02-25T18:51:45.1195115' AS DateTime2), CAST(N'2019-02-25T18:51:45.1195115' AS DateTime2), N'NOTASSIGNED', NULL, NULL, N'NCDG0122', N'0%', 5290, 0, 0, N'Test', CAST(N'2019-02-25T18:51:44.9835943' AS DateTime2), NULL, 0, NULL, NULL, NULL)
INSERT [dbo].[Commission] ([Id], [EmployeeId], [EmployeeType], [CommissionType], [Amount], [IsPaid], [Title], [InvoiceId], [HospitalId], [DateTime], [CreatedTime], [UpdatedTime], [MainInvoiceId], [PaymentGroup], [MainInvoiceCode], [InvoiceCode], [PercentOrValue], [InvoiceTotal], [LessAmount], [SpecialAmount], [Category], [InvoiceCreatedTime], [InvoiceDiagnosticTestId], [IsPaidFinally], [PaymentId], [ReceiptCreatedTime], [BarCodeImageUrl]) VALUES (N'dce4bf64-6da1-441d-9d8d-e4cb211d2837', N'8d3cf8f9-7ef7-4008-b529-e05a062b3f0c', N'Doctor', N'Biochemistry ', 55, 0, N'', N'9b1d0359-6b2c-4b7a-8e6f-121aed43f2b7', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2019-01-14T10:55:45.3340985' AS DateTime2), CAST(N'2019-02-03T08:17:35.7629175' AS DateTime2), N'NOTASSIGNED', N'NCR0114', NULL, N'NCDG0100', N'22%', 450, 0, 0, N'Test', CAST(N'2019-01-14T09:33:09.7393970' AS DateTime2), NULL, 1, NULL, N'03-02-2019 8:17 AM', N'data:image/jpeg;base64,[encoded data, 8380 characters]')
INSERT [dbo].[Commission] ([Id], [EmployeeId], [EmployeeType], [CommissionType], [Amount], [IsPaid], [Title], [InvoiceId], [HospitalId], [DateTime], [CreatedTime], [UpdatedTime], [MainInvoiceId], [PaymentGroup], [MainInvoiceCode], [InvoiceCode], [PercentOrValue], [InvoiceTotal], [LessAmount], [SpecialAmount], [Category], [InvoiceCreatedTime], [InvoiceDiagnosticTestId], [IsPaidFinally], [PaymentId], [ReceiptCreatedTime], [BarCodeImageUrl]) VALUES (N'dd0ac815-46c1-49e1-8f4b-d3dddeacf9ec', N'4c772c03-ef45-492a-82d7-24bd49320ea3', N'Referral', N'Biochemistry ', 0, 1, N'', N'd209247c-b29c-41b8-a45e-28c6b53decbb', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2018-12-25T15:51:27.8432923' AS DateTime2), CAST(N'2018-12-25T16:00:33.3685492' AS DateTime2), N'NOTASSIGNED', N'NCR0088', NULL, N'NCDG0078', N'10%', 1010.7, 112.3, 0, N'Test', CAST(N'2018-12-25T15:51:27.1486719' AS DateTime2), NULL, 1, N'NCP0011', N'25-Dec-18', N'NA')
INSERT [dbo].[Commission] ([Id], [EmployeeId], [EmployeeType], [CommissionType], [Amount], [IsPaid], [Title], [InvoiceId], [HospitalId], [DateTime], [CreatedTime], [UpdatedTime], [MainInvoiceId], [PaymentGroup], [MainInvoiceCode], [InvoiceCode], [PercentOrValue], [InvoiceTotal], [LessAmount], [SpecialAmount], [Category], [InvoiceCreatedTime], [InvoiceDiagnosticTestId], [IsPaidFinally], [PaymentId], [ReceiptCreatedTime], [BarCodeImageUrl]) VALUES (N'dd2b28ae-2817-47b0-bdbf-737864a74c36', N'f58ff95f-89e6-4f8e-8868-a83828ebe999', N'Doctor', N'UltraSoundCategory_1', 56, 0, N'', N'1d6045a7-1375-41cd-a3b1-166e195225d2', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2018-12-02T15:59:13.9311529' AS DateTime2), CAST(N'2018-12-22T16:17:56.9948653' AS DateTime2), N'NOTASSIGNED', NULL, NULL, N'NCDG0062', N'20%', 801.9, 89.1, 0, N'Test', CAST(N'2018-12-02T15:59:13.6286735' AS DateTime2), NULL, 1, N'NA', N'NA', N'NA')
INSERT [dbo].[Commission] ([Id], [EmployeeId], [EmployeeType], [CommissionType], [Amount], [IsPaid], [Title], [InvoiceId], [HospitalId], [DateTime], [CreatedTime], [UpdatedTime], [MainInvoiceId], [PaymentGroup], [MainInvoiceCode], [InvoiceCode], [PercentOrValue], [InvoiceTotal], [LessAmount], [SpecialAmount], [Category], [InvoiceCreatedTime], [InvoiceDiagnosticTestId], [IsPaidFinally], [PaymentId], [ReceiptCreatedTime], [BarCodeImageUrl]) VALUES (N'dd6b062f-9b3c-4515-8625-87e3d151c2cc', N'4c772c03-ef45-492a-82d7-24bd49320ea3', N'Referral', N'CT_2', 73.2, 0, N'', N'34fc05d9-22b2-478c-9ca0-f9a14d2e39a3', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2018-11-22T15:12:52.0715007' AS DateTime2), CAST(N'2018-12-22T16:17:56.9948653' AS DateTime2), N'NOTASSIGNED', NULL, NULL, N'NCDG0050', N'10%', 7322.92, 822.8, 0, N'Test', CAST(N'2018-11-22T15:12:50.9855282' AS DateTime2), NULL, 1, N'NA', N'NA', N'NA')
INSERT [dbo].[Commission] ([Id], [EmployeeId], [EmployeeType], [CommissionType], [Amount], [IsPaid], [Title], [InvoiceId], [HospitalId], [DateTime], [CreatedTime], [UpdatedTime], [MainInvoiceId], [PaymentGroup], [MainInvoiceCode], [InvoiceCode], [PercentOrValue], [InvoiceTotal], [LessAmount], [SpecialAmount], [Category], [InvoiceCreatedTime], [InvoiceDiagnosticTestId], [IsPaidFinally], [PaymentId], [ReceiptCreatedTime], [BarCodeImageUrl]) VALUES (N'ddb00233-14de-4ffe-8e0a-53b93ec472e3', N'f58ff95f-89e6-4f8e-8868-a83828ebe999', N'Doctor', N'CLINIC_REFERRAL', 3344, 1, N'ClinicInvoice', N'NOTASSIGNED', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2019-01-17T13:13:24.6028965' AS DateTime2), CAST(N'2019-02-02T16:34:30.2924126' AS DateTime2), N'409081dc-7ea0-4c1a-9ac9-e50472e9bb1f', NULL, NULL, N'NOTASSIGNED', N'3344', NULL, 0, 0, N'ADDED_JUST_FOR_COMMISSION', CAST(N'0001-01-01T00:00:00.0000000' AS DateTime2), NULL, 0, N'NCP0042', NULL, NULL)
INSERT [dbo].[Commission] ([Id], [EmployeeId], [EmployeeType], [CommissionType], [Amount], [IsPaid], [Title], [InvoiceId], [HospitalId], [DateTime], [CreatedTime], [UpdatedTime], [MainInvoiceId], [PaymentGroup], [MainInvoiceCode], [InvoiceCode], [PercentOrValue], [InvoiceTotal], [LessAmount], [SpecialAmount], [Category], [InvoiceCreatedTime], [InvoiceDiagnosticTestId], [IsPaidFinally], [PaymentId], [ReceiptCreatedTime], [BarCodeImageUrl]) VALUES (N'ddd58409-8f11-4425-92ff-c0d548247f7c', N'bb6d3d69-74b2-4218-b563-49d01cfbe205', N'Doctor', N'SPECIAL_SURGEON', 220, 0, N'KidneyOP_1', N'a335dccd-20b3-45b1-9268-5a34a1cb456d', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2019-02-16T16:56:13.4112733' AS DateTime2), CAST(N'2019-02-16T16:56:13.4112733' AS DateTime2), N'abb18202-7f6f-4a1b-86a2-5bcf1da3d8a7', NULL, N'NCINV0061', N'NCINV0061', N'220', NULL, 0, 0, N'Operation', CAST(N'2019-02-16T16:56:13.1391729' AS DateTime2), NULL, 0, NULL, NULL, NULL)
INSERT [dbo].[Commission] ([Id], [EmployeeId], [EmployeeType], [CommissionType], [Amount], [IsPaid], [Title], [InvoiceId], [HospitalId], [DateTime], [CreatedTime], [UpdatedTime], [MainInvoiceId], [PaymentGroup], [MainInvoiceCode], [InvoiceCode], [PercentOrValue], [InvoiceTotal], [LessAmount], [SpecialAmount], [Category], [InvoiceCreatedTime], [InvoiceDiagnosticTestId], [IsPaidFinally], [PaymentId], [ReceiptCreatedTime], [BarCodeImageUrl]) VALUES (N'de3e8030-ea12-44f7-a2d5-19b041b05f8c', N'2f49ff36-b04f-4081-9261-60ec973da26d', N'Referral', N'Biochemistry ', 50, 1, N'', N'36168919-2b9e-4dfc-ab56-e5b1c262953c', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2018-11-26T14:04:47.8778575' AS DateTime2), CAST(N'2018-12-22T16:23:58.5127715' AS DateTime2), N'NOTASSIGNED', N'NCR0010', NULL, N'NCDG0058', N'10%', 4228, 0, 0, N'Test+OverAllAmount', CAST(N'2018-11-26T14:04:47.7314583' AS DateTime2), NULL, 1, N'NA', N'NA', N'NA')
INSERT [dbo].[Commission] ([Id], [EmployeeId], [EmployeeType], [CommissionType], [Amount], [IsPaid], [Title], [InvoiceId], [HospitalId], [DateTime], [CreatedTime], [UpdatedTime], [MainInvoiceId], [PaymentGroup], [MainInvoiceCode], [InvoiceCode], [PercentOrValue], [InvoiceTotal], [LessAmount], [SpecialAmount], [Category], [InvoiceCreatedTime], [InvoiceDiagnosticTestId], [IsPaidFinally], [PaymentId], [ReceiptCreatedTime], [BarCodeImageUrl]) VALUES (N'de792791-a2a7-495a-be9d-86db0c2050cb', N'f58ff95f-89e6-4f8e-8868-a83828ebe999', N'Doctor', N'Biochemistry', 529, 1, N'', N'5dc1ffce-59f7-4661-b9fd-1a1e4bf52a15', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2019-02-14T13:02:19.1323066' AS DateTime2), CAST(N'2019-02-14T16:43:18.8394433' AS DateTime2), N'NOTASSIGNED', N'NCR0118', NULL, N'NCDG0117', N'10%', 5290, 0, 0, N'Test', CAST(N'2019-02-14T13:02:18.5006794' AS DateTime2), NULL, 1, N'NCP0068', N'14-02-2019 4:43 PM', N'data:image/jpeg;base64,[encoded data, 8364 characters]')
INSERT [dbo].[Commission] ([Id], [EmployeeId], [EmployeeType], [CommissionType], [Amount], [IsPaid], [Title], [InvoiceId], [HospitalId], [DateTime], [CreatedTime], [UpdatedTime], [MainInvoiceId], [PaymentGroup], [MainInvoiceCode], [InvoiceCode], [PercentOrValue], [InvoiceTotal], [LessAmount], [SpecialAmount], [Category], [InvoiceCreatedTime], [InvoiceDiagnosticTestId], [IsPaidFinally], [PaymentId], [ReceiptCreatedTime], [BarCodeImageUrl]) VALUES (N'deb57cdd-9d07-48d2-87e6-663247bac7e3', N'f58ff95f-89e6-4f8e-8868-a83828ebe999', N'Doctor', N'Biochemistry ', 50, 0, N'', N'2bab3a99-d239-40d5-82ad-023adb5e25ee', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2018-11-21T16:08:00.5046098' AS DateTime2), CAST(N'2018-12-22T16:17:56.9948653' AS DateTime2), N'NOTASSIGNED', NULL, NULL, N'NCDG0044', N'10%', 3694.6800000000003, 10, 0, N'Test', CAST(N'2018-11-21T16:08:00.2046921' AS DateTime2), NULL, 1, N'NA', N'NA', N'NA')
INSERT [dbo].[Commission] ([Id], [EmployeeId], [EmployeeType], [CommissionType], [Amount], [IsPaid], [Title], [InvoiceId], [HospitalId], [DateTime], [CreatedTime], [UpdatedTime], [MainInvoiceId], [PaymentGroup], [MainInvoiceCode], [InvoiceCode], [PercentOrValue], [InvoiceTotal], [LessAmount], [SpecialAmount], [Category], [InvoiceCreatedTime], [InvoiceDiagnosticTestId], [IsPaidFinally], [PaymentId], [ReceiptCreatedTime], [BarCodeImageUrl]) VALUES (N'dec58f78-9464-4358-820b-d4deaebab37a', N'4c772c03-ef45-492a-82d7-24bd49320ea3', N'Doctor', N'ANESTHESIA_DOCTOR', 10000, 0, N'KidneyOP_1', N'6f15c7a7-bea3-4a8d-8d86-bf13496b80f1', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2018-12-20T13:30:05.3356916' AS DateTime2), CAST(N'2018-12-22T16:17:56.9948653' AS DateTime2), N'ebce39be-4d21-4251-835d-2620dd8fe8aa', NULL, N'NCINV0037', N'NCINV0037', N'10000', NULL, 0, 0, N'Operation', CAST(N'2018-12-20T13:29:01.5391556' AS DateTime2), NULL, 1, N'NA', N'NA', N'NA')
INSERT [dbo].[Commission] ([Id], [EmployeeId], [EmployeeType], [CommissionType], [Amount], [IsPaid], [Title], [InvoiceId], [HospitalId], [DateTime], [CreatedTime], [UpdatedTime], [MainInvoiceId], [PaymentGroup], [MainInvoiceCode], [InvoiceCode], [PercentOrValue], [InvoiceTotal], [LessAmount], [SpecialAmount], [Category], [InvoiceCreatedTime], [InvoiceDiagnosticTestId], [IsPaidFinally], [PaymentId], [ReceiptCreatedTime], [BarCodeImageUrl]) VALUES (N'df83e595-679a-44c6-98da-3a805e03d324', N'4c772c03-ef45-492a-82d7-24bd49320ea3', N'Referral', N'Conbination', 0, 1, N'', N'f047f568-059f-4601-8455-697b90511f20', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2018-12-25T15:52:20.2391047' AS DateTime2), CAST(N'2018-12-25T16:00:33.3685492' AS DateTime2), N'NOTASSIGNED', N'NCR0088', NULL, N'NCDG0079', N'10%', 823, 0, 0, N'Test', CAST(N'2018-12-25T15:52:20.0618058' AS DateTime2), NULL, 1, N'NCP0009', N'25-Dec-18', N'NA')
INSERT [dbo].[Commission] ([Id], [EmployeeId], [EmployeeType], [CommissionType], [Amount], [IsPaid], [Title], [InvoiceId], [HospitalId], [DateTime], [CreatedTime], [UpdatedTime], [MainInvoiceId], [PaymentGroup], [MainInvoiceCode], [InvoiceCode], [PercentOrValue], [InvoiceTotal], [LessAmount], [SpecialAmount], [Category], [InvoiceCreatedTime], [InvoiceDiagnosticTestId], [IsPaidFinally], [PaymentId], [ReceiptCreatedTime], [BarCodeImageUrl]) VALUES (N'dfc22741-d8c2-4ea5-b3b8-497123d7211d', N'f58ff95f-89e6-4f8e-8868-a83828ebe999', N'Doctor', N'Biochemistry ', 50, 0, N'', N'fff0cb69-dc61-4081-9b80-ff8f57f6e46f', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2018-11-27T10:51:01.3179447' AS DateTime2), CAST(N'2018-12-22T16:17:56.9948653' AS DateTime2), N'NOTASSIGNED', NULL, NULL, N'NCDG0059', N'10%', 713.96, 12.29, 0, N'Test', CAST(N'2018-11-27T10:51:00.7530439' AS DateTime2), NULL, 1, N'NA', N'NA', N'NA')
INSERT [dbo].[Commission] ([Id], [EmployeeId], [EmployeeType], [CommissionType], [Amount], [IsPaid], [Title], [InvoiceId], [HospitalId], [DateTime], [CreatedTime], [UpdatedTime], [MainInvoiceId], [PaymentGroup], [MainInvoiceCode], [InvoiceCode], [PercentOrValue], [InvoiceTotal], [LessAmount], [SpecialAmount], [Category], [InvoiceCreatedTime], [InvoiceDiagnosticTestId], [IsPaidFinally], [PaymentId], [ReceiptCreatedTime], [BarCodeImageUrl]) VALUES (N'e04b8ca2-0835-470b-a9fb-c7784213c54e', N'bb6d3d69-74b2-4218-b563-49d01cfbe205', N'Doctor', N'CombineCategory_1', 0, 0, N'', N'6cf5f46b-ca82-409c-a699-7d394b027cf9', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2019-02-25T22:04:49.0059333' AS DateTime2), CAST(N'2019-02-25T22:04:59.9794726' AS DateTime2), N'NOTASSIGNED', NULL, NULL, N'NCDG0124', N'0%', 5439, 0, 0, N'Test', CAST(N'2019-02-25T22:04:48.7856116' AS DateTime2), NULL, 0, NULL, NULL, NULL)
INSERT [dbo].[Commission] ([Id], [EmployeeId], [EmployeeType], [CommissionType], [Amount], [IsPaid], [Title], [InvoiceId], [HospitalId], [DateTime], [CreatedTime], [UpdatedTime], [MainInvoiceId], [PaymentGroup], [MainInvoiceCode], [InvoiceCode], [PercentOrValue], [InvoiceTotal], [LessAmount], [SpecialAmount], [Category], [InvoiceCreatedTime], [InvoiceDiagnosticTestId], [IsPaidFinally], [PaymentId], [ReceiptCreatedTime], [BarCodeImageUrl]) VALUES (N'e0f1a526-4615-4844-9555-06d4c501de78', N'2f49ff36-b04f-4081-9261-60ec973da26d', N'Doctor', N'CombineCategory_1', 12.3, 1, N'', N'01742239-632f-4455-8f21-a6e5fde60fd1', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2019-01-17T09:32:58.0622329' AS DateTime2), CAST(N'2019-01-19T13:54:33.3800088' AS DateTime2), N'NOTASSIGNED', N'NCR0106', NULL, N'NCDG0104', N'10%', 1457, 0, 0, N'Test', CAST(N'2019-01-17T09:32:56.9286611' AS DateTime2), NULL, 1, N'NCP0048', N'19-01-2019 1:54 PM', N'data:image/jpeg;base64,[encoded data, 8452 characters]')
INSERT [dbo].[Commission] ([Id], [EmployeeId], [EmployeeType], [CommissionType], [Amount], [IsPaid], [Title], [InvoiceId], [HospitalId], [DateTime], [CreatedTime], [UpdatedTime], [MainInvoiceId], [PaymentGroup], [MainInvoiceCode], [InvoiceCode], [PercentOrValue], [InvoiceTotal], [LessAmount], [SpecialAmount], [Category], [InvoiceCreatedTime], [InvoiceDiagnosticTestId], [IsPaidFinally], [PaymentId], [ReceiptCreatedTime], [BarCodeImageUrl]) VALUES (N'e1a27d51-5e8f-4dea-8157-e3d1421c95c7', N'f58ff95f-89e6-4f8e-8868-a83828ebe999', N'Doctor', N'ASSIGNED_DOCTOR', 220, 1, N'KidneyOP_1', N'503de2f0-2c09-4be7-8f57-8b7c28560eff', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2019-01-17T13:27:38.7253968' AS DateTime2), CAST(N'2019-02-02T16:34:35.3465600' AS DateTime2), N'409081dc-7ea0-4c1a-9ac9-e50472e9bb1f', NULL, N'NCINV0051', N'NCINV0051', N'2330', NULL, 0, 0, N'Operation', CAST(N'2019-01-17T13:27:38.5977670' AS DateTime2), NULL, 0, N'NCP0056', NULL, NULL)
INSERT [dbo].[Commission] ([Id], [EmployeeId], [EmployeeType], [CommissionType], [Amount], [IsPaid], [Title], [InvoiceId], [HospitalId], [DateTime], [CreatedTime], [UpdatedTime], [MainInvoiceId], [PaymentGroup], [MainInvoiceCode], [InvoiceCode], [PercentOrValue], [InvoiceTotal], [LessAmount], [SpecialAmount], [Category], [InvoiceCreatedTime], [InvoiceDiagnosticTestId], [IsPaidFinally], [PaymentId], [ReceiptCreatedTime], [BarCodeImageUrl]) VALUES (N'e1eb611e-93ed-45e4-b758-b9a4dd3b1b25', N'65ba8697-497a-4f36-bd6c-668eba0c5d62', N'Doctor', N'DoctorVisit', 400, 0, N'', N'a8013dfc-eb93-4806-b82f-a23585711c1e', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2019-01-16T11:57:13.9503389' AS DateTime2), CAST(N'2019-02-03T08:17:35.7629175' AS DateTime2), N'382d7597-0685-443c-b918-7aab224db486', N'NCR0114', N'NCINV0048', NULL, NULL, NULL, 0, 0, N'Operation', CAST(N'2019-01-16T11:35:16.6739313' AS DateTime2), NULL, 1, NULL, N'03-02-2019 8:17 AM', N'data:image/jpeg;base64,[encoded data, 8380 characters]')
INSERT [dbo].[Commission] ([Id], [EmployeeId], [EmployeeType], [CommissionType], [Amount], [IsPaid], [Title], [InvoiceId], [HospitalId], [DateTime], [CreatedTime], [UpdatedTime], [MainInvoiceId], [PaymentGroup], [MainInvoiceCode], [InvoiceCode], [PercentOrValue], [InvoiceTotal], [LessAmount], [SpecialAmount], [Category], [InvoiceCreatedTime], [InvoiceDiagnosticTestId], [IsPaidFinally], [PaymentId], [ReceiptCreatedTime], [BarCodeImageUrl]) VALUES (N'e2111905-f879-456d-865f-168f796a94d9', N'7b3c0574-a184-4081-9a43-0b8360b4e107', N'Doctor', N'SPECIAL_SURGEON', 1000, 0, N'KidneyOP_1', N'fdcd1564-3c7a-40f5-9267-2f82b2c481e3', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2018-12-17T09:42:26.5044156' AS DateTime2), CAST(N'2018-12-22T16:17:56.9948653' AS DateTime2), N'83281dd4-5998-4b90-bd4f-ad30ae28cfa6', NULL, N'NCINV0036', N'NCINV0036', N'1000', NULL, 0, 0, N'Operation', CAST(N'2018-12-17T08:58:44.1210899' AS DateTime2), NULL, 1, N'NA', N'NA', N'NA')
INSERT [dbo].[Commission] ([Id], [EmployeeId], [EmployeeType], [CommissionType], [Amount], [IsPaid], [Title], [InvoiceId], [HospitalId], [DateTime], [CreatedTime], [UpdatedTime], [MainInvoiceId], [PaymentGroup], [MainInvoiceCode], [InvoiceCode], [PercentOrValue], [InvoiceTotal], [LessAmount], [SpecialAmount], [Category], [InvoiceCreatedTime], [InvoiceDiagnosticTestId], [IsPaidFinally], [PaymentId], [ReceiptCreatedTime], [BarCodeImageUrl]) VALUES (N'e2b47c70-bb7b-4bca-b224-a9b21b9ebe5a', N'4c772c03-ef45-492a-82d7-24bd49320ea3', N'Doctor', N'Conbination', 325, 0, N'', N'3e34586b-5b04-4755-ae22-5694878a495e', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2019-01-21T15:49:34.8348230' AS DateTime2), CAST(N'2019-02-03T08:17:35.7629175' AS DateTime2), N'NOTASSIGNED', N'NCR0114', NULL, N'NCDG0107', N'10%', 22280, 0, 0, N'Test', CAST(N'2019-01-21T15:49:31.1487126' AS DateTime2), NULL, 1, NULL, N'03-02-2019 8:17 AM', N'data:image/jpeg;base64,[encoded data, 8380 characters]')
INSERT [dbo].[Commission] ([Id], [EmployeeId], [EmployeeType], [CommissionType], [Amount], [IsPaid], [Title], [InvoiceId], [HospitalId], [DateTime], [CreatedTime], [UpdatedTime], [MainInvoiceId], [PaymentGroup], [MainInvoiceCode], [InvoiceCode], [PercentOrValue], [InvoiceTotal], [LessAmount], [SpecialAmount], [Category], [InvoiceCreatedTime], [InvoiceDiagnosticTestId], [IsPaidFinally], [PaymentId], [ReceiptCreatedTime], [BarCodeImageUrl]) VALUES (N'e2d1db91-433d-4438-8716-d8b9dc9ff27f', N'4c772c03-ef45-492a-82d7-24bd49320ea3', N'Referral', N'UltraSoundCategory_1', 36.9, 1, N'', N'24e4ffc4-6392-4eb1-a842-d19b9ccf6475', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2018-12-03T16:05:49.9483890' AS DateTime2), CAST(N'2018-12-03T16:23:12.2246970' AS DateTime2), N'NOTASSIGNED', N'NCR0021', NULL, N'NCDG0063', N'15%', 314, 0, 0, N'Test', CAST(N'2018-12-03T16:05:49.6665426' AS DateTime2), NULL, 0, N'NA', N'NA', N'NA')
INSERT [dbo].[Commission] ([Id], [EmployeeId], [EmployeeType], [CommissionType], [Amount], [IsPaid], [Title], [InvoiceId], [HospitalId], [DateTime], [CreatedTime], [UpdatedTime], [MainInvoiceId], [PaymentGroup], [MainInvoiceCode], [InvoiceCode], [PercentOrValue], [InvoiceTotal], [LessAmount], [SpecialAmount], [Category], [InvoiceCreatedTime], [InvoiceDiagnosticTestId], [IsPaidFinally], [PaymentId], [ReceiptCreatedTime], [BarCodeImageUrl]) VALUES (N'e2f6aa0b-d0e8-4f1b-8797-2f49b16cd63f', N'82b04905-0844-420a-9734-ef6ef52771f2', N'Doctor', N'Hematology', 128.33333333333331, 1, N'', N'abc57b45-50ab-4fe6-bdf2-ddbf1c3fbeee', N'd821cd9f-ac10-4f94-92cf-c292cd83b2c0', NULL, CAST(N'2018-08-01T20:49:52.2566667' AS DateTime2), CAST(N'2018-09-04T22:35:23.4333333' AS DateTime2), N'8c2d43c9-ad67-42a8-8527-2fc86d1cd454', N'RR0009', N'RINV0078', N'RDG0093', N'40%', 1500, 300, 0, N'Test', CAST(N'2018-08-01T10:33:28.2000000' AS DateTime2), NULL, 0, N'NA', N'NA', N'NA')
INSERT [dbo].[Commission] ([Id], [EmployeeId], [EmployeeType], [CommissionType], [Amount], [IsPaid], [Title], [InvoiceId], [HospitalId], [DateTime], [CreatedTime], [UpdatedTime], [MainInvoiceId], [PaymentGroup], [MainInvoiceCode], [InvoiceCode], [PercentOrValue], [InvoiceTotal], [LessAmount], [SpecialAmount], [Category], [InvoiceCreatedTime], [InvoiceDiagnosticTestId], [IsPaidFinally], [PaymentId], [ReceiptCreatedTime], [BarCodeImageUrl]) VALUES (N'e31f0fd1-39f2-484c-9a91-bfaf78cadf8e', N'f58ff95f-89e6-4f8e-8868-a83828ebe999', N'UltraSoundDoctor', N'UltraSoundCategory_2', 0, 0, N'', N'3e34586b-5b04-4755-ae22-5694878a495e', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2019-01-21T15:49:34.3358386' AS DateTime2), CAST(N'2019-02-03T08:17:35.7629175' AS DateTime2), N'NOTASSIGNED', N'NCR0114', N'NOTASSIGNED', N'NCDG0107', NULL, 22280, 0, 0, N'Test', CAST(N'2019-01-21T15:49:31.1487126' AS DateTime2), N'2e9d8309-dbf6-4203-b62a-fac439ede793', 1, NULL, N'03-02-2019 8:17 AM', N'data:image/jpeg;base64,[encoded data, 8380 characters]')
INSERT [dbo].[Commission] ([Id], [EmployeeId], [EmployeeType], [CommissionType], [Amount], [IsPaid], [Title], [InvoiceId], [HospitalId], [DateTime], [CreatedTime], [UpdatedTime], [MainInvoiceId], [PaymentGroup], [MainInvoiceCode], [InvoiceCode], [PercentOrValue], [InvoiceTotal], [LessAmount], [SpecialAmount], [Category], [InvoiceCreatedTime], [InvoiceDiagnosticTestId], [IsPaidFinally], [PaymentId], [ReceiptCreatedTime], [BarCodeImageUrl]) VALUES (N'e3a9f40c-c8f2-4338-b1fd-75c6d107ccac', N'2f49ff36-b04f-4081-9261-60ec973da26d', N'Doctor', N'Biochemistry ', 50, 0, N'', N'ff7bc358-98f0-48b6-8ee6-8b5cd5ff29ec', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2019-01-08T15:42:35.5856030' AS DateTime2), CAST(N'2019-02-03T08:17:35.7629175' AS DateTime2), N'NOTASSIGNED', N'NCR0114', NULL, N'NCDG0094', N'10%', 500, 0, 0, N'Test', CAST(N'2019-01-08T15:42:35.3604929' AS DateTime2), NULL, 1, NULL, N'03-02-2019 8:17 AM', N'data:image/jpeg;base64,[encoded data, 8380 characters]')
INSERT [dbo].[Commission] ([Id], [EmployeeId], [EmployeeType], [CommissionType], [Amount], [IsPaid], [Title], [InvoiceId], [HospitalId], [DateTime], [CreatedTime], [UpdatedTime], [MainInvoiceId], [PaymentGroup], [MainInvoiceCode], [InvoiceCode], [PercentOrValue], [InvoiceTotal], [LessAmount], [SpecialAmount], [Category], [InvoiceCreatedTime], [InvoiceDiagnosticTestId], [IsPaidFinally], [PaymentId], [ReceiptCreatedTime], [BarCodeImageUrl]) VALUES (N'e40b4870-92b2-41f5-970c-79b85c557b9e', N'cbfa4e4e-2fdf-48c7-9b94-e4712cf1f267', N'Referral', N'Ultrasound', -800, 1, N'', N'0a3797d0-4678-4d57-a1e7-0a1fbfd2403f', N'd821cd9f-ac10-4f94-92cf-c292cd83b2c0', NULL, CAST(N'2018-09-04T12:36:33.0700000' AS DateTime2), CAST(N'2018-09-04T22:35:23.4333333' AS DateTime2), N'bb6797bb-6fd2-464b-8880-539b58f95590', N'RR0051', N'RINV0175', N'RDG0191', N'0%', 0, 2050, 0, N'Test', CAST(N'2018-09-01T10:15:48.6966667' AS DateTime2), NULL, 0, N'NA', N'NA', N'NA')
INSERT [dbo].[Commission] ([Id], [EmployeeId], [EmployeeType], [CommissionType], [Amount], [IsPaid], [Title], [InvoiceId], [HospitalId], [DateTime], [CreatedTime], [UpdatedTime], [MainInvoiceId], [PaymentGroup], [MainInvoiceCode], [InvoiceCode], [PercentOrValue], [InvoiceTotal], [LessAmount], [SpecialAmount], [Category], [InvoiceCreatedTime], [InvoiceDiagnosticTestId], [IsPaidFinally], [PaymentId], [ReceiptCreatedTime], [BarCodeImageUrl]) VALUES (N'e40e15d5-fd2d-4357-b3bb-0a93e4364127', N'8d3cf8f9-7ef7-4008-b529-e05a062b3f0c', N'Doctor', N'CT_2', 51.26, 0, N'', N'55338c4f-57bc-4c74-97df-c3cf847157ba', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2019-01-13T13:30:45.8361976' AS DateTime2), CAST(N'2019-02-03T08:17:35.7629175' AS DateTime2), N'NOTASSIGNED', N'NCR0114', NULL, N'NCDG0098', N'22%', 1733, 0, 0, N'Test', CAST(N'2019-01-13T13:24:08.0000000' AS DateTime2), NULL, 1, NULL, N'03-02-2019 8:17 AM', N'data:image/jpeg;base64,[encoded data, 8380 characters]')
INSERT [dbo].[Commission] ([Id], [EmployeeId], [EmployeeType], [CommissionType], [Amount], [IsPaid], [Title], [InvoiceId], [HospitalId], [DateTime], [CreatedTime], [UpdatedTime], [MainInvoiceId], [PaymentGroup], [MainInvoiceCode], [InvoiceCode], [PercentOrValue], [InvoiceTotal], [LessAmount], [SpecialAmount], [Category], [InvoiceCreatedTime], [InvoiceDiagnosticTestId], [IsPaidFinally], [PaymentId], [ReceiptCreatedTime], [BarCodeImageUrl]) VALUES (N'e4bbcca6-bbe3-4ccc-b1e8-02153da38efd', N'3e6c7598-b4d4-453d-97fa-1de3da9ac873', N'Doctor', N'Pathology', 0, 1, N'', N'192168f2-5f03-4d9d-a6e2-b5d846984dd6', N'd821cd9f-ac10-4f94-92cf-c292cd83b2c0', NULL, CAST(N'2018-07-29T13:41:47.0066667' AS DateTime2), CAST(N'2018-09-04T22:35:23.4333333' AS DateTime2), N'1f6d0654-58e3-4932-a7cc-93707fdbcafd', N'RR0031', N'RINV0058', N'RDG0078', N'0%', 1400, 0, 0, N'Test', CAST(N'2018-07-29T13:39:51.4466667' AS DateTime2), NULL, 0, N'NA', N'NA', N'NA')
INSERT [dbo].[Commission] ([Id], [EmployeeId], [EmployeeType], [CommissionType], [Amount], [IsPaid], [Title], [InvoiceId], [HospitalId], [DateTime], [CreatedTime], [UpdatedTime], [MainInvoiceId], [PaymentGroup], [MainInvoiceCode], [InvoiceCode], [PercentOrValue], [InvoiceTotal], [LessAmount], [SpecialAmount], [Category], [InvoiceCreatedTime], [InvoiceDiagnosticTestId], [IsPaidFinally], [PaymentId], [ReceiptCreatedTime], [BarCodeImageUrl]) VALUES (N'e4c8f393-2f1b-4468-bde4-6c848e382a16', N'4c772c03-ef45-492a-82d7-24bd49320ea3', N'Doctor', N'CT_2', 23.3, 1, N'', N'22b6caac-53fd-43b0-a1fc-f5a38215c3a2', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2018-11-26T13:54:13.5225335' AS DateTime2), CAST(N'2018-12-22T16:36:54.6054465' AS DateTime2), N'NOTASSIGNED', N'NCR0007', NULL, N'NCDG0057', N'10%', 924.3, 102.7, 0, N'Test+OverAllAmount', CAST(N'2018-11-26T13:54:12.9779995' AS DateTime2), NULL, 1, N'NA', N'NA', N'NA')
INSERT [dbo].[Commission] ([Id], [EmployeeId], [EmployeeType], [CommissionType], [Amount], [IsPaid], [Title], [InvoiceId], [HospitalId], [DateTime], [CreatedTime], [UpdatedTime], [MainInvoiceId], [PaymentGroup], [MainInvoiceCode], [InvoiceCode], [PercentOrValue], [InvoiceTotal], [LessAmount], [SpecialAmount], [Category], [InvoiceCreatedTime], [InvoiceDiagnosticTestId], [IsPaidFinally], [PaymentId], [ReceiptCreatedTime], [BarCodeImageUrl]) VALUES (N'e5131a81-7caf-4b2d-8224-94031839dc13', N'8d3cf8f9-7ef7-4008-b529-e05a062b3f0c', N'Doctor', N'ASSISTANT_SURGEON', 10000, 0, N'KidneyOP_1', N'6f15c7a7-bea3-4a8d-8d86-bf13496b80f1', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2018-12-20T13:30:05.3557501' AS DateTime2), CAST(N'2018-12-22T16:17:56.9948653' AS DateTime2), N'ebce39be-4d21-4251-835d-2620dd8fe8aa', NULL, N'NCINV0037', N'NCINV0037', N'10000', NULL, 0, 0, N'Operation', CAST(N'2018-12-20T13:29:01.5391556' AS DateTime2), NULL, 1, N'NA', N'NA', N'NA')
INSERT [dbo].[Commission] ([Id], [EmployeeId], [EmployeeType], [CommissionType], [Amount], [IsPaid], [Title], [InvoiceId], [HospitalId], [DateTime], [CreatedTime], [UpdatedTime], [MainInvoiceId], [PaymentGroup], [MainInvoiceCode], [InvoiceCode], [PercentOrValue], [InvoiceTotal], [LessAmount], [SpecialAmount], [Category], [InvoiceCreatedTime], [InvoiceDiagnosticTestId], [IsPaidFinally], [PaymentId], [ReceiptCreatedTime], [BarCodeImageUrl]) VALUES (N'e551eba8-305c-4a0c-bd18-0f0b3dab436c', N'4c772c03-ef45-492a-82d7-24bd49320ea3', N'Doctor', N'CLINIC_REFERRAL', 3330, 1, N'ClinicInvoice', N'a96496a0-5736-4692-933e-99055207f837', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2019-01-16T12:40:43.4754503' AS DateTime2), CAST(N'2019-01-17T13:16:26.2359928' AS DateTime2), N'f253682d-6adc-4661-b133-62ba078575b5', NULL, N'NCINV0050', N'NOTASSIGNED', N'3330', NULL, 0, 0, N'OPERATION', CAST(N'2019-01-16T12:40:10.8903524' AS DateTime2), NULL, 0, N'NCP0037', NULL, NULL)
INSERT [dbo].[Commission] ([Id], [EmployeeId], [EmployeeType], [CommissionType], [Amount], [IsPaid], [Title], [InvoiceId], [HospitalId], [DateTime], [CreatedTime], [UpdatedTime], [MainInvoiceId], [PaymentGroup], [MainInvoiceCode], [InvoiceCode], [PercentOrValue], [InvoiceTotal], [LessAmount], [SpecialAmount], [Category], [InvoiceCreatedTime], [InvoiceDiagnosticTestId], [IsPaidFinally], [PaymentId], [ReceiptCreatedTime], [BarCodeImageUrl]) VALUES (N'e5eee462-a965-4e94-ab9c-e03b4c02477e', N'4c772c03-ef45-492a-82d7-24bd49320ea3', N'Referral', N'Serology ', 60, 0, N'', N'ddd8d663-8ec8-4094-874b-42caf6053c00', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2019-01-06T13:25:46.8319936' AS DateTime2), CAST(N'2019-02-03T08:17:35.7629175' AS DateTime2), N'NOTASSIGNED', N'NCR0114', NULL, N'NCDG0083', N'10%', 3558, 0, 0, N'Test', CAST(N'2019-01-06T10:10:33.9540561' AS DateTime2), NULL, 1, NULL, N'03-02-2019 8:17 AM', N'data:image/jpeg;base64,[encoded data, 8380 characters]')
INSERT [dbo].[Commission] ([Id], [EmployeeId], [EmployeeType], [CommissionType], [Amount], [IsPaid], [Title], [InvoiceId], [HospitalId], [DateTime], [CreatedTime], [UpdatedTime], [MainInvoiceId], [PaymentGroup], [MainInvoiceCode], [InvoiceCode], [PercentOrValue], [InvoiceTotal], [LessAmount], [SpecialAmount], [Category], [InvoiceCreatedTime], [InvoiceDiagnosticTestId], [IsPaidFinally], [PaymentId], [ReceiptCreatedTime], [BarCodeImageUrl]) VALUES (N'e65740bf-e06e-4b9f-9687-416a611aeb35', N'1fc95b60-c117-4163-b73d-37bd64d7fac8', N'Doctor', N'ASSISTANT_DOCTOR', 44, 1, N'KidneyOP_1', N'9a924f8e-9b6c-487b-b362-4bd5f203f570', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2019-01-16T12:01:42.8206925' AS DateTime2), CAST(N'2019-01-17T13:15:57.1972506' AS DateTime2), N'54863b24-e825-429a-9631-211c636d6bd2', NULL, N'NCINV0049', N'NCINV0049', N'44', NULL, 0, 0, N'Operation', CAST(N'2019-01-16T12:01:42.6787804' AS DateTime2), NULL, 0, N'NCP0039', NULL, NULL)
INSERT [dbo].[Commission] ([Id], [EmployeeId], [EmployeeType], [CommissionType], [Amount], [IsPaid], [Title], [InvoiceId], [HospitalId], [DateTime], [CreatedTime], [UpdatedTime], [MainInvoiceId], [PaymentGroup], [MainInvoiceCode], [InvoiceCode], [PercentOrValue], [InvoiceTotal], [LessAmount], [SpecialAmount], [Category], [InvoiceCreatedTime], [InvoiceDiagnosticTestId], [IsPaidFinally], [PaymentId], [ReceiptCreatedTime], [BarCodeImageUrl]) VALUES (N'e77fa30e-9f4e-4e07-b0c3-1fd6d89da119', N'4c772c03-ef45-492a-82d7-24bd49320ea3', N'Referral', N'CombineCategory_1', 500, 1, N'', N'11ca0974-d897-47ae-9180-66b70ae11df1', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2018-12-24T13:50:33.6253712' AS DateTime2), CAST(N'2018-12-24T14:13:15.4658082' AS DateTime2), N'NOTASSIGNED', N'NCR0082', NULL, N'NCDG0077', N'10%', 969.3, 107.7, 0, N'Test', CAST(N'2018-12-24T13:50:33.1434282' AS DateTime2), NULL, 1, N'NCP0007', N'NA', N'NA')
INSERT [dbo].[Commission] ([Id], [EmployeeId], [EmployeeType], [CommissionType], [Amount], [IsPaid], [Title], [InvoiceId], [HospitalId], [DateTime], [CreatedTime], [UpdatedTime], [MainInvoiceId], [PaymentGroup], [MainInvoiceCode], [InvoiceCode], [PercentOrValue], [InvoiceTotal], [LessAmount], [SpecialAmount], [Category], [InvoiceCreatedTime], [InvoiceDiagnosticTestId], [IsPaidFinally], [PaymentId], [ReceiptCreatedTime], [BarCodeImageUrl]) VALUES (N'e78180a9-9f64-44a4-a3a5-c8847c10f111', N'24a50fd4-8d08-41d3-94e5-be95c9e77925', N'Doctor', N'Pathology (Normal)', -11.194029850746269, 1, N'', N'b70eff46-b568-4872-a0ab-c1b3f08d0952', N'd821cd9f-ac10-4f94-92cf-c292cd83b2c0', NULL, CAST(N'2018-07-09T21:57:50.0000000' AS DateTime2), CAST(N'2018-09-04T22:35:24.3233333' AS DateTime2), N'aa1caee1-8c39-4ec8-b77c-a7419072800d', N'RR0001', N'RINV0002', N'RDG0010', N'0%', 3300, 50, 0, N'Test', CAST(N'2018-07-09T21:48:26.0000000' AS DateTime2), NULL, 0, N'NA', N'NA', N'NA')
