1.63.2 Investment Account Export
This topic provides detailed information on the Investment Account Export.
Table 1-197 Investment Account Export
| Field name | Description | Datatype | Length | Table Name |
|---|---|---|---|---|
| SEGMENTID | Segmentid | VARCHAR2 | 20 | PATB_PARTYMASTERINVEXPORT |
| SEQUENCENUMBER | Sequencenumber | NUMBER | 10 | PATB_PARTYMASTERINVEXPORT |
| PROCESSID | Processid | VARCHAR2 | 50 | PATB_PARTYMASTERINVEXPORT |
| BULKCLIENTCODE | Bulkclientcode | VARCHAR2 | 12 | PATB_PARTYMASTERINVEXPORT |
| UPLOADMODE | Uploadmode | VARCHAR2 | 1 | PATB_PARTYMASTERINVEXPORT |
| USERREFERENCENUMBER | Userreferencenumber | VARCHAR2 | 16 | PATB_PARTYMASTERINVEXPORT |
| PARTYID | Partyid | VARCHAR2 | 12 | PATB_PARTYMASTERINVEXPORT |
| PARTYTYPE | Partytype | VARCHAR2 | 3 | PATB_PARTYMASTERINVEXPORT |
| TITLE | Title | VARCHAR2 | 15 | PATB_PARTYMASTERINVEXPORT |
| FIRSTNAME | Firstname | VARCHAR2 | 100 | PATB_PARTYMASTERINVEXPORT |
| MIDDLENAME | Middlename | VARCHAR2 | 100 | PATB_PARTYMASTERINVEXPORT |
| LASTNAME | Lastname | VARCHAR2 | 100 | PATB_PARTYMASTERINVEXPORT |
| REGISTEREDNAME | Registeredname | VARCHAR2 | 100 | PATB_PARTYMASTERINVEXPORT |
| DATEOFBIRTH | Dateofbirth | DATE | 7 | PATB_PARTYMASTERINVEXPORT |
| DATEOFINCORPORATION | Dateofincorporation | DATE | 7 | PATB_PARTYMASTERINVEXPORT |
| MARITALSTATUS | Maritalstatus | VARCHAR2 | 1 | PATB_PARTYMASTERINVEXPORT |
| OCCUPATION | Occupation | VARCHAR2 | 3 | PATB_PARTYMASTERINVEXPORT |
| GENDER | Gender | VARCHAR2 | 1 | PATB_PARTYMASTERINVEXPORT |
| PREFERREDCURRENCY | Preferredcurrency | VARCHAR2 | 3 | PATB_PARTYMASTERINVEXPORT |
| MINOR | Minor | NUMBER | 1 | PATB_PARTYMASTERINVEXPORT |
| NATIONALITY | Nationality | VARCHAR2 | 3 | PATB_PARTYMASTERINVEXPORT |
| COUNTRYOFDOMICILE | Countryofdomicile | VARCHAR2 | 3 | PATB_PARTYMASTERINVEXPORT |
| COUNTRYOFBIRTH | Countryofbirth | VARCHAR2 | 3 | PATB_PARTYMASTERINVEXPORT |
| DUALNATIONALITY | Dualnationality | VARCHAR2 | 3 | PATB_PARTYMASTERINVEXPORT |
| SUBSTANTIALSTAYINUS | Substantialstayinus | NUMBER | 1 | PATB_PARTYMASTERINVEXPORT |
| HEALTHSTATUS | Healthstatus | VARCHAR2 | 1 | PATB_PARTYMASTERINVEXPORT |
| PROTECTIONLEVEL | Protectionlevel | VARCHAR2 | 1 | PATB_PARTYMASTERINVEXPORT |
| FIRSTAUTHORIZEDSIGNATORY | Firstauthor izedsignatory | VARCHAR2 | 100 | PATB_PARTYMASTERINVEXPORT |
| SECONDAUTHORIZEDSIGNATORY | Secondauthorizedsignatory | VARCHAR2 | 100 | PATB_PARTYMASTERINVEXPORT |
| THIRDAUTHORIZEDSIGNATORY | Thirdauthorizedsignatory | VARCHAR2 | 100 | PATB_PARTYMASTERINVEXPORT |
| CORPORATIONTYPE | Corporationtype | VARCHAR2 | 3 | PATB_PARTYMASTERINVEXPORT |
| MINNOOFCORPORATESIGNATOR Y | Minnoofcorporatesignatory | NUMBER | 22 | PATB_PARTYMASTERINVEXPORT |
| INCORPORATIONCOUNTRY | Incorporationcountry | VARCHAR2 | 3 | PATB_PARTYMASTERINVEXPORT |
| MODULEID | Moduleid | VARCHAR2 | 30 | PATB_PARTYMASTERINVEXPORT |
| MAKER_ID | Maker_Id | VARCHAR2 | 320 | PATB_PARTYMASTERINVEXPORT |
| MAKER_DT_STAM P | Maker_Dt_Stamp | DATE | 7 | PATB_PARTYMASTERINVEXPORT |
| CHECKER_ID | Checker_Id | VARCHAR2 | 320 | PATB_PARTYMASTERINVEXPORT |
| CHECKER_DT_STAM P | Checker_Dt_Stamp | DATE | 7 | PATB_PARTYMASTERINVEXPORT |
| AUTH_STAT | Auth_Stat | VARCHAR2 | 1 | PATB_PARTYMASTERINVEXPORT |
| ONCE_AUTH | Once_Auth | VARCHAR2 | 1 | PATB_PARTYMASTERINVEXPORT |
| RECORD_ST AT | Record_Stat | VARCHAR2 | 1 | PATB_PARTYMASTERINVEXPORT |
| MOD_NO | Mod_No | NUMBER | 22 | PATB_PARTYMASTERINVEXPORT |
| FATHERSPOUSENAM E | Fatherspousename | VARCHAR2 | 105 | PATB_PARTYMASTERINVEXPORT |
| SEGMENTID | Segmentid | VARCHAR2 | 20 | PATB_PARTYCONTACTINVEXPORT |
| SEQUENCENUMBER | Sequencenumber | NUMBER | 10 | PATB_PARTYCONTACTINVEXPORT |
| PROCESSID | Processid | VARCHAR2 | 50 | PATB_PARTYCONTACTINVEXPORT |
| USERREFERENCENUMBER | Userreferencenumber | VARCHAR2 | 16 | PATB_PARTYCONTACTINVEXPORT |
| PARTYID | Partyid | VARCHAR2 | 12 | PATB_PARTYCONTACTINVEXPORT |
| CONTACTREFNO | Contactrefno | VARCHAR2 | 16 | PATB_PARTYCONTACTINVEXPORT |
| ADDRESSTY PE | Addresstype | VARCHAR2 | 2 | PATB_PARTYCONTACTINVEXPORT |
| ADDRESSLINE1 | Addressline1 | VARCHAR2 | 100 | PATB_PARTYCONTACTINVEXPORT |
| ADDRESSLINE2 | Addressline2 | VARCHAR2 | 100 | PATB_PARTYCONTACTINVEXPORT |
| ADDRESSLINE3 | Addressline3 | VARCHAR2 | 100 | PATB_PARTYCONTACTINVEXPORT |
| POSTBOXNO | Postboxno | VARCHAR2 | 16 | PATB_PARTYCONTACTINVEXPORT |
| CITY | City | VARCHAR2 | 80 | PATB_PARTYCONTACTINVEXPORT |
| STATE | State | VARCHAR2 | 80 | PATB_PARTYCONTACTINVEXPORT |
| COUNTRY | Country | VARCHAR2 | 3 | PATB_PARTYCONTACTINVEXPORT |
| ZIPCODE | Zipcode | VARCHAR2 | 10 | PATB_PARTYCONTACTINVEXPORT |
| BICCODE | Biccode | VARCHAR2 | 16 | PATB_PARTYCONTACTINVEXPORT |
| WEBSITE | Website | VARCHAR2 | 100 | PATB_PARTYCONTACTINVEXPORT |
| EMAILADDRESS | Emailaddress | VARCHAR2 | 100 | PATB_PARTYCONTACTINVEXPORT |
| EFFECTIVEFROMDATE | Effectivefromdate | DATE | 7 | PATB_PARTYCONTACTINVEXPORT |
| EFFECTIVETODATE | Effectivetodate | DATE | 7 | PATB_PARTYCONTACTINVEXPORT |
| PRIMARYCONTACTPERSON | Primarycontactperson | VARCHAR2 | 100 | PATB_PARTYCONTACTINVEXPORT |
| PRIMARYINTERNDIALCODE1 | Primaryinterndialcode1 | VARCHAR2 | 10 | PATB_PARTYCONTACTINVEXPORT |
| PRIMARYINTERNDIALCODE2 | Primaryinterndialcode2 | VARCHAR2 | 10 | PATB_PARTYCONTACTINVEXPORT |
| PRIMARYINTERNDIALCODE3 | Primaryinterndialcode3 | VARCHAR2 | 10 | PATB_PARTYCONTACTINVEXPORT |
| PRIMARYINTERNDIALCODE4 | Primaryinterndialcode4 | VARCHAR2 | 10 | PATB_PARTYCONTACTINVEXPORT |
| PRIMARYPOSITION | Primaryposition | VARCHAR2 | 60 | PATB_PARTYCONTACTINVEXPORT |
| PRIMARYMOBILENUMBER1 | Primarymobilenumber1 | VARCHAR2 | 60 | PATB_PARTYCONTACTINVEXPORT |
| PRIMARYMOBILENUMBER2 | Primarymobilenumber2 | VARCHAR2 | 60 | PATB_PARTYCONTACTINVEXPORT |
| PRIMARYFIXEDLINE | Primaryfixedline | VARCHAR2 | 60 | PATB_PARTYCONTACTINVEXPORT |
| FAX | Fax | VARCHAR2 | 120 | PATB_PARTYCONTACTINVEXPORT |
| PRIMARYCONTACTINSTRN | Primarycontactinstrn | VARCHAR2 | 100 | PATB_PARTYCONTACTINVEXPORT |
| PRIMA RYEXTN | Primaryextn | VARCHAR2 | 60 | PATB_PARTYCONTACTINVEXPORT |
| SECONDARYCONTACTPERSON | Secondarycontactperson | VARCHAR2 | 100 | PATB_PARTYCONTACTINVEXPORT |
| SECONDARYINTERNDIALCODE1 | Secondaryinterndialcode1 | VARCHAR2 | 10 | PATB_PARTYCONTACTINVEXPORT |
| SECONDARYINTERNDIALCODE2 | Secondaryinterndialcode2 | VARCHAR2 | 10 | PATB_PARTYCONTACTINVEXPORT |
| SECONDARYPOSITION | Secondarypo sition | VARCHAR2 | 60 | PATB_PARTYCONTACTINVEXPORT |
| SECONDARYMOBILENUMBER | Secondarymobilenumber | VARCHAR2 | 60 | PATB_PARTYCONTACTINVEXPORT |
| SECONDARYFIXEDLINE | Secondaryfixedline | VARCHAR2 | 60 | PATB_PARTYCONTACTINVEXPORT |
| SECONDARYCONTACTINSTRN | Secondarycontactinstrn | VARCHAR2 | 105 | PATB_PARTYCONTACTINVEXPORT |
| SECONDARYEXTN | Secondaryextn | VARCHAR2 | 60 | PATB_PARTYCONTACTINVEXPORT |
| MODULEID | Moduleid | VARCHAR2 | 30 | PATB_PARTYCONTACTINVEXPORT |
| SEGMENTID | Segmentid | VARCHAR2 | 20 | PATB_PARTYIDINVEXPORT |
| SEQUENCENUMBER | Sequencenumber | NUMBER | 10 | PATB_PARTYIDINVEXPORT |
| PROCESSID | Processid | VARCHAR2 | 50 | PATB_PARTYIDINVEXPORT |
| USERREFERENCENUMBER | Userreferencenumber | VARCHAR2 | 16 | PATB_PARTYIDINVEXPORT |
| PARTYID | Partyid | VARCHAR2 | 12 | PATB_PARTYIDINVEXPORT |
| IDREFERENCENO | Idreferenceno | VARCHAR2 | 16 | PATB_PARTYIDINVEXPORT |
| IDENTIFICATIONTYPE | Identificationtype | VARCHAR2 | 20 | PATB_PARTYIDINVEXPORT |
| IDENTIFICATIONNUM BER | Identificationnumber | VARCHAR2 | 50 | PATB_PARTYIDINVEXPORT |
| PLACEOFISSUE | Placeofissue | VARCHAR2 | 3 | PATB_PARTYIDINVEXPORT |
| ISSUEAUTHORITY | Issueauthority | VARCHAR2 | 50 | PATB_PARTYIDINVEXPORT |
| ISSUECOUNTRY | Issuecountry | VARCHAR2 | 3 | PATB_PARTYIDINVEXPORT |
| DATEOFISSUE | Dateofissue | DATE | 7 | PATB_PARTYIDINVEXPORT |
| DATEOFEXPIRY | Dateofexpiry | DATE | 7 | PATB_PARTYIDINVEXPORT |
| LASTVERIFIEDDATE | Lastverifieddate | DATE | 7 | PATB_PARTYIDINVEXPORT |
| VERIFICATIONSTATUS | Verificationstatus | VARCHAR2 | 1 | PATB_PARTYIDINVEXPORT |
| MODULEID | Moduleid | VARCHAR2 | 30 | PATB_PARTYIDINVEXPORT |
| SEGMENTID | Segmentid | VARCHAR2 | 20 | PATB_INVACCMASTERINVEXPORT |
| SEQUENCENUMBER | Sequencenumber | NUMBER | 10 | PATB_INVACCMASTERINVEXPORT |
| PROCESSID | Processid | VARCHAR2 | 50 | PATB_INVACCMASTERINVEXPORT |
| USERREFERENCENUMBER | Userreferencenumber | VARCHAR2 | 16 | PATB_INVACCMASTERINVEXPORT |
| ACCOUNTID | Accountid | VARCHAR2 | 16 | PATB_INVACCMASTERINVEXPORT |
| ACOPERATIONTYPE | Acoperationtype | VARCHAR2 | 1 | PATB_INVACCMASTERINVEXPORT |
| DEALINGTYPE | Dealingtype | VARCHAR2 | 3 | PATB_INVACCMASTERINVEXPORT |
| GUARDIANID | Guardianid | VARCHAR2 | 12 | PATB_INVACCMASTERINVEXPORT |
| PARTYID | Partyid | VARCHAR2 | 12 | PATB_INVACCMASTERINVEXPORT |
| INVESTORCATEGORY | Investorcategory | VARCHAR2 | 2 | PATB_INVACCMASTERINVEXPORT |
| ACOPENINGDATE | Acopeningdate | DATE | 7 | PATB_INVACCMASTERINVEXPORT |
| ACCOUNTREFNO | Accountrefno | VARCHAR2 | 16 | PATB_INVACCMASTERINVEXPORT |
| MODULEID | Moduleid | VARCHAR2 | 30 | PATB_INVACCMASTERINVEXPORT |
| AUTH_STAT | Auth_Stat | VARCHAR2 | 1 | PATB_INVACCMASTERINVEXPORT |
| ONCE_AUTH | Once_Auth | VARCHAR2 | 1 | PATB_INVACCMASTERINVEXPORT |
| RECORD_ST AT | Record_Stat | VARCHAR2 | 1 | PATB_INVACCMASTERINVEXPORT |
| MOD_NO | Mod_No | NUMBER | 22 | PATB_INVACCMASTERINVEXPORT |
| MAKER_ID | Maker_Id | VARCHAR2 | 320 | PATB_INVACCMASTERINVEXPORT |
| MAKER_DT_STAM P | Maker_Dt_Stamp | DATE | 7 | PATB_INVACCMASTERINVEXPORT |
| CHECKER_ID | Checker_Id | VARCHAR2 | 320 | PATB_INVACCMASTERINVEXPORT |
| CHECKER_DT_STAM P | Checker_Dt_Stamp | DATE | 7 | PATB_INVACCMASTERINVEXPORT |
| ACCOUNTSTATUS | Accountstatus | VARCHAR2 | 1 | PATB_INVACCMASTERINVEXPORT |
| PENSIONACCOUNT | Pensionaccount | VARCHAR2 | 1 | PATB_INVACCMASTERINVEXPORT |
| ACCOUNTCLOSED | Accountclosed | VARCHAR2 | 1 | PATB_INVACCMASTERINVEXPORT |
| CHANGEDATE | Changedate | DATE | 7 | PATB_INVACCMASTERINVEXPORT |
| CHANGEREASON | Changereason | VARCHAR2 | 255 | PATB_INVACCMASTERINVEXPORT |
| CHANGEREFERENCENO | Changereferenceno | VARCHAR2 | 16 | PATB_INVACCMASTERINVEXPORT |
| SEGMENTID | Segmentid | VARCHAR2 | 20 | PATB_INVACCINTERINVEXPORT |
| SEQUENCENUMBER | Sequencenumber | NUMBER | 10 | PATB_INVACCINTERINVEXPORT |
| PROCESSID | Processid | VARCHAR2 | 50 | PATB_INVACCINTERINVEXPORT |
| USERREFERENCENUMBER | Userreferencenumber | VARCHAR2 | 16 | PATB_INVACCINTERINVEXPORT |
| ACCOUNTID | Accountid | VARCHAR2 | 16 | PATB_INVACCINTERINVEXPORT |
| INTERMEDIARYID | Intermediaryid | VARCHAR2 | 12 | PATB_INVACCINTERINVEXPORT |
| SPLITPERCENTAGE | Splitpercentage | NUMBER | 5 | PATB_INVACCINTERINVEXPORT |
| DEFAULTFLAG | Defaultflag | VARCHAR2 | 1 | PATB_INVACCINTERINVEXPORT |
| SEGMENTID | Segmentid | VARCHAR2 | 20 | PATB_PARTYBANKINVEXPORT |
| SEQUENCENUMBER | Sequencenumber | NUMBER | 10 | PATB_PARTYBANKINVEXPORT |
| PROCESSID | Processid | VARCHAR2 | 50 | PATB_PARTYBANKINVEXPORT |
| USERREFERENCENUMBER | Userreferencenumber | VARCHAR2 | 16 | PATB_PARTYBANKINVEXPORT |
| ACCOUNTID | Accountid | VARCHAR2 | 16 | PATB_PARTYBANKINVEXPORT |
| BANKREFERENCENO | Bankreferenceno | VARCHAR2 | 16 | PATB_PARTYBANKINVEXPORT |
| DIRECTDEB ITAPPLICABLE | Directdebitapplicable | VARCHAR2 | 1 | PATB_PARTYBANKINVEXPORT |
| DEFAULTFLAG | Defaultflag | VARCHAR2 | 1 | PATB_PARTYBANKINVEXPORT |
| ACCOUNTHO LDERNAME | Accountholdername | VARCHAR2 | 100 | PATB_PARTYBANKINVEXPORT |
| ACCOUNTTYPE | Accounttype | VARCHAR2 | 1 | PATB_PARTYBANKINVEXPORT |
| ACCOUNTCURRENCY | Accountcurrency | VARCHAR2 | 3 | PATB_PARTYBANKINVEXPORT |
| BANKCODE | Bankcode | VARCHAR2 | 12 | PATB_PARTYBANKINVEXPORT |
| BRANCHCODE | Branchcode | VARCHAR2 | 12 | PATB_PARTYBANKINVEXPORT |
| ACCOUNTNUMBER | Accountnum ber | VARCHAR2 | 20 | PATB_PARTYBANKINVEXPORT |
| IBAN | Iban | VARCHAR2 | 40 | PATB_PARTYBANKINVEXPORT |
| VERIFICATIONSTATUS | Verificationstatus | VARCHAR2 | 1 | PATB_PARTYBANKINVEXPORT |
| LASTVERIFIEDDATE | Lastverifieddate | DATE | 7 | PATB_PARTYBANKINVEXPORT |
| MODULEID | Moduleid | VARCHAR2 | 30 | PATB_PARTYBANKINVEXPORT |
| SEGMENTID | Segmentid | VARCHAR2 | 20 | PATB_INVESTACCBENFINVEXPORT |
| SEQUENCENUMBER | Sequencenumber | NUMBER | 10 | PATB_INVESTACCBENFINVEXPORT |
| PROCESSID | Processid | VARCHAR2 | 50 | PATB_INVESTACCBENFINVEXPORT |
| USERREFERENCENUMBER | Userreferencenumber | VARCHAR2 | 16 | PATB_INVESTACCBENFINVEXPORT |
| ACCOUNTID | Accountid | VARCHAR2 | 16 | PATB_INVESTACCBENFINVEXPORT |
| BENEFICIARYTYPE | Beneficiarytype | VARCHAR2 | 2 | PATB_INVESTACCBENFINVEXPORT |
| BENFPAR TYID | Benfpartyid | VARCHAR2 | 16 | PATB_INVESTACCBENFINVEXPORT |
| AWARDPERCENTAGE | Awardpercentage | NUMBER | 5 | PATB_INVESTACCBENFINVEXPORT |
| BENFPARTYNAME | Benfpartyname | VARCHAR2 | 100 | PATB_INVESTACCBENFINVEXPORT |
| DATEOFBIRTH | Dateofbirth | DATE | 7 | PATB_INVESTACCBENFINVEXPORT |
| COUNTRYOFBIRTH | Countryofbirth | VARCHAR2 | 3 | PATB_INVESTACCBENFINVEXPORT |
| COUNTRYOFDOMICILE | Countryofdomicile | VARCHAR2 | 3 | PATB_INVESTACCBENFINVEXPORT |
| GENDER | Gender | VARCHAR2 | 1 | PATB_INVESTACCBENFINVEXPORT |
| BENFIDTYPE | Benfidtype | VARCHAR2 | 20 | PATB_INVESTACCBENFINVEXPORT |
| BENFIDNUMBER | Benfidnumber | VARCHAR2 | 50 | PATB_INVESTACCBENFINVEXPORT |
| RELATIONSHIP | Relationship | VARCHAR2 | 70 | PATB_INVESTACCBENFINVEXPORT |
| ADDRESSLINE1 | Addressline1 | VARCHAR2 | 100 | PATB_INVESTACCBENFINVEXPORT |
| ADDRESSLINE2 | Addressline2 | VARCHAR2 | 100 | PATB_INVESTACCBENFINVEXPORT |
| CITY | City | VARCHAR2 | 80 | PATB_INVESTACCBENFINVEXPORT |
| STATE | State | VARCHAR2 | 80 | PATB_INVESTACCBENFINVEXPORT |
| COUNTRY | Country | VARCHAR2 | 3 | PATB_INVESTACCBENFINVEXPORT |
| ZIPCODE | Zipcode | VARCHAR2 | 10 | PATB_INVESTACCBENFINVEXPORT |
| VARCHAR2 | 100 | PATB_INVESTACCBENFINVEXPORT | ||
| PRIMARYMO BILENUMBER1 | Primarymobilenumber1 | VARCHAR2 | 60 | PATB_INVESTACCBENFINVEXPORT |
| PRIMARYMOBILENUMBER2 | Primarymobilenumber2 | VARCHAR2 | 60 | PATB_INVESTACCBENFINVEXPORT |
| PRIMARYFIXEDLINE | Primaryfixedline | VARCHAR2 | 60 | PATB_INVESTACCBENFINVEXPORT |
| FAX | Fax | VARCHAR2 | 120 | PATB_INVESTACCBENFINVEXPORT |
| CONTACTPERSON | Contactperson | VARCHAR2 | 100 | PATB_INVESTACCBENFINVEXPORT |
| BANK | Bank | VARCHAR2 | 12 | PATB_INVESTACCBENFINVEXPORT |
| BRANCH | Branch | VARCHAR2 | 12 | PATB_INVESTACCBENFINVEXPORT |
| ACCOUNTTYPE | Accounttype | VARCHAR2 | 1 | PATB_INVESTACCBENFINVEXPORT |
| ACCOUNTCURRENCY | Accountcurrency | VARCHAR2 | 3 | PATB_INVESTACCBENFINVEXPORT |
| ACCOUNTNUMBER | Accountnumber | VARCHAR2 | 20 | PATB_INVESTACCBENFINVEXPORT |
| ACCOUNTNAME | Accountname | VARCHAR2 | 100 | PATB_INVESTACCBENFINVEXPORT |
| IBAN | Iban | VARCHAR2 | 40 | PATB_INVESTACCBENFINVEXPORT |
Parent topic: Investment Account Export