Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB General » View Thread |
Messages 1 to 7 of 7 total |
[REQ] Index use for Distinct query |
Thu, May 20 2010 10:59 AM | Permanent Link |
Mauro Botta | Hi
i know EDB 2.x don't use index for elaborate Distinct query i have make a my personal distinct function ( while... seek last+1.. end ) but it is not 100 % optimized. Tim may you to add index optimization for distinct query ? It's a very important and very old required ( see this forum..) |
Thu, May 20 2010 11:38 AM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Mauro,
<< i know EDB 2.x don't use index for elaborate Distinct query >> EDB will use a primary key's enforcing index for any DISTINCT query where the SELECT columns match the columns in the primary key's enforcing index. When EDB can't find such a matching index, it builds a temporary index on the result set that is used to eliminate duplicates as the result set is populated. -- Tim Young Elevate Software www.elevatesoft.com |
Thu, May 20 2010 11:51 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Mauro
I can see how reading the index would be faster for a single column DISTINCT but when you have two or more columns involved, some of which may not be indexed I can't envisage any better way than to go through the table. Can you? Its a bit like optimising the ORDER BY clause - if there's more than one column used you need a compound index matching the clause. Roy Lambert |
Fri, May 21 2010 4:55 AM | Permanent Link |
Mauro Botta | Enviroment :
Table : 60'000 records , fast network disk , fast A.V., PC SUPER POWER, WIN7 64... 8GB, Other 3 pc / users have open this table ( just for test - only browse ) I can't use the primary key for have a distinct query QUERY : SELECT DISTINCT ANNOORDINE FROM CORRIT or SELECT ANNOORDINE FROM CORRIT GROUYP BY ANNOORDINE I need the distinct value for field : ANNOORDINE ( year ) there are only 9 records ( 2001...2009 ) of good result. The query take 7 seconds for have this 9 records ( having a ANNOORDINE index ) I have try to delete ANNOORDINE index and now the query take 7 seconds , always. then....... i think EDB in real world don't use the indexes for have a distinct query. ================================================================================ SQL Query (Executed by ElevateDB 2.03 Build 7) Note: The SQL shown here is generated by ElevateDB and may not be exactly the same as the SQL that was originally entered. However, none of the differences alter the execution results in any way. ================================================================================ SELECT DISTINCT "ANNOORDINE" AS "ANNOORDINE" FROM "CORRIT" Source Tables ------------- CORRIT: 67125 rows Result Set ---------- The result set was insensitive and read-only The result set consisted of zero or more rows Result set I/O statistics ------------------------- Total rows visited: 67125 Row buffer manager Max buffer size: 32768 Buffer size: 288 Hits: 9 Misses: 0 Hit ratio: 1 Reads: 0 Bytes read: 0 Writes: 0 Bytes written: 0 Index page buffer manager Max buffer size: 65536 Buffer size: 8192 Hits: 67142 Misses: 0 Hit ratio: 1 Reads: 0 Bytes read: 0 Writes: 0 Bytes written: 0 ================================================================================ 9 row(s) returned in 7,301 secs ================================================================================ -------------------------------------------------------------------------- TABLE STRUCTURE SQL ( index at bottom ) CREATE TABLE "CorriT" ( "CODNEGOZIO" FLOAT DEFAULT 0 DESCRIPTION '[Field] Alias=Codice punto vendita Active=True ReportVisible=True FilterVisible=True', "ANNOORDINE" SMALLINT DEFAULT 0 DESCRIPTION '[Field] Alias=Anno documento Active=True ReportVisible=True FilterVisible=True', "NUMORDINE" FLOAT DEFAULT 0 DESCRIPTION '[Field] Alias=Numero documento Active=True ReportVisible=True FilterVisible=True', "DATAORDINE" DATE DESCRIPTION '[Field] Alias=Data documento Active=True ReportVisible=True FilterVisible=True', "ORA" VarChar(5) COLLATE "ANSI_CI" DEFAULT '' DESCRIPTION '[Field] Alias=Ora creazione documento Active=True ReportVisible=True FilterVisible=True', "BIS" VarChar(1) COLLATE "ANSI_CI" DEFAULT '' DESCRIPTION '[Field] Alias=Bis Active=True ReportVisible=True FilterVisible=True', "NUMORDINE_MANUALE" VarChar(20) COLLATE "ANSI" DEFAULT '' DESCRIPTION '[Field] Alias=Numero documento Manuale Active=True ReportVisible=True FilterVisible=True', "OPERATORE" SMALLINT DEFAULT 0 DESCRIPTION '[Field] Alias=Codice operatore Active=True ReportVisible=True FilterVisible=True', "FORNITORE" SMALLINT DEFAULT 0 DESCRIPTION '[Field] Alias= Active=False ReportVisible=True FilterVisible=True', "CODCLIENTE" FLOAT DEFAULT 0 DESCRIPTION '[Field] Alias=Codice intestatario documento Active=True ReportVisible=True FilterVisible=True', "DESCSOGGETTO" VarChar(40) COLLATE "ANSI_CI" DEFAULT '' DESCRIPTION '[Field] Alias=Intestatario documento - Ragione sociale Active=True ReportVisible=True FilterVisible=True', "DESCSOGGETTO_AGG" VarChar(50) COLLATE "ANSI_CI" DEFAULT '' DESCRIPTION '[Field] Alias=Intestatario documento - Ragione sociale aggiuntiva Active=True ReportVisible=True FilterVisible=True', "INDIRIZZO" VarChar(40) COLLATE "ANSI_CI" DEFAULT '' DESCRIPTION '[Field] Alias=Intestatario documento - Indirizzo Active=True ReportVisible=True FilterVisible=True', "CAP" VarChar(8) COLLATE "ANSI_CI" DEFAULT '' DESCRIPTION '[Field] Alias=Intestatario documento - CAP Active=True ReportVisible=True FilterVisible=True', "LOCALITA" VarChar(40) COLLATE "ANSI_CI" DEFAULT '' DESCRIPTION '[Field] Alias=Intestatario documento - Località Active=True ReportVisible=True FilterVisible=True', "PROVINCIA" VarChar(4) COLLATE "ANSI_CI" DEFAULT '' DESCRIPTION '[Field] Alias=Intestatario documento - Provincia Active=True ReportVisible=True FilterVisible=True', "STATO" VarChar(15) COLLATE "ANSI_CI" DEFAULT '' DESCRIPTION '[Field] Alias=Intestatario documento - Nazione Active=True ReportVisible=True FilterVisible=True', "CHIUSO" BOOLEAN DEFAULT False DESCRIPTION '[Field] Alias=Documento chiuso Active=True ReportVisible=True FilterVisible=True', "DEPOSITO" SMALLINT DEFAULT 0 DESCRIPTION '[Field] Alias=Deposito di default Active=True ReportVisible=True FilterVisible=True', "DEPOSITO_DEST" SMALLINT DEFAULT 0 DESCRIPTION '[Field] Alias=Deposito di destinazione Active=True ReportVisible=True FilterVisible=True', "CODPAGA" SMALLINT DEFAULT 0 DESCRIPTION '[Field] Alias=Codice pagamento Active=True ReportVisible=True FilterVisible=True', "DATASCADENZA" DATE DESCRIPTION '[Field] Alias=Data scadenza validità documento Active=True ReportVisible=True FilterVisible=True', "CODVALUTA" SMALLINT DEFAULT 0 DESCRIPTION '[Field] Alias=Codice valuta Active=True ReportVisible=True FilterVisible=True', "RAPPORTOEURO" FLOAT DEFAULT 0 DESCRIPTION '[Field] Alias= Active=False ReportVisible=True FilterVisible=True', "CAB" VarChar(6) COLLATE "ANSI_CI" DEFAULT '' DESCRIPTION '[Field] Alias=IBAN - CAB Active=True ReportVisible=True FilterVisible=True', "ABI" VarChar(6) COLLATE "ANSI_CI" DEFAULT '' DESCRIPTION '[Field] Alias=IBAN - ABI Active=True ReportVisible=True FilterVisible=True', "BANCA" VarChar(40) COLLATE "ANSI_CI" DEFAULT '' DESCRIPTION '[Field] Alias=Descrizione banca Active=True ReportVisible=True FilterVisible=True', "AGENZIA" VarChar(30) COLLATE "ANSI_CI" DEFAULT '' DESCRIPTION '[Field] Alias=Descrizione Agenzia banca Active=True ReportVisible=True FilterVisible=True', "CAPI" FLOAT DEFAULT 0 DESCRIPTION '[Field] Alias=Numero totale articoli Active=True ReportVisible=True FilterVisible=True', "COD_BANCA_APPOGGIO" INTEGER DEFAULT 0 DESCRIPTION '[Field] Alias=Codice banca di appoggio Active=True ReportVisible=True FilterVisible=True', "TOT_NONSCONTATO_NETTO" FLOAT DEFAULT 0 DESCRIPTION '[Field] Alias= Active=True ReportVisible=True FilterVisible=True', "IMPNETTO" FLOAT DEFAULT 0 DESCRIPTION '[Field] Alias=Importo netto documento manuale Active=True ReportVisible=True FilterVisible=True', "IMPIVATO" FLOAT DEFAULT 0 DESCRIPTION '[Field] Alias=Importo ivato documento manuale Active=True ReportVisible=True FilterVisible=True', "ANTICIPO" FLOAT DEFAULT 0 DESCRIPTION '[Field] Alias=Anticipo Active=True ReportVisible=True FilterVisible=True', "SCONTORIGA" FLOAT DEFAULT 0 DESCRIPTION '[Field] Alias=Sconto riga 1 ereditato dal cliente Active=True ReportVisible=True FilterVisible=True', "SCONTORIGA2" FLOAT DEFAULT 0 DESCRIPTION '[Field] Alias=Sconto riga 2 ereditato dal cliente Active=True ReportVisible=True FilterVisible=True', "SCONTORIGA3" FLOAT DEFAULT 0 DESCRIPTION '[Field] Alias=Sconto riga 3 ereditato dal cliente Active=True ReportVisible=True FilterVisible=True', "SCONTORIGA4" FLOAT DEFAULT 0 DESCRIPTION '[Field] Alias=Sconto riga 4 ereditato dal cliente Active=True ReportVisible=True FilterVisible=True', "SCONTORIGAMAG" FLOAT DEFAULT 0 DESCRIPTION '[Field] Alias=Sconto riga 5 ereditato dal cliente Active=True ReportVisible=True FilterVisible=True', "SCONTOAPP" FLOAT DEFAULT 0 DESCRIPTION '[Field] Alias=Sconto manuale documento Active=True ReportVisible=True FilterVisible=True', "PREZACQUISVERO" FLOAT DEFAULT 0 DESCRIPTION '[Field] Alias=Importo di acquisto netto documento Active=True ReportVisible=True FilterVisible=True', "LISTINO" SMALLINT DEFAULT 0 DESCRIPTION '[Field] Alias=Fascia prezzi documento Active=True ReportVisible=True FilterVisible=True', "IMPNET_C" FLOAT DEFAULT 0 DESCRIPTION '[Field] Alias=Importo netto documento Active=True ReportVisible=True FilterVisible=True', "IMPNETIV_C" FLOAT DEFAULT 0 DESCRIPTION '[Field] Alias=Importo ivato documento Active=True ReportVisible=True FilterVisible=True', "IMPIVNOSCO" FLOAT DEFAULT 0 DESCRIPTION '[Field] Alias= Active=False ReportVisible=True FilterVisible=True', "NUMARTICOLI" FLOAT DEFAULT 0 DESCRIPTION '[Field] Alias= Active=False ReportVisible=True FilterVisible=True', "STATOORDINE" VarChar(1) COLLATE "ANSI_CI" DEFAULT '' DESCRIPTION '[Field] Alias=Stato movimnetazione documento (N-S-P) Active=True ReportVisible=True FilterVisible=True', "OF_STATO_ORDINE" VarChar(1) COLLATE "ANSI_CI" DEFAULT '' DESCRIPTION '[Field] Alias=Stato evadibilità ordine fornitore Active=True ReportVisible=True FilterVisible=True', "LIBERO" VarChar(10) COLLATE "ANSI_CI" DEFAULT '' DESCRIPTION '[Field] Alias=Campo libero Active=True ReportVisible=True FilterVisible=True', "DATAEVAS" DATE DESCRIPTION '[Field] Alias=Data evasione Active=True ReportVisible=True FilterVisible=True', "ORAEVAS" VarChar(5) COLLATE "ANSI_CI" DEFAULT '' DESCRIPTION '[Field] Alias=Ora evasione documento Active=True ReportVisible=True FilterVisible=True', "PRESSO" VarChar(30) COLLATE "ANSI_CI" DEFAULT '' DESCRIPTION '[Field] Alias=Da evadere presso Active=True ReportVisible=True FilterVisible=True', "SCHEDACLIENTENEGOZIO" FLOAT DEFAULT 0 DESCRIPTION '[Field] Alias=Commessa di riferimento - Punto vendita Active=True ReportVisible=True FilterVisible=True', "SCHEDACLIENTE" FLOAT DEFAULT 0 DESCRIPTION '[Field] Alias=Commessa di riferimento - Numero Active=True ReportVisible=True FilterVisible=True', "SCHEDACLIENTEANNO" SMALLINT DEFAULT 0 DESCRIPTION '[Field] Alias=Commessa di riferimento - Anno Active=True ReportVisible=True FilterVisible=True', "BOLLARESO" BOOLEAN DEFAULT False DESCRIPTION '[Field] Alias=DDT di reso Active=True ReportVisible=True FilterVisible=True', "STATO_TRASFORMAZIONE" VarChar(1) COLLATE "ANSI_CI" DEFAULT '' DESCRIPTION '[Field] Alias=Documento trasformato Active=True ReportVisible=True FilterVisible=True', "COD_AGENTE" SMALLINT DEFAULT 0 DESCRIPTION '[Field] Alias=Codice agente 1 Active=True ReportVisible=True FilterVisible=True', "COD_AGENTE_2" SMALLINT DEFAULT 0 DESCRIPTION '[Field] Alias=Codice agente 2 Active=True ReportVisible=True FilterVisible=True', "COD_AGENTE_3" SMALLINT DEFAULT 0 DESCRIPTION '[Field] Alias=Codice agente 3 Active=True ReportVisible=True FilterVisible=True', "AGENTE_PERC" FLOAT DEFAULT 0 DESCRIPTION '[Field] Alias= Active=False ReportVisible=True FilterVisible=True', "AGENTE_PROVVIGIONE" FLOAT DEFAULT 0 DESCRIPTION '[Field] Alias= Active=False ReportVisible=True FilterVisible=True', "CODLINGUA" SMALLINT DEFAULT 0 DESCRIPTION '[Field] Alias=Codice lingua Active=True ReportVisible=True FilterVisible=True', "CODICE_FASE_LAVORATIVA_PADRE" INTEGER DEFAULT 0 DESCRIPTION '[Field] Alias=Codice fase lavorativa padre Active=True ReportVisible=True FilterVisible=True', "CODICE_FASE_LAVORATIVA" INTEGER DEFAULT 0 DESCRIPTION '[Field] Alias=Codice fase lavorativa Active=True ReportVisible=True FilterVisible=True', "CAUSALE_ORDINE_CLIENTE" FLOAT DEFAULT 0 DESCRIPTION '[Field] Alias=Causale ordine cliente Active=True ReportVisible=True FilterVisible=True', "CAUSALE_ORDINE_FORNITORE" FLOAT DEFAULT 0 DESCRIPTION '[Field] Alias=Causale ordine fornitore Active=True ReportVisible=True FilterVisible=True', "FLAG_FATTURA_ACCOMPAGNATORIA" BOOLEAN DEFAULT False DESCRIPTION '[Field] Alias=Fattura accompagnatoria Active=True ReportVisible=True FilterVisible=True', "SPED_CODINDSPED" SMALLINT DEFAULT 0 DESCRIPTION '[Field] Alias=Dati spedizione - Codice destinazione alternativa Active=True ReportVisible=False FilterVisible=True', "SPED_DESC" VarChar(40) COLLATE "ANSI_CI" DEFAULT '' DESCRIPTION '[Field] Alias=Destinazione merci - Ragione sociale Active=True ReportVisible=True FilterVisible=True', "SPED_INDI" VarChar(40) COLLATE "ANSI_CI" DEFAULT '' DESCRIPTION '[Field] Alias=Destinazione merci - Indirizzo Active=True ReportVisible=True FilterVisible=True', "SPED_CAP" VarChar(8) COLLATE "ANSI_CI" DEFAULT '' DESCRIPTION '[Field] Alias=Destinazione merci - CAP Active=True ReportVisible=True FilterVisible=True', "SPED_LOCALITA" VarChar(40) COLLATE "ANSI_CI" DEFAULT '' DESCRIPTION '[Field] Alias=Destinazione merci - Località Active=True ReportVisible=True FilterVisible=True', "SPED_PROVINCIA" VarChar(4) COLLATE "ANSI_CI" DEFAULT '' DESCRIPTION '[Field] Alias=Destinazione merci - Provincia Active=True ReportVisible=True FilterVisible=True', "SPED_TELEFONO" VarChar(25) COLLATE "ANSI_CI" DEFAULT '' DESCRIPTION '[Field] Alias=Destinazione merci - Telefono Active=True ReportVisible=True FilterVisible=True', "SPED_AMEZZO" VarChar(1) COLLATE "ANSI_CI" DEFAULT '' DESCRIPTION '[Field] Alias=Dati spedizione - Tipo spedizione Active=True ReportVisible=True FilterVisible=True', "SPED_VETTORE" SMALLINT DEFAULT 0 DESCRIPTION '[Field] Alias=Dati spedizione - Vettore Active=True ReportVisible=True FilterVisible=True', "SPED_DATA" DATE DESCRIPTION '[Field] Alias=Dati spedizione - Data Active=True ReportVisible=True FilterVisible=True', "SPED_ORA" VarChar(5) COLLATE "ANSI_CI" DEFAULT '' DESCRIPTION '[Field] Alias=Dati spedizione - Ora Active=True ReportVisible=True FilterVisible=True', "SPED_ASPETTO" VarChar(25) COLLATE "ANSI_CI" DEFAULT '' DESCRIPTION '[Field] Alias=Dati spedizione - Aspetto dei beni Active=True ReportVisible=True FilterVisible=True', "SPED_NCOLLI" FLOAT DEFAULT 0 DESCRIPTION '[Field] Alias=Dati spedizione - Numero colli Active=True ReportVisible=True FilterVisible=True', "SPED_PESO" VarChar(8) COLLATE "ANSI_CI" DEFAULT '' DESCRIPTION '[Field] Alias=Dati spedizione - Peso calcolato automaticamente Active=True ReportVisible=True FilterVisible=True', "SPED_PESO_MANUALE" VarChar(8) COLLATE "ANSI_CI" DEFAULT '' DESCRIPTION '[Field] Alias=Dati spedizione - Porto manuale Active=True ReportVisible=True FilterVisible=True', "SPED_PORTO" SMALLINT DEFAULT 0 DESCRIPTION '[Field] Alias=Dati spedizione - Porto Active=True ReportVisible=True FilterVisible=True', "SPED_CAUSTRASP" SMALLINT DEFAULT 0 DESCRIPTION '[Field] Alias=Dati spedizione - Causale spedizione Active=True ReportVisible=True FilterVisible=True', "SPED_CONFORD" VarChar(20) COLLATE "ANSI_CI" DEFAULT '' DESCRIPTION '[Field] Alias=Dati spedizione - Conferma d''ordine Active=True ReportVisible=True FilterVisible=True', "SPED_BOLLA_AUTOINTESTATA" BOOLEAN DEFAULT False DESCRIPTION '[Field] Alias=DDT autointestato Active=True ReportVisible=True FilterVisible=True', "SPED2_DESC" VarChar(40) COLLATE "ANSI_CI" DEFAULT '' DESCRIPTION '[Field] Alias=Destinazione merci ordini - Ragione sociale Active=True ReportVisible=True FilterVisible=True', "SPED2_INDI" VarChar(40) COLLATE "ANSI_CI" DEFAULT '' DESCRIPTION '[Field] Alias=Destinazione merci ordini - Indirizzo Active=True ReportVisible=True FilterVisible=True', "SPED2_CAP" VarChar(8) COLLATE "ANSI_CI" DEFAULT '' DESCRIPTION '[Field] Alias=Destinazione merci ordini - CAP Active=True ReportVisible=True FilterVisible=True', "SPED2_LOCALITA" VarChar(40) COLLATE "ANSI_CI" DEFAULT '' DESCRIPTION '[Field] Alias=Destinazione merci ordini - Località Active=True ReportVisible=True FilterVisible=True', "SPED2_PROVINCIA" VarChar(4) COLLATE "ANSI_CI" DEFAULT '' DESCRIPTION '[Field] Alias=Destinazione merci ordini - Provincia Active=True ReportVisible=True FilterVisible=True', "SPED2_TELEFONO" VarChar(25) COLLATE "ANSI_CI" DEFAULT '' DESCRIPTION '[Field] Alias=Destinazione merci ordini - Telefono Active=True ReportVisible=True FilterVisible=True', "NUMFATTURA" VarChar(20) COLLATE "ANSI_CI" DEFAULT '' DESCRIPTION '[Field] Alias=Rif. documento di carico - Numero Active=True ReportVisible=True FilterVisible=True', "DATAFATTURA" DATE DESCRIPTION '[Field] Alias=Rif. documento di carico - Data Active=True ReportVisible=True FilterVisible=True', "PROTCARICO" FLOAT DEFAULT 0 DESCRIPTION '[Field] Alias=Protocollo di carico Active=True ReportVisible=True FilterVisible=True', "DISPONIBILITA" VarChar(1) COLLATE "ANSI_CI" DEFAULT '' DESCRIPTION '[Field] Alias=Stato evadibilità Active=True ReportVisible=True FilterVisible=True', "SC_ESEGUTORE" SMALLINT DEFAULT 0 DESCRIPTION '[Field] Alias=Codice collaboratore che esegue intervento o commessa Active=True ReportVisible=True FilterVisible=True', "SC_OGGINTERVENTO" CLOB COLLATE "ANSI" DESCRIPTION '[Field] Alias=Oggetto intervento o commessa Active=True ReportVisible=True FilterVisible=True', "SC_CAUSALEINTERVENTO" CLOB COLLATE "ANSI" DESCRIPTION '[Field] Alias=Causale intervento o commessa Active=True ReportVisible=True FilterVisible=True', "SC_RAPPORTOINTERVENTO" CLOB COLLATE "ANSI" DESCRIPTION '[Field] Alias=Rapporto intervento o commessa Active=True ReportVisible=True FilterVisible=True', "SC_ORA" VarChar(5) COLLATE "ANSI_CI" DEFAULT '' DESCRIPTION '[Field] Alias=Ora inizio intervento o commessa Active=True ReportVisible=True FilterVisible=True', "SC_ORA_FINE" VarChar(5) COLLATE "ANSI_CI" DEFAULT '' DESCRIPTION '[Field] Alias=Ora fine intervento Active=True ReportVisible=True FilterVisible=True', "SC_INTERNO" BOOLEAN DEFAULT False DESCRIPTION '[Field] Alias=Intervento o commessa interna Active=True ReportVisible=True FilterVisible=True', "SC_ESTERNO" BOOLEAN DEFAULT False DESCRIPTION '[Field] Alias= Active=False ReportVisible=True FilterVisible=True', "SC_RIFORDCLI" FLOAT DEFAULT 0 DESCRIPTION '[Field] Alias= Active=False ReportVisible=True FilterVisible=True', "SC_RIFORDCLIANNO" SMALLINT DEFAULT 0 DESCRIPTION '[Field] Alias= Active=False ReportVisible=True FilterVisible=True', "SC_ANNOPREV" SMALLINT DEFAULT 0 DESCRIPTION '[Field] Alias= Active=False ReportVisible=True FilterVisible=True', "SC_NUMPREV" FLOAT DEFAULT 0 DESCRIPTION '[Field] Alias= Active=False ReportVisible=True FilterVisible=True', "SC_FATTURATO" BOOLEAN DEFAULT False DESCRIPTION '[Field] Alias=Intervento o commessa fatturata Active=True ReportVisible=True FilterVisible=True', "SC_TAB_CAUS_INTERVENTO" SMALLINT DEFAULT 0 DESCRIPTION '[Field] Alias=Codice causale intervento Active=True ReportVisible=True FilterVisible=True', "SC_RIF_PREV_COMMESSA_CODICE" FLOAT DEFAULT 0 DESCRIPTION '[Field] Alias=Codice VSI offerta Active=True ReportVisible=True FilterVisible=True', "SC_COMMESSA_CODICE" FLOAT DEFAULT 0 DESCRIPTION '[Field] Alias= Active=False ReportVisible=True FilterVisible=True', "SC_COD_VSI_SPEC_TEC" FLOAT DEFAULT 0 DESCRIPTION '[Field] Alias=Codice VSI specifica tecnica Active=True ReportVisible=True FilterVisible=True', "SC_LAVORI_DATA_INIZIO" DATE DESCRIPTION '[Field] Alias=Data inizio lavori Active=True ReportVisible=True FilterVisible=True', "SC_LAVORI_DATA_FINE" DATE DESCRIPTION '[Field] Alias=Data fine lavori Active=True ReportVisible=True FilterVisible=True', "SC_IMPORTO_PREVENTIVATO" FLOAT DEFAULT 0 DESCRIPTION '[Field] Alias=Importo preventivato Active=True ReportVisible=True FilterVisible=True', "STATOPAGAMENTO" VarChar(1) COLLATE "ANSI_CI" DEFAULT '' DESCRIPTION '[Field] Alias=Stato pagamento documento Active=True ReportVisible=True FilterVisible=True', "PAG_DATA1" DATE DESCRIPTION '[Field] Alias=Scadenze - Data scadenza 1 Active=True ReportVisible=True FilterVisible=True', "PAG_DATAREALE1" DATE DESCRIPTION '[Field] Alias=Scadenze - Data incasso 1 Active=True ReportVisible=True FilterVisible=True', "PAG_IMPORTO1" FLOAT DEFAULT 0 DESCRIPTION '[Field] Alias=Scadenze - Importo scadenza 1 Active=True ReportVisible=True FilterVisible=True', "PAG_BANCAAPP1" FLOAT DEFAULT 0 DESCRIPTION '[Field] Alias=Scadenze - Banca di appoggio 1 Active=True ReportVisible=True FilterVisible=True', "PAG_MODPAG_1" SMALLINT DEFAULT 0 DESCRIPTION '[Field] Alias=Scadenze - Codice modalità di pagamento 1 Active=True ReportVisible=True FilterVisible=True', "PAG_FLUSSO_FLAG_PRESENTATO_1" BOOLEAN DEFAULT False DESCRIPTION '[Field] Alias=Scadenze - Scadenza presentata 1 Active=True ReportVisible=True FilterVisible=True', "PAG_FLUSSO_DATA_ULT_PRESENTAZIONE_1" TIMESTAMP DESCRIPTION '[Field] Alias=Scadenze - Data ultima presentazione 1 Active=True ReportVisible=True FilterVisible=True', "PAG_PROGR_PNOTA1" FLOAT DEFAULT 0 DESCRIPTION '[Field] Alias=Scadenze - Protocolla prima nota 1 Active=True ReportVisible=True FilterVisible=True', "PAG_CESSIONE_CREDITO_1" BOOLEAN DEFAULT False DESCRIPTION '[Field] Alias=Scadenze - Cessione di credito 1 Active=True ReportVisible=True FilterVisible=True', "PAG_FLAG_INSOLUTO_1" BOOLEAN DEFAULT False DESCRIPTION '[Field] Alias=Scadenze - Insoluto 1 Active=True ReportVisible=True FilterVisible=True', "PAG_NOTA1" VarChar(50) COLLATE "ANSI_CI" DEFAULT '' DESCRIPTION '[Field] Alias=Scadenze - Nota 1 Active=True ReportVisible=True FilterVisible=True', "PAG_DATA2" DATE DESCRIPTION '[Field] Alias=Scadenze - Data scadenza 2 Active=True ReportVisible=True FilterVisible=True', "PAG_DATAREALE2" DATE DESCRIPTION '[Field] Alias=Scadenze - Data incasso 2 Active=True ReportVisible=True FilterVisible=True', "PAG_IMPORTO2" FLOAT DEFAULT 0 DESCRIPTION '[Field] Alias=Scadenze - Importo scadenza 2 Active=True ReportVisible=True FilterVisible=True', "PAG_BANCAAPP2" FLOAT DEFAULT 0 DESCRIPTION '[Field] Alias=Scadenze - Banca di appoggio 2 Active=True ReportVisible=True FilterVisible=True', "PAG_MODPAG_2" SMALLINT DEFAULT 0 DESCRIPTION '[Field] Alias=Scadenze - Codice modalità di pagamento 2 Active=True ReportVisible=True FilterVisible=True', "PAG_FLUSSO_FLAG_PRESENTATO_2" BOOLEAN DEFAULT False DESCRIPTION '[Field] Alias=Scadenze - Scadenza presentata 2 Active=True ReportVisible=True FilterVisible=True', "PAG_FLUSSO_DATA_ULT_PRESENTAZIONE_2" TIMESTAMP DESCRIPTION '[Field] Alias=Scadenze - Data ultima presentazione 2 Active=True ReportVisible=True FilterVisible=True', "PAG_PROGR_PNOTA2" FLOAT DEFAULT 0 DESCRIPTION '[Field] Alias=Scadenze - Protocolla prima nota 2 Active=True ReportVisible=True FilterVisible=True', "PAG_CESSIONE_CREDITO_2" BOOLEAN DEFAULT False DESCRIPTION '[Field] Alias=Scadenze - Cessione di credito 2 Active=True ReportVisible=True FilterVisible=True', "PAG_FLAG_INSOLUTO_2" BOOLEAN DEFAULT False DESCRIPTION '[Field] Alias=Scadenze - Insoluto 2 Active=True ReportVisible=True FilterVisible=True', "PAG_NOTA2" VarChar(50) COLLATE "ANSI_CI" DEFAULT '' DESCRIPTION '[Field] Alias=Scadenze - Nota 2 Active=True ReportVisible=True FilterVisible=True', "PAG_DATA3" DATE DESCRIPTION '[Field] Alias=Scadenze - Data scadenza 3 Active=True ReportVisible=True FilterVisible=True', "PAG_DATAREALE3" DATE DESCRIPTION '[Field] Alias=Scadenze - Data incasso 3 Active=True ReportVisible=True FilterVisible=True', "PAG_IMPORTO3" FLOAT DEFAULT 0 DESCRIPTION '[Field] Alias=Scadenze - Importo scadenza 3 Active=True ReportVisible=True FilterVisible=True', "PAG_BANCAAPP3" FLOAT DEFAULT 0 DESCRIPTION '[Field] Alias=Scadenze - Banca di appoggio 3 Active=True ReportVisible=True FilterVisible=True', "PAG_MODPAG_3" SMALLINT DEFAULT 0 DESCRIPTION '[Field] Alias=Scadenze - Codice modalità di pagamento 3 Active=True ReportVisible=True FilterVisible=True', "PAG_FLUSSO_FLAG_PRESENTATO_3" BOOLEAN DEFAULT False DESCRIPTION '[Field] Alias=Scadenze - Scadenza presentata 3 Active=True ReportVisible=True FilterVisible=True', "PAG_FLUSSO_DATA_ULT_PRESENTAZIONE_3" TIMESTAMP DESCRIPTION '[Field] Alias=Scadenze - Data ultima presentazione 3 Active=True ReportVisible=True FilterVisible=True', "PAG_PROGR_PNOTA3" FLOAT DEFAULT 0 DESCRIPTION '[Field] Alias=Scadenze - Protocolla prima nota 3 Active=True ReportVisible=True FilterVisible=True', "PAG_CESSIONE_CREDITO_3" BOOLEAN DEFAULT False DESCRIPTION '[Field] Alias=Scadenze - Cessione di credito 3 Active=True ReportVisible=True FilterVisible=True', "PAG_FLAG_INSOLUTO_3" BOOLEAN DEFAULT False DESCRIPTION '[Field] Alias=Scadenze - Insoluto 3 Active=True ReportVisible=True FilterVisible=True', "PAG_NOTA3" VarChar(50) COLLATE "ANSI_CI" DEFAULT '' DESCRIPTION '[Field] Alias=Scadenze - Nota 3 Active=True ReportVisible=True FilterVisible=True', "PAG_DATA4" DATE DESCRIPTION '[Field] Alias=Scadenze - Data scadenza 4 Active=True ReportVisible=True FilterVisible=True', "PAG_DATAREALE4" DATE DESCRIPTION '[Field] Alias=Scadenze - Data incasso 4 Active=True ReportVisible=True FilterVisible=True', "PAG_IMPORTO4" FLOAT DEFAULT 0 DESCRIPTION '[Field] Alias=Scadenze - Importo scadenza 4 Active=True ReportVisible=True FilterVisible=True', "PAG_BANCAAPP4" FLOAT DEFAULT 0 DESCRIPTION '[Field] Alias=Scadenze - Banca di appoggio 4 Active=True ReportVisible=True FilterVisible=True', "PAG_MODPAG_4" SMALLINT DEFAULT 0 DESCRIPTION '[Field] Alias=Scadenze - Codice modalità di pagamento 4 Active=True ReportVisible=True FilterVisible=True', "PAG_FLUSSO_FLAG_PRESENTATO_4" BOOLEAN DEFAULT False DESCRIPTION '[Field] Alias=Scadenze - Scadenza presentata 4 Active=True ReportVisible=True FilterVisible=True', "PAG_FLUSSO_DATA_ULT_PRESENTAZIONE_4" TIMESTAMP DESCRIPTION '[Field] Alias=Scadenze - Data ultima presentazione 4 Active=True ReportVisible=True FilterVisible=True', "PAG_PROGR_PNOTA4" FLOAT DEFAULT 0 DESCRIPTION '[Field] Alias=Scadenze - Protocolla prima nota 4 Active=True ReportVisible=True FilterVisible=True', "PAG_CESSIONE_CREDITO_4" BOOLEAN DEFAULT False DESCRIPTION '[Field] Alias=Scadenze - Cessione di credito 4 Active=True ReportVisible=True FilterVisible=True', "PAG_FLAG_INSOLUTO_4" BOOLEAN DEFAULT False DESCRIPTION '[Field] Alias=Scadenze - Insoluto 4 Active=True ReportVisible=True FilterVisible=True', "PAG_NOTA4" VarChar(50) COLLATE "ANSI_CI" DEFAULT '' DESCRIPTION '[Field] Alias=Scadenze - Nota 4 Active=True ReportVisible=True FilterVisible=True', "PAG_DATA5" DATE DESCRIPTION '[Field] Alias=Scadenze - Data scadenza 5 Active=True ReportVisible=True FilterVisible=True', "PAG_DATAREALE5" DATE DESCRIPTION '[Field] Alias=Scadenze - Data incasso 5 Active=True ReportVisible=True FilterVisible=True', "PAG_IMPORTO5" FLOAT DEFAULT 0 DESCRIPTION '[Field] Alias=Scadenze - Importo scadenza 5 Active=True ReportVisible=True FilterVisible=True', "PAG_BANCAAPP5" FLOAT DEFAULT 0 DESCRIPTION '[Field] Alias=Scadenze - Banca di appoggio 5 Active=True ReportVisible=True FilterVisible=True', "PAG_MODPAG_5" SMALLINT DEFAULT 0 DESCRIPTION '[Field] Alias=Scadenze - Codice modalità di pagamento 5 Active=True ReportVisible=True FilterVisible=True', "PAG_FLUSSO_FLAG_PRESENTATO_5" BOOLEAN DEFAULT False DESCRIPTION '[Field] Alias=Scadenze - Scadenza presentata 5 Active=True ReportVisible=True FilterVisible=True', "PAG_FLUSSO_DATA_ULT_PRESENTAZIONE_5" TIMESTAMP DESCRIPTION '[Field] Alias=Scadenze - Data ultima presentazione 5 Active=True ReportVisible=True FilterVisible=True', "PAG_PROGR_PNOTA5" FLOAT DEFAULT 0 DESCRIPTION '[Field] Alias=Scadenze - Protocolla prima nota 5 Active=True ReportVisible=True FilterVisible=True', "PAG_CESSIONE_CREDITO_5" BOOLEAN DEFAULT False DESCRIPTION '[Field] Alias=Scadenze - Cessione di credito 5 Active=True ReportVisible=True FilterVisible=True', "PAG_FLAG_INSOLUTO_5" BOOLEAN DEFAULT False DESCRIPTION '[Field] Alias=Scadenze - Insoluto 5 Active=True ReportVisible=True FilterVisible=True', "PAG_NOTA5" VarChar(50) COLLATE "ANSI_CI" DEFAULT '' DESCRIPTION '[Field] Alias=Scadenze - Nota 5 Active=True ReportVisible=True FilterVisible=True', "PAG_DATA6" DATE DESCRIPTION '[Field] Alias=Scadenze - Data scadenza 6 Active=True ReportVisible=True FilterVisible=True', "PAG_DATAREALE6" DATE DESCRIPTION '[Field] Alias=Scadenze - Data incasso 6 Active=True ReportVisible=True FilterVisible=True', "PAG_IMPORTO6" FLOAT DEFAULT 0 DESCRIPTION '[Field] Alias=Scadenze - Importo scadenza 6 Active=True ReportVisible=True FilterVisible=True', "PAG_BANCAAPP6" FLOAT DEFAULT 0 DESCRIPTION '[Field] Alias=Scadenze - Banca di appoggio 6 Active=True ReportVisible=True FilterVisible=True', "PAG_MODPAG_6" SMALLINT DEFAULT 0 DESCRIPTION '[Field] Alias=Scadenze - Codice modalità di pagamento 6 Active=True ReportVisible=True FilterVisible=True', "PAG_FLUSSO_FLAG_PRESENTATO_6" BOOLEAN DEFAULT False DESCRIPTION '[Field] Alias=Scadenze - Scadenza presentata 6 Active=True ReportVisible=True FilterVisible=True', "PAG_FLUSSO_DATA_ULT_PRESENTAZIONE_6" TIMESTAMP DESCRIPTION '[Field] Alias=Scadenze - Data ultima presentazione 6 Active=True ReportVisible=True FilterVisible=True', "PAG_PROGR_PNOTA6" FLOAT DEFAULT 0 DESCRIPTION '[Field] Alias=Scadenze - Protocolla prima nota 6 Active=True ReportVisible=True FilterVisible=True', "PAG_CESSIONE_CREDITO_6" BOOLEAN DEFAULT False DESCRIPTION '[Field] Alias=Scadenze - Cessione di credito 6 Active=True ReportVisible=True FilterVisible=True', "PAG_FLAG_INSOLUTO_6" BOOLEAN DEFAULT False DESCRIPTION '[Field] Alias=Scadenze - Insoluto 6 Active=True ReportVisible=True FilterVisible=True', "PAG_NOTA6" VarChar(50) COLLATE "ANSI_CI" DEFAULT '' DESCRIPTION '[Field] Alias=Scadenze - Nota 6 Active=True ReportVisible=True FilterVisible=True', "PAG_DATA7" DATE DESCRIPTION '[Field] Alias=Scadenze - Data scadenza 7 Active=True ReportVisible=True FilterVisible=True', "PAG_DATAREALE7" DATE DESCRIPTION '[Field] Alias=Scadenze - Data incasso 7 Active=True ReportVisible=True FilterVisible=True', "PAG_IMPORTO7" FLOAT DEFAULT 0 DESCRIPTION '[Field] Alias=Scadenze - Importo scadenza 7 Active=True ReportVisible=True FilterVisible=True', "PAG_BANCAAPP7" FLOAT DEFAULT 0 DESCRIPTION '[Field] Alias=Scadenze - Banca di appoggio 7 Active=True ReportVisible=True FilterVisible=True', "PAG_MODPAG_7" SMALLINT DEFAULT 0 DESCRIPTION '[Field] Alias=Scadenze - Codice modalità di pagamento 7 Active=True ReportVisible=True FilterVisible=True', "PAG_FLUSSO_FLAG_PRESENTATO_7" BOOLEAN DEFAULT False DESCRIPTION '[Field] Alias=Scadenze - Scadenza presentata 7 Active=True ReportVisible=True FilterVisible=True', "PAG_FLUSSO_DATA_ULT_PRESENTAZIONE_7" TIMESTAMP DESCRIPTION '[Field] Alias=Scadenze - Data ultima presentazione 7 Active=True ReportVisible=True FilterVisible=True', "PAG_PROGR_PNOTA7" FLOAT DEFAULT 0 DESCRIPTION '[Field] Alias=Scadenze - Protocolla prima nota 7 Active=True ReportVisible=True FilterVisible=True', "PAG_CESSIONE_CREDITO_7" BOOLEAN DEFAULT False DESCRIPTION '[Field] Alias=Scadenze - Cessione di credito 7 Active=True ReportVisible=True FilterVisible=True', "PAG_FLAG_INSOLUTO_7" BOOLEAN DEFAULT False DESCRIPTION '[Field] Alias=Scadenze - Insoluto 7 Active=True ReportVisible=True FilterVisible=True', "PAG_NOTA7" VarChar(50) COLLATE "ANSI_CI" DEFAULT '' DESCRIPTION '[Field] Alias=Scadenze - Nota 7 Active=True ReportVisible=True FilterVisible=True', "PAG_DATA8" DATE DESCRIPTION '[Field] Alias=Scadenze - Data scadenza 8 Active=True ReportVisible=True FilterVisible=True', "PAG_DATAREALE8" DATE DESCRIPTION '[Field] Alias=Scadenze - Data incasso 7 Active=True ReportVisible=True FilterVisible=True', "PAG_IMPORTO8" FLOAT DEFAULT 0 DESCRIPTION '[Field] Alias=Scadenze - Importo scadenza 8 Active=True ReportVisible=True FilterVisible=True', "PAG_BANCAAPP8" FLOAT DEFAULT 0 DESCRIPTION '[Field] Alias=Scadenze - Banca di appoggio 8 Active=True ReportVisible=True FilterVisible=True', "PAG_MODPAG_8" SMALLINT DEFAULT 0 DESCRIPTION '[Field] Alias=Scadenze - Codice modalità di pagamento 8 Active=True ReportVisible=True FilterVisible=True', "PAG_FLUSSO_FLAG_PRESENTATO_8" BOOLEAN DEFAULT False DESCRIPTION '[Field] Alias=Scadenze - Scadenza presentata 8 Active=True ReportVisible=True FilterVisible=True', "PAG_FLUSSO_DATA_ULT_PRESENTAZIONE_8" TIMESTAMP DESCRIPTION '[Field] Alias=Scadenze - Data ultima presentazione 8 Active=True ReportVisible=True FilterVisible=True', "PAG_PROGR_PNOTA8" FLOAT DEFAULT 0 DESCRIPTION '[Field] Alias=Scadenze - Protocolla prima nota 8 Active=True ReportVisible=True FilterVisible=True', "PAG_CESSIONE_CREDITO_8" BOOLEAN DEFAULT False DESCRIPTION '[Field] Alias=Scadenze - Cessione di credito 8 Active=True ReportVisible=True FilterVisible=True', "PAG_FLAG_INSOLUTO_8" BOOLEAN DEFAULT False DESCRIPTION '[Field] Alias=Scadenze - Insoluto 8 Active=True ReportVisible=True FilterVisible=True', "PAG_NOTA8" VarChar(50) COLLATE "ANSI_CI" DEFAULT '' DESCRIPTION '[Field] Alias=Scadenze - Nota 8 Active=True ReportVisible=True FilterVisible=True', "PAG_DATA9" DATE DESCRIPTION '[Field] Alias=Scadenze - Data scadenza 9 Active=True ReportVisible=True FilterVisible=True', "PAG_DATAREALE9" DATE DESCRIPTION '[Field] Alias=Scadenze - Data incasso 9 Active=True ReportVisible=True FilterVisible=True', "PAG_IMPORTO9" FLOAT DEFAULT 0 DESCRIPTION '[Field] Alias=Scadenze - Importo scadenza 9 Active=True ReportVisible=True FilterVisible=True', "PAG_BANCAAPP9" FLOAT DEFAULT 0 DESCRIPTION '[Field] Alias=Scadenze - Banca di appoggio 9 Active=True ReportVisible=True FilterVisible=True', "PAG_MODPAG_9" SMALLINT DEFAULT 0 DESCRIPTION '[Field] Alias=Scadenze - Codice modalità di pagamento 9 Active=True ReportVisible=True FilterVisible=True', "PAG_FLUSSO_FLAG_PRESENTATO_9" BOOLEAN DEFAULT False DESCRIPTION '[Field] Alias=Scadenze - Scadenza presentata 9 Active=True ReportVisible=True FilterVisible=True', "PAG_FLUSSO_DATA_ULT_PRESENTAZIONE_9" TIMESTAMP DESCRIPTION '[Field] Alias=Scadenze - Data ultima presentazione 9 Active=True ReportVisible=True FilterVisible=True', "PAG_PROGR_PNOTA9" FLOAT DEFAULT 0 DESCRIPTION '[Field] Alias=Scadenze - Protocolla prima nota 9 Active=True ReportVisible=True FilterVisible=True', "PAG_CESSIONE_CREDITO_9" BOOLEAN DEFAULT False DESCRIPTION '[Field] Alias=Scadenze - Cessione di credito 9 Active=True ReportVisible=True FilterVisible=True', "PAG_FLAG_INSOLUTO_9" BOOLEAN DEFAULT False DESCRIPTION '[Field] Alias=Scadenze - Insoluto 9 Active=True ReportVisible=True FilterVisible=True', "PAG_NOTA9" VarChar(50) COLLATE "ANSI_CI" DEFAULT '' DESCRIPTION '[Field] Alias=Scadenze - Nota 9 Active=True ReportVisible=True FilterVisible=True', "PAG_DATA10" DATE DESCRIPTION '[Field] Alias=Scadenze - Data scadenza 10 Active=True ReportVisible=True FilterVisible=True', "PAG_DATAREALE10" DATE DESCRIPTION '[Field] Alias=Scadenze - Data incasso 10 Active=True ReportVisible=True FilterVisible=True', "PAG_IMPORTO10" FLOAT DEFAULT 0 DESCRIPTION '[Field] Alias=Scadenze - Importo scadenza 10 Active=True ReportVisible=True FilterVisible=True', "PAG_BANCAAPP10" FLOAT DEFAULT 0 DESCRIPTION '[Field] Alias=Scadenze - Banca di appoggio 10 Active=True ReportVisible=True FilterVisible=True', "PAG_MODPAG_10" SMALLINT DEFAULT 0 DESCRIPTION '[Field] Alias=Scadenze - Codice modalità di pagamento 10 Active=True ReportVisible=True FilterVisible=True', "PAG_FLUSSO_FLAG_PRESENTATO_10" BOOLEAN DEFAULT False DESCRIPTION '[Field] Alias=Scadenze - Scadenza presentata 10 Active=True ReportVisible=True FilterVisible=True', "PAG_FLUSSO_DATA_ULT_PRESENTAZIONE_10" TIMESTAMP DESCRIPTION '[Field] Alias=Scadenze - Data ultima presentazione 10 Active=True ReportVisible=True FilterVisible=True', "PAG_PROGR_PNOTA10" FLOAT DEFAULT 0 DESCRIPTION '[Field] Alias=Scadenze - Protocolla prima nota 10 Active=True ReportVisible=True FilterVisible=True', "PAG_CESSIONE_CREDITO_10" BOOLEAN DEFAULT False DESCRIPTION '[Field] Alias=Scadenze - Cessione di credito 10 Active=True ReportVisible=True FilterVisible=True', "PAG_FLAG_INSOLUTO_10" BOOLEAN DEFAULT False DESCRIPTION '[Field] Alias=Scadenze - Insoluto 10 Active=True ReportVisible=True FilterVisible=True', "PAG_NOTA10" VarChar(50) COLLATE "ANSI_CI" DEFAULT '' DESCRIPTION '[Field] Alias=Scadenze - Nota 10 Active=True ReportVisible=True FilterVisible=True', "PAG_DATA11" DATE DESCRIPTION '[Field] Alias=Scadenze - Data scadenza 11 Active=True ReportVisible=True FilterVisible=True', "PAG_DATAREALE11" DATE DESCRIPTION '[Field] Alias=Scadenze - Data incasso 11 Active=True ReportVisible=True FilterVisible=True', "PAG_IMPORTO11" FLOAT DEFAULT 0 DESCRIPTION '[Field] Alias=Scadenze - Importo scadenza 11 Active=True ReportVisible=True FilterVisible=True', "PAG_BANCAAPP11" FLOAT DEFAULT 0 DESCRIPTION '[Field] Alias=Scadenze - Banca di appoggio 11 Active=True ReportVisible=True FilterVisible=True', "PAG_MODPAG_11" SMALLINT DEFAULT 0 DESCRIPTION '[Field] Alias=Scadenze - Codice modalità di pagamento 11 Active=True ReportVisible=True FilterVisible=True', "PAG_FLUSSO_FLAG_PRESENTATO_11" BOOLEAN DEFAULT False DESCRIPTION '[Field] Alias=Scadenze - Scadenza presentata 11 Active=True ReportVisible=True FilterVisible=True', "PAG_FLUSSO_DATA_ULT_PRESENTAZIONE_11" TIMESTAMP DESCRIPTION '[Field] Alias=Scadenze - Data ultima presentazione 11 Active=True ReportVisible=True FilterVisible=True', "PAG_PROGR_PNOTA11" FLOAT DEFAULT 0 DESCRIPTION '[Field] Alias=Scadenze - Protocolla prima nota 11 Active=True ReportVisible=True FilterVisible=True', "PAG_CESSIONE_CREDITO_11" BOOLEAN DEFAULT False DESCRIPTION '[Field] Alias=Scadenze - Cessione di credito 11 Active=True ReportVisible=True FilterVisible=True', "PAG_FLAG_INSOLUTO_11" BOOLEAN DEFAULT False DESCRIPTION '[Field] Alias=Scadenze - Insoluto 11 Active=True ReportVisible=True FilterVisible=True', "PAG_NOTA11" VarChar(50) COLLATE "ANSI_CI" DEFAULT '' DESCRIPTION '[Field] Alias=Scadenze - Nota 11 Active=True ReportVisible=True FilterVisible=True', "PAG_DATA12" DATE DESCRIPTION '[Field] Alias=Scadenze - Data scadenza 12 Active=True ReportVisible=True FilterVisible=True', "PAG_DATAREALE12" DATE DESCRIPTION '[Field] Alias=Scadenze - Data incasso 12 Active=True ReportVisible=True FilterVisible=True', "PAG_IMPORTO12" FLOAT DEFAULT 0 DESCRIPTION '[Field] Alias=Scadenze - Importo scadenza 12 Active=True ReportVisible=True FilterVisible=True', "PAG_BANCAAPP12" FLOAT DEFAULT 0 DESCRIPTION '[Field] Alias=Scadenze - Banca di appoggio 12 Active=True ReportVisible=True FilterVisible=True', "PAG_MODPAG_12" SMALLINT DEFAULT 0 DESCRIPTION '[Field] Alias=Scadenze - Codice modalità di pagamento 12 Active=True ReportVisible=True FilterVisible=True', "PAG_FLUSSO_FLAG_PRESENTATO_12" BOOLEAN DEFAULT False DESCRIPTION '[Field] Alias=Scadenze - Scadenza presentata 12 Active=True ReportVisible=True FilterVisible=True', "PAG_FLUSSO_DATA_ULT_PRESENTAZIONE_12" TIMESTAMP DESCRIPTION '[Field] Alias=Scadenze - Data ultima presentazione 12 Active=True ReportVisible=True FilterVisible=True', "PAG_PROGR_PNOTA12" FLOAT DEFAULT 0 DESCRIPTION '[Field] Alias=Scadenze - Protocolla prima nota 12 Active=True ReportVisible=True FilterVisible=True', "PAG_CESSIONE_CREDITO_12" BOOLEAN DEFAULT False DESCRIPTION '[Field] Alias=Scadenze - Cessione di credito 12 Active=True ReportVisible=True FilterVisible=True', "PAG_FLAG_INSOLUTO_12" BOOLEAN DEFAULT False DESCRIPTION '[Field] Alias=Scadenze - Insoluto 12 Active=True ReportVisible=True FilterVisible=True', "PAG_NOTA12" VarChar(50) COLLATE "ANSI_CI" DEFAULT '' DESCRIPTION '[Field] Alias=Scadenze - Nota 12 Active=True ReportVisible=True FilterVisible=True', "PAG_DATA13" DATE DESCRIPTION '[Field] Alias=Scadenze - Data scadenza 13 Active=True ReportVisible=True FilterVisible=True', "PAG_DATAREALE13" DATE DESCRIPTION '[Field] Alias=Scadenze - Data incasso 13 Active=True ReportVisible=True FilterVisible=True', "PAG_IMPORTO13" FLOAT DEFAULT 0 DESCRIPTION '[Field] Alias=Scadenze - Importo scadenza 13 Active=True ReportVisible=True FilterVisible=True', "PAG_BANCAAPP13" FLOAT DEFAULT 0 DESCRIPTION '[Field] Alias=Scadenze - Banca di appoggio 13 Active=True ReportVisible=True FilterVisible=True', "PAG_MODPAG_13" SMALLINT DEFAULT 0 DESCRIPTION '[Field] Alias=Scadenze - Codice modalità di pagamento 13 Active=True ReportVisible=True FilterVisible=True', "PAG_FLUSSO_FLAG_PRESENTATO_13" BOOLEAN DEFAULT False DESCRIPTION '[Field] Alias=Scadenze - Scadenza presentata 13 Active=True ReportVisible=True FilterVisible=True', "PAG_FLUSSO_DATA_ULT_PRESENTAZIONE_13" TIMESTAMP DESCRIPTION '[Field] Alias=Scadenze - Data ultima presentazione 13 Active=True ReportVisible=True FilterVisible=True', "PAG_PROGR_PNOTA13" FLOAT DEFAULT 0 DESCRIPTION '[Field] Alias=Scadenze - Protocolla prima nota 13 Active=True ReportVisible=True FilterVisible=True', "PAG_CESSIONE_CREDITO_13" BOOLEAN DEFAULT False DESCRIPTION '[Field] Alias=Scadenze - Cessione di credito 13 Active=True ReportVisible=True FilterVisible=True', "PAG_FLAG_INSOLUTO_13" BOOLEAN DEFAULT False DESCRIPTION '[Field] Alias=Scadenze - Insoluto 13 Active=True ReportVisible=True FilterVisible=True', "PAG_NOTA13" VarChar(50) COLLATE "ANSI_CI" DEFAULT '' DESCRIPTION '[Field] Alias=Scadenze - Nota 13 Active=True ReportVisible=True FilterVisible=True', "PAG_FLAG_BAN_IMPORTOANTICIPO" BOOLEAN DEFAULT False DESCRIPTION '[Field] Alias= Active=False ReportVisible=True FilterVisible=True', "PAG_BAN_IMPORTOANTICIPO" FLOAT DEFAULT 0 DESCRIPTION '[Field] Alias= Active=False ReportVisible=True FilterVisible=True', "PAG_BAN_DATAANTICIPO" DATE DESCRIPTION '[Field] Alias= Active=False ReportVisible=True FilterVisible=True', "PAG_BAN_BANCAAPPOGGIO" FLOAT DEFAULT 0 DESCRIPTION '[Field] Alias= Active=False ReportVisible=True FilterVisible=True', "PAG_BAN_PROGR_PNOTA" FLOAT DEFAULT 0 DESCRIPTION '[Field] Alias= Active=False ReportVisible=True FilterVisible=True', "PAG_BAN_NOTA" VarChar(50) COLLATE "ANSI_CI" DEFAULT '' DESCRIPTION '[Field] Alias= Active=False ReportVisible=True FilterVisible=True', "PAG_ABBUONO" FLOAT DEFAULT 0 DESCRIPTION '[Field] Alias=Scadenze - Abbuono Active=True ReportVisible=True FilterVisible=True', "PAG_FLAG_MANUALE" BOOLEAN DEFAULT False DESCRIPTION '[Field] Alias=Scadenze - Scadenze manuali Active=True ReportVisible=True FilterVisible=True', "TIPODOCRIF" VarChar(6) COLLATE "ANSI_CI" DEFAULT '' DESCRIPTION '[Field] Alias= Active=False ReportVisible=True FilterVisible=True', "NEGOZIODOCRIF" FLOAT DEFAULT 0 DESCRIPTION '[Field] Alias=Chiusura Commessa - Punto vendita fattura di riferimento Active=True ReportVisible=True FilterVisible=True', "ANNODOCRIF" SMALLINT DEFAULT 0 DESCRIPTION '[Field] Alias=Chiusura Commessa - Anno fattura di riferimento Active=True ReportVisible=True FilterVisible=True', "NUMDOCRIF" FLOAT DEFAULT 0 DESCRIPTION '[Field] Alias=Chiusura Commessa - Numero fattura di riferimento Active=True ReportVisible=True FilterVisible=True', "BISDOCRIF" VarChar(1) COLLATE "ANSI_CI" DEFAULT '' DESCRIPTION '[Field] Alias=Chiusura Commessa - Bis fattura di riferimento Active=True ReportVisible=True FilterVisible=True', "FLAG_HIDDEN" BOOLEAN DEFAULT False DESCRIPTION '[Field] Alias= Active=False ReportVisible=True FilterVisible=True', "FLAG_ST_CAMPO1" VarChar(1) COLLATE "ANSI_CI" DEFAULT '' DESCRIPTION '[Field] Alias=RISERVATO Active=True ReportVisible=False FilterVisible=False', "FLAG_ST_CAMPO2" VarChar(1) COLLATE "ANSI_CI" DEFAULT '' DESCRIPTION '[Field] Alias=RISERVATO Active=True ReportVisible=False FilterVisible=False', "FLAG_ST_PREZZI" BOOLEAN DEFAULT True DESCRIPTION '[Field] Alias=Impostazioni di stampa - Prezzi di dettaglio e sconti Active=True ReportVisible=True FilterVisible=True', "FLAG_ST_QTA" BOOLEAN DEFAULT True DESCRIPTION '[Field] Alias=Impostazioni di stampa - Stampa quantità Active=True ReportVisible=True FilterVisible=True', "FLAG_ST_NOTA" BOOLEAN DEFAULT False DESCRIPTION '[Field] Alias=Impostazioni di stampa - Stampoa nota alternativa Active=True ReportVisible=True FilterVisible=True', "FLAG_ST_IMPORTOBOLLE" BOOLEAN DEFAULT False DESCRIPTION '[Field] Alias=Impostazioni di stampa - Stampa Importo nei DDT Active=True ReportVisible=True FilterVisible=True', "FLAG_ST_IMPORTOBOLLE_PREZZI_SINGOLI" BOOLEAN DEFAULT False DESCRIPTION '[Field] Alias=Impostazioni di stampa - Stampa prezzi singoli Active=True ReportVisible=True FilterVisible=True', "FLAG_ST_IMPORTOBOLLE_PREZZI_SINGOLI_IVAT" BOOLEAN DEFAULT False DESCRIPTION '[Field] Alias=Impostazioni di stampa - Stampa prezzi singoli ivati Active=True ReportVisible=True FilterVisible=True', "FLAG_ST_IMPORTOBOLLE_IMPORTI" BOOLEAN DEFAULT False DESCRIPTION '[Field] Alias=Impostazioni di stampa - Stampa Importi Active=True ReportVisible=True FilterVisible=True', "FLAG_ST_IMPORTOBOLLE_IMPORTI_IVATI" BOOLEAN DEFAULT False DESCRIPTION '[Field] Alias=Impostazioni di stampa - Stampa Importi ivati Active=True ReportVisible=True FilterVisible=True', "FLAG_VENDUTO" BOOLEAN DEFAULT False DESCRIPTION '[Field] Alias= Active=False ReportVisible=True FilterVisible=True', "FLAG_NOTA_ADDEBITO" BOOLEAN DEFAULT False DESCRIPTION '[Field] Alias=Nota di addebito Active=True ReportVisible=True FilterVisible=True', "FLAG_NOTA_COMMERCIALE" BOOLEAN DEFAULT False DESCRIPTION '[Field] Alias=Segnalazione documento Active=True ReportVisible=True FilterVisible=True', "STAMPA_NOTA" CLOB COLLATE "ANSI" DESCRIPTION '[Field] Alias=RISERVATO Active=True ReportVisible=False FilterVisible=False', "FLAG_CONAI" BOOLEAN DEFAULT False DESCRIPTION '[Field] Alias=Conai Active=True ReportVisible=True FilterVisible=True', "RIGA_CONAI" VarChar(50) COLLATE "ANSI_CI" DEFAULT '' DESCRIPTION '[Field] Alias=Descrizione Conai Active=True ReportVisible=True FilterVisible=True', "FLAG_ST_MOSTRA_OPERATORE" BOOLEAN DEFAULT True DESCRIPTION '[Field] Alias=Impostazioni di stampa - Stampa operatore Active=True ReportVisible=True FilterVisible=True', "FLAG_ST_MOSTRA_PAGAMENTO" BOOLEAN DEFAULT True DESCRIPTION '[Field] Alias=Impostazioni di stampa - Stampa pagamento Active=True ReportVisible=True FilterVisible=True', "FLAG_ST_MOSTRA_FIRMA" BOOLEAN DEFAULT True DESCRIPTION '[Field] Alias=Impostazioni di stampa - Stampa firma Active=True ReportVisible=True FilterVisible=True', "RIGA_FIRMA" VarChar(25) COLLATE "ANSI_CI" DEFAULT '' DESCRIPTION '[Field] Alias=Label firma alternativa Active=True ReportVisible=True FilterVisible=True', "FLAG_ST_MOSTRA_IMPORTI" BOOLEAN DEFAULT True DESCRIPTION '[Field] Alias=Impostazioni di stampa - Mostra importi Active=True ReportVisible=True FilterVisible=True', "FLAG_ST_LINEEORIZ" BOOLEAN DEFAULT False DESCRIPTION '[Field] Alias=Impostazioni di stampa - Stampa linee orizzontali Active=True ReportVisible=True FilterVisible=True', "FLAG_ST_SCADENZE_RATE" BOOLEAN DEFAULT True DESCRIPTION '[Field] Alias=Impostazioni di stampa - Stampa scadenze rate Active=True ReportVisible=True FilterVisible=True', "FLAG_ST_IMPORTONETTO" BOOLEAN DEFAULT True DESCRIPTION '[Field] Alias=Impostazioni di stampa - Stampa importo netto Active=True ReportVisible=True FilterVisible=True', "FLAG_ST_PREZZO_IVATO" BOOLEAN DEFAULT False DESCRIPTION '[Field] Alias=Impostazioni di stampa - Stampa prezzi ivati Active=True ReportVisible=True FilterVisible=True', "FLAG_ST_STAMPATO" BOOLEAN DEFAULT False DESCRIPTION '[Field] Alias=Documento stampato Active=True ReportVisible=True FilterVisible=True', "FLAG_ST_IMPORTO_MANODOPERA" BOOLEAN DEFAULT False DESCRIPTION '[Field] Alias=Impostazioni di stampa - Stampa importo netto manodopera Active=True ReportVisible=True FilterVisible=True', "FLAG_ST_ETICHETTA_ALTERNATIVA" BOOLEAN DEFAULT False DESCRIPTION '[Field] Alias=Impostazioni di stampa - Etichetta alternativa Active=True ReportVisible=True FilterVisible=True', "FLAG_CARICO_PRODUZIONE" BOOLEAN DEFAULT False DESCRIPTION '[Field] Alias=Carico da produzione Active=True ReportVisible=True FilterVisible=True', "FLAG_PARCELLA" BOOLEAN DEFAULT False DESCRIPTION '[Field] Alias= Active=False ReportVisible=True FilterVisible=True', "FLAG_CONFERMATO" BOOLEAN DEFAULT False DESCRIPTION '[Field] Alias=Documento confermato Active=True ReportVisible=True FilterVisible=True', "FLAG_OBSOLETO" BOOLEAN DEFAULT False DESCRIPTION '[Field] Alias=Documento obsoleto Active=True ReportVisible=True FilterVisible=True', "FLAG_ACCONTI_CORRISPETTIVI" BOOLEAN DEFAULT False DESCRIPTION '[Field] Alias=Vendita al banco di acconto Active=True ReportVisible=True FilterVisible=True', "FLAG_ST_RICEVUTE_FISCALI_PAGAMENTO" BOOLEAN DEFAULT False DESCRIPTION '[Field] Alias=Impostazioni di stampa - Stampa pagam.nelle ricevute fiscali Active=True ReportVisible=True FilterVisible=True', "FLAG_ST_NON_STAMPARE_TOTALI_DOCUMENTO" BOOLEAN DEFAULT False DESCRIPTION '[Field] Alias=Impostazioni di stampa - Non stampare totali documento Active=True ReportVisible=True FilterVisible=True', "FLAG_IVA_AD_ESIGIBILITA_DIFFERITA" BOOLEAN DEFAULT False DESCRIPTION '[Field] Alias=IVA ad esigibilità differita Active=True ReportVisible=True FilterVisible=True', "FLAG_ST_LAYOUT_PRIVATO" BOOLEAN DEFAULT False DESCRIPTION '[Field] Alias=Stampa Layout Privato Active=True ReportVisible=True FilterVisible=True', "FLAG_RDA" BOOLEAN DEFAULT False DESCRIPTION '[Field] Alias=RDA Active=True ReportVisible=True FilterVisible=True', "SPESEIMBALLO" FLOAT DEFAULT 0 DESCRIPTION '[Field] Alias=Importo spese imballo Active=True ReportVisible=True FilterVisible=True', "IVAIMBALLO" SMALLINT DEFAULT 0 DESCRIPTION '[Field] Alias=Codice IVA spese di imballo Active=True ReportVisible=True FilterVisible=True', "SPESETRASPORTO" FLOAT DEFAULT 0 DESCRIPTION '[Field] Alias=Importo spese trasporto Active=True ReportVisible=True FilterVisible=True', "IVATRASPORTO" SMALLINT DEFAULT 0 DESCRIPTION '[Field] Alias=Codice IVA spese di trasporto Active=True ReportVisible=True FilterVisible=True', "SPESEBANCARIE" FLOAT DEFAULT 0 DESCRIPTION '[Field] Alias=Importo spese bancarie Active=True ReportVisible=True FilterVisible=True', "IVABANCARIE" SMALLINT DEFAULT 0 DESCRIPTION '[Field] Alias=Codice IVA spese bancarie Active=True ReportVisible=True FilterVisible=True', "MOL_PERC" FLOAT DEFAULT 0 DESCRIPTION '[Field] Alias=MOL - Percentuale Active=True ReportVisible=True FilterVisible=True', "MOL_VALORE" FLOAT DEFAULT 0 DESCRIPTION '[Field] Alias=MOL - Valore Active=True ReportVisible=True FilterVisible=True', "MOL_GOM" FLOAT DEFAULT 0 DESCRIPTION '[Field] Alias=MOL - GOM Active=True ReportVisible=True FilterVisible=True', "CONSEGNAUNICA" BOOLEAN DEFAULT True DESCRIPTION '[Field] Alias=Consegna unica Active=True ReportVisible=True FilterVisible=True', "PERCEEVADIBILITA" SMALLINT DEFAULT 0 DESCRIPTION '[Field] Alias=Percentuale di evadibilità Active=True ReportVisible=True FilterVisible=True', "PARZIALE_IVA_1" SMALLINT DEFAULT 0 DESCRIPTION '[Field] Alias=Parziale IVA - Codice aliquota 1 Active=True ReportVisible=True FilterVisible=True', "PARZIALE_VALORE_IVA_1" FLOAT DEFAULT 0 DESCRIPTION '[Field] Alias=Parziale IVA - Importo 1 Active=True ReportVisible=True FilterVisible=True', "PARZIALE_IVA_2" SMALLINT DEFAULT 0 DESCRIPTION '[Field] Alias=Parziale IVA - Codice aliquota 2 Active=True ReportVisible=True FilterVisible=True', "PARZIALE_VALORE_IVA_2" FLOAT DEFAULT 0 DESCRIPTION '[Field] Alias=Parziale IVA - Importo 2 Active=True ReportVisible=True FilterVisible=True', "PARZIALE_IVA_3" SMALLINT DEFAULT 0 DESCRIPTION '[Field] Alias=Parziale IVA - Codice aliquota 3 Active=True ReportVisible=True FilterVisible=True', "PARZIALE_VALORE_IVA_3" FLOAT DEFAULT 0 DESCRIPTION '[Field] Alias=Parziale IVA - Importo 3 Active=True ReportVisible=True FilterVisible=True', "RF_DATA" DATE DESCRIPTION '[Field] Alias=Ricevuta fiscale - Data Active=False ReportVisible=True FilterVisible=True', "RF_ORA" VarChar(5) COLLATE "ANSI_CI" DEFAULT '' DESCRIPTION '[Field] Alias=Ricevuta fiscale - Ora Active=False ReportVisible=True FilterVisible=True', "RF_NUMERO" FLOAT DEFAULT 0 DESCRIPTION '[Field] Alias=Ricevuta fiscale - Numero Active=False ReportVisible=True FilterVisible=True', "RF_FLAG_STAMPATO" BOOLEAN DEFAULT False DESCRIPTION '[Field] Alias=Ricevuta fiscale - Stampata Active=False ReportVisible=True FilterVisible=True', "MP_CODICE_1" SMALLINT DEFAULT 0 DESCRIPTION '[Field] Alias=Modalità pagamento - Tipo 1 Active=True ReportVisible=True FilterVisible=True', "MP_IMPORTO_1" FLOAT DEFAULT 0 DESCRIPTION '[Field] Alias=Modalità pagamento - Importo tipo 1 Active=True ReportVisible=True FilterVisible=True', "MP_CODICE_2" SMALLINT DEFAULT 0 DESCRIPTION '[Field] Alias=Modalità pagamento - Tipo 2 Active=True ReportVisible=True FilterVisible=True', "MP_IMPORTO_2" FLOAT DEFAULT 0 DESCRIPTION '[Field] Alias=Modalità pagamento - Importo tipo 2 Active=True ReportVisible=True FilterVisible=True', "MP_CODICE_3" SMALLINT DEFAULT 0 DESCRIPTION '[Field] Alias=Modalità pagamento - Tipo 3 Active=True ReportVisible=True FilterVisible=True', "MP_IMPORTO_3" FLOAT DEFAULT 0 DESCRIPTION '[Field] Alias=Modalità pagamento - Importo tipo 3 Active=True ReportVisible=True FilterVisible=True', "MP_CODICE_4" SMALLINT DEFAULT 0 DESCRIPTION '[Field] Alias=Modalità pagamento - Tipo 4 Active=True ReportVisible=True FilterVisible=True', "MP_IMPORTO_4" FLOAT DEFAULT 0 DESCRIPTION '[Field] Alias=Modalità pagamento - Importo tipo 4 Active=True ReportVisible=True FilterVisible=True', "MP_CODICE_5" SMALLINT DEFAULT 0 DESCRIPTION '[Field] Alias=Modalità pagamento - Tipo 5 Active=True ReportVisible=True FilterVisible=True', "MP_IMPORTO_5" FLOAT DEFAULT 0 DESCRIPTION '[Field] Alias=Modalità pagamento - Importo tipo 5 Active=True ReportVisible=True FilterVisible=True', "CASSA_PREVIDENZA" FLOAT DEFAULT 0 DESCRIPTION '[Field] Alias= Active=False ReportVisible=True FilterVisible=True', "RITENUTA_ACCONTO" FLOAT DEFAULT 0 DESCRIPTION '[Field] Alias=Ritenuta Acconto Active=True ReportVisible=True FilterVisible=True', "RITENUTA_ACCONTO_SU" FLOAT DEFAULT 0 DESCRIPTION '[Field] Alias=Ritenuta Acconto su Active=True ReportVisible=True FilterVisible=True', "FLAG_RITENUTA_ACCONTO_MANUALE" BOOLEAN DEFAULT False DESCRIPTION '[Field] Alias= Active=False ReportVisible=True FilterVisible=True', "RITENUTA_ACCONTO_IMPORTO" FLOAT DEFAULT 0 DESCRIPTION '[Field] Alias= Active=True ReportVisible=True FilterVisible=True', "COD_ASSISTENZA" FLOAT DEFAULT 0 DESCRIPTION '[Field] Alias=Codice assistenza di riferimento (per interventi) Active=True ReportVisible=True FilterVisible=True', "RIGA_ATTIVITA" FLOAT DEFAULT 0 DESCRIPTION '[Field] Alias= Active=False ReportVisible=True FilterVisible=True', "RIGA_PRODOTTO" FLOAT DEFAULT 0 DESCRIPTION '[Field] Alias=ID assistenza di riferimento (per interventi) Active=True ReportVisible=True FilterVisible=True', "SHARE_FLAG_INVIATO" BOOLEAN DEFAULT False DESCRIPTION '[Field] Alias= Active=False ReportVisible=True FilterVisible=True', "SHARE_FLAG_DATA" DATE DESCRIPTION '[Field] Alias= Active=False ReportVisible=True FilterVisible=True', "SHARE_FLAG_ORA" VarChar(5) COLLATE "ANSI_CI" DEFAULT '' DESCRIPTION '[Field] Alias= Active=False ReportVisible=True FilterVisible=True', "FLAG_REG_CASSA_STAMPATO" BOOLEAN DEFAULT False DESCRIPTION '[Field] Alias=Documento inviato al registratore di cassa Active=True ReportVisible=True FilterVisible=True', "FLAG_RECORD_BLOCCATO" BOOLEAN DEFAULT False DESCRIPTION '[Field] Alias=Documento bloccato Active=True ReportVisible=True FilterVisible=True', "FLAG_RISERVATO" BOOLEAN DEFAULT False DESCRIPTION '[Field] Alias=Riservato Active=False ReportVisible=False FilterVisible=False', "CONTABILITA_FLAG_ESPORTATO" BOOLEAN DEFAULT False DESCRIPTION '[Field] Alias=Contabilità - Documento esportato Active=True ReportVisible=True FilterVisible=True', "CONTABILITA_DATA_ESPORTAZIONE" DATE DESCRIPTION '[Field] Alias=Contabilità - Data esportazione Active=True ReportVisible=True FilterVisible=True', "CONTABILITA_ORA_ESPORTAZIONE" VarChar(5) COLLATE "ANSI_CI" DEFAULT '' DESCRIPTION '[Field] Alias=Contabilità - Ora esportazione Active=True ReportVisible=True FilterVisible=True', "RIF_DOC_RICEVUTO_NUMERO" VarChar(10) COLLATE "ANSI_CI" DEFAULT '' DESCRIPTION '[Field] Alias=Rifermento conferma ordine - Numero conferma Active=True ReportVisible=True FilterVisible=True', "RIF_DOC_RICEVUTO_DATA" DATE DESCRIPTION '[Field] Alias=Rifermento conferma ordine - Data coferma Active=True ReportVisible=True FilterVisible=True', "RIF_DOC_RICEVUTO_MODALITA_RICEZIONE" SMALLINT DEFAULT 0 DESCRIPTION '[Field] Alias=Rifermento conferma ordine - Ricevuto a mezzo Active=True ReportVisible=True FilterVisible=True', "RIF_DOC_RICEVUTO_DATA_RICEZIONE" DATE DESCRIPTION '[Field] Alias=Rifermento conferma ordine - Data ricezione coferma Active=True ReportVisible=True FilterVisible=True', "ORIGINE_DOCUMENTO" VarChar(5) COLLATE "ANSI_CI" DEFAULT '' DESCRIPTION '[Field] Alias=Origine documento (da saldo) Active=True ReportVisible=False FilterVisible=False', "LINK_ID" INTEGER DEFAULT 0 DESCRIPTION '[Field] Alias= Active=True ReportVisible=False FilterVisible=False', "LINK_NUMERO_DOCUMENTO" INTEGER DEFAULT 0 DESCRIPTION '[Field] Alias= Active=True ReportVisible=False FilterVisible=False', "LINK_DATA_DOCUMENTO" DATE DESCRIPTION '[Field] Alias= Active=True ReportVisible=False FilterVisible=False', "NOTABREVE" VarChar(80) COLLATE "ANSI_CI" DEFAULT '' DESCRIPTION '[Field] Alias=Nota breve Active=True ReportVisible=True FilterVisible=True', "NOTE" CLOB COLLATE "ANSI" DESCRIPTION '[Field] Alias=Note Active=True ReportVisible=True FilterVisible=True' ) VERSION 1 UNENCRYPTED INDEX PAGE SIZE 4096 BLOB BLOCK SIZE 512 MAX ROW BUFFER SIZE 32768 MAX INDEX BUFFER SIZE 65536 MAX BLOB BUFFER SIZE 32768; CREATE INDEX "ANNO" ON "CorriT" ("ANNOORDINE"); |
Fri, May 21 2010 3:12 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Mauro,
<< SELECT DISTINCT ANNOORDINE FROM CORRIT or SELECT ANNOORDINE FROM CORRIT GROUYP BY ANNOORDINE >> Did you set RequestSensitive to True ? ElevateDB only uses the primary key for DISTINCT when it generates a sensitive result set. For insensitive result sets, there really isn't much of a point to it. -- Tim Young Elevate Software www.elevatesoft.com |
Mon, May 24 2010 4:38 AM | Permanent Link |
Mauro Botta | > For insensitive result sets, there really isn't much of a point to it.
there is one.... Open your EDB-ToDo File Add : EDB 2.04 Build 1 + Optimize DISTINCT ( without Primary key ) hehehehe Good Morning, Tim |
Tue, May 25 2010 4:41 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Mauro,
<< there is one.... >> BTW, are you running this over a network in a file-sharing arrangement ? If so, then that is most likely the issue with the performance. What performance do you get with the ElevateDB Server, or local execution ? The DISTINCT operations themselves are not really at issue here - if you look at the bottom of the execution plan you'll see that the I/O statistics for the result set are minimal. -- Tim Young Elevate Software www.elevatesoft.com |
This web page was last updated on Tuesday, April 30, 2024 at 03:55 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |