X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;ds=sidebyside;f=sql%2Fen_US-new.sql;h=41e7a4db6846e91f111138bf8959ddf22d891248;hb=1cb4f8ee15c1b2971594821b48d9ef034f5edb13;hp=a0607e84bd913e3b3f8d81d70b7ad1c25fbb6ef1;hpb=f0f7b444137a81aa1a227cbb041f3d7d7eaa1715;p=fa-stable.git

diff --git a/sql/en_US-new.sql b/sql/en_US-new.sql
index a0607e84..41e7a4db 100644
--- a/sql/en_US-new.sql
+++ b/sql/en_US-new.sql
@@ -1634,7 +1634,6 @@ CREATE TABLE IF NOT EXISTS `0_stock_master` (
   `dimension_id` int(11) default NULL,
   `dimension2_id` int(11) default NULL,
   `purchase_cost` double NOT NULL default '0',
-  `last_cost` double NOT NULL default '0',
   `material_cost` double NOT NULL default '0',
   `labour_cost` double NOT NULL default '0',
   `overhead_cost` double NOT NULL default '0',
@@ -1897,6 +1896,7 @@ INSERT INTO `0_sys_prefs` VALUES ('default_loss_on_asset_disposal_act', 'glsetup
 INSERT INTO `0_sys_prefs` VALUES ('depreciation_period', 'glsetup.company', 'tinyint', '1', '1');
 INSERT INTO `0_sys_prefs` VALUES ('use_manufacturing','setup.company', 'tinyint', 1, '1');
 INSERT INTO `0_sys_prefs` VALUES ('use_fixed_assets','setup.company', 'tinyint', 1, '1');
+INSERT INTO `0_sys_prefs` VALUES ('wip_act', 'glsetup.manuf', 'varchar', '15', '1530');
 
 -- --------------------------------------------------------
 
@@ -2227,6 +2227,7 @@ CREATE TABLE IF NOT EXISTS `0_wo_issue_items` (
   `stock_id` varchar(40) default NULL,
   `issue_id` int(11) default NULL,
   `qty_issued` double default NULL,
+  `unit_cost` double NOT NULL default '0',
   PRIMARY KEY (`id`)
 ) ENGINE=InnoDB;
 
@@ -2268,7 +2269,7 @@ CREATE TABLE IF NOT EXISTS `0_wo_requirements` (
   `stock_id` char(20) NOT NULL default '',
   `workcentre` int(11) NOT NULL default '0',
   `units_req` double NOT NULL default '1',
-  `std_cost` double NOT NULL default '0',
+  `unit_cost` double NOT NULL default '0',
   `loc_code` char(5) NOT NULL default '',
   `units_issued` double NOT NULL default '0',
   PRIMARY KEY (`id`),