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