1.34 Emergency Day Transaction Processing Upload

This topic provides information on Emergency Day Transaction Processing Upload.

This is used to capture emergency day transaction processing review.

Table 1-149 Emergency Day Transaction Processing Upload

Field Name (as expected in the file)	Data type	Field Length	Mandatory/Optional	Values
SEQUENCENUMBER	NUMBER		Mandatory	Sequence number
PROCESSID	VARCHAR2	50	Mandatory	Process ID
BULKCLIENTCODE	VARCHAR2	12	Mandatory	bulk client code
IMPORTFILENAME	VARCHAR2	255	Mandatory	import file name
KEYSTRING	VARCHAR2	50	Optional	key string
TRANSACTIONNUMBER	VARCHAR2	16	Mandatory	Transaction number
TRANSACTIONTYPE	VARCHAR2	2	Optional	Transaction type
REFTYPE	VARCHAR2	2	Optional	Ref type
FUNDID	VARCHAR2	6	Optional	Fund ID
AMCID	VARCHAR2	12	Optional	Amc ID
FUNDFAMILY	VARCHAR2	6	Optional	Fund family
TRANSACTIONDATE	DATE	7	Optional	Transaction date
NEWTRANSACTIONDATE	DATE	7	Optional	System derived transaction date considering Emergency day
PRICEDATE	DATE	7	Optional	Pricedate
NEWPRICEDATE	DATE	7	Optional	System derived pricedate considering Emergency day
PAYMENTDATE	DATE	7	Optional	Paymentdate
NEWPAYMENTDATE	DATE	7	Optional	System derived payment date considering Emergency day.
DEALINGDATE	DATE	7	Optional	Dealing date
NEWDEALINGDATE	DATE	7	Optional	System derived dealing date considering Emergency day.
FXDEALDATE	DATE	7	Optional	Fx deal date
NEWFXDEALDATE	DATE	7	Optional	System derived fxdeal date Considering Emergency day.
FXVALUEDATE	DATE	7	Optional	Fxvaluedate
NEWFXVALUEDATE	DATE	7	Optional	System derived fxvalue date considering Emergency day
PROCESSDATE	DATE	7	Optional	Date which is declared as Emergency day
USERID	VARCHAR2	320	Mandatory	User who reviewed the transactions
ACTION	VARCHAR2	1	Mandatory	Action performed on the review screen
MODULEID	VARCHAR2	30	Optional	Module ID
EXCHANGERATESTATUS	VARCHAR2	1	Optional	Exchange rate status
SETTLEMENTDUEDATE	DATE	7	Optional	Settlement due date
NEWSETTLEMENTDUEDATE	DATE	7	Optional	System derived Settlement due date considering Emergency day.