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.
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.
Parent topic: Process FCIS Subscription Transaction Detail