1.3.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-21 Transaction Settlement related Information

Field Name (as expected in the file)	Data type	Length	Attributes	Characteristics/rules	Values
SEGMENTID	VARCHAR2	20	Mandatory	-	Segment ID - 01SET
TXNSERIALNUMBER	NUMBER	10	Mandatory	-	Transaction Serial Number
SEQUENCENUMBER	NUMBER	10	Mandatory	-	Sequence Number
PROCESSID	VARCHAR2	50	Mandatory	-	Process ID
BULKCLIENTCODE	VARCHAR2	12	Mandatory	-	Bulk Client Code
IMPORTFILENAME	VARCHAR2	255	Mandatory	-	Import File Name
UPLOADMODE	VARCHAR2	1	Optional	-	Upload Mode
AMCID	VARCHAR2	12	Optional	-	AMC ID
PAYMENTREFERENCENUMBER	VARCHAR2	50	Optional	-	Payment Reference Number
PAYMENTMODE	VARCHAR2	2	Optional	-	Payment Mode: C - Cash Q - Cheque T - Transfer R - Card M - Multipayment D - Draft
SUBPAYMENTMODE	VARCHAR2	2	Optional	-	Sub Payment Mode: T - Money Transfer Q - Cheque R - Credit Card D - Demand Draft F -Against Payment I - In Kind Payment AT - Advice BQ -Broker Cheque CQ - Cashier cheque DR - Debit Card DT - Direct Debit FQ - Foreign Cheque GQ - Government Cheque IQ - Other Institution Cheque LQ - Local Cheque OQ - Out Of Town Cheque PD - Pay Order PQ - Payroll Deduction RQ - Reserve Bank Cheque TT - Telegraphic Transfer WT - Wire Transfer
PAYMENTCURRENCY	VARCHAR2	3	Optional	-	Payment Currency
PAYMENTDATE	DATE	10	Optional	-	Payment Date
PAYMENTAMOUNT	NUMBER	15	Optional	-	Payment Amount
BANKCHARGES	NUMBER	15	Optional	-	Bank Charges
PAYMENTCHARGES	NUMBER	15	Optional	-	Payment Charges
EXCHANGERATESOURCE	VARCHAR2	6	Optional	-	Exchange Rate Source
EXCHANGERATE	NUMBER	15	Optional	-	FX Rate
PAYMENTALTERNATEAMOUNT	NUMBER	30	Optional	-	Payment Alternate Amount
PAIDDATE	DATE	10	Optional	-	Paid Date
AUTOSETTLEMENT	NUMBER	1	Optional	-	Auto Settle 1 - Yes 0 - No
SETTLEMENTMETHOD	VARCHAR2	5	Optional	-	Settlement Method
SETTLEMENTSTATUS	VARCHAR2	2	Optional	-	Settlement Status
CHEQUEDATE	DATE	10	Optional	-	Cheque Date
CHEQUENUMBER	VARCHAR2	16	Optional	-	Cheque Number
CHEQUECURRENCY	VARCHAR2	3	Optional	-	Cheque Currency
CHEQUEAMOUNT	NUMBER	15	Optional	-	Cheque Amount
DRAWEEBANKCODE	VARCHAR2	12	Optional	-	Drawee Bank Code
DRAWEEBRANCHNAME	VARCHAR2	20	Optional	-	Drawee Branch Name
PAYMENTREMARKS	VARCHAR2	255	Optional	-	Payment Remarks
PAYMENTTYPE	VARCHAR2	1	Optional	-	Payment Type: S - Self T - Third Party B - Broker R - Retained AP - Advanced Payment A - Absorbed/ Paid back
THIRDPARTYADDRESS	VARCHAR2	255	Optional	-	Third Party Address
THIRDPARTYADDRESSLINE1	VARCHAR2	80	Optional	-	Third Party Address line 1
THIRDPARTYADDRESSLINE2	VARCHAR2	80	Optional	-	Third Party Address line 2
THIRDPARTYADDRESSLINE3	VARCHAR2	80	Optional	-	Third Party Address line 3
THIRDPARTYADDRESSLINE4	VARCHAR2	80	Optional	-	Third Party Address line 4
THIRDPARTYBICCODE	VARCHAR2	12	Optional	-	Third Party BIC Code
THIRDPARTYCOUNTRYCODE	VARCHAR2	3	Optional	-	Third Party Country
THIRDPARTYPAYMENTREFERENCE	VARCHAR2	255	Optional	-	Third Party Reference
THIRDPARTYSTATE	VARCHAR2	20	Optional	-	Third Party State
THIRDPARTYUSSTATE	NUMBER	1	Optional	-	Third Party US State
THIRDPARTYZIPCODE	VARCHAR2	10	Optional	-	Third Party Zip Code
TRANSFERACCOUNTCURRENCY	VARCHAR2	3	Optional	-	Transfer Account Currency
TRANSFERACCOUNTHOLDERNAME	VARCHAR2	100	Optional	-	Transfer Account Holder Name
TRANSFERACCOUNTNUMBER	VARCHAR2	20	Optional	-	Transfer Account Number
TRANSFERACCOUNTTYPE	VARCHAR2	1	Optional	-	Transfer Account Type
TRANSFERBRANCHCODE	VARCHAR2	12	Optional	-	Transfer Branch Code
TRANSFERREFERENCENUMBER	VARCHAR2	20	Optional	-	Transfer Reference Number
CREDITCARDREFNO	VARCHAR2	16	Optional	-	Credit Card Reference Number
INKINDPAYMENTDETAILS	VARCHAR2	255	Optional	-	In Kind Payment Details
PAYMENTADDRESSDETAILS	VARCHAR2	255	Optional	-	Payment Address Details
OLDPAYMENTREFERENCENO	VARCHAR2	16	Optional	-	Old Payment Reference Number
UHBICCODE	VARCHAR2	24	Optional	-	UH BIC Code
SWIFTFORMAT	VARCHAR2	6	Optional	Valid values are 0, 1 and 2	Swift Format: MT103 - MT103, MT202 - MT202
BANKCHARGED	VARCHAR2	12	Optional	-	Bank Charged. Beneficiary - Beneficiary, Remitter - Remitter, Share - Share
BENEFICIARY	VARCHAR2	35	Optional	-	Beneficiary
BENEFICIARYADD1	VARCHAR2	105	Optional	-	Beneficiary Address1
BENEFICIARYADD2	VARCHAR2	105	Optional	-	Beneficiary Address2
BENEFICIARYADD3	VARCHAR2	105	Optional	-	Beneficiary Address3
BENEFICIARYBICCODE	VARCHAR2	24	Optional	-	Beneficiary BIC Code
BENEFICIARYACCTNO	VARCHAR2	34	Optional	-	Beneficiary Account Number
BENEFICIARYCODE	VARCHAR2	24	Optional	-	Beneficiary Code
BENEFICIARYINFO	VARCHAR2	100	Optional	-	Beneficiary Information
INTERMEDIARY	VARCHAR2	35	Optional	-	Intermediary
INTERMEDIARYADD1	VARCHAR2	105	Optional	-	Intermediary Address1
INTERMEDIARYADD2	VARCHAR2	105	Optional	-	Intermediary Address2
INTERMEDIARYADD3	VARCHAR2	105	Optional	-	Intermediary Address3
INTERMEDIARYBICCODE	VARCHAR2	24	Optional	-	Intermediary BIC Code
INTERMEDIARYACCTNO	VARCHAR2	34	Optional	-	Intermediary Account No
INTERMEDIARYCODE	VARCHAR2	24	Optional	-	Intermediary Code
INTERMEDIARYINFO	VARCHAR2	100	Optional	-	Intermediary Info
FURTHERCREDITNAME	VARCHAR2	35	Optional	-	Further Credit Name
FURTHERCREDITACCTNO	VARCHAR2	35	Optional	-	Further Credit Account Number
REFERENCE1	VARCHAR2	35	Optional	-	Reference1
REFERENCE2	VARCHAR2	35	Optional	-	Reference2
ENTITYID	VARCHAR2	12	Optional	-	Entity ID
ENTITYTYPE	VARCHAR2	1	Optional	-	Entity Type
IBAN	VARCHAR2	40	Optional	-	IBAN
BENEFICIARYIBAN	VARCHAR2	40	Optional	-	Beneficiary IBAN
INTERMEDIARYIBAN	VARCHAR2	40	Optional	-	Intermediary IBAN
BENEFICIARYID	VARCHAR2	12	Optional	-	Beneficiary ID
BENEFICIARYPERCENTAGE	NUMBER	5	Optional	-	Beneficiary Percentage
AMOUNTBLOCKNO	VARCHAR2	16	Optional	-	Amount Block Number
SETTLED	VARCHAR2	1	Optional	-	Settled: Y - Yes N - No
REVERSED	VARCHAR2	1	Optional	-	Reversed: Y - Yes N - No