/*
Created		20/01/2009
Modified		17/11/2010
Project		ATS Vertical
Model		
Company		Landix Sistemas
Author		Keila Rodrigues e Tiago Morais
Version		01.06.00
Database		Firebird 
*/


Create Domain "NUINT" As Integer Default 0;
Create Domain "NUDEC" As Decimal(15,4) Default 0;
Create Domain "TStamp (10)" As Timestamp;
Create Domain "CODIGO" As Varchar(25);
Create Domain "IDBOOLEAN" As Char(1) Default '0';


Create Table "TMVSEQP"  (
	"CDEQP" Varchar(25) NOT NULL,
	"CDCNX" Varchar(25) NOT NULL,
	"CDUNID" Varchar(25) NOT NULL,
	"CDPAI" Varchar(25) NOT NULL,
	"DSNOME" Varchar(20),
	"IDCRG" Char(1) Default '1' NOT NULL,
 Primary Key ("CDEQP")
);

Create Table "TMVSPARAMGL"  (
	"CDRGST" Varchar(25) NOT NULL,
	"CDUSU" Varchar(25) NOT NULL,
	"CDTPVD" Varchar(25) NOT NULL,
	"DSSMTP" Varchar(256),
	"DSEMRT" Varchar(256),
	"DSEMTI" Varchar(50),
	"DSEMCF" Varchar(256),
	"DSTPAU" Varchar(25),
	"DSEMUS" Varchar(50),
	"DSEMSN" Varchar(50),
	"DSLMHS" Varchar(256),
	"DSLMUS" Varchar(50),
	"DSLMSH" Varchar(50),
	"DSLMSC" Varchar(50),
	"NULMPT" Integer,
	"IDLMAU" Char(1) Default '0' NOT NULL,
	"IDLMHS" Char(1) Default '0' NOT NULL,
	"NUDICR" Integer Default 0 NOT NULL,
	"IDTPCR" Char(1) Default '0' NOT NULL,
	"NRDNFP" Integer Default 0 NOT NULL,
	"IDLMLO" Char(1) Default '0',
	"HRVC1" Char(8),
	"HRVC2" Char(8),
	"HRVC3" Char(8),
	"HRVC4" Char(8),
	"HRVC5" Char(8),
	"HRVCA1" Char(8),
	"HRVCA2" Char(8),
	"HRVCA3" Char(8),
	"HRVCA4" Char(8),
	"HRVCA5" Char(8),
	"NUVERS" Varchar(8),
	"DTCRG" Date Default '01/01/1900' NOT NULL,
	"QTCOTA" Decimal(15,4) Default 0,
	"DSEMP" Varchar(25),
	"IDMSG" Char(1) Default '0',
	"IDMUR" Char(1) Default '0',
	"NUDRPD" Integer Default 0 NOT NULL,
	"DTHRVC" Timestamp,
	"IDVLCA" Char(1) Default '0',
	"NUDMAN" Integer Default 0,
	"NUBCK" Integer Default 0,
	"IDPROC" Char(1) Default '0',
	"NUDIMA" Integer Default 0,
	"IDVEIC" Char(1) Default '0',
	"CDCNDV" Varchar(25),
	"DSEST" Char(2),
	"IDST" Char(1) Default '0',
	"QTCHEQ" Integer Default 0,
	"IDCTVV" Char(1) Default '0',
	"NUDIAR" Integer Default 10,
 Primary Key ("CDRGST")
);

Create Table "TMVSPARAM"  (
	"CDPRFL" Varchar(25) NOT NULL,
	"IDPDBL" Char(1) Default '0' NOT NULL,
	"NRDINA" Integer Default 0 NOT NULL,
	"IDDCMX" Char(1) Default '0' NOT NULL,
	"IDPERF" Char(1) Default '0' NOT NULL,
	"NUVALI" Integer Default 0,
	"IDDBCR" Char(1) Default '0' NOT NULL,
	"IDPDLC" Char(1) Default '0' NOT NULL,
	"IDVIND" Char(1) Default '0',
	"IDEMMS" Char(1) Default '0',
	"IDESTV" Char(1) Default '0',
	"PCDSMX" Decimal(15,4) Default 0 NOT NULL,
	"IDTRPP" Char(1) Default '0',
	"IDSICL" Char(1) Default '0',
	"IDMDVD" Char(1) Default '0',
	"IDDESC" Char(1) Default '0',
	"PCDCOB" Decimal(15,4) Default 0,
	"IDEDVL" Char(1) Default '0',
	"IDEDDT" Char(1) Default '0',
	"PCTXJR" Decimal(15,4) Default 0,
	"IDIMP" Char(1) Default '0',
	"IDEDVV" Char(1) Default '0' NOT NULL,
 Primary Key ("CDPRFL")
);

Create Table "TMVSITE"  (
	"CDPED" Varchar(25) NOT NULL,
	"CDPROD" Varchar(25) NOT NULL,
	"CDGRAD" Varchar(25) NOT NULL,
	"QTDVND" Decimal(15,4) Default 0 NOT NULL,
	"VLTAB" Decimal(15,4) Default 0 NOT NULL,
	"VLVEND" Decimal(15,4) Default 0 NOT NULL,
	"PCDSAC" Decimal(15,4) Default 0 NOT NULL,
	"VLPROD" Decimal(15,4) Default 0,
	"DSMSEX" Varchar(4000),
	"VLICMS" Decimal(15,4) Default 0,
	"PCBSIC" Decimal(15,4) Default 0,
	"PCALIC" Decimal(15,4) Default 0,
	"VLST" Decimal(15,4) Default 0,
	"PCBSST" Decimal(15,4) Default 0,
	"PCALST" Decimal(15,4) Default 0,
	"VLITIM" Decimal(15,4) Default 0,
	"CDTRIB" Varchar(3),
	"DSCFOP" Varchar(4),
	"VLBSIC" Decimal(15,4) Default 0,
	"VLBSST" Decimal(15,4) Default 0,
 Primary Key ("CDPED","CDPROD","CDGRAD")
);

Create Table "TMVSCAB"  (
	"CDPED" Varchar(25) NOT NULL,
	"CDTPVD" Varchar(25) NOT NULL,
	"CDCNPG" Varchar(25) NOT NULL,
	"CDEQP" Varchar(25) NOT NULL,
	"CDCL" Varchar(25) NOT NULL,
	"DTCRIA" Timestamp,
	"DTALT" Timestamp,
	"DTFECH" Timestamp,
	"DTENT" Timestamp,
	"DTFAT" Timestamp,
	"VLPED" Decimal(15,4) Default 0 NOT NULL,
	"DSOBS" Varchar(127),
	"NUPECL" Varchar(25),
	"DTPROC" Timestamp NOT NULL,
	"NUPROC" Varchar(25) NOT NULL,
	"IDEXP" Char(1),
	"DSMSEX" Varchar(4000),
	"IDSTS" Char(1),
	"CDMW" Varchar(39) Default '0' NOT NULL,
	"IDMDNG" Char(2),
	"IDTPPD" Char(1),
	"IDCAN" Char(1) Default '0',
	"NUNOTA" Varchar(25),
	"NUSERI" Varchar(25),
	"VLICMS" Decimal(15,4) Default 0,
	"VLST" Decimal(15,4) Default 0,
	"VLPDIM" Decimal(15,4) Default 0,
	"IDEMI" Char(1),
	"QTREIM" Integer Default 0,
	"DTEMIS" Timestamp,
	"VLBSIC" Decimal(15,4) Default 0,
	"VLBSST" Decimal(15,4) Default 0,
 Primary Key ("CDPED")
);

Create Table "TMVSMNVCL"  (
	"CDINC" Integer NOT NULL,
	"CDCL" Varchar(25) NOT NULL,
	"CDMOT" Varchar(25) NOT NULL,
	"CDEQP" Varchar(25) NOT NULL,
	"DTMNV" Timestamp NOT NULL,
	"DTPROC" Timestamp NOT NULL,
	"NUPROC" Varchar(25) NOT NULL,
	"IDEXP" Char(1),
	"DSMSEX" Varchar(4000),
	"IDSTS" Char(1) Default '0',
 Primary Key ("CDINC")
);

Create Table "TMVSCLIALT"  (
	"CDCL" Varchar(25) NOT NULL,
	"CDCID" Varchar(25) NOT NULL,
	"CDATIV" Varchar(25) NOT NULL,
	"CDCNPG" Varchar(25) NOT NULL,
	"CDEQP" Varchar(25) NOT NULL,
	"CDTPVD" Varchar(25) NOT NULL,
	"DSRAZ" Varchar(40),
	"DSFAN" Varchar(40),
	"DSCGCP" Varchar(20),
	"DSIERG" Varchar(20),
	"VLCRED" Decimal(15,4),
	"IDPFPJ" Char(1),
	"IDBLQ" Char(1) Default '0',
	"IDTITV" Char(1) Default '0',
	"NUDSIN" Integer Default 0,
	"DSOBS" Varchar(40),
	"DSENDP" Varchar(40),
	"DSBAIP" Varchar(40),
	"DSCEPP" Varchar(10),
	"DSTLPR" Varchar(15),
	"DSFAXP" Varchar(15),
	"DSENDC" Varchar(40),
	"DSBAIC" Varchar(40),
	"CDCIDC" Varchar(25),
	"DSCEPC" Varchar(10),
	"IDIAE" Char(1),
	"DSEDEN" Varchar(60),
	"CDCIDE" Varchar(25),
	"DSBAEN" Varchar(30),
	"NUCPEN" Varchar(8),
	"DTPROC" Timestamp NOT NULL,
	"NUPROC" Varchar(25) NOT NULL,
	"IDEXP" Char(1),
	"DSMSEX" Varchar(4000),
 Primary Key ("CDCL")
);

Create Table "TMVSCTT"  (
	"CDCL" Varchar(25) NOT NULL,
	"DSCTT" Varchar(30) NOT NULL,
	"CDEQP" Varchar(25) NOT NULL,
	"NRTCTT" Varchar(15),
	"DSEMAI" Varchar(30),
	"DSDEP" Varchar(30),
	"IDIAE" Char(1) Default '0',
	"DTPROC" Timestamp NOT NULL,
	"NUPROC" Varchar(25) NOT NULL,
	"IDEXP" Char(1),
	"DSMSEX" Varchar(4000),
 Primary Key ("CDCL","DSCTT")
);

Create Table "TAFCTT"  (
	"COD_CLIENTE" Varchar(25) NOT NULL,
	"NOM_CONTATO" Varchar(30) NOT NULL,
	"NUM_TELEFONE" Varchar(15),
	"DES_EMAIL" Varchar(30),
	"IDIAE" Char(1) Default '0',
	"DSDEP" Varchar(30),
	"IMPORTADO" Varchar(25) NOT NULL,
	"DTPROC" Timestamp NOT NULL,
	"NUPROC" Varchar(25) NOT NULL,
	"MSG_IMPORTACAO" Varchar(300),
 Primary Key ("COD_CLIENTE","NOM_CONTATO")
);

Create Table "TAFITE"  (
	"COD_PEDIDO" Varchar(25) NOT NULL,
	"COD_PRODUTO" Varchar(25) NOT NULL,
	"COD_GRADE" Varchar(25) NOT NULL,
	"VLR_TABELA" Decimal(15,4) Default 0 NOT NULL,
	"VLR_VENDA" Decimal(15,4) Default 0 NOT NULL,
	"VLR_TOTPROD" Decimal(15,4) Default 0,
	"PER_DESCONTO" Decimal(15,4) Default 0 NOT NULL,
	"QTD_VENDA" Decimal(15,4) Default 0 NOT NULL,
	"QTDE_ATENDIDA" Decimal(15,4) Default 0,
	"QTDE_FALTA" Decimal(15,4) Default 0,
	"MSG_IMPORTACAO" Varchar(300),
	"VLR_ICMS" Decimal(15,4) Default 0,
	"PC_ICMSBS" Decimal(15,4) Default 0,
	"PC_ICMSAL" Decimal(15,4) Default 0,
	"VLR_ST" Decimal(15,4) Default 0,
	"PC_STBS" Decimal(15,4) Default 0,
	"PC_STAL" Decimal(15,4) Default 0,
	"VLR_ITEIMP" Decimal(15,4) Default 0,
	"COD_TRIB" Varchar(3),
	"CFOP" Varchar(4),
	"VLR_BASEICMS" Decimal(15,4) Default 0,
	"VLR_BASEST" Decimal(15,4) Default 0,
 Primary Key ("COD_PEDIDO","COD_PRODUTO","COD_GRADE")
);

Create Table "TAFCLIALT"  (
	"COD_CLIENTE" Varchar(25) NOT NULL,
	"COD_TIPOVENDA" Varchar(25) NOT NULL,
	"COD_CONDPGTO" Varchar(25) NOT NULL,
	"COD_RAMOATIV" Varchar(25) NOT NULL,
	"DES_RAZAO" Varchar(40),
	"DES_FANTASIA" Varchar(40),
	"NUM_CGCCPF" Varchar(20),
	"NUM_IERG" Varchar(20),
	"COD_VENDEDOR" Varchar(25) NOT NULL,
	"VLR_CREDITO" Decimal(15,4),
	"IDF_TIPPESSOA" Char(1),
	"IDF_BLOQUEIO" Char(1) Default '0',
	"IDF_TITULOS" Char(1) Default '0',
	"DES_OBS" Varchar(40),
	"COD_CIDPRIN" Varchar(25),
	"DES_ENDERECO" Varchar(40),
	"DES_BAIRRO" Varchar(40),
	"NUM_CEP" Varchar(10),
	"NUM_TELEFONE" Varchar(15),
	"NUM_FAX" Varchar(15),
	"COD_CIDCOB" Varchar(25),
	"DES_ENDERECOCOB" Varchar(40),
	"DES_BAIRROCOB" Varchar(40),
	"NUM_CEPCOB" Varchar(10),
	"COD_CIDENT" Varchar(25),
	"DES_ENDERECOENT" Varchar(60),
	"DES_BAIRROENT" Varchar(30),
	"NUM_CEPENT" Varchar(8),
	"IDIAE" Char(1),
	"MSG_IMPORTACAO" Varchar(300),
	"IMPORTADO" Varchar(25) NOT NULL,
	"DTPROC" Timestamp NOT NULL,
	"NUPROC" Varchar(25) NOT NULL,
 Primary Key ("COD_CLIENTE")
);

Create Table "TAFMNVCL"  (
	"NUM_MOT_NVENDA" Integer NOT NULL,
	"COD_VENDEDOR" Varchar(25) NOT NULL,
	"COD_CLIENTE" Varchar(25) NOT NULL,
	"COD_MOTNVENDA" Varchar(25) NOT NULL,
	"DAT_INCLUSAO" Timestamp NOT NULL,
	"IMPORTADO" Varchar(25) NOT NULL,
	"DTPROC" Timestamp NOT NULL,
	"NUPROC" Varchar(25) NOT NULL,
	"MSG_IMPORTACAO" Varchar(300),
 Primary Key ("NUM_MOT_NVENDA")
);

Create Table "TAFCAB"  (
	"COD_PEDIDO" Varchar(25) NOT NULL,
	"COD_VENDEDOR" Varchar(25) NOT NULL,
	"COD_CONDPAGTO" Varchar(25) NOT NULL,
	"COD_CLIENTE" Varchar(25) NOT NULL,
	"COD_TIPOVENDA" Varchar(25) NOT NULL,
	"DAT_HORACRIACAOPED" Timestamp,
	"DAT_HORAALTERPED" Timestamp,
	"DAT_HORAFECHPED" Timestamp,
	"DAT_ENTREGA" Timestamp,
	"DAT_FATURAMENTO" Timestamp,
	"VLR_TOTAL" Decimal(15,4) Default 0 NOT NULL,
	"DES_OBS" Varchar(127),
	"NUM_PEDCLI" Varchar(25),
	"CDMW" Varchar(39) NOT NULL,
	"IMPORTADO" Varchar(25) NOT NULL,
	"DTPROC" Timestamp NOT NULL,
	"NUPROC" Varchar(25) NOT NULL,
	"MSG_IMPORTACAO" Varchar(300),
	"IDF_MOD" Char(2),
	"IDF_TIPPED" Char(1),
	"IDF_CANC" Char(1) Default '0',
	"NUM_NOTA" Varchar(25),
	"NUM_SERIE" Varchar(25),
	"VLR_ICMS" Decimal(15,4) Default 0,
	"VLR_ST" Decimal(15,4) Default 0,
	"VLR_PEDIMP" Decimal(15,4) Default 0,
	"IDF_EMISSAO" Char(1),
	"QTD_REIMPRESSA" Integer Default 0,
	"DT_EMISSAO" Timestamp,
	"VLR_BASEICMS" Decimal(15,4) Default 0,
	"VLR_BASEST" Decimal(15,4) Default 0,
 Primary Key ("COD_PEDIDO")
);

Create Table "TMVSDADINIC"  (
	"NUNOTA" Varchar(25) NOT NULL,
	"NUSERI" Varchar(25),
	"CDVEIC" Varchar(25),
	"CDPORT" Varchar(10),
 Primary Key ("NUNOTA")
);

Create Table "TMVSCBMANIFPDA"  (
	"NUNOTA" Varchar(25) NOT NULL,
	"NUSERI" Varchar(25) NOT NULL,
	"CDEQP" Varchar(25),
	"DTEMIS" Timestamp,
	"CDVEIC" Varchar(25),
	"IDHOMO" Char(1) Default '0',
	"IDTPNT" Char(1) Default '0',
	"IDOCUL" Char(1) Default '0',
 Primary Key ("NUNOTA","NUSERI")
);

Create Table "TMVSITMANIFPDA"  (
	"NUNOTA" Varchar(25) NOT NULL,
	"NUSERI" Varchar(25) NOT NULL,
	"CDPROD" Varchar(25) NOT NULL,
	"QTPROD" Integer Default 0,
 Primary Key ("NUNOTA","NUSERI","CDPROD")
);

Create Table "TMVSESTDISP"  (
	"CDPROD" Varchar(25) NOT NULL,
	"QTPROD" Integer Default 0,
 Primary Key ("CDPROD")
);

Create Table "TMVSFINANC"  (
	"NUPGTO" Integer Default 0 NOT NULL,
	"NUPARC" Integer Default 0 NOT NULL,
	"CDPED" Varchar(25) NOT NULL,
	"IDFORM" Char(1),
	"IDTPBO" Char(1),
	"IDTPCH" Char(1),
	"NUCART" Integer Default 0,
	"NUBCBL" Varchar(4),
	"NUNOSS" Varchar(20),
	"NUCHEQ" Varchar(10),
	"NUBCCH" Varchar(4),
	"DSAGCH" Varchar(5),
	"NUCTCH" Varchar(15),
	"DTVENC" Timestamp,
	"VLPG" Decimal(15,4) Default 0,
	"DTPROC" Timestamp,
	"NUPROC" Varchar(25),
	"IDEXP" Char(1),
	"DSMSEX" Varchar(4000),
	"IDSTS" Char(1) Default '0',
	"DTPGTO" Timestamp,
	"DSNMTR" Varchar(40),
	"DSCPF" Varchar(20),
 Primary Key ("NUPGTO_","NUPARC","CDPED")
);

Create Table "TAFFINANC"  (
	"NU_PGTO" Integer Default 0 NOT NULL,
	"COD_VENDA" Varchar(25) NOT NULL,
	"IDF_FORMA" Char(1),
	"NU_PARCELA" Integer Default 0,
	"IDF_TIPOBOLETO" Char(1),
	"IDF_TIPOCHEQUE" Char(1),
	"NU_CARTEIRA" Integer Default 0,
	"NU_BANCOBOL" Varchar(4),
	"NU_NOSSO" Varchar(20),
	"NU_CHEQUE" Varchar(10),
	"NU_BANCOCH" Varchar(4),
	"DS_AGENCIACH" Varchar(5),
	"NU_CONTACH" Varchar(15),
	"DT_VENC" Timestamp,
	"VLR_PAGO" Decimal(15,4) Default 0,
	"IMPORTADO" Varchar(25),
	"DTPROC" Timestamp,
	"NUPROC" Varchar(25),
	"MSG_IMPORTACAO" Varchar(300),
	"DT_PAGTO" Timestamp,
	"DS_NOMTERC" Varchar(40),
	"DS_CPFCNPJ" Varchar(20),
 Primary Key ("NU_PGTO")
);

Create Table "TMVSCOBRANCAS"  (
	"NUTIT" Varchar(25) NOT NULL,
	"CDEQP" Varchar(25) NOT NULL,
	"CDCL" Varchar(25) NOT NULL,
	"DSTPTI" Varchar(2),
	"DTBAIX" Timestamp,
	"QTDICR" Integer Default 0,
	"PCTXJR" Decimal(15,4) Default 0,
	"VLJR" Decimal(15,4) Default 0,
	"VLTPG" Decimal(15,4) Default 0,
	"DTPROC" Timestamp,
	"NUPROC" Varchar(25),
	"IDEXP" Char(1),
	"DSMSEX" Varchar(4000),
	"IDSTS" Char(1) Default '0',
 Primary Key ("NUTIT")
);

Create Table "TMVSPGTOCOB"  (
	"NUPGTO" Varchar(25) NOT NULL,
	"NUTIT" Varchar(25) NOT NULL,
	"CDCL" Varchar(25) NOT NULL,
	"DSTPTI" Varchar(2),
	"IDFORM" Char(1),
	"IDTPCH" Char(1),
	"NUCHEQ" Varchar(10),
	"NUBCCH" Varchar(4),
	"DSAGCH" Varchar(5),
	"NUCTCH" Varchar(15),
	"VLPG" Decimal(15,4) Default 0,
	"DSNMTR" Varchar(40),
	"DSCPF" Varchar(20),
 Primary Key ("NUPGTO","NUTIT")
);

Create Table "TAFCOBRANCAS"  (
	"NRO_TIT" Varchar(25) NOT NULL,
	"COD_VENDEDOR" Varchar(25) NOT NULL,
	"COD_CLI" Varchar(25) NOT NULL,
	"DES_TPTIT" Varchar(2),
	"DT_BAIXA" Timestamp,
	"CARENCIA" Integer Default 0,
	"TX_JUROS" Decimal(15,4) Default 0,
	"VLR_JURO" Decimal(15,4) Default 0,
	"VLR_TOTPAG" Decimal(15,4) Default 0,
	"IMPORTADO" Char(1),
	"DTPROC" Timestamp,
	"NUPROC" Varchar(25),
	"MSG_IMPORTACAO" Varchar(300),
 Primary Key ("NRO_TIT")
);

Create Table "TAFPGTOCOB"  (
	"NRO_PGTO" Varchar(25) NOT NULL,
	"NRO_TIT" Varchar(25) NOT NULL,
	"COD_CLI" Varchar(25) NOT NULL,
	"DES_TPTIT" Varchar(2),
	"IDF_FORMA" Char(1),
	"IDF_TPCHEQ" Char(1),
	"NRO_CHEQ" Varchar(10),
	"NRO_BANCO" Varchar(4),
	"AGENCIA" Varchar(5),
	"NRO_CONTA" Varchar(15),
	"VLR_PAGO" Decimal(15,4) Default 0,
	"DS_NOMTERC" Varchar(40),
	"DS_CPFCNPJ" Varchar(20),
 Primary Key ("NRO_PGTO","NRO_TIT")
);

Create Table "TMVSCBMANIFRET"  (
	"CDRET" Varchar(25) NOT NULL,
	"CDEQP" Varchar(25) NOT NULL,
	"DSPLAC" Varchar(10),
	"DTEMIS" Timestamp,
	"DSMRMD" Varchar(20),
	"DTPROC" Timestamp,
	"NUPROC" Varchar(25),
	"IDEXP" Char(1),
	"DSMSEX" Varchar(4000),
	"IDSTS" Char(1) Default '0',
 Primary Key ("CDRET")
);

Create Table "TMVSITMANIFRET"  (
	"CDRET" Varchar(25) NOT NULL,
	"CDPROD" Varchar(25) NOT NULL,
	"QTPROD" Integer Default 0,
 Primary Key ("CDRET","CDPROD")
);

Create Table "TAFITMANIFRET"  (
	"COD_RETORNO" Varchar(25) NOT NULL,
	"COD_PRODUTO" Varchar(25) NOT NULL,
	"QTD_PRODUTO" Integer Default 0,
 Primary Key ("COD_RETORNO","COD_PRODUTO")
);

Create Table "TAFCBMANIFRET"  (
	"COD_RETORNO" Varchar(25) NOT NULL,
	"COD_VENDEDOR" Varchar(25) NOT NULL,
	"DES_PLACA" Varchar(10),
	"DT_EMISSAO" Timestamp,
	"DES_MARCMOD" Varchar(20),
	"IMPORTADO" Char(1),
	"DTPROC" Timestamp,
	"NUPROC" Varchar(25),
	"MSG_IMPORTACAO" Varchar(300),
 Primary Key ("COD_RETORNO")
);


Create Index "IDX_TMVSMNVCL_CDCL"  ON "TMVSMNVCL" ("CDCL");


