1.60.2 Party Main Upload
This topic provides detailed information on the on party main upload.
Table 1-192 Party Main Upload
| Field name | Description | Datatype | Length | Table Name |
|---|---|---|---|---|
| SEGMENTID | Segmentid | VARCHAR2 | 20 | PATM_PARTYMASTERUPLOAD |
| SEQUENCENUMBER | Sequencenumber | NUMBER | 22 | PATM_PARTYMASTERUPLOAD |
| PROCESSID | Processid | VARCHAR2 | 50 | PATM_PARTYMASTERUPLOAD |
| BULKCLIENTCODE | Bulkclientcode | VARCHAR2 | 12 | PATM_PARTYMASTERUPLOAD |
| UPLOADMODE | Uploadmode | VARCHAR2 | 1 | PATM_PARTYMASTERUPLOAD |
| IMPORTFILENAME | Importfilename | VARCHAR2 | 255 | PATM_PARTYMASTERUPLOAD |
| PARTYID | Partyid | VARCHAR2 | 12 | PATM_PARTYMASTERUPLOAD |
| PARTYTYPE | Partytype | VARCHAR2 | 3 | PATM_PARTYMASTERUPLOAD |
| TITLE | Title | VARCHAR2 | 15 | PATM_PARTYMASTERUPLOAD |
| FIRSTNAME | Firstname | VARCHAR2 | 100 | PATM_PARTYMASTERUPLOAD |
| MIDDLENAME | Middlename | VARCHAR2 | 100 | PATM_PARTYMASTERUPLOAD |
| LASTNAME | Lastname | VARCHAR2 | 100 | PATM_PARTYMASTERUPLOAD |
| REGISTEREDNAME | Registeredname | VARCHAR2 | 100 | PATM_PARTYMASTERUPLOAD |
| DATEOFBIRTH | Dateofbirth | DATE | 7 | PATM_PARTYMASTERUPLOAD |
| DATEOFINCORPORATION | Dateofincorporation | DATE | 7 | PATM_PARTYMASTERUPLOAD |
| MARITALSTATUS | Maritalstatus | VARCHAR2 | 1 | PATM_PARTYMASTERUPLOAD |
| OCCUPATION | Occupation | VARCHAR2 | 3 | PATM_PARTYMASTERUPLOAD |
| GENDER | Gender | VARCHAR2 | 1 | PATM_PARTYMASTERUPLOAD |
| PREFERREDCURRENCY | Preferredcurrency | VARCHAR2 | 3 | PATM_PARTYMASTERUPLOAD |
| MINOR | Minor | NUMBER | 1 | PATM_PARTYMASTERUPLOAD |
| NATIONALITY | Nationality | VARCHAR2 | 3 | PATM_PARTYMASTERUPLOAD |
| COUNTRYOFDOMICILE | Countryofdomicile | VARCHAR2 | 3 | PATM_PARTYMASTERUPLOAD |
| COUNTRYOFBIRTH | Countryofbirth | VARCHAR2 | 3 | PATM_PARTYMASTERUPLOAD |
| DUALNATIONALITY | Dualnationality | VARCHAR2 | 3 | PATM_PARTYMASTERUPLOAD |
| SUBSTANTIALSTAYINUS | Substantialstayinus | NUMBER | 1 | PATM_PARTYMASTERUPLOAD |
| HEALTHSTATUS | Healthstatus | VARCHAR2 | 1 | PATM_PARTYMASTERUPLOAD |
| PROTECTIONLEVEL | Protectionlevel | VARCHAR2 | 1 | PATM_PARTYMASTERUPLOAD |
| FIRSTAUTHORIZEDSIGNATORY | Firstauthorizedsignatory | VARCHAR2 | 100 | PATM_PARTYMASTERUPLOAD |
| SECONDAUTHORIZEDSIGNATORY | Secondauthorizedsignatory | VARCHAR2 | 100 | PATM_PARTYMASTERUPLOAD |
| THIRDAUTHORIZEDSIGNATORY | Thirdauthorizedsignatory | VARCHAR2 | 100 | PATM_PARTYMASTERUPLOAD |
| CORPORATIONTYPE | Corporationtype | VARCHAR2 | 3 | PATM_PARTYMASTERUPLOAD |
| MINNOOFCORPORATESIGNATOR Y | Minnoofcorporatesignatory | NUMBER | 22 | PATM_PARTYMASTERUPLOAD |
| INCORPORATIONCOUNTRY | Incorporationcountry | VARCHAR2 | 3 | PATM_PARTYMASTERUPLOAD |
| MODULEID | Moduleid | VARCHAR2 | 30 | PATM_PARTYMASTERUPLOAD |
| MAKER_ID | Maker_Id | VARCHAR2 | 320 | PATM_PARTYMASTERUPLOAD |
| MAKER_DT_STAM P | Maker_Dt_Stamp | DATE | 7 | PATM_PARTYMASTERUPLOAD |
| CHECKER_ID | Checker_Id | VARCHAR2 | 320 | PATM_PARTYMASTERUPLOAD |
| CHECKER_DT_STAM P | Checker_Dt_Stamp | DATE | 7 | PATM_PARTYMASTERUPLOAD |
| AUTH_STAT | Auth_Stat | VARCHAR2 | 1 | PATM_PARTYMASTERUPLOAD |
| ONCE_AUTH | Once_Auth | VARCHAR2 | 1 | PATM_PARTYMASTERUPLOAD |
| RECORD_STA T | Record_Stat | VARCHAR2 | 1 | PATM_PARTYMASTERUPLOAD |
| MOD_NO | Mod_No | NUMBER | 22 | PATM_PARTYMASTERUPLOAD |
| FATHERSPOUSENAME | Fatherspousename | VARCHAR2 | 105 | PATM_PARTYMASTERUPLOAD |
| SEGMENTID | Segmentid | VARCHAR2 | 20 | PATM_PARTYCONTACTUPLOAD |
| SEQUENCENUMBER | Sequencenumber | NUMBER | 22 | PATM_PARTYCONTACTUPLOAD |
| PROCESSID | Processid | VARCHAR2 | 50 | PATM_PARTYCONTACTUPLOAD |
| BULKCLIENTCODE | Bulkclientcode | VARCHAR2 | 12 | PATM_PARTYCONTACTUPLOAD |
| UPLOADMODE | Uploadmode | VARCHAR2 | 1 | PATM_PARTYCONTACTUPLOAD |
| IMPORTFILENAME | Importfilename | VARCHAR2 | 255 | PATM_PARTYCONTACTUPLOAD |
| PARTYID | Partyid | VARCHAR2 | 12 | PATM_PARTYCONTACTUPLOAD |
| CONTACTREFNO | Contactrefno | VARCHAR2 | 16 | PATM_PARTYCONTACTUPLOAD |
| ADDRESSTYPE | Addresstype | VARCHAR2 | 2 | PATM_PARTYCONTACTUPLOAD |
| ADDRESSLINE1 | Addressline1 | VARCHAR2 | 100 | PATM_PARTYCONTACTUPLOAD |
| ADDRESSLINE2 | Addressline2 | VARCHAR2 | 100 | PATM_PARTYCONTACTUPLOAD |
| ADDRESSLINE3 | Addressline3 | VARCHAR2 | 100 | PATM_PARTYCONTACTUPLOAD |
| POSTBOXNO | Postboxno | VARCHAR2 | 16 | PATM_PARTYCONTACTUPLOAD |
| CITY | City | VARCHAR2 | 80 | PATM_PARTYCONTACTUPLOAD |
| STATE | State | VARCHAR2 | 80 | PATM_PARTYCONTACTUPLOAD |
| COUNTRY | Country | VARCHAR2 | 3 | PATM_PARTYCONTACTUPLOAD |
| ZIPCODE | Zipcode | VARCHAR2 | 10 | PATM_PARTYCONTACTUPLOAD |
| WEBSITE | Website | VARCHAR2 | 100 | PATM_PARTYCONTACTUPLOAD |
| VARCHAR2 | 100 | PATM_PARTYCONTACTUPLOAD | ||
| EFFECTIVEFROMDATE | Effectivefromdate | DATE | 7 | PATM_PARTYCONTACTUPLOAD |
| EFFECTIVETODATE | Effectivetodate | DATE | 7 | PATM_PARTYCONTACTUPLOAD |
| PRIMARYCONTACTPERSON | Primarycontactperson | VARCHAR2 | 100 | PATM_PARTYCONTACTUPLOAD |
| PRIMARYINTERNDIALCODE1 | Primaryinterndialcode1 | VARCHAR2 | 10 | PATM_PARTYCONTACTUPLOAD |
| PRIMARYINTERNDIALCODE2 | Primaryinterndialcode2 | VARCHAR2 | 10 | PATM_PARTYCONTACTUPLOAD |
| PRIMARYINTERNDIALCODE3 | Primaryinterndialcode3 | VARCHAR2 | 10 | PATM_PARTYCONTACTUPLOAD |
| PRIMARYINTERNDIALCODE4 | Primaryinterndialcode4 | VARCHAR2 | 10 | PATM_PARTYCONTACTUPLOAD |
| PRIMARYPOSITION | Primaryposition | VARCHAR2 | 60 | PATM_PARTYCONTACTUPLOAD |
| PRIMARYMOBILENUMBER1 | Primarymobilenumber1 | VARCHAR2 | 60 | PATM_PARTYCONTACTUPLOAD |
| PRIMARYMOBILENUMBER2 | Primarymobilenumber2 | VARCHAR2 | 60 | PATM_PARTYCONTACTUPLOAD |
| PRIMARYFIXEDLINE | Primaryfixedline | VARCHAR2 | 60 | PATM_PARTYCONTACTUPLOAD |
| FAX | Fax | VARCHAR2 | 120 | PATM_PARTYCONTACTUPLOAD |
| PRIMARYCONTACTINSTRN | Primarycontactinstrn | VARCHAR2 | 100 | PATM_PARTYCONTACTUPLOAD |
| PRIMARYEXTN | Primaryextn | VARCHAR2 | 60 | PATM_PARTYCONTACTUPLOAD |
| SECONDARYCONTACTPERSON | Secondarycontactperson | VARCHAR2 | 100 | PATM_PARTYCONTACTUPLOAD |
| SECONDARYINTERNDIALCODE1 | Secondaryinterndialcode1 | VARCHAR2 | 10 | PATM_PARTYCONTACTUPLOAD |
| SECONDARYINTERNDIALCODE2 | Secondaryinterndialcode2 | VARCHAR2 | 10 | PATM_PARTYCONTACTUPLOAD |
| SECONDARYPOSITION | Secondaryposition | VARCHAR2 | 60 | PATM_PARTYCONTACTUPLOAD |
| SECONDARYMOBILENUMBER | Secondarymobilenumber | VARCHAR2 | 60 | PATM_PARTYCONTACTUPLOAD |
| SECONDARYFIXEDLINE | Secondaryfixedline | VARCHAR2 | 60 | PATM_PARTYCONTACTUPLOAD |
| SECONDARYCONTACTINSTRN | Secondarycontactinstrn | VARCHAR2 | 105 | PATM_PARTYCONTACTUPLOAD |
| SECONDARYEXTN | Secondaryextn | VARCHAR2 | 60 | PATM_PARTYCONTACTUPLOAD |
| BICCODE | Biccode | VARCHAR2 | 16 | PATM_PARTYCONTACTUPLOAD |
| SEGMENTID | Segmentid | VARCHAR2 | 20 | PATM_PARTYDIRECTORUPLOAD |
| SEQUENCENUMBER | Sequencenumber | NUMBER | 22 | PATM_PARTYDIRECTORUPLOAD |
| PROCESSID | Processid | VARCHAR2 | 50 | PATM_PARTYDIRECTORUPLOAD |
| BULKCLIENTCODE | Bulkclientcode | VARCHAR2 | 12 | PATM_PARTYDIRECTORUPLOAD |
| UPLOADMODE | Uploadmode | VARCHAR2 | 1 | PATM_PARTYDIRECTORUPLOAD |
| IMPORTFILENAME | Importfilename | VARCHAR2 | 255 | PATM_PARTYDIRECTORUPLOAD |
| PARTYID | Partyid | VARCHAR2 | 12 | PATM_PARTYDIRECTORUPLOAD |
| DIRECTORID | Directorid | VARCHAR2 | 12 | PATM_PARTYDIRECTORUPLOAD |
| PERCENTAGE | Percentage | NUMBER | 5 | PATM_PARTYDIRECTORUPLOAD |
| CONTROLLINGPERSON | Controllingperson | VARCHAR2 | 1 | PATM_PARTYDIRECTORUPLOAD |
| SEGMENTID | Segmentid | VARCHAR2 | 20 | PATM_PARTYBANKUPLOAD |
| SEQUENCENUMBER | Sequencenumber | NUMBER | 22 | PATM_PARTYBANKUPLOAD |
| PROCESSID | Processid | VARCHAR2 | 50 | PATM_PARTYBANKUPLOAD |
| BULKCLIENTCODE | Bulkclientcode | VARCHAR2 | 12 | PATM_PARTYBANKUPLOAD |
| UPLOAD MODE | Uploadmode | VARCHAR2 | 1 | PATM_PARTYBANKUPLOAD |
| IMPORTFILENAME | Importfilename | VARCHAR2 | 255 | PATM_PARTYBANKUPLOAD |
| PARTYID | Partyid | VARCHAR2 | 12 | PATM_PARTYBANKUPLOAD |
| BANKREFERENCENO | Bankreferenceno | VARCHAR2 | 16 | PATM_PARTYBANKUPLOAD |
| OWNERSHIPTYPE | Ownershiptype | VARCHAR2 | 1 | PATM_PARTYBANKUPLOAD |
| ACCOUNTTYPE | Accounttype | VARCHAR2 | 1 | PATM_PARTYBANKUPLOAD |
| ACCOUNTCURRENCY | Accountcurrency | VARCHAR2 | 3 | PATM_PARTYBANKUPLOAD |
| BANKCODE | Bankcode | VARCHAR2 | 12 | PATM_PARTYBANKUPLOAD |
| BRANCHCODE | Branchcode | VARCHAR2 | 12 | PATM_PARTYBANKUPLOAD |
| ACCOUNTNUMBER | Accountnumber | VARCHAR2 | 20 | PATM_PARTYBANKUPLOAD |
| IBAN | Iban | VARCHAR2 | 40 | PATM_PARTYBANKUPLOAD |
| VERIFICATIONSTATUS | Verificationstatus | VARCHAR2 | 1 | PATM_PARTYBANKUPLOAD |
| LASTVERIFIEDDATE | Lastverifieddate | DATE | 7 | PATM_PARTYBANKUPLOAD |
| ACCOUNTHO LDERNAME | Accountholdername | VARCHAR2 | 100 | PATM_PARTYBANKUPLOAD |
| USERREFERENCENUMBER | Userreference number | VARCHAR2 | 16 | PATM_PARTYBANKUPLOAD |
| SEGMENTID | Segmentid | VARCHAR2 | 20 | PATM_PARTYIDENTIFICATIONUPLOAD |
| SEQUENCENUMBER | Sequencenumber | NUMBER | 22 | PATM_PARTYIDENTIFICATIONUPLOAD |
| PROCESSID | Processid | VARCHAR2 | 50 | PATM_PARTYIDENTIFICATIONUPLOAD |
| BULKCLIENTCODE | Bulkclientcode | VARCHAR2 | 12 | PATM_PARTYIDENTIFICATIONUPLOAD |
| UPLOADMODE | Uploadmode | VARCHAR2 | 1 | PATM_PARTYIDENTIFICATIONUPLOAD |
| IMPORTFILENAME | Importfilename | VARCHAR2 | 255 | PATM_PARTYIDENTIFICATIONUPLOAD |
| PARTYID | Partyid | VARCHAR2 | 12 | PATM_PARTYIDENTIFICATIONUPLOAD |
| IDREFERENCENO | Idreferenceno | VARCHAR2 | 16 | PATM_PARTYIDENTIFICATIONUPLOAD |
| USERREFERENCENUMBER | Userreference number | VARCHAR2 | 16 | PATM_PARTYIDENTIFICATIONUPLOAD |
| IDENTIFICATIONTYPE | Identificationtype | VARCHAR2 | 20 | PATM_PARTYIDENTIFICATIONUPLOAD |
| IDENTIFICATIONNUMBER | Identificationnum ber | VARCHAR2 | 50 | PATM_PARTYIDENTIFICATIONUPLOAD |
| PLACEOFISSUE | Placeofissue | VARCHAR2 | 3 | PATM_PARTYIDENTIFICATIONUPLOAD |
| ISSUEAUTHORITY | Issueauthority | VARCHAR2 | 50 | PATM_PARTYIDENTIFICATIONUPLOAD |
| ISSUECOUNTRY | Issuecountry | VARCHAR2 | 3 | PATM_PARTYIDENTIFICATIONUPLOAD |
| DATEOFISSUE | Dateofissue | DATE | 7 | PATM_PARTYIDENTIFICATIONUPLOAD |
| DATEOFEXPIRY | Dateofexpiry | DATE | 7 | PATM_PARTYIDENTIFICATIONUPLOAD |
| LASTVERIFIEDDATE | Lastverifieddate | DATE | 7 | PATM_PARTYIDENTIFICATIONUPLOAD |
| VERIFICATIONSTATUS | Verificationstatus | VARCHAR2 | 1 | PATM_PARTYIDENTIFICATIONUPLOAD |
| SEGMENTID | Segmentid | VARCHAR2 | 20 | PATM_PARTYTAXCOMPLUPLOAD |
| SEQUENCE NUMBER | Sequencenumber | NUMBER | 22 | PATM_PARTYTAXCOMPLUPLOAD |
| PROCESSID | Processid | VARCHAR2 | 50 | PATM_PARTYTAXCOMPLUPLOAD |
| BULKCLIENTCODE | Bulkclientcode | VARCHAR2 | 12 | PATM_PARTYTAXCOMPLUPLOAD |
| UPLOADMODE | Uploadmode | VARCHAR2 | 1 | PATM_PARTYTAXCOMPLUPLOAD |
| IMPORTFILENAME | Importfilename | VARCHAR2 | 255 | PATM_PARTYTAXCOMPLUPLOAD |
| PARTYID | Partyid | VARCHAR2 | 12 | PATM_PARTYTAXCOMPLUPLOAD |
| TAXCOMPLIANCE | Taxcompliance | VARCHAR2 | 10 | PATM_PARTYTAXCOMPLUPLOAD |
| TAXJURISDICTION | Taxjurisdiction | VARCHAR2 | 3 | PATM_PARTYTAXCOMPLUPLOAD |
| INDICIAAVAILABLE | Indiciaavailable | NUMBER | 1 | PATM_PARTYTAXCOMPLUPLOAD |
| REPORTABLESTATUS | Reportablestatus | VARCHAR2 | 1 | PATM_PARTYTAXCOMPLUPLOAD |
| REMARKS | Remarks | VARCHAR2 | 255 | PATM_PARTYTAXCOMPLUPLOAD |
| CRITERIAMATCHED | Criteriamatched | VARCHAR2 | 255 | PATM_PARTYTAXCOMPLUPLOAD |
| SEGMENTID | Segmentid | VARCHAR2 | 20 | PATM_PARTYADDINFOUPLOAD |
| SEQUENCENUMBER | Sequencenumber | NUMBER | 22 | PATM_PARTYADDINFOUPLOAD |
| PROCESSID | Processid | VARCHAR2 | 50 | PATM_PARTYADDINFOUPLOAD |
| BULKCLIENTCODE | Bulkclientcode | VARCHAR2 | 12 | PATM_PARTYADDINFOUPLOAD |
| UPLOADMODE | Uploadmode | VARCHAR2 | 1 | PATM_PARTYADDINFOUPLOAD |
| IMPORTFILENAME | Importfilename | VARCHAR2 | 255 | PATM_PARTYADDINFOUPLOAD |
| PARTYID | Partyid | VARCHAR2 | 16 | PATM_PARTYADDINFOUPLOAD |
| ADDINFOLABEL | Addinfolabel | VARCHAR2 | 30 | PATM_PARTYADDINFOUPLOAD |
| FIELDVALUE | Fieldvalue | CHAR | 23 | PATM_PARTYADDINFOUPLOAD |
Parent topic: Party Main Upload