<?xml version="1.0" encoding="utf-8"?>
<Mapping Space="C-S" xmlns="http://schemas.microsoft.com/ado/2008/09/mapping/cs">
  <EntityContainerMapping StorageEntityContainer="NikaiDSRModelStoreContainer" CdmEntityContainer="NikaiDSREntities">
    <EntitySetMapping Name="Absents">
      <EntityTypeMapping TypeName="NikaiDSRModel.Absent">
        <MappingFragment StoreEntitySet="Absent">
          <ScalarProperty Name="Absent_Id" ColumnName="Absent_Id" />
          <ScalarProperty Name="Date" ColumnName="Date" />
          <ScalarProperty Name="Site_User_Id" ColumnName="Site_User_Id" />
        </MappingFragment>
      </EntityTypeMapping>
    </EntitySetMapping>
    <EntitySetMapping Name="Countries">
      <EntityTypeMapping TypeName="NikaiDSRModel.Country">
        <MappingFragment StoreEntitySet="Country">
          <ScalarProperty Name="Country_Id" ColumnName="Country_Id" />
          <ScalarProperty Name="Country_Name" ColumnName="Country_Name" />
        </MappingFragment>
      </EntityTypeMapping>
    </EntitySetMapping>
    <EntitySetMapping Name="Customers">
      <EntityTypeMapping TypeName="NikaiDSRModel.Customer">
        <MappingFragment StoreEntitySet="Customer">
          <ScalarProperty Name="Sales_Channel" ColumnName="Sales_Channel" />
          <ScalarProperty Name="Customer_Id" ColumnName="Customer_Id" />
          <ScalarProperty Name="Customer_Code" ColumnName="Customer_Code" />
          <ScalarProperty Name="Customer_Name" ColumnName="Customer_Name" />
          <ScalarProperty Name="Customer_Name_BL" ColumnName="Customer_Name_BL" />
          <ScalarProperty Name="Business_Type" ColumnName="Business_Type" />
          <ScalarProperty Name="Customer_Type" ColumnName="Customer_Type" />
          <ScalarProperty Name="Customer_Group" ColumnName="Customer_Group" />
          <ScalarProperty Name="Location_Id" ColumnName="Location_Id" />
          <ScalarProperty Name="Key_Account" ColumnName="Key_Account" />
          <ScalarProperty Name="Status" ColumnName="Status" />
          <ScalarProperty Name="Updated_By" ColumnName="Updated_By" />
          <ScalarProperty Name="Updated_Date" ColumnName="Updated_Date" />
        </MappingFragment>
      </EntityTypeMapping>
    </EntitySetMapping>
    <EntitySetMapping Name="DSRs">
      <EntityTypeMapping TypeName="NikaiDSRModel.DSR">
        <MappingFragment StoreEntitySet="DSR">
          <ScalarProperty Name="DSR_Id" ColumnName="DSR_Id" />
          <ScalarProperty Name="Site_User_Id" ColumnName="Site_User_Id" />
          <ScalarProperty Name="Date" ColumnName="Date" />
          <ScalarProperty Name="Contact_Id" ColumnName="Contact_Id" />
          <ScalarProperty Name="Objective" ColumnName="Objective" />
          <ScalarProperty Name="Time_In" ColumnName="Time_In" />
          <ScalarProperty Name="Time_Out" ColumnName="Time_Out" />
          <ScalarProperty Name="Time_Spent" ColumnName="Time_Spent" />
          <ScalarProperty Name="Time_w_Merchandiser" ColumnName="Time_w_Merchandiser" />
          <ScalarProperty Name="Collection" ColumnName="Collection" />
          <ScalarProperty Name="Secondary_Sales" ColumnName="Secondary_Sales" />
          <ScalarProperty Name="Sales_LPO_Received" ColumnName="Sales_LPO_Received" />
          <ScalarProperty Name="Discount" ColumnName="Discount" />
          <ScalarProperty Name="Sales_Return" ColumnName="Sales_Return" />
          <ScalarProperty Name="Remarks" ColumnName="Remarks" />
        </MappingFragment>
      </EntityTypeMapping>
    </EntitySetMapping>
    <EntitySetMapping Name="DSR_Header">
      <EntityTypeMapping TypeName="NikaiDSRModel.DSR_Header">
        <MappingFragment StoreEntitySet="DSR_Header">
          <ScalarProperty Name="DSR_Head_Id" ColumnName="DSR_Head_Id" />
          <ScalarProperty Name="Date" ColumnName="Date" />
          <ScalarProperty Name="Shift" ColumnName="Shift" />
          <ScalarProperty Name="Morning_Time_In" ColumnName="Morning_Time_In" />
          <ScalarProperty Name="Morning_Time_Out" ColumnName="Morning_Time_Out" />
          <ScalarProperty Name="Evening_Time_In" ColumnName="Evening_Time_In" />
          <ScalarProperty Name="Evening_Time_Out" ColumnName="Evening_Time_Out" />
          <ScalarProperty Name="Comments" ColumnName="Comments" />
          <ScalarProperty Name="Site_User_Id" ColumnName="Site_User_Id" />
        </MappingFragment>
      </EntityTypeMapping>
    </EntitySetMapping>
    <EntitySetMapping Name="Holidays">
      <EntityTypeMapping TypeName="NikaiDSRModel.Holiday">
        <MappingFragment StoreEntitySet="Holiday">
          <ScalarProperty Name="Holiday_Id" ColumnName="Holiday_Id" />
          <ScalarProperty Name="Date" ColumnName="Date" />
          <ScalarProperty Name="Country_Id" ColumnName="Country_Id" />
          <ScalarProperty Name="Holiday_Type" ColumnName="Holiday_Type" />
        </MappingFragment>
      </EntityTypeMapping>
    </EntitySetMapping>
    <EntitySetMapping Name="Manager_Executive">
      <EntityTypeMapping TypeName="NikaiDSRModel.Manager_Executive">
        <MappingFragment StoreEntitySet="Manager_Executive">
          <ScalarProperty Name="Manager_Exec_Id" ColumnName="Manager_Exec_Id" />
          <ScalarProperty Name="Executive_Id" ColumnName="Executive_Id" />
          <ScalarProperty Name="Manager_Id" ColumnName="Manager_Id" />
        </MappingFragment>
      </EntityTypeMapping>
    </EntitySetMapping>
    <EntitySetMapping Name="Menus">
      <EntityTypeMapping TypeName="NikaiDSRModel.Menu">
        <MappingFragment StoreEntitySet="Menu">
          <ScalarProperty Name="MenuId" ColumnName="MenuId" />
          <ScalarProperty Name="MenuName" ColumnName="MenuName" />
          <ScalarProperty Name="MenuParentId" ColumnName="MenuParentId" />
          <ScalarProperty Name="MenuStatus" ColumnName="MenuStatus" />
          <ScalarProperty Name="MenuOrder" ColumnName="MenuOrder" />
        </MappingFragment>
      </EntityTypeMapping>
    </EntitySetMapping>
    <EntitySetMapping Name="MenuAccesses">
      <EntityTypeMapping TypeName="NikaiDSRModel.MenuAccess">
        <MappingFragment StoreEntitySet="MenuAccess">
          <ScalarProperty Name="MenuAccessId" ColumnName="MenuAccessId" />
          <ScalarProperty Name="MenuId" ColumnName="MenuId" />
          <ScalarProperty Name="AccessType" ColumnName="AccessType" />
        </MappingFragment>
      </EntityTypeMapping>
    </EntitySetMapping>
    <EntitySetMapping Name="MenuRolePages">
      <EntityTypeMapping TypeName="NikaiDSRModel.MenuRolePage">
        <MappingFragment StoreEntitySet="MenuRolePages">
          <ScalarProperty Name="MenuRoleId" ColumnName="MenuRoleId" />
          <ScalarProperty Name="MenuId" ColumnName="MenuId" />
          <ScalarProperty Name="RoleId" ColumnName="RoleId" />
          <ScalarProperty Name="PageUrl" ColumnName="PageUrl" />
        </MappingFragment>
      </EntityTypeMapping>
    </EntitySetMapping>
    <EntitySetMapping Name="Parameters">
      <EntityTypeMapping TypeName="NikaiDSRModel.Parameter">
        <MappingFragment StoreEntitySet="Parameter">
          <ScalarProperty Name="ParameterId" ColumnName="ParameterId" />
          <ScalarProperty Name="ParameterText" ColumnName="ParameterText" />
        </MappingFragment>
      </EntityTypeMapping>
    </EntitySetMapping>
    <EntitySetMapping Name="Regions">
      <EntityTypeMapping TypeName="NikaiDSRModel.Region">
        <MappingFragment StoreEntitySet="Region">
          <ScalarProperty Name="Region_Id" ColumnName="Region_Id" />
          <ScalarProperty Name="Region_Name" ColumnName="Region_Name" />
          <ScalarProperty Name="Country_Id" ColumnName="Country_Id" />
        </MappingFragment>
      </EntityTypeMapping>
    </EntitySetMapping>
    <EntitySetMapping Name="Roles">
      <EntityTypeMapping TypeName="NikaiDSRModel.Role">
        <MappingFragment StoreEntitySet="Role">
          <ScalarProperty Name="Role_Id" ColumnName="Role_Id" />
          <ScalarProperty Name="Role_Name" ColumnName="Role_Name" />
        </MappingFragment>
      </EntityTypeMapping>
    </EntitySetMapping>
    <EntitySetMapping Name="RoleRights">
      <EntityTypeMapping TypeName="NikaiDSRModel.RoleRight">
        <MappingFragment StoreEntitySet="RoleRights">
          <ScalarProperty Name="RightsId" ColumnName="RightsId" />
          <ScalarProperty Name="RoleId" ColumnName="RoleId" />
          <ScalarProperty Name="MenuId" ColumnName="MenuId" />
          <ScalarProperty Name="AccessType" ColumnName="AccessType" />
        </MappingFragment>
      </EntityTypeMapping>
    </EntitySetMapping>
    <EntitySetMapping Name="Site_User">
      <EntityTypeMapping TypeName="NikaiDSRModel.Site_User">
        <MappingFragment StoreEntitySet="Site_User">
          <ScalarProperty Name="Site_User_Id" ColumnName="Site_User_Id" />
          <ScalarProperty Name="Role_Id" ColumnName="Role_Id" />
          <ScalarProperty Name="Location_Id" ColumnName="Location_Id" />
          <ScalarProperty Name="Name" ColumnName="Name" />
          <ScalarProperty Name="Login_Name" ColumnName="Login_Name" />
          <ScalarProperty Name="Password" ColumnName="Password" />
          <ScalarProperty Name="Email" ColumnName="Email" />
          <ScalarProperty Name="Status" ColumnName="Status" />
          <ScalarProperty Name="Employee_Code" ColumnName="Employee_Code" />
        </MappingFragment>
      </EntityTypeMapping>
    </EntitySetMapping>
    <EntitySetMapping Name="sysdiagrams">
      <EntityTypeMapping TypeName="NikaiDSRModel.sysdiagram">
        <MappingFragment StoreEntitySet="sysdiagrams">
          <ScalarProperty Name="name" ColumnName="name" />
          <ScalarProperty Name="principal_id" ColumnName="principal_id" />
          <ScalarProperty Name="diagram_id" ColumnName="diagram_id" />
          <ScalarProperty Name="version" ColumnName="version" />
          <ScalarProperty Name="definition" ColumnName="definition" />
        </MappingFragment>
      </EntityTypeMapping>
    </EntitySetMapping>
    <EntitySetMapping Name="Targets">
      <EntityTypeMapping TypeName="NikaiDSRModel.Target">
        <MappingFragment StoreEntitySet="Target">
          <ScalarProperty Name="Target_Id" ColumnName="Target_Id" />
          <ScalarProperty Name="Month" ColumnName="Month" />
          <ScalarProperty Name="Year" ColumnName="Year" />
          <ScalarProperty Name="Site_User_Id" ColumnName="Site_User_Id" />
          <ScalarProperty Name="Sales" ColumnName="Sales" />
          <ScalarProperty Name="Collection" ColumnName="Collection" />
          <ScalarProperty Name="Secondary_Sales" ColumnName="Secondary_Sales" />
        </MappingFragment>
      </EntityTypeMapping>
    </EntitySetMapping>
    <EntitySetMapping Name="UserRoleLocationRegionCountryViews">
      <EntityTypeMapping TypeName="NikaiDSRModel.UserRoleLocationRegionCountryView">
        <MappingFragment StoreEntitySet="UserRoleLocationRegionCountryView">
          <ScalarProperty Name="Site_User_Id" ColumnName="Site_User_Id" />
          <ScalarProperty Name="Name" ColumnName="Name" />
          <ScalarProperty Name="Email" ColumnName="Email" />
          <ScalarProperty Name="Status" ColumnName="Status" />
          <ScalarProperty Name="Role_Id" ColumnName="Role_Id" />
          <ScalarProperty Name="Role_Name" ColumnName="Role_Name" />
          <ScalarProperty Name="Location_Id" ColumnName="Location_Id" />
          <ScalarProperty Name="Location_Name" ColumnName="Location_Name" />
          <ScalarProperty Name="Region_Id" ColumnName="Region_Id" />
          <ScalarProperty Name="Region_Name" ColumnName="Region_Name" />
          <ScalarProperty Name="Country_Id" ColumnName="Country_Id" />
          <ScalarProperty Name="Country_Name" ColumnName="Country_Name" />
        </MappingFragment>
      </EntityTypeMapping>
    </EntitySetMapping>
    <FunctionImportMapping FunctionImportName="ActiveCustomerLocationRegionCountry" FunctionName="NikaiDSRModel.Store.ActiveCustomerLocationRegionCountry">
      <ResultMapping>
        <ComplexTypeMapping TypeName="NikaiDSRModel.ActiveCustomerLocationRegionCountry_Result">
          <ScalarProperty Name="Customer_Id" ColumnName="Customer_Id" />
          <ScalarProperty Name="Customer_Name" ColumnName="Customer_Name" />
          <ScalarProperty Name="Key_Account" ColumnName="Key_Account" />
          <ScalarProperty Name="Customer_Status" ColumnName="Customer_Status" />
          <ScalarProperty Name="Location_Id" ColumnName="Location_Id" />
          <ScalarProperty Name="Location_Name" ColumnName="Location_Name" />
          <ScalarProperty Name="Site_User_Id" ColumnName="Site_User_Id" />
          <ScalarProperty Name="Customer_Name_BL" ColumnName="Customer_Name_BL" />
          <ScalarProperty Name="Updated_By" ColumnName="Updated_By" />
          <ScalarProperty Name="Updated_Date" ColumnName="Updated_Date" />
          <ScalarProperty Name="Customer_Code" ColumnName="Customer_Code" />
          <ScalarProperty Name="Business_Type" ColumnName="Business_Type" />
          <ScalarProperty Name="Customer_Type" ColumnName="Customer_Type" />
          <ScalarProperty Name="Customer_Group" ColumnName="Customer_Group" />
          <ScalarProperty Name="Country_Name" ColumnName="Country_Name" />
          <ScalarProperty Name="Region_Name" ColumnName="Region_Name" />
        </ComplexTypeMapping>
      </ResultMapping>
    </FunctionImportMapping>
    <FunctionImportMapping FunctionImportName="ChangePassword" FunctionName="NikaiDSRModel.Store.ChangePassword" />
    <FunctionImportMapping FunctionImportName="GetAbsent" FunctionName="NikaiDSRModel.Store.GetAbsent">
      <ResultMapping>
        <ComplexTypeMapping TypeName="NikaiDSRModel.GetAbsent_Result">
          <ScalarProperty Name="Absent_Id" ColumnName="Absent_Id" />
          <ScalarProperty Name="Date" ColumnName="Date" />
          <ScalarProperty Name="Site_User_Id" ColumnName="Site_User_Id" />
        </ComplexTypeMapping>
      </ResultMapping>
    </FunctionImportMapping>
    <FunctionImportMapping FunctionImportName="GetAttendance" FunctionName="NikaiDSRModel.Store.GetAttendance">
      <ResultMapping>
        <ComplexTypeMapping TypeName="NikaiDSRModel.GetAttendance_Result">
          <ScalarProperty Name="A_Date" ColumnName="A_Date" />
          <ScalarProperty Name="Status" ColumnName="Status" />
          <ScalarProperty Name="Site_User_Id" ColumnName="Site_User_Id" />
        </ComplexTypeMapping>
      </ResultMapping>
    </FunctionImportMapping>
    <FunctionImportMapping FunctionImportName="GetCountry" FunctionName="NikaiDSRModel.Store.GetCountry">
      <ResultMapping>
        <ComplexTypeMapping TypeName="NikaiDSRModel.GetCountry_Result">
          <ScalarProperty Name="Country_Id" ColumnName="Country_Id" />
          <ScalarProperty Name="Country_Name" ColumnName="Country_Name" />
        </ComplexTypeMapping>
      </ResultMapping>
    </FunctionImportMapping>
    <FunctionImportMapping FunctionImportName="GetDSRHeader" FunctionName="NikaiDSRModel.Store.GetDSRHeader">
      <ResultMapping>
        <ComplexTypeMapping TypeName="NikaiDSRModel.GetDSRHeader_Result">
          <ScalarProperty Name="DSR_Head_Id" ColumnName="DSR_Head_Id" />
          <ScalarProperty Name="Date" ColumnName="Date" />
          <ScalarProperty Name="Shift" ColumnName="Shift" />
          <ScalarProperty Name="Morning_Time_In" ColumnName="Morning_Time_In" />
          <ScalarProperty Name="Morning_Time_Out" ColumnName="Morning_Time_Out" />
          <ScalarProperty Name="Evening_Time_In" ColumnName="Evening_Time_In" />
          <ScalarProperty Name="Evening_Time_Out" ColumnName="Evening_Time_Out" />
          <ScalarProperty Name="Comments" ColumnName="Comments" />
          <ScalarProperty Name="Site_User_Id" ColumnName="Site_User_Id" />
        </ComplexTypeMapping>
      </ResultMapping>
    </FunctionImportMapping>
    <FunctionImportMapping FunctionImportName="GetHoliday" FunctionName="NikaiDSRModel.Store.GetHoliday">
      <ResultMapping>
        <ComplexTypeMapping TypeName="NikaiDSRModel.GetHoliday_Result">
          <ScalarProperty Name="Holiday_Id" ColumnName="Holiday_Id" />
          <ScalarProperty Name="Date" ColumnName="Date" />
          <ScalarProperty Name="Country_Id" ColumnName="Country_Id" />
          <ScalarProperty Name="Holiday_Type" ColumnName="Holiday_Type" />
        </ComplexTypeMapping>
      </ResultMapping>
    </FunctionImportMapping>
    <FunctionImportMapping FunctionImportName="GetRegion" FunctionName="NikaiDSRModel.Store.GetRegion">
      <ResultMapping>
        <ComplexTypeMapping TypeName="NikaiDSRModel.GetRegion_Result">
          <ScalarProperty Name="Region_Id" ColumnName="Region_Id" />
          <ScalarProperty Name="Region_Name" ColumnName="Region_Name" />
          <ScalarProperty Name="Country_Id" ColumnName="Country_Id" />
        </ComplexTypeMapping>
      </ResultMapping>
    </FunctionImportMapping>
    <FunctionImportMapping FunctionImportName="GetRole" FunctionName="NikaiDSRModel.Store.GetRole">
      <ResultMapping>
        <ComplexTypeMapping TypeName="NikaiDSRModel.GetRole_Result">
          <ScalarProperty Name="Role_Id" ColumnName="Role_Id" />
          <ScalarProperty Name="Role_Name" ColumnName="Role_Name" />
        </ComplexTypeMapping>
      </ResultMapping>
    </FunctionImportMapping>
    <FunctionImportMapping FunctionImportName="GetRoleRights" FunctionName="NikaiDSRModel.Store.GetRoleRights">
      <ResultMapping>
        <ComplexTypeMapping TypeName="NikaiDSRModel.GetRoleRights_Result">
          <ScalarProperty Name="MenuId" ColumnName="MenuId" />
          <ScalarProperty Name="MenuName" ColumnName="MenuName" />
          <ScalarProperty Name="MenuParentId" ColumnName="MenuParentId" />
          <ScalarProperty Name="MenuStatus" ColumnName="MenuStatus" />
          <ScalarProperty Name="MenuOrder" ColumnName="MenuOrder" />
          <ScalarProperty Name="ParentMenuName" ColumnName="ParentMenuName" />
          <ScalarProperty Name="ParentNChildMenu" ColumnName="ParentNChildMenu" />
          <ScalarProperty Name="MenuStatusId" ColumnName="MenuStatusId" />
          <ScalarProperty Name="MenuStatusName" ColumnName="MenuStatusName" />
          <ScalarProperty Name="PageUrl" ColumnName="PageUrl" />
          <ScalarProperty Name="ViewAccess" ColumnName="ViewAccess" />
          <ScalarProperty Name="CreateAccess" ColumnName="CreateAccess" />
          <ScalarProperty Name="ModifyAccess" ColumnName="ModifyAccess" />
          <ScalarProperty Name="DeleteAccess" ColumnName="DeleteAccess" />
          <ScalarProperty Name="PrintAccess" ColumnName="PrintAccess" />
        </ComplexTypeMapping>
      </ResultMapping>
    </FunctionImportMapping>
    <FunctionImportMapping FunctionImportName="GetSiteUser" FunctionName="NikaiDSRModel.Store.GetSiteUser">
      <ResultMapping>
        <ComplexTypeMapping TypeName="NikaiDSRModel.GetSiteUser_Result">
          <ScalarProperty Name="Site_User_Id" ColumnName="Site_User_Id" />
          <ScalarProperty Name="Role_Id" ColumnName="Role_Id" />
          <ScalarProperty Name="Location_Id" ColumnName="Location_Id" />
          <ScalarProperty Name="Name" ColumnName="Name" />
          <ScalarProperty Name="Login_Name" ColumnName="Login_Name" />
          <ScalarProperty Name="Password" ColumnName="Password" />
          <ScalarProperty Name="Email" ColumnName="Email" />
          <ScalarProperty Name="Status" ColumnName="Status" />
          <ScalarProperty Name="Employee_Code" ColumnName="Employee_Code" />
        </ComplexTypeMapping>
      </ResultMapping>
    </FunctionImportMapping>
    <FunctionImportMapping FunctionImportName="GetTarget" FunctionName="NikaiDSRModel.Store.GetTarget">
      <ResultMapping>
        <ComplexTypeMapping TypeName="NikaiDSRModel.GetTarget_Result">
          <ScalarProperty Name="Target_Id" ColumnName="Target_Id" />
          <ScalarProperty Name="Month" ColumnName="Month" />
          <ScalarProperty Name="Year" ColumnName="Year" />
          <ScalarProperty Name="Site_User_Id" ColumnName="Site_User_Id" />
          <ScalarProperty Name="Sales" ColumnName="Sales" />
          <ScalarProperty Name="Collection" ColumnName="Collection" />
          <ScalarProperty Name="Secondary_Sales" ColumnName="Secondary_Sales" />
        </ComplexTypeMapping>
      </ResultMapping>
    </FunctionImportMapping>
    <FunctionImportMapping FunctionImportName="GetUserRoleLocationRegionCountry" FunctionName="NikaiDSRModel.Store.GetUserRoleLocationRegionCountry">
      <ResultMapping>
        <ComplexTypeMapping TypeName="NikaiDSRModel.GetUserRoleLocationRegionCountry_Result">
          <ScalarProperty Name="Site_User_Id" ColumnName="Site_User_Id" />
          <ScalarProperty Name="Name" ColumnName="Name" />
          <ScalarProperty Name="Email" ColumnName="Email" />
          <ScalarProperty Name="Status" ColumnName="Status" />
          <ScalarProperty Name="Role_Id" ColumnName="Role_Id" />
          <ScalarProperty Name="Role_Name" ColumnName="Role_Name" />
          <ScalarProperty Name="Location_Id" ColumnName="Location_Id" />
          <ScalarProperty Name="Location_Name" ColumnName="Location_Name" />
          <ScalarProperty Name="Region_Id" ColumnName="Region_Id" />
          <ScalarProperty Name="Region_Name" ColumnName="Region_Name" />
          <ScalarProperty Name="Country_Id" ColumnName="Country_Id" />
          <ScalarProperty Name="Country_Name" ColumnName="Country_Name" />
        </ComplexTypeMapping>
      </ResultMapping>
    </FunctionImportMapping>
    <FunctionImportMapping FunctionImportName="InsertLocation" FunctionName="NikaiDSRModel.Store.InsertLocation" />
    <FunctionImportMapping FunctionImportName="InsertRegion" FunctionName="NikaiDSRModel.Store.InsertRegion" />
    <FunctionImportMapping FunctionImportName="InsertUpdateAbsent" FunctionName="NikaiDSRModel.Store.InsertUpdateAbsent" />
    <FunctionImportMapping FunctionImportName="InsertUpdateCountry" FunctionName="NikaiDSRModel.Store.InsertUpdateCountry" />
    <FunctionImportMapping FunctionImportName="InsertUpdateDSR" FunctionName="NikaiDSRModel.Store.InsertUpdateDSR" />
    <FunctionImportMapping FunctionImportName="InsertUpdateDSRHeader" FunctionName="NikaiDSRModel.Store.InsertUpdateDSRHeader" />
    <FunctionImportMapping FunctionImportName="InsertUpdateHoliday" FunctionName="NikaiDSRModel.Store.InsertUpdateHoliday" />
    <FunctionImportMapping FunctionImportName="InsertUpdateManagerExecutive" FunctionName="NikaiDSRModel.Store.InsertUpdateManagerExecutive" />
    <FunctionImportMapping FunctionImportName="InsertUpdateRole" FunctionName="NikaiDSRModel.Store.InsertUpdateRole" />
    <FunctionImportMapping FunctionImportName="InsertUpdateSiteUser" FunctionName="NikaiDSRModel.Store.InsertUpdateSiteUser" />
    <FunctionImportMapping FunctionImportName="InsertUpdateTarget" FunctionName="NikaiDSRModel.Store.InsertUpdateTarget" />
    <FunctionImportMapping FunctionImportName="sp_alterdiagram" FunctionName="NikaiDSRModel.Store.sp_alterdiagram" />
    <FunctionImportMapping FunctionImportName="sp_creatediagram" FunctionName="NikaiDSRModel.Store.sp_creatediagram" />
    <FunctionImportMapping FunctionImportName="sp_dropdiagram" FunctionName="NikaiDSRModel.Store.sp_dropdiagram" />
    <FunctionImportMapping FunctionImportName="sp_helpdiagramdefinition" FunctionName="NikaiDSRModel.Store.sp_helpdiagramdefinition">
      <ResultMapping>
        <ComplexTypeMapping TypeName="NikaiDSRModel.sp_helpdiagramdefinition_Result">
          <ScalarProperty Name="version" ColumnName="version" />
          <ScalarProperty Name="definition" ColumnName="definition" />
        </ComplexTypeMapping>
      </ResultMapping>
    </FunctionImportMapping>
    <FunctionImportMapping FunctionImportName="sp_helpdiagrams" FunctionName="NikaiDSRModel.Store.sp_helpdiagrams">
      <ResultMapping>
        <ComplexTypeMapping TypeName="NikaiDSRModel.sp_helpdiagrams_Result">
          <ScalarProperty Name="Database" ColumnName="Database" />
          <ScalarProperty Name="Name" ColumnName="Name" />
          <ScalarProperty Name="ID" ColumnName="ID" />
          <ScalarProperty Name="Owner" ColumnName="Owner" />
          <ScalarProperty Name="OwnerID" ColumnName="OwnerID" />
        </ComplexTypeMapping>
      </ResultMapping>
    </FunctionImportMapping>
    <FunctionImportMapping FunctionImportName="sp_renamediagram" FunctionName="NikaiDSRModel.Store.sp_renamediagram" />
    <FunctionImportMapping FunctionImportName="sp_upgraddiagrams" FunctionName="NikaiDSRModel.Store.sp_upgraddiagrams" />
    <FunctionImportMapping FunctionImportName="UpdateLocation" FunctionName="NikaiDSRModel.Store.UpdateLocation" />
    <FunctionImportMapping FunctionImportName="UpdateRegion" FunctionName="NikaiDSRModel.Store.UpdateRegion" />
    <FunctionImportMapping FunctionImportName="InsertUpdateLinkedExecutive" FunctionName="NikaiDSRModel.Store.InsertUpdateLinkedExecutive" />
    <FunctionImportMapping FunctionImportName="GetAttendanceAndDSR" FunctionName="NikaiDSRModel.Store.GetAttendanceAndDSR">
      <ResultMapping>
        <ComplexTypeMapping TypeName="NikaiDSRModel.GetAttendanceAndDSR_Result">
          <ScalarProperty Name="A_Date" ColumnName="A_Date" />
          <ScalarProperty Name="A_Status" ColumnName="A_Status" />
          <ScalarProperty Name="DSR_Status" ColumnName="DSR_Status" />
          <ScalarProperty Name="Site_User_Id" ColumnName="Site_User_Id" />
          <ScalarProperty Name="Name" ColumnName="Name" />
          <ScalarProperty Name="DSR_Id" ColumnName="DSR_Id" />
          <ScalarProperty Name="DSR_Head_Id" ColumnName="DSR_Head_Id" />
        </ComplexTypeMapping>
      </ResultMapping>
    </FunctionImportMapping>
    <EntitySetMapping Name="User_Language">
      <EntityTypeMapping TypeName="NikaiDSRModel.User_Language">
        <MappingFragment StoreEntitySet="User_Language">
          <ScalarProperty Name="Language_Id" ColumnName="Language_Id" />
          <ScalarProperty Name="Site_User_Id" ColumnName="Site_User_Id" />
          <ScalarProperty Name="User_Language_Id" ColumnName="User_Language_Id" />
        </MappingFragment>
      </EntityTypeMapping>
    </EntitySetMapping>
    <FunctionImportMapping FunctionImportName="GetUser" FunctionName="NikaiDSRModel.Store.GetUser">
      <ResultMapping>
        <ComplexTypeMapping TypeName="NikaiDSRModel.GetUser_Result">
          <ScalarProperty Name="Site_User_Id" ColumnName="Site_User_Id" />
          <ScalarProperty Name="Role_Id" ColumnName="Role_Id" />
          <ScalarProperty Name="Location_Id" ColumnName="Location_Id" />
          <ScalarProperty Name="Name" ColumnName="Name" />
          <ScalarProperty Name="Login_Name" ColumnName="Login_Name" />
          <ScalarProperty Name="Password" ColumnName="Password" />
          <ScalarProperty Name="Email" ColumnName="Email" />
          <ScalarProperty Name="Status" ColumnName="Status" />
          <ScalarProperty Name="Employee_Code" ColumnName="Employee_Code" />
          <ScalarProperty Name="Language_Id" ColumnName="Language_Id" />
        </ComplexTypeMapping>
      </ResultMapping>
    </FunctionImportMapping>
    <EntitySetMapping Name="ParameterDets">
      <EntityTypeMapping TypeName="NikaiDSRModel.ParameterDet">
        <MappingFragment StoreEntitySet="ParameterDet">
          <ScalarProperty Name="SortOrder" ColumnName="SortOrder" />
          <ScalarProperty Name="Description_BL" ColumnName="Description_BL" />
          <ScalarProperty Name="Description" ColumnName="Description" />
          <ScalarProperty Name="Code" ColumnName="Code" />
          <ScalarProperty Name="ParameterValue" ColumnName="ParameterValue" />
          <ScalarProperty Name="ParameterId" ColumnName="ParameterId" />
          <ScalarProperty Name="ParameterDetId" ColumnName="ParameterDetId" />
        </MappingFragment>
      </EntityTypeMapping>
    </EntitySetMapping>
    <FunctionImportMapping FunctionImportName="GetParameter" FunctionName="NikaiDSRModel.Store.GetParameter">
      <ResultMapping>
        <ComplexTypeMapping TypeName="NikaiDSRModel.GetParameter_Result">
          <ScalarProperty Name="ParameterDetId" ColumnName="ParameterDetId" />
          <ScalarProperty Name="ParameterId" ColumnName="ParameterId" />
          <ScalarProperty Name="Code" ColumnName="Code" />
          <ScalarProperty Name="ParameterValue" ColumnName="ParameterValue" />
          <ScalarProperty Name="ParameterText" ColumnName="ParameterText" />
          <ScalarProperty Name="Description" ColumnName="Description" />
          <ScalarProperty Name="DescriptionBL" ColumnName="DescriptionBL" />
          <ScalarProperty Name="SortOrder" ColumnName="SortOrder" />
        </ComplexTypeMapping>
      </ResultMapping>
    </FunctionImportMapping>
    <EntitySetMapping Name="Locations">
      <EntityTypeMapping TypeName="NikaiDSRModel.Location">
        <MappingFragment StoreEntitySet="Location">
          <ScalarProperty Name="Region_Id" ColumnName="Region_Id" />
          <ScalarProperty Name="Location_Name_BL" ColumnName="Location_Name_BL" />
          <ScalarProperty Name="Location_Name" ColumnName="Location_Name" />
          <ScalarProperty Name="Location_Id" ColumnName="Location_Id" />
        </MappingFragment>
      </EntityTypeMapping>
    </EntitySetMapping>
    <FunctionImportMapping FunctionImportName="GetLocation" FunctionName="NikaiDSRModel.Store.GetLocation">
      <ResultMapping>
        <ComplexTypeMapping TypeName="NikaiDSRModel.GetLocation_Result">
          <ScalarProperty Name="Location_Id" ColumnName="Location_Id" />
          <ScalarProperty Name="Location_Name" ColumnName="Location_Name" />
          <ScalarProperty Name="Location_Name_BL" ColumnName="Location_Name_BL" />
          <ScalarProperty Name="Region_Id" ColumnName="Region_Id" />
        </ComplexTypeMapping>
      </ResultMapping>
    </FunctionImportMapping>
    <EntitySetMapping Name="Contacts">
      <EntityTypeMapping TypeName="NikaiDSRModel.Contact">
        <MappingFragment StoreEntitySet="Contact">
          <ScalarProperty Name="Status" ColumnName="Status" />
          <ScalarProperty Name="Mobile" ColumnName="Mobile" />
          <ScalarProperty Name="Department_BL" ColumnName="Department_BL" />
          <ScalarProperty Name="Department" ColumnName="Department" />
          <ScalarProperty Name="Customer_Id" ColumnName="Customer_Id" />
          <ScalarProperty Name="Contact_Name_BL" ColumnName="Contact_Name_BL" />
          <ScalarProperty Name="Contact_Name" ColumnName="Contact_Name" />
          <ScalarProperty Name="Contact_Id" ColumnName="Contact_Id" />
        </MappingFragment>
      </EntityTypeMapping>
    </EntitySetMapping>
    <FunctionImportMapping FunctionImportName="GetContact" FunctionName="NikaiDSRModel.Store.GetContact">
      <ResultMapping>
        <ComplexTypeMapping TypeName="NikaiDSRModel.GetContact_Result">
          <ScalarProperty Name="Contact_Id" ColumnName="Contact_Id" />
          <ScalarProperty Name="Contact_Name" ColumnName="Contact_Name" />
          <ScalarProperty Name="Contact_Name_BL" ColumnName="Contact_Name_BL" />
          <ScalarProperty Name="Customer_Id" ColumnName="Customer_Id" />
          <ScalarProperty Name="Department" ColumnName="Department" />
          <ScalarProperty Name="Department_BL" ColumnName="Department_BL" />
          <ScalarProperty Name="Mobile" ColumnName="Mobile" />
          <ScalarProperty Name="Status" ColumnName="Status" />
        </ComplexTypeMapping>
      </ResultMapping>
    </FunctionImportMapping>
    <FunctionImportMapping FunctionImportName="InsertUpdateContact" FunctionName="NikaiDSRModel.Store.InsertUpdateContact" />
    <FunctionImportMapping FunctionImportName="GetActiveDsrContactCustomerLocation" FunctionName="NikaiDSRModel.Store.GetActiveDsrContactCustomerLocation">
      <ResultMapping>
        <ComplexTypeMapping TypeName="NikaiDSRModel.GetActiveDsrContactCustomerLocation_Result">
          <ScalarProperty Name="Site_User_Id" ColumnName="Site_User_Id" />
          <ScalarProperty Name="DSR_Id" ColumnName="DSR_Id" />
          <ScalarProperty Name="Contact_Id" ColumnName="Contact_Id" />
          <ScalarProperty Name="Contact_Name" ColumnName="Contact_Name" />
          <ScalarProperty Name="Date" ColumnName="Date" />
          <ScalarProperty Name="Customer_Id" ColumnName="Customer_Id" />
          <ScalarProperty Name="Contact_Status" ColumnName="Contact_Status" />
          <ScalarProperty Name="Customer_Name" ColumnName="Customer_Name" />
          <ScalarProperty Name="Location_Id" ColumnName="Location_Id" />
          <ScalarProperty Name="Customer_Status" ColumnName="Customer_Status" />
          <ScalarProperty Name="Location_Name" ColumnName="Location_Name" />
          <ScalarProperty Name="Customer_Name_BL" ColumnName="Customer_Name_BL" />
          <ScalarProperty Name="Contact_Name_BL" ColumnName="Contact_Name_BL" />
          <ScalarProperty Name="Updated_By" ColumnName="Updated_By" />
          <ScalarProperty Name="Updated_Date" ColumnName="Updated_Date" />
          <ScalarProperty Name="Location_Name_BL" ColumnName="Location_Name_BL" />
        </ComplexTypeMapping>
      </ResultMapping>
    </FunctionImportMapping>
    <EntitySetMapping Name="DSRReportViews">
      <EntityTypeMapping TypeName="NikaiDSRModel.DSRReportView">
        <MappingFragment StoreEntitySet="DSRReportView">
          <ScalarProperty Name="Status_Customer" ColumnName="Status_Customer" />
          <ScalarProperty Name="Remarks" ColumnName="Remarks" />
          <ScalarProperty Name="Sales_Return" ColumnName="Sales_Return" />
          <ScalarProperty Name="Discount" ColumnName="Discount" />
          <ScalarProperty Name="Sales_LPO_Received" ColumnName="Sales_LPO_Received" />
          <ScalarProperty Name="Secondary_Sales" ColumnName="Secondary_Sales" />
          <ScalarProperty Name="Collection" ColumnName="Collection" />
          <ScalarProperty Name="Time_w_Merchandiser" ColumnName="Time_w_Merchandiser" />
          <ScalarProperty Name="Time_Spent" ColumnName="Time_Spent" />
          <ScalarProperty Name="Time_Out" ColumnName="Time_Out" />
          <ScalarProperty Name="Time_In" ColumnName="Time_In" />
          <ScalarProperty Name="Objective" ColumnName="Objective" />
          <ScalarProperty Name="Status_Contact" ColumnName="Status_Contact" />
          <ScalarProperty Name="Mobile" ColumnName="Mobile" />
          <ScalarProperty Name="Department" ColumnName="Department" />
          <ScalarProperty Name="Department_BL" ColumnName="Department_BL" />
          <ScalarProperty Name="Contact_Name_BL" ColumnName="Contact_Name_BL" />
          <ScalarProperty Name="Contact_Name" ColumnName="Contact_Name" />
          <ScalarProperty Name="Contact_Id" ColumnName="Contact_Id" />
          <ScalarProperty Name="Customer_Name_BL" ColumnName="Customer_Name_BL" />
          <ScalarProperty Name="Customer_Name" ColumnName="Customer_Name" />
          <ScalarProperty Name="Customer_Code" ColumnName="Customer_Code" />
          <ScalarProperty Name="Customer_Id" ColumnName="Customer_Id" />
          <ScalarProperty Name="Date" ColumnName="Date" />
          <ScalarProperty Name="Site_User_Id" ColumnName="Site_User_Id" />
        </MappingFragment>
      </EntityTypeMapping>
    </EntitySetMapping>
    <FunctionImportMapping FunctionImportName="GetExecutiveTargetsActuals" FunctionName="NikaiDSRModel.Store.GetExecutiveTargetsActuals">
      <ResultMapping>
        <ComplexTypeMapping TypeName="NikaiDSRModel.GetExecutiveTargetsActuals_Result">
          <ScalarProperty Name="Collection_Actual" ColumnName="Collection_Actual" />
          <ScalarProperty Name="Collection_Target" ColumnName="Collection_Target" />
          <ScalarProperty Name="Lpo_Actual" ColumnName="Lpo_Actual" />
          <ScalarProperty Name="Lpo_Target" ColumnName="Lpo_Target" />
          <ScalarProperty Name="Secondary_Sales_Actual" ColumnName="Secondary_Sales_Actual" />
          <ScalarProperty Name="Secondary_Sales_Target" ColumnName="Secondary_Sales_Target" />
        </ComplexTypeMapping>
      </ResultMapping>
    </FunctionImportMapping>
    <FunctionImportMapping FunctionImportName="GetManagerReport" FunctionName="NikaiDSRModel.Store.GetManagerReport">
      <ResultMapping>
        <ComplexTypeMapping TypeName="NikaiDSRModel.GetManagerReport_Result">
          <ScalarProperty Name="Date" ColumnName="Date" />
          <ScalarProperty Name="Executive_Id" ColumnName="Executive_Id" />
          <ScalarProperty Name="Executive_Name" ColumnName="Executive_Name" />
          <ScalarProperty Name="Executive_Count" ColumnName="Executive_Count" />
          <ScalarProperty Name="Present" ColumnName="Present" />
          <ScalarProperty Name="DSR_Submitted" ColumnName="DSR_Submitted" />
          <ScalarProperty Name="DSR_NotSubmittedBy" ColumnName="DSR_NotSubmittedBy" />
          <ScalarProperty Name="Total_Customer_Visited" ColumnName="Total_Customer_Visited" />
          <ScalarProperty Name="Sales" ColumnName="Sales" />
          <ScalarProperty Name="Secondary_Sales" ColumnName="Secondary_Sales" />
          <ScalarProperty Name="Collection" ColumnName="Collection" />
          <ScalarProperty Name="Discount" ColumnName="Discount" />
          <ScalarProperty Name="Sales_Return" ColumnName="Sales_Return" />
          <ScalarProperty Name="Time_Customer" ColumnName="Time_Customer" />
          <ScalarProperty Name="Time_Merchandiser" ColumnName="Time_Merchandiser" />
          <ScalarProperty Name="Time_In_Office" ColumnName="Time_In_Office" />
        </ComplexTypeMapping>
      </ResultMapping>
    </FunctionImportMapping>
    <FunctionImportMapping FunctionImportName="GetManagerExecutive" FunctionName="NikaiDSRModel.Store.GetManagerExecutive">
      <ResultMapping>
        <ComplexTypeMapping TypeName="NikaiDSRModel.GetManagerExecutive_Result">
          <ScalarProperty Name="Manager_Exec_Id" ColumnName="Manager_Exec_Id" />
          <ScalarProperty Name="Executive_Id" ColumnName="Executive_Id" />
          <ScalarProperty Name="Manager_Id" ColumnName="Manager_Id" />
          <ScalarProperty Name="Name" ColumnName="Name" />
        </ComplexTypeMapping>
      </ResultMapping>
    </FunctionImportMapping>
    <FunctionImportMapping FunctionImportName="GetActiveCustomerLocationRegionCountry" FunctionName="NikaiDSRModel.Store.GetActiveCustomerLocationRegionCountry">
      <ResultMapping>
        <ComplexTypeMapping TypeName="NikaiDSRModel.GetActiveCustomerLocationRegionCountry_Result">
          <ScalarProperty Name="Customer_Id" ColumnName="Customer_Id" />
          <ScalarProperty Name="Customer_Name" ColumnName="Customer_Name" />
          <ScalarProperty Name="Key_Account" ColumnName="Key_Account" />
          <ScalarProperty Name="Customer_Status" ColumnName="Customer_Status" />
          <ScalarProperty Name="Location_Id" ColumnName="Location_Id" />
          <ScalarProperty Name="Location_Name" ColumnName="Location_Name" />
          <ScalarProperty Name="Site_User_Id" ColumnName="Site_User_Id" />
          <ScalarProperty Name="Customer_Name_BL" ColumnName="Customer_Name_BL" />
          <ScalarProperty Name="Updated_By" ColumnName="Updated_By" />
          <ScalarProperty Name="Updated_Date" ColumnName="Updated_Date" />
          <ScalarProperty Name="Customer_Code" ColumnName="Customer_Code" />
          <ScalarProperty Name="Business_Type" ColumnName="Business_Type" />
          <ScalarProperty Name="Customer_Type" ColumnName="Customer_Type" />
          <ScalarProperty Name="Customer_Group" ColumnName="Customer_Group" />
          <ScalarProperty Name="Country_Name" ColumnName="Country_Name" />
          <ScalarProperty Name="Region_Name" ColumnName="Region_Name" />
          <ScalarProperty Name="Updated_By_Value" ColumnName="Updated_By_Value" />
          <ScalarProperty Name="Business_Type_Value" ColumnName="Business_Type_Value" />
          <ScalarProperty Name="Customer_Type_Value" ColumnName="Customer_Type_Value" />
          <ScalarProperty Name="Customer_Group_Value" ColumnName="Customer_Group_Value" />
        </ComplexTypeMapping>
      </ResultMapping>
    </FunctionImportMapping>
    <FunctionImportMapping FunctionImportName="GetContactWithCustName" FunctionName="NikaiDSRModel.Store.GetContactWithCustName">
      <ResultMapping>
        <ComplexTypeMapping TypeName="NikaiDSRModel.GetContactWithCustName_Result">
          <ScalarProperty Name="Contact_Id" ColumnName="Contact_Id" />
          <ScalarProperty Name="Contact_Name" ColumnName="Contact_Name" />
          <ScalarProperty Name="Contact_Name_BL" ColumnName="Contact_Name_BL" />
          <ScalarProperty Name="Customer_Id" ColumnName="Customer_Id" />
          <ScalarProperty Name="Department" ColumnName="Department" />
          <ScalarProperty Name="Department_BL" ColumnName="Department_BL" />
          <ScalarProperty Name="Mobile" ColumnName="Mobile" />
          <ScalarProperty Name="Status" ColumnName="Status" />
          <ScalarProperty Name="Customer_Name" ColumnName="Customer_Name" />
          <ScalarProperty Name="Customer_Name_BL" ColumnName="Customer_Name_BL" />
        </ComplexTypeMapping>
      </ResultMapping>
    </FunctionImportMapping>
    <FunctionImportMapping FunctionImportName="InsertVisit" FunctionName="NikaiDSRModel.Store.InsertVisit" />
    <FunctionImportMapping FunctionImportName="GetDSR" FunctionName="NikaiDSRModel.Store.GetDSR">
      <ResultMapping>
        <ComplexTypeMapping TypeName="NikaiDSRModel.GetDSR_Result">
          <ScalarProperty Name="DSR_Id" ColumnName="DSR_Id" />
          <ScalarProperty Name="Site_User_Id" ColumnName="Site_User_Id" />
          <ScalarProperty Name="Date" ColumnName="Date" />
          <ScalarProperty Name="Contact_Id" ColumnName="Contact_Id" />
          <ScalarProperty Name="Objective" ColumnName="Objective" />
          <ScalarProperty Name="Time_In" ColumnName="Time_In" />
          <ScalarProperty Name="Time_Out" ColumnName="Time_Out" />
          <ScalarProperty Name="Time_Spent" ColumnName="Time_Spent" />
          <ScalarProperty Name="Time_w_Merchandiser" ColumnName="Time_w_Merchandiser" />
          <ScalarProperty Name="Collection" ColumnName="Collection" />
          <ScalarProperty Name="Secondary_Sales" ColumnName="Secondary_Sales" />
          <ScalarProperty Name="Sales_LPO_Received" ColumnName="Sales_LPO_Received" />
          <ScalarProperty Name="Discount" ColumnName="Discount" />
          <ScalarProperty Name="Sales_Return" ColumnName="Sales_Return" />
          <ScalarProperty Name="Remarks" ColumnName="Remarks" />
        </ComplexTypeMapping>
      </ResultMapping>
    </FunctionImportMapping>
    <EntitySetMapping Name="ActiveContactCustomerLocationViews">
      <EntityTypeMapping TypeName="NikaiDSRModel.ActiveContactCustomerLocationView">
        <MappingFragment StoreEntitySet="ActiveContactCustomerLocationView">
          <ScalarProperty Name="Mobile" ColumnName="Mobile" />
          <ScalarProperty Name="Department_BL" ColumnName="Department_BL" />
          <ScalarProperty Name="Customer_Group" ColumnName="Customer_Group" />
          <ScalarProperty Name="Customer_Type" ColumnName="Customer_Type" />
          <ScalarProperty Name="Business_Type" ColumnName="Business_Type" />
          <ScalarProperty Name="Customer_Code" ColumnName="Customer_Code" />
          <ScalarProperty Name="Updated_Date" ColumnName="Updated_Date" />
          <ScalarProperty Name="Updated_By" ColumnName="Updated_By" />
          <ScalarProperty Name="Contact_Name_BL" ColumnName="Contact_Name_BL" />
          <ScalarProperty Name="Customer_Name_BL" ColumnName="Customer_Name_BL" />
          <ScalarProperty Name="Site_User_Id" ColumnName="Site_User_Id" />
          <ScalarProperty Name="Location_Name" ColumnName="Location_Name" />
          <ScalarProperty Name="Location_Id" ColumnName="Location_Id" />
          <ScalarProperty Name="Customer_Status" ColumnName="Customer_Status" />
          <ScalarProperty Name="Key_Account" ColumnName="Key_Account" />
          <ScalarProperty Name="Customer_Name" ColumnName="Customer_Name" />
          <ScalarProperty Name="Customer_Id" ColumnName="Customer_Id" />
          <ScalarProperty Name="Contact_Status" ColumnName="Contact_Status" />
          <ScalarProperty Name="Department" ColumnName="Department" />
          <ScalarProperty Name="Contact_Name" ColumnName="Contact_Name" />
          <ScalarProperty Name="Contact_Id" ColumnName="Contact_Id" />
        </MappingFragment>
      </EntityTypeMapping>
    </EntitySetMapping>
    <EntitySetMapping Name="ActiveCustomerLocationRegionCountryViews">
      <EntityTypeMapping TypeName="NikaiDSRModel.ActiveCustomerLocationRegionCountryView">
        <MappingFragment StoreEntitySet="ActiveCustomerLocationRegionCountryView">
          <ScalarProperty Name="Region_Name" ColumnName="Region_Name" />
          <ScalarProperty Name="Country_Name" ColumnName="Country_Name" />
          <ScalarProperty Name="Customer_Group" ColumnName="Customer_Group" />
          <ScalarProperty Name="Customer_Type" ColumnName="Customer_Type" />
          <ScalarProperty Name="Business_Type" ColumnName="Business_Type" />
          <ScalarProperty Name="Customer_Code" ColumnName="Customer_Code" />
          <ScalarProperty Name="Updated_Date" ColumnName="Updated_Date" />
          <ScalarProperty Name="Updated_By" ColumnName="Updated_By" />
          <ScalarProperty Name="Customer_Name_BL" ColumnName="Customer_Name_BL" />
          <ScalarProperty Name="Location_Name" ColumnName="Location_Name" />
          <ScalarProperty Name="Location_Id" ColumnName="Location_Id" />
          <ScalarProperty Name="Customer_Status" ColumnName="Customer_Status" />
          <ScalarProperty Name="Key_Account" ColumnName="Key_Account" />
          <ScalarProperty Name="Customer_Name" ColumnName="Customer_Name" />
          <ScalarProperty Name="Customer_Id" ColumnName="Customer_Id" />
        </MappingFragment>
      </EntityTypeMapping>
    </EntitySetMapping>
    <EntitySetMapping Name="DsrContactCustomerLocationViews">
      <EntityTypeMapping TypeName="NikaiDSRModel.DsrContactCustomerLocationView">
        <MappingFragment StoreEntitySet="DsrContactCustomerLocationView">
          <ScalarProperty Name="Location_Name_BL" ColumnName="Location_Name_BL" />
          <ScalarProperty Name="Updated_Date" ColumnName="Updated_Date" />
          <ScalarProperty Name="Updated_By" ColumnName="Updated_By" />
          <ScalarProperty Name="Contact_Name_BL" ColumnName="Contact_Name_BL" />
          <ScalarProperty Name="Customer_Name_BL" ColumnName="Customer_Name_BL" />
          <ScalarProperty Name="Location_Name" ColumnName="Location_Name" />
          <ScalarProperty Name="Customer_Status" ColumnName="Customer_Status" />
          <ScalarProperty Name="Location_Id" ColumnName="Location_Id" />
          <ScalarProperty Name="Customer_Name" ColumnName="Customer_Name" />
          <ScalarProperty Name="Contact_Status" ColumnName="Contact_Status" />
          <ScalarProperty Name="Customer_Id" ColumnName="Customer_Id" />
          <ScalarProperty Name="Date" ColumnName="Date" />
          <ScalarProperty Name="Contact_Name" ColumnName="Contact_Name" />
          <ScalarProperty Name="Contact_Id" ColumnName="Contact_Id" />
          <ScalarProperty Name="DSR_Id" ColumnName="DSR_Id" />
          <ScalarProperty Name="Site_User_Id" ColumnName="Site_User_Id" />
        </MappingFragment>
      </EntityTypeMapping>
    </EntitySetMapping>
    <FunctionImportMapping FunctionImportName="GetActiveContactCustomerLocation" FunctionName="NikaiDSRModel.Store.GetActiveContactCustomerLocation">
      <ResultMapping>
        <ComplexTypeMapping TypeName="NikaiDSRModel.GetActiveContactCustomerLocation_Result">
          <ScalarProperty Name="Contact_Id" ColumnName="Contact_Id" />
          <ScalarProperty Name="Contact_Name" ColumnName="Contact_Name" />
          <ScalarProperty Name="Department" ColumnName="Department" />
          <ScalarProperty Name="Contact_Status" ColumnName="Contact_Status" />
          <ScalarProperty Name="Customer_Id" ColumnName="Customer_Id" />
          <ScalarProperty Name="Customer_Name" ColumnName="Customer_Name" />
          <ScalarProperty Name="Key_Account" ColumnName="Key_Account" />
          <ScalarProperty Name="Customer_Status" ColumnName="Customer_Status" />
          <ScalarProperty Name="Location_Id" ColumnName="Location_Id" />
          <ScalarProperty Name="Location_Name" ColumnName="Location_Name" />
          <ScalarProperty Name="Site_User_Id" ColumnName="Site_User_Id" />
          <ScalarProperty Name="Customer_Name_BL" ColumnName="Customer_Name_BL" />
          <ScalarProperty Name="Contact_Name_BL" ColumnName="Contact_Name_BL" />
          <ScalarProperty Name="Updated_By" ColumnName="Updated_By" />
          <ScalarProperty Name="Updated_Date" ColumnName="Updated_Date" />
          <ScalarProperty Name="Customer_Code" ColumnName="Customer_Code" />
          <ScalarProperty Name="Business_Type" ColumnName="Business_Type" />
          <ScalarProperty Name="Customer_Type" ColumnName="Customer_Type" />
          <ScalarProperty Name="Customer_Group" ColumnName="Customer_Group" />
          <ScalarProperty Name="Department_BL" ColumnName="Department_BL" />
          <ScalarProperty Name="Mobile" ColumnName="Mobile" />
        </ComplexTypeMapping>
      </ResultMapping>
    </FunctionImportMapping>
    <FunctionImportMapping FunctionImportName="UpdateVisit" FunctionName="NikaiDSRModel.Store.UpdateVisit" />
    <FunctionImportMapping FunctionImportName="GetExecutiveReport" FunctionName="NikaiDSRModel.Store.GetExecutiveReport">
      <ResultMapping>
        <ComplexTypeMapping TypeName="NikaiDSRModel.GetExecutiveReport_Result">
          <ScalarProperty Name="Site_User_Id" ColumnName="Site_User_Id" />
          <ScalarProperty Name="Date" ColumnName="Date" />
          <ScalarProperty Name="Customer_Id" ColumnName="Customer_Id" />
          <ScalarProperty Name="Customer_Code" ColumnName="Customer_Code" />
          <ScalarProperty Name="Customer_Name" ColumnName="Customer_Name" />
          <ScalarProperty Name="Customer_Name_BL" ColumnName="Customer_Name_BL" />
          <ScalarProperty Name="Contact_Id" ColumnName="Contact_Id" />
          <ScalarProperty Name="Contact_Name" ColumnName="Contact_Name" />
          <ScalarProperty Name="Contact_Name_BL" ColumnName="Contact_Name_BL" />
          <ScalarProperty Name="Department_BL" ColumnName="Department_BL" />
          <ScalarProperty Name="Department" ColumnName="Department" />
          <ScalarProperty Name="Mobile" ColumnName="Mobile" />
          <ScalarProperty Name="Status_Contact" ColumnName="Status_Contact" />
          <ScalarProperty Name="Objective" ColumnName="Objective" />
          <ScalarProperty Name="Time_In" ColumnName="Time_In" />
          <ScalarProperty Name="Time_Out" ColumnName="Time_Out" />
          <ScalarProperty Name="Time_Spent" ColumnName="Time_Spent" />
          <ScalarProperty Name="Time_w_Merchandiser" ColumnName="Time_w_Merchandiser" />
          <ScalarProperty Name="Collection" ColumnName="Collection" />
          <ScalarProperty Name="Secondary_Sales" ColumnName="Secondary_Sales" />
          <ScalarProperty Name="Sales_LPO_Received" ColumnName="Sales_LPO_Received" />
          <ScalarProperty Name="Discount" ColumnName="Discount" />
          <ScalarProperty Name="Sales_Return" ColumnName="Sales_Return" />
          <ScalarProperty Name="Remarks" ColumnName="Remarks" />
          <ScalarProperty Name="Status_Customer" ColumnName="Status_Customer" />
          <ScalarProperty Name="ParameterDetId" ColumnName="ParameterDetId" />
          <ScalarProperty Name="ParameterId" ColumnName="ParameterId" />
          <ScalarProperty Name="ParameterValue" ColumnName="ParameterValue" />
          <ScalarProperty Name="Code" ColumnName="Code" />
          <ScalarProperty Name="Description" ColumnName="Description" />
          <ScalarProperty Name="Description_BL" ColumnName="Description_BL" />
          <ScalarProperty Name="SortOrder" ColumnName="SortOrder" />
          <ScalarProperty Name="ObjectiveValue" ColumnName="ObjectiveValue" />
        </ComplexTypeMapping>
      </ResultMapping>
    </FunctionImportMapping>
    <FunctionImportMapping FunctionImportName="GetReporteesForUserCreation" FunctionName="NikaiDSRModel.Store.GetReporteesForUserCreation">
      <ResultMapping>
        <ComplexTypeMapping TypeName="NikaiDSRModel.GetReporteesForUserCreation_Result">
          <ScalarProperty Name="Site_User_Id" ColumnName="Site_User_Id" />
          <ScalarProperty Name="Name" ColumnName="Name" />
          <ScalarProperty Name="Email" ColumnName="Email" />
          <ScalarProperty Name="Status" ColumnName="Status" />
          <ScalarProperty Name="Role_Id" ColumnName="Role_Id" />
          <ScalarProperty Name="Role_Name" ColumnName="Role_Name" />
          <ScalarProperty Name="Location_Id" ColumnName="Location_Id" />
          <ScalarProperty Name="Location_Name" ColumnName="Location_Name" />
          <ScalarProperty Name="Region_Id" ColumnName="Region_Id" />
          <ScalarProperty Name="Region_Name" ColumnName="Region_Name" />
          <ScalarProperty Name="Country_Id" ColumnName="Country_Id" />
          <ScalarProperty Name="Country_Name" ColumnName="Country_Name" />
        </ComplexTypeMapping>
      </ResultMapping>
    </FunctionImportMapping>
    <FunctionImportMapping FunctionImportName="InsertUpdateUser" FunctionName="NikaiDSRModel.Store.InsertUpdateUser" />
    <FunctionImportMapping FunctionImportName="GetCustomer" FunctionName="NikaiDSRModel.Store.GetCustomer">
      <ResultMapping>
        <ComplexTypeMapping TypeName="NikaiDSRModel.GetCustomer_Result">
          <ScalarProperty Name="Customer_Id" ColumnName="Customer_Id" />
          <ScalarProperty Name="Customer_Code" ColumnName="Customer_Code" />
          <ScalarProperty Name="Customer_Name" ColumnName="Customer_Name" />
          <ScalarProperty Name="Customer_Name_BL" ColumnName="Customer_Name_BL" />
          <ScalarProperty Name="Business_Type" ColumnName="Business_Type" />
          <ScalarProperty Name="Customer_Type" ColumnName="Customer_Type" />
          <ScalarProperty Name="Customer_Group" ColumnName="Customer_Group" />
          <ScalarProperty Name="Location_Id" ColumnName="Location_Id" />
          <ScalarProperty Name="Key_Account" ColumnName="Key_Account" />
          <ScalarProperty Name="Status" ColumnName="Status" />
          <ScalarProperty Name="Updated_By" ColumnName="Updated_By" />
          <ScalarProperty Name="Updated_Date" ColumnName="Updated_Date" />
          <ScalarProperty Name="Sales_Channel" ColumnName="Sales_Channel" />
        </ComplexTypeMapping>
      </ResultMapping>
    </FunctionImportMapping>
    <FunctionImportMapping FunctionImportName="InsertUpdateCustomer" FunctionName="NikaiDSRModel.Store.InsertUpdateCustomer" />
  </EntityContainerMapping>
</Mapping>