I'm posting the structure of the table ...
if you can help me .... Thank you!
Select all
CREATE TABLE tb_cebcct (
cctsts CHAR(1) /* Status s/ uso */,
ccttcc CHAR(2) NOT NULL /* Tipo do Conta Corrente (tb_srctab_tcc) */,
cctre1 CHAR(6) NOT NULL /* Responsavel do C/Corrente */,
cctncc VARCHAR(17) NOT NULL /* Numero do C/Corrente */,
ccttr1 CHAR(6) /* Estabelec. (GCVEMI) CC/CH/CE -> BANCO,CX/TE */,
cctst1 CHAR(1) /* Situacao do Conta Corrente */,
CONSTRAINT ck_cebcct_st1 CHECK (cctst1 IN (' ','0','1','2',
'3','4','7','8',
'9','C','D','L',
'R')
OR cctst1 IS NULL),
cctdt1 DATE /* Data de Vencimento/Liquidacao */,
cctfl2 CHAR(1) /* Fluxo Financeiro */,
CONSTRAINT ck_cebcct_fl2 CHECK (cctfl2 IN ('0','1','2','N',' ')
OR cctfl2 IS NULL),
ccterc CHAR(6) /* Emi/Favo Cheque (Rec/Emi) ou Cartao(CH/CC/CE)*/,
cctnec VARCHAR(40) /* Nome Emit/Favor Cheque/Cartao (CH/CC/CE) */,
cctnct VARCHAR( 20) /* Numero do Cheque/Cartao de Credito */,
cctcmp VARCHAR( 20) /* Complemento */,
cctdat DATE /* Data Emissao */,
cctval NUMERIC(11, 2) /* Valor Base */,
cctdtv DATE /* Data do Vencimento */,
ccttxt VARCHAR(255) /* Observacao do Conta Corrente */,
cctcar CHAR(1) /* Caracteristica do CCR (D/C) */,
CONSTRAINT ck_cebcct_car CHECK (cctcar IN ('D','C')
OR cctcar IS NULL),
cctinc CHAR(1) /* Tipo da Inclusao (M=Manual) */,
CONSTRAINT ck_cebcct_inc CHECK (cctinc IN (' ','M')
OR cctinc IS NULL),
cctbco NUMERIC( 3) /* Banco Portador do Compromisso a Pagar */,
cctopr CHAR(2) /* Operacao Geradora */,
cctdtp DATE /* Data do Processo da Operacao Geradora */,
cctntr NUMERIC( 5) /* Numero da Transacao da Operacao Geradora */,
cctseq NUMERIC( 3) /* Sequencia da Operacao Geradora */,
cctope CHAR(6) /* Operador da geracao do Conta Corrente */,
ccthor NUMERIC( 6) /* Hora de Geracao do Conta Corrente */,
cctprg VARCHAR( 8) /* Programa Gerador do Conta Corrente */,
cctemp_cpi NUMERIC( 2) /* Empresa (tb_cbaemp) - Acesso FK */,
cctcpi NUMERIC(14) /* Contra Partida (C/C Manual) (tb_cbacta) */,
cctsit CHAR(1) /* Situacao Anterior a Atual */,
CONSTRAINT ck_cebcct_sit CHECK (cctsit IN (' ','0','1','2',
'3','4','7','8',
'9','C','D','L',
'R')
OR cctsit IS NULL),
cctctt VARCHAR( 16) /* Chave do Deposito na (tb_cebcct) C/C = CC */,
cctvab NUMERIC(11, 2) /* Valor Pago/Recebido Sobre Principal */,
cctvde NUMERIC(11, 2) /* Juros Pagos/Despesas */,
cctvre NUMERIC(11, 2) /* Juros Recebidos/Resultado */,
cctuop CHAR(2) /* Codigo da Ultima Operacao */,
cctudp DATE /* Data do Processo da Ultima Operacao */,
cctunt NUMERIC( 5) /* Numero de Transacao da Ultima Operacao */,
cctusq NUMERIC( 3) /* Sequencia da Ultima Operacao */,
cctuor CHAR(6) /* Ultimo Operador */,
cctuho NUMERIC( 6) /* Ultima Hora */,
cctupr VARCHAR( 8) /* Ultimo Programa */,
cctuva NUMERIC(11, 2) /* Valor do Movimento */,
cctori CHAR(2) /* Origem da Compra/Venda/Conta Corrente */,
cctnop NUMERIC( 4) /* Natureza de Operacao (tb_tabnop) */,
ccttor CHAR(1) /* Categoria da origem (Peca,oFicina,Vei,Outr) */,
CONSTRAINT ck_cebcct_tor CHECK (ccttor IN (' ','P','F','V','O')
OR ccttor IS NULL),
cctdla DATE /* Data Lancamento em GCEATE */,
cctcpg NUMERIC( 2) /* Condicao de Pagamento (tb_tabcpg) */,
cctvpa NUMERIC(11, 2) /* Valor a Pagamento/Recebimento Atualizado */,
cctvqc NUMERIC(11, 5) /* Valor a Pagar (Em QC's) */,
cctstc CHAR(1) /* Situacao do C/C Antes Cancelamento (CEB023) */,
CONSTRAINT ck_cebcct_stc CHECK (cctstc IN (' ','0','1','2',
'3','4','7','8',
'9','C','D','L',
'R')
OR cctstc IS NULL),
cctnpr NUMERIC( 7) /* Numero da Proposta */,
cctscv CHAR(1) /* */,
ccttfo CHAR(1) /* Tabela de Correcao p/ Juros Floor-Plan */,
cctdij DATE /* Data do Inicio do Juros Floor-Plan */,
cctaup CHAR(1) /* Campo Autorizacao Pagto */,
CONSTRAINT ck_cebcct_aup CHECK (cctaup IN (' ','E','A')
OR cctaup IS NULL),
cctnap NUMERIC( 5) /* Numero da Autorizacao de Pagamento */,
cctdea DATE /* Data da Autorizacao Pagamento */,
cctrau CHAR(6) /* Responsavel Autorizacao de Pagamento (SPSCTR)*/,
ccthau NUMERIC( 6) /* Hora Autorizacao Pagamento */,
cctage VARCHAR( 10) /* Numero da Agencia do Cheque (CH) */,
cctccn VARCHAR( 15) /* Numero de Conta Corrente do (CH) */,
cctsis CHAR(3) /* Sistema que Emitiu Recibo */,
CONSTRAINT ck_cebcct_sis CHECK (cctsis IN (' ','CEB','VEI')
OR cctsis IS NULL),
cctemi CHAR(6) /* Emitente do Recibo (GCVEMI) - FK */,
cctnre NUMERIC( 6) /* Numero do Recibo (tb_cebrec) */,
cctvat NUMERIC(11, 2) /* Valor do Abatimento */,
cctdda DATE /* Data Atualizacao do Valor em Moeda Fiscal */,
cctdis CHAR(1) /* P/ C/C="CH" (cctst1,"S","N") Depositavel ? */,
CONSTRAINT ck_cebcct_diz CHECK (cctdis IN (' ','0','1','2',
'3','4','7','8',
'9','C','D','L',
'R','S','N')
OR cctdis IS NULL),
cctest CHAR( 6) /* Estabelecimento (GCVEMI) */,
cctdpo CHAR(1) /* P/ C/C="CC" Deposito On-Line (S/N) ? */,
CONSTRAINT ck_cebcct_dpo CHECK (cctdpo IN (' ','S','N')
OR cctdpo IS NULL),
cctsq1 NUMERIC( 8) /* Sequencia Utilizada p/ START-MAIOR */,
cctscc NUMERIC( 3) /* Codigo do Sub-Tipo */,
cctcdv NUMERIC( 7) /* Codigo do Veiculo */,
cctiss CHAR(1) /* Nota é de Servico (S/N)? -> P/ C/C = "GD" */,
CONSTRAINT ck_cebcct_iss CHECK (cctiss IN (' ','S','N')
OR cctiss IS NULL),
cctcpt CHAR(6) /* Codigo do Portador (tb_tracad) */,
ccttco NUMERIC(2) /* Tipo de Cobranca */,
CONSTRAINT ck_cebcct_tco CHECK (ccttco IN (0,1,2,3)
OR ccttco IS NULL),
cctcco CHAR(1) /* Codigo de Cobranca */,
cctndb VARCHAR(12) /* Numero da Duplicata no Banco */,
cctbar VARCHAR(44) /* Codigo de Barras do Bloqueto */,
cctdcc NUMERIC(2) /* Dias de Compensacao do Cheque */,
cctnom VARCHAR(30) /* Nome do Conta Corrente (Vem do SRCTAB) */,
cctndr VARCHAR(14) /* Numero do Documento Referencia */,
cctaln CHAR(2) /* Codigo da Alinea de Devolucao do Cheque */,
ccttpm CHAR(1) /* Tipo Movimento 'C'ompra/'V'enda */,
cctjur NUMERIC(11, 2) /* Juros a Receber (CNH) */,
cctvjm NUMERIC(11, 2) /* Valor do Juros de Mora (CNH) - Cheques */,
CONSTRAINT ck_cebcct_tpm CHECK (ccttpm IN (' ','C','V')
OR ccttpm IS NULL),
CONSTRAINT pk_cctkey PRIMARY KEY (ccttcc,cctre1,cctncc),
CONSTRAINT fk_ccttcc FOREIGN KEY (ccttcc)
REFERENCES tb_cebtab_tcc (tcccod),
CONSTRAINT fk_cctre1 FOREIGN KEY (cctre1)
REFERENCES tb_tracad (tracod),
CONSTRAINT fk_ccttr1 FOREIGN KEY (ccttr1)
REFERENCES tb_tracad (tracod),
CONSTRAINT fk_ccterc FOREIGN KEY (ccterc)
REFERENCES tb_tracad (tracod),
CONSTRAINT fk_cctbco FOREIGN KEY (cctbco)
REFERENCES tb_cebtab_bco (bcocod),
CONSTRAINT fk_cctemp_cpi FOREIGN KEY (cctemp_cpi)
REFERENCES tb_cbaemp (empcod),
/* CONSTRAINT fk_cctcpi FOREIGN KEY (cctemp_cpi,cctcpi) */
/* REFERENCES tb_cbacta (ctaemp,ctacod), */
CONSTRAINT fk_cctcpg FOREIGN KEY (cctcpg)
REFERENCES tb_tabcpg (cpgcod),
CONSTRAINT fk_cctemi FOREIGN KEY (cctemi)
REFERENCES tb_tracad (tracod),
CONSTRAINT fk_cctcpt FOREIGN KEY (cctcpt)
REFERENCES tb_tracad (tracod)
);
CREATE INDEX ix1_cebcct ON tb_cebcct(ccttcc,ccttr1,cctst1,cctre1,cctdt1,cctsq1);
CREATE INDEX ix2_cebcct ON tb_cebcct(cctst1,cctdt1,cctfl2,ccttcc);
CREATE INDEX ix3_cebcct ON tb_cebcct(cctre1,cctst1,cctdt1,cctfl2,ccttcc);
CREATE INDEX ix4_cebcct ON tb_cebcct(ccttcc,cctst1,cctre1,cctdt1);
CREATE INDEX ix5_cebcct ON tb_cebcct(ccttcc,cctdis,cctre1,ccttr1,cctnct);
CREATE INDEX ix6_cebcct ON tb_cebcct(ccttcc,cctdis,cctre1,cctdat);
CREATE INDEX ix7_cebcct ON tb_cebcct(cctst1,cctdat,cctfl2,ccttcc);
CREATE INDEX ix8_cebcct ON tb_cebcct(cctre1,cctst1,cctdat,ccttcc,cctfl2);
CREATE INDEX ix9_cebcct ON tb_cebcct(cctst1,ccttcc,cctdt1,cctre1);
CREATE INDEX ixA_cebcct ON tb_cebcct(ccttcc,cctre1,cctst1,cctdt1);
CREATE INDEX ixB_cebcct ON tb_cebcct(ccttcc,cctre1,cctdt1,cctst1);
CREATE INDEX ixC_cebcct ON tb_cebcct(cctst1,ccttcc,cctre1,cctdt1);
CREATE INDEX ixD_cebcct ON tb_cebcct(ccttcc,cctscc,cctre1,cctst1,cctdt1);
CREATE INDEX ixE_cebcct ON tb_cebcct(ccttcc,cctst1,cctcpt,ccttco,cctdt1);
CREATE INDEX ixF_cebcct ON tb_cebcct(ccttcc,cctst1,ccttco,cctcpt,cctdt1);
CREATE INDEX ixG_cebcct ON tb_cebcct(cctest,ccttcc,cctre1,cctnct);
CREATE INDEX ixH_cebcct ON tb_cebcct(cctst1,cctfl2,cctre1,cctdt1);
CREATE INDEX ixI_cebcct ON tb_cebcct(cctst1,cctbco,cctdt1,cctre1);
CREATE INDEX ixJ_cebcct ON tb_cebcct(cctst1,cctre1,cctdt1,ccttcc,cctncc,cctsq1);
CREATE INDEX ixK_cebcct ON tb_cebcct(cctcdv,ccttpm,cctdtp,ccttcc,cctncc,cctsq1);
CREATE INDEX ixO0_cebcct ON tb_cebcct(ccttcc,cctncc);
CREATE INDEX ixO1_cebcct ON tb_cebcct(ccttr1,cctst1,cctdt1,cctfl2,ccttcc);
CREATE INDEX ixO2_cebcct ON tb_cebcct(ccttr1,cctst1,ccttcc,cctdt1);
CREATE INDEX ixO3_cebcct ON tb_cebcct(cctst1,ccttcc,cctdtp,cctre1);
CREATE INDEX ixO4_cebcct ON tb_cebcct(cctst1,cctfl2,cctdtp,cctre1);
