GET /v2/odata/$metadata
An OData service is a self-describing service that exposes metadata defining the entity sets, relationships, entity types, and operations. An OData Metadata Document is a representation of the data model that describes the data and operations exposed by an OData service.
[OData-CSDL] describes an XML representation for OData metadata documents and provides an XML schema to validate their contents. The media type of the XML representation of an OData metadata document is application/xml.
OData services MUST expose a metadata document that describes the data model exposed by the service. The Metadata Document URL MUST be the root URL of the service with $metadata appended. To retrieve this document the client issues a GET request to the metadata document URL.
If a request for metadata does not specify a format preference (via accept header or $format) then the XML representation MUST be returned.
Return
Returns an EDMX document that contains a complete description of the feeds, types, properties and relationships exposed by the service.
Endpoint URL
https://api.wealthtechs.com/v2/odata/$metadata
Authorization
// Authorization via JWT Token.
Authorization: Bearer <YourToken>
Learn how to get access to our API V2.0 by clicking here.
You can copy and use our API v2.0 Example Token to get familiar with our API OData Resources.
Responses
Code | Type |
---|---|
200 | Success |
204 | No Content |
400 | Bad Request |
401 | Unauthorized |
Example Code
var myHeaders = new Headers();
myHeaders.append("Content-Type", "application/json");
myHeaders.append("Authorization", "Bearer eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJVc2VySW5mbyI6IntcIklkXCI6OTgxLFwiSWRlbnRpdHlJZFwiOlwiNjMyMzhhZTQtMzAyMC00NWI5LWEwODktOTE2ZTY4MDMyZTY3XCIsXCJVc2VyTmFtZVwiOlwiMF9URVNUX0NMSUVOVFwiLFwiRW1haWxcIjpcInRlc3RjbGllbnRAd2VhbHRodGVjaHMuY29tXCIsXCJGaXJzdE5hbWVcIjpcIlRlc3RcIixcIkxhc3ROYW1lXCI6XCJDbGllbnRcIixcIklzQ2xpZW50VXNlclwiOmZhbHNlfSIsIm5iZiI6MTY5NDcwMjU3OSwiZXhwIjoxOTI0OTIzNjAwLCJpc3MiOiJXZWFsdGhUZWNocyIsImF1ZCI6IkFQSVVzZXJzIn0.bNcP0ouNwtFoxrI7pYXw0WKiw0TN6w_R2-Ban5moo1A");
var requestOptions = {
method: 'GET',
headers: myHeaders,
redirect: 'follow'
};
fetch("https://api.wealthtechs.com/v2/odata/$metadata", requestOptions)
.then(response => response.text())
.then(result => console.log(result))
.catch(error => console.log('error', error));
Example Response
<?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="Wealthtechs.PAD.Core.Entities" xmlns="http://docs.oasis-open.org/odata/ns/edm"><EntityType Name="Fxrate"><Key><PropertyRef Name="BaseCurrencyId" /><PropertyRef Name="CustodianId" /><PropertyRef Name="LocalCurrencyId" /><PropertyRef Name="ProcessDate" /></Key><Property Name="CustodianId" Type="Edm.Int16" /><Property Name="ProcessDate" Type="Edm.DateTimeOffset" Nullable="false" /><Property Name="BaseCurrencyId" Type="Edm.Byte" Nullable="false" /><Property Name="LocalCurrencyId" Type="Edm.Byte" Nullable="false" /><Property Name="Factor" Type="Edm.Decimal" Nullable="false" Scale="Variable" /><NavigationProperty Name="BaseCurrency" Type="Wealthtechs.PAD.Core.Entities.Currency" /><NavigationProperty Name="Custodian" Type="Wealthtechs.PAD.Core.Entities.Custodian"><ReferentialConstraint Property="CustodianId" ReferencedProperty="Id" /></NavigationProperty><NavigationProperty Name="LocalCurrency" Type="Wealthtechs.PAD.Core.Entities.Currency" /></EntityType><EntityType Name="Position"><Key><PropertyRef Name="AccountId" /><PropertyRef Name="CustodianId" /><PropertyRef Name="CustomerId" /><PropertyRef Name="ProcessDate" /><PropertyRef Name="SecurityId" /></Key><Property Name="CustodianId" Type="Edm.Int16" /><Property Name="CustomerId" Type="Edm.Int16" /><Property Name="ProcessDate" Type="Edm.DateTimeOffset" Nullable="false" /><Property Name="AccountId" Type="Edm.Int32" /><Property Name="SecurityId" Type="Edm.Int32" /><Property Name="ShortPosition" Type="Edm.Boolean" Nullable="false" /><Property Name="Quantity" Type="Edm.Decimal" Nullable="false" Scale="Variable" /><Property Name="MarketValue" Type="Edm.Decimal" Nullable="false" Scale="Variable" /><Property Name="OriginalCost" Type="Edm.Decimal" Scale="Variable" /><Property Name="OriginalCostDate" Type="Edm.DateTimeOffset" /><Property Name="OriginalFace" Type="Edm.Decimal" Scale="Variable" /><NavigationProperty Name="Account" Type="Wealthtechs.PAD.Core.Entities.Account"><ReferentialConstraint Property="AccountId" ReferencedProperty="Id" /></NavigationProperty><NavigationProperty Name="Custodian" Type="Wealthtechs.PAD.Core.Entities.Custodian"><ReferentialConstraint Property="CustodianId" ReferencedProperty="Id" /></NavigationProperty><NavigationProperty Name="Customer" Type="Wealthtechs.PAD.Core.Entities.Customer"><ReferentialConstraint Property="CustomerId" ReferencedProperty="Id" /></NavigationProperty><NavigationProperty Name="Security" Type="Wealthtechs.PAD.Core.Entities.Security"><ReferentialConstraint Property="SecurityId" ReferencedProperty="Id" /></NavigationProperty></EntityType><EntityType Name="Price"><Key><PropertyRef Name="CustodianId" /><PropertyRef Name="ProcessDate" /><PropertyRef Name="SecurityId" /></Key><Property Name="CustodianId" Type="Edm.Int16" /><Property Name="ProcessDate" Type="Edm.DateTimeOffset" Nullable="false" /><Property Name="SecurityId" Type="Edm.Int32" /><Property Name="PriceValue" Type="Edm.Decimal" Nullable="false" Scale="Variable" /><NavigationProperty Name="Custodian" Type="Wealthtechs.PAD.Core.Entities.Custodian"><ReferentialConstraint Property="CustodianId" ReferencedProperty="Id" /></NavigationProperty><NavigationProperty Name="Security" Type="Wealthtechs.PAD.Core.Entities.Security"><ReferentialConstraint Property="SecurityId" ReferencedProperty="Id" /></NavigationProperty></EntityType><EntityType Name="InterfaceStatus"><Key><PropertyRef Name="CustodianId" /><PropertyRef Name="CustomerId" /><PropertyRef Name="ProcessDate" /></Key><Property Name="CustodianId" Type="Edm.Int32" Nullable="false" /><Property Name="CustomerId" Type="Edm.Int32" Nullable="false" /><Property Name="ProcessDate" Type="Edm.DateTimeOffset" Nullable="false" /><Property Name="RunDate" Type="Edm.DateTimeOffset" /><Property Name="ETA" Type="Edm.Duration" /><Property Name="StatusId" Type="Edm.Int32" Nullable="false" /><Property Name="HasTrn" Type="Edm.Boolean" /><Property Name="HasPos" Type="Edm.Boolean" /><Property Name="HasPri" Type="Edm.Boolean" /><Property Name="HasLot" Type="Edm.Boolean" /><Property Name="HasAcc" Type="Edm.Boolean" /><Property Name="HasVeh" Type="Edm.Boolean" /><Property Name="HasFx" Type="Edm.Boolean" /><Property Name="NoWeekendFiles" Type="Edm.Boolean" /><NavigationProperty Name="Status" Type="Wealthtechs.PAD.Core.Entities.InterfaceStatusType" /></EntityType><EntityType Name="Account"><Key><PropertyRef Name="Id" /></Key><Property Name="Id" Type="Edm.Int32" Nullable="false" /><Property Name="CustodianId" Type="Edm.Int16" /><Property Name="CustomerId" Type="Edm.Int16" /><Property Name="Number" Type="Edm.String" /><Property Name="Master" Type="Edm.String" /><Property Name="Name" Type="Edm.String" /><Property Name="AccountStatus" Type="Edm.String" /><Property Name="AccountType" Type="Edm.String" /><Property Name="PrimaryContact" Type="Edm.String" /><Property Name="MailingAddress" Type="Edm.String" /><Property Name="MailingCity" Type="Edm.String" /><Property Name="MailingState" Type="Edm.String" /><Property Name="MailingCountry" Type="Edm.String" /><Property Name="MailingZipCode" Type="Edm.String" /><Property Name="Email" Type="Edm.String" /><Property Name="Phone" Type="Edm.String" /><Property Name="BusinessPhone" Type="Edm.String" /><Property Name="DateOpened" Type="Edm.DateTimeOffset" /><Property Name="CurrencyId" Type="Edm.Byte" /><NavigationProperty Name="Currency" Type="Wealthtechs.PAD.Core.Entities.Currency"><ReferentialConstraint Property="CurrencyId" ReferencedProperty="Id" /></NavigationProperty><NavigationProperty Name="Custodian" Type="Wealthtechs.PAD.Core.Entities.Custodian"><ReferentialConstraint Property="CustodianId" ReferencedProperty="Id" /></NavigationProperty><NavigationProperty Name="Customer" Type="Wealthtechs.PAD.Core.Entities.Customer"><ReferentialConstraint Property="CustomerId" ReferencedProperty="Id" /></NavigationProperty><NavigationProperty Name="Positions" Type="Collection(Wealthtechs.PAD.Core.Entities.Position)" /><NavigationProperty Name="TaxLots" Type="Collection(Wealthtechs.PAD.Core.Entities.TaxLot)" /><NavigationProperty Name="Transactions" Type="Collection(Wealthtechs.PAD.Core.Entities.Transaction)" /></EntityType><EntityType Name="Currency"><Key><PropertyRef Name="Id" /></Key><Property Name="Id" Type="Edm.Byte" Nullable="false" /><Property Name="Alpha2Code" Type="Edm.String" /><Property Name="Alpha3Code" Type="Edm.String" /><Property Name="Description" Type="Edm.String" /><NavigationProperty Name="Accounts" Type="Collection(Wealthtechs.PAD.Core.Entities.Account)" /><NavigationProperty Name="FxrateBaseCurrencies" Type="Collection(Wealthtechs.PAD.Core.Entities.Fxrate)" /><NavigationProperty Name="FxrateLocalCurrencies" Type="Collection(Wealthtechs.PAD.Core.Entities.Fxrate)" /><NavigationProperty Name="Securities" Type="Collection(Wealthtechs.PAD.Core.Entities.Security)" /></EntityType><EntityType Name="Custodian"><Key><PropertyRef Name="Id" /></Key><Property Name="Id" Type="Edm.Int16" Nullable="false" /><Property Name="Name" Type="Edm.String" /><Property Name="ShortName" Type="Edm.String" /><NavigationProperty Name="Accounts" Type="Collection(Wealthtechs.PAD.Core.Entities.Account)" /><NavigationProperty Name="Fxrates" Type="Collection(Wealthtechs.PAD.Core.Entities.Fxrate)" /><NavigationProperty Name="Positions" Type="Collection(Wealthtechs.PAD.Core.Entities.Position)" /><NavigationProperty Name="Prices" Type="Collection(Wealthtechs.PAD.Core.Entities.Price)" /><NavigationProperty Name="Securities" Type="Collection(Wealthtechs.PAD.Core.Entities.Security)" /><NavigationProperty Name="TaxLots" Type="Collection(Wealthtechs.PAD.Core.Entities.TaxLot)" /><NavigationProperty Name="Transactions" Type="Collection(Wealthtechs.PAD.Core.Entities.Transaction)" /></EntityType><EntityType Name="Customer"><Key><PropertyRef Name="Id" /></Key><Property Name="Id" Type="Edm.Int16" Nullable="false" /><Property Name="Name" Type="Edm.String" /><Property Name="ShortName" Type="Edm.String" /><NavigationProperty Name="Accounts" Type="Collection(Wealthtechs.PAD.Core.Entities.Account)" /><NavigationProperty Name="Positions" Type="Collection(Wealthtechs.PAD.Core.Entities.Position)" /><NavigationProperty Name="TaxLots" Type="Collection(Wealthtechs.PAD.Core.Entities.TaxLot)" /><NavigationProperty Name="Transactions" Type="Collection(Wealthtechs.PAD.Core.Entities.Transaction)" /></EntityType><EntityType Name="InterfaceStatusType"><Key><PropertyRef Name="Id" /></Key><Property Name="Id" Type="Edm.Int32" Nullable="false" /><Property Name="Name" Type="Edm.String" /><Property Name="Description" Type="Edm.String" /><NavigationProperty Name="InterfaceStatuses" Type="Collection(Wealthtechs.PAD.Core.Entities.InterfaceStatus)" /></EntityType><EntityType Name="MajorAssetClass"><Key><PropertyRef Name="Id" /></Key><Property Name="Id" Type="Edm.Byte" Nullable="false" /><Property Name="Name" Type="Edm.String" /><Property Name="Description" Type="Edm.String" /><Property Name="PrimaryTypeCode" Type="Edm.String" /><NavigationProperty Name="PrimaryTypeCodeNavigation" Type="Wealthtechs.PAD.Core.Entities.PrimaryType"><ReferentialConstraint Property="PrimaryTypeCode" ReferencedProperty="Code" /></NavigationProperty><NavigationProperty Name="SecurityTypes" Type="Collection(Wealthtechs.PAD.Core.Entities.SecurityType)" /></EntityType><EntityType Name="PrimaryType"><Key><PropertyRef Name="Code" /></Key><Property Name="Code" Type="Edm.String" Nullable="false" /><Property Name="Description" Type="Edm.String" /><NavigationProperty Name="MajorAssetClasses" Type="Collection(Wealthtechs.PAD.Core.Entities.MajorAssetClass)" /></EntityType><EntityType Name="Sector"><Key><PropertyRef Name="Id" /></Key><Property Name="Id" Type="Edm.Byte" Nullable="false" /><Property Name="Name" Type="Edm.String" /><Property Name="Description" Type="Edm.String" /><NavigationProperty Name="Securities" Type="Collection(Wealthtechs.PAD.Core.Entities.Security)" /></EntityType><EntityType Name="Security"><Key><PropertyRef Name="Id" /></Key><Property Name="Id" Type="Edm.Int32" Nullable="false" /><Property Name="CustodianId" Type="Edm.Int16" /><Property Name="SecurityTypeId" Type="Edm.Byte" /><Property Name="CurrencyId" Type="Edm.Byte" /><Property Name="PrimarySymbol" Type="Edm.String" /><Property Name="Cusip" Type="Edm.String" /><Property Name="Sedol" Type="Edm.String" /><Property Name="Isin" Type="Edm.String" /><Property Name="Ticker" Type="Edm.String" /><Property Name="Description" Type="Edm.String" /><Property Name="SectorId" Type="Edm.Byte" /><Property Name="Industry" Type="Edm.String" /><NavigationProperty Name="Currency" Type="Wealthtechs.PAD.Core.Entities.Currency"><ReferentialConstraint Property="CurrencyId" ReferencedProperty="Id" /></NavigationProperty><NavigationProperty Name="Custodian" Type="Wealthtechs.PAD.Core.Entities.Custodian"><ReferentialConstraint Property="CustodianId" ReferencedProperty="Id" /></NavigationProperty><NavigationProperty Name="Sector" Type="Wealthtechs.PAD.Core.Entities.Sector"><ReferentialConstraint Property="SectorId" ReferencedProperty="Id" /></NavigationProperty><NavigationProperty Name="SecurityType" Type="Wealthtechs.PAD.Core.Entities.SecurityType"><ReferentialConstraint Property="SecurityTypeId" ReferencedProperty="Id" /></NavigationProperty><NavigationProperty Name="Positions" Type="Collection(Wealthtechs.PAD.Core.Entities.Position)" /><NavigationProperty Name="Prices" Type="Collection(Wealthtechs.PAD.Core.Entities.Price)" /><NavigationProperty Name="TaxLots" Type="Collection(Wealthtechs.PAD.Core.Entities.TaxLot)" /><NavigationProperty Name="TransactionSecurities" Type="Collection(Wealthtechs.PAD.Core.Entities.Transaction)" /><NavigationProperty Name="TransactionWhtSecurities" Type="Collection(Wealthtechs.PAD.Core.Entities.Transaction)" /></EntityType><EntityType Name="SecurityType"><Key><PropertyRef Name="Id" /></Key><Property Name="Id" Type="Edm.Byte" Nullable="false" /><Property Name="Code" Type="Edm.String" /><Property Name="Description" Type="Edm.String" /><Property Name="MajorAssetClassId" Type="Edm.Byte" /><NavigationProperty Name="MajorAssetClass" Type="Wealthtechs.PAD.Core.Entities.MajorAssetClass"><ReferentialConstraint Property="MajorAssetClassId" ReferencedProperty="Id" /></NavigationProperty><NavigationProperty Name="Securities" Type="Collection(Wealthtechs.PAD.Core.Entities.Security)" /></EntityType><EntityType Name="TaxLot"><Key><PropertyRef Name="Id" /></Key><Property Name="Id" Type="Edm.Int32" Nullable="false" /><Property Name="CustodianId" Type="Edm.Int16" /><Property Name="CustomerId" Type="Edm.Int16" /><Property Name="ProcessDate" Type="Edm.DateTimeOffset" Nullable="false" /><Property Name="AccountId" Type="Edm.Int32" /><Property Name="SecurityId" Type="Edm.Int32" /><Property Name="ShortPosition" Type="Edm.Boolean" Nullable="false" /><Property Name="TradeDate" Type="Edm.DateTimeOffset" Nullable="false" /><Property Name="Quantity" Type="Edm.Decimal" Nullable="false" Scale="Variable" /><Property Name="Amount" Type="Edm.Decimal" Nullable="false" Scale="Variable" /><Property Name="OriginalCost" Type="Edm.Decimal" Scale="Variable" /><Property Name="OriginalCostDate" Type="Edm.DateTimeOffset" /><Property Name="OriginalFace" Type="Edm.Decimal" Scale="Variable" /><NavigationProperty Name="Account" Type="Wealthtechs.PAD.Core.Entities.Account"><ReferentialConstraint Property="AccountId" ReferencedProperty="Id" /></NavigationProperty><NavigationProperty Name="Custodian" Type="Wealthtechs.PAD.Core.Entities.Custodian"><ReferentialConstraint Property="CustodianId" ReferencedProperty="Id" /></NavigationProperty><NavigationProperty Name="Customer" Type="Wealthtechs.PAD.Core.Entities.Customer"><ReferentialConstraint Property="CustomerId" ReferencedProperty="Id" /></NavigationProperty><NavigationProperty Name="Security" Type="Wealthtechs.PAD.Core.Entities.Security"><ReferentialConstraint Property="SecurityId" ReferencedProperty="Id" /></NavigationProperty></EntityType><EntityType Name="TransactionCode"><Key><PropertyRef Name="Id" /></Key><Property Name="Id" Type="Edm.Byte" Nullable="false" /><Property Name="Code" Type="Edm.String" /><Property Name="Description" Type="Edm.String" /><NavigationProperty Name="Transactions" Type="Collection(Wealthtechs.PAD.Core.Entities.Transaction)" /></EntityType><EntityType Name="Transaction"><Key><PropertyRef Name="Id" /></Key><Property Name="Id" Type="Edm.Int32" Nullable="false" /><Property Name="CustodianId" Type="Edm.Int16" /><Property Name="CustomerId" Type="Edm.Int16" /><Property Name="ProcessDate" Type="Edm.DateTimeOffset" Nullable="false" /><Property Name="AccountId" Type="Edm.Int32" /><Property Name="SecurityId" Type="Edm.Int32" /><Property Name="TransactionCodeId" Type="Edm.Byte" /><Property Name="CancelIndicator" Type="Edm.Boolean" /><Property Name="Comment" Type="Edm.String" /><Property Name="TradeDate" Type="Edm.DateTimeOffset" Nullable="false" /><Property Name="SettlementDate" Type="Edm.DateTimeOffset" /><Property Name="Quantity" Type="Edm.Decimal" Nullable="false" Scale="Variable" /><Property Name="Amount" Type="Edm.Decimal" Nullable="false" Scale="Variable" /><Property Name="OriginalCost" Type="Edm.Decimal" Scale="Variable" /><Property Name="OriginalCostDate" Type="Edm.DateTimeOffset" /><Property Name="Sdtype" Type="Edm.String" /><Property Name="Sdsymbol" Type="Edm.String" /><Property Name="Exchange" Type="Edm.Decimal" Scale="Variable" /><Property Name="ExchangeFee" Type="Edm.Decimal" Scale="Variable" /><Property Name="Commission" Type="Edm.Decimal" Scale="Variable" /><Property Name="OtherFees" Type="Edm.Decimal" Scale="Variable" /><Property Name="Broker" Type="Edm.String" /><Property Name="WhtSecurityId" Type="Edm.Int32" /><Property Name="ExecPri" Type="Edm.Decimal" Scale="Variable" /><Property Name="ExecPriCalc" Type="Edm.Decimal" Scale="Variable" /><Property Name="Reorg" Type="Edm.Boolean" /><NavigationProperty Name="Account" Type="Wealthtechs.PAD.Core.Entities.Account"><ReferentialConstraint Property="AccountId" ReferencedProperty="Id" /></NavigationProperty><NavigationProperty Name="Custodian" Type="Wealthtechs.PAD.Core.Entities.Custodian"><ReferentialConstraint Property="CustodianId" ReferencedProperty="Id" /></NavigationProperty><NavigationProperty Name="Customer" Type="Wealthtechs.PAD.Core.Entities.Customer"><ReferentialConstraint Property="CustomerId" ReferencedProperty="Id" /></NavigationProperty><NavigationProperty Name="Security" Type="Wealthtechs.PAD.Core.Entities.Security"><ReferentialConstraint Property="SecurityId" ReferencedProperty="Id" /></NavigationProperty><NavigationProperty Name="TransactionCode" Type="Wealthtechs.PAD.Core.Entities.TransactionCode"><ReferentialConstraint Property="TransactionCodeId" ReferencedProperty="Id" /></NavigationProperty><NavigationProperty Name="WhtSecurity" Type="Wealthtechs.PAD.Core.Entities.Security"><ReferentialConstraint Property="SecurityId" ReferencedProperty="Id" /></NavigationProperty></EntityType></Schema><Schema Namespace="Default" xmlns="http://docs.oasis-open.org/odata/ns/edm"><Function Name="GetByCompositeKeys" IsBound="true"><Parameter Name="bindingParameter" Type="Collection(Wealthtechs.PAD.Core.Entities.Fxrate)" /><Parameter Name="custodianId" Type="Edm.Int32" Nullable="false" /><Parameter Name="processDate" Type="Edm.DateTimeOffset" Nullable="false" /><Parameter Name="baseCurrencyId" Type="Edm.Int32" Nullable="false" /><Parameter Name="localCurrencyId" Type="Edm.Int32" Nullable="false" /><ReturnType Type="Wealthtechs.PAD.Core.Entities.Fxrate" /></Function><Function Name="GetByCompositeKeys" IsBound="true"><Parameter Name="bindingParameter" Type="Collection(Wealthtechs.PAD.Core.Entities.InterfaceStatus)" /><Parameter Name="custodianId" Type="Edm.Int32" Nullable="false" /><Parameter Name="customerId" Type="Edm.Int32" Nullable="false" /><Parameter Name="processDate" Type="Edm.DateTimeOffset" Nullable="false" /><ReturnType Type="Wealthtechs.PAD.Core.Entities.InterfaceStatus" /></Function><Function Name="GetByCompositeKeys" IsBound="true"><Parameter Name="bindingParameter" Type="Collection(Wealthtechs.PAD.Core.Entities.Position)" /><Parameter Name="custodianId" Type="Edm.Int32" Nullable="false" /><Parameter Name="customerId" Type="Edm.Int32" Nullable="false" /><Parameter Name="processDate" Type="Edm.DateTimeOffset" Nullable="false" /><Parameter Name="accountId" Type="Edm.Int32" Nullable="false" /><Parameter Name="securityId" Type="Edm.Int32" Nullable="false" /><Parameter Name="custodianId" Type="Edm.Int32" Nullable="false" /><Parameter Name="processDate" Type="Edm.DateTimeOffset" Nullable="false" /><Parameter Name="securityId" Type="Edm.Int32" Nullable="false" /><ReturnType Type="Wealthtechs.PAD.Core.Entities.Position" /></Function><Function Name="GetByCompositeKeys" IsBound="true"><Parameter Name="bindingParameter" Type="Collection(Wealthtechs.PAD.Core.Entities.Price)" /><ReturnType Type="Wealthtechs.PAD.Core.Entities.Price" /></Function><Function Name="GetDistinctProcessDates" IsBound="true"><Parameter Name="bindingParameter" Type="Collection(Wealthtechs.PAD.Core.Entities.Position)" /><ReturnType Type="Collection(Edm.DateTimeOffset)" Nullable="false" /></Function><Function Name="GetDistinctProcessDates" IsBound="true"><Parameter Name="bindingParameter" Type="Collection(Wealthtechs.PAD.Core.Entities.Transaction)" /><ReturnType Type="Collection(Edm.DateTimeOffset)" Nullable="false" /></Function><EntityContainer Name="Container"><EntitySet Name="Accounts" EntityType="Wealthtechs.PAD.Core.Entities.Account"><NavigationPropertyBinding Path="Currency" Target="Currencies" /><NavigationPropertyBinding Path="Custodian" Target="Custodians" /><NavigationPropertyBinding Path="Customer" Target="Customers" /><NavigationPropertyBinding Path="TaxLots" Target="TaxLots" /><NavigationPropertyBinding Path="Transactions" Target="Transactions" /></EntitySet><EntitySet Name="Currencies" EntityType="Wealthtechs.PAD.Core.Entities.Currency"><NavigationPropertyBinding Path="Accounts" Target="Accounts" /><NavigationPropertyBinding Path="Securities" Target="Securities" /></EntitySet><EntitySet Name="Custodians" EntityType="Wealthtechs.PAD.Core.Entities.Custodian"><NavigationPropertyBinding Path="Accounts" Target="Accounts" /><NavigationPropertyBinding Path="Securities" Target="Securities" /><NavigationPropertyBinding Path="TaxLots" Target="TaxLots" /><NavigationPropertyBinding Path="Transactions" Target="Transactions" /></EntitySet><EntitySet Name="Customers" EntityType="Wealthtechs.PAD.Core.Entities.Customer"><NavigationPropertyBinding Path="Accounts" Target="Accounts" /><NavigationPropertyBinding Path="TaxLots" Target="TaxLots" /><NavigationPropertyBinding Path="Transactions" Target="Transactions" /></EntitySet><EntitySet Name="FxRates" EntityType="Wealthtechs.PAD.Core.Entities.Fxrate"><NavigationPropertyBinding Path="BaseCurrency" Target="Currencies" /><NavigationPropertyBinding Path="Custodian" Target="Custodians" /><NavigationPropertyBinding Path="LocalCurrency" Target="Currencies" /></EntitySet><EntitySet Name="InterfaceStatuses" EntityType="Wealthtechs.PAD.Core.Entities.InterfaceStatus"><NavigationPropertyBinding Path="Status" Target="InterfaceStatusTypes" /></EntitySet><EntitySet Name="InterfaceStatusTypes" EntityType="Wealthtechs.PAD.Core.Entities.InterfaceStatusType" /><EntitySet Name="MajorAssetClasses" EntityType="Wealthtechs.PAD.Core.Entities.MajorAssetClass"><NavigationPropertyBinding Path="PrimaryTypeCodeNavigation" Target="PrimaryTypes" /><NavigationPropertyBinding Path="SecurityTypes" Target="SecurityTypes" /></EntitySet><EntitySet Name="Positions" EntityType="Wealthtechs.PAD.Core.Entities.Position"><NavigationPropertyBinding Path="Account" Target="Accounts" /><NavigationPropertyBinding Path="Custodian" Target="Custodians" /><NavigationPropertyBinding Path="Customer" Target="Customers" /><NavigationPropertyBinding Path="Security" Target="Securities" /></EntitySet><EntitySet Name="Prices" EntityType="Wealthtechs.PAD.Core.Entities.Price"><NavigationPropertyBinding Path="Custodian" Target="Custodians" /><NavigationPropertyBinding Path="Security" Target="Securities" /></EntitySet><EntitySet Name="PrimaryTypes" EntityType="Wealthtechs.PAD.Core.Entities.PrimaryType"><NavigationPropertyBinding Path="MajorAssetClasses" Target="MajorAssetClasses" /></EntitySet><EntitySet Name="Sectors" EntityType="Wealthtechs.PAD.Core.Entities.Sector"><NavigationPropertyBinding Path="Securities" Target="Securities" /></EntitySet><EntitySet Name="Securities" EntityType="Wealthtechs.PAD.Core.Entities.Security"><NavigationPropertyBinding Path="Currency" Target="Currencies" /><NavigationPropertyBinding Path="Custodian" Target="Custodians" /><NavigationPropertyBinding Path="Sector" Target="Sectors" /><NavigationPropertyBinding Path="SecurityType" Target="SecurityTypes" /><NavigationPropertyBinding Path="TaxLots" Target="TaxLots" /><NavigationPropertyBinding Path="TransactionSecurities" Target="Transactions" /><NavigationPropertyBinding Path="TransactionWhtSecurities" Target="Transactions" /></EntitySet><EntitySet Name="SecurityTypes" EntityType="Wealthtechs.PAD.Core.Entities.SecurityType"><NavigationPropertyBinding Path="MajorAssetClass" Target="MajorAssetClasses" /><NavigationPropertyBinding Path="Securities" Target="Securities" /></EntitySet><EntitySet Name="TaxLots" EntityType="Wealthtechs.PAD.Core.Entities.TaxLot"><NavigationPropertyBinding Path="Account" Target="Accounts" /><NavigationPropertyBinding Path="Custodian" Target="Custodians" /><NavigationPropertyBinding Path="Customer" Target="Customers" /><NavigationPropertyBinding Path="Security" Target="Securities" /></EntitySet><EntitySet Name="TransactionCodes" EntityType="Wealthtechs.PAD.Core.Entities.TransactionCode"><NavigationPropertyBinding Path="Transactions" Target="Transactions" /></EntitySet><EntitySet Name="Transactions" EntityType="Wealthtechs.PAD.Core.Entities.Transaction"><NavigationPropertyBinding Path="Account" Target="Accounts" /><NavigationPropertyBinding Path="Custodian" Target="Custodians" /><NavigationPropertyBinding Path="Customer" Target="Customers" /><NavigationPropertyBinding Path="Security" Target="Securities" /><NavigationPropertyBinding Path="TransactionCode" Target="TransactionCodes" /><NavigationPropertyBinding Path="WhtSecurity" Target="Securities" /></EntitySet><EntitySet Name="Fxrate" EntityType="Wealthtechs.PAD.Core.Entities.Fxrate"><NavigationPropertyBinding Path="BaseCurrency" Target="Currencies" /><NavigationPropertyBinding Path="Custodian" Target="Custodians" /><NavigationPropertyBinding Path="LocalCurrency" Target="Currencies" /></EntitySet><EntitySet Name="InterfaceStatus" EntityType="Wealthtechs.PAD.Core.Entities.InterfaceStatus"><NavigationPropertyBinding Path="Status" Target="InterfaceStatusTypes" /></EntitySet><EntitySet Name="Position" EntityType="Wealthtechs.PAD.Core.Entities.Position"><NavigationPropertyBinding Path="Account" Target="Accounts" /><NavigationPropertyBinding Path="Custodian" Target="Custodians" /><NavigationPropertyBinding Path="Customer" Target="Customers" /><NavigationPropertyBinding Path="Security" Target="Securities" /></EntitySet><EntitySet Name="Price" EntityType="Wealthtechs.PAD.Core.Entities.Price"><NavigationPropertyBinding Path="Custodian" Target="Custodians" /><NavigationPropertyBinding Path="Security" Target="Securities" /></EntitySet></EntityContainer></Schema></edmx:DataServices></edmx:Edmx>
You can copy the raw XML and use a tool like this to give format to it.
Pretty XML Example
<?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="Wealthtechs.PAD.Core.Entities" xmlns="http://docs.oasis-open.org/odata/ns/edm">
<EntityType Name="Fxrate">
<Key>
<PropertyRef Name="BaseCurrencyId" />
<PropertyRef Name="CustodianId" />
<PropertyRef Name="LocalCurrencyId" />
<PropertyRef Name="ProcessDate" />
</Key>
<Property Name="CustodianId" Type="Edm.Int16" />
<Property Name="ProcessDate" Type="Edm.DateTimeOffset" Nullable="false" />
<Property Name="BaseCurrencyId" Type="Edm.Byte" Nullable="false" />
<Property Name="LocalCurrencyId" Type="Edm.Byte" Nullable="false" />
<Property Name="Factor" Type="Edm.Decimal" Nullable="false" Scale="Variable" />
<NavigationProperty Name="BaseCurrency" Type="Wealthtechs.PAD.Core.Entities.Currency" />
<NavigationProperty Name="Custodian" Type="Wealthtechs.PAD.Core.Entities.Custodian">
<ReferentialConstraint Property="CustodianId" ReferencedProperty="Id" />
</NavigationProperty>
<NavigationProperty Name="LocalCurrency" Type="Wealthtechs.PAD.Core.Entities.Currency" />
</EntityType>
<EntityType Name="Position">
<Key>
<PropertyRef Name="AccountId" />
<PropertyRef Name="CustodianId" />
<PropertyRef Name="CustomerId" />
<PropertyRef Name="ProcessDate" />
<PropertyRef Name="SecurityId" />
</Key>
<Property Name="CustodianId" Type="Edm.Int16" />
<Property Name="CustomerId" Type="Edm.Int16" />
<Property Name="ProcessDate" Type="Edm.DateTimeOffset" Nullable="false" />
<Property Name="AccountId" Type="Edm.Int32" />
<Property Name="SecurityId" Type="Edm.Int32" />
<Property Name="ShortPosition" Type="Edm.Boolean" Nullable="false" />
<Property Name="Quantity" Type="Edm.Decimal" Nullable="false" Scale="Variable" />
<Property Name="MarketValue" Type="Edm.Decimal" Nullable="false" Scale="Variable" />
<Property Name="OriginalCost" Type="Edm.Decimal" Scale="Variable" />
<Property Name="OriginalCostDate" Type="Edm.DateTimeOffset" />
<Property Name="OriginalFace" Type="Edm.Decimal" Scale="Variable" />
<NavigationProperty Name="Account" Type="Wealthtechs.PAD.Core.Entities.Account">
<ReferentialConstraint Property="AccountId" ReferencedProperty="Id" />
</NavigationProperty>
<NavigationProperty Name="Custodian" Type="Wealthtechs.PAD.Core.Entities.Custodian">
<ReferentialConstraint Property="CustodianId" ReferencedProperty="Id" />
</NavigationProperty>
<NavigationProperty Name="Customer" Type="Wealthtechs.PAD.Core.Entities.Customer">
<ReferentialConstraint Property="CustomerId" ReferencedProperty="Id" />
</NavigationProperty>
<NavigationProperty Name="Security" Type="Wealthtechs.PAD.Core.Entities.Security">
<ReferentialConstraint Property="SecurityId" ReferencedProperty="Id" />
</NavigationProperty>
</EntityType>
<EntityType Name="Price">
<Key>
<PropertyRef Name="CustodianId" />
<PropertyRef Name="ProcessDate" />
<PropertyRef Name="SecurityId" />
</Key>
<Property Name="CustodianId" Type="Edm.Int16" />
<Property Name="ProcessDate" Type="Edm.DateTimeOffset" Nullable="false" />
<Property Name="SecurityId" Type="Edm.Int32" />
<Property Name="PriceValue" Type="Edm.Decimal" Nullable="false" Scale="Variable" />
<NavigationProperty Name="Custodian" Type="Wealthtechs.PAD.Core.Entities.Custodian">
<ReferentialConstraint Property="CustodianId" ReferencedProperty="Id" />
</NavigationProperty>
<NavigationProperty Name="Security" Type="Wealthtechs.PAD.Core.Entities.Security">
<ReferentialConstraint Property="SecurityId" ReferencedProperty="Id" />
</NavigationProperty>
</EntityType>
<EntityType Name="InterfaceStatus">
<Key>
<PropertyRef Name="CustodianId" />
<PropertyRef Name="CustomerId" />
<PropertyRef Name="ProcessDate" />
</Key>
<Property Name="CustodianId" Type="Edm.Int32" Nullable="false" />
<Property Name="CustomerId" Type="Edm.Int32" Nullable="false" />
<Property Name="ProcessDate" Type="Edm.DateTimeOffset" Nullable="false" />
<Property Name="RunDate" Type="Edm.DateTimeOffset" />
<Property Name="ETA" Type="Edm.Duration" />
<Property Name="StatusId" Type="Edm.Int32" Nullable="false" />
<Property Name="HasTrn" Type="Edm.Boolean" />
<Property Name="HasPos" Type="Edm.Boolean" />
<Property Name="HasPri" Type="Edm.Boolean" />
<Property Name="HasLot" Type="Edm.Boolean" />
<Property Name="HasAcc" Type="Edm.Boolean" />
<Property Name="HasVeh" Type="Edm.Boolean" />
<Property Name="HasFx" Type="Edm.Boolean" />
<Property Name="NoWeekendFiles" Type="Edm.Boolean" />
<NavigationProperty Name="Status" Type="Wealthtechs.PAD.Core.Entities.InterfaceStatusType" />
</EntityType>
<EntityType Name="Account">
<Key>
<PropertyRef Name="Id" />
</Key>
<Property Name="Id" Type="Edm.Int32" Nullable="false" />
<Property Name="CustodianId" Type="Edm.Int16" />
<Property Name="CustomerId" Type="Edm.Int16" />
<Property Name="Number" Type="Edm.String" />
<Property Name="Master" Type="Edm.String" />
<Property Name="Name" Type="Edm.String" />
<Property Name="AccountStatus" Type="Edm.String" />
<Property Name="AccountType" Type="Edm.String" />
<Property Name="PrimaryContact" Type="Edm.String" />
<Property Name="MailingAddress" Type="Edm.String" />
<Property Name="MailingCity" Type="Edm.String" />
<Property Name="MailingState" Type="Edm.String" />
<Property Name="MailingCountry" Type="Edm.String" />
<Property Name="MailingZipCode" Type="Edm.String" />
<Property Name="Email" Type="Edm.String" />
<Property Name="Phone" Type="Edm.String" />
<Property Name="BussinesPhone" Type="Edm.String" />
<Property Name="DateOpened" Type="Edm.DateTimeOffset" />
<Property Name="CurrencyId" Type="Edm.Byte" />
<NavigationProperty Name="Currency" Type="Wealthtechs.PAD.Core.Entities.Currency">
<ReferentialConstraint Property="CurrencyId" ReferencedProperty="Id" />
</NavigationProperty>
<NavigationProperty Name="Custodian" Type="Wealthtechs.PAD.Core.Entities.Custodian">
<ReferentialConstraint Property="CustodianId" ReferencedProperty="Id" />
</NavigationProperty>
<NavigationProperty Name="Customer" Type="Wealthtechs.PAD.Core.Entities.Customer">
<ReferentialConstraint Property="CustomerId" ReferencedProperty="Id" />
</NavigationProperty>
<NavigationProperty Name="Positions" Type="Collection(Wealthtechs.PAD.Core.Entities.Position)" />
<NavigationProperty Name="TaxLots" Type="Collection(Wealthtechs.PAD.Core.Entities.TaxLot)" />
<NavigationProperty Name="Transactions" Type="Collection(Wealthtechs.PAD.Core.Entities.Transaction)" />
</EntityType>
<EntityType Name="Currency">
<Key>
<PropertyRef Name="Id" />
</Key>
<Property Name="Id" Type="Edm.Byte" Nullable="false" />
<Property Name="Alpha2Code" Type="Edm.String" />
<Property Name="Alpha3Code" Type="Edm.String" />
<Property Name="Description" Type="Edm.String" />
<NavigationProperty Name="Accounts" Type="Collection(Wealthtechs.PAD.Core.Entities.Account)" />
<NavigationProperty Name="FxrateBaseCurrencies" Type="Collection(Wealthtechs.PAD.Core.Entities.Fxrate)" />
<NavigationProperty Name="FxrateLocalCurrencies" Type="Collection(Wealthtechs.PAD.Core.Entities.Fxrate)" />
<NavigationProperty Name="Securities" Type="Collection(Wealthtechs.PAD.Core.Entities.Security)" />
</EntityType>
<EntityType Name="Custodian">
<Key>
<PropertyRef Name="Id" />
</Key>
<Property Name="Id" Type="Edm.Int16" Nullable="false" />
<Property Name="Name" Type="Edm.String" />
<Property Name="ShortName" Type="Edm.String" />
<NavigationProperty Name="Accounts" Type="Collection(Wealthtechs.PAD.Core.Entities.Account)" />
<NavigationProperty Name="Fxrates" Type="Collection(Wealthtechs.PAD.Core.Entities.Fxrate)" />
<NavigationProperty Name="Positions" Type="Collection(Wealthtechs.PAD.Core.Entities.Position)" />
<NavigationProperty Name="Prices" Type="Collection(Wealthtechs.PAD.Core.Entities.Price)" />
<NavigationProperty Name="Securities" Type="Collection(Wealthtechs.PAD.Core.Entities.Security)" />
<NavigationProperty Name="TaxLots" Type="Collection(Wealthtechs.PAD.Core.Entities.TaxLot)" />
<NavigationProperty Name="Transactions" Type="Collection(Wealthtechs.PAD.Core.Entities.Transaction)" />
</EntityType>
<EntityType Name="Customer">
<Key>
<PropertyRef Name="Id" />
</Key>
<Property Name="Id" Type="Edm.Int16" Nullable="false" />
<Property Name="Name" Type="Edm.String" />
<Property Name="ShortName" Type="Edm.String" />
<NavigationProperty Name="Accounts" Type="Collection(Wealthtechs.PAD.Core.Entities.Account)" />
<NavigationProperty Name="Positions" Type="Collection(Wealthtechs.PAD.Core.Entities.Position)" />
<NavigationProperty Name="TaxLots" Type="Collection(Wealthtechs.PAD.Core.Entities.TaxLot)" />
<NavigationProperty Name="Transactions" Type="Collection(Wealthtechs.PAD.Core.Entities.Transaction)" />
</EntityType>
<EntityType Name="InterfaceStatusType">
<Key>
<PropertyRef Name="Id" />
</Key>
<Property Name="Id" Type="Edm.Int32" Nullable="false" />
<Property Name="Name" Type="Edm.String" />
<Property Name="Description" Type="Edm.String" />
<NavigationProperty Name="InterfaceStatuses" Type="Collection(Wealthtechs.PAD.Core.Entities.InterfaceStatus)" />
</EntityType>
<EntityType Name="MajorAssetClass">
<Key>
<PropertyRef Name="Id" />
</Key>
<Property Name="Id" Type="Edm.Byte" Nullable="false" />
<Property Name="Name" Type="Edm.String" />
<Property Name="Description" Type="Edm.String" />
<Property Name="PrimaryTypeCode" Type="Edm.String" />
<NavigationProperty Name="PrimaryTypeCodeNavigation" Type="Wealthtechs.PAD.Core.Entities.PrimaryType">
<ReferentialConstraint Property="PrimaryTypeCode" ReferencedProperty="Code" />
</NavigationProperty>
<NavigationProperty Name="SecurityTypes" Type="Collection(Wealthtechs.PAD.Core.Entities.SecurityType)" />
</EntityType>
<EntityType Name="PrimaryType">
<Key>
<PropertyRef Name="Code" />
</Key>
<Property Name="Code" Type="Edm.String" Nullable="false" />
<Property Name="Description" Type="Edm.String" />
<NavigationProperty Name="MajorAssetClasses" Type="Collection(Wealthtechs.PAD.Core.Entities.MajorAssetClass)" />
</EntityType>
<EntityType Name="Sector">
<Key>
<PropertyRef Name="Id" />
</Key>
<Property Name="Id" Type="Edm.Byte" Nullable="false" />
<Property Name="Name" Type="Edm.String" />
<Property Name="Description" Type="Edm.String" />
<NavigationProperty Name="Securities" Type="Collection(Wealthtechs.PAD.Core.Entities.Security)" />
</EntityType>
<EntityType Name="Security">
<Key>
<PropertyRef Name="Id" />
</Key>
<Property Name="Id" Type="Edm.Int32" Nullable="false" />
<Property Name="CustodianId" Type="Edm.Int16" />
<Property Name="SecurityTypeId" Type="Edm.Byte" />
<Property Name="CurrencyId" Type="Edm.Byte" />
<Property Name="PrimarySymbol" Type="Edm.String" />
<Property Name="Cusip" Type="Edm.String" />
<Property Name="Sedol" Type="Edm.String" />
<Property Name="Isin" Type="Edm.String" />
<Property Name="Ticker" Type="Edm.String" />
<Property Name="Description" Type="Edm.String" />
<Property Name="SectorId" Type="Edm.Byte" />
<Property Name="Industry" Type="Edm.String" />
<NavigationProperty Name="Currency" Type="Wealthtechs.PAD.Core.Entities.Currency">
<ReferentialConstraint Property="CurrencyId" ReferencedProperty="Id" />
</NavigationProperty>
<NavigationProperty Name="Custodian" Type="Wealthtechs.PAD.Core.Entities.Custodian">
<ReferentialConstraint Property="CustodianId" ReferencedProperty="Id" />
</NavigationProperty>
<NavigationProperty Name="Sector" Type="Wealthtechs.PAD.Core.Entities.Sector">
<ReferentialConstraint Property="SectorId" ReferencedProperty="Id" />
</NavigationProperty>
<NavigationProperty Name="SecurityType" Type="Wealthtechs.PAD.Core.Entities.SecurityType">
<ReferentialConstraint Property="SecurityTypeId" ReferencedProperty="Id" />
</NavigationProperty>
<NavigationProperty Name="Positions" Type="Collection(Wealthtechs.PAD.Core.Entities.Position)" />
<NavigationProperty Name="Prices" Type="Collection(Wealthtechs.PAD.Core.Entities.Price)" />
<NavigationProperty Name="TaxLots" Type="Collection(Wealthtechs.PAD.Core.Entities.TaxLot)" />
<NavigationProperty Name="TransactionSecurities" Type="Collection(Wealthtechs.PAD.Core.Entities.Transaction)" />
<NavigationProperty Name="TransactionWhtSecurities" Type="Collection(Wealthtechs.PAD.Core.Entities.Transaction)" />
</EntityType>
<EntityType Name="SecurityType">
<Key>
<PropertyRef Name="Id" />
</Key>
<Property Name="Id" Type="Edm.Byte" Nullable="false" />
<Property Name="Code" Type="Edm.String" />
<Property Name="Description" Type="Edm.String" />
<Property Name="MajorAssetClassId" Type="Edm.Byte" />
<NavigationProperty Name="MajorAssetClass" Type="Wealthtechs.PAD.Core.Entities.MajorAssetClass">
<ReferentialConstraint Property="MajorAssetClassId" ReferencedProperty="Id" />
</NavigationProperty>
<NavigationProperty Name="Securities" Type="Collection(Wealthtechs.PAD.Core.Entities.Security)" />
</EntityType>
<EntityType Name="TaxLot">
<Key>
<PropertyRef Name="Id" />
</Key>
<Property Name="Id" Type="Edm.Int32" Nullable="false" />
<Property Name="CustodianId" Type="Edm.Int16" />
<Property Name="CustomerId" Type="Edm.Int16" />
<Property Name="ProcessDate" Type="Edm.DateTimeOffset" Nullable="false" />
<Property Name="AccountId" Type="Edm.Int32" />
<Property Name="SecurityId" Type="Edm.Int32" />
<Property Name="ShortPosition" Type="Edm.Boolean" Nullable="false" />
<Property Name="TradeDate" Type="Edm.DateTimeOffset" Nullable="false" />
<Property Name="Quantity" Type="Edm.Decimal" Nullable="false" Scale="Variable" />
<Property Name="Amount" Type="Edm.Decimal" Nullable="false" Scale="Variable" />
<Property Name="OriginalCost" Type="Edm.Decimal" Scale="Variable" />
<Property Name="OriginalCostDate" Type="Edm.DateTimeOffset" />
<Property Name="OriginalFace" Type="Edm.Decimal" Scale="Variable" />
<NavigationProperty Name="Account" Type="Wealthtechs.PAD.Core.Entities.Account">
<ReferentialConstraint Property="AccountId" ReferencedProperty="Id" />
</NavigationProperty>
<NavigationProperty Name="Custodian" Type="Wealthtechs.PAD.Core.Entities.Custodian">
<ReferentialConstraint Property="CustodianId" ReferencedProperty="Id" />
</NavigationProperty>
<NavigationProperty Name="Customer" Type="Wealthtechs.PAD.Core.Entities.Customer">
<ReferentialConstraint Property="CustomerId" ReferencedProperty="Id" />
</NavigationProperty>
<NavigationProperty Name="Security" Type="Wealthtechs.PAD.Core.Entities.Security">
<ReferentialConstraint Property="SecurityId" ReferencedProperty="Id" />
</NavigationProperty>
</EntityType>
<EntityType Name="TransactionCode">
<Key>
<PropertyRef Name="Id" />
</Key>
<Property Name="Id" Type="Edm.Byte" Nullable="false" />
<Property Name="Code" Type="Edm.String" />
<Property Name="Description" Type="Edm.String" />
<NavigationProperty Name="Transactions" Type="Collection(Wealthtechs.PAD.Core.Entities.Transaction)" />
</EntityType>
<EntityType Name="Transaction">
<Key>
<PropertyRef Name="Id" />
</Key>
<Property Name="Id" Type="Edm.Int32" Nullable="false" />
<Property Name="CustodianId" Type="Edm.Int16" />
<Property Name="CustomerId" Type="Edm.Int16" />
<Property Name="ProcessDate" Type="Edm.DateTimeOffset" Nullable="false" />
<Property Name="AccountId" Type="Edm.Int32" />
<Property Name="SecurityId" Type="Edm.Int32" />
<Property Name="TransactionCodeId" Type="Edm.Byte" />
<Property Name="CancelIndicator" Type="Edm.Boolean" />
<Property Name="Comment" Type="Edm.String" />
<Property Name="TradeDate" Type="Edm.DateTimeOffset" Nullable="false" />
<Property Name="SettlementDate" Type="Edm.DateTimeOffset" />
<Property Name="Quantity" Type="Edm.Decimal" Nullable="false" Scale="Variable" />
<Property Name="Amount" Type="Edm.Decimal" Nullable="false" Scale="Variable" />
<Property Name="OriginalCost" Type="Edm.Decimal" Scale="Variable" />
<Property Name="OriginalCostDate" Type="Edm.DateTimeOffset" />
<Property Name="Sdtype" Type="Edm.String" />
<Property Name="Sdsymbol" Type="Edm.String" />
<Property Name="Exchange" Type="Edm.Decimal" Scale="Variable" />
<Property Name="ExchangeFee" Type="Edm.Decimal" Scale="Variable" />
<Property Name="Commission" Type="Edm.Decimal" Scale="Variable" />
<Property Name="OtherFees" Type="Edm.Decimal" Scale="Variable" />
<Property Name="Broker" Type="Edm.String" />
<Property Name="WhtSecurityId" Type="Edm.Int32" />
<Property Name="ExecPri" Type="Edm.Decimal" Scale="Variable" />
<Property Name="ExecPriCalc" Type="Edm.Decimal" Scale="Variable" />
<Property Name="Reorg" Type="Edm.Boolean" />
<NavigationProperty Name="Account" Type="Wealthtechs.PAD.Core.Entities.Account">
<ReferentialConstraint Property="AccountId" ReferencedProperty="Id" />
</NavigationProperty>
<NavigationProperty Name="Custodian" Type="Wealthtechs.PAD.Core.Entities.Custodian">
<ReferentialConstraint Property="CustodianId" ReferencedProperty="Id" />
</NavigationProperty>
<NavigationProperty Name="Customer" Type="Wealthtechs.PAD.Core.Entities.Customer">
<ReferentialConstraint Property="CustomerId" ReferencedProperty="Id" />
</NavigationProperty>
<NavigationProperty Name="Security" Type="Wealthtechs.PAD.Core.Entities.Security">
<ReferentialConstraint Property="SecurityId" ReferencedProperty="Id" />
</NavigationProperty>
<NavigationProperty Name="TransactionCode" Type="Wealthtechs.PAD.Core.Entities.TransactionCode">
<ReferentialConstraint Property="TransactionCodeId" ReferencedProperty="Id" />
</NavigationProperty>
<NavigationProperty Name="WhtSecurity" Type="Wealthtechs.PAD.Core.Entities.Security">
<ReferentialConstraint Property="SecurityId" ReferencedProperty="Id" />
</NavigationProperty>
</EntityType>
</Schema>
<Schema Namespace="Default" xmlns="http://docs.oasis-open.org/odata/ns/edm">
<Function Name="GetByCompositeKeys" IsBound="true">
<Parameter Name="bindingParameter" Type="Collection(Wealthtechs.PAD.Core.Entities.Fxrate)" />
<Parameter Name="custodianId" Type="Edm.Int32" Nullable="false" />
<Parameter Name="processDate" Type="Edm.DateTimeOffset" Nullable="false" />
<Parameter Name="baseCurrencyId" Type="Edm.Int32" Nullable="false" />
<Parameter Name="localCurrencyId" Type="Edm.Int32" Nullable="false" />
<ReturnType Type="Wealthtechs.PAD.Core.Entities.Fxrate" />
</Function>
<Function Name="GetByCompositeKeys" IsBound="true">
<Parameter Name="bindingParameter" Type="Collection(Wealthtechs.PAD.Core.Entities.InterfaceStatus)" />
<Parameter Name="custodianId" Type="Edm.Int32" Nullable="false" />
<Parameter Name="customerId" Type="Edm.Int32" Nullable="false" />
<Parameter Name="processDate" Type="Edm.DateTimeOffset" Nullable="false" />
<ReturnType Type="Wealthtechs.PAD.Core.Entities.InterfaceStatus" />
</Function>
<Function Name="GetByCompositeKeys" IsBound="true">
<Parameter Name="bindingParameter" Type="Collection(Wealthtechs.PAD.Core.Entities.Position)" />
<Parameter Name="custodianId" Type="Edm.Int32" Nullable="false" />
<Parameter Name="customerId" Type="Edm.Int32" Nullable="false" />
<Parameter Name="processDate" Type="Edm.DateTimeOffset" Nullable="false" />
<Parameter Name="accountId" Type="Edm.Int32" Nullable="false" />
<Parameter Name="securityId" Type="Edm.Int32" Nullable="false" />
<Parameter Name="custodianId" Type="Edm.Int32" Nullable="false" />
<Parameter Name="processDate" Type="Edm.DateTimeOffset" Nullable="false" />
<Parameter Name="securityId" Type="Edm.Int32" Nullable="false" />
<ReturnType Type="Wealthtechs.PAD.Core.Entities.Position" />
</Function>
<Function Name="GetByCompositeKeys" IsBound="true">
<Parameter Name="bindingParameter" Type="Collection(Wealthtechs.PAD.Core.Entities.Price)" />
<ReturnType Type="Wealthtechs.PAD.Core.Entities.Price" />
</Function>
<Function Name="GetDistinctProcessDates" IsBound="true">
<Parameter Name="bindingParameter" Type="Collection(Wealthtechs.PAD.Core.Entities.Position)" />
<ReturnType Type="Collection(Edm.DateTimeOffset)" Nullable="false" />
</Function>
<Function Name="GetDistinctProcessDates" IsBound="true">
<Parameter Name="bindingParameter" Type="Collection(Wealthtechs.PAD.Core.Entities.Transaction)" />
<ReturnType Type="Collection(Edm.DateTimeOffset)" Nullable="false" />
</Function>
<EntityContainer Name="Container">
<EntitySet Name="Accounts" EntityType="Wealthtechs.PAD.Core.Entities.Account">
<NavigationPropertyBinding Path="Currency" Target="Currencies" />
<NavigationPropertyBinding Path="Custodian" Target="Custodians" />
<NavigationPropertyBinding Path="Customer" Target="Customers" />
<NavigationPropertyBinding Path="TaxLots" Target="TaxLots" />
<NavigationPropertyBinding Path="Transactions" Target="Transactions" />
</EntitySet>
<EntitySet Name="Currencies" EntityType="Wealthtechs.PAD.Core.Entities.Currency">
<NavigationPropertyBinding Path="Accounts" Target="Accounts" />
<NavigationPropertyBinding Path="Securities" Target="Securities" />
</EntitySet>
<EntitySet Name="Custodians" EntityType="Wealthtechs.PAD.Core.Entities.Custodian">
<NavigationPropertyBinding Path="Accounts" Target="Accounts" />
<NavigationPropertyBinding Path="Securities" Target="Securities" />
<NavigationPropertyBinding Path="TaxLots" Target="TaxLots" />
<NavigationPropertyBinding Path="Transactions" Target="Transactions" />
</EntitySet>
<EntitySet Name="Customers" EntityType="Wealthtechs.PAD.Core.Entities.Customer">
<NavigationPropertyBinding Path="Accounts" Target="Accounts" />
<NavigationPropertyBinding Path="TaxLots" Target="TaxLots" />
<NavigationPropertyBinding Path="Transactions" Target="Transactions" />
</EntitySet>
<EntitySet Name="FxRates" EntityType="Wealthtechs.PAD.Core.Entities.Fxrate">
<NavigationPropertyBinding Path="BaseCurrency" Target="Currencies" />
<NavigationPropertyBinding Path="Custodian" Target="Custodians" />
<NavigationPropertyBinding Path="LocalCurrency" Target="Currencies" />
</EntitySet>
<EntitySet Name="InterfaceStatuses" EntityType="Wealthtechs.PAD.Core.Entities.InterfaceStatus">
<NavigationPropertyBinding Path="Status" Target="InterfaceStatusTypes" />
</EntitySet>
<EntitySet Name="InterfaceStatusTypes" EntityType="Wealthtechs.PAD.Core.Entities.InterfaceStatusType" />
<EntitySet Name="MajorAssetClasses" EntityType="Wealthtechs.PAD.Core.Entities.MajorAssetClass">
<NavigationPropertyBinding Path="PrimaryTypeCodeNavigation" Target="PrimaryTypes" />
<NavigationPropertyBinding Path="SecurityTypes" Target="SecurityTypes" />
</EntitySet>
<EntitySet Name="Positions" EntityType="Wealthtechs.PAD.Core.Entities.Position">
<NavigationPropertyBinding Path="Account" Target="Accounts" />
<NavigationPropertyBinding Path="Custodian" Target="Custodians" />
<NavigationPropertyBinding Path="Customer" Target="Customers" />
<NavigationPropertyBinding Path="Security" Target="Securities" />
</EntitySet>
<EntitySet Name="Prices" EntityType="Wealthtechs.PAD.Core.Entities.Price">
<NavigationPropertyBinding Path="Custodian" Target="Custodians" />
<NavigationPropertyBinding Path="Security" Target="Securities" />
</EntitySet>
<EntitySet Name="PrimaryTypes" EntityType="Wealthtechs.PAD.Core.Entities.PrimaryType">
<NavigationPropertyBinding Path="MajorAssetClasses" Target="MajorAssetClasses" />
</EntitySet>
<EntitySet Name="Sectors" EntityType="Wealthtechs.PAD.Core.Entities.Sector">
<NavigationPropertyBinding Path="Securities" Target="Securities" />
</EntitySet>
<EntitySet Name="Securities" EntityType="Wealthtechs.PAD.Core.Entities.Security">
<NavigationPropertyBinding Path="Currency" Target="Currencies" />
<NavigationPropertyBinding Path="Custodian" Target="Custodians" />
<NavigationPropertyBinding Path="Sector" Target="Sectors" />
<NavigationPropertyBinding Path="SecurityType" Target="SecurityTypes" />
<NavigationPropertyBinding Path="TaxLots" Target="TaxLots" />
<NavigationPropertyBinding Path="TransactionSecurities" Target="Transactions" />
<NavigationPropertyBinding Path="TransactionWhtSecurities" Target="Transactions" />
</EntitySet>
<EntitySet Name="SecurityTypes" EntityType="Wealthtechs.PAD.Core.Entities.SecurityType">
<NavigationPropertyBinding Path="MajorAssetClass" Target="MajorAssetClasses" />
<NavigationPropertyBinding Path="Securities" Target="Securities" />
</EntitySet>
<EntitySet Name="TaxLots" EntityType="Wealthtechs.PAD.Core.Entities.TaxLot">
<NavigationPropertyBinding Path="Account" Target="Accounts" />
<NavigationPropertyBinding Path="Custodian" Target="Custodians" />
<NavigationPropertyBinding Path="Customer" Target="Customers" />
<NavigationPropertyBinding Path="Security" Target="Securities" />
</EntitySet>
<EntitySet Name="TransactionCodes" EntityType="Wealthtechs.PAD.Core.Entities.TransactionCode">
<NavigationPropertyBinding Path="Transactions" Target="Transactions" />
</EntitySet>
<EntitySet Name="Transactions" EntityType="Wealthtechs.PAD.Core.Entities.Transaction">
<NavigationPropertyBinding Path="Account" Target="Accounts" />
<NavigationPropertyBinding Path="Custodian" Target="Custodians" />
<NavigationPropertyBinding Path="Customer" Target="Customers" />
<NavigationPropertyBinding Path="Security" Target="Securities" />
<NavigationPropertyBinding Path="TransactionCode" Target="TransactionCodes" />
<NavigationPropertyBinding Path="WhtSecurity" Target="Securities" />
</EntitySet>
<EntitySet Name="Fxrate" EntityType="Wealthtechs.PAD.Core.Entities.Fxrate">
<NavigationPropertyBinding Path="BaseCurrency" Target="Currencies" />
<NavigationPropertyBinding Path="Custodian" Target="Custodians" />
<NavigationPropertyBinding Path="LocalCurrency" Target="Currencies" />
</EntitySet>
<EntitySet Name="InterfaceStatus" EntityType="Wealthtechs.PAD.Core.Entities.InterfaceStatus">
<NavigationPropertyBinding Path="Status" Target="InterfaceStatusTypes" />
</EntitySet>
<EntitySet Name="Position" EntityType="Wealthtechs.PAD.Core.Entities.Position">
<NavigationPropertyBinding Path="Account" Target="Accounts" />
<NavigationPropertyBinding Path="Custodian" Target="Custodians" />
<NavigationPropertyBinding Path="Customer" Target="Customers" />
<NavigationPropertyBinding Path="Security" Target="Securities" />
</EntitySet>
<EntitySet Name="Price" EntityType="Wealthtechs.PAD.Core.Entities.Price">
<NavigationPropertyBinding Path="Custodian" Target="Custodians" />
<NavigationPropertyBinding Path="Security" Target="Securities" />
</EntitySet>
</EntityContainer>
</Schema>
</edmx:DataServices>
</edmx:Edmx>