# Transactions

## Fetch transactions

> The \`transactions\` endpoint returns all transactions, per published entity date. If a transaction falls on a date which has no positions, it will be be available once a position on that date or a subsequent date is published

```json
{"openapi":"3.1.0","info":{"title":"gateway-api","version":"0.0.1"},"servers":[{"url":"https://data.api.landytech.net","description":"Generated server url"}],"security":[{"basicAuth":[]}],"paths":{"/api/v2/transactions/{entityId}":{"get":{"tags":["transactions"],"summary":"Fetch transactions","description":"The `transactions` endpoint returns all transactions, per published entity date. If a transaction falls on a date which has no positions, it will be be available once a position on that date or a subsequent date is published","operationId":"getTransactions","parameters":[{"name":"X-Result-Limit","in":"header","description":"Maximum number of items to retrieve","required":false,"schema":{"type":"integer","format":"int32"}},{"name":"fields","in":"query","description":"List of field names to retrieve. If empty, all fields will be returned.","required":false,"schema":{"type":"array","items":{"type":"string"}}},{"name":"entityId","in":"path","description":"Unique identifier provided by Landytech","required":true,"schema":{"type":"integer","format":"int64"}},{"name":"fromDate","in":"query","description":"Start of transaction date range (inclusive)","required":false,"schema":{"type":"string","format":"date"}},{"name":"toDate","in":"query","description":"End of transaction date range (inclusive)","required":false,"schema":{"type":"string","format":"date"}},{"name":"consolidationType","in":"query","description":"DIRECT returns the entity's directly held assets. LOOK_THROUGH includes transactions of underlying entities linked through configured look-through relationships. If not provided, DIRECT is used","required":false,"schema":{"type":"string"}},{"name":"fromUpdatedDate","in":"query","description":"Return only records that have been updated on or after the specified date time","required":false,"schema":{"type":"string"}}],"responses":{"200":{"description":"List of transactions with selected fields","content":{"application/json":{"schema":{"$ref":"#/components/schemas/TransactionResponse"}}}},"401":{"description":"Unauthorized, missing or invalid authentication"},"403":{"description":"Forbidden, user does not have permission"}}}}},"components":{"schemas":{"TransactionResponse":{"type":"object","description":"Transaction data returned by the API","properties":{"content":{"$ref":"#/components/schemas/TransactionDetails","description":"Transaction details"}}},"TransactionDetails":{"type":"object","description":"Transaction details returned by the API","properties":{"ENTITY.ID":{"type":"integer","format":"int64","description":"Unique identifier of the entity the request was made for. This identifier is created by Sesame"},"ENTITY.NAME":{"type":"string","description":"Name of the entity the request was made for"},"ASSET.NAME":{"type":"string","description":"Name of the investment being transacted"},"ASSET.ID":{"type":"integer","format":"int64","description":"ID of the investment being transacted. This identifier is created by Sesame"},"ASSET.TYPE":{"type":"string","description":"Type of the investment being transacted"},"TRANSACTION.SUBTYPE":{"type":"string","description":"Subtype of the transaction. For a full list of supported subtypes, see the list in `FAQ and Troubleshooting`"},"TRANSACTION.CUSTODIAN_TRANSACTION_ID":{"type":"string","description":"Unique identifier of the transaction, as provided in the custodial feed. When not provided by the custodian, a unique transaction Id is generated by Sesame"},"TRANSACTION.DESCRIPTION":{"type":"string","description":"Description of the transaction, as provided in the custodial feed. When not provided by the custodian, a description is generated by Sesame"},"TRANSACTION.DATE":{"type":"string","format":"date","description":"Date of the transaction."},"TRANSACTION.SETTLEMENT_DATE":{"type":"string","format":"date","description":"Settlement date of the transaction."},"TRANSACTION.MOVEMENT_LOCAL":{"type":"number","description":"Net transaction value, in local currency"},"TRANSACTION.GROSS_MOVEMENT_LOCAL":{"type":"number","description":"Gross transaction value, in local currency"},"TRANSACTION.QUANTITY":{"type":"number","description":"Units of the investment transacted"},"TRANSACTION.NET_UNIT_PRICE_LOCAL":{"type":"number","description":"Net unit price of the transaction, in local currency"},"TRANSACTION.GROSS_UNIT_PRICE_LOCAL":{"type":"number","description":"Gross unit price of the transaction, in local currency"},"TRANSACTION.LOCAL_CURRENCY":{"type":"string","description":"Currency that the transaction is denominated in"},"TRANSACTION.LOCAL_CURRENCY2":{"type":"string","description":"The local currency of the incoming cash where the transaction is an internal FX transaction"},"TRANSACTION.MOVEMENT_REPORTING":{"type":"number","description":"Net transaction value, in reporting currency"},"TRANSACTION.GROSS_MOVEMENT_REPORTING":{"type":"number","description":"Gross transaction value, in reporting currency"},"TRANSACTION.SUB_PORTFOLIO_CODE":{"type":"string","description":"A string providing further granularity about the sub-account involved in the transaction. This could be a bank account number which differs per currency, or nature (capital/income), within the main account. The main account or portfolio identifier is shown in the PORTFOLIO_CODES field in the `entities` endpoint"},"TRANSACTION.SUB_PORTFOLIO_CODE2":{"type":"string","description":"A string providing further granularity about the second account involved in the transaction. This is required for internal FX transactions. In this case, the subPortfolioCode2 represents the sub-account that the incoming cash is received into. The main account or portfolio identifier is shown in the PORTFOLIO_CODES field in the `entities` endpoint"},"TRANSACTION.CAPITAL_OR_INCOME":{"type":"string","description":"A string indicating whether the transaction is in-to or out-of a CAPITAL, INCOME or MIXED account"},"TRANSACTION.GRANULARITY":{"$ref":"#/components/schemas/TransactionGranularityDetails","description":"Granularity of the transaction."},"TRANSACTION.PRIVATE_FUND_GRANULARITY":{"$ref":"#/components/schemas/PrivateFundGranularityDetails","description":"Private fund granularity of the transaction."},"TRANSACTION.REVERSAL":{"type":"boolean","description":"A boolean indicating whether this transaction is reversing a previous transaction"},"TRANSACTION.CUSTODIAN_REVERSED_TRANSACTION_ID":{"type":"string","description":"Where available, the CUSTODIAN_TRANSACTION_ID of the transaction which this transaction is reversing. Only seen for transactions where reversal = `true`. This field helps users connect reversal transactions and the transactions that they are reversing"},"TRANSACTION.UPDATED_DATE":{"type":"string","format":"date-time","description":"Last updated date of the transaction."}},"required":["ASSET.ID","ASSET.NAME","ASSET.TYPE","ENTITY.ID","ENTITY.NAME","TRANSACTION.CUSTODIAN_TRANSACTION_ID","TRANSACTION.DATE","TRANSACTION.DESCRIPTION","TRANSACTION.LOCAL_CURRENCY","TRANSACTION.MOVEMENT_LOCAL","TRANSACTION.QUANTITY","TRANSACTION.REVERSAL","TRANSACTION.SUBTYPE"]},"TransactionGranularityDetails":{"type":"object","description":"A breakdown of the difference between MOVEMENT_LOCAL and GROSS_MOVEMENT_LOCAL","properties":{"COMMISSIONS_LOCAL":{"type":"integer","format":"int64","description":"Value of commissions associated with the transaction, in local currency"},"STAMP_DUTY_LOCAL":{"type":"integer","format":"int64","description":"Value of stamp duties associated with the transaction, in local currency"},"WITHHOLDING_TAX_LOCAL":{"type":"integer","format":"int64","description":"Value of withholdings tax associated with the transaction, in local currency"},"COLLECTION_CHARGE_LOCAL":{"type":"integer","format":"int64","description":"Value of collection charges associated with the transaction, in local currency"},"TAX_LOCAL":{"type":"integer","format":"int64","description":"Value of taxes, duties associated with the transaction, in local currency"},"ACCRUED_INTEREST_LOCAL":{"type":"integer","format":"int64","description":"The value of the accrued interest when a fixed income investment is transacted, in local currency"}}},"PrivateFundGranularityDetails":{"type":"object","description":"Provides a breakdown of MOVEMENT_LOCAL for Capital Calls, Distributions and Equalisations","properties":{"PE_DEDUCTIBLE":{"type":"integer","format":"int64","description":"The portion of a capital call which reduces the remaining commitment or the portion of an equalisation which increases the remaining commitment, in local currency"},"PE_NON_DEDUCTIBLE":{"type":"integer","format":"int64","description":"The portion of a capital call which does not reduce the remaining commitment or the portion of an equalisation which does not increase the remaining commitment, in local currency"},"PE_INVESTMENT":{"type":"integer","format":"int64","description":"The portion of a capital call which goes towards purchasing portfolio companies or the portion of an equalisation which refunds for amounts previously paid towards purchasing portfolio companies, in local currency"},"PE_MANAGEMENT_FEES":{"type":"integer","format":"int64","description":"The portion of a capital call which is used for covering management fees or the portion an equalisation representing the pro-rata rebate for previously paid management fees, in local currency"},"PE_FUND_EXPENSES":{"type":"integer","format":"int64","description":"The portion of a capital call which is used for covering fund expenses or the portion of an equalisation representing the pro-rata rebate for previously paid fund expenses, in local currency"},"PE_OTHER_FEES":{"type":"integer","format":"int64","description":"The portion of a capital call which is used for covering other fund fees or the portion an equalisation representing the pro-rata rebate for previously paid other fund fees, in local currency"},"PE_EQUALISATION":{"type":"integer","format":"int64","description":"The portion of a capital call which is a catch-up equalisation payment or the portion of an equalisation which is received following catch-up equalisation by other investors, where above granularity is not provided, in local currency"},"PE_RECALLABLE":{"type":"integer","format":"int64","description":"The portion of the distribution that is recallable, in local currency"},"PE_NON_RECALLABLE":{"type":"integer","format":"int64","description":"The portion of the distribution that is non-recallable, in local currency"},"PE_CAPITAL_RETURN":{"type":"integer","format":"int64","description":"The portion of the distribution that represents a return of capital to the LP, in local currency"},"PE_CAPITAL_GAIN":{"type":"integer","format":"int64","description":"The portion of the distribution that is a capital gain (this can be negative, indicating a capital loss), in local currency"},"PE_INCOME":{"type":"integer","format":"int64","description":"The portion of the distribution that represents income, in local currency"}}}}}}
```