Samuele E. Locatelli
236 lines
14 KiB
XML
236 lines
14 KiB
XML
<?xml version="1.0" encoding="utf-8"?>
|
|
<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" />
|
|
<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" />
|
|
<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 FunctionImportName="stp_ResMensFilt" FunctionName="MAPModel.Store.stp_ResMensFilt" />
|
|
</EntityContainerMapping>
|
|
</Mapping> |