CREATE TABLE USR_SAP_PRAZOPGTFORN
(
   CDFORNECEDOR VARCHAR2(20),
   NRDIASPGTOFO NUMBER(3),
   VRPERCPGTOFO FLOAT
)
/

ALTER TABLE USR_SAP_ITEMPRODUTO
ADD DSPRODEMIS VARCHAR2(400)
/

ALTER TABLE USR_SAP_ITAPURFATUR
ADD DSPRODEMIS VARCHAR2(400)
/

ALTER TABLE USR_SAP_NOTAFISCAL
ADD IDSTATUSNFE VARCHAR2(1)
/

ALTER TABLE USR_SAP_NOTAFISCAL
ADD IDNFGERADAVIAXML VARCHAR2(1)
/

ALTER TABLE USR_SAP_ITEMPROIMPOS
ADD NRITPROIMPOS VARCHAR2(1)
/

ALTER TABLE USR_SAP_ITEMPROIMPOS
ADD CDSITUTRIBITNFE VARCHAR2(2) 
/

-- VERSAO --
BEGIN ATUVEROBJ('ATUALIZACAO_ESTRUTURA_BD','5.42.XXX'); END;
/