CANVASELEMENTO

Definisce gli elementi di un CANVAS.

#COLONNADECRIZIONETIPOLENNOTE
1CODICECodice CanvasStringa20
2GruppoCodice Gruppo CanvasStringa20
3CodiceArticoloCodice ArticoloStringa25
4RigaCanvasNumero riga canvas (chiave)Stringa20
5CausaleCausale di VenditaStringa2V,O,Oo ( Vendita o Omaggio)
6PrezzoUnitarioPrezzo Unitario articoloDecimale
7ScontoSconto articoloDecimale
8QuantitaQuantità articolo per ogni elemento selezionatoDecimale
9FissoFlag 1 o 0 che indica se l'elemento è fisso all'interno del canvasInteroFlag 1 o 0
10UnivocoFlag 1 o 0 che indica se questo elemento può esserci una volta sola all'interno del canvasInteroFlag 1 o 0
11Variante1Variante 1Stringa20
12Variante2Variante 2Stringa20

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; }

    }


Documentazione Zippy Infinity