(10000000000963,'com.landsystems.lrs.model.Transaction','PLS000000963',1,24,30,'BP3373','BP3373',NULL,NULL,1,0,NULL,0,NULL,'2014-12-10 14:50:57',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,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-10 14:50:57',NULL,NULL,10000000000377,0,NULL,1,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(10000000000964,'com.landsystems.lrs.model.Transaction','P-PLS000000586',3,25,31,'BP1298','BP1298',NULL,NULL,1,0,NULL,NULL,NULL,'2014-12-10 14:51:07',NULL,'1976-08-26 00:00:00','2006-08-25 00:00:00','1990-11-27 00:00:00','1990-12-06 00:00:00',NULL,NULL,NULL,842.08,0,NULL,NULL,30,NULL,NULL,NULL,1,1,NULL,2,20000,5,NULL,'9(CofO)','498',NULL,NULL,'498',NULL,NULL,NULL,'P-PLS000000563',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-10 14:51:07',NULL,NULL,10000000000348,4,NULL,1,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(10000000000965,'com.landsystems.lrs.model.Transaction','P-PLS000000587',5,24,31,'BP2784','BP2784',NULL,NULL,1,0,NULL,NULL,NULL,'2014-12-10 14:51:13',NULL,'1982-09-01 00:00:00','2081-08-31 00:00:00','1982-08-24 00:00:00','1982-08-24 00:00:00','1975-01-31 00:00:00',NULL,NULL,44.48,0,NULL,NULL,99,NULL,NULL,NULL,1,1,NULL,2,30000,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-10 14:51:13',NULL,NULL,10000000000370,1,NULL,1,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(10000000000966,'com.landsystems.lrs.model.Transaction','P-PLS000000588',5,24,31,'BP2364','BP2364',NULL,NULL,1,0,NULL,NULL,NULL,'2014-12-10 14:51:14',NULL,'1975-08-08 00:00:00','2074-08-07 00:00:00','1975-07-16 00:00:00','1975-07-16 00:00:00','1975-04-08 00:00:00',NULL,NULL,45.78,0,NULL,NULL,99,NULL,NULL,NULL,1,1,NULL,2,15000,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-10 14:51:14',NULL,NULL,10000000000369,1,NULL,1,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(10000000000967,'com.landsystems.lrs.model.Transaction','P-PLS000000589',5,24,31,'BP3415','BP3415',NULL,NULL,1,0,NULL,NULL,NULL,'2014-12-10 14:53:11',NULL,'1982-10-26 00:00:00','2081-10-25 00:00:00','1982-03-29 00:00:00','1982-03-29 00:00:00','1975-06-02 00:00:00',NULL,NULL,29.65,0,NULL,NULL,99,NULL,NULL,NULL,1,1,NULL,2,50000,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,1,1,NULL,NULL,NULL,NULL,1,'2014-12-10 14:53:11',NULL,NULL,10000000000375,1,NULL,1,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(10000000000968,'com.landsystems.lrs.model.Transaction','PLS000000968',1,24,30,'BP2834','BP2834',NULL,NULL,1,0,NULL,0,NULL,'2014-12-10 14:55:33',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,67.34,0,NULL,NULL,NULL,NULL,NULL,NULL,1,1,NULL,2,39000,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-10 14:55:33',NULL,NULL,10000000000378,0,NULL,1,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(10000000000969,'com.landsystems.lrs.model.Transaction','PLS000000969',1,24,30,'BP2374','BP2374',NULL,NULL,1,0,NULL,0,NULL,'2014-12-10 14:56:13',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,3.54,0,NULL,NULL,NULL,NULL,NULL,NULL,1,1,NULL,2,200000,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-10 14:56:13',NULL,NULL,10000000000379,0,NULL,1,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(10000000000970,'com.landsystems.lrs.model.Transaction','P-PLS000000590',5,25,31,'PL073','PL073',NULL,NULL,1,0,NULL,NULL,NULL,'2014-12-10 14:57:22',NULL,'1998-12-24 00:00:00','2097-12-23 00:00:00','1998-12-23 00:00:00','1998-12-23 00:00:00','1976-04-26 00:00:00',NULL,NULL,350,0,NULL,NULL,99,NULL,NULL,NULL,1,1,NULL,2,60000,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-10 14:57:22',NULL,NULL,10000000000374,1,NULL,1,NULL,2222,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(10000000000971,'com.landsystems.lrs.model.Transaction','P-PLS000000591',5,24,31,'BP4421','BP4421',NULL,NULL,1,0,NULL,NULL,NULL,'2014-12-10 14:57:23',NULL,'1980-10-05 00:00:00','2079-10-04 00:00:00','1980-09-12 00:00:00','1980-09-12 00:00:00','1976-02-27 00:00:00',NULL,NULL,72.8,0,NULL,NULL,99,NULL,NULL,NULL,1,1,NULL,NULL,NULL,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,'Date of Commencement is not clear.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,1,'2014-12-10 14:57:23',NULL,NULL,10000000000372,1,NULL,1,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(10000000000972,'com.landsystems.lrs.model.Transaction','P-PLS000000592',5,24,31,'BP1357','BP1357',NULL,NULL,1,0,NULL,NULL,NULL,'2014-12-10 14:57:43',NULL,'1974-07-31 00:00:00','1984-07-30 00:00:00','1974-07-09 00:00:00','1974-07-09 00:00:00','1972-05-25 00:00:00',NULL,NULL,1.473,0,NULL,NULL,10,NULL,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,NULL,1,557,1,1,0,0,0,'Note Terms here is specified as 10 Years approx. Coterminous with ML. 12352 Expiring on 11/4/82',NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,1,'2014-12-10 14:57:43',NULL,NULL,10000000000373,1,NULL,1,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(10000000000973,'com.landsystems.lrs.model.Transaction','PLS000000973',1,24,30,'BP2594','BP2594',NULL,NULL,1,0,NULL,0,NULL,'2014-12-10 14:59:37',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,10,0,NULL,NULL,NULL,NULL,NULL,NULL,1,1,NULL,2,7000,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-10 14:59:37',NULL,NULL,10000000000380,0,NULL,1,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(10000000000974,'com.landsystems.lrs.model.Transaction','P-PLS000000593',5,25,31,'BP995','BP995',NULL,NULL,1,0,NULL,NULL,NULL,'2014-12-10 15:00:28',NULL,'1971-12-03 00:00:00','2011-12-02 00:00:00','1971-09-23 00:00:00','1971-09-23 00:00:00','1971-07-19 00:00:00',NULL,NULL,57.25,0,NULL,NULL,40,NULL,NULL,NULL,1,1,NULL,2,5000,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-10 15:00:28',NULL,NULL,10000000000376,1,NULL,1,NULL,2222,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(10000000000975,'com.landsystems.lrs.model.Transaction','P-PLS000000594',5,25,31,'CofO14342','CofO14342',NULL,NULL,1,0,NULL,NULL,NULL,'2014-12-10 08:02:39',NULL,'1966-05-22 18:00:00','2006-05-21 18:00:00','1966-03-18 18:00:00','1966-03-18 18:00:00','1965-06-30 18:00:00',NULL,NULL,2.16,0,NULL,NULL,40,NULL,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,NULL,1,557,1,1,0,0,0,'The R of O following the present one not found in file.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,1,'2014-12-10 08:02:39',NULL,NULL,10000000000371,1,NULL,1,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(10000000000976,'com.landsystems.lrs.model.Transaction','P-PLS000000595',5,24,31,'BP3373','BP3373',NULL,NULL,1,0,NULL,NULL,NULL,'2014-12-10 15:03:23',NULL,'1977-10-07 00:00:00','2076-10-06 00:00:00','1977-09-02 00:00:00','1977-09-02 00:00:00','1975-05-31 00:00:00',NULL,NULL,NULL,0,NULL,NULL,99,NULL,NULL,NULL,1,1,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,1,0,0,0,'Note: The term(years) is indefinite.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,1,'2014-12-10 15:03:23',NULL,NULL,10000000000377,1,NULL,1,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(10000000000977,'com.landsystems.lrs.model.Transaction','PLS000000977',1,29,30,'BP2840','BP2840',NULL,NULL,1,0,NULL,0,NULL,'2014-12-10 15:03:46','2015-01-19 11:07:50',NULL,NULL,NULL,NULL,NULL,NULL,NULL,91.76,0,NULL,NULL,NULL,NULL,NULL,NULL,1,1,NULL,2,20000,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-10 15:03:46',NULL,NULL,10000000000381,0,NULL,1,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(10000000000978,'com.landsystems.lrs.model.Transaction','PLS000000978',1,24,30,'RofO14957','RofO14957',NULL,NULL,1,0,NULL,0,NULL,'2014-12-10 15:04:28',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,2.7,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-10 15:04:28',NULL,NULL,10000000000382,0,NULL,1,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(10000000000979,'com.landsystems.lrs.model.Transaction','PLS000000979',1,24,30,'CofO11926','CofO11926',NULL,NULL,1,0,NULL,0,NULL,'2014-12-10 01:05:11',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,17.81,0,NULL,NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,2000,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-10 01:05:11',NULL,NULL,10000000000383,0,NULL,1,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(10000000000980,'com.landsystems.lrs.model.Transaction','P-PLS000000596',5,24,31,'BP2834','BP2834',NULL,NULL,1,0,NULL,NULL,NULL,'2014-12-10 15:05:39',NULL,'1992-11-12 00:00:00','2091-11-11 00:00:00','1992-11-09 00:00:00','1992-11-09 00:00:00','1975-02-01 00:00:00',NULL,NULL,67.34,0,NULL,NULL,99,NULL,NULL,NULL,1,1,NULL,2,39000,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-10 15:05:39',NULL,NULL,10000000000378,1,NULL,1,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(10000000000981,'com.landsystems.lrs.model.Transaction','PLS000000981',1,24,30,'BP1862','BP1862',NULL,NULL,1,0,NULL,0,NULL,'2014-12-10 15:06:11',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,18.47,0,NULL,NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,2500,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-10 15:06:11',NULL,NULL,10000000000384,0,NULL,1,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(10000000000982,'com.landsystems.lrs.model.Transaction','P-PLS000000597',5,24,31,'BP2374','BP2374',NULL,NULL,1,0,NULL,NULL,NULL,'2014-12-10 15:06:33',NULL,'1982-12-03 00:00:00','2002-12-02 00:00:00','1975-08-23 00:00:00','1975-08-23 00:00:00','1974-06-07 00:00:00',NULL,NULL,3.54,0,NULL,NULL,20,NULL,NULL,NULL,1,1,NULL,2,200000,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-10 15:06:33',NULL,NULL,10000000000379,1,NULL,1,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(10000000000983,'com.landsystems.lrs.model.Transaction','PLS000000983',1,25,30,'BP623','BP623',NULL,NULL,1,0,NULL,0,NULL,'2014-12-10 15:08:21','2016-07-29 10:39:42',NULL,NULL,NULL,NULL,NULL,NULL,NULL,195.1,0,NULL,NULL,NULL,NULL,NULL,NULL,1,1,NULL,2,31000,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-10 15:08:21',NULL,NULL,10000000000385,0,NULL,1,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(10000000000985,'com.landsystems.lrs.model.Transaction','PLS000000985',1,24,30,'BP4308','BP4308',NULL,NULL,1,0,NULL,0,NULL,'2014-12-10 15:10:04',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,47.06,0,NULL,NULL,NULL,NULL,NULL,NULL,1,1,NULL,2,20000,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-10 15:10:04',NULL,NULL,10000000000386,0,NULL,1,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(10000000000987,'com.landsystems.lrs.model.Transaction','P-PLS000000600',5,24,31,'BP2594','BP2594',NULL,NULL,1,0,NULL,NULL,NULL,'2014-12-10 15:13:01',NULL,'1976-02-16 00:00:00','2016-02-15 00:00:00','1976-01-24 00:00:00','1976-01-24 00:00:00','1974-08-13 00:00:00',NULL,NULL,10,0,NULL,NULL,40,NULL,NULL,NULL,1,1,NULL,2,7000,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-10 15:13:01',NULL,NULL,10000000000380,1,NULL,1,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(10000000000988,'com.landsystems.lrs.model.Transaction','P-PLS000000601',3,25,31,'CofO14342','CofO14342',NULL,NULL,1,0,NULL,NULL,NULL,'2014-12-10 08:13:28',NULL,'1981-02-08 17:00:00','2021-02-07 17:00:00','1988-10-01 18:00:00','1988-10-06 18:00:00',NULL,NULL,NULL,2.16,0,NULL,NULL,40,NULL,NULL,NULL,1,1,NULL,NULL,NULL,5,NULL,'7(CofO)','145',NULL,NULL,'145',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-10 08:13:28',NULL,NULL,10000000000371,2,NULL,1,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(10000000000989,'com.landsystems.lrs.model.Transaction','PLS000000989',1,24,30,'BP4480','BP4480',NULL,NULL,1,0,NULL,0,NULL,'2014-12-10 15:14:43',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,22.2,0,NULL,NULL,NULL,NULL,NULL,NULL,1,1,NULL,2,10000,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-10 15:14:43',NULL,NULL,10000000000387,0,NULL,1,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(10000000000990,'com.landsystems.lrs.model.Transaction','PLS000000990',1,24,30,'BP2254','BP2254',NULL,NULL,1,0,NULL,0,NULL,'2014-12-10 15:16:15',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,93.24,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-10 15:16:15',NULL,NULL,10000000000388,0,NULL,1,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(10000000000991,'com.landsystems.lrs.model.Transaction','P-PLS000000602',5,24,31,'BP4308','BP4308',NULL,NULL,1,0,NULL,NULL,NULL,'2014-12-10 15:16:30',NULL,'1979-02-14 00:00:00','2078-02-13 00:00:00','1979-02-14 00:00:00','1979-02-14 00:00:00','1976-01-12 00:00:00',NULL,NULL,47.06,0,NULL,NULL,99,NULL,NULL,NULL,1,1,NULL,2,20000,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,'Issue date of RofO WAS used as commencement date, because the date was not found on the Acceptance letter. Issue date was also used as the execution date ',NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,1,'2014-12-10 15:16:30',NULL,NULL,10000000000386,1,NULL,1,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(10000000000992,'com.landsystems.lrs.model.Transaction','P-PLS000000603',5,24,31,'RofO14957','RofO14957',NULL,NULL,1,0,NULL,NULL,NULL,'2014-12-10 15:17:22',NULL,'1967-07-21 00:00:00','1987-07-20 00:00:00','1967-07-05 00:00:00','1967-07-05 00:00:00','1966-09-08 00:00:00',NULL,NULL,2.7,0,NULL,NULL,20,NULL,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,NULL,1,557,1,1,0,0,0,'Term gotten from C of O.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,1,'2014-12-10 15:17:22',NULL,NULL,10000000000382,1,NULL,1,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(10000000000993,'com.landsystems.lrs.model.Transaction','PLS000000993',1,24,30,'BP4129/T','BP4129/T',NULL,NULL,1,0,NULL,0,NULL,'2014-12-10 15:20:01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,139.78,0,NULL,NULL,NULL,NULL,NULL,NULL,1,1,NULL,2,50000,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-10 15:20:01',NULL,NULL,10000000000389,0,NULL,1,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(10000000000994,'com.landsystems.lrs.model.Transaction','P-PLS000000604',5,25,31,'BP623','BP623',NULL,NULL,1,0,NULL,NULL,NULL,'2014-12-10 15:20:36',NULL,'1971-03-03 00:00:00','2031-03-02 00:00:00','1971-02-16 00:00:00','1971-02-16 00:00:00','1970-06-22 00:00:00',NULL,NULL,195.1,0,NULL,NULL,60,NULL,NULL,NULL,1,1,NULL,2,31000,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-10 15:20:36',NULL,NULL,10000000000385,1,NULL,1,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(10000000000995,'com.landsystems.lrs.model.Transaction','PLS000000995',1,24,30,'CofO13671','CofO13671',NULL,NULL,1,0,NULL,0,NULL,'2014-12-10 15:21:06',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.9,0,NULL,NULL,NULL,NULL,NULL,NULL,1,1,NULL,6,100,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-10 15:21:06',NULL,NULL,10000000000390,0,NULL,1,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(10000000000996,'com.landsystems.lrs.model.Transaction','P-PLS000000605',5,24,31,'BP2254','BP2254',NULL,NULL,1,0,NULL,NULL,NULL,'2014-12-10 15:22:46',NULL,'1985-04-19 00:00:00','2084-04-18 00:00:00','1985-02-18 00:00:00','1985-02-18 00:00:00','1974-04-01 00:00:00',NULL,NULL,93.24,0,NULL,NULL,99,NULL,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,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-10 15:22:46',NULL,NULL,10000000000388,1,NULL,1,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(10000000000997,'com.landsystems.lrs.model.Transaction','P-PLS000000606',5,24,31,'BP4480','BP4480',NULL,NULL,1,0,NULL,NULL,NULL,'2014-12-10 15:23:20',NULL,'1986-11-10 00:00:00','2085-11-09 00:00:00','1986-10-22 00:00:00','1986-10-22 00:00:00','1976-02-18 00:00:00',NULL,NULL,22.2,0,NULL,NULL,99,NULL,NULL,NULL,1,1,NULL,2,10000,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-10 15:23:20',NULL,NULL,10000000000387,1,NULL,1,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(10000000000998,'com.landsystems.lrs.model.Transaction','P-PLS000000607',3,24,31,'BP4308','BP4308',NULL,NULL,1,0,NULL,NULL,NULL,'2014-12-10 15:23:23',NULL,'1979-02-14 00:00:00','2078-02-13 00:00:00','1979-07-23 00:00:00','1979-07-25 00:00:00',NULL,NULL,NULL,47.06,0,NULL,NULL,99,NULL,NULL,NULL,1,1,NULL,2,20000,5,NULL,'1(CofO)','470',NULL,NULL,'470',NULL,NULL,NULL,'P-PLS000000602',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-10 15:23:23',NULL,NULL,10000000000386,2,NULL,1,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(10000000000999,'com.landsystems.lrs.model.Transaction','P-PLS000000608',5,24,31,'CofO11926','CofO11926',NULL,NULL,1,0,NULL,NULL,NULL,'2014-12-10 01:23:36',NULL,'1963-06-04 12:00:00','2003-06-03 12:00:00','1963-04-29 12:00:00','1963-04-29 12:00:00','1962-09-23 12:00:00',NULL,NULL,17.81,0,NULL,NULL,40,NULL,NULL,NULL,1,1,NULL,NULL,2000,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-10 01:23:36',NULL,NULL,10000000000383,1,NULL,1,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(10000000001000,'com.landsystems.lrs.model.Transaction','PLS000001000',1,24,30,'BP3413','BP3413',NULL,NULL,1,0,NULL,0,NULL,'2014-12-10 15:25:32',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,41.13,0,NULL,NULL,NULL,NULL,NULL,NULL,1,1,NULL,2,6000,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-10 15:25:32',NULL,NULL,10000000000391,0,NULL,1,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(10000000001001,'com.landsystems.lrs.model.Transaction','P-PLS000000609',3,24,31,'RofO14957','RofO14957',NULL,NULL,1,0,NULL,NULL,NULL,'2014-12-10 15:26:29',NULL,'1968-10-30 00:00:00','1988-10-29 00:00:00','1979-07-23 00:00:00','1979-07-25 00:00:00',NULL,NULL,NULL,2.7,0,NULL,NULL,20,NULL,NULL,NULL,1,1,NULL,NULL,NULL,5,NULL,'1(CofO)','479',NULL,NULL,'479',NULL,NULL,NULL,'P-PLS000000603',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-10 15:26:29',NULL,NULL,10000000000382,2,NULL,1,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(10000000001002,'com.landsystems.lrs.model.Transaction','PLS000001002',1,24,30,'BP3941','BP3941',NULL,NULL,1,0,NULL,0,NULL,'2014-12-10 15:27:17',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,66.2,0,NULL,NULL,NULL,NULL,NULL,NULL,1,1,NULL,5,10000,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-10 15:27:17',NULL,NULL,10000000000392,0,NULL,1,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(10000000001003,'com.landsystems.lrs.model.Transaction','PLS000001003',1,24,30,'BP2494','BP2494',NULL,NULL,1,0,NULL,0,NULL,'2014-12-10 15:27:54',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,12.21,0,NULL,NULL,NULL,NULL,NULL,NULL,1,1,NULL,2,40000,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-10 15:27:54',NULL,NULL,10000000000393,0,NULL,1,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(10000000001004,'com.landsystems.lrs.model.Transaction','P-PLS000000610',5,24,31,'BP1862','BP1862',NULL,NULL,1,0,NULL,NULL,NULL,'2014-12-10 15:28:43',NULL,'1984-12-21 00:00:00','2083-12-20 00:00:00','1984-12-11 00:00:00','1984-12-11 00:00:00','1973-06-29 00:00:00',NULL,NULL,18.47,0,NULL,NULL,99,NULL,NULL,NULL,1,1,NULL,NULL,2500,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-10 15:28:43',NULL,NULL,10000000000384,1,NULL,1,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(10000000001005,'com.landsystems.lrs.model.Transaction','P-PLS000000611',5,24,31,'BP3413','BP3413',NULL,NULL,1,0,NULL,NULL,NULL,'2014-12-10 15:30:03',NULL,'1977-10-13 00:00:00','2076-10-12 00:00:00','1977-09-23 00:00:00','1977-09-23 00:00:00','1975-06-09 00:00:00',NULL,NULL,41.13,0,NULL,NULL,99,NULL,NULL,NULL,1,1,NULL,2,6000,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-10 15:30:03',NULL,NULL,10000000000391,1,NULL,1,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(10000000001006,'com.landsystems.lrs.model.Transaction','P-PLS000000612',5,24,31,'CofO13671','CofO13671',NULL,NULL,1,0,NULL,NULL,NULL,'2014-12-10 15:30:21',NULL,'1965-06-03 00:00:00','1984-10-14 00:00:00','1965-04-15 00:00:00','1965-04-15 00:00:00','1964-10-22 00:00:00',NULL,NULL,0.9,0,NULL,NULL,19,4,NULL,NULL,1,1,NULL,6,100,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-10 15:30:21',NULL,NULL,10000000000390,1,12,1,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(10000000001007,'com.landsystems.lrs.model.Transaction','P-PLS000000613',3,24,31,'BP2254','BP2254',NULL,NULL,1,0,NULL,NULL,NULL,'2014-12-10 15:30:44',NULL,'1985-04-19 00:00:00','2084-04-18 00:00:00','1986-10-27 00:00:00','1986-11-03 00:00:00',NULL,NULL,NULL,93.24,0,NULL,NULL,99,NULL,NULL,NULL,1,1,NULL,NULL,NULL,5,NULL,'5(CofO)','305',NULL,NULL,'305',NULL,NULL,NULL,'P-PLS000000605',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-10 15:30:44',NULL,NULL,10000000000388,2,NULL,1,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(10000000001008,'com.landsystems.lrs.model.Transaction','P-PLS000000614',3,25,31,'BP623','BP623',NULL,NULL,1,0,NULL,NULL,NULL,'2014-12-10 15:30:48',NULL,'1971-03-03 00:00:00','2031-03-02 00:00:00','1972-10-17 00:00:00','1972-10-18 00:00:00',NULL,NULL,NULL,195.1,0,NULL,NULL,60,NULL,NULL,NULL,1,1,NULL,2,31000,5,NULL,'1(C of O)','156',NULL,NULL,'156',NULL,NULL,NULL,'P-PLS000000604',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-10 15:30:48',NULL,NULL,10000000000385,2,NULL,1,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(10000000001010,'com.landsystems.lrs.model.Transaction','P-PLS000000616',5,24,31,'BP4129/T','BP4129/T',NULL,NULL,1,0,NULL,NULL,NULL,'2014-12-10 15:32:00',NULL,'1978-03-02 00:00:00','2077-03-01 00:00:00','1978-02-13 00:00:00','1978-02-13 00:00:00','1975-11-27 00:00:00',NULL,NULL,139.78,0,NULL,NULL,99,NULL,NULL,NULL,1,1,NULL,2,50000,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,'Execution Date not found, so Issue Date of RofO was used for Execution and Registration Dates.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,1,'2014-12-10 15:32:00',NULL,NULL,10000000000389,1,NULL,1,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(10000000001011,'com.landsystems.lrs.model.Transaction','P-PLS000000617',5,24,31,'BP3941','BP3941',NULL,NULL,1,0,NULL,NULL,NULL,'2014-12-10 15:32:26',NULL,'1976-11-02 00:00:00','2075-11-01 00:00:00','1976-09-13 00:00:00','1976-09-13 00:00:00','1975-09-24 00:00:00',NULL,NULL,66.2,0,NULL,NULL,99,NULL,NULL,NULL,1,1,NULL,5,10000,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,'Registration date is assumed',NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,1,'2014-12-10 15:32:26',NULL,NULL,10000000000392,1,NULL,1,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(10000000001012,'com.landsystems.lrs.model.Transaction','P-PLS000000618',5,24,31,'BP2494','BP2494',NULL,NULL,1,0,NULL,NULL,NULL,'2014-12-10 15:33:34',NULL,'1975-05-28 00:00:00','2074-05-27 00:00:00','1975-05-01 00:00:00','1975-05-01 00:00:00','1974-08-02 00:00:00',NULL,NULL,12.21,0,NULL,NULL,99,NULL,NULL,NULL,1,1,NULL,2,40000,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-10 15:33:34',NULL,NULL,10000000000393,1,NULL,1,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(10000000001013,'com.landsystems.lrs.model.Transaction','P-PLS000000619',3,24,31,'BP1862','BP1862',NULL,NULL,1,0,NULL,NULL,NULL,'2014-12-10 15:33:51',NULL,'1984-12-21 00:00:00','2083-12-20 00:00:00','1986-09-18 00:00:00','1986-09-23 00:00:00',NULL,NULL,NULL,18.47,0,NULL,NULL,99,NULL,NULL,NULL,1,1,NULL,NULL,2500,5,NULL,'5(CofO)','263',NULL,NULL,'263',NULL,NULL,NULL,'P-PLS000000610',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-10 15:33:51',NULL,NULL,10000000000384,2,NULL,1,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(10000000001014,'com.landsystems.lrs.model.Transaction','P-PLS000000620',3,24,31,'BP3413','BP3413',NULL,NULL,1,0,NULL,NULL,NULL,'2014-12-10 15:33:53',NULL,'1977-10-13 00:00:00','2076-10-12 00:00:00','1979-02-23 00:00:00','1979-03-08 00:00:00','1975-06-09 00:00:00',NULL,NULL,41.13,0,NULL,NULL,99,NULL,NULL,NULL,1,1,NULL,2,6000,5,NULL,'1(CofO)','381',NULL,NULL,'381',NULL,NULL,NULL,'P-PLS000000611',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-10 15:33:53',NULL,NULL,10000000000391,2,NULL,1,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(10000000001015,'com.landsystems.lrs.model.Transaction','PLS000001015',1,24,30,'BP3518','BP3518',NULL,NULL,1,0,NULL,0,NULL,'2014-12-10 15:33:54',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,207.57,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-10 15:33:54',NULL,NULL,10000000000394,0,NULL,1,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(10000000001016,'com.landsystems.lrs.model.Transaction','PLS000001016',1,24,30,'ACofO14939','ACofO14939',NULL,NULL,1,0,NULL,0,NULL,'2014-12-10 15:34:46',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,12500,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-10 15:34:46',NULL,NULL,10000000000395,0,NULL,1,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(10000000001017,'com.landsystems.lrs.model.Transaction','P-PLS000000621',3,24,31,'CofO13671','CofO13671',NULL,NULL,1,0,NULL,NULL,NULL,'2014-12-10 15:35:14',NULL,'1965-06-03 00:00:00','1985-10-14 00:00:00','1966-09-19 00:00:00','1966-09-21 00:00:00',NULL,NULL,NULL,0.9,0,NULL,NULL,20,4,NULL,NULL,1,1,NULL,6,100,5,NULL,'77(CofO)','109',NULL,NULL,'109',NULL,NULL,NULL,'P-PLS000000612',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-10 15:35:14',NULL,NULL,10000000000390,2,12,1,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(10000000001019,'com.landsystems.lrs.model.Transaction','P-PLS000000623',3,24,31,'BP4129/T','BP4129/T',NULL,NULL,1,0,NULL,NULL,NULL,'2014-12-10 15:36:02',NULL,'1978-03-02 00:00:00','2077-03-01 00:00:00','1979-02-05 00:00:00','1979-02-06 00:00:00',NULL,NULL,NULL,139.78,0,NULL,NULL,99,NULL,NULL,NULL,1,1,NULL,2,50000,5,NULL,'1(CofO)','354',NULL,NULL,'354',NULL,NULL,NULL,'P-PLS000000616',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-10 15:36:02',NULL,NULL,10000000000389,2,NULL,1,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(10000000001020,'com.landsystems.lrs.model.Transaction','PLS000001020',1,25,30,'BP2058','BP2058',NULL,NULL,1,0,NULL,0,NULL,'2014-12-10 15:37:51','2017-05-16 13:16:28',NULL,NULL,NULL,NULL,NULL,NULL,NULL,228.7,0,NULL,NULL,NULL,NULL,NULL,NULL,1,1,NULL,2,20000,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-10 15:37:51',NULL,NULL,10000000000396,0,NULL,1,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(10000000001021,'com.landsystems.lrs.model.Transaction','PLS000001021',1,24,30,'BP2451','BP2451',NULL,NULL,1,0,NULL,0,NULL,'2014-12-10 15:39:16',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,4.52,0,NULL,NULL,NULL,NULL,NULL,NULL,1,1,NULL,2,10000,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-10 15:39:16',NULL,NULL,10000000000397,0,NULL,1,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(10000000001022,'com.landsystems.lrs.model.Transaction','PLS000001022',1,24,30,'BP2506','BP2506',NULL,NULL,1,0,NULL,0,NULL,'2014-12-10 15:39:57',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,375,0,NULL,NULL,NULL,NULL,NULL,NULL,1,1,NULL,2,25000,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-10 15:39:57',NULL,NULL,10000000000398,0,NULL,1,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(10000000001023,'com.landsystems.lrs.model.Transaction','PLS000001023',1,26,30,'BP4384','BP4384',NULL,NULL,1,0,NULL,0,NULL,'2014-12-10 15:39:58',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,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-10 15:39:58',NULL,NULL,10000000000399,0,NULL,1,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(10000000001024,'com.landsystems.lrs.model.Transaction','PLS000001024',1,24,30,'CofO13615','CofO13615',NULL,NULL,1,0,NULL,0,NULL,'2014-12-10 15:40:35',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.162,0,NULL,NULL,NULL,NULL,NULL,NULL,1,1,NULL,2,5000,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-10 15:40:35',NULL,NULL,10000000000400,0,NULL,1,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(10000000001025,'com.landsystems.lrs.model.Transaction','PLS000001025',1,24,30,'BP4461','BP4461',NULL,NULL,1,0,NULL,0,NULL,'2014-12-10 15:40:48',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,86.2,0,NULL,NULL,NULL,NULL,NULL,NULL,1,1,NULL,2,20000,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-10 15:40:48',NULL,NULL,10000000000401,0,NULL,1,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(10000000001026,'com.landsystems.lrs.model.Transaction','PLS000001026',1,25,30,'BP2144','BP2144',NULL,NULL,1,0,NULL,0,NULL,'2014-12-10 15:41:36','2018-10-26 11:49:49',NULL,NULL,NULL,NULL,NULL,NULL,NULL,261.82,0,NULL,NULL,NULL,NULL,NULL,NULL,1,1,NULL,2,150000,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-10 15:41:36',NULL,NULL,10000000000402,0,NULL,1,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(10000000001027,'com.landsystems.lrs.model.Transaction','PLS000001027',1,24,30,'BP3965','BP3965',NULL,NULL,1,0,NULL,0,NULL,'2014-12-10 15:41:53',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,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-10 15:41:53',NULL,NULL,10000000000403,0,NULL,1,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(10000000001028,'com.landsystems.lrs.model.Transaction','P-PLS000000624',5,24,31,'BP3518','BP3518',NULL,NULL,1,0,NULL,NULL,NULL,'2014-12-10 15:41:57',NULL,'1982-03-22 00:00:00','2081-03-21 00:00:00','1981-12-02 00:00:00','1981-12-02 00:00:00','1975-06-22 00:00:00',NULL,NULL,207.57,0,NULL,NULL,99,NULL,NULL,NULL,1,1,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,1,0,0,0,'Note: No Term(Years) is indicated.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,1,'2014-12-10 15:41:57',NULL,NULL,10000000000394,1,NULL,1,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(10000000001029,'com.landsystems.lrs.model.Transaction','P-PLS000000625',5,25,31,'BP2058','BP2058',NULL,NULL,1,0,NULL,NULL,NULL,'2014-12-10 15:44:20',NULL,'1974-08-13 00:00:00','1994-08-12 00:00:00','1974-07-09 00:00:00','1974-07-09 00:00:00','1973-11-22 00:00:00',NULL,NULL,228.7,0,NULL,NULL,20,NULL,NULL,NULL,1,1,NULL,2,20000,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-10 15:44:20',NULL,NULL,10000000000396,1,NULL,1,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(10000000001030,'com.landsystems.lrs.model.Transaction','P-PLS000000626',5,24,31,'BP2451','BP2451',NULL,NULL,1,0,NULL,NULL,NULL,'2014-12-10 15:44:59',NULL,'1976-01-14 00:00:00','2075-01-13 00:00:00','1975-07-09 00:00:00','1975-07-09 00:00:00','1974-07-27 00:00:00',NULL,NULL,4.52,0,NULL,NULL,99,NULL,NULL,NULL,1,1,NULL,2,10000,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-10 15:44:59',NULL,NULL,10000000000397,1,NULL,1,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(10000000001031,'com.landsystems.lrs.model.Transaction','P-PLS000000627',5,24,31,'BP2506','BP2506',NULL,NULL,1,0,NULL,NULL,NULL,'2014-12-10 15:46:32',NULL,'1977-10-13 00:00:00','2076-10-12 00:00:00','1977-08-01 00:00:00','1977-08-01 00:00:00','1977-08-27 00:00:00',NULL,NULL,375,0,NULL,NULL,99,NULL,NULL,NULL,1,1,NULL,2,25000,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,'Execution and Registration dates not found. Issue date of R of O used in place',NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,1,'2014-12-10 15:46:32',NULL,NULL,10000000000398,1,NULL,1,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(10000000001032,'com.landsystems.lrs.model.Transaction','PLS000001032',1,24,30,'BP1956','BP1956',NULL,NULL,1,0,NULL,0,NULL,'2014-12-10 15:46:32',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,124,0,NULL,NULL,NULL,NULL,NULL,NULL,1,1,NULL,2,35000,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-10 15:46:32',NULL,NULL,10000000000404,0,NULL,1,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(10000000001033,'com.landsystems.lrs.model.Transaction','P-PLS000000628',5,24,31,'BP4461','BP4461',NULL,NULL,1,0,NULL,NULL,NULL,'2014-12-10 15:46:38',NULL,'1981-11-30 00:00:00','2080-11-29 00:00:00','1981-11-05 00:00:00','1981-11-05 00:00:00','1976-03-12 00:00:00',NULL,NULL,86.2,0,NULL,NULL,99,NULL,NULL,NULL,1,1,NULL,2,20000,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,1,0,0,0,'Acceptance letter was not found in file, so issue date was used',NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,1,'2014-12-10 15:46:38',NULL,NULL,10000000000401,1,NULL,1,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(10000000001034,'com.landsystems.lrs.model.Transaction','P-PLS000000629',5,24,31,'ACofO14939','ACofO14939',NULL,NULL,1,0,NULL,NULL,NULL,'2014-12-10 15:47:07',NULL,'1967-01-24 00:00:00','2066-01-23 00:00:00','1967-01-17 00:00:00','1967-01-17 00:00:00','1965-02-01 00:00:00',NULL,NULL,NULL,0,NULL,NULL,99,NULL,NULL,NULL,1,1,NULL,NULL,12500,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 that the term is indefinate',NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,1,'2014-12-10 15:47:07',NULL,NULL,10000000000395,1,NULL,1,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(10000000001035,'com.landsystems.lrs.model.Transaction','P-PLS000000630',5,24,31,'CofO13615','CofO13615',NULL,NULL,1,0,NULL,NULL,NULL,'2014-12-10 15:49:30',NULL,'1965-04-28 00:00:00','1977-04-01 00:00:00','1965-04-18 00:00:00','1965-04-18 00:00:00','1964-09-12 00:00:00',NULL,NULL,0.162,0,NULL,NULL,11,11,NULL,NULL,1,1,NULL,2,5000,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,'Page 23 in file indicates that the R of O has been withdrawn.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,1,'2014-12-10 15:49:30',NULL,NULL,10000000000400,1,5,1,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(10000000001036,'com.landsystems.lrs.model.Transaction','P-PLS000000631',5,24,31,'BP3965','BP3965',NULL,NULL,1,0,NULL,NULL,NULL,'2014-12-10 15:49:59',NULL,'1976-07-19 00:00:00','2075-07-18 00:00:00','1976-05-11 00:00:00','1976-05-11 00:00:00','1975-08-25 00:00:00',NULL,NULL,NULL,0,NULL,NULL,99,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,1,0,0,0,'Note:Note, Property has indefinite term with no revision period.',NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,1,'2014-12-10 15:49:59',NULL,NULL,10000000000403,1,NULL,1,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(10000000001038,'com.landsystems.lrs.model.Transaction','P-PLS000000633',5,25,31,'BP2144','BP2144',NULL,NULL,1,0,NULL,NULL,NULL,'2014-12-10 15:50:49',NULL,'1976-10-19 00:00:00','2075-10-18 00:00:00','1976-09-13 00:00:00','1976-09-13 00:00:00','1974-02-02 00:00:00',NULL,NULL,261.82,0,NULL,NULL,99,NULL,NULL,NULL,1,1,NULL,2,150000,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-10 15:50:49',NULL,NULL,10000000000402,1,NULL,1,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(10000000001039,'com.landsystems.lrs.model.Transaction','P-PLS000000634',3,24,31,'BP2451','BP2451',NULL,NULL,1,0,NULL,NULL,NULL,'2014-12-10 15:51:24',NULL,'1976-01-14 00:00:00','2075-01-13 00:00:00','1981-09-18 00:00:00','1981-10-07 00:00:00',NULL,NULL,NULL,4.52,0,NULL,NULL,99,NULL,NULL,NULL,1,1,NULL,2,10000,5,NULL,'3(CofO)','179',NULL,NULL,'179',NULL,NULL,NULL,'P-PLS000000626',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-10 15:51:24',NULL,NULL,10000000000397,2,NULL,1,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(10000000001041,'com.landsystems.lrs.model.Transaction','P-PLS000000636',3,24,31,'ACofO14939','ACofO14939',NULL,NULL,1,0,NULL,NULL,NULL,'2014-12-10 15:52:40',NULL,'1967-01-24 00:00:00',NULL,'1970-05-05 00:00:00','1970-05-06 00:00:00',NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,12500,5,NULL,'1(CofO)','52',NULL,NULL,'52',NULL,NULL,NULL,'P-PLS000000629',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-10 15:52:40',NULL,NULL,10000000000395,2,NULL,1,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(10000000001043,'com.landsystems.lrs.model.Transaction','PLS000001043',1,24,30,'BP4450','BP4450',NULL,NULL,1,0,NULL,0,NULL,'2014-12-10 15:53:43',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,48.19,0,NULL,NULL,NULL,NULL,NULL,NULL,1,1,NULL,2,20000,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-10 15:53:43',NULL,NULL,10000000000405,0,NULL,1,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(10000000001044,'com.landsystems.lrs.model.Transaction','P-PLS000000638',5,24,31,'BP1956','BP1956',NULL,NULL,1,0,NULL,NULL,NULL,'2014-12-10 15:54:47',NULL,'1974-10-07 00:00:00','2073-10-06 00:00:00','1974-05-16 00:00:00','1974-05-16 00:00:00','1973-05-23 00:00:00',NULL,NULL,124,0,NULL,NULL,99,NULL,NULL,NULL,1,1,NULL,2,35000,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-10 15:54:47',NULL,NULL,10000000000404,1,NULL,1,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(10000000001046,'com.landsystems.lrs.model.Transaction','P-PLS000000640',3,25,31,'BP2144','BP2144',NULL,NULL,1,0,NULL,NULL,NULL,'2014-12-10 15:56:50',NULL,'1976-10-19 00:00:00','2016-10-18 00:00:00','1981-05-15 00:00:00','1981-05-21 00:00:00',NULL,NULL,NULL,261.82,0,NULL,NULL,40,NULL,NULL,NULL,1,1,NULL,2,150000,5,NULL,'3(CofO)','14',NULL,NULL,'14',NULL,NULL,NULL,'P-PLS000000633',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-10 15:56:50',NULL,NULL,10000000000402,2,NULL,1,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(10000000001047,'com.landsystems.lrs.model.Transaction','PLS000001047',1,24,30,'BP3501','BP3501',NULL,NULL,1,0,NULL,0,NULL,'2014-12-10 15:57:50',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,59.72,0,NULL,NULL,NULL,NULL,NULL,NULL,1,1,NULL,2,20000,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-10 15:57:50',NULL,NULL,10000000000406,0,NULL,1,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(10000000001048,'com.landsystems.lrs.model.Transaction','PLS000001048',1,25,30,'BP3573','BP3573',NULL,NULL,1,0,NULL,0,NULL,'2014-12-10 15:58:52','2017-03-16 11:16:18',NULL,NULL,NULL,NULL,NULL,NULL,NULL,150,0,NULL,NULL,NULL,NULL,NULL,NULL,1,1,NULL,2,30000,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-10 15:58:52',NULL,NULL,10000000000407,0,NULL,1,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(10000000001050,'com.landsystems.lrs.model.Transaction','P-PLS000000642',5,24,31,'BP4450','BP4450',NULL,NULL,1,0,NULL,NULL,NULL,'2014-12-10 15:59:16',NULL,'1980-07-20 00:00:00','2079-07-19 00:00:00','1981-06-12 00:00:00','1981-06-12 00:00:00','1976-03-05 00:00:00',NULL,NULL,47,0,NULL,NULL,99,NULL,NULL,NULL,1,1,NULL,2,20000,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,'Registration date not applicable',NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,NULL,NULL,1,'2014-12-10 15:59:16',NULL,NULL,10000000000405,1,NULL,1,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(10000000001051,'com.landsystems.lrs.model.Transaction','PLS000001051',1,24,30,'BP614','BP614',NULL,NULL,1,0,NULL,0,NULL,'2014-12-10 15:59:24',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,34.425,0,NULL,NULL,NULL,NULL,NULL,NULL,1,1,NULL,2,3000,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-10 15:59:24',NULL,NULL,10000000000408,0,NULL,1,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(10000000001052,'com.landsystems.lrs.model.Transaction','PLS000001052',1,24,30,'BP2680','BP2680',NULL,NULL,1,0,NULL,0,NULL,'2014-12-10 15:59:46',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,15.2,0,NULL,NULL,NULL,NULL,NULL,NULL,1,1,NULL,3,20000,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-10 15:59:46',NULL,NULL,10000000000409,0,NULL,1,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(10000000001053,'com.landsystems.lrs.model.Transaction','PLS000001053',1,24,30,'BP2477','BP2477',NULL,NULL,1,0,NULL,0,NULL,'2014-12-10 16:01:11',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,66,0,NULL,NULL,NULL,NULL,NULL,NULL,1,1,NULL,2,30000,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-10 16:01:11',NULL,NULL,10000000000410,0,NULL,1,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(10000000001054,'com.landsystems.lrs.model.Transaction','PLS000001054',1,24,30,'CofO14057','CofO14057',NULL,NULL,1,0,NULL,0,NULL,'2014-12-10 16:01:38',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,309.2,0,NULL,NULL,NULL,NULL,NULL,NULL,1,1,NULL,2,22000,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-10 16:01:38',NULL,NULL,10000000000411,0,NULL,1,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(10000000001056,'com.landsystems.lrs.model.Transaction','PLS000001056',1,24,30,'BP982','BP982',NULL,NULL,1,0,NULL,0,NULL,'2014-12-10 16:02:37',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,51.89,0,NULL,NULL,NULL,NULL,NULL,NULL,1,1,NULL,2,10000,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-10 16:02:37',NULL,NULL,10000000000412,0,NULL,1,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(10000000001057,'com.landsystems.lrs.model.Transaction','P-PLS000000644',5,24,31,'BP3501','BP3501',NULL,NULL,1,0,NULL,NULL,NULL,'2014-12-10 16:03:16',NULL,'1979-02-13 00:00:00','2019-02-12 00:00:00','1979-02-02 00:00:00','1979-02-02 00:00:00','1975-06-23 00:00:00',NULL,NULL,59.72,0,NULL,NULL,40,NULL,NULL,NULL,1,1,NULL,2,20000,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-10 16:03:16',NULL,NULL,10000000000406,1,NULL,1,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(10000000001058,'com.landsystems.lrs.model.Transaction','PLS000001058',1,24,30,'RofO11350','RofO11350',NULL,NULL,1,0,NULL,0,NULL,'2014-12-10 16:03:47',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,0,NULL,NULL,NULL,NULL,NULL,NULL,1,1,NULL,2,400,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-10 16:03:47',NULL,NULL,10000000000413,0,NULL,1,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(10000000001059,'com.landsystems.lrs.model.Transaction','PLS000001059',1,24,30,'CofO14192','CofO14192',NULL,NULL,1,0,NULL,0,NULL,'2014-12-10 16:04:10',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,14,0,NULL,NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,200,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-10 16:04:10',NULL,NULL,10000000000414,0,NULL,1,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(10000000001060,'com.landsystems.lrs.model.Transaction','P-PLS000000645',5,24,31,'BP2477','BP2477',NULL,NULL,1,0,NULL,NULL,NULL,'2014-12-10 16:06:24',NULL,'1980-11-10 00:00:00','2020-11-09 00:00:00','1980-08-05 00:00:00','1980-08-05 00:00:00','1974-08-08 00:00:00',NULL,NULL,66,0,NULL,NULL,40,NULL,NULL,NULL,1,1,NULL,2,30000,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-10 16:06:24',NULL,NULL,10000000000410,1,NULL,1,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(10000000001061,'com.landsystems.lrs.model.Transaction','P-PLS000000646',5,25,31,'BP3573','BP3573',NULL,NULL,1,0,NULL,NULL,NULL,'2014-12-10 16:07:12',NULL,'1984-10-18 00:00:00','2083-10-17 00:00:00','1984-10-17 00:00:00','1984-10-17 00:00:00','1975-05-26 00:00:00',NULL,NULL,150,0,NULL,NULL,99,NULL,NULL,NULL,1,1,NULL,2,30000,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-10 16:07:12',NULL,NULL,10000000000407,1,NULL,1,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(10000000001062,'com.landsystems.lrs.model.Transaction','P-PLS000000647',5,24,31,'BP614','BP614',NULL,NULL,1,0,NULL,NULL,NULL,'2014-12-10 16:08:03',NULL,'1971-07-20 00:00:00','2070-07-19 00:00:00','1971-05-20 00:00:00','1971-05-20 00:00:00','1970-06-10 00:00:00',NULL,NULL,34.425,0,NULL,NULL,99,NULL,NULL,NULL,1,1,NULL,2,3000,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-10 16:08:03',NULL,NULL,10000000000408,1,NULL,1,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(10000000001063,'com.landsystems.lrs.model.Transaction','P-PLS000000648',3,24,31,'BP3501','BP3501',NULL,NULL,1,0,NULL,NULL,NULL,'2014-12-10 16:08:13',NULL,'1979-02-13 00:00:00','2019-02-12 00:00:00','1979-09-19 00:00:00','1979-09-20 00:00:00',NULL,NULL,NULL,59.72,0,NULL,NULL,40,NULL,NULL,NULL,1,1,NULL,2,20000,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-10 16:08:13',NULL,NULL,10000000000406,2,NULL,1,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(10000000001064,'com.landsystems.lrs.model.Transaction','P-PLS000000649',5,24,31,'BP2680','BP2680',NULL,NULL,1,0,NULL,NULL,NULL,'2014-12-10 16:09:33',NULL,'1975-09-02 00:00:00','1995-09-01 00:00:00','1975-07-21 00:00:00','1975-07-21 00:00:00','1975-11-28 00:00:00',NULL,NULL,15.2,0,NULL,NULL,20,NULL,NULL,NULL,1,1,NULL,3,20000,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-10 16:09:33',NULL,NULL,10000000000409,1,NULL,1,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(10000000001066,'com.landsystems.lrs.model.Transaction','P-PLS000000651',5,24,31,'CofO14057','CofO14057',NULL,NULL,1,0,NULL,NULL,NULL,'2014-12-10 16:11:12',NULL,'1965-11-11 00:00:00','2001-10-31 00:00:00','1965-09-30 00:00:00','1965-09-30 00:00:00','1964-12-16 00:00:00',NULL,NULL,309.2,0,NULL,NULL,35,11,NULL,NULL,1,1,NULL,2,22000,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-10 16:11:12',NULL,NULL,10000000000411,1,21,1,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(10000000001068,'com.landsystems.lrs.model.Transaction','PLS000001068',1,24,30,'BP3557','BP3557',NULL,NULL,1,0,NULL,0,NULL,'2014-12-10 16:13:27',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,64.33,0,NULL,NULL,NULL,NULL,NULL,NULL,1,1,NULL,2,20000,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-10 16:13:27',NULL,NULL,10000000000415,0,NULL,1,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(10000000001069,'com.landsystems.lrs.model.Transaction','P-PLS000000653',5,24,31,'CofO14192','CofO14192',NULL,NULL,1,0,NULL,NULL,NULL,'2014-12-10 16:13:43',NULL,'1965-12-22 00:00:00','2006-04-11 00:00:00','1965-12-04 00:00:00','1965-12-04 00:00:00','1965-05-13 00:00:00',NULL,NULL,14,0,NULL,NULL,40,3,NULL,NULL,1,1,NULL,2,200,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-10 16:13:43',NULL,NULL,10000000000414,1,21,2222,NULL,2222,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(10000000001070,'com.landsystems.lrs.model.Transaction','PLS000001070',1,24,30,'CofO11338','CofO11338',NULL,NULL,1,0,NULL,0,NULL,'2014-12-10 16:13:47',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.16,0,NULL,NULL,NULL,NULL,NULL,NULL,1,1,NULL,2,150,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-10 16:13:47',NULL,NULL,10000000000416,0,NULL,1,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(10000000001071,'com.landsystems.lrs.model.Transaction','P-PLS000000654',3,24,31,'BP2680','BP2680',NULL,NULL,1,0,NULL,NULL,NULL,'2014-12-10 16:15:04',NULL,'1975-09-02 00:00:00','1995-09-01 00:00:00','1978-06-20 00:00:00','1978-06-30 00:00:00',NULL,NULL,NULL,15.2,0,NULL,NULL,20,NULL,NULL,NULL,1,1,NULL,3,20000,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-10 16:15:04',NULL,NULL,10000000000409,2,NULL,1,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(10000000001072,'com.landsystems.lrs.model.Transaction','PLS000001072',1,24,30,'BP1567','BP1567',NULL,NULL,1,0,NULL,0,NULL,'2014-12-10 16:16:03',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,93.45,0,NULL,NULL,NULL,NULL,NULL,NULL,1,1,NULL,2,20000,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-10 16:16:03',NULL,NULL,10000000000417,0,NULL,1,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(10000000001073,'com.landsystems.lrs.model.Transaction','P-PLS000000655',5,24,31,'BP982','BP982',NULL,NULL,1,0,NULL,NULL,NULL,'2014-12-10 16:16:08',NULL,'1982-07-15 00:00:00','2022-07-14 00:00:00','1980-11-07 00:00:00','1980-11-07 00:00:00','1971-07-12 00:00:00',NULL,NULL,51.89,0,NULL,NULL,40,NULL,NULL,NULL,1,1,NULL,2,10000,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-10 16:16:08',NULL,NULL,10000000000412,1,NULL,1,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(10000000001074,'com.landsystems.lrs.model.Transaction','PLS000001074',1,24,30,'BP353','BP353',NULL,NULL,1,0,NULL,0,NULL,'2014-12-10 16:17:53',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,99.96,0,NULL,NULL,NULL,NULL,NULL,NULL,1,1,NULL,2,8000,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-10 16:17:53',NULL,NULL,10000000000418,0,NULL,1,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(10000000001075,'com.landsystems.lrs.model.Transaction','P-PLS000000656',5,24,31,'BP3557','BP3557',NULL,NULL,1,0,NULL,NULL,NULL,'2014-12-10 16:18:14',NULL,'1982-02-24 00:00:00','2081-02-23 00:00:00','1982-02-24 00:00:00','1982-02-24 00:00:00','1976-07-07 00:00:00',NULL,NULL,64.33,0,NULL,NULL,99,NULL,NULL,NULL,1,1,NULL,2,20000,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-10 16:18:14',NULL,NULL,10000000000415,1,NULL,1,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(10000000001076,'com.landsystems.lrs.model.Transaction','P-PLS000000657',5,24,31,'RofO11350','RofO11350',NULL,NULL,1,0,NULL,NULL,NULL,'2014-12-10 16:18:57',NULL,'1962-06-15 00:00:00','1981-07-06 00:00:00','1962-05-30 00:00:00','1962-05-30 00:00:00','1962-01-29 00:00:00',NULL,NULL,2,0,NULL,NULL,19,NULL,NULL,NULL,1,1,NULL,2,400,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-10 16:18:57',NULL,NULL,10000000000413,1,22,1,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(10000000001077,'com.landsystems.lrs.model.Transaction','PLS000001077',1,26,30,'BP2331','BP2331',NULL,NULL,1,0,NULL,0,NULL,'2014-12-10 16:19:39',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,50,0,NULL,NULL,NULL,NULL,NULL,NULL,1,1,NULL,3,20000,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-10 16:19:39',NULL,NULL,10000000000419,0,NULL,1,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(10000000001078,'com.landsystems.lrs.model.Transaction','PLS000001078',1,24,30,'BP4121','BP4121',NULL,NULL,1,0,NULL,0,NULL,'2014-12-10 16:19:58',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,62.14,0,NULL,NULL,NULL,NULL,NULL,NULL,1,1,NULL,2,20000,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-10 16:19:58',NULL,NULL,10000000000420,0,NULL,1,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(10000000001080,'com.landsystems.lrs.model.Transaction','P-PLS000000659',5,24,31,'BP1567','BP1567',NULL,NULL,1,0,NULL,NULL,NULL,'2014-12-10 16:21:56',NULL,'1982-12-22 00:00:00','2022-12-21 00:00:00','1982-12-15 00:00:00','1982-12-15 00:00:00','1972-10-31 00:00:00',NULL,NULL,93.45,0,NULL,NULL,40,NULL,NULL,NULL,1,1,NULL,2,20000,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-10 16:21:56',NULL,NULL,10000000000417,1,NULL,1,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(10000000001081,'com.landsystems.lrs.model.Transaction','PLS000001081',1,24,30,'BP3940','BP3940',NULL,NULL,1,0,NULL,0,NULL,'2014-12-10 16:22:00',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,56.34,0,NULL,NULL,NULL,NULL,NULL,NULL,1,1,NULL,2,18000,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-10 16:22:00',NULL,NULL,10000000000421,0,NULL,1,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(10000000001082,'com.landsystems.lrs.model.Transaction','P-PLS000000660',3,24,31,'BP3557','BP3557',NULL,NULL,1,0,NULL,NULL,NULL,'2014-12-10 16:22:16',NULL,'1982-02-24 00:00:00','2081-02-23 00:00:00','1983-06-24 00:00:00','1983-08-03 00:00:00',NULL,NULL,NULL,64.33,0,NULL,NULL,99,NULL,NULL,NULL,1,1,NULL,2,20000,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-10 16:22:16',NULL,NULL,10000000000415,2,NULL,1,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(10000000001083,'com.landsystems.lrs.model.Transaction','P-PLS000000661',5,24,31,'CofO11338','CofO11338',NULL,NULL,1,0,NULL,NULL,NULL,'2014-12-10 16:22:37',NULL,'1962-05-12 00:00:00','1971-05-11 00:00:00','1962-04-12 00:00:00','1962-04-12 00:00:00','1961-08-14 00:00:00',NULL,NULL,0.16,0,NULL,NULL,9,NULL,NULL,NULL,1,1,NULL,2,150,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-10 16:22:37',NULL,NULL,10000000000416,1,NULL,1,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(10000000001085,'com.landsystems.lrs.model.Transaction','P-PLS000000663',5,24,31,'BP4121','BP4121',NULL,NULL,1,0,NULL,NULL,NULL,'2014-12-10 16:25:54',NULL,'1978-07-07 00:00:00','2077-07-06 00:00:00','1978-06-26 00:00:00','1978-06-26 00:00:00','1975-11-27 00:00:00',NULL,NULL,62.14,0,NULL,NULL,99,NULL,NULL,NULL,1,1,NULL,2,20000,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-10 16:25:54',NULL,NULL,10000000000420,1,NULL,1,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(10000000001086,'com.landsystems.lrs.model.Transaction','P-PLS000000664',3,24,31,'BP1567','BP1567',NULL,NULL,1,0,NULL,NULL,NULL,'2014-12-10 16:26:08',NULL,'1982-12-22 00:00:00','2022-12-21 00:00:00','1984-09-19 00:00:00','1984-09-27 00:00:00',NULL,NULL,NULL,93.45,0,NULL,NULL,40,NULL,NULL,NULL,1,1,NULL,2,20000,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-10 16:26:08',NULL,NULL,10000000000417,2,NULL,1,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(10000000001088,'com.landsystems.lrs.model.Transaction','P-PLS000000665',5,26,31,'BP2331','BP2331',NULL,NULL,1,0,NULL,NULL,NULL,'2014-12-10 16:28:06',NULL,'1975-05-30 00:00:00','1995-05-29 00:00:00','1975-04-24 00:00:00','1975-04-24 00:00:00','1974-04-22 00:00:00',NULL,NULL,50,0,NULL,NULL,20,NULL,NULL,NULL,1,1,NULL,3,20000,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-10 16:28:06',NULL,NULL,10000000000419,1,NULL,1,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(10000000001089,'com.landsystems.lrs.model.Transaction','PLS000001089',1,24,30,'BP1349','BP1349',NULL,NULL,1,0,NULL,0,NULL,'2014-12-10 16:28:32',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,59.25,0,NULL,NULL,NULL,NULL,NULL,NULL,1,1,NULL,2,2000,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-10 16:28:32',NULL,NULL,10000000000423,0,NULL,1,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(10000000001090,'com.landsystems.lrs.model.Transaction','PLS000001090',1,24,30,'RofO14137','RofO14137',NULL,NULL,1,0,NULL,0,NULL,'2014-12-10 16:29:23',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,8,0,NULL,NULL,NULL,NULL,NULL,NULL,1,1,NULL,2,100,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-10 16:29:23',NULL,NULL,10000000000424,0,NULL,1,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(10000000001093,'com.landsystems.lrs.model.Transaction','P-PLS000000668',5,24,31,'BP353','BP353',NULL,NULL,1,0,NULL,NULL,NULL,'2014-12-10 16:30:18',NULL,'1973-06-19 00:00:00','2072-06-18 00:00:00','1973-06-19 00:00:00','1973-06-19 00:00:00','1969-08-08 00:00:00',NULL,NULL,99.96,0,NULL,NULL,99,NULL,NULL,NULL,1,1,NULL,2,8000,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-10 16:30:18',NULL,NULL,10000000000418,1,NULL,1,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(10000000001095,'com.landsystems.lrs.model.Transaction','PLS000001095',1,26,30,'CofO8144','CofO8144',NULL,NULL,1,0,NULL,0,NULL,'2014-12-10 16:31:01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,4.19,0,NULL,NULL,NULL,NULL,NULL,NULL,1,1,NULL,2,1000,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-10 16:31:01',NULL,NULL,10000000000425,0,NULL,1,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(10000000001096,'com.landsystems.lrs.model.Transaction','P-PLS000000670',5,24,31,'BP3940','BP3940',NULL,NULL,1,0,NULL,NULL,NULL,'2014-12-10 16:31:40',NULL,'1982-05-19 00:00:00','2081-05-18 00:00:00','1982-05-10 00:00:00','1982-05-10 00:00:00','1975-09-24 00:00:00',NULL,NULL,56.34,0,NULL,NULL,99,NULL,NULL,NULL,1,1,NULL,2,18000,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-10 16:31:40',NULL,NULL,10000000000421,1,NULL,1,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(10000000001097,'com.landsystems.lrs.model.Transaction','P-PLS000000671',5,24,31,'RofO14137','RofO14137',NULL,NULL,1,0,NULL,NULL,NULL,'2014-12-10 16:34:38',NULL,'1966-01-07 00:00:00','1983-01-06 00:00:00','1965-11-03 00:00:00','1965-11-03 00:00:00','1965-02-17 00:00:00',NULL,NULL,8,0,NULL,NULL,17,NULL,NULL,NULL,1,1,NULL,2,100,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-10 16:34:38',NULL,NULL,10000000000424,1,NULL,1,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(10000000001098,'com.landsystems.lrs.model.Transaction','P-PLS000000672',5,24,31,'BP1349','BP1349',NULL,NULL,1,0,NULL,NULL,NULL,'2014-12-10 16:35:27',NULL,'1973-09-10 00:00:00','2013-09-09 00:00:00','1973-08-18 00:00:00','1973-08-18 00:00:00','1972-05-30 00:00:00',NULL,NULL,59.25,0,NULL,NULL,40,NULL,NULL,NULL,1,1,NULL,2,2000,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-10 16:35:27',NULL,NULL,10000000000423,1,NULL,1,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(10000000001099,'com.landsystems.lrs.model.Transaction','PLS000001099',1,24,30,'BP464','BP464',NULL,NULL,1,0,NULL,0,NULL,'2014-12-10 16:36:07',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-10 16:36:07',NULL,NULL,10000000000426,0,NULL,1,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(10000000001100,'com.landsystems.lrs.model.Transaction','P-PLS000000673',5,24,31,'BP464','BP464',NULL,NULL,1,0,NULL,NULL,NULL,'2014-12-10 16:45:19',NULL,'1971-05-04 00:00:00','1991-01-09 00:00:00','1971-03-02 00:00:00','1971-03-02 00:00:00','1969-12-01 00: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-10 16:45:19',NULL,NULL,10000000000426,1,6,1,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(10000000001101,'com.landsystems.lrs.model.Transaction','P-PLS000000674',3,24,31,'BP353','BP353',NULL,NULL,1,0,NULL,NULL,NULL,'2014-12-11 09:12:25',NULL,'1973-07-26 00:00:00','2072-07-25 00:00:00','1976-02-26 00:00:00','1976-03-02 00:00:00',NULL,NULL,NULL,99.96,0,NULL,NULL,99,NULL,NULL,NULL,1,1,NULL,2,8000,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-11 09:12:25',NULL,NULL,10000000000418,2,NULL,1,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(10000000001102,'com.landsystems.lrs.model.Transaction','PLS000001102',1,24,30,'BP2099','BP2099',NULL,NULL,1,0,NULL,0,NULL,'2014-12-11 09:12:56',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,48.19,0,NULL,NULL,NULL,NULL,NULL,NULL,1,1,NULL,2,100000,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-11 09:12:56',NULL,NULL,10000000000427,0,NULL,1,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(10000000001103,'com.landsystems.lrs.model.Transaction','P-PLS000000675',3,24,31,'BP1349','BP1349',NULL,NULL,1,0,NULL,NULL,NULL,'2014-12-11 09:13:45',NULL,'1973-09-10 00:00:00','2013-09-09 00:00:00','1976-07-01 00:00:00','1976-07-06 00:00:00',NULL,NULL,NULL,59.25,0,NULL,NULL,40,NULL,NULL,NULL,1,1,NULL,2,2000,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-11 09:13:45',NULL,NULL,10000000000423,2,NULL,1,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(10000000001104,'com.landsystems.lrs.model.Transaction','PLS000001104',1,24,30,'BP3632','BP3632',NULL,NULL,1,0,NULL,0,NULL,'2014-12-11 09:15:08',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,66.08,0,NULL,NULL,NULL,NULL,NULL,NULL,1,1,NULL,2,20000,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-11 09:15:08',NULL,NULL,10000000000428,0,NULL,1,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(10000000001106,'com.landsystems.lrs.model.Transaction','PLS000001106',1,26,30,'BP3728','BP3728',NULL,NULL,1,0,NULL,0,NULL,'2014-12-11 09:22:28',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,89.75,0,NULL,NULL,NULL,NULL,NULL,NULL,1,1,NULL,2,30000,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-11 09:22:28',NULL,NULL,10000000000430,0,NULL,1,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(10000000001109,'com.landsystems.lrs.model.Transaction','PLS000001109',1,24,30,'BP3912','BP3912',NULL,NULL,1,0,NULL,0,NULL,'2014-12-11 09:25:48',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,18.56,0,NULL,NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,160000,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-11 09:25:48',NULL,NULL,10000000000431,0,NULL,1,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(10000000001110,'com.landsystems.lrs.model.Transaction','PLS000001110',1,24,30,'CofO14982','CofO14982',NULL,NULL,1,0,NULL,0,NULL,'2014-12-11 09:27:24',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-11 09:27:24',NULL,NULL,10000000000432,0,NULL,1,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(10000000001111,'com.landsystems.lrs.model.Transaction','PLS000001111',1,26,30,'CofO14181','CofO14181',NULL,NULL,1,0,NULL,0,NULL,'2014-12-11 09:27:46',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,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-11 09:27:46',NULL,NULL,10000000000433,0,NULL,1,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(10000000001112,'com.landsystems.lrs.model.Transaction','PLS000001112',1,24,30,'BP3503','BP3503',NULL,NULL,1,0,NULL,0,NULL,'2014-12-11 09:27:58',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,141.9,0,NULL,NULL,NULL,NULL,NULL,NULL,1,1,NULL,2,50000,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-11 09:27:58',NULL,NULL,10000000000434,0,NULL,1,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(10000000001113,'com.landsystems.lrs.model.Transaction','P-PLS000000678',5,26,31,'BP3728','BP3728',NULL,NULL,1,0,NULL,NULL,NULL,'2014-12-11 09:31:22',NULL,'1977-11-09 00:00:00','2076-11-08 00:00:00','1977-11-09 00:00:00','1977-11-09 00:00:00','1975-08-04 00:00:00',NULL,NULL,89.75,0,NULL,NULL,99,NULL,NULL,NULL,1,1,NULL,2,30000,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-11 09:31:22',NULL,NULL,10000000000430,1,NULL,1,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(10000000001114,'com.landsystems.lrs.model.Transaction','PLS000001114',1,24,30,'BP1548','BP1548',NULL,NULL,1,0,NULL,0,NULL,'2014-12-11 09:31:41',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,365.56,0,NULL,NULL,NULL,NULL,NULL,NULL,1,1,NULL,2,40000,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-11 09:31:41',NULL,NULL,10000000000435,0,NULL,1,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(10000000001115,'com.landsystems.lrs.model.Transaction','PLS000001115',1,24,30,'ACofO14408','ACofO14408',NULL,NULL,1,0,NULL,0,NULL,'2014-12-11 09:32:39',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.21,0,NULL,NULL,NULL,NULL,NULL,NULL,1,1,NULL,NULL,200,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-11 09:32:39',NULL,NULL,10000000000436,0,NULL,1,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(10000000001116,'com.landsystems.lrs.model.Transaction','PLS000001116',1,24,30,'BP3710','BP3710',NULL,NULL,1,0,NULL,0,NULL,'2014-12-11 09:34:17',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,395.64,0,NULL,NULL,NULL,NULL,NULL,NULL,1,1,NULL,2,100000,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-11 09:34:17',NULL,NULL,10000000000437,0,NULL,1,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(10000000001117,'com.landsystems.lrs.model.Transaction','P-PLS000000679',5,26,31,'CofO8144','CofO8144',NULL,NULL,1,0,NULL,NULL,NULL,'2014-12-11 09:34:33',NULL,'1956-11-16 00:00:00','1996-11-15 00:00:00','1956-11-16 00:00:00','1956-11-16 00:00:00','1956-08-13 00:00:00',NULL,NULL,4.19,0,NULL,NULL,40,NULL,NULL,NULL,1,1,NULL,2,1000,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-11 09:34:33',NULL,NULL,10000000000425,1,NULL,1,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(10000000001118,'com.landsystems.lrs.model.Transaction','P-PLS000000680',5,24,31,'BP3912','BP3912',NULL,NULL,1,0,NULL,NULL,NULL,'2014-12-11 09:34:37',NULL,'1989-04-17 00:00:00','2088-04-16 00:00:00','1989-01-14 00:00:00','1989-01-14 00:00:00','1975-09-18 00:00:00',NULL,NULL,18.56,0,NULL,NULL,99,NULL,NULL,NULL,1,1,NULL,NULL,160000,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-11 09:34:37',NULL,NULL,10000000000431,1,NULL,1,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(10000000001119,'com.landsystems.lrs.model.Transaction','P-PLS000000681',3,26,31,'BP3728','BP3728',NULL,NULL,1,0,NULL,NULL,NULL,'2014-12-11 09:36:08',NULL,'1978-02-14 00:00:00','2077-02-13 00:00:00','1979-08-13 00:00:00','1979-08-21 00:00:00',NULL,NULL,NULL,89.75,0,NULL,NULL,99,NULL,NULL,NULL,1,1,NULL,2,30000,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-11 09:36:08',NULL,NULL,10000000000430,2,NULL,1,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL);

--
-- Table structure for table `lr_transaction_document`
--

CREATE TABLE `lr_transaction_document` (
  `transaction_id` decimal(19,0) NOT NULL,
  `document_id` decimal(19,0) NOT NULL,
  `document_index` int NOT NULL,
  PRIMARY KEY (`transaction_id`,`document_index`),
  KEY `lr_transaction_document__idx` (`transaction_id`,`document_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `lr_transaction_document`
--

INSERT INTO `lr_transaction_document` VALUES (10000000000006,10000000000016,0),(10000000000006,10000000000021,1),(10000000000006,10000000000036,2),(10000000000007,10000000000012,0),(10000000000007,10000000000014,1),(10000000000007,10000000000039,2),(10000000000007,10000000000054,3),(10000000000008,10000000000013,0),(10000000000008,10000000000020,1),(10000000000008,10000000000032,2),(10000000000008,10000000000048,3),(10000000000009,10000000000017,0),(10000000000009,10000000000018,1),(10000000000009,10000000000031,2),(10000000000009,10000000000042,3),(10000000000010,10000000000022,0),(10000000000010,10000000000033,1),(10000000000010,10000000249982,2),(10000000000011,10000000000023,0),(10000000000011,10000000000025,1),(10000000000011,10000000000034,2),(10000000000012,10000000000024,0),(10000000000012,10000000000026,1),(10000000000012,10000000000041,2),(10000000000013,10000000000027,0),(10000000000013,10000000000028,1),(10000000000013,10000000003338,2),(10000000000014,10000000000029,0),(10000000000014,10000000000030,1),(10000000000014,10000000000045,3),(10000000000014,10000000000063,2),(10000000000015,10000000000031,0),(10000000000016,10000000000032,0),(10000000000017,10000000000033,0),(10000000000018,10000000000034,0),(10000000000019,10000000000036,0),(10000000000020,10000000000046,0),(10000000000020,10000000000049,1),(10000000000020,10000000000065,2),(10000000000021,10000000000039,0),(10000000000022,10000000003338,0),(10000000000023,10000000000037,0),(10000000000023,10000000000038,1),(10000000000023,10000000000061,2),(10000000000023,10000000000076,3),(10000000000025,10000000000042,0),(10000000000026,10000000000048,0),(10000000000027,10000000000041,0),(10000000000028,10000000000045,0),(10000000000030,10000000000040,0),(10000000000030,10000000000050,1),(10000000000030,10000000000071,2),(10000000000030,10000000000088,3),(10000000000031,10000000000054,0),(10000000000032,10000000000053,0),(10000000000032,10000000000057,1),(10000000000032,10000000003365,2),(10000000000033,10000000000052,0),(10000000000033,10000000000062,1),(10000000000033,10000000000087,2),(10000000000034,10000000000051,0),(10000000000034,10000000000056,1),(10000000000034,10000000000064,2),(10000000000034,10000000000073,3),(10000000000035,10000000000055,0),(10000000000035,10000000000058,1),(10000000000035,10000000000066,3),(10000000000035,10000000000080,2),(10000000000036,10000000000059,0),(10000000000036,10000000000060,1),(10000000000036,10000000000083,2),(10000000000037,10000000000061,0),(10000000000038,10000000000065,0),(10000000000039,10000000000063,0),(10000000000040,10000000000064,0),(10000000000041,10000000000066,0),(10000000000042,10000000000068,0),(10000000000042,10000000000069,1),(10000000000042,10000000000089,2),(10000000000043,10000000000067,0),(10000000000043,10000000000070,1),(10000000000043,10000000000085,3),(10000000000043,10000000002715,2),(10000000000044,10000000003365,0),(10000000000045,10000000000073,0),(10000000000046,10000000000071,0),(10000000000047,10000000000076,0),(10000000000048,10000000000080,0),(10000000000049,10000000000074,0),(10000000000049,10000000000078,1),(10000000000049,10000000000093,2),(10000000000049,10000000000106,3),(10000000000050,10000000000077,0),(10000000000050,10000000000079,1),(10000000000050,10000000000102,2),(10000000000051,10000000000083,0),(10000000000052,10000000000081,0),(10000000000052,10000000000082,1),(10000000000052,10000000000092,2),(10000000000052,10000000000105,3),(10000000000053,10000000000085,0),(10000000000054,10000000000088,0),(10000000000055,10000000000084,0),(10000000000055,10000000000086,1),(10000000000055,10000000000098,3),(10000000000055,10000000000113,2),(10000000000056,10000000000087,0),(10000000000057,10000000000089,0),(10000000000058,10000000000090,0),(10000000000058,10000000000091,1),(10000000000058,10000000000114,2),(10000000000059,10000000000092,0),(10000000000060,10000000000093,0),(10000000000062,10000000000095,0),(10000000000062,10000000000097,1),(10000000000062,10000000000125,2),(10000000000063,10000000000098,0),(10000000000064,10000000000096,0),(10000000000064,10000000000099,1),(10000000000064,10000000000131,2),(10000000000066,10000000000102,0),(10000000000067,10000000000105,0),(10000000000068,10000000000106,0),(10000000000070,10000000000101,0),(10000000000070,10000000000103,1),(10000000000070,10000000000121,3),(10000000000070,10000000000133,2),(10000000000071,10000000000104,0),(10000000000071,10000000000109,1),(10000000000071,10000000000123,3),(10000000000071,10000000004197,2),(10000000000073,10000000000114,0),(10000000000075,10000000000108,0),(10000000000075,10000000000111,1),(10000000000075,10000000000136,2),(10000000000076,10000000000113,0),(10000000000077,10000000000110,0),(10000000000077,10000000000116,1),(10000000000077,10000000000128,2),(10000000000077,10000000000140,3),(10000000000078,10000000000112,0),(10000000000078,10000000000119,1),(10000000000078,10000000000145,2),(10000000000079,10000000000115,0),(10000000000079,10000000000118,1),(10000000000079,10000000000129,4),(10000000000079,10000000000138,2),(10000000000079,10000000000148,3),(10000000000080,10000000000117,0),(10000000000080,10000000000120,1),(10000000000080,10000000000147,2),(10000000000080,10000000000164,3),(10000000000081,10000000000125,0),(10000000000082,10000000000121,0),(10000000000083,10000000000123,0),(10000000000084,10000000000122,0),(10000000000084,10000000000124,1),(10000000000084,10000000000134,2),(10000000000084,10000000000143,3),(10000000000085,10000000000128,0),(10000000000086,10000000000129,0),(10000000000087,10000000000127,0),(10000000000087,10000000000130,1),(10000000000087,10000000000139,2),(10000000000087,10000000000161,3),(10000000000088,10000000000131,0),(10000000000090,10000000000133,0),(10000000000091,10000000000134,0),(10000000000092,10000000000136,0),(10000000000093,10000000000140,0),(10000000000094,10000000000135,0),(10000000000094,10000000000137,1),(10000000000094,10000000000165,2),(10000000000095,10000000000138,0),(10000000000096,10000000000139,0),(10000000000098,10000000000143,0),(10000000000099,10000000000145,0),(10000000000100,10000000000147,0),(10000000000101,10000000000141,0),(10000000000101,10000000000142,1),(10000000000101,10000000003375,2),(10000000000101,10000000003385,3),(10000000000102,10000000000148,0),(10000000000103,10000000000144,0),(10000000000103,10000000000146,1),(10000000000103,10000000000163,2),(10000000000104,10000000000151,0),(10000000000104,10000000000178,2),(10000000000104,10000000002713,1),(10000000000105,10000000000150,0),(10000000000105,10000000000153,1),(10000000000105,10000000000166,2),(10000000000106,10000000000152,0),(10000000000106,10000000000154,1),(10000000000106,10000000000172,2),(10000000000106,10000000000189,3),(10000000000107,10000000000161,0),(10000000000108,10000000000155,0),(10000000000108,10000000000158,1),(10000000000108,10000000000171,2),(10000000000108,10000000000185,3),(10000000000109,10000000000157,0),(10000000000109,10000000000167,1),(10000000000110,10000000000156,0),(10000000000110,10000000000159,1),(10000000000110,10000000000168,2),(10000000000111,10000000003375,0),(10000000000112,10000000000164,0),(10000000000113,10000000000163,0),(10000000000114,10000000000165,0),(10000000000115,10000000000166,0),(10000000000116,10000000000168,0),(10000000000117,10000000000167,0),(10000000000118,10000000000171,0),(10000000000119,10000000000172,0),(10000000000120,10000000000169,0),(10000000000120,10000000000176,1),(10000000000120,10000000000193,2),(10000000000120,10000000000209,3),(10000000000121,10000000000170,0),(10000000000121,10000000000188,1),(10000000000121,10000000000211,2),(10000000000121,10000000000226,3),(10000000000123,10000000000173,0),(10000000000123,10000000000175,1),(10000000000123,10000000000195,2),(10000000000124,10000000000178,0),(10000000000126,10000000000177,0),(10000000000126,10000000000183,1),(10000000000126,10000000000206,3),(10000000000126,10000000003314,2),(10000000000127,10000000000180,0),(10000000000127,10000000000181,1),(10000000000127,10000000000208,2),(10000000000127,10000000000220,3),(10000000000128,10000000000179,0),(10000000000128,10000000000182,1),(10000000000128,10000000000196,2),(10000000000129,10000000000185,0),(10000000000130,10000000000189,0),(10000000000131,10000000000184,0),(10000000000131,10000000000187,1),(10000000000131,10000000000203,3),(10000000000131,10000000000205,2),(10000000000133,10000000000193,0),(10000000000134,10000000000192,0),(10000000000134,10000000000194,1),(10000000000134,10000000014546,2),(10000000000135,10000000000196,0),(10000000000136,10000000000195,0),(10000000000137,10000000000203,0),(10000000000138,10000000000197,0),(10000000000138,10000000000200,1),(10000000000139,10000000000199,0),(10000000000139,10000000000201,1),(10000000000139,10000000000222,2),(10000000000140,10000000000198,0),(10000000000140,10000000000202,1),(10000000000140,10000000000219,2),(10000000000140,10000000000224,3),(10000000000141,10000000000208,0),(10000000000143,10000000000209,0),(10000000000144,10000000000204,0),(10000000000144,10000000000207,1),(10000000000144,10000000000218,2),(10000000000144,10000000000230,3),(10000000000145,10000000000205,0),(10000000000146,10000000000206,0),(10000000000147,10000000000219,0),(10000000000148,10000000000211,0),(10000000000149,10000000000210,0),(10000000000149,10000000000212,1),(10000000000149,10000000000231,2),(10000000000150,10000000000213,0),(10000000000150,10000000000215,1),(10000000000150,10000000000233,3),(10000000000150,10000000000240,2),(10000000000151,10000000000214,0),(10000000000151,10000000000216,1),(10000000000151,10000000000312,2),(10000000000153,10000000000220,0),(10000000000154,10000000000218,0),(10000000000155,10000000000227,0),(10000000000155,10000000000232,1),(10000000000155,10000000000263,2),(10000000000155,10000000000280,3),(10000000000156,10000000000226,0),(10000000000157,10000000000222,0),(10000000000158,10000000000224,0),(10000000000159,10000000000230,0),(10000000000160,10000000000221,0),(10000000000160,10000000000229,1),(10000000000160,10000000000238,3),(10000000000160,10000000003381,2),(10000000000162,10000000000223,0),(10000000000162,10000000000225,1),(10000000000162,10000000000243,2),(10000000000162,10000000000268,3),(10000000000163,10000000000231,0),(10000000000164,10000000000233,0),(10000000000165,10000000000234,0),(10000000000165,10000000000236,1),(10000000000165,10000000000247,2),(10000000000166,10000000000235,0),(10000000000166,10000000000248,1),(10000000000166,10000000000271,2),(10000000000167,10000000000238,0),(10000000000168,10000000000237,0),(10000000000168,10000000000239,1),(10000000000168,10000000000252,2),(10000000000169,10000000000240,0),(10000000000170,10000000000243,0),(10000000000171,10000000000241,0),(10000000000171,10000000000246,1),(10000000000171,10000000000332,2),(10000000000172,10000000000242,0),(10000000000172,10000000000244,1),(10000000000172,10000000000266,3),(10000000000172,10000000000272,2),(10000000000173,10000000000245,0),(10000000000173,10000000000253,1),(10000000000173,10000000000287,2),(10000000000175,10000000000247,0),(10000000000176,10000000000252,0),(10000000000177,10000000000249,0),(10000000000177,10000000000251,1),(10000000000177,10000000000267,2),(10000000000179,10000000000268,0),(10000000000180,10000000000263,0),(10000000000181,10000000000254,0),(10000000000181,10000000000257,1),(10000000000181,10000000000270,2),(10000000000181,10000000000281,3),(10000000000182,10000000000256,0),(10000000000182,10000000000265,1),(10000000000182,10000000000269,2),(10000000000183,10000000000264,0),(10000000000183,10000000000282,1),(10000000000183,10000000002777,2),(10000000000184,10000000000259,0),(10000000000184,10000000000262,1),(10000000000184,10000000000285,2),(10000000000184,10000000000294,3),(10000000000185,10000000000260,0),(10000000000185,10000000000261,1),(10000000000185,10000000000283,3),(10000000000185,10000000000293,2),(10000000000186,10000000000266,0),(10000000000187,10000000000267,0),(10000000000188,10000000000269,0),(10000000000189,10000000000280,0),(10000000000190,10000000000271,0),(10000000000191,10000000000270,0),(10000000000192,10000000000287,0),(10000000000193,10000000000272,0),(10000000000194,10000000000276,0),(10000000000194,10000000000297,1),(10000000000195,10000000000274,0),(10000000000195,10000000000277,1),(10000000000195,10000000000288,2),(10000000000195,10000000000296,3),(10000000000196,10000000000275,0),(10000000000196,10000000000278,1),(10000000000196,10000000000303,2),(10000000000196,10000000000314,3),(10000000000197,10000000000281,0),(10000000000198,10000000000279,0),(10000000000198,10000000000284,1),(10000000000198,10000000000304,3),(10000000000198,10000000002824,2),(10000000000199,10000000000282,0),(10000000000200,10000000000283,0),(10000000000201,10000000000285,0),(10000000000202,10000000000288,0),(10000000000203,10000000000286,0),(10000000000203,10000000000289,1),(10000000000203,10000000000310,2),(10000000000204,10000000000290,0),(10000000000204,10000000000292,1),(10000000000204,10000000000318,2),(10000000000204,10000000000339,3),(10000000000205,10000000000297,0),(10000000000206,10000000000291,0),(10000000000206,10000000000295,1),(10000000000206,10000000000308,2),(10000000000207,10000000000293,0),(10000000000208,10000000000294,0),(10000000000209,10000000000296,0),(10000000000212,10000000000310,0),(10000000000213,10000000000298,0),(10000000000213,10000000000299,1),(10000000000213,10000000000317,2),(10000000000214,10000000000304,0),(10000000000215,10000000000303,0),(10000000000216,10000000000300,0),(10000000000216,10000000000316,1),(10000000000216,10000000000335,2),(10000000000216,10000000000342,3),(10000000000217,10000000000302,0),(10000000000217,10000000000305,1),(10000000000217,10000000000313,2),(10000000000217,10000000000322,3),(10000000000218,10000000000306,0),(10000000000218,10000000000307,1),(10000000000218,10000000000319,2),(10000000000218,10000000000328,3),(10000000000219,10000000000308,0),(10000000000220,10000000000317,0),(10000000000221,10000000000314,0),(10000000000222,10000000000318,0),(10000000000223,10000000000311,0),(10000000000223,10000000000315,1),(10000000000223,10000000000323,2),(10000000000224,10000000000312,0),(10000000000225,10000000000313,0),(10000000000226,10000000000319,0),(10000000000227,10000000000322,0),(10000000000228,10000000000320,0),(10000000000228,10000000000321,1),(10000000000228,10000000000330,2),(10000000000229,10000000000323,0),(10000000000230,10000000000325,0),(10000000000230,10000000000336,1),(10000000000230,10000000000360,2),(10000000000230,10000000000380,3),(10000000000231,10000000000324,0),(10000000000231,10000000000340,1),(10000000000231,10000000000451,2),(10000000000232,10000000000326,0),(10000000000232,10000000000327,1),(10000000000232,10000000000354,2),(10000000000233,10000000000328,0),(10000000000234,10000000000332,0),(10000000000235,10000000000330,0),(10000000000236,10000000000329,0),(10000000000236,10000000000331,1),(10000000000236,10000000000343,3),(10000000000236,10000000000356,2),(10000000000237,10000000000333,0),(10000000000237,10000000000334,1),(10000000000237,10000000000341,2),(10000000000238,10000000000335,0),(10000000000239,10000000000339,0),(10000000000240,10000000000337,0),(10000000000240,10000000000338,1),(10000000000240,10000000000358,3),(10000000000240,10000000000367,2),(10000000000242,10000000000342,0),(10000000000243,10000000000341,0),(10000000000244,10000000000343,0),(10000000000246,10000000000346,0),(10000000000246,10000000000350,1),(10000000000246,10000000000405,3),(10000000000246,10000000003287,2),(10000000000247,10000000000345,0),(10000000000247,10000000000347,1),(10000000000247,10000000000361,3),(10000000000247,10000000003033,2),(10000000000248,10000000000356,0),(10000000000249,10000000000348,0),(10000000000249,10000000000351,1),(10000000000249,10000000000366,3),(10000000000249,10000000002734,2),(10000000000250,10000000000352,0),(10000000000250,10000000000355,1),(10000000000250,10000000000364,2),(10000000000250,10000000000369,3),(10000000000251,10000000000349,0),(10000000000251,10000000000353,1),(10000000000251,10000000000365,2),(10000000000252,10000000000354,0),(10000000000253,10000000000360,0),(10000000000255,10000000000358,0),(10000000000256,10000000000361,0),(10000000000257,10000000000357,0),(10000000000257,10000000000359,1),(10000000000257,10000000000386,3),(10000000000257,10000000000411,2),(10000000000258,10000000000362,0),(10000000000258,10000000000363,1),(10000000000258,10000000000378,2),(10000000000258,10000000000384,3),(10000000000259,10000000000364,0),(10000000000260,10000000000365,0),(10000000000261,10000000000366,0),(10000000000262,10000000000367,0),(10000000000264,10000000000369,0),(10000000000265,10000000000370,0),(10000000000265,10000000000371,1),(10000000000265,10000000000434,7),(10000000000265,10000000000443,5),(10000000000265,10000000000458,3),(10000000000265,10000000000467,4),(10000000000265,10000000000483,2),(10000000000265,10000000000490,8),(10000000000265,10000000000721,6),(10000000000266,10000000000380,0),(10000000000267,10000000000381,0),(10000000000267,10000000000388,1),(10000000000267,10000000000404,2),(10000000000269,10000000000373,0),(10000000000269,10000000000377,1),(10000000000269,10000000000385,3),(10000000000269,10000000000393,2),(10000000000270,10000000000374,0),(10000000000270,10000000000376,1),(10000000000270,10000000000395,2),(10000000000271,10000000000375,0),(10000000000271,10000000000379,1),(10000000000271,10000000000390,3),(10000000000271,10000000000399,2),(10000000000273,10000000000378,0),(10000000000274,10000000000382,0),(10000000000274,10000000000383,1),(10000000000274,10000000000396,2),(10000000000274,10000000002716,3),(10000000000275,10000000000386,0),(10000000000276,10000000000384,0),(10000000000277,10000000000385,0),(10000000000278,10000000000390,0),(10000000000279,10000000000389,0),(10000000000279,10000000000409,1),(10000000000280,10000000000393,0),(10000000000281,10000000000395,0),(10000000000282,10000000000391,0),(10000000000282,10000000000392,1),(10000000000282,10000000000408,2),(10000000000283,10000000000396,0),(10000000000284,10000000000399,0),(10000000000285,10000000000405,0),(10000000000286,10000000000398,0),(10000000000286,10000000000401,1),(10000000000286,10000000000417,2),(10000000000286,10000000000427,3),(10000000000287,10000000000400,0),(10000000000287,10000000000403,1),(10000000000287,10000000000419,2),(10000000000287,10000000013896,3),(10000000000289,10000000000404,0),(10000000000290,10000000000406,0),(10000000000290,10000000000407,1),(10000000000290,10000000000414,2),(10000000000291,10000000000408,0),(10000000000292,10000000000409,0),(10000000000293,10000000000411,0),(10000000000294,10000000000410,0),(10000000000294,10000000000413,1),(10000000000294,10000000000422,2),(10000000000294,10000000002717,3),(10000000000295,10000000000417,0),(10000000000296,10000000000412,0),(10000000000296,10000000000415,1),(10000000000296,10000000000452,2),(10000000000297,10000000000414,0),(10000000000298,10000000000416,0),(10000000000298,10000000000418,1),(10000000000298,10000000000425,3),(10000000000298,10000000005838,2),(10000000000300,10000000000419,0),(10000000000301,10000000000422,0),(10000000000302,10000000000427,0),(10000000000303,10000000000420,0),(10000000000303,10000000000423,1),(10000000000303,10000000000433,2),(10000000000304,10000000000421,0),(10000000000304,10000000000424,1),(10000000000304,10000000000435,2),(10000000000304,10000000000446,3),(10000000000305,10000000000425,0),(10000000000308,10000000000428,0),(10000000000308,10000000000431,1),(10000000000308,10000000000460,2),(10000000000308,10000000000475,3),(10000000000309,10000000000433,0),(10000000000311,10000000000434,0),(10000000000312,10000000000435,0),(10000000000313,10000000000438,0),(10000000000315,10000000000443,0),(10000000000316,10000000000439,0),(10000000000316,10000000000441,1),(10000000000316,10000000000456,2),(10000000000316,10000000000463,3),(10000000000317,10000000000440,0),(10000000000317,10000000000444,1),(10000000000317,10000000000455,2),(10000000000318,10000000000442,0),(10000000000318,10000000000445,1),(10000000000319,10000000000446,0),(10000000000320,10000000000452,0),(10000000000321,10000000000451,0),(10000000000322,10000000000457,0),(10000000000322,10000000000459,1),(10000000000322,10000000000478,2),(10000000000322,10000000002921,3),(10000000000323,10000000000448,0),(10000000000323,10000000000450,1),(10000000000323,10000000000462,2),(10000000000323,10000000000470,3),(10000000000324,10000000000447,0),(10000000000324,10000000000449,1),(10000000000324,10000000000464,2),(10000000000324,10000000000476,3),(10000000000325,10000000000458,0),(10000000000326,10000000000453,0),(10000000000326,10000000000454,1),(10000000000326,10000000000468,2),(10000000000327,10000000000460,0),(10000000000328,10000000000456,0),(10000000000329,10000000000455,0),(10000000000330,10000000000462,0),(10000000000332,10000000000463,0),(10000000000333,10000000000461,0),(10000000000333,10000000000465,1),(10000000000333,10000000000517,2),(10000000000333,10000000002912,3),(10000000000334,10000000000467,0),(10000000000335,10000000000464,0),(10000000000336,10000000000466,0),(10000000000336,10000000000472,1),(10000000000336,10000000000515,2),(10000000000336,10000000000519,3),(10000000000337,10000000000468,0),(10000000000338,10000000000470,0),(10000000000339,10000000000469,0),(10000000000339,10000000000473,1),(10000000000339,10000000000480,2),(10000000000339,10000000002980,3),(10000000000340,10000000000475,0),(10000000000341,10000000000471,0),(10000000000341,10000000000474,1),(10000000000341,10000000000486,3),(10000000000341,10000000000497,2),(10000000000342,10000000000476,0),(10000000000343,10000000000483,0),(10000000000344,10000000000478,0),(10000000000345,10000000000477,0),(10000000000345,10000000000481,1),(10000000000345,10000000000488,2),(10000000000345,10000000000499,3),(10000000000346,10000000000480,0),(10000000000347,10000000000479,0),(10000000000347,10000000000482,1),(10000000000347,10000000000495,2),(10000000000348,10000000000484,0),(10000000000348,10000000000503,1),(10000000000348,10000000014393,2),(10000000000348,10000000014396,3),(10000000000350,10000000000486,0),(10000000000352,10000000000488,0),(10000000000353,10000000000492,0),(10000000000354,10000000000490,0),(10000000000355,10000000000489,0),(10000000000355,10000000000491,1),(10000000000355,10000000000502,2),(10000000000356,10000000000493,0),(10000000000356,10000000000494,1),(10000000000356,10000000000504,2),(10000000000356,10000000044369,3),(10000000000356,10000000044815,4),(10000000000357,10000000000497,0),(10000000000358,10000000000495,0),(10000000000360,10000000000496,0),(10000000000360,10000000000498,1),(10000000000360,10000000000518,2),(10000000000360,10000000000527,3),(10000000000361,10000000000499,0),(10000000000362,10000000000500,0),(10000000000362,10000000000501,1),(10000000000362,10000000000521,2),(10000000000363,10000000000502,0),(10000000000364,10000000000509,0),(10000000000365,10000000000504,0),(10000000000367,10000000000505,0),(10000000000367,10000000000507,1),(10000000000367,10000000000512,2),(10000000000367,10000000000532,3),(10000000000368,10000000000506,0),(10000000000368,10000000000508,1),(10000000000368,10000000000516,2),(10000000000369,10000000000510,0),(10000000000369,10000000000511,1),(10000000000369,10000000000523,3),(10000000000369,10000000000531,2),(10000000000370,10000000000515,0),(10000000000371,10000000000512,0),(10000000000372,10000000000513,0),(10000000000372,10000000000514,1),(10000000000372,10000000000525,2),(10000000000376,10000000000516,0),(10000000000377,10000000000519,0),(10000000000378,10000000000518,0),(10000000000379,10000000000521,0),(10000000000380,10000000000517,0),(10000000000381,10000000000523,0),(10000000000382,10000000000522,0),(10000000000382,10000000000524,1),(10000000000382,10000000000530,2),(10000000000383,10000000000525,0),(10000000000385,10000000000527,0),(10000000000386,10000000000526,0),(10000000000386,10000000000528,1),(10000000000386,10000000000542,2),(10000000000386,10000000000545,3),(10000000000387,10000000000530,0),(10000000000388,10000000000531,0),(10000000000389,10000000000532,0),(10000000000392,10000000000535,0),(10000000000392,10000000000543,1),(10000000000392,10000000000550,2),(10000000000392,10000000000552,3),(10000000000393,10000000000534,0),(10000000000393,10000000000536,1),(10000000000393,10000000000546,2),(10000000000393,10000000000551,3),(10000000000394,10000000000540,0),(10000000000394,10000000000544,1),(10000000000394,10000000000549,2),(10000000000395,10000000000539,0),(10000000000395,10000000000541,1),(10000000000395,10000000002467,2),(10000000000395,10000000003298,3),(10000000000396,10000000000542,0),(10000000000397,10000000000544,0),(10000000000398,10000000000545,0),(10000000000399,10000000000546,0),(10000000000400,10000000000549,0),(10000000000401,10000000003298,0),(10000000000402,10000000000548,0),(10000000000402,10000000014575,1),(10000000000402,10000000232364,2),(10000000000402,10000000232399,3),(10000000000403,10000000000550,0),(10000000000404,10000000000551,0),(10000000000405,10000000000552,0),(10000000000406,10000000000553,0),(10000000000406,10000000000554,1),(10000000000406,10000000000555,3),(10000000000406,10000000000556,2),(10000000000407,10000000000555,0),(10000000000408,10000000000556,0),(10000000000409,10000000000557,0),(10000000000409,10000000000559,1),(10000000000409,10000000000574,2),(10000000000410,10000000000558,0),(10000000000410,10000000000561,1),(10000000000410,10000000000571,2),(10000000000411,10000000000560,0),(10000000000411,10000000000562,1),(10000000000411,10000000000590,2),(10000000000411,10000000000603,3),(10000000000412,10000000000563,0),(10000000000412,10000000000564,1),(10000000000412,10000000000581,3),(10000000000412,10000000000594,2),(10000000000413,10000000000568,0),(10000000000413,10000000000569,1),(10000000000413,10000000000580,2),(10000000000413,10000000000593,3),(10000000000414,10000000000565,0),(10000000000414,10000000000566,1),(10000000000414,10000000000592,2),(10000000000414,10000000000609,4),(10000000000414,10000000000703,3),(10000000000415,10000000000567,0),(10000000000415,10000000000570,1),(10000000000415,10000000000583,2),(10000000000416,10000000000574,0),(10000000000417,10000000000571,0),(10000000000418,10000000000572,0),(10000000000418,10000000000585,1),(10000000000418,10000000000596,2),(10000000000418,10000000006361,3),(10000000000419,10000000000575,0),(10000000000419,10000000000595,1),(10000000000420,10000000000577,0),(10000000000420,10000000000579,1),(10000000000420,10000000000589,3),(10000000000420,10000000002826,2),(10000000000421,10000000000581,0),(10000000000422,10000000000576,0),(10000000000422,10000000000578,1),(10000000000422,10000000000588,3),(10000000000422,10000000000597,2),(10000000000423,10000000000590,0),(10000000000424,10000000000580,0),(10000000000425,10000000000583,0),(10000000000426,10000000000582,0),(10000000000426,10000000000584,1),(10000000000426,10000000000598,2),(10000000000426,10000000000620,3),(10000000000427,10000000000592,0),(10000000000428,10000000000595,0),(10000000000429,10000000000588,0),(10000000000430,10000000000593,0),(10000000000431,10000000000589,0),(10000000000432,10000000000586,0),(10000000000432,10000000000591,1),(10000000000432,10000000000599,2),(10000000000432,10000000000611,3),(10000000000433,10000000000594,0),(10000000000434,10000000000596,0),(10000000000435,10000000000597,0),(10000000000436,10000000000598,0),(10000000000437,10000000000599,0),(10000000000438,10000000000603,0),(10000000000439,10000000000609,0),(10000000000440,10000000000600,0),(10000000000440,10000000000614,1),(10000000000441,10000000000601,0),(10000000000441,10000000000605,1),(10000000000441,10000000000616,2),(10000000000441,10000000000628,3),(10000000000443,10000000000606,0),(10000000000443,10000000000607,1),(10000000000443,10000000000618,2),(10000000000443,10000000000624,3),(10000000000445,10000000000611,0),(10000000000446,10000000000610,0),(10000000000446,10000000000612,1),(10000000000446,10000000000623,2),(10000000000446,10000000000634,3),(10000000000447,10000000000620,0),(10000000000448,10000000000614,0),(10000000000449,10000000000616,0),(10000000000450,10000000000613,0),(10000000000450,10000000000615,1),(10000000000450,10000000000622,2),(10000000000450,10000000007028,3),(10000000000451,10000000000618,0),(10000000000452,10000000000617,0),(10000000000452,10000000000629,1),(10000000000452,10000000000648,2),(10000000000453,10000000000619,0),(10000000000453,10000000000621,1),(10000000000453,10000000000627,2),(10000000000453,10000000000637,3),(10000000000455,10000000000622,0),(10000000000456,10000000000623,0),(10000000000458,10000000000624,0),(10000000000459,10000000000628,0),(10000000000460,10000000000627,0),(10000000000461,10000000000625,0),(10000000000461,10000000000626,1),(10000000000462,10000000000634,0),(10000000000464,10000000000630,0),(10000000000464,10000000000631,1),(10000000000464,10000000000654,2),(10000000000465,10000000000632,0),(10000000000465,10000000000638,1),(10000000000465,10000000001043,3),(10000000000465,10000000005610,2),(10000000000466,10000000000637,0),(10000000000467,10000000000633,0),(10000000000467,10000000000635,1),(10000000000467,10000000000653,2),(10000000000467,10000000000658,3),(10000000000468,10000000000639,0),(10000000000468,10000000000641,1),(10000000000468,10000000000660,2),(10000000000468,10000000000675,3),(10000000000469,10000000000640,0),(10000000000469,10000000000642,1),(10000000000469,10000000000657,3),(10000000000469,10000000005676,2),(10000000000470,10000000000643,0),(10000000000470,10000000000651,1),(10000000000470,10000000000667,2),(10000000000471,10000000000644,0),(10000000000471,10000000000646,1),(10000000000471,10000000001011,2),(10000000000471,10000000005802,3),(10000000000472,10000000000645,0),(10000000000472,10000000000647,1),(10000000000472,10000000000668,2),(10000000000473,10000000000648,0),(10000000000474,10000000000653,0),(10000000000475,10000000000654,0),(10000000000476,10000000000650,0),(10000000000476,10000000000652,1),(10000000000476,10000000000663,3),(10000000000476,10000000000670,2),(10000000000476,10000000046109,4),(10000000000476,10000000046115,5),(10000000000477,10000000000655,0),(10000000000477,10000000000656,1),(10000000000477,10000000000669,2),(10000000000478,10000000000657,0),(10000000000479,10000000000658,0),(10000000000480,10000000000660,0),(10000000000481,10000000000663,0),(10000000000482,10000000000659,0),(10000000000482,10000000000661,1),(10000000000482,10000000000673,2),(10000000000482,10000000004901,3),(10000000000484,10000000000667,0),(10000000000485,10000000000662,0),(10000000000485,10000000000665,1),(10000000000485,10000000000671,2),(10000000000486,10000000000664,0),(10000000000486,10000000000666,1),(10000000000486,10000000000688,3),(10000000000486,10000000000698,2),(10000000000487,10000000000669,0),(10000000000488,10000000000668,0),(10000000000489,10000000000670,0),(10000000000490,10000000000671,0),(10000000000491,10000000000675,0),(10000000000492,10000000000673,0),(10000000000494,10000000000674,0),(10000000000494,10000000000676,1),(10000000000494,10000000000684,2),(10000000000495,10000000000677,0),(10000000000495,10000000000678,1),(10000000000495,10000000000694,2),(10000000000495,10000000000701,3),(10000000000496,10000000000680,0),(10000000000496,10000000000681,1),(10000000000496,10000000000696,3),(10000000000496,10000000000705,2),(10000000000497,10000000000679,0),(10000000000497,10000000000682,1),(10000000000497,10000000000689,2),(10000000000497,10000000005563,3),(10000000000499,10000000000684,0),(10000000000500,10000000000685,0),(10000000000500,10000000000687,1),(10000000000500,10000000000704,2),(10000000000502,10000000000688,0),(10000000000503,10000000000689,0),(10000000000504,10000000000703,0),(10000000000505,10000000000690,0),(10000000000505,10000000000691,1),(10000000000505,10000000000699,2),(10000000000505,10000000041154,4),(10000000000505,10000000041175,3),(10000000000506,10000000000692,0),(10000000000506,10000000000693,1),(10000000000506,10000000000700,2),(10000000000506,10000000005580,3),(10000000000507,10000000000694,0),(10000000000508,10000000000695,0),(10000000000508,10000000000697,1),(10000000000508,10000000000709,2),(10000000000509,10000000000696,0),(10000000000511,10000000000698,0),(10000000000512,10000000000699,0),(10000000000513,10000000000700,0),(10000000000514,10000000000701,0),(10000000000515,10000000000705,0),(10000000000516,10000000000702,0),(10000000000516,10000000000708,1),(10000000000516,10000000000725,2),(10000000000517,10000000000704,0),(10000000000519,10000000000709,0),(10000000000520,10000000000710,0),(10000000000520,10000000000715,1),(10000000000520,10000000000727,2),(10000000000520,10000000000740,3),(10000000000521,10000000000711,0),(10000000000521,10000000000712,1),(10000000000521,10000000000726,2),(10000000000521,10000000000735,3),(10000000000522,10000000000721,0),(10000000000524,10000000000713,0),(10000000000524,10000000000720,1),(10000000000524,10000000000744,2),(10000000000525,10000000000714,0),(10000000000525,10000000000717,1),(10000000000525,10000000000728,3),(10000000000525,10000000000733,2),(10000000000526,10000000000725,0),(10000000000527,10000000000716,0),(10000000000527,10000000000756,1),(10000000000528,10000000000718,0),(10000000000528,10000000000719,1),(10000000000528,10000000000729,2),(10000000000529,10000000000722,0),(10000000000529,10000000000723,1),(10000000000529,10000000000736,2),(10000000000530,10000000000729,0),(10000000000531,10000000000724,0),(10000000000531,10000000000731,1),(10000000000531,10000000278631,2),(10000000000532,10000000000726,0),(10000000000533,10000000000728,0),(10000000000534,10000000000727,0),(10000000000535,10000000000730,0),(10000000000535,10000000000737,1),(10000000000535,10000000000748,3),(10000000000535,10000000005183,2),(10000000000536,10000000000732,0),(10000000000536,10000000000734,1),(10000000000536,10000000000738,2),(10000000000538,10000000000733,0),(10000000000539,10000000000735,0),(10000000000540,10000000000736,0),(10000000000541,10000000000740,0),(10000000000542,10000000000738,0),(10000000000543,10000000000739,0),(10000000000543,10000000000742,1);

--
-- Table structure for table `lr_transaction_ext`
--

CREATE TABLE `lr_transaction_ext` (
  `parent_id` decimal(19,0) NOT NULL,
  `Hjtype` varchar(255) NOT NULL,
  `extended_comments` varchar(2000) DEFAULT NULL,
  `extended_params` varchar(1000) DEFAULT NULL,
  `NonExistingPropertiesSearch` varchar(1000) DEFAULT NULL,
  `CountPropertiesSearch` decimal(19,0) DEFAULT NULL,
  PRIMARY KEY (`parent_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `lr_transaction_ext`
--


--
-- Table structure for table `lr_transaction_launit`
--

CREATE TABLE `lr_transaction_launit` (
  `transaction_id` decimal(19,0) NOT NULL,
  `launit_id` decimal(19,0) NOT NULL,
  `launit_index` int NOT NULL,
  PRIMARY KEY (`transaction_id`,`launit_index`),
  KEY `lr_transaction_launit__idx` (`transaction_id`,`launit_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `lr_transaction_launit`
--


--
-- Table structure for table `lr_transaction_metadata`
--

CREATE TABLE `lr_transaction_metadata` (
  `Id` decimal(19,0) NOT NULL,
  `Hjtype` varchar(255) NOT NULL,
  `code` varchar(64) NOT NULL,
  `label` varchar(128) NOT NULL,
  `descr` varchar(1000) DEFAULT NULL,
  `category` varchar(64) NOT NULL,
  `general_term` tinyint DEFAULT NULL,
  `sort_order` int DEFAULT NULL,
  `hidden` tinyint DEFAULT NULL,
  `group_name` varchar(255) DEFAULT NULL,
  `workflow` varchar(255) DEFAULT NULL,
  `group_code` varchar(3) DEFAULT NULL,
  `normal_duration` decimal(19,0) DEFAULT NULL,
  `lapsed_duration` decimal(19,0) DEFAULT NULL,
  `max_duration` decimal(19,0) DEFAULT NULL,
  `right_type` varchar(64) DEFAULT NULL,
  `meta_type` int NOT NULL,
  `action_type` int NOT NULL,
  `source_party_type` varchar(255) DEFAULT NULL,
  `target_party_type` varchar(255) DEFAULT NULL,
  `related_transaction_code` varchar(64) DEFAULT NULL,
  `blocking_transaction_code` varchar(2000) DEFAULT NULL,
  `non_withdrawable_tasks` varchar(500) DEFAULT NULL,
  `cashier_transaction_code` varchar(500) DEFAULT NULL,
  `mandatory_docs_codes` varchar(255) DEFAULT NULL,
  `complete_reports_codes` varchar(1000) DEFAULT NULL,
  `reject_reports_codes` varchar(1000) DEFAULT NULL,
  `report_templates` varchar(1000) DEFAULT NULL,
  `detachable` tinyint DEFAULT NULL,
  `related_active_rrrs` varchar(500) DEFAULT NULL,
  `blocked_by_active_rrrs` varchar(500) DEFAULT NULL,
  `discharge_active_rrrs` varchar(500) DEFAULT NULL,
  `modify_active_rrrs` varchar(500) DEFAULT NULL,
  `create_new_rrrs` varchar(500) DEFAULT NULL,
  `retrieve_source_parties` varchar(255) DEFAULT NULL,
  `retrieve_target_parties` varchar(255) DEFAULT NULL,
  `version` decimal(19,0) DEFAULT NULL,
  `begin_lifespan_version` datetime DEFAULT NULL,
  `end_lifespan_version` datetime DEFAULT NULL,
  `stamp_duty` varchar(255) DEFAULT NULL,
  `cashier_code_based_on_source` varchar(500) DEFAULT NULL,
  `mandatory_scan_outgoing_document_codes` varchar(500) DEFAULT NULL,
  PRIMARY KEY (`Id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `lr_transaction_metadata`
--


--
-- Table structure for table `lr_transaction_note`
--

CREATE TABLE `lr_transaction_note` (
  `id` decimal(19,0) NOT NULL,
  `Hjtype` varchar(255) NOT NULL,
  `note_type` decimal(19,0) NOT NULL,
  `comments` varchar(800) DEFAULT NULL,
  `user_name` varchar(150) DEFAULT NULL,
  `task_id` decimal(19,0) DEFAULT NULL,
  `task_name` varchar(250) DEFAULT NULL,
  `comment_ref` varchar(250) DEFAULT NULL,
  `create_date` datetime DEFAULT NULL,
  `transaction_id` decimal(19,0) DEFAULT NULL,
  `note_index` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `lr_transaction_note`
--


--
-- Table structure for table `lr_transaction_party`
--

CREATE TABLE `lr_transaction_party` (
  `transaction_id` decimal(19,0) NOT NULL,
  `party_id` decimal(19,0) NOT NULL,
  `party_index` int NOT NULL,
  PRIMARY KEY (`transaction_id`,`party_index`),
  KEY `lr_transaction_party__idx` (`transaction_id`,`party_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `lr_transaction_party`
--


--
-- Table structure for table `lr_transaction_record`
--

CREATE TABLE `lr_transaction_record` (
  `id` decimal(19,0) NOT NULL,
  `Hjtype` varchar(255) NOT NULL,
  `operation_type` decimal(19,0) NOT NULL,
  `source_rrr` decimal(19,0) DEFAULT NULL,
  `target_rrr` decimal(19,0) DEFAULT NULL,
  `transaction_id` decimal(19,0) DEFAULT NULL,
  `record_index` int DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `lr_transaction_record_operation_type_idx` (`operation_type`),
  KEY `lr_transaction_record_transaction_id_idx` (`transaction_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `lr_transaction_record`
--


--
-- Table structure for table `lr_usage`
--

CREATE TABLE `lr_usage` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `Hjtype` varchar(255) NOT NULL,
  `usage_type` decimal(19,0) NOT NULL,
  `comments` varchar(800) DEFAULT NULL,
  `version` decimal(19,0) DEFAULT NULL,
  `begin_lifespan_version` datetime DEFAULT NULL,
  `end_lifespan_version` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `lr_usage`
--


--
-- Table structure for table `lr_valuation`
--

CREATE TABLE `lr_valuation` (
  `id` decimal(19,0) NOT NULL,
  `Hjtype` varchar(255) NOT NULL,
  `value` double DEFAULT NULL,
  `value_type` decimal(19,0) NOT NULL,
  `value_date` datetime DEFAULT NULL,
  `comments` varchar(800) DEFAULT NULL,
  `valu1` varchar(50) DEFAULT NULL,
  `valu2` varchar(50) DEFAULT NULL,
  `valu_dict1` decimal(19,0) NOT NULL,
  `valu_dict2` decimal(19,0) NOT NULL,
  `valu_date1` datetime DEFAULT NULL,
  `valu_date2` datetime DEFAULT NULL,
  `valu_count1` int DEFAULT NULL,
  `valu_count2` int DEFAULT NULL,
  `suid` varchar(50) DEFAULT NULL,
  `transaction_number` varchar(50) DEFAULT NULL,
  `version` decimal(19,0) DEFAULT NULL,
  `begin_lifespan_version` datetime DEFAULT NULL,
  `end_lifespan_version` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `lr_valuation`
--


--
-- Table structure for table `migrations`
--

CREATE TABLE `migrations` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `migration` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `batch` int NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `migrations`
--

INSERT INTO `migrations` VALUES (1,'2024_01_01_000000_import_production_dump',1),(2,'2024_01_01_000001_create_auth_tables',1),(3,'2024_01_01_000002_create_landing_tables',1),(4,'2024_01_01_000003_create_boundary_tables',1),(6,'2024_01_01_000003_create_login_panel_table',2),(7,'2024_01_01_000004_create_document_treatments_table',2),(9,'2024_01_01_000005_create_accounting_tables',3),(10,'2024_01_01_000006_create_gis_boundary_enhancements',4),(11,'2024_01_01_000007_add_user_id_to_commission_members',5),(12,'2024_01_01_000008_security_intelligence_layer',6),(13,'2024_01_01_000009_intelligence_layer',7),(14,'2024_01_01_000010_create_property_index_tables',8),(15,'2024_01_01_000011_add_party_type_to_property_index',9);

--
-- Table structure for table `property_document`
--

CREATE TABLE `property_document` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `property_id` bigint unsigned NOT NULL,
  `document_type` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `file_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `file_path` varchar(500) COLLATE utf8mb4_unicode_ci NOT NULL,
  `file_size` bigint unsigned DEFAULT NULL,
  `mime_type` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `uploaded_by` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `uploaded_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `property_document_property_id_document_type_index` (`property_id`,`document_type`),
  CONSTRAINT `property_document_property_id_foreign` FOREIGN KEY (`property_id`) REFERENCES `property_index` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `property_document`
--


--
-- Table structure for table `property_index`
--

CREATE TABLE `property_index` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `property_number` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `property_type` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `size_sqm` decimal(12,2) DEFAULT NULL,
  `plot` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `owner` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `party_type` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `boundary_id` bigint DEFAULT NULL,
  `state` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address` text COLLATE utf8mb4_unicode_ci,
  `description` text COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `property_index_property_number_unique` (`property_number`),
  KEY `property_index_property_type_index` (`property_type`),
  KEY `property_index_boundary_id_index` (`boundary_id`),
  KEY `property_index_state_index` (`state`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `property_index`
--


--
-- Table structure for table `refresh_tokens`
--

CREATE TABLE `refresh_tokens` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint unsigned NOT NULL,
  `token_hash` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL,
  `expires_at` timestamp NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `refresh_tokens_token_hash_unique` (`token_hash`),
  KEY `refresh_tokens_user_id_expires_at_index` (`user_id`,`expires_at`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `refresh_tokens`
--


--
-- Table structure for table `sdms_bootstrap`
--

CREATE TABLE `sdms_bootstrap` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `resource_name` varchar(255) NOT NULL,
  `res_version` int NOT NULL,
  `created` datetime NOT NULL,
  `modified` datetime NOT NULL,
  `is_model` tinyint NOT NULL,
  `resource_type` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `sdms_bootstrap`
--


--
-- Table structure for table `stakeholder`
--

CREATE TABLE `stakeholder` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `entity_type` varchar(100) NOT NULL,
  `contact_person` varchar(255) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `phone` varchar(50) DEFAULT NULL,
  `address` text,
  `role` varchar(100) DEFAULT NULL,
  `notes` text,
  `created_at` datetime DEFAULT CURRENT_TIMESTAMP,
  `updated_at` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `idx_name` (`name`),
  KEY `idx_entity_type` (`entity_type`),
  KEY `idx_role` (`role`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `stakeholder`
--

INSERT INTO `stakeholder` VALUES (1,'Plateau State Government','state','Commissioner for Lands','lands@plateaustate.gov.ng','+234-803-123-4567','Jos, Plateau State','claimant','Primary stakeholder in boundary matters','2025-12-16 16:08:58','2025-12-16 16:08:58'),(2,'Benue State Government','state','Commissioner for Lands','lands@benuestate.gov.ng','+234-803-234-5678','Makurdi, Benue State','claimant','Primary stakeholder in boundary matters','2025-12-16 16:08:58','2025-12-16 16:08:58'),(3,'Wase Community Leaders','community','Chief Wase','chief@wasecommunity.ng','+234-803-345-6789','Wase, Plateau State','affected_party','Community directly affected by boundary dispute','2025-12-16 16:08:58','2025-12-16 16:08:58'),(4,'Jos North LGA','lga','LGA Chairman','chairman@josnorthlga.ng','+234-803-456-7890','Jos North, Plateau State','claimant','Local government involved in administrative boundary','2025-12-16 16:08:58','2025-12-16 16:08:58'),(5,'Jos South LGA','lga','LGA Chairman','chairman@jossouthlga.ng','+234-803-567-8901','Jos South, Plateau State','claimant','Local government involved in administrative boundary','2025-12-16 16:08:58','2025-12-16 16:08:58'),(6,'National Boundary Commission','organization','Director General','info@boundarycommission.gov.ng','+234-803-678-9012','Abuja, FCT','mediator','Federal agency responsible for boundary management','2025-12-16 16:08:58','2025-12-16 16:08:58'),(7,'Plateau State Government','state','Commissioner for Lands','lands@plateaustate.gov.ng','+234-803-123-4567','Jos, Plateau State','claimant','Primary stakeholder in boundary matters','2025-12-16 16:30:49','2025-12-16 16:30:49'),(8,'Benue State Government','state','Commissioner for Lands','lands@benuestate.gov.ng','+234-803-234-5678','Makurdi, Benue State','claimant','Primary stakeholder in boundary matters','2025-12-16 16:30:49','2025-12-16 16:30:49'),(9,'Wase Community Leaders','community','Chief Wase','chief@wasecommunity.ng','+234-803-345-6789','Wase, Plateau State','affected_party','Community directly affected by boundary dispute','2025-12-16 16:30:49','2025-12-16 16:30:49'),(10,'Jos North LGA','lga','LGA Chairman','chairman@josnorthlga.ng','+234-803-456-7890','Jos North, Plateau State','claimant','Local government involved in administrative boundary','2025-12-16 16:30:49','2025-12-16 16:30:49'),(11,'Jos South LGA','lga','LGA Chairman','chairman@jossouthlga.ng','+234-803-567-8901','Jos South, Plateau State','claimant','Local government involved in administrative boundary','2025-12-16 16:30:49','2025-12-16 16:30:49'),(12,'National Boundary Commission','organization','Director General','info@boundarycommission.gov.ng','+234-803-678-9012','Abuja, FCT','mediator','Federal agency responsible for boundary management','2025-12-16 16:30:49','2025-12-16 16:30:49');

--
-- Dumping routines for database 'LRS43'
--


