
# ------------------------------------------------------------
# SCHEMA DUMP FOR TABLE: invoice_table
# ------------------------------------------------------------

CREATE TABLE IF NOT EXISTS `invoice_table` (
  `Id` int(10) NOT NULL AUTO_INCREMENT,
  `InvoiceNo` varchar(20) DEFAULT NULL,
  `InvoiceDate` date DEFAULT NULL,
  `CollectionPeriod` varchar(20) DEFAULT NULL,
  `CusId` varchar(20) DEFAULT NULL,
  `CusName` varchar(150) DEFAULT NULL,
  `Address` varchar(200) DEFAULT NULL,
  `CollectionId` int(11) DEFAULT NULL,
  `CollectionDate` varchar(50) DEFAULT NULL,
  `Provider` varchar(100) DEFAULT NULL,
  `Collections` decimal(20, 2) DEFAULT NULL,
  `Rate` varchar(20) DEFAULT NULL,
  `Commission` decimal(20, 2) DEFAULT NULL,
  `TotalColl` decimal(20, 2) DEFAULT NULL,
  `TotalComm` decimal(20, 2) DEFAULT NULL,
  `BasePayment` decimal(20, 2) DEFAULT NULL,
  `GrandTotal` decimal(20, 2) DEFAULT NULL,
  `BalToPay` decimal(20, 2) DEFAULT NULL,
  `AmountPaid` decimal(20, 2) DEFAULT NULL,
  `ApprovalStatus` varchar(50) DEFAULT NULL,
  `Status` varchar(20) DEFAULT NULL,
  `CreatedBy` varchar(50) DEFAULT NULL,
  `CompanyName` varchar(250) NOT NULL,
  PRIMARY KEY (`Id`)
) ENGINE = InnoDB AUTO_INCREMENT = 591 DEFAULT CHARSET = latin1;

# ------------------------------------------------------------
# SCHEMA DUMP FOR TABLE: assigned_contractor_table
# ------------------------------------------------------------

CREATE TABLE IF NOT EXISTS `assigned_contractor_table` (
  `Id` int(20) NOT NULL AUTO_INCREMENT,
  `ProvId` varchar(50) DEFAULT NULL,
  `ProviderName` varchar(255) DEFAULT NULL,
  `ConId` varchar(50) DEFAULT NULL,
  `ContractorName` varchar(250) DEFAULT NULL,
  `PayRate` varchar(10) DEFAULT NULL,
  `StartDate` date DEFAULT NULL,
  `EndDate` date DEFAULT NULL,
  `ReasonToEnded` varchar(200) DEFAULT NULL,
  `CompanyName` varchar(250) NOT NULL,
  `CreatedBy` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`Id`)
) ENGINE = InnoDB AUTO_INCREMENT = 77 DEFAULT CHARSET = latin1;

# ------------------------------------------------------------
# SCHEMA DUMP FOR TABLE: collection_table
# ------------------------------------------------------------

CREATE TABLE IF NOT EXISTS `collection_table` (
  `Id` int(20) NOT NULL AUTO_INCREMENT,
  `Date` varchar(20) DEFAULT NULL,
  `EmpId` varchar(50) DEFAULT NULL,
  `EmpName` varchar(250) DEFAULT NULL,
  `CusId` varchar(50) DEFAULT NULL,
  `CusName` varchar(250) DEFAULT NULL,
  `CollectionAmount` decimal(20, 2) DEFAULT NULL,
  `Rate` varchar(10) DEFAULT NULL,
  `Commission` decimal(20, 2) DEFAULT NULL,
  `Status` varchar(50) DEFAULT NULL,
  `CreatedBy` varchar(100) DEFAULT NULL,
  `CompanyName` varchar(250) NOT NULL,
  PRIMARY KEY (`Id`)
) ENGINE = InnoDB AUTO_INCREMENT = 182 DEFAULT CHARSET = latin1;

# ------------------------------------------------------------
# SCHEMA DUMP FOR TABLE: company_details_table
# ------------------------------------------------------------

CREATE TABLE IF NOT EXISTS `company_details_table` (
  `Id` int(20) NOT NULL AUTO_INCREMENT,
  `CompanyName` varchar(200) NOT NULL,
  `TaxID` varchar(100) DEFAULT NULL,
  `Phone` varchar(100) DEFAULT NULL,
  `Email` varchar(250) DEFAULT NULL,
  `Web` varchar(250) DEFAULT NULL,
  `OwnerName` varchar(250) DEFAULT NULL,
  `OwnerPhone` varchar(200) DEFAULT NULL,
  `EstablishDate` date DEFAULT NULL,
  `DateCreated` date DEFAULT NULL,
  `Address` varchar(200) DEFAULT NULL,
  `OtherDetails` varchar(250) DEFAULT NULL,
  `DigitalSignature` mediumblob DEFAULT NULL,
  `Logo` mediumblob DEFAULT NULL,
  `CreatedBy` varchar(50) NOT NULL,
  PRIMARY KEY (`Id`)
) ENGINE = InnoDB AUTO_INCREMENT = 25 DEFAULT CHARSET = latin1;

# ------------------------------------------------------------
# SCHEMA DUMP FOR TABLE: customer_receipt_table
# ------------------------------------------------------------

CREATE TABLE IF NOT EXISTS `customer_receipt_table` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `ReceiptNo` varchar(20) DEFAULT NULL,
  `PaidDate` date DEFAULT NULL,
  `PaymentType` varchar(20) DEFAULT NULL,
  `PaymentRefNo` varchar(100) DEFAULT NULL,
  `CusId` varchar(20) DEFAULT NULL,
  `CusName` varchar(100) DEFAULT NULL,
  `Address` varchar(200) DEFAULT NULL,
  `PaidTotal` decimal(20, 2) DEFAULT NULL,
  `InvoiceDate` date DEFAULT NULL,
  `InvoiceNo` varchar(20) DEFAULT NULL,
  `Period` varchar(20) DEFAULT NULL,
  `BasePayment` decimal(20, 2) DEFAULT NULL,
  `TotalComm` decimal(20, 2) DEFAULT NULL,
  `GrandTotal` decimal(20, 2) DEFAULT NULL,
  `BalToPay` decimal(20, 2) DEFAULT NULL,
  `AmountPaid` decimal(20, 2) DEFAULT NULL,
  `Status` varchar(20) DEFAULT NULL,
  `Payslip` varchar(20) DEFAULT NULL,
  `CreatedBy` varchar(50) DEFAULT NULL,
  `CompanyName` varchar(250) NOT NULL,
  PRIMARY KEY (`Id`)
) ENGINE = InnoDB AUTO_INCREMENT = 215 DEFAULT CHARSET = latin1;

# ------------------------------------------------------------
# SCHEMA DUMP FOR TABLE: customer_table
# ------------------------------------------------------------

CREATE TABLE IF NOT EXISTS `customer_table` (
  `Id` int(10) NOT NULL AUTO_INCREMENT,
  `CusId` varchar(20) NOT NULL,
  `CusName` varchar(50) NOT NULL,
  `Phone` varchar(100) DEFAULT NULL,
  `Email` varchar(100) DEFAULT NULL,
  `Address` varchar(250) DEFAULT NULL,
  `GroupName` varchar(250) DEFAULT NULL,
  `StartDate` date DEFAULT NULL,
  `Status` varchar(50) NOT NULL,
  `CreatedBy` varchar(50) NOT NULL,
  `CompanyName` varchar(250) NOT NULL,
  PRIMARY KEY (`Id`)
) ENGINE = InnoDB AUTO_INCREMENT = 238 DEFAULT CHARSET = latin1;

# ------------------------------------------------------------
# SCHEMA DUMP FOR TABLE: emp_table
# ------------------------------------------------------------

CREATE TABLE IF NOT EXISTS `emp_table` (
  `Id` int(20) NOT NULL AUTO_INCREMENT,
  `EmpName` varchar(255) DEFAULT NULL,
  `DOB` date DEFAULT NULL,
  `Gender` varchar(50) DEFAULT NULL,
  `Address` varchar(250) DEFAULT NULL,
  `Phone` varchar(50) DEFAULT NULL,
  `Email` varchar(250) DEFAULT NULL,
  `Status` varchar(50) DEFAULT NULL,
  `CreatedBy` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`Id`)
) ENGINE = InnoDB AUTO_INCREMENT = 8 DEFAULT CHARSET = latin1;

# ------------------------------------------------------------
# SCHEMA DUMP FOR TABLE: file_upload_table
# ------------------------------------------------------------

CREATE TABLE IF NOT EXISTS `file_upload_table` (
  `Id` int(20) NOT NULL AUTO_INCREMENT,
  `EmpId` varchar(100) DEFAULT NULL,
  `EmpName` varchar(255) DEFAULT NULL,
  `FileName` varchar(250) DEFAULT NULL,
  `Description` varchar(250) DEFAULT NULL,
  `AttachedDate` date DEFAULT NULL,
  `IsShared` varchar(20) DEFAULT NULL,
  `CreatedBy` varchar(100) DEFAULT NULL,
  `CompanyName` varchar(200) DEFAULT NULL,
  PRIMARY KEY (`Id`)
) ENGINE = InnoDB AUTO_INCREMENT = 46 DEFAULT CHARSET = latin1;

# ------------------------------------------------------------
# SCHEMA DUMP FOR TABLE: backup_table
# ------------------------------------------------------------

CREATE TABLE IF NOT EXISTS `backup_table` (
  `Id` int(20) NOT NULL AUTO_INCREMENT,
  `Filename` varchar(100) DEFAULT NULL,
  `DateCreated` varchar(100) DEFAULT NULL,
  `CreatedBy` varchar(100) DEFAULT NULL,
  `CompanyName` varchar(200) DEFAULT NULL,
  PRIMARY KEY (`Id`)
) ENGINE = InnoDB AUTO_INCREMENT = 14 DEFAULT CHARSET = latin1;

# ------------------------------------------------------------
# SCHEMA DUMP FOR TABLE: settings_table
# ------------------------------------------------------------

CREATE TABLE IF NOT EXISTS `settings_table` (
  `Id` int(10) NOT NULL AUTO_INCREMENT,
  `RefId` varchar(20) NOT NULL,
  `RefName` varchar(200) NOT NULL,
  PRIMARY KEY (`Id`)
) ENGINE = InnoDB AUTO_INCREMENT = 7 DEFAULT CHARSET = latin1;

# ------------------------------------------------------------
# SCHEMA DUMP FOR TABLE: shared_document_table
# ------------------------------------------------------------

CREATE TABLE IF NOT EXISTS `shared_document_table` (
  `Id` int(20) NOT NULL AUTO_INCREMENT,
  `FileName` varchar(255) DEFAULT NULL,
  `Description` varchar(250) DEFAULT NULL,
  `SharedOn` date DEFAULT NULL,
  `SharedBy` varchar(100) DEFAULT NULL,
  `SharedTo` varchar(100) DEFAULT NULL,
  `CompanyName` varchar(200) DEFAULT NULL,
  PRIMARY KEY (`Id`)
) ENGINE = InnoDB AUTO_INCREMENT = 38 DEFAULT CHARSET = latin1;

# ------------------------------------------------------------
# SCHEMA DUMP FOR TABLE: task_table
# ------------------------------------------------------------

CREATE TABLE IF NOT EXISTS `task_table` (
  `Id` int(20) NOT NULL AUTO_INCREMENT,
  `EmpId` varchar(100) DEFAULT NULL,
  `EmpName` varchar(250) NOT NULL,
  `Type` varchar(100) NOT NULL,
  `Title` varchar(250) NOT NULL,
  `Description` varchar(250) NOT NULL,
  `DueDate` date NOT NULL,
  `Status` varchar(50) NOT NULL,
  `CreatedBy` varchar(50) NOT NULL,
  `CompanyName` varchar(250) NOT NULL,
  PRIMARY KEY (`Id`)
) ENGINE = InnoDB AUTO_INCREMENT = 29 DEFAULT CHARSET = latin1;

# ------------------------------------------------------------
# SCHEMA DUMP FOR TABLE: user_access_permission_table
# ------------------------------------------------------------

CREATE TABLE IF NOT EXISTS `user_access_permission_table` (
  `Id` int(20) NOT NULL AUTO_INCREMENT,
  `UserName` varchar(30) NOT NULL,
  `DB` int(2) NOT NULL,
  `CP` int(2) NOT NULL,
  `COM` int(2) NOT NULL,
  `EM` int(2) NOT NULL,
  `ADD_CONT` int(2) NOT NULL,
  `ASSIGN_CONT` int(2) NOT NULL,
  `CM` int(2) NOT NULL,
  `COLL` int(2) NOT NULL,
  `INV` int(2) NOT NULL,
  `PMT` int(2) NOT NULL,
  `PS` int(2) NOT NULL,
  `TASK` int(2) NOT NULL,
  `DOC` int(2) NOT NULL,
  `USER` int(2) NOT NULL,
  `COLL_REPORT` int(2) NOT NULL,
  `INV_REPORT` int(2) NOT NULL,
  `BP_REPORT` int(2) NOT NULL,
  `PS_REPORT` int(2) NOT NULL,
  `CLIENT_REPORT` int(2) NOT NULL,
  `EMP_REPORT` int(2) NOT NULL,
  `SETTINGS` int(2) NOT NULL,
  `BACKUP` int(2) NOT NULL,
  `CreatedBy` varchar(50) NOT NULL,
  `CompanyName` varchar(250) NOT NULL,
  PRIMARY KEY (`Id`)
) ENGINE = InnoDB AUTO_INCREMENT = 49 DEFAULT CHARSET = latin1;

# ------------------------------------------------------------
# SCHEMA DUMP FOR TABLE: user_login_session_table
# ------------------------------------------------------------

CREATE TABLE IF NOT EXISTS `user_login_session_table` (
  `Id` int(10) NOT NULL AUTO_INCREMENT,
  `UserName` varchar(50) NOT NULL,
  `LoginDate` date NOT NULL,
  `LoginTime` time NOT NULL,
  `IsLogin` int(2) NOT NULL,
  `Status` varchar(20) NOT NULL,
  PRIMARY KEY (`Id`)
) ENGINE = InnoDB AUTO_INCREMENT = 13 DEFAULT CHARSET = latin1;

# ------------------------------------------------------------
# SCHEMA DUMP FOR TABLE: user_type_table
# ------------------------------------------------------------

CREATE TABLE IF NOT EXISTS `user_type_table` (
  `Id` int(20) NOT NULL AUTO_INCREMENT,
  `UserType` varchar(100) NOT NULL,
  `CreatedBy` varchar(50) NOT NULL,
  `CompanyName` varchar(250) NOT NULL,
  PRIMARY KEY (`Id`)
) ENGINE = InnoDB AUTO_INCREMENT = 37 DEFAULT CHARSET = latin1;

# ------------------------------------------------------------
# DATA DUMP FOR TABLE: invoice_table
# ------------------------------------------------------------

INSERT INTO
  `invoice_table` (
    `Id`,
    `InvoiceNo`,
    `InvoiceDate`,
    `CollectionPeriod`,
    `CusId`,
    `CusName`,
    `Address`,
    `CollectionId`,
    `CollectionDate`,
    `Provider`,
    `Collections`,
    `Rate`,
    `Commission`,
    `TotalColl`,
    `TotalComm`,
    `BasePayment`,
    `GrandTotal`,
    `BalToPay`,
    `AmountPaid`,
    `ApprovalStatus`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    327,
    'INV000001',
    '2021-05-23',
    '2021-04',
    'EMP000017',
    'Anura Kumara',
    'ff',
    39,
    'Apr 2021',
    'maduranga-updated',
    5000.00,
    '23',
    1150.00,
    55000.00,
    2650.00,
    0.00,
    2650.00,
    2650.00,
    0.00,
    NULL,
    'Unpaid',
    'admin',
    'RapidGnix'
  );
INSERT INTO
  `invoice_table` (
    `Id`,
    `InvoiceNo`,
    `InvoiceDate`,
    `CollectionPeriod`,
    `CusId`,
    `CusName`,
    `Address`,
    `CollectionId`,
    `CollectionDate`,
    `Provider`,
    `Collections`,
    `Rate`,
    `Commission`,
    `TotalColl`,
    `TotalComm`,
    `BasePayment`,
    `GrandTotal`,
    `BalToPay`,
    `AmountPaid`,
    `ApprovalStatus`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    328,
    'INV000001',
    '2021-05-23',
    '2021-04',
    'EMP000017',
    'Anura Kumara',
    'ff',
    40,
    'Apr 2021',
    'maduranga-updated',
    50000.00,
    '3',
    1500.00,
    55000.00,
    2650.00,
    0.00,
    2650.00,
    2650.00,
    0.00,
    NULL,
    'Unpaid',
    'admin',
    'RapidGnix'
  );
INSERT INTO
  `invoice_table` (
    `Id`,
    `InvoiceNo`,
    `InvoiceDate`,
    `CollectionPeriod`,
    `CusId`,
    `CusName`,
    `Address`,
    `CollectionId`,
    `CollectionDate`,
    `Provider`,
    `Collections`,
    `Rate`,
    `Commission`,
    `TotalColl`,
    `TotalComm`,
    `BasePayment`,
    `GrandTotal`,
    `BalToPay`,
    `AmountPaid`,
    `ApprovalStatus`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    329,
    'INV000002',
    '2021-05-24',
    '2021-05',
    'EMP000019',
    'Banuka perera',
    '32323',
    44,
    'May 2021',
    'maduranga-updated',
    12000.00,
    '12',
    1440.00,
    12000.00,
    1440.00,
    30000.00,
    31440.00,
    31440.00,
    0.00,
    NULL,
    'Unpaid',
    'admin',
    'ABC COMPANY PVT LTD'
  );
INSERT INTO
  `invoice_table` (
    `Id`,
    `InvoiceNo`,
    `InvoiceDate`,
    `CollectionPeriod`,
    `CusId`,
    `CusName`,
    `Address`,
    `CollectionId`,
    `CollectionDate`,
    `Provider`,
    `Collections`,
    `Rate`,
    `Commission`,
    `TotalColl`,
    `TotalComm`,
    `BasePayment`,
    `GrandTotal`,
    `BalToPay`,
    `AmountPaid`,
    `ApprovalStatus`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    330,
    'INV000003',
    '2021-05-26',
    '2021-05',
    'CON000022',
    'Fahad Razzaq',
    '1234',
    46,
    'May 2021',
    'Ronald Jefferson',
    4000.00,
    '2',
    80.00,
    4000.00,
    80.00,
    4.00,
    84.00,
    84.00,
    0.00,
    NULL,
    'Unpaid',
    'admin',
    'ABC COMPANY PVT LTD'
  );
INSERT INTO
  `invoice_table` (
    `Id`,
    `InvoiceNo`,
    `InvoiceDate`,
    `CollectionPeriod`,
    `CusId`,
    `CusName`,
    `Address`,
    `CollectionId`,
    `CollectionDate`,
    `Provider`,
    `Collections`,
    `Rate`,
    `Commission`,
    `TotalColl`,
    `TotalComm`,
    `BasePayment`,
    `GrandTotal`,
    `BalToPay`,
    `AmountPaid`,
    `ApprovalStatus`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    338,
    'INV000011',
    '2021-05-30',
    '2021-05',
    'EMP000019',
    'Banuka perera',
    'Kandy Road\nNittambuwa',
    49,
    'May 2021',
    'Ronald Jefferson',
    200000.00,
    '3',
    6000.00,
    200000.00,
    6000.00,
    0.00,
    6000.00,
    0.00,
    6000.00,
    'Approved',
    'Paid',
    'banukap',
    'ABC COMPANY PVT LTD'
  );
INSERT INTO
  `invoice_table` (
    `Id`,
    `InvoiceNo`,
    `InvoiceDate`,
    `CollectionPeriod`,
    `CusId`,
    `CusName`,
    `Address`,
    `CollectionId`,
    `CollectionDate`,
    `Provider`,
    `Collections`,
    `Rate`,
    `Commission`,
    `TotalColl`,
    `TotalComm`,
    `BasePayment`,
    `GrandTotal`,
    `BalToPay`,
    `AmountPaid`,
    `ApprovalStatus`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    462,
    'INV000012',
    '2021-06-05',
    '2021-05',
    'EMP000019',
    'Banuka perera',
    'Kandy Road',
    52,
    'May 2021',
    'Ronald Jefferson',
    90000.00,
    '3',
    2700.00,
    140000.00,
    4200.00,
    0.00,
    4200.00,
    0.00,
    4200.00,
    'Approved',
    'Paid',
    'admin',
    'ABC COMPANY PVT LTD'
  );
INSERT INTO
  `invoice_table` (
    `Id`,
    `InvoiceNo`,
    `InvoiceDate`,
    `CollectionPeriod`,
    `CusId`,
    `CusName`,
    `Address`,
    `CollectionId`,
    `CollectionDate`,
    `Provider`,
    `Collections`,
    `Rate`,
    `Commission`,
    `TotalColl`,
    `TotalComm`,
    `BasePayment`,
    `GrandTotal`,
    `BalToPay`,
    `AmountPaid`,
    `ApprovalStatus`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    463,
    'INV000012',
    '2021-06-05',
    '2021-05',
    'EMP000019',
    'Banuka perera',
    'Kandy Road',
    53,
    'May 2021',
    'Ronald Jefferson',
    50000.00,
    '3',
    1500.00,
    140000.00,
    4200.00,
    0.00,
    4200.00,
    0.00,
    4200.00,
    'Approved',
    'Paid',
    'admin',
    'ABC COMPANY PVT LTD'
  );
INSERT INTO
  `invoice_table` (
    `Id`,
    `InvoiceNo`,
    `InvoiceDate`,
    `CollectionPeriod`,
    `CusId`,
    `CusName`,
    `Address`,
    `CollectionId`,
    `CollectionDate`,
    `Provider`,
    `Collections`,
    `Rate`,
    `Commission`,
    `TotalColl`,
    `TotalComm`,
    `BasePayment`,
    `GrandTotal`,
    `BalToPay`,
    `AmountPaid`,
    `ApprovalStatus`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    464,
    'INV000013',
    '2021-06-05',
    '2021-05',
    'EMP000019',
    'Banuka perera',
    'Kandy Road',
    55,
    'May 2021',
    'Ronald Jefferson',
    37500.00,
    '3',
    1125.00,
    37500.00,
    1125.00,
    0.00,
    1125.00,
    0.00,
    1125.00,
    'Approved',
    'Paid',
    'admin',
    'ABC COMPANY PVT LTD'
  );
INSERT INTO
  `invoice_table` (
    `Id`,
    `InvoiceNo`,
    `InvoiceDate`,
    `CollectionPeriod`,
    `CusId`,
    `CusName`,
    `Address`,
    `CollectionId`,
    `CollectionDate`,
    `Provider`,
    `Collections`,
    `Rate`,
    `Commission`,
    `TotalColl`,
    `TotalComm`,
    `BasePayment`,
    `GrandTotal`,
    `BalToPay`,
    `AmountPaid`,
    `ApprovalStatus`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    465,
    'INV000014',
    '2021-06-11',
    '2021-05',
    'EMP000019',
    'Banuka perera',
    'Kandy Road',
    55,
    'May 2021',
    'Ronald Jefferson',
    37500.00,
    '3',
    1125.00,
    37500.00,
    1125.00,
    0.00,
    1125.00,
    0.00,
    1125.00,
    'Approved',
    'Paid',
    'admin',
    'ABC COMPANY PVT LTD'
  );
INSERT INTO
  `invoice_table` (
    `Id`,
    `InvoiceNo`,
    `InvoiceDate`,
    `CollectionPeriod`,
    `CusId`,
    `CusName`,
    `Address`,
    `CollectionId`,
    `CollectionDate`,
    `Provider`,
    `Collections`,
    `Rate`,
    `Commission`,
    `TotalColl`,
    `TotalComm`,
    `BasePayment`,
    `GrandTotal`,
    `BalToPay`,
    `AmountPaid`,
    `ApprovalStatus`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    466,
    'INV000015',
    '2021-06-13',
    '2021-06',
    'CON000026',
    'Nalaka Bandara',
    'Nugegoda',
    61,
    'Jun 2021',
    'Asela Gunarathne',
    120000.00,
    '5%',
    6000.00,
    120000.00,
    6000.00,
    0.00,
    6000.00,
    6000.00,
    0.00,
    'Pending',
    'Unpaid',
    'nalakab',
    'Novar Flex Pvt Ltd'
  );
INSERT INTO
  `invoice_table` (
    `Id`,
    `InvoiceNo`,
    `InvoiceDate`,
    `CollectionPeriod`,
    `CusId`,
    `CusName`,
    `Address`,
    `CollectionId`,
    `CollectionDate`,
    `Provider`,
    `Collections`,
    `Rate`,
    `Commission`,
    `TotalColl`,
    `TotalComm`,
    `BasePayment`,
    `GrandTotal`,
    `BalToPay`,
    `AmountPaid`,
    `ApprovalStatus`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    467,
    'INV000016',
    '2021-06-13',
    '2021-06',
    'CON000026',
    'Nalaka Bandara',
    'Nugegoda',
    62,
    'Jun 2021',
    'Asela Gunarathne',
    3000.00,
    '5%',
    150.00,
    3000.00,
    150.00,
    0.00,
    150.00,
    150.00,
    0.00,
    'Approved',
    'Unpaid',
    'admin',
    'Novar Flex Pvt Ltd'
  );
INSERT INTO
  `invoice_table` (
    `Id`,
    `InvoiceNo`,
    `InvoiceDate`,
    `CollectionPeriod`,
    `CusId`,
    `CusName`,
    `Address`,
    `CollectionId`,
    `CollectionDate`,
    `Provider`,
    `Collections`,
    `Rate`,
    `Commission`,
    `TotalColl`,
    `TotalComm`,
    `BasePayment`,
    `GrandTotal`,
    `BalToPay`,
    `AmountPaid`,
    `ApprovalStatus`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    468,
    'INV000016',
    '2021-06-13',
    '2021-06',
    'CON000026',
    'Nalaka Bandara',
    'Nugegoda',
    62,
    'Jun 2021',
    'Asela Gunarathne',
    3000.00,
    '5%',
    150.00,
    3000.00,
    150.00,
    0.00,
    150.00,
    150.00,
    0.00,
    'Approved',
    'Unpaid',
    'admin',
    'Novar Flex Pvt Ltd'
  );
INSERT INTO
  `invoice_table` (
    `Id`,
    `InvoiceNo`,
    `InvoiceDate`,
    `CollectionPeriod`,
    `CusId`,
    `CusName`,
    `Address`,
    `CollectionId`,
    `CollectionDate`,
    `Provider`,
    `Collections`,
    `Rate`,
    `Commission`,
    `TotalColl`,
    `TotalComm`,
    `BasePayment`,
    `GrandTotal`,
    `BalToPay`,
    `AmountPaid`,
    `ApprovalStatus`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    469,
    'INV000016',
    '2021-06-13',
    '2021-06',
    'CON000026',
    'Nalaka Bandara',
    'Nugegoda',
    62,
    'Jun 2021',
    'Asela Gunarathne',
    3000.00,
    '5%',
    150.00,
    3000.00,
    150.00,
    0.00,
    150.00,
    150.00,
    0.00,
    'Approved',
    'Unpaid',
    'admin',
    'Novar Flex Pvt Ltd'
  );
INSERT INTO
  `invoice_table` (
    `Id`,
    `InvoiceNo`,
    `InvoiceDate`,
    `CollectionPeriod`,
    `CusId`,
    `CusName`,
    `Address`,
    `CollectionId`,
    `CollectionDate`,
    `Provider`,
    `Collections`,
    `Rate`,
    `Commission`,
    `TotalColl`,
    `TotalComm`,
    `BasePayment`,
    `GrandTotal`,
    `BalToPay`,
    `AmountPaid`,
    `ApprovalStatus`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    470,
    'INV000016',
    '2021-06-13',
    '2021-06',
    'CON000026',
    'Nalaka Bandara',
    'Nugegoda',
    62,
    'Jun 2021',
    'Asela Gunarathne',
    3000.00,
    '5%',
    150.00,
    3000.00,
    150.00,
    0.00,
    150.00,
    150.00,
    0.00,
    'Approved',
    'Unpaid',
    'admin',
    'Novar Flex Pvt Ltd'
  );
INSERT INTO
  `invoice_table` (
    `Id`,
    `InvoiceNo`,
    `InvoiceDate`,
    `CollectionPeriod`,
    `CusId`,
    `CusName`,
    `Address`,
    `CollectionId`,
    `CollectionDate`,
    `Provider`,
    `Collections`,
    `Rate`,
    `Commission`,
    `TotalColl`,
    `TotalComm`,
    `BasePayment`,
    `GrandTotal`,
    `BalToPay`,
    `AmountPaid`,
    `ApprovalStatus`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    471,
    'INV000017',
    '2021-06-13',
    '2021-06',
    'CON000026',
    'Nalaka Bandara',
    'Nugegoda',
    62,
    'Jun 2021',
    'Asela Gunarathne',
    3000.00,
    '5%',
    150.00,
    3000.00,
    150.00,
    0.00,
    150.00,
    150.00,
    0.00,
    'Approved',
    'Unpaid',
    'admin',
    'Novar Flex Pvt Ltd'
  );
INSERT INTO
  `invoice_table` (
    `Id`,
    `InvoiceNo`,
    `InvoiceDate`,
    `CollectionPeriod`,
    `CusId`,
    `CusName`,
    `Address`,
    `CollectionId`,
    `CollectionDate`,
    `Provider`,
    `Collections`,
    `Rate`,
    `Commission`,
    `TotalColl`,
    `TotalComm`,
    `BasePayment`,
    `GrandTotal`,
    `BalToPay`,
    `AmountPaid`,
    `ApprovalStatus`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    472,
    'INV000018',
    '2021-06-13',
    '2021-06',
    'CON000026',
    'Nalaka Bandara',
    'Nugegoda',
    63,
    'Jun 2021',
    'Asela Gunarathne',
    60000.00,
    '5%',
    3000.00,
    60000.00,
    3000.00,
    0.00,
    3000.00,
    3000.00,
    0.00,
    'Approved',
    'Unpaid',
    'admin',
    'Novar Flex Pvt Ltd'
  );
INSERT INTO
  `invoice_table` (
    `Id`,
    `InvoiceNo`,
    `InvoiceDate`,
    `CollectionPeriod`,
    `CusId`,
    `CusName`,
    `Address`,
    `CollectionId`,
    `CollectionDate`,
    `Provider`,
    `Collections`,
    `Rate`,
    `Commission`,
    `TotalColl`,
    `TotalComm`,
    `BasePayment`,
    `GrandTotal`,
    `BalToPay`,
    `AmountPaid`,
    `ApprovalStatus`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    473,
    'INV000019',
    '2021-06-13',
    '2021-06',
    'CON000026',
    'Nalaka Bandara',
    'Nugegoda',
    63,
    'Jun 2021',
    'Asela Gunarathne',
    60000.00,
    '5%',
    3000.00,
    60000.00,
    3000.00,
    0.00,
    3000.00,
    3000.00,
    0.00,
    'Approved',
    'Unpaid',
    'admin',
    'Novar Flex Pvt Ltd'
  );
INSERT INTO
  `invoice_table` (
    `Id`,
    `InvoiceNo`,
    `InvoiceDate`,
    `CollectionPeriod`,
    `CusId`,
    `CusName`,
    `Address`,
    `CollectionId`,
    `CollectionDate`,
    `Provider`,
    `Collections`,
    `Rate`,
    `Commission`,
    `TotalColl`,
    `TotalComm`,
    `BasePayment`,
    `GrandTotal`,
    `BalToPay`,
    `AmountPaid`,
    `ApprovalStatus`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    474,
    'INV000020',
    '2021-06-13',
    '2021-06',
    'CON000026',
    'Nalaka Bandara',
    'Nugegoda',
    64,
    'Jun 2021',
    'Asela Gunarathne',
    40000.00,
    '5%',
    2000.00,
    40000.00,
    2000.00,
    0.00,
    2000.00,
    2000.00,
    0.00,
    'Pending',
    'Unpaid',
    'nalakab',
    'Novar Flex Pvt Ltd'
  );
INSERT INTO
  `invoice_table` (
    `Id`,
    `InvoiceNo`,
    `InvoiceDate`,
    `CollectionPeriod`,
    `CusId`,
    `CusName`,
    `Address`,
    `CollectionId`,
    `CollectionDate`,
    `Provider`,
    `Collections`,
    `Rate`,
    `Commission`,
    `TotalColl`,
    `TotalComm`,
    `BasePayment`,
    `GrandTotal`,
    `BalToPay`,
    `AmountPaid`,
    `ApprovalStatus`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    475,
    'INV000021',
    '2021-06-13',
    '2021-06',
    'CON000026',
    'Nalaka Bandara',
    'Nugegoda',
    64,
    'Jun 2021',
    'Asela Gunarathne',
    40000.00,
    '5%',
    2000.00,
    40000.00,
    2000.00,
    0.00,
    2000.00,
    2000.00,
    0.00,
    'Pending',
    'Unpaid',
    'nalakab',
    'Novar Flex Pvt Ltd'
  );
INSERT INTO
  `invoice_table` (
    `Id`,
    `InvoiceNo`,
    `InvoiceDate`,
    `CollectionPeriod`,
    `CusId`,
    `CusName`,
    `Address`,
    `CollectionId`,
    `CollectionDate`,
    `Provider`,
    `Collections`,
    `Rate`,
    `Commission`,
    `TotalColl`,
    `TotalComm`,
    `BasePayment`,
    `GrandTotal`,
    `BalToPay`,
    `AmountPaid`,
    `ApprovalStatus`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    477,
    'INV000022',
    '2021-06-14',
    '2021-06',
    'EMP000019',
    'Banuka perera',
    'Kandy Road',
    54,
    'Jun 2021',
    'Ronald Jefferson',
    400000.00,
    '3',
    12000.00,
    400000.00,
    12000.00,
    30000.00,
    42000.00,
    0.00,
    42000.00,
    'Approved',
    'Paid',
    'banukap',
    'ABC COMPANY PVT LTD'
  );
INSERT INTO
  `invoice_table` (
    `Id`,
    `InvoiceNo`,
    `InvoiceDate`,
    `CollectionPeriod`,
    `CusId`,
    `CusName`,
    `Address`,
    `CollectionId`,
    `CollectionDate`,
    `Provider`,
    `Collections`,
    `Rate`,
    `Commission`,
    `TotalColl`,
    `TotalComm`,
    `BasePayment`,
    `GrandTotal`,
    `BalToPay`,
    `AmountPaid`,
    `ApprovalStatus`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    484,
    'INV000025',
    '2021-07-20',
    '2021-06',
    'EMP000019',
    'Banuka perera',
    'Kandy Road',
    58,
    'Jun 2021',
    'Ronald Jefferson',
    235000.00,
    '3%',
    7050.00,
    235000.00,
    7050.00,
    30000.00,
    37050.00,
    37050.00,
    0.00,
    'Approved',
    'Unpaid',
    'admin',
    'ABC COMPANY PVT LTD'
  );
INSERT INTO
  `invoice_table` (
    `Id`,
    `InvoiceNo`,
    `InvoiceDate`,
    `CollectionPeriod`,
    `CusId`,
    `CusName`,
    `Address`,
    `CollectionId`,
    `CollectionDate`,
    `Provider`,
    `Collections`,
    `Rate`,
    `Commission`,
    `TotalColl`,
    `TotalComm`,
    `BasePayment`,
    `GrandTotal`,
    `BalToPay`,
    `AmountPaid`,
    `ApprovalStatus`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    485,
    'INV000026',
    '2021-08-05',
    '2021-08',
    'EMP000019',
    'Banuka perera',
    'Kandy Road',
    70,
    'Aug 2021',
    'Ronald Jefferson',
    30000.00,
    '3%',
    900.00,
    30000.00,
    900.00,
    30000.00,
    30900.00,
    30900.00,
    0.00,
    'Pending',
    'Unpaid',
    'banukap',
    'ABC COMPANY PVT LTD'
  );
INSERT INTO
  `invoice_table` (
    `Id`,
    `InvoiceNo`,
    `InvoiceDate`,
    `CollectionPeriod`,
    `CusId`,
    `CusName`,
    `Address`,
    `CollectionId`,
    `CollectionDate`,
    `Provider`,
    `Collections`,
    `Rate`,
    `Commission`,
    `TotalColl`,
    `TotalComm`,
    `BasePayment`,
    `GrandTotal`,
    `BalToPay`,
    `AmountPaid`,
    `ApprovalStatus`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    513,
    'INV000029',
    '2021-08-12',
    '2021-08',
    'CON000022',
    'Fahad Razzaq',
    'no address avauilable - none',
    124,
    'Aug 2021',
    'Winnie Moore, LCPC',
    0.00,
    '2',
    0.00,
    0.00,
    0.00,
    2000.00,
    2000.00,
    2000.00,
    0.00,
    'Approved',
    'Unpaid',
    'FahadAdmin',
    'ABC COMPANY PVT LTD'
  );
INSERT INTO
  `invoice_table` (
    `Id`,
    `InvoiceNo`,
    `InvoiceDate`,
    `CollectionPeriod`,
    `CusId`,
    `CusName`,
    `Address`,
    `CollectionId`,
    `CollectionDate`,
    `Provider`,
    `Collections`,
    `Rate`,
    `Commission`,
    `TotalColl`,
    `TotalComm`,
    `BasePayment`,
    `GrandTotal`,
    `BalToPay`,
    `AmountPaid`,
    `ApprovalStatus`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    514,
    'INV000029',
    '2021-08-12',
    '2021-08',
    'CON000022',
    'Fahad Razzaq',
    'no address avauilable - none',
    122,
    'Aug 2021',
    'Winnie Moore, LCPC',
    0.00,
    '2',
    0.00,
    0.00,
    0.00,
    2000.00,
    2000.00,
    2000.00,
    0.00,
    'Approved',
    'Unpaid',
    'FahadAdmin',
    'ABC COMPANY PVT LTD'
  );
INSERT INTO
  `invoice_table` (
    `Id`,
    `InvoiceNo`,
    `InvoiceDate`,
    `CollectionPeriod`,
    `CusId`,
    `CusName`,
    `Address`,
    `CollectionId`,
    `CollectionDate`,
    `Provider`,
    `Collections`,
    `Rate`,
    `Commission`,
    `TotalColl`,
    `TotalComm`,
    `BasePayment`,
    `GrandTotal`,
    `BalToPay`,
    `AmountPaid`,
    `ApprovalStatus`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    515,
    'INV000030',
    '2021-08-14',
    '2021-08',
    'CON000022',
    'Fahad Razzaq',
    'no address avauilable - none',
    125,
    'Aug 2021',
    'Winnie Moore, LCPC',
    0.00,
    '2',
    0.00,
    0.00,
    0.00,
    3000.00,
    3000.00,
    3000.00,
    0.00,
    'Approved',
    'Unpaid',
    'admin',
    'ABC COMPANY PVT LTD'
  );
INSERT INTO
  `invoice_table` (
    `Id`,
    `InvoiceNo`,
    `InvoiceDate`,
    `CollectionPeriod`,
    `CusId`,
    `CusName`,
    `Address`,
    `CollectionId`,
    `CollectionDate`,
    `Provider`,
    `Collections`,
    `Rate`,
    `Commission`,
    `TotalColl`,
    `TotalComm`,
    `BasePayment`,
    `GrandTotal`,
    `BalToPay`,
    `AmountPaid`,
    `ApprovalStatus`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    518,
    'INV000031',
    '2021-08-16',
    '2021-01',
    'CON000030',
    'Tabitha Contee',
    '15 Queen Anne Bridge Road\nUpper Marlboro, MD  20774',
    95,
    'Jan 2021',
    'Donna Reid Washington, LPC',
    6995.37,
    '4.5',
    314.79,
    65251.79,
    2936.33,
    0.00,
    2936.33,
    2936.33,
    0.00,
    'Approved',
    'Unpaid',
    'FahadAdmin',
    'Billing Plus, Inc.'
  );
INSERT INTO
  `invoice_table` (
    `Id`,
    `InvoiceNo`,
    `InvoiceDate`,
    `CollectionPeriod`,
    `CusId`,
    `CusName`,
    `Address`,
    `CollectionId`,
    `CollectionDate`,
    `Provider`,
    `Collections`,
    `Rate`,
    `Commission`,
    `TotalColl`,
    `TotalComm`,
    `BasePayment`,
    `GrandTotal`,
    `BalToPay`,
    `AmountPaid`,
    `ApprovalStatus`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    519,
    'INV000031',
    '2021-08-16',
    '2021-01',
    'CON000030',
    'Tabitha Contee',
    '15 Queen Anne Bridge Road\nUpper Marlboro, MD  20774',
    94,
    'Jan 2021',
    'Alpha and Omega Health and Wellness Center',
    226.20,
    '4.5',
    10.18,
    65251.79,
    2936.33,
    0.00,
    2936.33,
    2936.33,
    0.00,
    'Approved',
    'Unpaid',
    'FahadAdmin',
    'Billing Plus, Inc.'
  );
INSERT INTO
  `invoice_table` (
    `Id`,
    `InvoiceNo`,
    `InvoiceDate`,
    `CollectionPeriod`,
    `CusId`,
    `CusName`,
    `Address`,
    `CollectionId`,
    `CollectionDate`,
    `Provider`,
    `Collections`,
    `Rate`,
    `Commission`,
    `TotalColl`,
    `TotalComm`,
    `BasePayment`,
    `GrandTotal`,
    `BalToPay`,
    `AmountPaid`,
    `ApprovalStatus`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    520,
    'INV000031',
    '2021-08-16',
    '2021-01',
    'CON000030',
    'Tabitha Contee',
    '15 Queen Anne Bridge Road\nUpper Marlboro, MD  20774',
    93,
    'Jan 2021',
    'Winnie Moore, LCPC',
    14796.03,
    '4.5',
    665.82,
    65251.79,
    2936.33,
    0.00,
    2936.33,
    2936.33,
    0.00,
    'Approved',
    'Unpaid',
    'FahadAdmin',
    'Billing Plus, Inc.'
  );
INSERT INTO
  `invoice_table` (
    `Id`,
    `InvoiceNo`,
    `InvoiceDate`,
    `CollectionPeriod`,
    `CusId`,
    `CusName`,
    `Address`,
    `CollectionId`,
    `CollectionDate`,
    `Provider`,
    `Collections`,
    `Rate`,
    `Commission`,
    `TotalColl`,
    `TotalComm`,
    `BasePayment`,
    `GrandTotal`,
    `BalToPay`,
    `AmountPaid`,
    `ApprovalStatus`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    521,
    'INV000031',
    '2021-08-16',
    '2021-01',
    'CON000030',
    'Tabitha Contee',
    '15 Queen Anne Bridge Road\nUpper Marlboro, MD  20774',
    92,
    'Jan 2021',
    'Carla D. Washington, LPC',
    21406.93,
    '4.5',
    963.31,
    65251.79,
    2936.33,
    0.00,
    2936.33,
    2936.33,
    0.00,
    'Approved',
    'Unpaid',
    'FahadAdmin',
    'Billing Plus, Inc.'
  );
INSERT INTO
  `invoice_table` (
    `Id`,
    `InvoiceNo`,
    `InvoiceDate`,
    `CollectionPeriod`,
    `CusId`,
    `CusName`,
    `Address`,
    `CollectionId`,
    `CollectionDate`,
    `Provider`,
    `Collections`,
    `Rate`,
    `Commission`,
    `TotalColl`,
    `TotalComm`,
    `BasePayment`,
    `GrandTotal`,
    `BalToPay`,
    `AmountPaid`,
    `ApprovalStatus`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    522,
    'INV000031',
    '2021-08-16',
    '2021-01',
    'CON000030',
    'Tabitha Contee',
    '15 Queen Anne Bridge Road\nUpper Marlboro, MD  20774',
    91,
    'Jan 2021',
    'Joy R. Hart, LCSW-C',
    8942.59,
    '4.5',
    402.42,
    65251.79,
    2936.33,
    0.00,
    2936.33,
    2936.33,
    0.00,
    'Approved',
    'Unpaid',
    'FahadAdmin',
    'Billing Plus, Inc.'
  );
INSERT INTO
  `invoice_table` (
    `Id`,
    `InvoiceNo`,
    `InvoiceDate`,
    `CollectionPeriod`,
    `CusId`,
    `CusName`,
    `Address`,
    `CollectionId`,
    `CollectionDate`,
    `Provider`,
    `Collections`,
    `Rate`,
    `Commission`,
    `TotalColl`,
    `TotalComm`,
    `BasePayment`,
    `GrandTotal`,
    `BalToPay`,
    `AmountPaid`,
    `ApprovalStatus`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    523,
    'INV000031',
    '2021-08-16',
    '2021-01',
    'CON000030',
    'Tabitha Contee',
    '15 Queen Anne Bridge Road\nUpper Marlboro, MD  20774',
    90,
    'Jan 2021',
    'Veronica Watkins, LCSW-C',
    5654.86,
    '4.5',
    254.47,
    65251.79,
    2936.33,
    0.00,
    2936.33,
    2936.33,
    0.00,
    'Approved',
    'Unpaid',
    'FahadAdmin',
    'Billing Plus, Inc.'
  );
INSERT INTO
  `invoice_table` (
    `Id`,
    `InvoiceNo`,
    `InvoiceDate`,
    `CollectionPeriod`,
    `CusId`,
    `CusName`,
    `Address`,
    `CollectionId`,
    `CollectionDate`,
    `Provider`,
    `Collections`,
    `Rate`,
    `Commission`,
    `TotalColl`,
    `TotalComm`,
    `BasePayment`,
    `GrandTotal`,
    `BalToPay`,
    `AmountPaid`,
    `ApprovalStatus`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    524,
    'INV000031',
    '2021-08-16',
    '2021-01',
    'CON000030',
    'Tabitha Contee',
    '15 Queen Anne Bridge Road\nUpper Marlboro, MD  20774',
    89,
    'Jan 2021',
    'Apex - Bharat Vallurapalli, MS, OTR/L',
    7229.81,
    '4.5',
    325.34,
    65251.79,
    2936.33,
    0.00,
    2936.33,
    2936.33,
    0.00,
    'Approved',
    'Unpaid',
    'FahadAdmin',
    'Billing Plus, Inc.'
  );
INSERT INTO
  `invoice_table` (
    `Id`,
    `InvoiceNo`,
    `InvoiceDate`,
    `CollectionPeriod`,
    `CusId`,
    `CusName`,
    `Address`,
    `CollectionId`,
    `CollectionDate`,
    `Provider`,
    `Collections`,
    `Rate`,
    `Commission`,
    `TotalColl`,
    `TotalComm`,
    `BasePayment`,
    `GrandTotal`,
    `BalToPay`,
    `AmountPaid`,
    `ApprovalStatus`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    527,
    'INV000032',
    '2021-08-23',
    '2021-07',
    'CON000022',
    'Fahad Razzaq',
    'no address avauilable - none',
    129,
    'Jul 2021',
    'Demo Provider',
    25000.00,
    '2',
    500.00,
    25000.00,
    500.00,
    0.00,
    500.00,
    500.00,
    0.00,
    'Pending',
    'Unpaid',
    'Fahad',
    'ABC COMPANY PVT LTD'
  );
INSERT INTO
  `invoice_table` (
    `Id`,
    `InvoiceNo`,
    `InvoiceDate`,
    `CollectionPeriod`,
    `CusId`,
    `CusName`,
    `Address`,
    `CollectionId`,
    `CollectionDate`,
    `Provider`,
    `Collections`,
    `Rate`,
    `Commission`,
    `TotalColl`,
    `TotalComm`,
    `BasePayment`,
    `GrandTotal`,
    `BalToPay`,
    `AmountPaid`,
    `ApprovalStatus`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    528,
    'INV000033',
    '2021-08-23',
    '2021-05',
    'CON000022',
    'Fahad Razzaq',
    'no address avauilable - none',
    130,
    'May 2021',
    'Base Pay Provider',
    0.00,
    '250.00',
    0.00,
    0.00,
    0.00,
    250.00,
    250.00,
    250.00,
    0.00,
    'Pending',
    'Unpaid',
    'Fahad',
    'ABC COMPANY PVT LTD'
  );
INSERT INTO
  `invoice_table` (
    `Id`,
    `InvoiceNo`,
    `InvoiceDate`,
    `CollectionPeriod`,
    `CusId`,
    `CusName`,
    `Address`,
    `CollectionId`,
    `CollectionDate`,
    `Provider`,
    `Collections`,
    `Rate`,
    `Commission`,
    `TotalColl`,
    `TotalComm`,
    `BasePayment`,
    `GrandTotal`,
    `BalToPay`,
    `AmountPaid`,
    `ApprovalStatus`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    529,
    'INV000034',
    '2021-08-23',
    '2021-06',
    'CON000022',
    'Fahad Razzaq',
    'no address avauilable - none',
    132,
    'Jun 2021',
    'Winnie Moore, LCPC',
    15000.00,
    '2',
    300.00,
    265000.00,
    5300.00,
    0.00,
    5300.00,
    5300.00,
    0.00,
    'Pending',
    'Unpaid',
    'Fahad',
    'ABC COMPANY PVT LTD'
  );
INSERT INTO
  `invoice_table` (
    `Id`,
    `InvoiceNo`,
    `InvoiceDate`,
    `CollectionPeriod`,
    `CusId`,
    `CusName`,
    `Address`,
    `CollectionId`,
    `CollectionDate`,
    `Provider`,
    `Collections`,
    `Rate`,
    `Commission`,
    `TotalColl`,
    `TotalComm`,
    `BasePayment`,
    `GrandTotal`,
    `BalToPay`,
    `AmountPaid`,
    `ApprovalStatus`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    530,
    'INV000034',
    '2021-08-23',
    '2021-06',
    'CON000022',
    'Fahad Razzaq',
    'no address avauilable - none',
    131,
    'Jun 2021',
    'Winnie Moore, LCPC',
    250000.00,
    '2',
    5000.00,
    265000.00,
    5300.00,
    0.00,
    5300.00,
    5300.00,
    0.00,
    'Pending',
    'Unpaid',
    'Fahad',
    'ABC COMPANY PVT LTD'
  );
INSERT INTO
  `invoice_table` (
    `Id`,
    `InvoiceNo`,
    `InvoiceDate`,
    `CollectionPeriod`,
    `CusId`,
    `CusName`,
    `Address`,
    `CollectionId`,
    `CollectionDate`,
    `Provider`,
    `Collections`,
    `Rate`,
    `Commission`,
    `TotalColl`,
    `TotalComm`,
    `BasePayment`,
    `GrandTotal`,
    `BalToPay`,
    `AmountPaid`,
    `ApprovalStatus`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    531,
    'INV000035',
    '2021-08-23',
    '2021-07',
    'CON000022',
    'Fahad Razzaq',
    'no address avauilable - none',
    133,
    'Jul 2021',
    'Base Pay Provider',
    0.00,
    '250.00',
    0.00,
    0.00,
    0.00,
    250.00,
    250.00,
    250.00,
    0.00,
    'Pending',
    'Unpaid',
    'Fahad',
    'ABC COMPANY PVT LTD'
  );
INSERT INTO
  `invoice_table` (
    `Id`,
    `InvoiceNo`,
    `InvoiceDate`,
    `CollectionPeriod`,
    `CusId`,
    `CusName`,
    `Address`,
    `CollectionId`,
    `CollectionDate`,
    `Provider`,
    `Collections`,
    `Rate`,
    `Commission`,
    `TotalColl`,
    `TotalComm`,
    `BasePayment`,
    `GrandTotal`,
    `BalToPay`,
    `AmountPaid`,
    `ApprovalStatus`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    532,
    'INV000036',
    '2021-08-23',
    '2021-06',
    'CON000030',
    'Tabitha Contee',
    '15 Queen Anne Bridge Road\nUpper Marlboro, MD  20774',
    140,
    'Jun 2021',
    'Veronica Watkins, LCSW-C',
    8363.04,
    '4.5',
    376.34,
    57306.84,
    2578.81,
    0.00,
    2578.81,
    0.00,
    2578.81,
    'Approved',
    'Paid',
    'tconteeinvoices',
    'Billing Plus, Inc.'
  );
INSERT INTO
  `invoice_table` (
    `Id`,
    `InvoiceNo`,
    `InvoiceDate`,
    `CollectionPeriod`,
    `CusId`,
    `CusName`,
    `Address`,
    `CollectionId`,
    `CollectionDate`,
    `Provider`,
    `Collections`,
    `Rate`,
    `Commission`,
    `TotalColl`,
    `TotalComm`,
    `BasePayment`,
    `GrandTotal`,
    `BalToPay`,
    `AmountPaid`,
    `ApprovalStatus`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    533,
    'INV000036',
    '2021-08-23',
    '2021-06',
    'CON000030',
    'Tabitha Contee',
    '15 Queen Anne Bridge Road\nUpper Marlboro, MD  20774',
    139,
    'Jun 2021',
    'Winnie Moore, LCPC',
    19539.59,
    '4.5',
    879.28,
    57306.84,
    2578.81,
    0.00,
    2578.81,
    0.00,
    2578.81,
    'Approved',
    'Paid',
    'tconteeinvoices',
    'Billing Plus, Inc.'
  );
INSERT INTO
  `invoice_table` (
    `Id`,
    `InvoiceNo`,
    `InvoiceDate`,
    `CollectionPeriod`,
    `CusId`,
    `CusName`,
    `Address`,
    `CollectionId`,
    `CollectionDate`,
    `Provider`,
    `Collections`,
    `Rate`,
    `Commission`,
    `TotalColl`,
    `TotalComm`,
    `BasePayment`,
    `GrandTotal`,
    `BalToPay`,
    `AmountPaid`,
    `ApprovalStatus`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    534,
    'INV000036',
    '2021-08-23',
    '2021-06',
    'CON000030',
    'Tabitha Contee',
    '15 Queen Anne Bridge Road\nUpper Marlboro, MD  20774',
    138,
    'Jun 2021',
    'Carla D. Washington, LPC',
    16527.95,
    '4.5',
    743.76,
    57306.84,
    2578.81,
    0.00,
    2578.81,
    0.00,
    2578.81,
    'Approved',
    'Paid',
    'tconteeinvoices',
    'Billing Plus, Inc.'
  );
INSERT INTO
  `invoice_table` (
    `Id`,
    `InvoiceNo`,
    `InvoiceDate`,
    `CollectionPeriod`,
    `CusId`,
    `CusName`,
    `Address`,
    `CollectionId`,
    `CollectionDate`,
    `Provider`,
    `Collections`,
    `Rate`,
    `Commission`,
    `TotalColl`,
    `TotalComm`,
    `BasePayment`,
    `GrandTotal`,
    `BalToPay`,
    `AmountPaid`,
    `ApprovalStatus`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    535,
    'INV000036',
    '2021-08-23',
    '2021-06',
    'CON000030',
    'Tabitha Contee',
    '15 Queen Anne Bridge Road\nUpper Marlboro, MD  20774',
    137,
    'Jun 2021',
    'Joy R. Hart, LCSW-C',
    6529.76,
    '4.5',
    293.84,
    57306.84,
    2578.81,
    0.00,
    2578.81,
    0.00,
    2578.81,
    'Approved',
    'Paid',
    'tconteeinvoices',
    'Billing Plus, Inc.'
  );
INSERT INTO
  `invoice_table` (
    `Id`,
    `InvoiceNo`,
    `InvoiceDate`,
    `CollectionPeriod`,
    `CusId`,
    `CusName`,
    `Address`,
    `CollectionId`,
    `CollectionDate`,
    `Provider`,
    `Collections`,
    `Rate`,
    `Commission`,
    `TotalColl`,
    `TotalComm`,
    `BasePayment`,
    `GrandTotal`,
    `BalToPay`,
    `AmountPaid`,
    `ApprovalStatus`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    536,
    'INV000036',
    '2021-08-23',
    '2021-06',
    'CON000030',
    'Tabitha Contee',
    '15 Queen Anne Bridge Road\nUpper Marlboro, MD  20774',
    136,
    'Jun 2021',
    'Donna Reid Washington, LPC',
    2662.10,
    '4.5',
    119.79,
    57306.84,
    2578.81,
    0.00,
    2578.81,
    0.00,
    2578.81,
    'Approved',
    'Paid',
    'tconteeinvoices',
    'Billing Plus, Inc.'
  );
INSERT INTO
  `invoice_table` (
    `Id`,
    `InvoiceNo`,
    `InvoiceDate`,
    `CollectionPeriod`,
    `CusId`,
    `CusName`,
    `Address`,
    `CollectionId`,
    `CollectionDate`,
    `Provider`,
    `Collections`,
    `Rate`,
    `Commission`,
    `TotalColl`,
    `TotalComm`,
    `BasePayment`,
    `GrandTotal`,
    `BalToPay`,
    `AmountPaid`,
    `ApprovalStatus`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    537,
    'INV000036',
    '2021-08-23',
    '2021-06',
    'CON000030',
    'Tabitha Contee',
    '15 Queen Anne Bridge Road\nUpper Marlboro, MD  20774',
    135,
    'Jun 2021',
    'DC HT - Bharat Vallurapalli, MS, OTR/L',
    1403.78,
    '4.5',
    63.17,
    57306.84,
    2578.81,
    0.00,
    2578.81,
    0.00,
    2578.81,
    'Approved',
    'Paid',
    'tconteeinvoices',
    'Billing Plus, Inc.'
  );
INSERT INTO
  `invoice_table` (
    `Id`,
    `InvoiceNo`,
    `InvoiceDate`,
    `CollectionPeriod`,
    `CusId`,
    `CusName`,
    `Address`,
    `CollectionId`,
    `CollectionDate`,
    `Provider`,
    `Collections`,
    `Rate`,
    `Commission`,
    `TotalColl`,
    `TotalComm`,
    `BasePayment`,
    `GrandTotal`,
    `BalToPay`,
    `AmountPaid`,
    `ApprovalStatus`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    538,
    'INV000036',
    '2021-08-23',
    '2021-06',
    'CON000030',
    'Tabitha Contee',
    '15 Queen Anne Bridge Road\nUpper Marlboro, MD  20774',
    134,
    'Jun 2021',
    'Apex - Bharat Vallurapalli, MS, OTR/L',
    2280.62,
    '4.5',
    102.63,
    57306.84,
    2578.81,
    0.00,
    2578.81,
    0.00,
    2578.81,
    'Approved',
    'Paid',
    'tconteeinvoices',
    'Billing Plus, Inc.'
  );
INSERT INTO
  `invoice_table` (
    `Id`,
    `InvoiceNo`,
    `InvoiceDate`,
    `CollectionPeriod`,
    `CusId`,
    `CusName`,
    `Address`,
    `CollectionId`,
    `CollectionDate`,
    `Provider`,
    `Collections`,
    `Rate`,
    `Commission`,
    `TotalColl`,
    `TotalComm`,
    `BasePayment`,
    `GrandTotal`,
    `BalToPay`,
    `AmountPaid`,
    `ApprovalStatus`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    547,
    'INV000037',
    '2021-08-23',
    '2021-06',
    'CON000031',
    'Covita Mills',
    '2571 Enterprise Place\nWaldorf, MD 20601',
    162,
    'Jun 2021',
    'Thomas Patota, LCSW',
    1495.42,
    '1',
    14.95,
    65221.74,
    652.23,
    0.00,
    652.23,
    0.00,
    652.23,
    'Approved',
    'Paid',
    'cmillsinvoices',
    'Billing Plus, Inc.'
  );
INSERT INTO
  `invoice_table` (
    `Id`,
    `InvoiceNo`,
    `InvoiceDate`,
    `CollectionPeriod`,
    `CusId`,
    `CusName`,
    `Address`,
    `CollectionId`,
    `CollectionDate`,
    `Provider`,
    `Collections`,
    `Rate`,
    `Commission`,
    `TotalColl`,
    `TotalComm`,
    `BasePayment`,
    `GrandTotal`,
    `BalToPay`,
    `AmountPaid`,
    `ApprovalStatus`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    548,
    'INV000037',
    '2021-08-23',
    '2021-06',
    'CON000031',
    'Covita Mills',
    '2571 Enterprise Place\nWaldorf, MD 20601',
    157,
    'Jun 2021',
    'Yetta Lyle, LCPC',
    966.51,
    '1',
    9.67,
    65221.74,
    652.23,
    0.00,
    652.23,
    0.00,
    652.23,
    'Approved',
    'Paid',
    'cmillsinvoices',
    'Billing Plus, Inc.'
  );
INSERT INTO
  `invoice_table` (
    `Id`,
    `InvoiceNo`,
    `InvoiceDate`,
    `CollectionPeriod`,
    `CusId`,
    `CusName`,
    `Address`,
    `CollectionId`,
    `CollectionDate`,
    `Provider`,
    `Collections`,
    `Rate`,
    `Commission`,
    `TotalColl`,
    `TotalComm`,
    `BasePayment`,
    `GrandTotal`,
    `BalToPay`,
    `AmountPaid`,
    `ApprovalStatus`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    549,
    'INV000037',
    '2021-08-23',
    '2021-06',
    'CON000031',
    'Covita Mills',
    '2571 Enterprise Place\nWaldorf, MD 20601',
    156,
    'Jun 2021',
    'Onyx Therapy Group - Dr. LaNail Plummer',
    32231.60,
    '1',
    322.32,
    65221.74,
    652.23,
    0.00,
    652.23,
    0.00,
    652.23,
    'Approved',
    'Paid',
    'cmillsinvoices',
    'Billing Plus, Inc.'
  );
INSERT INTO
  `invoice_table` (
    `Id`,
    `InvoiceNo`,
    `InvoiceDate`,
    `CollectionPeriod`,
    `CusId`,
    `CusName`,
    `Address`,
    `CollectionId`,
    `CollectionDate`,
    `Provider`,
    `Collections`,
    `Rate`,
    `Commission`,
    `TotalColl`,
    `TotalComm`,
    `BasePayment`,
    `GrandTotal`,
    `BalToPay`,
    `AmountPaid`,
    `ApprovalStatus`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    550,
    'INV000037',
    '2021-08-23',
    '2021-06',
    'CON000031',
    'Covita Mills',
    '2571 Enterprise Place\nWaldorf, MD 20601',
    154,
    'Jun 2021',
    'Samantha Knox, LPC',
    6964.59,
    '1',
    69.65,
    65221.74,
    652.23,
    0.00,
    652.23,
    0.00,
    652.23,
    'Approved',
    'Paid',
    'cmillsinvoices',
    'Billing Plus, Inc.'
  );
INSERT INTO
  `invoice_table` (
    `Id`,
    `InvoiceNo`,
    `InvoiceDate`,
    `CollectionPeriod`,
    `CusId`,
    `CusName`,
    `Address`,
    `CollectionId`,
    `CollectionDate`,
    `Provider`,
    `Collections`,
    `Rate`,
    `Commission`,
    `TotalColl`,
    `TotalComm`,
    `BasePayment`,
    `GrandTotal`,
    `BalToPay`,
    `AmountPaid`,
    `ApprovalStatus`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    551,
    'INV000037',
    '2021-08-23',
    '2021-06',
    'CON000031',
    'Covita Mills',
    '2571 Enterprise Place\nWaldorf, MD 20601',
    152,
    'Jun 2021',
    'Wanda D. Smith, LCSW-C',
    842.64,
    '1',
    8.43,
    65221.74,
    652.23,
    0.00,
    652.23,
    0.00,
    652.23,
    'Approved',
    'Paid',
    'cmillsinvoices',
    'Billing Plus, Inc.'
  );
INSERT INTO
  `invoice_table` (
    `Id`,
    `InvoiceNo`,
    `InvoiceDate`,
    `CollectionPeriod`,
    `CusId`,
    `CusName`,
    `Address`,
    `CollectionId`,
    `CollectionDate`,
    `Provider`,
    `Collections`,
    `Rate`,
    `Commission`,
    `TotalColl`,
    `TotalComm`,
    `BasePayment`,
    `GrandTotal`,
    `BalToPay`,
    `AmountPaid`,
    `ApprovalStatus`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    552,
    'INV000037',
    '2021-08-23',
    '2021-06',
    'CON000031',
    'Covita Mills',
    '2571 Enterprise Place\nWaldorf, MD 20601',
    150,
    'Jun 2021',
    'Nicole Rudd, LCPC',
    676.01,
    '1',
    6.76,
    65221.74,
    652.23,
    0.00,
    652.23,
    0.00,
    652.23,
    'Approved',
    'Paid',
    'cmillsinvoices',
    'Billing Plus, Inc.'
  );
INSERT INTO
  `invoice_table` (
    `Id`,
    `InvoiceNo`,
    `InvoiceDate`,
    `CollectionPeriod`,
    `CusId`,
    `CusName`,
    `Address`,
    `CollectionId`,
    `CollectionDate`,
    `Provider`,
    `Collections`,
    `Rate`,
    `Commission`,
    `TotalColl`,
    `TotalComm`,
    `BasePayment`,
    `GrandTotal`,
    `BalToPay`,
    `AmountPaid`,
    `ApprovalStatus`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    553,
    'INV000037',
    '2021-08-23',
    '2021-06',
    'CON000031',
    'Covita Mills',
    '2571 Enterprise Place\nWaldorf, MD 20601',
    149,
    'Jun 2021',
    'Lenese Stephens, LCPC',
    22044.97,
    '1',
    220.45,
    65221.74,
    652.23,
    0.00,
    652.23,
    0.00,
    652.23,
    'Approved',
    'Paid',
    'cmillsinvoices',
    'Billing Plus, Inc.'
  );
INSERT INTO
  `invoice_table` (
    `Id`,
    `InvoiceNo`,
    `InvoiceDate`,
    `CollectionPeriod`,
    `CusId`,
    `CusName`,
    `Address`,
    `CollectionId`,
    `CollectionDate`,
    `Provider`,
    `Collections`,
    `Rate`,
    `Commission`,
    `TotalColl`,
    `TotalComm`,
    `BasePayment`,
    `GrandTotal`,
    `BalToPay`,
    `AmountPaid`,
    `ApprovalStatus`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    562,
    'INV000040',
    '2021-02-01',
    '2021-01',
    'CON000030',
    'Tabitha Contee',
    '15 Queen Anne Bridge Road\nUpper Marlboro, MD  20774',
    166,
    'Jan 2021',
    'Base Payment',
    0.00,
    '100',
    0.00,
    0.00,
    0.00,
    1000.00,
    1000.00,
    0.00,
    1000.00,
    'Approved',
    'Paid',
    'tconteeinvoices',
    'Billing Plus, Inc.'
  );
INSERT INTO
  `invoice_table` (
    `Id`,
    `InvoiceNo`,
    `InvoiceDate`,
    `CollectionPeriod`,
    `CusId`,
    `CusName`,
    `Address`,
    `CollectionId`,
    `CollectionDate`,
    `Provider`,
    `Collections`,
    `Rate`,
    `Commission`,
    `TotalColl`,
    `TotalComm`,
    `BasePayment`,
    `GrandTotal`,
    `BalToPay`,
    `AmountPaid`,
    `ApprovalStatus`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    563,
    'INV000041',
    '2021-03-01',
    '2021-02',
    'CON000030',
    'Tabitha Contee',
    '15 Queen Anne Bridge Road\nUpper Marlboro, MD  20774',
    167,
    'Feb 2021',
    'Base Payment',
    0.00,
    '100',
    0.00,
    0.00,
    0.00,
    1000.00,
    1000.00,
    1000.00,
    0.00,
    'Approved',
    'Unpaid',
    'tconteeinvoices',
    'Billing Plus, Inc.'
  );
INSERT INTO
  `invoice_table` (
    `Id`,
    `InvoiceNo`,
    `InvoiceDate`,
    `CollectionPeriod`,
    `CusId`,
    `CusName`,
    `Address`,
    `CollectionId`,
    `CollectionDate`,
    `Provider`,
    `Collections`,
    `Rate`,
    `Commission`,
    `TotalColl`,
    `TotalComm`,
    `BasePayment`,
    `GrandTotal`,
    `BalToPay`,
    `AmountPaid`,
    `ApprovalStatus`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    564,
    'INV000042',
    '2021-04-02',
    '2021-03',
    'CON000030',
    'Tabitha Contee',
    '15 Queen Anne Bridge Road\nUpper Marlboro, MD  20774',
    168,
    'Mar 2021',
    'Base Payment',
    0.00,
    '100',
    0.00,
    0.00,
    0.00,
    1000.00,
    1000.00,
    1000.00,
    0.00,
    'Approved',
    'Unpaid',
    'tconteeinvoices',
    'Billing Plus, Inc.'
  );
INSERT INTO
  `invoice_table` (
    `Id`,
    `InvoiceNo`,
    `InvoiceDate`,
    `CollectionPeriod`,
    `CusId`,
    `CusName`,
    `Address`,
    `CollectionId`,
    `CollectionDate`,
    `Provider`,
    `Collections`,
    `Rate`,
    `Commission`,
    `TotalColl`,
    `TotalComm`,
    `BasePayment`,
    `GrandTotal`,
    `BalToPay`,
    `AmountPaid`,
    `ApprovalStatus`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    565,
    'INV000043',
    '2021-06-02',
    '2021-05',
    'CON000030',
    'Tabitha Contee',
    '15 Queen Anne Bridge Road\nUpper Marlboro, MD  20774',
    170,
    'May 2021',
    'Base Payment',
    0.00,
    '100',
    0.00,
    0.00,
    0.00,
    1000.00,
    1000.00,
    1000.00,
    0.00,
    'Approved',
    'Unpaid',
    'tconteeinvoices',
    'Billing Plus, Inc.'
  );
INSERT INTO
  `invoice_table` (
    `Id`,
    `InvoiceNo`,
    `InvoiceDate`,
    `CollectionPeriod`,
    `CusId`,
    `CusName`,
    `Address`,
    `CollectionId`,
    `CollectionDate`,
    `Provider`,
    `Collections`,
    `Rate`,
    `Commission`,
    `TotalColl`,
    `TotalComm`,
    `BasePayment`,
    `GrandTotal`,
    `BalToPay`,
    `AmountPaid`,
    `ApprovalStatus`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    566,
    'INV000044',
    '2021-07-02',
    '2021-06',
    'CON000030',
    'Tabitha Contee',
    '15 Queen Anne Bridge Road\nUpper Marlboro, MD  20774',
    171,
    'Jun 2021',
    'Base Payment',
    0.00,
    '100',
    0.00,
    0.00,
    0.00,
    1000.00,
    1000.00,
    1000.00,
    0.00,
    'Approved',
    'Unpaid',
    'tconteeinvoices',
    'Billing Plus, Inc.'
  );
INSERT INTO
  `invoice_table` (
    `Id`,
    `InvoiceNo`,
    `InvoiceDate`,
    `CollectionPeriod`,
    `CusId`,
    `CusName`,
    `Address`,
    `CollectionId`,
    `CollectionDate`,
    `Provider`,
    `Collections`,
    `Rate`,
    `Commission`,
    `TotalColl`,
    `TotalComm`,
    `BasePayment`,
    `GrandTotal`,
    `BalToPay`,
    `AmountPaid`,
    `ApprovalStatus`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    567,
    'INV000045',
    '2021-07-22',
    '2021-07',
    'CON000033',
    'Javon Young',
    '11300 Kettering Place\nUpper Marlboro, MD  20774',
    172,
    'Jul 2021',
    'Base Payment',
    0.00,
    '100',
    0.00,
    0.00,
    0.00,
    2625.67,
    2625.67,
    0.00,
    2625.67,
    'Approved',
    'Paid',
    'jyounginvoices',
    'Billing Plus, Inc.'
  );
INSERT INTO
  `invoice_table` (
    `Id`,
    `InvoiceNo`,
    `InvoiceDate`,
    `CollectionPeriod`,
    `CusId`,
    `CusName`,
    `Address`,
    `CollectionId`,
    `CollectionDate`,
    `Provider`,
    `Collections`,
    `Rate`,
    `Commission`,
    `TotalColl`,
    `TotalComm`,
    `BasePayment`,
    `GrandTotal`,
    `BalToPay`,
    `AmountPaid`,
    `ApprovalStatus`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    568,
    'INV000046',
    '2021-08-23',
    '2021-05',
    'CON000033',
    'Javon Young',
    '11300 Kettering Place\nUpper Marlboro, MD  20774',
    173,
    'May 2021',
    'Create Your Life, LLC',
    1000.00,
    '4',
    40.00,
    1000.00,
    40.00,
    2625.67,
    2665.67,
    0.00,
    2665.67,
    'Approved',
    'Paid',
    'jyounginvoices',
    'Billing Plus, Inc.'
  );
INSERT INTO
  `invoice_table` (
    `Id`,
    `InvoiceNo`,
    `InvoiceDate`,
    `CollectionPeriod`,
    `CusId`,
    `CusName`,
    `Address`,
    `CollectionId`,
    `CollectionDate`,
    `Provider`,
    `Collections`,
    `Rate`,
    `Commission`,
    `TotalColl`,
    `TotalComm`,
    `BasePayment`,
    `GrandTotal`,
    `BalToPay`,
    `AmountPaid`,
    `ApprovalStatus`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    569,
    'INV000047',
    '2021-05-03',
    '2021-04',
    'CON000030',
    'Tabitha Contee',
    '15 Queen Anne Bridge Road\nUpper Marlboro, MD  20774',
    169,
    'Apr 2021',
    'Base Payment',
    0.00,
    '100',
    0.00,
    0.00,
    0.00,
    1000.00,
    1000.00,
    1000.00,
    0.00,
    'Approved',
    'Unpaid',
    'tconteeinvoices',
    'Billing Plus, Inc.'
  );
INSERT INTO
  `invoice_table` (
    `Id`,
    `InvoiceNo`,
    `InvoiceDate`,
    `CollectionPeriod`,
    `CusId`,
    `CusName`,
    `Address`,
    `CollectionId`,
    `CollectionDate`,
    `Provider`,
    `Collections`,
    `Rate`,
    `Commission`,
    `TotalColl`,
    `TotalComm`,
    `BasePayment`,
    `GrandTotal`,
    `BalToPay`,
    `AmountPaid`,
    `ApprovalStatus`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    570,
    'INV000048',
    '2021-01-02',
    '2020-12',
    'CON000030',
    'Tabitha Contee',
    '15 Queen Anne Bridge Road\nUpper Marlboro, MD  20774',
    174,
    'Dec 2020',
    'Base Payment',
    0.00,
    '100',
    0.00,
    0.00,
    0.00,
    1000.00,
    1000.00,
    0.00,
    1000.00,
    'Approved',
    'Paid',
    'tconteeinvoices',
    'Billing Plus, Inc.'
  );
INSERT INTO
  `invoice_table` (
    `Id`,
    `InvoiceNo`,
    `InvoiceDate`,
    `CollectionPeriod`,
    `CusId`,
    `CusName`,
    `Address`,
    `CollectionId`,
    `CollectionDate`,
    `Provider`,
    `Collections`,
    `Rate`,
    `Commission`,
    `TotalColl`,
    `TotalComm`,
    `BasePayment`,
    `GrandTotal`,
    `BalToPay`,
    `AmountPaid`,
    `ApprovalStatus`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    577,
    'INV000049',
    '2021-08-24',
    '2021-06',
    'CON000032',
    'Sanora Wicker',
    '17204 Britfield Court\nAccokeek, MD 20607',
    176,
    'Jun 2021',
    'Yetta Lyle, LCPC',
    145.00,
    '2',
    2.90,
    9918.12,
    198.37,
    0.00,
    198.37,
    0.00,
    198.37,
    'Approved',
    'Paid',
    'swickerinvoices',
    'Billing Plus, Inc.'
  );
INSERT INTO
  `invoice_table` (
    `Id`,
    `InvoiceNo`,
    `InvoiceDate`,
    `CollectionPeriod`,
    `CusId`,
    `CusName`,
    `Address`,
    `CollectionId`,
    `CollectionDate`,
    `Provider`,
    `Collections`,
    `Rate`,
    `Commission`,
    `TotalColl`,
    `TotalComm`,
    `BasePayment`,
    `GrandTotal`,
    `BalToPay`,
    `AmountPaid`,
    `ApprovalStatus`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    578,
    'INV000049',
    '2021-08-24',
    '2021-06',
    'CON000032',
    'Sanora Wicker',
    '17204 Britfield Court\nAccokeek, MD 20607',
    175,
    'Jun 2021',
    'Winnie Moore, LCPC',
    2107.17,
    '2',
    42.14,
    9918.12,
    198.37,
    0.00,
    198.37,
    0.00,
    198.37,
    'Approved',
    'Paid',
    'swickerinvoices',
    'Billing Plus, Inc.'
  );
INSERT INTO
  `invoice_table` (
    `Id`,
    `InvoiceNo`,
    `InvoiceDate`,
    `CollectionPeriod`,
    `CusId`,
    `CusName`,
    `Address`,
    `CollectionId`,
    `CollectionDate`,
    `Provider`,
    `Collections`,
    `Rate`,
    `Commission`,
    `TotalColl`,
    `TotalComm`,
    `BasePayment`,
    `GrandTotal`,
    `BalToPay`,
    `AmountPaid`,
    `ApprovalStatus`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    579,
    'INV000049',
    '2021-08-24',
    '2021-06',
    'CON000032',
    'Sanora Wicker',
    '17204 Britfield Court\nAccokeek, MD 20607',
    163,
    'Jun 2021',
    'Karen L. Allen, LCSW-C',
    505.00,
    '2',
    10.10,
    9918.12,
    198.37,
    0.00,
    198.37,
    0.00,
    198.37,
    'Approved',
    'Paid',
    'swickerinvoices',
    'Billing Plus, Inc.'
  );
INSERT INTO
  `invoice_table` (
    `Id`,
    `InvoiceNo`,
    `InvoiceDate`,
    `CollectionPeriod`,
    `CusId`,
    `CusName`,
    `Address`,
    `CollectionId`,
    `CollectionDate`,
    `Provider`,
    `Collections`,
    `Rate`,
    `Commission`,
    `TotalColl`,
    `TotalComm`,
    `BasePayment`,
    `GrandTotal`,
    `BalToPay`,
    `AmountPaid`,
    `ApprovalStatus`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    580,
    'INV000049',
    '2021-08-24',
    '2021-06',
    'CON000032',
    'Sanora Wicker',
    '17204 Britfield Court\nAccokeek, MD 20607',
    160,
    'Jun 2021',
    'Donna R. Inman, LPC',
    1068.89,
    '2',
    21.38,
    9918.12,
    198.37,
    0.00,
    198.37,
    0.00,
    198.37,
    'Approved',
    'Paid',
    'swickerinvoices',
    'Billing Plus, Inc.'
  );
INSERT INTO
  `invoice_table` (
    `Id`,
    `InvoiceNo`,
    `InvoiceDate`,
    `CollectionPeriod`,
    `CusId`,
    `CusName`,
    `Address`,
    `CollectionId`,
    `CollectionDate`,
    `Provider`,
    `Collections`,
    `Rate`,
    `Commission`,
    `TotalColl`,
    `TotalComm`,
    `BasePayment`,
    `GrandTotal`,
    `BalToPay`,
    `AmountPaid`,
    `ApprovalStatus`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    581,
    'INV000049',
    '2021-08-24',
    '2021-06',
    'CON000032',
    'Sanora Wicker',
    '17204 Britfield Court\nAccokeek, MD 20607',
    159,
    'Jun 2021',
    'Gillian Blackman-Diarra, LCSW-C',
    385.00,
    '2',
    7.70,
    9918.12,
    198.37,
    0.00,
    198.37,
    0.00,
    198.37,
    'Approved',
    'Paid',
    'swickerinvoices',
    'Billing Plus, Inc.'
  );
INSERT INTO
  `invoice_table` (
    `Id`,
    `InvoiceNo`,
    `InvoiceDate`,
    `CollectionPeriod`,
    `CusId`,
    `CusName`,
    `Address`,
    `CollectionId`,
    `CollectionDate`,
    `Provider`,
    `Collections`,
    `Rate`,
    `Commission`,
    `TotalColl`,
    `TotalComm`,
    `BasePayment`,
    `GrandTotal`,
    `BalToPay`,
    `AmountPaid`,
    `ApprovalStatus`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    582,
    'INV000049',
    '2021-08-24',
    '2021-06',
    'CON000032',
    'Sanora Wicker',
    '17204 Britfield Court\nAccokeek, MD 20607',
    158,
    'Jun 2021',
    'Jacqueline R. Williams, LCSW',
    1504.27,
    '2',
    30.09,
    9918.12,
    198.37,
    0.00,
    198.37,
    0.00,
    198.37,
    'Approved',
    'Paid',
    'swickerinvoices',
    'Billing Plus, Inc.'
  );
INSERT INTO
  `invoice_table` (
    `Id`,
    `InvoiceNo`,
    `InvoiceDate`,
    `CollectionPeriod`,
    `CusId`,
    `CusName`,
    `Address`,
    `CollectionId`,
    `CollectionDate`,
    `Provider`,
    `Collections`,
    `Rate`,
    `Commission`,
    `TotalColl`,
    `TotalComm`,
    `BasePayment`,
    `GrandTotal`,
    `BalToPay`,
    `AmountPaid`,
    `ApprovalStatus`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    583,
    'INV000049',
    '2021-08-24',
    '2021-06',
    'CON000032',
    'Sanora Wicker',
    '17204 Britfield Court\nAccokeek, MD 20607',
    155,
    'Jun 2021',
    'Glenda Bullock-Willis, LCPC',
    0.00,
    '2',
    0.00,
    9918.12,
    198.37,
    0.00,
    198.37,
    0.00,
    198.37,
    'Approved',
    'Paid',
    'swickerinvoices',
    'Billing Plus, Inc.'
  );
INSERT INTO
  `invoice_table` (
    `Id`,
    `InvoiceNo`,
    `InvoiceDate`,
    `CollectionPeriod`,
    `CusId`,
    `CusName`,
    `Address`,
    `CollectionId`,
    `CollectionDate`,
    `Provider`,
    `Collections`,
    `Rate`,
    `Commission`,
    `TotalColl`,
    `TotalComm`,
    `BasePayment`,
    `GrandTotal`,
    `BalToPay`,
    `AmountPaid`,
    `ApprovalStatus`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    584,
    'INV000049',
    '2021-08-24',
    '2021-06',
    'CON000032',
    'Sanora Wicker',
    '17204 Britfield Court\nAccokeek, MD 20607',
    145,
    'Jun 2021',
    'Create Your Life, LLC',
    4202.79,
    '2',
    84.06,
    9918.12,
    198.37,
    0.00,
    198.37,
    0.00,
    198.37,
    'Approved',
    'Paid',
    'swickerinvoices',
    'Billing Plus, Inc.'
  );
INSERT INTO
  `invoice_table` (
    `Id`,
    `InvoiceNo`,
    `InvoiceDate`,
    `CollectionPeriod`,
    `CusId`,
    `CusName`,
    `Address`,
    `CollectionId`,
    `CollectionDate`,
    `Provider`,
    `Collections`,
    `Rate`,
    `Commission`,
    `TotalColl`,
    `TotalComm`,
    `BasePayment`,
    `GrandTotal`,
    `BalToPay`,
    `AmountPaid`,
    `ApprovalStatus`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    585,
    'INV000050',
    '2021-08-25',
    '2021-08',
    'CON000031',
    'Covita Mills',
    '2571 Enterprise Place\nWaldorf, MD 20601',
    177,
    'Aug 2021',
    'Base Payment',
    0.00,
    '100',
    0.00,
    0.00,
    0.00,
    4333.33,
    4333.33,
    0.00,
    4333.33,
    'Approved',
    'Paid',
    'cmillsinvoices',
    'Billing Plus, Inc.'
  );
INSERT INTO
  `invoice_table` (
    `Id`,
    `InvoiceNo`,
    `InvoiceDate`,
    `CollectionPeriod`,
    `CusId`,
    `CusName`,
    `Address`,
    `CollectionId`,
    `CollectionDate`,
    `Provider`,
    `Collections`,
    `Rate`,
    `Commission`,
    `TotalColl`,
    `TotalComm`,
    `BasePayment`,
    `GrandTotal`,
    `BalToPay`,
    `AmountPaid`,
    `ApprovalStatus`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    587,
    'INV000052',
    '2021-09-01',
    '2021-08',
    'CON000033',
    'Javon Young',
    '11300 Kettering Place\nUpper Marlboro, MD  20774',
    179,
    'Aug 2021',
    'Base Payment',
    0.00,
    '100',
    0.00,
    0.00,
    0.00,
    2625.67,
    2625.67,
    2625.67,
    0.00,
    'Approved',
    'Unpaid',
    'jyounginvoices',
    'Billing Plus, Inc.'
  );
INSERT INTO
  `invoice_table` (
    `Id`,
    `InvoiceNo`,
    `InvoiceDate`,
    `CollectionPeriod`,
    `CusId`,
    `CusName`,
    `Address`,
    `CollectionId`,
    `CollectionDate`,
    `Provider`,
    `Collections`,
    `Rate`,
    `Commission`,
    `TotalColl`,
    `TotalComm`,
    `BasePayment`,
    `GrandTotal`,
    `BalToPay`,
    `AmountPaid`,
    `ApprovalStatus`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    588,
    'INV000053',
    '2021-09-01',
    '2021-07',
    'CON000030',
    'Tabitha Contee',
    '15 Queen Anne Bridge Road\nUpper Marlboro, MD  20774',
    165,
    'Jul 2021',
    'Base Payment',
    0.00,
    '100',
    0.00,
    0.00,
    0.00,
    1000.00,
    1000.00,
    1000.00,
    0.00,
    'Approved',
    'Unpaid',
    'tconteeinvoices',
    'Billing Plus, Inc.'
  );
INSERT INTO
  `invoice_table` (
    `Id`,
    `InvoiceNo`,
    `InvoiceDate`,
    `CollectionPeriod`,
    `CusId`,
    `CusName`,
    `Address`,
    `CollectionId`,
    `CollectionDate`,
    `Provider`,
    `Collections`,
    `Rate`,
    `Commission`,
    `TotalColl`,
    `TotalComm`,
    `BasePayment`,
    `GrandTotal`,
    `BalToPay`,
    `AmountPaid`,
    `ApprovalStatus`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    589,
    'INV000054',
    '2021-09-02',
    '2021-08',
    'CON000032',
    'Sanora Wicker',
    '17204 Britfield Court\nAccokeek, MD 20607',
    180,
    'Aug 2021',
    'Base Payment',
    0.00,
    '100',
    0.00,
    0.00,
    0.00,
    2166.67,
    2166.67,
    0.00,
    2166.67,
    'Approved',
    'Paid',
    'SWICKERINVOICES',
    'Billing Plus, Inc.'
  );
INSERT INTO
  `invoice_table` (
    `Id`,
    `InvoiceNo`,
    `InvoiceDate`,
    `CollectionPeriod`,
    `CusId`,
    `CusName`,
    `Address`,
    `CollectionId`,
    `CollectionDate`,
    `Provider`,
    `Collections`,
    `Rate`,
    `Commission`,
    `TotalColl`,
    `TotalComm`,
    `BasePayment`,
    `GrandTotal`,
    `BalToPay`,
    `AmountPaid`,
    `ApprovalStatus`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    590,
    'INV000055',
    '2021-09-02',
    '2021-08',
    'CON000030',
    'Tabitha Contee',
    '15 Queen Anne Bridge Road\nUpper Marlboro, MD  20774',
    181,
    'Aug 2021',
    'Base Payment',
    0.00,
    '100',
    0.00,
    0.00,
    0.00,
    1000.00,
    1000.00,
    0.00,
    1000.00,
    'Approved',
    'Paid',
    'tconteeinvoices',
    'Billing Plus, Inc.'
  );

# ------------------------------------------------------------
# DATA DUMP FOR TABLE: assigned_contractor_table
# ------------------------------------------------------------

INSERT INTO
  `assigned_contractor_table` (
    `Id`,
    `ProvId`,
    `ProviderName`,
    `ConId`,
    `ContractorName`,
    `PayRate`,
    `StartDate`,
    `EndDate`,
    `ReasonToEnded`,
    `CompanyName`,
    `CreatedBy`
  )
VALUES
  (
    15,
    'CUS000044',
    'ANURA PERERA ',
    'EMP000017',
    'Anura Kumara',
    '12%',
    '2021-05-23',
    '2021-05-27',
    '',
    'RapidGnix',
    'admin'
  );
INSERT INTO
  `assigned_contractor_table` (
    `Id`,
    `ProvId`,
    `ProviderName`,
    `ConId`,
    `ContractorName`,
    `PayRate`,
    `StartDate`,
    `EndDate`,
    `ReasonToEnded`,
    `CompanyName`,
    `CreatedBy`
  )
VALUES
  (
    23,
    'CUS000066',
    'Asela Gunarathne',
    'CON000026',
    'Nalaka Bandara',
    '5%',
    '2021-06-15',
    NULL,
    '',
    'Novar Flex Pvt Ltd',
    'admin'
  );
INSERT INTO
  `assigned_contractor_table` (
    `Id`,
    `ProvId`,
    `ProviderName`,
    `ConId`,
    `ContractorName`,
    `PayRate`,
    `StartDate`,
    `EndDate`,
    `ReasonToEnded`,
    `CompanyName`,
    `CreatedBy`
  )
VALUES
  (
    34,
    'PRO000077',
    'Create Your Life, LLC',
    'CON000033',
    'Javon Young',
    '4',
    '2021-07-19',
    NULL,
    '',
    'Billing Plus, Inc.',
    'Ismith01'
  );
INSERT INTO
  `assigned_contractor_table` (
    `Id`,
    `ProvId`,
    `ProviderName`,
    `ConId`,
    `ContractorName`,
    `PayRate`,
    `StartDate`,
    `EndDate`,
    `ReasonToEnded`,
    `CompanyName`,
    `CreatedBy`
  )
VALUES
  (
    35,
    'PRO000076',
    'Jacqueline R. Williams, LCSW',
    'CON000033',
    'Javon Young',
    '4',
    '2021-07-19',
    NULL,
    '',
    'Billing Plus, Inc.',
    'Ismith01'
  );
INSERT INTO
  `assigned_contractor_table` (
    `Id`,
    `ProvId`,
    `ProviderName`,
    `ConId`,
    `ContractorName`,
    `PayRate`,
    `StartDate`,
    `EndDate`,
    `ReasonToEnded`,
    `CompanyName`,
    `CreatedBy`
  )
VALUES
  (
    36,
    'PRO000079',
    'Onyx Therapy Group - Dr. LaNail Plummer',
    'CON000031',
    'Covita Mills',
    '1',
    '2020-11-05',
    NULL,
    '',
    'Billing Plus, Inc.',
    'Ismith01'
  );
INSERT INTO
  `assigned_contractor_table` (
    `Id`,
    `ProvId`,
    `ProviderName`,
    `ConId`,
    `ContractorName`,
    `PayRate`,
    `StartDate`,
    `EndDate`,
    `ReasonToEnded`,
    `CompanyName`,
    `CreatedBy`
  )
VALUES
  (
    37,
    'PRO000081',
    'Lenese Stephens, LCPC',
    'CON000031',
    'Covita Mills',
    '1',
    '2021-05-01',
    NULL,
    '',
    'Billing Plus, Inc.',
    'Ismith01'
  );
INSERT INTO
  `assigned_contractor_table` (
    `Id`,
    `ProvId`,
    `ProviderName`,
    `ConId`,
    `ContractorName`,
    `PayRate`,
    `StartDate`,
    `EndDate`,
    `ReasonToEnded`,
    `CompanyName`,
    `CreatedBy`
  )
VALUES
  (
    38,
    'PRO000082',
    'Nji J. Fru, CNPR',
    'CON000033',
    'Javon Young',
    '4',
    '2021-08-09',
    NULL,
    '',
    'Billing Plus, Inc.',
    'Ismith01'
  );
INSERT INTO
  `assigned_contractor_table` (
    `Id`,
    `ProvId`,
    `ProviderName`,
    `ConId`,
    `ContractorName`,
    `PayRate`,
    `StartDate`,
    `EndDate`,
    `ReasonToEnded`,
    `CompanyName`,
    `CreatedBy`
  )
VALUES
  (
    39,
    'PRO000083',
    'Samantha Knox, LPC',
    'CON000031',
    'Covita Mills',
    '1',
    '2021-01-01',
    NULL,
    '',
    'Billing Plus, Inc.',
    'Ismith01'
  );
INSERT INTO
  `assigned_contractor_table` (
    `Id`,
    `ProvId`,
    `ProviderName`,
    `ConId`,
    `ContractorName`,
    `PayRate`,
    `StartDate`,
    `EndDate`,
    `ReasonToEnded`,
    `CompanyName`,
    `CreatedBy`
  )
VALUES
  (
    40,
    'PRO000084',
    'Thomas Patota, LCSW',
    'CON000031',
    'Covita Mills',
    '1',
    '2021-01-01',
    NULL,
    '',
    'Billing Plus, Inc.',
    'Ismith01'
  );
INSERT INTO
  `assigned_contractor_table` (
    `Id`,
    `ProvId`,
    `ProviderName`,
    `ConId`,
    `ContractorName`,
    `PayRate`,
    `StartDate`,
    `EndDate`,
    `ReasonToEnded`,
    `CompanyName`,
    `CreatedBy`
  )
VALUES
  (
    41,
    'PRO000077',
    'Create Your Life, LLC',
    'CON000032',
    'Sanora Wicker',
    '2',
    '2021-05-17',
    NULL,
    '',
    'Billing Plus, Inc.',
    'Ismith01'
  );
INSERT INTO
  `assigned_contractor_table` (
    `Id`,
    `ProvId`,
    `ProviderName`,
    `ConId`,
    `ContractorName`,
    `PayRate`,
    `StartDate`,
    `EndDate`,
    `ReasonToEnded`,
    `CompanyName`,
    `CreatedBy`
  )
VALUES
  (
    42,
    'PRO000076',
    'Jacqueline R. Williams, LCSW',
    'CON000032',
    'Sanora Wicker',
    '2',
    '2021-05-17',
    NULL,
    '',
    'Billing Plus, Inc.',
    'Ismith01'
  );
INSERT INTO
  `assigned_contractor_table` (
    `Id`,
    `ProvId`,
    `ProviderName`,
    `ConId`,
    `ContractorName`,
    `PayRate`,
    `StartDate`,
    `EndDate`,
    `ReasonToEnded`,
    `CompanyName`,
    `CreatedBy`
  )
VALUES
  (
    43,
    'PRO000085',
    'Yetta Lyle, LCPC',
    'CON000031',
    'Covita Mills',
    '1',
    '2021-01-01',
    NULL,
    '',
    'Billing Plus, Inc.',
    'Ismith01'
  );
INSERT INTO
  `assigned_contractor_table` (
    `Id`,
    `ProvId`,
    `ProviderName`,
    `ConId`,
    `ContractorName`,
    `PayRate`,
    `StartDate`,
    `EndDate`,
    `ReasonToEnded`,
    `CompanyName`,
    `CreatedBy`
  )
VALUES
  (
    44,
    'PRO000086',
    'Judith Rose Wilson, LCPC',
    'CON000033',
    'Javon Young',
    '4',
    '2021-07-07',
    NULL,
    '',
    'Billing Plus, Inc.',
    'Ismith01'
  );
INSERT INTO
  `assigned_contractor_table` (
    `Id`,
    `ProvId`,
    `ProviderName`,
    `ConId`,
    `ContractorName`,
    `PayRate`,
    `StartDate`,
    `EndDate`,
    `ReasonToEnded`,
    `CompanyName`,
    `CreatedBy`
  )
VALUES
  (
    45,
    'PRO000086',
    'Judith Rose Wilson, LCPC',
    'CON000032',
    'Sanora Wicker',
    '2',
    '2021-05-17',
    NULL,
    '',
    'Billing Plus, Inc.',
    'Ismith01'
  );
INSERT INTO
  `assigned_contractor_table` (
    `Id`,
    `ProvId`,
    `ProviderName`,
    `ConId`,
    `ContractorName`,
    `PayRate`,
    `StartDate`,
    `EndDate`,
    `ReasonToEnded`,
    `CompanyName`,
    `CreatedBy`
  )
VALUES
  (
    46,
    'PRO000087',
    'Joy R. Hart, LCSW-C',
    'CON000030',
    'Tabitha Contee',
    '4.5',
    '2015-01-01',
    NULL,
    '',
    'Billing Plus, Inc.',
    'Ismith01'
  );
INSERT INTO
  `assigned_contractor_table` (
    `Id`,
    `ProvId`,
    `ProviderName`,
    `ConId`,
    `ContractorName`,
    `PayRate`,
    `StartDate`,
    `EndDate`,
    `ReasonToEnded`,
    `CompanyName`,
    `CreatedBy`
  )
VALUES
  (
    47,
    'PRO000088',
    'Karen L. Allen, LCSW-C',
    'CON000033',
    'Javon Young',
    '4',
    '2021-07-07',
    NULL,
    '',
    'Billing Plus, Inc.',
    'Ismith01'
  );
INSERT INTO
  `assigned_contractor_table` (
    `Id`,
    `ProvId`,
    `ProviderName`,
    `ConId`,
    `ContractorName`,
    `PayRate`,
    `StartDate`,
    `EndDate`,
    `ReasonToEnded`,
    `CompanyName`,
    `CreatedBy`
  )
VALUES
  (
    48,
    'PRO000088',
    'Karen L. Allen, LCSW-C',
    'CON000032',
    'Sanora Wicker',
    '2',
    '2021-05-17',
    NULL,
    '',
    'Billing Plus, Inc.',
    'Ismith01'
  );
INSERT INTO
  `assigned_contractor_table` (
    `Id`,
    `ProvId`,
    `ProviderName`,
    `ConId`,
    `ContractorName`,
    `PayRate`,
    `StartDate`,
    `EndDate`,
    `ReasonToEnded`,
    `CompanyName`,
    `CreatedBy`
  )
VALUES
  (
    49,
    'PRO000089',
    'Gillian Blackman-Diarra, LCSW-C',
    'CON000033',
    'Javon Young',
    '4',
    '2021-07-07',
    NULL,
    '',
    'Billing Plus, Inc.',
    'Ismith01'
  );
INSERT INTO
  `assigned_contractor_table` (
    `Id`,
    `ProvId`,
    `ProviderName`,
    `ConId`,
    `ContractorName`,
    `PayRate`,
    `StartDate`,
    `EndDate`,
    `ReasonToEnded`,
    `CompanyName`,
    `CreatedBy`
  )
VALUES
  (
    50,
    'PRO000089',
    'Gillian Blackman-Diarra, LCSW-C',
    'CON000032',
    'Sanora Wicker',
    '2',
    '2021-05-17',
    NULL,
    '',
    'Billing Plus, Inc.',
    'Ismith01'
  );
INSERT INTO
  `assigned_contractor_table` (
    `Id`,
    `ProvId`,
    `ProviderName`,
    `ConId`,
    `ContractorName`,
    `PayRate`,
    `StartDate`,
    `EndDate`,
    `ReasonToEnded`,
    `CompanyName`,
    `CreatedBy`
  )
VALUES
  (
    51,
    'PRO000090',
    'Glenda Bullock-Willis, LCPC',
    'CON000033',
    'Javon Young',
    '4',
    '2021-07-07',
    NULL,
    '',
    'Billing Plus, Inc.',
    'Ismith01'
  );
INSERT INTO
  `assigned_contractor_table` (
    `Id`,
    `ProvId`,
    `ProviderName`,
    `ConId`,
    `ContractorName`,
    `PayRate`,
    `StartDate`,
    `EndDate`,
    `ReasonToEnded`,
    `CompanyName`,
    `CreatedBy`
  )
VALUES
  (
    52,
    'PRO000090',
    'Glenda Bullock-Willis, LCPC',
    'CON000032',
    'Sanora Wicker',
    '2',
    '2021-05-17',
    NULL,
    '',
    'Billing Plus, Inc.',
    'Ismith01'
  );
INSERT INTO
  `assigned_contractor_table` (
    `Id`,
    `ProvId`,
    `ProviderName`,
    `ConId`,
    `ContractorName`,
    `PayRate`,
    `StartDate`,
    `EndDate`,
    `ReasonToEnded`,
    `CompanyName`,
    `CreatedBy`
  )
VALUES
  (
    53,
    'PRO000091',
    'Donna R. Inman, LPC',
    'CON000033',
    'Javon Young',
    '4',
    '2021-07-07',
    NULL,
    '',
    'Billing Plus, Inc.',
    'Ismith01'
  );
INSERT INTO
  `assigned_contractor_table` (
    `Id`,
    `ProvId`,
    `ProviderName`,
    `ConId`,
    `ContractorName`,
    `PayRate`,
    `StartDate`,
    `EndDate`,
    `ReasonToEnded`,
    `CompanyName`,
    `CreatedBy`
  )
VALUES
  (
    54,
    'PRO000091',
    'Donna R. Inman, LPC',
    'CON000032',
    'Sanora Wicker',
    '2',
    '2021-05-17',
    NULL,
    '',
    'Billing Plus, Inc.',
    'Ismith01'
  );
INSERT INTO
  `assigned_contractor_table` (
    `Id`,
    `ProvId`,
    `ProviderName`,
    `ConId`,
    `ContractorName`,
    `PayRate`,
    `StartDate`,
    `EndDate`,
    `ReasonToEnded`,
    `CompanyName`,
    `CreatedBy`
  )
VALUES
  (
    55,
    'PRO000092',
    'Apex - Bharat Vallurapalli, MS, OTR/L',
    'CON000030',
    'Tabitha Contee',
    '4.5',
    '2015-06-01',
    NULL,
    '',
    'Billing Plus, Inc.',
    'Ismith01'
  );
INSERT INTO
  `assigned_contractor_table` (
    `Id`,
    `ProvId`,
    `ProviderName`,
    `ConId`,
    `ContractorName`,
    `PayRate`,
    `StartDate`,
    `EndDate`,
    `ReasonToEnded`,
    `CompanyName`,
    `CreatedBy`
  )
VALUES
  (
    56,
    'PRO000093',
    'DC HT - Bharat Vallurapalli, MS, OTR/L',
    'CON000030',
    'Tabitha Contee',
    '4.5',
    '2015-03-01',
    NULL,
    '',
    'Billing Plus, Inc.',
    'Ismith01'
  );
INSERT INTO
  `assigned_contractor_table` (
    `Id`,
    `ProvId`,
    `ProviderName`,
    `ConId`,
    `ContractorName`,
    `PayRate`,
    `StartDate`,
    `EndDate`,
    `ReasonToEnded`,
    `CompanyName`,
    `CreatedBy`
  )
VALUES
  (
    57,
    'PRO000094',
    'Nicole Rudd, LCPC',
    'CON000031',
    'Covita Mills',
    '1',
    '2020-12-01',
    NULL,
    '',
    'Billing Plus, Inc.',
    'Ismith01'
  );
INSERT INTO
  `assigned_contractor_table` (
    `Id`,
    `ProvId`,
    `ProviderName`,
    `ConId`,
    `ContractorName`,
    `PayRate`,
    `StartDate`,
    `EndDate`,
    `ReasonToEnded`,
    `CompanyName`,
    `CreatedBy`
  )
VALUES
  (
    58,
    'PRO000095',
    'Carla D. Washington, LPC',
    'CON000030',
    'Tabitha Contee',
    '4.5',
    '2015-06-01',
    NULL,
    '',
    'Billing Plus, Inc.',
    'Ismith01'
  );
INSERT INTO
  `assigned_contractor_table` (
    `Id`,
    `ProvId`,
    `ProviderName`,
    `ConId`,
    `ContractorName`,
    `PayRate`,
    `StartDate`,
    `EndDate`,
    `ReasonToEnded`,
    `CompanyName`,
    `CreatedBy`
  )
VALUES
  (
    59,
    'PRO000096',
    'Donna Reid Washington, LPC',
    'CON000030',
    'Tabitha Contee',
    '4.5',
    '2015-05-01',
    NULL,
    '',
    'Billing Plus, Inc.',
    'Ismith01'
  );
INSERT INTO
  `assigned_contractor_table` (
    `Id`,
    `ProvId`,
    `ProviderName`,
    `ConId`,
    `ContractorName`,
    `PayRate`,
    `StartDate`,
    `EndDate`,
    `ReasonToEnded`,
    `CompanyName`,
    `CreatedBy`
  )
VALUES
  (
    60,
    'PRO000097',
    'Dr. Jamila Winn ',
    'CON000031',
    'Covita Mills',
    '1',
    '2021-01-01',
    '2021-01-19',
    'Provider Terminated Agreement',
    'Billing Plus, Inc.',
    'Ismith01'
  );
INSERT INTO
  `assigned_contractor_table` (
    `Id`,
    `ProvId`,
    `ProviderName`,
    `ConId`,
    `ContractorName`,
    `PayRate`,
    `StartDate`,
    `EndDate`,
    `ReasonToEnded`,
    `CompanyName`,
    `CreatedBy`
  )
VALUES
  (
    61,
    'PRO000098',
    'Tammy Miller, Ph.D',
    'CON000031',
    'Covita Mills',
    '1',
    '2021-01-01',
    '2021-01-15',
    'Provider Terminated Agreement',
    'Billing Plus, Inc.',
    'Ismith01'
  );
INSERT INTO
  `assigned_contractor_table` (
    `Id`,
    `ProvId`,
    `ProviderName`,
    `ConId`,
    `ContractorName`,
    `PayRate`,
    `StartDate`,
    `EndDate`,
    `ReasonToEnded`,
    `CompanyName`,
    `CreatedBy`
  )
VALUES
  (
    62,
    'PRO000099',
    'Winnie Moore, LCPC',
    'CON000030',
    'Tabitha Contee',
    '4.5',
    '2018-06-01',
    NULL,
    '',
    'Billing Plus, Inc.',
    'Ismith01'
  );
INSERT INTO
  `assigned_contractor_table` (
    `Id`,
    `ProvId`,
    `ProviderName`,
    `ConId`,
    `ContractorName`,
    `PayRate`,
    `StartDate`,
    `EndDate`,
    `ReasonToEnded`,
    `CompanyName`,
    `CreatedBy`
  )
VALUES
  (
    63,
    'PRO000099',
    'Winnie Moore, LCPC',
    'CON000032',
    'Sanora Wicker',
    '2',
    '2021-05-17',
    NULL,
    '',
    'Billing Plus, Inc.',
    'Ismith01'
  );
INSERT INTO
  `assigned_contractor_table` (
    `Id`,
    `ProvId`,
    `ProviderName`,
    `ConId`,
    `ContractorName`,
    `PayRate`,
    `StartDate`,
    `EndDate`,
    `ReasonToEnded`,
    `CompanyName`,
    `CreatedBy`
  )
VALUES
  (
    64,
    'PRO000100',
    'Alpha and Omega Health and Wellness Center',
    'CON000030',
    'Tabitha Contee',
    '4.5',
    '2020-01-01',
    NULL,
    '',
    'Billing Plus, Inc.',
    'Ismith01'
  );
INSERT INTO
  `assigned_contractor_table` (
    `Id`,
    `ProvId`,
    `ProviderName`,
    `ConId`,
    `ContractorName`,
    `PayRate`,
    `StartDate`,
    `EndDate`,
    `ReasonToEnded`,
    `CompanyName`,
    `CreatedBy`
  )
VALUES
  (
    65,
    'PRO000101',
    'Wanda D. Smith, LCSW-C',
    'CON000031',
    'Covita Mills',
    '1',
    '2020-12-01',
    NULL,
    '',
    'Billing Plus, Inc.',
    'Ismith01'
  );
INSERT INTO
  `assigned_contractor_table` (
    `Id`,
    `ProvId`,
    `ProviderName`,
    `ConId`,
    `ContractorName`,
    `PayRate`,
    `StartDate`,
    `EndDate`,
    `ReasonToEnded`,
    `CompanyName`,
    `CreatedBy`
  )
VALUES
  (
    66,
    'PRO000102',
    'Veronica Watkins, LCSW-C',
    'CON000030',
    'Tabitha Contee',
    '4.5',
    '2020-12-01',
    NULL,
    '',
    'Billing Plus, Inc.',
    'admin'
  );
INSERT INTO
  `assigned_contractor_table` (
    `Id`,
    `ProvId`,
    `ProviderName`,
    `ConId`,
    `ContractorName`,
    `PayRate`,
    `StartDate`,
    `EndDate`,
    `ReasonToEnded`,
    `CompanyName`,
    `CreatedBy`
  )
VALUES
  (
    67,
    'PRO000072',
    'Winnie Moore, LCPC',
    'CON000022',
    'Fahad Razzaq',
    '2',
    '2020-02-11',
    NULL,
    '',
    'ABC COMPANY PVT LTD',
    'admin'
  );
INSERT INTO
  `assigned_contractor_table` (
    `Id`,
    `ProvId`,
    `ProviderName`,
    `ConId`,
    `ContractorName`,
    `PayRate`,
    `StartDate`,
    `EndDate`,
    `ReasonToEnded`,
    `CompanyName`,
    `CreatedBy`
  )
VALUES
  (
    68,
    'PRO000103',
    'Base Payment',
    'CON000030',
    'Tabitha Contee',
    '100',
    '2020-12-31',
    NULL,
    '',
    'Billing Plus, Inc.',
    'Ismith01'
  );
INSERT INTO
  `assigned_contractor_table` (
    `Id`,
    `ProvId`,
    `ProviderName`,
    `ConId`,
    `ContractorName`,
    `PayRate`,
    `StartDate`,
    `EndDate`,
    `ReasonToEnded`,
    `CompanyName`,
    `CreatedBy`
  )
VALUES
  (
    69,
    'PRO000103',
    'Base Payment',
    'CON000031',
    'Covita Mills',
    '100',
    '2021-08-16',
    NULL,
    '',
    'Billing Plus, Inc.',
    'Ismith01'
  );
INSERT INTO
  `assigned_contractor_table` (
    `Id`,
    `ProvId`,
    `ProviderName`,
    `ConId`,
    `ContractorName`,
    `PayRate`,
    `StartDate`,
    `EndDate`,
    `ReasonToEnded`,
    `CompanyName`,
    `CreatedBy`
  )
VALUES
  (
    70,
    'PRO000074',
    'Demo Provider',
    'CON000022',
    'Fahad Razzaq',
    '2',
    '2010-07-23',
    NULL,
    '',
    'ABC COMPANY PVT LTD',
    'admin'
  );
INSERT INTO
  `assigned_contractor_table` (
    `Id`,
    `ProvId`,
    `ProviderName`,
    `ConId`,
    `ContractorName`,
    `PayRate`,
    `StartDate`,
    `EndDate`,
    `ReasonToEnded`,
    `CompanyName`,
    `CreatedBy`
  )
VALUES
  (
    71,
    'PRO000104',
    'Base Pay Provider',
    'CON000022',
    'Fahad Razzaq',
    '250.00',
    '2021-01-01',
    NULL,
    '',
    'ABC COMPANY PVT LTD',
    'admin'
  );
INSERT INTO
  `assigned_contractor_table` (
    `Id`,
    `ProvId`,
    `ProviderName`,
    `ConId`,
    `ContractorName`,
    `PayRate`,
    `StartDate`,
    `EndDate`,
    `ReasonToEnded`,
    `CompanyName`,
    `CreatedBy`
  )
VALUES
  (
    72,
    'PRO000103',
    'Base Payment',
    'CON000032',
    'Sanora Wicker',
    '100',
    '2021-05-17',
    NULL,
    '',
    'Billing Plus, Inc.',
    'Ismith01'
  );
INSERT INTO
  `assigned_contractor_table` (
    `Id`,
    `ProvId`,
    `ProviderName`,
    `ConId`,
    `ContractorName`,
    `PayRate`,
    `StartDate`,
    `EndDate`,
    `ReasonToEnded`,
    `CompanyName`,
    `CreatedBy`
  )
VALUES
  (
    73,
    'PRO000103',
    'Base Payment',
    'CON000033',
    'Javon Young',
    '100',
    '2021-07-07',
    NULL,
    '',
    'Billing Plus, Inc.',
    'Ismith01'
  );
INSERT INTO
  `assigned_contractor_table` (
    `Id`,
    `ProvId`,
    `ProviderName`,
    `ConId`,
    `ContractorName`,
    `PayRate`,
    `StartDate`,
    `EndDate`,
    `ReasonToEnded`,
    `CompanyName`,
    `CreatedBy`
  )
VALUES
  (
    74,
    'PRO000085',
    'Yetta Lyle, LCPC',
    'CON000032',
    'Sanora Wicker',
    '2',
    '2021-05-17',
    NULL,
    '',
    'Billing Plus, Inc.',
    'Ismith01'
  );
INSERT INTO
  `assigned_contractor_table` (
    `Id`,
    `ProvId`,
    `ProviderName`,
    `ConId`,
    `ContractorName`,
    `PayRate`,
    `StartDate`,
    `EndDate`,
    `ReasonToEnded`,
    `CompanyName`,
    `CreatedBy`
  )
VALUES
  (
    75,
    'PRO000105',
    'Dalton Johnson, LCPC',
    'CON000033',
    'Javon Young',
    '4',
    '2021-09-01',
    NULL,
    '',
    'Billing Plus, Inc.',
    'Ismith01'
  );
INSERT INTO
  `assigned_contractor_table` (
    `Id`,
    `ProvId`,
    `ProviderName`,
    `ConId`,
    `ContractorName`,
    `PayRate`,
    `StartDate`,
    `EndDate`,
    `ReasonToEnded`,
    `CompanyName`,
    `CreatedBy`
  )
VALUES
  (
    76,
    'PRO000103',
    'Base Monthly',
    'CON000034',
    'Tiffany Lee',
    '100',
    '2021-09-15',
    NULL,
    '',
    'Billing Plus, Inc.',
    'Ismith01'
  );

# ------------------------------------------------------------
# DATA DUMP FOR TABLE: collection_table
# ------------------------------------------------------------

INSERT INTO
  `collection_table` (
    `Id`,
    `Date`,
    `EmpId`,
    `EmpName`,
    `CusId`,
    `CusName`,
    `CollectionAmount`,
    `Rate`,
    `Commission`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    36,
    'May 2021',
    'EMP000017',
    'Anura Kumara',
    'CUS000047',
    'maduranga-updated',
    20000.00,
    '10',
    2000.00,
    'Invoiced',
    'anurak',
    'RapidGnix'
  );
INSERT INTO
  `collection_table` (
    `Id`,
    `Date`,
    `EmpId`,
    `EmpName`,
    `CusId`,
    `CusName`,
    `CollectionAmount`,
    `Rate`,
    `Commission`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    37,
    'May 2021',
    'EMP000017',
    'Anura Kumara',
    'CUS000047',
    'maduranga-upda',
    12000.00,
    '12',
    1440.00,
    'Invoiced',
    'anurak',
    'RapidGnix'
  );
INSERT INTO
  `collection_table` (
    `Id`,
    `Date`,
    `EmpId`,
    `EmpName`,
    `CusId`,
    `CusName`,
    `CollectionAmount`,
    `Rate`,
    `Commission`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    38,
    'May 2021',
    'EMP000017',
    'Anura Kumara',
    'CUS000047',
    'maduranga-up',
    1200.00,
    '200',
    2400.00,
    'Invoiced',
    'anurak',
    'RapidGnix'
  );
INSERT INTO
  `collection_table` (
    `Id`,
    `Date`,
    `EmpId`,
    `EmpName`,
    `CusId`,
    `CusName`,
    `CollectionAmount`,
    `Rate`,
    `Commission`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    39,
    'Apr 2021',
    'EMP000017',
    'Anura Kumara',
    'CUS000047',
    'maduranga-updated',
    5000.00,
    '23',
    1150.00,
    'Invoiced',
    'anurak',
    'RapidGnix'
  );
INSERT INTO
  `collection_table` (
    `Id`,
    `Date`,
    `EmpId`,
    `EmpName`,
    `CusId`,
    `CusName`,
    `CollectionAmount`,
    `Rate`,
    `Commission`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    40,
    'Apr 2021',
    'EMP000017',
    'Anura Kumara',
    'CUS000047',
    'maduranga-updated',
    50000.00,
    '3',
    1500.00,
    'Invoiced',
    'anurak',
    'RapidGnix'
  );
INSERT INTO
  `collection_table` (
    `Id`,
    `Date`,
    `EmpId`,
    `EmpName`,
    `CusId`,
    `CusName`,
    `CollectionAmount`,
    `Rate`,
    `Commission`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    41,
    '2021-05-25',
    'EMP000017',
    'Anura Kumara',
    'CUS000047',
    'maduranga-updated',
    60000.00,
    '23',
    13800.00,
    'Not Invoiced',
    'admin',
    'RapidGnix'
  );
INSERT INTO
  `collection_table` (
    `Id`,
    `Date`,
    `EmpId`,
    `EmpName`,
    `CusId`,
    `CusName`,
    `CollectionAmount`,
    `Rate`,
    `Commission`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    42,
    'Jun 2021',
    'EMP000017',
    'Anura Kumara',
    'CUS000047',
    'maduranga-updated',
    45000.00,
    '6',
    2700.00,
    'Not Invoiced',
    'anurak',
    'RapidGnix'
  );
INSERT INTO
  `collection_table` (
    `Id`,
    `Date`,
    `EmpId`,
    `EmpName`,
    `CusId`,
    `CusName`,
    `CollectionAmount`,
    `Rate`,
    `Commission`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    43,
    'May 2021',
    'EMP000017',
    'Anura Kumara',
    'CUS000047',
    'maduranga-updated',
    230006.00,
    '9',
    20700.54,
    'Not Invoiced',
    'anurak',
    'RapidGnix'
  );
INSERT INTO
  `collection_table` (
    `Id`,
    `Date`,
    `EmpId`,
    `EmpName`,
    `CusId`,
    `CusName`,
    `CollectionAmount`,
    `Rate`,
    `Commission`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    44,
    'May 2021',
    'EMP000019',
    'Banuka perera',
    'CUS000047',
    'maduranga-updated',
    12000.00,
    '12',
    1440.00,
    'Invoiced',
    'banukap',
    'ABC COMPANY PVT LTD'
  );
INSERT INTO
  `collection_table` (
    `Id`,
    `Date`,
    `EmpId`,
    `EmpName`,
    `CusId`,
    `CusName`,
    `CollectionAmount`,
    `Rate`,
    `Commission`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    46,
    'May 2021',
    'CON000022',
    'Fahad Razzaq',
    'CUS000065',
    'Ronald Jefferson',
    4000.00,
    '2',
    80.00,
    'Invoiced',
    'Fahad',
    'ABC COMPANY PVT LTD'
  );
INSERT INTO
  `collection_table` (
    `Id`,
    `Date`,
    `EmpId`,
    `EmpName`,
    `CusId`,
    `CusName`,
    `CollectionAmount`,
    `Rate`,
    `Commission`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    49,
    'May 2021',
    'EMP000019',
    'Banuka perera',
    'CUS000065',
    'Ronald Jefferson',
    200000.00,
    '3',
    6000.00,
    'Invoiced',
    'banukap',
    'ABC COMPANY PVT LTD'
  );
INSERT INTO
  `collection_table` (
    `Id`,
    `Date`,
    `EmpId`,
    `EmpName`,
    `CusId`,
    `CusName`,
    `CollectionAmount`,
    `Rate`,
    `Commission`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    50,
    'May 2021',
    'EMP000019',
    'Banuka perera',
    'CUS000065',
    'Ronald Jefferson',
    40000.00,
    '3',
    1200.00,
    'Invoiced',
    'banukap',
    'ABC COMPANY PVT LTD'
  );
INSERT INTO
  `collection_table` (
    `Id`,
    `Date`,
    `EmpId`,
    `EmpName`,
    `CusId`,
    `CusName`,
    `CollectionAmount`,
    `Rate`,
    `Commission`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    51,
    'May 2021',
    'EMP000019',
    'Banuka perera',
    'CUS000065',
    'Ronald Jefferson',
    12000.00,
    '3',
    360.00,
    'Invoiced',
    'banukap',
    'ABC COMPANY PVT LTD'
  );
INSERT INTO
  `collection_table` (
    `Id`,
    `Date`,
    `EmpId`,
    `EmpName`,
    `CusId`,
    `CusName`,
    `CollectionAmount`,
    `Rate`,
    `Commission`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    52,
    'May 2021',
    'EMP000019',
    'Banuka perera',
    'CUS000065',
    'Ronald Jefferson',
    90000.00,
    '3',
    2700.00,
    'Invoiced',
    'banukap',
    'ABC COMPANY PVT LTD'
  );
INSERT INTO
  `collection_table` (
    `Id`,
    `Date`,
    `EmpId`,
    `EmpName`,
    `CusId`,
    `CusName`,
    `CollectionAmount`,
    `Rate`,
    `Commission`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    53,
    'May 2021',
    'EMP000019',
    'Banuka perera',
    'CUS000065',
    'Ronald Jefferson',
    50000.00,
    '3',
    1500.00,
    'Invoiced',
    'banukap',
    'ABC COMPANY PVT LTD'
  );
INSERT INTO
  `collection_table` (
    `Id`,
    `Date`,
    `EmpId`,
    `EmpName`,
    `CusId`,
    `CusName`,
    `CollectionAmount`,
    `Rate`,
    `Commission`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    54,
    'Jun 2021',
    'EMP000019',
    'Banuka perera',
    'CUS000065',
    'Ronald Jefferson',
    400000.00,
    '3',
    12000.00,
    'Invoiced',
    'banukap',
    'ABC COMPANY PVT LTD'
  );
INSERT INTO
  `collection_table` (
    `Id`,
    `Date`,
    `EmpId`,
    `EmpName`,
    `CusId`,
    `CusName`,
    `CollectionAmount`,
    `Rate`,
    `Commission`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    55,
    'May 2021',
    'EMP000019',
    'Banuka perera',
    'CUS000065',
    'Ronald Jefferson',
    37500.00,
    '3',
    1125.00,
    'Invoiced',
    'banukap',
    'ABC COMPANY PVT LTD'
  );
INSERT INTO
  `collection_table` (
    `Id`,
    `Date`,
    `EmpId`,
    `EmpName`,
    `CusId`,
    `CusName`,
    `CollectionAmount`,
    `Rate`,
    `Commission`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    58,
    'Jun 2021',
    'EMP000019',
    'Banuka perera',
    'CUS000065',
    'Ronald Jefferson',
    235000.00,
    '3%',
    7050.00,
    'Invoiced',
    'banukap',
    'ABC COMPANY PVT LTD'
  );
INSERT INTO
  `collection_table` (
    `Id`,
    `Date`,
    `EmpId`,
    `EmpName`,
    `CusId`,
    `CusName`,
    `CollectionAmount`,
    `Rate`,
    `Commission`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    61,
    'Jun 2021',
    'CON000026',
    'Nalaka Bandara',
    'CUS000066',
    'Asela Gunarathne',
    120000.00,
    '5%',
    6000.00,
    'Invoiced',
    'nalakab',
    'Novar Flex Pvt Ltd'
  );
INSERT INTO
  `collection_table` (
    `Id`,
    `Date`,
    `EmpId`,
    `EmpName`,
    `CusId`,
    `CusName`,
    `CollectionAmount`,
    `Rate`,
    `Commission`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    62,
    'Jun 2021',
    'CON000026',
    'Nalaka Bandara',
    'CUS000066',
    'Asela Gunarathne',
    3000.00,
    '5%',
    150.00,
    'Invoiced',
    'nalakab',
    'Novar Flex Pvt Ltd'
  );
INSERT INTO
  `collection_table` (
    `Id`,
    `Date`,
    `EmpId`,
    `EmpName`,
    `CusId`,
    `CusName`,
    `CollectionAmount`,
    `Rate`,
    `Commission`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    63,
    'Jun 2021',
    'CON000026',
    'Nalaka Bandara',
    'CUS000066',
    'Asela Gunarathne',
    60000.00,
    '5%',
    3000.00,
    'Invoiced',
    'nalakab',
    'Novar Flex Pvt Ltd'
  );
INSERT INTO
  `collection_table` (
    `Id`,
    `Date`,
    `EmpId`,
    `EmpName`,
    `CusId`,
    `CusName`,
    `CollectionAmount`,
    `Rate`,
    `Commission`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    64,
    'Jun 2021',
    'CON000026',
    'Nalaka Bandara',
    'CUS000066',
    'Asela Gunarathne',
    40000.00,
    '5%',
    2000.00,
    'Invoiced',
    'nalakab',
    'Novar Flex Pvt Ltd'
  );
INSERT INTO
  `collection_table` (
    `Id`,
    `Date`,
    `EmpId`,
    `EmpName`,
    `CusId`,
    `CusName`,
    `CollectionAmount`,
    `Rate`,
    `Commission`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    65,
    'Jun 2021',
    'CON000026',
    'Nalaka Bandara',
    'CUS000066',
    'Asela Gunarathne',
    320000.00,
    '5%',
    16000.00,
    'Not Invoiced',
    'nalakab',
    'Novar Flex Pvt Ltd'
  );
INSERT INTO
  `collection_table` (
    `Id`,
    `Date`,
    `EmpId`,
    `EmpName`,
    `CusId`,
    `CusName`,
    `CollectionAmount`,
    `Rate`,
    `Commission`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    66,
    'Jun 2021',
    'CON000026',
    'Nalaka Bandara',
    'CUS000066',
    'Asela Gunarathne',
    50000.00,
    '5%',
    2500.00,
    'Not Invoiced',
    'nalakab',
    'Novar Flex Pvt Ltd'
  );
INSERT INTO
  `collection_table` (
    `Id`,
    `Date`,
    `EmpId`,
    `EmpName`,
    `CusId`,
    `CusName`,
    `CollectionAmount`,
    `Rate`,
    `Commission`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    67,
    'Jun 2021',
    'CON000026',
    'Nalaka Bandara',
    'CUS000066',
    'Asela Gunarathne',
    40000.00,
    '5%',
    2000.00,
    'Not Invoiced',
    'nalakab',
    'Novar Flex Pvt Ltd'
  );
INSERT INTO
  `collection_table` (
    `Id`,
    `Date`,
    `EmpId`,
    `EmpName`,
    `CusId`,
    `CusName`,
    `CollectionAmount`,
    `Rate`,
    `Commission`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    68,
    'Jun 2021',
    'CON000026',
    'Nalaka Bandara',
    'CUS000066',
    'Asela Gunarathne',
    10000.00,
    '5%',
    500.00,
    'Not Invoiced',
    'nalakab',
    'Novar Flex Pvt Ltd'
  );
INSERT INTO
  `collection_table` (
    `Id`,
    `Date`,
    `EmpId`,
    `EmpName`,
    `CusId`,
    `CusName`,
    `CollectionAmount`,
    `Rate`,
    `Commission`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    69,
    'Jun 2021',
    'CON000026',
    'Nalaka Bandara',
    'CUS000066',
    'Asela Gunarathne',
    64000.00,
    '5%',
    3200.00,
    'Not Invoiced',
    'nalakab',
    'Novar Flex Pvt Ltd'
  );
INSERT INTO
  `collection_table` (
    `Id`,
    `Date`,
    `EmpId`,
    `EmpName`,
    `CusId`,
    `CusName`,
    `CollectionAmount`,
    `Rate`,
    `Commission`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    70,
    'Aug 2021',
    'EMP000019',
    'Banuka perera',
    'CUS000065',
    'Ronald Jefferson',
    30000.00,
    '3%',
    900.00,
    'Invoiced',
    'banukap',
    'ABC COMPANY PVT LTD'
  );
INSERT INTO
  `collection_table` (
    `Id`,
    `Date`,
    `EmpId`,
    `EmpName`,
    `CusId`,
    `CusName`,
    `CollectionAmount`,
    `Rate`,
    `Commission`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    77,
    'Nov 2020',
    'CON000030',
    'Tabitha Contee',
    'PRO000092',
    'Apex - Bharat Vallurapalli, MS, OTR/L',
    2213.95,
    '4.5',
    99.63,
    'Not Invoiced',
    'tconteeinvoices',
    'Billing Plus, Inc.'
  );
INSERT INTO
  `collection_table` (
    `Id`,
    `Date`,
    `EmpId`,
    `EmpName`,
    `CusId`,
    `CusName`,
    `CollectionAmount`,
    `Rate`,
    `Commission`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    78,
    'Nov 2020',
    'CON000030',
    'Tabitha Contee',
    'PRO000093',
    'DC HT - Bharat Vallurapalli, MS, OTR/L',
    1855.78,
    '4.5',
    83.51,
    'Not Invoiced',
    'tconteeinvoices',
    'Billing Plus, Inc.'
  );
INSERT INTO
  `collection_table` (
    `Id`,
    `Date`,
    `EmpId`,
    `EmpName`,
    `CusId`,
    `CusName`,
    `CollectionAmount`,
    `Rate`,
    `Commission`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    79,
    'Nov 2020',
    'CON000030',
    'Tabitha Contee',
    'PRO000087',
    'Joy R. Hart, LCSW-C',
    9920.85,
    '4.5',
    446.44,
    'Not Invoiced',
    'tconteeinvoices',
    'Billing Plus, Inc.'
  );
INSERT INTO
  `collection_table` (
    `Id`,
    `Date`,
    `EmpId`,
    `EmpName`,
    `CusId`,
    `CusName`,
    `CollectionAmount`,
    `Rate`,
    `Commission`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    80,
    'Nov 2020',
    'CON000030',
    'Tabitha Contee',
    'PRO000095',
    'Carla D. Washington, LPC',
    16950.54,
    '4.5',
    762.77,
    'Not Invoiced',
    'tconteeinvoices',
    'Billing Plus, Inc.'
  );
INSERT INTO
  `collection_table` (
    `Id`,
    `Date`,
    `EmpId`,
    `EmpName`,
    `CusId`,
    `CusName`,
    `CollectionAmount`,
    `Rate`,
    `Commission`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    81,
    'Nov 2020',
    'CON000030',
    'Tabitha Contee',
    'PRO000099',
    'Winnie Moore, LCPC',
    16952.70,
    '4.5',
    762.87,
    'Not Invoiced',
    'tconteeinvoices',
    'Billing Plus, Inc.'
  );
INSERT INTO
  `collection_table` (
    `Id`,
    `Date`,
    `EmpId`,
    `EmpName`,
    `CusId`,
    `CusName`,
    `CollectionAmount`,
    `Rate`,
    `Commission`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    82,
    'Nov 2020',
    'CON000030',
    'Tabitha Contee',
    'PRO000102',
    'Veronica Watkins, LCSW-C',
    6246.34,
    '4.5',
    281.09,
    'Not Invoiced',
    'tconteeinvoices',
    'Billing Plus, Inc.'
  );
INSERT INTO
  `collection_table` (
    `Id`,
    `Date`,
    `EmpId`,
    `EmpName`,
    `CusId`,
    `CusName`,
    `CollectionAmount`,
    `Rate`,
    `Commission`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    83,
    'Dec 2020',
    'CON000030',
    'Tabitha Contee',
    'PRO000092',
    'Apex - Bharat Vallurapalli, MS, OTR/L',
    5577.22,
    '4.5',
    250.97,
    'Not Invoiced',
    'tconteeinvoices',
    'Billing Plus, Inc.'
  );
INSERT INTO
  `collection_table` (
    `Id`,
    `Date`,
    `EmpId`,
    `EmpName`,
    `CusId`,
    `CusName`,
    `CollectionAmount`,
    `Rate`,
    `Commission`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    84,
    'Dec 2020',
    'CON000030',
    'Tabitha Contee',
    'PRO000102',
    'Veronica Watkins, LCSW-C',
    8322.12,
    '4.5',
    374.50,
    'Not Invoiced',
    'tconteeinvoices',
    'Billing Plus, Inc.'
  );
INSERT INTO
  `collection_table` (
    `Id`,
    `Date`,
    `EmpId`,
    `EmpName`,
    `CusId`,
    `CusName`,
    `CollectionAmount`,
    `Rate`,
    `Commission`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    85,
    'Dec 2020',
    'CON000030',
    'Tabitha Contee',
    'PRO000087',
    'Joy R. Hart, LCSW-C',
    7607.42,
    '4.5',
    342.33,
    'Not Invoiced',
    'tconteeinvoices',
    'Billing Plus, Inc.'
  );
INSERT INTO
  `collection_table` (
    `Id`,
    `Date`,
    `EmpId`,
    `EmpName`,
    `CusId`,
    `CusName`,
    `CollectionAmount`,
    `Rate`,
    `Commission`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    86,
    'Dec 2020',
    'CON000030',
    'Tabitha Contee',
    'PRO000095',
    'Carla D. Washington, LPC',
    17329.25,
    '4.5',
    779.82,
    'Not Invoiced',
    'tconteeinvoices',
    'Billing Plus, Inc.'
  );
INSERT INTO
  `collection_table` (
    `Id`,
    `Date`,
    `EmpId`,
    `EmpName`,
    `CusId`,
    `CusName`,
    `CollectionAmount`,
    `Rate`,
    `Commission`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    87,
    'Dec 2020',
    'CON000030',
    'Tabitha Contee',
    'PRO000099',
    'Winnie Moore, LCPC',
    11710.81,
    '4.5',
    526.99,
    'Not Invoiced',
    'tconteeinvoices',
    'Billing Plus, Inc.'
  );
INSERT INTO
  `collection_table` (
    `Id`,
    `Date`,
    `EmpId`,
    `EmpName`,
    `CusId`,
    `CusName`,
    `CollectionAmount`,
    `Rate`,
    `Commission`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    88,
    'Dec 2020',
    'CON000030',
    'Tabitha Contee',
    'PRO000100',
    'Alpha and Omega Health and Wellness Center',
    6834.22,
    '4.5',
    307.54,
    'Not Invoiced',
    'tconteeinvoices',
    'Billing Plus, Inc.'
  );
INSERT INTO
  `collection_table` (
    `Id`,
    `Date`,
    `EmpId`,
    `EmpName`,
    `CusId`,
    `CusName`,
    `CollectionAmount`,
    `Rate`,
    `Commission`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    89,
    'Jan 2021',
    'CON000030',
    'Tabitha Contee',
    'PRO000092',
    'Apex - Bharat Vallurapalli, MS, OTR/L',
    7229.81,
    '4.5',
    325.34,
    'Invoiced',
    'tconteeinvoices',
    'Billing Plus, Inc.'
  );
INSERT INTO
  `collection_table` (
    `Id`,
    `Date`,
    `EmpId`,
    `EmpName`,
    `CusId`,
    `CusName`,
    `CollectionAmount`,
    `Rate`,
    `Commission`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    90,
    'Jan 2021',
    'CON000030',
    'Tabitha Contee',
    'PRO000102',
    'Veronica Watkins, LCSW-C',
    5654.86,
    '4.5',
    254.47,
    'Invoiced',
    'tconteeinvoices',
    'Billing Plus, Inc.'
  );
INSERT INTO
  `collection_table` (
    `Id`,
    `Date`,
    `EmpId`,
    `EmpName`,
    `CusId`,
    `CusName`,
    `CollectionAmount`,
    `Rate`,
    `Commission`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    91,
    'Jan 2021',
    'CON000030',
    'Tabitha Contee',
    'PRO000087',
    'Joy R. Hart, LCSW-C',
    8942.59,
    '4.5',
    402.42,
    'Invoiced',
    'tconteeinvoices',
    'Billing Plus, Inc.'
  );
INSERT INTO
  `collection_table` (
    `Id`,
    `Date`,
    `EmpId`,
    `EmpName`,
    `CusId`,
    `CusName`,
    `CollectionAmount`,
    `Rate`,
    `Commission`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    92,
    'Jan 2021',
    'CON000030',
    'Tabitha Contee',
    'PRO000095',
    'Carla D. Washington, LPC',
    21406.93,
    '4.5',
    963.31,
    'Invoiced',
    'tconteeinvoices',
    'Billing Plus, Inc.'
  );
INSERT INTO
  `collection_table` (
    `Id`,
    `Date`,
    `EmpId`,
    `EmpName`,
    `CusId`,
    `CusName`,
    `CollectionAmount`,
    `Rate`,
    `Commission`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    93,
    'Jan 2021',
    'CON000030',
    'Tabitha Contee',
    'PRO000099',
    'Winnie Moore, LCPC',
    14796.03,
    '4.5',
    665.82,
    'Invoiced',
    'tconteeinvoices',
    'Billing Plus, Inc.'
  );
INSERT INTO
  `collection_table` (
    `Id`,
    `Date`,
    `EmpId`,
    `EmpName`,
    `CusId`,
    `CusName`,
    `CollectionAmount`,
    `Rate`,
    `Commission`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    94,
    'Jan 2021',
    'CON000030',
    'Tabitha Contee',
    'PRO000100',
    'Alpha and Omega Health and Wellness Center',
    226.20,
    '4.5',
    10.18,
    'Invoiced',
    'tconteeinvoices',
    'Billing Plus, Inc.'
  );
INSERT INTO
  `collection_table` (
    `Id`,
    `Date`,
    `EmpId`,
    `EmpName`,
    `CusId`,
    `CusName`,
    `CollectionAmount`,
    `Rate`,
    `Commission`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    95,
    'Jan 2021',
    'CON000030',
    'Tabitha Contee',
    'PRO000096',
    'Donna Reid Washington, LPC',
    6995.37,
    '4.5',
    314.79,
    'Invoiced',
    'tconteeinvoices',
    'Billing Plus, Inc.'
  );
INSERT INTO
  `collection_table` (
    `Id`,
    `Date`,
    `EmpId`,
    `EmpName`,
    `CusId`,
    `CusName`,
    `CollectionAmount`,
    `Rate`,
    `Commission`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    96,
    'Feb 2021',
    'CON000030',
    'Tabitha Contee',
    'PRO000092',
    'Apex - Bharat Vallurapalli, MS, OTR/L',
    2497.50,
    '4.5',
    112.39,
    'Not Invoiced',
    'tconteeinvoices',
    'Billing Plus, Inc.'
  );
INSERT INTO
  `collection_table` (
    `Id`,
    `Date`,
    `EmpId`,
    `EmpName`,
    `CusId`,
    `CusName`,
    `CollectionAmount`,
    `Rate`,
    `Commission`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    97,
    'Feb 2021',
    'CON000030',
    'Tabitha Contee',
    'PRO000093',
    'DC HT - Bharat Vallurapalli, MS, OTR/L',
    1733.82,
    '4.5',
    78.02,
    'Not Invoiced',
    'tconteeinvoices',
    'Billing Plus, Inc.'
  );
INSERT INTO
  `collection_table` (
    `Id`,
    `Date`,
    `EmpId`,
    `EmpName`,
    `CusId`,
    `CusName`,
    `CollectionAmount`,
    `Rate`,
    `Commission`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    98,
    'Feb 2021',
    'CON000030',
    'Tabitha Contee',
    'PRO000102',
    'Veronica Watkins, LCSW-C',
    4477.93,
    '4.5',
    201.51,
    'Not Invoiced',
    'tconteeinvoices',
    'Billing Plus, Inc.'
  );
INSERT INTO
  `collection_table` (
    `Id`,
    `Date`,
    `EmpId`,
    `EmpName`,
    `CusId`,
    `CusName`,
    `CollectionAmount`,
    `Rate`,
    `Commission`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    99,
    'Feb 2021',
    'CON000030',
    'Tabitha Contee',
    'PRO000087',
    'Joy R. Hart, LCSW-C',
    9518.75,
    '4.5',
    428.34,
    'Not Invoiced',
    'tconteeinvoices',
    'Billing Plus, Inc.'
  );
INSERT INTO
  `collection_table` (
    `Id`,
    `Date`,
    `EmpId`,
    `EmpName`,
    `CusId`,
    `CusName`,
    `CollectionAmount`,
    `Rate`,
    `Commission`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    100,
    'Feb 2021',
    'CON000030',
    'Tabitha Contee',
    'PRO000095',
    'Carla D. Washington, LPC',
    17401.40,
    '4.5',
    783.06,
    'Not Invoiced',
    'tconteeinvoices',
    'Billing Plus, Inc.'
  );
INSERT INTO
  `collection_table` (
    `Id`,
    `Date`,
    `EmpId`,
    `EmpName`,
    `CusId`,
    `CusName`,
    `CollectionAmount`,
    `Rate`,
    `Commission`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    101,
    'Feb 2021',
    'CON000030',
    'Tabitha Contee',
    'PRO000099',
    'Winnie Moore, LCPC',
    12376.97,
    '4.5',
    556.96,
    'Not Invoiced',
    'tconteeinvoices',
    'Billing Plus, Inc.'
  );
INSERT INTO
  `collection_table` (
    `Id`,
    `Date`,
    `EmpId`,
    `EmpName`,
    `CusId`,
    `CusName`,
    `CollectionAmount`,
    `Rate`,
    `Commission`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    102,
    'Feb 2021',
    'CON000030',
    'Tabitha Contee',
    'PRO000096',
    'Donna Reid Washington, LPC',
    7913.94,
    '4.5',
    356.13,
    'Not Invoiced',
    'tconteeinvoices',
    'Billing Plus, Inc.'
  );
INSERT INTO
  `collection_table` (
    `Id`,
    `Date`,
    `EmpId`,
    `EmpName`,
    `CusId`,
    `CusName`,
    `CollectionAmount`,
    `Rate`,
    `Commission`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    103,
    'Nov 2020',
    'CON000031',
    'Covita Mills',
    'PRO000083',
    'Samantha Knox, LPC',
    4652.59,
    '1',
    46.53,
    'Not Invoiced',
    'cmillsinvoices',
    'Billing Plus, Inc.'
  );
INSERT INTO
  `collection_table` (
    `Id`,
    `Date`,
    `EmpId`,
    `EmpName`,
    `CusId`,
    `CusName`,
    `CollectionAmount`,
    `Rate`,
    `Commission`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    104,
    'Nov 2020',
    'CON000031',
    'Covita Mills',
    'PRO000079',
    'Onyx Therapy Group - Dr. LaNail Plummer',
    26262.67,
    '1',
    262.63,
    'Not Invoiced',
    'cmillsinvoices',
    'Billing Plus, Inc.'
  );
INSERT INTO
  `collection_table` (
    `Id`,
    `Date`,
    `EmpId`,
    `EmpName`,
    `CusId`,
    `CusName`,
    `CollectionAmount`,
    `Rate`,
    `Commission`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    105,
    'Nov 2020',
    'CON000031',
    'Covita Mills',
    'PRO000101',
    'Wanda D. Smith, LCSW-C',
    506.76,
    '1',
    5.07,
    'Not Invoiced',
    'cmillsinvoices',
    'Billing Plus, Inc.'
  );
INSERT INTO
  `collection_table` (
    `Id`,
    `Date`,
    `EmpId`,
    `EmpName`,
    `CusId`,
    `CusName`,
    `CollectionAmount`,
    `Rate`,
    `Commission`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    106,
    'Dec 2020',
    'CON000031',
    'Covita Mills',
    'PRO000079',
    'Onyx Therapy Group - Dr. LaNail Plummer',
    33019.78,
    '1',
    330.20,
    'Not Invoiced',
    'cmillsinvoices',
    'Billing Plus, Inc.'
  );
INSERT INTO
  `collection_table` (
    `Id`,
    `Date`,
    `EmpId`,
    `EmpName`,
    `CusId`,
    `CusName`,
    `CollectionAmount`,
    `Rate`,
    `Commission`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    107,
    'Dec 2020',
    'CON000031',
    'Covita Mills',
    'PRO000083',
    'Samantha Knox, LPC',
    5305.93,
    '1',
    53.06,
    'Not Invoiced',
    'cmillsinvoices',
    'Billing Plus, Inc.'
  );
INSERT INTO
  `collection_table` (
    `Id`,
    `Date`,
    `EmpId`,
    `EmpName`,
    `CusId`,
    `CusName`,
    `CollectionAmount`,
    `Rate`,
    `Commission`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    108,
    'Dec 2020',
    'CON000031',
    'Covita Mills',
    'PRO000101',
    'Wanda D. Smith, LCSW-C',
    125.34,
    '1',
    1.25,
    'Not Invoiced',
    'cmillsinvoices',
    'Billing Plus, Inc.'
  );
INSERT INTO
  `collection_table` (
    `Id`,
    `Date`,
    `EmpId`,
    `EmpName`,
    `CusId`,
    `CusName`,
    `CollectionAmount`,
    `Rate`,
    `Commission`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    112,
    'Jan 2021',
    'CON000031',
    'Covita Mills',
    'PRO000101',
    'Wanda D. Smith, LCSW-C',
    129.54,
    '1',
    1.30,
    'Not Invoiced',
    'cmillsinvoices',
    'Billing Plus, Inc.'
  );
INSERT INTO
  `collection_table` (
    `Id`,
    `Date`,
    `EmpId`,
    `EmpName`,
    `CusId`,
    `CusName`,
    `CollectionAmount`,
    `Rate`,
    `Commission`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    116,
    'Jan 2021',
    'CON000031',
    'Covita Mills',
    'PRO000097',
    'Dr. Jamila Winn ',
    67821.26,
    '1',
    678.21,
    'Not Invoiced',
    'cmillsinvoices',
    'Billing Plus, Inc.'
  );
INSERT INTO
  `collection_table` (
    `Id`,
    `Date`,
    `EmpId`,
    `EmpName`,
    `CusId`,
    `CusName`,
    `CollectionAmount`,
    `Rate`,
    `Commission`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    117,
    'Feb 2021',
    'CON000031',
    'Covita Mills',
    'PRO000079',
    'Onyx Therapy Group - Dr. LaNail Plummer',
    32839.70,
    '1',
    328.40,
    'Not Invoiced',
    'cmillsinvoices',
    'Billing Plus, Inc.'
  );
INSERT INTO
  `collection_table` (
    `Id`,
    `Date`,
    `EmpId`,
    `EmpName`,
    `CusId`,
    `CusName`,
    `CollectionAmount`,
    `Rate`,
    `Commission`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    118,
    'Feb 2021',
    'CON000031',
    'Covita Mills',
    'PRO000083',
    'Samantha Knox, LPC',
    6522.47,
    '1',
    65.22,
    'Not Invoiced',
    'cmillsinvoices',
    'Billing Plus, Inc.'
  );
INSERT INTO
  `collection_table` (
    `Id`,
    `Date`,
    `EmpId`,
    `EmpName`,
    `CusId`,
    `CusName`,
    `CollectionAmount`,
    `Rate`,
    `Commission`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    119,
    'Feb 2021',
    'CON000031',
    'Covita Mills',
    'PRO000094',
    'Nicole Rudd, LCPC',
    1941.24,
    '1',
    19.41,
    'Not Invoiced',
    'cmillsinvoices',
    'Billing Plus, Inc.'
  );
INSERT INTO
  `collection_table` (
    `Id`,
    `Date`,
    `EmpId`,
    `EmpName`,
    `CusId`,
    `CusName`,
    `CollectionAmount`,
    `Rate`,
    `Commission`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    120,
    'Feb 2021',
    'CON000031',
    'Covita Mills',
    'PRO000085',
    'Yetta Lyle, LCPC',
    1675.45,
    '1',
    16.75,
    'Not Invoiced',
    'cmillsinvoices',
    'Billing Plus, Inc.'
  );
INSERT INTO
  `collection_table` (
    `Id`,
    `Date`,
    `EmpId`,
    `EmpName`,
    `CusId`,
    `CusName`,
    `CollectionAmount`,
    `Rate`,
    `Commission`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    121,
    'Feb 2021',
    'CON000031',
    'Covita Mills',
    'PRO000084',
    'Thomas Patota, LCSW',
    1329.65,
    '1',
    13.30,
    'Not Invoiced',
    'cmillsinvoices',
    'Billing Plus, Inc.'
  );
INSERT INTO
  `collection_table` (
    `Id`,
    `Date`,
    `EmpId`,
    `EmpName`,
    `CusId`,
    `CusName`,
    `CollectionAmount`,
    `Rate`,
    `Commission`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    122,
    'Aug 2021',
    'CON000022',
    'Fahad Razzaq',
    'PRO000072',
    'Winnie Moore, LCPC',
    0.00,
    '2',
    0.00,
    'Invoiced',
    'Fahad',
    'ABC COMPANY PVT LTD'
  );
INSERT INTO
  `collection_table` (
    `Id`,
    `Date`,
    `EmpId`,
    `EmpName`,
    `CusId`,
    `CusName`,
    `CollectionAmount`,
    `Rate`,
    `Commission`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    124,
    'Aug 2021',
    'CON000022',
    'Fahad Razzaq',
    'PRO000072',
    'Winnie Moore, LCPC',
    0.00,
    '2',
    0.00,
    'Invoiced',
    'Fahad',
    'ABC COMPANY PVT LTD'
  );
INSERT INTO
  `collection_table` (
    `Id`,
    `Date`,
    `EmpId`,
    `EmpName`,
    `CusId`,
    `CusName`,
    `CollectionAmount`,
    `Rate`,
    `Commission`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    125,
    '2021-08-01',
    'CON000022',
    'Fahad Razzaq',
    'PRO000072',
    'Winnie Moore, LCPC',
    0.00,
    '2',
    0.00,
    'Invoiced',
    'admin',
    'ABC COMPANY PVT LTD'
  );
INSERT INTO
  `collection_table` (
    `Id`,
    `Date`,
    `EmpId`,
    `EmpName`,
    `CusId`,
    `CusName`,
    `CollectionAmount`,
    `Rate`,
    `Commission`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    129,
    'Jul 2021',
    'CON000022',
    'Fahad Razzaq',
    'PRO000074',
    'Demo Provider',
    25000.00,
    '2',
    500.00,
    'Invoiced',
    'Fahad',
    'ABC COMPANY PVT LTD'
  );
INSERT INTO
  `collection_table` (
    `Id`,
    `Date`,
    `EmpId`,
    `EmpName`,
    `CusId`,
    `CusName`,
    `CollectionAmount`,
    `Rate`,
    `Commission`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    130,
    'May 2021',
    'CON000022',
    'Fahad Razzaq',
    'PRO000104',
    'Base Pay Provider',
    0.00,
    '250.00',
    0.00,
    'Invoiced',
    'Fahad',
    'ABC COMPANY PVT LTD'
  );
INSERT INTO
  `collection_table` (
    `Id`,
    `Date`,
    `EmpId`,
    `EmpName`,
    `CusId`,
    `CusName`,
    `CollectionAmount`,
    `Rate`,
    `Commission`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    131,
    'Jun 2021',
    'CON000022',
    'Fahad Razzaq',
    'PRO000072',
    'Winnie Moore, LCPC',
    250000.00,
    '2',
    5000.00,
    'Invoiced',
    'Fahad',
    'ABC COMPANY PVT LTD'
  );
INSERT INTO
  `collection_table` (
    `Id`,
    `Date`,
    `EmpId`,
    `EmpName`,
    `CusId`,
    `CusName`,
    `CollectionAmount`,
    `Rate`,
    `Commission`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    132,
    'Jun 2021',
    'CON000022',
    'Fahad Razzaq',
    'PRO000072',
    'Winnie Moore, LCPC',
    15000.00,
    '2',
    300.00,
    'Invoiced',
    'Fahad',
    'ABC COMPANY PVT LTD'
  );
INSERT INTO
  `collection_table` (
    `Id`,
    `Date`,
    `EmpId`,
    `EmpName`,
    `CusId`,
    `CusName`,
    `CollectionAmount`,
    `Rate`,
    `Commission`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    133,
    'Jul 2021',
    'CON000022',
    'Fahad Razzaq',
    'PRO000104',
    'Base Pay Provider',
    0.00,
    '250.00',
    0.00,
    'Invoiced',
    'Fahad',
    'ABC COMPANY PVT LTD'
  );
INSERT INTO
  `collection_table` (
    `Id`,
    `Date`,
    `EmpId`,
    `EmpName`,
    `CusId`,
    `CusName`,
    `CollectionAmount`,
    `Rate`,
    `Commission`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    134,
    'Jun 2021',
    'CON000030',
    'Tabitha Contee',
    'PRO000092',
    'Apex - Bharat Vallurapalli, MS, OTR/L',
    2280.62,
    '4.5',
    102.63,
    'Invoiced',
    'tconteeinvoices',
    'Billing Plus, Inc.'
  );
INSERT INTO
  `collection_table` (
    `Id`,
    `Date`,
    `EmpId`,
    `EmpName`,
    `CusId`,
    `CusName`,
    `CollectionAmount`,
    `Rate`,
    `Commission`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    135,
    'Jun 2021',
    'CON000030',
    'Tabitha Contee',
    'PRO000093',
    'DC HT - Bharat Vallurapalli, MS, OTR/L',
    1403.78,
    '4.5',
    63.17,
    'Invoiced',
    'tconteeinvoices',
    'Billing Plus, Inc.'
  );
INSERT INTO
  `collection_table` (
    `Id`,
    `Date`,
    `EmpId`,
    `EmpName`,
    `CusId`,
    `CusName`,
    `CollectionAmount`,
    `Rate`,
    `Commission`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    136,
    'Jun 2021',
    'CON000030',
    'Tabitha Contee',
    'PRO000096',
    'Donna Reid Washington, LPC',
    2662.10,
    '4.5',
    119.79,
    'Invoiced',
    'tconteeinvoices',
    'Billing Plus, Inc.'
  );
INSERT INTO
  `collection_table` (
    `Id`,
    `Date`,
    `EmpId`,
    `EmpName`,
    `CusId`,
    `CusName`,
    `CollectionAmount`,
    `Rate`,
    `Commission`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    137,
    'Jun 2021',
    'CON000030',
    'Tabitha Contee',
    'PRO000087',
    'Joy R. Hart, LCSW-C',
    6529.76,
    '4.5',
    293.84,
    'Invoiced',
    'tconteeinvoices',
    'Billing Plus, Inc.'
  );
INSERT INTO
  `collection_table` (
    `Id`,
    `Date`,
    `EmpId`,
    `EmpName`,
    `CusId`,
    `CusName`,
    `CollectionAmount`,
    `Rate`,
    `Commission`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    138,
    'Jun 2021',
    'CON000030',
    'Tabitha Contee',
    'PRO000095',
    'Carla D. Washington, LPC',
    16527.95,
    '4.5',
    743.76,
    'Invoiced',
    'tconteeinvoices',
    'Billing Plus, Inc.'
  );
INSERT INTO
  `collection_table` (
    `Id`,
    `Date`,
    `EmpId`,
    `EmpName`,
    `CusId`,
    `CusName`,
    `CollectionAmount`,
    `Rate`,
    `Commission`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    139,
    'Jun 2021',
    'CON000030',
    'Tabitha Contee',
    'PRO000099',
    'Winnie Moore, LCPC',
    19539.59,
    '4.5',
    879.28,
    'Invoiced',
    'tconteeinvoices',
    'Billing Plus, Inc.'
  );
INSERT INTO
  `collection_table` (
    `Id`,
    `Date`,
    `EmpId`,
    `EmpName`,
    `CusId`,
    `CusName`,
    `CollectionAmount`,
    `Rate`,
    `Commission`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    140,
    'Jun 2021',
    'CON000030',
    'Tabitha Contee',
    'PRO000102',
    'Veronica Watkins, LCSW-C',
    8363.04,
    '4.5',
    376.34,
    'Invoiced',
    'tconteeinvoices',
    'Billing Plus, Inc.'
  );
INSERT INTO
  `collection_table` (
    `Id`,
    `Date`,
    `EmpId`,
    `EmpName`,
    `CusId`,
    `CusName`,
    `CollectionAmount`,
    `Rate`,
    `Commission`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    145,
    'Jun 2021',
    'CON000032',
    'Sanora Wicker',
    'PRO000077',
    'Create Your Life, LLC',
    4202.79,
    '2',
    84.06,
    'Invoiced',
    'swickerinvoices',
    'Billing Plus, Inc.'
  );
INSERT INTO
  `collection_table` (
    `Id`,
    `Date`,
    `EmpId`,
    `EmpName`,
    `CusId`,
    `CusName`,
    `CollectionAmount`,
    `Rate`,
    `Commission`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    149,
    'Jun 2021',
    'CON000031',
    'Covita Mills',
    'PRO000081',
    'Lenese Stephens, LCPC',
    22044.97,
    '1',
    220.45,
    'Invoiced',
    'cmillsinvoices',
    'Billing Plus, Inc.'
  );
INSERT INTO
  `collection_table` (
    `Id`,
    `Date`,
    `EmpId`,
    `EmpName`,
    `CusId`,
    `CusName`,
    `CollectionAmount`,
    `Rate`,
    `Commission`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    150,
    'Jun 2021',
    'CON000031',
    'Covita Mills',
    'PRO000094',
    'Nicole Rudd, LCPC',
    676.01,
    '1',
    6.76,
    'Invoiced',
    'cmillsinvoices',
    'Billing Plus, Inc.'
  );
INSERT INTO
  `collection_table` (
    `Id`,
    `Date`,
    `EmpId`,
    `EmpName`,
    `CusId`,
    `CusName`,
    `CollectionAmount`,
    `Rate`,
    `Commission`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    152,
    'Jun 2021',
    'CON000031',
    'Covita Mills',
    'PRO000101',
    'Wanda D. Smith, LCSW-C',
    842.64,
    '1',
    8.43,
    'Invoiced',
    'cmillsinvoices',
    'Billing Plus, Inc.'
  );
INSERT INTO
  `collection_table` (
    `Id`,
    `Date`,
    `EmpId`,
    `EmpName`,
    `CusId`,
    `CusName`,
    `CollectionAmount`,
    `Rate`,
    `Commission`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    154,
    'Jun 2021',
    'CON000031',
    'Covita Mills',
    'PRO000083',
    'Samantha Knox, LPC',
    6964.59,
    '1',
    69.65,
    'Invoiced',
    'cmillsinvoices',
    'Billing Plus, Inc.'
  );
INSERT INTO
  `collection_table` (
    `Id`,
    `Date`,
    `EmpId`,
    `EmpName`,
    `CusId`,
    `CusName`,
    `CollectionAmount`,
    `Rate`,
    `Commission`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    155,
    'Jun 2021',
    'CON000032',
    'Sanora Wicker',
    'PRO000090',
    'Glenda Bullock-Willis, LCPC',
    0.00,
    '2',
    0.00,
    'Invoiced',
    'swickerinvoices',
    'Billing Plus, Inc.'
  );
INSERT INTO
  `collection_table` (
    `Id`,
    `Date`,
    `EmpId`,
    `EmpName`,
    `CusId`,
    `CusName`,
    `CollectionAmount`,
    `Rate`,
    `Commission`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    156,
    'Jun 2021',
    'CON000031',
    'Covita Mills',
    'PRO000079',
    'Onyx Therapy Group - Dr. LaNail Plummer',
    32231.60,
    '1',
    322.32,
    'Invoiced',
    'cmillsinvoices',
    'Billing Plus, Inc.'
  );
INSERT INTO
  `collection_table` (
    `Id`,
    `Date`,
    `EmpId`,
    `EmpName`,
    `CusId`,
    `CusName`,
    `CollectionAmount`,
    `Rate`,
    `Commission`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    157,
    'Jun 2021',
    'CON000031',
    'Covita Mills',
    'PRO000085',
    'Yetta Lyle, LCPC',
    966.51,
    '1',
    9.67,
    'Invoiced',
    'cmillsinvoices',
    'Billing Plus, Inc.'
  );
INSERT INTO
  `collection_table` (
    `Id`,
    `Date`,
    `EmpId`,
    `EmpName`,
    `CusId`,
    `CusName`,
    `CollectionAmount`,
    `Rate`,
    `Commission`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    158,
    'Jun 2021',
    'CON000032',
    'Sanora Wicker',
    'PRO000076',
    'Jacqueline R. Williams, LCSW',
    1504.27,
    '2',
    30.09,
    'Invoiced',
    'swickerinvoices',
    'Billing Plus, Inc.'
  );
INSERT INTO
  `collection_table` (
    `Id`,
    `Date`,
    `EmpId`,
    `EmpName`,
    `CusId`,
    `CusName`,
    `CollectionAmount`,
    `Rate`,
    `Commission`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    159,
    'Jun 2021',
    'CON000032',
    'Sanora Wicker',
    'PRO000089',
    'Gillian Blackman-Diarra, LCSW-C',
    385.00,
    '2',
    7.70,
    'Invoiced',
    'swickerinvoices',
    'Billing Plus, Inc.'
  );
INSERT INTO
  `collection_table` (
    `Id`,
    `Date`,
    `EmpId`,
    `EmpName`,
    `CusId`,
    `CusName`,
    `CollectionAmount`,
    `Rate`,
    `Commission`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    160,
    'Jun 2021',
    'CON000032',
    'Sanora Wicker',
    'PRO000091',
    'Donna R. Inman, LPC',
    1068.89,
    '2',
    21.38,
    'Invoiced',
    'swickerinvoices',
    'Billing Plus, Inc.'
  );
INSERT INTO
  `collection_table` (
    `Id`,
    `Date`,
    `EmpId`,
    `EmpName`,
    `CusId`,
    `CusName`,
    `CollectionAmount`,
    `Rate`,
    `Commission`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    162,
    'Jun 2021',
    'CON000031',
    'Covita Mills',
    'PRO000084',
    'Thomas Patota, LCSW',
    1495.42,
    '1',
    14.95,
    'Invoiced',
    'cmillsinvoices',
    'Billing Plus, Inc.'
  );
INSERT INTO
  `collection_table` (
    `Id`,
    `Date`,
    `EmpId`,
    `EmpName`,
    `CusId`,
    `CusName`,
    `CollectionAmount`,
    `Rate`,
    `Commission`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    163,
    'Jun 2021',
    'CON000032',
    'Sanora Wicker',
    'PRO000088',
    'Karen L. Allen, LCSW-C',
    505.00,
    '2',
    10.10,
    'Invoiced',
    'swickerinvoices',
    'Billing Plus, Inc.'
  );
INSERT INTO
  `collection_table` (
    `Id`,
    `Date`,
    `EmpId`,
    `EmpName`,
    `CusId`,
    `CusName`,
    `CollectionAmount`,
    `Rate`,
    `Commission`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    165,
    'Jul 2021',
    'CON000030',
    'Tabitha Contee',
    'PRO000103',
    'Base Payment',
    0.00,
    '100',
    0.00,
    'Invoiced',
    'tconteeinvoices',
    'Billing Plus, Inc.'
  );
INSERT INTO
  `collection_table` (
    `Id`,
    `Date`,
    `EmpId`,
    `EmpName`,
    `CusId`,
    `CusName`,
    `CollectionAmount`,
    `Rate`,
    `Commission`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    166,
    'Jan 2021',
    'CON000030',
    'Tabitha Contee',
    'PRO000103',
    'Base Payment',
    0.00,
    '100',
    0.00,
    'Invoiced',
    'tconteeinvoices',
    'Billing Plus, Inc.'
  );
INSERT INTO
  `collection_table` (
    `Id`,
    `Date`,
    `EmpId`,
    `EmpName`,
    `CusId`,
    `CusName`,
    `CollectionAmount`,
    `Rate`,
    `Commission`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    167,
    'Feb 2021',
    'CON000030',
    'Tabitha Contee',
    'PRO000103',
    'Base Payment',
    0.00,
    '100',
    0.00,
    'Invoiced',
    'tconteeinvoices',
    'Billing Plus, Inc.'
  );
INSERT INTO
  `collection_table` (
    `Id`,
    `Date`,
    `EmpId`,
    `EmpName`,
    `CusId`,
    `CusName`,
    `CollectionAmount`,
    `Rate`,
    `Commission`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    168,
    'Mar 2021',
    'CON000030',
    'Tabitha Contee',
    'PRO000103',
    'Base Payment',
    0.00,
    '100',
    0.00,
    'Invoiced',
    'tconteeinvoices',
    'Billing Plus, Inc.'
  );
INSERT INTO
  `collection_table` (
    `Id`,
    `Date`,
    `EmpId`,
    `EmpName`,
    `CusId`,
    `CusName`,
    `CollectionAmount`,
    `Rate`,
    `Commission`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    169,
    'Apr 2021',
    'CON000030',
    'Tabitha Contee',
    'PRO000103',
    'Base Payment',
    0.00,
    '100',
    0.00,
    'Invoiced',
    'tconteeinvoices',
    'Billing Plus, Inc.'
  );
INSERT INTO
  `collection_table` (
    `Id`,
    `Date`,
    `EmpId`,
    `EmpName`,
    `CusId`,
    `CusName`,
    `CollectionAmount`,
    `Rate`,
    `Commission`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    170,
    'May 2021',
    'CON000030',
    'Tabitha Contee',
    'PRO000103',
    'Base Payment',
    0.00,
    '100',
    0.00,
    'Invoiced',
    'tconteeinvoices',
    'Billing Plus, Inc.'
  );
INSERT INTO
  `collection_table` (
    `Id`,
    `Date`,
    `EmpId`,
    `EmpName`,
    `CusId`,
    `CusName`,
    `CollectionAmount`,
    `Rate`,
    `Commission`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    171,
    'Jun 2021',
    'CON000030',
    'Tabitha Contee',
    'PRO000103',
    'Base Payment',
    0.00,
    '100',
    0.00,
    'Invoiced',
    'tconteeinvoices',
    'Billing Plus, Inc.'
  );
INSERT INTO
  `collection_table` (
    `Id`,
    `Date`,
    `EmpId`,
    `EmpName`,
    `CusId`,
    `CusName`,
    `CollectionAmount`,
    `Rate`,
    `Commission`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    172,
    'Jul 2021',
    'CON000033',
    'Javon Young',
    'PRO000103',
    'Base Payment',
    0.00,
    '100',
    0.00,
    'Invoiced',
    'jyounginvoices',
    'Billing Plus, Inc.'
  );
INSERT INTO
  `collection_table` (
    `Id`,
    `Date`,
    `EmpId`,
    `EmpName`,
    `CusId`,
    `CusName`,
    `CollectionAmount`,
    `Rate`,
    `Commission`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    173,
    'May 2021',
    'CON000033',
    'Javon Young',
    'PRO000077',
    'Create Your Life, LLC',
    1000.00,
    '4',
    40.00,
    'Invoiced',
    'jyounginvoices',
    'Billing Plus, Inc.'
  );
INSERT INTO
  `collection_table` (
    `Id`,
    `Date`,
    `EmpId`,
    `EmpName`,
    `CusId`,
    `CusName`,
    `CollectionAmount`,
    `Rate`,
    `Commission`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    174,
    'Dec 2020',
    'CON000030',
    'Tabitha Contee',
    'PRO000103',
    'Base Payment',
    0.00,
    '100',
    0.00,
    'Invoiced',
    'tconteeinvoices',
    'Billing Plus, Inc.'
  );
INSERT INTO
  `collection_table` (
    `Id`,
    `Date`,
    `EmpId`,
    `EmpName`,
    `CusId`,
    `CusName`,
    `CollectionAmount`,
    `Rate`,
    `Commission`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    175,
    'Jun 2021',
    'CON000032',
    'Sanora Wicker',
    'PRO000099',
    'Winnie Moore, LCPC',
    2107.17,
    '2',
    42.14,
    'Invoiced',
    'swickerinvoices',
    'Billing Plus, Inc.'
  );
INSERT INTO
  `collection_table` (
    `Id`,
    `Date`,
    `EmpId`,
    `EmpName`,
    `CusId`,
    `CusName`,
    `CollectionAmount`,
    `Rate`,
    `Commission`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    176,
    'Jun 2021',
    'CON000032',
    'Sanora Wicker',
    'PRO000085',
    'Yetta Lyle, LCPC',
    145.00,
    '2',
    2.90,
    'Invoiced',
    'swickerinvoices',
    'Billing Plus, Inc.'
  );
INSERT INTO
  `collection_table` (
    `Id`,
    `Date`,
    `EmpId`,
    `EmpName`,
    `CusId`,
    `CusName`,
    `CollectionAmount`,
    `Rate`,
    `Commission`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    177,
    'Aug 2021',
    'CON000031',
    'Covita Mills',
    'PRO000103',
    'Base Payment',
    0.00,
    '100',
    0.00,
    'Invoiced',
    'cmillsinvoices',
    'Billing Plus, Inc.'
  );
INSERT INTO
  `collection_table` (
    `Id`,
    `Date`,
    `EmpId`,
    `EmpName`,
    `CusId`,
    `CusName`,
    `CollectionAmount`,
    `Rate`,
    `Commission`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    179,
    'Aug 2021',
    'CON000033',
    'Javon Young',
    'PRO000103',
    'Base Payment',
    0.00,
    '100',
    0.00,
    'Invoiced',
    'jyounginvoices',
    'Billing Plus, Inc.'
  );
INSERT INTO
  `collection_table` (
    `Id`,
    `Date`,
    `EmpId`,
    `EmpName`,
    `CusId`,
    `CusName`,
    `CollectionAmount`,
    `Rate`,
    `Commission`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    180,
    'Aug 2021',
    'CON000032',
    'Sanora Wicker',
    'PRO000103',
    'Base Payment',
    0.00,
    '100',
    0.00,
    'Invoiced',
    'SWICKERINVOICES',
    'Billing Plus, Inc.'
  );
INSERT INTO
  `collection_table` (
    `Id`,
    `Date`,
    `EmpId`,
    `EmpName`,
    `CusId`,
    `CusName`,
    `CollectionAmount`,
    `Rate`,
    `Commission`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    181,
    'Aug 2021',
    'CON000030',
    'Tabitha Contee',
    'PRO000103',
    'Base Payment',
    0.00,
    '100',
    0.00,
    'Invoiced',
    'tconteeinvoices',
    'Billing Plus, Inc.'
  );

# ------------------------------------------------------------
# DATA DUMP FOR TABLE: company_details_table
# ------------------------------------------------------------

INSERT INTO
  `company_details_table` (
    `Id`,
    `CompanyName`,
    `TaxID`,
    `Phone`,
    `Email`,
    `Web`,
    `OwnerName`,
    `OwnerPhone`,
    `EstablishDate`,
    `DateCreated`,
    `Address`,
    `OtherDetails`,
    `DigitalSignature`,
    `Logo`,
    `CreatedBy`
  )
VALUES
  (
    21,
    'ABC COMPANY PVT LTD',
    '7677',
    '3232 6565',
    'sajithfeat145@gmail.com',
    'maritimelk.com',
    'ssasa',
    '+94713155665',
    '2021-01-01',
    '2021-01-13',
    'No.234\nVictoria Road\nColombo',
    'rrrrrr',
    NOFORMAT_WRAP(
      "##X'[BLOB]'##"
    ),
    NOFORMAT_WRAP(
      "##X'[BLOB]'##"
    ),
    'admin'
  );
INSERT INTO
  `company_details_table` (
    `Id`,
    `CompanyName`,
    `TaxID`,
    `Phone`,
    `Email`,
    `Web`,
    `OwnerName`,
    `OwnerPhone`,
    `EstablishDate`,
    `DateCreated`,
    `Address`,
    `OtherDetails`,
    `DigitalSignature`,
    `Logo`,
    `CreatedBy`
  )
VALUES
  (
    22,
    'RapidGnix',
    '',
    '212',
    NULL,
    NULL,
    'sajith',
    NULL,
    '2021-01-14',
    '2021-01-20',
    NULL,
    NULL,
    NULL,
    NOFORMAT_WRAP(
      "##X'[BLOB]'##"
    ),
    'admin'
  );
INSERT INTO
  `company_details_table` (
    `Id`,
    `CompanyName`,
    `TaxID`,
    `Phone`,
    `Email`,
    `Web`,
    `OwnerName`,
    `OwnerPhone`,
    `EstablishDate`,
    `DateCreated`,
    `Address`,
    `OtherDetails`,
    `DigitalSignature`,
    `Logo`,
    `CreatedBy`
  )
VALUES
  (
    23,
    'Novar Flex Pvt Ltd',
    '2333',
    '09477654345',
    'infor@novarflex.com',
    'novarflex.com',
    'Sajith',
    NULL,
    '0000-00-00',
    '0000-00-00',
    NULL,
    NULL,
    NULL,
    NULL,
    'admin'
  );
INSERT INTO
  `company_details_table` (
    `Id`,
    `CompanyName`,
    `TaxID`,
    `Phone`,
    `Email`,
    `Web`,
    `OwnerName`,
    `OwnerPhone`,
    `EstablishDate`,
    `DateCreated`,
    `Address`,
    `OtherDetails`,
    `DigitalSignature`,
    `Logo`,
    `CreatedBy`
  )
VALUES
  (
    24,
    'Billing Plus, Inc.',
    '461361749',
    '3012023739',
    'ismith@billing-plus.com',
    'www.billing-plus.com',
    'Irish Smith',
    '3012023739',
    '2006-07-15',
    '0000-00-00',
    '4315 Northview Drive\nBowie, MD  20716',
    NULL,
    NOFORMAT_WRAP(
      "##X'[BLOB]'##"
    ),
    NOFORMAT_WRAP(
      "##X'[BLOB]'##"
    ),
    'Ismith'
  );

# ------------------------------------------------------------
# DATA DUMP FOR TABLE: customer_receipt_table
# ------------------------------------------------------------

INSERT INTO
  `customer_receipt_table` (
    `Id`,
    `ReceiptNo`,
    `PaidDate`,
    `PaymentType`,
    `PaymentRefNo`,
    `CusId`,
    `CusName`,
    `Address`,
    `PaidTotal`,
    `InvoiceDate`,
    `InvoiceNo`,
    `Period`,
    `BasePayment`,
    `TotalComm`,
    `GrandTotal`,
    `BalToPay`,
    `AmountPaid`,
    `Status`,
    `Payslip`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    170,
    'CPMT000001',
    '2020-12-26',
    'Cheque',
    NULL,
    'EMP000003',
    'Sajith Wickramasena',
    'Kandy',
    1295.00,
    '2020-12-26',
    'INV000001',
    NULL,
    NULL,
    NULL,
    1295.00,
    1295.00,
    1295.00,
    'Paid',
    NULL,
    'admin',
    ''
  );
INSERT INTO
  `customer_receipt_table` (
    `Id`,
    `ReceiptNo`,
    `PaidDate`,
    `PaymentType`,
    `PaymentRefNo`,
    `CusId`,
    `CusName`,
    `Address`,
    `PaidTotal`,
    `InvoiceDate`,
    `InvoiceNo`,
    `Period`,
    `BasePayment`,
    `TotalComm`,
    `GrandTotal`,
    `BalToPay`,
    `AmountPaid`,
    `Status`,
    `Payslip`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    171,
    'CPMT000002',
    '2020-12-26',
    'Cash',
    NULL,
    'EMP000003',
    'Sajith Wickramasena',
    'Kandy',
    7000.00,
    '2020-12-26',
    'INV000002',
    NULL,
    NULL,
    NULL,
    7000.00,
    7000.00,
    7000.00,
    'Paid',
    NULL,
    'admin',
    ''
  );
INSERT INTO
  `customer_receipt_table` (
    `Id`,
    `ReceiptNo`,
    `PaidDate`,
    `PaymentType`,
    `PaymentRefNo`,
    `CusId`,
    `CusName`,
    `Address`,
    `PaidTotal`,
    `InvoiceDate`,
    `InvoiceNo`,
    `Period`,
    `BasePayment`,
    `TotalComm`,
    `GrandTotal`,
    `BalToPay`,
    `AmountPaid`,
    `Status`,
    `Payslip`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    172,
    'CPMT000003',
    '2020-12-26',
    'Cash',
    NULL,
    'EMP000017',
    'Anura Kumara',
    'ff',
    600.00,
    '2020-12-26',
    'INV000003',
    NULL,
    NULL,
    NULL,
    600.00,
    600.00,
    600.00,
    'Paid',
    NULL,
    'admin',
    'RapidGnix'
  );
INSERT INTO
  `customer_receipt_table` (
    `Id`,
    `ReceiptNo`,
    `PaidDate`,
    `PaymentType`,
    `PaymentRefNo`,
    `CusId`,
    `CusName`,
    `Address`,
    `PaidTotal`,
    `InvoiceDate`,
    `InvoiceNo`,
    `Period`,
    `BasePayment`,
    `TotalComm`,
    `GrandTotal`,
    `BalToPay`,
    `AmountPaid`,
    `Status`,
    `Payslip`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    174,
    'CPMT000005',
    '2020-12-27',
    'Cash',
    NULL,
    'EMP000016',
    'Sajith Wickramasena',
    'colombo',
    1000.00,
    '2020-12-27',
    'INV000006',
    NULL,
    NULL,
    NULL,
    2500.00,
    2500.00,
    1000.00,
    'Partly Paid',
    NULL,
    'admin',
    'ABC COMPANY PVT LTD'
  );
INSERT INTO
  `customer_receipt_table` (
    `Id`,
    `ReceiptNo`,
    `PaidDate`,
    `PaymentType`,
    `PaymentRefNo`,
    `CusId`,
    `CusName`,
    `Address`,
    `PaidTotal`,
    `InvoiceDate`,
    `InvoiceNo`,
    `Period`,
    `BasePayment`,
    `TotalComm`,
    `GrandTotal`,
    `BalToPay`,
    `AmountPaid`,
    `Status`,
    `Payslip`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    175,
    'CPMT000006',
    '2021-01-03',
    'Cash',
    NULL,
    'EMP000016',
    'Sajith Wickramasena',
    'colombo',
    2250.00,
    '2021-01-03',
    'INV000007',
    NULL,
    NULL,
    NULL,
    2250.00,
    2250.00,
    2250.00,
    'Paid',
    NULL,
    'admin',
    'ABC COMPANY PVT LTD'
  );
INSERT INTO
  `customer_receipt_table` (
    `Id`,
    `ReceiptNo`,
    `PaidDate`,
    `PaymentType`,
    `PaymentRefNo`,
    `CusId`,
    `CusName`,
    `Address`,
    `PaidTotal`,
    `InvoiceDate`,
    `InvoiceNo`,
    `Period`,
    `BasePayment`,
    `TotalComm`,
    `GrandTotal`,
    `BalToPay`,
    `AmountPaid`,
    `Status`,
    `Payslip`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    176,
    'CPMT000007',
    '2021-01-11',
    'Cash',
    NULL,
    'EMP000016',
    'Sajith Wickramasena',
    'colombo',
    1600.00,
    '2021-01-11',
    'INV000008',
    NULL,
    NULL,
    NULL,
    1600.00,
    1600.00,
    1600.00,
    'Paid',
    NULL,
    'admin',
    'ABC COMPANY PVT LTD'
  );
INSERT INTO
  `customer_receipt_table` (
    `Id`,
    `ReceiptNo`,
    `PaidDate`,
    `PaymentType`,
    `PaymentRefNo`,
    `CusId`,
    `CusName`,
    `Address`,
    `PaidTotal`,
    `InvoiceDate`,
    `InvoiceNo`,
    `Period`,
    `BasePayment`,
    `TotalComm`,
    `GrandTotal`,
    `BalToPay`,
    `AmountPaid`,
    `Status`,
    `Payslip`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    177,
    'CPMT000008',
    '2021-01-11',
    'Cheque',
    NULL,
    'EMP000016',
    'Sajith Wickramasena',
    'colombo',
    4500.00,
    '2020-12-27',
    'INV000006',
    NULL,
    NULL,
    NULL,
    2500.00,
    1500.00,
    1500.00,
    'Paid',
    NULL,
    'admin',
    'ABC COMPANY PVT LTD'
  );
INSERT INTO
  `customer_receipt_table` (
    `Id`,
    `ReceiptNo`,
    `PaidDate`,
    `PaymentType`,
    `PaymentRefNo`,
    `CusId`,
    `CusName`,
    `Address`,
    `PaidTotal`,
    `InvoiceDate`,
    `InvoiceNo`,
    `Period`,
    `BasePayment`,
    `TotalComm`,
    `GrandTotal`,
    `BalToPay`,
    `AmountPaid`,
    `Status`,
    `Payslip`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    178,
    'CPMT000008',
    '2021-01-11',
    'Cheque',
    NULL,
    'EMP000016',
    'Sajith Wickramasena',
    'colombo',
    4500.00,
    '2020-12-27',
    'INV000005',
    NULL,
    NULL,
    NULL,
    3000.00,
    3000.00,
    3000.00,
    'Paid',
    NULL,
    'admin',
    'ABC COMPANY PVT LTD'
  );
INSERT INTO
  `customer_receipt_table` (
    `Id`,
    `ReceiptNo`,
    `PaidDate`,
    `PaymentType`,
    `PaymentRefNo`,
    `CusId`,
    `CusName`,
    `Address`,
    `PaidTotal`,
    `InvoiceDate`,
    `InvoiceNo`,
    `Period`,
    `BasePayment`,
    `TotalComm`,
    `GrandTotal`,
    `BalToPay`,
    `AmountPaid`,
    `Status`,
    `Payslip`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    179,
    'CPMT000009',
    '2021-01-12',
    'Cash',
    NULL,
    'EMP000016',
    'Sajith Wickramasena',
    'colombo',
    38950.00,
    '2021-01-12',
    'INV000009',
    NULL,
    NULL,
    NULL,
    38950.00,
    38950.00,
    38950.00,
    'Paid',
    NULL,
    'admin',
    'ABC COMPANY PVT LTD'
  );
INSERT INTO
  `customer_receipt_table` (
    `Id`,
    `ReceiptNo`,
    `PaidDate`,
    `PaymentType`,
    `PaymentRefNo`,
    `CusId`,
    `CusName`,
    `Address`,
    `PaidTotal`,
    `InvoiceDate`,
    `InvoiceNo`,
    `Period`,
    `BasePayment`,
    `TotalComm`,
    `GrandTotal`,
    `BalToPay`,
    `AmountPaid`,
    `Status`,
    `Payslip`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    180,
    'CPMT000010',
    '2021-01-12',
    'Cash',
    NULL,
    'EMP000016',
    'Sajith Wickramasena',
    'colombo',
    40000.00,
    '2021-01-12',
    'INV000010',
    NULL,
    NULL,
    NULL,
    40000.00,
    40000.00,
    40000.00,
    'Paid',
    NULL,
    'admin',
    'ABC COMPANY PVT LTD'
  );
INSERT INTO
  `customer_receipt_table` (
    `Id`,
    `ReceiptNo`,
    `PaidDate`,
    `PaymentType`,
    `PaymentRefNo`,
    `CusId`,
    `CusName`,
    `Address`,
    `PaidTotal`,
    `InvoiceDate`,
    `InvoiceNo`,
    `Period`,
    `BasePayment`,
    `TotalComm`,
    `GrandTotal`,
    `BalToPay`,
    `AmountPaid`,
    `Status`,
    `Payslip`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    181,
    'CPMT000011',
    '2021-03-20',
    'Cheque',
    NULL,
    'EMP000016',
    'Sajith Wickramasena',
    'colombo',
    15000.00,
    '2021-03-20',
    'INV000011',
    NULL,
    NULL,
    NULL,
    15000.00,
    15000.00,
    15000.00,
    'Paid',
    NULL,
    'admin',
    'ABC COMPANY PVT LTD'
  );
INSERT INTO
  `customer_receipt_table` (
    `Id`,
    `ReceiptNo`,
    `PaidDate`,
    `PaymentType`,
    `PaymentRefNo`,
    `CusId`,
    `CusName`,
    `Address`,
    `PaidTotal`,
    `InvoiceDate`,
    `InvoiceNo`,
    `Period`,
    `BasePayment`,
    `TotalComm`,
    `GrandTotal`,
    `BalToPay`,
    `AmountPaid`,
    `Status`,
    `Payslip`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    182,
    'CPMT000012',
    '2021-03-20',
    'Cash',
    NULL,
    'EMP000016',
    'Sajith Wickramasena',
    'colombo',
    2600.00,
    '2020-12-26',
    'INV000004',
    NULL,
    NULL,
    NULL,
    2600.00,
    2600.00,
    2600.00,
    'Paid',
    NULL,
    'admin',
    'ABC COMPANY PVT LTD'
  );
INSERT INTO
  `customer_receipt_table` (
    `Id`,
    `ReceiptNo`,
    `PaidDate`,
    `PaymentType`,
    `PaymentRefNo`,
    `CusId`,
    `CusName`,
    `Address`,
    `PaidTotal`,
    `InvoiceDate`,
    `InvoiceNo`,
    `Period`,
    `BasePayment`,
    `TotalComm`,
    `GrandTotal`,
    `BalToPay`,
    `AmountPaid`,
    `Status`,
    `Payslip`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    184,
    'CPMT000013',
    '2021-05-30',
    'Cheque',
    NULL,
    'EMP000019',
    'Banuka perera',
    'Kandy Road\nNittambuwa',
    6000.00,
    '2021-05-30',
    'INV000004',
    NULL,
    NULL,
    NULL,
    6000.00,
    6000.00,
    6000.00,
    'Paid',
    NULL,
    'admin',
    'ABC COMPANY PVT LTD'
  );
INSERT INTO
  `customer_receipt_table` (
    `Id`,
    `ReceiptNo`,
    `PaidDate`,
    `PaymentType`,
    `PaymentRefNo`,
    `CusId`,
    `CusName`,
    `Address`,
    `PaidTotal`,
    `InvoiceDate`,
    `InvoiceNo`,
    `Period`,
    `BasePayment`,
    `TotalComm`,
    `GrandTotal`,
    `BalToPay`,
    `AmountPaid`,
    `Status`,
    `Payslip`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    192,
    'CPMT000014',
    '2021-06-05',
    'Cash',
    NULL,
    'EMP000019',
    'Banuka perera',
    'Kandy Road',
    2700.00,
    '2021-06-05',
    'INV000012',
    NULL,
    NULL,
    NULL,
    2700.00,
    2700.00,
    2700.00,
    'Paid',
    NULL,
    'admin',
    'ABC COMPANY PVT LTD'
  );
INSERT INTO
  `customer_receipt_table` (
    `Id`,
    `ReceiptNo`,
    `PaidDate`,
    `PaymentType`,
    `PaymentRefNo`,
    `CusId`,
    `CusName`,
    `Address`,
    `PaidTotal`,
    `InvoiceDate`,
    `InvoiceNo`,
    `Period`,
    `BasePayment`,
    `TotalComm`,
    `GrandTotal`,
    `BalToPay`,
    `AmountPaid`,
    `Status`,
    `Payslip`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    194,
    'CPMT000016',
    '2021-07-17',
    'Cheque',
    '6667',
    'EMP000019',
    'Banuka perera',
    'Kandy Road',
    42000.00,
    '2021-06-14',
    'INV000022',
    '2021-06',
    30000.00,
    12000.00,
    42000.00,
    42000.00,
    42000.00,
    'Paid',
    'Yes',
    'admin',
    'ABC COMPANY PVT LTD'
  );
INSERT INTO
  `customer_receipt_table` (
    `Id`,
    `ReceiptNo`,
    `PaidDate`,
    `PaymentType`,
    `PaymentRefNo`,
    `CusId`,
    `CusName`,
    `Address`,
    `PaidTotal`,
    `InvoiceDate`,
    `InvoiceNo`,
    `Period`,
    `BasePayment`,
    `TotalComm`,
    `GrandTotal`,
    `BalToPay`,
    `AmountPaid`,
    `Status`,
    `Payslip`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    195,
    'CPMT000017',
    '2021-07-19',
    'Cheque',
    '777',
    'EMP000019',
    'Banuka perera',
    'Kandy Road',
    4200.00,
    '2021-06-05',
    'INV000012',
    '2021-05',
    0.00,
    4200.00,
    4200.00,
    4200.00,
    4200.00,
    'Paid',
    'Yes',
    'admin',
    'ABC COMPANY PVT LTD'
  );
INSERT INTO
  `customer_receipt_table` (
    `Id`,
    `ReceiptNo`,
    `PaidDate`,
    `PaymentType`,
    `PaymentRefNo`,
    `CusId`,
    `CusName`,
    `Address`,
    `PaidTotal`,
    `InvoiceDate`,
    `InvoiceNo`,
    `Period`,
    `BasePayment`,
    `TotalComm`,
    `GrandTotal`,
    `BalToPay`,
    `AmountPaid`,
    `Status`,
    `Payslip`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    196,
    'CPMT000018',
    '2021-07-19',
    'Cheque',
    '88',
    'EMP000019',
    'Banuka perera',
    'Kandy Road',
    1125.00,
    '2021-06-11',
    'INV000014',
    '2021-05',
    0.00,
    1125.00,
    1125.00,
    1125.00,
    1125.00,
    'Paid',
    'Yes',
    'admin',
    'ABC COMPANY PVT LTD'
  );
INSERT INTO
  `customer_receipt_table` (
    `Id`,
    `ReceiptNo`,
    `PaidDate`,
    `PaymentType`,
    `PaymentRefNo`,
    `CusId`,
    `CusName`,
    `Address`,
    `PaidTotal`,
    `InvoiceDate`,
    `InvoiceNo`,
    `Period`,
    `BasePayment`,
    `TotalComm`,
    `GrandTotal`,
    `BalToPay`,
    `AmountPaid`,
    `Status`,
    `Payslip`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    201,
    'CPMT000019',
    '2021-08-06',
    'Cheque',
    '111111',
    'EMP000019',
    'Banuka perera',
    'Kandy Road',
    1125.00,
    '2021-06-04',
    'INV000013',
    '2021-05',
    0.00,
    1125.00,
    1125.00,
    1125.00,
    1125.00,
    'Paid',
    'No',
    'admin',
    'ABC COMPANY PVT LTD'
  );
INSERT INTO
  `customer_receipt_table` (
    `Id`,
    `ReceiptNo`,
    `PaidDate`,
    `PaymentType`,
    `PaymentRefNo`,
    `CusId`,
    `CusName`,
    `Address`,
    `PaidTotal`,
    `InvoiceDate`,
    `InvoiceNo`,
    `Period`,
    `BasePayment`,
    `TotalComm`,
    `GrandTotal`,
    `BalToPay`,
    `AmountPaid`,
    `Status`,
    `Payslip`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    204,
    'CPMT000020',
    '2021-07-26',
    'Bank Transfer',
    NULL,
    'CON000033',
    'Javon Young',
    '11300 Kettering Place\nUpper Marlboro, MD  20774',
    2625.67,
    '2021-07-22',
    'INV000045',
    '2021-07',
    2625.67,
    0.00,
    2625.67,
    2625.67,
    2625.67,
    'Paid',
    'Yes',
    'Ismith01',
    'Billing Plus, Inc.'
  );
INSERT INTO
  `customer_receipt_table` (
    `Id`,
    `ReceiptNo`,
    `PaidDate`,
    `PaymentType`,
    `PaymentRefNo`,
    `CusId`,
    `CusName`,
    `Address`,
    `PaidTotal`,
    `InvoiceDate`,
    `InvoiceNo`,
    `Period`,
    `BasePayment`,
    `TotalComm`,
    `GrandTotal`,
    `BalToPay`,
    `AmountPaid`,
    `Status`,
    `Payslip`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    205,
    'CPMT000021',
    '2021-05-01',
    'Cash',
    '00000000',
    'CON000033',
    'Javon Young',
    '11300 Kettering Place\nUpper Marlboro, MD  20774',
    2665.67,
    '2021-08-22',
    'INV000046',
    '2021-05',
    2625.67,
    40.00,
    2665.67,
    2665.67,
    2665.67,
    'Paid',
    'No',
    'FahadAdmin',
    'Billing Plus, Inc.'
  );
INSERT INTO
  `customer_receipt_table` (
    `Id`,
    `ReceiptNo`,
    `PaidDate`,
    `PaymentType`,
    `PaymentRefNo`,
    `CusId`,
    `CusName`,
    `Address`,
    `PaidTotal`,
    `InvoiceDate`,
    `InvoiceNo`,
    `Period`,
    `BasePayment`,
    `TotalComm`,
    `GrandTotal`,
    `BalToPay`,
    `AmountPaid`,
    `Status`,
    `Payslip`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    206,
    'CPMT000022',
    '2021-01-06',
    'Bank Transfer',
    NULL,
    'CON000030',
    'Tabitha Contee',
    '15 Queen Anne Bridge Road\nUpper Marlboro, MD  20774',
    1000.00,
    '2021-01-02',
    'INV000048',
    '2020-12',
    1000.00,
    0.00,
    1000.00,
    1000.00,
    1000.00,
    'Paid',
    'Yes',
    'Ismith01',
    'Billing Plus, Inc.'
  );
INSERT INTO
  `customer_receipt_table` (
    `Id`,
    `ReceiptNo`,
    `PaidDate`,
    `PaymentType`,
    `PaymentRefNo`,
    `CusId`,
    `CusName`,
    `Address`,
    `PaidTotal`,
    `InvoiceDate`,
    `InvoiceNo`,
    `Period`,
    `BasePayment`,
    `TotalComm`,
    `GrandTotal`,
    `BalToPay`,
    `AmountPaid`,
    `Status`,
    `Payslip`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    207,
    'CPMT000023',
    '2021-02-06',
    'Bank Transfer',
    NULL,
    'CON000030',
    'Tabitha Contee',
    '15 Queen Anne Bridge Road\nUpper Marlboro, MD  20774',
    1000.00,
    '2021-02-01',
    'INV000040',
    '2021-01',
    1000.00,
    0.00,
    1000.00,
    1000.00,
    1000.00,
    'Paid',
    'Yes',
    'Ismith01',
    'Billing Plus, Inc.'
  );
INSERT INTO
  `customer_receipt_table` (
    `Id`,
    `ReceiptNo`,
    `PaidDate`,
    `PaymentType`,
    `PaymentRefNo`,
    `CusId`,
    `CusName`,
    `Address`,
    `PaidTotal`,
    `InvoiceDate`,
    `InvoiceNo`,
    `Period`,
    `BasePayment`,
    `TotalComm`,
    `GrandTotal`,
    `BalToPay`,
    `AmountPaid`,
    `Status`,
    `Payslip`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    208,
    'CPMT000024',
    '2021-08-26',
    'Bank Transfer',
    'ACH',
    'CON000030',
    'Tabitha Contee',
    '15 Queen Anne Bridge Road\nUpper Marlboro, MD  20774',
    2578.81,
    '2021-08-23',
    'INV000036',
    '2021-06',
    0.00,
    2578.81,
    2578.81,
    2578.81,
    2578.81,
    'Paid',
    'No',
    'Ismith01',
    'Billing Plus, Inc.'
  );
INSERT INTO
  `customer_receipt_table` (
    `Id`,
    `ReceiptNo`,
    `PaidDate`,
    `PaymentType`,
    `PaymentRefNo`,
    `CusId`,
    `CusName`,
    `Address`,
    `PaidTotal`,
    `InvoiceDate`,
    `InvoiceNo`,
    `Period`,
    `BasePayment`,
    `TotalComm`,
    `GrandTotal`,
    `BalToPay`,
    `AmountPaid`,
    `Status`,
    `Payslip`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    209,
    'CPMT000025',
    '2021-08-26',
    'Bank Transfer',
    'ACH',
    'CON000031',
    'Covita Mills',
    '2571 Enterprise Place\nWaldorf, MD 20601',
    652.23,
    '2021-08-23',
    'INV000037',
    '2021-06',
    0.00,
    652.23,
    652.23,
    652.23,
    652.23,
    'Paid',
    'No',
    'Ismith01',
    'Billing Plus, Inc.'
  );
INSERT INTO
  `customer_receipt_table` (
    `Id`,
    `ReceiptNo`,
    `PaidDate`,
    `PaymentType`,
    `PaymentRefNo`,
    `CusId`,
    `CusName`,
    `Address`,
    `PaidTotal`,
    `InvoiceDate`,
    `InvoiceNo`,
    `Period`,
    `BasePayment`,
    `TotalComm`,
    `GrandTotal`,
    `BalToPay`,
    `AmountPaid`,
    `Status`,
    `Payslip`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    210,
    'CPMT000026',
    '2021-08-26',
    'Bank Transfer',
    'ACH',
    'CON000032',
    'Sanora Wicker',
    '17204 Britfield Court\nAccokeek, MD 20607',
    198.37,
    '2021-08-24',
    'INV000049',
    '2021-06',
    0.00,
    198.37,
    198.37,
    198.37,
    198.37,
    'Paid',
    'No',
    'Ismith01',
    'Billing Plus, Inc.'
  );
INSERT INTO
  `customer_receipt_table` (
    `Id`,
    `ReceiptNo`,
    `PaidDate`,
    `PaymentType`,
    `PaymentRefNo`,
    `CusId`,
    `CusName`,
    `Address`,
    `PaidTotal`,
    `InvoiceDate`,
    `InvoiceNo`,
    `Period`,
    `BasePayment`,
    `TotalComm`,
    `GrandTotal`,
    `BalToPay`,
    `AmountPaid`,
    `Status`,
    `Payslip`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    212,
    'CPMT000027',
    '2021-09-03',
    'Bank Transfer',
    'ACH',
    'CON000032',
    'Sanora Wicker',
    '17204 Britfield Court\nAccokeek, MD 20607',
    2166.67,
    '2021-09-02',
    'INV000054',
    '2021-08',
    2166.67,
    0.00,
    2166.67,
    2166.67,
    2166.67,
    'Paid',
    'No',
    'Ismith01',
    'Billing Plus, Inc.'
  );
INSERT INTO
  `customer_receipt_table` (
    `Id`,
    `ReceiptNo`,
    `PaidDate`,
    `PaymentType`,
    `PaymentRefNo`,
    `CusId`,
    `CusName`,
    `Address`,
    `PaidTotal`,
    `InvoiceDate`,
    `InvoiceNo`,
    `Period`,
    `BasePayment`,
    `TotalComm`,
    `GrandTotal`,
    `BalToPay`,
    `AmountPaid`,
    `Status`,
    `Payslip`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    213,
    'CPMT000028',
    '2021-09-03',
    'Bank Transfer',
    'ACH',
    'CON000030',
    'Tabitha Contee',
    '15 Queen Anne Bridge Road\nUpper Marlboro, MD  20774',
    1000.00,
    '2021-09-02',
    'INV000055',
    '2021-08',
    1000.00,
    0.00,
    1000.00,
    1000.00,
    1000.00,
    'Paid',
    'No',
    'Ismith01',
    'Billing Plus, Inc.'
  );
INSERT INTO
  `customer_receipt_table` (
    `Id`,
    `ReceiptNo`,
    `PaidDate`,
    `PaymentType`,
    `PaymentRefNo`,
    `CusId`,
    `CusName`,
    `Address`,
    `PaidTotal`,
    `InvoiceDate`,
    `InvoiceNo`,
    `Period`,
    `BasePayment`,
    `TotalComm`,
    `GrandTotal`,
    `BalToPay`,
    `AmountPaid`,
    `Status`,
    `Payslip`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    214,
    'CPMT000029',
    '2021-09-03',
    'Bank Transfer',
    'ACH',
    'CON000031',
    'Covita Mills',
    '2571 Enterprise Place\nWaldorf, MD 20601',
    4333.33,
    '2021-08-25',
    'INV000050',
    '2021-08',
    4333.33,
    0.00,
    4333.33,
    4333.33,
    4333.33,
    'Paid',
    'No',
    'Ismith01',
    'Billing Plus, Inc.'
  );

# ------------------------------------------------------------
# DATA DUMP FOR TABLE: customer_table
# ------------------------------------------------------------

INSERT INTO
  `customer_table` (
    `Id`,
    `CusId`,
    `CusName`,
    `Phone`,
    `Email`,
    `Address`,
    `GroupName`,
    `StartDate`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    159,
    'CUS000034',
    'SAJITH WICKRAMSENA ',
    '555566776',
    'sajithfeat145@gmail.com',
    'Nugegoda',
    ' 544545454545      ',
    '2020-12-24',
    'Active',
    'admin',
    'RapidGnix'
  );
INSERT INTO
  `customer_table` (
    `Id`,
    `CusId`,
    `CusName`,
    `Phone`,
    `Email`,
    `Address`,
    `GroupName`,
    `StartDate`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    174,
    'CUS000044',
    'ANURA PERERA ',
    'asassasasas',
    'sajithfeat145@gmail.com',
    'No 14\nMal Mawatha\nColombo 05',
    ' 544545454545      ',
    '0000-00-00',
    'Deactivated',
    'admin',
    'RapidGnix'
  );
INSERT INTO
  `customer_table` (
    `Id`,
    `CusId`,
    `CusName`,
    `Phone`,
    `Email`,
    `Address`,
    `GroupName`,
    `StartDate`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    175,
    'CUS000045',
    'ewew',
    'ewe',
    'eww@gmail.com',
    'wqwq',
    NULL,
    '2020-12-23',
    'Active',
    'admin',
    'RapidGnix'
  );
INSERT INTO
  `customer_table` (
    `Id`,
    `CusId`,
    `CusName`,
    `Phone`,
    `Email`,
    `Address`,
    `GroupName`,
    `StartDate`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    181,
    'CUS000051',
    'Kasun Devappriya',
    '3232',
    'kasun@gmail.com',
    'colombo',
    'bbb',
    '2020-12-24',
    'Active',
    'admin',
    'RapidGnix'
  );
INSERT INTO
  `customer_table` (
    `Id`,
    `CusId`,
    `CusName`,
    `Phone`,
    `Email`,
    `Address`,
    `GroupName`,
    `StartDate`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    182,
    'CUS000052',
    'nnnnnn',
    '21212',
    'sa@gmial.com',
    'wqwq',
    'wqw',
    '2021-01-22',
    'Active',
    'admin',
    'RapidGnix'
  );
INSERT INTO
  `customer_table` (
    `Id`,
    `CusId`,
    `CusName`,
    `Phone`,
    `Email`,
    `Address`,
    `GroupName`,
    `StartDate`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    196,
    'CUS000066',
    'Asela Gunarathne',
    '4444',
    '',
    'Kandy Road, Colombo 10',
    'bbb',
    '2021-06-16',
    'Active',
    'admin',
    'Novar Flex Pvt Ltd'
  );
INSERT INTO
  `customer_table` (
    `Id`,
    `CusId`,
    `CusName`,
    `Phone`,
    `Email`,
    `Address`,
    `GroupName`,
    `StartDate`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    198,
    'PRO000067',
    'Joy R. Hart, LCSW-C',
    '(571) 236-7012 ',
    'joy.hart76@aol.com',
    '14300 Gallant Fox Lane, #115 Bowie, MD  20715',
    'DJLS Therapy Services, LLC',
    '2010-06-15',
    'Active',
    'FahadAdmin',
    'ABC COMPANY PVT LTD'
  );
INSERT INTO
  `customer_table` (
    `Id`,
    `CusId`,
    `CusName`,
    `Phone`,
    `Email`,
    `Address`,
    `GroupName`,
    `StartDate`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    199,
    'PRO000068',
    'Bharat Vallurapalli, MS, OTR/L (VA)',
    '(703) 242-4263  ',
    'bharat@apexhandtherapy.com',
    '226 Maple Avenue, West, Suite 405, Vienna VA 22180',
    'Apex Hand Therapy, LLC',
    '2010-01-01',
    'Active',
    'Ismith01',
    'ABC COMPANY PVT LTD'
  );
INSERT INTO
  `customer_table` (
    `Id`,
    `CusId`,
    `CusName`,
    `Phone`,
    `Email`,
    `Address`,
    `GroupName`,
    `StartDate`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    200,
    'PRO000069',
    'Bharat Vallurapalli, MS,OTR/L (DC)',
    '(202) 545-6555',
    'bharat@dchandtherapy.com',
    '1020 19th Street, NW, Suite 775, WDC 20036',
    'Hand Therapy, LLC',
    '2015-01-01',
    'Active',
    'Ismith01',
    'ABC COMPANY PVT LTD'
  );
INSERT INTO
  `customer_table` (
    `Id`,
    `CusId`,
    `CusName`,
    `Phone`,
    `Email`,
    `Address`,
    `GroupName`,
    `StartDate`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    201,
    'PRO000070',
    'Donna Reid Washington, LPC',
    '(301) 526-3971',
    'reidwash214@comcast.net',
    '1775 Eye Street, NW Suite 1150, WDC 20005',
    'Love First, LLC',
    '2006-06-01',
    'Active',
    'Ismith01',
    'ABC COMPANY PVT LTD'
  );
INSERT INTO
  `customer_table` (
    `Id`,
    `CusId`,
    `CusName`,
    `Phone`,
    `Email`,
    `Address`,
    `GroupName`,
    `StartDate`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    202,
    'PRO000071',
    'Carla D. Washington, LCPC, LPC',
    '(202) 204-2215',
    'carlawashington@aol.com',
    '1629 K Street, NW, Suite 300, WDC 20006',
    'Carla D. Washington, LCPC, LPC',
    '2006-01-01',
    'Active',
    'Ismith01',
    'ABC COMPANY PVT LTD'
  );
INSERT INTO
  `customer_table` (
    `Id`,
    `CusId`,
    `CusName`,
    `Phone`,
    `Email`,
    `Address`,
    `GroupName`,
    `StartDate`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    203,
    'PRO000072',
    'Winnie Moore, LCPC',
    '(240) 232-5554',
    'ajscounselingconsultingservices@gmail.com',
    '2670 Crain Hwy, Suite 408, Waldorf, MD 20603',
    'AJs Counseling Consulting Services',
    '2016-01-01',
    'Active',
    'Ismith01',
    'ABC COMPANY PVT LTD'
  );
INSERT INTO
  `customer_table` (
    `Id`,
    `CusId`,
    `CusName`,
    `Phone`,
    `Email`,
    `Address`,
    `GroupName`,
    `StartDate`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    204,
    'PRO000073',
    'Veronica Watkins, LCSW-C',
    '(301) 909-4606',
    'templebuilders7@gmail.com',
    '9701 Apollo Drive, Suite 410, Upper Marlboro, MD 20774',
    'Temple Builders, LLC',
    '2020-01-01',
    'Active',
    'FahadAdmin',
    'ABC COMPANY PVT LTD'
  );
INSERT INTO
  `customer_table` (
    `Id`,
    `CusId`,
    `CusName`,
    `Phone`,
    `Email`,
    `Address`,
    `GroupName`,
    `StartDate`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    205,
    'PRO000074',
    'Demo Provider',
    '+923334908121',
    'fraz@gmail.com',
    'P.O. BOX 805107',
    'None',
    '2021-01-01',
    'Active',
    'FahadAdmin',
    'ABC COMPANY PVT LTD'
  );
INSERT INTO
  `customer_table` (
    `Id`,
    `CusId`,
    `CusName`,
    `Phone`,
    `Email`,
    `Address`,
    `GroupName`,
    `StartDate`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    206,
    'PRO000075',
    'LaNail Plummer, LPC',
    '(202) 246-0925 ',
    'dr.plummer@onyxtherapygroup.com',
    '529 14th Street, NW Suite 988',
    'Onyx Therapy Group',
    '2020-07-01',
    'Active',
    'Ismith01',
    'ABC COMPANY PVT LTD'
  );
INSERT INTO
  `customer_table` (
    `Id`,
    `CusId`,
    `CusName`,
    `Phone`,
    `Email`,
    `Address`,
    `GroupName`,
    `StartDate`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    207,
    'PRO000076',
    'Jacqueline R. Williams, LCSW',
    '240-535-8013',
    'jrbrownllc@yahoo.com',
    '9500 Medical Center Drive, Suite 230B, Upper Marlboro, MD  20774',
    'JRBrown, LLC',
    '2019-04-11',
    'Active',
    'Ismith01',
    'Billing Plus, Inc.'
  );
INSERT INTO
  `customer_table` (
    `Id`,
    `CusId`,
    `CusName`,
    `Phone`,
    `Email`,
    `Address`,
    `GroupName`,
    `StartDate`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    208,
    'PRO000077',
    'Create Your Life, LLC',
    '301-857-1848',
    'amw0804@yahoo.com',
    '10665 Stanhaven Place, Rm 3119, White Plains, MD  20695',
    'Create Your Life, LLC',
    '2019-02-01',
    'Active',
    'Ismith01',
    'Billing Plus, Inc.'
  );
INSERT INTO
  `customer_table` (
    `Id`,
    `CusId`,
    `CusName`,
    `Phone`,
    `Email`,
    `Address`,
    `GroupName`,
    `StartDate`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    209,
    'PRO000078',
    'Karena Wilson-Plater, PsyD',
    '301-938-7276',
    'kplater@thebridgetherapeutic.com',
    '7360 Grace Drive, Columbia, MD  21044',
    'The Bridge Therapeutic and Evaluation Services, LLC',
    '2021-04-01',
    'Active',
    'Ismith01',
    'Billing Plus, Inc.'
  );
INSERT INTO
  `customer_table` (
    `Id`,
    `CusId`,
    `CusName`,
    `Phone`,
    `Email`,
    `Address`,
    `GroupName`,
    `StartDate`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    210,
    'PRO000079',
    'Onyx Therapy Group - Dr. LaNail Plummer',
    '202-400-7524',
    'admin@onyxtherapygroup.com',
    '529 14th Street, NW Suite 988, Washington, DC  20045',
    'EMC2 Educational Consulting',
    '2020-08-01',
    'Active',
    'Ismith01',
    'Billing Plus, Inc.'
  );
INSERT INTO
  `customer_table` (
    `Id`,
    `CusId`,
    `CusName`,
    `Phone`,
    `Email`,
    `Address`,
    `GroupName`,
    `StartDate`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    211,
    'PRO000080',
    'LaCole Cole, LCPC',
    '240-346-1974',
    'lacole@dynamiccounselinggroup.com',
    '3195 Old Washington RD, Suite 110, Waldorf, MD 20602',
    'Dynamic Counseling Group, LLC',
    '2021-08-01',
    'Active',
    'Ismith01',
    'Billing Plus, Inc.'
  );
INSERT INTO
  `customer_table` (
    `Id`,
    `CusId`,
    `CusName`,
    `Phone`,
    `Email`,
    `Address`,
    `GroupName`,
    `StartDate`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    212,
    'PRO000081',
    'Lenese Stephens, LCPC',
    '301-844-1752',
    'drstephens@hopefulcounseling.org',
    '4601 Presidents Drive, Suit 135, Lanham, MD  20706',
    'Hopeful Counseling, LLC',
    '2021-05-01',
    'Active',
    'Ismith01',
    'Billing Plus, Inc.'
  );
INSERT INTO
  `customer_table` (
    `Id`,
    `CusId`,
    `CusName`,
    `Phone`,
    `Email`,
    `Address`,
    `GroupName`,
    `StartDate`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    213,
    'PRO000082',
    'Nji J. Fru, CNPR',
    '301-675-1652',
    'nfijru2003@yahoo.com',
    '2670 Crain Highway, Suite 408, Waldorf, MD  20601',
    'F and N Renounce Healthcare Services, Inc.',
    '2021-04-15',
    'Active',
    'Ismith01',
    'Billing Plus, Inc.'
  );
INSERT INTO
  `customer_table` (
    `Id`,
    `CusId`,
    `CusName`,
    `Phone`,
    `Email`,
    `Address`,
    `GroupName`,
    `StartDate`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    214,
    'PRO000083',
    'Samantha Knox, LPC',
    '202-746-5838',
    'samanthaknoxlpc@gmail.com',
    '1638 R Street, NW, Suite 311, Washington, DC  20009',
    'AYA Behavioral Health, LLC',
    '2020-04-01',
    'Active',
    'Ismith01',
    'Billing Plus, Inc.'
  );
INSERT INTO
  `customer_table` (
    `Id`,
    `CusId`,
    `CusName`,
    `Phone`,
    `Email`,
    `Address`,
    `GroupName`,
    `StartDate`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    215,
    'PRO000084',
    'Thomas Patota, LCSW',
    '301-593-8111',
    'tompatota@gmail.com',
    '1413 Annapolis Road, Suite 207, Odenton, MD 21113',
    'Thomas Patota, LCSW',
    '2021-01-01',
    'Active',
    'Ismith01',
    'Billing Plus, Inc.'
  );
INSERT INTO
  `customer_table` (
    `Id`,
    `CusId`,
    `CusName`,
    `Phone`,
    `Email`,
    `Address`,
    `GroupName`,
    `StartDate`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    216,
    'PRO000085',
    'Yetta Lyle, LCPC',
    '240-731-2830',
    'yettalyle@gmail.com',
    '1304 Kings Heather Drive, Mitchellville, MD  20721',
    'Metamorphosis',
    '2019-11-01',
    'Active',
    'Ismith01',
    'Billing Plus, Inc.'
  );
INSERT INTO
  `customer_table` (
    `Id`,
    `CusId`,
    `CusName`,
    `Phone`,
    `Email`,
    `Address`,
    `GroupName`,
    `StartDate`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    217,
    'PRO000086',
    'Judith Rose Wilson, LCPC',
    '301-605-3509',
    'jsallywally@hotmail.com',
    '',
    'Social Solutions, Inc.',
    '2017-03-01',
    'Active',
    'Ismith01',
    'Billing Plus, Inc.'
  );
INSERT INTO
  `customer_table` (
    `Id`,
    `CusId`,
    `CusName`,
    `Phone`,
    `Email`,
    `Address`,
    `GroupName`,
    `StartDate`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    218,
    'PRO000087',
    'Joy R. Hart, LCSW-C',
    '571-236-7012',
    'joy.hart76@yahoo.com',
    '14300 Gallant Fox Lane, Suite 115, Bowie, MD  20715',
    'DJLS Therapy Services, LLC',
    '2014-07-21',
    'Active',
    'Ismith01',
    'Billing Plus, Inc.'
  );
INSERT INTO
  `customer_table` (
    `Id`,
    `CusId`,
    `CusName`,
    `Phone`,
    `Email`,
    `Address`,
    `GroupName`,
    `StartDate`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    219,
    'PRO000088',
    'Karen L. Allen, LCSW-C',
    '301-741-7934',
    'imaniconsulting12@gmail.com',
    '4329 Northview Drive, Bowie, MD 20716',
    'Imani Consulting',
    '2015-09-14',
    'Active',
    'Ismith01',
    'Billing Plus, Inc.'
  );
INSERT INTO
  `customer_table` (
    `Id`,
    `CusId`,
    `CusName`,
    `Phone`,
    `Email`,
    `Address`,
    `GroupName`,
    `StartDate`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    220,
    'PRO000089',
    'Gillian Blackman-Diarra, LCSW-C',
    '240-354-8552',
    'diarragillian@yahoo.com',
    '7015 Dolphin RD, Lanham, MD 20706',
    'Gillian Blackman-Diarra, LCSW-C',
    '2012-08-01',
    'Active',
    'Ismith01',
    'Billing Plus, Inc.'
  );
INSERT INTO
  `customer_table` (
    `Id`,
    `CusId`,
    `CusName`,
    `Phone`,
    `Email`,
    `Address`,
    `GroupName`,
    `StartDate`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    221,
    'PRO000090',
    'Glenda Bullock-Willis, LCPC',
    '301-832-6295',
    'glendawillis@hotmail.com',
    '5211 Auth RD, Suite 202, Suitland, MD  20746',
    'Glenda Bullock-Willis, LCPC',
    '2015-04-01',
    'Active',
    'Ismith01',
    'Billing Plus, Inc.'
  );
INSERT INTO
  `customer_table` (
    `Id`,
    `CusId`,
    `CusName`,
    `Phone`,
    `Email`,
    `Address`,
    `GroupName`,
    `StartDate`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    222,
    'PRO000091',
    'Donna R. Inman, LPC',
    '703-975-7322',
    'donna.inman.lpc@gmail.com',
    '1629 K Street, NW, Suite 300, Washington, DC 20006',
    'Rosebud Counseling',
    '2014-06-23',
    'Active',
    'Ismith01',
    'Billing Plus, Inc.'
  );
INSERT INTO
  `customer_table` (
    `Id`,
    `CusId`,
    `CusName`,
    `Phone`,
    `Email`,
    `Address`,
    `GroupName`,
    `StartDate`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    223,
    'PRO000092',
    'Apex - Bharat Vallurapalli, MS, OTR/L',
    '571-432-9454',
    'bharat@apexhandtherapy.com',
    '226 Maple Avenue, West, Suite 405, Vienna VA 22180',
    'Apex Hand Therapy, PLLC',
    '2010-04-12',
    'Active',
    'Ismith01',
    'Billing Plus, Inc.'
  );
INSERT INTO
  `customer_table` (
    `Id`,
    `CusId`,
    `CusName`,
    `Phone`,
    `Email`,
    `Address`,
    `GroupName`,
    `StartDate`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    224,
    'PRO000093',
    'DC HT - Bharat Vallurapalli, MS, OTR/L',
    '571-236-7012',
    'bharat@dchandtherapy.com',
    '1020 19th Street, NW, Suite 775, Washington, DC 20036',
    'DC Hand Therapy, PLLC',
    '2015-03-01',
    'Active',
    'Ismith01',
    'Billing Plus, Inc.'
  );
INSERT INTO
  `customer_table` (
    `Id`,
    `CusId`,
    `CusName`,
    `Phone`,
    `Email`,
    `Address`,
    `GroupName`,
    `StartDate`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    225,
    'PRO000094',
    'Nicole Rudd, LCPC',
    '202-406-0929',
    'nicolewrudd@gmail.com',
    '2905 Mitchellville Road, Suite 112, Bowie, MD  20716',
    'Nicole Rudd, LCPC',
    '2019-06-01',
    'Active',
    'Ismith01',
    'Billing Plus, Inc.'
  );
INSERT INTO
  `customer_table` (
    `Id`,
    `CusId`,
    `CusName`,
    `Phone`,
    `Email`,
    `Address`,
    `GroupName`,
    `StartDate`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    226,
    'PRO000095',
    'Carla D. Washington, LPC',
    '301-906-3449',
    'carlawashington@aol.com',
    '1629 K Street, NW, Suite 300, Washington, DC  20006',
    'Carla D. Washington, LPC',
    '2005-08-01',
    'Active',
    'Ismith01',
    'Billing Plus, Inc.'
  );
INSERT INTO
  `customer_table` (
    `Id`,
    `CusId`,
    `CusName`,
    `Phone`,
    `Email`,
    `Address`,
    `GroupName`,
    `StartDate`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    227,
    'PRO000096',
    'Donna Reid Washington, LPC',
    '301-526-3971',
    'reidwash214@comcast.net',
    '1775 Eye Street, NW Suite 1150, Washington, DC 20006',
    'Donna Reid Washington, LPC',
    '2006-01-01',
    'Active',
    'Ismith01',
    'Billing Plus, Inc.'
  );
INSERT INTO
  `customer_table` (
    `Id`,
    `CusId`,
    `CusName`,
    `Phone`,
    `Email`,
    `Address`,
    `GroupName`,
    `StartDate`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    228,
    'PRO000097',
    'Dr. Jamila Winn ',
    '301-458-8123',
    'drwinn@drjamilawinn.com',
    '9500 Medical Center Drive, Suite 230B, Upper Marlboro, MD 20774',
    'Mindset Therapy and Wellness, Inc.',
    '2020-01-20',
    'Deactivated',
    'Ismith01',
    'Billing Plus, Inc.'
  );
INSERT INTO
  `customer_table` (
    `Id`,
    `CusId`,
    `CusName`,
    `Phone`,
    `Email`,
    `Address`,
    `GroupName`,
    `StartDate`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    229,
    'PRO000098',
    'Tammy Miller, Ph.D',
    '000-000-0000',
    'tammymiller@mirrormentalhealth.com',
    '2110 PRIEST BRIDGE DRIVE, Suite 1, Crofton, MD  21114',
    'Mirror Mental Health',
    '2019-03-01',
    'Deactivated',
    'Ismith01',
    'Billing Plus, Inc.'
  );
INSERT INTO
  `customer_table` (
    `Id`,
    `CusId`,
    `CusName`,
    `Phone`,
    `Email`,
    `Address`,
    `GroupName`,
    `StartDate`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    230,
    'PRO000099',
    'Winnie Moore, LCPC',
    '240-232-5554',
    'wmoore@ajscounseling.net',
    '2670 Crain Hwy, Suite 408, Waldorf, MD 20601',
    'AJs Counseling and Consulting Services',
    '2018-06-01',
    'Active',
    'Ismith01',
    'Billing Plus, Inc.'
  );
INSERT INTO
  `customer_table` (
    `Id`,
    `CusId`,
    `CusName`,
    `Phone`,
    `Email`,
    `Address`,
    `GroupName`,
    `StartDate`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    231,
    'PRO000100',
    'Alpha and Omega Health and Wellness Center',
    '240-232-5554',
    'aandowc@gmail.com',
    '2670 Crain Hwy, Suite 408, Waldorf, MD 20601',
    'Alpha and Omega Health and Wellness Center',
    '2020-01-01',
    'Active',
    'Ismith01',
    'Billing Plus, Inc.'
  );
INSERT INTO
  `customer_table` (
    `Id`,
    `CusId`,
    `CusName`,
    `Phone`,
    `Email`,
    `Address`,
    `GroupName`,
    `StartDate`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    232,
    'PRO000101',
    'Wanda D. Smith, LCSW-C',
    '000-000-0000',
    'wdsmith330@mac.com',
    '13005 Martha\'s Choice Circle, Bowie, MD  20720',
    'JW Smith, LLC',
    '2020-09-01',
    'Active',
    'Ismith01',
    'Billing Plus, Inc.'
  );
INSERT INTO
  `customer_table` (
    `Id`,
    `CusId`,
    `CusName`,
    `Phone`,
    `Email`,
    `Address`,
    `GroupName`,
    `StartDate`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    233,
    'PRO000102',
    'Veronica Watkins, LCSW-C',
    '(301) 909-4606',
    'templebuilders@gmail.com',
    '9701 Apollo Drive, Suite 410, Upper Marlboro, MD 20774',
    'Temple Builders, LLC',
    '2019-06-01',
    'Active',
    'admin',
    'Billing Plus, Inc.'
  );
INSERT INTO
  `customer_table` (
    `Id`,
    `CusId`,
    `CusName`,
    `Phone`,
    `Email`,
    `Address`,
    `GroupName`,
    `StartDate`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    234,
    'PRO000103',
    'Base Payment',
    '3014123835',
    'ismith@billing-plus.com',
    '4315 Northview Drive',
    'Billing Plus, Inc.',
    '2020-12-28',
    'Active',
    'Ismith01',
    'Billing Plus, Inc.'
  );
INSERT INTO
  `customer_table` (
    `Id`,
    `CusId`,
    `CusName`,
    `Phone`,
    `Email`,
    `Address`,
    `GroupName`,
    `StartDate`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    235,
    'PRO000104',
    'Base Pay Provider',
    '0000000000',
    '',
    '',
    '',
    '2021-01-01',
    'Active',
    'admin',
    'ABC COMPANY PVT LTD'
  );
INSERT INTO
  `customer_table` (
    `Id`,
    `CusId`,
    `CusName`,
    `Phone`,
    `Email`,
    `Address`,
    `GroupName`,
    `StartDate`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    236,
    'PRO000105',
    'Dalton Johnson, LCPC',
    '301-848-6793',
    'djjohnson@smcps.org',
    '4660 Prestancia Place, Apt 107, Waldorf, MD  20602',
    'n/a',
    '2021-09-01',
    'Active',
    'Ismith01',
    'Billing Plus, Inc.'
  );
INSERT INTO
  `customer_table` (
    `Id`,
    `CusId`,
    `CusName`,
    `Phone`,
    `Email`,
    `Address`,
    `GroupName`,
    `StartDate`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    237,
    'PRO000106',
    'Danielle Rogal-Hudespeth, LCPC',
    '202-604-5687',
    'lcmftdanielle@gmail.com',
    '3124 Applegate Terrace, Bowie, MD 20716',
    'Inclusive Community Counseling, LLC',
    '2021-09-01',
    'Active',
    'Ismith01',
    'Billing Plus, Inc.'
  );

# ------------------------------------------------------------
# DATA DUMP FOR TABLE: emp_table
# ------------------------------------------------------------

INSERT INTO
  `emp_table` (
    `Id`,
    `EmpName`,
    `DOB`,
    `Gender`,
    `Address`,
    `Phone`,
    `Email`,
    `Status`,
    `CreatedBy`
  )
VALUES
  (
    7,
    'Irish Smith',
    '1968-09-07',
    '2',
    '4315 Northview Drive\nBowie, MD 20716',
    '3012023739',
    'ismith@billing-plus.com',
    'Active',
    'Ismith01'
  );

# ------------------------------------------------------------
# DATA DUMP FOR TABLE: file_upload_table
# ------------------------------------------------------------

INSERT INTO
  `file_upload_table` (
    `Id`,
    `EmpId`,
    `EmpName`,
    `FileName`,
    `Description`,
    `AttachedDate`,
    `IsShared`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    22,
    'EMP000019',
    'Banuka perera',
    '1623483328033-5.jpg',
    'mmm',
    '2021-06-12',
    'Yes',
    'banukap',
    'ABC COMPANY PVT LTD'
  );
INSERT INTO
  `file_upload_table` (
    `Id`,
    `EmpId`,
    `EmpName`,
    `FileName`,
    `Description`,
    `AttachedDate`,
    `IsShared`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    23,
    'EMP000019',
    'Banuka perera',
    '1623485732097-3.jpg',
    'bbbb',
    '2021-06-12',
    'No',
    'banukap',
    'ABC COMPANY PVT LTD'
  );
INSERT INTO
  `file_upload_table` (
    `Id`,
    `EmpId`,
    `EmpName`,
    `FileName`,
    `Description`,
    `AttachedDate`,
    `IsShared`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    24,
    'EMP000019',
    'Banuka perera',
    '1623485977474-cus outsatanding.pdf',
    'report',
    '2021-06-12',
    'No',
    'banukap',
    'ABC COMPANY PVT LTD'
  );
INSERT INTO
  `file_upload_table` (
    `Id`,
    `EmpId`,
    `EmpName`,
    `FileName`,
    `Description`,
    `AttachedDate`,
    `IsShared`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    25,
    'EMP000019',
    'Banuka perera',
    '1623486020190-Invoice-INV000097.pdf',
    'report',
    '2021-06-12',
    'Yes',
    'banukap',
    'ABC COMPANY PVT LTD'
  );
INSERT INTO
  `file_upload_table` (
    `Id`,
    `EmpId`,
    `EmpName`,
    `FileName`,
    `Description`,
    `AttachedDate`,
    `IsShared`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    27,
    'EMP000019',
    'Banuka perera',
    '1623537476575-dashboard.JPG',
    'mnbb',
    '2021-06-13',
    'No',
    'banukap',
    'ABC COMPANY PVT LTD'
  );
INSERT INTO
  `file_upload_table` (
    `Id`,
    `EmpId`,
    `EmpName`,
    `FileName`,
    `Description`,
    `AttachedDate`,
    `IsShared`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    28,
    'EMP000019',
    'Banuka perera',
    '1623537539285-2.jpg',
    'mnbb',
    '2021-06-13',
    'Yes',
    'banukap',
    'ABC COMPANY PVT LTD'
  );
INSERT INTO
  `file_upload_table` (
    `Id`,
    `EmpId`,
    `EmpName`,
    `FileName`,
    `Description`,
    `AttachedDate`,
    `IsShared`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    29,
    'CON000026',
    'Nalaka Bandara',
    '1623547209823-1.jpg',
    'bcv',
    '2021-06-13',
    'Yes',
    'nalakab',
    'Novar Flex Pvt Ltd'
  );
INSERT INTO
  `file_upload_table` (
    `Id`,
    `EmpId`,
    `EmpName`,
    `FileName`,
    `Description`,
    `AttachedDate`,
    `IsShared`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    30,
    'admin',
    'admin',
    '1623553369709-1.jpg',
    'inv',
    '2021-06-13',
    'Yes',
    'admin',
    'ABC COMPANY PVT LTD'
  );
INSERT INTO
  `file_upload_table` (
    `Id`,
    `EmpId`,
    `EmpName`,
    `FileName`,
    `Description`,
    `AttachedDate`,
    `IsShared`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    31,
    'EMP000019',
    'Banuka perera',
    '1623556367668-1.jpg',
    'mmm',
    '2021-06-13',
    'Yes',
    'banukap',
    'ABC COMPANY PVT LTD'
  );
INSERT INTO
  `file_upload_table` (
    `Id`,
    `EmpId`,
    `EmpName`,
    `FileName`,
    `Description`,
    `AttachedDate`,
    `IsShared`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    32,
    'admin',
    'admin',
    '1624788871364-9.jpg',
    'new rates',
    '2021-06-27',
    'Yes',
    'admin',
    'ABC COMPANY PVT LTD'
  );
INSERT INTO
  `file_upload_table` (
    `Id`,
    `EmpId`,
    `EmpName`,
    `FileName`,
    `Description`,
    `AttachedDate`,
    `IsShared`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    33,
    'banukap',
    'banukap',
    '1624792347965-1.jpg',
    'bbbb',
    '2021-06-27',
    'No',
    'banukap',
    'ABC COMPANY PVT LTD'
  );
INSERT INTO
  `file_upload_table` (
    `Id`,
    `EmpId`,
    `EmpName`,
    `FileName`,
    `Description`,
    `AttachedDate`,
    `IsShared`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    34,
    'banukap',
    'banukap',
    '1624792534434-2.jpg',
    'lllll',
    '2021-06-27',
    'No',
    'banukap',
    'ABC COMPANY PVT LTD'
  );
INSERT INTO
  `file_upload_table` (
    `Id`,
    `EmpId`,
    `EmpName`,
    `FileName`,
    `Description`,
    `AttachedDate`,
    `IsShared`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    35,
    'EMP000019',
    'Banuka perera',
    '1624795408804-3.jpg',
    'gggg',
    '2021-06-27',
    'Yes',
    'banukap',
    'ABC COMPANY PVT LTD'
  );
INSERT INTO
  `file_upload_table` (
    `Id`,
    `EmpId`,
    `EmpName`,
    `FileName`,
    `Description`,
    `AttachedDate`,
    `IsShared`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    36,
    'Ismith01',
    'Ismith01',
    '1628607411137-PAYROLL SCHEDULE 2021.pdf',
    'Payroll Schedule 2021',
    '2021-08-10',
    'Yes',
    'Ismith01',
    'Billing Plus, Inc.'
  );
INSERT INTO
  `file_upload_table` (
    `Id`,
    `EmpId`,
    `EmpName`,
    `FileName`,
    `Description`,
    `AttachedDate`,
    `IsShared`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    37,
    'Ismith01',
    'Ismith01',
    '1628607433077-Time Off Request Form.pdf',
    'Time Off Request',
    '2021-08-10',
    'Yes',
    'Ismith01',
    'Billing Plus, Inc.'
  );
INSERT INTO
  `file_upload_table` (
    `Id`,
    `EmpId`,
    `EmpName`,
    `FileName`,
    `Description`,
    `AttachedDate`,
    `IsShared`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    38,
    'Ismith01',
    'Ismith01',
    '1628607473535-Direct Deposit Form.pdf',
    'Direct Deposit Request',
    '2021-08-10',
    'Yes',
    'Ismith01',
    'Billing Plus, Inc.'
  );
INSERT INTO
  `file_upload_table` (
    `Id`,
    `EmpId`,
    `EmpName`,
    `FileName`,
    `Description`,
    `AttachedDate`,
    `IsShared`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    39,
    'Ismith01',
    'Ismith01',
    '1628607493568-Background Check Document.pdf',
    'Background Check',
    '2021-08-10',
    'Yes',
    'Ismith01',
    'Billing Plus, Inc.'
  );
INSERT INTO
  `file_upload_table` (
    `Id`,
    `EmpId`,
    `EmpName`,
    `FileName`,
    `Description`,
    `AttachedDate`,
    `IsShared`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    41,
    'Ismith01',
    'Ismith01',
    '1628607877849-fw9.pdf',
    'IRS W9',
    '2021-08-10',
    'Yes',
    'Ismith01',
    'Billing Plus, Inc.'
  );
INSERT INTO
  `file_upload_table` (
    `Id`,
    `EmpId`,
    `EmpName`,
    `FileName`,
    `Description`,
    `AttachedDate`,
    `IsShared`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    42,
    'Ismith01',
    'Ismith01',
    '1629734621471-MyPayPlus User Guide.pdf',
    'System User Guide as of August 2021',
    '2021-08-23',
    'Yes',
    'Ismith01',
    'Billing Plus, Inc.'
  );
INSERT INTO
  `file_upload_table` (
    `Id`,
    `EmpId`,
    `EmpName`,
    `FileName`,
    `Description`,
    `AttachedDate`,
    `IsShared`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    43,
    'Ismith01',
    'Ismith01',
    '1630331433109-Independent Contractor Handbook 2021.pdf',
    'IC Handbook',
    '2021-08-30',
    'Yes',
    'Ismith01',
    'Billing Plus, Inc.'
  );
INSERT INTO
  `file_upload_table` (
    `Id`,
    `EmpId`,
    `EmpName`,
    `FileName`,
    `Description`,
    `AttachedDate`,
    `IsShared`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    44,
    'CON000033',
    'Javon Young',
    '1630672129977-jyoung acknowlegment form.pdf',
    'acknowledgement form',
    '2021-09-03',
    'No',
    'jyounginvoices',
    'Billing Plus, Inc.'
  );
INSERT INTO
  `file_upload_table` (
    `Id`,
    `EmpId`,
    `EmpName`,
    `FileName`,
    `Description`,
    `AttachedDate`,
    `IsShared`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    45,
    'Ismith01',
    'Ismith01',
    '1631658544335-Position Description - Signature Reqd.pdf',
    'Billing Assistant Position Description',
    '2021-09-14',
    'Yes',
    'Ismith01',
    'Billing Plus, Inc.'
  );

# ------------------------------------------------------------
# DATA DUMP FOR TABLE: backup_table
# ------------------------------------------------------------

INSERT INTO
  `backup_table` (
    `Id`,
    `Filename`,
    `DateCreated`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    10,
    '2021-07-18-backup.sql',
    '07/18/2021 11:31:01 PM',
    'admin',
    'ABC COMPANY PVT LTD'
  );
INSERT INTO
  `backup_table` (
    `Id`,
    `Filename`,
    `DateCreated`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    11,
    '2021-07-19-backup.sql',
    '07/19/2021 10:28:54 PM',
    'admin',
    'ABC COMPANY PVT LTD'
  );
INSERT INTO
  `backup_table` (
    `Id`,
    `Filename`,
    `DateCreated`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    12,
    '2021-07-20-backup.sql',
    '07/20/2021 9:54:59 PM',
    'admin',
    'ABC COMPANY PVT LTD'
  );
INSERT INTO
  `backup_table` (
    `Id`,
    `Filename`,
    `DateCreated`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    13,
    '2021-07-25-backup.sql',
    '07/25/2021 10:14:43 PM',
    'admin',
    'ABC COMPANY PVT LTD'
  );

# ------------------------------------------------------------
# DATA DUMP FOR TABLE: settings_table
# ------------------------------------------------------------

INSERT INTO
  `settings_table` (`Id`, `RefId`, `RefName`)
VALUES
  (1, 'POS01', 'CutePDF Writer');
INSERT INTO
  `settings_table` (`Id`, `RefId`, `RefName`)
VALUES
  (2, 'NP01', 'CutePDF Writer');
INSERT INTO
  `settings_table` (`Id`, `RefId`, `RefName`)
VALUES
  (3, 'TAX01', '45');
INSERT INTO
  `settings_table` (`Id`, `RefId`, `RefName`)
VALUES
  (4, 'VAT01', '15');
INSERT INTO
  `settings_table` (`Id`, `RefId`, `RefName`)
VALUES
  (5, 'COM01', 'Billing Plus, Inc.');
INSERT INTO
  `settings_table` (`Id`, `RefId`, `RefName`)
VALUES
  (6, 'DateFormat', 'MM/DD/YYYY');

# ------------------------------------------------------------
# DATA DUMP FOR TABLE: shared_document_table
# ------------------------------------------------------------

INSERT INTO
  `shared_document_table` (
    `Id`,
    `FileName`,
    `Description`,
    `SharedOn`,
    `SharedBy`,
    `SharedTo`,
    `CompanyName`
  )
VALUES
  (
    17,
    '1624788871364-9.jpg',
    'new rates',
    '2021-06-27',
    'admin',
    'All',
    'ABC COMPANY PVT LTD'
  );
INSERT INTO
  `shared_document_table` (
    `Id`,
    `FileName`,
    `Description`,
    `SharedOn`,
    `SharedBy`,
    `SharedTo`,
    `CompanyName`
  )
VALUES
  (
    18,
    '1623486020190-Invoice-INV000097.pdf',
    'report',
    '2021-06-27',
    'admin',
    'anurakw',
    'ABC COMPANY PVT LTD'
  );
INSERT INTO
  `shared_document_table` (
    `Id`,
    `FileName`,
    `Description`,
    `SharedOn`,
    `SharedBy`,
    `SharedTo`,
    `CompanyName`
  )
VALUES
  (
    19,
    '1624795408804-3.jpg',
    'gggg',
    '2021-06-27',
    'banukap',
    'All',
    'ABC COMPANY PVT LTD'
  );
INSERT INTO
  `shared_document_table` (
    `Id`,
    `FileName`,
    `Description`,
    `SharedOn`,
    `SharedBy`,
    `SharedTo`,
    `CompanyName`
  )
VALUES
  (
    20,
    '1623537539285-2.jpg',
    'mnbb',
    '2021-06-27',
    'banukap',
    'anurakw',
    'ABC COMPANY PVT LTD'
  );
INSERT INTO
  `shared_document_table` (
    `Id`,
    `FileName`,
    `Description`,
    `SharedOn`,
    `SharedBy`,
    `SharedTo`,
    `CompanyName`
  )
VALUES
  (
    21,
    '1623483328033-5.jpg',
    'mmm',
    '2021-06-27',
    'banukap',
    'banukap',
    'ABC COMPANY PVT LTD'
  );
INSERT INTO
  `shared_document_table` (
    `Id`,
    `FileName`,
    `Description`,
    `SharedOn`,
    `SharedBy`,
    `SharedTo`,
    `CompanyName`
  )
VALUES
  (
    22,
    '1623556367668-1.jpg',
    'mmm',
    '2021-06-27',
    'banukap',
    'admin',
    'ABC COMPANY PVT LTD'
  );
INSERT INTO
  `shared_document_table` (
    `Id`,
    `FileName`,
    `Description`,
    `SharedOn`,
    `SharedBy`,
    `SharedTo`,
    `CompanyName`
  )
VALUES
  (
    25,
    '1623553369709-1.jpg',
    'inv',
    '2021-07-07',
    'admin',
    'banukap',
    'ABC COMPANY PVT LTD'
  );
INSERT INTO
  `shared_document_table` (
    `Id`,
    `FileName`,
    `Description`,
    `SharedOn`,
    `SharedBy`,
    `SharedTo`,
    `CompanyName`
  )
VALUES
  (
    26,
    '1628607411137-PAYROLL SCHEDULE 2021.pdf',
    'Payroll Schedule 2021',
    '2021-08-10',
    'Ismith01',
    'All',
    'Billing Plus, Inc.'
  );
INSERT INTO
  `shared_document_table` (
    `Id`,
    `FileName`,
    `Description`,
    `SharedOn`,
    `SharedBy`,
    `SharedTo`,
    `CompanyName`
  )
VALUES
  (
    27,
    '1628607433077-Time Off Request Form.pdf',
    'Time Off Request',
    '2021-08-10',
    'Ismith01',
    'All',
    'Billing Plus, Inc.'
  );
INSERT INTO
  `shared_document_table` (
    `Id`,
    `FileName`,
    `Description`,
    `SharedOn`,
    `SharedBy`,
    `SharedTo`,
    `CompanyName`
  )
VALUES
  (
    28,
    '1628607473535-Direct Deposit Form.pdf',
    'Direct Deposit Request',
    '2021-08-10',
    'Ismith01',
    'All',
    'Billing Plus, Inc.'
  );
INSERT INTO
  `shared_document_table` (
    `Id`,
    `FileName`,
    `Description`,
    `SharedOn`,
    `SharedBy`,
    `SharedTo`,
    `CompanyName`
  )
VALUES
  (
    29,
    '1628607493568-Background Check Document.pdf',
    'Background Check',
    '2021-08-10',
    'Ismith01',
    'All',
    'Billing Plus, Inc.'
  );
INSERT INTO
  `shared_document_table` (
    `Id`,
    `FileName`,
    `Description`,
    `SharedOn`,
    `SharedBy`,
    `SharedTo`,
    `CompanyName`
  )
VALUES
  (
    31,
    '1628607877849-fw9.pdf',
    'IRS W9',
    '2021-08-10',
    'Ismith01',
    'All',
    'Billing Plus, Inc.'
  );
INSERT INTO
  `shared_document_table` (
    `Id`,
    `FileName`,
    `Description`,
    `SharedOn`,
    `SharedBy`,
    `SharedTo`,
    `CompanyName`
  )
VALUES
  (
    32,
    '1629734621471-MyPayPlus User Guide.pdf',
    'System User Guide as of August 2021',
    '2021-08-23',
    'Ismith01',
    'All',
    'Billing Plus, Inc.'
  );
INSERT INTO
  `shared_document_table` (
    `Id`,
    `FileName`,
    `Description`,
    `SharedOn`,
    `SharedBy`,
    `SharedTo`,
    `CompanyName`
  )
VALUES
  (
    33,
    '1630331433109-Independent Contractor Handbook 2021.pdf',
    'IC Handbook',
    '2021-08-30',
    'Ismith01',
    'tconteeinvoices',
    'Billing Plus, Inc.'
  );
INSERT INTO
  `shared_document_table` (
    `Id`,
    `FileName`,
    `Description`,
    `SharedOn`,
    `SharedBy`,
    `SharedTo`,
    `CompanyName`
  )
VALUES
  (
    34,
    '1630331433109-Independent Contractor Handbook 2021.pdf',
    'IC Handbook',
    '2021-08-30',
    'Ismith01',
    'cmillsinvoices',
    'Billing Plus, Inc.'
  );
INSERT INTO
  `shared_document_table` (
    `Id`,
    `FileName`,
    `Description`,
    `SharedOn`,
    `SharedBy`,
    `SharedTo`,
    `CompanyName`
  )
VALUES
  (
    35,
    '1630331433109-Independent Contractor Handbook 2021.pdf',
    'IC Handbook',
    '2021-08-30',
    'Ismith01',
    'swickerinvoices',
    'Billing Plus, Inc.'
  );
INSERT INTO
  `shared_document_table` (
    `Id`,
    `FileName`,
    `Description`,
    `SharedOn`,
    `SharedBy`,
    `SharedTo`,
    `CompanyName`
  )
VALUES
  (
    37,
    '1631658544335-Position Description - Signature Reqd.pdf',
    'Billing Assistant Position Description',
    '2021-09-14',
    'Ismith01',
    'tleeinvoices',
    'Billing Plus, Inc.'
  );

# ------------------------------------------------------------
# DATA DUMP FOR TABLE: task_table
# ------------------------------------------------------------

INSERT INTO
  `task_table` (
    `Id`,
    `EmpId`,
    `EmpName`,
    `Type`,
    `Title`,
    `Description`,
    `DueDate`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    7,
    'EMP000016',
    'Sajith Wickramasena',
    'Normal',
    'sasa',
    'sas',
    '2020-12-23',
    'In Progress',
    'admin',
    'ABC COMPANY PVT LTD'
  );
INSERT INTO
  `task_table` (
    `Id`,
    `EmpId`,
    `EmpName`,
    `Type`,
    `Title`,
    `Description`,
    `DueDate`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    9,
    'EMP000016',
    'Sajith Wickramasena',
    'Urgent',
    'accountin',
    'manoth end',
    '2021-01-13',
    'Not Started',
    'admin',
    'ABC COMPANY PVT LTD'
  );
INSERT INTO
  `task_table` (
    `Id`,
    `EmpId`,
    `EmpName`,
    `Type`,
    `Title`,
    `Description`,
    `DueDate`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    10,
    'EMP000016',
    'Sajith Wickramasena',
    'Urgent',
    'dsdsd',
    'dsd',
    '2020-12-15',
    'On Hold',
    'admin',
    'ABC COMPANY PVT LTD'
  );
INSERT INTO
  `task_table` (
    `Id`,
    `EmpId`,
    `EmpName`,
    `Type`,
    `Title`,
    `Description`,
    `DueDate`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    11,
    'EMP000016',
    'Sajith Wickramasena',
    'Urgent',
    'sas',
    'saas',
    '2020-12-23',
    'Completed',
    'admin',
    'ABC COMPANY PVT LTD'
  );
INSERT INTO
  `task_table` (
    `Id`,
    `EmpId`,
    `EmpName`,
    `Type`,
    `Title`,
    `Description`,
    `DueDate`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    12,
    'EMP000016',
    'Sajith Wickramasena',
    'Normal',
    'ewewe',
    'ewewe',
    '2020-12-17',
    'In Progress',
    'admin',
    'ABC COMPANY PVT LTD'
  );
INSERT INTO
  `task_table` (
    `Id`,
    `EmpId`,
    `EmpName`,
    `Type`,
    `Title`,
    `Description`,
    `DueDate`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    13,
    'EMP000016',
    'Sajith Wickramasena',
    'Special',
    'ewewe',
    'ewew',
    '2020-12-30',
    'Completed',
    'admin',
    'ABC COMPANY PVT LTD'
  );
INSERT INTO
  `task_table` (
    `Id`,
    `EmpId`,
    `EmpName`,
    `Type`,
    `Title`,
    `Description`,
    `DueDate`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    14,
    'EMP000016',
    'Sajith Wickramasena',
    'Normal',
    'wqwq',
    'wqw',
    '2020-12-31',
    'On Hold',
    'admin',
    'ABC COMPANY PVT LTD'
  );
INSERT INTO
  `task_table` (
    `Id`,
    `EmpId`,
    `EmpName`,
    `Type`,
    `Title`,
    `Description`,
    `DueDate`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    15,
    'EMP000016',
    'Sajith Wickramasena',
    'Urgent',
    'sas',
    'sas',
    '2021-03-25',
    'Not Started',
    'admin',
    'ABC COMPANY PVT LTD'
  );
INSERT INTO
  `task_table` (
    `Id`,
    `EmpId`,
    `EmpName`,
    `Type`,
    `Title`,
    `Description`,
    `DueDate`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    16,
    'EMP000017',
    'Anura Kumara',
    'Urgent',
    'vvvv',
    'vvv',
    '2021-05-27',
    'In Progress',
    'anurak',
    'RapidGnix'
  );
INSERT INTO
  `task_table` (
    `Id`,
    `EmpId`,
    `EmpName`,
    `Type`,
    `Title`,
    `Description`,
    `DueDate`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    17,
    'CON000021',
    'Anura Kamal Wickramasinghe',
    'Urgent',
    'bbb',
    'bbb',
    '2021-05-26',
    'Not Started',
    'admin',
    'ABC COMPANY PVT LTD'
  );
INSERT INTO
  `task_table` (
    `Id`,
    `EmpId`,
    `EmpName`,
    `Type`,
    `Title`,
    `Description`,
    `DueDate`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    18,
    'EMP000019',
    'Banuka perera',
    'Normal',
    'Collection Money',
    'Collection Money',
    '2021-05-31',
    'Not Started',
    'admin',
    'ABC COMPANY PVT LTD'
  );
INSERT INTO
  `task_table` (
    `Id`,
    `EmpId`,
    `EmpName`,
    `Type`,
    `Title`,
    `Description`,
    `DueDate`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    19,
    'CON000022',
    'Fahad Razzaq',
    'Normal',
    'Collections',
    'Collections',
    '2021-05-26',
    'Not Started',
    'admin',
    'ABC COMPANY PVT LTD'
  );
INSERT INTO
  `task_table` (
    `Id`,
    `EmpId`,
    `EmpName`,
    `Type`,
    `Title`,
    `Description`,
    `DueDate`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    20,
    'CON000022',
    'Fahad Razzaq',
    'Special',
    'Money colloection',
    'Money colloection',
    '2021-05-31',
    'In Progress',
    'admin',
    'ABC COMPANY PVT LTD'
  );
INSERT INTO
  `task_table` (
    `Id`,
    `EmpId`,
    `EmpName`,
    `Type`,
    `Title`,
    `Description`,
    `DueDate`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    21,
    'CON000030',
    'Tabitha Contee',
    'Normal',
    'August Base Pay Invoice ',
    'August Base Pay Invoice ',
    '2021-09-01',
    'Completed',
    'tconteeinvoices',
    'Billing Plus, Inc.'
  );
INSERT INTO
  `task_table` (
    `Id`,
    `EmpId`,
    `EmpName`,
    `Type`,
    `Title`,
    `Description`,
    `DueDate`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    22,
    'CON000031',
    'Covita Mills',
    'Normal',
    'August Base Pay Invoice ',
    'August Base Pay Invoice ',
    '2021-09-01',
    'Completed',
    'cmillsinvoices',
    'Billing Plus, Inc.'
  );
INSERT INTO
  `task_table` (
    `Id`,
    `EmpId`,
    `EmpName`,
    `Type`,
    `Title`,
    `Description`,
    `DueDate`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    23,
    'CON000032',
    'Sanora Wicker',
    'Normal',
    'August Base Pay Invoice ',
    'August Base Pay Invoice ',
    '2021-09-01',
    'Completed',
    'Ismith01',
    'Billing Plus, Inc.'
  );
INSERT INTO
  `task_table` (
    `Id`,
    `EmpId`,
    `EmpName`,
    `Type`,
    `Title`,
    `Description`,
    `DueDate`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    24,
    'CON000033',
    'Javon Young',
    'Normal',
    'August Base Pay Invoice ',
    'August Base Pay Invoice ',
    '2021-09-01',
    'Completed',
    'jyounginvoices',
    'Billing Plus, Inc.'
  );
INSERT INTO
  `task_table` (
    `Id`,
    `EmpId`,
    `EmpName`,
    `Type`,
    `Title`,
    `Description`,
    `DueDate`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    25,
    'CON000030',
    'Tabitha Contee',
    'Normal',
    'July % Invoice Due',
    'July % Invoice Due',
    '2021-09-22',
    'Not Started',
    'Ismith01',
    'Billing Plus, Inc.'
  );
INSERT INTO
  `task_table` (
    `Id`,
    `EmpId`,
    `EmpName`,
    `Type`,
    `Title`,
    `Description`,
    `DueDate`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    26,
    'CON000031',
    'Covita Mills',
    'Normal',
    'July % Invoice Due',
    'July % Invoice Due',
    '2021-09-22',
    'Not Started',
    'Ismith01',
    'Billing Plus, Inc.'
  );
INSERT INTO
  `task_table` (
    `Id`,
    `EmpId`,
    `EmpName`,
    `Type`,
    `Title`,
    `Description`,
    `DueDate`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    27,
    'CON000032',
    'Sanora Wicker',
    'Normal',
    'July % Invoice Due',
    'July % Invoice Due',
    '2021-09-22',
    'Not Started',
    'Ismith01',
    'Billing Plus, Inc.'
  );
INSERT INTO
  `task_table` (
    `Id`,
    `EmpId`,
    `EmpName`,
    `Type`,
    `Title`,
    `Description`,
    `DueDate`,
    `Status`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    28,
    'CON000033',
    'Javon Young',
    'Normal',
    'July % Invoice Due ',
    'July % Invoice Due (07/06/2021 to 07/31/2021 - see timeline for which providers',
    '2021-09-22',
    'Not Started',
    'Ismith01',
    'Billing Plus, Inc.'
  );

# ------------------------------------------------------------
# DATA DUMP FOR TABLE: user_access_permission_table
# ------------------------------------------------------------

INSERT INTO
  `user_access_permission_table` (
    `Id`,
    `UserName`,
    `DB`,
    `CP`,
    `COM`,
    `EM`,
    `ADD_CONT`,
    `ASSIGN_CONT`,
    `CM`,
    `COLL`,
    `INV`,
    `PMT`,
    `PS`,
    `TASK`,
    `DOC`,
    `USER`,
    `COLL_REPORT`,
    `INV_REPORT`,
    `BP_REPORT`,
    `PS_REPORT`,
    `CLIENT_REPORT`,
    `EMP_REPORT`,
    `SETTINGS`,
    `BACKUP`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    6,
    'admin  ',
    1,
    0,
    1,
    1,
    1,
    1,
    1,
    1,
    1,
    1,
    1,
    1,
    1,
    1,
    1,
    1,
    1,
    1,
    1,
    1,
    1,
    1,
    'admin',
    'ABC COMPANY PVT LTD'
  );
INSERT INTO
  `user_access_permission_table` (
    `Id`,
    `UserName`,
    `DB`,
    `CP`,
    `COM`,
    `EM`,
    `ADD_CONT`,
    `ASSIGN_CONT`,
    `CM`,
    `COLL`,
    `INV`,
    `PMT`,
    `PS`,
    `TASK`,
    `DOC`,
    `USER`,
    `COLL_REPORT`,
    `INV_REPORT`,
    `BP_REPORT`,
    `PS_REPORT`,
    `CLIENT_REPORT`,
    `EMP_REPORT`,
    `SETTINGS`,
    `BACKUP`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    30,
    'ss',
    0,
    0,
    1,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    'admin',
    ''
  );
INSERT INTO
  `user_access_permission_table` (
    `Id`,
    `UserName`,
    `DB`,
    `CP`,
    `COM`,
    `EM`,
    `ADD_CONT`,
    `ASSIGN_CONT`,
    `CM`,
    `COLL`,
    `INV`,
    `PMT`,
    `PS`,
    `TASK`,
    `DOC`,
    `USER`,
    `COLL_REPORT`,
    `INV_REPORT`,
    `BP_REPORT`,
    `PS_REPORT`,
    `CLIENT_REPORT`,
    `EMP_REPORT`,
    `SETTINGS`,
    `BACKUP`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    32,
    'bbbb',
    1,
    0,
    1,
    1,
    1,
    1,
    1,
    1,
    1,
    1,
    0,
    1,
    0,
    1,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    'bbbb',
    'ABC COMPANY PVT LTD'
  );
INSERT INTO
  `user_access_permission_table` (
    `Id`,
    `UserName`,
    `DB`,
    `CP`,
    `COM`,
    `EM`,
    `ADD_CONT`,
    `ASSIGN_CONT`,
    `CM`,
    `COLL`,
    `INV`,
    `PMT`,
    `PS`,
    `TASK`,
    `DOC`,
    `USER`,
    `COLL_REPORT`,
    `INV_REPORT`,
    `BP_REPORT`,
    `PS_REPORT`,
    `CLIENT_REPORT`,
    `EMP_REPORT`,
    `SETTINGS`,
    `BACKUP`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    33,
    'anurak',
    0,
    1,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    'admin',
    'RapidGnix'
  );
INSERT INTO
  `user_access_permission_table` (
    `Id`,
    `UserName`,
    `DB`,
    `CP`,
    `COM`,
    `EM`,
    `ADD_CONT`,
    `ASSIGN_CONT`,
    `CM`,
    `COLL`,
    `INV`,
    `PMT`,
    `PS`,
    `TASK`,
    `DOC`,
    `USER`,
    `COLL_REPORT`,
    `INV_REPORT`,
    `BP_REPORT`,
    `PS_REPORT`,
    `CLIENT_REPORT`,
    `EMP_REPORT`,
    `SETTINGS`,
    `BACKUP`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    35,
    'Fahad',
    0,
    1,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    'admin',
    'ABC COMPANY PVT LTD'
  );
INSERT INTO
  `user_access_permission_table` (
    `Id`,
    `UserName`,
    `DB`,
    `CP`,
    `COM`,
    `EM`,
    `ADD_CONT`,
    `ASSIGN_CONT`,
    `CM`,
    `COLL`,
    `INV`,
    `PMT`,
    `PS`,
    `TASK`,
    `DOC`,
    `USER`,
    `COLL_REPORT`,
    `INV_REPORT`,
    `BP_REPORT`,
    `PS_REPORT`,
    `CLIENT_REPORT`,
    `EMP_REPORT`,
    `SETTINGS`,
    `BACKUP`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    36,
    'nalakab',
    0,
    1,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    'admin',
    'Novar Flex Pvt Ltd'
  );
INSERT INTO
  `user_access_permission_table` (
    `Id`,
    `UserName`,
    `DB`,
    `CP`,
    `COM`,
    `EM`,
    `ADD_CONT`,
    `ASSIGN_CONT`,
    `CM`,
    `COLL`,
    `INV`,
    `PMT`,
    `PS`,
    `TASK`,
    `DOC`,
    `USER`,
    `COLL_REPORT`,
    `INV_REPORT`,
    `BP_REPORT`,
    `PS_REPORT`,
    `CLIENT_REPORT`,
    `EMP_REPORT`,
    `SETTINGS`,
    `BACKUP`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    37,
    'anurakw',
    0,
    1,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    'admin',
    'ABC COMPANY PVT LTD'
  );
INSERT INTO
  `user_access_permission_table` (
    `Id`,
    `UserName`,
    `DB`,
    `CP`,
    `COM`,
    `EM`,
    `ADD_CONT`,
    `ASSIGN_CONT`,
    `CM`,
    `COLL`,
    `INV`,
    `PMT`,
    `PS`,
    `TASK`,
    `DOC`,
    `USER`,
    `COLL_REPORT`,
    `INV_REPORT`,
    `BP_REPORT`,
    `PS_REPORT`,
    `CLIENT_REPORT`,
    `EMP_REPORT`,
    `SETTINGS`,
    `BACKUP`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    39,
    'banukap',
    0,
    1,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    'admin',
    'ABC COMPANY PVT LTD'
  );
INSERT INTO
  `user_access_permission_table` (
    `Id`,
    `UserName`,
    `DB`,
    `CP`,
    `COM`,
    `EM`,
    `ADD_CONT`,
    `ASSIGN_CONT`,
    `CM`,
    `COLL`,
    `INV`,
    `PMT`,
    `PS`,
    `TASK`,
    `DOC`,
    `USER`,
    `COLL_REPORT`,
    `INV_REPORT`,
    `BP_REPORT`,
    `PS_REPORT`,
    `CLIENT_REPORT`,
    `EMP_REPORT`,
    `SETTINGS`,
    `BACKUP`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    40,
    'Ismith',
    1,
    0,
    1,
    1,
    1,
    1,
    1,
    1,
    1,
    1,
    1,
    1,
    1,
    1,
    1,
    1,
    1,
    1,
    1,
    1,
    1,
    1,
    'Ismith',
    'ABC COMPANY PVT LTD'
  );
INSERT INTO
  `user_access_permission_table` (
    `Id`,
    `UserName`,
    `DB`,
    `CP`,
    `COM`,
    `EM`,
    `ADD_CONT`,
    `ASSIGN_CONT`,
    `CM`,
    `COLL`,
    `INV`,
    `PMT`,
    `PS`,
    `TASK`,
    `DOC`,
    `USER`,
    `COLL_REPORT`,
    `INV_REPORT`,
    `BP_REPORT`,
    `PS_REPORT`,
    `CLIENT_REPORT`,
    `EMP_REPORT`,
    `SETTINGS`,
    `BACKUP`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    41,
    'chanakap',
    1,
    0,
    1,
    1,
    1,
    1,
    1,
    1,
    1,
    1,
    1,
    1,
    1,
    1,
    1,
    1,
    1,
    1,
    1,
    1,
    1,
    1,
    'admin',
    'ABC COMPANY PVT LTD'
  );
INSERT INTO
  `user_access_permission_table` (
    `Id`,
    `UserName`,
    `DB`,
    `CP`,
    `COM`,
    `EM`,
    `ADD_CONT`,
    `ASSIGN_CONT`,
    `CM`,
    `COLL`,
    `INV`,
    `PMT`,
    `PS`,
    `TASK`,
    `DOC`,
    `USER`,
    `COLL_REPORT`,
    `INV_REPORT`,
    `BP_REPORT`,
    `PS_REPORT`,
    `CLIENT_REPORT`,
    `EMP_REPORT`,
    `SETTINGS`,
    `BACKUP`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    42,
    'FahadAdmin',
    1,
    0,
    1,
    1,
    1,
    1,
    1,
    1,
    1,
    1,
    1,
    1,
    1,
    1,
    1,
    1,
    1,
    1,
    1,
    1,
    1,
    1,
    'Ismith',
    'ABC COMPANY PVT LTD'
  );
INSERT INTO
  `user_access_permission_table` (
    `Id`,
    `UserName`,
    `DB`,
    `CP`,
    `COM`,
    `EM`,
    `ADD_CONT`,
    `ASSIGN_CONT`,
    `CM`,
    `COLL`,
    `INV`,
    `PMT`,
    `PS`,
    `TASK`,
    `DOC`,
    `USER`,
    `COLL_REPORT`,
    `INV_REPORT`,
    `BP_REPORT`,
    `PS_REPORT`,
    `CLIENT_REPORT`,
    `EMP_REPORT`,
    `SETTINGS`,
    `BACKUP`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    43,
    'Ismith01',
    1,
    0,
    1,
    1,
    1,
    1,
    1,
    1,
    1,
    1,
    1,
    1,
    1,
    1,
    1,
    1,
    1,
    1,
    1,
    1,
    1,
    1,
    'admin',
    'Billing Plus, Inc.'
  );
INSERT INTO
  `user_access_permission_table` (
    `Id`,
    `UserName`,
    `DB`,
    `CP`,
    `COM`,
    `EM`,
    `ADD_CONT`,
    `ASSIGN_CONT`,
    `CM`,
    `COLL`,
    `INV`,
    `PMT`,
    `PS`,
    `TASK`,
    `DOC`,
    `USER`,
    `COLL_REPORT`,
    `INV_REPORT`,
    `BP_REPORT`,
    `PS_REPORT`,
    `CLIENT_REPORT`,
    `EMP_REPORT`,
    `SETTINGS`,
    `BACKUP`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    44,
    'tconteeinvoices',
    0,
    1,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    'Ismith01',
    'ABC COMPANY PVT LTD'
  );
INSERT INTO
  `user_access_permission_table` (
    `Id`,
    `UserName`,
    `DB`,
    `CP`,
    `COM`,
    `EM`,
    `ADD_CONT`,
    `ASSIGN_CONT`,
    `CM`,
    `COLL`,
    `INV`,
    `PMT`,
    `PS`,
    `TASK`,
    `DOC`,
    `USER`,
    `COLL_REPORT`,
    `INV_REPORT`,
    `BP_REPORT`,
    `PS_REPORT`,
    `CLIENT_REPORT`,
    `EMP_REPORT`,
    `SETTINGS`,
    `BACKUP`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    45,
    'cmillsinvoices',
    0,
    1,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    'Ismith01',
    'Billing Plus, Inc.'
  );
INSERT INTO
  `user_access_permission_table` (
    `Id`,
    `UserName`,
    `DB`,
    `CP`,
    `COM`,
    `EM`,
    `ADD_CONT`,
    `ASSIGN_CONT`,
    `CM`,
    `COLL`,
    `INV`,
    `PMT`,
    `PS`,
    `TASK`,
    `DOC`,
    `USER`,
    `COLL_REPORT`,
    `INV_REPORT`,
    `BP_REPORT`,
    `PS_REPORT`,
    `CLIENT_REPORT`,
    `EMP_REPORT`,
    `SETTINGS`,
    `BACKUP`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    46,
    'jyounginvoices',
    0,
    1,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    'Ismith01',
    'Billing Plus, Inc.'
  );
INSERT INTO
  `user_access_permission_table` (
    `Id`,
    `UserName`,
    `DB`,
    `CP`,
    `COM`,
    `EM`,
    `ADD_CONT`,
    `ASSIGN_CONT`,
    `CM`,
    `COLL`,
    `INV`,
    `PMT`,
    `PS`,
    `TASK`,
    `DOC`,
    `USER`,
    `COLL_REPORT`,
    `INV_REPORT`,
    `BP_REPORT`,
    `PS_REPORT`,
    `CLIENT_REPORT`,
    `EMP_REPORT`,
    `SETTINGS`,
    `BACKUP`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    47,
    'swickerinvoices',
    0,
    1,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    'Ismith01',
    'Billing Plus, Inc.'
  );
INSERT INTO
  `user_access_permission_table` (
    `Id`,
    `UserName`,
    `DB`,
    `CP`,
    `COM`,
    `EM`,
    `ADD_CONT`,
    `ASSIGN_CONT`,
    `CM`,
    `COLL`,
    `INV`,
    `PMT`,
    `PS`,
    `TASK`,
    `DOC`,
    `USER`,
    `COLL_REPORT`,
    `INV_REPORT`,
    `BP_REPORT`,
    `PS_REPORT`,
    `CLIENT_REPORT`,
    `EMP_REPORT`,
    `SETTINGS`,
    `BACKUP`,
    `CreatedBy`,
    `CompanyName`
  )
VALUES
  (
    48,
    'tleeinvoices',
    0,
    1,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    'Ismith01',
    'Billing Plus, Inc.'
  );

# ------------------------------------------------------------
# DATA DUMP FOR TABLE: user_login_session_table
# ------------------------------------------------------------

INSERT INTO
  `user_login_session_table` (
    `Id`,
    `UserName`,
    `LoginDate`,
    `LoginTime`,
    `IsLogin`,
    `Status`
  )
VALUES
  (7, 'admin ', '2020-02-08', '07:56:36', 0, 'Logout');
INSERT INTO
  `user_login_session_table` (
    `Id`,
    `UserName`,
    `LoginDate`,
    `LoginTime`,
    `IsLogin`,
    `Status`
  )
VALUES
  (
    8,
    'wasanthak ',
    '2019-09-06',
    '05:57:00',
    0,
    'Logout'
  );
INSERT INTO
  `user_login_session_table` (
    `Id`,
    `UserName`,
    `LoginDate`,
    `LoginTime`,
    `IsLogin`,
    `Status`
  )
VALUES
  (
    9,
    'buddhikag ',
    '2019-09-07',
    '11:11:00',
    1,
    'Logged'
  );
INSERT INTO
  `user_login_session_table` (
    `Id`,
    `UserName`,
    `LoginDate`,
    `LoginTime`,
    `IsLogin`,
    `Status`
  )
VALUES
  (10, 'malakaH ', '2019-09-27', '11:35:44', 0, 'Logout');
INSERT INTO
  `user_login_session_table` (
    `Id`,
    `UserName`,
    `LoginDate`,
    `LoginTime`,
    `IsLogin`,
    `Status`
  )
VALUES
  (11, 'kamalk ', '2019-09-28', '08:44:59', 0, 'Logout');
INSERT INTO
  `user_login_session_table` (
    `Id`,
    `UserName`,
    `LoginDate`,
    `LoginTime`,
    `IsLogin`,
    `Status`
  )
VALUES
  (12, 'guest ', '2019-10-13', '12:51:20', 0, 'Logout');

# ------------------------------------------------------------
# DATA DUMP FOR TABLE: user_type_table
# ------------------------------------------------------------

INSERT INTO
  `user_type_table` (`Id`, `UserType`, `CreatedBy`, `CompanyName`)
VALUES
  (14, 'Manager', 'admin', '');
INSERT INTO
  `user_type_table` (`Id`, `UserType`, `CreatedBy`, `CompanyName`)
VALUES
  (15, 'Admin', 'admin', '');
INSERT INTO
  `user_type_table` (`Id`, `UserType`, `CreatedBy`, `CompanyName`)
VALUES
  (21, 'Cashier', 'admin', '');
INSERT INTO
  `user_type_table` (`Id`, `UserType`, `CreatedBy`, `CompanyName`)
VALUES
  (22, 'Designer', 'admin', '');
INSERT INTO
  `user_type_table` (`Id`, `UserType`, `CreatedBy`, `CompanyName`)
VALUES
  (24, 'ddd', 'admin', '');
INSERT INTO
  `user_type_table` (`Id`, `UserType`, `CreatedBy`, `CompanyName`)
VALUES
  (25, 'bbbb', 'admin', '');
INSERT INTO
  `user_type_table` (`Id`, `UserType`, `CreatedBy`, `CompanyName`)
VALUES
  (29, 'Contractor', 'admin', 'RapidGnix');
INSERT INTO
  `user_type_table` (`Id`, `UserType`, `CreatedBy`, `CompanyName`)
VALUES
  (30, 'Contractor', 'admin', 'ABC COMPANY PVT LTD');
INSERT INTO
  `user_type_table` (`Id`, `UserType`, `CreatedBy`, `CompanyName`)
VALUES
  (31, 'Contractor', 'admin', 'Novar Flex Pvt Ltd');
INSERT INTO
  `user_type_table` (`Id`, `UserType`, `CreatedBy`, `CompanyName`)
VALUES
  (32, 'Admin', 'admin', 'ABC COMPANY PVT LTD');
INSERT INTO
  `user_type_table` (`Id`, `UserType`, `CreatedBy`, `CompanyName`)
VALUES
  (33, 'Employee', 'admin', 'ABC COMPANY PVT LTD');
INSERT INTO
  `user_type_table` (`Id`, `UserType`, `CreatedBy`, `CompanyName`)
VALUES
  (35, 'Admin', 'admin', 'Billing Plus, Inc.');
INSERT INTO
  `user_type_table` (`Id`, `UserType`, `CreatedBy`, `CompanyName`)
VALUES
  (36, 'Contractor', 'Ismith01', 'Billing Plus, Inc.');

