/******************************************************************************/
/***               Generated by IBExpert 29/03/2019 15:21:58                ***/
/******************************************************************************/

/******************************************************************************/
/***      Following SET SQL DIALECT is just for the Database Comparer       ***/
/******************************************************************************/
SET SQL DIALECT 3;



/******************************************************************************/
/***                                 Tables                                 ***/
/******************************************************************************/



CREATE TABLE REC_ANUAL (
    NRDOC         VARCHAR(15) NOT NULL,
    TIPO          INTEGER,
    DATCOM        TIMESTAMP,
    CODCLI        INTEGER,
    CODVEN        INTEGER,
    CODCOM        INTEGER,
    DATVEN        TIMESTAMP,
    VALOR         FLOAT,
    DATPAG        TIMESTAMP,
    JUROS         FLOAT,
    DESCONTO      FLOAT,
    VALPAG        FLOAT,
    NRCHEQUE      INTEGER,
    REFERENCIA    VARCHAR(30),
    OBSERV        VARCHAR(30),
    NRDOC_MOV     VARCHAR(11),
    PLANPAG       INTEGER,
    CAIXAEMISSAO  INTEGER,
    CAIXABAIXA    INTEGER,
    EMPRESA       INTEGER,
    TERMINAL      INTEGER,
    SEQPEDIDO     INTEGER,
    FORMA         INTEGER
);




/******************************************************************************/
/***                               Privileges                               ***/
/******************************************************************************/


