1.9.4 Information Related to Transaction Fund Ratio
This topic provides information on information related to transaction fund ratio.
Serial Number: 3
Segment Identification Number: 02FDR
Description: This segment is used for providing information related to transaction fund ratio that is to be uploaded into the system.
Attributes: Mandatory
Table 1-68 Information Related to Transaction Fund Ratio
| Field Name (as expected in the file) | Data type | Length | Attributes | Characteristics/rules | Values |
|---|---|---|---|---|---|
| SEGMENTID | VARCHAR2 | 20 | Mandatory | - | Segment ID - 02FDR |
| SEQUENCENUMBER | NUMBER | 10 | Mandatory | - | Sequence Number |
| PROCESSID | VARCHAR2 | 50 | Mandatory | - | Process ID |
| POLICYTXNNUMBER | VARCHAR2 | 16 | Mandatory | - | Policy Transaction Number |
| FUNDID | VARCHAR2 | 6 | Mandatory | - | Fund ID |
| RATIO | NUMBER | 15 | Optional | - | Ratio |
| TXNAMOUNT | NUMBER | 15 | Mandatory | - | Transaction Amount |
| UNITSAPPLIED | NUMBER | 15 | Optional | - | Units Applied |
| WAC | NUMBER | 15 | Optional | - | Weighted Average Cost |
| AUTOCLEARPROVISIONALBALANCE | VARCHAR2 | 1 | Mandatory | - | Auto Clear Provisional balance |
| AUTOCLEARREINVESTMENTS | VARCHAR2 | 1 | Mandatory | - | Auto Clear Reinvestments |
| TXNAMOUNT _IN_TXNCCY | NUMBER | 30 | Optional | - | Transaction Amount in Transaction Currency |
| TRANSACTIONCURRENCY | VARCHAR2 | 3 | Optional | - | Transaction Currency |
| EXCHANGERATEAPPLIED | NUMBER | 15 | Optional | - | Exchange Rate Applied |
| OVERRIDEEXCHANGERATE | VARCHAR2 | 1 | Optional | - | Override Exchange Rate |
| SOURCEID | VARCHAR2 | 6 | Optional | - | Source ID |
| FXDEALDATE | DATE | 7 | Optional | - | FX Deal Date |
| FXVALUEDATE | DATE | 7 | Optional | - | FX Value Date |
Parent topic: Policy Transaction Upload Format