<?xml version="1.0" encoding="utf-8"?>
<edmx:Edmx Version="4.0" xmlns:edmx="http://docs.oasis-open.org/odata/ns/edmx">
  <edmx:Reference Uri="https://sap.github.io/odata-vocabularies/vocabularies/Common.xml">
    <edmx:Include Alias="Common" Namespace="com.sap.vocabularies.Common.v1"/>
  </edmx:Reference>
  <edmx:Reference Uri="https://oasis-tcs.github.io/odata-vocabularies/vocabularies/Org.OData.Core.V1.xml">
    <edmx:Include Alias="Core" Namespace="Org.OData.Core.V1"/>
  </edmx:Reference>
  <edmx:DataServices>
    <Schema Namespace="ReportsService" xmlns="http://docs.oasis-open.org/odata/ns/edm">
      <EntityContainer Name="EntityContainer">
        <EntitySet Name="ExpenseRecordEntries" EntityType="ReportsService.ExpenseRecordEntries">
          <NavigationPropertyBinding Path="userId" Target="Users"/>
          <NavigationPropertyBinding Path="approverId" Target="Users"/>
          <NavigationPropertyBinding Path="policy" Target="Policies"/>
          <NavigationPropertyBinding Path="travelRequestEntries" Target="TravelRequestEntries"/>
          <NavigationPropertyBinding Path="expenses" Target="ExpenseRecordExpenses"/>
        </EntitySet>
        <EntitySet Name="ExpenseRecordExpenses" EntityType="ReportsService.ExpenseRecordExpenses">
          <NavigationPropertyBinding Path="expenseRecordExpenses" Target="ExpenseRecordEntries"/>
          <NavigationPropertyBinding Path="expenseType" Target="ExpenseTypes"/>
        </EntitySet>
        <EntitySet Name="TravelRequestEntries" EntityType="ReportsService.TravelRequestEntries">
          <NavigationPropertyBinding Path="userId" Target="Users"/>
          <NavigationPropertyBinding Path="approverId" Target="Users"/>
          <NavigationPropertyBinding Path="policy" Target="Policies"/>
          <NavigationPropertyBinding Path="travelRequestExpenses" Target="TravelRequestExpenses"/>
        </EntitySet>
        <EntitySet Name="TravelRequestExpenses" EntityType="ReportsService.TravelRequestExpenses">
          <NavigationPropertyBinding Path="travelRequestEntries" Target="TravelRequestEntries"/>
          <NavigationPropertyBinding Path="expenseType" Target="SegmentTypes"/>
          <NavigationPropertyBinding Path="assigned_tmc" Target="Users"/>
          <NavigationPropertyBinding Path="assigned_ca_admin" Target="Users"/>
        </EntitySet>
        <EntitySet Name="EmployeeApproverMappings" EntityType="ReportsService.EmployeeApproverMappings">
          <NavigationPropertyBinding Path="employeeId" Target="Users"/>
          <NavigationPropertyBinding Path="approverId" Target="Users"/>
        </EntitySet>
        <EntitySet Name="ExpenseEmployeeApproverMappings" EntityType="ReportsService.ExpenseEmployeeApproverMappings">
          <NavigationPropertyBinding Path="user" Target="Users"/>
          <NavigationPropertyBinding Path="policy" Target="ExpensePolicies"/>
          <NavigationPropertyBinding Path="approver" Target="Users"/>
        </EntitySet>
        <EntitySet Name="Policies" EntityType="ReportsService.Policies"/>
        <EntitySet Name="ExpensePolicies" EntityType="ReportsService.ExpensePolicies"/>
        <EntitySet Name="Users" EntityType="ReportsService.Users">
          <NavigationPropertyBinding Path="costCenterId" Target="CostCenters"/>
          <NavigationPropertyBinding Path="ledgerId" Target="AccountingLedgers"/>
          <NavigationPropertyBinding Path="currencyId" Target="Currencies"/>
          <NavigationPropertyBinding Path="dependents" Target="UserDependents"/>
        </EntitySet>
        <EntitySet Name="UserRoleMappings" EntityType="ReportsService.UserRoleMappings"/>
        <EntitySet Name="Roles" EntityType="ReportsService.Roles"/>
        <EntitySet Name="PolicyRules" EntityType="ReportsService.PolicyRules">
          <NavigationPropertyBinding Path="applicability" Target="Applicability"/>
        </EntitySet>
        <EntitySet Name="PolicyRulePolicies" EntityType="ReportsService.PolicyRulePolicies">
          <NavigationPropertyBinding Path="policy_id" Target="Policies"/>
          <NavigationPropertyBinding Path="rule_id" Target="PolicyRules"/>
        </EntitySet>
        <EntitySet Name="Applicability" EntityType="ReportsService.Applicability"/>
        <EntitySet Name="PolicyConditions" EntityType="ReportsService.PolicyConditions"/>
        <EntitySet Name="RequestGroupPolicyMapping" EntityType="ReportsService.RequestGroupPolicyMapping">
          <NavigationPropertyBinding Path="policy" Target="Policies"/>
        </EntitySet>
        <EntitySet Name="ExpenseGroupPolicyMapping" EntityType="ReportsService.ExpenseGroupPolicyMapping">
          <NavigationPropertyBinding Path="policy" Target="Policies"/>
        </EntitySet>
        <EntitySet Name="AuditRules" EntityType="ReportsService.AuditRules">
          <NavigationPropertyBinding Path="policies" Target="Policies"/>
        </EntitySet>
        <EntitySet Name="AuditConditions" EntityType="ReportsService.AuditConditions">
          <NavigationPropertyBinding Path="audit_rule" Target="AuditRules"/>
        </EntitySet>
        <EntitySet Name="WorkflowStep" EntityType="ReportsService.WorkflowStep">
          <NavigationPropertyBinding Path="escalation_rule" Target="PolicyRules"/>
        </EntitySet>
        <EntitySet Name="ExpenseRecordWorkflow" EntityType="ReportsService.ExpenseRecordWorkflow">
          <NavigationPropertyBinding Path="expenseRecord" Target="ExpenseRecordEntries"/>
          <NavigationPropertyBinding Path="employee" Target="Users"/>
          <NavigationPropertyBinding Path="policy" Target="ExpensePolicies"/>
          <NavigationPropertyBinding Path="approver" Target="Users"/>
        </EntitySet>
        <EntitySet Name="ExpenseRecordFields" EntityType="ReportsService.ExpenseRecordFields"/>
        <EntitySet Name="ExpenseTypes" EntityType="ReportsService.ExpenseTypes"/>
        <EntitySet Name="ExpenseTypesExpense" EntityType="ReportsService.ExpenseTypesExpense"/>
        <EntitySet Name="SegmentTypes" EntityType="ReportsService.SegmentTypes"/>
        <EntitySet Name="PerDayAllowance" EntityType="ReportsService.PerDayAllowance">
          <NavigationPropertyBinding Path="policy" Target="ExpensePolicies"/>
        </EntitySet>
        <EntitySet Name="FuelAllowance" EntityType="ReportsService.FuelAllowance">
          <NavigationPropertyBinding Path="policy" Target="ExpensePolicies"/>
          <NavigationPropertyBinding Path="currency" Target="Currencies"/>
        </EntitySet>
        <EntitySet Name="Cities" EntityType="ReportsService.Cities"/>
        <EntitySet Name="AllCities" EntityType="ReportsService.AllCities"/>
        <EntitySet Name="AccountingLedgers" EntityType="ReportsService.AccountingLedgers"/>
        <EntitySet Name="CostCenters" EntityType="ReportsService.CostCenters"/>
        <EntitySet Name="GLCodeMappings" EntityType="ReportsService.GLCodeMappings">
          <NavigationPropertyBinding Path="ledger" Target="AccountingLedgers"/>
          <NavigationPropertyBinding Path="policy" Target="Policies"/>
          <NavigationPropertyBinding Path="expenseType" Target="ExpenseTypes"/>
        </EntitySet>
        <EntitySet Name="Currencies" EntityType="ReportsService.Currencies"/>
        <EntitySet Name="UserDependents" EntityType="ReportsService.UserDependents">
          <NavigationPropertyBinding Path="user" Target="Users"/>
        </EntitySet>
        <ActionImport Name="ExpenseRecordExport" Action="ReportsService.ExpenseRecordExport"/>
        <ActionImport Name="sendExpenseDataToSap" Action="ReportsService.sendExpenseDataToSap"/>
        <ActionImport Name="CashAdvanceExport" Action="ReportsService.CashAdvanceExport"/>
        <ActionImport Name="resetSapTrackingFlags" Action="ReportsService.resetSapTrackingFlags"/>
      </EntityContainer>
      <EntityType Name="ExpenseRecordEntries">
        <Key>
          <PropertyRef Name="ID"/>
        </Key>
        <Property Name="ID" Type="Edm.Guid" Nullable="false"/>
        <Property Name="name" Type="Edm.String" MaxLength="100"/>
        <Property Name="reject_comments" Type="Edm.String"/>
        <Property Name="reply_comments" Type="Edm.String"/>
        <Property Name="details" Type="Edm.String"/>
        <Property Name="status" Type="Edm.String" MaxLength="50" DefaultValue="Pending"/>
        <Property Name="created_at" Type="Edm.DateTimeOffset" Precision="7"/>
        <Property Name="updated_at" Type="Edm.DateTimeOffset" Precision="7"/>
        <NavigationProperty Name="userId" Type="ReportsService.Users">
          <ReferentialConstraint Property="userId_ID" ReferencedProperty="ID"/>
        </NavigationProperty>
        <Property Name="userId_ID" Type="Edm.Guid"/>
        <NavigationProperty Name="approverId" Type="ReportsService.Users">
          <ReferentialConstraint Property="approverId_ID" ReferencedProperty="ID"/>
        </NavigationProperty>
        <Property Name="approverId_ID" Type="Edm.Guid"/>
        <NavigationProperty Name="policy" Type="ReportsService.Policies">
          <ReferentialConstraint Property="policy_ID" ReferencedProperty="ID"/>
        </NavigationProperty>
        <Property Name="policy_ID" Type="Edm.Guid"/>
        <Property Name="warnings" Type="Edm.String" MaxLength="1000"/>
        <Property Name="isEscalated" Type="Edm.Boolean"/>
        <NavigationProperty Name="travelRequestEntries" Type="ReportsService.TravelRequestEntries">
          <ReferentialConstraint Property="travelRequestEntries_ID" ReferencedProperty="ID"/>
        </NavigationProperty>
        <Property Name="travelRequestEntries_ID" Type="Edm.Guid"/>
        <Property Name="sap_sent" Type="Edm.Boolean" DefaultValue="false"/>
        <Property Name="sap_sent_date" Type="Edm.DateTimeOffset" Precision="7"/>
        <Property Name="sap_batch_id" Type="Edm.String" MaxLength="100"/>
        <NavigationProperty Name="expenses" Type="Collection(ReportsService.ExpenseRecordExpenses)" Partner="expenseRecordExpenses">
          <OnDelete Action="Cascade"/>
        </NavigationProperty>
        <Property Name="downloaded" Type="Edm.Boolean" DefaultValue="false"/>
        <Property Name="downloaded_at" Type="Edm.DateTimeOffset"/>
      </EntityType>
      <EntityType Name="ExpenseRecordExpenses">
        <Key>
          <PropertyRef Name="ID"/>
        </Key>
        <Property Name="ID" Type="Edm.Guid" Nullable="false"/>
        <NavigationProperty Name="expenseRecordExpenses" Type="ReportsService.ExpenseRecordEntries" Partner="expenses">
          <ReferentialConstraint Property="expenseRecordExpenses_ID" ReferencedProperty="ID"/>
        </NavigationProperty>
        <Property Name="expenseRecordExpenses_ID" Type="Edm.Guid"/>
        <NavigationProperty Name="expenseType" Type="ReportsService.ExpenseTypes">
          <ReferentialConstraint Property="expenseType_ID" ReferencedProperty="ID"/>
        </NavigationProperty>
        <Property Name="expenseType_ID" Type="Edm.Guid"/>
        <Property Name="estimated_amount" Type="Edm.Decimal" Precision="15" Scale="2"/>
        <Property Name="actual_amount" Type="Edm.Decimal" Precision="15" Scale="2"/>
        <Property Name="details" Type="Edm.String"/>
        <Property Name="comments" Type="Edm.String" MaxLength="500"/>
        <Property Name="created_at" Type="Edm.DateTimeOffset" Precision="7"/>
        <Property Name="updated_at" Type="Edm.DateTimeOffset" Precision="7"/>
        <Property Name="file_path" Type="Edm.String" MaxLength="2000"/>
        <Property Name="Itemization" Type="Edm.String"/>
      </EntityType>
      <EntityType Name="TravelRequestEntries">
        <Key>
          <PropertyRef Name="ID"/>
        </Key>
        <Property Name="ID" Type="Edm.Guid" Nullable="false"/>
        <Property Name="name" Type="Edm.String" MaxLength="100"/>
        <Property Name="reply_comments" Type="Edm.String"/>
        <Property Name="reject_comments" Type="Edm.String"/>
        <Property Name="comments" Type="Edm.String"/>
        <Property Name="details" Type="Edm.String"/>
        <Property Name="status" Type="Edm.String" MaxLength="50" DefaultValue="Pending"/>
        <Property Name="created_at" Type="Edm.DateTimeOffset" Precision="7"/>
        <Property Name="updated_at" Type="Edm.DateTimeOffset" Precision="7"/>
        <NavigationProperty Name="userId" Type="ReportsService.Users">
          <ReferentialConstraint Property="userId_ID" ReferencedProperty="ID"/>
        </NavigationProperty>
        <Property Name="userId_ID" Type="Edm.Guid"/>
        <NavigationProperty Name="approverId" Type="ReportsService.Users">
          <ReferentialConstraint Property="approverId_ID" ReferencedProperty="ID"/>
        </NavigationProperty>
        <Property Name="approverId_ID" Type="Edm.Guid"/>
        <NavigationProperty Name="policy" Type="ReportsService.Policies">
          <ReferentialConstraint Property="policy_ID" ReferencedProperty="ID"/>
        </NavigationProperty>
        <Property Name="policy_ID" Type="Edm.Guid"/>
        <Property Name="warnings" Type="Edm.String" MaxLength="1000"/>
        <Property Name="isEscalated" Type="Edm.Boolean"/>
        <Property Name="file_path" Type="Edm.String" MaxLength="2000"/>
        <Property Name="castatus" Type="Edm.String" MaxLength="50"/>
        <Property Name="sap_sent" Type="Edm.Boolean" DefaultValue="false"/>
        <Property Name="sap_sent_date" Type="Edm.DateTimeOffset" Precision="7"/>
        <Property Name="sap_batch_id" Type="Edm.String" MaxLength="100"/>
        <NavigationProperty Name="travelRequestExpenses" Type="Collection(ReportsService.TravelRequestExpenses)" Partner="travelRequestEntries"/>
      </EntityType>
      <EntityType Name="TravelRequestExpenses">
        <Key>
          <PropertyRef Name="ID"/>
        </Key>
        <Property Name="ID" Type="Edm.Guid" Nullable="false"/>
        <NavigationProperty Name="travelRequestEntries" Type="ReportsService.TravelRequestEntries" Partner="travelRequestExpenses">
          <ReferentialConstraint Property="travelRequestEntries_ID" ReferencedProperty="ID"/>
        </NavigationProperty>
        <Property Name="travelRequestEntries_ID" Type="Edm.Guid"/>
        <NavigationProperty Name="expenseType" Type="ReportsService.SegmentTypes">
          <ReferentialConstraint Property="expenseType_ID" ReferencedProperty="ID"/>
        </NavigationProperty>
        <Property Name="expenseType_ID" Type="Edm.Guid"/>
        <Property Name="estimated_amount" Type="Edm.Decimal" Precision="15" Scale="2"/>
        <Property Name="details" Type="Edm.String"/>
        <Property Name="created_at" Type="Edm.DateTimeOffset" Precision="7"/>
        <Property Name="updated_at" Type="Edm.DateTimeOffset" Precision="7"/>
        <Property Name="file_path" Type="Edm.String" MaxLength="2000"/>
        <NavigationProperty Name="assigned_tmc" Type="ReportsService.Users">
          <ReferentialConstraint Property="assigned_tmc_ID" ReferencedProperty="ID"/>
        </NavigationProperty>
        <Property Name="assigned_tmc_ID" Type="Edm.Guid"/>
        <NavigationProperty Name="assigned_ca_admin" Type="ReportsService.Users">
          <ReferentialConstraint Property="assigned_ca_admin_ID" ReferencedProperty="ID"/>
        </NavigationProperty>
        <Property Name="assigned_ca_admin_ID" Type="Edm.Guid"/>
      </EntityType>
      <EntityType Name="EmployeeApproverMappings">
        <Key>
          <PropertyRef Name="ID"/>
        </Key>
        <Property Name="ID" Type="Edm.Guid" Nullable="false"/>
        <NavigationProperty Name="employeeId" Type="ReportsService.Users">
          <ReferentialConstraint Property="employeeId_ID" ReferencedProperty="ID"/>
        </NavigationProperty>
        <Property Name="employeeId_ID" Type="Edm.Guid"/>
        <NavigationProperty Name="approverId" Type="ReportsService.Users">
          <ReferentialConstraint Property="approverId_ID" ReferencedProperty="ID"/>
        </NavigationProperty>
        <Property Name="approverId_ID" Type="Edm.Guid"/>
        <Property Name="created_at" Type="Edm.DateTimeOffset" Precision="7"/>
        <Property Name="updated_at" Type="Edm.DateTimeOffset" Precision="7"/>
      </EntityType>
      <EntityType Name="ExpenseEmployeeApproverMappings">
        <Key>
          <PropertyRef Name="ID"/>
        </Key>
        <Property Name="ID" Type="Edm.Guid" Nullable="false"/>
        <NavigationProperty Name="user" Type="ReportsService.Users">
          <ReferentialConstraint Property="user_ID" ReferencedProperty="ID"/>
        </NavigationProperty>
        <Property Name="user_ID" Type="Edm.Guid"/>
        <Property Name="group_ID" Type="Edm.Guid"/>
        <NavigationProperty Name="policy" Type="ReportsService.ExpensePolicies">
          <ReferentialConstraint Property="policy_ID" ReferencedProperty="ID"/>
        </NavigationProperty>
        <Property Name="policy_ID" Type="Edm.Guid"/>
        <Property Name="approverLevel_ID" Type="Edm.Guid"/>
        <NavigationProperty Name="approver" Type="ReportsService.Users">
          <ReferentialConstraint Property="approver_ID" ReferencedProperty="ID"/>
        </NavigationProperty>
        <Property Name="approver_ID" Type="Edm.Guid"/>
        <Property Name="order" Type="Edm.Int32"/>
        <Property Name="created_at" Type="Edm.DateTimeOffset" Precision="7"/>
        <Property Name="updated_at" Type="Edm.DateTimeOffset" Precision="7"/>
      </EntityType>
      <EntityType Name="Policies">
        <Key>
          <PropertyRef Name="ID"/>
        </Key>
        <Property Name="ID" Type="Edm.Guid" Nullable="false"/>
        <Property Name="name" Type="Edm.String" MaxLength="100"/>
        <Property Name="description" Type="Edm.String" MaxLength="500"/>
        <Property Name="isInternationalPolicy" Type="Edm.Boolean" DefaultValue="false"/>
        <Property Name="created_at" Type="Edm.DateTimeOffset" Precision="7"/>
        <Property Name="updated_at" Type="Edm.DateTimeOffset" Precision="7"/>
        <Property Name="approvers_ID" Type="Edm.Guid"/>
      </EntityType>
      <EntityType Name="ExpensePolicies">
        <Key>
          <PropertyRef Name="ID"/>
        </Key>
        <Property Name="ID" Type="Edm.Guid" Nullable="false"/>
        <Property Name="name" Type="Edm.String" MaxLength="100"/>
        <Property Name="description" Type="Edm.String" MaxLength="500"/>
        <Property Name="isInternationalPolicy" Type="Edm.Boolean" DefaultValue="false"/>
        <Property Name="created_at" Type="Edm.DateTimeOffset" Precision="7"/>
        <Property Name="updated_at" Type="Edm.DateTimeOffset" Precision="7"/>
        <Property Name="isNonTravelPolicy" Type="Edm.Boolean" DefaultValue="false"/>
        <Property Name="isIntracityPolicy" Type="Edm.Boolean" DefaultValue="false"/>
      </EntityType>
      <EntityType Name="Users">
        <Key>
          <PropertyRef Name="ID"/>
        </Key>
        <Property Name="ID" Type="Edm.Guid" Nullable="false"/>
        <Property Name="username" Type="Edm.String" MaxLength="100" Nullable="false"/>
        <Property Name="password" Type="Edm.String" MaxLength="100" Nullable="false"/>
        <Property Name="firstName" Type="Edm.String" MaxLength="32"/>
        <Property Name="middleName" Type="Edm.String" MaxLength="32"/>
        <Property Name="lastName" Type="Edm.String" MaxLength="32"/>
        <Property Name="employeeId" Type="Edm.String" MaxLength="48"/>
        <Property Name="position" Type="Edm.String" MaxLength="100"/>
        <Property Name="managerId" Type="Edm.String" MaxLength="100"/>
        <Property Name="managerName" Type="Edm.String" MaxLength="100"/>
        <Property Name="email" Type="Edm.String" MaxLength="255"/>
        <Property Name="passportNumber" Type="Edm.String" MaxLength="100"/>
        <Property Name="passportExpiryDate" Type="Edm.Date"/>
        <Property Name="aadharNumber" Type="Edm.String" MaxLength="100"/>
        <Property Name="created_at" Type="Edm.DateTimeOffset" Precision="7"/>
        <Property Name="updated_at" Type="Edm.DateTimeOffset" Precision="7"/>
        <Property Name="is_active" Type="Edm.Boolean" DefaultValue="true"/>
        <Property Name="isTestUser" Type="Edm.Boolean" DefaultValue="false"/>
        <Property Name="expenseUser" Type="Edm.Boolean" DefaultValue="false"/>
        <Property Name="expenseApprover" Type="Edm.Boolean" DefaultValue="false"/>
        <Property Name="requestUser" Type="Edm.Boolean" DefaultValue="false"/>
        <Property Name="requestApprover" Type="Edm.Boolean" DefaultValue="false"/>
        <Property Name="autoApproval" Type="Edm.Boolean" DefaultValue="false"/>
        <Property Name="oneLevelApproval" Type="Edm.Boolean" DefaultValue="false"/>
        <Property Name="mustChangePassword" Type="Edm.Boolean" DefaultValue="false"/>
        <Property Name="passwordResetToken" Type="Edm.String" MaxLength="255"/>
        <Property Name="passwordResetExpiry" Type="Edm.DateTimeOffset" Precision="7"/>
        <Property Name="cashAdvanceAccountCode" Type="Edm.String" MaxLength="20"/>
        <Property Name="vendorId" Type="Edm.String" MaxLength="20"/>
        <Property Name="sbuId_ID" Type="Edm.Guid"/>
        <NavigationProperty Name="costCenterId" Type="ReportsService.CostCenters">
          <ReferentialConstraint Property="costCenterId_ID" ReferencedProperty="ID"/>
        </NavigationProperty>
        <Property Name="costCenterId_ID" Type="Edm.Guid"/>
        <Property Name="departmentId_ID" Type="Edm.Guid"/>
        <Property Name="divisionId_ID" Type="Edm.Guid"/>
        <Property Name="designationId_ID" Type="Edm.Guid"/>
        <Property Name="gradeId_ID" Type="Edm.Guid"/>
        <Property Name="companyId_ID" Type="Edm.Guid"/>
        <Property Name="orgLevel1_ID" Type="Edm.Guid"/>
        <Property Name="orgLevel2_ID" Type="Edm.Guid"/>
        <Property Name="orgLevel3_ID" Type="Edm.Guid"/>
        <Property Name="orgLevel4_ID" Type="Edm.Guid"/>
        <Property Name="orgLevel5_ID" Type="Edm.Guid"/>
        <Property Name="orgLevel6_ID" Type="Edm.Guid"/>
        <NavigationProperty Name="ledgerId" Type="ReportsService.AccountingLedgers">
          <ReferentialConstraint Property="ledgerId_ID" ReferencedProperty="ID"/>
        </NavigationProperty>
        <Property Name="ledgerId_ID" Type="Edm.Guid"/>
        <Property Name="group_ID" Type="Edm.Guid"/>
        <NavigationProperty Name="currencyId" Type="ReportsService.Currencies">
          <ReferentialConstraint Property="currencyId_ID" ReferencedProperty="ID"/>
        </NavigationProperty>
        <Property Name="currencyId_ID" Type="Edm.Guid"/>
        <Property Name="countryId_ID" Type="Edm.Int32"/>
        <Property Name="endDate" Type="Edm.Date"/>
        <NavigationProperty Name="dependents" Type="Collection(ReportsService.UserDependents)" Partner="user">
          <OnDelete Action="Cascade"/>
        </NavigationProperty>
      </EntityType>
      <EntityType Name="UserRoleMappings">
        <Key>
          <PropertyRef Name="ID"/>
        </Key>
        <Property Name="ID" Type="Edm.Guid" Nullable="false"/>
        <Property Name="userId" Type="Edm.Guid"/>
        <Property Name="roleId" Type="Edm.Guid"/>
      </EntityType>
      <EntityType Name="Roles">
        <Key>
          <PropertyRef Name="ID"/>
        </Key>
        <Property Name="ID" Type="Edm.Guid" Nullable="false"/>
        <Property Name="name" Type="Edm.String" MaxLength="100" Nullable="false"/>
        <Property Name="created_at" Type="Edm.DateTimeOffset" Precision="7"/>
        <Property Name="updated_at" Type="Edm.DateTimeOffset" Precision="7"/>
      </EntityType>
      <EntityType Name="PolicyRules">
        <Key>
          <PropertyRef Name="ID"/>
        </Key>
        <Property Name="ID" Type="Edm.Guid" Nullable="false"/>
        <NavigationProperty Name="applicability" Type="ReportsService.Applicability">
          <ReferentialConstraint Property="applicability_ID" ReferencedProperty="ID"/>
        </NavigationProperty>
        <Property Name="applicability_ID" Type="Edm.Guid"/>
        <Property Name="stop_type" Type="Edm.String" MaxLength="20"/>
        <Property Name="requires_escalation" Type="Edm.Boolean"/>
        <Property Name="created_at" Type="Edm.DateTimeOffset" Precision="7"/>
        <Property Name="updated_at" Type="Edm.DateTimeOffset" Precision="7"/>
        <Property Name="description" Type="Edm.String" MaxLength="500"/>
      </EntityType>
      <EntityType Name="PolicyRulePolicies">
        <Key>
          <PropertyRef Name="ID"/>
        </Key>
        <Property Name="ID" Type="Edm.Guid" Nullable="false"/>
        <NavigationProperty Name="policy_id" Type="ReportsService.Policies">
          <ReferentialConstraint Property="policy_id_ID" ReferencedProperty="ID"/>
        </NavigationProperty>
        <Property Name="policy_id_ID" Type="Edm.Guid"/>
        <NavigationProperty Name="rule_id" Type="ReportsService.PolicyRules">
          <ReferentialConstraint Property="rule_id_ID" ReferencedProperty="ID"/>
        </NavigationProperty>
        <Property Name="rule_id_ID" Type="Edm.Guid"/>
      </EntityType>
      <EntityType Name="Applicability">
        <Key>
          <PropertyRef Name="ID"/>
        </Key>
        <Property Name="ID" Type="Edm.Guid" Nullable="false"/>
        <Property Name="is_global" Type="Edm.Boolean"/>
        <Property Name="expense_category_id" Type="Edm.Guid"/>
        <Property Name="expense_type_id" Type="Edm.Guid"/>
        <Property Name="cost_centers" Type="Edm.String"/>
        <Property Name="departments" Type="Edm.String"/>
        <Property Name="sbus" Type="Edm.String"/>
        <Property Name="designations" Type="Edm.String"/>
        <Property Name="grades" Type="Edm.String"/>
        <Property Name="created_at" Type="Edm.DateTimeOffset" Precision="7"/>
        <Property Name="updated_at" Type="Edm.DateTimeOffset" Precision="7"/>
      </EntityType>
      <EntityType Name="PolicyConditions">
        <Key>
          <PropertyRef Name="ID"/>
        </Key>
        <Property Name="ID" Type="Edm.Guid" Nullable="false"/>
        <Property Name="policy_rule_id" Type="Edm.Guid"/>
        <Property Name="field_name" Type="Edm.String" MaxLength="50"/>
        <Property Name="operator" Type="Edm.String" MaxLength="10"/>
        <Property Name="value" Type="Edm.String" MaxLength="50"/>
        <Property Name="requires_escalation" Type="Edm.Boolean"/>
        <Property Name="logical_operator" Type="Edm.String" MaxLength="10"/>
        <Property Name="sequence" Type="Edm.Int32"/>
        <Property Name="group_id" Type="Edm.Int32"/>
        <Property Name="external_source" Type="Edm.String" MaxLength="200"/>
        <Property Name="created_at" Type="Edm.DateTimeOffset" Precision="7"/>
        <Property Name="updated_at" Type="Edm.DateTimeOffset" Precision="7"/>
      </EntityType>
      <EntityType Name="RequestGroupPolicyMapping">
        <Key>
          <PropertyRef Name="ID"/>
        </Key>
        <Property Name="ID" Type="Edm.Guid" Nullable="false"/>
        <NavigationProperty Name="policy" Type="ReportsService.Policies">
          <ReferentialConstraint Property="policy_ID" ReferencedProperty="ID"/>
        </NavigationProperty>
        <Property Name="policy_ID" Type="Edm.Guid"/>
        <Property Name="group_ID" Type="Edm.Guid"/>
      </EntityType>
      <EntityType Name="ExpenseGroupPolicyMapping">
        <Key>
          <PropertyRef Name="ID"/>
        </Key>
        <Property Name="ID" Type="Edm.Guid" Nullable="false"/>
        <NavigationProperty Name="policy" Type="ReportsService.Policies">
          <ReferentialConstraint Property="policy_ID" ReferencedProperty="ID"/>
        </NavigationProperty>
        <Property Name="policy_ID" Type="Edm.Guid"/>
        <Property Name="group_ID" Type="Edm.Guid"/>
      </EntityType>
      <EntityType Name="AuditRules">
        <Key>
          <PropertyRef Name="ID"/>
        </Key>
        <Property Name="ID" Type="Edm.Guid" Nullable="false"/>
        <Property Name="name" Type="Edm.String" MaxLength="100"/>
        <Property Name="rule_type" Type="Edm.String" MaxLength="50"/>
        <Property Name="applies_to_all_policies" Type="Edm.Boolean"/>
        <NavigationProperty Name="policies" Type="Collection(ReportsService.Policies)"/>
        <Property Name="policies_ID" Type="Edm.Guid"/>
        <Property Name="created_at" Type="Edm.DateTimeOffset" Precision="7"/>
        <Property Name="updated_at" Type="Edm.DateTimeOffset" Precision="7"/>
      </EntityType>
      <EntityType Name="AuditConditions">
        <Key>
          <PropertyRef Name="ID"/>
        </Key>
        <Property Name="ID" Type="Edm.Guid" Nullable="false"/>
        <NavigationProperty Name="audit_rule" Type="ReportsService.AuditRules">
          <ReferentialConstraint Property="audit_rule_ID" ReferencedProperty="ID"/>
        </NavigationProperty>
        <Property Name="audit_rule_ID" Type="Edm.Guid"/>
        <Property Name="condition_key" Type="Edm.String" MaxLength="50"/>
        <Property Name="operator" Type="Edm.String" MaxLength="10"/>
        <Property Name="threshold_value" Type="Edm.String" MaxLength="50"/>
        <Property Name="logical_operator" Type="Edm.String" MaxLength="10"/>
      </EntityType>
      <EntityType Name="WorkflowStep">
        <Key>
          <PropertyRef Name="ID"/>
        </Key>
        <Property Name="ID" Type="Edm.Guid" Nullable="false"/>
        <Property Name="workflow_ID" Type="Edm.Guid"/>
        <Property Name="step_number" Type="Edm.Int32"/>
        <Property Name="approver_level" Type="Edm.String" MaxLength="50"/>
        <NavigationProperty Name="escalation_rule" Type="ReportsService.PolicyRules">
          <ReferentialConstraint Property="escalation_rule_ID" ReferencedProperty="ID"/>
        </NavigationProperty>
        <Property Name="escalation_rule_ID" Type="Edm.Guid"/>
        <Property Name="requires_comment" Type="Edm.Boolean"/>
      </EntityType>
      <EntityType Name="ExpenseRecordWorkflow">
        <Key>
          <PropertyRef Name="ID"/>
        </Key>
        <Property Name="ID" Type="Edm.Guid" Nullable="false"/>
        <NavigationProperty Name="expenseRecord" Type="ReportsService.ExpenseRecordEntries">
          <ReferentialConstraint Property="expenseRecord_ID" ReferencedProperty="ID"/>
        </NavigationProperty>
        <Property Name="expenseRecord_ID" Type="Edm.Guid"/>
        <NavigationProperty Name="employee" Type="ReportsService.Users">
          <ReferentialConstraint Property="employee_ID" ReferencedProperty="ID"/>
        </NavigationProperty>
        <Property Name="employee_ID" Type="Edm.Guid"/>
        <NavigationProperty Name="policy" Type="ReportsService.ExpensePolicies">
          <ReferentialConstraint Property="policy_ID" ReferencedProperty="ID"/>
        </NavigationProperty>
        <Property Name="policy_ID" Type="Edm.Guid"/>
        <NavigationProperty Name="approver" Type="ReportsService.Users">
          <ReferentialConstraint Property="approver_ID" ReferencedProperty="ID"/>
        </NavigationProperty>
        <Property Name="approver_ID" Type="Edm.Guid"/>
        <Property Name="approverLevel_ID" Type="Edm.Guid"/>
        <Property Name="order" Type="Edm.Int32"/>
        <Property Name="status" Type="Edm.String" MaxLength="50" DefaultValue="Pending"/>
        <Property Name="isCompleted" Type="Edm.Boolean" DefaultValue="false"/>
        <Property Name="isEscalated" Type="Edm.Boolean" DefaultValue="false"/>
        <Property Name="isWorkflow" Type="Edm.Boolean" DefaultValue="false"/>
        <Property Name="created_at" Type="Edm.DateTimeOffset" Precision="7"/>
        <Property Name="updated_at" Type="Edm.DateTimeOffset" Precision="7"/>
      </EntityType>
      <EntityType Name="ExpenseRecordFields">
        <Key>
          <PropertyRef Name="ID"/>
        </Key>
        <Property Name="ID" Type="Edm.Guid" Nullable="false"/>
        <Property Name="name" Type="Edm.String" MaxLength="100"/>
        <Property Name="required_fields" Type="Edm.String" MaxLength="4000"/>
        <Property Name="required_field_options" Type="Edm.String" MaxLength="4000"/>
        <Property Name="core_fields" Type="Edm.String" MaxLength="4000"/>
        <Property Name="core_field_options" Type="Edm.String" MaxLength="4000"/>
      </EntityType>
      <EntityType Name="ExpenseTypes">
        <Key>
          <PropertyRef Name="ID"/>
        </Key>
        <Property Name="ID" Type="Edm.Guid" Nullable="false"/>
        <Property Name="name" Type="Edm.String" MaxLength="100"/>
        <Property Name="description" Type="Edm.String" MaxLength="500"/>
        <Property Name="requires_escalation" Type="Edm.Boolean"/>
        <Property Name="required_fields" Type="Edm.String" MaxLength="5000"/>
        <Property Name="options" Type="Edm.String" MaxLength="5000"/>
        <Property Name="core_fields" Type="Edm.String" MaxLength="5000"/>
        <Property Name="core_field_options" Type="Edm.String" MaxLength="5000"/>
        <Property Name="code" Type="Edm.String" MaxLength="100"/>
        <Property Name="isNonTravelPolicy" Type="Edm.Boolean" DefaultValue="false"/>
        <Property Name="isIntracityPolicy" Type="Edm.Boolean" DefaultValue="false"/>
      </EntityType>
      <EntityType Name="ExpenseTypesExpense">
        <Key>
          <PropertyRef Name="ID"/>
        </Key>
        <Property Name="ID" Type="Edm.Guid" Nullable="false"/>
        <Property Name="name" Type="Edm.String" MaxLength="100"/>
        <Property Name="description" Type="Edm.String" MaxLength="500"/>
        <Property Name="requires_escalation" Type="Edm.Boolean"/>
        <Property Name="required_fields" Type="Edm.String" MaxLength="5000"/>
        <Property Name="options" Type="Edm.String" MaxLength="5000"/>
        <Property Name="core_fields" Type="Edm.String" MaxLength="5000"/>
        <Property Name="core_field_options" Type="Edm.String" MaxLength="5000"/>
        <Property Name="category_ID" Type="Edm.Guid"/>
        <Property Name="code" Type="Edm.String" MaxLength="100"/>
      </EntityType>
      <EntityType Name="SegmentTypes">
        <Key>
          <PropertyRef Name="ID"/>
        </Key>
        <Property Name="ID" Type="Edm.Guid" Nullable="false"/>
        <Property Name="name" Type="Edm.String" MaxLength="100"/>
        <Property Name="description" Type="Edm.String" MaxLength="500"/>
        <Property Name="requires_escalation" Type="Edm.Boolean"/>
        <Property Name="required_fields" Type="Edm.String" MaxLength="5000"/>
        <Property Name="options" Type="Edm.String" MaxLength="5000"/>
        <Property Name="core_fields" Type="Edm.String" MaxLength="5000"/>
        <Property Name="core_field_options" Type="Edm.String" MaxLength="5000"/>
        <Property Name="code" Type="Edm.String" MaxLength="100"/>
      </EntityType>
      <EntityType Name="PerDayAllowance">
        <Key>
          <PropertyRef Name="ID"/>
        </Key>
        <Property Name="ID" Type="Edm.Guid" Nullable="false"/>
        <Property Name="PerDayAllowanceName" Type="Edm.String"/>
        <Property Name="group_ID" Type="Edm.Guid"/>
        <NavigationProperty Name="policy" Type="ReportsService.ExpensePolicies">
          <ReferentialConstraint Property="policy_ID" ReferencedProperty="ID"/>
        </NavigationProperty>
        <Property Name="policy_ID" Type="Edm.Guid"/>
        <Property Name="details" Type="Edm.String"/>
        <Property Name="created_at" Type="Edm.DateTimeOffset" Precision="7"/>
        <Property Name="updated_at" Type="Edm.DateTimeOffset" Precision="7"/>
      </EntityType>
      <EntityType Name="FuelAllowance">
        <Key>
          <PropertyRef Name="ID"/>
        </Key>
        <Property Name="ID" Type="Edm.Guid" Nullable="false"/>
        <Property Name="FuelAllowanceName" Type="Edm.String"/>
        <Property Name="group_ID" Type="Edm.Guid"/>
        <NavigationProperty Name="policy" Type="ReportsService.ExpensePolicies">
          <ReferentialConstraint Property="policy_ID" ReferencedProperty="ID"/>
        </NavigationProperty>
        <Property Name="policy_ID" Type="Edm.Guid"/>
        <NavigationProperty Name="currency" Type="ReportsService.Currencies">
          <ReferentialConstraint Property="currency_ID" ReferencedProperty="ID"/>
        </NavigationProperty>
        <Property Name="currency_ID" Type="Edm.Guid"/>
        <Property Name="vehicleType" Type="Edm.String"/>
        <Property Name="details" Type="Edm.String"/>
        <Property Name="created_at" Type="Edm.DateTimeOffset" Precision="7"/>
        <Property Name="updated_at" Type="Edm.DateTimeOffset" Precision="7"/>
      </EntityType>
      <EntityType Name="Cities">
        <Key>
          <PropertyRef Name="ID"/>
        </Key>
        <Property Name="ID" Type="Edm.Int32" Nullable="false"/>
        <Property Name="city" Type="Edm.String" MaxLength="255"/>
        <Property Name="name" Type="Edm.String" MaxLength="255"/>
        <Property Name="countryCode" Type="Edm.String" MaxLength="10"/>
        <Property Name="country_ID" Type="Edm.Int32"/>
      </EntityType>
      <EntityType Name="AllCities">
        <Key>
          <PropertyRef Name="ID"/>
        </Key>
        <Property Name="ID" Type="Edm.Guid" Nullable="false"/>
        <Property Name="name" Type="Edm.String" MaxLength="255"/>
        <Property Name="countryCode" Type="Edm.String" MaxLength="255"/>
        <Property Name="country" Type="Edm.String" MaxLength="255"/>
      </EntityType>
      <EntityType Name="AccountingLedgers">
        <Key>
          <PropertyRef Name="ID"/>
        </Key>
        <Property Name="ID" Type="Edm.Guid" Nullable="false"/>
        <Property Name="name" Type="Edm.String" MaxLength="100"/>
        <Property Name="description" Type="Edm.String" MaxLength="255"/>
        <Property Name="is_active" Type="Edm.Boolean"/>
        <Property Name="code" Type="Edm.String" MaxLength="100"/>
      </EntityType>
      <EntityType Name="CostCenters">
        <Key>
          <PropertyRef Name="ID"/>
        </Key>
        <Property Name="ID" Type="Edm.Guid" Nullable="false"/>
        <Property Name="name" Type="Edm.String" MaxLength="100"/>
        <Property Name="description" Type="Edm.String" MaxLength="255"/>
        <Property Name="code" Type="Edm.String" MaxLength="100"/>
        <Property Name="startDate" Type="Edm.Date"/>
        <Property Name="endDate" Type="Edm.Date"/>
        <Property Name="costcenterManager" Type="Edm.String" MaxLength="100"/>
        <Property Name="is_active" Type="Edm.Boolean"/>
      </EntityType>
      <EntityType Name="GLCodeMappings">
        <Key>
          <PropertyRef Name="ID"/>
        </Key>
        <Property Name="ID" Type="Edm.Guid" Nullable="false"/>
        <Property Name="gl_code" Type="Edm.String" MaxLength="50"/>
        <Property Name="description" Type="Edm.String" MaxLength="255"/>
        <NavigationProperty Name="ledger" Type="ReportsService.AccountingLedgers">
          <ReferentialConstraint Property="ledger_ID" ReferencedProperty="ID"/>
        </NavigationProperty>
        <Property Name="ledger_ID" Type="Edm.Guid"/>
        <NavigationProperty Name="policy" Type="ReportsService.Policies">
          <ReferentialConstraint Property="policy_ID" ReferencedProperty="ID"/>
        </NavigationProperty>
        <Property Name="policy_ID" Type="Edm.Guid"/>
        <NavigationProperty Name="expenseType" Type="ReportsService.ExpenseTypes">
          <ReferentialConstraint Property="expenseType_ID" ReferencedProperty="ID"/>
        </NavigationProperty>
        <Property Name="expenseType_ID" Type="Edm.Guid"/>
      </EntityType>
      <EntityType Name="Currencies">
        <Key>
          <PropertyRef Name="ID"/>
        </Key>
        <Property Name="ID" Type="Edm.Guid" Nullable="false"/>
        <Property Name="currency_code" Type="Edm.String" MaxLength="100"/>
        <Property Name="currency_name" Type="Edm.String" MaxLength="255"/>
      </EntityType>
      <EntityType Name="UserDependents">
        <Key>
          <PropertyRef Name="ID"/>
        </Key>
        <Property Name="ID" Type="Edm.Guid" Nullable="false"/>
        <NavigationProperty Name="user" Type="ReportsService.Users" Partner="dependents">
          <ReferentialConstraint Property="user_ID" ReferencedProperty="ID"/>
        </NavigationProperty>
        <Property Name="user_ID" Type="Edm.Guid"/>
        <Property Name="name" Type="Edm.String" MaxLength="255"/>
        <Property Name="relation" Type="Edm.String" MaxLength="50"/>
        <Property Name="passportNumber" Type="Edm.String" MaxLength="100"/>
        <Property Name="passportExpiryDate" Type="Edm.Date"/>
        <Property Name="aadharNumber" Type="Edm.String" MaxLength="100"/>
      </EntityType>
      <ComplexType Name="return_ReportsService_ExpenseRecordExport">
        <Property Name="EmpID" Type="Edm.String"/>
        <Property Name="Name" Type="Edm.String"/>
        <Property Name="VendorID" Type="Edm.String"/>
        <Property Name="Ledger" Type="Edm.String"/>
        <Property Name="CompanyCode" Type="Edm.String"/>
        <Property Name="CashAdvanceCode" Type="Edm.String"/>
        <Property Name="CostCenter" Type="Edm.String"/>
        <Property Name="ReportID" Type="Edm.String"/>
        <Property Name="ExpenseType" Type="Edm.String"/>
        <Property Name="ExpenseTypeCode" Type="Edm.String"/>
        <Property Name="GLCode" Type="Edm.String"/>
        <Property Name="Amount" Type="Edm.Decimal" Precision="15" Scale="2"/>
        <Property Name="TransactionCurrency" Type="Edm.String"/>
        <Property Name="TaxCode" Type="Edm.String"/>
        <Property Name="TransactionDate" Type="Edm.String"/>
        <Property Name="CashAdvance" Type="Edm.String"/>
        <Property Name="ReportTotal" Type="Edm.Decimal" Precision="15" Scale="2"/>
        <Property Name="BaseCurrency" Type="Edm.String"/>
        <Property Name="ReportName" Type="Edm.String"/>
        <Property Name="TravelStartDate" Type="Edm.String"/>
        <Property Name="TravelEndDate" Type="Edm.String"/>
        <Property Name="FromLocation" Type="Edm.String"/>
        <Property Name="ToLocation" Type="Edm.String"/>
        <Property Name="ProjectName" Type="Edm.String"/>
        <Property Name="ReceiptStatus" Type="Edm.String"/>
        <Property Name="Department" Type="Edm.String"/>
        <Property Name="RequestedAmount" Type="Edm.Decimal" Precision="15" Scale="2"/>
        <Property Name="AdjustedAmount" Type="Edm.Decimal" Precision="15" Scale="2"/>
        <Property Name="PolicyName" Type="Edm.String"/>
      </ComplexType>
      <ComplexType Name="ap_ReportsService_ExpenseRecordExport_filter">
        <Property Name="notDownloaded" Type="Edm.Boolean"/>
        <Property Name="dateRange" Type="ReportsService.ap_ReportsService_ExpenseRecordExport_filter_dateRange"/>
      </ComplexType>
      <ComplexType Name="ap_ReportsService_ExpenseRecordExport_filter_dateRange">
        <Property Name="startDate" Type="Edm.String"/>
        <Property Name="endDate" Type="Edm.String"/>
      </ComplexType>
      <ComplexType Name="return_ReportsService_sendExpenseDataToSap">
        <Property Name="success" Type="Edm.Boolean"/>
        <Property Name="message" Type="Edm.String"/>
        <Property Name="sapResponse" Type="Edm.String"/>
        <Property Name="sentData" Type="Collection(ReportsService.return_ReportsService_sendExpenseDataToSap_sentData)" Nullable="false"/>
        <Property Name="summary" Type="ReportsService.return_ReportsService_sendExpenseDataToSap_summary"/>
        <Property Name="batchId" Type="Edm.String"/>
        <Property Name="sapSentDate" Type="Edm.DateTimeOffset" Precision="7"/>
      </ComplexType>
      <ComplexType Name="return_ReportsService_sendExpenseDataToSap_sentData">
        <Property Name="Reportid" Type="Edm.String"/>
        <Property Name="Cashadvanceid" Type="Edm.String"/>
        <Property Name="CashadvanceAmount" Type="Edm.String"/>
        <Property Name="CashadvanceCurrency" Type="Edm.String"/>
        <Property Name="ExpenseAmount" Type="Edm.String"/>
        <Property Name="TransactionCurrency" Type="Edm.String"/>
        <Property Name="Employeeid" Type="Edm.String"/>
        <Property Name="EmployeeName" Type="Edm.String"/>
        <Property Name="Vendor" Type="Edm.String"/>
        <Property Name="Ledger" Type="Edm.String"/>
        <Property Name="Companycode" Type="Edm.String"/>
        <Property Name="CashAdvanceCode" Type="Edm.String"/>
        <Property Name="Costcenter" Type="Edm.String"/>
        <Property Name="ExpenseType" Type="Edm.String"/>
        <Property Name="ExpenseTypeCode" Type="Edm.String"/>
        <Property Name="GlCode" Type="Edm.String"/>
        <Property Name="TaxCode" Type="Edm.String"/>
        <Property Name="TransactionDate" Type="Edm.String"/>
        <Property Name="ReportTotal" Type="Edm.String"/>
        <Property Name="BaseCurrency" Type="Edm.String"/>
        <Property Name="ReportName" Type="Edm.String"/>
        <Property Name="CashadvanceCompanyCode" Type="Edm.String"/>
        <Property Name="CashadvanceIssueDate" Type="Edm.String"/>
        <Property Name="CashadvanceCreatedDate" Type="Edm.String"/>
        <Property Name="CashadvanceName" Type="Edm.String"/>
        <Property Name="CashadvanceType" Type="Edm.String"/>
      </ComplexType>
      <ComplexType Name="return_ReportsService_sendExpenseDataToSap_summary">
        <Property Name="totalRecords" Type="Edm.Int32"/>
        <Property Name="successfulRecords" Type="Edm.Int32"/>
        <Property Name="failedRecords" Type="Edm.Int32"/>
        <Property Name="totalBatches" Type="Edm.Int32"/>
        <Property Name="successfulBatches" Type="Edm.Int32"/>
        <Property Name="failedBatches" Type="Edm.Int32"/>
      </ComplexType>
      <ComplexType Name="return_ReportsService_CashAdvanceExport">
        <Property Name="EmployeeID" Type="Edm.String"/>
        <Property Name="EmployeeName" Type="Edm.String"/>
        <Property Name="VendorID" Type="Edm.String"/>
        <Property Name="Ledger" Type="Edm.String"/>
        <Property Name="CashAdvanceCode" Type="Edm.String"/>
        <Property Name="CashAdvanceID" Type="Edm.String"/>
        <Property Name="CashAdvanceAmount" Type="Edm.Decimal" Precision="15" Scale="2"/>
        <Property Name="CashAdvanceCurrency" Type="Edm.String"/>
        <Property Name="CashAdvanceCompanyCode" Type="Edm.String"/>
        <Property Name="CashAdvanceIssueDate" Type="Edm.String"/>
        <Property Name="CashAdvanceCreatedDate" Type="Edm.String"/>
        <Property Name="CashAdvanceName" Type="Edm.String"/>
        <Property Name="RequestID" Type="Edm.String"/>
        <Property Name="PolicyName" Type="Edm.String"/>
      </ComplexType>
      <ComplexType Name="return_ReportsService_resetSapTrackingFlags">
        <Property Name="success" Type="Edm.Boolean"/>
        <Property Name="message" Type="Edm.String"/>
      </ComplexType>
      <Action Name="ExpenseRecordExport" IsBound="false">
        <Parameter Name="filter" Type="ReportsService.ap_ReportsService_ExpenseRecordExport_filter"/>
        <ReturnType Type="Collection(ReportsService.return_ReportsService_ExpenseRecordExport)" Nullable="false"/>
      </Action>
      <Action Name="sendExpenseDataToSap" IsBound="false">
        <ReturnType Type="ReportsService.return_ReportsService_sendExpenseDataToSap"/>
      </Action>
      <Action Name="CashAdvanceExport" IsBound="false">
        <ReturnType Type="Collection(ReportsService.return_ReportsService_CashAdvanceExport)" Nullable="false"/>
      </Action>
      <Action Name="resetSapTrackingFlags" IsBound="false">
        <ReturnType Type="ReportsService.return_ReportsService_resetSapTrackingFlags"/>
      </Action>
      <Annotations Target="ReportsService.ExpenseRecordEntries/ID">
        <Annotation Term="Core.ComputedDefaultValue" Bool="true"/>
      </Annotations>
      <Annotations Target="ReportsService.ExpenseRecordExpenses/ID">
        <Annotation Term="Core.ComputedDefaultValue" Bool="true"/>
      </Annotations>
      <Annotations Target="ReportsService.TravelRequestEntries/ID">
        <Annotation Term="Core.ComputedDefaultValue" Bool="true"/>
      </Annotations>
      <Annotations Target="ReportsService.TravelRequestExpenses/ID">
        <Annotation Term="Core.ComputedDefaultValue" Bool="true"/>
      </Annotations>
      <Annotations Target="ReportsService.EmployeeApproverMappings/ID">
        <Annotation Term="Core.ComputedDefaultValue" Bool="true"/>
      </Annotations>
      <Annotations Target="ReportsService.ExpenseEmployeeApproverMappings/ID">
        <Annotation Term="Core.ComputedDefaultValue" Bool="true"/>
      </Annotations>
      <Annotations Target="ReportsService.Policies/ID">
        <Annotation Term="Core.ComputedDefaultValue" Bool="true"/>
      </Annotations>
      <Annotations Target="ReportsService.ExpensePolicies/ID">
        <Annotation Term="Core.ComputedDefaultValue" Bool="true"/>
      </Annotations>
      <Annotations Target="ReportsService.Users/ID">
        <Annotation Term="Core.ComputedDefaultValue" Bool="true"/>
      </Annotations>
      <Annotations Target="ReportsService.UserRoleMappings/ID">
        <Annotation Term="Core.ComputedDefaultValue" Bool="true"/>
      </Annotations>
      <Annotations Target="ReportsService.Roles/ID">
        <Annotation Term="Core.ComputedDefaultValue" Bool="true"/>
      </Annotations>
      <Annotations Target="ReportsService.PolicyRules/ID">
        <Annotation Term="Core.ComputedDefaultValue" Bool="true"/>
      </Annotations>
      <Annotations Target="ReportsService.PolicyRulePolicies/ID">
        <Annotation Term="Core.ComputedDefaultValue" Bool="true"/>
      </Annotations>
      <Annotations Target="ReportsService.Applicability/ID">
        <Annotation Term="Core.ComputedDefaultValue" Bool="true"/>
      </Annotations>
      <Annotations Target="ReportsService.PolicyConditions/ID">
        <Annotation Term="Core.ComputedDefaultValue" Bool="true"/>
      </Annotations>
      <Annotations Target="ReportsService.RequestGroupPolicyMapping/ID">
        <Annotation Term="Core.ComputedDefaultValue" Bool="true"/>
      </Annotations>
      <Annotations Target="ReportsService.ExpenseGroupPolicyMapping/ID">
        <Annotation Term="Core.ComputedDefaultValue" Bool="true"/>
      </Annotations>
      <Annotations Target="ReportsService.AuditRules/ID">
        <Annotation Term="Core.ComputedDefaultValue" Bool="true"/>
      </Annotations>
      <Annotations Target="ReportsService.AuditConditions/ID">
        <Annotation Term="Core.ComputedDefaultValue" Bool="true"/>
      </Annotations>
      <Annotations Target="ReportsService.WorkflowStep/ID">
        <Annotation Term="Core.ComputedDefaultValue" Bool="true"/>
      </Annotations>
      <Annotations Target="ReportsService.ExpenseRecordWorkflow/ID">
        <Annotation Term="Core.ComputedDefaultValue" Bool="true"/>
      </Annotations>
      <Annotations Target="ReportsService.ExpenseRecordFields/ID">
        <Annotation Term="Core.ComputedDefaultValue" Bool="true"/>
      </Annotations>
      <Annotations Target="ReportsService.ExpenseTypes/ID">
        <Annotation Term="Core.ComputedDefaultValue" Bool="true"/>
      </Annotations>
      <Annotations Target="ReportsService.ExpenseTypesExpense/ID">
        <Annotation Term="Core.ComputedDefaultValue" Bool="true"/>
      </Annotations>
      <Annotations Target="ReportsService.SegmentTypes/ID">
        <Annotation Term="Core.ComputedDefaultValue" Bool="true"/>
      </Annotations>
      <Annotations Target="ReportsService.PerDayAllowance/ID">
        <Annotation Term="Core.ComputedDefaultValue" Bool="true"/>
      </Annotations>
      <Annotations Target="ReportsService.FuelAllowance/ID">
        <Annotation Term="Core.ComputedDefaultValue" Bool="true"/>
      </Annotations>
      <Annotations Target="ReportsService.AllCities/ID">
        <Annotation Term="Core.ComputedDefaultValue" Bool="true"/>
      </Annotations>
      <Annotations Target="ReportsService.AccountingLedgers/ID">
        <Annotation Term="Core.ComputedDefaultValue" Bool="true"/>
      </Annotations>
      <Annotations Target="ReportsService.CostCenters/ID">
        <Annotation Term="Core.ComputedDefaultValue" Bool="true"/>
      </Annotations>
      <Annotations Target="ReportsService.GLCodeMappings/ID">
        <Annotation Term="Core.ComputedDefaultValue" Bool="true"/>
      </Annotations>
      <Annotations Target="ReportsService.Currencies/ID">
        <Annotation Term="Core.ComputedDefaultValue" Bool="true"/>
      </Annotations>
      <Annotations Target="ReportsService.UserDependents/ID">
        <Annotation Term="Core.ComputedDefaultValue" Bool="true"/>
      </Annotations>
    </Schema>
  </edmx:DataServices>
</edmx:Edmx>