ALTER TABLE dbo.Vpos_trs_BillDetails ADD HideOrderSlipItem int NULL GO ALTER TABLE dbo.Vpos_trs_BillDetails ADD CONSTRAINT DF_Vpos_trs_BillDetails_HideOrderSlipItem_1 DEFAULT ((0)) FOR HideOrderSlipItem GO ALTER TABLE dbo.Vstk_mt_Item ADD HideOrderSlipItem int NULL GO ALTER TABLE dbo.Vstk_mt_Item ADD CONSTRAINT DF_Vstk_mt_Item_HideOrderSlipItem DEFAULT ((0)) FOR HideOrderSlipItem GO ALTER TABLE dbo.Vstk_trs_Bills ADD TerminalNo varchar(20) NULL GO update vstk_mt_item set HideOrderSlipItem=0 where HideOrderSlipItem is null update vpos_trs_billdetails set HideOrderSlipItem=0 where HideOrderSlipItem is null DELETE FROM Vs_DefaultAccess WHERE (DefaultNo=126) and DefaultType='L' INSERT INTO Vs_DefaultAccess (DefaultName,DefaultNo,DefaultType,DisplayNo,ctype) VALUES('[L126] Non inventory scale item',126,'L',126,'OOXXXXXXXX')