1.45 Pension Allocation Handoff

This topic provides detailed information on the Pension Allocation Handoff.

Table 1-166 Pension Allocation Handoff

Field name	Description	Datatype	Length	Table Name
SEQUENCENUMBER	Sequencenumber	NUMBER	10	PHALLOCDETAILSTAUPLOADHF
PROCESSID	Processid	VARCHAR2	50	PHALLOCDETAILSTAUPLOADHF
BULKCLIENTCODE	Bulkclientcode	VARCHAR2	12	PHALLOCDETAILSTAUPLOADHF
UPLOADMODE	Uploadmode	VARCHAR2	1	PHALLOCDETAILSTAUPLOADHF
IMPORTFILENAME	Importfilename	VARCHAR2	255	PHALLOCDETAILSTAUPLOADHF
USERREFERENCENUMBER	Userreferencenumber	VARCHAR2	16	PHALLOCDETAILSTAUPLOADHF
ORDERNUMBER	Ordernumber	VARCHAR2	16	PHALLOCDETAILSTAUPLOADHF
EXTERNALTXNNUMBER	Externaltxnnumber	VARCHAR2	16	PHALLOCDETAILSTAUPLOADHF
PARTYID	Partyid	VARCHAR2	12	PHALLOCDETAILSTAUPLOADHF
PORTFOLIOID	Portfolioid	VARCHAR2	16	PHALLOCDETAILSTAUPLOADHF
ACCOUNTID	Accountid	VARCHAR2	16	PHALLOCDETAILSTAUPLOADHF
INSTRUMENTID	Instrumentid	VARCHAR2	16	PHALLOCDETAILSTAUPLOADHF
ASSETID	Assetid	VARCHAR2	16	PHALLOCDETAILSTAUPLOADHF
ORDERAMOUNT	Orderamount	NUMBER	30	PHALLOCDETAILSTAUPLOADHF
LOADAMOUNT	Loadamount	NUMBER	30	PHALLOCDETAILSTAUPLOADHF
NETAMOUNT	Netamount	NUMBER	30	PHALLOCDETAILSTAUPLOADHF
SETTLEMENTAMT	Settlementamt	NUMBER	30	PHALLOCDETAILSTAUPLOADHF
NAV	Nav	NUMBER	17	PHALLOCDETAILSTAUPLOADHF
NAVDATE	Navdate	DATE	7	PHALLOCDETAILSTAUPLOADHF
ALLOTEDUNITS	Allotedunits	NUMBER	30	PHALLOCDETAILSTAUPLOADHF
ALLOCATIONDATE	Allocationdate	DATE	7	PHALLOCDETAILSTAUPLOADHF
FROMORTOLEG	Fromortoleg	VARCHAR2	1	PHALLOCDETAILSTAUPLOADHF
ORIGINALORDNUMBER	Originalordnumber	VARCHAR2	16	PHALLOCDETAILSTAUPLOADHF
ORDERTYPE	Ordertype	VARCHAR2	3	PHALLOCDETAILSTAUPLOADHF
STATUS	Status	VARCHAR2	2	PHALLOCDETAILSTAUPLOADHF
ERR_CODE	Err_Code	VARCHAR2	20	PHALLOCDETAILSTAUPLOADHF
ERRDESCRIPTION	Errdescription	VARCHAR2	255	PHALLOCDETAILSTAUPLOADHF
TATRANSACTIONDATE	Tatransactiondate	DATE	7	PHALLOCDETAILSTAUPLOADHF
BLOCKEDFLAG	Blockedflag	VARCHAR2	1	PHALLOCDETAILSTAUPLOADHF