xB2mySql - xBase Conversion Utility
Download xB2mySql - bat,lnk,prg, and exe
Syntax: xB2mySql paperl c:\post\data\paperms.dbf -
produced this output
c:\mySql\bin>mysql -h127.0.0.1 -uroot -p""
mySql>\. c:/zip/master.txt
The above two lines adds all the data to the mySql tables
.
OUTPUT from xB2mySql \T paperms.log use paperl; drop table if exists paperms\g create table paperms( recno int not null auto_increment, acctno char(6) not null, seq char(4) not null, typecode char(1) not null, descript char(60) not null, descmemo mediumtext, inst_date char(4) not null, rbld_date char(4) not null, capacity float(9,2) not null, cap_type char(6) not null, index acctno( acctno ), index seq( seq ), index typecode( typecode ), index descript( descript ), index inst_date( inst_date ), index rbld_date( rbld_date ), index capacity( capacity ), index cap_type( cap_type ), PRIMARY KEY(recno) )\g insert into paperms set recno = 1,acctno = '006465',seq = '0010',typecode = '1',descript = '1 Hydrapulper\, 1 Sydrapulper',descmemo = '',inst_date = '',rbld_date = '',capacity = 0.00,cap_type = ''\g insert into paperms set recno = 2,acctno = '006465',seq = '0020',typecode = '2',descript = '1 Waterous triple-flow broke',descmemo = '',inst_date = '',rbld_date = '',capacity = 0.00,cap_type = ''\g insert into paperms set recno = 3,acctno = '006465',seq = '0030',typecode = '3',descript = '4 Selectifier\, 2 Centriscreen',descmemo = '',inst_date = '',rbld_date = '',capacity = 0.00,cap_type = ''\g insert into paperms set recno = 4,acctno = '006465',seq = '0040',typecode = '4',descript = '2 Prefiner',descmemo = '',inst_date = '',rbld_date = '',capacity = 0.00,cap_type = ''\g insert into paperms set recno = 5,acctno = '006465',seq = '0050',typecode = '6',descript = '2 three stage Centricleaner system ((NL))',descmemo = '',inst_date = '',rbld_date = '',capacity = 0.00,cap_type = ''\g insert into paperms set recno = 6,acctno = '006466',seq = '0020',typecode = '1',descript = '2 Kennedy-Jones pulpmasters\, 1 Hydrapulper',descmemo = '',inst_date = '',rbld_date = '',capacity = 0.00,cap_type = ''\g insert into paperms set recno = 7,acctno = '006466',seq = '0030',typecode = '3',descript = '1 60NP primary\, 24P secondary\, Selectifier',descmemo = '',inst_date = '',rbld_date = '',capacity = 0.00,cap_type = ''\g insert into paperms set recno = 8,acctno = '006466',seq = '0040',typecode = '4',descript = '2 Lascopener broke deflakers',descmemo = '',inst_date = '',rbld_date = '',capacity = 0.00,cap_type = ''\g insert into paperms set recno = 9,acctno = '006468',seq = '0020',typecode = '1',descript = '2 Black Clawson Hydrapulper',descmemo = '',inst_date = '1945',rbld_date = '1985',capacity = 45.00,cap_type = 'MTPM'\g insert into paperms set recno = 10,acctno = '006468',seq = '0030',typecode = '3',descript = '',descmemo = '12 Selectifier\, 1 Radiscreen',inst_date = '',rbld_date = '',capacity = 0.00,cap_type = ''\g insert into paperms set recno = 11,acctno = '006468',seq = '0040',typecode = '4',descript = '3 Lascopener',descmemo = '',inst_date = '',rbld_date = '',capacity = 0.00,cap_type = ''\g insert into paperms set recno = 12,acctno = '006468',seq = '0045',typecode = '7',descript = '6 Valmet with magnetic meter proportioners',descmemo = '',inst_date = '',rbld_date = '',capacity = 0.00,cap_type = ''\g insert into paperms set recno = 13,acctno = '006469',seq = '0020',typecode = '1',descript = '1 Hydrapulper\, 3 12\' Fleck\, 1 Pulpmaster\, 1 Sydrapulper',descmemo = '',inst_date = '',rbld_date = '',capacity = 0.00,cap_type = ''\g insert into paperms set recno = 14,acctno = '006469',seq = '0030',typecode = '3',descript = '(in pulp mill)',descmemo = '',inst_date = '',rbld_date = '',capacity = 0.00,cap_type = ''\g insert into paperms set recno = 15,acctno = '006469',seq = '0040',typecode = '4',descript = '2-26\'\' Sprout Waldron Twin-Flo\, 2 Lascopeners.',descmemo = '',inst_date = '',rbld_date = '',capacity = 0.00,cap_type = ''\g insert into paperms set recno = 16,acctno = '006469',seq = '0060',typecode = '6',descript = '(in pulp mill)',descmemo = '',inst_date = '',rbld_date = '',capacity = 0.00,cap_type = ''\g insert into paperms set recno = 17,acctno = '006469',seq = '0065',typecode = '7',descript = '7 DeZurik\, 3 Kalle\, 2 Foxboro\, 6 viscosity tube',descmemo = '',inst_date = '',rbld_date = '',capacity = 0.00,cap_type = ''\g insert into paperms set recno = 18,acctno = '006469',seq = '0070',typecode = '8',descript = '13 magnetic flow meters',descmemo = '',inst_date = '',rbld_date = '',capacity = 0.00,cap_type = ''\g insert into paperms set recno = 19,acctno = '006469',seq = '0080',typecode = 'A',descript = '',descmemo = '1 D-O-L American 12-disc\, 1 D-O-L American 10-disc\, 1 8\'x14\' D-O-L drum',inst_date = '',rbld_date = '',capacity = 0.00,cap_type = ''\g insert into paperms set recno = 20,acctno = '006470',seq = '0010',typecode = '3',descript = '',descmemo = '1 60NP60 primary Selectifier\, 1 10A secondary CIR Centriscreen',inst_date = '',rbld_date = '',capacity = 0.00,cap_type = ''\g insert into paperms set recno = 21,acctno = '006470',seq = '0020',typecode = '4',descript = '',descmemo = '2 Sprout-Waldron Twin-flo. Dorr-Oliver-Long disc saveall. Kraft pulp slushing',inst_date = '',rbld_date = '',capacity = 0.00,cap_type = ''\g insert into paperms set recno = 22,acctno = '006472',seq = '0002',typecode = '1',descript = '4 broke',descmemo = '',inst_date = '',rbld_date = '',capacity = 0.00,cap_type = ''\g insert into paperms set recno = 23,acctno = '006472',seq = '0006',typecode = '3',descript = '5 primary\, 3 secondary Centriscreens',descmemo = '',inst_date = '',rbld_date = '',capacity = 0.00,cap_type = ''\g insert into paperms set recno = 24,acctno = '006472',seq = '0014',typecode = '6',descript = '3 five-stage Centricleaner systems',descmemo = '',inst_date = '',rbld_date = '',capacity = 0.00,cap_type = ''\g insert into paperms set recno = 25,acctno = '006472',seq = '0030',typecode = '1',descript = '2 Hymac bale',descmemo = '',inst_date = '',rbld_date = '',capacity = 0.00,cap_type = ''\g insert into paperms set recno = 26,acctno = '006472',seq = '0060',typecode = '4',descript = '4 Twin-Flo Sprout Bauer',descmemo = '',inst_date = '',rbld_date = '',capacity = 0.00,cap_type = ''\g insert into paperms set recno = 27,acctno = '006472',seq = '0080',typecode = 'B',descript = '',descmemo = '1 300 ton bale storage\, 1 electric lift truck\, 1 bale feeding conveyor system\, sparger car clay unloading system with storage tank\, retention aid system\, color system',inst_date = '',rbld_date = '',capacity = 0.00,cap_type = ''\g insert into paperms set recno = 28,acctno = '006474',seq = '0010',typecode = '1',descript = '2 Hydrapulper (for semibl kraft)',descmemo = '',inst_date = '',rbld_date = '',capacity = 0.00,cap_type = ''\g insert into paperms set recno = 29,acctno = '006474',seq = '0020',typecode = '4',descript = '3 Sprout Waldron Twin-34',descmemo = '',inst_date = '',rbld_date = '',capacity = 0.00,cap_type = ''\g insert into paperms set recno = 30,acctno = '006474',seq = '0030',typecode = '7',descript = '',descmemo = '1 Kalle\, 3 DeZurik\, 1 Valmet\, 8 Eur Control\, 7 magnetic flowmeters',inst_date = '',rbld_date = '',capacity = 0.00,cap_type = ''\g insert into paperms set recno = 31,acctno = '006474',seq = '0040',typecode = 'A',descript = '2 Sherbrooke kraft stock washers',descmemo = '',inst_date = '',rbld_date = '',capacity = 0.00,cap_type = ''\g insert into paperms set recno = 32,acctno = '006476',seq = '0010',typecode = '1',descript = '1 Jones repulper',descmemo = '',inst_date = '',rbld_date = '',capacity = 0.00,cap_type = ''\g insert into paperms set recno = 33,acctno = '006476',seq = '0020',typecode = '4',descript = '3 Bauer\, 2 Sprout-Waldron pump-thru',descmemo = '',inst_date = '',rbld_date = '',capacity = 0.00,cap_type = ''\g insert into paperms set recno = 34,acctno = '006478',seq = '0010',typecode = '1',descript = '2 3000 lb Jones Shark',descmemo = '',inst_date = '',rbld_date = '',capacity = 0.00,cap_type = ''\g insert into paperms set recno = 35,acctno = '006478',seq = '0020',typecode = '4',descript = '2',descmemo = '',inst_date = '',rbld_date = '',capacity = 0.00,cap_type = ''\g insert into paperms set recno = 36,acctno = '006479',seq = '0010',typecode = '1',descript = '2 2000 lb',descmemo = '',inst_date = '',rbld_date = '',capacity = 0.00,cap_type = ''\g insert into paperms set recno = 37,acctno = '006479',seq = '0020',typecode = '4',descript = '2 disc\, 3 Conical',descmemo = '',inst_date = '',rbld_date = '',capacity = 0.00,cap_type = ''\g insert into paperms set recno = 38,acctno = '006481',seq = '0020',typecode = '1',descript = '1 Jones Shark',descmemo = '',inst_date = '',rbld_date = '',capacity = 0.00,cap_type = ''\g insert into paperms set recno = 39,acctno = '006481',seq = '0030',typecode = '5',descript = '2 Emerson',descmemo = '',inst_date = '',rbld_date = '',capacity = 0.00,cap_type = ''\g insert into paperms set recno = 40,acctno = '006481',seq = '0035',typecode = '7',descript = '2 DeZurik',descmemo = '',inst_date = '',rbld_date = '',capacity = 0.00,cap_type = ''\g insert into paperms set recno = 41,acctno = '006481',seq = '0040',typecode = 'B',descript = '1 thickener',descmemo = '',inst_date = '',rbld_date = '',capacity = 0.00,cap_type = ''\g insert into paperms set recno = 42,acctno = '006483',seq = '0010',typecode = '4',descript = '1 on SBK',descmemo = '',inst_date = '',rbld_date = '',capacity = 0.00,cap_type = ''\g insert into paperms set recno = 43,acctno = '006483',seq = '0020',typecode = '6',descript = 'Hymac',descmemo = '',inst_date = '',rbld_date = '',capacity = 0.00,cap_type = ''\g insert into paperms set recno = 44,acctno = '006487',seq = '0010',typecode = '1',descript = '1 Voith',descmemo = '',inst_date = '',rbld_date = '',capacity = 0.00,cap_type = ''\g insert into paperms set recno = 45,acctno = '006487',seq = '0045',typecode = '3',descript = 'three-stage Voith',descmemo = '',inst_date = '',rbld_date = '',capacity = 0.00,cap_type = ''\g insert into paperms set recno = 46,acctno = '006487',seq = '0040',typecode = '6',descript = 'five-stage Celleco',descmemo = '',inst_date = '',rbld_date = '',capacity = 0.00,cap_type = ''\g insert into paperms set recno = 47,acctno = '006487',seq = '0050',typecode = 'A',descript = '',descmemo = '1 Celleco broke; 2 Dorr-Oliver savealls\, D-O sidehill screen thickeners',inst_date = '',rbld_date = '',capacity = 0.00,cap_type = ''\g insert into paperms set recno = 48,acctno = '006490',seq = '0010',typecode = '1',descript = '1 Hydrapulper',descmemo = '',inst_date = '',rbld_date = '',capacity = 0.00,cap_type = ''\g insert into paperms set recno = 49,acctno = '006492',seq = '0010',typecode = '1',descript = '3',descmemo = '',inst_date = '',rbld_date = '',capacity = 0.00,cap_type = ''\g insert into paperms set recno = 50,acctno = '006492',seq = '0020',typecode = '4',descript = '1 Sprout Waldron',descmemo = '',inst_date = '',rbld_date = '',capacity = 0.00,cap_type = ''\g insert into paperms set recno = 51,acctno = '006492',seq = '0030',typecode = '5',descript = '3',descmemo = '',inst_date = '',rbld_date = '',capacity = 0.00,cap_type = ''\g insert into paperms set recno = 52,acctno = '006493',seq = '0010',typecode = '1',descript = '6',descmemo = '',inst_date = '',rbld_date = '',capacity = 0.00,cap_type = ''\g insert into paperms set recno = 53,acctno = '006493',seq = '0020',typecode = '3',descript = '6',descmemo = '',inst_date = '',rbld_date = '',capacity = 0.00,cap_type = ''\g insert into paperms set recno = 54,acctno = '006493',seq = '0030',typecode = '4',descript = '11',descmemo = '',inst_date = '',rbld_date = '',capacity = 0.00,cap_type = ''\g insert into paperms set recno = 55,acctno = '006494',seq = '0020',typecode = '1',descript = '',descmemo = '2 10\,000 lb Black Clawson\, 1-10\,000 lb Beloit Hi-Consistency\, 1-4000 lb Jones\, 1-2000 lb Shartle',inst_date = '',rbld_date = '',capacity = 0.00,cap_type = ''\g insert into paperms set recno = 56,acctno = '006494',seq = '0030',typecode = '3',descript = '',descmemo = '2 Jonsson\, 1 Black Clawson V-100\, 1 Shartle\, 1 Beloit Model B\, 1 Beloit Screenmaster',inst_date = '',rbld_date = '',capacity = 0.00,cap_type = ''\g insert into paperms set recno = 57,acctno = '006494',seq = '0040',typecode = '4',descript = '1 disc Jones',descmemo = '',inst_date = '',rbld_date = '',capacity = 0.00,cap_type = ''\g insert into paperms set recno = 58,acctno = '006494',seq = '0050',typecode = '6',descript = 'Beloit Posiflow system',descmemo = '',inst_date = '',rbld_date = '',capacity = 0.00,cap_type = ''\g insert into paperms set recno = 59,acctno = '006494',seq = '0060',typecode = '7',descript = '1 DeZurik\, 1 Bird\, 1 other',descmemo = '',inst_date = '',rbld_date = '',capacity = 0.00,cap_type = ''\g insert into paperms set recno = 60,acctno = '006495',seq = '0010',typecode = '1',descript = '1',descmemo = '',inst_date = '',rbld_date = '',capacity = 0.00,cap_type = ''\g insert into paperms set recno = 61,acctno = '006495',seq = '0020',typecode = '3',descript = '3',descmemo = '',inst_date = '',rbld_date = '',capacity = 0.00,cap_type = ''\g insert into paperms set recno = 62,acctno = '006495',seq = '0030',typecode = '4',descript = '1',descmemo = '',inst_date = '',rbld_date = '',capacity = 0.00,cap_type = ''\g insert into paperms set recno = 63,acctno = '006495',seq = '0040',typecode = '5',descript = '1',descmemo = '',inst_date = '',rbld_date = '',capacity = 0.00,cap_type = ''\g insert into paperms set recno = 64,acctno = '006497',seq = '0010',typecode = '1',descript = '2',descmemo = '',inst_date = '',rbld_date = '',capacity = 0.00,cap_type = ''\g insert into paperms set recno = 65,acctno = '006497',seq = '0020',typecode = '4',descript = '3 disc\, 1 deflaker',descmemo = '',inst_date = '',rbld_date = '',capacity = 0.00,cap_type = ''\g insert into paperms set recno = 66,acctno = '006499',seq = '0010',typecode = '1',descript = '6\, 2 broke',descmemo = '',inst_date = '',rbld_date = '',capacity = 0.00,cap_type = ''\g insert into paperms set recno = 67,acctno = '006499',seq = '0020',typecode = '4',descript = '',descmemo = '13\, 2 deflakers',inst_date = '',rbld_date = '',capacity = 0.00,cap_type = ''\g insert into paperms set recno = 68,acctno = '006499',seq = '0030',typecode = '5',descript = '4',descmemo = '',inst_date = '',rbld_date = '',capacity = 0.00,cap_type = ''\g insert into paperms set recno = 69,acctno = '006499',seq = '0040',typecode = '8',descript = '5 continuous systems',descmemo = '',inst_date = '',rbld_date = '',capacity = 0.00,cap_type = ''\g insert into paperms set recno = 70,acctno = '006500',seq = '0010',typecode = '1',descript = '4',descmemo = '',inst_date = '',rbld_date = '',capacity = 0.00,cap_type = ''\g insert into paperms set recno = 71,acctno = '006500',seq = '0020',typecode = '4',descript = '5',descmemo = '',inst_date = '',rbld_date = '',capacity = 0.00,cap_type = ''\g insert into paperms set recno = 72,acctno = '006500',seq = '0030',typecode = '5',descript = '6',descmemo = '',inst_date = '',rbld_date = '',capacity = 0.00,cap_type = ''\g insert into paperms set recno = 73,acctno = '006501',seq = '0010',typecode = '1',descript = '1 Hi-Lo\, 1 Dynapulper',descmemo = '',inst_date = '',rbld_date = '',capacity = 0.00,cap_type = ''\g insert into paperms set recno = 74,acctno = '006501',seq = '0020',typecode = '4',descript = '4 Jones DD\, 1 Bauer',descmemo = '',inst_date = '',rbld_date = '',capacity = 0.00,cap_type = ''\g insert into paperms set recno = 75,acctno = '006501',seq = '0030',typecode = '5',descript = '6 Fibremaster',descmemo = '',inst_date = '',rbld_date = '',capacity = 0.00,cap_type = ''\g insert into paperms set recno = 76,acctno = '006506',seq = '0010',typecode = '1',descript = '1-3000 lb\, 1-4000 lb',descmemo = '',inst_date = '',rbld_date = '',capacity = 0.00,cap_type = ''\g insert into paperms set recno = 77,acctno = '006506',seq = '0020',typecode = '3',descript = '3',descmemo = '',inst_date = '',rbld_date = '',capacity = 0.00,cap_type = ''\g insert into paperms set recno = 78,acctno = '006506',seq = '0030',typecode = '4',descript = '1 disc\, 2 conical',descmemo = '',inst_date = '',rbld_date = '',capacity = 0.00,cap_type = ''\g insert into paperms set recno = 79,acctno = '006506',seq = '0040',typecode = '5',descript = '1',descmemo = '',inst_date = '',rbld_date = '',capacity = 0.00,cap_type = ''\g insert into paperms set recno = 80,acctno = '006506',seq = '0050',typecode = '6',descript = 'Vorjects\, Bird Cycleans',descmemo = '',inst_date = '',rbld_date = '',capacity = 0.00,cap_type = ''\g insert into paperms set recno = 81,acctno = '006508',seq = '0010',typecode = '1',descript = '3 continuous\, 1 broke',descmemo = '',inst_date = '',rbld_date = '',capacity = 0.00,cap_type = ''\g insert into paperms set recno = 82,acctno = '006508',seq = '0020',typecode = '3',descript = '4 Beloit S',descmemo = '',inst_date = '',rbld_date = '',capacity = 0.00,cap_type = ''\g insert into paperms set recno = 83,acctno = '006508',seq = '0030',typecode = '4',descript = '7 disc',descmemo = '',inst_date = '',rbld_date = '',capacity = 0.00,cap_type = ''\g insert into paperms set recno = 84,acctno = '006508',seq = '0040',typecode = '6',descript = '',descmemo = '9 high density\, Celleco three-stage reverse',inst_date = '',rbld_date = '',capacity = 0.00,cap_type = ''\g insert into paperms set recno = 85,acctno = '006508',seq = '0050',typecode = '9',descript = '1',descmemo = '',inst_date = '',rbld_date = '',capacity = 0.00,cap_type = ''\g insert into paperms set recno = 86,acctno = '006508',seq = '0060',typecode = 'B',descript = '2 Turboseparators\, 1 Scavenger',descmemo = '',inst_date = '',rbld_date = '',capacity = 0.00,cap_type = ''\g insert into paperms set recno = 87,acctno = '006510',seq = '0010',typecode = '1',descript = '1 Hydrapulper',descmemo = '',inst_date = '',rbld_date = '',capacity = 0.00,cap_type = ''\g insert into paperms set recno = 88,acctno = '006510',seq = '0020',typecode = '3',descript = '1 Selectifier',descmemo = '',inst_date = '',rbld_date = '',capacity = 0.00,cap_type = ''\g insert into paperms set recno = 89,acctno = '006510',seq = '0030',typecode = '4',descript = '1 Am Defibrator\, 1 Claflin\, 1 Bauer',descmemo = '',inst_date = '',rbld_date = '',capacity = 0.00,cap_type = ''\g insert into paperms set recno = 90,acctno = '006510',seq = '0040',typecode = 'B',descript = '2 hammermills',descmemo = '',inst_date = '',rbld_date = '',capacity = 0.00,cap_type = ''\g insert into paperms set recno = 91,acctno = '006512',seq = '0010',typecode = '1',descript = '1 Hymac baled kraft with Sunds-Defibrator conveyor',descmemo = '',inst_date = '',rbld_date = '',capacity = 0.00,cap_type = ''\g insert into paperms set recno = 92,acctno = '006512',seq = '0015',typecode = '4',descript = '2 Sprout Waldron Twin-Flo on kraft\, 2 broke Deflakers',descmemo = '',inst_date = '',rbld_date = '',capacity = 0.00,cap_type = ''\g insert into paperms set recno = 93,acctno = '006512',seq = '0020',typecode = '3',descript = '6 Hymac/Jylha pressure\, 2 Jonsson vibrating flat',descmemo = '',inst_date = '',rbld_date = '',capacity = 0.00,cap_type = ''\g insert into paperms set recno = 94,acctno = '006512',seq = '0040',typecode = '6',descript = '',descmemo = '1 Bauer Centricleaner-Deculator system\, 1 Celleco five-stage Cleanpac 350 system with receiver. Savealls: 2 Dorr Oliver disc. 2 Honeywell TDC 2000 process control systems',inst_date = '',rbld_date = '',capacity = 0.00,cap_type = ''\g insert into paperms set recno = 95,acctno = '006513',seq = '0010',typecode = '1',descript = '7',descmemo = '',inst_date = '',rbld_date = '',capacity = 0.00,cap_type = ''\g insert into paperms set recno = 96,acctno = '006513',seq = '0020',typecode = '3',descript = '24 pressure',descmemo = '',inst_date = '',rbld_date = '',capacity = 0.00,cap_type = ''\g insert into paperms set recno = 97,acctno = '006513',seq = '0030',typecode = '4',descript = '8',descmemo = '',inst_date = '',rbld_date = '',capacity = 0.00,cap_type = ''\g insert into paperms set recno = 98,acctno = '006514',seq = '0010',typecode = '1',descript = '1 13\,000 lb Black Clawson; 2 7500 lb Beloit',descmemo = '',inst_date = '',rbld_date = '',capacity = 0.00,cap_type = ''\g insert into paperms set recno = 99,acctno = '006514',seq = '0030',typecode = '3',descript = '2 Selectifier',descmemo = '',inst_date = '',rbld_date = '',capacity = 0.00,cap_type = ''\g insert into paperms set recno = 100,acctno = '006514',seq = '0040',typecode = '4',descript = '',descmemo = '4 26\'\' and 4 20\'\' Sprout Waldron',inst_date = '',rbld_date = '',capacity = 0.00,cap_type = ''\g insert into paperms set recno = 101,acctno = '006515',seq = '0010',typecode = '1',descript = '4',descmemo = '',inst_date = '',rbld_date = '',capacity = 0.00,cap_type = ''\g insert into paperms set recno = 102,acctno = '006515',seq = '0020',typecode = '3',descript = '2 Selectifier',descmemo = '',inst_date = '',rbld_date = '',capacity = 0.00,cap_type = ''\g insert into paperms set recno = 103,acctno = '006515',seq = '0030',typecode = '4',descript = '5 disc',descmemo = '',inst_date = '',rbld_date = '',capacity = 0.00,cap_type = ''\g insert into paperms set recno = 104,acctno = '006515',seq = '0040',typecode = '5',descript = '2',descmemo = '',inst_date = '',rbld_date = '',capacity = 0.00,cap_type = ''\g insert into paperms set recno = 105,acctno = '006516',seq = '0010',typecode = '1',descript = '2',descmemo = '',inst_date = '',rbld_date = '',capacity = 0.00,cap_type = ''\g insert into paperms set recno = 106,acctno = '006516',seq = '0020',typecode = '2',descript = 'Shartle Hydrabeater',descmemo = '',inst_date = '',rbld_date = '',capacity = 0.00,cap_type = ''\g insert into paperms set recno = 107,acctno = '006516',seq = '0030',typecode = '3',descript = '5',descmemo = '',inst_date = '',rbld_date = '',capacity = 0.00,cap_type = ''\g insert into paperms set recno = 108,acctno = '006516',seq = '0040',typecode = '4',descript = '1 Shartle disc',descmemo = '',inst_date = '',rbld_date = '',capacity = 0.00,cap_type = ''\g insert into paperms set recno = 109,acctno = '006516',seq = '0050',typecode = '5',descript = '4 Miami',descmemo = '',inst_date = '',rbld_date = '',capacity = 0.00,cap_type = ''\g insert into paperms set recno = 110,acctno = '006519',seq = '0030',typecode = '6',descript = '1 300-body Centricleaner-Deculator system',descmemo = '',inst_date = '',rbld_date = '',capacity = 0.00,cap_type = ''\g insert into paperms set recno = 111,acctno = '006519',seq = '0040',typecode = '3',descript = '1 Bird. Savealls: 2 Impco disc filter',descmemo = '',inst_date = '',rbld_date = '',capacity = 0.00,cap_type = ''\g insert into paperms set recno = 112,acctno = '006520',seq = '0010',typecode = '1',descript = '1-20\'\, 1-18\'\, 1-16\'\, 1-15\' Hydrapulpers',descmemo = '',inst_date = '',rbld_date = '',capacity = 0.00,cap_type = ''\g insert into paperms set recno = 113,acctno = '006520',seq = '0020',typecode = '3',descript = '10 Selectifier',descmemo = '',inst_date = '',rbld_date = '',capacity = 0.00,cap_type = ''\g insert into paperms set recno = 114,acctno = '006520',seq = '0030',typecode = '4',descript = '5 26\'\' Sprout Waldron',descmemo = '',inst_date = '',rbld_date = '',capacity = 0.00,cap_type = ''\g insert into paperms set recno = 115,acctno = '006520',seq = '0040',typecode = '',descript = '',descmemo = 'Scavengers: 2 Fibreprep',inst_date = '',rbld_date = '',capacity = 0.00,cap_type = ''\g insert into paperms set recno = 116,acctno = '006520',seq = '0050',typecode = '',descript = '',descmemo = 'Thickeners: Hydrasieves',inst_date = '',rbld_date = '',capacity = 0.00,cap_type = ''\g insert into paperms set recno = 117,acctno = '006521',seq = '0010',typecode = '1',descript = '5 Hydrapulpers',descmemo = '',inst_date = '',rbld_date = '',capacity = 0.00,cap_type = ''\g insert into paperms set recno = 118,acctno = '006521',seq = '0020',typecode = '4',descript = '9 Sprout disc',descmemo = '',inst_date = '',rbld_date = '',capacity = 0.00,cap_type = ''\g insert into paperms set recno = 119,acctno = '006523',seq = '0010',typecode = '1',descript = '1-9\'\, 1-11\'',descmemo = '',inst_date = '',rbld_date = '',capacity = 0.00,cap_type = ''\g insert into paperms set recno = 120,acctno = '006523',seq = '0020',typecode = '4',descript = '2 disc',descmemo = '',inst_date = '',rbld_date = '',capacity = 0.00,cap_type = ''\g insert into paperms set recno = 121,acctno = '006524',seq = '0010',typecode = '1',descript = '1 2000 lb Dualator',descmemo = '',inst_date = '',rbld_date = '',capacity = 0.00,cap_type = ''\g insert into paperms set recno = 122,acctno = '006524',seq = '0020',typecode = '2',descript = '6 2200 lb.',descmemo = '',inst_date = '',rbld_date = '',capacity = 0.00,cap_type = ''\g insert into paperms set recno = 123,acctno = '006524',seq = '0030',typecode = '4',descript = '1 Hydrafiner',descmemo = '',inst_date = '',rbld_date = '',capacity = 0.00,cap_type = ''\g insert into paperms set recno = 124,acctno = '006524',seq = '0040',typecode = '5',descript = '4',descmemo = '',inst_date = '',rbld_date = '',capacity = 0.00,cap_type = ''\g insert into paperms set recno = 125,acctno = '006524',seq = '0050',typecode = '6',descript = '1 Escher Wyss stock system',descmemo = '',inst_date = '',rbld_date = '',capacity = 0.00,cap_type = ''\g insert into paperms set recno = 126,acctno = '006525',seq = '0010',typecode = '1',descript = '1',descmemo = '',inst_date = '',rbld_date = '',capacity = 0.00,cap_type = ''\g insert into paperms set recno = 127,acctno = '006525',seq = '0020',typecode = '2',descript = '2',descmemo = '',inst_date = '',rbld_date = '',capacity = 0.00,cap_type = ''\g insert into paperms set recno = 128,acctno = '006525',seq = '0030',typecode = '5',descript = '3',descmemo = '',inst_date = '',rbld_date = '',capacity = 0.00,cap_type = ''\g insert into paperms set recno = 129,acctno = '006527',seq = '0010',typecode = '1',descript = '',descmemo = '1 12\,000 lb for purchased kraft pulp\, 1 6000 lb for recycled pulp',inst_date = '',rbld_date = '',capacity = 0.00,cap_type = ''\g insert into paperms set recno = 130,acctno = '006527',seq = '0020',typecode = '4',descript = '2 Jones\, 1 Bauer\, 2 Sprout Waldron mixed stock',descmemo = '',inst_date = '',rbld_date = '',capacity = 0.00,cap_type = ''\g insert into paperms set recno = 131,acctno = '006527',seq = '0030',typecode = '5',descript = '3 Jones.',descmemo = '',inst_date = '',rbld_date = '',capacity = 0.00,cap_type = ''\g insert into paperms set recno = 132,acctno = '006529',seq = '0010',typecode = '1',descript = '4 Hydrapulpers',descmemo = '',inst_date = '',rbld_date = '',capacity = 0.00,cap_type = ''\g insert into paperms set recno = 133,acctno = '006529',seq = '0020',typecode = '3',descript = '5 Centriscreens',descmemo = '',inst_date = '',rbld_date = '',capacity = 0.00,cap_type = ''\g insert into paperms set recno = 134,acctno = '006529',seq = '0030',typecode = '4',descript = '6 Sprout Waldron disc',descmemo = '',inst_date = '',rbld_date = '',capacity = 0.00,cap_type = ''\g insert into paperms set recno = 135,acctno = '006530',seq = '0010',typecode = '1',descript = '2',descmemo = '',inst_date = '',rbld_date = '',capacity = 0.00,cap_type = ''\g insert into paperms set recno = 136,acctno = '006530',seq = '0020',typecode = '4',descript = '5',descmemo = '',inst_date = '',rbld_date = '',capacity = 0.00,cap_type = ''\g insert into paperms set recno = 137,acctno = '006532',seq = '0010',typecode = '1',descript = '2 Black Clawson Sydrapulper broke',descmemo = '',inst_date = '',rbld_date = '',capacity = 0.00,cap_type = ''\g insert into paperms set recno = 138,acctno = '006532',seq = '0020',typecode = '3',descript = '1 Bird Centriscreen',descmemo = '',inst_date = '',rbld_date = '',capacity = 0.00,cap_type = ''\g insert into paperms set recno = 139,acctno = '006532',seq = '0030',typecode = '4',descript = '6 Jones double disc',descmemo = '',inst_date = '',rbld_date = '',capacity = 0.00,cap_type = ''\g insert into paperms set recno = 140,acctno = '006532',seq = '0040',typecode = '6',descript = 'Centricleaners\, with Deculator',descmemo = '',inst_date = '',rbld_date = '',capacity = 0.00,cap_type = ''\g insert into paperms set recno = 141,acctno = '006533',seq = '0010',typecode = '1',descript = '4',descmemo = '',inst_date = '',rbld_date = '',capacity = 0.00,cap_type = ''\g insert into paperms set recno = 142,acctno = '006533',seq = '0020',typecode = '4',descript = '3',descmemo = '',inst_date = '',rbld_date = '',capacity = 0.00,cap_type = ''\g insert into paperms set recno = 143,acctno = '006535',seq = '0010',typecode = '1',descript = '3 Hydrapulper',descmemo = '',inst_date = '',rbld_date = '',capacity = 0.00,cap_type = ''\g insert into paperms set recno = 144,acctno = '006535',seq = '0020',typecode = '4',descript = '',descmemo = '14-30\'\'\, 1-34\'\'\, 1-36\'\'\, 1-38\'\'\, 1-40\'\' Beloit Jones disc; 1-30\'\'\, 1-38\'\' Sprout Waldron disc; 1 Jones disc; 4 Emerson\, 4 deflakers',inst_date = '',rbld_date = '',capacity = 0.00,cap_type = ''\g insert into paperms set recno = 145,acctno = '006536',seq = '0010',typecode = '1',descript = '1-14\' Hydrapulper',descmemo = '',inst_date = '',rbld_date = '',capacity = 0.00,cap_type = ''\g insert into paperms set recno = 146,acctno = '006536',seq = '0030',typecode = '3',descript = '5 centrifugal',descmemo = '',inst_date = '',rbld_date = '',capacity = 0.00,cap_type = ''\g insert into paperms set recno = 147,acctno = '006536',seq = '0050',typecode = '6',descript = 'Centricleaners',descmemo = '',inst_date = '',rbld_date = '',capacity = 0.00,cap_type = ''\g insert into paperms set recno = 148,acctno = '006537',seq = '0010',typecode = '1',descript = '3',descmemo = '',inst_date = '',rbld_date = '',capacity = 0.00,cap_type = ''\g insert into paperms set recno = 149,acctno = '006537',seq = '0020',typecode = '3',descript = '9',descmemo = '',inst_date = '',rbld_date = '',capacity = 0.00,cap_type = ''\g insert into paperms set recno = 150,acctno = '006537',seq = '0030',typecode = '4',descript = '9',descmemo = '',inst_date = '',rbld_date = '',capacity = 0.00,cap_type = ''\g insert into paperms set recno = 151,acctno = '006537',seq = '0040',typecode = '5',descript = '1',descmemo = '',inst_date = '',rbld_date = '',capacity = 0.00,cap_type = ''\g insert into paperms set recno = 152,acctno = '006537',seq = '0050',typecode = '6',descript = 'Krebs\, Hymac\, Beloit (idle)',descmemo = '',inst_date = '',rbld_date = '',capacity = 0.00,cap_type = ''\g insert into paperms set recno = 153,acctno = '006538',seq = '0010',typecode = '1',descript = '5',descmemo = '',inst_date = '',rbld_date = '',capacity = 0.00,cap_type = ''\g insert into paperms set recno = 154,acctno = '006538',seq = '0020',typecode = '3',descript = '1 Black Clawson',descmemo = '',inst_date = '',rbld_date = '',capacity = 0.00,cap_type = ''\g insert into paperms set recno = 155,acctno = '006538',seq = '0030',typecode = '4',descript = '2\, 3 Sprout-Waldron\, 2 Raffinator',descmemo = '',inst_date = '',rbld_date = '',capacity = 0.00,cap_type = ''\g insert into paperms set recno = 156,acctno = '006539',seq = '0010',typecode = '1',descript = '16',descmemo = '',inst_date = '',rbld_date = '',capacity = 0.00,cap_type = ''\g insert into paperms set recno = 157,acctno = '006539',seq = '0020',typecode = '4',descript = '14',descmemo = '',inst_date = '',rbld_date = '',capacity = 0.00,cap_type = ''\g insert into paperms set recno = 158,acctno = '006540',seq = '0010',typecode = '1',descript = '3 Jones Shark',descmemo = '',inst_date = '',rbld_date = '',capacity = 0.00,cap_type = ''\g insert into paperms set recno = 159,acctno = '006540',seq = '0020',typecode = '3',descript = '11',descmemo = '',inst_date = '',rbld_date = '',capacity = 0.00,cap_type = ''\g insert into paperms set recno = 160,acctno = '006540',seq = '0030',typecode = '4',descript = '11 Jones',descmemo = '',inst_date = '',rbld_date = '',capacity = 0.00,cap_type = ''\g insert into paperms set recno = 161,acctno = '006540',seq = '0040',typecode = '6',descript = 'Bauer Centricleaners with Deculator',descmemo = '',inst_date = '',rbld_date = '',capacity = 0.00,cap_type = ''\g insert into paperms set recno = 162,acctno = '006540',seq = '0050',typecode = '',descript = 'Impco\, Jones savealls ((NL))',descmemo = '',inst_date = '',rbld_date = '',capacity = 0.00,cap_type = ''\g insert into paperms set recno = 163,acctno = '006542',seq = '0010',typecode = '4',descript = '10 Sprout Waldron',descmemo = '',inst_date = '',rbld_date = '',capacity = 0.00,cap_type = ''\g insert into paperms set recno = 164,acctno = '006543',seq = '0010',typecode = '3',descript = '18 stock\, 5 reject',descmemo = '',inst_date = '',rbld_date = '',capacity = 0.00,cap_type = ''\g insert into paperms set recno = 165,acctno = '006543',seq = '0020',typecode = '4',descript = '5',descmemo = '',inst_date = '',rbld_date = '',capacity = 0.00,cap_type = ''\g insert into paperms set recno = 166,acctno = '006543',seq = '0030',typecode = '6',descript = '5 Deculator-Centricleaner system',descmemo = '',inst_date = '',rbld_date = '',capacity = 0.00,cap_type = ''\g insert into paperms set recno = 167,acctno = '006544',seq = '0010',typecode = '2',descript = '2 Hydrapulpers\, Black Clawson',descmemo = '',inst_date = '',rbld_date = '',capacity = 0.00,cap_type = ''\g insert into paperms set recno = 168,acctno = '006544',seq = '0020',typecode = '3',descript = '6 Centriscreen\, 2 Selectifier',descmemo = '',inst_date = '',rbld_date = '',capacity = 0.00,cap_type = ''\g insert into paperms set recno = 169,acctno = '006544',seq = '0030',typecode = '4',descript = '2 Lascopeners on broke',descmemo = '',inst_date = '',rbld_date = '',capacity = 0.00,cap_type = ''\g insert into paperms set recno = 170,acctno = '006544',seq = '0040',typecode = '6',descript = 'Bauer 623 with 2 Deculators',descmemo = '',inst_date = '',rbld_date = '',capacity = 0.00,cap_type = ''\g insert into paperms set recno = 171,acctno = '006544',seq = '0050',typecode = '8',descript = 'Black Clawson agitators',descmemo = '',inst_date = '',rbld_date = '',capacity = 0.00,cap_type = ''\g insert into paperms set recno = 172,acctno = '006544',seq = '0060',typecode = 'A',descript = '2 Dorr-Oliver Savealls\, 1 D-O disc thickener for broke',descmemo = '',inst_date = '',rbld_date = '',capacity = 0.00,cap_type = ''\g insert into paperms set recno = 173,acctno = '006545',seq = '0010',typecode = '1',descript = '2 Turboflex',descmemo = '',inst_date = '',rbld_date = '',capacity = 0.00,cap_type = ''\g insert into paperms set recno = 174,acctno = '006545',seq = '0020',typecode = '3',descript = '7',descmemo = '',inst_date = '',rbld_date = '',capacity = 0.00,cap_type = ''\g insert into paperms set recno = 175,acctno = '006545',seq = '0030',typecode = '4',descript = '1 Sprout Waldron\, 3 Defibrator',descmemo = '',inst_date = '',rbld_date = '',capacity = 0.00,cap_type = ''\g insert into paperms set recno = 176,acctno = '006545',seq = '0040',typecode = '5',descript = '6 Black Clawson',descmemo = '',inst_date = '',rbld_date = '',capacity = 0.00,cap_type = ''\g insert into paperms set recno = 177,acctno = '006547',seq = '0010',typecode = '1',descript = '2',descmemo = '',inst_date = '',rbld_date = '',capacity = 0.00,cap_type = ''\g insert into paperms set recno = 178,acctno = '006547',seq = '0020',typecode = '4',descript = '1 20\'\'\, 1 26\'\' Sprout Waldron Twin-Flo',descmemo = '',inst_date = '',rbld_date = '',capacity = 0.00,cap_type = ''\g insert into paperms set recno = 179,acctno = '006548',seq = '0010',typecode = '1',descript = '2 continuous',descmemo = '',inst_date = '',rbld_date = '',capacity = 0.00,cap_type = ''\g insert into paperms set recno = 180,acctno = '006548',seq = '0020',typecode = '4',descript = '2 Sprout Waldron',descmemo = '',inst_date = '',rbld_date = '',capacity = 0.00,cap_type = ''\g insert into paperms set recno = 181,acctno = '006549',seq = '0010',typecode = '1',descript = '1',descmemo = '',inst_date = '',rbld_date = '',capacity = 0.00,cap_type = ''\g insert into paperms set recno = 182,acctno = '006549',seq = '0020',typecode = '2',descript = '1 2000 lb',descmemo = '',inst_date = '',rbld_date = '',capacity = 0.00,cap_type = ''\g insert into paperms set recno = 183,acctno = '006549',seq = '0030',typecode = '4',descript = '2',descmemo = '',inst_date = '',rbld_date = '',capacity = 0.00,cap_type = ''\g insert into paperms set recno = 184,acctno = '006551',seq = '0010',typecode = '1',descript = '2',descmemo = '',inst_date = '',rbld_date = '',capacity = 0.00,cap_type = ''\g insert into paperms set recno = 185,acctno = '006551',seq = '0020',typecode = '3',descript = '6 Selectifier\, 2 Jonsson',descmemo = '',inst_date = '',rbld_date = '',capacity = 0.00,cap_type = ''\g insert into paperms set recno = 186,acctno = '006551',seq = '0030',typecode = '5',descript = '3 Jones',descmemo = '',inst_date = '',rbld_date = '',capacity = 0.00,cap_type = ''\g insert into paperms set recno = 187,acctno = '006552',seq = '0010',typecode = '5',descript = '9',descmemo = '',inst_date = '',rbld_date = '',capacity = 0.00,cap_type = ''\g insert into paperms set recno = 188,acctno = '006554',seq = '0010',typecode = '1',descript = '2 Hydrapulpers',descmemo = '',inst_date = '',rbld_date = '',capacity = 0.00,cap_type = ''\g insert into paperms set recno = 189,acctno = '006554',seq = '0020',typecode = '3',descript = '6 Selectifier\, 1 Wandell',descmemo = '',inst_date = '',rbld_date = '',capacity = 0.00,cap_type = ''\g insert into paperms set recno = 190,acctno = '006554',seq = '0030',typecode = '4',descript = '2-34\'\'\, 2-20\'\' disc',descmemo = '',inst_date = '',rbld_date = '',capacity = 0.00,cap_type = ''\g insert into paperms set recno = 191,acctno = '006555',seq = '0010',typecode = '4',descript = '1',descmemo = '',inst_date = '',rbld_date = '',capacity = 0.00,cap_type = ''\g insert into paperms set recno = 192,acctno = '006555',seq = '0020',typecode = '5',descript = '6',descmemo = '',inst_date = '',rbld_date = '',capacity = 0.00,cap_type = ''\g insert into paperms set recno = 193,acctno = '006557',seq = '0010',typecode = '1',descript = '2 2000 lb.',descmemo = '',inst_date = '',rbld_date = '',capacity = 0.00,cap_type = ''\g insert into paperms set recno = 194,acctno = '006557',seq = '0020',typecode = '4',descript = '4',descmemo = '',inst_date = '',rbld_date = '',capacity = 0.00,cap_type = ''\g insert into paperms set recno = 195,acctno = '006558',seq = '0010',typecode = '1',descript = '2 2000 lb',descmemo = '',inst_date = '',rbld_date = '',capacity = 0.00,cap_type = ''\g insert into paperms set recno = 196,acctno = '006558',seq = '0020',typecode = '4',descript = '2 #101 Claflin',descmemo = '',inst_date = '',rbld_date = '',capacity = 0.00,cap_type = ''\g insert into paperms set recno = 197,acctno = '006558',seq = '0030',typecode = '5',descript = '2',descmemo = '',inst_date = '',rbld_date = '',capacity = 0.00,cap_type = ''\g insert into paperms set recno = 198,acctno = '006559',seq = '0010',typecode = '1',descript = '1',descmemo = '',inst_date = '',rbld_date = '',capacity = 0.00,cap_type = ''\g insert into paperms set recno = 199,acctno = '006559',seq = '0020',typecode = '4',descript = '3',descmemo = '',inst_date = '',rbld_date = '',capacity = 0.00,cap_type = ''\g insert into paperms set recno = 200,acctno = '006561',seq = '0010',typecode = '1',descript = '4',descmemo = '',inst_date = '',rbld_date = '',capacity = 0.00,cap_type = ''\g insert into paperms set recno = 201,acctno = '006561',seq = '0020',typecode = '3',descript = '13',descmemo = '',inst_date = '',rbld_date = '',capacity = 0.00,cap_type = ''\g insert into paperms set recno = 202,acctno = '006561',seq = '0030',typecode = '4',descript = '5',descmemo = '',inst_date = '',rbld_date = '',capacity = 0.00,cap_type = ''\g insert into paperms set recno = 203,acctno = '006562',seq = '0010',typecode = '1',descript = '3',descmemo = '',inst_date = '',rbld_date = '',capacity = 0.00,cap_type = ''\g insert into paperms set recno = 204,acctno = '006562',seq = '0020',typecode = '3',descript = '10 Selectifier',descmemo = '',inst_date = '',rbld_date = '',capacity = 0.00,cap_type = ''\g insert into paperms set recno = 205,acctno = '006562',seq = '0030',typecode = '4',descript = '3 double dis',descmemo = '',inst_date = '',rbld_date = '',capacity = 0.00,cap_type = ''\g insert into paperms set recno = 206,acctno = '006562',seq = '0040',typecode = '6',descript = '4 liquid Cyclone',descmemo = '',inst_date = '',rbld_date = '',capacity = 0.00,cap_type = ''\g insert into paperms set recno = 207,acctno = '006565',seq = '0020',typecode = '',descript = 'Presses: 1 Valmet 1255 twin-roll',descmemo = '',inst_date = '',rbld_date = '',capacity = 0.00,cap_type = ''\g \g
