IF NOT EXISTS(SELECT * FROM INFORMATION_SCHEMA.TABLES
			 WHERE TABLE_NAME='PDV_VD_IT_IBS_CBS')
			 
BEGIN

	CREATE TABLE PDV_VD_IT_IBS_CBS
		(
			CD_EMP                       INT          NOT NULL,
			CD_FILIAL                    INT          NOT NULL,
			CD_VD                        INT          NOT NULL,
			CD_IT                        INT          NOT NULL,
			CD_PROD                      INT          NULL,
			CD_TRIB_IBS_CBS              INT          NULL,
			CST_IBS_CBS                  VARCHAR(3)   NULL,
			CLASS_TRIB_IBS_CBS           VARCHAR(6)   NULL,
			VLR_BC_IBS_CBS               MONEY        NULL,
			PERC_IBS_UF                  MONEY        NULL,
			PERC_IBS_UF_DIFERIMENTO      MONEY        NULL,
			VLR_IBS_UF_DIFERIMENTO       MONEY        NULL,
			VLR_IBS_UF_DEV_TRIB          MONEY        NULL,
			PERC_IBS_UF_RED              MONEY        NULL,
			PERC_IBS_UF_RED_EFET         MONEY        NULL,
			VLR_IBS_UF                   MONEY        NULL,
			PERC_IBS_MUN                 MONEY        NULL,
			PERC_IBS_MUN_DIFERIMENTO     MONEY        NULL,
			VLR_IBS_MUN_DIFERIMENTO      MONEY        NULL,
			VLR_IBS_MUN_DEV_TRIB         MONEY        NULL,
			PERC_IBS_MUN_RED             MONEY        NULL,
			PERC_IBS_MUN_RED_EFET        MONEY        NULL,
			VLR_IBS_MUN                  MONEY        NULL,
			VLR_IBS                      MONEY        NULL,
			PERC_CBS                     MONEY        NULL,
			PERC_CBS_DIFERIMENTO         MONEY        NULL,
			VLR_CBS_DIFERIMENTO          MONEY        NULL,
			VLR_CBS_DEV_TRIB             MONEY        NULL,
			PERC_CBS_RED                 MONEY        NULL,
			PERC_CBS_RED_EFET            MONEY        NULL,
			VLR_CBS                      MONEY        NULL,

			CONSTRAINT PK_PDV_VD_IT_IBS_CBS 
				PRIMARY KEY (CD_EMP, CD_FILIAL, CD_VD, CD_IT)
		);


END