3.8.1.1 Derive Transaction Date

This topic provides the instructions to derive the Transaction Date.

Transaction Date will be derived based on the Order received Date, Order Received Time Zone and Order Received Time. If order received time is within fund cutoff (converting time from Order Received Time Zone to Fund Time Zone), then transaction date arrives to same as order received date. If order received time breaches the fund cutoff, then transaction date arrives to next business date.

It is better understood by the below example:

Table 3-30 Example on Fund details

Fund Details Case 1 Case 2 Case 3
Fund ID FNSGP1 - -
Fund Time Zone SGT - -
Fund Cut Off 17:30 - -
Module Default Time Zone HKT - -
Time Zone UKT HKT SGT
GMT+ 00:00:00 08:00:00 08:00:00

Table 3-31 Example on Order Received details before and after Cut Off time

Order Received within Cut off time Order Received within Cut off time Order Received Post Cut off time Order Received Post Cut off time
Fund ID FNSGP1 Fund ID FNSGP1
Order Received Date 2-Jan-15 Order Received Date 2-Jan-15
Order Received Time Zone UKT Order Received Time Zone UKT
Order Received Time 9:15 Order Received Time 9:45
Transaction Date arrives to 2-Jan-15 Transaction Date arrives to 5-Jan-15

Table 3-32 Examples on Transaction Date Derivation

Transaction Details Transaction Date Derivation
Notice Period 5 days
Trade Cut Off Applicable No
Calendar basis Actual
Transaction Type 02

Table 3-33 Example of Transaction Date Derivation based on Captured Transaction Date

Capture Transaction Date Application Date Cut Off Transaction Date/ Override Transaction Date ORD ORT Derived Transaction Date
Pre-Settle Trade 07-Jan- 2015 12:00 07-Jan- 2015 07-Jan- 2015 15:00 12-Jan- 2015
Future Date 07-Jan- 2015 12:00 09-Jan- 2015 07-Jan- 2015 15:00 09-Jan- 2015
Back Date 07-Jan- 2015 12:00 06-Jan- 2015 07-Jan- 2015 15:00 06-Jan- 2015
Application Date 07-Jan- 2015 12:00 07-Jan- 2015 - - 07-Jan- 2015

Note:

  • For the Pre-settled trade, system will arrive at the transaction date as Order Received Date + Notice period for the transaction.
  • If ORT is after fund cut-off then, cut-off will be ignored and system will simply take ORD + NOTICE PERIOD to arrive at transaction date.
  • If transaction date is overridden, system will derive the new settlement due date based on new price date.
  • If derived transaction date is holiday, then next working date will be considered as transaction date.
  • System generated transaction will not be considered for deriving transaction date and settlement due date for pre-settled funds.