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