<?xml version="1.0" encoding="utf-8"?>
<edmx:Edmx Version="2.0" xmlns:edmx="http://schemas.microsoft.com/ado/2008/10/edmx">
  <!-- EF Runtime content -->
  <edmx:Runtime>
    <!-- SSDL content -->
    <edmx:StorageModels>
    <Schema Namespace="NikaiDSRModel.Store" Alias="Self" Provider="System.Data.SqlClient" ProviderManifestToken="2008" xmlns:store="http://schemas.microsoft.com/ado/2007/12/edm/EntityStoreSchemaGenerator" xmlns="http://schemas.microsoft.com/ado/2009/02/edm/ssdl">
        <EntityContainer Name="NikaiDSRModelStoreContainer">
          <EntitySet Name="Absent" EntityType="NikaiDSRModel.Store.Absent" store:Type="Tables" Schema="dbo" />
          <EntitySet Name="Contact" EntityType="NikaiDSRModel.Store.Contact" store:Type="Tables" Schema="dbo" />
          <EntitySet Name="Country" EntityType="NikaiDSRModel.Store.Country" store:Type="Tables" Schema="dbo" />
          <EntitySet Name="Customer" EntityType="NikaiDSRModel.Store.Customer" store:Type="Tables" Schema="dbo" />
          <EntitySet Name="DSR" EntityType="NikaiDSRModel.Store.DSR" store:Type="Tables" Schema="dbo" />
          <EntitySet Name="DSR_Header" EntityType="NikaiDSRModel.Store.DSR_Header" store:Type="Tables" Schema="dbo" />
          <EntitySet Name="Holiday" EntityType="NikaiDSRModel.Store.Holiday" store:Type="Tables" Schema="dbo" />
          <EntitySet Name="Location" EntityType="NikaiDSRModel.Store.Location" store:Type="Tables" Schema="dbo" />
          <EntitySet Name="Manager_Executive" EntityType="NikaiDSRModel.Store.Manager_Executive" store:Type="Tables" Schema="dbo" />
          <EntitySet Name="Menu" EntityType="NikaiDSRModel.Store.Menu" store:Type="Tables" Schema="dbo" />
          <EntitySet Name="MenuAccess" EntityType="NikaiDSRModel.Store.MenuAccess" store:Type="Tables" Schema="dbo" />
          <EntitySet Name="MenuRolePages" EntityType="NikaiDSRModel.Store.MenuRolePages" store:Type="Tables" Schema="dbo" />
          <EntitySet Name="Parameter" EntityType="NikaiDSRModel.Store.Parameter" store:Type="Tables" Schema="dbo" />
          <EntitySet Name="ParameterDet" EntityType="NikaiDSRModel.Store.ParameterDet" store:Type="Tables" Schema="dbo" />
          <EntitySet Name="Region" EntityType="NikaiDSRModel.Store.Region" store:Type="Tables" Schema="dbo" />
          <EntitySet Name="Role" EntityType="NikaiDSRModel.Store.Role" store:Type="Tables" Schema="dbo" />
          <EntitySet Name="RoleRights" EntityType="NikaiDSRModel.Store.RoleRights" store:Type="Tables" Schema="dbo" />
          <EntitySet Name="Site_User" EntityType="NikaiDSRModel.Store.Site_User" store:Type="Tables" Schema="dbo" />
          <EntitySet Name="sysdiagrams" EntityType="NikaiDSRModel.Store.sysdiagrams" store:Type="Tables" Schema="dbo" />
          <EntitySet Name="Target" EntityType="NikaiDSRModel.Store.Target" store:Type="Tables" Schema="dbo" />
          <EntitySet Name="User_Language" EntityType="NikaiDSRModel.Store.User_Language" store:Type="Tables" Schema="dbo" />
          <EntitySet Name="ActiveContactCustomerLocationView" EntityType="NikaiDSRModel.Store.ActiveContactCustomerLocationView" store:Type="Views" store:Schema="dbo" store:Name="ActiveContactCustomerLocationView">
            <DefiningQuery>SELECT 
      [ActiveContactCustomerLocationView].[Contact_Id] AS [Contact_Id], 
      [ActiveContactCustomerLocationView].[Contact_Name] AS [Contact_Name], 
      [ActiveContactCustomerLocationView].[Department] AS [Department], 
      [ActiveContactCustomerLocationView].[Contact_Status] AS [Contact_Status], 
      [ActiveContactCustomerLocationView].[Customer_Id] AS [Customer_Id], 
      [ActiveContactCustomerLocationView].[Customer_Name] AS [Customer_Name], 
      [ActiveContactCustomerLocationView].[Key_Account] AS [Key_Account], 
      [ActiveContactCustomerLocationView].[Customer_Status] AS [Customer_Status], 
      [ActiveContactCustomerLocationView].[Location_Id] AS [Location_Id], 
      [ActiveContactCustomerLocationView].[Location_Name] AS [Location_Name], 
      [ActiveContactCustomerLocationView].[Site_User_Id] AS [Site_User_Id], 
      [ActiveContactCustomerLocationView].[Customer_Name_BL] AS [Customer_Name_BL], 
      [ActiveContactCustomerLocationView].[Contact_Name_BL] AS [Contact_Name_BL], 
      [ActiveContactCustomerLocationView].[Updated_By] AS [Updated_By], 
      [ActiveContactCustomerLocationView].[Updated_Date] AS [Updated_Date], 
      [ActiveContactCustomerLocationView].[Customer_Code] AS [Customer_Code], 
      [ActiveContactCustomerLocationView].[Business_Type] AS [Business_Type], 
      [ActiveContactCustomerLocationView].[Customer_Type] AS [Customer_Type], 
      [ActiveContactCustomerLocationView].[Customer_Group] AS [Customer_Group], 
      [ActiveContactCustomerLocationView].[Department_BL] AS [Department_BL], 
      [ActiveContactCustomerLocationView].[Mobile] AS [Mobile]
      FROM [dbo].[ActiveContactCustomerLocationView] AS [ActiveContactCustomerLocationView]</DefiningQuery>
          </EntitySet>
          <EntitySet Name="ActiveCustomerLocationRegionCountryView" EntityType="NikaiDSRModel.Store.ActiveCustomerLocationRegionCountryView" store:Type="Views" store:Schema="dbo" store:Name="ActiveCustomerLocationRegionCountryView">
            <DefiningQuery>SELECT 
      [ActiveCustomerLocationRegionCountryView].[Customer_Id] AS [Customer_Id], 
      [ActiveCustomerLocationRegionCountryView].[Customer_Name] AS [Customer_Name], 
      [ActiveCustomerLocationRegionCountryView].[Key_Account] AS [Key_Account], 
      [ActiveCustomerLocationRegionCountryView].[Customer_Status] AS [Customer_Status], 
      [ActiveCustomerLocationRegionCountryView].[Location_Id] AS [Location_Id], 
      [ActiveCustomerLocationRegionCountryView].[Location_Name] AS [Location_Name], 
      [ActiveCustomerLocationRegionCountryView].[Customer_Name_BL] AS [Customer_Name_BL], 
      [ActiveCustomerLocationRegionCountryView].[Updated_By] AS [Updated_By], 
      [ActiveCustomerLocationRegionCountryView].[Updated_Date] AS [Updated_Date], 
      [ActiveCustomerLocationRegionCountryView].[Customer_Code] AS [Customer_Code], 
      [ActiveCustomerLocationRegionCountryView].[Business_Type] AS [Business_Type], 
      [ActiveCustomerLocationRegionCountryView].[Customer_Type] AS [Customer_Type], 
      [ActiveCustomerLocationRegionCountryView].[Customer_Group] AS [Customer_Group], 
      [ActiveCustomerLocationRegionCountryView].[Country_Name] AS [Country_Name], 
      [ActiveCustomerLocationRegionCountryView].[Region_Name] AS [Region_Name]
      FROM [dbo].[ActiveCustomerLocationRegionCountryView] AS [ActiveCustomerLocationRegionCountryView]</DefiningQuery>
          </EntitySet>
          <EntitySet Name="DsrContactCustomerLocationView" EntityType="NikaiDSRModel.Store.DsrContactCustomerLocationView" store:Type="Views" store:Schema="dbo" store:Name="DsrContactCustomerLocationView">
            <DefiningQuery>SELECT 
      [DsrContactCustomerLocationView].[Site_User_Id] AS [Site_User_Id], 
      [DsrContactCustomerLocationView].[DSR_Id] AS [DSR_Id], 
      [DsrContactCustomerLocationView].[Contact_Id] AS [Contact_Id], 
      [DsrContactCustomerLocationView].[Contact_Name] AS [Contact_Name], 
      [DsrContactCustomerLocationView].[Date] AS [Date], 
      [DsrContactCustomerLocationView].[Customer_Id] AS [Customer_Id], 
      [DsrContactCustomerLocationView].[Contact_Status] AS [Contact_Status], 
      [DsrContactCustomerLocationView].[Customer_Name] AS [Customer_Name], 
      [DsrContactCustomerLocationView].[Location_Id] AS [Location_Id], 
      [DsrContactCustomerLocationView].[Customer_Status] AS [Customer_Status], 
      [DsrContactCustomerLocationView].[Location_Name] AS [Location_Name], 
      [DsrContactCustomerLocationView].[Customer_Name_BL] AS [Customer_Name_BL], 
      [DsrContactCustomerLocationView].[Contact_Name_BL] AS [Contact_Name_BL], 
      [DsrContactCustomerLocationView].[Updated_By] AS [Updated_By], 
      [DsrContactCustomerLocationView].[Updated_Date] AS [Updated_Date], 
      [DsrContactCustomerLocationView].[Location_Name_BL] AS [Location_Name_BL]
      FROM [dbo].[DsrContactCustomerLocationView] AS [DsrContactCustomerLocationView]</DefiningQuery>
          </EntitySet>
          <EntitySet Name="DSRReportView" EntityType="NikaiDSRModel.Store.DSRReportView" store:Type="Views" store:Schema="dbo" store:Name="DSRReportView">
            <DefiningQuery>SELECT 
      [DSRReportView].[Site_User_Id] AS [Site_User_Id], 
      [DSRReportView].[Date] AS [Date], 
      [DSRReportView].[Customer_Id] AS [Customer_Id], 
      [DSRReportView].[Customer_Code] AS [Customer_Code], 
      [DSRReportView].[Customer_Name] AS [Customer_Name], 
      [DSRReportView].[Customer_Name_BL] AS [Customer_Name_BL], 
      [DSRReportView].[Contact_Id] AS [Contact_Id], 
      [DSRReportView].[Contact_Name] AS [Contact_Name], 
      [DSRReportView].[Contact_Name_BL] AS [Contact_Name_BL], 
      [DSRReportView].[Department_BL] AS [Department_BL], 
      [DSRReportView].[Department] AS [Department], 
      [DSRReportView].[Mobile] AS [Mobile], 
      [DSRReportView].[Status_Contact] AS [Status_Contact], 
      [DSRReportView].[Objective] AS [Objective], 
      [DSRReportView].[Time_In] AS [Time_In], 
      [DSRReportView].[Time_Out] AS [Time_Out], 
      [DSRReportView].[Time_Spent] AS [Time_Spent], 
      [DSRReportView].[Time_w_Merchandiser] AS [Time_w_Merchandiser], 
      [DSRReportView].[Collection] AS [Collection], 
      [DSRReportView].[Secondary_Sales] AS [Secondary_Sales], 
      [DSRReportView].[Sales_LPO_Received] AS [Sales_LPO_Received], 
      [DSRReportView].[Discount] AS [Discount], 
      [DSRReportView].[Sales_Return] AS [Sales_Return], 
      [DSRReportView].[Remarks] AS [Remarks], 
      [DSRReportView].[Status_Customer] AS [Status_Customer]
      FROM [dbo].[DSRReportView] AS [DSRReportView]</DefiningQuery>
          </EntitySet>
          <EntitySet Name="UserRoleLocationRegionCountryView" EntityType="NikaiDSRModel.Store.UserRoleLocationRegionCountryView" store:Type="Views" store:Schema="dbo" store:Name="UserRoleLocationRegionCountryView">
            <DefiningQuery>SELECT 
      [UserRoleLocationRegionCountryView].[Site_User_Id] AS [Site_User_Id], 
      [UserRoleLocationRegionCountryView].[Name] AS [Name], 
      [UserRoleLocationRegionCountryView].[Email] AS [Email], 
      [UserRoleLocationRegionCountryView].[Status] AS [Status], 
      [UserRoleLocationRegionCountryView].[Role_Id] AS [Role_Id], 
      [UserRoleLocationRegionCountryView].[Role_Name] AS [Role_Name], 
      [UserRoleLocationRegionCountryView].[Location_Id] AS [Location_Id], 
      [UserRoleLocationRegionCountryView].[Location_Name] AS [Location_Name], 
      [UserRoleLocationRegionCountryView].[Region_Id] AS [Region_Id], 
      [UserRoleLocationRegionCountryView].[Region_Name] AS [Region_Name], 
      [UserRoleLocationRegionCountryView].[Country_Id] AS [Country_Id], 
      [UserRoleLocationRegionCountryView].[Country_Name] AS [Country_Name]
      FROM [dbo].[UserRoleLocationRegionCountryView] AS [UserRoleLocationRegionCountryView]</DefiningQuery>
          </EntitySet>
          <AssociationSet Name="FK_Absent_Site_User" Association="NikaiDSRModel.Store.FK_Absent_Site_User">
            <End Role="Site_User" EntitySet="Site_User" />
            <End Role="Absent" EntitySet="Absent" />
          </AssociationSet>
          <AssociationSet Name="FK_Contact_Customer" Association="NikaiDSRModel.Store.FK_Contact_Customer">
            <End Role="Customer" EntitySet="Customer" />
            <End Role="Contact" EntitySet="Contact" />
          </AssociationSet>
          <AssociationSet Name="FK_Customer_Location" Association="NikaiDSRModel.Store.FK_Customer_Location">
            <End Role="Location" EntitySet="Location" />
            <End Role="Customer" EntitySet="Customer" />
          </AssociationSet>
          <AssociationSet Name="FK_Customer_ParameterDet" Association="NikaiDSRModel.Store.FK_Customer_ParameterDet">
            <End Role="ParameterDet" EntitySet="ParameterDet" />
            <End Role="Customer" EntitySet="Customer" />
          </AssociationSet>
          <AssociationSet Name="FK_Customer_ParameterDet1" Association="NikaiDSRModel.Store.FK_Customer_ParameterDet1">
            <End Role="ParameterDet" EntitySet="ParameterDet" />
            <End Role="Customer" EntitySet="Customer" />
          </AssociationSet>
          <AssociationSet Name="FK_Customer_ParameterDet2" Association="NikaiDSRModel.Store.FK_Customer_ParameterDet2">
            <End Role="ParameterDet" EntitySet="ParameterDet" />
            <End Role="Customer" EntitySet="Customer" />
          </AssociationSet>
          <AssociationSet Name="FK_Customer_ParameterDet3" Association="NikaiDSRModel.Store.FK_Customer_ParameterDet3">
            <End Role="ParameterDet" EntitySet="ParameterDet" />
            <End Role="Customer" EntitySet="Customer" />
          </AssociationSet>
          <AssociationSet Name="FK_Customer_Site_User" Association="NikaiDSRModel.Store.FK_Customer_Site_User">
            <End Role="Site_User" EntitySet="Site_User" />
            <End Role="Customer" EntitySet="Customer" />
          </AssociationSet>
          <AssociationSet Name="FK_DSR_Contact" Association="NikaiDSRModel.Store.FK_DSR_Contact">
            <End Role="Contact" EntitySet="Contact" />
            <End Role="DSR" EntitySet="DSR" />
          </AssociationSet>
          <AssociationSet Name="FK_DSR_DSR_Header" Association="NikaiDSRModel.Store.FK_DSR_DSR_Header">
            <End Role="Site_User" EntitySet="Site_User" />
            <End Role="DSR" EntitySet="DSR" />
          </AssociationSet>
          <AssociationSet Name="FK_Holiday_Country" Association="NikaiDSRModel.Store.FK_Holiday_Country">
            <End Role="Country" EntitySet="Country" />
            <End Role="Holiday" EntitySet="Holiday" />
          </AssociationSet>
          <AssociationSet Name="FK_Holiday_ParameterDet" Association="NikaiDSRModel.Store.FK_Holiday_ParameterDet">
            <End Role="ParameterDet" EntitySet="ParameterDet" />
            <End Role="Holiday" EntitySet="Holiday" />
          </AssociationSet>
          <AssociationSet Name="FK_Location_Region" Association="NikaiDSRModel.Store.FK_Location_Region">
            <End Role="Region" EntitySet="Region" />
            <End Role="Location" EntitySet="Location" />
          </AssociationSet>
          <AssociationSet Name="FK_Manager_Executive_Site_User" Association="NikaiDSRModel.Store.FK_Manager_Executive_Site_User">
            <End Role="Site_User" EntitySet="Site_User" />
            <End Role="Manager_Executive" EntitySet="Manager_Executive" />
          </AssociationSet>
          <AssociationSet Name="FK_Menu_ParameterDet" Association="NikaiDSRModel.Store.FK_Menu_ParameterDet">
            <End Role="ParameterDet" EntitySet="ParameterDet" />
            <End Role="Menu" EntitySet="Menu" />
          </AssociationSet>
          <AssociationSet Name="FK_MenuAccess_Menu" Association="NikaiDSRModel.Store.FK_MenuAccess_Menu">
            <End Role="Menu" EntitySet="Menu" />
            <End Role="MenuAccess" EntitySet="MenuAccess" />
          </AssociationSet>
          <AssociationSet Name="FK_MenuAccess_ParameterDet" Association="NikaiDSRModel.Store.FK_MenuAccess_ParameterDet">
            <End Role="ParameterDet" EntitySet="ParameterDet" />
            <End Role="MenuAccess" EntitySet="MenuAccess" />
          </AssociationSet>
          <AssociationSet Name="FK_MenuRolePages_Menu" Association="NikaiDSRModel.Store.FK_MenuRolePages_Menu">
            <End Role="Menu" EntitySet="Menu" />
            <End Role="MenuRolePages" EntitySet="MenuRolePages" />
          </AssociationSet>
          <AssociationSet Name="FK_MenuRolePages_ParameterDet" Association="NikaiDSRModel.Store.FK_MenuRolePages_ParameterDet">
            <End Role="Role" EntitySet="Role" />
            <End Role="MenuRolePages" EntitySet="MenuRolePages" />
          </AssociationSet>
          <AssociationSet Name="FK_ParameterDet_Parameter" Association="NikaiDSRModel.Store.FK_ParameterDet_Parameter">
            <End Role="Parameter" EntitySet="Parameter" />
            <End Role="ParameterDet" EntitySet="ParameterDet" />
          </AssociationSet>
          <AssociationSet Name="FK_Region_Country" Association="NikaiDSRModel.Store.FK_Region_Country">
            <End Role="Country" EntitySet="Country" />
            <End Role="Region" EntitySet="Region" />
          </AssociationSet>
          <AssociationSet Name="FK_RoleRights_Menu" Association="NikaiDSRModel.Store.FK_RoleRights_Menu">
            <End Role="Menu" EntitySet="Menu" />
            <End Role="RoleRights" EntitySet="RoleRights" />
          </AssociationSet>
          <AssociationSet Name="FK_RoleRights_ParameterDet" Association="NikaiDSRModel.Store.FK_RoleRights_ParameterDet">
            <End Role="Role" EntitySet="Role" />
            <End Role="RoleRights" EntitySet="RoleRights" />
          </AssociationSet>
          <AssociationSet Name="FK_RoleRights_ParameterDet1" Association="NikaiDSRModel.Store.FK_RoleRights_ParameterDet1">
            <End Role="ParameterDet" EntitySet="ParameterDet" />
            <End Role="RoleRights" EntitySet="RoleRights" />
          </AssociationSet>
          <AssociationSet Name="FK_Site_User_Location" Association="NikaiDSRModel.Store.FK_Site_User_Location">
            <End Role="Location" EntitySet="Location" />
            <End Role="Site_User" EntitySet="Site_User" />
          </AssociationSet>
          <AssociationSet Name="FK_Site_User_Role" Association="NikaiDSRModel.Store.FK_Site_User_Role">
            <End Role="Role" EntitySet="Role" />
            <End Role="Site_User" EntitySet="Site_User" />
          </AssociationSet>
          <AssociationSet Name="FK_Target_Site_User" Association="NikaiDSRModel.Store.FK_Target_Site_User">
            <End Role="Site_User" EntitySet="Site_User" />
            <End Role="Target" EntitySet="Target" />
          </AssociationSet>
          <AssociationSet Name="FK_User_Language_ParameterDet" Association="NikaiDSRModel.Store.FK_User_Language_ParameterDet">
            <End Role="ParameterDet" EntitySet="ParameterDet" />
            <End Role="User_Language" EntitySet="User_Language" />
          </AssociationSet>
          <AssociationSet Name="FK_User_Language_Site_User" Association="NikaiDSRModel.Store.FK_User_Language_Site_User">
            <End Role="Site_User" EntitySet="Site_User" />
            <End Role="User_Language" EntitySet="User_Language" />
          </AssociationSet>
        </EntityContainer>
        <EntityType Name="Absent">
          <Key>
            <PropertyRef Name="Absent_Id" />
          </Key>
          <Property Name="Absent_Id" Type="int" Nullable="false" StoreGeneratedPattern="Identity" />
          <Property Name="Date" Type="date" Nullable="false" />
          <Property Name="Site_User_Id" Type="int" Nullable="false" />
        </EntityType>
        <EntityType Name="Contact">
          <Key>
            <PropertyRef Name="Contact_Id" />
          </Key>
          <Property Name="Contact_Id" Type="int" Nullable="false" StoreGeneratedPattern="Identity" />
          <Property Name="Contact_Name" Type="nvarchar" MaxLength="50" />
          <Property Name="Contact_Name_BL" Type="nvarchar" MaxLength="50" />
          <Property Name="Customer_Id" Type="int" Nullable="false" />
          <Property Name="Department" Type="nvarchar" MaxLength="50" />
          <Property Name="Department_BL" Type="nvarchar" MaxLength="50" />
          <Property Name="Mobile" Type="nvarchar" MaxLength="50" />
          <Property Name="Status" Type="bit" Nullable="false" />
        </EntityType>
        <EntityType Name="Country">
          <Key>
            <PropertyRef Name="Country_Id" />
          </Key>
          <Property Name="Country_Id" Type="int" Nullable="false" StoreGeneratedPattern="Identity" />
          <Property Name="Country_Name" Type="nvarchar" Nullable="false" MaxLength="50" />
        </EntityType>
        <EntityType Name="Customer">
          <Key>
            <PropertyRef Name="Customer_Id" />
          </Key>
          <Property Name="Customer_Id" Type="int" Nullable="false" StoreGeneratedPattern="Identity" />
          <Property Name="Customer_Code" Type="nvarchar" MaxLength="50" />
          <Property Name="Customer_Name" Type="nvarchar" MaxLength="50" />
          <Property Name="Customer_Name_BL" Type="nvarchar" MaxLength="50" />
          <Property Name="Business_Type" Type="int" />
          <Property Name="Customer_Type" Type="int" />
          <Property Name="Customer_Group" Type="int" />
          <Property Name="Location_Id" Type="int" />
          <Property Name="Key_Account" Type="bit" />
          <Property Name="Status" Type="bit" Nullable="false" />
          <Property Name="Updated_By" Type="int" Nullable="false" />
          <Property Name="Updated_Date" Type="date" Nullable="false" />
          <Property Name="Sales_Channel" Type="int" />
        </EntityType>
        <EntityType Name="DSR">
          <Key>
            <PropertyRef Name="DSR_Id" />
          </Key>
          <Property Name="DSR_Id" Type="int" Nullable="false" StoreGeneratedPattern="Identity" />
          <Property Name="Site_User_Id" Type="int" Nullable="false" />
          <Property Name="Date" Type="date" Nullable="false" />
          <Property Name="Contact_Id" Type="int" Nullable="false" />
          <Property Name="Objective" Type="nvarchar" MaxLength="50" />
          <Property Name="Time_In" Type="time" />
          <Property Name="Time_Out" Type="time" />
          <Property Name="Time_Spent" Type="int" />
          <Property Name="Time_w_Merchandiser" Type="int" />
          <Property Name="Collection" Type="int" />
          <Property Name="Secondary_Sales" Type="int" />
          <Property Name="Sales_LPO_Received" Type="int" />
          <Property Name="Discount" Type="int" />
          <Property Name="Sales_Return" Type="int" />
          <Property Name="Remarks" Type="nvarchar" MaxLength="50" />
        </EntityType>
        <EntityType Name="DSR_Header">
          <Key>
            <PropertyRef Name="DSR_Head_Id" />
          </Key>
          <Property Name="DSR_Head_Id" Type="int" Nullable="false" StoreGeneratedPattern="Identity" />
          <Property Name="Date" Type="date" Nullable="false" />
          <Property Name="Shift" Type="nvarchar" MaxLength="50" />
          <Property Name="Morning_Time_In" Type="time" />
          <Property Name="Morning_Time_Out" Type="time" />
          <Property Name="Evening_Time_In" Type="time" />
          <Property Name="Evening_Time_Out" Type="time" />
          <Property Name="Comments" Type="nvarchar" MaxLength="50" />
          <Property Name="Site_User_Id" Type="int" Nullable="false" />
        </EntityType>
        <EntityType Name="Holiday">
          <Key>
            <PropertyRef Name="Holiday_Id" />
          </Key>
          <Property Name="Holiday_Id" Type="int" Nullable="false" StoreGeneratedPattern="Identity" />
          <Property Name="Date" Type="date" Nullable="false" />
          <Property Name="Country_Id" Type="int" Nullable="false" />
          <Property Name="Holiday_Type" Type="int" Nullable="false" />
        </EntityType>
        <EntityType Name="Location">
          <Key>
            <PropertyRef Name="Location_Id" />
          </Key>
          <Property Name="Location_Id" Type="int" Nullable="false" StoreGeneratedPattern="Identity" />
          <Property Name="Location_Name" Type="nvarchar" MaxLength="50" />
          <Property Name="Location_Name_BL" Type="nvarchar" MaxLength="50" />
          <Property Name="Region_Id" Type="int" Nullable="false" />
        </EntityType>
        <EntityType Name="Manager_Executive">
          <Key>
            <PropertyRef Name="Manager_Exec_Id" />
          </Key>
          <Property Name="Manager_Exec_Id" Type="int" Nullable="false" StoreGeneratedPattern="Identity" />
          <Property Name="Executive_Id" Type="int" Nullable="false" />
          <Property Name="Manager_Id" Type="int" Nullable="false" />
        </EntityType>
        <EntityType Name="Menu">
          <Key>
            <PropertyRef Name="MenuId" />
          </Key>
          <Property Name="MenuId" Type="int" Nullable="false" />
          <Property Name="MenuName" Type="nvarchar" Nullable="false" MaxLength="100" />
          <Property Name="MenuParentId" Type="int" />
          <Property Name="MenuStatus" Type="int" Nullable="false" />
          <Property Name="MenuOrder" Type="int" Nullable="false" />
        </EntityType>
        <EntityType Name="MenuAccess">
          <Key>
            <PropertyRef Name="MenuAccessId" />
          </Key>
          <Property Name="MenuAccessId" Type="int" Nullable="false" StoreGeneratedPattern="Identity" />
          <Property Name="MenuId" Type="int" Nullable="false" />
          <Property Name="AccessType" Type="int" Nullable="false" />
        </EntityType>
        <EntityType Name="MenuRolePages">
          <Key>
            <PropertyRef Name="MenuRoleId" />
          </Key>
          <Property Name="MenuRoleId" Type="int" Nullable="false" StoreGeneratedPattern="Identity" />
          <Property Name="MenuId" Type="int" Nullable="false" />
          <Property Name="RoleId" Type="int" Nullable="false" />
          <Property Name="PageUrl" Type="varchar" Nullable="false" MaxLength="200" />
        </EntityType>
        <EntityType Name="Parameter">
          <Key>
            <PropertyRef Name="ParameterId" />
          </Key>
          <Property Name="ParameterId" Type="int" Nullable="false" />
          <Property Name="ParameterText" Type="varchar" Nullable="false" MaxLength="100" />
        </EntityType>
        <EntityType Name="ParameterDet">
          <Key>
            <PropertyRef Name="ParameterDetId" />
          </Key>
          <Property Name="ParameterDetId" Type="int" Nullable="false" StoreGeneratedPattern="Identity" />
          <Property Name="ParameterId" Type="int" Nullable="false" />
          <Property Name="ParameterValue" Type="int" Nullable="false" />
          <Property Name="Code" Type="varchar" MaxLength="25" />
          <Property Name="Description" Type="varchar" Nullable="false" MaxLength="100" />
          <Property Name="Description_BL" Type="varchar" MaxLength="100" />
          <Property Name="SortOrder" Type="int" Nullable="false" />
        </EntityType>
        <EntityType Name="Region">
          <Key>
            <PropertyRef Name="Region_Id" />
          </Key>
          <Property Name="Region_Id" Type="int" Nullable="false" StoreGeneratedPattern="Identity" />
          <Property Name="Region_Name" Type="nvarchar" Nullable="false" MaxLength="50" />
          <Property Name="Country_Id" Type="int" Nullable="false" />
        </EntityType>
        <EntityType Name="Role">
          <Key>
            <PropertyRef Name="Role_Id" />
          </Key>
          <Property Name="Role_Id" Type="int" Nullable="false" StoreGeneratedPattern="Identity" />
          <Property Name="Role_Name" Type="nvarchar" Nullable="false" MaxLength="50" />
        </EntityType>
        <EntityType Name="RoleRights">
          <Key>
            <PropertyRef Name="RightsId" />
          </Key>
          <Property Name="RightsId" Type="int" Nullable="false" StoreGeneratedPattern="Identity" />
          <Property Name="RoleId" Type="int" Nullable="false" />
          <Property Name="MenuId" Type="int" Nullable="false" />
          <Property Name="AccessType" Type="int" Nullable="false" />
        </EntityType>
        <EntityType Name="Site_User">
          <Key>
            <PropertyRef Name="Site_User_Id" />
          </Key>
          <Property Name="Site_User_Id" Type="int" Nullable="false" StoreGeneratedPattern="Identity" />
          <Property Name="Role_Id" Type="int" Nullable="false" />
          <Property Name="Location_Id" Type="int" Nullable="false" />
          <Property Name="Name" Type="nvarchar" Nullable="false" MaxLength="50" />
          <Property Name="Login_Name" Type="nvarchar" MaxLength="50" />
          <Property Name="Password" Type="nvarchar" Nullable="false" MaxLength="50" />
          <Property Name="Email" Type="nvarchar" MaxLength="50" />
          <Property Name="Status" Type="bit" Nullable="false" />
          <Property Name="Employee_Code" Type="nvarchar" MaxLength="50" />
        </EntityType>
        <EntityType Name="sysdiagrams">
          <Key>
            <PropertyRef Name="diagram_id" />
          </Key>
          <Property Name="name" Type="nvarchar" Nullable="false" MaxLength="128" />
          <Property Name="principal_id" Type="int" Nullable="false" />
          <Property Name="diagram_id" Type="int" Nullable="false" StoreGeneratedPattern="Identity" />
          <Property Name="version" Type="int" />
          <Property Name="definition" Type="varbinary(max)" />
        </EntityType>
        <EntityType Name="Target">
          <Key>
            <PropertyRef Name="Target_Id" />
          </Key>
          <Property Name="Target_Id" Type="int" Nullable="false" StoreGeneratedPattern="Identity" />
          <Property Name="Month" Type="int" Nullable="false" />
          <Property Name="Year" Type="int" Nullable="false" />
          <Property Name="Site_User_Id" Type="int" Nullable="false" />
          <Property Name="Sales" Type="int" />
          <Property Name="Collection" Type="int" />
          <Property Name="Secondary_Sales" Type="int" />
        </EntityType>
        <EntityType Name="User_Language">
          <Key>
            <PropertyRef Name="User_Language_Id" />
          </Key>
          <Property Name="User_Language_Id" Type="int" Nullable="false" StoreGeneratedPattern="Identity" />
          <Property Name="Site_User_Id" Type="int" Nullable="false" />
          <Property Name="Language_Id" Type="int" Nullable="false" />
        </EntityType>
        <!--Errors Found During Generation:
      warning 6002: The table/view 'NikaiDSR.dbo.ActiveContactCustomerLocationView' does not have a primary key defined. The key has been inferred and the definition was created as a read-only table/view.
      -->
        <EntityType Name="ActiveContactCustomerLocationView">
          <Key>
            <PropertyRef Name="Customer_Id" />
            <PropertyRef Name="Customer_Status" />
            <PropertyRef Name="Location_Id" />
            <PropertyRef Name="Site_User_Id" />
            <PropertyRef Name="Updated_By" />
            <PropertyRef Name="Updated_Date" />
          </Key>
          <Property Name="Contact_Id" Type="int" />
          <Property Name="Contact_Name" Type="nvarchar" MaxLength="50" />
          <Property Name="Department" Type="nvarchar" MaxLength="50" />
          <Property Name="Contact_Status" Type="bit" />
          <Property Name="Customer_Id" Type="int" Nullable="false" />
          <Property Name="Customer_Name" Type="nvarchar" MaxLength="50" />
          <Property Name="Key_Account" Type="bit" />
          <Property Name="Customer_Status" Type="bit" Nullable="false" />
          <Property Name="Location_Id" Type="int" Nullable="false" />
          <Property Name="Location_Name" Type="nvarchar" MaxLength="50" />
          <Property Name="Site_User_Id" Type="int" Nullable="false" />
          <Property Name="Customer_Name_BL" Type="nvarchar" MaxLength="50" />
          <Property Name="Contact_Name_BL" Type="nvarchar" MaxLength="50" />
          <Property Name="Updated_By" Type="int" Nullable="false" />
          <Property Name="Updated_Date" Type="date" Nullable="false" />
          <Property Name="Customer_Code" Type="nvarchar" MaxLength="50" />
          <Property Name="Business_Type" Type="int" />
          <Property Name="Customer_Type" Type="int" />
          <Property Name="Customer_Group" Type="int" />
          <Property Name="Department_BL" Type="nvarchar" MaxLength="50" />
          <Property Name="Mobile" Type="nvarchar" MaxLength="50" />
        </EntityType>
        <!--Errors Found During Generation:
      warning 6002: The table/view 'NikaiDSR.dbo.ActiveCustomerLocationRegionCountryView' does not have a primary key defined. The key has been inferred and the definition was created as a read-only table/view.
      -->
        <EntityType Name="ActiveCustomerLocationRegionCountryView">
          <Key>
            <PropertyRef Name="Customer_Id" />
            <PropertyRef Name="Customer_Status" />
            <PropertyRef Name="Location_Id" />
            <PropertyRef Name="Updated_By" />
            <PropertyRef Name="Updated_Date" />
            <PropertyRef Name="Country_Name" />
            <PropertyRef Name="Region_Name" />
          </Key>
          <Property Name="Customer_Id" Type="int" Nullable="false" />
          <Property Name="Customer_Name" Type="nvarchar" MaxLength="50" />
          <Property Name="Key_Account" Type="bit" />
          <Property Name="Customer_Status" Type="bit" Nullable="false" />
          <Property Name="Location_Id" Type="int" Nullable="false" />
          <Property Name="Location_Name" Type="nvarchar" MaxLength="50" />
          <Property Name="Customer_Name_BL" Type="nvarchar" MaxLength="50" />
          <Property Name="Updated_By" Type="int" Nullable="false" />
          <Property Name="Updated_Date" Type="date" Nullable="false" />
          <Property Name="Customer_Code" Type="nvarchar" MaxLength="50" />
          <Property Name="Business_Type" Type="int" />
          <Property Name="Customer_Type" Type="int" />
          <Property Name="Customer_Group" Type="int" />
          <Property Name="Country_Name" Type="nvarchar" Nullable="false" MaxLength="50" />
          <Property Name="Region_Name" Type="nvarchar" Nullable="false" MaxLength="50" />
        </EntityType>
        <!--Errors Found During Generation:
      warning 6002: The table/view 'NikaiDSR.dbo.DsrContactCustomerLocationView' does not have a primary key defined. The key has been inferred and the definition was created as a read-only table/view.
      -->
        <EntityType Name="DsrContactCustomerLocationView">
          <Key>
            <PropertyRef Name="Site_User_Id" />
            <PropertyRef Name="DSR_Id" />
            <PropertyRef Name="Contact_Id" />
            <PropertyRef Name="Date" />
            <PropertyRef Name="Customer_Id" />
            <PropertyRef Name="Contact_Status" />
            <PropertyRef Name="Customer_Status" />
            <PropertyRef Name="Updated_By" />
            <PropertyRef Name="Updated_Date" />
          </Key>
          <Property Name="Site_User_Id" Type="int" Nullable="false" />
          <Property Name="DSR_Id" Type="int" Nullable="false" />
          <Property Name="Contact_Id" Type="int" Nullable="false" />
          <Property Name="Contact_Name" Type="nvarchar" MaxLength="50" />
          <Property Name="Date" Type="date" Nullable="false" />
          <Property Name="Customer_Id" Type="int" Nullable="false" />
          <Property Name="Contact_Status" Type="bit" Nullable="false" />
          <Property Name="Customer_Name" Type="nvarchar" MaxLength="50" />
          <Property Name="Location_Id" Type="int" />
          <Property Name="Customer_Status" Type="bit" Nullable="false" />
          <Property Name="Location_Name" Type="nvarchar" MaxLength="50" />
          <Property Name="Customer_Name_BL" Type="nvarchar" MaxLength="50" />
          <Property Name="Contact_Name_BL" Type="nvarchar" MaxLength="50" />
          <Property Name="Updated_By" Type="int" Nullable="false" />
          <Property Name="Updated_Date" Type="date" Nullable="false" />
          <Property Name="Location_Name_BL" Type="nvarchar" MaxLength="50" />
        </EntityType>
        <!--Errors Found During Generation:
      warning 6002: The table/view 'NikaiDSR.dbo.DSRReportView' does not have a primary key defined. The key has been inferred and the definition was created as a read-only table/view.
      -->
        <EntityType Name="DSRReportView">
          <Key>
            <PropertyRef Name="Site_User_Id" />
            <PropertyRef Name="Date" />
            <PropertyRef Name="Customer_Id" />
            <PropertyRef Name="Contact_Id" />
            <PropertyRef Name="Status_Contact" />
            <PropertyRef Name="Status_Customer" />
          </Key>
          <Property Name="Site_User_Id" Type="int" Nullable="false" />
          <Property Name="Date" Type="date" Nullable="false" />
          <Property Name="Customer_Id" Type="int" Nullable="false" />
          <Property Name="Customer_Code" Type="nvarchar" MaxLength="50" />
          <Property Name="Customer_Name" Type="nvarchar" MaxLength="50" />
          <Property Name="Customer_Name_BL" Type="nvarchar" MaxLength="50" />
          <Property Name="Contact_Id" Type="int" Nullable="false" />
          <Property Name="Contact_Name" Type="nvarchar" MaxLength="50" />
          <Property Name="Contact_Name_BL" Type="nvarchar" MaxLength="50" />
          <Property Name="Department_BL" Type="nvarchar" MaxLength="50" />
          <Property Name="Department" Type="nvarchar" MaxLength="50" />
          <Property Name="Mobile" Type="nvarchar" MaxLength="50" />
          <Property Name="Status_Contact" Type="bit" Nullable="false" />
          <Property Name="Objective" Type="nvarchar" MaxLength="50" />
          <Property Name="Time_In" Type="time" />
          <Property Name="Time_Out" Type="time" />
          <Property Name="Time_Spent" Type="int" />
          <Property Name="Time_w_Merchandiser" Type="int" />
          <Property Name="Collection" Type="int" />
          <Property Name="Secondary_Sales" Type="int" />
          <Property Name="Sales_LPO_Received" Type="int" />
          <Property Name="Discount" Type="int" />
          <Property Name="Sales_Return" Type="int" />
          <Property Name="Remarks" Type="nvarchar" MaxLength="50" />
          <Property Name="Status_Customer" Type="bit" Nullable="false" />
        </EntityType>
        <!--Errors Found During Generation:
      warning 6002: The table/view 'NikaiDSR.dbo.UserRoleLocationRegionCountryView' does not have a primary key defined. The key has been inferred and the definition was created as a read-only table/view.
      -->
        <EntityType Name="UserRoleLocationRegionCountryView">
          <Key>
            <PropertyRef Name="Site_User_Id" />
            <PropertyRef Name="Name" />
            <PropertyRef Name="Status" />
            <PropertyRef Name="Role_Id" />
            <PropertyRef Name="Role_Name" />
            <PropertyRef Name="Location_Id" />
            <PropertyRef Name="Location_Name" />
            <PropertyRef Name="Region_Id" />
            <PropertyRef Name="Region_Name" />
            <PropertyRef Name="Country_Id" />
            <PropertyRef Name="Country_Name" />
          </Key>
          <Property Name="Site_User_Id" Type="int" Nullable="false" />
          <Property Name="Name" Type="nvarchar" Nullable="false" MaxLength="50" />
          <Property Name="Email" Type="nvarchar" MaxLength="50" />
          <Property Name="Status" Type="bit" Nullable="false" />
          <Property Name="Role_Id" Type="int" Nullable="false" />
          <Property Name="Role_Name" Type="nvarchar" Nullable="false" MaxLength="50" />
          <Property Name="Location_Id" Type="int" Nullable="false" />
          <Property Name="Location_Name" Type="nvarchar" Nullable="false" MaxLength="50" />
          <Property Name="Region_Id" Type="int" Nullable="false" />
          <Property Name="Region_Name" Type="nvarchar" Nullable="false" MaxLength="50" />
          <Property Name="Country_Id" Type="int" Nullable="false" />
          <Property Name="Country_Name" Type="nvarchar" Nullable="false" MaxLength="50" />
        </EntityType>
        <Association Name="FK_Absent_Site_User">
          <End Role="Site_User" Type="NikaiDSRModel.Store.Site_User" Multiplicity="1" />
          <End Role="Absent" Type="NikaiDSRModel.Store.Absent" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="Site_User">
              <PropertyRef Name="Site_User_Id" />
            </Principal>
            <Dependent Role="Absent">
              <PropertyRef Name="Site_User_Id" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_Contact_Customer">
          <End Role="Customer" Type="NikaiDSRModel.Store.Customer" Multiplicity="1" />
          <End Role="Contact" Type="NikaiDSRModel.Store.Contact" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="Customer">
              <PropertyRef Name="Customer_Id" />
            </Principal>
            <Dependent Role="Contact">
              <PropertyRef Name="Customer_Id" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_Customer_Location">
          <End Role="Location" Type="NikaiDSRModel.Store.Location" Multiplicity="0..1" />
          <End Role="Customer" Type="NikaiDSRModel.Store.Customer" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="Location">
              <PropertyRef Name="Location_Id" />
            </Principal>
            <Dependent Role="Customer">
              <PropertyRef Name="Location_Id" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_Customer_ParameterDet">
          <End Role="ParameterDet" Type="NikaiDSRModel.Store.ParameterDet" Multiplicity="0..1" />
          <End Role="Customer" Type="NikaiDSRModel.Store.Customer" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="ParameterDet">
              <PropertyRef Name="ParameterDetId" />
            </Principal>
            <Dependent Role="Customer">
              <PropertyRef Name="Business_Type" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_Customer_ParameterDet1">
          <End Role="ParameterDet" Type="NikaiDSRModel.Store.ParameterDet" Multiplicity="0..1" />
          <End Role="Customer" Type="NikaiDSRModel.Store.Customer" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="ParameterDet">
              <PropertyRef Name="ParameterDetId" />
            </Principal>
            <Dependent Role="Customer">
              <PropertyRef Name="Customer_Group" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_Customer_ParameterDet2">
          <End Role="ParameterDet" Type="NikaiDSRModel.Store.ParameterDet" Multiplicity="0..1" />
          <End Role="Customer" Type="NikaiDSRModel.Store.Customer" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="ParameterDet">
              <PropertyRef Name="ParameterDetId" />
            </Principal>
            <Dependent Role="Customer">
              <PropertyRef Name="Customer_Type" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_Customer_ParameterDet3">
          <End Role="ParameterDet" Type="NikaiDSRModel.Store.ParameterDet" Multiplicity="0..1" />
          <End Role="Customer" Type="NikaiDSRModel.Store.Customer" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="ParameterDet">
              <PropertyRef Name="ParameterDetId" />
            </Principal>
            <Dependent Role="Customer">
              <PropertyRef Name="Sales_Channel" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_Customer_Site_User">
          <End Role="Site_User" Type="NikaiDSRModel.Store.Site_User" Multiplicity="1" />
          <End Role="Customer" Type="NikaiDSRModel.Store.Customer" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="Site_User">
              <PropertyRef Name="Site_User_Id" />
            </Principal>
            <Dependent Role="Customer">
              <PropertyRef Name="Updated_By" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_DSR_Contact">
          <End Role="Contact" Type="NikaiDSRModel.Store.Contact" Multiplicity="1" />
          <End Role="DSR" Type="NikaiDSRModel.Store.DSR" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="Contact">
              <PropertyRef Name="Contact_Id" />
            </Principal>
            <Dependent Role="DSR">
              <PropertyRef Name="Contact_Id" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_DSR_DSR_Header">
          <End Role="Site_User" Type="NikaiDSRModel.Store.Site_User" Multiplicity="1" />
          <End Role="DSR" Type="NikaiDSRModel.Store.DSR" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="Site_User">
              <PropertyRef Name="Site_User_Id" />
            </Principal>
            <Dependent Role="DSR">
              <PropertyRef Name="Site_User_Id" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_Holiday_Country">
          <End Role="Country" Type="NikaiDSRModel.Store.Country" Multiplicity="1" />
          <End Role="Holiday" Type="NikaiDSRModel.Store.Holiday" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="Country">
              <PropertyRef Name="Country_Id" />
            </Principal>
            <Dependent Role="Holiday">
              <PropertyRef Name="Country_Id" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_Holiday_ParameterDet">
          <End Role="ParameterDet" Type="NikaiDSRModel.Store.ParameterDet" Multiplicity="1" />
          <End Role="Holiday" Type="NikaiDSRModel.Store.Holiday" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="ParameterDet">
              <PropertyRef Name="ParameterDetId" />
            </Principal>
            <Dependent Role="Holiday">
              <PropertyRef Name="Holiday_Type" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_Location_Region">
          <End Role="Region" Type="NikaiDSRModel.Store.Region" Multiplicity="1" />
          <End Role="Location" Type="NikaiDSRModel.Store.Location" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="Region">
              <PropertyRef Name="Region_Id" />
            </Principal>
            <Dependent Role="Location">
              <PropertyRef Name="Region_Id" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_Manager_Executive_Site_User">
          <End Role="Site_User" Type="NikaiDSRModel.Store.Site_User" Multiplicity="1" />
          <End Role="Manager_Executive" Type="NikaiDSRModel.Store.Manager_Executive" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="Site_User">
              <PropertyRef Name="Site_User_Id" />
            </Principal>
            <Dependent Role="Manager_Executive">
              <PropertyRef Name="Manager_Id" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_Menu_ParameterDet">
          <End Role="ParameterDet" Type="NikaiDSRModel.Store.ParameterDet" Multiplicity="1" />
          <End Role="Menu" Type="NikaiDSRModel.Store.Menu" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="ParameterDet">
              <PropertyRef Name="ParameterDetId" />
            </Principal>
            <Dependent Role="Menu">
              <PropertyRef Name="MenuStatus" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_MenuAccess_Menu">
          <End Role="Menu" Type="NikaiDSRModel.Store.Menu" Multiplicity="1" />
          <End Role="MenuAccess" Type="NikaiDSRModel.Store.MenuAccess" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="Menu">
              <PropertyRef Name="MenuId" />
            </Principal>
            <Dependent Role="MenuAccess">
              <PropertyRef Name="MenuId" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_MenuAccess_ParameterDet">
          <End Role="ParameterDet" Type="NikaiDSRModel.Store.ParameterDet" Multiplicity="1" />
          <End Role="MenuAccess" Type="NikaiDSRModel.Store.MenuAccess" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="ParameterDet">
              <PropertyRef Name="ParameterDetId" />
            </Principal>
            <Dependent Role="MenuAccess">
              <PropertyRef Name="AccessType" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_MenuRolePages_Menu">
          <End Role="Menu" Type="NikaiDSRModel.Store.Menu" Multiplicity="1" />
          <End Role="MenuRolePages" Type="NikaiDSRModel.Store.MenuRolePages" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="Menu">
              <PropertyRef Name="MenuId" />
            </Principal>
            <Dependent Role="MenuRolePages">
              <PropertyRef Name="MenuId" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_MenuRolePages_ParameterDet">
          <End Role="Role" Type="NikaiDSRModel.Store.Role" Multiplicity="1" />
          <End Role="MenuRolePages" Type="NikaiDSRModel.Store.MenuRolePages" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="Role">
              <PropertyRef Name="Role_Id" />
            </Principal>
            <Dependent Role="MenuRolePages">
              <PropertyRef Name="RoleId" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_ParameterDet_Parameter">
          <End Role="Parameter" Type="NikaiDSRModel.Store.Parameter" Multiplicity="1" />
          <End Role="ParameterDet" Type="NikaiDSRModel.Store.ParameterDet" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="Parameter">
              <PropertyRef Name="ParameterId" />
            </Principal>
            <Dependent Role="ParameterDet">
              <PropertyRef Name="ParameterId" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_Region_Country">
          <End Role="Country" Type="NikaiDSRModel.Store.Country" Multiplicity="1" />
          <End Role="Region" Type="NikaiDSRModel.Store.Region" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="Country">
              <PropertyRef Name="Country_Id" />
            </Principal>
            <Dependent Role="Region">
              <PropertyRef Name="Country_Id" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_RoleRights_Menu">
          <End Role="Menu" Type="NikaiDSRModel.Store.Menu" Multiplicity="1" />
          <End Role="RoleRights" Type="NikaiDSRModel.Store.RoleRights" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="Menu">
              <PropertyRef Name="MenuId" />
            </Principal>
            <Dependent Role="RoleRights">
              <PropertyRef Name="MenuId" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_RoleRights_ParameterDet">
          <End Role="Role" Type="NikaiDSRModel.Store.Role" Multiplicity="1" />
          <End Role="RoleRights" Type="NikaiDSRModel.Store.RoleRights" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="Role">
              <PropertyRef Name="Role_Id" />
            </Principal>
            <Dependent Role="RoleRights">
              <PropertyRef Name="RoleId" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_RoleRights_ParameterDet1">
          <End Role="ParameterDet" Type="NikaiDSRModel.Store.ParameterDet" Multiplicity="1" />
          <End Role="RoleRights" Type="NikaiDSRModel.Store.RoleRights" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="ParameterDet">
              <PropertyRef Name="ParameterDetId" />
            </Principal>
            <Dependent Role="RoleRights">
              <PropertyRef Name="AccessType" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_Site_User_Location">
          <End Role="Location" Type="NikaiDSRModel.Store.Location" Multiplicity="1" />
          <End Role="Site_User" Type="NikaiDSRModel.Store.Site_User" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="Location">
              <PropertyRef Name="Location_Id" />
            </Principal>
            <Dependent Role="Site_User">
              <PropertyRef Name="Location_Id" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_Site_User_Role">
          <End Role="Role" Type="NikaiDSRModel.Store.Role" Multiplicity="1" />
          <End Role="Site_User" Type="NikaiDSRModel.Store.Site_User" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="Role">
              <PropertyRef Name="Role_Id" />
            </Principal>
            <Dependent Role="Site_User">
              <PropertyRef Name="Role_Id" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_Target_Site_User">
          <End Role="Site_User" Type="NikaiDSRModel.Store.Site_User" Multiplicity="1" />
          <End Role="Target" Type="NikaiDSRModel.Store.Target" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="Site_User">
              <PropertyRef Name="Site_User_Id" />
            </Principal>
            <Dependent Role="Target">
              <PropertyRef Name="Site_User_Id" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_User_Language_ParameterDet">
          <End Role="ParameterDet" Type="NikaiDSRModel.Store.ParameterDet" Multiplicity="1" />
          <End Role="User_Language" Type="NikaiDSRModel.Store.User_Language" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="ParameterDet">
              <PropertyRef Name="ParameterDetId" />
            </Principal>
            <Dependent Role="User_Language">
              <PropertyRef Name="Language_Id" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_User_Language_Site_User">
          <End Role="Site_User" Type="NikaiDSRModel.Store.Site_User" Multiplicity="1" />
          <End Role="User_Language" Type="NikaiDSRModel.Store.User_Language" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="Site_User">
              <PropertyRef Name="Site_User_Id" />
            </Principal>
            <Dependent Role="User_Language">
              <PropertyRef Name="Site_User_Id" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Function Name="ActiveCustomerLocationRegionCountry" Aggregate="false" BuiltIn="false" NiladicFunction="false" IsComposable="false" ParameterTypeSemantics="AllowImplicitConversion" Schema="dbo">
          <Parameter Name="User_Id" Type="int" Mode="In" />
        </Function>
        <Function Name="ChangePassword" Aggregate="false" BuiltIn="false" NiladicFunction="false" IsComposable="false" ParameterTypeSemantics="AllowImplicitConversion" Schema="dbo">
          <Parameter Name="User_Id" Type="int" Mode="In" />
          <Parameter Name="Password" Type="nvarchar" Mode="In" />
        </Function>
        <Function Name="fn_diagramobjects" ReturnType="int" Aggregate="false" BuiltIn="false" NiladicFunction="false" IsComposable="true" ParameterTypeSemantics="AllowImplicitConversion" Schema="dbo" />
        <Function Name="GetAbsent" Aggregate="false" BuiltIn="false" NiladicFunction="false" IsComposable="false" ParameterTypeSemantics="AllowImplicitConversion" Schema="dbo">
          <Parameter Name="Absent_Id" Type="int" Mode="In" />
          <Parameter Name="Date" Type="datetime" Mode="In" />
          <Parameter Name="Site_User_Id" Type="int" Mode="In" />
        </Function>
        <Function Name="GetActiveContactCustomerLocation" Aggregate="false" BuiltIn="false" NiladicFunction="false" IsComposable="false" ParameterTypeSemantics="AllowImplicitConversion" Schema="dbo">
          <Parameter Name="User_Id" Type="int" Mode="In" />
        </Function>
        <Function Name="GetActiveCustomerLocationRegionCountry" Aggregate="false" BuiltIn="false" NiladicFunction="false" IsComposable="false" ParameterTypeSemantics="AllowImplicitConversion" Schema="dbo">
          <Parameter Name="User_Id" Type="int" Mode="In" />
        </Function>
        <Function Name="GetActiveDsrContactCustomerLocation" Aggregate="false" BuiltIn="false" NiladicFunction="false" IsComposable="false" ParameterTypeSemantics="AllowImplicitConversion" Schema="dbo">
          <Parameter Name="User_Id" Type="int" Mode="In" />
          <Parameter Name="Date" Type="date" Mode="In" />
        </Function>
        <Function Name="GetAttendance" Aggregate="false" BuiltIn="false" NiladicFunction="false" IsComposable="false" ParameterTypeSemantics="AllowImplicitConversion" Schema="dbo">
          <Parameter Name="DatePeriod" Type="int" Mode="In" />
          <Parameter Name="SpecificDate" Type="date" Mode="In" />
          <Parameter Name="User_Id" Type="int" Mode="In" />
        </Function>
        <Function Name="GetAttendanceAndDSR" Aggregate="false" BuiltIn="false" NiladicFunction="false" IsComposable="false" ParameterTypeSemantics="AllowImplicitConversion" Schema="dbo">
          <Parameter Name="DatePeriod" Type="int" Mode="In" />
          <Parameter Name="SpecificDate" Type="date" Mode="In" />
          <Parameter Name="User_Id" Type="int" Mode="In" />
          <Parameter Name="Search_User_Id" Type="int" Mode="In" />
        </Function>
        <Function Name="GetContact" Aggregate="false" BuiltIn="false" NiladicFunction="false" IsComposable="false" ParameterTypeSemantics="AllowImplicitConversion" Schema="dbo">
          <Parameter Name="Contact_Id" Type="int" Mode="In" />
          <Parameter Name="Contact_Name" Type="nvarchar" Mode="In" />
          <Parameter Name="Contact_Name_BL" Type="nvarchar" Mode="In" />
          <Parameter Name="Customer_Id" Type="int" Mode="In" />
          <Parameter Name="Department" Type="nvarchar" Mode="In" />
          <Parameter Name="Department_BL" Type="nvarchar" Mode="In" />
          <Parameter Name="Mobile" Type="int" Mode="In" />
          <Parameter Name="Status" Type="int" Mode="In" />
        </Function>
        <Function Name="GetContactWithCustName" Aggregate="false" BuiltIn="false" NiladicFunction="false" IsComposable="false" ParameterTypeSemantics="AllowImplicitConversion" Schema="dbo">
          <Parameter Name="Contact_Id" Type="int" Mode="In" />
          <Parameter Name="Contact_Name" Type="nvarchar" Mode="In" />
          <Parameter Name="Customer_Name" Type="nvarchar" Mode="In" />
          <Parameter Name="Contact_Name_BL" Type="nvarchar" Mode="In" />
          <Parameter Name="Customer_Id" Type="int" Mode="In" />
          <Parameter Name="Department" Type="nvarchar" Mode="In" />
          <Parameter Name="Department_BL" Type="nvarchar" Mode="In" />
          <Parameter Name="Mobile" Type="nvarchar" Mode="In" />
          <Parameter Name="Status" Type="int" Mode="In" />
        </Function>
        <Function Name="GetCountry" Aggregate="false" BuiltIn="false" NiladicFunction="false" IsComposable="false" ParameterTypeSemantics="AllowImplicitConversion" Schema="dbo">
          <Parameter Name="Country_Id" Type="int" Mode="In" />
          <Parameter Name="Country_Name" Type="nvarchar" Mode="In" />
        </Function>
        <Function Name="GetCustomer" Aggregate="false" BuiltIn="false" NiladicFunction="false" IsComposable="false" ParameterTypeSemantics="AllowImplicitConversion" Schema="dbo">
          <Parameter Name="Customer_Id" Type="int" Mode="In" />
          <Parameter Name="Customer_Code" Type="nvarchar" Mode="In" />
          <Parameter Name="Customer_Name" Type="nvarchar" Mode="In" />
          <Parameter Name="Customer_Name_BL" Type="nvarchar" Mode="In" />
          <Parameter Name="Business_Type" Type="int" Mode="In" />
          <Parameter Name="Customer_Type" Type="int" Mode="In" />
          <Parameter Name="Customer_Group" Type="int" Mode="In" />
          <Parameter Name="Location_Id" Type="int" Mode="In" />
          <Parameter Name="Key_Account" Type="bit" Mode="In" />
          <Parameter Name="Status" Type="bit" Mode="In" />
          <Parameter Name="Sales_Channel" Type="int" Mode="In" />
        </Function>
        <Function Name="GetDSR" Aggregate="false" BuiltIn="false" NiladicFunction="false" IsComposable="false" ParameterTypeSemantics="AllowImplicitConversion" Schema="dbo">
          <Parameter Name="DSR_Id" Type="int" Mode="In" />
          <Parameter Name="Site_User_Id" Type="int" Mode="In" />
          <Parameter Name="Date" Type="date" Mode="In" />
          <Parameter Name="Contact_Id" Type="int" Mode="In" />
          <Parameter Name="Objective" Type="int" Mode="In" />
          <Parameter Name="Time_In" Type="time" Mode="In" />
          <Parameter Name="Time_Out" Type="time" Mode="In" />
          <Parameter Name="Time_Spent" Type="int" Mode="In" />
          <Parameter Name="Time_w_Merchandiser" Type="int" Mode="In" />
          <Parameter Name="Collection" Type="int" Mode="In" />
          <Parameter Name="Secondary_Sales" Type="int" Mode="In" />
          <Parameter Name="Sales_LPO_Received" Type="int" Mode="In" />
          <Parameter Name="Discount" Type="int" Mode="In" />
          <Parameter Name="Sales_Return" Type="int" Mode="In" />
          <Parameter Name="Remarks" Type="nvarchar" Mode="In" />
        </Function>
        <Function Name="GetDSRHeader" Aggregate="false" BuiltIn="false" NiladicFunction="false" IsComposable="false" ParameterTypeSemantics="AllowImplicitConversion" Schema="dbo">
          <Parameter Name="DSR_Head_Id" Type="int" Mode="In" />
          <Parameter Name="Date" Type="date" Mode="In" />
          <Parameter Name="Shift" Type="nvarchar" Mode="In" />
          <Parameter Name="Morning_Time_In" Type="time" Mode="In" />
          <Parameter Name="Morning_Time_Out" Type="time" Mode="In" />
          <Parameter Name="Evening_Time_In" Type="time" Mode="In" />
          <Parameter Name="Evening_Time_Out" Type="time" Mode="In" />
          <Parameter Name="Comments" Type="nvarchar" Mode="In" />
          <Parameter Name="Site_User_Id" Type="int" Mode="In" />
        </Function>
        <Function Name="GetExecutiveReport" Aggregate="false" BuiltIn="false" NiladicFunction="false" IsComposable="false" ParameterTypeSemantics="AllowImplicitConversion" Schema="dbo">
          <Parameter Name="Month" Type="int" Mode="In" />
          <Parameter Name="Year" Type="int" Mode="In" />
          <Parameter Name="Executive_Id" Type="int" Mode="In" />
        </Function>
        <Function Name="GetExecutiveTargetsActuals" Aggregate="false" BuiltIn="false" NiladicFunction="false" IsComposable="false" ParameterTypeSemantics="AllowImplicitConversion" Schema="dbo">
          <Parameter Name="Month" Type="int" Mode="In" />
          <Parameter Name="Year" Type="int" Mode="In" />
          <Parameter Name="Executive_Id" Type="int" Mode="In" />
        </Function>
        <Function Name="GetHoliday" Aggregate="false" BuiltIn="false" NiladicFunction="false" IsComposable="false" ParameterTypeSemantics="AllowImplicitConversion" Schema="dbo">
          <Parameter Name="Holiday_Id" Type="int" Mode="In" />
          <Parameter Name="Date" Type="datetime" Mode="In" />
          <Parameter Name="Country_Id" Type="int" Mode="In" />
          <Parameter Name="Holiday_Type" Type="int" Mode="In" />
        </Function>
        <Function Name="GetLocation" Aggregate="false" BuiltIn="false" NiladicFunction="false" IsComposable="false" ParameterTypeSemantics="AllowImplicitConversion" Schema="dbo">
          <Parameter Name="Location_Id" Type="int" Mode="In" />
          <Parameter Name="Location_Name" Type="nvarchar" Mode="In" />
          <Parameter Name="Region_Id" Type="int" Mode="In" />
        </Function>
        <Function Name="GetManagerExecutive" Aggregate="false" BuiltIn="false" NiladicFunction="false" IsComposable="false" ParameterTypeSemantics="AllowImplicitConversion" Schema="dbo">
          <Parameter Name="Manager_Id" Type="int" Mode="In" />
          <Parameter Name="Executive_Id" Type="int" Mode="In" />
        </Function>
        <Function Name="GetManagerReport" Aggregate="false" BuiltIn="false" NiladicFunction="false" IsComposable="false" ParameterTypeSemantics="AllowImplicitConversion" Schema="dbo">
          <Parameter Name="FromDate" Type="date" Mode="In" />
          <Parameter Name="ToDate" Type="date" Mode="In" />
          <Parameter Name="Country_Id" Type="int" Mode="In" />
          <Parameter Name="Region_Id" Type="int" Mode="In" />
          <Parameter Name="Location_Id" Type="int" Mode="In" />
          <Parameter Name="KeyAccounts" Type="bit" Mode="In" />
          <Parameter Name="Manager_Id" Type="int" Mode="In" />
          <Parameter Name="Search_Executive_Id" Type="int" Mode="In" />
          <Parameter Name="Report_ExecutiveWise" Type="bit" Mode="In" />
        </Function>
        <Function Name="GetParameter" Aggregate="false" BuiltIn="false" NiladicFunction="false" IsComposable="false" ParameterTypeSemantics="AllowImplicitConversion" Schema="dbo">
          <Parameter Name="ParameterId" Type="int" Mode="In" />
          <Parameter Name="ParameterDetId" Type="int" Mode="In" />
          <Parameter Name="ParameterValue" Type="int" Mode="In" />
        </Function>
        <Function Name="GetParameterDetId" ReturnType="int" Aggregate="false" BuiltIn="false" NiladicFunction="false" IsComposable="true" ParameterTypeSemantics="AllowImplicitConversion" Schema="dbo">
          <Parameter Name="ParameterId" Type="int" Mode="In" />
          <Parameter Name="ParameterValue" Type="int" Mode="In" />
        </Function>
        <Function Name="GetRegion" Aggregate="false" BuiltIn="false" NiladicFunction="false" IsComposable="false" ParameterTypeSemantics="AllowImplicitConversion" Schema="dbo">
          <Parameter Name="Region_Id" Type="int" Mode="In" />
          <Parameter Name="Region_Name" Type="nvarchar" Mode="In" />
          <Parameter Name="Country_Id" Type="int" Mode="In" />
        </Function>
        <Function Name="GetReporteesForUserCreation" Aggregate="false" BuiltIn="false" NiladicFunction="false" IsComposable="false" ParameterTypeSemantics="AllowImplicitConversion" Schema="dbo">
          <Parameter Name="Role_Id" Type="int" Mode="In" />
          <Parameter Name="Location_Id" Type="int" Mode="In" />
        </Function>
        <Function Name="GetRole" Aggregate="false" BuiltIn="false" NiladicFunction="false" IsComposable="false" ParameterTypeSemantics="AllowImplicitConversion" Schema="dbo">
          <Parameter Name="Role_Id" Type="int" Mode="In" />
          <Parameter Name="Role_Name" Type="nvarchar" Mode="In" />
        </Function>
        <Function Name="GetRoleRights" Aggregate="false" BuiltIn="false" NiladicFunction="false" IsComposable="false" ParameterTypeSemantics="AllowImplicitConversion" Schema="dbo">
          <Parameter Name="RoleId" Type="int" Mode="In" />
        </Function>
        <Function Name="GetSiteUser" Aggregate="false" BuiltIn="false" NiladicFunction="false" IsComposable="false" ParameterTypeSemantics="AllowImplicitConversion" Schema="dbo">
          <Parameter Name="Site_User_Id" Type="int" Mode="In" />
          <Parameter Name="Role_Id" Type="int" Mode="In" />
          <Parameter Name="Location_Id" Type="int" Mode="In" />
          <Parameter Name="Login_Name" Type="nvarchar" Mode="In" />
          <Parameter Name="Email" Type="nvarchar" Mode="In" />
        </Function>
        <Function Name="GetTarget" Aggregate="false" BuiltIn="false" NiladicFunction="false" IsComposable="false" ParameterTypeSemantics="AllowImplicitConversion" Schema="dbo">
          <Parameter Name="User_Id" Type="int" Mode="In" />
          <Parameter Name="Target_Id" Type="int" Mode="In" />
          <Parameter Name="Month" Type="int" Mode="In" />
          <Parameter Name="Year" Type="int" Mode="In" />
          <Parameter Name="Sales" Type="int" Mode="In" />
          <Parameter Name="Collection" Type="int" Mode="In" />
          <Parameter Name="Secondary_Sales" Type="int" Mode="In" />
        </Function>
        <Function Name="GetUser" Aggregate="false" BuiltIn="false" NiladicFunction="false" IsComposable="false" ParameterTypeSemantics="AllowImplicitConversion" Schema="dbo">
          <Parameter Name="UserId" Type="int" Mode="In" />
          <Parameter Name="UserName" Type="nvarchar" Mode="In" />
          <Parameter Name="Password" Type="nvarchar" Mode="In" />
        </Function>
        <Function Name="GetUserRoleLocationRegionCountry" Aggregate="false" BuiltIn="false" NiladicFunction="false" IsComposable="false" ParameterTypeSemantics="AllowImplicitConversion" Schema="dbo">
          <Parameter Name="User_Id" Type="int" Mode="In" />
          <Parameter Name="UserName" Type="nvarchar" Mode="In" />
          <Parameter Name="Email" Type="nvarchar" Mode="In" />
          <Parameter Name="Status" Type="bit" Mode="In" />
          <Parameter Name="RoleId" Type="int" Mode="In" />
          <Parameter Name="RoleName" Type="nvarchar" Mode="In" />
          <Parameter Name="LocationId" Type="int" Mode="In" />
          <Parameter Name="LocationName" Type="nvarchar" Mode="In" />
          <Parameter Name="RegionId" Type="int" Mode="In" />
          <Parameter Name="RegionName" Type="nvarchar" Mode="In" />
          <Parameter Name="CountryId" Type="int" Mode="In" />
          <Parameter Name="CountryName" Type="nvarchar" Mode="In" />
        </Function>
        <Function Name="InsertLocation" Aggregate="false" BuiltIn="false" NiladicFunction="false" IsComposable="false" ParameterTypeSemantics="AllowImplicitConversion" Schema="dbo">
          <Parameter Name="Location_Name" Type="nvarchar" Mode="In" />
          <Parameter Name="Region_Id" Type="int" Mode="In" />
        </Function>
        <Function Name="InsertRegion" Aggregate="false" BuiltIn="false" NiladicFunction="false" IsComposable="false" ParameterTypeSemantics="AllowImplicitConversion" Schema="dbo">
          <Parameter Name="Region_Name" Type="nvarchar" Mode="In" />
          <Parameter Name="Country_Id" Type="int" Mode="In" />
        </Function>
        <Function Name="InsertUpdateAbsent" Aggregate="false" BuiltIn="false" NiladicFunction="false" IsComposable="false" ParameterTypeSemantics="AllowImplicitConversion" Schema="dbo">
          <Parameter Name="Absent_Id" Type="int" Mode="In" />
          <Parameter Name="Date" Type="datetime" Mode="In" />
          <Parameter Name="Site_User_Id" Type="int" Mode="In" />
        </Function>
        <Function Name="InsertUpdateContact" Aggregate="false" BuiltIn="false" NiladicFunction="false" IsComposable="false" ParameterTypeSemantics="AllowImplicitConversion" Schema="dbo">
          <Parameter Name="Contact_Id" Type="int" Mode="In" />
          <Parameter Name="Contact_Name" Type="nvarchar" Mode="In" />
          <Parameter Name="Contact_Name_BL" Type="nvarchar" Mode="In" />
          <Parameter Name="Customer_Id" Type="int" Mode="In" />
          <Parameter Name="Department" Type="nvarchar" Mode="In" />
          <Parameter Name="Department_BL" Type="nvarchar" Mode="In" />
          <Parameter Name="Mobile" Type="nvarchar" Mode="In" />
          <Parameter Name="Status" Type="bit" Mode="In" />
          <Parameter Name="Cont_Id" Type="int" Mode="InOut" />
        </Function>
        <Function Name="InsertUpdateCountry" Aggregate="false" BuiltIn="false" NiladicFunction="false" IsComposable="false" ParameterTypeSemantics="AllowImplicitConversion" Schema="dbo">
          <Parameter Name="Country_Id" Type="int" Mode="In" />
          <Parameter Name="Country_Name" Type="nvarchar" Mode="In" />
        </Function>
        <Function Name="InsertUpdateCustomer" Aggregate="false" BuiltIn="false" NiladicFunction="false" IsComposable="false" ParameterTypeSemantics="AllowImplicitConversion" Schema="dbo">
          <Parameter Name="Customer_Id" Type="int" Mode="In" />
          <Parameter Name="Customer_Code" Type="nvarchar" Mode="In" />
          <Parameter Name="Customer_Name" Type="nvarchar" Mode="In" />
          <Parameter Name="Customer_Name_BL" Type="nvarchar" Mode="In" />
          <Parameter Name="Business_Type" Type="int" Mode="In" />
          <Parameter Name="Customer_Type" Type="int" Mode="In" />
          <Parameter Name="Customer_Group" Type="int" Mode="In" />
          <Parameter Name="Location_Id" Type="int" Mode="In" />
          <Parameter Name="Key_Account" Type="bit" Mode="In" />
          <Parameter Name="Status" Type="bit" Mode="In" />
          <Parameter Name="Updated_By" Type="int" Mode="In" />
          <Parameter Name="Sales_Channel" Type="int" Mode="In" />
          <Parameter Name="CustId" Type="int" Mode="InOut" />
        </Function>
        <Function Name="InsertUpdateDSR" Aggregate="false" BuiltIn="false" NiladicFunction="false" IsComposable="false" ParameterTypeSemantics="AllowImplicitConversion" Schema="dbo">
          <Parameter Name="DSR_Id" Type="int" Mode="In" />
          <Parameter Name="Site_User_Id" Type="int" Mode="In" />
          <Parameter Name="Date" Type="date" Mode="In" />
          <Parameter Name="Contact_Id" Type="int" Mode="In" />
          <Parameter Name="Objective" Type="int" Mode="In" />
          <Parameter Name="Time_In" Type="time" Mode="In" />
          <Parameter Name="Time_Out" Type="time" Mode="In" />
          <Parameter Name="Time_Spent" Type="int" Mode="In" />
          <Parameter Name="Time_w_Merchandiser" Type="int" Mode="In" />
          <Parameter Name="Collection" Type="int" Mode="In" />
          <Parameter Name="Secondary_Sales" Type="int" Mode="In" />
          <Parameter Name="Sales_LPO_Received" Type="int" Mode="In" />
          <Parameter Name="Discount" Type="int" Mode="In" />
          <Parameter Name="Sales_Return" Type="int" Mode="In" />
          <Parameter Name="Remarks" Type="nvarchar" Mode="In" />
        </Function>
        <Function Name="InsertUpdateDSRHeader" Aggregate="false" BuiltIn="false" NiladicFunction="false" IsComposable="false" ParameterTypeSemantics="AllowImplicitConversion" Schema="dbo">
          <Parameter Name="DSR_Head_Id" Type="int" Mode="In" />
          <Parameter Name="Date" Type="date" Mode="In" />
          <Parameter Name="Shift" Type="nvarchar" Mode="In" />
          <Parameter Name="Morning_Time_In" Type="time" Mode="In" />
          <Parameter Name="Morning_Time_Out" Type="time" Mode="In" />
          <Parameter Name="Evening_Time_In" Type="time" Mode="In" />
          <Parameter Name="Evening_Time_Out" Type="time" Mode="In" />
          <Parameter Name="Comments" Type="nvarchar" Mode="In" />
          <Parameter Name="Site_User_Id" Type="int" Mode="In" />
        </Function>
        <Function Name="InsertUpdateHoliday" Aggregate="false" BuiltIn="false" NiladicFunction="false" IsComposable="false" ParameterTypeSemantics="AllowImplicitConversion" Schema="dbo">
          <Parameter Name="Holiday_Id" Type="int" Mode="In" />
          <Parameter Name="Date" Type="datetime" Mode="In" />
          <Parameter Name="Country_Id" Type="int" Mode="In" />
          <Parameter Name="Holiday_Type" Type="int" Mode="In" />
        </Function>
        <Function Name="InsertUpdateLinkedExecutive" Aggregate="false" BuiltIn="false" NiladicFunction="false" IsComposable="false" ParameterTypeSemantics="AllowImplicitConversion" Schema="dbo">
          <Parameter Name="User_Id" Type="int" Mode="In" />
          <Parameter Name="LinkedUsers" Type="nvarchar" Mode="In" />
        </Function>
        <Function Name="InsertUpdateManagerExecutive" Aggregate="false" BuiltIn="false" NiladicFunction="false" IsComposable="false" ParameterTypeSemantics="AllowImplicitConversion" Schema="dbo">
          <Parameter Name="Manager_Exec_Id" Type="int" Mode="In" />
          <Parameter Name="Manager_Id" Type="int" Mode="In" />
          <Parameter Name="Executive_Id" Type="int" Mode="In" />
        </Function>
        <Function Name="InsertUpdateRole" Aggregate="false" BuiltIn="false" NiladicFunction="false" IsComposable="false" ParameterTypeSemantics="AllowImplicitConversion" Schema="dbo">
          <Parameter Name="Role_Id" Type="int" Mode="In" />
          <Parameter Name="Role_Name" Type="int" Mode="In" />
        </Function>
        <Function Name="InsertUpdateSiteUser" Aggregate="false" BuiltIn="false" NiladicFunction="false" IsComposable="false" ParameterTypeSemantics="AllowImplicitConversion" Schema="dbo">
          <Parameter Name="Site_User_Id" Type="int" Mode="In" />
          <Parameter Name="Role_Id" Type="int" Mode="In" />
          <Parameter Name="Location_Id" Type="int" Mode="In" />
          <Parameter Name="Name" Type="nvarchar" Mode="In" />
          <Parameter Name="Login_Name" Type="nvarchar" Mode="In" />
          <Parameter Name="Passsword" Type="nvarchar" Mode="In" />
          <Parameter Name="Email" Type="nvarchar" Mode="In" />
          <Parameter Name="Status" Type="bit" Mode="In" />
          <Parameter Name="Employee_Code" Type="nvarchar" Mode="In" />
        </Function>
        <Function Name="InsertUpdateTarget" Aggregate="false" BuiltIn="false" NiladicFunction="false" IsComposable="false" ParameterTypeSemantics="AllowImplicitConversion" Schema="dbo">
          <Parameter Name="Target_Id" Type="int" Mode="In" />
          <Parameter Name="Month" Type="int" Mode="In" />
          <Parameter Name="Year" Type="int" Mode="In" />
          <Parameter Name="Sales" Type="int" Mode="In" />
          <Parameter Name="Collection" Type="int" Mode="In" />
          <Parameter Name="Secondary_Sales" Type="int" Mode="In" />
          <Parameter Name="Site_User_Id" Type="int" Mode="In" />
        </Function>
        <Function Name="InsertUpdateUser" Aggregate="false" BuiltIn="false" NiladicFunction="false" IsComposable="false" ParameterTypeSemantics="AllowImplicitConversion" Schema="dbo">
          <Parameter Name="User_Id" Type="int" Mode="In" />
          <Parameter Name="Name" Type="nvarchar" Mode="In" />
          <Parameter Name="Password" Type="nvarchar" Mode="In" />
          <Parameter Name="Email" Type="nvarchar" Mode="In" />
          <Parameter Name="Role_Id" Type="int" Mode="In" />
          <Parameter Name="Location_Id" Type="int" Mode="In" />
          <Parameter Name="Employee_Code" Type="nvarchar" Mode="In" />
          <Parameter Name="Status" Type="bit" Mode="In" />
          <Parameter Name="LinkedUsers" Type="nvarchar" Mode="In" />
          <Parameter Name="Language_Id" Type="int" Mode="In" />
        </Function>
        <Function Name="InsertVisit" Aggregate="false" BuiltIn="false" NiladicFunction="false" IsComposable="false" ParameterTypeSemantics="AllowImplicitConversion" Schema="dbo">
          <Parameter Name="Customer_Id" Type="int" Mode="In" />
          <Parameter Name="Customer_Name" Type="nvarchar" Mode="In" />
          <Parameter Name="Customer_Name_BL" Type="nvarchar" Mode="In" />
          <Parameter Name="Location_Id" Type="int" Mode="In" />
          <Parameter Name="Contact_Id" Type="int" Mode="In" />
          <Parameter Name="Contact_Name" Type="nvarchar" Mode="In" />
          <Parameter Name="Contact_Name_BL" Type="nvarchar" Mode="In" />
          <Parameter Name="Department" Type="nvarchar" Mode="In" />
          <Parameter Name="Department_BL" Type="nvarchar" Mode="In" />
          <Parameter Name="Mobile" Type="nvarchar" Mode="In" />
          <Parameter Name="Site_User_Id" Type="int" Mode="In" />
          <Parameter Name="Date" Type="date" Mode="In" />
          <Parameter Name="Objective" Type="int" Mode="In" />
          <Parameter Name="Time_In" Type="time" Mode="In" />
          <Parameter Name="Time_Out" Type="time" Mode="In" />
          <Parameter Name="Time_w_Merchandiser" Type="int" Mode="In" />
          <Parameter Name="Collection" Type="int" Mode="In" />
          <Parameter Name="Secondary_Sales" Type="int" Mode="In" />
          <Parameter Name="Sales_LPO_Received" Type="int" Mode="In" />
          <Parameter Name="Discount" Type="int" Mode="In" />
          <Parameter Name="Sales_Return" Type="int" Mode="In" />
          <Parameter Name="Remarks" Type="nvarchar" Mode="In" />
          <Parameter Name="Updated_By" Type="int" Mode="In" />
        </Function>
        <Function Name="sp_alterdiagram" Aggregate="false" BuiltIn="false" NiladicFunction="false" IsComposable="false" ParameterTypeSemantics="AllowImplicitConversion" Schema="dbo">
          <Parameter Name="diagramname" Type="nvarchar" Mode="In" />
          <Parameter Name="owner_id" Type="int" Mode="In" />
          <Parameter Name="version" Type="int" Mode="In" />
          <Parameter Name="definition" Type="varbinary(max)" Mode="In" />
        </Function>
        <Function Name="sp_creatediagram" Aggregate="false" BuiltIn="false" NiladicFunction="false" IsComposable="false" ParameterTypeSemantics="AllowImplicitConversion" Schema="dbo">
          <Parameter Name="diagramname" Type="nvarchar" Mode="In" />
          <Parameter Name="owner_id" Type="int" Mode="In" />
          <Parameter Name="version" Type="int" Mode="In" />
          <Parameter Name="definition" Type="varbinary(max)" Mode="In" />
        </Function>
        <Function Name="sp_dropdiagram" Aggregate="false" BuiltIn="false" NiladicFunction="false" IsComposable="false" ParameterTypeSemantics="AllowImplicitConversion" Schema="dbo">
          <Parameter Name="diagramname" Type="nvarchar" Mode="In" />
          <Parameter Name="owner_id" Type="int" Mode="In" />
        </Function>
        <Function Name="sp_helpdiagramdefinition" Aggregate="false" BuiltIn="false" NiladicFunction="false" IsComposable="false" ParameterTypeSemantics="AllowImplicitConversion" Schema="dbo">
          <Parameter Name="diagramname" Type="nvarchar" Mode="In" />
          <Parameter Name="owner_id" Type="int" Mode="In" />
        </Function>
        <Function Name="sp_helpdiagrams" Aggregate="false" BuiltIn="false" NiladicFunction="false" IsComposable="false" ParameterTypeSemantics="AllowImplicitConversion" Schema="dbo">
          <Parameter Name="diagramname" Type="nvarchar" Mode="In" />
          <Parameter Name="owner_id" Type="int" Mode="In" />
        </Function>
        <Function Name="sp_renamediagram" Aggregate="false" BuiltIn="false" NiladicFunction="false" IsComposable="false" ParameterTypeSemantics="AllowImplicitConversion" Schema="dbo">
          <Parameter Name="diagramname" Type="nvarchar" Mode="In" />
          <Parameter Name="owner_id" Type="int" Mode="In" />
          <Parameter Name="new_diagramname" Type="nvarchar" Mode="In" />
        </Function>
        <Function Name="sp_upgraddiagrams" Aggregate="false" BuiltIn="false" NiladicFunction="false" IsComposable="false" ParameterTypeSemantics="AllowImplicitConversion" Schema="dbo" />
        <Function Name="UpdateLocation" Aggregate="false" BuiltIn="false" NiladicFunction="false" IsComposable="false" ParameterTypeSemantics="AllowImplicitConversion" Schema="dbo">
          <Parameter Name="Location_Id" Type="int" Mode="In" />
          <Parameter Name="Location_Name" Type="nvarchar" Mode="In" />
          <Parameter Name="Region_Id" Type="int" Mode="In" />
        </Function>
        <Function Name="UpdateRegion" Aggregate="false" BuiltIn="false" NiladicFunction="false" IsComposable="false" ParameterTypeSemantics="AllowImplicitConversion" Schema="dbo">
          <Parameter Name="Region_Id" Type="int" Mode="In" />
          <Parameter Name="Region_Name" Type="nvarchar" Mode="In" />
          <Parameter Name="Country_Id" Type="int" Mode="In" />
        </Function>
        <Function Name="UpdateVisit" Aggregate="false" BuiltIn="false" NiladicFunction="false" IsComposable="false" ParameterTypeSemantics="AllowImplicitConversion" Schema="dbo">
          <Parameter Name="DSR_Id" Type="int" Mode="In" />
          <Parameter Name="Customer_Id" Type="int" Mode="In" />
          <Parameter Name="Customer_Name" Type="nvarchar" Mode="In" />
          <Parameter Name="Customer_Name_BL" Type="nvarchar" Mode="In" />
          <Parameter Name="Location_Id" Type="int" Mode="In" />
          <Parameter Name="Contact_Id" Type="int" Mode="In" />
          <Parameter Name="Contact_Name" Type="nvarchar" Mode="In" />
          <Parameter Name="Contact_Name_BL" Type="nvarchar" Mode="In" />
          <Parameter Name="Department" Type="nvarchar" Mode="In" />
          <Parameter Name="Department_BL" Type="nvarchar" Mode="In" />
          <Parameter Name="Mobile" Type="nvarchar" Mode="In" />
          <Parameter Name="Site_User_Id" Type="int" Mode="In" />
          <Parameter Name="Date" Type="date" Mode="In" />
          <Parameter Name="Objective" Type="int" Mode="In" />
          <Parameter Name="Time_In" Type="time" Mode="In" />
          <Parameter Name="Time_Out" Type="time" Mode="In" />
          <Parameter Name="Time_w_Merchandiser" Type="int" Mode="In" />
          <Parameter Name="Collection" Type="int" Mode="In" />
          <Parameter Name="Secondary_Sales" Type="int" Mode="In" />
          <Parameter Name="Sales_LPO_Received" Type="int" Mode="In" />
          <Parameter Name="Discount" Type="int" Mode="In" />
          <Parameter Name="Sales_Return" Type="int" Mode="In" />
          <Parameter Name="Remarks" Type="nvarchar" Mode="In" />
          <Parameter Name="Updated_By" Type="int" Mode="In" />
        </Function>
      </Schema></edmx:StorageModels>
    <!-- CSDL content -->
    <edmx:ConceptualModels>
      <Schema Namespace="NikaiDSRModel" Alias="Self" xmlns:annotation="http://schemas.microsoft.com/ado/2009/02/edm/annotation" xmlns="http://schemas.microsoft.com/ado/2008/09/edm">
        <EntityContainer Name="NikaiDSREntities" annotation:LazyLoadingEnabled="true">
          <EntitySet Name="Absents" EntityType="NikaiDSRModel.Absent" />
          <EntitySet Name="Countries" EntityType="NikaiDSRModel.Country" />
          <EntitySet Name="Customers" EntityType="NikaiDSRModel.Customer" />
          <EntitySet Name="DSRs" EntityType="NikaiDSRModel.DSR" />
          <EntitySet Name="DSR_Header" EntityType="NikaiDSRModel.DSR_Header" />
          <EntitySet Name="Holidays" EntityType="NikaiDSRModel.Holiday" />
          <EntitySet Name="Manager_Executive" EntityType="NikaiDSRModel.Manager_Executive" />
          <EntitySet Name="Menus" EntityType="NikaiDSRModel.Menu" />
          <EntitySet Name="MenuAccesses" EntityType="NikaiDSRModel.MenuAccess" />
          <EntitySet Name="MenuRolePages" EntityType="NikaiDSRModel.MenuRolePage" />
          <EntitySet Name="Parameters" EntityType="NikaiDSRModel.Parameter" />
          <EntitySet Name="Regions" EntityType="NikaiDSRModel.Region" />
          <EntitySet Name="Roles" EntityType="NikaiDSRModel.Role" />
          <EntitySet Name="RoleRights" EntityType="NikaiDSRModel.RoleRight" />
          <EntitySet Name="Site_User" EntityType="NikaiDSRModel.Site_User" />
          <EntitySet Name="sysdiagrams" EntityType="NikaiDSRModel.sysdiagram" />
          <EntitySet Name="Targets" EntityType="NikaiDSRModel.Target" />
          <EntitySet Name="UserRoleLocationRegionCountryViews" EntityType="NikaiDSRModel.UserRoleLocationRegionCountryView" />
          <AssociationSet Name="FK_Absent_Site_User" Association="NikaiDSRModel.FK_Absent_Site_User">
            <End Role="Site_User" EntitySet="Site_User" />
            <End Role="Absent" EntitySet="Absents" />
          </AssociationSet>
          <AssociationSet Name="FK_Holiday_Country" Association="NikaiDSRModel.FK_Holiday_Country">
            <End Role="Country" EntitySet="Countries" />
            <End Role="Holiday" EntitySet="Holidays" />
          </AssociationSet>
          <AssociationSet Name="FK_Region_Country" Association="NikaiDSRModel.FK_Region_Country">
            <End Role="Country" EntitySet="Countries" />
            <End Role="Region" EntitySet="Regions" />
          </AssociationSet>
          <AssociationSet Name="FK_Customer_Site_User" Association="NikaiDSRModel.FK_Customer_Site_User">
            <End Role="Site_User" EntitySet="Site_User" />
            <End Role="Customer" EntitySet="Customers" />
          </AssociationSet>
          <AssociationSet Name="FK_DSR_DSR_Header" Association="NikaiDSRModel.FK_DSR_DSR_Header">
            <End Role="Site_User" EntitySet="Site_User" />
            <End Role="DSR" EntitySet="DSRs" />
          </AssociationSet>
          <AssociationSet Name="FK_Manager_Executive_Site_User" Association="NikaiDSRModel.FK_Manager_Executive_Site_User">
            <End Role="Site_User" EntitySet="Site_User" />
            <End Role="Manager_Executive" EntitySet="Manager_Executive" />
          </AssociationSet>
          <AssociationSet Name="FK_MenuAccess_Menu" Association="NikaiDSRModel.FK_MenuAccess_Menu">
            <End Role="Menu" EntitySet="Menus" />
            <End Role="MenuAccess" EntitySet="MenuAccesses" />
          </AssociationSet>
          <AssociationSet Name="FK_MenuRolePages_Menu" Association="NikaiDSRModel.FK_MenuRolePages_Menu">
            <End Role="Menu" EntitySet="Menus" />
            <End Role="MenuRolePages" EntitySet="MenuRolePages" />
          </AssociationSet>
          <AssociationSet Name="FK_RoleRights_Menu" Association="NikaiDSRModel.FK_RoleRights_Menu">
            <End Role="Menu" EntitySet="Menus" />
            <End Role="RoleRights" EntitySet="RoleRights" />
          </AssociationSet>
          <AssociationSet Name="FK_MenuRolePages_ParameterDet" Association="NikaiDSRModel.FK_MenuRolePages_ParameterDet">
            <End Role="Role" EntitySet="Roles" />
            <End Role="MenuRolePages" EntitySet="MenuRolePages" />
          </AssociationSet>
          <AssociationSet Name="FK_RoleRights_ParameterDet" Association="NikaiDSRModel.FK_RoleRights_ParameterDet">
            <End Role="Role" EntitySet="Roles" />
            <End Role="RoleRights" EntitySet="RoleRights" />
          </AssociationSet>
          <AssociationSet Name="FK_Site_User_Role" Association="NikaiDSRModel.FK_Site_User_Role">
            <End Role="Role" EntitySet="Roles" />
            <End Role="Site_User" EntitySet="Site_User" />
          </AssociationSet>
          <AssociationSet Name="FK_Target_Site_User" Association="NikaiDSRModel.FK_Target_Site_User">
            <End Role="Site_User" EntitySet="Site_User" />
            <End Role="Target" EntitySet="Targets" />
          </AssociationSet>
          <FunctionImport Name="ActiveCustomerLocationRegionCountry" ReturnType="Collection(NikaiDSRModel.ActiveCustomerLocationRegionCountry_Result)">
          <Parameter Name="User_Id" Mode="In" Type="Int32" />
          </FunctionImport>
          <FunctionImport Name="ChangePassword">
            <Parameter Name="User_Id" Mode="In" Type="Int32" />
            <Parameter Name="Password" Mode="In" Type="String" />
          </FunctionImport>
          <FunctionImport Name="GetAbsent" ReturnType="Collection(NikaiDSRModel.GetAbsent_Result)">
            <Parameter Name="Absent_Id" Mode="In" Type="Int32" />
            <Parameter Name="Date" Mode="In" Type="DateTime" />
            <Parameter Name="Site_User_Id" Mode="In" Type="Int32" />
          </FunctionImport>
          <FunctionImport Name="GetAttendance" ReturnType="Collection(NikaiDSRModel.GetAttendance_Result)">
            <Parameter Name="DatePeriod" Mode="In" Type="Int32" />
            <Parameter Name="SpecificDate" Mode="In" Type="DateTime" />
            <Parameter Name="User_Id" Mode="In" Type="Int32" />
          </FunctionImport>
          <FunctionImport Name="GetCountry" ReturnType="Collection(NikaiDSRModel.GetCountry_Result)">
            <Parameter Name="Country_Id" Mode="In" Type="Int32" />
            <Parameter Name="Country_Name" Mode="In" Type="String" />
          </FunctionImport>
          <FunctionImport Name="GetDSRHeader" ReturnType="Collection(NikaiDSRModel.GetDSRHeader_Result)">
            <Parameter Name="DSR_Head_Id" Mode="In" Type="Int32" />
            <Parameter Name="Date" Mode="In" Type="DateTime" />
            <Parameter Name="Shift" Mode="In" Type="String" />
            <Parameter Name="Morning_Time_In" Mode="In" Type="Time" />
            <Parameter Name="Morning_Time_Out" Mode="In" Type="Time" />
            <Parameter Name="Evening_Time_In" Mode="In" Type="Time" />
            <Parameter Name="Evening_Time_Out" Mode="In" Type="Time" />
            <Parameter Name="Comments" Mode="In" Type="String" />
            <Parameter Name="Site_User_Id" Mode="In" Type="Int32" />
          </FunctionImport>
          <FunctionImport Name="GetHoliday" ReturnType="Collection(NikaiDSRModel.GetHoliday_Result)">
            <Parameter Name="Holiday_Id" Mode="In" Type="Int32" />
            <Parameter Name="Date" Mode="In" Type="DateTime" />
            <Parameter Name="Country_Id" Mode="In" Type="Int32" />
            <Parameter Name="Holiday_Type" Mode="In" Type="Int32" />
          </FunctionImport>
          <FunctionImport Name="GetRegion" ReturnType="Collection(NikaiDSRModel.GetRegion_Result)">
            <Parameter Name="Region_Id" Mode="In" Type="Int32" />
            <Parameter Name="Region_Name" Mode="In" Type="String" />
            <Parameter Name="Country_Id" Mode="In" Type="Int32" />
          </FunctionImport>
          <FunctionImport Name="GetRole" ReturnType="Collection(NikaiDSRModel.GetRole_Result)">
            <Parameter Name="Role_Id" Mode="In" Type="Int32" />
            <Parameter Name="Role_Name" Mode="In" Type="String" />
          </FunctionImport>
          <FunctionImport Name="GetRoleRights" ReturnType="Collection(NikaiDSRModel.GetRoleRights_Result)">
          <Parameter Name="RoleId" Mode="In" Type="Int32" />
          </FunctionImport>
          <FunctionImport Name="GetSiteUser" ReturnType="Collection(NikaiDSRModel.GetSiteUser_Result)">
            <Parameter Name="Site_User_Id" Mode="In" Type="Int32" />
            <Parameter Name="Role_Id" Mode="In" Type="Int32" />
            <Parameter Name="Location_Id" Mode="In" Type="Int32" />
            <Parameter Name="Login_Name" Mode="In" Type="String" />
            <Parameter Name="Email" Mode="In" Type="String" />
          </FunctionImport>
          <FunctionImport Name="GetTarget" ReturnType="Collection(NikaiDSRModel.GetTarget_Result)">
            <Parameter Name="User_Id" Mode="In" Type="Int32" />
            <Parameter Name="Target_Id" Mode="In" Type="Int32" />
            <Parameter Name="Month" Mode="In" Type="Int32" />
            <Parameter Name="Year" Mode="In" Type="Int32" />
            <Parameter Name="Sales" Mode="In" Type="Int32" />
            <Parameter Name="Collection" Mode="In" Type="Int32" />
            <Parameter Name="Secondary_Sales" Mode="In" Type="Int32" />
          </FunctionImport>
          <FunctionImport Name="GetUserRoleLocationRegionCountry" ReturnType="Collection(NikaiDSRModel.GetUserRoleLocationRegionCountry_Result)">
            <Parameter Name="User_Id" Mode="In" Type="Int32" />
            <Parameter Name="UserName" Mode="In" Type="String" />
            <Parameter Name="Email" Mode="In" Type="String" />
            <Parameter Name="Status" Mode="In" Type="Boolean" />
            <Parameter Name="RoleId" Mode="In" Type="Int32" />
            <Parameter Name="RoleName" Mode="In" Type="String" />
            <Parameter Name="LocationId" Mode="In" Type="Int32" />
            <Parameter Name="LocationName" Mode="In" Type="String" />
            <Parameter Name="RegionId" Mode="In" Type="Int32" />
            <Parameter Name="RegionName" Mode="In" Type="String" />
            <Parameter Name="CountryId" Mode="In" Type="Int32" />
            <Parameter Name="CountryName" Mode="In" Type="String" />
          </FunctionImport>
          <FunctionImport Name="InsertLocation">
            <Parameter Name="Location_Name" Mode="In" Type="String" />
            <Parameter Name="Region_Id" Mode="In" Type="Int32" />
          </FunctionImport>
          <FunctionImport Name="InsertRegion">
            <Parameter Name="Region_Name" Mode="In" Type="String" />
            <Parameter Name="Country_Id" Mode="In" Type="Int32" />
          </FunctionImport>
          <FunctionImport Name="InsertUpdateAbsent">
            <Parameter Name="Absent_Id" Mode="In" Type="Int32" />
            <Parameter Name="Date" Mode="In" Type="DateTime" />
            <Parameter Name="Site_User_Id" Mode="In" Type="Int32" />
          </FunctionImport>
          <FunctionImport Name="InsertUpdateCountry">
            <Parameter Name="Country_Id" Mode="In" Type="Int32" />
            <Parameter Name="Country_Name" Mode="In" Type="String" />
          </FunctionImport>
          <FunctionImport Name="InsertUpdateDSR">
            <Parameter Name="DSR_Id" Mode="In" Type="Int32" />
            <Parameter Name="Site_User_Id" Mode="In" Type="Int32" />
            <Parameter Name="Date" Mode="In" Type="DateTime" />
            <Parameter Name="Contact_Id" Mode="In" Type="Int32" />
            <Parameter Name="Objective" Mode="In" Type="Int32" />
            <Parameter Name="Time_In" Mode="In" Type="Time" />
            <Parameter Name="Time_Out" Mode="In" Type="Time" />
            <Parameter Name="Time_Spent" Mode="In" Type="Int32" />
            <Parameter Name="Time_w_Merchandiser" Mode="In" Type="Int32" />
            <Parameter Name="Collection" Mode="In" Type="Int32" />
            <Parameter Name="Secondary_Sales" Mode="In" Type="Int32" />
            <Parameter Name="Sales_LPO_Received" Mode="In" Type="Int32" />
            <Parameter Name="Discount" Mode="In" Type="Int32" />
            <Parameter Name="Sales_Return" Mode="In" Type="Int32" />
            <Parameter Name="Remarks" Mode="In" Type="String" />
          </FunctionImport>
          <FunctionImport Name="InsertUpdateDSRHeader">
            <Parameter Name="DSR_Head_Id" Mode="In" Type="Int32" />
            <Parameter Name="Date" Mode="In" Type="DateTime" />
            <Parameter Name="Shift" Mode="In" Type="String" />
            <Parameter Name="Morning_Time_In" Mode="In" Type="Time" />
            <Parameter Name="Morning_Time_Out" Mode="In" Type="Time" />
            <Parameter Name="Evening_Time_In" Mode="In" Type="Time" />
            <Parameter Name="Evening_Time_Out" Mode="In" Type="Time" />
            <Parameter Name="Comments" Mode="In" Type="String" />
            <Parameter Name="Site_User_Id" Mode="In" Type="Int32" />
          </FunctionImport>
          <FunctionImport Name="InsertUpdateHoliday">
            <Parameter Name="Holiday_Id" Mode="In" Type="Int32" />
            <Parameter Name="Date" Mode="In" Type="DateTime" />
            <Parameter Name="Country_Id" Mode="In" Type="Int32" />
            <Parameter Name="Holiday_Type" Mode="In" Type="Int32" />
          </FunctionImport>
          <FunctionImport Name="InsertUpdateManagerExecutive">
            <Parameter Name="Manager_Exec_Id" Mode="In" Type="Int32" />
            <Parameter Name="Manager_Id" Mode="In" Type="Int32" />
            <Parameter Name="Executive_Id" Mode="In" Type="Int32" />
          </FunctionImport>
          <FunctionImport Name="InsertUpdateRole">
            <Parameter Name="Role_Id" Mode="In" Type="Int32" />
            <Parameter Name="Role_Name" Mode="In" Type="Int32" />
          </FunctionImport>
          <FunctionImport Name="InsertUpdateSiteUser">
            <Parameter Name="Site_User_Id" Mode="In" Type="Int32" />
            <Parameter Name="Role_Id" Mode="In" Type="Int32" />
            <Parameter Name="Location_Id" Mode="In" Type="Int32" />
            <Parameter Name="Name" Mode="In" Type="String" />
            <Parameter Name="Login_Name" Mode="In" Type="String" />
            <Parameter Name="Passsword" Mode="In" Type="String" />
            <Parameter Name="Email" Mode="In" Type="String" />
            <Parameter Name="Status" Mode="In" Type="Boolean" />
            <Parameter Name="Employee_Code" Mode="In" Type="String" />
          </FunctionImport>
          <FunctionImport Name="InsertUpdateTarget">
            <Parameter Name="Target_Id" Mode="In" Type="Int32" />
            <Parameter Name="Month" Mode="In" Type="Int32" />
            <Parameter Name="Year" Mode="In" Type="Int32" />
            <Parameter Name="Sales" Mode="In" Type="Int32" />
            <Parameter Name="Collection" Mode="In" Type="Int32" />
            <Parameter Name="Secondary_Sales" Mode="In" Type="Int32" />
            <Parameter Name="Site_User_Id" Mode="In" Type="Int32" />
          </FunctionImport>
          <FunctionImport Name="sp_alterdiagram">
            <Parameter Name="diagramname" Mode="In" Type="String" />
            <Parameter Name="owner_id" Mode="In" Type="Int32" />
            <Parameter Name="version" Mode="In" Type="Int32" />
            <Parameter Name="definition" Mode="In" Type="Binary" />
          </FunctionImport>
          <FunctionImport Name="sp_creatediagram">
            <Parameter Name="diagramname" Mode="In" Type="String" />
            <Parameter Name="owner_id" Mode="In" Type="Int32" />
            <Parameter Name="version" Mode="In" Type="Int32" />
            <Parameter Name="definition" Mode="In" Type="Binary" />
          </FunctionImport>
          <FunctionImport Name="sp_dropdiagram">
            <Parameter Name="diagramname" Mode="In" Type="String" />
            <Parameter Name="owner_id" Mode="In" Type="Int32" />
          </FunctionImport>
          <FunctionImport Name="sp_helpdiagramdefinition" ReturnType="Collection(NikaiDSRModel.sp_helpdiagramdefinition_Result)">
            <Parameter Name="diagramname" Mode="In" Type="String" />
            <Parameter Name="owner_id" Mode="In" Type="Int32" />
          </FunctionImport>
          <FunctionImport Name="sp_helpdiagrams" ReturnType="Collection(NikaiDSRModel.sp_helpdiagrams_Result)">
            <Parameter Name="diagramname" Mode="In" Type="String" />
            <Parameter Name="owner_id" Mode="In" Type="Int32" />
          </FunctionImport>
          <FunctionImport Name="sp_renamediagram">
            <Parameter Name="diagramname" Mode="In" Type="String" />
            <Parameter Name="owner_id" Mode="In" Type="Int32" />
            <Parameter Name="new_diagramname" Mode="In" Type="String" />
          </FunctionImport>
          <FunctionImport Name="sp_upgraddiagrams" />
          <FunctionImport Name="UpdateLocation">
            <Parameter Name="Location_Id" Mode="In" Type="Int32" />
            <Parameter Name="Location_Name" Mode="In" Type="String" />
            <Parameter Name="Region_Id" Mode="In" Type="Int32" />
          </FunctionImport>
          <FunctionImport Name="UpdateRegion">
            <Parameter Name="Region_Id" Mode="In" Type="Int32" />
            <Parameter Name="Region_Name" Mode="In" Type="String" />
            <Parameter Name="Country_Id" Mode="In" Type="Int32" />
          </FunctionImport>
          <FunctionImport Name="InsertUpdateLinkedExecutive">
            <Parameter Name="User_Id" Mode="In" Type="Int32" />
            <Parameter Name="LinkedUsers" Mode="In" Type="String" />
          </FunctionImport>
          <FunctionImport Name="GetAttendanceAndDSR" ReturnType="Collection(NikaiDSRModel.GetAttendanceAndDSR_Result)">
            <Parameter Name="DatePeriod" Mode="In" Type="Int32" />
            <Parameter Name="SpecificDate" Mode="In" Type="DateTime" />
            <Parameter Name="User_Id" Mode="In" Type="Int32" />
            <Parameter Name="Search_User_Id" Mode="In" Type="Int32" />
          </FunctionImport>
          <EntitySet Name="User_Language" EntityType="NikaiDSRModel.User_Language" />
          <AssociationSet Name="FK_User_Language_Site_User" Association="NikaiDSRModel.FK_User_Language_Site_User">
            <End Role="Site_User" EntitySet="Site_User" />
            <End Role="User_Language" EntitySet="User_Language" />
          </AssociationSet>
          <FunctionImport Name="GetUser" ReturnType="Collection(NikaiDSRModel.GetUser_Result)">
            <Parameter Name="UserId" Mode="In" Type="Int32" />
            <Parameter Name="UserName" Mode="In" Type="String" />
            <Parameter Name="Password" Mode="In" Type="String" />
          </FunctionImport>
          <EntitySet Name="ParameterDets" EntityType="NikaiDSRModel.ParameterDet" />
          <AssociationSet Name="FK_Customer_ParameterDet" Association="NikaiDSRModel.FK_Customer_ParameterDet">
            <End Role="ParameterDet" EntitySet="ParameterDets" />
            <End Role="Customer" EntitySet="Customers" />
          </AssociationSet>
          <AssociationSet Name="FK_Customer_ParameterDet1" Association="NikaiDSRModel.FK_Customer_ParameterDet1">
            <End Role="ParameterDet" EntitySet="ParameterDets" />
            <End Role="Customer" EntitySet="Customers" />
          </AssociationSet>
          <AssociationSet Name="FK_Customer_ParameterDet2" Association="NikaiDSRModel.FK_Customer_ParameterDet2">
            <End Role="ParameterDet" EntitySet="ParameterDets" />
            <End Role="Customer" EntitySet="Customers" />
          </AssociationSet>
          <AssociationSet Name="FK_Holiday_ParameterDet" Association="NikaiDSRModel.FK_Holiday_ParameterDet">
            <End Role="ParameterDet" EntitySet="ParameterDets" />
            <End Role="Holiday" EntitySet="Holidays" />
          </AssociationSet>
          <AssociationSet Name="FK_Menu_ParameterDet" Association="NikaiDSRModel.FK_Menu_ParameterDet">
            <End Role="ParameterDet" EntitySet="ParameterDets" />
            <End Role="Menu" EntitySet="Menus" />
          </AssociationSet>
          <AssociationSet Name="FK_MenuAccess_ParameterDet" Association="NikaiDSRModel.FK_MenuAccess_ParameterDet">
            <End Role="ParameterDet" EntitySet="ParameterDets" />
            <End Role="MenuAccess" EntitySet="MenuAccesses" />
          </AssociationSet>
          <AssociationSet Name="FK_ParameterDet_Parameter" Association="NikaiDSRModel.FK_ParameterDet_Parameter">
            <End Role="Parameter" EntitySet="Parameters" />
            <End Role="ParameterDet" EntitySet="ParameterDets" />
          </AssociationSet>
          <AssociationSet Name="FK_RoleRights_ParameterDet1" Association="NikaiDSRModel.FK_RoleRights_ParameterDet1">
            <End Role="ParameterDet" EntitySet="ParameterDets" />
            <End Role="RoleRight" EntitySet="RoleRights" />
          </AssociationSet>
          <AssociationSet Name="FK_User_Language_ParameterDet" Association="NikaiDSRModel.FK_User_Language_ParameterDet">
            <End Role="ParameterDet" EntitySet="ParameterDets" />
            <End Role="User_Language" EntitySet="User_Language" />
          </AssociationSet>
          <FunctionImport Name="GetParameter" ReturnType="Collection(NikaiDSRModel.GetParameter_Result)">
            <Parameter Name="ParameterId" Mode="In" Type="Int32" />
            <Parameter Name="ParameterDetId" Mode="In" Type="Int32" />
            <Parameter Name="ParameterValue" Mode="In" Type="Int32" />
          </FunctionImport>
          <EntitySet Name="Locations" EntityType="NikaiDSRModel.Location" />
          <AssociationSet Name="FK_Customer_Location" Association="NikaiDSRModel.FK_Customer_Location">
            <End Role="Location" EntitySet="Locations" />
            <End Role="Customer" EntitySet="Customers" />
          </AssociationSet>
          <AssociationSet Name="FK_Location_Region" Association="NikaiDSRModel.FK_Location_Region">
            <End Role="Region" EntitySet="Regions" />
            <End Role="Location" EntitySet="Locations" />
          </AssociationSet>
          <AssociationSet Name="FK_Site_User_Location" Association="NikaiDSRModel.FK_Site_User_Location">
            <End Role="Location" EntitySet="Locations" />
            <End Role="Site_User" EntitySet="Site_User" />
          </AssociationSet>
          <FunctionImport Name="GetLocation" ReturnType="Collection(NikaiDSRModel.GetLocation_Result)">
            <Parameter Name="Location_Id" Mode="In" Type="Int32" />
            <Parameter Name="Location_Name" Mode="In" Type="String" />
            <Parameter Name="Region_Id" Mode="In" Type="Int32" />
          </FunctionImport>
          <EntitySet Name="Contacts" EntityType="NikaiDSRModel.Contact" />
          <AssociationSet Name="FK_Contact_Customer" Association="NikaiDSRModel.FK_Contact_Customer">
            <End Role="Customer" EntitySet="Customers" />
            <End Role="Contact" EntitySet="Contacts" />
          </AssociationSet>
          <AssociationSet Name="FK_DSR_Contact" Association="NikaiDSRModel.FK_DSR_Contact">
            <End Role="Contact" EntitySet="Contacts" />
            <End Role="DSR" EntitySet="DSRs" />
          </AssociationSet>
          <FunctionImport Name="GetContact" ReturnType="Collection(NikaiDSRModel.GetContact_Result)">
            <Parameter Name="Contact_Id" Mode="In" Type="Int32" />
            <Parameter Name="Contact_Name" Mode="In" Type="String" />
            <Parameter Name="Contact_Name_BL" Mode="In" Type="String" />
            <Parameter Name="Customer_Id" Mode="In" Type="Int32" />
            <Parameter Name="Department" Mode="In" Type="String" />
            <Parameter Name="Department_BL" Mode="In" Type="String" />
            <Parameter Name="Mobile" Mode="In" Type="Int32" />
            <Parameter Name="Status" Mode="In" Type="Int32" />
          </FunctionImport>
          <FunctionImport Name="InsertUpdateContact" ReturnType="Collection(Decimal)">
            <Parameter Name="Contact_Id" Mode="In" Type="Int32" />
            <Parameter Name="Contact_Name" Mode="In" Type="String" />
            <Parameter Name="Contact_Name_BL" Mode="In" Type="String" />
            <Parameter Name="Customer_Id" Mode="In" Type="Int32" />
            <Parameter Name="Department" Mode="In" Type="String" />
            <Parameter Name="Department_BL" Mode="In" Type="String" />
            <Parameter Name="Mobile" Mode="In" Type="String" />
            <Parameter Name="Status" Mode="In" Type="Boolean" />
            <Parameter Name="Cont_Id" Mode="InOut" Type="Int32" />
          </FunctionImport>
          <FunctionImport Name="GetActiveDsrContactCustomerLocation" ReturnType="Collection(NikaiDSRModel.GetActiveDsrContactCustomerLocation_Result)">
            <Parameter Name="User_Id" Mode="In" Type="Int32" />
            <Parameter Name="Date" Mode="In" Type="DateTime" />
          </FunctionImport>
          <EntitySet Name="DSRReportViews" EntityType="NikaiDSRModel.DSRReportView" />
          <FunctionImport Name="GetExecutiveTargetsActuals" ReturnType="Collection(NikaiDSRModel.GetExecutiveTargetsActuals_Result)">
            <Parameter Name="Month" Mode="In" Type="Int32" />
            <Parameter Name="Year" Mode="In" Type="Int32" />
            <Parameter Name="Executive_Id" Mode="In" Type="Int32" />
          </FunctionImport>
          <FunctionImport Name="GetManagerReport" ReturnType="Collection(NikaiDSRModel.GetManagerReport_Result)">
            <Parameter Name="FromDate" Mode="In" Type="DateTime" />
            <Parameter Name="ToDate" Mode="In" Type="DateTime" />
            <Parameter Name="Country_Id" Mode="In" Type="Int32" />
            <Parameter Name="Region_Id" Mode="In" Type="Int32" />
            <Parameter Name="Location_Id" Mode="In" Type="Int32" />
            <Parameter Name="KeyAccounts" Mode="In" Type="Boolean" />
            <Parameter Name="Manager_Id" Mode="In" Type="Int32" />
            <Parameter Name="Search_Executive_Id" Mode="In" Type="Int32" />
            <Parameter Name="Report_ExecutiveWise" Mode="In" Type="Boolean" />
          </FunctionImport>
          <FunctionImport Name="GetManagerExecutive" ReturnType="Collection(NikaiDSRModel.GetManagerExecutive_Result)">
            <Parameter Name="Manager_Id" Mode="In" Type="Int32" />
            <Parameter Name="Executive_Id" Mode="In" Type="Int32" />
          </FunctionImport>
          <FunctionImport Name="GetActiveCustomerLocationRegionCountry" ReturnType="Collection(NikaiDSRModel.GetActiveCustomerLocationRegionCountry_Result)">
          <Parameter Name="User_Id" Mode="In" Type="Int32" />
          </FunctionImport>
          <FunctionImport Name="GetContactWithCustName" ReturnType="Collection(NikaiDSRModel.GetContactWithCustName_Result)">
            <Parameter Name="Contact_Id" Mode="In" Type="Int32" />
            <Parameter Name="Contact_Name" Mode="In" Type="String" />
            <Parameter Name="Customer_Name" Mode="In" Type="String" />
            <Parameter Name="Contact_Name_BL" Mode="In" Type="String" />
            <Parameter Name="Customer_Id" Mode="In" Type="Int32" />
            <Parameter Name="Department" Mode="In" Type="String" />
            <Parameter Name="Department_BL" Mode="In" Type="String" />
            <Parameter Name="Mobile" Mode="In" Type="String" />
            <Parameter Name="Status" Mode="In" Type="Int32" />
          </FunctionImport>
          <FunctionImport Name="InsertVisit">
            <Parameter Name="Customer_Id" Mode="In" Type="Int32" />
            <Parameter Name="Customer_Name" Mode="In" Type="String" />
            <Parameter Name="Customer_Name_BL" Mode="In" Type="String" />
            <Parameter Name="Location_Id" Mode="In" Type="Int32" />
            <Parameter Name="Contact_Id" Mode="In" Type="Int32" />
            <Parameter Name="Contact_Name" Mode="In" Type="String" />
            <Parameter Name="Contact_Name_BL" Mode="In" Type="String" />
            <Parameter Name="Department" Mode="In" Type="String" />
            <Parameter Name="Department_BL" Mode="In" Type="String" />
            <Parameter Name="Mobile" Mode="In" Type="String" />
            <Parameter Name="Site_User_Id" Mode="In" Type="Int32" />
            <Parameter Name="Date" Mode="In" Type="DateTime" />
            <Parameter Name="Objective" Mode="In" Type="Int32" />
            <Parameter Name="Time_In" Mode="In" Type="Time" />
            <Parameter Name="Time_Out" Mode="In" Type="Time" />
            <Parameter Name="Time_w_Merchandiser" Mode="In" Type="Int32" />
            <Parameter Name="Collection" Mode="In" Type="Int32" />
            <Parameter Name="Secondary_Sales" Mode="In" Type="Int32" />
            <Parameter Name="Sales_LPO_Received" Mode="In" Type="Int32" />
            <Parameter Name="Discount" Mode="In" Type="Int32" />
            <Parameter Name="Sales_Return" Mode="In" Type="Int32" />
            <Parameter Name="Remarks" Mode="In" Type="String" />
            <Parameter Name="Updated_By" Mode="In" Type="Int32" />
          </FunctionImport>
          <FunctionImport Name="GetDSR" ReturnType="Collection(NikaiDSRModel.GetDSR_Result)">
            <Parameter Name="DSR_Id" Mode="In" Type="Int32" />
            <Parameter Name="Site_User_Id" Mode="In" Type="Int32" />
            <Parameter Name="Date" Mode="In" Type="DateTime" />
            <Parameter Name="Contact_Id" Mode="In" Type="Int32" />
            <Parameter Name="Objective" Mode="In" Type="Int32" />
            <Parameter Name="Time_In" Mode="In" Type="Time" />
            <Parameter Name="Time_Out" Mode="In" Type="Time" />
            <Parameter Name="Time_Spent" Mode="In" Type="Int32" />
            <Parameter Name="Time_w_Merchandiser" Mode="In" Type="Int32" />
            <Parameter Name="Collection" Mode="In" Type="Int32" />
            <Parameter Name="Secondary_Sales" Mode="In" Type="Int32" />
            <Parameter Name="Sales_LPO_Received" Mode="In" Type="Int32" />
            <Parameter Name="Discount" Mode="In" Type="Int32" />
            <Parameter Name="Sales_Return" Mode="In" Type="Int32" />
            <Parameter Name="Remarks" Mode="In" Type="String" />
          </FunctionImport>
          <EntitySet Name="ActiveContactCustomerLocationViews" EntityType="NikaiDSRModel.ActiveContactCustomerLocationView" />
          <EntitySet Name="ActiveCustomerLocationRegionCountryViews" EntityType="NikaiDSRModel.ActiveCustomerLocationRegionCountryView" />
          <EntitySet Name="DsrContactCustomerLocationViews" EntityType="NikaiDSRModel.DsrContactCustomerLocationView" />
          <FunctionImport Name="GetActiveContactCustomerLocation" ReturnType="Collection(NikaiDSRModel.GetActiveContactCustomerLocation_Result)">
          <Parameter Name="User_Id" Mode="In" Type="Int32" />
          </FunctionImport>
          <FunctionImport Name="UpdateVisit">
            <Parameter Name="DSR_Id" Mode="In" Type="Int32" />
            <Parameter Name="Customer_Id" Mode="In" Type="Int32" />
            <Parameter Name="Customer_Name" Mode="In" Type="String" />
            <Parameter Name="Customer_Name_BL" Mode="In" Type="String" />
            <Parameter Name="Location_Id" Mode="In" Type="Int32" />
            <Parameter Name="Contact_Id" Mode="In" Type="Int32" />
            <Parameter Name="Contact_Name" Mode="In" Type="String" />
            <Parameter Name="Contact_Name_BL" Mode="In" Type="String" />
            <Parameter Name="Department" Mode="In" Type="String" />
            <Parameter Name="Department_BL" Mode="In" Type="String" />
            <Parameter Name="Mobile" Mode="In" Type="String" />
            <Parameter Name="Site_User_Id" Mode="In" Type="Int32" />
            <Parameter Name="Date" Mode="In" Type="DateTime" />
            <Parameter Name="Objective" Mode="In" Type="Int32" />
            <Parameter Name="Time_In" Mode="In" Type="Time" />
            <Parameter Name="Time_Out" Mode="In" Type="Time" />
            <Parameter Name="Time_w_Merchandiser" Mode="In" Type="Int32" />
            <Parameter Name="Collection" Mode="In" Type="Int32" />
            <Parameter Name="Secondary_Sales" Mode="In" Type="Int32" />
            <Parameter Name="Sales_LPO_Received" Mode="In" Type="Int32" />
            <Parameter Name="Discount" Mode="In" Type="Int32" />
            <Parameter Name="Sales_Return" Mode="In" Type="Int32" />
            <Parameter Name="Remarks" Mode="In" Type="String" />
            <Parameter Name="Updated_By" Mode="In" Type="Int32" />
          </FunctionImport>
          <FunctionImport Name="GetExecutiveReport" ReturnType="Collection(NikaiDSRModel.GetExecutiveReport_Result)">
            <Parameter Name="Month" Mode="In" Type="Int32" />
            <Parameter Name="Year" Mode="In" Type="Int32" />
            <Parameter Name="Executive_Id" Mode="In" Type="Int32" />
          </FunctionImport>
          <FunctionImport Name="GetReporteesForUserCreation" ReturnType="Collection(NikaiDSRModel.GetReporteesForUserCreation_Result)">
            <Parameter Name="Role_Id" Mode="In" Type="Int32" />
            <Parameter Name="Location_Id" Mode="In" Type="Int32" />
          </FunctionImport>
          <FunctionImport Name="InsertUpdateUser">
            <Parameter Name="User_Id" Mode="In" Type="Int32" />
            <Parameter Name="Name" Mode="In" Type="String" />
            <Parameter Name="Password" Mode="In" Type="String" />
            <Parameter Name="Email" Mode="In" Type="String" />
            <Parameter Name="Role_Id" Mode="In" Type="Int32" />
            <Parameter Name="Location_Id" Mode="In" Type="Int32" />
            <Parameter Name="Employee_Code" Mode="In" Type="String" />
            <Parameter Name="Status" Mode="In" Type="Boolean" />
            <Parameter Name="LinkedUsers" Mode="In" Type="String" />
            <Parameter Name="Language_Id" Mode="In" Type="Int32" />
          </FunctionImport>
          <AssociationSet Name="FK_Customer_ParameterDet3" Association="NikaiDSRModel.FK_Customer_ParameterDet3">
            <End Role="ParameterDet" EntitySet="ParameterDets" />
            <End Role="Customer" EntitySet="Customers" />
          </AssociationSet>
          <FunctionImport Name="GetCustomer" ReturnType="Collection(NikaiDSRModel.GetCustomer_Result)">
            <Parameter Name="Customer_Id" Mode="In" Type="Int32" />
            <Parameter Name="Customer_Code" Mode="In" Type="String" />
            <Parameter Name="Customer_Name" Mode="In" Type="String" />
            <Parameter Name="Customer_Name_BL" Mode="In" Type="String" />
            <Parameter Name="Business_Type" Mode="In" Type="Int32" />
            <Parameter Name="Customer_Type" Mode="In" Type="Int32" />
            <Parameter Name="Customer_Group" Mode="In" Type="Int32" />
            <Parameter Name="Location_Id" Mode="In" Type="Int32" />
            <Parameter Name="Key_Account" Mode="In" Type="Boolean" />
            <Parameter Name="Status" Mode="In" Type="Boolean" />
            <Parameter Name="Sales_Channel" Mode="In" Type="Int32" />
          </FunctionImport>
          <FunctionImport Name="InsertUpdateCustomer">
            <Parameter Name="Customer_Id" Mode="In" Type="Int32" />
            <Parameter Name="Customer_Code" Mode="In" Type="String" />
            <Parameter Name="Customer_Name" Mode="In" Type="String" />
            <Parameter Name="Customer_Name_BL" Mode="In" Type="String" />
            <Parameter Name="Business_Type" Mode="In" Type="Int32" />
            <Parameter Name="Customer_Type" Mode="In" Type="Int32" />
            <Parameter Name="Customer_Group" Mode="In" Type="Int32" />
            <Parameter Name="Location_Id" Mode="In" Type="Int32" />
            <Parameter Name="Key_Account" Mode="In" Type="Boolean" />
            <Parameter Name="Status" Mode="In" Type="Boolean" />
            <Parameter Name="Updated_By" Mode="In" Type="Int32" />
            <Parameter Name="Sales_Channel" Mode="In" Type="Int32" />
            <Parameter Name="CustId" Mode="InOut" Type="Int32" />
          </FunctionImport>
        </EntityContainer>
        <EntityType Name="Absent">
          <Key>
            <PropertyRef Name="Absent_Id" />
          </Key>
          <Property Name="Absent_Id" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
          <Property Name="Date" Type="DateTime" Nullable="false" Precision="0" />
          <Property Name="Site_User_Id" Type="Int32" Nullable="false" />
          <NavigationProperty Name="Site_User" Relationship="NikaiDSRModel.FK_Absent_Site_User" FromRole="Absent" ToRole="Site_User" />
        </EntityType>
        <EntityType Name="Country">
          <Key>
            <PropertyRef Name="Country_Id" />
          </Key>
          <Property Name="Country_Id" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
          <Property Name="Country_Name" Type="String" Nullable="false" MaxLength="50" Unicode="true" FixedLength="false" />
          <NavigationProperty Name="Holidays" Relationship="NikaiDSRModel.FK_Holiday_Country" FromRole="Country" ToRole="Holiday" />
          <NavigationProperty Name="Regions" Relationship="NikaiDSRModel.FK_Region_Country" FromRole="Country" ToRole="Region" />
        </EntityType>
        <EntityType Name="Customer">
          <Key>
            <PropertyRef Name="Customer_Id" />
          </Key>
          <Property Name="Customer_Id" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
          <Property Name="Customer_Code" Type="String" MaxLength="50" Unicode="true" FixedLength="false" />
          <Property Name="Customer_Name" Type="String" MaxLength="50" Unicode="true" FixedLength="false" />
          <Property Name="Customer_Name_BL" Type="String" MaxLength="50" Unicode="true" FixedLength="false" />
          <Property Name="Business_Type" Type="Int32" />
          <Property Name="Customer_Type" Type="Int32" />
          <Property Name="Customer_Group" Type="Int32" />
          <Property Name="Location_Id" Type="Int32" />
          <Property Name="Key_Account" Type="Boolean" />
          <Property Name="Status" Type="Boolean" Nullable="false" />
          <Property Name="Updated_By" Type="Int32" Nullable="false" />
          <Property Name="Updated_Date" Type="DateTime" Nullable="false" Precision="0" />
          <NavigationProperty Name="Site_User" Relationship="NikaiDSRModel.FK_Customer_Site_User" FromRole="Customer" ToRole="Site_User" />
          <NavigationProperty Name="ParameterDet" Relationship="NikaiDSRModel.FK_Customer_ParameterDet" FromRole="Customer" ToRole="ParameterDet" />
          <NavigationProperty Name="ParameterDet1" Relationship="NikaiDSRModel.FK_Customer_ParameterDet1" FromRole="Customer" ToRole="ParameterDet" />
          <NavigationProperty Name="ParameterDet2" Relationship="NikaiDSRModel.FK_Customer_ParameterDet2" FromRole="Customer" ToRole="ParameterDet" />
          <NavigationProperty Name="Location" Relationship="NikaiDSRModel.FK_Customer_Location" FromRole="Customer" ToRole="Location" />
          <NavigationProperty Name="Contacts" Relationship="NikaiDSRModel.FK_Contact_Customer" FromRole="Customer" ToRole="Contact" />
          <Property Type="Int32" Name="Sales_Channel" />
          <NavigationProperty Name="ParameterDet3" Relationship="NikaiDSRModel.FK_Customer_ParameterDet3" FromRole="Customer" ToRole="ParameterDet" />
        </EntityType>
        <EntityType Name="DSR">
          <Key>
            <PropertyRef Name="DSR_Id" />
          </Key>
          <Property Name="DSR_Id" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
          <Property Name="Site_User_Id" Type="Int32" Nullable="false" />
          <Property Name="Date" Type="DateTime" Nullable="false" Precision="0" />
          <Property Name="Contact_Id" Type="Int32" Nullable="false" />
          <Property Name="Objective" Type="String" MaxLength="50" Unicode="true" FixedLength="false" />
          <Property Name="Time_In" Type="Time" Precision="7" />
          <Property Name="Time_Out" Type="Time" Precision="7" />
          <Property Name="Time_Spent" Type="Int32" />
          <Property Name="Time_w_Merchandiser" Type="Int32" />
          <Property Name="Collection" Type="Int32" />
          <Property Name="Secondary_Sales" Type="Int32" />
          <Property Name="Sales_LPO_Received" Type="Int32" />
          <Property Name="Discount" Type="Int32" />
          <Property Name="Sales_Return" Type="Int32" />
          <Property Name="Remarks" Type="String" MaxLength="50" Unicode="true" FixedLength="false" />
          <NavigationProperty Name="Site_User" Relationship="NikaiDSRModel.FK_DSR_DSR_Header" FromRole="DSR" ToRole="Site_User" />
          <NavigationProperty Name="Contact" Relationship="NikaiDSRModel.FK_DSR_Contact" FromRole="DSR" ToRole="Contact" />
        </EntityType>
        <EntityType Name="DSR_Header">
          <Key>
            <PropertyRef Name="DSR_Head_Id" />
          </Key>
          <Property Name="DSR_Head_Id" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
          <Property Name="Date" Type="DateTime" Nullable="false" Precision="0" />
          <Property Name="Shift" Type="String" MaxLength="50" Unicode="true" FixedLength="false" />
          <Property Name="Morning_Time_In" Type="Time" Precision="7" />
          <Property Name="Morning_Time_Out" Type="Time" Precision="7" />
          <Property Name="Evening_Time_In" Type="Time" Precision="7" />
          <Property Name="Evening_Time_Out" Type="Time" Precision="7" />
          <Property Name="Comments" Type="String" MaxLength="50" Unicode="true" FixedLength="false" />
          <Property Name="Site_User_Id" Type="Int32" Nullable="false" />
        </EntityType>
        <EntityType Name="Holiday">
          <Key>
            <PropertyRef Name="Holiday_Id" />
          </Key>
          <Property Name="Holiday_Id" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
          <Property Name="Date" Type="DateTime" Nullable="false" Precision="0" />
          <Property Name="Country_Id" Type="Int32" Nullable="false" />
          <Property Name="Holiday_Type" Type="Int32" Nullable="false" />
          <NavigationProperty Name="Country" Relationship="NikaiDSRModel.FK_Holiday_Country" FromRole="Holiday" ToRole="Country" />
          <NavigationProperty Name="ParameterDet" Relationship="NikaiDSRModel.FK_Holiday_ParameterDet" FromRole="Holiday" ToRole="ParameterDet" />
        </EntityType>
        <EntityType Name="Manager_Executive">
          <Key>
            <PropertyRef Name="Manager_Exec_Id" />
          </Key>
          <Property Name="Manager_Exec_Id" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
          <Property Name="Executive_Id" Type="Int32" Nullable="false" />
          <Property Name="Manager_Id" Type="Int32" Nullable="false" />
          <NavigationProperty Name="Site_User" Relationship="NikaiDSRModel.FK_Manager_Executive_Site_User" FromRole="Manager_Executive" ToRole="Site_User" />
        </EntityType>
        <EntityType Name="Menu">
          <Key>
            <PropertyRef Name="MenuId" />
          </Key>
          <Property Name="MenuId" Type="Int32" Nullable="false" />
          <Property Name="MenuName" Type="String" Nullable="false" MaxLength="100" Unicode="true" FixedLength="false" />
          <Property Name="MenuParentId" Type="Int32" />
          <Property Name="MenuStatus" Type="Int32" Nullable="false" />
          <Property Name="MenuOrder" Type="Int32" Nullable="false" />
          <NavigationProperty Name="MenuAccesses" Relationship="NikaiDSRModel.FK_MenuAccess_Menu" FromRole="Menu" ToRole="MenuAccess" />
          <NavigationProperty Name="MenuRolePages" Relationship="NikaiDSRModel.FK_MenuRolePages_Menu" FromRole="Menu" ToRole="MenuRolePages" />
          <NavigationProperty Name="RoleRights" Relationship="NikaiDSRModel.FK_RoleRights_Menu" FromRole="Menu" ToRole="RoleRights" />
          <NavigationProperty Name="ParameterDet" Relationship="NikaiDSRModel.FK_Menu_ParameterDet" FromRole="Menu" ToRole="ParameterDet" />
        </EntityType>
        <EntityType Name="MenuAccess">
          <Key>
            <PropertyRef Name="MenuAccessId" />
          </Key>
          <Property Name="MenuAccessId" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
          <Property Name="MenuId" Type="Int32" Nullable="false" />
          <Property Name="AccessType" Type="Int32" Nullable="false" />
          <NavigationProperty Name="Menu" Relationship="NikaiDSRModel.FK_MenuAccess_Menu" FromRole="MenuAccess" ToRole="Menu" />
          <NavigationProperty Name="ParameterDet" Relationship="NikaiDSRModel.FK_MenuAccess_ParameterDet" FromRole="MenuAccess" ToRole="ParameterDet" />
        </EntityType>
        <EntityType Name="MenuRolePage">
          <Key>
            <PropertyRef Name="MenuRoleId" />
          </Key>
          <Property Name="MenuRoleId" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
          <Property Name="MenuId" Type="Int32" Nullable="false" />
          <Property Name="RoleId" Type="Int32" Nullable="false" />
          <Property Name="PageUrl" Type="String" Nullable="false" MaxLength="200" Unicode="false" FixedLength="false" />
          <NavigationProperty Name="Menu" Relationship="NikaiDSRModel.FK_MenuRolePages_Menu" FromRole="MenuRolePages" ToRole="Menu" />
          <NavigationProperty Name="Role" Relationship="NikaiDSRModel.FK_MenuRolePages_ParameterDet" FromRole="MenuRolePages" ToRole="Role" />
        </EntityType>
        <EntityType Name="Parameter">
          <Key>
            <PropertyRef Name="ParameterId" />
          </Key>
          <Property Name="ParameterId" Type="Int32" Nullable="false" />
          <Property Name="ParameterText" Type="String" Nullable="false" MaxLength="100" Unicode="false" FixedLength="false" />
          <NavigationProperty Name="ParameterDets" Relationship="NikaiDSRModel.FK_ParameterDet_Parameter" FromRole="Parameter" ToRole="ParameterDet" />
        </EntityType>
        <EntityType Name="Region">
          <Key>
            <PropertyRef Name="Region_Id" />
          </Key>
          <Property Name="Region_Id" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
          <Property Name="Region_Name" Type="String" Nullable="false" MaxLength="50" Unicode="true" FixedLength="false" />
          <Property Name="Country_Id" Type="Int32" Nullable="false" />
          <NavigationProperty Name="Country" Relationship="NikaiDSRModel.FK_Region_Country" FromRole="Region" ToRole="Country" />
          <NavigationProperty Name="Locations" Relationship="NikaiDSRModel.FK_Location_Region" FromRole="Region" ToRole="Location" />
        </EntityType>
        <EntityType Name="Role">
          <Key>
            <PropertyRef Name="Role_Id" />
          </Key>
          <Property Name="Role_Id" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
          <Property Name="Role_Name" Type="String" Nullable="false" MaxLength="50" Unicode="true" FixedLength="false" />
          <NavigationProperty Name="MenuRolePages" Relationship="NikaiDSRModel.FK_MenuRolePages_ParameterDet" FromRole="Role" ToRole="MenuRolePages" />
          <NavigationProperty Name="RoleRights" Relationship="NikaiDSRModel.FK_RoleRights_ParameterDet" FromRole="Role" ToRole="RoleRights" />
          <NavigationProperty Name="Site_User" Relationship="NikaiDSRModel.FK_Site_User_Role" FromRole="Role" ToRole="Site_User" />
        </EntityType>
        <EntityType Name="RoleRight">
          <Key>
            <PropertyRef Name="RightsId" />
          </Key>
          <Property Name="RightsId" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
          <Property Name="RoleId" Type="Int32" Nullable="false" />
          <Property Name="MenuId" Type="Int32" Nullable="false" />
          <Property Name="AccessType" Type="Int32" Nullable="false" />
          <NavigationProperty Name="Menu" Relationship="NikaiDSRModel.FK_RoleRights_Menu" FromRole="RoleRights" ToRole="Menu" />
          <NavigationProperty Name="Role" Relationship="NikaiDSRModel.FK_RoleRights_ParameterDet" FromRole="RoleRights" ToRole="Role" />
          <NavigationProperty Name="ParameterDet" Relationship="NikaiDSRModel.FK_RoleRights_ParameterDet1" FromRole="RoleRight" ToRole="ParameterDet" />
        </EntityType>
        <EntityType Name="Site_User">
          <Key>
            <PropertyRef Name="Site_User_Id" />
          </Key>
          <Property Name="Site_User_Id" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
          <Property Name="Role_Id" Type="Int32" Nullable="false" />
          <Property Name="Location_Id" Type="Int32" Nullable="false" />
          <Property Name="Name" Type="String" Nullable="false" MaxLength="50" Unicode="true" FixedLength="false" />
          <Property Name="Login_Name" Type="String" MaxLength="50" Unicode="true" FixedLength="false" />
          <Property Name="Password" Type="String" Nullable="false" MaxLength="50" Unicode="true" FixedLength="false" />
          <Property Name="Email" Type="String" MaxLength="50" Unicode="true" FixedLength="false" />
          <Property Name="Status" Type="Boolean" Nullable="false" />
          <Property Name="Employee_Code" Type="String" MaxLength="50" Unicode="true" FixedLength="false" />
          <NavigationProperty Name="Absents" Relationship="NikaiDSRModel.FK_Absent_Site_User" FromRole="Site_User" ToRole="Absent" />
          <NavigationProperty Name="Customers" Relationship="NikaiDSRModel.FK_Customer_Site_User" FromRole="Site_User" ToRole="Customer" />
          <NavigationProperty Name="DSRs" Relationship="NikaiDSRModel.FK_DSR_DSR_Header" FromRole="Site_User" ToRole="DSR" />
          <NavigationProperty Name="Manager_Executive" Relationship="NikaiDSRModel.FK_Manager_Executive_Site_User" FromRole="Site_User" ToRole="Manager_Executive" />
          <NavigationProperty Name="Role" Relationship="NikaiDSRModel.FK_Site_User_Role" FromRole="Site_User" ToRole="Role" />
          <NavigationProperty Name="Targets" Relationship="NikaiDSRModel.FK_Target_Site_User" FromRole="Site_User" ToRole="Target" />
          <NavigationProperty Name="User_Language" Relationship="NikaiDSRModel.FK_User_Language_Site_User" FromRole="Site_User" ToRole="User_Language" />
          <NavigationProperty Name="Location" Relationship="NikaiDSRModel.FK_Site_User_Location" FromRole="Site_User" ToRole="Location" />
        </EntityType>
        <EntityType Name="sysdiagram">
          <Key>
            <PropertyRef Name="diagram_id" />
          </Key>
          <Property Name="name" Type="String" Nullable="false" MaxLength="128" Unicode="true" FixedLength="false" />
          <Property Name="principal_id" Type="Int32" Nullable="false" />
          <Property Name="diagram_id" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
          <Property Name="version" Type="Int32" />
          <Property Name="definition" Type="Binary" MaxLength="Max" FixedLength="false" />
        </EntityType>
        <EntityType Name="Target">
          <Key>
            <PropertyRef Name="Target_Id" />
          </Key>
          <Property Name="Target_Id" Type="Int32" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
          <Property Name="Month" Type="Int32" Nullable="false" />
          <Property Name="Year" Type="Int32" Nullable="false" />
          <Property Name="Site_User_Id" Type="Int32" Nullable="false" />
          <Property Name="Sales" Type="Int32" />
          <Property Name="Collection" Type="Int32" />
          <Property Name="Secondary_Sales" Type="Int32" />
          <NavigationProperty Name="Site_User" Relationship="NikaiDSRModel.FK_Target_Site_User" FromRole="Target" ToRole="Site_User" />
        </EntityType>
        <EntityType Name="UserRoleLocationRegionCountryView">
          <Key>
            <PropertyRef Name="Site_User_Id" />
            <PropertyRef Name="Name" />
            <PropertyRef Name="Status" />
            <PropertyRef Name="Role_Id" />
            <PropertyRef Name="Role_Name" />
            <PropertyRef Name="Location_Id" />
            <PropertyRef Name="Location_Name" />
            <PropertyRef Name="Region_Id" />
            <PropertyRef Name="Region_Name" />
            <PropertyRef Name="Country_Id" />
            <PropertyRef Name="Country_Name" />
          </Key>
          <Property Name="Site_User_Id" Type="Int32" Nullable="false" />
          <Property Name="Name" Type="String" Nullable="false" MaxLength="50" Unicode="true" FixedLength="false" />
          <Property Name="Email" Type="String" MaxLength="50" Unicode="true" FixedLength="false" />
          <Property Name="Status" Type="Boolean" Nullable="false" />
          <Property Name="Role_Id" Type="Int32" Nullable="false" />
          <Property Name="Role_Name" Type="String" Nullable="false" MaxLength="50" Unicode="true" FixedLength="false" />
          <Property Name="Location_Id" Type="Int32" Nullable="false" />
          <Property Name="Location_Name" Type="String" Nullable="false" MaxLength="50" Unicode="true" FixedLength="false" />
          <Property Name="Region_Id" Type="Int32" Nullable="false" />
          <Property Name="Region_Name" Type="String" Nullable="false" MaxLength="50" Unicode="true" FixedLength="false" />
          <Property Name="Country_Id" Type="Int32" Nullable="false" />
          <Property Name="Country_Name" Type="String" Nullable="false" MaxLength="50" Unicode="true" FixedLength="false" />
        </EntityType>
        <Association Name="FK_Absent_Site_User">
          <End Role="Site_User" Type="NikaiDSRModel.Site_User" Multiplicity="1" />
          <End Role="Absent" Type="NikaiDSRModel.Absent" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="Site_User">
              <PropertyRef Name="Site_User_Id" />
            </Principal>
            <Dependent Role="Absent">
              <PropertyRef Name="Site_User_Id" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_Holiday_Country">
          <End Role="Country" Type="NikaiDSRModel.Country" Multiplicity="1" />
          <End Role="Holiday" Type="NikaiDSRModel.Holiday" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="Country">
              <PropertyRef Name="Country_Id" />
            </Principal>
            <Dependent Role="Holiday">
              <PropertyRef Name="Country_Id" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_Region_Country">
          <End Role="Country" Type="NikaiDSRModel.Country" Multiplicity="1" />
          <End Role="Region" Type="NikaiDSRModel.Region" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="Country">
              <PropertyRef Name="Country_Id" />
            </Principal>
            <Dependent Role="Region">
              <PropertyRef Name="Country_Id" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_Customer_Site_User">
          <End Role="Site_User" Type="NikaiDSRModel.Site_User" Multiplicity="1" />
          <End Role="Customer" Type="NikaiDSRModel.Customer" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="Site_User">
              <PropertyRef Name="Site_User_Id" />
            </Principal>
            <Dependent Role="Customer">
              <PropertyRef Name="Updated_By" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_DSR_DSR_Header">
          <End Role="Site_User" Type="NikaiDSRModel.Site_User" Multiplicity="1" />
          <End Role="DSR" Type="NikaiDSRModel.DSR" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="Site_User">
              <PropertyRef Name="Site_User_Id" />
            </Principal>
            <Dependent Role="DSR">
              <PropertyRef Name="Site_User_Id" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_Manager_Executive_Site_User">
          <End Role="Site_User" Type="NikaiDSRModel.Site_User" Multiplicity="1" />
          <End Role="Manager_Executive" Type="NikaiDSRModel.Manager_Executive" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="Site_User">
              <PropertyRef Name="Site_User_Id" />
            </Principal>
            <Dependent Role="Manager_Executive">
              <PropertyRef Name="Manager_Id" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_MenuAccess_Menu">
          <End Role="Menu" Type="NikaiDSRModel.Menu" Multiplicity="1" />
          <End Role="MenuAccess" Type="NikaiDSRModel.MenuAccess" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="Menu">
              <PropertyRef Name="MenuId" />
            </Principal>
            <Dependent Role="MenuAccess">
              <PropertyRef Name="MenuId" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_MenuRolePages_Menu">
          <End Role="Menu" Type="NikaiDSRModel.Menu" Multiplicity="1" />
          <End Role="MenuRolePages" Type="NikaiDSRModel.MenuRolePage" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="Menu">
              <PropertyRef Name="MenuId" />
            </Principal>
            <Dependent Role="MenuRolePages">
              <PropertyRef Name="MenuId" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_RoleRights_Menu">
          <End Role="Menu" Type="NikaiDSRModel.Menu" Multiplicity="1" />
          <End Role="RoleRights" Type="NikaiDSRModel.RoleRight" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="Menu">
              <PropertyRef Name="MenuId" />
            </Principal>
            <Dependent Role="RoleRights">
              <PropertyRef Name="MenuId" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_MenuRolePages_ParameterDet">
          <End Role="Role" Type="NikaiDSRModel.Role" Multiplicity="1" />
          <End Role="MenuRolePages" Type="NikaiDSRModel.MenuRolePage" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="Role">
              <PropertyRef Name="Role_Id" />
            </Principal>
            <Dependent Role="MenuRolePages">
              <PropertyRef Name="RoleId" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_RoleRights_ParameterDet">
          <End Role="Role" Type="NikaiDSRModel.Role" Multiplicity="1" />
          <End Role="RoleRights" Type="NikaiDSRModel.RoleRight" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="Role">
              <PropertyRef Name="Role_Id" />
            </Principal>
            <Dependent Role="RoleRights">
              <PropertyRef Name="RoleId" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_Site_User_Role">
          <End Role="Role" Type="NikaiDSRModel.Role" Multiplicity="1" />
          <End Role="Site_User" Type="NikaiDSRModel.Site_User" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="Role">
              <PropertyRef Name="Role_Id" />
            </Principal>
            <Dependent Role="Site_User">
              <PropertyRef Name="Role_Id" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_Target_Site_User">
          <End Role="Site_User" Type="NikaiDSRModel.Site_User" Multiplicity="1" />
          <End Role="Target" Type="NikaiDSRModel.Target" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="Site_User">
              <PropertyRef Name="Site_User_Id" />
            </Principal>
            <Dependent Role="Target">
              <PropertyRef Name="Site_User_Id" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <ComplexType Name="ActiveCustomerLocationRegionCountry_Result">
          <Property Type="Int32" Name="Customer_Id" Nullable="false" />
          <Property Type="String" Name="Customer_Name" Nullable="true" MaxLength="50" />
          <Property Type="Boolean" Name="Key_Account" Nullable="true" />
          <Property Type="Boolean" Name="Customer_Status" Nullable="false" />
          <Property Type="Int32" Name="Location_Id" Nullable="false" />
          <Property Type="String" Name="Location_Name" Nullable="false" MaxLength="50" />
          <Property Type="Int32" Name="Site_User_Id" Nullable="false" />
          <Property Type="String" Name="Customer_Name_BL" Nullable="true" MaxLength="50" />
          <Property Type="Int32" Name="Updated_By" Nullable="false" />
          <Property Type="DateTime" Name="Updated_Date" Nullable="false" />
          <Property Type="String" Name="Customer_Code" Nullable="true" MaxLength="50" />
          <Property Type="Int32" Name="Business_Type" Nullable="true" />
          <Property Type="Int32" Name="Customer_Type" Nullable="true" />
          <Property Type="Int32" Name="Customer_Group" Nullable="true" />
          <Property Type="String" Name="Country_Name" Nullable="false" MaxLength="50" />
          <Property Type="String" Name="Region_Name" Nullable="false" MaxLength="50" />
        </ComplexType>
        <ComplexType Name="GetAbsent_Result">
          <Property Type="Int32" Name="Absent_Id" Nullable="false" />
          <Property Type="DateTime" Name="Date" Nullable="false" />
          <Property Type="Int32" Name="Site_User_Id" Nullable="false" />
        </ComplexType>
        <ComplexType Name="GetAttendance_Result">
          <Property Type="DateTime" Name="A_Date" Nullable="true" />
          <Property Type="String" Name="Status" Nullable="true" MaxLength="10" />
          <Property Type="Int32" Name="Site_User_Id" Nullable="true" />
        </ComplexType>
        <ComplexType Name="GetCountry_Result">
          <Property Type="Int32" Name="Country_Id" Nullable="false" />
          <Property Type="String" Name="Country_Name" Nullable="false" MaxLength="50" />
        </ComplexType>
        <ComplexType Name="GetDSRHeader_Result">
          <Property Type="Int32" Name="DSR_Head_Id" Nullable="false" />
          <Property Type="DateTime" Name="Date" Nullable="false" />
          <Property Type="String" Name="Shift" Nullable="true" MaxLength="50" />
          <Property Type="Time" Name="Morning_Time_In" Nullable="true" />
          <Property Type="Time" Name="Morning_Time_Out" Nullable="true" />
          <Property Type="Time" Name="Evening_Time_In" Nullable="true" />
          <Property Type="Time" Name="Evening_Time_Out" Nullable="true" />
          <Property Type="String" Name="Comments" Nullable="true" MaxLength="50" />
          <Property Type="Int32" Name="Site_User_Id" Nullable="false" />
        </ComplexType>
        <ComplexType Name="GetHoliday_Result">
          <Property Type="Int32" Name="Holiday_Id" Nullable="false" />
          <Property Type="DateTime" Name="Date" Nullable="false" />
          <Property Type="Int32" Name="Country_Id" Nullable="false" />
          <Property Type="Int32" Name="Holiday_Type" Nullable="false" />
        </ComplexType>
        <ComplexType Name="GetRegion_Result">
          <Property Type="Int32" Name="Region_Id" Nullable="false" />
          <Property Type="String" Name="Region_Name" Nullable="false" MaxLength="50" />
          <Property Type="Int32" Name="Country_Id" Nullable="false" />
        </ComplexType>
        <ComplexType Name="GetRole_Result">
          <Property Type="Int32" Name="Role_Id" Nullable="false" />
          <Property Type="String" Name="Role_Name" Nullable="false" MaxLength="50" />
        </ComplexType>
        <ComplexType Name="GetRoleRights_Result">
          <Property Type="Int32" Name="MenuId" Nullable="false" />
          <Property Type="String" Name="MenuName" Nullable="false" MaxLength="100" />
          <Property Type="Int32" Name="MenuParentId" Nullable="true" />
          <Property Type="Int32" Name="MenuStatus" Nullable="false" />
          <Property Type="Int32" Name="MenuOrder" Nullable="false" />
          <Property Type="String" Name="ParentMenuName" Nullable="true" MaxLength="100" />
          <Property Type="String" Name="ParentNChildMenu" Nullable="true" MaxLength="201" />
          <Property Type="Int32" Name="MenuStatusId" Nullable="false" />
          <Property Type="String" Name="MenuStatusName" Nullable="false" MaxLength="100" />
          <Property Type="String" Name="PageUrl" Nullable="false" MaxLength="200" />
          <Property Type="Boolean" Name="ViewAccess" Nullable="true" />
          <Property Type="Boolean" Name="CreateAccess" Nullable="true" />
          <Property Type="Boolean" Name="ModifyAccess" Nullable="true" />
          <Property Type="Boolean" Name="DeleteAccess" Nullable="true" />
          <Property Type="Boolean" Name="PrintAccess" Nullable="true" />
        </ComplexType>
        <ComplexType Name="GetSiteUser_Result">
          <Property Type="Int32" Name="Site_User_Id" Nullable="false" />
          <Property Type="Int32" Name="Role_Id" Nullable="false" />
          <Property Type="Int32" Name="Location_Id" Nullable="false" />
          <Property Type="String" Name="Name" Nullable="false" MaxLength="50" />
          <Property Type="String" Name="Login_Name" Nullable="true" MaxLength="50" />
          <Property Type="String" Name="Password" Nullable="false" MaxLength="50" />
          <Property Type="String" Name="Email" Nullable="true" MaxLength="50" />
          <Property Type="Boolean" Name="Status" Nullable="false" />
          <Property Type="String" Name="Employee_Code" Nullable="true" MaxLength="50" />
        </ComplexType>
        <ComplexType Name="GetTarget_Result">
          <Property Type="Int32" Name="Target_Id" Nullable="false" />
          <Property Type="Int32" Name="Month" Nullable="false" />
          <Property Type="Int32" Name="Year" Nullable="false" />
          <Property Type="Int32" Name="Site_User_Id" Nullable="false" />
          <Property Type="Int32" Name="Sales" Nullable="true" />
          <Property Type="Int32" Name="Collection" Nullable="true" />
          <Property Type="Int32" Name="Secondary_Sales" Nullable="true" />
        </ComplexType>
        <ComplexType Name="GetUserRoleLocationRegionCountry_Result">
          <Property Type="Int32" Name="Site_User_Id" Nullable="false" />
          <Property Type="String" Name="Name" Nullable="false" MaxLength="50" />
          <Property Type="String" Name="Email" Nullable="true" MaxLength="50" />
          <Property Type="Boolean" Name="Status" Nullable="false" />
          <Property Type="Int32" Name="Role_Id" Nullable="false" />
          <Property Type="String" Name="Role_Name" Nullable="false" MaxLength="50" />
          <Property Type="Int32" Name="Location_Id" Nullable="false" />
          <Property Type="String" Name="Location_Name" Nullable="false" MaxLength="50" />
          <Property Type="Int32" Name="Region_Id" Nullable="false" />
          <Property Type="String" Name="Region_Name" Nullable="false" MaxLength="50" />
          <Property Type="Int32" Name="Country_Id" Nullable="false" />
          <Property Type="String" Name="Country_Name" Nullable="false" MaxLength="50" />
        </ComplexType>
        <ComplexType Name="sp_helpdiagramdefinition_Result">
          <Property Type="Int32" Name="version" Nullable="true" />
          <Property Type="Binary" Name="definition" Nullable="true" />
        </ComplexType>
        <ComplexType Name="sp_helpdiagrams_Result">
          <Property Type="String" Name="Database" Nullable="true" MaxLength="128" />
          <Property Type="String" Name="Name" Nullable="false" MaxLength="128" />
          <Property Type="Int32" Name="ID" Nullable="false" />
          <Property Type="String" Name="Owner" Nullable="true" MaxLength="128" />
          <Property Type="Int32" Name="OwnerID" Nullable="false" />
        </ComplexType>
        <ComplexType Name="GetAttendanceAndDSR_Result">
          <Property Type="DateTime" Name="A_Date" Nullable="true" />
          <Property Type="String" Name="A_Status" Nullable="true" MaxLength="10" />
          <Property Type="String" Name="DSR_Status" Nullable="true" MaxLength="10" />
          <Property Type="Int32" Name="Site_User_Id" Nullable="true" />
          <Property Type="String" Name="Name" Nullable="false" MaxLength="50" />
          <Property Type="Int32" Name="DSR_Id" Nullable="true" />
          <Property Type="Int32" Name="DSR_Head_Id" Nullable="true" />
        </ComplexType>
        <EntityType Name="User_Language">
          <Key>
            <PropertyRef Name="User_Language_Id" />
          </Key>
          <Property Type="Int32" Name="User_Language_Id" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
          <Property Type="Int32" Name="Site_User_Id" Nullable="false" />
          <Property Type="Int32" Name="Language_Id" Nullable="false" />
          <NavigationProperty Name="Site_User" Relationship="NikaiDSRModel.FK_User_Language_Site_User" FromRole="User_Language" ToRole="Site_User" />
          <NavigationProperty Name="ParameterDet" Relationship="NikaiDSRModel.FK_User_Language_ParameterDet" FromRole="User_Language" ToRole="ParameterDet" />
        </EntityType>
        <Association Name="FK_User_Language_Site_User">
          <End Type="NikaiDSRModel.Site_User" Role="Site_User" Multiplicity="1" />
          <End Type="NikaiDSRModel.User_Language" Role="User_Language" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="Site_User">
              <PropertyRef Name="Site_User_Id" />
            </Principal>
            <Dependent Role="User_Language">
              <PropertyRef Name="Site_User_Id" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <ComplexType Name="GetUser_Result">
          <Property Type="Int32" Name="Site_User_Id" Nullable="false" />
          <Property Type="Int32" Name="Role_Id" Nullable="false" />
          <Property Type="Int32" Name="Location_Id" Nullable="false" />
          <Property Type="String" Name="Name" Nullable="false" MaxLength="50" />
          <Property Type="String" Name="Login_Name" Nullable="true" MaxLength="50" />
          <Property Type="String" Name="Password" Nullable="false" MaxLength="50" />
          <Property Type="String" Name="Email" Nullable="true" MaxLength="50" />
          <Property Type="Boolean" Name="Status" Nullable="false" />
          <Property Type="String" Name="Employee_Code" Nullable="true" MaxLength="50" />
          <Property Type="Int32" Name="Language_Id" Nullable="true" />
        </ComplexType>
        <EntityType Name="ParameterDet">
          <Key>
            <PropertyRef Name="ParameterDetId" />
          </Key>
          <Property Type="Int32" Name="ParameterDetId" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
          <Property Type="Int32" Name="ParameterId" Nullable="false" />
          <Property Type="Int32" Name="ParameterValue" Nullable="false" />
          <Property Type="String" Name="Code" MaxLength="25" FixedLength="false" Unicode="false" />
          <Property Type="String" Name="Description" Nullable="false" MaxLength="100" FixedLength="false" Unicode="false" />
          <Property Type="String" Name="Description_BL" MaxLength="100" FixedLength="false" Unicode="false" />
          <Property Type="Int32" Name="SortOrder" Nullable="false" />
          <NavigationProperty Name="Customers" Relationship="NikaiDSRModel.FK_Customer_ParameterDet" FromRole="ParameterDet" ToRole="Customer" />
          <NavigationProperty Name="Customers1" Relationship="NikaiDSRModel.FK_Customer_ParameterDet1" FromRole="ParameterDet" ToRole="Customer" />
          <NavigationProperty Name="Customers2" Relationship="NikaiDSRModel.FK_Customer_ParameterDet2" FromRole="ParameterDet" ToRole="Customer" />
          <NavigationProperty Name="Holidays" Relationship="NikaiDSRModel.FK_Holiday_ParameterDet" FromRole="ParameterDet" ToRole="Holiday" />
          <NavigationProperty Name="Menus" Relationship="NikaiDSRModel.FK_Menu_ParameterDet" FromRole="ParameterDet" ToRole="Menu" />
          <NavigationProperty Name="MenuAccesses" Relationship="NikaiDSRModel.FK_MenuAccess_ParameterDet" FromRole="ParameterDet" ToRole="MenuAccess" />
          <NavigationProperty Name="Parameter" Relationship="NikaiDSRModel.FK_ParameterDet_Parameter" FromRole="ParameterDet" ToRole="Parameter" />
          <NavigationProperty Name="RoleRights" Relationship="NikaiDSRModel.FK_RoleRights_ParameterDet1" FromRole="ParameterDet" ToRole="RoleRight" />
          <NavigationProperty Name="User_Language" Relationship="NikaiDSRModel.FK_User_Language_ParameterDet" FromRole="ParameterDet" ToRole="User_Language" />
          <NavigationProperty Name="Customers3" Relationship="NikaiDSRModel.FK_Customer_ParameterDet3" FromRole="ParameterDet" ToRole="Customer" />
        </EntityType>
        <Association Name="FK_Customer_ParameterDet">
          <End Type="NikaiDSRModel.ParameterDet" Role="ParameterDet" Multiplicity="0..1" />
          <End Type="NikaiDSRModel.Customer" Role="Customer" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="ParameterDet">
              <PropertyRef Name="ParameterDetId" />
            </Principal>
            <Dependent Role="Customer">
              <PropertyRef Name="Business_Type" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_Customer_ParameterDet1">
          <End Type="NikaiDSRModel.ParameterDet" Role="ParameterDet" Multiplicity="0..1" />
          <End Type="NikaiDSRModel.Customer" Role="Customer" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="ParameterDet">
              <PropertyRef Name="ParameterDetId" />
            </Principal>
            <Dependent Role="Customer">
              <PropertyRef Name="Customer_Group" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_Customer_ParameterDet2">
          <End Type="NikaiDSRModel.ParameterDet" Role="ParameterDet" Multiplicity="0..1" />
          <End Type="NikaiDSRModel.Customer" Role="Customer" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="ParameterDet">
              <PropertyRef Name="ParameterDetId" />
            </Principal>
            <Dependent Role="Customer">
              <PropertyRef Name="Customer_Type" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_Holiday_ParameterDet">
          <End Type="NikaiDSRModel.ParameterDet" Role="ParameterDet" Multiplicity="1" />
          <End Type="NikaiDSRModel.Holiday" Role="Holiday" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="ParameterDet">
              <PropertyRef Name="ParameterDetId" />
            </Principal>
            <Dependent Role="Holiday">
              <PropertyRef Name="Holiday_Type" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_Menu_ParameterDet">
          <End Type="NikaiDSRModel.ParameterDet" Role="ParameterDet" Multiplicity="1" />
          <End Type="NikaiDSRModel.Menu" Role="Menu" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="ParameterDet">
              <PropertyRef Name="ParameterDetId" />
            </Principal>
            <Dependent Role="Menu">
              <PropertyRef Name="MenuStatus" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_MenuAccess_ParameterDet">
          <End Type="NikaiDSRModel.ParameterDet" Role="ParameterDet" Multiplicity="1" />
          <End Type="NikaiDSRModel.MenuAccess" Role="MenuAccess" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="ParameterDet">
              <PropertyRef Name="ParameterDetId" />
            </Principal>
            <Dependent Role="MenuAccess">
              <PropertyRef Name="AccessType" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_ParameterDet_Parameter">
          <End Type="NikaiDSRModel.Parameter" Role="Parameter" Multiplicity="1" />
          <End Type="NikaiDSRModel.ParameterDet" Role="ParameterDet" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="Parameter">
              <PropertyRef Name="ParameterId" />
            </Principal>
            <Dependent Role="ParameterDet">
              <PropertyRef Name="ParameterId" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_RoleRights_ParameterDet1">
          <End Type="NikaiDSRModel.ParameterDet" Role="ParameterDet" Multiplicity="1" />
          <End Type="NikaiDSRModel.RoleRight" Role="RoleRight" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="ParameterDet">
              <PropertyRef Name="ParameterDetId" />
            </Principal>
            <Dependent Role="RoleRight">
              <PropertyRef Name="AccessType" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_User_Language_ParameterDet">
          <End Type="NikaiDSRModel.ParameterDet" Role="ParameterDet" Multiplicity="1" />
          <End Type="NikaiDSRModel.User_Language" Role="User_Language" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="ParameterDet">
              <PropertyRef Name="ParameterDetId" />
            </Principal>
            <Dependent Role="User_Language">
              <PropertyRef Name="Language_Id" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <ComplexType Name="GetParameter_Result">
          <Property Type="Int32" Name="ParameterDetId" Nullable="true" />
          <Property Type="Int32" Name="ParameterId" Nullable="true" />
          <Property Type="String" Name="Code" Nullable="true" MaxLength="25" />
          <Property Type="Int32" Name="ParameterValue" Nullable="true" />
          <Property Type="String" Name="ParameterText" Nullable="true" MaxLength="100" />
          <Property Type="String" Name="Description" Nullable="true" MaxLength="50" />
          <Property Type="String" Name="DescriptionBL" Nullable="true" MaxLength="50" />
          <Property Type="Int32" Name="SortOrder" Nullable="true" />
        </ComplexType>
        <EntityType Name="Location">
          <Key>
            <PropertyRef Name="Location_Id" />
          </Key>
          <Property Type="Int32" Name="Location_Id" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
          <Property Type="String" Name="Location_Name" MaxLength="50" FixedLength="false" Unicode="true" />
          <Property Type="String" Name="Location_Name_BL" MaxLength="50" FixedLength="false" Unicode="true" />
          <Property Type="Int32" Name="Region_Id" Nullable="false" />
          <NavigationProperty Name="Customers" Relationship="NikaiDSRModel.FK_Customer_Location" FromRole="Location" ToRole="Customer" />
          <NavigationProperty Name="Region" Relationship="NikaiDSRModel.FK_Location_Region" FromRole="Location" ToRole="Region" />
          <NavigationProperty Name="Site_User" Relationship="NikaiDSRModel.FK_Site_User_Location" FromRole="Location" ToRole="Site_User" />
        </EntityType>
        <Association Name="FK_Customer_Location">
          <End Type="NikaiDSRModel.Location" Role="Location" Multiplicity="0..1" />
          <End Type="NikaiDSRModel.Customer" Role="Customer" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="Location">
              <PropertyRef Name="Location_Id" />
            </Principal>
            <Dependent Role="Customer">
              <PropertyRef Name="Location_Id" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_Location_Region">
          <End Type="NikaiDSRModel.Region" Role="Region" Multiplicity="1" />
          <End Type="NikaiDSRModel.Location" Role="Location" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="Region">
              <PropertyRef Name="Region_Id" />
            </Principal>
            <Dependent Role="Location">
              <PropertyRef Name="Region_Id" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_Site_User_Location">
          <End Type="NikaiDSRModel.Location" Role="Location" Multiplicity="1" />
          <End Type="NikaiDSRModel.Site_User" Role="Site_User" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="Location">
              <PropertyRef Name="Location_Id" />
            </Principal>
            <Dependent Role="Site_User">
              <PropertyRef Name="Location_Id" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <ComplexType Name="GetLocation_Result">
          <Property Type="Int32" Name="Location_Id" Nullable="false" />
          <Property Type="String" Name="Location_Name" Nullable="true" MaxLength="50" />
          <Property Type="String" Name="Location_Name_BL" Nullable="true" MaxLength="50" />
          <Property Type="Int32" Name="Region_Id" Nullable="false" />
        </ComplexType>
        <EntityType Name="Contact">
          <Key>
            <PropertyRef Name="Contact_Id" />
          </Key>
          <Property Type="Int32" Name="Contact_Id" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
          <Property Type="String" Name="Contact_Name" MaxLength="50" FixedLength="false" Unicode="true" />
          <Property Type="String" Name="Contact_Name_BL" MaxLength="50" FixedLength="false" Unicode="true" />
          <Property Type="Int32" Name="Customer_Id" Nullable="false" />
          <Property Type="String" Name="Department" MaxLength="50" FixedLength="false" Unicode="true" />
          <Property Type="String" Name="Department_BL" MaxLength="50" FixedLength="false" Unicode="true" />
          <Property Type="String" Name="Mobile" MaxLength="50" FixedLength="false" Unicode="true" />
          <Property Type="Boolean" Name="Status" Nullable="false" />
          <NavigationProperty Name="Customer" Relationship="NikaiDSRModel.FK_Contact_Customer" FromRole="Contact" ToRole="Customer" />
          <NavigationProperty Name="DSRs" Relationship="NikaiDSRModel.FK_DSR_Contact" FromRole="Contact" ToRole="DSR" />
        </EntityType>
        <Association Name="FK_Contact_Customer">
          <End Type="NikaiDSRModel.Customer" Role="Customer" Multiplicity="1" />
          <End Type="NikaiDSRModel.Contact" Role="Contact" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="Customer">
              <PropertyRef Name="Customer_Id" />
            </Principal>
            <Dependent Role="Contact">
              <PropertyRef Name="Customer_Id" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <Association Name="FK_DSR_Contact">
          <End Type="NikaiDSRModel.Contact" Role="Contact" Multiplicity="1" />
          <End Type="NikaiDSRModel.DSR" Role="DSR" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="Contact">
              <PropertyRef Name="Contact_Id" />
            </Principal>
            <Dependent Role="DSR">
              <PropertyRef Name="Contact_Id" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <ComplexType Name="GetContact_Result">
          <Property Type="Int32" Name="Contact_Id" Nullable="false" />
          <Property Type="String" Name="Contact_Name" Nullable="true" MaxLength="50" />
          <Property Type="String" Name="Contact_Name_BL" Nullable="true" MaxLength="50" />
          <Property Type="Int32" Name="Customer_Id" Nullable="false" />
          <Property Type="String" Name="Department" Nullable="true" MaxLength="50" />
          <Property Type="String" Name="Department_BL" Nullable="true" MaxLength="50" />
          <Property Type="String" Name="Mobile" Nullable="true" MaxLength="50" />
          <Property Type="Boolean" Name="Status" Nullable="false" />
        </ComplexType>
        <ComplexType Name="GetActiveDsrContactCustomerLocation_Result">
          <Property Type="Int32" Name="Site_User_Id" Nullable="false" />
          <Property Type="Int32" Name="DSR_Id" Nullable="false" />
          <Property Type="Int32" Name="Contact_Id" Nullable="false" />
          <Property Type="String" Name="Contact_Name" Nullable="true" MaxLength="50" />
          <Property Type="DateTime" Name="Date" Nullable="false" />
          <Property Type="Int32" Name="Customer_Id" Nullable="false" />
          <Property Type="Boolean" Name="Contact_Status" Nullable="false" />
          <Property Type="String" Name="Customer_Name" Nullable="true" MaxLength="50" />
          <Property Type="Int32" Name="Location_Id" Nullable="true" />
          <Property Type="Boolean" Name="Customer_Status" Nullable="false" />
          <Property Type="String" Name="Location_Name" Nullable="true" MaxLength="50" />
          <Property Type="String" Name="Customer_Name_BL" Nullable="true" MaxLength="50" />
          <Property Type="String" Name="Contact_Name_BL" Nullable="true" MaxLength="50" />
          <Property Type="Int32" Name="Updated_By" Nullable="false" />
          <Property Type="DateTime" Name="Updated_Date" Nullable="false" />
          <Property Type="String" Name="Location_Name_BL" Nullable="true" MaxLength="50" />
        </ComplexType>
        <EntityType Name="DSRReportView">
          <Key>
            <PropertyRef Name="Site_User_Id" />
            <PropertyRef Name="Date" />
            <PropertyRef Name="Customer_Id" />
            <PropertyRef Name="Contact_Id" />
            <PropertyRef Name="Status_Contact" />
            <PropertyRef Name="Status_Customer" />
          </Key>
          <Property Type="Int32" Name="Site_User_Id" Nullable="false" />
          <Property Type="DateTime" Name="Date" Nullable="false" Precision="0" />
          <Property Type="Int32" Name="Customer_Id" Nullable="false" />
          <Property Type="String" Name="Customer_Code" MaxLength="50" FixedLength="false" Unicode="true" />
          <Property Type="String" Name="Customer_Name" MaxLength="50" FixedLength="false" Unicode="true" />
          <Property Type="String" Name="Customer_Name_BL" MaxLength="50" FixedLength="false" Unicode="true" />
          <Property Type="Int32" Name="Contact_Id" Nullable="false" />
          <Property Type="String" Name="Contact_Name" MaxLength="50" FixedLength="false" Unicode="true" />
          <Property Type="String" Name="Contact_Name_BL" MaxLength="50" FixedLength="false" Unicode="true" />
          <Property Type="String" Name="Department_BL" MaxLength="50" FixedLength="false" Unicode="true" />
          <Property Type="String" Name="Department" MaxLength="50" FixedLength="false" Unicode="true" />
          <Property Type="String" Name="Mobile" MaxLength="50" FixedLength="false" Unicode="true" />
          <Property Type="Boolean" Name="Status_Contact" Nullable="false" />
          <Property Type="String" Name="Objective" MaxLength="50" FixedLength="false" Unicode="true" />
          <Property Type="Time" Name="Time_In" Precision="7" />
          <Property Type="Time" Name="Time_Out" Precision="7" />
          <Property Type="Int32" Name="Time_Spent" />
          <Property Type="Int32" Name="Time_w_Merchandiser" />
          <Property Type="Int32" Name="Collection" />
          <Property Type="Int32" Name="Secondary_Sales" />
          <Property Type="Int32" Name="Sales_LPO_Received" />
          <Property Type="Int32" Name="Discount" />
          <Property Type="Int32" Name="Sales_Return" />
          <Property Type="String" Name="Remarks" MaxLength="50" FixedLength="false" Unicode="true" />
          <Property Type="Boolean" Name="Status_Customer" Nullable="false" />
        </EntityType>
        <ComplexType Name="GetExecutiveTargetsActuals_Result">
          <Property Type="Int32" Name="Collection_Actual" Nullable="true" />
          <Property Type="Int32" Name="Collection_Target" Nullable="true" />
          <Property Type="Int32" Name="Lpo_Actual" Nullable="true" />
          <Property Type="Int32" Name="Lpo_Target" Nullable="true" />
          <Property Type="Int32" Name="Secondary_Sales_Actual" Nullable="true" />
          <Property Type="Int32" Name="Secondary_Sales_Target" Nullable="true" />
        </ComplexType>
        <ComplexType Name="GetManagerReport_Result">
          <Property Type="DateTime" Name="Date" Nullable="true" />
          <Property Type="Int32" Name="Executive_Id" Nullable="true" />
          <Property Type="String" Name="Executive_Name" Nullable="true" MaxLength="50" />
          <Property Type="Int32" Name="Executive_Count" Nullable="true" />
          <Property Type="String" Name="Present" Nullable="true" MaxLength="50" />
          <Property Type="Int32" Name="DSR_Submitted" Nullable="true" />
          <Property Type="String" Name="DSR_NotSubmittedBy" Nullable="true" MaxLength="50" />
          <Property Type="Int32" Name="Total_Customer_Visited" Nullable="true" />
          <Property Type="Int32" Name="Sales" Nullable="true" />
          <Property Type="Int32" Name="Secondary_Sales" Nullable="true" />
          <Property Type="Int32" Name="Collection" Nullable="true" />
          <Property Type="Int32" Name="Discount" Nullable="true" />
          <Property Type="Int32" Name="Sales_Return" Nullable="true" />
          <Property Type="Int32" Name="Time_Customer" Nullable="true" />
          <Property Type="Int32" Name="Time_Merchandiser" Nullable="true" />
          <Property Type="Int32" Name="Time_In_Office" Nullable="true" />
        </ComplexType>
        <ComplexType Name="GetManagerExecutive_Result">
          <Property Type="Int32" Name="Manager_Exec_Id" Nullable="false" />
          <Property Type="Int32" Name="Executive_Id" Nullable="false" />
          <Property Type="Int32" Name="Manager_Id" Nullable="false" />
          <Property Type="String" Name="Name" Nullable="false" MaxLength="50" />
        </ComplexType>
        <ComplexType Name="GetActiveCustomerLocationRegionCountry_Result">
          <Property Type="Int32" Name="Customer_Id" Nullable="true" />
          <Property Type="String" Name="Customer_Name" Nullable="true" MaxLength="50" />
          <Property Type="Boolean" Name="Key_Account" Nullable="true" />
          <Property Type="Boolean" Name="Customer_Status" Nullable="true" />
          <Property Type="Int32" Name="Location_Id" Nullable="true" />
          <Property Type="String" Name="Location_Name" Nullable="true" MaxLength="50" />
          <Property Type="Int32" Name="Site_User_Id" Nullable="true" />
          <Property Type="String" Name="Customer_Name_BL" Nullable="true" MaxLength="50" />
          <Property Type="Int32" Name="Updated_By" Nullable="true" />
          <Property Type="DateTime" Name="Updated_Date" Nullable="true" />
          <Property Type="String" Name="Customer_Code" Nullable="true" MaxLength="50" />
          <Property Type="Int32" Name="Business_Type" Nullable="true" />
          <Property Type="Int32" Name="Customer_Type" Nullable="true" />
          <Property Type="Int32" Name="Customer_Group" Nullable="true" />
          <Property Type="String" Name="Country_Name" Nullable="true" MaxLength="50" />
          <Property Type="String" Name="Region_Name" Nullable="true" MaxLength="50" />
          <Property Type="String" Name="Updated_By_Value" Nullable="true" MaxLength="50" />
          <Property Type="String" Name="Business_Type_Value" Nullable="true" MaxLength="50" />
          <Property Type="String" Name="Customer_Type_Value" Nullable="true" MaxLength="50" />
          <Property Type="String" Name="Customer_Group_Value" Nullable="true" MaxLength="50" />
        </ComplexType>
        <ComplexType Name="GetContactWithCustName_Result">
          <Property Type="Int32" Name="Contact_Id" Nullable="false" />
          <Property Type="String" Name="Contact_Name" Nullable="true" MaxLength="50" />
          <Property Type="String" Name="Contact_Name_BL" Nullable="true" MaxLength="50" />
          <Property Type="Int32" Name="Customer_Id" Nullable="false" />
          <Property Type="String" Name="Department" Nullable="true" MaxLength="50" />
          <Property Type="String" Name="Department_BL" Nullable="true" MaxLength="50" />
          <Property Type="String" Name="Mobile" Nullable="true" MaxLength="50" />
          <Property Type="Boolean" Name="Status" Nullable="false" />
          <Property Type="String" Name="Customer_Name" Nullable="true" MaxLength="50" />
          <Property Type="String" Name="Customer_Name_BL" Nullable="true" MaxLength="50" />
        </ComplexType>
        <ComplexType Name="GetDSR_Result">
          <Property Type="Int32" Name="DSR_Id" Nullable="false" />
          <Property Type="Int32" Name="Site_User_Id" Nullable="false" />
          <Property Type="DateTime" Name="Date" Nullable="false" />
          <Property Type="Int32" Name="Contact_Id" Nullable="false" />
          <Property Type="String" Name="Objective" Nullable="true" MaxLength="50" />
          <Property Type="Time" Name="Time_In" Nullable="true" />
          <Property Type="Time" Name="Time_Out" Nullable="true" />
          <Property Type="Int32" Name="Time_Spent" Nullable="true" />
          <Property Type="Int32" Name="Time_w_Merchandiser" Nullable="true" />
          <Property Type="Int32" Name="Collection" Nullable="true" />
          <Property Type="Int32" Name="Secondary_Sales" Nullable="true" />
          <Property Type="Int32" Name="Sales_LPO_Received" Nullable="true" />
          <Property Type="Int32" Name="Discount" Nullable="true" />
          <Property Type="Int32" Name="Sales_Return" Nullable="true" />
          <Property Type="String" Name="Remarks" Nullable="true" MaxLength="50" />
        </ComplexType>
        <EntityType Name="ActiveContactCustomerLocationView">
          <Key>
            <PropertyRef Name="Customer_Id" />
            <PropertyRef Name="Customer_Status" />
            <PropertyRef Name="Location_Id" />
            <PropertyRef Name="Site_User_Id" />
            <PropertyRef Name="Updated_By" />
            <PropertyRef Name="Updated_Date" />
          </Key>
          <Property Type="Int32" Name="Contact_Id" />
          <Property Type="String" Name="Contact_Name" MaxLength="50" FixedLength="false" Unicode="true" />
          <Property Type="String" Name="Department" MaxLength="50" FixedLength="false" Unicode="true" />
          <Property Type="Boolean" Name="Contact_Status" />
          <Property Type="Int32" Name="Customer_Id" Nullable="false" />
          <Property Type="String" Name="Customer_Name" MaxLength="50" FixedLength="false" Unicode="true" />
          <Property Type="Boolean" Name="Key_Account" />
          <Property Type="Boolean" Name="Customer_Status" Nullable="false" />
          <Property Type="Int32" Name="Location_Id" Nullable="false" />
          <Property Type="String" Name="Location_Name" MaxLength="50" FixedLength="false" Unicode="true" />
          <Property Type="Int32" Name="Site_User_Id" Nullable="false" />
          <Property Type="String" Name="Customer_Name_BL" MaxLength="50" FixedLength="false" Unicode="true" />
          <Property Type="String" Name="Contact_Name_BL" MaxLength="50" FixedLength="false" Unicode="true" />
          <Property Type="Int32" Name="Updated_By" Nullable="false" />
          <Property Type="DateTime" Name="Updated_Date" Nullable="false" Precision="0" />
          <Property Type="String" Name="Customer_Code" MaxLength="50" FixedLength="false" Unicode="true" />
          <Property Type="Int32" Name="Business_Type" />
          <Property Type="Int32" Name="Customer_Type" />
          <Property Type="Int32" Name="Customer_Group" />
          <Property Type="String" Name="Department_BL" MaxLength="50" FixedLength="false" Unicode="true" />
          <Property Type="String" Name="Mobile" MaxLength="50" FixedLength="false" Unicode="true" />
        </EntityType>
        <EntityType Name="ActiveCustomerLocationRegionCountryView">
          <Key>
            <PropertyRef Name="Customer_Id" />
            <PropertyRef Name="Customer_Status" />
            <PropertyRef Name="Location_Id" />
            <PropertyRef Name="Updated_By" />
            <PropertyRef Name="Updated_Date" />
            <PropertyRef Name="Country_Name" />
            <PropertyRef Name="Region_Name" />
          </Key>
          <Property Type="Int32" Name="Customer_Id" Nullable="false" />
          <Property Type="String" Name="Customer_Name" MaxLength="50" FixedLength="false" Unicode="true" />
          <Property Type="Boolean" Name="Key_Account" />
          <Property Type="Boolean" Name="Customer_Status" Nullable="false" />
          <Property Type="Int32" Name="Location_Id" Nullable="false" />
          <Property Type="String" Name="Location_Name" MaxLength="50" FixedLength="false" Unicode="true" />
          <Property Type="String" Name="Customer_Name_BL" MaxLength="50" FixedLength="false" Unicode="true" />
          <Property Type="Int32" Name="Updated_By" Nullable="false" />
          <Property Type="DateTime" Name="Updated_Date" Nullable="false" Precision="0" />
          <Property Type="String" Name="Customer_Code" MaxLength="50" FixedLength="false" Unicode="true" />
          <Property Type="Int32" Name="Business_Type" />
          <Property Type="Int32" Name="Customer_Type" />
          <Property Type="Int32" Name="Customer_Group" />
          <Property Type="String" Name="Country_Name" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" />
          <Property Type="String" Name="Region_Name" Nullable="false" MaxLength="50" FixedLength="false" Unicode="true" />
        </EntityType>
        <EntityType Name="DsrContactCustomerLocationView">
          <Key>
            <PropertyRef Name="Site_User_Id" />
            <PropertyRef Name="DSR_Id" />
            <PropertyRef Name="Contact_Id" />
            <PropertyRef Name="Date" />
            <PropertyRef Name="Customer_Id" />
            <PropertyRef Name="Contact_Status" />
            <PropertyRef Name="Customer_Status" />
            <PropertyRef Name="Updated_By" />
            <PropertyRef Name="Updated_Date" />
          </Key>
          <Property Type="Int32" Name="Site_User_Id" Nullable="false" />
          <Property Type="Int32" Name="DSR_Id" Nullable="false" />
          <Property Type="Int32" Name="Contact_Id" Nullable="false" />
          <Property Type="String" Name="Contact_Name" MaxLength="50" FixedLength="false" Unicode="true" />
          <Property Type="DateTime" Name="Date" Nullable="false" Precision="0" />
          <Property Type="Int32" Name="Customer_Id" Nullable="false" />
          <Property Type="Boolean" Name="Contact_Status" Nullable="false" />
          <Property Type="String" Name="Customer_Name" MaxLength="50" FixedLength="false" Unicode="true" />
          <Property Type="Int32" Name="Location_Id" />
          <Property Type="Boolean" Name="Customer_Status" Nullable="false" />
          <Property Type="String" Name="Location_Name" MaxLength="50" FixedLength="false" Unicode="true" />
          <Property Type="String" Name="Customer_Name_BL" MaxLength="50" FixedLength="false" Unicode="true" />
          <Property Type="String" Name="Contact_Name_BL" MaxLength="50" FixedLength="false" Unicode="true" />
          <Property Type="Int32" Name="Updated_By" Nullable="false" />
          <Property Type="DateTime" Name="Updated_Date" Nullable="false" Precision="0" />
          <Property Type="String" Name="Location_Name_BL" MaxLength="50" FixedLength="false" Unicode="true" />
        </EntityType>
        <ComplexType Name="GetActiveContactCustomerLocation_Result">
          <Property Type="Int32" Name="Contact_Id" Nullable="true" />
          <Property Type="String" Name="Contact_Name" Nullable="true" MaxLength="50" />
          <Property Type="String" Name="Department" Nullable="true" MaxLength="50" />
          <Property Type="Boolean" Name="Contact_Status" Nullable="true" />
          <Property Type="Int32" Name="Customer_Id" Nullable="false" />
          <Property Type="String" Name="Customer_Name" Nullable="true" MaxLength="50" />
          <Property Type="Boolean" Name="Key_Account" Nullable="true" />
          <Property Type="Boolean" Name="Customer_Status" Nullable="false" />
          <Property Type="Int32" Name="Location_Id" Nullable="false" />
          <Property Type="String" Name="Location_Name" Nullable="true" MaxLength="50" />
          <Property Type="Int32" Name="Site_User_Id" Nullable="false" />
          <Property Type="String" Name="Customer_Name_BL" Nullable="true" MaxLength="50" />
          <Property Type="String" Name="Contact_Name_BL" Nullable="true" MaxLength="50" />
          <Property Type="Int32" Name="Updated_By" Nullable="false" />
          <Property Type="DateTime" Name="Updated_Date" Nullable="false" />
          <Property Type="String" Name="Customer_Code" Nullable="true" MaxLength="50" />
          <Property Type="Int32" Name="Business_Type" Nullable="true" />
          <Property Type="Int32" Name="Customer_Type" Nullable="true" />
          <Property Type="Int32" Name="Customer_Group" Nullable="true" />
          <Property Type="String" Name="Department_BL" Nullable="true" MaxLength="50" />
          <Property Type="String" Name="Mobile" Nullable="true" MaxLength="50" />
        </ComplexType>
        <ComplexType Name="GetExecutiveReport_Result">
          <Property Type="Int32" Name="Site_User_Id" Nullable="false" />
          <Property Type="DateTime" Name="Date" Nullable="false" />
          <Property Type="Int32" Name="Customer_Id" Nullable="false" />
          <Property Type="String" Name="Customer_Code" Nullable="true" MaxLength="50" />
          <Property Type="String" Name="Customer_Name" Nullable="true" MaxLength="50" />
          <Property Type="String" Name="Customer_Name_BL" Nullable="true" MaxLength="50" />
          <Property Type="Int32" Name="Contact_Id" Nullable="false" />
          <Property Type="String" Name="Contact_Name" Nullable="true" MaxLength="50" />
          <Property Type="String" Name="Contact_Name_BL" Nullable="true" MaxLength="50" />
          <Property Type="String" Name="Department_BL" Nullable="true" MaxLength="50" />
          <Property Type="String" Name="Department" Nullable="true" MaxLength="50" />
          <Property Type="String" Name="Mobile" Nullable="true" MaxLength="50" />
          <Property Type="Boolean" Name="Status_Contact" Nullable="false" />
          <Property Type="String" Name="Objective" Nullable="true" MaxLength="50" />
          <Property Type="Time" Name="Time_In" Nullable="true" />
          <Property Type="Time" Name="Time_Out" Nullable="true" />
          <Property Type="Int32" Name="Time_Spent" Nullable="true" />
          <Property Type="Int32" Name="Time_w_Merchandiser" Nullable="true" />
          <Property Type="Int32" Name="Collection" Nullable="true" />
          <Property Type="Int32" Name="Secondary_Sales" Nullable="true" />
          <Property Type="Int32" Name="Sales_LPO_Received" Nullable="true" />
          <Property Type="Int32" Name="Discount" Nullable="true" />
          <Property Type="Int32" Name="Sales_Return" Nullable="true" />
          <Property Type="String" Name="Remarks" Nullable="true" MaxLength="50" />
          <Property Type="Boolean" Name="Status_Customer" Nullable="false" />
          <Property Type="Int32" Name="ParameterDetId" Nullable="true" />
          <Property Type="Int32" Name="ParameterId" Nullable="true" />
          <Property Type="Int32" Name="ParameterValue" Nullable="true" />
          <Property Type="String" Name="Code" Nullable="true" MaxLength="25" />
          <Property Type="String" Name="Description" Nullable="true" MaxLength="100" />
          <Property Type="String" Name="Description_BL" Nullable="true" MaxLength="100" />
          <Property Type="Int32" Name="SortOrder" Nullable="true" />
          <Property Type="String" Name="ObjectiveValue" Nullable="true" MaxLength="100" />
        </ComplexType>
        <ComplexType Name="GetReporteesForUserCreation_Result">
          <Property Type="Int32" Name="Site_User_Id" Nullable="false" />
          <Property Type="String" Name="Name" Nullable="false" MaxLength="50" />
          <Property Type="String" Name="Email" Nullable="true" MaxLength="50" />
          <Property Type="Boolean" Name="Status" Nullable="false" />
          <Property Type="Int32" Name="Role_Id" Nullable="false" />
          <Property Type="String" Name="Role_Name" Nullable="false" MaxLength="50" />
          <Property Type="Int32" Name="Location_Id" Nullable="false" />
          <Property Type="String" Name="Location_Name" Nullable="true" MaxLength="50" />
          <Property Type="Int32" Name="Region_Id" Nullable="false" />
          <Property Type="String" Name="Region_Name" Nullable="false" MaxLength="50" />
          <Property Type="Int32" Name="Country_Id" Nullable="false" />
          <Property Type="String" Name="Country_Name" Nullable="false" MaxLength="50" />
        </ComplexType>
        <Association Name="FK_Customer_ParameterDet3">
          <End Type="NikaiDSRModel.ParameterDet" Role="ParameterDet" Multiplicity="0..1" />
          <End Type="NikaiDSRModel.Customer" Role="Customer" Multiplicity="*" />
          <ReferentialConstraint>
            <Principal Role="ParameterDet">
              <PropertyRef Name="ParameterDetId" />
            </Principal>
            <Dependent Role="Customer">
              <PropertyRef Name="Sales_Channel" />
            </Dependent>
          </ReferentialConstraint>
        </Association>
        <ComplexType Name="GetCustomer_Result">
          <Property Type="Int32" Name="Customer_Id" Nullable="false" />
          <Property Type="String" Name="Customer_Code" Nullable="true" MaxLength="50" />
          <Property Type="String" Name="Customer_Name" Nullable="true" MaxLength="50" />
          <Property Type="String" Name="Customer_Name_BL" Nullable="true" MaxLength="50" />
          <Property Type="Int32" Name="Business_Type" Nullable="true" />
          <Property Type="Int32" Name="Customer_Type" Nullable="true" />
          <Property Type="Int32" Name="Customer_Group" Nullable="true" />
          <Property Type="Int32" Name="Location_Id" Nullable="true" />
          <Property Type="Boolean" Name="Key_Account" Nullable="true" />
          <Property Type="Boolean" Name="Status" Nullable="false" />
          <Property Type="Int32" Name="Updated_By" Nullable="false" />
          <Property Type="DateTime" Name="Updated_Date" Nullable="false" />
          <Property Type="Int32" Name="Sales_Channel" Nullable="true" />
        </ComplexType>
      </Schema>
    </edmx:ConceptualModels>
    <!-- C-S mapping content -->
    <edmx:Mappings>
      <Mapping Space="C-S" xmlns="http://schemas.microsoft.com/ado/2008/09/mapping/cs">
        <EntityContainerMapping StorageEntityContainer="NikaiDSRModelStoreContainer" CdmEntityContainer="NikaiDSREntities">
          <EntitySetMapping Name="Absents">
            <EntityTypeMapping TypeName="NikaiDSRModel.Absent">
              <MappingFragment StoreEntitySet="Absent">
                <ScalarProperty Name="Absent_Id" ColumnName="Absent_Id" />
                <ScalarProperty Name="Date" ColumnName="Date" />
                <ScalarProperty Name="Site_User_Id" ColumnName="Site_User_Id" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="Countries">
            <EntityTypeMapping TypeName="NikaiDSRModel.Country">
              <MappingFragment StoreEntitySet="Country">
                <ScalarProperty Name="Country_Id" ColumnName="Country_Id" />
                <ScalarProperty Name="Country_Name" ColumnName="Country_Name" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="Customers">
            <EntityTypeMapping TypeName="NikaiDSRModel.Customer">
              <MappingFragment StoreEntitySet="Customer">
                <ScalarProperty Name="Sales_Channel" ColumnName="Sales_Channel" />
                <ScalarProperty Name="Customer_Id" ColumnName="Customer_Id" />
                <ScalarProperty Name="Customer_Code" ColumnName="Customer_Code" />
                <ScalarProperty Name="Customer_Name" ColumnName="Customer_Name" />
                <ScalarProperty Name="Customer_Name_BL" ColumnName="Customer_Name_BL" />
                <ScalarProperty Name="Business_Type" ColumnName="Business_Type" />
                <ScalarProperty Name="Customer_Type" ColumnName="Customer_Type" />
                <ScalarProperty Name="Customer_Group" ColumnName="Customer_Group" />
                <ScalarProperty Name="Location_Id" ColumnName="Location_Id" />
                <ScalarProperty Name="Key_Account" ColumnName="Key_Account" />
                <ScalarProperty Name="Status" ColumnName="Status" />
                <ScalarProperty Name="Updated_By" ColumnName="Updated_By" />
                <ScalarProperty Name="Updated_Date" ColumnName="Updated_Date" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="DSRs">
            <EntityTypeMapping TypeName="NikaiDSRModel.DSR">
              <MappingFragment StoreEntitySet="DSR">
                <ScalarProperty Name="DSR_Id" ColumnName="DSR_Id" />
                <ScalarProperty Name="Site_User_Id" ColumnName="Site_User_Id" />
                <ScalarProperty Name="Date" ColumnName="Date" />
                <ScalarProperty Name="Contact_Id" ColumnName="Contact_Id" />
                <ScalarProperty Name="Objective" ColumnName="Objective" />
                <ScalarProperty Name="Time_In" ColumnName="Time_In" />
                <ScalarProperty Name="Time_Out" ColumnName="Time_Out" />
                <ScalarProperty Name="Time_Spent" ColumnName="Time_Spent" />
                <ScalarProperty Name="Time_w_Merchandiser" ColumnName="Time_w_Merchandiser" />
                <ScalarProperty Name="Collection" ColumnName="Collection" />
                <ScalarProperty Name="Secondary_Sales" ColumnName="Secondary_Sales" />
                <ScalarProperty Name="Sales_LPO_Received" ColumnName="Sales_LPO_Received" />
                <ScalarProperty Name="Discount" ColumnName="Discount" />
                <ScalarProperty Name="Sales_Return" ColumnName="Sales_Return" />
                <ScalarProperty Name="Remarks" ColumnName="Remarks" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="DSR_Header">
            <EntityTypeMapping TypeName="NikaiDSRModel.DSR_Header">
              <MappingFragment StoreEntitySet="DSR_Header">
                <ScalarProperty Name="DSR_Head_Id" ColumnName="DSR_Head_Id" />
                <ScalarProperty Name="Date" ColumnName="Date" />
                <ScalarProperty Name="Shift" ColumnName="Shift" />
                <ScalarProperty Name="Morning_Time_In" ColumnName="Morning_Time_In" />
                <ScalarProperty Name="Morning_Time_Out" ColumnName="Morning_Time_Out" />
                <ScalarProperty Name="Evening_Time_In" ColumnName="Evening_Time_In" />
                <ScalarProperty Name="Evening_Time_Out" ColumnName="Evening_Time_Out" />
                <ScalarProperty Name="Comments" ColumnName="Comments" />
                <ScalarProperty Name="Site_User_Id" ColumnName="Site_User_Id" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="Holidays">
            <EntityTypeMapping TypeName="NikaiDSRModel.Holiday">
              <MappingFragment StoreEntitySet="Holiday">
                <ScalarProperty Name="Holiday_Id" ColumnName="Holiday_Id" />
                <ScalarProperty Name="Date" ColumnName="Date" />
                <ScalarProperty Name="Country_Id" ColumnName="Country_Id" />
                <ScalarProperty Name="Holiday_Type" ColumnName="Holiday_Type" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="Manager_Executive">
            <EntityTypeMapping TypeName="NikaiDSRModel.Manager_Executive">
              <MappingFragment StoreEntitySet="Manager_Executive">
                <ScalarProperty Name="Manager_Exec_Id" ColumnName="Manager_Exec_Id" />
                <ScalarProperty Name="Executive_Id" ColumnName="Executive_Id" />
                <ScalarProperty Name="Manager_Id" ColumnName="Manager_Id" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="Menus">
            <EntityTypeMapping TypeName="NikaiDSRModel.Menu">
              <MappingFragment StoreEntitySet="Menu">
                <ScalarProperty Name="MenuId" ColumnName="MenuId" />
                <ScalarProperty Name="MenuName" ColumnName="MenuName" />
                <ScalarProperty Name="MenuParentId" ColumnName="MenuParentId" />
                <ScalarProperty Name="MenuStatus" ColumnName="MenuStatus" />
                <ScalarProperty Name="MenuOrder" ColumnName="MenuOrder" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="MenuAccesses">
            <EntityTypeMapping TypeName="NikaiDSRModel.MenuAccess">
              <MappingFragment StoreEntitySet="MenuAccess">
                <ScalarProperty Name="MenuAccessId" ColumnName="MenuAccessId" />
                <ScalarProperty Name="MenuId" ColumnName="MenuId" />
                <ScalarProperty Name="AccessType" ColumnName="AccessType" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="MenuRolePages">
            <EntityTypeMapping TypeName="NikaiDSRModel.MenuRolePage">
              <MappingFragment StoreEntitySet="MenuRolePages">
                <ScalarProperty Name="MenuRoleId" ColumnName="MenuRoleId" />
                <ScalarProperty Name="MenuId" ColumnName="MenuId" />
                <ScalarProperty Name="RoleId" ColumnName="RoleId" />
                <ScalarProperty Name="PageUrl" ColumnName="PageUrl" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="Parameters">
            <EntityTypeMapping TypeName="NikaiDSRModel.Parameter">
              <MappingFragment StoreEntitySet="Parameter">
                <ScalarProperty Name="ParameterId" ColumnName="ParameterId" />
                <ScalarProperty Name="ParameterText" ColumnName="ParameterText" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="Regions">
            <EntityTypeMapping TypeName="NikaiDSRModel.Region">
              <MappingFragment StoreEntitySet="Region">
                <ScalarProperty Name="Region_Id" ColumnName="Region_Id" />
                <ScalarProperty Name="Region_Name" ColumnName="Region_Name" />
                <ScalarProperty Name="Country_Id" ColumnName="Country_Id" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="Roles">
            <EntityTypeMapping TypeName="NikaiDSRModel.Role">
              <MappingFragment StoreEntitySet="Role">
                <ScalarProperty Name="Role_Id" ColumnName="Role_Id" />
                <ScalarProperty Name="Role_Name" ColumnName="Role_Name" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="RoleRights">
            <EntityTypeMapping TypeName="NikaiDSRModel.RoleRight">
              <MappingFragment StoreEntitySet="RoleRights">
                <ScalarProperty Name="RightsId" ColumnName="RightsId" />
                <ScalarProperty Name="RoleId" ColumnName="RoleId" />
                <ScalarProperty Name="MenuId" ColumnName="MenuId" />
                <ScalarProperty Name="AccessType" ColumnName="AccessType" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="Site_User">
            <EntityTypeMapping TypeName="NikaiDSRModel.Site_User">
              <MappingFragment StoreEntitySet="Site_User">
                <ScalarProperty Name="Site_User_Id" ColumnName="Site_User_Id" />
                <ScalarProperty Name="Role_Id" ColumnName="Role_Id" />
                <ScalarProperty Name="Location_Id" ColumnName="Location_Id" />
                <ScalarProperty Name="Name" ColumnName="Name" />
                <ScalarProperty Name="Login_Name" ColumnName="Login_Name" />
                <ScalarProperty Name="Password" ColumnName="Password" />
                <ScalarProperty Name="Email" ColumnName="Email" />
                <ScalarProperty Name="Status" ColumnName="Status" />
                <ScalarProperty Name="Employee_Code" ColumnName="Employee_Code" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="sysdiagrams">
            <EntityTypeMapping TypeName="NikaiDSRModel.sysdiagram">
              <MappingFragment StoreEntitySet="sysdiagrams">
                <ScalarProperty Name="name" ColumnName="name" />
                <ScalarProperty Name="principal_id" ColumnName="principal_id" />
                <ScalarProperty Name="diagram_id" ColumnName="diagram_id" />
                <ScalarProperty Name="version" ColumnName="version" />
                <ScalarProperty Name="definition" ColumnName="definition" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="Targets">
            <EntityTypeMapping TypeName="NikaiDSRModel.Target">
              <MappingFragment StoreEntitySet="Target">
                <ScalarProperty Name="Target_Id" ColumnName="Target_Id" />
                <ScalarProperty Name="Month" ColumnName="Month" />
                <ScalarProperty Name="Year" ColumnName="Year" />
                <ScalarProperty Name="Site_User_Id" ColumnName="Site_User_Id" />
                <ScalarProperty Name="Sales" ColumnName="Sales" />
                <ScalarProperty Name="Collection" ColumnName="Collection" />
                <ScalarProperty Name="Secondary_Sales" ColumnName="Secondary_Sales" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="UserRoleLocationRegionCountryViews">
            <EntityTypeMapping TypeName="NikaiDSRModel.UserRoleLocationRegionCountryView">
              <MappingFragment StoreEntitySet="UserRoleLocationRegionCountryView">
                <ScalarProperty Name="Site_User_Id" ColumnName="Site_User_Id" />
                <ScalarProperty Name="Name" ColumnName="Name" />
                <ScalarProperty Name="Email" ColumnName="Email" />
                <ScalarProperty Name="Status" ColumnName="Status" />
                <ScalarProperty Name="Role_Id" ColumnName="Role_Id" />
                <ScalarProperty Name="Role_Name" ColumnName="Role_Name" />
                <ScalarProperty Name="Location_Id" ColumnName="Location_Id" />
                <ScalarProperty Name="Location_Name" ColumnName="Location_Name" />
                <ScalarProperty Name="Region_Id" ColumnName="Region_Id" />
                <ScalarProperty Name="Region_Name" ColumnName="Region_Name" />
                <ScalarProperty Name="Country_Id" ColumnName="Country_Id" />
                <ScalarProperty Name="Country_Name" ColumnName="Country_Name" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <FunctionImportMapping FunctionImportName="ActiveCustomerLocationRegionCountry" FunctionName="NikaiDSRModel.Store.ActiveCustomerLocationRegionCountry">
            <ResultMapping>
              <ComplexTypeMapping TypeName="NikaiDSRModel.ActiveCustomerLocationRegionCountry_Result">
                <ScalarProperty Name="Customer_Id" ColumnName="Customer_Id" />
                <ScalarProperty Name="Customer_Name" ColumnName="Customer_Name" />
                <ScalarProperty Name="Key_Account" ColumnName="Key_Account" />
                <ScalarProperty Name="Customer_Status" ColumnName="Customer_Status" />
                <ScalarProperty Name="Location_Id" ColumnName="Location_Id" />
                <ScalarProperty Name="Location_Name" ColumnName="Location_Name" />
                <ScalarProperty Name="Site_User_Id" ColumnName="Site_User_Id" />
                <ScalarProperty Name="Customer_Name_BL" ColumnName="Customer_Name_BL" />
                <ScalarProperty Name="Updated_By" ColumnName="Updated_By" />
                <ScalarProperty Name="Updated_Date" ColumnName="Updated_Date" />
                <ScalarProperty Name="Customer_Code" ColumnName="Customer_Code" />
                <ScalarProperty Name="Business_Type" ColumnName="Business_Type" />
                <ScalarProperty Name="Customer_Type" ColumnName="Customer_Type" />
                <ScalarProperty Name="Customer_Group" ColumnName="Customer_Group" />
                <ScalarProperty Name="Country_Name" ColumnName="Country_Name" />
                <ScalarProperty Name="Region_Name" ColumnName="Region_Name" />
              </ComplexTypeMapping>
            </ResultMapping>
          </FunctionImportMapping>
          <FunctionImportMapping FunctionImportName="ChangePassword" FunctionName="NikaiDSRModel.Store.ChangePassword" />
          <FunctionImportMapping FunctionImportName="GetAbsent" FunctionName="NikaiDSRModel.Store.GetAbsent">
            <ResultMapping>
              <ComplexTypeMapping TypeName="NikaiDSRModel.GetAbsent_Result">
                <ScalarProperty Name="Absent_Id" ColumnName="Absent_Id" />
                <ScalarProperty Name="Date" ColumnName="Date" />
                <ScalarProperty Name="Site_User_Id" ColumnName="Site_User_Id" />
              </ComplexTypeMapping>
            </ResultMapping>
          </FunctionImportMapping>
          <FunctionImportMapping FunctionImportName="GetAttendance" FunctionName="NikaiDSRModel.Store.GetAttendance">
            <ResultMapping>
              <ComplexTypeMapping TypeName="NikaiDSRModel.GetAttendance_Result">
                <ScalarProperty Name="A_Date" ColumnName="A_Date" />
                <ScalarProperty Name="Status" ColumnName="Status" />
                <ScalarProperty Name="Site_User_Id" ColumnName="Site_User_Id" />
              </ComplexTypeMapping>
            </ResultMapping>
          </FunctionImportMapping>
          <FunctionImportMapping FunctionImportName="GetCountry" FunctionName="NikaiDSRModel.Store.GetCountry">
            <ResultMapping>
              <ComplexTypeMapping TypeName="NikaiDSRModel.GetCountry_Result">
                <ScalarProperty Name="Country_Id" ColumnName="Country_Id" />
                <ScalarProperty Name="Country_Name" ColumnName="Country_Name" />
              </ComplexTypeMapping>
            </ResultMapping>
          </FunctionImportMapping>
          <FunctionImportMapping FunctionImportName="GetDSRHeader" FunctionName="NikaiDSRModel.Store.GetDSRHeader">
            <ResultMapping>
              <ComplexTypeMapping TypeName="NikaiDSRModel.GetDSRHeader_Result">
                <ScalarProperty Name="DSR_Head_Id" ColumnName="DSR_Head_Id" />
                <ScalarProperty Name="Date" ColumnName="Date" />
                <ScalarProperty Name="Shift" ColumnName="Shift" />
                <ScalarProperty Name="Morning_Time_In" ColumnName="Morning_Time_In" />
                <ScalarProperty Name="Morning_Time_Out" ColumnName="Morning_Time_Out" />
                <ScalarProperty Name="Evening_Time_In" ColumnName="Evening_Time_In" />
                <ScalarProperty Name="Evening_Time_Out" ColumnName="Evening_Time_Out" />
                <ScalarProperty Name="Comments" ColumnName="Comments" />
                <ScalarProperty Name="Site_User_Id" ColumnName="Site_User_Id" />
              </ComplexTypeMapping>
            </ResultMapping>
          </FunctionImportMapping>
          <FunctionImportMapping FunctionImportName="GetHoliday" FunctionName="NikaiDSRModel.Store.GetHoliday">
            <ResultMapping>
              <ComplexTypeMapping TypeName="NikaiDSRModel.GetHoliday_Result">
                <ScalarProperty Name="Holiday_Id" ColumnName="Holiday_Id" />
                <ScalarProperty Name="Date" ColumnName="Date" />
                <ScalarProperty Name="Country_Id" ColumnName="Country_Id" />
                <ScalarProperty Name="Holiday_Type" ColumnName="Holiday_Type" />
              </ComplexTypeMapping>
            </ResultMapping>
          </FunctionImportMapping>
          <FunctionImportMapping FunctionImportName="GetRegion" FunctionName="NikaiDSRModel.Store.GetRegion">
            <ResultMapping>
              <ComplexTypeMapping TypeName="NikaiDSRModel.GetRegion_Result">
                <ScalarProperty Name="Region_Id" ColumnName="Region_Id" />
                <ScalarProperty Name="Region_Name" ColumnName="Region_Name" />
                <ScalarProperty Name="Country_Id" ColumnName="Country_Id" />
              </ComplexTypeMapping>
            </ResultMapping>
          </FunctionImportMapping>
          <FunctionImportMapping FunctionImportName="GetRole" FunctionName="NikaiDSRModel.Store.GetRole">
            <ResultMapping>
              <ComplexTypeMapping TypeName="NikaiDSRModel.GetRole_Result">
                <ScalarProperty Name="Role_Id" ColumnName="Role_Id" />
                <ScalarProperty Name="Role_Name" ColumnName="Role_Name" />
              </ComplexTypeMapping>
            </ResultMapping>
          </FunctionImportMapping>
          <FunctionImportMapping FunctionImportName="GetRoleRights" FunctionName="NikaiDSRModel.Store.GetRoleRights">
            <ResultMapping>
              <ComplexTypeMapping TypeName="NikaiDSRModel.GetRoleRights_Result">
                <ScalarProperty Name="MenuId" ColumnName="MenuId" />
                <ScalarProperty Name="MenuName" ColumnName="MenuName" />
                <ScalarProperty Name="MenuParentId" ColumnName="MenuParentId" />
                <ScalarProperty Name="MenuStatus" ColumnName="MenuStatus" />
                <ScalarProperty Name="MenuOrder" ColumnName="MenuOrder" />
                <ScalarProperty Name="ParentMenuName" ColumnName="ParentMenuName" />
                <ScalarProperty Name="ParentNChildMenu" ColumnName="ParentNChildMenu" />
                <ScalarProperty Name="MenuStatusId" ColumnName="MenuStatusId" />
                <ScalarProperty Name="MenuStatusName" ColumnName="MenuStatusName" />
                <ScalarProperty Name="PageUrl" ColumnName="PageUrl" />
                <ScalarProperty Name="ViewAccess" ColumnName="ViewAccess" />
                <ScalarProperty Name="CreateAccess" ColumnName="CreateAccess" />
                <ScalarProperty Name="ModifyAccess" ColumnName="ModifyAccess" />
                <ScalarProperty Name="DeleteAccess" ColumnName="DeleteAccess" />
                <ScalarProperty Name="PrintAccess" ColumnName="PrintAccess" />
              </ComplexTypeMapping>
            </ResultMapping>
          </FunctionImportMapping>
          <FunctionImportMapping FunctionImportName="GetSiteUser" FunctionName="NikaiDSRModel.Store.GetSiteUser">
            <ResultMapping>
              <ComplexTypeMapping TypeName="NikaiDSRModel.GetSiteUser_Result">
                <ScalarProperty Name="Site_User_Id" ColumnName="Site_User_Id" />
                <ScalarProperty Name="Role_Id" ColumnName="Role_Id" />
                <ScalarProperty Name="Location_Id" ColumnName="Location_Id" />
                <ScalarProperty Name="Name" ColumnName="Name" />
                <ScalarProperty Name="Login_Name" ColumnName="Login_Name" />
                <ScalarProperty Name="Password" ColumnName="Password" />
                <ScalarProperty Name="Email" ColumnName="Email" />
                <ScalarProperty Name="Status" ColumnName="Status" />
                <ScalarProperty Name="Employee_Code" ColumnName="Employee_Code" />
              </ComplexTypeMapping>
            </ResultMapping>
          </FunctionImportMapping>
          <FunctionImportMapping FunctionImportName="GetTarget" FunctionName="NikaiDSRModel.Store.GetTarget">
            <ResultMapping>
              <ComplexTypeMapping TypeName="NikaiDSRModel.GetTarget_Result">
                <ScalarProperty Name="Target_Id" ColumnName="Target_Id" />
                <ScalarProperty Name="Month" ColumnName="Month" />
                <ScalarProperty Name="Year" ColumnName="Year" />
                <ScalarProperty Name="Site_User_Id" ColumnName="Site_User_Id" />
                <ScalarProperty Name="Sales" ColumnName="Sales" />
                <ScalarProperty Name="Collection" ColumnName="Collection" />
                <ScalarProperty Name="Secondary_Sales" ColumnName="Secondary_Sales" />
              </ComplexTypeMapping>
            </ResultMapping>
          </FunctionImportMapping>
          <FunctionImportMapping FunctionImportName="GetUserRoleLocationRegionCountry" FunctionName="NikaiDSRModel.Store.GetUserRoleLocationRegionCountry">
            <ResultMapping>
              <ComplexTypeMapping TypeName="NikaiDSRModel.GetUserRoleLocationRegionCountry_Result">
                <ScalarProperty Name="Site_User_Id" ColumnName="Site_User_Id" />
                <ScalarProperty Name="Name" ColumnName="Name" />
                <ScalarProperty Name="Email" ColumnName="Email" />
                <ScalarProperty Name="Status" ColumnName="Status" />
                <ScalarProperty Name="Role_Id" ColumnName="Role_Id" />
                <ScalarProperty Name="Role_Name" ColumnName="Role_Name" />
                <ScalarProperty Name="Location_Id" ColumnName="Location_Id" />
                <ScalarProperty Name="Location_Name" ColumnName="Location_Name" />
                <ScalarProperty Name="Region_Id" ColumnName="Region_Id" />
                <ScalarProperty Name="Region_Name" ColumnName="Region_Name" />
                <ScalarProperty Name="Country_Id" ColumnName="Country_Id" />
                <ScalarProperty Name="Country_Name" ColumnName="Country_Name" />
              </ComplexTypeMapping>
            </ResultMapping>
          </FunctionImportMapping>
          <FunctionImportMapping FunctionImportName="InsertLocation" FunctionName="NikaiDSRModel.Store.InsertLocation" />
          <FunctionImportMapping FunctionImportName="InsertRegion" FunctionName="NikaiDSRModel.Store.InsertRegion" />
          <FunctionImportMapping FunctionImportName="InsertUpdateAbsent" FunctionName="NikaiDSRModel.Store.InsertUpdateAbsent" />
          <FunctionImportMapping FunctionImportName="InsertUpdateCountry" FunctionName="NikaiDSRModel.Store.InsertUpdateCountry" />
          <FunctionImportMapping FunctionImportName="InsertUpdateDSR" FunctionName="NikaiDSRModel.Store.InsertUpdateDSR" />
          <FunctionImportMapping FunctionImportName="InsertUpdateDSRHeader" FunctionName="NikaiDSRModel.Store.InsertUpdateDSRHeader" />
          <FunctionImportMapping FunctionImportName="InsertUpdateHoliday" FunctionName="NikaiDSRModel.Store.InsertUpdateHoliday" />
          <FunctionImportMapping FunctionImportName="InsertUpdateManagerExecutive" FunctionName="NikaiDSRModel.Store.InsertUpdateManagerExecutive" />
          <FunctionImportMapping FunctionImportName="InsertUpdateRole" FunctionName="NikaiDSRModel.Store.InsertUpdateRole" />
          <FunctionImportMapping FunctionImportName="InsertUpdateSiteUser" FunctionName="NikaiDSRModel.Store.InsertUpdateSiteUser" />
          <FunctionImportMapping FunctionImportName="InsertUpdateTarget" FunctionName="NikaiDSRModel.Store.InsertUpdateTarget" />
          <FunctionImportMapping FunctionImportName="sp_alterdiagram" FunctionName="NikaiDSRModel.Store.sp_alterdiagram" />
          <FunctionImportMapping FunctionImportName="sp_creatediagram" FunctionName="NikaiDSRModel.Store.sp_creatediagram" />
          <FunctionImportMapping FunctionImportName="sp_dropdiagram" FunctionName="NikaiDSRModel.Store.sp_dropdiagram" />
          <FunctionImportMapping FunctionImportName="sp_helpdiagramdefinition" FunctionName="NikaiDSRModel.Store.sp_helpdiagramdefinition">
            <ResultMapping>
              <ComplexTypeMapping TypeName="NikaiDSRModel.sp_helpdiagramdefinition_Result">
                <ScalarProperty Name="version" ColumnName="version" />
                <ScalarProperty Name="definition" ColumnName="definition" />
              </ComplexTypeMapping>
            </ResultMapping>
          </FunctionImportMapping>
          <FunctionImportMapping FunctionImportName="sp_helpdiagrams" FunctionName="NikaiDSRModel.Store.sp_helpdiagrams">
            <ResultMapping>
              <ComplexTypeMapping TypeName="NikaiDSRModel.sp_helpdiagrams_Result">
                <ScalarProperty Name="Database" ColumnName="Database" />
                <ScalarProperty Name="Name" ColumnName="Name" />
                <ScalarProperty Name="ID" ColumnName="ID" />
                <ScalarProperty Name="Owner" ColumnName="Owner" />
                <ScalarProperty Name="OwnerID" ColumnName="OwnerID" />
              </ComplexTypeMapping>
            </ResultMapping>
          </FunctionImportMapping>
          <FunctionImportMapping FunctionImportName="sp_renamediagram" FunctionName="NikaiDSRModel.Store.sp_renamediagram" />
          <FunctionImportMapping FunctionImportName="sp_upgraddiagrams" FunctionName="NikaiDSRModel.Store.sp_upgraddiagrams" />
          <FunctionImportMapping FunctionImportName="UpdateLocation" FunctionName="NikaiDSRModel.Store.UpdateLocation" />
          <FunctionImportMapping FunctionImportName="UpdateRegion" FunctionName="NikaiDSRModel.Store.UpdateRegion" />
          <FunctionImportMapping FunctionImportName="InsertUpdateLinkedExecutive" FunctionName="NikaiDSRModel.Store.InsertUpdateLinkedExecutive" />
          <FunctionImportMapping FunctionImportName="GetAttendanceAndDSR" FunctionName="NikaiDSRModel.Store.GetAttendanceAndDSR">
            <ResultMapping>
              <ComplexTypeMapping TypeName="NikaiDSRModel.GetAttendanceAndDSR_Result">
                <ScalarProperty Name="A_Date" ColumnName="A_Date" />
                <ScalarProperty Name="A_Status" ColumnName="A_Status" />
                <ScalarProperty Name="DSR_Status" ColumnName="DSR_Status" />
                <ScalarProperty Name="Site_User_Id" ColumnName="Site_User_Id" />
                <ScalarProperty Name="Name" ColumnName="Name" />
                <ScalarProperty Name="DSR_Id" ColumnName="DSR_Id" />
                <ScalarProperty Name="DSR_Head_Id" ColumnName="DSR_Head_Id" />
              </ComplexTypeMapping>
            </ResultMapping>
          </FunctionImportMapping>
          <EntitySetMapping Name="User_Language">
            <EntityTypeMapping TypeName="NikaiDSRModel.User_Language">
              <MappingFragment StoreEntitySet="User_Language">
                <ScalarProperty Name="Language_Id" ColumnName="Language_Id" />
                <ScalarProperty Name="Site_User_Id" ColumnName="Site_User_Id" />
                <ScalarProperty Name="User_Language_Id" ColumnName="User_Language_Id" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <FunctionImportMapping FunctionImportName="GetUser" FunctionName="NikaiDSRModel.Store.GetUser">
            <ResultMapping>
              <ComplexTypeMapping TypeName="NikaiDSRModel.GetUser_Result">
                <ScalarProperty Name="Site_User_Id" ColumnName="Site_User_Id" />
                <ScalarProperty Name="Role_Id" ColumnName="Role_Id" />
                <ScalarProperty Name="Location_Id" ColumnName="Location_Id" />
                <ScalarProperty Name="Name" ColumnName="Name" />
                <ScalarProperty Name="Login_Name" ColumnName="Login_Name" />
                <ScalarProperty Name="Password" ColumnName="Password" />
                <ScalarProperty Name="Email" ColumnName="Email" />
                <ScalarProperty Name="Status" ColumnName="Status" />
                <ScalarProperty Name="Employee_Code" ColumnName="Employee_Code" />
                <ScalarProperty Name="Language_Id" ColumnName="Language_Id" />
              </ComplexTypeMapping>
            </ResultMapping>
          </FunctionImportMapping>
          <EntitySetMapping Name="ParameterDets">
            <EntityTypeMapping TypeName="NikaiDSRModel.ParameterDet">
              <MappingFragment StoreEntitySet="ParameterDet">
                <ScalarProperty Name="SortOrder" ColumnName="SortOrder" />
                <ScalarProperty Name="Description_BL" ColumnName="Description_BL" />
                <ScalarProperty Name="Description" ColumnName="Description" />
                <ScalarProperty Name="Code" ColumnName="Code" />
                <ScalarProperty Name="ParameterValue" ColumnName="ParameterValue" />
                <ScalarProperty Name="ParameterId" ColumnName="ParameterId" />
                <ScalarProperty Name="ParameterDetId" ColumnName="ParameterDetId" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <FunctionImportMapping FunctionImportName="GetParameter" FunctionName="NikaiDSRModel.Store.GetParameter">
            <ResultMapping>
              <ComplexTypeMapping TypeName="NikaiDSRModel.GetParameter_Result">
                <ScalarProperty Name="ParameterDetId" ColumnName="ParameterDetId" />
                <ScalarProperty Name="ParameterId" ColumnName="ParameterId" />
                <ScalarProperty Name="Code" ColumnName="Code" />
                <ScalarProperty Name="ParameterValue" ColumnName="ParameterValue" />
                <ScalarProperty Name="ParameterText" ColumnName="ParameterText" />
                <ScalarProperty Name="Description" ColumnName="Description" />
                <ScalarProperty Name="DescriptionBL" ColumnName="DescriptionBL" />
                <ScalarProperty Name="SortOrder" ColumnName="SortOrder" />
              </ComplexTypeMapping>
            </ResultMapping>
          </FunctionImportMapping>
          <EntitySetMapping Name="Locations">
            <EntityTypeMapping TypeName="NikaiDSRModel.Location">
              <MappingFragment StoreEntitySet="Location">
                <ScalarProperty Name="Region_Id" ColumnName="Region_Id" />
                <ScalarProperty Name="Location_Name_BL" ColumnName="Location_Name_BL" />
                <ScalarProperty Name="Location_Name" ColumnName="Location_Name" />
                <ScalarProperty Name="Location_Id" ColumnName="Location_Id" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <FunctionImportMapping FunctionImportName="GetLocation" FunctionName="NikaiDSRModel.Store.GetLocation">
            <ResultMapping>
              <ComplexTypeMapping TypeName="NikaiDSRModel.GetLocation_Result">
                <ScalarProperty Name="Location_Id" ColumnName="Location_Id" />
                <ScalarProperty Name="Location_Name" ColumnName="Location_Name" />
                <ScalarProperty Name="Location_Name_BL" ColumnName="Location_Name_BL" />
                <ScalarProperty Name="Region_Id" ColumnName="Region_Id" />
              </ComplexTypeMapping>
            </ResultMapping>
          </FunctionImportMapping>
          <EntitySetMapping Name="Contacts">
            <EntityTypeMapping TypeName="NikaiDSRModel.Contact">
              <MappingFragment StoreEntitySet="Contact">
                <ScalarProperty Name="Status" ColumnName="Status" />
                <ScalarProperty Name="Mobile" ColumnName="Mobile" />
                <ScalarProperty Name="Department_BL" ColumnName="Department_BL" />
                <ScalarProperty Name="Department" ColumnName="Department" />
                <ScalarProperty Name="Customer_Id" ColumnName="Customer_Id" />
                <ScalarProperty Name="Contact_Name_BL" ColumnName="Contact_Name_BL" />
                <ScalarProperty Name="Contact_Name" ColumnName="Contact_Name" />
                <ScalarProperty Name="Contact_Id" ColumnName="Contact_Id" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <FunctionImportMapping FunctionImportName="GetContact" FunctionName="NikaiDSRModel.Store.GetContact">
            <ResultMapping>
              <ComplexTypeMapping TypeName="NikaiDSRModel.GetContact_Result">
                <ScalarProperty Name="Contact_Id" ColumnName="Contact_Id" />
                <ScalarProperty Name="Contact_Name" ColumnName="Contact_Name" />
                <ScalarProperty Name="Contact_Name_BL" ColumnName="Contact_Name_BL" />
                <ScalarProperty Name="Customer_Id" ColumnName="Customer_Id" />
                <ScalarProperty Name="Department" ColumnName="Department" />
                <ScalarProperty Name="Department_BL" ColumnName="Department_BL" />
                <ScalarProperty Name="Mobile" ColumnName="Mobile" />
                <ScalarProperty Name="Status" ColumnName="Status" />
              </ComplexTypeMapping>
            </ResultMapping>
          </FunctionImportMapping>
          <FunctionImportMapping FunctionImportName="InsertUpdateContact" FunctionName="NikaiDSRModel.Store.InsertUpdateContact" />
          <FunctionImportMapping FunctionImportName="GetActiveDsrContactCustomerLocation" FunctionName="NikaiDSRModel.Store.GetActiveDsrContactCustomerLocation">
            <ResultMapping>
              <ComplexTypeMapping TypeName="NikaiDSRModel.GetActiveDsrContactCustomerLocation_Result">
                <ScalarProperty Name="Site_User_Id" ColumnName="Site_User_Id" />
                <ScalarProperty Name="DSR_Id" ColumnName="DSR_Id" />
                <ScalarProperty Name="Contact_Id" ColumnName="Contact_Id" />
                <ScalarProperty Name="Contact_Name" ColumnName="Contact_Name" />
                <ScalarProperty Name="Date" ColumnName="Date" />
                <ScalarProperty Name="Customer_Id" ColumnName="Customer_Id" />
                <ScalarProperty Name="Contact_Status" ColumnName="Contact_Status" />
                <ScalarProperty Name="Customer_Name" ColumnName="Customer_Name" />
                <ScalarProperty Name="Location_Id" ColumnName="Location_Id" />
                <ScalarProperty Name="Customer_Status" ColumnName="Customer_Status" />
                <ScalarProperty Name="Location_Name" ColumnName="Location_Name" />
                <ScalarProperty Name="Customer_Name_BL" ColumnName="Customer_Name_BL" />
                <ScalarProperty Name="Contact_Name_BL" ColumnName="Contact_Name_BL" />
                <ScalarProperty Name="Updated_By" ColumnName="Updated_By" />
                <ScalarProperty Name="Updated_Date" ColumnName="Updated_Date" />
                <ScalarProperty Name="Location_Name_BL" ColumnName="Location_Name_BL" />
              </ComplexTypeMapping>
            </ResultMapping>
          </FunctionImportMapping>
          <EntitySetMapping Name="DSRReportViews">
            <EntityTypeMapping TypeName="NikaiDSRModel.DSRReportView">
              <MappingFragment StoreEntitySet="DSRReportView">
                <ScalarProperty Name="Status_Customer" ColumnName="Status_Customer" />
                <ScalarProperty Name="Remarks" ColumnName="Remarks" />
                <ScalarProperty Name="Sales_Return" ColumnName="Sales_Return" />
                <ScalarProperty Name="Discount" ColumnName="Discount" />
                <ScalarProperty Name="Sales_LPO_Received" ColumnName="Sales_LPO_Received" />
                <ScalarProperty Name="Secondary_Sales" ColumnName="Secondary_Sales" />
                <ScalarProperty Name="Collection" ColumnName="Collection" />
                <ScalarProperty Name="Time_w_Merchandiser" ColumnName="Time_w_Merchandiser" />
                <ScalarProperty Name="Time_Spent" ColumnName="Time_Spent" />
                <ScalarProperty Name="Time_Out" ColumnName="Time_Out" />
                <ScalarProperty Name="Time_In" ColumnName="Time_In" />
                <ScalarProperty Name="Objective" ColumnName="Objective" />
                <ScalarProperty Name="Status_Contact" ColumnName="Status_Contact" />
                <ScalarProperty Name="Mobile" ColumnName="Mobile" />
                <ScalarProperty Name="Department" ColumnName="Department" />
                <ScalarProperty Name="Department_BL" ColumnName="Department_BL" />
                <ScalarProperty Name="Contact_Name_BL" ColumnName="Contact_Name_BL" />
                <ScalarProperty Name="Contact_Name" ColumnName="Contact_Name" />
                <ScalarProperty Name="Contact_Id" ColumnName="Contact_Id" />
                <ScalarProperty Name="Customer_Name_BL" ColumnName="Customer_Name_BL" />
                <ScalarProperty Name="Customer_Name" ColumnName="Customer_Name" />
                <ScalarProperty Name="Customer_Code" ColumnName="Customer_Code" />
                <ScalarProperty Name="Customer_Id" ColumnName="Customer_Id" />
                <ScalarProperty Name="Date" ColumnName="Date" />
                <ScalarProperty Name="Site_User_Id" ColumnName="Site_User_Id" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <FunctionImportMapping FunctionImportName="GetExecutiveTargetsActuals" FunctionName="NikaiDSRModel.Store.GetExecutiveTargetsActuals">
            <ResultMapping>
              <ComplexTypeMapping TypeName="NikaiDSRModel.GetExecutiveTargetsActuals_Result">
                <ScalarProperty Name="Collection_Actual" ColumnName="Collection_Actual" />
                <ScalarProperty Name="Collection_Target" ColumnName="Collection_Target" />
                <ScalarProperty Name="Lpo_Actual" ColumnName="Lpo_Actual" />
                <ScalarProperty Name="Lpo_Target" ColumnName="Lpo_Target" />
                <ScalarProperty Name="Secondary_Sales_Actual" ColumnName="Secondary_Sales_Actual" />
                <ScalarProperty Name="Secondary_Sales_Target" ColumnName="Secondary_Sales_Target" />
              </ComplexTypeMapping>
            </ResultMapping>
          </FunctionImportMapping>
          <FunctionImportMapping FunctionImportName="GetManagerReport" FunctionName="NikaiDSRModel.Store.GetManagerReport">
            <ResultMapping>
              <ComplexTypeMapping TypeName="NikaiDSRModel.GetManagerReport_Result">
                <ScalarProperty Name="Date" ColumnName="Date" />
                <ScalarProperty Name="Executive_Id" ColumnName="Executive_Id" />
                <ScalarProperty Name="Executive_Name" ColumnName="Executive_Name" />
                <ScalarProperty Name="Executive_Count" ColumnName="Executive_Count" />
                <ScalarProperty Name="Present" ColumnName="Present" />
                <ScalarProperty Name="DSR_Submitted" ColumnName="DSR_Submitted" />
                <ScalarProperty Name="DSR_NotSubmittedBy" ColumnName="DSR_NotSubmittedBy" />
                <ScalarProperty Name="Total_Customer_Visited" ColumnName="Total_Customer_Visited" />
                <ScalarProperty Name="Sales" ColumnName="Sales" />
                <ScalarProperty Name="Secondary_Sales" ColumnName="Secondary_Sales" />
                <ScalarProperty Name="Collection" ColumnName="Collection" />
                <ScalarProperty Name="Discount" ColumnName="Discount" />
                <ScalarProperty Name="Sales_Return" ColumnName="Sales_Return" />
                <ScalarProperty Name="Time_Customer" ColumnName="Time_Customer" />
                <ScalarProperty Name="Time_Merchandiser" ColumnName="Time_Merchandiser" />
                <ScalarProperty Name="Time_In_Office" ColumnName="Time_In_Office" />
              </ComplexTypeMapping>
            </ResultMapping>
          </FunctionImportMapping>
          <FunctionImportMapping FunctionImportName="GetManagerExecutive" FunctionName="NikaiDSRModel.Store.GetManagerExecutive">
            <ResultMapping>
              <ComplexTypeMapping TypeName="NikaiDSRModel.GetManagerExecutive_Result">
                <ScalarProperty Name="Manager_Exec_Id" ColumnName="Manager_Exec_Id" />
                <ScalarProperty Name="Executive_Id" ColumnName="Executive_Id" />
                <ScalarProperty Name="Manager_Id" ColumnName="Manager_Id" />
                <ScalarProperty Name="Name" ColumnName="Name" />
              </ComplexTypeMapping>
            </ResultMapping>
          </FunctionImportMapping>
          <FunctionImportMapping FunctionImportName="GetActiveCustomerLocationRegionCountry" FunctionName="NikaiDSRModel.Store.GetActiveCustomerLocationRegionCountry">
            <ResultMapping>
              <ComplexTypeMapping TypeName="NikaiDSRModel.GetActiveCustomerLocationRegionCountry_Result">
                <ScalarProperty Name="Customer_Id" ColumnName="Customer_Id" />
                <ScalarProperty Name="Customer_Name" ColumnName="Customer_Name" />
                <ScalarProperty Name="Key_Account" ColumnName="Key_Account" />
                <ScalarProperty Name="Customer_Status" ColumnName="Customer_Status" />
                <ScalarProperty Name="Location_Id" ColumnName="Location_Id" />
                <ScalarProperty Name="Location_Name" ColumnName="Location_Name" />
                <ScalarProperty Name="Site_User_Id" ColumnName="Site_User_Id" />
                <ScalarProperty Name="Customer_Name_BL" ColumnName="Customer_Name_BL" />
                <ScalarProperty Name="Updated_By" ColumnName="Updated_By" />
                <ScalarProperty Name="Updated_Date" ColumnName="Updated_Date" />
                <ScalarProperty Name="Customer_Code" ColumnName="Customer_Code" />
                <ScalarProperty Name="Business_Type" ColumnName="Business_Type" />
                <ScalarProperty Name="Customer_Type" ColumnName="Customer_Type" />
                <ScalarProperty Name="Customer_Group" ColumnName="Customer_Group" />
                <ScalarProperty Name="Country_Name" ColumnName="Country_Name" />
                <ScalarProperty Name="Region_Name" ColumnName="Region_Name" />
                <ScalarProperty Name="Updated_By_Value" ColumnName="Updated_By_Value" />
                <ScalarProperty Name="Business_Type_Value" ColumnName="Business_Type_Value" />
                <ScalarProperty Name="Customer_Type_Value" ColumnName="Customer_Type_Value" />
                <ScalarProperty Name="Customer_Group_Value" ColumnName="Customer_Group_Value" />
              </ComplexTypeMapping>
            </ResultMapping>
          </FunctionImportMapping>
          <FunctionImportMapping FunctionImportName="GetContactWithCustName" FunctionName="NikaiDSRModel.Store.GetContactWithCustName">
            <ResultMapping>
              <ComplexTypeMapping TypeName="NikaiDSRModel.GetContactWithCustName_Result">
                <ScalarProperty Name="Contact_Id" ColumnName="Contact_Id" />
                <ScalarProperty Name="Contact_Name" ColumnName="Contact_Name" />
                <ScalarProperty Name="Contact_Name_BL" ColumnName="Contact_Name_BL" />
                <ScalarProperty Name="Customer_Id" ColumnName="Customer_Id" />
                <ScalarProperty Name="Department" ColumnName="Department" />
                <ScalarProperty Name="Department_BL" ColumnName="Department_BL" />
                <ScalarProperty Name="Mobile" ColumnName="Mobile" />
                <ScalarProperty Name="Status" ColumnName="Status" />
                <ScalarProperty Name="Customer_Name" ColumnName="Customer_Name" />
                <ScalarProperty Name="Customer_Name_BL" ColumnName="Customer_Name_BL" />
              </ComplexTypeMapping>
            </ResultMapping>
          </FunctionImportMapping>
          <FunctionImportMapping FunctionImportName="InsertVisit" FunctionName="NikaiDSRModel.Store.InsertVisit" />
          <FunctionImportMapping FunctionImportName="GetDSR" FunctionName="NikaiDSRModel.Store.GetDSR">
            <ResultMapping>
              <ComplexTypeMapping TypeName="NikaiDSRModel.GetDSR_Result">
                <ScalarProperty Name="DSR_Id" ColumnName="DSR_Id" />
                <ScalarProperty Name="Site_User_Id" ColumnName="Site_User_Id" />
                <ScalarProperty Name="Date" ColumnName="Date" />
                <ScalarProperty Name="Contact_Id" ColumnName="Contact_Id" />
                <ScalarProperty Name="Objective" ColumnName="Objective" />
                <ScalarProperty Name="Time_In" ColumnName="Time_In" />
                <ScalarProperty Name="Time_Out" ColumnName="Time_Out" />
                <ScalarProperty Name="Time_Spent" ColumnName="Time_Spent" />
                <ScalarProperty Name="Time_w_Merchandiser" ColumnName="Time_w_Merchandiser" />
                <ScalarProperty Name="Collection" ColumnName="Collection" />
                <ScalarProperty Name="Secondary_Sales" ColumnName="Secondary_Sales" />
                <ScalarProperty Name="Sales_LPO_Received" ColumnName="Sales_LPO_Received" />
                <ScalarProperty Name="Discount" ColumnName="Discount" />
                <ScalarProperty Name="Sales_Return" ColumnName="Sales_Return" />
                <ScalarProperty Name="Remarks" ColumnName="Remarks" />
              </ComplexTypeMapping>
            </ResultMapping>
          </FunctionImportMapping>
          <EntitySetMapping Name="ActiveContactCustomerLocationViews">
            <EntityTypeMapping TypeName="NikaiDSRModel.ActiveContactCustomerLocationView">
              <MappingFragment StoreEntitySet="ActiveContactCustomerLocationView">
                <ScalarProperty Name="Mobile" ColumnName="Mobile" />
                <ScalarProperty Name="Department_BL" ColumnName="Department_BL" />
                <ScalarProperty Name="Customer_Group" ColumnName="Customer_Group" />
                <ScalarProperty Name="Customer_Type" ColumnName="Customer_Type" />
                <ScalarProperty Name="Business_Type" ColumnName="Business_Type" />
                <ScalarProperty Name="Customer_Code" ColumnName="Customer_Code" />
                <ScalarProperty Name="Updated_Date" ColumnName="Updated_Date" />
                <ScalarProperty Name="Updated_By" ColumnName="Updated_By" />
                <ScalarProperty Name="Contact_Name_BL" ColumnName="Contact_Name_BL" />
                <ScalarProperty Name="Customer_Name_BL" ColumnName="Customer_Name_BL" />
                <ScalarProperty Name="Site_User_Id" ColumnName="Site_User_Id" />
                <ScalarProperty Name="Location_Name" ColumnName="Location_Name" />
                <ScalarProperty Name="Location_Id" ColumnName="Location_Id" />
                <ScalarProperty Name="Customer_Status" ColumnName="Customer_Status" />
                <ScalarProperty Name="Key_Account" ColumnName="Key_Account" />
                <ScalarProperty Name="Customer_Name" ColumnName="Customer_Name" />
                <ScalarProperty Name="Customer_Id" ColumnName="Customer_Id" />
                <ScalarProperty Name="Contact_Status" ColumnName="Contact_Status" />
                <ScalarProperty Name="Department" ColumnName="Department" />
                <ScalarProperty Name="Contact_Name" ColumnName="Contact_Name" />
                <ScalarProperty Name="Contact_Id" ColumnName="Contact_Id" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="ActiveCustomerLocationRegionCountryViews">
            <EntityTypeMapping TypeName="NikaiDSRModel.ActiveCustomerLocationRegionCountryView">
              <MappingFragment StoreEntitySet="ActiveCustomerLocationRegionCountryView">
                <ScalarProperty Name="Region_Name" ColumnName="Region_Name" />
                <ScalarProperty Name="Country_Name" ColumnName="Country_Name" />
                <ScalarProperty Name="Customer_Group" ColumnName="Customer_Group" />
                <ScalarProperty Name="Customer_Type" ColumnName="Customer_Type" />
                <ScalarProperty Name="Business_Type" ColumnName="Business_Type" />
                <ScalarProperty Name="Customer_Code" ColumnName="Customer_Code" />
                <ScalarProperty Name="Updated_Date" ColumnName="Updated_Date" />
                <ScalarProperty Name="Updated_By" ColumnName="Updated_By" />
                <ScalarProperty Name="Customer_Name_BL" ColumnName="Customer_Name_BL" />
                <ScalarProperty Name="Location_Name" ColumnName="Location_Name" />
                <ScalarProperty Name="Location_Id" ColumnName="Location_Id" />
                <ScalarProperty Name="Customer_Status" ColumnName="Customer_Status" />
                <ScalarProperty Name="Key_Account" ColumnName="Key_Account" />
                <ScalarProperty Name="Customer_Name" ColumnName="Customer_Name" />
                <ScalarProperty Name="Customer_Id" ColumnName="Customer_Id" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <EntitySetMapping Name="DsrContactCustomerLocationViews">
            <EntityTypeMapping TypeName="NikaiDSRModel.DsrContactCustomerLocationView">
              <MappingFragment StoreEntitySet="DsrContactCustomerLocationView">
                <ScalarProperty Name="Location_Name_BL" ColumnName="Location_Name_BL" />
                <ScalarProperty Name="Updated_Date" ColumnName="Updated_Date" />
                <ScalarProperty Name="Updated_By" ColumnName="Updated_By" />
                <ScalarProperty Name="Contact_Name_BL" ColumnName="Contact_Name_BL" />
                <ScalarProperty Name="Customer_Name_BL" ColumnName="Customer_Name_BL" />
                <ScalarProperty Name="Location_Name" ColumnName="Location_Name" />
                <ScalarProperty Name="Customer_Status" ColumnName="Customer_Status" />
                <ScalarProperty Name="Location_Id" ColumnName="Location_Id" />
                <ScalarProperty Name="Customer_Name" ColumnName="Customer_Name" />
                <ScalarProperty Name="Contact_Status" ColumnName="Contact_Status" />
                <ScalarProperty Name="Customer_Id" ColumnName="Customer_Id" />
                <ScalarProperty Name="Date" ColumnName="Date" />
                <ScalarProperty Name="Contact_Name" ColumnName="Contact_Name" />
                <ScalarProperty Name="Contact_Id" ColumnName="Contact_Id" />
                <ScalarProperty Name="DSR_Id" ColumnName="DSR_Id" />
                <ScalarProperty Name="Site_User_Id" ColumnName="Site_User_Id" />
              </MappingFragment>
            </EntityTypeMapping>
          </EntitySetMapping>
          <FunctionImportMapping FunctionImportName="GetActiveContactCustomerLocation" FunctionName="NikaiDSRModel.Store.GetActiveContactCustomerLocation">
            <ResultMapping>
              <ComplexTypeMapping TypeName="NikaiDSRModel.GetActiveContactCustomerLocation_Result">
                <ScalarProperty Name="Contact_Id" ColumnName="Contact_Id" />
                <ScalarProperty Name="Contact_Name" ColumnName="Contact_Name" />
                <ScalarProperty Name="Department" ColumnName="Department" />
                <ScalarProperty Name="Contact_Status" ColumnName="Contact_Status" />
                <ScalarProperty Name="Customer_Id" ColumnName="Customer_Id" />
                <ScalarProperty Name="Customer_Name" ColumnName="Customer_Name" />
                <ScalarProperty Name="Key_Account" ColumnName="Key_Account" />
                <ScalarProperty Name="Customer_Status" ColumnName="Customer_Status" />
                <ScalarProperty Name="Location_Id" ColumnName="Location_Id" />
                <ScalarProperty Name="Location_Name" ColumnName="Location_Name" />
                <ScalarProperty Name="Site_User_Id" ColumnName="Site_User_Id" />
                <ScalarProperty Name="Customer_Name_BL" ColumnName="Customer_Name_BL" />
                <ScalarProperty Name="Contact_Name_BL" ColumnName="Contact_Name_BL" />
                <ScalarProperty Name="Updated_By" ColumnName="Updated_By" />
                <ScalarProperty Name="Updated_Date" ColumnName="Updated_Date" />
                <ScalarProperty Name="Customer_Code" ColumnName="Customer_Code" />
                <ScalarProperty Name="Business_Type" ColumnName="Business_Type" />
                <ScalarProperty Name="Customer_Type" ColumnName="Customer_Type" />
                <ScalarProperty Name="Customer_Group" ColumnName="Customer_Group" />
                <ScalarProperty Name="Department_BL" ColumnName="Department_BL" />
                <ScalarProperty Name="Mobile" ColumnName="Mobile" />
              </ComplexTypeMapping>
            </ResultMapping>
          </FunctionImportMapping>
          <FunctionImportMapping FunctionImportName="UpdateVisit" FunctionName="NikaiDSRModel.Store.UpdateVisit" />
          <FunctionImportMapping FunctionImportName="GetExecutiveReport" FunctionName="NikaiDSRModel.Store.GetExecutiveReport">
            <ResultMapping>
              <ComplexTypeMapping TypeName="NikaiDSRModel.GetExecutiveReport_Result">
                <ScalarProperty Name="Site_User_Id" ColumnName="Site_User_Id" />
                <ScalarProperty Name="Date" ColumnName="Date" />
                <ScalarProperty Name="Customer_Id" ColumnName="Customer_Id" />
                <ScalarProperty Name="Customer_Code" ColumnName="Customer_Code" />
                <ScalarProperty Name="Customer_Name" ColumnName="Customer_Name" />
                <ScalarProperty Name="Customer_Name_BL" ColumnName="Customer_Name_BL" />
                <ScalarProperty Name="Contact_Id" ColumnName="Contact_Id" />
                <ScalarProperty Name="Contact_Name" ColumnName="Contact_Name" />
                <ScalarProperty Name="Contact_Name_BL" ColumnName="Contact_Name_BL" />
                <ScalarProperty Name="Department_BL" ColumnName="Department_BL" />
                <ScalarProperty Name="Department" ColumnName="Department" />
                <ScalarProperty Name="Mobile" ColumnName="Mobile" />
                <ScalarProperty Name="Status_Contact" ColumnName="Status_Contact" />
                <ScalarProperty Name="Objective" ColumnName="Objective" />
                <ScalarProperty Name="Time_In" ColumnName="Time_In" />
                <ScalarProperty Name="Time_Out" ColumnName="Time_Out" />
                <ScalarProperty Name="Time_Spent" ColumnName="Time_Spent" />
                <ScalarProperty Name="Time_w_Merchandiser" ColumnName="Time_w_Merchandiser" />
                <ScalarProperty Name="Collection" ColumnName="Collection" />
                <ScalarProperty Name="Secondary_Sales" ColumnName="Secondary_Sales" />
                <ScalarProperty Name="Sales_LPO_Received" ColumnName="Sales_LPO_Received" />
                <ScalarProperty Name="Discount" ColumnName="Discount" />
                <ScalarProperty Name="Sales_Return" ColumnName="Sales_Return" />
                <ScalarProperty Name="Remarks" ColumnName="Remarks" />
                <ScalarProperty Name="Status_Customer" ColumnName="Status_Customer" />
                <ScalarProperty Name="ParameterDetId" ColumnName="ParameterDetId" />
                <ScalarProperty Name="ParameterId" ColumnName="ParameterId" />
                <ScalarProperty Name="ParameterValue" ColumnName="ParameterValue" />
                <ScalarProperty Name="Code" ColumnName="Code" />
                <ScalarProperty Name="Description" ColumnName="Description" />
                <ScalarProperty Name="Description_BL" ColumnName="Description_BL" />
                <ScalarProperty Name="SortOrder" ColumnName="SortOrder" />
                <ScalarProperty Name="ObjectiveValue" ColumnName="ObjectiveValue" />
              </ComplexTypeMapping>
            </ResultMapping>
          </FunctionImportMapping>
          <FunctionImportMapping FunctionImportName="GetReporteesForUserCreation" FunctionName="NikaiDSRModel.Store.GetReporteesForUserCreation">
            <ResultMapping>
              <ComplexTypeMapping TypeName="NikaiDSRModel.GetReporteesForUserCreation_Result">
                <ScalarProperty Name="Site_User_Id" ColumnName="Site_User_Id" />
                <ScalarProperty Name="Name" ColumnName="Name" />
                <ScalarProperty Name="Email" ColumnName="Email" />
                <ScalarProperty Name="Status" ColumnName="Status" />
                <ScalarProperty Name="Role_Id" ColumnName="Role_Id" />
                <ScalarProperty Name="Role_Name" ColumnName="Role_Name" />
                <ScalarProperty Name="Location_Id" ColumnName="Location_Id" />
                <ScalarProperty Name="Location_Name" ColumnName="Location_Name" />
                <ScalarProperty Name="Region_Id" ColumnName="Region_Id" />
                <ScalarProperty Name="Region_Name" ColumnName="Region_Name" />
                <ScalarProperty Name="Country_Id" ColumnName="Country_Id" />
                <ScalarProperty Name="Country_Name" ColumnName="Country_Name" />
              </ComplexTypeMapping>
            </ResultMapping>
          </FunctionImportMapping>
          <FunctionImportMapping FunctionImportName="InsertUpdateUser" FunctionName="NikaiDSRModel.Store.InsertUpdateUser" />
          <FunctionImportMapping FunctionImportName="GetCustomer" FunctionName="NikaiDSRModel.Store.GetCustomer">
            <ResultMapping>
              <ComplexTypeMapping TypeName="NikaiDSRModel.GetCustomer_Result">
                <ScalarProperty Name="Customer_Id" ColumnName="Customer_Id" />
                <ScalarProperty Name="Customer_Code" ColumnName="Customer_Code" />
                <ScalarProperty Name="Customer_Name" ColumnName="Customer_Name" />
                <ScalarProperty Name="Customer_Name_BL" ColumnName="Customer_Name_BL" />
                <ScalarProperty Name="Business_Type" ColumnName="Business_Type" />
                <ScalarProperty Name="Customer_Type" ColumnName="Customer_Type" />
                <ScalarProperty Name="Customer_Group" ColumnName="Customer_Group" />
                <ScalarProperty Name="Location_Id" ColumnName="Location_Id" />
                <ScalarProperty Name="Key_Account" ColumnName="Key_Account" />
                <ScalarProperty Name="Status" ColumnName="Status" />
                <ScalarProperty Name="Updated_By" ColumnName="Updated_By" />
                <ScalarProperty Name="Updated_Date" ColumnName="Updated_Date" />
                <ScalarProperty Name="Sales_Channel" ColumnName="Sales_Channel" />
              </ComplexTypeMapping>
            </ResultMapping>
          </FunctionImportMapping>
          <FunctionImportMapping FunctionImportName="InsertUpdateCustomer" FunctionName="NikaiDSRModel.Store.InsertUpdateCustomer" />
        </EntityContainerMapping>
      </Mapping>
    </edmx:Mappings>
  </edmx:Runtime>
  <!-- EF Designer content (DO NOT EDIT MANUALLY BELOW HERE) -->
  <Designer xmlns="http://schemas.microsoft.com/ado/2008/10/edmx">
    <Connection>
      <DesignerInfoPropertySet>
        <DesignerProperty Name="MetadataArtifactProcessing" Value="EmbedInOutputAssembly" />
      </DesignerInfoPropertySet>
    </Connection>
    <Options>
      <DesignerInfoPropertySet>
        <DesignerProperty Name="ValidateOnBuild" Value="true" />
        <DesignerProperty Name="EnablePluralization" Value="True" />
        <DesignerProperty Name="IncludeForeignKeysInModel" Value="True" />
        <DesignerProperty Name="CodeGenerationStrategy" Value="None" />
      </DesignerInfoPropertySet>
    </Options>
    <!-- Diagram content (shape and connector positions) -->
    <Diagrams></Diagrams>
  </Designer>
</edmx:Edmx>