Samuele E. Locatelli
945 lines
54 KiB
XML
945 lines
54 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="StockManModel.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="CountersList">
|
|
<Key>
|
|
<PropertyRef Name="ID" />
|
|
</Key>
|
|
<Property Name="ID" Type="varchar" MaxLength="50" Nullable="false" />
|
|
<Property Name="NextNum" Type="int" Nullable="false" />
|
|
</EntityType>
|
|
<EntityType Name="Item">
|
|
<Key>
|
|
<PropertyRef Name="ID" />
|
|
</Key>
|
|
<Property Name="ID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
|
|
<Property Name="Descr" Type="nvarchar" MaxLength="250" Nullable="false" />
|
|
<Property Name="CodInt" Type="nvarchar" MaxLength="50" Nullable="false" />
|
|
<Property Name="ItemFamilyID" Type="nvarchar" MaxLength="50" Nullable="false" />
|
|
<Property Name="CodExt" Type="nvarchar" MaxLength="250" Nullable="false" />
|
|
<Property Name="DescrExt" Type="nvarchar" MaxLength="250" Nullable="false" />
|
|
<Property Name="QtaMin" Type="int" Nullable="false" />
|
|
<Property Name="QtaBatch" Type="int" Nullable="false" />
|
|
<Property Name="CurrValue" Type="decimal" Precision="18" Scale="6" Nullable="false" />
|
|
<Property Name="QtaCurr" Type="int" StoreGeneratedPattern="Computed" />
|
|
<Property Name="QtaPend" Type="int" StoreGeneratedPattern="Computed" />
|
|
<Property Name="UM" Type="nvarchar" MaxLength="50" Nullable="false" />
|
|
</EntityType>
|
|
<EntityType Name="ItemFamily">
|
|
<Key>
|
|
<PropertyRef Name="ID" />
|
|
</Key>
|
|
<Property Name="ID" Type="nvarchar" MaxLength="50" Nullable="false" />
|
|
<Property Name="Descr" Type="nvarchar" MaxLength="50" Nullable="false" />
|
|
<Property Name="NumItems" Type="int" StoreGeneratedPattern="Computed" />
|
|
</EntityType>
|
|
<EntityType Name="ItemFlux">
|
|
<Key>
|
|
<PropertyRef Name="ID" />
|
|
</Key>
|
|
<Property Name="ID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
|
|
<Property Name="ItemID" Type="int" Nullable="false" />
|
|
<Property Name="LocationID" Type="nvarchar" MaxLength="50" Nullable="false" />
|
|
<Property Name="MovTypeID" Type="nvarchar" MaxLength="50" Nullable="false" />
|
|
<Property Name="ExtLocationID" Type="nvarchar" MaxLength="50" Nullable="false" />
|
|
<Property Name="dtMov" Type="date" Nullable="false" />
|
|
<Property Name="Qta" Type="int" Nullable="false" />
|
|
<Property Name="TotValue" Type="decimal" Precision="18" Scale="6" Nullable="false" />
|
|
<Property Name="UnitVal" Type="decimal" Precision="29" Scale="17" StoreGeneratedPattern="Computed" Nullable="false" />
|
|
<Property Name="OperatorID" Type="nvarchar" MaxLength="50" Nullable="false" />
|
|
<Property Name="Note" Type="nvarchar" MaxLength="250" Nullable="false" />
|
|
<Property Name="CodDoc" Type="nvarchar" MaxLength="250" Nullable="false" />
|
|
<Property Name="dtExport" Type="date" />
|
|
<Property Name="ModOperatorID" Type="nvarchar" MaxLength="50" Nullable="false" />
|
|
</EntityType>
|
|
<EntityType Name="ItemStock">
|
|
<Key>
|
|
<PropertyRef Name="ID" />
|
|
</Key>
|
|
<Property Name="ID" Type="int" StoreGeneratedPattern="Identity" Nullable="false" />
|
|
<Property Name="ItemID" Type="int" Nullable="false" />
|
|
<Property Name="LocationID" Type="nvarchar" MaxLength="50" Nullable="false" />
|
|
<Property Name="QtyConf" Type="int" Nullable="false" />
|
|
<Property Name="Note" Type="nvarchar(max)" Nullable="false" />
|
|
<Property Name="dtLastUpd" Type="datetime" Nullable="false" />
|
|
</EntityType>
|
|
<EntityType Name="Location">
|
|
<Key>
|
|
<PropertyRef Name="ID" />
|
|
</Key>
|
|
<Property Name="ID" Type="nvarchar" MaxLength="50" Nullable="false" />
|
|
<Property Name="Descr" Type="nvarchar" MaxLength="50" Nullable="false" />
|
|
<Property Name="LocTypeID" Type="varchar" MaxLength="50" Nullable="false" />
|
|
</EntityType>
|
|
<EntityType Name="LocType">
|
|
<Key>
|
|
<PropertyRef Name="ID" />
|
|
</Key>
|
|
<Property Name="ID" Type="varchar" MaxLength="50" Nullable="false" />
|
|
<Property Name="Descr" Type="nvarchar" MaxLength="250" Nullable="false" />
|
|
<Property Name="IsStock" Type="bit" Nullable="false" />
|
|
<Property Name="IsCli" Type="bit" Nullable="false" />
|
|
<Property Name="IsFor" Type="bit" Nullable="false" />
|
|
</EntityType>
|
|
<EntityType Name="MovType">
|
|
<Key>
|
|
<PropertyRef Name="ID" />
|
|
</Key>
|
|
<Property Name="ID" Type="nvarchar" MaxLength="50" Nullable="false" />
|
|
<Property Name="Descr" Type="nvarchar" MaxLength="250" Nullable="false" />
|
|
<Property Name="CssClass" Type="nvarchar" MaxLength="50" />
|
|
</EntityType>
|
|
<EntityType Name="Operator">
|
|
<Key>
|
|
<PropertyRef Name="ID" />
|
|
</Key>
|
|
<Property Name="ID" Type="nvarchar" MaxLength="50" Nullable="false" />
|
|
<Property Name="CodExt" Type="nvarchar" MaxLength="50" Nullable="false" />
|
|
<Property Name="LastName" Type="nvarchar" MaxLength="50" Nullable="false" />
|
|
<Property Name="FirstName" Type="nvarchar" MaxLength="50" Nullable="false" />
|
|
</EntityType>
|
|
<!--Errori trovati durante la generazione:
|
|
avviso 6002: Nessuna chiave primaria definita per la tabella/visualizzazione 'StockMan.dbo.vItemFlux2Save'. La chiave è stata dedotta e la definizione è stata creata come tabella/visualizzazione di sola lettura.-->
|
|
<EntityType Name="vItemFlux2Save">
|
|
<Key>
|
|
<PropertyRef Name="ItemID" />
|
|
</Key>
|
|
<Property Name="ItemID" Type="int" Nullable="false" />
|
|
<Property Name="NumMov" Type="int" />
|
|
<Property Name="TotQta" Type="int" />
|
|
<Property Name="TotQtaOrd" Type="int" />
|
|
<Property Name="TotQtaCar" Type="int" />
|
|
<Property Name="TotValCar" Type="decimal" Precision="38" Scale="6" />
|
|
</EntityType>
|
|
<!--Errori trovati durante la generazione:
|
|
avviso 6002: Nessuna chiave primaria definita per la tabella/visualizzazione 'StockMan.dbo.vLocationVal'. La chiave è stata dedotta e la definizione è stata creata come tabella/visualizzazione di sola lettura.-->
|
|
<EntityType Name="vLocationVal">
|
|
<Key>
|
|
<PropertyRef Name="LocationID" />
|
|
</Key>
|
|
<Property Name="LocationID" Type="nvarchar" MaxLength="50" Nullable="false" />
|
|
<Property Name="TotVal" Type="decimal" Precision="38" Scale="6" />
|
|
<Property Name="NumArt" Type="int" />
|
|
<Property Name="TotCurr" Type="int" />
|
|
<Property Name="TotPend" Type="int" />
|
|
</EntityType>
|
|
<Association Name="FK_Item_ItemFamily">
|
|
<End Role="ItemFamily" Type="Self.ItemFamily" Multiplicity="1" />
|
|
<End Role="Item" Type="Self.Item" Multiplicity="*" />
|
|
<ReferentialConstraint>
|
|
<Principal Role="ItemFamily">
|
|
<PropertyRef Name="ID" />
|
|
</Principal>
|
|
<Dependent Role="Item">
|
|
<PropertyRef Name="ItemFamilyID" />
|
|
</Dependent>
|
|
</ReferentialConstraint>
|
|
</Association>
|
|
<Association Name="FK_ItemFlux_Item">
|
|
<End Role="Item" Type="Self.Item" Multiplicity="1" />
|
|
<End Role="ItemFlux" Type="Self.ItemFlux" Multiplicity="*" />
|
|
<ReferentialConstraint>
|
|
<Principal Role="Item">
|
|
<PropertyRef Name="ID" />
|
|
</Principal>
|
|
<Dependent Role="ItemFlux">
|
|
<PropertyRef Name="ItemID" />
|
|
</Dependent>
|
|
</ReferentialConstraint>
|
|
</Association>
|
|
<Association Name="FK_ItemFlux_Location">
|
|
<End Role="Location" Type="Self.Location" Multiplicity="1" />
|
|
<End Role="ItemFlux" Type="Self.ItemFlux" Multiplicity="*" />
|
|
<ReferentialConstraint>
|
|
<Principal Role="Location">
|
|
<PropertyRef Name="ID" />
|
|
</Principal>
|
|
<Dependent Role="ItemFlux">
|
|
<PropertyRef Name="LocationID" />
|
|
</Dependent>
|
|
</ReferentialConstraint>
|
|
</Association>
|
|
<Association Name="FK_ItemFlux_Location1">
|
|
<End Role="Location" Type="Self.Location" Multiplicity="1" />
|
|
<End Role="ItemFlux" Type="Self.ItemFlux" Multiplicity="*" />
|
|
<ReferentialConstraint>
|
|
<Principal Role="Location">
|
|
<PropertyRef Name="ID" />
|
|
</Principal>
|
|
<Dependent Role="ItemFlux">
|
|
<PropertyRef Name="ExtLocationID" />
|
|
</Dependent>
|
|
</ReferentialConstraint>
|
|
</Association>
|
|
<Association Name="FK_ItemFlux_Operator">
|
|
<End Role="Operator" Type="Self.Operator" Multiplicity="1" />
|
|
<End Role="ItemFlux" Type="Self.ItemFlux" Multiplicity="*" />
|
|
<ReferentialConstraint>
|
|
<Principal Role="Operator">
|
|
<PropertyRef Name="ID" />
|
|
</Principal>
|
|
<Dependent Role="ItemFlux">
|
|
<PropertyRef Name="OperatorID" />
|
|
</Dependent>
|
|
</ReferentialConstraint>
|
|
</Association>
|
|
<Association Name="FK_ItemFlux_Operator1">
|
|
<End Role="Operator" Type="Self.Operator" Multiplicity="1" />
|
|
<End Role="ItemFlux" Type="Self.ItemFlux" Multiplicity="*" />
|
|
<ReferentialConstraint>
|
|
<Principal Role="Operator">
|
|
<PropertyRef Name="ID" />
|
|
</Principal>
|
|
<Dependent Role="ItemFlux">
|
|
<PropertyRef Name="ModOperatorID" />
|
|
</Dependent>
|
|
</ReferentialConstraint>
|
|
</Association>
|
|
<Association Name="FK_Location_LocType1">
|
|
<End Role="LocType" Type="Self.LocType" Multiplicity="1" />
|
|
<End Role="Location" Type="Self.Location" Multiplicity="*" />
|
|
<ReferentialConstraint>
|
|
<Principal Role="LocType">
|
|
<PropertyRef Name="ID" />
|
|
</Principal>
|
|
<Dependent Role="Location">
|
|
<PropertyRef Name="LocTypeID" />
|
|
</Dependent>
|
|
</ReferentialConstraint>
|
|
</Association>
|
|
<Association Name="FK_Stock_Items">
|
|
<End Role="Item" Type="Self.Item" Multiplicity="1" />
|
|
<End Role="ItemStock" Type="Self.ItemStock" Multiplicity="*" />
|
|
<ReferentialConstraint>
|
|
<Principal Role="Item">
|
|
<PropertyRef Name="ID" />
|
|
</Principal>
|
|
<Dependent Role="ItemStock">
|
|
<PropertyRef Name="ItemID" />
|
|
</Dependent>
|
|
</ReferentialConstraint>
|
|
</Association>
|
|
<Association Name="FK_Stock_Location1">
|
|
<End Role="Location" Type="Self.Location" Multiplicity="1" />
|
|
<End Role="ItemStock" Type="Self.ItemStock" Multiplicity="*" />
|
|
<ReferentialConstraint>
|
|
<Principal Role="Location">
|
|
<PropertyRef Name="ID" />
|
|
</Principal>
|
|
<Dependent Role="ItemStock">
|
|
<PropertyRef Name="LocationID" />
|
|
</Dependent>
|
|
</ReferentialConstraint>
|
|
</Association>
|
|
<Association Name="FK_StockMov_MovType">
|
|
<End Role="MovType" Type="Self.MovType" Multiplicity="1" />
|
|
<End Role="ItemFlux" Type="Self.ItemFlux" Multiplicity="*" />
|
|
<ReferentialConstraint>
|
|
<Principal Role="MovType">
|
|
<PropertyRef Name="ID" />
|
|
</Principal>
|
|
<Dependent Role="ItemFlux">
|
|
<PropertyRef Name="MovTypeID" />
|
|
</Dependent>
|
|
</ReferentialConstraint>
|
|
</Association>
|
|
<Function Name="stp_Counters_getNext" Aggregate="false" BuiltIn="false" NiladicFunction="false" IsComposable="false" ParameterTypeSemantics="AllowImplicitConversion" Schema="dbo">
|
|
<Parameter Name="ID" Type="nvarchar" Mode="In" />
|
|
</Function>
|
|
<Function Name="stp_ItemConsolidate" Aggregate="false" BuiltIn="false" NiladicFunction="false" IsComposable="false" ParameterTypeSemantics="AllowImplicitConversion" Schema="dbo">
|
|
<Parameter Name="ItemID" Type="int" Mode="In" />
|
|
</Function>
|
|
<Function Name="stp_ItemDuplicate" Aggregate="false" BuiltIn="false" NiladicFunction="false" IsComposable="false" ParameterTypeSemantics="AllowImplicitConversion" Schema="dbo">
|
|
<Parameter Name="Original_ID" Type="int" Mode="In" />
|
|
</Function>
|
|
<Function Name="stp_ItemFluxDuplicate" Aggregate="false" BuiltIn="false" NiladicFunction="false" IsComposable="false" ParameterTypeSemantics="AllowImplicitConversion" Schema="dbo">
|
|
<Parameter Name="Original_ID" Type="int" Mode="In" />
|
|
</Function>
|
|
<Function Name="stp_ItemResetAll" Aggregate="false" BuiltIn="false" NiladicFunction="false" IsComposable="false" ParameterTypeSemantics="AllowImplicitConversion" Schema="dbo">
|
|
<Parameter Name="ItemID" Type="int" Mode="In" />
|
|
</Function>
|
|
<Function Name="stp_ItemShrinkHist" Aggregate="false" BuiltIn="false" NiladicFunction="false" IsComposable="false" ParameterTypeSemantics="AllowImplicitConversion" Schema="dbo">
|
|
<Parameter Name="ItemID" Type="int" Mode="In" />
|
|
</Function>
|
|
<Function Name="stp_ItemStockMove" Aggregate="false" BuiltIn="false" NiladicFunction="false" IsComposable="false" ParameterTypeSemantics="AllowImplicitConversion" Schema="dbo">
|
|
<Parameter Name="StockID" Type="int" Mode="In" />
|
|
<Parameter Name="LocationID_FROM" Type="nvarchar" Mode="In" />
|
|
<Parameter Name="LocationID_TO" Type="nvarchar" Mode="In" />
|
|
<Parameter Name="OperatorID" Type="nvarchar" Mode="In" />
|
|
</Function>
|
|
<Function Name="stp_ItemStockMove_New" Aggregate="false" BuiltIn="false" NiladicFunction="false" IsComposable="false" ParameterTypeSemantics="AllowImplicitConversion" Schema="dbo">
|
|
<Parameter Name="StockID" Type="int" Mode="In" />
|
|
<Parameter Name="LocationID_FROM" Type="nvarchar" Mode="In" />
|
|
<Parameter Name="LocationID_TO" Type="nvarchar" Mode="In" />
|
|
<Parameter Name="OperatorID" Type="nvarchar" Mode="In" />
|
|
<Parameter Name="QtyMov" Type="int" Mode="In" />
|
|
</Function>
|
|
<EntityContainer Name="StockManModelStoreContainer">
|
|
<EntitySet Name="CountersList" EntityType="Self.CountersList" Schema="dbo" store:Type="Tables" />
|
|
<EntitySet Name="Item" EntityType="Self.Item" Schema="dbo" store:Type="Tables" />
|
|
<EntitySet Name="ItemFamily" EntityType="Self.ItemFamily" Schema="dbo" store:Type="Tables" />
|
|
<EntitySet Name="ItemFlux" EntityType="Self.ItemFlux" Schema="dbo" store:Type="Tables" />
|
|
<EntitySet Name="ItemStock" EntityType="Self.ItemStock" Schema="dbo" store:Type="Tables" />
|
|
<EntitySet Name="Location" EntityType="Self.Location" Schema="dbo" store:Type="Tables" />
|
|
<EntitySet Name="LocType" EntityType="Self.LocType" Schema="dbo" store:Type="Tables" />
|
|
<EntitySet Name="MovType" EntityType="Self.MovType" Schema="dbo" store:Type="Tables" />
|
|
<EntitySet Name="Operator" EntityType="Self.Operator" Schema="dbo" store:Type="Tables" />
|
|
<EntitySet Name="vItemFlux2Save" EntityType="Self.vItemFlux2Save" store:Type="Views" store:Schema="dbo">
|
|
<DefiningQuery>SELECT
|
|
[vItemFlux2Save].[ItemID] AS [ItemID],
|
|
[vItemFlux2Save].[NumMov] AS [NumMov],
|
|
[vItemFlux2Save].[TotQta] AS [TotQta],
|
|
[vItemFlux2Save].[TotQtaOrd] AS [TotQtaOrd],
|
|
[vItemFlux2Save].[TotQtaCar] AS [TotQtaCar],
|
|
[vItemFlux2Save].[TotValCar] AS [TotValCar]
|
|
FROM [dbo].[vItemFlux2Save] AS [vItemFlux2Save]</DefiningQuery>
|
|
</EntitySet>
|
|
<EntitySet Name="vLocationVal" EntityType="Self.vLocationVal" store:Type="Views" store:Schema="dbo">
|
|
<DefiningQuery>SELECT
|
|
[vLocationVal].[LocationID] AS [LocationID],
|
|
[vLocationVal].[TotVal] AS [TotVal],
|
|
[vLocationVal].[NumArt] AS [NumArt],
|
|
[vLocationVal].[TotCurr] AS [TotCurr],
|
|
[vLocationVal].[TotPend] AS [TotPend]
|
|
FROM [dbo].[vLocationVal] AS [vLocationVal]</DefiningQuery>
|
|
</EntitySet>
|
|
<AssociationSet Name="FK_Item_ItemFamily" Association="Self.FK_Item_ItemFamily">
|
|
<End Role="ItemFamily" EntitySet="ItemFamily" />
|
|
<End Role="Item" EntitySet="Item" />
|
|
</AssociationSet>
|
|
<AssociationSet Name="FK_ItemFlux_Item" Association="Self.FK_ItemFlux_Item">
|
|
<End Role="Item" EntitySet="Item" />
|
|
<End Role="ItemFlux" EntitySet="ItemFlux" />
|
|
</AssociationSet>
|
|
<AssociationSet Name="FK_ItemFlux_Location" Association="Self.FK_ItemFlux_Location">
|
|
<End Role="Location" EntitySet="Location" />
|
|
<End Role="ItemFlux" EntitySet="ItemFlux" />
|
|
</AssociationSet>
|
|
<AssociationSet Name="FK_ItemFlux_Location1" Association="Self.FK_ItemFlux_Location1">
|
|
<End Role="Location" EntitySet="Location" />
|
|
<End Role="ItemFlux" EntitySet="ItemFlux" />
|
|
</AssociationSet>
|
|
<AssociationSet Name="FK_ItemFlux_Operator" Association="Self.FK_ItemFlux_Operator">
|
|
<End Role="Operator" EntitySet="Operator" />
|
|
<End Role="ItemFlux" EntitySet="ItemFlux" />
|
|
</AssociationSet>
|
|
<AssociationSet Name="FK_ItemFlux_Operator1" Association="Self.FK_ItemFlux_Operator1">
|
|
<End Role="Operator" EntitySet="Operator" />
|
|
<End Role="ItemFlux" EntitySet="ItemFlux" />
|
|
</AssociationSet>
|
|
<AssociationSet Name="FK_Location_LocType1" Association="Self.FK_Location_LocType1">
|
|
<End Role="LocType" EntitySet="LocType" />
|
|
<End Role="Location" EntitySet="Location" />
|
|
</AssociationSet>
|
|
<AssociationSet Name="FK_Stock_Items" Association="Self.FK_Stock_Items">
|
|
<End Role="Item" EntitySet="Item" />
|
|
<End Role="ItemStock" EntitySet="ItemStock" />
|
|
</AssociationSet>
|
|
<AssociationSet Name="FK_Stock_Location1" Association="Self.FK_Stock_Location1">
|
|
<End Role="Location" EntitySet="Location" />
|
|
<End Role="ItemStock" EntitySet="ItemStock" />
|
|
</AssociationSet>
|
|
<AssociationSet Name="FK_StockMov_MovType" Association="Self.FK_StockMov_MovType">
|
|
<End Role="MovType" EntitySet="MovType" />
|
|
<End Role="ItemFlux" EntitySet="ItemFlux" />
|
|
</AssociationSet>
|
|
</EntityContainer>
|
|
</Schema>
|
|
</edmx:StorageModels>
|
|
<!-- CSDL content -->
|
|
<edmx:ConceptualModels>
|
|
<Schema Namespace="StockManModel" 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">
|
|
<EntityType Name="ItemFlux">
|
|
<Key>
|
|
<PropertyRef Name="ID" />
|
|
</Key>
|
|
<Property Name="ID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
|
|
<Property Name="ItemID" Type="Int32" Nullable="false" />
|
|
<Property Name="LocationID" Type="String" MaxLength="50" FixedLength="false" Unicode="true" Nullable="false" />
|
|
<Property Name="MovTypeID" Type="String" MaxLength="50" FixedLength="false" Unicode="true" Nullable="false" />
|
|
<Property Name="ExtLocationID" Type="String" MaxLength="50" FixedLength="false" Unicode="true" Nullable="false" />
|
|
<Property Name="dtMov" Type="DateTime" Nullable="false" Precision="0" />
|
|
<Property Name="Qta" Type="Int32" Nullable="false" />
|
|
<Property Name="TotValue" Type="Decimal" Precision="18" Scale="6" Nullable="false" />
|
|
<Property Name="UnitVal" Type="Decimal" Precision="29" Scale="17" annotation:StoreGeneratedPattern="Computed" Nullable="false" />
|
|
<Property Name="Note" Type="String" MaxLength="250" FixedLength="false" Unicode="true" Nullable="false" />
|
|
<Property Name="dtExport" Type="DateTime" Precision="0" />
|
|
<NavigationProperty Name="Location" Relationship="Self.FK_ItemFlux_Location" FromRole="ItemFlux" ToRole="Location" />
|
|
<NavigationProperty Name="MovType" Relationship="Self.FK_StockMov_MovType" FromRole="ItemFlux" ToRole="MovType" />
|
|
<NavigationProperty Name="Item" Relationship="StockManModel.FK_ItemFlux_Item" FromRole="ItemFlux" ToRole="Item" />
|
|
<Property Name="OperatorID" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" />
|
|
<NavigationProperty Name="Operator" Relationship="StockManModel.FK_ItemFlux_Operator" FromRole="ItemFlux" ToRole="Operator" />
|
|
<NavigationProperty Name="Location1" Relationship="StockManModel.FK_ItemFlux_Location1" FromRole="ItemFlux" ToRole="Location" />
|
|
<Property Name="CodDoc" Type="String" Nullable="false" MaxLength="250" FixedLength="false" Unicode="true" />
|
|
<Property Name="ModOperatorID" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" />
|
|
<NavigationProperty Name="Operator1" Relationship="StockManModel.FK_ItemFlux_Operator1" FromRole="ItemFlux" ToRole="Operator" />
|
|
</EntityType>
|
|
<EntityType Name="ItemStock">
|
|
<Key>
|
|
<PropertyRef Name="ID" />
|
|
</Key>
|
|
<Property Name="ID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
|
|
<Property Name="ItemID" Type="Int32" Nullable="false" />
|
|
<Property Name="LocationID" Type="String" MaxLength="50" FixedLength="false" Unicode="true" Nullable="false" />
|
|
<Property Name="QtyConf" Type="Int32" Nullable="false" />
|
|
<Property Name="Note" Type="String" MaxLength="Max" FixedLength="false" Unicode="true" Nullable="false" />
|
|
<Property Name="dtLastUpd" Type="DateTime" Nullable="false" Precision="3" />
|
|
<NavigationProperty Name="Location" Relationship="Self.FK_Stock_Location1" FromRole="ItemStock" ToRole="Location" />
|
|
<NavigationProperty Name="Item" Relationship="StockManModel.FK_Stock_Items" FromRole="ItemStock" ToRole="Item" />
|
|
</EntityType>
|
|
<EntityType Name="Location">
|
|
<Key>
|
|
<PropertyRef Name="ID" />
|
|
</Key>
|
|
<Property Name="ID" Type="String" MaxLength="50" FixedLength="false" Unicode="true" Nullable="false" />
|
|
<Property Name="Descr" Type="String" MaxLength="50" FixedLength="false" Unicode="true" Nullable="false" />
|
|
<Property Name="LocTypeID" Type="String" MaxLength="50" FixedLength="false" Unicode="false" Nullable="false" />
|
|
<NavigationProperty Name="ItemFlux" Relationship="Self.FK_ItemFlux_Location" FromRole="Location" ToRole="ItemFlux" />
|
|
<NavigationProperty Name="ItemStock" Relationship="Self.FK_Stock_Location1" FromRole="Location" ToRole="ItemStock" />
|
|
<NavigationProperty Name="LocType" Relationship="Self.FK_Location_LocType1" FromRole="Location" ToRole="LocType" />
|
|
<NavigationProperty Name="ItemFlux1" Relationship="StockManModel.FK_ItemFlux_Location1" FromRole="Location" ToRole="ItemFlux" />
|
|
<NavigationProperty Name="vLocationVal" Relationship="StockManModel.LocationvLocationVal" FromRole="Location" ToRole="vLocationVal" />
|
|
</EntityType>
|
|
<EntityType Name="LocType">
|
|
<Key>
|
|
<PropertyRef Name="ID" />
|
|
</Key>
|
|
<Property Name="ID" Type="String" MaxLength="50" FixedLength="false" Unicode="false" Nullable="false" />
|
|
<Property Name="Descr" Type="String" MaxLength="250" FixedLength="false" Unicode="true" Nullable="false" />
|
|
<Property Name="IsStock" Type="Boolean" Nullable="false" />
|
|
<Property Name="IsCli" Type="Boolean" Nullable="false" />
|
|
<Property Name="IsFor" Type="Boolean" Nullable="false" />
|
|
<NavigationProperty Name="Location" Relationship="Self.FK_Location_LocType1" FromRole="LocType" ToRole="Location" />
|
|
</EntityType>
|
|
<EntityType Name="MovType">
|
|
<Key>
|
|
<PropertyRef Name="ID" />
|
|
</Key>
|
|
<Property Name="ID" Type="String" MaxLength="50" FixedLength="false" Unicode="true" Nullable="false" />
|
|
<Property Name="Descr" Type="String" MaxLength="250" FixedLength="false" Unicode="true" Nullable="false" />
|
|
<NavigationProperty Name="ItemFlux" Relationship="Self.FK_StockMov_MovType" FromRole="MovType" ToRole="ItemFlux" />
|
|
<Property Name="CssClass" Type="String" MaxLength="50" FixedLength="false" Unicode="true" />
|
|
</EntityType>
|
|
<Association Name="FK_ItemFlux_Location">
|
|
<End Role="Location" Type="Self.Location" Multiplicity="1" />
|
|
<End Role="ItemFlux" Type="Self.ItemFlux" Multiplicity="*" />
|
|
<ReferentialConstraint>
|
|
<Principal Role="Location">
|
|
<PropertyRef Name="ID" />
|
|
</Principal>
|
|
<Dependent Role="ItemFlux">
|
|
<PropertyRef Name="LocationID" />
|
|
</Dependent>
|
|
</ReferentialConstraint>
|
|
</Association>
|
|
<Association Name="FK_StockMov_MovType">
|
|
<End Role="MovType" Type="Self.MovType" Multiplicity="1" />
|
|
<End Role="ItemFlux" Type="Self.ItemFlux" Multiplicity="*" />
|
|
<ReferentialConstraint>
|
|
<Principal Role="MovType">
|
|
<PropertyRef Name="ID" />
|
|
</Principal>
|
|
<Dependent Role="ItemFlux">
|
|
<PropertyRef Name="MovTypeID" />
|
|
</Dependent>
|
|
</ReferentialConstraint>
|
|
</Association>
|
|
<Association Name="FK_Stock_Location1">
|
|
<End Role="Location" Type="Self.Location" Multiplicity="1" />
|
|
<End Role="ItemStock" Type="Self.ItemStock" Multiplicity="*" />
|
|
<ReferentialConstraint>
|
|
<Principal Role="Location">
|
|
<PropertyRef Name="ID" />
|
|
</Principal>
|
|
<Dependent Role="ItemStock">
|
|
<PropertyRef Name="LocationID" />
|
|
</Dependent>
|
|
</ReferentialConstraint>
|
|
</Association>
|
|
<Association Name="FK_Location_LocType1">
|
|
<End Role="LocType" Type="Self.LocType" Multiplicity="1" />
|
|
<End Role="Location" Type="Self.Location" Multiplicity="*" />
|
|
<ReferentialConstraint>
|
|
<Principal Role="LocType">
|
|
<PropertyRef Name="ID" />
|
|
</Principal>
|
|
<Dependent Role="Location">
|
|
<PropertyRef Name="LocTypeID" />
|
|
</Dependent>
|
|
</ReferentialConstraint>
|
|
</Association>
|
|
<EntityContainer Name="StockManEntities" annotation:LazyLoadingEnabled="true">
|
|
<EntitySet Name="ItemFlux" EntityType="Self.ItemFlux" />
|
|
<EntitySet Name="ItemStock" EntityType="Self.ItemStock" />
|
|
<EntitySet Name="Location" EntityType="Self.Location" />
|
|
<EntitySet Name="LocType" EntityType="Self.LocType" />
|
|
<EntitySet Name="MovType" EntityType="Self.MovType" />
|
|
<AssociationSet Name="FK_ItemFlux_Location" Association="Self.FK_ItemFlux_Location">
|
|
<End Role="Location" EntitySet="Location" />
|
|
<End Role="ItemFlux" EntitySet="ItemFlux" />
|
|
</AssociationSet>
|
|
<AssociationSet Name="FK_StockMov_MovType" Association="Self.FK_StockMov_MovType">
|
|
<End Role="MovType" EntitySet="MovType" />
|
|
<End Role="ItemFlux" EntitySet="ItemFlux" />
|
|
</AssociationSet>
|
|
<AssociationSet Name="FK_Stock_Location1" Association="Self.FK_Stock_Location1">
|
|
<End Role="Location" EntitySet="Location" />
|
|
<End Role="ItemStock" EntitySet="ItemStock" />
|
|
</AssociationSet>
|
|
<AssociationSet Name="FK_Location_LocType1" Association="Self.FK_Location_LocType1">
|
|
<End Role="LocType" EntitySet="LocType" />
|
|
<End Role="Location" EntitySet="Location" />
|
|
</AssociationSet>
|
|
<EntitySet Name="ItemFamily" EntityType="StockManModel.ItemFamily" />
|
|
<EntitySet Name="Item" EntityType="StockManModel.Item" />
|
|
<AssociationSet Name="FK_Item_ItemFamily" Association="StockManModel.FK_Item_ItemFamily">
|
|
<End Role="ItemFamily" EntitySet="ItemFamily" />
|
|
<End Role="Item" EntitySet="Item" />
|
|
</AssociationSet>
|
|
<AssociationSet Name="FK_ItemFlux_Item" Association="StockManModel.FK_ItemFlux_Item">
|
|
<End Role="Item" EntitySet="Item" />
|
|
<End Role="ItemFlux" EntitySet="ItemFlux" />
|
|
</AssociationSet>
|
|
<AssociationSet Name="FK_Stock_Items" Association="StockManModel.FK_Stock_Items">
|
|
<End Role="Item" EntitySet="Item" />
|
|
<End Role="ItemStock" EntitySet="ItemStock" />
|
|
</AssociationSet>
|
|
<EntitySet Name="Operator" EntityType="StockManModel.Operator" />
|
|
<AssociationSet Name="FK_ItemFlux_Operator" Association="StockManModel.FK_ItemFlux_Operator">
|
|
<End Role="Operator" EntitySet="Operator" />
|
|
<End Role="ItemFlux" EntitySet="ItemFlux" />
|
|
</AssociationSet>
|
|
<AssociationSet Name="FK_ItemFlux_Location1" Association="StockManModel.FK_ItemFlux_Location1">
|
|
<End Role="Location" EntitySet="Location" />
|
|
<End Role="ItemFlux" EntitySet="ItemFlux" />
|
|
</AssociationSet>
|
|
<EntitySet Name="vItemFlux2Save" EntityType="StockManModel.vItemFlux2Save" />
|
|
<AssociationSet Name="ItemvItemFlux2Save" Association="StockManModel.ItemvItemFlux2Save">
|
|
<End Role="Item" EntitySet="Item" />
|
|
<End Role="vItemFlux2Save" EntitySet="vItemFlux2Save" />
|
|
</AssociationSet>
|
|
<FunctionImport Name="stp_ItemConsolidate">
|
|
<Parameter Name="ItemID" Mode="In" Type="Int32" />
|
|
</FunctionImport>
|
|
<FunctionImport Name="stp_ItemDuplicate" EntitySet="Item" ReturnType="Collection(StockManModel.Item)">
|
|
<Parameter Name="Original_ID" Mode="In" Type="Int32" />
|
|
</FunctionImport>
|
|
<EntitySet Name="vLocationVal" EntityType="StockManModel.vLocationVal" />
|
|
<AssociationSet Name="LocationvLocationVal" Association="StockManModel.LocationvLocationVal">
|
|
<End Role="Location" EntitySet="Location" />
|
|
<End Role="vLocationVal" EntitySet="vLocationVal" />
|
|
</AssociationSet>
|
|
<FunctionImport Name="stp_ItemStockMove">
|
|
<Parameter Name="StockID" Mode="In" Type="Int32" />
|
|
<Parameter Name="LocationID_FROM" Mode="In" Type="String" />
|
|
<Parameter Name="LocationID_TO" Mode="In" Type="String" />
|
|
<Parameter Name="OperatorID" Mode="In" Type="String" />
|
|
</FunctionImport>
|
|
<FunctionImport Name="stp_ItemStockMove_New">
|
|
<Parameter Name="StockID" Mode="In" Type="Int32" />
|
|
<Parameter Name="LocationID_FROM" Mode="In" Type="String" />
|
|
<Parameter Name="LocationID_TO" Mode="In" Type="String" />
|
|
<Parameter Name="OperatorID" Mode="In" Type="String" />
|
|
<Parameter Name="QtyMov" Mode="In" Type="Int32" />
|
|
</FunctionImport>
|
|
<FunctionImport Name="stp_ItemShrinkHist">
|
|
<Parameter Name="ItemID" Mode="In" Type="Int32" />
|
|
</FunctionImport>
|
|
<AssociationSet Name="FK_ItemFlux_Operator1" Association="StockManModel.FK_ItemFlux_Operator1">
|
|
<End Role="Operator" EntitySet="Operator" />
|
|
<End Role="ItemFlux" EntitySet="ItemFlux" />
|
|
</AssociationSet>
|
|
<EntitySet Name="CountersList" EntityType="StockManModel.CountersList" />
|
|
<FunctionImport Name="stp_Counters_getNext" EntitySet="CountersList" ReturnType="Collection(StockManModel.CountersList)">
|
|
<Parameter Name="ID" Mode="In" Type="String" />
|
|
</FunctionImport>
|
|
<FunctionImport Name="stp_ItemFluxDuplicate" EntitySet="ItemFlux" ReturnType="Collection(StockManModel.ItemFlux)">
|
|
<Parameter Name="Original_ID" Mode="In" Type="Int32" />
|
|
</FunctionImport>
|
|
<FunctionImport Name="stp_ItemResetAll">
|
|
<Parameter Name="ItemID" Mode="In" Type="Int32" />
|
|
</FunctionImport>
|
|
</EntityContainer>
|
|
<EntityType Name="ItemFamily">
|
|
<Key>
|
|
<PropertyRef Name="ID" />
|
|
</Key>
|
|
<Property Name="ID" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" />
|
|
<Property Name="Descr" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" />
|
|
<NavigationProperty Name="Item" Relationship="StockManModel.FK_Item_ItemFamily" FromRole="ItemFamily" ToRole="Item" />
|
|
<Property Name="NumItems" Type="Int32" annotation:StoreGeneratedPattern="Computed" />
|
|
</EntityType>
|
|
<EntityType Name="Item">
|
|
<Key>
|
|
<PropertyRef Name="ID" />
|
|
</Key>
|
|
<Property Name="ID" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
|
|
<Property Name="Descr" Type="String" Nullable="false" MaxLength="250" FixedLength="false" Unicode="true" />
|
|
<Property Name="CodInt" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" />
|
|
<Property Name="ItemFamilyID" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" />
|
|
<Property Name="CodExt" Type="String" Nullable="false" MaxLength="250" FixedLength="false" Unicode="true" />
|
|
<Property Name="DescrExt" Type="String" Nullable="false" MaxLength="250" FixedLength="false" Unicode="true" />
|
|
<Property Name="QtaMin" Type="Int32" Nullable="false" />
|
|
<Property Name="QtaBatch" Type="Int32" Nullable="false" />
|
|
<Property Name="CurrValue" Type="Decimal" Nullable="false" Precision="18" Scale="6" />
|
|
<NavigationProperty Name="ItemFamily" Relationship="StockManModel.FK_Item_ItemFamily" FromRole="Item" ToRole="ItemFamily" />
|
|
<NavigationProperty Name="ItemFlux" Relationship="StockManModel.FK_ItemFlux_Item" FromRole="Item" ToRole="ItemFlux" />
|
|
<NavigationProperty Name="ItemStock" Relationship="StockManModel.FK_Stock_Items" FromRole="Item" ToRole="ItemStock" />
|
|
<Property Name="QtaCurr" annotation:StoreGeneratedPattern="Computed" Type="Int32" />
|
|
<Property Name="QtaPend" Type="Int32" annotation:StoreGeneratedPattern="Computed" />
|
|
<NavigationProperty Name="vItemFlux2Save" Relationship="StockManModel.ItemvItemFlux2Save" FromRole="Item" ToRole="vItemFlux2Save" />
|
|
<Property Name="UM" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" />
|
|
</EntityType>
|
|
<Association Name="FK_Item_ItemFamily">
|
|
<End Type="StockManModel.ItemFamily" Role="ItemFamily" Multiplicity="1" />
|
|
<End Type="StockManModel.Item" Role="Item" Multiplicity="*" />
|
|
<ReferentialConstraint>
|
|
<Principal Role="ItemFamily">
|
|
<PropertyRef Name="ID" />
|
|
</Principal>
|
|
<Dependent Role="Item">
|
|
<PropertyRef Name="ItemFamilyID" />
|
|
</Dependent>
|
|
</ReferentialConstraint>
|
|
</Association>
|
|
<Association Name="FK_ItemFlux_Item">
|
|
<End Type="StockManModel.Item" Role="Item" Multiplicity="1" />
|
|
<End Type="StockManModel.ItemFlux" Role="ItemFlux" Multiplicity="*" />
|
|
<ReferentialConstraint>
|
|
<Principal Role="Item">
|
|
<PropertyRef Name="ID" />
|
|
</Principal>
|
|
<Dependent Role="ItemFlux">
|
|
<PropertyRef Name="ItemID" />
|
|
</Dependent>
|
|
</ReferentialConstraint>
|
|
</Association>
|
|
<Association Name="FK_Stock_Items">
|
|
<End Type="StockManModel.Item" Role="Item" Multiplicity="1" />
|
|
<End Type="StockManModel.ItemStock" Role="ItemStock" Multiplicity="*" />
|
|
<ReferentialConstraint>
|
|
<Principal Role="Item">
|
|
<PropertyRef Name="ID" />
|
|
</Principal>
|
|
<Dependent Role="ItemStock">
|
|
<PropertyRef Name="ItemID" />
|
|
</Dependent>
|
|
</ReferentialConstraint>
|
|
</Association>
|
|
<EntityType Name="Operator">
|
|
<Key>
|
|
<PropertyRef Name="ID" />
|
|
</Key>
|
|
<Property Name="ID" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" />
|
|
<Property Name="CodExt" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" />
|
|
<Property Name="LastName" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" />
|
|
<Property Name="FirstName" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" />
|
|
<NavigationProperty Name="ItemFlux" Relationship="StockManModel.FK_ItemFlux_Operator" FromRole="Operator" ToRole="ItemFlux" />
|
|
<NavigationProperty Name="ItemFlux1" Relationship="StockManModel.FK_ItemFlux_Operator1" FromRole="Operator" ToRole="ItemFlux" />
|
|
</EntityType>
|
|
<Association Name="FK_ItemFlux_Operator">
|
|
<End Type="StockManModel.Operator" Role="Operator" Multiplicity="1" />
|
|
<End Type="StockManModel.ItemFlux" Role="ItemFlux" Multiplicity="*" />
|
|
<ReferentialConstraint>
|
|
<Principal Role="Operator">
|
|
<PropertyRef Name="ID" />
|
|
</Principal>
|
|
<Dependent Role="ItemFlux">
|
|
<PropertyRef Name="OperatorID" />
|
|
</Dependent>
|
|
</ReferentialConstraint>
|
|
</Association>
|
|
<Association Name="FK_ItemFlux_Location1">
|
|
<End Type="StockManModel.Location" Role="Location" Multiplicity="1" />
|
|
<End Type="StockManModel.ItemFlux" Role="ItemFlux" Multiplicity="*" />
|
|
<ReferentialConstraint>
|
|
<Principal Role="Location">
|
|
<PropertyRef Name="ID" />
|
|
</Principal>
|
|
<Dependent Role="ItemFlux">
|
|
<PropertyRef Name="ExtLocationID" />
|
|
</Dependent>
|
|
</ReferentialConstraint>
|
|
</Association>
|
|
<EntityType Name="vItemFlux2Save">
|
|
<Key>
|
|
<PropertyRef Name="ItemID" />
|
|
</Key>
|
|
<Property Name="ItemID" Type="Int32" Nullable="false" />
|
|
<Property Name="NumMov" Type="Int32" />
|
|
<Property Name="TotQta" Type="Int32" />
|
|
<Property Name="TotValCar" Type="Decimal" Precision="38" Scale="6" />
|
|
<Property Name="TotQtaCar" Type="Int32" />
|
|
<NavigationProperty Name="Item" Relationship="StockManModel.ItemvItemFlux2Save" FromRole="vItemFlux2Save" ToRole="Item" />
|
|
<Property Name="TotQtaOrd" Type="Int32" />
|
|
</EntityType>
|
|
<Association Name="ItemvItemFlux2Save">
|
|
<End Type="StockManModel.Item" Role="Item" Multiplicity="1" />
|
|
<End Type="StockManModel.vItemFlux2Save" Role="vItemFlux2Save" Multiplicity="1" />
|
|
<ReferentialConstraint>
|
|
<Principal Role="Item">
|
|
<PropertyRef Name="ID" />
|
|
</Principal>
|
|
<Dependent Role="vItemFlux2Save">
|
|
<PropertyRef Name="ItemID" />
|
|
</Dependent>
|
|
</ReferentialConstraint>
|
|
</Association>
|
|
<ComplexType Name="stp_ItemDuplicate1_Result">
|
|
<Property Type="Int32" Name="ID" Nullable="false" />
|
|
<Property Type="String" Name="Descr" Nullable="false" MaxLength="250" />
|
|
<Property Type="String" Name="CodInt" Nullable="false" MaxLength="50" />
|
|
<Property Type="String" Name="ItemFamilyID" Nullable="false" MaxLength="50" />
|
|
<Property Type="String" Name="CodExt" Nullable="false" MaxLength="250" />
|
|
<Property Type="String" Name="DescrExt" Nullable="false" MaxLength="250" />
|
|
<Property Type="Int32" Name="QtaMin" Nullable="false" />
|
|
<Property Type="Int32" Name="QtaBatch" Nullable="false" />
|
|
<Property Type="Decimal" Name="CurrValue" Nullable="false" Precision="18" Scale="6" />
|
|
<Property Type="Int32" Name="QtaCurr" Nullable="true" />
|
|
<Property Type="Int32" Name="QtaPend" Nullable="true" />
|
|
</ComplexType>
|
|
<EntityType Name="vLocationVal">
|
|
<Key>
|
|
<PropertyRef Name="LocationID" />
|
|
</Key>
|
|
<Property Name="LocationID" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" />
|
|
<Property Name="TotVal" Type="Decimal" Precision="38" Scale="6" />
|
|
<Property Name="TotCurr" Type="Int32" />
|
|
<Property Name="TotPend" Type="Int32" />
|
|
<NavigationProperty Name="Location" Relationship="StockManModel.LocationvLocationVal" FromRole="vLocationVal" ToRole="Location" />
|
|
<Property Name="NumArt" Type="Int32" />
|
|
</EntityType>
|
|
<Association Name="LocationvLocationVal">
|
|
<End Type="StockManModel.Location" Role="Location" Multiplicity="1" />
|
|
<End Type="StockManModel.vLocationVal" Role="vLocationVal" Multiplicity="1" />
|
|
<ReferentialConstraint>
|
|
<Principal Role="Location">
|
|
<PropertyRef Name="ID" />
|
|
</Principal>
|
|
<Dependent Role="vLocationVal">
|
|
<PropertyRef Name="LocationID" />
|
|
</Dependent>
|
|
</ReferentialConstraint>
|
|
</Association>
|
|
<ComplexType Name="stp_ItemStockMove_Result">
|
|
<Property Type="Int32" Name="ItemID" Nullable="false" />
|
|
<Property Type="String" Name="LocationID" Nullable="false" MaxLength="50" />
|
|
<Property Type="String" Name="Column1" Nullable="false" MaxLength="3" />
|
|
<Property Type="String" Name="Column2" Nullable="true" MaxLength="50" />
|
|
<Property Type="DateTime" Name="Column3" Nullable="true" Precision="23" />
|
|
<Property Type="Int32" Name="QtyConf" Nullable="false" />
|
|
<Property Type="String" Name="Column4" Nullable="true" MaxLength="50" />
|
|
<Property Type="DateTime" Name="Column5" Nullable="true" Precision="23" />
|
|
</ComplexType>
|
|
<Association Name="FK_ItemFlux_Operator1">
|
|
<End Type="StockManModel.Operator" Role="Operator" Multiplicity="1" />
|
|
<End Type="StockManModel.ItemFlux" Role="ItemFlux" Multiplicity="*" />
|
|
<ReferentialConstraint>
|
|
<Principal Role="Operator">
|
|
<PropertyRef Name="ID" />
|
|
</Principal>
|
|
<Dependent Role="ItemFlux">
|
|
<PropertyRef Name="ModOperatorID" />
|
|
</Dependent>
|
|
</ReferentialConstraint>
|
|
</Association>
|
|
<EntityType Name="CountersList">
|
|
<Key>
|
|
<PropertyRef Name="ID" />
|
|
</Key>
|
|
<Property Name="ID" Type="String" Nullable="false" MaxLength="50" FixedLength="false" Unicode="false" />
|
|
<Property Name="NextNum" Type="Int32" Nullable="false" />
|
|
</EntityType>
|
|
<ComplexType Name="stp_Counters_getNext_Result">
|
|
<Property Type="String" Name="ID" Nullable="false" MaxLength="50" />
|
|
<Property Type="Int32" Name="NextNum" Nullable="false" />
|
|
</ComplexType>
|
|
<ComplexType Name="stp_ItemFluxDuplicate_Result">
|
|
<Property Type="Int32" Name="ID" Nullable="false" />
|
|
<Property Type="String" Name="Descr" Nullable="false" MaxLength="250" />
|
|
<Property Type="String" Name="CodInt" Nullable="false" MaxLength="50" />
|
|
<Property Type="String" Name="ItemFamilyID" Nullable="false" MaxLength="50" />
|
|
<Property Type="String" Name="CodExt" Nullable="false" MaxLength="250" />
|
|
<Property Type="String" Name="DescrExt" Nullable="false" MaxLength="250" />
|
|
<Property Type="Int32" Name="QtaMin" Nullable="false" />
|
|
<Property Type="Int32" Name="QtaBatch" Nullable="false" />
|
|
<Property Type="Decimal" Name="CurrValue" Nullable="false" Precision="18" Scale="6" />
|
|
<Property Type="Int32" Name="QtaCurr" Nullable="true" />
|
|
<Property Type="Int32" Name="QtaPend" Nullable="true" />
|
|
<Property Type="String" Name="UM" Nullable="false" MaxLength="50" />
|
|
</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="StockManModelStoreContainer" CdmEntityContainer="StockManEntities">
|
|
<EntitySetMapping Name="ItemFlux">
|
|
<EntityTypeMapping TypeName="StockManModel.ItemFlux">
|
|
<MappingFragment StoreEntitySet="ItemFlux">
|
|
<ScalarProperty Name="ModOperatorID" ColumnName="ModOperatorID" />
|
|
<ScalarProperty Name="CodDoc" ColumnName="CodDoc" />
|
|
<ScalarProperty Name="OperatorID" ColumnName="OperatorID" />
|
|
<ScalarProperty Name="ID" ColumnName="ID" />
|
|
<ScalarProperty Name="ItemID" ColumnName="ItemID" />
|
|
<ScalarProperty Name="LocationID" ColumnName="LocationID" />
|
|
<ScalarProperty Name="MovTypeID" ColumnName="MovTypeID" />
|
|
<ScalarProperty Name="ExtLocationID" ColumnName="ExtLocationID" />
|
|
<ScalarProperty Name="dtMov" ColumnName="dtMov" />
|
|
<ScalarProperty Name="Qta" ColumnName="Qta" />
|
|
<ScalarProperty Name="TotValue" ColumnName="TotValue" />
|
|
<ScalarProperty Name="UnitVal" ColumnName="UnitVal" />
|
|
<ScalarProperty Name="Note" ColumnName="Note" />
|
|
<ScalarProperty Name="dtExport" ColumnName="dtExport" />
|
|
</MappingFragment>
|
|
</EntityTypeMapping>
|
|
</EntitySetMapping>
|
|
<EntitySetMapping Name="ItemStock">
|
|
<EntityTypeMapping TypeName="StockManModel.ItemStock">
|
|
<MappingFragment StoreEntitySet="ItemStock">
|
|
<ScalarProperty Name="ID" ColumnName="ID" />
|
|
<ScalarProperty Name="ItemID" ColumnName="ItemID" />
|
|
<ScalarProperty Name="LocationID" ColumnName="LocationID" />
|
|
<ScalarProperty Name="QtyConf" ColumnName="QtyConf" />
|
|
<ScalarProperty Name="Note" ColumnName="Note" />
|
|
<ScalarProperty Name="dtLastUpd" ColumnName="dtLastUpd" />
|
|
</MappingFragment>
|
|
</EntityTypeMapping>
|
|
</EntitySetMapping>
|
|
<EntitySetMapping Name="Location">
|
|
<EntityTypeMapping TypeName="StockManModel.Location">
|
|
<MappingFragment StoreEntitySet="Location">
|
|
<ScalarProperty Name="ID" ColumnName="ID" />
|
|
<ScalarProperty Name="Descr" ColumnName="Descr" />
|
|
<ScalarProperty Name="LocTypeID" ColumnName="LocTypeID" />
|
|
</MappingFragment>
|
|
</EntityTypeMapping>
|
|
</EntitySetMapping>
|
|
<EntitySetMapping Name="LocType">
|
|
<EntityTypeMapping TypeName="StockManModel.LocType">
|
|
<MappingFragment StoreEntitySet="LocType">
|
|
<ScalarProperty Name="ID" ColumnName="ID" />
|
|
<ScalarProperty Name="Descr" ColumnName="Descr" />
|
|
<ScalarProperty Name="IsStock" ColumnName="IsStock" />
|
|
<ScalarProperty Name="IsCli" ColumnName="IsCli" />
|
|
<ScalarProperty Name="IsFor" ColumnName="IsFor" />
|
|
</MappingFragment>
|
|
</EntityTypeMapping>
|
|
</EntitySetMapping>
|
|
<EntitySetMapping Name="MovType">
|
|
<EntityTypeMapping TypeName="StockManModel.MovType">
|
|
<MappingFragment StoreEntitySet="MovType">
|
|
<ScalarProperty Name="CssClass" ColumnName="CssClass" />
|
|
<ScalarProperty Name="ID" ColumnName="ID" />
|
|
<ScalarProperty Name="Descr" ColumnName="Descr" />
|
|
</MappingFragment>
|
|
</EntityTypeMapping>
|
|
</EntitySetMapping>
|
|
<EntitySetMapping Name="ItemFamily">
|
|
<EntityTypeMapping TypeName="StockManModel.ItemFamily">
|
|
<MappingFragment StoreEntitySet="ItemFamily">
|
|
<ScalarProperty Name="NumItems" ColumnName="NumItems" />
|
|
<ScalarProperty Name="Descr" ColumnName="Descr" />
|
|
<ScalarProperty Name="ID" ColumnName="ID" />
|
|
</MappingFragment>
|
|
</EntityTypeMapping>
|
|
</EntitySetMapping>
|
|
<EntitySetMapping Name="Item">
|
|
<EntityTypeMapping TypeName="StockManModel.Item">
|
|
<MappingFragment StoreEntitySet="Item">
|
|
<ScalarProperty Name="UM" ColumnName="UM" />
|
|
<ScalarProperty Name="QtaPend" ColumnName="QtaPend" />
|
|
<ScalarProperty Name="QtaCurr" ColumnName="QtaCurr" />
|
|
<ScalarProperty Name="CurrValue" ColumnName="CurrValue" />
|
|
<ScalarProperty Name="QtaBatch" ColumnName="QtaBatch" />
|
|
<ScalarProperty Name="QtaMin" ColumnName="QtaMin" />
|
|
<ScalarProperty Name="DescrExt" ColumnName="DescrExt" />
|
|
<ScalarProperty Name="CodExt" ColumnName="CodExt" />
|
|
<ScalarProperty Name="ItemFamilyID" ColumnName="ItemFamilyID" />
|
|
<ScalarProperty Name="CodInt" ColumnName="CodInt" />
|
|
<ScalarProperty Name="Descr" ColumnName="Descr" />
|
|
<ScalarProperty Name="ID" ColumnName="ID" />
|
|
</MappingFragment>
|
|
</EntityTypeMapping>
|
|
</EntitySetMapping>
|
|
<EntitySetMapping Name="Operator">
|
|
<EntityTypeMapping TypeName="StockManModel.Operator">
|
|
<MappingFragment StoreEntitySet="Operator">
|
|
<ScalarProperty Name="FirstName" ColumnName="FirstName" />
|
|
<ScalarProperty Name="LastName" ColumnName="LastName" />
|
|
<ScalarProperty Name="CodExt" ColumnName="CodExt" />
|
|
<ScalarProperty Name="ID" ColumnName="ID" />
|
|
</MappingFragment>
|
|
</EntityTypeMapping>
|
|
</EntitySetMapping>
|
|
<EntitySetMapping Name="vItemFlux2Save">
|
|
<EntityTypeMapping TypeName="StockManModel.vItemFlux2Save">
|
|
<MappingFragment StoreEntitySet="vItemFlux2Save">
|
|
<ScalarProperty Name="TotQtaOrd" ColumnName="TotQtaOrd" />
|
|
<ScalarProperty Name="TotQtaCar" ColumnName="TotQtaCar" />
|
|
<ScalarProperty Name="TotValCar" ColumnName="TotValCar" />
|
|
<ScalarProperty Name="TotQta" ColumnName="TotQta" />
|
|
<ScalarProperty Name="NumMov" ColumnName="NumMov" />
|
|
<ScalarProperty Name="ItemID" ColumnName="ItemID" />
|
|
</MappingFragment>
|
|
</EntityTypeMapping>
|
|
</EntitySetMapping>
|
|
<FunctionImportMapping FunctionImportName="stp_ItemConsolidate" FunctionName="StockManModel.Store.stp_ItemConsolidate" />
|
|
<FunctionImportMapping FunctionImportName="stp_ItemDuplicate" FunctionName="StockManModel.Store.stp_ItemDuplicate" />
|
|
<EntitySetMapping Name="vLocationVal">
|
|
<EntityTypeMapping TypeName="StockManModel.vLocationVal">
|
|
<MappingFragment StoreEntitySet="vLocationVal">
|
|
<ScalarProperty Name="NumArt" ColumnName="NumArt" />
|
|
<ScalarProperty Name="TotPend" ColumnName="TotPend" />
|
|
<ScalarProperty Name="TotCurr" ColumnName="TotCurr" />
|
|
<ScalarProperty Name="TotVal" ColumnName="TotVal" />
|
|
<ScalarProperty Name="LocationID" ColumnName="LocationID" />
|
|
</MappingFragment>
|
|
</EntityTypeMapping>
|
|
</EntitySetMapping>
|
|
<FunctionImportMapping FunctionImportName="stp_ItemStockMove" FunctionName="StockManModel.Store.stp_ItemStockMove">
|
|
</FunctionImportMapping>
|
|
<FunctionImportMapping FunctionImportName="stp_ItemStockMove_New" FunctionName="StockManModel.Store.stp_ItemStockMove_New" />
|
|
<FunctionImportMapping FunctionImportName="stp_ItemShrinkHist" FunctionName="StockManModel.Store.stp_ItemShrinkHist" />
|
|
<EntitySetMapping Name="CountersList">
|
|
<EntityTypeMapping TypeName="StockManModel.CountersList">
|
|
<MappingFragment StoreEntitySet="CountersList">
|
|
<ScalarProperty Name="NextNum" ColumnName="NextNum" />
|
|
<ScalarProperty Name="ID" ColumnName="ID" />
|
|
</MappingFragment>
|
|
</EntityTypeMapping>
|
|
</EntitySetMapping>
|
|
<FunctionImportMapping FunctionImportName="stp_Counters_getNext" FunctionName="StockManModel.Store.stp_Counters_getNext">
|
|
</FunctionImportMapping>
|
|
<FunctionImportMapping FunctionImportName="stp_ItemFluxDuplicate" FunctionName="StockManModel.Store.stp_ItemFluxDuplicate">
|
|
</FunctionImportMapping>
|
|
<FunctionImportMapping FunctionImportName="stp_ItemResetAll" FunctionName="StockManModel.Store.stp_ItemResetAll" />
|
|
</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="None" />
|
|
</DesignerInfoPropertySet>
|
|
</Options>
|
|
<!-- Diagram content (shape and connector positions) -->
|
|
<Diagrams>
|
|
</Diagrams>
|
|
</Designer>
|
|
</edmx:Edmx> |