if not exists(select 1 from syscolumns where id = object_id('EST_PED_VD_IT') and name = 'VLR_BASE_ICMS_SUBS')
begin
ALTER TABLE dbo.EST_PED_VD_IT ADD
	VLR_BASE_ICMS_SUBS money NULL,
	VLR_BASE_ICMS_IT money NULL,
	VLR_TOT_IT money NULL,
	VLR_ISENTO money NULL,
	VLR_OUTROS money NULL, 
	PERC_REDU_BASE_SUBS money NULL,
	PERC_REDU_BASE_ICMS money NULL,
	VLR_PROD_FRETE money NULL,
	VLR_BASE_PIS money NULL,
	VLR_PIS money NULL,
	PERC_ALIQ_PIS money NULL,
	VLR_BASE_COFINS money NULL,
	VLR_COFINS money NULL,
	PERC_ALIQ_COFINS money NULL,
	VLR_BASE_ICMS_RET money NULL,
	VLR_OUTROS_DESPESAS money NULL

ALTER TABLE dbo.EST_PED_VD_IT ADD CONSTRAINT
	DF_EST_PED_VD_IT_VLR_BASE_ICMS_SUBS DEFAULT 0 FOR VLR_BASE_ICMS_SUBS

ALTER TABLE dbo.EST_PED_VD_IT ADD CONSTRAINT
	DF_EST_PED_VD_IT_VLR_BASE_ICMS_IT DEFAULT 0 FOR VLR_BASE_ICMS_IT

ALTER TABLE dbo.EST_PED_VD_IT ADD CONSTRAINT
	DF_EST_PED_VD_IT_VLR_TOT_IT DEFAULT 0 FOR VLR_TOT_IT

ALTER TABLE dbo.EST_PED_VD_IT ADD CONSTRAINT
	DF_EST_PED_VD_IT_VLR_ISENTO DEFAULT 0 FOR VLR_ISENTO

ALTER TABLE dbo.EST_PED_VD_IT ADD CONSTRAINT
	DF_EST_PED_VD_IT_VLR_OUTROS DEFAULT 0 FOR VLR_OUTROS

ALTER TABLE dbo.EST_PED_VD_IT ADD CONSTRAINT
	DF_EST_PED_VD_IT_PERC_REDU_BASE_SUBS DEFAULT 0 FOR PERC_REDU_BASE_SUBS

ALTER TABLE dbo.EST_PED_VD_IT ADD CONSTRAINT
	DF_EST_PED_VD_IT_PERC_REDU_BASE_ICMS DEFAULT 0 FOR PERC_REDU_BASE_ICMS

ALTER TABLE dbo.EST_PED_VD_IT ADD CONSTRAINT
	DF_EST_PED_VD_IT_VLR_PROD_FRETE DEFAULT 0 FOR VLR_PROD_FRETE

ALTER TABLE dbo.EST_PED_VD_IT ADD CONSTRAINT
	DF_EST_PED_VD_IT_VLR_BASE_PIS DEFAULT 0 FOR VLR_BASE_PIS

ALTER TABLE dbo.EST_PED_VD_IT ADD CONSTRAINT
	DF_EST_PED_VD_IT_PERC_ALIQ_PIS DEFAULT 0 FOR PERC_ALIQ_PIS

ALTER TABLE dbo.EST_PED_VD_IT ADD CONSTRAINT
	DF_EST_PED_VD_IT_VLR_BASE_COFINS DEFAULT 0 FOR VLR_BASE_COFINS
ALTER TABLE dbo.EST_PED_VD_IT ADD CONSTRAINT
	DF_EST_PED_VD_IT_VLR_COFINS DEFAULT 0 FOR VLR_COFINS
ALTER TABLE dbo.EST_PED_VD_IT ADD CONSTRAINT
	DF_EST_PED_VD_IT_PERC_ALIQ_COFINS DEFAULT 0 FOR PERC_ALIQ_COFINS
ALTER TABLE dbo.EST_PED_VD_IT ADD CONSTRAINT
	DF_EST_PED_VD_IT_VLR_BASE_ICMS_RET DEFAULT 0 FOR VLR_BASE_ICMS_RET
ALTER TABLE dbo.EST_PED_VD_IT ADD CONSTRAINT
	DF_EST_PED_VD_IT_VLR_OUTROS_DESPESAS DEFAULT 0 FOR VLR_OUTROS_DESPESAS
end