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'664e6b88-d61c-4698-91d9-ef2c2fae1aaa', N'f58ff95f-89e6-4f8e-8868-a83828ebe999', N'Doctor', N'CombineCategory_1', 12.3, 0, N'', N'b589a7b7-19d2-492e-8366-1d76f986e4dd', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2019-01-03T18:58:29.1861200' AS DateTime2), CAST(N'2019-02-03T08:17:35.7629175' AS DateTime2), N'NOTASSIGNED', N'NCR0114', NULL, N'NCDG0081', N'10%', 873, 0, 0, N'Test', CAST(N'2019-01-03T18:58:28.7901557' 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'6671d329-e83c-4838-a3de-058ba7aaf34b', N'aa1bef3d-ea7c-404a-9d19-2347fcd8fad9', N'Doctor', N'Pathology', 400, 1, N'', N'cc6b598c-3380-46d1-a4e2-28dfc45b783e', N'd821cd9f-ac10-4f94-92cf-c292cd83b2c0', NULL, CAST(N'2018-07-23T14:55:31.1166667' AS DateTime2), CAST(N'2018-09-04T22:35:23.0600000' AS DateTime2), N'5610283e-bfdd-4559-813b-66c681d1914a', N'RR0027', N'RINV0033', N'RDG0052', N'40%', 2550, 0, 0, N'Test', CAST(N'2018-07-23T14:49:45.7266667' 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'667e5ddc-9122-43ba-bcf7-3d68055ce95c', N'2f49ff36-b04f-4081-9261-60ec973da26d', N'UltraSoundDoctor', N'UltraSoundCategory_1', 0, 0, N'', N'9ec3c26c-7cfa-44f4-8e24-98f3073d3ea5', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2018-12-06T15:26:18.4705831' AS DateTime2), CAST(N'2018-12-22T16:17:56.9948653' AS DateTime2), N'NOTASSIGNED', NULL, N'NOTASSIGNED', N'NCDG0069', NULL, 1570, 157, 0, N'Test', CAST(N'2018-12-06T15:26:18.2047477' AS DateTime2), N'a6585a59-a1ab-45cc-8152-ccba68bec6a5', 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'668b1311-f329-4c68-b986-04d394484278', N'65ba8697-497a-4f36-bd6c-668eba0c5d62', N'Doctor', N'ASSISTANT_DOCTOR', 444, 1, 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-20T15:20:51.6133918' AS DateTime2), N'ebce39be-4d21-4251-835d-2620dd8fe8aa', N'NCR0065', N'NCINV0037', N'NCINV0037', N'444', NULL, 0, 0, N'Operation', CAST(N'2018-12-20T13:29:01.5391556' 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'670f94a1-8622-4129-a57d-5a06238c2163', N'2f49ff36-b04f-4081-9261-60ec973da26d', N'UltraSoundDoctor', N'UltraSoundCategory_1', 100, 1, N'', N'1d6045a7-1375-41cd-a3b1-166e195225d2', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2018-12-02T15:59:13.8426243' AS DateTime2), CAST(N'2018-12-03T11:26:13.7367881' AS DateTime2), N'NOTASSIGNED', N'NCR0013', N'NOTASSIGNED', N'NCDG0062', NULL, 891, 89.1, 0, N'test', CAST(N'2018-12-02T15:59:13.6286735' 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'67968541-cad3-4844-a7a5-dc3cd8ddbdc8', N'f58ff95f-89e6-4f8e-8868-a83828ebe999', N'Doctor', N'Biochemistry ', 0, 1, N'', N'11ca0974-d897-47ae-9180-66b70ae11df1', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2018-12-24T13:50:33.5701661' AS DateTime2), CAST(N'2018-12-24T14:11:26.5307031' AS DateTime2), N'NOTASSIGNED', N'NCR0079', 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'NCP0006', 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'67b6c39b-e84b-415c-a204-0e12fc9ce075', N'2f49ff36-b04f-4081-9261-60ec973da26d', N'Referral', N'UltraSoundCategory_1', 0, 0, N'', N'fff0cb69-dc61-4081-9b80-ff8f57f6e46f', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2018-11-27T10:51:01.3702888' AS DateTime2), CAST(N'2018-12-22T16:17:56.9948653' AS DateTime2), N'NOTASSIGNED', NULL, NULL, N'NCDG0059', N'0%', 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'68027b7d-36c3-41d0-9962-034f10ca34fd', N'4c772c03-ef45-492a-82d7-24bd49320ea3', N'Doctor', N'Biochemistry ', 75, 1, N'', N'992af5f3-7d01-4d51-9af2-2a83f5148810', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2019-01-27T13:25:42.2438271' AS DateTime2), CAST(N'2019-01-27T13:36:28.3904888' AS DateTime2), N'NOTASSIGNED', N'NCR0107', NULL, N'NCDG0110', N'10%', 750, 0, 0, N'Test', CAST(N'2019-01-27T13:25:38.4631545' AS DateTime2), NULL, 1, N'NCP0049', N'27-01-2019 1:36 PM', N'data:image/jpeg;base64,[encoded data, 8416 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'68a74392-870c-4679-8b26-b63c4e6da2b5', N'f58ff95f-89e6-4f8e-8868-a83828ebe999', N'Referral', N'Biochemistry ', 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'68ae3ccf-5f79-437d-87c3-ec87feb85924', N'2f49ff36-b04f-4081-9261-60ec973da26d', N'Referral', N'CombineCategory_1', 12.3, 0, N'', N'fff0cb69-dc61-4081-9b80-ff8f57f6e46f', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2018-11-27T10:51:01.3742861' 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'68b9a8d8-4322-44d5-8553-30c79d4927b2', N'82b04905-0844-420a-9734-ef6ef52771f2', N'Doctor', N'X-Ray ', 105, 1, N'', N'abc57b45-50ab-4fe6-bdf2-ddbf1c3fbeee', N'd821cd9f-ac10-4f94-92cf-c292cd83b2c0', NULL, CAST(N'2018-08-01T20:49:52.3033333' AS DateTime2), CAST(N'2018-09-04T22:35:23.0600000' AS DateTime2), N'8c2d43c9-ad67-42a8-8527-2fc86d1cd454', N'RR0007', 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'68c218e6-29de-4adf-8452-f030786a9daa', N'1fc95b60-c117-4163-b73d-37bd64d7fac8', N'Doctor', N'CombineCategory_1', 51.26, 0, N'', N'f33e74fd-da37-47dd-882b-a9663d8f8b7d', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2019-01-14T11:07:21.5026442' AS DateTime2), CAST(N'2019-02-03T08:17:35.7629175' AS DateTime2), N'NOTASSIGNED', N'NCR0114', NULL, N'NCDG0102', N'22%', 2783, 0, 0, N'Test', CAST(N'2019-01-14T11:07:20.0329910' 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'69e91933-2a30-4d52-95c0-adf1184d300e', N'4c772c03-ef45-492a-82d7-24bd49320ea3', N'UltraSoundDoctor', N'UltraSoundCategory_2', 6000, 1, N'', N'c5e84ccb-38d8-4ca4-a224-92ea42e0f4c5', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2019-02-03T08:43:30.6233420' AS DateTime2), CAST(N'2019-02-03T08:45:12.2780248' AS DateTime2), N'NOTASSIGNED', N'NCR0116', N'NOTASSIGNED', N'NCDG0115', NULL, 1234, 0, 0, N'test', CAST(N'2019-02-02T16:42:10.5098169' AS DateTime2), N'3130782c-414f-4609-8117-153fc3841164', 1, N'NCP0064', N'03-02-2019 8:45 AM', N'data:image/jpeg;base64,[encoded data, 8376 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'6a635816-8452-4fb3-a6a3-d4f30e341090', N'cbfa4e4e-2fdf-48c7-9b94-e4712cf1f267', N'Referral', N'Biochemistry', -200, 1, N'', N'd8b6db0e-2c00-409a-b02a-184d15ca3c33', N'd821cd9f-ac10-4f94-92cf-c292cd83b2c0', NULL, CAST(N'2018-09-04T12:38:09.7100000' AS DateTime2), CAST(N'2018-09-04T22:35:23.0600000' AS DateTime2), N'ace96277-8fcd-46aa-b198-ddcecba2182b', N'RR0051', N'RINV0157', N'RDG0174', N'0%', 0, 1750, 0, N'Test', CAST(N'2018-08-28T09:57:58.2066667' 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'6a747b75-5032-418f-9389-bf11777ea1fc', N'2f49ff36-b04f-4081-9261-60ec973da26d', N'UltraSoundDoctor', N'UltraSoundCategory_2', 0, 0, N'', N'9ec3c26c-7cfa-44f4-8e24-98f3073d3ea5', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2018-12-06T15:26:18.4096199' AS DateTime2), CAST(N'2018-12-22T16:17:56.9948653' AS DateTime2), N'NOTASSIGNED', NULL, N'NOTASSIGNED', N'NCDG0069', NULL, 1570, 157, 0, N'Test', CAST(N'2018-12-06T15:26:18.2047477' AS DateTime2), N'0cc883b0-ff6d-4d17-97d8-68894dd008a2', 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'6a8d424c-609e-476f-9cbe-06f6d998fe10', N'f58ff95f-89e6-4f8e-8868-a83828ebe999', N'Doctor', N'CombineCategory_1', 12.3, 1, N'', N'd209247c-b29c-41b8-a45e-28c6b53decbb', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2018-12-25T15:51:27.8589248' AS DateTime2), CAST(N'2018-12-25T16:00:37.0757042' AS DateTime2), N'NOTASSIGNED', N'NCR0089', 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'NCP0010', 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'6ae75f15-6954-48d0-b627-3b4405589155', N'f58ff95f-89e6-4f8e-8868-a83828ebe999', N'Doctor', N'CLINIC_REFERRAL', 77, 0, N'ClinicInvoice', N'NOTASSIGNED', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2019-01-17T11:56:55.1181980' AS DateTime2), CAST(N'2019-02-03T08:17:35.7629175' AS DateTime2), N'409081dc-7ea0-4c1a-9ac9-e50472e9bb1f', 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'6b5255d8-149e-4edc-bdce-e45c313feaf5', N'aa1bef3d-ea7c-404a-9d19-2347fcd8fad9', N'Doctor', N'Pathology', 0, 1, N'', N'b31a7dee-379e-4d99-8eda-213ebc8157ea', N'd821cd9f-ac10-4f94-92cf-c292cd83b2c0', NULL, CAST(N'2018-07-30T11:24:28.3666667' AS DateTime2), CAST(N'2018-09-04T22:35:23.0633333' AS DateTime2), N'8012e745-48fa-4c5b-804d-6296e0285a3b', N'RR0022', N'RINV0067', N'RDG0082', N'0%', 150, 0, 0, N'Test', CAST(N'2018-07-30T11:20:21.2266667' 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'6bbc2fec-a787-4aa8-bd16-f7d2045d6a07', N'2f49ff36-b04f-4081-9261-60ec973da26d', N'Doctor', N'CLINIC_REFERRAL', 0, 1, N'ClinicInvoice', N'95de806b-ea14-47eb-9664-4474d52b6c2e', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2018-12-18T11:05:31.4412675' AS DateTime2), CAST(N'2018-12-20T11:28:03.0350225' AS DateTime2), N'83281dd4-5998-4b90-bd4f-ad30ae28cfa6', N'NCR0050', N'NCINV0036', N'NOTASSIGNED', N'1000', NULL, 0, 0, N'OPERATION', CAST(N'2018-12-17T08:57:09.7197221' 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'6d4d9271-ee6f-4f97-96cd-6374f4f8fcfa', N'2f49ff36-b04f-4081-9261-60ec973da26d', N'Doctor', 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.0515133' 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'6d974214-4ed0-4825-a307-3799ef1966ec', N'24a50fd4-8d08-41d3-94e5-be95c9e77925', N'Doctor', N'Pathology (Normal)', -76.923076923076934, 1, N'', N'c58a7b22-0d04-4786-8350-d805dddce26d', N'd821cd9f-ac10-4f94-92cf-c292cd83b2c0', NULL, CAST(N'2018-07-09T21:55:24.3933333' AS DateTime2), CAST(N'2018-09-04T22:35:23.0633333' 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'6def470d-76a7-46f2-ab88-80d633f90e4d', N'cbfa4e4e-2fdf-48c7-9b94-e4712cf1f267', N'Referral', N'Ultrasound', -800, 1, N'', N'd8b6db0e-2c00-409a-b02a-184d15ca3c33', N'd821cd9f-ac10-4f94-92cf-c292cd83b2c0', NULL, CAST(N'2018-09-04T12:38:09.6966667' AS DateTime2), CAST(N'2018-09-04T22:35:23.0633333' AS DateTime2), N'ace96277-8fcd-46aa-b198-ddcecba2182b', N'RR0051', N'RINV0157', N'RDG0174', N'0%', 0, 1750, 0, N'Test', CAST(N'2018-08-28T09:57:58.2066667' 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'6df4d904-d16e-4c70-99df-d03833e4bd27', N'4c772c03-ef45-492a-82d7-24bd49320ea3', N'Referral', N'Conbination', 125, 0, N'', N'34fc05d9-22b2-478c-9ca0-f9a14d2e39a3', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2018-11-22T15:12:52.0665037' 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'6df8664c-3e55-4a78-853c-4c776dc1daf4', N'6ee087eb-7031-408f-b4ea-f567d250f75b', N'Doctor', N'UltraSoundCategory_2', 67.2, 0, N'', N'bf6974a6-9f9e-4640-bd8f-535bab6e4eab', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2019-01-08T11:14:00.3673068' AS DateTime2), CAST(N'2019-02-03T08:17:35.7629175' AS DateTime2), N'NOTASSIGNED', N'NCR0114', NULL, N'NCDG0093', N'12%', 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'6fa702bb-39f3-4b3c-9abc-78dabdb6f1ad', N'4c772c03-ef45-492a-82d7-24bd49320ea3', N'Referral', N'UltraSoundCategory_2', 108.6, 1, N'', N'e456eaf1-93e2-43db-9cd1-8a09a2a66374', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2018-12-03T16:34:17.6232696' AS DateTime2), CAST(N'2018-12-04T10:52:56.4334638' AS DateTime2), N'NOTASSIGNED', N'NCR0027', NULL, N'NCDG0064', N'15%', 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'6fd59379-5f34-4bef-b816-4f09722d626d', N'4c772c03-ef45-492a-82d7-24bd49320ea3', N'Doctor', N'ANESTHESIA_DOCTOR', 100, 1, N'KidneyOP_1', N'93443976-2220-48f9-8268-cdecc45440be', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2018-12-17T09:42:25.0786234' AS DateTime2), CAST(N'2018-12-20T11:28:02.9760334' AS DateTime2), N'83281dd4-5998-4b90-bd4f-ad30ae28cfa6', N'NCR0046', N'NCINV0036', N'NCINV0036', N'1000', NULL, 0, 0, N'Operation', CAST(N'2018-12-17T09:30:58.2648648' 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'6fedff74-f27d-4d4d-93dd-4ecc6c0958e9', N'f58ff95f-89e6-4f8e-8868-a83828ebe999', N'Doctor', N'CLINIC_REFERRAL', 77, 0, N'ClinicInvoice', N'NOTASSIGNED', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2019-01-17T11:54:07.3901309' AS DateTime2), CAST(N'2019-02-03T08:17:35.7629175' AS DateTime2), N'409081dc-7ea0-4c1a-9ac9-e50472e9bb1f', 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'70d8c319-0568-4221-8164-acc3d5baa0a6', 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.3500000' AS DateTime2), CAST(N'2018-09-04T22:35:23.0633333' 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'7103b238-f292-4d72-9246-047cef79f50a', N'f58ff95f-89e6-4f8e-8868-a83828ebe999', N'Referral', N'CT_2', 2.66, 0, N'', N'65513723-2d7e-40ba-989d-11c1138646df', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2018-11-25T13:14:54.6236525' AS DateTime2), CAST(N'2018-12-22T16:17:56.9948653' AS DateTime2), N'NOTASSIGNED', NULL, NULL, N'NCDG0055', N'2%', 964.8, 241.2, 0, N'Test', CAST(N'2018-11-25T13:14:54.0936648' 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'71069747-5bb9-4371-b033-7842f3ef9a9c', N'2f49ff36-b04f-4081-9261-60ec973da26d', N'Doctor', N'SPECIAL_SURGEON', 0, 1, N'LungsOP_1', N'c8249365-2881-4525-849a-00a05376e928', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2018-12-20T13:32:39.6508766' AS DateTime2), CAST(N'2018-12-22T16:40:46.9611973' AS DateTime2), N'9c0c25c5-11fc-4a52-a928-6cfebda17d20', N'NCR0067', N'NCINV0038', N'NCINV0038', N'1110', NULL, 0, 0, N'Operation', CAST(N'2018-12-20T13:32:05.5291427' 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'71b7e9f8-5ce1-41e0-aa74-850b173bce84', N'2f49ff36-b04f-4081-9261-60ec973da26d', N'UltraSoundDoctor', N'UltraSoundCategory_1', 0, 0, N'', N'9ec3c26c-7cfa-44f4-8e24-98f3073d3ea5', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2018-12-06T15:26:18.5005644' AS DateTime2), CAST(N'2018-12-22T16:17:56.9948653' AS DateTime2), N'NOTASSIGNED', NULL, N'NOTASSIGNED', N'NCDG0069', NULL, 1570, 157, 0, N'Test', CAST(N'2018-12-06T15:26:18.2047477' AS DateTime2), N'95b91f6c-3080-4aa0-8145-efb1e85c9c2a', 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'7349edbf-1821-4fd6-ae11-7e9e00cc8266', N'aa1bef3d-ea7c-404a-9d19-2347fcd8fad9', N'Doctor', N'Pathology', -115.11627906976744, 1, N'', N'7a054570-a86b-44e4-b924-ce2c3d1cd64e', N'd821cd9f-ac10-4f94-92cf-c292cd83b2c0', NULL, CAST(N'2018-07-16T17:41:26.7600000' AS DateTime2), CAST(N'2018-09-04T22:35:23.0700000' 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'73d45d15-aba7-456a-987a-cc490c0e66e5', N'f58ff95f-89e6-4f8e-8868-a83828ebe999', N'Doctor', 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.9293432' 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'73d8d508-a7a7-4be5-b144-43d829115fd6', N'f58ff95f-89e6-4f8e-8868-a83828ebe999', N'Doctor', N'Surgeon', 1000, 0, N'KidneyOP_1', N'a5c8f1df-75e3-41e6-b77f-76aec925404e', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2018-12-13T16:01:55.2640914' 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: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'7440fa61-7d71-49f1-8825-32df2731b4d1', N'2f49ff36-b04f-4081-9261-60ec973da26d', N'Doctor', N'SPECIAL_SURGEON', 1000, 1, N'KidneyOP_1', N'3d4646d1-0c53-413f-9e23-9783787d8522', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2018-12-26T12:45:43.9256293' AS DateTime2), CAST(N'2018-12-27T12:05:15.6569742' AS DateTime2), N'0c6f2449-2e4f-489d-8372-860af4eabf75', N'NCR0100', N'NCINV0041', N'NCINV0041', N'2000', NULL, 0, 0, N'Operation', CAST(N'2018-12-26T12:45:35.8356009' AS DateTime2), NULL, 1, N'NCP0031', N'27-Dec-18 11:37 AM', N'data:image/jpeg;base64,[encoded data, 8412 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'7461e6d9-da90-4904-bd75-3af305f7ec83', N'8d3cf8f9-7ef7-4008-b529-e05a062b3f0c', N'Doctor', N'Conbination', 165, 0, N'', N'55338c4f-57bc-4c74-97df-c3cf847157ba', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2019-01-13T13:30:45.8301997' 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'7490538e-7cd0-4ee8-9f66-9e2a0c97c76a', N'8d3cf8f9-7ef7-4008-b529-e05a062b3f0c', N'Doctor', N'CLINIC_REFERRAL', 33, 0, N'ClinicInvoice', N'ff9b4b8f-34e8-4506-b6b7-dc51b37680f6', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2019-01-14T10:42:21.8963464' 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'33', 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'74a98f8b-11d6-4b65-9cef-f9156f447350', N'bb6d3d69-74b2-4218-b563-49d01cfbe205', N'Doctor', N'ASSIGNED_DOCTOR', 220, 0, N'KidneyOP_1', N'172d55ca-fd29-4f10-bb15-b9c83957b941', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2019-02-22T22:49:35.9443573' AS DateTime2), CAST(N'2019-02-22T22:49:35.9443573' 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'75ab6626-b15d-41e1-bc32-095b832353e0', 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:13.7323037' 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'6a6018dd-0f61-4cb7-8dc2-c9c17c2db899', 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'75bf6431-215a-47f5-adc7-77776041128b', N'4c772c03-ef45-492a-82d7-24bd49320ea3', N'Doctor', N'ASSISTANT_SURGEON', 780, 1, N'KidneyOP_1', N'93443976-2220-48f9-8268-cdecc45440be', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2018-12-17T09:42:25.1481672' AS DateTime2), CAST(N'2018-12-20T11:28:02.9760334' AS DateTime2), N'83281dd4-5998-4b90-bd4f-ad30ae28cfa6', N'NCR0057', N'NCINV0036', N'NCINV0036', N'1000', NULL, 0, 0, N'Operation', CAST(N'2018-12-17T09:30:58.2648648' 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'7671f019-25a1-4c67-98b4-edc06126b75c', N'4c772c03-ef45-492a-82d7-24bd49320ea3', N'Referral', N'Biochemistry ', 200, 1, N'', N'f047f568-059f-4601-8455-697b90511f20', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2018-12-25T15:52:20.2440988' 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'767232d3-b4fe-445a-8461-617cddcc1e5a', N'7a432ef3-78e3-4091-811b-11fc802fb981', N'Doctor', N'X-Ray ', -266.66666666666669, 1, N'', N'32efb69d-feb4-42a5-b5d8-9365511f01dc', N'd821cd9f-ac10-4f94-92cf-c292cd83b2c0', NULL, CAST(N'2018-07-15T10:46:11.1866667' AS DateTime2), CAST(N'2018-09-04T22:35:23.0733333' AS DateTime2), N'a09d1933-a42e-4b01-8f2f-08ffd0109967', N'RR0042', N'RINV0009', N'RDG0026', N'0%', 2300, 1150, 0, N'Test', CAST(N'2018-07-15T10:05:42.1766667' 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'768f8bd0-f40e-4472-a353-eb83272e0312', N'2f49ff36-b04f-4081-9261-60ec973da26d', N'Referral', N'CombineCategory_1', 98.9, 0, N'', N'bf6974a6-9f9e-4640-bd8f-535bab6e4eab', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2019-01-08T09:26:07.1187581' 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'76d3d3b8-1bd9-4d42-8c94-8d6d05e23e38', N'2f49ff36-b04f-4081-9261-60ec973da26d', N'Doctor', N'SPECIAL_SURGEON', 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.1634055' AS DateTime2), CAST(N'2018-12-27T12:05:15.6370524' AS DateTime2), N'0c6f2449-2e4f-489d-8372-860af4eabf75', N'NCR0100', N'NCINV0041', N'NCINV0041', N'1000', NULL, 0, 0, N'Operation', CAST(N'2018-12-26T12:16:04.4329021' AS DateTime2), NULL, 1, N'NCP0026', N'27-Dec-18 11:37 AM', N'data:image/jpeg;base64,[encoded data, 8412 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'77909c1a-3304-4f0d-b1b9-56f685d7abd6', N'2f49ff36-b04f-4081-9261-60ec973da26d', N'Doctor', N'CombineCategory_1', 56.7, 1, N'', N'ddd8d663-8ec8-4094-874b-42caf6053c00', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2019-01-06T15:18:33.5636561' AS DateTime2), CAST(N'2019-01-19T13:44:02.6857815' AS DateTime2), N'NOTASSIGNED', N'NCR0103', NULL, N'NCDG0083', N'10%', 3558, 0, 0, N'Test', CAST(N'2019-01-06T10:10:33.9540561' AS DateTime2), NULL, 1, N'NCP0045', N'Saturday, January 19, 2019 1:44 PM', N'data:image/jpeg;base64,[encoded data, 8416 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'77b7e9e9-b3c6-41d8-a095-8191ed41daad', N'f58ff95f-89e6-4f8e-8868-a83828ebe999', N'Doctor', N'UltraSoundCategory_1', 6.8, 1, N'', N'a022cb08-0c98-4969-a31f-1d5d2884fbbb', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2018-12-06T13:43:42.2419901' AS DateTime2), CAST(N'2018-12-06T15:14:18.7414536' AS DateTime2), N'NOTASSIGNED', N'NCR0041', NULL, N'NCDG0068', N'20%', 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'785711b4-9d3b-45bb-aa3a-94ccfb22e363', N'f58ff95f-89e6-4f8e-8868-a83828ebe999', N'UltraSoundDoctor', N'UltraSoundCategory_2', 0, 0, N'', N'9ec3c26c-7cfa-44f4-8e24-98f3073d3ea5', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2018-12-06T15:26:18.3906317' AS DateTime2), CAST(N'2018-12-22T16:17:56.9948653' AS DateTime2), N'NOTASSIGNED', NULL, N'NOTASSIGNED', N'NCDG0069', NULL, 1570, 157, 0, N'Test', CAST(N'2018-12-06T15:26:18.2047477' AS DateTime2), N'392e74cc-cab4-49ec-86ba-65c6d69a6d3b', 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'788ead33-ad4c-4b7a-a1ae-da02438971f0', N'4c772c03-ef45-492a-82d7-24bd49320ea3', N'Doctor', N'ASSISTANT_SURGEON', 344, 0, N'KidneyOP_1', N'a335dccd-20b3-45b1-9268-5a34a1cb456d', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2019-02-16T16:56:13.4002798' AS DateTime2), CAST(N'2019-02-16T16:56:13.4002798' 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'789718a1-1b07-424a-9d64-556316e3db22', N'4c772c03-ef45-492a-82d7-24bd49320ea3', N'Doctor', N'Biochemistry ', 75, 1, N'', N'4db4f89f-ff9a-4eb0-98ee-966524f56836', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2019-01-16T11:02:20.7035218' AS DateTime2), CAST(N'2019-01-19T13:46:18.4655544' AS DateTime2), N'NOTASSIGNED', N'NCR0104', NULL, N'NCDG0103', N'10%', 1000, 150, 0, N'Test', CAST(N'2019-01-16T11:02:20.0059561' AS DateTime2), NULL, 1, N'NCP0044', N'19-Jan-19 1:46:18 PM 1:46 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'78d8e1f5-4a90-4487-b2b4-2f0ae97835ee', N'2f49ff36-b04f-4081-9261-60ec973da26d', N'Referral', N'Conbination', 15, 1, N'', N'3eddb765-d8ed-44bb-ad8a-2effd21d9b58', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2018-12-23T11:14:13.7408744' AS DateTime2), CAST(N'2018-12-23T11:19:05.2221187' AS DateTime2), N'NOTASSIGNED', N'NCR0078', NULL, N'NCDG0074', N'10%', 585, 65, 0, N'Test', CAST(N'2018-12-23T11:14:13.6797121' 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'790525ee-59fa-48ed-bed7-52a8451a6358', N'4c772c03-ef45-492a-82d7-24bd49320ea3', N'Doctor', N'Conbination', 20, 0, N'', N'15a731c0-16d0-4ab4-a55b-8352a17027fc', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2018-11-19T15:21:13.1048726' 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'790d5937-d428-4c13-b2e8-e092c1a23063', 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.1320083' 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'8a845ff6-30b3-4cc1-a177-f0ab581863cb', 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'7962128f-954a-4932-b520-54428ea91509', N'f58ff95f-89e6-4f8e-8868-a83828ebe999', N'UltraSoundDoctor', N'UltraSoundCategory_2', 0, 0, N'', N'1d6045a7-1375-41cd-a3b1-166e195225d2', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2018-12-02T15:59:13.7626297' AS DateTime2), CAST(N'2018-12-22T16:17:56.9948653' AS DateTime2), N'NOTASSIGNED', NULL, N'NOTASSIGNED', N'NCDG0062', NULL, 891, 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'79686734-20d7-4dbb-85f8-923df9990b05', N'f58ff95f-89e6-4f8e-8868-a83828ebe999', N'Doctor', N'ASSIGNED_DOCTOR', 0, 1, N'KidneyOP_1', N'd647259e-5506-4502-afed-9c1f343b16c0', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2019-01-19T10:09:28.0213931' AS DateTime2), CAST(N'2019-02-14T16:09:04.0459259' AS DateTime2), N'ac648549-b8c7-4d2e-bd99-44837610c45a', N'NCR0114', N'NCINV0053', N'NCINV0053', N'44', NULL, 0, 0, N'Operation', CAST(N'2019-01-19T10:09:27.8770711' AS DateTime2), NULL, 1, N'NCP0067', 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'7a4fec7b-f529-48e5-b9dd-d247fe38b9cf', N'f58ff95f-89e6-4f8e-8868-a83828ebe999', N'UltraSoundDoctor', N'UltraSoundCategory_2', 0, 0, N'', N'9ec3c26c-7cfa-44f4-8e24-98f3073d3ea5', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2018-12-06T15:26:18.4186138' AS DateTime2), CAST(N'2018-12-22T16:17:56.9948653' AS DateTime2), N'NOTASSIGNED', NULL, N'NOTASSIGNED', N'NCDG0069', NULL, 1570, 157, 0, N'Test', CAST(N'2018-12-06T15:26:18.2047477' AS DateTime2), N'6feafa73-cb03-4394-8550-575fc2a1ec5a', 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'7aa11bb7-e35f-4fef-b2b8-e5d3ac9cc65c', 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:47:03.0825225' 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'7ad08d7a-0d21-4883-919d-550bfad20763', N'7aea2b0b-c196-4bd2-b220-d9be9dee7688', N'Doctor', N'Pathology', -75.675675675675677, 1, N'', N'f3e6d38d-8ac1-45df-8b17-e4b6686bcbb1', N'd821cd9f-ac10-4f94-92cf-c292cd83b2c0', NULL, CAST(N'2018-07-25T15:32:20.8233333' AS DateTime2), CAST(N'2018-09-04T22:35:23.0733333' AS DateTime2), N'ff0ebd31-f7bc-498c-b664-2e56792867c1', N'RR0023', N'RINV0040', N'RDG0060', N'0%', 1800, 420, 0, N'Test', CAST(N'2018-07-25T15:23:31.7466667' 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'7c01b445-c939-42a7-ad8f-181b8eb2de82', N'8d3cf8f9-7ef7-4008-b529-e05a062b3f0c', N'Referral', N'CombineCategory_1', 36.74, 1, N'', N'4561a3e0-d340-4da7-8094-1a2b3288fa16', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2019-02-02T10:06:56.6024133' AS DateTime2), CAST(N'2019-02-03T08:13:15.2195195' AS DateTime2), N'NOTASSIGNED', N'NCR0113', NULL, N'NCDG0114', N'22%', 917, 0, 0, N'Test', CAST(N'2019-02-02T10:06:56.3895443' AS DateTime2), NULL, 1, N'NCP0061', N'03-02-2019 8:13 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'7c69d93b-5ec9-4ccf-9a0d-ad380c2f2074', N'2f49ff36-b04f-4081-9261-60ec973da26d', N'Referral', N'Biochemistry ', 14277, 0, N'', N'bf6974a6-9f9e-4640-bd8f-535bab6e4eab', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2019-01-08T09:26:07.1187581' 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'7d0be5b1-cd4c-4d30-8309-534510dafa1d', N'4c772c03-ef45-492a-82d7-24bd49320ea3', N'Doctor', 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.2457765' 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'7d6f81cf-e1b8-44ac-8de3-2293511c1428', N'cbfa4e4e-2fdf-48c7-9b94-e4712cf1f267', N'Referral', N'Biochemistry', -15.384615384615385, 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.0733333' 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'7dd3a7d9-541d-45e5-8d47-7d9bd951a148', N'f58ff95f-89e6-4f8e-8868-a83828ebe999', N'Doctor', N'CT_2', 45.5, 1, N'', N'02581d5d-e2a1-45e9-b4c4-36f1102a9f4a', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2018-12-05T12:30:59.4959739' AS DateTime2), CAST(N'2018-12-06T13:19:34.6988020' 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')
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'7e182451-fa1c-482b-ab62-09a752ce9a67', N'4c772c03-ef45-492a-82d7-24bd49320ea3', N'Doctor', N'ANESTHESIA_DOCTOR', 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.0032526' 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'7eee6b99-6a94-4a2a-9992-b9ce9f46873d', N'2f49ff36-b04f-4081-9261-60ec973da26d', N'Referral', N'Conbination', 0, 0, N'', N'86636fc7-fea3-4e6c-ad30-5f4bea4f8417', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2018-11-24T13:30:55.9273456' AS DateTime2), CAST(N'2018-12-22T16:17:56.9948653' AS DateTime2), N'NOTASSIGNED', NULL, NULL, N'NCDG0053', N'0', 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'7efc68ab-61a7-4e3f-b384-59008217f301', N'2f49ff36-b04f-4081-9261-60ec973da26d', N'Doctor', N'Biochemistry ', 95, 1, N'', N'01742239-632f-4455-8f21-a6e5fde60fd1', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2019-01-17T09:32:57.9932059' 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'7f10d0cf-ec84-4e94-a16c-f81e62dfec45', N'4c772c03-ef45-492a-82d7-24bd49320ea3', N'Referral', N'CombineCategory_1', 0, 1, N'', N'f047f568-059f-4601-8455-697b90511f20', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2018-12-25T15:52:20.2480965' 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'7f24f6fd-45d8-4303-9cb5-abcfa378c4f8', N'2f49ff36-b04f-4081-9261-60ec973da26d', N'Doctor', N'Biochemistry ', 75, 0, N'', N'd8f7316a-aa7f-478e-83c8-4e5f01b66a0e', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2019-01-29T16:08:58.0752157' AS DateTime2), CAST(N'2019-02-03T08:17:35.7629175' AS DateTime2), N'NOTASSIGNED', N'NCR0114', NULL, N'NCDG0111', N'10%', 785.7, 87.3, 0, N'Test', CAST(N'2019-01-29T16:08:54.7740617' 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'7fe5924c-2d73-42f1-b634-cc6fb660092d', N'7aea2b0b-c196-4bd2-b220-d9be9dee7688', N'Doctor', N'Pathology', -47.2972972972973, 1, N'', N'f3e6d38d-8ac1-45df-8b17-e4b6686bcbb1', N'd821cd9f-ac10-4f94-92cf-c292cd83b2c0', NULL, CAST(N'2018-07-25T15:32:20.8566667' AS DateTime2), CAST(N'2018-09-04T22:35:23.0733333' AS DateTime2), N'ff0ebd31-f7bc-498c-b664-2e56792867c1', N'RR0018', N'RINV0040', N'RDG0060', N'0%', 1800, 420, 0, N'Test', CAST(N'2018-07-25T15:23:31.7466667' 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'80862618-ffe3-4332-89d7-1af33e6fb741', N'2f49ff36-b04f-4081-9261-60ec973da26d', N'Doctor', N'Serology ', 60, 1, N'', N'ddd8d663-8ec8-4094-874b-42caf6053c00', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2019-01-06T15:18:33.5576603' AS DateTime2), CAST(N'2019-01-19T13:44:02.6857815' AS DateTime2), N'NOTASSIGNED', N'NCR0103', NULL, N'NCDG0083', N'10%', 3558, 0, 0, N'Test', CAST(N'2019-01-06T10:10:33.9540561' AS DateTime2), NULL, 1, N'NCP0045', N'Saturday, January 19, 2019 1:44 PM', N'data:image/jpeg;base64,[encoded data, 8416 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'80a9cc1c-099d-4a60-a27b-740ff5afd2d4', N'35471cdd-86e8-4eb1-8532-e96a2ba5ea2f', N'Referral', N'Biochemistry', 40, 1, N'', N'78375895-ab72-4a5c-b4a1-3153afdf3fca', N'd821cd9f-ac10-4f94-92cf-c292cd83b2c0', NULL, CAST(N'2018-08-03T15:10:57.5800000' AS DateTime2), CAST(N'2018-09-04T22:35:23.0766667' AS DateTime2), N'b49f9faf-baaa-43aa-a7d7-72dd8cb158a3', N'RR0048', N'RINV0090', N'RDG0107', N'40', 1400, 0, 0, N'Test', CAST(N'2018-08-03T13:44:51.0166667' 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'80eb6ae0-eba8-4c16-a74c-9a9442f310f8', N'f58ff95f-89e6-4f8e-8868-a83828ebe999', N'Doctor', N'CLINIC_REFERRAL', 3, 0, N'ClinicInvoice', N'6555b14b-76a1-48f6-a908-67cda25b45e2', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2019-02-27T19:19:22.8588882' AS DateTime2), CAST(N'2019-02-27T19:19:22.8588882' AS DateTime2), N'abb18202-7f6f-4a1b-86a2-5bcf1da3d8a7', NULL, N'NCINV0061', N'NOTASSIGNED', N'3', NULL, 0, 0, N'OPERATION', CAST(N'2019-02-16T16:37:01.2260854' 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'813e50d3-98db-405e-b640-2f32286eced3', N'4c772c03-ef45-492a-82d7-24bd49320ea3', N'Referral', N'CT_2', 500, 1, N'', N'11ca0974-d897-47ae-9180-66b70ae11df1', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2018-12-24T13:50:33.6203554' AS DateTime2), CAST(N'2018-12-24T14:13:15.4528145' AS DateTime2), N'NOTASSIGNED', N'NCR0080', 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'81773ffb-2f30-459e-9c8f-0796bf0cce10', 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:13.8202508' 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'6bb322bd-d460-4cbe-9288-9a12bfa3c373', 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'8187024f-44a4-4e4e-9365-790e1e3b4aa8', N'f58ff95f-89e6-4f8e-8868-a83828ebe999', 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.3548261' 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'cd640710-1f77-4904-bb55-9384cab197ee', 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'8188a3d3-e76b-4ae8-b727-1a81809217a7', N'4c772c03-ef45-492a-82d7-24bd49320ea3', N'Doctor', N'Conbination', 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'827a52ba-99da-4420-88ff-738ebca5d7c4', N'4c772c03-ef45-492a-82d7-24bd49320ea3', N'UltraSoundDoctor', N'UltraSoundCategory_2', 80, 1, N'', N'e456eaf1-93e2-43db-9cd1-8a09a2a66374', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2018-12-03T16:34:17.5533129' AS DateTime2), CAST(N'2018-12-04T10:52:13.9300285' AS DateTime2), N'NOTASSIGNED', N'NCR0024', N'NOTASSIGNED', N'NCDG0064', NULL, 1004, 0, 0, N'test', CAST(N'2018-12-03T16:34:17.4923501' AS DateTime2), N'7244df4c-b1e9-4ea7-b102-26bd76c5a4ba', 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'83036ca7-be17-4a69-822f-3d581effb770', N'f58ff95f-89e6-4f8e-8868-a83828ebe999', N'Doctor', N'ASSIGNED_DOCTOR', 0, 0, N'KidneyOP_1', N'a57d776c-6f61-4d28-b156-7ad6277382b5', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2019-01-16T12:42:28.8646553' AS DateTime2), CAST(N'2019-02-03T08:17:35.7629175' AS DateTime2), N'f253682d-6adc-4661-b133-62ba078575b5', N'NCR0114', N'NCINV0050', N'NCINV0050', N'0', NULL, 0, 0, N'Operation', CAST(N'2019-01-16T12:42:28.8006949' 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'8357a33f-c3af-4ead-8147-f09dbd0b3dcd', N'f58ff95f-89e6-4f8e-8868-a83828ebe999', N'Doctor', N'Surgeon', 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.5131685' 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'83dc6da0-5384-4c00-81d3-8526fbd8d4ce', N'f58ff95f-89e6-4f8e-8868-a83828ebe999', N'Doctor', N'CombineCategory_1', 40, 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.8579214' AS DateTime2), N'NOTASSIGNED', N'NCR0003', 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'83e4e838-c7c1-4de8-a023-e48eece9c249', N'35471cdd-86e8-4eb1-8532-e96a2ba5ea2f', N'Referral', N'ECG/ECO', 40, 1, N'', N'78375895-ab72-4a5c-b4a1-3153afdf3fca', N'd821cd9f-ac10-4f94-92cf-c292cd83b2c0', NULL, CAST(N'2018-08-03T15:10:57.5800000' AS DateTime2), CAST(N'2018-09-04T22:35:23.0766667' AS DateTime2), N'b49f9faf-baaa-43aa-a7d7-72dd8cb158a3', N'RR0048', N'RINV0090', N'RDG0107', N'40', 1400, 0, 0, N'Test', CAST(N'2018-08-03T13:44:51.0166667' 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'841fc587-e0e0-4538-94db-9bff1b7ce90e', N'7a432ef3-78e3-4091-811b-11fc802fb981', N'Doctor', N'ECG/ECO', -100, 1, N'', N'32efb69d-feb4-42a5-b5d8-9365511f01dc', N'd821cd9f-ac10-4f94-92cf-c292cd83b2c0', NULL, CAST(N'2018-07-15T10:46:11.1866667' AS DateTime2), CAST(N'2018-09-04T22:35:23.0766667' AS DateTime2), N'a09d1933-a42e-4b01-8f2f-08ffd0109967', N'RR0042', N'RINV0009', N'RDG0026', N'0%', 2300, 1150, 0, N'Test', CAST(N'2018-07-15T10:05:42.1766667' 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'84f0e0e9-d5dd-47ff-a9b0-5a6aa4d14a27', N'8d3cf8f9-7ef7-4008-b529-e05a062b3f0c', N'Doctor', N'ASSISTANT_DOCTOR', 100000, 0, N'KidneyOP_1', N'fdcd1564-3c7a-40f5-9267-2f82b2c481e3', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2018-12-19T11:12:30.9730400' AS DateTime2), CAST(N'2018-12-22T16:17:56.9948653' AS DateTime2), N'83281dd4-5998-4b90-bd4f-ad30ae28cfa6', NULL, N'NCINV0036', N'NOTASSIGNED', N'100000', NULL, 0, 0, N'ADDED_JUST_FOR_COMMISSION', 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'85508028-cb82-4740-a81f-e6a8dd0bc137', N'f58ff95f-89e6-4f8e-8868-a83828ebe999', N'Doctor', N'Biochemistry ', 75, 1, N'', N'0858d559-451b-4578-a003-c905fe560de7', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2019-01-19T11:29:20.3424851' AS DateTime2), CAST(N'2019-01-19T13:49:24.6466694' AS DateTime2), N'NOTASSIGNED', N'NCR0105', NULL, N'NCDG0106', N'10%', 1000, 150, 0, N'Test', CAST(N'2019-01-19T11:29:20.2545392' AS DateTime2), NULL, 1, N'NCP0047', N'19-01-2019 1:49 PM', N'data:image/jpeg;base64,[encoded data, 8416 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'85a7ca51-cf7b-4d63-90c6-9d05333af9b0', N'f58ff95f-89e6-4f8e-8868-a83828ebe999', N'Doctor', N'Biochemistry ', 75, 0, N'', N'bedb87d2-f0f8-4b88-8875-34e408073588', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2018-11-24T09:11:24.1810616' AS DateTime2), CAST(N'2018-12-22T16:17:56.9948653' AS DateTime2), N'NOTASSIGNED', NULL, NULL, N'NCDG0051', N'10%', 873, 0, 0, N'Test', CAST(N'2018-11-24T09:11:22.9214992' 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'8686696d-4c11-48ab-8235-ef4b2dd99c68', N'f58ff95f-89e6-4f8e-8868-a83828ebe999', N'Doctor', N'CLINIC_REFERRAL', 1000, 1, N'ClinicInvoice', N'fdac064a-2cec-4056-8828-9a640411513b', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2018-12-20T13:29:20.9883530' AS DateTime2), CAST(N'2018-12-23T10:08:58.3626984' AS DateTime2), N'ebce39be-4d21-4251-835d-2620dd8fe8aa', N'NCR0063', N'NCINV0037', N'NOTASSIGNED', N'1000', NULL, 0, 0, N'OPERATION', CAST(N'2018-12-20T13:27:39.5305824' 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'872ba3fb-4005-470b-a444-8336cfd47d46', N'2f49ff36-b04f-4081-9261-60ec973da26d', N'Referral', N'Biochemistry ', 100, 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:16:30.8763260' AS DateTime2), N'NOTASSIGNED', N'NCR0084', 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'87cac26c-b4ce-4fa3-b30c-601a72363425', N'4c772c03-ef45-492a-82d7-24bd49320ea3', N'Doctor', N'Biochemistry ', 1500, 0, N'', N'38eaf1ff-15e6-464b-afe4-8edfd638a740', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2019-01-07T12:03:22.0226886' 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'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'87d5056a-2dfd-4aa5-a8a6-6acd8c781216', N'45c6d504-e6fb-4da1-9454-92195a3dba94', N'Doctor', N'X-Ray ', -58.695652173913047, 1, N'', N'51c1122d-de73-48a8-b5f3-11dbd65883d8', N'd821cd9f-ac10-4f94-92cf-c292cd83b2c0', NULL, CAST(N'2018-07-20T10:57:07.4266667' AS DateTime2), CAST(N'2018-09-04T22:35:23.0800000' AS DateTime2), N'd4384253-b264-43c8-b337-297dfdb59c3c', N'RR0040', N'RINV0022', N'RDG0040', N'0%', 1000, 150, 0, N'Test', CAST(N'2018-07-20T10:45:14.6333333' 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'882f2d55-7f80-420d-86c1-6ed0132094ce', N'4c772c03-ef45-492a-82d7-24bd49320ea3', N'Doctor', N'CombineCategory_1', 16.7, 1, N'', N'7bd632bc-ba3f-4f72-90c9-a5025915a7d4', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2019-01-31T10:43:35.7213164' AS DateTime2), CAST(N'2019-01-31T10:55:27.6476151' AS DateTime2), N'NOTASSIGNED', N'NCR0108', NULL, N'NCDG0112', N'10%', 917, 0, 0, N'Test', CAST(N'2019-01-31T10:43:32.3253485' AS DateTime2), NULL, 1, N'NCP0050', N'31-01-2019 10:55 AM', N'data:image/jpeg;base64,[encoded data, 8396 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'88d19869-926d-4f5d-bfca-c462f0e4a7bf', N'8d3cf8f9-7ef7-4008-b529-e05a062b3f0c', N'Doctor', N'CombineCategory_1', 63.8, 0, N'', N'db7cc987-1cd1-43f1-b548-dc824f9cb7d5', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2019-02-16T09:07:58.5595416' AS DateTime2), CAST(N'2019-02-16T13:33:40.7978349' AS DateTime2), N'NOTASSIGNED', NULL, NULL, N'NCDG0118', N'22%', 2075.3, 41.7, 0, N'Test', CAST(N'2019-02-16T09:07:54.1846206' 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'89451082-9dbe-4866-b098-9fdcdf988bb4', N'65ba8697-497a-4f36-bd6c-668eba0c5d62', N'Referral', N'CombineCategory_1', 129.33, 0, N'', N'25baf030-f741-473d-882b-a87e2bcd6ba0', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2019-01-07T12:42:30.4882141' AS DateTime2), CAST(N'2019-02-03T08:17:35.7629175' AS DateTime2), N'NOTASSIGNED', N'NCR0114', NULL, N'NCDG0086', N'27%', 583, 0, 0, N'Test', CAST(N'2019-01-07T11:33:57.9726087' 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'899bba2b-7692-4387-8592-c626c1256383', N'f58ff95f-89e6-4f8e-8868-a83828ebe999', N'UltraSoundDoctor', N'UltraSoundCategory_2', 0, 0, N'', N'9ec3c26c-7cfa-44f4-8e24-98f3073d3ea5', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2018-12-06T15:26:18.3816374' AS DateTime2), CAST(N'2018-12-22T16:17:56.9948653' AS DateTime2), N'NOTASSIGNED', NULL, N'NOTASSIGNED', N'NCDG0069', NULL, 1570, 157, 0, N'Test', CAST(N'2018-12-06T15:26:18.2047477' AS DateTime2), N'425fe1bf-2223-4d3a-9d42-bcecac4700d4', 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'89c2cd3d-06a0-4cac-b911-24c2af08ebd9', N'f58ff95f-89e6-4f8e-8868-a83828ebe999', N'Referral', N'Conbination', 6, 0, N'', N'65513723-2d7e-40ba-989d-11c1138646df', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2018-11-25T13:14:54.6392773' AS DateTime2), CAST(N'2018-12-22T16:17:56.9948653' AS DateTime2), N'NOTASSIGNED', NULL, NULL, N'NCDG0055', N'4%', 964.8, 241.2, 0, N'Test', CAST(N'2018-11-25T13:14:54.0936648' 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'8a0e9846-b4e6-479f-9372-181a9b3b6ca5', N'cbfa4e4e-2fdf-48c7-9b94-e4712cf1f267', N'Referral', N'ECG/ECO', -50, 1, N'', N'307df4fa-fc32-4973-9000-fa77dcf8b613', N'd821cd9f-ac10-4f94-92cf-c292cd83b2c0', NULL, CAST(N'2018-07-25T11:19:21.9566667' AS DateTime2), CAST(N'2018-09-04T22:35:23.0800000' AS DateTime2), N'f67fbe0b-1d75-4aa8-8735-7a354fc8e115', N'RR0019', N'RINV0036', N'RDG0055', N'0%', 200, 50, 0, N'Test', CAST(N'2018-07-25T11:14:37.1000000' 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'8a2273ed-a671-431f-a269-bb48d1b3e545', N'f58ff95f-89e6-4f8e-8868-a83828ebe999', N'Referral', N'Haematology', 13, 0, N'', N'65513723-2d7e-40ba-989d-11c1138646df', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2018-11-25T13:14:54.6392773' AS DateTime2), CAST(N'2018-12-22T16:17:56.9948653' AS DateTime2), N'NOTASSIGNED', NULL, NULL, N'NCDG0055', N'10%', 964.8, 241.2, 0, N'Test', CAST(N'2018-11-25T13:14:54.0936648' 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'8aa4407c-ff55-4895-aa3d-1ee8ef6321be', N'f58ff95f-89e6-4f8e-8868-a83828ebe999', N'Doctor', N'Biochemistry', 0, 0, N'', N'a8a76081-0a85-44f6-b533-7ccadc0eede1', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2019-02-25T13:55:39.5246630' AS DateTime2), CAST(N'2019-02-25T13:55:39.5246630' AS DateTime2), N'NOTASSIGNED', NULL, NULL, N'NCDG0120', N'0%', 5290, 0, 0, N'Test', CAST(N'2019-02-25T13:55:36.0617962' 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'8b7dba45-dded-44b1-805e-1a2570f06c1a', N'2f49ff36-b04f-4081-9261-60ec973da26d', N'Doctor', N'SPECIAL_SURGEON', 220, 1, N'KidneyOP_1', N'35309d68-3241-45dd-abff-5a49a3367c91', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2019-01-31T10:57:08.8935687' AS DateTime2), CAST(N'2019-02-02T16:33:50.2527543' 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'NCP0055', 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'8be037f7-2d1e-4f3d-b773-9bd2f9b39b3a', N'65ba8697-497a-4f36-bd6c-668eba0c5d62', N'Doctor', N'Conbination', 81, 0, N'', N'2a4569a0-70ab-4888-a205-af406c84856d', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2019-01-07T09:32:32.6102162' AS DateTime2), CAST(N'2019-02-03T08:17:35.7629175' AS DateTime2), N'NOTASSIGNED', N'NCR0114', NULL, N'NCDG0084', N'27%', 1993, 0, 0, N'Test', CAST(N'2019-01-07T09:32:31.1570702' 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'8c128346-75da-4dd2-a83d-250b973abd62', N'4c772c03-ef45-492a-82d7-24bd49320ea3', N'Referral', N'UltraSoundCategory_1', 42, 1, N'', N'e456eaf1-93e2-43db-9cd1-8a09a2a66374', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2018-12-03T16:34:17.6262664' AS DateTime2), CAST(N'2018-12-04T10:52:56.4424581' AS DateTime2), N'NOTASSIGNED', N'NCR0027', NULL, N'NCDG0064', N'15%', 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'8c1d0392-4b71-47e2-9bf8-f381f9f89bf0', N'f58ff95f-89e6-4f8e-8868-a83828ebe999', N'Doctor', N'DoctorVisit', 0, 1, N'', N'9e8b5338-6749-43fb-9b9e-fc933f1897b1', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2018-12-18T10:30:54.3701165' AS DateTime2), CAST(N'2018-12-23T10:08:59.5184894' AS DateTime2), N'83281dd4-5998-4b90-bd4f-ad30ae28cfa6', N'NCR0049', 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'8c406deb-a789-4529-8249-dfd669413dad', N'1fc95b60-c117-4163-b73d-37bd64d7fac8', N'Doctor', N'Biochemistry ', 220, 0, N'', N'f33e74fd-da37-47dd-882b-a9663d8f8b7d', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2019-01-14T11:07:21.6120123' AS DateTime2), CAST(N'2019-02-03T08:17:35.7629175' AS DateTime2), N'NOTASSIGNED', N'NCR0114', NULL, N'NCDG0102', N'22%', 2783, 0, 0, N'Test', CAST(N'2019-01-14T11:07:20.0329910' 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'8d2efe55-9e4f-402c-8fe7-1f1a14c5252f', 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:13.6643497' 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'bdeb3267-fbf8-470c-bda6-8443567350ab', 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'8d63b368-5656-4775-8549-8484cce21d43', N'f58ff95f-89e6-4f8e-8868-a83828ebe999', N'Referral', 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'8dd14b58-0b9e-44a3-afaa-0ee863bd4097', N'7b3c0574-a184-4081-9a43-0b8360b4e107', N'Doctor', N'ASSISTANT_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.5014175' 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'8de57d3e-6e17-418e-a2d0-cd6fcc2a90cb', N'5972905b-bc7d-495a-bc9d-4469871316b1', N'Doctor', N'ECG/ECO', -40, 1, N'', N'fcc273a5-90e1-4238-901f-65511300243c', N'd821cd9f-ac10-4f94-92cf-c292cd83b2c0', NULL, CAST(N'2018-09-04T12:02:59.3566667' AS DateTime2), CAST(N'2018-09-04T22:21:52.4400000' 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'8ead5e0c-7e9b-4347-8fa8-fab889eea074', N'f58ff95f-89e6-4f8e-8868-a83828ebe999', N'Doctor', N'UltraSoundCategory_2', 6.8, 1, N'', N'f8a9e4c8-7ab7-49d3-bec9-4abc80951695', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2018-12-06T11:50:04.8007282' AS DateTime2), CAST(N'2018-12-06T12:49:33.7827963' AS DateTime2), N'NOTASSIGNED', N'NCR0038', NULL, N'NCDG0067', N'20%', 61.2, 6.8, 0, N'Test', CAST(N'2018-12-06T11:50:04.4105222' 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'8ead9948-3474-4892-a897-258e9e10e91d', N'2f49ff36-b04f-4081-9261-60ec973da26d', N'Doctor', N'CLINIC_REFERRAL', 1000, 0, N'ClinicInvoice', N'NOTASSIGNED', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2018-12-19T09:21:51.3689633' AS DateTime2), CAST(N'2018-12-22T16:17:56.9948653' AS DateTime2), N'83281dd4-5998-4b90-bd4f-ad30ae28cfa6', NULL, N'NCINV0036', N'NOTASSIGNED', N'1000', NULL, 0, 0, N'ADDED_JUST_FOR_COMMISSION', 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'8ecde9c0-5e10-48b8-8b16-ad30fc8d04a4', N'2f49ff36-b04f-4081-9261-60ec973da26d', N'Referral', 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.6005328' 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'900d3f5f-a315-4e2b-a230-953beb529432', N'2f49ff36-b04f-4081-9261-60ec973da26d', N'Doctor', 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.2328298' AS DateTime2), CAST(N'2018-12-25T16:00:39.1141658' AS DateTime2), N'NOTASSIGNED', N'NCR0090', NULL, N'NCDG0079', N'10%', 823, 0, 0, N'Test', CAST(N'2018-12-25T15:52:20.0618058' AS DateTime2), NULL, 1, N'NCP0008', 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'903d2146-77da-47f9-93c4-85e2d1491bb6', N'7b3c0574-a184-4081-9a43-0b8360b4e107', N'Doctor', N'ASSIGNED_DOCTOR', 0, 1, N'KidneyOP_1', N'fdcd1564-3c7a-40f5-9267-2f82b2c481e3', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2018-12-17T09:42:26.4754330' AS DateTime2), CAST(N'2018-12-20T11:28:03.0130366' AS DateTime2), N'83281dd4-5998-4b90-bd4f-ad30ae28cfa6', N'NCR0054', N'NCINV0036', N'NCINV0036', N'1000', NULL, 0, 0, N'Operation', CAST(N'2018-12-17T08:58:44.1210899' 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'90b189c5-65ec-4638-a256-1843fbafaf2c', N'f58ff95f-89e6-4f8e-8868-a83828ebe999', N'UltraSoundDoctor', N'UltraSoundCategory_2', 200, 1, N'', N'24e4ffc4-6392-4eb1-a842-d19b9ccf6475', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2018-12-03T16:05:49.8524488' AS DateTime2), CAST(N'2018-12-03T16:23:05.5578012' AS DateTime2), N'NOTASSIGNED', N'NCR0017', N'NOTASSIGNED', N'NCDG0063', NULL, 314, 0, 0, N'test', CAST(N'2018-12-03T16:05:49.6665426' AS DateTime2), N'fb7dc01a-a59d-47ce-9403-8a31ca1ce95f', 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'90f60afd-1a5a-4aad-abfb-ed2cec1b076a', N'7aea2b0b-c196-4bd2-b220-d9be9dee7688', N'Doctor', N'Pathology', -85.135135135135144, 1, N'', N'f3e6d38d-8ac1-45df-8b17-e4b6686bcbb1', N'd821cd9f-ac10-4f94-92cf-c292cd83b2c0', NULL, CAST(N'2018-07-25T15:32:20.8400000' AS DateTime2), CAST(N'2018-09-04T22:35:23.0866667' AS DateTime2), N'ff0ebd31-f7bc-498c-b664-2e56792867c1', N'RR0020', N'RINV0040', N'RDG0060', N'0%', 1800, 420, 0, N'Test', CAST(N'2018-07-25T15:23:31.7466667' 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'90f9d708-0bbd-4407-bcae-6b55077d79ff', N'f58ff95f-89e6-4f8e-8868-a83828ebe999', N'UltraSoundDoctor', N'UltraSoundCategory_2', 0, 1, N'', N'e456eaf1-93e2-43db-9cd1-8a09a2a66374', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2018-12-03T16:34:17.5373240' AS DateTime2), CAST(N'2018-12-04T10:52:13.9370276' AS DateTime2), N'NOTASSIGNED', N'NCR0022', N'NOTASSIGNED', N'NCDG0064', NULL, 1004, 0, 0, N'test', CAST(N'2018-12-03T16:34:17.4923501' AS DateTime2), N'c9e62a9b-46f2-4c24-a806-2236c5aa5213', 0, N'NA', N'NA', N'NA')
