SCADENZE | Help Linea Computers SRL

Definisce le partite aperte di un cliente.

Questo archivio può essere movimentato anche dal sistema quando un documento genera esposizione e quindi genera una partita aperta. Le scadenze generate dal sistema vengono identificate da un id negativo.

#	COLONNA	DECRIZIONE	TIPO	LEN
1	ID	Indentificativo univoco della scadenze	Intero
2	DataDocumento	Data Documento	Data
3	NumeroDocumento	Numero Documento	Stringa	20
4	DataScadenza	Data Scadenza	Data
5	CodiceCliente	Codice Cliente	Stringa	8
6	ImportoScadenza	Importo residuo scadenze	Decimale
7	ImportoFattura	Importo totale del documento che ha generato la scadenza	Decimale
8	CodiceDocumento	Codice Documento	Stringa	20

Esempio

12345678,'12/27/2000','2','12/27/2000','C0000200',15.0000,0.0000,'FT'
3,'12/27/2000','3','12/27/2000','C0000400',8.0000,0.0000,'FT'
13,'02/27/2001','4','02/27/2001','C0001400',12.0000,12.0000,'FT'
15,'02/27/2001','5','02/27/2001','C0001400',24.0000,24.0000,'FT'
17,'02/27/2001','6','03/27/2001','C0000100',20.0000,60.0000,'FT'
18,'02/27/2001','6','04/27/2001','C0000100',20.0000,60.0000,'FT'
19,'02/27/2001','6','05/27/2001','C0000100',20.0000,60.0000,'FT'
24,'02/27/2001','2','03/27/2001','C0000100',85.0000,25500.0000,'FT'
25,'02/27/2001','2','04/27/2001','C0000100',85.0000,25500.0000,'FT'
26,'02/27/2001','2','05/27/2001','C0000100',85.0000,25500.0000,'FT'
28,'03/27/2001','8','05/27/2001','C0000500',24.0000,24000.0000,'FT'
32,'02/27/2001','9','03/27/2001','C0000100',281.0000,0.0000,'FT'
33,'02/27/2001','9','04/27/2001','C0000100',281.0000,0.0000,'FT'
34,'02/27/2001','9','05/27/2001','C0000100',281.0000,0.0000,'FT'
35,'11/27/2001','9','12/27/2001','C0000500',387.0000,7740.0000,'FT'
36,'10/27/2001','9','01/27/2002','C0000500',38.80000,7740.0000,'FT'
37,'10/27/2001','10','01/27/2002','C0000400',420.0000,420.0000,'FT'
39,'11/27/2001','11','12/27/2001','C0000200',35.5400,3581.5400,'FT'
40,'11/27/2001','12','12/27/2001','C0001000',19.9500,5822.8400,'FT'
41,'11/27/2001','12','01/27/2002','C0001000',19.9500,5822.8400,'FT'
42,'11/27/2001','12','02/27/2002','C0001000',19.9400,5822.8400,'FT'
53,'12/27/2001','13','01/27/2002','C0000100',80.0000,24000.0000,'FT'
54,'12/27/2001','13','02/27/2002','C0000100',8.0000,24000.0000,'FT'
55,'12/27/2001','13','03/27/2002','C0000100',8.0000,24000.0000,'FT'
56,'12/27/2001','14','01/27/2002','C0000300',1.7000,12000.0000,'FT'
67,'01/27/2002','2','01/27/2002','C0000300',16.3600,1604.3600,'FT'
69,'01/27/2002','5','01/27/2002','C0001300',28.1900,2853.1900,'FT'
70,'01/27/2002','4','02/27/2002','C0000900',84.0000,8400.0000,'FT'
71,'09/27/2002','6','10/27/2002','C0000100',12.2300,3777.6800,'FA'
72,'09/27/2002','6','11/27/2002','C0000100',12.2300,3777.6800,'FA'
73,'09/27/2002','6','12/27/2002','C0000100',12.2200,3777.6800,'FT'
79,'01/27/2002','3','03/27/2002','C0000600',39.6100,3910.6100,'FT'
81,'11/27/2002','9','02/27/2003','C0000400',5.0000,500.0000,'FT'



<?xml version="1.0" encoding="utf-8"?>

<TABELLA_SCADENZE xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema"?>

  <SCADENZE>

    <ID>0</ID>

    <DataDocumento>0001-01-01T00:00:00</DataDocumento>

    <NumeroDocumento />

    <DataScadenza>0001-01-01T00:00:00</DataScadenza>

    <CodiceCliente />

    <ImportoScadenza>0</ImportoScadenza>

    <ImportoFattura>0</ImportoFattura>

    <CodiceDocumento />

  </SCADENZE>

</TABELLA_SCADENZE>

    public partial class SCADENZE
    {
        [PrimaryKey]
        public decimal ID { get; set; }


        public System.DateTime DataDocumento { get; set; }


        [MaxLengthAttribute(20)]
        public string NumeroDocumento { get; set; }


        public System.DateTime DataScadenza { get; set; }


        [MaxLengthAttribute(8)]
        public string CodiceCliente { get; set; }


        public decimal ImportoScadenza { get; set; }
        public decimal ImportoFattura { get; set; }


        [MaxLengthAttribute(20)]
        public string CodiceDocumento { get; set; }
   
    }

Documentazione Zippy Infinity