1.56.2 Investment Account Upload
This topic provides detailed information on the Investment Account Upload.
Table 1-183 Investment Account Upload
| Field name | Description | Datatype | Length | Table Name |
|---|---|---|---|---|
| SEGMENTID | Segmentid | VARCHAR2 | 20 | PATM_INVESTMENTACCMASTERUPLOAD |
| SEQUENCENUMBER | Sequencenumber | NUMBER | 22 | PATM_INVESTMENTACCMASTERUPLOAD |
| PROCESSID | Processid | VARCHAR2 | 50 | PATM_INVESTMENTACCMASTERUPLOAD |
| BULKCLIENTCODE | Bulkclientcode | VARCHAR2 | 12 | PATM_INVESTMENTACCMASTERUPLOAD |
| UPLOADMODE | Uploadmode | VARCHAR2 | 1 | PATM_INVESTMENTACCMASTERUPLOAD |
| IMPORTFILENAME | Importfilename | VARCHAR2 | 255 | PATM_INVESTMENTACCMASTERUPLOAD |
| ACCOUNTID | Accountid | VARCHAR2 | 16 | PATM_INVESTMENTACCMASTERUPLOAD |
| ACOPERATIONTYPE | Acoperationtype | VARCHAR2 | 1 | PATM_INVESTMENTACCMASTERUPLOAD |
| DEALINGTYPE | Dealingtype | VARCHAR2 | 3 | PATM_INVESTMENTACCMASTERUPLOAD |
| GUARDIANID | Guardianid | VARCHAR2 | 12 | PATM_INVESTMENTACCMASTERUPLOAD |
| PARTYID | Partyid | VARCHAR2 | 12 | PATM_INVESTMENTACCMASTERUPLOAD |
| INVESTORCATEGORY | Investorcategory | VARCHAR2 | 2 | PATM_INVESTMENTACCMASTERUPLOAD |
| ACOPENINGDATE | Acopeningdate | DATE | 7 | PATM_INVESTMENTACCMASTERUPLOAD |
| ACCOUNTREFNO | Accountrefno | VARCHAR2 | 16 | PATM_INVESTMENTACCMASTERUPLOAD |
| MODULEID | Moduleid | VARCHAR2 | 30 | PATM_INVESTMENTACCMASTERUPLOAD |
| AUTH_STAT | Auth_Stat | VARCHAR2 | 1 | PATM_INVESTMENTACCMASTERUPLOAD |
| ONCE_AUT H | Once_Auth | VARCHAR2 | 1 | PATM_INVESTMENTACCMASTERUPLOAD |
| RECORD_S TAT | Record_Stat | VARCHAR2 | 1 | PATM_INVESTMENTACCMASTERUPLOAD |
| MOD_NO | Mod_No | NUMBER | 22 | PATM_INVESTMENTACCMASTERUPLOAD |
| MAKER_ID | Maker_Id | VARCHAR2 | 320 | PATM_INVESTMENTACCMASTERUPLOAD |
| MAKER_DT_STAMP | Maker_Dt_Stamp | DATE | 7 | PATM_INVESTMENTACCMASTERUPLOAD |
| CHECKER_ID | Checker_Id | VARCHAR2 | 320 | PATM_INVESTMENTACCMASTERUPLOAD |
| CHECKER_DT_STA MP | Checker_Dt_Stamp | DATE | 7 | PATM_INVESTMENTACCMASTERUPLOAD |
| ACCOUNTSTATUS | Accountstatus | VARCHAR2 | 1 | PATM_INVESTMENTACCMASTERUPLOAD |
| PENSIONACCOUNT | Pensionaccount | VARCHAR2 | 1 | PATM_INVESTMENTACCMASTERUPLOAD |
| SEGMENTID | Segmentid | VARCHAR2 | 20 | PATM_INVESTACCINTERUPLOAD |
| SEQUENCENUMBER | Sequencenumber | NUMBER | 22 | PATM_INVESTACCINTERUPLOAD |
| PROCESSID | Processid | VARCHAR2 | 50 | PATM_INVESTACCINTERUPLOAD |
| BULKCLIENTCODE | Bulkclientcode | VARCHAR2 | 12 | PATM_INVESTACCINTERUPLOAD |
| UPLOADMODE | Uploadmode | VARCHAR2 | 1 | PATM_INVESTACCINTERUPLOAD |
| IMPORTFILENAME | Importfilename | VARCHAR2 | 255 | PATM_INVESTACCINTERUPLOAD |
| ACCOUNTID | Accountid | VARCHAR2 | 16 | PATM_INVESTACCINTERUPLOAD |
| INTERMEDIARYID | Intermediaryid | VARCHAR2 | 12 | PATM_INVESTACCINTERUPLOAD |
| SPLITPERCENTAGE | Splitpercentage | NUMBER | 22 | PATM_INVESTACCINTERUPLOAD |
| DEFAULTFLAG | Defaultflag | VARCHAR2 | 1 | PATM_INVESTACCINTERUPLOAD |
Parent topic: Investment Account Upload