1.9.2 Policy Transactions Related Information
This topic provides information on policy transactions related information.
Serial Number: 1
Segment Identification Number: 00PTN
Description: This segment is used for providing information related to policy transactions that is to be uploaded into the system.
Attributes: Mandatory
Table 1-66 Policy Transactions Related Information
| Field Name (as expected in the file) | Data type | Length | Attributes | Characteristics/rules | Values |
|---|---|---|---|---|---|
| SEGMENTID | VARCHAR2 | 20 | Mandatory | - | Segment ID - 00PTN |
| 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 |
| POLICYTXNNUMBER | VARCHAR2 | 16 | Mandatory | - | Policy Transaction Number |
| POLICYNUMBER | VARCHAR2 | 16 | Mandatory | - | Policy Reference Number |
| TXNREFERENCENUMBER | VARCHAR2 | 16 | Optional | - | Transaction Reference Number |
| TXNTYPE | VARCHAR2 | 2 | Mandatory | - | Transaction Type |
| TXNDATE | DATE | 7 | Mandatory | - | Transaction Date |
| TXNINPUTDATE | DATE | 7 | Optional | - | Transaction Input Date |
| TXNAMT | NUMBER | 15 | Mandatory | - | Transaction Amount |
| NETAMT | NUMBER | 15 | Optional | - | Net Amount |
| TXNBASECCY | VARCHAR2 | 3 | Optional | - | Transaction base currency |
| TXNGENFLAG | NUMBER | 1 | Optional | - | Transaction Generated Flag |
| TXNREMARKS | VARCHAR2 | 255 | Optional | - | Transaction Remarks |
| USERID | VARCHAR2 | 15 | Mandatory | - | Represents the user ID who has entered the latest record |
| LASTMODIFIEDUSERID | VARCHAR2 | 15 | Optional | - | Last Modified User ID |
| LASTMODIFIEDUSERDATE | DATE | 7 | Optional | - | Last Modified User Date |
| MOD_NO | NUMBER | 38 | Optional | - | Modification Number |
| AUTH_STAT | VARCHAR2 | 1 | Mandatory | - |
Authorisation Status:
|
| AGENTCODE | VARCHAR2 | 12 | Mandatory | - | Agent Code |
| BRANCHCODE | VARCHAR2 | 12 | Mandatory | - | Branch Code |
| DRAWEEBANKCODE | VARCHAR2 | 12 | Optional | - | Drawee Bank Code |
| TRANSFERBRANCHCODE | VARCHAR2 | 12 | Optional | - | Transfer Branch Code |
| TRANSFERACCOUNTTYPE | VARCHAR2 | 1 | Optional | - | Transfer Account Type |
| TRANSFERACCOUNTNUMBER | VARCHAR2 | 20 | Optional | - | Transfer Account Number |
| TRANSFERACCOUNTCURRENCY | VARCHAR2 | 3 | Optional | - | Transfer Account Currency |
| PAYMENTMODE | VARCHAR2 | 1 | Optional | - | Payment Mode |
| CHEQUENUMBER | VARCHAR2 | 16 | Optional | - | Cheque Number |
| CHEQUEDATE | DATE | 7 | Optional | - | Cheque Date |
| CLEARINGDATE | DATE | 7 | Optional | - | Clearing Date |
| CLEARINGSTATUS | VARCHAR2 | 3 | Optional | - | Clearing Status |
| PRODUCTID | VARCHAR2 | 10 | Optional | - | Product ID |
| POLICYHOLDERID | VARCHAR2 | 12 | Optional | - | Policy Holder ID |
| POLICYTRANSACTIONMODE | VARCHAR2 | 1 | Mandatory | - |
Policy Transaction Mode:
|
| ALLOTTEDFLAG | NUMBER | 1 | Optional | - | Alloted Flag |
| TOPUPINCLUSIVE | NUMBER | 1 | Optional | - |
Top up Inclusive Flag:
|
| SYNCFLAG | NUMBER | 1 | Optional | - | Sync Flag |
| ACKNOWLEDGEMENTPRINTED | NUMBER | 1 | Optional | - | Acknowledgement Printed |
| TRANSFERORID | VARCHAR2 | 12 | Optional | - | Transfer Order ID |
| PERCENTAGEAPPLIED | NUMBER | 5 | Optional | - | Percentage Applied |
| OLDPOLICYTXNNUMBER | VARCHAR2 | 16 | Optional | - | Old Policy Txn number |
| NETINVESTIBLEAMOUNT | NUMBER | 15 | Optional | - | Net Investible Amount |
| MODULEID | VARCHAR2 | 30 | Mandatory | - | Module ID |
| ADJUSTMENTTXNTYPE | VARCHAR2 | 3 | Optional | - | Adjustment Transaction Type |
| PORTFOLIOSWITCH | NUMBER | 1 | Optional | - | Port Folio Switch |
| SURRENDERMONEYPAYABLE | VARCHAR2 | 1 | Mandatory | - | Surrender Money Payable |
| FUNDINGPERCENTAGE | NUMBER | 5 | Optional | - | Funding Percentage |
| CANCELLED_ PHA SEINID | VARCHAR2 | 16 | Optional | - | Cancelled Phase In ID |
| UNITSAPPLIED | NUMBER | 15 | Optional | - | Units Applied |
| INTERESTAMOUNT | NUMBER | 15 | Mandatory | - | Interest Amount |
| DATEALLOTED | DATE | 7 | Optional | - | Date Alloted |
| GROSSAMOUNT | NUMBER | 22 | Optional | - | Gross Amount |
| SWITCHINGROSSAMT | NUMBER | 15 | Optional | - | Switch In Gross Amount |
| SWITCHINNETAMT | NUMBER | 15 | Optional | - | Switch In Net Amount |
| ADJUSTMENTTXN | NUMBER | 1 | Optional | - | Adjustment Transaction |
| IBAN | VARCHAR2 | 40 | Optional | - | Internation Bank Account Number |
| SOURCEID | VARCHAR2 | 6 | Optional | - | Source ID |
| EXCHANGERATEAPPLIED | NUMBER | 24 | Optional | - | Exchange Rate Applied |
| AMOUNTAPPLIED | NUMBER | 30 | Optional | - | Amount Applied |
| BALANCETRANSFER | NUMBER | 1 | Optional | - | Balance transfer |
| OVERRIDEEXCHANGERATE | VARCHAR2 | 1 | Optional | - | Override Exchange Rate |
| INTAMTINTXNCCY | NUMBER | 30 | Optional | - | Initial amount in Transaction currency |
| INCLUDE_INTEREST_IN_INVE STMENT | VARCHAR2 | 1 | Optional | - | Include Interest In Investment |
| FXDEALDATE | DATE | 7 | Optional | - | FX Deal Date |
| FXVALUEDATE | DATE | 7 | Optional | - | FX Value Date |
| EXCHANGERATESTATUS | VARCHAR2 | 1 | Optional | - | Exchange Rate Status |
Parent topic: Policy Transaction Upload Format