Tables

TMP_CONTABILIZAR

Description

(There is no description for table TMP_CONTABILIZAR)

Fields

Triggers

(There are no triggers for table TMP_CONTABILIZAR)

Indices

References

(There are no references for table TMP_CONTABILIZAR)

Referenced By

(There are no tables referenced by table TMP_CONTABILIZAR)

Definition

CREATE TABLE TMP_CONTABILIZAR (
    ID       INTEGER NOT NULL,
    TIPO     CHAR(5),
    PREFIJO  CHAR(5),
    NUMERO   CHAR(10),
    CUENTA   CHAR(30),
    CENTRO   CHAR(5),
    TERCERO  CHAR(15),
    DEBITO   DOUBLE PRECISION DEFAULT 0,
    CREDITO  DOUBLE PRECISION DEFAULT 0,
    BASE     DOUBLE PRECISION DEFAULT 0,
    DETALLE  CHAR(1)
);


CREATE INDEX TMP_CONTABILIZAR_IDX1 ON TMP_CONTABILIZAR (ID);
CREATE INDEX TMP_CONTABILIZAR_IDX2 ON TMP_CONTABILIZAR (TIPO);
CREATE INDEX TMP_CONTABILIZAR_IDX3 ON TMP_CONTABILIZAR (PREFIJO);
CREATE INDEX TMP_CONTABILIZAR_IDX4 ON TMP_CONTABILIZAR (NUMERO);
CREATE INDEX TMP_CONTABILIZAR_IDX5 ON TMP_CONTABILIZAR (CUENTA);
CREATE INDEX TMP_CONTABILIZAR_IDX6 ON TMP_CONTABILIZAR (CENTRO);
CREATE INDEX TMP_CONTABILIZAR_IDX7 ON TMP_CONTABILIZAR (TERCERO);