Fórum Relatório Complexo com situação de pagamentos #321856

qual o banco de dados e quais os componentes de acesso utilizados?
se possível, publique a estrutura das tabelas pertinentes à consulta.

CREATE TABLE ´ALUNOS´
(
´ID´INTEGER NOT NULL,
´ALUNO´´DALUNO_1´ NOT NULL COLLATE PXW_INTL850,
´SEXO´CHAR(1) CHARACTER SET WIN1252 COLLATE PXW_INTL850,
´NASCIMENTO´DATE,
´RGALUNO´VARCHAR(12) CHARACTER SET WIN1252 COLLATE PXW_INTL850,
´RGDC´VARCHAR(2) CHARACTER SET WIN1252 COLLATE PXW_INTL850,
´RGUF´CHAR(2) CHARACTER SET WIN1252 COLLATE PXW_INTL850,
´MAE´VARCHAR(60) CHARACTER SET WIN1252 COLLATE PXW_INTL850,
´PAI´VARCHAR(60) CHARACTER SET WIN1252 COLLATE PXW_INTL850,
´CEP´CHAR(9) CHARACTER SET WIN1252 COLLATE PXW_INTL850,
´CIDADE´VARCHAR(50) CHARACTER SET WIN1252 COLLATE PXW_INTL850,
´UF´CHAR(2) CHARACTER SET WIN1252 COLLATE PXW_INTL850,
´ENDERECO´VARCHAR(60) CHARACTER SET WIN1252 COLLATE PXW_INTL850,
´NUMERO´VARCHAR(6) CHARACTER SET WIN1252 COLLATE PXW_INTL850,
´COMPLEMENTO´VARCHAR(50) CHARACTER SET WIN1252 COLLATE PXW_INTL850,
´BAIRRO´VARCHAR(50) CHARACTER SET WIN1252 COLLATE PXW_INTL850,
´TELEFONERES´VARCHAR(15) CHARACTER SET WIN1252 COLLATE PXW_INTL850,
´TELEFONEREC´VARCHAR(15) CHARACTER SET WIN1252 COLLATE PXW_INTL850,
´RAMALNOMERECADO´VARCHAR(50) CHARACTER SET WIN1252 COLLATE PXW_INTL850,
´NATURALIDADE´VARCHAR(50) CHARACTER SET WIN1252 COLLATE PXW_INTL850,
´UFNATURALIDADE´CHAR(2) CHARACTER SET WIN1252 COLLATE PXW_INTL850,
´FOLHANATURALIDADE´VARCHAR(4) CHARACTER SET WIN1252 COLLATE PXW_INTL850,
´COMARCANASCIMENTO´VARCHAR(50) CHARACTER SET WIN1252 COLLATE PXW_INTL850,
´UFCOMARCA´CHAR(2) CHARACTER SET WIN1252 COLLATE PXW_INTL850,
´LIVROCOMARCA´VARCHAR(4) CHARACTER SET WIN1252 COLLATE PXW_INTL850,
´DISTRITONASCIMENTO´VARCHAR(50) CHARACTER SET WIN1252 COLLATE PXW_INTL850,
´NUMEROCERTIDAO´VARCHAR(6) CHARACTER SET WIN1252 COLLATE PXW_INTL850,
´OBS´BLOB SUB_TYPE TEXT SEGMENT SIZE 80 CHARACTER SET WIN1252,
´COR´VARCHAR(50) CHARACTER SET WIN1252 COLLATE PXW_INTL850,
´DATACADASTRO´DATE,
´CPFPAI´CHAR(14) CHARACTER SET WIN1252 COLLATE PXW_INTL850,
´CPFMAE´CHAR(14) CHARACTER SET WIN1252 COLLATE PXW_INTL850,
´RGPAI´VARCHAR(12) CHARACTER SET WIN1252 COLLATE PXW_INTL850,
´RGMAE´VARCHAR(12) CHARACTER SET WIN1252 COLLATE PXW_INTL850,
´PROFISSAOPAI´VARCHAR(50) CHARACTER SET WIN1252 COLLATE PXW_INTL850,
´PROFISSAOMAE´VARCHAR(50) CHARACTER SET WIN1252 COLLATE PXW_INTL850,
´MEDICO´VARCHAR(50) CHARACTER SET WIN1252 COLLATE PXW_INTL850,
´MENSALIDADE´NUMERIC(15, 2),
´DESCONTO´NUMERIC(15, 2),
´VENCIMENTO´INTEGER,
´TELEFONEMEDICO´VARCHAR(15) CHARACTER SET WIN1252 COLLATE PXW_INTL850,
´MENSALIDADELIQUIDA´NUMERIC(15, 2),
´EMAIL´VARCHAR(100) CHARACTER SET WIN1252 COLLATE PXW_INTL850,
´RA´VARCHAR(12) CHARACTER SET WIN1252 COLLATE PXW_INTL850,
´DCRA´VARCHAR(2) CHARACTER SET WIN1252 COLLATE PXW_INTL850,
´UFRA´VARCHAR(2) CHARACTER SET WIN1252 COLLATE PXW_INTL850,
´CPF´CHAR(14) CHARACTER SET WIN1252 COLLATE PXW_INTL850,
´ANONASCIMENTO´CHAR(4) CHARACTER SET WIN1252 COLLATE PXW_INTL850,
´FONEPAICOMERCIAL´VARCHAR(15) CHARACTER SET WIN1252 COLLATE PXW_INTL850,
´FONEMAECOMERCIAL´VARCHAR(15) CHARACTER SET WIN1252 COLLATE PXW_INTL850,
´CELULARMAE´VARCHAR(15) CHARACTER SET WIN1252 COLLATE PXW_INTL850,
´CELULARPAI´VARCHAR(15) CHARACTER SET WIN1252 COLLATE PXW_INTL850,
´MESNASCIMENTO´VARCHAR(2) CHARACTER SET WIN1252 COLLATE PXW_INTL850,
´RGMAEDATA´DATE,
´RGPAIDATA´DATE,
´RESPONSAVEL´VARCHAR(50) CHARACTER SET WIN1252 COLLATE PXW_INTL850,
´PARENTESCO´VARCHAR(30) CHARACTER SET WIN1252 COLLATE PXW_INTL850,
´CPFPARENTE´CHAR(14) CHARACTER SET WIN1252 COLLATE PXW_INTL850,
´RGPARENTE´VARCHAR(12) CHARACTER SET WIN1252 COLLATE PXW_INTL850,
´TRABALHOMAE´VARCHAR(50) CHARACTER SET WIN1252 COLLATE PXW_INTL850,
´TRABALHOPAI´VARCHAR(50) CHARACTER SET WIN1252 COLLATE PXW_INTL850,
´RAMALPAI´VARCHAR(10) CHARACTER SET WIN1252 COLLATE PXW_INTL850,
´RAMALMAE´VARCHAR(10) CHARACTER SET WIN1252 COLLATE PXW_INTL850,
´NECESSIDADE´CHAR(1) CHARACTER SET WIN1252 COLLATE PXW_INTL850,
´CEGUEIRA´CHAR(1) CHARACTER SET WIN1252 COLLATE PXW_INTL850,
´BAIXAVISAO´CHAR(1) CHARACTER SET WIN1252 COLLATE PXW_INTL850,
´SURDEZSEVERAOUPROFUNDA´CHAR(1) CHARACTER SET WIN1252 COLLATE PXW_INTL850,
´SURDEZLEVEOUMODERADA´CHAR(1) CHARACTER SET WIN1252 COLLATE PXW_INTL850,
´SURDOCEGUEIRA´CHAR(1) CHARACTER SET WIN1252 COLLATE PXW_INTL850,
´FISICA´CHAR(1) CHARACTER SET WIN1252 COLLATE PXW_INTL850,
´MENTAL´CHAR(1) CHARACTER SET WIN1252 COLLATE PXW_INTL850,
´AUTISMO´CHAR(1) CHARACTER SET WIN1252 COLLATE PXW_INTL850,
´SINDROMEDEDOWN´CHAR(1) CHARACTER SET WIN1252 COLLATE PXW_INTL850,
´MULTIPLA´CHAR(2) CHARACTER SET WIN1252 COLLATE PXW_INTL850,
´ALTASHABILIDADESSUPERDOTACAO´CHAR(2) CHARACTER SET WIN1252 COLLATE PXW_INTL850,
´CONDUTASTIPICAS´CHAR(2) CHARACTER SET WIN1252 COLLATE PXW_INTL850,
´NACIONALIDADE´VARCHAR(30) CHARACTER SET WIN1252 COLLATE PXW_INTL850,
´DESCONTOCALCULADO´NUMERIC(15, 2),
´MENSAGEM2´VARCHAR(200) CHARACTER SET WIN1252 COLLATE PXW_INTL850,
´FOTO´BLOB SUB_TYPE 0 SEGMENT SIZE 80,
CONSTRAINT ´PK_ALUNOS´ PRIMARY KEY (´ID´)
);

--------------------------------------------------------------


/* Table: MATRICULAS, Owner: SYSDBA */

CREATE TABLE ´MATRICULAS´
(
´IDMATRICULA´INTEGER NOT NULL,
´IDALUNO´INTEGER NOT NULL,
´IDSERIE´INTEGER NOT NULL,
´DATAMATRICULA´DATE NOT NULL,
´ANO´CHAR(4) CHARACTER SET WIN1252 NOT NULL COLLATE PXW_INTL850,
´PERIODO´VARCHAR(30) CHARACTER SET WIN1252 NOT NULL COLLATE PXW_INTL850,
´SITUACAO´VARCHAR(50) CHARACTER SET WIN1252 NOT NULL COLLATE PXW_INTL850,
´ATIVO´CHAR(1) CHARACTER SET WIN1252 NOT NULL COLLATE PXW_INTL850,
´DATATERMINO´DATE,
´BOLSA´CHAR(1) CHARACTER SET WIN1252 COLLATE PXW_INTL850,
´TURMA´VARCHAR(20) CHARACTER SET WIN1252 COLLATE PXW_INTL850,
´NIVEL´VARCHAR(30) CHARACTER SET WIN1252 COLLATE PXW_INTL850,
´RESPONSAVEL´VARCHAR(10) CHARACTER SET WIN1252 COLLATE PXW_INTL850,
´CODMATRICULA´INTEGER,
´IRMAO´CHAR(1) CHARACTER SET WIN1252 COLLATE PXW_INTL850,
´BOLETOGERADO´CHAR(1) CHARACTER SET WIN1252 COLLATE PXW_INTL850,
´MENSAGEM´VARCHAR(200) CHARACTER SET WIN1252 COLLATE PXW_INTL850,
CONSTRAINT ´PK_MATRICULAS´ PRIMARY KEY (´IDMATRICULA´)
);
ALTER TABLE ´MATRICULAS´ ADD CONSTRAINT ´FK_MATRICULAS_1´ FOREIGN KEY (´IDALUNO´) REFERENCES ALUNOS (´ID´) ON UPDATE CASCADE;
ALTER TABLE ´MATRICULAS´ ADD CONSTRAINT ´FK_MATRICULAS_2´ FOREIGN KEY (´IDSERIE´) REFERENCES SERIES (´IDSERIE´) ON UPDATE CASCADE;


------------------------------------------------------

/* Table: SERIES, Owner: SYSDBA */

CREATE TABLE ´SERIES´
(
´IDSERIE´INTEGER NOT NULL,
´SERIE´VARCHAR(50) CHARACTER SET WIN1252 NOT NULL COLLATE PXW_INTL850,
´ENSINO´VARCHAR(30) CHARACTER SET WIN1252 COLLATE PXW_INTL850,
CONSTRAINT ´PK_SERIES´ PRIMARY KEY (´IDSERIE´)
);

----------------------------------------------------------------

/* Table: BOLETOS, Owner: SYSDBA */

CREATE TABLE ´BOLETOS´
(
´NRBOLETO´VARCHAR(13) CHARACTER SET WIN1252 NOT NULL,
´REFERENTE´VARCHAR(30) CHARACTER SET WIN1252 NOT NULL COLLATE PXW_INTL850,
´DATADOCUMENTO´DATE NOT NULL,
´DATAVENCIMENTO´DATE NOT NULL,
´DATAPAGAMENTO´DATE,
´VALORBRUTO´NUMERIC(15, 2) NOT NULL,
´DESCONTO´NUMERIC(15, 2) NOT NULL,
´VALORLIQUIDO´NUMERIC(15, 2) NOT NULL,
´VALORPAGO´NUMERIC(15, 2),
´IDMATRICULA´INTEGER,
´SITUACAO´VARCHAR(30) CHARACTER SET WIN1252 DEFAULT ´ABERTO´ NOT NULL COLLATE PXW_INTL850,
´NOSSONUMERO´VARCHAR(15) CHARACTER SET WIN1252 NOT NULL COLLATE PXW_INTL850,
´LOCALPAGAMENTO´VARCHAR(10) CHARACTER SET WIN1252 COLLATE PXW_INTL850,
´DATABAIXA´DATE,
CONSTRAINT ´PK_BOLETOS´ PRIMARY KEY (´NOSSONUMERO´)
);
ALTER TABLE ´BOLETOS´ ADD CONSTRAINT ´FK_BOLETOS_1´ FOREIGN KEY (´IDMATRICULA´) REFERENCES MATRICULAS (´IDMATRICULA´) ON UPDATE CASCADE;

----------------------------------------------------------------------------