Definisce gli elementi di un CANVAS.
NOTE
Per maggiori informazioni sui CANVAS consultare la sezione tecnica dedicata in dettaglio.
Per maggiori informazioni sui CANVAS consultare la sezione tecnica dedicata in dettaglio.
# | COLONNA | DECRIZIONE | TIPO | LEN | NOTE |
---|---|---|---|---|---|
1 | CODICE | Codice Canvas | Stringa | 20 | |
2 | Gruppo | Codice Gruppo Canvas | Stringa | 20 | |
3 | CodiceArticolo | Codice Articolo | Stringa | 25 | |
4 | RigaCanvas | Numero riga canvas (chiave) | Stringa | 20 | |
5 | Causale | Causale di Vendita | Stringa | 2 | V,O,Oo ( Vendita o Omaggio) |
6 | PrezzoUnitario | Prezzo Unitario articolo | Decimale | ||
7 | Sconto | Sconto articolo | Decimale | ||
8 | Quantita | Quantità articolo per ogni elemento selezionato | Decimale | ||
9 | Fisso | Flag 1 o 0 che indica se l'elemento è fisso all'interno del canvas | Intero | Flag 1 o 0 | |
10 | Univoco | Flag 1 o 0 che indica se questo elemento può esserci una volta sola all'interno del canvas | Intero | Flag 1 o 0 | |
11 | Variante1 | Variante 1 | Stringa | 20 | |
12 | Variante2 | Variante 2 | Stringa | 20 |
Esempio
'CANVAS_001','MONITOR','MOLG15',1,'V',50,0,1,0,0,'','' 'CANVAS_001','MONITOR','MOLG17',2,'V',60,0,1,0,0,'','' 'CANVAS_001','MONITOR','MOLG19',3,'V',70,0,1,0,0,'','' 'CANVAS_001','MONITOR','MOLG21',4,'V',80,0,1,0,0,'','' 'CANVAS_001','MONITOR','MOPH15',5,'V',90,0,1,0,0,'','' 'CANVAS_001','OMAGGI','FLOPPY',1,'O',10,0,1,0,0,'','' 'CANVAS_001','OMAGGI','HDIDE20',2,'O',20,0,1,0,0,'','' 'CANVAS_001','OMAGGI','HDIDE40',3,'O',30,0,1,0,0,'','' 'CANVAS_002','ELEMENTI COMPUTER','MOLG15',1,'V',50,0,1,1,1,'','' 'CANVAS_002','ELEMENTI COMPUTER','HDSCSI20',2,'V',60,0,1,1,1,'','' 'CANVAS_002','ELEMENTI COMPUTER','PTIJHP960C',3,'V',70,0,1,1,1,'','' 'CANVAS_002','ELEMENTI COMPUTER','TAST2',4,'V',20,0,1,1,1,'','' 'CANVAS_002','ELEMENTI COMPUTER','MBASA7A',5,'V',80,0,1,1,1,'','' 'CANVAS_003','ELEMENTI COMPUTER','HDSCSI20',1,'V',60,0,1,1,1,'','' 'CANVAS_003','ELEMENTI COMPUTER','PTIJHP960C',2,'V',30,0,1,1,1,'','' 'CANVAS_003','ELEMENTI COMPUTER','TAST2',3,'V',20,0,1,1,1,'','' 'CANVAS_003','ELEMENTI COMPUTER','MBASA7A',4,'V',80,0,1,1,1,'','' 'CANVAS_003','MONITOR','MOLG15',1,'V',50,0,1,0,0,'','' 'CANVAS_003','MONITOR','MOLG17',2,'V',60,0,1,0,0,'','' 'CANVAS_003','MONITOR','MOLG19',3,'V',70,0,1,0,0,'','' 'CANVAS_003','MONITOR','MOLG21',4,'V',80,0,1,0,0,'','' 'CANVAS_003','MONITOR','MOPH15',5,'V',90,0,1,0,0,'','' 'CANVAS_004','COMPOSIZIONE','PTIJHP960C',1,'V',30,0,1,1,1,'','' 'CANVAS_004','COMPOSIZIONE','MOLG15',2,'V',50,0,1,0,0,'','' 'CANVAS_004','COMPOSIZIONE','MOLG17',3,'V',60,0,1,0,0,'','' 'CANVAS_004','COMPOSIZIONE','MOLG19',4,'V',70,0,1,0,0,'','' 'CANVAS_004','COMPOSIZIONE','MOLG21',5,'V',80,0,1,0,0,'','' 'CANVAS_004','COMPOSIZIONE','MOPH15',6,'V',90,0,1,0,0,'','' 'CANVAS_004','COMPOSIZIONE','FLOPPY',7,'V',10,0,1,0,0,'','' 'CANVAS_004','COMPOSIZIONE','HDIDE20',8,'V',20,0,1,0,0,'','' 'CANVAS_004','COMPOSIZIONE','HDIDE40',9,'V',30,0,1,0,0,'','' 'CANVAS_004','COMPOSIZIONE','TAST2',10,'V',20,0,1,0,0,'','' 'CANVAS_005','STAMPANTI','PTIJHP960C',1,'V',120,0,2,0,0,'','' 'CANVAS_005','STAMPANTI','PTIJEPSTC80',2,'V',213,0,1,0,0,'','' 'CANVAS_005','STAMPANTI','PTIJLXZ12',3,'V',45,0,2,0,0,'','' 'CANVAS_005','STAMPANTI','PTLSEP5900L',4,'V',55,0,1,0,0,'',''
<?xml version="1.0" encoding="utf-8"?>
<TABELLA_CANVASELEMENTO xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema"?>
<CANVASELEMENTO>
<CodiceCanvas />
<Gruppo />
<RigaCanvas />
<CodiceArticolo />
<Causale />
<PrezzoUnitario>0</PrezzoUnitario>
<Sconto>0</Sconto>
<Quantita>0</Quantita>
<Fisso>0</Fisso>
<Univoco>0</Univoco>
<Variante1 />
<Variante2 />
</CANVASELEMENTO>
</TABELLA_CANVASELEMENTO>
public partial class CANVASELEMENTO { [Indexed(Name = "IX_PK_CANVASELEMENTO", Order = 1, Unique = true), MaxLengthAttribute(20)] public string CodiceCanvas { get; set; } [Indexed(Name = "IX_PK_CANVASELEMENTO", Order = 2, Unique = true), MaxLengthAttribute(20)] public string Gruppo { get; set; } [Indexed(Name = "IX_PK_CANVASELEMENTO", Order = 3, Unique = true), MaxLengthAttribute(20)] public string RigaCanvas { get; set; } [MaxLengthAttribute(25)] public string CodiceArticolo { get; set; } [MaxLengthAttribute(2)] public string Causale { get; set; } public decimal PrezzoUnitario { get; set; } public decimal Sconto { get; set; } public decimal Quantita { get; set; } public int Fisso { get; set; } public int Univoco { get; set; } [MaxLengthAttribute(20)] public string Variante1 { get; set; } [MaxLengthAttribute(20)] public string Variante2 { get; set; } }