1.57.2 Portfolio Mapping Upload
This topic provides detailed information on the portfolio mapping upload.
Table 1-185 Portfolio Mapping Upload
| Field name | Description | Datatype | Length | Table Name | 
|---|---|---|---|---|
| SEGMENTID | Segmentid | VARCHAR2 | 20 | PATM_PARTYPORTFOLIOUPLOAD | 
| SEQUENCENUMBER | Sequencenumber | NUMBER | 22 | PATM_PARTYPORTFOLIOUPLOAD | 
| PROCESSID | Processid | VARCHAR2 | 50 | PATM_PARTYPORTFOLIOUPLOAD | 
| BULKCLIENTCODE | Bulkclientcode | VARCHAR2 | 12 | PATM_PARTYPORTFOLIOUPLOAD | 
| UPLOADMODE | Uploadmode | VARCHAR2 | 1 | PATM_PARTYPORTFOLIOUPLOAD | 
| IMPORTFILENAME | Importfilename | VARCHAR2 | 255 | PATM_PARTYPORTFOLIOUPLOAD | 
| PARTYROLE | Partyrole | VARCHAR2 | 12 | PATM_PARTYPORTFOLIOUPLOAD | 
| PARTYID | Partyid | VARCHAR2 | 12 | PATM_PARTYPORTFOLIOUPLOAD | 
| ACCOUNTID | Accountid | VARCHAR2 | 16 | PATM_PARTYPORTFOLIOUPLOAD | 
| MODULEID | Moduleid | VARCHAR2 | 30 | PATM_PARTYPORTFOLIOUPLOAD | 
| AUTH_STAT | Auth_Stat | VARCHAR2 | 1 | PATM_PARTYPORTFOLIOUPLOAD | 
| ONCE_AUT H | Once_Auth | VARCHAR2 | 1 | PATM_PARTYPORTFOLIOUPLOAD | 
| RECORD_S TAT | Record_Stat | VARCHAR2 | 1 | PATM_PARTYPORTFOLIOUPLOAD | 
| MOD_NO | Mod_No | NUMBER | 22 | PATM_PARTYPORTFOLIOUPLOAD | 
| MAKER_ID | Maker_Id | VARCHAR2 | 320 | PATM_PARTYPORTFOLIOUPLOAD | 
| MAKER_DT_STA MP | Maker_Dt_Stamp | DATE | 7 | PATM_PARTYPORTFOLIOUPLOAD | 
| CHECKER_ID | Checker_Id | VARCHAR2 | 320 | PATM_PARTYPORTFOLIOUPLOAD | 
| CHECKER_DT_STA MP | Checker_Dt_Stamp | DATE | 7 | PATM_PARTYPORTFOLIOUPLOAD | 
| SEGMENTID | Segmentid | VARCHAR2 | 20 | PATM_PARTYPORTFOLIOIDUPLOAD | 
| SEQUENCENUMBER | Sequencenumber | NUMBER | 22 | PATM_PARTYPORTFOLIOIDUPLOAD | 
| PROCESSID | Processid | VARCHAR2 | 50 | PATM_PARTYPORTFOLIOIDUPLOAD | 
| BULKCLIENTCODE | Bulkclientcode | VARCHAR2 | 12 | PATM_PARTYPORTFOLIOIDUPLOAD | 
| UPLOADMODE | Uploadmode | VARCHAR2 | 1 | PATM_PARTYPORTFOLIOIDUPLOAD | 
| IMPORTFILENAME | Importfilename | VARCHAR2 | 255 | PATM_PARTYPORTFOLIOIDUPLOAD | 
| PARTYROLE | Partyrole | VARCHAR2 | 12 | PATM_PARTYPORTFOLIOIDUPLOAD | 
| PARTYID | Partyid | VARCHAR2 | 12 | PATM_PARTYPORTFOLIOIDUPLOAD | 
| ACCOUNTID | Accountid | VARCHAR2 | 16 | PATM_PARTYPORTFOLIOIDUPLOAD | 
| PORTFOLIOID | Portfolioid | VARCHAR2 | 16 | PATM_PARTYPORTFOLIOIDUPLOAD | 
| SEGMENTID | Segmentid | VARCHAR2 | 20 | PATM_PARTYPORTFOLIOASSETUPLOAD | 
| SEQUENCENUMBER | Sequencenumber | NUMBER | 22 | PATM_PARTYPORTFOLIOASSETUPLOAD | 
| PROCESSID | Processid | VARCHAR2 | 50 | PATM_PARTYPORTFOLIOASSETUPLOAD | 
| BULKCLIENTCODE | Bulkclientcode | VARCHAR2 | 12 | PATM_PARTYPORTFOLIOASSETUPLOAD | 
| UPLOADMODE | Uploadmode | VARCHAR2 | 1 | PATM_PARTYPORTFOLIOASSETUPLOAD | 
| IMPORTFILENAME | Importfilename | VARCHAR2 | 255 | PATM_PARTYPORTFOLIOASSETUPLOAD | 
| PARTYROLE | Partyrole | VARCHAR2 | 12 | PATM_PARTYPORTFOLIOASSETUPLOAD | 
| PARTYID | Partyid | VARCHAR2 | 12 | PATM_PARTYPORTFOLIOASSETUPLOAD | 
| ACCOUNTID | Accountid | VARCHAR2 | 16 | PATM_PARTYPORTFOLIOASSETUPLOAD | 
| PORTFOLIOID | Portfolioid | VARCHAR2 | 16 | PATM_PARTYPORTFOLIOASSETUPLOAD | 
| INSTRUMENTID | Instrumentid | VARCHAR2 | 16 | PATM_PARTYPORTFOLIOASSETUPLOAD | 
| ASSETID | Assetid | VARCHAR2 | 12 | PATM_PARTYPORTFOLIOASSETUPLOAD | 
| RATIO | Ratio | NUMBER | 22 | PATM_PARTYPORTFOLIOASSETUPLOAD | 
| OVERRIDE | Override | VARCHAR2 | 1 | PATM_PARTYPORTFOLIOASSETUPLOAD | 
| SEGMENTID | Segmentid | VARCHAR2 | 20 | PATM_PARTYPFINSTASSETUPLOAD | 
| SEQUENCENUMBER | Sequencenumber | NUMBER | 22 | PATM_PARTYPFINSTASSETUPLOAD | 
| PROCESSID | Processid | VARCHAR2 | 50 | PATM_PARTYPFINSTASSETUPLOAD | 
| BULKCLIENTCODE | Bulkclientcode | VARCHAR2 | 12 | PATM_PARTYPFINSTASSETUPLOAD | 
| UPLOADMODE | Uploadmode | VARCHAR2 | 1 | PATM_PARTYPFINSTASSETUPLOAD | 
| IMPORTFILENAME | Importfilename | VARCHAR2 | 255 | PATM_PARTYPFINSTASSETUPLOAD | 
| PARTYROLE | Partyrole | VARCHAR2 | 12 | PATM_PARTYPFINSTASSETUPLOAD | 
| PARTYID | Party ID | VARCHAR2 | 12 | PATM_PARTYPFINSTASSETUPLOAD | 
| ACCOUNTID | Account ID | VARCHAR2 | 16 | PATM_PARTYPFINSTASSETUPLOAD | 
| PORTFOLIOID | Portfolio ID | VARCHAR2 | 16 | PATM_PARTYPFINSTASSETUPLOAD | 
| INSTRUMENTID | Instrument ID | VARCHAR2 | 16 | PATM_PARTYPFINSTASSETUPLOAD | 
| INSTRUMENTRATIO | Instrument Ratio | NUMBER | 22 | PATM_PARTYPFINSTASSETUPLOAD | 
Parent topic: Portfolio Mapping Upload