1.42.2 Pension Order Import Upload
This topic explains the systematic instructions on pension order import upload.
Table 1-161 Pension Order Import Upload
| Field name | Description | Datatype | Length | Table Name |
|---|---|---|---|---|
| SEGMENTID | Segmentid | VARCHAR2 | 20 | PHORDERUP-LOADTBL |
| SEQUENCE-NUMBER | Sequencenumber | NUMBER | 10 | PHORDERUP-LOADTBL |
| PROCESSID | Processid | VARCHAR2 | 50 | PHORDERUP-LOADTBL |
| BULKCLI-ENTCODE | Bulkclientcode | VARCHAR2 | 12 | PHORDERUP-LOADTBL |
| UPLOAD-MODE | Uploadmode | VARCHAR2 | 1 | PHORDERUP-LOADTBL |
| USERREF-ERENCE-NUMBER | Userreferencenum-ber | VARCHAR2 | 16 | PHORDERUP-LOADTBL |
| ORDER-NUMBER | Ordernumber | VARCHAR2 | 16 | PHORDERUP-LOADTBL |
| REFEREN-CENUMBER | Referencenumber | VARCHAR2 | 16 | PHORDERUP-LOADTBL |
| PARTYID | Partyid | VARCHAR2 | 12 | PHORDERUP-LOADTBL |
| PORTFO-LIOID | Portfolioid | VARCHAR2 | 16 | PHORDERUP-LOADTBL |
| ACCOUNTID | Accountid | VARCHAR2 | 16 | PHORDERUP-LOADTBL |
| ORDERCUR-RENCY | Ordercurrency | VARCHAR2 | 3 | PHORDERUP-LOADTBL |
| ORDER-MODE | Ordermode | VARCHAR2 | 1 | PHORDERUP-LOADTBL |
| ORDER-VALUE | Ordervalue | NUMBER | 30 | PHORDERUP-LOADTBL |
| INSTRUC-TIONDATE | Instructiondate | DATE | 7 | PHORDERUP-LOADTBL |
| ORDER-TYPE | Ordertype | VARCHAR2 | 3 | PHORDERUP-LOADTBL |
| ORDERSUB-TYPE | Ordersubtype | VARCHAR2 | 3 | PHORDERUP-LOADTBL |
| PAYMENT-MODE | Paymentmode | VARCHAR2 | 2 | PHORDERUP-LOADTBL |
| GROSSOR-NET | Grossornet | VARCHAR2 | 1 | PHORDERUP-LOADTBL |
| MODULEID | Moduleid | VARCHAR2 | 30 | PHORDERUP-LOADTBL |
| ORDERSTA-TUS | Orderstatus | NUMBER | 2 | PHORDERUP-LOADTBL |
| ORIGIN-ALORDNUM-BER | Originalordnumber | VARCHAR2 | 16 | PHORDERUP-LOADTBL |
| ORIGINAL-REFNUM-BER | Originalrefnumber | VARCHAR2 | 16 | PHORDERUP-LOADTBL |
| AUTH_STAT | Auth_Stat | VARCHAR2 | 1 | PHORDERUP-LOADTBL |
| ONCE_AUT H | Once_Auth | VARCHAR2 | 1 | PHORDERUP-LOADTBL |
| RECORD_S TAT | Record_Stat | VARCHAR2 | 1 | PHORDERUP-LOADTBL |
| MOD_NO | Mod_No | NUMBER | 22 | PHORDERUP-LOADTBL |
| MAKER_ID | Maker_Id | VARCHAR2 | 320 | PHORDERUP-LOADTBL |
| MAK-ER_DT_STA MP | Maker_Dt_Stamp | DATE | 7 | PHORDERUP-LOADTBL |
| CHECK-ER_ID | Checker_Id | VARCHAR2 | 320 | PHORDERUP-LOADTBL |
| CHECK-ER_DT_STA MP | Checker_Dt_Stamp | DATE | 7 | PHORDERUP-LOADTBL |
| REMARKS | Remarks | VARCHAR2 | 255 | PHORDERUP-LOADTBL |
| SWIORDER-STATUS | Swiorderstatus | VARCHAR2 | 2 | PHORDERUP-LOADTBL |
| SEGMENTID | Segmentid | VARCHAR2 | 20 | PHORDERIN-STRUMENTUP-LOADTBL |
| SEQUENCE-NUMBER | Sequencenumber | NUMBER | 10 | PHORDERIN-STRUMENTUP-LOADTBL |
| PROCESSID | Processid | VARCHAR2 | 50 | PHORDERIN-STRUMENTUP-LOADTBL |
| USERREF-ERENCE-NUMBER | Userreferencenum-ber | VARCHAR2 | 16 | PHORDERIN-STRUMENTUP-LOADTBL |
| ORDER-NUMBER | Ordernumber | VARCHAR2 | 16 | PHORDERIN-STRUMENTUP-LOADTBL |
| INSTRU-MENTID | Instrumentid | VARCHAR2 | 16 | PHORDERIN-STRUMENTUP-LOADTBL |
| SPLITPER-CENTAGE | Splitpercentage | NUMBER | 5 | PHORDERIN-STRUMENTUP-LOADTBL |
| SEGMENTID | Segmentid | VARCHAR2 | 20 | PHORDERINSTAS-SETUPLOADTBL |
| SEQUENCE-NUMBER | Sequencenumber | NUMBER | 10 | PHORDERINSTAS-SETUPLOADTBL |
| PROCESSID | Processid | VARCHAR2 | 50 | PHORDERINSTAS-SETUPLOADTBL |
| USERREF-ERENCE-NUMBER | Userreferencenum-ber | VARCHAR2 | 16 | PHORDERINSTAS-SETUPLOADTBL |
| ORDER-NUMBER | Ordernumber | VARCHAR2 | 16 | PHORDERINSTAS-SETUPLOADTBL |
| INSTRU-MENTID | Instrumentid | VARCHAR2 | 16 | PHORDERINSTAS-SETUPLOADTBL |
| ASSETID | Assetid | VARCHAR2 | 16 | PHORDERINSTAS-SETUPLOADTBL |
| RATIO | Ratio | NUMBER | 5 | PHORDERINSTAS-SETUPLOADTBL |
| OVERRIDE | Override | VARCHAR2 | 1 | PHORDERINSTAS-SETUPLOADTBL |
| SEGMENTID | Segmentid | VARCHAR2 | 20 | PHORDERINTER-MEDIARYUP-LOADTBL |
| SEQUENCE-NUMBER | Sequencenumber | NUMBER | 10 | PHORDERINTER-MEDIARYUP-LOADTBL |
| PROCESSID | Processid | VARCHAR2 | 50 | PHORDERINTER-MEDIARYUP-LOADTBL |
| USERREF-ERENCE-NUMBER | Userreferencenum- ber | VARCHAR2 | 16 | PHORDERINTER-MEDIARYUP-LOADTBL |
| ORDER-NUMBER | Ordernumber | VARCHAR2 | 16 | PHORDERINTER-MEDIARYUP-LOADTBL |
| INTERMEDI-ARYID | Intermediaryid | VARCHAR2 | 12 | PHORDERINTER-MEDIARYUP-LOADTBL |
| SPLITPER-CENTAGE | Splitpercentage | NUMBER | 5 | PHORDERINTER-MEDIARYUP-LOADTBL |
| SEGMENTID | Segmentid | VARCHAR2 | 20 | PHORDERSET-TLEMENTUP-LOADTBL |
| SEQUENCE-NUMBER | Sequencenumber | NUMBER | 10 | PHORDERSET-TLEMENTUP-LOADTBL |
| PROCESSID | Processid | VARCHAR2 | 50 | PHORDERSET-TLEMENTUP-LOADTBL |
| USERREF-ERENCE-NUMBER | Userreferencenum- ber | VARCHAR2 | 16 | PHORDERSET-TLEMENTUP-LOADTBL |
| ORDER- NUMBER | Ordernumber | VARCHAR2 | 16 | PHORDERSET-TLEMENTUP-LOADTBL |
| PAYMEN-TREFNUM-BER | Paymentrefnumber | VARCHAR2 | 16 | PHORDERSET-TLEMENTUP-LOADTBL |
| BANKREF-ERENCENO | Bankreferenceno | VARCHAR2 | 16 | PHORDERSET-TLEMENTUP-LOADTBL |
| CHEQUE-DATE | Chequedate | DATE | 7 | PHORDERSET-TLEMENTUP-LOADTBL |
| CHEQUE-NUMBER | Chequenumber | VARCHAR2 | 20 | PHORDERSET-TLEMENTUP-LOADTBL |
| PAYMENTA-MOUNT | Paymentamount | NUMBER | 30 | PHORDERSET-TLEMENTUP-LOADTBL |
| PAIDDATE | Paiddate | DATE | 7 | PHORDERSET-TLEMENTUP-LOADTBL |
| SETTLED | Settled | VARCHAR2 | 1 | PHORDERSET-TLEMENTUP-LOADTBL |
| ACCOUNTH OLDER-NAME | Accountholdername | VARCHAR2 | 100 | PHORDERSET-TLEMENTUP-LOADTBL |
| ACCOUNT-TYPE | Accounttype | VARCHAR2 | 1 | PHORDERSET-TLEMENTUP-LOADTBL |
| ACCOUNT-CURRENCY | Accountcurrency | VARCHAR2 | 3 | PHORDERSET-TLEMENTUP-LOADTBL |
| BANKCODE | Bankcode | VARCHAR2 | 12 | PHORDERSET-TLEMENTUP-LOADTBL |
| BRANCH-CODE | Branchcode | VARCHAR2 | 12 | PHORDERSET-TLEMENTUP-LOADTBL |
| ACCOUNT-NUMBER | Accountnumber | VARCHAR2 | 20 | PHORDERSET-TLEMENTUP-LOADTBL |
| IBAN | Iban | VARCHAR2 | 40 | PHORDERSET-TLEMENTUP-LOADTBL |
| AUTOSET-TLEMENT | AUTOSETTLE-MENT | NUMBER | 1 | PHORDERSET-TLEMENTUP-LOADTBL |
| SETTLE-MENTDUE-DATE | SETTLEMENTDUE-DATE | DATE | 7 | PHORDERSET-TLEMENTUP-LOADTBL |
| SEGMENTID | Segmentid | VARCHAR2 | 20 | PHPARTYMAS-TERUPLOADTBL |
| SEQUENCE-NUMBER | Sequencenumber | NUMBER | 10 | PHPARTYMAS-TERUPLOADTBL |
| PROCESSID | Processid | VARCHAR2 | 50 | PHPARTYMAS-TERUPLOADTBL |
| USERREF-ERENCE-NUMBER | Userreferencenum-ber | VARCHAR2 | 16 | PHPARTYMAS-TERUPLOADTBL |
| PARTYID | Partyid | VARCHAR2 | 12 | PHPARTYMAS-TERUPLOADTBL |
| PARTYTYPE | Partytype | VARCHAR2 | 3 | PHPARTYMAS-TERUPLOADTBL |
| TITLE | Title | VARCHAR2 | 15 | PHPARTYMAS-TERUPLOADTBL |
| FIRSTNAME | Firstname | VARCHAR2 | 100 | PHPARTYMAS-TERUPLOADTBL |
| MIDDLE- NAME | Middlename | VARCHAR2 | 100 | PHPARTYMAS-TERUPLOADTBL |
| LASTNAME | Lastname | VARCHAR2 | 100 | PHPARTYMAS-TERUPLOADTBL |
| REGIS-TEREDNAM E | Registeredname | VARCHAR2 | 100 | PHPARTYMAS-TERUPLOADTBL |
| DATEOF-BIRTH | Dateofbirth | DATE | 7 | PHPARTYMAS-TERUPLOADTBL |
| DATEOFIN-CORPORA-TION | Dateofincorporation | DATE | 7 | PHPARTYMAS-TERUPLOADTBL |
| MARITAL-STATUS | Maritalstatus | VARCHAR2 | 1 | PHPARTYMAS-TERUPLOADTBL |
| OCCUPA-TION | Occupation | VARCHAR2 | 3 | PHPARTYMAS-TERUPLOADTBL |
| GENDER | Gender | VARCHAR2 | 1 | PHPARTYMAS-TERUPLOADTBL |
| PRE-FERRED-CURRENCY | Preferredcurrency | VARCHAR2 | 3 | PHPARTYMAS-TERUPLOADTBL |
| MINOR | Minor | NUMBER | 1 | PHPARTYMAS-TERUPLOADTBL |
| NATIONAL-ITY | Nationality | VARCHAR2 | 3 | PHPARTYMAS-TERUPLOADTBL |
| COUNTRY-OFDOMI-CILE | Countryofdomicile | VARCHAR2 | 3 | PHPARTYMAS-TERUPLOADTBL |
| COUNTRY-OFBIRTH | Countryofbirth | VARCHAR2 | 3 | PHPARTYMAS-TERUPLOADTBL |
| DUALNA-TIONALITY | Dualnationality | VARCHAR2 | 3 | PHPARTYMAS-TERUPLOADTBL |
| SUBSTAN-TIALSTAYI-NUS | Substantialstayinus | NUMBER | 1 | PHPARTYMAS-TERUPLOADTBL |
| HEALTHSTA-TUS | Healthstatus | VARCHAR2 | 1 | PHPARTYMAS-TERUPLOADTBL |
| PROTEC-TIONLEVEL | Protectionlevel | VARCHAR2 | 1 | PHPARTYMAS-TERUPLOADTBL |
| FIRSTAU-THORIZED-SIGNATORY | Firstauthorizedsig-natory | VARCHAR2 | 100 | PHPARTYMAS-TERUPLOADTBL |
| SECONDAU-THORIZED-SIGNATORY | Secondauthorized-signatory | VARCHAR2 | 100 | PHPARTYMAS-TERUPLOADTBL |
| THIRDAU-THORIZED-SIGNATORY | Thirdauthorizedsig-natory | VARCHAR2 | 100 | PHPARTYMAS-TERUPLOADTBL |
| CORPORA-TIONTYPE | Corporationtype | VARCHAR2 | 3 | PHPARTYMAS-TERUPLOADTBL |
| MINNOOF-CORPORA-TESIGNATO RY | Minnoofcorporates-ignatory | NUMBER | 22 | PHPARTYMAS-TERUPLOADTBL |
| INCORPO-RATION-COUNTRY | Incorporationcoun-try | VARCHAR2 | 3 | PHPARTYMAS-TERUPLOADTBL |
| MODULEID | Moduleid | VARCHAR2 | 30 | PHPARTYMAS-TERUPLOADTBL |
| MAKER_ID | Maker_Id | VARCHAR2 | 320 | PHPARTYMAS-TERUPLOADTBL |
| MAK-ER_DT_STAMP | Maker_Dt_Stamp | DATE | 7 | PHPARTYMAS-TERUPLOADTBL |
| CHECK-ER_ID | Checker_Id | VARCHAR2 | 320 | PHPARTYMAS-TERUPLOADTBL |
| CHECK-ER_DT_STA MP | Checker_Dt_Stamp | DATE | 7 | PHPARTYMAS-TERUPLOADTBL |
| AUTH_STAT | Auth_Stat | VARCHAR2 | 1 | PHPARTYMAS-TERUPLOADTBL |
| ONCE_AUTH | Once_Auth | VARCHAR2 | 1 | PHPARTYMAS-TERUPLOADTBL |
| RECORD_STAT | Record_Stat | VARCHAR2 | 1 | PHPARTYMAS-TERUPLOADTBL |
| MOD_NO | Mod_No | NUMBER | 22 | PHPARTYMAS-TERUPLOADTBL |
| FATHER-SPOUSENA ME | Fatherspousename | VARCHAR2 | 105 | PHPARTYMAS-TERUPLOADTBL |
| BULKCLI-ENTCODE | Bulkclientcode | VARCHAR2 | 12 | PHPARTYMAS-TERUPLOADTBL |
| UPLOAD-MODE | Uploadmode | VARCHAR2 | 1 | PHPARTYMAS-TERUPLOADTBL |
| SEGMENTID | Segmentid | VARCHAR2 | 20 | PHPARTYCON-TACTUPLOADTBL |
| SEQUENCE-NUMBER | Sequencenumber | NUMBER | 10 | PHPARTYCON-TACTUPLOADTBL |
| PROCESSID | Processid | VARCHAR2 | 50 | PHPARTYCON-TACTUPLOADTBL |
| USERREF-ERENCE-NUMBER | Userreferencenum-ber | VARCHAR2 | 16 | PHPARTYCON-TACTUPLOADTBL |
| PARTYID | Partyid | VARCHAR2 | 12 | PHPARTYCON-TACTUPLOADTBL |
| CONTAC-TREFNO | Contactrefno | VARCHAR2 | 16 | PHPARTYCON-TACTUPLOADTBL |
| ADDRESSTY PE | Addresstype | VARCHAR2 | 2 | PHPARTYCON-TACTUPLOADTBL |
| ADDRESS-LINE1 | Addressline1 | VARCHAR2 | 100 | PHPARTYCON-TACTUPLOADTBL |
| ADDRESS-LINE2 | Addressline2 | VARCHAR2 | 100 | PHPARTYCON-TACTUPLOADTBL |
| ADDRESS-LINE3 | Addressline3 | VARCHAR2 | 100 | PHPARTYCON-TACTUPLOADTBL |
| POST-BOXNO | Postboxno | VARCHAR2 | 16 | PHPARTYCON-TACTUPLOADTBL |
| CITY | City | VARCHAR2 | 80 | PHPARTYCON-TACTUPLOADTBL |
| STATE | State | VARCHAR2 | 80 | PHPARTYCON-TACTUPLOADTBL |
| COUNTRY | Country | VARCHAR2 | 3 | PHPARTYCON-TACTUPLOADTBL |
| ZIPCODE | Zipcode | VARCHAR2 | 10 | PHPARTYCON-TACTUPLOADTBL |
| BICCODE | Biccode | VARCHAR2 | 16 | PHPARTYCON-TACTUPLOADTBL |
| WEBSITE | Website | VARCHAR2 | 100 | PHPARTYCON-TACTUPLOADTBL |
| EMAILAD-DRESS | Emailaddress | VARCHAR2 | 100 | PHPARTYCON-TACTUPLOADTBL |
| EFFECTIVE-FROMDATE | Effectivefromdate | DATE | 7 | PHPARTYCON-TACTUPLOADTBL |
| EFFEC-TIVETO-DATE | Effectivetodate | DATE | 7 | PHPARTYCON-TACTUPLOADTBL |
| PRIMARY-CONTACT-PERSON | Primarycontactper-son | VARCHAR2 | 100 | PHPARTYCON-TACTUPLOADTBL |
| PRIMARYIN-TERNDIAL-CODE1 | Primaryinterndial-code1 | VARCHAR2 | 10 | PHPARTYCON-TACTUPLOADTBL |
| PRIMARYIN-TERNDIAL-CODE2 | Primaryinterndial-code2 | VARCHAR2 | 10 | PHPARTYCON-TACTUPLOADTBL |
| PRIMARYIN- TERNDIAL- CODE3 | Primaryinterndial-code3 | VARCHAR2 | 10 | PHPARTYCON-TACTUPLOADTBL |
| PRIMARYIN-TERNDIAL-CODE4 | Primaryinterndial-code4 | VARCHAR2 | 10 | PHPARTYCON-TACTUPLOADTBL |
| PRIMARY-POSITION | Primaryposition | VARCHAR2 | 60 | PHPARTYCON-TACTUPLOADTBL |
| PRIMARY-MOBILE-NUMBER1 | Primarymobilenum-ber1 | VARCHAR2 | 60 | PHPARTYCON-TACTUPLOADTBL |
| PRIMARY-MOBILE-NUMBER2 | Primarymobilenum-ber2 | VARCHAR2 | 60 | PHPARTYCON-TACTUPLOADTBL |
| PRIMARY-FIXEDLINE | Primaryfixedline | VARCHAR2 | 60 | PHPARTYCON-TACTUPLOADTBL |
| FAX | Fax | VARCHAR2 | 120 | PHPARTYCON-TACTUPLOADTBL |
| PRIMARY- CONTACTIN- STRN | Primarycontactin- strn | VARCHAR2 | 100 | PHPARTYCON-TACTUPLOADTBL |
| PRIMA- RYEXTN | Primaryextn | VARCHAR2 | 60 | PHPARTYCON-TACTUPLOADTBL |
| SECOND-ARYCON-TACTPERSON | Secondarycontact- person | VARCHAR2 | 100 | PHPARTYCON-TACTUPLOADTBL |
| SECOND-ARYINTERN-DIALCODE1 | Secondaryinterndi-alcode1 | VARCHAR2 | 10 | PHPARTYCON-TACTUPLOADTBL |
| SECOND-ARYINTERN-DIALCODE2 | Secondaryinterndi-alcode2 | VARCHAR2 | 10 | PHPARTYCON-TACTUPLOADTBL |
| SECOND-ARYPOSI-TION | Secondaryposition | VARCHAR2 | 60 | PHPARTYCON-TACTUPLOADTBL |
| SECONDA-RYMOBILE-NUMBER | Secondarymobile-number | VARCHAR2 | 60 | PHPARTYCON-TACTUPLOADTBL |
| SECOND-ARYFIXED-LINE | Secondaryfixedline | VARCHAR2 | 60 | PHPARTYCON-TACTUPLOADTBL |
| SECOND- ARYCON- TACTINSTR N | Secondarycontac-tinstrn | VARCHAR2 | 105 | PHPARTYCON-TACTUPLOADTBL |
| SECOND-ARYEXTN | Secondaryextn | VARCHAR2 | 60 | PHPARTYCON-TACTUPLOADTBL |
| MODULEID | Moduleid | VARCHAR2 | 30 | PHPARTYCON-TACTUPLOADTBL |
| SEGMENTID | Segmentid | VARCHAR2 | 20 | PHPARTYIDUP-LOADTBL |
| SEQUENCE-NUMBER | Sequencenumber | NUMBER | 10 | PHPARTYIDUP-LOADTBL |
| PROCESSID | Processid | VARCHAR2 | 50 | PHPARTYIDUP-LOADTBL |
| USERREF-ERENCE-NUMBER | Userreferencenum-ber | VARCHAR2 | 16 | PHPARTYIDUP-LOADTBL |
| PARTYID | Partyid | VARCHAR2 | 12 | PHPARTYIDUP-LOADTBL |
| IDREFEREN-CENO | Idreferenceno | VARCHAR2 | 16 | PHPARTYIDUP-LOADTBL |
| IDENTIFICA-TIONTYPE | Identificationtype | VARCHAR2 | 20 | PHPARTYIDUP-LOADTBL |
| IDENTIFICA-TIONNUM-BER | Identificationnumber | VARCHAR2 | 50 | PHPARTYIDUP-LOADTBL |
| PLACEOFIS-SUE | Placeofissue | VARCHAR2 | 3 | PHPARTYIDUP-LOADTBL |
| ISSUEAU-THORITY | Issueauthority | VARCHAR2 | 50 | PHPARTYIDUP-LOADTBL |
| ISSUE-COUNTRY | Issuecountry | VARCHAR2 | 3 | PHPARTYIDUP-LOADTBL |
| DATEOFIS-SUE | Dateofissue | DATE | 7 | PHPARTYIDUP-LOADTBL |
| DATEOFEX-PIRY | Dateofexpiry | DATE | 7 | PHPARTYIDUP-LOADTBL |
| LASTVERI-FIEDDATE | Lastverifieddate | DATE | 7 | PHPARTYIDUP-LOADTBL |
| VERIFICA-TIONSTA-TUS | Verificationstatus | VARCHAR2 | 1 | PHPARTYIDUP-LOADTBL |
| MODULEID | Moduleid | VARCHAR2 | 30 | PHPARTYIDUP-LOADTBL |
| SEGMENTID | Segmentid | VARCHAR2 | 20 | PHINVACCMAS-TERUPLOADTBL |
| SEQUENCE-NUMBER | Sequencenumber | NUMBER | 10 | PHINVACCMAS-TERUPLOADTBL |
| PROCESSID | Processid | VARCHAR2 | 50 | PHINVACCMAS-TERUPLOADTBL |
| USERREF-ERENCE-NUMBER | Userreferencenum-ber | VARCHAR2 | 16 | PHINVACCMAS-TERUPLOADTBL |
| ACCOUNTID | Accountid | VARCHAR2 | 16 | PHINVACCMAS-TERUPLOADTBL |
| ACOPERA-TIONTYPE | Acoperationtype | VARCHAR2 | 1 | PHINVACCMAS-TERUPLOADTBL |
| DEALING-TYPE | Dealingtype | VARCHAR2 | 3 | PHINVACCMAS-TERUPLOADTBL |
| GUARDI-ANID | Guardianid | VARCHAR2 | 12 | PHINVACCMAS-TERUPLOADTBL |
| PARTYID | Partyid | VARCHAR2 | 12 | PHINVACCMAS-TERUPLOADTBL |
| INVESTOR- CATEGORY | Investorcategory | VARCHAR2 | 2 | PHINVACCMAS-TERUPLOADTBL |
| ACOPEN- INGDATE | Acopeningdate | DATE | 7 | PHINVACCMAS-TERUPLOADTBL |
| ACCOUN- TREFNO | Accountrefno | VARCHAR2 | 16 | PHINVACCMAS-TERUPLOADTBL |
| MODULEID | Moduleid | VARCHAR2 | 30 | PHINVACCMAS-TERUPLOADTBL |
| AUTH_STAT | Auth_Stat | VARCHAR2 | 1 | PHINVACCMAS-TERUPLOADTBL |
| ONCE_AUT H | Once_Auth | VARCHAR2 | 1 | PHINVACCMAS-TERUPLOADTBL |
| RECORD_S TAT | Record_Stat | VARCHAR2 | 1 | PHINVACCMAS-TERUPLOADTBL |
| MOD_NO | Mod_No | NUMBER | 22 | PHINVACCMAS-TERUPLOADTBL |
| MAKER_ID | Maker_Id | VARCHAR2 | 320 | PHINVACCMAS-TERUPLOADTBL |
| MAK-ER_DT_STA MP | Maker_Dt_Stamp | DATE | 7 | PHINVACCMAS-TERUPLOADTBL |
| CHECK-ER_ID | Checker_Id | VARCHAR2 | 320 | PHINVACCMAS-TERUPLOADTBL |
| CHECK-ER_DT_STA MP | Checker_Dt_Stamp | DATE | 7 | PHINVACCMAS-TERUPLOADTBL |
| ACCOUNT-STATUS | Accountstatus | VARCHAR2 | 1 | PHINVACCMAS-TERUPLOADTBL |
| PENSION-ACCOUNT | Pensionaccount | VARCHAR2 | 1 | PHINVACCMAS-TERUPLOADTBL |
| ACCOUNT-CLOSED | Accountclosed | VARCHAR2 | 1 | PHINVACCMAS-TERUPLOADTBL |
| CHANGE-DATE | Changedate | DATE | 7 | PHINVACCMAS-TERUPLOADTBL |
| CHANG-EREASON | Changereason | VARCHAR2 | 255 | PHINVACCMAS-TERUPLOADTBL |
| CHANG-EREFEREN-CENO | Changereferenceno | VARCHAR2 | 16 | PHINVACCMAS-TERUPLOADTBL |
| SEGMENTID | Segmentid | VARCHAR2 | 20 | PHINVACCINTER-UPLOADTBL |
| SEQUENCE- NUMBER | Sequencenumber | NUMBER | 10 | PHINVACCINTER-UPLOADTBL |
| PROCESSID | Processid | VARCHAR2 | 50 | PHINVACCINTER-UPLOADTBL |
| USERREF-ERENCE-NUMBER | Userreferencenum-ber | VARCHAR2 | 16 | PHINVACCINTER-UPLOADTBL |
| ACCOUNTID | Accountid | VARCHAR2 | 16 | PHINVACCINTER-UPLOADTBL |
| INTERMEDI-ARYID | Intermediaryid | VARCHAR2 | 12 | PHINVACCINTER-UPLOADTBL |
| SPLITPER-CENTAGE | Splitpercentage | NUMBER | 5 | PHINVACCINTER-UPLOADTBL |
| DEFAULT-FLAG | Defaultflag | VARCHAR2 | 1 | PHINVACCINTER-UPLOADTBL |
| SEGMENTID | Segmentid | VARCHAR2 | 20 | PHINVACCBANK- UPLOADTBL |
| SEQUENCE-NUMBER | Sequencenumber | NUMBER | 10 | PHINVACCBANK- UPLOADTBL |
| PROCESSID | Processid | VARCHAR2 | 50 | PHINVACCBANK- UPLOADTBL |
| USERREF-ERENCE-NUMBER | Userreferencenum- ber | VARCHAR2 | 16 | PHINVACCBANK- UPLOADTBL |
| ACCOUNTID | Accountid | VARCHAR2 | 16 | PHINVACCBANK- UPLOADTBL |
| BANKREF-ERENCENO | Bankreferenceno | VARCHAR2 | 16 | PHINVACCBANK- UPLOADTBL |
| DIRECTDEB-ITAPPLICA-BLE | Directdebitapplica-ble | VARCHAR2 | 1 | PHINVACCBANK- UPLOADTBL |
| DEFAULT-FLAG | Defaultflag | VARCHAR2 | 1 | PHINVACCBANK- UPLOADTBL |
| ACCOUNTH OLDER-NAME | Accountholdername | VARCHAR2 | 100 | PHINVACCBANK- UPLOADTBL |
| ACCOUNT-TYPE | Accounttype | VARCHAR2 | 1 | PHINVACCBANK- UPLOADTBL |
| ACCOUNT-CURRENCY | Accountcurrency | VARCHAR2 | 3 | PHINVACCBANK- UPLOADTBL |
| BANKCODE | Bankcode | VARCHAR2 | 12 | PHINVACCBANK- UPLOADTBL |
| BRANCH-CODE | Branchcode | VARCHAR2 | 12 | PHINVACCBANK- UPLOADTBL |
| ACCOUNT-NUMBER | Accountnumber | VARCHAR2 | 20 | PHINVACCBANK- UPLOADTBL |
| IBAN | Iban | VARCHAR2 | 40 | PHINVACCBANK- UPLOADTBL |
| VERIFICA-TIONSTA-TUS | Verificationstatus | VARCHAR2 | 1 | PHINVACCBANK- UPLOADTBL |
| LASTVERI-FIEDDATE | Lastverifieddate | DATE | 7 | PHINVACCBANK- UPLOADTBL |
| MODULEID | Moduleid | VARCHAR2 | 30 | PHINVACCBANK- UPLOADTBL |
| SEGMENTID | Segmentid | VARCHAR2 | 20 | PHINVESTAC-CBENFUP-LOADTBL |
| SEQUENCE-NUMBER | Sequencenumber | NUMBER | 10 | PHINVESTAC-CBENFUP-LOADTBL |
| PROCESSID | Processid | VARCHAR2 | 50 | PHINVESTAC-CBENFUP-LOADTBL |
| USERREF-ERENCE-NUMBER | Userreferencenum- ber | VARCHAR2 | 16 | PHINVESTAC-CBENFUP-LOADTBL |
| ACCOUNTID | Accountid | VARCHAR2 | 16 | PHINVESTAC-CBENFUP-LOADTBL |
| BENEFI-CIARYTYPE | Beneficiarytype | VARCHAR2 | 2 | PHINVESTAC-CBENFUP-LOADTBL |
| BENFPAR-TYID | Benfpartyid | VARCHAR2 | 16 | PHINVESTAC-CBENFUP-LOADTBL |
| AWARDPER-CENTAGE | Awardpercentage | NUMBER | 5 | PHINVESTAC-CBENFUP-LOADTBL |
| BENFPAR-TYNAME | Benfpartyname | VARCHAR2 | 100 | PHINVESTAC-CBENFUP-LOADTBL |
| DATEOF-BIRTH | Dateofbirth | DATE | 7 | PHINVESTAC-CBENFUP-LOADTBL |
| COUNTRY-OFBIRTH | Countryofbirth | VARCHAR2 | 3 | PHINVESTAC-CBENFUP-LOADTBL |
| COUNTRY-OFDOMI-CILE | Countryofdomicile | VARCHAR2 | 3 | PHINVESTAC-CBENFUP-LOADTBL |
| GENDER | Gender | VARCHAR2 | 1 | PHINVESTAC-CBENFUP-LOADTBL |
| IDENTIFICA-TIONTYPE | Identificationtype | VARCHAR2 | 20 | PHINVESTAC-CBENFUP-LOADTBL |
| IDENTIFICA-TIONNUM-BER | Identificationnumber | VARCHAR2 | 50 | PHINVESTAC-CBENFUP-LOADTBL |
| RELATION-SHIP | Relationship | VARCHAR2 | 70 | PHINVESTAC-CBENFUP-LOADTBL |
| ADDRESS-LINE1 | Addressline1 | VARCHAR2 | 100 | PHINVESTAC-CBENFUP-LOADTBL |
| ADDRESS-LINE2 | Addressline2 | VARCHAR2 | 100 | PHINVESTAC-CBENFUP-LOADTBL |
| CITY | City | VARCHAR2 | 80 | PHINVESTAC-CBENFUP-LOADTBL |
| STATE | State | VARCHAR2 | 80 | PHINVESTAC-CBENFUP-LOADTBL |
| COUNTRY | Country | VARCHAR2 | 3 | PHINVESTAC-CBENFUP-LOADTBL |
| ZIPCODE | Zipcode | VARCHAR2 | 10 | PHINVESTAC-CBENFUP-LOADTBL |
| EMAILAD-DRESS | Emailaddress | VARCHAR2 | 100 | PHINVESTAC-CBENFUP-LOADTBL |
| PRIMARY-MOBILE-NUMBER1 | Primarymobilenum-ber1 | VARCHAR2 | 60 | PHINVESTAC-CBENFUP-LOADTBL |
| PRIMARY-MOBILE-NUMBER2 | Primarymobilenum-ber2 | VARCHAR2 | 60 | PHINVESTAC-CBENFUP-LOADTBL |
| PRIMARY-FIXEDLINE | Primaryfixedline | VARCHAR2 | 60 | PHINVESTAC-CBENFUP-LOADTBL |
| FAX | Fax | VARCHAR2 | 120 | PHINVESTAC-CBENFUP-LOADTBL |
| CONTACT-PERSON | Contactperson | VARCHAR2 | 100 | PHINVESTAC-CBENFUP-LOADTBL |
| BANKCODE | Bankcode | VARCHAR2 | 12 | PHINVESTAC-CBENFUP-LOADTBL |
| BRANCH-CODE | Branchcode | VARCHAR2 | 12 | PHINVESTAC-CBENFUP-LOADTBL |
| ACCOUNT-TYPE | Accounttype | VARCHAR2 | 1 | PHINVESTAC-CBENFUP-LOADTBL |
| ACCOUNT-CURRENCY | Accountcurrency | VARCHAR2 | 3 | PHINVESTAC-CBENFUP-LOADTBL |
| ACCOUNT-NUMBER | Accountnumber | VARCHAR2 | 20 | PHINVESTAC-CBENFUP-LOADTBL |
| ACCOUNT-NAME | Accountname | VARCHAR2 | 100 | PHINVESTAC-CBENFUP-LOADTBL |
| IBAN | Iban | VARCHAR2 | 40 | PHINVESTAC-CBENFUP-LOADTBL |
| DESIGNA-TION | Designation | VARCHAR2 | 100 | PHINVESTAC-CBENFUP-LOADTBL |
| CON-TROLLING-PERSON | Controllingperson | VARCHAR2 | 1 | PHINVESTAC-CBENFUP-LOADTBL |
| SEGMENTID | Segmentid | VARCHAR2 | 20 | PHORDERALLOC-DETUPLOADTBL |
| SEQUENCE-NUMBER | Sequencenumber | NUMBER | 10 | PHORDERALLOC-DETUPLOADTBL |
| PROCESSID | Processid | VARCHAR2 | 50 | PHORDERALLOC-DETUPLOADTBL |
| USERREF-ERENCE-NUMBER | Userreferencenum- ber | VARCHAR2 | 16 | PHORDERALLOC-DETUPLOADTBL |
| ORDER-NUMBER | Ordernumber | VARCHAR2 | 16 | PHORDERALLOC-DETUPLOADTBL |
| EXTERNAL-TXNNUM-BER | Externaltxnnumber | VARCHAR2 | 16 | PHORDERALLOC-DETUPLOADTBL |
| PARTYID | Partyid | VARCHAR2 | 12 | PHORDERALLOC-DETUPLOADTBL |
| PORTFO-LIOID | Portfolioid | VARCHAR2 | 16 | PHORDERALLOC-DETUPLOADTBL |
| ACCOUNTID | Accountid | VARCHAR2 | 16 | PHORDERALLOC-DETUPLOADTBL |
| INSTRU-MENTID | Instrumentid | VARCHAR2 | 16 | PHORDERALLOC-DETUPLOADTBL |
| ASSETID | Assetid | VARCHAR2 | 16 | PHORDERALLOC-DETUPLOADTBL |
| ORDER-AMOUNT | Orderamount | NUMBER | 30 | PHORDERALLOC-DETUPLOADTBL |
| LOADA-MOUNT | Loadamount | NUMBER | 30 | PHORDERALLOC-DETUPLOADTBL |
| NETA-MOUNT | Netamount | NUMBER | 30 | PHORDERALLOC-DETUPLOADTBL |
| SETTLE-MENTAMT | Settlementamt | NUMBER | 30 | PHORDERALLOC-DETUPLOADTBL |
| NAV | Nav | NUMBER | 17 | PHORDERALLOC-DETUPLOADTBL |
| NAVDATE | Navdate | DATE | 7 | PHORDERALLOC-DETUPLOADTBL |
| ALLOTE-DUNITS | Allotedunits | NUMBER | 30 | PHORDERALLOC-DETUPLOADTBL |
| ALLOCA-TIONDATE | Allocationdate | DATE | 7 | PHORDERALLOC-DETUPLOADTBL |
| FROMORTO-LEG | Fromortoleg | VARCHAR2 | 1 | PHORDERALLOC-DETUPLOADTBL |
| ORIGIN-ALORDNUM-BER | Originalordnumber | VARCHAR2 | 16 | PHORDERALLOC-DETUPLOADTBL |
| ORDER-TYPE | Ordertype | VARCHAR2 | 3 | PHORDERALLOC-DETUPLOADTBL |
| STATUS | Status | VARCHAR2 | 2 | PHORDERALLOC-DETUPLOADTBL |
| ERR_CODE | Err_Code | VARCHAR2 | 20 | PHORDERALLOC-DETUPLOADTBL |
| ERRDE-SCRIPTION | Errdescription | VARCHAR2 | 255 | PHORDERALLOC-DETUPLOADTBL |
| TATRANS-ACTION-DATE | Tatransactiondate | DATE | 7 | PHORDERALLOC-DETUPLOADTBL |
| BLOCKED-FLAG | Blockedflag | VARCHAR2 | 1 | PHORDERALLOC-DETUPLOADTBL |
Parent topic: Pension Order Import