1.10.3 Transaction Settlement Related Information
This topic provides information on transaction settlement related information.
Serial Number: 2
Segment Identification Number: 01SET
Description: This segment is used for providing Transaction Settlement Related Information.
Attributes: Mandatory
Table 1-75 Transaction Settlement Related Information
| Field Name (as expected in the file) | Data type | Mandatory | Description |
|---|---|---|---|
| SEGMENTID | VARCHAR2(5) | Yes | Segment Identifier(01SET) |
| TXNSERIALNUMBER | NUMBER(10) | Yes | Transaction Serial Number |
| SEQUENCENUMBER | NUMBER(10) | Yes | Sequence Number |
| PROCESSID | VARCHAR2(50) | Yes | Process ID |
| BULKCLIENTCODE | VARCHAR2(12) | Yes | Bulk Client Code |
| IMPORTFILENAME | VARCHAR2(255) | Yes | Import File Name |
| AMCID | VARCHAR2(12) | Yes | AMC ID |
| TRANSACTIONNUMBER | VARCHAR2(16) | No | Transaction Number |
| PRODUCTID | VARCHAR2(10) | No | Product ID |
| POLICYNUMBER | VARCHAR2(16) | No | Policy Number |
| SYSREFERENCENUMBER | VARCHAR2(25) | No | Sys Reference Number |
| UNITHOLDERID | VARCHAR2(12) | Yes | Unit holder ID |
| PAYMENTREFERENCENUMBER | VARCHAR2(50) | No | Payment Reference Number |
| PAYMENTMODE | VARCHAR2(2) | No | Payment Mode:
|
| SUBPAYMENTMODE | VARCHAR2(2) | No | Sub-Payment Mode:
|
| PAYMENTCURRENCY | VARCHAR2(3) | No | Payment Currency |
| PAYMENTDATE | DATE | No | Payment Date |
| PAYMENTAMOUNT | NUMBER(30,12) | No | Payment Amount |
| BANKCHARGES | NUMBER(30,12) | No | Bank Charges |
| PAYMENTCHARGES | NUMBER(30,12) | No | Payment Charges |
| EXCHANGERATESOURCE | VARCHAR2(6) | No | Exchange Rate Source |
| EXCHANGERATE | NUMBER(15,9) | No | FX Rate |
| PAYMENTFBCTXNAMOUNT | NUMBER(30,12) | No | FBC Amount |
| PAYMENTALTERNATEAMOUNT | NUMBER(30,12) | No | Payment Alternate Amount |
| SETTLEMENTDUEDATE | DATE | No | Settlement Due Date |
| PAIDDATE | DATE | No | Paid Date |
| SETTLEMENTDUEDATE | DATE | No | Settlement Due Date |
| PAIDDATE | DATE | No | Paid Date |
| AUTOSETTLEMENT | NUMBER(1) | No | Auto Settle:
|
| PAYMENTSTATUS | VARCHAR2(1) | No | Payment Status |
| CLEARINGSTATUS | VARCHAR2(5) | No | Clearing Status |
| PAID | NUMBER(1) | No | Paid |
| SETTLEMENTMETHOD | VARCHAR2(5) | No | Settlement Method |
| SETTLEMENTSTATUS | VARCHAR2(2) | No | Settlement Status |
| SETTLEMENTAT | VARCHAR2(3) | No | Settlement At |
| CHEQUEDATE | DATE | No | Cheque Date |
| CHEQUENUMBER | VARCHAR2(16) | No | Cheque Number |
| CHEQUECURRENCY | VARCHAR2(3) | No | Cheque Currency |
| CHEQUEAMOUNT | NUMBER(30,12) | No | Cheque Amount |
| DRAWEEBANKCODE | VARCHAR2(12) | No | Drawee Bank Code |
| DRAWEEBRANCHNAME | VARCHAR2(20) | No | Drawee Branch Name |
| PAYMENTREMARKS | VARCHAR2(255) | No | Payment Remarks |
| PAYMENTTYPE | VARCHAR2(2) | No | Payment Type:
|
| THIRDPARTYADDRESS | VARCHAR2(255) | No | Third Party Address |
| THIRDPARTYADDRESSLINE1 | VARCHAR2(80) | Yes | Third Party Address line 1 |
| THIRDPARTYADDRESSLINE2 | VARCHAR2(80) | Yes | Third Party Address line 2 |
| THIRDPARTYADDRESSLINE3 | VARCHAR2(80) | Yes | Third Party Address line 3 |
| THIRDPARTYADDRESSLINE4 | VARCHAR2(80) | Yes | Third Party Address line 4 |
| THIRDPARTYBICCODE | VARCHAR2(12) | No | Third Party BIC Code |
| THIRDPARTYCOUNTRYCODE | VARCHAR2(3) | No | Third Party Country |
| THIRDPARTYPAYMENTREFERENCE | VARCHAR2(255) | No | Third Party Reference |
| THIRDPARTYSTATE | VARCHAR2(20) | No | Third Party State |
| THIRDPARTYUSSTATE | NUMBER(1) | No | Third Party US State |
| THIRDPARTYZIPCODE | VARCHAR2(10) | No | Third Party Zip Code |
| TRANSFERACCOUNTCURRENCY | VARCHAR2(3) | No | Transfer Account Currency |
| TRANSFERACCOUNTHOLDERNAME | VARCHAR2(100) | No | Transfer Account Holder Name |
| TRANSFERACCOUNTNUMBER | VARCHAR2(34) | No | Transfer Account Number |
| TRANSFERACCOUNTTYPE | VARCHAR2(1) | Yes | Transfer Account Type |
| TRANSFERBRANCHCODE | VARCHAR2(12) | No | Transfer Branch Code |
| TRANSFERREFERENCENUMBER | VARCHAR2(20) | No | Transfer Reference Number |
| CREDITCARDREFNO | VARCHAR2(16) | No | Credit Card Reference Number |
| INKINDPAYMENTDETAILS | VARCHAR2(255) | No | In Kind Payment Details |
| PAYMENTADDRESSDETAILS | VARCHAR2(255) | No | Payment Address Details |
| OLDPAYMENTREFERENCENO | VARCHAR2(25) | No | Old Payment Reference Number |
| UHBICCODE | VARCHAR2(24) | No | UH BIC Code |
| SWIFTFORMAT | VARCHAR2(6) | No | Swift Format:
|
| BANKCHARGED | VARCHAR2(12) | No | Bank Charged:
|
| BENEFICIARY | VARCHAR2(35) | No | Beneficiary |
| BENEFICIARYADD1 | VARCHAR2(105) | Yes | Beneficiary Address1 |
| BENEFICIARYADD2 | VARCHAR2(105) | Yes | Beneficiary Address2 |
| BENEFICIARYADD3 | VARCHAR2(105) | Yes | Beneficiary Address3 |
| BENEFICIARYBICCODE | VARCHAR2(24) | No | Beneficiary BIC Code |
| BENEFICIARYACCTNO | VARCHAR2(34) | No | Beneficiary Account Number |
| BENEFICIARYCODE | VARCHAR2(24) | No | Beneficiary Code |
| BENEFICIARYINFO | VARCHAR2(100) | No | Beneficiary Information |
| INTERMEDIARY | VARCHAR2(35) | No | Intermediary |
| INTERMEDIARYADD1 | VARCHAR2(35) | No | Intermediary Address1 |
| INTERMEDIARYADD2 | VARCHAR2(35) | No | Intermediary Address2 |
| INTERMEDIARYADD3 | VARCHAR2(35) | No | Intermediary Address3 |
| INTERMEDIARYBICCODE | VARCHAR2(24) | No | Intermediary BIC Code |
| INTERMEDIARYACCTNO | VARCHAR2(24) | No | Intermediary Account No |
| INTERMEDIARYCODE | VARCHAR2(24) | No | Intermediary Code |
| INTERMEDIARYINFO | VARCHAR2(100) | No | Intermediary Info |
| FURTHERCREDITNAME | VARCHAR2(35) | No | Further Credit Name |
| FURTHERCREDITACCTNO | VARCHAR2(35) | No | Further Credit Account Number |
| REFERENCE1 | VARCHAR2(35) | No | Reference1 |
| REFERENCE2 | VARCHAR2(35) | No | Reference2 |
| ENTITYID | VARCHAR2(12) | No | Entity ID |
| ENTITYTYPE | VARCHAR2(1) | No | Entity Type |
| IBAN | VARCHAR2(40) | No | IBAN |
| BENEFICIARYIBAN | VARCHAR2(40) | No | Beneficiary IBAN |
| INTERMEDIARYIBAN | VARCHAR2(40) | No | Intermediary IBAN |
| BENEFICIARYID | VARCHAR2(12) | No | Beneficiary ID |
| BENEFICIARYPERCENTAGE | NUMBER(5,2) | No | Beneficiary Percentage |
Parent topic: Light Weight Transaction File Format