--Novos campos da Ordem de compra ALTER TABLE com_aux_ordem_compra_item ADD COLUMN base_icms numeric(18,6), ADD COLUMN aliquota_icms numeric(18,6), ADD COLUMN base_ipi numeric(18,6), ADD COLUMN base_pis numeric(18,6), ADD COLUMN aliquota_pis numeric(18,6), ADD COLUMN valor_pis numeric(18,6), ADD COLUMN base_cofins numeric(18,6), ADD COLUMN aliquota_cofins numeric(18,6), ADD COLUMN valor_cofins numeric(18,6), ADD COLUMN base_icms_st numeric(18,6), ADD COLUMN aliquota_icms_st numeric(18,6), ADD COLUMN valor_icms_st numeric(18,6), ADD COLUMN peso_total_bruto numeric(18,6), ADD COLUMN classificacao_fiscal character varying(15), ADD COLUMN cfop integer, ADD COLUMN cst_icms integer, ADD COLUMN cst_pis integer, ADD COLUMN cst_cofins integer, ADD COLUMN cst_ipi integer, ADD COLUMN perc_desconto numeric(18,6), ADD COLUMN valor_desconto numeric(18,6); ALTER TABLE com_ordem_compra_item ADD COLUMN base_icms numeric(18,6), ADD COLUMN aliquota_icms numeric(18,6), ADD COLUMN base_ipi numeric(18,6), ADD COLUMN base_pis numeric(18,6), ADD COLUMN aliquota_pis numeric(18,6), ADD COLUMN valor_pis numeric(18,6), ADD COLUMN base_cofins numeric(18,6), ADD COLUMN aliquota_cofins numeric(18,6), ADD COLUMN valor_cofins numeric(18,6), ADD COLUMN base_icms_st numeric(18,6), ADD COLUMN aliquota_icms_st numeric(18,6), ADD COLUMN valor_icms_st numeric(18,6), ADD COLUMN peso_total_bruto numeric(18,6), ADD COLUMN classificacao_fiscal character varying(15), ADD COLUMN cfop integer, ADD COLUMN cst_icms integer, ADD COLUMN cst_pis integer, ADD COLUMN cst_cofins integer, ADD COLUMN cst_ipi integer, ADD COLUMN perc_desconto numeric(18,6), ADD COLUMN valor_desconto numeric(18,6); ALTER TABLE com_aux_ordem_compra ADD COLUMN base_icms numeric(18,6), ADD COLUMN valor_icms numeric(18,6), ADD COLUMN base_ipi numeric(18,6), ADD COLUMN base_pis numeric(18,6), ADD COLUMN valor_pis numeric(18,6), ADD COLUMN base_cofins numeric(18,6), ADD COLUMN valor_cofins numeric(18,6), ADD COLUMN base_icms_st numeric(18,6), ADD COLUMN valor_icms_st numeric(18,6), ADD COLUMN peso_total_liquido numeric(18,6), ADD COLUMN peso_total_bruto numeric(18,6), ADD COLUMN valor_desconto numeric(18,6); ALTER TABLE com_ordem_compra ADD COLUMN base_icms numeric(18,6), ADD COLUMN valor_icms numeric(18,6), ADD COLUMN base_ipi numeric(18,6), ADD COLUMN base_pis numeric(18,6), ADD COLUMN valor_pis numeric(18,6), ADD COLUMN base_cofins numeric(18,6), ADD COLUMN valor_cofins numeric(18,6), ADD COLUMN base_icms_st numeric(18,6), ADD COLUMN valor_icms_st numeric(18,6), ADD COLUMN peso_total_liquido numeric(18,6), ADD COLUMN peso_total_bruto numeric(18,6), ADD COLUMN valor_desconto numeric(18,6); --ATUALIZA OS CAMPOS UPDATE com_aux_ordem_compra_item SET base_icms = 0, aliquota_icms = 0, base_ipi = 0, base_pis = 0, aliquota_pis = 0, valor_pis = 0, base_cofins = 0, aliquota_cofins = 0, valor_cofins = 0, base_icms_st = 0, aliquota_icms_st = 0, valor_icms_st = 0, peso_total_bruto = 0, classificacao_fiscal = '', cfop = 0, cst_icms = 0, cst_pis = 0, cst_cofins = 0, cst_ipi = 0, perc_desconto = 0, valor_desconto = 0; UPDATE com_ordem_compra_item SET base_icms = 0, aliquota_icms = 0, base_ipi = 0, base_pis = 0, aliquota_pis = 0, valor_pis = 0, base_cofins = 0, aliquota_cofins = 0, valor_cofins = 0, base_icms_st = 0, aliquota_icms_st = 0, valor_icms_st = 0, peso_total_bruto = 0, classificacao_fiscal = '', cfop = 0, cst_icms = 0, cst_pis = 0, cst_cofins = 0, cst_ipi = 0, perc_desconto = 0, valor_desconto = 0; UPDATE com_aux_ordem_compra SET base_icms = 0, valor_icms = 0, base_ipi = 0, base_pis = 0, valor_pis = 0, base_cofins = 0, valor_cofins = 0, base_icms_st = 0, valor_icms_st = 0, peso_total_liquido = 0, peso_total_bruto = 0, valor_desconto = 0; UPDATE com_ordem_compra SET base_icms = 0, valor_icms = 0, base_ipi = 0, base_pis = 0, valor_pis = 0, base_cofins = 0, valor_cofins = 0, base_icms_st = 0, valor_icms_st = 0, peso_total_liquido = 0, peso_total_bruto = 0, valor_desconto = 0; --ALTERA PARA NOT NULL ALTER TABLE com_aux_ordem_compra_item ALTER COLUMN base_icms SET NOT NULL, ALTER COLUMN aliquota_icms SET NOT NULL, ALTER COLUMN base_ipi SET NOT NULL, ALTER COLUMN base_pis SET NOT NULL, ALTER COLUMN aliquota_pis SET NOT NULL, ALTER COLUMN valor_pis SET NOT NULL, ALTER COLUMN base_cofins SET NOT NULL, ALTER COLUMN aliquota_cofins SET NOT NULL, ALTER COLUMN valor_cofins SET NOT NULL, ALTER COLUMN base_icms_st SET NOT NULL, ALTER COLUMN aliquota_icms_st SET NOT NULL, ALTER COLUMN valor_icms_st SET NOT NULL, ALTER COLUMN peso_total_bruto SET NOT NULL, ALTER COLUMN classificacao_fiscal SET NOT NULL, ALTER COLUMN cfop SET NOT NULL, ALTER COLUMN cst_icms SET NOT NULL, ALTER COLUMN cst_pis SET NOT NULL, ALTER COLUMN cst_cofins SET NOT NULL, ALTER COLUMN cst_ipi SET NOT NULL, ALTER COLUMN perc_desconto SET NOT NULL, ALTER COLUMN valor_desconto SET NOT NULL; ALTER TABLE com_ordem_compra_item ALTER COLUMN base_icms SET NOT NULL, ALTER COLUMN aliquota_icms SET NOT NULL, ALTER COLUMN base_ipi SET NOT NULL, ALTER COLUMN base_pis SET NOT NULL, ALTER COLUMN aliquota_pis SET NOT NULL, ALTER COLUMN valor_pis SET NOT NULL, ALTER COLUMN base_cofins SET NOT NULL, ALTER COLUMN aliquota_cofins SET NOT NULL, ALTER COLUMN valor_cofins SET NOT NULL, ALTER COLUMN base_icms_st SET NOT NULL, ALTER COLUMN aliquota_icms_st SET NOT NULL, ALTER COLUMN valor_icms_st SET NOT NULL, ALTER COLUMN peso_total_bruto SET NOT NULL, ALTER COLUMN classificacao_fiscal SET NOT NULL, ALTER COLUMN cfop SET NOT NULL, ALTER COLUMN cst_icms SET NOT NULL, ALTER COLUMN cst_pis SET NOT NULL, ALTER COLUMN cst_cofins SET NOT NULL, ALTER COLUMN cst_ipi SET NOT NULL, ALTER COLUMN perc_desconto SET NOT NULL, ALTER COLUMN valor_desconto SET NOT NULL; ALTER TABLE com_aux_ordem_compra ALTER COLUMN base_icms SET NOT NULL, ALTER COLUMN valor_icms SET NOT NULL, ALTER COLUMN base_ipi SET NOT NULL, ALTER COLUMN base_pis SET NOT NULL, ALTER COLUMN valor_pis SET NOT NULL, ALTER COLUMN base_cofins SET NOT NULL, ALTER COLUMN valor_cofins SET NOT NULL, ALTER COLUMN base_icms_st SET NOT NULL, ALTER COLUMN valor_icms_st SET NOT NULL, ALTER COLUMN peso_total_liquido SET NOT NULL, ALTER COLUMN peso_total_bruto SET NOT NULL, ALTER COLUMN valor_desconto SET NOT NULL; ALTER TABLE com_ordem_compra ALTER COLUMN base_icms SET NOT NULL, ALTER COLUMN valor_icms SET NOT NULL, ALTER COLUMN base_ipi SET NOT NULL, ALTER COLUMN base_pis SET NOT NULL, ALTER COLUMN valor_pis SET NOT NULL, ALTER COLUMN base_cofins SET NOT NULL, ALTER COLUMN valor_cofins SET NOT NULL, ALTER COLUMN base_icms_st SET NOT NULL, ALTER COLUMN valor_icms_st SET NOT NULL, ALTER COLUMN peso_total_liquido SET NOT NULL, ALTER COLUMN peso_total_bruto SET NOT NULL, ALTER COLUMN valor_desconto SET NOT NULL;