<?xml version="1.0" encoding="utf-8"?>
<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>