1.32 Cheque Tracking File Format

This topic provides information on Cheque Tracking File Format.

Note:

For all imports of new and amended Cheque Tracking data, the external hand-off file containing the information must:

• Always contain all information marked as mandatory in the table below.
• Always contain the information in the exact format and serial order shown in the Field Name column (with values according to the validations mentioned) in the table below:

Table 1-147 Cheque Tracking File Format

Field Name (as expected in the file)	Data type	Field Length	Attributes	Characteristics/rules	Values
SEGMENTID	String	20	Mandatory	-	Sequence no. of records in the file
SEQUENCENUMBER	Number	10	Mandatory	-	Sequence no. of records in the file
PROCESSID	String	50	Mandatory	-	The Process ID, along with the system generated sequence number, identifies the uploaded record uniquely. Each file must have a unique Process ID. This should be same for all records within a file.
BULKCLIENTCODE	String	12	Mandatory	-	The Code of the Bulk client.
IMPORTFILENAME	String	255	Mandatory	-	Name of the file being uploaded should be specified. Each file must have a unique name.
UPLOADMODE	String	1	Mandatory	-	“N” for New Mode and ‘E’ for Edit Mode, “M” for modify mode , “D” for delete mode.
AMCID	String	12	Mandatory	-	The ID of the AMC/Distributor for which the bulk client has maintained the defaults details.
CHEQUETYPE	String	3	Mandatory	-	Should be valid type as maintained in the system.
TRANSACTIONNumber	String	16	-	-	Transaction number should be specified if the Transaction Type is “RED”.
FUNDID	String	6	Mandatory	-	The ID of a valid and enabled fund maintained in the system
PAYMENTNUMBER	Number	5	Mandatory	-	Payment number should be specified if the Transaction Type is “UHD”.
UNITHOLDERID	String	12	Mandatory	-	The Unit holder ID to identify a unit holder in the system, depending on the scheme/ cross reference number.
PRODUCTID	String	10	Optional	-	ID of the product under which the corresponding Policy has been created.
CORPORATEACTIONTYPE	String	1	Optional	-	C- Cash Dividend S – Stock Dividend
CHEQUEAMOUNT	Number	30,12	Mandatory	-	This field denotes the cheque Amount
CHEQUECURRENCY	String	3	Mandatory	-	This field denotes the cheque currency
CHEQUEDATE	Date	10	Mandatory	-	For check payment modes, this is the date of issue of the check. Must not be later than the current application date.
CHEQUENUMBER	String	16	Mandatory	-	Indicates the check number for Payment mode (Q) and Credit card number for payment mode (R). This is Mandatory if mode of Payment is check (Q) or credit card (R).
OLDCHEQUENUMBER	String	16	Optional	-	This field denotes the previous cheque number.
DRAWEEBANK	String	12	Mandatory	-	Should be a valid Bank Code as defined in the system
DRAWEEBRANCHCODE	String	12	Optional	Mandatory	Should be a valid Branch Code as defined in the system
DUPLICATE	String	1	Optional	-	-
TRANSACTIONTYPE	String	4	Optional	Mandatory	Should valid type as maintained in the system.
SPOOLSERIALNO	Number	10	Optional	-	Unique Serial No.
CHECKSTATUS	String	1	Mandatory	-	Check Status N - New A – Active D- Duplicate C- Cleared I – Invalid
CHECKPRINTEDDATE	Date	10	Optional	-	Actual Chq Printed Date
FILENAME	String	30	Optional	-	Chq Upload File Name
PROCESSED	String	1	Optional	Mandatory	Unique Sequence number
TIMESTAMP	Date	10	Optional	-	Date Time Stamp
PRINTERID	String	15	Optional	-	Unique Sequence number
USERID	String	320	Mandatory	-	Indicates the user ID who has entered the latest record
DEPOSITRYID	String	12	Optional	-	DP ID
PAYMENTMODE	String	2	Mandatory	-	Indicates mode of payment. Can be any of the following values. Q - Cheque T - Transfer R - Credit card C - Cash D - Draft
SUBPAYMENTMODE	String	2	Optional	-	Can have valid values as defined in the mode of payment table
PAYINBANK	String	12	Optional	-	Should be a valid Bank as defined in the system.
PAYINBRANCH	String	12	Optional	-	Should be a valid Brach as defined in the system.
PAYINNumber	String	12	Optional	-	Unique Serial Number
MODULEID	String	30	Mandatory	-	Should be a valid module ID as defined in the system.
COMMISSION	Number	30,12	Optional	-	Entity Commission Amount
CHEQOPTYPE	String	1	Optional	-	0 – Cheque 3 – Demand Draft 4 – Outstation Cheques/DD 5 - Others
SYSREFERENCENumber	String	25	Mandatory	-	Unique Serial number
MICRCODE	String	40	-	-	Cheque MICR Code
AUTHTYPE	String	1	Mandatory	-	Could be either of the following values: "U" - Unauthorized "A" – Authorized
IBAN	String	36	Optional	-	Used to capture the IBAN