1.3.2 Transaction Related Information

This topic provides information on transaction related information.

Serial Number: 1

Segment Identification Number: 00CON

Description: This segment is used for providing Transaction related Information.

Attributes: Mandatory

Table 1-20 Transaction related Information

Field Name (as expected in the file) Data type Length Attributes Characteristics/rules Values
SEGMENTID VARCHAR2 80 Mandatory - Segment ID - 00CON
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 Mandatory -
Mode of Transaction,
  • N – New
  • E - Modify
  • D - Delete
  • A - Auth
  • R - Reversal
  • I – Incremental
AMCID VARCHAR2 12 Mandatory - AMC ID
TRANSACTIONNUMBER VARCHAR2 16 Mandatory - Transaction Number
REFERENCENUMBER VARCHAR2 16 Optional - Reference Number
TRANSACTIONDATE DATE 7 Mandatory - Transaction Date
UNITHOLDERID VARCHAR2 60 Mandatory - Unitholder ID
REFUNITHOLDERID VARCHAR2 12 Mandatory - Reference Unit Holder ID
AGENTCODE VARCHAR2 12 Mandatory - Agent Code
BRANCHCODE VARCHAR2 12 Mandatory - Branch Code
FUNDID VARCHAR2 25 Mandatory - Fund ID
AMOUNT NUMBER 15 Optional - Amount
PAYMENTMODE VARCHAR2 1 Optional -
Payment Mode:
  • C - Cash
  • Q - Cheque
  • T - Transfer
  • R - Card
  • M - Multipayment
  • D - Draft
CHEQUENUMBER VARCHAR2 16 Optional - Cheque Number
CLEARINGDATE DATE 7 Optional - Clearing Date
TRANSACTIONCURRENCY VARCHAR2 3 Optional - Transaction Currency
TRANSACTIONMODE VARCHAR2 1 Optional -
Transaction Mode:
  • A - Amount
  • U - Units
  • P - Percentage
UNITSAPPLIED NUMBER 15 Optional - Units
PERCENTAPPLIED NUMBER 5 Optional - Percentage
TOFUNDID VARCHAR2 25 Optional - To Fund ID
TOUNITHOLDERID VARCHAR2 60 Optional - To Unitholder ID
REFTOUNITHOLDERID VARCHAR2 12 Optional - Reference To Unit Holder ID
TRANSACTIONTYPE VARCHAR2 2 Mandatory -
Transaction Type:
  • 01 - IPO Subscription
  • 02 - Subscription
  • 03 - Redemption
  • 04 - Switch
  • 05 - Transfer
REFTYPE VARCHAR2 2 Optional -

Ref Type

For example, reftype - 56, transaction Type - 05 it will consider as 'No Change of beneficiary ownership' Transfer transaction
REMARKS VARCHAR2 255 Optional - Remarks
CIFNUMBER VARCHAR2 12 Optional - CIF Number
TOCIFNUMBER VARCHAR2 12 Optional - To CIF Number
GROSSORNET VARCHAR2 1 Optional For the redemption transactions, by default the value will be Net, if the same is not provided by the user Gross Or Net.GGross, N-Net
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
COMMUNICATIONMODE VARCHAR2 2 Optional -
Communication Mode:
  • CW - Check Writing
  • DI - Direct (In Person)
  • EM - EMail
  • IN - Internet
  • RA-Registered Investment Advisor
  • RD - Registered Dealer
  • SP - Savings Plan
  • SW - SWIFT
  • TL - Telephone
POLICYNUMBER VARCHAR2 16 Optional - Policy Number
PRODUCTID VARCHAR2 10 Optional - Product ID
LOIAPPLICABLE NUMBER 1 Optional - LOI Transaction:
  • 1 - Yes
  • 0 - No
REFFUNDID VARCHAR2 6 Mandatory - Reference Fund ID
REFTOFUNDID VARCHAR2 6 Optional - Reference To Fund ID
ENTITYTYPE VARCHAR2 1 Optional -
Entity Type:
  • A - Agent
  • N - Branch Code
  • I - IFA
  • O - Account Officer
  • B - Broker
ENTITYID VARCHAR2 12 Optional - Entity ID
SETTLEMENTDATE DATE 7 Optional - Settlement Date
DELIVERYOPTION VARCHAR2 1 Optional -
Delivery Option:
  • Y - On
  • N - Off
TRANSACTIONSUBTYPE VARCHAR2 1 Optional - Transaction Sub Type
REVERSALCODE VARCHAR2 2 Optional - Reversal Code
CANCELINSTRUCTION VARCHAR2 2 Optional - Cancel Instruction. SI-Standing Instruction
FROMFUNDPRICEBASIS VARCHAR2 10 Optional - Fund Price Basis
TOFUNDPRICEBASIS VARCHAR2 10 Optional - Switch In Price Basis
TXN_OR_PRICE_DATE_FLAG VARCHAR2 1 Optional - Transaction/ price date
FROMPRICEDATE DATE 7 Optional - Price Date
TOPRICEDATE DATE 7 Optional - Switch In Price Date
SUBSCRIPTIONFUNDID VARCHAR2 6 Optional - Subscription Fund ID
SUBSCRIPTIONPRICEBASIS VARCHAR2 10 Optional - Subscription Price Basis
PAYMENTALLOWED NUMBER 1 Optional - Payment Allowed
PROCESSID1 VARCHAR2 51 Mandatory - Process ID . Should be same as the Process ID given above.
SUBSETTLEMENTDATE DATE 10 Optional - Settlement Date
SUBPRICEDATE DATE 10 Optional - Subscription price Date
BASECOST NUMBER 15 Optional - Base cost
EXCHANGERATEDETAILS VARCHAR2 35 Optional - Exchange Rate Details - Unit Currency, Quoted Currency, Exchange Rate.Seperated by '#' for instance, ZAR#GBP#0.2#
DEALINGDATE DATE 10 Mandatory - Dealing Date
COMPLETIONDATE DATE 10 Mandatory - Completion Date
EUSDOPTION VARCHAR2 1 Mandatory - EUSD Option:
  • W - With Holding Tax
  • E - Exchange of Information
  • T - Tax Exemption Certificate
TODEALINGDATE DATE 10 Mandatory - Switch In Dealing Date
KYCCHASINGDATE DATE 10 Mandatory - KYC Chasing Date
KYCRECEIVED NUMBER 1 Mandatory - KYC Received:
  • 1 - Yes
  • 0 - No
LOCKINPERIODFORGAIN NUMBER 4 Optional - Lock-In Period for Gain
SWIINEXCHANGERATEAPPLIED NUMBER 15 Mandatory - Switch-In Exchange Rate Applied
AUTOCLEARPROVISIONALBALANCE NUMBER 1 Optional Valid values are 0, 1 and 2 Auto Clear Provisional Balance. 1-Yes,0- No
AUTOCLEARREINVESTMENTS NUMBER 1 Optional Valid values are 0, 1 and 2 Auto Clear Reinvestments:
  • 1 - Yes
  • 0 - No
FEECURRENCY VARCHAR2 3 Optional Valid values are ‘FBC’ and ‘TC’ Fee Currency
MATURITYDATE DATE 10 Optional - Maturity Date
SUBSOURCEID VARCHAR2 6 Optional - Subscription Source ID
CERTSPILLOVER NUMBER 1 Optional - Certificate Spill- Over
ISSUED NUMBER 1 Optional - From Issued Balances:
  • 1 - Yes
  • 0 - No
BLOCKTXNNUMBER VARCHAR2 16 Optional - Block Transaction Number
CPMFBONUSPERCENT NUMBER 30 Optional - CPMF Bonus Percent
CPMFCREDITLAG NUMBER 3 Optional - CPMF Credit Lag
RETAINAGEING NUMBER 1 Optional - Retain Ageing
CAMPAIGNCODE VARCHAR2 6 Optional - Campaign Code
FXDEALDATE DATE 10 Optional Applicable for only IPO Subscription/ Subscription/ Redemption and Pseudo Switch FX Deal Date
FXVALUEDATE DATE 10 Optional Applicable for only IPO Subscription/ Subscription/ Redemption and Pseudo Switch FX Value Date
USERID VARCHAR2 15 Mandatory - Represents the user ID who has entered the latest record
AUTH_STAT VARCHAR2 1 Mandatory - Authorisation Status:
  • A - Authorized
  • U - Unauthorized
ORDERRECEIVEDDATE DATE 7 Optional - Order Received Date
ORDERRECEIVEDTIME VARCHAR2 5 Optional - Order Received Time
TXNCATEGORY VARCHAR2 1 Optional - Transaction Category
  • E - Execution only
  • L - Legacy
  • A - Advise Mode
LOADREFTYPE VARCHAR2 4 Optional - Load Ref Type
SOURCEID VARCHAR2 6 Optional - Source ID
KIIDRECEIVED VARCHAR2 1 Optional - KIID Received
ORDERRECDTIMEZONE VARCHAR2 12 Mandatory - Order Received Time Zone

Note:

If the upload mode is R, then the system will consider transaction number and reversal code in the template for the reversal of transaction.

Parent topic: Transactions File Format