1.43.2 Pension Allocation Import from TA
This topic provides detailed information on Pension Allocation Import from TA.
Table 1-163 Pension Allocation Import from TA
| Field name | Description | Datatype | Length | Table Name |
|---|---|---|---|---|
| SEQUENCENUMBER | Sequencenumber | NUMBER | 10 | PATB_ALLOCDETAILSTAUPLOADHF |
| PROCESSID | Processid | VARCHAR2 | 50 | PATB_ALLOCDETAILSTAUPLOADHF |
| BULKCLIENTCODE | Bulkclientcode | VARCHAR2 | 12 | PATB_ALLOCDETAILSTAUPLOADHF |
| UPLOADMODE | Uploadmode | VARCHAR2 | 1 | PATB_ALLOCDETAILSTAUPLOADHF |
| IMPORTFILENAME | Importfilename | VARCHAR2 | 255 | PATB_ALLOCDETAILSTAUPLOADHF |
| USERREFERENCENUMBER | Userreferencenumber | VARCHAR2 | 16 | PATB_ALLOCDETAILSTAUPLOADHF |
| ORDERNUMBER | Ordernumber | VARCHAR2 | 16 | PATB_ALLOCDETAILSTAUPLOADHF |
| EXTERNALTXNNUMBER | Externaltxnnum ber | VARCHAR2 | 16 | PATB_ALLOCDETAILSTAUPLOADHF |
| PARTYID | Partyid | VARCHAR2 | 12 | PATB_ALLOCDETAILSTAUPLOADHF |
| PORTFOLIOID | Portfolioid | VARCHAR2 | 16 | PATB_ALLOCDETAILSTAUPLOADHF |
| ACCOUNTID | Accountid | VARCHAR2 | 16 | PATB_ALLOCDETAILSTAUPLOADHF |
| INSTRUMENTID | Instrumentid | VARCHAR2 | 16 | PATB_ALLOCDETAILSTAUPLOADHF |
| ASSETID | Assetid | VARCHAR2 | 16 | PATB_ALLOCDETAILSTAUPLOADHF |
| ORDER AMOUNT | Orderamount | NUMBER | 30 | PATB_ALLOCDETAILSTAUPLOADHF |
| LOADAMOUNT | Loadamount | NUMBER | 30 | PATB_ALLOCDETAILSTAUPLOADHF |
| NETAMOUNT | Netamount | NUMBER | 30 | PATB_ALLOCDETAILSTAUPLOADHF |
| SETTLEMENTAMT | Settlementamt | NUMBER | 30 | PATB_ALLOCDETAILSTAUPLOADHF |
| NAV | Nav | NUMBER | 17 | PATB_ALLOCDETAILSTAUPLOADHF |
| NAVDATE | Navdate | DATE | 7 | PATB_ALLOCDETAILSTAUPLOADHF |
| ALLOTEDUNITS | Allotedunits | NUMBER | 30 | PATB_ALLOCDETAILSTAUPLOADHF |
| ALLOCATIONDATE | Allocationdate | DATE | 7 | PATB_ALLOCDETAILSTAUPLOADHF |
| FROMORTOLEG | Fromortoleg | VARCHAR2 | 1 | PATB_ALLOCDETAILSTAUPLOADHF |
| ORIGINALORDNUMBER | Originalordnum ber | VARCHAR2 | 16 | PATB_ALLOCDETAILSTAUPLOADHF |
| ORDERTYPE | Ordertype | VARCHAR2 | 3 | PATB_ALLOCDETAILSTAUPLOADHF |
| STATUS | Status | VARCHAR2 | 2 | PATB_ALLOCDETAILSTAUPLOADHF |
| ERR_CODE | Err_Code | VARCHAR2 | 20 | PATB_ALLOCDETAILSTAUPLOADHF |
| ERRDESCRIPTION | Errdescription | VARCHAR2 | 255 | PATB_ALLOCDETAILSTAUPLOADHF |
| TATRANSACTIONDATE | Tatransactiondate | DATE | 7 | PATB_ALLOCDETAILSTAUPLOADHF |
| BLOCKEDFLAG | Blockedflag | VARCHAR2 | 1 | PATB_ALLOCDETAILSTAUPLOADHF |
Parent topic: Pension Allocation Import from TA