
/*------ ATD 334237 ------*/
IF NOT EXISTS (SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE table_name = 'PAGAMENTOVENDA' and column_name = 'rItemPrev')
ALTER TABLE PAGAMENTOVENDA ADD rItemPrev INT NULL
go
IF NOT EXISTS (SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE table_name = 'PAGAMENTOVENDA' and column_name = 'Origem')
ALTER TABLE PAGAMENTOVENDA ADD Origem VARCHAR(2) NULL
go
IF NOT EXISTS (SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE table_name = 'PAGAMENTOVENDA' and column_name = 'TipoParcela')
ALTER TABLE PAGAMENTOVENDA ADD TipoParcela VARCHAR(1) NULL
go
IF NOT EXISTS (SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE table_name = 'ITNFSAICOMPLEMENTO' and column_name = 'pFCP')
ALTER TABLE ITNFSAICOMPLEMENTO ADD pFCP NUMERIC(5,2) NULL
go
IF NOT EXISTS (SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE table_name = 'ITNFSAICOMPLEMENTO' and column_name = 'vFCP')
ALTER TABLE ITNFSAICOMPLEMENTO ADD vFCP NUMERIC(15,2) NULL
go