<?xml version="1.0" encoding="utf-8"?><edmx:Edmx Version="4.0" xmlns:edmx="http://docs.oasis-open.org/odata/ns/edmx"><edmx:DataServices><Schema Namespace="Opex.Xeppo.Server.Entity" xmlns="http://docs.oasis-open.org/odata/ns/edm"><EntityType Name="Account"><Key><PropertyRef Name="SourceConnectorID" /><PropertyRef Name="AccountID" /></Key><Property Name="SourceConnectorID" Type="Edm.Int64" Nullable="false" /><Property Name="AccountID" Type="Edm.String" Nullable="false" /><Property Name="XeppoCode" Type="Edm.Int64" Nullable="false" /><Property Name="XeppoGroupCode" Type="Edm.Int64" /><Property Name="PracticeID" Type="Edm.Int64" Nullable="false" /><Property Name="ClientID" Type="Edm.String" /><Property Name="AccountType" Type="Edm.String" /><Property Name="AccountNumber" Type="Edm.String" /><Property Name="Class" Type="Edm.String" /><Property Name="AccountName" Type="Edm.String" /><Property Name="TaxType" Type="Edm.String" /><Property Name="Amount" Type="Edm.Decimal" Scale="Variable" /><Property Name="SyncID" Type="Edm.String" /><Property Name="LastUpdated" Type="Edm.DateTimeOffset" /><Property Name="ClientName" Type="Edm.String" /><Property Name="ClientCode" Type="Edm.String" /><Property Name="ConnectorName" Type="Edm.String" /><Property Name="ConnectorMasterID" Type="Edm.Int32" /><Property Name="GroupName" Type="Edm.String" /><Property Name="AccountCode" Type="Edm.String" /><Property Name="ClientStatusID" Type="Edm.Int64" /></EntityType><EntityType Name="Address"><Key><PropertyRef Name="SourceConnectorID" /><PropertyRef Name="ClientID" /><PropertyRef Name="TempKey" /></Key><Property Name="SourceConnectorID" Type="Edm.Int64" Nullable="false" /><Property Name="ClientID" Type="Edm.String" Nullable="false" /><Property Name="TempKey" Type="Edm.String" Nullable="false" /><Property Name="XeppoCode" Type="Edm.Int64" Nullable="false" /><Property Name="ClientName" Type="Edm.String" /><Property Name="ClientCode" Type="Edm.String" /><Property Name="XeppoGroupCode" Type="Edm.Int64" /><Property Name="PracticeID" Type="Edm.Int64" Nullable="false" /><Property Name="GroupID" Type="Edm.String" /><Property Name="Type" Type="Edm.String" /><Property Name="Line1" Type="Edm.String" /><Property Name="Line2" Type="Edm.String" /><Property Name="Line3" Type="Edm.String" /><Property Name="Suburb" Type="Edm.String" /><Property Name="State" Type="Edm.String" /><Property Name="Postcode" Type="Edm.String" /><Property Name="Country" Type="Edm.String" /><Property Name="Preferred" Type="Edm.Boolean" /><Property Name="SyncID" Type="Edm.String" /><Property Name="LastUpdated" Type="Edm.DateTimeOffset" /><Property Name="AddressID" Type="Edm.String" /><Property Name="TempKey2" Type="Edm.String" /><Property Name="Priority" Type="Edm.Int32" Nullable="false" /><Property Name="ConnectorName" Type="Edm.String" /><Property Name="AddressTypeID" Type="Edm.Int16" /><Property Name="GroupName" Type="Edm.String" /><Property Name="ClientStatusID" Type="Edm.Int64" /></EntityType><EntityType Name="AgedDebtor"><Key><PropertyRef Name="SourceConnectorID" /><PropertyRef Name="AgedDebtorsID" /></Key><Property Name="SourceConnectorID" Type="Edm.Int64" Nullable="false" /><Property Name="AgedDebtorsID" Type="Edm.String" Nullable="false" /><Property Name="XeppoCode" Type="Edm.Int64" Nullable="false" /><Property Name="PracticeID" Type="Edm.Int64" Nullable="false" /><Property Name="InvoiceNo" Type="Edm.String" /><Property Name="AmountOutstanding" Type="Edm.Decimal" Scale="Variable" /><Property Name="Current" Type="Edm.Decimal" Scale="Variable" /><Property Name="C30Days" Type="Edm.Decimal" Scale="Variable" /><Property Name="C60Days" Type="Edm.Decimal" Scale="Variable" /><Property Name="C90Days" Type="Edm.Decimal" Scale="Variable" /><Property Name="InvoiceDate" Type="Edm.DateTimeOffset" /><Property Name="Net" Type="Edm.Decimal" Scale="Variable" /><Property Name="GST" Type="Edm.Decimal" Scale="Variable" /><Property Name="Gross" Type="Edm.Decimal" Scale="Variable" /><Property Name="ItemType" Type="Edm.String" /><Property Name="ClientID" Type="Edm.String" /><Property Name="GroupID" Type="Edm.String" /><Property Name="XeppoGroupCode" Type="Edm.Int64" /><Property Name="ClientName" Type="Edm.String" /><Property Name="ClientCode" Type="Edm.String" /><Property Name="SyncID" Type="Edm.String" /><Property Name="LastUpdated" Type="Edm.DateTimeOffset" /><Property Name="GroupName" Type="Edm.String" /><Property Name="ClientStatusID" Type="Edm.Int64" /></EntityType><EntityType Name="Asset"><Key><PropertyRef Name="XeppoCode" /><PropertyRef Name="XeppoAssetID" /></Key><Property Name="XeppoCode" Type="Edm.Int64" Nullable="false" /><Property Name="XeppoAssetID" Type="Edm.Int64" Nullable="false" /><Property Name="ClientName" Type="Edm.String" /><Property Name="ClientCode" Type="Edm.String" /><Property Name="XeppoGroupCode" Type="Edm.Int64" /><Property Name="GroupName" Type="Edm.String" /><Property Name="PracticeID" Type="Edm.Int64" Nullable="false" /><Property Name="TempKey" Type="Edm.String" /><Property Name="SourceConnectorID" Type="Edm.Int32" /><Property Name="AssetID" Type="Edm.String" /><Property Name="ClientID" Type="Edm.String" /><Property Name="AssetName" Type="Edm.String" /><Property Name="AssetValue" Type="Edm.Double" /><Property Name="ValuationDate" Type="Edm.DateTimeOffset" /><Property Name="AssetType" Type="Edm.String" /><Property Name="AssetCategory" Type="Edm.String" /><Property Name="Acquired" Type="Edm.DateTimeOffset" /><Property Name="DisposalDate" Type="Edm.DateTimeOffset" /><Property Name="GroupID" Type="Edm.String" /><Property Name="Depth" Type="Edm.Int32" /><Property Name="SyncID" Type="Edm.String" /><Property Name="LastUpdated" Type="Edm.DateTimeOffset" /><Property Name="ConnectorName" Type="Edm.String" /><Property Name="ConnectorMasterID" Type="Edm.Int32" /><Property Name="AssetTypeID" Type="Edm.Int16" /><Property Name="AssetSubtypeID" Type="Edm.Int16" /><Property Name="AssetStatusID" Type="Edm.Int16" /><Property Name="Institution" Type="Edm.String" /><Property Name="AccountNumber" Type="Edm.String" /><Property Name="CapitalWithdrawalAmount" Type="Edm.Decimal" Scale="Variable" /><Property Name="Cost" Type="Edm.Decimal" Scale="Variable" /><Property Name="UnderAdvice" Type="Edm.Boolean" /><Property Name="ReinvestIncome" Type="Edm.Boolean" /><Property Name="AssetStatus" Type="Edm.String" /><Property Name="Notes" Type="Edm.String" /><Property Name="OwnerClients" Type="Edm.String" /><Property Name="ClientStatusID" Type="Edm.Int64" /><Property Name="OwnershipPercentage" Type="Edm.Decimal" Scale="Variable" /><Property Name="TaxedElement" Type="Edm.Decimal" Scale="Variable" /><Property Name="UnTaxedElement" Type="Edm.Decimal" Scale="Variable" /><Property Name="TaxFree" Type="Edm.Decimal" Scale="Variable" /><Property Name="PreservedAmount" Type="Edm.Decimal" Scale="Variable" /><Property Name="RestrictedNonPreserved" Type="Edm.Decimal" Scale="Variable" /><Property Name="UnRestrictedNonPreserved" Type="Edm.Decimal" Scale="Variable" /><Property Name="EligibleServiceDate" Type="Edm.DateTimeOffset" /><Property Name="DateCommenced" Type="Edm.DateTimeOffset" /><Property Name="TaxFreePercentage" Type="Edm.Decimal" Scale="Variable" /><Property Name="IncomePaymentTypeID" Type="Edm.Int32" /><Property Name="Term" Type="Edm.Decimal" Scale="Variable" /><Property Name="ResidualCapitalValue" Type="Edm.Decimal" Scale="Variable" /><Property Name="DeferralPeriod" Type="Edm.Decimal" Scale="Variable" /><Property Name="WithdrawalPeriod" Type="Edm.Decimal" Scale="Variable" /><Property Name="IncomeIndexation" Type="Edm.String" /><Property Name="IncomeIndexationPercentage" Type="Edm.Decimal" Scale="Variable" /><Property Name="IsPurchasedBySuper" Type="Edm.Boolean" /><Property Name="AnnualIncome" Type="Edm.Decimal" Scale="Variable" /><Property Name="OwnershipValue" Type="Edm.Double" /><Property Name="IsAuthorisedForFee" Type="Edm.Boolean" /></EntityType><EntityType Name="BalanceComponent"><Key><PropertyRef Name="SourceConnectorID" /><PropertyRef Name="BalanceComponentID" /></Key><Property Name="SourceConnectorID" Type="Edm.Int64" Nullable="false" /><Property Name="BalanceComponentID" Type="Edm.String" Nullable="false" /><Property Name="XeppoCode" Type="Edm.Int64" Nullable="false" /><Property Name="PracticeID" Type="Edm.Int64" Nullable="false" /><Property Name="MemberAccountID" Type="Edm.String" /><Property Name="ClosingBalanceType" Type="Edm.String" /><Property Name="Component" Type="Edm.String" /><Property Name="Amount" Type="Edm.Decimal" Scale="Variable" /><Property Name="ClientID" Type="Edm.String" /><Property Name="GroupID" Type="Edm.String" /><Property Name="FundID" Type="Edm.String" /><Property Name="ClientName" Type="Edm.String" /><Property Name="ClientCode" Type="Edm.String" /><Property Name="SyncID" Type="Edm.String" /><Property Name="LastUpdated" Type="Edm.DateTimeOffset" /><Property Name="XeppoGroupCode" Type="Edm.Int64" /><Property Name="MemberAccountName" Type="Edm.String" /><Property Name="GroupName" Type="Edm.String" /><Property Name="ClientStatusID" Type="Edm.Int64" /></EntityType><EntityType Name="Client"><Key><PropertyRef Name="XeppoCode" /></Key><Property Name="XeppoCode" Type="Edm.Int64" Nullable="false" /><Property Name="PracticeID" Type="Edm.Int64" Nullable="false" /><Property Name="Code" Type="Edm.String" /><Property Name="FatherCode" Type="Edm.String" /><Property Name="SourceEntityType" Type="Edm.String" /><Property Name="Name" Type="Edm.String" /><Property Name="HomePhone" Type="Edm.String" /><Property Name="WorkPhone" Type="Edm.String" /><Property Name="HomeMobile" Type="Edm.String" /><Property Name="HomeEmail" Type="Edm.String" /><Property Name="WorkEmail" Type="Edm.String" /><Property Name="OtherEmail" Type="Edm.String" /><Property Name="PreferredEmail" Type="Edm.String" /><Property Name="PreferredEmailTypeId" Type="Edm.Byte" /><Property Name="WorkFax" Type="Edm.String" /><Property Name="Salutation" Type="Edm.String" /><Property Name="MailName" Type="Edm.String" /><Property Name="TradingAs" Type="Edm.String" /><Property Name="PreferredContactMethod" Type="Edm.String" /><Property Name="DateEngagementLetterSent" Type="Edm.Boolean" /><Property Name="ACN" Type="Edm.String" /><Property Name="ABN" Type="Edm.String" /><Property Name="TFN" Type="Edm.String" /><Property Name="SFN" Type="Edm.String" /><Property Name="DateOfIncorporation" Type="Edm.DateTimeOffset" /><Property Name="DirectorRelationshipStatus" Type="Edm.String" /><Property Name="ReferrerName" Type="Edm.String" /><Property Name="ReferrerType" Type="Edm.String" /><Property Name="ClientGroupName" Type="Edm.String" /><Property Name="TaxReturnID" Type="Edm.String" /><Property Name="LastTaxReturn_NetIncome" Type="Edm.Decimal" Scale="Variable" /><Property Name="LastTaxReturn_LodgementDate" Type="Edm.DateTimeOffset" /><Property Name="PrevTaxReturn_LodgementDate" Type="Edm.DateTimeOffset" /><Property Name="InsuranceAdviser" Type="Edm.String" /><Property Name="Gender" Type="Edm.String" /><Property Name="DateOfBirth" Type="Edm.DateTimeOffset" /><Property Name="MaritalStatus" Type="Edm.String" /><Property Name="SpouseName" Type="Edm.String" /><Property Name="NoOfChildren" Type="Edm.String" /><Property Name="Occupation" Type="Edm.String" /><Property Name="Smoker" Type="Edm.String" /><Property Name="Health" Type="Edm.String" /><Property Name="Industry" Type="Edm.String" /><Property Name="FirstName" Type="Edm.String" /><Property Name="LastName" Type="Edm.String" /><Property Name="MiddleName" Type="Edm.String" /><Property Name="TerminationDate" Type="Edm.DateTimeOffset" /><Property Name="WorkMobile" Type="Edm.String" /><Property Name="HomeFax" Type="Edm.String" /><Property Name="Class_PWM_Inv" Type="Edm.String" /><Property Name="Class_CA" Type="Edm.String" /><Property Name="Class_Finance" Type="Edm.String" /><Property Name="Class_Audit" Type="Edm.String" /><Property Name="Class_PWM_Ins" Type="Edm.String" /><Property Name="ClientReferredBy" Type="Edm.String" /><Property Name="MarketingCommunication" Type="Edm.Boolean" /><Property Name="OccupationCode" Type="Edm.String" /><Property Name="Manager" Type="Edm.String" /><Property Name="Director" Type="Edm.String" /><Property Name="Accountant" Type="Edm.String" /><Property Name="PrimaryRelationshipPartner" Type="Edm.String" /><Property Name="TotalIncomeThisYear_TOTAL" Type="Edm.Decimal" Scale="Variable" /><Property Name="TaxableIncomeThisYear_TOTAL" Type="Edm.Decimal" Scale="Variable" /><Property Name="TotalIncomeLastYear_TOTAL" Type="Edm.Decimal" Scale="Variable" /><Property Name="TaxableIncomeLastYear_TOTAL" Type="Edm.Decimal" Scale="Variable" /><Property Name="ClientStatus_CRM" Type="Edm.String" /><Property Name="ClientClass_CRM" Type="Edm.String" /><Property Name="ClientType_CRM" Type="Edm.Int64" /><Property Name="PreferredClientContact_CRM" Type="Edm.String" /><Property Name="DebtorsOutstanding_TOTAL" Type="Edm.Decimal" Scale="Variable" /><Property Name="OldestUnpaidInvoice_TOTAL" Type="Edm.Int32" /><Property Name="CurrentWIP_TOTAL" Type="Edm.Decimal" Scale="Variable" /><Property Name="TotalLockup_TOTAL" Type="Edm.Decimal" Scale="Variable" /><Property Name="TotalFUM_TOTAL" Type="Edm.Decimal" Scale="Variable" /><Property Name="TotalAdviceFUA_TOTAL" Type="Edm.Decimal" Scale="Variable" /><Property Name="TotalAssets_TOTAL" Type="Edm.Decimal" Scale="Variable" /><Property Name="TotalLiabilities_TOTAL" Type="Edm.Decimal" Scale="Variable" /><Property Name="NetWorth_TOTAL" Type="Edm.Decimal" Scale="Variable" /><Property Name="AnnualPremium_TOTAL" Type="Edm.Decimal" Scale="Variable" /><Property Name="LifeSumInsured_TOTAL" Type="Edm.Decimal" Scale="Variable" /><Property Name="TraumaSumInsured_TOTAL" Type="Edm.Decimal" Scale="Variable" /><Property Name="TPDSumInsured_TOTAL" Type="Edm.Decimal" Scale="Variable" /><Property Name="IncomeProtectionMonthlyBenefit_TOTAL" Type="Edm.Decimal" Scale="Variable" /><Property Name="BusinessExpenseMonthlyBenefit_TOTAL" Type="Edm.Decimal" Scale="Variable" /><Property Name="OtherSumInsured_TOTAL" Type="Edm.Decimal" Scale="Variable" /><Property Name="IncomeYTD_TOTAL" Type="Edm.Decimal" Scale="Variable" /><Property Name="ExpensesYTD_TOTAL" Type="Edm.Decimal" Scale="Variable" /><Property Name="CashAtBank_TOTAL" Type="Edm.Decimal" Scale="Variable" /><Property Name="XeroTotalAssets_TOTAL" Type="Edm.Decimal" Scale="Variable" /><Property Name="XeroTotalLiabilities_TOTAL" Type="Edm.Decimal" Scale="Variable" /><Property Name="XeroTotalDebtors_TOTAL" Type="Edm.Decimal" Scale="Variable" /><Property Name="InvestorType_CRM" Type="Edm.Int64" /><Property Name="IncludeInCampaigns_CRM" Type="Edm.Boolean" /><Property Name="ClientRefersClients_CRM" Type="Edm.Boolean" /><Property Name="LastFPReview_TOTAL" Type="Edm.DateTimeOffset" /><Property Name="TotalFPHoldings_TOTAL" Type="Edm.Decimal" Scale="Variable" /><Property Name="TotalSMSFHoldings_TOTAL" Type="Edm.Decimal" Scale="Variable" /><Property Name="FPAsAt_TOTAL" Type="Edm.DateTimeOffset" /><Property Name="SMSFAsAt_TOTAL" Type="Edm.DateTimeOffset" /><Property Name="RSE" Type="Edm.String" /><Property Name="TrusteeName" Type="Edm.String" /><Property Name="TrustDeedDate" Type="Edm.DateTimeOffset" /><Property Name="Auditor" Type="Edm.String" /><Property Name="InvestmentManager" Type="Edm.String" /><Property Name="IsSuperFund_CHECK" Type="Edm.Boolean" /><Property Name="NetProfitYTD_TOTAL" Type="Edm.Decimal" Scale="Variable" /><Property Name="LastInsuranceReview_TOTAL" Type="Edm.DateTimeOffset" /><Property Name="TotalDebt_TOTAL" Type="Edm.Decimal" Scale="Variable" /><Property Name="MemberNumber" Type="Edm.String" /><Property Name="JoinFundDate" Type="Edm.DateTimeOffset" /><Property Name="ESPStartDate" Type="Edm.DateTimeOffset" /><Property Name="TFNRecorded" Type="Edm.Boolean" /><Property Name="BeneficiaryDetailsRecorded" Type="Edm.Boolean" /><Property Name="NominationEffectiveDate" Type="Edm.DateTimeOffset" /><Property Name="NominationExpiryDate" Type="Edm.DateTimeOffset" /><Property Name="Balance" Type="Edm.Decimal" Scale="Variable" /><Property Name="InsuranceRecorded" Type="Edm.Boolean" /><Property Name="LifeCover" Type="Edm.Decimal" Scale="Variable" /><Property Name="TPDCover" Type="Edm.Decimal" Scale="Variable" /><Property Name="SalaryContCover" Type="Edm.Decimal" Scale="Variable" /><Property Name="Title" Type="Edm.String" /><Property Name="ForeignOwner_CRM" Type="Edm.String" /><Property Name="CreditHold_CRM" Type="Edm.Boolean" /><Property Name="NoOfEmployees" Type="Edm.Int32" /><Property Name="Age" Type="Edm.Int32" /><Property Name="CleanTFN" Type="Edm.String" /><Property Name="CleanName" Type="Edm.String" /><Property Name="CleanLastName" Type="Edm.String" /><Property Name="LastUpdatedDate" Type="Edm.DateTimeOffset" /><Property Name="CostOfSalesYTD_TOTAL" Type="Edm.Decimal" Scale="Variable" /><Property Name="OtherIncomeYTD_TOTAL" Type="Edm.Decimal" Scale="Variable" /><Property Name="GrossProfitYTD_TOTAL" Type="Edm.Decimal" Scale="Variable" /><Property Name="XeroNetAssets_TOTAL" Type="Edm.Decimal" Scale="Variable" /><Property Name="TotalEquity_TOTAL" Type="Edm.Decimal" Scale="Variable" /><Property Name="XeroCurrentAssets_TOTAL" Type="Edm.Decimal" Scale="Variable" /><Property Name="TotalFeesYTD_TOTAL" Type="Edm.Decimal" Scale="Variable" /><Property Name="TotalFeesPrev_TOTAL" Type="Edm.Decimal" Scale="Variable" /><Property Name="TotalFeesPrev2_TOTAL" Type="Edm.Decimal" Scale="Variable" /><Property Name="TotalCommissionYTD_TOTAL" Type="Edm.Decimal" Scale="Variable" /><Property Name="TotalRevenueYTD_TOTAL" Type="Edm.Decimal" Scale="Variable" /><Property Name="TotalNewBusinessYTD_TOTAL" Type="Edm.Decimal" Scale="Variable" /><Property Name="TotalOngoingYTD_TOTAL" Type="Edm.Decimal" Scale="Variable" /><Property Name="AgeBracket" Type="Edm.String" /><Property Name="TotalFeesRollingYear_TOTAL" Type="Edm.Decimal" Scale="Variable" /><Property Name="TotalCommissionRollingYear_TOTAL" Type="Edm.Decimal" Scale="Variable" /><Property Name="TotalRevenueRollingYear_TOTAL" Type="Edm.Decimal" Scale="Variable" /><Property Name="APS_CHECK" Type="Edm.Boolean" /><Property Name="ClassSuper_CHECK" Type="Edm.Boolean" /><Property Name="Commpay_CHECK" Type="Edm.Boolean" /><Property Name="BGLCAS_CHECK" Type="Edm.Boolean" /><Property Name="XPLAN_CHECK" Type="Edm.Boolean" /><Property Name="Worksorted_CHECK" Type="Edm.Boolean" /><Property Name="WorkflowMax_CHECK" Type="Edm.Boolean" /><Property Name="MYOB_CHECK" Type="Edm.Boolean" /><Property Name="Xero_CHECK" Type="Edm.Boolean" /><Property Name="LoanAmountBorrowed_TOTAL" Type="Edm.Decimal" Scale="Variable" /><Property Name="LoanAmountOwing_TOTAL" Type="Edm.Decimal" Scale="Variable" /><Property Name="ClassTotalAssets_TOTAL" Type="Edm.Decimal" Scale="Variable" /><Property Name="ClassTotalLiabilities_TOTAL" Type="Edm.Decimal" Scale="Variable" /><Property Name="ClassNetAssets_TOTAL" Type="Edm.Decimal" Scale="Variable" /><Property Name="DebtorsOverdue_TOTAL" Type="Edm.Decimal" Scale="Variable" /><Property Name="TotalQuote_TOTAL" Type="Edm.Decimal" Scale="Variable" /><Property Name="TotalQuoteIssued_TOTAL" Type="Edm.Decimal" Scale="Variable" /><Property Name="TotalQuoteDraft_TOTAL" Type="Edm.Decimal" Scale="Variable" /><Property Name="TotalCommissionPrev_TOTAL" Type="Edm.Decimal" Scale="Variable" /><Property Name="KeyFirmContactList" Type="Edm.String" /><Property Name="StatusID" Type="Edm.Int64" /><Property Name="XeppoCodeString" Type="Edm.String" /><Property Name="TotalDiscrepancyCount" Type="Edm.Int32" /><Property Name="MismatchedDataCount" Type="Edm.Int32" /><Property Name="MissingDataCount" Type="Edm.Int32" /><Property Name="InvalidDataCount" Type="Edm.Int32" /><Property Name="NumberOfMatches" Type="Edm.Int32" /><Property Name="ConnectorList" Type="Edm.String" /><Property Name="XeppoGroupCode" Type="Edm.Int64" /><Property Name="GroupName" Type="Edm.String" /><Property Name="GroupVerifiedStatusID" Type="Edm.Int16" /><Property Name="GroupVerifiedStatus" Type="Edm.String" /><Property Name="IsPrimaryContact" Type="Edm.Boolean" /><Property Name="TagNames" Type="Edm.String" /><Property Name="Status" Type="Edm.String" /><Property Name="MoneySoftLoanAmountOwing_TOTAL" Type="Edm.Decimal" Scale="Variable" /><Property Name="MoneySoft_CHECK" Type="Edm.Boolean" Nullable="false" /><Property Name="MoneySoftNetWorth_TOTAL" Type="Edm.Decimal" Scale="Variable" /><Property Name="MoneySoftInvestments_TOTAL" Type="Edm.Decimal" Scale="Variable" /><Property Name="MoneySoftBankAccounts_TOTAL" Type="Edm.Decimal" Scale="Variable" /><Property Name="MoneySoftCreditCards_TOTAL" Type="Edm.Decimal" Scale="Variable" /><Property Name="MoneySoftPropoerties_TOTAL" Type="Edm.Decimal" Scale="Variable" /><Property Name="EntityType" Type="Edm.String" /><Property Name="ClientTypeID" Type="Edm.Int16" /><Property Name="StreetAddressLine1" Type="Edm.String" /><Property Name="StreetAddressLine2" Type="Edm.String" /><Property Name="StreetAddressLine3" Type="Edm.String" /><Property Name="StreetAddressSuburb" Type="Edm.String" /><Property Name="StreetAddressState" Type="Edm.String" /><Property Name="StreetAddressPostCode" Type="Edm.String" /><Property Name="BusinessAddressLine1" Type="Edm.String" /><Property Name="BusinessAddressLine2" Type="Edm.String" /><Property Name="BusinessAddressLine3" Type="Edm.String" /><Property Name="BusinessAddressSuburb" Type="Edm.String" /><Property Name="BusinessAddressState" Type="Edm.String" /><Property Name="BusinessAddressPostCode" Type="Edm.String" /><Property Name="PostalAddressLine1" Type="Edm.String" /><Property Name="PostalAddressLine2" Type="Edm.String" /><Property Name="PostalAddressLine3" Type="Edm.String" /><Property Name="PostalAddressSuburb" Type="Edm.String" /><Property Name="PostalAddressState" Type="Edm.String" /><Property Name="PostalAddressPostCode" Type="Edm.String" /><Property Name="RegisteredAddressLine1" Type="Edm.String" /><Property Name="RegisteredAddressLine2" Type="Edm.String" /><Property Name="RegisteredAddressLine3" Type="Edm.String" /><Property Name="RegisteredAddressSuburb" Type="Edm.String" /><Property Name="RegisteredAddressState" Type="Edm.String" /><Property Name="RegisteredAddressPostCode" Type="Edm.String" /><Property Name="PreferredAddressLine1" Type="Edm.String" /><Property Name="PreferredAddressLine2" Type="Edm.String" /><Property Name="PreferredAddressLine3" Type="Edm.String" /><Property Name="PreferredAddressSuburb" Type="Edm.String" /><Property Name="PreferredAddressState" Type="Edm.String" /><Property Name="PreferredAddressPostCode" Type="Edm.String" /><Property Name="StreetAddress" Type="Edm.String" /><Property Name="BusinessAddress" Type="Edm.String" /><Property Name="PostalAddress" Type="Edm.String" /><Property Name="RegisteredAddress" Type="Edm.String" /><Property Name="PreferredAddressTypeId" Type="Edm.Byte" /><Property Name="PreferredAddress" Type="Edm.String" /><Property Name="IsGenerateChangeRequestsEnabled" Type="Edm.Boolean" Nullable="false" /><Property Name="HasInsurance" Type="Edm.Boolean" /><Property Name="HasInsuranceGeneral" Type="Edm.Boolean" /><Property Name="HasInsurancePersonal" Type="Edm.Boolean" /><Property Name="TotalWages" Type="Edm.Decimal" Scale="Variable" /><Property Name="OtherDeductionsThisYear_TOTAL" Type="Edm.Decimal" Scale="Variable" /><Property Name="OtherDeductionsDescriptionThisYear" Type="Edm.String" /><Property Name="RentalIncomeThisYear_TOTAL" Type="Edm.Decimal" Scale="Variable" /><Property Name="DividendsThisYear_TOTAL" Type="Edm.Decimal" Scale="Variable" /><Property Name="DividendDeductionsThisYear_TOTAL" Type="Edm.Decimal" Scale="Variable" /><Property Name="InterestDeductionsThisYear_TOTAL" Type="Edm.Decimal" Scale="Variable" /><Property Name="OtherDeductionsLastYear_TOTAL" Type="Edm.Decimal" Scale="Variable" /><Property Name="OtherDeductionsDescriptionLastYear" Type="Edm.String" /><Property Name="RentalIncomeLastYear_TOTAL" Type="Edm.Decimal" Scale="Variable" /><Property Name="DividendsLastYear_TOTAL" Type="Edm.Decimal" Scale="Variable" /><Property Name="DividendDeductionsLastYear_TOTAL" Type="Edm.Decimal" Scale="Variable" /><Property Name="InterestDeductionsLastYear_TOTAL" Type="Edm.Decimal" Scale="Variable" /><Property Name="IncomeProtectionDeductionsThisYear_TOTAL" Type="Edm.Decimal" Scale="Variable" /><Property Name="IncomeProtectionDeductionsLastYear_TOTAL" Type="Edm.Decimal" Scale="Variable" /><Property Name="PartnerXeppoCode" Type="Edm.Int64" /><Property Name="OwnOrRentHome" Type="Edm.String" /><Property Name="TypeOfCompany" Type="Edm.String" /><Property Name="PartnershipLiability" Type="Edm.String" /><Property Name="PartnershipType" Type="Edm.String" /><Property Name="TypeOfFund" Type="Edm.String" /><Property Name="TypeOfTrust" Type="Edm.String" /><Property Name="PreferredName" Type="Edm.String" /><Property Name="PlaceOfBirth" Type="Edm.String" /><Property Name="DateOfMarriage" Type="Edm.DateTimeOffset" /><Property Name="ResidentStatus" Type="Edm.String" /><Property Name="IsAustralianTaxResident" Type="Edm.Boolean" /><Property Name="EmergencyContact" Type="Edm.String" /><Property Name="AddressForCorrespondence" Type="Edm.String" /><Property Name="IsLivingAtHome" Type="Edm.Boolean" /><Property Name="EmploymentPosition" Type="Edm.String" /><Property Name="EmploymentStatus" Type="Edm.String" /><Property Name="HoursWorkedPerWeek" Type="Edm.Decimal" Scale="Variable" /><Property Name="AnyEmploymentChangePlanned" Type="Edm.String" /><Property Name="HasSalaryPackagingAvailable" Type="Edm.Boolean" /><Property Name="LeaveDetails" Type="Edm.String" /><Property Name="BusinessStructure" Type="Edm.String" /><Property Name="AdditionalInformation" Type="Edm.String" /><Property Name="HealthInsurance" Type="Edm.String" /><Property Name="FamilyHistory" Type="Edm.String" /><Property Name="TotalIssuedShares" Type="Edm.Int64" /><Property Name="BusinessPurpose" Type="Edm.String" /><Property Name="BusinessActivities" Type="Edm.String" /><Property Name="BusinessValue" Type="Edm.Decimal" Scale="Variable" /><Property Name="HasComplyingStatus" Type="Edm.Boolean" /><Property Name="LocationOfDeed" Type="Edm.String" /><Property Name="PartnershipNumber" Type="Edm.String" /><Property Name="EmployerName" Type="Edm.String" /><Property Name="StartDateWithEmployer" Type="Edm.DateTimeOffset" /><Property Name="StartedInCurrentOccupation" Type="Edm.DateTimeOffset" /><Property Name="HealthConditions" Type="Edm.String" /><Property Name="MoneySoftVehicles_TOTAL" Type="Edm.Decimal" Scale="Variable" /><Property Name="MoneySoftOtherAsset_TOTAL" Type="Edm.Decimal" Scale="Variable" /><Property Name="MoneySoftOtherLoyalty_TOTAL" Type="Edm.Decimal" Scale="Variable" /><Property Name="MoneySoftOtherLiability_TOTAL" Type="Edm.Decimal" Scale="Variable" /><Property Name="DateOfDeath" Type="Edm.DateTimeOffset" /><Property Name="EmploymentDuties" Type="Edm.String" /><Property Name="TrustNumber" Type="Edm.String" /><Property Name="RenewalNoteSentDate" Type="Edm.DateTimeOffset" /><Property Name="FeeTerminationDate" Type="Edm.DateTimeOffset" /><Property Name="AgreedToOngoingFee" Type="Edm.Boolean" /><Property Name="AgreementSignedDate" Type="Edm.DateTimeOffset" /><Property Name="InitialScopeOfAdvice" Type="Edm.String" /><Property Name="DateLastFactFindSigned" Type="Edm.DateTimeOffset" /><Property Name="DateAMLCompleted" Type="Edm.DateTimeOffset" /><Property Name="DateFSGProvided" Type="Edm.DateTimeOffset" /><Property Name="DateFirstReceivedFinancialAdvice" Type="Edm.DateTimeOffset" /><Property Name="DateOfLastSignedSOA" Type="Edm.DateTimeOffset" /><Property Name="DateOfLastSignedROA" Type="Edm.DateTimeOffset" /><Property Name="DateOfLastReview" Type="Edm.DateTimeOffset" /><Property Name="IsPoliticallyExposedIndividual" Type="Edm.Boolean" /><Property Name="InvestorRiskProfileDate" Type="Edm.DateTimeOffset" /><Property Name="ClientCategory" Type="Edm.String" /><Property Name="InvestorRiskProfile" Type="Edm.String" /><Property Name="FSGCurrentVersion" Type="Edm.String" /><Property Name="FSGCurrentVersionDate" Type="Edm.DateTimeOffset" /><Property Name="AMLCTFExpiryDate" Type="Edm.DateTimeOffset" /><Property Name="FDSRequired" Type="Edm.Boolean" /><Property Name="NextFDSDate" Type="Edm.DateTimeOffset" /><Property Name="OptInRequired" Type="Edm.Boolean" /><Property Name="OptInStatus" Type="Edm.String" /><Property Name="ServiceAgreementStatus" Type="Edm.String" /><Property Name="NextOptInDate" Type="Edm.DateTimeOffset" /><Property Name="OptInSubjectToGrandfathering" Type="Edm.Boolean" /><Property Name="DateBecameClient" Type="Edm.DateTimeOffset" /><Property Name="ReportedAnnualExpenses" Type="Edm.Decimal" Scale="Variable" /><Property Name="ReportedAnnualIncome" Type="Edm.Decimal" Scale="Variable" /><Property Name="ReportedAnnualNetIncome" Type="Edm.Decimal" Scale="Variable" /><Property Name="CRNDVANumber" Type="Edm.String" /><Property Name="CentrelinkAssessedAssets" Type="Edm.Decimal" Scale="Variable" /><Property Name="AssetValuationDate" Type="Edm.DateTimeOffset" /><Property Name="CentrelinkAssessedIncome" Type="Edm.Decimal" Scale="Variable" /><Property Name="ClientAssessedIncomeFrequency" Type="Edm.String" /><Property Name="ClientAssessedIncomeFrequencyID" Type="Edm.Int64" /><Property Name="AssessedIncomeValuationDate" Type="Edm.DateTimeOffset" /><Property Name="IsHomeOwner" Type="Edm.Boolean" /><Property Name="IsRegisteredForPensionBonusScheme" Type="Edm.Boolean" /><Property Name="HasGiftedAssets" Type="Edm.Boolean" /><Property Name="GiftedAssetDetails" Type="Edm.String" /><Property Name="IsRegisteredForCommonwealthSeniorsHealthCard" Type="Edm.Boolean" /><Property Name="TotalAnnualEntitlement" Type="Edm.Decimal" Scale="Variable" /><Property Name="ClientSocialSecurityPaymentTypes" Type="Edm.String" /><Property Name="AdviserHasCentrelinkAuthority" Type="Edm.Boolean" Nullable="false" /><Property Name="CompanyNumber" Type="Edm.String" /><Property Name="EstablishmentDate" Type="Edm.DateTimeOffset" /><Property Name="WindupDate" Type="Edm.DateTimeOffset" /><Property Name="RegisterLocation" Type="Edm.String" /><Property Name="SealLocation" Type="Edm.String" /><Property Name="BusinessName" Type="Edm.String" /><Property Name="CountryOfEstablishment" Type="Edm.String" /><Property Name="CompanyLiability" Type="Edm.String" /><Property Name="SophisticatedCertificateExpiryDate" Type="Edm.DateTimeOffset" /><Property Name="W8BENExpiryDate" Type="Edm.DateTimeOffset" /><Property Name="AgedCareTypeID" Type="Edm.Int32" /><Property Name="AgedCareType" Type="Edm.String" /><Property Name="ClientAgedCareIsHomeOwner" Type="Edm.Boolean" /><Property Name="CurrentValueOfHome" Type="Edm.Decimal" Scale="Variable" /><Property Name="AssessedAnnualIncome" Type="Edm.Decimal" Scale="Variable" /><Property Name="AssessedFinancialAssets" Type="Edm.Decimal" Scale="Variable" /><Property Name="AssessedSuperannuationAndOtherAssets" Type="Edm.Decimal" Scale="Variable" /><Property Name="AssessedTotalDebts" Type="Edm.Decimal" Scale="Variable" /><Property Name="IsLivingWithPartner" Type="Edm.Boolean" /><Property Name="HomeCarePackageReceivedID" Type="Edm.Int32" /><Property Name="HomeCarePackageReceived" Type="Edm.String" /><Property Name="DateOfEntryToAgedCare" Type="Edm.DateTimeOffset" /><Property Name="MaximumPermissibleInterestRateSetAtEntry" Type="Edm.Decimal" Scale="Variable" /><Property Name="AgedCareAssessmentTypeID" Type="Edm.Int32" /><Property Name="AgedCareAssessmentType" Type="Edm.String" /><Property Name="IsProtectedPersonLivingInHome" Type="Edm.Boolean" /><Property Name="AccommodationLumpSumPaymentRequired" Type="Edm.Decimal" Scale="Variable" /><Property Name="AccommodationLumpSumPaymentPaid" Type="Edm.Decimal" Scale="Variable" /><Property Name="AccommodationDailyFeeAmount" Type="Edm.Decimal" Scale="Variable" /><Property Name="AccommodationDailyFeeFrequencyID" Type="Edm.Int32" /><Property Name="AccommodationDailyFeeFrequency" Type="Edm.String" /><Property Name="IncomeTestedCareFeeAmount" Type="Edm.Decimal" Scale="Variable" /><Property Name="IncomeTestedCareFeeFrequencyID" Type="Edm.Int32" /><Property Name="IncomeTestedCareFeeFrequency" Type="Edm.String" /><Property Name="AnnualIncomeTestedFeeAmount" Type="Edm.Decimal" Scale="Variable" /><Property Name="LifetimeIncomeTestedFeeAmount" Type="Edm.Decimal" Scale="Variable" /><Property Name="BasicDailyFeeAmount" Type="Edm.Decimal" Scale="Variable" /><Property Name="BasicDailyFeeAmountFrequencyID" Type="Edm.Int32" /><Property Name="BasicDailyFeeAmountFrequency" Type="Edm.String" /><Property Name="MeansTestedFee" Type="Edm.Decimal" Scale="Variable" /><Property Name="MeansTestedFeeFrequencyID" Type="Edm.Int32" /><Property Name="MeansTestedFeeFrequency" Type="Edm.String" /><Property Name="AnnualMeansTestedFeeAmount" Type="Edm.Decimal" Scale="Variable" /><Property Name="LifetimeMeansTestedFeeAmount" Type="Edm.Decimal" Scale="Variable" /><Property Name="AdditionalServicesFee" Type="Edm.Decimal" Scale="Variable" /><Property Name="AdditionalServicesFeeFrequencyID" Type="Edm.Int32" /><Property Name="AdditionalServicesFeeFrequency" Type="Edm.String" /><Property Name="TotalFees" Type="Edm.Decimal" Scale="Variable" /><Property Name="TotalFeeFrequencyID" Type="Edm.Int32" /><Property Name="TotalFeeFrequency" Type="Edm.String" /><Property Name="IsAgedCareAuthority" Type="Edm.Boolean" /><Property Name="SharePointPath" Type="Edm.String" /><Property Name="HasExistingWill" Type="Edm.Boolean" /><Property Name="DateOfExistingWill" Type="Edm.DateTimeOffset" /><Property Name="DateWillLastReviewed" Type="Edm.DateTimeOffset" /><Property Name="LocationOfWill" Type="Edm.String" /><Property Name="IsProvidedForTestamentaryTrust" Type="Edm.Boolean" /><Property Name="AppointedGuardianName" Type="Edm.String" /><Property Name="HasFuneralPlan" Type="Edm.Boolean" /><Property Name="StateDocumentsPrepared" Type="Edm.String" /><Property Name="AccommodationPaymentTypes" Type="Edm.String" /><Property Name="DirectorID" Type="Edm.String" /><Property Name="XeppoCreatedDateUTC" Type="Edm.DateTimeOffset" /></EntityType><EntityType Name="ClientCompliance"><Key><PropertyRef Name="XeppoCode" /></Key><Property Name="XeppoCode" Type="Edm.Int64" Nullable="false" /><Property Name="PracticeID" Type="Edm.Int64" /><Property Name="XeppoGroupCode" Type="Edm.Int64" /><Property Name="InitialScopeOfAdvice" Type="Edm.String" /><Property Name="DateLastFactFindSigned" Type="Edm.DateTimeOffset" /><Property Name="DateAMLCompleted" Type="Edm.DateTimeOffset" /><Property Name="DateFSGProvided" Type="Edm.DateTimeOffset" /><Property Name="DateFirstReceivedFinancialAdvice" Type="Edm.DateTimeOffset" /><Property Name="DateOfLastSignedSOA" Type="Edm.DateTimeOffset" /><Property Name="DateOfLastSignedROA" Type="Edm.DateTimeOffset" /><Property Name="DateOfLastReview" Type="Edm.DateTimeOffset" /><Property Name="DateOfNextReview" Type="Edm.DateTimeOffset" /><Property Name="IsPoliticallyExposedIndividual" Type="Edm.Boolean" /><Property Name="InvestorRiskProfileDate" Type="Edm.DateTimeOffset" /><Property Name="SophisticatedCertificateExpiryDate" Type="Edm.DateTimeOffset" /><Property Name="W8BENExpiryDate" Type="Edm.DateTimeOffset" /><Property Name="ServiceAgreementSentDate" Type="Edm.DateTimeOffset" /><Property Name="ServiceAgreementResponseDate" Type="Edm.DateTimeOffset" /><Property Name="FeeConsentExpiryDate" Type="Edm.DateTimeOffset" /><Property Name="AgreementStartDate" Type="Edm.DateTimeOffset" /><Property Name="AgreementEndDate" Type="Edm.DateTimeOffset" /><Property Name="FixedTermAgreementStartDate" Type="Edm.DateTimeOffset" /><Property Name="FixedTermAgreementEndDate" Type="Edm.DateTimeOffset" /><Property Name="IsWholesaleClient" Type="Edm.Boolean" /><Property Name="DateOfWholesaleAssessment" Type="Edm.DateTimeOffset" /><Property Name="IsControllerDeclarationOnFile" Type="Edm.Boolean" /><Property Name="DateOfControllerDeclaration" Type="Edm.DateTimeOffset" /><Property Name="FSGVersionID" Type="Edm.Int32" /><Property Name="MethodFSGProvidedID" Type="Edm.Int32" /><Property Name="InvestorRiskProfileID" Type="Edm.Int32" /><Property Name="PEPRiskLevelID" Type="Edm.Int32" /><Property Name="PEPTypeID" Type="Edm.Int32" /><Property Name="ServiceAgreementStatusID" Type="Edm.Int32" /><Property Name="ServiceAgreementTypeID" Type="Edm.Int32" /><Property Name="WholesaleAssessmentID" Type="Edm.Int32" /><Property Name="ClientRiskRatingID" Type="Edm.Int32" /><Property Name="AMLCTFExpiryDate" Type="Edm.DateTimeOffset" /><Property Name="ServiceAgreementRequired" Type="Edm.Boolean" /><Property Name="ServiceAgreementAnniversaryDate" Type="Edm.DateTimeOffset" /><Property Name="AgreementSignedDate" Type="Edm.DateTimeOffset" /><Property Name="ExpectedAnnualAgreementFee" Type="Edm.Decimal" Scale="Variable" /><Property Name="FSGCurrentVersionDate" Type="Edm.DateTimeOffset" /><Property Name="LastUpdateDate" Type="Edm.DateTimeOffset" /><Property Name="FSGVersion" Type="Edm.String" /><Property Name="MethodFSGProvided" Type="Edm.String" /><Property Name="InvestorRiskProfile" Type="Edm.String" /><Property Name="PEPRiskLevel" Type="Edm.String" /><Property Name="PEPType" Type="Edm.String" /><Property Name="ServiceAgreementStatus" Type="Edm.String" /><Property Name="ServiceAgreementType" Type="Edm.String" /><Property Name="WholesaleAssessment" Type="Edm.String" /><Property Name="KeyFirmContactList" Type="Edm.String" /><Property Name="ServiceAgreementTerminationDate" Type="Edm.DateTimeOffset" /><Property Name="ClientRiskRating" Type="Edm.String" /></EntityType><EntityType Name="ClientServiceHistory"><Key><PropertyRef Name="PracticeID" /><PropertyRef Name="SourceConnectorId" /><PropertyRef Name="TempKey" /></Key><Property Name="PracticeID" Type="Edm.Int64" Nullable="false" /><Property Name="SourceConnectorId" Type="Edm.Int64" Nullable="false" /><Property Name="TempKey" Type="Edm.String" Nullable="false" /><Property Name="XeppoCode" Type="Edm.Int64" /><Property Name="ClientId" Type="Edm.String" /><Property Name="Type" Type="Edm.String" /><Property Name="SubType" Type="Edm.String" /><Property Name="AgreementStartDate" Type="Edm.DateTimeOffset" /><Property Name="DateSent" Type="Edm.DateTimeOffset" /><Property Name="DateViewedByClient" Type="Edm.DateTimeOffset" /><Property Name="ClientResponse" Type="Edm.String" /><Property Name="HasRecievedClientConsent" Type="Edm.Boolean" /><Property Name="ClientConsentDate" Type="Edm.DateTimeOffset" /><Property Name="AnnualFeesExpected" Type="Edm.Decimal" Scale="Variable" /><Property Name="AnnualFeesReceived" Type="Edm.Decimal" Scale="Variable" /><Property Name="PaymentMethod" Type="Edm.String" /><Property Name="SolePurposeTestAttestation" Type="Edm.String" /><Property Name="IsFeeTeminationConfirmed" Type="Edm.Boolean" /><Property Name="FeeTerminationDate" Type="Edm.DateTimeOffset" /><Property Name="AgreementSignedDate" Type="Edm.DateTimeOffset" /><Property Name="AgreementEndDate" Type="Edm.DateTimeOffset" /><Property Name="ServiceAgreementAnniversaryDate" Type="Edm.DateTimeOffset" /></EntityType><EntityType Name="ClientInvoice"><Key><PropertyRef Name="SourceConnectorID" /><PropertyRef Name="InvoiceID" /></Key><Property Name="SourceConnectorID" Type="Edm.Int64" Nullable="false" /><Property Name="InvoiceID" Type="Edm.String" Nullable="false" /><Property Name="XeppoCode" Type="Edm.Int64" Nullable="false" /><Property Name="ClientName" Type="Edm.String" /><Property Name="ClientCode" Type="Edm.String" /><Property Name="XeppoGroupCode" Type="Edm.Int64" /><Property Name="PracticeID" Type="Edm.Int64" Nullable="false" /><Property Name="ClientID" Type="Edm.String" /><Property Name="InvoiceNumber" Type="Edm.String" /><Property Name="Ref" Type="Edm.String" /><Property Name="Contact" Type="Edm.String" /><Property Name="Type" Type="Edm.String" /><Property Name="InvoiceDate" Type="Edm.DateTimeOffset" /><Property Name="DueDate" Type="Edm.DateTimeOffset" /><Property Name="Amount" Type="Edm.Decimal" Scale="Variable" /><Property Name="SyncID" Type="Edm.String" /><Property Name="LastUpdated" Type="Edm.DateTimeOffset" /><Property Name="ConnectorName" Type="Edm.String" /><Property Name="ConnectorMasterID" Type="Edm.Int32" /><Property Name="GroupName" Type="Edm.String" /></EntityType><EntityType Name="vwClientRanking"><Key><PropertyRef Name="XeppoCode" /></Key><Property Name="XeppoCode" Type="Edm.Int64" Nullable="false" /><Property Name="Grouping" Type="Edm.String" /><Property Name="ClientName" Type="Edm.String" /><Property Name="XeppoGroupCode" Type="Edm.Int64" /><Property Name="GroupName" Type="Edm.String" /><Property Name="PracticeID" Type="Edm.Int64" Nullable="false" /><Property Name="CommissionRank" Type="Edm.Double" /><Property Name="CommissionRankPercent" Type="Edm.Double" /><Property Name="CommissionValue" Type="Edm.Double" /><Property Name="CommissionValueAverage" Type="Edm.Double" /><Property Name="CommissionCount" Type="Edm.Double" /><Property Name="BalanceRank" Type="Edm.Double" /><Property Name="BalanceRankPercent" Type="Edm.Double" /><Property Name="BalanceValue" Type="Edm.Double" /><Property Name="BalanceValueAverage" Type="Edm.Double" /><Property Name="BalanceCount" Type="Edm.Double" /><Property Name="AgedDebtRank" Type="Edm.Double" /><Property Name="AgedDebtRankPercent" Type="Edm.Double" /><Property Name="AgedDebtValue" Type="Edm.Double" /><Property Name="AgedDebtValueAverage" Type="Edm.Double" /><Property Name="AgedDebtCount" Type="Edm.Double" /><Property Name="FeesRank" Type="Edm.Double" /><Property Name="FeesRankPercent" Type="Edm.Double" /><Property Name="FeesValue" Type="Edm.Double" /><Property Name="FeesValueAverage" Type="Edm.Double" /><Property Name="FeesCount" Type="Edm.Double" /><Property Name="FUARank" Type="Edm.Double" /><Property Name="FUARankPercent" Type="Edm.Double" /><Property Name="FUAValue" Type="Edm.Double" /><Property Name="FUAValueAverage" Type="Edm.Double" /><Property Name="FUACount" Type="Edm.Double" /><Property Name="FUMRank" Type="Edm.Double" /><Property Name="FUMRankPercent" Type="Edm.Double" /><Property Name="FUMValue" Type="Edm.Double" /><Property Name="FUMValueAverage" Type="Edm.Double" /><Property Name="FUMCount" Type="Edm.Double" /><Property Name="TaxableIncomeThisYearRank" Type="Edm.Double" /><Property Name="TaxableIncomeThisYearRankPercent" Type="Edm.Double" /><Property Name="TaxableIncomeThisYearValue" Type="Edm.Double" /><Property Name="TaxableIncomeThisYearValueAverage" Type="Edm.Double" /><Property Name="TaxableIncomeThisYearCount" Type="Edm.Double" /><Property Name="TotalIncomeThisYearRank" Type="Edm.Double" /><Property Name="TotalIncomeThisYearRankPercent" Type="Edm.Double" /><Property Name="TotalIncomeThisYearValue" Type="Edm.Double" /><Property Name="TotalIncomeThisYearValueAverage" Type="Edm.Double" /><Property Name="TotalIncomeThisYearCount" Type="Edm.Double" /><Property Name="RevenueRank" Type="Edm.Double" /><Property Name="RevenueRankPercent" Type="Edm.Double" /><Property Name="RevenueValue" Type="Edm.Double" /><Property Name="RevenueValueAverage" Type="Edm.Double" /><Property Name="RevenueCount" Type="Edm.Double" /><Property Name="LoanAmountOwingRank" Type="Edm.Double" /><Property Name="LoanAmountOwingRankPercent" Type="Edm.Double" /><Property Name="LoanAmountOwingValue" Type="Edm.Double" /><Property Name="LoanAmountOwingValueAverage" Type="Edm.Double" /><Property Name="LoanAmountOwingCount" Type="Edm.Double" /><Property Name="PO" Type="Edm.Int32" /><Property Name="KeyFirmContactList" Type="Edm.String" /><Property Name="TagNames" Type="Edm.String" /><Property Name="SMSFNetAssetsRank" Type="Edm.Double" /><Property Name="SMSFNetAssetsRankPercent" Type="Edm.Double" /><Property Name="SMSFNetAssetsValue" Type="Edm.Double" /><Property Name="SMSFNetAssetsValueAverage" Type="Edm.Double" /><Property Name="SMSFNetAssetsCount" Type="Edm.Double" /></EntityType><EntityType Name="vwClientHealth"><Key><PropertyRef Name="XeppoCode" /></Key><Property Name="XeppoCode" Type="Edm.Int64" Nullable="false" /><Property Name="XeppoGroupCode" Type="Edm.Int64" /><Property Name="PracticeID" Type="Edm.Int64" Nullable="false" /><Property Name="HealthStatusID" Type="Edm.Int32" /><Property Name="HealthStatus" Type="Edm.String" /><Property Name="HasHealthInsurance" Type="Edm.Boolean" /><Property Name="HealthConditions" Type="Edm.String" /><Property Name="FamilyHistory" Type="Edm.String" /><Property Name="Smoker" Type="Edm.String" /><Property Name="LastUpdated" Type="Edm.DateTimeOffset" /></EntityType><EntityType Name="vwClientSocialSecurity"><Key><PropertyRef Name="XeppoCode" /></Key><Property Name="XeppoCode" Type="Edm.Int64" Nullable="false" /><Property Name="PracticeID" Type="Edm.Int64" Nullable="false" /><Property Name="XeppoGroupCode" Type="Edm.Int64" /><Property Name="CRNDVANumber" Type="Edm.String" /><Property Name="AssessedIncomeValuationDate" Type="Edm.DateTimeOffset" /><Property Name="AssetValuationDate" Type="Edm.DateTimeOffset" /><Property Name="CentrelinkAssessedAssets" Type="Edm.Decimal" Scale="Variable" /><Property Name="CentrelinkAssessedIncome" Type="Edm.Decimal" Scale="Variable" /><Property Name="GiftedAssetDetails" Type="Edm.String" /><Property Name="HasGiftedAssets" Type="Edm.Boolean" /><Property Name="IsHomeOwner" Type="Edm.Boolean" /><Property Name="IsRegisteredForCommonwealthSeniorsHealthCard" Type="Edm.Boolean" /><Property Name="IsRegisteredForPensionBonusScheme" Type="Edm.Boolean" /><Property Name="TotalAnnualEntitlement" Type="Edm.Decimal" Scale="Variable" /><Property Name="AdviserHasCentrelinkAuthority" Type="Edm.Boolean" Nullable="false" /><Property Name="ClientAssessedIncomeFrequencyID" Type="Edm.Int64" /><Property Name="ClientAssessedIncomeFrequency" Type="Edm.String" /></EntityType><EntityType Name="vwClientSocialSecurityPaymentTypesReceived"><Key><PropertyRef Name="XeppoCode" /><PropertyRef Name="ClientPaymentTypeReceivedID" /></Key><Property Name="XeppoCode" Type="Edm.Int64" Nullable="false" /><Property Name="ClientPaymentTypeReceivedID" Type="Edm.Int64" Nullable="false" /><Property Name="PracticeID" Type="Edm.Int64" Nullable="false" /><Property Name="ClientPaymentTypeReceived" Type="Edm.String" /></EntityType><EntityType Name="Commission"><Key><PropertyRef Name="SourceConnectorID" /><PropertyRef Name="TempKey" /></Key><Property Name="SourceConnectorID" Type="Edm.Int64" Nullable="false" /><Property Name="TempKey" Type="Edm.String" Nullable="false" /><Property Name="XeppoCode" Type="Edm.Int64" Nullable="false" /><Property Name="PracticeID" Type="Edm.Int64" Nullable="false" /><Property Name="StatementNumber" Type="Edm.String" /><Property Name="StatementRecordDate" Type="Edm.DateTimeOffset" /><Property Name="Provider" Type="Edm.String" /><Property Name="PolicyNumber" Type="Edm.String" /><Property Name="ClientID" Type="Edm.String" /><Property Name="ClientName" Type="Edm.String" /><Property Name="ProductName" Type="Edm.String" /><Property Name="ProductType" Type="Edm.String" /><Property Name="ProductClassification" Type="Edm.String" /><Property Name="MainRevenue" Type="Edm.String" /><Property Name="RevenueType" Type="Edm.String" /><Property Name="Gross" Type="Edm.Decimal" Scale="Variable" /><Property Name="Net" Type="Edm.Decimal" Scale="Variable" /><Property Name="Tax" Type="Edm.Decimal" Scale="Variable" /><Property Name="AdviserName" Type="Edm.String" /><Property Name="AdviserCode" Type="Edm.String" /><Property Name="SyncID" Type="Edm.String" /><Property Name="LastUpdated" Type="Edm.DateTimeOffset" /><Property Name="XeppoGroupCode" Type="Edm.Int64" /><Property Name="ClientCode" Type="Edm.String" /><Property Name="FeeCategorySourceID" Type="Edm.String" /><Property Name="FeeCategoryName" Type="Edm.String" /><Property Name="GroupName" Type="Edm.String" /><Property Name="ClientStatusID" Type="Edm.Int64" /><Property Name="PaymentPeriodName" Type="Edm.String" /><Property Name="PaymentPeriodEnd" Type="Edm.DateTimeOffset" /><Property Name="ContraNet" Type="Edm.Decimal" Scale="Variable" /><Property Name="ContraGross" Type="Edm.Decimal" Scale="Variable" /><Property Name="ContraTax" Type="Edm.Decimal" Scale="Variable" /><Property Name="PracticeName" Type="Edm.String" /><Property Name="Licensee" Type="Edm.String" /></EntityType><EntityType Name="ContactDetail"><Key><PropertyRef Name="SourceConnectorID" /><PropertyRef Name="ContactDetailID" /></Key><Property Name="SourceConnectorID" Type="Edm.Int64" Nullable="false" /><Property Name="ContactDetailID" Type="Edm.String" Nullable="false" /><Property Name="XeppoCode" Type="Edm.Int64" Nullable="false" /><Property Name="PracticeID" Type="Edm.Int64" Nullable="false" /><Property Name="ClientID" Type="Edm.String" /><Property Name="GroupID" Type="Edm.String" /><Property Name="ContactType" Type="Edm.String" /><Property Name="Value" Type="Edm.String" /><Property Name="Preferred" Type="Edm.Boolean" /><Property Name="ClientName" Type="Edm.String" /><Property Name="ClientCode" Type="Edm.String" /><Property Name="SyncID" Type="Edm.String" /><Property Name="LastUpdated" Type="Edm.DateTimeOffset" /><Property Name="XeppoGroupCode" Type="Edm.Int64" /><Property Name="GroupName" Type="Edm.String" /></EntityType><EntityType Name="ContributionLimit"><Key><PropertyRef Name="SourceConnectorID" /><PropertyRef Name="ContributionLimitID" /></Key><Property Name="SourceConnectorID" Type="Edm.Int64" Nullable="false" /><Property Name="ContributionLimitID" Type="Edm.String" Nullable="false" /><Property Name="XeppoCode" Type="Edm.Int64" Nullable="false" /><Property Name="PracticeID" Type="Edm.Int64" Nullable="false" /><Property Name="FinancialYear" Type="Edm.String" /><Property Name="LimitType" Type="Edm.String" /><Property Name="LimitPeriod" Type="Edm.String" /><Property Name="ClientID" Type="Edm.String" /><Property Name="Amount" Type="Edm.String" /><Property Name="GroupID" Type="Edm.String" /><Property Name="FundID" Type="Edm.String" /><Property Name="MemberNumber" Type="Edm.String" /><Property Name="EntitySourceConnector" Type="Edm.String" /><Property Name="XeppoGroupCode" Type="Edm.Int64" /><Property Name="SyncID" Type="Edm.String" /><Property Name="LastUpdated" Type="Edm.DateTimeOffset" /><Property Name="ClientName" Type="Edm.String" /><Property Name="ClientCode" Type="Edm.String" /><Property Name="Limit" Type="Edm.String" /><Property Name="GroupName" Type="Edm.String" /><Property Name="ClientStatusID" Type="Edm.Int64" /></EntityType><EntityType Name="Connector"><Key><PropertyRef Name="ConnectorID" /></Key><Property Name="ConnectorID" Type="Edm.Int64" Nullable="false" /><Property Name="ConnectorName" Type="Edm.String" /><Property Name="Description" Type="Edm.String" /><Property Name="Enabled" Type="Edm.Boolean" /><Property Name="Category" Type="Edm.String" /><Property Name="ConnectorMasterID" Type="Edm.Int32" /><Property Name="ConnectorMasterName" Type="Edm.String" /><Property Name="PracticeID" Type="Edm.Int64" /><Property Name="LastRunDate" Type="Edm.DateTimeOffset" /><Property Name="PracticeName" Type="Edm.String" /><Property Name="LastRunWasSuccess" Type="Edm.Boolean" /></EntityType><EntityType Name="Dependant"><Key><PropertyRef Name="XeppoCode" /><PropertyRef Name="XeppoDependantID" /></Key><Property Name="XeppoCode" Type="Edm.Int64" Nullable="false" /><Property Name="XeppoDependantID" Type="Edm.Int64" Nullable="false" /><Property Name="DependantID" Type="Edm.String" /><Property Name="SourceConnectorID" Type="Edm.Int64" /><Property Name="PracticeID" Type="Edm.Int64" Nullable="false" /><Property Name="ClientID" Type="Edm.String" /><Property Name="Title" Type="Edm.String" /><Property Name="FirstName" Type="Edm.String" /><Property Name="LastName" Type="Edm.String" /><Property Name="DateOfBirth" Type="Edm.DateTimeOffset" /><Property Name="Relationship" Type="Edm.String" /><Property Name="Gender" Type="Edm.String" /><Property Name="FinancialDependant" Type="Edm.String" /><Property Name="DependantUntilAge" Type="Edm.String" /><Property Name="Age" Type="Edm.Int32" /><Property Name="GroupID" Type="Edm.String" /><Property Name="XeppoGroupCode" Type="Edm.Int64" /><Property Name="SyncID" Type="Edm.String" /><Property Name="LastUpdated" Type="Edm.DateTimeOffset" /><Property Name="ClientName" Type="Edm.String" /><Property Name="ClientCode" Type="Edm.String" /><Property Name="GroupName" Type="Edm.String" /><Property Name="ClientStatusID" Type="Edm.Int64" /><Property Name="RelatedClients" Type="Edm.String" /><Property Name="DependantGroupingID" Type="Edm.String" /><Property Name="ConnectorName" Type="Edm.String" /><Property Name="ConnectorList" Type="Edm.String" /><Property Name="AdditionalComments" Type="Edm.String" /></EntityType><EntityType Name="Expense"><Key><PropertyRef Name="ExpenseID" /></Key><Property Name="ExpenseID" Type="Edm.String" Nullable="false" /><Property Name="ClientName" Type="Edm.String" /><Property Name="ClientCode" Type="Edm.String" /><Property Name="OwnerClients" Type="Edm.String" /><Property Name="XeppoGroupCode" Type="Edm.Int64" /><Property Name="GroupName" Type="Edm.String" /><Property Name="SourceConnectorID" Type="Edm.Int64" /><Property Name="ClientID" Type="Edm.String" /><Property Name="XeppoCode" Type="Edm.Int64" Nullable="false" /><Property Name="PracticeID" Type="Edm.Int64" Nullable="false" /><Property Name="Description" Type="Edm.String" /><Property Name="ExpenseTypeID" Type="Edm.Int16" /><Property Name="ExpenseSubtypeID" Type="Edm.Int16" /><Property Name="Amount" Type="Edm.Decimal" Scale="Variable" /><Property Name="TaxTypeID" Type="Edm.Int16" /><Property Name="FrequencyID" Type="Edm.Int16" /><Property Name="Cost" Type="Edm.Boolean" /><Property Name="LastUpdated" Type="Edm.DateTimeOffset" /><Property Name="RecordDate" Type="Edm.DateTimeOffset" /><Property Name="Subtype" Type="Edm.String" /><Property Name="Owner" Type="Edm.String" /><Property Name="Frequency" Type="Edm.String" /><Property Name="TaxType" Type="Edm.String" /><Property Name="Type" Type="Edm.String" /><Property Name="SyncID" Type="Edm.String" /><Property Name="ConnectorList" Type="Edm.String" /><Property Name="XeppoExpenseID" Type="Edm.Int64" Nullable="false" /><Property Name="IsActualData" Type="Edm.Boolean" /><Property Name="ExpenseGroupingID" Type="Edm.String" /><Property Name="ParentExpenseID" Type="Edm.String" /><Property Name="AnnualAmount" Type="Edm.Decimal" Scale="Variable" /><Property Name="TotalAnnualAmount" Type="Edm.Decimal" Scale="Variable" /><Property Name="ClientStatusID" Type="Edm.Int64" /><Property Name="ConnectorName" Type="Edm.String" /><Property Name="IsJoint" Type="Edm.Boolean" /></EntityType><EntityType Name="Fee"><Key><PropertyRef Name="SourceConnectorID" /><PropertyRef Name="FeeID" /></Key><Property Name="SourceConnectorID" Type="Edm.Int64" Nullable="false" /><Property Name="FeeID" Type="Edm.String" Nullable="false" /><Property Name="XeppoCode" Type="Edm.Int64" Nullable="false" /><Property Name="PracticeID" Type="Edm.Int64" Nullable="false" /><Property Name="ClientID" Type="Edm.String" /><Property Name="InvoiceID" Type="Edm.String" /><Property Name="InvoiceNo" Type="Edm.String" /><Property Name="Val" Type="Edm.Double" /><Property Name="Fees" Type="Edm.Double" /><Property Name="Writeoff" Type="Edm.Double" /><Property Name="GroupID" Type="Edm.String" /><Property Name="Net" Type="Edm.Decimal" Scale="Variable" /><Property Name="Tax" Type="Edm.Decimal" Scale="Variable" /><Property Name="Gross" Type="Edm.Decimal" Scale="Variable" /><Property Name="XeppoGroupCode" Type="Edm.Int64" /><Property Name="SyncID" Type="Edm.String" /><Property Name="LastUpdated" Type="Edm.DateTimeOffset" /><Property Name="ClientName" Type="Edm.String" /><Property Name="ClientCode" Type="Edm.String" /><Property Name="FeeCategorySourceID" Type="Edm.String" /><Property Name="FeeCategoryName" Type="Edm.String" /><Property Name="GroupName" Type="Edm.String" /><Property Name="ClientStatusID" Type="Edm.Int64" /><Property Name="TimeEntryInvoiceID" Type="Edm.String" /><Property Name="InvoiceStatus" Type="Edm.String" /></EntityType><EntityType Name="Group"><Key><PropertyRef Name="XeppoGroupCode" /></Key><Property Name="XeppoGroupCode" Type="Edm.Int64" Nullable="false" /><Property Name="GroupID" Type="Edm.String" /><Property Name="SourceConnectorID" Type="Edm.Int64" /><Property Name="PracticeID" Type="Edm.Int64" Nullable="false" /><Property Name="Code" Type="Edm.String" /><Property Name="GroupName" Type="Edm.String" /><Property Name="ClientStatus_CRM" Type="Edm.String" /><Property Name="DateBecameClient" Type="Edm.DateTimeOffset" /><Property Name="ClientClass_CRM" Type="Edm.String" /><Property Name="ClientType_CRM" Type="Edm.String" /><Property Name="PreferredClientContact_CRM" Type="Edm.String" /><Property Name="CurrentWIP_TOTAL" Type="Edm.Decimal" Scale="Variable" /><Property Name="DebtorsOutstanding_TOTAL" Type="Edm.Decimal" Scale="Variable" /><Property Name="TotalLockup_TOTAL" Type="Edm.Decimal" Scale="Variable" /><Property Name="OldestUnpaidInvoice_TOTAL" Type="Edm.Int32" /><Property Name="TotalFUM_TOTAL" Type="Edm.Decimal" Scale="Variable" /><Property Name="TotalAdviceFUA_TOTAL" Type="Edm.Decimal" Scale="Variable" /><Property Name="TotalAssets_TOTAL" Type="Edm.Decimal" Scale="Variable" /><Property Name="TotalLiabilities_TOTAL" Type="Edm.Decimal" Scale="Variable" /><Property Name="NetWorth_TOTAL" Type="Edm.Decimal" Scale="Variable" /><Property Name="TotalIncomeThisYear_TOTAL" Type="Edm.Decimal" Scale="Variable" /><Property Name="TotalIncomeLastYear_TOTAL" Type="Edm.Decimal" Scale="Variable" /><Property Name="TaxableIncomeLastYear_TOTAL" Type="Edm.Decimal" Scale="Variable" /><Property Name="TaxableIncomeThisYear_TOTAL" Type="Edm.Decimal" Scale="Variable" /><Property Name="AnnualInsurancePremiums_TOTAL" Type="Edm.Decimal" Scale="Variable" /><Property Name="LifeSumInsured_TOTAL" Type="Edm.Decimal" Scale="Variable" /><Property Name="TraumaSumInsured_TOTAL" Type="Edm.Decimal" Scale="Variable" /><Property Name="TPDSumInsured_TOTAL" Type="Edm.Decimal" Scale="Variable" /><Property Name="IncomeProtectionMonthlyBenefit_TOTAL" Type="Edm.Decimal" Scale="Variable" /><Property Name="BusinessExpenseMonthlyBenefit_TOTAL" Type="Edm.Decimal" Scale="Variable" /><Property Name="OtherSumInsured_TOTAL" Type="Edm.Decimal" Scale="Variable" /><Property Name="IncomeYTD_TOTAL" Type="Edm.Decimal" Scale="Variable" /><Property Name="ExpensesYTD_TOTAL" Type="Edm.Decimal" Scale="Variable" /><Property Name="CashAtBank_TOTAL" Type="Edm.Decimal" Scale="Variable" /><Property Name="XeroTotalAssets_TOTAL" Type="Edm.Decimal" Scale="Variable" /><Property Name="XeroTotalLiabilities_TOTAL" Type="Edm.Decimal" Scale="Variable" /><Property Name="XeroTotalDebtors_TOTAL" Type="Edm.Decimal" Scale="Variable" /><Property Name="Industry" Type="Edm.String" /><Property Name="Website" Type="Edm.String" /><Property Name="ReferredBy" Type="Edm.String" /><Property Name="ClientRefersClients" Type="Edm.String" /><Property Name="TotalFPHoldings_TOTAL" Type="Edm.Decimal" Scale="Variable" /><Property Name="TotalSMSFHoldings_TOTAL" Type="Edm.Decimal" Scale="Variable" /><Property Name="APS_CHECK" Type="Edm.Boolean" /><Property Name="XPLAN_CHECK" Type="Edm.Boolean" /><Property Name="ClassSuper_CHECK" Type="Edm.Boolean" /><Property Name="BGLCAS_CHECK" Type="Edm.Boolean" /><Property Name="Worksorted_CHECK" Type="Edm.Boolean" /><Property Name="Xero_CHECK" Type="Edm.Boolean" /><Property Name="TotalDebt_TOTAL" Type="Edm.Decimal" Scale="Variable" /><Property Name="NoOfEmployees" Type="Edm.Int32" /><Property Name="MYOB_CHECK" Type="Edm.Boolean" /><Property Name="CostOfSalesYTD_TOTAL" Type="Edm.Decimal" Scale="Variable" /><Property Name="OtherIncomeYTD_TOTAL" Type="Edm.Decimal" Scale="Variable" /><Property Name="GrossProfitYTD_TOTAL" Type="Edm.Decimal" Scale="Variable" /><Property Name="XeroNetAssets_TOTAL" Type="Edm.Decimal" Scale="Variable" /><Property Name="TotalEquity_TOTAL" Type="Edm.Decimal" Scale="Variable" /><Property Name="XeroCurrentAssets_TOTAL" Type="Edm.Decimal" Scale="Variable" /><Property Name="TotalFeesYTD_TOTAL" Type="Edm.Decimal" Scale="Variable" /><Property Name="TotalFeesPrev_TOTAL" Type="Edm.Decimal" Scale="Variable" /><Property Name="TotalFeesPrev2_TOTAL" Type="Edm.Decimal" Scale="Variable" /><Property Name="NetProfitYTD_TOTAL" Type="Edm.Decimal" Scale="Variable" /><Property Name="TotalCommissionYTD_TOTAL" Type="Edm.Decimal" Scale="Variable" /><Property Name="TotalRevenueYTD_TOTAL" Type="Edm.Decimal" Scale="Variable" /><Property Name="TotalNewBusinessYTD_TOTAL" Type="Edm.Decimal" Scale="Variable" /><Property Name="TotalOngoingYTD_TOTAL" Type="Edm.Decimal" Scale="Variable" /><Property Name="Commpay_CHECK" Type="Edm.Boolean" /><Property Name="WorkflowMax_CHECK" Type="Edm.Boolean" /><Property Name="LoanAmountBorrowed_TOTAL" Type="Edm.Decimal" Scale="Variable" /><Property Name="LoanAmountOwing_TOTAL" Type="Edm.Decimal" Scale="Variable" /><Property Name="ClassTotalAssets_TOTAL" Type="Edm.Decimal" Scale="Variable" /><Property Name="ClassTotalLiabilities_TOTAL" Type="Edm.Decimal" Scale="Variable" /><Property Name="ClassNetAssets_TOTAL" Type="Edm.Decimal" Scale="Variable" /><Property Name="DebtorsOverdue_TOTAL" Type="Edm.Decimal" Scale="Variable" /><Property Name="TotalQuote_TOTAL" Type="Edm.Decimal" Scale="Variable" /><Property Name="TotalQuoteIssued_TOTAL" Type="Edm.Decimal" Scale="Variable" /><Property Name="TotalQuoteDraft_TOTAL" Type="Edm.Decimal" Scale="Variable" /><Property Name="TotalCommissionPrev_TOTAL" Type="Edm.Decimal" Scale="Variable" /><Property Name="KeyFirmContactList" Type="Edm.String" /><Property Name="VerifiedBy" Type="Edm.String" /><Property Name="VerifiedDate" Type="Edm.DateTimeOffset" /><Property Name="VerifiedStatusID" Type="Edm.Int16" Nullable="false" /><Property Name="VerifiedStatus" Type="Edm.String" /><Property Name="TagNames" Type="Edm.String" /><Property Name="HasPrimaryContact" Type="Edm.Boolean" /><Property Name="PrimaryContacts" Type="Edm.String" /><Property Name="MoneySoftLoanAmountOwing_TOTAL" Type="Edm.Decimal" Scale="Variable" /><Property Name="MoneySoft_CHECK" Type="Edm.Boolean" Nullable="false" /><Property Name="MoneySoftNetWorth_TOTAL" Type="Edm.Decimal" Scale="Variable" /><Property Name="MoneySoftInvestments_TOTAL" Type="Edm.Decimal" Scale="Variable" /><Property Name="MoneySoftBankAccounts_TOTAL" Type="Edm.Decimal" Scale="Variable" /><Property Name="MoneySoftCreditCards_TOTAL" Type="Edm.Decimal" Scale="Variable" /><Property Name="MoneySoftPropoerties_TOTAL" Type="Edm.Decimal" Scale="Variable" /><Property Name="TotalWages_TOTAL" Type="Edm.Decimal" Scale="Variable" /><Property Name="MoneySoftVehicles_TOTAL" Type="Edm.Decimal" Scale="Variable" /><Property Name="MoneySoftOtherAsset_TOTAL" Type="Edm.Decimal" Scale="Variable" /><Property Name="MoneySoftOtherLoyalty_TOTAL" Type="Edm.Decimal" Scale="Variable" /><Property Name="MoneySoftOtherLiability_TOTAL" Type="Edm.Decimal" Scale="Variable" /><Property Name="ReportedAnnualExpenses_TOTAL" Type="Edm.Decimal" Scale="Variable" /><Property Name="ReportedAnnualIncome_TOTAL" Type="Edm.Decimal" Scale="Variable" /><Property Name="ReportedAnnualNetIncome_TOTAL" Type="Edm.Decimal" Scale="Variable" /><Property Name="SharePointPath" Type="Edm.String" /><Property Name="SharePointWebUrl" Type="Edm.String" /><Property Name="Status" Type="Edm.String" /><Property Name="StatusID" Type="Edm.Int64" /><Property Name="IsProtectedGrouping" Type="Edm.Boolean" /><Property Name="XeppoCreatedDateUTC" Type="Edm.DateTimeOffset" /><Property Name="LastUpdatedDateUTC" Type="Edm.DateTimeOffset" /></EntityType><EntityType Name="Holding"><Key><PropertyRef Name="SourceConnectorID" /><PropertyRef Name="TempKey" /></Key><Property Name="SourceConnectorID" Type="Edm.Int64" Nullable="false" /><Property Name="TempKey" Type="Edm.String" Nullable="false" /><Property Name="XeppoCode" Type="Edm.Int64" Nullable="false" /><Property Name="ClientName" Type="Edm.String" /><Property Name="ClientCode" Type="Edm.String" /><Property Name="XeppoGroupCode" Type="Edm.Int64" /><Property Name="GroupName" Type="Edm.String" /><Property Name="PracticeID" Type="Edm.Int64" Nullable="false" /><Property Name="AssetName" Type="Edm.String" /><Property Name="AssetClass" Type="Edm.String" /><Property Name="ClientID" Type="Edm.String" /><Property Name="Exchange" Type="Edm.String" /><Property Name="GroupID" Type="Edm.String" /><Property Name="HoldingsID" Type="Edm.String" /><Property Name="LastUpdated" Type="Edm.DateTimeOffset" /><Property Name="PortfolioName" Type="Edm.String" /><Property Name="SubfundDescription" Type="Edm.String" /><Property Name="SubfundId" Type="Edm.String" /><Property Name="SyncID" Type="Edm.String" /><Property Name="Units" Type="Edm.String" /><Property Name="Value" Type="Edm.Decimal" Scale="Variable" /><Property Name="ConnectorName" Type="Edm.String" /><Property Name="ConnectorMasterID" Type="Edm.Int32" /><Property Name="ClientStatusID" Type="Edm.Int64" /><Property Name="IsUnderManagement" Type="Edm.Boolean" Nullable="false" /><Property Name="Code" Type="Edm.String" /><Property Name="AssetCode" Type="Edm.String" /><Property Name="Vendor" Type="Edm.String" /><Property Name="AccountNumber" Type="Edm.String" /></EntityType><EntityType Name="Income"><Key><PropertyRef Name="IncomeID" /></Key><Property Name="IncomeID" Type="Edm.String" Nullable="false" /><Property Name="ClientName" Type="Edm.String" /><Property Name="ClientCode" Type="Edm.String" /><Property Name="OwnerClients" Type="Edm.String" /><Property Name="XeppoGroupCode" Type="Edm.Int64" /><Property Name="GroupName" Type="Edm.String" /><Property Name="SourceConnectorID" Type="Edm.Int64" /><Property Name="ClientID" Type="Edm.String" /><Property Name="XeppoCode" Type="Edm.Int64" Nullable="false" /><Property Name="PracticeID" Type="Edm.Int64" Nullable="false" /><Property Name="Description" Type="Edm.String" /><Property Name="IncomeTypeID" Type="Edm.Int16" /><Property Name="IncomeSubtypeID" Type="Edm.Int16" /><Property Name="Amount" Type="Edm.Decimal" Scale="Variable" /><Property Name="TaxableIncome" Type="Edm.Boolean" /><Property Name="FrequencyID" Type="Edm.Int16" /><Property Name="Gross" Type="Edm.Boolean" /><Property Name="LastUpdated" Type="Edm.DateTimeOffset" /><Property Name="RecordDate" Type="Edm.DateTimeOffset" /><Property Name="IsActualData" Type="Edm.Boolean" /><Property Name="ParentIncomeID" Type="Edm.String" /><Property Name="IncomeGroupingID" Type="Edm.String" /><Property Name="Frequency" Type="Edm.String" /><Property Name="IncomeSubtype" Type="Edm.String" /><Property Name="Owner" Type="Edm.String" /><Property Name="IncomeType" Type="Edm.String" /><Property Name="SyncID" Type="Edm.String" /><Property Name="ConnectorList" Type="Edm.String" /><Property Name="XeppoIncomeID" Type="Edm.Int64" Nullable="false" /><Property Name="AnnualAmount" Type="Edm.Decimal" Scale="Variable" /><Property Name="TotalAnnualAmount" Type="Edm.Decimal" Scale="Variable" /><Property Name="ClientStatusID" Type="Edm.Int64" /><Property Name="ConnectorName" Type="Edm.String" /><Property Name="IsJoint" Type="Edm.Boolean" /></EntityType><EntityType Name="InsuranceCover"><Key><PropertyRef Name="SourceConnectorID" /><PropertyRef Name="TempKey" /></Key><Property Name="SourceConnectorID" Type="Edm.Int64" Nullable="false" /><Property Name="TempKey" Type="Edm.String" Nullable="false" /><Property Name="XeppoCode" Type="Edm.Int64" Nullable="false" /><Property Name="ClientName" Type="Edm.String" /><Property Name="ClientCode" Type="Edm.String" /><Property Name="XeppoGroupCode" Type="Edm.Int64" /><Property Name="GroupName" Type="Edm.String" /><Property Name="PracticeID" Type="Edm.Int64" Nullable="false" /><Property Name="ClientID" Type="Edm.String" /><Property Name="CoverName" Type="Edm.String" /><Property Name="CoverDescription" Type="Edm.String" /><Property Name="SumInsured" Type="Edm.Decimal" Scale="Variable" /><Property Name="SyncID" Type="Edm.String" /><Property Name="InsurancePolicyTempKey" Type="Edm.String" /><Property Name="LastUpdated" Type="Edm.DateTimeOffset" /><Property Name="ClientStatusID" Type="Edm.Int64" /><Property Name="BenefitAmount" Type="Edm.Decimal" Scale="Variable" /><Property Name="BenefitIndexationType" Type="Edm.String" /><Property Name="BenefitIndexationValue" Type="Edm.Decimal" Scale="Variable" /><Property Name="LifeInsured" Type="Edm.String" /><Property Name="IPWaitingPeriod" Type="Edm.String" /><Property Name="IPBenefitPeriod" Type="Edm.String" /><Property Name="Exclusions" Type="Edm.String" /><Property Name="Loadings" Type="Edm.Decimal" Scale="Variable" /><Property Name="PremiumStructure" Type="Edm.String" /><Property Name="BenefitPeriod" Type="Edm.String" /><Property Name="BenefitStatus" Type="Edm.String" /><Property Name="CoverSubtype" Type="Edm.String" /><Property Name="CoverType" Type="Edm.String" /><Property Name="IPDefinition" Type="Edm.String" /><Property Name="TPDWaitingPeriod" Type="Edm.String" /><Property Name="BenefitFrequency" Type="Edm.String" /><Property Name="CoverNotes" Type="Edm.String" /><Property Name="LoadingNotes" Type="Edm.String" /><Property Name="IsSuperannuation" Type="Edm.Boolean" /><Property Name="IsFlexiLinked" Type="Edm.Boolean" /><Property Name="CoverTypeID" Type="Edm.Int16" /><Property Name="BenefitAmountAnnualised" Type="Edm.Decimal" Scale="Variable" /><Property Name="BenefitAmountMonthly" Type="Edm.Decimal" Scale="Variable" /><Property Name="PolicyOwner" Type="Edm.String" /><Property Name="PolicyNumber" Type="Edm.String" /><Property Name="XeppoInsurancePolicyID" Type="Edm.Int64" /></EntityType><EntityType Name="InsuranceCoverRestricted"><Key><PropertyRef Name="SourceConnectorID" /><PropertyRef Name="TempKey" /></Key><Property Name="SourceConnectorID" Type="Edm.Int64" Nullable="false" /><Property Name="TempKey" Type="Edm.String" Nullable="false" /><Property Name="XeppoCode" Type="Edm.Int64" Nullable="false" /><Property Name="ClientName" Type="Edm.String" /><Property Name="ClientCode" Type="Edm.String" /><Property Name="XeppoGroupCode" Type="Edm.Int64" /><Property Name="GroupName" Type="Edm.String" /><Property Name="PracticeID" Type="Edm.Int64" Nullable="false" /><Property Name="ClientID" Type="Edm.String" /><Property Name="CoverName" Type="Edm.String" /><Property Name="CoverDescription" Type="Edm.String" /><Property Name="SumInsured" Type="Edm.Decimal" Scale="Variable" /><Property Name="SyncID" Type="Edm.String" /><Property Name="InsurancePolicyTempKey" Type="Edm.String" /><Property Name="LastUpdated" Type="Edm.DateTimeOffset" /><Property Name="ClientStatusID" Type="Edm.Int64" /><Property Name="BenefitAmount" Type="Edm.Decimal" Scale="Variable" /><Property Name="BenefitIndexationType" Type="Edm.String" /><Property Name="BenefitIndexationValue" Type="Edm.Decimal" Scale="Variable" /><Property Name="LifeInsured" Type="Edm.String" /><Property Name="IPWaitingPeriod" Type="Edm.String" /><Property Name="IPBenefitPeriod" Type="Edm.String" /><Property Name="Exclusions" Type="Edm.String" /><Property Name="Loadings" Type="Edm.Decimal" Scale="Variable" /><Property Name="PremiumStructure" Type="Edm.String" /><Property Name="BenefitPeriod" Type="Edm.String" /><Property Name="BenefitStatus" Type="Edm.String" /><Property Name="CoverSubtype" Type="Edm.String" /><Property Name="CoverType" Type="Edm.String" /><Property Name="IPDefinition" Type="Edm.String" /><Property Name="TPDWaitingPeriod" Type="Edm.String" /><Property Name="BenefitFrequency" Type="Edm.String" /><Property Name="CoverNotes" Type="Edm.String" /><Property Name="LoadingNotes" Type="Edm.String" /><Property Name="IsSuperannuation" Type="Edm.Boolean" /><Property Name="IsFlexiLinked" Type="Edm.Boolean" /><Property Name="CoverTypeID" Type="Edm.Int16" /><Property Name="BenefitAmountAnnualised" Type="Edm.Decimal" Scale="Variable" /><Property Name="BenefitAmountMonthly" Type="Edm.Decimal" Scale="Variable" /><Property Name="PolicyOwner" Type="Edm.String" /><Property Name="PolicyNumber" Type="Edm.String" /><Property Name="XeppoInsurancePolicyID" Type="Edm.Int64" /></EntityType><EntityType Name="InsurancePolicy"><Key><PropertyRef Name="XeppoInsurancePolicyID" /></Key><Property Name="XeppoInsurancePolicyID" Type="Edm.Int64" Nullable="false" /><Property Name="XeppoCode" Type="Edm.Int64" Nullable="false" /><Property Name="ClientName" Type="Edm.String" /><Property Name="ClientCode" Type="Edm.String" /><Property Name="XeppoGroupCode" Type="Edm.Int64" /><Property Name="GroupName" Type="Edm.String" /><Property Name="PracticeID" Type="Edm.Int64" Nullable="false" /><Property Name="ClientID" Type="Edm.String" /><Property Name="IssueStatus" Type="Edm.String" /><Property Name="LastUpdated" Type="Edm.DateTimeOffset" /><Property Name="PolicyEndDate" Type="Edm.DateTimeOffset" /><Property Name="PolicyNumber" Type="Edm.String" /><Property Name="PolicyOwner" Type="Edm.String" /><Property Name="PolicyStartDate" Type="Edm.DateTimeOffset" /><Property Name="Premium" Type="Edm.Decimal" Scale="Variable" /><Property Name="ProductName" Type="Edm.String" /><Property Name="Provider" Type="Edm.String" /><Property Name="SourceConnectorID" Type="Edm.Int64" Nullable="false" /><Property Name="SyncID" Type="Edm.String" /><Property Name="TempKey" Type="Edm.String" /><Property Name="InsuranceGroupUnderAdvice" Type="Edm.Boolean" Nullable="false" /><Property Name="ClientStatusID" Type="Edm.Int64" /><Property Name="PolicyType" Type="Edm.String" /><Property Name="NextReviewDate" Type="Edm.DateTimeOffset" /><Property Name="PremiumPaidViaSuperannuation" Type="Edm.Decimal" Scale="Variable" /><Property Name="PremiumPaidViaNonSuperannuation" Type="Edm.Decimal" Scale="Variable" /><Property Name="PremiumPayer" Type="Edm.String" /><Property Name="InstalmentPremium" Type="Edm.Decimal" Scale="Variable" /><Property Name="Frequency" Type="Edm.String" /><Property Name="PolicyCovers" Type="Edm.String" /><Property Name="PolicyOwnerXeppoCode" Type="Edm.Int64" /><Property Name="PolicyNotes" Type="Edm.String" /><Property Name="AccountNumber" Type="Edm.String" /></EntityType><EntityType Name="InsurancePolicyRestricted"><Key><PropertyRef Name="XeppoInsurancePolicyID" /></Key><Property Name="XeppoInsurancePolicyID" Type="Edm.Int64" Nullable="false" /><Property Name="XeppoCode" Type="Edm.Int64" Nullable="false" /><Property Name="ClientName" Type="Edm.String" /><Property Name="ClientCode" Type="Edm.String" /><Property Name="XeppoGroupCode" Type="Edm.Int64" /><Property Name="GroupName" Type="Edm.String" /><Property Name="PracticeID" Type="Edm.Int64" Nullable="false" /><Property Name="ClientID" Type="Edm.String" /><Property Name="IssueStatus" Type="Edm.String" /><Property Name="LastUpdated" Type="Edm.DateTimeOffset" /><Property Name="PolicyEndDate" Type="Edm.DateTimeOffset" /><Property Name="PolicyNumber" Type="Edm.String" /><Property Name="PolicyOwner" Type="Edm.String" /><Property Name="PolicyStartDate" Type="Edm.DateTimeOffset" /><Property Name="Premium" Type="Edm.Decimal" Scale="Variable" /><Property Name="ProductName" Type="Edm.String" /><Property Name="Provider" Type="Edm.String" /><Property Name="SourceConnectorID" Type="Edm.Int64" Nullable="false" /><Property Name="SyncID" Type="Edm.String" /><Property Name="TempKey" Type="Edm.String" /><Property Name="InsuranceGroupUnderAdvice" Type="Edm.Boolean" Nullable="false" /><Property Name="ClientStatusID" Type="Edm.Int64" /><Property Name="PolicyType" Type="Edm.String" /><Property Name="NextReviewDate" Type="Edm.DateTimeOffset" /><Property Name="PremiumPaidViaSuperannuation" Type="Edm.Decimal" Scale="Variable" /><Property Name="PremiumPaidViaNonSuperannuation" Type="Edm.Decimal" Scale="Variable" /><Property Name="PremiumPayer" Type="Edm.String" /><Property Name="InstalmentPremium" Type="Edm.Decimal" Scale="Variable" /><Property Name="Frequency" Type="Edm.String" /><Property Name="PolicyCovers" Type="Edm.String" /><Property Name="PolicyOwnerXeppoCode" Type="Edm.Int64" /><Property Name="PolicyNotes" Type="Edm.String" /></EntityType><EntityType Name="Invoice"><Key><PropertyRef Name="SourceConnectorID" /><PropertyRef Name="InvoiceID" /></Key><Property Name="SourceConnectorID" Type="Edm.Int64" Nullable="false" /><Property Name="InvoiceID" Type="Edm.String" Nullable="false" /><Property Name="XeppoCode" Type="Edm.Int64" Nullable="false" /><Property Name="PracticeID" Type="Edm.Int64" Nullable="false" /><Property Name="ClientID" Type="Edm.String" /><Property Name="InvoiceNo" Type="Edm.String" /><Property Name="Date" Type="Edm.DateTimeOffset" /><Property Name="DueDate" Type="Edm.DateTimeOffset" /><Property Name="Val" Type="Edm.Double" /><Property Name="Fees" Type="Edm.Double" /><Property Name="Writeoff" Type="Edm.Double" /><Property Name="LastReceiptDate" Type="Edm.DateTimeOffset" /><Property Name="ReceiptAmount" Type="Edm.Double" /><Property Name="ProductType" Type="Edm.String" /><Property Name="RevenueType" Type="Edm.String" /><Property Name="TransactionType" Type="Edm.String" /><Property Name="GroupID" Type="Edm.String" /><Property Name="Net" Type="Edm.Decimal" Scale="Variable" /><Property Name="Tax" Type="Edm.Decimal" Scale="Variable" /><Property Name="Gross" Type="Edm.Decimal" Scale="Variable" /><Property Name="Outstanding" Type="Edm.Decimal" Scale="Variable" /><Property Name="XeppoGroupCode" Type="Edm.Int64" /><Property Name="ClientName" Type="Edm.String" /><Property Name="ClientCode" Type="Edm.String" /><Property Name="SyncID" Type="Edm.String" /><Property Name="LastUpdated" Type="Edm.DateTimeOffset" /><Property Name="GroupName" Type="Edm.String" /><Property Name="ClientStatusID" Type="Edm.Int64" /><Property Name="InvoiceStatus" Type="Edm.String" /></EntityType><EntityType Name="KeyFirmContact"><Key><PropertyRef Name="SourceConnectorID" /><PropertyRef Name="KeyFirmContactID" /></Key><Property Name="SourceConnectorID" Type="Edm.Int64" Nullable="false" /><Property Name="KeyFirmContactID" Type="Edm.String" Nullable="false" /><Property Name="KeyFirmContactTypeID" Type="Edm.Int64" /><Property Name="ContactType" Type="Edm.String" /><Property Name="UserKeyFirmContactID" Type="Edm.String" /><Property Name="Name" Type="Edm.String" /><Property Name="GroupID" Type="Edm.String" /><Property Name="XeppoGroupCode" Type="Edm.Int64" /><Property Name="GroupName" Type="Edm.String" /><Property Name="ClientID" Type="Edm.String" /><Property Name="ClientCode" Type="Edm.String" /><Property Name="ClientName" Type="Edm.String" /><Property Name="ClientStatusID" Type="Edm.Int64" /><Property Name="XeppoCode" Type="Edm.Int64" Nullable="false" /><Property Name="PracticeID" Type="Edm.Int64" Nullable="false" /><Property Name="SyncID" Type="Edm.String" /><Property Name="LastUpdated" Type="Edm.DateTimeOffset" /><Property Name="IsXeppoManaged" Type="Edm.Boolean" /><Property Name="ContactCode" Type="Edm.String" /></EntityType><EntityType Name="AggregatedKeyFirmContact"><Key><PropertyRef Name="XeppoKeyFirmContactID" /></Key><Property Name="XeppoKeyFirmContactID" Type="Edm.Int64" Nullable="false" /><Property Name="ContactType" Type="Edm.String" /><Property Name="Name" Type="Edm.String" /><Property Name="ContactCode" Type="Edm.String" /><Property Name="XeppoGroupCode" Type="Edm.Int64" /><Property Name="GroupName" Type="Edm.String" /><Property Name="XeppoCode" Type="Edm.Int64" /><Property Name="ClientName" Type="Edm.String" /><Property Name="ClientCode" Type="Edm.String" /><Property Name="ClientStatusID" Type="Edm.Int64" /></EntityType><EntityType Name="Liability"><Key><PropertyRef Name="XeppoCode" /><PropertyRef Name="XeppoLiabilityID" /></Key><Property Name="XeppoCode" Type="Edm.Int64" Nullable="false" /><Property Name="XeppoLiabilityID" Type="Edm.Int64" Nullable="false" /><Property Name="ClientName" Type="Edm.String" /><Property Name="ClientCode" Type="Edm.String" /><Property Name="XeppoGroupCode" Type="Edm.Int64" /><Property Name="GroupName" Type="Edm.String" /><Property Name="PracticeID" Type="Edm.Int64" Nullable="false" /><Property Name="TempKey" Type="Edm.String" /><Property Name="SourceConnectorID" Type="Edm.Int64" /><Property Name="LiabilityID" Type="Edm.String" /><Property Name="ClientID" Type="Edm.String" /><Property Name="LiabilityName" Type="Edm.String" /><Property Name="AmountOwing" Type="Edm.Double" /><Property Name="LiabilityType" Type="Edm.String" /><Property Name="LiabilityCategory" Type="Edm.String" /><Property Name="Details" Type="Edm.String" /><Property Name="Repayment" Type="Edm.Double" /><Property Name="Frequency" Type="Edm.String" /><Property Name="StartDate" Type="Edm.DateTimeOffset" /><Property Name="EndDate" Type="Edm.DateTimeOffset" /><Property Name="GroupID" Type="Edm.String" /><Property Name="Depth" Type="Edm.Int32" /><Property Name="SyncID" Type="Edm.String" /><Property Name="LastUpdated" Type="Edm.DateTimeOffset" /><Property Name="ConnectorName" Type="Edm.String" /><Property Name="ConnectorMasterID" Type="Edm.Int32" /><Property Name="ClientStatusID" Type="Edm.Int64" /><Property Name="LenderInstitution" Type="Edm.String" /><Property Name="CommissionType" Type="Edm.String" /><Property Name="InterestRateType" Type="Edm.String" /><Property Name="AmountBorrowed" Type="Edm.Decimal" Scale="Variable" /><Property Name="LoanReviewDate" Type="Edm.DateTimeOffset" /><Property Name="SettlementDate" Type="Edm.DateTimeOffset" /><Property Name="UnderAdvice" Type="Edm.Boolean" /><Property Name="AccountNumber" Type="Edm.String" /><Property Name="CreditLimit" Type="Edm.Decimal" Scale="Variable" /><Property Name="InterestRate" Type="Edm.Decimal" Scale="Variable" /><Property Name="LoanTerm" Type="Edm.Int16" /><Property Name="Guarantors" Type="Edm.String" /><Property Name="ToBeRefinanced" Type="Edm.Boolean" /><Property Name="DateDischarged" Type="Edm.DateTimeOffset" /><Property Name="RecordDate" Type="Edm.DateTimeOffset" /><Property Name="LiabilityTypeID" Type="Edm.Int16" /><Property Name="LiabilitySubtypeID" Type="Edm.Int16" /><Property Name="InterestRateTypeID" Type="Edm.Int16" /><Property Name="CommissionTypeID" Type="Edm.Int16" /><Property Name="RepaymentTypeID" Type="Edm.Int16" /><Property Name="RepaymentFrequencyID" Type="Edm.Int16" /><Property Name="LiabilityLoanStatusID" Type="Edm.Int16" /><Property Name="LenderInstitutionID" Type="Edm.Int16" /><Property Name="LoanStatus" Type="Edm.String" /><Property Name="RepaymentType" Type="Edm.String" /><Property Name="OwnerClients" Type="Edm.String" /><Property Name="OwnershipPercentage" Type="Edm.Decimal" Scale="Variable" /><Property Name="OwnershipOutstanding" Type="Edm.Double" /><Property Name="RepaymentFrequency" Type="Edm.String" /></EntityType><EntityType Name="Loan"><Key><PropertyRef Name="SourceConnectorID" /><PropertyRef Name="TempKey" /></Key><Property Name="SourceConnectorID" Type="Edm.Int64" Nullable="false" /><Property Name="TempKey" Type="Edm.String" Nullable="false" /><Property Name="XeppoCode" Type="Edm.Int64" Nullable="false" /><Property Name="ClientName" Type="Edm.String" /><Property Name="ClientCode" Type="Edm.String" /><Property Name="XeppoGroupCode" Type="Edm.Int64" /><Property Name="PracticeID" Type="Edm.Int64" Nullable="false" /><Property Name="LoanNumber" Type="Edm.String" /><Property Name="Lender" Type="Edm.String" /><Property Name="ClientID" Type="Edm.String" /><Property Name="AmountBorrowed" Type="Edm.Double" /><Property Name="AmountOwing" Type="Edm.Double" /><Property Name="DateSettled" Type="Edm.DateTimeOffset" /><Property Name="RecordDate" Type="Edm.DateTimeOffset" /><Property Name="SyncID" Type="Edm.String" /><Property Name="LastUpdated" Type="Edm.DateTimeOffset" /><Property Name="ConnectorName" Type="Edm.String" /><Property Name="ConnectorMasterID" Type="Edm.Int32" /><Property Name="GroupName" Type="Edm.String" /><Property Name="ClientStatusID" Type="Edm.Int64" /><Property Name="LoanName" Type="Edm.String" /></EntityType><EntityType Name="vwLoanLatest"><Key><PropertyRef Name="SourceConnectorID" /><PropertyRef Name="TempKey" /></Key><Property Name="SourceConnectorID" Type="Edm.Int64" Nullable="false" /><Property Name="TempKey" Type="Edm.String" Nullable="false" /><Property Name="XeppoCode" Type="Edm.Int64" Nullable="false" /><Property Name="ClientName" Type="Edm.String" /><Property Name="ClientCode" Type="Edm.String" /><Property Name="XeppoGroupCode" Type="Edm.Int64" /><Property Name="GroupName" Type="Edm.String" /><Property Name="PracticeID" Type="Edm.Int64" Nullable="false" /><Property Name="LoanNumber" Type="Edm.String" /><Property Name="Lender" Type="Edm.String" /><Property Name="ClientID" Type="Edm.String" /><Property Name="AmountBorrowed" Type="Edm.Double" /><Property Name="AmountOwing" Type="Edm.Double" /><Property Name="DateSettled" Type="Edm.DateTimeOffset" /><Property Name="RecordDate" Type="Edm.DateTimeOffset" /><Property Name="SyncID" Type="Edm.String" /><Property Name="LastUpdated" Type="Edm.DateTimeOffset" /><Property Name="ConnectorName" Type="Edm.String" /><Property Name="ConnectorMasterID" Type="Edm.Int32" /><Property Name="ClientStatusID" Type="Edm.Int64" /><Property Name="LoanName" Type="Edm.String" /></EntityType><EntityType Name="Member"><Key><PropertyRef Name="SourceConnectorID" /><PropertyRef Name="MemberID" /></Key><Property Name="SourceConnectorID" Type="Edm.Int64" Nullable="false" /><Property Name="MemberID" Type="Edm.String" Nullable="false" /><Property Name="XeppoCode" Type="Edm.Int64" Nullable="false" /><Property Name="PracticeID" Type="Edm.Int64" Nullable="false" /><Property Name="ClientID" Type="Edm.String" /><Property Name="MemberNumber" Type="Edm.String" /><Property Name="JoinFundDate" Type="Edm.DateTimeOffset" /><Property Name="ESPStartDate" Type="Edm.DateTimeOffset" /><Property Name="SFN" Type="Edm.String" /><Property Name="RSE" Type="Edm.String" /><Property Name="TFNRecorded" Type="Edm.Boolean" /><Property Name="BeneficiaryDetailsRecorded" Type="Edm.Boolean" /><Property Name="Balance" Type="Edm.Decimal" Scale="Variable" /><Property Name="InsuranceRecorded" Type="Edm.Boolean" /><Property Name="LifeCover" Type="Edm.Decimal" Scale="Variable" /><Property Name="TPDCover" Type="Edm.Decimal" Scale="Variable" /><Property Name="SalaryContCover" Type="Edm.Decimal" Scale="Variable" /><Property Name="GroupID" Type="Edm.String" /><Property Name="MemberName" Type="Edm.String" /><Property Name="TrusteeName" Type="Edm.String" /><Property Name="TrustDeedDate" Type="Edm.DateTimeOffset" /><Property Name="Auditor" Type="Edm.String" /><Property Name="InvestmentManager" Type="Edm.String" /><Property Name="FundID" Type="Edm.String" /><Property Name="EntitySourceConnector" Type="Edm.String" /><Property Name="NominationEffectiveDate" Type="Edm.DateTimeOffset" /><Property Name="NominationExpiryDate" Type="Edm.DateTimeOffset" /><Property Name="XeppoGroupCode" Type="Edm.Int64" /><Property Name="SyncID" Type="Edm.String" /><Property Name="LastUpdated" Type="Edm.DateTimeOffset" /><Property Name="ClientName" Type="Edm.String" /><Property Name="ClientCode" Type="Edm.String" /><Property Name="MemberXeppoCode" Type="Edm.Int64" /><Property Name="MemberConcessionalAmount" Type="Edm.Decimal" Scale="Variable" /><Property Name="MemberConcessionalLimit" Type="Edm.Decimal" Scale="Variable" /><Property Name="MemberNonConcessionalAmount" Type="Edm.Decimal" Scale="Variable" /><Property Name="MemberNonConcessionalLimit" Type="Edm.Decimal" Scale="Variable" /><Property Name="MemberPensionSelected_TOTAL" Type="Edm.Decimal" Scale="Variable" /><Property Name="MemberPensionYTDBalance_TOTAL" Type="Edm.Decimal" Scale="Variable" /><Property Name="MemberPensionMinimum_TOTAL" Type="Edm.Decimal" Scale="Variable" /><Property Name="GroupName" Type="Edm.String" /><Property Name="ClientStatusID" Type="Edm.Int64" /></EntityType><EntityType Name="MemberAccount"><Key><PropertyRef Name="SourceConnectorID" /><PropertyRef Name="MemberAccountID" /></Key><Property Name="SourceConnectorID" Type="Edm.Int64" Nullable="false" /><Property Name="MemberAccountID" Type="Edm.String" Nullable="false" /><Property Name="XeppoCode" Type="Edm.Int64" Nullable="false" /><Property Name="PracticeID" Type="Edm.Int64" Nullable="false" /><Property Name="ParentType" Type="Edm.String" /><Property Name="MemberID" Type="Edm.String" /><Property Name="ClientID" Type="Edm.String" /><Property Name="MemberNumber" Type="Edm.String" /><Property Name="AccountName" Type="Edm.String" /><Property Name="AccountType" Type="Edm.String" /><Property Name="StartDate" Type="Edm.DateTimeOffset" /><Property Name="TaxableProportion_DEC" Type="Edm.Decimal" Scale="Variable" /><Property Name="OpeningBalance" Type="Edm.Decimal" Scale="Variable" /><Property Name="ClosingBalance" Type="Edm.Decimal" Scale="Variable" /><Property Name="TotalIncome" Type="Edm.Decimal" Scale="Variable" /><Property Name="TotalExpenses" Type="Edm.Decimal" Scale="Variable" /><Property Name="PensionAccountStartDate" Type="Edm.DateTimeOffset" /><Property Name="GroupID" Type="Edm.String" /><Property Name="FundID" Type="Edm.String" /><Property Name="XeppoGroupCode" Type="Edm.Int64" /><Property Name="SyncID" Type="Edm.String" /><Property Name="LastUpdated" Type="Edm.DateTimeOffset" /><Property Name="ClientName" Type="Edm.String" /><Property Name="ClientCode" Type="Edm.String" /><Property Name="GroupName" Type="Edm.String" /><Property Name="ClientStatusID" Type="Edm.Int64" /></EntityType><EntityType Name="OperatingStatement"><Key><PropertyRef Name="SourceConnectorID" /><PropertyRef Name="OperatingStatementID" /></Key><Property Name="SourceConnectorID" Type="Edm.Int64" Nullable="false" /><Property Name="OperatingStatementID" Type="Edm.String" Nullable="false" /><Property Name="XeppoCode" Type="Edm.Int64" Nullable="false" /><Property Name="PracticeID" Type="Edm.Int64" Nullable="false" /><Property Name="StartDate" Type="Edm.DateTimeOffset" /><Property Name="EndDate" Type="Edm.DateTimeOffset" /><Property Name="PreviousStartDate" Type="Edm.DateTimeOffset" /><Property Name="PreviousEndDate" Type="Edm.DateTimeOffset" /><Property Name="TotalIncomeTY" Type="Edm.Decimal" Scale="Variable" /><Property Name="TotalExpensesTY" Type="Edm.Decimal" Scale="Variable" /><Property Name="TotalIncomeTaxTY" Type="Edm.Decimal" Scale="Variable" /><Property Name="IncomeValuePY" Type="Edm.Decimal" Scale="Variable" /><Property Name="ExpenseValuePY" Type="Edm.Decimal" Scale="Variable" /><Property Name="IncomeTaxValuePY" Type="Edm.Decimal" Scale="Variable" /><Property Name="ClientID" Type="Edm.String" /><Property Name="GroupID" Type="Edm.String" /><Property Name="XeppoGroupCode" Type="Edm.Int64" /><Property Name="ClientName" Type="Edm.String" /><Property Name="ClientCode" Type="Edm.String" /><Property Name="SyncID" Type="Edm.String" /><Property Name="LastUpdated" Type="Edm.DateTimeOffset" /><Property Name="GroupName" Type="Edm.String" /><Property Name="ClientStatusID" Type="Edm.Int64" /></EntityType><EntityType Name="PensionDetail"><Key><PropertyRef Name="SourceConnectorID" /><PropertyRef Name="PensionID" /></Key><Property Name="SourceConnectorID" Type="Edm.Int64" Nullable="false" /><Property Name="PensionID" Type="Edm.String" Nullable="false" /><Property Name="XeppoCode" Type="Edm.Int64" Nullable="false" /><Property Name="PracticeID" Type="Edm.Int64" Nullable="false" /><Property Name="ClientID" Type="Edm.String" /><Property Name="MemberAccountID" Type="Edm.String" /><Property Name="PeriodStartDate" Type="Edm.DateTimeOffset" /><Property Name="PensionStartDate" Type="Edm.DateTimeOffset" /><Property Name="YTDBalance" Type="Edm.Double" /><Property Name="Minimum" Type="Edm.Double" /><Property Name="ReqdForMinimum" Type="Edm.Double" /><Property Name="Selected" Type="Edm.Double" /><Property Name="ReqdForSelected" Type="Edm.Double" /><Property Name="Maximum" Type="Edm.Double" /><Property Name="RemainingUntilMax" Type="Edm.Double" /><Property Name="OverMaximum" Type="Edm.Double" /><Property Name="TotalDrawdownsGross" Type="Edm.Double" /><Property Name="TotalDrawdownsNet" Type="Edm.Double" /><Property Name="DrawdownsPAYG" Type="Edm.Double" /><Property Name="ReviewState" Type="Edm.String" /><Property Name="GroupID" Type="Edm.String" /><Property Name="FundID" Type="Edm.String" /><Property Name="MemberNumber" Type="Edm.String" /><Property Name="EntitySourceConnector" Type="Edm.String" /><Property Name="ClientName" Type="Edm.String" /><Property Name="ClientCode" Type="Edm.String" /><Property Name="SyncID" Type="Edm.String" /><Property Name="LastUpdated" Type="Edm.DateTimeOffset" /><Property Name="XeppoGroupCode" Type="Edm.Int64" /><Property Name="GroupName" Type="Edm.String" /><Property Name="BalanceState" Type="Edm.String" /><Property Name="ClientStatusID" Type="Edm.Int64" /></EntityType><EntityType Name="Quote"><Key><PropertyRef Name="SourceConnectorID" /><PropertyRef Name="QuoteID" /></Key><Property Name="SourceConnectorID" Type="Edm.Int64" Nullable="false" /><Property Name="QuoteID" Type="Edm.String" Nullable="false" /><Property Name="XeppoCode" Type="Edm.Int64" Nullable="false" /><Property Name="PracticeID" Type="Edm.Int64" Nullable="false" /><Property Name="ClientID" Type="Edm.String" /><Property Name="Description" Type="Edm.String" /><Property Name="Status" Type="Edm.String" /><Property Name="Amount" Type="Edm.Double" /><Property Name="AmountTax" Type="Edm.Double" /><Property Name="AmountIncludingTax" Type="Edm.Double" /><Property Name="ValidToDate" Type="Edm.DateTimeOffset" /><Property Name="IssuedDate" Type="Edm.DateTimeOffset" /><Property Name="XeppoGroupCode" Type="Edm.Int64" /><Property Name="ClientName" Type="Edm.String" /><Property Name="ClientCode" Type="Edm.String" /><Property Name="SyncID" Type="Edm.String" /><Property Name="LastUpdated" Type="Edm.DateTimeOffset" /><Property Name="GroupName" Type="Edm.String" /><Property Name="ClientStatusID" Type="Edm.Int64" /></EntityType><EntityType Name="SMSFHolding"><Key><PropertyRef Name="SourceConnectorID" /><PropertyRef Name="SMSFHoldingID" /></Key><Property Name="SourceConnectorID" Type="Edm.Int64" Nullable="false" /><Property Name="SMSFHoldingID" Type="Edm.String" Nullable="false" /><Property Name="XeppoCode" Type="Edm.Int64" Nullable="false" /><Property Name="PracticeID" Type="Edm.Int64" Nullable="false" /><Property Name="ClientID" Type="Edm.String" /><Property Name="AssetCode" Type="Edm.String" /><Property Name="AssetName" Type="Edm.String" /><Property Name="AssetClass" Type="Edm.String" /><Property Name="Units" Type="Edm.Double" /><Property Name="MarketPrice" Type="Edm.Double" /><Property Name="MarketValue" Type="Edm.Double" /><Property Name="UnsettledPosition" Type="Edm.Double" /><Property Name="TotalValue" Type="Edm.Double" /><Property Name="GroupID" Type="Edm.String" /><Property Name="XeppoGroupCode" Type="Edm.Int64" /><Property Name="ClientName" Type="Edm.String" /><Property Name="ClientCode" Type="Edm.String" /><Property Name="SyncID" Type="Edm.String" /><Property Name="LastUpdated" Type="Edm.DateTimeOffset" /><Property Name="GroupName" Type="Edm.String" /><Property Name="ConnectorName" Type="Edm.String" /><Property Name="ConnectorMasterID" Type="Edm.Int32" /><Property Name="ClientStatusID" Type="Edm.Int64" /></EntityType><EntityType Name="TaxReturn"><Key><PropertyRef Name="SourceConnectorID" /><PropertyRef Name="TaxReturnID" /></Key><Property Name="SourceConnectorID" Type="Edm.Int64" Nullable="false" /><Property Name="TaxReturnID" Type="Edm.String" Nullable="false" /><Property Name="XeppoCode" Type="Edm.Int64" Nullable="false" /><Property Name="PracticeID" Type="Edm.Int64" Nullable="false" /><Property Name="ClientID" Type="Edm.String" /><Property Name="FinancialYear" Type="Edm.String" /><Property Name="TotalIncome" Type="Edm.Double" /><Property Name="TotalExpenses" Type="Edm.Double" /><Property Name="TaxableIncome" Type="Edm.Double" /><Property Name="NetRefund" Type="Edm.Double" /><Property Name="GroupID" Type="Edm.String" /><Property Name="LodgementDate" Type="Edm.DateTimeOffset" /><Property Name="XeppoGroupCode" Type="Edm.Int64" /><Property Name="ClientName" Type="Edm.String" /><Property Name="ClientCode" Type="Edm.String" /><Property Name="SyncID" Type="Edm.String" /><Property Name="LastUpdated" Type="Edm.DateTimeOffset" /><Property Name="GroupName" Type="Edm.String" /><Property Name="ClientStatusID" Type="Edm.Int64" /><Property Name="DividendDeductions" Type="Edm.Double" /><Property Name="Dividends" Type="Edm.Double" /><Property Name="InterestDeductions" Type="Edm.Double" /><Property Name="OtherDeductions" Type="Edm.Double" /><Property Name="OtherDeductionsDescription" Type="Edm.String" /><Property Name="RentalIncome" Type="Edm.Double" /><Property Name="IncomeProtectionDeductions" Type="Edm.Double" /><Property Name="ReturnType" Type="Edm.String" /><Property Name="ReturnStatus" Type="Edm.String" /></EntityType><EntityType Name="WIP"><Key><PropertyRef Name="SourceConnectorID" /><PropertyRef Name="WIPID" /></Key><Property Name="SourceConnectorID" Type="Edm.Int64" Nullable="false" /><Property Name="WIPID" Type="Edm.String" Nullable="false" /><Property Name="XeppoCode" Type="Edm.Int64" Nullable="false" /><Property Name="PracticeID" Type="Edm.Int64" Nullable="false" /><Property Name="ClientID" Type="Edm.String" /><Property Name="InvoiceID" Type="Edm.String" /><Property Name="FeeCategorySourceID" Type="Edm.String" /><Property Name="Date" Type="Edm.DateTimeOffset" /><Property Name="Value" Type="Edm.Double" /><Property Name="GroupID" Type="Edm.String" /><Property Name="XeppoGroupCode" Type="Edm.Int64" /><Property Name="ClientName" Type="Edm.String" /><Property Name="ClientCode" Type="Edm.String" /><Property Name="SyncID" Type="Edm.String" /><Property Name="LastUpdated" Type="Edm.DateTimeOffset" /><Property Name="MatterName" Type="Edm.String" /><Property Name="GroupName" Type="Edm.String" /><Property Name="ClientStatusID" Type="Edm.Int64" /></EntityType><EntityType Name="vwClientRankingsFeeCategory"><Key><PropertyRef Name="XeppoCode" /><PropertyRef Name="FeeCategoryID" /></Key><Property Name="XeppoCode" Type="Edm.Int64" Nullable="false" /><Property Name="FeeCategoryID" Type="Edm.Int64" Nullable="false" /><Property Name="ClientName" Type="Edm.String" /><Property Name="PracticeID" Type="Edm.Int64" Nullable="false" /><Property Name="Depth" Type="Edm.Int32" Nullable="false" /><Property Name="Rank" Type="Edm.Double" /><Property Name="RankPercent" Type="Edm.Double" /><Property Name="Value" Type="Edm.Decimal" Scale="Variable" /><Property Name="ValueAverage" Type="Edm.Decimal" Scale="Variable" /><Property Name="Count" Type="Edm.Int32" /><Property Name="KeyFirmContactList" Type="Edm.String" /><Property Name="TagNames" Type="Edm.String" /></EntityType><EntityType Name="vwGroupRankingsFeeCategory"><Key><PropertyRef Name="XeppoGroupCode" /><PropertyRef Name="FeeCategoryID" /></Key><Property Name="XeppoGroupCode" Type="Edm.Int64" Nullable="false" /><Property Name="FeeCategoryID" Type="Edm.Int64" Nullable="false" /><Property Name="GroupName" Type="Edm.String" /><Property Name="PracticeID" Type="Edm.Int64" Nullable="false" /><Property Name="Depth" Type="Edm.Int32" Nullable="false" /><Property Name="Rank" Type="Edm.Double" /><Property Name="RankPercent" Type="Edm.Double" /><Property Name="Value" Type="Edm.Decimal" Scale="Variable" /><Property Name="ValueAverage" Type="Edm.Decimal" Scale="Variable" /><Property Name="Count" Type="Edm.Int32" /><Property Name="KeyFirmContactList" Type="Edm.String" /><Property Name="TagNames" Type="Edm.String" /><Property Name="Status" Type="Edm.String" /><Property Name="StatusID" Type="Edm.Int64" /></EntityType><EntityType Name="TotalFees_Category"><Key><PropertyRef Name="XeppoCode" /><PropertyRef Name="SortYear" /><PropertyRef Name="Depth" /><PropertyRef Name="FeeCategoryName" /></Key><Property Name="XeppoCode" Type="Edm.Int64" Nullable="false" /><Property Name="SortYear" Type="Edm.Int32" Nullable="false" /><Property Name="Depth" Type="Edm.Int32" Nullable="false" /><Property Name="FeeCategoryName" Type="Edm.String" Nullable="false" /><Property Name="PracticeID" Type="Edm.Int64" Nullable="false" /><Property Name="XeppoGroupCode" Type="Edm.Int64" /><Property Name="ClientName" Type="Edm.String" /><Property Name="FinancialYear" Type="Edm.String" /><Property Name="FeeCategoryID" Type="Edm.Int64" Nullable="false" /><Property Name="Fees" Type="Edm.Decimal" Scale="Variable" /><Property Name="Commission" Type="Edm.Decimal" Scale="Variable" /><Property Name="Revenue" Type="Edm.Decimal" Scale="Variable" /><Property Name="LastUpdated" Type="Edm.DateTimeOffset" /></EntityType><EntityType Name="Commission_Category"><Key><PropertyRef Name="XeppoCode" /><PropertyRef Name="SortYear" /><PropertyRef Name="Depth" /><PropertyRef Name="FeeCategoryName" /></Key><Property Name="XeppoCode" Type="Edm.Int64" Nullable="false" /><Property Name="SortYear" Type="Edm.Int32" Nullable="false" /><Property Name="Depth" Type="Edm.Int32" Nullable="false" /><Property Name="FeeCategoryName" Type="Edm.String" Nullable="false" /><Property Name="PracticeID" Type="Edm.Int64" Nullable="false" /><Property Name="XeppoGroupCode" Type="Edm.Int64" /><Property Name="ClientName" Type="Edm.String" /><Property Name="FinancialYear" Type="Edm.String" /><Property Name="FeeCategoryID" Type="Edm.Int64" Nullable="false" /><Property Name="Gross" Type="Edm.Decimal" Scale="Variable" /><Property Name="Net" Type="Edm.Decimal" Scale="Variable" /></EntityType><EntityType Name="Fees_Category"><Key><PropertyRef Name="XeppoCode" /><PropertyRef Name="SortYear" /><PropertyRef Name="Depth" /><PropertyRef Name="FeeCategoryID" /></Key><Property Name="XeppoCode" Type="Edm.Int64" Nullable="false" /><Property Name="SortYear" Type="Edm.Int32" Nullable="false" /><Property Name="Depth" Type="Edm.Int32" Nullable="false" /><Property Name="FeeCategoryID" Type="Edm.Int64" Nullable="false" /><Property Name="PracticeID" Type="Edm.Int64" Nullable="false" /><Property Name="XeppoGroupCode" Type="Edm.Int64" /><Property Name="ClientName" Type="Edm.String" /><Property Name="FinancialYear" Type="Edm.String" /><Property Name="FeeCategoryName" Type="Edm.String" /><Property Name="Fees" Type="Edm.Decimal" Scale="Variable" /><Property Name="Gross" Type="Edm.Decimal" Scale="Variable" /><Property Name="Net" Type="Edm.Decimal" Scale="Variable" /><Property Name="WriteOff" Type="Edm.Decimal" Scale="Variable" /></EntityType><EntityType Name="Fees_Commission"><Key><PropertyRef Name="XeppoCode" /><PropertyRef Name="SortYear" /></Key><Property Name="XeppoCode" Type="Edm.Int64" Nullable="false" /><Property Name="SortYear" Type="Edm.Int32" Nullable="false" /><Property Name="XeppoGroupCode" Type="Edm.Int64" /><Property Name="ClientName" Type="Edm.String" /><Property Name="FinancialYear" Type="Edm.String" /><Property Name="Fees" Type="Edm.Decimal" Scale="Variable" /><Property Name="Commissions" Type="Edm.Decimal" Scale="Variable" /><Property Name="Total" Type="Edm.Decimal" Scale="Variable" /><Property Name="CommissionsNewBusiness" Type="Edm.Decimal" Scale="Variable" /><Property Name="CommissionsOngoing" Type="Edm.Decimal" Scale="Variable" /><Property Name="PracticeID" Type="Edm.Int64" Nullable="false" /></EntityType><EntityType Name="vwFeeCategoryDepth"><Key><PropertyRef Name="FeeCategoryID" /></Key><Property Name="FeeCategoryID" Type="Edm.Int64" Nullable="false" /><Property Name="ParentFeeCategoryID" Type="Edm.Int64" /><Property Name="SourceID" Type="Edm.String" /><Property Name="SourceConnectorID" Type="Edm.Int64" /><Property Name="ParentSourceID" Type="Edm.String" /><Property Name="Name" Type="Edm.String" /><Property Name="PracticeID" Type="Edm.Int64" Nullable="false" /><Property Name="SyncID" Type="Edm.String" /><Property Name="LastUpdated" Type="Edm.DateTimeOffset" /><Property Name="ConnectorName" Type="Edm.String" /><Property Name="ConnectorDescription" Type="Edm.String" /><Property Name="IsSource" Type="Edm.Boolean" /><Property Name="IsParentSource" Type="Edm.Boolean" /><Property Name="IsUncategorised" Type="Edm.Boolean" /><Property Name="depth" Type="Edm.Int32" /></EntityType><EntityType Name="vwGroupPrimaryContact"><Key><PropertyRef Name="XeppoCode" /></Key><Property Name="XeppoCode" Type="Edm.Int64" Nullable="false" /><Property Name="XeppoGroupCode" Type="Edm.Int64" /><Property Name="Name" Type="Edm.String" /><Property Name="FirstName" Type="Edm.String" /><Property Name="LastName" Type="Edm.String" /><Property Name="WorkEmail" Type="Edm.String" /><Property Name="HomeEmail" Type="Edm.String" /><Property Name="WorkPhone" Type="Edm.String" /><Property Name="HomeMobile" Type="Edm.String" /><Property Name="PracticeID" Type="Edm.Int64" Nullable="false" /><Property Name="OtherEmail" Type="Edm.String" /></EntityType><EntityType Name="vwGroupTag"><Key><PropertyRef Name="XeppoGroupCode" /></Key><Property Name="XeppoGroupCode" Type="Edm.Int64" Nullable="false" /><Property Name="GroupName" Type="Edm.String" /><Property Name="PracticeID" Type="Edm.Int64" Nullable="false" /><Property Name="Value" Type="Edm.String" /><Property Name="Tag" Type="Edm.String" /><Property Name="TagID" Type="Edm.Int64" Nullable="false" /><Property Name="TagValueID" Type="Edm.Int64" Nullable="false" /><Property Name="IsSystem" Type="Edm.Boolean" Nullable="false" /></EntityType><EntityType Name="vwClientTag"><Key><PropertyRef Name="XeppoCode" /></Key><Property Name="XeppoCode" Type="Edm.Int64" Nullable="false" /><Property Name="ClientName" Type="Edm.String" /><Property Name="PracticeID" Type="Edm.Int64" Nullable="false" /><Property Name="Value" Type="Edm.String" /><Property Name="Tag" Type="Edm.String" /><Property Name="TagID" Type="Edm.Int64" Nullable="false" /><Property Name="TagValueID" Type="Edm.Int64" Nullable="false" /><Property Name="IsSystem" Type="Edm.Boolean" Nullable="false" /></EntityType><EntityType Name="vwRelationship"><Key><PropertyRef Name="RelationshipID" /></Key><Property Name="RelationshipID" Type="Edm.Int64" Nullable="false" /><Property Name="SourceConnectorID" Type="Edm.Int64" /><Property Name="PracticeID" Type="Edm.Int64" Nullable="false" /><Property Name="XeppoCode" Type="Edm.Int64" Nullable="false" /><Property Name="ToXeppoCode" Type="Edm.Int64" Nullable="false" /><Property Name="FromName" Type="Edm.String" /><Property Name="ToName" Type="Edm.String" /><Property Name="RelationshipType" Type="Edm.String" /><Property Name="LastUpdated" Type="Edm.DateTimeOffset" /><Property Name="CreatedDateUTC" Type="Edm.DateTimeOffset" /><Property Name="SyncID" Type="Edm.String" /><Property Name="IsXeppoManaged" Type="Edm.Boolean" /><Property Name="IsDeleted" Type="Edm.Boolean" Nullable="false" /></EntityType><EntityType Name="Trend"><Key><PropertyRef Name="TrendID" /></Key><Property Name="TrendID" Type="Edm.Int64" Nullable="false" /><Property Name="PracticeID" Type="Edm.Int64" Nullable="false" /><Property Name="EntityID" Type="Edm.Int16" Nullable="false" /><Property Name="XeppoCode" Type="Edm.Int64" Nullable="false" /><Property Name="ConsolidationMonth" Type="Edm.DateTimeOffset" Nullable="false" /><Property Name="ConnectorID" Type="Edm.Int64" Nullable="false" /><Property Name="MinimumValue" Type="Edm.Decimal" Nullable="false" Scale="Variable" /><Property Name="MaximumValue" Type="Edm.Decimal" Nullable="false" Scale="Variable" /><Property Name="AverageValue" Type="Edm.Decimal" Nullable="false" Scale="Variable" /><Property Name="LastRecordValue" Type="Edm.Decimal" Nullable="false" Scale="Variable" /><Property Name="EntityName" Type="Edm.String" /><Property Name="ConnectorName" Type="Edm.String" /><Property Name="ConnectorMasterID" Type="Edm.Int32" /></EntityType><EntityType Name="vwDataClient"><Key><PropertyRef Name="SourceConnectorID" /><PropertyRef Name="ClientID" /></Key><Property Name="SourceConnectorID" Type="Edm.Int64" Nullable="false" /><Property Name="ClientID" Type="Edm.String" Nullable="false" /><Property Name="XeppoCode" Type="Edm.Int64" /><Property Name="Code" Type="Edm.String" /><Property Name="FatherCode" Type="Edm.String" /><Property Name="SourceEntityType" Type="Edm.String" /><Property Name="Name" Type="Edm.String" /><Property Name="HomePhone" Type="Edm.String" /><Property Name="WorkPhone" Type="Edm.String" /><Property Name="HomeMobile" Type="Edm.String" /><Property Name="HomeEmail" Type="Edm.String" /><Property Name="WorkEmail" Type="Edm.String" /><Property Name="OtherEmail" Type="Edm.String" /><Property Name="PreferredEmail" Type="Edm.String" /><Property Name="PreferredEmailTypeId" Type="Edm.Byte" /><Property Name="WorkFax" Type="Edm.String" /><Property Name="GroupID" Type="Edm.String" /><Property Name="Salutation" Type="Edm.String" /><Property Name="MailName" Type="Edm.String" /><Property Name="TradingAs" Type="Edm.String" /><Property Name="PreferredContactMethod" Type="Edm.String" /><Property Name="DateEngagementLetterSent" Type="Edm.Boolean" /><Property Name="ACN" Type="Edm.String" /><Property Name="ABN" Type="Edm.String" /><Property Name="TFN" Type="Edm.String" /><Property Name="SFN" Type="Edm.String" /><Property Name="DateOfIncorporation" Type="Edm.DateTimeOffset" /><Property Name="DirectorRelationshipStatus" Type="Edm.String" /><Property Name="ReferrerName" Type="Edm.String" /><Property Name="ReferrerType" Type="Edm.String" /><Property Name="ClientGroupName" Type="Edm.String" /><Property Name="TaxReturnID" Type="Edm.String" /><Property Name="InsuranceAdviser" Type="Edm.String" /><Property Name="Gender" Type="Edm.String" /><Property Name="DateOfBirth" Type="Edm.DateTimeOffset" /><Property Name="MaritalStatus" Type="Edm.String" /><Property Name="SpouseName" Type="Edm.String" /><Property Name="NoOfChildren" Type="Edm.String" /><Property Name="Occupation" Type="Edm.String" /><Property Name="Smoker" Type="Edm.String" /><Property Name="Health" Type="Edm.String" /><Property Name="Industry" Type="Edm.String" /><Property Name="FirstName" Type="Edm.String" /><Property Name="LastName" Type="Edm.String" /><Property Name="MiddleName" Type="Edm.String" /><Property Name="TerminationDate" Type="Edm.DateTimeOffset" /><Property Name="WorkMobile" Type="Edm.String" /><Property Name="HomeFax" Type="Edm.String" /><Property Name="DateBecameClient" Type="Edm.DateTimeOffset" /><Property Name="Class_PWM_Inv" Type="Edm.String" /><Property Name="Class_CA" Type="Edm.String" /><Property Name="Class_Finance" Type="Edm.String" /><Property Name="Class_Audit" Type="Edm.String" /><Property Name="Class_PWM_Ins" Type="Edm.String" /><Property Name="ClientReferredBy" Type="Edm.String" /><Property Name="MarketingCommunication" Type="Edm.Boolean" /><Property Name="OccupationCode" Type="Edm.String" /><Property Name="Manager" Type="Edm.String" /><Property Name="Director" Type="Edm.String" /><Property Name="Accountant" Type="Edm.String" /><Property Name="PrimaryRelationshipPartner" Type="Edm.String" /><Property Name="ClientStatus_CRM" Type="Edm.String" /><Property Name="ClientClass_CRM" Type="Edm.String" /><Property Name="ClientType_CRM" Type="Edm.Int64" /><Property Name="PreferredClientContact_CRM" Type="Edm.String" /><Property Name="InvestorType_CRM" Type="Edm.Int64" /><Property Name="IncludeInCampaigns_CRM" Type="Edm.Boolean" /><Property Name="ClientRefersClients_CRM" Type="Edm.Boolean" /><Property Name="RSE" Type="Edm.String" /><Property Name="TrusteeName" Type="Edm.String" /><Property Name="TrustDeedDate" Type="Edm.DateTimeOffset" /><Property Name="Auditor" Type="Edm.String" /><Property Name="InvestmentManager" Type="Edm.String" /><Property Name="IsSuperFund_CHECK" Type="Edm.Boolean" /><Property Name="MemberNumber" Type="Edm.String" /><Property Name="JoinFundDate" Type="Edm.DateTimeOffset" /><Property Name="ESPStartDate" Type="Edm.DateTimeOffset" /><Property Name="TFNRecorded" Type="Edm.Boolean" /><Property Name="BeneficiaryDetailsRecorded" Type="Edm.Boolean" /><Property Name="NominationEffectiveDate" Type="Edm.DateTimeOffset" /><Property Name="NominationExpiryDate" Type="Edm.DateTimeOffset" /><Property Name="Balance" Type="Edm.Decimal" Scale="Variable" /><Property Name="InsuranceRecorded" Type="Edm.Boolean" /><Property Name="LifeCover" Type="Edm.Decimal" Scale="Variable" /><Property Name="TPDCover" Type="Edm.Decimal" Scale="Variable" /><Property Name="SalaryContCover" Type="Edm.Decimal" Scale="Variable" /><Property Name="Title" Type="Edm.String" /><Property Name="ForeignOwner_CRM" Type="Edm.String" /><Property Name="CreditHold_CRM" Type="Edm.Boolean" /><Property Name="NoOfEmployees" Type="Edm.Int32" /><Property Name="Age" Type="Edm.Int32" /><Property Name="SyncID" Type="Edm.String" /><Property Name="LastUpdated" Type="Edm.DateTimeOffset" /><Property Name="StatusID" Type="Edm.Int64" /><Property Name="IsPrimaryContact" Type="Edm.Boolean" /><Property Name="XeppoCodeString" Type="Edm.String" /><Property Name="IsMatched" Type="Edm.Boolean" /><Property Name="PracticeID" Type="Edm.Int64" Nullable="false" /><Property Name="ConnectorName" Type="Edm.String" /><Property Name="ConnectorDescription" Type="Edm.String" /><Property Name="ConnectorMasterID" Type="Edm.Int32" /><Property Name="Status" Type="Edm.String" /><Property Name="EntityType" Type="Edm.String" /><Property Name="ClientTypeID" Type="Edm.Int16" /><Property Name="TotalWages" Type="Edm.Decimal" Scale="Variable" /><Property Name="PreferredName" Type="Edm.String" /><Property Name="PlaceOfBirth" Type="Edm.String" /><Property Name="DateOfMarriage" Type="Edm.DateTimeOffset" /><Property Name="ResidentStatus" Type="Edm.String" /><Property Name="IsAustralianTaxResident" Type="Edm.Boolean" /><Property Name="EmergencyContact" Type="Edm.String" /><Property Name="OwnOrRentHome" Type="Edm.String" /><Property Name="TypeOfCompany" Type="Edm.String" /><Property Name="PartnershipLiability" Type="Edm.String" /><Property Name="TypeOfFund" Type="Edm.String" /><Property Name="PartnershipType" Type="Edm.String" /><Property Name="TypeOfTrust" Type="Edm.String" /><Property Name="AddressForCorrespondence" Type="Edm.String" /><Property Name="IsLivingAtHome" Type="Edm.Boolean" /><Property Name="EmploymentPosition" Type="Edm.String" /><Property Name="EmploymentStatus" Type="Edm.String" /><Property Name="HoursWorkedPerWeek" Type="Edm.Decimal" Scale="Variable" /><Property Name="AnyEmploymentChangePlanned" Type="Edm.String" /><Property Name="HasSalaryPackagingAvailable" Type="Edm.Boolean" /><Property Name="LeaveDetails" Type="Edm.String" /><Property Name="BusinessStructure" Type="Edm.String" /><Property Name="AdditionalInformation" Type="Edm.String" /><Property Name="HealthInsurance" Type="Edm.String" /><Property Name="FamilyHistory" Type="Edm.String" /><Property Name="TotalIssuedShares" Type="Edm.Int64" /><Property Name="BusinessPurpose" Type="Edm.String" /><Property Name="BusinessActivities" Type="Edm.String" /><Property Name="BusinessValue" Type="Edm.Decimal" Scale="Variable" /><Property Name="HasComplyingStatus" Type="Edm.Boolean" /><Property Name="LocationOfDeed" Type="Edm.String" /><Property Name="PartnershipNumber" Type="Edm.String" /><Property Name="EmployerName" Type="Edm.String" /><Property Name="StartDateWithEmployer" Type="Edm.DateTimeOffset" /><Property Name="StartedInCurrentOccupation" Type="Edm.DateTimeOffset" /><Property Name="HealthConditions" Type="Edm.String" /><Property Name="DateOfDeath" Type="Edm.DateTimeOffset" /><Property Name="EmploymentDuties" Type="Edm.String" /><Property Name="TrustNumber" Type="Edm.String" /><Property Name="ClientCategory" Type="Edm.String" /><Property Name="InvestorRiskProfile" Type="Edm.String" /><Property Name="FSGCurrentVersion" Type="Edm.String" /><Property Name="FSGCurrentVersionDate" Type="Edm.DateTimeOffset" /><Property Name="AMLCTFExpiryDate" Type="Edm.DateTimeOffset" /><Property Name="FDSRequired" Type="Edm.Boolean" /><Property Name="NextFDSDate" Type="Edm.DateTimeOffset" /><Property Name="OptInRequired" Type="Edm.Boolean" /><Property Name="OptInStatus" Type="Edm.String" /><Property Name="ServiceAgreementStatus" Type="Edm.String" /><Property Name="NextOptInDate" Type="Edm.DateTimeOffset" /><Property Name="OptInSubjectToGrandfathering" Type="Edm.Boolean" /><Property Name="RenewalNoteSentDate" Type="Edm.DateTimeOffset" /><Property Name="FeeTerminationDate" Type="Edm.DateTimeOffset" /><Property Name="AgreedToOngoingFee" Type="Edm.Boolean" /><Property Name="AgreementSignedDate" Type="Edm.DateTimeOffset" /><Property Name="LastBrokerageRecordDate" Type="Edm.DateTimeOffset" /><Property Name="InitialScopeOfAdvice" Type="Edm.String" /><Property Name="DateLastFactFindSigned" Type="Edm.DateTimeOffset" /><Property Name="DateAMLCompleted" Type="Edm.DateTimeOffset" /><Property Name="DateFSGProvided" Type="Edm.DateTimeOffset" /><Property Name="DateFirstReceivedFinancialAdvice" Type="Edm.DateTimeOffset" /><Property Name="DateOfLastSignedSOA" Type="Edm.DateTimeOffset" /><Property Name="DateOfLastSignedROA" Type="Edm.DateTimeOffset" /><Property Name="DateOfLastReview" Type="Edm.DateTimeOffset" /><Property Name="IsPoliticallyExposedIndividual" Type="Edm.Boolean" /><Property Name="InvestorRiskProfileDate" Type="Edm.DateTimeOffset" /><Property Name="SophisticatedCertificateExpiryDate" Type="Edm.DateTimeOffset" /><Property Name="W8BENExpiryDate" Type="Edm.DateTimeOffset" /></EntityType><EntityType Name="vwSalesLead"><Key><PropertyRef Name="SalesLeadID" /></Key><Property Name="SalesLeadID" Type="Edm.Int64" Nullable="false" /><Property Name="PracticeID" Type="Edm.Int64" Nullable="false" /><Property Name="Topic" Type="Edm.String" /><Property Name="SalesLeadTopicID" Type="Edm.Int64" /><Property Name="Description" Type="Edm.String" /><Property Name="EstimatedValue" Type="Edm.Decimal" Scale="Variable" /><Property Name="EstimatedValueOngoing" Type="Edm.Decimal" Scale="Variable" /><Property Name="SaleValue" Type="Edm.Decimal" Scale="Variable" /><Property Name="SaleValueOngoing" Type="Edm.Decimal" Scale="Variable" /><Property Name="ProductValue" Type="Edm.Decimal" Scale="Variable" /><Property Name="Status" Type="Edm.String" /><Property Name="EntityType" Type="Edm.String" /><Property Name="EntityName" Type="Edm.String" /><Property Name="IndividualFirstName" Type="Edm.String" /><Property Name="IndividualLastName" Type="Edm.String" /><Property Name="IndividualDateOfBirth" Type="Edm.DateTimeOffset" /><Property Name="IndividualGender" Type="Edm.String" /><Property Name="Industry" Type="Edm.String" /><Property Name="Occupation" Type="Edm.String" /><Property Name="IndividualPhone" Type="Edm.String" /><Property Name="IndividualMobile" Type="Edm.String" /><Property Name="IndividualEmail" Type="Edm.String" /><Property Name="ContactFirstName" Type="Edm.String" /><Property Name="ContactLastName" Type="Edm.String" /><Property Name="ContactPhone" Type="Edm.String" /><Property Name="ContactMobile" Type="Edm.String" /><Property Name="ContactEmail" Type="Edm.String" /><Property Name="ClientXeppoCode" Type="Edm.Int64" /><Property Name="ContactXeppoCode" Type="Edm.Int64" /><Property Name="XeppoGroupCode" Type="Edm.Int64" /><Property Name="EstimatedCloseDate" Type="Edm.DateTimeOffset" /><Property Name="ActualCloseDate" Type="Edm.DateTimeOffset" /><Property Name="QualifiedDateUTC" Type="Edm.DateTimeOffset" /><Property Name="Participant1UserID" Type="Edm.String" /><Property Name="Participant2UserID" Type="Edm.String" /><Property Name="Participant1" Type="Edm.String" /><Property Name="Participant2" Type="Edm.String" /><Property Name="UserID" Type="Edm.String" /><Property Name="UserName" Type="Edm.String" /><Property Name="TeamID" Type="Edm.Int64" /><Property Name="TeamName" Type="Edm.String" /><Property Name="CreatedDateUTC" Type="Edm.DateTimeOffset" Nullable="false" /><Property Name="ModifiedDateUTC" Type="Edm.DateTimeOffset" /><Property Name="CreatedBy" Type="Edm.String" /><Property Name="ModifiedBy" Type="Edm.String" /><Property Name="CreatedByUserID" Type="Edm.String" /><Property Name="ModifiedByUserID" Type="Edm.String" /><Property Name="CRMID" Type="Edm.String" /><Property Name="IsDeleted" Type="Edm.Boolean" Nullable="false" /><Property Name="ReferralType" Type="Edm.String" /><Property Name="ReferralTypeID" Type="Edm.Int64" /><Property Name="ReferralSource" Type="Edm.String" /><Property Name="ReferralSourceID" Type="Edm.String" /><Property Name="ImportedDateUTC" Type="Edm.DateTimeOffset" /><Property Name="ImportedFilename" Type="Edm.String" /><Property Name="AddressType" Type="Edm.String" /><Property Name="AddressLine1" Type="Edm.String" /><Property Name="AddressLine2" Type="Edm.String" /><Property Name="AddressSuburb" Type="Edm.String" /><Property Name="AddressState" Type="Edm.String" /><Property Name="AddressPostcode" Type="Edm.String" /><Property Name="AddressCountry" Type="Edm.String" /><Property Name="DataAddressID" Type="Edm.String" /><Property Name="ClientClientID" Type="Edm.String" /><Property Name="ContactClientID" Type="Edm.String" /><Property Name="XeppoCode" Type="Edm.Int64" /></EntityType><EntityType Name="vwSalesOpportunity"><Key><PropertyRef Name="SalesOpportunityID" /></Key><Property Name="SalesOpportunityID" Type="Edm.Int64" Nullable="false" /><Property Name="PracticeID" Type="Edm.Int64" Nullable="false" /><Property Name="XeppoCode" Type="Edm.Int64" /><Property Name="XeppoGroupCode" Type="Edm.Int64" /><Property Name="Topic" Type="Edm.String" /><Property Name="SalesOpportunityTopicID" Type="Edm.Int64" /><Property Name="Description" Type="Edm.String" /><Property Name="Status" Type="Edm.String" /><Property Name="PipelineStageID" Type="Edm.Int64" /><Property Name="EstimatedValue" Type="Edm.Decimal" Scale="Variable" /><Property Name="EstimatedValueOngoing" Type="Edm.Decimal" Scale="Variable" /><Property Name="SaleValue" Type="Edm.Decimal" Scale="Variable" /><Property Name="SaleValueOngoing" Type="Edm.Decimal" Scale="Variable" /><Property Name="ProductValue" Type="Edm.Decimal" Scale="Variable" /><Property Name="ReferralType" Type="Edm.String" /><Property Name="ReferralTypeID" Type="Edm.Int64" /><Property Name="ReferralSource" Type="Edm.String" /><Property Name="ReferralSourceID" Type="Edm.String" /><Property Name="TeamID" Type="Edm.Int64" /><Property Name="UserID" Type="Edm.String" /><Property Name="Participant1UserID" Type="Edm.String" /><Property Name="Participant2UserID" Type="Edm.String" /><Property Name="Participant1" Type="Edm.String" /><Property Name="Participant2" Type="Edm.String" /><Property Name="CreatedDateUTC" Type="Edm.DateTimeOffset" Nullable="false" /><Property Name="ModifiedDateUTC" Type="Edm.DateTimeOffset" /><Property Name="CreatedBy" Type="Edm.String" /><Property Name="ModifiedBy" Type="Edm.String" /><Property Name="CreatedByUserID" Type="Edm.String" /><Property Name="ModifiedByUserID" Type="Edm.String" /><Property Name="EstimatedCloseDate" Type="Edm.DateTimeOffset" /><Property Name="ActualCloseDate" Type="Edm.DateTimeOffset" /><Property Name="ActivatedDateUTC" Type="Edm.DateTimeOffset" /><Property Name="CRMID" Type="Edm.String" /><Property Name="MarketingListID" Type="Edm.Int64" /><Property Name="MarketingListName" Type="Edm.String" /><Property Name="SalesLeadID" Type="Edm.Int64" /><Property Name="QueryID" Type="Edm.Int64" /><Property Name="IsDeleted" Type="Edm.Boolean" Nullable="false" /><Property Name="UserName" Type="Edm.String" /><Property Name="Name" Type="Edm.String" /><Property Name="EntityType" Type="Edm.String" /><Property Name="GroupName" Type="Edm.String" /><Property Name="PipelineStageName" Type="Edm.String" /><Property Name="PipelineStageDescription" Type="Edm.String" /><Property Name="StageOrder" Type="Edm.Int64" /><Property Name="PipelineID" Type="Edm.Int64" /><Property Name="PipelineName" Type="Edm.String" /><Property Name="PipelineDescription" Type="Edm.String" /><Property Name="TeamName" Type="Edm.String" /><Property Name="DaysOnCurrentStage" Type="Edm.Int32" /><Property Name="OnCurrentStageSinceUTC" Type="Edm.DateTimeOffset" /></EntityType><EntityType Name="vwSalesPipeline"><Key><PropertyRef Name="PipelineID" /></Key><Property Name="PipelineID" Type="Edm.Int64" Nullable="false" /><Property Name="PracticeID" Type="Edm.Int64" Nullable="false" /><Property Name="PipelineName" Type="Edm.String" /><Property Name="PipelineDescription" Type="Edm.String" /><Property Name="IsDefault" Type="Edm.Boolean" Nullable="false" /><Property Name="AssociatedOpportunityCount" Type="Edm.Int32" /><Property Name="FirstStageID" Type="Edm.Int64" /></EntityType><EntityType Name="vwSalesPipelineStage"><Key><PropertyRef Name="PipelineStageID" /></Key><Property Name="PipelineStageID" Type="Edm.Int64" Nullable="false" /><Property Name="PipelineStageName" Type="Edm.String" /><Property Name="PipelineStageDescription" Type="Edm.String" /><Property Name="StageOrder" Type="Edm.Int64" /><Property Name="AssociatedOpportunityCount" Type="Edm.Int32" /><Property Name="PipelineID" Type="Edm.Int64" Nullable="false" /><Property Name="PracticeID" Type="Edm.Int64" Nullable="false" /><Property Name="PipelineName" Type="Edm.String" /><Property Name="PipelineDescription" Type="Edm.String" /></EntityType><EntityType Name="vwMarketingList"><Key><PropertyRef Name="MarketingListID" /></Key><Property Name="MarketingListID" Type="Edm.Int64" Nullable="false" /><Property Name="PracticeID" Type="Edm.Int64" Nullable="false" /><Property Name="Name" Type="Edm.String" /><Property Name="MailChimpID" Type="Edm.String" /><Property Name="Subscribed" Type="Edm.Int32" /><Property Name="Synchronised" Type="Edm.Int32" /><Property Name="Unsynchronised" Type="Edm.Int32" /><Property Name="Unsubscribed" Type="Edm.Int32" /><Property Name="Exceptions" Type="Edm.Int32" /><Property Name="CreatedDateUTC" Type="Edm.DateTimeOffset" Nullable="false" /><Property Name="ModifiedDateUTC" Type="Edm.DateTimeOffset" Nullable="false" /><Property Name="IsSynchronised" Type="Edm.Boolean" /><Property Name="EmailPreference" Type="Edm.String" /></EntityType><EntityType Name="vwMarketingClient"><Key><PropertyRef Name="MarketingClientID" /></Key><Property Name="MarketingClientID" Type="Edm.Int64" Nullable="false" /><Property Name="XeppoCode" Type="Edm.Int64" /><Property Name="XeppoGroupCode" Type="Edm.Int64" /><Property Name="PracticeID" Type="Edm.Int64" Nullable="false" /><Property Name="Email" Type="Edm.String" /><Property Name="Name" Type="Edm.String" /><Property Name="FirstName" Type="Edm.String" /><Property Name="LastName" Type="Edm.String" /><Property Name="IsSubscribed" Type="Edm.Boolean" /><Property Name="ModifiedDateUTC" Type="Edm.DateTimeOffset" Nullable="false" /><Property Name="MarketingListID" Type="Edm.Int64" /><Property Name="MarketingListName" Type="Edm.String" /><Property Name="MailChimpID" Type="Edm.String" /><Property Name="MarketingExceptionID" Type="Edm.Int16" /><Property Name="ErrorMessage" Type="Edm.String" /><Property Name="HasException" Type="Edm.Boolean" /><Property Name="MemberStatus" Type="Edm.String" /><Property Name="IsSynchronised" Type="Edm.Boolean" /></EntityType><EntityType Name="Practice"><Key><PropertyRef Name="PracticeID" /></Key><Property Name="PracticeID" Type="Edm.Int64" Nullable="false" /><Property Name="PracticeName" Type="Edm.String" /><Property Name="SubDomain" Type="Edm.String" /><Property Name="BillingSubscriptionID" Type="Edm.String" /></EntityType><EntityType Name="vwProject"><Key><PropertyRef Name="ProjectID" /></Key><Property Name="ProjectID" Type="Edm.Int64" Nullable="false" /><Property Name="PracticeID" Type="Edm.Int64" Nullable="false" /><Property Name="XeppoCode" Type="Edm.Int64" /><Property Name="XeppoGroupCode" Type="Edm.Int64" /><Property Name="Topic" Type="Edm.String" /><Property Name="ProjectTopicID" Type="Edm.Int64" /><Property Name="Description" Type="Edm.String" /><Property Name="ProjectStageID" Type="Edm.Int64" /><Property Name="ActualStartDate" Type="Edm.DateTimeOffset" /><Property Name="ActualEndDate" Type="Edm.DateTimeOffset" /><Property Name="EstimatedStartDate" Type="Edm.DateTimeOffset" /><Property Name="EstimatedEndDate" Type="Edm.DateTimeOffset" /><Property Name="ProjectValue" Type="Edm.Decimal" Scale="Variable" /><Property Name="Status" Type="Edm.String" /><Property Name="ProjectTemplateID" Type="Edm.Int64" /><Property Name="TemplateTopic" Type="Edm.String" /><Property Name="ProjectStageName" Type="Edm.String" /><Property Name="Name" Type="Edm.String" /><Property Name="EntityType" Type="Edm.String" /><Property Name="GroupName" Type="Edm.String" /><Property Name="UserID" Type="Edm.String" /><Property Name="TeamID" Type="Edm.Int64" /><Property Name="CreatedDateUTC" Type="Edm.DateTimeOffset" Nullable="false" /><Property Name="ModifiedDateUTC" Type="Edm.DateTimeOffset" /><Property Name="CreatedByUserID" Type="Edm.String" /><Property Name="ModifiedByUserID" Type="Edm.String" /><Property Name="IsTemplate" Type="Edm.Boolean" Nullable="false" /><Property Name="IsDeleted" Type="Edm.Boolean" Nullable="false" /><Property Name="UserName" Type="Edm.String" /><Property Name="TeamName" Type="Edm.String" /><Property Name="CreatedBy" Type="Edm.String" /><Property Name="ModifiedBy" Type="Edm.String" /><Property Name="EstimatedDurationSeconds" Type="Edm.Int64" /><Property Name="EstimatedDurationHours" Type="Edm.Int64" /></EntityType><EntityType Name="vwProjectStage"><Key><PropertyRef Name="ProjectStageID" /></Key><Property Name="ProjectStageID" Type="Edm.Int64" Nullable="false" /><Property Name="PracticeID" Type="Edm.Int64" Nullable="false" /><Property Name="ProjectID" Type="Edm.Int64" Nullable="false" /><Property Name="ProjectStageName" Type="Edm.String" /><Property Name="ProjectStageDescription" Type="Edm.String" /><Property Name="StageOrder" Type="Edm.Int64" /><Property Name="ScheduledStartDate" Type="Edm.DateTimeOffset" /><Property Name="ScheduledEndDate" Type="Edm.DateTimeOffset" /><Property Name="ActualStartDate" Type="Edm.DateTimeOffset" /><Property Name="ActualEndDate" Type="Edm.DateTimeOffset" /><Property Name="EstimatedDays" Type="Edm.Int64" /><Property Name="IsTemplate" Type="Edm.Boolean" Nullable="false" /><Property Name="ActivityCount" Type="Edm.Int32" /><Property Name="PercentComplete" Type="Edm.Decimal" Scale="Variable" /><Property Name="IsActive" Type="Edm.Boolean" /></EntityType><EntityType Name="vwProjectRole"><Key><PropertyRef Name="ProjectRoleID" /></Key><Property Name="ProjectRoleID" Type="Edm.Int64" Nullable="false" /><Property Name="PracticeID" Type="Edm.Int64" Nullable="false" /><Property Name="RoleName" Type="Edm.String" /><Property Name="RoleDescription" Type="Edm.String" /><Property Name="KeyFirmContactType" Type="Edm.String" /></EntityType><EntityType Name="vwProjectParticipant"><Key><PropertyRef Name="ProjectParticipantID" /></Key><Property Name="ProjectParticipantID" Type="Edm.Int64" Nullable="false" /><Property Name="PracticeID" Type="Edm.Int64" Nullable="false" /><Property Name="ProjectID" Type="Edm.Int64" Nullable="false" /><Property Name="ProjectRoleID" Type="Edm.Int64" Nullable="false" /><Property Name="RoleName" Type="Edm.String" /><Property Name="RoleDescription" Type="Edm.String" /><Property Name="UserID" Type="Edm.String" /><Property Name="TeamID" Type="Edm.Int64" /><Property Name="ProjectParticipantTypeID" Type="Edm.Byte" Nullable="false" /><Property Name="ProjectParticipantType" Type="Edm.String" /><Property Name="ProjectParticipantName" Type="Edm.String" /></EntityType><EntityType Name="vwActivity"><Key><PropertyRef Name="ActivityID" /></Key><Property Name="ActivityID" Type="Edm.Int64" Nullable="false" /><Property Name="IsEvent" Type="Edm.Boolean" /><Property Name="Type" Type="Edm.String" /><Property Name="ActivityTypeID" Type="Edm.Int32" /><Property Name="PracticeID" Type="Edm.Int64" Nullable="false" /><Property Name="ActivityStatusID" Type="Edm.Int32" /><Property Name="ActivityStatus" Type="Edm.String" /><Property Name="RelatedEntityTypeID" Type="Edm.Int64" /><Property Name="RelatedEntityType" Type="Edm.String" /><Property Name="RelatedEntityID" Type="Edm.Int64" /><Property Name="Title" Type="Edm.String" /><Property Name="Description" Type="Edm.String" /><Property Name="StartDateTime" Type="Edm.DateTimeOffset" /><Property Name="EndDateTime" Type="Edm.DateTimeOffset" /><Property Name="IsAllDayEvent" Type="Edm.Boolean" /><Property Name="DueDateTime" Type="Edm.DateTimeOffset" /><Property Name="StartDateTimeUTC" Type="Edm.DateTimeOffset" /><Property Name="AssignedUserID" Type="Edm.String" /><Property Name="Assignee" Type="Edm.String" /><Property Name="AssignedTeamID" Type="Edm.Int64" /><Property Name="TeamName" Type="Edm.String" /><Property Name="AssignedRoleID" Type="Edm.Int64" /><Property Name="RoleName" Type="Edm.String" /><Property Name="CreatedDateUTC" Type="Edm.DateTimeOffset" /><Property Name="CreatedByUserID" Type="Edm.String" /><Property Name="Creator" Type="Edm.String" /><Property Name="ModifiedDateUTC" Type="Edm.DateTimeOffset" /><Property Name="ModifiedByUserID" Type="Edm.String" /><Property Name="CompletedDateTime" Type="Edm.DateTimeOffset" /><Property Name="Modifier" Type="Edm.String" /><Property Name="DisplayIcon" Type="Edm.String" /><Property Name="EntityName" Type="Edm.String" /><Property Name="XeppoCode" Type="Edm.Int64" /><Property Name="XeppoGroupCode" Type="Edm.Int64" /><Property Name="IsAssigned" Type="Edm.Boolean" /><Property Name="IsEmail" Type="Edm.Boolean" /><Property Name="ProjectStageID" Type="Edm.Int64" /><Property Name="IsTemplate" Type="Edm.Boolean" /><Property Name="ParentActivityID" Type="Edm.Int64" /><Property Name="ParentProjectStageID" Type="Edm.Int64" /><Property Name="StartDelayDays" Type="Edm.Int32" /><Property Name="DueDelayDays" Type="Edm.Int32" /><Property Name="ActivityCategoryID" Type="Edm.Int64" /><Property Name="ActivitySubcategoryID" Type="Edm.Int64" /><Property Name="ActivityCategoryName" Type="Edm.String" /><Property Name="ActivitySubcategoryName" Type="Edm.String" /><Property Name="DataActivityID" Type="Edm.String" /><Property Name="IsManagedInSource" Type="Edm.Boolean" Nullable="false" /><Property Name="ConnectorName" Type="Edm.String" /><Property Name="ConnectorID" Type="Edm.Int64" /><Property Name="IsActivityTemplate" Type="Edm.Boolean" Nullable="false" /><Property Name="ActivityTemplateID" Type="Edm.Int64" /><Property Name="TemplateTitle" Type="Edm.String" /><Property Name="TimeZoneOffset" Type="Edm.Int32" /><Property Name="EmailRecipients" Type="Edm.String" /><Property Name="ActivityPriorityDisplayIcon" Type="Edm.String" /><Property Name="ActivityPriorityID" Type="Edm.Byte" /><Property Name="Priority" Type="Edm.String" /><Property Name="EstimatedDurationSeconds" Type="Edm.Int64" /><Property Name="DocumentCount" Type="Edm.Int32" /><Property Name="NotesCount" Type="Edm.Int32" /><Property Name="ActionsCount" Type="Edm.Int32" /><Property Name="SourceAssignedUser" Type="Edm.String" /></EntityType><EntityType Name="vwActivityNote"><Key><PropertyRef Name="ActivityNoteID" /></Key><Property Name="ActivityNoteID" Type="Edm.Int64" Nullable="false" /><Property Name="ActivityID" Type="Edm.Int64" Nullable="false" /><Property Name="PracticeID" Type="Edm.Int64" Nullable="false" /><Property Name="Content" Type="Edm.String" /><Property Name="CreatedDateUTC" Type="Edm.DateTimeOffset" /><Property Name="ModifiedDateUTC" Type="Edm.DateTimeOffset" /><Property Name="CreatedByUserID" Type="Edm.String" /><Property Name="IsPrivate" Type="Edm.Boolean" Nullable="false" /><Property Name="IsDeleted" Type="Edm.Boolean" Nullable="false" /><Property Name="ModifiedByUserID" Type="Edm.String" /><Property Name="LastUpdated" Type="Edm.DateTimeOffset" /><Property Name="SourceConnectorID" Type="Edm.Int64" /><Property Name="DataActivityNoteID" Type="Edm.String" /><Property Name="IsManagedInSource" Type="Edm.Boolean" Nullable="false" /></EntityType><EntityType Name="vwTimeEntry"><Key><PropertyRef Name="TimeEntryID" /></Key><Property Name="TimeEntryID" Type="Edm.Int64" Nullable="false" /><Property Name="PracticeID" Type="Edm.Int64" Nullable="false" /><Property Name="TimeAttachedTo" Type="Edm.String" /><Property Name="UserID" Type="Edm.String" /><Property Name="UserName" Type="Edm.String" /><Property Name="XeppoCode" Type="Edm.Int64" /><Property Name="XeppoGroupCode" Type="Edm.Int64" /><Property Name="ActivityID" Type="Edm.Int64" /><Property Name="ProjectID" Type="Edm.Int64" /><Property Name="TimeEntryDate" Type="Edm.DateTimeOffset" /><Property Name="DurationSeconds" Type="Edm.Int64" /><Property Name="DurationHHmm" Type="Edm.String" /><Property Name="IsBillable" Type="Edm.Boolean" /><Property Name="Notes" Type="Edm.String" /><Property Name="EntityName" Type="Edm.String" /><Property Name="ProjectTopic" Type="Edm.String" /><Property Name="ActivityTitle" Type="Edm.String" /><Property Name="CreatedDateUTC" Type="Edm.DateTimeOffset" /><Property Name="ModifiedDateUTC" Type="Edm.DateTimeOffset" /><Property Name="CreatedByUserID" Type="Edm.String" /><Property Name="ModifiedByUserID" Type="Edm.String" /><Property Name="SourceConnectorID" Type="Edm.Int64" /><Property Name="IsDeleted" Type="Edm.Boolean" Nullable="false" /><Property Name="CreatedBy" Type="Edm.String" /><Property Name="ModifiedBy" Type="Edm.String" /><Property Name="JobName" Type="Edm.String" /><Property Name="JobDescription" Type="Edm.String" /><Property Name="TaskName" Type="Edm.String" /><Property Name="TaskDescription" Type="Edm.String" /><Property Name="SourceID" Type="Edm.String" /><Property Name="SyncStatusID" Type="Edm.Byte" /><Property Name="SyncStatus" Type="Edm.String" /><Property Name="SyncErrorMessage" Type="Edm.String" /><Property Name="ConnectorName" Type="Edm.String" /><Property Name="JobNumber" Type="Edm.String" /><Property Name="LastSyncDateUTC" Type="Edm.DateTimeOffset" /><Property Name="BillableJobID" Type="Edm.String" /><Property Name="BillableTaskID" Type="Edm.String" /><Property Name="InvoiceID" Type="Edm.String" /></EntityType><EntityType Name="vwBillableJob"><Key><PropertyRef Name="SourceConnectorID" /><PropertyRef Name="BillableJobID" /></Key><Property Name="SourceConnectorID" Type="Edm.Int64" Nullable="false" /><Property Name="BillableJobID" Type="Edm.String" Nullable="false" /><Property Name="ConnectorName" Type="Edm.String" /><Property Name="PracticeID" Type="Edm.Int64" Nullable="false" /><Property Name="ClientID" Type="Edm.String" /><Property Name="XeppoCode" Type="Edm.Int64" /><Property Name="Name" Type="Edm.String" /><Property Name="Code" Type="Edm.String" /><Property Name="JobName" Type="Edm.String" /><Property Name="JobDescription" Type="Edm.String" /><Property Name="Budget" Type="Edm.Decimal" Scale="Variable" /><Property Name="State" Type="Edm.String" /><Property Name="Category" Type="Edm.String" /><Property Name="Partner" Type="Edm.String" /><Property Name="Manager" Type="Edm.String" /><Property Name="StartDate" Type="Edm.DateTimeOffset" /><Property Name="DueDate" Type="Edm.DateTimeOffset" /><Property Name="SyncID" Type="Edm.String" /><Property Name="LastUpdated" Type="Edm.DateTimeOffset" /><Property Name="JobNumber" Type="Edm.String" /><Property Name="CompletedDate" Type="Edm.DateTimeOffset" /><Property Name="XeppoGroupCode" Type="Edm.Int64" /><Property Name="GroupName" Type="Edm.String" /></EntityType><EntityType Name="vwBillableTask"><Key><PropertyRef Name="SourceConnectorID" /><PropertyRef Name="BillableTaskID" /></Key><Property Name="SourceConnectorID" Type="Edm.Int64" Nullable="false" /><Property Name="BillableTaskID" Type="Edm.String" Nullable="false" /><Property Name="ConnectorName" Type="Edm.String" /><Property Name="BillableJobID" Type="Edm.String" /><Property Name="JobName" Type="Edm.String" /><Property Name="PracticeID" Type="Edm.Int64" Nullable="false" /><Property Name="TaskName" Type="Edm.String" /><Property Name="TaskDescription" Type="Edm.String" /><Property Name="EstimatedDurationSeconds" Type="Edm.Int64" /><Property Name="Label" Type="Edm.String" /><Property Name="IsBillable" Type="Edm.Boolean" /><Property Name="StartDate" Type="Edm.DateTimeOffset" /><Property Name="DueDate" Type="Edm.DateTimeOffset" /><Property Name="SyncID" Type="Edm.String" /><Property Name="LastUpdated" Type="Edm.DateTimeOffset" /><Property Name="XeppoCode" Type="Edm.Int64" /><Property Name="Name" Type="Edm.String" /><Property Name="Code" Type="Edm.String" /><Property Name="ClientID" Type="Edm.String" /><Property Name="JobNumber" Type="Edm.String" /><Property Name="JobDescription" Type="Edm.String" /><Property Name="ActualDurationSeconds" Type="Edm.Int64" /><Property Name="IsCompleted" Type="Edm.Boolean" /><Property Name="EstimatedDurationHours" Type="Edm.Decimal" Scale="Variable" /><Property Name="ActualDurationHours" Type="Edm.Decimal" Scale="Variable" /><Property Name="XeppoGroupCode" Type="Edm.Int64" /><Property Name="GroupName" Type="Edm.String" /></EntityType><EntityType Name="vwNetWorthGroup"><Key><PropertyRef Name="XeppoGroupCode" /></Key><Property Name="XeppoGroupCode" Type="Edm.Int64" Nullable="false" /><Property Name="PracticeID" Type="Edm.Int64" Nullable="false" /><Property Name="GroupName" Type="Edm.String" /><Property Name="CountSnapshot" Type="Edm.Int32" /><Property Name="TotalNetWorth" Type="Edm.Decimal" Scale="Variable" /><Property Name="TotalAsset" Type="Edm.Decimal" Scale="Variable" /><Property Name="TotalLiability" Type="Edm.Decimal" Scale="Variable" /><Property Name="TotalUnallocated" Type="Edm.Decimal" Scale="Variable" /><Property Name="TagNames" Type="Edm.String" /><Property Name="KeyFirmContactList" Type="Edm.String" /><Property Name="IsEnabled" Type="Edm.Boolean" Nullable="false" /><Property Name="ActivatedDateUTC" Type="Edm.DateTimeOffset" Nullable="false" /><Property Name="Status" Type="Edm.String" /><Property Name="StatusID" Type="Edm.Int64" /><Property Name="IsConfirmed" Type="Edm.Int16" /><Property Name="Unclassified" Type="Edm.Decimal" Scale="Variable" /></EntityType><EntityType Name="vwNetWorthData"><Key><PropertyRef Name="SourceConnectorID" /><PropertyRef Name="ClientID" /><PropertyRef Name="RecordID" /></Key><Property Name="SourceConnectorID" Type="Edm.Int64" Nullable="false" /><Property Name="ClientID" Type="Edm.String" Nullable="false" /><Property Name="RecordID" Type="Edm.String" Nullable="false" /><Property Name="PracticeID" Type="Edm.Int64" Nullable="false" /><Property Name="ClientName" Type="Edm.String" /><Property Name="ConnectorName" Type="Edm.String" /><Property Name="XeppoGroupCode" Type="Edm.Int64" Nullable="false" /><Property Name="XeppoCode" Type="Edm.Int64" Nullable="false" /><Property Name="Type" Type="Edm.String" /><Property Name="SubType" Type="Edm.String" /><Property Name="Value" Type="Edm.Decimal" Scale="Variable" /><Property Name="Name" Type="Edm.String" /><Property Name="Category" Type="Edm.String" /><Property Name="ValuationDate" Type="Edm.DateTimeOffset" /><Property Name="EnteredValue" Type="Edm.Decimal" Scale="Variable" /><Property Name="IsIgnored" Type="Edm.Boolean" Nullable="false" /><Property Name="NetWorthAccountID" Type="Edm.Int64" /><Property Name="CreatedUser" Type="Edm.String" /><Property Name="ModifiedUser" Type="Edm.String" /><Property Name="NetWorthAccount" Type="Edm.String" /><Property Name="NetWorthAllocation" Type="Edm.String" /><Property Name="NetWorthAllocationID" Type="Edm.Int64" /><Property Name="EnteredType" Type="Edm.String" /><Property Name="EnteredValuationDate" Type="Edm.DateTimeOffset" /><Property Name="EnteredOwner" Type="Edm.String" /><Property Name="CreatedDateUTC" Type="Edm.DateTimeOffset" Nullable="false" /><Property Name="ModifiedDateUTC" Type="Edm.DateTimeOffset" /><Property Name="KendoGridID" Type="Edm.String" /><Property Name="IsJoint" Type="Edm.Boolean" Nullable="false" /><Property Name="IsDuplicate" Type="Edm.Boolean" Nullable="false" /><Property Name="IsDeleted" Type="Edm.Boolean" Nullable="false" /><Property Name="AccountName" Type="Edm.String" /><Property Name="Exchange" Type="Edm.String" /><Property Name="AssetCode" Type="Edm.String" /><Property Name="Vendor" Type="Edm.String" /><Property Name="Units" Type="Edm.String" /><Property Name="IsConfirmed" Type="Edm.Boolean" /></EntityType><EntityType Name="vwNetWorthLiveData"><Key><PropertyRef Name="SourceConnectorID" /><PropertyRef Name="ClientID" /><PropertyRef Name="RecordID" /></Key><Property Name="SourceConnectorID" Type="Edm.Int64" Nullable="false" /><Property Name="ClientID" Type="Edm.String" Nullable="false" /><Property Name="RecordID" Type="Edm.String" Nullable="false" /><Property Name="PracticeID" Type="Edm.Int64" Nullable="false" /><Property Name="XeppoCode" Type="Edm.Int64" Nullable="false" /><Property Name="XeppoGroupCode" Type="Edm.Int64" Nullable="false" /><Property Name="Type" Type="Edm.String" /><Property Name="SubType" Type="Edm.String" /><Property Name="Value" Type="Edm.Decimal" Scale="Variable" /><Property Name="Name" Type="Edm.String" /><Property Name="Category" Type="Edm.String" /><Property Name="IsIgnored" Type="Edm.Boolean" Nullable="false" /><Property Name="NetWorthAccount" Type="Edm.String" /><Property Name="NetWorthAccountID" Type="Edm.Int64" /><Property Name="NetWorthAllocation" Type="Edm.String" /><Property Name="NetWorthAllocationID" Type="Edm.Int64" /><Property Name="Owner" Type="Edm.String" /><Property Name="ValuationDate" Type="Edm.DateTimeOffset" /><Property Name="KendoGridID" Type="Edm.String" /><Property Name="ConnectorName" Type="Edm.String" /><Property Name="IsJoint" Type="Edm.Boolean" Nullable="false" /><Property Name="IsDuplicate" Type="Edm.Boolean" Nullable="false" /><Property Name="IsDeleted" Type="Edm.Boolean" Nullable="false" /></EntityType><EntityType Name="vwNetWorthAccount"><Key><PropertyRef Name="NetWorthAccountID" /></Key><Property Name="NetWorthAccountID" Type="Edm.Int64" Nullable="false" /><Property Name="ParentNetWorthAcountID" Type="Edm.Int64" /><Property Name="PracticeID" Type="Edm.Int64" Nullable="false" /><Property Name="AccountCode" Type="Edm.String" /><Property Name="AccountName" Type="Edm.String" /><Property Name="AccountDescription" Type="Edm.String" /><Property Name="ShowDetail" Type="Edm.Boolean" Nullable="false" /></EntityType><EntityType Name="vwNetWorthAllocation"><Key><PropertyRef Name="NetWorthAllocationID" /></Key><Property Name="NetWorthAllocationID" Type="Edm.Int64" Nullable="false" /><Property Name="ParentNetWorthAllocationID" Type="Edm.Int64" /><Property Name="PracticeID" Type="Edm.Int64" Nullable="false" /><Property Name="AllocationCode" Type="Edm.String" /><Property Name="AllocationName" Type="Edm.String" /><Property Name="AllocationDescription" Type="Edm.String" /><Property Name="IsAsset" Type="Edm.Boolean" Nullable="false" /></EntityType><EntityType Name="vwNetWorthSnapshot"><Key><PropertyRef Name="NetWorthSnapshotID" /></Key><Property Name="NetWorthSnapshotID" Type="Edm.Int64" Nullable="false" /><Property Name="PracticeID" Type="Edm.Int64" Nullable="false" /><Property Name="XeppoGroupCode" Type="Edm.Int64" Nullable="false" /><Property Name="CreatedDateUTC" Type="Edm.DateTimeOffset" Nullable="false" /><Property Name="IsBackdated" Type="Edm.Boolean" Nullable="false" /><Property Name="DataLevel" Type="Edm.String" /><Property Name="GroupName" Type="Edm.String" /><Property Name="IsEnabled" Type="Edm.Boolean" Nullable="false" /><Property Name="PeriodEndDate" Type="Edm.DateTimeOffset" Nullable="false" /></EntityType><EntityType Name="vwNetWorthSnapshotData"><Key><PropertyRef Name="NetWorthSnapshotDataID" /></Key><Property Name="NetWorthSnapshotDataID" Type="Edm.Int64" Nullable="false" /><Property Name="NetWorthSnapshotID" Type="Edm.Int64" Nullable="false" /><Property Name="XeppoCode" Type="Edm.Int64" Nullable="false" /><Property Name="Type" Type="Edm.String" /><Property Name="Subtype" Type="Edm.String" /><Property Name="Category" Type="Edm.String" /><Property Name="ClientID" Type="Edm.String" /><Property Name="RecordID" Type="Edm.String" /><Property Name="SourceConnectorID" Type="Edm.Int64" /><Property Name="RecordName" Type="Edm.String" /><Property Name="NetWorthAccount" Type="Edm.String" /><Property Name="NetWorthAccountID" Type="Edm.Int64" /><Property Name="Value" Type="Edm.Decimal" Scale="Variable" /><Property Name="IsIgnored" Type="Edm.Boolean" Nullable="false" /><Property Name="NetWorthAllocation" Type="Edm.String" /><Property Name="NetWorthAllocationID" Type="Edm.Int64" /><Property Name="Owner" Type="Edm.String" /><Property Name="ValuationDate" Type="Edm.DateTimeOffset" /><Property Name="PracticeID" Type="Edm.Int64" Nullable="false" /><Property Name="XeppoGroupCode" Type="Edm.Int64" /><Property Name="CurrentRecordName" Type="Edm.String" /><Property Name="Exchange" Type="Edm.String" /><Property Name="AssetCode" Type="Edm.String" /><Property Name="Vendor" Type="Edm.String" /><Property Name="Units" Type="Edm.String" /></EntityType><EntityType Name="vwNetWorthSnapshotTotal"><Key><PropertyRef Name="NetWorthSnapshotTotalID" /></Key><Property Name="NetWorthSnapshotTotalID" Type="Edm.Int64" Nullable="false" /><Property Name="NetWorthSnapshotID" Type="Edm.Int64" Nullable="false" /><Property Name="Type" Type="Edm.String" /><Property Name="Value" Type="Edm.Decimal" Scale="Variable" /><Property Name="NetWorthAccount" Type="Edm.String" /><Property Name="NetWorthAccountID" Type="Edm.Int64" Nullable="false" /><Property Name="NetWorthAllocation" Type="Edm.String" /><Property Name="NetWorthAllocationID" Type="Edm.Int64" /><Property Name="DataLevel" Type="Edm.String" /><Property Name="PracticeID" Type="Edm.Int64" Nullable="false" /></EntityType><EntityType Name="vwFDSData"><Key><PropertyRef Name="FDSDataID" /></Key><Property Name="FDSDataID" Type="Edm.Int64" Nullable="false" /><Property Name="XeppoCode" Type="Edm.Int64" Nullable="false" /><Property Name="XeppoGroupCode" Type="Edm.Int64" Nullable="false" /><Property Name="PracticeID" Type="Edm.Int64" Nullable="false" /><Property Name="Name" Type="Edm.String" /><Property Name="FDSStatus" Type="Edm.String" /><Property Name="OptInStatus" Type="Edm.String" /><Property Name="FDSPeriodStartDate" Type="Edm.DateTimeOffset" /><Property Name="FDSPeriodEndDate" Type="Edm.DateTimeOffset" Nullable="false" /><Property Name="DisclosureStatementRequired" Type="Edm.Boolean" /><Property Name="NextDisclosureStatementDate" Type="Edm.DateTimeOffset" /><Property Name="ShouldSendOptInNotice" Type="Edm.Boolean" /><Property Name="OptInRequired" Type="Edm.Boolean" /><Property Name="NextOptInDate" Type="Edm.DateTimeOffset" /><Property Name="IsSubjectToOptInGrandfathering" Type="Edm.Boolean" /><Property Name="GeneratedDate" Type="Edm.DateTimeOffset" /><Property Name="FinalisedDate" Type="Edm.DateTimeOffset" /><Property Name="SentDate" Type="Edm.DateTimeOffset" /><Property Name="OptInDueDate" Type="Edm.DateTimeOffset" /><Property Name="OptInNoticeResponseDate" Type="Edm.DateTimeOffset" /><Property Name="DocumentViewedDateTime" Type="Edm.DateTimeOffset" /><Property Name="FDSDocumentID" Type="Edm.Int64" /><Property Name="DataDocumentID" Type="Edm.Int64" /><Property Name="IsFinalDocument" Type="Edm.Boolean" /><Property Name="FDSStatusID" Type="Edm.Int32" Nullable="false" /><Property Name="FDSOptInStatusID" Type="Edm.Int32" /><Property Name="FDSDueStartDate" Type="Edm.DateTimeOffset" /><Property Name="FDSOverdueStartDate" Type="Edm.DateTimeOffset" /><Property Name="FDSAdviserID" Type="Edm.Int64" /><Property Name="FDSAdviserName" Type="Edm.String" /><Property Name="FDSAdviserEmail" Type="Edm.String" /><Property Name="TotalFees" Type="Edm.Decimal" Scale="Variable" /><Property Name="TotalCommission" Type="Edm.Decimal" Scale="Variable" /><Property Name="TotalRevenue" Type="Edm.Decimal" Scale="Variable" /><Property Name="PreferredEmail" Type="Edm.String" /><Property Name="RootFDSDataID" Type="Edm.Int64" /><Property Name="PreviousFDSDataID" Type="Edm.Int64" /><Property Name="FeesProcessing" Type="Edm.Boolean" /><Property Name="FDSDuePeriodEndDate" Type="Edm.DateTimeOffset" /></EntityType><EntityType Name="vwFDSClient"><Key><PropertyRef Name="XeppoCode" /></Key><Property Name="XeppoCode" Type="Edm.Int64" Nullable="false" /><Property Name="PracticeID" Type="Edm.Int64" Nullable="false" /><Property Name="XeppoGroupCode" Type="Edm.Int64" /><Property Name="Name" Type="Edm.String" /><Property Name="DisclosureStatementRequired" Type="Edm.Boolean" Nullable="false" /><Property Name="EntityType" Type="Edm.String" /><Property Name="FDSDataID" Type="Edm.Int64" /><Property Name="FDSAdviserID" Type="Edm.Int64" /><Property Name="FDSAdviserName" Type="Edm.String" /><Property Name="FDSDocumentID" Type="Edm.Int64" /><Property Name="DataDocumentID" Type="Edm.Int64" /><Property Name="FDSStatus" Type="Edm.String" /><Property Name="FDSStatusID" Type="Edm.Int32" /><Property Name="FDSPeriodStartDate" Type="Edm.DateTimeOffset" /><Property Name="FDSPeriodEndDate" Type="Edm.DateTimeOffset" /><Property Name="NextDisclosureStatementDate" Type="Edm.DateTimeOffset" /><Property Name="FDSDueStartDate" Type="Edm.DateTimeOffset" /><Property Name="FDSOverdueStartDate" Type="Edm.DateTimeOffset" /><Property Name="GeneratedDate" Type="Edm.DateTimeOffset" /><Property Name="FinalisedDate" Type="Edm.DateTimeOffset" /><Property Name="SentDate" Type="Edm.DateTimeOffset" /><Property Name="NextOptInDate" Type="Edm.DateTimeOffset" /><Property Name="OptInDueDate" Type="Edm.DateTimeOffset" /><Property Name="OptInNoticeResponseDate" Type="Edm.DateTimeOffset" /><Property Name="ShouldSendOptInNotice" Type="Edm.Boolean" /><Property Name="OptInStatus" Type="Edm.String" /><Property Name="FDSOptInStatusID" Type="Edm.Int32" /><Property Name="OptInRequired" Type="Edm.Boolean" /><Property Name="IsSubjectToOptInGrandfathering" Type="Edm.Boolean" /><Property Name="IsFinalDocument" Type="Edm.Boolean" /><Property Name="IsCurrent" Type="Edm.Boolean" /><Property Name="IsPrimaryContact" Type="Edm.Boolean" Nullable="false" /><Property Name="ParentXeppoCode" Type="Edm.Int64" /><Property Name="StatusID" Type="Edm.Int64" /><Property Name="FDSDuePeriodEndDate" Type="Edm.DateTimeOffset" /></EntityType><EntityType Name="vwFDSClientPrimary"><Key><PropertyRef Name="XeppoCode" /></Key><Property Name="XeppoCode" Type="Edm.Int64" Nullable="false" /><Property Name="PracticeID" Type="Edm.Int64" Nullable="false" /><Property Name="XeppoGroupCode" Type="Edm.Int64" /><Property Name="Name" Type="Edm.String" /><Property Name="DisclosureStatementRequired" Type="Edm.Boolean" Nullable="false" /><Property Name="FDSDataID" Type="Edm.Int64" /><Property Name="FDSAdviserID" Type="Edm.Int64" /><Property Name="FDSAdviserName" Type="Edm.String" /><Property Name="FDSDocumentID" Type="Edm.Int64" /><Property Name="DataDocumentID" Type="Edm.Int64" /><Property Name="FDSStatus" Type="Edm.String" /><Property Name="FDSStatusID" Type="Edm.Int32" /><Property Name="FDSPeriodStartDate" Type="Edm.DateTimeOffset" /><Property Name="FDSPeriodEndDate" Type="Edm.DateTimeOffset" /><Property Name="NextDisclosureStatementDate" Type="Edm.DateTimeOffset" /><Property Name="GeneratedDate" Type="Edm.DateTimeOffset" /><Property Name="FinalisedDate" Type="Edm.DateTimeOffset" /><Property Name="SentDate" Type="Edm.DateTimeOffset" /><Property Name="NextOptInDate" Type="Edm.DateTimeOffset" /><Property Name="OptInDueDate" Type="Edm.DateTimeOffset" /><Property Name="OptInNoticeResponseDate" Type="Edm.DateTimeOffset" /><Property Name="ShouldSendOptInNotice" Type="Edm.Boolean" /><Property Name="OptInStatus" Type="Edm.String" /><Property Name="FDSOptInStatusID" Type="Edm.Int32" /><Property Name="OptInRequired" Type="Edm.Boolean" /><Property Name="IsSubjectToOptInGrandfathering" Type="Edm.Boolean" /><Property Name="IsFinalDocument" Type="Edm.Boolean" /><Property Name="IsCurrent" Type="Edm.Boolean" /><Property Name="IsPrimaryContact" Type="Edm.Boolean" Nullable="false" /><Property Name="ParentXeppoCode" Type="Edm.Int64" /><Property Name="Services" Type="Edm.String" /><Property Name="FDSEntities" Type="Edm.String" /><Property Name="TotalFees" Type="Edm.Decimal" Scale="Variable" /><Property Name="TotalCommission" Type="Edm.Decimal" Scale="Variable" /><Property Name="TotalRevenue" Type="Edm.Decimal" Scale="Variable" /><Property Name="PreferredEmail" Type="Edm.String" /><Property Name="TagNames" Type="Edm.String" /><Property Name="CustomFDSPeriods" Type="Edm.Boolean" /><Property Name="FDSDueStartDate" Type="Edm.DateTimeOffset" /><Property Name="FDSOverdueStartDate" Type="Edm.DateTimeOffset" /><Property Name="FDSDuePeriodEndDate" Type="Edm.DateTimeOffset" /></EntityType><EntityType Name="vwFDSClientService"><Key><PropertyRef Name="FDSClientServiceID" /></Key><Property Name="FDSClientServiceID" Type="Edm.Int64" Nullable="false" /><Property Name="PracticeID" Type="Edm.Int64" Nullable="false" /><Property Name="XeppoCode" Type="Edm.Int64" /><Property Name="XeppoGroupCode" Type="Edm.Int64" /><Property Name="FDSDataID" Type="Edm.Int64" Nullable="false" /><Property Name="FDSServiceID" Type="Edm.Int64" Nullable="false" /><Property Name="ClientName" Type="Edm.String" /><Property Name="ServiceName" Type="Edm.String" /><Property Name="ServiceDescription" Type="Edm.String" /><Property Name="HasBeenProvided" Type="Edm.Boolean" Nullable="false" /><Property Name="ServiceFrequencyID" Type="Edm.Int64" Nullable="false" /><Property Name="ServiceFrequencyName" Type="Edm.String" /><Property Name="NumberOfDocumentsFound" Type="Edm.Int32" /><Property Name="NumberOfActivitiesFound" Type="Edm.Int32" /><Property Name="ParentName" Type="Edm.String" /><Property Name="ClientXeppoCode" Type="Edm.Int64" /></EntityType><EntityType Name="vwFDSEvent"><Key><PropertyRef Name="EventID" /></Key><Property Name="EventID" Type="Edm.Int64" Nullable="false" /><Property Name="PracticeID" Type="Edm.Int64" Nullable="false" /><Property Name="EventTypeID" Type="Edm.Int64" /><Property Name="RelatedEntityTypeID" Type="Edm.Int64" /><Property Name="RelatedEntityID" Type="Edm.Int64" /><Property Name="EventDetail" Type="Edm.String" /><Property Name="CreatedDateUTC" Type="Edm.DateTimeOffset" /><Property Name="CreatedByUserID" Type="Edm.String" /><Property Name="Type" Type="Edm.String" /><Property Name="XeppoCode" Type="Edm.Int64" /><Property Name="XeppoGroupCode" Type="Edm.Int64" /><Property Name="ClientName" Type="Edm.String" /><Property Name="Creator" Type="Edm.String" /></EntityType><EntityType Name="vwFDSService"><Key><PropertyRef Name="FDSServiceID" /></Key><Property Name="FDSServiceID" Type="Edm.Int64" Nullable="false" /><Property Name="PracticeID" Type="Edm.Int64" Nullable="false" /><Property Name="ServiceName" Type="Edm.String" /><Property Name="ServiceDescription" Type="Edm.String" /><Property Name="ServiceFrequencyID" Type="Edm.Int64" /><Property Name="ServiceFrequencyName" Type="Edm.String" /><Property Name="DocumentCategories" Type="Edm.String" /><Property Name="ActivityCategories" Type="Edm.String" /><Property Name="EvidenceValues" Type="Collection(Opex.Xeppo.Server.Entity.FDSEvidenceValue)" /></EntityType><EntityType Name="vwFDSServicePackage"><Key><PropertyRef Name="FDSServicePackageID" /></Key><Property Name="FDSServicePackageID" Type="Edm.Int64" Nullable="false" /><Property Name="PackageName" Type="Edm.String" /><Property Name="PackageDescription" Type="Edm.String" /><Property Name="PracticeID" Type="Edm.Int64" Nullable="false" /><Property Name="AssociatedServicesCount" Type="Edm.Int32" /></EntityType><EntityType Name="vwFDSServicePackageService"><Key><PropertyRef Name="FDSServiceID" /></Key><Property Name="FDSServiceID" Type="Edm.Int64" Nullable="false" /><Property Name="FDSServicePackageID" Type="Edm.Int64" /><Property Name="PracticeID" Type="Edm.Int64" Nullable="false" /><Property Name="Name" Type="Edm.String" /><Property Name="Description" Type="Edm.String" /><Property Name="FDSServiceFrequencyID" Type="Edm.Int64" /></EntityType><EntityType Name="vwFDSAdviser"><Key><PropertyRef Name="FDSAdviserID" /></Key><Property Name="FDSAdviserID" Type="Edm.Int64" Nullable="false" /><Property Name="PracticeID" Type="Edm.Int64" Nullable="false" /><Property Name="Name" Type="Edm.String" /><Property Name="ABN" Type="Edm.String" /><Property Name="ASICLicenseNumber" Type="Edm.String" /><Property Name="LicenseeName" Type="Edm.String" /><Property Name="Email" Type="Edm.String" /><Property Name="Phone" Type="Edm.String" /><Property Name="CreatedDateUTC" Type="Edm.DateTimeOffset" /><Property Name="CreatedByUserID" Type="Edm.String" /><Property Name="ModifiedDateUTC" Type="Edm.DateTimeOffset" /><Property Name="ModifiedByUserID" Type="Edm.String" /><Property Name="KeyFirmContactName" Type="Edm.String" /><Property Name="FDSAssentAdviserTypeID" Type="Edm.Int32" /><NavigationProperty Name="FDSAssentAdviserType" Type="Opex.Xeppo.Server.Entity.FDSAssentAdviserType"><ReferentialConstraint Property="FDSAssentAdviserTypeID" ReferencedProperty="FDSAssentAdviserTypeID" /></NavigationProperty></EntityType><EntityType Name="vwFDSFee"><Key><PropertyRef Name="SourceConnectorID" /><PropertyRef Name="FeeID" /></Key><Property Name="SourceConnectorID" Type="Edm.Int64" Nullable="false" /><Property Name="FeeID" Type="Edm.String" Nullable="false" /><Property Name="XeppoCode" Type="Edm.Int64" /><Property Name="FDSDataID" Type="Edm.Int64" /><Property Name="InvoiceDate" Type="Edm.DateTimeOffset" /><Property Name="InvoiceNo" Type="Edm.String" /><Property Name="FeeCategoryID" Type="Edm.Int64" /><Property Name="FeeCategoryName" Type="Edm.String" /><Property Name="PracticeID" Type="Edm.Int64" Nullable="false" /><Property Name="Gross" Type="Edm.Decimal" Scale="Variable" /><Property Name="Writeoff" Type="Edm.Double" /><Property Name="Val" Type="Edm.Double" /></EntityType><EntityType Name="vwFDSCommission"><Key><PropertyRef Name="SourceConnectorID" /><PropertyRef Name="TempKey" /></Key><Property Name="SourceConnectorID" Type="Edm.Int64" Nullable="false" /><Property Name="TempKey" Type="Edm.String" Nullable="false" /><Property Name="XeppoCode" Type="Edm.Int64" /><Property Name="FDSDataID" Type="Edm.Int64" /><Property Name="StatementRecordDate" Type="Edm.DateTimeOffset" /><Property Name="PracticeID" Type="Edm.Int64" Nullable="false" /><Property Name="FeeCategoryID" Type="Edm.Int64" /><Property Name="FeeCategoryName" Type="Edm.String" /><Property Name="Gross" Type="Edm.Decimal" Scale="Variable" /></EntityType><EntityType Name="vwFDSClientFeeCategory"><Key><PropertyRef Name="XeppoCode" /><PropertyRef Name="FeeCategoryID" /></Key><Property Name="XeppoCode" Type="Edm.Int64" Nullable="false" /><Property Name="FeeCategoryID" Type="Edm.Int64" Nullable="false" /><Property Name="XeppoGroupCode" Type="Edm.Int64" /><Property Name="ClientName" Type="Edm.String" /><Property Name="FeeCategoryName" Type="Edm.String" /><Property Name="PracticeID" Type="Edm.Int64" Nullable="false" /><Property Name="FDSDataID" Type="Edm.Int64" /><Property Name="IsSelected" Type="Edm.Boolean" /><Property Name="TotalFees" Type="Edm.Decimal" Scale="Variable" /><Property Name="TotalCommission" Type="Edm.Decimal" Scale="Variable" /><Property Name="TotalRevenue" Type="Edm.Decimal" Scale="Variable" /><Property Name="IsPrimaryContact" Type="Edm.Boolean" Nullable="false" /><Property Name="ParentXeppoCode" Type="Edm.Int64" Nullable="false" /><Property Name="ParentName" Type="Edm.String" /><Property Name="IsEstimate" Type="Edm.Boolean" /><Property Name="EstimateDescription" Type="Edm.String" /><Property Name="FDSClientEstimatedRevenueID" Type="Edm.Int64" /></EntityType><EntityType Name="vwFDSClientSignatory"><Key><PropertyRef Name="FDSClientSignatoryID" /></Key><Property Name="FDSClientSignatoryID" Type="Edm.Int64" Nullable="false" /><Property Name="PracticeID" Type="Edm.Int64" Nullable="false" /><Property Name="XeppoCode" Type="Edm.Int64" Nullable="false" /><Property Name="ClientName" Type="Edm.String" /><Property Name="SignatoryName" Type="Edm.String" /><Property Name="IsPrimaryContact" Type="Edm.Boolean" Nullable="false" /><Property Name="ParentName" Type="Edm.String" /><Property Name="SignatoryEmail" Type="Edm.String" /><Property Name="ClientXeppoCode" Type="Edm.Int64" Nullable="false" /></EntityType><EntityType Name="vwFDSSettingsOdataView"><Key><PropertyRef Name="PracticeID" /></Key><Property Name="PracticeID" Type="Edm.Int64" Nullable="false" /><Property Name="FDSDuePeriod" Type="Edm.Int32" /><Property Name="OptInRenewalPeriod" Type="Edm.Int32" /><Property Name="OptInSchedule" Type="Edm.Int32" /><Property Name="CustomReplyToEmail" Type="Edm.String" /></EntityType><EntityType Name="vwFDSTerm"><Key><PropertyRef Name="FDSTermID" /></Key><Property Name="FDSTermID" Type="Edm.Int64" Nullable="false" /><Property Name="PracticeID" Type="Edm.Int64" Nullable="false" /><Property Name="XeppoCode" Type="Edm.Int64" Nullable="false" /><Property Name="ClientXeppoCode" Type="Edm.Int64" Nullable="false" /><Property Name="FDSDataID" Type="Edm.Int64" Nullable="false" /><Property Name="FeeAmountPerPeriod" Type="Edm.Decimal" Nullable="false" Scale="Variable" /><Property Name="Frequency" Type="Edm.String" /><Property Name="FeeAmount" Type="Edm.Decimal" Nullable="false" Scale="Variable" /><Property Name="IsFeeAmountEstimated" Type="Edm.Boolean" Nullable="false" /></EntityType><EntityType Name="vwFDSTermProvider"><Key><PropertyRef Name="FDSTermProviderID" /></Key><Property Name="FDSTermProviderID" Type="Edm.Int64" Nullable="false" /><Property Name="PracticeID" Type="Edm.Int64" Nullable="false" /><Property Name="XeppoCode" Type="Edm.Int64" Nullable="false" /><Property Name="ClientXeppoCode" Type="Edm.Int64" Nullable="false" /><Property Name="FDSDataID" Type="Edm.Int64" Nullable="false" /><Property Name="FDSTermID" Type="Edm.Int64" Nullable="false" /><Property Name="StartDate" Type="Edm.DateTimeOffset" /><Property Name="ProductName" Type="Edm.String" /><Property Name="AccountNumber" Type="Edm.String" /><Property Name="AdvisorOrSupplierCode" Type="Edm.String" /><Property Name="FeeAmount" Type="Edm.Decimal" Nullable="false" Scale="Variable" /><Property Name="FeeCalculationDescription" Type="Edm.String" /><Property Name="PreviousFDSTermProviderID" Type="Edm.Int64" /><Property Name="LossOfBenefitsInformation" Type="Edm.String" /><Property Name="AccountTypeID" Type="Edm.Int32" Nullable="false" /><Property Name="AccountTypeName" Type="Edm.String" /><Property Name="ProviderID" Type="Edm.Int64" /><Property Name="ProviderName" Type="Edm.String" /><Property Name="ProviderAddressLine1" Type="Edm.String" /><Property Name="ProviderAddressLine2" Type="Edm.String" /><Property Name="ProviderAddressLine3" Type="Edm.String" /><Property Name="ProviderAddressSuburb" Type="Edm.String" /><Property Name="ProviderAddressState" Type="Edm.String" /><Property Name="ProviderAddressPostCode" Type="Edm.String" /><Property Name="ProviderAddressCountry" Type="Edm.String" /><Property Name="ProviderEmailAddress" Type="Edm.String" /><Property Name="ProviderPhoneNumber" Type="Edm.String" /><Property Name="ProviderWebSiteAddress" Type="Edm.String" /><Property Name="ProviderStatusID" Type="Edm.Int32" Nullable="false" /><Property Name="ProviderStatusName" Type="Edm.String" /><Property Name="AccountType" Type="Edm.String" /><Property Name="ProviderStatus" Type="Edm.String" /></EntityType><EntityType Name="vwFDSTermProviderSignatory"><Key><PropertyRef Name="XeppoCode" /><PropertyRef Name="ClientXeppoCode" /><PropertyRef Name="FDSTermProviderID" /></Key><Property Name="XeppoCode" Type="Edm.Int64" Nullable="false" /><Property Name="ClientXeppoCode" Type="Edm.Int64" Nullable="false" /><Property Name="FDSTermProviderID" Type="Edm.Int64" Nullable="false" /><Property Name="PracticeID" Type="Edm.Int64" Nullable="false" /><Property Name="Name" Type="Edm.String" /><Property Name="Email" Type="Edm.String" /><Property Name="Address" Type="Edm.String" /></EntityType><EntityType Name="vwFDSProvider"><Key><PropertyRef Name="FDSProviderID" /></Key><Property Name="FDSProviderID" Type="Edm.Int64" Nullable="false" /><Property Name="PracticeID" Type="Edm.Int64" Nullable="false" /><Property Name="Name" Type="Edm.String" /><Property Name="AddressLine1" Type="Edm.String" /><Property Name="AddressLine2" Type="Edm.String" /><Property Name="AddressLine3" Type="Edm.String" /><Property Name="AddressSuburb" Type="Edm.String" /><Property Name="AddressState" Type="Edm.String" /><Property Name="AddressPostCode" Type="Edm.String" /><Property Name="AddressCountry" Type="Edm.String" /><Property Name="PhoneNumber" Type="Edm.String" /><Property Name="EmailAddress" Type="Edm.String" /><Property Name="WebSiteAddress" Type="Edm.String" /></EntityType><EntityType Name="vwFDSClientServiceFact"><Key><PropertyRef Name="FDSClientServiceID" /></Key><Property Name="FDSClientServiceID" Type="Edm.Int64" Nullable="false" /><Property Name="PracticeID" Type="Edm.Int64" Nullable="false" /><Property Name="XeppoCode" Type="Edm.Int64" /><Property Name="XeppoGroupCode" Type="Edm.Int64" /><Property Name="FDSDataID" Type="Edm.Int64" Nullable="false" /><Property Name="FDSServiceID" Type="Edm.Int64" Nullable="false" /><Property Name="ClientName" Type="Edm.String" /><Property Name="ServiceName" Type="Edm.String" /><Property Name="ServiceDescription" Type="Edm.String" /><Property Name="HasBeenProvided" Type="Edm.Boolean" Nullable="false" /><Property Name="ServiceFrequencyID" Type="Edm.Int64" Nullable="false" /><Property Name="ServiceFrequencyName" Type="Edm.String" /><Property Name="NumberOfDocumentsFound" Type="Edm.Int32" /><Property Name="NumberOfActivitiesFound" Type="Edm.Int32" /><Property Name="ParentName" Type="Edm.String" /><Property Name="ClientXeppoCode" Type="Edm.Int64" /></EntityType><EntityType Name="FDSAssentCollectionAdviser"><Key><PropertyRef Name="FDSAssentCollectionID" /><PropertyRef Name="FDSAdviserID" /></Key><Property Name="FDSAssentCollectionID" Type="Edm.Int64" Nullable="false" /><Property Name="FDSAdviserID" Type="Edm.Int64" Nullable="false" /><Property Name="PracticeID" Type="Edm.Int64" Nullable="false" /><Property Name="Name" Type="Edm.String" /><Property Name="ABN" Type="Edm.String" /><Property Name="ASICLicenseNumber" Type="Edm.String" /><Property Name="LicenseeName" Type="Edm.String" /><Property Name="Email" Type="Edm.String" /><Property Name="Phone" Type="Edm.String" /><Property Name="KeyFirmContactName" Type="Edm.String" /><Property Name="FDSAssentAdviserTypeID" Type="Edm.Int32" /><Property Name="AdvisorTypeName" Type="Edm.String" /><Property Name="AdvisorTypeDescription" Type="Edm.String" /></EntityType><EntityType Name="FDSAssentCollection"><Key><PropertyRef Name="FDSAssentCollectionID" /></Key><Property Name="FDSAssentCollectionID" Type="Edm.Int64" Nullable="false" /><Property Name="PracticeID" Type="Edm.Int64" Nullable="false" /><Property Name="FDSAssentCollectionTypeID" Type="Edm.Guid" /><Property Name="FDSAssentCollectionTypeName" Type="Edm.String" /><Property Name="FDSAssentCollectionStatusID" Type="Edm.Int32" Nullable="false" /><Property Name="FDSAssentCollectionStatusName" Type="Edm.String" /><Property Name="RegisteredAdviserID" Type="Edm.Int64" Nullable="false" /><Property Name="RegisteredAdviserName" Type="Edm.String" /><Property Name="PractisingAdviserID" Type="Edm.Int64" /><Property Name="PractisingAdviserName" Type="Edm.String" /><Property Name="ExpectedStartDate" Type="Edm.DateTimeOffset" /><Property Name="ExpectedEndDate" Type="Edm.DateTimeOffset" /><Property Name="IssuedDate" Type="Edm.DateTimeOffset" /><Property Name="StartedDate" Type="Edm.DateTimeOffset" /><Property Name="TerminatedDate" Type="Edm.DateTimeOffset" /><Property Name="DeclinedDate" Type="Edm.DateTimeOffset" /></EntityType><EntityType Name="FDSAssentCollectionClient"><Key><PropertyRef Name="FDSAssentCollectionID" /><PropertyRef Name="XeppoCode" /></Key><Property Name="FDSAssentCollectionID" Type="Edm.Int64" Nullable="false" /><Property Name="XeppoCode" Type="Edm.Int64" Nullable="false" /><Property Name="PracticeID" Type="Edm.Int64" Nullable="false" /><Property Name="IsPrimary" Type="Edm.Boolean" /><Property Name="ClientName" Type="Edm.String" /><Property Name="ClientPreferredName" Type="Edm.String" /><Property Name="ClientFirstName" Type="Edm.String" /><Property Name="ClientLastName" Type="Edm.String" /><Property Name="ClientDateOfBirth" Type="Edm.DateTimeOffset" /><Property Name="ClientEntityType" Type="Edm.String" /><Property Name="ClientSalutation" Type="Edm.String" /><Property Name="ClientMailName" Type="Edm.String" /><Property Name="ClientPreferredEmail" Type="Edm.String" /><Property Name="ClientPreferredAddressLine1" Type="Edm.String" /><Property Name="ClientPreferredAddressLine2" Type="Edm.String" /><Property Name="ClientPreferredAddressLine3" Type="Edm.String" /><Property Name="ClientPreferredAddressSuburb" Type="Edm.String" /><Property Name="ClientPreferredAddressState" Type="Edm.String" /><Property Name="ClientPreferredAddressPostCode" Type="Edm.String" /><Property Name="ClientPreferredAddress" Type="Edm.String" /></EntityType><EntityType Name="FDSAssentCollectionSignatory"><Key><PropertyRef Name="FDSAssentCollectionID" /><PropertyRef Name="FDSAssentCollectionSignatoryID" /></Key><Property Name="FDSAssentCollectionID" Type="Edm.Int64" Nullable="false" /><Property Name="FDSAssentCollectionSignatoryID" Type="Edm.Int64" Nullable="false" /><Property Name="PracticeID" Type="Edm.Int64" Nullable="false" /><Property Name="Name" Type="Edm.String" /><Property Name="Email" Type="Edm.String" /></EntityType><EntityType Name="FDSAssentRecord"><Key><PropertyRef Name="FDSAssentRecordID" /></Key><Property Name="FDSAssentRecordID" Type="Edm.Int64" Nullable="false" /><Property Name="PracticeID" Type="Edm.Int64" Nullable="false" /><Property Name="FDSAssentCollectionID" Type="Edm.Int64" Nullable="false" /><Property Name="FDSAssentRecordPeriod" Type="Edm.Int64" Nullable="false" /><Property Name="PreviousID" Type="Edm.Int64" /><Property Name="FDSAssentRecordStatusID" Type="Edm.Int32" Nullable="false" /><Property Name="FDSAssentRecordStatusName" Type="Edm.String" /><Property Name="PeriodStartDate" Type="Edm.DateTimeOffset" /><Property Name="PeriodEndDate" Type="Edm.DateTimeOffset" /><Property Name="DueDate" Type="Edm.DateTimeOffset" /><Property Name="OverdueDate" Type="Edm.DateTimeOffset" /><Property Name="ReadyForTerminationDate" Type="Edm.DateTimeOffset" /><Property Name="GeneratedDate" Type="Edm.DateTimeOffset" /><Property Name="FinalisedDate" Type="Edm.DateTimeOffset" /><Property Name="RenewedDate" Type="Edm.DateTimeOffset" /><Property Name="SentDateTimeUTC" Type="Edm.DateTimeOffset" /><Property Name="CreatedTimeUTC" Type="Edm.DateTimeOffset" Nullable="false" /><Property Name="PreviousDueDate" Type="Edm.DateTimeOffset" /><Property Name="PreviousOverdueDate" Type="Edm.DateTimeOffset" /><Property Name="PreviousReadyForTerminationDate" Type="Edm.DateTimeOffset" /></EntityType><EntityType Name="FDSAssentRecordRevenue"><Key><PropertyRef Name="FDSAssentCollectionID" /><PropertyRef Name="FDSAssentRecordID" /></Key><Property Name="FDSAssentCollectionID" Type="Edm.Int64" Nullable="false" /><Property Name="FDSAssentRecordID" Type="Edm.Int64" Nullable="false" /><Property Name="PracticeID" Type="Edm.Int64" Nullable="false" /><Property Name="FDSAssentRecordPeriod" Type="Edm.Int64" Nullable="false" /><Property Name="XeppoCode" Type="Edm.Int64" Nullable="false" /><Property Name="ClientName" Type="Edm.String" /><Property Name="FeeCategoryID" Type="Edm.Int64" /><Property Name="Name" Type="Edm.String" /><Property Name="TotalFees" Type="Edm.Decimal" Scale="Variable" /><Property Name="TotalCommission" Type="Edm.Decimal" Scale="Variable" /><Property Name="TotalRevenue" Type="Edm.Decimal" Scale="Variable" /><Property Name="IsEstimate" Type="Edm.Boolean" /><Property Name="FDSClientEstimatedRevenueID" Type="Edm.Int64" /><Property Name="EstimateDescription" Type="Edm.String" /></EntityType><EntityType Name="FDSAssentRecordService"><Key><PropertyRef Name="FDSAssentCollectionID" /><PropertyRef Name="FDSAssentRecordID" /><PropertyRef Name="FDSAssentRecordServiceID" /></Key><Property Name="FDSAssentCollectionID" Type="Edm.Int64" Nullable="false" /><Property Name="FDSAssentRecordID" Type="Edm.Int64" Nullable="false" /><Property Name="FDSAssentRecordServiceID" Type="Edm.Int64" Nullable="false" /><Property Name="FDSAssentRecordPeriod" Type="Edm.Int64" Nullable="false" /><Property Name="PracticeID" Type="Edm.Int64" Nullable="false" /><Property Name="PrimaryClientXeppoCode" Type="Edm.Int64" Nullable="false" /><Property Name="PrimaryClientName" Type="Edm.String" /><Property Name="XeppoGroupCode" Type="Edm.Int64" Nullable="false" /><Property Name="FDSServiceID" Type="Edm.Int64" /><Property Name="ServiceName" Type="Edm.String" /><Property Name="ServiceDescription" Type="Edm.String" /><Property Name="HasBeenProvided" Type="Edm.Boolean" Nullable="false" /><Property Name="ServiceFrequencyID" Type="Edm.Int64" Nullable="false" /><Property Name="ServiceFrequencyName" Type="Edm.String" /><Property Name="NumberOfDocumentsFound" Type="Edm.Int32" /><Property Name="NumberOfActivitiesFound" Type="Edm.Int32" /><Property Name="ServiceSpecificClientXeppoCode" Type="Edm.Int64" /><Property Name="ServiceSpecificClientName" Type="Edm.String" /></EntityType><EntityType Name="FDSAssentRecordPaymentTerm"><Key><PropertyRef Name="FDSAssentCollectionID" /><PropertyRef Name="FDSAssentRecordID" /><PropertyRef Name="FDSAssentRecordPaymentTermID" /></Key><Property Name="FDSAssentCollectionID" Type="Edm.Int64" Nullable="false" /><Property Name="FDSAssentRecordID" Type="Edm.Int64" Nullable="false" /><Property Name="FDSAssentRecordPaymentTermID" Type="Edm.Int64" Nullable="false" /><Property Name="PracticeID" Type="Edm.Int64" Nullable="false" /><Property Name="FDSAssentRecordPeriod" Type="Edm.Int64" Nullable="false" /><Property Name="XeppoCode" Type="Edm.Int64" Nullable="false" /><Property Name="Fee" Type="Edm.Decimal" Nullable="false" Scale="Variable" /><Property Name="FDSTermFeeFrequencyId" Type="Edm.Int32" Nullable="false" /><Property Name="FDSTermFeeFrequencyName" Type="Edm.String" /><Property Name="FDSTermFeeFrequencyValue" Type="Edm.Int32" Nullable="false" /><Property Name="TotalFee" Type="Edm.Decimal" Nullable="false" Scale="Variable" /><Property Name="IsFeeAmountEstimated" Type="Edm.Boolean" Nullable="false" /></EntityType><EntityType Name="FDSAssentRecordPaymentTermProvider"><Key><PropertyRef Name="FDSAssentCollectionID" /><PropertyRef Name="FDSAssentRecordID" /><PropertyRef Name="FDSAssentRecordPaymentTermID" /><PropertyRef Name="FDSAssentRecordPaymentTermProviderID" /></Key><Property Name="FDSAssentCollectionID" Type="Edm.Int64" Nullable="false" /><Property Name="FDSAssentRecordID" Type="Edm.Int64" Nullable="false" /><Property Name="FDSAssentRecordPaymentTermID" Type="Edm.Int64" Nullable="false" /><Property Name="FDSAssentRecordPaymentTermProviderID" Type="Edm.Int64" Nullable="false" /><Property Name="PracticeID" Type="Edm.Int64" Nullable="false" /><Property Name="FDSAssentRecordPeriod" Type="Edm.Int64" Nullable="false" /><Property Name="StartDate" Type="Edm.DateTimeOffset" /><Property Name="FDSAccountTypeID" Type="Edm.Int32" Nullable="false" /><Property Name="FDSAccountTypeName" Type="Edm.String" /><Property Name="FDSProviderID" Type="Edm.Int64" /><Property Name="FDSProviderName" Type="Edm.String" /><Property Name="ProductName" Type="Edm.String" /><Property Name="AccountNumber" Type="Edm.String" /><Property Name="AdvisorOrSupplierCode" Type="Edm.String" /><Property Name="FeeAmount" Type="Edm.Decimal" Nullable="false" Scale="Variable" /><Property Name="FeeCalculationDescription" Type="Edm.String" /><Property Name="LossOfBenefitsInformation" Type="Edm.String" /><Property Name="FDSTermProviderStatusId" Type="Edm.Int32" Nullable="false" /><Property Name="FDSTermProviderStatusName" Type="Edm.String" /></EntityType><EntityType Name="FDSAssentRecordPaymentTermProviderSignatory"><Key><PropertyRef Name="FDSAssentCollectionID" /><PropertyRef Name="FDSAssentRecordID" /><PropertyRef Name="FDSAssentRecordPaymentTermID" /><PropertyRef Name="FDSAssentRecordPaymentTermProviderID" /><PropertyRef Name="FDSAssentRecordPaymentTermProviderSignatoryID" /></Key><Property Name="FDSAssentCollectionID" Type="Edm.Int64" Nullable="false" /><Property Name="FDSAssentRecordID" Type="Edm.Int64" Nullable="false" /><Property Name="FDSAssentRecordPaymentTermID" Type="Edm.Int64" Nullable="false" /><Property Name="FDSAssentRecordPaymentTermProviderID" Type="Edm.Int64" Nullable="false" /><Property Name="FDSAssentRecordPaymentTermProviderSignatoryID" Type="Edm.Int64" Nullable="false" /><Property Name="PracticeID" Type="Edm.Int64" Nullable="false" /><Property Name="FDSAssentRecordPeriod" Type="Edm.Int64" Nullable="false" /><Property Name="XeppoCode" Type="Edm.Int64" Nullable="false" /><Property Name="Name" Type="Edm.String" /><Property Name="Email" Type="Edm.String" /><Property Name="Address" Type="Edm.String" /></EntityType><EntityType Name="vwFDSAssentRecordServiceFact"><Key><PropertyRef Name="FDSAssentRecordServiceID" /></Key><Property Name="FDSAssentRecordServiceID" Type="Edm.Int64" Nullable="false" /><Property Name="FDSAssentRecordID" Type="Edm.Int64" Nullable="false" /><Property Name="FDSAssentRecordPeriod" Type="Edm.Int64" Nullable="false" /><Property Name="FDSAssentCollectionID" Type="Edm.Int64" Nullable="false" /><Property Name="PracticeID" Type="Edm.Int64" Nullable="false" /><Property Name="PrimaryClientXeppoCode" Type="Edm.Int64" Nullable="false" /><Property Name="PrimaryClientName" Type="Edm.String" /><Property Name="XeppoGroupCode" Type="Edm.Int64" Nullable="false" /><Property Name="FDSServiceID" Type="Edm.Int64" /><Property Name="ServiceName" Type="Edm.String" /><Property Name="ServiceDescription" Type="Edm.String" /><Property Name="HasBeenProvided" Type="Edm.Boolean" Nullable="false" /><Property Name="ServiceFrequencyID" Type="Edm.Int64" Nullable="false" /><Property Name="ServiceFrequencyName" Type="Edm.String" /><Property Name="NumberOfDocumentsFound" Type="Edm.Int32" /><Property Name="NumberOfActivitiesFound" Type="Edm.Int32" /><Property Name="ServiceSpecificClientXeppoCode" Type="Edm.Int64" /><Property Name="ServiceSpecificClientName" Type="Edm.String" /></EntityType><EntityType Name="vwAfslAdviserProfile"><Key><PropertyRef Name="AfslAdviserProfileId" /></Key><Property Name="AfslAdviserProfileId" Type="Edm.Int32" Nullable="false" /><Property Name="PracticeID" Type="Edm.Int64" Nullable="false" /><Property Name="XeppoCode" Type="Edm.Int64" Nullable="false" /><Property Name="VersionLookupFieldId" Type="Edm.Int16" Nullable="false" /><Property Name="Version" Type="Edm.String" /><Property Name="Date" Type="Edm.DateTimeOffset" /><Property Name="Notes" Type="Edm.String" /></EntityType><EntityType Name="vwAfslAudit"><Key><PropertyRef Name="AfslAuditId" /></Key><Property Name="AfslAuditId" Type="Edm.Int32" Nullable="false" /><Property Name="PracticeID" Type="Edm.Int64" Nullable="false" /><Property Name="XeppoCode" Type="Edm.Int64" Nullable="false" /><Property Name="CategoryLookupFieldId" Type="Edm.Int16" Nullable="false" /><Property Name="Category" Type="Edm.String" /><Property Name="Date" Type="Edm.DateTimeOffset" Nullable="false" /><Property Name="TypeLookupFieldId" Type="Edm.Int16" Nullable="false" /><Property Name="Type" Type="Edm.String" /><Property Name="NameLookupFieldId" Type="Edm.Int16" Nullable="false" /><Property Name="AuditorName" Type="Edm.String" /><Property Name="OutcomeLookupFieldId" Type="Edm.Int16" Nullable="false" /><Property Name="AuditOutcome" Type="Edm.String" /><Property Name="AuditNotes" Type="Edm.String" /></EntityType><EntityType Name="vwAfslAuthorisedRepresentativeTax"><Key><PropertyRef Name="AfslAuthorisedRepresentativeTaxId" /></Key><Property Name="AfslAuthorisedRepresentativeTaxId" Type="Edm.Int32" Nullable="false" /><Property Name="PracticeID" Type="Edm.Int64" Nullable="false" /><Property Name="XeppoCode" Type="Edm.Int64" Nullable="false" /><Property Name="TypeLookupFieldId" Type="Edm.Int16" Nullable="false" /><Property Name="Type" Type="Edm.String" /><Property Name="RegistrationDate" Type="Edm.DateTimeOffset" /><Property Name="ExpiryDate" Type="Edm.DateTimeOffset" /><Property Name="Notes" Type="Edm.String" /><Property Name="TPBNumber" Type="Edm.Int32" /></EntityType><EntityType Name="vwAfslClient"><Key><PropertyRef Name="XeppoCode" /></Key><Property Name="XeppoCode" Type="Edm.Int64" Nullable="false" /><Property Name="PracticeID" Type="Edm.Int64" Nullable="false" /><Property Name="Name" Type="Edm.String" /><Property Name="LicenseeNameLookupFieldId" Type="Edm.Int16" Nullable="false" /><Property Name="LicenseeName" Type="Edm.String" /><Property Name="AfslLookupFieldId" Type="Edm.Int16" Nullable="false" /><Property Name="Afsl" Type="Edm.String" /><Property Name="Website" Type="Edm.String" /><Property Name="TypeLookupFieldId" Type="Edm.Int16" /><Property Name="Type" Type="Edm.String" /><Property Name="CorporateAuthorisedRepresentativeNumber" Type="Edm.Int32" /><Property Name="AuthorisedRepresentativeNumber" Type="Edm.Int32" /><Property Name="AgreementDate" Type="Edm.DateTimeOffset" /><Property Name="TerminationDate" Type="Edm.DateTimeOffset" /><Property Name="AuthorisationDate" Type="Edm.DateTimeOffset" /><Property Name="FeeArrangement" Type="Edm.String" /><Property Name="PrimaryCoachLookupFieldId" Type="Edm.Int16" /><Property Name="PrimaryCoach" Type="Edm.String" /><Property Name="LicenseeSplit" Type="Edm.Decimal" Scale="Variable" /><Property Name="BusinessSplit" Type="Edm.Decimal" Scale="Variable" /><Property Name="AdviserSplit" Type="Edm.Decimal" Scale="Variable" /><Property Name="Designations" Type="Edm.String" /><Property Name="ExamDateNotified" Type="Edm.DateTimeOffset" /><Property Name="ExamDateSat" Type="Edm.DateTimeOffset" /><Property Name="ExamDateComplete" Type="Edm.DateTimeOffset" /><Property Name="IsTrainingComplete" Type="Edm.Boolean" /><Property Name="CurrentTraningDetails" Type="Edm.String" /></EntityType><EntityType Name="vwAfslComplaint"><Key><PropertyRef Name="AfslComplaintId" /></Key><Property Name="AfslComplaintId" Type="Edm.Int32" Nullable="false" /><Property Name="PracticeID" Type="Edm.Int64" Nullable="false" /><Property Name="XeppoCode" Type="Edm.Int64" Nullable="false" /><Property Name="TypeLookupFieldId" Type="Edm.Int16" Nullable="false" /><Property Name="Type" Type="Edm.String" /><Property Name="DateReceived" Type="Edm.DateTimeOffset" Nullable="false" /><Property Name="DateResponded" Type="Edm.DateTimeOffset" /><Property Name="SeverityLookupFieldId" Type="Edm.Int16" Nullable="false" /><Property Name="Severity" Type="Edm.String" /><Property Name="Summary" Type="Edm.String" /><Property Name="Owner" Type="Edm.String" /><Property Name="OwnerName" Type="Edm.String" /><Property Name="DateClosed" Type="Edm.DateTimeOffset" /><Property Name="ComplainantName" Type="Edm.String" /><Property Name="ComplainantEmail" Type="Edm.String" /><Property Name="ComplainantPhone" Type="Edm.String" /><Property Name="ClaimAmount" Type="Edm.Decimal" Scale="Variable" /><Property Name="IdrEdrLookupFieldId" Type="Edm.Int16" /><Property Name="IdrEdr" Type="Edm.String" /><Property Name="ReferenceNumber" Type="Edm.String" /><Property Name="DateAcknowledged" Type="Edm.DateTimeOffset" /><Property Name="DueDateForResponse" Type="Edm.DateTimeOffset" Nullable="false" /><Property Name="DateResponseSent" Type="Edm.DateTimeOffset" /><Property Name="ResponseSummary" Type="Edm.String" /><Property Name="DateEDRSchemeNotified" Type="Edm.DateTimeOffset" /><Property Name="StatusLookupFieldId" Type="Edm.Int16" Nullable="false" /><Property Name="Status" Type="Edm.String" /></EntityType><EntityType Name="vwAfslFinancialServicesGuide"><Key><PropertyRef Name="AfslFinancialServicesGuideId" /></Key><Property Name="AfslFinancialServicesGuideId" Type="Edm.Int32" Nullable="false" /><Property Name="PracticeID" Type="Edm.Int64" Nullable="false" /><Property Name="XeppoCode" Type="Edm.Int64" Nullable="false" /><Property Name="VersionLookupFieldId" Type="Edm.Int16" Nullable="false" /><Property Name="Version" Type="Edm.String" /><Property Name="Date" Type="Edm.DateTimeOffset" /><Property Name="Notes" Type="Edm.String" /></EntityType><EntityType Name="vwAfslMembership"><Key><PropertyRef Name="AfslMembershipId" /></Key><Property Name="AfslMembershipId" Type="Edm.Int32" Nullable="false" /><Property Name="PracticeID" Type="Edm.Int64" Nullable="false" /><Property Name="XeppoCode" Type="Edm.Int64" Nullable="false" /><Property Name="TypeLookupFieldId" Type="Edm.Int16" /><Property Name="Type" Type="Edm.String" /><Property Name="Name" Type="Edm.String" /><Property Name="Number" Type="Edm.String" /><Property Name="StartDate" Type="Edm.DateTimeOffset" /><Property Name="EndDate" Type="Edm.DateTimeOffset" /><Property Name="Notes" Type="Edm.String" /></EntityType><EntityType Name="vwAfslRestriction"><Key><PropertyRef Name="AfslRestrictionId" /></Key><Property Name="AfslRestrictionId" Type="Edm.Int32" Nullable="false" /><Property Name="PracticeID" Type="Edm.Int64" Nullable="false" /><Property Name="XeppoCode" Type="Edm.Int64" Nullable="false" /><Property Name="TypeLookupFieldId" Type="Edm.Int16" Nullable="false" /><Property Name="Type" Type="Edm.String" /><Property Name="Description" Type="Edm.String" /><Property Name="StartDate" Type="Edm.DateTimeOffset" /><Property Name="EndDate" Type="Edm.DateTimeOffset" /><Property Name="Notes" Type="Edm.String" /></EntityType><EntityType Name="vwAfslProfessionalDevelopment"><Key><PropertyRef Name="AfslProfessionalDevelopmentId" /></Key><Property Name="AfslProfessionalDevelopmentId" Type="Edm.Int32" Nullable="false" /><Property Name="PracticeID" Type="Edm.Int64" Nullable="false" /><Property Name="XeppoCode" Type="Edm.Int64" Nullable="false" /><Property Name="Name" Type="Edm.String" /><Property Name="Points" Type="Edm.Decimal" Nullable="false" Scale="Variable" /><Property Name="DateAcquired" Type="Edm.DateTimeOffset" /><Property Name="Notes" Type="Edm.String" /></EntityType><EntityType Name="vwAfslQualification"><Key><PropertyRef Name="AfslQualificationId" /></Key><Property Name="AfslQualificationId" Type="Edm.Int32" Nullable="false" /><Property Name="PracticeID" Type="Edm.Int64" Nullable="false" /><Property Name="XeppoCode" Type="Edm.Int64" Nullable="false" /><Property Name="Type" Type="Edm.String" /><Property Name="Provider" Type="Edm.String" /><Property Name="DateCompleted" Type="Edm.DateTimeOffset" /><Property Name="IsFaseaRequirement" Type="Edm.Boolean" Nullable="false" /><Property Name="Reference" Type="Edm.String" /></EntityType><EntityType Name="vwAfslIncidentBreach"><Key><PropertyRef Name="AfslIncidentBreachId" /></Key><Property Name="AfslIncidentBreachId" Type="Edm.Int32" Nullable="false" /><Property Name="PracticeID" Type="Edm.Int64" Nullable="false" /><Property Name="XeppoCode" Type="Edm.Int64" Nullable="false" /><Property Name="Subject" Type="Edm.String" /><Property Name="Summary" Type="Edm.String" /><Property Name="DateOccurred" Type="Edm.DateTimeOffset" Nullable="false" /><Property Name="DateIdentified" Type="Edm.DateTimeOffset" Nullable="false" /><Property Name="IncidentOrBreachId" Type="Edm.Int16" Nullable="false" /><Property Name="IncidentOrBreach" Type="Edm.String" /><Property Name="TypeLookupFieldId" Type="Edm.Int16" Nullable="false" /><Property Name="Type" Type="Edm.String" /><Property Name="HowWasIncidentIdentifiedLookupFieldId" Type="Edm.Int16" Nullable="false" /><Property Name="HowWasIncidentIdentified" Type="Edm.String" /><Property Name="IdentifiedBy" Type="Edm.String" /><Property Name="IdentifiedByName" Type="Edm.String" /><Property Name="Linked_Audit_Record_ID" Type="Edm.Int32" /><Property Name="Linked_Audit_Record" Type="Edm.String" /><Property Name="DateReferredCommittee" Type="Edm.DateTimeOffset" /><Property Name="DateReviewedCommittee" Type="Edm.DateTimeOffset" /><Property Name="Assessment" Type="Edm.String" /><Property Name="IsSignificant" Type="Edm.Boolean" Nullable="false" /><Property Name="SignificanceReason" Type="Edm.String" /><Property Name="DateNotifiedBoard" Type="Edm.DateTimeOffset" /><Property Name="DateNotifiedASIC" Type="Edm.DateTimeOffset" /><Property Name="ProposedRectification" Type="Edm.String" /><Property Name="FuturePreventativeMeasures" Type="Edm.String" /><Property Name="Remediation" Type="Edm.String" /><Property Name="RemediationOwner" Type="Edm.String" /><Property Name="RemediationOwnerName" Type="Edm.String" /><Property Name="DateClosed" Type="Edm.DateTimeOffset" /></EntityType><EntityType Name="vwDocument"><Key><PropertyRef Name="DocumentID" /><PropertyRef Name="LinkID" /></Key><Property Name="DocumentID" Type="Edm.Int64" Nullable="false" /><Property Name="LinkID" Type="Edm.String" Nullable="false" /><Property Name="PracticeID" Type="Edm.Int64" Nullable="false" /><Property Name="URL" Type="Edm.String" /><Property Name="DocumentDataID" Type="Edm.Guid" /><Property Name="RelatedEntityType" Type="Edm.String" /><Property Name="RelatedEntityTypeID" Type="Edm.Int64" /><Property Name="RelatedEntityID" Type="Edm.Int64" /><Property Name="XeppoCode" Type="Edm.Int64" /><Property Name="XeppoGroupCode" Type="Edm.Int64" /><Property Name="ContentType" Type="Edm.String" /><Property Name="DocumentCategory" Type="Edm.String" /><Property Name="DocumentCategoryID" Type="Edm.Int64" Nullable="false" /><Property Name="Description" Type="Edm.String" /><Property Name="DocumentName" Type="Edm.String" /><Property Name="DocumentFileDatetime" Type="Edm.DateTimeOffset" /><Property Name="CreatedDateUTC" Type="Edm.DateTimeOffset" /><Property Name="ModifiedDateUTC" Type="Edm.DateTimeOffset" /><Property Name="CreatedByUserID" Type="Edm.String" /><Property Name="ModifiedByUserID" Type="Edm.String" /><Property Name="EntityName" Type="Edm.String" /><Property Name="VisibleToClientRole" Type="Edm.Boolean" /><Property Name="CreatedBy" Type="Edm.String" /><Property Name="ModifiedBy" Type="Edm.String" /><Property Name="SizeInMB" Type="Edm.Decimal" Scale="Variable" /><Property Name="SizeInKB" Type="Edm.Int64" /><Property Name="SizeInB" Type="Edm.Int64" /><Property Name="FileType" Type="Edm.String" /><Property Name="DocumentIcon" Type="Edm.String" /><Property Name="DocumentType" Type="Edm.String" /><Property Name="WebUrl" Type="Edm.String" /><Property Name="SharePointPath" Type="Edm.String" /><Property Name="SharePointDocumentID" Type="Edm.String" /><Property Name="IsSharePoint" Type="Edm.Boolean" /></EntityType><EntityType Name="vwChangeRequest"><Key><PropertyRef Name="ChangeRequestID" /></Key><Property Name="ChangeRequestID" Type="Edm.Int64" Nullable="false" /><Property Name="PracticeID" Type="Edm.Int64" Nullable="false" /><Property Name="Code" Type="Edm.Int64" Nullable="false" /><Property Name="CodeType" Type="Edm.String" /><Property Name="ChangeRequestCategoryID" Type="Edm.Int64" Nullable="false" /><Property Name="ChangeCategory" Type="Edm.String" /><Property Name="ChangeDetail" Type="Edm.String" /><Property Name="SubmittedUserID" Type="Edm.String" /><Property Name="SubmittedDate" Type="Edm.DateTimeOffset" Nullable="false" /><Property Name="StatusID" Type="Edm.Byte" /><Property Name="Status" Type="Edm.String" /><Property Name="DaysOpen" Type="Edm.Int32" /><Property Name="SubmittedUserName" Type="Edm.String" /><Property Name="CodeName" Type="Edm.String" /><Property Name="ConnectorID" Type="Edm.Int64" /><Property Name="ConnectorName" Type="Edm.String" /><Property Name="IsPushBack" Type="Edm.Boolean" /><Property Name="ClientID" Type="Edm.String" /></EntityType><EntityType Name="vwChangeRequestPushBack"><Key><PropertyRef Name="ChangeRequestID" /></Key><Property Name="ChangeRequestID" Type="Edm.Int64" Nullable="false" /><Property Name="PracticeID" Type="Edm.Int64" Nullable="false" /><Property Name="ConnectorID" Type="Edm.Int64" /><Property Name="ConnectorName" Type="Edm.String" /><Property Name="XeppoCode" Type="Edm.Int64" Nullable="false" /><Property Name="ClientName" Type="Edm.String" /><Property Name="ChangeRequestCategoryID" Type="Edm.Int64" Nullable="false" /><Property Name="ChangeRequestCategory" Type="Edm.String" /><Property Name="SourceClient" Type="Edm.String" /><Property Name="UpdatedFields" Type="Edm.String" /><Property Name="ConnectorMasterID" Type="Edm.Int32" /></EntityType><EntityType Name="vwDataPushHistory"><Key><PropertyRef Name="DataPushHistoryID" /></Key><Property Name="DataPushHistoryID" Type="Edm.Int64" Nullable="false" /><Property Name="PracticeID" Type="Edm.Int64" Nullable="false" /><Property Name="XeppoCode" Type="Edm.Int64" Nullable="false" /><Property Name="CreatedDateUTC" Type="Edm.DateTimeOffset" Nullable="false" /><Property Name="ProcessedDateUTC" Type="Edm.DateTimeOffset" /><Property Name="Field" Type="Edm.String" /><Property Name="OldValue" Type="Edm.String" /><Property Name="NewValue" Type="Edm.String" /><Property Name="User" Type="Edm.String" /><Property Name="DataPushFieldChangeID" Type="Edm.Int64" Nullable="false" /></EntityType><EntityType Name="vwXeppoTask"><Key><PropertyRef Name="TaskID" /></Key><Property Name="TaskID" Type="Edm.Int64" Nullable="false" /><Property Name="PracticeID" Type="Edm.Int64" Nullable="false" /><Property Name="UserID" Type="Edm.String" /><Property Name="UserName" Type="Edm.String" /><Property Name="Completed" Type="Edm.Boolean" Nullable="false" /><Property Name="DateCreatedUTC" Type="Edm.DateTimeOffset" Nullable="false" /><Property Name="Entity" Type="Edm.String" /><Property Name="EntityID" Type="Edm.Int64" /><Property Name="ConnectorID" Type="Edm.Int64" /><Property Name="ConnectorName" Type="Edm.String" /><Property Name="MinutesOpen" Type="Edm.Int32" /></EntityType><EntityType Name="vwActivityCategory"><Key><PropertyRef Name="ActivityCategoryID" /></Key><Property Name="ActivityCategoryID" Type="Edm.Int64" Nullable="false" /><Property Name="PracticeID" Type="Edm.Int64" Nullable="false" /><Property Name="ActivityCategoryName" Type="Edm.String" /><Property Name="SourceID" Type="Edm.String" /><Property Name="SourceConnectorID" Type="Edm.Int64" /><Property Name="SyncID" Type="Edm.String" /><Property Name="LastUpdated" Type="Edm.DateTimeOffset" /></EntityType><EntityType Name="vwActivitySubcategory"><Key><PropertyRef Name="ActivitySubcategoryID" /></Key><Property Name="ActivitySubcategoryID" Type="Edm.Int64" Nullable="false" /><Property Name="PracticeID" Type="Edm.Int64" Nullable="false" /><Property Name="ActivitySubcategoryName" Type="Edm.String" /><Property Name="SourceID" Type="Edm.String" /><Property Name="SourceConnectorID" Type="Edm.Int64" /><Property Name="ParentSourceID" Type="Edm.String" /><Property Name="ParentActivityCategoryID" Type="Edm.Int64" /><Property Name="SyncID" Type="Edm.String" /><Property Name="LastUpdated" Type="Edm.DateTimeOffset" /></EntityType><EntityType Name="vwAudit"><Key><PropertyRef Name="AuditID" /></Key><Property Name="AuditID" Type="Edm.Int64" Nullable="false" /><Property Name="UserName" Type="Edm.String" /><Property Name="IPAddress" Type="Edm.String" /><Property Name="Action" Type="Edm.String" /><Property Name="Timestamp" Type="Edm.DateTimeOffset" Nullable="false" /><Property Name="HttpMethod" Type="Edm.String" /><Property Name="UserID" Type="Edm.String" /><Property Name="PracticeID" Type="Edm.Int64" Nullable="false" /><Property Name="ImpersonatingUserID" Type="Edm.String" /></EntityType><EntityType Name="vwUserRolePractice"><Key><PropertyRef Name="UserID" /><PropertyRef Name="RoleID" /></Key><Property Name="UserID" Type="Edm.String" Nullable="false" /><Property Name="RoleID" Type="Edm.String" Nullable="false" /><Property Name="UserName" Type="Edm.String" /><Property Name="FirstName" Type="Edm.String" /><Property Name="LastName" Type="Edm.String" /><Property Name="FullName" Type="Edm.String" /><Property Name="RoleName" Type="Edm.String" /><Property Name="PracticeName" Type="Edm.String" /><Property Name="PracticeID" Type="Edm.Int64" Nullable="false" /><Property Name="SubDomain" Type="Edm.String" /><Property Name="Last_Login" Type="Edm.DateTimeOffset" /><Property Name="Enabled" Type="Edm.Boolean" Nullable="false" /><Property Name="ThemeColour" Type="Edm.String" /><Property Name="ThemeTextColour" Type="Edm.String" /><Property Name="TeamNames" Type="Edm.String" /><Property Name="LicenseTypeID" Type="Edm.Int16" Nullable="false" /></EntityType><EntityType Name="vwUserTeam"><Key><PropertyRef Name="UserID" /></Key><Property Name="UserID" Type="Edm.String" Nullable="false" /><Property Name="TeamID" Type="Edm.Int64" /><Property Name="PracticeID" Type="Edm.Int64" /><Property Name="UserName" Type="Edm.String" /><Property Name="FullName" Type="Edm.String" /><Property Name="TeamName" Type="Edm.String" /></EntityType><EntityType Name="vwTeam"><Key><PropertyRef Name="TeamID" /></Key><Property Name="TeamID" Type="Edm.Int64" Nullable="false" /><Property Name="PracticeID" Type="Edm.Int64" Nullable="false" /><Property Name="TeamName" Type="Edm.String" /><Property Name="Created" Type="Edm.DateTimeOffset" Nullable="false" /><Property Name="CreatedBy" Type="Edm.String" /><Property Name="Modified" Type="Edm.DateTimeOffset" /><Property Name="ModifiedBy" Type="Edm.String" /><Property Name="UserCount" Type="Edm.Int32" /></EntityType><EntityType Name="vwEmployment"><Key><PropertyRef Name="XeppoEmploymentID" /></Key><Property Name="XeppoEmploymentID" Type="Edm.Int64" Nullable="false" /><Property Name="EmploymentID" Type="Edm.Int32" /><Property Name="XeppoCode" Type="Edm.Int64" Nullable="false" /><Property Name="PracticeID" Type="Edm.Int64" Nullable="false" /><Property Name="XeppoGroupCode" Type="Edm.Int64" /><Property Name="ClientName" Type="Edm.String" /><Property Name="ConnectorName" Type="Edm.String" /><Property Name="Occupation" Type="Edm.String" /><Property Name="Industry" Type="Edm.String" /><Property Name="EmploymentPosition" Type="Edm.String" /><Property Name="EmploymentDuties" Type="Edm.String" /><Property Name="EmploymentStatusID" Type="Edm.Int32" /><Property Name="EmploymentStatus" Type="Edm.String" /><Property Name="EmployerName" Type="Edm.String" /><Property Name="HoursWorkedPerWeek" Type="Edm.Decimal" Scale="Variable" /><Property Name="StartDateWithEmployer" Type="Edm.DateTimeOffset" /><Property Name="BusinessStructure" Type="Edm.String" /><Property Name="BusinessStructureID" Type="Edm.Int32" /><Property Name="AdditionalInformation" Type="Edm.String" /><Property Name="EndDateWithEmployer" Type="Edm.DateTimeOffset" /><Property Name="YearsInCurrentOccupation" Type="Edm.Decimal" Scale="Variable" /><Property Name="IsLikelyChangeInStatus" Type="Edm.Boolean" /><Property Name="IsAbleToSalaryPackage" Type="Edm.Boolean" /><Property Name="AnnualLeave" Type="Edm.Decimal" Scale="Variable" /><Property Name="LongServiceLeave" Type="Edm.Decimal" Scale="Variable" /><Property Name="SickLeave" Type="Edm.Decimal" Scale="Variable" /><Property Name="IsMainOccupation" Type="Edm.Boolean" /><Property Name="LastUpdated" Type="Edm.DateTimeOffset" /></EntityType><EntityType Name="vwClientEstatePlanning"><Key><PropertyRef Name="XeppoCode" /></Key><Property Name="XeppoCode" Type="Edm.Int64" Nullable="false" /><Property Name="PracticeID" Type="Edm.Int64" Nullable="false" /><Property Name="XeppoGroupCode" Type="Edm.Int64" /><Property Name="HasExistingWill" Type="Edm.Boolean" /><Property Name="DateOfExistingWill" Type="Edm.DateTimeOffset" /><Property Name="DateWillLastReviewed" Type="Edm.DateTimeOffset" /><Property Name="LocationOfWill" Type="Edm.String" /><Property Name="IsProvidedForTestamentaryTrust" Type="Edm.Boolean" /><Property Name="AppointedGuardianName" Type="Edm.String" /><Property Name="HasFuneralPlan" Type="Edm.Boolean" /><Property Name="StateDocumentsPrepared" Type="Edm.String" /><Property Name="PreviousRelationshipsDescription" Type="Edm.String" /><Property Name="LastUpdated" Type="Edm.DateTimeOffset" /></EntityType><EntityType Name="vwClientEstatePlanningNominatedPerson"><Key><PropertyRef Name="SourceConnectorID" /><PropertyRef Name="NominatedPersonID" /></Key><Property Name="SourceConnectorID" Type="Edm.Int64" Nullable="false" /><Property Name="NominatedPersonID" Type="Edm.String" Nullable="false" /><Property Name="NominatedTypeID" Type="Edm.Int32" Nullable="false" /><Property Name="PracticeID" Type="Edm.Int64" Nullable="false" /><Property Name="ClientEstatePlanningID" Type="Edm.String" /><Property Name="NominatedPersonXeppoCode" Type="Edm.Int64" /><Property Name="XeppoCode" Type="Edm.Int64" /><Property Name="FirstName" Type="Edm.String" /><Property Name="LastName" Type="Edm.String" /><Property Name="PreferredName" Type="Edm.String" /><Property Name="AgeOfEntitlement" Type="Edm.Int32" /><Property Name="PowerOfAttorneyTypeID" Type="Edm.Int32" /><Property Name="PowerOfAttorneyType" Type="Edm.String" /><Property Name="Notes" Type="Edm.String" /></EntityType><EntityType Name="vwClientAgedCare"><Key><PropertyRef Name="XeppoCode" /></Key><Property Name="XeppoCode" Type="Edm.Int64" Nullable="false" /><Property Name="PracticeID" Type="Edm.Int64" Nullable="false" /><Property Name="AgedCareTypeID" Type="Edm.Int32" /><Property Name="AgedCareType" Type="Edm.String" /><Property Name="IsHomeOwner" Type="Edm.Boolean" /><Property Name="CurrentValueOfHome" Type="Edm.Decimal" Scale="Variable" /><Property Name="AssessedAnnualIncome" Type="Edm.Decimal" Scale="Variable" /><Property Name="AssessedFinancialAssets" Type="Edm.Decimal" Scale="Variable" /><Property Name="AssessedSuperannuationAndOtherAssets" Type="Edm.Decimal" Scale="Variable" /><Property Name="AssessedTotalDebts" Type="Edm.Decimal" Scale="Variable" /><Property Name="IsLivingWithPartner" Type="Edm.Boolean" /><Property Name="HomeCarePackageReceivedID" Type="Edm.Int32" /><Property Name="HomeCarePackageReceived" Type="Edm.String" /><Property Name="DateOfEntryToAgedCare" Type="Edm.DateTimeOffset" /><Property Name="MaximumPermissibleInterestRateSetAtEntry" Type="Edm.Decimal" Scale="Variable" /><Property Name="AgedCareAssessmentTypeID" Type="Edm.Int32" /><Property Name="AgedCareAssessmentType" Type="Edm.String" /><Property Name="IsProtectedPersonLivingInHome" Type="Edm.Boolean" /><Property Name="AccommodationLumpSumPaymentRequired" Type="Edm.Decimal" Scale="Variable" /><Property Name="AccommodationLumpSumPaymentPaid" Type="Edm.Decimal" Scale="Variable" /><Property Name="AccommodationDailyFeeAmount" Type="Edm.Decimal" Scale="Variable" /><Property Name="AccommodationDailyFeeFrequencyID" Type="Edm.Int32" /><Property Name="AccommodationDailyFeeFrequency" Type="Edm.String" /><Property Name="IncomeTestedCareFeeAmount" Type="Edm.Decimal" Scale="Variable" /><Property Name="IncomeTestedCareFeeFrequencyID" Type="Edm.Int32" /><Property Name="IncomeTestedCareFeeFrequency" Type="Edm.String" /><Property Name="AnnualIncomeTestedFeeAmount" Type="Edm.Decimal" Scale="Variable" /><Property Name="LifetimeIncomeTestedFeeAmount" Type="Edm.Decimal" Scale="Variable" /><Property Name="BasicDailyFeeAmount" Type="Edm.Decimal" Scale="Variable" /><Property Name="BasicDailyFeeAmountFrequencyID" Type="Edm.Int32" /><Property Name="BasicDailyFeeAmountFrequency" Type="Edm.String" /><Property Name="MeansTestedFee" Type="Edm.Decimal" Scale="Variable" /><Property Name="MeansTestedFeeFrequencyID" Type="Edm.Int32" /><Property Name="AnnualMeansTestedFeeAmount" Type="Edm.Decimal" Scale="Variable" /><Property Name="LifetimeMeansTestedFeeAmount" Type="Edm.Decimal" Scale="Variable" /><Property Name="AdditionalServicesFee" Type="Edm.Decimal" Scale="Variable" /><Property Name="AdditionalServicesFeeFrequencyID" Type="Edm.Int32" /><Property Name="AdditionalServicesFeeFrequency" Type="Edm.String" /><Property Name="TotalFees" Type="Edm.Decimal" Scale="Variable" /><Property Name="TotalFeeFrequencyID" Type="Edm.Int32" /><Property Name="IsAgedCareAuthority" Type="Edm.Boolean" /><Property Name="XeppoGroupCode" Type="Edm.Int64" /></EntityType><EntityType Name="vwClientAgedCareAccommodationPaymentType"><Key><PropertyRef Name="XeppoCode" /><PropertyRef Name="AgedCareAccommodationPaymentTypeID" /></Key><Property Name="XeppoCode" Type="Edm.Int64" Nullable="false" /><Property Name="AgedCareAccommodationPaymentTypeID" Type="Edm.Int32" Nullable="false" /><Property Name="PracticeID" Type="Edm.Int64" Nullable="false" /><Property Name="AccomodationPaymentType" Type="Edm.String" /></EntityType><ComplexType Name="FDSEvidenceValue"><Property Name="FDSServiceID" Type="Edm.Int64" Nullable="false" /><Property Name="PracticeID" Type="Edm.Int64" Nullable="false" /><Property Name="FDSEvidenceTypeID" Type="Edm.Int64" Nullable="false" /><Property Name="EvidenceValue" Type="Edm.String" /><Property Name="CreatedBy" Type="Edm.String" /><Property Name="CreatedDateUTC" Type="Edm.DateTimeOffset" Nullable="false" /><Property Name="ModifiedBy" Type="Edm.String" /><Property Name="ModifiedDateUTC" Type="Edm.DateTimeOffset" /></ComplexType><EntityType Name="FDSAssentAdviserType"><Key><PropertyRef Name="FDSAssentAdviserTypeID" /></Key><Property Name="FDSAssentAdviserTypeID" Type="Edm.Int32" Nullable="false" /><Property Name="Name" Type="Edm.String" /><Property Name="Description" Type="Edm.String" /><Property Name="SortOrder" Type="Edm.Int32" /></EntityType></Schema><Schema Namespace="Default" xmlns="http://docs.oasis-open.org/odata/ns/edm"><EntityContainer Name="Container"><EntitySet Name="Accounts" EntityType="Opex.Xeppo.Server.Entity.Account" /><EntitySet Name="Addresses" EntityType="Opex.Xeppo.Server.Entity.Address" /><EntitySet Name="AgedDebtors" EntityType="Opex.Xeppo.Server.Entity.AgedDebtor" /><EntitySet Name="Assets" EntityType="Opex.Xeppo.Server.Entity.Asset" /><EntitySet Name="BalanceComponents" EntityType="Opex.Xeppo.Server.Entity.BalanceComponent" /><EntitySet Name="Clients" EntityType="Opex.Xeppo.Server.Entity.Client" /><EntitySet Name="ClientCompliances" EntityType="Opex.Xeppo.Server.Entity.ClientCompliance" /><EntitySet Name="ClientServiceHistories" EntityType="Opex.Xeppo.Server.Entity.ClientServiceHistory" /><EntitySet Name="ClientInvoices" EntityType="Opex.Xeppo.Server.Entity.ClientInvoice" /><EntitySet Name="ClientRankings" EntityType="Opex.Xeppo.Server.Entity.vwClientRanking" /><EntitySet Name="ClientHealths" EntityType="Opex.Xeppo.Server.Entity.vwClientHealth" /><EntitySet Name="ClientSocialSecurities" EntityType="Opex.Xeppo.Server.Entity.vwClientSocialSecurity" /><EntitySet Name="ClientSocialSecurityPaymentTypesReceived" EntityType="Opex.Xeppo.Server.Entity.vwClientSocialSecurityPaymentTypesReceived" /><EntitySet Name="Commissions" EntityType="Opex.Xeppo.Server.Entity.Commission" /><EntitySet Name="ContactDetails" EntityType="Opex.Xeppo.Server.Entity.ContactDetail" /><EntitySet Name="ContributionLimits" EntityType="Opex.Xeppo.Server.Entity.ContributionLimit" /><EntitySet Name="Connectors" EntityType="Opex.Xeppo.Server.Entity.Connector" /><EntitySet Name="Dependants" EntityType="Opex.Xeppo.Server.Entity.Dependant" /><EntitySet Name="Expenses" EntityType="Opex.Xeppo.Server.Entity.Expense" /><EntitySet Name="Fees" EntityType="Opex.Xeppo.Server.Entity.Fee" /><EntitySet Name="Groups" EntityType="Opex.Xeppo.Server.Entity.Group" /><EntitySet Name="Holdings" EntityType="Opex.Xeppo.Server.Entity.Holding" /><EntitySet Name="Incomes" EntityType="Opex.Xeppo.Server.Entity.Income" /><EntitySet Name="InsuranceCovers" EntityType="Opex.Xeppo.Server.Entity.InsuranceCover" /><EntitySet Name="InsuranceCoversRestricted" EntityType="Opex.Xeppo.Server.Entity.InsuranceCoverRestricted" /><EntitySet Name="InsurancePolicies" EntityType="Opex.Xeppo.Server.Entity.InsurancePolicy" /><EntitySet Name="InsurancePoliciesRestricted" EntityType="Opex.Xeppo.Server.Entity.InsurancePolicyRestricted" /><EntitySet Name="Invoices" EntityType="Opex.Xeppo.Server.Entity.Invoice" /><EntitySet Name="KeyFirmContacts" EntityType="Opex.Xeppo.Server.Entity.KeyFirmContact" /><EntitySet Name="AggregatedKeyFirmContacts" EntityType="Opex.Xeppo.Server.Entity.AggregatedKeyFirmContact" /><EntitySet Name="Liabilities" EntityType="Opex.Xeppo.Server.Entity.Liability" /><EntitySet Name="Loans" EntityType="Opex.Xeppo.Server.Entity.Loan" /><EntitySet Name="LoanLatests" EntityType="Opex.Xeppo.Server.Entity.vwLoanLatest" /><EntitySet Name="Members" EntityType="Opex.Xeppo.Server.Entity.Member" /><EntitySet Name="MemberAccounts" EntityType="Opex.Xeppo.Server.Entity.MemberAccount" /><EntitySet Name="OperatingStatements" EntityType="Opex.Xeppo.Server.Entity.OperatingStatement" /><EntitySet Name="PensionDetails" EntityType="Opex.Xeppo.Server.Entity.PensionDetail" /><EntitySet Name="Quotes" EntityType="Opex.Xeppo.Server.Entity.Quote" /><EntitySet Name="SMSFHoldings" EntityType="Opex.Xeppo.Server.Entity.SMSFHolding" /><EntitySet Name="TaxReturns" EntityType="Opex.Xeppo.Server.Entity.TaxReturn" /><EntitySet Name="WIPs" EntityType="Opex.Xeppo.Server.Entity.WIP" /><EntitySet Name="ClientRankingFeeCategories" EntityType="Opex.Xeppo.Server.Entity.vwClientRankingsFeeCategory" /><EntitySet Name="GroupRankingFeeCategories" EntityType="Opex.Xeppo.Server.Entity.vwGroupRankingsFeeCategory" /><EntitySet Name="FeeCommissionFeeCategories" EntityType="Opex.Xeppo.Server.Entity.TotalFees_Category" /><EntitySet Name="CommissionFeeCategories" EntityType="Opex.Xeppo.Server.Entity.Commission_Category" /><EntitySet Name="FeeFeeCategories" EntityType="Opex.Xeppo.Server.Entity.Fees_Category" /><EntitySet Name="FeeCommissions" EntityType="Opex.Xeppo.Server.Entity.Fees_Commission" /><EntitySet Name="FeeCategories" EntityType="Opex.Xeppo.Server.Entity.vwFeeCategoryDepth" /><EntitySet Name="GroupPrimaryContacts" EntityType="Opex.Xeppo.Server.Entity.vwGroupPrimaryContact" /><EntitySet Name="GroupTags" EntityType="Opex.Xeppo.Server.Entity.vwGroupTag" /><EntitySet Name="ClientTags" EntityType="Opex.Xeppo.Server.Entity.vwClientTag" /><EntitySet Name="Relationships" EntityType="Opex.Xeppo.Server.Entity.vwRelationship" /><EntitySet Name="Trends" EntityType="Opex.Xeppo.Server.Entity.Trend" /><EntitySet Name="DataClients" EntityType="Opex.Xeppo.Server.Entity.vwDataClient" /><EntitySet Name="SalesLeads" EntityType="Opex.Xeppo.Server.Entity.vwSalesLead" /><EntitySet Name="SalesOpportunities" EntityType="Opex.Xeppo.Server.Entity.vwSalesOpportunity" /><EntitySet Name="SalesPipelines" EntityType="Opex.Xeppo.Server.Entity.vwSalesPipeline" /><EntitySet Name="SalesPipelineStages" EntityType="Opex.Xeppo.Server.Entity.vwSalesPipelineStage" /><EntitySet Name="MarketingLists" EntityType="Opex.Xeppo.Server.Entity.vwMarketingList" /><EntitySet Name="MarketingClients" EntityType="Opex.Xeppo.Server.Entity.vwMarketingClient" /><EntitySet Name="PracticeSettings" EntityType="Opex.Xeppo.Server.Entity.Practice" /><EntitySet Name="Projects" EntityType="Opex.Xeppo.Server.Entity.vwProject" /><EntitySet Name="ProjectStages" EntityType="Opex.Xeppo.Server.Entity.vwProjectStage" /><EntitySet Name="ProjectRoles" EntityType="Opex.Xeppo.Server.Entity.vwProjectRole" /><EntitySet Name="ProjectParticipants" EntityType="Opex.Xeppo.Server.Entity.vwProjectParticipant" /><EntitySet Name="Activities" EntityType="Opex.Xeppo.Server.Entity.vwActivity" /><EntitySet Name="ActivityNote" EntityType="Opex.Xeppo.Server.Entity.vwActivityNote" /><EntitySet Name="TimeEntries" EntityType="Opex.Xeppo.Server.Entity.vwTimeEntry" /><EntitySet Name="BillableJobs" EntityType="Opex.Xeppo.Server.Entity.vwBillableJob" /><EntitySet Name="BillableTasks" EntityType="Opex.Xeppo.Server.Entity.vwBillableTask" /><EntitySet Name="NetWorthGroups" EntityType="Opex.Xeppo.Server.Entity.vwNetWorthGroup" /><EntitySet Name="NetWorthDatas" EntityType="Opex.Xeppo.Server.Entity.vwNetWorthData" /><EntitySet Name="NetWorthLiveDatas" EntityType="Opex.Xeppo.Server.Entity.vwNetWorthLiveData" /><EntitySet Name="NetWorthAccounts" EntityType="Opex.Xeppo.Server.Entity.vwNetWorthAccount" /><EntitySet Name="NetWorthAllocations" EntityType="Opex.Xeppo.Server.Entity.vwNetWorthAllocation" /><EntitySet Name="NetWorthSnapshots" EntityType="Opex.Xeppo.Server.Entity.vwNetWorthSnapshot" /><EntitySet Name="NetWorthSnapshotDatas" EntityType="Opex.Xeppo.Server.Entity.vwNetWorthSnapshotData" /><EntitySet Name="NetWorthSnapshotTotals" EntityType="Opex.Xeppo.Server.Entity.vwNetWorthSnapshotTotal" /><EntitySet Name="FDSDatas" EntityType="Opex.Xeppo.Server.Entity.vwFDSData" /><EntitySet Name="FDSClients" EntityType="Opex.Xeppo.Server.Entity.vwFDSClient" /><EntitySet Name="FDSClientPrimaries" EntityType="Opex.Xeppo.Server.Entity.vwFDSClientPrimary" /><EntitySet Name="FDSClientServices" EntityType="Opex.Xeppo.Server.Entity.vwFDSClientService" /><EntitySet Name="FDSEvents" EntityType="Opex.Xeppo.Server.Entity.vwFDSEvent" /><EntitySet Name="FDSServices" EntityType="Opex.Xeppo.Server.Entity.vwFDSService" /><EntitySet Name="FDSServicePackages" EntityType="Opex.Xeppo.Server.Entity.vwFDSServicePackage" /><EntitySet Name="FDSServicePackageServices" EntityType="Opex.Xeppo.Server.Entity.vwFDSServicePackageService" /><EntitySet Name="FDSAdvisers" EntityType="Opex.Xeppo.Server.Entity.vwFDSAdviser" /><EntitySet Name="FDSFees" EntityType="Opex.Xeppo.Server.Entity.vwFDSFee" /><EntitySet Name="FDSCommissions" EntityType="Opex.Xeppo.Server.Entity.vwFDSCommission" /><EntitySet Name="FDSClientFeeCategories" EntityType="Opex.Xeppo.Server.Entity.vwFDSClientFeeCategory" /><EntitySet Name="FDSClientSignatories" EntityType="Opex.Xeppo.Server.Entity.vwFDSClientSignatory" /><EntitySet Name="FDSSettings" EntityType="Opex.Xeppo.Server.Entity.vwFDSSettingsOdataView" /><EntitySet Name="FDSTerm" EntityType="Opex.Xeppo.Server.Entity.vwFDSTerm" /><EntitySet Name="FDSTermProvider" EntityType="Opex.Xeppo.Server.Entity.vwFDSTermProvider" /><EntitySet Name="FDSTermProviderSignatory" EntityType="Opex.Xeppo.Server.Entity.vwFDSTermProviderSignatory" /><EntitySet Name="FDSProvider" EntityType="Opex.Xeppo.Server.Entity.vwFDSProvider" /><EntitySet Name="FDSClientServiceReports" EntityType="Opex.Xeppo.Server.Entity.vwFDSClientServiceFact" /><EntitySet Name="FDSAssentCollectionAdvisers" EntityType="Opex.Xeppo.Server.Entity.FDSAssentCollectionAdviser" /><EntitySet Name="FDSAssentCollections" EntityType="Opex.Xeppo.Server.Entity.FDSAssentCollection" /><EntitySet Name="FDSAssentCollectionClients" EntityType="Opex.Xeppo.Server.Entity.FDSAssentCollectionClient" /><EntitySet Name="FDSAssentCollectionSignatories" EntityType="Opex.Xeppo.Server.Entity.FDSAssentCollectionSignatory" /><EntitySet Name="FDSAssentRecords" EntityType="Opex.Xeppo.Server.Entity.FDSAssentRecord" /><EntitySet Name="FDSAssentRecordRevenues" EntityType="Opex.Xeppo.Server.Entity.FDSAssentRecordRevenue" /><EntitySet Name="FDSAssentRecordServices" EntityType="Opex.Xeppo.Server.Entity.FDSAssentRecordService" /><EntitySet Name="FDSAssentRecordPaymentTerms" EntityType="Opex.Xeppo.Server.Entity.FDSAssentRecordPaymentTerm" /><EntitySet Name="FDSAssentRecordPaymentTermProviders" EntityType="Opex.Xeppo.Server.Entity.FDSAssentRecordPaymentTermProvider" /><EntitySet Name="FDSAssentRecordPaymentTermProviderSignatories" EntityType="Opex.Xeppo.Server.Entity.FDSAssentRecordPaymentTermProviderSignatory" /><EntitySet Name="FDSAssentRecordServiceReports" EntityType="Opex.Xeppo.Server.Entity.vwFDSAssentRecordServiceFact" /><EntitySet Name="AfslAdviserProfiles" EntityType="Opex.Xeppo.Server.Entity.vwAfslAdviserProfile" /><EntitySet Name="AfslAudits" EntityType="Opex.Xeppo.Server.Entity.vwAfslAudit" /><EntitySet Name="AfslAuthorisedRepresentativeTaxes" EntityType="Opex.Xeppo.Server.Entity.vwAfslAuthorisedRepresentativeTax" /><EntitySet Name="AfslClients" EntityType="Opex.Xeppo.Server.Entity.vwAfslClient" /><EntitySet Name="AfslComplaints" EntityType="Opex.Xeppo.Server.Entity.vwAfslComplaint" /><EntitySet Name="AfslFinancialServicesGuides" EntityType="Opex.Xeppo.Server.Entity.vwAfslFinancialServicesGuide" /><EntitySet Name="AfslMemberships" EntityType="Opex.Xeppo.Server.Entity.vwAfslMembership" /><EntitySet Name="AfslRestrictions" EntityType="Opex.Xeppo.Server.Entity.vwAfslRestriction" /><EntitySet Name="AfslProfessionalDevelopments" EntityType="Opex.Xeppo.Server.Entity.vwAfslProfessionalDevelopment" /><EntitySet Name="AfslQualifications" EntityType="Opex.Xeppo.Server.Entity.vwAfslQualification" /><EntitySet Name="AfslIncidentBreaches" EntityType="Opex.Xeppo.Server.Entity.vwAfslIncidentBreach" /><EntitySet Name="Documents" EntityType="Opex.Xeppo.Server.Entity.vwDocument" /><EntitySet Name="ChangeRequests" EntityType="Opex.Xeppo.Server.Entity.vwChangeRequest" /><EntitySet Name="ChangeRequestsPushBack" EntityType="Opex.Xeppo.Server.Entity.vwChangeRequestPushBack" /><EntitySet Name="DataPushHistory" EntityType="Opex.Xeppo.Server.Entity.vwDataPushHistory" /><EntitySet Name="Tasks" EntityType="Opex.Xeppo.Server.Entity.vwXeppoTask" /><EntitySet Name="ActivityCategories" EntityType="Opex.Xeppo.Server.Entity.vwActivityCategory" /><EntitySet Name="ActivitySubcategories" EntityType="Opex.Xeppo.Server.Entity.vwActivitySubcategory" /><EntitySet Name="UserAudits" EntityType="Opex.Xeppo.Server.Entity.vwAudit" /><EntitySet Name="Users" EntityType="Opex.Xeppo.Server.Entity.vwUserRolePractice" /><EntitySet Name="UserTeams" EntityType="Opex.Xeppo.Server.Entity.vwUserTeam" /><EntitySet Name="Teams" EntityType="Opex.Xeppo.Server.Entity.vwTeam" /><EntitySet Name="Employments" EntityType="Opex.Xeppo.Server.Entity.vwEmployment" /><EntitySet Name="ClientEstatePlannings" EntityType="Opex.Xeppo.Server.Entity.vwClientEstatePlanning" /><EntitySet Name="ClientEstatePlanningNominatedPersons" EntityType="Opex.Xeppo.Server.Entity.vwClientEstatePlanningNominatedPerson" /><EntitySet Name="ClientAgedCares" EntityType="Opex.Xeppo.Server.Entity.vwClientAgedCare" /><EntitySet Name="ClientAgedCareAccommodationPaymentTypes" EntityType="Opex.Xeppo.Server.Entity.vwClientAgedCareAccommodationPaymentType" /></EntityContainer></Schema></edmx:DataServices></edmx:Edmx>