Samuele E. Locatelli
1153 lines
71 KiB
XML
1153 lines
71 KiB
XML
<?xml version="1.0" encoding="utf-8"?>
|
|
<edmx:Edmx Version="3.0" xmlns:edmx="http://schemas.microsoft.com/ado/2009/11/edmx">
|
|
<!-- EF Runtime content -->
|
|
<edmx:Runtime>
|
|
<!-- SSDL content -->
|
|
<edmx:StorageModels>
|
|
<Schema Namespace="MAPModel.Store" Provider="System.Data.SqlClient" ProviderManifestToken="2012" Alias="Self" xmlns:store="http://schemas.microsoft.com/ado/2007/12/edm/EntityStoreSchemaGenerator" xmlns:customannotation="http://schemas.microsoft.com/ado/2013/11/edm/customannotation" xmlns="http://schemas.microsoft.com/ado/2009/11/edm/ssdl">
|
|
<EntityType Name="C_iva">
|
|
<Key>
|
|
<PropertyRef Name="C_iva" />
|
|
</Key>
|
|
<Property Name="C_iva" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
|
|
<Property Name="iva" Type="float" Nullable="false" />
|
|
<Property Name="descrizione" Type="nvarchar" MaxLength="250" Nullable="false" />
|
|
<Property Name="enabled" Type="bit" Nullable="false" />
|
|
<Property Name="splitPay" Type="bit" Nullable="false" />
|
|
</EntityType>
|
|
<EntityType Name="Clienti">
|
|
<Key>
|
|
<PropertyRef Name="idxCli" />
|
|
</Key>
|
|
<Property Name="idxCli" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
|
|
<Property Name="RagSoc" Type="nvarchar" MaxLength="50" Nullable="false" />
|
|
<Property Name="Sesso" Type="char" MaxLength="1" Nullable="false" />
|
|
<Property Name="POBirth" Type="nvarchar" MaxLength="250" Nullable="false" />
|
|
<Property Name="DOBirth" Type="datetime" Nullable="false" />
|
|
<Property Name="P_iva" Type="nvarchar" MaxLength="50" Nullable="false" />
|
|
<Property Name="C_Fisc" Type="nvarchar" MaxLength="50" Nullable="false" />
|
|
<Property Name="Via" Type="nvarchar" MaxLength="250" Nullable="false" />
|
|
<Property Name="Località" Type="nvarchar" MaxLength="50" Nullable="false" />
|
|
<Property Name="Cap" Type="nvarchar" MaxLength="5" Nullable="false" />
|
|
<Property Name="Provincia" Type="nvarchar" MaxLength="2" Nullable="false" />
|
|
<Property Name="Pagamento" Type="nvarchar" MaxLength="250" Nullable="false" />
|
|
<Property Name="email" Type="nvarchar" MaxLength="50" Nullable="false" />
|
|
<Property Name="tel" Type="nvarchar" MaxLength="50" Nullable="false" />
|
|
<Property Name="Note" Type="ntext" Nullable="false" />
|
|
<Property Name="idxGruppo" Type="nvarchar" MaxLength="50" Nullable="false" />
|
|
</EntityType>
|
|
<EntityType Name="KVPlist">
|
|
<Key>
|
|
<PropertyRef Name="strKey" />
|
|
</Key>
|
|
<Property Name="strKey" Type="nvarchar" MaxLength="50" Nullable="false" />
|
|
<Property Name="strVal" Type="nvarchar" MaxLength="50" Nullable="false" />
|
|
</EntityType>
|
|
<!--Errori trovati durante la generazione:
|
|
avviso 6002: Nessuna chiave primaria definita per la tabella/visualizzazione 'MedAP.dbo.v_docRowsExpl'. La chiave è stata dedotta e la definizione è stata creata come tabella/visualizzazione di sola lettura.-->
|
|
<EntityType Name="v_docRowsExpl">
|
|
<Key>
|
|
<PropertyRef Name="IdxRigheFatt" />
|
|
</Key>
|
|
<Property Name="IdxRigheFatt" Type="int" Nullable="false" />
|
|
<Property Name="IdxFatt" Type="int" />
|
|
<Property Name="idxDoc" Type="int" />
|
|
<Property Name="Descrizione" Type="ntext" />
|
|
<Property Name="um" Type="nvarchar" MaxLength="50" />
|
|
<Property Name="prezzoUm" Type="money" />
|
|
<Property Name="qta" Type="int" />
|
|
<Property Name="sconto" Type="real" />
|
|
<Property Name="c_iva" Type="int" />
|
|
<Property Name="no_ritenuta" Type="bit" />
|
|
<Property Name="iva" Type="float" />
|
|
<Property Name="netto" Type="decimal" Precision="9" Scale="2" />
|
|
<Property Name="quotaIva" Type="decimal" Precision="9" Scale="2" />
|
|
<Property Name="importo" Type="decimal" Precision="9" Scale="2" />
|
|
</EntityType>
|
|
<!--Errori trovati durante la generazione:
|
|
avviso 6002: Nessuna chiave primaria definita per la tabella/visualizzazione 'MedAP.dbo.v_docsExpl'. La chiave è stata dedotta e la definizione è stata creata come tabella/visualizzazione di sola lettura.-->
|
|
<EntityType Name="v_docsExpl">
|
|
<Key>
|
|
<PropertyRef Name="idxDoc" />
|
|
<PropertyRef Name="Gruppo" />
|
|
<PropertyRef Name="RagSoc" />
|
|
<PropertyRef Name="indirizzo" />
|
|
<PropertyRef Name="localita" />
|
|
<PropertyRef Name="Cap" />
|
|
<PropertyRef Name="prov" />
|
|
<PropertyRef Name="CF" />
|
|
<PropertyRef Name="pIva" />
|
|
<PropertyRef Name="num" />
|
|
<PropertyRef Name="anno" />
|
|
<PropertyRef Name="netto" />
|
|
<PropertyRef Name="iva" />
|
|
<PropertyRef Name="importo" />
|
|
<PropertyRef Name="tipo" />
|
|
<PropertyRef Name="idxCli" />
|
|
<PropertyRef Name="totPagato" />
|
|
<PropertyRef Name="totScadenze" />
|
|
<PropertyRef Name="Descrizione" />
|
|
<PropertyRef Name="ritenuta" />
|
|
<PropertyRef Name="CostiAss" />
|
|
<PropertyRef Name="Pagamento" />
|
|
<PropertyRef Name="Note" />
|
|
</Key>
|
|
<Property Name="idxDoc" Type="int" Nullable="false" />
|
|
<Property Name="emesso" Type="date" />
|
|
<Property Name="Gruppo" Type="nvarchar" MaxLength="50" Nullable="false" />
|
|
<Property Name="RagSoc" Type="nvarchar" MaxLength="50" Nullable="false" />
|
|
<Property Name="indirizzo" Type="nvarchar" MaxLength="250" Nullable="false" />
|
|
<Property Name="localita" Type="nvarchar" MaxLength="50" Nullable="false" />
|
|
<Property Name="Cap" Type="nvarchar" MaxLength="5" Nullable="false" />
|
|
<Property Name="prov" Type="nvarchar" MaxLength="2" Nullable="false" />
|
|
<Property Name="CF" Type="nvarchar" MaxLength="50" Nullable="false" />
|
|
<Property Name="pIva" Type="nvarchar" MaxLength="50" Nullable="false" />
|
|
<Property Name="num" Type="int" Nullable="false" />
|
|
<Property Name="anno" Type="int" Nullable="false" />
|
|
<Property Name="Trim" Type="int" />
|
|
<Property Name="Mese" Type="int" />
|
|
<Property Name="netto" Type="decimal" Precision="9" Scale="2" Nullable="false" />
|
|
<Property Name="iva" Type="decimal" Precision="9" Scale="2" Nullable="false" />
|
|
<Property Name="importo" Type="decimal" Precision="9" Scale="2" Nullable="false" />
|
|
<Property Name="tipo" Type="nvarchar" MaxLength="50" Nullable="false" />
|
|
<Property Name="idxCli" Type="int" Nullable="false" />
|
|
<Property Name="totPagato" Type="money" Nullable="false" />
|
|
<Property Name="totScadenze" Type="money" Nullable="false" />
|
|
<Property Name="Descrizione" Type="nvarchar(max)" Nullable="false" />
|
|
<Property Name="ritenuta" Type="float" Nullable="false" />
|
|
<Property Name="CostiAss" Type="money" Nullable="false" />
|
|
<Property Name="Pagamento" Type="nvarchar" MaxLength="250" Nullable="false" />
|
|
<Property Name="Note" Type="ntext" Nullable="false" />
|
|
</EntityType>
|
|
<!--Errori trovati durante la generazione:
|
|
avviso 6002: Nessuna chiave primaria definita per la tabella/visualizzazione 'MedAP.dbo.v_DocTemplate'. La chiave è stata dedotta e la definizione è stata creata come tabella/visualizzazione di sola lettura.-->
|
|
<EntityType Name="v_DocTemplate">
|
|
<Key>
|
|
<PropertyRef Name="idxDoc" />
|
|
<PropertyRef Name="Gruppo" />
|
|
<PropertyRef Name="RagSoc" />
|
|
<PropertyRef Name="num" />
|
|
<PropertyRef Name="anno" />
|
|
<PropertyRef Name="netto" />
|
|
<PropertyRef Name="iva" />
|
|
<PropertyRef Name="importo" />
|
|
<PropertyRef Name="tipo" />
|
|
<PropertyRef Name="idxCli" />
|
|
<PropertyRef Name="totPagato" />
|
|
<PropertyRef Name="totScadenze" />
|
|
<PropertyRef Name="Descrizione" />
|
|
<PropertyRef Name="ritenuta" />
|
|
<PropertyRef Name="CostiAss" />
|
|
</Key>
|
|
<Property Name="idxDoc" Type="int" Nullable="false" />
|
|
<Property Name="emesso" Type="date" />
|
|
<Property Name="Gruppo" Type="nvarchar" MaxLength="50" Nullable="false" />
|
|
<Property Name="RagSoc" Type="nvarchar" MaxLength="50" Nullable="false" />
|
|
<Property Name="num" Type="int" Nullable="false" />
|
|
<Property Name="anno" Type="int" Nullable="false" />
|
|
<Property Name="Trim" Type="int" />
|
|
<Property Name="Mese" Type="int" />
|
|
<Property Name="netto" Type="decimal" Precision="9" Scale="2" Nullable="false" />
|
|
<Property Name="iva" Type="decimal" Precision="9" Scale="2" Nullable="false" />
|
|
<Property Name="importo" Type="decimal" Precision="9" Scale="2" Nullable="false" />
|
|
<Property Name="tipo" Type="nvarchar" MaxLength="50" Nullable="false" />
|
|
<Property Name="idxCli" Type="int" Nullable="false" />
|
|
<Property Name="totPagato" Type="money" Nullable="false" />
|
|
<Property Name="totScadenze" Type="money" Nullable="false" />
|
|
<Property Name="Descrizione" Type="nvarchar(max)" Nullable="false" />
|
|
<Property Name="ritenuta" Type="float" Nullable="false" />
|
|
<Property Name="CostiAss" Type="money" Nullable="false" />
|
|
</EntityType>
|
|
<!--Errori trovati durante la generazione:
|
|
avviso 6002: Nessuna chiave primaria definita per la tabella/visualizzazione 'MedAP.dbo.v_resGiorn'. La chiave è stata dedotta e la definizione è stata creata come tabella/visualizzazione di sola lettura.-->
|
|
<EntityType Name="v_resGiorn">
|
|
<Key>
|
|
<PropertyRef Name="anno" />
|
|
<PropertyRef Name="mese" />
|
|
<PropertyRef Name="giorno" />
|
|
</Key>
|
|
<Property Name="anno" Type="int" Nullable="false" />
|
|
<Property Name="mese" Type="int" Nullable="false" />
|
|
<Property Name="giorno" Type="datetime" Nullable="false" />
|
|
<Property Name="numDoc" Type="int" />
|
|
<Property Name="totNetto" Type="decimal" Precision="38" Scale="2" />
|
|
<Property Name="totIva" Type="decimal" Precision="38" Scale="2" />
|
|
<Property Name="totImporto" Type="decimal" Precision="38" Scale="2" />
|
|
</EntityType>
|
|
<!--Errori trovati durante la generazione:
|
|
avviso 6002: Nessuna chiave primaria definita per la tabella/visualizzazione 'MedAP.dbo.v_resMens'. La chiave è stata dedotta e la definizione è stata creata come tabella/visualizzazione di sola lettura.-->
|
|
<EntityType Name="v_resMens">
|
|
<Key>
|
|
<PropertyRef Name="anno" />
|
|
<PropertyRef Name="mese" />
|
|
</Key>
|
|
<Property Name="anno" Type="int" Nullable="false" />
|
|
<Property Name="mese" Type="int" Nullable="false" />
|
|
<Property Name="numDoc" Type="int" />
|
|
<Property Name="totNetto" Type="decimal" Precision="38" Scale="2" />
|
|
<Property Name="totIva" Type="decimal" Precision="38" Scale="2" />
|
|
<Property Name="totImporto" Type="decimal" Precision="38" Scale="2" />
|
|
</EntityType>
|
|
<!--Errori trovati durante la generazione:
|
|
avviso 6002: Nessuna chiave primaria definita per la tabella/visualizzazione 'MedAP.dbo.v_ResocontoIvaFatt'. La chiave è stata dedotta e la definizione è stata creata come tabella/visualizzazione di sola lettura.-->
|
|
<EntityType Name="v_ResocontoIvaFatt">
|
|
<Key>
|
|
<PropertyRef Name="RN" />
|
|
</Key>
|
|
<Property Name="RN" Type="bigint" Nullable="false" />
|
|
<Property Name="Idxfatt" Type="int" />
|
|
<Property Name="iva" Type="float" />
|
|
<Property Name="imponibile" Type="decimal" Precision="9" Scale="2" />
|
|
<Property Name="imposta" Type="decimal" Precision="9" Scale="2" />
|
|
<Property Name="totale" Type="decimal" Precision="9" Scale="2" />
|
|
</EntityType>
|
|
<!--Errori trovati durante la generazione:
|
|
avviso 6002: Nessuna chiave primaria definita per la tabella/visualizzazione 'MedAP.dbo.v_RowTemplate'. La chiave è stata dedotta e la definizione è stata creata come tabella/visualizzazione di sola lettura.-->
|
|
<EntityType Name="v_RowTemplate">
|
|
<Key>
|
|
<PropertyRef Name="importo" />
|
|
<PropertyRef Name="netto" />
|
|
<PropertyRef Name="iva" />
|
|
<PropertyRef Name="IdxRigheFatt" />
|
|
</Key>
|
|
<Property Name="IdxRigheFatt" Type="int" Nullable="false" />
|
|
<Property Name="importo" Type="numeric" Precision="1" Scale="1" Nullable="false" />
|
|
<Property Name="netto" Type="numeric" Precision="1" Scale="1" Nullable="false" />
|
|
<Property Name="iva" Type="numeric" Precision="1" Scale="1" Nullable="false" />
|
|
<Property Name="Descrizione" Type="nvarchar(max)" />
|
|
</EntityType>
|
|
<Function Name="stp_clienti_delete" Aggregate="false" BuiltIn="false" NiladicFunction="false" IsComposable="false" ParameterTypeSemantics="AllowImplicitConversion" Schema="dbo">
|
|
<Parameter Name="Original_idxCli" Type="int" Mode="In" />
|
|
</Function>
|
|
<Function Name="stp_clienti_insert" Aggregate="false" BuiltIn="false" NiladicFunction="false" IsComposable="false" ParameterTypeSemantics="AllowImplicitConversion" Schema="dbo">
|
|
<Parameter Name="RagSoc" Type="nvarchar" Mode="In" />
|
|
<Parameter Name="Sesso" Type="char" Mode="In" />
|
|
<Parameter Name="POBirth" Type="nvarchar" Mode="In" />
|
|
<Parameter Name="DOBirth" Type="datetime" Mode="In" />
|
|
<Parameter Name="P_iva" Type="nvarchar" Mode="In" />
|
|
<Parameter Name="C_Fisc" Type="nvarchar" Mode="In" />
|
|
<Parameter Name="Via" Type="nvarchar" Mode="In" />
|
|
<Parameter Name="Localita" Type="nvarchar" Mode="In" />
|
|
<Parameter Name="Cap" Type="nvarchar" Mode="In" />
|
|
<Parameter Name="Provincia" Type="nvarchar" Mode="In" />
|
|
<Parameter Name="Pagamento" Type="nvarchar" Mode="In" />
|
|
<Parameter Name="Note" Type="ntext" Mode="In" />
|
|
<Parameter Name="idxGruppo" Type="nvarchar" Mode="In" />
|
|
</Function>
|
|
<Function Name="stp_clienti_update" Aggregate="false" BuiltIn="false" NiladicFunction="false" IsComposable="false" ParameterTypeSemantics="AllowImplicitConversion" Schema="dbo">
|
|
<Parameter Name="Original_idxCli" Type="int" Mode="In" />
|
|
<Parameter Name="RagSoc" Type="nvarchar" Mode="In" />
|
|
<Parameter Name="Sesso" Type="char" Mode="In" />
|
|
<Parameter Name="POBirth" Type="nvarchar" Mode="In" />
|
|
<Parameter Name="DOBirth" Type="datetime" Mode="In" />
|
|
<Parameter Name="P_iva" Type="nvarchar" Mode="In" />
|
|
<Parameter Name="C_Fisc" Type="nvarchar" Mode="In" />
|
|
<Parameter Name="Via" Type="nvarchar" Mode="In" />
|
|
<Parameter Name="Localita" Type="nvarchar" Mode="In" />
|
|
<Parameter Name="Cap" Type="nvarchar" Mode="In" />
|
|
<Parameter Name="Provincia" Type="nvarchar" Mode="In" />
|
|
<Parameter Name="Pagamento" Type="nvarchar" Mode="In" />
|
|
<Parameter Name="email" Type="nvarchar" Mode="In" />
|
|
<Parameter Name="tel" Type="nvarchar" Mode="In" />
|
|
<Parameter Name="Note" Type="ntext" Mode="In" />
|
|
<Parameter Name="idxGruppo" Type="nvarchar" Mode="In" />
|
|
</Function>
|
|
<Function Name="stp_docRows_addNew" Aggregate="false" BuiltIn="false" NiladicFunction="false" IsComposable="false" ParameterTypeSemantics="AllowImplicitConversion" Schema="dbo">
|
|
<Parameter Name="idxDoc" Type="int" Mode="In" />
|
|
<Parameter Name="Descrizione" Type="nvarchar" Mode="In" />
|
|
<Parameter Name="um" Type="nvarchar" Mode="In" />
|
|
<Parameter Name="prezzoUm" Type="money" Mode="In" />
|
|
<Parameter Name="qta" Type="real" Mode="In" />
|
|
<Parameter Name="cIva" Type="int" Mode="In" />
|
|
</Function>
|
|
<Function Name="stp_docRows_copy2doc" Aggregate="false" BuiltIn="false" NiladicFunction="false" IsComposable="false" ParameterTypeSemantics="AllowImplicitConversion" Schema="dbo">
|
|
<Parameter Name="idxDoc" Type="int" Mode="In" />
|
|
<Parameter Name="idxRow" Type="int" Mode="In" />
|
|
</Function>
|
|
<Function Name="stp_docRows_deleteQuery" Aggregate="false" BuiltIn="false" NiladicFunction="false" IsComposable="false" ParameterTypeSemantics="AllowImplicitConversion" Schema="dbo">
|
|
<Parameter Name="Original_id" Type="int" Mode="In" />
|
|
</Function>
|
|
<Function Name="stp_docRows_getByIdxDoc" Aggregate="false" BuiltIn="false" NiladicFunction="false" IsComposable="false" ParameterTypeSemantics="AllowImplicitConversion" Schema="dbo">
|
|
<Parameter Name="idxDoc" Type="int" Mode="In" />
|
|
</Function>
|
|
<Function Name="stp_docRows_updateQuery" Aggregate="false" BuiltIn="false" NiladicFunction="false" IsComposable="false" ParameterTypeSemantics="AllowImplicitConversion" Schema="dbo">
|
|
<Parameter Name="Original_id" Type="int" Mode="In" />
|
|
<Parameter Name="Descrizione" Type="nvarchar" Mode="In" />
|
|
<Parameter Name="um" Type="nvarchar" Mode="In" />
|
|
<Parameter Name="prezzoUm" Type="money" Mode="In" />
|
|
<Parameter Name="qta" Type="real" Mode="In" />
|
|
<Parameter Name="sconto" Type="real" Mode="In" />
|
|
<Parameter Name="c_iva" Type="int" Mode="In" />
|
|
</Function>
|
|
<Function Name="stp_docs_clone" Aggregate="false" BuiltIn="false" NiladicFunction="false" IsComposable="false" ParameterTypeSemantics="AllowImplicitConversion" Schema="dbo">
|
|
<Parameter Name="IdxFatt" Type="int" Mode="In" />
|
|
</Function>
|
|
<Function Name="stp_docs_cloneTemplate" Aggregate="false" BuiltIn="false" NiladicFunction="false" IsComposable="false" ParameterTypeSemantics="AllowImplicitConversion" Schema="dbo">
|
|
<Parameter Name="IdxFatt" Type="int" Mode="In" />
|
|
<Parameter Name="idxCli" Type="int" Mode="In" />
|
|
</Function>
|
|
<Function Name="stp_docs_delete" Aggregate="false" BuiltIn="false" NiladicFunction="false" IsComposable="false" ParameterTypeSemantics="AllowImplicitConversion" Schema="dbo">
|
|
<Parameter Name="Original_idxDoc" Type="int" Mode="In" />
|
|
</Function>
|
|
<Function Name="stp_docs_getByKey" Aggregate="false" BuiltIn="false" NiladicFunction="false" IsComposable="false" ParameterTypeSemantics="AllowImplicitConversion" Schema="dbo">
|
|
<Parameter Name="idxDoc" Type="int" Mode="In" />
|
|
</Function>
|
|
<Function Name="stp_docs_getFilt" Aggregate="false" BuiltIn="false" NiladicFunction="false" IsComposable="false" ParameterTypeSemantics="AllowImplicitConversion" Schema="dbo">
|
|
<Parameter Name="anno" Type="int" Mode="In" />
|
|
<Parameter Name="idxCli" Type="int" Mode="In" />
|
|
<Parameter Name="tipo" Type="nvarchar" Mode="In" />
|
|
<Parameter Name="gruppo" Type="nvarchar" Mode="In" />
|
|
<Parameter Name="ragSoc" Type="nvarchar" Mode="In" />
|
|
<Parameter Name="inizio" Type="datetime" Mode="In" />
|
|
<Parameter Name="fine" Type="datetime" Mode="In" />
|
|
<Parameter Name="aperta" Type="int" Mode="In" />
|
|
<Parameter Name="search" Type="nvarchar" Mode="In" />
|
|
</Function>
|
|
<Function Name="stp_docs_insert" Aggregate="false" BuiltIn="false" NiladicFunction="false" IsComposable="false" ParameterTypeSemantics="AllowImplicitConversion" Schema="dbo">
|
|
<Parameter Name="anno" Type="int" Mode="In" />
|
|
<Parameter Name="num" Type="int" Mode="In" />
|
|
<Parameter Name="idxCli" Type="int" Mode="In" />
|
|
<Parameter Name="tipo" Type="nvarchar" Mode="In" />
|
|
<Parameter Name="emesso" Type="datetime" Mode="In" />
|
|
<Parameter Name="ritenuta" Type="float" Mode="In" />
|
|
</Function>
|
|
<Function Name="stp_docs_update" Aggregate="false" BuiltIn="false" NiladicFunction="false" IsComposable="false" ParameterTypeSemantics="AllowImplicitConversion" Schema="dbo">
|
|
<Parameter Name="Original_idxDoc" Type="int" Mode="In" />
|
|
<Parameter Name="anno" Type="int" Mode="In" />
|
|
<Parameter Name="num" Type="int" Mode="In" />
|
|
<Parameter Name="idxCli" Type="int" Mode="In" />
|
|
<Parameter Name="tipo" Type="nvarchar" Mode="In" />
|
|
<Parameter Name="emesso" Type="datetime" Mode="In" />
|
|
<Parameter Name="ritenuta" Type="float" Mode="In" />
|
|
</Function>
|
|
<Function Name="stp_listValues_getValidValuesTrad" Aggregate="false" BuiltIn="false" NiladicFunction="false" IsComposable="false" ParameterTypeSemantics="AllowImplicitConversion" Schema="dbo">
|
|
<Parameter Name="TableName" Type="nvarchar" Mode="In" />
|
|
<Parameter Name="FieldName" Type="nvarchar" Mode="In" />
|
|
<Parameter Name="Lingua" Type="nvarchar" Mode="In" />
|
|
</Function>
|
|
<Function Name="stp_ResGiornFilt" Aggregate="false" BuiltIn="false" NiladicFunction="false" IsComposable="false" ParameterTypeSemantics="AllowImplicitConversion" Schema="dbo">
|
|
<Parameter Name="inizio" Type="datetime" Mode="In" />
|
|
<Parameter Name="fine" Type="datetime" Mode="In" />
|
|
</Function>
|
|
<Function Name="stp_ResMensFilt" Aggregate="false" BuiltIn="false" NiladicFunction="false" IsComposable="false" ParameterTypeSemantics="AllowImplicitConversion" Schema="dbo">
|
|
<Parameter Name="inizio" Type="datetime" Mode="In" />
|
|
<Parameter Name="fine" Type="datetime" Mode="In" />
|
|
</Function>
|
|
<Function Name="stp_ResocontoIva" Aggregate="false" BuiltIn="false" NiladicFunction="false" IsComposable="false" ParameterTypeSemantics="AllowImplicitConversion" Schema="dbo">
|
|
<Parameter Name="idxDoc" Type="int" Mode="In" />
|
|
</Function>
|
|
<Function Name="stp_VAT_deleteQuery" Aggregate="false" BuiltIn="false" NiladicFunction="false" IsComposable="false" ParameterTypeSemantics="AllowImplicitConversion" Schema="dbo">
|
|
<Parameter Name="Original_C_iva" Type="int" Mode="In" />
|
|
</Function>
|
|
<Function Name="stp_VAT_updateQuery" Aggregate="false" BuiltIn="false" NiladicFunction="false" IsComposable="false" ParameterTypeSemantics="AllowImplicitConversion" Schema="dbo">
|
|
<Parameter Name="Original_C_iva" Type="int" Mode="In" />
|
|
<Parameter Name="iva" Type="float" Mode="In" />
|
|
<Parameter Name="descrizione" Type="nvarchar" Mode="In" />
|
|
<Parameter Name="enabled" Type="bit" Mode="In" />
|
|
<Parameter Name="splitPay" Type="bit" Mode="In" />
|
|
</Function>
|
|
<EntityContainer Name="MAPModelStoreContainer">
|
|
<EntitySet Name="C_iva" EntityType="Self.C_iva" Schema="dbo" store:Type="Tables" />
|
|
<EntitySet Name="Clienti" EntityType="Self.Clienti" Schema="dbo" store:Type="Tables" />
|
|
<EntitySet Name="KVPlist" EntityType="Self.KVPlist" Schema="dbo" store:Type="Tables" />
|
|
<EntitySet Name="v_docRowsExpl" EntityType="Self.v_docRowsExpl" store:Type="Views" store:Schema="dbo">
|
|
<DefiningQuery>SELECT
|
|
[v_docRowsExpl].[IdxRigheFatt] AS [IdxRigheFatt],
|
|
[v_docRowsExpl].[IdxFatt] AS [IdxFatt],
|
|
[v_docRowsExpl].[idxDoc] AS [idxDoc],
|
|
[v_docRowsExpl].[Descrizione] AS [Descrizione],
|
|
[v_docRowsExpl].[um] AS [um],
|
|
[v_docRowsExpl].[prezzoUm] AS [prezzoUm],
|
|
[v_docRowsExpl].[qta] AS [qta],
|
|
[v_docRowsExpl].[sconto] AS [sconto],
|
|
[v_docRowsExpl].[c_iva] AS [c_iva],
|
|
[v_docRowsExpl].[no_ritenuta] AS [no_ritenuta],
|
|
[v_docRowsExpl].[iva] AS [iva],
|
|
[v_docRowsExpl].[netto] AS [netto],
|
|
[v_docRowsExpl].[quotaIva] AS [quotaIva],
|
|
[v_docRowsExpl].[importo] AS [importo]
|
|
FROM [dbo].[v_docRowsExpl] AS [v_docRowsExpl]</DefiningQuery>
|
|
</EntitySet>
|
|
<EntitySet Name="v_docsExpl" EntityType="Self.v_docsExpl" store:Type="Views" store:Schema="dbo">
|
|
<DefiningQuery>SELECT
|
|
[v_docsExpl].[idxDoc] AS [idxDoc],
|
|
[v_docsExpl].[emesso] AS [emesso],
|
|
[v_docsExpl].[Gruppo] AS [Gruppo],
|
|
[v_docsExpl].[RagSoc] AS [RagSoc],
|
|
[v_docsExpl].[indirizzo] AS [indirizzo],
|
|
[v_docsExpl].[localita] AS [localita],
|
|
[v_docsExpl].[Cap] AS [Cap],
|
|
[v_docsExpl].[prov] AS [prov],
|
|
[v_docsExpl].[CF] AS [CF],
|
|
[v_docsExpl].[pIva] AS [pIva],
|
|
[v_docsExpl].[num] AS [num],
|
|
[v_docsExpl].[anno] AS [anno],
|
|
[v_docsExpl].[Trim] AS [Trim],
|
|
[v_docsExpl].[Mese] AS [Mese],
|
|
[v_docsExpl].[netto] AS [netto],
|
|
[v_docsExpl].[iva] AS [iva],
|
|
[v_docsExpl].[importo] AS [importo],
|
|
[v_docsExpl].[tipo] AS [tipo],
|
|
[v_docsExpl].[idxCli] AS [idxCli],
|
|
[v_docsExpl].[totPagato] AS [totPagato],
|
|
[v_docsExpl].[totScadenze] AS [totScadenze],
|
|
[v_docsExpl].[Descrizione] AS [Descrizione],
|
|
[v_docsExpl].[ritenuta] AS [ritenuta],
|
|
[v_docsExpl].[CostiAss] AS [CostiAss],
|
|
[v_docsExpl].[Pagamento] AS [Pagamento],
|
|
[v_docsExpl].[Note] AS [Note]
|
|
FROM [dbo].[v_docsExpl] AS [v_docsExpl]</DefiningQuery>
|
|
</EntitySet>
|
|
<EntitySet Name="v_DocTemplate" EntityType="Self.v_DocTemplate" store:Type="Views" store:Schema="dbo">
|
|
<DefiningQuery>SELECT
|
|
[v_DocTemplate].[idxDoc] AS [idxDoc],
|
|
[v_DocTemplate].[emesso] AS [emesso],
|
|
[v_DocTemplate].[Gruppo] AS [Gruppo],
|
|
[v_DocTemplate].[RagSoc] AS [RagSoc],
|
|
[v_DocTemplate].[num] AS [num],
|
|
[v_DocTemplate].[anno] AS [anno],
|
|
[v_DocTemplate].[Trim] AS [Trim],
|
|
[v_DocTemplate].[Mese] AS [Mese],
|
|
[v_DocTemplate].[netto] AS [netto],
|
|
[v_DocTemplate].[iva] AS [iva],
|
|
[v_DocTemplate].[importo] AS [importo],
|
|
[v_DocTemplate].[tipo] AS [tipo],
|
|
[v_DocTemplate].[idxCli] AS [idxCli],
|
|
[v_DocTemplate].[totPagato] AS [totPagato],
|
|
[v_DocTemplate].[totScadenze] AS [totScadenze],
|
|
[v_DocTemplate].[Descrizione] AS [Descrizione],
|
|
[v_DocTemplate].[ritenuta] AS [ritenuta],
|
|
[v_DocTemplate].[CostiAss] AS [CostiAss]
|
|
FROM [dbo].[v_DocTemplate] AS [v_DocTemplate]</DefiningQuery>
|
|
</EntitySet>
|
|
<EntitySet Name="v_resGiorn" EntityType="Self.v_resGiorn" store:Type="Views" store:Schema="dbo">
|
|
<DefiningQuery>SELECT
|
|
[v_resGiorn].[anno] AS [anno],
|
|
[v_resGiorn].[mese] AS [mese],
|
|
[v_resGiorn].[giorno] AS [giorno],
|
|
[v_resGiorn].[numDoc] AS [numDoc],
|
|
[v_resGiorn].[totNetto] AS [totNetto],
|
|
[v_resGiorn].[totIva] AS [totIva],
|
|
[v_resGiorn].[totImporto] AS [totImporto]
|
|
FROM [dbo].[v_resGiorn] AS [v_resGiorn]</DefiningQuery>
|
|
</EntitySet>
|
|
<EntitySet Name="v_resMens" EntityType="Self.v_resMens" store:Type="Views" store:Schema="dbo">
|
|
<DefiningQuery>SELECT
|
|
[v_resMens].[anno] AS [anno],
|
|
[v_resMens].[mese] AS [mese],
|
|
[v_resMens].[numDoc] AS [numDoc],
|
|
[v_resMens].[totNetto] AS [totNetto],
|
|
[v_resMens].[totIva] AS [totIva],
|
|
[v_resMens].[totImporto] AS [totImporto]
|
|
FROM [dbo].[v_resMens] AS [v_resMens]</DefiningQuery>
|
|
</EntitySet>
|
|
<EntitySet Name="v_ResocontoIvaFatt" EntityType="Self.v_ResocontoIvaFatt" store:Type="Views" store:Schema="dbo">
|
|
<DefiningQuery>SELECT
|
|
[v_ResocontoIvaFatt].[RN] AS [RN],
|
|
[v_ResocontoIvaFatt].[Idxfatt] AS [Idxfatt],
|
|
[v_ResocontoIvaFatt].[iva] AS [iva],
|
|
[v_ResocontoIvaFatt].[imponibile] AS [imponibile],
|
|
[v_ResocontoIvaFatt].[imposta] AS [imposta],
|
|
[v_ResocontoIvaFatt].[totale] AS [totale]
|
|
FROM [dbo].[v_ResocontoIvaFatt] AS [v_ResocontoIvaFatt]</DefiningQuery>
|
|
</EntitySet>
|
|
<EntitySet Name="v_RowTemplate" EntityType="Self.v_RowTemplate" store:Type="Views" store:Schema="dbo">
|
|
<DefiningQuery>SELECT
|
|
[v_RowTemplate].[IdxRigheFatt] AS [IdxRigheFatt],
|
|
[v_RowTemplate].[importo] AS [importo],
|
|
[v_RowTemplate].[netto] AS [netto],
|
|
[v_RowTemplate].[iva] AS [iva],
|
|
[v_RowTemplate].[Descrizione] AS [Descrizione]
|
|
FROM [dbo].[v_RowTemplate] AS [v_RowTemplate]</DefiningQuery>
|
|
</EntitySet>
|
|
</EntityContainer>
|
|
</Schema></edmx:StorageModels>
|
|
<!-- CSDL content -->
|
|
<edmx:ConceptualModels>
|
|
<Schema Namespace="MAPModel" Alias="Self" annotation:UseStrongSpatialTypes="false" xmlns:annotation="http://schemas.microsoft.com/ado/2009/02/edm/annotation" xmlns:customannotation="http://schemas.microsoft.com/ado/2013/11/edm/customannotation" xmlns="http://schemas.microsoft.com/ado/2009/11/edm">
|
|
<EntityContainer Name="MAPEntities" annotation:LazyLoadingEnabled="true">
|
|
<EntitySet Name="Documenti" EntityType="MAPModel.Documenti" />
|
|
<EntitySet Name="DocTemplate" EntityType="MAPModel.DocTemplate" />
|
|
<EntitySet Name="RigheDoc" EntityType="MAPModel.RigheDoc" />
|
|
<FunctionImport Name="stp_docRows_deleteQuery">
|
|
<Parameter Name="Original_id" Mode="In" Type="Int32" />
|
|
</FunctionImport>
|
|
<FunctionImport Name="stp_docRows_updateQuery">
|
|
<Parameter Name="Original_id" Mode="In" Type="Int32" />
|
|
<Parameter Name="Descrizione" Mode="In" Type="String" />
|
|
<Parameter Name="um" Mode="In" Type="String" />
|
|
<Parameter Name="prezzoUm" Mode="In" Type="Decimal" />
|
|
<Parameter Name="qta" Mode="In" Type="Single" />
|
|
<Parameter Name="sconto" Mode="In" Type="Single" />
|
|
<Parameter Name="c_iva" Mode="In" Type="Int32" />
|
|
</FunctionImport>
|
|
<FunctionImport Name="stp_docRows_getByIdxDoc" EntitySet="RigheDoc" ReturnType="Collection(MAPModel.RigheDoc)">
|
|
<Parameter Name="idxDoc" Mode="In" Type="Int32" />
|
|
</FunctionImport>
|
|
<EntitySet Name="Clienti" EntityType="MAPModel.Clienti" />
|
|
<FunctionImport Name="stp_clienti_delete">
|
|
<Parameter Name="Original_idxCli" Mode="In" Type="Int32" />
|
|
</FunctionImport>
|
|
<FunctionImport Name="stp_clienti_insert">
|
|
<Parameter Name="RagSoc" Mode="In" Type="String" />
|
|
<Parameter Name="Sesso" Mode="In" Type="String" />
|
|
<Parameter Name="POBirth" Mode="In" Type="String" />
|
|
<Parameter Name="DOBirth" Mode="In" Type="DateTime" />
|
|
<Parameter Name="P_iva" Mode="In" Type="String" />
|
|
<Parameter Name="C_Fisc" Mode="In" Type="String" />
|
|
<Parameter Name="Via" Mode="In" Type="String" />
|
|
<Parameter Name="Localita" Mode="In" Type="String" />
|
|
<Parameter Name="Cap" Mode="In" Type="String" />
|
|
<Parameter Name="Provincia" Mode="In" Type="String" />
|
|
<Parameter Name="Pagamento" Mode="In" Type="String" />
|
|
<Parameter Name="Note" Mode="In" Type="String" />
|
|
<Parameter Name="idxGruppo" Mode="In" Type="String" />
|
|
</FunctionImport>
|
|
<FunctionImport Name="stp_clienti_update">
|
|
<Parameter Name="Original_idxCli" Mode="In" Type="Int32" />
|
|
<Parameter Name="RagSoc" Mode="In" Type="String" />
|
|
<Parameter Name="Sesso" Mode="In" Type="String" />
|
|
<Parameter Name="POBirth" Mode="In" Type="String" />
|
|
<Parameter Name="DOBirth" Mode="In" Type="DateTime" />
|
|
<Parameter Name="P_iva" Mode="In" Type="String" />
|
|
<Parameter Name="C_Fisc" Mode="In" Type="String" />
|
|
<Parameter Name="Via" Mode="In" Type="String" />
|
|
<Parameter Name="Localita" Mode="In" Type="String" />
|
|
<Parameter Name="Cap" Mode="In" Type="String" />
|
|
<Parameter Name="Provincia" Mode="In" Type="String" />
|
|
<Parameter Name="Pagamento" Mode="In" Type="String" />
|
|
<Parameter Name="email" Mode="In" Type="String" />
|
|
<Parameter Name="tel" Mode="In" Type="String" />
|
|
<Parameter Name="Note" Mode="In" Type="String" />
|
|
<Parameter Name="idxGruppo" Mode="In" Type="String" />
|
|
</FunctionImport>
|
|
<FunctionImport Name="stp_docs_clone">
|
|
<Parameter Name="IdxFatt" Mode="In" Type="Int32" />
|
|
</FunctionImport>
|
|
<FunctionImport Name="stp_docs_delete">
|
|
<Parameter Name="Original_idxDoc" Mode="In" Type="Int32" />
|
|
</FunctionImport>
|
|
<FunctionImport Name="stp_docs_getByKey" ReturnType="Collection(MAPModel.stp_docs_getByKey_Result)">
|
|
<Parameter Name="idxDoc" Mode="In" Type="Int32" />
|
|
</FunctionImport>
|
|
<FunctionImport Name="stp_docs_getFilt" ReturnType="Collection(MAPModel.stp_docs_getFilt_Result)">
|
|
<Parameter Name="anno" Mode="In" Type="Int32" />
|
|
<Parameter Name="idxCli" Mode="In" Type="Int32" />
|
|
<Parameter Name="tipo" Mode="In" Type="String" />
|
|
<Parameter Name="gruppo" Mode="In" Type="String" />
|
|
<Parameter Name="ragSoc" Mode="In" Type="String" />
|
|
<Parameter Name="inizio" Mode="In" Type="DateTime" />
|
|
<Parameter Name="fine" Mode="In" Type="DateTime" />
|
|
<Parameter Name="aperta" Mode="In" Type="Int32" />
|
|
<Parameter Name="search" Mode="In" Type="String" />
|
|
</FunctionImport>
|
|
<FunctionImport Name="stp_docs_insert">
|
|
<Parameter Name="anno" Mode="In" Type="Int32" />
|
|
<Parameter Name="num" Mode="In" Type="Int32" />
|
|
<Parameter Name="idxCli" Mode="In" Type="Int32" />
|
|
<Parameter Name="tipo" Mode="In" Type="String" />
|
|
<Parameter Name="emesso" Mode="In" Type="DateTime" />
|
|
<Parameter Name="ritenuta" Mode="In" Type="Double" />
|
|
</FunctionImport>
|
|
<FunctionImport Name="stp_docs_update">
|
|
<Parameter Name="Original_idxDoc" Mode="In" Type="Int32" />
|
|
<Parameter Name="anno" Mode="In" Type="Int32" />
|
|
<Parameter Name="num" Mode="In" Type="Int32" />
|
|
<Parameter Name="idxCli" Mode="In" Type="Int32" />
|
|
<Parameter Name="tipo" Mode="In" Type="String" />
|
|
<Parameter Name="emesso" Mode="In" Type="DateTime" />
|
|
<Parameter Name="ritenuta" Mode="In" Type="Double" />
|
|
</FunctionImport>
|
|
<FunctionImport Name="stp_docRows_addNew">
|
|
<Parameter Name="idxDoc" Mode="In" Type="Int32" />
|
|
<Parameter Name="Descrizione" Mode="In" Type="String" />
|
|
<Parameter Name="um" Mode="In" Type="String" />
|
|
<Parameter Name="prezzoUm" Mode="In" Type="Decimal" />
|
|
<Parameter Name="qta" Mode="In" Type="Single" />
|
|
<Parameter Name="cIva" Mode="In" Type="Int32" />
|
|
</FunctionImport>
|
|
<FunctionImport Name="stp_docRows_copy2doc">
|
|
<Parameter Name="idxDoc" Mode="In" Type="Int32" />
|
|
<Parameter Name="idxRow" Mode="In" Type="Int32" />
|
|
</FunctionImport>
|
|
<FunctionImport Name="stp_docs_cloneTemplate">
|
|
<Parameter Name="IdxFatt" Mode="In" Type="Int32" />
|
|
<Parameter Name="idxCli" Mode="In" Type="Int32" />
|
|
</FunctionImport>
|
|
<EntitySet Name="RowTemplate" EntityType="MAPModel.RowTemplate" />
|
|
<EntitySet Name="ResocontoIvaFatt" EntityType="MAPModel.ResocontoIvaFatt" />
|
|
<EntitySet Name="VAT" EntityType="MAPModel.VAT" />
|
|
<FunctionImport Name="stp_VAT_deleteQuery">
|
|
<Parameter Name="Original_C_iva" Mode="In" Type="Int32" />
|
|
</FunctionImport>
|
|
<FunctionImport Name="stp_VAT_updateQuery">
|
|
<Parameter Name="Original_C_iva" Mode="In" Type="Int32" />
|
|
<Parameter Name="iva" Mode="In" Type="Double" />
|
|
<Parameter Name="descrizione" Mode="In" Type="String" />
|
|
<Parameter Name="enabled" Mode="In" Type="Boolean" />
|
|
<Parameter Name="splitPay" Mode="In" Type="Boolean" />
|
|
</FunctionImport>
|
|
<EntitySet Name="KVPlist" EntityType="MAPModel.KVPlist" />
|
|
<FunctionImport Name="stp_listValues_getValidValuesTrad" EntitySet="KVPlist" ReturnType="Collection(MAPModel.KVPlist)">
|
|
<Parameter Name="TableName" Mode="In" Type="String" />
|
|
<Parameter Name="FieldName" Mode="In" Type="String" />
|
|
<Parameter Name="Lingua" Mode="In" Type="String" />
|
|
</FunctionImport>
|
|
<EntitySet Name="ResGiorn" EntityType="MAPModel.ResGiorn" />
|
|
<EntitySet Name="ResMens" EntityType="MAPModel.ResMens" />
|
|
<FunctionImport Name="stp_ResGiornFilt" EntitySet="ResGiorn" ReturnType="Collection(MAPModel.ResGiorn)">
|
|
<Parameter Name="inizio" Mode="In" Type="DateTime" />
|
|
<Parameter Name="fine" Mode="In" Type="DateTime" />
|
|
</FunctionImport>
|
|
<FunctionImport Name="stp_ResMensFilt" EntitySet="ResMens" ReturnType="Collection(MAPModel.ResMens)">
|
|
<Parameter Name="inizio" Mode="In" Type="DateTime" />
|
|
<Parameter Name="fine" Mode="In" Type="DateTime" />
|
|
</FunctionImport>
|
|
</EntityContainer>
|
|
<EntityType Name="Documenti">
|
|
<Key>
|
|
<PropertyRef Name="idxDoc" />
|
|
<PropertyRef Name="Gruppo" />
|
|
<PropertyRef Name="RagSoc" />
|
|
<PropertyRef Name="num" />
|
|
<PropertyRef Name="anno" />
|
|
<PropertyRef Name="netto" />
|
|
<PropertyRef Name="iva" />
|
|
<PropertyRef Name="importo" />
|
|
<PropertyRef Name="tipo" />
|
|
<PropertyRef Name="idxCli" />
|
|
<PropertyRef Name="totPagato" />
|
|
<PropertyRef Name="totScadenze" />
|
|
<PropertyRef Name="Descrizione" />
|
|
<PropertyRef Name="ritenuta" />
|
|
<PropertyRef Name="CostiAss" />
|
|
<PropertyRef Name="indirizzo" />
|
|
<PropertyRef Name="localita" />
|
|
<PropertyRef Name="Cap" />
|
|
<PropertyRef Name="prov" />
|
|
<PropertyRef Name="CF" />
|
|
<PropertyRef Name="pIva" />
|
|
<PropertyRef Name="Pagamento" />
|
|
<PropertyRef Name="Note" />
|
|
</Key>
|
|
<Property Name="idxDoc" Type="Int32" Nullable="false" />
|
|
<Property Name="emesso" Type="DateTime" Precision="0" />
|
|
<Property Name="Gruppo" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" />
|
|
<Property Name="RagSoc" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" />
|
|
<Property Name="num" Type="Int32" Nullable="false" />
|
|
<Property Name="anno" Type="Int32" Nullable="false" />
|
|
<Property Name="Trim" Type="Int32" />
|
|
<Property Name="Mese" Type="Int32" />
|
|
<Property Name="netto" Type="Decimal" Nullable="false" Precision="9" Scale="2" />
|
|
<Property Name="iva" Type="Decimal" Nullable="false" Precision="9" Scale="2" />
|
|
<Property Name="importo" Type="Decimal" Nullable="false" Precision="9" Scale="2" />
|
|
<Property Name="tipo" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" />
|
|
<Property Name="idxCli" Type="Int32" Nullable="false" />
|
|
<Property Name="totPagato" Type="Decimal" Nullable="false" Precision="19" Scale="4" />
|
|
<Property Name="totScadenze" Type="Decimal" Nullable="false" Precision="19" Scale="4" />
|
|
<Property Name="Descrizione" Type="String" Nullable="false" MaxLength="Max" FixedLength="false" Unicode="true" />
|
|
<Property Name="ritenuta" Type="Double" Nullable="false" />
|
|
<Property Name="CostiAss" Type="Decimal" Nullable="false" Precision="19" Scale="4" />
|
|
<Property Name="indirizzo" Type="String" Nullable="false" MaxLength="250" FixedLength="false" Unicode="true" />
|
|
<Property Name="localita" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" />
|
|
<Property Name="Cap" Type="String" Nullable="false" MaxLength="5" FixedLength="false" Unicode="true" />
|
|
<Property Name="prov" Type="String" Nullable="false" MaxLength="2" FixedLength="false" Unicode="true" />
|
|
<Property Name="CF" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" />
|
|
<Property Name="pIva" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" />
|
|
<Property Name="Pagamento" Type="String" Nullable="false" MaxLength="250" FixedLength="false" Unicode="true" />
|
|
<Property Name="Note" Type="String" Nullable="false" MaxLength="Max" FixedLength="false" Unicode="true" />
|
|
</EntityType>
|
|
<EntityType Name="DocTemplate">
|
|
<Key>
|
|
<PropertyRef Name="idxDoc" />
|
|
<PropertyRef Name="Gruppo" />
|
|
<PropertyRef Name="RagSoc" />
|
|
<PropertyRef Name="num" />
|
|
<PropertyRef Name="anno" />
|
|
<PropertyRef Name="netto" />
|
|
<PropertyRef Name="iva" />
|
|
<PropertyRef Name="importo" />
|
|
<PropertyRef Name="tipo" />
|
|
<PropertyRef Name="idxCli" />
|
|
<PropertyRef Name="totPagato" />
|
|
<PropertyRef Name="totScadenze" />
|
|
<PropertyRef Name="Descrizione" />
|
|
<PropertyRef Name="ritenuta" />
|
|
<PropertyRef Name="CostiAss" />
|
|
</Key>
|
|
<Property Name="idxDoc" Type="Int32" Nullable="false" />
|
|
<Property Name="emesso" Type="DateTime" Precision="0" />
|
|
<Property Name="Gruppo" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" />
|
|
<Property Name="RagSoc" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" />
|
|
<Property Name="num" Type="Int32" Nullable="false" />
|
|
<Property Name="anno" Type="Int32" Nullable="false" />
|
|
<Property Name="Trim" Type="Int32" />
|
|
<Property Name="Mese" Type="Int32" />
|
|
<Property Name="netto" Type="Decimal" Nullable="false" Precision="9" Scale="2" />
|
|
<Property Name="iva" Type="Decimal" Nullable="false" Precision="9" Scale="2" />
|
|
<Property Name="importo" Type="Decimal" Nullable="false" Precision="9" Scale="2" />
|
|
<Property Name="tipo" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" />
|
|
<Property Name="idxCli" Type="Int32" Nullable="false" />
|
|
<Property Name="totPagato" Type="Decimal" Nullable="false" Precision="19" Scale="4" />
|
|
<Property Name="totScadenze" Type="Decimal" Nullable="false" Precision="19" Scale="4" />
|
|
<Property Name="Descrizione" Type="String" Nullable="false" MaxLength="Max" FixedLength="false" Unicode="true" />
|
|
<Property Name="ritenuta" Type="Double" Nullable="false" />
|
|
<Property Name="CostiAss" Type="Decimal" Nullable="false" Precision="19" Scale="4" />
|
|
</EntityType>
|
|
<EntityType Name="RigheDoc">
|
|
<Key>
|
|
<PropertyRef Name="IdxRigheFatt" />
|
|
</Key>
|
|
<Property Name="IdxRigheFatt" Type="Int32" Nullable="false" />
|
|
<Property Name="IdxFatt" Type="Int32" />
|
|
<Property Name="idxDoc" Type="Int32" />
|
|
<Property Name="Descrizione" Type="String" MaxLength="Max" FixedLength="false" Unicode="true" />
|
|
<Property Name="um" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
|
|
<Property Name="prezzoUm" Type="Decimal" Precision="19" Scale="4" />
|
|
<Property Name="qta" Type="Int32" />
|
|
<Property Name="sconto" Type="Single" />
|
|
<Property Name="c_iva" Type="Int32" />
|
|
<Property Name="no_ritenuta" Type="Boolean" />
|
|
<Property Name="iva" Type="Double" />
|
|
<Property Name="netto" Type="Decimal" Precision="9" Scale="2" />
|
|
<Property Name="quotaIva" Type="Decimal" Precision="9" Scale="2" />
|
|
<Property Name="importo" Type="Decimal" Precision="9" Scale="2" />
|
|
</EntityType>
|
|
<ComplexType Name="stp_docRows_getByIdxDoc_Result">
|
|
<Property Type="Int32" Name="IdxRigheFatt" Nullable="false" />
|
|
<Property Type="Int32" Name="IdxFatt" Nullable="true" />
|
|
<Property Type="Int32" Name="idxDoc" Nullable="true" />
|
|
<Property Type="String" Name="Descrizione" Nullable="true" MaxLength="Max" />
|
|
<Property Type="String" Name="um" Nullable="true" MaxLength="50" />
|
|
<Property Type="Decimal" Name="prezzoUm" Nullable="true" Precision="19" />
|
|
<Property Type="Int32" Name="qta" Nullable="true" />
|
|
<Property Type="Single" Name="sconto" Nullable="true" />
|
|
<Property Type="Int32" Name="c_iva" Nullable="true" />
|
|
<Property Type="Boolean" Name="no_ritenuta" Nullable="true" />
|
|
<Property Type="Double" Name="iva" Nullable="true" />
|
|
<Property Type="Decimal" Name="netto" Nullable="true" Precision="9" Scale="2" />
|
|
<Property Type="Decimal" Name="quotaIva" Nullable="true" Precision="9" Scale="2" />
|
|
<Property Type="Decimal" Name="importo" Nullable="true" Precision="9" Scale="2" />
|
|
</ComplexType>
|
|
<EntityType Name="Clienti">
|
|
<Key>
|
|
<PropertyRef Name="idxCli" />
|
|
</Key>
|
|
<Property Name="idxCli" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
|
|
<Property Name="RagSoc" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" />
|
|
<Property Name="Sesso" Type="String" Nullable="false" MaxLength="1" FixedLength="true" Unicode="false" />
|
|
<Property Name="POBirth" Type="String" Nullable="false" MaxLength="250" FixedLength="false" Unicode="true" />
|
|
<Property Name="DOBirth" Type="DateTime" Nullable="false" Precision="3" />
|
|
<Property Name="P_iva" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" />
|
|
<Property Name="C_Fisc" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" />
|
|
<Property Name="Via" Type="String" Nullable="false" MaxLength="250" FixedLength="false" Unicode="true" />
|
|
<Property Name="Località" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" />
|
|
<Property Name="Cap" Type="String" Nullable="false" MaxLength="5" FixedLength="false" Unicode="true" />
|
|
<Property Name="Provincia" Type="String" Nullable="false" MaxLength="2" FixedLength="false" Unicode="true" />
|
|
<Property Name="Pagamento" Type="String" Nullable="false" MaxLength="250" FixedLength="false" Unicode="true" />
|
|
<Property Name="Note" Type="String" Nullable="false" MaxLength="Max" FixedLength="false" Unicode="true" />
|
|
<Property Name="idxGruppo" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" />
|
|
<Property Name="email" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" />
|
|
<Property Name="tel" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" />
|
|
</EntityType>
|
|
<ComplexType Name="stp_docs_getByKey_Result">
|
|
<Property Type="Int32" Name="idxDoc" Nullable="false" />
|
|
<Property Type="DateTime" Name="emesso" Nullable="true" />
|
|
<Property Type="String" Name="Gruppo" Nullable="false" MaxLength="50" />
|
|
<Property Type="String" Name="RagSoc" Nullable="false" MaxLength="50" />
|
|
<Property Type="Int32" Name="num" Nullable="false" />
|
|
<Property Type="Int32" Name="anno" Nullable="false" />
|
|
<Property Type="Int32" Name="Trim" Nullable="true" />
|
|
<Property Type="Int32" Name="Mese" Nullable="true" />
|
|
<Property Type="Decimal" Name="netto" Nullable="false" Precision="9" Scale="2" />
|
|
<Property Type="Decimal" Name="iva" Nullable="false" Precision="9" Scale="2" />
|
|
<Property Type="Decimal" Name="importo" Nullable="false" Precision="9" Scale="2" />
|
|
<Property Type="String" Name="tipo" Nullable="false" MaxLength="50" />
|
|
<Property Type="Int32" Name="idxCli" Nullable="false" />
|
|
<Property Type="Decimal" Name="totPagato" Nullable="false" Precision="19" />
|
|
<Property Type="Decimal" Name="totScadenze" Nullable="false" Precision="19" />
|
|
<Property Type="String" Name="Descrizione" Nullable="false" />
|
|
<Property Type="Double" Name="ritenuta" Nullable="false" />
|
|
<Property Type="Decimal" Name="CostiAss" Nullable="false" Precision="19" />
|
|
</ComplexType>
|
|
<ComplexType Name="stp_docs_getFilt_Result">
|
|
<Property Type="Int32" Name="idxDoc" Nullable="false" />
|
|
<Property Type="DateTime" Name="emesso" Nullable="true" />
|
|
<Property Type="String" Name="Gruppo" Nullable="false" MaxLength="50" />
|
|
<Property Type="String" Name="RagSoc" Nullable="false" MaxLength="50" />
|
|
<Property Type="Int32" Name="num" Nullable="false" />
|
|
<Property Type="Int32" Name="anno" Nullable="false" />
|
|
<Property Type="Int32" Name="Trim" Nullable="true" />
|
|
<Property Type="Int32" Name="Mese" Nullable="true" />
|
|
<Property Type="Decimal" Name="netto" Nullable="false" Precision="9" Scale="2" />
|
|
<Property Type="Decimal" Name="iva" Nullable="false" Precision="9" Scale="2" />
|
|
<Property Type="Decimal" Name="importo" Nullable="false" Precision="9" Scale="2" />
|
|
<Property Type="String" Name="tipo" Nullable="false" MaxLength="50" />
|
|
<Property Type="Int32" Name="idxCli" Nullable="false" />
|
|
<Property Type="Decimal" Name="totPagato" Nullable="false" Precision="19" />
|
|
<Property Type="Decimal" Name="totScadenze" Nullable="false" Precision="19" />
|
|
<Property Type="String" Name="Descrizione" Nullable="false" />
|
|
<Property Type="Double" Name="ritenuta" Nullable="false" />
|
|
<Property Type="Decimal" Name="CostiAss" Nullable="false" Precision="19" />
|
|
</ComplexType>
|
|
<EntityType Name="RowTemplate">
|
|
<Key>
|
|
<PropertyRef Name="importo" />
|
|
<PropertyRef Name="netto" />
|
|
<PropertyRef Name="iva" />
|
|
<PropertyRef Name="IdxRigheFatt" />
|
|
</Key>
|
|
<Property Name="IdxRigheFatt" Type="Int32" Nullable="false" />
|
|
<Property Name="Descrizione" Type="String" MaxLength="Max" FixedLength="false" Unicode="true" />
|
|
<Property Name="importo" Type="Decimal" Nullable="false" Precision="1" Scale="1" />
|
|
<Property Name="netto" Type="Decimal" Nullable="false" Precision="1" Scale="1" />
|
|
<Property Name="iva" Type="Decimal" Nullable="false" Precision="1" Scale="1" />
|
|
</EntityType>
|
|
<ComplexType Name="stp_ResocontoIva_Result">
|
|
<Property Type="Int64" Name="RN" Nullable="false" />
|
|
<Property Type="Int32" Name="Idxfatt" Nullable="true" />
|
|
<Property Type="Double" Name="iva" Nullable="true" />
|
|
<Property Type="Decimal" Name="imponibile" Nullable="true" Precision="9" Scale="2" />
|
|
<Property Type="Decimal" Name="imposta" Nullable="true" Precision="9" Scale="2" />
|
|
<Property Type="Decimal" Name="totale" Nullable="true" Precision="9" Scale="2" />
|
|
</ComplexType>
|
|
<EntityType Name="ResocontoIvaFatt">
|
|
<Key>
|
|
<PropertyRef Name="RN" />
|
|
</Key>
|
|
<Property Name="RN" Type="Int64" Nullable="false" />
|
|
<Property Name="Idxfatt" Type="Int32" />
|
|
<Property Name="iva" Type="Double" />
|
|
<Property Name="imponibile" Type="Decimal" Precision="9" Scale="2" />
|
|
<Property Name="imposta" Type="Decimal" Precision="9" Scale="2" />
|
|
<Property Name="totale" Type="Decimal" Precision="9" Scale="2" />
|
|
</EntityType>
|
|
<EntityType Name="VAT">
|
|
<Key>
|
|
<PropertyRef Name="C_iva" />
|
|
</Key>
|
|
<Property Name="C_iva" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
|
|
<Property Name="iva" Type="Double" Nullable="false" />
|
|
<Property Name="descrizione" Type="String" Nullable="false" MaxLength="250" FixedLength="false" Unicode="true" />
|
|
<Property Name="enabled" Type="Boolean" Nullable="false" />
|
|
<Property Name="splitPay" Type="Boolean" Nullable="false" />
|
|
</EntityType>
|
|
<EntityType Name="KVPlist">
|
|
<Key>
|
|
<PropertyRef Name="strKey" />
|
|
</Key>
|
|
<Property Name="strKey" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" />
|
|
<Property Name="strVal" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" />
|
|
</EntityType>
|
|
<ComplexType Name="stp_listValues_getValidValuesTrad_Result">
|
|
<Property Type="String" Name="strKey" Nullable="false" MaxLength="50" />
|
|
<Property Type="String" Name="strVal" Nullable="false" MaxLength="500" />
|
|
</ComplexType>
|
|
<EntityType Name="ResGiorn">
|
|
<Key>
|
|
<PropertyRef Name="anno" />
|
|
<PropertyRef Name="mese" />
|
|
<PropertyRef Name="giorno" />
|
|
</Key>
|
|
<Property Name="anno" Type="Int32" Nullable="false" />
|
|
<Property Name="mese" Type="Int32" Nullable="false" />
|
|
<Property Name="giorno" Type="DateTime" Precision="3" Nullable="false" />
|
|
<Property Name="numDoc" Type="Int32" />
|
|
<Property Name="totNetto" Type="Decimal" Precision="38" Scale="2" />
|
|
<Property Name="totIva" Type="Decimal" Precision="38" Scale="2" />
|
|
<Property Name="totImporto" Type="Decimal" Precision="38" Scale="2" />
|
|
</EntityType>
|
|
<EntityType Name="ResMens">
|
|
<Key>
|
|
<PropertyRef Name="anno" />
|
|
<PropertyRef Name="mese" />
|
|
</Key>
|
|
<Property Name="anno" Type="Int32" Nullable="false" />
|
|
<Property Name="mese" Type="Int32" Nullable="false" />
|
|
<Property Name="numDoc" Type="Int32" />
|
|
<Property Name="totNetto" Type="Decimal" Precision="38" Scale="2" />
|
|
<Property Name="totIva" Type="Decimal" Precision="38" Scale="2" />
|
|
<Property Name="totImporto" Type="Decimal" Precision="38" Scale="2" />
|
|
</EntityType>
|
|
<ComplexType Name="stp_ResGiornFilt_Result">
|
|
<Property Type="Int32" Name="anno" Nullable="false" />
|
|
<Property Type="Int32" Name="mese" Nullable="true" />
|
|
<Property Type="DateTime" Name="giorno" Nullable="true" Precision="23" />
|
|
<Property Type="Int32" Name="numDoc" Nullable="true" />
|
|
<Property Type="Decimal" Name="totNetto" Nullable="true" Precision="38" Scale="2" />
|
|
<Property Type="Decimal" Name="totIva" Nullable="true" Precision="38" Scale="2" />
|
|
<Property Type="Decimal" Name="totImporto" Nullable="true" Precision="38" Scale="2" />
|
|
</ComplexType>
|
|
<ComplexType Name="stp_ResMensFilt_Result">
|
|
<Property Type="Int32" Name="anno" Nullable="false" />
|
|
<Property Type="Int32" Name="mese" Nullable="true" />
|
|
<Property Type="Int32" Name="numDoc" Nullable="true" />
|
|
<Property Type="Decimal" Name="totNetto" Nullable="true" Precision="38" Scale="2" />
|
|
<Property Type="Decimal" Name="totIva" Nullable="true" Precision="38" Scale="2" />
|
|
<Property Type="Decimal" Name="totImporto" Nullable="true" Precision="38" Scale="2" />
|
|
</ComplexType>
|
|
</Schema>
|
|
</edmx:ConceptualModels>
|
|
<!-- C-S mapping content -->
|
|
<edmx:Mappings>
|
|
<Mapping Space="C-S" xmlns="http://schemas.microsoft.com/ado/2009/11/mapping/cs">
|
|
<EntityContainerMapping StorageEntityContainer="MAPModelStoreContainer" CdmEntityContainer="MAPEntities">
|
|
<EntitySetMapping Name="Documenti">
|
|
<EntityTypeMapping TypeName="MAPModel.Documenti">
|
|
<MappingFragment StoreEntitySet="v_docsExpl">
|
|
<ScalarProperty Name="Note" ColumnName="Note" />
|
|
<ScalarProperty Name="Pagamento" ColumnName="Pagamento" />
|
|
<ScalarProperty Name="pIva" ColumnName="pIva" />
|
|
<ScalarProperty Name="CF" ColumnName="CF" />
|
|
<ScalarProperty Name="prov" ColumnName="prov" />
|
|
<ScalarProperty Name="Cap" ColumnName="Cap" />
|
|
<ScalarProperty Name="localita" ColumnName="localita" />
|
|
<ScalarProperty Name="indirizzo" ColumnName="indirizzo" />
|
|
<ScalarProperty Name="CostiAss" ColumnName="CostiAss" />
|
|
<ScalarProperty Name="ritenuta" ColumnName="ritenuta" />
|
|
<ScalarProperty Name="Descrizione" ColumnName="Descrizione" />
|
|
<ScalarProperty Name="totScadenze" ColumnName="totScadenze" />
|
|
<ScalarProperty Name="totPagato" ColumnName="totPagato" />
|
|
<ScalarProperty Name="idxCli" ColumnName="idxCli" />
|
|
<ScalarProperty Name="tipo" ColumnName="tipo" />
|
|
<ScalarProperty Name="importo" ColumnName="importo" />
|
|
<ScalarProperty Name="iva" ColumnName="iva" />
|
|
<ScalarProperty Name="netto" ColumnName="netto" />
|
|
<ScalarProperty Name="Mese" ColumnName="Mese" />
|
|
<ScalarProperty Name="Trim" ColumnName="Trim" />
|
|
<ScalarProperty Name="anno" ColumnName="anno" />
|
|
<ScalarProperty Name="num" ColumnName="num" />
|
|
<ScalarProperty Name="RagSoc" ColumnName="RagSoc" />
|
|
<ScalarProperty Name="Gruppo" ColumnName="Gruppo" />
|
|
<ScalarProperty Name="emesso" ColumnName="emesso" />
|
|
<ScalarProperty Name="idxDoc" ColumnName="idxDoc" />
|
|
</MappingFragment>
|
|
</EntityTypeMapping>
|
|
</EntitySetMapping>
|
|
<EntitySetMapping Name="DocTemplate">
|
|
<EntityTypeMapping TypeName="MAPModel.DocTemplate">
|
|
<MappingFragment StoreEntitySet="v_DocTemplate">
|
|
<ScalarProperty Name="CostiAss" ColumnName="CostiAss" />
|
|
<ScalarProperty Name="ritenuta" ColumnName="ritenuta" />
|
|
<ScalarProperty Name="Descrizione" ColumnName="Descrizione" />
|
|
<ScalarProperty Name="totScadenze" ColumnName="totScadenze" />
|
|
<ScalarProperty Name="totPagato" ColumnName="totPagato" />
|
|
<ScalarProperty Name="idxCli" ColumnName="idxCli" />
|
|
<ScalarProperty Name="tipo" ColumnName="tipo" />
|
|
<ScalarProperty Name="importo" ColumnName="importo" />
|
|
<ScalarProperty Name="iva" ColumnName="iva" />
|
|
<ScalarProperty Name="netto" ColumnName="netto" />
|
|
<ScalarProperty Name="Mese" ColumnName="Mese" />
|
|
<ScalarProperty Name="Trim" ColumnName="Trim" />
|
|
<ScalarProperty Name="anno" ColumnName="anno" />
|
|
<ScalarProperty Name="num" ColumnName="num" />
|
|
<ScalarProperty Name="RagSoc" ColumnName="RagSoc" />
|
|
<ScalarProperty Name="Gruppo" ColumnName="Gruppo" />
|
|
<ScalarProperty Name="emesso" ColumnName="emesso" />
|
|
<ScalarProperty Name="idxDoc" ColumnName="idxDoc" />
|
|
</MappingFragment>
|
|
</EntityTypeMapping>
|
|
</EntitySetMapping>
|
|
<EntitySetMapping Name="RigheDoc">
|
|
<EntityTypeMapping TypeName="MAPModel.RigheDoc">
|
|
<MappingFragment StoreEntitySet="v_docRowsExpl">
|
|
<ScalarProperty Name="importo" ColumnName="importo" />
|
|
<ScalarProperty Name="quotaIva" ColumnName="quotaIva" />
|
|
<ScalarProperty Name="netto" ColumnName="netto" />
|
|
<ScalarProperty Name="iva" ColumnName="iva" />
|
|
<ScalarProperty Name="no_ritenuta" ColumnName="no_ritenuta" />
|
|
<ScalarProperty Name="c_iva" ColumnName="c_iva" />
|
|
<ScalarProperty Name="sconto" ColumnName="sconto" />
|
|
<ScalarProperty Name="qta" ColumnName="qta" />
|
|
<ScalarProperty Name="prezzoUm" ColumnName="prezzoUm" />
|
|
<ScalarProperty Name="um" ColumnName="um" />
|
|
<ScalarProperty Name="Descrizione" ColumnName="Descrizione" />
|
|
<ScalarProperty Name="idxDoc" ColumnName="idxDoc" />
|
|
<ScalarProperty Name="IdxFatt" ColumnName="IdxFatt" />
|
|
<ScalarProperty Name="IdxRigheFatt" ColumnName="IdxRigheFatt" />
|
|
</MappingFragment>
|
|
</EntityTypeMapping>
|
|
</EntitySetMapping>
|
|
<FunctionImportMapping FunctionImportName="stp_docRows_deleteQuery" FunctionName="MAPModel.Store.stp_docRows_deleteQuery" />
|
|
<FunctionImportMapping FunctionImportName="stp_docRows_updateQuery" FunctionName="MAPModel.Store.stp_docRows_updateQuery" />
|
|
<FunctionImportMapping FunctionImportName="stp_docRows_getByIdxDoc" FunctionName="MAPModel.Store.stp_docRows_getByIdxDoc">
|
|
</FunctionImportMapping>
|
|
<EntitySetMapping Name="Clienti">
|
|
<EntityTypeMapping TypeName="MAPModel.Clienti">
|
|
<MappingFragment StoreEntitySet="Clienti">
|
|
<ScalarProperty Name="tel" ColumnName="tel" />
|
|
<ScalarProperty Name="email" ColumnName="email" />
|
|
<ScalarProperty Name="idxGruppo" ColumnName="idxGruppo" />
|
|
<ScalarProperty Name="Note" ColumnName="Note" />
|
|
<ScalarProperty Name="Pagamento" ColumnName="Pagamento" />
|
|
<ScalarProperty Name="Provincia" ColumnName="Provincia" />
|
|
<ScalarProperty Name="Cap" ColumnName="Cap" />
|
|
<ScalarProperty Name="Località" ColumnName="Località" />
|
|
<ScalarProperty Name="Via" ColumnName="Via" />
|
|
<ScalarProperty Name="C_Fisc" ColumnName="C_Fisc" />
|
|
<ScalarProperty Name="P_iva" ColumnName="P_iva" />
|
|
<ScalarProperty Name="DOBirth" ColumnName="DOBirth" />
|
|
<ScalarProperty Name="POBirth" ColumnName="POBirth" />
|
|
<ScalarProperty Name="Sesso" ColumnName="Sesso" />
|
|
<ScalarProperty Name="RagSoc" ColumnName="RagSoc" />
|
|
<ScalarProperty Name="idxCli" ColumnName="idxCli" />
|
|
</MappingFragment>
|
|
</EntityTypeMapping>
|
|
</EntitySetMapping>
|
|
<FunctionImportMapping FunctionImportName="stp_clienti_delete" FunctionName="MAPModel.Store.stp_clienti_delete" />
|
|
<FunctionImportMapping FunctionImportName="stp_clienti_insert" FunctionName="MAPModel.Store.stp_clienti_insert" />
|
|
<FunctionImportMapping FunctionImportName="stp_clienti_update" FunctionName="MAPModel.Store.stp_clienti_update" />
|
|
<FunctionImportMapping FunctionImportName="stp_docs_clone" FunctionName="MAPModel.Store.stp_docs_clone" />
|
|
<FunctionImportMapping FunctionImportName="stp_docs_delete" FunctionName="MAPModel.Store.stp_docs_delete" />
|
|
<FunctionImportMapping FunctionImportName="stp_docs_getByKey" FunctionName="MAPModel.Store.stp_docs_getByKey">
|
|
<ResultMapping>
|
|
<ComplexTypeMapping TypeName="MAPModel.stp_docs_getByKey_Result">
|
|
<ScalarProperty Name="idxDoc" ColumnName="idxDoc" />
|
|
<ScalarProperty Name="emesso" ColumnName="emesso" />
|
|
<ScalarProperty Name="Gruppo" ColumnName="Gruppo" />
|
|
<ScalarProperty Name="RagSoc" ColumnName="RagSoc" />
|
|
<ScalarProperty Name="num" ColumnName="num" />
|
|
<ScalarProperty Name="anno" ColumnName="anno" />
|
|
<ScalarProperty Name="Trim" ColumnName="Trim" />
|
|
<ScalarProperty Name="Mese" ColumnName="Mese" />
|
|
<ScalarProperty Name="netto" ColumnName="netto" />
|
|
<ScalarProperty Name="iva" ColumnName="iva" />
|
|
<ScalarProperty Name="importo" ColumnName="importo" />
|
|
<ScalarProperty Name="tipo" ColumnName="tipo" />
|
|
<ScalarProperty Name="idxCli" ColumnName="idxCli" />
|
|
<ScalarProperty Name="totPagato" ColumnName="totPagato" />
|
|
<ScalarProperty Name="totScadenze" ColumnName="totScadenze" />
|
|
<ScalarProperty Name="Descrizione" ColumnName="Descrizione" />
|
|
<ScalarProperty Name="ritenuta" ColumnName="ritenuta" />
|
|
<ScalarProperty Name="CostiAss" ColumnName="CostiAss" />
|
|
</ComplexTypeMapping>
|
|
</ResultMapping>
|
|
</FunctionImportMapping>
|
|
<FunctionImportMapping FunctionImportName="stp_docs_getFilt" FunctionName="MAPModel.Store.stp_docs_getFilt">
|
|
<ResultMapping>
|
|
<ComplexTypeMapping TypeName="MAPModel.stp_docs_getFilt_Result">
|
|
<ScalarProperty Name="idxDoc" ColumnName="idxDoc" />
|
|
<ScalarProperty Name="emesso" ColumnName="emesso" />
|
|
<ScalarProperty Name="Gruppo" ColumnName="Gruppo" />
|
|
<ScalarProperty Name="RagSoc" ColumnName="RagSoc" />
|
|
<ScalarProperty Name="num" ColumnName="num" />
|
|
<ScalarProperty Name="anno" ColumnName="anno" />
|
|
<ScalarProperty Name="Trim" ColumnName="Trim" />
|
|
<ScalarProperty Name="Mese" ColumnName="Mese" />
|
|
<ScalarProperty Name="netto" ColumnName="netto" />
|
|
<ScalarProperty Name="iva" ColumnName="iva" />
|
|
<ScalarProperty Name="importo" ColumnName="importo" />
|
|
<ScalarProperty Name="tipo" ColumnName="tipo" />
|
|
<ScalarProperty Name="idxCli" ColumnName="idxCli" />
|
|
<ScalarProperty Name="totPagato" ColumnName="totPagato" />
|
|
<ScalarProperty Name="totScadenze" ColumnName="totScadenze" />
|
|
<ScalarProperty Name="Descrizione" ColumnName="Descrizione" />
|
|
<ScalarProperty Name="ritenuta" ColumnName="ritenuta" />
|
|
<ScalarProperty Name="CostiAss" ColumnName="CostiAss" />
|
|
</ComplexTypeMapping>
|
|
</ResultMapping>
|
|
</FunctionImportMapping>
|
|
<FunctionImportMapping FunctionImportName="stp_docs_insert" FunctionName="MAPModel.Store.stp_docs_insert" />
|
|
<FunctionImportMapping FunctionImportName="stp_docs_update" FunctionName="MAPModel.Store.stp_docs_update" />
|
|
<FunctionImportMapping FunctionImportName="stp_docRows_addNew" FunctionName="MAPModel.Store.stp_docRows_addNew" />
|
|
<FunctionImportMapping FunctionImportName="stp_docRows_copy2doc" FunctionName="MAPModel.Store.stp_docRows_copy2doc" />
|
|
<FunctionImportMapping FunctionImportName="stp_docs_cloneTemplate" FunctionName="MAPModel.Store.stp_docs_cloneTemplate" />
|
|
<EntitySetMapping Name="RowTemplate">
|
|
<EntityTypeMapping TypeName="MAPModel.RowTemplate">
|
|
<MappingFragment StoreEntitySet="v_RowTemplate">
|
|
<ScalarProperty Name="iva" ColumnName="iva" />
|
|
<ScalarProperty Name="netto" ColumnName="netto" />
|
|
<ScalarProperty Name="importo" ColumnName="importo" />
|
|
<ScalarProperty Name="Descrizione" ColumnName="Descrizione" />
|
|
<ScalarProperty Name="IdxRigheFatt" ColumnName="IdxRigheFatt" />
|
|
</MappingFragment>
|
|
</EntityTypeMapping>
|
|
</EntitySetMapping>
|
|
<EntitySetMapping Name="ResocontoIvaFatt">
|
|
<EntityTypeMapping TypeName="MAPModel.ResocontoIvaFatt">
|
|
<MappingFragment StoreEntitySet="v_ResocontoIvaFatt">
|
|
<ScalarProperty Name="totale" ColumnName="totale" />
|
|
<ScalarProperty Name="imposta" ColumnName="imposta" />
|
|
<ScalarProperty Name="imponibile" ColumnName="imponibile" />
|
|
<ScalarProperty Name="iva" ColumnName="iva" />
|
|
<ScalarProperty Name="Idxfatt" ColumnName="Idxfatt" />
|
|
<ScalarProperty Name="RN" ColumnName="RN" />
|
|
</MappingFragment>
|
|
</EntityTypeMapping>
|
|
</EntitySetMapping>
|
|
<EntitySetMapping Name="VAT">
|
|
<EntityTypeMapping TypeName="MAPModel.VAT">
|
|
<MappingFragment StoreEntitySet="C_iva">
|
|
<ScalarProperty Name="splitPay" ColumnName="splitPay" />
|
|
<ScalarProperty Name="enabled" ColumnName="enabled" />
|
|
<ScalarProperty Name="descrizione" ColumnName="descrizione" />
|
|
<ScalarProperty Name="iva" ColumnName="iva" />
|
|
<ScalarProperty Name="C_iva" ColumnName="C_iva" />
|
|
</MappingFragment>
|
|
</EntityTypeMapping>
|
|
</EntitySetMapping>
|
|
<FunctionImportMapping FunctionImportName="stp_VAT_deleteQuery" FunctionName="MAPModel.Store.stp_VAT_deleteQuery" />
|
|
<FunctionImportMapping FunctionImportName="stp_VAT_updateQuery" FunctionName="MAPModel.Store.stp_VAT_updateQuery" />
|
|
<EntitySetMapping Name="KVPlist">
|
|
<EntityTypeMapping TypeName="MAPModel.KVPlist">
|
|
<MappingFragment StoreEntitySet="KVPlist">
|
|
<ScalarProperty Name="strVal" ColumnName="strVal" />
|
|
<ScalarProperty Name="strKey" ColumnName="strKey" />
|
|
</MappingFragment>
|
|
</EntityTypeMapping>
|
|
</EntitySetMapping>
|
|
<FunctionImportMapping FunctionImportName="stp_listValues_getValidValuesTrad" FunctionName="MAPModel.Store.stp_listValues_getValidValuesTrad">
|
|
</FunctionImportMapping>
|
|
<EntitySetMapping Name="ResGiorn">
|
|
<EntityTypeMapping TypeName="MAPModel.ResGiorn">
|
|
<MappingFragment StoreEntitySet="v_resGiorn">
|
|
<ScalarProperty Name="totImporto" ColumnName="totImporto" />
|
|
<ScalarProperty Name="totIva" ColumnName="totIva" />
|
|
<ScalarProperty Name="totNetto" ColumnName="totNetto" />
|
|
<ScalarProperty Name="numDoc" ColumnName="numDoc" />
|
|
<ScalarProperty Name="giorno" ColumnName="giorno" />
|
|
<ScalarProperty Name="mese" ColumnName="mese" />
|
|
<ScalarProperty Name="anno" ColumnName="anno" />
|
|
</MappingFragment>
|
|
</EntityTypeMapping>
|
|
</EntitySetMapping>
|
|
<EntitySetMapping Name="ResMens">
|
|
<EntityTypeMapping TypeName="MAPModel.ResMens">
|
|
<MappingFragment StoreEntitySet="v_resMens">
|
|
<ScalarProperty Name="totImporto" ColumnName="totImporto" />
|
|
<ScalarProperty Name="totIva" ColumnName="totIva" />
|
|
<ScalarProperty Name="totNetto" ColumnName="totNetto" />
|
|
<ScalarProperty Name="numDoc" ColumnName="numDoc" />
|
|
<ScalarProperty Name="mese" ColumnName="mese" />
|
|
<ScalarProperty Name="anno" ColumnName="anno" />
|
|
</MappingFragment>
|
|
</EntityTypeMapping>
|
|
</EntitySetMapping>
|
|
<FunctionImportMapping FunctionImportName="stp_ResGiornFilt" FunctionName="MAPModel.Store.stp_ResGiornFilt">
|
|
</FunctionImportMapping>
|
|
<FunctionImportMapping FunctionImportName="stp_ResMensFilt" FunctionName="MAPModel.Store.stp_ResMensFilt">
|
|
</FunctionImportMapping>
|
|
</EntityContainerMapping>
|
|
</Mapping>
|
|
</edmx:Mappings>
|
|
</edmx:Runtime>
|
|
<!-- EF Designer content (DO NOT EDIT MANUALLY BELOW HERE) -->
|
|
<Designer xmlns="http://schemas.microsoft.com/ado/2009/11/edmx">
|
|
<Connection>
|
|
<DesignerInfoPropertySet>
|
|
<DesignerProperty Name="MetadataArtifactProcessing" Value="EmbedInOutputAssembly" />
|
|
</DesignerInfoPropertySet>
|
|
</Connection>
|
|
<Options>
|
|
<DesignerInfoPropertySet>
|
|
<DesignerProperty Name="ValidateOnBuild" Value="true" />
|
|
<DesignerProperty Name="EnablePluralization" Value="false" />
|
|
<DesignerProperty Name="IncludeForeignKeysInModel" Value="true" />
|
|
<DesignerProperty Name="UseLegacyProvider" Value="false" />
|
|
<DesignerProperty Name="CodeGenerationStrategy" Value="Nessuno" />
|
|
</DesignerInfoPropertySet>
|
|
</Options>
|
|
<!-- Diagram content (shape and connector positions) -->
|
|
<Diagrams></Diagrams>
|
|
</Designer>
|
|
</edmx:Edmx> |