1.4.2 Standing Instruction Related Information

This topic provides information on standing instruction related information.

Serial Number: 1

Segment Identification Number: 00SIN

Description: This segment is used for providing Standing Instruction related Information.

Attributes: Mandatory

Table 1-35 Standing Instruction Related Information

Field Name (as expected in the file) Data type Length Attributes Characteristics/rules Values
SEGMENTID VARCHAR2 80 Mandatory - Segment ID. Value of Segment ID is 00SIN
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 Mandatory - Upload Mode
AMCID VARCHAR2 12 Mandatory - AMC ID
SIID VARCHAR2 16 Optional - Standing Instruction ID
SIDESCRIPTION VARCHAR2 255 Optional - SI Description
FUNDID VARCHAR2 25 Optional - Fund ID
REFUNITHOLDERID VARCHAR2 12 Optional - This must be blank
REFUNITHOLDERID VARCHAR2 12 Optional - This must be blank
UNITHOLDERID VARCHAR2 12 Optional - Unitholder ID
TRANSACTIONTYPE VARCHAR2 2 Optional -
Transaction Type:
  • 01 - IPO Subscription
  • 02 - Subscription
  • 03 - Redemption
  • 04 - Switch
  • 05 - Transfer
EFFECTIVESTARTDATE DATE 10 Optional - Effective Start Date
EFFECTIVEENDDATE DATE 10 Optional - Effective End Date
SIFREQUENCY VARCHAR2 1 Optional -
SI Frequency:
  • M - Monthly
  • Q - Quartely
  • H - Half Yearly
  • Y - Yearly
  • W - Weekly
  • F - BiWeekly
  • D - Daily
AMOUNT NUMBER 30 Optional - Amount
UNITS NUMBER 27 Optional - Units
HOLDINGSPERCENTAGE NUMBER 5 Optional - Percentage
TRANSACTIONCURRENCY VARCHAR2 3 Optional - Transaction Currency.
TOUNITHOLDERID VARCHAR2 12 Optional - To Unitholder ID
TOFUNDID VARCHAR2 25 Optional - To Fund ID
AGENTCODE VARCHAR2 12 Optional - Agent Code
BRANCHCODE VARCHAR2 12 Optional - Branch Code
MODULEID VARCHAR2 30 Optional - Module ID
MODEOFPAYMENT VARCHAR2 1 Optional - Mode of Payment
PAYMENTBRANCHCODE VARCHAR2 12 Optional - Payment Branch
TRANSFERACCOUNTTYPE VARCHAR2 1 Optional - Account Type
TRANSFERACCOUNTNUMBER VARCHAR2 20 Optional - Account Number
REMINDERBEFOREPERIOD NUMBER 3 Optional - Reminder Period
REMINDERBEFOREACTION NUMBER 1 Optional - Reminder Before Action
SISTATUS VARCHAR2 1 Optional - SI Status
GENERATEAUTHTXN NUMBER 1 Optional -
Generate Auth Transactions:
  • 1 - Yes
  • 0 - No
SITYPE VARCHAR2 10 Optional - This must be blank
SIESCALATIONFREQUENCY VARCHAR2 1 Optional - Escalation Frequency:
  • M - Execution only
  • Q - Legacy
  • H - Advise Mode
  • Y - Yearly
  • W - Weekly
  • F - Bi Weekly
  • D - Daily
NEXTESCALATIONDATE DATE 10 Mandatory - Next Escalation Date
ESCALATIONTYPE VARCHAR2 1 Optional - Escalation Type:
  • A - Amount/ Units
  • P - Percentage
ESCALATIONVALUE NUMBER 30 Optional - Escalation Value
USERID VARCHAR2 15 Mandatory - Represents the user ID who has entered the latest record
AUTH_STAT VARCHAR2 1 Optional -
Authorization Status:
  • A - Authorized
  • U - Unauthorized
GROSSORNET VARCHAR2 1 Mandatory Mandatory for transaction types (01, 02 & 03) i.e., IPO, Subscription and redemption
Gross or Net:
  • G - Gross
  • N - Net
MEANSOFPURCHASE VARCHAR2 2 Optional - Value should be a valid means of purchase code maintained in the system
ISSUED VARCHAR2 1 Optional - Issued:
  • 1 - Yes
  • 0 - No
  • 2 - Both
CERTREQD VARCHAR2 1 Optional - Certificate Required?
  • 1 - Yes
  • 0 - No
SINGLECERT VARCHAR2 1 Optional - Single Certificate?
  • 1 - Yes
  • 0 - No
TOSINGLECERT VARCHAR2 1 Optional - Applicable for script based fund only
SUBPAYMENTMODE VARCHAR2 2 Optional -
Mode of Payment:
  • 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
ESCALATIONSTARTDATE DATE 10 Mandatory Mandatory if Escalation type is provided Escalation Start Date
ESCALATIONENDDATE DATE 10 Mandatory Mandatory if Escalation type is provided Escalation End Date
PAYMENTBANKCODE VARCHAR2 12 Mandatory Require d for payment modes check transfer, credit card and demand draft Payment Bank Code
TRANSFERACCOUNTHOLDERNAME VARCHAR2 60 Optional - Account Holder Name
PAYMENTTYPE VARCHAR2 1 Optional -
Payment Type:
  • S - Self
  • T - Third Party
THIRDPARTYPAYMENTREFERENCE VARCHAR2 255 Optional - Third Party Reference
THIRDPARTYZIPCODE VARCHAR2 6 Optional - Third Party Zip Code
THIRDPARTYUSSTATE NUMBER 1 Optional - Third Party US State
DELIVERYOPTION VARCHAR2 1 Optional - Delivery Option
THIRDPARTYBICCODE VARCHAR2 12 Optional - BIC Code
THIRDPARTYCOUNTRYCODE VARCHAR2 3 Optional - Country
THIRDPARTYADDRESSLINE1 VARCHAR2 80 Optional - Address Line 1
THIRDPARTYADDRESSLINE2 VARCHAR2 80 Optional - Address Line 2
THIRDPARTYADDRESSLINE3 VARCHAR2 80 Optional - City
THIRDPARTYADDRESSLINE4 VARCHAR2 80 Optional - Country
TRANSFERREFERENCENUMBER VARCHAR2 20 Optional - Transfer Reference Number
CIFNUMBER VARCHAR2 12 Optional - CIF Number
TOCIFNUMBER VARCHAR2 12 Optional - To CIF Number
POLICYNUMBER VARCHAR2 16 Optional - This must be blank
PRODUCTID VARCHAR2 10 Optional - This must be blank
ENTITYTYPE VARCHAR2 1 Optional -
Entity Type:
  • B - Broker
  • A - Agent
  • I - IFA
  • O - Account Officer
  • N - Agency Branch
ENTITYID VARCHAR2 12 Optional - Broker/Intermediary
REFFUNDID VARCHAR2 6 Optional - Specify the fund code here
REFTOFUNDID VARCHAR2 6 Optional - Specify the fund code if the SI is switch type of instruction
MINHOLDCHKREQ NUMBER 1 Optional -
Minimum Holding Check Required?
  • 1 - Yes
  • 0 - No
FROMFUNDPRICEBASIS VARCHAR2 10 Optional - Price Basis
TOFUNDPRICEBASIS VARCHAR2 10 Optional - This must be blank
PHASEIN NUMBER 1 Optional - Phase In
PHASEINTYPE VARCHAR2 1 Optional If PHASEIN is applicable, then this field is mandatory.
Phase In Type:
  • H - Holdings
PHASEINOCCURENCES NUMBER 3 Optional If PHASEIN is applicable, then this field is mandatory. If Phase In is applicable then this field is mandatory.
REMAININGOCCURENCES NUMBER 3 Optional - This must be blank
GENERATEON VARCHAR2 255 Optional - This must be blank
NOOFSI NUMBER 5 Optional - No. of SI Transactions
SWIFTFORMAT VARCHAR2 6 Optional -

Swift Format.

MT103 - MT103, MT202 - MT202
BANKCHARGED VARCHAR2 12 Optional -

Bank Charged.

Shared - Shared, Remit - Remit
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 Info
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 Number
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
NOOFSITRANSACTIONS NUMBER 4 Optional - No. of SI Transactions
SILEVEL VARCHAR2 1 Optional Valid values are ‘F’ and ‘P’
SI Level:
  • P - Plan
  • F - Fund
PLANCODE VARCHAR2 6 Optional - Plan Code
FIRSTPAYMENTDATE DATE 10 Optional - First Generation Date
IBAN VARCHAR2 40 Optional - IBAN
CAMPAIGNCODE VARCHAR2 6 Optional - Campaign Code
BENEFICIARYIBAN VARCHAR2 40 Optional - Beneficiary IBAN
INTERMEDIARYIBAN VARCHAR2 40 Optional - Intermediary IBAN
SIPAYMENTREJECTIONCOUNTER NUMBER 3 Optional - No. of Cumulative Payment Rejections
SIAUTOTERMINATIONCOUNTER NUMBER 3 Optional - SI Auto-Termination Cumulative Counter
CONSSIPAYMNTREJCNTER NUMBER 3 Optional - No. of Consecutive Payment Rejections
CONSSIAUTOCOUNTER NUMBER 3 Optional - SI Auto-Termination Consecutive Counter
MAXSITXNSALLOWED NUMBER 3 Optional - Maximum SI Transactions Allowed

Parent topic: Standing Instruction File Format