Source Extract Accounts Details Data Block

The Source Extract Accounts Details (Source_ExtractAccountsDetails) Data Block must be edited by the client.

Source Extract Accounts Details (Source_ExtractAccountsDetails) is a Transform Data Block used to extract data related to the account master from client’s source data (e.g., Snowflake). This Data Block is expected to be edited by the client and therefore the name and output is subject to change.

General Info #

The following table shows the default fields of the Data Block.

Field	Value
Name	Source_ExtractAccountsDetails
Block Category	Interface
Block Type	Snowflake Database Call
Data Type	None
Output Type	Data Table

Columns #

The following columns are the default columns for the Data Object, all columns are optional unless marked otherwise. Please see footnotes for additional information.

Field Name	Description
PORTFOLIOCODE*	Unique product code identifier (e.g., “ACCT1”)
NAME	Name of the account (e.g., “Assette Capital Holdings”)
INVESTMENTSTYLE	Investment style of the account (e.g., “Growth”)
PORTFOLIOCATEGORY*1	Indicates the account’s category. Must be any one of the following values: – “Individual Account” – “Consolidated” – “Group” – “Composite”
OPENDATE	Account open date (e.g., “2024-03-31”)
PERFORMANCEINCEPTIONDATE	Performance inception date of the account
PERFORMANCETERMINATIONDATE	Performance termination date of the account
BASECURRENCYCODE	Currency code for the account’s base currency (e.g., “USD”)
BASECURRENCYNAME	Currency name for the account’s base currency (e.g., “U.S. Dollar”)
PRODUCTCODE*	Unique product code (e.g., “PRODUCT1”)

Example Definition #

{
    "type": "table",
    "sql": "SELECT PORTFOLIOCODE,NAME,INVESTMENTSTYLE,PORTFOLIOCATEGORY,OPENDATE,PERFORMANCEINCEPTIONDATE,TERMINATIONDATE,BASECURRENCYCODE,BASECURRENCYNAME,PRODUCTCODE FROM DEMO_DB.DBO.PORTFOLIOGENERALINFORMATION",
    "parameters": []
}

Example Request #

The Extract Accounts Details (Source_ExtractAccountsDetails) Interface Data Block should return a value with “{}” as the test parameters.

{}

Example Response #

The following example output has been truncated for brevity.

{
    "data": [
        {
            "AccountID": "123",
            "Name": "ABC11",
            "Code": "1106",
            "Category": "Individual Account",
            "CurrencyCode": null,
            "Associated": null,
            "Manager": null,
            "StrategyName": "Diversified Large Cap Value",
            "ServiceTier": null,
            "ProductID": null,
            "ProductCode": null,
            "AssetClassName": null,
            "AssetClassCode": null,
            "ClientType": null,
            "FiscalYear": null,
            "UserDefine": null,
            "UserDefinedAttribute": null,
            "Strategy": "588",
            "Vehicle": null,
            "Country": "us"
        },
        {
            "AccountID": "456",
            "Name": "ABC12",
            "Code": "1107",
            "Category": "Individual Account",
            "CurrencyCode": null,
            "Associated": null,
            "Manager": null,
            "StrategyName": "Diversified Large Cap Value",
            "ServiceTier": null,
            "ProductID": null,
            "ProductCode": null,
            "AssetClassName": null,
            "AssetClassCode": null,
            "ClientType": null,
            "FiscalYear": null,
            "UserDefine": null,
            "UserDefinedAttribute": null,
            "Strategy": "588",
            "Vehicle": null,
            "Country": "cn"
        }
    ],
    "errors": [],
    "success": true,
    "logs": []
}