INSERT [dbo].[Commission] ([Id], [EmployeeId], [EmployeeType], [CommissionType], [Amount], [IsPaid], [Title], [InvoiceId], [HospitalId], [DateTime], [CreatedTime], [UpdatedTime], [MainInvoiceId], [PaymentGroup], [MainInvoiceCode], [InvoiceCode], [PercentOrValue], [InvoiceTotal], [LessAmount], [SpecialAmount], [Category], [InvoiceCreatedTime], [InvoiceDiagnosticTestId], [IsPaidFinally], [PaymentId], [ReceiptCreatedTime], [BarCodeImageUrl]) VALUES (N'3a0dec66-8629-4607-a130-790c97ef4dc6', N'4c772c03-ef45-492a-82d7-24bd49320ea3', N'Doctor', N'SPECIAL_SURGEON', 1000, 1, N'KidneyOP_1', N'93443976-2220-48f9-8268-cdecc45440be', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2018-12-17T09:42:25.1511653' AS DateTime2), CAST(N'2018-12-20T11:51:23.9562109' AS DateTime2), N'83281dd4-5998-4b90-bd4f-ad30ae28cfa6', N'NCR0058', N'NCINV0036', N'NCINV0036', N'1000', NULL, 0, 0, N'Operation', CAST(N'2018-12-17T09:30:58.2648648' AS DateTime2), NULL, 0, N'NA', N'NA', N'NA')
INSERT [dbo].[Commission] ([Id], [EmployeeId], [EmployeeType], [CommissionType], [Amount], [IsPaid], [Title], [InvoiceId], [HospitalId], [DateTime], [CreatedTime], [UpdatedTime], [MainInvoiceId], [PaymentGroup], [MainInvoiceCode], [InvoiceCode], [PercentOrValue], [InvoiceTotal], [LessAmount], [SpecialAmount], [Category], [InvoiceCreatedTime], [InvoiceDiagnosticTestId], [IsPaidFinally], [PaymentId], [ReceiptCreatedTime], [BarCodeImageUrl]) VALUES (N'3aaeadea-1b04-4df0-8f8b-2508f4995b8f', N'410f20e6-ad68-450b-9cf3-55da4793042c', N'Referral', N'Biochemistry ', 145, 0, N'', N'2a4569a0-70ab-4888-a205-af406c84856d', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2019-01-07T09:32:32.6414648' 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'3aee67d2-dea8-4eeb-b3c5-c868d44f4bd4', N'f58ff95f-89e6-4f8e-8868-a83828ebe999', N'Doctor', N'CLINIC_REFERRAL', 3344, 1, N'ClinicInvoice', N'NOTASSIGNED', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2019-01-17T13:13:52.0294771' AS DateTime2), CAST(N'2019-02-02T16:34:30.2614308' AS DateTime2), N'409081dc-7ea0-4c1a-9ac9-e50472e9bb1f', NULL, NULL, N'NOTASSIGNED', N'3344', NULL, 0, 0, N'ADDED_JUST_FOR_COMMISSION', CAST(N'0001-01-01T00:00:00.0000000' AS DateTime2), NULL, 0, N'NCP0040', 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'3c2e9741-0a4d-43da-bb08-2c9fd0897e9d', N'1fc95b60-c117-4163-b73d-37bd64d7fac8', N'Doctor', N'Conbination', 231, 0, N'', N'f33e74fd-da37-47dd-882b-a9663d8f8b7d', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2019-01-14T11:07:21.5963863' 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'3c5a9bc2-6a4a-465d-b131-f1f18d35cd7c', N'f58ff95f-89e6-4f8e-8868-a83828ebe999', N'Doctor', N'CombineCategory_1', 40, 1, N'', N'0858d559-451b-4578-a003-c905fe560de7', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2019-01-19T11:29:20.3464824' AS DateTime2), CAST(N'2019-01-19T13:49:24.6466694' AS DateTime2), N'NOTASSIGNED', N'NCR0105', NULL, N'NCDG0106', N'10%', 1000, 150, 0, N'Test', CAST(N'2019-01-19T11:29:20.2545392' AS DateTime2), NULL, 1, N'NCP0047', N'19-01-2019 1:49 PM', N'data:image/jpeg;base64,[encoded data, 8416 characters]')
INSERT [dbo].[Commission] ([Id], [EmployeeId], [EmployeeType], [CommissionType], [Amount], [IsPaid], [Title], [InvoiceId], [HospitalId], [DateTime], [CreatedTime], [UpdatedTime], [MainInvoiceId], [PaymentGroup], [MainInvoiceCode], [InvoiceCode], [PercentOrValue], [InvoiceTotal], [LessAmount], [SpecialAmount], [Category], [InvoiceCreatedTime], [InvoiceDiagnosticTestId], [IsPaidFinally], [PaymentId], [ReceiptCreatedTime], [BarCodeImageUrl]) VALUES (N'3cd4b6e3-4e51-43b0-a2f2-a55a88c4873e', N'8d3cf8f9-7ef7-4008-b529-e05a062b3f0c', N'Doctor', N'ASSISTANT_SURGEON', 120, 0, N'KidneyOP_1', N'4b1a982e-042e-4c33-8058-6b23570c0f85', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2018-12-25T16:30:29.0082573' AS DateTime2), CAST(N'2019-02-03T08:17:35.7629175' AS DateTime2), N'2dea13d0-bea8-41c9-8442-93148a2818c1', N'NCR0114', N'NCINV0040', N'NCINV0040', N'120', NULL, 0, 0, N'Operation', CAST(N'2018-12-25T16:30:07.3822871' AS DateTime2), NULL, 1, NULL, N'03-02-2019 8:17 AM', N'data:image/jpeg;base64,[encoded data, 8380 characters]')
INSERT [dbo].[Commission] ([Id], [EmployeeId], [EmployeeType], [CommissionType], [Amount], [IsPaid], [Title], [InvoiceId], [HospitalId], [DateTime], [CreatedTime], [UpdatedTime], [MainInvoiceId], [PaymentGroup], [MainInvoiceCode], [InvoiceCode], [PercentOrValue], [InvoiceTotal], [LessAmount], [SpecialAmount], [Category], [InvoiceCreatedTime], [InvoiceDiagnosticTestId], [IsPaidFinally], [PaymentId], [ReceiptCreatedTime], [BarCodeImageUrl]) VALUES (N'3ceacde8-c73f-4109-babc-e3d3cc4e7fb5', N'4c772c03-ef45-492a-82d7-24bd49320ea3', N'Referral', N'Biochemistry ', 180, 0, N'', N'ddd8d663-8ec8-4094-874b-42caf6053c00', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2019-01-06T13:25:46.8337207' 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'3d08f6f5-a6f6-4855-a8c9-fb85282720da', N'2f49ff36-b04f-4081-9261-60ec973da26d', N'Referral', N'CT_2', 100, 1, N'', N'26b3e18b-3653-41c6-95af-cc1cff900d7f', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2018-12-24T12:13:57.3818491' AS DateTime2), CAST(N'2018-12-24T14:16:30.8653328' AS DateTime2), N'NOTASSIGNED', N'NCR0083', 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'3de63cb5-cf56-4a35-9829-080393ca69aa', N'f58ff95f-89e6-4f8e-8868-a83828ebe999', N'Doctor', N'ANESTHESIA_DOCTOR', 0, 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'NCR0099', N'NCINV0041', N'NCINV0041', N'2000', NULL, 0, 0, N'Operation', CAST(N'2018-12-26T08:09:45.3326896' AS DateTime2), NULL, 1, N'NCP0016', N'27-Dec-18 11:11 AM', N'data:image/jpeg;base64,[encoded data, 8636 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'3e103fcd-2a1b-497b-b567-35e10d6aed25', N'6ee087eb-7031-408f-b4ea-f567d250f75b', N'Doctor', N'CLINIC_REFERRAL', 33, 0, N'ClinicInvoice', N'NOTASSIGNED', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2019-01-17T13:32:06.3634050' AS DateTime2), CAST(N'2019-02-03T08:17:35.7629175' AS DateTime2), N'10e0a2dd-c064-4251-b264-5ba675bbb22e', N'NCR0114', NULL, N'NOTASSIGNED', N'33', 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'3e7cb7ae-4992-4e64-a716-a6a79e959af0', N'4c772c03-ef45-492a-82d7-24bd49320ea3', N'Referral', N'Biochemistry ', 75, 0, N'', N'b589a7b7-19d2-492e-8366-1d76f986e4dd', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2019-01-03T18:58:29.1509589' 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'408ee9fa-4611-4771-8f12-32f2824b3e1d', N'4c772c03-ef45-492a-82d7-24bd49320ea3', N'Doctor', N'SPECIAL_SURGEON', 0, 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'NCP0017', 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'40cdb991-ac04-4296-a0e5-6d62caf4e7c5', N'4c772c03-ef45-492a-82d7-24bd49320ea3', N'Doctor', N'ASSIGNED_DOCTOR', 0, 1, N'KidneyOP_1', N'93443976-2220-48f9-8268-cdecc45440be', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2018-12-17T09:42:25.0451488' AS DateTime2), CAST(N'2018-12-20T11:28:02.9760334' AS DateTime2), N'83281dd4-5998-4b90-bd4f-ad30ae28cfa6', N'NCR0045', N'NCINV0036', N'NCINV0036', N'1000', NULL, 0, 0, N'Operation', CAST(N'2018-12-17T09:30:58.2648648' AS DateTime2), NULL, 0, N'NA', N'NA', N'NA')
INSERT [dbo].[Commission] ([Id], [EmployeeId], [EmployeeType], [CommissionType], [Amount], [IsPaid], [Title], [InvoiceId], [HospitalId], [DateTime], [CreatedTime], [UpdatedTime], [MainInvoiceId], [PaymentGroup], [MainInvoiceCode], [InvoiceCode], [PercentOrValue], [InvoiceTotal], [LessAmount], [SpecialAmount], [Category], [InvoiceCreatedTime], [InvoiceDiagnosticTestId], [IsPaidFinally], [PaymentId], [ReceiptCreatedTime], [BarCodeImageUrl]) VALUES (N'416a6f75-bd2d-4d7b-be2b-be514ba7b29c', N'45c6d504-e6fb-4da1-9454-92195a3dba94', N'Doctor', N'X-Ray ', -122.72727272727273, 1, N'', N'3a2adaca-9159-4647-bc0b-18d813f92306', N'd821cd9f-ac10-4f94-92cf-c292cd83b2c0', NULL, CAST(N'2018-07-20T11:42:34.5133333' AS DateTime2), CAST(N'2018-09-04T22:21:52.4566667' 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'41c8fe37-c2fe-44e2-9013-e3e1d4e8821f', N'2f49ff36-b04f-4081-9261-60ec973da26d', N'Referral', N'Serology ', 3000, 0, N'', N'bf6974a6-9f9e-4640-bd8f-535bab6e4eab', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2019-01-08T11:21:49.4361927' AS DateTime2), CAST(N'2019-02-03T08:17:35.7629175' AS DateTime2), N'NOTASSIGNED', N'NCR0114', NULL, N'NCDG0093', N'10%', 13139963.79, 1000, 0, N'Test', CAST(N'2019-01-07T16:47:29.0000000' AS DateTime2), NULL, 1, NULL, N'03-02-2019 8:17 AM', N'data:image/jpeg;base64,[encoded data, 8380 characters]')
INSERT [dbo].[Commission] ([Id], [EmployeeId], [EmployeeType], [CommissionType], [Amount], [IsPaid], [Title], [InvoiceId], [HospitalId], [DateTime], [CreatedTime], [UpdatedTime], [MainInvoiceId], [PaymentGroup], [MainInvoiceCode], [InvoiceCode], [PercentOrValue], [InvoiceTotal], [LessAmount], [SpecialAmount], [Category], [InvoiceCreatedTime], [InvoiceDiagnosticTestId], [IsPaidFinally], [PaymentId], [ReceiptCreatedTime], [BarCodeImageUrl]) VALUES (N'41f46498-f454-452b-8fee-d5b99dcda4eb', N'8d3cf8f9-7ef7-4008-b529-e05a062b3f0c', N'Referral', N'CombineCategory_1', 12.3, 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'42199624-b121-4104-8993-0e5f9bb1a73b', N'2f49ff36-b04f-4081-9261-60ec973da26d', N'Doctor', N'Serology ', 240.6, 0, N'', N'34fc05d9-22b2-478c-9ca0-f9a14d2e39a3', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2018-11-22T15:12:52.0755000' AS DateTime2), CAST(N'2018-12-22T16:17:56.9948653' AS DateTime2), N'NOTASSIGNED', NULL, NULL, N'NCDG0050', N'10%', 7322.92, 822.8, 0, N'Test', CAST(N'2018-11-22T15:12:50.9855282' AS DateTime2), NULL, 1, N'NA', N'NA', N'NA')
INSERT [dbo].[Commission] ([Id], [EmployeeId], [EmployeeType], [CommissionType], [Amount], [IsPaid], [Title], [InvoiceId], [HospitalId], [DateTime], [CreatedTime], [UpdatedTime], [MainInvoiceId], [PaymentGroup], [MainInvoiceCode], [InvoiceCode], [PercentOrValue], [InvoiceTotal], [LessAmount], [SpecialAmount], [Category], [InvoiceCreatedTime], [InvoiceDiagnosticTestId], [IsPaidFinally], [PaymentId], [ReceiptCreatedTime], [BarCodeImageUrl]) VALUES (N'421d619c-0547-481b-8a87-dac126bd5330', N'2f49ff36-b04f-4081-9261-60ec973da26d', N'UltraSoundDoctor', N'UltraSoundCategory_2', 0, 0, N'', N'9ec3c26c-7cfa-44f4-8e24-98f3073d3ea5', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2018-12-06T15:26:18.3306681' 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'246e9dcc-f633-4dd3-b1dc-2ec6dbe31e30', 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'430966d6-42a9-4e6b-a494-9faaea4ade60', N'f58ff95f-89e6-4f8e-8868-a83828ebe999', N'Referral', N'CT_2', 182, 0, N'', N'8be24963-914e-473d-b269-d80182e42daf', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2018-11-25T08:59:06.4224617' AS DateTime2), CAST(N'2018-12-22T16:17:56.9948653' AS DateTime2), N'NOTASSIGNED', NULL, NULL, N'NCDG0054', N'40%', 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'43c5eb7d-409d-443c-877e-d842750c4f39', N'7aea2b0b-c196-4bd2-b220-d9be9dee7688', N'Doctor', N'Pathology', -78.260869565217391, 1, N'', N'62d767ec-8bd8-4515-8ae8-7ed535ddcc82', N'd821cd9f-ac10-4f94-92cf-c292cd83b2c0', NULL, CAST(N'2018-07-25T17:14:58.8566667' AS DateTime2), CAST(N'2018-09-04T22:35:23.0500000' AS DateTime2), N'de745a7c-c5b9-467e-8a74-1a979fe92952', N'RR0010', 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'43fa22e9-9615-4022-a473-93ebb263f9c9', N'8d3cf8f9-7ef7-4008-b529-e05a062b3f0c', N'Doctor', N'CLINIC_REFERRAL', 1000, 0, N'ClinicInvoice', N'NOTASSIGNED', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2018-12-15T12:11:29.1104493' AS DateTime2), CAST(N'2018-12-22T16:17:56.9948653' AS DateTime2), N'16bc03aa-d22d-4e2d-b340-064db2437f49', NULL, N'NCINV0035', N'NOTASSIGNED', N'1000', NULL, 0, 0, N'OPERATION', CAST(N'2018-12-15T11:42:11.8911327' 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'45648d76-451b-457e-a2e6-24698934336e', N'2f49ff36-b04f-4081-9261-60ec973da26d', N'Doctor', N'CLINIC_REFERRAL', 10000, 1, N'ClinicInvoice', N'76144d28-aab5-4104-9701-80c08a68d12d', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2018-12-26T08:10:12.8453543' AS DateTime2), CAST(N'2018-12-27T12:05:15.6767843' AS DateTime2), N'0c6f2449-2e4f-489d-8372-860af4eabf75', N'NCR0094', N'NCINV0041', N'NOTASSIGNED', N'10000', NULL, 0, 0, N'OPERATION', CAST(N'2018-12-26T08:03:39.7660177' AS DateTime2), NULL, 1, N'NCP0021', N'26-Dec-18 11:57 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'4605769b-8bde-4507-8921-cf900960844b', N'cbfa4e4e-2fdf-48c7-9b94-e4712cf1f267', N'Referral', N'Serology', 10, 1, N'', N'71c3fad3-2aae-4fe9-8bc1-a18f3de9d7a5', N'd821cd9f-ac10-4f94-92cf-c292cd83b2c0', NULL, CAST(N'2018-09-04T12:53:28.7266667' AS DateTime2), CAST(N'2018-09-04T22:21:52.4566667' AS DateTime2), N'2346f319-0301-40bc-baf6-6322a20a765e', N'RR0051', N'RINV0193', N'RDG0212', N'40%', 100, 50, 0, N'Test', CAST(N'2018-09-04T10:48:55.3833333' 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'466a76e4-c79a-4d61-b812-d158ce18a341', 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.3324493' 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'c1c742fb-b723-4bd5-8787-0443b79eb4aa', 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'46a13a69-d91a-4602-9ce2-889bda08a93d', N'410f20e6-ad68-450b-9cf3-55da4793042c', N'Referral', N'Serology ', 145, 0, N'', N'2a4569a0-70ab-4888-a205-af406c84856d', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2019-01-07T09:32:32.6414648' 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'46af3a6d-1bb2-4dc2-a8ee-954768848950', N'1fc95b60-c117-4163-b73d-37bd64d7fac8', N'Doctor', N'ASSISTANT_DOCTOR', 1200, 0, N'KidneyOP_1', N'93443976-2220-48f9-8268-cdecc45440be', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2018-12-19T11:04:05.1692651' AS DateTime2), CAST(N'2018-12-22T16:17:56.9948653' AS DateTime2), N'83281dd4-5998-4b90-bd4f-ad30ae28cfa6', NULL, N'NCINV0036', N'NOTASSIGNED', N'1200', 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'46ef6f68-9c1e-4336-a76f-573b281ed83b', N'f58ff95f-89e6-4f8e-8868-a83828ebe999', N'Doctor', N'CombineCategory_1', 50, 1, N'', N'36168919-2b9e-4dfc-ab56-e5b1c262953c', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2018-11-26T14:04:47.8794844' AS DateTime2), CAST(N'2018-12-22T16:36:50.0944030' AS DateTime2), N'NOTASSIGNED', N'NCR0009', NULL, N'NCDG0058', N'10%', 4228, 0, 0, N'Test+OverAllAmount', CAST(N'2018-11-26T14:04:47.7314583' AS DateTime2), NULL, 1, N'NA', N'NA', N'NA')
INSERT [dbo].[Commission] ([Id], [EmployeeId], [EmployeeType], [CommissionType], [Amount], [IsPaid], [Title], [InvoiceId], [HospitalId], [DateTime], [CreatedTime], [UpdatedTime], [MainInvoiceId], [PaymentGroup], [MainInvoiceCode], [InvoiceCode], [PercentOrValue], [InvoiceTotal], [LessAmount], [SpecialAmount], [Category], [InvoiceCreatedTime], [InvoiceDiagnosticTestId], [IsPaidFinally], [PaymentId], [ReceiptCreatedTime], [BarCodeImageUrl]) VALUES (N'47d32454-6917-495b-ab31-2f1120713dc4', N'6ee087eb-7031-408f-b4ea-f567d250f75b', N'Referral', N'Biochemistry ', 202.5, 0, N'', N'd8f7316a-aa7f-478e-83c8-4e5f01b66a0e', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2019-01-29T16:08:58.0972028' 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'48306410-b027-4c6e-8f33-8243871eb15d', 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.5615584' 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'd4032a8c-42d9-4508-8370-f8e7d197b026', 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'48417f95-309d-442f-940c-e17ee1dc4a44', N'2f49ff36-b04f-4081-9261-60ec973da26d', N'Doctor', N'Biochemistry ', 275, 1, N'', N'2cdef65a-d591-46b7-ad79-ef086a35d066', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2019-01-19T11:10:16.3810717' AS DateTime2), CAST(N'2019-01-19T13:30:28.8103209' AS DateTime2), N'NOTASSIGNED', N'NCR0102', NULL, N'NCDG0105', N'10%', 2750, 0, 0, N'Test', CAST(N'2019-01-19T11:10:16.0473058' AS DateTime2), NULL, 1, N'NCP0046', N'19-Jan-19 1:30 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'48d48408-cbfe-4799-b50d-fb1c276e3e4a', N'95b82f5e-e170-495e-a68b-05cf1af9bd8c', N'Referral', N'Ultrasound', 0, 1, N'', N'1bee162c-dfdd-4c12-a638-e404433bc0b8', N'd821cd9f-ac10-4f94-92cf-c292cd83b2c0', NULL, CAST(N'2018-08-04T13:21:15.8866667' AS DateTime2), CAST(N'2018-09-04T22:21:52.4466667' AS DateTime2), N'a59f415e-29da-4177-8cf0-d6235ae37f30', N'RR0047', N'RINV0091', N'RDG0108', N'0', 1000, 0, 1000, N'Test', CAST(N'2018-08-04T13:16:06.6233333' 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'49f924c1-6d19-40aa-824a-0bee06e34f34', N'4c772c03-ef45-492a-82d7-24bd49320ea3', N'Referral', N'Biochemistry ', 75, 1, N'', N'b01fe88e-fcaa-4de7-a420-a19e83dbe3ad', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2018-12-23T11:10:28.1677302' AS DateTime2), CAST(N'2018-12-23T11:12:58.7587218' AS DateTime2), N'NOTASSIGNED', N'NCR0076', NULL, N'NCDG0073', N'10%', 675, 75, 0, N'Test', CAST(N'2018-12-23T11:10:28.0861181' 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'4a3aac5a-8682-4dec-8e79-192af983bcc7', N'7a432ef3-78e3-4091-811b-11fc802fb981', N'Doctor', N'Pathology (Combination)', -316.66666666666669, 1, N'', N'32efb69d-feb4-42a5-b5d8-9365511f01dc', N'd821cd9f-ac10-4f94-92cf-c292cd83b2c0', NULL, CAST(N'2018-07-15T10:46:11.1700000' AS DateTime2), CAST(N'2018-09-04T22:21:52.4466667' AS DateTime2), N'a09d1933-a42e-4b01-8f2f-08ffd0109967', N'RR0042', N'RINV0009', N'RDG0026', N'0%', 2300, 1150, 0, N'Test', CAST(N'2018-07-15T10:05:42.1766667' AS DateTime2), NULL, 0, N'NA', N'NA', N'NA')
INSERT [dbo].[Commission] ([Id], [EmployeeId], [EmployeeType], [CommissionType], [Amount], [IsPaid], [Title], [InvoiceId], [HospitalId], [DateTime], [CreatedTime], [UpdatedTime], [MainInvoiceId], [PaymentGroup], [MainInvoiceCode], [InvoiceCode], [PercentOrValue], [InvoiceTotal], [LessAmount], [SpecialAmount], [Category], [InvoiceCreatedTime], [InvoiceDiagnosticTestId], [IsPaidFinally], [PaymentId], [ReceiptCreatedTime], [BarCodeImageUrl]) VALUES (N'4a51d639-5e9c-44eb-9ce2-fb2e33479d3e', N'6ee087eb-7031-408f-b4ea-f567d250f75b', N'Doctor', N'Biochemistry ', 38547.9, 0, N'', N'bf6974a6-9f9e-4640-bd8f-535bab6e4eab', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2019-01-08T09:15:03.6394705' AS DateTime2), CAST(N'2019-02-03T08:17:35.7629175' AS DateTime2), N'NOTASSIGNED', N'NCR0114', NULL, N'NCDG0093', N'27%', 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'4b0f57b9-08aa-4256-aeb0-f2b06ee78c37', N'f58ff95f-89e6-4f8e-8868-a83828ebe999', N'Doctor', N'CombineCategory_1', 12.3, 0, N'', N'86636fc7-fea3-4e6c-ad30-5f4bea4f8417', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2018-11-24T13:30:55.9333426' 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'4b37cda8-99c4-49ec-8a85-c60628fb9352', N'f58ff95f-89e6-4f8e-8868-a83828ebe999', N'Doctor', N'DoctorVisit', 1000, 0, N'', N'NOTASSIGNED', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2018-12-19T09:21:17.8886749' AS DateTime2), CAST(N'2018-12-22T16:17:56.9948653' AS DateTime2), N'83281dd4-5998-4b90-bd4f-ad30ae28cfa6', NULL, N'NCINV0036', 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'4b6e4d04-133c-4b27-952b-2ace2f65895b', N'7b3c0574-a184-4081-9a43-0b8360b4e107', N'Doctor', N'ANESTHESIA_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.4784315' AS DateTime2), CAST(N'2018-12-20T11:28:03.0130366' AS DateTime2), N'83281dd4-5998-4b90-bd4f-ad30ae28cfa6', N'NCR0053', N'NCINV0036', N'NCINV0036', N'1000', NULL, 0, 0, N'Operation', CAST(N'2018-12-17T08:58:44.1210899' AS DateTime2), NULL, 0, N'NA', N'NA', N'NA')
INSERT [dbo].[Commission] ([Id], [EmployeeId], [EmployeeType], [CommissionType], [Amount], [IsPaid], [Title], [InvoiceId], [HospitalId], [DateTime], [CreatedTime], [UpdatedTime], [MainInvoiceId], [PaymentGroup], [MainInvoiceCode], [InvoiceCode], [PercentOrValue], [InvoiceTotal], [LessAmount], [SpecialAmount], [Category], [InvoiceCreatedTime], [InvoiceDiagnosticTestId], [IsPaidFinally], [PaymentId], [ReceiptCreatedTime], [BarCodeImageUrl]) VALUES (N'4ba4bd94-bdcd-4ede-9167-491edac73200', N'6ee087eb-7031-408f-b4ea-f567d250f75b', N'Doctor', N'Serology ', 5400, 0, N'', N'bf6974a6-9f9e-4640-bd8f-535bab6e4eab', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2019-01-08T11:21:49.3741853' AS DateTime2), CAST(N'2019-02-03T08:17:35.7629175' AS DateTime2), N'NOTASSIGNED', N'NCR0114', NULL, N'NCDG0093', N'18%', 13139963.79, 1000, 0, N'Test', CAST(N'2019-01-07T16:47:29.0000000' AS DateTime2), NULL, 1, NULL, N'03-02-2019 8:17 AM', N'data:image/jpeg;base64,[encoded data, 8380 characters]')
INSERT [dbo].[Commission] ([Id], [EmployeeId], [EmployeeType], [CommissionType], [Amount], [IsPaid], [Title], [InvoiceId], [HospitalId], [DateTime], [CreatedTime], [UpdatedTime], [MainInvoiceId], [PaymentGroup], [MainInvoiceCode], [InvoiceCode], [PercentOrValue], [InvoiceTotal], [LessAmount], [SpecialAmount], [Category], [InvoiceCreatedTime], [InvoiceDiagnosticTestId], [IsPaidFinally], [PaymentId], [ReceiptCreatedTime], [BarCodeImageUrl]) VALUES (N'4c661fbe-739f-4bcb-a809-8da96bf43150', N'7aea2b0b-c196-4bd2-b220-d9be9dee7688', N'Doctor', N'Pathology', -28.378378378378379, 1, N'', N'f3e6d38d-8ac1-45df-8b17-e4b6686bcbb1', N'd821cd9f-ac10-4f94-92cf-c292cd83b2c0', NULL, CAST(N'2018-07-25T15:32:20.8100000' AS DateTime2), CAST(N'2018-09-04T22:35:23.0233333' AS DateTime2), N'ff0ebd31-f7bc-498c-b664-2e56792867c1', N'RR0011', N'RINV0040', N'RDG0060', N'0%', 1800, 420, 0, N'Test', CAST(N'2018-07-25T15:23:31.7466667' AS DateTime2), NULL, 0, N'NA', N'NA', N'NA')
INSERT [dbo].[Commission] ([Id], [EmployeeId], [EmployeeType], [CommissionType], [Amount], [IsPaid], [Title], [InvoiceId], [HospitalId], [DateTime], [CreatedTime], [UpdatedTime], [MainInvoiceId], [PaymentGroup], [MainInvoiceCode], [InvoiceCode], [PercentOrValue], [InvoiceTotal], [LessAmount], [SpecialAmount], [Category], [InvoiceCreatedTime], [InvoiceDiagnosticTestId], [IsPaidFinally], [PaymentId], [ReceiptCreatedTime], [BarCodeImageUrl]) VALUES (N'4c711abc-f10e-4702-af0a-dafedb2a38c3', N'65ba8697-497a-4f36-bd6c-668eba0c5d62', N'Referral', N'Conbination', 0, 0, N'', N'9b1d0359-6b2c-4b7a-8e6f-121aed43f2b7', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2019-01-14T10:55:20.4495433' AS DateTime2), CAST(N'2019-02-03T08:17:35.7629175' AS DateTime2), N'NOTASSIGNED', N'NCR0114', NULL, N'NCDG0100', N'0%', 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'4c8ded5f-e053-49e3-a751-e097900c49f9', N'4c772c03-ef45-492a-82d7-24bd49320ea3', N'Doctor', N'Biochemistry ', 25, 0, N'', N'95330de0-a5b7-4d94-a289-175147c7848b', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2019-01-09T12:23:07.7306090' 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'4c9d60b3-5e70-4a06-8bd2-5d8b6e23d5be', N'2f49ff36-b04f-4081-9261-60ec973da26d', N'Doctor', N'Ultrasound', 70, 0, N'', N'34fc05d9-22b2-478c-9ca0-f9a14d2e39a3', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2018-11-22T15:12:52.0685038' AS DateTime2), CAST(N'2018-12-22T16:17:56.9948653' AS DateTime2), N'NOTASSIGNED', NULL, NULL, N'NCDG0050', N'10%', 7322.92, 822.8, 0, N'Test', CAST(N'2018-11-22T15:12:50.9855282' AS DateTime2), NULL, 1, N'NA', N'NA', N'NA')
INSERT [dbo].[Commission] ([Id], [EmployeeId], [EmployeeType], [CommissionType], [Amount], [IsPaid], [Title], [InvoiceId], [HospitalId], [DateTime], [CreatedTime], [UpdatedTime], [MainInvoiceId], [PaymentGroup], [MainInvoiceCode], [InvoiceCode], [PercentOrValue], [InvoiceTotal], [LessAmount], [SpecialAmount], [Category], [InvoiceCreatedTime], [InvoiceDiagnosticTestId], [IsPaidFinally], [PaymentId], [ReceiptCreatedTime], [BarCodeImageUrl]) VALUES (N'4cabd034-1418-41bf-a4c9-ee4c444b9431', 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.4615888' 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'f6af8370-5e03-4c6f-ae03-b9088a868cdc', 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'4d3f25bb-6678-4e2d-aada-a649c60a9974', N'f58ff95f-89e6-4f8e-8868-a83828ebe999', 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.5772977' 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'7d6ecc70-328c-493d-913b-5b3579bf74d2', 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'4d4a444b-1cc5-46c7-be11-d73d29b3702c', N'4c772c03-ef45-492a-82d7-24bd49320ea3', N'Doctor', N'Biochemistry ', 0, 0, N'', N'8be24963-914e-473d-b269-d80182e42daf', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2018-11-25T08:59:06.4224617' AS DateTime2), CAST(N'2018-12-22T16:17:56.9948653' AS DateTime2), N'NOTASSIGNED', NULL, NULL, N'NCDG0054', N'0%', 4699.8, 522.2, 0, N'Test', CAST(N'2018-11-25T08:59:05.7217518' AS DateTime2), NULL, 1, N'NA', N'NA', N'NA')
INSERT [dbo].[Commission] ([Id], [EmployeeId], [EmployeeType], [CommissionType], [Amount], [IsPaid], [Title], [InvoiceId], [HospitalId], [DateTime], [CreatedTime], [UpdatedTime], [MainInvoiceId], [PaymentGroup], [MainInvoiceCode], [InvoiceCode], [PercentOrValue], [InvoiceTotal], [LessAmount], [SpecialAmount], [Category], [InvoiceCreatedTime], [InvoiceDiagnosticTestId], [IsPaidFinally], [PaymentId], [ReceiptCreatedTime], [BarCodeImageUrl]) VALUES (N'4d5efc70-a96c-4b1c-8feb-3e4f53320489', N'8d3cf8f9-7ef7-4008-b529-e05a062b3f0c', N'Doctor', N'ASSISTANT_SURGEON', 2220, 0, N'KidneyOP_1', N'9a924f8e-9b6c-487b-b362-4bd5f203f570', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2019-01-16T12:01:42.8256895' AS DateTime2), CAST(N'2019-02-03T08:17:35.7629175' AS DateTime2), N'54863b24-e825-429a-9631-211c636d6bd2', N'NCR0114', N'NCINV0049', N'NCINV0049', N'2220', NULL, 0, 0, N'Operation', CAST(N'2019-01-16T12:01:42.6787804' 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'4ed5a5ff-a614-4fb5-9725-2831defa20bf', N'4c772c03-ef45-492a-82d7-24bd49320ea3', N'Doctor', N'CLINIC_REFERRAL', 1000, 0, N'ClinicInvoice', N'NOTASSIGNED', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2018-12-15T12:12:25.0889355' AS DateTime2), CAST(N'2018-12-22T16:17:56.9948653' AS DateTime2), N'16bc03aa-d22d-4e2d-b340-064db2437f49', NULL, N'NCINV0035', N'NOTASSIGNED', N'1000', NULL, 0, 0, N'OPERATION', CAST(N'2018-12-15T11:42:11.8911327' 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'4f293d8a-3c1e-48f9-8b74-029ff68f679a', N'4c772c03-ef45-492a-82d7-24bd49320ea3', N'Referral', N'Biochemistry ', 50, 0, N'', N'cb1010ec-1a5e-48c3-ac2a-9de923623b95', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2018-11-21T16:09:31.5826775' AS DateTime2), CAST(N'2018-12-22T16:17:56.9948653' AS DateTime2), N'NOTASSIGNED', NULL, NULL, N'NCDG0045', N'10%', 3694.6800000000003, 10, 0, N'Test', CAST(N'2018-11-21T16:09:31.4866487' 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'4f59d602-b678-4450-a787-05bb030f9c1e', N'f58ff95f-89e6-4f8e-8868-a83828ebe999', N'Doctor', N'CombineCategory_1', 12.3, 0, N'', N'bedb87d2-f0f8-4b88-8875-34e408073588', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2018-11-24T09:11:24.1341905' AS DateTime2), CAST(N'2018-12-22T16:17:56.9948653' AS DateTime2), N'NOTASSIGNED', NULL, NULL, N'NCDG0051', N'10%', 873, 0, 0, N'Test', CAST(N'2018-11-24T09:11:22.9214992' AS DateTime2), NULL, 1, N'NA', N'NA', N'NA')
INSERT [dbo].[Commission] ([Id], [EmployeeId], [EmployeeType], [CommissionType], [Amount], [IsPaid], [Title], [InvoiceId], [HospitalId], [DateTime], [CreatedTime], [UpdatedTime], [MainInvoiceId], [PaymentGroup], [MainInvoiceCode], [InvoiceCode], [PercentOrValue], [InvoiceTotal], [LessAmount], [SpecialAmount], [Category], [InvoiceCreatedTime], [InvoiceDiagnosticTestId], [IsPaidFinally], [PaymentId], [ReceiptCreatedTime], [BarCodeImageUrl]) VALUES (N'501534f7-5502-4b32-8135-5ad593683858', N'35471cdd-86e8-4eb1-8532-e96a2ba5ea2f', N'Referral', N'Hematology', 40, 1, N'', N'78375895-ab72-4a5c-b4a1-3153afdf3fca', N'd821cd9f-ac10-4f94-92cf-c292cd83b2c0', NULL, CAST(N'2018-08-03T15:10:57.5500000' AS DateTime2), CAST(N'2018-09-04T22:21:52.4500000' 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'501b3fe6-85fd-4f01-9ee8-ab9b035c3fa2', N'24a50fd4-8d08-41d3-94e5-be95c9e77925', N'Doctor', N'Ultrasound', 0, 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.4500000' AS DateTime2), N'025708d8-b827-49dc-86c0-6791345cbdc0', N'RR0044', N'RINV0007', N'RDG0023', N'0%', 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'50384031-9fcf-408d-b3f0-b1d57897be0c', N'2f49ff36-b04f-4081-9261-60ec973da26d', N'Doctor', N'CLINIC_REFERRAL', 55, 0, N'ClinicInvoice', N'NOTASSIGNED', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2018-12-20T16:09:43.9138958' AS DateTime2), CAST(N'2018-12-22T16:17:56.9948653' AS DateTime2), N'e442f9c5-c767-48c4-a0e9-983012f4bb00', NULL, N'NCINV0039', N'NOTASSIGNED', N'55', 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'5107faa2-7754-4c23-8770-6cc76ca56a84', N'2f49ff36-b04f-4081-9261-60ec973da26d', N'Doctor', N'SPECIAL_SURGEON', 2220, 0, N'KidneyOP_1', N'9a924f8e-9b6c-487b-b362-4bd5f203f570', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2019-01-16T12:01:42.8276884' AS DateTime2), CAST(N'2019-02-03T08:17:35.7629175' AS DateTime2), N'54863b24-e825-429a-9631-211c636d6bd2', N'NCR0114', N'NCINV0049', N'NCINV0049', N'2220', NULL, 0, 0, N'Operation', CAST(N'2019-01-16T12:01:42.6787804' 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'517a0746-6142-4cd3-86c6-1986c7d24dd4', N'8d3cf8f9-7ef7-4008-b529-e05a062b3f0c', N'Doctor', N'CLINIC_REFERRAL', 1000, 1, N'ClinicInvoice', N'd4418669-e2cc-43dd-8db5-d8992e3e5d86', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2018-12-20T13:29:25.7070388' AS DateTime2), CAST(N'2018-12-20T13:41:31.9084452' AS DateTime2), N'ebce39be-4d21-4251-835d-2620dd8fe8aa', N'NCR0059', N'NCINV0037', N'NOTASSIGNED', N'1000', NULL, 0, 0, N'OPERATION', CAST(N'2018-12-20T13:27:39.5305824' 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'51fff0fc-31a8-4d7a-8868-b4aae3c279ea', N'4c772c03-ef45-492a-82d7-24bd49320ea3', N'Doctor', N'UltraSoundCategory_1', 117.75, 0, N'', N'3e34586b-5b04-4755-ae22-5694878a495e', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2019-01-21T15:49:34.8268283' AS DateTime2), CAST(N'2019-02-03T08:17:35.7629175' AS DateTime2), N'NOTASSIGNED', N'NCR0114', NULL, N'NCDG0107', N'15%', 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'5221d26c-5d64-494d-9baa-a24177c66141', N'aa1bef3d-ea7c-404a-9d19-2347fcd8fad9', N'Doctor', N'Pathology', -51.162790697674417, 1, N'', N'7a054570-a86b-44e4-b924-ce2c3d1cd64e', N'd821cd9f-ac10-4f94-92cf-c292cd83b2c0', NULL, CAST(N'2018-07-16T17:41:26.7100000' AS DateTime2), CAST(N'2018-09-04T22:21:52.4533333' AS DateTime2), N'f2724c66-005f-4357-b7a5-3ab67b54cea0', N'RR0041', N'RINV0015', N'RDG0032', N'0%', 1600, 550, 0, N'Test', CAST(N'2018-07-16T17:21:37.3566667' AS DateTime2), NULL, 0, N'NA', N'NA', N'NA')
INSERT [dbo].[Commission] ([Id], [EmployeeId], [EmployeeType], [CommissionType], [Amount], [IsPaid], [Title], [InvoiceId], [HospitalId], [DateTime], [CreatedTime], [UpdatedTime], [MainInvoiceId], [PaymentGroup], [MainInvoiceCode], [InvoiceCode], [PercentOrValue], [InvoiceTotal], [LessAmount], [SpecialAmount], [Category], [InvoiceCreatedTime], [InvoiceDiagnosticTestId], [IsPaidFinally], [PaymentId], [ReceiptCreatedTime], [BarCodeImageUrl]) VALUES (N'527721d5-1d44-492b-9660-dbf8e5b56265', N'f58ff95f-89e6-4f8e-8868-a83828ebe999', N'UltraSoundDoctor', N'UltraSoundCategory_1', 300, 1, N'', N'1d6045a7-1375-41cd-a3b1-166e195225d2', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2018-12-02T15:59:13.8006029' AS DateTime2), CAST(N'2018-12-03T11:26:13.7257962' AS DateTime2), N'NOTASSIGNED', N'NCR0015', N'NOTASSIGNED', N'NCDG0062', NULL, 891, 89.1, 0, N'test', CAST(N'2018-12-02T15:59:13.6286735' AS DateTime2), NULL, 0, N'NA', N'NA', N'NA')
INSERT [dbo].[Commission] ([Id], [EmployeeId], [EmployeeType], [CommissionType], [Amount], [IsPaid], [Title], [InvoiceId], [HospitalId], [DateTime], [CreatedTime], [UpdatedTime], [MainInvoiceId], [PaymentGroup], [MainInvoiceCode], [InvoiceCode], [PercentOrValue], [InvoiceTotal], [LessAmount], [SpecialAmount], [Category], [InvoiceCreatedTime], [InvoiceDiagnosticTestId], [IsPaidFinally], [PaymentId], [ReceiptCreatedTime], [BarCodeImageUrl]) VALUES (N'53107cec-d5a8-4192-81da-77a032c851c5', N'8d3cf8f9-7ef7-4008-b529-e05a062b3f0c', N'Doctor', N'CLINIC_REFERRAL', 330, 0, N'ClinicInvoice', N'ff25da13-b5a8-402b-9289-62c6063c562c', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2019-01-16T11:58:47.1146318' AS DateTime2), CAST(N'2019-02-03T08:17:35.7629175' AS DateTime2), N'54863b24-e825-429a-9631-211c636d6bd2', N'NCR0114', N'NCINV0049', N'NOTASSIGNED', N'330', NULL, 0, 0, N'OPERATION', CAST(N'2019-01-16T11:58:14.6954208' 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'5400310c-b9e7-4790-9053-6843cc0dbc97', N'65ba8697-497a-4f36-bd6c-668eba0c5d62', N'Doctor', N'ASSISTANT_DOCTOR', 33, 1, N'KidneyOP_1', N'3d4646d1-0c53-413f-9e23-9783787d8522', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2018-12-26T12:45:43.9196323' AS DateTime2), CAST(N'2018-12-27T12:05:15.6667547' AS DateTime2), N'0c6f2449-2e4f-489d-8372-860af4eabf75', N'NCR0097', N'NCINV0041', N'NCINV0041', N'33', NULL, 0, 0, N'Operation', CAST(N'2018-12-26T12:45:35.8356009' AS DateTime2), NULL, 1, N'NCP0034', N'27-Dec-18 10:26 AM', N'data:image/png;base64,[encoded data, 8612 characters]')
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'5534e1dd-9ecf-49a0-8768-42c085bbceb9', 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.9500000' AS DateTime2), CAST(N'2018-09-04T22:21:52.4533333' 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'575b9725-88da-445f-a249-34b365dab603', N'f58ff95f-89e6-4f8e-8868-a83828ebe999', N'Doctor', N'UltraSoundCategory_2', 122.2, 0, N'', N'1d6045a7-1375-41cd-a3b1-166e195225d2', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2018-12-02T15:59:13.9351515' AS DateTime2), CAST(N'2018-12-22T16:17:56.9948653' AS DateTime2), N'NOTASSIGNED', NULL, NULL, N'NCDG0062', N'20%', 801.9, 89.1, 0, N'Test', CAST(N'2018-12-02T15:59:13.6286735' AS DateTime2), NULL, 1, N'NA', N'NA', N'NA')
INSERT [dbo].[Commission] ([Id], [EmployeeId], [EmployeeType], [CommissionType], [Amount], [IsPaid], [Title], [InvoiceId], [HospitalId], [DateTime], [CreatedTime], [UpdatedTime], [MainInvoiceId], [PaymentGroup], [MainInvoiceCode], [InvoiceCode], [PercentOrValue], [InvoiceTotal], [LessAmount], [SpecialAmount], [Category], [InvoiceCreatedTime], [InvoiceDiagnosticTestId], [IsPaidFinally], [PaymentId], [ReceiptCreatedTime], [BarCodeImageUrl]) VALUES (N'5838052e-6a0b-47c7-b164-6ea39613e885', N'2f49ff36-b04f-4081-9261-60ec973da26d', N'Doctor', N'Biochemistry ', 75, 0, N'', N'3ff6014c-d50a-403a-bbf2-fea054d9aefd', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2019-01-24T09:54:38.5322869' AS DateTime2), CAST(N'2019-02-03T08:17:35.7629175' AS DateTime2), N'NOTASSIGNED', N'NCR0114', NULL, N'NCDG0108', N'10%', 1150, 0, 0, N'Test', CAST(N'2019-01-24T09:54:37.5792773' 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'58eb8fba-ae80-481c-8328-948ab5e0ef85', N'4c772c03-ef45-492a-82d7-24bd49320ea3', N'Doctor', N'Biochemistry ', 25, 0, N'', N'df1299d2-cda2-4ba9-9769-d0523eb341b4', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2019-02-02T10:03:26.7832383' AS DateTime2), CAST(N'2019-02-03T08:17:35.7629175' AS DateTime2), N'NOTASSIGNED', N'NCR0114', NULL, N'NCDG0113', N'10%', 619, 0, 0, N'Test', CAST(N'2019-02-02T10:03:23.6774660' 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'59ba2f16-f1a8-4002-9a5c-cbf33e5ae16e', N'8d3cf8f9-7ef7-4008-b529-e05a062b3f0c', N'Referral', N'Biochemistry ', 165, 1, N'', N'4561a3e0-d340-4da7-8094-1a2b3288fa16', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2019-02-02T10:06:56.6064049' AS DateTime2), CAST(N'2019-02-03T08:13:15.2195195' AS DateTime2), N'NOTASSIGNED', N'NCR0113', NULL, N'NCDG0114', N'22%', 917, 0, 0, N'Test', CAST(N'2019-02-02T10:06:56.3895443' AS DateTime2), NULL, 1, N'NCP0061', N'03-02-2019 8:13 AM', N'data:image/jpeg;base64,[encoded data, 8332 characters]')
INSERT [dbo].[Commission] ([Id], [EmployeeId], [EmployeeType], [CommissionType], [Amount], [IsPaid], [Title], [InvoiceId], [HospitalId], [DateTime], [CreatedTime], [UpdatedTime], [MainInvoiceId], [PaymentGroup], [MainInvoiceCode], [InvoiceCode], [PercentOrValue], [InvoiceTotal], [LessAmount], [SpecialAmount], [Category], [InvoiceCreatedTime], [InvoiceDiagnosticTestId], [IsPaidFinally], [PaymentId], [ReceiptCreatedTime], [BarCodeImageUrl]) VALUES (N'59d70be8-6c34-430e-b434-523dc08f1fc6', N'410f20e6-ad68-450b-9cf3-55da4793042c', N'Doctor', N'ASSISTANT_DOCTOR', 22, 0, N'KidneyOP_1', N'172d55ca-fd29-4f10-bb15-b9c83957b941', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2019-02-22T22:49:35.9633439' AS DateTime2), CAST(N'2019-02-22T22:49:35.9633439' AS DateTime2), N'd1039f90-a091-4ef6-ae6f-5c88d88c8fad', NULL, N'NCINV0064', N'NCINV0064', N'22', NULL, 0, 0, N'Operation', CAST(N'2019-02-22T22:49:35.7954201' AS DateTime2), NULL, 0, NULL, NULL, NULL)
INSERT [dbo].[Commission] ([Id], [EmployeeId], [EmployeeType], [CommissionType], [Amount], [IsPaid], [Title], [InvoiceId], [HospitalId], [DateTime], [CreatedTime], [UpdatedTime], [MainInvoiceId], [PaymentGroup], [MainInvoiceCode], [InvoiceCode], [PercentOrValue], [InvoiceTotal], [LessAmount], [SpecialAmount], [Category], [InvoiceCreatedTime], [InvoiceDiagnosticTestId], [IsPaidFinally], [PaymentId], [ReceiptCreatedTime], [BarCodeImageUrl]) VALUES (N'5a6638ef-5e55-4a55-9f34-a830b5a94b98', N'f58ff95f-89e6-4f8e-8868-a83828ebe999', N'Doctor', N'UltraSoundCategory_1', 4.92, 1, N'', N'003042e8-1731-43ad-a3cd-906998b3e07d', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2018-12-05T16:07:50.4607320' AS DateTime2), CAST(N'2018-12-06T10:02:43.5787530' AS DateTime2), N'NOTASSIGNED', N'NCR0028', NULL, N'NCDG0066', N'2%', 312.01, 199.99, 0, N'Test', CAST(N'2018-12-05T16:07:49.8740832' 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'5a8c5458-f388-46ca-b5f5-bdd9c4d19d8b', N'8d3cf8f9-7ef7-4008-b529-e05a062b3f0c', N'Doctor', N'Conbination', 66, 0, N'', N'db7cc987-1cd1-43f1-b548-dc824f9cb7d5', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2019-02-16T13:14:53.2591478' AS DateTime2), CAST(N'2019-02-16T13:33:40.8038303' AS DateTime2), N'NOTASSIGNED', NULL, NULL, N'NCDG0118', N'22%', 2075.3, 41.7, 0, N'Test', CAST(N'2019-02-16T09:07:54.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'5aec9d56-5707-4d54-a025-c5e2fea525ef', N'2f49ff36-b04f-4081-9261-60ec973da26d', N'Doctor', N'SPECIAL_SURGEON', 8900, 0, N'KidneyOP_1', N'67650f2a-cd2d-49fd-bc7e-5eefce820158', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2018-12-20T15:20:15.7690134' AS DateTime2), CAST(N'2018-12-22T16:17:56.9948653' AS DateTime2), N'e442f9c5-c767-48c4-a0e9-983012f4bb00', NULL, N'NCINV0039', N'NCINV0039', N'8900', NULL, 0, 0, N'Operation', CAST(N'2018-12-20T15:11:56.1774447' AS DateTime2), NULL, 1, N'NA', N'NA', N'NA')
INSERT [dbo].[Commission] ([Id], [EmployeeId], [EmployeeType], [CommissionType], [Amount], [IsPaid], [Title], [InvoiceId], [HospitalId], [DateTime], [CreatedTime], [UpdatedTime], [MainInvoiceId], [PaymentGroup], [MainInvoiceCode], [InvoiceCode], [PercentOrValue], [InvoiceTotal], [LessAmount], [SpecialAmount], [Category], [InvoiceCreatedTime], [InvoiceDiagnosticTestId], [IsPaidFinally], [PaymentId], [ReceiptCreatedTime], [BarCodeImageUrl]) VALUES (N'5b578a21-8c9f-42de-ae87-d662c78e4703', N'8d3cf8f9-7ef7-4008-b529-e05a062b3f0c', N'Doctor', N'ASSISTANT_SURGEON', 8900, 0, N'KidneyOP_1', N'67650f2a-cd2d-49fd-bc7e-5eefce820158', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2018-12-20T15:20:15.7690134' AS DateTime2), CAST(N'2018-12-22T16:17:56.9948653' AS DateTime2), N'e442f9c5-c767-48c4-a0e9-983012f4bb00', NULL, N'NCINV0039', N'NCINV0039', N'8900', NULL, 0, 0, N'Operation', CAST(N'2018-12-20T15:11:56.1774447' AS DateTime2), NULL, 1, N'NA', N'NA', N'NA')
INSERT [dbo].[Commission] ([Id], [EmployeeId], [EmployeeType], [CommissionType], [Amount], [IsPaid], [Title], [InvoiceId], [HospitalId], [DateTime], [CreatedTime], [UpdatedTime], [MainInvoiceId], [PaymentGroup], [MainInvoiceCode], [InvoiceCode], [PercentOrValue], [InvoiceTotal], [LessAmount], [SpecialAmount], [Category], [InvoiceCreatedTime], [InvoiceDiagnosticTestId], [IsPaidFinally], [PaymentId], [ReceiptCreatedTime], [BarCodeImageUrl]) VALUES (N'5be3b25a-2cef-429d-afe9-03b418f4885e', N'65ba8697-497a-4f36-bd6c-668eba0c5d62', N'Doctor', N'CombineCategory_1', 96.12, 0, N'', N'2a4569a0-70ab-4888-a205-af406c84856d', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2019-01-07T09:32:32.4942731' AS DateTime2), CAST(N'2019-02-03T08:17:35.7629175' AS DateTime2), N'NOTASSIGNED', N'NCR0114', NULL, N'NCDG0084', N'27%', 1993, 0, 0, N'Test', CAST(N'2019-01-07T09:32:31.1570702' AS DateTime2), NULL, 1, NULL, N'03-02-2019 8:17 AM', N'data:image/jpeg;base64,[encoded data, 8380 characters]')
INSERT [dbo].[Commission] ([Id], [EmployeeId], [EmployeeType], [CommissionType], [Amount], [IsPaid], [Title], [InvoiceId], [HospitalId], [DateTime], [CreatedTime], [UpdatedTime], [MainInvoiceId], [PaymentGroup], [MainInvoiceCode], [InvoiceCode], [PercentOrValue], [InvoiceTotal], [LessAmount], [SpecialAmount], [Category], [InvoiceCreatedTime], [InvoiceDiagnosticTestId], [IsPaidFinally], [PaymentId], [ReceiptCreatedTime], [BarCodeImageUrl]) VALUES (N'5c6dc7ed-33e8-405e-9689-34e68ce877e1', N'4c772c03-ef45-492a-82d7-24bd49320ea3', N'Doctor', N'UltraSoundCategory_2', 34.8, 1, N'', N'eb7be4be-6bd1-45ba-9031-6297b013383c', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2019-02-03T09:56:52.1035882' AS DateTime2), CAST(N'2019-02-23T12:47:31.8154487' AS DateTime2), N'NOTASSIGNED', N'NCR0119', NULL, N'NCDG0116', N'15%', 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'5cd82d8d-4130-4bcd-8c0d-4c213e29ffd8', N'f58ff95f-89e6-4f8e-8868-a83828ebe999', N'Doctor', 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.9363403' 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'5db440c7-7b69-44ce-abbc-afa2ad1f20d9', N'65ba8697-497a-4f36-bd6c-668eba0c5d62', N'Doctor', N'CLINIC_REFERRAL', 220, 0, N'ClinicInvoice', N'b2b26231-8c02-4d89-84ac-7c1595af6fe0', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2019-01-16T11:56:43.7047292' AS DateTime2), CAST(N'2019-02-03T08:17:35.7629175' AS DateTime2), N'382d7597-0685-443c-b918-7aab224db486', N'NCR0114', N'NCINV0048', N'NOTASSIGNED', N'220', NULL, 0, 0, N'OPERATION', CAST(N'2019-01-16T11:35:16.6739313' AS DateTime2), NULL, 1, NULL, N'03-02-2019 8:17 AM', N'data:image/jpeg;base64,[encoded data, 8380 characters]')
INSERT [dbo].[Commission] ([Id], [EmployeeId], [EmployeeType], [CommissionType], [Amount], [IsPaid], [Title], [InvoiceId], [HospitalId], [DateTime], [CreatedTime], [UpdatedTime], [MainInvoiceId], [PaymentGroup], [MainInvoiceCode], [InvoiceCode], [PercentOrValue], [InvoiceTotal], [LessAmount], [SpecialAmount], [Category], [InvoiceCreatedTime], [InvoiceDiagnosticTestId], [IsPaidFinally], [PaymentId], [ReceiptCreatedTime], [BarCodeImageUrl]) VALUES (N'5e42f0b8-7555-4c8d-b54a-9b35056f1fb7', N'2f49ff36-b04f-4081-9261-60ec973da26d', N'Doctor', N'ANESTHESIA_DOCTOR', 330, 0, N'KidneyOP_1', N'a335dccd-20b3-45b1-9268-5a34a1cb456d', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2019-02-16T16:56:13.3583072' AS DateTime2), CAST(N'2019-02-16T16:56:13.3583072' AS DateTime2), N'abb18202-7f6f-4a1b-86a2-5bcf1da3d8a7', NULL, N'NCINV0061', N'NCINV0061', N'330', 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'5ea6dac6-793a-4856-8672-4f96aacd543f', N'7a432ef3-78e3-4091-811b-11fc802fb981', N'Doctor', N'ECG/ECO', 20, 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.4566667' 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'5f1c0565-5800-4a01-95ed-a76497361f90', N'7b3c0574-a184-4081-9a43-0b8360b4e107', N'Doctor', N'SPECIAL_SURGEON', 0, 1, N'KidneyOP_1', N'a57d776c-6f61-4d28-b156-7ad6277382b5', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2019-01-17T11:47:54.9363261' AS DateTime2), CAST(N'2019-01-17T13:16:28.8426894' AS DateTime2), N'f253682d-6adc-4661-b133-62ba078575b5', NULL, N'NCINV0050', N'NCINV0050', N'0', NULL, 0, 0, N'Operation', CAST(N'0001-01-01T00:00:00.0000000' AS DateTime2), NULL, 0, N'NCP0041', 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'5f569413-f5d7-461f-9cee-7b23830b19b3', N'2f49ff36-b04f-4081-9261-60ec973da26d', N'Doctor', N'CLINIC_REFERRAL', 33, 0, N'ClinicInvoice', N'8c4bee08-86ab-48cf-9323-23660eb1e2c8', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2019-01-14T10:42:10.7514046' AS DateTime2), CAST(N'2019-02-03T08:17:35.7629175' AS DateTime2), N'ee0b1f7f-b2bc-46e2-abf6-e16c6d791ec1', N'NCR0114', N'NCINV0047', N'NOTASSIGNED', N'33', NULL, 0, 0, N'OPERATION', CAST(N'2019-01-14T10:42:01.7797406' AS DateTime2), NULL, 1, NULL, N'03-02-2019 8:17 AM', N'data:image/jpeg;base64,[encoded data, 8380 characters]')
INSERT [dbo].[Commission] ([Id], [EmployeeId], [EmployeeType], [CommissionType], [Amount], [IsPaid], [Title], [InvoiceId], [HospitalId], [DateTime], [CreatedTime], [UpdatedTime], [MainInvoiceId], [PaymentGroup], [MainInvoiceCode], [InvoiceCode], [PercentOrValue], [InvoiceTotal], [LessAmount], [SpecialAmount], [Category], [InvoiceCreatedTime], [InvoiceDiagnosticTestId], [IsPaidFinally], [PaymentId], [ReceiptCreatedTime], [BarCodeImageUrl]) VALUES (N'6031c249-6555-4e9d-9e71-746c760c4ce9', N'f58ff95f-89e6-4f8e-8868-a83828ebe999', N'Doctor', N'ASSIGNED_DOCTOR', 2220, 0, N'KidneyOP_1', N'9a924f8e-9b6c-487b-b362-4bd5f203f570', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2019-01-16T12:01:42.8047024' AS DateTime2), CAST(N'2019-02-03T08:17:35.7629175' AS DateTime2), N'54863b24-e825-429a-9631-211c636d6bd2', N'NCR0114', N'NCINV0049', N'NCINV0049', N'2220', NULL, 0, 0, N'Operation', CAST(N'2019-01-16T12:01:42.6787804' 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'6165681a-af92-4539-acd1-8e766d824635', N'cbfa4e4e-2fdf-48c7-9b94-e4712cf1f267', N'Referral', N'Hematology', -42.307692307692307, 1, N'', N'daf7c28c-4e05-453f-9b21-b814e85a24e9', N'd821cd9f-ac10-4f94-92cf-c292cd83b2c0', NULL, CAST(N'2018-09-04T12:34:13.3533333' AS DateTime2), CAST(N'2018-09-04T22:21:52.4566667' AS DateTime2), N'b165f658-f1e5-4e8d-902c-61e20171ec3c', N'RR0051', N'RINV0176', N'RDG0192', N'0%', 1200, 100, 0, N'Test', CAST(N'2018-09-01T10:23:20.5533333' AS DateTime2), NULL, 0, N'NA', N'NA', N'NA')
INSERT [dbo].[Commission] ([Id], [EmployeeId], [EmployeeType], [CommissionType], [Amount], [IsPaid], [Title], [InvoiceId], [HospitalId], [DateTime], [CreatedTime], [UpdatedTime], [MainInvoiceId], [PaymentGroup], [MainInvoiceCode], [InvoiceCode], [PercentOrValue], [InvoiceTotal], [LessAmount], [SpecialAmount], [Category], [InvoiceCreatedTime], [InvoiceDiagnosticTestId], [IsPaidFinally], [PaymentId], [ReceiptCreatedTime], [BarCodeImageUrl]) VALUES (N'6175d222-48ec-4b7a-a86a-75b23464bb3b', N'aa1bef3d-ea7c-404a-9d19-2347fcd8fad9', N'Doctor', N'Pathology', 100, 1, N'', N'cc6b598c-3380-46d1-a4e2-28dfc45b783e', N'd821cd9f-ac10-4f94-92cf-c292cd83b2c0', NULL, CAST(N'2018-07-23T14:55:31.1033333' AS DateTime2), CAST(N'2018-09-04T22:35:23.0266667' AS DateTime2), N'5610283e-bfdd-4559-813b-66c681d1914a', N'RR0012', 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'618ffab2-24de-4ec5-935d-18b03afae4cc', N'2f49ff36-b04f-4081-9261-60ec973da26d', N'Doctor', N'Biochemistry ', 158.3, 0, N'', N'34fc05d9-22b2-478c-9ca0-f9a14d2e39a3', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2018-11-22T15:12:52.0794986' AS DateTime2), CAST(N'2018-12-22T16:17:56.9948653' AS DateTime2), N'NOTASSIGNED', NULL, NULL, N'NCDG0050', N'10%', 7322.92, 822.8, 0, N'Test', CAST(N'2018-11-22T15:12:50.9855282' AS DateTime2), NULL, 1, N'NA', N'NA', N'NA')
INSERT [dbo].[Commission] ([Id], [EmployeeId], [EmployeeType], [CommissionType], [Amount], [IsPaid], [Title], [InvoiceId], [HospitalId], [DateTime], [CreatedTime], [UpdatedTime], [MainInvoiceId], [PaymentGroup], [MainInvoiceCode], [InvoiceCode], [PercentOrValue], [InvoiceTotal], [LessAmount], [SpecialAmount], [Category], [InvoiceCreatedTime], [InvoiceDiagnosticTestId], [IsPaidFinally], [PaymentId], [ReceiptCreatedTime], [BarCodeImageUrl]) VALUES (N'620e2bb1-9f85-4fb4-8ac3-03d35cf5295d', N'aa1bef3d-ea7c-404a-9d19-2347fcd8fad9', N'Doctor', N'Pathology', -63.95348837209302, 1, N'', N'7a054570-a86b-44e4-b924-ce2c3d1cd64e', N'd821cd9f-ac10-4f94-92cf-c292cd83b2c0', NULL, CAST(N'2018-07-16T17:41:26.6333333' AS DateTime2), CAST(N'2018-09-04T22:21:52.4566667' AS DateTime2), N'f2724c66-005f-4357-b7a5-3ab67b54cea0', N'RR0041', N'RINV0015', N'RDG0032', N'0%', 1600, 550, 0, N'Test', CAST(N'2018-07-16T17:21:37.3566667' AS DateTime2), NULL, 0, N'NA', N'NA', N'NA')
INSERT [dbo].[Commission] ([Id], [EmployeeId], [EmployeeType], [CommissionType], [Amount], [IsPaid], [Title], [InvoiceId], [HospitalId], [DateTime], [CreatedTime], [UpdatedTime], [MainInvoiceId], [PaymentGroup], [MainInvoiceCode], [InvoiceCode], [PercentOrValue], [InvoiceTotal], [LessAmount], [SpecialAmount], [Category], [InvoiceCreatedTime], [InvoiceDiagnosticTestId], [IsPaidFinally], [PaymentId], [ReceiptCreatedTime], [BarCodeImageUrl]) VALUES (N'62bf0dab-8567-4a2a-828a-62014f86b2c9', N'8d3cf8f9-7ef7-4008-b529-e05a062b3f0c', N'Doctor', N'ASSISTANT_SURGEON', 1000, 1, N'KidneyOP_1', N'3d4646d1-0c53-413f-9e23-9783787d8522', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2018-12-26T12:45:43.9236292' 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'NCP0029', 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'62c39bb0-d350-4f42-955e-3f0c4984273c', N'6ee087eb-7031-408f-b4ea-f567d250f75b', N'Doctor', N'Assistance', 33, 0, N'KidneyOP_1', N'54122edc-d414-4681-bcd9-8a2c5dea2efa', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2018-12-13T16:01:53.5391530' AS DateTime2), CAST(N'2018-12-22T16:17:56.9948653' AS DateTime2), N'3185ec7e-59f6-4fdc-b1ff-b0d47865fd59', NULL, N'NCINV0034', N'NCINV0034', N'33', NULL, 0, 0, N'Operation', CAST(N'2018-12-13T15: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'6324cd86-2485-481e-821c-0958c4c12a13', N'7aea2b0b-c196-4bd2-b220-d9be9dee7688', N'Doctor', N'Pathology', -22.702702702702705, 1, N'', N'f3e6d38d-8ac1-45df-8b17-e4b6686bcbb1', N'd821cd9f-ac10-4f94-92cf-c292cd83b2c0', NULL, CAST(N'2018-07-25T15:32:20.8566667' AS DateTime2), CAST(N'2018-09-04T22:35:23.0600000' AS DateTime2), N'ff0ebd31-f7bc-498c-b664-2e56792867c1', N'RR0026', N'RINV0040', N'RDG0060', N'0%', 1800, 420, 0, N'Test', CAST(N'2018-07-25T15:23:31.7466667' AS DateTime2), NULL, 0, N'NA', N'NA', N'NA')
INSERT [dbo].[Commission] ([Id], [EmployeeId], [EmployeeType], [CommissionType], [Amount], [IsPaid], [Title], [InvoiceId], [HospitalId], [DateTime], [CreatedTime], [UpdatedTime], [MainInvoiceId], [PaymentGroup], [MainInvoiceCode], [InvoiceCode], [PercentOrValue], [InvoiceTotal], [LessAmount], [SpecialAmount], [Category], [InvoiceCreatedTime], [InvoiceDiagnosticTestId], [IsPaidFinally], [PaymentId], [ReceiptCreatedTime], [BarCodeImageUrl]) VALUES (N'634c1f4b-4a74-466b-b491-11fb77c043f5', 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.1859145' 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'af33374d-9197-4915-9907-4adf59a5620a', 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'63914f23-aa85-413b-a0c3-1381b2ace25d', N'8d3cf8f9-7ef7-4008-b529-e05a062b3f0c', N'Doctor', N'ASSISTANT_SURGEON', 3330, 1, N'KidneyOP_1', N'503de2f0-2c09-4be7-8f57-8b7c28560eff', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2019-01-17T13:27:38.7510368' AS DateTime2), CAST(N'2019-02-02T16:34:39.1819788' 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'NCP0057', 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'6397bf46-29c3-410a-89a2-b8fedfdef4df', N'f58ff95f-89e6-4f8e-8868-a83828ebe999', N'Doctor', N'Conbination', 20, 1, N'', N'7563126c-a5b2-40ab-bdef-ef3b9f9dbfc4', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2018-11-26T09:22:22.4293220' AS DateTime2), CAST(N'2018-11-26T13:54:40.8479266' AS DateTime2), N'NOTASSIGNED', N'NCR0002', 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'63c16758-e55f-4c0e-9148-96dd014e8116', N'0e9223ff-2649-44ca-ac5a-7a43d1adea34', N'Referral', N'Biochemistry', 0, 1, N'', N'b8408577-d0c8-4b5d-b4f7-b9f308f935ca', N'd821cd9f-ac10-4f94-92cf-c292cd83b2c0', NULL, CAST(N'2018-08-31T13:05:23.9233333' AS DateTime2), CAST(N'2018-09-04T22:21:52.4600000' AS DateTime2), N'f6b0ccfa-c098-4790-aefc-1354aca6b85c', N'RR0050', N'RINV0173', N'RDG0189', N'0', 200, 0, 200, N'Test', CAST(N'2018-08-31T12:56:53.5033333' 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'644a243f-9588-49d1-9121-92f1ff25cd42', N'4c772c03-ef45-492a-82d7-24bd49320ea3', N'Referral', N'CombineCategory_1', 0, 1, N'', N'd209247c-b29c-41b8-a45e-28c6b53decbb', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2018-12-25T15:51:27.8589248' AS DateTime2), CAST(N'2018-12-25T16:00:33.3685492' AS DateTime2), N'NOTASSIGNED', N'NCR0088', NULL, N'NCDG0078', N'10%', 1010.7, 112.3, 0, N'Test', CAST(N'2018-12-25T15:51:27.1486719' AS DateTime2), NULL, 1, N'NCP0011', N'25-Dec-18', N'NA')
INSERT [dbo].[Commission] ([Id], [EmployeeId], [EmployeeType], [CommissionType], [Amount], [IsPaid], [Title], [InvoiceId], [HospitalId], [DateTime], [CreatedTime], [UpdatedTime], [MainInvoiceId], [PaymentGroup], [MainInvoiceCode], [InvoiceCode], [PercentOrValue], [InvoiceTotal], [LessAmount], [SpecialAmount], [Category], [InvoiceCreatedTime], [InvoiceDiagnosticTestId], [IsPaidFinally], [PaymentId], [ReceiptCreatedTime], [BarCodeImageUrl]) VALUES (N'64e60863-50b8-4465-be15-276b89afc4b3', 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.5327722' 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'be1b7884-6088-4e05-bd8c-54528ea0ef6c', 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'64fa1fb9-e7b3-47cb-baa6-92a8ac545bc0', N'6ee087eb-7031-408f-b4ea-f567d250f75b', N'Doctor', N'CombineCategory_1', 267.03, 0, N'', N'bf6974a6-9f9e-4640-bd8f-535bab6e4eab', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2019-01-08T09:15:03.6550775' AS DateTime2), CAST(N'2019-02-03T08:17:35.7629175' AS DateTime2), N'NOTASSIGNED', N'NCR0114', NULL, N'NCDG0093', N'27%', 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'65469355-1324-4818-a3d0-d6916d802dc3', N'8d3cf8f9-7ef7-4008-b529-e05a062b3f0c', N'Doctor', N'Assistance', 1000, 0, N'KidneyOP_1', N'54122edc-d414-4681-bcd9-8a2c5dea2efa', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2018-12-13T16:01:53.5421515' AS DateTime2), CAST(N'2018-12-22T16:17:56.9948653' AS DateTime2), N'3185ec7e-59f6-4fdc-b1ff-b0d47865fd59', NULL, N'NCINV0034', N'NCINV0034', N'1000', NULL, 0, 0, N'Operation', CAST(N'2018-12-13T15:34:21.0070266' AS DateTime2), NULL, 1, N'NA', N'NA', N'NA')
INSERT [dbo].[Commission] ([Id], [EmployeeId], [EmployeeType], [CommissionType], [Amount], [IsPaid], [Title], [InvoiceId], [HospitalId], [DateTime], [CreatedTime], [UpdatedTime], [MainInvoiceId], [PaymentGroup], [MainInvoiceCode], [InvoiceCode], [PercentOrValue], [InvoiceTotal], [LessAmount], [SpecialAmount], [Category], [InvoiceCreatedTime], [InvoiceDiagnosticTestId], [IsPaidFinally], [PaymentId], [ReceiptCreatedTime], [BarCodeImageUrl]) VALUES (N'65594bd2-a52e-4af4-8b79-d0b1f119ecd0', N'f58ff95f-89e6-4f8e-8868-a83828ebe999', N'Doctor', N'CT_2', 4.4, 1, N'', N'26b3e18b-3653-41c6-95af-cc1cff900d7f', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2018-12-24T12:13:57.3713292' AS DateTime2), CAST(N'2018-12-24T14:23:29.4277467' AS DateTime2), N'NOTASSIGNED', N'NCR0087', NULL, N'NCDG0075', N'10%', 867, 0, 0, N'Test', CAST(N'2018-12-24T12:13:56.8550827' AS DateTime2), NULL, 1, N'NCP0002', N'NA', N'NA')
INSERT [dbo].[Commission] ([Id], [EmployeeId], [EmployeeType], [CommissionType], [Amount], [IsPaid], [Title], [InvoiceId], [HospitalId], [DateTime], [CreatedTime], [UpdatedTime], [MainInvoiceId], [PaymentGroup], [MainInvoiceCode], [InvoiceCode], [PercentOrValue], [InvoiceTotal], [LessAmount], [SpecialAmount], [Category], [InvoiceCreatedTime], [InvoiceDiagnosticTestId], [IsPaidFinally], [PaymentId], [ReceiptCreatedTime], [BarCodeImageUrl]) VALUES (N'657d26d2-27ad-47d9-937b-ee7b45805cd4', N'2f49ff36-b04f-4081-9261-60ec973da26d', N'Doctor', N'SPECIAL_SURGEON', 33, 0, N'KidneyOP_1', N'd647259e-5506-4502-afed-9c1f343b16c0', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2019-01-19T10:09:28.0623661' 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'65ad5e52-1cf6-47a1-a433-a0e545e76cae', N'4c772c03-ef45-492a-82d7-24bd49320ea3', N'UltraSoundDoctor', N'UltraSoundCategory_2', 0, 0, N'', N'1d6045a7-1375-41cd-a3b1-166e195225d2', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2018-12-02T15:59:13.7866136' AS DateTime2), CAST(N'2018-12-22T16:17:56.9948653' AS DateTime2), N'NOTASSIGNED', NULL, N'NOTASSIGNED', N'NCDG0062', NULL, 891, 89.1, 0, N'Test', CAST(N'2018-12-02T15:59:13.6286735' AS DateTime2), NULL, 1, N'NA', N'NA', N'NA')
INSERT [dbo].[Commission] ([Id], [EmployeeId], [EmployeeType], [CommissionType], [Amount], [IsPaid], [Title], [InvoiceId], [HospitalId], [DateTime], [CreatedTime], [UpdatedTime], [MainInvoiceId], [PaymentGroup], [MainInvoiceCode], [InvoiceCode], [PercentOrValue], [InvoiceTotal], [LessAmount], [SpecialAmount], [Category], [InvoiceCreatedTime], [InvoiceDiagnosticTestId], [IsPaidFinally], [PaymentId], [ReceiptCreatedTime], [BarCodeImageUrl]) VALUES (N'6624c1e6-e016-4340-97fe-d2806db3f434', 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.2328862' 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'619700a0-c974-412a-a7a2-0c8a5cc76ecf', 1, NULL, N'03-02-2019 8:17 AM', N'data:image/jpeg;base64,[encoded data, 8380 characters]')
