CREATE TABLE CONTAS_PAGAR (
    NR_PAGAMENTO       CHAR(10) NOT NULL,
    VENCIMENTO         TIMESTAMP,
    NR_DOCUMENTO       VARCHAR(15),
    NR_FATURA          VARCHAR(15),
    TP_DOCUMENTO       CHAR(1),
    CD_FORNECEDOR      VARCHAR(6),
    VALOR              DOUBLE PRECISION,
    DATACOMP           TIMESTAMP,
    DESCONTO           DOUBLE PRECISION,
    JUROS              DOUBLE PRECISION,
    MULTA              DOUBLE PRECISION,
    OBSERV             BLOB SUB_TYPE 1 SEGMENT SIZE 80,
    VALORTOT           DOUBLE PRECISION,
    CONTA_CRED_PLC     VARCHAR(6),
    CONTA              VARCHAR(10),
    BANCO              VARCHAR(3),
    CHEQUE             VARCHAR(6),
    CD_LOCAL_PGTO      CHAR(2),
    CD_TIPO_CART_COBR  CHAR(2),
    CD_MOEDA           CHAR(2),
    DATALANCAMENTO     TIMESTAMP,
    VALOR_PAGAMENTO    DOUBLE PRECISION,
    USUARIO            CHAR(10),
    USUARIO_DATA       TIMESTAMP,
    NR_SEQ_BANCO_LANC  VARCHAR(20),
    MES_COMPETENCIA    CHAR(2),
    ANO_COMPETENCIA    CHAR(4),
    CD_CONTA_PLANO     CHAR(4),
    CD_EMPRESA         VARCHAR(6),
    FL_PRE_DAT         CHAR(1),
    NOTA_FISCAL        CHAR(6),
    CD_ORCAMENTO       CHAR(10),
    FL_PREJUIZO        CHAR(1),
    DT_INCLUSAO        TIMESTAMP,
    USUARIO_INC        CHAR(10)
);


++++++++++++++++++++++++++++++++++++


CREATE TABLE CONTAS_PAGAR_LIQ (
    NR_PAGAMENTO        CHAR(10),
    VENCIMENTO          TIMESTAMP,
    NR_DOCUMENTO        VARCHAR(10),
    NR_FATURA           VARCHAR(10),
    TP_DOCUMENTO        CHAR(1),
    CD_FORNECEDOR       VARCHAR(6),
    VALOR               DOUBLE PRECISION,
    DATACOMP            TIMESTAMP,
    DATALIQ             TIMESTAMP,
    DESCONTO            DOUBLE PRECISION,
    JUROS               DOUBLE PRECISION,
    MULTA               DOUBLE PRECISION,
    OBSERV              BLOB SUB_TYPE 1 SEGMENT SIZE 80,
    VALORTOT            DOUBLE PRECISION,
    CONTA_CRED_PLC      VARCHAR(6),
    CONTA               VARCHAR(10),
    BANCO               VARCHAR(3),
    CHEQUE              VARCHAR(6),
    CD_LOCAL_PGTO       CHAR(2),
    CD_TIPO_CART_COBR   CHAR(2),
    CD_MOEDA            CHAR(2),
    DATALANCAMENTO      TIMESTAMP,
    VALOR_PAGAMENTO     DOUBLE PRECISION,
    USUARIO             CHAR(10),
    USUARIO_DATA        TIMESTAMP,
    CD_CONTA_DEB        CHAR(8),
    CD_CONTA_CRED       CHAR(8),
    CD_CONTA_JUROS      CHAR(8),
    CD_CONTA_DESCONTO   CHAR(8),
    CD_HISTORICO        CHAR(8),
    COMPLEMENTO         CHAR(64),
    NR_PARCELA          VARCHAR(2),
    NR_LOTE             CHAR(4),
    MES_COMPETENCIA     CHAR(2),
    ANO_COMPETENCIA     CHAR(4),
    CD_CONTA_PLANO      CHAR(4),
    CD_EMPRESA          VARCHAR(6),
    CD_HISTORICO_JUROS  CHAR(8),
    FL_RELATORIOS       CHAR(1),
    FL_PRE_DAT          CHAR(1),
    NOTA_FISCAL         CHAR(6),
    CD_ORCAMENTO        CHAR(10),
    FL_PREJUIZO         CHAR(1),
    DT_INCLUSAO         TIMESTAMP,
    USUARIO_INC         CHAR(10)
);