1.18.2 Cheque Book Request Upload Format

This topic provides information on cheque book request upload format.

Table 1-95 Cheque Book Request Upload Format

Field Name (as expected in the file)	Data type	Length	Attributes	Characteristics/rules	Values
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 operation which has to be performed on the record
AMCID	VARCHAR2	12	Mandatory	-	AMC ID
UNITHOLDERID	VARCHAR2	12	Mandatory	-	Unit Holder ID
FUNDID	VARCHAR2	6	Mandatory	-	Fund ID
ENTITYID	VARCHAR2	12	Mandatory	-	Entity ID
CHECKBOOKNUMBER	VARCHAR2	16	Mandatory	-	Check Book Number
STARTCHECKNUMBER	VARCHAR2	12	Mandatory	-	Start Check Number
ENDCHECKNUMBER	VARCHAR2	12	Mandatory	-	End Check Number
CHECKCURRENCY	VARCHAR2	3	Mandatory	-	Check Currency
USERID	VARCHAR2	320	Mandatory	-	Indicates the user ID who has entered the latest record
AUTH_STAT	VARCHAR2	1	Optional	-	This filed indicates where this particular record is authorized or not. A - Authorised U - Unauthorised
MOD_NO	NUMBER	10	Optional	-	Indicates the max number of times the record is modified.
RECORD_STAT	CHAR	1	Optional	-	Indicates whether the record is Open - O Closed - C
ONCE_AUTH	CHAR	1	Optional	-	Indicates whether the record was authorized at least once after its creation. Authorized(Y)/ Never Authorized( N)
STATUS	VARCHAR2	50	Optional	-	Indicates the Status. CHECKSTATUSMAINTAINED Check Status Maintained. CHECKBOOKAPPLIED Check Book Applied. CHECKBOOKEXHAUSTED Check Book Exhausted. SENTTOVENDOR Sent To Vendor. DISCREPANCYNOTICED Discrepancy Noticed. CANCELLED Check Cancelled.
REMARKS	VARCHAR2	200	Optional	-	Indicates the Remarks