Anagrafiche articoli.
# | COLONNA | DECRIZIONE | TIPO | LEN | NOTE |
---|---|---|---|---|---|
1 | CODICE | Codice Articolo | Stringa | 25 | |
2 | Descrizione | Descrizione Articolo | Stringa | 100 | |
3 | UnitaMisura | Unità misura principale | Stringa | 3 | |
4 | GruppoMagazzino | Gruppo magazzino | Stringa | 10 | |
5 | Listino1 | Listino 1 | Decimale | ||
6 | Listino2 | Listino 2 | Decimale | ||
7 | Listino3 | Listino 3 | Decimale | ||
8 | Listino4 | Listino 4 | Decimale | ||
9 | Listino5 | Listino 5 | Decimale | ||
10 | Listino6 | Listino 6 | Decimale | ||
11 | Listino7 | Listino 7 | Decimale | ||
12 | Listino8 | Listino 8 | Decimale | ||
13 | Listino9 | Listino 9 | Decimale | Utilizzato per il prezzo di listino minimo. Utilizzato per il calcolo della marginalità o bloccare la vendita sotto un determinato prezzo | |
14 | CodiceIVA | Codice iva | Stringa | 4 | Codice iva che deve essere presente nella tabella Aliquote. Se non viene trovata corrispondenza Zippy applica l'iva al 99% |
15 | Sconto1 | Sconto 1 | Stringa | 20 | |
16 | Sconto2 | Sconto 2 | Stringa | 20 | |
17 | Sconto3 | Sconto 3 | Stringa | 20 | |
18 | Barcode | Barcode | Stringa | 20 | |
19 | UnitaMisura1 | Unità misura alternativa | Stringa | 3 | Seconda unità di misura (Es. KG) |
20 | UnitaMisura2 | Unità misura 3 | Stringa | 3 | Terza unità di misura (Es. LT) |
21 | UnitaMisura3 | Unità misura 4 | Stringa | 3 | Quarta unità di misura Es.(SC) |
22 | Fattore1 | Fattore conversione principale /alternativa | Decimale | Rapporto di unmisura1 con unmisura (Es. KG = 3 NR) | |
23 | Fattore2 | Fattore conversione principale /alternativa | Decimale | Rapporto di unmisura2 con unmisura (Es. LT = 2,5 NR) | |
24 | Fattore3 | Fattore conversione principale /4 | Decimale | Rapporto di unmisura3 con unmisura (Es. SC = 10 NR) | |
25 | CodiceCessionario | Codice Cessionario | Stringa | 20 | Gestione cessionario per articolo. Il documento di vendita verrà splittato per n documenti secondo i codici dei cessionari trovati negli articoli inseriti nel documento di vendita. |
26 | Pt1AR_LIST | Stringa | 20 | Non gestito | |
27 | Pt2AR_LIST | Stringa | 20 | Non gestito | |
28 | Pt3AR_LIST | Stringa | 20 | Non gestito | |
29 | Pt4AR_LIST | Stringa | 20 | Non gestito | |
30 | Pt5AR_LIST | Stringa | 20 | Non gestito | |
31 | Pt6AR_LIST | Stringa | 20 | Non gestito | |
32 | Pt7AR_LIST | Stringa | 20 | Non gestito | |
33 | FlagOmagiabile | Flag Omaggiabile | Stringa | 1 | Se passato X viene applicata la causale di omaggio in TipoOmaggio |
34 | TipoOmaggio | Tipo Omaggio | Stringa | 2 | O = Omaggio Merce; Oo = Omaggio Totale |
35 | Quadratura | Quadratura | Decimale | Non gestito | |
36 | NoPezzoZero | No prezzo zero | Intero | Non gestito | |
37 | Classe | Classe | Stringa | 20 | Classe di raggruppamento per gestire l'ordinamento delle righe in fase di stampa documento o utilizzato come classe di raggruppamento nella riassegnazione sconti finali con tabella RIASSEGNASCONTI.TXT |
38 | Peso | Peso | Decimale | Peso. Viene passato come riferimento di calcolo totale peso articoli nel documento | |
39 | GestioneLotti | Gestione lotto si o no | Intero | Flag 1 o 0. Se viene applicato il controllo del lotto obbligatorio e su alcuni prodotti non si vuole gestire passare 0 | |
40 | StampaNotePiede | StampaNotePiede | Intero | Flag 1 o 0. Serve per gestire la stampa di alcune note piede particolari in presenza di almeno un articolo in documento con il flag = 1 | |
41 | LinkSchedaTecnica | Link a file scheda tecnica | Stringa | ND | Non gestito |
42 | ShelfLife | ShelfLife | Intero | ||
43 | TipoArticolo | Tipo Articolo | Stringa | 5 | se gestito anche in docana filtra la lista degli articoli sul tipo articolo definito nel codice del documento |
44 | Modello | Modello | Stringa | 50 | Modello macchinario |
45 | GestioneMacchinario | Gestione Macchinario | Intero | Flag 1 o 0. Se viene passato a 1 la richiesta del codice macchinario sulle righe del documento è obbligatoria | |
46 | ArticoloNonVendibile | Articolo non vendibile | Intero | Flag 1 o 0. Se viene passato a 1 l'articolo non sarà imputabile all'interno delle righe del documento |
Esempio
'.','.','NR','',0.0,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,10.000000,'20','5','','','051111125137','NR','NR','NR',1.000000,1.000000,1.000000,'' 'SPX','Spesa incasso','NR','00208',10.00000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,10.000000,'20','5','','','051111125137','NR','NR','NR',1.000000,1.000000,1.000000,'' 'ABITO','Abito Uomo','NR','00208',28.300000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,10.000000,'20','5','','','051111125137','NR','NR','NR',1.000000,1.000000,1.000000,'C000100' 'CAMICIA','Camicia Donna','NR','00208',28.300000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,'20','','','','051111125137','NR','NR','NR',1.000000,1.000000,1.000000,'C0000200' '0001','Scarpa Mocassino','NR','00208',28.300000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,'20','','','','051111125137','NR','NR','NR',1.000000,1.000000,1.000000,'C0000200' '0002','Stivale','NR','00201',59.600000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,'20','','','','8011334031054','NR','NR','NR',1.000000,1.000000,1.000000,'C0000200' '0003','Succo di frutta','NR','00201',3.600000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,'20','','','','98011334031054','NR','NR','NR',1.000000,1.000000,1.000000,'C0000200' '0004','Latte','NR','00201',1.210000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,'04','','','','BARCODE','NR','NR','NR',1.000000,1.000000,1.000000,'' '0010','Yogurt','NR','00201',0.320000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,'10','','','','BARCODE','NR','NR','NR',1.000000,1.000000,1.000000,'' 'CASE2','Case Miditower','NR','00201',60.480000,50.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,'20','','','','BARCODE','KG','NR','NR',1.000000,1.000000,1.000000,'C0001600' 'CASE3','Case Tower','NR','00201',78.680000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,'20','','','','BARCODE','NR','NR','NR',1.000000,1.000000,1.000000,'C0001600' 'CAVO1','Cavo Alimentazione','NR','00301',0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,'20','','','','BARCODE','NR','NR','NR',1.000000,1.000000,1.000000,'C0001600' 'CAVO2','Cavo Parallelo','NR','00301',0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,'20','','','','BARCODE','NR','NR','NR',1.000000,1.000000,1.000000,'C0001600' 'CDROM','Lettore CD-Rom SCSI','NR','00202',68.850000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,'20','','','','BARCODE','NR','NR','NR',1.000000,1.000000,1.000000,'' 'CPUAMD1','CPU AMD Athlon XP 1600','NR','00203',196.310000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,'20','','','','BARCODE','NR','NR','NR',1.000000,1.000000,1.000000,'' 'CPUAMD2','CPU AMD Athlon XP 1700','NR','00203',199.230000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,'20','','','','BARCODE','NR','NR','NR',1.000000,1.000000,1.000000,'' 'CPUAMD3','CPU AMD Athlon XP 1800 - ART. CON LOTTO','NR','00203',241.180000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,'20','','','','BARCODE','NR','NR','NR',1.000000,1.000000,1.000000,'' 'CPUIN1','CPU Intel P4 1,5 Ghz','NR','00203',231.370000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,'20','','','','BARCODE','NR','NR','NR',1.000000,1.000000,1.000000,'' 'CPUIN2','CPU Intel P4 1,6 Ghz','NR','00203',245.670000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,'20','','','','BARCODE','NR','NR','NR',1.000000,1.000000,1.000000,'' 'CPUIN3','CPU Intel P4 1,7 Ghz','NR','00203',283.250000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,'20','','','','BARCODE','NR','NR','NR',1.000000,1.000000,1.000000,'' 'CPUIN4','CPU Intel P4 1,9 Ghz','NR','00203',372.990000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,'20','','','','BARCODE','NR','NR','NR',1.000000,1.000000,1.000000,'' 'CTIDE','Controller IDE','NR','00207',13.090000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,'20','','','','BARCODE','NR','NR','NR',1.000000,1.000000,1.000000,'' 'CTSCSI','Controller SCSI','NR','00207',64.210000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,'20','','','','BARCODE','NR','NR','NR',1.000000,1.000000,1.000000,'' 'FLOPPY','Floppy Disk Drive 3"1/2','NR','00204',14.150000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,'20','','','','BARCODE','NR','NR','NR',1.000000,1.000000,1.000000,'' 'HDIDE20','Hard Disk Ide 20 Gb','NR','00205',118.510000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,'20','','','','BARCODE','NR','NR','NR',1.000000,1.000000,1.000000,'C0001500' 'HDIDE40','Hard Disk Ide 40 Gb','NR','00205',134.050000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,'20','','','','BARCODE','NR','NR','NR',1.000000,1.000000,1.000000,'C0001500' 'HDIDE60','Hard Disk Ide 60 Gb','NR','00205',158.850000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,'20','','','','BARCODE','NR','NR','NR',1.000000,1.000000,1.000000,'C0001500' 'HDSCSI20','Hard Disk SCSI 20 Gb','NR','00205',289.090000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,'20','','','','BARCODE','NR','NR','NR',1.000000,1.000000,1.000000,'C0001500' 'HDSCSI40','Hard Disk SCSI 40 Gb','NR','00205',588.870000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,'20','','','','BARCODE','NR','NR','NR',1.000000,1.000000,1.000000,'' 'HDSCSI80','Hard Disk SCSI 80 Gb','NR','00205',1109.470000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,'20','','','','BARCODE','NR','NR','NR',1.000000,1.000000,1.000000,'' 'IMB1','Scatola Grande','NR','',1.350000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,'20','','','','BARCODE','NR','NR','NR',1.000000,1.000000,1.000000,'' 'IMB2','Nastro Adesivo','NR','',0.100000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,'20','','','','BARCODE','NR','NR','NR',1.000000,1.000000,1.000000,'' 'IMB3','Etichetta','NR','',0.300000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,'20','','','','BARCODE','NR','NR','NR',1.000000,1.000000,1.000000,'' 'IMBPC','Imballaggio Computer - FITTIZIO','NR','',0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,'20','','','','BARCODE','NR','NR','NR',1.000000,1.000000,1.000000,'' 'MAN1','Manodopera - Assemblaggio','MN','',0.150000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,'20','','','','BARCODE','PZ','PZ','PZ',1.000000,1.000000,1.000000,'' 'MAN2','Manodopera - Imballaggio','MN','',0.150000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,'20','','','','BARCODE','PZ','PZ','PZ',1.000000,1.000000,1.000000,'' 'MASTIDE1','Masterizzatore IDE 24x10x40x','NR','00301',132.290000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,'20','','','','BARCODE','NR','NR','NR',1.000000,1.000000,1.000000,'' 'MASTIDE2','Masterizzatore IDE 8x8x32x','NR','00301',119.960000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,'20','','','','BARCODE','NR','NR','NR',1.000000,1.000000,1.000000,'' 'MASTSCSI','Masterizzatore SCSI 12x10x32','NR','00301',137.420000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,'20','','','','BARCODE','NR','NR','NR',1.000000,1.000000,1.000000,'' 'MBASA7A','Main Board Asus A7A-266','NR','00206',206.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,'20','','','','BARCODE','NR','NR','NR',1.000000,1.000000,1.000000,'' 'MBECSP4','Main Board ECS x P4','NR','00206',175.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,'20','','','','BARCODE','NR','NR','NR',1.000000,1.000000,1.000000,'' 'MDESISDN','Modem esterno ISDN','NR','00103',67.940000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,'20','','','','BARCODE','NR','NR','NR',1.000000,1.000000,1.000000,'' 'MDESSTD','Modem esterno standard','NR','00103',49.720000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,'20','','','','BARCODE','NR','NR','NR',1.000000,1.000000,1.000000,'' 'MDINSISDN','Modem interno ISDN','NR','00103',33.910000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,'20','','','','BARCODE','NR','NR','NR',1.000000,1.000000,1.000000,'' 'MDINSTD','Modem interno standard','NR','00103',22.130000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,'20','','','','BARCODE','NR','NR','NR',1.000000,1.000000,1.000000,'' 'MOLG15','Monitor LG 15"','NR','00105',162.430000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,'20','','','','BARCODE','NR','NR','NR',1.000000,1.000000,1.000000,'' 'MOLG17','Monitor LG 17"','NR','00105',245.740000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,'20','','','','BARCODE','NR','NR','NR',1.000000,1.000000,1.000000,'' 'MOLG19','Monitor LG 19"','NR','00105',409.650000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,'20','','','','BARCODE','NR','NR','NR',1.000000,1.000000,1.000000,'' 'MOLG21','Monitor LG 21"','NR','00105',981.460000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,'20','','','','BARCODE','NR','NR','NR',1.000000,1.000000,1.000000,'' 'MOPH15','Monitor Philips 15"','NR','00105',186.080000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,'20','','','','BARCODE','NR','NR','NR',1.000000,1.000000,1.000000,'' 'MOPH17','Monitor Philips 17"','NR','00105',406.380000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,'20','','','','BARCODE','NR','NR','NR',1.000000,1.000000,1.000000,'' 'MOPH19','Monitor Philips 19"','NR','00105',588.040000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,'20','','','','BARCODE','NR','NR','NR',1.000000,1.000000,1.000000,'' 'MOSO15','Monitor Samsung 15"','NR','00105',205.660000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,'20','','','','BARCODE','NR','NR','NR',1.000000,1.000000,1.000000,'' 'MOSO17','Monitor Samsung 17"','NR','00105',317.720000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,'20','','','','BARCODE','NR','NR','NR',1.000000,1.000000,1.000000,'' 'MOSO19','Monitor Samsung 19"','NR','00105',559.040000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,'20','','','','BARCODE','NR','NR','NR',1.000000,1.000000,1.000000,'' 'MOSO21','Monitor Samsung 21"','NR','00105',958.600000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,'20','','','','BARCODE','NR','NR','NR',1.000000,1.000000,1.000000,'' 'PTIJEPSTC80','Stampante Epson Stylus Color C80','NR','00104',252.360000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,'20','','','','BARCODE','NR','NR','NR',1.000000,1.000000,1.000000,'' 'PTIJHP960C','Stampante HP 960C DeskJet','NR','00104',217.860000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,'20','','','','BARCODE','NR','NR','NR',1.000000,1.000000,1.000000,'' 'PTIJLXZ12','Stampante Lexmark Z12','NR','00104',53.540000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,'20','','','','BARCODE','NR','NR','NR',1.000000,1.000000,1.000000,'' 'PTLSEP5900L','Stampante Epson EPL 5900L','NR','00104',328.190000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,'20','','','','BARCODE','NR','NR','NR',1.000000,1.000000,1.000000,'' 'PTLSHP1200','Stampante HP LaserJet 1200','NR','00104',808.350000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,'20','','','','BARCODE','NR','NR','NR',1.000000,1.000000,1.000000,'' 'PTLSLXT614','Stampante Lexmark Optra T614','NR','00104',1422.420000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,'20','','','','BARCODE','NR','NR','NR',1.000000,1.000000,1.000000,'' 'SASB41','Scheda audio Creative S.Blaster 41','NR','00207',51.740000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,'20','','','','BARCODE','NR','NR','NR',1.000000,1.000000,1.000000,'' 'SKMEM128','Scheda memoria 128 Mb','NR','00207',64.910000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,'20','','','','BARCODE','NR','NR','NR',1.000000,1.000000,1.000000,'' 'SKMEM256','Scheda memoria 256 Mb','NR','00207',124.430000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,'20','','','','BARCODE','NR','NR','NR',1.000000,1.000000,1.000000,'' 'SKMEM64','Scheda memoria 64 Mb','NR','00207',27.930000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,'20','','','','BARCODE','NR','NR','NR',1.000000,1.000000,1.000000,'' 'SKPAR','Scheda Parallela','NR','00207',10.940000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,'20','','','','BARCODE','NR','NR','NR',1.000000,1.000000,1.000000,'' 'SVASV7700','Scheda Video Asus 64 Mb','NR','00207',100.990000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,'20','','','','BARCODE','NR','NR','NR',1.000000,1.000000,1.000000,'' 'SVATRA64','Scheda video SVA ATI Radeon 64 Mb','NR','00207',76.580000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,'20','','','','BARCODE','NR','NR','NR',1.000000,1.000000,1.000000,'' 'SVMTG400','Scheda video SVGA Matrox G400 32Mb','NR','00207',115.030000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,'20','','','','BARCODE','NR','NR','NR',1.000000,1.000000,1.000000,'' 'SVMTG450','Scheda video SVGA Matrox G450 32Mb','NR','00207',183.360000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,'20','','','','BARCODE','NR','NR','NR',1.000000,1.000000,1.000000,'' 'SWW2000P','Windows2000 Professional OEM','NR','00401',252.710000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,'20','','','','BARCODE','NR','NR','NR',1.000000,1.000000,1.000000,'' 'SWWXPH','Windows Xp - Home','NR','00401',0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,'20','','','','BARCODE','NR','NR','NR',1.000000,1.000000,1.000000,'' 'SWWXPP','Windows Xp - Professional','NR','00401',465.670000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,'20','','','','BARCODE','NR','NR','NR',1.000000,1.000000,1.000000,'' 'TAST1','Tastiera Italiana','NR','00102',7.810000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,'20','','','','BARCODE','NR','NR','NR',1.000000,1.000000,1.000000,'' 'TAST2','Tastiera americana','NR','00102',9.120000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,'20','','','','BARCODE','NR','NR','NR',1.000000,1.000000,1.000000,'' 'TAST3','Tastiera wireless','NR','00102',34.390000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,'20','','','','BARCODE','NR','NR','NR',1.000000,1.000000,1.000000,'' 'KITMM','Kit Multimediale - FANTASMA','NR','',0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,'20','','','','BARCODE','nr','nr','nr',1.000000,1.000000,1.000000,'' 'CASSE','Casse multimediali','NR','00301',13.710000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,'20','','','','BARCODE','nr','nr','nr',1.000000,1.000000,1.000000,'' 'PCDESKP4','PC Desk Pentium4 (con fasi e CDC)','NR','',699.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,'20','','','','BARCODE','NR','NR','NR',1.000000,1.000000,1.000000,'' 'PCMIDIP4','PC MidiTower Pentium4','NR','',943.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,'20','','','','BARCODE','NR','NR','NR',1.000000,1.000000,1.000000,'' 'PCTOWIP4','PC Tower Pentium4','NR','',143.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,'20','','','','BARCODE','NR','NR','NR',1.000000,1.000000,1.000000,'' 'PCFULL1','Pc Completo desk - P4 - Mon.17"','NR','',705.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,'20','','','','BARCODE','NR','NR','NR',1.000000,1.000000,1.000000,'' 'MSPS2','Mouse PS/2','NR','00101',6.110000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,'20','','','','BARCODE','NR','NR','NR',1.000000,1.000000,1.000000,'' 'MSUSB','Mouse 3 tasti USB','NR','00101',5.410000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,'20','','','','BARCODE','NR','NR','NR',1.000000,1.000000,1.000000,'' 'MSWIR','Mouse Wireless','NR','00101',20.380000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,'20','','','','BARCODE','NR','NR','NR',1.000000,1.000000,1.000000,'' 'PCFULL2','Pc Completo Miditower - P4 - Mon.17"','NR','',949.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,'20','','','','BARCODE','NR','NR','NR',1.000000,1.000000,1.000000,'' 'PCFULL3','Pc Completo Tower - P4 - Mon. 21"','NR','',143.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,'20','','','','BARCODE','NR','NR','NR',1.000000,1.000000,1.000000,'' 'Z-INFERRIATA','Inferriata - D.B. con U.M. secondarie','MT','',0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,-1,'20','','','','BARCODE','MT','MT','MT',1.000000,1.000000,1.000000,'' 'Z-INFZINC','Inferriata zincata','MT','',0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,-1,'20','','','','BARCODE','MT','MT','MT',1.000000,1.000000,1.000000,'' 'Z-INFGREZZA','Inferriata grezza','MT','',0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,-1,'20','','','','BARCODE','MT','MT','MT',1.000000,1.000000,1.000000,'' 'Z-VERNICIATURA','Verniciatura','MT','',0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,-2,'20','','','','BARCODE','MT','MT','MT',1.000000,1.000000,1.000000,'' 'Z-ZINCATURA','Zincatura','KG','',0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,-2,'20','','','','BARCODE','MT','KG','KG',0.650000,1.000000,1.000000,'' 'Z-FERRO','Ferro','MT','',0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,-3,'20','','','','BARCODE','KG','VG','MT',1.538400,6.320000,1.000000,'' 'Z-BULLONI','Bulloni','NR','',0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,0.000000,-3,'20','','','','BARCODE','KG','NR','NR',450.000000,1.000000,1.000000,'C0000300'
<?xml version="1.0" encoding="utf-8"?>
<TABELLA_MAGART xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema"?>
<MAGART>
<CODICE />
<Variante1 />
<Variante2 />
<Descrizione />
<UnitaMisura>NR</UnitaMisura>
<GruppoMagazzino />
<Listino1>0</Listino1>
<Listino2>0</Listino2>
<Listino3>0</Listino3>
<Listino4>0</Listino4>
<Listino5>0</Listino5>
<Listino6>0</Listino6>
<Listino7>0</Listino7>
<Listino8>0</Listino8>
<Listino9>0</Listino9>
<CodiceIVA />
<Sconto1 />
<Sconto2 />
<Sconto3 />
<Barcode />
<UnitaMisura1>NR</UnitaMisura1>
<UnitaMisura2>NR</UnitaMisura2>
<UnitaMisura3>NR</UnitaMisura3>
<Fattore1>1</Fattore1>
<Fattore2>1</Fattore2>
<Fattore3>1</Fattore3>
<CodiceCessionario />
<Pt1AR_LIST />
<Pt2AR_LIST />
<Pt3AR_LIST />
<Pt4AR_LIST />
<Pt5AR_LIST />
<Pt6AR_LIST />
<Pt7AR_LIST />
<FlagOmagiabile />
<TipoOmaggio />
<Quadratura>0</Quadratura>
<NoPezzoZero>0</NoPezzoZero>
<GestioneLotti>0</GestioneLotti>
<GestioneVariante1>0</GestioneVariante1>
<GestioneVariante2>0</GestioneVariante2>
<CodiceMacchinario />
<Pag3060>0</Pag3060>
<DescrGruppo1 />
<DescrGruppo2 />
<Classe />
<Peso>0</Peso>
<StampaNotePiede>0</StampaNotePiede>
<uid_fatture_cloud />
<ShelfLife>0</ShelfLife>
<TipoArticolo />
<Modello />
<GestioneMacchinario>0</GestioneMacchinario>
<ArticoloNonVendibile>0</ArticoloNonVendibile>
</MAGART>
</TABELLA_MAGART>
public partial class MAGART { [Indexed(Name = "IX_PK_MAGART", Order = 1, Unique = true), MaxLengthAttribute(25)] public string CODICE { get; set; } [Indexed(Name = "IX_PK_MAGART", Order = 2, Unique = true), MaxLengthAttribute(20)] public string Variante1 { get; set; } [Indexed(Name = "IX_PK_MAGART", Order = 3, Unique = true), MaxLengthAttribute(20)] public string Variante2 { get; set; } [MaxLengthAttribute(100)] public string Descrizione { get; set; } [MaxLengthAttribute(3)] public string UnitaMisura { get; set; } [MaxLengthAttribute(10)] public string GruppoMagazzino{ get; set; } public decimal Listino1 { get; set; } public decimal Listino2 { get; set; } public decimal Listino3 { get; set; } public decimal Listino4 { get; set; } public decimal Listino5 { get; set; } public decimal Listino6 { get; set; } public decimal Listino7 { get; set; } public decimal Listino8 { get; set; } public decimal Listino9 { get; set; } [MaxLengthAttribute(4)] public string CodiceIVA { get; set; } [MaxLengthAttribute(20)] public string Sconto1 { get; set; } [MaxLengthAttribute(20)] public string Sconto2 { get; set; } [MaxLengthAttribute(20)] public string Sconto3 { get; set; } [MaxLengthAttribute(20)] public string Barcode { get; set; } [MaxLengthAttribute(3)] public string UnitaMisura1 { get; set; } [MaxLengthAttribute(3)] public string UnitaMisura2 { get; set; } [MaxLengthAttribute(3)] public string UnitaMisura3 { get; set; } public decimal Fattore1 { get; set; } public decimal Fattore2 { get; set; } public decimal Fattore3 { get; set; } [MaxLengthAttribute(8)] public string CodiceCessionario { get; set; } [MaxLengthAttribute(20)] public string Pt1AR_LIST { get; set; } [MaxLengthAttribute(20)] public string Pt2AR_LIST { get; set; } [MaxLengthAttribute(20)] public string Pt3AR_LIST { get; set; } [MaxLengthAttribute(20)] public string Pt4AR_LIST { get; set; } [MaxLengthAttribute(20)] public string Pt5AR_LIST { get; set; } [MaxLengthAttribute(20)] public string Pt6AR_LIST { get; set; } [MaxLengthAttribute(20)] public string Pt7AR_LIST { get; set; } [MaxLengthAttribute(1)] public string FlagOmagiabile { get; set; } [MaxLengthAttribute(2)] public string TipoOmaggio { get; set; } public decimal Quadratura { get; set; } public int NoPezzoZero { get; set; } public int GestioneLotti { get; set; } public int GestioneVariante1 { get; set; } public int GestioneVariante2 { get; set; } [MaxLengthAttribute(20)] public string CodiceMacchinario { get; set; } public int Pag3060 { get; set; } [MaxLengthAttribute(20)] public string DescrGruppo1 { get; set; } [MaxLengthAttribute(20)] public string DescrGruppo2 { get; set; } [MaxLengthAttribute(20)] public string Classe { get; set; } public decimal Peso { get; set; } public int StampaNotePiede { get; set; } [MaxLengthAttribute(50)] public string uid_fatture_cloud { get; set; } public int ShelfLife { get; set; } [MaxLengthAttribute(5)] public string TipoArticolo { get; set; } [MaxLengthAttribute(50)] public string Modello { get; set; } public int GestioneMacchinario { get; set; } public int ArticoloNonVendibile { get; set; } }