1.37 Special Discount Upload

This topic provides information on Special Discount Upload.

This is used to capture special discount upload details:

Table 1-152 Special Discount Upload

Field or Column Name	Data type	Length	Table Name	Attributes
SEGMENTID	VARCHAR2	80	BULKSPECIALDISCMAINTTBL	Mandatory
SEQUENCENUMBER	NUMBER	22	BULKSPECIALDISCMAINTTBL	Mandatory
PROCESSID	VARCHAR2	5	BULKSPECIALDISCMAINTTBL	Mandatory
BULKCLIENTCODE	VARCHAR2	12	BULKSPECIALDISCMAINTTBL	Mandatory
IMPORTFILENAME	VARCHAR2	255	BULKSPECIALDISCMAINTTBL	Mandatory
UPLOADMODE	VARCHAR2	1	BULKSPECIALDISCMAINTTBL	Mandatory
FUNDTYPE	VARCHAR2	3	BULKSPECIALDISCMAINTTBL	Mandatory
UNITHOLDERID	VARCHAR2	12	BULKSPECIALDISCMAINTTBL	Mandatory
TRANSACTIONDATE	DATE	7	BULKSPECIALDISCMAINTTBL	Mandatory
TRANSACTIONCURRENCY	VARCHAR2	22	BULKSPECIALDISCMAINTTBL	Optional
CAMPAIGNCODE	VARCHAR2	12	BULKSPECIALDISCMAINTTBL	Mandatory
AUTH_STAT	VARCHAR2	1	BULKSPECIALDISCMAINTTBL	Optional
USERID	VARCHAR2	320	BULKSPECIALDISCMAINTTBL	Mandatory
ONCE_AUTH	CHAR	1	BULKSPECIALDISCMAINTTBL	Optional
MOD_NO	NUMBER	22	BULKSPECIALDISCMAINTTBL	Optional
RECORD_STAT	CHAR	1	BULKSPECIALDISCMAINTTBL	Optional