ALTER TABLE T0001 ADD (TidNroDocu NUMERIC(7) , TidInd3 CHAR(1) , TidInd2 CHAR(1) , TidInd1 CHAR(1) , TidTipAcer CHAR(1) )

ALTER TABLE Emt011 ADD (UsbNroUnid NUMERIC(4) , UsbNomConj CHAR(45) , UsbNomMae CHAR(45) , UsbNomPai CHAR(45) , UsbDscComp CHAR(20) )
ALTER TABLE Emt011 MODIFY UsbNroCPF NUMERIC(15)

ALTER TABLE Abt022 ADD (ForNroCnpj NUMERIC(15) )

ALTER TABLE T0048 ADD (UndTipNome CHAR(1) , UndInd5 CHAR(1) , UndEndArqu CHAR(150) )

ALTER TABLE T0050 ADD (DvoQtdAnos NUMERIC(3) )
CREATE INDEX DVOI11 ON T0050 (DvoQtdAnos ,DocNro ,UndCod ,DoeNroSequ ,DvoNroVolu ,DvoNroTomo )

ALTER TABLE T0062 ADD (DviNroRepo NUMERIC(5) )

ALTER TABLE EMT014 ADD (UsnValRecu CHAR(50) )
CREATE INDEX USN01 ON EMT014 (UsnNroSeq ,UsnValRecu ,UsbCod )

ALTER TABLE T0076 ADD (VncDatCada DATE )

ALTER TABLE MAT002 ADD (DisTipVali CHAR(1) , DisIndObri CHAR(1) )
CREATE INDEX DIS03 ON MAT002 (DicTipMate ,DisIndObri )

CREATE TABLE T0105 (RddNroSequ NUMERIC(5) NOT NULL , RddDscURL CHAR(230) , RddDscCami CHAR(230) , RddInd1 CHAR(1) , RddDscAnot VARCHAR2(4000) , PRIMARY KEY(RddNroSequ))
CREATE INDEX RDD01 ON T0105 (RddNroSequ DESC)

CREATE TABLE T0104 (StrCod NUMERIC(5) NOT NULL , StrNom CHAR(50) NOT NULL , PRIMARY KEY(StrCod))
CREATE INDEX STR01 ON T0104 (StrCod DESC)

CREATE TABLE T0103 (TtdNroSequ NUMERIC(4) NOT NULL , TtcCodCamp CHAR(10) NOT NULL , TtcValCamp VARCHAR2(1024) , PRIMARY KEY(TtdNroSequ, TtcCodCamp))

CREATE TABLE T0102 (TtdNroSequ NUMERIC(4) NOT NULL , TtdInd1 CHAR(1) , StrCod NUMERIC(5) , PRIMARY KEY(TtdNroSequ))
CREATE INDEX TTD01 ON T0102 (TtdNroSequ DESC)
CREATE INDEX IT0102 ON T0102 (StrCod )

CREATE TABLE T0101 (RdoNroSequ NUMERIC(6) NOT NULL , RdiNroSequ NUMERIC(4) NOT NULL , RicCodCamp CHAR(10) NOT NULL , RicValCont VARCHAR2(1024) , RicCampo1L CHAR(10) , RicInd1 CHAR(1) , PRIMARY KEY(RdoNroSequ, RdiNroSequ, RicCodCamp))

CREATE TABLE T0100 (RdoNroSequ NUMERIC(6) NOT NULL , RdiNroSequ NUMERIC(4) NOT NULL , RdiNroTomb NUMERIC(7) , RdiInd1 CHAR(1) , RdiCampo1L CHAR(10) , PRIMARY KEY(RdoNroSequ, RdiNroSequ))
CREATE INDEX RDI01 ON T0100 (RdoNroSequ ,RdiNroSequ DESC)

CREATE TABLE T0099 (RdoNroSequ NUMERIC(6) NOT NULL , RdoTipMovi CHAR(1) , UsbCod CHAR(14) NOT NULL , RdoDatMovi DATE , RdoDscDoac VARCHAR2(4000) , RdoCampo1L CHAR(20) , RdoInd1 CHAR(1) , PRIMARY KEY(RdoNroSequ))
CREATE INDEX ITIMT0951 ON T0099 (UsbCod )
CREATE INDEX RDO01 ON T0099 (RdoNroSequ DESC)
CREATE INDEX RDO02 ON T0099 (RdoDatMovi ,RdoNroSequ )

CREATE TABLE T0098 (DinCodTabe CHAR(1) NOT NULL , DinNroDocu NUMERIC(7) NOT NULL , DinNroSequ NUMERIC(4) NOT NULL , DinCodCamp CHAR(20) NOT NULL , DinInd1 CHAR(1) , DinInd2 CHAR(1) , DinValCont VARCHAR2(4000) , PRIMARY KEY(DinCodTabe, DinNroDocu, DinNroSequ))

CREATE INDEX SCD07 ON MAT012 (CedNroSeqC ,ScdNroSeqS ,ScdCampo1L ,DocNro ,CedNroItem ,CedNroArti )

CREATE INDEX I08P ON T0008 (DocCodAuto ,DocNro )

