/*******************************************************************************
 * Selected metadata objects
 * -------------------------
 * Extracted at 08/08/2005 11:44:04 a.m.
 ******************************************************************************/

/*******************************************************************************
 * Sequences
 * ---------
 * Extracted at 08/08/2005 11:44:04 a.m.
 ******************************************************************************/

CREATE SEQUENCE LOGIC_021.DETALLE_SOLICITUD_CP_GEN
  MINVALUE 1
  CACHE 20
/

CREATE SEQUENCE LOGIC_021.GEN_PL
  MINVALUE 1
  CACHE 20
/

CREATE SEQUENCE LOGIC_021.INC_SALDOS_PENDIENTES
  MINVALUE 1
  CACHE 20
/

CREATE SEQUENCE LOGIC_021.INCIP
  MINVALUE 1
  CACHE 20
/

CREATE SEQUENCE LOGIC_021.INCLOGRELOJX
  MINVALUE 1
  CACHE 20
/

CREATE SEQUENCE LOGIC_021.INCNUMABONNE
  MINVALUE 1
  CACHE 20
/

CREATE SEQUENCE LOGIC_021.INCNUMAPPEL
  MINVALUE 1
  CACHE 20
/

CREATE SEQUENCE LOGIC_021.INCNUMBN
  MINVALUE 1
  CACHE 20
/

CREATE SEQUENCE LOGIC_021.INCNUMBNINT
  MINVALUE 1
  CACHE 20
/

CREATE SEQUENCE LOGIC_021.INCNUMCAMBIO
  MINVALUE 1
  CACHE 20
/

CREATE SEQUENCE LOGIC_021.INCNUMEC
  MINVALUE 1
  CACHE 20
/

CREATE SEQUENCE LOGIC_021.INCNUMHIST
  MINVALUE 1
  CACHE 20
/

CREATE SEQUENCE LOGIC_021.INCNUMID_RECHABONNE
  MINVALUE 1
  CACHE 20
/

CREATE SEQUENCE LOGIC_021.INCNUMIMP
  MINVALUE 1
  CACHE 20
/

CREATE SEQUENCE LOGIC_021.INCNUMITV
  MINVALUE 1
  CACHE 20
/

CREATE SEQUENCE LOGIC_021.INCNUMLOGIN
  MINVALUE 1
  CACHE 20
/

CREATE SEQUENCE LOGIC_021.INCNUMLOTEX
  MINVALUE 1
  CACHE 20
/

CREATE SEQUENCE LOGIC_021.INCNUMMAIL
  MINVALUE 1
  CACHE 20
/

CREATE SEQUENCE LOGIC_021.INCNUMMOUVEMENT
  MINVALUE 1
  CACHE 20
/

CREATE SEQUENCE LOGIC_021.INCNUMORDREPPV
  MINVALUE 1
  CACHE 20
/

CREATE SEQUENCE LOGIC_021.INCNUMPAYAV
  MINVALUE 1
  CACHE 20
/

CREATE SEQUENCE LOGIC_021.INCNUMRDV
  MINVALUE 1
  CACHE 20
/

CREATE SEQUENCE LOGIC_021.INCNUMRECH
  MINVALUE 1
  CACHE 20
/

CREATE SEQUENCE LOGIC_021.INCNUMRECU
  MINVALUE 1
  CACHE 20
/

CREATE SEQUENCE LOGIC_021.INCNUMROLE
  MINVALUE 1
  CACHE 20
/

CREATE SEQUENCE LOGIC_021.INCNUMSOC
  MINVALUE 1
  CACHE 20
/

CREATE SEQUENCE LOGIC_021.INCNUMSTATRECO
  MINVALUE 1
  CACHE 20
/

CREATE SEQUENCE LOGIC_021.INCNUMVENTE
  MINVALUE 1
  CACHE 20
/

CREATE SEQUENCE LOGIC_021.INCNUMVISITE
  MINVALUE 1
  CACHE 20
/

CREATE SEQUENCE LOGIC_021.INCPAGO
  MINVALUE 1
  CACHE 20
/

CREATE SEQUENCE LOGIC_021.INCTRANSACDLAX
  MINVALUE 1
  CACHE 20
/

CREATE SEQUENCE LOGIC_021.SOLICITUD_CABIO_PRECIO_GEN
  MINVALUE 1
  CACHE 20
/

/*******************************************************************************
 * Tables
 * ------
 * Extracted at 08/08/2005 11:44:04 a.m.
 ******************************************************************************/

CREATE TABLE LOGIC_021.ABONNE (
    NUMABONNE Number(10) NOT NULL,
    NUMSOUSCRIPT Number(10),
    NUMCONTRAT Number(10),
    GENRE Char(1),
    NOM VarChar2(50),
    LGT VarChar2(4),
    CODINSEE Char(3),
    ADRESSE VarChar2(100),
    BOITPOST VarChar2(15),
    TELDOM VarChar2(14),
    TELBURO VarChar2(14),
    TELCEL VarChar2(14),
    DTABON Date,
    DTSAISIE Date,
    LETWLC Char(3),
    CODOPE Char(10),
    RUTA Number(10),
    CBOR Char(4),
    NATION VarChar2(10),
    CAUTION Unknown,
    TRAVAIL VarChar2(20),
    CODRGT Char(4),
    NUMTVA VarChar2(10),
    SOLDE Unknown,
    LOCALIZATION Char(5),
    CEDULA VarChar2(20),
    NUMID Number(10),
    INTERNET VarChar2(62),
    HABITACION Number(5),
    LIMITPPV Unknown,
    ASUJETIV Char(1) DEFAULT 'F' NOT NULL,
    VENCELGT Date,
    TIPO VarChar2(1),
    NITREAL VarChar2(25),
    NUME_HOGAR VarChar2(8),
    CPROV VarChar2(3),
    CCANTON VarChar2(3),
    CDISTRI VarChar2(3),
    CLAVEDLA VarChar2(8),
    TIPOFACT Char(4),
    TEMPORAL Number(10),
    TELFAX VarChar2(14),
    MULTA Char(1) DEFAULT 'F' NOT NULL,
    GESTION VarChar2(1),
    MOTIVO_GESTION VarChar2(3),
    FECHA_GESTION Date,
    GESTOR VarChar2(10),
    CONSTRAINT PK_ABONNE PRIMARY KEY (
      NUMABONNE
    )
)
/

CREATE TABLE LOGIC_021.ABONNEPPV (
    NUMORDREPPV Number(10) NOT NULL,
    NUMABONNE Number(10),
    DTSAISIE Date,
    NUMTRANSACDLA Number(10),
    NUMEVENT Number(10),
    NUMSERIE Char(15),
    DTFACT Date,
    CONSTRAINT PK_ABONNEPPV PRIMARY KEY (
      NUMORDREPPV
    )
)
/

CREATE TABLE LOGIC_021.ABONNEPPVPROB (
    NUMORDREPPV Number(10) NOT NULL,
    DTSAISIE Date,
    NUMSERIE Char(15),
    NUMABONNE Number(10),
    CONSTRAINT PK_ABONNEPPVPROB PRIMARY KEY (
      NUMORDREPPV
    )
)
/

CREATE TABLE LOGIC_021.ACTUALIZACION (
    NUMABONNE Number(10) NOT NULL,
    OPTICNODE VarChar2(9),
    NUMTAP VarChar2(9),
    SORTIETAP Number(5),
    CONSTRAINT PK_ACTUALIZACION PRIMARY KEY (
      NUMABONNE
    )
)
/

CREATE TABLE LOGIC_021.AG (
    NUMABONNE Number(10) NOT NULL,
    SOLD1 Unknown,
    SOLD2 Unknown,
    SOLD3 Unknown,
    SOLD4 Unknown,
    SOLD5 Unknown,
    CONSTRAINT PK_AG PRIMARY KEY (
      NUMABONNE
    )
)
/

CREATE TABLE LOGIC_021.AMNETINFO (
    FICHEID Number(10) NOT NULL,
    PRECIOS BLOB,
    CANALES BLOB,
    NOTICIAS BLOB,
    TELEFONO BLOB,
    PROMOCION BLOB,
    AVERIAS BLOB,
    COBERINTERNET BLOB,
    VENTAS BLOB,
    RHUMANO BLOB,
    INFOLOGIC BLOB,
    INFORADIOS BLOB,
    CONSTRAINT PK_AMNETINFO PRIMARY KEY (
      FICHEID
    )
)
/

CREATE TABLE LOGIC_021.AVERINTERNET (
    NUMLLAMADA Number(10) NOT NULL,
    NUMABONNE Number(10) NOT NULL,
    NUMOT Number(10),
    FECHAINI Date,
    HORAINI VarChar2(5),
    USUARIOINI VarChar2(10),
    MOTIVO VarChar2(4),
    RESPUESTA VarChar2(4),
    OBSERVACION Long,
    ESTADO Char(1) NOT NULL,
    GRUPOLATE VarChar2(4),
    FECHAFINAL Date,
    HORAFINAL VarChar2(5),
    USUARIOFIN VarChar2(10),
    NUMCASO Number(10),
    PRIORIDAD Number(10),
    CONSTRAINT PK_AVERINTERNET PRIMARY KEY (
      NUMLLAMADA
    )
)
/

CREATE TABLE LOGIC_021.BITACORA_NODOS (
    CODIGO_HEADEND VarChar2(5) NOT NULL,
    CODIGO_HUB VarChar2(5) NOT NULL,
    NUMNODE Char(10) NOT NULL,
    FECHA Date NOT NULL,
    HORA Number(10) NOT NULL,
    ESTADO Number(10) NOT NULL,
    USUARIO VarChar2(10) NOT NULL,
    COMENTARIO VarChar2(250),
    CONSTRAINT PK_BITACORA_NODOS PRIMARY KEY (
      CODIGO_HEADEND,
      CODIGO_HUB,
      NUMNODE,
      FECHA,
      HORA,
      ESTADO
    )
)
/

CREATE TABLE LOGIC_021.BLOCNOTE (
    NUMBN Number(10) NOT NULL,
    NUMABONNE Number(10),
    DTSAISIE Date,
    LIB VarChar2(50),
    CODOPE VarChar2(10),
    CONSTRAINT PK_BLOCNOTE PRIMARY KEY (
      NUMBN
    )
)
/

CREATE TABLE LOGIC_021.CABLEMODEMSERV (
    ORDRE Number(10) NOT NULL,
    NUMSERIE VarChar2(40),
    MACADDRESS VarChar2(15),
    TIPOEQUIPO VarChar2(12),
    FECHAVENCIM Date,
    PROPIETARIO VarChar2(12),
    NUMCLIALOPA VarChar2(10),
    POLITICA Char(10),
    CONSTRAINT PK_CABLEMODEMSERV PRIMARY KEY (
      ORDRE
    )
)
/

CREATE TABLE LOGIC_021.CAJACAJERO (
    NUMMOUVEMENT Number(10) NOT NULL,
    HEURE Char(5),
    DTCPT Date,
    CASHIER Char(10),
    CASHEFECTIVOCOL Unknown,
    CASHEFECTIVODOL Unknown,
    CASHCHEQUECOL Unknown,
    CASHCHEQUEDOL Unknown,
    CASHBANCODEPOSIT Unknown,
    CASHDIFER Unknown,
    CASHVOUCHERCREST Unknown,
    CASHVOUCHERCREDOMATIC Unknown,
    CASHVOUCHERAVAL Unknown,
    CASHDIFERCANAL Unknown,
    CASHDIFERSISTEMAS Unknown,
    "COMMENT" Char(200),
    CAMBIO Unknown,
    COMISION Unknown,
    DIFERCAMBIO Unknown,
    DIFERCORTE Unknown,
    PCOBRAREMPLEA Unknown,
    DIFERCAJERO Unknown,
    CONSTRAINT PK_CAJACAJERO PRIMARY KEY (
      NUMMOUVEMENT
    )
)
/

CREATE TABLE LOGIC_021.CAJAPRINC (
    NUMMOUVEMENT Number(10) NOT NULL,
    HEURE Char(5),
    CODOPE Char(10),
    DTCPT Date,
    NUMLOTE VarChar2(10),
    CASHIER Char(10),
    TOTEFECTIVO Unknown,
    TOTCHEQUE Unknown,
    TOTBANCRECEN Unknown,
    TOTCREDOMATIC Unknown,
    TOTAVAL Unknown,
    TOTOTRO Unknown,
    TOTCREST Unknown,
    TOTBANCO Unknown,
    CASHEFECTIVOCOL Unknown,
    CASHEFECTIVODOL Unknown,
    CASHCHEQUECOL Unknown,
    CASHCHEQUEDOL Unknown,
    CASHBANCODEPOSIT Unknown,
    CASHDIFER Unknown,
    CASHVOUCHERCREST Unknown,
    CASHVOUCHERCREDOMATIC Unknown,
    CASHVOUCHERAVAL Unknown,
    CASHDIFERCANAL Unknown,
    CASHDIFERSISTEMAS Unknown,
    "COMMENT" Char(200),
    CAMBIO Unknown,
    COMISION Unknown,
    TOTBSJ Unknown,
    DIFERCAMBIO Unknown,
    DIFERCORTE Unknown,
    PCOBRAREMPLEA Unknown,
    DIFERCAJERO Unknown,
    TIPO Char(5),
    OFICINA Char(4),
    AVALMILLAS Unknown,
    TOTAVALMILLAS Unknown,
    CASHAVALMILLAS Unknown,
    DIFERAVALMILLAS Unknown,
    CONSTRAINT PK_CAJAPRINC PRIMARY KEY (
      NUMMOUVEMENT
    )
)
/

CREATE TABLE LOGIC_021.CAMBIOCOLILLA (
    NUMCAMBIO Number(10) NOT NULL,
    NUMABONNE Number(10) NOT NULL,
    NUMSOUSCRIPT Number(10),
    NOM VarChar2(50),
    DTSAISIE Date,
    CODOPE VarChar2(10),
    CONSTRAINT PK_CAMBIOCOLILLA PRIMARY KEY (
      NUMCAMBIO
    )
)
/

CREATE TABLE LOGIC_021.CANTONES (
    CCANTON VarChar2(3) NOT NULL,
    NCANTON VarChar2(50),
    CPROV VarChar2(2) NOT NULL,
    CPAIS VarChar2(3) NOT NULL,
    CONSTRAINT PK_CANTONES PRIMARY KEY (
      CCANTON,
      CPROV,
      CPAIS
    )
)
/

CREATE TABLE LOGIC_021.CDDTRCONDI (
    NUMABONNE Number(10),
    OFICIAL Char(10),
    FECHA Date,
    ESTCTA VarChar2(1),
    INST VarChar2(1),
    AVE VarChar2(1),
    TEXT VarChar2(1),
    TINST VarChar2(1),
    DEV VarChar2(1),
    DES VarChar2(1),
    RECO VarChar2(1),
    PREM VarChar2(1),
    STEC VarChar2(1),
    SALDO VarChar2(1),
    VENTAS VarChar2(1),
    VARIOS VarChar2(1),
    OBSERV VarChar2(100),
    TELEFONO VarChar2(14),
    EMISOR VarChar2(50),
    CMBTAR VarChar2(1),
    EXCTAR VarChar2(1),
    INCTAR VarChar2(1)
)
/

CREATE TABLE LOGIC_021.CIUDADES (
    CODIGO Number(10) NOT NULL,
    DESCRIPCION VarChar2(50),
    CONSTRAINT PK_CIUDADES PRIMARY KEY (
      CODIGO
    )
)
/

CREATE TABLE LOGIC_021.CLOSING (
    DTCLOS Date NOT NULL,
    CONSTRAINT PK_CLOSING PRIMARY KEY (
      DTCLOS
    )
)
/

CREATE TABLE LOGIC_021.COMMUNE (
    CODINSEE Char(3) NOT NULL,
    NOM Char(25),
    NBPREV Number(10),
    NUMSOC Number(5),
    CONSTRAINT PK_COMMUNE PRIMARY KEY (
      CODINSEE
    )
)
/

CREATE TABLE LOGIC_021.COMPTA (
    PERIODE Char(7) NOT NULL,
    CAMBIO Unknown,
    STATUS Char(4),
    CONSTRAINT PK_COMPTA PRIMARY KEY (
      PERIODE
    )
)
/

CREATE TABLE LOGIC_021.COMPTE (
    CPTNUM VarChar2(20) NOT NULL,
    LIB VarChar2(50)
)
/

CREATE TABLE LOGIC_021.CONFIGURACION (
    DESC3 Unknown,
    DESC6 Unknown,
    DESC9 Unknown,
    DESC12 Unknown,
    TIPOMULTA Char(1),
    MULTA Unknown,
    PASSENCRYP Char(1),
    AVALMILLAS Unknown,
    AVALMONTO Unknown,
    FACTORAVAL Unknown,
    RUTA_PPV_WIN VarChar2(30),
    RUTA_PPV_LINUX VarChar2(30),
    ALOPA Char(1) DEFAULT 'F' NOT NULL,
    PNODESCO Char(4),
    PDESCOTRAS Char(4),
    PDESCONORM Char(4),
    COD_DEPOSITO Char(4),
    COST_INS Char(4)
)
/

CREATE TABLE LOGIC_021.CONTACTOS (
    NUMCONTACTO Number(10) NOT NULL,
    NUMABONNE Number(10) NOT NULL,
    NOMBRE VarChar2(50),
    TELEFONO1 VarChar2(10),
    TELEFONO2 VarChar2(10) NOT NULL,
    EMAIL VarChar2(50),
    APARTADO VarChar2(15)
)
/

CREATE TABLE LOGIC_021.CONTRAT (
    TYPCTRT Char(4),
    DTLASTMODIF Date,
    DTRESI Date,
    CODRESI Char(4),
    CODRGT Char(4),
    CODVDS Char(4),
    CODPROV Char(4),
    "COMMENT" VarChar2(100),
    NUMABONNE Number(10) NOT NULL,
    AMPLIACION Char(1),
    INSINMEDIATA Char(1),
    TIPOTRABAJO Char(4),
    CONSTRAINT PK_CONTRAT PRIMARY KEY (
      NUMABONNE
    )
)
/

CREATE TABLE LOGIC_021.CORREOS (
    NUMMAIL Number(10) NOT NULL,
    ORDRE Number(10),
    NUMINTER Number(10),
    LOGIN VarChar2(25),
    DOMINIO VarChar2(25),
    PASSWD VarChar2(20),
    CAPACITY Unknown,
    ESTADO Char(1),
    DTSAISIE Date,
    DTMENS Date,
    DTRESI Date,
    MOVIMIENTO Char(3),
    CONSTRAINT PK_CORREOS PRIMARY KEY (
      NUMMAIL
    )
)
/

CREATE TABLE LOGIC_021.CREDFISCAL (
    NUMABONNE Number(10) NOT NULL,
    NUMREGISTRO VarChar2(10),
    ACTIVIDAD VarChar2(50),
    CONSTRAINT PK_CREDFISCAL PRIMARY KEY (
      NUMABONNE
    )
)
/

CREATE TABLE LOGIC_021.DECOLUNES (
    NUMABONNE Number(10) NOT NULL,
    SALDO Unknown,
    CODOPE Char(10),
    DTSAISIE Date,
    NOM VarChar2(50),
    JOUR VarChar2(10),
    CODINSEE Char(5),
    CONSTRAINT PK_DECOLUNES PRIMARY KEY (
      NUMABONNE
    )
)
/

CREATE TABLE LOGIC_021.DEMENAGE (
    NUMABONNE Number(10) NOT NULL,
    ADRESSE Char(100),
    CODINSEE Char(5),
    TELDOM Char(14),
    DTRACC Date,
    CODINT Char(4),
    "COMMENT" Char(100),
    LOCA Char(11),
    LOCALIZATION Char(11),
    OPTICNODE Char(10),
    CONSTRAINT PK_DEMENAGE PRIMARY KEY (
      NUMABONNE
    )
)
/

CREATE TABLE LOGIC_021.DEPOSITOS (
    NUMABONNE Number(10) NOT NULL,
    DEPOSITO Unknown,
    ESTADO Char(1) DEFAULT 'F' NOT NULL,
    RECIBO Number(10),
    CODOPE VarChar2(10),
    FECHA Date,
    CONSTRAINT PK_DEPOSITOS PRIMARY KEY (
      NUMABONNE
    )
)
/

CREATE TABLE LOGIC_021.DERECHOS_REPORTE (
    GRUPO Char(4),
    REPORTE VarChar2(50)
)
/

CREATE TABLE LOGIC_021.DETALLE_SOLICITUD_CP (
    ID_DETALLE Number(10) NOT NULL,
    ID_SOLICITUD Number(10) NOT NULL,
    ORDRE Number(10) NOT NULL,
    CODPROD Char(4) NOT NULL,
    NUEVO_PRECIO Unknown,
    CONSTRAINT PK_DETALLE_SOLICITUD_CP PRIMARY KEY (
      ID_DETALLE
    )
)
/

CREATE TABLE LOGIC_021.DETEC (
    NUMPIECE Number(10) NOT NULL,
    CODPROD Char(4) NOT NULL,
    MTT Unknown,
    CODTVA Char(4),
    NUMJRNL Char(3),
    CANTIDAD Number(10),
    CONSTRAINT PK_DETEC PRIMARY KEY (
      NUMPIECE,
      CODPROD
    )
)
/

CREATE TABLE LOGIC_021.DETECHQ (
    NUMPIECE Number(10) NOT NULL,
    NUMCHQ Char(10),
    BANKCHQ Char(25),
    EMISOR VarChar2(25),
    NUMCARD VarChar2(16),
    NUMAUTORIZ VarChar2(16),
    TARJETAHABIENTE VarChar2(40),
    MILLAS Unknown,
    PAQUETE Char(4),
    CONSTRAINT PK_DETECHQ PRIMARY KEY (
      NUMPIECE
    )
)
/

CREATE TABLE LOGIC_021.DETINTER (
    NUMINTER Number(10) NOT NULL,
    CODPROD Char(4) NOT NULL,
    QTEDMD Number(5),
    MOVIMIENTO Char(3),
    ESTADO Char(1) DEFAULT 'F' NOT NULL,
    ORDREVTE Number(10) NOT NULL,
    TIPO VarChar2(1),
    MOTIVO Char(4),
    CONSTRAINT PK_DETINTER PRIMARY KEY (
      NUMINTER,
      ORDREVTE
    )
)
/

CREATE TABLE LOGIC_021.DETINTER_TEMP (
    NUMINTER Number(10) NOT NULL,
    ORDRE Number(10) NOT NULL,
    NUMSERIE Char(15),
    CODPROD Char(4) NOT NULL,
    TIPOACCION Char(3),
    ACCRESULT VarChar2(50),
    OPTICNODE Char(10)
)
/

CREATE TABLE LOGIC_021.DETINTERMAT (
    NUMINTER Number(10) NOT NULL,
    CODMAT Char(9) NOT NULL,
    QTEINST Number(5),
    CONSTRAINT PK_DETINTERMAT PRIMARY KEY (
      NUMINTER,
      CODMAT
    )
)
/

CREATE TABLE LOGIC_021.DICO (
    OBJID Number(10),
    VERSION Number(5),
    "NAME" VarChar2(31),
    ALIASNAME VarChar2(31),
    TYPEID Number(10),
    MISCINFO1 Number(10),
    MISCINFO2 Number(10),
    SRCOBJID Number(10),
    SRCVERSION Number(5),
    DESTOBJID Number(10),
    DESTVERSION Number(5),
    OUTOFDATE VarChar2(1),
    CREATEDATE Date,
    LASTUPDATE Date,
    INFOBLOB BLOB,
    MISCINFO3 Number(10)
)
/

CREATE TABLE LOGIC_021.DISTRITOS (
    CDISTRI VarChar2(3) NOT NULL,
    NDISTRI VarChar2(50),
    CCANTON VarChar2(3) NOT NULL,
    CPROV VarChar2(2) NOT NULL,
    CPAIS VarChar2(3) NOT NULL,
    CONSTRAINT PK_DISTRITOS PRIMARY KEY (
      CDISTRI,
      CCANTON,
      CPROV,
      CPAIS
    )
)
/

CREATE TABLE LOGIC_021.DROITS (
    DROIT Char(4) NOT NULL,
    LIB Char(25),
    SOCIO Char(1) DEFAULT 'F' NOT NULL,
    NUEVOSOCIO Char(1) DEFAULT 'F' NOT NULL,
    CONSULTSOCIO Char(1) DEFAULT 'F' NOT NULL,
    MODIFSOCIO Char(1) DEFAULT 'F' NOT NULL,
    MODIFINTERNET Char(1) DEFAULT 'F' NOT NULL,
    CAMBIOSERV Char(1) DEFAULT 'F' NOT NULL,
    REACTIV Char(1) DEFAULT 'F' NOT NULL,
    COMPLETEOT Char(1) DEFAULT 'F' NOT NULL,
    MODIFOT Char(1) DEFAULT 'F' NOT NULL,
    DESCO Char(1) DEFAULT 'F' NOT NULL,
    RECO Char(1) DEFAULT 'F' NOT NULL,
    TRASLADO Char(1) DEFAULT 'F' NOT NULL,
    COLILLA Char(1) DEFAULT 'F' NOT NULL,
    CONTA Char(1) DEFAULT 'F' NOT NULL,
    FACTURA Char(1) DEFAULT 'F' NOT NULL,
    PAGOCONLOTE Char(1) DEFAULT 'F' NOT NULL,
    REIMBULSO Char(1) DEFAULT 'F' NOT NULL,
    NOTACRED Char(1) DEFAULT 'F' NOT NULL,
    DEVUELTO Char(1) DEFAULT 'F' NOT NULL,
    NOTADEBITO Char(1) DEFAULT 'F' NOT NULL,
    PAGOSINLOTE Char(1) DEFAULT 'F' NOT NULL,
    RECONCIL Char(1) DEFAULT 'F' NOT NULL,
    LOTECAJA Char(1) DEFAULT 'F' NOT NULL,
    TRANSFCAJA Char(1) DEFAULT 'F' NOT NULL,
    CIERRE Char(1) DEFAULT 'F' NOT NULL,
    LOTENC Char(1) DEFAULT 'F' NOT NULL,
    TRANSFNC Char(1) DEFAULT 'F' NOT NULL,
    EDICION Char(1) DEFAULT 'F' NOT NULL,
    EDTCOBRADOR Char(1) DEFAULT 'F' NOT NULL,
    EXPORT Char(1) DEFAULT 'F' NOT NULL,
    PREMIUM Char(1) DEFAULT 'F' NOT NULL,
    TERMINAL Char(1) DEFAULT 'F' NOT NULL,
    PELICULAS Char(1) DEFAULT 'F' NOT NULL,
    COBRADOR Char(1) DEFAULT 'F' NOT NULL,
    MODIFLOTECOB Char(1) DEFAULT 'F' NOT NULL,
    MODIFCOB Char(1) DEFAULT 'F' NOT NULL,
    COBCREARCHIVO Char(1) DEFAULT 'F' NOT NULL,
    COBTRANSARCHIVO Char(1) DEFAULT 'F' NOT NULL,
    FACTPRORAT Char(1) DEFAULT 'F' NOT NULL,
    RED Char(1) DEFAULT 'F' NOT NULL,
    FACTURACION Char(1) DEFAULT 'F' NOT NULL,
    EDTSOCIO Char(1) DEFAULT 'F' NOT NULL,
    EDTCLIENTE Char(1) DEFAULT 'F' NOT NULL,
    EDTCONTA Char(1) DEFAULT 'F' NOT NULL,
    EDTRED Char(1) DEFAULT 'F' NOT NULL,
    EDTDIVERSO Char(1) DEFAULT 'F' NOT NULL,
    EDTOT Char(1) DEFAULT 'F' NOT NULL,
    ADMINISTRACION Char(1) DEFAULT 'F' NOT NULL,
    AGENDA Char(1) DEFAULT 'F' NOT NULL,
    PARAMETRO Char(1) DEFAULT 'F' NOT NULL,
    DECOFALTAPAGO Char(1) DEFAULT 'F' NOT NULL,
    CAMBIODIR Char(1) DEFAULT 'F' NOT NULL,
    CONSTRAINT PK_DROITS PRIMARY KEY (
      DROIT
    )
)
/

CREATE TABLE LOGIC_021.ECRITCPT (
    NUMPIECE Number(10) NOT NULL,
    NUMABONNE Number(10),
    PERIODE Char(7),
    DTCPT Date,
    DTSAISIE Date,
    NUMJRNL Char(3),
    LIB VarChar2(50),
    NUMFACT Number(10),
    MTTDEB Unknown,
    MTTCRED Unknown,
    MDRGLT Char(4),
    MOTIFIMP Char(4),
    CODOPE Char(10),
    ENCAISSE Unknown,
    RESTE Unknown,
    CODINSEE Char(5),
    TYPEC Char(4),
    CBOR Char(4),
    RESUMANU Number(10),
    NUMLOTE VarChar2(10),
    NUMFACTURA Number(10),
    RECONCIL Char(1),
    IMPRESO VarChar2(1),
    WORKTO Char(4),
    FACTURA VarChar2(8),
    FECHA_DESDE Date,
    FECHA_HASTA Date,
    CODIGODEPAGO Number(10),
    CONSTRAINT PK_ECRITCPT PRIMARY KEY (
      NUMPIECE
    )
)
/

CREATE TABLE LOGIC_021.ESTADO_NODO (
    ESTADO Number(10) NOT NULL,
    DETALLE VarChar2(20),
    TIPO VarChar2(1),
    CONSTRAINT PK_ESTADO_NODO PRIMARY KEY (
      ESTADO
    )
)
/

CREATE TABLE LOGIC_021.ESTCTA_031 (
    NUMABONNE Number(10) NOT NULL,
    NUMSOUSCRIPT Number(10),
    NOM VarChar2(50),
    ADRESSE VarChar2(100),
    PERIODE Char(7),
    DT Date,
    TITULOSALDO VarChar2(20),
    SOLDMESANTES Unknown,
    SERVICIO1 VarChar2(25),
    SERVMTT1 Unknown,
    SERVICIO2 VarChar2(25),
    SERVMTT2 Unknown,
    SERVICIO3 VarChar2(25),
    SERVMTT3 Unknown,
    SERVICIO4 VarChar2(25),
    SERVMTT4 Unknown,
    NUEVOSALDO Unknown,
    RUTA Number(10),
    VENCIMIENTO Date,
    TELDOM VarChar2(14),
    DESDE Date,
    HASTA Date,
    MTT5 Unknown,
    CBOR Char(4),
    PAGODESPUES Unknown,
    MULTAPLICADA Char(4),
    NUEVOSALDOCOL Unknown,
    PAGOOFICINA Char(10),
    FACTURA Number(10),
    SERVICIO5 VarChar2(25),
    SERVMTT5 Unknown,
    SERVICIO6 VarChar2(25),
    SERVMTT6 Unknown,
    SERVICIO7 VarChar2(25),
    SERVMTT7 Unknown,
    SERVICIO8 VarChar2(25),
    SERVMTT8 Unknown,
    SERVICIO9 VarChar2(25),
    SERVMTT9 Unknown,
    SERVICIO10 VarChar2(25),
    SERVMTT10 Unknown,
    MULTA Unknown,
    FACTURA_TC Number(10),
    MONTO_MULTA Unknown,
    MONTO_FACTURA Unknown,
    MONTO_FACTURA_TC Unknown,
    NOTA_CRED1 VarChar2(50),
    MTT_NOTA_CRED1 Unknown,
    NOTA_CRED2 VarChar2(50),
    MTT_NOTA_CRED2 Unknown,
    NOTA_CRED3 VarChar2(50),
    MTT_NOTA_CRED3 Unknown,
    NOTA_CREDTC1 VarChar2(50),
    MTT_NOTA_CREDTC1 Unknown,
    NOTA_CREDTC2 VarChar2(50),
    MTT_NOTA_CREDTC2 Unknown,
    NOTA_CREDTC3 VarChar2(50),
    MTT_NOTA_CREDTC3 Unknown,
    QTYS1 Number(5),
    QTYS2 Number(5),
    QTYS3 Number(5),
    QTYS4 Number(5),
    QTYS5 Number(5),
    QTYS6 Number(5),
    QTYS7 Number(5),
    QTYS8 Number(5),
    QTYS9 Number(5),
    QTYS10 Number(5),
    TOTAL_IMPUESTOS Unknown,
    ASUJETI Char(4),
    MONTOMES Unknown,
    DESDE1 Date,
    HASTA1 Date,
    CODPROD1 Char(4),
    CODPROD2 Char(4),
    CODPROD3 Char(4),
    CODPROD4 Char(4),
    CODPROD5 Char(4),
    CODPROD6 Char(4),
    CODPROD7 Char(4),
    CODPROD8 Char(4),
    CODPROD9 Char(4),
    CODPROD10 Char(4),
    ASUJETIV Char(1) DEFAULT 'F' NOT NULL,
    ULT_PAGO Date
)
/

CREATE TABLE LOGIC_021.FACTRECIBO (
    NUMABONNE Number(10) NOT NULL,
    NUMSOUSCRIPT Number(10),
    NOMBREPAGADOR VarChar2(50),
    ADRESSE VarChar2(100),
    PERIODE Char(7),
    RUTA Number(10),
    TELDOM VarChar2(14),
    NOMBRECBOR VarChar2(25),
    SERV0 VarChar2(25),
    MTT0 Unknown,
    MTT0G Unknown,
    MTTDOL0 Unknown,
    SERV1 VarChar2(25),
    MTT1 Unknown,
    MTT1G Unknown,
    MTTDOL1 Unknown,
    SERV2 VarChar2(25),
    MTT2 Unknown,
    MTT2G Unknown,
    MTTDOL2 Unknown,
    SERV3 VarChar2(25),
    MTT3 Unknown,
    MTT3G Unknown,
    MTTDOL3 Unknown,
    SERV4 VarChar2(25),
    MTT4 Unknown,
    MTT4G Unknown,
    MTTDOL4 Unknown,
    SERV5 VarChar2(25),
    MTT5 Unknown,
    MTT5G Unknown,
    MTTDOL5 Unknown,
    SERV6 VarChar2(25),
    MTT6 Unknown,
    MTT6G Unknown,
    MTTDOL6 Unknown,
    SERV7 VarChar2(25),
    MTT7 Unknown,
    MTT7G Unknown,
    MTTDOL7 Unknown,
    SERV8 VarChar2(25),
    MTT8 Unknown,
    MTT8G Unknown,
    MTTDOL8 Unknown,
    SERV9 VarChar2(25),
    MTT9 Unknown,
    MTT9G Unknown,
    MTTDOL9 Unknown,
    SERV10 VarChar2(25),
    MTT10 Unknown,
    MTT10G Unknown,
    MTTDOL10 Unknown,
    SERV11 VarChar2(25),
    MTT11 Unknown,
    MTT11G Unknown,
    MTTDOL11 Unknown,
    TVAPROD Unknown,
    TOTALAPAGAR Unknown,
    DESDEHASTA VarChar2(20),
    FECHASPAGOS Char(36),
    FACTURA Number(10),
    CONSTRAINT PK_FACTRECIBO PRIMARY KEY (
      NUMABONNE
    )
)
/

CREATE TABLE LOGIC_021.HEADEND (
    CODIGO_HEADEND VarChar2(5) NOT NULL,
    NOMBRE_HEADEND VarChar2(25),
    CONSTRAINT PK_HEADEND PRIMARY KEY (
      CODIGO_HEADEND
    )
)
/

CREATE TABLE LOGIC_021.HISTERMINAL (
    NUMHIST Number(10) NOT NULL,
    NUMSERIE Char(15),
    NUMABONNE Number(10),
    FECHAMOVI Date,
    CODOPE VarChar2(10),
    TIPOMOVIMIENTO Char(3),
    "COMMENT" VarChar2(50),
    CONSTRAINT PK_HISTERMINAL PRIMARY KEY (
      NUMHIST
    )
)
/

CREATE TABLE LOGIC_021.HISTORICO_NUMCONTRAT (
    NUMABONNE Number(10) NOT NULL,
    NUMCONTRAT_VIEJO Number(10),
    NOM VarChar2(50),
    CONSTRAINT PK_HISTORICO_NUMCONTRAT PRIMARY KEY (
      NUMABONNE
    )
)
/

CREATE TABLE LOGIC_021.HUB (
    CODIGO_HUB VarChar2(5) NOT NULL,
    NOMBRE_HUB VarChar2(25),
    CODIGO_HEADEND VarChar2(5) NOT NULL,
    CONSTRAINT PK_HUB PRIMARY KEY (
      CODIGO_HUB,
      CODIGO_HEADEND
    )
)
/

CREATE TABLE LOGIC_021.IMPAYE (
    NUMIMP Number(10) NOT NULL,
    NUMPIECE Number(10) NOT NULL,
    NUMABONNE Number(10) NOT NULL,
    PERIODE Date,
    MTT Unknown,
    MOTIF Char(4),
    LIB Char(25),
    DTPAIE Date,
    ESTADO Char(1) DEFAULT 'F' NOT NULL,
    CONSTRAINT PK_IMPAYE PRIMARY KEY (
      NUMIMP
    )
)
/

CREATE TABLE LOGIC_021.INTERNET (
    NUMABONNE Number(10) NOT NULL,
    SYSTEMEOPE VarChar2(11),
    RACSANAME VarChar2(50),
    EQUIPEMENT VarChar2(20),
    CONTACTO VarChar2(25),
    LOGINCOMMUT VarChar2(25),
    CABLEMODEM VarChar2(15),
    RACSANUMCONTRAT Number(10),
    TIPOCABLEMODEM Char(6),
    USERNAME VarChar2(50),
    FECHAVENCE Date,
    ORDRE Number(10),
    CONSTRAINT PK_INTERNET PRIMARY KEY (
      NUMABONNE
    )
)
/

CREATE TABLE LOGIC_021.INTERVENANT (
    CODINT Char(4) NOT NULL,
    NOM VarChar2(42),
    ACTIVIDAD Char(3),
    TIPO Char(4),
    CODINSEE Char(3),
    PRIORIDAD Number(10),
    EMAIL VarChar2(50),
    MSGCORTO VarChar2(50),
    CLAVE VarChar2(10),
    COMISION Unknown,
    COBRA Char(1) DEFAULT 'F' NOT NULL,
    ENLINEA Char(1) DEFAULT 'F' NOT NULL,
    CONSTRAINT PK_INTERVENANT PRIMARY KEY (
      CODINT
    )
)
/

CREATE TABLE LOGIC_021.INTERVENTION (
    NUMINTER Number(10) NOT NULL,
    NUMABONNE Number(10),
    DTDEB Date,
    DTFIN Date,
    HEURE Char(5),
    OPESAISIE Char(10),
    OPEMODIF Char(10),
    MOTIF Char(4),
    PANNE Char(4),
    REPONSE Char(4),
    SIEGE Char(4),
    INTERVENANT Char(4),
    DETMOTIF Char(50),
    DETPANNE Char(50),
    DETREP Char(50),
    LIB Char(25),
    NUMRDV Number(10),
    LATE Char(4),
    HEUREDEB Char(5),
    HEUREFIN Char(5),
    DTCLOS Date,
    DTEDTOR Date,
    HRCLOS Char(5),
    TRASDEB Char(5),
    TRASFIN Char(5),
    TIPO Char(4),
    DTOTAVERIA Date,
    GRUPOLATE Char(4),
    ESTADO Char(1),
    ROLLINICIAL Date,
    ROLLFINAL Date,
    TIPOINSTAL Char(1),
    FECH_CHG_GRUPO Date,
    HORA_CHG_GRUPO Char(5),
    CONSTRAINT PK_INTERVENTION PRIMARY KEY (
      NUMINTER
    )
)
/

CREATE TABLE LOGIC_021.IPSERV (
    NUMIP Number(10) NOT NULL,
    ORDRE Number(10) NOT NULL,
    BLOCKIP VarChar2(19),
    ETHERNETIP VarChar2(15),
    MASKIP VarChar2(15),
    RFIP VarChar2(15),
    CODELUGAR Char(4),
    NUMLUGAR Number(5),
    CONSTRAINT PK_IPSERV PRIMARY KEY (
      NUMIP
    )
)
/

CREATE TABLE LOGIC_021.JOURNAL (
    NUMJRNL Char(3) NOT NULL,
    LIB Char(25),
    TIPOJRNL Char(1),
    CONSTRAINT PK_JOURNAL PRIMARY KEY (
      NUMJRNL
    )
)
/

CREATE TABLE LOGIC_021.LATE (
    CODLATE Char(4) NOT NULL,
    LIB Char(25),
    CONSTRAINT PK_LATE PRIMARY KEY (
      CODLATE
    )
)
/

CREATE TABLE LOGIC_021.LINEUP (
    NUMCANAL Number(10) NOT NULL,
    NOM Char(25),
    CONSTRAINT PK_LINEUP PRIMARY KEY (
      NUMCANAL
    )
)
/

CREATE TABLE LOGIC_021.LOCALIZACION_NODO (
    CODIGO_HEADEND VarChar2(5) NOT NULL,
    CODIGO_HUB VarChar2(5) NOT NULL,
    CODINSEE Char(5) NOT NULL,
    LOCALISATION Char(5) NOT NULL,
    NUMNODE Char(10) NOT NULL,
    CONSTRAINT PK_LOCALIZACION_NODO PRIMARY KEY (
      CODIGO_HEADEND,
      CODIGO_HUB,
      CODINSEE,
      LOCALISATION,
      NUMNODE
    )
)
/

CREATE TABLE LOGIC_021.LOCALIZATION (
    CODINSEE Char(5) NOT NULL,
    LOCALISATION Char(5) NOT NULL,
    LIB VarChar2(25),
    PRINTO Char(4),
    CPAIS VarChar2(3) NOT NULL,
    CPROV VarChar2(3) NOT NULL,
    CCANTON VarChar2(3) NOT NULL,
    CDISTRI VarChar2(3) NOT NULL,
    CONSTRAINT PK_LOCALIZATION PRIMARY KEY (
      CODINSEE,
      LOCALISATION
    )
)
/

CREATE TABLE LOGIC_021.LOGINS (
    NUMLOGIN Number(10) NOT NULL,
    ORDRE Number(10),
    PASSWD VarChar2(20),
    DTSAISIE Date,
    USUARIO VarChar2(50),
    CONSTRAINT PK_LOGINS PRIMARY KEY (
      NUMLOGIN
    )
)
/

CREATE TABLE LOGIC_021.LOGRELOJ (
    ID Number(10) NOT NULL,
    LOGIN Char(10),
    AUTORIZA Char(10),
    FECHA Date,
    HORA Char(10),
    MINUTOS Number(10)
)
/

CREATE TABLE LOGIC_021.LOTE_DESC_RACSA (
    ORDRE Number(10) NOT NULL,
    FECHA_CARGA Date,
    CODOPE VarChar2(10),
    NUMCLIALOPA VarChar2(10),
    ESTADO Char(1) DEFAULT 'F' NOT NULL,
    FECHA_DESCO Date,
    NUMINTER Number(10),
    GESTIONADO VarChar2(1),
    GESTIONO VarChar2(10),
    INTE VarChar2(15) NOT NULL,
    CONSTRAINT PK_LOTE_DESC_RACSA PRIMARY KEY (
      ESTADO,
      INTE
    )
)
/

CREATE TABLE LOGIC_021.LOTE_RECO_RACSA (
    ORDRE Number(10) NOT NULL,
    FECHA_CARGA Date,
    CODOPE VarChar2(10),
    NUMCLIALOPA VarChar2(10),
    ESTADO Char(1) DEFAULT 'F' NOT NULL,
    NUMINTER Number(10),
    INTE VarChar2(15) NOT NULL,
    ESTADO_ORDEN VarChar2(1),
    FECHA_RECO Date,
    CONSTRAINT PK_LOTE_RECO_RACSA PRIMARY KEY (
      ESTADO,
      INTE
    )
)
/

CREATE TABLE LOGIC_021.MATERIAL (
    CODMAT Char(9) NOT NULL,
    NOM Char(25),
    TIPOMAT Char(4),
    PRIX Unknown,
    ORDEN_REPORTE Number(10),
    ACTIVO Char(1) DEFAULT 'F' NOT NULL,
    CONSTRAINT PK_MATERIAL PRIMARY KEY (
      CODMAT
    )
)
/

CREATE TABLE LOGIC_021.MATRIZ_MAX_SERVICIOS (
    CODPROD Char(4) NOT NULL,
    MAXIMO Number(10) NOT NULL,
    CONSTRAINT PK_MATRIZ_MAX_SERVICIOS PRIMARY KEY (
      CODPROD
    )
)
/

CREATE TABLE LOGIC_021.MATRIZ_NO_COMBINA (
    CODPROD Char(4) NOT NULL,
    CODPROD_NO_COMBO Char(4) NOT NULL,
    CONSTRAINT PK_MATRIZ_NO_COMBINA PRIMARY KEY (
      CODPROD,
      CODPROD_NO_COMBO
    )
)
/

CREATE TABLE LOGIC_021.MATRIZ_OPCIONES (
    NUM_OPCION Char(1) NOT NULL,
    DESC_OPCION VarChar2(50),
    CONSTRAINT PK_MATRIZ_OPCIONES PRIMARY KEY (
      NUM_OPCION
    )
)
/

CREATE TABLE LOGIC_021.MATRIZ_REGLAS (
    LN Number(5),
    MAXSERVICIOS Char(1) DEFAULT 'F' NOT NULL,
    NOCOMBINA Char(1) DEFAULT 'F' NOT NULL,
    SERVOBLIGATORIO Char(1) DEFAULT 'F' NOT NULL,
    DEBECOMBINAR Char(1) DEFAULT 'F' NOT NULL
)
/

CREATE TABLE LOGIC_021.MATRIZ_REGLAS_OT (
    NUM_OPCION Char(1) NOT NULL,
    LINEA Number(10) NOT NULL,
    TIPO Char(1),
    GRUPOLATE Char(4),
    CONSTRAINT PK_MATRIZ_REGLAS_OT PRIMARY KEY (
      NUM_OPCION,
      LINEA
    )
)
/

CREATE TABLE LOGIC_021.MATRIZ_SERV_OBLIGATORIO (
    CODPROD Char(4) NOT NULL,
    CONSTRAINT PK_MATRIZ_SERV_OBLIGATORIO PRIMARY KEY (
      CODPROD
    )
)
/

CREATE TABLE LOGIC_021.MATRIZ_SI_COMBINA (
    CODPROD Char(4) NOT NULL,
    CODPROD_SI_COMBO Char(4) NOT NULL,
    CONSTRAINT PK_MATRIZ_SI_COMBINA PRIMARY KEY (
      CODPROD,
      CODPROD_SI_COMBO
    )
)
/

CREATE TABLE LOGIC_021.MOORE (
    NUMABONNE Number(10) NOT NULL,
    NUMSOUSCRIPT Number(10),
    NOM VarChar2(50),
    ADRESSE VarChar2(100),
    PERIODE Char(7),
    DT Date,
    TITULOSALDO VarChar2(20),
    SOLDMESANTES Unknown,
    CODPROD0 Char(4),
    SERVICIO0 VarChar2(25),
    CANT0 Number(10),
    SERVMTT0 Unknown,
    SERVMTTDOL0 Unknown,
    SERVMTT0G Unknown,
    CODPROD1 Char(4),
    SERVICIO1 VarChar2(25),
    CANT1 Number(10),
    SERVMTT1 Unknown,
    SERVMTTDOL1 Unknown,
    SERVMTT1G Unknown,
    CODPROD2 Char(4),
    SERVICIO2 VarChar2(25),
    CANT2 Number(10),
    SERVMTT2 Unknown,
    SERVMTTDOL2 Unknown,
    SERVMTT2G Unknown,
    CODPROD3 Char(4),
    SERVICIO3 VarChar2(25),
    CANT3 Number(10),
    SERVMTT3 Unknown,
    SERVMTTDOL3 Unknown,
    SERVMTT3G Unknown,
    CODPROD4 Char(4),
    SERVICIO4 VarChar2(25),
    CANT4 Number(10),
    SERVMTT4 Unknown,
    SERVMTTDOL4 Unknown,
    SERVMTT4G Unknown,
    CODPROD5 Char(4),
    SERVICIO5 VarChar2(25),
    SERVMTT5 Unknown,
    CANT5 Number(10),
    SERVMTTDOL5 Unknown,
    SERVMTT5G Unknown,
    CODPROD6 Char(4),
    SERVICIO6 VarChar2(25),
    SERVMTT6 Unknown,
    SERVMTTDOL6 Unknown,
    SERVMTT6G Unknown,
    CODPROD7 Char(4),
    SERVICIO7 VarChar2(25),
    CANT7 Number(10),
    SERVMTT7 Unknown,
    SERVMTTDOL7 Unknown,
    SERVMTT7G Unknown,
    CODPROD8 Char(4),
    SERVICIO8 VarChar2(25),
    CANT8 Number(10),
    SERVMTT8 Unknown,
    SERVMTTDOL8 Unknown,
    SERVMTT8G Unknown,
    CODPROD9 Char(4),
    SERVICIO9 VarChar2(25),
    CANT9 Number(10),
    SERVMTT9 Unknown,
    SERVMTTDOL9 Unknown,
    SERVMTT9G Unknown,
    CODPROD10 Char(4),
    SERVICIO10 VarChar2(25),
    CANT10 Number(10),
    SERVMTT10 Unknown,
    SERVMTTDOL10 Unknown,
    SERVMTT10G Unknown,
    CODPROD11 Char(4),
    SERVICIO11 VarChar2(25),
    CANT11 Number(10),
    SERVMTT11 Unknown,
    SERVMTTDOL11 Unknown,
    SERVMTT11G Unknown,
    NUEVOSALDO Unknown,
    RUTA Number(10),
    TELDOM VarChar2(14),
    NOMBRECBOR VarChar2(25),
    SERV0 VarChar2(25),
    MTT0 Unknown,
    MTT0G Unknown,
    SERV1 VarChar2(25),
    MTT1 Unknown,
    MTT1G Unknown,
    SERV2 VarChar2(25),
    MTT2 Unknown,
    MTT2G Unknown,
    SERV3 VarChar2(25),
    MTT3 Unknown,
    MTT3G Unknown,
    SERV4 VarChar2(25),
    MTT4 Unknown,
    MTT4G Unknown,
    SERV5 VarChar2(25),
    MTT5 Unknown,
    MTT5G Unknown,
    SERV6 VarChar2(25),
    MTT6 Unknown,
    MTT6G Unknown,
    SERV7 VarChar2(25),
    MTT7 Unknown,
    MTT7G Unknown,
    SERV8 VarChar2(25),
    MTT8 Unknown,
    MTT8G Unknown,
    SERV9 VarChar2(25),
    MTT9 Unknown,
    MTT9G Unknown,
    SERV10 VarChar2(25),
    MTT10 Unknown,
    MTT10G Unknown,
    SERV11 VarChar2(25),
    MTT11 Unknown,
    MTT11G Unknown,
    TVAPROD Unknown,
    TOTALAPAGAR Unknown,
    CBOR Char(4),
    PAGODESPUES Unknown,
    NOMBREPAGADOR VarChar2(50),
    DESDEHASTA VarChar2(20),
    ULTIMOPAGO Date,
    COLONMESACTUAL Unknown,
    COLONMESANTERIOR Unknown,
    FECHASPAGOS Char(36),
    FACTURA Number(10),
    COMMENT1 Char(60),
    COMMENT2 Char(60),
    LOCALIZATION Char(5),
    CAMBIODIR Char(1) DEFAULT 'F' NOT NULL,
    NUMTAP VarChar2(9),
    CODINSEE Char(3),
    CONSTRAINT PK_MOORE PRIMARY KEY (
      NUMABONNE
    )
)
/

CREATE TABLE LOGIC_021.MOTIF (
    CODMOTIF Char(4) NOT NULL,
    LIB Char(25),
    CODPROD Char(4),
    TIPO Char(2),
    CONSTRAINT PK_MOTIF PRIMARY KEY (
      CODMOTIF
    )
)
/

CREATE TABLE LOGIC_021.NODE (
    NUMNODE Char(10) NOT NULL,
    LIB Char(25),
    NBREABONNE Number(10),
    DOBLEVIA Char(3),
    ACTIVO VarChar2(1),
    CODIFICADO Char(1) DEFAULT 'F' NOT NULL,
    CLASE Char(1),
    FECHA_INIC Date,
    FECHA_FINC Date,
    CANTCABLE Number(10),
    STRAND Number(10),
    CAPACIDAD Number(10),
    KMXNODO Number(10),
    COMENTARIO VarChar2(50),
    COD_ENLACE VarChar2(15),
    DESCRIP_ENLACE VarChar2(30),
    FECHA_ENLACE Date,
    KM_ENLACE Number(10),
    FIBRA_ENLACE Number(10),
    COMENT_ENLACE VarChar2(50),
    PUNTA_INI_ENLACE Number(10),
    PUNTA_FIN_ENLACE Number(10),
    CODIGO_HEADEND VarChar2(5) NOT NULL,
    CODIGO_HUB VarChar2(5) NOT NULL,
    PLAQUEADO VarChar2(1),
    COMENTARIO_ESTADO VarChar2(250),
    ESTADO Number(10) NOT NULL,
    CONSTRAINT PK_NODE PRIMARY KEY (
      NUMNODE,
      CODIGO_HEADEND,
      CODIGO_HUB
    )
)
/

CREATE TABLE LOGIC_021.NODETAP (
    NUMNODE Char(10) NOT NULL,
    TAPINI VarChar2(10) NOT NULL,
    TAPFIN VarChar2(10) NOT NULL,
    CONSTRAINT PK_NODETAP PRIMARY KEY (
      TAPINI,
      TAPFIN
    )
)
/

CREATE TABLE LOGIC_021.PAGOS_EN_LINEA (
    NUMPIECE Number(10) NOT NULL,
    NUMABONNE Number(10) NOT NULL,
    CODIGO_PAGO Number(10) NOT NULL,
    RECAUDADOR VarChar2(10),
    MONTO Unknown,
    FECHA_PAGO Date NOT NULL,
    CONSTRAINT PK_PAGOS_EN_LINEA PRIMARY KEY (
      CODIGO_PAGO
    )
)
/

CREATE TABLE LOGIC_021.PAGOS_EN_LINEA2 (
    NUMPIECE Number(10) NOT NULL,
    NUMABONNE Number(10) NOT NULL,
    CODIGO_PAGO Number(10) NOT NULL,
    RECAUDADOR VarChar2(10),
    MONTO Unknown,
    TIPO VarChar2(1),
    FECHA_PAGO Date NOT NULL,
    CONSTRAINT PK_PAGOS_EN_LINEA2 PRIMARY KEY (
      CODIGO_PAGO
    )
)
/

CREATE TABLE LOGIC_021.PAISES (
    CPAIS VarChar2(3) NOT NULL,
    NPAIS VarChar2(50),
    TIPO Char(1),
    CONSTRAINT PK_PAISES PRIMARY KEY (
      CPAIS
    )
)
/

CREATE TABLE LOGIC_021.PANNE (
    CODPANNE Char(4) NOT NULL,
    LIB Char(25),
    CODPROD Char(4),
    CONSTRAINT PK_PANNE PRIMARY KEY (
      CODPANNE
    )
)
/

CREATE TABLE LOGIC_021.PARAM_COMPA (
    COD_PARAM_COMPA Number(10) NOT NULL,
    DESCRICION BLOB,
    ESTADO BLOB,
    CONSTRAINT PK_PARAM_COMPA PRIMARY KEY (
      COD_PARAM_COMPA
    )
)
/

CREATE TABLE LOGIC_021.PARAMETRE (
    CODTBL Char(4) NOT NULL,
    CODE Char(4) NOT NULL,
    LIBCODE Char(25),
    INFO_REQUE VarChar2(1),
    CONSTRAINT PK_PARAMETRE PRIMARY KEY (
      CODTBL,
      CODE
    )
)
/

CREATE TABLE LOGIC_021.PAYEUR (
    NUMABONNE Number(10) NOT NULL,
    GENRE Char(1),
    NOM VarChar2(50),
    ADRESSE VarChar2(100),
    COMMUNE VarChar2(25),
    TEL VarChar2(14),
    BANQUE VarChar2(25),
    TYPCB Char(4),
    DTEXPIR Char(5),
    "ZONE" Char(5),
    CODCB VarChar2(25),
    NUMID Number(10),
    DTCBDEBUT Date,
    DTCBFIN Date,
    CPROV VarChar2(3),
    CCANTON VarChar2(3),
    CDISTRI VarChar2(3),
    CONSTRAINT PK_PAYEUR PRIMARY KEY (
      NUMABONNE
    )
)
/

CREATE TABLE LOGIC_021.PBSERV (
    ORDRE Number(10) NOT NULL
)
/

CREATE TABLE LOGIC_021.PPVCLASE (
    CODE Char(4) NOT NULL,
    LIBCODE VarChar2(30),
    CONSTRAINT PK_PPVCLASE PRIMARY KEY (
      CODE
    )
)
/

CREATE TABLE LOGIC_021.PPVRATING (
    CODE Char(4) NOT NULL,
    LIBCODE VarChar2(30),
    CONSTRAINT PK_PPVRATING PRIMARY KEY (
      CODE
    )
)
/

CREATE TABLE LOGIC_021.PPVTIPO (
    CODE Char(4) NOT NULL,
    LIBCODE VarChar2(30),
    CONSTRAINT PK_PPVTIPO PRIMARY KEY (
      CODE
    )
)
/

CREATE TABLE LOGIC_021.PRISE (
    NUMABONNE Number(10) NOT NULL,
    CODINT Char(4),
    NUMPLB Char(8),
    DTRACC Date,
    DTCOUPE Date,
    "COMMENT" VarChar2(100),
    NUMTERM VarChar2(9),
    NUMTERM2 VarChar2(9),
    NUMTAP VarChar2(9),
    SORTIETAP Number(5),
    ESTADO Char(1),
    PILOTO Char(1) DEFAULT 'F' NOT NULL,
    OPTICNODE2 VarChar2(20),
    CODIGO_HEADEND VarChar2(5),
    CODIGO_HUB VarChar2(5),
    CODIGO_RAMAL VarChar2(3),
    CODIGO_TAP VarChar2(12),
    OPTICNODE Char(10),
    CONSTRAINT PK_PRISE PRIMARY KEY (
      NUMABONNE
    )
)
/

CREATE TABLE LOGIC_021.PROB (
    NUMABONNE Number(10) NOT NULL,
    SOLDEC Unknown NOT NULL,
    SOLDDETEC Unknown,
    CONSTRAINT PK_PROB PRIMARY KEY (
      NUMABONNE
    )
)
/

CREATE TABLE LOGIC_021.PRODUIT (
    CODPROD Char(4) NOT NULL,
    NOM Char(25),
    PRIX Unknown,
    CODTVA Char(4) NOT NULL,
    JRNLVTE Char(3) NOT NULL,
    JRNLBKE Char(3) NOT NULL,
    NATURE Char(4),
    TAX Unknown,
    CPTNUM Char(20),
    DTDEB Date,
    DTFIN Date,
    PRIXDOL Unknown,
    PAGOMESES Number(5),
    CODINSEE Char(5),
    CTMODIF Char(4),
    CTINST Char(4),
    PRORATEO Char(1) DEFAULT 'F' NOT NULL,
    FALTATERMINAL Char(1) DEFAULT 'F' NOT NULL,
    FACMONTOFIJO Char(1) DEFAULT 'F' NOT NULL,
    DOBLEVIA Char(1) DEFAULT 'F' NOT NULL,
    PERIODICIDAD Number(5),
    FECHA_FIJA Char(1) DEFAULT 'F' NOT NULL,
    PROMOCION Char(1) DEFAULT 'F' NOT NULL,
    TIPO Char(1),
    NUMAPS VarChar2(15),
    ALOPA VarChar2(15),
    PAQRACSA Char(4),
    CONSTRAINT PK_PRODUIT PRIMARY KEY (
      CODPROD
    )
)
/

CREATE TABLE LOGIC_021.PROPSERV (
    ORDRE Number(10) NOT NULL,
    ANCHOBANDA Char(4),
    MEDIOTRANS Char(4),
    METODTRANS Char(4),
    EXCLUSIVIDAD Char(1) DEFAULT 'F' NOT NULL
)
/

CREATE TABLE LOGIC_021.PROVINCIAS (
    CPROV VarChar2(3) NOT NULL,
    NPROV VarChar2(50),
    CPAIS VarChar2(3) NOT NULL,
    CONSTRAINT PK_PROVINCIAS PRIMARY KEY (
      CPROV,
      CPAIS
    )
)
/

CREATE TABLE LOGIC_021.RAMAL (
    CODIGO_RAMAL VarChar2(3) NOT NULL,
    NOMBRE_RAMAL VarChar2(15),
    CODIGO_HEADEND VarChar2(5) NOT NULL,
    CODIGO_HUB VarChar2(5) NOT NULL,
    NUMNODE Char(10) NOT NULL,
    CONSTRAINT PK_RAMAL PRIMARY KEY (
      CODIGO_RAMAL,
      CODIGO_HEADEND,
      CODIGO_HUB,
      NUMNODE
    )
)
/

CREATE TABLE LOGIC_021.RECHABONNE (
    NUMID Number(10) NOT NULL,
    ABONNE Number(10),
    SOUSCRIT Number(10),
    NOM Char(50),
    TEL Char(14),
    NUMCTRT Number(10),
    CONSTRAINT PK_RECHABONNE PRIMARY KEY (
      NUMID
    )
)
/

CREATE TABLE LOGIC_021.RECIBO (
    NUMRECU Number(10) NOT NULL,
    NUMABONNE Number(10) NOT NULL,
    PERIODE Char(7),
    DT Date,
    SERVICIO1 VarChar2(25),
    SERVICIO2 VarChar2(25),
    SERVICIO3 VarChar2(25),
    SERVICIO4 VarChar2(25),
    SERVICIO5 VarChar2(25),
    SERVICIO6 VarChar2(25),
    MTT1 Unknown,
    MTT2 Unknown,
    MTT3 Unknown,
    MTT4 Unknown,
    MTT5 Unknown,
    MTT6 Unknown,
    MTT1G Unknown,
    MTT2G Unknown,
    MTT3G Unknown,
    MTT4G Unknown,
    MTT5G Unknown,
    MTT6G Unknown,
    MTTDOL1 Unknown,
    MTTDOL2 Unknown,
    MTTDOL3 Unknown,
    MTTDOL4 Unknown,
    MTTDOL5 Unknown,
    MTTDOL6 Unknown,
    NUEVOSALDO Unknown,
    PAGODESPUES Unknown,
    SOLDPREC Unknown,
    STATUT Char(3),
    CBOR Char(4),
    PAGOCOBRADOR Unknown,
    PAGOCOBRADORDESPUES Unknown,
    SERVICIO7 VarChar2(25),
    SERVICIO8 VarChar2(25),
    SERVICIO9 VarChar2(25),
    SERVICIO10 VarChar2(25),
    SERVICIO11 VarChar2(25),
    SERVICIO12 VarChar2(25),
    MTT7 Unknown,
    MTT8 Unknown,
    MTT9 Unknown,
    MTT10 Unknown,
    MTT11 Unknown,
    MTT12 Unknown,
    MTT7G Unknown,
    MTT8G Unknown,
    MTT9G Unknown,
    MTT10G Unknown,
    MTT11G Unknown,
    MTT12G Unknown,
    MTTDOL7 Unknown,
    MTTDOL8 Unknown,
    MTTDOL9 Unknown,
    MTTDOL10 Unknown,
    MTTDOL11 Unknown,
    MTTDOL12 Unknown,
    COMMENT1 Char(60),
    CONSTRAINT PK_RECIBO PRIMARY KEY (
      NUMRECU
    )
)
/

CREATE TABLE LOGIC_021.RECU (
    NUMRECU Number(10) NOT NULL,
    NUMABONNE Number(10),
    MDRGT Char(4),
    SOLDE Unknown,
    PERIODE Char(7),
    DTPAIE Date,
    CBOR Char(4),
    CPT Number(10) NOT NULL,
    CODOPE Char(10),
    CODINSEE Char(3),
    CONSTRAINT PK_RECU PRIMARY KEY (
      CPT
    )
)
/

CREATE TABLE LOGIC_021.RECUPIMP (
    NUMABONNE Number(10) NOT NULL,
    MTT Unknown,
    STATUT Char(3),
    TIPOPAGO Char(2),
    NUMRECU Char(8),
    CONSTRAINT PK_RECUPIMP PRIMARY KEY (
      NUMABONNE
    )
)
/

CREATE TABLE LOGIC_021.REPORTES (
    CODIGO Number(10) NOT NULL,
    NOMBRE VarChar2(50)
)
/

CREATE TABLE LOGIC_021.ROLES (
    NUMROLE Number(10) NOT NULL,
    NUMINTER Number(10),
    TIPO Char(4),
    DTSAISIE Date,
    HRSAISIE Char(5),
    OPESAISIE Char(10),
    FECHACITA Date,
    HRCITA Char(5),
    OPEMODIF Char(10),
    FECHAMODIF Date,
    HRMODIF Char(5),
    OBSERVACION VarChar2(40),
    STATUS Char(1) DEFAULT 'F' NOT NULL,
    CODINT Char(4),
    MOVIL Char(6),
    SECTOR Char(1),
    PADRINO Char(10),
    CONSTRAINT PK_ROLES PRIMARY KEY (
      NUMROLE
    )
)
/

CREATE TABLE LOGIC_021.SALDOS_PENDIENTES (
    NUMABONNE Number(10) NOT NULL,
    SALDO Unknown NOT NULL,
    FECHA Date NOT NULL,
    ID_SALDOS_PENDIENTES Number(10) NOT NULL,
    ESTADO VarChar2(1) NOT NULL,
    NUMINTER Number(10),
    NUMPIECE Number(10),
    CONSTRAINT PK_SALDOS_PENDIENTES PRIMARY KEY (
      ID_SALDOS_PENDIENTES
    )
)
/

CREATE TABLE LOGIC_021.SCHEDULEPPV (
    SCHEDID Number(10) NOT NULL,
    LBEN Number(10) NOT NULL,
    CHANNELID Number(5),
    CHANNELNAME VarChar2(30),
    SCHEDSTARTDT Date,
    SCHEDSTARTTI Char(5),
    SCHEDUREE Number(5),
    DTSAISIE Date,
    SCHEDBSID Number(10),
    CONSTRAINT PK_SCHEDULEPPV PRIMARY KEY (
      SCHEDID
    )
)
/

CREATE TABLE LOGIC_021.SECTOR (
    CODIGO Number(10) NOT NULL,
    DESCRIPCION VarChar2(30),
    SECTOR VarChar2(1),
    CONSTRAINT PK_SECTOR PRIMARY KEY (
      CODIGO
    )
)
/

CREATE TABLE LOGIC_021.SERVTERMINAL (
    ORDRE Number(10) NOT NULL,
    CODPROD Char(4),
    NUMSERIE Char(15),
    CONSTRAINT PK_SERVTERMINAL PRIMARY KEY (
      ORDRE
    )
)
/

CREATE TABLE LOGIC_021.SOCIETE (
    NUMSOC Number(5),
    NOM Char(25),
    NBABONNE Number(10),
    AGENCE Char(25),
    NUMRECU Number(10),
    TITULO1 VarChar2(40),
    TITULO2 VarChar2(40),
    TITULO3 VarChar2(40),
    TITULO4 VarChar2(40),
    OFICEID Number(10),
    HEADEND Number(5),
    NOTELDLA Char(15),
    REG_BANCOS Number(5),
    LABL_NIV01 VarChar2(15),
    LABL_NIV02 VarChar2(15),
    LABL_NIV03 VarChar2(15),
    LABL_NIV04 VarChar2(15),
    SOCIOCOLILLA Char(1) DEFAULT 'F' NOT NULL
)
/

CREATE TABLE LOGIC_021.SOLICITUD_CABIO_PRECIO (
    ID Number(10) NOT NULL,
    USUARIO_SOLICITA Char(10) NOT NULL,
    CODPROD Char(4) NOT NULL,
    FECHA_SOLICITUD Date NOT NULL,
    NOMBRE_SOLICITANTE VarChar2(50) NOT NULL,
    FEHA_APLICACION Date,
    NOMBRE_APRUEBA VarChar2(50),
    APROBADO Char(1),
    USUARIO_APROBO VarChar2(10),
    PRECIO_NUEVO Unknown,
    USUARIO_APLICO VarChar2(10),
    FECHA_APROBACION Date,
    APLICADO Char(1),
    TIPO_SOLICITUD Number(10) NOT NULL,
    MONEDA Number(10) NOT NULL,
    CODINSEE Char(5),
    LOCALIZATION Char(5),
    CONSTRAINT PK_SOLICITUD_CABIO_PRECIO PRIMARY KEY (
      ID
    )
)
/

CREATE TABLE LOGIC_021.STATRECO (
    NUMSTATRECO Number(10) NOT NULL,
    NUMABONNE Number(10) NOT NULL,
    DTRECO Date,
    DTRESI Date,
    CONSTRAINT PK_STATRECO PRIMARY KEY (
      NUMSTATRECO
    )
)
/

CREATE TABLE LOGIC_021.TAP (
    CODIGO_TAP Number(10) NOT NULL,
    NOMBRE_TAP VarChar2(25),
    CODIGO_HEADEND VarChar2(5) NOT NULL,
    CODIGO_HUB VarChar2(5) NOT NULL,
    NUMNODE Char(10) NOT NULL,
    CODIGO_RAMAL VarChar2(3) NOT NULL,
    CAPACIDAD Number(10),
    RANGO Number(10),
    PUERTOS Number(10),
    VALOR Number(10),
    MARCA VarChar2(15),
    INTELIGENTE Char(1) DEFAULT 'F' NOT NULL,
    CONSTRAINT PK_TAP PRIMARY KEY (
      CODIGO_TAP,
      CODIGO_HEADEND,
      CODIGO_HUB,
      NUMNODE,
      CODIGO_RAMAL
    )
)
/

CREATE TABLE LOGIC_021.TAPXNODE (
    NUMTAP Char(9) NOT NULL,
    NUMNODE Char(5) NOT NULL,
    RAMAL Char(5) NOT NULL,
    CAPACIDAD Number(5),
    CONSTRAINT PK_TAPXNODE PRIMARY KEY (
      NUMTAP,
      NUMNODE
    )
)
/

CREATE TABLE LOGIC_021.TEMP (
    NUMPIECE Number(10) NOT NULL,
    NUMABONNE Number(10),
    PERIODE Char(7),
    CONSTRAINT PK_TEMP PRIMARY KEY (
      NUMPIECE
    )
)
/

CREATE TABLE LOGIC_021.TEMPCOMPARAINTERNET (
    NUMABONNE Number(10) NOT NULL,
    SERVIDOR VarChar2(5),
    TIPOCABLEMODEM VarChar2(6),
    FECHA Date,
    USUARIO VarChar2(10),
    MSGERROR VarChar2(400)
)
/

CREATE TABLE LOGIC_021.TEMPDETEC (
    NUMTEMP Number(10) NOT NULL,
    CODPROD Char(4) NOT NULL,
    MTT Unknown,
    CODTVA Char(4),
    NUMJRNL Char(3),
    CONSTRAINT PK_TEMPDETEC PRIMARY KEY (
      NUMTEMP,
      CODPROD
    )
)
/

CREATE TABLE LOGIC_021.TEMPDETINTERMAT (
    NUMINTER Number(10) NOT NULL,
    CODMAT Char(9) NOT NULL,
    QTEINST Number(5),
    CONSTRAINT PK_TEMPDETINTERMAT PRIMARY KEY (
      NUMINTER,
      CODMAT
    )
)
/

CREATE TABLE LOGIC_021.TEMPEC (
    NUMTEMP Number(10) NOT NULL,
    NUMABONNE Number(10),
    PERIODE Char(7),
    DTCPT Date,
    DTSAISIE Date,
    NUMJRNL Char(3),
    LIB VarChar2(50),
    NUMFACT Number(10),
    MTTDEB Unknown,
    MTTCRED Unknown,
    MDRGLT Char(4),
    CODOPE Char(10),
    CODINSEE Char(5),
    TYPEC Char(4),
    CBOR Char(4),
    RESUMANU Number(10),
    NUMLOTE VarChar2(10),
    MOTIFIMP Char(4),
    LIBNC VarChar2(50),
    NUMCHQ Char(10),
    BANKCHQ Char(25),
    EMISOR VarChar2(25),
    NUMCARD VarChar2(16),
    NUMAUTORIZ VarChar2(16),
    TARJETAHABIENTE VarChar2(40),
    MILLAS Unknown,
    PAQUETE Char(4),
    CONSTRAINT PK_TEMPEC PRIMARY KEY (
      NUMTEMP
    )
)
/

CREATE TABLE LOGIC_021.TEMPFACTPPV (
    NUMABONNE Number(10),
    MONTO Unknown,
    PELICULAS Number(5)
)
/

CREATE TABLE LOGIC_021.TEMPINTES (
    CUENTARACSA Number(10),
    INTE VarChar2(15),
    LOGIN VarChar2(25),
    PAQUETE Char(4),
    NUMCONTRAT Number(10),
    ORDRE Number(10),
    MOVIM Char(1)
)
/

CREATE TABLE LOGIC_021.TEMPNODE (
    LOCALIZATION Char(5),
    NUMNODO VarChar2(9)
)
/

CREATE TABLE LOGIC_021.TEMPRACSAINTE (
    NUMABONNE Number(10) NOT NULL,
    CUENTARACSA Number(10),
    INTE VarChar2(15),
    LOGIN VarChar2(50),
    PAQRACSA Char(4),
    MSGERROR VarChar2(400)
)
/

CREATE TABLE LOGIC_021.TERMINAL (
    NUMID Number(10),
    NUMSERIE Char(15) NOT NULL,
    MODELO Char(8),
    TIPO Char(2),
    STATUS Char(10),
    PRECIO Unknown,
    DTSAISIE Date,
    PPV Char(3),
    DOBLEVIA Char(3),
    VOLUME Char(3),
    REMOTE Char(3),
    IPPV Char(3),
    FAVORITE Char(3),
    BSID17 Char(3),
    BSID20 Char(3),
    BSID21 Char(3),
    BSID22 Char(3),
    CREDIT Number(5),
    BSID123 Char(3),
    FECHAVENCE Date,
    NUME_PROMO Number(5),
    NUME_PROVI Number(5),
    HUB Char(1),
    CONSTRAINT PK_TERMINAL PRIMARY KEY (
      NUMSERIE
    )
)
/

CREATE TABLE LOGIC_021.TERMINALBSID (
    NUMSERIE VarChar2(15) NOT NULL,
    BSID Char(5) NOT NULL,
    CONSTRAINT PK_TERMINALBSID PRIMARY KEY (
      NUMSERIE,
      BSID
    )
)
/

CREATE TABLE LOGIC_021.TITLEPPV (
    LBEN Number(10) NOT NULL,
    MOVIENAME VarChar2(80),
    DUREE Number(5),
    RATING Number(5),
    TIPOEVENT Number(5),
    DTSAISIE Date,
    PRIX Unknown,
    GENREEVENT Number(5),
    MOVIENAMEDLA VarChar2(80),
    CONSTRAINT PK_TITLEPPV PRIMARY KEY (
      LBEN
    )
)
/

CREATE TABLE LOGIC_021.TRANSACDLA (
    NUMTRANSACDLA Number(10) NOT NULL,
    DTSAISIE Date,
    HEURETRANSAC Char(8),
    ENVOITRANSAC VarChar2(250),
    OPETRANSAC Char(10),
    RECUTRANSAC VarChar2(150),
    CONSTRAINT PK_TRANSACDLA PRIMARY KEY (
      NUMTRANSACDLA
    )
)
/

CREATE TABLE LOGIC_021.TRANSACPPV (
    NUMTRANSACDLA Number(10) NOT NULL,
    DTSAISIE Date,
    HEURETRANSAC Char(8),
    OPETRANSAC Char(10),
    RECUTRANSAC Char(250),
    CONSTRAINT PK_TRANSACPPV PRIMARY KEY (
      NUMTRANSACDLA
    )
)
/

CREATE TABLE LOGIC_021.TYPPARA (
    CODTBL Char(4) NOT NULL,
    LIB Char(25),
    CONSTRAINT PK_TYPPARA PRIMARY KEY (
      CODTBL
    )
)
/

CREATE TABLE LOGIC_021.TYPTVA (
    CODTVA Char(4) NOT NULL,
    LIB Char(25),
    TAUX Unknown,
    DIVISOR Unknown,
    CONSTRAINT PK_TYPTVA PRIMARY KEY (
      CODTVA
    )
)
/

CREATE TABLE LOGIC_021.UTILISATEUR (
    LOGIN Char(10) NOT NULL,
    PASSE Char(10),
    DROIT Char(4),
    LIB Char(50),
    DATE_PASSWORD Date,
    DATE_CIERRE Date,
    DATE_LOGIN Date,
    HEURE_LOGIN Char(5),
    FECHASALIDA Date,
    EMAIL VarChar2(50),
    WORKTO Char(4),
    PRIORIDAD Number(10),
    CASILLERO VarChar2(20),
    CAMBIA_RELOJ VarChar2(1),
    CLAVE_EMAIL VarChar2(12),
    ALOPA Char(1) DEFAULT 'F' NOT NULL,
    CONSTRAINT PK_UTILISATEUR PRIMARY KEY (
      LOGIN
    )
)
/

CREATE TABLE LOGIC_021.VENTE (
    ORDRE Number(10) NOT NULL,
    NUMABONNE Number(10) NOT NULL,
    CODPROD Char(4),
    MTT Unknown,
    CODVEND Char(4),
    CODPROV Char(4),
    DTSAISIE Date,
    DTSIGN Date,
    DTMENS Date,
    DTPAIE Date,
    DTRESI Date,
    CODRESI Char(4),
    DTCHGTTF Date,
    CTINST Unknown,
    CTREDUC Unknown,
    MTTDOL Unknown,
    QTEDMD Number(5),
    QTEREA Number(5),
    STATUT Char(1) DEFAULT 'F' NOT NULL,
    CODMARK Char(4),
    FACTPRORAT Char(1) DEFAULT 'F' NOT NULL,
    INTE VarChar2(15),
    NUM_DOCU Number(10),
    DTRESI2 Date,
    CONSTRAINT PK_VENTE PRIMARY KEY (
      ORDRE
    )
)
/

CREATE TABLE LOGIC_021.VISITE (
    NUMVISITE Number(10) NOT NULL,
    NUMABONNE Number(10),
    DTSAISIE Date,
    LIB VarChar2(50),
    CONSTRAINT PK_VISITE PRIMARY KEY (
      NUMVISITE
    )
)
/

CREATE TABLE LOGIC_021.VTE (
    NUMABONNE Number(10) NOT NULL,
    CODPROD Char(4) NOT NULL,
    NOM Char(25),
    MTT Unknown,
    PAIE Unknown
)
/

/*******************************************************************************
 * Indices
 * -------
 * Extracted at 08/08/2005 11:45:19 a.m.
 ******************************************************************************/

CREATE INDEX LOGIC_021.ABONNEINDEX1
 ON LOGIC_021.ABONNE(NUMCONTRAT)
 PCTFREE 10 INITRANS 2 MAXTRANS 255
 STORAGE (
    INITIAL         64K
    MINEXTENTS      1
    MAXEXTENTS      2147483645
 )
 LOGGING
 TABLESPACE LOGIC_021
/

CREATE INDEX LOGIC_021.ABONNEINDEX2
 ON LOGIC_021.ABONNE(CBOR)
 PCTFREE 10 INITRANS 2 MAXTRANS 255
 STORAGE (
    INITIAL         64K
    MINEXTENTS      1
    MAXEXTENTS      2147483645
 )
 LOGGING
 TABLESPACE LOGIC_021
/

CREATE INDEX LOGIC_021.ABONNEINDEX3
 ON LOGIC_021.ABONNE(LOCALIZATION)
 PCTFREE 10 INITRANS 2 MAXTRANS 255
 STORAGE (
    INITIAL         64K
    MINEXTENTS      1
    MAXEXTENTS      2147483645
 )
 LOGGING
 TABLESPACE LOGIC_021
/

CREATE INDEX LOGIC_021.ABONNEINDEX4
 ON LOGIC_021.ABONNE(NOM)
 PCTFREE 10 INITRANS 2 MAXTRANS 255
 STORAGE (
    INITIAL         64K
    MINEXTENTS      1
    MAXEXTENTS      2147483645
 )
 LOGGING
 TABLESPACE LOGIC_021
/

CREATE INDEX LOGIC_021.ABONNEPPVINDEX1
 ON LOGIC_021.ABONNEPPV(NUMEVENT)
 PCTFREE 10 INITRANS 2 MAXTRANS 255
 STORAGE (
    INITIAL         64K
    MINEXTENTS      1
    MAXEXTENTS      2147483645
 )
 LOGGING
 TABLESPACE LOGIC_021
/

CREATE INDEX LOGIC_021.ABONNEPPVINDEX2
 ON LOGIC_021.ABONNEPPV(NUMABONNE)
 PCTFREE 10 INITRANS 2 MAXTRANS 255
 STORAGE (
    INITIAL         64K
    MINEXTENTS      1
    MAXEXTENTS      2147483645
 )
 LOGGING
 TABLESPACE LOGIC_021
/

CREATE INDEX LOGIC_021.AGINDEX1
 ON LOGIC_021.AG(SOLD5 DESC)
 PCTFREE 10 INITRANS 2 MAXTRANS 255
 STORAGE (
    INITIAL         64K
    MINEXTENTS      1
    MAXEXTENTS      2147483645
 )
 LOGGING
 TABLESPACE LOGIC_021
/

CREATE INDEX LOGIC_021.AVERINTERNETINDEX2
 ON LOGIC_021.AVERINTERNET(NUMABONNE)
 PCTFREE 10 INITRANS 2 MAXTRANS 255
 STORAGE (
    INITIAL         64K
    MINEXTENTS      1
    MAXEXTENTS      2147483645
 )
 LOGGING
 TABLESPACE LOGIC_021
/

CREATE INDEX LOGIC_021.AVERINTERNETINDEX3
 ON LOGIC_021.AVERINTERNET(NUMOT)
 PCTFREE 10 INITRANS 2 MAXTRANS 255
 STORAGE (
    INITIAL         64K
    MINEXTENTS      1
    MAXEXTENTS      2147483645
 )
 LOGGING
 TABLESPACE LOGIC_021
/

CREATE INDEX LOGIC_021.AVERINTERNETINDEX4
 ON LOGIC_021.AVERINTERNET(NUMCASO)
 PCTFREE 10 INITRANS 2 MAXTRANS 255
 STORAGE (
    INITIAL         64K
    MINEXTENTS      1
    MAXEXTENTS      2147483645
 )
 LOGGING
 TABLESPACE LOGIC_021
/

CREATE INDEX LOGIC_021.BLOCNOTEINDEX1
 ON LOGIC_021.BLOCNOTE(NUMABONNE)
 PCTFREE 10 INITRANS 2 MAXTRANS 255
 STORAGE (
    INITIAL         64K
    MINEXTENTS      1
    MAXEXTENTS      2147483645
 )
 LOGGING
 TABLESPACE LOGIC_021
/

CREATE INDEX LOGIC_021.BLOCNOTEINDEX2
 ON LOGIC_021.BLOCNOTE(DTSAISIE)
 PCTFREE 10 INITRANS 2 MAXTRANS 255
 STORAGE (
    INITIAL         64K
    MINEXTENTS      1
    MAXEXTENTS      2147483645
 )
 LOGGING
 TABLESPACE LOGIC_021
/

CREATE INDEX LOGIC_021.CAJAPRINCINDEX1
 ON LOGIC_021.CAJAPRINC(DTCPT)
 PCTFREE 10 INITRANS 2 MAXTRANS 255
 STORAGE (
    INITIAL         64K
    MINEXTENTS      1
    MAXEXTENTS      2147483645
 )
 LOGGING
 TABLESPACE LOGIC_021
/

CREATE INDEX LOGIC_021.CAJAPRINCINDEX2
 ON LOGIC_021.CAJAPRINC(CODOPE)
 PCTFREE 10 INITRANS 2 MAXTRANS 255
 STORAGE (
    INITIAL         64K
    MINEXTENTS      1
    MAXEXTENTS      2147483645
 )
 LOGGING
 TABLESPACE LOGIC_021
/

CREATE INDEX LOGIC_021.CDDTRCONDIINDEX1
 ON LOGIC_021.CDDTRCONDI(FECHA)
 PCTFREE 10 INITRANS 2 MAXTRANS 255
 STORAGE (
    INITIAL         64K
    MINEXTENTS      1
    MAXEXTENTS      2147483645
 )
 LOGGING
 TABLESPACE LOGIC_021
/

CREATE INDEX LOGIC_021.CDDTRCONDIINDEX2
 ON LOGIC_021.CDDTRCONDI(TELEFONO)
 PCTFREE 10 INITRANS 2 MAXTRANS 255
 STORAGE (
    INITIAL         64K
    MINEXTENTS      1
    MAXEXTENTS      2147483645
 )
 LOGGING
 TABLESPACE LOGIC_021
/

CREATE INDEX LOGIC_021.CDDTRCONDIINDEX3
 ON LOGIC_021.CDDTRCONDI(NUMABONNE)
 PCTFREE 10 INITRANS 2 MAXTRANS 255
 STORAGE (
    INITIAL         64K
    MINEXTENTS      1
    MAXEXTENTS      2147483645
 )
 LOGGING
 TABLESPACE LOGIC_021
/

CREATE INDEX LOGIC_021.COMPARAINTERNETINDEX1
 ON LOGIC_021.TEMPCOMPARAINTERNET(NUMABONNE)
 PCTFREE 10 INITRANS 2 MAXTRANS 255
 STORAGE (
    INITIAL         64K
    MINEXTENTS      1
    MAXEXTENTS      2147483645
 )
 LOGGING
 TABLESPACE LOGIC_021
/

CREATE INDEX LOGIC_021.CONTRATINDEX1
 ON LOGIC_021.CONTRAT(DTRESI)
 PCTFREE 10 INITRANS 2 MAXTRANS 255
 STORAGE (
    INITIAL         64K
    MINEXTENTS      1
    MAXEXTENTS      2147483645
 )
 LOGGING
 TABLESPACE LOGIC_021
/

CREATE INDEX LOGIC_021.CONTRATINDEX2
 ON LOGIC_021.CONTRAT(CODVDS)
 PCTFREE 10 INITRANS 2 MAXTRANS 255
 STORAGE (
    INITIAL         64K
    MINEXTENTS      1
    MAXEXTENTS      2147483645
 )
 LOGGING
 TABLESPACE LOGIC_021
/

CREATE INDEX LOGIC_021.CORREOSINDEX1
 ON LOGIC_021.CORREOS(NUMINTER)
 PCTFREE 10 INITRANS 2 MAXTRANS 255
 STORAGE (
    INITIAL         64K
    MINEXTENTS      1
    MAXEXTENTS      2147483645
 )
 LOGGING
 TABLESPACE LOGIC_021
/

CREATE INDEX LOGIC_021.CORREOSINDEX2
 ON LOGIC_021.CORREOS(ORDRE)
 PCTFREE 10 INITRANS 2 MAXTRANS 255
 STORAGE (
    INITIAL         64K
    MINEXTENTS      1
    MAXEXTENTS      2147483645
 )
 LOGGING
 TABLESPACE LOGIC_021
/

CREATE INDEX LOGIC_021.DECOLUNESINDEX1
 ON LOGIC_021.DECOLUNES(JOUR)
 PCTFREE 10 INITRANS 2 MAXTRANS 255
 STORAGE (
    INITIAL         64K
    MINEXTENTS      1
    MAXEXTENTS      2147483645
 )
 LOGGING
 TABLESPACE LOGIC_021
/

CREATE INDEX LOGIC_021.DETECINDEX1
 ON LOGIC_021.DETEC(NUMPIECE)
 PCTFREE 10 INITRANS 2 MAXTRANS 255
 STORAGE (
    INITIAL         64K
    MINEXTENTS      1
    MAXEXTENTS      2147483645
 )
 LOGGING
 TABLESPACE LOGIC_021
/

CREATE INDEX LOGIC_021.DETECINDEX2
 ON LOGIC_021.DETEC(CODPROD)
 PCTFREE 10 INITRANS 2 MAXTRANS 255
 STORAGE (
    INITIAL         64K
    MINEXTENTS      1
    MAXEXTENTS      2147483645
 )
 LOGGING
 TABLESPACE LOGIC_021
/

CREATE INDEX LOGIC_021.DETINTERINDEX1
 ON LOGIC_021.DETINTER(NUMINTER)
 PCTFREE 10 INITRANS 2 MAXTRANS 255
 STORAGE (
    INITIAL         64K
    MINEXTENTS      1
    MAXEXTENTS      2147483645
 )
 LOGGING
 TABLESPACE LOGIC_021
/

CREATE INDEX LOGIC_021.DETINTERINDEX2
 ON LOGIC_021.DETINTER(CODPROD)
 PCTFREE 10 INITRANS 2 MAXTRANS 255
 STORAGE (
    INITIAL         64K
    MINEXTENTS      1
    MAXEXTENTS      2147483645
 )
 LOGGING
 TABLESPACE LOGIC_021
/

CREATE INDEX LOGIC_021.ECRITCPTINDEX1
 ON LOGIC_021.ECRITCPT(DTSAISIE)
 PCTFREE 10 INITRANS 2 MAXTRANS 255
 STORAGE (
    INITIAL         64K
    MINEXTENTS      1
    MAXEXTENTS      2147483645
 )
 LOGGING
 TABLESPACE LOGIC_021
/

CREATE INDEX LOGIC_021.ECRITCPTINDEX2
 ON LOGIC_021.ECRITCPT(NUMABONNE)
 PCTFREE 10 INITRANS 2 MAXTRANS 255
 STORAGE (
    INITIAL         64K
    MINEXTENTS      1
    MAXEXTENTS      2147483645
 )
 LOGGING
 TABLESPACE LOGIC_021
/

CREATE INDEX LOGIC_021.ECRITCPTINDEX3
 ON LOGIC_021.ECRITCPT(RESUMANU)
 PCTFREE 10 INITRANS 2 MAXTRANS 255
 STORAGE (
    INITIAL         64K
    MINEXTENTS      1
    MAXEXTENTS      2147483645
 )
 LOGGING
 TABLESPACE LOGIC_021
/

CREATE INDEX LOGIC_021.ECRITCPTINDEX4
 ON LOGIC_021.ECRITCPT(PERIODE)
 PCTFREE 10 INITRANS 2 MAXTRANS 255
 STORAGE (
    INITIAL         64K
    MINEXTENTS      1
    MAXEXTENTS      2147483645
 )
 LOGGING
 TABLESPACE LOGIC_021
/

CREATE INDEX LOGIC_021.ECRITCPTINDEX5
 ON LOGIC_021.ECRITCPT(MOTIFIMP)
 PCTFREE 10 INITRANS 2 MAXTRANS 255
 STORAGE (
    INITIAL         64K
    MINEXTENTS      1
    MAXEXTENTS      2147483645
 )
 LOGGING
 TABLESPACE LOGIC_021
/

CREATE INDEX LOGIC_021.HISTERMINALINDEX1
 ON LOGIC_021.HISTERMINAL(NUMABONNE)
 PCTFREE 10 INITRANS 2 MAXTRANS 255
 STORAGE (
    INITIAL         64K
    MINEXTENTS      1
    MAXEXTENTS      2147483645
 )
 LOGGING
 TABLESPACE LOGIC_021
/

CREATE INDEX LOGIC_021.HISTERMINALINDEX2
 ON LOGIC_021.HISTERMINAL(NUMSERIE)
 PCTFREE 10 INITRANS 2 MAXTRANS 255
 STORAGE (
    INITIAL         64K
    MINEXTENTS      1
    MAXEXTENTS      2147483645
 )
 LOGGING
 TABLESPACE LOGIC_021
/

CREATE INDEX LOGIC_021.IMPAYEINDEX1
 ON LOGIC_021.IMPAYE(NUMABONNE)
 PCTFREE 10 INITRANS 2 MAXTRANS 255
 STORAGE (
    INITIAL         64K
    MINEXTENTS      1
    MAXEXTENTS      2147483645
 )
 LOGGING
 TABLESPACE LOGIC_021
/

CREATE INDEX LOGIC_021.INTERVENTIONINDEX1
 ON LOGIC_021.INTERVENTION(DTDEB)
 PCTFREE 10 INITRANS 2 MAXTRANS 255
 STORAGE (
    INITIAL         64K
    MINEXTENTS      1
    MAXEXTENTS      2147483645
 )
 LOGGING
 TABLESPACE LOGIC_021
/

CREATE INDEX LOGIC_021.INTERVENTIONINDEX2
 ON LOGIC_021.INTERVENTION(NUMABONNE)
 PCTFREE 10 INITRANS 2 MAXTRANS 255
 STORAGE (
    INITIAL         64K
    MINEXTENTS      1
    MAXEXTENTS      2147483645
 )
 LOGGING
 TABLESPACE LOGIC_021
/

CREATE INDEX LOGIC_021.INTERVENTIONINDEX3
 ON LOGIC_021.INTERVENTION(DTCLOS)
 PCTFREE 10 INITRANS 2 MAXTRANS 255
 STORAGE (
    INITIAL         64K
    MINEXTENTS      1
    MAXEXTENTS      2147483645
 )
 LOGGING
 TABLESPACE LOGIC_021
/

CREATE INDEX LOGIC_021.INTERVENTIONINDEX5
 ON LOGIC_021.INTERVENTION(DTFIN)
 PCTFREE 10 INITRANS 2 MAXTRANS 255
 STORAGE (
    INITIAL         64K
    MINEXTENTS      1
    MAXEXTENTS      2147483645
 )
 LOGGING
 TABLESPACE LOGIC_021
/

CREATE INDEX LOGIC_021.INTERVENTIONINDEX6
 ON LOGIC_021.INTERVENTION(DTOTAVERIA)
 PCTFREE 10 INITRANS 2 MAXTRANS 255
 STORAGE (
    INITIAL         64K
    MINEXTENTS      1
    MAXEXTENTS      2147483645
 )
 LOGGING
 TABLESPACE LOGIC_021
/

CREATE INDEX LOGIC_021.INTERVENTIONINDEX7
 ON LOGIC_021.INTERVENTION(DTEDTOR)
 PCTFREE 10 INITRANS 2 MAXTRANS 255
 STORAGE (
    INITIAL         64K
    MINEXTENTS      1
    MAXEXTENTS      2147483645
 )
 LOGGING
 TABLESPACE LOGIC_021
/

CREATE INDEX LOGIC_021.IPSERVINDEX1
 ON LOGIC_021.IPSERV(ORDRE)
 PCTFREE 10 INITRANS 2 MAXTRANS 255
 STORAGE (
    INITIAL         64K
    MINEXTENTS      1
    MAXEXTENTS      2147483645
 )
 LOGGING
 TABLESPACE LOGIC_021
/

CREATE INDEX LOGIC_021.LOGINSINDEX1
 ON LOGIC_021.LOGINS(ORDRE)
 PCTFREE 10 INITRANS 2 MAXTRANS 255
 STORAGE (
    INITIAL         64K
    MINEXTENTS      1
    MAXEXTENTS      2147483645
 )
 LOGGING
 TABLESPACE LOGIC_021
/

CREATE INDEX LOGIC_021.MATRIZ_NO_COMBINAINDEX1
 ON LOGIC_021.MATRIZ_NO_COMBINA(CODPROD)
 PCTFREE 10 INITRANS 2 MAXTRANS 255
 STORAGE (
    INITIAL         64K
    MINEXTENTS      1
    MAXEXTENTS      2147483645
 )
 LOGGING
 TABLESPACE LOGIC_021
/

CREATE INDEX LOGIC_021.MATRIZ_REGLASINDEX1
 ON LOGIC_021.MATRIZ_REGLAS(LN)
 PCTFREE 10 INITRANS 2 MAXTRANS 255
 STORAGE (
    INITIAL         64K
    MINEXTENTS      1
    MAXEXTENTS      2147483645
 )
 LOGGING
 TABLESPACE LOGIC_021
/

CREATE INDEX LOGIC_021.MATRIZ_SI_COMBINAINDEX1
 ON LOGIC_021.MATRIZ_SI_COMBINA(CODPROD)
 PCTFREE 10 INITRANS 2 MAXTRANS 255
 STORAGE (
    INITIAL         64K
    MINEXTENTS      1
    MAXEXTENTS      2147483645
 )
 LOGGING
 TABLESPACE LOGIC_021
/

CREATE INDEX LOGIC_021.MOOREINDEX1
 ON LOGIC_021.MOORE(FACTURA)
 PCTFREE 10 INITRANS 2 MAXTRANS 255
 STORAGE (
    INITIAL         64K
    MINEXTENTS      1
    MAXEXTENTS      2147483645
 )
 LOGGING
 TABLESPACE LOGIC_021
/

CREATE INDEX LOGIC_021.MOOREINDEX2
 ON LOGIC_021.MOORE(LOCALIZATION)
 PCTFREE 10 INITRANS 2 MAXTRANS 255
 STORAGE (
    INITIAL         64K
    MINEXTENTS      1
    MAXEXTENTS      2147483645
 )
 LOGGING
 TABLESPACE LOGIC_021
/

CREATE INDEX LOGIC_021.NOM
 ON LOGIC_021.RECHABONNE(NOM)
 PCTFREE 10 INITRANS 2 MAXTRANS 255
 STORAGE (
    INITIAL         64K
    MINEXTENTS      1
    MAXEXTENTS      2147483645
 )
 LOGGING
 TABLESPACE LOGIC_021
/

CREATE INDEX LOGIC_021.NUMABONNE
 ON LOGIC_021.RECHABONNE(ABONNE)
 PCTFREE 10 INITRANS 2 MAXTRANS 255
 STORAGE (
    INITIAL         64K
    MINEXTENTS      1
    MAXEXTENTS      2147483645
 )
 LOGGING
 TABLESPACE LOGIC_021
/

CREATE INDEX LOGIC_021.NUMCTRT
 ON LOGIC_021.RECHABONNE(NUMCTRT)
 PCTFREE 10 INITRANS 2 MAXTRANS 255
 STORAGE (
    INITIAL         64K
    MINEXTENTS      1
    MAXEXTENTS      2147483645
 )
 LOGGING
 TABLESPACE LOGIC_021
/

CREATE INDEX LOGIC_021.NUMSOUSCRIT
 ON LOGIC_021.RECHABONNE(SOUSCRIT)
 PCTFREE 10 INITRANS 2 MAXTRANS 255
 STORAGE (
    INITIAL         64K
    MINEXTENTS      1
    MAXEXTENTS      2147483645
 )
 LOGGING
 TABLESPACE LOGIC_021
/

CREATE INDEX LOGIC_021.OALIASNAME
 ON LOGIC_021.DICO(TYPEID, ALIASNAME)
 PCTFREE 10 INITRANS 2 MAXTRANS 255
 STORAGE (
    INITIAL         64K
    MINEXTENTS      1
    MAXEXTENTS      2147483645
 )
 LOGGING
 TABLESPACE LOGIC_021
/

CREATE UNIQUE INDEX LOGIC_021.OBJID
 ON LOGIC_021.DICO(OBJID, VERSION)
 PCTFREE 10 INITRANS 2 MAXTRANS 255
 STORAGE (
    INITIAL         64K
    MINEXTENTS      1
    MAXEXTENTS      2147483645
 )
 LOGGING
 TABLESPACE LOGIC_021
/

CREATE INDEX LOGIC_021.ONAME
 ON LOGIC_021.DICO(TYPEID, "NAME")
 PCTFREE 10 INITRANS 2 MAXTRANS 255
 STORAGE (
    INITIAL         64K
    MINEXTENTS      1
    MAXEXTENTS      2147483645
 )
 LOGGING
 TABLESPACE LOGIC_021
/

CREATE INDEX LOGIC_021.PAYEURINDEX1
 ON LOGIC_021.PAYEUR(NOM)
 PCTFREE 10 INITRANS 2 MAXTRANS 255
 STORAGE (
    INITIAL         64K
    MINEXTENTS      1
    MAXEXTENTS      2147483645
 )
 LOGGING
 TABLESPACE LOGIC_021
/

CREATE INDEX LOGIC_021.PRISEINDEX1
 ON LOGIC_021.PRISE(DTRACC)
 PCTFREE 10 INITRANS 2 MAXTRANS 255
 STORAGE (
    INITIAL         64K
    MINEXTENTS      1
    MAXEXTENTS      2147483645
 )
 LOGGING
 TABLESPACE LOGIC_021
/

CREATE INDEX LOGIC_021.PRODUITINDEX1
 ON LOGIC_021.PRODUIT(DTFIN)
 PCTFREE 10 INITRANS 2 MAXTRANS 255
 STORAGE (
    INITIAL         64K
    MINEXTENTS      1
    MAXEXTENTS      2147483645
 )
 LOGGING
 TABLESPACE LOGIC_021
/

CREATE INDEX LOGIC_021.PRODUITINDEX2
 ON LOGIC_021.PRODUIT(NATURE)
 PCTFREE 10 INITRANS 2 MAXTRANS 255
 STORAGE (
    INITIAL         64K
    MINEXTENTS      1
    MAXEXTENTS      2147483645
 )
 LOGGING
 TABLESPACE LOGIC_021
/

CREATE INDEX LOGIC_021.PROPSERVINDEX1
 ON LOGIC_021.PROPSERV(ORDRE)
 PCTFREE 10 INITRANS 2 MAXTRANS 255
 STORAGE (
    INITIAL         64K
    MINEXTENTS      1
    MAXEXTENTS      2147483645
 )
 LOGGING
 TABLESPACE LOGIC_021
/

CREATE INDEX LOGIC_021.RECIBOINDEX1
 ON LOGIC_021.RECIBO(NUMABONNE)
 PCTFREE 10 INITRANS 2 MAXTRANS 255
 STORAGE (
    INITIAL         64K
    MINEXTENTS      1
    MAXEXTENTS      2147483645
 )
 LOGGING
 TABLESPACE LOGIC_021
/

CREATE INDEX LOGIC_021.RECUINDEX1
 ON LOGIC_021.RECU(NUMABONNE)
 PCTFREE 10 INITRANS 2 MAXTRANS 255
 STORAGE (
    INITIAL         64K
    MINEXTENTS      1
    MAXEXTENTS      2147483645
 )
 LOGGING
 TABLESPACE LOGIC_021
/

CREATE INDEX LOGIC_021.RELDEST
 ON LOGIC_021.DICO(DESTOBJID, DESTVERSION, TYPEID, SRCOBJID, SRCVERSION)
 PCTFREE 10 INITRANS 2 MAXTRANS 255
 STORAGE (
    INITIAL         64K
    MINEXTENTS      1
    MAXEXTENTS      2147483645
 )
 LOGGING
 TABLESPACE LOGIC_021
/

CREATE INDEX LOGIC_021.RELSRC
 ON LOGIC_021.DICO(SRCOBJID, SRCVERSION, TYPEID, DESTOBJID, DESTVERSION)
 PCTFREE 10 INITRANS 2 MAXTRANS 255
 STORAGE (
    INITIAL         64K
    MINEXTENTS      1
    MAXEXTENTS      2147483645
 )
 LOGGING
 TABLESPACE LOGIC_021
/

CREATE INDEX LOGIC_021.ROLESINDEX1
 ON LOGIC_021.ROLES(NUMINTER)
 PCTFREE 10 INITRANS 2 MAXTRANS 255
 STORAGE (
    INITIAL         64K
    MINEXTENTS      1
    MAXEXTENTS      2147483645
 )
 LOGGING
 TABLESPACE LOGIC_021
/

CREATE INDEX LOGIC_021.SCHEDULEPPVINDEX1
 ON LOGIC_021.SCHEDULEPPV(LBEN)
 PCTFREE 10 INITRANS 2 MAXTRANS 255
 STORAGE (
    INITIAL         64K
    MINEXTENTS      1
    MAXEXTENTS      2147483645
 )
 LOGGING
 TABLESPACE LOGIC_021
/

CREATE INDEX LOGIC_021.SCHEDULEPPVINDEX2
 ON LOGIC_021.SCHEDULEPPV(SCHEDBSID)
 PCTFREE 10 INITRANS 2 MAXTRANS 255
 STORAGE (
    INITIAL         64K
    MINEXTENTS      1
    MAXEXTENTS      2147483645
 )
 LOGGING
 TABLESPACE LOGIC_021
/

CREATE INDEX LOGIC_021.SCHEDULEPPVINDEX4
 ON LOGIC_021.SCHEDULEPPV(CHANNELID)
 PCTFREE 10 INITRANS 2 MAXTRANS 255
 STORAGE (
    INITIAL         64K
    MINEXTENTS      1
    MAXEXTENTS      2147483645
 )
 LOGGING
 TABLESPACE LOGIC_021
/

CREATE INDEX LOGIC_021.SERVTERMINALINDEX1
 ON LOGIC_021.SERVTERMINAL(NUMSERIE)
 PCTFREE 10 INITRANS 2 MAXTRANS 255
 STORAGE (
    INITIAL         64K
    MINEXTENTS      1
    MAXEXTENTS      2147483645
 )
 LOGGING
 TABLESPACE LOGIC_021
/

CREATE INDEX LOGIC_021.TEL
 ON LOGIC_021.RECHABONNE(TEL)
 PCTFREE 10 INITRANS 2 MAXTRANS 255
 STORAGE (
    INITIAL         64K
    MINEXTENTS      1
    MAXEXTENTS      2147483645
 )
 LOGGING
 TABLESPACE LOGIC_021
/

CREATE INDEX LOGIC_021.TEMPECINDEX1
 ON LOGIC_021.TEMPEC(NUMABONNE)
 PCTFREE 10 INITRANS 2 MAXTRANS 255
 STORAGE (
    INITIAL         64K
    MINEXTENTS      1
    MAXEXTENTS      2147483645
 )
 LOGGING
 TABLESPACE LOGIC_021
/

CREATE INDEX LOGIC_021.TEMPECINDEX2
 ON LOGIC_021.TEMPEC(CODOPE)
 PCTFREE 10 INITRANS 2 MAXTRANS 255
 STORAGE (
    INITIAL         64K
    MINEXTENTS      1
    MAXEXTENTS      2147483645
 )
 LOGGING
 TABLESPACE LOGIC_021
/

CREATE INDEX LOGIC_021.TEMPNODEINDEX1
 ON LOGIC_021.TEMPNODE(LOCALIZATION)
 PCTFREE 10 INITRANS 2 MAXTRANS 255
 STORAGE (
    INITIAL         64K
    MINEXTENTS      1
    MAXEXTENTS      2147483645
 )
 LOGGING
 TABLESPACE LOGIC_021
/

CREATE INDEX LOGIC_021.TEMPRACSAINTEINDEX1
 ON LOGIC_021.TEMPRACSAINTE(NUMABONNE)
 PCTFREE 10 INITRANS 2 MAXTRANS 255
 STORAGE (
    INITIAL         64K
    MINEXTENTS      1
    MAXEXTENTS      2147483645
 )
 LOGGING
 TABLESPACE LOGIC_021
/

CREATE INDEX LOGIC_021.TERMINALINDEX1
 ON LOGIC_021.TERMINAL(NUMID)
 PCTFREE 10 INITRANS 2 MAXTRANS 255
 STORAGE (
    INITIAL         64K
    MINEXTENTS      1
    MAXEXTENTS      2147483645
 )
 LOGGING
 TABLESPACE LOGIC_021
/

CREATE INDEX LOGIC_021.TYPEID
 ON LOGIC_021.DICO(TYPEID)
 PCTFREE 10 INITRANS 2 MAXTRANS 255
 STORAGE (
    INITIAL         64K
    MINEXTENTS      1
    MAXEXTENTS      2147483645
 )
 LOGGING
 TABLESPACE LOGIC_021
/

CREATE INDEX LOGIC_021.VENTEINDEX1
 ON LOGIC_021.VENTE(NUMABONNE)
 PCTFREE 10 INITRANS 2 MAXTRANS 255
 STORAGE (
    INITIAL         64K
    MINEXTENTS      1
    MAXEXTENTS      2147483645
 )
 LOGGING
 TABLESPACE LOGIC_021
/

CREATE INDEX LOGIC_021.VENTEINDEX2
 ON LOGIC_021.VENTE(CODPROD)
 PCTFREE 10 INITRANS 2 MAXTRANS 255
 STORAGE (
    INITIAL         64K
    MINEXTENTS      1
    MAXEXTENTS      2147483645
 )
 LOGGING
 TABLESPACE LOGIC_021
/

CREATE INDEX LOGIC_021.VENTEINDEX3
 ON LOGIC_021.VENTE(DTPAIE)
 PCTFREE 10 INITRANS 2 MAXTRANS 255
 STORAGE (
    INITIAL         64K
    MINEXTENTS      1
    MAXEXTENTS      2147483645
 )
 LOGGING
 TABLESPACE LOGIC_021
/

CREATE INDEX LOGIC_021.VENTEINDEX4
 ON LOGIC_021.VENTE(INTE)
 PCTFREE 10 INITRANS 2 MAXTRANS 255
 STORAGE (
    INITIAL         64K
    MINEXTENTS      1
    MAXEXTENTS      2147483645
 )
 LOGGING
 TABLESPACE LOGIC_021
/

CREATE INDEX LOGIC_021.VISITEINDEX1
 ON LOGIC_021.VISITE(NUMABONNE)
 PCTFREE 10 INITRANS 2 MAXTRANS 255
 STORAGE (
    INITIAL         64K
    MINEXTENTS      1
    MAXEXTENTS      2147483645
 )
 LOGGING
 TABLESPACE LOGIC_021
/

CREATE INDEX LOGIC_021.VTEINDEX1
 ON LOGIC_021.VTE(NUMABONNE, CODPROD)
 PCTFREE 10 INITRANS 2 MAXTRANS 255
 STORAGE (
    INITIAL         64K
    MINEXTENTS      1
    MAXEXTENTS      2147483645
 )
 LOGGING
 TABLESPACE LOGIC_021
/

/*******************************************************************************
 * Unique Constraints
 * ------------------
 * Extracted at 08/08/2005 11:45:19 a.m.
 ******************************************************************************/

/*******************************************************************************
 * Check Constraints
 * -----------------
 * Extracted at 08/08/2005 11:45:19 a.m.
 ******************************************************************************/

ALTER TABLE LOGIC_021.SOLICITUD_CABIO_PRECIO ADD CONSTRAINT C_SOLICITUD_CABIO_PRECIO
 CHECK (moneda in (1,2))

/

ALTER TABLE LOGIC_021.PAGOS_EN_LINEA2 ADD CONSTRAINT CHECHKTIPO1
 CHECK (TIPO IN ('R','P'))

/

ALTER TABLE LOGIC_021.SOLICITUD_CABIO_PRECIO ADD CONSTRAINT CHK1
 CHECK (TIPO_SOLICITUD  in(1,2,3))

/

/*******************************************************************************
 * Foreign Key Constraints
 * -----------------------
 * Extracted at 08/08/2005 11:45:19 a.m.
 ******************************************************************************/

ALTER TABLE LOGIC_021.PROVINCIAS ADD CONSTRAINT INTEG_249 FOREIGN KEY (CPAIS)
 REFERENCES LOGIC_021.PAISES (CPAIS)
 ON DELETE CASCADE
 VALIDATE
/

ALTER TABLE LOGIC_021.CANTONES ADD CONSTRAINT INTEG_250 FOREIGN KEY (CPAIS, CPROV)
 REFERENCES LOGIC_021.PROVINCIAS (CPROV, CPAIS)
 ON DELETE CASCADE
 VALIDATE
/

ALTER TABLE LOGIC_021.DISTRITOS ADD CONSTRAINT INTEG_251 FOREIGN KEY (CCANTON, CPAIS, CPROV)
 REFERENCES LOGIC_021.CANTONES (CCANTON, CPROV, CPAIS)
 ON DELETE CASCADE
 VALIDATE
/

ALTER TABLE LOGIC_021.LOCALIZATION ADD CONSTRAINT INTEG_252 FOREIGN KEY (CCANTON, CDISTRI, CPAIS, CPROV)
 REFERENCES LOGIC_021.DISTRITOS (CDISTRI, CCANTON, CPROV, CPAIS)
 ON DELETE CASCADE
 VALIDATE
/

ALTER TABLE LOGIC_021.LOCALIZATION ADD CONSTRAINT INTEG_253 FOREIGN KEY (CODINSEE)
 REFERENCES LOGIC_021.COMMUNE (CODINSEE)
 VALIDATE
/

ALTER TABLE LOGIC_021.HUB ADD CONSTRAINT INTEG_254 FOREIGN KEY (CODIGO_HEADEND)
 REFERENCES LOGIC_021.HEADEND (CODIGO_HEADEND)
 ON DELETE CASCADE
 VALIDATE
/

ALTER TABLE LOGIC_021.NODE ADD CONSTRAINT INTEG_255 FOREIGN KEY (CODIGO_HEADEND, CODIGO_HUB)
 REFERENCES LOGIC_021.HUB (CODIGO_HUB, CODIGO_HEADEND)
 ON DELETE CASCADE
 VALIDATE
/

ALTER TABLE LOGIC_021.RAMAL ADD CONSTRAINT INTEG_256 FOREIGN KEY (CODIGO_HEADEND, CODIGO_HUB, NUMNODE)
 REFERENCES LOGIC_021.NODE (NUMNODE, CODIGO_HEADEND, CODIGO_HUB)
 ON DELETE CASCADE
 VALIDATE
/

ALTER TABLE LOGIC_021.TAP ADD CONSTRAINT INTEG_257 FOREIGN KEY (CODIGO_HEADEND, CODIGO_HUB, CODIGO_RAMAL, NUMNODE)
 REFERENCES LOGIC_021.RAMAL (CODIGO_RAMAL, CODIGO_HEADEND, CODIGO_HUB, NUMNODE)
 ON DELETE CASCADE
 VALIDATE
/

ALTER TABLE LOGIC_021.LOCALIZACION_NODO ADD CONSTRAINT INTEG_258 FOREIGN KEY (CODIGO_HEADEND, CODIGO_HUB, NUMNODE)
 REFERENCES LOGIC_021.NODE (NUMNODE, CODIGO_HEADEND, CODIGO_HUB)
 ON DELETE CASCADE
 VALIDATE
/

ALTER TABLE LOGIC_021.LOCALIZACION_NODO ADD CONSTRAINT INTEG_259 FOREIGN KEY (CODINSEE, LOCALISATION)
 REFERENCES LOGIC_021.LOCALIZATION (CODINSEE, LOCALISATION)
 ON DELETE CASCADE
 VALIDATE
/

ALTER TABLE LOGIC_021.PRISE ADD CONSTRAINT INTEG_260 FOREIGN KEY (NUMABONNE)
 REFERENCES LOGIC_021.ABONNE (NUMABONNE)
 ON DELETE CASCADE
 VALIDATE
/

ALTER TABLE LOGIC_021.NODE ADD CONSTRAINT INTEG_265 FOREIGN KEY (ESTADO)
 REFERENCES LOGIC_021.ESTADO_NODO (ESTADO)
 VALIDATE
/

ALTER TABLE LOGIC_021.BITACORA_NODOS ADD CONSTRAINT INTEG_274 FOREIGN KEY (ESTADO)
 REFERENCES LOGIC_021.ESTADO_NODO (ESTADO)
 VALIDATE
/

ALTER TABLE LOGIC_021.BITACORA_NODOS ADD CONSTRAINT INTEG_275 FOREIGN KEY (CODIGO_HEADEND, CODIGO_HUB, NUMNODE)
 REFERENCES LOGIC_021.NODE (NUMNODE, CODIGO_HEADEND, CODIGO_HUB)
 ON DELETE CASCADE
 VALIDATE
/

ALTER TABLE LOGIC_021.PARAMETRE ADD CONSTRAINT PARAMETREFOREIGNKEY1 FOREIGN KEY (CODTBL)
 REFERENCES LOGIC_021.TYPPARA (CODTBL)
 VALIDATE
/

ALTER TABLE LOGIC_021.UTILISATEUR ADD CONSTRAINT UTILISATEURFOREIGNKEY1 FOREIGN KEY (DROIT)
 REFERENCES LOGIC_021.DROITS (DROIT)
 VALIDATE
/

/*******************************************************************************
 * Views
 * -----
 * Extracted at 08/08/2005 11:45:20 a.m.
 ******************************************************************************/

CREATE OR REPLACE VIEW LOGIC_021.AVERIASINDETINTER (NUMINTER, NUMABONNE, DTDEB, TIPO, LIB, MOTIF, CODPROD, MOVIMIENTO)
AS
select numinter, numabonne, dtdeb, tipo, lib, motif, '0000' as codprod, 'Add' as movimiento
   from intervention
    where
     estado = 'F' and intervention.tipo = 'Apl'
/
