TRUNCATE `panel_db`;
INSERT INTO `panel_db` (`part_nm`,`group`,`description`,`price_type`,`price_each`,`price_per_foot`,`price_per_S1`,`dealer_pct`,`retail_pct`,`cost_type`) VALUES
  ('GR-3_29','Grand Rib 3_29','Ca_Si_Mo_Al_So_Ba','F',0.0000,2.1400,0.0000,1.3000,1.5500,'P'),
  ('GR-3_26','Grand Rib 3_26','Ca_Si_Mo_Al_So_Ba','F',0.0000,2.9200,0.0000,1.3000,1.5500,'P'),
  ('MP','Multi-Purpose','Ca_Si_Mo_Al_So_Ba','F',0.0000,1.9700,0.0000,1.3000,1.5500,'P'),
  ('GB','Grand Beam','Te','F',0.0000,3.6000,0.0000,1.3000,1.5500,'P'),
  ('MR','Mighty Rib','Sp','F',0.0000,2.7100,0.0000,1.3000,1.5500,'P'),
  ('AS-R','AS-R Corner','So','S1',0.0000,0.0000,16.8800,1.3000,1.5500,'T'),
  ('AJ-3','AJ-3 Jamb Trim','Si_Mo_Al_So_Ba','S1',0.0000,0.0000,5.6400,1.3000,1.5500,'T'),
  ('HA-2','1.5 x2 Header Angle','Si_Mo_Al_Ba_Te','S1',0.0000,0.0000,6.7100,1.3000,1.5500,'T'),
  ('HA-3','1.5x3 Header Angle','Si_Mo_Al_So_Ba_Te','S1',0.0000,0.0000,7.3600,1.3000,1.5500,'T'),
  ('AR-3','AR-3 Ridgecap','Si_Mo_Al_Ba_Te','S1',0.0000,0.0000,13.7200,1.3000,1.5500,'T'),
  ('AS-S','AS-S Gable Trim','Si_Al_Ba','S1',0.0000,0.0000,18.8700,1.3000,1.5500,'T'),
  ('AC-1','AC-1 Corner','Si_Al_Ba','S1',0.0000,0.0000,12.3400,1.3000,1.5500,'T'),
  ('WE-4','WE-4 Eave Trim','Si_Mo_Al_Ba','S1',0.0000,0.0000,14.2300,1.3000,1.5500,'T'),
  ('AE-1','AE-1 Eave','Mo','S1',0.0000,0.0000,10.1200,1.3000,1.5500,'T'),
  ('AS-T','AS-T Corner','Te','S1',0.0000,0.0000,25.7900,1.3000,1.5500,'T'),
  ('AS-TS','AS-T Soffit','Te','S1',0.0000,0.0000,40.5600,1.3000,1.5500,'T'),
  ('AT-2','AT-2 Gambrel Trim','Ba','S1',0.0000,0.0000,18.3500,1.3000,1.5500,'T'),
  ('AS-TJ','AS-T Jamb Trim','Te','S1',0.0000,0.0000,15.3500,1.3000,1.5500,'T'),
  ('CLO-3-O','O/S GR-3 Closure','Si_Mo_Al_So_Ba','E',0.5300,0.0000,0.0000,1.3000,1.5500,'C'),
  ('CLO-3-I','I/S  GR-3 Closure','Si_Mo_Al_So_Ba','E',0.5300,0.0000,0.0000,1.3000,1.5500,'C'),
  ('CLO-GB','Grand Beam  closure','Te','E',0.6000,0.0000,0.0000,1.3000,1.5500,'C'),
  ('Panel_Screws-Stk','#12 x 1  Colored Panel Screw w/washer (panels) Stock','Fastener','E',0.0700,0.0000,0.0000,1.2857,2.2857,'S'),
  ('Stitch_Screws_Stk','#14 x ?  Colored Trim screw w/washer  (trim) Stock','Fastener','E',0.0700,0.0000,0.0000,1.2857,2.2857,'S'),
  ('Panel_Screws-Ord','#12 x 1  Colored Panel Screw w/washer (panels) Order','Fastener','E',0.0700,0.0000,0.0000,1.2857,2.2857,'S'),
  ('Stitch_Screws_Ord','#14 x ?  Colored Trim screw w/washer  (trim) Order','Fastener','E',0.0700,0.0000,0.0000,1.2857,2.2857,'S'),
  ('Imp_Rib_29','Imperial Rib 29 ga.','Ca_Si_Mo_Al_So_Ba','F',0.0000,2.1400,0.0000,1.3000,1.5500,'P'),
  ('Imp_Rib_26','Imperial Rib 26 ga.','Ca_Si_Mo_Al_So_Ba','F',0.0000,2.9200,0.0000,1.3000,1.5500,'P'),
  ('Econo20-IMP','Econo20-IMP','Ca_Si_Mo_Al_So_Ba','F',0.0000,1.9700,0.0000,1.3000,1.5500,'P'),
  ('ABC-PBR_Panel','ABC PBR Panel','Sp','F',0.0000,2.7100,0.0000,1.3000,1.5500,'P'),
  ('LG-128A','LG-128A Corner','So','S1',0.0000,0.0000,16.8800,1.3000,1.5500,'T'),
  ('LG-123','LG-123 Jamb Trim','Si_Mo_Al_So_Ba','S1',0.0000,0.0000,5.6400,1.3000,1.5500,'T'),
  ('LG-127C','LG-127C Header Angle','Si_Mo_Al_So_Ba','S1',0.0000,0.0000,7.3600,1.3000,1.5500,'T'),
  ('LG-101','LG-101 Ridgecap','Si_Mo_Al_Ba','S1',0.0000,0.0000,13.7200,1.3000,1.5500,'T'),
  ('LG-117','LG-117 Gable Trim','Si_Al_Ba','S1',0.0000,0.0000,18.8700,1.3000,1.5500,'T'),
  ('LG-113','LG-113 Corner','Si_Al_Ba','S1',0.0000,0.0000,12.3400,1.3000,1.5500,'T'),
  ('LG-119','LG-119 Eave','Mo','S1',0.0000,0.0000,40.5600,1.3000,1.5500,'T'),
  ('AT-2','AT-2 Gambrel Trim','Ba','S1',0.0000,0.0000,18.3500,1.3000,1.5500,'T'),
  ('HW-473','Outside Imp Closure','Si_Mo_Al_So_Ba','E',0.5300,0.0000,0.0000,1.3000,1.5500,'C'),
  ('HW-472','Inside Imp Closure','Si_Mo_Al_So_Ba','E',0.5300,0.0000,0.0000,1.3000,1.5500,'C'),
  ('P+_29','Panel Loc Plus 29 ga.','Ca_Si_Mo_Al_So_Ba','F',0.0000,2.1400,0.0000,1.3000,1.5500,'P'),
  ('P+_26','Panel Loc Plus 26 ga.','Ca_Si_Mo_Al_So_Ba','F',0.0000,2.9200,0.0000,1.3000,1.5500,'P'),
  ('5+','Panel Loc Thrifty','Ca_Si_Mo_Al_So_Ba','F',0.0000,1.9700,0.0000,1.3000,1.5500,'P'),
  ('Rloc','Rloc PBR Panel','Sp','F',0.0000,2.7100,0.0000,1.3000,1.5500,'P'),
  ('SA3x3-C','SA3x3 Corner','So','S1',0.0000,0.0000,16.8800,1.3000,1.5500,'T'),
  ('JT','JT Jamb Trim','Si_Mo_Al_So_Ba','S1',0.0000,0.0000,5.6400,1.3000,1.5500,'T'),
  ('SA2x2','2x2 Header Angle','Si_Mo_Al_So_Ba','S1',0.0000,0.0000,6.7100,1.3000,1.5500,'T'),
  ('SA3x3-HA','3x3 Header Angle','Si_Mo_Al_So_Ba','S1',0.0000,0.0000,7.3600,1.3000,1.5500,'T'),
  ('RC-2','RC-2 Ridgecap','Si_Mo_Al_Ba','S1',0.0000,0.0000,13.7200,1.3000,1.5500,'T'),
  ('COR-G','COR Gable','Si_Al_Ba','S1',0.0000,0.0000,18.8700,1.3000,1.5500,'T'),
  ('COR-C','COR Corner','Si_Al_Ba','S1',0.0000,0.0000,12.3400,1.3000,1.5500,'T'),
  ('RET','RET Eave Trim','Si_Mo_Al_Ba','S1',0.0000,0.0000,14.2300,1.3000,1.5500,'T'),
  ('SA5x5','5x5 Corner','Mo','S1',0.0000,0.0000,10.1200,1.3000,1.5500,'T'),
  ('AS-TS','AS-T Soffit','Si_Mo_Al_Ba','S1',0.0000,0.0000,25.7900,1.3000,1.5500,'T'),
  ('FT','FT Eave Trim','Mo','S1',0.0000,0.0000,40.5600,1.3000,1.5500,'T'),
  ('GTU','GTU Gambrel Trim','Ba','S1',0.0000,0.0000,18.3500,1.3000,1.5500,'T'),
  ('CLOUT+','Closure Outside Panel Loc Plus','Si_Mo_Al_So_Ba','E',0.5300,0.0000,0.0000,1.3000,1.5500,'C'),
  ('CLIN+','Closure Inside Panel Loc Plus','Si_Mo_Al_So_Ba','E',0.5300,0.0000,0.0000,1.3000,1.5500,'C'),
  ('CE-1','CE-1 Eave','Mo','S1',0.0000,0.0000,10.1200,1.3000,1.5500,'T'),
  ('LG-120','LG-120 Eave','Mo','S1',0.0000,0.0000,10.1200,1.3000,1.5500,'T');

INSERT INTO `master_db` (`part_nm`, `group`, `description`, `length`, `mfg_cost`, `dealer_cost`, `retail_cost`, `weight_lbs`) VALUES
  ('HW-473', 'Closures', 'Outside Imp Closure', 0, 0.53, 0, 0, 0),
  ('HW-472', 'Closures', 'Inside Imp Closure', 0, 0.53, 0, 0, 0),
  ('CLOUT+', 'Closures', 'Closure Outside Panel Loc Plus', 0, 0.53, 0, 0, 0),
  ('CLIN+', 'Closures', 'Closure Inside Panel Loc Plus', 0, 0.53, 0, 0, 0),
  ('Caps', 'Caps', 'Gable Caps', 0, 0.5, 0, 0, 0),
  ('Tube-Caps-2x3', 'Caps', '2x3 Tube Caps', 0, 0.5, 0, 0, 0),
  ('Tube-Caps-2x4', 'Caps', '2x4 Tube Caps', 0, 0.5, 0, 0, 0);

ALTER TABLE `estOrderTable` ADD COLUMN `PnlMfg` CHAR(150) NULL AFTER `PnlOrderSpInstr`;