2.7 Transactions Upload Format
This topic explains the information on Transactions Upload Format.
The upload file would contain various segment identification number in the first column to indicate the type of data that is present in that entire row. The possible segments that would be used in Transaction upload are given below for reference:
Segment ID - 00CON
This segment will be mandatory for incremental upload
Table 2-57 Transactions Upload Format - 00CON
| Column Name | Mandatory fields in upload file for upload mode I | Modifiable fields in Incremental mode | Remarks |
|---|---|---|---|
| SEGMENTID | Y | - | 00CON |
| PROCESSID | Y | - | Unique |
| SEQUENCENUMBER | Y | - | Unique |
| TXNSERIALNUMBER | Y | - | Unique |
| BULKCLIENTCODE | - | - | Unique |
| IMPORTFILENAME | - | - | Unique |
| AMCID | - | - | - |
| UPLOADMODE | - | - | I |
| TRANSACTIONNUMBER | - | - | - |
| REFERENCENUMBER | - | - | - |
| TRANSACTIONDATE | - | - | - |
| UNITHOLDERID | - | - | - |
| REFUNITHOLDERID | - | - | - |
| AGENTCODE | - | - | - |
| BRANCHCODE | - | - | - |
| FUNDID | - | - | - |
| AMOUNT | - | - | - |
| PAYMENTMODE | - | - | - |
| CHEQUENUMBER | - | - | - |
| CLEARINGDATE | - | - | - |
| TRANSACTIONCURRENCY | - | - | - |
| TRANSACTIONMODE | - | - | - |
| UNITSAPPLIED | - | - | - |
| PERCENTAPPLIED | - | - | - |
| TOFUNDID | - | - | - |
| TOUNITHOLDERID | - | - | - |
| REFTOUNITHOLDERID | - | - | - |
| TRANSACTIONTYPE | - | - | - |
| REFTYPE | - | - | - |
| REMARKS | - | - | - |
| CERTIFICATE | - | - | - |
| CIFNUMBER | - | - | - |
| TOCIFNUMBER | - | - | - |
| GROSSORNET | - | - | - |
| SUBPAYMENTMODE | - | - | - |
| COMMUNICATIONMODE | - | - | - |
| POLICYNUMBER | - | - | - |
| PRODUCTID | - | - | - |
| LOIAPPLICABLE | - | - | - |
| REFFUNDID | - | - | - |
| REFTOFUNDID | - | - | - |
| ENTITYTYPE | - | - | - |
| ENTITYID | - | - | - |
| SETTLEMENTDATE | - | - | - |
| DELIVERYOPTION | - | - | - |
| TRANSACTIONSUBTYPE | - | - | - |
| REVERSALCODE | - | - | - |
| CANCELINSTRUCTION | - | - | - |
| FROMFUNDPRICEBASIS | - | - | - |
| TOFUNDPRICEBASIS | - | - | - |
| TXN_OR_PRICE_DATE_FLAG | - | - | - |
| FROMPRICEDATE | - | - | - |
| TOPRICEDATE | - | - | - |
| SUBSCRIPTIONFUNDID | - | - | - |
| SUBSCRIPTIONPRICEBASIS | - | - | - |
| PAYMENTALLOWED | - | - | - |
| PROCESSID1 | - | - | - |
| SUBSETTLEMENTDATE | - | - | - |
| SUBPRICEDATE | - | - | - |
| BASECOST | - | - | - |
| EXCHANGERATEDETAILS | - | - | - |
| DEALINGDATE | - | - | - |
| COMPLETIONDATE | - | - | - |
| EUSDOPTION | - | - | - |
| TODEALINGDATE | - | - | - |
| KYCCHASINGDATE | - | - | - |
| KYCRECEIVED | - | - | - |
| LOCKINPERIODFORGAIN | - | - | - |
| SWIINEXCHANGERATEAPPLIED | - | - | - |
| AUTOCLEARPROVISIONALBALANCE | - | - | - |
| AUTOCLEARREINVESTMENTS | - | - | - |
| FEECURRENCY | - | - | - |
| MATURITYDATE | - | - | - |
| SUBSOURCEID | - | - | - |
| CERTSPILLOVER | - | - | - |
| ISSUED | - | - | - |
| BLOCKTXNNUMBER | - | - | - |
| CPMFBONUSPERCENT | - | - | - |
| CPMFCREDITLAG | - | - | - |
| RETAINAGEING | - | - | - |
| CAMPAIGNCODE | - | - | - |
| FXDEALDATE | - | - | - |
| FXVALUEDATE | - | - | - |
| USERID | - | - | Indicates the user ID who has entered the latest record |
| AUTH_STAT | - | - | - |
| ORDERRECEIVEDDATE | - | - | - |
| TXNCATEGORY | - | - | - |
| ORDERRECEIVEDTIME | - | - | - |
| SOURCEID | - | - | - |
| LOADREFTYPE | - | - | - |
| KIIDRECEIVED | - | - | - |
| ORDERRECDTIMEZONE | - | - | Order Received Time zone |
Segment ID - 01SET
Table 2-58 Transactions Upload Format - 01SET
| Column Name | Mandatory fields in upload file for upload mode I | Modifiable fields in Incremental mode | Remarks |
|---|---|---|---|
| SEGMENTID | Y | - | 01SET |
| PROCESSID | Y | - | Unique |
| SEQUENCENUMBER | Y | - | Unique |
| TXNSERIALNUMBER | Y | - | Unique |
| BULKCLIENTCODE | Y | - | Unique |
| IMPORTFILENAME | Y | - | Unique |
| AMCID | N | - | - |
| TRANSACTIONNUMBER | N | - | - |
| PRODUCTID | N | - | - |
| POLICYNUMBER | N | - | - |
| SYSREFERENCENUMBER | N | - | - |
| UNITHOLDERID | N | - | - |
| PAYMENTREFERENCENUMBER | N | - | - |
| PAYMENTMODE | N | - | - |
| SUBPAYMENTMODE | N | - | - |
| PAYMENTCURRENCY | N | - | - |
| PAYMENTDATE | N | Y | - |
| PAYMENTAMOUNT | N | Y | - |
| BANKCHARGES | N | Y | - |
| PAYMENTCHARGES | N | Y | - |
| EXCHANGERATESOURCE | N | Y | - |
| EXCHANGERATE | N | Y | - |
| PAYMENTFBCTXNAMOUNT | N | - | - |
| PAYMENTALTERNATEAMOUNT | N | - | - |
| SETTLEMENTDUEDATE | N | Y | - |
| PAIDDATE | N | Y | - |
| AUTOSETTLEMENT | N | Y | - |
| PAYMENTSTATUS | N | - | - |
| CLEARINGSTATUS | N | - | - |
| PAID | N | Y | - |
| SETTLEMENTMETHOD | N | - | - |
| SETTLEMENTSTATUS | N | - | - |
| SETTLEMENTAT | N | - | - |
| CHEQUEDATE | N | Y | - |
| CHEQUENUMBER | N | Y | - |
| CHEQUECURRENCY | N | Y | - |
| CHEQUEAMOUNT | N | Y | - |
| DRAWEEBANKCODE | N | Y | - |
| DRAWEEBRANCHNAME | N | Y | - |
| PAYMENTREMARKS | N | Y | - |
| PAYMENTTYPE | N | Y | - |
| THIRDPARTYADDRESS | N | Y | - |
| THIRDPARTYADDRESSLINE1 | N | Y | - |
| THIRDPARTYADDRESSLINE2 | N | Y | - |
| THIRDPARTYADDRESSLINE3 | N | Y | - |
| THIRDPARTYADDRESSLINE4 | N | Y | - |
| THIRDPARTYBICCODE | N | Y | - |
| THIRDPARTYCOUNTRYCODE | N | Y | - |
| THIRDPARTYPAYMENTREFERENCE | N | Y | - |
| THIRDPARTYSTATE | N | Y | - |
| THIRDPARTYUSSTATE | N | Y | - |
| THIRDPARTYZIPCODE | N | Y | - |
| TRANSFERACCOUNTCURRENCY | N | - | Complete transfer details can be updated if there are no existing transfer details & mode of payment is transfer or existing transfer details to be changed to new transfer details |
| TRANSFERACCOUNTHOLDERNAME | N | - | - |
| TRANSFERACCOUNTNUMBER | N | Y | - |
| TRANSFERACCOUNTTYPE | N | Y | - |
| TRANSFERBRANCHCODE | N | Y | - |
| TRANSFERREFERENCENUMBER | N | Y | - |
| CREDITCARDREFNO | N | Y | - |
| INKINDPAYMENTDETAILS | N | Y | - |
| PAYMENTADDRESSDETAILS | N | Y | - |
| OLDPAYMENTREFERENCENO | N | - | |
| UHBICCODE | N | Y | - |
| SWIFTFORMAT | N | Y | - |
| BANKCHARGED | N | Y | - |
| BENEFICIARY | N | Y | - |
| BENEFICIARYADD1 | N | Y | - |
| BENEFICIARYADD2 | N | Y | - |
| BENEFICIARYADD3 | N | Y | - |
| BENEFICIARYBICCODE | N | Y | - |
| BENEFICIARYACCTNO | N | Y | - |
| BENEFICIARYCODE | N | Y | - |
| BENEFICIARYINFO | N | Y | - |
| INTERMEDIARY | N | Y | - |
| INTERMEDIARYADD1 | N | Y | - |
| INTERMEDIARYADD2 | N | Y | - |
| INTERMEDIARYADD3 | N | Y | - |
| INTERMEDIARYBICCODE | N | Y | - |
| INTERMEDIARYACCTNO | N | Y | - |
| INTERMEDIARYCODE | N | Y | - |
| INTERMEDIARYINFO | N | Y | - |
| FURTHERCREDITNAME | N | Y | - |
| FURTHERCREDITACCTNO | N | Y | - |
| REFERENCE1 | N | Y | - |
| REFERENCE2 | N | Y | - |
| ENTITYID | N | Y | - |
| ENTITYTYPE | N | Y | - |
| IBAN | N | Y | - |
| BENEFICIARYIBAN | N | Y | - |
| INTERMEDIARYIBAN | N | Y | - |
| BENEFICIARYID | N | Y | - |
| BENEFICIARYPERCENTAGE | N | Y | - |
| AMOUNTBLOCKNO | N | - | - |
| SETTLED | N | Y | - |
| REVERSED | N | Y | - |
Segment ID - 03AIF
Table 2-59 Transactions Upload Format - 03AIF
| Column Name | Mandatory fields in upload file for upload mode I | Modifiable fields in Incremental mode | Remarks |
|---|---|---|---|
| SEGMENTID | Y | - | 03AIF |
| PROCESSID | Y | - | Unique |
| SEQUENCENUMBER | Y | - | Unique |
| TXNSERIALNUMBER | Y | - | Unique |
| BULKCLIENTCODE | Y | - | Unique |
| IMPORTFILENAME | Y | - | Unique |
| AMCID | N | - | - |
| TRANSACTIONNUMBER | N | - | - |
| REFERENCENUMBER | N | - | - |
| OTHERINFO1 | N | Y | - |
| OTHERINFO2 | N | Y | - |
| OTHERINFO3 | N | Y | - |
| OTHERINFO4 | N | Y | - |
| OTHERINFO5 | N | Y | - |
| OTHERINFO6 | N | Y | - |
| OTHERINFO7 | N | Y | - |
| OTHERINFO8 | N | Y | - |
| OTHERINFO9 | N | Y | - |
| OTHERINFO10 | N | Y | - |
| OTHERINFO11 | N | Y | - |
| OTHERINFO12 | N | Y | - |
| OTHERINFO13 | N | Y | - |
| OTHERINFO14 | N | Y | - |
| OTHERINFO15 | N | Y | - |
| OTHERINFO16 | N | Y | - |
| OTHERINFO17 | N | Y | - |
| OTHERINFO18 | N | Y | - |
| OTHERINFO19 | N | Y | - |
| OTHERINFO20 | N | Y | - |
| OTHERINFO21 | N | Y | - |
| OTHERINFO22 | N | Y | - |
| OTHERINFO23 | N | Y | - |
| OTHERINFO24 | N | Y | - |
| OTHERINFO25 | N | Y | - |
| OTHERINFO26 | N | Y | - |
| OTHERINFO27 | N | Y | - |
| OTHERINFO28 | N | Y | - |
| OTHERINFO29 | N | Y | - |
| OTHERINFO30 | N | Y | - |
Segment ID - 04INT
Table 2-60 Transactions Upload Format - 04INT
| Column Name | Mandatory fields in upload file for upload mode I | Modifiable fields in Incremental mode | Remarks |
|---|---|---|---|
| SEGMENTID | Y | - | Segment ID -04INT |
| PROCESSID | Y | - | Unique |
| SEQUENCENUMBER | Y | - | Unique |
| TXNSERIALNUMBER | Y | - | Unique |
| ENTITYID | Y | Y | If this field is populated along with dependent fields, this will replace entity at transaction level |
| ENTITYTYPE | Y | Y | - |
| SPLITPERCENTAGE | N | Y | - |
| FROMORTOLEG | N | Y | - |
Segment ID - 09LOD
Table 2-61 Transactions Upload Format - 09LOD
| Column Name | Mandatory fields in upload file for upload mode I | Modifiable fields in Incremental mode | Remarks |
|---|---|---|---|
| SEGMENTID | Y | - | 09LOD |
| PROCESSID | Y | - | Unique |
| SEQUENCENUMBER | Y | - | Unique |
| TXNSERIALNUMBER | Y | - | Unique |
| LOADID | Y | - | - |
| FUNDID | N | - | - |
| CHANGETYPE | N | Y | - |
| CHANGEVALUE | N | Y | - |
| GROUPID | N | - | If not provided, system will consider this as DEFGRP |
Segment ID - 10DLO
Table 2-62 Transactions Upload Format - 10DLO
| Column Name | Mandatory fields in upload file for upload mode I | Modifiable fields in Incremental mode | Remarks |
|---|---|---|---|
| SEGMENTID | Y | - | 10DLO |
| PROCESSID | Y | - | Unique |
| SEQUENCENUMBER | Y | - | Unique |
| TXNSERIALNUMBER | Y | - | Unique |
| DERIVEDLOADID | Y | - | - |
| FUNDID | N | - | - |
| CHANGETYPE | N | Y | - |
| CHANGEVALUE | N | Y | - |
| PARENTLOADID | N | - |
Segment ID - 12PSL
Table 2-63 Transactions Upload Format - 12PSL
| Column Name | Mandatory fields in upload file for upload mode I | Modifiable fields in Incremental mode | Remarks |
|---|---|---|---|
| SEGMENTID | Y | - | 12PSL |
| PROCESSID | Y | - | Unique |
| SEQUENCENUMBER | Y | - | Unique |
| TXNSERIALNUMBER | Y | - | Unique |
| REFERENCENUMBER | Y | - | - |
| LOADID | Y | - | - |
| FUNDID | N | - | - |
| CHANGETYPE | N | Y | - |
| CHANGEVALUE | N | Y | - |
| GROUPID | N | - | If not provided, system will consider this as DEFGRP |
| - | - | - | - |
| - | - | - | - |
Segment ID - 13PSD
Table 2-64 Transactions Upload Format - 13PSD
| Column Name | Mandatory fields in upload file for upload mode I | Modifiable fields in Incremental mode | Remarks |
|---|---|---|---|
| SEGMENTID | Y | - | 13PSD |
| PROCESSID | Y | - | Unique |
| SEQUENCENUMBER | Y | - | Unique |
| TXNSERIALNUMBER | Y | - | Unique |
| REFERENCENUMBER | Y | - | - |
| DERIVEDLOADID | Y | - | - |
| FUNDID | N | - | - |
| CHANGETYPE | N | Y | - |
| CHANGEVALUE | N | Y | - |
| PARENTLOADID | N | - | - |
| - | - | - | - |
| - | - | - | - |
Note:
If Param text is set to ‘Y’ for Param code ‘UPLDCUTOFFTIME’ and order received Date, order received Time Zone and order received Time is not present in upload file, then the time of transaction creation will be considered as order received Time, order received Time Zone as default one and trade date to be derived accordingly. If parameter is turned off, transaction will be considered as received within the cut off time.Parent topic: Appendix B - Upload File Formats B