INSERT [dbo].[Commission] ([Id], [EmployeeId], [EmployeeType], [CommissionType], [Amount], [IsPaid], [Title], [InvoiceId], [HospitalId], [DateTime], [CreatedTime], [UpdatedTime], [MainInvoiceId], [PaymentGroup], [MainInvoiceCode], [InvoiceCode], [PercentOrValue], [InvoiceTotal], [LessAmount], [SpecialAmount], [Category], [InvoiceCreatedTime], [InvoiceDiagnosticTestId], [IsPaidFinally], [PaymentId], [ReceiptCreatedTime], [BarCodeImageUrl]) VALUES (N'103ad30c-21eb-4741-90ee-67884f7f6207', N'3e6c7598-b4d4-453d-97fa-1de3da9ac873', N'Doctor', N'Pathology', 0, 1, N'', N'192168f2-5f03-4d9d-a6e2-b5d846984dd6', N'd821cd9f-ac10-4f94-92cf-c292cd83b2c0', NULL, CAST(N'2018-07-29T13:41:47.0233333' AS DateTime2), CAST(N'2018-09-04T22:35:23.0366667' AS DateTime2), N'1f6d0654-58e3-4932-a7cc-93707fdbcafd', N'RR0024', N'RINV0058', N'RDG0078', N'0%', 1400, 0, 0, N'Test', CAST(N'2018-07-29T13:39:51.4466667' AS DateTime2), NULL, 0, N'NA', N'NA', N'NA')
INSERT [dbo].[Commission] ([Id], [EmployeeId], [EmployeeType], [CommissionType], [Amount], [IsPaid], [Title], [InvoiceId], [HospitalId], [DateTime], [CreatedTime], [UpdatedTime], [MainInvoiceId], [PaymentGroup], [MainInvoiceCode], [InvoiceCode], [PercentOrValue], [InvoiceTotal], [LessAmount], [SpecialAmount], [Category], [InvoiceCreatedTime], [InvoiceDiagnosticTestId], [IsPaidFinally], [PaymentId], [ReceiptCreatedTime], [BarCodeImageUrl]) VALUES (N'103d1d49-7a39-4dbe-9c4b-84cae0c98ccb', N'7aea2b0b-c196-4bd2-b220-d9be9dee7688', N'Doctor', N'Pathology', 0, 1, N'', N'86016633-9a21-49ce-915f-475f0c8ae109', N'd821cd9f-ac10-4f94-92cf-c292cd83b2c0', NULL, CAST(N'2018-07-25T14:38:05.0200000' AS DateTime2), CAST(N'2018-09-04T22:35:23.0366667' AS DateTime2), N'f837df36-adff-43ca-accb-28a896247894', N'RR0021', N'RINV0038', N'RDG0058', N'0%', 200, 0, 0, N'Test', CAST(N'2018-07-25T14:36:32.7100000' 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'106740fc-cb97-4522-a524-8d3a67a21a1d', N'4c772c03-ef45-492a-82d7-24bd49320ea3', N'Doctor', N'CombineCategory_1', 12.3, 1, N'', N'eb7be4be-6bd1-45ba-9031-6297b013383c', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2019-02-03T09:56:52.1059090' AS DateTime2), CAST(N'2019-02-23T12:47:31.8154487' AS DateTime2), N'NOTASSIGNED', N'NCR0119', NULL, N'NCDG0116', N'10%', 1105, 0, 0, N'Test', CAST(N'2019-02-03T09:56:48.9540657' AS DateTime2), NULL, 1, N'NCP0065', N'23-02-2019 12:47 PM', N'data:image/jpeg;base64,[encoded data, 8360 characters]')
INSERT [dbo].[Commission] ([Id], [EmployeeId], [EmployeeType], [CommissionType], [Amount], [IsPaid], [Title], [InvoiceId], [HospitalId], [DateTime], [CreatedTime], [UpdatedTime], [MainInvoiceId], [PaymentGroup], [MainInvoiceCode], [InvoiceCode], [PercentOrValue], [InvoiceTotal], [LessAmount], [SpecialAmount], [Category], [InvoiceCreatedTime], [InvoiceDiagnosticTestId], [IsPaidFinally], [PaymentId], [ReceiptCreatedTime], [BarCodeImageUrl]) VALUES (N'109a3322-e99f-4275-9cd4-8d826d7dd195', N'f58ff95f-89e6-4f8e-8868-a83828ebe999', N'Doctor', N'CombineCategory_1', 500, 1, N'', N'11ca0974-d897-47ae-9180-66b70ae11df1', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2018-12-24T13:50:33.6253712' AS DateTime2), CAST(N'2018-12-24T14:11:26.5307031' AS DateTime2), N'NOTASSIGNED', N'NCR0079', NULL, N'NCDG0077', N'10%', 969.3, 107.7, 0, N'Test', CAST(N'2018-12-24T13:50:33.1434282' AS DateTime2), NULL, 1, N'NCP0006', N'NA', N'NA')
INSERT [dbo].[Commission] ([Id], [EmployeeId], [EmployeeType], [CommissionType], [Amount], [IsPaid], [Title], [InvoiceId], [HospitalId], [DateTime], [CreatedTime], [UpdatedTime], [MainInvoiceId], [PaymentGroup], [MainInvoiceCode], [InvoiceCode], [PercentOrValue], [InvoiceTotal], [LessAmount], [SpecialAmount], [Category], [InvoiceCreatedTime], [InvoiceDiagnosticTestId], [IsPaidFinally], [PaymentId], [ReceiptCreatedTime], [BarCodeImageUrl]) VALUES (N'117aeb4e-7c7e-4903-af46-92b01d582e50', N'2f49ff36-b04f-4081-9261-60ec973da26d', N'Referral', N'UltraSoundCategory_1', 6.8, 1, N'', N'a022cb08-0c98-4969-a31f-1d5d2884fbbb', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2018-12-06T13:57:10.0922943' AS DateTime2), CAST(N'2018-12-06T15:14:18.7544439' AS DateTime2), N'NOTASSIGNED', N'NCR0042', NULL, N'NCDG0068', N'20%', 68, 0, 0, N'Test', CAST(N'2018-12-06T13:43:42.0771626' AS DateTime2), NULL, 0, N'NA', N'NA', N'NA')
INSERT [dbo].[Commission] ([Id], [EmployeeId], [EmployeeType], [CommissionType], [Amount], [IsPaid], [Title], [InvoiceId], [HospitalId], [DateTime], [CreatedTime], [UpdatedTime], [MainInvoiceId], [PaymentGroup], [MainInvoiceCode], [InvoiceCode], [PercentOrValue], [InvoiceTotal], [LessAmount], [SpecialAmount], [Category], [InvoiceCreatedTime], [InvoiceDiagnosticTestId], [IsPaidFinally], [PaymentId], [ReceiptCreatedTime], [BarCodeImageUrl]) VALUES (N'120dc7eb-9881-4d35-bc31-cf33a13047eb', N'65ba8697-497a-4f36-bd6c-668eba0c5d62', N'Referral', N'Biochemistry ', 0, 0, N'', N'9b1d0359-6b2c-4b7a-8e6f-121aed43f2b7', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2019-01-14T10:55:20.4395498' 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'1235ec64-988a-4f4b-b738-781cf5e8b2a2', N'2f49ff36-b04f-4081-9261-60ec973da26d', N'Doctor', N'ANESTHESIA_DOCTOR', 2220, 0, N'KidneyOP_1', N'1d164d48-5760-4f63-9083-066b657fa554', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2019-01-16T11:39:05.3940658' AS DateTime2), CAST(N'2019-02-03T08:17:35.7629175' AS DateTime2), N'382d7597-0685-443c-b918-7aab224db486', N'NCR0114', N'NCINV0048', N'NCINV0048', N'2220', NULL, 0, 0, N'Operation', CAST(N'2019-01-16T11:39:05.0952503' AS DateTime2), NULL, 1, NULL, N'03-02-2019 8:17 AM', N'data:image/jpeg;base64,[encoded data, 8380 characters]')
INSERT [dbo].[Commission] ([Id], [EmployeeId], [EmployeeType], [CommissionType], [Amount], [IsPaid], [Title], [InvoiceId], [HospitalId], [DateTime], [CreatedTime], [UpdatedTime], [MainInvoiceId], [PaymentGroup], [MainInvoiceCode], [InvoiceCode], [PercentOrValue], [InvoiceTotal], [LessAmount], [SpecialAmount], [Category], [InvoiceCreatedTime], [InvoiceDiagnosticTestId], [IsPaidFinally], [PaymentId], [ReceiptCreatedTime], [BarCodeImageUrl]) VALUES (N'1294dd40-d43d-4b26-9622-51cc62a81db6', N'7a432ef3-78e3-4091-811b-11fc802fb981', N'Doctor', N'X-Ray ', -266.66666666666669, 1, N'', N'4469621b-8a3f-4ae6-9e23-a0a15e6b3414', N'd821cd9f-ac10-4f94-92cf-c292cd83b2c0', NULL, CAST(N'2018-07-15T10:00:46.6466667' AS DateTime2), CAST(N'2018-09-04T22:21:52.4400000' AS DateTime2), N'a09d1933-a42e-4b01-8f2f-08ffd0109967', N'RR0042', N'RINV0009', N'RDG0025', N'0%', 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'153fda3c-d9fa-4438-8e47-ca89fec373f4', N'2f49ff36-b04f-4081-9261-60ec973da26d', N'Doctor', N'Biochemistry ', 180, 1, N'', N'ddd8d663-8ec8-4094-874b-42caf6053c00', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2019-01-06T15:18:33.5606564' AS DateTime2), CAST(N'2019-01-19T13:44:02.6857815' AS DateTime2), N'NOTASSIGNED', N'NCR0103', NULL, N'NCDG0083', N'10%', 3558, 0, 0, N'Test', CAST(N'2019-01-06T10:10:33.9540561' AS DateTime2), NULL, 1, N'NCP0045', N'Saturday, January 19, 2019 1:44 PM', N'data:image/jpeg;base64,[encoded data, 8416 characters]')
INSERT [dbo].[Commission] ([Id], [EmployeeId], [EmployeeType], [CommissionType], [Amount], [IsPaid], [Title], [InvoiceId], [HospitalId], [DateTime], [CreatedTime], [UpdatedTime], [MainInvoiceId], [PaymentGroup], [MainInvoiceCode], [InvoiceCode], [PercentOrValue], [InvoiceTotal], [LessAmount], [SpecialAmount], [Category], [InvoiceCreatedTime], [InvoiceDiagnosticTestId], [IsPaidFinally], [PaymentId], [ReceiptCreatedTime], [BarCodeImageUrl]) VALUES (N'1588d6a4-f16c-4311-852d-ba39927036b0', N'f58ff95f-89e6-4f8e-8868-a83828ebe999', N'Doctor', N'DoctorVisit', 100, 0, N'', N'04ec7a83-8cde-4ee6-a599-e3c5080cfc51', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2018-12-25T16:30:26.4257403' AS DateTime2), CAST(N'2019-02-03T08:17:35.7629175' AS DateTime2), N'2dea13d0-bea8-41c9-8442-93148a2818c1', N'NCR0114', NULL, N'NCINV0040', NULL, NULL, 0, 0, N'Operation', 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'15e23edd-7172-406f-9236-e8cfca19b55d', N'2f49ff36-b04f-4081-9261-60ec973da26d', N'Referral', N'Ultrasound', 70000, 0, N'', N'bf6974a6-9f9e-4640-bd8f-535bab6e4eab', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2019-01-08T11:29:27.6562886' 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'15e41537-1658-4215-a51f-2b6b326efa30', N'4c772c03-ef45-492a-82d7-24bd49320ea3', N'Doctor', N'Anesthesia', 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.5361549' 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'162ab4e5-951d-483f-a4a4-2397148b03f6', N'6ee087eb-7031-408f-b4ea-f567d250f75b', N'Doctor', N'Conbination', 3294, 0, N'', N'bf6974a6-9f9e-4640-bd8f-535bab6e4eab', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2019-01-08T11:27:33.1445549' 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'163aa2ef-9d14-472e-aea5-b20a0a6dcfe6', N'2f49ff36-b04f-4081-9261-60ec973da26d', N'Doctor', N'CombineCategory_1', 12.3, 0, N'', N'd8f7316a-aa7f-478e-83c8-4e5f01b66a0e', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2019-01-29T16:08:58.1002001' AS DateTime2), CAST(N'2019-02-03T08:17:35.7629175' AS DateTime2), N'NOTASSIGNED', N'NCR0114', NULL, N'NCDG0111', N'10%', 785.7, 87.3, 0, N'Test', CAST(N'2019-01-29T16:08:54.7740617' AS DateTime2), NULL, 1, NULL, N'03-02-2019 8:17 AM', N'data:image/jpeg;base64,[encoded data, 8380 characters]')
INSERT [dbo].[Commission] ([Id], [EmployeeId], [EmployeeType], [CommissionType], [Amount], [IsPaid], [Title], [InvoiceId], [HospitalId], [DateTime], [CreatedTime], [UpdatedTime], [MainInvoiceId], [PaymentGroup], [MainInvoiceCode], [InvoiceCode], [PercentOrValue], [InvoiceTotal], [LessAmount], [SpecialAmount], [Category], [InvoiceCreatedTime], [InvoiceDiagnosticTestId], [IsPaidFinally], [PaymentId], [ReceiptCreatedTime], [BarCodeImageUrl]) VALUES (N'16a8e3c4-6afd-4a60-8f09-7a47662ddcf9', N'2f49ff36-b04f-4081-9261-60ec973da26d', N'Doctor', N'DoctorVisit', 3344, 0, N'', N'NOTASSIGNED', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2019-01-17T13:17:50.4111907' AS DateTime2), CAST(N'2019-02-03T08:17:35.7629175' AS DateTime2), N'382d7597-0685-443c-b918-7aab224db486', N'NCR0114', NULL, N'NOTASSIGNED', NULL, NULL, 0, 0, N'ADDED_JUST_FOR_COMMISSION', CAST(N'0001-01-01T00:00:00.0000000' AS DateTime2), NULL, 1, NULL, N'03-02-2019 8:17 AM', N'data:image/jpeg;base64,[encoded data, 8380 characters]')
INSERT [dbo].[Commission] ([Id], [EmployeeId], [EmployeeType], [CommissionType], [Amount], [IsPaid], [Title], [InvoiceId], [HospitalId], [DateTime], [CreatedTime], [UpdatedTime], [MainInvoiceId], [PaymentGroup], [MainInvoiceCode], [InvoiceCode], [PercentOrValue], [InvoiceTotal], [LessAmount], [SpecialAmount], [Category], [InvoiceCreatedTime], [InvoiceDiagnosticTestId], [IsPaidFinally], [PaymentId], [ReceiptCreatedTime], [BarCodeImageUrl]) VALUES (N'16ba6f5d-7944-4312-a4fa-15603ba15494', N'4c772c03-ef45-492a-82d7-24bd49320ea3', N'Doctor', N'ANESTHESIA_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.8186945' 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'16d3299c-5ef0-4a3c-ac90-cda77f862840', N'f58ff95f-89e6-4f8e-8868-a83828ebe999', N'Doctor', N'UltraSoundCategory_1', 24.6, 1, N'', N'c5e84ccb-38d8-4ca4-a224-92ea42e0f4c5', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2019-02-02T16:42:10.8274173' AS DateTime2), CAST(N'2019-02-23T12:47:42.5142667' AS DateTime2), N'NOTASSIGNED', N'NCR0120', NULL, N'NCDG0115', N'20%', 1234, 0, 0, N'Test', CAST(N'2019-02-02T16:42:10.5098169' AS DateTime2), NULL, 1, N'NCP0062', N'23-02-2019 12:47 PM', N'data:image/jpeg;base64,[encoded data, 8420 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'16f9fb87-3901-4040-a463-fa6aee329849', N'2f49ff36-b04f-4081-9261-60ec973da26d', N'Doctor', N'Biochemistry ', 25, 1, N'', N'67b289d0-644b-4278-a2c3-3d230a455da7', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2018-12-11T09:49:04.4339869' AS DateTime2), CAST(N'2018-12-23T10:33:23.1283633' AS DateTime2), N'6d5275c3-14d6-402f-a25a-be761fa0a549', N'NCR0070', N'NCINV0032', N'NCDG0071', N'10%', 250, 0, 0, N'Test', CAST(N'2018-12-11T09:49:04.3850191' 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'1738b777-f123-4bbb-80b0-f222d789c58f', N'2f49ff36-b04f-4081-9261-60ec973da26d', N'Doctor', N'CombineCategory_1', 4.4, 0, N'', N'703d5936-69a5-45c0-a69e-1b32c6fcd0f7', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2019-01-07T11:05:08.0163624' AS DateTime2), CAST(N'2019-02-03T08:17:35.7629175' AS DateTime2), N'NOTASSIGNED', N'NCR0114', NULL, N'NCDG0085', N'10%', 1357, 0, 0, N'Test', CAST(N'2019-01-07T10:38:42.9472130' AS DateTime2), NULL, 1, NULL, N'03-02-2019 8:17 AM', N'data:image/jpeg;base64,[encoded data, 8380 characters]')
INSERT [dbo].[Commission] ([Id], [EmployeeId], [EmployeeType], [CommissionType], [Amount], [IsPaid], [Title], [InvoiceId], [HospitalId], [DateTime], [CreatedTime], [UpdatedTime], [MainInvoiceId], [PaymentGroup], [MainInvoiceCode], [InvoiceCode], [PercentOrValue], [InvoiceTotal], [LessAmount], [SpecialAmount], [Category], [InvoiceCreatedTime], [InvoiceDiagnosticTestId], [IsPaidFinally], [PaymentId], [ReceiptCreatedTime], [BarCodeImageUrl]) VALUES (N'174b5405-9162-4cf6-ba46-243a65c25f24', N'f58ff95f-89e6-4f8e-8868-a83828ebe999', N'Doctor', N'UltraSoundCategory_2', 0, 0, N'', N'b19fdabe-22c4-4bfd-9e31-ce5c9110367b', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2018-11-29T16:14:24.8276819' AS DateTime2), CAST(N'2018-12-22T16:17:56.9948653' AS DateTime2), N'NOTASSIGNED', NULL, NULL, N'NCDG0061', N'0%', 157, 0, 0, N'Test', CAST(N'2018-11-29T16:14:24.7495605' AS DateTime2), NULL, 1, N'NA', N'NA', N'NA')
INSERT [dbo].[Commission] ([Id], [EmployeeId], [EmployeeType], [CommissionType], [Amount], [IsPaid], [Title], [InvoiceId], [HospitalId], [DateTime], [CreatedTime], [UpdatedTime], [MainInvoiceId], [PaymentGroup], [MainInvoiceCode], [InvoiceCode], [PercentOrValue], [InvoiceTotal], [LessAmount], [SpecialAmount], [Category], [InvoiceCreatedTime], [InvoiceDiagnosticTestId], [IsPaidFinally], [PaymentId], [ReceiptCreatedTime], [BarCodeImageUrl]) VALUES (N'17df61b4-d49e-4ef6-8f04-a3f739c22e51', N'f58ff95f-89e6-4f8e-8868-a83828ebe999', N'Doctor', N'SPECIAL_SURGEON', 220, 0, N'KidneyOP_1', N'172d55ca-fd29-4f10-bb15-b9c83957b941', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2019-02-22T22:49:35.9713386' AS DateTime2), CAST(N'2019-02-22T22:49:35.9713386' AS DateTime2), N'd1039f90-a091-4ef6-ae6f-5c88d88c8fad', NULL, N'NCINV0064', N'NCINV0064', N'220', NULL, 0, 0, N'Operation', CAST(N'2019-02-22T22:49:35.7954201' AS DateTime2), NULL, 0, NULL, NULL, NULL)
INSERT [dbo].[Commission] ([Id], [EmployeeId], [EmployeeType], [CommissionType], [Amount], [IsPaid], [Title], [InvoiceId], [HospitalId], [DateTime], [CreatedTime], [UpdatedTime], [MainInvoiceId], [PaymentGroup], [MainInvoiceCode], [InvoiceCode], [PercentOrValue], [InvoiceTotal], [LessAmount], [SpecialAmount], [Category], [InvoiceCreatedTime], [InvoiceDiagnosticTestId], [IsPaidFinally], [PaymentId], [ReceiptCreatedTime], [BarCodeImageUrl]) VALUES (N'1820651e-e38f-4303-b8d0-20eda91698fa', N'f58ff95f-89e6-4f8e-8868-a83828ebe999', N'Doctor', N'UltraSoundCategory_2', 6.8, 1, N'', N'a022cb08-0c98-4969-a31f-1d5d2884fbbb', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2018-12-06T13:43:42.2576169' AS DateTime2), CAST(N'2018-12-06T15:14:18.7454492' AS DateTime2), N'NOTASSIGNED', N'NCR0041', NULL, N'NCDG0068', N'20%', 68, 0, 0, N'Test', CAST(N'2018-12-06T13:43:42.0771626' AS DateTime2), NULL, 0, N'NA', N'NA', N'NA')
INSERT [dbo].[Commission] ([Id], [EmployeeId], [EmployeeType], [CommissionType], [Amount], [IsPaid], [Title], [InvoiceId], [HospitalId], [DateTime], [CreatedTime], [UpdatedTime], [MainInvoiceId], [PaymentGroup], [MainInvoiceCode], [InvoiceCode], [PercentOrValue], [InvoiceTotal], [LessAmount], [SpecialAmount], [Category], [InvoiceCreatedTime], [InvoiceDiagnosticTestId], [IsPaidFinally], [PaymentId], [ReceiptCreatedTime], [BarCodeImageUrl]) VALUES (N'18aab94f-f6bd-4612-a8ea-eb062075f35f', N'410f20e6-ad68-450b-9cf3-55da4793042c', N'Doctor', N'CLINIC_REFERRAL', 123, 0, N'ClinicInvoice', N'NOTASSIGNED', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2019-02-14T16:05:42.9437959' AS DateTime2), CAST(N'2019-02-14T16:05:42.9437959' AS DateTime2), N'07742b8f-093a-447d-8a17-76b7b75f04f4', NULL, NULL, N'NOTASSIGNED', N'123', NULL, 0, 0, N'ADDED_JUST_FOR_COMMISSION', CAST(N'0001-01-01T00:00:00.0000000' AS DateTime2), NULL, 0, NULL, NULL, NULL)
INSERT [dbo].[Commission] ([Id], [EmployeeId], [EmployeeType], [CommissionType], [Amount], [IsPaid], [Title], [InvoiceId], [HospitalId], [DateTime], [CreatedTime], [UpdatedTime], [MainInvoiceId], [PaymentGroup], [MainInvoiceCode], [InvoiceCode], [PercentOrValue], [InvoiceTotal], [LessAmount], [SpecialAmount], [Category], [InvoiceCreatedTime], [InvoiceDiagnosticTestId], [IsPaidFinally], [PaymentId], [ReceiptCreatedTime], [BarCodeImageUrl]) VALUES (N'18be20d7-69db-4551-bd2f-aac96890b30c', N'f58ff95f-89e6-4f8e-8868-a83828ebe999', N'Doctor', N'ASSIGNED_DOCTOR', 1000, 1, N'KidneyOP_1', N'0cb8c3a4-5ed3-4945-9a65-9214be4c4765', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2018-12-26T12:17:48.1280429' AS DateTime2), CAST(N'2018-12-27T12:05:15.6370524' AS DateTime2), N'0c6f2449-2e4f-489d-8372-860af4eabf75', N'NCR0096', N'NCINV0041', N'NCINV0041', N'1090', NULL, 0, 0, N'Operation', CAST(N'2018-12-26T12:16:04.4329021' AS DateTime2), NULL, 1, N'NCP0024', N'26-Dec-18 1:17 PM', N'NA')
INSERT [dbo].[Commission] ([Id], [EmployeeId], [EmployeeType], [CommissionType], [Amount], [IsPaid], [Title], [InvoiceId], [HospitalId], [DateTime], [CreatedTime], [UpdatedTime], [MainInvoiceId], [PaymentGroup], [MainInvoiceCode], [InvoiceCode], [PercentOrValue], [InvoiceTotal], [LessAmount], [SpecialAmount], [Category], [InvoiceCreatedTime], [InvoiceDiagnosticTestId], [IsPaidFinally], [PaymentId], [ReceiptCreatedTime], [BarCodeImageUrl]) VALUES (N'18cc86bc-28a2-4ad4-b448-c438a2adba4f', N'4c772c03-ef45-492a-82d7-24bd49320ea3', N'Doctor', N'DoctorVisit', 200000, 1, N'', N'00c38617-660c-45df-90de-65889c2c791d', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2018-12-27T12:04:19.0270520' AS DateTime2), CAST(N'2018-12-27T12:06:11.1707842' AS DateTime2), N'0c6f2449-2e4f-489d-8372-860af4eabf75', N'NCR0101', N'NCINV0041', NULL, NULL, NULL, 0, 0, N'Operation', CAST(N'0001-01-01T00:00:00.0000000' AS DateTime2), NULL, 1, N'NCP0035', N'27-Dec-18 12:06 PM', N'data:image/jpeg;base64,[encoded data, 8412 characters]')
INSERT [dbo].[Commission] ([Id], [EmployeeId], [EmployeeType], [CommissionType], [Amount], [IsPaid], [Title], [InvoiceId], [HospitalId], [DateTime], [CreatedTime], [UpdatedTime], [MainInvoiceId], [PaymentGroup], [MainInvoiceCode], [InvoiceCode], [PercentOrValue], [InvoiceTotal], [LessAmount], [SpecialAmount], [Category], [InvoiceCreatedTime], [InvoiceDiagnosticTestId], [IsPaidFinally], [PaymentId], [ReceiptCreatedTime], [BarCodeImageUrl]) VALUES (N'18ea6966-3ed8-47a0-ae68-5f5eb6a13172', N'f58ff95f-89e6-4f8e-8868-a83828ebe999', N'Doctor', N'ASSIGNED_DOCTOR', 8900, 0, N'KidneyOP_1', N'67650f2a-cd2d-49fd-bc7e-5eefce820158', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2018-12-20T15:20:15.7533873' 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'193cf9ef-8f12-4e7d-91ba-2f48a792f880', N'7a432ef3-78e3-4091-811b-11fc802fb981', N'Doctor', N'Pathology (Combination)', 13.333333333333329, 1, N'', N'4469621b-8a3f-4ae6-9e23-a0a15e6b3414', N'd821cd9f-ac10-4f94-92cf-c292cd83b2c0', NULL, CAST(N'2018-07-15T10:00:46.6466667' AS DateTime2), CAST(N'2018-09-04T22:21:52.4466667' 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'197c41a7-a3f4-4f2f-be0c-5006ceb47a9e', N'4c772c03-ef45-492a-82d7-24bd49320ea3', N'UltraSoundDoctor', N'UltraSoundCategory_2', 200, 1, N'', N'1d6045a7-1375-41cd-a3b1-166e195225d2', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2018-12-02T15:59:13.7766197' AS DateTime2), CAST(N'2018-12-03T11:26:13.7188003' AS DateTime2), N'NOTASSIGNED', N'NCR0014', 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'19bcbafa-d05c-4e40-bf44-2f0c673be7df', N'8d3cf8f9-7ef7-4008-b529-e05a062b3f0c', N'Doctor', N'CLINIC_REFERRAL', 3330, 0, N'ClinicInvoice', N'1db7108f-94c2-4775-94d8-92c66c1940b4', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2019-01-16T12:40:50.3534903' AS DateTime2), CAST(N'2019-02-03T08:17:35.7629175' AS DateTime2), N'f253682d-6adc-4661-b133-62ba078575b5', N'NCR0114', N'NCINV0050', N'NOTASSIGNED', N'3330', NULL, 0, 0, N'OPERATION', CAST(N'2019-01-16T12:40:10.8903524' 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'19ec3b08-b50d-4575-aff7-7ef0229aaeda', N'7aea2b0b-c196-4bd2-b220-d9be9dee7688', N'Doctor', N'Pathology', -58.695652173913039, 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.0366667' AS DateTime2), N'de745a7c-c5b9-467e-8a74-1a979fe92952', N'RR0005', 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'1a360d38-e5e6-44a4-894b-ba298a7728f3', N'410f20e6-ad68-450b-9cf3-55da4793042c', N'Referral', N'CombineCategory_1', 103.24, 0, N'', N'2a4569a0-70ab-4888-a205-af406c84856d', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2019-01-07T09:32:32.5945903' 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'1a44e43b-821a-4232-9f72-9e4345e5e537', N'f58ff95f-89e6-4f8e-8868-a83828ebe999', N'Doctor', N'UltraSoundCategory_1', 49.2, 1, N'', N'24e4ffc4-6392-4eb1-a842-d19b9ccf6475', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2018-12-03T16:05:49.9463889' AS DateTime2), CAST(N'2018-12-03T16:23:05.5288207' AS DateTime2), N'NOTASSIGNED', N'NCR0020', NULL, N'NCDG0063', N'20%', 314, 0, 0, N'Test', CAST(N'2018-12-03T16:05:49.6665426' AS DateTime2), NULL, 0, N'NA', N'NA', N'NA')
INSERT [dbo].[Commission] ([Id], [EmployeeId], [EmployeeType], [CommissionType], [Amount], [IsPaid], [Title], [InvoiceId], [HospitalId], [DateTime], [CreatedTime], [UpdatedTime], [MainInvoiceId], [PaymentGroup], [MainInvoiceCode], [InvoiceCode], [PercentOrValue], [InvoiceTotal], [LessAmount], [SpecialAmount], [Category], [InvoiceCreatedTime], [InvoiceDiagnosticTestId], [IsPaidFinally], [PaymentId], [ReceiptCreatedTime], [BarCodeImageUrl]) VALUES (N'1a785c38-e171-42ea-af37-6e2868e058ea', N'2f49ff36-b04f-4081-9261-60ec973da26d', N'Doctor', N'CLINIC_REFERRAL', 1000, 0, N'ClinicInvoice', N'88afdcc5-92ab-4efa-8c4e-24f8e1ac21f4', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2018-12-18T11:05:20.2293536' AS DateTime2), CAST(N'2018-12-22T16:17:56.9948653' AS DateTime2), N'83281dd4-5998-4b90-bd4f-ad30ae28cfa6', NULL, N'NCINV0036', N'NOTASSIGNED', N'1000', NULL, 0, 0, N'OPERATION', CAST(N'2018-12-17T08:57:09.7197221' AS DateTime2), NULL, 1, N'NA', N'NA', N'NA')
INSERT [dbo].[Commission] ([Id], [EmployeeId], [EmployeeType], [CommissionType], [Amount], [IsPaid], [Title], [InvoiceId], [HospitalId], [DateTime], [CreatedTime], [UpdatedTime], [MainInvoiceId], [PaymentGroup], [MainInvoiceCode], [InvoiceCode], [PercentOrValue], [InvoiceTotal], [LessAmount], [SpecialAmount], [Category], [InvoiceCreatedTime], [InvoiceDiagnosticTestId], [IsPaidFinally], [PaymentId], [ReceiptCreatedTime], [BarCodeImageUrl]) VALUES (N'1aa7c890-35a0-4f82-95e0-c5b8beda5b18', N'4c772c03-ef45-492a-82d7-24bd49320ea3', N'Referral', N'CombineCategory_1', 110, 1, N'', N'22b6caac-53fd-43b0-a1fc-f5a38215c3a2', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2018-11-26T13:54:13.5205338' AS DateTime2), CAST(N'2018-12-22T16:36:52.8209753' AS DateTime2), N'NOTASSIGNED', N'NCR0008', NULL, N'NCDG0057', N'10%', 924.3, 102.7, 0, N'Test+OverAllAmount', CAST(N'2018-11-26T13:54:12.9779995' AS DateTime2), NULL, 1, N'NA', N'NA', N'NA')
INSERT [dbo].[Commission] ([Id], [EmployeeId], [EmployeeType], [CommissionType], [Amount], [IsPaid], [Title], [InvoiceId], [HospitalId], [DateTime], [CreatedTime], [UpdatedTime], [MainInvoiceId], [PaymentGroup], [MainInvoiceCode], [InvoiceCode], [PercentOrValue], [InvoiceTotal], [LessAmount], [SpecialAmount], [Category], [InvoiceCreatedTime], [InvoiceDiagnosticTestId], [IsPaidFinally], [PaymentId], [ReceiptCreatedTime], [BarCodeImageUrl]) VALUES (N'1bd940ee-236c-49ad-8a76-80d62e691045', N'410f20e6-ad68-450b-9cf3-55da4793042c', N'Doctor', N'CombineCategory_1', 138.91, 0, N'', N'25baf030-f741-473d-882b-a87e2bcd6ba0', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2019-01-07T11:33:58.1765749' AS DateTime2), CAST(N'2019-02-03T08:17:35.7629175' AS DateTime2), N'NOTASSIGNED', N'NCR0114', NULL, N'NCDG0086', N'29%', 583, 0, 0, N'Test', CAST(N'2019-01-07T11:33:57.9726087' AS DateTime2), NULL, 1, NULL, N'03-02-2019 8:17 AM', N'data:image/jpeg;base64,[encoded data, 8380 characters]')
INSERT [dbo].[Commission] ([Id], [EmployeeId], [EmployeeType], [CommissionType], [Amount], [IsPaid], [Title], [InvoiceId], [HospitalId], [DateTime], [CreatedTime], [UpdatedTime], [MainInvoiceId], [PaymentGroup], [MainInvoiceCode], [InvoiceCode], [PercentOrValue], [InvoiceTotal], [LessAmount], [SpecialAmount], [Category], [InvoiceCreatedTime], [InvoiceDiagnosticTestId], [IsPaidFinally], [PaymentId], [ReceiptCreatedTime], [BarCodeImageUrl]) VALUES (N'1c3575d7-4edf-45dc-bfc4-9811a82d7b5a', N'2f49ff36-b04f-4081-9261-60ec973da26d', N'UltraSoundDoctor', N'UltraSoundCategory_1', 100, 1, N'', N'a022cb08-0c98-4969-a31f-1d5d2884fbbb', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2018-12-06T13:43:42.2086794' AS DateTime2), CAST(N'2018-12-06T15:14:29.0899810' AS DateTime2), N'NOTASSIGNED', N'NCR0043', N'NOTASSIGNED', N'NCDG0068', NULL, 68, 0, 0, N'test', CAST(N'2018-12-06T13:43:42.0771626' AS DateTime2), N'31999a30-e65e-4d65-8719-f4c21f40edfa', 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'1c8f7aba-c0ec-4457-81d5-2e302de1577a', N'4c772c03-ef45-492a-82d7-24bd49320ea3', N'Referral', 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.0774985' 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'1f8c8a27-a0bf-4e37-b609-8bf2ac93dadd', N'410f20e6-ad68-450b-9cf3-55da4793042c', N'Doctor', N'Assistance', 1000, 0, N'KidneyOP_1', N'a5c8f1df-75e3-41e6-b77f-76aec925404e', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2018-12-13T16:01:55.2700868' AS DateTime2), CAST(N'2018-12-22T16:17:56.9948653' AS DateTime2), N'3185ec7e-59f6-4fdc-b1ff-b0d47865fd59', NULL, N'NCINV0034', N'NCINV0034', N'1000', NULL, 0, 0, N'Operation', CAST(N'2018-12-13T15:36:00.3756381' AS DateTime2), NULL, 1, N'NA', N'NA', N'NA')
INSERT [dbo].[Commission] ([Id], [EmployeeId], [EmployeeType], [CommissionType], [Amount], [IsPaid], [Title], [InvoiceId], [HospitalId], [DateTime], [CreatedTime], [UpdatedTime], [MainInvoiceId], [PaymentGroup], [MainInvoiceCode], [InvoiceCode], [PercentOrValue], [InvoiceTotal], [LessAmount], [SpecialAmount], [Category], [InvoiceCreatedTime], [InvoiceDiagnosticTestId], [IsPaidFinally], [PaymentId], [ReceiptCreatedTime], [BarCodeImageUrl]) VALUES (N'20b407fd-88ce-4688-a688-7c4d608fd86c', N'1fc95b60-c117-4163-b73d-37bd64d7fac8', N'Doctor', N'ASSISTANT_DOCTOR', 111, 0, N'KidneyOP_1', N'93443976-2220-48f9-8268-cdecc45440be', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2018-12-17T09:42:25.1441690' AS DateTime2), CAST(N'2018-12-22T16:17:56.9948653' AS DateTime2), N'83281dd4-5998-4b90-bd4f-ad30ae28cfa6', NULL, N'NCINV0036', N'NCINV0036', N'111', NULL, 0, 0, N'Operation', CAST(N'2018-12-17T09:30:58.2648648' 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'21d2b581-a2a9-468e-aa0a-c65e92453234', N'2f49ff36-b04f-4081-9261-60ec973da26d', N'Doctor', N'CombineCategory_1', 40, 0, N'', N'86b66756-7719-470a-85a5-866eb64fd3c7', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2019-01-26T15:32:08.1488031' AS DateTime2), CAST(N'2019-02-03T08:17:35.7629175' AS DateTime2), N'NOTASSIGNED', N'NCR0114', NULL, N'NCDG0109', N'10%', 1150, 0, 0, N'Test', CAST(N'2019-01-26T15:32:07.4469164' 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'2253b473-4649-4a22-b589-3b477f4eb467', N'e3d4a527-b8d6-4e80-8e15-ddd22394a385', N'Doctor', N'Pathology', -17.391304347826086, 1, N'', N'22d470c7-cb02-4d5b-99d5-c276c653412f', N'd821cd9f-ac10-4f94-92cf-c292cd83b2c0', NULL, CAST(N'2018-07-21T12:40:23.6600000' AS DateTime2), CAST(N'2018-09-04T22:35:23.0400000' AS DateTime2), N'45daa90c-6a81-4de1-a0b8-96142e893b17', N'RR0016', N'RINV0028', N'RDG0046', N'0%', 1100, 50, 0, N'Test', CAST(N'2018-07-21T12:32:18.4566667' AS DateTime2), NULL, 0, N'NA', N'NA', N'NA')
INSERT [dbo].[Commission] ([Id], [EmployeeId], [EmployeeType], [CommissionType], [Amount], [IsPaid], [Title], [InvoiceId], [HospitalId], [DateTime], [CreatedTime], [UpdatedTime], [MainInvoiceId], [PaymentGroup], [MainInvoiceCode], [InvoiceCode], [PercentOrValue], [InvoiceTotal], [LessAmount], [SpecialAmount], [Category], [InvoiceCreatedTime], [InvoiceDiagnosticTestId], [IsPaidFinally], [PaymentId], [ReceiptCreatedTime], [BarCodeImageUrl]) VALUES (N'235602e3-3061-49af-9bd9-2effd638b259', N'1fc95b60-c117-4163-b73d-37bd64d7fac8', N'Doctor', N'CLINIC_REFERRAL', 1000, 0, N'ClinicInvoice', N'NOTASSIGNED', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2018-12-15T12:12:30.9583074' 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'23bf1a17-b782-499a-99d0-d3bd2bcd9531', N'f58ff95f-89e6-4f8e-8868-a83828ebe999', N'Doctor', N'Biochemistry ', 50, 1, N'', N'c5e84ccb-38d8-4ca4-a224-92ea42e0f4c5', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2019-02-02T16:42:10.8214195' AS DateTime2), CAST(N'2019-02-23T12:47:42.5142667' AS DateTime2), N'NOTASSIGNED', N'NCR0120', NULL, N'NCDG0115', N'10%', 1234, 0, 0, N'Test', CAST(N'2019-02-02T16:42:10.5098169' AS DateTime2), NULL, 1, N'NCP0062', N'23-02-2019 12:47 PM', N'data:image/jpeg;base64,[encoded data, 8420 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'23d60dbf-fd6d-4c8b-80f1-e491f4a3a8c7', N'95b82f5e-e170-495e-a68b-05cf1af9bd8c', N'Referral', N'Hematology', 40, 1, N'', N'9d6426a8-e938-49c8-995e-84b6d1d5df6e', N'd821cd9f-ac10-4f94-92cf-c292cd83b2c0', NULL, CAST(N'2018-08-03T15:08:41.0033333' AS DateTime2), CAST(N'2018-09-04T22:21:52.4500000' AS DateTime2), N'697cd337-22e2-4411-97c0-2fe1577b3849', N'RR0047', N'RINV0087', N'RDG0104', N'40', 600, 0, 0, N'Test', CAST(N'2018-08-03T13:28:11.8466667' 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'2410670c-a8e9-4108-a17a-5351c26176ab', N'f58ff95f-89e6-4f8e-8868-a83828ebe999', N'Doctor', N'ASSIGNED_DOCTOR', 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.9086371' AS DateTime2), CAST(N'2018-12-27T12:05:15.6569742' 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-26T12:45:35.8356009' AS DateTime2), NULL, 1, N'NCP0028', 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'25016a87-6285-4756-b47f-b2595e0602e3', N'65ba8697-497a-4f36-bd6c-668eba0c5d62', N'Doctor', N'ASSISTANT_DOCTOR', 676, 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', NULL, N'NCINV0041', N'NCINV0041', N'676', NULL, 0, 0, N'Operation', CAST(N'2018-12-26T08:09:45.3326896' AS DateTime2), NULL, 0, N'NCP0018', 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'2533f0db-75b7-40d5-8884-656c4aa75d52', 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.5838767' 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'8b8d4f8e-c55f-4968-8e9d-7ce0774f7319', 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'2552a1f4-c03a-43cf-abe7-0683ef0beb1b', N'f58ff95f-89e6-4f8e-8868-a83828ebe999', N'Doctor', N'CombineCategory_1', 12.3, 1, N'', N'4bac4ff3-459b-4475-8761-1773a8b06677', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2018-12-25T16:06:14.3452316' AS DateTime2), CAST(N'2018-12-25T16:07:39.3366352' AS DateTime2), N'NOTASSIGNED', N'NCR0092', NULL, N'NCDG0080', N'10%', 740.7, 82.3, 0, N'Test', CAST(N'2018-12-25T16:06:13.9164993' AS DateTime2), NULL, 1, N'NCP0012', N'25-Dec-18 4:07 PM', N'NA')
INSERT [dbo].[Commission] ([Id], [EmployeeId], [EmployeeType], [CommissionType], [Amount], [IsPaid], [Title], [InvoiceId], [HospitalId], [DateTime], [CreatedTime], [UpdatedTime], [MainInvoiceId], [PaymentGroup], [MainInvoiceCode], [InvoiceCode], [PercentOrValue], [InvoiceTotal], [LessAmount], [SpecialAmount], [Category], [InvoiceCreatedTime], [InvoiceDiagnosticTestId], [IsPaidFinally], [PaymentId], [ReceiptCreatedTime], [BarCodeImageUrl]) VALUES (N'257e2b85-e1e1-4bcb-ae0e-6a4f80a9b0b8', N'4c772c03-ef45-492a-82d7-24bd49320ea3', N'Doctor', N'UltraSoundCategory_2', 25.5, 0, N'', N'3e34586b-5b04-4755-ae22-5694878a495e', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2019-01-21T15:49:34.8248721' 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'268c3e65-2628-48a2-b531-af7c1bd5199a', N'2f49ff36-b04f-4081-9261-60ec973da26d', N'Referral', N'CT_2', 4.4, 1, N'', N'7563126c-a5b2-40ab-bdef-ef3b9f9dbfc4', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2018-11-26T10:07:00.2557191' AS DateTime2), CAST(N'2018-11-26T13:54:40.8779096' AS DateTime2), N'NOTASSIGNED', N'NCR0006', NULL, N'NCDG0056', N'10%', 1227.03, 499.97, 0, N'Test', CAST(N'2018-11-26T09:22:21.0580030' AS DateTime2), NULL, 0, N'NA', N'NA', N'NA')
INSERT [dbo].[Commission] ([Id], [EmployeeId], [EmployeeType], [CommissionType], [Amount], [IsPaid], [Title], [InvoiceId], [HospitalId], [DateTime], [CreatedTime], [UpdatedTime], [MainInvoiceId], [PaymentGroup], [MainInvoiceCode], [InvoiceCode], [PercentOrValue], [InvoiceTotal], [LessAmount], [SpecialAmount], [Category], [InvoiceCreatedTime], [InvoiceDiagnosticTestId], [IsPaidFinally], [PaymentId], [ReceiptCreatedTime], [BarCodeImageUrl]) VALUES (N'26dcae89-a9f8-4941-9844-19ab428b623e', N'f58ff95f-89e6-4f8e-8868-a83828ebe999', N'Doctor', N'UltraSoundCategory_2', 13.6, 1, N'', N'24e4ffc4-6392-4eb1-a842-d19b9ccf6475', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2018-12-03T16:05:49.9403932' AS DateTime2), CAST(N'2018-12-03T16:23:05.5178268' AS DateTime2), N'NOTASSIGNED', N'NCR0020', NULL, N'NCDG0063', N'20%', 314, 0, 0, N'Test', CAST(N'2018-12-03T16:05:49.6665426' AS DateTime2), NULL, 0, N'NA', N'NA', N'NA')
INSERT [dbo].[Commission] ([Id], [EmployeeId], [EmployeeType], [CommissionType], [Amount], [IsPaid], [Title], [InvoiceId], [HospitalId], [DateTime], [CreatedTime], [UpdatedTime], [MainInvoiceId], [PaymentGroup], [MainInvoiceCode], [InvoiceCode], [PercentOrValue], [InvoiceTotal], [LessAmount], [SpecialAmount], [Category], [InvoiceCreatedTime], [InvoiceDiagnosticTestId], [IsPaidFinally], [PaymentId], [ReceiptCreatedTime], [BarCodeImageUrl]) VALUES (N'28926a02-34dd-40aa-afab-128bc1fa0edc', N'2f49ff36-b04f-4081-9261-60ec973da26d', N'Referral', N'UltraSoundCategory_2', 63.84, 1, N'', N'003042e8-1731-43ad-a3cd-906998b3e07d', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2018-12-05T16:07:50.4587323' AS DateTime2), CAST(N'2018-12-06T10:02:51.8904588' AS DateTime2), N'NOTASSIGNED', N'NCR0029', NULL, N'NCDG0066', N'24%', 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'28e60ccc-06f8-4faf-8891-b28c1ba8ce8f', N'45c6d504-e6fb-4da1-9454-92195a3dba94', N'Doctor', N'Pathology', -58.695652173913047, 1, N'', N'51c1122d-de73-48a8-b5f3-11dbd65883d8', N'd821cd9f-ac10-4f94-92cf-c292cd83b2c0', NULL, CAST(N'2018-07-20T10:57:07.4100000' AS DateTime2), CAST(N'2018-09-04T22:21:52.4500000' AS DateTime2), N'd4384253-b264-43c8-b337-297dfdb59c3c', N'RR0040', N'RINV0022', N'RDG0040', N'0%', 1000, 150, 0, N'Test', CAST(N'2018-07-20T10:45:14.6333333' AS DateTime2), NULL, 0, N'NA', N'NA', N'NA')
INSERT [dbo].[Commission] ([Id], [EmployeeId], [EmployeeType], [CommissionType], [Amount], [IsPaid], [Title], [InvoiceId], [HospitalId], [DateTime], [CreatedTime], [UpdatedTime], [MainInvoiceId], [PaymentGroup], [MainInvoiceCode], [InvoiceCode], [PercentOrValue], [InvoiceTotal], [LessAmount], [SpecialAmount], [Category], [InvoiceCreatedTime], [InvoiceDiagnosticTestId], [IsPaidFinally], [PaymentId], [ReceiptCreatedTime], [BarCodeImageUrl]) VALUES (N'292c722b-5107-4187-9512-c2cac978b996', N'2f49ff36-b04f-4081-9261-60ec973da26d', N'Doctor', N'ASSISTANT_SURGEON', 7890, 1, N'KidneyOP_1', N'a57d776c-6f61-4d28-b156-7ad6277382b5', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2019-01-17T11:31:59.0508875' AS DateTime2), CAST(N'2019-01-17T13:16:26.1960178' 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'NCP0038', 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'2931dfda-1f63-455b-b4d0-93ebdae6f5ba', N'2f49ff36-b04f-4081-9261-60ec973da26d', N'Doctor', N'CLINIC_REFERRAL', 1000, 0, N'ClinicInvoice', N'6053f232-6be1-4ee5-8d27-90aae0b8679e', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2018-12-18T11:05:11.2150109' AS DateTime2), CAST(N'2018-12-22T16:17:56.9948653' AS DateTime2), N'83281dd4-5998-4b90-bd4f-ad30ae28cfa6', NULL, N'NCINV0036', N'NOTASSIGNED', N'1000', NULL, 0, 0, N'OPERATION', CAST(N'2018-12-17T08:57:09.7197221' AS DateTime2), NULL, 1, N'NA', N'NA', N'NA')
INSERT [dbo].[Commission] ([Id], [EmployeeId], [EmployeeType], [CommissionType], [Amount], [IsPaid], [Title], [InvoiceId], [HospitalId], [DateTime], [CreatedTime], [UpdatedTime], [MainInvoiceId], [PaymentGroup], [MainInvoiceCode], [InvoiceCode], [PercentOrValue], [InvoiceTotal], [LessAmount], [SpecialAmount], [Category], [InvoiceCreatedTime], [InvoiceDiagnosticTestId], [IsPaidFinally], [PaymentId], [ReceiptCreatedTime], [BarCodeImageUrl]) VALUES (N'2982df09-02f6-404d-88a1-f17da0c0ee0b', N'7a432ef3-78e3-4091-811b-11fc802fb981', N'Doctor', N'Pathology (Combination)', -383.33333333333331, 1, N'', N'4469621b-8a3f-4ae6-9e23-a0a15e6b3414', N'd821cd9f-ac10-4f94-92cf-c292cd83b2c0', NULL, CAST(N'2018-07-15T10:00:46.6133333' AS DateTime2), CAST(N'2018-09-04T22:21:52.4533333' AS DateTime2), N'a09d1933-a42e-4b01-8f2f-08ffd0109967', N'RR0042', N'RINV0009', N'RDG0025', N'0%', 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'29ab7fcb-f26b-489a-8a97-f1e7a74014c8', N'aa1bef3d-ea7c-404a-9d19-2347fcd8fad9', N'Doctor', N'Pathology', 60, 1, N'', N'cc6b598c-3380-46d1-a4e2-28dfc45b783e', N'd821cd9f-ac10-4f94-92cf-c292cd83b2c0', NULL, CAST(N'2018-07-23T14:55:31.1466667' AS DateTime2), CAST(N'2018-09-04T22:35:23.0500000' AS DateTime2), N'5610283e-bfdd-4559-813b-66c681d1914a', N'RR0017', 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'29c34f70-98bf-4b84-8471-abc8ce909ee0', N'4c772c03-ef45-492a-82d7-24bd49320ea3', N'Referral', N'Biochemistry ', 50, 1, N'', N'4bac4ff3-459b-4475-8761-1773a8b06677', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2018-12-25T16:06:14.3392350' AS DateTime2), CAST(N'2018-12-25T16:07:36.8553368' AS DateTime2), N'NOTASSIGNED', N'NCR0091', NULL, N'NCDG0080', N'10%', 740.7, 82.3, 0, N'Test', CAST(N'2018-12-25T16:06:13.9164993' AS DateTime2), NULL, 1, N'NCP0013', N'25-Dec-18 4:07 PM', N'NA')
INSERT [dbo].[Commission] ([Id], [EmployeeId], [EmployeeType], [CommissionType], [Amount], [IsPaid], [Title], [InvoiceId], [HospitalId], [DateTime], [CreatedTime], [UpdatedTime], [MainInvoiceId], [PaymentGroup], [MainInvoiceCode], [InvoiceCode], [PercentOrValue], [InvoiceTotal], [LessAmount], [SpecialAmount], [Category], [InvoiceCreatedTime], [InvoiceDiagnosticTestId], [IsPaidFinally], [PaymentId], [ReceiptCreatedTime], [BarCodeImageUrl]) VALUES (N'29dd723a-35cb-4128-a614-c002d9008693', N'4c772c03-ef45-492a-82d7-24bd49320ea3', N'Doctor', N'CLINIC_REFERRAL', 33, 0, N'ClinicInvoice', N'98353a85-5c28-430f-9863-e23c55ed988b', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2019-01-14T10:42:16.8722708' 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'2a7a8461-2502-4bca-85d4-0ae7fe80d3a2', N'bb6d3d69-74b2-4218-b563-49d01cfbe205', N'Doctor', N'CombineCategory_1', 0, 0, N'', N'02a0bc61-fe04-4dab-a57c-673eaf1a8fea', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2019-02-22T22:39:33.3765407' AS DateTime2), CAST(N'2019-02-22T22:42:42.8491643' AS DateTime2), N'NOTASSIGNED', NULL, NULL, N'NCDG0119', N'0%', 9111.6, 1012.4, 0, N'Test', CAST(N'2019-02-22T22:34:49.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'2a80a525-1f1c-4909-90d0-da8b892b3cfc', N'f58ff95f-89e6-4f8e-8868-a83828ebe999', N'UltraSoundDoctor', N'UltraSoundCategory_1', 0, 0, N'', N'3e34586b-5b04-4755-ae22-5694878a495e', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2019-01-21T15:49:34.4087948' 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'6ee1a1bb-4f17-4975-86f3-8ca7c7c2c2a3', 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'2b0a64ff-1892-468f-8d6a-fc11fa117648', N'4c772c03-ef45-492a-82d7-24bd49320ea3', N'Doctor', N'CLINIC_REFERRAL', 1110, 1, N'ClinicInvoice', N'ed185430-98cf-4601-a800-af46d9f4f6b5', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2018-12-20T13:32:18.1279675' AS DateTime2), CAST(N'2018-12-22T16:40:45.4036696' AS DateTime2), N'9c0c25c5-11fc-4a52-a928-6cfebda17d20', N'NCR0069', N'NCINV0038', N'NOTASSIGNED', N'1110', NULL, 0, 0, N'OPERATION', CAST(N'2018-12-20T13:30:52.0965180' 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'2c37aceb-b63d-4665-b6a0-7863b4bc2015', N'aa1bef3d-ea7c-404a-9d19-2347fcd8fad9', N'Doctor', N'ECG/ECO', -63.95348837209302, 1, N'', N'7a054570-a86b-44e4-b924-ce2c3d1cd64e', N'd821cd9f-ac10-4f94-92cf-c292cd83b2c0', NULL, CAST(N'2018-07-16T17:41:26.7900000' 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')
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'2c412087-699c-4464-854d-a4fe30d28a3b', N'6ee087eb-7031-408f-b4ea-f567d250f75b', N'Doctor', N'DoctorVisit', 108900, 0, N'', N'92c96ad2-6447-4458-bef1-b92f1932ebca', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2019-01-14T10:42:41.9078823' AS DateTime2), CAST(N'2019-02-03T08:17:35.7629175' AS DateTime2), N'ee0b1f7f-b2bc-46e2-abf6-e16c6d791ec1', N'NCR0114', N'NCINV0047', NULL, NULL, 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'2c8b44e2-7a29-4446-b919-aca830f7d977', N'4c772c03-ef45-492a-82d7-24bd49320ea3', N'UltraSoundDoctor', N'UltraSoundCategory_2', 0, 0, N'', N'003042e8-1731-43ad-a3cd-906998b3e07d', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2018-12-05T16:07:50.2088854' AS DateTime2), CAST(N'2018-12-22T16:17:56.9948653' AS DateTime2), N'NOTASSIGNED', NULL, N'NOTASSIGNED', N'NCDG0066', NULL, 512, 51.2, 0, N'Test', CAST(N'2018-12-05T16:07:49.8740832' AS DateTime2), N'767b14df-30bd-4659-9245-d8645990d20b', 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'2ca24333-3c47-4192-b9b0-d5b9b2cf2096', N'2f49ff36-b04f-4081-9261-60ec973da26d', N'Doctor', N'CLINIC_REFERRAL', 1110, 0, N'ClinicInvoice', N'1df9d566-c333-49b1-ae88-db40b39099cb', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2018-12-20T13:32:13.8472022' AS DateTime2), CAST(N'2018-12-22T16:17:56.9948653' AS DateTime2), N'9c0c25c5-11fc-4a52-a928-6cfebda17d20', NULL, N'NCINV0038', N'NOTASSIGNED', N'1110', NULL, 0, 0, N'OPERATION', CAST(N'2018-12-20T13:30:52.0965180' 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'2d7e1e5c-c95a-42cc-a5cf-3e5810a3a3e9', N'4c772c03-ef45-492a-82d7-24bd49320ea3', N'Doctor', N'CT_2', 23.3, 0, N'', N'15a731c0-16d0-4ab4-a55b-8352a17027fc', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2018-11-19T15:21:13.1068756' AS DateTime2), CAST(N'2018-12-22T16:17:56.9948653' AS DateTime2), N'NOTASSIGNED', NULL, NULL, N'NCDG0043', N'10%', 1556, 0, 0, N'Test', CAST(N'0001-01-01T00:00:00.0000000' AS DateTime2), NULL, 1, N'NA', N'NA', N'NA')
INSERT [dbo].[Commission] ([Id], [EmployeeId], [EmployeeType], [CommissionType], [Amount], [IsPaid], [Title], [InvoiceId], [HospitalId], [DateTime], [CreatedTime], [UpdatedTime], [MainInvoiceId], [PaymentGroup], [MainInvoiceCode], [InvoiceCode], [PercentOrValue], [InvoiceTotal], [LessAmount], [SpecialAmount], [Category], [InvoiceCreatedTime], [InvoiceDiagnosticTestId], [IsPaidFinally], [PaymentId], [ReceiptCreatedTime], [BarCodeImageUrl]) VALUES (N'2d8374a2-859e-41a4-934d-7f53f027ecf0', N'f58ff95f-89e6-4f8e-8868-a83828ebe999', N'Referral', N'Ultrasound', 70, 0, N'', N'8be24963-914e-473d-b269-d80182e42daf', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2018-11-25T08:59:06.4380852' AS DateTime2), CAST(N'2018-12-22T16:17:56.9948653' AS DateTime2), N'NOTASSIGNED', NULL, NULL, N'NCDG0054', N'10%', 4699.8, 522.2, 0, N'Test', CAST(N'2018-11-25T08:59:05.7217518' AS DateTime2), NULL, 1, N'NA', N'NA', N'NA')
INSERT [dbo].[Commission] ([Id], [EmployeeId], [EmployeeType], [CommissionType], [Amount], [IsPaid], [Title], [InvoiceId], [HospitalId], [DateTime], [CreatedTime], [UpdatedTime], [MainInvoiceId], [PaymentGroup], [MainInvoiceCode], [InvoiceCode], [PercentOrValue], [InvoiceTotal], [LessAmount], [SpecialAmount], [Category], [InvoiceCreatedTime], [InvoiceDiagnosticTestId], [IsPaidFinally], [PaymentId], [ReceiptCreatedTime], [BarCodeImageUrl]) VALUES (N'2e003088-e38f-4223-8282-ff4f5d1d0081', N'2f49ff36-b04f-4081-9261-60ec973da26d', N'Referral', N'Conbination', 1220, 0, N'', N'bf6974a6-9f9e-4640-bd8f-535bab6e4eab', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2019-01-08T11:27:33.1605848' 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'2e605ef3-6368-4d08-b9e7-06f6bf179383', N'f58ff95f-89e6-4f8e-8868-a83828ebe999', N'Doctor', N'CombineCategory_1', 200, 1, N'', N'842671da-0061-4672-b0ca-22660eee3ef5', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2018-12-24T13:34:09.6321946' AS DateTime2), CAST(N'2018-12-24T14:11:26.5307031' AS DateTime2), N'NOTASSIGNED', N'NCR0079', NULL, N'NCDG0076', N'10%', 1100.7, 122.3, 0, N'Test', CAST(N'2018-12-24T13:34:09.3753377' AS DateTime2), NULL, 1, N'NCP0004', N'NA', N'NA')
INSERT [dbo].[Commission] ([Id], [EmployeeId], [EmployeeType], [CommissionType], [Amount], [IsPaid], [Title], [InvoiceId], [HospitalId], [DateTime], [CreatedTime], [UpdatedTime], [MainInvoiceId], [PaymentGroup], [MainInvoiceCode], [InvoiceCode], [PercentOrValue], [InvoiceTotal], [LessAmount], [SpecialAmount], [Category], [InvoiceCreatedTime], [InvoiceDiagnosticTestId], [IsPaidFinally], [PaymentId], [ReceiptCreatedTime], [BarCodeImageUrl]) VALUES (N'2ed11607-22df-4499-8dd6-d17342c034ff', N'f58ff95f-89e6-4f8e-8868-a83828ebe999', N'Doctor', 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.1359696' 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'2f4dd372-c670-4d76-89be-e4758ff5d52c', N'2f49ff36-b04f-4081-9261-60ec973da26d', N'Doctor', N'Haematology', 15, 0, N'', N'34fc05d9-22b2-478c-9ca0-f9a14d2e39a3', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2018-11-22T15:12:52.0734999' 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'30369582-3027-49f4-8580-d013af02286e', N'24a50fd4-8d08-41d3-94e5-be95c9e77925', N'Doctor', N'Ultrasound', -82.051282051282044, 1, N'', N'c58a7b22-0d04-4786-8350-d805dddce26d', N'd821cd9f-ac10-4f94-92cf-c292cd83b2c0', NULL, CAST(N'2018-07-09T21:55:24.3933333' AS DateTime2), CAST(N'2018-09-04T22:35:23.0500000' AS DateTime2), N'86369ff8-4d85-4b08-8b42-7ba206964d7a', N'RR0004', N'RINV0006', N'RDG0018', N'0%', 1750, 200, 0, N'Test', CAST(N'2018-07-09T21:50:19.0200000' AS DateTime2), NULL, 0, N'NA', N'NA', N'NA')
INSERT [dbo].[Commission] ([Id], [EmployeeId], [EmployeeType], [CommissionType], [Amount], [IsPaid], [Title], [InvoiceId], [HospitalId], [DateTime], [CreatedTime], [UpdatedTime], [MainInvoiceId], [PaymentGroup], [MainInvoiceCode], [InvoiceCode], [PercentOrValue], [InvoiceTotal], [LessAmount], [SpecialAmount], [Category], [InvoiceCreatedTime], [InvoiceDiagnosticTestId], [IsPaidFinally], [PaymentId], [ReceiptCreatedTime], [BarCodeImageUrl]) VALUES (N'30949d91-84fc-44ae-bed5-afd94959f8a0', N'4c772c03-ef45-492a-82d7-24bd49320ea3', N'Referral', N'Biochemistry ', 50, 0, N'', N'3c7e7e81-8d2d-4efa-b73b-a323bc9a8bba', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2018-11-21T16:43:04.0668362' AS DateTime2), CAST(N'2018-12-22T16:17:56.9948653' AS DateTime2), N'NOTASSIGNED', NULL, NULL, N'NCDG0049', N'10%', 500, 0, 0, N'Test', CAST(N'2018-11-21T16:41:14.7028043' 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'30a4a987-366e-4733-8271-89e9b8188df5', N'f58ff95f-89e6-4f8e-8868-a83828ebe999', N'Referral', N'CombineCategory_1', 5.38, 0, N'', N'65513723-2d7e-40ba-989d-11c1138646df', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2018-11-25T13:14:54.6392773' AS DateTime2), CAST(N'2018-12-22T16:17:56.9948653' AS DateTime2), N'NOTASSIGNED', NULL, NULL, N'NCDG0055', N'6%', 964.8, 241.2, 0, N'Test', CAST(N'2018-11-25T13:14:54.0936648' AS DateTime2), NULL, 1, N'NA', N'NA', N'NA')
INSERT [dbo].[Commission] ([Id], [EmployeeId], [EmployeeType], [CommissionType], [Amount], [IsPaid], [Title], [InvoiceId], [HospitalId], [DateTime], [CreatedTime], [UpdatedTime], [MainInvoiceId], [PaymentGroup], [MainInvoiceCode], [InvoiceCode], [PercentOrValue], [InvoiceTotal], [LessAmount], [SpecialAmount], [Category], [InvoiceCreatedTime], [InvoiceDiagnosticTestId], [IsPaidFinally], [PaymentId], [ReceiptCreatedTime], [BarCodeImageUrl]) VALUES (N'31070efd-be8d-45b4-9d74-eafe46b2482a', N'8d3cf8f9-7ef7-4008-b529-e05a062b3f0c', N'Doctor', N'ANESTHESIA_DOCTOR', 0, 0, N'KidneyOP_1', N'a57d776c-6f61-4d28-b156-7ad6277382b5', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2019-01-17T11:43:12.0494046' AS DateTime2), CAST(N'2019-02-03T08:17:35.7629175' AS DateTime2), N'f253682d-6adc-4661-b133-62ba078575b5', N'NCR0114', N'NCINV0050', N'NCINV0050', N'0', NULL, 0, 0, N'Operation', CAST(N'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'319c40f2-cb82-46c7-8cc2-7fc81804c284', 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.4815774' 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'ce5f4c5a-4aad-4834-9f7b-4ea6b4f48467', 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'319e16d4-576e-493d-bd00-ed705555b55d', N'f58ff95f-89e6-4f8e-8868-a83828ebe999', N'Doctor', N'Conbination', 0, 0, N'', N'86636fc7-fea3-4e6c-ad30-5f4bea4f8417', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2018-11-24T13:30:55.9183521' AS DateTime2), CAST(N'2018-12-22T16:17:56.9948653' AS DateTime2), N'NOTASSIGNED', NULL, NULL, N'NCDG0053', N'0', 1356.05, 199.95, 0, N'Test', CAST(N'2018-11-24T13:30:55.6012090' AS DateTime2), NULL, 1, N'NA', N'NA', N'NA')
INSERT [dbo].[Commission] ([Id], [EmployeeId], [EmployeeType], [CommissionType], [Amount], [IsPaid], [Title], [InvoiceId], [HospitalId], [DateTime], [CreatedTime], [UpdatedTime], [MainInvoiceId], [PaymentGroup], [MainInvoiceCode], [InvoiceCode], [PercentOrValue], [InvoiceTotal], [LessAmount], [SpecialAmount], [Category], [InvoiceCreatedTime], [InvoiceDiagnosticTestId], [IsPaidFinally], [PaymentId], [ReceiptCreatedTime], [BarCodeImageUrl]) VALUES (N'31af21aa-70a2-4e7a-bcd9-9b4474650342', N'6ee087eb-7031-408f-b4ea-f567d250f75b', N'Doctor', N'ASSISTANT_DOCTOR', 44, 0, N'KidneyOP_1', N'6f15c7a7-bea3-4a8d-8d86-bf13496b80f1', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2018-12-20T13:30:05.3396959' AS DateTime2), CAST(N'2018-12-22T16:17:56.9948653' AS DateTime2), N'ebce39be-4d21-4251-835d-2620dd8fe8aa', NULL, N'NCINV0037', N'NCINV0037', N'44', NULL, 0, 0, N'Operation', CAST(N'2018-12-20T13:29:01.5391556' AS DateTime2), NULL, 1, N'NA', N'NA', N'NA')
INSERT [dbo].[Commission] ([Id], [EmployeeId], [EmployeeType], [CommissionType], [Amount], [IsPaid], [Title], [InvoiceId], [HospitalId], [DateTime], [CreatedTime], [UpdatedTime], [MainInvoiceId], [PaymentGroup], [MainInvoiceCode], [InvoiceCode], [PercentOrValue], [InvoiceTotal], [LessAmount], [SpecialAmount], [Category], [InvoiceCreatedTime], [InvoiceDiagnosticTestId], [IsPaidFinally], [PaymentId], [ReceiptCreatedTime], [BarCodeImageUrl]) VALUES (N'31c31cb4-3a3b-49be-a559-a0abdc60d208', 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.3996268' 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'b96d22a0-db95-4a2b-8084-3d8ca57b0765', 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'31d681b4-74bb-49de-8150-d8313a4b7084', N'4c772c03-ef45-492a-82d7-24bd49320ea3', N'Doctor', N'CombineCategory_1', 35.6, 0, N'', N'cdc3b1aa-6295-40f8-a64a-22c9e2ac20f6', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2019-01-07T13:03:42.3238930' AS DateTime2), CAST(N'2019-02-03T08:17:35.7629175' AS DateTime2), N'NOTASSIGNED', N'NCR0114', NULL, N'NCDG0088', N'10%', 609, 0, 0, N'Test', CAST(N'2019-01-07T13:03:41.3549972' AS DateTime2), NULL, 1, NULL, N'03-02-2019 8:17 AM', N'data:image/jpeg;base64,[encoded data, 8380 characters]')
INSERT [dbo].[Commission] ([Id], [EmployeeId], [EmployeeType], [CommissionType], [Amount], [IsPaid], [Title], [InvoiceId], [HospitalId], [DateTime], [CreatedTime], [UpdatedTime], [MainInvoiceId], [PaymentGroup], [MainInvoiceCode], [InvoiceCode], [PercentOrValue], [InvoiceTotal], [LessAmount], [SpecialAmount], [Category], [InvoiceCreatedTime], [InvoiceDiagnosticTestId], [IsPaidFinally], [PaymentId], [ReceiptCreatedTime], [BarCodeImageUrl]) VALUES (N'31da6fd9-118a-48a6-b54a-c4357ff44c04', N'4c772c03-ef45-492a-82d7-24bd49320ea3', N'Doctor', 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.4068361' 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'3231b297-1467-49a2-a43d-1aba25b7c2e3', N'4c772c03-ef45-492a-82d7-24bd49320ea3', N'Doctor', N'ASSIGNED_DOCTOR', 100, 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', NULL, N'NCINV0041', N'NCINV0041', N'2000', NULL, 0, 0, N'Operation', CAST(N'2018-12-26T08:09:45.3326896' AS DateTime2), NULL, 0, N'NCP0014', 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'32363685-a0ef-4bd4-9b98-5479dd4caa6c', N'f58ff95f-89e6-4f8e-8868-a83828ebe999', N'Doctor', N'Biochemistry ', 200, 1, N'', N'842671da-0061-4672-b0ca-22660eee3ef5', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2018-12-24T13:34:09.6361776' AS DateTime2), CAST(N'2018-12-24T14:11:26.5307031' AS DateTime2), N'NOTASSIGNED', N'NCR0079', NULL, N'NCDG0076', N'10%', 1100.7, 122.3, 0, N'Test', CAST(N'2018-12-24T13:34:09.3753377' AS DateTime2), NULL, 1, N'NCP0004', N'NA', N'NA')
INSERT [dbo].[Commission] ([Id], [EmployeeId], [EmployeeType], [CommissionType], [Amount], [IsPaid], [Title], [InvoiceId], [HospitalId], [DateTime], [CreatedTime], [UpdatedTime], [MainInvoiceId], [PaymentGroup], [MainInvoiceCode], [InvoiceCode], [PercentOrValue], [InvoiceTotal], [LessAmount], [SpecialAmount], [Category], [InvoiceCreatedTime], [InvoiceDiagnosticTestId], [IsPaidFinally], [PaymentId], [ReceiptCreatedTime], [BarCodeImageUrl]) VALUES (N'32468909-115d-487e-8050-1e7cdf47d46f', N'2f49ff36-b04f-4081-9261-60ec973da26d', N'Doctor', N'DoctorVisit', 55, 0, N'', N'NOTASSIGNED', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2018-12-20T16:09:38.4988866' AS DateTime2), CAST(N'2018-12-22T16:17:56.9948653' AS DateTime2), N'e442f9c5-c767-48c4-a0e9-983012f4bb00', NULL, N'NCINV0039', 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'3275e89a-7257-46ab-b89d-147bf7008d14', N'8d3cf8f9-7ef7-4008-b529-e05a062b3f0c', N'Doctor', N'DoctorVisit', 3344, 0, N'', N'NOTASSIGNED', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2019-01-17T13:14:49.3046421' AS DateTime2), CAST(N'2019-02-03T08:17:35.7629175' AS DateTime2), N'f253682d-6adc-4661-b133-62ba078575b5', N'NCR0114', NULL, N'NOTASSIGNED', NULL, NULL, 0, 0, N'ADDED_JUST_FOR_COMMISSION', CAST(N'0001-01-01T00:00:00.0000000' AS DateTime2), NULL, 1, NULL, N'03-02-2019 8:17 AM', N'data:image/jpeg;base64,[encoded data, 8380 characters]')
INSERT [dbo].[Commission] ([Id], [EmployeeId], [EmployeeType], [CommissionType], [Amount], [IsPaid], [Title], [InvoiceId], [HospitalId], [DateTime], [CreatedTime], [UpdatedTime], [MainInvoiceId], [PaymentGroup], [MainInvoiceCode], [InvoiceCode], [PercentOrValue], [InvoiceTotal], [LessAmount], [SpecialAmount], [Category], [InvoiceCreatedTime], [InvoiceDiagnosticTestId], [IsPaidFinally], [PaymentId], [ReceiptCreatedTime], [BarCodeImageUrl]) VALUES (N'32b7465f-272c-4d86-98f4-92703fff6e4c', N'7b3c0574-a184-4081-9a43-0b8360b4e107', N'Doctor', N'ASSISTANT_DOCTOR', 33, 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'33', 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'32d996d9-7fdb-489c-ba10-52ee4ba6e2ab', N'f58ff95f-89e6-4f8e-8868-a83828ebe999', N'Doctor', N'Biochemistry ', 25, 0, N'', N'5e555d75-f6b1-4a96-8483-d65e27f3ec6b', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2019-01-07T16:44:25.4067209' AS DateTime2), CAST(N'2019-02-03T08:17:35.7629175' AS DateTime2), N'ebce39be-4d21-4251-835d-2620dd8fe8aa', N'NCR0114', NULL, N'NCDG0090', N'10%', 294, 0, 0, N'Test', CAST(N'2019-01-07T16:44:24.6661795' AS DateTime2), NULL, 1, NULL, N'03-02-2019 8:17 AM', N'data:image/jpeg;base64,[encoded data, 8380 characters]')
INSERT [dbo].[Commission] ([Id], [EmployeeId], [EmployeeType], [CommissionType], [Amount], [IsPaid], [Title], [InvoiceId], [HospitalId], [DateTime], [CreatedTime], [UpdatedTime], [MainInvoiceId], [PaymentGroup], [MainInvoiceCode], [InvoiceCode], [PercentOrValue], [InvoiceTotal], [LessAmount], [SpecialAmount], [Category], [InvoiceCreatedTime], [InvoiceDiagnosticTestId], [IsPaidFinally], [PaymentId], [ReceiptCreatedTime], [BarCodeImageUrl]) VALUES (N'32dca2d0-d045-462a-90bf-d0ddfffe33db', N'45c6d504-e6fb-4da1-9454-92195a3dba94', N'Doctor', N'Pathology', -32.608695652173914, 1, N'', N'51c1122d-de73-48a8-b5f3-11dbd65883d8', N'd821cd9f-ac10-4f94-92cf-c292cd83b2c0', NULL, CAST(N'2018-07-20T10:57:07.3800000' AS DateTime2), CAST(N'2018-09-04T22:21:52.4533333' AS DateTime2), N'd4384253-b264-43c8-b337-297dfdb59c3c', N'RR0040', N'RINV0022', N'RDG0040', N'0%', 1000, 150, 0, N'Test', CAST(N'2018-07-20T10:45:14.6333333' AS DateTime2), NULL, 0, N'NA', N'NA', N'NA')
INSERT [dbo].[Commission] ([Id], [EmployeeId], [EmployeeType], [CommissionType], [Amount], [IsPaid], [Title], [InvoiceId], [HospitalId], [DateTime], [CreatedTime], [UpdatedTime], [MainInvoiceId], [PaymentGroup], [MainInvoiceCode], [InvoiceCode], [PercentOrValue], [InvoiceTotal], [LessAmount], [SpecialAmount], [Category], [InvoiceCreatedTime], [InvoiceDiagnosticTestId], [IsPaidFinally], [PaymentId], [ReceiptCreatedTime], [BarCodeImageUrl]) VALUES (N'32fb276c-8bb3-443e-a623-edf4df9cc89f', N'24a50fd4-8d08-41d3-94e5-be95c9e77925', N'Doctor', N'Pathology (Combination)', -20.512820512820511, 1, N'', N'c58a7b22-0d04-4786-8350-d805dddce26d', N'd821cd9f-ac10-4f94-92cf-c292cd83b2c0', NULL, CAST(N'2018-07-09T21:55:24.3933333' AS DateTime2), CAST(N'2018-09-04T22:35:23.0500000' AS DateTime2), N'86369ff8-4d85-4b08-8b42-7ba206964d7a', N'RR0004', N'RINV0006', N'RDG0018', N'0%', 1750, 200, 0, N'Test', CAST(N'2018-07-09T21:50:19.0200000' AS DateTime2), NULL, 0, N'NA', N'NA', N'NA')
INSERT [dbo].[Commission] ([Id], [EmployeeId], [EmployeeType], [CommissionType], [Amount], [IsPaid], [Title], [InvoiceId], [HospitalId], [DateTime], [CreatedTime], [UpdatedTime], [MainInvoiceId], [PaymentGroup], [MainInvoiceCode], [InvoiceCode], [PercentOrValue], [InvoiceTotal], [LessAmount], [SpecialAmount], [Category], [InvoiceCreatedTime], [InvoiceDiagnosticTestId], [IsPaidFinally], [PaymentId], [ReceiptCreatedTime], [BarCodeImageUrl]) VALUES (N'3304acaa-0a79-438c-98af-963cefb3e3ad', N'4c772c03-ef45-492a-82d7-24bd49320ea3', N'Doctor', N'CombineCategory_1', 40, 1, N'', N'4db4f89f-ff9a-4eb0-98ee-966524f56836', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2019-01-16T11:02:20.6415602' AS DateTime2), CAST(N'2019-01-19T13:46:18.4655544' AS DateTime2), N'NOTASSIGNED', N'NCR0104', NULL, N'NCDG0103', N'10%', 1000, 150, 0, N'Test', CAST(N'2019-01-16T11:02:20.0059561' AS DateTime2), NULL, 1, N'NCP0044', N'19-Jan-19 1:46:18 PM 1:46 PM', N'data:image/jpeg;base64,[encoded data, 8452 characters]')
INSERT [dbo].[Commission] ([Id], [EmployeeId], [EmployeeType], [CommissionType], [Amount], [IsPaid], [Title], [InvoiceId], [HospitalId], [DateTime], [CreatedTime], [UpdatedTime], [MainInvoiceId], [PaymentGroup], [MainInvoiceCode], [InvoiceCode], [PercentOrValue], [InvoiceTotal], [LessAmount], [SpecialAmount], [Category], [InvoiceCreatedTime], [InvoiceDiagnosticTestId], [IsPaidFinally], [PaymentId], [ReceiptCreatedTime], [BarCodeImageUrl]) VALUES (N'33ef106e-d732-4a75-8418-137a4347f9a1', N'4c772c03-ef45-492a-82d7-24bd49320ea3', N'Referral', N'Conbination', 300, 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'34179db0-1b87-4eba-a5c3-2722eb552672', N'f58ff95f-89e6-4f8e-8868-a83828ebe999', N'UltraSoundDoctor', N'UltraSoundCategory_2', 2000, 1, N'', N'c5e84ccb-38d8-4ca4-a224-92ea42e0f4c5', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2019-02-02T16:48:58.6551103' AS DateTime2), CAST(N'2019-02-03T08:44:45.7349917' AS DateTime2), N'NOTASSIGNED', N'NCR0114', N'NOTASSIGNED', N'NCDG0115', NULL, 657, 0, 0, N'test', CAST(N'2019-02-02T16:42:10.5098169' AS DateTime2), N'6ce32596-1ea9-4a8a-9660-c134fb4e4df0', 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'3423451a-76af-4e55-8159-9d69307fdad6', N'bb6d3d69-74b2-4218-b563-49d01cfbe205', N'Doctor', N'DoctorVisit', 123, 0, N'', N'NOTASSIGNED', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2019-02-14T16:05:08.1175917' AS DateTime2), CAST(N'2019-02-14T16:05:08.1175917' AS DateTime2), N'07742b8f-093a-447d-8a17-76b7b75f04f4', NULL, NULL, N'NOTASSIGNED', NULL, NULL, 0, 0, N'ADDED_JUST_FOR_COMMISSION', CAST(N'0001-01-01T00:00:00.0000000' AS DateTime2), NULL, 0, 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'35a1b8bf-9647-43ae-9b47-c583e9fb1851', N'2f49ff36-b04f-4081-9261-60ec973da26d', N'Referral', N'UltraSoundCategory_2', 81.6, 0, N'', N'9ec3c26c-7cfa-44f4-8e24-98f3073d3ea5', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2018-12-06T15:26:18.6035297' AS DateTime2), CAST(N'2018-12-22T16:17:56.9948653' AS DateTime2), N'NOTASSIGNED', NULL, NULL, N'NCDG0069', N'24%', 1683, 187, 0, N'Test', CAST(N'2018-12-06T15:26:18.2047477' AS DateTime2), NULL, 1, N'NA', N'NA', N'NA')
INSERT [dbo].[Commission] ([Id], [EmployeeId], [EmployeeType], [CommissionType], [Amount], [IsPaid], [Title], [InvoiceId], [HospitalId], [DateTime], [CreatedTime], [UpdatedTime], [MainInvoiceId], [PaymentGroup], [MainInvoiceCode], [InvoiceCode], [PercentOrValue], [InvoiceTotal], [LessAmount], [SpecialAmount], [Category], [InvoiceCreatedTime], [InvoiceDiagnosticTestId], [IsPaidFinally], [PaymentId], [ReceiptCreatedTime], [BarCodeImageUrl]) VALUES (N'35a793fc-d459-471c-baa7-2176b53649e1', N'f58ff95f-89e6-4f8e-8868-a83828ebe999', N'UltraSoundDoctor', N'UltraSoundCategory_1', 1000, 1, N'', N'c5e84ccb-38d8-4ca4-a224-92ea42e0f4c5', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2019-02-02T16:42:10.7701129' AS DateTime2), CAST(N'2019-02-03T08:44:45.7153451' AS DateTime2), N'NOTASSIGNED', N'NCR0114', N'NOTASSIGNED', N'NCDG0115', NULL, 623, 0, 0, N'test', CAST(N'2019-02-02T16:42:10.5098169' AS DateTime2), N'063628aa-8107-48ca-9ec4-57327af485ba', 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'370ef82f-76ef-4dd9-9e42-65b6b43ed5ce', N'6ee087eb-7031-408f-b4ea-f567d250f75b', N'Doctor', N'ASSISTANT_DOCTOR', 44, 1, N'KidneyOP_1', N'3d4646d1-0c53-413f-9e23-9783787d8522', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2018-12-26T12:45:43.9216304' AS DateTime2), CAST(N'2018-12-27T12:05:15.6667547' AS DateTime2), N'0c6f2449-2e4f-489d-8372-860af4eabf75', N'NCR0098', N'NCINV0041', N'NCINV0041', N'44', NULL, 0, 0, N'Operation', CAST(N'2018-12-26T12:45:35.8356009' AS DateTime2), NULL, 1, N'NCP0033', N'27-Dec-18 11:03 AM', N'data:image/jpeg;base64,[encoded data, 8648 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'37215d09-9444-4125-ba42-9fadb2ec0cc7', 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.4276089' 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'b8ffdb64-26f3-4360-865c-326f7678be9b', 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'37444ce8-eeed-4f6b-81c3-599f6500de65', N'f58ff95f-89e6-4f8e-8868-a83828ebe999', N'Doctor', N'DoctorVisit', 200, 0, N'', N'd5c122f7-cc95-4d94-ba90-5fe79acd0ee0', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2018-12-18T10:32:49.8224860' AS DateTime2), CAST(N'2018-12-22T16:17:56.9948653' AS DateTime2), N'83281dd4-5998-4b90-bd4f-ad30ae28cfa6', NULL, N'NCINV0036', N'NCINV0036', NULL, NULL, 0, 0, N'Operation', CAST(N'0001-01-01T00:00:00.0000000' AS DateTime2), NULL, 1, N'NA', N'NA', N'NA')
INSERT [dbo].[Commission] ([Id], [EmployeeId], [EmployeeType], [CommissionType], [Amount], [IsPaid], [Title], [InvoiceId], [HospitalId], [DateTime], [CreatedTime], [UpdatedTime], [MainInvoiceId], [PaymentGroup], [MainInvoiceCode], [InvoiceCode], [PercentOrValue], [InvoiceTotal], [LessAmount], [SpecialAmount], [Category], [InvoiceCreatedTime], [InvoiceDiagnosticTestId], [IsPaidFinally], [PaymentId], [ReceiptCreatedTime], [BarCodeImageUrl]) VALUES (N'3828cc71-888a-4b84-80e5-7e253fd3a1cd', N'8d3cf8f9-7ef7-4008-b529-e05a062b3f0c', N'Doctor', N'ASSISTANT_DOCTOR', 898, 1, N'KidneyOP_1', N'0cb8c3a4-5ed3-4945-9a65-9214be4c4765', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2018-12-26T12:17:48.1510288' AS DateTime2), CAST(N'2018-12-27T12:05:15.6569742' AS DateTime2), N'0c6f2449-2e4f-489d-8372-860af4eabf75', NULL, N'NCINV0041', N'NCINV0041', N'898', NULL, 0, 0, N'Operation', CAST(N'2018-12-26T12:16:04.4329021' AS DateTime2), NULL, 0, N'NCP0027', 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'3837e28c-a1d7-4e4d-958f-c93060ae0c4c', N'45c6d504-e6fb-4da1-9454-92195a3dba94', N'Doctor', N'Pathology', -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'392e5923-d7e0-4ef5-b3cb-ffb655935ce1', N'2f49ff36-b04f-4081-9261-60ec973da26d', N'Referral', N'UltraSoundCategory_1', 49.2, 1, N'', N'003042e8-1731-43ad-a3cd-906998b3e07d', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2018-12-05T16:07:50.4627288' AS DateTime2), CAST(N'2018-12-06T10:02:51.9024508' AS DateTime2), N'NOTASSIGNED', N'NCR0029', NULL, N'NCDG0066', N'20%', 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'398e281f-de85-40a8-85f7-8d57466602de', N'7b3c0574-a184-4081-9a43-0b8360b4e107', N'Doctor', N'ASSISTANT_DOCTOR', 33, 0, N'KidneyOP_1', N'a335dccd-20b3-45b1-9268-5a34a1cb456d', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2019-02-16T16:56:13.3912863' AS DateTime2), CAST(N'2019-02-16T16:56:13.3912863' AS DateTime2), N'abb18202-7f6f-4a1b-86a2-5bcf1da3d8a7', NULL, N'NCINV0061', N'NCINV0061', N'33', 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'3998f4c0-239f-496f-9818-766b6eb24c7b', N'65ba8697-497a-4f36-bd6c-668eba0c5d62', N'Doctor', N'Biochemistry ', 135, 0, N'', N'2a4569a0-70ab-4888-a205-af406c84856d', N'ef1e120e-4fb9-43fe-890b-47c309427a7e', NULL, CAST(N'2019-01-07T09:32:32.6258405' AS DateTime2), CAST(N'2019-02-03T08:17:35.7629175' AS DateTime2), N'NOTASSIGNED', N'NCR0114', NULL, N'NCDG0084', N'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]')
