ALTER TABLE REFERENCIAS ADD REF_IBC INT DEFAULT(0) NOT NULL,REF_AZC DECIMAL(14,4) DEFAULT(0) NOT NULL,REF_VOL DECIMAL(14,4) DEFAULT(0) NOT NULL
GO
ALTER TABLE SUBGRUPOS ADD SUB_ICU VARCHAR(3)
GO
INSERT INTO CLASEPOR (CLA_COD,CLA_DES)
VALUES ('ICU','COMESTIBLES ULTRAPROCESADOS')
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TARIFASAZUCAR](
	[TAR_PER] INT NOT NULL DEFAULT ((0)),
	[TAR_ITM] INT NOT NULL DEFAULT ((0)),
	[TAR_CAD] DECIMAL(14, 4) NOT NULL DEFAULT ((0)),
	[TAR_CAH] DECIMAL(14, 4) NOT NULL DEFAULT ((0)),
	[TAR_VAL] DECIMAL(14, 4) NOT NULL DEFAULT ((0)),
 CONSTRAINT [PK_TARIFASAZUCAR] PRIMARY KEY CLUSTERED (TAR_PER,TAR_ITM))


