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'918a1d98-4dce-42b2-a934-b7227aeb4455', N'f58ff95f-89e6-4f8e-8868-a83828ebe999', N'UltraSoundDoctor', N'UltraSoundCategory_1', 100, 1, N'', N'e456eaf1-93e2-43db-9cd1-8a09a2a66374', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2018-12-03T16:34:17.5872908' AS DateTime2), CAST(N'2018-12-04T10:52:39.6044768' AS DateTime2), N'NOTASSIGNED', N'NCR0025', N'NOTASSIGNED', N'NCDG0064', NULL, 1004, 0, 0, N'test', CAST(N'2018-12-03T16:34:17.4923501' AS DateTime2), N'b69efbdc-935e-4bd3-9090-700ad58de320', 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'92295b44-abba-4b87-bbc2-3706b819411d', N'e3d4a527-b8d6-4e80-8e15-ddd22394a385', N'Doctor', N'Pathology', -60.000000000000007, 1, N'', N'e6c7e2bf-19c9-4451-a118-c34a0c698c23', N'd821cd9f-ac10-4f94-92cf-c292cd83b2c0', NULL, CAST(N'2018-07-21T15:03:58.8333333' AS DateTime2), CAST(N'2018-09-04T22:35:23.0866667' AS DateTime2), N'dd5e3703-3ba2-4cc1-b199-9c5887a08b72', N'RR0013', N'RINV0031', N'RDG0049', N'0%', 1020, 680, 0, N'Test', CAST(N'2018-07-21T14:58:57.5700000' AS DateTime2), NULL, 0, N'NA', N'NA', N'NA')
INSERT [dbo].[Commission] ([Id], [EmployeeId], [EmployeeType], [CommissionType], [Amount], [IsPaid], [Title], [InvoiceId], [HospitalId], [DateTime], [CreatedTime], [UpdatedTime], [MainInvoiceId], [PaymentGroup], [MainInvoiceCode], [InvoiceCode], [PercentOrValue], [InvoiceTotal], [LessAmount], [SpecialAmount], [Category], [InvoiceCreatedTime], [InvoiceDiagnosticTestId], [IsPaidFinally], [PaymentId], [ReceiptCreatedTime], [BarCodeImageUrl]) VALUES (N'92ffef0b-73ac-4e60-a1a9-7b1a2c5765d2', N'cbfa4e4e-2fdf-48c7-9b94-e4712cf1f267', N'Referral', N'Hematology', 80, 1, N'', N'6934d123-a6cb-4a72-9e32-d1bd1440b06d', N'd821cd9f-ac10-4f94-92cf-c292cd83b2c0', NULL, CAST(N'2018-09-04T12:09:12.0300000' AS DateTime2), CAST(N'2018-09-04T22:21:52.4466667' AS DateTime2), N'27b1b1ae-a621-4b4a-a7df-1996f16ca805', N'RR0039', N'RINV0192', N'RDG0211', N'40%', 200, 0, 0, N'Test', CAST(N'2018-09-04T10:46:46.9466667' 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'9308c948-010e-487b-ba9a-3807966f757c', N'4c772c03-ef45-492a-82d7-24bd49320ea3', N'UltraSoundDoctor', N'UltraSoundCategory_2', 0, 1, N'', N'a022cb08-0c98-4969-a31f-1d5d2884fbbb', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2018-12-06T13:43:42.1930571' AS DateTime2), CAST(N'2018-12-06T15:14:32.3400385' AS DateTime2), N'NOTASSIGNED', N'NCR0044', N'NOTASSIGNED', N'NCDG0068', NULL, 68, 0, 0, N'test', CAST(N'2018-12-06T13:43:42.0771626' AS DateTime2), N'b1c06896-6cf8-4eaa-b53a-077f7f29ae95', 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'93103661-3531-4e95-a500-3817763887b9', N'82b04905-0844-420a-9734-ef6ef52771f2', N'Doctor', N'ECG/ECO', 46.666666666666671, 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.0866667' AS DateTime2), N'8c2d43c9-ad67-42a8-8527-2fc86d1cd454', N'RR0008', 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'938722b9-e075-429d-b6a9-10f086ff0403', N'aa1bef3d-ea7c-404a-9d19-2347fcd8fad9', N'Doctor', N'X-Ray ', 180, 1, N'', N'cc6b598c-3380-46d1-a4e2-28dfc45b783e', N'd821cd9f-ac10-4f94-92cf-c292cd83b2c0', NULL, CAST(N'2018-07-23T14:55:31.1466667' AS DateTime2), CAST(N'2018-09-04T22:35:23.0900000' AS DateTime2), N'5610283e-bfdd-4559-813b-66c681d1914a', N'RR0014', 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'93c1ff57-31d7-4b99-8233-8b179b92901a', N'4c772c03-ef45-492a-82d7-24bd49320ea3', N'Doctor', N'CT_2', 366, 0, N'', N'3e34586b-5b04-4755-ae22-5694878a495e', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2019-01-21T15:49:34.8318273' AS DateTime2), CAST(N'2019-02-03T08:17:35.7629175' AS DateTime2), N'NOTASSIGNED', N'NCR0114', NULL, N'NCDG0107', N'10%', 22280, 0, 0, N'Test', CAST(N'2019-01-21T15:49:31.1487126' AS DateTime2), NULL, 1, NULL, N'03-02-2019 8:17 AM', N'data:image/jpeg;base64,[encoded data, 8380 characters]')
INSERT [dbo].[Commission] ([Id], [EmployeeId], [EmployeeType], [CommissionType], [Amount], [IsPaid], [Title], [InvoiceId], [HospitalId], [DateTime], [CreatedTime], [UpdatedTime], [MainInvoiceId], [PaymentGroup], [MainInvoiceCode], [InvoiceCode], [PercentOrValue], [InvoiceTotal], [LessAmount], [SpecialAmount], [Category], [InvoiceCreatedTime], [InvoiceDiagnosticTestId], [IsPaidFinally], [PaymentId], [ReceiptCreatedTime], [BarCodeImageUrl]) VALUES (N'93f87b94-bdba-4e10-b2ce-ae7e1539227a', N'4c772c03-ef45-492a-82d7-24bd49320ea3', N'Referral', N'UltraSoundCategory_1', 5.1, 1, N'', N'f8a9e4c8-7ab7-49d3-bec9-4abc80951695', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2018-12-06T11:50:04.7908156' AS DateTime2), CAST(N'2018-12-06T12:49:33.7984202' AS DateTime2), N'NOTASSIGNED', N'NCR0032', NULL, N'NCDG0067', N'15%', 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'94299b65-c319-417f-a68d-2e2fb5cbc3c7', N'2f49ff36-b04f-4081-9261-60ec973da26d', N'Referral', N'UltraSoundCategory_2', 0, 0, N'', N'fff0cb69-dc61-4081-9b80-ff8f57f6e46f', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2018-11-27T10:51:01.3783450' 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'942c0d73-7f90-4cf8-bd1b-a92c0cad7aa6', N'f58ff95f-89e6-4f8e-8868-a83828ebe999', N'Doctor', N'ASSIGNED_DOCTOR', 10000, 0, N'KidneyOP_1', N'6f15c7a7-bea3-4a8d-8d86-bf13496b80f1', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2018-12-20T13:30:05.3257157' AS DateTime2), CAST(N'2018-12-22T16:17:56.9948653' AS DateTime2), N'ebce39be-4d21-4251-835d-2620dd8fe8aa', NULL, N'NCINV0037', N'NCINV0037', N'10000', NULL, 0, 0, N'Operation', CAST(N'2018-12-20T13:29:01.5391556' AS DateTime2), NULL, 1, N'NA', N'NA', N'NA')
INSERT [dbo].[Commission] ([Id], [EmployeeId], [EmployeeType], [CommissionType], [Amount], [IsPaid], [Title], [InvoiceId], [HospitalId], [DateTime], [CreatedTime], [UpdatedTime], [MainInvoiceId], [PaymentGroup], [MainInvoiceCode], [InvoiceCode], [PercentOrValue], [InvoiceTotal], [LessAmount], [SpecialAmount], [Category], [InvoiceCreatedTime], [InvoiceDiagnosticTestId], [IsPaidFinally], [PaymentId], [ReceiptCreatedTime], [BarCodeImageUrl]) VALUES (N'943fc27b-1100-4e51-846a-ca06e201b536', N'2f49ff36-b04f-4081-9261-60ec973da26d', N'UltraSoundDoctor', N'UltraSoundCategory_1', 0, 0, N'', N'e456eaf1-93e2-43db-9cd1-8a09a2a66374', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2018-12-03T16:34:17.5972851' AS DateTime2), CAST(N'2018-12-22T16:17:56.9948653' AS DateTime2), N'NOTASSIGNED', NULL, N'NOTASSIGNED', N'NCDG0064', NULL, 1004, 0, 0, N'Test', CAST(N'2018-12-03T16:34:17.4923501' AS DateTime2), N'c5850109-14c7-44ca-acde-7b674b5b3fc1', 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'9476aa8c-9a84-43e2-9e2c-b496bc5abbaf', N'aa1bef3d-ea7c-404a-9d19-2347fcd8fad9', N'Doctor', N'ECG/ECO', 100, 1, N'', N'cc6b598c-3380-46d1-a4e2-28dfc45b783e', N'd821cd9f-ac10-4f94-92cf-c292cd83b2c0', NULL, CAST(N'2018-07-23T14:55:31.1333333' AS DateTime2), CAST(N'2018-09-04T22:35:23.0900000' AS DateTime2), N'5610283e-bfdd-4559-813b-66c681d1914a', N'RR0015', 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'94cbb0bb-8c23-4789-a8cc-104393a032e3', N'8d3cf8f9-7ef7-4008-b529-e05a062b3f0c', N'Doctor', N'ASSISTANT_DOCTOR', 100, 0, N'KidneyOP_1', N'fdcd1564-3c7a-40f5-9267-2f82b2c481e3', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2018-12-17T09:42:26.4864266' AS DateTime2), CAST(N'2018-12-22T16:17:56.9948653' AS DateTime2), N'83281dd4-5998-4b90-bd4f-ad30ae28cfa6', NULL, N'NCINV0036', N'NCINV0036', N'100', 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'954eaadb-12bd-4fc2-9aca-82c0a1fae88b', N'4c772c03-ef45-492a-82d7-24bd49320ea3', N'Doctor', N'Biochemistry ', 100, 0, N'', N'15a731c0-16d0-4ab4-a55b-8352a17027fc', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2018-11-19T15:21:13.1036028' 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'958a15e8-f516-4927-99b5-40f1a67440ff', N'4c772c03-ef45-492a-82d7-24bd49320ea3', N'Doctor', N'Ultrasound', 70, 0, N'', N'8be24963-914e-473d-b269-d80182e42daf', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2018-11-25T08:59:06.4380852' AS DateTime2), CAST(N'2018-12-22T16:17:56.9948653' AS DateTime2), N'NOTASSIGNED', NULL, NULL, N'NCDG0054', N'10%', 4699.8, 522.2, 0, N'Test', CAST(N'2018-11-25T08:59:05.7217518' AS DateTime2), NULL, 1, N'NA', N'NA', N'NA')
INSERT [dbo].[Commission] ([Id], [EmployeeId], [EmployeeType], [CommissionType], [Amount], [IsPaid], [Title], [InvoiceId], [HospitalId], [DateTime], [CreatedTime], [UpdatedTime], [MainInvoiceId], [PaymentGroup], [MainInvoiceCode], [InvoiceCode], [PercentOrValue], [InvoiceTotal], [LessAmount], [SpecialAmount], [Category], [InvoiceCreatedTime], [InvoiceDiagnosticTestId], [IsPaidFinally], [PaymentId], [ReceiptCreatedTime], [BarCodeImageUrl]) VALUES (N'958a34d1-de63-489c-b267-0e7e1ce29f0f', N'4c772c03-ef45-492a-82d7-24bd49320ea3', N'Referral', N'CT_2', 4.4, 0, N'', N'ddd8d663-8ec8-4094-874b-42caf6053c00', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2019-01-06T13:25:46.8269966' AS DateTime2), CAST(N'2019-02-03T08:17:35.7629175' AS DateTime2), N'NOTASSIGNED', N'NCR0114', NULL, N'NCDG0083', N'10%', 3558, 0, 0, N'Test', CAST(N'2019-01-06T10:10:33.9540561' AS DateTime2), NULL, 1, NULL, N'03-02-2019 8:17 AM', N'data:image/jpeg;base64,[encoded data, 8380 characters]')
INSERT [dbo].[Commission] ([Id], [EmployeeId], [EmployeeType], [CommissionType], [Amount], [IsPaid], [Title], [InvoiceId], [HospitalId], [DateTime], [CreatedTime], [UpdatedTime], [MainInvoiceId], [PaymentGroup], [MainInvoiceCode], [InvoiceCode], [PercentOrValue], [InvoiceTotal], [LessAmount], [SpecialAmount], [Category], [InvoiceCreatedTime], [InvoiceDiagnosticTestId], [IsPaidFinally], [PaymentId], [ReceiptCreatedTime], [BarCodeImageUrl]) VALUES (N'9590aa21-ddb0-41c8-bc3f-a02a037fa53f', N'3e6c7598-b4d4-453d-97fa-1de3da9ac873', N'Doctor', N'Ultrasound', 0, 1, N'', N'192168f2-5f03-4d9d-a6e2-b5d846984dd6', N'd821cd9f-ac10-4f94-92cf-c292cd83b2c0', NULL, CAST(N'2018-07-29T13:41:46.9766667' AS DateTime2), CAST(N'2018-09-04T22:35:23.0900000' AS DateTime2), N'1f6d0654-58e3-4932-a7cc-93707fdbcafd', N'RR0032', N'RINV0058', N'RDG0078', N'0%', 1400, 0, 0, N'Test', CAST(N'2018-07-29T13:39:51.4466667' AS DateTime2), NULL, 0, N'NA', N'NA', N'NA')
INSERT [dbo].[Commission] ([Id], [EmployeeId], [EmployeeType], [CommissionType], [Amount], [IsPaid], [Title], [InvoiceId], [HospitalId], [DateTime], [CreatedTime], [UpdatedTime], [MainInvoiceId], [PaymentGroup], [MainInvoiceCode], [InvoiceCode], [PercentOrValue], [InvoiceTotal], [LessAmount], [SpecialAmount], [Category], [InvoiceCreatedTime], [InvoiceDiagnosticTestId], [IsPaidFinally], [PaymentId], [ReceiptCreatedTime], [BarCodeImageUrl]) VALUES (N'95dbf1cb-ebec-4092-9c9b-2939fb05e9af', N'7a432ef3-78e3-4091-811b-11fc802fb981', N'Doctor', N'Ultrasound', 66.666666666666629, 1, N'', N'4469621b-8a3f-4ae6-9e23-a0a15e6b3414', N'd821cd9f-ac10-4f94-92cf-c292cd83b2c0', NULL, CAST(N'2018-07-15T10:00:46.6600000' AS DateTime2), CAST(N'2018-09-04T22:21:52.4500000' AS DateTime2), N'a09d1933-a42e-4b01-8f2f-08ffd0109967', N'RR0042', N'RINV0009', N'RDG0025', N'40%', 2300, 1150, 0, N'Test', CAST(N'2018-07-15T09:44:02.3366667' 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'95e131e4-bad5-437c-a7dc-a9133e57c9d7', N'1fc95b60-c117-4163-b73d-37bd64d7fac8', N'Doctor', N'Conbination', 162, 0, N'', N'39b40131-dd02-494a-9c09-93ae96288084', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2019-01-13T13:32:39.2334065' AS DateTime2), CAST(N'2019-02-03T08:17:35.7629175' AS DateTime2), N'NOTASSIGNED', N'NCR0114', NULL, N'NCDG0099', N'12%', 3469.6, 274.4, 0, N'Test', CAST(N'2019-01-13T13:32:39.0868620' 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'971b916b-a7df-4a41-90ec-7e66700a426f', N'4c772c03-ef45-492a-82d7-24bd49320ea3', N'Doctor', N'ANESTHESIA_DOCTOR', 10000, 1, N'KidneyOP_1', N'3d4646d1-0c53-413f-9e23-9783787d8522', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2018-12-26T12:45:43.9156346' AS DateTime2), CAST(N'2018-12-27T12:05:15.6569742' AS DateTime2), N'0c6f2449-2e4f-489d-8372-860af4eabf75', NULL, N'NCINV0041', N'NCINV0041', N'2000', NULL, 0, 0, N'Operation', CAST(N'2018-12-26T12:45:35.8356009' AS DateTime2), NULL, 0, N'NCP0030', NULL, N'NA')
INSERT [dbo].[Commission] ([Id], [EmployeeId], [EmployeeType], [CommissionType], [Amount], [IsPaid], [Title], [InvoiceId], [HospitalId], [DateTime], [CreatedTime], [UpdatedTime], [MainInvoiceId], [PaymentGroup], [MainInvoiceCode], [InvoiceCode], [PercentOrValue], [InvoiceTotal], [LessAmount], [SpecialAmount], [Category], [InvoiceCreatedTime], [InvoiceDiagnosticTestId], [IsPaidFinally], [PaymentId], [ReceiptCreatedTime], [BarCodeImageUrl]) VALUES (N'97813f31-09a0-456c-8391-cbbb74991e87', N'6ee087eb-7031-408f-b4ea-f567d250f75b', N'Referral', N'CombineCategory_1', 33.21, 0, N'', N'd8f7316a-aa7f-478e-83c8-4e5f01b66a0e', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2019-01-29T16:08:58.1021998' AS DateTime2), CAST(N'2019-02-03T08:17:35.7629175' AS DateTime2), N'NOTASSIGNED', N'NCR0114', NULL, N'NCDG0111', N'27%', 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'97e74bf2-d98f-41d4-9d4c-9748229503ab', N'4c772c03-ef45-492a-82d7-24bd49320ea3', N'Doctor', N'Biochemistry ', 75, 1, N'', N'4561a3e0-d340-4da7-8094-1a2b3288fa16', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2019-02-02T10:06:56.6044076' AS DateTime2), CAST(N'2019-02-02T16:40:29.5695365' AS DateTime2), N'NOTASSIGNED', NULL, NULL, N'NCDG0114', N'10%', 917, 0, 0, N'Test', CAST(N'2019-02-02T10:06:56.3895443' AS DateTime2), NULL, 0, N'NCP0060', 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'98ca950f-7383-406c-8462-712c98f6ca63', N'4c772c03-ef45-492a-82d7-24bd49320ea3', N'Referral', N'CombineCategory_1', 56.7, 0, N'', N'ddd8d663-8ec8-4094-874b-42caf6053c00', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2019-01-06T13:25:46.8355755' AS DateTime2), CAST(N'2019-02-03T08:17:35.7629175' AS DateTime2), N'NOTASSIGNED', N'NCR0114', NULL, N'NCDG0083', N'10%', 3558, 0, 0, N'Test', CAST(N'2019-01-06T10:10:33.9540561' AS DateTime2), NULL, 1, NULL, N'03-02-2019 8:17 AM', N'data:image/jpeg;base64,[encoded data, 8380 characters]')
INSERT [dbo].[Commission] ([Id], [EmployeeId], [EmployeeType], [CommissionType], [Amount], [IsPaid], [Title], [InvoiceId], [HospitalId], [DateTime], [CreatedTime], [UpdatedTime], [MainInvoiceId], [PaymentGroup], [MainInvoiceCode], [InvoiceCode], [PercentOrValue], [InvoiceTotal], [LessAmount], [SpecialAmount], [Category], [InvoiceCreatedTime], [InvoiceDiagnosticTestId], [IsPaidFinally], [PaymentId], [ReceiptCreatedTime], [BarCodeImageUrl]) VALUES (N'99002136-5c6c-4a50-b27d-431591f24a6c', N'410f20e6-ad68-450b-9cf3-55da4793042c', N'Doctor', N'ASSISTANT_DOCTOR', 111, 0, N'LungsOP_1', N'c8249365-2881-4525-849a-00a05376e928', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2018-12-20T13:32:39.6468788' AS DateTime2), CAST(N'2018-12-22T16:17:56.9948653' AS DateTime2), N'9c0c25c5-11fc-4a52-a928-6cfebda17d20', NULL, N'NCINV0038', N'NCINV0038', N'111', 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'995cd50c-ec8f-4a5c-81bf-c67ed2caf6ed', N'7aea2b0b-c196-4bd2-b220-d9be9dee7688', N'Doctor', N'Ultrasound', -313.04347826086956, 1, N'', N'62d767ec-8bd8-4515-8ae8-7ed535ddcc82', N'd821cd9f-ac10-4f94-92cf-c292cd83b2c0', NULL, CAST(N'2018-07-25T17:14:58.8100000' AS DateTime2), CAST(N'2018-09-04T22:35:23.0900000' AS DateTime2), N'de745a7c-c5b9-467e-8a74-1a979fe92952', N'RR0033', N'RINV0039', N'RDG0059', N'0%', 700, 450, 0, N'Test', CAST(N'2018-07-25T14:49:38.0500000' 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'99c8af2e-4f50-4def-8942-b6b9329ebb94', N'410f20e6-ad68-450b-9cf3-55da4793042c', N'Referral', N'Conbination', 87, 0, N'', N'2a4569a0-70ab-4888-a205-af406c84856d', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2019-01-07T09:32:32.6258405' AS DateTime2), CAST(N'2019-02-03T08:17:35.7629175' AS DateTime2), N'NOTASSIGNED', N'NCR0114', NULL, N'NCDG0084', N'29%', 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'99ce31a1-fd47-47fc-98e6-587c43a461fb', N'f58ff95f-89e6-4f8e-8868-a83828ebe999', N'Doctor', N'CLINIC_REFERRAL', 10000, 1, N'ClinicInvoice', N'8336a95e-c2dd-452e-8325-f774b20637dd', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2018-12-26T08:10:05.6229213' AS DateTime2), CAST(N'2018-12-27T12:05:15.6869987' AS DateTime2), N'0c6f2449-2e4f-489d-8372-860af4eabf75', N'NCR0093', N'NCINV0041', N'NOTASSIGNED', N'10000', NULL, 0, 0, N'OPERATION', CAST(N'2018-12-26T08:03:39.7660177' AS DateTime2), NULL, 1, N'NCP0022', N'26-Dec-18 11:45 AM', 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'9a09a405-641c-43c5-afc6-1701b8e343be', N'cbfa4e4e-2fdf-48c7-9b94-e4712cf1f267', N'Referral', N'Hematology', -600, 1, N'', N'0a3797d0-4678-4d57-a1e7-0a1fbfd2403f', N'd821cd9f-ac10-4f94-92cf-c292cd83b2c0', NULL, CAST(N'2018-09-04T12:36:33.0700000' AS DateTime2), CAST(N'2018-09-04T22:21:52.4500000' AS DateTime2), N'bb6797bb-6fd2-464b-8880-539b58f95590', N'RR0051', N'RINV0175', N'RDG0191', N'0%', 0, 2050, 0, N'Test', CAST(N'2018-09-01T10:15:48.6966667' AS DateTime2), NULL, 0, N'NA', N'NA', N'NA')
INSERT [dbo].[Commission] ([Id], [EmployeeId], [EmployeeType], [CommissionType], [Amount], [IsPaid], [Title], [InvoiceId], [HospitalId], [DateTime], [CreatedTime], [UpdatedTime], [MainInvoiceId], [PaymentGroup], [MainInvoiceCode], [InvoiceCode], [PercentOrValue], [InvoiceTotal], [LessAmount], [SpecialAmount], [Category], [InvoiceCreatedTime], [InvoiceDiagnosticTestId], [IsPaidFinally], [PaymentId], [ReceiptCreatedTime], [BarCodeImageUrl]) VALUES (N'9a917be0-6e31-4361-b246-9bbc29ca1e23', N'cbf3c979-dbe4-47e7-85c5-1519eae5a5f9', N'Referral', N'CombineCategory_1', 12.3, 0, N'', N'1d7e9ea2-f7ae-418b-a43d-762f94e11b7c', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2019-01-05T15:22:03.4488386' AS DateTime2), CAST(N'2019-02-03T08:17:35.7629175' AS DateTime2), N'NOTASSIGNED', N'NCR0114', NULL, N'NCDG0082', N'10%', 873, 0, 0, N'Test', CAST(N'2019-01-05T15:22:02.7041591' AS DateTime2), NULL, 1, NULL, N'03-02-2019 8:17 AM', N'data:image/jpeg;base64,[encoded data, 8380 characters]')
INSERT [dbo].[Commission] ([Id], [EmployeeId], [EmployeeType], [CommissionType], [Amount], [IsPaid], [Title], [InvoiceId], [HospitalId], [DateTime], [CreatedTime], [UpdatedTime], [MainInvoiceId], [PaymentGroup], [MainInvoiceCode], [InvoiceCode], [PercentOrValue], [InvoiceTotal], [LessAmount], [SpecialAmount], [Category], [InvoiceCreatedTime], [InvoiceDiagnosticTestId], [IsPaidFinally], [PaymentId], [ReceiptCreatedTime], [BarCodeImageUrl]) VALUES (N'9b14541a-3a32-463d-a589-4e73fc73472f', 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.3808102' 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'318a68da-af7c-44a3-8a0e-0a8055d30390', 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'9b51623f-af42-46b4-ad3e-debc42afdcf4', N'4c772c03-ef45-492a-82d7-24bd49320ea3', N'Doctor', N'CombineCategory_1', 16.7, 0, N'', N'8be24963-914e-473d-b269-d80182e42daf', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2018-11-25T08:59:06.3912118' AS DateTime2), CAST(N'2018-12-22T16:17:56.9948653' AS DateTime2), N'NOTASSIGNED', NULL, NULL, N'NCDG0054', N'10%', 4699.8, 522.2, 0, N'Test', CAST(N'2018-11-25T08:59:05.7217518' AS DateTime2), NULL, 1, N'NA', N'NA', N'NA')
INSERT [dbo].[Commission] ([Id], [EmployeeId], [EmployeeType], [CommissionType], [Amount], [IsPaid], [Title], [InvoiceId], [HospitalId], [DateTime], [CreatedTime], [UpdatedTime], [MainInvoiceId], [PaymentGroup], [MainInvoiceCode], [InvoiceCode], [PercentOrValue], [InvoiceTotal], [LessAmount], [SpecialAmount], [Category], [InvoiceCreatedTime], [InvoiceDiagnosticTestId], [IsPaidFinally], [PaymentId], [ReceiptCreatedTime], [BarCodeImageUrl]) VALUES (N'9bcd628c-b25e-4a9c-a7d0-5ae7d1f1210c', N'410f20e6-ad68-450b-9cf3-55da4793042c', N'Doctor', N'DoctorVisit', 999, 1, N'', N'NOTASSIGNED', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2018-12-19T11:06:39.5546238' AS DateTime2), CAST(N'2018-12-20T11:28:03.0650040' AS DateTime2), N'83281dd4-5998-4b90-bd4f-ad30ae28cfa6', N'NCR0051', N'NCINV0036', N'NOTASSIGNED', NULL, NULL, 0, 0, N'ADDED_JUST_FOR_COMMISSION', CAST(N'0001-01-01T00:00:00.0000000' AS DateTime2), NULL, 0, N'NA', N'NA', N'NA')
INSERT [dbo].[Commission] ([Id], [EmployeeId], [EmployeeType], [CommissionType], [Amount], [IsPaid], [Title], [InvoiceId], [HospitalId], [DateTime], [CreatedTime], [UpdatedTime], [MainInvoiceId], [PaymentGroup], [MainInvoiceCode], [InvoiceCode], [PercentOrValue], [InvoiceTotal], [LessAmount], [SpecialAmount], [Category], [InvoiceCreatedTime], [InvoiceDiagnosticTestId], [IsPaidFinally], [PaymentId], [ReceiptCreatedTime], [BarCodeImageUrl]) VALUES (N'9cc4b16c-871d-48ef-82e4-d15a261b6f33', N'4c772c03-ef45-492a-82d7-24bd49320ea3', N'Doctor', N'ASSISTANT_SURGEON', 1000, 1, N'KidneyOP_1', N'a60a883f-6e3b-4f24-85c5-64cca05579d3', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2018-12-26T08:11:03.7300676' AS DateTime2), CAST(N'2018-12-27T12:05:15.6767843' AS DateTime2), N'0c6f2449-2e4f-489d-8372-860af4eabf75', N'NCR0095', N'NCINV0041', N'NCINV0041', N'2000', NULL, 0, 0, N'Operation', CAST(N'2018-12-26T08:09:45.3326896' AS DateTime2), NULL, 1, N'NCP0015', N'26-Dec-18 11:58 AM', 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'9cfa4e43-0e95-4a85-a442-83d44621ea47', N'45c6d504-e6fb-4da1-9454-92195a3dba94', N'Doctor', N'Pathology', -54.545454545454547, 1, N'', N'3a2adaca-9159-4647-bc0b-18d813f92306', N'd821cd9f-ac10-4f94-92cf-c292cd83b2c0', NULL, CAST(N'2018-07-20T11:42:34.6233333' AS DateTime2), CAST(N'2018-09-04T22:21:52.4500000' AS DateTime2), N'c050d739-2984-4f79-9086-fc357b41c392', N'RR0040', N'RINV0025', N'RDG0043', N'0%', 800, 300, 0, N'Test', CAST(N'2018-07-20T11:38:08.2800000' 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'9e6b2b02-756e-4319-8a5f-ef27070b8c47', N'8d3cf8f9-7ef7-4008-b529-e05a062b3f0c', N'Referral', N'UltraSoundCategory_2', 23.2, 1, N'', N'eb7be4be-6bd1-45ba-9031-6297b013383c', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2019-02-03T11:14:29.3616541' AS DateTime2), CAST(N'2019-02-03T11:15:12.9411262' AS DateTime2), N'NOTASSIGNED', N'NCR0117', NULL, N'NCDG0116', N'10%', 1105, 0, 0, N'Test', CAST(N'2019-02-03T09:56:48.9540657' AS DateTime2), NULL, 1, N'NCP0066', N'03-02-2019 11:15 AM', N'data:image/jpeg;base64,[encoded data, 8320 characters]')
INSERT [dbo].[Commission] ([Id], [EmployeeId], [EmployeeType], [CommissionType], [Amount], [IsPaid], [Title], [InvoiceId], [HospitalId], [DateTime], [CreatedTime], [UpdatedTime], [MainInvoiceId], [PaymentGroup], [MainInvoiceCode], [InvoiceCode], [PercentOrValue], [InvoiceTotal], [LessAmount], [SpecialAmount], [Category], [InvoiceCreatedTime], [InvoiceDiagnosticTestId], [IsPaidFinally], [PaymentId], [ReceiptCreatedTime], [BarCodeImageUrl]) VALUES (N'9e6f3685-d616-40ec-abb7-1e5fd8aa4914', N'f58ff95f-89e6-4f8e-8868-a83828ebe999', N'Doctor', 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.3712896' 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'9e712bc8-db08-40b4-9f1f-64c12b0c247c', N'4c772c03-ef45-492a-82d7-24bd49320ea3', N'Referral', 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.1871209' 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'9e92fc52-b15a-4bf3-ae74-eff0a58281fd', N'2f49ff36-b04f-4081-9261-60ec973da26d', N'Doctor', N'SPECIAL_SURGEON', 10000, 0, N'KidneyOP_1', N'6f15c7a7-bea3-4a8d-8d86-bf13496b80f1', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2018-12-20T13:30:05.3557501' AS DateTime2), CAST(N'2018-12-22T16:17:56.9948653' AS DateTime2), N'ebce39be-4d21-4251-835d-2620dd8fe8aa', NULL, N'NCINV0037', N'NCINV0037', N'10000', NULL, 0, 0, N'Operation', CAST(N'2018-12-20T13:29:01.5391556' AS DateTime2), NULL, 1, N'NA', N'NA', N'NA')
INSERT [dbo].[Commission] ([Id], [EmployeeId], [EmployeeType], [CommissionType], [Amount], [IsPaid], [Title], [InvoiceId], [HospitalId], [DateTime], [CreatedTime], [UpdatedTime], [MainInvoiceId], [PaymentGroup], [MainInvoiceCode], [InvoiceCode], [PercentOrValue], [InvoiceTotal], [LessAmount], [SpecialAmount], [Category], [InvoiceCreatedTime], [InvoiceDiagnosticTestId], [IsPaidFinally], [PaymentId], [ReceiptCreatedTime], [BarCodeImageUrl]) VALUES (N'9ea92ec6-6b3a-47dc-baac-24b5de98bbac', 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.0000000' AS DateTime2), CAST(N'2018-09-04T22:35:23.4033333' AS DateTime2), N'6c056c80-8225-4edb-a07a-69ca4db0296a', N'RR0032', N'RINV0026', N'RDG0044', N'0%', 800, 0, 0, N'Test', CAST(N'2018-07-20T12:22:06.0000000' AS DateTime2), NULL, 0, N'NA', N'NA', N'NA')
INSERT [dbo].[Commission] ([Id], [EmployeeId], [EmployeeType], [CommissionType], [Amount], [IsPaid], [Title], [InvoiceId], [HospitalId], [DateTime], [CreatedTime], [UpdatedTime], [MainInvoiceId], [PaymentGroup], [MainInvoiceCode], [InvoiceCode], [PercentOrValue], [InvoiceTotal], [LessAmount], [SpecialAmount], [Category], [InvoiceCreatedTime], [InvoiceDiagnosticTestId], [IsPaidFinally], [PaymentId], [ReceiptCreatedTime], [BarCodeImageUrl]) VALUES (N'9ebe6e9c-339a-4e4d-ba32-441008790995', N'8d3cf8f9-7ef7-4008-b529-e05a062b3f0c', N'Doctor', N'ASSISTANT_SURGEON', 2220, 0, N'KidneyOP_1', N'1d164d48-5760-4f63-9083-066b657fa554', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2019-01-16T11:39:05.4400381' AS DateTime2), CAST(N'2019-02-03T08:17:35.7629175' AS DateTime2), N'382d7597-0685-443c-b918-7aab224db486', N'NCR0114', N'NCINV0048', N'NCINV0048', N'2220', NULL, 0, 0, N'Operation', CAST(N'2019-01-16T11:39:05.0952503' AS DateTime2), NULL, 1, NULL, N'03-02-2019 8:17 AM', N'data:image/jpeg;base64,[encoded data, 8380 characters]')
INSERT [dbo].[Commission] ([Id], [EmployeeId], [EmployeeType], [CommissionType], [Amount], [IsPaid], [Title], [InvoiceId], [HospitalId], [DateTime], [CreatedTime], [UpdatedTime], [MainInvoiceId], [PaymentGroup], [MainInvoiceCode], [InvoiceCode], [PercentOrValue], [InvoiceTotal], [LessAmount], [SpecialAmount], [Category], [InvoiceCreatedTime], [InvoiceDiagnosticTestId], [IsPaidFinally], [PaymentId], [ReceiptCreatedTime], [BarCodeImageUrl]) VALUES (N'9f2b2bc8-5396-46b5-92cb-441ac8685f28', N'2f49ff36-b04f-4081-9261-60ec973da26d', N'Doctor', N'CLINIC_REFERRAL', 123, 0, N'ClinicInvoice', N'NOTASSIGNED', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2018-12-20T16:02:02.0504688' AS DateTime2), CAST(N'2018-12-22T16:17:56.9948653' AS DateTime2), N'9c0c25c5-11fc-4a52-a928-6cfebda17d20', NULL, N'NCINV0038', N'NOTASSIGNED', N'123', 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'a00f73a9-0e8d-430b-a861-794ef63a0439', 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.4515944' 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'e3abf0dc-e58b-4180-a014-a587b340b8a7', 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'a04f64ce-4f8e-41bd-acdc-b0ec365eb6ba', N'cbfa4e4e-2fdf-48c7-9b94-e4712cf1f267', N'Referral', N'ECG/ECO', -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:21:52.4533333' 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'a05755f0-2015-4887-9ed1-a529ea1fbb98', N'35471cdd-86e8-4eb1-8532-e96a2ba5ea2f', N'Referral', N'X-Ray ', 40, 1, N'', N'78375895-ab72-4a5c-b4a1-3153afdf3fca', N'd821cd9f-ac10-4f94-92cf-c292cd83b2c0', NULL, CAST(N'2018-08-03T15:10:57.5966667' AS DateTime2), CAST(N'2018-09-04T22:21:52.4533333' 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'a08388b7-525e-4e96-887f-54c76db1180a', N'1fc95b60-c117-4163-b73d-37bd64d7fac8', N'Doctor', N'CombineCategory_1', 12.3, 0, N'', N'1d7e9ea2-f7ae-418b-a43d-762f94e11b7c', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2019-01-05T15:22:03.4357530' AS DateTime2), CAST(N'2019-02-03T08:17:35.7629175' AS DateTime2), N'NOTASSIGNED', N'NCR0114', NULL, N'NCDG0082', N'10%', 873, 0, 0, N'Test', CAST(N'2019-01-05T15:22:02.7041591' AS DateTime2), NULL, 1, NULL, N'03-02-2019 8:17 AM', N'data:image/jpeg;base64,[encoded data, 8380 characters]')
INSERT [dbo].[Commission] ([Id], [EmployeeId], [EmployeeType], [CommissionType], [Amount], [IsPaid], [Title], [InvoiceId], [HospitalId], [DateTime], [CreatedTime], [UpdatedTime], [MainInvoiceId], [PaymentGroup], [MainInvoiceCode], [InvoiceCode], [PercentOrValue], [InvoiceTotal], [LessAmount], [SpecialAmount], [Category], [InvoiceCreatedTime], [InvoiceDiagnosticTestId], [IsPaidFinally], [PaymentId], [ReceiptCreatedTime], [BarCodeImageUrl]) VALUES (N'a0e43d76-51c3-41c3-824b-6e480185a120', N'1fc95b60-c117-4163-b73d-37bd64d7fac8', N'Doctor', N'Serology ', 110, 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'a11b4a95-1abc-4afe-a0e1-6bd0f4531f91', N'2f49ff36-b04f-4081-9261-60ec973da26d', N'Doctor', N'Serology ', 30, 0, N'', N'703d5936-69a5-45c0-a69e-1b32c6fcd0f7', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2019-01-07T11:10:20.4625840' AS DateTime2), CAST(N'2019-02-03T08:17:35.7629175' AS DateTime2), N'NOTASSIGNED', N'NCR0114', NULL, N'NCDG0085', N'10%', 1357, 0, 0, N'Test', CAST(N'2019-01-07T10:38:42.9472130' AS DateTime2), NULL, 1, NULL, N'03-02-2019 8:17 AM', N'data:image/jpeg;base64,[encoded data, 8380 characters]')
INSERT [dbo].[Commission] ([Id], [EmployeeId], [EmployeeType], [CommissionType], [Amount], [IsPaid], [Title], [InvoiceId], [HospitalId], [DateTime], [CreatedTime], [UpdatedTime], [MainInvoiceId], [PaymentGroup], [MainInvoiceCode], [InvoiceCode], [PercentOrValue], [InvoiceTotal], [LessAmount], [SpecialAmount], [Category], [InvoiceCreatedTime], [InvoiceDiagnosticTestId], [IsPaidFinally], [PaymentId], [ReceiptCreatedTime], [BarCodeImageUrl]) VALUES (N'a153b4af-5308-477b-9193-b8fe5c9aa3d5', N'7b3c0574-a184-4081-9a43-0b8360b4e107', N'Doctor', N'ASSISTANT_SURGEON', 1000, 1, N'LungsOP_1', N'c8249365-2881-4525-849a-00a05376e928', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2018-12-20T13:32:39.6488802' AS DateTime2), CAST(N'2018-12-20T13:55:39.2583554' AS DateTime2), N'9c0c25c5-11fc-4a52-a928-6cfebda17d20', N'NCR0064', N'NCINV0038', N'NCINV0038', N'1110', NULL, 0, 0, N'Operation', CAST(N'2018-12-20T13:32:05.5291427' 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'a1891fcb-5038-4d6a-9d1c-cf0c601a33a7', N'8d3cf8f9-7ef7-4008-b529-e05a062b3f0c', N'Doctor', N'Biochemistry', 55, 0, N'', N'db7cc987-1cd1-43f1-b548-dc824f9cb7d5', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2019-02-16T09:07:58.7001583' AS DateTime2), CAST(N'2019-02-16T13:33:40.8008338' 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)
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'a1a23d4e-2594-4320-99ad-cc7cbb403f07', 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:14.5868177' 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'84e18f30-2ab3-4a0a-abc1-8981ab0df18b', 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'a27a40f0-6245-4f65-93f3-4dd0478f11fa', N'8d3cf8f9-7ef7-4008-b529-e05a062b3f0c', N'Doctor', N'Anesthesia', 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.2650906' 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'a2ee4156-186b-423e-a740-6d1d79fb5cfc', N'f58ff95f-89e6-4f8e-8868-a83828ebe999', N'Doctor', N'UltraSoundCategory_2', 122.2, 0, N'', N'c5e84ccb-38d8-4ca4-a224-92ea42e0f4c5', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2019-02-02T16:48:58.7300650' AS DateTime2), CAST(N'2019-02-03T08:44:45.7086231' AS DateTime2), N'NOTASSIGNED', N'NCR0114', NULL, N'NCDG0115', N'20%', 1234, 0, 0, N'Test', CAST(N'2019-02-02T16:42:10.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'a3180a29-fd9f-406f-b8fa-d5a546a2bdeb', N'e3d4a527-b8d6-4e80-8e15-ddd22394a385', N'Doctor', N'Pathology', -80, 1, N'', N'e6c7e2bf-19c9-4451-a118-c34a0c698c23', N'd821cd9f-ac10-4f94-92cf-c292cd83b2c0', NULL, CAST(N'2018-07-21T15:03:58.8033333' AS DateTime2), CAST(N'2018-09-04T22:35:23.4033333' AS DateTime2), N'dd5e3703-3ba2-4cc1-b199-9c5887a08b72', N'RR0038', N'RINV0031', N'RDG0049', N'0%', 1020, 680, 0, N'Test', CAST(N'2018-07-21T14:58:57.5700000' AS DateTime2), NULL, 0, N'NA', N'NA', N'NA')
INSERT [dbo].[Commission] ([Id], [EmployeeId], [EmployeeType], [CommissionType], [Amount], [IsPaid], [Title], [InvoiceId], [HospitalId], [DateTime], [CreatedTime], [UpdatedTime], [MainInvoiceId], [PaymentGroup], [MainInvoiceCode], [InvoiceCode], [PercentOrValue], [InvoiceTotal], [LessAmount], [SpecialAmount], [Category], [InvoiceCreatedTime], [InvoiceDiagnosticTestId], [IsPaidFinally], [PaymentId], [ReceiptCreatedTime], [BarCodeImageUrl]) VALUES (N'a3578780-01e0-4941-99ab-191e0d8ba6b3', N'f58ff95f-89e6-4f8e-8868-a83828ebe999', N'UltraSoundDoctor', N'UltraSoundCategory_2', 0, 0, N'', N'3e34586b-5b04-4755-ae22-5694878a495e', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2019-01-21T15:49:34.2728768' 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'61f79bc3-36fe-4147-af60-02f4df63c9df', 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'a3a2226e-4391-4d91-9021-23afc74467e0', N'8d3cf8f9-7ef7-4008-b529-e05a062b3f0c', N'Doctor', N'ASSISTANT_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.4974210' AS DateTime2), CAST(N'2018-12-20T11:28:03.0230297' AS DateTime2), N'83281dd4-5998-4b90-bd4f-ad30ae28cfa6', N'NCR0047', N'NCINV0036', N'NCINV0036', N'100', 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'a3f74598-7cc0-43a8-aa30-46c52fa24c4c', N'7b3c0574-a184-4081-9a43-0b8360b4e107', N'Doctor', N'CLINIC_REFERRAL', 123, 0, N'ClinicInvoice', N'NOTASSIGNED', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2019-02-14T16:06:19.1275746' AS DateTime2), CAST(N'2019-02-14T16:06:19.1275746' AS DateTime2), N'07742b8f-093a-447d-8a17-76b7b75f04f4', NULL, NULL, N'NOTASSIGNED', N'123', NULL, 0, 0, N'ADDED_JUST_FOR_COMMISSION', CAST(N'0001-01-01T00:00:00.0000000' 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'a50d30bd-b46c-4fdb-9c99-e15f338d185a', N'2f49ff36-b04f-4081-9261-60ec973da26d', N'Referral', N'Biochemistry ', 50, 1, N'', N'3eddb765-d8ed-44bb-ad8a-2effd21d9b58', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2018-12-23T11:14:13.7564967' AS DateTime2), CAST(N'2018-12-23T11:19:05.8443003' 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'a52169e5-33b5-4371-8095-0d61215ec843', N'7aea2b0b-c196-4bd2-b220-d9be9dee7688', N'Doctor', N'Ultrasound', -200, 1, N'', N'de39d9cb-7a81-49c8-bc2e-417e65508956', N'd821cd9f-ac10-4f94-92cf-c292cd83b2c0', NULL, CAST(N'2018-07-23T13:16:36.3966667' AS DateTime2), CAST(N'2018-09-04T22:35:23.4066667' AS DateTime2), N'71f9202e-55ef-4e15-98a6-93e726f7cc9b', N'RR0034', N'RINV0032', N'RDG0051', N'0%', 400, 200, 0, N'Test', CAST(N'2018-07-23T13:14:09.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'a5d2ac64-8dcb-4dca-86ee-18749747a1fb', N'8d3cf8f9-7ef7-4008-b529-e05a062b3f0c', N'Doctor', N'Conbination', 44, 0, N'', N'9b1d0359-6b2c-4b7a-8e6f-121aed43f2b7', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2019-01-14T10:55:45.3360974' AS DateTime2), CAST(N'2019-02-03T08:17:35.7629175' AS DateTime2), N'NOTASSIGNED', N'NCR0114', NULL, N'NCDG0100', N'22%', 450, 0, 0, N'Test', CAST(N'2019-01-14T09:33:09.7393970' AS DateTime2), NULL, 1, NULL, N'03-02-2019 8:17 AM', N'data:image/jpeg;base64,[encoded data, 8380 characters]')
INSERT [dbo].[Commission] ([Id], [EmployeeId], [EmployeeType], [CommissionType], [Amount], [IsPaid], [Title], [InvoiceId], [HospitalId], [DateTime], [CreatedTime], [UpdatedTime], [MainInvoiceId], [PaymentGroup], [MainInvoiceCode], [InvoiceCode], [PercentOrValue], [InvoiceTotal], [LessAmount], [SpecialAmount], [Category], [InvoiceCreatedTime], [InvoiceDiagnosticTestId], [IsPaidFinally], [PaymentId], [ReceiptCreatedTime], [BarCodeImageUrl]) VALUES (N'a72420f8-0fbe-4647-88a9-80378999ac19', N'4c772c03-ef45-492a-82d7-24bd49320ea3', N'Referral', N'Biochemistry ', 75, 0, N'', N'5884d972-352b-4763-b4f7-a03c519c1e2b', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2018-11-24T13:12:46.3194258' AS DateTime2), CAST(N'2018-12-22T16:17:56.9948653' AS DateTime2), N'NOTASSIGNED', NULL, NULL, N'NCDG0052', N'10%', 982, 0, 0, N'Test', CAST(N'2018-11-24T13:12:45.9690137' 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'a7f98157-73fb-48f2-bae5-474e8da928ff', N'f58ff95f-89e6-4f8e-8868-a83828ebe999', N'Doctor', N'UltraSoundCategory_2', 0, 0, N'', N'fff0cb69-dc61-4081-9b80-ff8f57f6e46f', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2018-11-27T10:51:01.3762874' 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'a81f4261-2562-40bf-9193-37233b293cac', N'f58ff95f-89e6-4f8e-8868-a83828ebe999', N'Doctor', N'CT_2', 4.4, 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.8599202' AS DateTime2), N'NOTASSIGNED', N'NCR0004', 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'a851d084-d3e2-4673-9bb8-f5374ceb126d', N'1fc95b60-c117-4163-b73d-37bd64d7fac8', N'Doctor', N'ASSISTANT_DOCTOR', 1000, 1, N'KidneyOP_1', N'93443976-2220-48f9-8268-cdecc45440be', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2018-12-19T09:16:23.5384428' AS DateTime2), CAST(N'2018-12-20T11:28:03.0040406' AS DateTime2), N'83281dd4-5998-4b90-bd4f-ad30ae28cfa6', N'NCR0052', 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, 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'a8924e84-a154-4fb1-917f-45ae6ffd1a46', N'f58ff95f-89e6-4f8e-8868-a83828ebe999', N'UltraSoundDoctor', N'UltraSoundCategory_1', 1000, 1, N'', N'f8a9e4c8-7ab7-49d3-bec9-4abc80951695', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2018-12-06T11:50:04.6710022' AS DateTime2), CAST(N'2018-12-06T12:49:37.6896797' AS DateTime2), N'NOTASSIGNED', N'NCR0039', N'NOTASSIGNED', N'NCDG0067', NULL, 68, 6.8, 0, N'test', CAST(N'2018-12-06T11:50:04.4105222' AS DateTime2), N'236e8616-cd9a-4aaf-8413-0e305b46fb54', 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'a89aa7a2-5e75-4202-8a44-6dfbb271a32e', 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.4598057' 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'f63c32d6-2463-4e81-8fcf-67dc328c2856', 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'a8ab37fa-b9af-4cd7-9c25-6a4f3d5f43b5', N'7b3c0574-a184-4081-9a43-0b8360b4e107', N'Doctor', N'ASSISTANT_DOCTOR', 123, 0, N'KidneyOP_1', N'd647259e-5506-4502-afed-9c1f343b16c0', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2019-02-14T16:07:22.4235560' AS DateTime2), CAST(N'2019-02-14T16:07:22.4235560' AS DateTime2), N'ac648549-b8c7-4d2e-bd99-44837610c45a', NULL, NULL, N'NOTASSIGNED', N'123', NULL, 0, 0, N'ADDED_JUST_FOR_COMMISSION', CAST(N'0001-01-01T00:00:00.0000000' 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'a9a30ba3-7a1d-43f2-8989-75d2c9064089', N'cbfa4e4e-2fdf-48c7-9b94-e4712cf1f267', N'Referral', N'Hematology', -550, 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:21:52.4566667' 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'a9a48704-6bae-4ffa-b766-d5b3d05f2c66', N'2f49ff36-b04f-4081-9261-60ec973da26d', N'Referral', N'CombineCategory_1', 40, 1, N'', N'7563126c-a5b2-40ab-bdef-ef3b9f9dbfc4', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2018-11-26T10:07:00.2529871' AS DateTime2), CAST(N'2018-11-26T13:54:40.8749124' AS DateTime2), N'NOTASSIGNED', N'NCR0006', 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'a9d03895-0418-4a62-a51f-8c06daeec053', N'8d3cf8f9-7ef7-4008-b529-e05a062b3f0c', N'Doctor', N'Biochemistry ', 165, 0, N'', N'55338c4f-57bc-4c74-97df-c3cf847157ba', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2019-01-13T13:24:08.6919865' 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.1062513' 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'a9f26d4a-9fbb-41e9-acd8-ec065680aeab', N'2f49ff36-b04f-4081-9261-60ec973da26d', N'Doctor', 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.2460964' 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'aa18cd69-0b82-4a04-b8ea-c3e1f9628ea6', N'f58ff95f-89e6-4f8e-8868-a83828ebe999', N'Doctor', N'UltraSoundCategory_1', 6.8, 1, N'', N'f8a9e4c8-7ab7-49d3-bec9-4abc80951695', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2018-12-06T11:50:04.7908156' 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'aa7fb5dc-1f1c-42a8-a923-f421996acbc2', N'2f49ff36-b04f-4081-9261-60ec973da26d', N'Referral', N'CT_2', 23.3, 0, N'', N'86636fc7-fea3-4e6c-ad30-5f4bea4f8417', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2018-11-24T13:30:55.9383384' 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'aac493b5-4429-4a25-91c3-89029cfc68b0', N'4c772c03-ef45-492a-82d7-24bd49320ea3', N'Referral', N'UltraSoundCategory_2', 5.1, 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.7984202' AS DateTime2), N'NOTASSIGNED', N'NCR0032', NULL, N'NCDG0067', N'15%', 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'aae26a0d-72be-4e11-b9dc-d7d0f6be7018', N'24a50fd4-8d08-41d3-94e5-be95c9e77925', N'Doctor', N'Pathology (Combination)', 435, 1, N'', N'1a19f822-5eb2-4e98-8812-d474a95bf90d', N'd821cd9f-ac10-4f94-92cf-c292cd83b2c0', NULL, CAST(N'2018-07-14T00:21:26.0000000' AS DateTime2), CAST(N'2018-09-04T22:21:52.4566667' AS DateTime2), N'025708d8-b827-49dc-86c0-6791345cbdc0', N'RR0044', N'RINV0007', N'RDG0023', N'30%', 3750, 0, 0, N'Test', CAST(N'2018-07-14T00:17:08.0000000' AS DateTime2), NULL, 0, N'NA', N'NA', N'NA')
INSERT [dbo].[Commission] ([Id], [EmployeeId], [EmployeeType], [CommissionType], [Amount], [IsPaid], [Title], [InvoiceId], [HospitalId], [DateTime], [CreatedTime], [UpdatedTime], [MainInvoiceId], [PaymentGroup], [MainInvoiceCode], [InvoiceCode], [PercentOrValue], [InvoiceTotal], [LessAmount], [SpecialAmount], [Category], [InvoiceCreatedTime], [InvoiceDiagnosticTestId], [IsPaidFinally], [PaymentId], [ReceiptCreatedTime], [BarCodeImageUrl]) VALUES (N'ab8db980-f7f5-4382-8d43-17cd01a3de44', N'4c772c03-ef45-492a-82d7-24bd49320ea3', N'Referral', N'Biochemistry ', 110, 1, N'', N'22b6caac-53fd-43b0-a1fc-f5a38215c3a2', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2018-11-26T13:54:13.5165365' AS DateTime2), CAST(N'2018-12-22T16:36:52.8239738' AS DateTime2), N'NOTASSIGNED', N'NCR0008', NULL, N'NCDG0057', N'10%', 924.3, 102.7, 0, N'Test+OverAllAmount', CAST(N'2018-11-26T13:54:12.9779995' AS DateTime2), NULL, 1, N'NA', N'NA', N'NA')
INSERT [dbo].[Commission] ([Id], [EmployeeId], [EmployeeType], [CommissionType], [Amount], [IsPaid], [Title], [InvoiceId], [HospitalId], [DateTime], [CreatedTime], [UpdatedTime], [MainInvoiceId], [PaymentGroup], [MainInvoiceCode], [InvoiceCode], [PercentOrValue], [InvoiceTotal], [LessAmount], [SpecialAmount], [Category], [InvoiceCreatedTime], [InvoiceDiagnosticTestId], [IsPaidFinally], [PaymentId], [ReceiptCreatedTime], [BarCodeImageUrl]) VALUES (N'aca61e6d-0f8b-4eac-b802-b469dc92d096', N'f58ff95f-89e6-4f8e-8868-a83828ebe999', N'Doctor', N'DoctorVisit', 484, 0, N'', N'3f6e75b9-40f5-405f-b574-3892672759f7', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2018-12-20T13:30:02.0914988' AS DateTime2), CAST(N'2018-12-22T16:17:56.9948653' AS DateTime2), N'ebce39be-4d21-4251-835d-2620dd8fe8aa', NULL, N'NCINV0037', N'NCINV0037', 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'adc05202-eaf6-4a77-a001-1c345f731c78', N'4c772c03-ef45-492a-82d7-24bd49320ea3', N'Referral', N'Conbination', 20, 1, N'', N'4bac4ff3-459b-4475-8761-1773a8b06677', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2018-12-25T16:06:14.3352381' AS DateTime2), CAST(N'2018-12-25T16:07:36.8553368' AS DateTime2), N'NOTASSIGNED', N'NCR0091', NULL, N'NCDG0080', N'10%', 740.7, 82.3, 0, N'Test', CAST(N'2018-12-25T16:06:13.9164993' AS DateTime2), NULL, 1, N'NCP0013', N'25-Dec-18 4:07 PM', N'NA')
INSERT [dbo].[Commission] ([Id], [EmployeeId], [EmployeeType], [CommissionType], [Amount], [IsPaid], [Title], [InvoiceId], [HospitalId], [DateTime], [CreatedTime], [UpdatedTime], [MainInvoiceId], [PaymentGroup], [MainInvoiceCode], [InvoiceCode], [PercentOrValue], [InvoiceTotal], [LessAmount], [SpecialAmount], [Category], [InvoiceCreatedTime], [InvoiceDiagnosticTestId], [IsPaidFinally], [PaymentId], [ReceiptCreatedTime], [BarCodeImageUrl]) VALUES (N'adf106d1-b0fb-4750-a559-d51b3a2b4655', N'8d3cf8f9-7ef7-4008-b529-e05a062b3f0c', N'Doctor', N'DoctorVisit', 3344, 0, N'', N'NOTASSIGNED', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2019-01-17T13:14:02.8094734' AS DateTime2), CAST(N'2019-02-03T08:17:35.7629175' AS DateTime2), N'409081dc-7ea0-4c1a-9ac9-e50472e9bb1f', N'NCR0114', NULL, N'NOTASSIGNED', NULL, 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'af02a476-3317-437b-80ab-387df3491ddb', N'f58ff95f-89e6-4f8e-8868-a83828ebe999', N'UltraSoundDoctor', N'UltraSoundCategory_1', 0, 0, N'', N'01742239-632f-4455-8f21-a6e5fde60fd1', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2019-01-17T10:22:39.8951909' AS DateTime2), CAST(N'2019-02-03T08:17:35.7629175' AS DateTime2), N'NOTASSIGNED', N'NCR0114', N'NOTASSIGNED', N'NCDG0104', NULL, 1457, 0, 0, N'Test', CAST(N'2019-01-17T09:32:56.9286611' AS DateTime2), N'dc6cbdfc-90eb-49b9-87bf-ce944c3c1e3a', 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'af569286-1854-4f3e-a9b6-9cdcea84bb84', 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.5923915' 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'6503234c-0195-42fb-92ff-e00104c04d60', 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'b027568c-798c-4ded-aec1-1a216f2d8511', N'f58ff95f-89e6-4f8e-8868-a83828ebe999', N'Doctor', N'Biochemistry ', 70, 1, N'', N'd209247c-b29c-41b8-a45e-28c6b53decbb', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2018-12-25T15:51:27.8367838' 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'b0ed28bd-5a85-4627-a9d7-e3b6ad1c8588', N'f58ff95f-89e6-4f8e-8868-a83828ebe999', N'UltraSoundDoctor', N'UltraSoundCategory_2', 100, 1, N'', N'24e4ffc4-6392-4eb1-a842-d19b9ccf6475', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2018-12-03T16:05:49.8614418' AS DateTime2), CAST(N'2018-12-03T16:23:05.5498058' AS DateTime2), N'NOTASSIGNED', N'NCR0016', N'NOTASSIGNED', N'NCDG0063', NULL, 314, 0, 0, N'test', CAST(N'2018-12-03T16:05:49.6665426' AS DateTime2), N'6509c97c-c1c2-4c1a-a5b7-0fe5f7614f38', 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'b1657fba-7c0f-47bd-903e-3ba770ab1325', N'7a432ef3-78e3-4091-811b-11fc802fb981', N'Doctor', N'Pathology (Combination)', 0, 1, N'', N'81efe0aa-c8bd-4fdb-b3bd-f306b416bb2d', N'd821cd9f-ac10-4f94-92cf-c292cd83b2c0', NULL, CAST(N'2018-07-16T14:51:30.9166667' AS DateTime2), CAST(N'2018-09-04T22:21:52.4566667' AS DateTime2), N'02cae185-558d-4f91-a9ff-17af841e72a3', N'RR0042', N'RINV0013', N'RDG0029', N'0%', 350, 0, 0, N'Test', CAST(N'2018-07-16T14:49:46.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'b2d566a3-83ab-4e39-8007-14ed9e3df1ce', N'2f49ff36-b04f-4081-9261-60ec973da26d', N'Referral', N'Conbination', 30, 0, N'', N'9ec3c26c-7cfa-44f4-8e24-98f3073d3ea5', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2018-12-06T15:32:43.5631492' AS DateTime2), CAST(N'2018-12-22T16:17:56.9948653' AS DateTime2), N'NOTASSIGNED', NULL, NULL, N'NCDG0069', N'10%', 1683, 187, 0, N'Test', CAST(N'0001-01-01T00:00:00.0000000' AS DateTime2), NULL, 1, N'NA', N'NA', N'NA')
INSERT [dbo].[Commission] ([Id], [EmployeeId], [EmployeeType], [CommissionType], [Amount], [IsPaid], [Title], [InvoiceId], [HospitalId], [DateTime], [CreatedTime], [UpdatedTime], [MainInvoiceId], [PaymentGroup], [MainInvoiceCode], [InvoiceCode], [PercentOrValue], [InvoiceTotal], [LessAmount], [SpecialAmount], [Category], [InvoiceCreatedTime], [InvoiceDiagnosticTestId], [IsPaidFinally], [PaymentId], [ReceiptCreatedTime], [BarCodeImageUrl]) VALUES (N'b2f14aa6-5dce-4293-a6ed-3ed95b02e499', N'1fc95b60-c117-4163-b73d-37bd64d7fac8', N'Doctor', N'CombineCategory_1', 5.28, 0, N'', N'39b40131-dd02-494a-9c09-93ae96288084', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2019-01-13T13:40:31.9580429' AS DateTime2), CAST(N'2019-02-03T08:17:35.7629175' AS DateTime2), N'NOTASSIGNED', N'NCR0114', NULL, N'NCDG0099', N'12%', 3469.6, 274.4, 0, N'Test', CAST(N'2019-01-13T13:32:39.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'b30c08ab-8f17-422e-a75d-a3b4b1b3f168', N'f58ff95f-89e6-4f8e-8868-a83828ebe999', N'Doctor', N'Conbination', 20, 0, N'', N'db26c1f2-e56b-4636-969d-be8c38e57c0f', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2019-01-14T10:10:58.3662800' AS DateTime2), CAST(N'2019-02-03T08:17:35.7629175' AS DateTime2), N'e5ad7440-6629-405c-b524-aef3d276e5ad', N'NCR0114', NULL, N'NCDG0101', N'10%', 200, 0, 0, N'Test', CAST(N'2019-01-14T10:10:57.3220429' 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'b3389597-7776-43b1-a78a-fe225f0dc192', N'f58ff95f-89e6-4f8e-8868-a83828ebe999', N'UltraSoundDoctor', N'UltraSoundCategory_2', 0, 0, N'', N'003042e8-1731-43ad-a3cd-906998b3e07d', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2018-12-05T16:07:50.1539049' AS DateTime2), CAST(N'2018-12-22T16:17:56.9948653' AS DateTime2), N'NOTASSIGNED', NULL, N'NOTASSIGNED', N'NCDG0066', NULL, 512, 51.2, 0, N'Test', CAST(N'2018-12-05T16:07:49.8740832' AS DateTime2), N'7b5ff99f-5013-489e-86c5-506d3b587cd1', 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'b3463517-9da9-4e87-bdfa-6e78ffed07ed', N'f58ff95f-89e6-4f8e-8868-a83828ebe999', N'UltraSoundDoctor', N'UltraSoundCategory_1', 300, 1, N'', N'24e4ffc4-6392-4eb1-a842-d19b9ccf6475', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2018-12-03T16:05:49.8004593' AS DateTime2), CAST(N'2018-12-03T16:23:05.5598001' AS DateTime2), N'NOTASSIGNED', N'NCR0018', N'NOTASSIGNED', N'NCDG0063', NULL, 314, 0, 0, N'test', CAST(N'2018-12-03T16:05:49.6665426' AS DateTime2), N'cba00ff9-0e9d-401e-ad82-dbeb07284b1c', 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'b359f275-9872-4a9c-bcbe-62e6b6e57e2b', N'4c772c03-ef45-492a-82d7-24bd49320ea3', N'Doctor', N'DoctorVisit', 33, 0, N'', N'NOTASSIGNED', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2019-01-17T13:32:00.8163748' AS DateTime2), CAST(N'2019-02-03T08:17:35.7629175' AS DateTime2), N'10e0a2dd-c064-4251-b264-5ba675bbb22e', N'NCR0114', NULL, N'NOTASSIGNED', NULL, 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'b3b4f71b-cb35-4ca5-b6a6-55e8ff62c98b', N'4c772c03-ef45-492a-82d7-24bd49320ea3', N'Doctor', N'Biochemistry ', 75, 1, N'', N'22b6caac-53fd-43b0-a1fc-f5a38215c3a2', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2018-11-26T13:54:13.5115412' AS DateTime2), CAST(N'2018-12-22T16:36:54.5759692' AS DateTime2), N'NOTASSIGNED', N'NCR0007', NULL, N'NCDG0057', N'10%', 924.3, 102.7, 0, N'Test+OverAllAmount', CAST(N'2018-11-26T13:54:12.9779995' AS DateTime2), NULL, 1, N'NA', N'NA', N'NA')
INSERT [dbo].[Commission] ([Id], [EmployeeId], [EmployeeType], [CommissionType], [Amount], [IsPaid], [Title], [InvoiceId], [HospitalId], [DateTime], [CreatedTime], [UpdatedTime], [MainInvoiceId], [PaymentGroup], [MainInvoiceCode], [InvoiceCode], [PercentOrValue], [InvoiceTotal], [LessAmount], [SpecialAmount], [Category], [InvoiceCreatedTime], [InvoiceDiagnosticTestId], [IsPaidFinally], [PaymentId], [ReceiptCreatedTime], [BarCodeImageUrl]) VALUES (N'b3ddb758-1569-4148-8763-1f393a875eb3', N'82b04905-0844-420a-9734-ef6ef52771f2', N'Doctor', N'Hematology', 40, 1, N'', N'1f2197fc-5fe9-4325-899d-994c9fd6ea75', N'd821cd9f-ac10-4f94-92cf-c292cd83b2c0', NULL, CAST(N'2018-08-03T15:09:09.7533333' AS DateTime2), CAST(N'2018-09-04T22:35:23.4100000' AS DateTime2), N'dc1a2ce0-6318-4422-9ecc-8889dc8d00c4', N'RR0045', N'RINV0084', N'RDG0101', N'40', 1200, 50, 0, N'Test', CAST(N'2018-08-03T11:43:50.0966667' AS DateTime2), NULL, 0, N'NA', N'NA', N'NA')
INSERT [dbo].[Commission] ([Id], [EmployeeId], [EmployeeType], [CommissionType], [Amount], [IsPaid], [Title], [InvoiceId], [HospitalId], [DateTime], [CreatedTime], [UpdatedTime], [MainInvoiceId], [PaymentGroup], [MainInvoiceCode], [InvoiceCode], [PercentOrValue], [InvoiceTotal], [LessAmount], [SpecialAmount], [Category], [InvoiceCreatedTime], [InvoiceDiagnosticTestId], [IsPaidFinally], [PaymentId], [ReceiptCreatedTime], [BarCodeImageUrl]) VALUES (N'b3f6e0a2-cd9f-4872-93f1-56feeff2699a', N'4c772c03-ef45-492a-82d7-24bd49320ea3', N'Doctor', N'CombineCategory_1', 35.6, 0, N'', N'95330de0-a5b7-4d94-a289-175147c7848b', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2019-01-09T12:23:07.6976268' AS DateTime2), CAST(N'2019-02-03T08:17:35.7629175' AS DateTime2), N'NOTASSIGNED', N'NCR0114', NULL, N'NCDG0097', N'10%', 606, 0, 0, N'Test', CAST(N'2019-01-09T12:23:06.6109646' 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'b4ae482a-c8e1-4709-aecb-fbbf3b75eaa1', N'2f49ff36-b04f-4081-9261-60ec973da26d', N'Doctor', N'ANESTHESIA_DOCTOR', 330, 1, N'KidneyOP_1', N'503de2f0-2c09-4be7-8f57-8b7c28560eff', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2019-01-17T13:27:38.7307139' AS DateTime2), CAST(N'2019-02-02T16:34:43.4674570' AS DateTime2), N'409081dc-7ea0-4c1a-9ac9-e50472e9bb1f', NULL, N'NCINV0051', N'NCINV0051', N'2330', NULL, 0, 0, N'Operation', CAST(N'2019-01-17T13:27:38.5977670' AS DateTime2), NULL, 0, N'NCP0058', 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'b4c83b0f-23d1-4363-83e4-b8d076391a78', N'f58ff95f-89e6-4f8e-8868-a83828ebe999', N'Doctor', N'ASSIGNED_DOCTOR', 220, 0, N'KidneyOP_1', N'a335dccd-20b3-45b1-9268-5a34a1cb456d', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2019-02-16T16:56:13.3503113' AS DateTime2), CAST(N'2019-02-16T16:56:13.3503113' 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'b5012b4e-60d2-4d15-a4a9-5f172d8b3649', 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.5115568' 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'96894dc2-cdaa-41c4-be86-99dc76cee73a', 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'b52a3af3-3c19-4a23-9775-2f482ef32765', N'e3d4a527-b8d6-4e80-8e15-ddd22394a385', N'Doctor', N'Pathology', -160, 1, N'', N'e6c7e2bf-19c9-4451-a118-c34a0c698c23', N'd821cd9f-ac10-4f94-92cf-c292cd83b2c0', NULL, CAST(N'2018-07-21T15:03:58.8633333' AS DateTime2), CAST(N'2018-09-04T22:35:23.4133333' AS DateTime2), N'dd5e3703-3ba2-4cc1-b199-9c5887a08b72', N'RR0036', N'RINV0031', N'RDG0049', N'0%', 1020, 680, 0, N'Test', CAST(N'2018-07-21T14:58:57.5700000' AS DateTime2), NULL, 0, N'NA', N'NA', N'NA')
INSERT [dbo].[Commission] ([Id], [EmployeeId], [EmployeeType], [CommissionType], [Amount], [IsPaid], [Title], [InvoiceId], [HospitalId], [DateTime], [CreatedTime], [UpdatedTime], [MainInvoiceId], [PaymentGroup], [MainInvoiceCode], [InvoiceCode], [PercentOrValue], [InvoiceTotal], [LessAmount], [SpecialAmount], [Category], [InvoiceCreatedTime], [InvoiceDiagnosticTestId], [IsPaidFinally], [PaymentId], [ReceiptCreatedTime], [BarCodeImageUrl]) VALUES (N'b53c1c84-bc2a-4962-8452-85f881a98c7c', N'f58ff95f-89e6-4f8e-8868-a83828ebe999', N'Doctor', N'DoctorVisit', 33, 0, N'', N'NOTASSIGNED', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2019-01-17T13:13:04.8087036' AS DateTime2), CAST(N'2019-02-03T08:17:35.7629175' AS DateTime2), N'409081dc-7ea0-4c1a-9ac9-e50472e9bb1f', N'NCR0114', NULL, N'NOTASSIGNED', NULL, 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'b54b2a45-da27-4105-b4d8-6ee60fb80273', N'f58ff95f-89e6-4f8e-8868-a83828ebe999', N'UltraSoundDoctor', N'UltraSoundCategory_2', 1000, 1, N'', N'f8a9e4c8-7ab7-49d3-bec9-4abc80951695', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2018-12-06T11:50:04.6406099' AS DateTime2), CAST(N'2018-12-06T12:49:33.8205494' AS DateTime2), N'NOTASSIGNED', N'NCR0037', N'NOTASSIGNED', N'NCDG0067', NULL, 68, 6.8, 0, N'test', CAST(N'2018-12-06T11:50:04.4105222' AS DateTime2), N'0ef100cf-b5aa-46b4-9478-196fea94d2d9', 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'b59fbb7a-6195-4081-80e6-60a52b4960b4', N'1fc95b60-c117-4163-b73d-37bd64d7fac8', N'Doctor', N'Assistance', 22, 0, N'KidneyOP_1', N'54122edc-d414-4681-bcd9-8a2c5dea2efa', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2018-12-13T16:01:53.5401531' AS DateTime2), CAST(N'2018-12-22T16:17:56.9948653' AS DateTime2), N'3185ec7e-59f6-4fdc-b1ff-b0d47865fd59', NULL, N'NCINV0034', N'NCINV0034', N'22', 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'b68315c5-6690-4946-829a-a625c3bee136', N'2f49ff36-b04f-4081-9261-60ec973da26d', N'Doctor', N'CLINIC_REFERRAL', 1000, 0, N'ClinicInvoice', N'62bfd02b-b13a-4607-abbe-794004debda6', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2018-12-18T11:05:15.6864294' 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'OPERATION', CAST(N'2018-12-17T08:57:09.7197221' 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'b6abb2ac-ea31-4c3a-8f95-1c702e13f4e3', N'4c772c03-ef45-492a-82d7-24bd49320ea3', N'Doctor', N'DoctorVisit', 3344, 1, N'', N'NOTASSIGNED', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2019-01-17T13:13:35.5866235' AS DateTime2), CAST(N'2019-02-02T16:34:30.3153989' AS DateTime2), N'409081dc-7ea0-4c1a-9ac9-e50472e9bb1f', NULL, NULL, N'NOTASSIGNED', NULL, NULL, 0, 0, N'ADDED_JUST_FOR_COMMISSION', CAST(N'0001-01-01T00:00:00.0000000' AS DateTime2), NULL, 0, N'NCP0043', 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'b6f07e58-9af3-4295-85fe-1e7a28eb7e4b', N'f58ff95f-89e6-4f8e-8868-a83828ebe999', N'Doctor', 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:21:43.2106026' AS DateTime2), N'NOTASSIGNED', N'NCR0077', NULL, N'NCDG0074', N'10%', 585, 65, 0, N'Test', CAST(N'2018-12-23T11:14:13.6797121' AS DateTime2), NULL, 1, N'NA', N'NA', N'NA')
INSERT [dbo].[Commission] ([Id], [EmployeeId], [EmployeeType], [CommissionType], [Amount], [IsPaid], [Title], [InvoiceId], [HospitalId], [DateTime], [CreatedTime], [UpdatedTime], [MainInvoiceId], [PaymentGroup], [MainInvoiceCode], [InvoiceCode], [PercentOrValue], [InvoiceTotal], [LessAmount], [SpecialAmount], [Category], [InvoiceCreatedTime], [InvoiceDiagnosticTestId], [IsPaidFinally], [PaymentId], [ReceiptCreatedTime], [BarCodeImageUrl]) VALUES (N'b6f58ff9-d725-44e3-97d9-b1148eec76fb', N'f58ff95f-89e6-4f8e-8868-a83828ebe999', N'Doctor', N'UltraSoundCategory_2', 68, 0, N'', N'9ec3c26c-7cfa-44f4-8e24-98f3073d3ea5', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2018-12-06T15:26:18.6025309' 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'b705b413-c1d9-41d0-a005-a3b88a58a87e', N'f58ff95f-89e6-4f8e-8868-a83828ebe999', N'Referral', N'Conbination', 20, 0, N'', N'209481c5-8894-40e0-9811-794b49bb6446', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2018-11-28T08:59:15.3707876' AS DateTime2), CAST(N'2018-12-22T16:17:56.9948653' AS DateTime2), N'NOTASSIGNED', NULL, NULL, N'NCDG0060', N'10%', 7374.6, 819.4, 0, N'Test', CAST(N'2018-11-28T08:59:14.2156449' AS DateTime2), NULL, 1, N'NA', N'NA', N'NA')
INSERT [dbo].[Commission] ([Id], [EmployeeId], [EmployeeType], [CommissionType], [Amount], [IsPaid], [Title], [InvoiceId], [HospitalId], [DateTime], [CreatedTime], [UpdatedTime], [MainInvoiceId], [PaymentGroup], [MainInvoiceCode], [InvoiceCode], [PercentOrValue], [InvoiceTotal], [LessAmount], [SpecialAmount], [Category], [InvoiceCreatedTime], [InvoiceDiagnosticTestId], [IsPaidFinally], [PaymentId], [ReceiptCreatedTime], [BarCodeImageUrl]) VALUES (N'b72a4519-4c85-4c2a-83d5-32cf4af9334d', N'2f49ff36-b04f-4081-9261-60ec973da26d', N'Doctor', N'DoctorVisit', 300, 0, N'', N'46965960-1aa5-4fa1-8b10-91b4554f32ff', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2018-12-18T10:30:55.3875312' AS DateTime2), CAST(N'2018-12-22T16:17:56.9948653' AS DateTime2), N'83281dd4-5998-4b90-bd4f-ad30ae28cfa6', NULL, N'NCINV0036', N'NCINV0036', NULL, NULL, 0, 0, N'Operation', CAST(N'0001-01-01T00:00:00.0000000' AS DateTime2), NULL, 1, N'NA', N'NA', N'NA')
INSERT [dbo].[Commission] ([Id], [EmployeeId], [EmployeeType], [CommissionType], [Amount], [IsPaid], [Title], [InvoiceId], [HospitalId], [DateTime], [CreatedTime], [UpdatedTime], [MainInvoiceId], [PaymentGroup], [MainInvoiceCode], [InvoiceCode], [PercentOrValue], [InvoiceTotal], [LessAmount], [SpecialAmount], [Category], [InvoiceCreatedTime], [InvoiceDiagnosticTestId], [IsPaidFinally], [PaymentId], [ReceiptCreatedTime], [BarCodeImageUrl]) VALUES (N'b73e8090-977a-439d-b016-420164f4f7e8', N'2f49ff36-b04f-4081-9261-60ec973da26d', N'UltraSoundDoctor', N'UltraSoundCategory_1', 0, 0, N'', N'3e34586b-5b04-4755-ae22-5694878a495e', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2019-01-21T15:49:34.5668873' 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'b8b96896-71ab-4884-b8de-89c74ef8aff4', 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'b750a25f-b7b6-4e50-bab5-c3cab693c8b6', N'8d3cf8f9-7ef7-4008-b529-e05a062b3f0c', N'Doctor', N'ASSISTANT_SURGEON', 44, 0, N'KidneyOP_1', N'd647259e-5506-4502-afed-9c1f343b16c0', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2019-01-19T10:09:28.0603689' AS DateTime2), CAST(N'2019-02-03T08:17:35.7629175' AS DateTime2), N'ac648549-b8c7-4d2e-bd99-44837610c45a', N'NCR0114', N'NCINV0053', N'NCINV0053', N'33', NULL, 0, 0, N'Operation', CAST(N'2019-01-19T10:09:27.8770711' 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'b7fd7a00-58cb-4158-8574-9c205027355a', N'2f49ff36-b04f-4081-9261-60ec973da26d', N'UltraSoundDoctor', N'UltraSoundCategory_1', 200, 1, N'', N'b19fdabe-22c4-4bfd-9e31-ce5c9110367b', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2018-11-29T16:14:24.7964332' AS DateTime2), CAST(N'2018-12-02T15:50:26.1834295' AS DateTime2), N'NOTASSIGNED', N'NCR0012', N'NOTASSIGNED', N'NCDG0061', NULL, 157, 0, 0, N'test', CAST(N'2018-11-29T16:14:24.7495605' AS DateTime2), NULL, 0, N'NA', N'NA', N'NA')
INSERT [dbo].[Commission] ([Id], [EmployeeId], [EmployeeType], [CommissionType], [Amount], [IsPaid], [Title], [InvoiceId], [HospitalId], [DateTime], [CreatedTime], [UpdatedTime], [MainInvoiceId], [PaymentGroup], [MainInvoiceCode], [InvoiceCode], [PercentOrValue], [InvoiceTotal], [LessAmount], [SpecialAmount], [Category], [InvoiceCreatedTime], [InvoiceDiagnosticTestId], [IsPaidFinally], [PaymentId], [ReceiptCreatedTime], [BarCodeImageUrl]) VALUES (N'b86104c6-65e3-439c-8455-9dd7f24d6f65', N'4c772c03-ef45-492a-82d7-24bd49320ea3', N'Doctor', N'CombineCategory_1', 4.4, 1, N'', N'22b6caac-53fd-43b0-a1fc-f5a38215c3a2', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2018-11-26T13:54:13.5185362' AS DateTime2), CAST(N'2018-12-22T16:36:54.6054465' AS DateTime2), N'NOTASSIGNED', N'NCR0007', NULL, N'NCDG0057', N'10%', 924.3, 102.7, 0, N'Test+OverAllAmount', CAST(N'2018-11-26T13:54:12.9779995' AS DateTime2), NULL, 1, N'NA', N'NA', N'NA')
INSERT [dbo].[Commission] ([Id], [EmployeeId], [EmployeeType], [CommissionType], [Amount], [IsPaid], [Title], [InvoiceId], [HospitalId], [DateTime], [CreatedTime], [UpdatedTime], [MainInvoiceId], [PaymentGroup], [MainInvoiceCode], [InvoiceCode], [PercentOrValue], [InvoiceTotal], [LessAmount], [SpecialAmount], [Category], [InvoiceCreatedTime], [InvoiceDiagnosticTestId], [IsPaidFinally], [PaymentId], [ReceiptCreatedTime], [BarCodeImageUrl]) VALUES (N'b8b7057d-dd9d-4fad-bf55-39bd26e6fcd6', N'4c772c03-ef45-492a-82d7-24bd49320ea3', N'Doctor', N'Biochemistry ', 75, 1, N'', N'eb7be4be-6bd1-45ba-9031-6297b013383c', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2019-02-03T09:56:52.0995901' AS DateTime2), CAST(N'2019-02-23T12:47:31.8154487' AS DateTime2), N'NOTASSIGNED', N'NCR0119', NULL, N'NCDG0116', N'10%', 1105, 0, 0, N'Test', CAST(N'2019-02-03T09:56:48.9540657' AS DateTime2), NULL, 1, N'NCP0065', N'23-02-2019 12:47 PM', N'data:image/jpeg;base64,[encoded data, 8360 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'b916ac55-2985-4a91-a3f3-501bebd3b067', N'2f49ff36-b04f-4081-9261-60ec973da26d', N'Referral', N'UltraSoundCategory_1', 72, 0, N'', N'bf6974a6-9f9e-4640-bd8f-535bab6e4eab', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2019-01-08T11:19:15.9866253' AS DateTime2), CAST(N'2019-02-03T08:17:35.7629175' AS DateTime2), N'NOTASSIGNED', N'NCR0114', NULL, N'NCDG0093', N'20%', 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'b9ddedc6-1e19-496f-8fc9-bb986d292964', N'2f49ff36-b04f-4081-9261-60ec973da26d', N'Referral', N'Conbination', 100, 1, N'', N'26b3e18b-3653-41c6-95af-cc1cff900d7f', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2018-12-24T12:13:57.3873896' AS DateTime2), CAST(N'2018-12-24T14:16:30.8806509' AS DateTime2), N'NOTASSIGNED', N'NCR0085', 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'bb879b99-cd50-4dde-8953-680c18b417cc', N'2f49ff36-b04f-4081-9261-60ec973da26d', N'UltraSoundDoctor', N'UltraSoundCategory_1', 0, 0, N'', N'003042e8-1731-43ad-a3cd-906998b3e07d', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2018-12-05T16:07:50.3158209' AS DateTime2), CAST(N'2018-12-22T16:17:56.9948653' AS DateTime2), N'NOTASSIGNED', NULL, N'NOTASSIGNED', N'NCDG0066', NULL, 512, 51.2, 0, N'Test', CAST(N'2018-12-05T16:07:49.8740832' AS DateTime2), N'a3518caa-96d7-4a9e-84ab-c75086d081b4', 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'bbcb9217-023f-47e0-bc02-d7152b3cd368', N'2f49ff36-b04f-4081-9261-60ec973da26d', N'Doctor', N'Conbination', 35, 1, N'', N'01742239-632f-4455-8f21-a6e5fde60fd1', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2019-01-17T09:36:58.1409504' 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.0000000' AS DateTime2), NULL, 1, N'NCP0048', N'19-01-2019 1:54 PM', N'data:image/jpeg;base64,[encoded data, 8452 characters]')
INSERT [dbo].[Commission] ([Id], [EmployeeId], [EmployeeType], [CommissionType], [Amount], [IsPaid], [Title], [InvoiceId], [HospitalId], [DateTime], [CreatedTime], [UpdatedTime], [MainInvoiceId], [PaymentGroup], [MainInvoiceCode], [InvoiceCode], [PercentOrValue], [InvoiceTotal], [LessAmount], [SpecialAmount], [Category], [InvoiceCreatedTime], [InvoiceDiagnosticTestId], [IsPaidFinally], [PaymentId], [ReceiptCreatedTime], [BarCodeImageUrl]) VALUES (N'bbe53479-f0a1-4aa2-b128-047de882c27a', N'2f49ff36-b04f-4081-9261-60ec973da26d', N'Doctor', N'DoctorVisit', 123, 0, N'', N'NOTASSIGNED', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2018-12-20T16:02:08.5365302' AS DateTime2), CAST(N'2018-12-22T16:17:56.9948653' AS DateTime2), N'9c0c25c5-11fc-4a52-a928-6cfebda17d20', NULL, N'NCINV0038', N'NOTASSIGNED', NULL, 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'bc43aed0-c748-48bf-8a62-986b2c063184', N'f58ff95f-89e6-4f8e-8868-a83828ebe999', N'Doctor', N'CT_2', 0, 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: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'bc9a3aa3-cc0c-4f08-8649-0da5bde4f402', N'f58ff95f-89e6-4f8e-8868-a83828ebe999', N'UltraSoundDoctor', N'UltraSoundCategory_1', 400, 1, N'', N'24e4ffc4-6392-4eb1-a842-d19b9ccf6475', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2018-12-03T16:05:49.8134715' AS DateTime2), CAST(N'2018-12-03T16:23:05.5627986' AS DateTime2), N'NOTASSIGNED', N'NCR0019', N'NOTASSIGNED', N'NCDG0063', NULL, 314, 0, 0, N'test', CAST(N'2018-12-03T16:05:49.6665426' AS DateTime2), N'92a7584e-6817-49c7-b960-c5b34b26cf4f', 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'bcaebe2b-3ed0-40cc-a253-ba9f69cc1e22', N'4c772c03-ef45-492a-82d7-24bd49320ea3', N'Doctor', N'Conbination', 20, 0, N'', N'209481c5-8894-40e0-9811-794b49bb6446', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2018-11-28T08:59:15.3707876' AS DateTime2), CAST(N'2018-12-22T16:17:56.9948653' AS DateTime2), N'NOTASSIGNED', NULL, NULL, N'NCDG0060', N'10%', 7374.6, 819.4, 0, N'Test', CAST(N'2018-11-28T08:59:14.2156449' AS DateTime2), NULL, 1, N'NA', N'NA', N'NA')
INSERT [dbo].[Commission] ([Id], [EmployeeId], [EmployeeType], [CommissionType], [Amount], [IsPaid], [Title], [InvoiceId], [HospitalId], [DateTime], [CreatedTime], [UpdatedTime], [MainInvoiceId], [PaymentGroup], [MainInvoiceCode], [InvoiceCode], [PercentOrValue], [InvoiceTotal], [LessAmount], [SpecialAmount], [Category], [InvoiceCreatedTime], [InvoiceDiagnosticTestId], [IsPaidFinally], [PaymentId], [ReceiptCreatedTime], [BarCodeImageUrl]) VALUES (N'bd2ea015-a872-4bb1-8f4d-301b79572d24', N'4c772c03-ef45-492a-82d7-24bd49320ea3', N'Doctor', N'Haematology', 75, 0, N'', N'3e34586b-5b04-4755-ae22-5694878a495e', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2019-01-21T15:49:34.8338229' AS DateTime2), CAST(N'2019-02-03T08:17:35.7629175' AS DateTime2), N'NOTASSIGNED', N'NCR0114', NULL, N'NCDG0107', N'10%', 22280, 0, 0, N'Test', CAST(N'2019-01-21T15:49:31.1487126' AS DateTime2), NULL, 1, NULL, N'03-02-2019 8:17 AM', N'data:image/jpeg;base64,[encoded data, 8380 characters]')
