Dec-15-2020, 11:44 AM
Here's the database schema:
schema:
I used python tags here so that window would scroll
schema:
I used python tags here so that window would scroll
mdb-schema dati.mdb -- ---------------------------------------------------------- -- MDB Tools - A library for reading MS Access database files -- Copyright (C) 2000-2011 Brian Bruns and others. -- Files in libmdb are licensed under LGPL and the utilities under -- the GPL, see COPYING.LIB and COPYING files respectively. -- Check out http://mdbtools.sourceforge.net -- ---------------------------------------------------------- -- That file uses encoding UTF-8 CREATE TABLE [Cartecredito] ( [codice] Integer, [descrizione] Text (50), [percentuale] Single, [fisso] Single ); CREATE TABLE [certificati] ( [numero] Text (200), [codice] Text (200), [oggetto] Text (200), [titolooro] Text (200), [peso] Text (200), [data] Text (200), [cliente] Text (200), [descrizione] Memo/Hyperlink (255), [controllo] Memo/Hyperlink (255), [totpietre] Integer, [varieta1] Text (100), [varieta2] Text (100), [varieta3] Text (100), [varieta4] Text (100), [varieta5] Text (100), [varieta6] Text (100), [peso1] Text (100), [peso2] Text (100), [peso3] Text (100), [peso4] Text (100), [peso5] Text (100), [peso6] Text (100), [colore1] Text (100), [colore2] Text (100), [colore3] Text (100), [colore4] Text (100), [colore5] Text (100), [colore6] Text (100), [purezza1] Text (100), [purezza2] Text (100), [purezza3] Text (100), [purezza4] Text (100), [purezza5] Text (100), [purezza6] Text (100), [dimensioni1] Text (100), [dimensioni2] Text (100), [dimensioni3] Text (100), [dimensioni4] Text (100), [dimensioni5] Text (100), [dimensioni6] Text (100), [taglioforma1] Text (100), [taglioforma2] Text (100), [taglioforma3] Text (100), [taglioforma4] Text (100), [taglioforma5] Text (100), [taglioforma6] Text (100), [valore] Text (200) ); CREATE TABLE [fattddt] ( [tipo] Integer, [nfatt] Text (10), [data] Text (12), [r2] Text (50), [r3] Text (50), [paga] Text (44), [corpo] Text (100), [iva] Integer, [riga] Integer, [totale] Single, [r1] Text (60), [note] Text (70), [r4] Text (50), [ragsoc2] Text (50), [accomp] Text (2), [documento] Text (50), [commento] Text (100), [scontrino] Text (10), [datascontrino] Text (10), [spunta] Text (3), [corpo2] Text (100), [r1sped] Text (60), [ragsoc2sped] Text (50), [r2sped] Text (50), [r3sped] Text (50), [r4sped] Text (50), [note2] Text (70), [udm] Text (10), [dataord] Long Integer, [calce1] Text (70), [calce2] Text (70), [calce3] Text (70), [calce4] Text (70), [ddtInFattura] Text (250), [codcli] Long Integer, [nomeFE] Text (150), [cognomeFE] Text (150), [naturaFE] Text (250) ); CREATE TABLE [GarCalce] ( [testo] Memo/Hyperlink (255) ); CREATE TABLE [GarRipaCalce] ( [testo] Memo/Hyperlink (255) ); CREATE TABLE [immagini] ( [codice] Long Integer, [percorso] Text (150) ); CREATE TABLE [magqta] ( [codice] Long Integer, [qta] Long Integer ); CREATE TABLE [negozio] ( [corrente] Long Integer ); CREATE TABLE [noteagg] ( [codice] Long Integer, [gr] Single, [kt1] Single, [kt2] Single ); CREATE TABLE [tabacc] ( [codice] Long Integer, [data] Text (10), [acconto] Single ); CREATE TABLE [TabAcc2] ( [codice] Long Integer, [data] Text (10), [acconto] Single, [cliente] Text (50) ); CREATE TABLE [TabCategorie] ( [cod] Integer, [descr] Text (50) ); CREATE TABLE [TabCatSpese1] ( [cod] Integer, [descr] Text (40) ); CREATE TABLE [TabCatSpese2] ( [codp] Integer, [cod] Integer, [descr] Text (40) ); CREATE TABLE [TabCespiti] ( [descr] Text (50), [anno] Integer, [valore] Double, [perc] Integer ); CREATE TABLE [tabcosto] ( [cifra] Integer, [lettera] Text (1) ); CREATE TABLE [TabCstorico] ( [codice] Text (8), [prezzoco] Long Integer ); CREATE TABLE [tabcv] ( [codice] Long Integer, [cliente] Text (50), [datafinev] Text (10), [datauscita] Text (10), [acconto] Single, [prvend] Single ); CREATE TABLE [TabDettTrasporto] ( [tipo] Long Integer, [numdoc] Text (10), [causale] Text (50), [porto] Text (50), [trasportomezzo] Text (50), [vettore] Text (50), [peso] Text (50), [colli] Text (50), [data_ora] Text (50) ); CREATE TABLE [tabgio] ( [peso] Single, [costog] Single, [manif] Single, [incrodia] Single, [t1] Single, [t2] Single, [t3] Single, [t4] Single, [t5] Single, [t6] Single, [t7] Single, [t8] Single, [t9] Single, [t10] Single, [codice] Text (10), [note] Text (250), [nserie] Text (80), [vetro] Text (80), [misura] Text (80), [cassa] Text (80), [quadrante] Text (80), [certificato] Text (80), [bracciale] Text (80), [movimento] Text (80), [gemme] Text (80), [calibro] Text (80), [sottomodello] Text (80), [pietra1] Text (80), [pietra2] Text (80), [pietra3] Text (80), [forni1] Text (80), [forni2] Text (80), [forni3] Text (80), [fattura1] Text (80), [fattura2] Text (80), [fattura3] Text (80), [t11] Single, [t12] Single, [t13] Single, [t14] Single, [t15] Single, [t16] Single ); CREATE TABLE [tabinv] ( [codice] Long Integer, [qta] Long Integer ); CREATE TABLE [TabIVA] ( [anno] Integer, [mese] Integer, [valore] Single ); CREATE TABLE [TabLavRipa] ( [cod] Integer, [descr] Text (50), [prpub] Single, [prcosto] Single ); CREATE TABLE [tablic] ( [ragsoc] Text (50), [Ind] Text (50), [citta] Text (50), [cap] Text (5), [prov] Text (2), [piva] Text (11), [tel] Text (30), [fax] Text (30), [email] Text (50), [iva] Integer, [lecu] Single, [calo] Long Integer, [calo2] Long Integer, [arr] Long Integer, [stringaeti] Text (50), [arreuro] Single, [cf] Text (16), [Rea] Text (30), [CapSoc] Text (30), [ufficioRea] Text (2), [socioUnicoP] Text (200), [statoLiquidazione] Text (200), [regimeFiscaleP] Text (200), [esigibilitaIVA] Text (200), [progressivoFE] Text (15), [numOAM] Text (50) ); CREATE TABLE [tabliv] ( [operatore] Text (25), [pass] Text (25), [livelli] Text (15), [clienti] Integer, [fornitori] Integer, [sms] Integer ); CREATE TABLE [TabLogEventi] ( [tipoop] Text (30), [codice] Text (8), [oldprpub] Single, [newprpub] Single, [data] Long Integer, [ora] Text (5) ); CREATE TABLE [tabmag] ( [codice] Long Integer, [codbar] Text (8), [descr] Text (50), [modello] Text (50), [forni] Text (50), [nfattura] Text (50), [punit] Single, [manif] Text (50), [cmetallo] Long Integer, [calo] Long Integer, [ricarico] Text (50), [datacarico] Text (10), [tipo] Integer, [prezzopu] Long Integer, [sconto] Single, [prezzoco] Long Integer, [sconto2] Single, [iva] Long Integer, [stato] Text (50), [imposto] Text (2), [situa] Text (5), [note] Text (70), [prezzopueuro] Single, [settore] Integer, [pos] Integer, [referenza] Text (100), [misura] Text (30), [completa] Memo/Hyperlink (255) ); CREATE TABLE [tabmet] ( [oro] Long Integer, [argento] Long Integer ); CREATE TABLE [TabModifica] ( [codice] Text (8), [datamod] DateTime ); CREATE TABLE [TabModPag] ( [cod] Integer, [descr] Text (50) ); CREATE TABLE [tabogg] ( [descrizione] Text (25), [escludi] Integer ); CREATE TABLE [TabPercSconti] ( [inizio] Text (4), [fine] Text (4), [sconto] Integer ); CREATE TABLE [TabPos] ( [cod] Integer, [descr] Text (50) ); CREATE TABLE [TabReferenze] ( [referenza] Text (100), [sottoscorta] Integer, [continuativo] Text (2) ); CREATE TABLE [TabRFID] ( [rfid] Text (200), [codice] Text (8) ); CREATE TABLE [tabric] ( [codice] Text (3), [valore] Long Integer ); CREATE TABLE [TabRientri] ( [codbar] Text (8), [descr] Text (50), [forni] Text (50), [prezzopu] Single, [prezzoco] Single, [prezzovend] Single, [datacarico] Text (10), [datascarico] Text (10), [datareso] Text (10), [dataord] Long Integer, [Esportato] Text (20), [situa] Text (20) ); CREATE TABLE [TabRipaOgg] ( [descr] Text (70) ); CREATE TABLE [TabRitiroMetallo] ( [numero] Long Integer, [cliente] Text (100), [data] Text (10), [dataord] Long Integer, [peso] Single, [valore] Single, [destinazione] Text (40), [operazione] Integer, [check1] Text (2), [check2] Text (2), [check3] Text (2), [check4] Text (2), [check5] Text (2), [check6] Text (2), [check7] Text (2), [osservazioni] Text (100), [descrizione] Memo/Hyperlink (255), [nato] Text (100), [indirizzo] Text (100), [documento] Text (100), [citta] Text (100), [rilasciodoc] Text (100), [codfiscale] Text (100), [datarilasciodoc] Text (100), [ora] Text (5) ); CREATE TABLE [tabsca] ( [nfatt] Text (50), [forni] Text (50), [fino] Long Integer, [importo] Single, [tipomoneta] Text (50), [datafat] Text (10), [iva] Long Integer, [note] Text (50), [nrate] Long Integer, [tipopag] Text (50), [tiporeg] Text (50), [nrata] Long Integer, [valore] Single, [scadenza] Text (10), [orddata] Long Integer, [pagata] Text (50), [avviso] Text (1), [modpag] Integer, [noteRata] Text (100) ); CREATE TABLE [TabSconti] ( [data] Text (10), [ordine] Long Integer, [valore] Single, [tessera] Text (30), [tipo] Text (1) ); CREATE TABLE [TabSetRipa] ( [cod] Integer, [descr] Text (50) ); CREATE TABLE [TabSMS] ( [numero] Text (25), [testo] Text (255), [data] Long Integer, [nome] Text (100) ); CREATE TABLE [TabSpese] ( [codp] Integer, [cod] Integer, [descr] Text (50), [data] Text (10), [orddata] Long Integer, [tipo] Integer, [importo] Double ); CREATE TABLE [TabTessere] ( [codbar] Text (30), [codice] Long Integer ); CREATE TABLE [tabven] ( [codice] Long Integer, [codbar] Text (8), [descr] Text (50), [modello] Text (50), [forni] Text (50), [nfattura] Text (50), [datacarico] Text (10), [datascarico] Text (10), [tipo] Integer, [prezzopu] Long Integer, [prezzoco] Long Integer, [iva] Long Integer, [prezzopu2] Long Integer, [lecu] Single, [prezzovend] Long Integer, [peso] Single, [manif] Text (50), [cmetallo] Long Integer, [calo] Long Integer, [ricarico] Text (50), [sconto] Single, [sconto2] Single, [stato] Text (50), [imposto] Text (50), [situa] Text (50), [note] Text (70), [ordcarico] Long Integer, [ordscarico] Long Integer, [settore] Integer, [commento] Text (50), [pos] Integer, [venditore] Integer, [codreg] Long Integer, [referenza] Text (100), [misura] Text (30), [completa] Memo/Hyperlink (255) ); CREATE TABLE [TabVenditori] ( [cod] Integer, [descr] Text (50), [stato] Text (30) ); CREATE TABLE [TabVerificaDB] ( [codice] Text (8), [qta] Integer, [archivi] Text (255) ); CREATE TABLE [Temp2SottoscortaXLS] ( [Referenza] Text (100), [Giacenza] Long Integer, [Venduto] Long Integer, [Venduto_AnnoCorrente] Long Integer, [Venduto_AnnoPrecedente] Long Integer, [Venduto_30] Long Integer, [Venduto_60] Long Integer, [Venduto_90] Long Integer, [Venduto_180] Long Integer, [Reso] Long Integer, [Acquisti_AnnoCorrente] Long Integer, [Acquisti_AnnoPrecedente] Long Integer, [Sottoscorta] Long Integer, [giacenza31dic] Long Integer, [Val_Giacenza_Pub] Single, [Val_Giacenza_Costo] Single, [Val_Acquisti_Pub_AnnoCorrente] Single, [Val_Acquisti_Costo_AnnoCorrente] Single, [Val_Acquisti_Pub_AnnoPrecedente] Single, [Val_Acquisti_Costo_AnnoPrecedente] Single, [Margine] Single ); CREATE TABLE [TempAnalisiForniXLS] ( [Fornitore] Text (100), [Partenza_PZ] Long Integer, [Partenza_Costo] Long Integer, [Acquisti_PZ] Long Integer, [Acquisti_Costo] Long Integer, [Vendite_PZ] Long Integer, [Vendite_Costo] Long Integer, [Rimanenze_PZ] Long Integer, [Rimanenze_Costo] Long Integer, [Margine_Perc] Single, [Margine_Valore] Single ); CREATE TABLE [TempCatOIRXLS] ( [IdWeb] Text (100), [codiceEG] Text (100), [Referenza] Text (100), [Descrizione] Text (100), [Marca] Text (100), [PrPubblico] Single, [PrListino] Single, [PrAffiliati] Single, [statoWEB] Text (100), [statoEG] Text (100) ); CREATE TABLE [TempCLIXLS] ( [Codice] Integer, [Nominativo] Text (60), [Indirizzo] Text (70), [CAP] Text (5), [Citta] Text (25), [TEL] Text (25), [TelUff] Text (20), [Cellulare] Text (20), [EMail] Text (50), [Note] Text (40), [Nascita] Text (10), [CodFiscale] Text (16), [nTessera] Text (30), [Credito] Single, [Descrizione] Memo/Hyperlink (255), [Anniversario] Text (10) ); CREATE TABLE [TempDaRiordinareCIPXLS] ( [Referenza] Text (100), [Giacenza] Long Integer, [Sottoscorta] Long Integer, [DaRiordinare] Long Integer, [Continuativo] Text (100), [Descrizione] Text (100), [Fornitore] Text (100), [Peso] Single, [Modello] Text (100), [PrezzoAcquisto] Single ); CREATE TABLE [TempIncassiXLS] ( [Tipo] Text (20), [Codice] Text (20), [Descrizione] Text (50), [Data] DateTime, [PrPub] Single, [Incasso] Single, [Note_Cliente] Text (50), [Categoria] Text (50), [Costo] Single, [Fornitore] Text (100), [Settore] Text (50) ); CREATE TABLE [TempINVEXLS] ( [Codice] Text (8), [Descrizione] Text (50), [Modello] Text (50), [Note] Text (50), [Fornitore] Text (50), [DataCarico] Text (10), [PrezzoPub] Single, [Qta] Integer, [PrezzoCosto] Single ); CREATE TABLE [TempInvXLS] ( [Codice] Text (8), [Descrizione] Text (50), [Fornitore] Text (50), [Prezzo] Single, [Stato] Text (30), [QtaMancante] Integer, [Settore] Integer, [pos] Integer ); CREATE TABLE [TempMAGXLS] ( [Codice] Text (8), [Descrizione] Text (50), [Modello] Text (50), [Note] Text (50), [Fornitore] Text (50), [PrezzoCo] Single, [PrezzoPu] Single, [Categoria] Integer, [DataCarico] DateTime, [Settore] Integer, [Peso] Single, [pos] Integer, [Manif] Single, [CostoStorico] Single, [Misura] Text (30) ); CREATE TABLE [TempMovMagXLS] ( [Data] DateTime, [Causale] Text (100), [Codice] Text (100), [Descrizione] Text (100), [Fornitore] Text (100), [Costo] Single ); CREATE TABLE [TempResiQta] ( [codbar] Text (8), [datacarico] Text (10), [noqta] Long Integer ); CREATE TABLE [TempResoXLS] ( [Codice] Text (8), [Descrizione] Text (50), [Modello] Text (50), [Note] Text (50), [Fornitore] Text (50), [Peso] Single, [DataCarico] DateTime, [DataReso] DateTime, [PrezzoCo] Single, [PrezzoPu] Single, [Categoria] Integer, [Settore] Integer, [Manif] Single ); CREATE TABLE [TempRipaXLS] ( [Nbusta] Long Integer, [Cliente] Text (50), [Riparatore] Text (50), [DataReg] DateTime, [DataUscita] DateTime, [DataRientro] DateTime, [DataConsegna] DateTime, [Garanzia] Text (2), [PrezzoCo] Single, [PrezzoPub] Single, [Descrizione1] Text (70), [Descrizione2] Memo/Hyperlink (255), [Riparazione2] Memo/Hyperlink (255), [Riparazione1] Text (114) ); CREATE TABLE [TempRitiroMetalloXLS] ( [Numero] Long Integer, [Data] DateTime, [Cliente] Text (100), [Peso] Single, [Valore] Single, [Destinazione] Text (40) ); CREATE TABLE [TempSottoscortaXLS] ( [Referenza] Text (100), [Giacenza] Long Integer, [Venduto] Long Integer, [Reso] Long Integer, [Sottoscorta] Long Integer, [Venduto_AnnoCorrente] Long Integer, [Venduto_AnnoPrecedente] Long Integer, [Acquisti_AnnoCorrente] Long Integer, [Acquisti_AnnoPrecedente] Long Integer, [Val_Giacenza_Pub] Single, [Val_Giacenza_Costo] Single, [Val_Acquisti_AnnoCorrente] Single, [Val_Acquisti_AnnoPrecedente] Single ); CREATE TABLE [TempVALANNOXLS] ( [Codice] Text (8), [Descrizione] Text (50), [Fornitore] Text (50), [PrezzoCo] Single, [DataCarico] DateTime, [PrezzoPub] Single, [Modello] Text (50), [Note] Text (70), [Categoria] Integer, [Settore] Integer, [Ubicazione] Integer, [Peso] Single, [NomeSettore] Text (100) ); CREATE TABLE [TempVarAcquistiCZXLS] ( [Codice] Text (8), [Descrizione] Text (50), [Modello] Text (50), [Fornitore] Text (50), [oldCosto] Single, [newCosto] Single, [Categoria] Text (30), [Magazzino] Text (30), [DataVariazione] DateTime ); CREATE TABLE [TempVEN2XLS] ( [Codice] Text (8), [Descrizione] Text (50), [Modello] Text (50), [Fornitore] Text (50), [DataScarico] DateTime, [Incasso] Single, [Venditore] Text (70), [Cliente] Text (70), [NumReg] Text (12) ); CREATE TABLE [TempVENXLS] ( [Codice] Text (8), [Descrizione] Text (50), [Modello] Text (50), [Note] Text (50), [Fornitore] Text (50), [PrezzoCo] Single, [PrezzoPu] Single, [Incasso] Single, [Categoria] Integer, [DataCarico] DateTime, [Datascarico] DateTime, [Settore] Integer, [Peso] Single, [Manif] Single, [CostoStorico] Single, [Misura] Text (30) ); CREATE TABLE [tipipag] ( [tipo] Text (50) ); CREATE TABLE [DettVenduto] ( [codreg] Long Integer, [codcli] Long Integer ); CREATE TABLE [immaR] ( [codice] Long Integer, [percorso] Text (150) ); CREATE TABLE [puntatori] ( [numpunta] Long Integer ); CREATE TABLE [TabCarrelliOiR] ( [id] Text (30), [idweb] Text (30), [codiceinterno] Text (8), [dataord] Long Integer, [valore] Single, [esito] Text (30) ); CREATE TABLE [tabcli] ( [Codice] Long Integer, [Tel] Text (25), [cap] Text (5), [citta] Text (25), [credito] Long Integer, [nascita] Text (10), [codfiscale] Text (16), [teluff] Text (20), [cell] Text (20), [note] Text (40), [nome] Text (60), [tipo] Integer, [email] Text (50), [indirizzo] Text (70), [nome2] Text (60), [noteagg] Memo/Hyperlink (255), [documento] Text (20), [titolo] Text (50), [piva] Text (13), [nazione] Text (60), [datamano] Text (10), [pollicedx] Text (10), [pollicesx] Text (10), [indicedx] Text (10), [indicesx] Text (10), [mediodx] Text (10), [mediosx] Text (10), [anularedx] Text (10), [anularesx] Text (10), [mignolodx] Text (10), [mignolosx] Text (10), [iban] Text (27), [titolosped] Text (50), [nomesped] Text (60), [nome2sped] Text (60), [indirizzosped] Text (70), [capsped] Text (5), [cittasped] Text (25), [nazionesped] Text (60), [anniversario] Text (10), [rilasciodoc] Text (100), [datarilasciodoc] Text (100), [pec] Text (100), [provincia] Text (2), [codnazione] Text (100), [codiceDestinatario] Text (7) ); CREATE TABLE [tabforni] ( [Codice] Long Integer, [Nome] Text (30), [cap] Text (50), [Note] Text (50), [sconto] Single, [sconto2] Single, [prov] Text (2), [stato] Text (15), [rif] Text (30), [noterif] Text (30), [telrif] Text (30), [codfiscale] Text (16), [selez] Integer, [ricar] Integer, [nome2] Text (30), [tel] Text (30), [email] Text (50), [brand] Text (30), [cat1] Integer, [cat2] Integer, [cat3] Integer, [cat4] Integer, [cat5] Integer, [cat6] Integer, [piva] Text (13), [iban] Text (27), [nomesped] Text (30), [nome2sped] Text (30), [capsped] Text (50), [provsped] Text (2), [statosped] Text (15), [indirizzo] Text (70), [citta] Text (50), [indirizzosped] Text (70), [cittasped] Text (50) ); CREATE TABLE [tablav] ( [valore] Long Integer, [codice] Text (5) ); CREATE TABLE [TabLogUbi] ( [codice] Text (8), [descrizione] Text (30), [data] DateTime, [sorg] Integer, [dest] Integer ); CREATE TABLE [TabMovCarteCredito] ( [data] Text (10), [tot] Single, [codicecarta] Integer, [percentuale] Single, [netto] Single, [orddata] Long Integer, [fisso] Single ); CREATE TABLE [tabreso] ( [codbar] Text (50), [Forni] Text (50), [Descr] Text (50), [Prezzoco] Long Integer, [Prezzocoeuro] Long Integer, [datacarico] Text (10), [datascarico] Text (10), [modello] Text (50), [tipo] Long Integer, [punit] Single, [codice] Long Integer, [nfattura] Text (50), [manif] Text (50), [cmetallo] Long Integer, [calo] Long Integer, [ricarico] Text (50), [prezzopu] Long Integer, [sconto] Single, [sconto2] Single, [iva] Long Integer, [stato] Text (50), [imposto] Text (2), [situa] Text (5), [note] Text (70), [prezzopueuro] Single, [settore] Integer, [ordcarico] Long Integer, [ordscarico] Long Integer, [pos] Integer, [referenza] Text (100), [misura] Text (30), [completa] Memo/Hyperlink (255) ); CREATE TABLE [tabripa] ( [Nome] Text (25), [Tel] Text (25), [Nbusta] Long Integer, [data] Text (10), [Descrizione] Text (30), [costo] Long Integer, [vendita] Long Integer, [riparatore] Text (50), [consegnato] Text (50), [datacons] Text (10), [datauscita] Text (50), [datarientro] Text (50), [posizione] Text (50), [dataprev] Text (10), [assicurato] Long Integer, [note] Text (30), [settore] Integer, [utente] Text (25), [cell] Text (20), [prevt] Text (12), [prev] Long Integer, [garanzia] Long Integer, [opeseguite] Text (120), [codcli] Long Integer, [valdichiarato] Text (50), [acconto] Text (50), [pesopietre] Text (50), [descr2] Memo/Hyperlink (255), [oper2] Memo/Hyperlink (255), [pronta] Boolean NOT NULL, [venditore] Integer, [smsSent] Boolean NOT NULL, [lavorazioni] Text (250), [noteinterne] Memo/Hyperlink (255), [dPreventivo] Integer, [email] Text (50), [operazioni] Text (114), [pos] Integer ); CREATE TABLE [TabRipaUbi] ( [numerazione] Text (10), [ubicazione] Integer ); CREATE TABLE [TabSettori] ( [cod] Integer, [descr] Text (50) ); CREATE TABLE [TabUltimi] ( [Tipo] Integer, [Valore] Text (10) ); CREATE TABLE [TempAcquistiCZXLS] ( [Fornitore] Text (50), [NumFattura] Text (50), [Categoria] Integer, [NumPezzi] Long Integer, [Costo] Single, [Stato] Text (30), [Magazzino] Text (30), [DataFattura] DateTime ); CREATE TABLE [TempDaRiordinareXLS] ( [Referenza] Text (100), [Giacenza] Long Integer, [Sottoscorta] Long Integer, [DaRiordinare] Long Integer, [Continuativo] Text (100) ); CREATE TABLE [TempMultidbCZXLS] ( [Codice] Text (8), [Descrizione] Text (50), [Modello] Text (50), [Fornitore] Text (50), [Pubblico] Single, [Costo] Single, [Stato] Text (30), [Magazzino] Text (30) ); CREATE TABLE [TempScadenXLS] ( [nFattura] Text (50), [nRata] Integer, [Fornitore] Text (50), [TipoPagamento] Text (50), [Scadenza] DateTime, [Importo] Single, [Note] Text (80), [PAGATA] Text (10), [PagamentoRata] Text (100), [NoteRata] Text (100) );