Tables

TMP_PRORRATEOS

Description

(There is no description for table TMP_PRORRATEOS)

Fields

Triggers

(There are no triggers for table TMP_PRORRATEOS)

Indices

References

(There are no references for table TMP_PRORRATEOS)

Referenced By

(There are no tables referenced by table TMP_PRORRATEOS)

Definition

CREATE TABLE TMP_PRORRATEOS (
    ID                INTEGER NOT NULL,
    CODCUENTA         CHAR(30),
    CODCENTRO         CHAR(5),
    CODPERSONAL       CHAR(15),
    SUBTOTAL_DEBITO   DOUBLE PRECISION DEFAULT 0,
    SUBTOTAL_CREDITO  DOUBLE PRECISION DEFAULT 0
);


CREATE INDEX TMP_PRORRATEOS_IDX1 ON TMP_PRORRATEOS (ID);
CREATE INDEX TMP_PRORRATEOS_IDX2 ON TMP_PRORRATEOS (CODCENTRO);
CREATE INDEX TMP_PRORRATEOS_IDX3 ON TMP_PRORRATEOS (CODPERSONAL);
CREATE INDEX TMP_PRORRATEOS_IDX4 ON TMP_PRORRATEOS (CODCUENTA);