GetExternalFundBatchOrders only display a single TradeDate and SettlementDate. If you wish to see specific dates for both the cash and instrument leg of the transaction you can select underlying TradeOrders to view InstrumentTradeDate, CashTradeDate, InstrumentSettlementDate, and CashSettlementDate separately.

Filter inputs

Name

Type

Description

Mandatory

Available from version

BrickIds

Guid[]

Filter by array of BrickIds. BrickId is the internal id of an order

States

String[]

Filter orders by states. To find a list with states use the back office GUI and navigate to System Data→Workflows and find the Key with the name ExternalFundBatchOrder

Instruments

Guid[]

Filter by array of InstrumentIds.

ExternalReferences

String[]

Filter by ExternalReferences

OrderNos

String[]

Filter by order numbers

ExecutionInterface

Guid[]

Filter by the BfsId of Execution Interface

ExecutionInterfaceKey

String

Filter by Execution Interface key

CreatedDateFrom

DateTime

When used, both from date and to date should be provided in the request

CreatedDateTo

DateTime

Response rows (Array) inherits from EntityBase

Name

Type

Description

Available from version

BrickId

Guid

The BrickId of the order

CashAmount

Decimal

The amount in cash

InstrumentAmount

Decimal

The amount in units

TradeOrderDirectionKey

String

"Buy" or "Sell"

Instrument

Guid

The associated instrument

Cash

Guid

The associated Cash

Price

Double

The price of the order

State

String

The current state of the order

IsUnitOrder

Bool

True if the order is traded in units

OrderNo

String

The order number of the order

CashTradeDate

DateTime

The date the cash leg of the order was executed

Depreciated in 2.41

InstrumentTradeDate

DateTime

The date the instrument leg of the order was executed

Depreciated in 2.41

CashSettlementDate

DateTime

The date the cash leg of the order was settled

Depreciated in 2.41

InstrumentSettlementDate

DateTime

The date the instrument leg of the order was settled

Depreciated in 2.41

SentDate

DateTime

The date the order was sent to an order route

ExternalReference

String

External reference on the order

ExecutionInterfaceKey

String

The key name of the associated execution interface

2.02

ExecutionInterface

Guid

The BrickId of the execution interface

2.02

CreatedDate

DateTime

The timestamp of when the order was created

2.02

IsPrePayed

Bool

True if the order follows the pre pay order process

2.02

TradeDate

DateTime

The date when the instrument was traded

2.41

SettlementDate

DateTime

The date when the cash was settled

2.41

Code examples

C# - GetExternalFundBatchOrders
 //Use the GetExternalFundBatchOrders method 
var client = new BFSServiceReference.bfsapiSoapClient();

var credentials = new BFSServiceReference.Credentials()
{
    UserName = bfsusername, //Username of administrative user in your instance of BFS
    Password = bfspassword, //Password of the administrative user in your instance of BFS
};

var accounttypes = client.GetExternalFundBatchOrders(new BFSServiceReference.GetExternalFundBatchOrdersRequest()
{
    Credentials = credentials,

    identify = bfsidentifier, //Identifier is a unique token for your instance of BFS  

    Args = new GetExternalFundBatchOrdersArgs()
    {
        BrickIds = new Guid[]
        {
            new Guid("928f5a5a-5abf-45e7-977c-b716f73b7618"),
        }

    },

    Fields = new BFSServiceReference.GetExternalFundBatchOrderFields()
    {
        BrickId = true,
        CashAmount = true,
        InstrumentAmount = true,
        TradeOrderDirectionKey = true,
        Instrument = true,
        Cash = true,
        Price = true,
        State = true,
        IsUnitOrder = true,
        OrderNo = true,
        ExternalReference = true,
        CreatedDate = true,
        ExecutionInterfaceKey = true,
        ExecutionInterface = true,
        IsPrePayed = true,
        SentDate = true,
        SettledAmount = true,
        TradeDate = true,
        SettlementDate = true
    },
});

foreach (var c in accounttypes.Result)
{
    Console.WriteLine(c.BrickId + ","
        + c.CashAmount
        + ","
        + c.InstrumentAmount
        + ","
        + c.TradeOrderDirectionKey
        + ","
        + c.Instrument
        + ","
        + c.Cash
        + ","
        + c.Price
        + ","
        + c.State
        + ","
        + c.IsUnitOrder
        + ","
        + c.OrderNo
        + ","
        + c.TradeDate
        + ","
        + c.SettlementDate
        + ","
        + c.ExternalReference
        + ","
        + c.CreatedDate
        + ","
        + c.ExecutionInterfaceKey
        + ","
        + c.ExecutionInterface
        + ","
        + c.IsPrePayed
        + ","
        + c.SentDate
        + ","
        + c.SettledAmount
        );
}