INSERT INTO lr_transaction (`id`, `Hjtype`, `transaction_number`, `transaction_type`, `transaction_status`, `transaction_source`, `source_property_ids`, `target_property_ids`, `old_property_id`, `parent_property_ids`, `tenure_type`, `is_search_oldfile`, `registration_fee`, `consideration`, `interest_money`, `create_date`, `complete_date`, `start_date`, `expiration_date`, `sign_date`, `registration_date`, `application_date`, `firstpay_date`, `balance_date`, `balance_sum`, `partial`, `pageNumber`, `cert_nos`, `term_year`, `term_month`, `term_year_ext`, `term_month_ext`, `lease_extension`, `lease_duration`, `duration`, `build_term`, `build_value`, `pay_period_year`, `pay_period_month`, `volume`, `folio`, `volume_linked`, `folio_linked`, `recordingno`, `internal_receipt_no`, `serial_number`, `general_number`, `related_number`, `related_page_number`, `related_volume`, `deed_case`, `related_instr_number`, `lodgment_number`, `boxno`, `special_condition`, `inscription`, `inscription2`, `reg_initials`, `blockplot`, `volumefolio`, `filetype`, `region`, `district`, `is_delivered`, `is_right_required`, `is_inactive`, `is_mem_transaction`, `comments`, `site_analysis`, `inspection_officer`, `gis_params`, `tran1`, `tran2`, `tran_date1`, `tran_date2`, `tran_dict1`, `tran_dict2`, `tran_cost1`, `tran_cost2`, `tran_count1`, `tran_count2`, `version`, `begin_lifespan_version`, `end_lifespan_version`, `demandnotice_number`, `batch`, `transaction_index`, `term_day`, `consideration_currency`, `temp_consideration`, `improvement_amount_currency`, `data_corrected_transaction_number`, `data_corrected_transaction_type`, `data_corrected_comments`, `data_corrected_create_date`, `data_corrected_complete_date`, `recommendation_memorandum`, `SurveyPlan`) VALUES ('10000000001054', 'com.landsystems.lrs.model.Transaction', 'PLS000001054', '1', '24', '30', 'CofO14057', 'CofO14057', NULL, NULL, '1', 0, NULL, 0.0, NULL, '2014-12-10T16:01:38.297000', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 309.2, 0, NULL, NULL, NULL, NULL, NULL, NULL, '1', '1', NULL, 2, 22000.0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1', '557', '1', 0, 0, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1761', '1', NULL, NULL, NULL, NULL, '1', '2014-12-10T16:01:38.297000', NULL, NULL, '10000000000411', 0, NULL, '1', NULL, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO lr_transaction (`id`, `Hjtype`, `transaction_number`, `transaction_type`, `transaction_status`, `transaction_source`, `source_property_ids`, `target_property_ids`, `old_property_id`, `parent_property_ids`, `tenure_type`, `is_search_oldfile`, `registration_fee`, `consideration`, `interest_money`, `create_date`, `complete_date`, `start_date`, `expiration_date`, `sign_date`, `registration_date`, `application_date`, `firstpay_date`, `balance_date`, `balance_sum`, `partial`, `pageNumber`, `cert_nos`, `term_year`, `term_month`, `term_year_ext`, `term_month_ext`, `lease_extension`, `lease_duration`, `duration`, `build_term`, `build_value`, `pay_period_year`, `pay_period_month`, `volume`, `folio`, `volume_linked`, `folio_linked`, `recordingno`, `internal_receipt_no`, `serial_number`, `general_number`, `related_number`, `related_page_number`, `related_volume`, `deed_case`, `related_instr_number`, `lodgment_number`, `boxno`, `special_condition`, `inscription`, `inscription2`, `reg_initials`, `blockplot`, `volumefolio`, `filetype`, `region`, `district`, `is_delivered`, `is_right_required`, `is_inactive`, `is_mem_transaction`, `comments`, `site_analysis`, `inspection_officer`, `gis_params`, `tran1`, `tran2`, `tran_date1`, `tran_date2`, `tran_dict1`, `tran_dict2`, `tran_cost1`, `tran_cost2`, `tran_count1`, `tran_count2`, `version`, `begin_lifespan_version`, `end_lifespan_version`, `demandnotice_number`, `batch`, `transaction_index`, `term_day`, `consideration_currency`, `temp_consideration`, `improvement_amount_currency`, `data_corrected_transaction_number`, `data_corrected_transaction_type`, `data_corrected_comments`, `data_corrected_create_date`, `data_corrected_complete_date`, `recommendation_memorandum`, `SurveyPlan`) VALUES ('10000000001056', 'com.landsystems.lrs.model.Transaction', 'PLS000001056', '1', '24', '30', 'BP982', 'BP982', NULL, NULL, '1', 0, NULL, 0.0, NULL, '2014-12-10T16:02:37.423000', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 51.89, 0, NULL, NULL, NULL, NULL, NULL, NULL, '1', '1', NULL, 2, 10000.0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1', '557', '1', 0, 0, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1761', '1', NULL, NULL, NULL, NULL, '1', '2014-12-10T16:02:37.407000', NULL, NULL, '10000000000412', 0, NULL, '1', NULL, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO lr_transaction (`id`, `Hjtype`, `transaction_number`, `transaction_type`, `transaction_status`, `transaction_source`, `source_property_ids`, `target_property_ids`, `old_property_id`, `parent_property_ids`, `tenure_type`, `is_search_oldfile`, `registration_fee`, `consideration`, `interest_money`, `create_date`, `complete_date`, `start_date`, `expiration_date`, `sign_date`, `registration_date`, `application_date`, `firstpay_date`, `balance_date`, `balance_sum`, `partial`, `pageNumber`, `cert_nos`, `term_year`, `term_month`, `term_year_ext`, `term_month_ext`, `lease_extension`, `lease_duration`, `duration`, `build_term`, `build_value`, `pay_period_year`, `pay_period_month`, `volume`, `folio`, `volume_linked`, `folio_linked`, `recordingno`, `internal_receipt_no`, `serial_number`, `general_number`, `related_number`, `related_page_number`, `related_volume`, `deed_case`, `related_instr_number`, `lodgment_number`, `boxno`, `special_condition`, `inscription`, `inscription2`, `reg_initials`, `blockplot`, `volumefolio`, `filetype`, `region`, `district`, `is_delivered`, `is_right_required`, `is_inactive`, `is_mem_transaction`, `comments`, `site_analysis`, `inspection_officer`, `gis_params`, `tran1`, `tran2`, `tran_date1`, `tran_date2`, `tran_dict1`, `tran_dict2`, `tran_cost1`, `tran_cost2`, `tran_count1`, `tran_count2`, `version`, `begin_lifespan_version`, `end_lifespan_version`, `demandnotice_number`, `batch`, `transaction_index`, `term_day`, `consideration_currency`, `temp_consideration`, `improvement_amount_currency`, `data_corrected_transaction_number`, `data_corrected_transaction_type`, `data_corrected_comments`, `data_corrected_create_date`, `data_corrected_complete_date`, `recommendation_memorandum`, `SurveyPlan`) VALUES ('10000000001057', 'com.landsystems.lrs.model.Transaction', 'P-PLS000000644', '5', '24', '31', 'BP3501', 'BP3501', NULL, NULL, '1', 0, NULL, NULL, NULL, '2014-12-10T16:03:15.627000', NULL, '1979-02-13T00:00:00', '2019-02-12T00:00:00', '1979-02-02T00:00:00', '1979-02-02T00:00:00', '1975-06-23T00:00:00', NULL, NULL, 59.72, 0, NULL, NULL, 40, NULL, NULL, NULL, '1', '1', NULL, 2, 20000.0, 5, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1', '557', '1', 1, 0, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1', '1', NULL, NULL, NULL, NULL, '1', '2014-12-10T16:03:15.610000', NULL, NULL, '10000000000406', 1, NULL, '1', NULL, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO lr_transaction (`id`, `Hjtype`, `transaction_number`, `transaction_type`, `transaction_status`, `transaction_source`, `source_property_ids`, `target_property_ids`, `old_property_id`, `parent_property_ids`, `tenure_type`, `is_search_oldfile`, `registration_fee`, `consideration`, `interest_money`, `create_date`, `complete_date`, `start_date`, `expiration_date`, `sign_date`, `registration_date`, `application_date`, `firstpay_date`, `balance_date`, `balance_sum`, `partial`, `pageNumber`, `cert_nos`, `term_year`, `term_month`, `term_year_ext`, `term_month_ext`, `lease_extension`, `lease_duration`, `duration`, `build_term`, `build_value`, `pay_period_year`, `pay_period_month`, `volume`, `folio`, `volume_linked`, `folio_linked`, `recordingno`, `internal_receipt_no`, `serial_number`, `general_number`, `related_number`, `related_page_number`, `related_volume`, `deed_case`, `related_instr_number`, `lodgment_number`, `boxno`, `special_condition`, `inscription`, `inscription2`, `reg_initials`, `blockplot`, `volumefolio`, `filetype`, `region`, `district`, `is_delivered`, `is_right_required`, `is_inactive`, `is_mem_transaction`, `comments`, `site_analysis`, `inspection_officer`, `gis_params`, `tran1`, `tran2`, `tran_date1`, `tran_date2`, `tran_dict1`, `tran_dict2`, `tran_cost1`, `tran_cost2`, `tran_count1`, `tran_count2`, `version`, `begin_lifespan_version`, `end_lifespan_version`, `demandnotice_number`, `batch`, `transaction_index`, `term_day`, `consideration_currency`, `temp_consideration`, `improvement_amount_currency`, `data_corrected_transaction_number`, `data_corrected_transaction_type`, `data_corrected_comments`, `data_corrected_create_date`, `data_corrected_complete_date`, `recommendation_memorandum`, `SurveyPlan`) VALUES ('10000000001058', 'com.landsystems.lrs.model.Transaction', 'PLS000001058', '1', '24', '30', 'RofO11350', 'RofO11350', NULL, NULL, '1', 0, NULL, 0.0, NULL, '2014-12-10T16:03:47.393000', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 2.0, 0, NULL, NULL, NULL, NULL, NULL, NULL, '1', '1', NULL, 2, 400.0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1', '557', '1', 0, 0, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1761', '1', NULL, NULL, NULL, NULL, '1', '2014-12-10T16:03:47.377000', NULL, NULL, '10000000000413', 0, NULL, '1', NULL, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO lr_transaction (`id`, `Hjtype`, `transaction_number`, `transaction_type`, `transaction_status`, `transaction_source`, `source_property_ids`, `target_property_ids`, `old_property_id`, `parent_property_ids`, `tenure_type`, `is_search_oldfile`, `registration_fee`, `consideration`, `interest_money`, `create_date`, `complete_date`, `start_date`, `expiration_date`, `sign_date`, `registration_date`, `application_date`, `firstpay_date`, `balance_date`, `balance_sum`, `partial`, `pageNumber`, `cert_nos`, `term_year`, `term_month`, `term_year_ext`, `term_month_ext`, `lease_extension`, `lease_duration`, `duration`, `build_term`, `build_value`, `pay_period_year`, `pay_period_month`, `volume`, `folio`, `volume_linked`, `folio_linked`, `recordingno`, `internal_receipt_no`, `serial_number`, `general_number`, `related_number`, `related_page_number`, `related_volume`, `deed_case`, `related_instr_number`, `lodgment_number`, `boxno`, `special_condition`, `inscription`, `inscription2`, `reg_initials`, `blockplot`, `volumefolio`, `filetype`, `region`, `district`, `is_delivered`, `is_right_required`, `is_inactive`, `is_mem_transaction`, `comments`, `site_analysis`, `inspection_officer`, `gis_params`, `tran1`, `tran2`, `tran_date1`, `tran_date2`, `tran_dict1`, `tran_dict2`, `tran_cost1`, `tran_cost2`, `tran_count1`, `tran_count2`, `version`, `begin_lifespan_version`, `end_lifespan_version`, `demandnotice_number`, `batch`, `transaction_index`, `term_day`, `consideration_currency`, `temp_consideration`, `improvement_amount_currency`, `data_corrected_transaction_number`, `data_corrected_transaction_type`, `data_corrected_comments`, `data_corrected_create_date`, `data_corrected_complete_date`, `recommendation_memorandum`, `SurveyPlan`) VALUES ('10000000001059', 'com.landsystems.lrs.model.Transaction', 'PLS000001059', '1', '24', '30', 'CofO14192', 'CofO14192', NULL, NULL, '1', 0, NULL, 0.0, NULL, '2014-12-10T16:04:10.270000', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 14.0, 0, NULL, NULL, NULL, NULL, NULL, NULL, '1', '1', NULL, NULL, 200.0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1', '557', '1', 0, 0, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1761', '1', NULL, NULL, NULL, NULL, '1', '2014-12-10T16:04:10.253000', NULL, NULL, '10000000000414', 0, NULL, '1', NULL, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO lr_transaction (`id`, `Hjtype`, `transaction_number`, `transaction_type`, `transaction_status`, `transaction_source`, `source_property_ids`, `target_property_ids`, `old_property_id`, `parent_property_ids`, `tenure_type`, `is_search_oldfile`, `registration_fee`, `consideration`, `interest_money`, `create_date`, `complete_date`, `start_date`, `expiration_date`, `sign_date`, `registration_date`, `application_date`, `firstpay_date`, `balance_date`, `balance_sum`, `partial`, `pageNumber`, `cert_nos`, `term_year`, `term_month`, `term_year_ext`, `term_month_ext`, `lease_extension`, `lease_duration`, `duration`, `build_term`, `build_value`, `pay_period_year`, `pay_period_month`, `volume`, `folio`, `volume_linked`, `folio_linked`, `recordingno`, `internal_receipt_no`, `serial_number`, `general_number`, `related_number`, `related_page_number`, `related_volume`, `deed_case`, `related_instr_number`, `lodgment_number`, `boxno`, `special_condition`, `inscription`, `inscription2`, `reg_initials`, `blockplot`, `volumefolio`, `filetype`, `region`, `district`, `is_delivered`, `is_right_required`, `is_inactive`, `is_mem_transaction`, `comments`, `site_analysis`, `inspection_officer`, `gis_params`, `tran1`, `tran2`, `tran_date1`, `tran_date2`, `tran_dict1`, `tran_dict2`, `tran_cost1`, `tran_cost2`, `tran_count1`, `tran_count2`, `version`, `begin_lifespan_version`, `end_lifespan_version`, `demandnotice_number`, `batch`, `transaction_index`, `term_day`, `consideration_currency`, `temp_consideration`, `improvement_amount_currency`, `data_corrected_transaction_number`, `data_corrected_transaction_type`, `data_corrected_comments`, `data_corrected_create_date`, `data_corrected_complete_date`, `recommendation_memorandum`, `SurveyPlan`) VALUES ('10000000001060', 'com.landsystems.lrs.model.Transaction', 'P-PLS000000645', '5', '24', '31', 'BP2477', 'BP2477', NULL, NULL, '1', 0, NULL, NULL, NULL, '2014-12-10T16:06:23.603000', NULL, '1980-11-10T00:00:00', '2020-11-09T00:00:00', '1980-08-05T00:00:00', '1980-08-05T00:00:00', '1974-08-08T00:00:00', NULL, NULL, 66.0, 0, NULL, NULL, 40, NULL, NULL, NULL, '1', '1', NULL, 2, 30000.0, 5, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1', '557', '1', 1, 0, 0, 0, 'Execution date and registration date not found', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1', '1', NULL, NULL, NULL, NULL, '1', '2014-12-10T16:06:23.603000', NULL, NULL, '10000000000410', 1, NULL, '1', NULL, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO lr_transaction (`id`, `Hjtype`, `transaction_number`, `transaction_type`, `transaction_status`, `transaction_source`, `source_property_ids`, `target_property_ids`, `old_property_id`, `parent_property_ids`, `tenure_type`, `is_search_oldfile`, `registration_fee`, `consideration`, `interest_money`, `create_date`, `complete_date`, `start_date`, `expiration_date`, `sign_date`, `registration_date`, `application_date`, `firstpay_date`, `balance_date`, `balance_sum`, `partial`, `pageNumber`, `cert_nos`, `term_year`, `term_month`, `term_year_ext`, `term_month_ext`, `lease_extension`, `lease_duration`, `duration`, `build_term`, `build_value`, `pay_period_year`, `pay_period_month`, `volume`, `folio`, `volume_linked`, `folio_linked`, `recordingno`, `internal_receipt_no`, `serial_number`, `general_number`, `related_number`, `related_page_number`, `related_volume`, `deed_case`, `related_instr_number`, `lodgment_number`, `boxno`, `special_condition`, `inscription`, `inscription2`, `reg_initials`, `blockplot`, `volumefolio`, `filetype`, `region`, `district`, `is_delivered`, `is_right_required`, `is_inactive`, `is_mem_transaction`, `comments`, `site_analysis`, `inspection_officer`, `gis_params`, `tran1`, `tran2`, `tran_date1`, `tran_date2`, `tran_dict1`, `tran_dict2`, `tran_cost1`, `tran_cost2`, `tran_count1`, `tran_count2`, `version`, `begin_lifespan_version`, `end_lifespan_version`, `demandnotice_number`, `batch`, `transaction_index`, `term_day`, `consideration_currency`, `temp_consideration`, `improvement_amount_currency`, `data_corrected_transaction_number`, `data_corrected_transaction_type`, `data_corrected_comments`, `data_corrected_create_date`, `data_corrected_complete_date`, `recommendation_memorandum`, `SurveyPlan`) VALUES ('10000000001061', 'com.landsystems.lrs.model.Transaction', 'P-PLS000000646', '5', '25', '31', 'BP3573', 'BP3573', NULL, NULL, '1', 0, NULL, NULL, NULL, '2014-12-10T16:07:11.933000', NULL, '1984-10-18T00:00:00', '2083-10-17T00:00:00', '1984-10-17T00:00:00', '1984-10-17T00:00:00', '1975-05-26T00:00:00', NULL, NULL, 150.0, 0, NULL, NULL, 99, NULL, NULL, NULL, '1', '1', NULL, 2, 30000.0, 5, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1', '557', '1', 1, 0, 0, 0, 'Note, execution date not found. issue date of R of O used instead.', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1', '1', NULL, NULL, NULL, NULL, '1', '2014-12-10T16:07:11.933000', NULL, NULL, '10000000000407', 1, NULL, '1', NULL, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO lr_transaction (`id`, `Hjtype`, `transaction_number`, `transaction_type`, `transaction_status`, `transaction_source`, `source_property_ids`, `target_property_ids`, `old_property_id`, `parent_property_ids`, `tenure_type`, `is_search_oldfile`, `registration_fee`, `consideration`, `interest_money`, `create_date`, `complete_date`, `start_date`, `expiration_date`, `sign_date`, `registration_date`, `application_date`, `firstpay_date`, `balance_date`, `balance_sum`, `partial`, `pageNumber`, `cert_nos`, `term_year`, `term_month`, `term_year_ext`, `term_month_ext`, `lease_extension`, `lease_duration`, `duration`, `build_term`, `build_value`, `pay_period_year`, `pay_period_month`, `volume`, `folio`, `volume_linked`, `folio_linked`, `recordingno`, `internal_receipt_no`, `serial_number`, `general_number`, `related_number`, `related_page_number`, `related_volume`, `deed_case`, `related_instr_number`, `lodgment_number`, `boxno`, `special_condition`, `inscription`, `inscription2`, `reg_initials`, `blockplot`, `volumefolio`, `filetype`, `region`, `district`, `is_delivered`, `is_right_required`, `is_inactive`, `is_mem_transaction`, `comments`, `site_analysis`, `inspection_officer`, `gis_params`, `tran1`, `tran2`, `tran_date1`, `tran_date2`, `tran_dict1`, `tran_dict2`, `tran_cost1`, `tran_cost2`, `tran_count1`, `tran_count2`, `version`, `begin_lifespan_version`, `end_lifespan_version`, `demandnotice_number`, `batch`, `transaction_index`, `term_day`, `consideration_currency`, `temp_consideration`, `improvement_amount_currency`, `data_corrected_transaction_number`, `data_corrected_transaction_type`, `data_corrected_comments`, `data_corrected_create_date`, `data_corrected_complete_date`, `recommendation_memorandum`, `SurveyPlan`) VALUES ('10000000001062', 'com.landsystems.lrs.model.Transaction', 'P-PLS000000647', '5', '24', '31', 'BP614', 'BP614', NULL, NULL, '1', 0, NULL, NULL, NULL, '2014-12-10T16:08:03.263000', NULL, '1971-07-20T00:00:00', '2070-07-19T00:00:00', '1971-05-20T00:00:00', '1971-05-20T00:00:00', '1970-06-10T00:00:00', NULL, NULL, 34.425, 0, NULL, NULL, 99, NULL, NULL, NULL, '1', '1', NULL, 2, 3000.0, 5, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1', '557', '1', 1, 0, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1', '1', NULL, NULL, NULL, NULL, '1', '2014-12-10T16:08:03.263000', NULL, NULL, '10000000000408', 1, NULL, '1', NULL, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO lr_transaction (`id`, `Hjtype`, `transaction_number`, `transaction_type`, `transaction_status`, `transaction_source`, `source_property_ids`, `target_property_ids`, `old_property_id`, `parent_property_ids`, `tenure_type`, `is_search_oldfile`, `registration_fee`, `consideration`, `interest_money`, `create_date`, `complete_date`, `start_date`, `expiration_date`, `sign_date`, `registration_date`, `application_date`, `firstpay_date`, `balance_date`, `balance_sum`, `partial`, `pageNumber`, `cert_nos`, `term_year`, `term_month`, `term_year_ext`, `term_month_ext`, `lease_extension`, `lease_duration`, `duration`, `build_term`, `build_value`, `pay_period_year`, `pay_period_month`, `volume`, `folio`, `volume_linked`, `folio_linked`, `recordingno`, `internal_receipt_no`, `serial_number`, `general_number`, `related_number`, `related_page_number`, `related_volume`, `deed_case`, `related_instr_number`, `lodgment_number`, `boxno`, `special_condition`, `inscription`, `inscription2`, `reg_initials`, `blockplot`, `volumefolio`, `filetype`, `region`, `district`, `is_delivered`, `is_right_required`, `is_inactive`, `is_mem_transaction`, `comments`, `site_analysis`, `inspection_officer`, `gis_params`, `tran1`, `tran2`, `tran_date1`, `tran_date2`, `tran_dict1`, `tran_dict2`, `tran_cost1`, `tran_cost2`, `tran_count1`, `tran_count2`, `version`, `begin_lifespan_version`, `end_lifespan_version`, `demandnotice_number`, `batch`, `transaction_index`, `term_day`, `consideration_currency`, `temp_consideration`, `improvement_amount_currency`, `data_corrected_transaction_number`, `data_corrected_transaction_type`, `data_corrected_comments`, `data_corrected_create_date`, `data_corrected_complete_date`, `recommendation_memorandum`, `SurveyPlan`) VALUES ('10000000001063', 'com.landsystems.lrs.model.Transaction', 'P-PLS000000648', '3', '24', '31', 'BP3501', 'BP3501', NULL, NULL, '1', 0, NULL, NULL, NULL, '2014-12-10T16:08:13.137000', NULL, '1979-02-13T00:00:00', '2019-02-12T00:00:00', '1979-09-19T00:00:00', '1979-09-20T00:00:00', NULL, NULL, NULL, 59.72, 0, NULL, NULL, 40, NULL, NULL, NULL, '1', '1', NULL, 2, 20000.0, 5, NULL, '1(CofO)', '546', NULL, NULL, '546', NULL, NULL, NULL, 'P-PLS000000644', NULL, NULL, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1', '557', '1', 1, 0, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1', '1', NULL, NULL, NULL, NULL, '1', '2014-12-10T16:08:13.137000', NULL, NULL, '10000000000406', 2, NULL, '1', NULL, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO lr_transaction (`id`, `Hjtype`, `transaction_number`, `transaction_type`, `transaction_status`, `transaction_source`, `source_property_ids`, `target_property_ids`, `old_property_id`, `parent_property_ids`, `tenure_type`, `is_search_oldfile`, `registration_fee`, `consideration`, `interest_money`, `create_date`, `complete_date`, `start_date`, `expiration_date`, `sign_date`, `registration_date`, `application_date`, `firstpay_date`, `balance_date`, `balance_sum`, `partial`, `pageNumber`, `cert_nos`, `term_year`, `term_month`, `term_year_ext`, `term_month_ext`, `lease_extension`, `lease_duration`, `duration`, `build_term`, `build_value`, `pay_period_year`, `pay_period_month`, `volume`, `folio`, `volume_linked`, `folio_linked`, `recordingno`, `internal_receipt_no`, `serial_number`, `general_number`, `related_number`, `related_page_number`, `related_volume`, `deed_case`, `related_instr_number`, `lodgment_number`, `boxno`, `special_condition`, `inscription`, `inscription2`, `reg_initials`, `blockplot`, `volumefolio`, `filetype`, `region`, `district`, `is_delivered`, `is_right_required`, `is_inactive`, `is_mem_transaction`, `comments`, `site_analysis`, `inspection_officer`, `gis_params`, `tran1`, `tran2`, `tran_date1`, `tran_date2`, `tran_dict1`, `tran_dict2`, `tran_cost1`, `tran_cost2`, `tran_count1`, `tran_count2`, `version`, `begin_lifespan_version`, `end_lifespan_version`, `demandnotice_number`, `batch`, `transaction_index`, `term_day`, `consideration_currency`, `temp_consideration`, `improvement_amount_currency`, `data_corrected_transaction_number`, `data_corrected_transaction_type`, `data_corrected_comments`, `data_corrected_create_date`, `data_corrected_complete_date`, `recommendation_memorandum`, `SurveyPlan`) VALUES ('10000000001064', 'com.landsystems.lrs.model.Transaction', 'P-PLS000000649', '5', '24', '31', 'BP2680', 'BP2680', NULL, NULL, '1', 0, NULL, NULL, NULL, '2014-12-10T16:09:33.097000', NULL, '1975-09-02T00:00:00', '1995-09-01T00:00:00', '1975-07-21T00:00:00', '1975-07-21T00:00:00', '1975-11-28T00:00:00', NULL, NULL, 15.2, 0, NULL, NULL, 20, NULL, NULL, NULL, '1', '1', NULL, 3, 20000.0, 5, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1', '557', '1', 1, 0, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1', '1', NULL, NULL, NULL, NULL, '1', '2014-12-10T16:09:33.097000', NULL, NULL, '10000000000409', 1, NULL, '1', NULL, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO lr_transaction (`id`, `Hjtype`, `transaction_number`, `transaction_type`, `transaction_status`, `transaction_source`, `source_property_ids`, `target_property_ids`, `old_property_id`, `parent_property_ids`, `tenure_type`, `is_search_oldfile`, `registration_fee`, `consideration`, `interest_money`, `create_date`, `complete_date`, `start_date`, `expiration_date`, `sign_date`, `registration_date`, `application_date`, `firstpay_date`, `balance_date`, `balance_sum`, `partial`, `pageNumber`, `cert_nos`, `term_year`, `term_month`, `term_year_ext`, `term_month_ext`, `lease_extension`, `lease_duration`, `duration`, `build_term`, `build_value`, `pay_period_year`, `pay_period_month`, `volume`, `folio`, `volume_linked`, `folio_linked`, `recordingno`, `internal_receipt_no`, `serial_number`, `general_number`, `related_number`, `related_page_number`, `related_volume`, `deed_case`, `related_instr_number`, `lodgment_number`, `boxno`, `special_condition`, `inscription`, `inscription2`, `reg_initials`, `blockplot`, `volumefolio`, `filetype`, `region`, `district`, `is_delivered`, `is_right_required`, `is_inactive`, `is_mem_transaction`, `comments`, `site_analysis`, `inspection_officer`, `gis_params`, `tran1`, `tran2`, `tran_date1`, `tran_date2`, `tran_dict1`, `tran_dict2`, `tran_cost1`, `tran_cost2`, `tran_count1`, `tran_count2`, `version`, `begin_lifespan_version`, `end_lifespan_version`, `demandnotice_number`, `batch`, `transaction_index`, `term_day`, `consideration_currency`, `temp_consideration`, `improvement_amount_currency`, `data_corrected_transaction_number`, `data_corrected_transaction_type`, `data_corrected_comments`, `data_corrected_create_date`, `data_corrected_complete_date`, `recommendation_memorandum`, `SurveyPlan`) VALUES ('10000000001066', 'com.landsystems.lrs.model.Transaction', 'P-PLS000000651', '5', '24', '31', 'CofO14057', 'CofO14057', NULL, NULL, '1', 0, NULL, NULL, NULL, '2014-12-10T16:11:11.880000', NULL, '1965-11-11T00:00:00', '2001-10-31T00:00:00', '1965-09-30T00:00:00', '1965-09-30T00:00:00', '1964-12-16T00:00:00', NULL, NULL, 309.2, 0, NULL, NULL, 35, 11, NULL, NULL, '1', '1', NULL, 2, 22000.0, 5, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, NULL, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1', '557', '1', 1, 0, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1', '1', NULL, NULL, NULL, NULL, '1', '2014-12-10T16:11:11.880000', NULL, NULL, '10000000000411', 1, 21, '1', NULL, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO lr_transaction (`id`, `Hjtype`, `transaction_number`, `transaction_type`, `transaction_status`, `transaction_source`, `source_property_ids`, `target_property_ids`, `old_property_id`, `parent_property_ids`, `tenure_type`, `is_search_oldfile`, `registration_fee`, `consideration`, `interest_money`, `create_date`, `complete_date`, `start_date`, `expiration_date`, `sign_date`, `registration_date`, `application_date`, `firstpay_date`, `balance_date`, `balance_sum`, `partial`, `pageNumber`, `cert_nos`, `term_year`, `term_month`, `term_year_ext`, `term_month_ext`, `lease_extension`, `lease_duration`, `duration`, `build_term`, `build_value`, `pay_period_year`, `pay_period_month`, `volume`, `folio`, `volume_linked`, `folio_linked`, `recordingno`, `internal_receipt_no`, `serial_number`, `general_number`, `related_number`, `related_page_number`, `related_volume`, `deed_case`, `related_instr_number`, `lodgment_number`, `boxno`, `special_condition`, `inscription`, `inscription2`, `reg_initials`, `blockplot`, `volumefolio`, `filetype`, `region`, `district`, `is_delivered`, `is_right_required`, `is_inactive`, `is_mem_transaction`, `comments`, `site_analysis`, `inspection_officer`, `gis_params`, `tran1`, `tran2`, `tran_date1`, `tran_date2`, `tran_dict1`, `tran_dict2`, `tran_cost1`, `tran_cost2`, `tran_count1`, `tran_count2`, `version`, `begin_lifespan_version`, `end_lifespan_version`, `demandnotice_number`, `batch`, `transaction_index`, `term_day`, `consideration_currency`, `temp_consideration`, `improvement_amount_currency`, `data_corrected_transaction_number`, `data_corrected_transaction_type`, `data_corrected_comments`, `data_corrected_create_date`, `data_corrected_complete_date`, `recommendation_memorandum`, `SurveyPlan`) VALUES ('10000000001068', 'com.landsystems.lrs.model.Transaction', 'PLS000001068', '1', '24', '30', 'BP3557', 'BP3557', NULL, NULL, '1', 0, NULL, 0.0, NULL, '2014-12-10T16:13:27.293000', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 64.33, 0, NULL, NULL, NULL, NULL, NULL, NULL, '1', '1', NULL, 2, 20000.0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1', '557', '1', 0, 0, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1761', '1', NULL, NULL, NULL, NULL, '1', '2014-12-10T16:13:27.293000', NULL, NULL, '10000000000415', 0, NULL, '1', NULL, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO lr_transaction (`id`, `Hjtype`, `transaction_number`, `transaction_type`, `transaction_status`, `transaction_source`, `source_property_ids`, `target_property_ids`, `old_property_id`, `parent_property_ids`, `tenure_type`, `is_search_oldfile`, `registration_fee`, `consideration`, `interest_money`, `create_date`, `complete_date`, `start_date`, `expiration_date`, `sign_date`, `registration_date`, `application_date`, `firstpay_date`, `balance_date`, `balance_sum`, `partial`, `pageNumber`, `cert_nos`, `term_year`, `term_month`, `term_year_ext`, `term_month_ext`, `lease_extension`, `lease_duration`, `duration`, `build_term`, `build_value`, `pay_period_year`, `pay_period_month`, `volume`, `folio`, `volume_linked`, `folio_linked`, `recordingno`, `internal_receipt_no`, `serial_number`, `general_number`, `related_number`, `related_page_number`, `related_volume`, `deed_case`, `related_instr_number`, `lodgment_number`, `boxno`, `special_condition`, `inscription`, `inscription2`, `reg_initials`, `blockplot`, `volumefolio`, `filetype`, `region`, `district`, `is_delivered`, `is_right_required`, `is_inactive`, `is_mem_transaction`, `comments`, `site_analysis`, `inspection_officer`, `gis_params`, `tran1`, `tran2`, `tran_date1`, `tran_date2`, `tran_dict1`, `tran_dict2`, `tran_cost1`, `tran_cost2`, `tran_count1`, `tran_count2`, `version`, `begin_lifespan_version`, `end_lifespan_version`, `demandnotice_number`, `batch`, `transaction_index`, `term_day`, `consideration_currency`, `temp_consideration`, `improvement_amount_currency`, `data_corrected_transaction_number`, `data_corrected_transaction_type`, `data_corrected_comments`, `data_corrected_create_date`, `data_corrected_complete_date`, `recommendation_memorandum`, `SurveyPlan`) VALUES ('10000000001069', 'com.landsystems.lrs.model.Transaction', 'P-PLS000000653', '5', '24', '31', 'CofO14192', 'CofO14192', NULL, NULL, '1', 0, NULL, NULL, NULL, '2014-12-10T16:13:42.543000', NULL, '1965-12-22T00:00:00', '2006-04-11T00:00:00', '1965-12-04T00:00:00', '1965-12-04T00:00:00', '1965-05-13T00:00:00', NULL, NULL, 14.0, 0, NULL, NULL, 40, 3, NULL, NULL, '1', '1', NULL, 2, 200.0, 5, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1', '557', '1', 1, 0, 0, 0, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1', '1', NULL, NULL, NULL, NULL, '1', '2014-12-10T16:13:42.527000', NULL, NULL, '10000000000414', 1, 21, '2222', NULL, '2222', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO lr_transaction (`id`, `Hjtype`, `transaction_number`, `transaction_type`, `transaction_status`, `transaction_source`, `source_property_ids`, `target_property_ids`, `old_property_id`, `parent_property_ids`, `tenure_type`, `is_search_oldfile`, `registration_fee`, `consideration`, `interest_money`, `create_date`, `complete_date`, `start_date`, `expiration_date`, `sign_date`, `registration_date`, `application_date`, `firstpay_date`, `balance_date`, `balance_sum`, `partial`, `pageNumber`, `cert_nos`, `term_year`, `term_month`, `term_year_ext`, `term_month_ext`, `lease_extension`, `lease_duration`, `duration`, `build_term`, `build_value`, `pay_period_year`, `pay_period_month`, `volume`, `folio`, `volume_linked`, `folio_linked`, `recordingno`, `internal_receipt_no`, `serial_number`, `general_number`, `related_number`, `related_page_number`, `related_volume`, `deed_case`, `related_instr_number`, `lodgment_number`, `boxno`, `special_condition`, `inscription`, `inscription2`, `reg_initials`, `blockplot`, `volumefolio`, `filetype`, `region`, `district`, `is_delivered`, `is_right_required`, `is_inactive`, `is_mem_transaction`, `comments`, `site_analysis`, `inspection_officer`, `gis_params`, `tran1`, `tran2`, `tran_date1`, `tran_date2`, `tran_dict1`, `tran_dict2`, `tran_cost1`, `tran_cost2`, `tran_count1`, `tran_count2`, `version`, `begin_lifespan_version`, `end_lifespan_version`, `demandnotice_number`, `batch`, `transaction_index`, `term_day`, `consideration_currency`, `temp_consideration`, `improvement_amount_currency`, `data_corrected_transaction_number`, `data_corrected_transaction_type`, `data_corrected_comments`, `data_corrected_create_date`, `data_corrected_complete_date`, `recommendation_memorandum`, `SurveyPlan`) VALUES ('10000000001070', 'com.landsystems.lrs.model.Transaction', 'PLS000001070', '1', '24', '30', 'CofO11338', 'CofO11338', NULL, NULL, '1', 0, NULL, 0.0, NULL, '2014-12-10T16:13:46.903000', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0.16, 0, NULL, NULL, NULL, NULL, NULL, NULL, '1', '1', NULL, 2, 150.0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1', '557', '1', 0, 0, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1761', '1', NULL, NULL, NULL, NULL, '1', '2014-12-10T16:13:46.903000', NULL, NULL, '10000000000416', 0, NULL, '1', NULL, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO lr_transaction (`id`, `Hjtype`, `transaction_number`, `transaction_type`, `transaction_status`, `transaction_source`, `source_property_ids`, `target_property_ids`, `old_property_id`, `parent_property_ids`, `tenure_type`, `is_search_oldfile`, `registration_fee`, `consideration`, `interest_money`, `create_date`, `complete_date`, `start_date`, `expiration_date`, `sign_date`, `registration_date`, `application_date`, `firstpay_date`, `balance_date`, `balance_sum`, `partial`, `pageNumber`, `cert_nos`, `term_year`, `term_month`, `term_year_ext`, `term_month_ext`, `lease_extension`, `lease_duration`, `duration`, `build_term`, `build_value`, `pay_period_year`, `pay_period_month`, `volume`, `folio`, `volume_linked`, `folio_linked`, `recordingno`, `internal_receipt_no`, `serial_number`, `general_number`, `related_number`, `related_page_number`, `related_volume`, `deed_case`, `related_instr_number`, `lodgment_number`, `boxno`, `special_condition`, `inscription`, `inscription2`, `reg_initials`, `blockplot`, `volumefolio`, `filetype`, `region`, `district`, `is_delivered`, `is_right_required`, `is_inactive`, `is_mem_transaction`, `comments`, `site_analysis`, `inspection_officer`, `gis_params`, `tran1`, `tran2`, `tran_date1`, `tran_date2`, `tran_dict1`, `tran_dict2`, `tran_cost1`, `tran_cost2`, `tran_count1`, `tran_count2`, `version`, `begin_lifespan_version`, `end_lifespan_version`, `demandnotice_number`, `batch`, `transaction_index`, `term_day`, `consideration_currency`, `temp_consideration`, `improvement_amount_currency`, `data_corrected_transaction_number`, `data_corrected_transaction_type`, `data_corrected_comments`, `data_corrected_create_date`, `data_corrected_complete_date`, `recommendation_memorandum`, `SurveyPlan`) VALUES ('10000000001071', 'com.landsystems.lrs.model.Transaction', 'P-PLS000000654', '3', '24', '31', 'BP2680', 'BP2680', NULL, NULL, '1', 0, NULL, NULL, NULL, '2014-12-10T16:15:03.577000', NULL, '1975-09-02T00:00:00', '1995-09-01T00:00:00', '1978-06-20T00:00:00', '1978-06-30T00:00:00', NULL, NULL, NULL, 15.2, 0, NULL, NULL, 20, NULL, NULL, NULL, '1', '1', NULL, 3, 20000.0, 5, NULL, '1(CofO)', '248', NULL, NULL, '248', NULL, NULL, NULL, 'P-PLS000000649', NULL, NULL, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1', '557', '1', 1, 0, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1', '1', NULL, NULL, NULL, NULL, '1', '2014-12-10T16:15:03.560000', NULL, NULL, '10000000000409', 2, NULL, '1', NULL, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO lr_transaction (`id`, `Hjtype`, `transaction_number`, `transaction_type`, `transaction_status`, `transaction_source`, `source_property_ids`, `target_property_ids`, `old_property_id`, `parent_property_ids`, `tenure_type`, `is_search_oldfile`, `registration_fee`, `consideration`, `interest_money`, `create_date`, `complete_date`, `start_date`, `expiration_date`, `sign_date`, `registration_date`, `application_date`, `firstpay_date`, `balance_date`, `balance_sum`, `partial`, `pageNumber`, `cert_nos`, `term_year`, `term_month`, `term_year_ext`, `term_month_ext`, `lease_extension`, `lease_duration`, `duration`, `build_term`, `build_value`, `pay_period_year`, `pay_period_month`, `volume`, `folio`, `volume_linked`, `folio_linked`, `recordingno`, `internal_receipt_no`, `serial_number`, `general_number`, `related_number`, `related_page_number`, `related_volume`, `deed_case`, `related_instr_number`, `lodgment_number`, `boxno`, `special_condition`, `inscription`, `inscription2`, `reg_initials`, `blockplot`, `volumefolio`, `filetype`, `region`, `district`, `is_delivered`, `is_right_required`, `is_inactive`, `is_mem_transaction`, `comments`, `site_analysis`, `inspection_officer`, `gis_params`, `tran1`, `tran2`, `tran_date1`, `tran_date2`, `tran_dict1`, `tran_dict2`, `tran_cost1`, `tran_cost2`, `tran_count1`, `tran_count2`, `version`, `begin_lifespan_version`, `end_lifespan_version`, `demandnotice_number`, `batch`, `transaction_index`, `term_day`, `consideration_currency`, `temp_consideration`, `improvement_amount_currency`, `data_corrected_transaction_number`, `data_corrected_transaction_type`, `data_corrected_comments`, `data_corrected_create_date`, `data_corrected_complete_date`, `recommendation_memorandum`, `SurveyPlan`) VALUES ('10000000001072', 'com.landsystems.lrs.model.Transaction', 'PLS000001072', '1', '24', '30', 'BP1567', 'BP1567', NULL, NULL, '1', 0, NULL, 0.0, NULL, '2014-12-10T16:16:02.877000', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 93.45, 0, NULL, NULL, NULL, NULL, NULL, NULL, '1', '1', NULL, 2, 20000.0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1', '557', '1', 0, 0, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1761', '1', NULL, NULL, NULL, NULL, '1', '2014-12-10T16:16:02.860000', NULL, NULL, '10000000000417', 0, NULL, '1', NULL, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO lr_transaction (`id`, `Hjtype`, `transaction_number`, `transaction_type`, `transaction_status`, `transaction_source`, `source_property_ids`, `target_property_ids`, `old_property_id`, `parent_property_ids`, `tenure_type`, `is_search_oldfile`, `registration_fee`, `consideration`, `interest_money`, `create_date`, `complete_date`, `start_date`, `expiration_date`, `sign_date`, `registration_date`, `application_date`, `firstpay_date`, `balance_date`, `balance_sum`, `partial`, `pageNumber`, `cert_nos`, `term_year`, `term_month`, `term_year_ext`, `term_month_ext`, `lease_extension`, `lease_duration`, `duration`, `build_term`, `build_value`, `pay_period_year`, `pay_period_month`, `volume`, `folio`, `volume_linked`, `folio_linked`, `recordingno`, `internal_receipt_no`, `serial_number`, `general_number`, `related_number`, `related_page_number`, `related_volume`, `deed_case`, `related_instr_number`, `lodgment_number`, `boxno`, `special_condition`, `inscription`, `inscription2`, `reg_initials`, `blockplot`, `volumefolio`, `filetype`, `region`, `district`, `is_delivered`, `is_right_required`, `is_inactive`, `is_mem_transaction`, `comments`, `site_analysis`, `inspection_officer`, `gis_params`, `tran1`, `tran2`, `tran_date1`, `tran_date2`, `tran_dict1`, `tran_dict2`, `tran_cost1`, `tran_cost2`, `tran_count1`, `tran_count2`, `version`, `begin_lifespan_version`, `end_lifespan_version`, `demandnotice_number`, `batch`, `transaction_index`, `term_day`, `consideration_currency`, `temp_consideration`, `improvement_amount_currency`, `data_corrected_transaction_number`, `data_corrected_transaction_type`, `data_corrected_comments`, `data_corrected_create_date`, `data_corrected_complete_date`, `recommendation_memorandum`, `SurveyPlan`) VALUES ('10000000001073', 'com.landsystems.lrs.model.Transaction', 'P-PLS000000655', '5', '24', '31', 'BP982', 'BP982', NULL, NULL, '1', 0, NULL, NULL, NULL, '2014-12-10T16:16:07.940000', NULL, '1982-07-15T00:00:00', '2022-07-14T00:00:00', '1980-11-07T00:00:00', '1980-11-07T00:00:00', '1971-07-12T00:00:00', NULL, NULL, 51.89, 0, NULL, NULL, 40, NULL, NULL, NULL, '1', '1', NULL, 2, 10000.0, 5, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, NULL, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1', '557', '1', 1, 0, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1', '1', NULL, NULL, NULL, NULL, '1', '2014-12-10T16:16:07.940000', NULL, NULL, '10000000000412', 1, NULL, '1', NULL, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO lr_transaction (`id`, `Hjtype`, `transaction_number`, `transaction_type`, `transaction_status`, `transaction_source`, `source_property_ids`, `target_property_ids`, `old_property_id`, `parent_property_ids`, `tenure_type`, `is_search_oldfile`, `registration_fee`, `consideration`, `interest_money`, `create_date`, `complete_date`, `start_date`, `expiration_date`, `sign_date`, `registration_date`, `application_date`, `firstpay_date`, `balance_date`, `balance_sum`, `partial`, `pageNumber`, `cert_nos`, `term_year`, `term_month`, `term_year_ext`, `term_month_ext`, `lease_extension`, `lease_duration`, `duration`, `build_term`, `build_value`, `pay_period_year`, `pay_period_month`, `volume`, `folio`, `volume_linked`, `folio_linked`, `recordingno`, `internal_receipt_no`, `serial_number`, `general_number`, `related_number`, `related_page_number`, `related_volume`, `deed_case`, `related_instr_number`, `lodgment_number`, `boxno`, `special_condition`, `inscription`, `inscription2`, `reg_initials`, `blockplot`, `volumefolio`, `filetype`, `region`, `district`, `is_delivered`, `is_right_required`, `is_inactive`, `is_mem_transaction`, `comments`, `site_analysis`, `inspection_officer`, `gis_params`, `tran1`, `tran2`, `tran_date1`, `tran_date2`, `tran_dict1`, `tran_dict2`, `tran_cost1`, `tran_cost2`, `tran_count1`, `tran_count2`, `version`, `begin_lifespan_version`, `end_lifespan_version`, `demandnotice_number`, `batch`, `transaction_index`, `term_day`, `consideration_currency`, `temp_consideration`, `improvement_amount_currency`, `data_corrected_transaction_number`, `data_corrected_transaction_type`, `data_corrected_comments`, `data_corrected_create_date`, `data_corrected_complete_date`, `recommendation_memorandum`, `SurveyPlan`) VALUES ('10000000001074', 'com.landsystems.lrs.model.Transaction', 'PLS000001074', '1', '24', '30', 'BP353', 'BP353', NULL, NULL, '1', 0, NULL, 0.0, NULL, '2014-12-10T16:17:52.833000', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 99.96, 0, NULL, NULL, NULL, NULL, NULL, NULL, '1', '1', NULL, 2, 8000.0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1', '557', '1', 0, 0, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1761', '1', NULL, NULL, NULL, NULL, '1', '2014-12-10T16:17:52.817000', NULL, NULL, '10000000000418', 0, NULL, '1', NULL, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO lr_transaction (`id`, `Hjtype`, `transaction_number`, `transaction_type`, `transaction_status`, `transaction_source`, `source_property_ids`, `target_property_ids`, `old_property_id`, `parent_property_ids`, `tenure_type`, `is_search_oldfile`, `registration_fee`, `consideration`, `interest_money`, `create_date`, `complete_date`, `start_date`, `expiration_date`, `sign_date`, `registration_date`, `application_date`, `firstpay_date`, `balance_date`, `balance_sum`, `partial`, `pageNumber`, `cert_nos`, `term_year`, `term_month`, `term_year_ext`, `term_month_ext`, `lease_extension`, `lease_duration`, `duration`, `build_term`, `build_value`, `pay_period_year`, `pay_period_month`, `volume`, `folio`, `volume_linked`, `folio_linked`, `recordingno`, `internal_receipt_no`, `serial_number`, `general_number`, `related_number`, `related_page_number`, `related_volume`, `deed_case`, `related_instr_number`, `lodgment_number`, `boxno`, `special_condition`, `inscription`, `inscription2`, `reg_initials`, `blockplot`, `volumefolio`, `filetype`, `region`, `district`, `is_delivered`, `is_right_required`, `is_inactive`, `is_mem_transaction`, `comments`, `site_analysis`, `inspection_officer`, `gis_params`, `tran1`, `tran2`, `tran_date1`, `tran_date2`, `tran_dict1`, `tran_dict2`, `tran_cost1`, `tran_cost2`, `tran_count1`, `tran_count2`, `version`, `begin_lifespan_version`, `end_lifespan_version`, `demandnotice_number`, `batch`, `transaction_index`, `term_day`, `consideration_currency`, `temp_consideration`, `improvement_amount_currency`, `data_corrected_transaction_number`, `data_corrected_transaction_type`, `data_corrected_comments`, `data_corrected_create_date`, `data_corrected_complete_date`, `recommendation_memorandum`, `SurveyPlan`) VALUES ('10000000001075', 'com.landsystems.lrs.model.Transaction', 'P-PLS000000656', '5', '24', '31', 'BP3557', 'BP3557', NULL, NULL, '1', 0, NULL, NULL, NULL, '2014-12-10T16:18:14.037000', NULL, '1982-02-24T00:00:00', '2081-02-23T00:00:00', '1982-02-24T00:00:00', '1982-02-24T00:00:00', '1976-07-07T00:00:00', NULL, NULL, 64.33, 0, NULL, NULL, 99, NULL, NULL, NULL, '1', '1', NULL, 2, 20000.0, 5, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, NULL, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1', '557', '1', 1, 0, 0, 0, 'Approval date Torn out so Issue date was use', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1', '1', NULL, NULL, NULL, NULL, '1', '2014-12-10T16:18:14.023000', NULL, NULL, '10000000000415', 1, NULL, '1', NULL, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO lr_transaction (`id`, `Hjtype`, `transaction_number`, `transaction_type`, `transaction_status`, `transaction_source`, `source_property_ids`, `target_property_ids`, `old_property_id`, `parent_property_ids`, `tenure_type`, `is_search_oldfile`, `registration_fee`, `consideration`, `interest_money`, `create_date`, `complete_date`, `start_date`, `expiration_date`, `sign_date`, `registration_date`, `application_date`, `firstpay_date`, `balance_date`, `balance_sum`, `partial`, `pageNumber`, `cert_nos`, `term_year`, `term_month`, `term_year_ext`, `term_month_ext`, `lease_extension`, `lease_duration`, `duration`, `build_term`, `build_value`, `pay_period_year`, `pay_period_month`, `volume`, `folio`, `volume_linked`, `folio_linked`, `recordingno`, `internal_receipt_no`, `serial_number`, `general_number`, `related_number`, `related_page_number`, `related_volume`, `deed_case`, `related_instr_number`, `lodgment_number`, `boxno`, `special_condition`, `inscription`, `inscription2`, `reg_initials`, `blockplot`, `volumefolio`, `filetype`, `region`, `district`, `is_delivered`, `is_right_required`, `is_inactive`, `is_mem_transaction`, `comments`, `site_analysis`, `inspection_officer`, `gis_params`, `tran1`, `tran2`, `tran_date1`, `tran_date2`, `tran_dict1`, `tran_dict2`, `tran_cost1`, `tran_cost2`, `tran_count1`, `tran_count2`, `version`, `begin_lifespan_version`, `end_lifespan_version`, `demandnotice_number`, `batch`, `transaction_index`, `term_day`, `consideration_currency`, `temp_consideration`, `improvement_amount_currency`, `data_corrected_transaction_number`, `data_corrected_transaction_type`, `data_corrected_comments`, `data_corrected_create_date`, `data_corrected_complete_date`, `recommendation_memorandum`, `SurveyPlan`) VALUES ('10000000001076', 'com.landsystems.lrs.model.Transaction', 'P-PLS000000657', '5', '24', '31', 'RofO11350', 'RofO11350', NULL, NULL, '1', 0, NULL, NULL, NULL, '2014-12-10T16:18:57.070000', NULL, '1962-06-15T00:00:00', '1981-07-06T00:00:00', '1962-05-30T00:00:00', '1962-05-30T00:00:00', '1962-01-29T00:00:00', NULL, NULL, 2.0, 0, NULL, NULL, 19, NULL, NULL, NULL, '1', '1', NULL, 2, 400.0, 10, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, NULL, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1', '557', '1', 1, 0, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1', '1', NULL, NULL, NULL, NULL, '1', '2014-12-10T16:18:57.057000', NULL, NULL, '10000000000413', 1, 22, '1', NULL, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO lr_transaction (`id`, `Hjtype`, `transaction_number`, `transaction_type`, `transaction_status`, `transaction_source`, `source_property_ids`, `target_property_ids`, `old_property_id`, `parent_property_ids`, `tenure_type`, `is_search_oldfile`, `registration_fee`, `consideration`, `interest_money`, `create_date`, `complete_date`, `start_date`, `expiration_date`, `sign_date`, `registration_date`, `application_date`, `firstpay_date`, `balance_date`, `balance_sum`, `partial`, `pageNumber`, `cert_nos`, `term_year`, `term_month`, `term_year_ext`, `term_month_ext`, `lease_extension`, `lease_duration`, `duration`, `build_term`, `build_value`, `pay_period_year`, `pay_period_month`, `volume`, `folio`, `volume_linked`, `folio_linked`, `recordingno`, `internal_receipt_no`, `serial_number`, `general_number`, `related_number`, `related_page_number`, `related_volume`, `deed_case`, `related_instr_number`, `lodgment_number`, `boxno`, `special_condition`, `inscription`, `inscription2`, `reg_initials`, `blockplot`, `volumefolio`, `filetype`, `region`, `district`, `is_delivered`, `is_right_required`, `is_inactive`, `is_mem_transaction`, `comments`, `site_analysis`, `inspection_officer`, `gis_params`, `tran1`, `tran2`, `tran_date1`, `tran_date2`, `tran_dict1`, `tran_dict2`, `tran_cost1`, `tran_cost2`, `tran_count1`, `tran_count2`, `version`, `begin_lifespan_version`, `end_lifespan_version`, `demandnotice_number`, `batch`, `transaction_index`, `term_day`, `consideration_currency`, `temp_consideration`, `improvement_amount_currency`, `data_corrected_transaction_number`, `data_corrected_transaction_type`, `data_corrected_comments`, `data_corrected_create_date`, `data_corrected_complete_date`, `recommendation_memorandum`, `SurveyPlan`) VALUES ('10000000001077', 'com.landsystems.lrs.model.Transaction', 'PLS000001077', '1', '26', '30', 'BP2331', 'BP2331', NULL, NULL, '1', 0, NULL, 0.0, NULL, '2014-12-10T16:19:38.527000', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 50.0, 0, NULL, NULL, NULL, NULL, NULL, NULL, '1', '1', NULL, 3, 20000.0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1', '557', '1', 0, 0, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1761', '1', NULL, NULL, NULL, NULL, '1', '2014-12-10T16:19:38.527000', NULL, NULL, '10000000000419', 0, NULL, '1', NULL, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO lr_transaction (`id`, `Hjtype`, `transaction_number`, `transaction_type`, `transaction_status`, `transaction_source`, `source_property_ids`, `target_property_ids`, `old_property_id`, `parent_property_ids`, `tenure_type`, `is_search_oldfile`, `registration_fee`, `consideration`, `interest_money`, `create_date`, `complete_date`, `start_date`, `expiration_date`, `sign_date`, `registration_date`, `application_date`, `firstpay_date`, `balance_date`, `balance_sum`, `partial`, `pageNumber`, `cert_nos`, `term_year`, `term_month`, `term_year_ext`, `term_month_ext`, `lease_extension`, `lease_duration`, `duration`, `build_term`, `build_value`, `pay_period_year`, `pay_period_month`, `volume`, `folio`, `volume_linked`, `folio_linked`, `recordingno`, `internal_receipt_no`, `serial_number`, `general_number`, `related_number`, `related_page_number`, `related_volume`, `deed_case`, `related_instr_number`, `lodgment_number`, `boxno`, `special_condition`, `inscription`, `inscription2`, `reg_initials`, `blockplot`, `volumefolio`, `filetype`, `region`, `district`, `is_delivered`, `is_right_required`, `is_inactive`, `is_mem_transaction`, `comments`, `site_analysis`, `inspection_officer`, `gis_params`, `tran1`, `tran2`, `tran_date1`, `tran_date2`, `tran_dict1`, `tran_dict2`, `tran_cost1`, `tran_cost2`, `tran_count1`, `tran_count2`, `version`, `begin_lifespan_version`, `end_lifespan_version`, `demandnotice_number`, `batch`, `transaction_index`, `term_day`, `consideration_currency`, `temp_consideration`, `improvement_amount_currency`, `data_corrected_transaction_number`, `data_corrected_transaction_type`, `data_corrected_comments`, `data_corrected_create_date`, `data_corrected_complete_date`, `recommendation_memorandum`, `SurveyPlan`) VALUES ('10000000001078', 'com.landsystems.lrs.model.Transaction', 'PLS000001078', '1', '24', '30', 'BP4121', 'BP4121', NULL, NULL, '1', 0, NULL, 0.0, NULL, '2014-12-10T16:19:58.103000', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 62.14, 0, NULL, NULL, NULL, NULL, NULL, NULL, '1', '1', NULL, 2, 20000.0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1', '557', '1', 0, 0, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1761', '1', NULL, NULL, NULL, NULL, '1', '2014-12-10T16:19:58.103000', NULL, NULL, '10000000000420', 0, NULL, '1', NULL, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO lr_transaction (`id`, `Hjtype`, `transaction_number`, `transaction_type`, `transaction_status`, `transaction_source`, `source_property_ids`, `target_property_ids`, `old_property_id`, `parent_property_ids`, `tenure_type`, `is_search_oldfile`, `registration_fee`, `consideration`, `interest_money`, `create_date`, `complete_date`, `start_date`, `expiration_date`, `sign_date`, `registration_date`, `application_date`, `firstpay_date`, `balance_date`, `balance_sum`, `partial`, `pageNumber`, `cert_nos`, `term_year`, `term_month`, `term_year_ext`, `term_month_ext`, `lease_extension`, `lease_duration`, `duration`, `build_term`, `build_value`, `pay_period_year`, `pay_period_month`, `volume`, `folio`, `volume_linked`, `folio_linked`, `recordingno`, `internal_receipt_no`, `serial_number`, `general_number`, `related_number`, `related_page_number`, `related_volume`, `deed_case`, `related_instr_number`, `lodgment_number`, `boxno`, `special_condition`, `inscription`, `inscription2`, `reg_initials`, `blockplot`, `volumefolio`, `filetype`, `region`, `district`, `is_delivered`, `is_right_required`, `is_inactive`, `is_mem_transaction`, `comments`, `site_analysis`, `inspection_officer`, `gis_params`, `tran1`, `tran2`, `tran_date1`, `tran_date2`, `tran_dict1`, `tran_dict2`, `tran_cost1`, `tran_cost2`, `tran_count1`, `tran_count2`, `version`, `begin_lifespan_version`, `end_lifespan_version`, `demandnotice_number`, `batch`, `transaction_index`, `term_day`, `consideration_currency`, `temp_consideration`, `improvement_amount_currency`, `data_corrected_transaction_number`, `data_corrected_transaction_type`, `data_corrected_comments`, `data_corrected_create_date`, `data_corrected_complete_date`, `recommendation_memorandum`, `SurveyPlan`) VALUES ('10000000001080', 'com.landsystems.lrs.model.Transaction', 'P-PLS000000659', '5', '24', '31', 'BP1567', 'BP1567', NULL, NULL, '1', 0, NULL, NULL, NULL, '2014-12-10T16:21:56.203000', NULL, '1982-12-22T00:00:00', '2022-12-21T00:00:00', '1982-12-15T00:00:00', '1982-12-15T00:00:00', '1972-10-31T00:00:00', NULL, NULL, 93.45, 0, NULL, NULL, 40, NULL, NULL, NULL, '1', '1', NULL, 2, 20000.0, 5, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1', '557', '1', 1, 0, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1', '1', NULL, NULL, NULL, NULL, '1', '2014-12-10T16:21:56.187000', NULL, NULL, '10000000000417', 1, NULL, '1', NULL, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO lr_transaction (`id`, `Hjtype`, `transaction_number`, `transaction_type`, `transaction_status`, `transaction_source`, `source_property_ids`, `target_property_ids`, `old_property_id`, `parent_property_ids`, `tenure_type`, `is_search_oldfile`, `registration_fee`, `consideration`, `interest_money`, `create_date`, `complete_date`, `start_date`, `expiration_date`, `sign_date`, `registration_date`, `application_date`, `firstpay_date`, `balance_date`, `balance_sum`, `partial`, `pageNumber`, `cert_nos`, `term_year`, `term_month`, `term_year_ext`, `term_month_ext`, `lease_extension`, `lease_duration`, `duration`, `build_term`, `build_value`, `pay_period_year`, `pay_period_month`, `volume`, `folio`, `volume_linked`, `folio_linked`, `recordingno`, `internal_receipt_no`, `serial_number`, `general_number`, `related_number`, `related_page_number`, `related_volume`, `deed_case`, `related_instr_number`, `lodgment_number`, `boxno`, `special_condition`, `inscription`, `inscription2`, `reg_initials`, `blockplot`, `volumefolio`, `filetype`, `region`, `district`, `is_delivered`, `is_right_required`, `is_inactive`, `is_mem_transaction`, `comments`, `site_analysis`, `inspection_officer`, `gis_params`, `tran1`, `tran2`, `tran_date1`, `tran_date2`, `tran_dict1`, `tran_dict2`, `tran_cost1`, `tran_cost2`, `tran_count1`, `tran_count2`, `version`, `begin_lifespan_version`, `end_lifespan_version`, `demandnotice_number`, `batch`, `transaction_index`, `term_day`, `consideration_currency`, `temp_consideration`, `improvement_amount_currency`, `data_corrected_transaction_number`, `data_corrected_transaction_type`, `data_corrected_comments`, `data_corrected_create_date`, `data_corrected_complete_date`, `recommendation_memorandum`, `SurveyPlan`) VALUES ('10000000001081', 'com.landsystems.lrs.model.Transaction', 'PLS000001081', '1', '24', '30', 'BP3940', 'BP3940', NULL, NULL, '1', 0, NULL, 0.0, NULL, '2014-12-10T16:22:00.437000', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 56.34, 0, NULL, NULL, NULL, NULL, NULL, NULL, '1', '1', NULL, 2, 18000.0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1', '557', '1', 0, 0, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1761', '1', NULL, NULL, NULL, NULL, '1', '2014-12-10T16:22:00.437000', NULL, NULL, '10000000000421', 0, NULL, '1', NULL, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO lr_transaction (`id`, `Hjtype`, `transaction_number`, `transaction_type`, `transaction_status`, `transaction_source`, `source_property_ids`, `target_property_ids`, `old_property_id`, `parent_property_ids`, `tenure_type`, `is_search_oldfile`, `registration_fee`, `consideration`, `interest_money`, `create_date`, `complete_date`, `start_date`, `expiration_date`, `sign_date`, `registration_date`, `application_date`, `firstpay_date`, `balance_date`, `balance_sum`, `partial`, `pageNumber`, `cert_nos`, `term_year`, `term_month`, `term_year_ext`, `term_month_ext`, `lease_extension`, `lease_duration`, `duration`, `build_term`, `build_value`, `pay_period_year`, `pay_period_month`, `volume`, `folio`, `volume_linked`, `folio_linked`, `recordingno`, `internal_receipt_no`, `serial_number`, `general_number`, `related_number`, `related_page_number`, `related_volume`, `deed_case`, `related_instr_number`, `lodgment_number`, `boxno`, `special_condition`, `inscription`, `inscription2`, `reg_initials`, `blockplot`, `volumefolio`, `filetype`, `region`, `district`, `is_delivered`, `is_right_required`, `is_inactive`, `is_mem_transaction`, `comments`, `site_analysis`, `inspection_officer`, `gis_params`, `tran1`, `tran2`, `tran_date1`, `tran_date2`, `tran_dict1`, `tran_dict2`, `tran_cost1`, `tran_cost2`, `tran_count1`, `tran_count2`, `version`, `begin_lifespan_version`, `end_lifespan_version`, `demandnotice_number`, `batch`, `transaction_index`, `term_day`, `consideration_currency`, `temp_consideration`, `improvement_amount_currency`, `data_corrected_transaction_number`, `data_corrected_transaction_type`, `data_corrected_comments`, `data_corrected_create_date`, `data_corrected_complete_date`, `recommendation_memorandum`, `SurveyPlan`) VALUES ('10000000001082', 'com.landsystems.lrs.model.Transaction', 'P-PLS000000660', '3', '24', '31', 'BP3557', 'BP3557', NULL, NULL, '1', 0, NULL, NULL, NULL, '2014-12-10T16:22:16.033000', NULL, '1982-02-24T00:00:00', '2081-02-23T00:00:00', '1983-06-24T00:00:00', '1983-08-03T00:00:00', NULL, NULL, NULL, 64.33, 0, NULL, NULL, 99, NULL, NULL, NULL, '1', '1', NULL, 2, 20000.0, 5, NULL, '4(CofO)', '204', NULL, NULL, '204', NULL, NULL, NULL, 'P-PLS000000656', NULL, NULL, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1', '557', '1', 1, 0, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1', '1', NULL, NULL, NULL, NULL, '1', '2014-12-10T16:22:16.017000', NULL, NULL, '10000000000415', 2, NULL, '1', NULL, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO lr_transaction (`id`, `Hjtype`, `transaction_number`, `transaction_type`, `transaction_status`, `transaction_source`, `source_property_ids`, `target_property_ids`, `old_property_id`, `parent_property_ids`, `tenure_type`, `is_search_oldfile`, `registration_fee`, `consideration`, `interest_money`, `create_date`, `complete_date`, `start_date`, `expiration_date`, `sign_date`, `registration_date`, `application_date`, `firstpay_date`, `balance_date`, `balance_sum`, `partial`, `pageNumber`, `cert_nos`, `term_year`, `term_month`, `term_year_ext`, `term_month_ext`, `lease_extension`, `lease_duration`, `duration`, `build_term`, `build_value`, `pay_period_year`, `pay_period_month`, `volume`, `folio`, `volume_linked`, `folio_linked`, `recordingno`, `internal_receipt_no`, `serial_number`, `general_number`, `related_number`, `related_page_number`, `related_volume`, `deed_case`, `related_instr_number`, `lodgment_number`, `boxno`, `special_condition`, `inscription`, `inscription2`, `reg_initials`, `blockplot`, `volumefolio`, `filetype`, `region`, `district`, `is_delivered`, `is_right_required`, `is_inactive`, `is_mem_transaction`, `comments`, `site_analysis`, `inspection_officer`, `gis_params`, `tran1`, `tran2`, `tran_date1`, `tran_date2`, `tran_dict1`, `tran_dict2`, `tran_cost1`, `tran_cost2`, `tran_count1`, `tran_count2`, `version`, `begin_lifespan_version`, `end_lifespan_version`, `demandnotice_number`, `batch`, `transaction_index`, `term_day`, `consideration_currency`, `temp_consideration`, `improvement_amount_currency`, `data_corrected_transaction_number`, `data_corrected_transaction_type`, `data_corrected_comments`, `data_corrected_create_date`, `data_corrected_complete_date`, `recommendation_memorandum`, `SurveyPlan`) VALUES ('10000000001083', 'com.landsystems.lrs.model.Transaction', 'P-PLS000000661', '5', '24', '31', 'CofO11338', 'CofO11338', NULL, NULL, '1', 0, NULL, NULL, NULL, '2014-12-10T16:22:37.393000', NULL, '1962-05-12T00:00:00', '1971-05-11T00:00:00', '1962-04-12T00:00:00', '1962-04-12T00:00:00', '1961-08-14T00:00:00', NULL, NULL, 0.16, 0, NULL, NULL, 9, NULL, NULL, NULL, '1', '1', NULL, 2, 150.0, 10, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1', '557', '1', 1, 0, 0, 0, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1', '1', NULL, NULL, NULL, NULL, '1', '2014-12-10T16:22:37.377000', NULL, NULL, '10000000000416', 1, NULL, '1', NULL, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO lr_transaction (`id`, `Hjtype`, `transaction_number`, `transaction_type`, `transaction_status`, `transaction_source`, `source_property_ids`, `target_property_ids`, `old_property_id`, `parent_property_ids`, `tenure_type`, `is_search_oldfile`, `registration_fee`, `consideration`, `interest_money`, `create_date`, `complete_date`, `start_date`, `expiration_date`, `sign_date`, `registration_date`, `application_date`, `firstpay_date`, `balance_date`, `balance_sum`, `partial`, `pageNumber`, `cert_nos`, `term_year`, `term_month`, `term_year_ext`, `term_month_ext`, `lease_extension`, `lease_duration`, `duration`, `build_term`, `build_value`, `pay_period_year`, `pay_period_month`, `volume`, `folio`, `volume_linked`, `folio_linked`, `recordingno`, `internal_receipt_no`, `serial_number`, `general_number`, `related_number`, `related_page_number`, `related_volume`, `deed_case`, `related_instr_number`, `lodgment_number`, `boxno`, `special_condition`, `inscription`, `inscription2`, `reg_initials`, `blockplot`, `volumefolio`, `filetype`, `region`, `district`, `is_delivered`, `is_right_required`, `is_inactive`, `is_mem_transaction`, `comments`, `site_analysis`, `inspection_officer`, `gis_params`, `tran1`, `tran2`, `tran_date1`, `tran_date2`, `tran_dict1`, `tran_dict2`, `tran_cost1`, `tran_cost2`, `tran_count1`, `tran_count2`, `version`, `begin_lifespan_version`, `end_lifespan_version`, `demandnotice_number`, `batch`, `transaction_index`, `term_day`, `consideration_currency`, `temp_consideration`, `improvement_amount_currency`, `data_corrected_transaction_number`, `data_corrected_transaction_type`, `data_corrected_comments`, `data_corrected_create_date`, `data_corrected_complete_date`, `recommendation_memorandum`, `SurveyPlan`) VALUES ('10000000001085', 'com.landsystems.lrs.model.Transaction', 'P-PLS000000663', '5', '24', '31', 'BP4121', 'BP4121', NULL, NULL, '1', 0, NULL, NULL, NULL, '2014-12-10T16:25:54.277000', NULL, '1978-07-07T00:00:00', '2077-07-06T00:00:00', '1978-06-26T00:00:00', '1978-06-26T00:00:00', '1975-11-27T00:00:00', NULL, NULL, 62.14, 0, NULL, NULL, 99, NULL, NULL, NULL, '1', '1', NULL, 2, 20000.0, 5, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, NULL, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1', '557', '1', 1, 0, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1', '1', NULL, NULL, NULL, NULL, '1', '2014-12-10T16:25:54.277000', NULL, NULL, '10000000000420', 1, NULL, '1', NULL, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO lr_transaction (`id`, `Hjtype`, `transaction_number`, `transaction_type`, `transaction_status`, `transaction_source`, `source_property_ids`, `target_property_ids`, `old_property_id`, `parent_property_ids`, `tenure_type`, `is_search_oldfile`, `registration_fee`, `consideration`, `interest_money`, `create_date`, `complete_date`, `start_date`, `expiration_date`, `sign_date`, `registration_date`, `application_date`, `firstpay_date`, `balance_date`, `balance_sum`, `partial`, `pageNumber`, `cert_nos`, `term_year`, `term_month`, `term_year_ext`, `term_month_ext`, `lease_extension`, `lease_duration`, `duration`, `build_term`, `build_value`, `pay_period_year`, `pay_period_month`, `volume`, `folio`, `volume_linked`, `folio_linked`, `recordingno`, `internal_receipt_no`, `serial_number`, `general_number`, `related_number`, `related_page_number`, `related_volume`, `deed_case`, `related_instr_number`, `lodgment_number`, `boxno`, `special_condition`, `inscription`, `inscription2`, `reg_initials`, `blockplot`, `volumefolio`, `filetype`, `region`, `district`, `is_delivered`, `is_right_required`, `is_inactive`, `is_mem_transaction`, `comments`, `site_analysis`, `inspection_officer`, `gis_params`, `tran1`, `tran2`, `tran_date1`, `tran_date2`, `tran_dict1`, `tran_dict2`, `tran_cost1`, `tran_cost2`, `tran_count1`, `tran_count2`, `version`, `begin_lifespan_version`, `end_lifespan_version`, `demandnotice_number`, `batch`, `transaction_index`, `term_day`, `consideration_currency`, `temp_consideration`, `improvement_amount_currency`, `data_corrected_transaction_number`, `data_corrected_transaction_type`, `data_corrected_comments`, `data_corrected_create_date`, `data_corrected_complete_date`, `recommendation_memorandum`, `SurveyPlan`) VALUES ('10000000001086', 'com.landsystems.lrs.model.Transaction', 'P-PLS000000664', '3', '24', '31', 'BP1567', 'BP1567', NULL, NULL, '1', 0, NULL, NULL, NULL, '2014-12-10T16:26:07.730000', NULL, '1982-12-22T00:00:00', '2022-12-21T00:00:00', '1984-09-19T00:00:00', '1984-09-27T00:00:00', NULL, NULL, NULL, 93.45, 0, NULL, NULL, 40, NULL, NULL, NULL, '1', '1', NULL, 2, 20000.0, 5, NULL, '4(CofO)', '383', NULL, NULL, '383', NULL, NULL, NULL, 'P-PLS000000659', NULL, NULL, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1', '557', '1', 1, 0, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1', '1', NULL, NULL, NULL, NULL, '1', '2014-12-10T16:26:07.730000', NULL, NULL, '10000000000417', 2, NULL, '1', NULL, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO lr_transaction (`id`, `Hjtype`, `transaction_number`, `transaction_type`, `transaction_status`, `transaction_source`, `source_property_ids`, `target_property_ids`, `old_property_id`, `parent_property_ids`, `tenure_type`, `is_search_oldfile`, `registration_fee`, `consideration`, `interest_money`, `create_date`, `complete_date`, `start_date`, `expiration_date`, `sign_date`, `registration_date`, `application_date`, `firstpay_date`, `balance_date`, `balance_sum`, `partial`, `pageNumber`, `cert_nos`, `term_year`, `term_month`, `term_year_ext`, `term_month_ext`, `lease_extension`, `lease_duration`, `duration`, `build_term`, `build_value`, `pay_period_year`, `pay_period_month`, `volume`, `folio`, `volume_linked`, `folio_linked`, `recordingno`, `internal_receipt_no`, `serial_number`, `general_number`, `related_number`, `related_page_number`, `related_volume`, `deed_case`, `related_instr_number`, `lodgment_number`, `boxno`, `special_condition`, `inscription`, `inscription2`, `reg_initials`, `blockplot`, `volumefolio`, `filetype`, `region`, `district`, `is_delivered`, `is_right_required`, `is_inactive`, `is_mem_transaction`, `comments`, `site_analysis`, `inspection_officer`, `gis_params`, `tran1`, `tran2`, `tran_date1`, `tran_date2`, `tran_dict1`, `tran_dict2`, `tran_cost1`, `tran_cost2`, `tran_count1`, `tran_count2`, `version`, `begin_lifespan_version`, `end_lifespan_version`, `demandnotice_number`, `batch`, `transaction_index`, `term_day`, `consideration_currency`, `temp_consideration`, `improvement_amount_currency`, `data_corrected_transaction_number`, `data_corrected_transaction_type`, `data_corrected_comments`, `data_corrected_create_date`, `data_corrected_complete_date`, `recommendation_memorandum`, `SurveyPlan`) VALUES ('10000000001088', 'com.landsystems.lrs.model.Transaction', 'P-PLS000000665', '5', '26', '31', 'BP2331', 'BP2331', NULL, NULL, '1', 0, NULL, NULL, NULL, '2014-12-10T16:28:06.373000', NULL, '1975-05-30T00:00:00', '1995-05-29T00:00:00', '1975-04-24T00:00:00', '1975-04-24T00:00:00', '1974-04-22T00:00:00', NULL, NULL, 50.0, 0, NULL, NULL, 20, NULL, NULL, NULL, '1', '1', NULL, 3, 20000.0, 5, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1', '557', '1', 1, 0, 0, 0, 'Commencement date not found on acceptance letter, so the issue date on landform 7 was used', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1', '1', NULL, NULL, NULL, NULL, '1', '2014-12-10T16:28:06.373000', NULL, NULL, '10000000000419', 1, NULL, '1', NULL, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO lr_transaction (`id`, `Hjtype`, `transaction_number`, `transaction_type`, `transaction_status`, `transaction_source`, `source_property_ids`, `target_property_ids`, `old_property_id`, `parent_property_ids`, `tenure_type`, `is_search_oldfile`, `registration_fee`, `consideration`, `interest_money`, `create_date`, `complete_date`, `start_date`, `expiration_date`, `sign_date`, `registration_date`, `application_date`, `firstpay_date`, `balance_date`, `balance_sum`, `partial`, `pageNumber`, `cert_nos`, `term_year`, `term_month`, `term_year_ext`, `term_month_ext`, `lease_extension`, `lease_duration`, `duration`, `build_term`, `build_value`, `pay_period_year`, `pay_period_month`, `volume`, `folio`, `volume_linked`, `folio_linked`, `recordingno`, `internal_receipt_no`, `serial_number`, `general_number`, `related_number`, `related_page_number`, `related_volume`, `deed_case`, `related_instr_number`, `lodgment_number`, `boxno`, `special_condition`, `inscription`, `inscription2`, `reg_initials`, `blockplot`, `volumefolio`, `filetype`, `region`, `district`, `is_delivered`, `is_right_required`, `is_inactive`, `is_mem_transaction`, `comments`, `site_analysis`, `inspection_officer`, `gis_params`, `tran1`, `tran2`, `tran_date1`, `tran_date2`, `tran_dict1`, `tran_dict2`, `tran_cost1`, `tran_cost2`, `tran_count1`, `tran_count2`, `version`, `begin_lifespan_version`, `end_lifespan_version`, `demandnotice_number`, `batch`, `transaction_index`, `term_day`, `consideration_currency`, `temp_consideration`, `improvement_amount_currency`, `data_corrected_transaction_number`, `data_corrected_transaction_type`, `data_corrected_comments`, `data_corrected_create_date`, `data_corrected_complete_date`, `recommendation_memorandum`, `SurveyPlan`) VALUES ('10000000001089', 'com.landsystems.lrs.model.Transaction', 'PLS000001089', '1', '24', '30', 'BP1349', 'BP1349', NULL, NULL, '1', 0, NULL, 0.0, NULL, '2014-12-10T16:28:31.577000', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 59.25, 0, NULL, NULL, NULL, NULL, NULL, NULL, '1', '1', NULL, 2, 2000.0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1', '557', '1', 0, 0, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1761', '1', NULL, NULL, NULL, NULL, '1', '2014-12-10T16:28:31.577000', NULL, NULL, '10000000000423', 0, NULL, '1', NULL, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO lr_transaction (`id`, `Hjtype`, `transaction_number`, `transaction_type`, `transaction_status`, `transaction_source`, `source_property_ids`, `target_property_ids`, `old_property_id`, `parent_property_ids`, `tenure_type`, `is_search_oldfile`, `registration_fee`, `consideration`, `interest_money`, `create_date`, `complete_date`, `start_date`, `expiration_date`, `sign_date`, `registration_date`, `application_date`, `firstpay_date`, `balance_date`, `balance_sum`, `partial`, `pageNumber`, `cert_nos`, `term_year`, `term_month`, `term_year_ext`, `term_month_ext`, `lease_extension`, `lease_duration`, `duration`, `build_term`, `build_value`, `pay_period_year`, `pay_period_month`, `volume`, `folio`, `volume_linked`, `folio_linked`, `recordingno`, `internal_receipt_no`, `serial_number`, `general_number`, `related_number`, `related_page_number`, `related_volume`, `deed_case`, `related_instr_number`, `lodgment_number`, `boxno`, `special_condition`, `inscription`, `inscription2`, `reg_initials`, `blockplot`, `volumefolio`, `filetype`, `region`, `district`, `is_delivered`, `is_right_required`, `is_inactive`, `is_mem_transaction`, `comments`, `site_analysis`, `inspection_officer`, `gis_params`, `tran1`, `tran2`, `tran_date1`, `tran_date2`, `tran_dict1`, `tran_dict2`, `tran_cost1`, `tran_cost2`, `tran_count1`, `tran_count2`, `version`, `begin_lifespan_version`, `end_lifespan_version`, `demandnotice_number`, `batch`, `transaction_index`, `term_day`, `consideration_currency`, `temp_consideration`, `improvement_amount_currency`, `data_corrected_transaction_number`, `data_corrected_transaction_type`, `data_corrected_comments`, `data_corrected_create_date`, `data_corrected_complete_date`, `recommendation_memorandum`, `SurveyPlan`) VALUES ('10000000001090', 'com.landsystems.lrs.model.Transaction', 'PLS000001090', '1', '24', '30', 'RofO14137', 'RofO14137', NULL, NULL, '1', 0, NULL, 0.0, NULL, '2014-12-10T16:29:23.003000', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 8.0, 0, NULL, NULL, NULL, NULL, NULL, NULL, '1', '1', NULL, 2, 100.0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1', '557', '1', 0, 0, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1761', '1', NULL, NULL, NULL, NULL, '1', '2014-12-10T16:29:22.987000', NULL, NULL, '10000000000424', 0, NULL, '1', NULL, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO lr_transaction (`id`, `Hjtype`, `transaction_number`, `transaction_type`, `transaction_status`, `transaction_source`, `source_property_ids`, `target_property_ids`, `old_property_id`, `parent_property_ids`, `tenure_type`, `is_search_oldfile`, `registration_fee`, `consideration`, `interest_money`, `create_date`, `complete_date`, `start_date`, `expiration_date`, `sign_date`, `registration_date`, `application_date`, `firstpay_date`, `balance_date`, `balance_sum`, `partial`, `pageNumber`, `cert_nos`, `term_year`, `term_month`, `term_year_ext`, `term_month_ext`, `lease_extension`, `lease_duration`, `duration`, `build_term`, `build_value`, `pay_period_year`, `pay_period_month`, `volume`, `folio`, `volume_linked`, `folio_linked`, `recordingno`, `internal_receipt_no`, `serial_number`, `general_number`, `related_number`, `related_page_number`, `related_volume`, `deed_case`, `related_instr_number`, `lodgment_number`, `boxno`, `special_condition`, `inscription`, `inscription2`, `reg_initials`, `blockplot`, `volumefolio`, `filetype`, `region`, `district`, `is_delivered`, `is_right_required`, `is_inactive`, `is_mem_transaction`, `comments`, `site_analysis`, `inspection_officer`, `gis_params`, `tran1`, `tran2`, `tran_date1`, `tran_date2`, `tran_dict1`, `tran_dict2`, `tran_cost1`, `tran_cost2`, `tran_count1`, `tran_count2`, `version`, `begin_lifespan_version`, `end_lifespan_version`, `demandnotice_number`, `batch`, `transaction_index`, `term_day`, `consideration_currency`, `temp_consideration`, `improvement_amount_currency`, `data_corrected_transaction_number`, `data_corrected_transaction_type`, `data_corrected_comments`, `data_corrected_create_date`, `data_corrected_complete_date`, `recommendation_memorandum`, `SurveyPlan`) VALUES ('10000000001093', 'com.landsystems.lrs.model.Transaction', 'P-PLS000000668', '5', '24', '31', 'BP353', 'BP353', NULL, NULL, '1', 0, NULL, NULL, NULL, '2014-12-10T16:30:17.707000', NULL, '1973-06-19T00:00:00', '2072-06-18T00:00:00', '1973-06-19T00:00:00', '1973-06-19T00:00:00', '1969-08-08T00:00:00', NULL, NULL, 99.96, 0, NULL, NULL, 99, NULL, NULL, NULL, '1', '1', NULL, 2, 8000.0, 5, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1', '557', '1', 1, 0, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1', '1', NULL, NULL, NULL, NULL, '1', '2014-12-10T16:30:17.707000', NULL, NULL, '10000000000418', 1, NULL, '1', NULL, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO lr_transaction (`id`, `Hjtype`, `transaction_number`, `transaction_type`, `transaction_status`, `transaction_source`, `source_property_ids`, `target_property_ids`, `old_property_id`, `parent_property_ids`, `tenure_type`, `is_search_oldfile`, `registration_fee`, `consideration`, `interest_money`, `create_date`, `complete_date`, `start_date`, `expiration_date`, `sign_date`, `registration_date`, `application_date`, `firstpay_date`, `balance_date`, `balance_sum`, `partial`, `pageNumber`, `cert_nos`, `term_year`, `term_month`, `term_year_ext`, `term_month_ext`, `lease_extension`, `lease_duration`, `duration`, `build_term`, `build_value`, `pay_period_year`, `pay_period_month`, `volume`, `folio`, `volume_linked`, `folio_linked`, `recordingno`, `internal_receipt_no`, `serial_number`, `general_number`, `related_number`, `related_page_number`, `related_volume`, `deed_case`, `related_instr_number`, `lodgment_number`, `boxno`, `special_condition`, `inscription`, `inscription2`, `reg_initials`, `blockplot`, `volumefolio`, `filetype`, `region`, `district`, `is_delivered`, `is_right_required`, `is_inactive`, `is_mem_transaction`, `comments`, `site_analysis`, `inspection_officer`, `gis_params`, `tran1`, `tran2`, `tran_date1`, `tran_date2`, `tran_dict1`, `tran_dict2`, `tran_cost1`, `tran_cost2`, `tran_count1`, `tran_count2`, `version`, `begin_lifespan_version`, `end_lifespan_version`, `demandnotice_number`, `batch`, `transaction_index`, `term_day`, `consideration_currency`, `temp_consideration`, `improvement_amount_currency`, `data_corrected_transaction_number`, `data_corrected_transaction_type`, `data_corrected_comments`, `data_corrected_create_date`, `data_corrected_complete_date`, `recommendation_memorandum`, `SurveyPlan`) VALUES ('10000000001095', 'com.landsystems.lrs.model.Transaction', 'PLS000001095', '1', '26', '30', 'CofO8144', 'CofO8144', NULL, NULL, '1', 0, NULL, 0.0, NULL, '2014-12-10T16:31:00.677000', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 4.19, 0, NULL, NULL, NULL, NULL, NULL, NULL, '1', '1', NULL, 2, 1000.0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1', '557', '1', 0, 0, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1761', '1', NULL, NULL, NULL, NULL, '1', '2014-12-10T16:31:00.663000', NULL, NULL, '10000000000425', 0, NULL, '1', NULL, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO lr_transaction (`id`, `Hjtype`, `transaction_number`, `transaction_type`, `transaction_status`, `transaction_source`, `source_property_ids`, `target_property_ids`, `old_property_id`, `parent_property_ids`, `tenure_type`, `is_search_oldfile`, `registration_fee`, `consideration`, `interest_money`, `create_date`, `complete_date`, `start_date`, `expiration_date`, `sign_date`, `registration_date`, `application_date`, `firstpay_date`, `balance_date`, `balance_sum`, `partial`, `pageNumber`, `cert_nos`, `term_year`, `term_month`, `term_year_ext`, `term_month_ext`, `lease_extension`, `lease_duration`, `duration`, `build_term`, `build_value`, `pay_period_year`, `pay_period_month`, `volume`, `folio`, `volume_linked`, `folio_linked`, `recordingno`, `internal_receipt_no`, `serial_number`, `general_number`, `related_number`, `related_page_number`, `related_volume`, `deed_case`, `related_instr_number`, `lodgment_number`, `boxno`, `special_condition`, `inscription`, `inscription2`, `reg_initials`, `blockplot`, `volumefolio`, `filetype`, `region`, `district`, `is_delivered`, `is_right_required`, `is_inactive`, `is_mem_transaction`, `comments`, `site_analysis`, `inspection_officer`, `gis_params`, `tran1`, `tran2`, `tran_date1`, `tran_date2`, `tran_dict1`, `tran_dict2`, `tran_cost1`, `tran_cost2`, `tran_count1`, `tran_count2`, `version`, `begin_lifespan_version`, `end_lifespan_version`, `demandnotice_number`, `batch`, `transaction_index`, `term_day`, `consideration_currency`, `temp_consideration`, `improvement_amount_currency`, `data_corrected_transaction_number`, `data_corrected_transaction_type`, `data_corrected_comments`, `data_corrected_create_date`, `data_corrected_complete_date`, `recommendation_memorandum`, `SurveyPlan`) VALUES ('10000000001096', 'com.landsystems.lrs.model.Transaction', 'P-PLS000000670', '5', '24', '31', 'BP3940', 'BP3940', NULL, NULL, '1', 0, NULL, NULL, NULL, '2014-12-10T16:31:40.147000', NULL, '1982-05-19T00:00:00', '2081-05-18T00:00:00', '1982-05-10T00:00:00', '1982-05-10T00:00:00', '1975-09-24T00:00:00', NULL, NULL, 56.34, 0, NULL, NULL, 99, NULL, NULL, NULL, '1', '1', NULL, 2, 18000.0, 5, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, NULL, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1', '557', '1', 1, 0, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1', '1', NULL, NULL, NULL, NULL, '1', '2014-12-10T16:31:40.147000', NULL, NULL, '10000000000421', 1, NULL, '1', NULL, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO lr_transaction (`id`, `Hjtype`, `transaction_number`, `transaction_type`, `transaction_status`, `transaction_source`, `source_property_ids`, `target_property_ids`, `old_property_id`, `parent_property_ids`, `tenure_type`, `is_search_oldfile`, `registration_fee`, `consideration`, `interest_money`, `create_date`, `complete_date`, `start_date`, `expiration_date`, `sign_date`, `registration_date`, `application_date`, `firstpay_date`, `balance_date`, `balance_sum`, `partial`, `pageNumber`, `cert_nos`, `term_year`, `term_month`, `term_year_ext`, `term_month_ext`, `lease_extension`, `lease_duration`, `duration`, `build_term`, `build_value`, `pay_period_year`, `pay_period_month`, `volume`, `folio`, `volume_linked`, `folio_linked`, `recordingno`, `internal_receipt_no`, `serial_number`, `general_number`, `related_number`, `related_page_number`, `related_volume`, `deed_case`, `related_instr_number`, `lodgment_number`, `boxno`, `special_condition`, `inscription`, `inscription2`, `reg_initials`, `blockplot`, `volumefolio`, `filetype`, `region`, `district`, `is_delivered`, `is_right_required`, `is_inactive`, `is_mem_transaction`, `comments`, `site_analysis`, `inspection_officer`, `gis_params`, `tran1`, `tran2`, `tran_date1`, `tran_date2`, `tran_dict1`, `tran_dict2`, `tran_cost1`, `tran_cost2`, `tran_count1`, `tran_count2`, `version`, `begin_lifespan_version`, `end_lifespan_version`, `demandnotice_number`, `batch`, `transaction_index`, `term_day`, `consideration_currency`, `temp_consideration`, `improvement_amount_currency`, `data_corrected_transaction_number`, `data_corrected_transaction_type`, `data_corrected_comments`, `data_corrected_create_date`, `data_corrected_complete_date`, `recommendation_memorandum`, `SurveyPlan`) VALUES ('10000000001097', 'com.landsystems.lrs.model.Transaction', 'P-PLS000000671', '5', '24', '31', 'RofO14137', 'RofO14137', NULL, NULL, '1', 0, NULL, NULL, NULL, '2014-12-10T16:34:38.327000', NULL, '1966-01-07T00:00:00', '1983-01-06T00:00:00', '1965-11-03T00:00:00', '1965-11-03T00:00:00', '1965-02-17T00:00:00', NULL, NULL, 8.0, 0, NULL, NULL, 17, NULL, NULL, NULL, '1', '1', NULL, 2, 100.0, 5, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1', '557', '1', 1, 0, 0, 0, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1', '1', NULL, NULL, NULL, NULL, '1', '2014-12-10T16:34:38.313000', NULL, NULL, '10000000000424', 1, NULL, '1', NULL, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO lr_transaction (`id`, `Hjtype`, `transaction_number`, `transaction_type`, `transaction_status`, `transaction_source`, `source_property_ids`, `target_property_ids`, `old_property_id`, `parent_property_ids`, `tenure_type`, `is_search_oldfile`, `registration_fee`, `consideration`, `interest_money`, `create_date`, `complete_date`, `start_date`, `expiration_date`, `sign_date`, `registration_date`, `application_date`, `firstpay_date`, `balance_date`, `balance_sum`, `partial`, `pageNumber`, `cert_nos`, `term_year`, `term_month`, `term_year_ext`, `term_month_ext`, `lease_extension`, `lease_duration`, `duration`, `build_term`, `build_value`, `pay_period_year`, `pay_period_month`, `volume`, `folio`, `volume_linked`, `folio_linked`, `recordingno`, `internal_receipt_no`, `serial_number`, `general_number`, `related_number`, `related_page_number`, `related_volume`, `deed_case`, `related_instr_number`, `lodgment_number`, `boxno`, `special_condition`, `inscription`, `inscription2`, `reg_initials`, `blockplot`, `volumefolio`, `filetype`, `region`, `district`, `is_delivered`, `is_right_required`, `is_inactive`, `is_mem_transaction`, `comments`, `site_analysis`, `inspection_officer`, `gis_params`, `tran1`, `tran2`, `tran_date1`, `tran_date2`, `tran_dict1`, `tran_dict2`, `tran_cost1`, `tran_cost2`, `tran_count1`, `tran_count2`, `version`, `begin_lifespan_version`, `end_lifespan_version`, `demandnotice_number`, `batch`, `transaction_index`, `term_day`, `consideration_currency`, `temp_consideration`, `improvement_amount_currency`, `data_corrected_transaction_number`, `data_corrected_transaction_type`, `data_corrected_comments`, `data_corrected_create_date`, `data_corrected_complete_date`, `recommendation_memorandum`, `SurveyPlan`) VALUES ('10000000001098', 'com.landsystems.lrs.model.Transaction', 'P-PLS000000672', '5', '24', '31', 'BP1349', 'BP1349', NULL, NULL, '1', 0, NULL, NULL, NULL, '2014-12-10T16:35:27.283000', NULL, '1973-09-10T00:00:00', '2013-09-09T00:00:00', '1973-08-18T00:00:00', '1973-08-18T00:00:00', '1972-05-30T00:00:00', NULL, NULL, 59.25, 0, NULL, NULL, 40, NULL, NULL, NULL, '1', '1', NULL, 2, 2000.0, 5, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1', '557', '1', 1, 0, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1', '1', NULL, NULL, NULL, NULL, '1', '2014-12-10T16:35:27.283000', NULL, NULL, '10000000000423', 1, NULL, '1', NULL, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO lr_transaction (`id`, `Hjtype`, `transaction_number`, `transaction_type`, `transaction_status`, `transaction_source`, `source_property_ids`, `target_property_ids`, `old_property_id`, `parent_property_ids`, `tenure_type`, `is_search_oldfile`, `registration_fee`, `consideration`, `interest_money`, `create_date`, `complete_date`, `start_date`, `expiration_date`, `sign_date`, `registration_date`, `application_date`, `firstpay_date`, `balance_date`, `balance_sum`, `partial`, `pageNumber`, `cert_nos`, `term_year`, `term_month`, `term_year_ext`, `term_month_ext`, `lease_extension`, `lease_duration`, `duration`, `build_term`, `build_value`, `pay_period_year`, `pay_period_month`, `volume`, `folio`, `volume_linked`, `folio_linked`, `recordingno`, `internal_receipt_no`, `serial_number`, `general_number`, `related_number`, `related_page_number`, `related_volume`, `deed_case`, `related_instr_number`, `lodgment_number`, `boxno`, `special_condition`, `inscription`, `inscription2`, `reg_initials`, `blockplot`, `volumefolio`, `filetype`, `region`, `district`, `is_delivered`, `is_right_required`, `is_inactive`, `is_mem_transaction`, `comments`, `site_analysis`, `inspection_officer`, `gis_params`, `tran1`, `tran2`, `tran_date1`, `tran_date2`, `tran_dict1`, `tran_dict2`, `tran_cost1`, `tran_cost2`, `tran_count1`, `tran_count2`, `version`, `begin_lifespan_version`, `end_lifespan_version`, `demandnotice_number`, `batch`, `transaction_index`, `term_day`, `consideration_currency`, `temp_consideration`, `improvement_amount_currency`, `data_corrected_transaction_number`, `data_corrected_transaction_type`, `data_corrected_comments`, `data_corrected_create_date`, `data_corrected_complete_date`, `recommendation_memorandum`, `SurveyPlan`) VALUES ('10000000001099', 'com.landsystems.lrs.model.Transaction', 'PLS000001099', '1', '24', '30', 'BP464', 'BP464', NULL, NULL, '1', 0, NULL, 0.0, NULL, '2014-12-10T16:36:06.817000', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 2.901, 0, NULL, NULL, NULL, NULL, NULL, NULL, '1', '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, '1', '557', '1', 0, 0, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1761', '1', NULL, NULL, NULL, NULL, '1', '2014-12-10T16:36:06.800000', NULL, NULL, '10000000000426', 0, NULL, '1', NULL, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO lr_transaction (`id`, `Hjtype`, `transaction_number`, `transaction_type`, `transaction_status`, `transaction_source`, `source_property_ids`, `target_property_ids`, `old_property_id`, `parent_property_ids`, `tenure_type`, `is_search_oldfile`, `registration_fee`, `consideration`, `interest_money`, `create_date`, `complete_date`, `start_date`, `expiration_date`, `sign_date`, `registration_date`, `application_date`, `firstpay_date`, `balance_date`, `balance_sum`, `partial`, `pageNumber`, `cert_nos`, `term_year`, `term_month`, `term_year_ext`, `term_month_ext`, `lease_extension`, `lease_duration`, `duration`, `build_term`, `build_value`, `pay_period_year`, `pay_period_month`, `volume`, `folio`, `volume_linked`, `folio_linked`, `recordingno`, `internal_receipt_no`, `serial_number`, `general_number`, `related_number`, `related_page_number`, `related_volume`, `deed_case`, `related_instr_number`, `lodgment_number`, `boxno`, `special_condition`, `inscription`, `inscription2`, `reg_initials`, `blockplot`, `volumefolio`, `filetype`, `region`, `district`, `is_delivered`, `is_right_required`, `is_inactive`, `is_mem_transaction`, `comments`, `site_analysis`, `inspection_officer`, `gis_params`, `tran1`, `tran2`, `tran_date1`, `tran_date2`, `tran_dict1`, `tran_dict2`, `tran_cost1`, `tran_cost2`, `tran_count1`, `tran_count2`, `version`, `begin_lifespan_version`, `end_lifespan_version`, `demandnotice_number`, `batch`, `transaction_index`, `term_day`, `consideration_currency`, `temp_consideration`, `improvement_amount_currency`, `data_corrected_transaction_number`, `data_corrected_transaction_type`, `data_corrected_comments`, `data_corrected_create_date`, `data_corrected_complete_date`, `recommendation_memorandum`, `SurveyPlan`) VALUES ('10000000001100', 'com.landsystems.lrs.model.Transaction', 'P-PLS000000673', '5', '24', '31', 'BP464', 'BP464', NULL, NULL, '1', 0, NULL, NULL, NULL, '2014-12-10T16:45:18.743000', NULL, '1971-05-04T00:00:00', '1991-01-09T00:00:00', '1971-03-02T00:00:00', '1971-03-02T00:00:00', '1969-12-01T00:00:00', NULL, NULL, 2.901, 0, NULL, NULL, 19, 8, NULL, NULL, '1', '1', NULL, NULL, NULL, 5, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, '1', '557', '1', 1, 0, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1', '1', NULL, NULL, NULL, NULL, '1', '2014-12-10T16:45:18.743000', NULL, NULL, '10000000000426', 1, 6, '1', NULL, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO lr_transaction (`id`, `Hjtype`, `transaction_number`, `transaction_type`, `transaction_status`, `transaction_source`, `source_property_ids`, `target_property_ids`, `old_property_id`, `parent_property_ids`, `tenure_type`, `is_search_oldfile`, `registration_fee`, `consideration`, `interest_money`, `create_date`, `complete_date`, `start_date`, `expiration_date`, `sign_date`, `registration_date`, `application_date`, `firstpay_date`, `balance_date`, `balance_sum`, `partial`, `pageNumber`, `cert_nos`, `term_year`, `term_month`, `term_year_ext`, `term_month_ext`, `lease_extension`, `lease_duration`, `duration`, `build_term`, `build_value`, `pay_period_year`, `pay_period_month`, `volume`, `folio`, `volume_linked`, `folio_linked`, `recordingno`, `internal_receipt_no`, `serial_number`, `general_number`, `related_number`, `related_page_number`, `related_volume`, `deed_case`, `related_instr_number`, `lodgment_number`, `boxno`, `special_condition`, `inscription`, `inscription2`, `reg_initials`, `blockplot`, `volumefolio`, `filetype`, `region`, `district`, `is_delivered`, `is_right_required`, `is_inactive`, `is_mem_transaction`, `comments`, `site_analysis`, `inspection_officer`, `gis_params`, `tran1`, `tran2`, `tran_date1`, `tran_date2`, `tran_dict1`, `tran_dict2`, `tran_cost1`, `tran_cost2`, `tran_count1`, `tran_count2`, `version`, `begin_lifespan_version`, `end_lifespan_version`, `demandnotice_number`, `batch`, `transaction_index`, `term_day`, `consideration_currency`, `temp_consideration`, `improvement_amount_currency`, `data_corrected_transaction_number`, `data_corrected_transaction_type`, `data_corrected_comments`, `data_corrected_create_date`, `data_corrected_complete_date`, `recommendation_memorandum`, `SurveyPlan`) VALUES ('10000000001101', 'com.landsystems.lrs.model.Transaction', 'P-PLS000000674', '3', '24', '31', 'BP353', 'BP353', NULL, NULL, '1', 0, NULL, NULL, NULL, '2014-12-11T09:12:25.163000', NULL, '1973-07-26T00:00:00', '2072-07-25T00:00:00', '1976-02-26T00:00:00', '1976-03-02T00:00:00', NULL, NULL, NULL, 99.96, 0, NULL, NULL, 99, NULL, NULL, NULL, '1', '1', NULL, 2, 8000.0, 5, NULL, '2(CofO)', '240', NULL, NULL, '240', NULL, NULL, NULL, 'P-PLS000000668', NULL, NULL, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1', '557', '1', 1, 0, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1', '1', NULL, NULL, NULL, NULL, '1', '2014-12-11T09:12:25.147000', NULL, NULL, '10000000000418', 2, NULL, '1', NULL, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO lr_transaction (`id`, `Hjtype`, `transaction_number`, `transaction_type`, `transaction_status`, `transaction_source`, `source_property_ids`, `target_property_ids`, `old_property_id`, `parent_property_ids`, `tenure_type`, `is_search_oldfile`, `registration_fee`, `consideration`, `interest_money`, `create_date`, `complete_date`, `start_date`, `expiration_date`, `sign_date`, `registration_date`, `application_date`, `firstpay_date`, `balance_date`, `balance_sum`, `partial`, `pageNumber`, `cert_nos`, `term_year`, `term_month`, `term_year_ext`, `term_month_ext`, `lease_extension`, `lease_duration`, `duration`, `build_term`, `build_value`, `pay_period_year`, `pay_period_month`, `volume`, `folio`, `volume_linked`, `folio_linked`, `recordingno`, `internal_receipt_no`, `serial_number`, `general_number`, `related_number`, `related_page_number`, `related_volume`, `deed_case`, `related_instr_number`, `lodgment_number`, `boxno`, `special_condition`, `inscription`, `inscription2`, `reg_initials`, `blockplot`, `volumefolio`, `filetype`, `region`, `district`, `is_delivered`, `is_right_required`, `is_inactive`, `is_mem_transaction`, `comments`, `site_analysis`, `inspection_officer`, `gis_params`, `tran1`, `tran2`, `tran_date1`, `tran_date2`, `tran_dict1`, `tran_dict2`, `tran_cost1`, `tran_cost2`, `tran_count1`, `tran_count2`, `version`, `begin_lifespan_version`, `end_lifespan_version`, `demandnotice_number`, `batch`, `transaction_index`, `term_day`, `consideration_currency`, `temp_consideration`, `improvement_amount_currency`, `data_corrected_transaction_number`, `data_corrected_transaction_type`, `data_corrected_comments`, `data_corrected_create_date`, `data_corrected_complete_date`, `recommendation_memorandum`, `SurveyPlan`) VALUES ('10000000001102', 'com.landsystems.lrs.model.Transaction', 'PLS000001102', '1', '24', '30', 'BP2099', 'BP2099', NULL, NULL, '1', 0, NULL, 0.0, NULL, '2014-12-11T09:12:56.483000', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 48.19, 0, NULL, NULL, NULL, NULL, NULL, NULL, '1', '1', NULL, 2, 100000.0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1', '557', '1', 0, 0, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1761', '1', NULL, NULL, NULL, NULL, '1', '2014-12-11T09:12:56.467000', NULL, NULL, '10000000000427', 0, NULL, '1', NULL, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO lr_transaction (`id`, `Hjtype`, `transaction_number`, `transaction_type`, `transaction_status`, `transaction_source`, `source_property_ids`, `target_property_ids`, `old_property_id`, `parent_property_ids`, `tenure_type`, `is_search_oldfile`, `registration_fee`, `consideration`, `interest_money`, `create_date`, `complete_date`, `start_date`, `expiration_date`, `sign_date`, `registration_date`, `application_date`, `firstpay_date`, `balance_date`, `balance_sum`, `partial`, `pageNumber`, `cert_nos`, `term_year`, `term_month`, `term_year_ext`, `term_month_ext`, `lease_extension`, `lease_duration`, `duration`, `build_term`, `build_value`, `pay_period_year`, `pay_period_month`, `volume`, `folio`, `volume_linked`, `folio_linked`, `recordingno`, `internal_receipt_no`, `serial_number`, `general_number`, `related_number`, `related_page_number`, `related_volume`, `deed_case`, `related_instr_number`, `lodgment_number`, `boxno`, `special_condition`, `inscription`, `inscription2`, `reg_initials`, `blockplot`, `volumefolio`, `filetype`, `region`, `district`, `is_delivered`, `is_right_required`, `is_inactive`, `is_mem_transaction`, `comments`, `site_analysis`, `inspection_officer`, `gis_params`, `tran1`, `tran2`, `tran_date1`, `tran_date2`, `tran_dict1`, `tran_dict2`, `tran_cost1`, `tran_cost2`, `tran_count1`, `tran_count2`, `version`, `begin_lifespan_version`, `end_lifespan_version`, `demandnotice_number`, `batch`, `transaction_index`, `term_day`, `consideration_currency`, `temp_consideration`, `improvement_amount_currency`, `data_corrected_transaction_number`, `data_corrected_transaction_type`, `data_corrected_comments`, `data_corrected_create_date`, `data_corrected_complete_date`, `recommendation_memorandum`, `SurveyPlan`) VALUES ('10000000001103', 'com.landsystems.lrs.model.Transaction', 'P-PLS000000675', '3', '24', '31', 'BP1349', 'BP1349', NULL, NULL, '1', 0, NULL, NULL, NULL, '2014-12-11T09:13:45.300000', NULL, '1973-09-10T00:00:00', '2013-09-09T00:00:00', '1976-07-01T00:00:00', '1976-07-06T00:00:00', NULL, NULL, NULL, 59.25, 0, NULL, NULL, 40, NULL, NULL, NULL, '1', '1', NULL, 2, 2000.0, 5, NULL, '1(CofO)', '22', NULL, NULL, '22', NULL, NULL, NULL, 'P-PLS000000672', NULL, NULL, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1', '557', '1', 1, 0, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1', '1', NULL, NULL, NULL, NULL, '1', '2014-12-11T09:13:45.287000', NULL, NULL, '10000000000423', 2, NULL, '1', NULL, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO lr_transaction (`id`, `Hjtype`, `transaction_number`, `transaction_type`, `transaction_status`, `transaction_source`, `source_property_ids`, `target_property_ids`, `old_property_id`, `parent_property_ids`, `tenure_type`, `is_search_oldfile`, `registration_fee`, `consideration`, `interest_money`, `create_date`, `complete_date`, `start_date`, `expiration_date`, `sign_date`, `registration_date`, `application_date`, `firstpay_date`, `balance_date`, `balance_sum`, `partial`, `pageNumber`, `cert_nos`, `term_year`, `term_month`, `term_year_ext`, `term_month_ext`, `lease_extension`, `lease_duration`, `duration`, `build_term`, `build_value`, `pay_period_year`, `pay_period_month`, `volume`, `folio`, `volume_linked`, `folio_linked`, `recordingno`, `internal_receipt_no`, `serial_number`, `general_number`, `related_number`, `related_page_number`, `related_volume`, `deed_case`, `related_instr_number`, `lodgment_number`, `boxno`, `special_condition`, `inscription`, `inscription2`, `reg_initials`, `blockplot`, `volumefolio`, `filetype`, `region`, `district`, `is_delivered`, `is_right_required`, `is_inactive`, `is_mem_transaction`, `comments`, `site_analysis`, `inspection_officer`, `gis_params`, `tran1`, `tran2`, `tran_date1`, `tran_date2`, `tran_dict1`, `tran_dict2`, `tran_cost1`, `tran_cost2`, `tran_count1`, `tran_count2`, `version`, `begin_lifespan_version`, `end_lifespan_version`, `demandnotice_number`, `batch`, `transaction_index`, `term_day`, `consideration_currency`, `temp_consideration`, `improvement_amount_currency`, `data_corrected_transaction_number`, `data_corrected_transaction_type`, `data_corrected_comments`, `data_corrected_create_date`, `data_corrected_complete_date`, `recommendation_memorandum`, `SurveyPlan`) VALUES ('10000000001104', 'com.landsystems.lrs.model.Transaction', 'PLS000001104', '1', '24', '30', 'BP3632', 'BP3632', NULL, NULL, '1', 0, NULL, 0.0, NULL, '2014-12-11T09:15:08.077000', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 66.08, 0, NULL, NULL, NULL, NULL, NULL, NULL, '1', '1', NULL, 2, 20000.0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1', '557', '1', 0, 0, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1761', '1', NULL, NULL, NULL, NULL, '1', '2014-12-11T09:15:08.060000', NULL, NULL, '10000000000428', 0, NULL, '1', NULL, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO lr_transaction (`id`, `Hjtype`, `transaction_number`, `transaction_type`, `transaction_status`, `transaction_source`, `source_property_ids`, `target_property_ids`, `old_property_id`, `parent_property_ids`, `tenure_type`, `is_search_oldfile`, `registration_fee`, `consideration`, `interest_money`, `create_date`, `complete_date`, `start_date`, `expiration_date`, `sign_date`, `registration_date`, `application_date`, `firstpay_date`, `balance_date`, `balance_sum`, `partial`, `pageNumber`, `cert_nos`, `term_year`, `term_month`, `term_year_ext`, `term_month_ext`, `lease_extension`, `lease_duration`, `duration`, `build_term`, `build_value`, `pay_period_year`, `pay_period_month`, `volume`, `folio`, `volume_linked`, `folio_linked`, `recordingno`, `internal_receipt_no`, `serial_number`, `general_number`, `related_number`, `related_page_number`, `related_volume`, `deed_case`, `related_instr_number`, `lodgment_number`, `boxno`, `special_condition`, `inscription`, `inscription2`, `reg_initials`, `blockplot`, `volumefolio`, `filetype`, `region`, `district`, `is_delivered`, `is_right_required`, `is_inactive`, `is_mem_transaction`, `comments`, `site_analysis`, `inspection_officer`, `gis_params`, `tran1`, `tran2`, `tran_date1`, `tran_date2`, `tran_dict1`, `tran_dict2`, `tran_cost1`, `tran_cost2`, `tran_count1`, `tran_count2`, `version`, `begin_lifespan_version`, `end_lifespan_version`, `demandnotice_number`, `batch`, `transaction_index`, `term_day`, `consideration_currency`, `temp_consideration`, `improvement_amount_currency`, `data_corrected_transaction_number`, `data_corrected_transaction_type`, `data_corrected_comments`, `data_corrected_create_date`, `data_corrected_complete_date`, `recommendation_memorandum`, `SurveyPlan`) VALUES ('10000000001106', 'com.landsystems.lrs.model.Transaction', 'PLS000001106', '1', '26', '30', 'BP3728', 'BP3728', NULL, NULL, '1', 0, NULL, 0.0, NULL, '2014-12-11T09:22:28.250000', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 89.75, 0, NULL, NULL, NULL, NULL, NULL, NULL, '1', '1', NULL, 2, 30000.0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1', '557', '1', 0, 0, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1761', '1', NULL, NULL, NULL, NULL, '1', '2014-12-11T09:22:28.233000', NULL, NULL, '10000000000430', 0, NULL, '1', NULL, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO lr_transaction (`id`, `Hjtype`, `transaction_number`, `transaction_type`, `transaction_status`, `transaction_source`, `source_property_ids`, `target_property_ids`, `old_property_id`, `parent_property_ids`, `tenure_type`, `is_search_oldfile`, `registration_fee`, `consideration`, `interest_money`, `create_date`, `complete_date`, `start_date`, `expiration_date`, `sign_date`, `registration_date`, `application_date`, `firstpay_date`, `balance_date`, `balance_sum`, `partial`, `pageNumber`, `cert_nos`, `term_year`, `term_month`, `term_year_ext`, `term_month_ext`, `lease_extension`, `lease_duration`, `duration`, `build_term`, `build_value`, `pay_period_year`, `pay_period_month`, `volume`, `folio`, `volume_linked`, `folio_linked`, `recordingno`, `internal_receipt_no`, `serial_number`, `general_number`, `related_number`, `related_page_number`, `related_volume`, `deed_case`, `related_instr_number`, `lodgment_number`, `boxno`, `special_condition`, `inscription`, `inscription2`, `reg_initials`, `blockplot`, `volumefolio`, `filetype`, `region`, `district`, `is_delivered`, `is_right_required`, `is_inactive`, `is_mem_transaction`, `comments`, `site_analysis`, `inspection_officer`, `gis_params`, `tran1`, `tran2`, `tran_date1`, `tran_date2`, `tran_dict1`, `tran_dict2`, `tran_cost1`, `tran_cost2`, `tran_count1`, `tran_count2`, `version`, `begin_lifespan_version`, `end_lifespan_version`, `demandnotice_number`, `batch`, `transaction_index`, `term_day`, `consideration_currency`, `temp_consideration`, `improvement_amount_currency`, `data_corrected_transaction_number`, `data_corrected_transaction_type`, `data_corrected_comments`, `data_corrected_create_date`, `data_corrected_complete_date`, `recommendation_memorandum`, `SurveyPlan`) VALUES ('10000000001109', 'com.landsystems.lrs.model.Transaction', 'PLS000001109', '1', '24', '30', 'BP3912', 'BP3912', NULL, NULL, '1', 0, NULL, 0.0, NULL, '2014-12-11T09:25:48.417000', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 18.56, 0, NULL, NULL, NULL, NULL, NULL, NULL, '1', '1', NULL, NULL, 160000.0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1', '557', '1', 0, 0, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1761', '1', NULL, NULL, NULL, NULL, '1', '2014-12-11T09:25:48.403000', NULL, NULL, '10000000000431', 0, NULL, '1', NULL, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO lr_transaction (`id`, `Hjtype`, `transaction_number`, `transaction_type`, `transaction_status`, `transaction_source`, `source_property_ids`, `target_property_ids`, `old_property_id`, `parent_property_ids`, `tenure_type`, `is_search_oldfile`, `registration_fee`, `consideration`, `interest_money`, `create_date`, `complete_date`, `start_date`, `expiration_date`, `sign_date`, `registration_date`, `application_date`, `firstpay_date`, `balance_date`, `balance_sum`, `partial`, `pageNumber`, `cert_nos`, `term_year`, `term_month`, `term_year_ext`, `term_month_ext`, `lease_extension`, `lease_duration`, `duration`, `build_term`, `build_value`, `pay_period_year`, `pay_period_month`, `volume`, `folio`, `volume_linked`, `folio_linked`, `recordingno`, `internal_receipt_no`, `serial_number`, `general_number`, `related_number`, `related_page_number`, `related_volume`, `deed_case`, `related_instr_number`, `lodgment_number`, `boxno`, `special_condition`, `inscription`, `inscription2`, `reg_initials`, `blockplot`, `volumefolio`, `filetype`, `region`, `district`, `is_delivered`, `is_right_required`, `is_inactive`, `is_mem_transaction`, `comments`, `site_analysis`, `inspection_officer`, `gis_params`, `tran1`, `tran2`, `tran_date1`, `tran_date2`, `tran_dict1`, `tran_dict2`, `tran_cost1`, `tran_cost2`, `tran_count1`, `tran_count2`, `version`, `begin_lifespan_version`, `end_lifespan_version`, `demandnotice_number`, `batch`, `transaction_index`, `term_day`, `consideration_currency`, `temp_consideration`, `improvement_amount_currency`, `data_corrected_transaction_number`, `data_corrected_transaction_type`, `data_corrected_comments`, `data_corrected_create_date`, `data_corrected_complete_date`, `recommendation_memorandum`, `SurveyPlan`) VALUES ('10000000001110', 'com.landsystems.lrs.model.Transaction', 'PLS000001110', '1', '24', '30', 'CofO14982', 'CofO14982', NULL, NULL, '1', 0, NULL, 0.0, NULL, '2014-12-11T09:27:23.823000', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1.8, 0, NULL, NULL, NULL, NULL, NULL, NULL, '1', '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1', '557', '1', 0, 0, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1761', '1', NULL, NULL, NULL, NULL, '1', '2014-12-11T09:27:23.807000', NULL, NULL, '10000000000432', 0, NULL, '1', NULL, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO lr_transaction (`id`, `Hjtype`, `transaction_number`, `transaction_type`, `transaction_status`, `transaction_source`, `source_property_ids`, `target_property_ids`, `old_property_id`, `parent_property_ids`, `tenure_type`, `is_search_oldfile`, `registration_fee`, `consideration`, `interest_money`, `create_date`, `complete_date`, `start_date`, `expiration_date`, `sign_date`, `registration_date`, `application_date`, `firstpay_date`, `balance_date`, `balance_sum`, `partial`, `pageNumber`, `cert_nos`, `term_year`, `term_month`, `term_year_ext`, `term_month_ext`, `lease_extension`, `lease_duration`, `duration`, `build_term`, `build_value`, `pay_period_year`, `pay_period_month`, `volume`, `folio`, `volume_linked`, `folio_linked`, `recordingno`, `internal_receipt_no`, `serial_number`, `general_number`, `related_number`, `related_page_number`, `related_volume`, `deed_case`, `related_instr_number`, `lodgment_number`, `boxno`, `special_condition`, `inscription`, `inscription2`, `reg_initials`, `blockplot`, `volumefolio`, `filetype`, `region`, `district`, `is_delivered`, `is_right_required`, `is_inactive`, `is_mem_transaction`, `comments`, `site_analysis`, `inspection_officer`, `gis_params`, `tran1`, `tran2`, `tran_date1`, `tran_date2`, `tran_dict1`, `tran_dict2`, `tran_cost1`, `tran_cost2`, `tran_count1`, `tran_count2`, `version`, `begin_lifespan_version`, `end_lifespan_version`, `demandnotice_number`, `batch`, `transaction_index`, `term_day`, `consideration_currency`, `temp_consideration`, `improvement_amount_currency`, `data_corrected_transaction_number`, `data_corrected_transaction_type`, `data_corrected_comments`, `data_corrected_create_date`, `data_corrected_complete_date`, `recommendation_memorandum`, `SurveyPlan`) VALUES ('10000000001111', 'com.landsystems.lrs.model.Transaction', 'PLS000001111', '1', '26', '30', 'CofO14181', 'CofO14181', NULL, NULL, '1', 0, NULL, 0.0, NULL, '2014-12-11T09:27:46.437000', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0.0, 0, NULL, NULL, NULL, NULL, NULL, NULL, '1', '1', NULL, NULL, 0.0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1', '557', '1', 0, 0, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1761', '1', NULL, NULL, NULL, NULL, '1', '2014-12-11T09:27:46.437000', NULL, NULL, '10000000000433', 0, NULL, '1', NULL, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO lr_transaction (`id`, `Hjtype`, `transaction_number`, `transaction_type`, `transaction_status`, `transaction_source`, `source_property_ids`, `target_property_ids`, `old_property_id`, `parent_property_ids`, `tenure_type`, `is_search_oldfile`, `registration_fee`, `consideration`, `interest_money`, `create_date`, `complete_date`, `start_date`, `expiration_date`, `sign_date`, `registration_date`, `application_date`, `firstpay_date`, `balance_date`, `balance_sum`, `partial`, `pageNumber`, `cert_nos`, `term_year`, `term_month`, `term_year_ext`, `term_month_ext`, `lease_extension`, `lease_duration`, `duration`, `build_term`, `build_value`, `pay_period_year`, `pay_period_month`, `volume`, `folio`, `volume_linked`, `folio_linked`, `recordingno`, `internal_receipt_no`, `serial_number`, `general_number`, `related_number`, `related_page_number`, `related_volume`, `deed_case`, `related_instr_number`, `lodgment_number`, `boxno`, `special_condition`, `inscription`, `inscription2`, `reg_initials`, `blockplot`, `volumefolio`, `filetype`, `region`, `district`, `is_delivered`, `is_right_required`, `is_inactive`, `is_mem_transaction`, `comments`, `site_analysis`, `inspection_officer`, `gis_params`, `tran1`, `tran2`, `tran_date1`, `tran_date2`, `tran_dict1`, `tran_dict2`, `tran_cost1`, `tran_cost2`, `tran_count1`, `tran_count2`, `version`, `begin_lifespan_version`, `end_lifespan_version`, `demandnotice_number`, `batch`, `transaction_index`, `term_day`, `consideration_currency`, `temp_consideration`, `improvement_amount_currency`, `data_corrected_transaction_number`, `data_corrected_transaction_type`, `data_corrected_comments`, `data_corrected_create_date`, `data_corrected_complete_date`, `recommendation_memorandum`, `SurveyPlan`) VALUES ('10000000001112', 'com.landsystems.lrs.model.Transaction', 'PLS000001112', '1', '24', '30', 'BP3503', 'BP3503', NULL, NULL, '1', 0, NULL, 0.0, NULL, '2014-12-11T09:27:58.123000', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 141.9, 0, NULL, NULL, NULL, NULL, NULL, NULL, '1', '1', NULL, 2, 50000.0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1', '557', '1', 0, 0, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1761', '1', NULL, NULL, NULL, NULL, '1', '2014-12-11T09:27:58.123000', NULL, NULL, '10000000000434', 0, NULL, '1', NULL, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO lr_transaction (`id`, `Hjtype`, `transaction_number`, `transaction_type`, `transaction_status`, `transaction_source`, `source_property_ids`, `target_property_ids`, `old_property_id`, `parent_property_ids`, `tenure_type`, `is_search_oldfile`, `registration_fee`, `consideration`, `interest_money`, `create_date`, `complete_date`, `start_date`, `expiration_date`, `sign_date`, `registration_date`, `application_date`, `firstpay_date`, `balance_date`, `balance_sum`, `partial`, `pageNumber`, `cert_nos`, `term_year`, `term_month`, `term_year_ext`, `term_month_ext`, `lease_extension`, `lease_duration`, `duration`, `build_term`, `build_value`, `pay_period_year`, `pay_period_month`, `volume`, `folio`, `volume_linked`, `folio_linked`, `recordingno`, `internal_receipt_no`, `serial_number`, `general_number`, `related_number`, `related_page_number`, `related_volume`, `deed_case`, `related_instr_number`, `lodgment_number`, `boxno`, `special_condition`, `inscription`, `inscription2`, `reg_initials`, `blockplot`, `volumefolio`, `filetype`, `region`, `district`, `is_delivered`, `is_right_required`, `is_inactive`, `is_mem_transaction`, `comments`, `site_analysis`, `inspection_officer`, `gis_params`, `tran1`, `tran2`, `tran_date1`, `tran_date2`, `tran_dict1`, `tran_dict2`, `tran_cost1`, `tran_cost2`, `tran_count1`, `tran_count2`, `version`, `begin_lifespan_version`, `end_lifespan_version`, `demandnotice_number`, `batch`, `transaction_index`, `term_day`, `consideration_currency`, `temp_consideration`, `improvement_amount_currency`, `data_corrected_transaction_number`, `data_corrected_transaction_type`, `data_corrected_comments`, `data_corrected_create_date`, `data_corrected_complete_date`, `recommendation_memorandum`, `SurveyPlan`) VALUES ('10000000001113', 'com.landsystems.lrs.model.Transaction', 'P-PLS000000678', '5', '26', '31', 'BP3728', 'BP3728', NULL, NULL, '1', 0, NULL, NULL, NULL, '2014-12-11T09:31:22.070000', NULL, '1977-11-09T00:00:00', '2076-11-08T00:00:00', '1977-11-09T00:00:00', '1977-11-09T00:00:00', '1975-08-04T00:00:00', NULL, NULL, 89.75, 0, NULL, NULL, 99, NULL, NULL, NULL, '1', '1', NULL, 2, 30000.0, 5, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1', '557', '1', 1, 0, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1', '1', NULL, NULL, NULL, NULL, '1', '2014-12-11T09:31:22.070000', NULL, NULL, '10000000000430', 1, NULL, '1', NULL, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO lr_transaction (`id`, `Hjtype`, `transaction_number`, `transaction_type`, `transaction_status`, `transaction_source`, `source_property_ids`, `target_property_ids`, `old_property_id`, `parent_property_ids`, `tenure_type`, `is_search_oldfile`, `registration_fee`, `consideration`, `interest_money`, `create_date`, `complete_date`, `start_date`, `expiration_date`, `sign_date`, `registration_date`, `application_date`, `firstpay_date`, `balance_date`, `balance_sum`, `partial`, `pageNumber`, `cert_nos`, `term_year`, `term_month`, `term_year_ext`, `term_month_ext`, `lease_extension`, `lease_duration`, `duration`, `build_term`, `build_value`, `pay_period_year`, `pay_period_month`, `volume`, `folio`, `volume_linked`, `folio_linked`, `recordingno`, `internal_receipt_no`, `serial_number`, `general_number`, `related_number`, `related_page_number`, `related_volume`, `deed_case`, `related_instr_number`, `lodgment_number`, `boxno`, `special_condition`, `inscription`, `inscription2`, `reg_initials`, `blockplot`, `volumefolio`, `filetype`, `region`, `district`, `is_delivered`, `is_right_required`, `is_inactive`, `is_mem_transaction`, `comments`, `site_analysis`, `inspection_officer`, `gis_params`, `tran1`, `tran2`, `tran_date1`, `tran_date2`, `tran_dict1`, `tran_dict2`, `tran_cost1`, `tran_cost2`, `tran_count1`, `tran_count2`, `version`, `begin_lifespan_version`, `end_lifespan_version`, `demandnotice_number`, `batch`, `transaction_index`, `term_day`, `consideration_currency`, `temp_consideration`, `improvement_amount_currency`, `data_corrected_transaction_number`, `data_corrected_transaction_type`, `data_corrected_comments`, `data_corrected_create_date`, `data_corrected_complete_date`, `recommendation_memorandum`, `SurveyPlan`) VALUES ('10000000001114', 'com.landsystems.lrs.model.Transaction', 'PLS000001114', '1', '24', '30', 'BP1548', 'BP1548', NULL, NULL, '1', 0, NULL, 0.0, NULL, '2014-12-11T09:31:40.603000', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 365.56, 0, NULL, NULL, NULL, NULL, NULL, NULL, '1', '1', NULL, 2, 40000.0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1', '557', '1', 0, 0, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1761', '1', NULL, NULL, NULL, NULL, '1', '2014-12-11T09:31:40.603000', NULL, NULL, '10000000000435', 0, NULL, '1', NULL, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO lr_transaction (`id`, `Hjtype`, `transaction_number`, `transaction_type`, `transaction_status`, `transaction_source`, `source_property_ids`, `target_property_ids`, `old_property_id`, `parent_property_ids`, `tenure_type`, `is_search_oldfile`, `registration_fee`, `consideration`, `interest_money`, `create_date`, `complete_date`, `start_date`, `expiration_date`, `sign_date`, `registration_date`, `application_date`, `firstpay_date`, `balance_date`, `balance_sum`, `partial`, `pageNumber`, `cert_nos`, `term_year`, `term_month`, `term_year_ext`, `term_month_ext`, `lease_extension`, `lease_duration`, `duration`, `build_term`, `build_value`, `pay_period_year`, `pay_period_month`, `volume`, `folio`, `volume_linked`, `folio_linked`, `recordingno`, `internal_receipt_no`, `serial_number`, `general_number`, `related_number`, `related_page_number`, `related_volume`, `deed_case`, `related_instr_number`, `lodgment_number`, `boxno`, `special_condition`, `inscription`, `inscription2`, `reg_initials`, `blockplot`, `volumefolio`, `filetype`, `region`, `district`, `is_delivered`, `is_right_required`, `is_inactive`, `is_mem_transaction`, `comments`, `site_analysis`, `inspection_officer`, `gis_params`, `tran1`, `tran2`, `tran_date1`, `tran_date2`, `tran_dict1`, `tran_dict2`, `tran_cost1`, `tran_cost2`, `tran_count1`, `tran_count2`, `version`, `begin_lifespan_version`, `end_lifespan_version`, `demandnotice_number`, `batch`, `transaction_index`, `term_day`, `consideration_currency`, `temp_consideration`, `improvement_amount_currency`, `data_corrected_transaction_number`, `data_corrected_transaction_type`, `data_corrected_comments`, `data_corrected_create_date`, `data_corrected_complete_date`, `recommendation_memorandum`, `SurveyPlan`) VALUES ('10000000001115', 'com.landsystems.lrs.model.Transaction', 'PLS000001115', '1', '24', '30', 'ACofO14408', 'ACofO14408', NULL, NULL, '1', 0, NULL, 0.0, NULL, '2014-12-11T09:32:39.467000', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0.21, 0, NULL, NULL, NULL, NULL, NULL, NULL, '1', '1', NULL, NULL, 200.0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1', '557', '1', 0, 0, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1761', '1', NULL, NULL, NULL, NULL, '1', '2014-12-11T09:32:39.467000', NULL, NULL, '10000000000436', 0, NULL, '1', NULL, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO lr_transaction (`id`, `Hjtype`, `transaction_number`, `transaction_type`, `transaction_status`, `transaction_source`, `source_property_ids`, `target_property_ids`, `old_property_id`, `parent_property_ids`, `tenure_type`, `is_search_oldfile`, `registration_fee`, `consideration`, `interest_money`, `create_date`, `complete_date`, `start_date`, `expiration_date`, `sign_date`, `registration_date`, `application_date`, `firstpay_date`, `balance_date`, `balance_sum`, `partial`, `pageNumber`, `cert_nos`, `term_year`, `term_month`, `term_year_ext`, `term_month_ext`, `lease_extension`, `lease_duration`, `duration`, `build_term`, `build_value`, `pay_period_year`, `pay_period_month`, `volume`, `folio`, `volume_linked`, `folio_linked`, `recordingno`, `internal_receipt_no`, `serial_number`, `general_number`, `related_number`, `related_page_number`, `related_volume`, `deed_case`, `related_instr_number`, `lodgment_number`, `boxno`, `special_condition`, `inscription`, `inscription2`, `reg_initials`, `blockplot`, `volumefolio`, `filetype`, `region`, `district`, `is_delivered`, `is_right_required`, `is_inactive`, `is_mem_transaction`, `comments`, `site_analysis`, `inspection_officer`, `gis_params`, `tran1`, `tran2`, `tran_date1`, `tran_date2`, `tran_dict1`, `tran_dict2`, `tran_cost1`, `tran_cost2`, `tran_count1`, `tran_count2`, `version`, `begin_lifespan_version`, `end_lifespan_version`, `demandnotice_number`, `batch`, `transaction_index`, `term_day`, `consideration_currency`, `temp_consideration`, `improvement_amount_currency`, `data_corrected_transaction_number`, `data_corrected_transaction_type`, `data_corrected_comments`, `data_corrected_create_date`, `data_corrected_complete_date`, `recommendation_memorandum`, `SurveyPlan`) VALUES ('10000000001116', 'com.landsystems.lrs.model.Transaction', 'PLS000001116', '1', '24', '30', 'BP3710', 'BP3710', NULL, NULL, '1', 0, NULL, 0.0, NULL, '2014-12-11T09:34:17.037000', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 395.64, 0, NULL, NULL, NULL, NULL, NULL, NULL, '1', '1', NULL, 2, 100000.0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1', '557', '1', 0, 0, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1761', '1', NULL, NULL, NULL, NULL, '1', '2014-12-11T09:34:17.020000', NULL, NULL, '10000000000437', 0, NULL, '1', NULL, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO lr_transaction (`id`, `Hjtype`, `transaction_number`, `transaction_type`, `transaction_status`, `transaction_source`, `source_property_ids`, `target_property_ids`, `old_property_id`, `parent_property_ids`, `tenure_type`, `is_search_oldfile`, `registration_fee`, `consideration`, `interest_money`, `create_date`, `complete_date`, `start_date`, `expiration_date`, `sign_date`, `registration_date`, `application_date`, `firstpay_date`, `balance_date`, `balance_sum`, `partial`, `pageNumber`, `cert_nos`, `term_year`, `term_month`, `term_year_ext`, `term_month_ext`, `lease_extension`, `lease_duration`, `duration`, `build_term`, `build_value`, `pay_period_year`, `pay_period_month`, `volume`, `folio`, `volume_linked`, `folio_linked`, `recordingno`, `internal_receipt_no`, `serial_number`, `general_number`, `related_number`, `related_page_number`, `related_volume`, `deed_case`, `related_instr_number`, `lodgment_number`, `boxno`, `special_condition`, `inscription`, `inscription2`, `reg_initials`, `blockplot`, `volumefolio`, `filetype`, `region`, `district`, `is_delivered`, `is_right_required`, `is_inactive`, `is_mem_transaction`, `comments`, `site_analysis`, `inspection_officer`, `gis_params`, `tran1`, `tran2`, `tran_date1`, `tran_date2`, `tran_dict1`, `tran_dict2`, `tran_cost1`, `tran_cost2`, `tran_count1`, `tran_count2`, `version`, `begin_lifespan_version`, `end_lifespan_version`, `demandnotice_number`, `batch`, `transaction_index`, `term_day`, `consideration_currency`, `temp_consideration`, `improvement_amount_currency`, `data_corrected_transaction_number`, `data_corrected_transaction_type`, `data_corrected_comments`, `data_corrected_create_date`, `data_corrected_complete_date`, `recommendation_memorandum`, `SurveyPlan`) VALUES ('10000000001117', 'com.landsystems.lrs.model.Transaction', 'P-PLS000000679', '5', '26', '31', 'CofO8144', 'CofO8144', NULL, NULL, '1', 0, NULL, NULL, NULL, '2014-12-11T09:34:32.943000', NULL, '1956-11-16T00:00:00', '1996-11-15T00:00:00', '1956-11-16T00:00:00', '1956-11-16T00:00:00', '1956-08-13T00:00:00', NULL, NULL, 4.19, 0, NULL, NULL, 40, NULL, NULL, NULL, '1', '1', NULL, 2, 1000.0, 10, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, NULL, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1', '557', '1', 1, 0, 0, 0, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1', '1', NULL, NULL, NULL, NULL, '1', '2014-12-11T09:34:32.927000', NULL, NULL, '10000000000425', 1, NULL, '1', NULL, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO lr_transaction (`id`, `Hjtype`, `transaction_number`, `transaction_type`, `transaction_status`, `transaction_source`, `source_property_ids`, `target_property_ids`, `old_property_id`, `parent_property_ids`, `tenure_type`, `is_search_oldfile`, `registration_fee`, `consideration`, `interest_money`, `create_date`, `complete_date`, `start_date`, `expiration_date`, `sign_date`, `registration_date`, `application_date`, `firstpay_date`, `balance_date`, `balance_sum`, `partial`, `pageNumber`, `cert_nos`, `term_year`, `term_month`, `term_year_ext`, `term_month_ext`, `lease_extension`, `lease_duration`, `duration`, `build_term`, `build_value`, `pay_period_year`, `pay_period_month`, `volume`, `folio`, `volume_linked`, `folio_linked`, `recordingno`, `internal_receipt_no`, `serial_number`, `general_number`, `related_number`, `related_page_number`, `related_volume`, `deed_case`, `related_instr_number`, `lodgment_number`, `boxno`, `special_condition`, `inscription`, `inscription2`, `reg_initials`, `blockplot`, `volumefolio`, `filetype`, `region`, `district`, `is_delivered`, `is_right_required`, `is_inactive`, `is_mem_transaction`, `comments`, `site_analysis`, `inspection_officer`, `gis_params`, `tran1`, `tran2`, `tran_date1`, `tran_date2`, `tran_dict1`, `tran_dict2`, `tran_cost1`, `tran_cost2`, `tran_count1`, `tran_count2`, `version`, `begin_lifespan_version`, `end_lifespan_version`, `demandnotice_number`, `batch`, `transaction_index`, `term_day`, `consideration_currency`, `temp_consideration`, `improvement_amount_currency`, `data_corrected_transaction_number`, `data_corrected_transaction_type`, `data_corrected_comments`, `data_corrected_create_date`, `data_corrected_complete_date`, `recommendation_memorandum`, `SurveyPlan`) VALUES ('10000000001118', 'com.landsystems.lrs.model.Transaction', 'P-PLS000000680', '5', '24', '31', 'BP3912', 'BP3912', NULL, NULL, '1', 0, NULL, NULL, NULL, '2014-12-11T09:34:36.837000', NULL, '1989-04-17T00:00:00', '2088-04-16T00:00:00', '1989-01-14T00:00:00', '1989-01-14T00:00:00', '1975-09-18T00:00:00', NULL, NULL, 18.56, 0, NULL, NULL, 99, NULL, NULL, NULL, '1', '1', NULL, NULL, 160000.0, 5, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, NULL, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1', '557', '1', 1, 0, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1', '1', NULL, NULL, NULL, NULL, '1', '2014-12-11T09:34:36.837000', NULL, NULL, '10000000000431', 1, NULL, '1', NULL, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);
INSERT INTO lr_transaction (`id`, `Hjtype`, `transaction_number`, `transaction_type`, `transaction_status`, `transaction_source`, `source_property_ids`, `target_property_ids`, `old_property_id`, `parent_property_ids`, `tenure_type`, `is_search_oldfile`, `registration_fee`, `consideration`, `interest_money`, `create_date`, `complete_date`, `start_date`, `expiration_date`, `sign_date`, `registration_date`, `application_date`, `firstpay_date`, `balance_date`, `balance_sum`, `partial`, `pageNumber`, `cert_nos`, `term_year`, `term_month`, `term_year_ext`, `term_month_ext`, `lease_extension`, `lease_duration`, `duration`, `build_term`, `build_value`, `pay_period_year`, `pay_period_month`, `volume`, `folio`, `volume_linked`, `folio_linked`, `recordingno`, `internal_receipt_no`, `serial_number`, `general_number`, `related_number`, `related_page_number`, `related_volume`, `deed_case`, `related_instr_number`, `lodgment_number`, `boxno`, `special_condition`, `inscription`, `inscription2`, `reg_initials`, `blockplot`, `volumefolio`, `filetype`, `region`, `district`, `is_delivered`, `is_right_required`, `is_inactive`, `is_mem_transaction`, `comments`, `site_analysis`, `inspection_officer`, `gis_params`, `tran1`, `tran2`, `tran_date1`, `tran_date2`, `tran_dict1`, `tran_dict2`, `tran_cost1`, `tran_cost2`, `tran_count1`, `tran_count2`, `version`, `begin_lifespan_version`, `end_lifespan_version`, `demandnotice_number`, `batch`, `transaction_index`, `term_day`, `consideration_currency`, `temp_consideration`, `improvement_amount_currency`, `data_corrected_transaction_number`, `data_corrected_transaction_type`, `data_corrected_comments`, `data_corrected_create_date`, `data_corrected_complete_date`, `recommendation_memorandum`, `SurveyPlan`) VALUES ('10000000001119', 'com.landsystems.lrs.model.Transaction', 'P-PLS000000681', '3', '26', '31', 'BP3728', 'BP3728', NULL, NULL, '1', 0, NULL, NULL, NULL, '2014-12-11T09:36:07.980000', NULL, '1978-02-14T00:00:00', '2077-02-13T00:00:00', '1979-08-13T00:00:00', '1979-08-21T00:00:00', NULL, NULL, NULL, 89.75, 0, NULL, NULL, 99, NULL, NULL, NULL, '1', '1', NULL, 2, 30000.0, 5, NULL, '1', '503', NULL, NULL, '503', NULL, NULL, NULL, 'P-PLS000000678', NULL, NULL, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1', '557', '1', 1, 0, 0, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '1', '1', NULL, NULL, NULL, NULL, '1', '2014-12-11T09:36:07.980000', NULL, NULL, '10000000000430', 2, NULL, '1', NULL, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL);


SET FOREIGN_KEY_CHECKS=1;
