Investor Transactions

transactions

GET

/{externalId}/transactions

Returns all the transactions data for an Investor available in the SEI system.
Prod:
https://api.seic.com/v1/investors/{externalId}/transactions
Query Parameters
Name Description Data Type Required
fundExternalId

Unique business identifier that represents a fund entity recognized by SEI and a third party system or application. Many times the externalId is used to synchronize SEI sourced data with another data source for the same record.

string

startDate

The earliest date within a range in ISO 8601 format YYYY-MM-DD.

string

endDate

The earliest date within a range in ISO 8601 format YYYY-MM-DD.

string

typeId

SEI Accounting system generated identifier for the Transaction Type of the transaction.

string

excludeUnallocated

Valid values are true or false. If true is passed the result set will exclude any unallocated transactions associated with the fund. If false or this parameter is not passed unalloacted transactions are included in the response. Unallocated transactions have an investorExternalId as '-1'.

string

limit

Number of records per page. Many responses have a maximum of 50 records per page.

string

Header Parameters
Name Description Data Type Required
Authorization

access_token value obtained from the Token endpoint.This is passed as "Bearer access_token"

string

AppKey

This is the Consumer Key provided during the App Registration process and is used to identify the user's application.

string

category

This parameter defines the business line the data belongs to. Valid value is CEF.

string

Path Parameters
Name Description Data Type Required
externalId

Unique business identifier that represents an investor entity recognized by SEI and a third party system or application. Many times the externalId is used to synchronize SEI sourced data with another data source for the same record.

string

HTTP Responses
  • Code
    Description
  • 200

    OK- The request has succeeded and the response has been returned.

  • 400

    Bad request - The server cannot or will not process the request due to an inaccurate request submitted by the client application. Please resubmit the request after making the required corrections indicated in the error response. For more Info on SEI Error Standards please refer to the API Standards FAQ under Support.

  • 401

    Unauthorized - Invalid authentication details have been provided. Also useful to trigger an authorization pop up if the API is used from a browser.

  • 403

    Forbidden-The SEI Server understood the request but refuses to fulfill it.

  • 404

    Not Found- The requested resource or the underlying resource does not exist. Please resubmit the request after making the required corrections

  • 500

    Internal Server Error - The server was unable to fulfill the request due to an unknown condition. Please contact SEI for support. For More Info please refer to the "Response & Errors" FAQ under support.

TEST ENDPOINT
fundExternalId

Unique business identifier that represents a fund entity recognized by SEI and a third party system or application. Many times the externalId is used to synchronize SEI sourced data with another data source for the same record.

startDate

The earliest date within a range in ISO 8601 format YYYY-MM-DD.

endDate

The earliest date within a range in ISO 8601 format YYYY-MM-DD.

typeId

SEI Accounting system generated identifier for the Transaction Type of the transaction.

excludeUnallocated

Valid values are true or false. If true is passed the result set will exclude any unallocated transactions associated with the fund. If false or this parameter is not passed unalloacted transactions are included in the response. Unallocated transactions have an investorExternalId as '-1'.

limit

Number of records per page. Many responses have a maximum of 50 records per page.

Authorization

access_token value obtained from the Token endpoint.This is passed as "Bearer access_token"

AppKey

This is the Consumer Key provided during the App Registration process and is used to identify the user's application.

category

This parameter defines the business line the data belongs to. Valid value is CEF.

Request Body

externalId Unique business identifier that represents an investor entity recognized by SEI and a third party system or application. Many times the externalId is used to synchronize SEI sourced data with another data source for the same record. null true

HTTP Basic

OAuth 2.0

API Key

Working...

Investor Transactions

transactions

GET

/{externalId}/transactions

Returns all the transactions data for an Investor available in the SEI system.
Prod:
https://api.seic.com/v1/investors/{externalId}/transactions
Query Parameters
Name Description Data Type Required
fundExternalId

Unique business identifier that represents a fund entity recognized by SEI and a third party system or application. Many times the externalId is used to synchronize SEI sourced data with another data source for the same record.

string

startDate

The earliest date within a range in ISO 8601 format YYYY-MM-DD.

string

endDate

The earliest date within a range in ISO 8601 format YYYY-MM-DD.

string

typeId

SEI Accounting system generated identifier for the Transaction Type of the transaction.

string

excludeUnallocated

Valid values are true or false. If true is passed the result set will exclude any unallocated transactions associated with the fund. If false or this parameter is not passed unalloacted transactions are included in the response. Unallocated transactions have an investorExternalId as '-1'.

string

limit

Number of records per page. Many responses have a maximum of 50 records per page.

string

Header Parameters
Name Description Data Type Required
Authorization

access_token value obtained from the Token endpoint.This is passed as "Bearer access_token"

string

AppKey

This is the Consumer Key provided during the App Registration process and is used to identify the user's application.

string

category

This parameter defines the business line the data belongs to. Valid value is CEF.

string

Path Parameters
Name Description Data Type Required
externalId

Unique business identifier that represents an investor entity recognized by SEI and a third party system or application. Many times the externalId is used to synchronize SEI sourced data with another data source for the same record.

string

HTTP Responses
  • Code
    Description
  • 200

    OK- The request has succeeded and the response has been returned.

  • 400

    Bad request - The server cannot or will not process the request due to an inaccurate request submitted by the client application. Please resubmit the request after making the required corrections indicated in the error response. For more Info on SEI Error Standards please refer to the API Standards FAQ under Support.

  • 401

    Unauthorized - Invalid authentication details have been provided. Also useful to trigger an authorization pop up if the API is used from a browser.

  • 403

    Forbidden-The SEI Server understood the request but refuses to fulfill it.

  • 404

    Not Found- The requested resource or the underlying resource does not exist. Please resubmit the request after making the required corrections

  • 500

    Internal Server Error - The server was unable to fulfill the request due to an unknown condition. Please contact SEI for support. For More Info please refer to the "Response & Errors" FAQ under support.

TEST ENDPOINT
fundExternalId

Unique business identifier that represents a fund entity recognized by SEI and a third party system or application. Many times the externalId is used to synchronize SEI sourced data with another data source for the same record.

startDate

The earliest date within a range in ISO 8601 format YYYY-MM-DD.

endDate

The earliest date within a range in ISO 8601 format YYYY-MM-DD.

typeId

SEI Accounting system generated identifier for the Transaction Type of the transaction.

excludeUnallocated

Valid values are true or false. If true is passed the result set will exclude any unallocated transactions associated with the fund. If false or this parameter is not passed unalloacted transactions are included in the response. Unallocated transactions have an investorExternalId as '-1'.

limit

Number of records per page. Many responses have a maximum of 50 records per page.

Authorization

access_token value obtained from the Token endpoint.This is passed as "Bearer access_token"

AppKey

This is the Consumer Key provided during the App Registration process and is used to identify the user's application.

category

This parameter defines the business line the data belongs to. Valid value is CEF.

Request Body

externalId Unique business identifier that represents an investor entity recognized by SEI and a third party system or application. Many times the externalId is used to synchronize SEI sourced data with another data source for the same record. null true

HTTP Basic

OAuth 2.0

API Key

Working...

Test: https://test.api.seic.com/v1/investors/{externalId}/transactions
TLS*: https://mtls.api.seic.com/v1/investors/{externalId}/transactions
*The TLS endpoint is only used if Server Based Application was selected during the App Registration process.
Step 2

Pass the oAuth Token and the App key to invoke this endpoint for a particular application.

Investor Transactions

transactions

GET

/{externalId}/transactions

Returns all the transactions data for an Investor available in the SEI system.
Prod:
https://api.seic.com/v1/investors/{externalId}/transactions
Query Parameters
Name Description Data Type Required
fundExternalId

Unique business identifier that represents a fund entity recognized by SEI and a third party system or application. Many times the externalId is used to synchronize SEI sourced data with another data source for the same record.

string

startDate

The earliest date within a range in ISO 8601 format YYYY-MM-DD.

string

endDate

The earliest date within a range in ISO 8601 format YYYY-MM-DD.

string

typeId

SEI Accounting system generated identifier for the Transaction Type of the transaction.

string

excludeUnallocated

Valid values are true or false. If true is passed the result set will exclude any unallocated transactions associated with the fund. If false or this parameter is not passed unalloacted transactions are included in the response. Unallocated transactions have an investorExternalId as '-1'.

string

limit

Number of records per page. Many responses have a maximum of 50 records per page.

string

Header Parameters
Name Description Data Type Required
Authorization

access_token value obtained from the Token endpoint.This is passed as "Bearer access_token"

string

AppKey

This is the Consumer Key provided during the App Registration process and is used to identify the user's application.

string

category

This parameter defines the business line the data belongs to. Valid value is CEF.

string

Path Parameters
Name Description Data Type Required
externalId

Unique business identifier that represents an investor entity recognized by SEI and a third party system or application. Many times the externalId is used to synchronize SEI sourced data with another data source for the same record.

string

HTTP Responses
  • Code
    Description
  • 200

    OK- The request has succeeded and the response has been returned.

  • 400

    Bad request - The server cannot or will not process the request due to an inaccurate request submitted by the client application. Please resubmit the request after making the required corrections indicated in the error response. For more Info on SEI Error Standards please refer to the API Standards FAQ under Support.

  • 401

    Unauthorized - Invalid authentication details have been provided. Also useful to trigger an authorization pop up if the API is used from a browser.

  • 403

    Forbidden-The SEI Server understood the request but refuses to fulfill it.

  • 404

    Not Found- The requested resource or the underlying resource does not exist. Please resubmit the request after making the required corrections

  • 500

    Internal Server Error - The server was unable to fulfill the request due to an unknown condition. Please contact SEI for support. For More Info please refer to the "Response & Errors" FAQ under support.

TEST ENDPOINT
fundExternalId

Unique business identifier that represents a fund entity recognized by SEI and a third party system or application. Many times the externalId is used to synchronize SEI sourced data with another data source for the same record.

startDate

The earliest date within a range in ISO 8601 format YYYY-MM-DD.

endDate

The earliest date within a range in ISO 8601 format YYYY-MM-DD.

typeId

SEI Accounting system generated identifier for the Transaction Type of the transaction.

excludeUnallocated

Valid values are true or false. If true is passed the result set will exclude any unallocated transactions associated with the fund. If false or this parameter is not passed unalloacted transactions are included in the response. Unallocated transactions have an investorExternalId as '-1'.

limit

Number of records per page. Many responses have a maximum of 50 records per page.

Authorization

access_token value obtained from the Token endpoint.This is passed as "Bearer access_token"

AppKey

This is the Consumer Key provided during the App Registration process and is used to identify the user's application.

category

This parameter defines the business line the data belongs to. Valid value is CEF.

Request Body

externalId Unique business identifier that represents an investor entity recognized by SEI and a third party system or application. Many times the externalId is used to synchronize SEI sourced data with another data source for the same record. null true

HTTP Basic

OAuth 2.0

API Key

Working...

SAMPLE REQUEST

curl -X GET \
https://api.seic.com/v1/investors/{externalId}/transactions \
  -H 'appkey: gsedgaerhDSHGRSH' \
  -H 'authorization: Bearer ADsgdnnkjnfdIKJN' \
  -H 'category: cef' \


REQUEST HEADER

Authorization: Bearer ADsgdnnkjnfdIKJN 
AppKey: gsedgaerhDSHGRSH
Category: cef
RESPONSE HEADER

Content-Type: application/json 
Status: 200 OK 
requesttrackingid: 67e1ff68-164f-03ad-0f2d-5cbbfda56ec9


SAMPLE RESPONSE

{
	"data": [{
		"startDate": "2015-01-01T00:00:00",
		"endDate": "2015-12-31T00:00:00",
		"investor": {
			"externalId": "1234",
			"investorCommonId": 1234,
			"investorSpecificId": 12345,
			"investorName": "Fund A"
		},
		"fundCurrencyIsocode": "USD",
		"subFundName": "Fund B",
		"subFundId": 3434,
		"subFundSpecificId": 5353,
		"fundExternalId": "1234",
		"fundId": 3434,
		"lotId": null,
		"lotName": null,
		"portfolioDealId": 1234,
		"portfolioPositionsId": null,
		"position": "Unallocated",
		"allocationRule": "User Provided",
		"allocationRuleId": 3,
		"accountType": "assets",
		"id": 1234,
		"currencyIsoCode": "USD",
		"type": "Investor Commitments",
		"typeId": 1234,
		"index": 3,
		"journalEntryType": "N/A",
		"journalEntryIndex": 1,
		"glAccount": "Gl account name",
		"glDate": "2015-12-31T00:00:00",
		"glRef": null,
		"debits": 0,
		"credits": 10000,
		"amount": 10000,
		"debitsLocal": 0,
		"creditsLocal": 10000,
		"amountLocal": 10000,
		"effectiveDate": "2015-12-31T00:00:00",
		"quantity": 0,
		"lastModifiedDate": "2015-10-27T09:48:42.437",
		"comments": null,
		"batch": {
			"id": 1727836,
			"processId": 0,
			"lastModifiedDate": "2015-10-27T09:48:42.437",
			"createdDate": "2015-10-27T09:48:42.437",
			"postedDate": null,
			"status": "Held",
			"type": "General",
			"transactionComments": "XYZ expenses"
		},
		"userDefined": {
			"lookUp1": null,
			"lookUp2": null,
			"lookUp3": null,
			"lookUp4": null,
			"lookUp5": null,
			"id1": null,
			"id2": null,
			"text1": null,
			"text2": null,
			"date1": null
		}
	}],
	"paging": {
		"totalCount": 5953,
		"limit": 1,
		"first": "https://api.seic.com/v1/investors/9480/transactions?firmId=9999&startDate=2015-01-01&endDate=2015-12-31&fundExternalId=WWCIDVII&before=MQ==&after=MjU=",
		"last": "https://api.seic.com/v1/investors/9480/transactions?firmId=9999&startDate=2015-01-01&endDate=2015-12-31&fundExternalId=WWCIDVII&before=NTk1MQ==&after=NTk3NQ==",
		"previous": null,
		"next": "https://api.seic.com/v1/investors/9480/transactions?firmId=9999&startDate=2015-01-01&endDate=2015-12-31&fundExternalId=WWCIDVII&before=MjY=&after=NTA=",
		"self": "https://api.seic.com/v1/investors/9480/transactions?firmId=9999&startDate=2015-01-01&endDate=2015-12-31&fundExternalId=WWCIDVII"
	}
}
MODEL
Operations
Name Description Data Type (L)
startDate

The earliest date within a range in ISO 8601 format YYYY-MM-DD.

boolean
endDate

A schedule is created to automate the run of a report over time. The end date is the last date for when the schedule will run.

string
investor

Indicates the external investor ID related to the contact relationship.

object
externalId

Unique business identifier that represents a contact, investor, product, transaction or alternate entity recognized by SEI and a third party system or application.  Many times the externalId is used to synchronize SEI sourced data with another data source for the same record.

string
investorCommonId

SEI Accounting system generated identifier for the Investor on a global level

investorSpecificId

SEI Accounting system generated identifier for the investor and its relationship to a specific Fund

string
investorName

Investor full legal name as indicated on the subscription document.

string
fundCurrencyIsoCode

The standard curency code of the fund.

string
subFundName

The name of the subFund (vehicle).

string
subFundId The SEI code that identifies a sub fund (vehicle) uniquely. string
subFundSpecificId

SEI Accounting system generated identifier for the subFund (vehicle) and its relationship to a specific Fund

string
FundExternalId

Unique business identifier that represents a contact, investor, product, transaction or alternate entity recognized by SEI and a third party system or application.  Many times the externalId is used to synchronize SEI sourced data with another data source for the same record.

string
fundId

The SEI code that identifies a fund uniquely.

string
portfolioDealId

SEI Accounting system generated identifier that identifies the link between Fund and the Deal

string
portfolioPositionsId

SEI Accounting system generated identifier that identifies the link between Fund, Deal and Position

string
position

Concatenated string representing the Issuer and Security in the Deal

string
accountType

Identifies the type of GL Account as: Assets, Liabilities, Capital, Revenue, Expenses, Tax, Financial Top Side

string
currencyIsoCode

The currency code in which the transaction is paid in.

string
type

Transaction Types are the basic unit for recording transactions in SEI Accounting system and identifying the specfic purpose of the debit or credit being booked.

string
typeId

SEI Accounting system generated identifier for the Transaction Type of the transaction

string
index

Transaction Index

number
journalEntryType

References the Type of Journal Entry Template that was used to create the Batch

string
glAccount

Identifies the General Ledger Account the amount in the transaction is related to as a concatenated string of the Account Number and Account Name

string
glDate

Date of recognition indicating accounting period that the transaction is in, new activity is limited to dates in open periods.

string
debits

This returns only debits in absolute value at the fund or investor level depending on the fund Currency for the transaction

string
credits

This returns only credits in absolute value at the fund or investor level depending on the fund Currency

string
debitsLocal

This column returns only debits in absolute value at the fund or investor level depending on Currency for the transaction

string
creditsLocal

This column returns only credits in absolute value at the fund or investor level depending on Currency for the transaction

string
amountLocal

This column returns debits as positive numbers and credits negative numbers at the fund or investor level depending on the Currency for the transaction

string
effectiveDate

Date on which something becomes or was instituted within the context of the API in ISO 8601 UTC format.

string
quantity

The current face amount, or quantity of shares held, for an investment or noted on a transaction.

number
lastModifiedDate Transaction level SEI Accounting system generated value representing the last changed date and time stamp string
comments

Description of the business purpose of the transaction, free text field limited to 255 characters, can be unique for each row in a batch

string
processId

The unique identifier of the batch processing the transaction

string
status

Defines the status for a specific pending transaction, such as 'Active' or 'Cancel'.

string(30)
transactionComments

Description of the business purpose of the batch, free text field limited to 255 characters, limited to one description per batch

string
lookUp

Transaction level user defined field (lookup) that stores a value as defined by each client explicitly typically representing a bank account number, vendor, counterparty, etc.

string
id1 Contact SEI to understand if this field is applicable to you and if yes what value it is returning. The object consists of user defined fields configured in SEI Accounting System as per discussions during client data conversion phase string
id2 Contact SEI to understand if this field is applicable to you and if yes what value it is returning. The object consists of user defined fields configured in SEI Accounting System as per discussions during client data conversion phase string
text1 Contact SEI to understand if this field is applicable to you and if yes what value it is returning. The object consists of user defined fields configured in SEI Accounting System as per discussions during client data conversion phase string
text2 Contact SEI to understand if this field is applicable to you and if yes what value it is returning. The object consists of user defined fields configured in SEI Accounting System as per discussions during client data conversion phase string
date1 Contact SEI to understand if this field is applicable to you and if yes what value it is returning. The object consists of user defined fields configured in SEI Accounting System as per discussions during client data conversion phase string
id

Insight unique product system identifier.

string
amount

This column returns debits as positive numbers and credits negative numbers at the fund or investor level depending on the fund Currency for the transaction

string(19)
Batch System generated ID for a grouping of Journal Entries which contain a group of Transactions. Batches are for single GL Date for account string
glRef The GL reference of the batch. Used as separate reference and can be any text reference to the General Ledger typically used for separately sourced transactions that are not manually entered. string
allocationRule The name of the rule used to allocate the General Ledger transaction to the Investor. string
allocationRuleId The system generated ID of the Allocation Rule name. string
postedDate The Date when the Batch status and included transactions were approved and changed to Posted status. string
lotName The tax lot name. string
lotId Lot Name is the system generated ID of the tax lot name. string
journalEntryIndex System generated index of the journal entry within a batch. Values include 1,2,3 and represent the sequence assigned to Journal Entries within a batch. string
createdDate Initial create timestamp for the record. Datetime is Eastern Standard Time (EST). string


Investor Transactions

transactions

GET

/{externalId}/transactions

Returns all the transactions data for an Investor available in the SEI system.
Prod:
https://api.seic.com/v1/investors/{externalId}/transactions
Query Parameters
Name Description Data Type Required
fundExternalId

Unique business identifier that represents a fund entity recognized by SEI and a third party system or application. Many times the externalId is used to synchronize SEI sourced data with another data source for the same record.

string

startDate

The earliest date within a range in ISO 8601 format YYYY-MM-DD.

string

endDate

The earliest date within a range in ISO 8601 format YYYY-MM-DD.

string

typeId

SEI Accounting system generated identifier for the Transaction Type of the transaction.

string

excludeUnallocated

Valid values are true or false. If true is passed the result set will exclude any unallocated transactions associated with the fund. If false or this parameter is not passed unalloacted transactions are included in the response. Unallocated transactions have an investorExternalId as '-1'.

string

limit

Number of records per page. Many responses have a maximum of 50 records per page.

string

Header Parameters
Name Description Data Type Required
Authorization

access_token value obtained from the Token endpoint.This is passed as "Bearer access_token"

string

AppKey

This is the Consumer Key provided during the App Registration process and is used to identify the user's application.

string

category

This parameter defines the business line the data belongs to. Valid value is CEF.

string

Path Parameters
Name Description Data Type Required
externalId

Unique business identifier that represents an investor entity recognized by SEI and a third party system or application. Many times the externalId is used to synchronize SEI sourced data with another data source for the same record.

string

HTTP Responses
  • Code
    Description
  • 200

    OK- The request has succeeded and the response has been returned.

  • 400

    Bad request - The server cannot or will not process the request due to an inaccurate request submitted by the client application. Please resubmit the request after making the required corrections indicated in the error response. For more Info on SEI Error Standards please refer to the API Standards FAQ under Support.

  • 401

    Unauthorized - Invalid authentication details have been provided. Also useful to trigger an authorization pop up if the API is used from a browser.

  • 403

    Forbidden-The SEI Server understood the request but refuses to fulfill it.

  • 404

    Not Found- The requested resource or the underlying resource does not exist. Please resubmit the request after making the required corrections

  • 500

    Internal Server Error - The server was unable to fulfill the request due to an unknown condition. Please contact SEI for support. For More Info please refer to the "Response & Errors" FAQ under support.

TEST ENDPOINT
fundExternalId

Unique business identifier that represents a fund entity recognized by SEI and a third party system or application. Many times the externalId is used to synchronize SEI sourced data with another data source for the same record.

startDate

The earliest date within a range in ISO 8601 format YYYY-MM-DD.

endDate

The earliest date within a range in ISO 8601 format YYYY-MM-DD.

typeId

SEI Accounting system generated identifier for the Transaction Type of the transaction.

excludeUnallocated

Valid values are true or false. If true is passed the result set will exclude any unallocated transactions associated with the fund. If false or this parameter is not passed unalloacted transactions are included in the response. Unallocated transactions have an investorExternalId as '-1'.

limit

Number of records per page. Many responses have a maximum of 50 records per page.

Authorization

access_token value obtained from the Token endpoint.This is passed as "Bearer access_token"

AppKey

This is the Consumer Key provided during the App Registration process and is used to identify the user's application.

category

This parameter defines the business line the data belongs to. Valid value is CEF.

Request Body

externalId Unique business identifier that represents an investor entity recognized by SEI and a third party system or application. Many times the externalId is used to synchronize SEI sourced data with another data source for the same record. null true

HTTP Basic

OAuth 2.0

API Key

Working...

Investor Transactions

transactions

GET

/{externalId}/transactions

Returns all the transactions data for an Investor available in the SEI system.
Prod:
https://api.seic.com/v1/investors/{externalId}/transactions
Query Parameters
Name Description Data Type Required
fundExternalId

Unique business identifier that represents a fund entity recognized by SEI and a third party system or application. Many times the externalId is used to synchronize SEI sourced data with another data source for the same record.

string

startDate

The earliest date within a range in ISO 8601 format YYYY-MM-DD.

string

endDate

The earliest date within a range in ISO 8601 format YYYY-MM-DD.

string

typeId

SEI Accounting system generated identifier for the Transaction Type of the transaction.

string

excludeUnallocated

Valid values are true or false. If true is passed the result set will exclude any unallocated transactions associated with the fund. If false or this parameter is not passed unalloacted transactions are included in the response. Unallocated transactions have an investorExternalId as '-1'.

string

limit

Number of records per page. Many responses have a maximum of 50 records per page.

string

Header Parameters
Name Description Data Type Required
Authorization

access_token value obtained from the Token endpoint.This is passed as "Bearer access_token"

string

AppKey

This is the Consumer Key provided during the App Registration process and is used to identify the user's application.

string

category

This parameter defines the business line the data belongs to. Valid value is CEF.

string

Path Parameters
Name Description Data Type Required
externalId

Unique business identifier that represents an investor entity recognized by SEI and a third party system or application. Many times the externalId is used to synchronize SEI sourced data with another data source for the same record.

string

HTTP Responses
  • Code
    Description
  • 200

    OK- The request has succeeded and the response has been returned.

  • 400

    Bad request - The server cannot or will not process the request due to an inaccurate request submitted by the client application. Please resubmit the request after making the required corrections indicated in the error response. For more Info on SEI Error Standards please refer to the API Standards FAQ under Support.

  • 401

    Unauthorized - Invalid authentication details have been provided. Also useful to trigger an authorization pop up if the API is used from a browser.

  • 403

    Forbidden-The SEI Server understood the request but refuses to fulfill it.

  • 404

    Not Found- The requested resource or the underlying resource does not exist. Please resubmit the request after making the required corrections

  • 500

    Internal Server Error - The server was unable to fulfill the request due to an unknown condition. Please contact SEI for support. For More Info please refer to the "Response & Errors" FAQ under support.

TEST ENDPOINT
fundExternalId

Unique business identifier that represents a fund entity recognized by SEI and a third party system or application. Many times the externalId is used to synchronize SEI sourced data with another data source for the same record.

startDate

The earliest date within a range in ISO 8601 format YYYY-MM-DD.

endDate

The earliest date within a range in ISO 8601 format YYYY-MM-DD.

typeId

SEI Accounting system generated identifier for the Transaction Type of the transaction.

excludeUnallocated

Valid values are true or false. If true is passed the result set will exclude any unallocated transactions associated with the fund. If false or this parameter is not passed unalloacted transactions are included in the response. Unallocated transactions have an investorExternalId as '-1'.

limit

Number of records per page. Many responses have a maximum of 50 records per page.

Authorization

access_token value obtained from the Token endpoint.This is passed as "Bearer access_token"

AppKey

This is the Consumer Key provided during the App Registration process and is used to identify the user's application.

category

This parameter defines the business line the data belongs to. Valid value is CEF.

Request Body

externalId Unique business identifier that represents an investor entity recognized by SEI and a third party system or application. Many times the externalId is used to synchronize SEI sourced data with another data source for the same record. null true

HTTP Basic

OAuth 2.0

API Key

Working...

Test: https://test.api.seic.com/v1/investors/{externalId}/transactions
TLS*: https://mtls.api.seic.com/v1/investors/{externalId}/transactions
*The TLS endpoint is only used if Server Based Application was selected during the App Registration process.
STEP 1



Step 2

Pass the oAuth Token and the App key to invoke this endpoint for a particular application.

Investor Transactions

transactions

GET

/{externalId}/transactions

Returns all the transactions data for an Investor available in the SEI system.
Prod:
https://api.seic.com/v1/investors/{externalId}/transactions
Query Parameters
Name Description Data Type Required
fundExternalId

Unique business identifier that represents a fund entity recognized by SEI and a third party system or application. Many times the externalId is used to synchronize SEI sourced data with another data source for the same record.

string

startDate

The earliest date within a range in ISO 8601 format YYYY-MM-DD.

string

endDate

The earliest date within a range in ISO 8601 format YYYY-MM-DD.

string

typeId

SEI Accounting system generated identifier for the Transaction Type of the transaction.

string

excludeUnallocated

Valid values are true or false. If true is passed the result set will exclude any unallocated transactions associated with the fund. If false or this parameter is not passed unalloacted transactions are included in the response. Unallocated transactions have an investorExternalId as '-1'.

string

limit

Number of records per page. Many responses have a maximum of 50 records per page.

string

Header Parameters
Name Description Data Type Required
Authorization

access_token value obtained from the Token endpoint.This is passed as "Bearer access_token"

string

AppKey

This is the Consumer Key provided during the App Registration process and is used to identify the user's application.

string

category

This parameter defines the business line the data belongs to. Valid value is CEF.

string

Path Parameters
Name Description Data Type Required
externalId

Unique business identifier that represents an investor entity recognized by SEI and a third party system or application. Many times the externalId is used to synchronize SEI sourced data with another data source for the same record.

string

HTTP Responses
  • Code
    Description
  • 200

    OK- The request has succeeded and the response has been returned.

  • 400

    Bad request - The server cannot or will not process the request due to an inaccurate request submitted by the client application. Please resubmit the request after making the required corrections indicated in the error response. For more Info on SEI Error Standards please refer to the API Standards FAQ under Support.

  • 401

    Unauthorized - Invalid authentication details have been provided. Also useful to trigger an authorization pop up if the API is used from a browser.

  • 403

    Forbidden-The SEI Server understood the request but refuses to fulfill it.

  • 404

    Not Found- The requested resource or the underlying resource does not exist. Please resubmit the request after making the required corrections

  • 500

    Internal Server Error - The server was unable to fulfill the request due to an unknown condition. Please contact SEI for support. For More Info please refer to the "Response & Errors" FAQ under support.

TEST ENDPOINT
fundExternalId

Unique business identifier that represents a fund entity recognized by SEI and a third party system or application. Many times the externalId is used to synchronize SEI sourced data with another data source for the same record.

startDate

The earliest date within a range in ISO 8601 format YYYY-MM-DD.

endDate

The earliest date within a range in ISO 8601 format YYYY-MM-DD.

typeId

SEI Accounting system generated identifier for the Transaction Type of the transaction.

excludeUnallocated

Valid values are true or false. If true is passed the result set will exclude any unallocated transactions associated with the fund. If false or this parameter is not passed unalloacted transactions are included in the response. Unallocated transactions have an investorExternalId as '-1'.

limit

Number of records per page. Many responses have a maximum of 50 records per page.

Authorization

access_token value obtained from the Token endpoint.This is passed as "Bearer access_token"

AppKey

This is the Consumer Key provided during the App Registration process and is used to identify the user's application.

category

This parameter defines the business line the data belongs to. Valid value is CEF.

Request Body

externalId Unique business identifier that represents an investor entity recognized by SEI and a third party system or application. Many times the externalId is used to synchronize SEI sourced data with another data source for the same record. null true

HTTP Basic

OAuth 2.0

API Key

Working...

SAMPLE REQUEST

curl -X GET \
https://api.seic.com/v1/investors/{externalId}/transactions \
  -H 'appkey: gsedgaerhDSHGRSH' \
  -H 'authorization: Bearer ADsgdnnkjnfdIKJN' \
  -H 'category: cef' \


REQUEST HEADER

Authorization: Bearer ADsgdnnkjnfdIKJN 
AppKey: gsedgaerhDSHGRSH
Category: cef
RESPONSE HEADER

Content-Type: application/json 
Status: 200 OK 
requesttrackingid: 67e1ff68-164f-03ad-0f2d-5cbbfda56ec9


SAMPLE RESPONSE

{
	"data": [{
		"startDate": "2015-01-01T00:00:00",
		"endDate": "2015-12-31T00:00:00",
		"investor": {
			"externalId": "1234",
			"investorCommonId": 1234,
			"investorSpecificId": 12345,
			"investorName": "Fund A"
		},
		"fundCurrencyIsocode": "USD",
		"subFundName": "Fund B",
		"subFundId": 3434,
		"subFundSpecificId": 5353,
		"fundExternalId": "1234",
		"fundId": 3434,
		"lotId": null,
		"lotName": null,
		"portfolioDealId": 1234,
		"portfolioPositionsId": null,
		"position": "Unallocated",
		"allocationRule": "User Provided",
		"allocationRuleId": 3,
		"accountType": "assets",
		"id": 1234,
		"currencyIsoCode": "USD",
		"type": "Investor Commitments",
		"typeId": 1234,
		"index": 3,
		"journalEntryType": "N/A",
		"journalEntryIndex": 1,
		"glAccount": "Gl account name",
		"glDate": "2015-12-31T00:00:00",
		"glRef": null,
		"debits": 0,
		"credits": 10000,
		"amount": 10000,
		"debitsLocal": 0,
		"creditsLocal": 10000,
		"amountLocal": 10000,
		"effectiveDate": "2015-12-31T00:00:00",
		"quantity": 0,
		"lastModifiedDate": "2015-10-27T09:48:42.437",
		"comments": null,
		"batch": {
			"id": 1727836,
			"processId": 0,
			"lastModifiedDate": "2015-10-27T09:48:42.437",
			"createdDate": "2015-10-27T09:48:42.437",
			"postedDate": null,
			"status": "Held",
			"type": "General",
			"transactionComments": "XYZ expenses"
		},
		"userDefined": {
			"lookUp1": null,
			"lookUp2": null,
			"lookUp3": null,
			"lookUp4": null,
			"lookUp5": null,
			"id1": null,
			"id2": null,
			"text1": null,
			"text2": null,
			"date1": null
		}
	}],
	"paging": {
		"totalCount": 5953,
		"limit": 1,
		"first": "https://api.seic.com/v1/investors/9480/transactions?firmId=9999&startDate=2015-01-01&endDate=2015-12-31&fundExternalId=WWCIDVII&before=MQ==&after=MjU=",
		"last": "https://api.seic.com/v1/investors/9480/transactions?firmId=9999&startDate=2015-01-01&endDate=2015-12-31&fundExternalId=WWCIDVII&before=NTk1MQ==&after=NTk3NQ==",
		"previous": null,
		"next": "https://api.seic.com/v1/investors/9480/transactions?firmId=9999&startDate=2015-01-01&endDate=2015-12-31&fundExternalId=WWCIDVII&before=MjY=&after=NTA=",
		"self": "https://api.seic.com/v1/investors/9480/transactions?firmId=9999&startDate=2015-01-01&endDate=2015-12-31&fundExternalId=WWCIDVII"
	}
}
MODEL
Operations
Name Description Data Type (L)
startDate

The earliest date within a range in ISO 8601 format YYYY-MM-DD.

boolean
endDate

A schedule is created to automate the run of a report over time. The end date is the last date for when the schedule will run.

string
investor

Indicates the external investor ID related to the contact relationship.

object
externalId

Unique business identifier that represents a contact, investor, product, transaction or alternate entity recognized by SEI and a third party system or application.  Many times the externalId is used to synchronize SEI sourced data with another data source for the same record.

string
investorCommonId

SEI Accounting system generated identifier for the Investor on a global level

investorSpecificId

SEI Accounting system generated identifier for the investor and its relationship to a specific Fund

string
investorName

Investor full legal name as indicated on the subscription document.

string
fundCurrencyIsoCode

The standard curency code of the fund.

string
subFundName

The name of the subFund (vehicle).

string
subFundId The SEI code that identifies a sub fund (vehicle) uniquely. string
subFundSpecificId

SEI Accounting system generated identifier for the subFund (vehicle) and its relationship to a specific Fund

string
FundExternalId

Unique business identifier that represents a contact, investor, product, transaction or alternate entity recognized by SEI and a third party system or application.  Many times the externalId is used to synchronize SEI sourced data with another data source for the same record.

string
fundId

The SEI code that identifies a fund uniquely.

string
portfolioDealId

SEI Accounting system generated identifier that identifies the link between Fund and the Deal

string
portfolioPositionsId

SEI Accounting system generated identifier that identifies the link between Fund, Deal and Position

string
position

Concatenated string representing the Issuer and Security in the Deal

string
accountType

Identifies the type of GL Account as: Assets, Liabilities, Capital, Revenue, Expenses, Tax, Financial Top Side

string
currencyIsoCode

The currency code in which the transaction is paid in.

string
type

Transaction Types are the basic unit for recording transactions in SEI Accounting system and identifying the specfic purpose of the debit or credit being booked.

string
typeId

SEI Accounting system generated identifier for the Transaction Type of the transaction

string
index

Transaction Index

number
journalEntryType

References the Type of Journal Entry Template that was used to create the Batch

string
glAccount

Identifies the General Ledger Account the amount in the transaction is related to as a concatenated string of the Account Number and Account Name

string
glDate

Date of recognition indicating accounting period that the transaction is in, new activity is limited to dates in open periods.

string
debits

This returns only debits in absolute value at the fund or investor level depending on the fund Currency for the transaction

string
credits

This returns only credits in absolute value at the fund or investor level depending on the fund Currency

string
debitsLocal

This column returns only debits in absolute value at the fund or investor level depending on Currency for the transaction

string
creditsLocal

This column returns only credits in absolute value at the fund or investor level depending on Currency for the transaction

string
amountLocal

This column returns debits as positive numbers and credits negative numbers at the fund or investor level depending on the Currency for the transaction

string
effectiveDate

Date on which something becomes or was instituted within the context of the API in ISO 8601 UTC format.

string
quantity

The current face amount, or quantity of shares held, for an investment or noted on a transaction.

number
lastModifiedDate Transaction level SEI Accounting system generated value representing the last changed date and time stamp string
comments

Description of the business purpose of the transaction, free text field limited to 255 characters, can be unique for each row in a batch

string
processId

The unique identifier of the batch processing the transaction

string
status

Defines the status for a specific pending transaction, such as 'Active' or 'Cancel'.

string(30)
transactionComments

Description of the business purpose of the batch, free text field limited to 255 characters, limited to one description per batch

string
lookUp

Transaction level user defined field (lookup) that stores a value as defined by each client explicitly typically representing a bank account number, vendor, counterparty, etc.

string
id1 Contact SEI to understand if this field is applicable to you and if yes what value it is returning. The object consists of user defined fields configured in SEI Accounting System as per discussions during client data conversion phase string
id2 Contact SEI to understand if this field is applicable to you and if yes what value it is returning. The object consists of user defined fields configured in SEI Accounting System as per discussions during client data conversion phase string
text1 Contact SEI to understand if this field is applicable to you and if yes what value it is returning. The object consists of user defined fields configured in SEI Accounting System as per discussions during client data conversion phase string
text2 Contact SEI to understand if this field is applicable to you and if yes what value it is returning. The object consists of user defined fields configured in SEI Accounting System as per discussions during client data conversion phase string
date1 Contact SEI to understand if this field is applicable to you and if yes what value it is returning. The object consists of user defined fields configured in SEI Accounting System as per discussions during client data conversion phase string
id

Insight unique product system identifier.

string
amount

This column returns debits as positive numbers and credits negative numbers at the fund or investor level depending on the fund Currency for the transaction

string(19)
Batch System generated ID for a grouping of Journal Entries which contain a group of Transactions. Batches are for single GL Date for account string
glRef The GL reference of the batch. Used as separate reference and can be any text reference to the General Ledger typically used for separately sourced transactions that are not manually entered. string
allocationRule The name of the rule used to allocate the General Ledger transaction to the Investor. string
allocationRuleId The system generated ID of the Allocation Rule name. string
postedDate The Date when the Batch status and included transactions were approved and changed to Posted status. string
lotName The tax lot name. string
lotId Lot Name is the system generated ID of the tax lot name. string
journalEntryIndex System generated index of the journal entry within a batch. Values include 1,2,3 and represent the sequence assigned to Journal Entries within a batch. string
createdDate Initial create timestamp for the record. Datetime is Eastern Standard Time (EST). string


Investor Transactions

transactions

GET

/{externalId}/transactions

Returns all the transactions data for an Investor available in the SEI system.
Prod:
https://api.seic.com/v1/investors/{externalId}/transactions
Query Parameters
Name Description Data Type Required
fundExternalId

Unique business identifier that represents a fund entity recognized by SEI and a third party system or application. Many times the externalId is used to synchronize SEI sourced data with another data source for the same record.

string

startDate

The earliest date within a range in ISO 8601 format YYYY-MM-DD.

string

endDate

The earliest date within a range in ISO 8601 format YYYY-MM-DD.

string

typeId

SEI Accounting system generated identifier for the Transaction Type of the transaction.

string

excludeUnallocated

Valid values are true or false. If true is passed the result set will exclude any unallocated transactions associated with the fund. If false or this parameter is not passed unalloacted transactions are included in the response. Unallocated transactions have an investorExternalId as '-1'.

string

limit

Number of records per page. Many responses have a maximum of 50 records per page.

string

Header Parameters
Name Description Data Type Required
Authorization

access_token value obtained from the Token endpoint.This is passed as "Bearer access_token"

string

AppKey

This is the Consumer Key provided during the App Registration process and is used to identify the user's application.

string

category

This parameter defines the business line the data belongs to. Valid value is CEF.

string

Path Parameters
Name Description Data Type Required
externalId

Unique business identifier that represents an investor entity recognized by SEI and a third party system or application. Many times the externalId is used to synchronize SEI sourced data with another data source for the same record.

string

HTTP Responses
  • Code
    Description
  • 200

    OK- The request has succeeded and the response has been returned.

  • 400

    Bad request - The server cannot or will not process the request due to an inaccurate request submitted by the client application. Please resubmit the request after making the required corrections indicated in the error response. For more Info on SEI Error Standards please refer to the API Standards FAQ under Support.

  • 401

    Unauthorized - Invalid authentication details have been provided. Also useful to trigger an authorization pop up if the API is used from a browser.

  • 403

    Forbidden-The SEI Server understood the request but refuses to fulfill it.

  • 404

    Not Found- The requested resource or the underlying resource does not exist. Please resubmit the request after making the required corrections

  • 500

    Internal Server Error - The server was unable to fulfill the request due to an unknown condition. Please contact SEI for support. For More Info please refer to the "Response & Errors" FAQ under support.

TEST ENDPOINT
fundExternalId

Unique business identifier that represents a fund entity recognized by SEI and a third party system or application. Many times the externalId is used to synchronize SEI sourced data with another data source for the same record.

startDate

The earliest date within a range in ISO 8601 format YYYY-MM-DD.

endDate

The earliest date within a range in ISO 8601 format YYYY-MM-DD.

typeId

SEI Accounting system generated identifier for the Transaction Type of the transaction.

excludeUnallocated

Valid values are true or false. If true is passed the result set will exclude any unallocated transactions associated with the fund. If false or this parameter is not passed unalloacted transactions are included in the response. Unallocated transactions have an investorExternalId as '-1'.

limit

Number of records per page. Many responses have a maximum of 50 records per page.

Authorization

access_token value obtained from the Token endpoint.This is passed as "Bearer access_token"

AppKey

This is the Consumer Key provided during the App Registration process and is used to identify the user's application.

category

This parameter defines the business line the data belongs to. Valid value is CEF.

Request Body

externalId Unique business identifier that represents an investor entity recognized by SEI and a third party system or application. Many times the externalId is used to synchronize SEI sourced data with another data source for the same record. null true

HTTP Basic

OAuth 2.0

API Key

Working...