Samuele E. Locatelli
459 lines
26 KiB
XML
459 lines
26 KiB
XML
<?xml version="1.0" encoding="utf-8"?>
|
|
<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> |