1.9.5 Policy Transaction Settlement Related Information
This topic provides information on policy transaction settlement related information.
Serial Number: 4
Segment Identification Number: 03SET
Description: This segment is used for providing Policy Transaction Settlement Related Information.
Attributes: Optional
Table 1-69 Policy Transaction Settlement Related Information
| Field Name (as expected in the file) | Data type | Length | Attributes | Characteristics/rules | Values |
|---|---|---|---|---|---|
| SEGMENTID | VARCHAR2 | 20 | Mandatory | - | Segment ID - 03SET |
| SEQUENCENUMBER | NUMBER | 10 | Mandatory | - | Sequence Number |
| PROCESSID | VARCHAR2 | 50 | Mandatory | - | Process ID |
| POLICYTXNNUMBER | VARCHAR2 | 16 | Mandatory | - | Policy Transaction Number |
| IMPORTFILENAME | VARCHAR2 | 255 | Mandatory | - | Import File Name |
| UPLOADMODE | VARCHAR2 | 1 | Mandatory | - | Upload Mode |
| AMCID | VARCHAR2 | 12 | Mandatory | - | AMC ID |
| POLICYTXNNUMBER | VARCHAR2 | 16 | Mandatory | - | Policy Transaction Number |
| PAYMENTTYPE | VARCHAR2 | 1 | Optional | - | Payment Type:
|
| PAYMENTMODE | VARCHAR2 | 1 | Optional | - | Payment Mode:
|
| PAYMENTENTITY | VARCHAR2 | 12 | Optional | - | Payment Entity |
| DRAWEEBANKCODE | VARCHAR2 | 12 | Optional | - | Drawee Bank code |
| TRANSFERBRANCHCODE | VARCHAR2 | 12 | Optional | - | Transfer Branch Code |
| TRANSFERACCOUNTTYPE | VARCHAR2 | 1 | Optional | - | Transfer Account Type |
| TRANSFERACCOUNTNUMBER | VARCHAR2 | 20 | Optional | - | Transfer Account Number |
| TRANSFERACCOUNTCURRENCY | VARCHAR2 | 3 | Optional | - | Transfer Account Currency |
| CHEQUENUMBER | VARCHAR2 | 16 | Optional | - | Cheque Number |
| CHEQUEDATE | VARCHAR2 | 11 | Optional | - | Cheque Date |
| CLEARINGDATE | VARCHAR2 | 11 | Optional | - | Clearing Date |
| CLEARINGSTATUS | VARCHAR2 | 3 | Optional | - | Clearing Status |
| RATIO | NUMBER | 5 | Optional | - | Ratio |
| AUTH_STAT | VARCHAR2 | 1 | Mandatory | - | Authorization Status:
|
| IDENTIFICATIONNUMBER | VARCHAR2 | 50 | Mandatory | - | Identification Number |
| CONTACTNAME | VARCHAR2 | 100 | Optional | - | Branch Code |
| ADDRESSLINE1 | VARCHAR2 | 105 | Mandatory | - | Address Line 1 |
| ADDRESSLINE2 | VARCHAR2 | 105 | Mandatory | - | Address Line 2 |
| TRANSFERREFNUMBER | VARCHAR2 | 16 | Optional | - | Transfer Reference Number |
| IBAN | VARCHAR2 | 40 | Optional | - | International Bank Account Number |
| FXDEALDATE | DATE | 7 | Optional | - | FX Deal Date |
| FXVALUEDATE | DATE | 7 | Optional | - | FX Value Date |
| EXCHANGERATEAPPLIED | NUMBER | 15 | Optional | - | Exchange Rate Applied |
| OVERRIDEEXCHANGERATE | VARCHAR2 | 1 | Optional | - | Override Exchange Rate |
| SOURCEID | VARCHAR2 | 6 | Optional | - | Source ID |
| PAYMENT_CURRENCY | VARCHAR2 | 3 | Optional | - | Payment Currency |
| PAYMENT_DATE | DATE | 7 | Optional | - | Payment Date |
| PAYMENT_AMOUNT | NUMBER | 30 | Optional | - | Payment amount |
| EXCHANGERATESTATUS | VARCHAR2 | 1 | Optional | - | Exchange Rate Status |
| INTERESTRATE | NUMBER | 30 | Optional | - | Interest Rate |
| INTERESTAMOUNT | NUMBER | 30 | Optional | - | Interest Amount |
| NOOFDAYS | NUMBER | 30 | Optional | - | No of Days |
| BASISDAYS | NUMBER | 30 | Optional | - | Basis days |
| PAYMENT_ AMT_IN_TXNCCY | NUMBER | 30 | Optional | - | Payment amount in Transaction currency |
| INTEREST_ AMT_IN_TXNCCY | NUMBER | 30 | Optional | - | Interest Amount in Transaction currency |
| SEQ_NO | NUMBER | 30 | Optional | - | Sequence Number |
| TRANSFERACCOUNTHOLDERNAME | VARCHAR2 | 100 | Optional | - | Transfer Account holder Name |
Parent topic: Policy Transaction Upload Format